[CALCITE-2787] JSON aggregate calls with different null clause get incorrectly merged during converting from SQL to relational algebra

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.18.0
• Fix Version/s: 1.19.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Hongze Zhang
• Reporter: Hongze Zhang
• Created: 16/Jan/19 06:35
• Updated: 25/Mar/19 00:11
• Resolved: 27/Feb/19 14:29

Description

SQL:
 

WITH tab(x) AS (VALUES 1, 2, 1, CAST(NULL AS INTEGER))
SELECT JSON_ARRAYAGG(x), JSON_ARRAYAGG(x NULL ON NULl) FROM tab

Produces:

EXPR$0  |EXPR$1  |
--------|--------|
[1,2,1] |[1,2,1] |

Should be:

EXPR$0  |EXPR$1  |
--------|--------|
[1,2,1] |[1,2,1,null] |

Issue Links

• links to: GitHub Pull Request #1060