From b371336cce59e51dbe7325622c953ce6028b1cbb Mon Sep 17 00:00:00 2001 From: =?utf8?q?C=C3=A9dric=20Villemain?= Date: Tue, 10 Dec 2013 14:10:57 +0100 Subject: [PATCH] Update regression test --- expected/pgfincore.ext.out | 11 +++++++++++ expected/pgfincore.out | 11 +++++++++++ sql/pgfincore.ext.sql | 5 +++-- sql/pgfincore.sql | 5 +++-- 4 files changed, 28 insertions(+), 4 deletions(-) diff --git a/expected/pgfincore.ext.out b/expected/pgfincore.ext.out index 8dfe491..8191dc0 100644 --- a/expected/pgfincore.ext.out +++ b/expected/pgfincore.ext.out @@ -49,6 +49,17 @@ select true from pgfadvise_loader('test', 0, false, false, B'1010'); t (1 row) +-- must not fail on empty databit input +select true from pgfadvise_loader('test', 0, false, false, B''); + bool +------ + t +(1 row) + +-- ERROR on NULL databit input +select true from pgfadvise_loader('test', 0, false, false, NULL); +ERROR: pgfadvise_loader: databit argument shouldn't be NULL +CONTEXT: SQL function "pgfadvise_loader" statement 1 -- -- test pgfincore -- diff --git a/expected/pgfincore.out b/expected/pgfincore.out index 5995071..8e930a9 100644 --- a/expected/pgfincore.out +++ b/expected/pgfincore.out @@ -51,6 +51,17 @@ select true from pgfadvise_loader('test', 0, false, false, B'1010'); t (1 row) +-- must not fail on empty databit input +select true from pgfadvise_loader('test', 0, false, false, B''); + bool +------ + t +(1 row) + +-- ERROR on NULL databit input +select true from pgfadvise_loader('test', 0, false, false, NULL); +ERROR: pgfadvise_loader: databit argument shouldn't be NULL +CONTEXT: SQL function "pgfadvise_loader" statement 1 -- -- test pgfincore -- diff --git a/sql/pgfincore.ext.sql b/sql/pgfincore.ext.sql index b45ad3b..c4ca50a 100644 --- a/sql/pgfincore.ext.sql +++ b/sql/pgfincore.ext.sql @@ -23,9 +23,10 @@ select true from pgfadvise_loader('test', 0, true, true, B'1010'); select true from pgfadvise_loader('test', 0, true, false, B'1010'); select true from pgfadvise_loader('test', 0, false, true, B'1010'); select true from pgfadvise_loader('test', 0, false, false, B'1010'); --- must not fail on NULL or empty -select true from pgfadvise_loader('test', 0, false, false, NULL); +-- must not fail on empty databit input select true from pgfadvise_loader('test', 0, false, false, B''); +-- ERROR on NULL databit input +select true from pgfadvise_loader('test', 0, false, false, NULL); -- -- test pgfincore diff --git a/sql/pgfincore.sql b/sql/pgfincore.sql index 3f60bd9..4f5f441 100644 --- a/sql/pgfincore.sql +++ b/sql/pgfincore.sql @@ -27,9 +27,10 @@ select true from pgfadvise_loader('test', 0, true, true, B'1010'); select true from pgfadvise_loader('test', 0, true, false, B'1010'); select true from pgfadvise_loader('test', 0, false, true, B'1010'); select true from pgfadvise_loader('test', 0, false, false, B'1010'); --- must not fail on NULL or empty -select true from pgfadvise_loader('test', 0, false, false, NULL); +-- must not fail on empty databit input select true from pgfadvise_loader('test', 0, false, false, B''); +-- ERROR on NULL databit input +select true from pgfadvise_loader('test', 0, false, false, NULL); -- -- test pgfincore -- 2.39.5