/dports/databases/postgis25/postgis-2.5.5/regress/loader/ |
H A D | NotReallyMultiPoint-w.select.expected | 1 MULTIPOINT(580936.14282 819465.26182) 2 MULTIPOINT(506358.89382 607539.2573) 3 MULTIPOINT(630565.96358 527840.45893) 4 MULTIPOINT(315456.49222 345306.81409) 5 MULTIPOINT(471022.70077 736736.49304) 6 MULTIPOINT(500018.60921 615679.27508) 7 MULTIPOINT(219498.72249 315980.37513) 8 MULTIPOINT(319224.66926 318928.06245) 9 MULTIPOINT(568650.77442 460462.13034) 10 MULTIPOINT(556409.11354 729253.3099) [all …]
|
H A D | NotReallyMultiPoint.select.expected | 1 MULTIPOINT(580936.14282 819465.26182) 2 MULTIPOINT(506358.89382 607539.2573) 3 MULTIPOINT(630565.96358 527840.45893) 4 MULTIPOINT(315456.49222 345306.81409) 5 MULTIPOINT(471022.70077 736736.49304) 6 MULTIPOINT(500018.60921 615679.27508) 7 MULTIPOINT(219498.72249 315980.37513) 8 MULTIPOINT(319224.66926 318928.06245) 9 MULTIPOINT(568650.77442 460462.13034) 10 MULTIPOINT(556409.11354 729253.3099) [all …]
|
/dports/databases/postgis32/postgis-3.2.0/regress/loader/ |
H A D | NotReallyMultiPoint-w.select.expected | 1 MULTIPOINT(580936.14282 819465.26182) 2 MULTIPOINT(506358.89382 607539.2573) 3 MULTIPOINT(630565.96358 527840.45893) 4 MULTIPOINT(315456.49222 345306.81409) 5 MULTIPOINT(471022.70077 736736.49304) 6 MULTIPOINT(500018.60921 615679.27508) 7 MULTIPOINT(219498.72249 315980.37513) 8 MULTIPOINT(319224.66926 318928.06245) 9 MULTIPOINT(568650.77442 460462.13034) 10 MULTIPOINT(556409.11354 729253.3099) [all …]
|
H A D | NotReallyMultiPoint.select.expected | 1 MULTIPOINT(580936.14282 819465.26182) 2 MULTIPOINT(506358.89382 607539.2573) 3 MULTIPOINT(630565.96358 527840.45893) 4 MULTIPOINT(315456.49222 345306.81409) 5 MULTIPOINT(471022.70077 736736.49304) 6 MULTIPOINT(500018.60921 615679.27508) 7 MULTIPOINT(219498.72249 315980.37513) 8 MULTIPOINT(319224.66926 318928.06245) 9 MULTIPOINT(568650.77442 460462.13034) 10 MULTIPOINT(556409.11354 729253.3099) [all …]
|
/dports/databases/postgis31/postgis-3.1.4/regress/loader/ |
H A D | NotReallyMultiPoint.select.expected | 1 MULTIPOINT(580936.14282 819465.26182) 2 MULTIPOINT(506358.89382 607539.2573) 3 MULTIPOINT(630565.96358 527840.45893) 4 MULTIPOINT(315456.49222 345306.81409) 5 MULTIPOINT(471022.70077 736736.49304) 6 MULTIPOINT(500018.60921 615679.27508) 7 MULTIPOINT(219498.72249 315980.37513) 8 MULTIPOINT(319224.66926 318928.06245) 9 MULTIPOINT(568650.77442 460462.13034) 10 MULTIPOINT(556409.11354 729253.3099) [all …]
|
H A D | NotReallyMultiPoint-w.select.expected | 1 MULTIPOINT(580936.14282 819465.26182) 2 MULTIPOINT(506358.89382 607539.2573) 3 MULTIPOINT(630565.96358 527840.45893) 4 MULTIPOINT(315456.49222 345306.81409) 5 MULTIPOINT(471022.70077 736736.49304) 6 MULTIPOINT(500018.60921 615679.27508) 7 MULTIPOINT(219498.72249 315980.37513) 8 MULTIPOINT(319224.66926 318928.06245) 9 MULTIPOINT(568650.77442 460462.13034) 10 MULTIPOINT(556409.11354 729253.3099) [all …]
|
/dports/databases/postgis30/postgis-3.0.4/regress/loader/ |
H A D | NotReallyMultiPoint-w.select.expected | 1 MULTIPOINT(580936.14282 819465.26182) 2 MULTIPOINT(506358.89382 607539.2573) 3 MULTIPOINT(630565.96358 527840.45893) 4 MULTIPOINT(315456.49222 345306.81409) 5 MULTIPOINT(471022.70077 736736.49304) 6 MULTIPOINT(500018.60921 615679.27508) 7 MULTIPOINT(219498.72249 315980.37513) 8 MULTIPOINT(319224.66926 318928.06245) 9 MULTIPOINT(568650.77442 460462.13034) 10 MULTIPOINT(556409.11354 729253.3099) [all …]
|
H A D | NotReallyMultiPoint.select.expected | 1 MULTIPOINT(580936.14282 819465.26182) 2 MULTIPOINT(506358.89382 607539.2573) 3 MULTIPOINT(630565.96358 527840.45893) 4 MULTIPOINT(315456.49222 345306.81409) 5 MULTIPOINT(471022.70077 736736.49304) 6 MULTIPOINT(500018.60921 615679.27508) 7 MULTIPOINT(219498.72249 315980.37513) 8 MULTIPOINT(319224.66926 318928.06245) 9 MULTIPOINT(568650.77442 460462.13034) 10 MULTIPOINT(556409.11354 729253.3099) [all …]
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/gis/r/ |
H A D | spatial_utility_function_distance_sphere.result | 263 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')); 264 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')) 266 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')); 267 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')) 269 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')); 270 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')) 273 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(-179 0)')) 297 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(-150 -79)'), ST_GEOMFROMTEXT('MULTIPOINT(145 -2)')) 300 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(164 -37)'), ST_GEOMFROMTEXT('MULTIPOINT(67 59)')) 303 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(135 62)'), ST_GEOMFROMTEXT('MULTIPOINT(-116 -22)')) [all …]
|
H A D | geometry_class_attri_prop.result | 4017 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 4018 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 4019 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 4020 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 4021 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 4022 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 4023 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 4024 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 4025 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 4026 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 [all …]
|
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/gis/r/ |
H A D | spatial_utility_function_distance_sphere.result | 263 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')); 264 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')) 266 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')); 267 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')) 269 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')); 270 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')) 273 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(-179 0)')) 297 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(-150 -79)'), ST_GEOMFROMTEXT('MULTIPOINT(145 -2)')) 300 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(164 -37)'), ST_GEOMFROMTEXT('MULTIPOINT(67 59)')) 303 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(135 62)'), ST_GEOMFROMTEXT('MULTIPOINT(-116 -22)')) [all …]
|
H A D | geometry_class_attri_prop.result | 4017 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 4018 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 4019 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 4020 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 4021 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 4022 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 4023 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 4024 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 4025 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 4026 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 0 0 [all …]
|
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/gis/r/ |
H A D | spatial_utility_function_distance_sphere.result | 263 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')); 264 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')) 266 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')); 267 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')) 269 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')); 270 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')) 273 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(-179 0)')) 297 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(-150 -79)'), ST_GEOMFROMTEXT('MULTIPOINT(145 -2)')) 300 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(164 -37)'), ST_GEOMFROMTEXT('MULTIPOINT(67 59)')) 303 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(135 62)'), ST_GEOMFROMTEXT('MULTIPOINT(-116 -22)')) [all …]
|
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/gis/r/ |
H A D | spatial_utility_function_distance_sphere.result | 263 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')); 264 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')) 266 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')); 267 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')) 269 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')); 270 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')) 273 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(-179 0)')) 297 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(-150 -79)'), ST_GEOMFROMTEXT('MULTIPOINT(145 -2)')) 300 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(164 -37)'), ST_GEOMFROMTEXT('MULTIPOINT(67 59)')) 303 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(135 62)'), ST_GEOMFROMTEXT('MULTIPOINT(-116 -22)')) [all …]
|
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/gis/r/ |
H A D | spatial_utility_function_distance_sphere.result | 263 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')); 264 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')) 266 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')); 267 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')) 269 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')); 270 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')) 273 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(-179 0)')) 297 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(-150 -79)'), ST_GEOMFROMTEXT('MULTIPOINT(145 -2)')) 300 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(164 -37)'), ST_GEOMFROMTEXT('MULTIPOINT(67 59)')) 303 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(135 62)'), ST_GEOMFROMTEXT('MULTIPOINT(-116 -22)')) [all …]
|
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/gis/r/ |
H A D | spatial_utility_function_distance_sphere.result | 263 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')); 264 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')) 266 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')); 267 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')) 269 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')); 270 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')) 273 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(-179 0)')) 297 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(-150 -79)'), ST_GEOMFROMTEXT('MULTIPOINT(145 -2)')) 300 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(164 -37)'), ST_GEOMFROMTEXT('MULTIPOINT(67 59)')) 303 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(135 62)'), ST_GEOMFROMTEXT('MULTIPOINT(-116 -22)')) [all …]
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/gis/r/ |
H A D | spatial_utility_function_distance_sphere.result | 12 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(1 1)')); 13 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(1 1)')) 18 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(1 1)'), 1… 19 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(1 1)'), 1) 25 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)', 4047), ST_GEOMFROMTEXT('MULTIPOINT(1 1)', 404… 31 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)', 4326), ST_GEOMFROMTEXT('MULTIPOINT(1 1)', 432… 304 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')) 307 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')) 310 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')) 313 ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(-179 0)')) [all …]
|
H A D | geometry_class_attri_prop.result | 3824 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 3825 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 3826 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 3827 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 3828 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 3829 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 3830 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 3831 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 3832 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 3833 MULTIPOINT MULTIPOINT 0 0 0 0 1 1 0 0 [all …]
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/gis/t/ |
H A D | spatial_utility_function_distance_sphere.test | 248 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')); 250 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')); 253 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')); 256 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(-179 0)')… 260 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(180 90,0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(18… 262 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(180 0,0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180… 267 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(111 11,11 1)'), ST_GEOMFROMTEXT('MULTIPOINT(1… 273 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(-150 -79)'), ST_GEOMFROMTEXT('MULTIPOINT(145 … 276 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(164 -37)'), ST_GEOMFROMTEXT('MULTIPOINT(67 59… 278 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(135 62)'), ST_GEOMFROMTEXT('MULTIPOINT(-116 -… [all …]
|
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/gis/t/ |
H A D | spatial_utility_function_distance_sphere.test | 248 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')); 250 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')); 253 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')); 256 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(-179 0)')… 260 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(180 90,0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(18… 262 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(180 0,0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180… 267 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(111 11,11 1)'), ST_GEOMFROMTEXT('MULTIPOINT(1… 273 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(-150 -79)'), ST_GEOMFROMTEXT('MULTIPOINT(145 … 276 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(164 -37)'), ST_GEOMFROMTEXT('MULTIPOINT(67 59… 278 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(135 62)'), ST_GEOMFROMTEXT('MULTIPOINT(-116 -… [all …]
|
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/gis/t/ |
H A D | spatial_utility_function_distance_sphere.test | 248 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')); 250 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')); 253 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')); 256 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(-179 0)')… 260 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(180 90,0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(18… 262 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(180 0,0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180… 267 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(111 11,11 1)'), ST_GEOMFROMTEXT('MULTIPOINT(1… 273 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(-150 -79)'), ST_GEOMFROMTEXT('MULTIPOINT(145 … 276 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(164 -37)'), ST_GEOMFROMTEXT('MULTIPOINT(67 59… 278 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(135 62)'), ST_GEOMFROMTEXT('MULTIPOINT(-116 -… [all …]
|
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/gis/t/ |
H A D | spatial_utility_function_distance_sphere.test | 248 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')); 250 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')); 253 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')); 256 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(-179 0)')… 260 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(180 90,0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(18… 262 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(180 0,0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180… 267 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(111 11,11 1)'), ST_GEOMFROMTEXT('MULTIPOINT(1… 273 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(-150 -79)'), ST_GEOMFROMTEXT('MULTIPOINT(145 … 276 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(164 -37)'), ST_GEOMFROMTEXT('MULTIPOINT(67 59… 278 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(135 62)'), ST_GEOMFROMTEXT('MULTIPOINT(-116 -… [all …]
|
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/gis/t/ |
H A D | spatial_utility_function_distance_sphere.test | 248 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')); 250 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')); 253 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')); 256 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(-179 0)')… 260 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(180 90,0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(18… 262 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(180 0,0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180… 267 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(111 11,11 1)'), ST_GEOMFROMTEXT('MULTIPOINT(1… 273 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(-150 -79)'), ST_GEOMFROMTEXT('MULTIPOINT(145 … 276 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(164 -37)'), ST_GEOMFROMTEXT('MULTIPOINT(67 59… 278 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(135 62)'), ST_GEOMFROMTEXT('MULTIPOINT(-116 -… [all …]
|
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/gis/t/ |
H A D | spatial_utility_function_distance_sphere.test | 248 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')); 250 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')); 253 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')); 256 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(-179 0)')… 260 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(180 90,0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(18… 262 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(180 0,0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180… 267 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(111 11,11 1)'), ST_GEOMFROMTEXT('MULTIPOINT(1… 273 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(-150 -79)'), ST_GEOMFROMTEXT('MULTIPOINT(145 … 276 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(164 -37)'), ST_GEOMFROMTEXT('MULTIPOINT(67 59… 278 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(135 62)'), ST_GEOMFROMTEXT('MULTIPOINT(-116 -… [all …]
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/gis/t/ |
H A D | spatial_utility_function_distance_sphere.test | 26 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(1 1)')); 30 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(1 1)'), 1… 34 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)', 4047), ST_GEOMFROMTEXT('MULTIPOINT(1 1… 38 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)', 4326), ST_GEOMFROMTEXT('MULTIPOINT(1 1… 293 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 0)')); 295 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(180 0)')); 298 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(0 90)')); 301 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'), ST_GEOMFROMTEXT('MULTIPOINT(-179 0)')… 318 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(-150 -79)'), ST_GEOMFROMTEXT('MULTIPOINT(145 … 321 SELECT ST_DISTANCE_SPHERE(ST_GEOMFROMTEXT('MULTIPOINT(164 -37)'), ST_GEOMFROMTEXT('MULTIPOINT(67 59… [all …]
|