Re: [PATCHES] Proposed patch for contrib/cube - Mailing list pgsql-hackers

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