From: | Neil Conway <neilc(at)samurai(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | regression test failure (CVS HEAD) |
Date: | 2002-11-15 17:43:43 |
Message-ID: | 87el9mhgog.fsf@mailbox.samurai.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)samurai(dot)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;
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-11-15 17:46:12 | Re: Geometry regression tests (was Re: Float output formatting options) |
Previous Message | Lamar Owen | 2002-11-15 17:40:11 | Re: Time to move on... |