Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: |
Downloads: |
Tarball
| ZIP archive
|
---|
Timelines: |
family
| ancestors
| descendants
| both
| trunk
|
Files: |
files
| file ages
| folders
|
SHA1: |
05a7dc5557a34a0ef799f53d7c90462aa6d0d51a |
User & Date: |
mistachkin
2017-06-10 17:22:55.849 |
Context
2017-06-11
| | |
02:58 |
|
check-in: 802962c8f3 user: mistachkin tags: trunk
|
2017-06-10
| | |
17:38 |
|
check-in: 091bc3a48a user: mistachkin tags: branch-1.0.105
|
17:22 |
|
check-in: 05a7dc5557 user: mistachkin tags: trunk
|
01:09 |
|
check-in: ac29179121 user: mistachkin tags: trunk
|
| | |
Changes
Changes to Doc/Extra/Core/lang_createtrigger.html.
︙ | | |
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
|
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
|
-
+
+
+
+
+
+
+
|
restrictions apply:</p>
<ul>
<li><p>
The name of the table to be modified in an <a href="lang_update.html">UPDATE</a>, <a href="lang_delete.html">DELETE</a>, or <a href="lang_insert.html">INSERT</a>
statement must be an unqualified table name. In other words, one must
use just "<i>tablename</i>" not "<i>database</i><b>.</b><i>tablename</i>"
when specifying the table. The table to be modified must exist in the
when specifying the table. </p></li>
<li><p>
For non-TEMP triggers,
the table to be modified or queried must exist in the
same database as the table or view to which the trigger is attached.
TEMP triggers are not subject to the same-database rule. A TEMP
trigger is allowed to query or modify any table in any <a href="lang_attach.html">ATTACH</a>-ed database.
</p></li>
<li><p>
The "INSERT INTO <i>table</i> DEFAULT VALUES" form of the <a href="lang_insert.html">INSERT</a> statement
is not supported.
</p></li>
|
︙ | | |
Changes to Doc/Extra/Provider/version.html.
︙ | | |
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
-
+
+
+
+
+
-
+
+
|
</td>
</tr>
</table>
</div>
<div id="mainSection">
<div id="mainBody">
<h1 class="heading">Version History</h1>
<p><b>1.0.106.0 - July XX, 2017 <font color="red">(release scheduled)</font></b></p>
<p><b>1.0.106.0 - August XX, 2017 <font color="red">(release scheduled)</font></b></p>
<ul>
<li>Updated to <a href="https://www.sqlite.org/src/timeline">SQLite 3.20.0</a>.</li>
</ul>
<p><b>1.0.105.2 - June 12, 2017</b></p>
<ul>
<li>Updated to <a href="https://www.sqlite.org/releaselog/3_19_2.html">SQLite 3.19.2</a>.</li>
<li>Updated to <a href="https://www.sqlite.org/releaselog/3_19_3.html">SQLite 3.19.3</a>.</li>
<li>Fix issues that prevented SQLiteBlob creation from succeeding for tables that did not have an integer primary key.</li>
</ul>
<p><b>1.0.105.1 - May 15, 2017</b></p>
<ul>
<li>Prevent culture settings from negatively impacting integer connection string defaults.</li>
<li>Make sure the "No_SQLiteConnectionNewParser" and "DefaultFlags_SQLiteConnection" setting values end up being cached.</li>
<li>Cache the XML file name and assembly directory used by the configuration subsystem.</li>
</ul>
|
︙ | | |
Changes to SQLite.Interop/props/sqlite3.props.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
-
-
+
+
|
<?xml version="1.0" encoding="utf-8"?>
<!--
*
* sqlite3.props -
*
* Written by Joe Mistachkin.
* Released to the public domain, use at your own risk!
*
-->
<Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="4.0">
<PropertyGroup Label="UserMacros">
<SQLITE_MANIFEST_VERSION>3.19.2.0</SQLITE_MANIFEST_VERSION>
<SQLITE_RC_VERSION>3,19,2,0</SQLITE_RC_VERSION>
<SQLITE_MANIFEST_VERSION>3.19.3.0</SQLITE_MANIFEST_VERSION>
<SQLITE_RC_VERSION>3,19,3,0</SQLITE_RC_VERSION>
<SQLITE_COMMON_DEFINES>_CRT_SECURE_NO_DEPRECATE;_CRT_SECURE_NO_WARNINGS;_CRT_NONSTDC_NO_DEPRECATE;_CRT_NONSTDC_NO_WARNINGS;SQLITE_THREADSAFE=1;SQLITE_USE_URI=1;SQLITE_ENABLE_COLUMN_METADATA=1;SQLITE_ENABLE_STAT4=1;SQLITE_ENABLE_FTS3=1;SQLITE_ENABLE_LOAD_EXTENSION=1;SQLITE_ENABLE_RTREE=1;SQLITE_SOUNDEX=1;SQLITE_ENABLE_MEMORY_MANAGEMENT=1;SQLITE_ENABLE_API_ARMOR=1;SQLITE_ENABLE_DBSTAT_VTAB=1</SQLITE_COMMON_DEFINES>
<SQLITE_EXTRA_DEFINES>SQLITE_PLACEHOLDER=1;SQLITE_HAS_CODEC=1</SQLITE_EXTRA_DEFINES>
<SQLITE_WINCE_200X_DEFINES>SQLITE_OMIT_WAL=1</SQLITE_WINCE_200X_DEFINES>
<SQLITE_WINCE_2013_DEFINES>HAVE_ERRNO_H=1;SQLITE_MSVC_LOCALTIME_API=1</SQLITE_WINCE_2013_DEFINES>
<SQLITE_DEBUG_DEFINES>SQLITE_DEBUG=1;SQLITE_MEMDEBUG=1;SQLITE_ENABLE_EXPENSIVE_ASSERT=1</SQLITE_DEBUG_DEFINES>
<SQLITE_RELEASE_DEFINES>SQLITE_WIN32_MALLOC=1</SQLITE_RELEASE_DEFINES>
<SQLITE_DISABLE_WARNINGS>4055;4100;4127;4146;4210;4232;4244;4245;4267;4306;4389;4701;4703;4706</SQLITE_DISABLE_WARNINGS>
|
︙ | | |
Changes to SQLite.Interop/props/sqlite3.vsprops.
︙ | | |
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
-
+
-
+
|
<VisualStudioPropertySheet
ProjectType="Visual C++"
Version="8.00"
Name="sqlite3"
>
<UserMacro
Name="SQLITE_MANIFEST_VERSION"
Value="3.19.2.0"
Value="3.19.3.0"
PerformEnvironmentSet="true"
/>
<UserMacro
Name="SQLITE_RC_VERSION"
Value="3,19,2,0"
Value="3,19,3,0"
PerformEnvironmentSet="true"
/>
<UserMacro
Name="SQLITE_COMMON_DEFINES"
Value="_CRT_SECURE_NO_DEPRECATE;_CRT_SECURE_NO_WARNINGS;_CRT_NONSTDC_NO_DEPRECATE;_CRT_NONSTDC_NO_WARNINGS;SQLITE_THREADSAFE=1;SQLITE_USE_URI=1;SQLITE_ENABLE_COLUMN_METADATA=1;SQLITE_ENABLE_STAT4=1;SQLITE_ENABLE_FTS3=1;SQLITE_ENABLE_LOAD_EXTENSION=1;SQLITE_ENABLE_RTREE=1;SQLITE_SOUNDEX=1;SQLITE_ENABLE_MEMORY_MANAGEMENT=1;SQLITE_ENABLE_API_ARMOR=1;SQLITE_ENABLE_DBSTAT_VTAB=1"
PerformEnvironmentSet="true"
/>
|
︙ | | |
Changes to SQLite.Interop/src/core/sqlite3.c.
1
2
3
4
5
6
7
8
9
10
|
1
2
3
4
5
6
7
8
9
10
|
-
+
|
/******************************************************************************
** This file is an amalgamation of many separate C source files from SQLite
** version 3.19.2. By combining all the individual C code files into this
** version 3.19.3. By combining all the individual C code files into this
** single large file, the entire code can be compiled as a single translation
** unit. This allows many compilers to do optimizations that would not be
** possible if the files were compiled separately. Performance improvements
** of 5% or more are commonly seen when SQLite is compiled as a single
** translation unit.
**
** This file is all you need to compile SQLite. To use SQLite in other
|
︙ | | |
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
|
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
|
-
-
-
+
+
+
|
** string contains the date and time of the check-in (UTC) and a SHA1
** or SHA3-256 hash of the entire source tree.
**
** See also: [sqlite3_libversion()],
** [sqlite3_libversion_number()], [sqlite3_sourceid()],
** [sqlite_version()] and [sqlite_source_id()].
*/
#define SQLITE_VERSION "3.19.2"
#define SQLITE_VERSION_NUMBER 3019002
#define SQLITE_SOURCE_ID "2017-05-25 16:50:27 edb4e819b0c058c7d74d27ebd14cc5ceb2bad6a6144a486a970182b7afe3f8b9"
#define SQLITE_VERSION "3.19.3"
#define SQLITE_VERSION_NUMBER 3019003
#define SQLITE_SOURCE_ID "2017-06-08 14:26:16 0ee482a1e0eae22e08edc8978c9733a96603d4509645f348ebf55b579e89636b"
/*
** CAPI3REF: Run-Time Library Version Numbers
** KEYWORDS: sqlite3_version sqlite3_sourceid
**
** These interfaces provide the same information as the [SQLITE_VERSION],
** [SQLITE_VERSION_NUMBER], and [SQLITE_SOURCE_ID] C preprocessor macros
|
︙ | | |
67204
67205
67206
67207
67208
67209
67210
67211
67212
67213
67214
67215
67216
67217
67218
67219
67220
67221
67222
67223
|
67204
67205
67206
67207
67208
67209
67210
67211
67212
67213
67214
67215
67216
67217
67218
67219
67220
67221
67222
67223
67224
67225
67226
67227
67228
67229
|
-
+
+
+
-
+
+
+
+
+
|
goto end_insert;
}
oldCell = findCell(pPage, idx);
if( !pPage->leaf ){
memcpy(newCell, oldCell, 4);
}
rc = clearCell(pPage, oldCell, &info);
if( info.nSize==szNew && info.nLocal==info.nPayload ){
if( info.nSize==szNew && info.nLocal==info.nPayload
&& (!ISAUTOVACUUM || szNew<pPage->minLocal)
){
/* Overwrite the old cell with the new if they are the same size.
** We could also try to do this if the old cell is smaller, then add
** the leftover space to the free list. But experiments show that
** doing that is no faster then skipping this optimization and just
** calling dropCell() and insertCell(). */
** calling dropCell() and insertCell().
**
** This optimization cannot be used on an autovacuum database if the
** new entry uses overflow pages, as the insertCell() call below is
** necessary to add the PTRMAP_OVERFLOW1 pointer-map entry. */
assert( rc==SQLITE_OK ); /* clearCell never fails when nLocal==nPayload */
if( oldCell+szNew > pPage->aDataEnd ) return SQLITE_CORRUPT_BKPT;
memcpy(oldCell, newCell, szNew);
return SQLITE_OK;
}
dropCell(pPage, idx, info.nSize, &rc);
if( rc ) goto end_insert;
|
︙ | | |
199052
199053
199054
199055
199056
199057
199058
199059
199060
199061
199062
199063
199064
199065
199066
|
199058
199059
199060
199061
199062
199063
199064
199065
199066
199067
199068
199069
199070
199071
199072
|
-
+
|
static void fts5SourceIdFunc(
sqlite3_context *pCtx, /* Function call context */
int nArg, /* Number of args */
sqlite3_value **apUnused /* Function arguments */
){
assert( nArg==0 );
UNUSED_PARAM2(nArg, apUnused);
sqlite3_result_text(pCtx, "fts5: 2017-05-25 16:50:27 edb4e819b0c058c7d74d27ebd14cc5ceb2bad6a6144a486a970182b7afe3f8b9", -1, SQLITE_TRANSIENT);
sqlite3_result_text(pCtx, "fts5: 2017-06-08 14:26:16 0ee482a1e0eae22e08edc8978c9733a96603d4509645f348ebf55b579e89636b", -1, SQLITE_TRANSIENT);
}
static int fts5Init(sqlite3 *db){
static const sqlite3_module fts5Mod = {
/* iVersion */ 2,
/* xCreate */ fts5CreateMethod,
/* xConnect */ fts5ConnectMethod,
|
︙ | | |
Changes to SQLite.Interop/src/core/sqlite3.h.
︙ | | |
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
|
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
|
-
-
-
+
+
+
|
** string contains the date and time of the check-in (UTC) and a SHA1
** or SHA3-256 hash of the entire source tree.
**
** See also: [sqlite3_libversion()],
** [sqlite3_libversion_number()], [sqlite3_sourceid()],
** [sqlite_version()] and [sqlite_source_id()].
*/
#define SQLITE_VERSION "3.19.2"
#define SQLITE_VERSION_NUMBER 3019002
#define SQLITE_SOURCE_ID "2017-05-25 16:50:27 edb4e819b0c058c7d74d27ebd14cc5ceb2bad6a6144a486a970182b7afe3f8b9"
#define SQLITE_VERSION "3.19.3"
#define SQLITE_VERSION_NUMBER 3019003
#define SQLITE_SOURCE_ID "2017-06-08 14:26:16 0ee482a1e0eae22e08edc8978c9733a96603d4509645f348ebf55b579e89636b"
/*
** CAPI3REF: Run-Time Library Version Numbers
** KEYWORDS: sqlite3_version sqlite3_sourceid
**
** These interfaces provide the same information as the [SQLITE_VERSION],
** [SQLITE_VERSION_NUMBER], and [SQLITE_SOURCE_ID] C preprocessor macros
|
︙ | | |
Changes to SQLite.Interop/src/ext/fts5.c.
︙ | | |
17302
17303
17304
17305
17306
17307
17308
17309
17310
17311
17312
17313
17314
17315
17316
|
17302
17303
17304
17305
17306
17307
17308
17309
17310
17311
17312
17313
17314
17315
17316
|
-
+
|
static void fts5SourceIdFunc(
sqlite3_context *pCtx, /* Function call context */
int nArg, /* Number of args */
sqlite3_value **apUnused /* Function arguments */
){
assert( nArg==0 );
UNUSED_PARAM2(nArg, apUnused);
sqlite3_result_text(pCtx, "fts5: 2017-05-25 16:50:27 edb4e819b0c058c7d74d27ebd14cc5ceb2bad6a6144a486a970182b7afe3f8b9", -1, SQLITE_TRANSIENT);
sqlite3_result_text(pCtx, "fts5: 2017-06-08 14:26:16 0ee482a1e0eae22e08edc8978c9733a96603d4509645f348ebf55b579e89636b", -1, SQLITE_TRANSIENT);
}
static int fts5Init(sqlite3 *db){
static const sqlite3_module fts5Mod = {
/* iVersion */ 2,
/* xCreate */ fts5CreateMethod,
/* xConnect */ fts5ConnectMethod,
|
︙ | | |
Changes to readme.htm.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
-
-
+
+
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
</head>
<body>
ADO.NET SQLite Data Provider<br />
Version 1.0.106.0 - July XX, 2017 <font color="red">(release scheduled)</font><br />
Using <a href="https://www.sqlite.org/releaselog/3_19_2.html">SQLite 3.19.2</a><br />Originally written by Robert Simpson<br />
Version 1.0.106.0 - August XX, 2017 <font color="red">(release scheduled)</font><br />
Using <a href="https://www.sqlite.org/src/timeline">SQLite 3.20.0</a><br />Originally written by Robert Simpson<br />
Released to the public domain, use at your own risk!<br />
Official provider website: <a href="https://system.data.sqlite.org/">https://system.data.sqlite.org/</a><br />
Legacy versions: <a href="https://sourceforge.net/projects/sqlite-dotnet2/">https://sourceforge.net/projects/sqlite-dotnet2/</a><br />
<br />
The current development version can be downloaded from <a href="https://system.data.sqlite.org/index.html/timeline?y=ci">
https://system.data.sqlite.org/index.html/timeline?y=ci</a>
<br />
|
︙ | | |
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
|
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
|
-
+
+
+
+
+
+
+
-
+
+
|
designed for robustness and maximum backward compatibility with previously
released versions of System.Data.SQLite.
</p>
<h2><b>Version History</b></h2>
<p>
<b>1.0.106.0 - July XX, 2017 <font color="red">(release scheduled)</font></b>
<b>1.0.106.0 - August XX, 2017 <font color="red">(release scheduled)</font></b>
</p>
<ul>
<li>Updated to <a href="https://www.sqlite.org/src/timeline">SQLite 3.20.0</a>.</li>
</ul>
<p>
<b>1.0.105.2 - June 12, 2017</b>
</p>
<ul>
<li>Updated to <a href="https://www.sqlite.org/releaselog/3_19_2.html">SQLite 3.19.2</a>.</li>
<li>Updated to <a href="https://www.sqlite.org/releaselog/3_19_3.html">SQLite 3.19.3</a>.</li>
<li>Fix issues that prevented SQLiteBlob creation from succeeding for tables that did not have an integer primary key.</li>
</ul>
<p>
<b>1.0.105.1 - May 15, 2017</b>
</p>
<ul>
<li>Prevent culture settings from negatively impacting integer connection string defaults.</li>
<li>Make sure the "No_SQLiteConnectionNewParser" and "DefaultFlags_SQLiteConnection" setting values end up being cached.</li>
|
︙ | | |
Changes to www/news.wiki.
︙ | | |
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
|
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
|
-
+
+
+
+
+
+
+
-
+
+
|
Access to archived release packages will be granted on a case-by-case basis.
</li>
</ul>
<div align="center"><h2><b>Version History</b></h2></div>
<p>
<b>1.0.106.0 - July XX, 2017 <font color="red">(release scheduled)</font></b>
<b>1.0.106.0 - August XX, 2017 <font color="red">(release scheduled)</font></b>
</p>
<ul>
<li>Updated to [https://www.sqlite.org/src/timeline|SQLite 3.20.0].</li>
</ul>
<p>
<b>1.0.105.2 - June 12, 2017</b>
</p>
<ul>
<li>Updated to [https://www.sqlite.org/releaselog/3_19_2.html|SQLite 3.19.2].</li>
<li>Updated to [https://www.sqlite.org/releaselog/3_19_3.html|SQLite 3.19.3].</li>
<li>Fix issues that prevented SQLiteBlob creation from succeeding for tables that did not have an integer primary key.</li>
</ul>
<p>
<b>1.0.105.1 - May 15, 2017</b>
</p>
<ul>
<li>Prevent culture settings from negatively impacting integer connection string defaults.</li>
<li>Make sure the "No_SQLiteConnectionNewParser" and "DefaultFlags_SQLiteConnection" setting values end up being cached.</li>
|
︙ | | |