|
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.
|