Skip to content

insert into [...] select [...] returning [...] is not parsed correctly #1131

@lovasoa

Description

@lovasoa

The following query is valid in SQLite and Postgres:

insert into test select 1 returning 2;

(test)

sqlparser currently fails to parse this with ParserError("Expected end of statement, found: 2"). Apparently, it tries to parse RETURNING as a column alias for 1...

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