v1-0001-Fix-sorting-of-output-rows-in-a-new-isolation-tes.patch
application/octet-stream
Filename: v1-0001-Fix-sorting-of-output-rows-in-a-new-isolation-tes.patch
Type: application/octet-stream
Part: 0
Patch
Format: format-patch
Series: patch v1-0001
Subject: Fix sorting of output rows in a new isolation test introduced in commit 4b760a181ab2
| File | + | − |
|---|---|---|
| src/test/isolation/expected/insert-conflict-do-update-4.out | 4 | 4 |
| src/test/isolation/specs/insert-conflict-do-update-4.spec | 1 | 1 |
From 0d27e1505c1009e2f4ad0c482ab28d83ff4a76d9 Mon Sep 17 00:00:00 2001
From: Pavel Borisov <pashkin.elfe@gmail.com>
Date: Tue, 24 Feb 2026 20:00:48 +0400
Subject: [PATCH v1] Fix sorting of output rows in a new isolation test
introduced in commit 4b760a181ab2
---
.../isolation/expected/insert-conflict-do-update-4.out | 8 ++++----
src/test/isolation/specs/insert-conflict-do-update-4.spec | 2 +-
2 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/src/test/isolation/expected/insert-conflict-do-update-4.out b/src/test/isolation/expected/insert-conflict-do-update-4.out
index 6e96e0d12da..80af2798a94 100644
--- a/src/test/isolation/expected/insert-conflict-do-update-4.out
+++ b/src/test/isolation/expected/insert-conflict-do-update-4.out
@@ -12,11 +12,11 @@ step insert1: INSERT INTO upsert VALUES (1, 11, 111)
step update2a: UPDATE upsert SET i = i + 10 WHERE i = 1;
step c2: COMMIT;
step insert1: <... completed>
-step select1: SELECT * FROM upsert;
+step select1: SELECT * FROM upsert ORDER BY i;
i| j| k
--+--+---
-11|10|100
1|11|111
+11|10|100
(2 rows)
step c1: COMMIT;
@@ -33,7 +33,7 @@ step insert1: INSERT INTO upsert VALUES (1, 11, 111)
step update2b: UPDATE upsert SET i = i + 150 WHERE i = 1;
step c2: COMMIT;
step insert1: <... completed>
-step select1: SELECT * FROM upsert;
+step select1: SELECT * FROM upsert ORDER BY i;
i| j| k
---+--+---
1|11|111
@@ -54,7 +54,7 @@ step insert1: INSERT INTO upsert VALUES (1, 11, 111)
step delete2: DELETE FROM upsert WHERE i = 1;
step c2: COMMIT;
step insert1: <... completed>
-step select1: SELECT * FROM upsert;
+step select1: SELECT * FROM upsert ORDER BY i;
i| j| k
-+--+---
1|11|111
diff --git a/src/test/isolation/specs/insert-conflict-do-update-4.spec b/src/test/isolation/specs/insert-conflict-do-update-4.spec
index 6297b1d1d6c..a62531660d3 100644
--- a/src/test/isolation/specs/insert-conflict-do-update-4.spec
+++ b/src/test/isolation/specs/insert-conflict-do-update-4.spec
@@ -23,7 +23,7 @@ session s1
setup { BEGIN ISOLATION LEVEL READ COMMITTED; }
step insert1 { INSERT INTO upsert VALUES (1, 11, 111)
ON CONFLICT (i) DO UPDATE SET k = EXCLUDED.k; }
-step select1 { SELECT * FROM upsert; }
+step select1 { SELECT * FROM upsert ORDER BY i; }
step c1 { COMMIT; }
session s2
--
2.39.2 (Apple Git-143)