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

Assertion `marked_for_read()' failed in Field_long::val_int

    Details

      Description

      CREATE TABLE t1 (a INT) ENGINE=MyISAM;
      INSERT INTO t1 VALUES (1),(0);
       
      CREATE TABLE t2 (
        b INT,
        b1 INT GENERATED ALWAYS AS (b/2) STORED,
        b2 INT GENERATED ALWAYS AS (b*2) VIRTUAL,
        b3 INT GENERATED ALWAYS AS (b MOD 128) STORED,
        KEY (b1),
        KEY (b3),
        KEY (b1,b3,b2),
        KEY (b2,b3)
      ) ENGINE=MyISAM;
      INSERT INTO t2 (b) VALUES (6),(6),(8),(0),(4);
       
      CREATE TABLE t3 (c INT) ENGINE=MyISAM;
      INSERT INTO t3 VALUES (1),(2);
       
      CREATE ALGORITHM = MERGE VIEW v AS SELECT t2.b1, t2.b2 FROM t1 STRAIGHT_JOIN t2 ON t1.a = t2.b3;
       
      SELECT * FROM v STRAIGHT_JOIN t3 ON v.b2 = t3.c WHERE v.b1 <= 0;
       
      # Cleanup
      DROP VIEW v;
      DROP TABLE t1, t2, t3;
      

      10.4 81f6a3b0

      mysqld: /data/src/10.4/sql/field.cc:4257: virtual longlong Field_long::val_int(): Assertion `marked_for_read()' failed.
      190429 20:31:16 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007ffa21e0aee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x0000556612ba0fc4 in Field_long::val_int (this=0x7ffa001532f8) at /data/src/10.4/sql/field.cc:4257
      #9  0x0000556612bf28a2 in Item_field::val_int (this=0x7ffa001557b8) at /data/src/10.4/sql/item.cc:3153
      #10 0x0000556612c56f92 in Item_func_mul::int_op (this=0x7ffa00155630) at /data/src/10.4/sql/item_func.cc:1316
      #11 0x0000556612ab510b in Item_func_hybrid_field_type::val_int_from_int_op (this=0x7ffa00155630) at /data/src/10.4/sql/item_func.h:701
      #12 0x0000556612aa122c in Type_handler_int_result::Item_func_hybrid_field_type_val_int (this=0x556613f2f2f8 <type_handler_longlong>, item=0x7ffa00155630) at /data/src/10.4/sql/sql_type.cc:4679
      #13 0x000055661287dfee in Item_func_hybrid_field_type::val_int (this=0x7ffa00155630) at /data/src/10.4/sql/item_func.h:757
      #14 0x0000556612bfc09e in Item::save_int_in_field (this=0x7ffa00155630, field=0x7ffa001534b8, no_conversions=false) at /data/src/10.4/sql/item.cc:6482
      #15 0x0000556612a9ebc4 in Type_handler_int_result::Item_save_in_field (this=0x556613f2f2f8 <type_handler_longlong>, item=0x7ffa00155630, field=0x7ffa001534b8, no_conversions=false) at /data/src/10.4/sql/sql_type.cc:3587
      #16 0x0000556612bfc149 in Item::save_in_field (this=0x7ffa00155630, field=0x7ffa001534b8, no_conversions=false) at /data/src/10.4/sql/item.cc:6492
      #17 0x00005566129c59c4 in TABLE::update_virtual_fields (this=0x7ffa00152430, h=0x7ffa001536f8, update_mode=VCOL_UPDATE_FOR_READ) at /data/src/10.4/sql/table.cc:8198
      #18 0x0000556612bd6300 in handler::ha_rnd_next (this=0x7ffa001536f8, buf=0x7ffa001532a0 "\341\006") at /data/src/10.4/sql/handler.cc:2823
      #19 0x0000556612d69b63 in rr_sequential (info=0x7ffa0004a140) at /data/src/10.4/sql/records.cc:481
      #20 0x00005566127eed1b in READ_RECORD::read_record (this=0x7ffa0004a140) at /data/src/10.4/sql/records.h:73
      #21 0x000055661291544f in join_init_read_record (tab=0x7ffa0004a078) at /data/src/10.4/sql/sql_select.cc:20985
      #22 0x0000556612a580cc in JOIN_TAB_SCAN::open (this=0x7ffa0004bba8) at /data/src/10.4/sql/sql_join_cache.cc:3348
      #23 0x0000556612a5651c in JOIN_CACHE::join_matching_records (this=0x7ffa0004d428, skip_last=false) at /data/src/10.4/sql/sql_join_cache.cc:2251
      #24 0x0000556612a5607e in JOIN_CACHE::join_records (this=0x7ffa0004d428, skip_last=false) at /data/src/10.4/sql/sql_join_cache.cc:2088
      #25 0x0000556612912d1c in sub_select_cache (join=0x7ffa00045690, join_tab=0x7ffa0004a078, end_of_records=true) at /data/src/10.4/sql/sql_select.cc:19822
      #26 0x0000556612912f29 in sub_select (join=0x7ffa00045690, join_tab=0x7ffa00049cb0, end_of_records=true) at /data/src/10.4/sql/sql_select.cc:19993
      #27 0x00005566129126f1 in do_select (join=0x7ffa00045690, procedure=0x0) at /data/src/10.4/sql/sql_select.cc:19584
      #28 0x00005566128e9277 in JOIN::exec_inner (this=0x7ffa00045690) at /data/src/10.4/sql/sql_select.cc:4389
      #29 0x00005566128e841e in JOIN::exec (this=0x7ffa00045690) at /data/src/10.4/sql/sql_select.cc:4171
      #30 0x00005566128e9ad0 in mysql_select (thd=0x7ffa00000b00, tables=0x7ffa00015c78, wild_num=1, fields=..., conds=0x7ffa00017808, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7ffa00045668, unit=0x7ffa00004a28, select_lex=0x7ffa000156b8) at /data/src/10.4/sql/sql_select.cc:4603
      #31 0x00005566128da040 in handle_select (thd=0x7ffa00000b00, lex=0x7ffa00004960, result=0x7ffa00045668, setup_tables_done_option=0) at /data/src/10.4/sql/sql_select.cc:424
      #32 0x00005566128a38d9 in execute_sqlcom_select (thd=0x7ffa00000b00, all_tables=0x7ffa00015c78) at /data/src/10.4/sql/sql_parse.cc:6597
      #33 0x0000556612898eaf in mysql_execute_command (thd=0x7ffa00000b00) at /data/src/10.4/sql/sql_parse.cc:3886
      #34 0x00005566128a765f in mysql_parse (thd=0x7ffa00000b00, rawbuf=0x7ffa000155d8 "SELECT * FROM v STRAIGHT_JOIN t3 ON v.b2 = t3.c WHERE v.b1 <= 0", length=63, parser_state=0x7ffa0ffb4180, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8149
      #35 0x00005566128930b6 in dispatch_command (command=COM_QUERY, thd=0x7ffa00000b00, packet=0x7ffa001398f1 "", packet_length=63, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1828
      #36 0x000055661289189c in do_command (thd=0x7ffa00000b00) at /data/src/10.4/sql/sql_parse.cc:1361
      #37 0x0000556612a09cad in do_handle_one_connection (connect=0x5566151d5290) at /data/src/10.4/sql/sql_connect.cc:1398
      #38 0x0000556612a09a1e in handle_one_connection (arg=0x5566151d5290) at /data/src/10.4/sql/sql_connect.cc:1301
      #39 0x0000556612e2ed9d in pfs_spawn_thread (arg=0x5566152726d0) at /data/src/10.4/storage/perfschema/pfs.cc:1862
      #40 0x00007ffa23eff494 in start_thread (arg=0x7ffa0ffb5700) at pthread_create.c:333
      #41 0x00007ffa21ec793f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      No obvious failure on a non-debug build.

      Not reproducible on 10.3.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sanja Oleksandr Byelkin
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: