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)
