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/13 03:55:15 UTC

[GitHub] [shardingsphere] cobstergo opened a new issue #6814: Does sharding proxy support query add custom column?

cobstergo opened a new issue #6814:
URL: https://github.com/apache/shardingsphere/issues/6814


   Does sharding proxy support query add custom column？
   like this , for example
   SELECT id,(SELECT count(0) FROM table_budev) as devCount FROM table_ticket ORDER BY id DESC limit 10;
   in mysql:
   ![image](https://user-images.githubusercontent.com/11827280/90092452-8d439380-dd5b-11ea-8299-7c772aeed8fc.png)
   in sharding proxy:
   ![image](https://user-images.githubusercontent.com/11827280/90092471-9df40980-dd5b-11ea-861b-51a52466c135.png)
   sharding proxy version is 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] tristaZero commented on issue #6814: Does sharding proxy support query add custom column?

Posted by GitBox <gi...@apache.org>.

tristaZero commented on issue #6814:
URL: https://github.com/apache/shardingsphere/issues/6814#issuecomment-673311448


   @cobstergo Hi
   4.1.1 does not have better support for `subquery`, I suggest you try the `master branch`.
   Besides, it is required that `table_budev ` and `table_ticket ` have the same sharding algorithm.


----------------------------------------------------------------
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] cobstergo closed issue #6814: Does sharding proxy support query add custom column?

Posted by GitBox <gi...@apache.org>.

cobstergo closed issue #6814:
URL: https://github.com/apache/shardingsphere/issues/6814


   


----------------------------------------------------------------
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] cobstergo commented on issue #6814: Does sharding proxy support query add custom column?

Posted by GitBox <gi...@apache.org>.

cobstergo commented on issue #6814:
URL: https://github.com/apache/shardingsphere/issues/6814#issuecomment-673357963


   @tristaZero got it, thanks for you reply.


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