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

Commit9fa1aaa

Browse files
committed
Add missing BUFFERS OFF in select_into regression tests
c2a4078 adjusted EXPLAIN ANALYZE to include BUFFERS by default, buta few tests in select_into.sql neglected to add BUFFERS OFF. Thefailing tests seem unlikely to ever access buffers during execution, butthey certainly could during planning.Per buildfarm member kestrel, tayra and calliphoridae.Discussion:https://postgr.es/m/CANNMO++W7MM8T0KyXN3ZheXXt-uLVM3aEtZd+WNfZ=obxffUiA@mail.gmail.com
1 parentc2a4078 commit9fa1aaa

File tree

2 files changed

+4
-4
lines changed

2 files changed

+4
-4
lines changed

‎src/test/regress/expected/select_into.out

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -37,7 +37,7 @@ EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF, BUFFERS OFF)
3737
-- WITH NO DATA, passes.
3838
CREATE TABLE selinto_schema.tbl_nodata1 (a) AS
3939
SELECT generate_series(1,3) WITH NO DATA;
40-
EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
40+
EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF, BUFFERS OFF)
4141
CREATE TABLE selinto_schema.tbl_nodata2 (a) AS
4242
SELECT generate_series(1,3) WITH NO DATA;
4343
QUERY PLAN
@@ -50,7 +50,7 @@ EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
5050
PREPARE data_sel AS SELECT generate_series(1,3);
5151
CREATE TABLE selinto_schema.tbl_withdata3 (a) AS
5252
EXECUTE data_sel WITH DATA;
53-
EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
53+
EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF, BUFFERS OFF)
5454
CREATE TABLE selinto_schema.tbl_withdata4 (a) AS
5555
EXECUTE data_sel WITH DATA;
5656
QUERY PLAN

‎src/test/regress/sql/select_into.sql

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -36,14 +36,14 @@ EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF, BUFFERS OFF)
3636
-- WITH NO DATA, passes.
3737
CREATETABLEselinto_schema.tbl_nodata1 (a)AS
3838
SELECT generate_series(1,3) WITH NO DATA;
39-
EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
39+
EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF, BUFFERS OFF)
4040
CREATETABLEselinto_schema.tbl_nodata2 (a)AS
4141
SELECT generate_series(1,3) WITH NO DATA;
4242
-- EXECUTE and WITH DATA, passes.
4343
PREPARE data_selASSELECT generate_series(1,3);
4444
CREATETABLEselinto_schema.tbl_withdata3 (a)AS
4545
EXECUTE data_sel WITH DATA;
46-
EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF)
46+
EXPLAIN (ANALYZE, COSTS OFF, SUMMARY OFF, TIMING OFF, BUFFERS OFF)
4747
CREATETABLEselinto_schema.tbl_withdata4 (a)AS
4848
EXECUTE data_sel WITH DATA;
4949
-- EXECUTE and WITH NO DATA, passes.

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp