Re: [PATCHES] Proposed patch for contrib/cube

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

--
Joshua Reich
Finance and Corporate Development
ROOT Exchange, A Division of ROOT Markets
601 W. 26th St. / Suite 1500
New York, NY 10001
W - (212) 645 6320 x 7101
M / T - (646) 427 7959
E - josh(at)rootexchange(dot)com