1--TEST-- 2MySQL PDO->exec(), native types wo ZEROFILL 3--SKIPIF-- 4<?php 5require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'skipif.inc'); 6require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc'); 7MySQLPDOTest::skip(); 8?> 9--FILE-- 10<?php 11 require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc'); 12 13 function test_type(&$db, $offset, $sql_type, $value, $ret_value = NULL, $pattern = NULL, $alternative_type = NULL) { 14 15 $db->exec('DROP TABLE IF EXISTS test'); 16 $sql = sprintf('CREATE TABLE test(id INT, label %s) ENGINE=%s', $sql_type, MySQLPDOTest::getTableEngine()); 17 @$db->exec($sql); 18 if ($db->errorCode() != 0) { 19 // not all MySQL Server versions and/or engines might support the type 20 return true; 21 } 22 23 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)'); 24 $stmt->bindValue(1, $offset); 25 $stmt->bindValue(2, $value); 26 if (!$stmt->execute()) { 27 printf("[%03d + 1] INSERT failed, %s\n", $offset, var_export($stmt->errorInfo(), true)); 28 return false; 29 } 30 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 31 $stmt = $db->query('SELECT id, label FROM test'); 32 $row = $stmt->fetch(PDO::FETCH_ASSOC); 33 $stmt->closeCursor(); 34 35 if (!isset($row['id']) || !isset($row['label'])) { 36 printf("[%03d + 2] Fetched result seems wrong, dumping result: %s\n", $offset, var_export($row, true)); 37 return false; 38 } 39 40 if ($row['id'] != $offset) { 41 printf("[%03d + 3] Expecting %s got %s\n", $offset, $row['id']); 42 return false; 43 } 44 45 if (!is_null($pattern)) { 46 if (!preg_match($pattern, $row['label'])) { 47 printf("[%03d + 5] Value seems wrong, accepting pattern %s got %s, check manually\n", 48 $offset, $pattern, var_export($row['label'], true)); 49 return false; 50 } 51 52 } else { 53 54 $exp = $value; 55 if (!is_null($ret_value)) { 56 // we expect a different return value than our input value 57 // typically the difference is only the type 58 $exp = $ret_value; 59 } 60 if ($row['label'] !== $exp && !is_null($alternative_type) && gettype($row['label']) != $alternative_type) { 61 printf("[%03d + 4] %s - input = %s/%s, output = %s/%s (alternative type: %s)\n", $offset, 62 $sql_type, var_export($exp, true), gettype($exp), 63 var_export($row['label'], true), gettype($row['label']), 64 $alternative_type); 65 return false; 66 } 67 68 } 69 70 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true); 71 $stmt = $db->query('SELECT id, label FROM test'); 72 $row_string = $stmt->fetch(PDO::FETCH_ASSOC); 73 $stmt->closeCursor(); 74 if (is_null($pattern) && ($row['label'] != $row_string['label'])) { 75 printf("%s - STRINGIGY = %s, NATIVE = %s\n", $sql_type, var_export($row_string['label'], true), var_export($row['label'], true)); 76 return false; 77 } else if (!is_null($pattern) && !preg_match($pattern, $row_string['label'])) { 78 printf("%s - STRINGIGY = %s, NATIVE = %s, pattern '%s'\n", $sql_type, var_export($row_string['label'], true), var_export($row['label'], true), $pattern); 79 return false; 80 } 81 82 83 return true; 84 } 85 86 $db = MySQLPDOTest::factory(); 87 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 88 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); 89 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); 90 91/* 92 test_type($db, 20, 'BIT(8)', 1); 93*/ 94 $is_mysqlnd = MySQLPDOTest::isPDOMySQLnd(); 95 96 test_type($db, 30, 'TINYINT', -127, ($is_mysqlnd) ? -127: '-127'); 97 test_type($db, 40, 'TINYINT UNSIGNED', 255, ($is_mysqlnd) ? 255 : '255'); 98 test_type($db, 50, 'BOOLEAN', 1, ($is_mysqlnd) ? 1 : '1'); 99 100 test_type($db, 60, 'SMALLINT', -32768, ($is_mysqlnd) ? -32768 : '-32768'); 101 test_type($db, 70, 'SMALLINT UNSIGNED', 65535, ($is_mysqlnd) ? 65535 : '65535'); 102 103 test_type($db, 80, 'MEDIUMINT', -8388608, ($is_mysqlnd) ? -8388608 : '-8388608'); 104 test_type($db, 90, 'MEDIUMINT UNSIGNED', 16777215, ($is_mysqlnd) ? 16777215 : '16777215'); 105 106 test_type($db, 100, 'INT', -2147483648, 107 ($is_mysqlnd) ? ((PHP_INT_SIZE > 4) ? (int)-2147483648 : (double)-2147483648) : '-2147483648', 108 NULL, ($is_mysqlnd) ? 'integer' : NULL); 109 110 test_type($db, 110, 'INT UNSIGNED', 4294967295, ($is_mysqlnd) ? ((PHP_INT_SIZE > 4) ? 4294967295 : '4294967295') : '4294967295'); 111 112 // no chance to return int with the current PDO version - we are forced to return strings 113 test_type($db, 120, 'BIGINT', 1, ($is_mysqlnd) ? 1 : '1'); 114 // to avoid trouble with numeric ranges, lets pass the numbers as a string 115 test_type($db, 130, 'BIGINT', '-9223372036854775808', NULL, '/^\-9[\.]*22/'); 116 test_type($db, 140, 'BIGINT UNSIGNED', '18446744073709551615', NULL, '/^1[\.]*844/'); 117 118 test_type($db, 150, 'REAL', -1.01, ($is_mysqlnd) ? -1.01 : '-1.01'); 119 test_type($db, 160, 'REAL UNSIGNED', 1.01, ($is_mysqlnd) ? 1.01 : '1.01'); 120 121 test_type($db, 170, 'DOUBLE', -1.01, ($is_mysqlnd) ? -1.01 : '-1.01'); 122 test_type($db, 180, 'DOUBLE UNSIGNED', 1.01, ($is_mysqlnd) ? 1.01 : '1.01'); 123 124 test_type($db, 210, 'FLOAT', -1.01, NULL, '/^\-1.0\d+/'); 125 test_type($db, 220, 'FLOAT UNSIGNED', 1.01, NULL, '/^1.0\d+/'); 126 127 test_type($db, 250, 'DECIMAL', -1.01, '-1'); 128 test_type($db, 260, 'DECIMAL UNSIGNED', 1.01, '1'); 129 130 131 test_type($db, 290, 'NUMERIC', -1.01, '-1'); 132 test_type($db, 300, 'NUMERIC UNSIGNED', 1.01, '1'); 133 134 test_type($db, 330, 'DATE', '2008-04-23'); 135 test_type($db, 340, 'TIME', '14:37:00'); 136 test_type($db, 350, 'TIMESTAMP', '2008-05-06 21:09:00'); 137 test_type($db, 360, 'DATETIME', '2008-03-23 14:38:00'); 138 test_type($db, 370, 'YEAR', 2008, ($is_mysqlnd) ? 2008 : '2008'); 139 140 test_type($db, 380, 'CHAR(1)', 'a'); 141 test_type($db, 390, 'CHAR(10)', '0123456789'); 142 test_type($db, 400, 'CHAR(255)', str_repeat('z', 255)); 143 test_type($db, 410, 'VARCHAR(1)', 'a'); 144 test_type($db, 420, 'VARCHAR(10)', '0123456789'); 145 test_type($db, 430, 'VARCHAR(255)', str_repeat('z', 255)); 146 147 test_type($db, 440, 'BINARY(1)', str_repeat('a', 1)); 148 test_type($db, 450, 'BINARY(255)', str_repeat('b', 255)); 149 test_type($db, 460, 'VARBINARY(1)', str_repeat('a', 1)); 150 test_type($db, 470, 'VARBINARY(255)', str_repeat('b', 255)); 151 152 test_type($db, 480, 'TINYBLOB', str_repeat('b', 255)); 153 test_type($db, 490, 'BLOB', str_repeat('b', 256)); 154 test_type($db, 500, 'MEDIUMBLOB', str_repeat('b', 256)); 155 test_type($db, 510, 'LONGBLOB', str_repeat('b', 256)); 156 157 test_type($db, 520, 'TINYTEXT', str_repeat('b', 255)); 158 test_type($db, 530, 'TINYTEXT BINARY', str_repeat('b', 255)); 159 160 test_type($db, 560, 'TEXT', str_repeat('b', 256)); 161 test_type($db, 570, 'TEXT BINARY', str_repeat('b', 256)); 162 163 test_type($db, 580, 'MEDIUMTEXT', str_repeat('b', 256)); 164 test_type($db, 590, 'MEDIUMTEXT BINARY', str_repeat('b', 256)); 165 166 test_type($db, 600, 'LONGTEXT', str_repeat('b', 256)); 167 test_type($db, 610, 'LONGTEXT BINARY', str_repeat('b', 256)); 168 169 test_type($db, 620, "ENUM('yes', 'no') DEFAULT 'yes'", 'no'); 170 test_type($db, 630, "SET('yes', 'no') DEFAULT 'yes'", 'no'); 171 172 test_type($db, 640, 'DECIMAL(3,2)', -1.01, '-1.01'); 173 174 175 echo "done!\n"; 176?> 177--CLEAN-- 178<?php 179require dirname(__FILE__) . '/mysql_pdo_test.inc'; 180$db = MySQLPDOTest::factory(); 181$db->exec('DROP TABLE IF EXISTS test'); 182?> 183--EXPECT-- 184done! 185