Annotation of embedaddon/php/ext/pdo_mysql/tests/pdo_mysql_types.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: MySQL PDO->exec(), native types wo ZEROFILL
3: --SKIPIF--
4: <?php
5: require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'skipif.inc');
6: require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc');
7: MySQLPDOTest::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
179: require dirname(__FILE__) . '/mysql_pdo_test.inc';
180: $db = MySQLPDOTest::factory();
181: $db->exec('DROP TABLE IF EXISTS test');
182: ?>
183: --EXPECTF--
184: done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>