Item_row::illegal_method_call | void Item_row::illegal_method_call(const char*): Assertion `0' failed.
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.6 |
Triaged
|
High
|
Unassigned | |||
5.7 |
Fix Released
|
High
|
Unassigned |
Bug Description
This bug was seen 320 times in the first iteration of PS 5.7 debug.
Testcase:
DROP DATABASE test;CREATE DATABASE test;USE test;
SELECT('a%b' LIKE 'ax%b' ESCAPE (0,0));
Results on various versions:
$ ~/percona-
======= PS-5.7-OPT (5.7)
ERROR 1241 (21000) at line 2: Operand should contain 1 column(s)
======= PS-5.7-DBG (5.7)
ERROR 2013 (HY000) at line 2: Lost connection to MySQL server during query
======= MS-5.7-OPT (5.7.8)
ERROR 1241 (21000) at line 2: Operand should contain 1 column(s)
======= MS-5.7-DBG (5.7.8)
ERROR 1241 (21000) at line 2: Operand should contain 1 column(s)
======= PS-5.6-DBG (5.6.25)
ERROR 2013 (HY000) at line 2: Lost connection to MySQL server during query
======= MS-5.6-DBG (5.6.23)
ERROR 2013 (HY000) at line 2: Lost connection to MySQL server during query
From PS-5.7-DBG (alpha):
+bt
#0 0x00007ffdd56fa771 in __pthread_kill (threadid=
#1 0x0000000000ab0686 in my_write_core (sig=6) at /git/PS-
#2 0x000000000072dfdf in handle_fatal_signal (sig=6) at /git/PS-
#3 <signal handler called>
#4 0x00007ffdd42fe5d7 in __GI_raise (sig=sig@entry=6) at ../nptl/
#5 0x00007ffdd42ffcc8 in __GI_abort () at abort.c:90
#6 0x00007ffdd42f7546 in __assert_fail_base (fmt=0x7ffdd4447128 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=
#7 0x00007ffdd42f75f2 in __GI___assert_fail (assertion=0xfc823b "0", file=0xfc8308 "/git/PS-
#8 0x000000000094347f in Item_row:
#9 0x0000000000944095 in Item_row::val_str (this=0x7ffd220
#10 0x000000000068a080 in Item_func_
#11 0x0000000000779418 in setup_fields (thd=0x7ffd296a
#12 0x00000000008094e4 in JOIN::prepare (this=0x7ffd220
#13 0x0000000000810ec1 in mysql_prepare_
#14 0x000000000081118f in mysql_select (thd=0x7ffd296a
#15 0x000000000080f3e2 in handle_select (thd=0x7ffd296a
#16 0x00000000007e79e2 in execute_
#17 0x00000000007dff82 in mysql_execute_
#18 0x00000000007ea6e5 in mysql_parse (thd=0x7ffd296a
#19 0x00000000007dc67d in dispatch_command (command=COM_QUERY, thd=0x7ffd296af000, packet=
#20 0x00000000007db5af in do_command (thd=0x7ffd296a
#21 0x00000000007a3b41 in do_handle_
#22 0x00000000007a3649 in handle_
#23 0x0000000000b00f8c in pfs_spawn_thread (arg=0x7ffdd3bf
#24 0x00007ffdd56f5df5 in start_thread (arg=0x7ffdd5cf
#25 0x00007ffdd43bf1ad in clone () at ../sysdeps/
description: | updated |
tags: | removed: qablock |
tags: | added: qa57 qablock |
tags: | added: upstream |
It's really an upstream bug that is apparently fixed in (later version of) MS 5.7 /bugs.mysql. com/bug. php?id= 78330 /bugs.mysql. com/bug. php?id= 57552
https:/
https:/