Skip to content

SELECT null [not] IN () #1529

@mathiasrw

Description

@mathiasrw

Derived from https://github.com/AlaSQL/alasql-sqllogictest/blob/a10ff82e75edafae2ce96c9d02ab47cfc85d4507/results/output.md#1620-testevidencein1test


SELECT null IN ()

Expected: false but got NULL


SELECT null NOT IN ()

Expected: true but got NULL

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions