[ 
https://issues.apache.org/jira/browse/IGNITE-7666?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mikhail Cherkasov updated IGNITE-7666:
--------------------------------------
    Description: 
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}
 

  was:
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 the error easy to find, but it becomes 
almost impossible to find the error in real life 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}
 


> "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.5
>
>
> 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)

Reply via email to