[GitHub] [incubator-shardingsphere] lightning-pro opened a new issue #3651: select statement encouter error when using > comparation with strings

[GitBox <gi...@apache.org>]

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:
users@infra.apache.org


With regards,
Apache Git Services