[GitHub] [shardingsphere] chenkuig opened a new issue #9173: it parse incorrectly with both ”in“ and "between" keyword for the same column in a sql statement

Tue, 26 Jan 2021 03:01:42 -0800 


chenkuig opened a new issue #9173:
URL: https://github.com/apache/shardingsphere/issues/9173


   ###logging  Actual SQL : 
   select 
id,tenant_id,state,type_code,type_name,top_flag,deadline_time,creater_id,creater_name,creater_position,create_time,publisher_id,publisher_name,publisher_position,publish_time,title,content,media_files
  FROM t_proclamation1 
   WHERE (tenant_id IN (?,?) AND tenant_id BETWEEN ? AND ? AND create_time 
BETWEEN ? AND ?) ::: [1001, 2001, 1000, 3000, 2020-12-29 12:12:00, 2021-2-29 
12:12:00]
   
   ### actually need
   
![image](https://user-images.githubusercontent.com/40064877/105835818-4f83b000-6007-11eb-935a-bb8bf6335e5a.png)
   
   debug:
   only parse "tenant_id between " keyword and "create_time between"  keyword, 
"tenant_id in"  do not  parse
   
![image](https://user-images.githubusercontent.com/40064877/105835990-8ce83d80-6007-11eb-8841-8e28a21dba69.png)
   
   ###application.properties config
   
![image](https://user-images.githubusercontent.com/40064877/105836480-2fa0bc00-6008-11eb-9aba-5dce4fb05d62.png)
   
   question: in and between keyword for the same column, do  it need the 
special config for "ComplexKeysShardingAlgorithm" strategy


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

Reply via email to