Details
Description
https://mariadb.com/kb/en/st-crosses/ : Returns 1 if geometry g1 spatially crosses geometry g2. Returns NULL if g1 is a Polygon or a MultiPolygon, or if g2 is a Point or a MultiPoint. Otherwise, returns 0.
MariaDB [test]> SELECT ST_CROSSES( ST_GEOMFROMTEXT('point(1 1)'), st_geomfromtext('point(1 1)') ) a;
|
+------+
|
| a |
|
+------+
|
| 0 |
|
+------+
|
1 row in set (0,000 sec)
|
|
|
MariaDB [test]> SELECT ST_CROSSES( ST_GEOMFROMTEXT('POLYGON ((59 18,67 18,67 13,59 13,59 18)) '), st_geomfromtext('polygon((2 2,2 4, 4 2,2 2))') ) a;
|
+------+
|
| a |
|
+------+
|
| 0 |
|
+------+
|
1 row in set (0,001 sec)
|
|
|
MariaDB [test]> SELECT ST_CROSSES( ST_GEOMFROMTEXT('POLYGON ((59 18,67 18,67 13,59 13,59 18)) '), st_geomfromtext('point(1 1)') ) a;
|
+------+
|
| a |
|
+------+
|
| 0 |
|
+------+
|
1 row in set (0,000 sec)
|
|
from the KB example:
|
MariaDB [test]> SET @g1 = ST_GEOMFROMTEXT('LINESTRING(174 149, 176 151)');
|
Query OK, 0 rows affected (0,000 sec)
|
|
|
MariaDB [test]> SET @g2 = ST_GEOMFROMTEXT('POLYGON((175 150, 20 40, 50 60, 125 100, 175 150))');
|
Query OK, 0 rows affected (0,009 sec)
|
|
|
MariaDB [test]> SELECT ST_CROSSES(@g1,@g2);
|
+---------------------+
|
| ST_CROSSES(@g1,@g2) |
|
+---------------------+
|
| 1 |
|
+---------------------+
|
1 row in set (0,002 sec)
|
|
|
MariaDB [test]> SELECT ST_CROSSES(@g2,@g1); ## NULL expected
|
+---------------------+
|
| ST_CROSSES(@g2,@g1) |
|
+---------------------+
|
| 1 |
|
+---------------------+
|
1 row in set (0,001 sec)
|
mysql> SET @g1 = ST_GEOMFROMTEXT('LINESTRING(174 149, 176 151)');
|
Query OK, 0 rows affected (0,01 sec)
|
|
|
mysql> SET @g2 = ST_GEOMFROMTEXT('POLYGON((175 150, 20 40, 50 60, 125 100, 175 150))');
|
Query OK, 0 rows affected (0,00 sec)
|
|
|
mysql> SELECT ST_CROSSES(@g1,@g2);
|
+---------------------+
|
| ST_CROSSES(@g1,@g2) |
|
+---------------------+
|
| 0 |
|
+---------------------+
|
1 row in set (0,00 sec)
|
|
|
mysql> SELECT ST_CROSSES(@g2,@g1);
|
+---------------------+
|
| ST_CROSSES(@g2,@g1) |
|
+---------------------+
|
| NULL |
|
+---------------------+
|
1 row in set (0,00 sec)
|
Attachments
Issue Links
- relates to
-
MDEV-35201 ST_CROSSES returns different result than Mysql for 2 linestrings
-
- Open
-