Parser fails if column name is synonym

[salonijuneja]

Parser failed with JSQLParserException if a column name in select statement is synonym.
eg: select businessDate as "bd", synonym as "synonym" from sc.tab

[manticore-projects]

It is NOT about the alias, but about the unquoted column name:

"synonym" is a Keyword and you can't use that without quotes.
Please close the issue, when confirmed.

Best regards
Andreas

[salonijuneja]

But this query (without quotes) executes successfully without error on Database (Sybase IQ though)

[manticore-projects]

This is very possible when Sybase does not use "Synonym" as a keyword. Does not change the fact, that "Synonym" is a very common keyword on any major RDBMS and you can't write queries like:  select from as table from where as null group by having; for a reason, while select "from" as "table" from "where" as "null" group by "having"; actually will work. Best regards Andreas

…

On Tue, 2021-05-25 at 04:52 -0700, salonijuneja wrote: But this query (without quotes) executes successfully without error on Database (Sybase IQ though) — You are receiving this because you commented. Reply to this email directly, view it on GitHub, or unsubscribe.

[wumpz]

@manticore-projects To allow keywords as object names you could include those in RelObjectNameWithoutValue. In some cases this is not possible because the conflicts in JSqlParser grammar would be to huge to tackle, but this synonym keyword made no problems.