Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
-
None
Description
--source include/have_partition.inc
|
|
CREATE TABLE t1 (pk INT PRIMARY KEY, a INT); |
INSERT INTO t1 VALUES (1,10),(2,20); |
|
CREATE TABLE t2 (b INT) PARTITION BY KEY (b) PARTITIONS 2; |
INSERT INTO t2 VALUES (1),(2); |
|
DELETE t2 FROM t2 WHERE b BETWEEN 5 AND 9; |
UPDATE t2 JOIN t1 SET b = 5; |
|
# Cleanup
|
DROP TABLE t1, t2; |
10.0 a2c0376e08 |
mysqld: /data/src/10.0/sql/ha_partition.cc:7464: void ha_partition::late_extra_cache(uint): Assertion `m_extra_cache' failed.
|
180712 14:36:43 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f4152768ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x0000000000df8986 in ha_partition::late_extra_cache (this=0x7f414a87f088, partition_id=1) at /data/src/10.0/sql/ha_partition.cc:7464
|
#9 0x0000000000df4409 in ha_partition::rnd_next (this=0x7f414a87f088, buf=0x7f414a8284a0 "\375\005") at /data/src/10.0/sql/ha_partition.cc:4976
|
#10 0x00000000008404ec in handler::ha_rnd_next (this=0x7f414a87f088, buf=0x7f414a8284a0 "\375\005") at /data/src/10.0/sql/handler.cc:2625
|
#11 0x0000000000971827 in rr_sequential (info=0x7f414a94b598) at /data/src/10.0/sql/records.cc:470
|
#12 0x00000000006adae4 in sub_select (join=0x7f414a8fb6d0, join_tab=0x7f414a94b4f0, end_of_records=false) at /data/src/10.0/sql/sql_select.cc:18003
|
#13 0x00000000006ad2a4 in do_select (join=0x7f414a8fb6d0, fields=0x7f41547eebd0, table=0x0, procedure=0x0) at /data/src/10.0/sql/sql_select.cc:17646
|
#14 0x000000000068a01d in JOIN::exec_inner (this=0x7f414a8fb6d0) at /data/src/10.0/sql/sql_select.cc:3116
|
#15 0x00000000006874da in JOIN::exec (this=0x7f414a8fb6d0) at /data/src/10.0/sql/sql_select.cc:2402
|
#16 0x000000000068a87c in mysql_select (thd=0x7f414c6a8070, rref_pointer_array=0x7f414c6ac3a0, tables=0x7f414a8fa170, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=1342177408, result=0x7f414a8fb610, unit=0x7f414c6aba08, select_lex=0x7f414c6ac0f8) at /data/src/10.0/sql/sql_select.cc:3341
|
#17 0x000000000071b2c3 in mysql_multi_update (thd=0x7f414c6a8070, table_list=0x7f414a8fa170, fields=0x7f414c6ac210, values=0x7f414c6ac6c8, conds=0x0, options=0, handle_duplicates=DUP_ERROR, ignore=false, unit=0x7f414c6aba08, select_lex=0x7f414c6ac0f8, result=0x7f41547ef2e0) at /data/src/10.0/sql/sql_update.cc:1599
|
#18 0x000000000064f416 in mysql_execute_command (thd=0x7f414c6a8070) at /data/src/10.0/sql/sql_parse.cc:3378
|
#19 0x0000000000657dd6 in mysql_parse (thd=0x7f414c6a8070, rawbuf=0x7f414a8fa088 "UPDATE t2 JOIN t1 SET b = 5", length=27, parser_state=0x7f41547ef640) at /data/src/10.0/sql/sql_parse.cc:6634
|
#20 0x000000000064a6f6 in dispatch_command (command=COM_QUERY, thd=0x7f414c6a8070, packet=0x7f414dbe5071 "UPDATE t2 JOIN t1 SET b = 5", packet_length=27) at /data/src/10.0/sql/sql_parse.cc:1297
|
#21 0x00000000006499f6 in do_command (thd=0x7f414c6a8070) at /data/src/10.0/sql/sql_parse.cc:1000
|
#22 0x000000000076a872 in do_handle_one_connection (thd_arg=0x7f414c6a8070) at /data/src/10.0/sql/sql_connect.cc:1377
|
#23 0x000000000076a5e4 in handle_one_connection (arg=0x7f414c6a8070) at /data/src/10.0/sql/sql_connect.cc:1292
|
#24 0x0000000000acc722 in pfs_spawn_thread (arg=0x7f414c5a25f0) at /data/src/10.0/storage/perfschema/pfs.cc:1861
|
#25 0x00007f415446c494 in start_thread (arg=0x7f41547f0700) at pthread_create.c:333
|
#26 0x00007f415282593f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
No visible effect on non-debug builds.