Repository navigation
[BUG] JSQLParser Version : 5.1 RDBMS : PostgreSQL 10 mix the JSON and relational operators, it outputs the wrong AST and sql. #2163
Description
Activity
BTW
if we parse the new sqlSELECT * FROM t WHERE js#>>'{a,b,1}' <> 'bar'
JSQLParser will recognize it as a wrong Bitwise operation in the AST:
the collumn name isjs#, and the operator is>>.the collumn name is js#, and the operator is >>
In this case you will need to quote the column name like
"js#"since it interferes with the JSON operator#>>.SQL Text └─Statements: statement.select.PlainSelect ├─selectItems: statement.select.SelectItem │ └─AllColumns: * ├─Table: t └─where: expression.operators.relational.NotEqualsTo ├─leftExpression: expression.operators.arithmetic.BitwiseRightShift │ ├─Column: "js#" │ └─StringValue: '{a,b,1}' └─StringValue: 'bar'thanks.
what about the issue of the wrong priority?
js #>> ('{a,b,1}' <> 'bar')in fact, what we need is:
(js #>> '{a,b,1}') <> 'bar', just like PG does.we parse the original sql by JSQLParser 4.9, and it works well.
it seems like a bug for version 5.1 .what about the issue of the wrong priority?
Adding brackets for clarity may be your best instant solution.
SQL Text └─Statements: statement.select.PlainSelect ├─selectItems: statement.select.SelectItem │ └─AllColumns: * ├─Table: t └─where: expression.operators.relational.NotEqualsTo ├─ParenthesedExpressionList: (js#>>'{a,b,1}') └─StringValue: 'bar'Verified on current master (
a5765f3):select * from t where js #>> '{a,b,1}' <> 'bar'now parses with the expected precedence: the WHERE clause isNotEqualsTo(JsonExpression(js #>> '{a,b,1}'), 'bar'). The deparser output also keeps the spaces:SELECT * FROM t WHERE js #>> '{a,b,1}' <> 'bar'. Both reported errors are resolved. Can this be closed?Reacted by manticore-projects
Description:
SQL Example:
Original SQL:
Error 1:
In the AST, the filter likes this:
js #>> ('{a,b,1}' <> 'bar')but what we need is:
(js #>> '{a,b,1}') <> 'bar'Error 2:
JSQLParser generates the new sql:
but what we need is:
SELECT * FROM t WHERE js #>> '{a,b,1}' <> 'bar'JSQLParser lost the blank spaces.
Software Information: