You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/09/10 03:40:29 UTC
[GitHub] [shardingsphere] zhangboqing opened a new issue #7372: ShardingSphere-JDBC : line 1:154 no viable alternative at input '->'
zhangboqing opened a new issue #7372:
URL: https://github.com/apache/shardingsphere/issues/7372
## Bug Report
### Which version of ShardingSphere did you use?
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-core</artifactId>
<version>4.1.1</version>
</dependency>
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
have not log this error
### Actual behavior
1、Only the error log was printed on the console
2、The SQL can execute correctly
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
SELECT count(0) FROM op_producer_hotting_task WHERE create_time BETWEEN ? AND ? AND app_id = ? AND source IN (?, ?, ?, ?) AND status IN (?) AND data_json->'$.crowdPackageId' IS NOT NULL
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuohai666 commented on issue #7372: ShardingSphere-JDBC : line 1:154 no viable alternative at input '->'
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #7372:
URL: https://github.com/apache/shardingsphere/issues/7372#issuecomment-690038999
@jingshanglu Can you help to check it?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] zhangboqing commented on issue #7372: ShardingSphere-JDBC : line 1:154 no viable alternative at input '->'
Posted by GitBox <gi...@apache.org>.
zhangboqing commented on issue #7372:
URL: https://github.com/apache/shardingsphere/issues/7372#issuecomment-690008985
> @zhangboqing
>
> > 1、Only the error log was printed on the console
>
> what printed on the console in detail?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuohai666 commented on issue #7372: ShardingSphere-JDBC : line 1:154 no viable alternative at input '->'
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #7372:
URL: https://github.com/apache/shardingsphere/issues/7372#issuecomment-689961200
@zhangboqing
> 1、Only the error log was printed on the console
what printed on the console in detail?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] zhangboqing removed a comment on issue #7372: ShardingSphere-JDBC : line 1:154 no viable alternative at input '->'
Posted by GitBox <gi...@apache.org>.
zhangboqing removed a comment on issue #7372:
URL: https://github.com/apache/shardingsphere/issues/7372#issuecomment-690008985
> @zhangboqing
>
> > 1、Only the error log was printed on the console
>
> what printed on the console in detail?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jingshanglu commented on issue #7372: ShardingSphere-JDBC : line 1:154 no viable alternative at input '->'
Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #7372:
URL: https://github.com/apache/shardingsphere/issues/7372#issuecomment-690117851
@tuohai666 Ok, new version will fix it.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero closed issue #7372: ShardingSphere-JDBC : line 1:154 no viable alternative at input '->'
Posted by GitBox <gi...@apache.org>.
tristaZero closed issue #7372:
URL: https://github.com/apache/shardingsphere/issues/7372
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] zhangboqing closed issue #7372: ShardingSphere-JDBC : line 1:154 no viable alternative at input '->'
Posted by GitBox <gi...@apache.org>.
zhangboqing closed issue #7372:
URL: https://github.com/apache/shardingsphere/issues/7372
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] zhangboqing commented on issue #7372: ShardingSphere-JDBC : line 1:154 no viable alternative at input '->'
Posted by GitBox <gi...@apache.org>.
zhangboqing commented on issue #7372:
URL: https://github.com/apache/shardingsphere/issues/7372#issuecomment-690012363
> @zhangboqing
>
> > 1、Only the error log was printed on the console
>
> what printed on the console in detail?
There is no other information；
I debug locally ，find the location of the log info：
`org.antlr.v4.runtime.atn.ParserATNSimulator.noViableAlt(ParserATNSimulator.java:2026)
org.antlr.v4.runtime.atn.ParserATNSimulator.execATN(ParserATNSimulator.java:467)
org.antlr.v4.runtime.atn.ParserATNSimulator.adaptivePredict(ParserATNSimulator.java:393)
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.bitExpr(MySQLStatementParser.java:11951)
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.predicate(MySQLStatementParser.java:11869)
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.booleanPrimary(MySQLStatementParser.java:11486)
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.expr(MySQLStatementParser.java:11285)
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.expr(MySQLStatementParser.java:11310)
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.whereClause(MySQLStatementParser.java:6995)
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.selectClause(MySQLStatementParser.java:4600)
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.unionClause(MySQLStatementParser.java:4459)
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.select(MySQLStatementParser.java:3121)
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.execute(MySQLStatementParser.java:769)
org.apache.shardingsphere.sql.parser.mysql.parser.MySQLParser.parse(MySQLParser.java:37)
org.apache.shardingsphere.sql.parser.core.parser.SQLParserExecutor.towPhaseParse(SQLParserExecutor.java:59)
org.apache.shardingsphere.sql.parser.core.parser.SQLParserExecutor.execute(SQLParserExecutor.java:47)
org.apache.shardingsphere.sql.parser.SQLParserEngine.parse0(SQLParserEngine.java:79)`
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] jingshanglu edited a comment on issue #7372: ShardingSphere-JDBC : line 1:154 no viable alternative at input '->'
Posted by GitBox <gi...@apache.org>.
jingshanglu edited a comment on issue #7372:
URL: https://github.com/apache/shardingsphere/issues/7372#issuecomment-690117851
@tuohai666 @zhangboqing Ok, new version will fix it.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuohai666 commented on issue #7372: ShardingSphere-JDBC : line 1:154 no viable alternative at input '->'
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #7372:
URL: https://github.com/apache/shardingsphere/issues/7372#issuecomment-690033997
@zhangboqing After a serial of analysis, I found you fill reversely in Expected behavior and Actual behavior. Accordingly I guess you click reversely between the button Close and Comment.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org