Changeset 2055

Timestamp:

11/23/05 05:46:35 (6 years ago)

Author:

strk

Message:

Added a few regression tests for LRS functions

Location:

trunk/regress

Files:

• regress_expected (modified) (1 diff)
• regress.sql (modified) (1 diff)

trunk/regress/regress_expected

@@ -149 +149 @@
 147|POINT(1 2 3 0)
 144|LINESTRING(-5 -5,0 0,1 1,4 4)
+2d|
+3dz|
+PNTM_1|GEOMETRYCOLLECTIONM EMPTY
+PNTM_2|POINTM(1 2 3)
+PNTM_3|POINTM(1 2 3)
+PNTM_4|POINTM(1 2 3)
+PNTM_5|GEOMETRYCOLLECTIONM EMPTY
+MPNT_1|GEOMETRYCOLLECTIONM(POINT(1 2 2))
+MPNT_2|GEOMETRYCOLLECTIONM(POINT(2 2 5))
+MPNT_3|GEOMETRYCOLLECTIONM EMPTY
+MPNT_4|GEOMETRYCOLLECTIONM(POINT(1 2 8),POINT(2 2 5))
+COLL_1|
+LINEZM_1|GEOMETRYCOLLECTION(LINESTRING(0 8 80 2,0 0 0 10))
+LINEZM_2|GEOMETRYCOLLECTION(LINESTRING(0 8 20 2,0 0 100 10))
+LINEZM_3|GEOMETRYCOLLECTION(LINESTRING(0 8 80 2,0 0 0 10,8 0 0 2))
+LINEZM_4|GEOMETRYCOLLECTION(LINESTRING(0 9 90 2,0 1 10 18),LINESTRING(1 0 0 18,9 0 0 2))
+LINEZM_5|GEOMETRYCOLLECTION(LINESTRING(0 9 90 2,0 1 10 18),LINESTRING(5.5 4.5 4.5 18,9.5 0.5 0.5 2))

trunk/regress/regress.sql

@@ -245 +245 @@
 
 select '144', asewkt(linemerge('GEOMETRYCOLLECTION(LINESTRING(0 0, 1 1), LINESTRING(4 4, 1 1), LINESTRING(-5 -5, 0 0))'::geometry));
+
+--------------------------------
+-- LRS functions
+--------------------------------
+
+-- No M value
+select '2d',asewkt(locate_along_measure('POINT(1 2)', 1));
+select '3dz',asewkt(locate_along_measure('POINT(1 2 3)', 1));
+
+-- Points
+select 'PNTM_1',asewkt(locate_along_measure('POINTM(1 2 3)', 1));
+select 'PNTM_2',asewkt(locate_along_measure('POINTM(1 2 3)', 3));
+select 'PNTM_3',asewkt(locate_between_measures('POINTM(1 2 3)', 2, 3));
+select 'PNTM_4',asewkt(locate_between_measures('POINTM(1 2 3)', 3, 4));
+select 'PNTM_5',asewkt(locate_between_measures('POINTM(1 2 4.00001)', 3, 4));
+
+-- Multipoints
+select 'MPNT_1',asewkt(locate_between_measures('MULTIPOINTM(1 2 2)', 2, 5));
+select 'MPNT_2', asewkt(locate_between_measures('MULTIPOINTM(1 2 8, 2 2 5, 2 1 0)', 2, 5));
+select 'MPNT_3', asewkt(locate_between_measures('MULTIPOINTM(1 2 8, 2 2 5.1, 2 1 0)', 2, 5));
+select 'MPNT_4', asewkt(locate_between_measures('MULTIPOINTM(1 2 8, 2 2 5, 2 1 0)', 4, 8));
+
+
+-- Collections
+select 'COLL_1', asewkt(locate_between_measures('GEOMETRYCOLLECTION(MULTIPOINTM(1 2 8, 2 2 5.0, 2 1 0),MULTIPOINT(0 0 1))', 2, 5));
+
+-- Linestrings
+select 'LINEZM_1', asewkt(locate_between_measures('LINESTRING(0 10 100 0, 0 0 0 10)', 2, 18));
+select 'LINEZM_2', asewkt(locate_between_measures('LINESTRING(0 10 0 0, 0 0 100 10)', 2, 18));
+select 'LINEZM_3', asewkt(locate_between_measures('LINESTRING(0 10 100 0, 0 0 0 10, 10 0 0 0)', 2, 18));
+select 'LINEZM_4', asewkt(locate_between_measures('LINESTRING(0 10 100 0, 0 0 0 20, 10 0 0 0)', 2, 18));
+select 'LINEZM_5', asewkt(locate_between_measures('LINESTRING(0 10 100 0, 0 0 0 20, 0 10 10 40, 10 0 0 0)', 2, 18));