mariadb/mysql-test/suite/versioning/r/update,trx_id.rdiff
2023-08-09 07:53:48 +02:00

24 lines
582 B
Text

--- update.result 2023-08-08 21:02:56.126291112 +0200
+++ update,trx_id.reject 2023-08-09 07:38:38.369422625 +0200
@@ -84,12 +84,10 @@
commit;
select x, y, sys_trx_end = MAXVAL as current from t1 for system_time all order by sys_trx_end, x, y;
x y current
-3 1 0
2 1 0
-3 2 0
+3 1 0
4 1 0
5 1 0
-5 2 0
1 1 1
2 2 1
3 3 1
@@ -478,7 +476,6 @@
select nid, nstate, check_row(row_start, row_end) from t1 for system_time all order by row_start, row_end;
nid nstate check_row(row_start, row_end)
1 1 HISTORICAL ROW
-1 1 HISTORICAL ROW
1 3 CURRENT ROW
commit;
drop tables t1;