Documentation Source Text

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

Changes to pages/changes.in.

    41     41   <li>Partial index causes assertion fault on UPDATE OR REPLACE.
    42     42       Ticket [http://www.sqlite.org/src/info/2ea3e9fe63 | 2ea3e9fe63]
    43     43   <li>Crash when calling undocumented SQL function sqlite_rename_parent()
    44     44       with NULL parameters.
    45     45       Ticket [http://www.sqlite.org/src/info/264b970c4379fd | 264b970c43]
    46     46   <li>ORDER BY ignored if the query has an identical GROUP BY.
    47     47       Ticket [http://www.sqlite.org/src/info/b75a9ca6b0499 |  b75a9ca6b0]
    48         -
           48  +<li>The group_concat(x,'') SQL function returns NULL instead of an empty string
           49  +    when all inputs are empty strings.  
           50  +    Ticket [http://www.sqlite.org/src/info/55746f9e65f85 |  55746f9e65]
    49     51   }
    50     52   
    51     53   chng {2014-04-03 (3.8.4.3)} {
    52     54   <li>Add a 
    53     55       [http://www.sqlite.org/src/fdiff?sbs=1&v1=7d539cedb1c&v2=ebad891b7494d&smhdr|one-character fix]
    54     56       for a problem that might cause incorrect query results on a query that mixes
    55     57       DISTINCT, GROUP BY in a subquery, and ORDER BY.

Changes to pages/lang.in.

  2847   2847   <p>The INSERT statement comes in three basic forms.  
  2848   2848   <ul>
  2849   2849   <li><p>^The first form (with the "VALUES" keyword) creates one or more
  2850   2850   new rows in
  2851   2851   an existing table. ^If no column-list is specified then the number
  2852   2852   of values inserted into each row
  2853   2853   must be the same as the number of columns in the table. ^In this case
  2854         -the result of evaluating the left-most expression in each term of
  2855         -the VALUES list is inserted into the left-most column of the each new row,
  2856         -and forth for each subsequent expression. ^If a
         2854  +the result of evaluating the left-most expression from each term of
         2855  +the VALUES list is inserted into the left-most column of each new row,
         2856  +and so forth for each subsequent expression. ^If a
  2857   2857   column-list is specified, then the number of values in each term of the
  2858   2858   VALUE list must match the number of
  2859   2859   specified columns. ^Each of the named columns of the new row is populated
  2860   2860   with the results of evaluating the corresponding VALUES expression. ^Table
  2861   2861   columns that do not appear in the column list are populated with the default
  2862   2862   column value (specified as part of the CREATE TABLE statement), or with NULL if
  2863   2863   no default value is specified.