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

            Ascending order - Click to sort in descending order
            lstartseva Lena Startseva created issue -
            lstartseva Lena Startseva made changes -
            Field Original Value New Value
            lstartseva Lena Startseva made changes -
            Attachment v1.frm [ 67512 ]
            lstartseva Lena Startseva made changes -
            Description *Test:*
            {code:sql}
            st_distance_sphere(point(0,90), multipoint(point(24,20)))
            7783627.7608924415

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

            drop view v1;
            {code}

            *Expected result:*
            {code:sql}
            st_distance_sphere(point(0,90), multipoint(point(24,20)))
            7783627.7608924415

            st_distance_sphere(point(0,90), multipoint(point(24,20)))
            7783627.7608924415
            {code}

            *Actual result:*
            {code:sql}
            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
            {code}             		*Test:*
            {code:sql}
            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;
            {code}

            *Expected result:*
            {code:sql}
            st_distance_sphere(point(0,90), multipoint(point(24,20)))
            7783627.7608924415

            st_distance_sphere(point(0,90), multipoint(point(24,20)))
            7783627.7608924415
            {code}

            *Actual result:*
            {code:sql}
            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
            {code}
            serg Sergei Golubchik made changes -
            Assignee Oleksandr Byelkin [ sanja ] Alexey Botchkov [ holyfoot ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.3 [ 22126 ]
            alice Alice Sherepa added a comment -

            10.5-11.6 currently return the expected results

            alice Alice Sherepa added a comment - 10.5-11.6 currently return the expected results
            alice Alice Sherepa made changes -
            Component/s GIS [ 10105 ]
            Fix Version/s N/A [ 14700 ]
            Fix Version/s 10.4(EOL) [ 22408 ]
            Resolution Cannot Reproduce [ 5 ]
            Status Open [ 1 ] Closed [ 6 ]

            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.