mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +01:00
38 lines
968 B
Text
38 lines
968 B
Text
--- select2.result
|
|
+++ select2,trx_id.reject
|
|
@@ -22,6 +22,8 @@
|
|
delete from t1 where x > 7;
|
|
insert into t1(x, y) values(3, 33);
|
|
select sys_start from t1 where x = 3 and y = 33 into @t1;
|
|
+set @x1= @t1;
|
|
+select trt_commit_ts(@x1) into @t1;
|
|
select x, y from t1;
|
|
x y
|
|
0 100
|
|
@@ -82,7 +84,7 @@
|
|
8 108
|
|
9 109
|
|
3 33
|
|
-select x as ASOF2_x, y from t1 for system_time as of @t0;
|
|
+select x as ASOF2_x, y from t1 for system_time as of transaction @x0;
|
|
ASOF2_x y
|
|
0 100
|
|
1 101
|
|
@@ -94,7 +96,7 @@
|
|
7 107
|
|
8 108
|
|
9 109
|
|
-select x as FROMTO2_x, y from t1 for system_time from '1970-01-01 00:00' to @t1;
|
|
+select x as FROMTO2_x, y from t1 for system_time from transaction @x0 to transaction @x1;
|
|
FROMTO2_x y
|
|
0 100
|
|
1 101
|
|
@@ -106,7 +108,7 @@
|
|
7 107
|
|
8 108
|
|
9 109
|
|
-select x as BETWAND2_x, y from t1 for system_time between '1970-01-01 00:00' and timestamp @t1;
|
|
+select x as BETWAND2_x, y from t1 for system_time between transaction @x0 and transaction @x1;
|
|
BETWAND2_x y
|
|
0 100
|
|
1 101
|