1--TEST-- 2PDO MySQL Bug #33689 (query() execute() and fetch() return false on valid select queries) 3--EXTENSIONS-- 4pdo 5pdo_mysql 6--SKIPIF-- 7<?php 8require __DIR__ . '/config.inc'; 9require __DIR__ . '/../../../ext/pdo/tests/pdo_test.inc'; 10PDOTest::skip(); 11?> 12--FILE-- 13<?php 14require __DIR__ . '/config.inc'; 15require __DIR__ . '/../../../ext/pdo/tests/pdo_test.inc'; 16$db = PDOTest::test_factory(__DIR__ . '/common.phpt'); 17 18$db->exec('CREATE TABLE test (bar INT NOT NULL)'); 19$db->exec('INSERT INTO test VALUES(1)'); 20 21var_dump($db->query('SELECT * from test')); 22foreach ($db->query('SELECT * from test') as $row) { 23 print_r($row); 24} 25 26$stmt = $db->prepare('SELECT * from test'); 27print_r($stmt->getColumnMeta(0)); 28$stmt->execute(); 29$tmp = $stmt->getColumnMeta(0); 30 31// libmysql and mysqlnd will show the pdo_type entry at a different position in the hash 32// and will report a different type, as mysqlnd returns native types. 33if (!isset($tmp['pdo_type']) || ($tmp['pdo_type'] != 1 && $tmp['pdo_type'] != 2)) 34 printf("Expecting pdo_type = 1 got %s\n", $tmp['pdo_type']); 35else 36 unset($tmp['pdo_type']); 37 38print_r($tmp); 39?> 40--CLEAN-- 41<?php 42require __DIR__ . '/mysql_pdo_test.inc'; 43MySQLPDOTest::dropTestTable(); 44?> 45--EXPECTF-- 46object(PDOStatement)#%d (1) { 47 ["queryString"]=> 48 string(18) "SELECT * from test" 49} 50Array 51( 52 [bar] => 1 53 [0] => 1 54) 55Array 56( 57 [native_type] => LONG 58 [flags] => Array 59 ( 60 [0] => not_null 61 ) 62 63 [table] => test 64 [name] => bar 65 [len] => 11 66 [precision] => 0 67) 68
