/ Check-in [6aed4ea3]
Login

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

Overview
Comment:Make sure the SQLITE_Stat34 optimization switch is always 0x800, a value which is hard-coded in the TH3 test suite.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | prefer-coroutine-sort-subquery
Files: files | file ages | folders
SHA3-256: 6aed4ea34c4163c682ad5bb2956fdf4f3a3ad048fefd3edab0fef6761c3783cc
User & Date: drh 2017-09-30 10:50:34
Context
2017-09-30
11:47
More details in the header comment of pushDownWhereTerms(). No changes to code. Closed-Leaf check-in: 92848623 user: drh tags: prefer-coroutine-sort-subquery
10:50
Make sure the SQLITE_Stat34 optimization switch is always 0x800, a value which is hard-coded in the TH3 test suite. check-in: 6aed4ea3 user: drh tags: prefer-coroutine-sort-subquery
01:25
Fix unreachable conditionals and revise a testcase that was made obsolete by the changes on this branch. check-in: 71f0adf7 user: drh tags: prefer-coroutine-sort-subquery
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/sqliteInt.h.

  1507   1507   #define SQLITE_GroupByOrder   0x0004   /* GROUPBY cover of ORDERBY */
  1508   1508   #define SQLITE_FactorOutConst 0x0008   /* Constant factoring */
  1509   1509   #define SQLITE_DistinctOpt    0x0010   /* DISTINCT using indexes */
  1510   1510   #define SQLITE_CoverIdxScan   0x0020   /* Covering index scans */
  1511   1511   #define SQLITE_OrderByIdxJoin 0x0040   /* ORDER BY of joins via index */
  1512   1512   #define SQLITE_Transitive     0x0080   /* Transitive constraints */
  1513   1513   #define SQLITE_OmitNoopJoin   0x0100   /* Omit unused tables in joins */
  1514         -#define SQLITE_Stat34         0x0200   /* Use STAT3 or STAT4 data */
  1515         -#define SQLITE_CountOfView    0x0400   /* The count-of-view optimization */
  1516         -#define SQLITE_CursorHints    0x0800   /* Add OP_CursorHint opcodes */
         1514  +#define SQLITE_CountOfView    0x0200   /* The count-of-view optimization */
         1515  +#define SQLITE_CursorHints    0x0400   /* Add OP_CursorHint opcodes */
         1516  +#define SQLITE_Stat34         0x0800   /* Use STAT3 or STAT4 data */
         1517  +   /* TH3 expects the Stat34  ^^^^^^ value to be 0x0800.  Don't change it */
  1517   1518   #define SQLITE_AllOpts        0xffff   /* All optimizations */
  1518   1519   
  1519   1520   /*
  1520   1521   ** Macros for testing whether or not optimizations are enabled or disabled.
  1521   1522   */
  1522   1523   #define OptimizationDisabled(db, mask)  (((db)->dbOptFlags&(mask))!=0)
  1523   1524   #define OptimizationEnabled(db, mask)   (((db)->dbOptFlags&(mask))==0)