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

cte + geometry crash

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Confirmed (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.2, 10.3, 10.3.10
    • Fix Version/s: 10.2, 10.3
    • Component/s: None
    • Labels:
      None
    • Environment:
      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

          Activity

            People

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

              Dates

              • Created:
                Updated: