Documentation Source Text

Check-in [cd0e9d17ed]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Added the fts4aux languageid column. Fix typos in famous.html
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:cd0e9d17ed3823bcea5d6e413b450c773bf36bc2
User & Date: drh 2013-10-15 19:08:14
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

    40     40   <li>The [Date And Time Functions] are enhanced so that the current time
    41     41       (ex: julianday('now')) is always the same for multiple function invocations
    42     42       within the same [sqlite3_step()] call.
    43     43   <li>Add the "totype.c" extension, implementing the tointeger() and toreal()
    44     44       SQL functions.
    45     45   <li>[FTS4] queries are better able to make use of docid<$limit constraints to
    46     46       limit the amount of I/O required.
           47  +<li>Added the hidden [fts4aux languageid column] to the [fts4aux] virtual table.
    47     48   <li>The [VACUUM] command packs the database about 1% tighter.
    48     49   <li>The sqlite3_analyzer utility program is updated to provide better descriptions
    49     50       and to compute a more accurate estimate for "Non-sequential pages"
    50     51   <li>Refactor the implementation of PRAGMA statements to improve parsing performance.
    51     52   <li>The directory used to hold temporary files on unix can now be set using
    52     53       the SQLITE_TMPDIR environment variable,  which takes precedence over the
    53     54       TMPDIR environment variable.  The [sqlite3_temp_directory] global variable

Changes to pages/famous.in.

   147    147   
   148    148   
   149    149   <tr><td valign="top">
   150    150   <a href="http://www.microsoft.com/">
   151    151   <img src="images/foreignlogos/microsoft.gif" border="0"></a>
   152    152   </td>
   153    153   <td>
   154         -It can inferred from 
          154  +It can be inferred from 
   155    155   [http://www.mail-archive.com/sqlite-users@sqlite.org/msg19226.html | traffic on the SQLite mailing list]
   156    156   that at least one group within 
   157    157   [http://www.microsoft.com/ | Microsoft]
   158    158   is using SQLite in the development of a 
   159    159   game program. No word yet if this game has actually been released or
   160    160   if they are still using SQLite.
   161    161   </td>

Changes to pages/fts3.in.

  1271   1271       <br><br>
  1272   1272       If the "col" column contains the value '*', then this column
  1273   1273       contains the total number of instances of the term in all rows of the 
  1274   1274       FTS table (in any column). Otherwise, if col contains an integer
  1275   1275       value, then this column contains the total number of instances of the
  1276   1276       term that appear in the FTS table column identified by the col
  1277   1277       value.
         1278  +
         1279  +  <tr><td>languageid <i>(hidden)</i><td>
         1280  +    <tcl>hd_fragment f4alid {fts4aux languageid column}</tcl>
         1281  +    This column determines which [languageid] is used to
         1282  +    extract vocabulary from the FTS3/4 table.
         1283  +    <br><br>
         1284  +    The default value for languageid is 0.  If an alternative language
         1285  +    is specified in WHERE clause constraints, then that alternative is
         1286  +    used instead of 0.  There can only be a single languageid per query.
         1287  +    In other words, the WHERE clause cannot contain a range constraint
         1288  +    or IN operator on the languageid.
  1278   1289   </table>
  1279   1290   
  1280   1291   <p>
  1281   1292     For example, using the tables created above:
  1282   1293   
  1283   1294   <codeblock>
  1284   1295     INSERT INTO ft(x, y) VALUES('Apple banana', 'Cherry');
................................................................................
  1676   1687   <p>
  1677   1688     This command may also be used with ordinary FTS4 tables, for example if
  1678   1689     the implementation of the tokenizer changes.  It is an
  1679   1690     error to attempt to rebuild the full-text index maintained by a contentless
  1680   1691     FTS4 table, since no content will be available to do the rebuilding.
  1681   1692   
  1682   1693   
  1683         -<tcl>hd_fragment *fts4languageid {FTS4 languageid option}</tcl>
         1694  +<tcl>hd_fragment *fts4languageid languageid {FTS4 languageid option}</tcl>
  1684   1695   <h2 tags="fts4 languageid option">The languageid= option</h2>
  1685   1696   
  1686   1697   <p>
  1687   1698     When the languageid option is present, it specifies the name of
  1688   1699     another [hidden column] that is added to the FTS4
  1689   1700     table and which is used to specify the language stored in each row
  1690   1701     of the FTS4 table.  The name of the languageid hidden column must