Skip to content

parse true and false as column names, not booleans in Microsoft SQL server #1508

Closed
@lovasoa

Description

@lovasoa

mssql does not have a boolean type: true and false are not special keywords and they are valid column names. However, sqlparser always parses them as boolean literals, regardless of the dialect.

In the mssql dialect, in

select true from table;

true should be parsed as an Identifier, not a Value.

Parsing true and false as booleans in mssql causes the following confusing behavior in SQLPage: sqlpage/SQLPage#679

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