#36812 [Bgs->Opn]: bind NULL variables generates warning

ID: 36812 User updated by: ce at netage dot bg Reported By: ce at netage dot bg -Status: Bogus +Status: Open Bug Type: PostgreSQL related Operating System: linux PHP Version: 5.1.3RC1 New Comment: check the workarround and see how an array of $param_list = array(null, null, null); does NOT generate any error, actually working as expected (so the problem is not at the integer type of the column, because it has the right to be NULL) Previous Comments: ------------------------------------------------------------------------ [2006-03-22 18:19:30] iliaa@php.net Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.php.net/manual/ and the instructions on how to report a bug at http://bugs.php.net/how-to-report.php You declare the parameter is being of type INT and then put NULL into it. Is it any wonder PostgreSQL generates an error? ------------------------------------------------------------------------ [2006-03-21 12:38:16] ce at netage dot bg Description: ------------ when binding explicit null value there is no problem (see the workarround), but, when the null value is from variable there is a problem (the example is stupid, but is the simplest one representing the problem) Reproduce code: --------------- CREATE TABLE nullproblem (i integer); <? $conn = pg_connect('dbname=test'); $temp1 = null; $param_list = array($temp1, $temp1, $temp1, ); /******************* workarround: $param_list = array(is_null($temp1)?null:$temp1, is_null($temp1)?null:$temp1, is_null($temp1)?null:$temp1, ); ****************/ pg_prepare($conn, 'test', 'INSERT INTO nullproblem VALUES (case when $2::int IS NULL then $3::int else $1::int end)'); pg_execute($conn, 'test', $param_list); ?> Expected result: ---------------- nothing special Actual result: -------------- Warning: pg_execute(): Query failed: ERROR: invalid input syntax for integer: "" in test.php on line 10 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=36812&edit=1