denys <[EMAIL PROTECTED]> wrote: > > Here is the statement: > CREATE TABLE Media (id INTEGER PRIMARY KEY, keywords TEXT, original > INTEGER, used INTEGER, picture TEXT, note INTEGER, comment BLOB, note > INTEGER, type INTEGER, idSpec INTEGER); > > Assertion failed: pCol->zType==0, file build.c, line 955 > > I'm using SQLite 3.2.2 under Windows XP. > Does anyone see what could be wrong with that?? >
The column named "note" appears twice. This tickled a bug in the parser that was fixed by check-in [2684]. See http://www.sqlite.org/cvstrac/tktview?tn=1418 -- D. Richard Hipp <[EMAIL PROTECTED]>
