Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
Description
--source include/have_innodb.inc
|
|
|
CREATE OR REPLACE TABLE t1 (a INT, s BIGINT UNSIGNED AS ROW START, e BIGINT UNSIGNED AS ROW END, PERIOD FOR SYSTEM_TIME(s,e)) WITH SYSTEM VERSIONING ENGINE=InnoDB; |
CREATE OR REPLACE ALGORITHM=TEMPTABLE VIEW v AS SELECT * FROM t1; |
INSERT INTO t1 (a) VALUES (1); |
|
|
CREATE OR REPLACE TABLE t2 (f TIMESTAMP); |
INSERT INTO t2 VALUES ('2019-04-01 23:22:12'),('2019-04-01 23:22:12'); |
SELECT * from v WHERE s IN (SELECT f FROM t2); |
|
|
# Cleanup
|
DROP VIEW v; |
DROP TABLE t1, t2; |
|
10.3 ed661a0e |
mysqld: /data/src/10.3/sql/field.cc:2096: bool Field_vers_trx_id::get_date(MYSQL_TIME*, ulonglong, ulonglong): Assertion `table->versioned(VERS_TRX_ID) || (table->versioned() && table->s->table_category == TABLE_CATEGORY_TEMPORARY)' failed.
|
190402 3:09:22 [ERROR] mysqld got signal 6 ;
|
|
|
#7 0x00007f11f7889ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000055676aa8d0a6 in Field_vers_trx_id::get_date (this=0x7f11a003fd98, ltime=0x7f11f0bcd9e0, fuzzydate=33554433, trx_id=36) at /data/src/10.3/sql/field.cc:2095
|
#9 0x000055676aab9ae2 in Field_vers_trx_id::get_date (this=0x7f11a003fd98, ltime=0x7f11f0bcd9e0, fuzzydate=33554433) at /data/src/10.3/sql/field.h:2353
|
#10 0x000055676aaeb3ba in Item_field::get_date (this=0x7f11a0015578, ltime=0x7f11f0bcd9e0, fuzzydate=33554433) at /data/src/10.3/sql/item.cc:3445
|
#11 0x000055676a9b3030 in Temporal_with_date::make_from_item (this=0x7f11f0bcd9e0, thd=0x7f11a0000b00, item=0x7f11a0015578, flags=33554433) at /data/src/10.3/sql/sql_type.cc:150
|
#12 0x000055676a6c9870 in Temporal_with_date::Temporal_with_date (this=0x7f11f0bcd9e0, thd=0x7f11a0000b00, item=0x7f11a0015578, flags=33554433) at /data/src/10.3/sql/sql_type.h:295
|
#13 0x000055676a6c9934 in Datetime::Datetime (this=0x7f11f0bcd9e0, thd=0x7f11a0000b00, item=0x7f11a0015578, flags=33554433) at /data/src/10.3/sql/sql_type.h:370
|
#14 0x000055676a6ca58e in Item::val_datetime_packed (this=0x7f11a0015578) at /data/src/10.3/sql/item.h:1521
|
#15 0x000055676ab0b8e7 in Arg_comparator::compare_datetime (this=0x7f11a00415e8) at /data/src/10.3/sql/item_cmpfunc.cc:736
|
#16 0x000055676ab1fef2 in Arg_comparator::compare (this=0x7f11a00415e8) at /data/src/10.3/sql/item_cmpfunc.h:102
|
#17 0x000055676ab0eb2b in Item_func_eq::val_int (this=0x7f11a0041528) at /data/src/10.3/sql/item_cmpfunc.cc:1728
|
#18 0x000055676a8d1990 in SQL_SELECT::skip_record (this=0x7f11a0044130, thd=0x7f11a0000b00) at /data/src/10.3/sql/opt_range.h:1658
|
#19 0x000055676a97cea9 in JOIN_CACHE::check_match (this=0x7f11a0044300, rec_ptr=0x7f11a00ab981 "") at /data/src/10.3/sql/sql_join_cache.cc:2449
|
#20 0x000055676a97896c in JOIN_CACHE::generate_full_extensions (this=0x7f11a0044300, rec_ptr=0x7f11a00ab981 "") at /data/src/10.3/sql/sql_join_cache.cc:2392
|
#21 0x000055676a97874c in JOIN_CACHE::join_matching_records (this=0x7f11a0044300, skip_last=false) at /data/src/10.3/sql/sql_join_cache.cc:2292
|
#22 0x000055676a978118 in JOIN_CACHE::join_records (this=0x7f11a0044300, skip_last=false) at /data/src/10.3/sql/sql_join_cache.cc:2088
|
#23 0x000055676a8440cf in sub_select_cache (join=0x7f11a0019668, join_tab=0x7f11a00460f8, end_of_records=true) at /data/src/10.3/sql/sql_select.cc:19176
|
#24 0x000055676a8442dc in sub_select (join=0x7f11a0019668, join_tab=0x7f11a0045d48, end_of_records=true) at /data/src/10.3/sql/sql_select.cc:19347
|
#25 0x000055676a843aa4 in do_select (join=0x7f11a0019668, procedure=0x0) at /data/src/10.3/sql/sql_select.cc:18938
|
#26 0x000055676a81c607 in JOIN::exec_inner (this=0x7f11a0019668) at /data/src/10.3/sql/sql_select.cc:4040
|
#27 0x000055676a81ba48 in JOIN::exec (this=0x7f11a0019668) at /data/src/10.3/sql/sql_select.cc:3834
|
#28 0x000055676a81cce8 in mysql_select (thd=0x7f11a0000b00, tables=0x7f11a0014f10, wild_num=1, fields=..., conds=0x7f11a00169d0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f11a0019640, unit=0x7f11a00049c8, select_lex=0x7f11a0005138) at /data/src/10.3/sql/sql_select.cc:4239
|
#29 0x000055676a80ec08 in handle_select (thd=0x7f11a0000b00, lex=0x7f11a0004900, result=0x7f11a0019640, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:385
|
#30 0x000055676a7d95ff in execute_sqlcom_select (thd=0x7f11a0000b00, all_tables=0x7f11a0014f10) at /data/src/10.3/sql/sql_parse.cc:6548
|
#31 0x000055676a7cff1e in mysql_execute_command (thd=0x7f11a0000b00) at /data/src/10.3/sql/sql_parse.cc:3821
|
#32 0x000055676a7dd59d in mysql_parse (thd=0x7f11a0000b00, rawbuf=0x7f11a0014ce8 "SELECT * from v WHERE s IN (SELECT f FROM t2)", length=45, parser_state=0x7f11f0bcf5f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8091
|
#33 0x000055676a7ca86c in dispatch_command (command=COM_QUERY, thd=0x7f11a0000b00, packet=0x7f11a01621d1 "", packet_length=45, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1857
|
#34 0x000055676a7c9256 in do_command (thd=0x7f11a0000b00) at /data/src/10.3/sql/sql_parse.cc:1403
|
#35 0x000055676a931eef in do_handle_one_connection (connect=0x55676ed03220) at /data/src/10.3/sql/sql_connect.cc:1402
|
#36 0x000055676a931c73 in handle_one_connection (arg=0x55676ed03220) at /data/src/10.3/sql/sql_connect.cc:1308
|
#37 0x000055676adce589 in pfs_spawn_thread (arg=0x55676ec48140) at /data/src/10.3/storage/perfschema/pfs.cc:1862
|
#38 0x00007f11f9778494 in start_thread (arg=0x7f11f0bd0700) at pthread_create.c:333
|
#39 0x00007f11f794693f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
No obvious effect on a non-debug build.
Attachments
Issue Links
- relates to
-
MDEV-16226 TRX_ID-based System Versioning refactoring
-
- Stalled
-
mysqld: /11.2/sql/field.cc:2305: bool Field_vers_trx_id::get_date(MYSQL_TIME*, date_mode_t, ulonglong): Assertion `table->versioned(VERS_TRX_ID) || (table->versioned() && table->s->table_category == TABLE_CATEGORY_TEMPORARY)' failed.230725 14:01:32 [ERROR] mysqld got signal 6 ;Server version: 11.2.0-MariaDB-debug-log source revision: cb6307f7099ede2016e6a42e440176c290727fa5sql/field.cc:2306(Field_vers_trx_id::get_date(st_mysql_time*, date_mode_t, unsigned long long))[0x556a3dea387e]sql/field.h:2837(Field_vers_trx_id::get_date(st_mysql_time*, date_mode_t))[0x556a3defd54a]sql/item.cc:3395(Item_field::get_date_result(THD*, st_mysql_time*, date_mode_t))[0x556a3dfa2287]sql/item.cc:8576(Item_ref::get_date(THD*, st_mysql_time*, date_mode_t))[0x556a3dfcafb8]sql/sql_type.cc:1010(Temporal_with_date::make_from_item(THD*, Item*, date_mode_t))[0x556a3dcc17be]sql/sql_type.h:2119(Temporal_with_date::Temporal_with_date(THD*, Item*, date_mode_t))[0x556a3d26cd67]sql/sql_type.h:2399(Datetime::Datetime(THD*, Item*, date_mode_t))[0x556a3d26d1d7]sql/item_timefunc.h:1445(Item_func_timestamp::get_date(THD*, st_mysql_time*, date_mode_t))[0x556a3de08bd4]sql/sql_type.cc:1010(Temporal_with_date::make_from_item(THD*, Item*, date_mode_t))[0x556a3dcc17be]sql/sql_type.h:2119(Temporal_with_date::Temporal_with_date(THD*, Item*, date_mode_t))[0x556a3d26cd67]sql/sql_type.h:2399(Datetime::Datetime(THD*, Item*, date_mode_t))[0x556a3d26d1d7]sql/item.h:2052(Item::val_datetime_packed(THD*))[0x556a3d26f9ba]sql/item_cmpfunc.cc:747(Arg_comparator::compare_datetime())[0x556a3dfff183]sql/item_cmpfunc.h:104(Arg_comparator::compare())[0x556a3e042a0a]sql/item_cmpfunc.cc:1820(Item_func_gt::val_int())[0x556a3e00ba91]sql/item.cc:343(Item::val_decimal_from_int(my_decimal*))[0x556a3df872f1]sql/item_func.h:1168(Item_int_func::val_decimal(my_decimal*))[0x556a3d2ff81f]sql/sql_type.cc:301(VDec::VDec(Item*))[0x556a3dcbb286]sql/item_cmpfunc.cc:894(Arg_comparator::compare_e_decimal())[0x556a3e0016d3]sql/item_cmpfunc.h:104(Arg_comparator::compare())[0x556a3e042a0a]sql/item_cmpfunc.cc:1798(Item_func_equal::val_int())[0x556a3e00b857]sql/item.cc:6862(Item::save_int_in_field(Field*, bool))[0x556a3dfbcb73]sql/sql_type.cc:4343(Type_handler_int_result::Item_save_in_field(Item*, Field*, bool) const)[0x556a3dcd2d34]sql/item.cc:6872(Item::save_in_field(Field*, bool))[0x556a3dfbcd57]sql/item.h:3489(Item_result_field::save_in_result_field(bool))[0x556a3d2fdbc0]sql/sql_select.cc:28836(copy_funcs(Item**, THD const*))[0x556a3d7c3db1]sql/sql_select.cc:24966(end_write(JOIN*, st_join_table*, bool))[0x556a3d7a8e22]sql/sql_select.cc:32242(AGGR_OP::put_record(bool))[0x556a3d7ddb3a]sql/sql_select.h:1180(AGGR_OP::put_record())[0x556a3d7f2495]sql/sql_select.cc:23121(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x556a3d79b873]sql/sql_select.cc:23664(evaluate_join_record(JOIN*, st_join_table*, int))[0x556a3d79e4ad]sql/sql_select.cc:32323(AGGR_OP::end_send())[0x556a3d7de21a]sql/sql_select.cc:23115(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x556a3d79b7e1]sql/sql_select.cc:23365(sub_select(JOIN*, st_join_table*, bool))[0x556a3d79c2ad]sql/sql_select.cc:22950(do_select(JOIN*, Procedure*))[0x556a3d79a80e]sql/sql_select.cc:4933(JOIN::exec_inner())[0x556a3d71a7a1]sql/sql_select.cc:4710(JOIN::exec())[0x556a3d717b9a]sql/sql_select.cc:5239(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*))[0x556a3d71c167]sql/sql_select.cc:627(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x556a3d6ec00d]sql/sql_parse.cc:6030(execute_sqlcom_select(THD*, TABLE_LIST*))[0x556a3d613174]sql/sql_parse.cc:3944(mysql_execute_command(THD*, bool))[0x556a3d603d25]sql/sql_parse.cc:7769(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x556a3d61daee]sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x556a3d5f669a]sql/sql_parse.cc:1405(do_command(THD*, bool))[0x556a3d5f338d]sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x556a3dab71b0]sql/sql_connect.cc:1320(handle_one_connection)[0x556a3dab6b06]perfschema/pfs.cc:2203(pfs_spawn_thread)[0x556a3e7a6d61]nptl/pthread_create.c:487(start_thread)[0x7f1a63852fa3]x86_64/clone.S:97(clone)[0x7f1a6345c06f]