>
> 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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to