summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--src/test/regress/expected/index_including.out26
-rw-r--r--src/test/regress/sql/index_including.sql24
2 files changed, 25 insertions, 25 deletions
diff --git a/src/test/regress/expected/index_including.out b/src/test/regress/expected/index_including.out
index ceccd55b2be..1199671a440 100644
--- a/src/test/regress/expected/index_including.out
+++ b/src/test/regress/expected/index_including.out
@@ -143,14 +143,14 @@ DROP TABLE tbl;
*/
CREATE TABLE tbl (c1 int,c2 int, c3 int, c4 int);
CREATE UNIQUE INDEX tbl_idx ON tbl using btree(c1, c2, c3, c4);
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
indexdef
-----------------------------------------------------------------
CREATE UNIQUE INDEX tbl_idx ON tbl USING btree (c1, c2, c3, c4)
(1 row)
ALTER TABLE tbl DROP COLUMN c3;
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
indexdef
----------
(0 rows)
@@ -163,14 +163,14 @@ DROP TABLE tbl;
*/
CREATE TABLE tbl (c1 int,c2 int, c3 int, c4 box);
CREATE UNIQUE INDEX tbl_idx ON tbl using btree(c1, c2) INCLUDING(c3,c4);
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
indexdef
----------------------------------------------------------------------------
CREATE UNIQUE INDEX tbl_idx ON tbl USING btree (c1, c2) INCLUDING (c3, c4)
(1 row)
ALTER TABLE tbl DROP COLUMN c3;
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
indexdef
----------
(0 rows)
@@ -182,20 +182,20 @@ DROP TABLE tbl;
* as well as key columns deletion. It's explained in documentation.
*/
CREATE TABLE tbl (c1 int,c2 int, c3 int, c4 box, UNIQUE(c1, c2) INCLUDING(c3,c4));
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
indexdef
----------------------------------------------------------------------------------------
CREATE UNIQUE INDEX tbl_c1_c2_c3_c4_key ON tbl USING btree (c1, c2) INCLUDING (c3, c4)
(1 row)
ALTER TABLE tbl DROP COLUMN c3;
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
indexdef
----------
(0 rows)
ALTER TABLE tbl DROP COLUMN c1;
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
indexdef
----------
(0 rows)
@@ -207,11 +207,11 @@ DROP TABLE tbl;
CREATE TABLE tbl (c1 int,c2 int, c3 int, c4 box, UNIQUE(c1, c2) INCLUDING(c3,c4));
INSERT INTO tbl select x, 2*x, 3*x, box('4,4,4,4') from generate_series(1,1000) as x;
CREATE UNIQUE INDEX CONCURRENTLY on tbl (c1, c2) INCLUDING (c3, c4);
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
indexdef
----------------------------------------------------------------------------------------
- CREATE UNIQUE INDEX tbl_c1_c2_c3_c4_key ON tbl USING btree (c1, c2) INCLUDING (c3, c4)
CREATE UNIQUE INDEX tbl_c1_c2_c3_c4_idx ON tbl USING btree (c1, c2) INCLUDING (c3, c4)
+ CREATE UNIQUE INDEX tbl_c1_c2_c3_c4_key ON tbl USING btree (c1, c2) INCLUDING (c3, c4)
(2 rows)
DROP TABLE tbl;
@@ -219,27 +219,27 @@ DROP TABLE tbl;
* 5. REINDEX
*/
CREATE TABLE tbl (c1 int,c2 int, c3 int, c4 box, UNIQUE(c1, c2) INCLUDING(c3,c4));
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
indexdef
----------------------------------------------------------------------------------------
CREATE UNIQUE INDEX tbl_c1_c2_c3_c4_key ON tbl USING btree (c1, c2) INCLUDING (c3, c4)
(1 row)
ALTER TABLE tbl DROP COLUMN c3;
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
indexdef
----------
(0 rows)
REINDEX INDEX tbl_c1_c2_c3_c4_key;
ERROR: relation "tbl_c1_c2_c3_c4_key" does not exist
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
indexdef
----------
(0 rows)
ALTER TABLE tbl DROP COLUMN c1;
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
indexdef
----------
(0 rows)
diff --git a/src/test/regress/sql/index_including.sql b/src/test/regress/sql/index_including.sql
index 83ca670480d..c4c61c56d71 100644
--- a/src/test/regress/sql/index_including.sql
+++ b/src/test/regress/sql/index_including.sql
@@ -88,9 +88,9 @@ DROP TABLE tbl;
*/
CREATE TABLE tbl (c1 int,c2 int, c3 int, c4 int);
CREATE UNIQUE INDEX tbl_idx ON tbl using btree(c1, c2, c3, c4);
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
ALTER TABLE tbl DROP COLUMN c3;
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
DROP TABLE tbl;
/*
@@ -100,9 +100,9 @@ DROP TABLE tbl;
*/
CREATE TABLE tbl (c1 int,c2 int, c3 int, c4 box);
CREATE UNIQUE INDEX tbl_idx ON tbl using btree(c1, c2) INCLUDING(c3,c4);
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
ALTER TABLE tbl DROP COLUMN c3;
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
DROP TABLE tbl;
/*
@@ -111,11 +111,11 @@ DROP TABLE tbl;
* as well as key columns deletion. It's explained in documentation.
*/
CREATE TABLE tbl (c1 int,c2 int, c3 int, c4 box, UNIQUE(c1, c2) INCLUDING(c3,c4));
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
ALTER TABLE tbl DROP COLUMN c3;
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
ALTER TABLE tbl DROP COLUMN c1;
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
DROP TABLE tbl;
@@ -125,7 +125,7 @@ DROP TABLE tbl;
CREATE TABLE tbl (c1 int,c2 int, c3 int, c4 box, UNIQUE(c1, c2) INCLUDING(c3,c4));
INSERT INTO tbl select x, 2*x, 3*x, box('4,4,4,4') from generate_series(1,1000) as x;
CREATE UNIQUE INDEX CONCURRENTLY on tbl (c1, c2) INCLUDING (c3, c4);
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
DROP TABLE tbl;
@@ -133,13 +133,13 @@ DROP TABLE tbl;
* 5. REINDEX
*/
CREATE TABLE tbl (c1 int,c2 int, c3 int, c4 box, UNIQUE(c1, c2) INCLUDING(c3,c4));
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
ALTER TABLE tbl DROP COLUMN c3;
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
REINDEX INDEX tbl_c1_c2_c3_c4_key;
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
ALTER TABLE tbl DROP COLUMN c1;
-select indexdef from pg_indexes where tablename='tbl';
+select indexdef from pg_indexes where tablename = 'tbl' order by indexname;
DROP TABLE tbl;
/*
generated by cgit v1.2.3 (git 2.39.1) at 2025-07-21 00:25:19 +0000