Skip to content

[BUG] JSQLParser 5.0: Generic: Update with true as value is parsed as column #2109

@lucarota

Description

@lucarota

Failing SQL Feature:

When updating a Boolean column, the value true is parsed as column.

SQL Example:

UPDATE TestTable SET Column1 = 'Tester', Column2 = true WHERE Id = 'AAS'    

Column1 and Column2 are parsed as a Column object.
Tester is parsed as a StringValue
true is parsed as Column object. Why? I expect it to be parsed as BooleanValue or something else value object.

Statement queryData = CCJSqlParserUtil.parse("UPDATE TestTable SET Column1 = 'Tester', Column2 = true WHERE Id = 'AAS'");

image

Software Information:

  • JSqlParser version 5.0 (same problem with the snapshot)

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