You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Yury Gerzhedovich (Jira)" <ji...@apache.org> on 2023/05/03 08:32:00 UTC
[jira] [Updated] (IGNITE-18511) Incomprehensible error when using a reserved word in ddl via jdbc
[ https://issues.apache.org/jira/browse/IGNITE-18511?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yury Gerzhedovich updated IGNITE-18511:
---------------------------------------
Labels: ise (was: calcite3-required ise)
> Incomprehensible error when using a reserved word in ddl via jdbc
> ------------------------------------------------------------------
>
> Key: IGNITE-18511
> URL: https://issues.apache.org/jira/browse/IGNITE-18511
> Project: Ignite
> Issue Type: Improvement
> Affects Versions: 2.14
> Reporter: Luchnikov Alexander
> Assignee: Ilhom Ulmasov
> Priority: Minor
> Labels: ise
> Fix For: 2.15
>
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> When creating a table via sqlline, the column name of which uses a reserved word (in our case, the name is "type") on the calcite engine, we fall with an error due to which the cause cannot be determined.
> When using the h2 engine, the table is created.
> {code:java}
> ./sqlline.sh --verbose=true -u jdbc:ignite:thin://127.0.0.1:10800?queryEngine=calcite
> 0: jdbc:ignite:thin://127.0.0.1:10800> CREATE TABLE test (
> . . . . . . . . . . . . . . . . . . )> id BIGINT,
> . . . . . . . . . . . . . . . . . . )> name VARCHAR,
> . . . . . . . . . . . . . . . . . . )> type VARCHAR,
> . . . . . . . . . . . . . . . . . . )> PRIMARY KEY (id)
> . . . . . . . . . . . . . . . . . . )> );
> Error: Failed to parse query. (state=42000,code=1001)
> java.sql.SQLException: Failed to parse query.
> at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:1010)
> at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:234)
> at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:560)
> at sqlline.Commands.executeSingleQuery(Commands.java:1054)
> at sqlline.Commands.execute(Commands.java:1003)
> at sqlline.Commands.sql(Commands.java:967)
> at sqlline.SqlLine.dispatch(SqlLine.java:734)
> at sqlline.SqlLine.begin(SqlLine.java:541)
> at sqlline.SqlLine.start(SqlLine.java:267)
> at sqlline.SqlLine.main(SqlLine.java:206)
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)