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