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

crash in Gis_point::calculate_haversine

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: In Review (View Workflow)
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.6, 10.6.3
    • Fix Version/s: 10.3, 10.4, 10.5, 10.6
    • Component/s: GIS
    • Labels:
      None
    • Environment:
      Linux x64

      Description

       
      Version: '10.6.3-MariaDB'  MariaDB Server
       
      Thread 26 "mysqld" received signal SIGSEGV, Segmentation fault.
      (gdb) bt
      #0  in Gis_point::calculate_haversine at ./sql/spatial.cc:1112
      #1  in Gis_multi_point::spherical_distance_multipoints at ./sql/spatial.cc:2365
      #2  in Item_func_sphere_distance::spherical_distance_points at ./sql/item_geofunc.cc:2637
      #3  in Item_func_sphere_distance::val_real at ./sql/item_geofunc.cc:2568
      #4  in Item_func::is_null at ./sql/item_func.h:176
      #5  in mysql_do at ./sql/sql_do.cc:35
      #6  in mysql_execute_command at ./sql/sql_parse.cc:3976
      #7  in mysql_parse at ./sql/sql_parse.cc:8026
      #8  in dispatch_command at ./sql/sql_parse.cc:1896
      #9  in do_command at ./sql/sql_parse.cc:1405
      #10 in do_handle_one_connection at ./sql/sql_connect.cc:1410
      #11 in handle_one_connection at ./sql/sql_connect.cc:1312
      #12 in pfs_spawn_thread at ./storage/perfschema/pfs.cc:2201
      

      Testcase

      do st_distance_sphere(
       st_asbinary(
        polygon(
         linestring(
          point(-19655,-18908), 
          point(-10261,-7746), 
          point(31432,-18255), 
          point(-19655,-18908)
         ),
         linestring(
          point(-10494,19004),
          point(-18181,-24299),
          point(20616,19685),
          point(-10494,19004)
         ),
         linestring(
          point(8904,-21761),
          point(-24528,3798),
          point(-2502,-2889),
          point(8904,-21761)
         ),
         linestring(
          point(-7451,-19434),
          point(-30558,-27426),
          point(19086,17469),
          point(-7451,-19434)
         )
        )
       ),
       multipoint(
        point(124,204)
       ),
       3232164176
      );
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              holyfoot Alexey Botchkov
              Reporter:
              sbester1 sbester1
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

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