c15988aab3
This makes the tests independent of each other and allows them to be run in parallel. Co-authored-by: Gina Peter Banyard <girgias@php.net>
68 lines
1.3 KiB
PHP
68 lines
1.3 KiB
PHP
--TEST--
|
|
Bug #32223 (weird behaviour of pg_last_notice using define)
|
|
--EXTENSIONS--
|
|
pgsql
|
|
--SKIPIF--
|
|
<?php
|
|
require_once('inc/skipif.inc');
|
|
|
|
_skip_lc_messages($conn);
|
|
|
|
@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');
|
|
?>
|
|
--INI--
|
|
pgsql.ignore_notice=0
|
|
--FILE--
|
|
<?php
|
|
|
|
require_once('inc/config.inc');
|
|
require_once('inc/lcmess.inc');
|
|
|
|
$dbh = pg_connect($conn_str);
|
|
if (!$dbh) {
|
|
die ("Could not connect to the server");
|
|
}
|
|
|
|
_set_lc_messages($dbh);
|
|
|
|
$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, 'SET client_min_messages TO NOTICE;');
|
|
var_dump($res);
|
|
|
|
function tester($dbh) {
|
|
$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(pg_last_notice($dbh));
|
|
}
|
|
}
|
|
tester($dbh);
|
|
|
|
pg_close($dbh);
|
|
|
|
?>
|
|
--EXPECTF--
|
|
object(PgSql\Result)#%d (0) {
|
|
}
|
|
array(1) {
|
|
[0]=>
|
|
string(1) "f"
|
|
}
|
|
string(14) "NOTICE: 11111"
|