Skip to content

misbehave on select xxx group by having #148

Open
@actiontech-bot

Description

@actiontech-bot

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.

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions