dble
dble copied to clipboard
misbehave on `select xxx group by having`
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.
dble version:5.6.29-dble-2.18.09.1-2b298cd-20180904021034