Hi,
Sorry I don't understand. What is the problem exactly? Where is the
behavior of H2 different from Oracle?
Regards,
Thomas
On Monday, May 4, 2015, Peter Fich <peterf...@gmail.com> wrote:
> 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 h2-database+unsubscr...@googlegroups.com
> <javascript:_e(%7B%7D,'cvml','h2-database%2bunsubscr...@googlegroups.com');>
> .
> To post to this group, send email to h2-database@googlegroups.com
> <javascript:_e(%7B%7D,'cvml','h2-database@googlegroups.com');>.
> Visit this group at http://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/d/optout.
>
--
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/d/optout.
