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()

    XMLWordPrintable

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

            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.