System.Data.SQLite
Check-in [4deb290d23]
Not logged in

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

Overview
Comment:Pickup the SQLite core library 3.29.0 docs from upstream.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 4deb290d232e58504861b16579fa736163bd57c2
User & Date: mistachkin 2019-07-13 18:31:10
Context
2019-07-13
18:35
Update version history docs. check-in: 62de24d8a3 user: mistachkin tags: trunk
18:31
Pickup the SQLite core library 3.29.0 docs from upstream. check-in: 4deb290d23 user: mistachkin tags: trunk
18:28
Update SQLite core library to the 3.29.0 release. check-in: fe3c97a1d8 user: mistachkin tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to Doc/Extra/Core/lang.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>Query Language Understood by SQLite</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_UPSERT.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: upsert</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_aggfunc.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: Aggregate Functions</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_altertable.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: ALTER TABLE</title>
     7      7   <!-- path= -->
     8      8   </head>
................................................................................
   233    233   <b>Compatibility Note:</b>
   234    234   The behavior of ALTER TABLE when renaming a table was enhanced
   235    235   in versions 3.25.0 (2018-09-15) and 3.26.0 (2018-12-01)
   236    236   in order to carry the rename operation forward into triggers and
   237    237   views that reference the renamed table.  This is considered an
   238    238   improvement. Applications that depend on the older (and
   239    239   arguably buggy) behavior can use the
   240         -<a href="pragma.html#pragma_legacy_alter_table">PRAGMA legacy_alter_table=ON</a> statement to make ALTER TABLE RENAME
          240  +<a href="pragma.html#pragma_legacy_alter_table">PRAGMA legacy_alter_table=ON</a> statement or the
          241  +<a href="c3ref/c_dbconfig_defensive.html#sqlitedbconfiglegacyaltertable">SQLITE_DBCONFIG_LEGACY_ALTER_TABLE</a> configuration parameter
          242  +on <a href="c3ref/db_config.html">sqlite3_db_config()</a> interface to make ALTER TABLE RENAME
   241    243   behave as it did prior to version 3.25.0.
   242    244   </blockquote>
   243    245   
   244    246   <p>
   245    247   Beginning with release 3.25.0 (2018-09-15), references to the table
   246    248   within trigger bodies and view definitions are also renamed.
   247    249   </p>
................................................................................
   340    342   <li><p>
   341    343   If foreign key constraints are enabled, disable them using <a href="pragma.html#pragma_foreign_keys">PRAGMA foreign_keys=OFF</a>.
   342    344   
   343    345   <li><p>
   344    346   Start a transaction.
   345    347   
   346    348   <li><p>
   347         -Remember the format of all indexes and triggers associated with table X.
          349  +Remember the format of all indexes, triggers, and views associated with table X.
   348    350   This information will be needed in step 8 below.  One way to do this is
   349    351   to run a query like the following:
   350    352   SELECT type, sql FROM sqlite_master WHERE tbl_name='X'.
   351    353   
   352    354   <li><p>
   353    355   Use <a href="lang_createtable.html">CREATE TABLE</a> to construct a new table "new_X" that is in the desired
   354    356   revised format of table X.  Make sure that the name "new_X" does not collide
................................................................................
   361    363   <li><p>
   362    364   Drop the old table X:  <a href="lang_droptable.html">DROP TABLE X</a>.
   363    365   
   364    366   <li><p>
   365    367   Change the name of new_X to X using: ALTER TABLE new_X RENAME TO X.
   366    368   
   367    369   <li><p>
   368         -Use <a href="lang_createindex.html">CREATE INDEX</a> and <a href="lang_createtrigger.html">CREATE TRIGGER</a> to reconstruct indexes and triggers
   369         -associated with table X.  Perhaps use the old format of the triggers and
   370         -indexes saved from step 3 above as a guide, making changes as appropriate
   371         -for the alteration.
          370  +Use <a href="lang_createindex.html">CREATE INDEX</a>, <a href="lang_createtrigger.html">CREATE TRIGGER</a>, and <a href="lang_createview.html">CREATE VIEW</a>
          371  +to reconstruct indexes, triggers, and views
          372  +associated with table X.  Perhaps use the old format of the triggers,
          373  +indexes, and views saved from step 3 above as a guide, making changes
          374  +as appropriate for the alteration.
   372    375   
   373    376   <li><p>If any views refer to table X in a way that is affected by the
   374    377   schema change, then drop those views using <a href="lang_dropview.html">DROP VIEW</a> and recreate them
   375    378   with whatever changes are necessary to accommodate the schema change
   376    379   using <a href="lang_createview.html">CREATE VIEW</a>.
   377    380   
   378    381   <li><p>
................................................................................
   483    486   
   484    487   <li><p> Commit the transaction started on step 1 above.
   485    488   </ol>
   486    489   
   487    490   <p>If some future version of SQLite adds new ALTER TABLE capabilities, 
   488    491   those capabilities will very likely use one of the two procedures
   489    492   outlined above.
          493  +
          494  +<a name="altertableishard"></a>
          495  +
          496  +<h3>Why ALTER TABLE is such a problem for SQLite</h3>
          497  +
          498  +<p>Most SQL database engines store the schema already parsed into
          499  +various system tables.  On those database engines, ALTER TABLE merely 
          500  +has to make modifications to the corresponding system tables.
          501  +
          502  +<p>SQLite is different in that it stores the schema
          503  +in the <a href="fileformat2.html#sqlite_master">sqlite_master</a> table as the original text of the CREATE
          504  +statements that define the schema.  Hence ALTER TABLE needs
          505  +to revise the text of the CREATE statement.  Doing
          506  +so can be tricky for certain "creative" schema designs.
          507  +
          508  +<p>The SQLite approach of storing the schema as text has advantages
          509  +for an embedded relational database.  For one, it means that the
          510  +schema takes up less space in the database file.  This is important
          511  +since a common SQLite usage pattern is to have many small,
          512  +separate database files instead of putting everything in one
          513  +big global database file, which is the usual approach for client/server
          514  +database engines.
          515  +Since the schema is duplicated in each separate database file, it is
          516  +important to keep the schema representation compact.
          517  +
          518  +<p>Storing the schema as text rather than as parsed tables also
          519  +give flexibility to the implementation.  Since the internal parse
          520  +of the schema is regenerated each time the database is opened, the
          521  +internal representation of the schema can change from one release
          522  +to the next.  This is important, as sometimes new features require
          523  +enhancements to the internal schema representation.  Changing the
          524  +internal schema representation would be much more difficult if the
          525  +schema representation was exposed in the database file.  So, in other
          526  +words, storing the schema as text helps maintain backwards 
          527  +compatibility, and helps ensure that older database files can be
          528  +read and written by newer versions of SQLite.
          529  +
          530  +<p>Storing the schema a text also makes the 
          531  +<a href="fileformat2.html">SQLite database file format</a> easier to define, document, and 
          532  +understand. This helps make SQLite database files a
          533  +<a href="locrsf.html">recommended storage format</a> for long-term archiving of data.
          534  +
          535  +<p>The downside of storing schema a text is that it can make
          536  +the schema tricky to modify.  And for that reason, the ALTER TABLE
          537  +support in SQLite has traditionally lagged behind other SQL
          538  +database engines that store their schemas as parsed system tables
          539  +that are easier to modify.
          540  +
          541  +
   490    542   
   491    543   
   492    544   
   493    545   
   494    546   

Changes to Doc/Extra/Core/lang_analyze.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: ANALYZE</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_attach.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: ATTACH DATABASE</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_comment.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: comment</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_conflict.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: ON CONFLICT clause</title>
     7      7   <!-- path= -->
     8      8   </head>
................................................................................
   152    152   resolution algorithm aborts the current SQL statement with an
   153    153   SQLITE_CONSTRAINT error.  But the FAIL resolution does not
   154    154   back out prior changes of the SQL statement that failed nor does
   155    155   it end the transaction.
   156    156   For example, if an UPDATE
   157    157   statement encountered a constraint violation on the 100th row that
   158    158   it attempts to update, then the first 99 row changes are preserved
   159         -but changes to rows 100 and beyond never occur.</p></dd>
          159  +but changes to rows 100 and beyond never occur.</p>
          160  +
          161  +<p>The FAIL behavior only works for uniqueness, NOT NULL, and CHECK 
          162  +constraints.  A <a href="foreignkeys.html">foreign key constraint</a> violation causes an ABORT.
          163  +</p></dd>
   160    164   
   161    165   <dt><b>IGNORE</b></dt>
   162    166   <dd><p> When an applicable constraint violation occurs, 
   163    167   the IGNORE resolution algorithm skips the one row that contains
   164    168   the constraint violation and continues processing subsequent rows
   165    169   of the SQL statement as if nothing went wrong.
   166    170   Other rows before and after the row that
   167    171   contained the constraint violation are inserted or updated
   168         -normally. No error is returned when the IGNORE conflict resolution
   169         -algorithm is used.</p></dd>
          172  +normally. No error is returned for uniqueness, NOT NULL, and
          173  +UNIQUE constraint errors when the IGNORE conflict resolution
          174  +algorithm is used.  However, the IGNORE conflict resolution
          175  +algorithm works like ABORT for <a href="foreignkeys.html">foreign key constraint</a> errors.
          176  +</p>
          177  +</dd>
   170    178   
   171    179   <dt><b>REPLACE</b></dt>
   172    180   <dd><p> When a <a href="lang_createtable.html#uniqueconst">UNIQUE</a> or <a href="lang_createtable.html#primkeyconst">PRIMARY KEY</a> constraint violation occurs, 
   173    181   the REPLACE algorithm
   174    182   deletes pre-existing rows that are causing the constraint violation
   175    183   prior to inserting or updating the current row and the command continues 
   176    184   executing normally.
   177    185   If a <a href="lang_createtable.html#notnullconst">NOT NULL</a> constraint violation occurs, the REPLACE conflict
   178    186   resolution replaces the NULL value with
   179    187   the default value for that column, or if the column has no default
   180    188   value, then the ABORT algorithm is used.
   181         -If a <a href="lang_createtable.html#ckconst">CHECK</a> constraint violation occurs, the REPLACE conflict resolution
   182         -algorithm always works like ABORT.</p>
          189  +If a <a href="lang_createtable.html#ckconst">CHECK constraint</a> or <a href="foreignkeys.html">foreign key constraint</a> violation occurs, 
          190  +the REPLACE conflict resolution algorithm works like ABORT.</p>
   183    191   
   184    192   <p>When the REPLACE conflict resolution strategy deletes rows in order to
   185    193   satisfy a constraint, <a href="lang_createtrigger.html">delete triggers</a> fire if and only if
   186    194   <a href="pragma.html#pragma_recursive_triggers">recursive triggers</a> are enabled.</p>
   187    195   
   188    196   <p>The <a href="c3ref/update_hook.html">update hook</a> is not invoked for rows that
   189    197   are deleted by the REPLACE conflict resolution strategy.  Nor does

Changes to Doc/Extra/Core/lang_corefunc.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: Core Functions</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_createindex.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: CREATE INDEX</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_createtable.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: CREATE TABLE</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_createtrigger.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: CREATE TRIGGER</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_createview.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: CREATE VIEW</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_createvtab.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: CREATE VIRTUAL TABLE</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_datefunc.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: Date And Time Functions</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_delete.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: DELETE</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_detach.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: DETACH DATABASE</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_dropindex.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: DROP INDEX</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_droptable.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: DROP TABLE</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_droptrigger.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: DROP TRIGGER</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_dropview.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: DROP VIEW</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_explain.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: EXPLAIN</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_expr.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: expression</title>
     7      7   <!-- path= -->
     8      8   </head>
................................................................................
   668    668   <p>If the value of <i>expr</i> is NULL, then the result of the CAST
   669    669   expression is also NULL. Otherwise, the storage class of the result
   670    670   is determined by applying the <a href="datatype3.html#affname">rules for determining column affinity</a> to
   671    671   the <span class='yyterm'>type-name</span>.
   672    672   
   673    673   <table border=1>
   674    674   <tr>
   675         -  <th> Affinity of <span class='yyterm'>type-name</span>
          675  +  <th> Affinity of <span class='yyterm'><nobr>type-name</nobr></span>
   676    676     <th> Conversion Processing
   677    677   <tr>
   678    678     <td> NONE 
   679    679     <td> Casting a value to a <span class='yyterm'>type-name</span> with no affinity 
   680    680     causes the value to
   681    681     be converted into a BLOB.  Casting to a BLOB consists of first casting
   682    682     the value to TEXT in the <a href="pragma.html#pragma_encoding">encoding</a> of the database connection, then
................................................................................
   739    739         casting a REAL value greater than
   740    740         +9223372036854775807.0 into an integer resulted in the most negative
   741    741         integer, -9223372036854775808.  This behavior was meant to emulate the
   742    742         behavior of x86/x64 hardware when doing the equivalent cast.
   743    743   
   744    744   <tr>
   745    745     <td> NUMERIC
   746         -  <td> Casting a TEXT or BLOB value into NUMERIC first does a forced
   747         -   conversion into REAL but then further converts the result into INTEGER if
   748         -   and only if the conversion from REAL to INTEGER is lossless and reversible.
   749         -   This is the only context in SQLite where the NUMERIC and INTEGER <a href="datatype3.html#affinity">affinities</a>
   750         -   behave differently.
          746  +  <td> Casting a TEXT or BLOB value into NUMERIC yields either an INTEGER or
          747  +   a REAL result.
          748  +   If the input text looks like an integer (there is no decimal point nor
          749  +   exponent) and the value is small enough to fit in a 64-bit signed integer,
          750  +   then the result will be INTEGER.
          751  +   Input text that looks like floating point (there is a decimal point and/or
          752  +   an exponent) and the text describes a value that 
          753  +   can be losslessly converted back and forth between IEEE 754 64-bit float and a
          754  +   51-bit signed integer, then the result is INTEGER.
          755  +   (In the previous sentence, a 51-bit integer is specified since that is one
          756  +   bit less than the length of the mantissa of an IEEE 754 64-bit float and
          757  +   thus provides a 1-bit of margin for the text-to-float conversion operation.)
          758  +   Any text input that describes a value outside the range of a 64-bit
          759  +   signed integer yields a REAL result.
   751    760      <p> Casting a REAL or INTEGER value to NUMERIC is a no-op, even if a real
   752    761      value could be losslessly converted to an integer.
   753    762   
   754    763   </tr>
   755    764   
   756    765   </table>
   757    766   

Changes to Doc/Extra/Core/lang_indexedby.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: INDEXED BY</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_insert.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: INSERT</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_keywords.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: SQLite Keywords</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_naming.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: Database Object Name Resolution</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_reindex.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: REINDEX</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_replace.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: REPLACE</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_savepoint.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: SAVEPOINT</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_select.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: SELECT</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_transaction.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: BEGIN TRANSACTION</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_update.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: UPDATE</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_vacuum.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: VACUUM</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/lang_with.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Query Language: WITH clause</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/pragma.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>Pragma statements supported by SQLite</title>
     7      7   <!-- path= -->
     8      8   </head>
................................................................................
   503    503   
   504    504       <p>The default page cache implemention does not allocate
   505    505       the full amount of cache memory all at once.  Cache memory
   506    506       is allocated in smaller chunks on an as-needed basis.  The page_cache
   507    507       setting is a (suggested) upper bound on the amount of memory that the
   508    508       cache can use, not the amount of memory it will use all of the time.
   509    509       This is the behavior of the default page cache implementation, but an
   510         -    <a href="c3ref/pcache_methods2.html">applicaction defined page cache</a> is free
          510  +    <a href="c3ref/pcache_methods2.html">application defined page cache</a> is free
   511    511       to behave differently if it wants.
   512    512   <a name="pragma_cache_spill"></a>
   513    513   <h _id=pragma_cache_spill style="display:none"> PRAGMA cache_spill</h><hr>
   514    514       <p><b>PRAGMA cache_spill;
   515    515            <br>PRAGMA cache_spill=</b><i>boolean</i><b>;
   516    516            <br>PRAGMA </b><i>schema.</i><b>cache_spill=<i>N</i>;</b></p>
   517    517   
................................................................................
  1050   1050       journal to delete.  The OFF journaling mode disables the atomic
  1051   1051       commit and rollback capabilities of SQLite. The <a href="lang_transaction.html">ROLLBACK</a> command
  1052   1052       no longer works; it behaves in an undefined way.  Applications must
  1053   1053       avoid using the <a href="lang_transaction.html">ROLLBACK</a> command when the journal mode is OFF.
  1054   1054       If the application crashes
  1055   1055       in the middle of a transaction when the OFF journaling mode is
  1056   1056       set, then the database file will very likely
  1057         -    <a href="howtocorrupt.html#cfgerr">go corrupt</a>.</p>
         1057  +    <a href="howtocorrupt.html#cfgerr">go corrupt</a>. Without a journal, there is no way for
         1058  +    a statement to unwind partially completed operations following
         1059  +    a constraint error.  This might also leave the database in a corrupted
         1060  +    state.  For example, if a duplicate entry causes a 
         1061  +    <a href="lang_createindex.html">CREATE UNIQUE INDEX</a> statement to fail half-way through,
         1062  +    it will leave behind a partially created, and hence corrupt, index.
         1063  +    Because OFF journaling
         1064  +    mode allows the database file to be corrupted using ordinary SQL,
         1065  +    it is disabled when <a href="c3ref/c_dbconfig_defensive.html#sqlitedbconfigdefensive">SQLITE_DBCONFIG_DEFENSIVE</a> is enabled.</p>
  1058   1066   
  1059   1067       <p>Note that the journal_mode for an <a href="inmemorydb.html">in-memory database</a>
  1060   1068       is either MEMORY or OFF and can not be changed to a different value.
  1061   1069       An attempt to change the journal_mode of an <a href="inmemorydb.html">in-memory database</a> to
  1062   1070       any setting other than MEMORY or OFF is ignored.  Note also that
  1063   1071       the journal_mode cannot be changed while a transaction is active.</p>
  1064   1072   <a name="pragma_journal_size_limit"></a>
................................................................................
  1131   1139       contain code that expect the incomplete behavior
  1132   1140       of <a href="lang_altertable.html#altertabrename">ALTER TABLE RENAME</a> found in older versions of SQLite.
  1133   1141       New applications should leave this flag turned off.
  1134   1142       <p>For compatibility with older <a href="vtab.html">virtual table</a> implementations,
  1135   1143       this flag is turned on temporarily while the <a href="vtab.html#xrename">sqlite3_module.xRename</a>
  1136   1144       method is being run.  The value of this flag is restore after the 
  1137   1145       <a href="vtab.html#xrename">sqlite3_module.xRename</a> method finishes.
         1146  +    <p>The legacy alter table behavior can also be toggled on and off
         1147  +    using the <a href="c3ref/c_dbconfig_defensive.html#sqlitedbconfiglegacyaltertable">SQLITE_DBCONFIG_LEGACY_ALTER_TABLE</a> option to the
         1148  +    <a href="c3ref/db_config.html">sqlite3_db_config()</a> interface.
  1138   1149   <a name="pragma_legacy_file_format"></a>
  1139   1150   <h _id=pragma_legacy_file_format style="display:none"> PRAGMA legacy_file_format</h><hr>
  1140   1151      <p><b>PRAGMA legacy_file_format;
  1141   1152          <br>PRAGMA legacy_file_format = <i>boolean</i></b></p>
  1142   1153       <p>This pragma sets or queries the value of the legacy_file_format
  1143   1154       flag.  When this flag is on, new SQLite databases are created in
  1144   1155       a file format that is readable and writable by all versions of

Changes to Doc/Extra/Core/syntax.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>List of SQLite Syntax Diagrams</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/alter-table-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: alter-table-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/analyze-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: analyze-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/attach-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: attach-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/begin-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: begin-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/column-constraint.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: column-constraint</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/column-def.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: column-def</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/column-name-list.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: column-name-list</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/comment-syntax.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: comment-syntax</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/commit-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: commit-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/common-table-expression.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: common-table-expression</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/compound-operator.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: compound-operator</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/compound-select-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: compound-select-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/conflict-clause.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: conflict-clause</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/create-index-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: create-index-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/create-table-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: create-table-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/create-trigger-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: create-trigger-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/create-view-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: create-view-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/create-virtual-table-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: create-virtual-table-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/cte-table-name.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: cte-table-name</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/delete-stmt-limited.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: delete-stmt-limited</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/delete-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: delete-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/detach-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: detach-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/drop-index-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: drop-index-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/drop-table-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: drop-table-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/drop-trigger-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: drop-trigger-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/drop-view-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: drop-view-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/expr.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: expr</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/factored-select-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: factored-select-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/foreign-key-clause.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: foreign-key-clause</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/indexed-column.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: indexed-column</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/insert-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: insert-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/join-clause.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: join-clause</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/join-constraint.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: join-constraint</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/join-operator.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: join-operator</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/literal-value.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: literal-value</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/numeric-literal.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: numeric-literal</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/ordering-term.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: ordering-term</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/pragma-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: pragma-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/pragma-value.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: pragma-value</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/qualified-table-name.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: qualified-table-name</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/raise-function.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: raise-function</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/recursive-cte.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: recursive-cte</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/reindex-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: reindex-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/release-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: release-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/result-column.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: result-column</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/rollback-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: rollback-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/savepoint-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: savepoint-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/select-core.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: select-core</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/select-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: select-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/signed-number.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: signed-number</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/simple-select-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: simple-select-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/sql-stmt-list.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: sql-stmt-list</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/sql-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: sql-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/table-constraint.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: table-constraint</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/table-or-subquery.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: table-or-subquery</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/type-name.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: type-name</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/update-stmt-limited.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: update-stmt-limited</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/update-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: update-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/vacuum-stmt.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: vacuum-stmt</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntax/with-clause.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="../sqlite.css" rel="stylesheet">
     6      6   <title>SQLite Syntax: with-clause</title>
     7      7   <!-- path=../ -->
     8      8   </head>

Changes to Doc/Extra/Core/syntaxdiagrams.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>Syntax Diagrams For SQLite</title>
     7      7   <!-- path= -->
     8      8   </head>

Changes to Doc/Special/Core/vtab.html.

     1         -<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
            1  +<!DOCTYPE html>
     2      2   <html><head>
     3      3   <meta name="viewport" content="width=device-width, initial-scale=1.0">
     4      4   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
     5      5   <link href="sqlite.css" rel="stylesheet">
     6      6   <title>The Virtual Table Mechanism Of SQLite</title>
     7      7   <!-- path= -->
     8      8   </head>