dble icon indicating copy to clipboard operation
dble copied to clipboard

misbehave on `select xxx group by having`

Open actiontech-bot opened this issue 7 years ago • 1 comments

Raised by: helingyun SQL: select my_max_money from user_creditcard_info where id between 1 and 100 group by my_creditcard having my_comsume_money>=8

Query on Dble succeed while it failed on MySQL.

Found: Dble makes having in where while MySQL makes the opposite.

actiontech-bot avatar Sep 02 '17 12:09 actiontech-bot

dble version:5.6.29-dble-2.18.09.1-2b298cd-20180904021034 b419e0a65cd5f2fbaf66856d5a2c17dd

irene-coming avatar Sep 04 '18 08:09 irene-coming