After being out of the office for a bit, I came back and thought "My
to-do list is too long." So instead of working on the hardest bit, I
decided to see how many pieces of low-hanging fruit I could knock
off...
So today I'm getting rid of all these to-do items around fts1/2 rowid
breakage and fts3 rowid fixage. The changes are:
- fts1.c will now refuse to build. If you still want to build it,
define SQLITE_ENABLE_BROKEN_FTS1. This was done to make certain
that nobody is unintentially using it.
- Likewise with fts2.c.
- fts3 should work exactly the same as fts2 or fts1, with the
following changes:
- the table-named column is now marked HIDDEN. This means that you
can now do 'SELECT * FROM t' or 'INSERT INTO t VALUES (...)'
against an fts3 table, rather than always being required to
enumerate things.
- I've added a new implicit column, docid, which is an alias of the
fts3 table's rowid. This is meant to mimic how rowid works when
you explicitely alias it. I would like to encourage using docid
rather than rowid, to reduce the chance for future confusion
around these issues. docid is also marked HIDDEN, but should be
usable exactly as rowid.
Building fts3 should be exactly the same as building fts2, except with
the different pathnames. I'm going to try to get some traction on
refactoring the wiki pages this afternoon.
Thanks for your patience,
scott
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
