Skip to content

fix: Issue #2109 true and false value parsed as column instead of BooleanValue#2110

Merged
manticore-projects merged 1 commit intoJSQLParser:masterfrom
lucarota:fix/issue_2109
Nov 14, 2024
Merged

fix: Issue #2109 true and false value parsed as column instead of BooleanValue#2110
manticore-projects merged 1 commit intoJSQLParser:masterfrom
lucarota:fix/issue_2109

Conversation

@lucarota
Copy link
Contributor

Hi all,

this patch addresses Issue #2109 in the JSQLParser library, where TRUE and FALSE were incorrectly handled as column names rather than as boolean values.

According to the SQL standard ISO/IEC 9075:2016, TRUE and FALSE are reserved keywords representing boolean literals, not column identifiers.

This patch updates the parser to recognize TRUE and FALSE as boolean literals, ensuring compliance with the SQL standard and preventing potential errors in query interpretation.

Ciao,
Luca

@manticore-projects
Copy link
Contributor

Very clean, well done! Thank you for your help and contribution!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants

Comments