Skip to content

Value disappeared when parsing sql in sqlite with expression IN #7805

Description

@VLDB2026

read="sqlite"
dialect="sqlite"
Confirmed on main: reproduces on commit fd6d4d6

After parsing the SQLite query, the values within the query disappeared.
Fully reproducible code snippet

SELECT * FROM t1 WHERE (a, b) IN (((SELECT 42), 1), (2, 2))

after parsed and resql, it output:

SELECT * FROM t1 WHERE (a, b) IN (((SELECT 42)), (2, 2))

the ((SELECT 42), 1) becomes ((SELECT 42)) and no warning or error occurs.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions