vshmidt/php: The PHP Interpreter

ext/pgsql/tests/bug72028.phpt

52 строки1 KB

George Peter Banyard

Deprecate using the implicit default PgSQL connection

10 июл 2021, 00:12

10 июл 2021, 00:121f42777

--TEST--
Bug #72028 pg_query_params(): NULL converts to empty string
--EXTENSIONS--
pgsql
--SKIPIF--
<?php include("skipif.inc"); ?>
--FILE--
<?php
// create test table

include('config.inc');

$conn = pg_connect($conn_str);

$table = "bug72028_" . md5(uniqid(time()));

pg_query($conn, "CREATE TABLE $table (value TEXT, details TEXT);");

$sql = "INSERT INTO $table (value, details) VALUES ($1, $2)";

$params = array(null, "insert before looping with a reference");
$result = pg_query_params($conn, $sql, $params);

$params2 = array(null, "insert after looping with a reference");
foreach ($params2 as &$p) {
    // doing nothing
}
unset($p);

$result = pg_query_params($conn, $sql, $params2);

$r = pg_query($conn, "SELECT * FROM $table");
while (false !== ($i = pg_fetch_assoc($r))) {
    var_dump($i);
}

pg_query($conn, "DROP TABLE $table");

?>
--EXPECT--
array(2) {
  ["value"]=>
  NULL
  ["details"]=>
  string(38) "insert before looping with a reference"
}
array(2) {
  ["value"]=>
  NULL
  ["details"]=>
  string(37) "insert after looping with a reference"
}