On Mon, 31 Jan 2011 11:46:21 -0500, Samuel Adam <a...@certifound.com> wrote:
> On Mon, 31 Jan 2011 11:05:13 -0500, Simon Slavin <slav...@bigfraud.org> > wrote: > >> In the definition given in the original post, which I quoted, the table >> was defined as follows: >> >>> CREATE VIRTUAL TABLE Directors USING fts3(id INTEGER PRIMARY KEY NOT >>> NULL, first_name TEXT NOT NULL, last_name TEXT NOT NULL, >>> show_last_name_first INTEGER DEFAULT 0, normalised_name TEXT NOT NULL, >>> sort_name TEXT NOT NULL, fanships_count INTEGER, image_url >>> VARCHAR(255)); >> >> Under this situation, would SQLite not use 'id' as an alias to rowid ? […] > You were right; I was wrong. I saw FTS3 and somehow missed the PK > definition. Spoke too soon. SQLite actually ignores the PK definition, and does *not* use "id" as an alias for the rowid. Evidence coming in another post; I think I found a bug. Very truly, Samuel Adam <a...@certifound.com> 763 Montgomery Road Hillsborough, NJ 08844-1304 • United States http://certifound.com/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users