Documentation Source Text

Changes On Branch version-3.8.4.3
Login

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

Changes In Branch version-3.8.4.3 Excluding Merge-Ins

This is equivalent to a diff from a6ea023899 to e56e2046b0

2014-05-26
23:18
Fix Win32 to say Win64 for 64-bit DLLs on the download page. (check-in: 3638ded7d1 user: drh tags: trunk)
23:18
Fix Win32 to say Win64 for 64-bit DLLs on the download page. (Leaf check-in: e56e2046b0 user: drh tags: version-3.8.4.3)
23:16
Fixes the download of pre-release DLLs. (check-in: 076319aa90 user: drh tags: version-3.8.4.3)
2014-04-25
20:47
Fix more typos in the foreignkey.html document. (check-in: 25bc66990e user: drh tags: version-3.8.4.3)
2014-04-22
01:06
Update the version number to 3.8.5. Add a change log. (check-in: aabef1a296 user: drh tags: trunk)
00:32
Rename the "sqlite.html" page to "cli.html". Keep an "sqlite.html" page that redirects to "cli.html". (check-in: a6ea023899 user: drh tags: trunk)
2014-04-21
18:20
Update the command-line shell documentation with a discussion of CSV import and export. (check-in: 070bfddab9 user: drh tags: trunk)

Changes to misc/althttpd.c.

445
446
447
448
449
450
451
452


453
454

455
456
457





458

459
460
461
462
463
464
465
445
446
447
448
449
450
451

452
453
454

455

456
457
458
459
460
461
462

463
464
465
466
467
468
469
470







-
+
+

-
+
-


+
+
+
+
+
-
+







    "The CGI program %s generated an error\n"
    "</body>\n", zScript);
  MakeLogEntry(0);
  exit(0);
}

/*
** This is called if we timeout.
** This is called if we timeout or catch some other kind of signal.
** Log an error code which is 900+iSig and then quit.
*/
static void Timeout(int NotUsed){
static void Timeout(int iSig){
  (void)NotUsed;
  if( !debugFlag ){
    if( zScript && zScript[0] ){
      char zBuf[10];
      zBuf[0] = '9';
      zBuf[1] = '0' + (iSig/10)%10;
      zBuf[2] = '0' + iSig%10;
      zBuf[3] = 0;
      strcpy(zReplyStatus, "999");
      strcpy(zReplyStatus, zBuf);
      MakeLogEntry(0);
    }
    exit(0);
  }
}

/*
926
927
928
929
930
931
932


933
934
935
936
937
938
939
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946







+
+







  }
  nRequest++;

  /*
  ** We must receive a complete header within 15 seconds
  */
  signal(SIGALRM, Timeout);
  signal(SIGSEGV, Timeout);
  signal(SIGPIPE, Timeout);
  if( useTimeout ) alarm(15);

  /* Get the first line of the request and parse out the
  ** method, the script and the protocol.
  */
  if( fgets(zLine,sizeof(zLine),stdin)==0 ){
    exit(0);

Changes to pages/download.in.

117
118
119
120
121
122
123
















124
125
126
127
128
129
130
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146







+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+







}
Product {snapshot/sqlite-tea-DATE.zip} {
  This is a snapshot (as of VERSION) of the current SQLite code under 
  development, packaged and ready to build using the
  <a href="http://www.tcl.tk/doc/tea/">Tcl Extension Architecture (TEA)</a>.
  Use this snapshot for testing only.  This is not a release.
}

Heading {Pre-release Windows DLLs} {} $Caution

Product snapshot/sqlite-dll-win32-x86-DATE.zip {
  This ZIP archive contains a DLL for the SQLite library snapshot as of VERSION for
  32-bit x86 processors using the Win32 API. See the
  <a href="http://www.sqlite.org/draft/releaselog/current.html">pending change log</a>
  for a list of changes.
}
Product snapshot/sqlite-dll-win64-x64-DATE.zip {
  This ZIP archive contains a DLL for the SQLite library snapshot as of VERSION for
  64-bit x64 processors using the Win64 API.   See the
  <a href="http://www.sqlite.org/draft/releaselog/current.html">pending change log</a>
  for a list of changes.
}

Product {snapshot/sqlite-shell-win32-x86-DATE.zip} {
  This is a snapshot (as of VERSION) build of the 
  [CLI | sqlite3.exe command-line shell]
  shell program for 32-bit windows.
}
Product {snapshot/sqlite-shell-win64-x64-DATE.zip} {
  This is a snapshot (as of VERSION) build of the 
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238


239
240
241
242
243
244
245







-
-







  This program is compatible with all versions of SQLite through VERSION
  and beyond.
}

Product YEAR/sqlite-dll-win32-x86-VVV.zip {
  This ZIP archive contains a DLL for the SQLite library version VERSION for
  32-bit x86 processors using the Win32 API.
  The DLL is built using [SQLITE_ENABLE_COLUMN_METADATA] so that it is
  suitable for use with Ruby on Rails.
}

Product YEAR/sqlite-dll-win32-x64-VVV.zip {
  This ZIP archive contains a DLL for the SQLite library version VERSION for
  64-bit x64 processors using the Win32 API.
}

Changes to pages/foreignkeys.in.

235
236
237
238
239
240
241
242

243
244
245
246
247
248
249

250
251
252
253
254
255
256
235
236
237
238
239
240
241

242

243
244
245
246
247

248
249
250
251
252
253
254
255







-
+
-





-
+







<codeblock>
  sqlite&gt; PRAGMA foreign_keys = ON;
</codeblock>

  <p>
    ^Foreign key constraints are disabled by default 
    (for backwards compatibility),
    so must be enabled separately for each [database connection]
    so must be enabled separately for each [database connection].
    separately.
    (Note, however, that future releases of SQLite might change
    so that foreign key constraints enabled by default.  Careful
    developers will not
    make any assumptions about whether or not foreign keys are enabled by
    default but will instead enable or disable them as necessary.)
    ^The application can can also use a [PRAGMA foreign_keys] statement to
    ^The application can also use a [PRAGMA foreign_keys] statement to
    determine if foreign keys are currently enabled. ^(The following 
    command-line session demonstrates this:
<codeblock>
  sqlite> PRAGMA foreign_keys;
  0
  sqlite> PRAGMA foreign_keys = ON;
  sqlite> PRAGMA foreign_keys;
896
897
898
899
900
901
902
903

904
905
906
895
896
897
898
899
900
901

902
903
904
905







-
+




    <li><p>
      <b>Recursion limit on foreign key actions.</b> ^(The 
         [SQLITE_MAX_TRIGGER_DEPTH] and [SQLITE_LIMIT_TRIGGER_DEPTH]
         settings determine the maximum allowable depth of trigger
         program recursion. For the purposes of these limits,
         [foreign key actions] are considered trigger programs.)^ ^The
         [PRAGMA recursive_triggers] setting does not not affect the operation 
         [PRAGMA recursive_triggers] setting does not affect the operation 
         of foreign key actions. It is not possible to disable recursive foreign 
         key actions.
   </ol>