Edit report at http://bugs.php.net/bug.php?id=52682&edit=1
ID: 52682
Comment by: Dalifter2006 at mail dot ru
Reported by: benoitg at coeus dot ca
Summary: pg_query does not return on error
Status: Feedback
Type: Bug
Package: PostgreSQL related
Operating System: Ubuntu Lucid or Maverick
PHP Version: 5.3.3
Block user comment: N
New Comment:
php --version
PHP 5.3.3-1ubuntu9 with Suhosin-Patch (cli) (built: Sep 20 2010
22:40:29)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
with Xdebug v2.1.0, Copyright (c) 2002-2010, by Derick Rethans
Catched up on selection from not-exists table.
Previous Comments:
------------------------------------------------------------------------
[2010-09-20 14:32:45] [email protected]
Seems to work fine in latest snapshot.
------------------------------------------------------------------------
[2010-08-25 23:17:52] benoitg at coeus dot ca
Additional notes:
When the bug occurs, lines like the following are written to the
postgresql log:
2010-08-25 17:03:03 EDT LOG: unexpected EOF on client connection
No errors are reported by apache.
------------------------------------------------------------------------
[2010-08-24 00:52:50] benoitg at coeus dot ca
Description:
------------
pg_query() should return when an SQL error happens (there are then
various function to get the error description. However in php 5.3.2
(ubuntu lucid) and 5.3.3 (ubuntu maverick), the function doesn't return
at all (the php script ends).
Included is a short test script. As will run on ubuntu as written if
you run php cli as the postgres system user, for example:
sudo -u postgres php test_pg_query_not_returning.php
Test script:
---------------
<?php
define ('CONF_DATABASE_NAME', "postgres");
define ('CONF_DATABASE_USER', "postgres");
define ('CONF_DATABASE_PASSWORD', "");
$conn_string = "dbname=".CONF_DATABASE_NAME."
user=".CONF_DATABASE_USER." password=".CONF_DATABASE_PASSWORD."\n";
$conn = pg_connect($conn_string) or die("Unable to connect to database,
fix this first");
echo "About to execute actual test: \n";
$sql = "SOME INVALID SQL";
$return = pg_query($conn, $sql);
if($return === FALSE) {
echo "You should see this, but this code is never executed!\n";
}
echo "Even this code is never executed!\n";
?>
Expected result:
----------------
sudo -u postgres php test_pg_query_not_returning.php
About to execute actual test:
PHP Warning: pg_query(): Query failed: ERROR: syntax error at or near
"SOME"
LINE 1: SOME INVALID SQL
^
in /var/www/eureka/html/tests/test_pg_query_not_returning.php on line
11
You should see this, but this code is never executed!
Even this code is never executed!
Actual result:
--------------
sudo -u postgres php test_pg_query_not_returning.php
About to execute actual test:
PHP Warning: pg_query(): Query failed: ERROR: syntax error at or near
"SOME"
LINE 1: SOME INVALID SQL
^
in /var/www/eureka/html/tests/test_pg_query_not_returning.php on line
11
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/bug.php?id=52682&edit=1
