[MDEV-11729] [bb-10.2-monty] Server crashes in in Field::register_field_in_read_map Created: 2017-01-05  Updated: 2017-01-06  Resolved: 2017-01-06

Status: Closed
Project: MariaDB Server
Component/s: Virtual Columns
Affects Version/s: N/A
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: None


 Description   

CREATE TABLE t1 ( 
 pk BIGINT,
 c CHAR(64) NOT NULL DEFAULT '',
 vc CHAR(64) AS (c) VIRTUAL,
 PRIMARY KEY(pk),
 INDEX(vc(32))
);
DELETE FROM t1 WHERE vc IS NULL ORDER BY pk;

bb-10.2-monty e127bd70e55

#3  <signal handler called>
#4  0x00007f8c27b7fd9e in Field::register_field_in_read_map (this=0x7f8c1c0281f8) at /data/src/bb-10.2-monty/sql/field.cc:10874
#5  0x00007f8c27ced148 in QUICK_RANGE_SELECT::add_used_key_part_to_set (this=0x7f8c1c101140) at /data/src/bb-10.2-monty/sql/opt_range.cc:11861
#6  0x00007f8c27b8b366 in find_all_keys (thd=0x7f8c1c016070, param=0x7f8c28a545a0, select=0x7f8c1c064d30, fs_info=0x7f8c1c29d200, buffpek_pointers=0x7f8c28a547b0, tempfile=0x7f8c28a54630, pq=0x0, found_rows=0x7f8c1c29d3f0) at /data/src/bb-10.2-monty/sql/filesort.cc:764
#7  0x00007f8c27b89b97 in filesort (thd=0x7f8c1c016070, table=0x7f8c1c0d7870, filesort=0x7f8c28a54a50, tracker=0x7f8c1c065198, join=0x0, first_table_bit=0) at /data/src/bb-10.2-monty/sql/filesort.cc:284
#8  0x00007f8c27d24aff in mysql_delete (thd=0x7f8c1c016070, table_list=0x7f8c1c064190, conds=0x7f8c1c0648a0, order_list=0x7f8c1c01a4a8, limit=18446744073709551615, options=0, result=0x0) at /data/src/bb-10.2-monty/sql/sql_delete.cc:503
#9  0x00007f8c2792bf63 in mysql_execute_command (thd=0x7f8c1c016070) at /data/src/bb-10.2-monty/sql/sql_parse.cc:4566
#10 0x00007f8c27936888 in mysql_parse (thd=0x7f8c1c016070, rawbuf=0x7f8c1c064088 "DELETE FROM t1 WHERE vc IS NULL ORDER BY pk", length=43, parser_state=0x7f8c28a55dd0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.2-monty/sql/sql_parse.cc:7839
#11 0x00007f8c2792444e in dispatch_command (command=COM_QUERY, thd=0x7f8c1c016070, packet=0x7f8c1c058071 "DELETE FROM t1 WHERE vc IS NULL ORDER BY pk", packet_length=43, is_com_multi=false, is_next_command=false) at /data/src/bb-10.2-monty/sql/sql_parse.cc:1799
#12 0x00007f8c27922e28 in do_command (thd=0x7f8c1c016070) at /data/src/bb-10.2-monty/sql/sql_parse.cc:1359
#13 0x00007f8c27a6ac46 in do_handle_one_connection (connect=0x7f8c244744f0) at /data/src/bb-10.2-monty/sql/sql_connect.cc:1354
#14 0x00007f8c27a6a9d3 in handle_one_connection (arg=0x7f8c244744f0) at /data/src/bb-10.2-monty/sql/sql_connect.cc:1260
#15 0x00007f8c27da9582 in pfs_spawn_thread (arg=0x7f8c2440f9f0) at /data/src/bb-10.2-monty/storage/perfschema/pfs.cc:1862
#16 0x00007f8c26f570a4 in start_thread (arg=0x7f8c28a57300) at pthread_create.c:309
#17 0x00007f8c24f0487d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

Not reproducible on current 10.2 (as of 348ccb6f03).



 Comments   
Comment by Michael Widenius [ 2017-01-06 ]

Fixed by using key_part->field_index instead of key_part->field as the later is different for partial keys.

Comment by Michael Widenius [ 2017-01-06 ]

Fixed and pushed

Generated at Thu Feb 08 07:52:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.