cvs: php-src(PHP_5_1) /ext/pgsql/tests 80_bug32223.phpt
| From: | Marcus Boerger | 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);