Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
None
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
|
Attachments
Issue Links
- relates to
-
MDEV-5800 indexes on virtual (not materialized) columns
- Closed