Bug #81532 virtual enum_field_types Item::field_type() const: Assertion `0' failed.
Submitted: 23 May 2016 2:01 Modified: 16 Dec 2019 22:40
Reporter: Roel Van de Paar Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DML Severity:S6 (Debug Builds)
Version:5.6.30 OS:Any
Assigned to: CPU Architecture:Any

[23 May 2016 2:01] Roel Van de Paar
Description:
mysqld: /sda/mysql-5.6.30_dbg/sql/item.cc:5916: virtual enum_field_types Item::field_type() const: Assertion `0' failed.
01:46:44 UTC - mysqld got signal 6 ;

+bt
#0  0x00007f66f2eb8741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1  0x0000000000a9bd32 in my_write_core (sig=6) at /sda/mysql-5.6.30_dbg/mysys/stacktrace.c:422
#2  0x000000000072bbc0 in handle_fatal_signal (sig=6) at /sda/mysql-5.6.30_dbg/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x00007f66f14595f7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5  0x00007f66f145ace8 in __GI_abort () at abort.c:90
#6  0x00007f66f1452566 in __assert_fail_base (fmt=0x7f66f15a2228 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0xe72f66 "0", file=file@entry=0xe73178 "/sda/mysql-5.6.30_dbg/sql/item.cc", line=line@entry=5916, function=function@entry=0xe75a00 <Item::field_type() const::__PRETTY_FUNCTION__> "virtual enum_field_types Item::field_type() const") at assert.c:92
#7  0x00007f66f1452612 in __GI___assert_fail (assertion=0xe72f66 "0", file=0xe73178 "/sda/mysql-5.6.30_dbg/sql/item.cc", line=5916, function=0xe75a00 <Item::field_type() const::__PRETTY_FUNCTION__> "virtual enum_field_types Item::field_type() const") at assert.c:101
#8  0x0000000000662c0c in Item::field_type (this=0x7f6633a74e80) at /sda/mysql-5.6.30_dbg/sql/item.cc:5916
#9  0x0000000000656fd9 in Item::is_blob_field (this=0x7f6633a74e80) at /sda/mysql-5.6.30_dbg/sql/item.cc:1539
#10 0x00000000009b124b in semijoin_types_allow_materialization (sj_nest=0x7f6633a77010) at /sda/mysql-5.6.30_dbg/sql/sql_optimizer.cc:3909
#11 0x00000000009b20fb in optimize_semijoin_nests_for_materialization (join=0x7f6633a73c58) at /sda/mysql-5.6.30_dbg/sql/sql_optimizer.cc:4360
#12 0x00000000009b0c3a in make_join_statistics (join=0x7f6633a73c58, tables_arg=0x7f6633a25200, conds=0x0, keyuse_array=0x7f6633a73e80, first_optimization=true) at /sda/mysql-5.6.30_dbg/sql/sql_optimizer.cc:3765
#13 0x00000000009a7e3e in JOIN::optimize (this=0x7f6633a73c58) at /sda/mysql-5.6.30_dbg/sql/sql_optimizer.cc:365
#14 0x00000000008073f2 in mysql_execute_select (thd=0x7f66ef6a8800, select_lex=0x7f66ef6aacd0, free_join=true) at /sda/mysql-5.6.30_dbg/sql/sql_select.cc:1087
#15 0x0000000000807739 in mysql_select (thd=0x7f66ef6a8800, tables=0x7f6633a25200, wild_num=0, fields=..., conds=0x7f6633a26e18, order=0x7f66ef6aae98, group=0x7f66ef6aadd0, having=0x0, select_options=2147748608, result=0x7f6633a26fc0, unit=0x7f66ef6aa688, select_lex=0x7f66ef6aacd0) at /sda/mysql-5.6.30_dbg/sql/sql_select.cc:1222
#16 0x000000000080581f in handle_select (thd=0x7f66ef6a8800, result=0x7f6633a26fc0, setup_tables_done_option=0) at /sda/mysql-5.6.30_dbg/sql/sql_select.cc:110
#17 0x00000000007df8da in execute_sqlcom_select (thd=0x7f66ef6a8800, all_tables=0x7f6633a25200) at /sda/mysql-5.6.30_dbg/sql/sql_parse.cc:5133
#18 0x00000000007d86cf in mysql_execute_command (thd=0x7f66ef6a8800) at /sda/mysql-5.6.30_dbg/sql/sql_parse.cc:2655
#19 0x00000000007e2460 in mysql_parse (thd=0x7f66ef6a8800, rawbuf=0x7f6633a25010 "SELECT 1 FROM t1 WHERE(SELECT 1,2 FROM t1)IN (SELECT 1,2 FROM t1)", length=65, parser_state=0x7f66f34c35a0) at /sda/mysql-5.6.30_dbg/sql/sql_parse.cc:6385
#20 0x00000000007d5649 in dispatch_command (command=COM_QUERY, thd=0x7f66ef6a8800, packet=0x7f66459c8c41 "SELECT 1 FROM t1 WHERE(SELECT 1,2 FROM t1)IN (SELECT 1,2 FROM t1)", packet_length=65) at /sda/mysql-5.6.30_dbg/sql/sql_parse.cc:1339
#21 0x00000000007d469c in do_command (thd=0x7f66ef6a8800) at /sda/mysql-5.6.30_dbg/sql/sql_parse.cc:1036
#22 0x000000000079bf91 in do_handle_one_connection (thd_arg=0x7f66ef6a8800) at /sda/mysql-5.6.30_dbg/sql/sql_connect.cc:982
#23 0x000000000079ba7a in handle_one_connection (arg=0x7f66ef6a8800) at /sda/mysql-5.6.30_dbg/sql/sql_connect.cc:898
#24 0x0000000000df92d1 in pfs_spawn_thread (arg=0x7f66d5b9bae0) at /sda/mysql-5.6.30_dbg/storage/perfschema/pfs.cc:1860
#25 0x00007f66f2eb3dc5 in start_thread (arg=0x7f66f34c4700) at pthread_create.c:308
#26 0x00007f66f151a21d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(f1 CHAR (1))ENGINE=InnoDB;
INSERT INTO t1 VALUES(0xACAC);
SELECT 1 FROM t1 WHERE(SELECT 1,2 FROM t1)IN (SELECT 1,2 FROM t1);
[23 May 2016 6:06] MySQL Verification Team
Hello Roel,

Thank you for the report and test case.
Observed that 5.6.30(also, 5.6.32 daily) debug build is affected.

Thanks,
Umesh
[23 May 2016 6:10] MySQL Verification Team
I'm not seeing any issues in 5.5.49/5.7.12 debug/release builds with provided test case.
[16 Dec 2019 22:40] Roy Lyseng
Posted by developer:
 
Fixed in 5.7.12