/ Check-in [7fdad122]
Login

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

Overview
Comment:Fix requirements marks. No code changes.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 7fdad122a21e4b01bd678198fd5131dc32febe3af366bd6368505398255f9822
User & Date: drh 2018-05-04 18:32:11
Context
2018-05-05
01:23
Fix a slightly incorrect corruption detection branch in the btree logic. check-in: 9191ff67 user: drh tags: trunk
2018-05-04
19:33
Merge recent enhancements from trunk. check-in: e17bca2c user: drh tags: apple-osx
19:18
Merge enhancements from trunk. check-in: 9650f71b user: drh tags: cell-overwrite-prototype
18:32
Fix requirements marks. No code changes. check-in: 7fdad122 user: drh tags: trunk
04:49
For the amalgamation-tarball, enable FTS5 and JSON1 by default and provide a new --enable-debug option that actives debugging facilities. check-in: 03edecaf user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/e_createtable.test.

   652    652     1    "CREATE TABLE x1 AS SELECT * FROM t1"                     {a b c}
   653    653     2    "CREATE TABLE x1 AS SELECT c, b, a FROM t1"               {c b a}
   654    654     3    "CREATE TABLE x1 AS SELECT * FROM t1, t2"                 {a b c d e f}
   655    655     4    "CREATE TABLE x1 AS SELECT count(*) FROM t1"              {count(*)}
   656    656     5    "CREATE TABLE x1 AS SELECT count(a) AS a, max(b) FROM t1" {a max(b)}
   657    657   }
   658    658   
   659         -# EVIDENCE-OF: R-37111-22855 The declared type of each column is
          659  +# EVIDENCE-OF: R-55407-45319 The declared type of each column is
   660    660   # determined by the expression affinity of the corresponding expression
   661    661   # in the result set of the SELECT statement, as follows: Expression
   662    662   # Affinity Column Declared Type TEXT "TEXT" NUMERIC "NUM" INTEGER "INT"
   663         -# REAL "REAL" NONE "" (empty string)
          663  +# REAL "REAL" BLOB (a.k.a "NONE") "" (empty string)
   664    664   #
   665    665   do_createtable_tests 2.2 -tclquery {
   666    666     table_column_decltypes x1
   667    667   } -repair {
   668    668     catchsql { DROP TABLE x1 }
   669    669   } {
   670    670     1    "CREATE TABLE x1 AS SELECT a FROM t1"     {""}

Changes to test/indexedby.test.

    55     55   }
    56     56   
    57     57   # Parser tests. Test that an INDEXED BY or NOT INDEX clause can be 
    58     58   # attached to a table in the FROM clause, but not to a sub-select or
    59     59   # SQL view. Also test that specifying an index that does not exist or
    60     60   # is attached to a different table is detected as an error.
    61     61   #
    62         -# EVIDENCE-OF: R-07004-11522 -- syntax diagram qualified-table-name
           62  +# X-EVIDENCE-OF: R-07004-11522 -- syntax diagram qualified-table-name
    63     63   # 
    64     64   # EVIDENCE-OF: R-58230-57098 The "INDEXED BY index-name" phrase
    65     65   # specifies that the named index must be used in order to look up values
    66     66   # on the preceding table.
    67     67   #
    68     68   do_test indexedby-2.1 {
    69     69     execsql { SELECT * FROM t1 NOT INDEXED WHERE a = 'one' AND b = 'two'}