From 4871a30d77ae1436eb8ec816fe4f0a21091b0b84 Mon Sep 17 00:00:00 2001
From: Tatsuo Ishii <ishii@postgresql.org>
Date: Wed, 23 Oct 2024 15:29:17 +0900
Subject: [PATCH] Test: add test cases for new "PGPOOL SET CACHE DELETE".

---
 .../regression/tests/006.memqcache/expected.n | 30 +++++++++++++++++
 .../regression/tests/006.memqcache/expected.r | 32 +++++++++++++++++++
 .../regression/tests/006.memqcache/expected.s | 30 +++++++++++++++++
 .../regression/tests/006.memqcache/test.sh    | 13 ++++++++
 4 files changed, 105 insertions(+)

diff --git a/src/test/regression/tests/006.memqcache/expected.n b/src/test/regression/tests/006.memqcache/expected.n
index df85bcee9..962dac4ea 100644
--- a/src/test/regression/tests/006.memqcache/expected.n
+++ b/src/test/regression/tests/006.memqcache/expected.n
@@ -596,3 +596,33 @@ SELECT 10;
        10
 (1 row)
 
+--
+-- PGPOOL SET CACHE DELETE test cases.
+--
+-- force to create cache
+/*FORCE QUERY CACHE*/SELECT 1;
+NOTICE:  DB node id: 0 statement: /*FORCE QUERY CACHE*/SELECT 1;
+ ?column? 
+----------
+        1
+(1 row)
+
+-- make sure the cache was created
+/*FORCE QUERY CACHE*/SELECT 1;
+ ?column? 
+----------
+        1
+(1 row)
+
+-- delete the cache
+PGPOOL SET CACHE DELETE '/*FORCE QUERY CACHE*/SELECT 1;';
+NOTICE:  query cache deleted. query: "/*FORCE QUERY CACHE*/SELECT 1;"
+SET
+-- make sure the cache was deleted
+/*FORCE QUERY CACHE*/SELECT 1;
+NOTICE:  DB node id: 0 statement: /*FORCE QUERY CACHE*/SELECT 1;
+ ?column? 
+----------
+        1
+(1 row)
+
diff --git a/src/test/regression/tests/006.memqcache/expected.r b/src/test/regression/tests/006.memqcache/expected.r
index ebf84694c..33a0aedbc 100644
--- a/src/test/regression/tests/006.memqcache/expected.r
+++ b/src/test/regression/tests/006.memqcache/expected.r
@@ -656,3 +656,35 @@ SELECT 10;
        10
 (1 row)
 
+--
+-- PGPOOL SET CACHE DELETE test cases.
+--
+-- force to create cache
+/*FORCE QUERY CACHE*/SELECT 1;
+NOTICE:  DB node id: 0 statement: /*FORCE QUERY CACHE*/SELECT 1;
+NOTICE:  DB node id: 1 statement: /*FORCE QUERY CACHE*/SELECT 1;
+ ?column? 
+----------
+        1
+(1 row)
+
+-- make sure the cache was created
+/*FORCE QUERY CACHE*/SELECT 1;
+ ?column? 
+----------
+        1
+(1 row)
+
+-- delete the cache
+PGPOOL SET CACHE DELETE '/*FORCE QUERY CACHE*/SELECT 1;';
+NOTICE:  query cache deleted. query: "/*FORCE QUERY CACHE*/SELECT 1;"
+SET
+-- make sure the cache was deleted
+/*FORCE QUERY CACHE*/SELECT 1;
+NOTICE:  DB node id: 0 statement: /*FORCE QUERY CACHE*/SELECT 1;
+NOTICE:  DB node id: 1 statement: /*FORCE QUERY CACHE*/SELECT 1;
+ ?column? 
+----------
+        1
+(1 row)
+
diff --git a/src/test/regression/tests/006.memqcache/expected.s b/src/test/regression/tests/006.memqcache/expected.s
index df85bcee9..962dac4ea 100644
--- a/src/test/regression/tests/006.memqcache/expected.s
+++ b/src/test/regression/tests/006.memqcache/expected.s
@@ -596,3 +596,33 @@ SELECT 10;
        10
 (1 row)
 
+--
+-- PGPOOL SET CACHE DELETE test cases.
+--
+-- force to create cache
+/*FORCE QUERY CACHE*/SELECT 1;
+NOTICE:  DB node id: 0 statement: /*FORCE QUERY CACHE*/SELECT 1;
+ ?column? 
+----------
+        1
+(1 row)
+
+-- make sure the cache was created
+/*FORCE QUERY CACHE*/SELECT 1;
+ ?column? 
+----------
+        1
+(1 row)
+
+-- delete the cache
+PGPOOL SET CACHE DELETE '/*FORCE QUERY CACHE*/SELECT 1;';
+NOTICE:  query cache deleted. query: "/*FORCE QUERY CACHE*/SELECT 1;"
+SET
+-- make sure the cache was deleted
+/*FORCE QUERY CACHE*/SELECT 1;
+NOTICE:  DB node id: 0 statement: /*FORCE QUERY CACHE*/SELECT 1;
+ ?column? 
+----------
+        1
+(1 row)
+
diff --git a/src/test/regression/tests/006.memqcache/test.sh b/src/test/regression/tests/006.memqcache/test.sh
index 00eb1dfe3..fa9f4b15e 100755
--- a/src/test/regression/tests/006.memqcache/test.sh
+++ b/src/test/regression/tests/006.memqcache/test.sh
@@ -458,6 +458,19 @@ ALTER ROLE foo WITH CONNECTION LIMIT 10;
 SELECT 10;
 EOF
 
+		$PSQL -a test >> result 2>&1 <<EOF
+--
+-- PGPOOL SET CACHE DELETE test cases.
+--
+-- force to create cache
+/*FORCE QUERY CACHE*/SELECT 1;
+-- make sure the cache was created
+/*FORCE QUERY CACHE*/SELECT 1;
+-- delete the cache
+PGPOOL SET CACHE DELETE '/*FORCE QUERY CACHE*/SELECT 1;';
+-- make sure the cache was deleted
+/*FORCE QUERY CACHE*/SELECT 1;
+EOF
 	./shutdownall
 
 	cd ..
-- 
2.39.5