[MDEV-11518] Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed in Field_long::val_int() Created: 2016-12-09  Updated: 2017-01-02  Resolved: 2016-12-13

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

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-5800 indexes on virtual (not materialized)... Closed

 Description    

CREATE TABLE t1 (pk INT, i INT, v INT AS (i*2) VIRTUAL, PRIMARY KEY (pk), KEY (v)) ENGINE=MyISAM;
 
INSERT INTO t1 (pk,i) VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8);
 
 
 
CREATE TABLE t2 (a INT, b INT) ENGINE=MyISAM;
 
INSERT INTO t2 VALUES (1,2),(2,4);
 
 
 
SELECT * FROM t1 INNER JOIN t2 ON ( t2.b = t1.v OR t2.a = t1.pk );

bb-10.2-vcols b584734d242e7c56647889e5e9c97e4a11ab5e52

 
#7  0x00007f9ac4583312 in __GI___assert_fail (assertion=0x7f9ac7ba2ac0 "!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))", file=0x7f9ac7ba2858 "/data/src/bb-10.2-vcols/sql/field.cc", line=4193, function=0x7f9ac7ba5680 <Field_long::val_int()::__PRETTY_FUNCTION__> "virtual longlong Field_long::val_int()") at assert.c:101
 
#8  0x00007f9ac729f006 in Field_long::val_int (this=0x7f9abb827698) at /data/src/bb-10.2-vcols/sql/field.cc:4193
 
#9  0x00007f9ac72e0b8a in Item_field::val_int (this=0x7f9abb827c18) at /data/src/bb-10.2-vcols/sql/item.cc:2749
 
#10 0x00007f9ac733ee60 in Item_func_mul::int_op (this=0x7f9abba0ac88) at /data/src/bb-10.2-vcols/sql/item_func.cc:1530
 
#11 0x00007f9ac733cb0a in Item_func_hybrid_field_type::val_int (this=0x7f9abba0ac88) at /data/src/bb-10.2-vcols/sql/item_func.cc:937
 
#12 0x00007f9ac72ea983 in Item::save_in_field (this=0x7f9abba0ac88, field=0x7f9abb827768, no_conversions=false) at /data/src/bb-10.2-vcols/sql/item.cc:6310
 
#13 0x00007f9ac7167552 in TABLE::update_virtual_fields (this=0x7f9abb8d7870, update_mode=VCOL_UPDATE_FOR_READ) at /data/src/bb-10.2-vcols/sql/table.cc:7354
 
#14 0x00007f9ac72cbea5 in handler::ha_index_read_map (this=0x7f9abb9e4960, buf=0x7f9abb827588 "\371\002", key=0x7f9abb9e4228 "\002", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at /data/src/bb-10.2-vcols/sql/handler.cc:2634
 
#15 0x00007f9ac72d26f4 in handler::read_range_first (this=0x7f9abb9e4960, start_key=0x7f9abb9e4a48, end_key=0x7f9abb9e4a68, eq_range_arg=true, sorted=true) at /data/src/bb-10.2-vcols/sql/handler.cc:5318
 
#16 0x00007f9ac71ec304 in handler::multi_range_read_next (this=0x7f9abb9e4960, range_info=0x7f9ac8195798) at /data/src/bb-10.2-vcols/sql/multi_range_read.cc:290
 
#17 0x00007f9ac71ec4de in Mrr_simple_index_reader::get_next (this=0x7f9abb9e4ef0, range_info=0x7f9ac8195798) at /data/src/bb-10.2-vcols/sql/multi_range_read.cc:322
 
#18 0x00007f9ac71ef028 in DsMrr_impl::dsmrr_next (this=0x7f9abb9e4db0, range_info=0x7f9ac8195798) at /data/src/bb-10.2-vcols/sql/multi_range_read.cc:1408
 
#19 0x00007f9ac79a64d6 in ha_myisam::multi_range_read_next (this=0x7f9abb9e4960, range_info=0x7f9ac8195798) at /data/src/bb-10.2-vcols/storage/myisam/ha_myisam.cc:2355
 
#20 0x00007f9ac741f980 in QUICK_RANGE_SELECT::get_next (this=0x7f9abb901140) at /data/src/bb-10.2-vcols/sql/opt_range.cc:11188
 
#21 0x00007f9ac7409c39 in QUICK_ROR_UNION_SELECT::reset (this=0x7f9abb852300) at /data/src/bb-10.2-vcols/sql/opt_range.cc:1806
 
#22 0x00007f9ac70cea62 in join_init_read_record (tab=0x7f9abb868de8) at /data/src/bb-10.2-vcols/sql/sql_select.cc:19261
 
#23 0x00007f9ac70ce7a6 in join_init_quick_read_record (tab=0x7f9abb868de8) at /data/src/bb-10.2-vcols/sql/sql_select.cc:19209
 
#24 0x00007f9ac70cca0d in sub_select (join=0x7f9abb865f48, join_tab=0x7f9abb868de8, end_of_records=false) at /data/src/bb-10.2-vcols/sql/sql_select.cc:18350
 
#25 0x00007f9ac70cd138 in evaluate_join_record (join=0x7f9abb865f48, join_tab=0x7f9abb868a38, error=0) at /data/src/bb-10.2-vcols/sql/sql_select.cc:18575
 
#26 0x00007f9ac70ccc03 in sub_select (join=0x7f9abb865f48, join_tab=0x7f9abb868a38, end_of_records=false) at /data/src/bb-10.2-vcols/sql/sql_select.cc:18392
 
#27 0x00007f9ac70cc02d in do_select (join=0x7f9abb865f48, procedure=0x0) at /data/src/bb-10.2-vcols/sql/sql_select.cc:17897
 
#28 0x00007f9ac70a6ffa in JOIN::exec_inner (this=0x7f9abb865f48) at /data/src/bb-10.2-vcols/sql/sql_select.cc:3388
 
#29 0x00007f9ac70a6544 in JOIN::exec (this=0x7f9abb865f48) at /data/src/bb-10.2-vcols/sql/sql_select.cc:3199
 
#30 0x00007f9ac70a769b in mysql_select (thd=0x7f9abb816070, tables=0x7f9abb8642c0, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f9abb865f28, unit=0x7f9abb819b48, select_lex=0x7f9abb81a278) at /data/src/bb-10.2-vcols/sql/sql_select.cc:3584
 
#31 0x00007f9ac709c753 in handle_select (thd=0x7f9abb816070, lex=0x7f9abb819a80, result=0x7f9abb865f28, setup_tables_done_option=0) at /data/src/bb-10.2-vcols/sql/sql_select.cc:373
 
#32 0x00007f9ac7069085 in execute_sqlcom_select (thd=0x7f9abb816070, all_tables=0x7f9abb8642c0) at /data/src/bb-10.2-vcols/sql/sql_parse.cc:6347
 
#33 0x00007f9ac705eb40 in mysql_execute_command (thd=0x7f9abb816070) at /data/src/bb-10.2-vcols/sql/sql_parse.cc:3370
 
#34 0x00007f9ac706ca44 in mysql_parse (thd=0x7f9abb816070, rawbuf=0x7f9abb864088 "SELECT * FROM t1 INNER JOIN t2 ON ( t2.b = t1.v OR t2.a = t1.pk )", length=65, parser_state=0x7f9ac8196dd0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.2-vcols/sql/sql_parse.cc:7790
 
#35 0x00007f9ac705a794 in dispatch_command (command=COM_QUERY, thd=0x7f9abb816070, packet=0x7f9abb858071 "", packet_length=65, is_com_multi=false, is_next_command=false) at /data/src/bb-10.2-vcols/sql/sql_parse.cc:1799
 
#36 0x00007f9ac705916e in do_command (thd=0x7f9abb816070) at /data/src/bb-10.2-vcols/sql/sql_parse.cc:1359
 
#37 0x00007f9ac71a077a in do_handle_one_connection (connect=0x7f9ac3c74950) at /data/src/bb-10.2-vcols/sql/sql_connect.cc:1354
 
#38 0x00007f9ac71a0507 in handle_one_connection (arg=0x7f9ac3c74950) at /data/src/bb-10.2-vcols/sql/sql_connect.cc:1260
 
#39 0x00007f9ac74dc70c in pfs_spawn_thread (arg=0x7f9ac3c0f9f0) at /data/src/bb-10.2-vcols/storage/perfschema/pfs.cc:1862
 
#40 0x00007f9ac66900a4 in start_thread (arg=0x7f9ac8198300) at pthread_create.c:309
 
#41 0x00007f9ac463d87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111



 Comments   
Comment by Elena Stepanova [ 2017-01-02 ]

Didn't re-appear on bb-10.2-monty as of 349d69e2e

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