postgres.git / summary / log / commit / refs
commit 2c30f96103c320d4e3c8cab2807d88476f584278
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: Wed Nov 09 05:13:37 2011 +0000
First released in: 9.2.0
Tweak new regression test case for more portability.
Ensure that same index gets selected on 32-bit and 64-bit machines.
Per buildfarm results.
src/test/regress/expected/inherit.out | 10 +++++-----
src/test/regress/sql/inherit.sql | 4 ++--
2 files changed, 7 insertions(+), 7 deletions(-)
diff --git a/src/test/regress/expected/inherit.out b/src/test/regress/expected/inherit.out
index 3e2ab9ac5b8..72986c78a23 100644
--- a/src/test/regress/expected/inherit.out
+++ b/src/test/regress/expected/inherit.out
@@ -1266,19 +1266,19 @@ ORDER BY thousand, tenthous;
(7 rows)
explain (costs off)
-SELECT thousand, tenthous FROM tenk1
+SELECT thousand, tenthous, thousand+tenthous AS x FROM tenk1
UNION ALL
-SELECT 42, 42 FROM tenk1
+SELECT 42, 42, hundred FROM tenk1
ORDER BY thousand, tenthous;
- QUERY PLAN
------------------------------------------------------------------------
+ QUERY PLAN
+-----------------------------------------------------------------
Result
-> Merge Append
Sort Key: public.tenk1.thousand, public.tenk1.tenthous
-> Index Only Scan using tenk1_thous_tenthous on tenk1
-> Sort
Sort Key: (42), (42)
- -> Index Only Scan using tenk1_thous_tenthous on tenk1
+ -> Index Only Scan using tenk1_hundred on tenk1
(7 rows)
explain (costs off)
diff --git a/src/test/regress/sql/inherit.sql b/src/test/regress/sql/inherit.sql
index 6e5a1d1c8ee..deda5a519ef 100644
--- a/src/test/regress/sql/inherit.sql
+++ b/src/test/regress/sql/inherit.sql
@@ -423,9 +423,9 @@ SELECT thousand, thousand FROM tenk1
ORDER BY thousand, tenthous;
explain (costs off)
-SELECT thousand, tenthous FROM tenk1
+SELECT thousand, tenthous, thousand+tenthous AS x FROM tenk1
UNION ALL
-SELECT 42, 42 FROM tenk1
+SELECT 42, 42, hundred FROM tenk1
ORDER BY thousand, tenthous;
explain (costs off)
[parent: 6d295b64945c]