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

crash in Item::save_in_field with empty enum value

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.8, 10.1.11
    • Fix Version/s: 10.1.13
    • Component/s: Optimizer
    • Labels:
      None
    • Sprint:
      10.1.13

      Description

      Version: '10.1.11-MariaDB' mariadb.org binary distribution
      [ERROR] mysqld got exception 0xc0000005 ;
      mysqld.exe!Item::save_in_field()[item.cc:5908]
      mysqld.exe!Item::save_in_field_no_warnings()[item.cc:1353]
      mysqld.exe!Item_bool_func::get_mm_leaf()[opt_range.cc:7794]
      mysqld.exe!Item_bool_func::get_mm_parts()[opt_range.cc:7611]
      mysqld.exe!Item_bool_func2_with_rev::get_func_mm_tree()[item_cmpfunc.h:422]
      mysqld.exe!Item_bool_func::get_full_func_mm_tree()[opt_range.cc:7311]
      mysqld.exe!Item_bool_func::get_full_func_mm_tree_for_args()[item_cmpfunc.h:180]
      mysqld.exe!Item_bool_func2_with_rev::get_mm_tree()[item_cmpfunc.h:450]
      mysqld.exe!SQL_SELECT::test_quick_select()[opt_range.cc:2540]
      mysqld.exe!get_quick_record_count()[sql_select.cc:3490]
      mysqld.exe!make_join_statistics()[sql_select.cc:4108]
      mysqld.exe!JOIN::optimize_inner()[sql_select.cc:1375]
      mysqld.exe!JOIN::optimize()[sql_select.cc:1036]
      mysqld.exe!mysql_select()[sql_select.cc:3437]
      mysqld.exe!handle_select()[sql_select.cc:384]
      mysqld.exe!execute_sqlcom_select()[sql_parse.cc:5903]
      mysqld.exe!mysql_execute_command()[sql_parse.cc:2962]
      mysqld.exe!mysql_parse()[sql_parse.cc:7308]
      mysqld.exe!dispatch_command()[sql_parse.cc:1491]
      mysqld.exe!do_command()[sql_parse.cc:1109]
      mysqld.exe!threadpool_process_request()[threadpool_common.cc:239]
      mysqld.exe!io_completion_callback()[threadpool_win.cc:568]

      How to repeat
      ---------------

      set sql_mode='';
      drop table if exists t;
      create table t (a enum('a'),b time,c int,key(b)) engine=innodb;
      insert into t values ('','00:00:00',0);
      select 1 from t where (select a from t group by c) = b;

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              bar Alexander Barkov
              Reporter:
              sbester1 sbester1
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration