{
    "requestID": "69ccd6bc-a960-4dfe-a474-c495bd4991b5",
    "signature": "json",
    "results": [
        {
            "plan": {
                "#operator": "Sequence",
                "~children": [
                    {
                        "#operator": "Sequence",
                        "~children": [
                            {
                                "#operator": "IntersectScan",
                                "scans": [
                                    {
                                        "#operator": "IndexScan3",
                                        "as": "t_5",
                                        "index": "simple_table_3_int_field1",
                                        "index_id": "c5941a70244f3958",
                                        "index_projection": {
                                            "primary_key": true
                                        },
                                        "keyspace": "multiple_table_db_35247585_simple_table_3",
                                        "namespace": "default",
                                        "spans": [
                                            {
                                                "exact": true,
                                                "range": [
                                                    {
                                                        "inclusion": 0,
                                                        "low": "null"
                                                    }
                                                ]
                                            }
                                        ],
                                        "using": "gsi"
                                    },
                                    {
                                        "#operator": "IndexScan3",
                                        "as": "t_5",
                                        "index": "simple_table_3_char_field1",
                                        "index_id": "b36326e255b8d4d4",
                                        "index_projection": {
                                            "primary_key": true
                                        },
                                        "keyspace": "multiple_table_db_35247585_simple_table_3",
                                        "namespace": "default",
                                        "spans": [
                                            {
                                                "exact": true,
                                                "range": [
                                                    {
                                                        "inclusion": 0,
                                                        "low": "null"
                                                    }
                                                ]
                                            }
                                        ],
                                        "using": "gsi"
                                    }
                                ]
                            },
                            {
                                "#operator": "Fetch",
                                "as": "t_5",
                                "keyspace": "multiple_table_db_35247585_simple_table_3",
                                "namespace": "default"
                            },
                            {
                                "#operator": "Parallel",
                                "~child": {
                                    "#operator": "Sequence",
                                    "~children": [
                                        {
                                            "#operator": "NestedLoopJoin",
                                            "alias": "t_1",
                                            "on_clause": "(((`t_5`.`char_field1`) = (`t_1`.`char_field1`)) and ((`t_5`.`int_field1`) < (`t_1`.`int_field1`)))",
                                            "~child": {
                                                "#operator": "Sequence",
                                                "~children": [
                                                    {
                                                        "#operator": "IntersectScan",
                                                        "scans": [
                                                            {
                                                                "#operator": "IndexScan3",
                                                                "as": "t_1",
                                                                "index": "simple_table_2_char_field1",
                                                                "index_id": "9990e8b16ec80efd",
                                                                "index_projection": {
                                                                    "primary_key": true
                                                                },
                                                                "keyspace": "multiple_table_db_35247585_simple_table_2",
                                                                "namespace": "default",
                                                                "nested_loop": true,
                                                                "spans": [
                                                                    {
                                                                        "exact": true,
                                                                        "range": [
                                                                            {
                                                                                "high": "(`t_5`.`char_field1`)",
                                                                                "inclusion": 3,
                                                                                "low": "(`t_5`.`char_field1`)"
                                                                            }
                                                                        ]
                                                                    }
                                                                ],
                                                                "using": "gsi"
                                                            },
                                                            {
                                                                "#operator": "IndexScan3",
                                                                "as": "t_1",
                                                                "index": "simple_table_2_int_field1",
                                                                "index_id": "e695087bccd05c0f",
                                                                "index_projection": {
                                                                    "primary_key": true
                                                                },
                                                                "keyspace": "multiple_table_db_35247585_simple_table_2",
                                                                "namespace": "default",
                                                                "nested_loop": true,
                                                                "spans": [
                                                                    {
                                                                        "exact": true,
                                                                        "range": [
                                                                            {
                                                                                "inclusion": 0,
                                                                                "low": "(`t_5`.`int_field1`)"
                                                                            }
                                                                        ]
                                                                    }
                                                                ],
                                                                "using": "gsi"
                                                            }
                                                        ]
                                                    },
                                                    {
                                                        "#operator": "Fetch",
                                                        "as": "t_1",
                                                        "keyspace": "multiple_table_db_35247585_simple_table_2",
                                                        "namespace": "default",
                                                        "nested_loop": true
                                                    }
                                                ]
                                            }
                                        },
                                        {
                                            "#operator": "NestedLoopJoin",
                                            "alias": "t_3",
                                            "on_clause": "(((`t_5`.`decimal_field1`) = (`t_3`.`decimal_field1`)) and ((`t_5`.`varchar_field1`) = (`t_3`.`varchar_field1`)))",
                                            "outer": true,
                                            "~child": {
                                                "#operator": "Sequence",
                                                "~children": [
                                                    {
                                                        "#operator": "IntersectScan",
                                                        "scans": [
                                                            {
                                                                "#operator": "IndexScan3",
                                                                "as": "t_3",
                                                                "index": "simple_table_1_varchar_field1",
                                                                "index_id": "bf7228e61fb324c5",
                                                                "index_projection": {
                                                                    "primary_key": true
                                                                },
                                                                "keyspace": "multiple_table_db_35247585_simple_table_1",
                                                                "namespace": "default",
                                                                "nested_loop": true,
                                                                "spans": [
                                                                    {
                                                                        "exact": true,
                                                                        "range": [
                                                                            {
                                                                                "high": "(`t_5`.`varchar_field1`)",
                                                                                "inclusion": 3,
                                                                                "low": "(`t_5`.`varchar_field1`)"
                                                                            }
                                                                        ]
                                                                    }
                                                                ],
                                                                "using": "gsi"
                                                            },
                                                            {
                                                                "#operator": "IndexScan3",
                                                                "as": "t_3",
                                                                "index": "simple_table_1_decimal_field1",
                                                                "index_id": "6d441f2cad4b0c7a",
                                                                "index_projection": {
                                                                    "primary_key": true
                                                                },
                                                                "keyspace": "multiple_table_db_35247585_simple_table_1",
                                                                "namespace": "default",
                                                                "nested_loop": true,
                                                                "spans": [
                                                                    {
                                                                        "exact": true,
                                                                        "range": [
                                                                            {
                                                                                "high": "(`t_5`.`decimal_field1`)",
                                                                                "inclusion": 3,
                                                                                "low": "(`t_5`.`decimal_field1`)"
                                                                            }
                                                                        ]
                                                                    }
                                                                ],
                                                                "using": "gsi"
                                                            }
                                                        ]
                                                    },
                                                    {
                                                        "#operator": "Fetch",
                                                        "as": "t_3",
                                                        "keyspace": "multiple_table_db_35247585_simple_table_1",
                                                        "namespace": "default",
                                                        "nested_loop": true
                                                    }
                                                ]
                                            }
                                        },
                                        {
                                            "#operator": "NestedLoopJoin",
                                            "alias": "t_2",
                                            "on_clause": "((((`t_3`.`int_field1`) = (`t_2`.`int_field1`)) and ((`t_3`.`varchar_field1`) = (`t_2`.`varchar_field1`))) and ((`t_3`.`int_field1`) = (`t_2`.`int_field1`)))",
                                            "outer": true,
                                            "~child": {
                                                "#operator": "Sequence",
                                                "~children": [
                                                    {
                                                        "#operator": "IntersectScan",
                                                        "scans": [
                                                            {
                                                                "#operator": "IndexScan3",
                                                                "as": "t_2",
                                                                "index": "simple_table_4_varchar_field1",
                                                                "index_id": "8279896a4726bea2",
                                                                "index_projection": {
                                                                    "primary_key": true
                                                                },
                                                                "keyspace": "multiple_table_db_35247585_simple_table_4",
                                                                "namespace": "default",
                                                                "nested_loop": true,
                                                                "spans": [
                                                                    {
                                                                        "exact": true,
                                                                        "range": [
                                                                            {
                                                                                "high": "(`t_3`.`varchar_field1`)",
                                                                                "inclusion": 3,
                                                                                "low": "(`t_3`.`varchar_field1`)"
                                                                            }
                                                                        ]
                                                                    }
                                                                ],
                                                                "using": "gsi"
                                                            },
                                                            {
                                                                "#operator": "IndexScan3",
                                                                "as": "t_2",
                                                                "index": "simple_table_4_int_field1",
                                                                "index_id": "62fbfdcd96f9b6b7",
                                                                "index_projection": {
                                                                    "primary_key": true
                                                                },
                                                                "keyspace": "multiple_table_db_35247585_simple_table_4",
                                                                "namespace": "default",
                                                                "nested_loop": true,
                                                                "spans": [
                                                                    {
                                                                        "range": [
                                                                            {
                                                                                "high": "(`t_3`.`int_field1`)",
                                                                                "inclusion": 3,
                                                                                "low": "(`t_3`.`int_field1`)"
                                                                            }
                                                                        ]
                                                                    }
                                                                ],
                                                                "using": "gsi"
                                                            }
                                                        ]
                                                    },
                                                    {
                                                        "#operator": "Fetch",
                                                        "as": "t_2",
                                                        "keyspace": "multiple_table_db_35247585_simple_table_4",
                                                        "namespace": "default",
                                                        "nested_loop": true
                                                    }
                                                ]
                                            }
                                        },
                                        {
                                            "#operator": "NestedLoopJoin",
                                            "alias": "t_4",
                                            "on_clause": "(not ((((`t_5`.`decimal_field1`) = (`t_4`.`decimal_field1`)) and ((`t_5`.`varchar_field1`) = (`t_4`.`varchar_field1`))) and ((`t_5`.`varchar_field1`) = (`t_4`.`varchar_field1`))))",
                                            "outer": true,
                                            "~child": {
                                                "#operator": "Sequence",
                                                "~children": [
                                                    {
                                                        "#operator": "UnionScan",
                                                        "scans": [
                                                            {
                                                                "#operator": "IntersectScan",
                                                                "scans": [
                                                                    {
                                                                        "#operator": "IndexScan3",
                                                                        "as": "t_4",
                                                                        "index": "simple_table_10_bool_field1",
                                                                        "index_id": "d24ff325ba902a44",
                                                                        "index_projection": {
                                                                            "primary_key": true
                                                                        },
                                                                        "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                        "namespace": "default",
                                                                        "nested_loop": true,
                                                                        "spans": [
                                                                            {
                                                                                "exact": true,
                                                                                "range": [
                                                                                    {
                                                                                        "high": "true",
                                                                                        "inclusion": 0,
                                                                                        "low": "null"
                                                                                    }
                                                                                ]
                                                                            }
                                                                        ],
                                                                        "using": "gsi"
                                                                    },
                                                                    {
                                                                        "#operator": "IndexScan3",
                                                                        "as": "t_4",
                                                                        "index": "simple_table_10_decimal_field1",
                                                                        "index_id": "5cfd6093c76b9272",
                                                                        "index_projection": {
                                                                            "primary_key": true
                                                                        },
                                                                        "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                        "namespace": "default",
                                                                        "nested_loop": true,
                                                                        "spans": [
                                                                            {
                                                                                "exact": true,
                                                                                "range": [
                                                                                    {
                                                                                        "inclusion": 0,
                                                                                        "low": "(`t_5`.`decimal_field1`)"
                                                                                    }
                                                                                ]
                                                                            }
                                                                        ],
                                                                        "using": "gsi"
                                                                    }
                                                                ]
                                                            },
                                                            {
                                                                "#operator": "IntersectScan",
                                                                "scans": [
                                                                    {
                                                                        "#operator": "IndexScan3",
                                                                        "as": "t_4",
                                                                        "index": "simple_table_10_decimal_field1",
                                                                        "index_id": "5cfd6093c76b9272",
                                                                        "index_projection": {
                                                                            "primary_key": true
                                                                        },
                                                                        "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                        "namespace": "default",
                                                                        "nested_loop": true,
                                                                        "spans": [
                                                                            {
                                                                                "exact": true,
                                                                                "range": [
                                                                                    {
                                                                                        "high": "(`t_5`.`decimal_field1`)",
                                                                                        "inclusion": 0,
                                                                                        "low": "null"
                                                                                    }
                                                                                ]
                                                                            }
                                                                        ],
                                                                        "using": "gsi"
                                                                    },
                                                                    {
                                                                        "#operator": "IndexScan3",
                                                                        "as": "t_4",
                                                                        "index": "simple_table_10_bool_field1",
                                                                        "index_id": "d24ff325ba902a44",
                                                                        "index_projection": {
                                                                            "primary_key": true
                                                                        },
                                                                        "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                        "namespace": "default",
                                                                        "nested_loop": true,
                                                                        "spans": [
                                                                            {
                                                                                "exact": true,
                                                                                "range": [
                                                                                    {
                                                                                        "high": "true",
                                                                                        "inclusion": 0,
                                                                                        "low": "null"
                                                                                    }
                                                                                ]
                                                                            }
                                                                        ],
                                                                        "using": "gsi"
                                                                    }
                                                                ]
                                                            },
                                                            {
                                                                "#operator": "IntersectScan",
                                                                "scans": [
                                                                    {
                                                                        "#operator": "IndexScan3",
                                                                        "as": "t_4",
                                                                        "index": "simple_table_10_bool_field1",
                                                                        "index_id": "d24ff325ba902a44",
                                                                        "index_projection": {
                                                                            "primary_key": true
                                                                        },
                                                                        "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                        "namespace": "default",
                                                                        "nested_loop": true,
                                                                        "spans": [
                                                                            {
                                                                                "exact": true,
                                                                                "range": [
                                                                                    {
                                                                                        "high": "true",
                                                                                        "inclusion": 0,
                                                                                        "low": "null"
                                                                                    }
                                                                                ]
                                                                            }
                                                                        ],
                                                                        "using": "gsi"
                                                                    },
                                                                    {
                                                                        "#operator": "IndexScan3",
                                                                        "as": "t_4",
                                                                        "index": "simple_table_10_varchar_field1",
                                                                        "index_id": "7915a9e2c7783265",
                                                                        "index_projection": {
                                                                            "primary_key": true
                                                                        },
                                                                        "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                        "namespace": "default",
                                                                        "nested_loop": true,
                                                                        "spans": [
                                                                            {
                                                                                "exact": true,
                                                                                "range": [
                                                                                    {
                                                                                        "inclusion": 0,
                                                                                        "low": "(`t_5`.`varchar_field1`)"
                                                                                    }
                                                                                ]
                                                                            }
                                                                        ],
                                                                        "using": "gsi"
                                                                    }
                                                                ]
                                                            },
                                                            {
                                                                "#operator": "IntersectScan",
                                                                "scans": [
                                                                    {
                                                                        "#operator": "IndexScan3",
                                                                        "as": "t_4",
                                                                        "index": "simple_table_10_bool_field1",
                                                                        "index_id": "d24ff325ba902a44",
                                                                        "index_projection": {
                                                                            "primary_key": true
                                                                        },
                                                                        "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                        "namespace": "default",
                                                                        "nested_loop": true,
                                                                        "spans": [
                                                                            {
                                                                                "exact": true,
                                                                                "range": [
                                                                                    {
                                                                                        "high": "true",
                                                                                        "inclusion": 0,
                                                                                        "low": "null"
                                                                                    }
                                                                                ]
                                                                            }
                                                                        ],
                                                                        "using": "gsi"
                                                                    },
                                                                    {
                                                                        "#operator": "IndexScan3",
                                                                        "as": "t_4",
                                                                        "index": "simple_table_10_varchar_field1",
                                                                        "index_id": "7915a9e2c7783265",
                                                                        "index_projection": {
                                                                            "primary_key": true
                                                                        },
                                                                        "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                        "namespace": "default",
                                                                        "nested_loop": true,
                                                                        "spans": [
                                                                            {
                                                                                "exact": true,
                                                                                "range": [
                                                                                    {
                                                                                        "high": "(`t_5`.`varchar_field1`)",
                                                                                        "inclusion": 0,
                                                                                        "low": "null"
                                                                                    }
                                                                                ]
                                                                            }
                                                                        ],
                                                                        "using": "gsi"
                                                                    }
                                                                ]
                                                            },
                                                            {
                                                                "#operator": "IntersectScan",
                                                                "scans": [
                                                                    {
                                                                        "#operator": "IndexScan3",
                                                                        "as": "t_4",
                                                                        "index": "simple_table_10_bool_field1",
                                                                        "index_id": "d24ff325ba902a44",
                                                                        "index_projection": {
                                                                            "primary_key": true
                                                                        },
                                                                        "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                        "namespace": "default",
                                                                        "nested_loop": true,
                                                                        "spans": [
                                                                            {
                                                                                "exact": true,
                                                                                "range": [
                                                                                    {
                                                                                        "inclusion": 0,
                                                                                        "low": "true"
                                                                                    }
                                                                                ]
                                                                            }
                                                                        ],
                                                                        "using": "gsi"
                                                                    },
                                                                    {
                                                                        "#operator": "IndexScan3",
                                                                        "as": "t_4",
                                                                        "index": "simple_table_10_decimal_field1",
                                                                        "index_id": "5cfd6093c76b9272",
                                                                        "index_projection": {
                                                                            "primary_key": true
                                                                        },
                                                                        "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                        "namespace": "default",
                                                                        "nested_loop": true,
                                                                        "spans": [
                                                                            {
                                                                                "exact": true,
                                                                                "range": [
                                                                                    {
                                                                                        "inclusion": 0,
                                                                                        "low": "(`t_5`.`decimal_field1`)"
                                                                                    }
                                                                                ]
                                                                            }
                                                                        ],
                                                                        "using": "gsi"
                                                                    }
                                                                ]
                                                            },
                                                            {
                                                                "#operator": "IntersectScan",
                                                                "scans": [
                                                                    {
                                                                        "#operator": "IndexScan3",
                                                                        "as": "t_4",
                                                                        "index": "simple_table_10_decimal_field1",
                                                                        "index_id": "5cfd6093c76b9272",
                                                                        "index_projection": {
                                                                            "primary_key": true
                                                                        },
                                                                        "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                        "namespace": "default",
                                                                        "nested_loop": true,
                                                                        "spans": [
                                                                            {
                                                                                "exact": true,
                                                                                "range": [
                                                                                    {
                                                                                        "high": "(`t_5`.`decimal_field1`)",
                                                                                        "inclusion": 0,
                                                                                        "low": "null"
                                                                                    }
                                                                                ]
                                                                            }
                                                                        ],
                                                                        "using": "gsi"
                                                                    },
                                                                    {
                                                                        "#operator": "IndexScan3",
                                                                        "as": "t_4",
                                                                        "index": "simple_table_10_bool_field1",
                                                                        "index_id": "d24ff325ba902a44",
                                                                        "index_projection": {
                                                                            "primary_key": true
                                                                        },
                                                                        "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                        "namespace": "default",
                                                                        "nested_loop": true,
                                                                        "spans": [
                                                                            {
                                                                                "exact": true,
                                                                                "range": [
                                                                                    {
                                                                                        "inclusion": 0,
                                                                                        "low": "true"
                                                                                    }
                                                                                ]
                                                                            }
                                                                        ],
                                                                        "using": "gsi"
                                                                    }
                                                                ]
                                                            },
                                                            {
                                                                "#operator": "IntersectScan",
                                                                "scans": [
                                                                    {
                                                                        "#operator": "IndexScan3",
                                                                        "as": "t_4",
                                                                        "index": "simple_table_10_bool_field1",
                                                                        "index_id": "d24ff325ba902a44",
                                                                        "index_projection": {
                                                                            "primary_key": true
                                                                        },
                                                                        "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                        "namespace": "default",
                                                                        "nested_loop": true,
                                                                        "spans": [
                                                                            {
                                                                                "exact": true,
                                                                                "range": [
                                                                                    {
                                                                                        "inclusion": 0,
                                                                                        "low": "true"
                                                                                    }
                                                                                ]
                                                                            }
                                                                        ],
                                                                        "using": "gsi"
                                                                    },
                                                                    {
                                                                        "#operator": "IndexScan3",
                                                                        "as": "t_4",
                                                                        "index": "simple_table_10_varchar_field1",
                                                                        "index_id": "7915a9e2c7783265",
                                                                        "index_projection": {
                                                                            "primary_key": true
                                                                        },
                                                                        "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                        "namespace": "default",
                                                                        "nested_loop": true,
                                                                        "spans": [
                                                                            {
                                                                                "exact": true,
                                                                                "range": [
                                                                                    {
                                                                                        "inclusion": 0,
                                                                                        "low": "(`t_5`.`varchar_field1`)"
                                                                                    }
                                                                                ]
                                                                            }
                                                                        ],
                                                                        "using": "gsi"
                                                                    }
                                                                ]
                                                            },
                                                            {
                                                                "#operator": "IntersectScan",
                                                                "scans": [
                                                                    {
                                                                        "#operator": "IndexScan3",
                                                                        "as": "t_4",
                                                                        "index": "simple_table_10_varchar_field1",
                                                                        "index_id": "7915a9e2c7783265",
                                                                        "index_projection": {
                                                                            "primary_key": true
                                                                        },
                                                                        "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                        "namespace": "default",
                                                                        "nested_loop": true,
                                                                        "spans": [
                                                                            {
                                                                                "exact": true,
                                                                                "range": [
                                                                                    {
                                                                                        "high": "(`t_5`.`varchar_field1`)",
                                                                                        "inclusion": 0,
                                                                                        "low": "null"
                                                                                    }
                                                                                ]
                                                                            }
                                                                        ],
                                                                        "using": "gsi"
                                                                    },
                                                                    {
                                                                        "#operator": "IndexScan3",
                                                                        "as": "t_4",
                                                                        "index": "simple_table_10_bool_field1",
                                                                        "index_id": "d24ff325ba902a44",
                                                                        "index_projection": {
                                                                            "primary_key": true
                                                                        },
                                                                        "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                        "namespace": "default",
                                                                        "nested_loop": true,
                                                                        "spans": [
                                                                            {
                                                                                "exact": true,
                                                                                "range": [
                                                                                    {
                                                                                        "inclusion": 0,
                                                                                        "low": "true"
                                                                                    }
                                                                                ]
                                                                            }
                                                                        ],
                                                                        "using": "gsi"
                                                                    }
                                                                ]
                                                            },
                                                            {
                                                                "#operator": "IndexScan3",
                                                                "as": "t_4",
                                                                "index": "simple_table_10_decimal_field1",
                                                                "index_id": "5cfd6093c76b9272",
                                                                "index_projection": {
                                                                    "primary_key": true
                                                                },
                                                                "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                "namespace": "default",
                                                                "nested_loop": true,
                                                                "spans": [
                                                                    {
                                                                        "exact": true,
                                                                        "range": [
                                                                            {
                                                                                "inclusion": 0,
                                                                                "low": "(`t_5`.`decimal_field1`)"
                                                                            }
                                                                        ]
                                                                    }
                                                                ],
                                                                "using": "gsi"
                                                            },
                                                            {
                                                                "#operator": "IndexScan3",
                                                                "as": "t_4",
                                                                "index": "simple_table_10_decimal_field1",
                                                                "index_id": "5cfd6093c76b9272",
                                                                "index_projection": {
                                                                    "primary_key": true
                                                                },
                                                                "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                "namespace": "default",
                                                                "nested_loop": true,
                                                                "spans": [
                                                                    {
                                                                        "exact": true,
                                                                        "range": [
                                                                            {
                                                                                "high": "(`t_5`.`decimal_field1`)",
                                                                                "inclusion": 0,
                                                                                "low": "null"
                                                                            }
                                                                        ]
                                                                    }
                                                                ],
                                                                "using": "gsi"
                                                            },
                                                            {
                                                                "#operator": "IndexScan3",
                                                                "as": "t_4",
                                                                "index": "simple_table_10_varchar_field1",
                                                                "index_id": "7915a9e2c7783265",
                                                                "index_projection": {
                                                                    "primary_key": true
                                                                },
                                                                "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                "namespace": "default",
                                                                "nested_loop": true,
                                                                "spans": [
                                                                    {
                                                                        "exact": true,
                                                                        "range": [
                                                                            {
                                                                                "inclusion": 0,
                                                                                "low": "(`t_5`.`varchar_field1`)"
                                                                            }
                                                                        ]
                                                                    }
                                                                ],
                                                                "using": "gsi"
                                                            },
                                                            {
                                                                "#operator": "IndexScan3",
                                                                "as": "t_4",
                                                                "index": "simple_table_10_varchar_field1",
                                                                "index_id": "7915a9e2c7783265",
                                                                "index_projection": {
                                                                    "primary_key": true
                                                                },
                                                                "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                                "namespace": "default",
                                                                "nested_loop": true,
                                                                "spans": [
                                                                    {
                                                                        "exact": true,
                                                                        "range": [
                                                                            {
                                                                                "high": "(`t_5`.`varchar_field1`)",
                                                                                "inclusion": 0,
                                                                                "low": "null"
                                                                            }
                                                                        ]
                                                                    }
                                                                ],
                                                                "using": "gsi"
                                                            }
                                                        ]
                                                    },
                                                    {
                                                        "#operator": "Fetch",
                                                        "as": "t_4",
                                                        "keyspace": "multiple_table_db_35247585_simple_table_10",
                                                        "namespace": "default",
                                                        "nested_loop": true
                                                    }
                                                ]
                                            }
                                        },
                                        {
                                            "#operator": "NestedLoopJoin",
                                            "alias": "t_2JWzwoYaSrR",
                                            "on_clause": "(((`t_3`.`primary_key_id`) = cover ((`t_2JWzwoYaSrR`.`primary_key_id`))) and (not (not ((`t_3`.`int_field1`) = cover ((`t_2JWzwoYaSrR`.`int_field1`))))))",
                                            "~child": {
                                                "#operator": "Sequence",
                                                "~children": [
                                                    {
                                                        "#operator": "IndexScan3",
                                                        "as": "t_2JWzwoYaSrR",
                                                        "covers": [
                                                            "cover ((`t_2JWzwoYaSrR`.`primary_key_id`))",
                                                            "cover ((`t_2JWzwoYaSrR`.`bool_field1`))",
                                                            "cover ((`t_2JWzwoYaSrR`.`char_field1`))",
                                                            "cover ((`t_2JWzwoYaSrR`.`datetime_field1`))",
                                                            "cover ((`t_2JWzwoYaSrR`.`decimal_field1`))",
                                                            "cover ((`t_2JWzwoYaSrR`.`int_field1`))",
                                                            "cover ((`t_2JWzwoYaSrR`.`varchar_field1`))",
                                                            "cover ((meta(`t_2JWzwoYaSrR`).`id`))"
                                                        ],
                                                        "index": "simple_table_4",
                                                        "index_id": "8c9b23138d455216",
                                                        "index_projection": {
                                                            "entry_keys": [
                                                                0,
                                                                5
                                                            ],
                                                            "primary_key": true
                                                        },
                                                        "keyspace": "multiple_table_db_35247585_simple_table_4",
                                                        "namespace": "default",
                                                        "nested_loop": true,
                                                        "spans": [
                                                            {
                                                                "exact": true,
                                                                "range": [
                                                                    {
                                                                        "high": "(`t_3`.`primary_key_id`)",
                                                                        "inclusion": 3,
                                                                        "low": "(`t_3`.`primary_key_id`)"
                                                                    }
                                                                ]
                                                            }
                                                        ],
                                                        "using": "gsi"
                                                    }
                                                ]
                                            }
                                        },
                                        {
                                            "#operator": "NestedLoopJoin",
                                            "alias": "t_2hAuEmuNSgG",
                                            "on_clause": "(((`t_5`.`int_field1`) = cover ((`t_2hAuEmuNSgG`.`int_field1`))) and ((`t_5`.`int_field1`) = cover ((`t_2hAuEmuNSgG`.`int_field1`))))",
                                            "outer": true,
                                            "~child": {
                                                "#operator": "Sequence",
                                                "~children": [
                                                    {
                                                        "#operator": "IndexScan3",
                                                        "as": "t_2hAuEmuNSgG",
                                                        "covers": [
                                                            "cover ((`t_2hAuEmuNSgG`.`int_field1`))",
                                                            "cover ((meta(`t_2hAuEmuNSgG`).`id`))"
                                                        ],
                                                        "index": "simple_table_4_int_field1",
                                                        "index_id": "62fbfdcd96f9b6b7",
                                                        "keyspace": "multiple_table_db_35247585_simple_table_4",
                                                        "namespace": "default",
                                                        "nested_loop": true,
                                                        "spans": [
                                                            {
                                                                "range": [
                                                                    {
                                                                        "high": "(`t_5`.`int_field1`)",
                                                                        "inclusion": 3,
                                                                        "low": "(`t_5`.`int_field1`)"
                                                                    }
                                                                ]
                                                            }
                                                        ],
                                                        "using": "gsi"
                                                    }
                                                ]
                                            }
                                        },
                                        {
                                            "#operator": "Filter",
                                            "condition": "((not ((`t_4`.`bool_field1`) = true)) or ((`t_2`.`primary_key_id`) <= \"549\"))"
                                        },
                                        {
                                            "#operator": "InitialProject",
                                            "result_terms": [
                                                {
                                                    "expr": "`t_2`",
                                                    "star": true
                                                }
                                            ]
                                        }
                                    ]
                                }
                            }
                        ]
                    },
                    {
                        "#operator": "Order",
                        "sort_terms": [
                            {
                                "expr": "(`t_3`.`int_field1`)"
                            },
                            {
                                "expr": "(`t_3`.`decimal_field1`)"
                            }
                        ]
                    },
                    {
                        "#operator": "FinalProject"
                    }
                ]
            },
            "text": "SELECT  t_2.* FROM  multiple_table_db_35247585_simple_table_3 t_5 INNER JOIN  multiple_table_db_35247585_simple_table_2 t_1 ON ( (t_5.char_field1 = t_1.char_field1 AND t_5.int_field1 < t_1.int_field1) ) LEFT JOIN  multiple_table_db_35247585_simple_table_1 t_3 ON ( (t_5.decimal_field1 = t_3.decimal_field1 AND t_5.varchar_field1 = t_3.varchar_field1) ) LEFT JOIN  multiple_table_db_35247585_simple_table_4 t_2 ON ( (t_3.int_field1 = t_2.int_field1 AND t_3.varchar_field1 = t_2.varchar_field1 AND t_3.int_field1 = t_2.int_field1) ) LEFT JOIN  multiple_table_db_35247585_simple_table_10 t_4 ON ( NOT ((t_5.decimal_field1 = t_4.decimal_field1 AND t_5.varchar_field1 = t_4.varchar_field1 AND t_5.varchar_field1 = t_4.varchar_field1)) ) INNER JOIN  multiple_table_db_35247585_simple_table_4 t_2JWzwoYaSrR ON ( (t_3.primary_key_id = t_2JWzwoYaSrR.primary_key_id AND NOT (NOT (t_3.int_field1 = t_2JWzwoYaSrR.int_field1))) ) LEFT JOIN  multiple_table_db_35247585_simple_table_4 t_2hAuEmuNSgG ON ( (t_5.int_field1 = t_2hAuEmuNSgG.int_field1 AND t_5.int_field1 = t_2hAuEmuNSgG.int_field1) ) WHERE  (t_4.bool_field1 != true OR t_2.primary_key_id <= \"549\")    ORDER BY   t_3.int_field1 , t_3.decimal_field1;"
        }
    ],
    "status": "success",
    "metrics": {
        "elapsedTime": "10.87ms",
        "executionTime": "10.771ms",
        "resultCount": 1,
        "resultSize": 78617
    }
}