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

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

    XMLWordPrintable

Details

    Description

      CREATE TABLE t (f1 INT, f2 INT, f3 INT AS (f1*2) VIRTUAL, KEY(f3,f2));
      INSERT INTO t (f1,f2) VALUES (1,1),(2,2);
       
      CREATE VIEW v AS 
        SELECT a2.f1, a2.f2, a1.f3 
        FROM t a1, t a2 
        WHERE a2.f3 <> 0 
        WITH LOCAL CHECK OPTION;
       
      UPDATE v SET f3 = 52;
      

      10.2 86fc5ece26f

      mysqld: /data/src/10.2/sql/field.cc:4197: virtual longlong Field_long::val_int(): Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed.
      170823  1:14:58 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f213dbbdee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x000055f44685eb28 in Field_long::val_int (this=0x7f211c06ee78) at /data/src/10.2/sql/field.cc:4197
      #9  0x000055f4468a0d3e in Item_field::val_int (this=0x7f211c168b48) at /data/src/10.2/sql/item.cc:2753
      #10 0x000055f4469015fa in Item_func_mul::int_op (this=0x7f211c168cd8) at /data/src/10.2/sql/item_func.cc:1531
      #11 0x000055f4468ff2a4 in Item_func_hybrid_field_type::val_int (this=0x7f211c168cd8) at /data/src/10.2/sql/item_func.cc:938
      #12 0x000055f4468aada7 in Item::save_in_field (this=0x7f211c168cd8, field=0x7f211c06f018, no_conversions=false) at /data/src/10.2/sql/item.cc:6410
      #13 0x000055f446723d0c in TABLE::update_virtual_fields (this=0x7f211c06e230, h=0x7f211c168338, update_mode=VCOL_UPDATE_FOR_READ) at /data/src/10.2/sql/table.cc:7434
      #14 0x000055f44688ba94 in handler::ha_rnd_pos (this=0x7f211c168338, buf=0x7f211c06ee38 "\361\001", pos=0x7f211c174ce0 "") at /data/src/10.2/sql/handler.cc:2580
      #15 0x000055f446707439 in multi_update::do_updates (this=0x7f211c017208) at /data/src/10.2/sql/sql_update.cc:2398
      #16 0x000055f446707bab in multi_update::send_eof (this=0x7f211c017208) at /data/src/10.2/sql/sql_update.cc:2540
      #17 0x000055f44668693c in do_select (join=0x7f211c0172d0, procedure=0x0) at /data/src/10.2/sql/sql_select.cc:18161
      #18 0x000055f446660f47 in JOIN::exec_inner (this=0x7f211c0172d0) at /data/src/10.2/sql/sql_select.cc:3483
      #19 0x000055f4466603f6 in JOIN::exec (this=0x7f211c0172d0) at /data/src/10.2/sql/sql_select.cc:3278
      #20 0x000055f4466615bf in mysql_select (thd=0x7f211c000b00, tables=0x7f211c012500, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=1342177408, result=0x7f211c017208, unit=0x7f211c0046a0, select_lex=0x7f211c004dd8) at /data/src/10.2/sql/sql_select.cc:3678
      #21 0x000055f446704852 in mysql_multi_update (thd=0x7f211c000b00, table_list=0x7f211c012500, fields=0x7f211c004f00, values=0x7f211c0053b0, conds=0x0, options=0, handle_duplicates=DUP_ERROR, ignore=false, unit=0x7f211c0046a0, select_lex=0x7f211c004dd8, result=0x7f2138699920) at /data/src/10.2/sql/sql_update.cc:1604
      #22 0x000055f44661a368 in mysql_execute_command (thd=0x7f211c000b00) at /data/src/10.2/sql/sql_parse.cc:4336
      #23 0x000055f446625762 in mysql_parse (thd=0x7f211c000b00, rawbuf=0x7f211c012428 "UPDATE v SET f3 = 52", length=20, parser_state=0x7f213869a200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7886
      #24 0x000055f44661376d in dispatch_command (command=COM_QUERY, thd=0x7f211c000b00, packet=0x7f211c163271 "UPDATE v SET f3 = 52", packet_length=20, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1812
      #25 0x000055f4466120e7 in do_command (thd=0x7f211c000b00) at /data/src/10.2/sql/sql_parse.cc:1360
      #26 0x000055f44675ea53 in do_handle_one_connection (connect=0x55f4488d7270) at /data/src/10.2/sql/sql_connect.cc:1354
      #27 0x000055f44675e7e0 in handle_one_connection (arg=0x55f4488d7270) at /data/src/10.2/sql/sql_connect.cc:1260
      #28 0x000055f446b7a8e0 in pfs_spawn_thread (arg=0x55f4488b1e00) at /data/src/10.2/storage/perfschema/pfs.cc:1862
      #29 0x00007f213fb02494 in start_thread (arg=0x7f213869b700) at pthread_create.c:333
      #30 0x00007f213dc7a93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Attachments

        Activity

          People

            serg Sergei Golubchik
            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.