[2.1.214][MariaDB] DELETE query failure #3599
Description
Hello,
The following query works with MODE=MySQL;IGNORECASE=TRUE, but fails with MODE=MariaDB;IGNORECASE=TRUE:
DELETE p FROM unitak p WHERE NOT EXISTS(SELECT r.idpk FROM unitar r WHERE r.domainpk=p.domainpk AND r.idpk=p.unitarfk)Here is the stacktrace:
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "P" not found; SQL statement:
DELETE p FROM unitak p WHERE NOT EXISTS(SELECT r.idpk FROM unitar r WHERE r.domainpk=p.domainpk AND r.idpk=p.unitarfk) [42102-214]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:502)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
at org.h2.message.DbException.get(DbException.java:223)
at org.h2.message.DbException.get(DbException.java:199)
at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8398)
at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8369)
at org.h2.command.Parser.readTableOrView(Parser.java:8358)
at org.h2.command.Parser.readTableOrView(Parser.java:8328)
at org.h2.command.Parser.readSimpleTableFilter(Parser.java:1160)
at org.h2.command.Parser.parseDelete(Parser.java:1174)
at org.h2.command.Parser.parsePrepared(Parser.java:774)
at org.h2.command.Parser.parse(Parser.java:689)
at org.h2.command.Parser.parse(Parser.java:661)
at org.h2.command.Parser.prepareCommand(Parser.java:569)
at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631)
at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:186)
at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:143)
The query works fine on MySQL and MariaDB.
Thanks for the amazing work !