Taras Ledkov created IGNITE-11444:
-------------------------------------
Summary: SQL: MERGE USING throws unclear exception
Key: IGNITE-11444
URL: https://issues.apache.org/jira/browse/IGNITE-11444
Project: Ignite
Issue Type: Task
Components: sql
Affects Versions: 2.7
Reporter: Taras Ledkov
Assignee: Taras Ledkov
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.
{code}
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)
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
