Hi, This feature was added in version 1.3.175. You are using 1.3.174, where it is not yet available.
See also http://www.h2database.com/html/changelog.html "Issue 522: Treat empty strings like NULL in Oracle compatibility mode, patch by Daniel Gredler." Regards, Thomas On Sat, Feb 15, 2014 at 3:51 PM, Mike Cobo <[email protected]> wrote: > Hi Thomas, > > > The documentation says that for Oracle compatibility mode: > > - Empty strings are treated like NULL values. > > But in the following cases an empty string in Oracle compatibility mode > seems not to be treated like NULL. > > The following query in Oracle DB returns true, whereas in H2 with > MODE=Oracle doesn't: > SELECT true AS result WHERE '' IS NULL; > > And the following query in Oracle DB returns nothing (empty result set), > whereas in H2 with MODE=Oracle returns true: > SELECT true AS result WHERE '' = ''; > > The same behaviour appears when reading the values from a table. > And when inserting an empty string in H2 with MODE=Oracle it is not > converted to NULL whereas in Oracle DB NULL is stored and not an empty > string. > The statements where executed on H2 1.3.174 (2013-10-19) > > Do I need do set any other parameter for the compatibility mode to work > correctly or is it simply not working yet? > > Regards, > Mike > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
