#46212 [Opn->Asn]: SQLite3::exec() with a valid CREATE TABLE fails

From: Date: Wed, 01 Oct 2008 15:56:12 +0000
Subject: #46212 [Opn->Asn]: SQLite3::exec() with a valid CREATE TABLE fails
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-129392@lists.php.net to get a copy of this message 
 ID:               46212
 Updated by:       scottmac@php.net
 Reported By:      kristof dot coomans at telenet dot be
-Status:           Open
+Status:           Assigned
 Bug Type:         SQLite related
 Operating System: Windows XP
 PHP Version:      5.3CVS-2008-10-01 (snap)
-Assigned To:      
+Assigned To:      scottmac
 New Comment:

This works on Linux and Mac but not Windows.


Previous Comments:
------------------------------------------------------------------------

[2008-10-01 15:37:08] kristof dot coomans at telenet dot be

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 this bug report at http://bugs.php.net/?id=46212&edit=1

Thread (7 messages)

« previous php.bugs (#129392) next »