[CALCITE-5997] OFFSET operator is incorrectly unparsed

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.35.0
• Fix Version/s: 1.36.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Mihai Budiu
• Reporter: Mihai Budiu
• Created: 12/Sep/23 00:32
• Updated: 10/Nov/23 11:34
• Resolved: 20/Sep/23 02:19

Description

The following query:

select ARRAY[p2,p1,p0][OFFSET(2)] from (values (6, 4, 2)) as t(p0, p1, p2)

when parsed as a SqlNode and then unparsed produces:

SELECT ARRAY["P2", "P1", "P0"][2]
FROM (VALUES ROW(6, 4, 2)) AS "T" ("P0", "P1", "P2")

which no longer produces the same result (the OFFSET function call is missing).

Issue Links

• links to: GitHub Pull Request #3423