Hi Thomas, Thanks for the quick response. Actually I am delighted to see the compatibility mode in H2. As i moved into MySQL all my testcases failed as it was using HSQL, now with some tweaking i can have my testcases and MySQL queries in sync to a certain extend.
Thanks for giving us H2. Regards chungonn On Sun, Apr 10, 2011 at 4:59 AM, Thomas Mueller < [email protected]> wrote: > Hi, > > > I found out that regexp when use in H2 mysql compatibility mode is > > case sensitive whereas it is not in mysql. Is this the expected > > behavior? > > Yes, it is expected. H2 is not 100% compatible to all other databases > - if it would, then it would be 100 times larger I guess. H2 just > tries to be compatible where possible and where it makes sense. > > > I also realize that H2 mysql mode does not recognize the > > RLIKE token is this also an expected behaviour? > > Yes it is expected. > > Regards, > Thomas > > -- > 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. > > -- 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.
