#35248 [Ver->Asn]: sqlite_query() doesnt set error_msg

ID: 35248 Updated by: sniper@php.net Reported By: jwellis at carlalbert dot edu -Status: Verified +Status: Assigned Bug Type: SQLite related Operating System: * PHP Version: 5.1.0RC5 -Assigned To: +Assigned To: wez New Comment: As far as I can tell, this is intentional. Perhaps Wez can share a light on the reasoning behind it though. (so that our brave documenters can do their work :) Previous Comments: ------------------------------------------------------------------------ [2005-11-16 23:28:26] jwellis at carlalbert dot edu Description: ------------ When setting the result of sqlite_query to a result set, if there is an error, error_msg is not set. Example: $result = $db->query("asdfesdfa", SQLITE_NUM, $db_error); i would like to note, however, that if i dont set the results into a result set, it works just fine. Example: $db->query("asdfesdfa", SQLITE_NUM, $db_error); Reproduce code: --------------- $db = new SQLiteDatabase("sqlite_db1"); $result = $db->query("asdfesdfa", SQLITE_NUM, $db_error); print">> $db_error<br>\n"; $db->query("asdfesdfa", SQLITE_NUM, $db_error); print">> $db_error<br>\n"; Expected result: ---------------- >> near "asdfesdfa": syntax error >> near "asdfesdfa": syntax error Actual result: -------------- >> >> near "asdfesdfa": syntax error ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=35248&edit=1