Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix typos in the FTS4 languageid option documentation. Add entries to the 3.7.11 change log. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
eb26f055740ee53aa837f66b1f4fa41d |
| User & Date: | drh 2012-03-05 19:40:00.633 |
Context
|
2012-03-06
| ||
| 13:11 | Tweaks to the FTS4 documentation. Add Bentley to the sponsor list on the front page. (check-in: 39b1d19256 user: drh tags: trunk) | |
|
2012-03-05
| ||
| 19:40 | Fix typos in the FTS4 languageid option documentation. Add entries to the 3.7.11 change log. (check-in: eb26f05574 user: drh tags: trunk) | |
| 19:14 | Documentation for the content= and langaugeid= options for FTS4. (check-in: 16b58c9eb4 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
| ︙ | ︙ | |||
48 49 50 51 52 53 54 55 56 57 58 59 60 61 |
<li>Enhance the [CREATE VIRTUAL TABLE] command to support the
IF NOT EXISTS clause.
<li>Added the [sqlite3_stricmp()] interface as a counterpart to
[sqlite3_strnicmp()].
<li>Added the [SQLITE_FCNTL_PRAGMA] file control, giving [VFS] implementations
the ability to add new [PRAGMA] statements or to override built-in
PRAGMAs.
}
chng {2012 January 16 (3.7.10)} {
<li>The default [schema format number] is changed from 1 to 4.
This means that, unless
the [PRAGMA legacy_file_format | PRAGMA legacy_file_format=ON] statement is
run, newly created database files will be unreadable by version of SQLite
| > > > > > > | 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 |
<li>Enhance the [CREATE VIRTUAL TABLE] command to support the
IF NOT EXISTS clause.
<li>Added the [sqlite3_stricmp()] interface as a counterpart to
[sqlite3_strnicmp()].
<li>Added the [SQLITE_FCNTL_PRAGMA] file control, giving [VFS] implementations
the ability to add new [PRAGMA] statements or to override built-in
PRAGMAs.
<li>Queries of the form: "SELECT max(x), y FROM table" returns the
value of y on the same row that contains the maximum x value.
<li>Added support for the [FTS4 languageid option].
<li>Documented support for the [FTS4 content option]. This feature has
actually been in the code since [version 3.7.9] but is only now considered
to be officially supported.
}
chng {2012 January 16 (3.7.10)} {
<li>The default [schema format number] is changed from 1 to 4.
This means that, unless
the [PRAGMA legacy_file_format | PRAGMA legacy_file_format=ON] statement is
run, newly created database files will be unreadable by version of SQLite
|
| ︙ | ︙ |
Changes to pages/fts3.in.
| ︙ | ︙ | |||
1652 1653 1654 1655 1656 1657 1658 | <p> This command may also be used with ordinary FTS4 tables, although it may only be useful if the full-text index has somehow become corrupt. It is an error to attempt to rebuild the full-text index maintained by a contentless FTS4 table. | | | | 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 |
<p>
This command may also be used with ordinary FTS4 tables, although it may
only be useful if the full-text index has somehow become corrupt. It is an
error to attempt to rebuild the full-text index maintained by a contentless
FTS4 table.
<tcl>hd_fragment *fts4languageid {FTS4 languageid option}</tcl>
<h2 tags="fts4 languageid option">The languageid= option</h2>
<p>
When the languageid option is present, it specifies the name of
another [hidden column] that is added to the FTS4
table and which is used to specify the language stored in each row
of the FTS4 table. The name of the languageid hidden column must
be distinct from all other column names in the FTS4 table. Example:
<codeblock>
CREATE VIRTUAL TABLE t1 USING fts4(x, y, languageid="lid")
|
| ︙ | ︙ |