Debian Codegraph @

mysql-test/suite/versioning/r/select2,trx_id.rdiff

raw
1 --- select2.result
2 +++ select2,trx_id.reject
3 @@ -22,6 +22,8 @@
4 delete from t1 where x > 7;
5 insert into t1(x, y) values(3, 33);
6 select sys_start from t1 where x = 3 and y = 33 into @t1;
7 +set @x1= @t1;
8 +select trt_commit_ts(@x1) into @t1;
9 select x, y from t1;
10 x y
11 0 100
12 @@ -82,7 +84,7 @@
13 8 108
14 9 109
15 3 33
16 -select x as ASOF2_x, y from t1 for system_time as of @t0;
17 +select x as ASOF2_x, y from t1 for system_time as of transaction @x0;
18 ASOF2_x y
19 0 100
20 1 101
21 @@ -94,7 +96,7 @@
22 7 107
23 8 108
24 9 109
25 -select x as FROMTO2_x, y from t1 for system_time from '1970-01-01 00:00' to @t1;
26 +select x as FROMTO2_x, y from t1 for system_time from transaction @x0 to transaction @x1;
27 FROMTO2_x y
28 0 100
29 1 101
30 @@ -106,7 +108,7 @@
31 7 107
32 8 108
33 9 109
34 -select x as BETWAND2_x, y from t1 for system_time between '1970-01-01 00:00' and timestamp @t1;
35 +select x as BETWAND2_x, y from t1 for system_time between transaction @x0 and transaction @x1;
36 BETWAND2_x y
37 0 100
38 1 101