diff options
author | William Felipe Welter <william.welter@4linux.com.br> | 2015-02-05 13:19:52 -0200 |
---|---|---|
committer | William Felipe Welter <william.welter@4linux.com.br> | 2015-02-05 13:19:52 -0200 |
commit | b64f1491768426cd9602dc7057a220ef5b5e4cfd (patch) | |
tree | 2a11e6f23e6fb73dc25014b131a07cd50ffe75a5 | |
parent | cb3833a3bef1d40ff630f6a0af55648acaf664f7 (diff) | |
download | php-git-b64f1491768426cd9602dc7057a220ef5b5e4cfd.tar.gz |
Test case Bug #68638 pg_update() fails to store infinite values
-rw-r--r-- | ext/pgsql/tests/bug68638.phpt | 53 |
1 files changed, 53 insertions, 0 deletions
diff --git a/ext/pgsql/tests/bug68638.phpt b/ext/pgsql/tests/bug68638.phpt new file mode 100644 index 0000000000..e0701a79f5 --- /dev/null +++ b/ext/pgsql/tests/bug68638.phpt @@ -0,0 +1,53 @@ +--TEST-- +Bug #68638 pg_update() fails to store infinite values +--SKIPIF-- +<?php include("skipif.inc"); ?> +--FILE-- +<?php + +include('config.inc'); + +$conn = pg_connect($conn_str); + +$table='test_68638'; + +pg_query("CREATE TABLE $table (id INT, value FLOAT)"); + +pg_insert($conn,$table, array('id' => 1, 'value' => 1.2)); +pg_insert($conn,$table, array('id' => 2, 'value' => 10)); +pg_insert($conn,$table, array('id' => 3, 'value' => 15)); + +var_dump(pg_update($conn,$table, array('value' => 'inf'), array('id' => 1), PGSQL_DML_STRING)); + +pg_update($conn,$table, array('value' => 'inf'), array('id' => 1)); +pg_update($conn,$table, array('value' => '-inf'), array('id' => 2)); +pg_update($conn,$table, array('value' => '+inf'), array('id' => 3)); + +$rs = pg_query("SELECT * FROM $table"); +while ($row = pg_fetch_assoc($rs)) { + var_dump($row); +} + +pg_query("DROP TABLE $table"); + +?> +--EXPECT-- +string(52) "UPDATE "test_68638" SET "value"=E'inf' WHERE "id"=1;" +array(2) { + ["id"]=> + string(1) "1" + ["value"]=> + string(8) "Infinity" +} +array(2) { + ["id"]=> + string(1) "2" + ["value"]=> + string(9) "-Infinity" +} +array(2) { + ["id"]=> + string(1) "3" + ["value"]=> + string(8) "Infinity" +} |