Skip to content

SELECT statement works on 1.4.200 but fails on 2.0.202 with "Column XYZ must be in the GROUP BY list" #3287

@tasso94

Description

@tasso94

The attached SQL SELECT statement can be executed with H2 version 1.4.200 but fails with the following error on H2 version 2.0.202:

Column "PROCDEF.KEY_" must be in the GROUP BY list;

Table definitions, inserts, and failing select statement: reproduce_h2_bug.sql.txt

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions