taigam commented on issue #8480:
URL: https://github.com/apache/shardingsphere/issues/8480#issuecomment-737690313
and i found
if i delete order by
sharing will add it behind the group by
the sql changed for :
SELECT
app_code,
group_id,
matrix_pwd,
count(matrix_pwd) AS repeatedCount
FROM
matrix_info1
GROUP BY
matrix_pwd
ORDER BY
matrix_pwd ASC
HAVING
count(matrix_pwd) >= ?
LIMIT ? ::: [ 6,
20 ]
it can't be used
----------------------------------------------------------------
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]
