Hi, I wouldn't say allowing NULL assignments to NOT NULL columns and silently replacing them by empty strings or 0 values is being tolerant, it's just being as noncompliant and braindead as MySQL.
If it's made possible in the engine then please make it a separate switch. Bye, Florent On Dec 16, 6:25 pm, Max <[email protected]> wrote: > I would like H2 be more MySQL compatible. > > I wish H2 to support "REPLACE" query instead of MERGE > > and following syntax > INSERT INTO table SET column1 = value1, column2 = value2 > > I wish H2 to to be more tolerant to syntax. > H2 fires errors when I assign NULL to NOT NULL > It should make strings blank and numbers 0 > > Is there a simple way to do that? > > Could you advise where should I look in source code If it is required > to modify source code ? > > Cheers, > Max --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
