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

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

    XMLWordPrintable

    Details

      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

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: