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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
