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.