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/10/28 10:03:47 UTC
[GitHub] [shardingsphere] heysJava opened a new issue #13331: How to prohibit order by
heysJava opened a new issue #13331:
URL: https://github.com/apache/shardingsphere/issues/13331
When there is no order by in my query, order by is automatically added using shardingsphere. I want to know how to remove the automatic splicing order by
--
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] heysJava commented on issue #13331: How to prohibit order by
Posted by GitBox <gi...@apache.org>.
heysJava commented on issue #13331:
URL: https://github.com/apache/shardingsphere/issues/13331#issuecomment-954345063
@strongduanmu Hi，My query statement contains group by, but there is no order by, because order by will affect query performance, I don’t want to execute sql statement containing order by
--
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] strongduanmu commented on issue #13331: How to prohibit order by
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #13331:
URL: https://github.com/apache/shardingsphere/issues/13331#issuecomment-954478954
You can refer this doc for more detail info——https://shardingsphere.apache.org/document/current/cn/reference/sharding/merge/#%E5%88%86%E7%BB%84%E5%BD%92%E5%B9%B6.
--
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] heysJava commented on issue #13331: How to prohibit order by
Posted by GitBox <gi...@apache.org>.
heysJava commented on issue #13331:
URL: https://github.com/apache/shardingsphere/issues/13331#issuecomment-997434140
你好，邮件已收到，谢谢你(*^__^*)
--
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] terrymanu closed issue #13331: How to prohibit order by
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #13331:
URL: https://github.com/apache/shardingsphere/issues/13331
--
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] heysJava commented on issue #13331: How to prohibit order by
Posted by GitBox <gi...@apache.org>.
heysJava commented on issue #13331:
URL: https://github.com/apache/shardingsphere/issues/13331#issuecomment-954591778
@strongduanmu thanks，Although it is not the result I want, but I understand the purpose of automatically adding order by
--
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] strongduanmu commented on issue #13331: How to prohibit order by
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #13331:
URL: https://github.com/apache/shardingsphere/issues/13331#issuecomment-953746769
Hi @heysJava Please check if your statement contains aggregate functions. In order to ensure that aggregate functions can be merged efficiently, ShardingSphere will rewrite queries containing aggregate functions and add OrderBy statements.
--
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] strongduanmu commented on issue #13331: How to prohibit order by
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #13331:
URL: https://github.com/apache/shardingsphere/issues/13331#issuecomment-954673407
@heysJava So, can we close this issue now?
--
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] heysJava commented on issue #13331: How to prohibit order by
Posted by GitBox <gi...@apache.org>.
heysJava commented on issue #13331:
URL: https://github.com/apache/shardingsphere/issues/13331#issuecomment-956002000
> @heysJava So, can we close this issue now?
Can be closed
--
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