You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/01/26 11:01:36 UTC
[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
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:
users@infra.apache.org
[GitHub] [shardingsphere] chenkuig commented on issue #9173: it parse incorrectly with both ”in“ and "between" keyword for the same column in a sql statement
Posted by GitBox <gi...@apache.org>.
chenkuig commented on issue #9173:
URL: https://github.com/apache/shardingsphere/issues/9173#issuecomment-768018207
version:
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
<version>4.1.1</version>
</dependency>
----------------------------------------------------------------
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
[GitHub] [shardingsphere] tuichenchuxin commented on issue #9173: it parse incorrectly with both ”in“ and "between" keyword for the same column in a sql statement
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #9173:
URL: https://github.com/apache/shardingsphere/issues/9173#issuecomment-927657125
@chenkuig Can you try to use the latest version to test it? We have a lot improvement, welcome to test.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #9173: it parse incorrectly with both ”in“ and "between" keyword for the same column in a sql statement
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #9173:
URL: https://github.com/apache/shardingsphere/issues/9173#issuecomment-767998819
Which version is running? FYI. https://shardingsphere.apache.org/document/current/en/features/sharding/concept/sharding/
----------------------------------------------------------------
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