I have completed upgrading the cube codebase to use the V1 call
protocol. However, before I submit a patch I would really like to work
out why I have never been able to get cube to pass installcheck.
This is what I get when I run installcheck on a clean version of 8.1.4
(I get similar results on CVS HEAD). The regression.diff is attached.
josh:~/installs/postgresql-8.1.4/contrib/cube josh$ make installcheck
make -C ../../src/test/regress pg_regress
make[1]: `pg_regress' is up to date.
/bin/sh ../../src/test/regress/pg_regress --dbname=contrib_regression
cube
(using postmaster on Unix socket, default port)
============== dropping database "contrib_regression" ==============
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
============== dropping regression test user accounts ==============
============== running regression test queries ==============
test cube ... FAILED
======================
1 of 1 tests failed.
======================
I have tried this both on OS X and Linux and get similar results.
Josh Reich
Neil Conway wrote:
On Mon, 2006-07-17 at 17:55 -0400, Joshua Reich wrote:
Ok. So, the cube code looks very unmaintained (not to offend
anyone), but it is all in V0 and I believe make installcheck fails
out of the box due to new error message formats.
It passes for me with CVS HEAD. The cube regression test is also run as
part of the buildfarm process, so it sounds like an error on your end.
------------------------------------------------------------------------
*** ./expected/cube_1.out Sun Jun 26 21:19:43 2005
--- ./results/cube.out Tue Jul 18 09:44:14 2006
***************
*** 258,310 ****
-- invalid input: parse errors
SELECT ''::cube AS cube;
ERROR: bad cube representation
! DETAIL: syntax error at end of input
SELECT 'ABC'::cube AS cube;
ERROR: bad cube representation
! DETAIL: syntax error at or near "A"
SELECT '()'::cube AS cube;
ERROR: bad cube representation
! DETAIL: syntax error at or near ")"
SELECT '[]'::cube AS cube;
ERROR: bad cube representation
! DETAIL: syntax error at or near "]"
SELECT '[()]'::cube AS cube;
ERROR: bad cube representation
! DETAIL: syntax error at or near ")"
SELECT '[(1)]'::cube AS cube;
ERROR: bad cube representation
! DETAIL: syntax error at or near "]"
SELECT '[(1),]'::cube AS cube;
ERROR: bad cube representation
! DETAIL: syntax error at or near "]"
SELECT '[(1),2]'::cube AS cube;
ERROR: bad cube representation
! DETAIL: syntax error at or near "2"
SELECT '[(1),(2),(3)]'::cube AS cube;
ERROR: bad cube representation
! DETAIL: syntax error at or near ","
SELECT '1,'::cube AS cube;
ERROR: bad cube representation
! DETAIL: syntax error at end of input
SELECT '1,2,'::cube AS cube;
ERROR: bad cube representation
! DETAIL: syntax error at end of input
SELECT '1,,2'::cube AS cube;
ERROR: bad cube representation
! DETAIL: syntax error at or near ","
SELECT '(1,)'::cube AS cube;
ERROR: bad cube representation
! DETAIL: syntax error at or near ")"
SELECT '(1,2,)'::cube AS cube;
ERROR: bad cube representation
! DETAIL: syntax error at or near ")"
SELECT '(1,,2)'::cube AS cube;
ERROR: bad cube representation
! DETAIL: syntax error at or near ","
-- invalid input: semantic errors and trailing garbage
SELECT '[(1),(2)],'::cube AS cube; -- 0
ERROR: bad cube representation
! DETAIL: syntax error at or near ","
SELECT '[(1,2,3),(2,3)]'::cube AS cube; -- 1
ERROR: bad cube representation
DETAIL: different point dimensions in (1,2,3) and (2,3)
--- 258,310 ----
-- invalid input: parse errors
SELECT ''::cube AS cube;
ERROR: bad cube representation
! DETAIL: parse error at end of input
SELECT 'ABC'::cube AS cube;
ERROR: bad cube representation
! DETAIL: parse error at or near "A"
SELECT '()'::cube AS cube;
ERROR: bad cube representation
! DETAIL: parse error at or near ")"
SELECT '[]'::cube AS cube;
ERROR: bad cube representation
! DETAIL: parse error at or near "]"
SELECT '[()]'::cube AS cube;
ERROR: bad cube representation
! DETAIL: parse error at or near ")"
SELECT '[(1)]'::cube AS cube;
ERROR: bad cube representation
! DETAIL: parse error at or near "]"
SELECT '[(1),]'::cube AS cube;
ERROR: bad cube representation
! DETAIL: parse error at or near "]"
SELECT '[(1),2]'::cube AS cube;
ERROR: bad cube representation
! DETAIL: parse error at or near "2"
SELECT '[(1),(2),(3)]'::cube AS cube;
ERROR: bad cube representation
! DETAIL: parse error at or near ","
SELECT '1,'::cube AS cube;
ERROR: bad cube representation
! DETAIL: parse error at end of input
SELECT '1,2,'::cube AS cube;
ERROR: bad cube representation
! DETAIL: parse error at end of input
SELECT '1,,2'::cube AS cube;
ERROR: bad cube representation
! DETAIL: parse error at or near ","
SELECT '(1,)'::cube AS cube;
ERROR: bad cube representation
! DETAIL: parse error at or near ")"
SELECT '(1,2,)'::cube AS cube;
ERROR: bad cube representation
! DETAIL: parse error at or near ")"
SELECT '(1,,2)'::cube AS cube;
ERROR: bad cube representation
! DETAIL: parse error at or near ","
-- invalid input: semantic errors and trailing garbage
SELECT '[(1),(2)],'::cube AS cube; -- 0
ERROR: bad cube representation
! DETAIL: parse error at or near ","
SELECT '[(1,2,3),(2,3)]'::cube AS cube; -- 1
ERROR: bad cube representation
DETAIL: different point dimensions in (1,2,3) and (2,3)
***************
*** 313,319 ****
DETAIL: different point dimensions in (1,2) and (1,2,3)
SELECT '(1),(2),'::cube AS cube; -- 2
ERROR: bad cube representation
! DETAIL: syntax error at or near ","
SELECT '(1,2,3),(2,3)'::cube AS cube; -- 3
ERROR: bad cube representation
DETAIL: different point dimensions in (1,2,3) and (2,3)
--- 313,319 ----
DETAIL: different point dimensions in (1,2) and (1,2,3)
SELECT '(1),(2),'::cube AS cube; -- 2
ERROR: bad cube representation
! DETAIL: parse error at or near ","
SELECT '(1,2,3),(2,3)'::cube AS cube; -- 3
ERROR: bad cube representation
DETAIL: different point dimensions in (1,2,3) and (2,3)
***************
*** 322,346 ****
DETAIL: different point dimensions in (1,2) and (1,2,3)
SELECT '(1,2,3)ab'::cube AS cube; -- 4
ERROR: bad cube representation
! DETAIL: syntax error at or near "a"
SELECT '(1,2,3)a'::cube AS cube; -- 5
ERROR: bad cube representation
! DETAIL: syntax error at or near "a"
SELECT '(1,2)('::cube AS cube; -- 5
ERROR: bad cube representation
! DETAIL: syntax error at or near "("
SELECT '1,2ab'::cube AS cube; -- 6
ERROR: bad cube representation
! DETAIL: syntax error at or near "a"
SELECT '1 e7'::cube AS cube; -- 6
ERROR: bad cube representation
! DETAIL: syntax error at or near "e"
SELECT '1,2a'::cube AS cube; -- 7
ERROR: bad cube representation
! DETAIL: syntax error at or near "a"
SELECT '1..2'::cube AS cube; -- 7
ERROR: bad cube representation
! DETAIL: syntax error at or near ".2"
--
-- Testing building cubes from float8 values
--
--- 322,346 ----
DETAIL: different point dimensions in (1,2) and (1,2,3)
SELECT '(1,2,3)ab'::cube AS cube; -- 4
ERROR: bad cube representation
! DETAIL: parse error at or near "a"
SELECT '(1,2,3)a'::cube AS cube; -- 5
ERROR: bad cube representation
! DETAIL: parse error at or near "a"
SELECT '(1,2)('::cube AS cube; -- 5
ERROR: bad cube representation
! DETAIL: parse error at or near "("
SELECT '1,2ab'::cube AS cube; -- 6
ERROR: bad cube representation
! DETAIL: parse error at or near "a"
SELECT '1 e7'::cube AS cube; -- 6
ERROR: bad cube representation
! DETAIL: parse error at or near "e"
SELECT '1,2a'::cube AS cube; -- 7
ERROR: bad cube representation
! DETAIL: parse error at or near "a"
SELECT '1..2'::cube AS cube; -- 7
ERROR: bad cube representation
! DETAIL: parse error at or near ".2"
--
-- Testing building cubes from float8 values
--
======================================================================
------------------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
