diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-11-16 03:25:22 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-11-16 03:25:22 +0000 |
| commit | 00e59b5ec2b494951dcf1430c87918ceb1c10c63 (patch) | |
| tree | 5528b87fbaa450938e8a1cc1c100ec5dbc06bdf7 /src | |
| parent | 24b130cb89ced67ea62342c17a60fb1bd80f16f1 (diff) | |
| download | postgresql-00e59b5ec2b494951dcf1430c87918ceb1c10c63.tar.gz postgresql-00e59b5ec2b494951dcf1430c87918ceb1c10c63.zip | |
Fix CLUSTER regression failure caused by new patch, from Neil Conway
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/cluster.out | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/src/test/regress/expected/cluster.out b/src/test/regress/expected/cluster.out index ee39c3a8482..f537f00a5ce 100644 --- a/src/test/regress/expected/cluster.out +++ b/src/test/regress/expected/cluster.out @@ -302,6 +302,9 @@ INSERT INTO clstr_2 VALUES (2); INSERT INTO clstr_2 VALUES (1); INSERT INTO clstr_3 VALUES (2); INSERT INTO clstr_3 VALUES (1); +-- "CLUSTER <tablename>" on a table that hasn't been clustered +CLUSTER clstr_2; +ERROR: CLUSTER: No previously clustered index found on table clstr_2 CLUSTER clstr_1_pkey ON clstr_1; CLUSTER clstr_2_pkey ON clstr_2; SELECT * FROM clstr_1 UNION ALL @@ -344,6 +347,18 @@ SELECT * FROM clstr_1 UNION ALL 1 (6 rows) +-- cluster a single table using the indisclustered bit previously set +DELETE FROM clstr_1; +INSERT INTO clstr_1 VALUES (2); +INSERT INTO clstr_1 VALUES (1); +CLUSTER clstr_1; +SELECT * FROM clstr_1; + a +--- + 1 + 2 +(2 rows) + -- clean up \c - DROP TABLE clstr_1; |