Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Added the fts4aux languageid column. Fix typos in famous.html |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
cd0e9d17ed3823bcea5d6e413b450c77 |
User & Date: | drh 2013-10-15 19:08:14.018 |
Context
2013-10-16
| ||
23:58 | Fix typos in documentation. (check-in: df95e4e1ec user: drh tags: trunk) | |
2013-10-15
| ||
19:08 | Added the fts4aux languageid column. Fix typos in famous.html (check-in: cd0e9d17ed user: drh tags: trunk) | |
2013-10-14
| ||
21:20 | Move the tointeger() and toreal() functions into an extension. (check-in: 6218782fda user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
40 41 42 43 44 45 46 47 48 49 50 51 52 53 | <li>The [Date And Time Functions] are enhanced so that the current time (ex: julianday('now')) is always the same for multiple function invocations within the same [sqlite3_step()] call. <li>Add the "totype.c" extension, implementing the tointeger() and toreal() SQL functions. <li>[FTS4] queries are better able to make use of docid<$limit constraints to limit the amount of I/O required. <li>The [VACUUM] command packs the database about 1% tighter. <li>The sqlite3_analyzer utility program is updated to provide better descriptions and to compute a more accurate estimate for "Non-sequential pages" <li>Refactor the implementation of PRAGMA statements to improve parsing performance. <li>The directory used to hold temporary files on unix can now be set using the SQLITE_TMPDIR environment variable, which takes precedence over the TMPDIR environment variable. The [sqlite3_temp_directory] global variable | > | 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 | <li>The [Date And Time Functions] are enhanced so that the current time (ex: julianday('now')) is always the same for multiple function invocations within the same [sqlite3_step()] call. <li>Add the "totype.c" extension, implementing the tointeger() and toreal() SQL functions. <li>[FTS4] queries are better able to make use of docid<$limit constraints to limit the amount of I/O required. <li>Added the hidden [fts4aux languageid column] to the [fts4aux] virtual table. <li>The [VACUUM] command packs the database about 1% tighter. <li>The sqlite3_analyzer utility program is updated to provide better descriptions and to compute a more accurate estimate for "Non-sequential pages" <li>Refactor the implementation of PRAGMA statements to improve parsing performance. <li>The directory used to hold temporary files on unix can now be set using the SQLITE_TMPDIR environment variable, which takes precedence over the TMPDIR environment variable. The [sqlite3_temp_directory] global variable |
︙ | ︙ |
Changes to pages/famous.in.
︙ | ︙ | |||
147 148 149 150 151 152 153 | <tr><td valign="top"> <a href="http://www.microsoft.com/"> <img src="images/foreignlogos/microsoft.gif" border="0"></a> </td> <td> | | | 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 | <tr><td valign="top"> <a href="http://www.microsoft.com/"> <img src="images/foreignlogos/microsoft.gif" border="0"></a> </td> <td> It can be inferred from [http://www.mail-archive.com/sqlite-users@sqlite.org/msg19226.html | traffic on the SQLite mailing list] that at least one group within [http://www.microsoft.com/ | Microsoft] is using SQLite in the development of a game program. No word yet if this game has actually been released or if they are still using SQLite. </td> |
︙ | ︙ |
Changes to pages/fts3.in.
︙ | ︙ | |||
1271 1272 1273 1274 1275 1276 1277 1278 1279 1280 1281 1282 1283 1284 | <br><br> If the "col" column contains the value '*', then this column contains the total number of instances of the term in all rows of the FTS table (in any column). Otherwise, if col contains an integer value, then this column contains the total number of instances of the term that appear in the FTS table column identified by the col value. </table> <p> For example, using the tables created above: <codeblock> INSERT INTO ft(x, y) VALUES('Apple banana', 'Cherry'); | > > > > > > > > > > > | 1271 1272 1273 1274 1275 1276 1277 1278 1279 1280 1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 | <br><br> If the "col" column contains the value '*', then this column contains the total number of instances of the term in all rows of the FTS table (in any column). Otherwise, if col contains an integer value, then this column contains the total number of instances of the term that appear in the FTS table column identified by the col value. <tr><td>languageid <i>(hidden)</i><td> <tcl>hd_fragment f4alid {fts4aux languageid column}</tcl> This column determines which [languageid] is used to extract vocabulary from the FTS3/4 table. <br><br> The default value for languageid is 0. If an alternative language is specified in WHERE clause constraints, then that alternative is used instead of 0. There can only be a single languageid per query. In other words, the WHERE clause cannot contain a range constraint or IN operator on the languageid. </table> <p> For example, using the tables created above: <codeblock> INSERT INTO ft(x, y) VALUES('Apple banana', 'Cherry'); |
︙ | ︙ | |||
1676 1677 1678 1679 1680 1681 1682 | <p> This command may also be used with ordinary FTS4 tables, for example if the implementation of the tokenizer changes. It is an error to attempt to rebuild the full-text index maintained by a contentless FTS4 table, since no content will be available to do the rebuilding. | | | 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 | <p> This command may also be used with ordinary FTS4 tables, for example if the implementation of the tokenizer changes. It is an error to attempt to rebuild the full-text index maintained by a contentless FTS4 table, since no content will be available to do the rebuilding. <tcl>hd_fragment *fts4languageid languageid {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 |
︙ | ︙ |