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 2020/10/21 04:18:23 UTC
[GitHub] [shardingsphere] waylink opened a new issue #7868: In() function parameters does not split
waylink opened a new issue #7868:
URL: https://github.com/apache/shardingsphere/issues/7868
About:
Sharding: user % 2
unique: user_type_index(user, type)
Consume Time：2 ms 2020-10-21 12:11:21
Execute SQL：SELECT id, user, type FROM user_t_0 WHERE (user IN ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100') and type = 1)
Consume Time：0 ms 2020-10-21 12:11:21
Execute SQL：SELECT id, user, type FROM user_t_1 WHERE (user IN ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100') and type = 1)
----------------------------------------------------------------
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] kimmking commented on issue #7868: In() function parameters does not split
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #7868:
URL: https://github.com/apache/shardingsphere/issues/7868#issuecomment-713343218
It's the NORMAL design now.
And will be optimized some time.
----------------------------------------------------------------
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] yu199195 commented on issue #7868: In() function parameters does not split
Posted by GitBox <gi...@apache.org>.
yu199195 commented on issue #7868:
URL: https://github.com/apache/shardingsphere/issues/7868#issuecomment-713337393
Which version are you using？ can you show sharding config？
----------------------------------------------------------------
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] kimmking closed issue #7868: In() function parameters does not split
Posted by GitBox <gi...@apache.org>.
kimmking closed issue #7868:
URL: https://github.com/apache/shardingsphere/issues/7868
----------------------------------------------------------------
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