GROUP BY + LIMIT rewrite incorrect

[terrymanu]

Please answer these questions before submitting your issue. Thanks!

Which version of Sharding-Jdbc do you using?

1.5.0

Expected behavior

SELECT user_id FROM t_order GROUP BY user_id LIMIT ?

=>

SELECT user_id FROM t_order GROUP BY user_id ORDER BY user_id ASC LIMIT ?

Actual behavior

SELECT user_id FROM t_order GROUP BY user_id LIMIT ?

=>

SELECT user_id FROM t_order GROUP BY user_id LIMIT ORDER BY user_id ASC

[terrymanu]

fixed at 1.5.1