Did you create table work in ParAccel 4 ? Does it have a 1 at the end in c1 varchar(25)  NULL 1 ??

ParAcccel does not have the same syntax as PostgreSQL for defaults. I will look into ParAccel 4 and let you know. FOr e.g only postgresql supports this -> ALTER TABLE "public"."test_default" ALTER "c1" SET DEFAULT 10 

By mistake i have copied wrong syntax,actual syntax for default value in table is

I think we should not allow user to Alter default if it is not supported. The field should be disabled. Once I get the ParAccel 4 documentation will confirm if there is any new SQL syntax for Alter Table...

I have gone through documentation for Alter Functionality and it does not allow us to ALTER

Default Value.
Data type for column.
Change Precision and Scale value.
Change Value from Null to Not null and vice versa.
Add a column which have contains Encryption,Distribution Key,Sort Key Order

Ivan, when a user alters a table in ParAccel, can you disable the following fields, so that it is not confusing to the user.

Default Value should be disabled.
Change Precision and Scale value. (in case of decimal etc...) should be disabled
Add a column - Encryption,Distribution Key,Sort Key Order should be disabled

Implemented the following

- Default Value should be disabled.

- Change Precision and Scale value. (in case of decimal etc...) should be disabled

- Add a column - Encryption,Distribution Key,Sort Key Order should be disabled

Verified for ParAccel in 14.0.0-beta-73

Verified for ParAccel in 14.0.0-beta-74.