Details
Major Description
MariaDB [test]> select version();
|
+-----------------------+
|
| version() |
|
+-----------------------+
|
| 10.5.28-MariaDB-debug |
|
+-----------------------+
|
1 row in set (0,001 sec)
|
|
|
MariaDB [test]> SELECT ST_astext(ST_UNION( ST_GEOMFROMTEXT(' MULTIPOLYGON( ( (3 5, 2 5, 2 4, 3 4, 3 5) ), ( ( 7 7, 2 7, 4 9, 7 1, 7 7 ) ), ( ( 2 2, 2 8, 8 8, 8 2, 2 2 ), ( 4 4, 4 6, 6 6, 6 4, 4 4 ) ) ) '), ST_GEOMFROMTEXT('POLYGON((2 4,3 4,3 5,2 5,2 4))') )) с ;
|
+----------------------------------------------------------------------------------------------+
|
| с |
|
+----------------------------------------------------------------------------------------------+
|
| POLYGON((7 1,6.625 2,2 2,2 8,3 8,4 9,4.375 8,8 8,8 2,7 2,7 1),(4 4,4 6,5.125 6,5.875 4,4 4)) |
|
+----------------------------------------------------------------------------------------------+
|
1 row in set (0,002 sec)
|
mysql> SELECT ST_astext(ST_UNION( ST_GEOMFROMTEXT(' MULTIPOLYGON( ( (3 5, 2 5, 2 4, 3 4, 3 5) ), ( ( 7 7, 2 7, 4 9, 7 1, 7 7 ) ), ( ( 2 2, 2 8, 8 8, 8 2, 2 2 ), ( 4 4, 4 6, 6 6, 6 4, 4 4 ) ) ) '), ST_GEOMFROMTEXT('POLYGON((2 4,3 4,3 5,2 5,2 4))') )) с ;
|
+-------------------------------------------------------------------------------------+
|
| с |
|
+-------------------------------------------------------------------------------------+
|
| MULTIPOLYGON(((7 7,2 7,4 9,7 1,7 7)),((2 8,2 2,8 2,8 8,2 8),(4 4,4 6,6 6,6 4,4 4))) |
|
+-------------------------------------------------------------------------------------+
|
1 row in set (0,00 sec)
|
|
|
mysql> select version();
|
+-----------+
|
| version() |
|
+-----------+
|
| 9.1.0 |
|
+-----------+
|
1 row in set (0,00 sec)
|