[jira] [Updated] (IGNITE-7666) "Failed to parse query exception" has no description to find error in query

2018-09-23 Thread Vladimir Ozerov (JIRA) 


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

Vladimir Ozerov updated IGNITE-7666:

Fix Version/s: (was: 2.7)

> "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: Major
>
> 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)

[jira] [Updated] (IGNITE-7666) "Failed to parse query exception" has no description to find error in query

2018-06-26 Thread Dmitriy Pavlov (JIRA) 


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

Dmitriy Pavlov updated IGNITE-7666:
---
Fix Version/s: (was: 2.6)
   2.7

> "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: Major
> Fix For: 2.7
>
>
> 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)

[jira] [Updated] (IGNITE-7666) "Failed to parse query exception" has no description to find error in query

2018-04-18 Thread Andrey Gura (JIRA) 

 [ 
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)

[jira] [Updated] (IGNITE-7666) "Failed to parse query exception" has no description to find error in query

2018-04-18 Thread Andrey Gura (JIRA) 

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

Andrey Gura updated IGNITE-7666:

Priority: Major  (was: Blocker)

> "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: Major
> 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)

[jira] [Updated] (IGNITE-7666) "Failed to parse query exception" has no description to find error in query

2018-02-09 Thread Mikhail Cherkasov (JIRA) 

 [ 
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)

[jira] [Updated] (IGNITE-7666) "Failed to parse query exception" has no description to find error in query

2018-02-09 Thread Mikhail Cherkasov (JIRA) 

 [ 
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 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}
 

  was:
In the query below there are wrong quote characters around alias name(it 
requires no quotes or double quotes), but 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 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}
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (IGNITE-7666) "Failed to parse query exception" has no description to find error in query

2018-02-09 Thread Mikhail Cherkasov (JIRA) 

 [ 
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 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}
 

  was:
As an example, in the query below there are wrong quote characters around alias 
name(it requires no quotes or double quotes), but 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 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}
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)