Darren Duncan wrote:
'ROWID' is a special word in SQLite, and implicitly exists for all
tables as its primary key, or as an alias to such. SQLite probably
stripped it out of your explicit declaration because it was redundant.
SQLite lets you use ROWID or OID or _ROWID_ as the implicit integer
primary key on any table. If, however, you use one of those words
as an actual column name, its use as a column name hides its integer
primary key meaning. Or at least that is was is suppose to happen.
To be honest, I'm not sure the test suite checks the case where you
explicitly declare ROWID INTEGER PRIMARY KEY. But I did just try this
myself and I cannot seem to reproduce the problem. Can anybody else
get it to fail?
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
