Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL)
Description
For some functions there are ST_ synonyms, while for others (of the same kind) there are none. It makes SQL incompatible with e.g. PostGIS.
Example:
MariaDB [test]> select PolygonFromText(); |
ERROR 1582 (42000): Incorrect parameter count in the call to native function 'PolygonFromText' |
MariaDB [test]> select MultiPolygonFromText(); |
ERROR 1582 (42000): Incorrect parameter count in the call to native function 'MultiPolygonFromText' |
MariaDB [test]> select ST_PolygonFromText(); |
ERROR 1582 (42000): Incorrect parameter count in the call to native function 'ST_PolygonFromText' |
MariaDB [test]> select ST_MultiPolygonFromText(); |
ERROR 1305 (42000): FUNCTION test.ST_MultiPolygonFromText does not exist |
So, there are both PolygonFromText and ST_PolygonFromText, but only MultiPolygonFromText, no ST_MultiPolygonFromText.
There might be other ones missing as well.
Attachments
Issue Links
- relates to
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Affects Version/s | 5.5 [ 15800 ] |
| Fix Version/s | 10.1.4 [ 18400 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v2 [ 59341 ] | MariaDB v3 [ 65781 ] |
| Workflow | MariaDB v3 [ 65781 ] | MariaDB v4 [ 148750 ] |
There is also ST_Relate() only, not Relate(). Some of these functions are documented as behaving differently in the KB. For example, Within() is documented differently to ST_Within(). If this is correct, it's going to be very confusing to have some functions as synonyms, and others implemented differently.