arm rc1 regression failures
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;
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/pointJim
--
-- 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 19073See 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?
------- End of Original Message -------
Attachments:
regression.diffstext/plain; name=regression.diffsDownload+8-8
Jim Buttafuoco wrote:
See attached
Well, that test passed for the last release, so what changed in between?
I don't think we changed the floating-point output again, did we?
--
Peter Eisentraut
http://learn.to/quote