Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Documentation updates (CVS 1921) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
9322c439c5727f0d65548efdf4de4d7b |
| User & Date: | drh 2004-08-30 14:58:12 |
Context
|
2004-08-30
| ||
| 16:52 | Better detection and handling of corrupt database files. (CVS 1922) check-in: 8f5b199e user: drh tags: trunk | |
| 14:58 | Documentation updates (CVS 1921) check-in: 9322c439 user: drh tags: trunk | |
| 14:22 | Remove the \001 character that lemon inserts automatically in its output file. The need for this character has expired and it creates confusion for users. Ticket #877 (CVS 1920) check-in: acfc5918 user: drh tags: trunk | |
Changes
Changes to www/c_interface.tcl.
1 1 # 2 2 # Run this Tcl script to generate the sqlite.html file. 3 3 # 4 -set rcsid {$Id: c_interface.tcl,v 1.40 2004/05/31 15:06:29 drh Exp $} 4 +set rcsid {$Id: c_interface.tcl,v 1.41 2004/08/30 14:58:12 drh Exp $} 5 5 source common.tcl 6 6 header {The C language interface to the SQLite library} 7 7 puts { 8 8 <h2>The C language interface to the SQLite library</h2> 9 9 10 10 <p>The SQLite library is designed to be very easy to use from 11 11 a C or C++ program. This document gives an overview of the C/C++ ................................................................................ 691 691 pointer. In addition to the regular data, there is an added row at the 692 692 beginning of the array that contains the name of each column of the 693 693 result.</p> 694 694 695 695 <p>As an example, consider the following query:</p> 696 696 697 697 <blockquote> 698 -SELECT employee_name, login, host FROM users WHERE logic LIKE 'd%'; 698 +SELECT employee_name, login, host FROM users WHERE login LIKE 'd%'; 699 699 </blockquote> 700 700 701 701 <p>This query will return the name, login and host computer name 702 702 for every employee whose login begins with the letter "d". If this 703 703 query is submitted to <b>sqlite_get_table</b> the result might 704 704 look like this:</p> 705 705
Changes to www/nulls.tcl.
1 1 # 2 2 # Run this script to generated a nulls.html output file 3 3 # 4 -set rcsid {$Id: nulls.tcl,v 1.6 2004/05/31 15:06:30 drh Exp $} 4 +set rcsid {$Id: nulls.tcl,v 1.7 2004/08/30 14:58:12 drh Exp $} 5 5 source common.tcl 6 6 header {NULL Handling in SQLite} 7 7 puts { 8 8 <h2>NULL Handling in SQLite Versus Other Database Engines</h2> 9 9 10 10 <p> 11 11 The goal is ................................................................................ 103 103 <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td> 104 104 </tr> 105 105 <tr><td>nulls are distinct in a UNIQUE column</td> 106 106 <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td> 107 107 <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td> 108 108 <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td> 109 109 <td valign="center" align="center" bgcolor="#c7a9a9">No</td> 110 -<td valign="center" align="center" bgcolor="#a9c7a9">Yes</td> 110 +<td valign="center" align="center" bgcolor="#aaaad2">(Note 4)</td> 111 111 <td valign="center" align="center" bgcolor="#c7a9a9">No</td> 112 112 <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td> 113 113 </tr> 114 114 <tr><td>nulls are distinct in SELECT DISTINCT</td> 115 115 <td valign="center" align="center" bgcolor="#c7a9a9">No</td> 116 116 <td valign="center" align="center" bgcolor="#c7a9a9">No</td> 117 117 <td valign="center" align="center" bgcolor="#c7a9a9">No</td> ................................................................................ 235 235 <tr><td>2. </td> 236 236 <td>Test data unavailable.</td> 237 237 </tr> 238 238 <tr><td>3. </td> 239 239 <td>MySQL version 3.23.41 does not support UNION.</td> 240 240 </tr> 241 241 <tr><td>4. </td> 242 -<td>SQL Anywhere and Borland Interbase 242 +<td>DB2, SQL Anywhere, and Borland Interbase 243 243 do not allow NULLs in a UNIQUE column.</td> 244 244 </tr> 245 245 <tr><td>5. </td> 246 246 <td>Borland Interbase does not support CASE expressions.</td> 247 247 </tr> 248 248 </table> 249 249 <br clear="both">