Description:
mysqld: /sdc/percona-server/sql/item_row.cc:87: void Item_row::illegal_method_call(const char*): Assertion `0' failed.
+bt
#0 0x00007fc0b3f9d771 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x0000000000a9804e in my_write_core (sig=6) at /bzr/mysql-5.6.23/mysys/stacktrace.c:422
#2 0x00000000007277f0 in handle_fatal_signal (sig=6) at /bzr/mysql-5.6.23/sql/signal_handler.cc:230
#3 <signal handler called>
#4 0x00007fc0b2da95d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007fc0b2daacc8 in __GI_abort () at abort.c:90
#6 0x00007fc0b2da2546 in __assert_fail_base (fmt=0x7fc0b2ef2128 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0xf8da7d "0", file=file@entry=0xf8db48 "/bzr/mysql-5.6.23/sql/item_row.cc", line=line@entry=87, function=function@entry=0xf8dca0 <Item_row::illegal_method_call(char const*)::__PRETTY_FUNCTION__> "void Item_row::illegal_method_call(const char*)") at assert.c:92
#7 0x00007fc0b2da25f2 in __GI___assert_fail (assertion=0xf8da7d "0", file=0xf8db48 "/bzr/mysql-5.6.23/sql/item_row.cc", line=87, function=0xf8dca0 <Item_row::illegal_method_call(char const*)::__PRETTY_FUNCTION__> "void Item_row::illegal_method_call(const char*)") at assert.c:101
#8 0x000000000092b70b in Item_row::illegal_method_call (this=0x7fc001c1f3c0, method=0xf8dae5 "val_str") at /bzr/mysql-5.6.23/sql/item_row.cc:87
#9 0x000000000092c333 in Item_row::val_str (this=0x7fc001c1f3c0) at /bzr/mysql-5.6.23/sql/item_row.h:58
#10 0x0000000000683b80 in Item_func_like::fix_fields (this=0x7fc001c1f480, thd=0x7fc00bfef000, ref=0x7fc001c1f650) at /bzr/mysql-5.6.23/sql/item_cmpfunc.cc:5336
#11 0x00000000007720a0 in setup_fields (thd=0x7fc00bfef000, ref_pointer_array=..., fields=..., mark_used_columns=MARK_COLUMNS_READ, sum_func_list=0x7fc001c1f990, allow_sum_func=true) at /bzr/mysql-5.6.23/sql/sql_base.cc:8325
#12 0x00000000007fabb0 in JOIN::prepare (this=0x7fc001c1f748, tables_init=0x0, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, group_init=0x0, having_init=0x0, select_lex_arg=0x7fc00bff1878, unit_arg=0x7fc00bff1230) at /bzr/mysql-5.6.23/sql/sql_resolver.cc:168
#13 0x0000000000802677 in mysql_prepare_select (thd=0x7fc00bfef000, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, select_options=2147748608, result=0x7fc001c1f720, unit=0x7fc00bff1230, select_lex=0x7fc00bff1878, free_join=0x7fc0b4594c37) at /bzr/mysql-5.6.23/sql/sql_select.cc:1054
#14 0x0000000000802951 in mysql_select (thd=0x7fc00bfef000, tables=0x0, wild_num=0, fields=..., conds=0x0, order=0x7fc00bff1a40, group=0x7fc00bff1978, having=0x0, select_options=2147748608, result=0x7fc001c1f720, unit=0x7fc00bff1230, select_lex=0x7fc00bff1878) at /bzr/mysql-5.6.23/sql/sql_select.cc:1177
#15 0x0000000000800b2b in handle_select (thd=0x7fc00bfef000, result=0x7fc001c1f720, setup_tables_done_option=0) at /bzr/mysql-5.6.23/sql/sql_select.cc:110
#16 0x00000000007da980 in execute_sqlcom_select (thd=0x7fc00bfef000, all_tables=0x0) at /bzr/mysql-5.6.23/sql/sql_parse.cc:5103
#17 0x00000000007d3730 in mysql_execute_command (thd=0x7fc00bfef000) at /bzr/mysql-5.6.23/sql/sql_parse.cc:2649
#18 0x00000000007dd54a in mysql_parse (thd=0x7fc00bfef000, rawbuf=0x7fc001c1f010 "SELECT('a%b' LIKE 'ax%b' ESCAPE (0,0))", length=38, parser_state=0x7fc0b4595e70) at /bzr/mysql-5.6.23/sql/sql_parse.cc:6357
#19 0x00000000007d06bc in dispatch_command (command=COM_QUERY, thd=0x7fc00bfef000, packet=0x7fc00060a001 "SELECT('a%b' LIKE 'ax%b' ESCAPE (0,0))", packet_length=38) at /bzr/mysql-5.6.23/sql/sql_parse.cc:1332
#20 0x00000000007cf7ab in do_command (thd=0x7fc00bfef000) at /bzr/mysql-5.6.23/sql/sql_parse.cc:1034
#21 0x0000000000797b3d in do_handle_one_connection (thd_arg=0x7fc00bfef000) at /bzr/mysql-5.6.23/sql/sql_connect.cc:982
#22 0x0000000000797626 in handle_one_connection (arg=0x7fc00bfef000) at /bzr/mysql-5.6.23/sql/sql_connect.cc:898
#23 0x0000000000ae6600 in pfs_spawn_thread (arg=0x7fc0b23fbb00) at /bzr/mysql-5.6.23/storage/perfschema/pfs.cc:1860
#24 0x00007fc0b3f98df5 in start_thread (arg=0x7fc0b4597700) at pthread_create.c:308
#25 0x00007fc0b2e6a1ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113
How to repeat:
SELECT('a%b' LIKE 'ax%b' ESCAPE (0,0));
Description: mysqld: /sdc/percona-server/sql/item_row.cc:87: void Item_row::illegal_method_call(const char*): Assertion `0' failed. +bt #0 0x00007fc0b3f9d771 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61 #1 0x0000000000a9804e in my_write_core (sig=6) at /bzr/mysql-5.6.23/mysys/stacktrace.c:422 #2 0x00000000007277f0 in handle_fatal_signal (sig=6) at /bzr/mysql-5.6.23/sql/signal_handler.cc:230 #3 <signal handler called> #4 0x00007fc0b2da95d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 #5 0x00007fc0b2daacc8 in __GI_abort () at abort.c:90 #6 0x00007fc0b2da2546 in __assert_fail_base (fmt=0x7fc0b2ef2128 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0xf8da7d "0", file=file@entry=0xf8db48 "/bzr/mysql-5.6.23/sql/item_row.cc", line=line@entry=87, function=function@entry=0xf8dca0 <Item_row::illegal_method_call(char const*)::__PRETTY_FUNCTION__> "void Item_row::illegal_method_call(const char*)") at assert.c:92 #7 0x00007fc0b2da25f2 in __GI___assert_fail (assertion=0xf8da7d "0", file=0xf8db48 "/bzr/mysql-5.6.23/sql/item_row.cc", line=87, function=0xf8dca0 <Item_row::illegal_method_call(char const*)::__PRETTY_FUNCTION__> "void Item_row::illegal_method_call(const char*)") at assert.c:101 #8 0x000000000092b70b in Item_row::illegal_method_call (this=0x7fc001c1f3c0, method=0xf8dae5 "val_str") at /bzr/mysql-5.6.23/sql/item_row.cc:87 #9 0x000000000092c333 in Item_row::val_str (this=0x7fc001c1f3c0) at /bzr/mysql-5.6.23/sql/item_row.h:58 #10 0x0000000000683b80 in Item_func_like::fix_fields (this=0x7fc001c1f480, thd=0x7fc00bfef000, ref=0x7fc001c1f650) at /bzr/mysql-5.6.23/sql/item_cmpfunc.cc:5336 #11 0x00000000007720a0 in setup_fields (thd=0x7fc00bfef000, ref_pointer_array=..., fields=..., mark_used_columns=MARK_COLUMNS_READ, sum_func_list=0x7fc001c1f990, allow_sum_func=true) at /bzr/mysql-5.6.23/sql/sql_base.cc:8325 #12 0x00000000007fabb0 in JOIN::prepare (this=0x7fc001c1f748, tables_init=0x0, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, group_init=0x0, having_init=0x0, select_lex_arg=0x7fc00bff1878, unit_arg=0x7fc00bff1230) at /bzr/mysql-5.6.23/sql/sql_resolver.cc:168 #13 0x0000000000802677 in mysql_prepare_select (thd=0x7fc00bfef000, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, select_options=2147748608, result=0x7fc001c1f720, unit=0x7fc00bff1230, select_lex=0x7fc00bff1878, free_join=0x7fc0b4594c37) at /bzr/mysql-5.6.23/sql/sql_select.cc:1054 #14 0x0000000000802951 in mysql_select (thd=0x7fc00bfef000, tables=0x0, wild_num=0, fields=..., conds=0x0, order=0x7fc00bff1a40, group=0x7fc00bff1978, having=0x0, select_options=2147748608, result=0x7fc001c1f720, unit=0x7fc00bff1230, select_lex=0x7fc00bff1878) at /bzr/mysql-5.6.23/sql/sql_select.cc:1177 #15 0x0000000000800b2b in handle_select (thd=0x7fc00bfef000, result=0x7fc001c1f720, setup_tables_done_option=0) at /bzr/mysql-5.6.23/sql/sql_select.cc:110 #16 0x00000000007da980 in execute_sqlcom_select (thd=0x7fc00bfef000, all_tables=0x0) at /bzr/mysql-5.6.23/sql/sql_parse.cc:5103 #17 0x00000000007d3730 in mysql_execute_command (thd=0x7fc00bfef000) at /bzr/mysql-5.6.23/sql/sql_parse.cc:2649 #18 0x00000000007dd54a in mysql_parse (thd=0x7fc00bfef000, rawbuf=0x7fc001c1f010 "SELECT('a%b' LIKE 'ax%b' ESCAPE (0,0))", length=38, parser_state=0x7fc0b4595e70) at /bzr/mysql-5.6.23/sql/sql_parse.cc:6357 #19 0x00000000007d06bc in dispatch_command (command=COM_QUERY, thd=0x7fc00bfef000, packet=0x7fc00060a001 "SELECT('a%b' LIKE 'ax%b' ESCAPE (0,0))", packet_length=38) at /bzr/mysql-5.6.23/sql/sql_parse.cc:1332 #20 0x00000000007cf7ab in do_command (thd=0x7fc00bfef000) at /bzr/mysql-5.6.23/sql/sql_parse.cc:1034 #21 0x0000000000797b3d in do_handle_one_connection (thd_arg=0x7fc00bfef000) at /bzr/mysql-5.6.23/sql/sql_connect.cc:982 #22 0x0000000000797626 in handle_one_connection (arg=0x7fc00bfef000) at /bzr/mysql-5.6.23/sql/sql_connect.cc:898 #23 0x0000000000ae6600 in pfs_spawn_thread (arg=0x7fc0b23fbb00) at /bzr/mysql-5.6.23/storage/perfschema/pfs.cc:1860 #24 0x00007fc0b3f98df5 in start_thread (arg=0x7fc0b4597700) at pthread_create.c:308 #25 0x00007fc0b2e6a1ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113 How to repeat: SELECT('a%b' LIKE 'ax%b' ESCAPE (0,0));