Annotation of embedaddon/php/ext/pdo/tests/pdo_008.phpt, revision 1.1
1.1 ! misho 1: --TEST--
! 2: PDO Common: PDO::FETCH_UNIQUE conflict
! 3: --SKIPIF--
! 4: <?php # vim:ft=php
! 5: if (!extension_loaded('pdo')) die('skip');
! 6: $dir = getenv('REDIR_TEST_DIR');
! 7: if (false == $dir) die('skip no driver');
! 8: require_once $dir . 'pdo_test.inc';
! 9: PDOTest::skip();
! 10: ?>
! 11: --FILE--
! 12: <?php
! 13: if (getenv('REDIR_TEST_DIR') === false) putenv('REDIR_TEST_DIR='.dirname(__FILE__) . '/../../pdo/tests/');
! 14: require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc';
! 15: $db = PDOTest::factory();
! 16:
! 17: $db->exec('CREATE TABLE test(id CHAR(1) NOT NULL PRIMARY KEY, val VARCHAR(10))');
! 18: $db->exec("INSERT INTO test VALUES('A', 'A')");
! 19: $db->exec("INSERT INTO test VALUES('B', 'A')");
! 20: $db->exec("INSERT INTO test VALUES('C', 'C')");
! 21:
! 22: $stmt = $db->prepare('SELECT val, id from test');
! 23:
! 24: $stmt->execute();
! 25: var_dump($stmt->fetchAll(PDO::FETCH_NUM|PDO::FETCH_UNIQUE));
! 26:
! 27: ?>
! 28: --EXPECT--
! 29: array(2) {
! 30: ["A"]=>
! 31: array(1) {
! 32: [0]=>
! 33: string(1) "B"
! 34: }
! 35: ["C"]=>
! 36: array(1) {
! 37: [0]=>
! 38: string(1) "C"
! 39: }
! 40: }
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>