You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Andrey Gura (JIRA)" <ji...@apache.org> on 2018/04/18 13:00:02 UTC
[jira] [Updated] (IGNITE-7666) "Failed to parse query exception"
has no description to find error in query
[ https://issues.apache.org/jira/browse/IGNITE-7666?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrey Gura updated IGNITE-7666:
--------------------------------
Fix Version/s: (was: 2.5)
2.6
> "Failed to parse query exception" has no description to find error in query
> ---------------------------------------------------------------------------
>
> Key: IGNITE-7666
> URL: https://issues.apache.org/jira/browse/IGNITE-7666
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.3
> Reporter: Mikhail Cherkasov
> Priority: Blocker
> Fix For: 2.6
>
>
> In the query below there are wrong quote characters around alias name(it requires no quotes or double quotes), but the exception has no clue to find the error in query. This query is simple and it wouldn't take a lot of time to find the error to users, but it becomes almost impossible to find the error in real life big and complex queries:
> {noformat}
> 0: jdbc:ignite:thin://127.0.0.1/> SELECT Name as 'super_name' from person p where p.name = 'test';
> Error: Failed to parse query: SELECT Name as 'super_name' from person p where p.name = 'test' (state=42000,code=0)
> java.sql.SQLException: Failed to parse query: SELECT Name as 'super_name' from person p where p.name = 'test'
> at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:671)
> at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:130)
> at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:299)
> at sqlline.Commands.execute(Commands.java:823)
> at sqlline.Commands.sql(Commands.java:733)
> at sqlline.SqlLine.dispatch(SqlLine.java:795)
> at sqlline.SqlLine.begin(SqlLine.java:668)
> at sqlline.SqlLine.start(SqlLine.java:373)
> at sqlline.SqlLine.main(SqlLine.java:265){noformat}
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)