--source include/have_innodb.inc

CREATE TABLE t1 (id int, k int, PRIMARY KEY (id)) ENGINE=InnoDB WITH SYSTEM VERSIONING;

INSERT INTO t1 VALUES (1,1),(2,2);

CREATE VIEW v1 AS SELECT * FROM t1;

UPDATE v1 SET id = 2 WHERE k = 0;

# Cleanup

DROP VIEW v1;

DROP TABLE t1;

mysqld: /data/src/10.3/sql/field.cc:4300: virtual longlong Field_long::val_int(): Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index) || (!(ptr >= table->record[0] && ptr < table->record[0] + table->s->reclength)))' failed.

191203 11:48:18 [ERROR] mysqld got signal 6 ;

#7  0x00007f38209dff12 in __GI___assert_fail (assertion=0x5653f82647c0 "!table || (!table->read_set || bitmap_is_set(table->read_set, field_index) || (!(ptr >= table->record[0] && ptr < table->record[0] + table->s->reclength)))", file=0x5653f8264619 "/data/src/10.3/sql/field.cc", line=4300, function=0x5653f8267000 <Field_long::val_int()::__PRETTY_FUNCTION__> "virtual longlong Field_long::val_int()") at assert.c:101

#8  0x00005653f7787dae in Field_long::val_int (this=0x7f37c8006c38) at /data/src/10.3/sql/field.cc:4300

#9  0x00005653f77e04b5 in Item_field::val_int (this=0x7f37c8015038) at /data/src/10.3/sql/item.cc:3432

#10 0x00005653f77f0211 in Item_direct_ref::val_int (this=0x7f37c8016968) at /data/src/10.3/sql/item.cc:8517

#11 0x00005653f77fb093 in Item_direct_view_ref::val_int (this=0x7f37c8016968) at /data/src/10.3/sql/item.h:5333

#12 0x00005653f780333b in Arg_comparator::compare_int_signed (this=0x7f37c80133b8) at /data/src/10.3/sql/item_cmpfunc.cc:915

#13 0x00005653f78181be in Arg_comparator::compare (this=0x7f37c80133b8) at /data/src/10.3/sql/item_cmpfunc.h:102

#14 0x00005653f7805cec in Item_func_eq::val_int (this=0x7f37c80132f8) at /data/src/10.3/sql/item_cmpfunc.cc:1743

#15 0x00005653f76a216b in Type_handler_int_result::Item_val_bool (this=0x5653f8b02950 <type_handler_long>, item=0x7f37c80132f8) at /data/src/10.3/sql/sql_type.cc:3281

#16 0x00005653f7394e4e in Item::val_bool (this=0x7f37c80132f8) at /data/src/10.3/sql/item.h:1213

#17 0x00005653f7810f02 in Item_cond_and::val_int (this=0x7f37c8016aa0) at /data/src/10.3/sql/item_cmpfunc.cc:5070

#18 0x00005653f75b02f0 in SQL_SELECT::skip_record (this=0x7f37c8016da8, thd=0x7f37c8000af0) at /data/src/10.3/sql/opt_range.h:1658

#19 0x00005653f75a8b01 in mysql_update (thd=0x7f37c8000af0, table_list=0x7f37c8012908, fields=..., values=..., conds=0x7f37c8016aa0, order_num=0, order=0x0, limit=18446744073709551615, ignore=false, found_return=0x7f3819d80f10, updated_return=0x7f3819d80fd0) at /data/src/10.3/sql/sql_update.cc:759

#20 0x00005653f74a60d7 in mysql_execute_command (thd=0x7f37c8000af0) at /data/src/10.3/sql/sql_parse.cc:4301

#21 0x00005653f74b214b in mysql_parse (thd=0x7f37c8000af0, rawbuf=0x7f37c8012818 "UPDATE v1 SET id = 2 WHERE k = 0", length=32, parser_state=0x7f3819d815e0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7818

#22 0x00005653f749ec97 in dispatch_command (command=COM_QUERY, thd=0x7f37c8000af0, packet=0x7f37c8165681 "UPDATE v1 SET id = 2 WHERE k = 0", packet_length=32, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1856

#23 0x00005653f749d5df in do_command (thd=0x7f37c8000af0) at /data/src/10.3/sql/sql_parse.cc:1401

#24 0x00005653f7614a70 in do_handle_one_connection (connect=0x5653fb369540) at /data/src/10.3/sql/sql_connect.cc:1403

#25 0x00005653f76147d2 in handle_one_connection (arg=0x5653fb369540) at /data/src/10.3/sql/sql_connect.cc:1308

#26 0x00005653f7fc230c in pfs_spawn_thread (arg=0x5653fb2b3360) at /data/src/10.3/storage/perfschema/pfs.cc:1862

#27 0x00007f38225554a4 in start_thread (arg=0x7f3819d82700) at pthread_create.c:456

#28 0x00007f3820a9cd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

mysqld: /data/src/10.4/sql/field.cc:4292: virtual longlong Field_long::val_int(): Assertion `marked_for_read()' failed.

191203 11:49:48 [ERROR] mysqld got signal 6 ;

#7  0x00007f44e212df12 in __GI___assert_fail (assertion=0x559ac22c1d50 "marked_for_read()", file=0x559ac22c1b8b "/data/src/10.4/sql/field.cc", line=4292, function=0x559ac22c4600 <Field_long::val_int()::__PRETTY_FUNCTION__> "virtual longlong Field_long::val_int()") at assert.c:101

#8  0x0000559ac1777931 in Field_long::val_int (this=0x7f44880400d8) at /data/src/10.4/sql/field.cc:4292

#9  0x0000559ac17cfdb1 in Item_field::val_int (this=0x7f4488016308) at /data/src/10.4/sql/item.cc:3196

#10 0x0000559ac17dfad9 in Item_direct_ref::val_int (this=0x7f44880185a0) at /data/src/10.4/sql/item.cc:8342

#11 0x0000559ac17ea24d in Item_direct_view_ref::val_int (this=0x7f44880185a0) at /data/src/10.4/sql/item.h:5725

#12 0x0000559ac17f32fb in Arg_comparator::compare_int_signed (this=0x7f4488013d68) at /data/src/10.4/sql/item_cmpfunc.cc:936

#13 0x0000559ac180a00c in Arg_comparator::compare (this=0x7f4488013d68) at /data/src/10.4/sql/item_cmpfunc.h:104

#14 0x0000559ac17f5c5c in Item_func_eq::val_int (this=0x7f4488013ca0) at /data/src/10.4/sql/item_cmpfunc.cc:1769

#15 0x0000559ac166aeef in Type_handler_int_result::Item_val_bool (this=0x559ac2be9b70 <type_handler_bool>, item=0x7f4488013ca0) at /data/src/10.4/sql/sql_type.cc:4416

#16 0x0000559ac1329b9e in Item::val_bool (this=0x7f4488013ca0) at /data/src/10.4/sql/item.h:1458

#17 0x0000559ac1802112 in Item_cond_and::val_int (this=0x7f44880186d8) at /data/src/10.4/sql/item_cmpfunc.cc:5297

#18 0x0000559ac1564a44 in SQL_SELECT::skip_record (this=0x7f44880189e8, thd=0x7f4488000af0) at /data/src/10.4/sql/opt_range.h:1664

#19 0x0000559ac155cdc6 in mysql_update (thd=0x7f4488000af0, table_list=0x7f4488013248, fields=..., values=..., conds=0x7f44880186d8, order_num=0, order=0x0, limit=18446744073709551615, ignore=false, found_return=0x7f44dc0fe840, updated_return=0x7f44dc0fe900) at /data/src/10.4/sql/sql_update.cc:846

#20 0x0000559ac144e3b9 in mysql_execute_command (thd=0x7f4488000af0) at /data/src/10.4/sql/sql_parse.cc:4377

#21 0x0000559ac145b387 in mysql_parse (thd=0x7f4488000af0, rawbuf=0x7f4488013158 "UPDATE v1 SET id = 2 WHERE k = 0", length=32, parser_state=0x7f44dc0ff160, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7901

#22 0x0000559ac144652c in dispatch_command (command=COM_QUERY, thd=0x7f4488000af0, packet=0x7f44881363c1 "UPDATE v1 SET id = 2 WHERE k = 0", packet_length=32, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1842

#23 0x0000559ac1444bb9 in do_command (thd=0x7f4488000af0) at /data/src/10.4/sql/sql_parse.cc:1360

#24 0x0000559ac15cd6a7 in do_handle_one_connection (connect=0x559ac41c3e50) at /data/src/10.4/sql/sql_connect.cc:1412

#25 0x0000559ac15cd3f6 in handle_one_connection (arg=0x559ac41c3e50) at /data/src/10.4/sql/sql_connect.cc:1316

#26 0x0000559ac1fcf7bb in pfs_spawn_thread (arg=0x559ac4141540) at /data/src/10.4/storage/perfschema/pfs.cc:1862

#27 0x00007f44e3ca34a4 in start_thread (arg=0x7f44dc100700) at pthread_create.c:456

#28 0x00007f44e21ead0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

CREATE TABLE t1 (a INT) WITH SYSTEM VERSIONING;

CREATE VIEW v1 AS SELECT * FROM t1;

CREATE PROCEDURE sp() UPDATE v1 SET xx = 1; 

--error ER_BAD_FIELD_ERROR

CALL sp;

--error ER_BAD_FIELD_ERROR

CALL sp;

# Cleanup

DROP PROCEDURE sp;

DROP VIEW v1;

DROP TABLE t1;

#3  <signal handler called>

#4  0x0000561a1fe05f46 in Item_cond::fix_fields (this=0x7f5b5c0388f8, thd=0x7f5b5c000af0, ref=0x7f5b5c073cd0) at /data/src/bb-10.3-release/sql/item_cmpfunc.cc:4592

#5  0x0000561a1fbbe685 in TABLE_LIST::prep_where (this=0x7f5b5c073ae0, thd=0x7f5b5c000af0, conds=0x7f5b6e5253d8, no_where_clause=false) at /data/src/bb-10.3-release/sql/table.cc:4978

#6  0x0000561a1fa15db3 in TABLE_LIST::prepare_where (this=0x7f5b5c073ae0, thd=0x7f5b5c000af0, conds=0x7f5b6e5253d8, no_where_clause=false) at /data/src/bb-10.3-release/sql/table.h:2480

#7  0x0000561a1fa13250 in setup_conds (thd=0x7f5b5c000af0, tables=0x7f5b5c073ae0, leaves=..., conds=0x7f5b6e5253d8) at /data/src/bb-10.3-release/sql/sql_base.cc:8186

#8  0x0000561a1fba0d6d in mysql_prepare_update (thd=0x7f5b5c000af0, table_list=0x7f5b5c073ae0, conds=0x7f5b6e5253d8, order_num=0, order=0x0) at /data/src/bb-10.3-release/sql/sql_update.cc:1288

#9  0x0000561a1fb9dc23 in mysql_update (thd=0x7f5b5c000af0, table_list=0x7f5b5c073ae0, fields=..., values=..., conds=0x7f5b5c0384c0, order_num=0, order=0x0, limit=18446744073709551615, ignore=false, found_return=0x7f5b6e525aa0, updated_return=0x7f5b6e525b60) at /data/src/bb-10.3-release/sql/sql_update.cc:401

#10 0x0000561a1fa9c6f3 in mysql_execute_command (thd=0x7f5b5c000af0) at /data/src/bb-10.3-release/sql/sql_parse.cc:4301

#11 0x0000561a1f9bdf16 in sp_instr_stmt::exec_core (this=0x7f5b5c074320, thd=0x7f5b5c000af0, nextp=0x7f5b6e5261c4) at /data/src/bb-10.3-release/sql/sp_head.cc:3592

#12 0x0000561a1f9bd3d4 in sp_lex_keeper::reset_lex_and_exec_core (this=0x7f5b5c074368, thd=0x7f5b5c000af0, nextp=0x7f5b6e5261c4, open_tables=false, instr=0x7f5b5c074320) at /data/src/bb-10.3-release/sql/sp_head.cc:3324

#13 0x0000561a1f9bdaf6 in sp_instr_stmt::execute (this=0x7f5b5c074320, thd=0x7f5b5c000af0, nextp=0x7f5b6e5261c4) at /data/src/bb-10.3-release/sql/sp_head.cc:3498

#14 0x0000561a1f9b7734 in sp_head::execute (this=0x7f5b5c072e58, thd=0x7f5b5c000af0, merge_da_on_success=true) at /data/src/bb-10.3-release/sql/sp_head.cc:1356

#15 0x0000561a1f9ba1ec in sp_head::execute_procedure (this=0x7f5b5c072e58, thd=0x7f5b5c000af0, args=0x7f5b5c005778) at /data/src/bb-10.3-release/sql/sp_head.cc:2296

#16 0x0000561a1fa984f2 in do_execute_sp (thd=0x7f5b5c000af0, sp=0x7f5b5c072e58) at /data/src/bb-10.3-release/sql/sql_parse.cc:2992

#17 0x0000561a1fa99168 in Sql_cmd_call::execute (this=0x7f5b5c0128d0, thd=0x7f5b5c000af0) at /data/src/bb-10.3-release/sql/sql_parse.cc:3232

#18 0x0000561a1faa3006 in mysql_execute_command (thd=0x7f5b5c000af0) at /data/src/bb-10.3-release/sql/sql_parse.cc:6031

#19 0x0000561a1faa8767 in mysql_parse (thd=0x7f5b5c000af0, rawbuf=0x7f5b5c012818 "CALL sp", length=7, parser_state=0x7f5b6e5275e0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-release/sql/sql_parse.cc:7818

#20 0x0000561a1fa952b3 in dispatch_command (command=COM_QUERY, thd=0x7f5b5c000af0, packet=0x7f5b5c123431 "CALL sp", packet_length=7, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-release/sql/sql_parse.cc:1856

#21 0x0000561a1fa93bfb in do_command (thd=0x7f5b5c000af0) at /data/src/bb-10.3-release/sql/sql_parse.cc:1401

#22 0x0000561a1fc0b02c in do_handle_one_connection (connect=0x561a22b3f9e0) at /data/src/bb-10.3-release/sql/sql_connect.cc:1403

#23 0x0000561a1fc0ad8e in handle_one_connection (arg=0x561a22b3f9e0) at /data/src/bb-10.3-release/sql/sql_connect.cc:1308

#24 0x0000561a205b7858 in pfs_spawn_thread (arg=0x561a22b5a9a0) at /data/src/bb-10.3-release/storage/perfschema/pfs.cc:1862

#25 0x00007f5b75e9e4a4 in start_thread (arg=0x7f5b6e528700) at pthread_create.c:456

#26 0x00007f5b743e5d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97

commit bf2f391664c56334ff9229e448bb3efa166c40b7

Author: Aleksey Midenkov <midenok@gmail.com>

Date:   Tue Dec 3 15:46:49 2019 +0300

    MDEV-21147 Assertion `marked_for_read()' upon UPDATE on versioned table via view

    Unit prepare prematurely fixed field which must be fixed via

    setup_conds() to correctly update table->covering_keys.

    Call vers_setup_conds() directly instead, because actually everything

    else is not needed.