EVOLUTION-MANAGER

Edit File: select2,trx_id.rdiff

--- select2.result +++ select2,trx_id.result~ @@ -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 @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 '0-0-0 0:0:0' to @t1; +select x as FROMTO2_x, y from t1 for system_time from @x0 to @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 timestamp '0-0-0 0:0:0' 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