Opened 12 years ago
Closed 6 years ago
#1930 closed defect (wontfix)
Quote column names when creating tables via sqlite
Reported by: | scw | Owned by: | |
---|---|---|---|
Priority: | normal | Milestone: | 7.0.7 |
Component: | Database | Version: | unspecified |
Keywords: | sqlite, SQL | Cc: | |
CPU: | Unspecified | Platform: | Unspecified |
Description
I have an input table which includes the column 'unique', and it failed to import, with the error:
DBMI-SQLite driver error: Error in sqlite3_prepare(): near "varchar": syntax error
This is due to "unique" being a reserved keyword in SQLite. This can be fixed by quoting column names prior to passing them to SQLite, see this page for details:
Change History (7)
comment:1 by , 12 years ago
Component: | Default → Database |
---|---|
Keywords: | sqlite added |
comment:2 by , 11 years ago
Keywords: | SQL added |
---|
comment:3 by , 8 years ago
Milestone: | 7.0.0 → 7.0.5 |
---|
comment:4 by , 8 years ago
Milestone: | 7.0.5 → 7.0.6 |
---|
comment:5 by , 7 years ago
Milestone: | 7.0.6 → 7.0.7 |
---|
comment:7 by , 6 years ago
Resolution: | → wontfix |
---|---|
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
For SQL reserved word collisions, see also #1755 and #578