Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL), 10.5
-
None
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
- duplicates
-
MDEV-18166 ASSERT_COLUMN_MARKED_FOR_READ failed on tables with vcols
- Closed
- relates to
-
MDEV-20056 Assertion `!prebuilt->index->is_primary()' failed in row_search_idx_cond_check
- Closed
-
MDEV-19306 Assertion `marked_for_read()' failed in Field_blob::val_str with virtual columns and views
- Closed