[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