Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fix typo in VALUES clause documentation in lang.html. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
fee01c2d5b9ff68857d529ea042992e4 |
User & Date: | drh 2014-05-09 22:27:10.001 |
Context
2014-05-16
| ||
11:28 | Update fts3.html for recent changes to FTS. (check-in: ae994ce63a user: dan tags: trunk) | |
2014-05-09
| ||
22:27 | Fix typo in VALUES clause documentation in lang.html. (check-in: fee01c2d5b user: drh tags: trunk) | |
2014-05-07
| ||
16:00 | Add notes on the SQLITE_IOCAP_IMMUTABLE and "nolock" and "immutable" query parameter changes. (check-in: 7aa71cbb0c user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
41 42 43 44 45 46 47 | <li>Partial index causes assertion fault on UPDATE OR REPLACE. Ticket [http://www.sqlite.org/src/info/2ea3e9fe63 | 2ea3e9fe63] <li>Crash when calling undocumented SQL function sqlite_rename_parent() with NULL parameters. Ticket [http://www.sqlite.org/src/info/264b970c4379fd | 264b970c43] <li>ORDER BY ignored if the query has an identical GROUP BY. Ticket [http://www.sqlite.org/src/info/b75a9ca6b0499 | b75a9ca6b0] | | > > | 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 | <li>Partial index causes assertion fault on UPDATE OR REPLACE. Ticket [http://www.sqlite.org/src/info/2ea3e9fe63 | 2ea3e9fe63] <li>Crash when calling undocumented SQL function sqlite_rename_parent() with NULL parameters. Ticket [http://www.sqlite.org/src/info/264b970c4379fd | 264b970c43] <li>ORDER BY ignored if the query has an identical GROUP BY. Ticket [http://www.sqlite.org/src/info/b75a9ca6b0499 | b75a9ca6b0] <li>The group_concat(x,'') SQL function returns NULL instead of an empty string when all inputs are empty strings. Ticket [http://www.sqlite.org/src/info/55746f9e65f85 | 55746f9e65] } chng {2014-04-03 (3.8.4.3)} { <li>Add a [http://www.sqlite.org/src/fdiff?sbs=1&v1=7d539cedb1c&v2=ebad891b7494d&smhdr|one-character fix] for a problem that might cause incorrect query results on a query that mixes DISTINCT, GROUP BY in a subquery, and ORDER BY. |
︙ | ︙ |
Changes to pages/lang.in.
︙ | ︙ | |||
2847 2848 2849 2850 2851 2852 2853 | <p>The INSERT statement comes in three basic forms. <ul> <li><p>^The first form (with the "VALUES" keyword) creates one or more new rows in an existing table. ^If no column-list is specified then the number of values inserted into each row must be the same as the number of columns in the table. ^In this case | | | | | 2847 2848 2849 2850 2851 2852 2853 2854 2855 2856 2857 2858 2859 2860 2861 2862 2863 | <p>The INSERT statement comes in three basic forms. <ul> <li><p>^The first form (with the "VALUES" keyword) creates one or more new rows in an existing table. ^If no column-list is specified then the number of values inserted into each row must be the same as the number of columns in the table. ^In this case the result of evaluating the left-most expression from each term of the VALUES list is inserted into the left-most column of each new row, and so forth for each subsequent expression. ^If a column-list is specified, then the number of values in each term of the VALUE list must match the number of specified columns. ^Each of the named columns of the new row is populated with the results of evaluating the corresponding VALUES expression. ^Table columns that do not appear in the column list are populated with the default column value (specified as part of the CREATE TABLE statement), or with NULL if no default value is specified. |
︙ | ︙ |