Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.4, 10.5(EOL), 11.2(EOL), 11.6(EOL)
-
None
Description
it seems to be also the correct answer, but it is not compatible with Mysql. also it gets huge if geometry is somewhat bigger:
MariaDB [test]> SELECT st_astext(st_union(st_geomfromtext( 'LINESTRING(-13 -16,9 16,9 -10,-7 20)'), st_geomfromtext('POINT(7 0)')));
|
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| st_astext(st_union(st_geomfromtext( 'LINESTRING(-13 -16,9 16,9 -10,-7 20)'), st_geomfromtext('POINT(7 0)'))) |
|
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| GEOMETRYCOLLECTION(LINESTRING(-13 -16,1.1911262798634823 4.641638225255974),LINESTRING(1.1911262798634823 4.641638225255974,9 -10,9 16,1.1911262798634823 4.641638225255974),POINT(7 0),LINESTRING(1.1911262798634823 4.641638225255974,-7 20)) |
|
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0,011 sec)
|
in mysql:
mysql> SELECT st_astext(st_union(st_geomfromtext( 'LINESTRING(-13 -16,9 16,9 -10,-7 20)'), st_geomfromtext('POINT(7 0)')));
|
+---------------------------------------------------------------------------------------------------------------+
|
| st_astext(st_union(st_geomfromtext( 'LINESTRING(-13 -16,9 16,9 -10,-7 20)'), st_geomfromtext('POINT(7 0)'))) |
|
+---------------------------------------------------------------------------------------------------------------+
|
| GEOMETRYCOLLECTION(LINESTRING(-13 -16,9 16,9 -10,-7 20),POINT(7 0)) |
|
+---------------------------------------------------------------------------------------------------------------+
|
1 row in set (0,00 sec)
|
e.g.:
MariaDB [test]> SELECT st_astext(st_union(st_geomfromtext( 'GEOMETRYCOLLECTION(MULTIPOINT(0 14,-9 -11),MULTILINESTRING((-11 -2,17 -14),(18 -12,18 -8),(-13 -16,9 16,9 -10,-7 20),(-14 -5,10 -9,4 1,17 -8),(-9 -4,-2 -12,9 -13,-5 4),(15 17,13 20)))'), st_geomfromtext('POINT(7 0)'))) a;
|
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| a |
|
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| GEOMETRYCOLLECTION(LINESTRING(-13 -16,-6.62 -6.720000000000001),LINESTRING(17 -14,5.909090909090909 -9.246753246753247),LINESTRING(-6.62 -6.720000000000001,-2 -12,9 -13,5.909090909090909 -9.246753246753247),LINESTRING(18 -12,18 -8),POINT(-9 -11),LINESTRING(8.317073170731707 -8.71951219512195,9 -10,9 -8.833333333333334),LINESTRING(5.909090909090909 -9.246753246753247,2.3636363636363633 -7.7272727272727275),LINESTRING(5.909090909090909 -9.246753246753247,5.0227272727272725 -8.170454545454545),LINESTRING(9 -8.833333333333334,10 -9,9 -7.333333333333334),LINESTRING(9 -8.833333333333334,8.317073170731707 -8.71951219512195),LINESTRING(9 -8.833333333333334,9 -7.333333333333334),LINESTRING(8.317073170731707 -8.71951219512195,5.0227272727272725 -8.170454545454545),LINESTRING(8.317073170731707 -8.71951219512195,1.1911262798634823 4.641638225255974),LINESTRING(5.0227272727272725 -8.170454545454545,2.3636363636363633 -7.7272727272727275),LINESTRING(5.0227272727272725 -8.170454545454545,-1.8661800486617999 0.19464720194647356),LINESTRING(17 -8,9 -2.4615384615384617),LINESTRING(2.3636363636363633 -7.7272727272727275,-6.317757009345795 -6.280373831775702),LINESTRING(2.3636363636363633 -7.7272727272727275,-5.110344827586207 -4.524137931034483),LINESTRING(9 -7.333333333333334,4 1,9 -2.4615384615384617),LINESTRING(9 -7.333333333333334,9 -2.4615384615384617),LINESTRING(-6.62 -6.720000000000001,-7.121951219512195 -6.146341463414634),LINESTRING(-6.62 -6.720000000000001,-6.317757009345795 -6.280373831775702),LINESTRING(-6.317757009345795 -6.280373831775702,-7.121951219512195 -6.146341463414634),LINESTRING(-6.317757009345795 -6.280373831775702,-5.110344827586207 -4.524137931034483),LINESTRING(-7.121951219512195 -6.146341463414634,-14 -5),LINESTRING(-7.121951219512195 -6.146341463414634,-9 -4),LINESTRING(-5.110344827586207 -4.524137931034483,-11 -2),LINESTRING(-5.110344827586207 -4.524137931034483,-1.8661800486617999 0.19464720194647356),LINESTRING(9 -2.4615384615384617,9 16,1.1911262798634823 4.641638225255974),POINT(7 0),LINESTRING(-1.8661800486617999 0.19464720194647356,-5 4),LINESTRING(-1.8661800486617999 0.19464720194647356,1.1911262798634823 4.641638225255974),LINESTRING(1.1911262798634823 4.641638225255974,-7 20),POINT(0 14),LINESTRING(15 17,13 20)) |
|
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0,005 sec)
|
Attachments
Issue Links
- relates to
-
-
- Stalled
-