1--TEST-- 2Bug #47199 (pg_delete fails on NULL) 3--SKIPIF-- 4<?php 5require_once('skipif.inc'); 6?> 7--FILE-- 8<?php 9 10require_once('config.inc'); 11 12$dbh = pg_connect($conn_str); 13$tbl_name = 'test_47199'; 14@pg_query("DROP TABLE $tbl_name"); 15pg_query("CREATE TABLE $tbl_name (null_field INT, not_null_field INT NOT NULL)"); 16 17pg_insert($dbh, $tbl_name, array('null_field' => null, 'not_null_field' => 1)); 18pg_insert($dbh, $tbl_name, array('null_field' => null, 'not_null_field' => 2)); 19 20var_dump(pg_fetch_all(pg_query('SELECT * FROM '. $tbl_name))); 21 22$query = pg_delete($dbh, $tbl_name, array('null_field' => NULL,'not_null_field' => 2), PGSQL_DML_STRING|PGSQL_DML_EXEC); 23 24echo $query, "\n"; 25 26$query = pg_update($dbh, $tbl_name, array('null_field' => NULL, 'not_null_field' => 0), array('not_null_field' => 1, 'null_field' => ''), PGSQL_DML_STRING|PGSQL_DML_EXEC); 27 28echo $query, "\n"; 29 30var_dump(pg_fetch_all(pg_query('SELECT * FROM '. $tbl_name))); 31 32@pg_query("DROP TABLE $tbl_name"); 33pg_close($dbh); 34 35echo PHP_EOL."Done".PHP_EOL; 36 37?> 38--EXPECTF-- 39array(2) { 40 [0]=> 41 array(2) { 42 ["null_field"]=> 43 NULL 44 ["not_null_field"]=> 45 string(1) "1" 46 } 47 [1]=> 48 array(2) { 49 ["null_field"]=> 50 NULL 51 ["not_null_field"]=> 52 string(1) "2" 53 } 54} 55DELETE FROM "test_47199" WHERE "null_field" IS NULL AND "not_null_field"=2; 56UPDATE "test_47199" SET "null_field"=NULL,"not_null_field"=0 WHERE "not_null_field"=1 AND "null_field" IS NULL; 57array(1) { 58 [0]=> 59 array(2) { 60 ["null_field"]=> 61 NULL 62 ["not_null_field"]=> 63 string(1) "0" 64 } 65} 66 67Done
