-
-
Notifications
You must be signed in to change notification settings - Fork 1.4k
Closed
@HigorOliveira056
Description
Failing SQL Feature:
Apparently the sum of subselects with joins gives an error when parsing
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "+" "+"
at line 1, column 155. Was expecting one of: ")"
SQL Example:
SELECT ( (SELECT COUNT(1) FROM CUSTOMER C INNER JOIN ORDER O ON O.CUSTOMER_ID = C.CUSTOMER_ID INNER JOIN PAYMENT P ON P.ORDER_ID = O.ORDER_ID ) + (SELECT COUNT(1) FROM CUSTOMER C INNER JOIN ADDRESS A ON A.CUSTOMER_ID = C.CUSTOMER_ID INNER JOIN CITY CT ON CT.CITY_ID = A.CITY_ID ) ) AS TOTAL_ASSOC;
Software Information:
- JSqlParser version 5.3
- Database Postgres
Tips:
Without joins works fine
SELECT ( (SELECT COUNT(1) FROM CUSTOMER C ) + (SELECT COUNT(1) FROM CUSTOMER C ) ) AS TOTAL_ASSOC;
and if the expressions are not in parentheses it also works
SELECT (SELECT COUNT(1) FROM CUSTOMER C INNER JOIN ORDER O ON O.CUSTOMER_ID = C.CUSTOMER_ID INNER JOIN PAYMENT P ON P.ORDER_ID = O.ORDER_ID ) + (SELECT COUNT(1) FROM CUSTOMER C INNER JOIN ADDRESS A ON A.CUSTOMER_ID = C.CUSTOMER_ID INNER JOIN CITY CT ON CT.CITY_ID = A.CITY_ID ) AS TOTAL_ASSOC;
Metadata
Metadata
Assignees
Labels
No labels