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: |
6aed4ea34c4163c682ad5bb2956fdf4f |
| 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
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)