regression test failure (CVS HEAD)
Started by Neil Conwayabout 23 years ago2 messages
Seems like a result of Alverro's cluster patch -- looks like the patch
didn't updated the expected results for the regression tests
fully. Diffs below.
Cheers,
Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
*** ./expected/cluster.out Fri Nov 15 12:35:36 2002
--- ./results/cluster.out Fri Nov 15 12:39:33 2002
***************
*** 302,307 ****
--- 302,310 ----
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,349 ****
--- 347,364 ----
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;
Re: regression test failure (CVS HEAD)
Applied. Sorry I missed this one. I did a clean compile and initdb for
testing, but forgot regression.
---------------------------------------------------------------------------
Neil Conway wrote:
Seems like a result of Alverro's cluster patch -- looks like the patch
didn't updated the expected results for the regression tests
fully. Diffs below.Cheers,
Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC*** ./expected/cluster.out Fri Nov 15 12:35:36 2002 --- ./results/cluster.out Fri Nov 15 12:39:33 2002 *************** *** 302,307 **** --- 302,310 ---- 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,349 **** --- 347,364 ---- 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;---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073