From 30e2b286d5fc34354d24441327bb1f45e4ca8eb9 Mon Sep 17 00:00:00 2001 From: Tatsuo Ishii Date: Thu, 5 Dec 2024 18:04:44 +0900 Subject: [PATCH] Test: fix 006.memqcache regression test. 4dd7371c2 added test cases. SQL syntax used in the test was not compatible with PostgreSQL 15 or earlier. Backpatch-through: v4.2 --- src/test/regression/tests/006.memqcache/expected.3 | 4 ++-- src/test/regression/tests/006.memqcache/query_cache_bug3.data | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/src/test/regression/tests/006.memqcache/expected.3 b/src/test/regression/tests/006.memqcache/expected.3 index 05abf7833..79d556208 100644 --- a/src/test/regression/tests/006.memqcache/expected.3 +++ b/src/test/regression/tests/006.memqcache/expected.3 @@ -1,4 +1,4 @@ -FE=> Parse(stmt="S0", query="SELECT * FROM (VALUES(1),(2))") +FE=> Parse(stmt="S0", query="SELECT * FROM (VALUES(1),(2)) foo") FE=> Bind(stmt="S0", portal="P0") FE=> Describe(portal="P0") FE=> Execute(portal="P0") @@ -10,7 +10,7 @@ FE=> Sync <= BE DataRow <= BE CommandComplete(SELECT 2) <= BE ReadyForQuery(I) -FE=> Parse(stmt="S1", query="SELECT * FROM (VALUES(1),(2),(3))") +FE=> Parse(stmt="S1", query="SELECT * FROM (VALUES(1),(2),(3)) foo") FE=> Bind(stmt="S1", portal="P1") FE=> Describe(portal="P1") FE=> Execute(portal="P1") diff --git a/src/test/regression/tests/006.memqcache/query_cache_bug3.data b/src/test/regression/tests/006.memqcache/query_cache_bug3.data index 790f21a3d..5d61f4835 100644 --- a/src/test/regression/tests/006.memqcache/query_cache_bug3.data +++ b/src/test/regression/tests/006.memqcache/query_cache_bug3.data @@ -1,13 +1,13 @@ # Portal suspended test -'P' "S0" "SELECT * FROM (VALUES(1),(2))" 0 +'P' "S0" "SELECT * FROM (VALUES(1),(2)) foo" 0 'B' "P0" "S0" 0 0 0 'D' 'P' "P0" 'E' "P0" 0 'S' 'Y' -'P' "S1" "SELECT * FROM (VALUES(1),(2),(3))" 0 +'P' "S1" "SELECT * FROM (VALUES(1),(2),(3)) foo" 0 'B' "P1" "S1" 0 0 0 'D' 'P' "P1" 'E' "P1" 1 -- 2.39.5