Skip to content

GREATEST and LEAST aren't fully compliant with the SQL Standard #3089

@gabrielsky

Description

@gabrielsky

the function "least()" have diffent behavior
myqsl : If any argument is NULL, the result is NULL. No comparison is needed.
h2 : all value must be null return null

example:
least(null,123)
in mysql return null,but h2 return 123

we use h2 as junit test db,so hope they have same behavior

h2 version:1.4.200

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions