summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--src/test/regress/expected/union.out4
-rw-r--r--src/test/regress/sql/union.sql4
2 files changed, 4 insertions, 4 deletions
diff --git a/src/test/regress/expected/union.out b/src/test/regress/expected/union.out
index 05e13db310..e159c8b64b 100644
--- a/src/test/regress/expected/union.out
+++ b/src/test/regress/expected/union.out
@@ -538,10 +538,10 @@ explain (num_nodes off, nodes off, costs off)
-- Test that ORDER BY for UNION ALL can be pushed down to inheritance
-- children.
--
-CREATE TEMP TABLE t1c (b text, a text);
+CREATE TEMP TABLE t1c (a text, b text);
ALTER TABLE t1c INHERIT t1;
CREATE TEMP TABLE t2c (primary key (ab)) INHERITS (t2);
-INSERT INTO t1c VALUES ('v', 'w'), ('c', 'd'), ('m', 'n'), ('e', 'f');
+INSERT INTO t1c (b, a) VALUES ('v', 'w'), ('c', 'd'), ('m', 'n'), ('e', 'f');
INSERT INTO t2c VALUES ('vw'), ('cd'), ('mn'), ('ef');
CREATE INDEX t1c_ab_idx on t1c ((a || b));
set enable_seqscan = on;
diff --git a/src/test/regress/sql/union.sql b/src/test/regress/sql/union.sql
index f0f7640869..d71375b897 100644
--- a/src/test/regress/sql/union.sql
+++ b/src/test/regress/sql/union.sql
@@ -212,10 +212,10 @@ explain (num_nodes off, nodes off, costs off)
-- children.
--
-CREATE TEMP TABLE t1c (b text, a text);
+CREATE TEMP TABLE t1c (a text, b text);
ALTER TABLE t1c INHERIT t1;
CREATE TEMP TABLE t2c (primary key (ab)) INHERITS (t2);
-INSERT INTO t1c VALUES ('v', 'w'), ('c', 'd'), ('m', 'n'), ('e', 'f');
+INSERT INTO t1c (b, a) VALUES ('v', 'w'), ('c', 'd'), ('m', 'n'), ('e', 'f');
INSERT INTO t2c VALUES ('vw'), ('cd'), ('mn'), ('ef');
CREATE INDEX t1c_ab_idx on t1c ((a || b));