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
-
MDEV-7779 View definition changes upon creation
- Closed