v20241119-2-0022-set-verbosity-mode-in-regress-tests.patch

text/x-patch

Filename: v20241119-2-0022-set-verbosity-mode-in-regress-tests.patch

Type: text/x-patch

Part: 2

Patch

Same data as JSON: GET /api/v1/attachments/:id/patch the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes. API reference →

Format: format-patch

Series: patch v20241119-0022

Subject: set verbosity mode in regress tests

File	+	−
src/test/regress/expected/session_variables.out	2	0
src/test/regress/sql/session_variables.sql	2	0

From a68fd2eee6823a9e5abd39f29876d67a2f4b8ae1 Mon Sep 17 00:00:00 2001
From: "okbob@github.com" <pavel.stehule@gmail.com>
Date: Tue, 19 Nov 2024 22:27:32 +0100
Subject: [PATCH 22/22] set verbosity mode in regress tests

---
 src/test/regress/expected/session_variables.out | 2 ++
 src/test/regress/sql/session_variables.sql      | 2 ++
 2 files changed, 4 insertions(+)

diff --git a/src/test/regress/expected/session_variables.out b/src/test/regress/expected/session_variables.out
index 66f1959a329..03ef5635f9c 100644
--- a/src/test/regress/expected/session_variables.out
+++ b/src/test/regress/expected/session_variables.out
@@ -1889,12 +1889,14 @@ DETAIL:  Session variables can be shadowed by columns, routine's variables and r
 (1 row)
 
 -- no warning
+\set VERBOSITY verbose
 SELECT variable(a) FROM test_table;
  a  
 ----
  10
 (1 row)
 
+\set VERBOSITY default
 ALTER TABLE test_table DROP COLUMN a;
 -- warning - variable fence is not used
 SELECT a, b FROM test_table;
diff --git a/src/test/regress/sql/session_variables.sql b/src/test/regress/sql/session_variables.sql
index 45510e2ea54..8089eae79b9 100644
--- a/src/test/regress/sql/session_variables.sql
+++ b/src/test/regress/sql/session_variables.sql
@@ -1285,7 +1285,9 @@ SELECT a;
 SELECT a, b FROM test_table;
 
 -- no warning
+\set VERBOSITY verbose
 SELECT variable(a) FROM test_table;
+\set VERBOSITY default
 
 ALTER TABLE test_table DROP COLUMN a;
 
-- 
2.47.0