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

cte + geometry crash

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3.10, 10.2, 10.3, 10.4, 10.5, 10.6, 10.9, 10.10, 10.11, 11.0, 11.1, 11.2
    • 10.4, 10.5, 10.6, 10.11, 11.0
    • GIS
    • None
    • Win x64

    Description

      Version: '10.3.10-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
      [ERROR] mysqld got exception 0xc0000005 ;
      terribly wrong...
      mysqld.exe!Gcalc_scan_iterator::event_point::simple_event()[gcalc_slicescan.h:424]
      mysqld.exe!Item_func_distance::val_real()[item_geofunc.cc:2434]
      mysqld.exe!Item_cache_real::cache_value()[item.cc:10065]
      mysqld.exe!Item_cache_real::val_real()[item.cc:10073]
      mysqld.exe!Item_direct_ref::val_real()[item.cc:8434]
      mysqld.exe!Arg_comparator::compare_real()[item_cmpfunc.cc:802]
      mysqld.exe!Item_func_le::val_int()[item_cmpfunc.cc:1775]
      mysqld.exe!evaluate_join_record()[sql_select.cc:19393]
      mysqld.exe!sub_select()[sql_select.cc:19295]
      mysqld.exe!do_select()[sql_select.cc:18835]
      mysqld.exe!JOIN::exec_inner()[sql_select.cc:4037]
      mysqld.exe!JOIN::exec()[sql_select.cc:3830]
      mysqld.exe!mysql_select()[sql_select.cc:4236]
      mysqld.exe!mysql_derived_fill()[sql_derived.cc:1168]
      mysqld.exe!mysql_handle_single_derived()[sql_derived.cc:197]
      mysqld.exe!st_join_table::preread_init()[sql_select.cc:12472]
      mysqld.exe!sub_select()[sql_select.cc:19263]
      mysqld.exe!do_select()[sql_select.cc:18835]
      mysqld.exe!JOIN::exec_inner()[sql_select.cc:4037]
      mysqld.exe!JOIN::exec()[sql_select.cc:3830]
      mysqld.exe!mysql_select()[sql_select.cc:4236]
      mysqld.exe!handle_select()[sql_select.cc:370]
      mysqld.exe!execute_sqlcom_select()[sql_parse.cc:6547]
      mysqld.exe!mysql_execute_command()[sql_parse.cc:3769]
      mysqld.exe!mysql_parse()[sql_parse.cc:8096]
      mysqld.exe!dispatch_command()[sql_parse.cc:1852]
      mysqld.exe!do_command()[sql_parse.cc:1394]
      mysqld.exe!threadpool_process_request()[threadpool_common.cc:358]
      mysqld.exe!tp_callback()[threadpool_common.cc:186]
      

      How to Repeat (non-simplified testcase):

      drop table if exists t;
      create table t(a int)engine=innodb;
      insert into t values(1);
      with  recursive   cte1  
      as( select(st_distance(point(21510,694)  ,
      st_geomcollfromwkb(geometrycollection( linestring( point(25379,17862), point(6681,30275), 
      point(-26660,1.657696e+308), point(-19034, 9236.9238), point(3476,-10459), point(11969,27300), 
      point(-14087,-9794), point(1.494934e+308,-13287)),linestring( point(12321,4518), 
      point(8032,21492), point(-8325,-25260), point(-28709,-3642), point(29325,-25119), 
      point(21317,8796093022210), point(-20917,-28292), point(19939,-22107), 
      point(-8084,-6337)))  )  ) )as a1  from  t  ) 
      select cte1 .a1   from cte1  
      where cte1 .a1  <= 'B! .$ ,*f* #} *-<}*#!c /e{A ^a$$ :*0^*}*=5c > $';
      
      

      Attachments

        Issue Links

          Activity

            People

              holyfoot Alexey Botchkov
              sbester1 sbester1
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.