Return to bug64953.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / pdo_pgsql / tests

Annotation of embedaddon/php/ext/pdo_pgsql/tests/bug64953.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: PDO PgSQL Bug #64953 (Postgres prepared statement positional parameter casting)
        !             3: --SKIPIF--
        !             4: <?php
        !             5: if (!extension_loaded('pdo') || !extension_loaded('pdo_pgsql')) die('skip not loaded');
        !             6: require dirname(__FILE__) . '/config.inc';
        !             7: require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
        !             8: PDOTest::skip();
        !             9: ?>
        !            10: --FILE--
        !            11: <?php
        !            12: echo "Test\n";
        !            13: 
        !            14: require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
        !            15: $pdo = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
        !            16: $pdo->setAttribute (\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
        !            17: 
        !            18: echo "Taken from the bug report:\n";
        !            19: 
        !            20: $st = $pdo->prepare('SELECT ?::char as i');
        !            21: $st->bindValue(1, '1');
        !            22: $st->execute();
        !            23: var_dump($st->fetch()); // return false
        !            24: 
        !            25: 
        !            26: $st = $pdo->prepare('SELECT (?)::char as i');
        !            27: $st->bindValue(1, '1');
        !            28: $st->execute();
        !            29: var_dump($st->fetch());  // return array(1) { ["i"]=> string(1) "1" }
        !            30: 
        !            31: echo "Something more nasty:\n";
        !            32: 
        !            33: $st = $pdo->prepare("SELECT :int::int as i");
        !            34: $st->execute(array(":int" => 123));
        !            35: var_dump($st->fetch());
        !            36: 
        !            37: $st = $pdo->prepare("SELECT '''?'''::text as \":text\"");
        !            38: $st->execute();
        !            39: var_dump($st->fetch());
        !            40: 
        !            41: ?>
        !            42: Done
        !            43: --EXPECT--
        !            44: Test
        !            45: Taken from the bug report:
        !            46: array(2) {
        !            47:   ["i"]=>
        !            48:   string(1) "1"
        !            49:   [0]=>
        !            50:   string(1) "1"
        !            51: }
        !            52: array(2) {
        !            53:   ["i"]=>
        !            54:   string(1) "1"
        !            55:   [0]=>
        !            56:   string(1) "1"
        !            57: }
        !            58: Something more nasty:
        !            59: array(2) {
        !            60:   ["i"]=>
        !            61:   string(3) "123"
        !            62:   [0]=>
        !            63:   string(3) "123"
        !            64: }
        !            65: array(2) {
        !            66:   [":text"]=>
        !            67:   string(3) "'?'"
        !            68:   [0]=>
        !            69:   string(3) "'?'"
        !            70: }
        !            71: Done