From: kristof dot coomans at telenet dot be Operating system: Windows XP PHP version: 5.3CVS-2008-10-01 (snap) PHP Bug Type: SQLite related Bug description: SQLite3::exec() with a valid CREATE TABLE fails
Description: ------------ SQLite3::exec with valid query fails with the error message "SQL logic error or missing database". Actually testing with http://snaps.php.net/win32/php5.3-win32-200809251104.zip since there is no snapshot for win32 yet for today. Reproduce code: --------------- <?php @unlink( 'test.sqlite3.db' ); $cn = new SQLite3( 'test.sqlite3.db' ); $sql = "CREATE TABLE ezcontentclass_attribute ( can_translate INTEGER(11) DEFAULT '1', contentclass_id INTEGER(11) NOT NULL DEFAULT '0', data_float1 float DEFAULT NULL, data_float2 float DEFAULT NULL, data_float3 float DEFAULT NULL, data_float4 float DEFAULT NULL, data_int1 INTEGER(11) DEFAULT NULL, data_int2 INTEGER(11) DEFAULT NULL, data_int3 INTEGER(11) DEFAULT NULL, data_text1 varchar(50) DEFAULT NULL, data_text2 varchar(50) DEFAULT NULL, data_text3 varchar(50) DEFAULT NULL, data_text5 longtext, data_type_string varchar(50) NOT NULL DEFAULT '', id INTEGER, identifier varchar(50) NOT NULL DEFAULT '', is_information_collector INTEGER(11) NOT NULL DEFAULT '0', is_required INTEGER(11) NOT NULL DEFAULT '0', is_searchable INTEGER(11) NOT NULL DEFAULT '0', placement INTEGER(11) NOT NULL DEFAULT '0', serialized_name_list longtext NOT NULL, version INTEGER(11) NOT NULL DEFAULT '0', PRIMARY KEY ( id, version ) )"; $succes = @$cn->exec( $sql ); if ( !$succes ) { print( "Error " . $cn->lastErrorCode() . ": " . $cn->lastErrorMsg() . PHP_EOL ); } ?> Expected result: ---------------- The script should finish without any warnings. Executing the sql with the sqlite3 command line client works fine. Actual result: -------------- Error 1: SQL logic error or missing database -- Edit bug report at http://bugs.php.net/?id=46212&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=46212&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=46212&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=46212&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=46212&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=46212&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=46212&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=46212&r=needscript Try newer version: http://bugs.php.net/fix.php?id=46212&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=46212&r=support Expected behavior: http://bugs.php.net/fix.php?id=46212&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=46212&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=46212&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=46212&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=46212&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=46212&r=dst IIS Stability: http://bugs.php.net/fix.php?id=46212&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=46212&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=46212&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=46212&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=46212&r=mysqlcfg