Re: [PATCHES] Proposed patch for contrib/cube

What version of bison do you have?

cheers

andrew

Joshua Reich wrote:

> 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
>
>