cvs: php-src(PHP_4_4) /ext/pgsql/tests 80_bug32223.phpt
| From: | Marcus Boerger | Date: | Sun, 09 Oct 2005 15:58:05 +0000 |
| Subject: | cvs: php-src(PHP_4_4) /ext/pgsql/tests 80_bug32223.phpt | ||
| Groups: | php.cvs | ||
| Request: | Send a blank email to php-cvs+get-34443@lists.php.net to get a copy of this message | ||
helly Sun Oct 9 11:58:05 2005 EDT
Modified files: (Branch: PHP_4_4)
/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.4.2&r2=1.1.4.3&ty=u
Index: php-src/ext/pgsql/tests/80_bug32223.phpt
diff -u php-src/ext/pgsql/tests/80_bug32223.phpt:1.1.4.2
php-src/ext/pgsql/tests/80_bug32223.phpt:1.1.4.3
--- php-src/ext/pgsql/tests/80_bug32223.phpt:1.1.4.2 Sun Oct 9 11:22:05 2005
+++ php-src/ext/pgsql/tests/80_bug32223.phpt Sun Oct 9 11:58:05 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,13 +23,15 @@
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;");
+
$res = pg_query($dbh, 'SELECT test_notice()');
$row = pg_fetch_row($res, 0);
var_dump($row);