Hello! This issue cannot be resolved on H2 side.
ESCAPE '' is not valid according to the SQL Standard: > If the length in characters of ECV is not equal to 1, then an exception condition is raised: > data exception — invalid escape character. Oracle throws an exception as expected: ORA-01425: escape character must be character string of length 1 H2 allows ESCAPE '' with a special meaning, but this extension is not portable across all compatibility modes, because in Oracle compatibility mode (just like in the real Oracle) an empty character string and NULL aren't distinct from each other and it isn't possible to distinguish them here. This issue was already reported in bugtracker of Hibernate ORM: https://hibernate.atlassian.net/browse/HHH-16277 It was closed as a duplicate of another issue, but I think it isn't a duplicate and should be re-opened. -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/562bdf13-b6a9-4a76-92bd-134b6d3e7377n%40googlegroups.com.
