The following query is valid, but gets marked as ERROR: Found ‘)’, Expecting: ,
SELECT LISTAGG( 1 ) WITHIN GROUP( ORDER BY 1 ) FROM dual;
The following query is valid, but gets marked as ERROR: Found ‘)’, Expecting: ,
SELECT LISTAGG( 1 ) WITHIN GROUP( ORDER BY 1 ) FROM dual;
I think this was once before reported as a bug.
could anyone confirmed?
A parser bug indeed.
I didn’t find a record for this defect, but next (or next next) parser version will fix it. (QP-2551)
Thanks,
Andre