[IGNITE-11444] SQL: MERGE USING must throw clear exception with UNSUPPORTED error code

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.7
• Component/s: sql
• Labels: h2-limitation
• Ignite Flags: Docs Required
• Assignee: Unassigned
• Reporter: Taras Ledkov
• Created: 28/Feb/19 09:56
• Updated: 01/Oct/19 03:09

Description

The unsupported SQL statement MERGE USING throws unclear exception because H2 uses internal ROWID column at MERGE USING implementation. Ignite tables doesn't contain ROWID column.

Caused by: org.h2.jdbc.JdbcSQLException: Column count does not match; SQL statement:
SELECT _ROWID_ FROM PARENT AS P WHERE (((P.ID = S.ID)
    AND (1 = 1))
    AND (S.ID = P.ID)) [21002-197]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
	at org.h2.message.DbException.get(DbException.java:179)
	at org.h2.message.DbException.get(DbException.java:155)
	at org.h2.message.DbException.get(DbException.java:144)
	at org.h2.command.dml.MergeUsing.prepare(MergeUsing.java:403)
	at org.h2.command.Parser.prepareCommand(Parser.java:283)
	at org.h2.engine.Session.prepareLocal(Session.java:611)
	at org.h2.engine.Session.prepareCommand(Session.java:549)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247)
	at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:76)
	at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:694)
	at org.apache.ignite.internal.processors.query.h2.ConnectionManager.prepareStatementNoCache(ConnectionManager.java:363)
	at org.apache.ignite.internal.processors.query.h2.QueryParser.parseH2(QueryParser.java:264)

Issue Links

• is a child of: IGNITE-11472 SQL: throw sane exception for unsupported features
• relates to: IGNITE-7664 SQL: throw sane exception on unsupported SQL statements