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

View definition changes upon creation

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5, 10.0, 10.1
    • 5.5.43
    • GIS, Views
    • 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
          John Donofrio
        2. test_query.sql
          0.5 kB
          John Donofrio
        3. test_setup.sql
          10 kB
          John Donofrio

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.