On Thu, Apr 21, 2005 at 12:07:24PM -0500, William Hachfeld wrote: > I've recently tried to upgrade from SQLite 3.0.8 to 3.2.1 and have run into a > snag. This is probably something REAL simple that I'm just not seeing. I'm > hoping someone can point out my stupid mistake... > > When I rebuild our project with 3.2.1 instead of 3.0.8, I'm getting a syntax > error, where none previously existed, while constructing a database. I've > found > that I can reproduce this same behavior by executing the identical SQL > statements using the "sqlite3" command interface: > > sqlite> CREATE TABLE Statements (id INTEGER PRIMARY KEY, linked_object > INTEGER, file INTEGER, line INTEGER, column INTEGER); > SQL error: near "column": syntax error > > sqlite> > > > > In the above, "tmp.db" did not exist prior to the execution of "sqlite3". > Where > is the syntax error near "column" in the last line?
I wonder if 'column' is now reserved with the addition of ALTER TABLE ADD COLUMN.