xsong123 opened a new issue, #15647:
URL: https://github.com/apache/shardingsphere/issues/15647

   shardingsphere version 5.0.0
   Oracle version 11c
   
   sql as below:
   1.create index INDEX_ASSETINT2_ASSETCODE on asset_schedule (ASSETCODE)
   2.create table name(...)
   and so on.
   
   error:
   Caused by: 
org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have an 
error in your SQL syntax
        at 
org.apache.shardingsphere.sql.parser.core.database.parser.SQLParserExecutor.twoPhaseParse(SQLParserExecutor.java:68)
 ~[shardingsphere-sql-parser-engine-5.0.0.jar:5.0.0]
        at 
org.apache.shardingsphere.sql.parser.core.database.parser.SQLParserExecutor.parse(SQLParserExecutor.java:49)
 ~[shardingsphere-sql-parser-engine-5.0.0.jar:5.0.0]
        at 
org.apache.shardingsphere.sql.parser.api.SQLParserEngine.parse(SQLParserEngine.java:51)
 ~[shardingsphere-sql-parser-engine-5.0.0.jar:5.0.0]
        at 
org.apache.shardingsphere.infra.parser.sql.SQLStatementParserExecutor.parse(SQLStatementParserExecutor.java:47)
 ~[shardingsphere-infra-parser-5.0.0.jar:5.0.0]
        at 
org.apache.shardingsphere.infra.parser.cache.SQLStatementCacheLoader.load(SQLStatementCacheLoader.java:40)
 ~[shardingsphere-infra-parser-5.0.0.jar:5.0.0]
        at 
org.apache.shardingsphere.infra.parser.cache.SQLStatementCacheLoader.load(SQLStatementCacheLoader.java:29)
 ~[shardingsphere-infra-parser-5.0.0.jar:5.0.0]
        at 
com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3529)
 ~[guava-29.0-jre.jar:?]
        at 
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2278) 
~[guava-29.0-jre.jar:?]
        at 
com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2155)
 ~[guava-29.0-jre.jar:?]
        at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2045) 
~[guava-29.0-jre.jar:?]
        at com.google.common.cache.LocalCache.get(LocalCache.java:3951) 
~[guava-29.0-jre.jar:?]
        at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3974) 
~[guava-29.0-jre.jar:?]
        at 
com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4958) 
~[guava-29.0-jre.jar:?]
        at 
com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4964)
 ~[guava-29.0-jre.jar:?]
        at 
org.apache.shardingsphere.infra.parser.sql.SQLStatementParserEngine.parse(SQLStatementParserEngine.java:48)
 ~[shardingsphere-infra-parser-5.0.0.jar:5.0.0]
        at 
org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse0(ShardingSphereSQLParserEngine.java:71)
 ~[shardingsphere-infra-parser-5.0.0.jar:5.0.0]
        at 
org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse(ShardingSphereSQLParserEngine.java:60)
 ~[shardingsphere-infra-parser-5.0.0.jar:5.0.0]
        at 
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:157)
 ~[shardingsphere-jdbc-core-5.0.0.jar:5.0.0]
        at 
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:128)
 ~[shardingsphere-jdbc-core-5.0.0.jar:5.0.0]
        at 
org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection.prepareStatement(ShardingSphereConnection.java:78)
 ~[shardingsphere-jdbc-core-5.0.0.jar:5.0.0]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
~[?:1.8.0_181]
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
~[?:1.8.0_181]
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[?:1.8.0_181]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_181]
        at 
org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogger.java:55)
 ~[mybatis-3.5.3.jar:3.5.3]
        at com.sun.proxy.$Proxy280.prepareStatement(Unknown Source) ~[?:?]
        at 
org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:86)
 ~[mybatis-3.5.3.jar:3.5.3]
        at 
org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)
 ~[mybatis-3.5.3.jar:3.5.3]
        at 
org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)
 ~[mybatis-3.5.3.jar:3.5.3]
        at 
org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:87)
 ~[mybatis-3.5.3.jar:3.5.3]
        at 
org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49) 
~[mybatis-3.5.3.jar:3.5.3]
        at 
org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) 
~[mybatis-3.5.3.jar:3.5.3]
        at 
org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) 
~[mybatis-3.5.3.jar:3.5.3]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
~[?:1.8.0_181]
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
~[?:1.8.0_181]
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[?:1.8.0_181]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_181]
   


-- 
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.

To unsubscribe, e-mail: 
[email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to