#35248 [Opn->Ver]: sqlite_query() doesnt set error_msg
| From: | tony2001@php.net | Date: | Wed, 16 Nov 2005 22:42:46 +0000 |
| Subject: | #35248 [Opn->Ver]: sqlite_query() doesnt set error_msg | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-88326@lists.php.net to get a copy of this message | ||
ID: 35248
Updated by: tony2001@php.net
Reported By: jwellis at carlalbert dot edu
-Status: Open
+Status: Verified
Bug Type: SQLite related
Operating System: *
PHP Version: 5.1.0RC5
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