-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.5, 10.1, 10.0
-
Fix Version/s: 5.5.43
-
Labels:
-
Environment:Debian 7.8, Mariadb 10.0.17
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.
- relates to
-
MDEV-7512 GIS: ST_ synonyms for functions are not consistent
-
- Closed
-