diff options
author | Tomas Vondra | 2017-07-07 23:17:29 +0000 |
---|---|---|
committer | Tomas Vondra | 2017-07-07 23:17:29 +0000 |
commit | 8c88742b734862e3422e5de555448e2f48fc6347 (patch) | |
tree | 3e6bd145c7c7cc1ffd7af3d56e6cc3b3e942699d | |
parent | 2752383bf70e9a915308a53d55357c26d5e9ecb3 (diff) |
Accept trivial plan changes in brin regression test
Those are new plans in upstream, and the only that happened to them is
adding "Remote Fast Query Execution" to the top of the plan.
-rw-r--r-- | src/test/regress/expected/brin.out | 28 |
1 files changed, 16 insertions, 12 deletions
diff --git a/src/test/regress/expected/brin.out b/src/test/regress/expected/brin.out index 3d500369a5..13233c238c 100644 --- a/src/test/regress/expected/brin.out +++ b/src/test/regress/expected/brin.out @@ -500,19 +500,23 @@ CREATE INDEX brin_test_b_idx ON brin_test USING brin (b) WITH (pages_per_range = VACUUM ANALYZE brin_test; -- Ensure brin index is used when columns are perfectly correlated EXPLAIN (COSTS OFF) SELECT * FROM brin_test WHERE a = 1; - QUERY PLAN --------------------------------------------- - Bitmap Heap Scan on brin_test - Recheck Cond: (a = 1) - -> Bitmap Index Scan on brin_test_a_idx - Index Cond: (a = 1) -(4 rows) + QUERY PLAN +-------------------------------------------------- + Remote Fast Query Execution + Node/s: datanode_1 + -> Bitmap Heap Scan on brin_test + Recheck Cond: (a = 1) + -> Bitmap Index Scan on brin_test_a_idx + Index Cond: (a = 1) +(6 rows) -- Ensure brin index is not used when values are not correlated EXPLAIN (COSTS OFF) SELECT * FROM brin_test WHERE b = 1; - QUERY PLAN ------------------------ - Seq Scan on brin_test - Filter: (b = 1) -(2 rows) + QUERY PLAN +---------------------------------- + Remote Fast Query Execution + Node/s: datanode_1, datanode_2 + -> Seq Scan on brin_test + Filter: (b = 1) +(4 rows) |