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

crash in Item_cond::eval_not_null_tables

    Details

      Description

      Version: '10.0.17-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
      [ERROR] mysqld got exception 0xc0000005 ;
      mysqld.exe!Item_func_eq::val_int()[item_cmpfunc.cc:1934]
      mysqld.exe!Item_cond::eval_not_null_tables()[item_cmpfunc.cc:4451]
      mysqld.exe!Item_func::walk()[item_func.cc:303]
      mysqld.exe!Item_cond::walk()[item_cmpfunc.cc:4520]
      mysqld.exe!st_select_lex::update_used_tables()[sql_lex.cc:3860]
      mysqld.exe!JOIN::optimize_inner()[sql_select.cc:1127]
      mysqld.exe!JOIN::optimize()[sql_select.cc:1024]
      mysqld.exe!mysql_select()[sql_select.cc:3296]
      mysqld.exe!handle_select()[sql_select.cc:373]
      mysqld.exe!execute_sqlcom_select()[sql_parse.cc:5262]
      mysqld.exe!mysql_execute_command()[sql_parse.cc:2550]
      mysqld.exe!mysql_parse()[sql_parse.cc:6522]
      mysqld.exe!dispatch_command()[sql_parse.cc:1303]
      mysqld.exe!do_command()[sql_parse.cc:1003]
      mysqld.exe!threadpool_process_request()[threadpool_common.cc:233]
      mysqld.exe!io_completion_callback()[threadpool_win.cc:568]

      You may get this error instead of crash, so maybe a client charset matters, or check under valgrind on linux:

      mysql> explain select 1 from t1 where _cp932 "1" in (select '1' from t1);
      ERROR 1267 (HY000): Illegal mix of collations (cp932_japanese_ci,COERCIBLE) and (latin1_swedish_ci,COERCIBLE) for operation '='

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

      drop table if exists t1;
      create table t1(a int)engine=innodb;
      insert into t1 values(1),(2),(3),(null);
      select 1 from t1 where _cp932 "1" in (select '1' from t1);

        Attachments

          Activity

            People

            • Assignee:
              psergey Sergei Petrunia
              Reporter:
              sbester1 sbester1
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: