arun-prasat edited a comment 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 the maven
repository but still getting the exception for the same query,(I searched for
**5.0.0-alpha** which was not available for sharding-jdbc-spring-boot-starter)
version -- **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:
[email protected]
