System.Data.SQLite
Check-in [f453665b94]
Not logged in

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

Overview
Comment:Pickup the SQLite core library 3.19.1 docs from upstream.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:f453665b94762585624fc8d33dd3b5b8a3d97bc8
User & Date: mistachkin 2017-05-24 19:25:48
Context
2017-06-10
17:38
Merge updates from trunk. check-in: 091bc3a48a user: mistachkin tags: branch-1.0.105
2017-05-25
18:52
Update SQLite core library to the 3.19.2 release. check-in: 4f5c9aa89f user: mistachkin tags: trunk
2017-05-24
19:25
Pickup the SQLite core library 3.19.1 docs from upstream. check-in: f453665b94 user: mistachkin tags: trunk
19:24
Update SQLite core library to the 3.19.1 release. check-in: 44ad7c70f0 user: mistachkin tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

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

751
752
753
754
755
756
757
758

759
760
761
762
763
764
765
....
1267
1268
1269
1270
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
1296
1297
....
1396
1397
1398
1399
1400
1401
1402
1403
1404
1405
1406
1407
1408
1409
1410

    <p>The foreign_key_check pragma checks the database, or the table
    called "<i>table-name</i>", for 
    <a href="foreignkeys.html">foreign key constraints</a> that are violated and returns one row of
    output for each violation.  There are four columns in each result row.
    The first column is the name of the table that contains the REFERENCES
    clause.  The second column is the <a href="lang_createtable.html#rowid">rowid</a> of the row that
    contains the invalid REFERENCES clause.  The third column is the name

    of the table that is referred to. The fourth column is the index of
    the specific foreign key constraint that failed.  The fourth column
    in the output of the foreign_key_check pragma is the same integer as
    the first column in the output of the <a href="pragma.html#pragma_foreign_key_list">foreign_key_list pragma</a>.
    When a "<i>table-name</i>" is specified, the only foreign key constraints
    checked are those created by REFERENCES clauses in the
    CREATE TABLE statement for <i>table-name</i>.</p>
................................................................................
<h _id=pragma_page_size style="display:none"> PRAGMA page_size</h><hr>
   <p><b>PRAGMA </b><i>schema.</i><b>page_size;
       <br>PRAGMA </b><i>schema.</i><b>page_size = </b><i>bytes</i><b>;</b></p>
    <p>Query or set the page size of the database. The page
    size must be a power of two between 512 and 65536 inclusive.
    </p>

    <p>When a new database is created, SQLite assigned a page size to
    the database based on platform and filesystem.  For many years,
    the default page size was almost always 1024 bytes, but beginning
    with SQLite <a href="releaselog/3_12_0.html">version 3.12.0</a> (2016-03-29), 
    the default page size increased
    to 4096.

    <p>The page_size pragma will only set in the
    page size if it is issued before any other SQL statements that
    cause I/O against the database file.
    SQL statements that cause I/O against the database file include
    "CREATE", "SELECT", "BEGIN IMMEDIATE", and "PRAGMA journal_mode=WAL".
    If the page_size pragma is
    used to specify a new page size just prior to
    running the <a href="lang_vacuum.html">VACUUM</a> command and if the database is not in
    <a href="wal.html">WAL journal mode</a> then <a href="lang_vacuum.html">VACUUM</a> will change the page
    size to the new value.</p>


    <p>The <a href="compile.html#default_page_size">SQLITE_DEFAULT_PAGE_SIZE</a> compile-time option can be used
    to change the default page size assigned to new databases.
<a name="pragma_parser_trace"></a>
<h _id=pragma_parser_trace style="display:none"> PRAGMA parser_trace</h><hr>
    <p><b>PRAGMA parser_trace = </b><i>boolean</i><b>; </b></p>

................................................................................
       <a href="fileformat2.html#database_header">database header</a>. 

<p>    SQLite automatically increments the schema-version whenever the
       schema changes. As each SQL statement runs, the schema version is
       checked to ensure that the schema has not changed since the SQL
       statement was <a href="c3ref/prepare.html">prepared</a>.
       Subverting this mechanism by using "PRAGMA schema_version"
       my cause SQL statement to run using an obsolete schema,
       which can lead to incorrect answers and/or
       <a href="howtocorrupt.html#cfgerr">database corruption</a>.

       
    <p><span style='background-color: #ffff60;'>
    <b>Warning:</b>
    Misuse of this pragma can result in <a href="howtocorrupt.html#cfgerr">database corruption</a>.







|
>







 







|



|
|

|
|
|
<
<
|
<
|
<
<
>







 







|







751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
....
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284


1285

1286


1287
1288
1289
1290
1291
1292
1293
1294
....
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404
1405
1406
1407

    <p>The foreign_key_check pragma checks the database, or the table
    called "<i>table-name</i>", for 
    <a href="foreignkeys.html">foreign key constraints</a> that are violated and returns one row of
    output for each violation.  There are four columns in each result row.
    The first column is the name of the table that contains the REFERENCES
    clause.  The second column is the <a href="lang_createtable.html#rowid">rowid</a> of the row that
    contains the invalid REFERENCES clause, or NULL if the child table is a
    <a href="withoutrowid.html">WITHOUT ROWID</a> table.  The third column is the name
    of the table that is referred to. The fourth column is the index of
    the specific foreign key constraint that failed.  The fourth column
    in the output of the foreign_key_check pragma is the same integer as
    the first column in the output of the <a href="pragma.html#pragma_foreign_key_list">foreign_key_list pragma</a>.
    When a "<i>table-name</i>" is specified, the only foreign key constraints
    checked are those created by REFERENCES clauses in the
    CREATE TABLE statement for <i>table-name</i>.</p>
................................................................................
<h _id=pragma_page_size style="display:none"> PRAGMA page_size</h><hr>
   <p><b>PRAGMA </b><i>schema.</i><b>page_size;
       <br>PRAGMA </b><i>schema.</i><b>page_size = </b><i>bytes</i><b>;</b></p>
    <p>Query or set the page size of the database. The page
    size must be a power of two between 512 and 65536 inclusive.
    </p>

    <p>When a new database is created, SQLite assigns a page size to
    the database based on platform and filesystem.  For many years,
    the default page size was almost always 1024 bytes, but beginning
    with SQLite <a href="releaselog/3_12_0.html">version 3.12.0</a> (2016-03-29), 
    the default page size increased to 4096.
    The default page size is recommended for most applications.

    <p>Specifying a new page size does not change the page size
    immediately.  Instead, the new page size is remembered and is used
    to set the page size when the database is first created, if it does


    not already exist when the page_size pragma is issued, or at the

    next <a href="lang_vacuum.html">VACUUM</a> command that is run on the same database connection


    while not in <a href="wal.html">WAL mode</a>.</p>

    <p>The <a href="compile.html#default_page_size">SQLITE_DEFAULT_PAGE_SIZE</a> compile-time option can be used
    to change the default page size assigned to new databases.
<a name="pragma_parser_trace"></a>
<h _id=pragma_parser_trace style="display:none"> PRAGMA parser_trace</h><hr>
    <p><b>PRAGMA parser_trace = </b><i>boolean</i><b>; </b></p>

................................................................................
       <a href="fileformat2.html#database_header">database header</a>. 

<p>    SQLite automatically increments the schema-version whenever the
       schema changes. As each SQL statement runs, the schema version is
       checked to ensure that the schema has not changed since the SQL
       statement was <a href="c3ref/prepare.html">prepared</a>.
       Subverting this mechanism by using "PRAGMA schema_version"
       may cause SQL statement to run using an obsolete schema,
       which can lead to incorrect answers and/or
       <a href="howtocorrupt.html#cfgerr">database corruption</a>.

       
    <p><span style='background-color: #ffff60;'>
    <b>Warning:</b>
    Misuse of this pragma can result in <a href="howtocorrupt.html#cfgerr">database corruption</a>.

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

1
2
3
4
5
6

7
8
9
10
11
12
13
..
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
..
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html><head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<link href="../sqlite.css" rel="stylesheet">
<title>SQLite Syntax: column-name-list</title>

</head>
<body>
<div class=nosearch>
<a href="../index.html">
<img class="logo" src="../images/sqlite370_banner.gif" alt="SQLite" border="0">
</a>
<div><!-- IE hack to prevent disappearing logo --></div>
................................................................................
<li><a href='../docs.html'>Documentation</a>
<li><a href='../download.html'>Download</a>
<li><a href='../support.html'>Support</a>
<li><a href='../prosupport.html'>Purchase</a>
</ul>
</div>
<div class="searchmenu" id="searchmenu">
<form method="GET" action="search">
<span class="desktoponly">Search for:</span> <input type="text" name="q">
<input type="submit" value="Go">
</form>
</div>
</div>
<script>
function toggle_div(nm) {
................................................................................
w.style.display = "block";
}
}
function div_off(nm){document.getElementById(nm).style.display="none";}
window.onbeforeunload = function(e){div_off("submenu");}
/* Disable the Search feature if we are not operating from CGI, since */
/* Search is accomplished using CGI and will not work without it. */
if( !location.origin.match(/http/) ){
document.getElementById("search_menubutton").style.display = "none";
}
/* Used by the Hide/Show button beside syntax diagrams, to toggle the */
function hideorshow(btn,obj){
var x = document.getElementById(obj);
var b = document.getElementById(btn);
if( x.style.display!='none' ){






>







 







|







 







|







1
2
3
4
5
6
7
8
9
10
11
12
13
14
..
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
..
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html><head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<link href="../sqlite.css" rel="stylesheet">
<title>SQLite Syntax: column-name-list</title>
<!-- path=../ -->
</head>
<body>
<div class=nosearch>
<a href="../index.html">
<img class="logo" src="../images/sqlite370_banner.gif" alt="SQLite" border="0">
</a>
<div><!-- IE hack to prevent disappearing logo --></div>
................................................................................
<li><a href='../docs.html'>Documentation</a>
<li><a href='../download.html'>Download</a>
<li><a href='../support.html'>Support</a>
<li><a href='../prosupport.html'>Purchase</a>
</ul>
</div>
<div class="searchmenu" id="searchmenu">
<form method="GET" action="../search">
<span class="desktoponly">Search for:</span> <input type="text" name="q">
<input type="submit" value="Go">
</form>
</div>
</div>
<script>
function toggle_div(nm) {
................................................................................
w.style.display = "block";
}
}
function div_off(nm){document.getElementById(nm).style.display="none";}
window.onbeforeunload = function(e){div_off("submenu");}
/* Disable the Search feature if we are not operating from CGI, since */
/* Search is accomplished using CGI and will not work without it. */
if( !location.origin.match || !location.origin.match(/http/) ){
document.getElementById("search_menubutton").style.display = "none";
}
/* Used by the Hide/Show button beside syntax diagrams, to toggle the */
function hideorshow(btn,obj){
var x = document.getElementById(obj);
var b = document.getElementById(btn);
if( x.style.display!='none' ){

Changes to Doc/sync.eagle.

50
51
52
53
54
55
56

57
58
59
60
61
62
63
...
109
110
111
112
113
114
115

116
117
118
119
120
121
122
    [file join images sqlite370_banner.gif] \
    [file join images syntax alter-table-stmt.gif] \
    [file join images syntax analyze-stmt.gif] \
    [file join images syntax attach-stmt.gif] \
    [file join images syntax begin-stmt.gif] \
    [file join images syntax column-constraint.gif] \
    [file join images syntax column-def.gif] \

    [file join images syntax comment-syntax.gif] \
    [file join images syntax commit-stmt.gif] \
    [file join images syntax common-table-expression.gif] \
    [file join images syntax compound-operator.gif] \
    [file join images syntax compound-select-stmt.gif] \
    [file join images syntax conflict-clause.gif] \
    [file join images syntax create-index-stmt.gif] \
................................................................................
    [file join images syntax with-clause.gif] \
    [file join syntax alter-table-stmt.html] \
    [file join syntax analyze-stmt.html] \
    [file join syntax attach-stmt.html] \
    [file join syntax begin-stmt.html] \
    [file join syntax column-constraint.html] \
    [file join syntax column-def.html] \

    [file join syntax comment-syntax.html] \
    [file join syntax commit-stmt.html] \
    [file join syntax common-table-expression.html] \
    [file join syntax compound-operator.html] \
    [file join syntax compound-select-stmt.html] \
    [file join syntax conflict-clause.html] \
    [file join syntax create-index-stmt.html] \







>







 







>







50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
...
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
    [file join images sqlite370_banner.gif] \
    [file join images syntax alter-table-stmt.gif] \
    [file join images syntax analyze-stmt.gif] \
    [file join images syntax attach-stmt.gif] \
    [file join images syntax begin-stmt.gif] \
    [file join images syntax column-constraint.gif] \
    [file join images syntax column-def.gif] \
    [file join images syntax column-name-list.gif] \
    [file join images syntax comment-syntax.gif] \
    [file join images syntax commit-stmt.gif] \
    [file join images syntax common-table-expression.gif] \
    [file join images syntax compound-operator.gif] \
    [file join images syntax compound-select-stmt.gif] \
    [file join images syntax conflict-clause.gif] \
    [file join images syntax create-index-stmt.gif] \
................................................................................
    [file join images syntax with-clause.gif] \
    [file join syntax alter-table-stmt.html] \
    [file join syntax analyze-stmt.html] \
    [file join syntax attach-stmt.html] \
    [file join syntax begin-stmt.html] \
    [file join syntax column-constraint.html] \
    [file join syntax column-def.html] \
    [file join syntax column-name-list.html] \
    [file join syntax comment-syntax.html] \
    [file join syntax commit-stmt.html] \
    [file join syntax common-table-expression.html] \
    [file join syntax compound-operator.html] \
    [file join syntax compound-select-stmt.html] \
    [file join syntax conflict-clause.html] \
    [file join syntax create-index-stmt.html] \