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

Commit62a5b52

Browse files
committed
[PGPRO-6745] Added lo_unlink for some ATX tests
1 parent3d6313f commit62a5b52

File tree

1 file changed

+22
-9
lines changed

1 file changed

+22
-9
lines changed

‎expected/regression_ee.diff‎

Lines changed: 22 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -590,23 +590,36 @@ diff ../../../src/test/regress/expected/rowsecurity.out ../tmp_check/regress_out
590590
diff ../../../src/test/regress/expected/atx.out ../tmp_check/regress_outdir/results/atx.out
591591
--- ../../../src/test/regress/expected/atx.outCENSORED
592592
+++ ../tmp_check/regress_outdir/results/atx.outCENSORED
593-
@@ -851,6 +851,7 @@
593+
@@ -816,11 +816,7 @@
594+
(1 row)
595+
596+
select lo_unlink(:my_loid);
597+
- lo_unlink
598+
------------
599+
- 1
600+
-(1 row)
601+
-
602+
+ERROR: [MTM] failed to prepare transaction at peer node
603+
--
604+
DO $body$
605+
begin
606+
@@ -857,6 +853,7 @@
594607
declare c2 cursor with hold for select count_tt1_v(), count_tt1_s();
595608
insert into atx_tt1 values(2);
596609
commit;
597610
+ERROR: cannot PREPARE a transaction that has created a cursor WITH HOLD
598611
commit;
599612
begin;
600613
begin autonomous;
601-
@@ -866,6 +867,7 @@
614+
@@ -872,6 +869,7 @@
602615
drop function count_tt1_s();
603616
drop table if exists atx_tt1;
604617
close c2;
605618
+ERROR: cursor "c2" does not exist
606-
-- 13
619+
--
607620
create table atx_13_t(i int);
608621
begin;
609-
@@ -985,9 +987,7 @@
622+
@@ -991,9 +989,7 @@
610623
insert into atx_tt2 values(1);
611624
declare c2 cursor with hold for select error_function();
612625
commit;
@@ -617,7 +630,7 @@ diff ../../../src/test/regress/expected/atx.out ../tmp_check/regress_outdir/resu
617630
commit;
618631
drop function if exists error_function();
619632
drop table if exists atx_tt2;
620-
@@ -1077,6 +1077,7 @@
633+
@@ -1083,6 +1079,7 @@
621634
RESET client_min_messages;
622635
create database regression_atx_test_database;
623636
ALTER DATABASE "regression_atx_test_database" SET lc_messages TO 'C';
@@ -628,7 +641,7 @@ diff ../../../src/test/regress/expected/atx.out ../tmp_check/regress_outdir/resu
628641
diff ../../../src/test/regress/expected/atx5.out ../tmp_check/regress_outdir/results/atx5.out
629642
--- ../../../src/test/regress/expected/atx5.outCENSORED
630643
+++ ../tmp_check/regress_outdir/results/atx5.outCENSORED
631-
@@ -24,10 +24,7 @@
644+
@@ -23,10 +23,7 @@
632645
NOTICE: function atx_test_30_one() does not exist, skipping
633646
NOTICE: function atx_test_30_one() does not exist, skipping
634647
NOTICE: function atx_test_30_one() does not exist, skipping
@@ -643,7 +656,7 @@ diff ../../../src/test/regress/expected/atx5.out ../tmp_check/regress_outdir/res
643656
diff ../../../src/test/regress/expected/atx9.out ../tmp_check/regress_outdir/results/atx9.out
644657
--- ../../../src/test/regress/expected/atx9.outCENSORED
645658
+++ ../tmp_check/regress_outdir/results/atx9.outCENSORED
646-
@@ -29,50 +29,38 @@
659+
@@ -28,50 +28,38 @@
647660
INSERT INTO abc VALUES (1);
648661
INSERT INTO abc VALUES (2);
649662
COMMIT AND CHAIN; -- TBLOCK_END
@@ -703,7 +716,7 @@ diff ../../../src/test/regress/expected/atx9.out ../tmp_check/regress_outdir/res
703716
COMMIT;
704717
ROLLBACK;
705718
BEGIN;
706-
@@ -144,24 +132,13 @@
719+
@@ -143,24 +131,13 @@
707720

708721
SAVEPOINT x;
709722
COMMIT AND CHAIN; -- TBLOCK_SUBCOMMIT
@@ -732,7 +745,7 @@ diff ../../../src/test/regress/expected/atx9.out ../tmp_check/regress_outdir/res
732745
COMMIT;
733746
ROLLBACK;
734747
-- different mix of options just for fun
735-
@@ -232,17 +209,14 @@
748+
@@ -231,17 +208,14 @@
736749
COMMIT;
737750
-- not allowed outside a transaction block
738751
COMMIT AUTONOMOUS AND CHAIN; -- error

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp