mirror of
https://github.com/php/php-src.git
synced 2026-03-25 08:42:29 +01:00
39131219e8
This is a mix of more automated and manual migration. It should remove all applicable extension_loaded() checks outside of skipif.inc files.
74 lines
1.3 KiB
PHP
74 lines
1.3 KiB
PHP
--TEST--
|
|
PDO PgSQL Bug #64953 (Postgres prepared statement positional parameter casting)
|
|
--EXTENSIONS--
|
|
pdo
|
|
pdo_pgsql
|
|
--SKIPIF--
|
|
<?php
|
|
require __DIR__ . '/config.inc';
|
|
require __DIR__ . '/../../../ext/pdo/tests/pdo_test.inc';
|
|
PDOTest::skip();
|
|
?>
|
|
--FILE--
|
|
<?php
|
|
echo "Test\n";
|
|
|
|
require __DIR__ . '/../../../ext/pdo/tests/pdo_test.inc';
|
|
$pdo = PDOTest::test_factory(__DIR__ . '/common.phpt');
|
|
$pdo->setAttribute (\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
|
|
|
|
echo "Taken from the bug report:\n";
|
|
|
|
$st = $pdo->prepare('SELECT ?::char as i');
|
|
$st->bindValue(1, '1');
|
|
$st->execute();
|
|
var_dump($st->fetch()); // return false
|
|
|
|
|
|
$st = $pdo->prepare('SELECT (?)::char as i');
|
|
$st->bindValue(1, '1');
|
|
$st->execute();
|
|
var_dump($st->fetch()); // return array(1) { ["i"]=> string(1) "1" }
|
|
|
|
echo "Something more nasty:\n";
|
|
|
|
$st = $pdo->prepare("SELECT :int::int as i");
|
|
$st->execute(array(":int" => 123));
|
|
var_dump($st->fetch());
|
|
|
|
$st = $pdo->prepare("SELECT '''?'''::text as \":text\"");
|
|
$st->execute();
|
|
var_dump($st->fetch());
|
|
|
|
?>
|
|
Done
|
|
--EXPECT--
|
|
Test
|
|
Taken from the bug report:
|
|
array(2) {
|
|
["i"]=>
|
|
string(1) "1"
|
|
[0]=>
|
|
string(1) "1"
|
|
}
|
|
array(2) {
|
|
["i"]=>
|
|
string(1) "1"
|
|
[0]=>
|
|
string(1) "1"
|
|
}
|
|
Something more nasty:
|
|
array(2) {
|
|
["i"]=>
|
|
string(3) "123"
|
|
[0]=>
|
|
string(3) "123"
|
|
}
|
|
array(2) {
|
|
[":text"]=>
|
|
string(3) "'?'"
|
|
[0]=>
|
|
string(3) "'?'"
|
|
}
|
|
Done
|