diff options
-rw-r--r-- | src/test/regress/expected/union.out | 4 | ||||
-rw-r--r-- | src/test/regress/sql/union.sql | 4 |
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)); |