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

Then maybe you need to remove cubeparse.[ch] and try again. Bison 
changed the error message from "parse error" to "syntax error" in 
version 1.875 and it has been the same ever since, AFAIK.

cheers

andrew

Joshua Reich wrote:

> I upgraded to the latest version (2.3) as per the warning after 
> running configure.
>
> Josh
>
> Andrew Dunstan wrote:
>
>>
>>
>> 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
>>>  
>>>
>>
>