zhangheng0027 opened a new issue, #30386:
URL: https://github.com/apache/shardingsphere/issues/30386
Using version shardingsphere-jdbc-core:5.4.0
Specific codeļ¼
`SQLParserExecutor mySQLParserExecutor = new SQLParserExecutor("MySQL");
mySQLParserExecutor.parse("select hour from aaa");
SQLParserExecutor oracleParserExecutor = new
SQLParserExecutor("Oracle");
oracleParserExecutor.parse("select hour from aaa");
SQLParserExecutor postgreSQLParserExecutor = new
SQLParserExecutor("PostgreSQL");
postgreSQLParserExecutor.parse("select hour from aaa");
SQLParserExecutor sqlServerParserExecutor = new
SQLParserExecutor("SQLServer");
sqlServerParserExecutor.parse("select hour from aaa");`
**Only SQL server reported an error**
org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have
an error in your SQL syntax: select hour from aaa, no viable alternative at
input 'hour' at line 1, position 7, near [@1,7:10='hour',<142>,1:7]
at
org.apache.shardingsphere.sql.parser.core.database.parser.SQLParserExecutor.twoPhaseParse(SQLParserExecutor.java:69)
at
org.apache.shardingsphere.sql.parser.core.database.parser.SQLParserExecutor.parse(SQLParserExecutor.java:48)
at
com.example.testsharding.TestShardingApplicationTests.test03(TestShardingApplicationTests.java:56)
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at
org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727)
at
org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)
at
--
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]
