{
    "Plan": {
        "Node Type": "Query",
        "PlanNodeType": "Query",
        "Plans": [
            {
                "Node Type": "ResultSet",
                "PlanNodeId": 4,
                "PlanNodeType": "ResultSet",
                "Plans": [
                    {
                        "Node Type": "Limit",
                        "Operators": [
                            {
                                "Inputs": [
                                    {
                                        "ExternalPlanNodeId": 2
                                    }
                                ],
                                "Limit": "1001",
                                "Name": "Limit"
                            }
                        ],
                        "PlanNodeId": 3,
                        "Plans": [
                            {
                                "Node Type": "UnionAll",
                                "PlanNodeId": 2,
                                "PlanNodeType": "Connection",
                                "Plans": [
                                    {
                                        "Node Type": "Limit-TableFullScan",
                                        "Operators": [
                                            {
                                                "Inputs": [
                                                    {
                                                        "InternalOperatorId": 1
                                                    }
                                                ],
                                                "Limit": "1001",
                                                "Name": "Limit"
                                            },
                                            {
                                                "Inputs": [],
                                                "Name": "TableFullScan",
                                                "ReadColumns": [
                                                    "i"
                                                ],
                                                "ReadLimit": "1001",
                                                "ReadRanges": [
                                                    "i (-\u221e, +\u221e)"
                                                ],
                                                "Scan": "Sequential",
                                                "Table": "postgres_case.test_plan/CASE_TBL"
                                            }
                                        ],
                                        "PlanNodeId": 1,
                                        "Tables": [
                                            "postgres_case.test_plan/CASE_TBL"
                                        ]
                                    }
                                ]
                            }
                        ]
                    }
                ]
            }
        ]
    },
    "meta": {
        "type": "query",
        "version": "0.2"
    },
    "tables": [
        {
            "name": "/Root/postgres_case.test_plan/CASE_TBL",
            "reads": [
                {
                    "columns": [
                        "i"
                    ],
                    "limit": "1001",
                    "scan_by": [
                        "i (-\u221e, +\u221e)"
                    ],
                    "type": "FullScan"
                }
            ]
        }
    ]
}{
    "Plan": {
        "Node Type": "Query",
        "PlanNodeType": "Query",
        "Plans": [
            {
                "Node Type": "ResultSet_2",
                "PlanNodeId": 25,
                "PlanNodeType": "ResultSet",
                "Plans": [
                    {
                        "Node Type": "Limit",
                        "Operators": [
                            {
                                "Inputs": [
                                    {
                                        "ExternalPlanNodeId": 23
                                    }
                                ],
                                "Limit": "1001",
                                "Name": "Limit"
                            }
                        ],
                        "PlanNodeId": 24,
                        "Plans": [
                            {
                                "Node Type": "Merge",
                                "PlanNodeId": 23,
                                "PlanNodeType": "Connection",
                                "Plans": [
                                    {
                                        "Node Type": "TopSort-LeftJoin (MapJoin)",
                                        "Operators": [
                                            {
                                                "Inputs": [
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    }
                                                ],
                                                "Limit": "1001",
                                                "Name": "TopSort",
                                                "TopSortBy": "row.x1"
                                            },
                                            {
                                                "Condition": "x_1.x1 = xx.x1",
                                                "Inputs": [
                                                    {
                                                        "ExternalPlanNodeId": 21
                                                    },
                                                    {
                                                        "ExternalPlanNodeId": 13
                                                    }
                                                ],
                                                "Name": "LeftJoin (MapJoin)"
                                            }
                                        ],
                                        "PlanNodeId": 22,
                                        "Plans": [
                                            {
                                                "Node Type": "Map",
                                                "PlanNodeId": 21,
                                                "PlanNodeType": "Connection",
                                                "Plans": [
                                                    {
                                                        "Node Type": "LeftJoin (MapJoin)",
                                                        "Operators": [
                                                            {
                                                                "Condition": "x_1.x1 = y.y1",
                                                                "Inputs": [
                                                                    {
                                                                        "ExternalPlanNodeId": 19
                                                                    },
                                                                    {
                                                                        "ExternalPlanNodeId": 17
                                                                    }
                                                                ],
                                                                "Name": "LeftJoin (MapJoin)"
                                                            }
                                                        ],
                                                        "PlanNodeId": 20,
                                                        "Plans": [
                                                            {
                                                                "Node Type": "Broadcast",
                                                                "PlanNodeId": 17,
                                                                "PlanNodeType": "Connection",
                                                                "Plans": [
                                                                    {
                                                                        "Node Type": "Collect",
                                                                        "PlanNodeId": 16,
                                                                        "Plans": [
                                                                            {
                                                                                "Node Type": "UnionAll",
                                                                                "PlanNodeId": 15,
                                                                                "PlanNodeType": "Connection",
                                                                                "Plans": [
                                                                                    {
                                                                                        "CTE Name": "precompute_1_0",
                                                                                        "Node Type": "Filter-TableRangeScan-ConstantExpr",
                                                                                        "Operators": [
                                                                                            {
                                                                                                "Inputs": [
                                                                                                    {
                                                                                                        "InternalOperatorId": 1
                                                                                                    }
                                                                                                ],
                                                                                                "Name": "Filter",
                                                                                                "Predicate": "Exist(item.y1)"
                                                                                            },
                                                                                            {
                                                                                                "Inputs": [
                                                                                                    {
                                                                                                        "InternalOperatorId": 2
                                                                                                    }
                                                                                                ],
                                                                                                "Name": "TableRangeScan",
                                                                                                "ReadColumns": [
                                                                                                    "y1",
                                                                                                    "y2"
                                                                                                ],
                                                                                                "Table": "postgres_jointest/join2.test_plan/y"
                                                                                            },
                                                                                            {
                                                                                                "Inputs": [],
                                                                                                "Iterator": "precompute_1_0",
                                                                                                "Name": "Iterator"
                                                                                            }
                                                                                        ],
                                                                                        "PlanNodeId": 14,
                                                                                        "Tables": [
                                                                                            "postgres_jointest/join2.test_plan/y"
                                                                                        ]
                                                                                    }
                                                                                ]
                                                                            }
                                                                        ]
                                                                    }
                                                                ]
                                                            },
                                                            {
                                                                "Node Type": "Map",
                                                                "PlanNodeId": 19,
                                                                "PlanNodeType": "Connection",
                                                                "Plans": [
                                                                    {
                                                                        "CTE Name": "precompute_0_0",
                                                                        "Node Type": "ConstantExpr",
                                                                        "Operators": [
                                                                            {
                                                                                "Inputs": [],
                                                                                "Iterator": "precompute_0_0",
                                                                                "Name": "Iterator"
                                                                            }
                                                                        ],
                                                                        "PlanNodeId": 18
                                                                    }
                                                                ]
                                                            }
                                                        ]
                                                    }
                                                ]
                                            },
                                            {
                                                "Node Type": "Broadcast",
                                                "PlanNodeId": 13,
                                                "PlanNodeType": "Connection",
                                                "Plans": [
                                                    {
                                                        "CTE Name": "precompute_0_1",
                                                        "Node Type": "ConstantExpr",
                                                        "Operators": [
                                                            {
                                                                "Inputs": [],
                                                                "Iterator": "precompute_0_1",
                                                                "Name": "Iterator"
                                                            }
                                                        ],
                                                        "PlanNodeId": 12
                                                    }
                                                ]
                                            }
                                        ]
                                    }
                                ],
                                "SortColumns": [
                                    "x1 (Asc)"
                                ]
                            }
                        ]
                    }
                ]
            },
            {
                "Node Type": "Precompute_1",
                "Parent Relationship": "InitPlan",
                "PlanNodeId": 10,
                "PlanNodeType": "Materialize",
                "Plans": [
                    {
                        "CTE Name": "precompute_0_0",
                        "Node Type": "Aggregate",
                        "Operators": [
                            {
                                "Input": "precompute_0_0",
                                "Inputs": [],
                                "Name": "PartitionByKey"
                            }
                        ],
                        "PlanNodeId": 9
                    }
                ],
                "Subplan Name": "CTE precompute_1_0"
            },
            {
                "Node Type": "Precompute_0_0",
                "Parent Relationship": "InitPlan",
                "PlanNodeId": 7,
                "PlanNodeType": "Materialize",
                "Plans": [
                    {
                        "Node Type": "Collect",
                        "PlanNodeId": 6,
                        "Plans": [
                            {
                                "Node Type": "UnionAll",
                                "PlanNodeId": 5,
                                "PlanNodeType": "Connection",
                                "Plans": [
                                    {
                                        "Node Type": "TableFullScan",
                                        "Operators": [
                                            {
                                                "Inputs": [],
                                                "Name": "TableFullScan",
                                                "ReadColumns": [
                                                    "x1",
                                                    "x2"
                                                ],
                                                "ReadRanges": [
                                                    "x1 (-\u221e, +\u221e)",
                                                    "x2 (-\u221e, +\u221e)"
                                                ],
                                                "Scan": "Parallel",
                                                "Table": "postgres_jointest/join2.test_plan/x"
                                            }
                                        ],
                                        "Parent Relationship": "InitPlan",
                                        "PlanNodeId": 4,
                                        "Subplan Name": "CTE TableFullScan_5",
                                        "Tables": [
                                            "postgres_jointest/join2.test_plan/x"
                                        ]
                                    }
                                ]
                            }
                        ]
                    }
                ],
                "Subplan Name": "CTE precompute_0_0"
            },
            {
                "Node Type": "Precompute_0_1",
                "Parent Relationship": "InitPlan",
                "PlanNodeId": 3,
                "PlanNodeType": "Materialize",
                "Plans": [
                    {
                        "Node Type": "Collect",
                        "PlanNodeId": 2,
                        "Plans": [
                            {
                                "CTE Name": "TableFullScan_5",
                                "Node Type": "UnionAll",
                                "PlanNodeId": 1,
                                "PlanNodeType": "Connection"
                            }
                        ]
                    }
                ],
                "Subplan Name": "CTE precompute_0_1"
            }
        ]
    },
    "meta": {
        "type": "query",
        "version": "0.2"
    },
    "tables": [
        {
            "name": "/Root/postgres_jointest/join2.test_plan/x",
            "reads": [
                {
                    "columns": [
                        "x1",
                        "x2"
                    ],
                    "scan_by": [
                        "x1 (-\u221e, +\u221e)",
                        "x2 (-\u221e, +\u221e)"
                    ],
                    "type": "FullScan"
                }
            ]
        },
        {
            "name": "/Root/postgres_jointest/join2.test_plan/y",
            "reads": [
                {
                    "columns": [
                        "y1",
                        "y2"
                    ],
                    "type": "Scan"
                }
            ]
        }
    ]
}{
    "Plan": {
        "Node Type": "Query",
        "PlanNodeType": "Query",
        "Plans": [
            {
                "Node Type": "ResultSet",
                "PlanNodeId": 4,
                "PlanNodeType": "ResultSet",
                "Plans": [
                    {
                        "Node Type": "Limit",
                        "Operators": [
                            {
                                "Inputs": [
                                    {
                                        "ExternalPlanNodeId": 2
                                    }
                                ],
                                "Limit": "1001",
                                "Name": "Limit"
                            }
                        ],
                        "PlanNodeId": 3,
                        "Plans": [
                            {
                                "Node Type": "UnionAll",
                                "PlanNodeId": 2,
                                "PlanNodeType": "Connection",
                                "Plans": [
                                    {
                                        "Node Type": "Limit-TableRangeScan",
                                        "Operators": [
                                            {
                                                "Inputs": [
                                                    {
                                                        "InternalOperatorId": 1
                                                    }
                                                ],
                                                "Limit": "1001",
                                                "Name": "Limit"
                                            },
                                            {
                                                "Inputs": [],
                                                "Name": "TableRangeScan",
                                                "ReadColumns": [
                                                    "stringu1",
                                                    "unique1"
                                                ],
                                                "ReadLimit": "1001",
                                                "ReadRange": [
                                                    "unique1 (980, +\u221e)",
                                                    "unique2 (-\u221e, +\u221e)"
                                                ],
                                                "Scan": "Sequential",
                                                "Table": "postgres_select.test_plan/onek2"
                                            }
                                        ],
                                        "PlanNodeId": 1,
                                        "Tables": [
                                            "postgres_select.test_plan/onek2"
                                        ]
                                    }
                                ]
                            }
                        ]
                    }
                ]
            }
        ]
    },
    "meta": {
        "type": "query",
        "version": "0.2"
    },
    "tables": [
        {
            "name": "/Root/postgres_select.test_plan/onek2",
            "reads": [
                {
                    "columns": [
                        "stringu1",
                        "unique1"
                    ],
                    "limit": "1001",
                    "scan_by": [
                        "unique1 (980, +\u221e)",
                        "unique2 (-\u221e, +\u221e)"
                    ],
                    "type": "Scan"
                }
            ]
        }
    ]
}{
    "Plan": {
        "Node Type": "Query",
        "PlanNodeType": "Query",
        "Plans": []
    },
    "meta": {
        "type": "query",
        "version": "0.2"
    },
    "tables": []
}{
    "Plan": {
        "Node Type": "Query",
        "PlanNodeType": "Query",
        "Plans": [
            {
                "Node Type": "ResultSet",
                "PlanNodeId": 4,
                "PlanNodeType": "ResultSet",
                "Plans": [
                    {
                        "Node Type": "Limit",
                        "Operators": [
                            {
                                "Inputs": [
                                    {
                                        "ExternalPlanNodeId": 2
                                    }
                                ],
                                "Limit": "1001",
                                "Name": "Limit"
                            }
                        ],
                        "PlanNodeId": 3,
                        "Plans": [
                            {
                                "Node Type": "Merge",
                                "PlanNodeId": 2,
                                "PlanNodeType": "Connection",
                                "Plans": [
                                    {
                                        "Node Type": "TopSort-TableFullScan",
                                        "Operators": [
                                            {
                                                "Inputs": [
                                                    {
                                                        "InternalOperatorId": 1
                                                    }
                                                ],
                                                "Limit": "1001",
                                                "Name": "TopSort",
                                                "TopSortBy": ""
                                            },
                                            {
                                                "Inputs": [],
                                                "Name": "TableFullScan",
                                                "ReadColumns": [
                                                    "a",
                                                    "b",
                                                    "c",
                                                    "d"
                                                ],
                                                "ReadRanges": [
                                                    "a (-\u221e, +\u221e)",
                                                    "b (-\u221e, +\u221e)",
                                                    "c (-\u221e, +\u221e)",
                                                    "d (-\u221e, +\u221e)",
                                                    "e (-\u221e, +\u221e)"
                                                ],
                                                "Scan": "Parallel",
                                                "Table": "sqllogictest_select1-5.test_plan/t1"
                                            }
                                        ],
                                        "PlanNodeId": 1,
                                        "Tables": [
                                            "sqllogictest_select1-5.test_plan/t1"
                                        ]
                                    }
                                ],
                                "SortColumns": [
                                    "col1 (Asc)",
                                    "col2 (Asc)"
                                ]
                            }
                        ]
                    }
                ]
            }
        ]
    },
    "meta": {
        "type": "query",
        "version": "0.2"
    },
    "tables": [
        {
            "name": "/Root/sqllogictest_select1-5.test_plan/t1",
            "reads": [
                {
                    "columns": [
                        "a",
                        "b",
                        "c",
                        "d"
                    ],
                    "scan_by": [
                        "a (-\u221e, +\u221e)",
                        "b (-\u221e, +\u221e)",
                        "c (-\u221e, +\u221e)",
                        "d (-\u221e, +\u221e)",
                        "e (-\u221e, +\u221e)"
                    ],
                    "type": "FullScan"
                }
            ]
        }
    ]
}{
    "Plan": {
        "Node Type": "Query",
        "PlanNodeType": "Query",
        "Plans": [
            {
                "Node Type": "ResultSet",
                "PlanNodeId": 4,
                "PlanNodeType": "ResultSet",
                "Plans": [
                    {
                        "Node Type": "Limit",
                        "Operators": [
                            {
                                "Inputs": [
                                    {
                                        "ExternalPlanNodeId": 2
                                    }
                                ],
                                "Limit": "1001",
                                "Name": "Limit"
                            }
                        ],
                        "PlanNodeId": 3,
                        "Plans": [
                            {
                                "Node Type": "Merge",
                                "PlanNodeId": 2,
                                "PlanNodeType": "Connection",
                                "Plans": [
                                    {
                                        "Node Type": "TopSort-Filter-TableFullScan",
                                        "Operators": [
                                            {
                                                "Inputs": [
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    }
                                                ],
                                                "Limit": "1001",
                                                "Name": "TopSort",
                                                "TopSortBy": ""
                                            },
                                            {
                                                "Inputs": [
                                                    {
                                                        "InternalOperatorId": 2
                                                    }
                                                ],
                                                "Name": "Filter",
                                                "Predicate": "item.a > item.b - 2 And item.a < item.b + 2 And item.e > item.a And item.e < item.b And item.b > item.c"
                                            },
                                            {
                                                "Inputs": [],
                                                "Name": "TableFullScan",
                                                "ReadColumns": [
                                                    "a",
                                                    "b",
                                                    "c",
                                                    "d",
                                                    "e"
                                                ],
                                                "ReadRanges": [
                                                    "a (-\u221e, +\u221e)",
                                                    "b (-\u221e, +\u221e)",
                                                    "c (-\u221e, +\u221e)",
                                                    "d (-\u221e, +\u221e)",
                                                    "e (-\u221e, +\u221e)"
                                                ],
                                                "Scan": "Parallel",
                                                "Table": "sqllogictest_select3-1.test_plan/t1"
                                            }
                                        ],
                                        "PlanNodeId": 1,
                                        "Tables": [
                                            "sqllogictest_select3-1.test_plan/t1"
                                        ]
                                    }
                                ],
                                "SortColumns": [
                                    "col3 (Asc)",
                                    "col2 (Asc)",
                                    "col4 (Asc)",
                                    "col1 (Asc)"
                                ]
                            }
                        ]
                    }
                ]
            }
        ]
    },
    "meta": {
        "type": "query",
        "version": "0.2"
    },
    "tables": [
        {
            "name": "/Root/sqllogictest_select3-1.test_plan/t1",
            "reads": [
                {
                    "columns": [
                        "a",
                        "b",
                        "c",
                        "d",
                        "e"
                    ],
                    "scan_by": [
                        "a (-\u221e, +\u221e)",
                        "b (-\u221e, +\u221e)",
                        "c (-\u221e, +\u221e)",
                        "d (-\u221e, +\u221e)",
                        "e (-\u221e, +\u221e)"
                    ],
                    "type": "FullScan"
                }
            ]
        }
    ]
}{
    "Plan": {
        "Node Type": "Query",
        "PlanNodeType": "Query",
        "Plans": [
            {
                "Node Type": "ResultSet",
                "PlanNodeId": 4,
                "PlanNodeType": "ResultSet",
                "Plans": [
                    {
                        "Node Type": "Limit",
                        "Operators": [
                            {
                                "Inputs": [
                                    {
                                        "ExternalPlanNodeId": 2
                                    }
                                ],
                                "Limit": "1001",
                                "Name": "Limit"
                            }
                        ],
                        "PlanNodeId": 3,
                        "Plans": [
                            {
                                "Node Type": "Merge",
                                "PlanNodeId": 2,
                                "PlanNodeType": "Connection",
                                "Plans": [
                                    {
                                        "Node Type": "TopSort-Filter-TableFullScan",
                                        "Operators": [
                                            {
                                                "Inputs": [
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    }
                                                ],
                                                "Limit": "1001",
                                                "Name": "TopSort",
                                                "TopSortBy": ""
                                            },
                                            {
                                                "Inputs": [
                                                    {
                                                        "InternalOperatorId": 2
                                                    }
                                                ],
                                                "Name": "Filter",
                                                "Predicate": "item.e + item.d >= item.a + item.b - 10 And item.e + item.d <= item.c + 130 Or item.c > item.d Or item.d > item.e"
                                            },
                                            {
                                                "Inputs": [],
                                                "Name": "TableFullScan",
                                                "ReadColumns": [
                                                    "a",
                                                    "b",
                                                    "c",
                                                    "d",
                                                    "e"
                                                ],
                                                "ReadRanges": [
                                                    "a (-\u221e, +\u221e)",
                                                    "b (-\u221e, +\u221e)",
                                                    "c (-\u221e, +\u221e)",
                                                    "d (-\u221e, +\u221e)",
                                                    "e (-\u221e, +\u221e)"
                                                ],
                                                "Scan": "Parallel",
                                                "Table": "sqllogictest_select3-14.test_plan/t1"
                                            }
                                        ],
                                        "PlanNodeId": 1,
                                        "Tables": [
                                            "sqllogictest_select3-14.test_plan/t1"
                                        ]
                                    }
                                ],
                                "SortColumns": [
                                    "col2 (Asc)",
                                    "col1 (Asc)"
                                ]
                            }
                        ]
                    }
                ]
            }
        ]
    },
    "meta": {
        "type": "query",
        "version": "0.2"
    },
    "tables": [
        {
            "name": "/Root/sqllogictest_select3-14.test_plan/t1",
            "reads": [
                {
                    "columns": [
                        "a",
                        "b",
                        "c",
                        "d",
                        "e"
                    ],
                    "scan_by": [
                        "a (-\u221e, +\u221e)",
                        "b (-\u221e, +\u221e)",
                        "c (-\u221e, +\u221e)",
                        "d (-\u221e, +\u221e)",
                        "e (-\u221e, +\u221e)"
                    ],
                    "type": "FullScan"
                }
            ]
        }
    ]
}{
    "Plan": {
        "Node Type": "Query",
        "PlanNodeType": "Query",
        "Plans": [
            {
                "Node Type": "ResultSet",
                "PlanNodeId": 4,
                "PlanNodeType": "ResultSet",
                "Plans": [
                    {
                        "Node Type": "Limit",
                        "Operators": [
                            {
                                "Inputs": [
                                    {
                                        "ExternalPlanNodeId": 2
                                    }
                                ],
                                "Limit": "1001",
                                "Name": "Limit"
                            }
                        ],
                        "PlanNodeId": 3,
                        "Plans": [
                            {
                                "Node Type": "Merge",
                                "PlanNodeId": 2,
                                "PlanNodeType": "Connection",
                                "Plans": [
                                    {
                                        "Node Type": "TopSort-Filter-TableFullScan",
                                        "Operators": [
                                            {
                                                "Inputs": [
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    },
                                                    {
                                                        "InternalOperatorId": 1
                                                    }
                                                ],
                                                "Limit": "1001",
                                                "Name": "TopSort",
                                                "TopSortBy": ""
                                            },
                                            {
                                                "Inputs": [
                                                    {
                                                        "InternalOperatorId": 2
                                                    }
                                                ],
                                                "Name": "Filter",
                                                "Predicate": "item.c > item.d And item.d > item.e And item.a > item.b - 2 And item.a < item.b + 2"
                                            },
                                            {
                                                "Inputs": [],
                                                "Name": "TableFullScan",
                                                "ReadColumns": [
                                                    "a",
                                                    "b",
                                                    "c",
                                                    "d",
                                                    "e"
                                                ],
                                                "ReadRanges": [
                                                    "a (-\u221e, +\u221e)",
                                                    "b (-\u221e, +\u221e)",
                                                    "c (-\u221e, +\u221e)",
                                                    "d (-\u221e, +\u221e)",
                                                    "e (-\u221e, +\u221e)"
                                                ],
                                                "Scan": "Parallel",
                                                "Table": "sqllogictest_select3-5.test_plan/t1"
                                            }
                                        ],
                                        "PlanNodeId": 1,
                                        "Tables": [
                                            "sqllogictest_select3-5.test_plan/t1"
                                        ]
                                    }
                                ],
                                "SortColumns": [
                                    "col2 (Asc)",
                                    "col1 (Asc)"
                                ]
                            }
                        ]
                    }
                ]
            }
        ]
    },
    "meta": {
        "type": "query",
        "version": "0.2"
    },
    "tables": [
        {
            "name": "/Root/sqllogictest_select3-5.test_plan/t1",
            "reads": [
                {
                    "columns": [
                        "a",
                        "b",
                        "c",
                        "d",
                        "e"
                    ],
                    "scan_by": [
                        "a (-\u221e, +\u221e)",
                        "b (-\u221e, +\u221e)",
                        "c (-\u221e, +\u221e)",
                        "d (-\u221e, +\u221e)",
                        "e (-\u221e, +\u221e)"
                    ],
                    "type": "FullScan"
                }
            ]
        }
    ]
}{
    "Plan": {
        "Node Type": "Query",
        "PlanNodeType": "Query",
        "Plans": [
            {
                "Node Type": "ResultSet",
                "PlanNodeId": 4,
                "PlanNodeType": "ResultSet",
                "Plans": [
                    {
                        "Node Type": "Limit",
                        "Operators": [
                            {
                                "Inputs": [
                                    {
                                        "ExternalPlanNodeId": 2
                                    }
                                ],
                                "Limit": "1001",
                                "Name": "Limit"
                            }
                        ],
                        "PlanNodeId": 3,
                        "Plans": [
                            {
                                "Node Type": "Merge",
                                "PlanNodeId": 2,
                                "PlanNodeType": "Connection",
                                "Plans": [
                                    {
                                        "Node Type": "TopSort-TableFullScan",
                                        "Operators": [
                                            {
                                                "Inputs": [
                                                    {
                                                        "InternalOperatorId": 1
                                                    }
                                                ],
                                                "Limit": "1001",
                                                "Name": "TopSort",
                                                "TopSortBy": ""
                                            },
                                            {
                                                "Inputs": [],
                                                "Name": "TableFullScan",
                                                "ReadColumns": [
                                                    "a",
                                                    "b",
                                                    "c",
                                                    "d",
                                                    "e"
                                                ],
                                                "ReadRanges": [
                                                    "a (-\u221e, +\u221e)",
                                                    "b (-\u221e, +\u221e)",
                                                    "c (-\u221e, +\u221e)",
                                                    "d (-\u221e, +\u221e)",
                                                    "e (-\u221e, +\u221e)"
                                                ],
                                                "Scan": "Parallel",
                                                "Table": "sqllogictest_select3-9.test_plan/t1"
                                            }
                                        ],
                                        "PlanNodeId": 1,
                                        "Tables": [
                                            "sqllogictest_select3-9.test_plan/t1"
                                        ]
                                    }
                                ],
                                "SortColumns": [
                                    "col4 (Asc)",
                                    "col5 (Asc)",
                                    "col2 (Asc)",
                                    "col6 (Asc)",
                                    "col7 (Asc)",
                                    "col3 (Asc)",
                                    "col1 (Asc)"
                                ]
                            }
                        ]
                    }
                ]
            }
        ]
    },
    "meta": {
        "type": "query",
        "version": "0.2"
    },
    "tables": [
        {
            "name": "/Root/sqllogictest_select3-9.test_plan/t1",
            "reads": [
                {
                    "columns": [
                        "a",
                        "b",
                        "c",
                        "d",
                        "e"
                    ],
                    "scan_by": [
                        "a (-\u221e, +\u221e)",
                        "b (-\u221e, +\u221e)",
                        "c (-\u221e, +\u221e)",
                        "d (-\u221e, +\u221e)",
                        "e (-\u221e, +\u221e)"
                    ],
                    "type": "FullScan"
                }
            ]
        }
    ]
}