diff options
| -rw-r--r-- | src/test/regress/expected/create_index.out | 54 |
1 files changed, 31 insertions, 23 deletions
diff --git a/src/test/regress/expected/create_index.out b/src/test/regress/expected/create_index.out index bccb6920dd..acf85f14c6 100644 --- a/src/test/regress/expected/create_index.out +++ b/src/test/regress/expected/create_index.out @@ -3057,41 +3057,49 @@ explain (costs off) create temp table boolindex (b bool, i int, unique(b, i), junk float); explain (costs off) select * from boolindex order by b, i limit 10; - QUERY PLAN -------------------------------------------------------- + QUERY PLAN +------------------------------------------------------------------- Limit - -> Index Scan using boolindex_b_i_key on boolindex -(2 rows) + -> Remote Subquery Scan on all (datanode_1,datanode_2) + -> Limit + -> Index Scan using boolindex_b_i_key on boolindex +(4 rows) explain (costs off) select * from boolindex where b order by i limit 10; - QUERY PLAN -------------------------------------------------------- + QUERY PLAN +------------------------------------------------------------------- Limit - -> Index Scan using boolindex_b_i_key on boolindex - Index Cond: (b = true) - Filter: b -(4 rows) + -> Remote Subquery Scan on all (datanode_1,datanode_2) + -> Limit + -> Index Scan using boolindex_b_i_key on boolindex + Index Cond: (b = true) + Filter: b +(6 rows) explain (costs off) select * from boolindex where b = true order by i desc limit 10; - QUERY PLAN ----------------------------------------------------------------- - Limit - -> Index Scan Backward using boolindex_b_i_key on boolindex - Index Cond: (b = true) - Filter: b -(4 rows) + QUERY PLAN +---------------------------------------------------------------------- + Remote Fast Query Execution + Node/s: datanode_1 + -> Limit + -> Index Scan Backward using boolindex_b_i_key on boolindex + Index Cond: (b = true) + Filter: b +(6 rows) explain (costs off) select * from boolindex where not b order by i limit 10; - QUERY PLAN -------------------------------------------------------- + QUERY PLAN +------------------------------------------------------------------- Limit - -> Index Scan using boolindex_b_i_key on boolindex - Index Cond: (b = false) - Filter: (NOT b) -(4 rows) + -> Remote Subquery Scan on all (datanode_1,datanode_2) + -> Limit + -> Index Scan using boolindex_b_i_key on boolindex + Index Cond: (b = false) + Filter: (NOT b) +(6 rows) -- -- REINDEX (VERBOSE) |