[ https://issues.apache.org/jira/browse/IGNITE-15647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17435102#comment-17435102 ]
Ignite TC Bot commented on IGNITE-15647: ---------------------------------------- {panel:title=Branch: [pull/9536/head] Base: [master] : Possible Blockers (8)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1} {color:#d04437}Platform .NET (Windows){color} [[tests 1 Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=6243286]] * exe: CacheTest.TestCacheWithExpiryPolicyOnUpdate - Test has low fail rate in base branch 1,2% and is not flaky {color:#d04437}Platform C++ CMake (Win x64 / Release){color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=6243279]] * IgniteThinClientTest: CacheClientTestSuite: CacheClientRemoveAll - Test has low fail rate in base branch 0,0% and is not flaky {color:#d04437}ZooKeeper (Discovery) 1{color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=6243226]] * ZookeeperDiscoverySpiTestSuite1: ZookeeperDiscoveryMiscTest.testSetConsistentId - Test has low fail rate in base branch 0,0% and is not flaky {color:#d04437}Cache 5{color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=6243248]] * IgniteCacheTestSuite5: GridExchangeFreeCellularSwitchTxContinuationTest.testAlreadyStartedTxsContinuationDuringAndAfterTheSwitch[Isolation = PESSIMISTIC, Concurrency = READ_COMMITTED, Started from = BROKEN_CELL] - Test has low fail rate in base branch 0,0% and is not flaky {color:#d04437}Control Utility{color} [[tests 0 TIMEOUT , Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=6243277]] {color:#d04437}Java Client{color} [[tests 0 TIMEOUT , Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=6243208]] {color:#d04437}ZooKeeper (Discovery) 2{color} [[tests 1|https://ci.ignite.apache.org/viewLog.html?buildId=6243227]] * ZookeeperDiscoverySpiTestSuite2: GridCachePartitionedNodeRestartTest.testRestartWithTxPutAllTenNodesTwoBackups - Test has low fail rate in base branch 0,0% and is not flaky {panel} {panel:title=Branch: [pull/9536/head] Base: [master] : No new tests found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}{panel} [TeamCity *--> Run :: All* Results|https://ci.ignite.apache.org/viewLog.html?buildId=6243287&buildTypeId=IgniteTests24Java8_RunAll] > -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 > Assignee: Ilya Kasnacheev > Priority: Critical > Fix For: 2.12 > > Time Spent: 20m > Remaining Estimate: 0h > > 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)