Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7779

View definition changes upon creation

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.1, 10.0, 5.5
        • Fix Version/s: 5.5.43
        • Component/s: GIS, Views
        • Labels:
        • Environment:
          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.

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Bug - A problem which impairs or prevents the functions of the product. MDEV-7512 GIS: ST_ synonyms for functions are not consistent

                • Major - Major loss of function.
                • Closed

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  Thanks for the report and test case.

                  Show
                  elenst Elena Stepanova added a comment - Thanks for the report and test case.
                  Hide
                  Permalink
                  holyfoot Alexey Botchkov added a comment -

                  Fixing patch:
                  http://lists.askmonty.org/pipermail/commits/2015-April/007794.html

                  Show
                  holyfoot Alexey Botchkov added a comment - Fixing patch: http://lists.askmonty.org/pipermail/commits/2015-April/007794.html

                    People

                    • Assignee:
                      holyfoot Alexey Botchkov
                      Reporter:
                      Frio John Donofrio
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved:

                        Time Tracking

                        Estimated:
                        Original Estimate - Not Specified
                        Not Specified
                        Remaining:
                        Remaining Estimate - 0 minutes
                        0m
                        Logged:
                        Time Spent - 2 hours
                        2h