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/08/21 11:17:40 UTC

[GitHub] [shardingsphere] peng-ran opened a new issue #6982: SQL evaluated expressions with double parentheses are not sharable

peng-ran opened a new issue #6982:
URL: https://github.com/apache/shardingsphere/issues/6982


           SELECT ROUND(a.F_ID, 3)  / 1000 - ROUND(a.F_ID, 3)  / 1000 as F_ID,
                  a.F_NAME
           FROM t_demo AS a
   
   is ok 
   
           SELECT (ROUND(a.F_ID, 3) - ROUND(a.F_ID, 3))  / 1000 as F_ID,
                  a.F_NAME
           FROM t_demo AS a
   or
   
           SELECT (ROUND(a.F_ID, 3) - ROUND(a.F_ID, 3))  + 1000 as F_ID,
                  a.F_NAME
           FROM t_demo AS a
   
   or 
   
           SELECT (ROUND(a.F_ID, 3))  / 1000 as F_ID,
                  a.F_NAME
           FROM t_demo AS a
   is error ,can not 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



[GitHub] [shardingsphere] terrymanu commented on issue #6982: SQL evaluated expressions with double parentheses can not sharding

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #6982:
URL: https://github.com/apache/shardingsphere/issues/6982#issuecomment-678894524


   What the version do you use? 
   The problem has already fixed by version 4.x.


----------------------------------------------------------------
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] jingshanglu edited a comment on issue #6982: SQL evaluated expressions with double parentheses can not sharding

Posted by GitBox <gi...@apache.org>.
jingshanglu edited a comment on issue #6982:
URL: https://github.com/apache/shardingsphere/issues/6982#issuecomment-684178316


   @peng-ran @kimmking @terrymanu  Now, i test it on master branch, it has been fixed on master branch, new version will be ok.
   ![image](https://user-images.githubusercontent.com/16559542/91792368-f5451580-ec47-11ea-9254-4c0518bce0b0.png)
   ![image](https://user-images.githubusercontent.com/16559542/91792419-09891280-ec48-11ea-96c1-43818b341afb.png)
   
   
   


----------------------------------------------------------------
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] peng-ran commented on issue #6982: SQL evaluated expressions with double parentheses can not sharding

Posted by GitBox <gi...@apache.org>.
peng-ran commented on issue #6982:
URL: https://github.com/apache/shardingsphere/issues/6982#issuecomment-679449659


   @terrymanu sharding-jdbc-core 4.1.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 #6982: SQL evaluated expressions with double parentheses can not sharding

Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #6982:
URL: https://github.com/apache/shardingsphere/issues/6982#issuecomment-696134849


   I check these cases work well now in master branch.


----------------------------------------------------------------
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 #6982: SQL evaluated expressions with double parentheses can not sharding

Posted by GitBox <gi...@apache.org>.
kimmking closed issue #6982:
URL: https://github.com/apache/shardingsphere/issues/6982


   


----------------------------------------------------------------
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 edited a comment on issue #6982: SQL evaluated expressions with double parentheses can not sharding

Posted by GitBox <gi...@apache.org>.
kimmking edited a comment on issue #6982:
URL: https://github.com/apache/shardingsphere/issues/6982#issuecomment-679480078


   it's a bug.
   
   > select (1+id) as iid from test;
   >  select ((1+id)) as iid from test;
   >  select ((1+id)-1) as iid from test;
   
   is ok. 
   
   > select (1+id)+2 as iid from test;
   >  select ((1+id))-1 as iid from test;
   
   will be not 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



[GitHub] [shardingsphere] kimmking commented on issue #6982: SQL evaluated expressions with double parentheses can not sharding

Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #6982:
URL: https://github.com/apache/shardingsphere/issues/6982#issuecomment-679480078


   it's a bug.
   
   > select (1+id) as iid from test;
   
   is ok. 
   
   > select (1+id)+2 as iid from test;
   
   will be not 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



[GitHub] [shardingsphere] kimmking commented on issue #6982: SQL evaluated expressions with double parentheses can not sharding

Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #6982:
URL: https://github.com/apache/shardingsphere/issues/6982#issuecomment-696134849


   I check these cases work well now in master branch.


----------------------------------------------------------------
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 #6982: SQL evaluated expressions with double parentheses can not sharding

Posted by GitBox <gi...@apache.org>.
kimmking closed issue #6982:
URL: https://github.com/apache/shardingsphere/issues/6982


   


----------------------------------------------------------------
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] jingshanglu commented on issue #6982: SQL evaluated expressions with double parentheses can not sharding

Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #6982:
URL: https://github.com/apache/shardingsphere/issues/6982#issuecomment-684178316


   @peng-ran @kimmking @terrymanu  Now, i test it on master branch, it is ok.
   ![image](https://user-images.githubusercontent.com/16559542/91792368-f5451580-ec47-11ea-9254-4c0518bce0b0.png)
   ![image](https://user-images.githubusercontent.com/16559542/91792419-09891280-ec48-11ea-96c1-43818b341afb.png)
   
   
   


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