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

In view definition (in .frm) 'multipoint' is changed to 'geometrycollection' that causes internal error

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.3(EOL), 10.4(EOL)
    • N/A
    • GIS

    Description

      Test:

      select st_distance_sphere(point(0,90), multipoint(point(24,20)));
      		 
       
      		 
      create view v1 as select st_distance_sphere(point(0,90), multipoint(point(24,20)));
      		 
      select * from v1;
      		 
       
      		 
      drop view v1;

      Expected result:

      st_distance_sphere(point(0,90), multipoint(point(24,20)))
      		 
      7783627.7608924415
      		 
       
      		 
      st_distance_sphere(point(0,90), multipoint(point(24,20)))
      		 
      7783627.7608924415

      Actual result:

      st_distance_sphere(point(0,90), multipoint(point(24,20)))
      		 
      7783627.7608924415
      		 
       
      		 
      At line 4: query 'select * from v1' failed: 1815: Internal error: st_distance_sphere

      Attachments

        Issue Links

          is part of

          Technical task - A technical task. MDEV-27691 make working view-protocol

          • Major - Major loss of function.
          • Closed

          Activity

            People

              holyfoot Alexey Botchkov
              lstartseva Lena Startseva
              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.