[MDEV-7512] GIS: ST_ synonyms for functions are not consistent - Jira

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.

relates to

MDEV-7779 View definition changes upon creation

Transition	Time In Source Status	Execution Times

Alexey Botchkov made transition - 2015-02-14 19:08

Open

In Progress

17d 23h 35m

Alexey Botchkov made transition - 2015-03-15 22:21

In Progress

Closed

29d 3h 13m

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server