[jira] [Created] (IGNITE-15647) -e parameter of sqlline command does not work properly

["Anton Kondratev (Jira)" <ji...@apache.org>]

Anton Kondratev created IGNITE-15647:
----------------------------------------

             Summary: -e parameter of sqlline command does not work properly
                 Key: IGNITE-15647
                 URL: https://issues.apache.org/jira/browse/IGNITE-15647
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 2.10
         Environment: CentOS7.8.2003
            Reporter: Anton Kondratev


SQL query specified in -e parameter of sqlline command does not get parsed properly and therefore not executed.

I'm trying to use it like this:
{code:java}
./sqlline.sh -u jdbc:ignite:thin://1.2.3.4 -n login -p password -e 'select * from \"sys\".\"tables\";'{code}
and output is:
{code:java}
Property "url" is required
Property "url" is required
Property "url" is required
Property "url" is required
Property "url" is required
Property "url" is required
Property "url" is required
Property "url" is required
include (Is a directory)
Property "url" is required
Property "url" is required
from (No such file or directory)
\"sys\".\"tables\"; (No such file or directory)
Error: Failed to parse query. Syntax error in SQL statement "SELECT [*]"; expected "TOP, LIMIT, DISTINCT, ALL, *, NOT, EXISTS, INTERSECTS"; SQL statement:
select [42001-197] (state=42000,code=1001)
java.sql.SQLException: Failed to parse query. Syntax error in SQL statement "SELECT [*]"; expected "TOP, LIMIT, DISTINCT, ALL, *, NOT, EXISTS, INTERSECTS"; SQL statement:
select [42001-197]
 at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:1009)
 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.initArgs(SqlLine.java:449)
 at sqlline.SqlLine.begin(SqlLine.java:515)
 at sqlline.SqlLine.start(SqlLine.java:267)
 at sqlline.SqlLine.main(SqlLine.java:206)
sqlline version 1.9.0{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)