[MDEV-11598] Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed in Field_double::val_real() - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2(EOL)
Fix Version/s: 10.2.4
Component/s: Virtual Columns
Labels:
None

Description

CREATE TABLE IF NOT EXISTS X (

    f2 DOUBLE NOT NULL DEFAULT '0',

    f3 DOUBLE NOT NULL DEFAULT '0',

    f4 DOUBLE,

    f5 DOUBLE DEFAULT '0',

    v4 DOUBLE AS (IF(f4,f3,f2)) VIRTUAL,

    KEY (f5),

    KEY (v4)

);

INSERT INTO X (f2,f3,f4,f5) VALUES (5,4,1,0),(5,7,NULL,0);

INSERT INTO X (f2,f3,f4,f5) SELECT f2, f3, f5, f3 FROM X;

INSERT INTO X (f2,f3,f4,f5) VALUES (5,0,NULL,1);

INSERT INTO X (f2,f3,f4,f5) SELECT f2, f5, f5, f3 FROM X;

DELETE FROM X WHERE f5 = 1 OR v4 = 4 ORDER BY f5,v4 LIMIT 9;

10.2 c35b8c46b404d035e54a23d667da5dff6502fc2e
mysqld: /data/src/10.2/sql/field.cc:4771: virtual double Field_double::val_real(): Assertion `!table \|\| (!table->read_set \|\| bitmap_is_set(table->read_set, field_index))' failed.
161218 18:48:31 [ERROR] mysqld got signal 6 ;

#7 0x00007fc8cc9e9312 in __GI___assert_fail (assertion=0x7fc8cf5726c0 "!table \|\| (!table->read_set \|\| bitmap_is_set(table->read_set, field_index))", file=0x7fc8cf571e67 "/data/src/10.2/sql/field.cc", line=4771, function=0x7fc8cf575ae0 <Field_double::val_real()::__PRETTY_FUNCTION__> "virtual double Field_double::val_real()") at assert.c:101
#8 0x00007fc8ced49bda in Field_double::val_real (this=<optimized out>) at /data/src/10.2/sql/field.cc:4771
#9 0x00007fc8ced7ba7c in Item_field::val_real (this=<optimized out>) at /data/src/10.2/sql/item.cc:2740
#10 0x00007fc8ced9d027 in Item_func_if::real_op (this=0x7fc8c3a0af70) at /data/src/10.2/sql/item_cmpfunc.cc:2425
#11 0x00007fc8cedd337a in Item_func_hybrid_field_type::val_real (this=0x7fc8c3a0af70) at /data/src/10.2/sql/item_func.cc:902
#12 0x00007fc8ced81b8e in Item::save_in_field (this=0x7fc8c3a0af70, field=0x7fc8c3827b58, no_conversions=<optimized out>) at /data/src/10.2/sql/item.cc:6293
#13 0x00007fc8cec554be in TABLE::update_virtual_fields (this=0x7fc8c38d5870, update_mode=update_mode@entry=VCOL_UPDATE_FOR_READ) at /data/src/10.2/sql/table.cc:7354
#14 0x00007fc8ced6e78c in handler::ha_index_read_map (this=this@entry=0x7fc8c39e0298, buf=0x7fc8c3827588 "\363", '\245' <repeats 24 times>, key=0x7fc8c39e0138 "", keypart_map=1, find_flag=<optimized out>) at /data/src/10.2/sql/handler.cc:2634
#15 0x00007fc8ced73ddc in handler::read_range_first (this=0x7fc8c39e0298, start_key=0x7fc8c39e0380, end_key=0x7fc8c39e03a0, eq_range_arg=<optimized out>, sorted=<optimized out>) at /data/src/10.2/sql/handler.cc:5318
#16 0x00007fc8cecbdd5e in handler::multi_range_read_next (this=0x7fc8c39e0298, range_info=range_info@entry=0x7fc8cfb8eb88) at /data/src/10.2/sql/multi_range_read.cc:290
#17 0x00007fc8cecbde35 in Mrr_simple_index_reader::get_next (this=0x7fc8c39e0828, range_info=0x7fc8cfb8eb88) at /data/src/10.2/sql/multi_range_read.cc:322
#18 0x00007fc8cecbf842 in DsMrr_impl::dsmrr_next (this=0x7fc8c39e06e8, range_info=0x7fc8cfb8eb88) at /data/src/10.2/sql/multi_range_read.cc:1408
#19 0x00007fc8cf39d73e in ha_myisam::multi_range_read_next (this=<optimized out>, range_info=<optimized out>) at /data/src/10.2/storage/myisam/ha_myisam.cc:2355
#20 0x00007fc8cee809b9 in QUICK_RANGE_SELECT::get_next (this=0x7fc8c38ff140) at /data/src/10.2/sql/opt_range.cc:11189
#21 0x00007fc8cee852a8 in QUICK_ROR_UNION_SELECT::reset (this=0x7fc8c3852300) at /data/src/10.2/sql/opt_range.cc:1807
#22 0x00007fc8ced66dc5 in find_all_keys (found_rows=0x7fc8c3a9d3f0, pq=0x0, tempfile=0x7fc8cfb8ef30, buffpek_pointers=0x7fc8cfb8f0b0, fs_info=0x7fc8c3a9d200, select=0x7fc8c38656b8, param=0x7fc8cfb8ee90, thd=0x7fc8c3816070) at /data/src/10.2/sql/filesort.cc:776
#23 filesort (thd=thd@entry=0x7fc8c3816070, table=table@entry=0x7fc8c38d5870, filesort=filesort@entry=0x7fc8cfb8f790, tracker=0x7fc8c3865b20, join=join@entry=0x0, first_table_bit=first_table_bit@entry=0) at /data/src/10.2/sql/filesort.cc:284
#24 0x00007fc8ceec5a4c in mysql_delete (thd=thd@entry=0x7fc8c3816070, table_list=0x7fc8c38641b0, conds=0x7fc8c3864dd0, order_list=order_list@entry=0x7fc8c381a4a8, limit=9, options=<optimized out>, result=0x0) at /data/src/10.2/sql/sql_delete.cc:503
#25 0x00007fc8ceb8935b in mysql_execute_command (thd=thd@entry=0x7fc8c3816070) at /data/src/10.2/sql/sql_parse.cc:4516
#26 0x00007fc8ceb8f2d2 in mysql_parse (thd=thd@entry=0x7fc8c3816070, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fc8cfb918e0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:7790
#27 0x00007fc8ceb9155b in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fc8c3816070, packet=packet@entry=0x7fc8c3858071 "DELETE FROM X WHERE f5 = 1 OR v4 = 4 ORDER BY f5,v4 LIMIT 9", packet_length=packet_length@entry=59, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:1799
#28 0x00007fc8ceb9408d in do_command (thd=0x7fc8c3816070) at /data/src/10.2/sql/sql_parse.cc:1359
#29 0x00007fc8cec81f4a in do_handle_one_connection (connect=connect@entry=0x7fc8cbc71410) at /data/src/10.2/sql/sql_connect.cc:1354
#30 0x00007fc8cec82133 in handle_one_connection (arg=arg@entry=0x7fc8cbc71410) at /data/src/10.2/sql/sql_connect.cc:1260
#31 0x00007fc8cef301bf in pfs_spawn_thread (arg=0x7fc8cbc15df0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
#32 0x00007fc8ce2830a4 in start_thread (arg=0x7fc8cfb93300) at pthread_create.c:309
#33 0x00007fc8ccaa387d 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

Activity

Ascending order - Click to sort in descending order

Elena Stepanova added a comment - 2017-01-02 13:02

Also reproducible on bb-10.2-monty as of 349d69e2e

Elena Stepanova added a comment - 2017-01-02 13:02 Also reproducible on bb-10.2-monty as of 349d69e2e

Michael Widenius added a comment - 2017-01-04 21:34

Found and fixed 2 problems:

Filesort addon fields didn't mark virtual columns properly
multi-range-read calculated vcol bitmap but was not using it.
This caused wrong vcol field to be calculated on read, which caused the assert.

Michael Widenius added a comment - 2017-01-04 21:34 Found and fixed 2 problems: Filesort addon fields didn't mark virtual columns properly multi-range-read calculated vcol bitmap but was not using it. This caused wrong vcol field to be calculated on read, which caused the assert.

Michael Widenius added a comment - 2017-01-04 23:07

Fix pushed into bb-10.2-monty
Will be pushed soon into 10.2 (after some testing)

Michael Widenius added a comment - 2017-01-04 23:07 Fix pushed into bb-10.2-monty Will be pushed soon into 10.2 (after some testing)

Elena Stepanova added a comment - 2017-01-05 12:59

The following test case still produces the same assertion failure, only in Field_varstring::val_str:

--source include/have_innodb.inc

CREATE TABLE t1 (

 d DECIMAL(63,0) NOT NULL DEFAULT 0,

 c VARCHAR(64) NOT NULL DEFAULT '',

 vd DECIMAL(63,0) AS (d) VIRTUAL,

 vc VARCHAR(2048) AS (c) VIRTUAL,

 pk BIGINT AUTO_INCREMENT,

 PRIMARY KEY(pk)

 ) ENGINE=InnoDB;

INSERT INTO t1 (d,c) VALUES (0.5,'foo');

SELECT * FROM t1 WHERE vc != 'bar' ORDER BY vd;

bb-10.2-monty e127bd70e55
mysqld: /data/src/bb-10.2-monty/sql/field.cc:7511: virtual String* Field_varstring::val_str(String, String): Assertion `!table \|\| (!table->read_set \|\| bitmap_is_set(table->read_set, field_index))' failed.
170105 14:56:37 [ERROR] mysqld got signal 6 ;

#7 0x00007fb8cb43f312 in __GI___assert_fail (assertion=0x7fb8cea5a040 "!table \|\| (!table->read_set \|\| bitmap_is_set(table->read_set, field_index))", file=0x7fb8cea59dd8 "/data/src/bb-10.2-monty/sql/field.cc", line=7511, function=0x7fb8cea5e420 <Field_varstring::val_str(String, String)::__PRETTY_FUNCTION__> "virtual String* Field_varstring::val_str(String, String)") at assert.c:101
#8 0x00007fb8ce16a24a in Field_varstring::val_str (this=0x7fb8a5428a90, val_buffer=0x7fb8cf038d50, val_ptr=0x7fb8cf038d50) at /data/src/bb-10.2-mo#9 0x00007fb8cde5b4ef in Field::val_str (this=0x7fb8a5428a90, str=0x7fb8cf038d50) at /data/src/bb-10.2-monty/sql/field.h:833
#10 0x00007fb8ce1754ee in Field::save_in_field_str (this=0x7fb8a5428a90, to=0x7fb8a5428c48) at /data/src/bb-10.2-monty/sql/field.h:674
#11 0x00007fb8ce17671f in Field_str::save_in_field (this=0x7fb8a5428a90, to=0x7fb8a5428c48) at /data/src/bb-10.2-monty/sql/field.h:1655
#12 0x00007fb8ce1755da in Field::store_field (this=0x7fb8a5428c48, from=0x7fb8a5428a90) at /data/src/bb-10.2-monty/sql/field.h:806
#13 0x00007fb8ce17db63 in field_conv_incompatible (to=0x7fb8a5428c48, from=0x7fb8a5428a90) at /data/src/bb-10.2-monty/sql/field_conv.cc:814
#14 0x00007fb8ce17dbbf in field_conv (to=0x7fb8a5428c48, from=0x7fb8a5428a90) at /data/src/bb-10.2-monty/sql/field_conv.cc:827
#15 0x00007fb8ce1a9d6b in save_field_in_field (from=0x7fb8a5428a90, null_value=0x7fb8a561130a, to=0x7fb8a5428c48, no_conversions=false) at /data/src/bb-10.2-monty/sql/item.cc:6207
#16 0x00007fb8ce1a9f6a in Item_field::save_in_field (this=0x7fb8a5611298, to=0x7fb8a5428c48, no_conversions=false) at /data/src/bb-10.2-monty/sql/item.cc:6253
#17 0x00007fb8ce026955 in TABLE::update_virtual_fields (this=0x7fb8a54d7870, update_mode=VCOL_UPDATE_FOR_READ) at /data/src/bb-10.2-monty/sql/table.cc:7381
#18 0x00007fb8ce18b0f0 in handler::ha_rnd_next (this=0x7fb8a54b7888, buf=0x7fb8a55a5088 "\374\200") at /data/src/bb-10.2-monty/sql/handler.cc:2583
#19 0x00007fb8ce180568 in find_all_keys (thd=0x7fb8a5416070, param=0x7fb8cf039560, select=0x7fb8a54674d0, fs_info=0x7fb8a569e400, buffpek_pointers=0x7fb8cf039770, tempfile=0x7fb8cf0395f0, pq=0x0, found_rows=0x7fb8a569e5f0) at /data/src/bb-10.2-monty/sql/filesort.cc:793
#20 0x00007fb8ce17eb97 in filesort (thd=0x7fb8a5416070, table=0x7fb8a54d7870, filesort=0x7fb8a54676b0, tracker=0x7fb8a5467e88, join=0x7fb8a5464df0, first_table_bit=1) at /data/src/bb-10.2-monty/sql/filesort.cc:284
#21 0x00007fb8cdf931af in create_sort_index (thd=0x7fb8a5416070, join=0x7fb8a5464df0, tab=0x7fb8a5466b70, fsort=0x7fb8a54676b0) at /data/src/bb-10.2-monty/sql/sql_select.cc:21464
#22 0x00007fb8cdf8dc2a in st_join_table::sort_table (this=0x7fb8a5466b70) at /data/src/bb-10.2-monty/sql/sql_select.cc:19301
#23 0x00007fb8cdf8d922 in join_init_read_record (tab=0x7fb8a5466b70) at /data/src/bb-10.2-monty/sql/sql_select.cc:19248
#24 0x00007fb8cdf8b92d in sub_select (join=0x7fb8a5464df0, join_tab=0x7fb8a5466b70, end_of_records=false) at /data/src/bb-10.2-monty/sql/sql_select.cc:18340
#25 0x00007fb8cdf8af4d in do_select (join=0x7fb8a5464df0, procedure=0x0) at /data/src/bb-10.2-monty/sql/sql_select.cc:17887
#26 0x00007fb8cdf65fc4 in JOIN::exec_inner (this=0x7fb8a5464df0) at /data/src/bb-10.2-monty/sql/sql_select.cc:3388
#27 0x00007fb8cdf6550e in JOIN::exec (this=0x7fb8a5464df0) at /data/src/bb-10.2-monty/sql/sql_select.cc:3199
#28 0x00007fb8cdf66665 in mysql_select (thd=0x7fb8a5416070, tables=0x7fb8a5464298, wild_num=1, fields=..., conds=0x7fb8a5464a58, og_num=1, order=0x7fb8a5464cc0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fb8a5464dd0, unit=0x7fb8a5419b48, select_lex=0x7fb8a541a278) at /data/src/bb-10.2-monty/sql/sql_select.cc:3584
#29 0x00007fb8cdf5b71d in handle_select (thd=0x7fb8a5416070, lex=0x7fb8a5419a80, result=0x7fb8a5464dd0, setup_tables_done_option=0) at /data/src/bb-10.2-monty/sql/sql_select.cc:373
#30 0x00007fb8cdf27ec9 in execute_sqlcom_select (thd=0x7fb8a5416070, all_tables=0x7fb8a5464298) at /data/src/bb-10.2-monty/sql/sql_parse.cc:6396
#31 0x00007fb8cdf1d9b8 in mysql_execute_command (thd=0x7fb8a5416070) at /data/src/bb-10.2-monty/sql/sql_parse.cc:3426
#32 0x00007fb8cdf2b888 in mysql_parse (thd=0x7fb8a5416070, rawbuf=0x7fb8a5464088 "SELECT * FROM t1 WHERE vc != 'bar' ORDER BY vd", length=46, parser_state=0x7fb8cf03add0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.2-monty/sql/sql_parse.cc:7839
#33 0x00007fb8cdf1944e in dispatch_command (command=COM_QUERY, thd=0x7fb8a5416070, packet=0x7fb8a5458071 "", packet_length=46, is_com_multi=false, is_next_command=false) at /data/src/bb-10.2-monty/sql/sql_parse.cc:1799
#34 0x00007fb8cdf17e28 in do_command (thd=0x7fb8a5416070) at /data/src/bb-10.2-monty/sql/sql_parse.cc:1359
#35 0x00007fb8ce05fc46 in do_handle_one_connection (connect=0x7fb8cac75050) at /data/src/bb-10.2-monty/sql/sql_connect.cc:1354
#36 0x00007fb8ce05f9d3 in handle_one_connection (arg=0x7fb8cac75050) at /data/src/bb-10.2-monty/sql/sql_connect.cc:1260
#37 0x00007fb8ce39e582 in pfs_spawn_thread (arg=0x7fb8b83ed770) at /data/src/bb-10.2-monty/storage/perfschema/pfs.cc:1862
#38 0x00007fb8cd54c0a4 in start_thread (arg=0x7fb8cf03c300) at pthread_create.c:309
#39 0x00007fb8cb4f987d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

Elena Stepanova added a comment - 2017-01-05 12:59 The following test case still produces the same assertion failure, only in Field_varstring::val_str: --source include/have_innodb.inc CREATE TABLE t1 ( d DECIMAL (63,0) NOT NULL DEFAULT 0, c VARCHAR (64) NOT NULL DEFAULT '' , vd DECIMAL (63,0) AS (d) VIRTUAL, vc VARCHAR (2048) AS (c) VIRTUAL, pk BIGINT AUTO_INCREMENT, PRIMARY KEY (pk) ) ENGINE=InnoDB; INSERT INTO t1 (d,c) VALUES (0.5, 'foo' ); SELECT * FROM t1 WHERE vc != 'bar' ORDER BY vd; bb-10.2-monty e127bd70e55 mysqld: /data/src/bb-10.2-monty/sql/field.cc:7511: virtual String* Field_varstring::val_str(String*, String*): Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed. 170105 14:56:37 [ERROR] mysqld got signal 6 ; #7 0x00007fb8cb43f312 in __GI___assert_fail (assertion=0x7fb8cea5a040 "!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))", file=0x7fb8cea59dd8 "/data/src/bb-10.2-monty/sql/field.cc", line=7511, function=0x7fb8cea5e420 <Field_varstring::val_str(String*, String*)::__PRETTY_FUNCTION__> "virtual String* Field_varstring::val_str(String*, String*)") at assert.c:101 #8 0x00007fb8ce16a24a in Field_varstring::val_str (this=0x7fb8a5428a90, val_buffer=0x7fb8cf038d50, val_ptr=0x7fb8cf038d50) at /data/src/bb-10.2-mo#9 0x00007fb8cde5b4ef in Field::val_str (this=0x7fb8a5428a90, str=0x7fb8cf038d50) at /data/src/bb-10.2-monty/sql/field.h:833 #10 0x00007fb8ce1754ee in Field::save_in_field_str (this=0x7fb8a5428a90, to=0x7fb8a5428c48) at /data/src/bb-10.2-monty/sql/field.h:674 #11 0x00007fb8ce17671f in Field_str::save_in_field (this=0x7fb8a5428a90, to=0x7fb8a5428c48) at /data/src/bb-10.2-monty/sql/field.h:1655 #12 0x00007fb8ce1755da in Field::store_field (this=0x7fb8a5428c48, from=0x7fb8a5428a90) at /data/src/bb-10.2-monty/sql/field.h:806 #13 0x00007fb8ce17db63 in field_conv_incompatible (to=0x7fb8a5428c48, from=0x7fb8a5428a90) at /data/src/bb-10.2-monty/sql/field_conv.cc:814 #14 0x00007fb8ce17dbbf in field_conv (to=0x7fb8a5428c48, from=0x7fb8a5428a90) at /data/src/bb-10.2-monty/sql/field_conv.cc:827 #15 0x00007fb8ce1a9d6b in save_field_in_field (from=0x7fb8a5428a90, null_value=0x7fb8a561130a, to=0x7fb8a5428c48, no_conversions=false) at /data/src/bb-10.2-monty/sql/item.cc:6207 #16 0x00007fb8ce1a9f6a in Item_field::save_in_field (this=0x7fb8a5611298, to=0x7fb8a5428c48, no_conversions=false) at /data/src/bb-10.2-monty/sql/item.cc:6253 #17 0x00007fb8ce026955 in TABLE::update_virtual_fields (this=0x7fb8a54d7870, update_mode=VCOL_UPDATE_FOR_READ) at /data/src/bb-10.2-monty/sql/table.cc:7381 #18 0x00007fb8ce18b0f0 in handler::ha_rnd_next (this=0x7fb8a54b7888, buf=0x7fb8a55a5088 "\374\200") at /data/src/bb-10.2-monty/sql/handler.cc:2583 #19 0x00007fb8ce180568 in find_all_keys (thd=0x7fb8a5416070, param=0x7fb8cf039560, select=0x7fb8a54674d0, fs_info=0x7fb8a569e400, buffpek_pointers=0x7fb8cf039770, tempfile=0x7fb8cf0395f0, pq=0x0, found_rows=0x7fb8a569e5f0) at /data/src/bb-10.2-monty/sql/filesort.cc:793 #20 0x00007fb8ce17eb97 in filesort (thd=0x7fb8a5416070, table=0x7fb8a54d7870, filesort=0x7fb8a54676b0, tracker=0x7fb8a5467e88, join=0x7fb8a5464df0, first_table_bit=1) at /data/src/bb-10.2-monty/sql/filesort.cc:284 #21 0x00007fb8cdf931af in create_sort_index (thd=0x7fb8a5416070, join=0x7fb8a5464df0, tab=0x7fb8a5466b70, fsort=0x7fb8a54676b0) at /data/src/bb-10.2-monty/sql/sql_select.cc:21464 #22 0x00007fb8cdf8dc2a in st_join_table::sort_table (this=0x7fb8a5466b70) at /data/src/bb-10.2-monty/sql/sql_select.cc:19301 #23 0x00007fb8cdf8d922 in join_init_read_record (tab=0x7fb8a5466b70) at /data/src/bb-10.2-monty/sql/sql_select.cc:19248 #24 0x00007fb8cdf8b92d in sub_select (join=0x7fb8a5464df0, join_tab=0x7fb8a5466b70, end_of_records=false) at /data/src/bb-10.2-monty/sql/sql_select.cc:18340 #25 0x00007fb8cdf8af4d in do_select (join=0x7fb8a5464df0, procedure=0x0) at /data/src/bb-10.2-monty/sql/sql_select.cc:17887 #26 0x00007fb8cdf65fc4 in JOIN::exec_inner (this=0x7fb8a5464df0) at /data/src/bb-10.2-monty/sql/sql_select.cc:3388 #27 0x00007fb8cdf6550e in JOIN::exec (this=0x7fb8a5464df0) at /data/src/bb-10.2-monty/sql/sql_select.cc:3199 #28 0x00007fb8cdf66665 in mysql_select (thd=0x7fb8a5416070, tables=0x7fb8a5464298, wild_num=1, fields=..., conds=0x7fb8a5464a58, og_num=1, order=0x7fb8a5464cc0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fb8a5464dd0, unit=0x7fb8a5419b48, select_lex=0x7fb8a541a278) at /data/src/bb-10.2-monty/sql/sql_select.cc:3584 #29 0x00007fb8cdf5b71d in handle_select (thd=0x7fb8a5416070, lex=0x7fb8a5419a80, result=0x7fb8a5464dd0, setup_tables_done_option=0) at /data/src/bb-10.2-monty/sql/sql_select.cc:373 #30 0x00007fb8cdf27ec9 in execute_sqlcom_select (thd=0x7fb8a5416070, all_tables=0x7fb8a5464298) at /data/src/bb-10.2-monty/sql/sql_parse.cc:6396 #31 0x00007fb8cdf1d9b8 in mysql_execute_command (thd=0x7fb8a5416070) at /data/src/bb-10.2-monty/sql/sql_parse.cc:3426 #32 0x00007fb8cdf2b888 in mysql_parse (thd=0x7fb8a5416070, rawbuf=0x7fb8a5464088 "SELECT * FROM t1 WHERE vc != 'bar' ORDER BY vd", length=46, parser_state=0x7fb8cf03add0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.2-monty/sql/sql_parse.cc:7839 #33 0x00007fb8cdf1944e in dispatch_command (command=COM_QUERY, thd=0x7fb8a5416070, packet=0x7fb8a5458071 "", packet_length=46, is_com_multi=false, is_next_command=false) at /data/src/bb-10.2-monty/sql/sql_parse.cc:1799 #34 0x00007fb8cdf17e28 in do_command (thd=0x7fb8a5416070) at /data/src/bb-10.2-monty/sql/sql_parse.cc:1359 #35 0x00007fb8ce05fc46 in do_handle_one_connection (connect=0x7fb8cac75050) at /data/src/bb-10.2-monty/sql/sql_connect.cc:1354 #36 0x00007fb8ce05f9d3 in handle_one_connection (arg=0x7fb8cac75050) at /data/src/bb-10.2-monty/sql/sql_connect.cc:1260 #37 0x00007fb8ce39e582 in pfs_spawn_thread (arg=0x7fb8b83ed770) at /data/src/bb-10.2-monty/storage/perfschema/pfs.cc:1862 #38 0x00007fb8cd54c0a4 in start_thread (arg=0x7fb8cf03c300) at pthread_create.c:309 #39 0x00007fb8cb4f987d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

Michael Widenius added a comment - 2017-01-06 13:02

Problem with read_set in filesort found and fixed.

Michael Widenius added a comment - 2017-01-06 13:02 Problem with read_set in filesort found and fixed.

Michael Widenius added a comment - 2017-01-06 13:34

Fix pushed to bb-10.2-monty

Michael Widenius added a comment - 2017-01-06 13:34 Fix pushed to bb-10.2-monty

People

Assignee:: Michael Widenius

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2016-12-18 16:50

Updated:: 2017-01-11 08:35

Resolved:: 2017-01-11 08:35

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server