/ Check-in [557eb2ec]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

Overview
Comment:Clarify documentation of DEFAULT CURRENT_TIME etc. (version 3.1.0 and greater only). (CVS 2274)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 557eb2ec9d825c0a2830d3355d0d27b4b5937de2
User & Date: danielk1977 2005-01-24 23:27:32
Context
2005-01-25
04:27
Prevent collation sequences and user functions from being deleted or changed while SQL statements are executing. (CVS 2275) check-in: cabab62b user: danielk1977 tags: trunk
2005-01-24
23:27
Clarify documentation of DEFAULT CURRENT_TIME etc. (version 3.1.0 and greater only). (CVS 2274) check-in: 557eb2ec user: danielk1977 tags: trunk
13:03
More test cases to do with invalidating precompiled statements. (CVS 2273) check-in: b243681a user: danielk1977 tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to www/lang.tcl.

     1      1   #
     2      2   # Run this Tcl script to generate the lang-*.html files.
     3      3   #
     4         -set rcsid {$Id: lang.tcl,v 1.81 2005/01/10 06:39:57 danielk1977 Exp $}
            4  +set rcsid {$Id: lang.tcl,v 1.82 2005/01/24 23:27:32 danielk1977 Exp $}
     5      5   source common.tcl
     6      6   
     7      7   if {[llength $argv]>0} {
     8      8     set outputdir [lindex $argv 0]
     9      9   } else {
    10     10     set outputdir ""
    11     11   }
................................................................................
   479    479   The UNIQUE constraint causes an index to be created on the specified
   480    480   columns.  This index must contain unique keys.
   481    481   The COLLATE clause specifies what text <a href="datatype3.html#collation">
   482    482   collating function</a> to use when comparing text entries for the column.  
   483    483   The built-in BINARY collating function is used by default.
   484    484   <p>
   485    485   The DEFAULT constraint specifies a default value to use when doing an INSERT.
   486         -The value may be NULL, a string constant, a number, or one of the special
   487         -case-independant keywords CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP.
   488         -If the value is NULL, a string constant or number, it is literally inserted
   489         -into the column whenever an INSERT statement that does not specify a value
   490         -for the column is executed. If the value is CURRENT_TIME, CURRENT_DATE or
   491         -CURRENT_TIMESTAMP, then the current UTC date and/or time is inserted into
   492         -the columns. For CURRENT_TIME, the format is HH:MM:SS. For CURRENT_DATE, 
   493         -YYYY-MM-DD. The format for CURRENT_TIMESTAMP is "YYYY-MM-DD HH:MM:SS".
          486  +The value may be NULL, a string constant or a number. Starting with version
          487  +3.1.0, the default value may also be one of the special case-independant
          488  +keywords CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP. If the value is
          489  +NULL, a string constant or number, it is literally inserted into the column
          490  +whenever an INSERT statement that does not specify a value for the column is
          491  +executed. If the value is CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP, then
          492  +the current UTC date and/or time is inserted into the columns. For
          493  +CURRENT_TIME, the format is HH:MM:SS. For CURRENT_DATE, YYYY-MM-DD. The format
          494  +for CURRENT_TIMESTAMP is "YYYY-MM-DD HH:MM:SS".
   494    495   </p>
   495    496   
   496    497   <p>Specifying a PRIMARY KEY normally just creates a UNIQUE index
   497    498   on the corresponding columns.  However, if primary key is on a single column
   498    499   that has datatype INTEGER, then that column is used internally
   499    500   as the actual key of the B-Tree for the table.  This means that the column
   500    501   may only hold unique integer values.  (Except for this one case,