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
-
Activity
Transition | Time In Source Status | Execution Times |
---|
|
5m 56s | 1 |
|
5h 47m | 1 |
|
13d 15h 5m | 1 |
|
2d 20h 28m | 1 |