[ https://issues.apache.org/jira/browse/IGNITE-11444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Taras Ledkov reassigned IGNITE-11444: ------------------------------------- Assignee: (was: Taras Ledkov) > SQL: MERGE USING must throw clear exception with UNSUPPORTED error code > ----------------------------------------------------------------------- > > Key: IGNITE-11444 > URL: https://issues.apache.org/jira/browse/IGNITE-11444 > Project: Ignite > Issue Type: Improvement > Components: sql > Affects Versions: 2.7 > Reporter: Taras Ledkov > Priority: Major > > 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)