From 8ecee2a42f77698898eaeeca0a0c269332275e55 Mon Sep 17 00:00:00 2001 From: Julien Rouhaud Date: Sat, 3 Sep 2022 16:09:41 +0800 Subject: [PATCH 3/3] FIXUP 0009-regress-tests-for-session-variables --- 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