Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commita6948c3

Browse files
CherkashinSergeyza-arthur
authored andcommitted
Add test
1 parent745ea14 commita6948c3

File tree

2 files changed

+25
-0
lines changed

2 files changed

+25
-0
lines changed

‎expected/pg_variables_trans.out

Lines changed: 19 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -2005,6 +2005,25 @@ SELECT package FROM pgv_stats() ORDER BY package;
20052005
---------
20062006
(0 rows)
20072007

2008+
SELECT pgv_set('vars', 'any1', 'some value'::text);
2009+
pgv_set
2010+
---------
2011+
2012+
(1 row)
2013+
2014+
BEGIN;
2015+
SELECT pgv_remove('vars');
2016+
pgv_remove
2017+
------------
2018+
2019+
(1 row)
2020+
2021+
ROLLBACK;
2022+
SELECT package FROM pgv_stats() ORDER BY package;
2023+
package
2024+
---------
2025+
(0 rows)
2026+
20082027
SELECT pgv_free();
20092028
pgv_free
20102029
----------

‎sql/pg_variables_trans.sql

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -525,4 +525,10 @@ SELECT package FROM pgv_stats() ORDER BY package;
525525
COMMIT;
526526
SELECT packageFROM pgv_stats()ORDER BY package;
527527

528+
SELECT pgv_set('vars','any1','some value'::text);
529+
BEGIN;
530+
SELECT pgv_remove('vars');
531+
ROLLBACK;
532+
SELECT packageFROM pgv_stats()ORDER BY package;
533+
528534
SELECT pgv_free();

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp