[fdo-trac] #618: sqlite providers breaks on autoincrement not null in primary key

FDO trac_fdo at osgeo.org
Tue Feb 23 05:54:35 EST 2010


#618: sqlite providers breaks on autoincrement not null in primary key
-------------------------------+--------------------------------------------
   Reporter:  bigs             |       Owner:  traianstanev
       Type:  defect           |      Status:  new         
   Priority:  minor            |   Milestone:  3.6.0       
  Component:  SQLite Provider  |     Version:  3.4.0       
   Severity:  3                |    Keywords:              
External_id:                   |  
-------------------------------+--------------------------------------------
 SQL that does not work:[[BR]]
 CREATE TABLE ESDHData ( "ID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
 "GEOMETRY" BLOB)[[BR]]
 [[BR]]
 SQL that works:[[BR]]
 CREATE TABLE ESDHData ( "ID" INTEGER PRIMARY KEY, "GEOMETRY" BLOB)[[BR]]
 [[BR]]
 If I create an SQLite table with the first statement I get a
 MgUnclassifiedException, if I use the second all works.

 Attached are working and non-working example databases.

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/618>
FDO <http://fdo.osgeo.org/>
Feature Data Objects


More information about the fdo-trac mailing list