Hello, consider the following table:
CREATE TABLE check_test ( id INTEGER NOT NULL PRIMARY KEY, some_value INTEGER NOT NULL CHECK (some_value > 0) ); After creating it, the check constraint should be available in INFORMATION_SCHEMA.CONSTRAINTS but it isn't select * from information_schema.constraints where constraint_type = 'CHECK' and table_name = 'CHECK_TEST' returns no rows. I tested this with 1.3.162 and 1.3.164 The constraint is enforced though. I'm pretty sure this was working in earlier releases. -- 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.
