#46212 [NEW]: SQLite3::exec() with a valid CREATE TABLE fails

From: Date: Wed, 01 Oct 2008 15:37:09 +0000
Subject: #46212 [NEW]: SQLite3::exec() with a valid CREATE TABLE fails
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-129391@lists.php.net to get a copy of this message 
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

Thread (7 messages)

« previous php.bugs (#129391) next »