Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11598

Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed in Field_double::val_real()

Details

    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

          Activity

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

            elenst Elena Stepanova added a comment - Also reproducible on bb-10.2-monty as of 349d69e2e

            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.
            monty Michael Widenius added a comment - 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.

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

            monty Michael Widenius added a comment - Fix pushed into bb-10.2-monty Will be pushed soon into 10.2 (after some testing)

            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
            

            elenst Elena Stepanova added a comment - 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

            Problem with read_set in filesort found and fixed.

            monty Michael Widenius added a comment - Problem with read_set in filesort found and fixed.

            Fix pushed to bb-10.2-monty

            monty Michael Widenius added a comment - Fix pushed to bb-10.2-monty

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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