There is something wrong with behavoir.. Example: CREATE TABLE FOO(c1 int null,c2 int default 1 not null)
Executing SQLlike this: INSERT INTO BAR SET c1 = 1, c2 = COALESCE(null,DEFAULT) Results in: Column "DEFAULT" not found; SQL statement: INSERT INTO BAR SET c1 = 1, c2 = COALESCE(null,DEFAULT) [42122-161] 42S22/42122 At the same time: INSERT INTO BAR (c1,c2) values (1, DEFAULT) Ok! But(!!!), "INSERT INTO BAR SET c1 = 1, c2 = DEFAULT" Result: NULL not allowed for column "C2"; SQL statement: INSERT INTO BAR SET c1 = 1, c2 = DEFAULT [23502-161] 23502/23502 I think it is a bug. If it is not, is any way to specify use of default value exists? H2 1.3.161 (2011-10-28) -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
