diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2018-05-01 13:21:16 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2018-05-01 13:21:16 -0400 |
| commit | 6594ee280383b7548b006e7f96c8d06137fced57 (patch) | |
| tree | 7d446d1c153bfc81b3c3d60f5e3bd654fe243fc8 /contrib/jsonb_plperl/sql/jsonb_plperlu.sql | |
| parent | bcbf2346d69f6006f126044864dd9383d50d87b4 (diff) | |
| download | postgresql-6594ee280383b7548b006e7f96c8d06137fced57.tar.gz postgresql-6594ee280383b7548b006e7f96c8d06137fced57.zip | |
Remove jsonb_plperl test cases for Inf/NaN conversions.
It turns out that old Perl versions (before about 5.10) don't have any
very reliable way to generate Inf or NaN numeric values. Getting around
that would require way more work than is really justified to test the
code involved, so let's just drop these new test cases.
Discussion: https://postgr.es/m/28585.1525131438@sss.pgh.pa.us
Diffstat (limited to 'contrib/jsonb_plperl/sql/jsonb_plperlu.sql')
| -rw-r--r-- | contrib/jsonb_plperl/sql/jsonb_plperlu.sql | 22 |
1 files changed, 0 insertions, 22 deletions
diff --git a/contrib/jsonb_plperl/sql/jsonb_plperlu.sql b/contrib/jsonb_plperl/sql/jsonb_plperlu.sql index 339486ddb6f..9287f7672f7 100644 --- a/contrib/jsonb_plperl/sql/jsonb_plperlu.sql +++ b/contrib/jsonb_plperl/sql/jsonb_plperlu.sql @@ -34,28 +34,6 @@ $$; SELECT testSVToJsonb(); -CREATE FUNCTION testInf() RETURNS jsonb -LANGUAGE plperlu -TRANSFORM FOR TYPE jsonb -AS $$ -$val = 9**9**9; # we assume this will overflow to +Inf -return $val; -$$; - -SELECT testInf(); - - -CREATE FUNCTION testNaN() RETURNS jsonb -LANGUAGE plperlu -TRANSFORM FOR TYPE jsonb -AS $$ -$val = sin(9**9**9); # we assume sin(inf) will yield NaN -return $val; -$$; - -SELECT testNaN(); - - -- this revealed a bug in the original implementation CREATE FUNCTION testRegexpResultToJsonb() RETURNS jsonb LANGUAGE plperlu |