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 2021/05/08 07:20:06 UTC
[GitHub] [shardingsphere] arun-prasat commented on issue #10263: getting org.antlr.v4.runtime.tree.ErrorNodeImpl cannot be cast to org.antlr.v4.runtime.ParserRuleContext
arun-prasat commented on issue #10263:
URL: https://github.com/apache/shardingsphere/issues/10263#issuecomment-835167015
I tried with the below version which is the latest one found in maven repository but still getting the exception for the same query,(I searched for 5.0.0-alpha which is not available for sharding-jdbc-spring-boot-starter)
implementation group: 'org.apache.shardingsphere', name: 'sharding-jdbc-spring-boot-starter', version: '4.1.1'
Exception :
line 1:53 no viable alternative at input '(lower'
line 1:53 no viable alternative at input '(lower'
ine 1:122 extraneous input 'lower' expecting {'!', '~', '+', '-', '.', '(', '{', '?', '@', POSITION, CASE, CAST, TRIM, SUBSTRING, IF, NOT, NULL, TRUE, FALSE, EXISTS, INTERVAL, DATE, TIME, TIMESTAMP, LOCALTIME, LOCALTIMESTAMP, MAX, MIN, SUM, COUNT, AVG, LOCAL, NAME, TYPE, ADA, C92, CATALOG_NAME, CHARACTER_SET_CATALOG, CHARACTER_SET_NAME, CHARACTER_SET_SCHEMA, CLASS_ORIGIN, COBOL, COLLATION_CATALOG, COLLATION_NAME, COLLATION_SCHEMA, COLUMN_NAME, COMMAND_FUNCTION, COMMITTED, CONDITION_NUMBER, CONNECTION_NAME, CONSTRAINT_CATALOG, CONSTRAINT_NAME, CONSTRAINT_SCHEMA, CURSOR_NAME, DATA, DATETIME_INTERVAL_CODE, DATETIME_INTERVAL_PRECISION, DYNAMIC_FUNCTION, FORTRAN, LENGTH, MESSAGE_LENGTH, MESSAGE_OCTET_LENGTH, MESSAGE_TEXT, MORE92, MUMPS, NULLABLE, NUMBER, PASCAL, PLI, REPEATABLE, RETURNED_LENGTH, RETURNED_OCTET_LENGTH, RETURNED_SQLSTATE, ROW_COUNT, SCALE, SCHEMA_NAME, SERIALIZABLE, SERVER_NAME, SUBCLASS_ORIGIN, TABLE_NAME, UNCOMMITTED, UNNAMED, CONVERT, CURRENT_TIMESTAMP, EXTRACT, GLOBA
L, IDENTIFIER_, STRING_, NUMBER_, HEX_DIGIT_, BIT_NUM_}
line 1:145 no viable alternative at input '(arrayElement(b.ep.'
java.lang.IndexOutOfBoundsException: Index: 0
at java.util.Collections$EmptyList.get(Collections.java:4456)
at org.apache.shardingsphere.sql.parser.sql92.visitor.SQL92Visitor.visitExpr(SQL92Visitor.java:237)
at org.apache.shardingsphere.sql.parser.sql92.visitor.SQL92Visitor.visitExpr(SQL92Visitor.java:108)
at org.apache.shardingsphere.sql.parser.autogen.SQL92StatementParser$ExprContext.accept(SQL92StatementParser.java:4227)
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.shardingsphere.sql.parser.sql92.visitor.SQL92Visitor.visitExpr(SQL92Visitor.java:234)
at org.apache.shardingsphere.sql.parser.sql92.visitor.SQL92Visitor.visitExpr(SQL92Visitor.java:108)
at org.apache.shardingsphere.sql.parser.autogen.SQL92StatementParser$ExprContext.accept(SQL92StatementParser.java:4227)
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.shardingsphere.sql.parser.sql92.visitor.SQL92Visitor.visitExpr(SQL92Visitor.java:234)
at org.apache.shardingsphere.sql.parser.sql92.visitor.SQL92Visitor.visitExpr(SQL92Visitor.java:108)
at org.apache.shardingsphere.sql.parser.autogen.SQL92StatementParser$ExprContext.accept(SQL92StatementParser.java:4227)
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.shardingsphere.sql.parser.sql92.visitor.impl.SQL92DMLVisitor.visitWhereClause(SQL92DMLVisitor.java:447)
at org.apache.shardingsphere.sql.parser.sql92.visitor.impl.SQL92DMLVisitor.visitWhereClause(SQL92DMLVisitor.java:102)
at org.apache.shardingsphere.sql.parser.autogen.SQL92StatementParser$WhereClauseContext.accept(SQL92StatementParser.java:2562)
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.shardingsphere.sql.parser.sql92.visitor.impl.SQL92DMLVisitor.visitSelectClause(SQL92DMLVisitor.java:235)
at org.apache.shardingsphere.sql.parser.sql92.visitor.impl.SQL92DMLVisitor.visitSelectClause(SQL92DMLVisitor.java:102)
at org.apache.shardingsphere.sql.parser.autogen.SQL92StatementParser$SelectClauseContext.accept(SQL92StatementParser.java:1323)
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.shardingsphere.sql.parser.sql92.visitor.impl.SQL92DMLVisitor.visitUnionClause(SQL92DMLVisitor.java:217)
at org.apache.shardingsphere.sql.parser.sql92.visitor.impl.SQL92DMLVisitor.visitUnionClause(SQL92DMLVisitor.java:102)
at org.apache.shardingsphere.sql.parser.autogen.SQL92StatementParser$UnionClauseContext.accept(SQL92StatementParser.java:1235)
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.shardingsphere.sql.parser.sql92.visitor.impl.SQL92DMLVisitor.visitSelect(SQL92DMLVisitor.java:209)
at org.apache.shardingsphere.sql.parser.sql92.visitor.impl.SQL92DMLVisitor.visitSelect(SQL92DMLVisitor.java:102)
at org.apache.shardingsphere.sql.parser.autogen.SQL92StatementParser$SelectContext.accept(SQL92StatementParser.java:1188)
at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.shardingsphere.sql.parser.SQLParserEngine.parse0(SQLParserEngine.java:80)
at org.apache.shardingsphere.sql.parser.SQLParserEngine.parse(SQLParserEngine.java:61)
at org.apache.shardingsphere.underlying.route.DataNodeRouter.createRouteContext(DataNodeRouter.java:97)
at org.apache.shardingsphere.underlying.route.DataNodeRouter.executeRoute(DataNodeRouter.java:89)
at org.apache.shardingsphere.underlying.route.DataNodeRouter.route(DataNodeRouter.java:76)
at org.apache.shardingsphere.underlying.pluggble.prepare.PreparedQueryPrepareEngine.route(PreparedQueryPrepareEngine.java:54)
at org.apache.shardingsphere.underlying.pluggble.prepare.BasePrepareEngine.executeRoute(BasePrepareEngine.java:96)
at org.apache.shardingsphere.underlying.pluggble.prepare.BasePrepareEngine.prepare(BasePrepareEngine.java:83)
at org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.prepare(ShardingPreparedStatement.java:183)
at org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.executeQuery(ShardingPreparedStatement.java:116)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
at org.hibernate.loader.Loader.getResultSet(Loader.java:2292)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2050)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2012)
at org.hibernate.loader.Loader.doQuery(Loader.java:953)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354)
at org.hibernate.loader.Loader.doList(Loader.java:2815)
at org.hibernate.loader.Loader.doList(Loader.java:2797)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2629)
at org.hibernate.loader.Loader.list(Loader.java:2624)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:338)
at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:2123)
at org.hibernate.internal.AbstractSharedSessionContract.list(AbstractSharedSessionContract.java:1134)
at org.hibernate.query.internal.NativeQueryImpl.doList(NativeQueryImpl.java:173)
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1526)
at org.hibernate.query.Query.getResultList(Query.java:165)
--
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