Details
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.
Gliffy Diagrams
Attachments
Issue Links
- relates to
-
MDEV-7779 View definition changes upon creation
-
- Closed
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
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.