diff options
| -rw-r--r-- | ext/pdo_pgsql/tests/bug_33876.phpt | 151 | ||||
| -rw-r--r-- | ext/pdo_pgsql/tests/large_objects.phpt | 61 |
2 files changed, 212 insertions, 0 deletions
diff --git a/ext/pdo_pgsql/tests/bug_33876.phpt b/ext/pdo_pgsql/tests/bug_33876.phpt new file mode 100644 index 0000000000..fc9d20f696 --- /dev/null +++ b/ext/pdo_pgsql/tests/bug_33876.phpt @@ -0,0 +1,151 @@ +--TEST-- +PDO PgSQL Bug #33876 +--SKIPIF-- +<?php +if (!extension_loaded('pdo') || !extension_loaded('pdo_pgsql')) die('skip not loaded'); +require dirname(__FILE__) . '/config.inc'; +require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc'; +PDOTest::skip(); +?> +--FILE-- +<?php +require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc'; +$db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); +$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT); + +$db->exec("SET LC_MESSAGES='C'"); +$db->exec('CREATE TABLE test (foo varchar(5) NOT NULL, bar bool NOT NULL)'); +$db->exec("INSERT INTO test VALUES('false','f')"); +$db->exec("INSERT INTO test VALUES('true', 't')"); + +$res = $db->prepare('SELECT foo from test where bar = ?'); + +# this is the portable approach to binding a bool +$res->bindValue(1, false, PDO::PARAM_BOOL); +if (!$res->execute()) + print_r($res->errorInfo()); +else + print_r($res->fetchAll(PDO::FETCH_ASSOC)); + +# this is the portable approach to binding a bool +$res->bindValue(1, true, PDO::PARAM_BOOL); +if (!$res->execute()) + print_r($res->errorInfo()); +else + print_r($res->fetchAll(PDO::FETCH_ASSOC)); + + +# true gets cast to string (because the implied default is string) +# true-as-string is 1, so this "works" +if (!$res->execute(array(true))) + print_r($res->errorInfo()); +else + print_r($res->fetchAll(PDO::FETCH_ASSOC)); + +# Expected to fail; unless told otherwise, PDO assumes string inputs +# false -> "" as string, which pgsql doesn't like +if (!$res->execute(array(false))) + print_r($res->errorInfo()); +else + print_r($res->fetchAll(PDO::FETCH_ASSOC)); + +# And now using emulator prepares +echo "EMUL\n"; + + +$res = $db->prepare('SELECT foo from test where bar = ?', array( + PDO::PGSQL_ATTR_DISABLE_NATIVE_PREPARED_STATEMENT => true)); + +# this is the portable approach to binding a bool +$res->bindValue(1, false, PDO::PARAM_BOOL); +if (!$res->execute()) + print_r($res->errorInfo()); +else + print_r($res->fetchAll(PDO::FETCH_ASSOC)); + +# this is the portable approach to binding a bool +$res->bindValue(1, true, PDO::PARAM_BOOL); +if (!$res->execute()) + print_r($res->errorInfo()); +else + print_r($res->fetchAll(PDO::FETCH_ASSOC)); + + +# true gets cast to string (because the implied default is string) +# true-as-string is 1, so this "works" +if (!$res->execute(array(true))) + print_r($res->errorInfo()); +else + print_r($res->fetchAll(PDO::FETCH_ASSOC)); + +# Expected to fail; unless told otherwise, PDO assumes string inputs +# false -> "" as string, which pgsql doesn't like +if (!$res->execute(array(false))) + print_r($res->errorInfo()); +else + print_r($res->fetchAll(PDO::FETCH_ASSOC)); + + + +--EXPECT-- +Array +( + [0] => Array + ( + [foo] => false + ) + +) +Array +( + [0] => Array + ( + [foo] => true + ) + +) +Array +( + [0] => Array + ( + [foo] => true + ) + +) +Array +( + [0] => 22P02 + [1] => 7 + [2] => ERROR: invalid input syntax for type boolean: "" +) +EMUL +Array +( + [0] => Array + ( + [foo] => false + ) + +) +Array +( + [0] => Array + ( + [foo] => true + ) + +) +Array +( + [0] => Array + ( + [foo] => true + ) + +) +Array +( + [0] => 22P02 + [1] => 7 + [2] => ERROR: invalid input syntax for type boolean: "" +) diff --git a/ext/pdo_pgsql/tests/large_objects.phpt b/ext/pdo_pgsql/tests/large_objects.phpt new file mode 100644 index 0000000000..f6ee9e29c0 --- /dev/null +++ b/ext/pdo_pgsql/tests/large_objects.phpt @@ -0,0 +1,61 @@ +--TEST-- +PDO PgSQL Large Objects +--SKIPIF-- +<?php # vim:se ft=php: +if (!extension_loaded('pdo') || !extension_loaded('pdo_pgsql')) die('skip not loaded'); +require dirname(__FILE__) . '/config.inc'; +require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc'; +PDOTest::skip(); +?> +--FILE-- +<?php +require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc'; +$db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); +$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); +$db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); + +$db->exec('CREATE TABLE test (blobid integer not null primary key, bloboid OID)'); + +$db->beginTransaction(); +$oid = $db->pgsqlLOBCreate(); +try { +$stm = $db->pgsqlLOBOpen($oid); +fwrite($stm, "Hello dude\n"); + +$stmt = $db->prepare("INSERT INTO test (blobid, bloboid) values (?, ?)"); +$stmt->bindValue(1, 1); +/* bind as LOB; the oid from the pgsql stream will be inserted instead + * of the stream contents. Binding other streams will attempt to bind + * as bytea, and will most likely lead to an error. + * You can also just bind the $oid in as a string. */ +$stmt->bindParam(2, $stm, PDO::PARAM_LOB); +$stmt->execute(); +$stm = null; + +/* Pull it out */ +$stmt = $db->prepare("SELECT * from test"); +$stmt->execute(); +$stmt->bindColumn('bloboid', $lob, PDO::PARAM_LOB); +echo "Fetching:\n"; +while (($row = $stmt->fetch(PDO::FETCH_ASSOC))) { + var_dump($row['blobid']); + var_dump(stream_get_contents($lob)); +} +echo "Fetched!\n"; +} catch (Exception $e) { + /* catch exceptions so that we can guarantee to clean + * up the LOB */ + echo "Exception! at line ", $e->getLine(), "\n"; + var_dump($e->getMessage()); +} + +/* Now to remove the large object from the database, so it doesn't + * linger and clutter up the storage */ +$db->pgsqlLOBUnlink($oid); + +--EXPECT-- +Fetching: +int(1) +string(11) "Hello dude +" +Fetched! |