xref: /PHP-8.1/ext/pdo/tests/bug_42917.phpt (revision 74859783)
1--TEST--
2PDO Common: Bug #42917 (PDO::FETCH_KEY_PAIR doesn't work with setFetchMode)
3--EXTENSIONS--
4pdo
5--SKIPIF--
6<?php
7$dir = getenv('REDIR_TEST_DIR');
8if (false == $dir) die('skip no driver');
9require_once $dir . 'pdo_test.inc';
10PDOTest::skip();
11?>
12--FILE--
13<?php
14if (getenv('REDIR_TEST_DIR') === false) putenv('REDIR_TEST_DIR='.__DIR__ . '/../../pdo/tests/');
15require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc';
16$db = PDOTest::factory();
17
18$db->exec("CREATE TABLE test (a varchar(100), b varchar(100), c varchar(100))");
19
20for ($i = 0; $i < 5; $i++) {
21    $db->exec("INSERT INTO test (a,b,c) VALUES('test".$i."','".$i."','".$i."')");
22}
23
24$res = $db->query("SELECT a,b FROM test");
25$res->setFetchMode(PDO::FETCH_KEY_PAIR);
26var_dump($res->fetchAll());
27
28?>
29--EXPECT--
30array(5) {
31  ["test0"]=>
32  string(1) "0"
33  ["test1"]=>
34  string(1) "1"
35  ["test2"]=>
36  string(1) "2"
37  ["test3"]=>
38  string(1) "3"
39  ["test4"]=>
40  string(1) "4"
41}
42