[CALCITE-3295] Aggregate call name lost in serialized json string.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.21.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Wang Yanlin
• Created: 26/Aug/19 12:43
• Updated: 10/Sep/19 21:36
• Resolved: 27/Aug/19 20:56

Description

When serialize a relnode to json string, the name of aggregate call was lost.
For a sql string like this

SELECT max(SAL) as max_sal from EMP group by JOB;

The serialized json string is like this

{
  "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"
        }
      ]
    }
  ]
}

Lost the name of max call.

Issue Links

• links to: GitHub Pull Request #1415