#40772 [Com]: PDO::query() does not raise exception

ID: 40772 Comment by: dennis at inmarket dot lviv dot ua Reported By: vunnuk_o at ukr dot net Status: Open Bug Type: PDO related Operating System: Win XP PHP Version: 5.2.1 New Comment: Looks like PDO constructor does not like the PDO::ATTR_ERRMODE in the options array. This way works: $conn = new PDO($dsn, $user, $pass); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $conn->query("SELETC * FROM test"); // throws a PDOException However, for SQLite the SQLSTATE still is HY000 instead of 42000 Previous Comments: ------------------------------------------------------------------------ [2007-03-11 15:53:21] vunnuk_o at ukr dot net However, SQLite's errorCode() is HY000... should not be 42000? ------------------------------------------------------------------------ [2007-03-11 15:47:27] vunnuk_o at ukr dot net This happens for MySQL an SQLite ------------------------------------------------------------------------ [2007-03-11 14:42:16] iliaa@php.net What PDO back-end are you using? ------------------------------------------------------------------------ [2007-03-10 18:49:24] vunnuk_o at ukr dot net Description: ------------ PDO::query() does not throw an error when the SQL query contains syntax error Reproduce code: --------------- $pdo = new PDO($dsn, $user, $pass, array(PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION)); $pdo->query("SELETC * FROM test"); Expected result: ---------------- Exception should be raised. Actual result: -------------- Exception is not raised but $pdo->errorCode() reports 42000 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=40772&edit=1