diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/misc_functions.out | 23 | ||||
| -rw-r--r-- | src/test/regress/sql/misc_functions.sql | 8 |
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 88bb696ded8..2907f779a75 100644 --- a/src/test/regress/expected/misc_functions.out +++ b/src/test/regress/expected/misc_functions.out @@ -619,3 +619,26 @@ SELECT count(*) > 0 AS ok FROM pg_control_system(); t (1 row) +-- pg_dissect_walfile_name +SELECT * FROM pg_dissect_walfile_name(NULL); + segno | timeline_id +-------+------------- + | +(1 row) + +SELECT * FROM pg_dissect_walfile_name('invalid'); +ERROR: invalid WAL file name "invalid" +SELECT segno > 0 AS ok_segno, timeline_id + FROM pg_dissect_walfile_name('000000010000000100000000'); + ok_segno | timeline_id +----------+------------- + t | 1 +(1 row) + +SELECT segno > 0 AS ok_segno, timeline_id + FROM pg_dissect_walfile_name('ffffffFF00000001000000af'); + ok_segno | timeline_id +----------+------------- + t | 4294967295 +(1 row) + diff --git a/src/test/regress/sql/misc_functions.sql b/src/test/regress/sql/misc_functions.sql index b07e9e8dbb3..0c3d75fd1ac 100644 --- a/src/test/regress/sql/misc_functions.sql +++ b/src/test/regress/sql/misc_functions.sql @@ -229,3 +229,11 @@ 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(); + +-- pg_dissect_walfile_name +SELECT * FROM pg_dissect_walfile_name(NULL); +SELECT * FROM pg_dissect_walfile_name('invalid'); +SELECT segno > 0 AS ok_segno, timeline_id + FROM pg_dissect_walfile_name('000000010000000100000000'); +SELECT segno > 0 AS ok_segno, timeline_id + FROM pg_dissect_walfile_name('ffffffFF00000001000000af'); |