lightning-pro opened a new issue #3651: select statement encouter error when using > comparation with strings URL: https://github.com/apache/incubator-shardingsphere/issues/3651 #3043 # Which version of ShardingSphere did you use? 4.0.0-RC4 compile by myselft from the source code ### Which project did you use? Sharding-JDBC or Sharding-Proxy? Sharding-Proxy ### Expected behavior select the records as expected ### Actual behavior encounter error as belows SQL 错误 [10002] [C1000]: 2Unknown exception: [Inline strategy cannot support range sharding.] ### Reason analyze (If you can) have no idea ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc. SELECT SMS_NUM_ID FROM CUSTOMER_SMS_NUM WHERE SMS_NUM_ID > '11' ### Example codes for reproduce this issue (such as a github link). SELECT SMS_NUM_ID FROM CUSTOMER_SMS_NUM WHERE SMS_NUM_ID > '11' SELECT SMS_NUM_ID FROM CUSTOMER_SMS_NUM WHERE SMS_NUM_ID > '11' or SELECT SMS_NUM_ID FROM CUSTOMER_SMS_NUM WHERE SMS_NUM_ID > 11 fail to execute, but when connect to the db directly, both of these work fine
---------------------------------------------------------------- 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: us...@infra.apache.org With regards, Apache Git Services