taigam opened a new issue #8480:
URL: https://github.com/apache/shardingsphere/issues/8480
` <dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
<version>5.0.0-alpha</version>
</dependency>`
`Actual SQL: magic-image2 ::: SELECT count(0) FROM (SELECT app_code,
group_id, matrix_pwd FROM matrix_info1 GROUP BY matrix_pwd HAVING
count(matrix_pwd) >= ?) table_count ::: [6]`
`-Actual SQL: magic-image0 ::: select
app_code,
group_id,
matrix_pwd
, count(matrix_pwd) AS ORDER_BY_DERIVED_0
from
matrix_info0
group by
matrix_pwd
having count(matrix_pwd) >= ?
order by
count(matrix_pwd) desc LIMIT ? ::: [2147483647, 20]`
when i add order by count() then param have been changed
----------------------------------------------------------------
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:
[email protected]
