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: |
c914be12fef11e91c867f525f1230007 |
| 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
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 |