cvs: php-src(PHP_5_1) /ext/pgsql/tests 80_bug32223.phpt

From: Date: Sun, 09 Oct 2005 15:58:13 +0000
Subject: cvs: php-src(PHP_5_1) /ext/pgsql/tests 80_bug32223.phpt
Groups: php.cvs 
Request: Send a blank email to php-cvs+get-34444@lists.php.net to get a copy of this message
helly Sun Oct 9 11:58:13 2005 EDT Modified files: (Branch: PHP_5_1) /php-src/ext/pgsql/tests 80_bug32223.phpt Log: - MFH Make test check for PlPgSQL before using it http://cvs.php.net/diff.php/php-src/ext/pgsql/tests/80_bug32223.phpt?r1=1.1.2.2&r2=1.1.2.3&ty=u Index: php-src/ext/pgsql/tests/80_bug32223.phpt diff -u php-src/ext/pgsql/tests/80_bug32223.phpt:1.1.2.2 php-src/ext/pgsql/tests/80_bug32223.phpt:1.1.2.3 --- php-src/ext/pgsql/tests/80_bug32223.phpt:1.1.2.2 Sun Oct 9 11:14:22 2005 +++ php-src/ext/pgsql/tests/80_bug32223.phpt Sun Oct 9 11:58:13 2005 @@ -1,8 +1,17 @@ --TEST-- -Bug #27597 pg_fetch_array not returning false +Bug #32223 (weird behaviour of pg_last_notice) --SKIPIF-- <?php require_once('skipif.inc'); + +@pg_query($conn, "CREATE LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler LANCOMPILER 'PL/pgSQL'"); +$res = @pg_query($conn, "CREATE OR REPLACE FUNCTION test_notice() RETURNS boolean AS ' +begin + RAISE NOTICE ''11111''; + return ''f''; +end; +' LANGUAGE plpgsql;"); +if (!$res) die('skip PLPGSQL not available'); ?> --FILE-- <?php @@ -14,28 +23,22 @@ die ("Could not connect to the server"); } -pg_query($dbh, "CREATE OR REPLACE FUNCTION test_notice() RETURNS boolean AS ' +//@pg_query($dbh, "CREATE LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler LANCOMPILER 'PL/pgSQL'"); +$res = pg_query($dbh, "CREATE OR REPLACE FUNCTION test_notice() RETURNS boolean AS ' begin RAISE NOTICE ''11111''; return ''f''; end; ' LANGUAGE plpgsql;"); -try -{ - $res = pg_query($dbh, 'SELECT test_notice()'); - $row = pg_fetch_row($res, 0); - var_dump($row); - pg_free_result($res); - if ($row[0] == 'f') - { - throw new Exception(pg_last_notice($dbh)); - } - echo 2; -} -catch (Exception $e) + +$res = pg_query($dbh, 'SELECT test_notice()'); +$row = pg_fetch_row($res, 0); +var_dump($row); +pg_free_result($res); +if ($row[0] == 'f') { - var_dump($e->getMessage()); + var_dump(pg_last_notice($dbh)); } pg_close($dbh);

« previous php.cvs (#34444) next »