Skip to content

[BUG] JSQLParser 4.6 : MySQL : JSON_OBJECTAGG fails with table prefixes #1753

@tomershay

Description

@tomershay

The following query parses ok:
SELECT JSON_OBJECTAGG( KEY foo VALUE bar) FROM dual

But this one doesn't (only change is adding prefixes to column names:
SELECT JSON_OBJECTAGG( KEY q.foo VALUE q.bar) FROM dual

Also, this alternative is valid but fail parsing:
SELECT JSON_OBJECTAGG(foo, bar) FROM dual

Metadata

Metadata

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions