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;

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