You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Alexey Popov (JIRA)" <ji...@apache.org> on 2018/02/01 08:25:00 UTC
[jira] [Commented] (IGNITE-7598) SQL: INSERT requires you to
specify the column names even if you are adding values for all the columns
of the table
[ https://issues.apache.org/jira/browse/IGNITE-7598?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16348182#comment-16348182 ]
Alexey Popov commented on IGNITE-7598:
--------------------------------------
Please have a look at https://issues.apache.org/jira/browse/IGNITE-6111
> SQL: INSERT requires you to specify the column names even if you are adding values for all the columns of the table
> -------------------------------------------------------------------------------------------------------------------
>
> Key: IGNITE-7598
> URL: https://issues.apache.org/jira/browse/IGNITE-7598
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Roman Shtykh
> Priority: Major
>
> Checked via JDBC thin.
> {noformat}
> Caused by: org.h2.jdbc.JdbcSQLException: Column count does not match; SQL statement:
> INSERT INTO MYTABLE VALUES (?,?,?,?,?,?,?,?,?,?,?) [21002-195]
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
> 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.Insert.prepare(Insert.java:265){noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)