#42147 [Opn->Fbk]: Possible PDO issue with an SQLite expression

ID: 42147 Updated by: scottmac@php.net Reported By: the at email dot address -Status: Open +Status: Feedback Bug Type: SQLite related Operating System: Windows XP PHP Version: 5.2.3 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows (zip): http://snaps.php.net/win32/php5.2-win32-latest.zip For Windows (installer): http://snaps.php.net/win32/php5.2-win32-installer-latest.msi Previous Comments: ------------------------------------------------------------------------ [2007-12-12 11:29:12] rose dot andrew at gmail dot com Unable to replicate bug on PHP 5.2.5/Linux. ------------------------------------------------------------------------ [2007-07-30 15:16:28] the at email dot address Description: ------------ Using the IN() expression in a statement for SQLite causes a 'SQLSTATE[HY000]' error. I realise SQLite is probably not returning the right errorcode, but the important part is why an error occurs. The same statement in the commandline tool for SQLite, and also works fine with mySQL. Changing the statement to do the same action without an IN() expression ( "WHERE (name='this' OR name='that')" ) causes no error. Since as it's unlikely that the engine is different between the executable and the dll, I can only think of PDO mangling the statement somehow.. Reproduce code: --------------- $q = $db->query( "SELECT * FROM thetable WHERE name IN('this','that')" ); Expected result: ---------------- Listing of all rows where the name matches 'this' or 'that'. Actual result: -------------- Throws an exception: SQLSTATE[HY000]: General error: 14 unable to open database file ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=42147&edit=1