Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL)
-
Debian 7.8, Mariadb 10.0.17
Description
When creating a view using the following join:
...on(mbrcontains(`a`.`b`,geometryfromwkb(point(`y`.`z`,0)))) |
it changes to:
...on(mbrcontains(`a`.`b`,st_geometryfromwkb(st_point(`y`.`z`,0)))) |
which will not work since st_point is not a valid function.
When a query is executed with the same SQL as the view definition, it works as expected.
Three files are attached for duplicating the issue:
- test_setup.sql - Setup the test DB with tables, views and sample data
- test_query.sql - execute a query with the same SQL as the view in question
- test_create_view.sql - Create a view which is modified upon save as described above.
Attachments
Issue Links
- relates to
-
MDEV-7512 GIS: ST_ synonyms for functions are not consistent
- Closed