Repository navigation
PostgreSQL JSON arrow operators #1696
Description
Activity
SELECT '{"key": "value"}'::json -> 'key' AS X
fails because
JSONExpressionis currently defined forColumnonly (but not for anExpression).
Please refere to the source JSQLParser/src/main/jjtree/net/sf/jsqlparser/parser/JSqlParserCC.jjt:4175- added a commit that references this issue
on Dec 16, 2022 Greetings,
I have fixed that, although we can't make it work with a generic function:
-- won't work SELECT myStringFunction(a, b, c)::json -> 'key' AS X
The parser will become way too slow and many performance related tests will fail.
Although Parameters and Sub-Queries are supported.I have also exposed the
Idents()andOperators(), no idea what happened there.Great, thank you very much!
Kind regards,
Julien Corman
Hello,
With the JSQL Parser Version 4.5, I encountered the two following issues when parsing PostgreSQL JSON functions in infix notation (the "arrow" operators).
The query
SELECT '{"key": "value"}'::json -> 'key' AS Xyields an exception
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "->" "->".This extends to all the combinations that I tried for the pattern
SELECT [leftOperand]::[datatype] [arrowSymbol] [rightOperand] AS Xwhere
[leftOperand] is a json object
[datatype] is one of {json, jsonb}
[arrowSymbol] is one of { ->, ->>, #>, #>>}
[rightOperand] is a positive integer, a quoted string or a an expression of the form '{a,b}'.
The query
SELECT Y::json -> 'key' AS Xis parsed.
As well as all the combinations that I tried for the above pattern, but where is a non-quoted string (aka a variable name).
The expression
Y::json -> 'key'in this example is exposed as an instance of
net.sf.jsqlparser.expression.JSONExpression.And the right operand ('key' in this example) is the first element of the list
net.sf.jsqlparser.expression.JSONExpression.idents.However, this list
identshas private access.And looking at the source code, I could not find a way to retrieve its elements.
The class
JSONExpressioncontains a getter method foridents, but the code has been commented out.Thank you in advance for your help.
Kind regards,
Julien Corman