diff options
author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2018-01-19 12:31:34 -0300 |
---|---|---|
committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2018-01-19 12:31:34 -0300 |
commit | 189d0ff588f54b9641c6684d7c668ef85ea4dfbd (patch) | |
tree | 2ca109929741174265f0ff45ed002c13563dff87 /src/test/regress/sql/indexing.sql | |
parent | 8b08f7d4820fd7a8ef6152a9dd8c6e3cb01e5f99 (diff) | |
download | postgresql-189d0ff588f54b9641c6684d7c668ef85ea4dfbd.tar.gz postgresql-189d0ff588f54b9641c6684d7c668ef85ea4dfbd.zip |
Fix regression tests for better stability
Per buildfarm
Diffstat (limited to 'src/test/regress/sql/indexing.sql')
-rw-r--r-- | src/test/regress/sql/indexing.sql | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/src/test/regress/sql/indexing.sql b/src/test/regress/sql/indexing.sql index 33be718699c..2f985ec8667 100644 --- a/src/test/regress/sql/indexing.sql +++ b/src/test/regress/sql/indexing.sql @@ -116,12 +116,12 @@ create index on idxpart (a); select indexrelid::regclass, indrelid::regclass, inhparent::regclass from pg_index idx left join pg_inherits inh on (idx.indexrelid = inh.inhrelid) where indexrelid::regclass::text like 'idxpart%' - order by indrelid::regclass::text collate "C"; + order by indexrelid::regclass::text collate "C"; alter index idxpart2_a_idx attach partition idxpart22_a_idx; select indexrelid::regclass, indrelid::regclass, inhparent::regclass from pg_index idx left join pg_inherits inh on (idx.indexrelid = inh.inhrelid) where indexrelid::regclass::text like 'idxpart%' - order by indrelid::regclass::text collate "C"; + order by indexrelid::regclass::text collate "C"; -- attaching idxpart22 is not enough to set idxpart22_a_idx valid ... alter index idxpart2_a_idx attach partition idxpart22_a_idx; \d idxpart2 @@ -306,7 +306,7 @@ alter table idxpart attach partition idxpart2 for values from (10) to (20); select c.relname, pg_get_indexdef(indexrelid) from pg_class c join pg_index i on c.oid = i.indexrelid where indrelid::regclass::text like 'idxpart%' - order by indrelid::regclass::text collate "C"; + order by indexrelid::regclass::text collate "C"; drop table idxpart; -- Verify that columns are mapped correctly in expression indexes @@ -323,7 +323,7 @@ alter table idxpart attach partition idxpart1 for values from (1) to (2); select c.relname, pg_get_indexdef(indexrelid) from pg_class c join pg_index i on c.oid = i.indexrelid where indrelid::regclass::text like 'idxpart%' - order by indrelid::regclass::text collate "C"; + order by indexrelid::regclass::text collate "C"; drop table idxpart; -- Verify that columns are mapped correctly for WHERE in a partial index @@ -340,7 +340,7 @@ create index on idxpart (a) where b > 1000; select c.relname, pg_get_indexdef(indexrelid) from pg_class c join pg_index i on c.oid = i.indexrelid where indrelid::regclass::text like 'idxpart%' - order by indrelid::regclass::text collate "C"; + order by indexrelid::regclass::text collate "C"; drop table idxpart; -- Column number mapping: dropped columns in the partition |