I'd love to do fts2_1, because it implies fts1_1, but, really, 2_1 implies that the data would be backward-compatible, and maybe there's just a new feature exposed or something.
-scott On 8/14/07, Samuel R. Neff <[EMAIL PROTECTED]> wrote: > > +1 for fts3 or fts2_1 :-) > > ------------------------------------------- > We're Hiring! Seeking a passionate developer to join our team building > products. Position is in the Washington D.C. metro area. If interested > contact [EMAIL PROTECTED] > > -----Original Message----- > From: Scott Hess [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 14, 2007 8:22 PM > To: [EMAIL PROTECTED] > Cc: sqlite-users@sqlite.org > Subject: Re: [sqlite] ALTER TABLE and INTEGER PRIMARY KEY. > > On 8/14/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > "Scott Hess" <[EMAIL PROTECTED]> wrote: > > > I was getting ready to checkin the rowid-versus-fts2 fix, and wanted > > > to add one last bit, to upgrade older tables. > > > > > > Unfortunately, code of the form: > > > > > > ALTER TABLE x_segments ADD id INTEGER PRIMARY KEY; > > > > > > is documented as not supported. > > > http://www.sqlite.org/lang_altertable.html . As far as I can tell, > > > this means that there is no option to do a cheap schema upgrade to get > > > the correct semantics. Am I missing a trick? > > > > It appears that you can set > > > > PRAGMA writable_schema=ON; > > > > Then do a manual UPDATE of the sqlite_master table to insert > > an "id INTEGER PRIMARY KEY" into the SQL for the table definition. > > I tried it and it seems to work. But it is dangerous. If you > > mess up, you corrupt the database file. > > Ooh, I think that tips me away from fixing fts2, because it's scary > and Google Gears disables PRAGMA. > > At least Joe threw in a vote for just versioning things to fts3 - > anyone want to vote against? > > -scott > > ---------------------------------------------------------------------------- > - > To unsubscribe, send email to [EMAIL PROTECTED] > ---------------------------------------------------------------------------- > - > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
