Failed to change "not null" option on a column on version 1.4.199

[nzanaga]

Hi, with driver version "1.4.199" query to alter column to modify not null options fails.

Using versione "1.4.197" this works fine.

Query:

CREATE TABLE test1 (
    a integer
)


ALTER TABLE test1 ALTER COLUMN a SET DATA TYPE  INTEGER  NOT NULL

[Evgenij Ryazanov]

Hello.

Your command is definitely not valid. Where did you find it? We don't have such syntax in the documentation. It was accepted due to bug.

Use

ALTER TABLE tableName ALTER COLUMN columnName SET NOT NULL

instead.

The SET DATA TYPE clause may be used only to change the data type of the column, it is officially supported since 1.4.198.