1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
|
--TEST--
PDO::ATTR_ERRMODE
--SKIPIF--
<?php
require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'skipif.inc');
require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc');
MySQLPDOTest::skip();
$db = MySQLPDOTest::factory();
?>
--INI--
error_reporting=E_ALL
--FILE--
<?php
require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc');
$db = MySQLPDOTest::factory();
$valid = array(PDO::ERRMODE_SILENT, PDO::ERRMODE_WARNING, PDO::ERRMODE_EXCEPTION);
do {
$invalid = mt_rand(-1000, 1000);
} while (in_array($invalid, $valid));
$tmp = array();
if (false != @$db->setAttribute(PDO::ATTR_ERRMODE, $tmp))
printf("[001] Maybe PDO could indicate that this is not a proper way of setting the ERRMODE...\n");
$tmp = new stdClass();
$ret = @$db->setAttribute(PDO::ATTR_ERRMODE, $tmp);
if (false != $ret)
printf("[002] Maybe PDO could indicate that this is not a proper way of setting the ERRMODE...%s\n",
var_export($ret, true));
$ret = @$db->setAttribute(PDO::ATTR_ERRMODE, 'pdo');
if (false != $ret)
printf("[003] Maybe PDO could indicate that this is not a proper way of setting the ERRMODE...%s\n",
var_export($ret, true));
if (false != @$db->setAttribute(PDO::ATTR_ERRMODE, $invalid))
printf("[004] Invalid ERRMODE should be rejected\n");
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
// no message for any PDO call but...
$db->query('THIS IS NOT VALID SQL');
// ... still messages for everything else
$code = $db->errorCode();
$info = $db->errorInfo();
if ($code != '42000')
printf("[005] Expecting SQL code 42000 got '%s'\n", $code);
if ($code !== $info[0])
printf("[006] Code and info should be identical, got errorCode() = %s, errorInfo()[0] = %s\n",
$code, $info[0]);
if ('' == $info[1])
printf("[007] Driver specific error code not set\n");
if ('' == $info[2])
printf("[008] Driver specific error message not set\n");
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
$db->query('THIS IS NOT VALID SQL');
$code = $db->errorCode();
$info = $db->errorInfo();
if ($code != '42000')
printf("[009] Expecting SQL code 42000 got '%s'\n", $code);
if ($code !== $info[0])
printf("[010] Code and info should be identical, got errorCode() = %s, errorInfo()[0] = %s\n",
$code, $info[0]);
if ('' == $info[1])
printf("[011] Driver specific error code not set\n");
if ('' == $info[2])
printf("[012] Driver specific error message not set\n");
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
try {
$line = __LINE__ + 1;
$db->query('THIS IS NOT VALID SQL');
} catch (PDOException $e) {
$code = $db->errorCode();
$info = $db->errorInfo();
if ($code != '42000')
printf("[013] Expecting SQL code 42000 got '%s'\n", $code);
if ($code !== $info[0])
printf("[014] Code and info should be identical, got errorCode() = %s, errorInfo()[0] = %s\n",
$code, $info[0]);
if ('' == $info[1])
printf("[015] Driver specific error code not set\n");
if ('' == $info[2])
printf("[016] Driver specific error message not set\n");
if ($e->getCode() !== $code)
printf("[017] Exception code '%s' differs from errorCode '%s'\n",
$e->getCode(), $code);
$msg = $e->getMessage();
foreach ($info as $k => $v) {
if (false === stristr($msg, (string)$v)) {
printf("[018] Cannot find all parts of the error info ('%s') in the exception message '%s'\n",
$v, $msg);
}
}
if ($e->getLine() !== $line)
printf("[019] Exception has been thrown in line %d, exception object reports line %d\n",
$line, $e->getLine());
if ($e->getFile() !== __FILE__)
printf("[020] Exception has been thrown in file '%s', exception object reports file '%s'\n",
__FILE__, $e->getFile());
}
function my_handler($e) {
global $db, $line;
$code = $db->errorCode();
$info = $db->errorInfo();
if ($code != '42000')
printf("[021] Expecting SQL code 42000 got '%s'\n", $code);
if ($code !== $info[0])
printf("[022] Code and info should be identical, got errorCode() = %s, errorInfo()[0] = %s\n",
$code, $info[0]);
if ('' == $info[1])
printf("[023] Driver specific error code not set\n");
if ('' == $info[2])
printf("[024] Driver specific error message not set\n");
if ($e->getCode() !== $code)
printf("[025] Exception code '%s' differs from errorCode '%s'\n",
$e->getCode(), $code);
$msg = $e->getMessage();
foreach ($info as $k => $v) {
if (false === stristr($msg, (string)$v)) {
printf("[026] Cannot find all parts of the error info ('%s') in the exception message '%s'\n",
$v, $msg);
}
}
if ($e->getLine() !== $line)
printf("[027] Exception has been thrown in line %d, exception object reports line %d\n",
$line, $e->getLine());
if ($e->getFile() !== __FILE__)
printf("[028] Exception has been thrown in file '%s', exception object reports file '%s'\n",
__FILE__, $e->getFile());
if (get_class($e) != 'PDOException')
printf("[029] Expecting PDO exception got exception of type '%s'\n", get_class($e));
print "\nend of execution";
}
set_exception_handler('my_handler');
$line = __LINE__ + 1;
$db->query('THIS IS NOT VALID SQL');
print "done!\n";
--EXPECTF--
[003] Maybe PDO could indicate that this is not a proper way of setting the ERRMODE...true
Warning: PDO::query(): SQLSTATE[42000]: Syntax error or access violation: %d You have an error in your SQL syntax; check the manual that corresponds to your %s server version for the right syntax to use near '%s' at line %d in %s on line %d
end of execution
|
