Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
10.1(EOL)
Description
Setting to Minor because it's a debug assertion which only seems to affect 10.1
--source include/have_innodb.inc
|
|
CREATE TABLE t1 (a INT, b CHAR(8), c INT, UNIQUE(c,a), KEY (b)) ENGINE=InnoDB; |
INSERT INTO t1 VALUES (1,'foo',NULL), (2,'bar',2); |
REPLACE INTO t1 SELECT * FROM t1; |
--error ER_DUP_ENTRY
|
UPDATE t1 SET c = 0 WHERE b > 'baz'; |
|
# Cleanup
|
DROP TABLE t1; |
10.1 57ec42bc |
2020-07-22 15:02:02 7f5157ff6700 InnoDB: Warning: using a partial-field key prefix in search.
|
InnoDB: index `b` of table `test`.`t1`. Last data field length 9 bytes,
|
InnoDB: key ptr now exceeds key end by 3 bytes.
|
InnoDB: Key value in the MySQL format:
|
len 6; hex 000000000202; asc ;
|
2020-07-22 15:02:02 7f5157ff6700 InnoDB: Assertion failure in thread 139987345434368 in file row0sel.cc line 2500
|
InnoDB: Failing assertion: 0
|
|
#5 0x00007f51563df42a in __GI_abort () at abort.c:89
|
#6 0x00007f514f828e8f in row_sel_convert_mysql_key_to_innobase (tuple=0x7f513fd353f8, buf=0x7f513fd353e8 "\200", buf_len=8, index=0x7f513fde8578, key_ptr=0x7f513fc9d251 "\245\245\245\245\245\245\245", '\217' <repeats 193 times>..., key_len=6, trx=0x7f513fc64478) at /data/src/10.1/storage/innobase/row/row0sel.cc:2500
|
#7 0x00007f514f6f4b82 in ha_innodb::index_read (this=0x7f513fcac888, buf=0x7f513fc9cfa0 "\371\001", key_ptr=0x7f513fc9d248 "", key_len=6, find_flag=HA_READ_KEY_EXACT) at /data/src/10.1/storage/innobase/handler/ha_innodb.cc:9372
|
#8 0x00007f514f6f5fc5 in ha_innodb::rnd_pos (this=0x7f513fcac888, buf=0x7f513fc9cfa0 "\371\001", pos=0x7f513fc9d248 "") at /data/src/10.1/storage/innobase/handler/ha_innodb.cc:9960
|
#9 0x000055c90391522f in handler::ha_rnd_pos (this=0x7f513fcac888, buf=0x7f513fc9cfa0 "\371\001", pos=0x7f513fc9d248 "") at /data/src/10.1/sql/handler.cc:2671
|
#10 0x000055c9037af9d1 in prepare_record_for_error_message (error=121, table=0x7f513fc7dc70) at /data/src/10.1/sql/sql_update.cc:215
|
#11 0x000055c9037b1908 in mysql_update (thd=0x7f514cb61070, table_list=0x7f513fcf6180, fields=..., values=..., conds=0x7f513fcf6ae8, order_num=0, order=0x0, limit=18446744073709551614, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f5157ff4cf0, updated_return=0x7f5157ff4d80) at /data/src/10.1/sql/sql_update.cc:856
|
#12 0x000055c9036d262a in mysql_execute_command (thd=0x7f514cb61070) at /data/src/10.1/sql/sql_parse.cc:3506
|
#13 0x000055c9036ddde0 in mysql_parse (thd=0x7f514cb61070, rawbuf=0x7f513fcf6088 "UPDATE t1 SET c = 0 WHERE b > 'baz'", length=35, parser_state=0x7f5157ff55f0) at /data/src/10.1/sql/sql_parse.cc:7200
|
#14 0x000055c9036ccfb7 in dispatch_command (command=COM_QUERY, thd=0x7f514cb61070, packet=0x7f514ca9b071 "UPDATE t1 SET c = 0 WHERE b > 'baz'", packet_length=35) at /data/src/10.1/sql/sql_parse.cc:1491
|
#15 0x000055c9036cbe9c in do_command (thd=0x7f514cb61070) at /data/src/10.1/sql/sql_parse.cc:1123
|
#16 0x000055c903809d3b in do_handle_one_connection (thd_arg=0x7f514cb61070) at /data/src/10.1/sql/sql_connect.cc:1331
|
#17 0x000055c903809a6c in handle_one_connection (arg=0x7f514cb61070) at /data/src/10.1/sql/sql_connect.cc:1242
|
#18 0x000055c903c27ed4 in pfs_spawn_thread (arg=0x7f5150fae3f0) at /data/src/10.1/storage/perfschema/pfs.cc:1868
|
#19 0x00007f5157c854a4 in start_thread (arg=0x7f5157ff6700) at pthread_create.c:456
|
#20 0x00007f5156493d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
Couldn't reproduce on 10.2+, although there are similar open bugs affecting these versions.
Attachments
Issue Links
- relates to
-
MDEV-21245 Assertion `0' failed in row_sel_convert_mysql_key_to_innobase upon UPDATE using a partial-field key prefix in search
- Closed
-
MDEV-21798 Assertion `0' failed in row_sel_convert_mysql_key_to_innobase upon SELECT using index
- Closed