On Mar 21, 8:28 pm, Thomas Mueller <[email protected]> wrote: > Hi, > > I will add a feature request: "TRUNCATE should reset the identity > columns as in MySQL and MS SQL Server (and possibly other databases)."
Hi, there's (at least) one more thing working differently in MySql: With DROP ALL OBJECTS; CREATE TABLE t (a INT); CREATE PRIMARY KEY ON t (a); you get "COLUMN_MUST_NOT_BE_NULLABLE_1 = 90023" while MySql just silently adds NOT NULL. Disclaimer: I don't care about it at all, just stumbled upon it. -- 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.
