[ https://issues.apache.org/jira/browse/CALCITE-3295?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Haisheng Yuan resolved CALCITE-3295. ------------------------------------ Fix Version/s: 1.21.0 Resolution: Fixed Fixed in https://github.com/apache/calcite/commit/97d68952d467540cddddbe8350f706028001dfbf, thanks for the PR, [~yanlin-Lynn]! > Aggregate call name lost in serialized json string. > --------------------------------------------------- > > Key: CALCITE-3295 > URL: https://issues.apache.org/jira/browse/CALCITE-3295 > Project: Calcite > Issue Type: Bug > Reporter: Wang Yanlin > Priority: Major > Labels: pull-request-available > Fix For: 1.21.0 > > Time Spent: 0.5h > Remaining Estimate: 0h > > When serialize a relnode to json string, the name of aggregate call was lost. > For a sql string like this > {code:java} > SELECT max(SAL) as max_sal from EMP group by JOB; > {code} > The serialized json string is like this > {code:java} > { > "rels": [ > { > "id": "0", > "relOp": "LogicalTableScan", > "table": [ > "scott", > "EMP" > ], > "inputs": [] > }, > { > "id": "1", > "relOp": "LogicalProject", > "fields": [ > "JOB", > "SAL" > ], > "exprs": [ > { > "input": 2, > "name": "$2" > }, > { > "input": 5, > "name": "$5" > } > ] > }, > { > "id": "2", > "relOp": "LogicalAggregate", > "group": [ > 0 > ], > "aggs": [ > { > "agg": { > "name": "MAX", > "kind": "MAX", > "syntax": "FUNCTION" > }, > "type": { > "type": "DECIMAL", > "nullable": true, > "precision": 7, > "scale": 2 > }, > "distinct": false, > "operands": [ > 1 > ], > } > ] > }, > { > "id": "3", > "relOp": "LogicalProject", > "fields": [ > "max_sal" > ], > "exprs": [ > { > "input": 1, > "name": "$1" > } > ] > } > ] > } > {code} > Lost the name of max call. -- This message was sent by Atlassian Jira (v8.3.2#803003)