diff -U3 /tmp/autopkgtest.6V8S06/build.MIr/src/debian/tests/expected/055_geography_funcs.test.out /tmp/regress.87VOWG/results/055_geography_funcs.test.out --- /tmp/autopkgtest.6V8S06/build.MIr/src/debian/tests/expected/055_geography_funcs.test.out 2023-05-29 20:41:45.000000000 +0000 +++ /tmp/regress.87VOWG/results/055_geography_funcs.test.out 2023-06-17 19:29:04.056559966 +0000 @@ -66,9 +66,9 @@ (1 row) SELECT ST_LineLocatePoint(geography 'Linestring(1 1,2 2)', 'Point(1 1)', false); - st_linelocatepoint --------------------- - 0 + st_linelocatepoint +----------------------- + 2.398573818138993e-17 (1 row) -- Empty geography -> NULL diff -U3 /tmp/autopkgtest.6V8S06/build.MIr/src/debian/tests/expected/064_tpoint_distance.test.out /tmp/regress.87VOWG/results/064_tpoint_distance.test.out --- /tmp/autopkgtest.6V8S06/build.MIr/src/debian/tests/expected/064_tpoint_distance.test.out 2023-05-29 20:41:45.000000000 +0000 +++ /tmp/regress.87VOWG/results/064_tpoint_distance.test.out 2023-06-17 19:29:13.616624719 +0000 @@ -718,15 +718,15 @@ (1 row) SELECT round(tgeogpoint '[Point(1.5 1.5)@2000-01-01, Point(2.5 2.5)@2000-01-02, Point(1.5 1.5)@2000-01-03]' <-> tgeogpoint '[Point(2.5 2.5)@2000-01-01, Point(1.5 1.5)@2000-01-02, Point(2.5 2.5)@2000-01-03]', 6); - round ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - [156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 12:00:00 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 12:00:00 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST] + round +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + [156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 11:59:59.999999 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 11:59:59.999999 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST] (1 row) SELECT round(tgeogpoint '{[Point(1.5 1.5)@2000-01-01, Point(2.5 2.5)@2000-01-02, Point(1.5 1.5)@2000-01-03],[Point(3.5 3.5)@2000-01-04, Point(3.5 3.5)@2000-01-05]}' <-> tgeogpoint '[Point(2.5 2.5)@2000-01-01, Point(1.5 1.5)@2000-01-02, Point(2.5 2.5)@2000-01-03]', 6); - round --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 12:00:00 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 12:00:00 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST]} + round +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 11:59:59.999999 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 11:59:59.999999 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST]} (1 row) SELECT round(tgeogpoint 'Point(1.5 1.5)@2000-01-01' <-> tgeogpoint '{[Point(2.5 2.5)@2000-01-01, Point(1.5 1.5)@2000-01-02, Point(2.5 2.5)@2000-01-03],[Point(3.5 3.5)@2000-01-04, Point(3.5 3.5)@2000-01-05]}', 6); @@ -742,15 +742,15 @@ (1 row) SELECT round(tgeogpoint '[Point(1.5 1.5)@2000-01-01, Point(2.5 2.5)@2000-01-02, Point(1.5 1.5)@2000-01-03]' <-> tgeogpoint '{[Point(2.5 2.5)@2000-01-01, Point(1.5 1.5)@2000-01-02, Point(2.5 2.5)@2000-01-03],[Point(3.5 3.5)@2000-01-04, Point(3.5 3.5)@2000-01-05]}', 6); - round --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 12:00:00 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 12:00:00 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST]} + round +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 11:59:59.999999 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 11:59:59.999999 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST]} (1 row) SELECT round(tgeogpoint '{[Point(1.5 1.5)@2000-01-01, Point(2.5 2.5)@2000-01-02, Point(1.5 1.5)@2000-01-03],[Point(3.5 3.5)@2000-01-04, Point(3.5 3.5)@2000-01-05]}' <-> tgeogpoint '{[Point(2.5 2.5)@2000-01-01, Point(1.5 1.5)@2000-01-02, Point(2.5 2.5)@2000-01-03],[Point(3.5 3.5)@2000-01-04, Point(3.5 3.5)@2000-01-05]}', 6); - round --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 12:00:00 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 12:00:00 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST], [0@Tue Jan 04 00:00:00 2000 PST, 0@Wed Jan 05 00:00:00 2000 PST]} + round +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 11:59:59.999999 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 11:59:59.999999 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST], [0@Tue Jan 04 00:00:00 2000 PST, 0@Wed Jan 05 00:00:00 2000 PST]} (1 row) SELECT round(tgeogpoint 'Point(1.5 1.5 1.5)@2000-01-01' <-> tgeogpoint 'Point(2.5 2.5 2.5)@2000-01-01', 6); @@ -814,15 +814,15 @@ (1 row) SELECT round(tgeogpoint '[Point(1.5 1.5 1.5)@2000-01-01, Point(2.5 2.5 2.5)@2000-01-02, Point(1.5 1.5 1.5)@2000-01-03]' <-> tgeogpoint '[Point(2.5 2.5 2.5)@2000-01-01, Point(1.5 1.5 1.5)@2000-01-02, Point(2.5 2.5 2.5)@2000-01-03]', 6); - round ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - [156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 12:00:00 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 12:00:00 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST] + round +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + [156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 11:59:59.999999 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 11:59:59.999999 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST] (1 row) SELECT round(tgeogpoint '{[Point(1.5 1.5 1.5)@2000-01-01, Point(2.5 2.5 2.5)@2000-01-02, Point(1.5 1.5 1.5)@2000-01-03],[Point(3.5 3.5 3.5)@2000-01-04, Point(3.5 3.5 3.5)@2000-01-05]}' <-> tgeogpoint '[Point(2.5 2.5 2.5)@2000-01-01, Point(1.5 1.5 1.5)@2000-01-02, Point(2.5 2.5 2.5)@2000-01-03]', 6); - round --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 12:00:00 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 12:00:00 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST]} + round +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 11:59:59.999999 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 11:59:59.999999 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST]} (1 row) SELECT round(tgeogpoint 'Point(1.5 1.5 1.5)@2000-01-01' <-> tgeogpoint '{[Point(2.5 2.5 2.5)@2000-01-01, Point(1.5 1.5 1.5)@2000-01-02, Point(2.5 2.5 2.5)@2000-01-03],[Point(3.5 3.5 3.5)@2000-01-04, Point(3.5 3.5 3.5)@2000-01-05]}', 6); @@ -838,15 +838,15 @@ (1 row) SELECT round(tgeogpoint '[Point(1.5 1.5 1.5)@2000-01-01, Point(2.5 2.5 2.5)@2000-01-02, Point(1.5 1.5 1.5)@2000-01-03]' <-> tgeogpoint '{[Point(2.5 2.5 2.5)@2000-01-01, Point(1.5 1.5 1.5)@2000-01-02, Point(2.5 2.5 2.5)@2000-01-03],[Point(3.5 3.5 3.5)@2000-01-04, Point(3.5 3.5 3.5)@2000-01-05]}', 6); - round --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 12:00:00 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 12:00:00 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST]} + round +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 11:59:59.999999 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 11:59:59.999999 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST]} (1 row) SELECT round(tgeogpoint '{[Point(1.5 1.5 1.5)@2000-01-01, Point(2.5 2.5 2.5)@2000-01-02, Point(1.5 1.5 1.5)@2000-01-03],[Point(3.5 3.5 3.5)@2000-01-04, Point(3.5 3.5 3.5)@2000-01-05]}' <-> tgeogpoint '{[Point(2.5 2.5 2.5)@2000-01-01, Point(1.5 1.5 1.5)@2000-01-02, Point(2.5 2.5 2.5)@2000-01-03],[Point(3.5 3.5 3.5)@2000-01-04, Point(3.5 3.5 3.5)@2000-01-05]}', 6); - round ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------