When creating a view using the following join:
it changes to:
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.