Documentation Source Text

Check-in [c914be12fe]
Login

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

Overview
Comment:Clarify that bound parameters may not appear in the DEFAULT clause of a CREATE TABLE statement.
Timelines: family | ancestors | version-3.8.6
Files: files | file ages | folders
SHA1: c914be12fef11e91c867f525f1230007bb4c6f57
User & Date: drh 2014-09-24 13:26:00
Context
2014-09-24
13:26
Clarify that bound parameters may not appear in the DEFAULT clause of a CREATE TABLE statement. Leaf check-in: c914be12fe user: drh tags: version-3.8.6
13:25
Clarify that bound parameters may not appear in the DEFAULT clause of a CREATE TABLE statement. check-in: d59078695f user: drh tags: trunk
2014-09-21
16:58
Cherrypick typo fixes from trunk. check-in: d72427edab user: drh tags: version-3.8.6
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/lang.in.

   898    898   determine the [affinity] of the column only.
   899    899   
   900    900   <p>The DEFAULT clause specifies a default value to use for the column if no
   901    901   value is explicitly provided by the user when doing an [INSERT]. ^If there
   902    902   is no explicit DEFAULT clause attached to a column definition, then the 
   903    903   default value of the column is NULL. ^(An explicit DEFAULT clause may specify
   904    904   that the default value is NULL, a string constant, a blob constant, a
   905         -signed-number, or any constant expression enclosed in parentheses. An explicit
          905  +signed-number, or any constant expression enclosed in parentheses. A
   906    906   default value may also be one of the special case-independent keywords
   907    907   CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP.)^ ^For the purposes of the
   908         -DEFAULT clause, an expression is considered constant provided that it does
   909         -not contain any sub-queries, column or table references, or string literals
   910         -enclosed in double-quotes instead of single-quotes.
          908  +DEFAULT clause, an expression is considered constant if it does
          909  +contains no sub-queries, column or table references, [bound parameters],
          910  +or string literals enclosed in double-quotes instead of single-quotes.
   911    911   
   912    912   <p>^(Each time a row is inserted into the table by an INSERT statement that 
   913    913   does not provide explicit values for all table columns the values stored in
   914    914   the new row are determined by their default values)^, as follows:
   915    915   
   916    916   <ul>
   917    917     <li><p>^If the default value of the column is a constant NULL, text, blob or