Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.3.12, 5.5(EOL), 10.0(EOL), 10.1(EOL)
-
Windows, Linux
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); |