Thread

[PATCH 3/3] FIXUP 0009-regress-tests-for-session-variables

Julien Rouhaud <julien.rouhaud@free.fr> — 2022-09-03T08:09:41Z

---
 src/test/isolation/specs/session-variable.spec  | 2 +-
 src/test/regress/expected/session_variables.out | 5 +++++
 src/test/regress/sql/session_variables.sql      | 6 ++++++
 3 files changed, 12 insertions(+), 1 deletion(-)

diff --git a/src/test/isolation/specs/session-variable.spec b/src/test/isolation/specs/session-variable.spec
index a138f0449e..fe47339110 100644
--- a/src/test/isolation/specs/session-variable.spec
+++ b/src/test/isolation/specs/session-variable.spec
@@ -1,4 +1,4 @@
-#
+# Test session variables memory cleanup for sinval
 
 setup
 {
diff --git a/src/test/regress/expected/session_variables.out b/src/test/regress/expected/session_variables.out
index 5e1e8c5dd0..99e433a762 100644
--- a/src/test/regress/expected/session_variables.out
+++ b/src/test/regress/expected/session_variables.out
@@ -531,6 +531,11 @@ EXPLAIN (costs off) LET zero = (SELECT count(*) FROM svar_test);
                        ->  Parallel Seq Scan on svar_test
 (8 rows)
 
+-- test for dependency on relation
+CREATE VARIABLE v_table AS svar_test;
+ALTER TABLE svar_test ALTER COLUMN a TYPE text;
+ERROR:  cannot alter table "svar_test" because session variable "svartest.v_table" uses it
+DROP VARIABLE v_table;
 DROP TABLE svar_test;
 DROP VARIABLE zero;
 RESET parallel_setup_cost;
diff --git a/src/test/regress/sql/session_variables.sql b/src/test/regress/sql/session_variables.sql
index 23d0ae716c..d05c28d3eb 100644
--- a/src/test/regress/sql/session_variables.sql
+++ b/src/test/regress/sql/session_variables.sql
@@ -356,6 +356,12 @@ SELECT zero;
 -- parallel workers should be used
 EXPLAIN (costs off) LET zero = (SELECT count(*) FROM svar_test);
 
+-- test for dependency on relation
+CREATE VARIABLE v_table AS svar_test;
+
+ALTER TABLE svar_test ALTER COLUMN a TYPE text;
+
+DROP VARIABLE v_table;
 DROP TABLE svar_test;
 DROP VARIABLE zero;
 
-- 
2.37.0


--vuzhuyepzhyurc52--