You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Nikolay Izhikov (Jira)" <ji...@apache.org> on 2019/10/01 03:10:00 UTC
[jira] [Updated] (IGNITE-11444) SQL: MERGE USING must throw clear
exception with UNSUPPORTED error code
[ https://issues.apache.org/jira/browse/IGNITE-11444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Nikolay Izhikov updated IGNITE-11444:
-------------------------------------
Labels: h2-limitation (was: )
> 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
> Labels: h2-limitation
>
> 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
(v8.3.4#803005)