-
Notifications
You must be signed in to change notification settings - Fork 38
Open
Description
I have this query
SELECT
ARRAY_TO_STRING(
(ARRAY_AGG("EmployeeName" ORDER BY "Salary" DESC))[1:10],
', '
) AS top10_employees,
ARRAY_TO_STRING(
(ARRAY_AGG("EmployeeName" ORDER BY "Salary" ASC))[1:10],
', '
) AS bottom10_employees
FROM
"Employee";
but the parser fails to parse it correctly when I try to convert it back to sql I get
SELECT
ARRAY_TO_STRING((ARRAY_AGG("EmployeeName" ORDER BY "Salary" DESC))
[LiteralValue { Value = Number { Value = 1, Long = False } }:LiteralValue { Value = Number { Value = 10, Long = False } }], ', ') AS top10_employees,
ARRAY_TO_STRING((ARRAY_AGG("EmployeeName" ORDER BY "Salary" ASC))
[LiteralValue { Value = Number { Value = 1, Long = False } }:LiteralValue { Value = Number { Value = 10, Long = False } }], ', ') AS bottom10_employees
FROM
Employee
Metadata
Metadata
Assignees
Labels
No labels