Annotation of embedaddon/php/ext/pdo_mysql/tests/pecl_bug_5802.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: PDO MySQL PECL Bug #5802 (bindParam/bindValue retain the is_null flag)
        !             3: --SKIPIF--
        !             4: <?php # vim:ft=php:
        !             5: if (!extension_loaded('pdo') || !extension_loaded('pdo_mysql')) 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: require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
        !            13: $db = PDOTest::test_factory(dirname(__FILE__). '/common.phpt');
        !            14: 
        !            15: $db->exec('create table test ( bar char(3) NULL )');
        !            16: $stmt = $db->prepare('insert into test (bar) values(:bar)') or var_dump($db->errorInfo());
        !            17: 
        !            18: $bar = 'foo';
        !            19: $stmt->bindParam(':bar', $bar);
        !            20: $stmt->execute() or var_dump($stmt->errorInfo());
        !            21: 
        !            22: $bar = null;
        !            23: $stmt->bindParam(':bar', $bar);
        !            24: $stmt->execute() or var_dump($stmt->errorInfo());
        !            25: 
        !            26: $bar = 'qaz';
        !            27: $stmt->bindParam(':bar', $bar);
        !            28: $stmt->execute() or var_dump($stmt->errorInfo());
        !            29: 
        !            30: $stmt = $db->prepare('select * from test') or var_dump($db->errorInfo());
        !            31: 
        !            32: if($stmt) $stmt->execute();
        !            33: if($stmt) var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
        !            34: 
        !            35: print "done!";
        !            36: ?>
        !            37: --CLEAN--
        !            38: <?php
        !            39: require dirname(__FILE__) . '/mysql_pdo_test.inc';
        !            40: $db = MySQLPDOTest::factory();
        !            41: $db->exec('DROP TABLE IF EXISTS test');
        !            42: ?>
        !            43: --EXPECTF--
        !            44: array(3) {
        !            45:   [0]=>
        !            46:   array(1) {
        !            47:     [%u|b%"bar"]=>
        !            48:     %unicode|string%(3) "foo"
        !            49:   }
        !            50:   [1]=>
        !            51:   array(1) {
        !            52:     [%u|b%"bar"]=>
        !            53:     NULL
        !            54:   }
        !            55:   [2]=>
        !            56:   array(1) {
        !            57:     [%u|b%"bar"]=>
        !            58:     %unicode|string%(3) "qaz"
        !            59:   }
        !            60: }
        !            61: done!

FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>