Version: h2-1.4.196

ALTER TABLE "table-name" MODIFY "columne-name" NOT NULL; fails with Unknown 
data type: "NOT"; 
- - -
I kowticed that h2 started to support the "ALTER TABLE - MODIFY"-SQL syntax 
(used in Oracle) since ca. Version: h2-1.4.19x.
In the older version h2-1.4.192 it failed when trying to alter to NULL 
(e.g: ALTER TABLE "table-name" MODIFY "columne-name" NULL).
This seames to have been fixed when using the latest version: h2-1.4.196.

But what still is failing is the "*NOT* NULL" case: "ALTER TABLE 
"table-name" MODIFY "columne-name" NOT NULL"
fails with the error mentioned above.

Would be very helpfull if this missing feature could be added.

Regards Sam 

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to