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/05/03 03:41:08 UTC

[GitHub] [shardingsphere] 362475097 opened a new issue #5414: Cannot use LogicTableName in 'where clause'

362475097 opened a new issue #5414:
URL: https://github.com/apache/shardingsphere/issues/5414


   I‘m using sqlalchemy + sharding-proxy.
   
   The sql created by sqlalchemy like this:
     select * from order_info where CAST(order_info.create_time AS DATE) = '2020-05-03';
   
   The real sql excuted by sharding-proxy like this:
     select * from order_info_2020_4 where CAST(order_info.create_time AS DATE) = '2020-05-03';
   
   So the 'order_info' in 'where clause' is wrong. 
   How to solve this problem?


----------------------------------------------------------------
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 #5414: Cannot use LogicTableName in 'where clause'

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


   Closed because of no response anymore


----------------------------------------------------------------
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 #5414: Cannot use LogicTableName in 'where clause'

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


   Or remove the table name in the prefix


----------------------------------------------------------------
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 #5414: Cannot use LogicTableName in 'where clause'

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


   You can use alias to instead of table name


----------------------------------------------------------------
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 #5414: Cannot use LogicTableName in 'where clause'

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


   What is your version?


----------------------------------------------------------------
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] 362475097 commented on issue #5414: Cannot use LogicTableName in 'where clause'

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


   > What is your version?
   
   My version is 4.1.0


----------------------------------------------------------------
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 closed issue #5414: Cannot use LogicTableName in 'where clause'

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


   


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