Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3.6
-
None
Description
Reproduce
create or replace table t1 ( |
x int(11) default null, |
row_start bigint(20) unsigned generated always as row start invisible, |
row_end bigint(20) unsigned generated always as row end invisible, |
period for system_time (row_start, row_end) |
) engine=innodb with system versioning; |
|
begin; |
set @ts1= now(6); |
select sleep(1); |
insert into t1 values (1); |
commit; |
|
select row_start from t1 into @trx_id; |
select trt_begin_ts(@trx_id) <= @ts1; |
Result
trt_begin_ts(@trx_id) is time of last executed statement (commit).
Expected
trt_begin_ts(@trx_id) is time of begin statement.
Attachments
Issue Links
- relates to
-
MDEV-15963 mysql.transaction_registry is not documented in KB
- Closed