Opened 14 years ago

Closed 14 years ago

#618 closed defect (fixed)

sqlite providers breaks on autoincrement not null in primary key

Reported by: bigs Owned by: romicadascalescu
Priority: minor Milestone: 3.5.0
Component: SQLite Provider Version: 3.4.0
Severity: 3 Keywords:
Cc: External ID:

Description

SQL that does not work:
CREATE TABLE ESDHData ( "ID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "GEOMETRY" BLOB)

SQL that works:
CREATE TABLE ESDHData ( "ID" INTEGER PRIMARY KEY, "GEOMETRY" BLOB)

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.

Attachments (2)

Working Data.sqlite (192.0 KB ) - added by bigs 14 years ago.
Not Working Data.sqlite (160.0 KB ) - added by bigs 14 years ago.

Download all attachments as: .zip

Change History (4)

by bigs, 14 years ago

Attachment: Working Data.sqlite added

by bigs, 14 years ago

Attachment: Not Working Data.sqlite added

comment:1 by traianstanev, 14 years ago

Owner: changed from traianstanev to romicadascalescu

Reassigning to Romy, to see if this may be has already been fixed in the 3.5 release.

comment:2 by romicadascalescu, 14 years ago

Milestone: 3.6.03.5.0
Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.