Opened 15 years ago
Closed 15 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)
Change History (4)
by , 15 years ago
Attachment: | Working Data.sqlite added |
---|
by , 15 years ago
Attachment: | Not Working Data.sqlite added |
---|
comment:1 by , 15 years ago
Owner: | changed from | to
---|
comment:2 by , 15 years ago
Milestone: | 3.6.0 → 3.5.0 |
---|---|
Resolution: | → fixed |
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
Reassigning to Romy, to see if this may be has already been fixed in the 3.5 release.