Bug #68638 [NEW]: pg_update() fails to store infinite values

From: joerg dot ludwig at iserv dot eu Operating system: Debian Linux PHP version: 5.4.36 Package: PostgreSQL related Bug Type: Bug Bug description:pg_update() fails to store infinite values Description: ------------ pg_update() fails to store infinite values. Test script: --------------- $dbh = pg_connect("dbname=test"); pg_update($dbh, "test", ["ping" => INF], ["id" => 42]); pg_update($dbh, "test", ["ping" => "INF"], ["id" => 42]); Expected result: ---------------- pg_update() (and pg_insert()) should be able to store infinite values (INF and -INF). In PostgreSQL itself it works: UPDATE test SET ping = 'INF' WHERE id = 42; Actual result: -------------- PHP Warning: pg_update(): ERROR: column "inf" does not exist LINE 1: UPDATE "test" SET "ping"=INF WHERE "id"=42... ^ in Command line code on line 1 PHP Notice: pg_update(): 'INF' does not match with '^([+-]{0,1}[0-9]+)|([+-]{0,1}[0-9]*[\.][0-9]+)|([+-]{0,1}[0-9]+[\.][0-9]*)$' in Command line code on line 1 PHP Notice: pg_update(): Expects NULL, string, long or double value for PostgreSQL 'float4' (ping) in Command line code on line 1 -- Edit bug report at https://bugs.php.net/bug.php?id=68638&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=68638&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=68638&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=68638&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=68638&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=68638&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=68638&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=68638&r=needscript Try newer version: https://bugs.php.net/fix.php?id=68638&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=68638&r=support Expected behavior: https://bugs.php.net/fix.php?id=68638&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=68638&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=68638&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=68638&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=68638&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=68638&r=dst IIS Stability: https://bugs.php.net/fix.php?id=68638&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=68638&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=68638&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=68638&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=68638&r=mysqlcfg