--source include/have_innodb.inc

CREATE TABLE sv_t (x INT,start_trxid BIGINT UNSIGNED GENERATED ALWAYS AS ROW START,end_trxid BIGINT UNSIGNED GENERATED ALWAYS AS ROW END,PERIOD FOR SYSTEM_TIME(start_trxid,end_trxid)) ENGINE=INNODB WITH SYSTEM VERSIONING;

CREATE OR REPLACE TABLE mysql.transaction_registry (id INT);

XA START 'a';

INSERT INTO sv_t (x) VALUES(1);

SELECT * FROM sv_t FOR SYSTEM_TIME FROM  (NOW() - INTERVAL 1 MINUTE) TO NOW();

Core was generated by `/test/MD170225-mariadb-11.8.1-linux-x86_64-opt/bin/mariadbd --no-defaults --max'.

Program terminated with signal SIGSEGV, Segmentation fault.

#0  Item_field::Item_field (this=0x1534a801cda8, thd=0x1534a8000c68, context_arg=0x1534a80175f0, f=0x1534a8064741)at /test/11.8_opt/sql/item.cc:3230

[Current thread is 1 (Thread 0x153505fc36c0 (LWP 3061186))]

(gdb) bt

#0  Item_field::Item_field (this=0x1534a801cda8, thd=0x1534a8000c68, context_arg=0x1534a80175f0, f=0x1534a8064741)at /test/11.8_opt/sql/item.cc:3230

#1  0x0000561c6b0ddb68 in TR_table::query (this=0x153505fc0498, commit_time=@0x153505fc0470: {year = 2000, month = 9, day = 8, hour = 0, minute = 0, second = 0, second_part = 0, neg = 0 '\000', time_type = MYSQL_TIMESTAMP_DATETIME}, backwards=false) at /test/11.8_opt/sql/table.cc:10636

#2  0x0000561c6b1bb9f9 in Item_func_trt_id::get_by_commit_ts (this=0x1534a8019728, commit_ts=@0x153505fc0470: {year = 2000, month = 9, day = 8, hour = 0, minute = 0, second = 0, second_part = 0, neg = 0 '\000', time_type = MYSQL_TIMESTAMP_DATETIME}, backwards=<optimized out>) at /test/11.8_opt/sql/item_vers.cc:136

#3  Item_func_trt_id::val_int (this=0x1534a8019728)at /test/11.8_opt/sql/item_vers.cc:170

#4  0x0000561c6b277426 in Item_cache_int::cache_value (this=0x1534a801c200)at /test/11.8_opt/sql/item.cc:10562

#5  0x0000561c6b2775be in Item_cache::has_value (this=0x1534a801c200)at /test/11.8_opt/sql/item.h:7530

#6  Item_cache_int::val_int (this=0x1534a801c200)at /test/11.8_opt/sql/item.cc:10595

#7  0x0000561c6b1bbbbc in Item::val_uint (this=0x1534a801cda8)at /test/11.8_opt/sql/item.h:1523

#8  Item_func_trt_trx_sees::val_bool (this=0x1534a80197e0)at /test/11.8_opt/sql/item_vers.cc:189

#9  0x0000561c6b294068 in Item_cond_and::val_bool (this=0x1534a801c3a8)at /test/11.8_opt/sql/item_cmpfunc.cc:5702

#10 0x0000561c6b04eac3 in evaluate_join_record (join=join@entry=0x1534a8018c68, join_tab=join_tab@entry=0x1534a801b238, error=<optimized out>) at /test/11.8_opt/sql/sql_select.cc:24287

#11 0x0000561c6b017a3b in sub_select (join=0x1534a8018c68, join_tab=0x1534a801b238, end_of_records=<optimized out>)at /test/11.8_opt/sql/sql_select.cc:24186

#12 0x0000561c6b032ce3 in do_select (join=join@entry=0x1534a8018c68, procedure=<optimized out>) at /test/11.8_opt/sql/sql_select.cc:23697

#13 0x0000561c6b0325f2 in JOIN::exec_inner (this=this@entry=0x1534a8018c68)at /test/11.8_opt/sql/sql_select.cc:5059

#14 0x0000561c6b018297 in JOIN::exec (this=0x1534a8018c68)at /test/11.8_opt/sql/sql_select.cc:4842

#15 mysql_select (thd=thd@entry=0x1534a8000c68, tables=<optimized out>, fields=@0x1534a8017860: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x1534a8017b98, last = 0x1534a8017b98, elements = 1}, <No data fields>}, conds=<optimized out>, og_num=<optimized out>, order=<optimized out>, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x1534a8018c40, unit=0x1534a8004fc0, select_lex=0x1534a80175a8)at /test/11.8_opt/sql/sql_select.cc:5375

#16 0x0000561c6b017f19 in handle_select (thd=thd@entry=0x1534a8000c68, lex=lex@entry=0x1534a8004ee0, result=result@entry=0x1534a8018c40, setup_tables_done_option=setup_tables_done_option@entry=0)at /test/11.8_opt/sql/sql_select.cc:633

#17 0x0000561c6afe550e in execute_sqlcom_select (thd=thd@entry=0x1534a8000c68, all_tables=0x1534a8017be8) at /test/11.8_opt/sql/sql_parse.cc:6191

#18 0x0000561c6afe3a00 in mysql_execute_command (thd=thd@entry=0x1534a8000c68, is_called_from_prepared_stmt=false) at /test/11.8_opt/sql/sql_parse.cc:3979

#19 0x0000561c6afdc261 in mysql_parse (thd=thd@entry=0x1534a8000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x153505fc2430)at /test/11.8_opt/sql/sql_parse.cc:7915

#20 0x0000561c6afda6f0 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x1534a8000c68, packet=packet@entry=0x1534a80088a9 "", packet_length=packet_length@entry=15, blocking=true)at /test/11.8_opt/sql/sql_parse.cc:1902

#21 0x0000561c6afdc671 in do_command (thd=thd@entry=0x1534a8000c68, blocking=true) at /test/11.8_opt/sql/sql_parse.cc:1415

#22 0x0000561c6b107e8d in do_handle_one_connection (connect=<optimized out>, connect@entry=0x561caa284c38, put_in_cache=true)at /test/11.8_opt/sql/sql_connect.cc:1415

#23 0x0000561c6b107c4f in handle_one_connection (arg=arg@entry=0x561caa284c38)at /test/11.8_opt/sql/sql_connect.cc:1327

#24 0x0000561c6b48cd29 in pfs_spawn_thread (arg=0x561caa231528)at /test/11.8_opt/storage/perfschema/pfs.cc:2198

#25 0x000015350b89caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447

#26 0x000015350b929c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78