Documentation Source Text

<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

<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

<tr><td valign="top">
<a href="http://www.microsoft.com/">
<img src="images/foreignlogos/microsoft.gif" border="0"></a>
</td>
<td>
It can 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>

<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>

    <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');
................................................................................
<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 {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

    <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');
................................................................................
<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