diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/misc_functions.out | 25 | ||||
| -rw-r--r-- | src/test/regress/sql/misc_functions.sql | 6 |
2 files changed, 31 insertions, 0 deletions
diff --git a/src/test/regress/expected/misc_functions.out b/src/test/regress/expected/misc_functions.out index 9f106c2a108..88bb696ded8 100644 --- a/src/test/regress/expected/misc_functions.out +++ b/src/test/regress/expected/misc_functions.out @@ -594,3 +594,28 @@ SELECT * FROM tenk1 a JOIN my_gen_series(1,10) g ON a.unique1 = g; Index Cond: (unique1 = g.g) (4 rows) +-- Test functions for control data +SELECT count(*) > 0 AS ok FROM pg_control_checkpoint(); + ok +---- + t +(1 row) + +SELECT count(*) > 0 AS ok FROM pg_control_init(); + ok +---- + t +(1 row) + +SELECT count(*) > 0 AS ok FROM pg_control_recovery(); + ok +---- + t +(1 row) + +SELECT count(*) > 0 AS ok FROM pg_control_system(); + ok +---- + t +(1 row) + diff --git a/src/test/regress/sql/misc_functions.sql b/src/test/regress/sql/misc_functions.sql index 639e9b352cf..b07e9e8dbb3 100644 --- a/src/test/regress/sql/misc_functions.sql +++ b/src/test/regress/sql/misc_functions.sql @@ -223,3 +223,9 @@ SELECT * FROM tenk1 a JOIN my_gen_series(1,1000) g ON a.unique1 = g; EXPLAIN (COSTS OFF) SELECT * FROM tenk1 a JOIN my_gen_series(1,10) g ON a.unique1 = g; + +-- Test functions for control data +SELECT count(*) > 0 AS ok FROM pg_control_checkpoint(); +SELECT count(*) > 0 AS ok FROM pg_control_init(); +SELECT count(*) > 0 AS ok FROM pg_control_recovery(); +SELECT count(*) > 0 AS ok FROM pg_control_system(); |