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

View definition changes upon creation

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5, 10.0, 10.1
    • 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.

        Attachments

        1. test_create_view.sql
          0.6 kB
        2. test_query.sql
          0.5 kB
        3. test_setup.sql
          10 kB

          Issue Links

            Activity

              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: