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

Commit44cbba9

Browse files
committed
Adjust EXPLAIN test case to filter out "Actual Rows" values.
Per the buildfarm, these tests appear to be unstable in the wake ofcommitddb17e3. I'm not sure thatjust hiding this output is the right way forward, because I thinkthere may be other test cases that will fail with lower probabilityeven after this fix. However, it's hard to tell right now, becausethis is failing on a number of buildfarm animals. So let's try thisfor now to either get a clearer picture of what else is broken, oras a stopgap until we decide what the permanent fix should be, orperhaps this will be the permanent fix after all.
1 parent98fc31d commit44cbba9

File tree

2 files changed

+6
-2
lines changed

2 files changed

+6
-2
lines changed

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

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -493,6 +493,9 @@ select jsonb_pretty(
493493
-- Also remove its sort-type fields, as those aren't 100% stable
494494
#- '{0,Plan,Plans,0,Sort Method}'
495495
#- '{0,Plan,Plans,0,Sort Space Type}'
496+
-- Actual Rows can be 0 or 0.0 depending on whether loops>1
497+
#- '{0,Plan,Plans,0,Actual Rows}'
498+
#- '{0,Plan,Plans,0,Plans,0,Actual Rows}'
496499
);
497500
jsonb_pretty
498501
-------------------------------------------------------------
@@ -528,7 +531,6 @@ select jsonb_pretty(
528531
"Plan Rows": 0, +
529532
"Plan Width": 0, +
530533
"Total Cost": 0.0, +
531-
"Actual Rows": 0.0, +
532534
"Actual Loops": 0, +
533535
"Startup Cost": 0.0, +
534536
"Async Capable": false, +
@@ -575,7 +577,6 @@ select jsonb_pretty(
575577
"Plan Rows": 0, +
576578
"Plan Width": 0, +
577579
"Total Cost": 0.0, +
578-
"Actual Rows": 0.0, +
579580
"Actual Loops": 0, +
580581
"Startup Cost": 0.0, +
581582
"Async Capable": false, +

‎src/test/regress/sql/explain.sql

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -147,6 +147,9 @@ select jsonb_pretty(
147147
-- Also remove its sort-type fields, as those aren't 100% stable
148148
#- '{0,Plan,Plans,0,Sort Method}'
149149
#- '{0,Plan,Plans,0,Sort Space Type}'
150+
-- Actual Rows can be 0 or 0.0 depending on whether loops>1
151+
#- '{0,Plan,Plans,0,Actual Rows}'
152+
#- '{0,Plan,Plans,0,Plans,0,Actual Rows}'
150153
);
151154

152155
rollback;

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp