While using H2 as a replacement for Oracle in test, I have come across this
problem.
Searching the group I have found nothing that indicates this is a know
issue. If it is, please can someone help me find the relevant thread.
I have added a test to TestCompatibilityOracle, that I believe shows the
problem:
stat.execute("CREATE TABLE F (ID NUMBER, X VARCHAR2(1))");
stat.execute("INSERT INTO F VALUES (1, 'a')");
PreparedStatement preparedStatement = conn.prepareStatement("INSERT
INTO F VALUES (2, ?)");
preparedStatement.setString(1, "");
preparedStatement.execute();
assertResult("2", stat, "SELECT COUNT(*) FROM F");
assertResult("1", stat, "SELECT COUNT(*) FROM F WHERE X IS NULL");
assertResult("0", stat, "SELECT COUNT(*) FROM F WHERE X = ''");
assertResult(new Object[][]{{1, "a"}, {2, null}}, stat, "SELECT *
FROM F");
In the setString method JdbcPreparedStatement, ValueString.get(x) is called
without the flag. But getting the mode in there in an elegant way seems
hard to me.
Dose anyone have any suggestions on how to fix this?
Cheers,
Peter
--
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/d/optout.
