diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/sysviews.out | 11 | ||||
| -rw-r--r-- | src/test/regress/sql/sysviews.sql | 5 |
2 files changed, 9 insertions, 7 deletions
diff --git a/src/test/regress/expected/sysviews.out b/src/test/regress/expected/sysviews.out index 442eeb1e3fe..92b48502dd3 100644 --- a/src/test/regress/expected/sysviews.out +++ b/src/test/regress/expected/sysviews.out @@ -48,11 +48,12 @@ select count(*) >= 0 as ok from pg_file_settings; t (1 row) --- There will surely be at least one rule -select count(*) > 0 as ok from pg_hba_file_rules; - ok ----- - t +-- There will surely be at least one rule, with no errors. +select count(*) > 0 as ok, count(*) FILTER (WHERE error IS NOT NULL) = 0 AS no_err + from pg_hba_file_rules; + ok | no_err +----+-------- + t | t (1 row) -- There will surely be at least one active lock diff --git a/src/test/regress/sql/sysviews.sql b/src/test/regress/sql/sysviews.sql index 4980f07be25..77e48ef7ccc 100644 --- a/src/test/regress/sql/sysviews.sql +++ b/src/test/regress/sql/sysviews.sql @@ -25,8 +25,9 @@ select count(*) = 0 as ok from pg_cursors; select count(*) >= 0 as ok from pg_file_settings; --- There will surely be at least one rule -select count(*) > 0 as ok from pg_hba_file_rules; +-- There will surely be at least one rule, with no errors. +select count(*) > 0 as ok, count(*) FILTER (WHERE error IS NOT NULL) = 0 AS no_err + from pg_hba_file_rules; -- There will surely be at least one active lock select count(*) > 0 as ok from pg_locks; |