{
    "Plan": {
        "Node Type": "Query",
        "PlanNodeType": "Query",
        "Plans": [
            {
                "Node Type": "ResultSet_1",
                "PlanNodeId": 13,
                "PlanNodeType": "ResultSet",
                "Plans": [
                    {
                        "Node Type": "Limit",
                        "Operators": [
                            {
                                "Inputs": [
                                    {
                                        "ExternalPlanNodeId": 11
                                    }
                                ],
                                "Limit": "1001",
                                "Name": "Limit"
                            }
                        ],
                        "PlanNodeId": 12,
                        "Plans": [
                            {
                                "Node Type": "Merge",
                                "PlanNodeId": 11,
                                "PlanNodeType": "Connection",
                                "Plans": [
                                    {
                                        "Node Type": "TopSort-CrossJoin",
                                        "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
                                                    },
                                                    {
                                                        "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": [
                                                    {
                                                        "ExternalPlanNodeId": 9
                                                    },
                                                    {
                                                        "ExternalPlanNodeId": 7
                                                    }
                                                ],
                                                "Name": "CrossJoin"
                                            }
                                        ],
                                        "PlanNodeId": 10,
                                        "Plans": [
                                            {
                                                "Node Type": "Map",
                                                "PlanNodeId": 9,
                                                "PlanNodeType": "Connection",
                                                "Plans": [
                                                    {
                                                        "Node Type": "Filter-TableFullScan",
                                                        "Operators": [
                                                            {
                                                                "Inputs": [
                                                                    {
                                                                        "InternalOperatorId": 1
                                                                    }
                                                                ],
                                                                "Name": "Filter",
                                                                "Predicate": "item.b > item.c And item.a > item.b"
                                                            },
                                                            {
                                                                "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_select1-4.test_plan/t1"
                                                            }
                                                        ],
                                                        "PlanNodeId": 8,
                                                        "Tables": [
                                                            "sqllogictest_select1-4.test_plan/t1"
                                                        ]
                                                    }
                                                ]
                                            },
                                            {
                                                "Node Type": "Broadcast",
                                                "PlanNodeId": 7,
                                                "PlanNodeType": "Connection",
                                                "Plans": [
                                                    {
                                                        "CTE Name": "precompute_0_0",
                                                        "Node Type": "ConstantExpr",
                                                        "Operators": [
                                                            {
                                                                "Inputs": [],
                                                                "Iterator": "precompute_0_0",
                                                                "Name": "Iterator"
                                                            }
                                                        ],
                                                        "PlanNodeId": 6
                                                    }
                                                ]
                                            }
                                        ]
                                    }
                                ],
                                "SortColumns": [
                                    "col3 (Asc)",
                                    "col4 (Asc)",
                                    "col2 (Asc)",
                                    "col5 (Asc)",
                                    "col1 (Asc)"
                                ]
                            }
                        ]
                    }
                ]
            },
            {
                "Node Type": "Precompute_0",
                "Parent Relationship": "InitPlan",
                "PlanNodeId": 4,
                "PlanNodeType": "Materialize",
                "Plans": [
                    {
                        "Node Type": "Aggregate-Limit",
                        "Operators": [
                            {
                                "Inputs": [
                                    {
                                        "InternalOperatorId": 1
                                    }
                                ],
                                "Name": "Aggregate"
                            },
                            {
                                "Inputs": [
                                    {
                                        "ExternalPlanNodeId": 2
                                    }
                                ],
                                "Limit": "1",
                                "Name": "Limit"
                            }
                        ],
                        "PlanNodeId": 3,
                        "Plans": [
                            {
                                "Node Type": "UnionAll",
                                "PlanNodeId": 2,
                                "PlanNodeType": "Connection",
                                "Plans": [
                                    {
                                        "Node Type": "Aggregate-TableFullScan",
                                        "Operators": [
                                            {
                                                "Inputs": [
                                                    {
                                                        "InternalOperatorId": 1
                                                    }
                                                ],
                                                "Name": "Aggregate"
                                            },
                                            {
                                                "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_select1-4.test_plan/t1"
                                            }
                                        ],
                                        "PlanNodeId": 1,
                                        "Tables": [
                                            "sqllogictest_select1-4.test_plan/t1"
                                        ]
                                    }
                                ]
                            }
                        ]
                    }
                ],
                "Subplan Name": "CTE precompute_0_0"
            }
        ]
    },
    "meta": {
        "type": "query",
        "version": "0.2"
    },
    "tables": [
        {
            "name": "/Root/sqllogictest_select1-4.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"
                },
                {
                    "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
                                                    }
                                                ],
                                                "Limit": "1001",
                                                "Name": "TopSort",
                                                "TopSortBy": "row.col1"
                                            },
                                            {
                                                "Inputs": [
                                                    {
                                                        "InternalOperatorId": 2
                                                    }
                                                ],
                                                "Name": "Filter",
                                                "Predicate": "item.d < 110 Or item.d > 150 And item.c > item.d And item.b > item.c"
                                            },
                                            {
                                                "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_select3-1.test_plan/t1"
                                            }
                                        ],
                                        "PlanNodeId": 1,
                                        "Tables": [
                                            "sqllogictest_select3-1.test_plan/t1"
                                        ]
                                    }
                                ],
                                "SortColumns": [
                                    "col1 (Asc)"
                                ]
                            }
                        ]
                    }
                ]
            }
        ]
    },
    "meta": {
        "type": "query",
        "version": "0.2"
    },
    "tables": [
        {
            "name": "/Root/sqllogictest_select3-1.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
                                                    }
                                                ],
                                                "Limit": "1001",
                                                "Name": "TopSort",
                                                "TopSortBy": "row.col1"
                                            },
                                            {
                                                "Inputs": [
                                                    {
                                                        "InternalOperatorId": 2
                                                    }
                                                ],
                                                "Name": "Filter",
                                                "Predicate": "item.e > item.c Or item.e < item.d And item.d < 110 Or item.d > 150 And item.c >= item.b - 2 And item.c <= item.d + 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-12.test_plan/t1"
                                            }
                                        ],
                                        "PlanNodeId": 1,
                                        "Tables": [
                                            "sqllogictest_select3-12.test_plan/t1"
                                        ]
                                    }
                                ],
                                "SortColumns": [
                                    "col1 (Asc)"
                                ]
                            }
                        ]
                    }
                ]
            }
        ]
    },
    "meta": {
        "type": "query",
        "version": "0.2"
    },
    "tables": [
        {
            "name": "/Root/sqllogictest_select3-12.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-3.test_plan/t1"
                                            }
                                        ],
                                        "PlanNodeId": 1,
                                        "Tables": [
                                            "sqllogictest_select3-3.test_plan/t1"
                                        ]
                                    }
                                ],
                                "SortColumns": [
                                    "col6 (Asc)",
                                    "col7 (Asc)",
                                    "col4 (Asc)",
                                    "col5 (Asc)",
                                    "col2 (Asc)",
                                    "col3 (Asc)",
                                    "col1 (Asc)"
                                ]
                            }
                        ]
                    }
                ]
            }
        ]
    },
    "meta": {
        "type": "query",
        "version": "0.2"
    },
    "tables": [
        {
            "name": "/Root/sqllogictest_select3-3.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": "argument.b"
                                            },
                                            {
                                                "Inputs": [],
                                                "Name": "TableFullScan",
                                                "ReadColumns": [
                                                    "b"
                                                ],
                                                "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": [
                                    "b (Asc)"
                                ]
                            }
                        ]
                    }
                ]
            }
        ]
    },
    "meta": {
        "type": "query",
        "version": "0.2"
    },
    "tables": [
        {
            "name": "/Root/sqllogictest_select3-9.test_plan/t1",
            "reads": [
                {
                    "columns": [
                        "b"
                    ],
                    "scan_by": [
                        "a (-\u221e, +\u221e)",
                        "b (-\u221e, +\u221e)",
                        "c (-\u221e, +\u221e)",
                        "d (-\u221e, +\u221e)",
                        "e (-\u221e, +\u221e)"
                    ],
                    "type": "FullScan"
                }
            ]
        }
    ]
}