Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
-
None
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
|