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.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | version-3.8.6
Files: files | file ages | folders
SHA1: c914be12fef11e91c867f525f1230007bb4c6f57
User & Date: drh 2014-09-24 13:26:00.828
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
Unified Diff Ignore Whitespace Patch
Changes to pages/lang.in.
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
determine the [affinity] of the column only.

<p>The DEFAULT clause specifies a default value to use for the column if no
value is explicitly provided by the user when doing an [INSERT]. ^If there
is no explicit DEFAULT clause attached to a column definition, then the 
default value of the column is NULL. ^(An explicit DEFAULT clause may specify
that the default value is NULL, a string constant, a blob constant, a
signed-number, or any constant expression enclosed in parentheses. An explicit
default value may also be one of the special case-independent keywords
CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP.)^ ^For the purposes of the
DEFAULT clause, an expression is considered constant provided that it does
not contain any sub-queries, column or table references, or string literals
enclosed in double-quotes instead of single-quotes.

<p>^(Each time a row is inserted into the table by an INSERT statement that 
does not provide explicit values for all table columns the values stored in
the new row are determined by their default values)^, as follows:

<ul>
  <li><p>^If the default value of the column is a constant NULL, text, blob or







|


|
|
|







898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
determine the [affinity] of the column only.

<p>The DEFAULT clause specifies a default value to use for the column if no
value is explicitly provided by the user when doing an [INSERT]. ^If there
is no explicit DEFAULT clause attached to a column definition, then the 
default value of the column is NULL. ^(An explicit DEFAULT clause may specify
that the default value is NULL, a string constant, a blob constant, a
signed-number, or any constant expression enclosed in parentheses. A
default value may also be one of the special case-independent keywords
CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP.)^ ^For the purposes of the
DEFAULT clause, an expression is considered constant if it does
contains no sub-queries, column or table references, [bound parameters],
or string literals enclosed in double-quotes instead of single-quotes.

<p>^(Each time a row is inserted into the table by an INSERT statement that 
does not provide explicit values for all table columns the values stored in
the new row are determined by their default values)^, as follows:

<ul>
  <li><p>^If the default value of the column is a constant NULL, text, blob or