Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
--source include/have_innodb.inc
|
|
CREATE TABLE t1 ( |
id int, |
dt1 date, |
i1 int, |
v_i1 int GENERATED ALWAYS AS (i1), |
PRIMARY KEY (id,i1), |
KEY i1 (i1), |
KEY v_i1 (v_i1) |
) ENGINE=InnoDB;
|
|
INSERT INTO t1(dt1, i1, id) VALUES |
('1994-04-27',3,1),('1939-03-07',8,2),('2035-04-15',195,3),('1936-02-07',8,4),('1912-08-14',9,5); |
|
SELECT dt1 FROM t1 WHERE i1 IN (1,2,3) AND (i1 NOT IN (0)) AND (v_i1 <= 0); |
10.5 e0d61cb41c809169b58843765ba1 |
Version: '10.5.10-MariaDB-debug-log'
|
mariadbd: /10.5/storage/innobase/row/row0sel.cc:2846: void row_sel_field_store_in_mysql_format_func(byte*, const mysql_row_templ_t*, const dict_index_t*, ulint, const byte*, ulint): Assertion `templ->mysql_col_len == len' failed.
|
210505 12:57:05 [ERROR] mysqld got signal 6 ;
|
|
linux/raise.c:51(__GI_raise)[0x7f7ea79f87bb]
|
stdlib/abort.c:81(__GI_abort)[0x7f7ea79e3535]
|
intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f7ea79e340f]
|
??:0(__assert_fail)[0x7f7ea79f1102]
|
row/row0sel.cc:2848(row_sel_field_store_in_mysql_format_func(unsigned char*, mysql_row_templ_t const*, dict_index_t const*, unsigned long, unsigned char const*, unsigned long))[0x5654c1ab8538]
|
row/row0sel.cc:3001(row_sel_store_mysql_field(unsigned char*, row_prebuilt_t*, unsigned char const*, dict_index_t const*, unsigned short const*, unsigned long, mysql_row_templ_t const*))[0x5654c1ab98a8]
|
row/row0sel.cc:3965(row_search_idx_cond_check(unsigned char*, row_prebuilt_t*, unsigned char const*, unsigned short const*))[0x5654c1abf0be]
|
row/row0sel.cc:5281(row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long))[0x5654c1ac8678]
|
handler/ha_innodb.cc:8854(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x5654c16a12fe]
|
sql/handler.h:3809(handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x5654c0bd6001]
|
sql/handler.cc:3123(handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x5654c0ba6bf5]
|
sql/handler.cc:6200(handler::read_range_first(st_key_range const*, st_key_range const*, bool, bool))[0x5654c0bc1454]
|
sql/multi_range_read.cc:516(handler::multi_range_read_next(void**))[0x5654c08a9484]
|
sql/multi_range_read.cc:553(Mrr_simple_index_reader::get_next(void**))[0x5654c08a9858]
|
sql/multi_range_read.cc:1653(DsMrr_impl::dsmrr_next(void**))[0x5654c08b3237]
|
handler/ha_innodb.cc:20409(ha_innobase::multi_range_read_next(void**))[0x5654c16d370c]
|
sql/opt_range.cc:12647(QUICK_RANGE_SELECT::get_next())[0x5654c0fb3f8d]
|
sql/records.cc:403(rr_quick(READ_RECORD*))[0x5654c0fe8107]
|
sql/records.h:80(READ_RECORD::read_record())[0x5654c01fbf5a]
|
sql/sql_select.cc:21766(join_init_read_record(st_join_table*))[0x5654c04ff80f]
|
sql/sql_select.cc:20818(sub_select(JOIN*, st_join_table*, bool))[0x5654c04f8af7]
|
sql/sql_select.cc:20355(do_select(JOIN*, Procedure*))[0x5654c04f6e52]
|
sql/sql_select.cc:4503(JOIN::exec_inner())[0x5654c04843ae]
|
sql/sql_select.cc:4284(JOIN::exec())[0x5654c04819fc]
|
sql/sql_select.cc:4761(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5654c0485c9d]
|
sql/sql_select.cc:443(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5654c0457ae3]
|
sql/sql_parse.cc:6313(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5654c03c45d6]
|
sql/sql_parse.cc:4009(mysql_execute_command(THD*))[0x5654c03b3585]
|
sql/sql_parse.cc:8099(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5654c03cf460]
|
sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5654c03a58d9]
|
sql/sql_parse.cc:1370(do_command(THD*))[0x5654c03a21e5]
|
sql/sql_connect.cc:1410(do_handle_one_connection(CONNECT*, bool))[0x5654c07d4b66]
|
sql/sql_connect.cc:1314(handle_one_connection)[0x5654c07d44c3]
|
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5654c14a2e46]
|
nptl/pthread_create.c:487(start_thread)[0x7f7ea7eb1fa3]
|
x86_64/clone.S:97(clone)[0x7f7ea7aba4cf]
|
|
Query (0x62b0000a12a8): SELECT dt1 FROM t1 WHERE i1 IN (1,2,3) AND (i1 NOT IN (0)) AND (v_i1 <= 0)
|
no visible effect on non-debug build
Attachments
Issue Links
- relates to
-
MDEV-18911 Assertion `(templ->is_virtual && !field) || (field && field->prefix_len ? field->prefix_len == len : templ->mysql_col_len == len)' failed row_sel_field_store_in_mysql_format_func
- Closed
-
MDEV-20940 Data corruption after partition maintenance for table using legacy DATETIME storage.
- Confirmed