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

View definition changes upon creation

    XMLWordPrintable

    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: