But H2 has MySQL compatibility mode. Why it is not Ok for H2 to support such queries in MySQL compatibility mode. Otherwise what is sense in MySQL compatibility mode if MySQL code does not work in that mode?
I do not say it should be supported in standard mode. Cheers On Dec 16, 7:49 pm, Florent Guillaume <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
