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
...
926
927
928
929
930
931
932


933
934
935
936
937
938
939
    "The CGI program %s generated an error\n"
    "</body>\n", zScript);
  MakeLogEntry(0);
  exit(0);
}

/*
** This is called if we timeout.

*/
static void Timeout(int NotUsed){
  (void)NotUsed;
  if( !debugFlag ){
    if( zScript && zScript[0] ){





      strcpy(zReplyStatus, "999");
      MakeLogEntry(0);
    }
    exit(0);
  }
}

/*
................................................................................
  }
  nRequest++;

  /*
  ** We must receive a complete header within 15 seconds
  */
  signal(SIGALRM, 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);







|
>

|
<


>
>
>
>
>
|







 







>
>







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
...
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
    "The CGI program %s generated an error\n"
    "</body>\n", zScript);
  MakeLogEntry(0);
  exit(0);
}

/*
** 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 iSig){

  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, zBuf);
      MakeLogEntry(0);
    }
    exit(0);
  }
}

/*
................................................................................
  }
  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
...
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
}
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.
}
















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








>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







 







<
<







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
...
232
233
234
235
236
237
238


239
240
241
242
243
244
245
}
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 
................................................................................
  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.


}

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
...
896
897
898
899
900
901
902
903
904
905
906
<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]
    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
    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;
................................................................................

    <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 
         of foreign key actions. It is not possible to disable recursive foreign 
         key actions.
   </ol>







|
<





|







 







|



235
236
237
238
239
240
241
242

243
244
245
246
247
248
249
250
251
252
253
254
255
...
895
896
897
898
899
900
901
902
903
904
905
<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].

    (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 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;
................................................................................

    <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 affect the operation 
         of foreign key actions. It is not possible to disable recursive foreign 
         key actions.
   </ol>