Home > mailing lists
Re: arm rc1 regression failures - Mailing list pgsql-hackers

From	Jim Buttafuoco
Subject	Re: arm rc1 regression failures
Date	December 6, 2004 20:34:08
Msg-id	20041206173326.M79618@contactbda.com Whole thread Raw
In response to	Re: arm rc1 regression failures (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses	Re: arm rc1 regression failures
List	pgsql-hackers
Tree view
See attached


---------- Original Message -----------
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: jim@contactbda.com
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Sent: Mon, 6 Dec 2004 12:24:18 -0500 (EST)
Subject: Re: [HACKERS] arm rc1 regression failures

> Would you send us regression.diff?  That should show the differences.
>
> ---------------------------------------------------------------------------
>
> Jim Buttafuoco wrote:
> > Just compiled RC1 on a netwinder ARM system running Debian Linux (sarge).  All tests passed except "point" with
the
> > following in results/point
> >
> > Jim
> >
> >
> > --
> > -- POINT
> > --
> > CREATE TABLE POINT_TBL(f1 point);
> > INSERT INTO POINT_TBL(f1) VALUES ('(0.0,0.0)');
> > INSERT INTO POINT_TBL(f1) VALUES ('(-10.0,0.0)');
> > INSERT INTO POINT_TBL(f1) VALUES ('(-3.0,4.0)');
> > INSERT INTO POINT_TBL(f1) VALUES ('(5.1, 34.5)');
> > INSERT INTO POINT_TBL(f1) VALUES ('(-5.0,-12.0)');
> > -- bad format points
> > INSERT INTO POINT_TBL(f1) VALUES ('asdfasdf');
> > ERROR:  invalid input syntax for type point: "asdfasdf"
> > INSERT INTO POINT_TBL(f1) VALUES ('10.0,10.0');
> > INSERT INTO POINT_TBL(f1) VALUES ('(10.0 10.0)');
> > ERROR:  invalid input syntax for type point: "(10.0 10.0)"
> > INSERT INTO POINT_TBL(f1) VALUES ('(10.0,10.0');
> > ERROR:  invalid input syntax for type point: "(10.0,10.0"
> > SELECT '' AS six, POINT_TBL.*;
> >  six |     f1
> > -----+------------
> >      | (0,0)
> >      | (-10,0)
> >      | (-3,4)
> >      | (5.1,34.5)
> >      | (-5,-12)
> >      | (10,10)
> > (6 rows)
> >
> > -- left of
> > SELECT '' AS three, p.* FROM POINT_TBL p WHERE p.f1 << '(0.0, 0.0)';
> >  three |    f1
> > -------+----------
> >        | (-10,0)
> >        | (-3,4)
> >        | (-5,-12)
> > (3 rows)
> >
> > -- right of
> > SELECT '' AS three, p.* FROM POINT_TBL p WHERE '(0.0,0.0)' >> p.f1;
> >  three |    f1
> > -------+----------
> >        | (-10,0)
> >        | (-3,4)
> >        | (-5,-12)
> > (3 rows)
> >
> > -- above
> > SELECT '' AS one, p.* FROM POINT_TBL p WHERE '(0.0,0.0)' >^ p.f1;
> >  one |    f1
> > -----+----------
> >      | (-5,-12)
> > (1 row)
> >
> > -- below
> > SELECT '' AS one, p.* FROM POINT_TBL p WHERE p.f1 <^ '(0.0, 0.0)';
> >  one |    f1
> > -----+----------
> >      | (-5,-12)
> > (1 row)
> >
> > -- equal
> > SELECT '' AS one, p.* FROM POINT_TBL p WHERE p.f1 ~= '(5.1, 34.5)';
> >  one |     f1
> > -----+------------
> >      | (5.1,34.5)
> > (1 row)
> >
> > -- point in box
> > SELECT '' AS three, p.* FROM POINT_TBL p
> >    WHERE p.f1 @ box '(0,0,100,100)';
> >  three |     f1
> > -------+------------
> >        | (0,0)
> >        | (5.1,34.5)
> >        | (10,10)
> > (3 rows)
> >
> > SELECT '' AS three, p.* FROM POINT_TBL p
> >    WHERE not p.f1 @ box '(0,0,100,100)';
> >  three |    f1
> > -------+----------
> >        | (-10,0)
> >        | (-3,4)
> >        | (-5,-12)
> > (3 rows)
> >
> > SELECT '' AS two, p.* FROM POINT_TBL p
> >    WHERE p.f1 @ path '[(0,0),(-10,0),(-10,10)]';
> >  two |   f1
> > -----+---------
> >      | (0,0)
> >      | (-10,0)
> > (2 rows)
> >
> > SELECT '' AS six, p.f1, p.f1 <-> point '(0,0)' AS dist
> >    FROM POINT_TBL p
> >    ORDER BY dist;
> >  six |     f1     |       dist
> > -----+------------+------------------
> >      | (0,0)      |                0
> >      | (-3,4)     |                5
> >      | (-10,0)    |               10
> >      | (-5,-12)   |               13
> >      | (10,10)    | 14.1421356237309
> >      | (5.1,34.5) | 34.8749193547455
> > (6 rows)
> >
> > SET geqo TO 'off';
> > SELECT '' AS thirtysix, p1.f1 AS point1, p2.f1 AS point2, p1.f1 <-> p2.f1 AS dist
> >    FROM POINT_TBL p1, POINT_TBL p2
> >    ORDER BY dist, point1 using <<, point2 using <<;
> >  thirtysix |   point1   |   point2   |       dist
> > -----------+------------+------------+------------------
> >            | (-10,0)    | (-10,0)    |                0
> >            | (-5,-12)   | (-5,-12)   |                0
> >            | (-3,4)     | (-3,4)     |                0
> >            | (0,0)      | (0,0)      |                0
> >            | (5.1,34.5) | (5.1,34.5) |                0
> >            | (10,10)    | (10,10)    |                0
> >            | (-3,4)     | (0,0)      |                5
> >            | (0,0)      | (-3,4)     |                5
> >            | (-10,0)    | (-3,4)     | 8.06225774829855
> >            | (-3,4)     | (-10,0)    | 8.06225774829855
> >            | (-10,0)    | (0,0)      |               10
> >            | (0,0)      | (-10,0)    |               10
> >            | (-10,0)    | (-5,-12)   |               13
> >            | (-5,-12)   | (-10,0)    |               13
> >            | (-5,-12)   | (0,0)      |               13
> >            | (0,0)      | (-5,-12)   |               13
> >            | (0,0)      | (10,10)    | 14.1421356237309
> >            | (10,10)    | (0,0)      | 14.1421356237309
> >            | (-3,4)     | (10,10)    | 14.3178210632764
> >            | (10,10)    | (-3,4)     | 14.3178210632764
> >            | (-5,-12)   | (-3,4)     | 16.1245154965971
> >            | (-3,4)     | (-5,-12)   | 16.1245154965971
> >            | (-10,0)    | (10,10)    | 22.3606797749979
> >            | (10,10)    | (-10,0)    | 22.3606797749979
> >            | (5.1,34.5) | (10,10)    | 24.9851956166046
> >            | (10,10)    | (5.1,34.5) | 24.9851956166046
> >            | (-5,-12)   | (10,10)    | 26.6270539113887
> >            | (10,10)    | (-5,-12)   | 26.6270539113887
> >            | (-3,4)     | (5.1,34.5) | 31.5572495632937
> >            | (5.1,34.5) | (-3,4)     | 31.5572495632937
> >            | (0,0)      | (5.1,34.5) | 34.8749193547455
> >            | (5.1,34.5) | (0,0)      | 34.8749193547455
> >            | (-10,0)    | (5.1,34.5) | 37.6597928831267
> >            | (5.1,34.5) | (-10,0)    | 37.6597928831267
> >            | (-5,-12)   | (5.1,34.5) | 47.5842410888311
> >            | (5.1,34.5) | (-5,-12)   | 47.5842410888311
> > (36 rows)
> >
> > SELECT '' AS thirty, p1.f1 AS point1, p2.f1 AS point2
> >    FROM POINT_TBL p1, POINT_TBL p2
> >    WHERE (p1.f1 <-> p2.f1) > 3;
> >  thirty |   point1   |   point2
> > --------+------------+------------
> >         | (0,0)      | (-10,0)
> >         | (0,0)      | (-3,4)
> >         | (0,0)      | (5.1,34.5)
> >         | (0,0)      | (-5,-12)
> >         | (0,0)      | (10,10)
> >         | (-10,0)    | (0,0)
> >         | (-10,0)    | (-3,4)
> >         | (-10,0)    | (5.1,34.5)
> >         | (-10,0)    | (-5,-12)
> >         | (-10,0)    | (10,10)
> >         | (-3,4)     | (0,0)
> >         | (-3,4)     | (-10,0)
> >         | (-3,4)     | (5.1,34.5)
> >         | (-3,4)     | (-5,-12)
> >         | (-3,4)     | (10,10)
> >         | (5.1,34.5) | (0,0)
> >         | (5.1,34.5) | (-10,0)
> >         | (5.1,34.5) | (-3,4)
> >         | (5.1,34.5) | (-5,-12)
> >         | (5.1,34.5) | (10,10)
> >         | (-5,-12)   | (0,0)
> >         | (-5,-12)   | (-10,0)
> >         | (-5,-12)   | (-3,4)
> >         | (-5,-12)   | (5.1,34.5)
> >         | (-5,-12)   | (10,10)
> >         | (10,10)    | (0,0)
> >         | (10,10)    | (-10,0)
> >         | (10,10)    | (-3,4)
> >         | (10,10)    | (5.1,34.5)
> >         | (10,10)    | (-5,-12)
> > (30 rows)
> >
> > -- put distance result into output to allow sorting with GEQ optimizer - tgl 97/05/10
> > SELECT '' AS fifteen, p1.f1 AS point1, p2.f1 AS point2, (p1.f1 <-> p2.f1) AS distance
> >    FROM POINT_TBL p1, POINT_TBL p2
> >    WHERE (p1.f1 <-> p2.f1) > 3 and p1.f1 << p2.f1
> >    ORDER BY distance, point1 using <<, point2 using <<;
> >  fifteen |   point1   |   point2   |     distance
> > ---------+------------+------------+------------------
> >          | (-3,4)     | (0,0)      |                5
> >          | (-10,0)    | (-3,4)     | 8.06225774829855
> >          | (-10,0)    | (0,0)      |               10
> >          | (-10,0)    | (-5,-12)   |               13
> >          | (-5,-12)   | (0,0)      |               13
> >          | (0,0)      | (10,10)    | 14.1421356237309
> >          | (-3,4)     | (10,10)    | 14.3178210632764
> >          | (-5,-12)   | (-3,4)     | 16.1245154965971
> >          | (-10,0)    | (10,10)    | 22.3606797749979
> >          | (5.1,34.5) | (10,10)    | 24.9851956166046
> >          | (-5,-12)   | (10,10)    | 26.6270539113887
> >          | (-3,4)     | (5.1,34.5) | 31.5572495632937
> >          | (0,0)      | (5.1,34.5) | 34.8749193547455
> >          | (-10,0)    | (5.1,34.5) | 37.6597928831267
> >          | (-5,-12)   | (5.1,34.5) | 47.5842410888311
> > (15 rows)
> >
> > -- put distance result into output to allow sorting with GEQ optimizer - tgl 97/05/10
> > SELECT '' AS three, p1.f1 AS point1, p2.f1 AS point2, (p1.f1 <-> p2.f1) AS distance
> >    FROM POINT_TBL p1, POINT_TBL p2
> >    WHERE (p1.f1 <-> p2.f1) > 3 and p1.f1 << p2.f1 and p1.f1 >^ p2.f1
> >    ORDER BY distance;
> >  three |   point1   |  point2  |     distance
> > -------+------------+----------+------------------
> >        | (-3,4)     | (0,0)    |                5
> >        | (-10,0)    | (-5,-12) |               13
> >        | (5.1,34.5) | (10,10)  | 24.9851956166046
> > (3 rows)
> >
> > RESET geqo;
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 9: the planner will ignore your desire to choose an index scan if your
> >       joining column's datatypes do not match
> >
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
------- End of Original Message -------
Attachment

regression.diffs
pgsql-hackers by date:
From: Brad Nicholson
Date: 06 December 2004, 20:29:25
Subject: Re: V8 Beta 5 on AIX
From: Mark Wong
Date: 06 December 2004, 20:42:23
Subject: Re: [Testperf-general] Re: 8.0beta5 results w/ dbt2
Re: arm rc1 regression failures - Mailing list pgsql-hackers

Attachment

Previous

Next
