Opened 10 years ago
Closed 10 years ago
#5426 closed defect (fixed)
[PATCH] Date/Time values cannot be inserted into an empty SQLite layer
Reported by: | ermite | Owned by: | warmerdam |
---|---|---|---|
Priority: | normal | Milestone: | 1.11.0 |
Component: | OGR_SF | Version: | svn-trunk |
Severity: | normal | Keywords: | SQLite, Datetime |
Cc: |
Description
The date/time values couldn't be inserted into an empty SQLite layer during my recent experience. The ogrinfo reports the date/time columns as string if the layer is empty. Further testing shows that the column type (retrieved by sqlite3_column_type) is SQLITE_NULL, rather than expected SQLITE_TEXT, therefore the insertion failure. Patch attached.
Attachments (1)
Change History (2)
by , 10 years ago
Attachment: | ogrsqlite20140328.patch added |
---|
comment:1 by , 10 years ago
Milestone: | → 1.11.0 |
---|---|
Resolution: | → fixed |
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
trunk r27102 "SQLite: ensure fields of type DATETIME, DATE or TIME are properly recognized if the table is empty (patch by ermite, #5426)"