/ Timeline
Login

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

36 check-ins using file test/shell1.test version 474ed53b

2013-09-13
22:38
VSIX tooling changes to support Visual Studio 2013. check-in: d56fac40 user: mistachkin tags: trunk
21:03
Fix the "const" qualifiers on the pragma name table. check-in: b74e6be8 user: drh tags: trunk
21:01
Add the soft_heap_limit pragma. check-in: c326356f user: drh tags: trunk
19:00
Tweak the new PRAGMA name parser to achieve full branch test coverage. check-in: c82e05c4 user: drh tags: trunk
18:15
Remove one unreachable branch and add asserts() to dupedExprStructSize(). New asserts verify that removed branch is unused and that constants that are ORed together in the output do not overlap. check-in: 86ad358b user: drh tags: trunk
17:47
Adjust the query planner to take into account WHERE clause terms that do not drive indices. Add the unlikely() and likelihood() functions used to give hints to the query planner about the selectivity of WHERE clause terms. check-in: bc446449 user: drh tags: trunk
16:56
Enhance the pragma lookup table generator script to output a comment that gives the number of pragmas. check-in: ca052050 user: drh tags: trunk
16:36
Change the PRAGMA parser to use a binary search for the pragma name. Also: Minor performance enhancement to sqlite3DbFree() and to the token dequoter. check-in: 870c030b user: drh tags: trunk
12:10
Add tests for the fts4 unicode61 tokenchars and separators options. check-in: 9ce6f40d user: dan tags: trunk
2013-09-12
23:42
Refactor the ExprSetIrreducible() macro into ExprSetVVAProperty(*,EP_NoReduce). This is a naming change only. The logic is the same. Closed-Leaf check-in: 695aee46 user: drh tags: unlikely-func
23:12
Fix typo in a macro name: "GlogUpperToLower" should be "GlobUpperToLower" check-in: 73634ca4 user: drh tags: trunk
17:29
Merge in the Expr.flags expansion to 32-bits. Use an extra bit to help optimize the sqlite3ExprSkipCollate() routine. check-in: 4c84d1b4 user: drh tags: unlikely-func
16:50
Increase the number of bits available in Expr.flags. Other tweaks aimed at making expression processing more robust. Closed-Leaf check-in: 579a5125 user: drh tags: expr-tuning
02:09
For error log messages generated by the Win32 native allocator, make sure the correct format specifier is used for the value returned by GetLastError(). check-in: 75a8a8c1 user: mistachkin tags: trunk
01:47
Fix a couple more harmless compiler warnings. check-in: 59708674 user: mistachkin tags: trunk
01:33
Remove two obsolete fields from the sqlite3 object. check-in: 117fa5fb user: drh tags: trunk
00:54
Fix harmless compiler warning. check-in: 2b510614 user: mistachkin tags: trunk
00:40
Merge updates from trunk. Closed-Leaf check-in: fca799f0 user: mistachkin tags: vsix2013
2013-09-11
17:39
Improvements to likelihood processing so that commuting an unindexed term in the WHERE clause does not change the query plan. check-in: 6e6bded0 user: drh tags: unlikely-func
14:57
Add test cases to cover TPC-H Q8. check-in: eb5cef83 user: drh tags: trunk
14:34
Additional unlikely() test cases. Logic tweaks to support test coverage. check-in: 5d00cce7 user: drh tags: unlikely-func
11:38
Change the name of the two-argument unlikely() function to likelihood(). Add test cases. check-in: 29a359b8 user: drh tags: unlikely-func
03:53
Tweaks to the index selection logic. check-in: 52d52688 user: drh tags: unlikely-func
2013-09-10
01:53
Merge trunk fixes into the unlikely-func branch. check-in: a51d7515 user: drh tags: unlikely-func
01:41
Deterministically initialize the PRNG used as a tie-breaker in the ANALYZE command, so that the analysis is always the same given the same database. This simplifies testing. check-in: 48ed8b56 user: drh tags: trunk
2013-09-09
19:37
Make sure that the transitive constraint optimization does not cause WHERE clause terms to be disabled prematurely. We are unable to find a test case that fails because of this, but it seems prudent to make this preventative change nevertheless. check-in: d6e361d7 user: drh tags: trunk
2013-09-07
00:29
Continuing refinements of the logic to take WHERE clause terms not used for indexing into account when computing the number of output rows from each table. check-in: b65dc534 user: drh tags: unlikely-func
2013-09-06
22:27
Merge updates from trunk. check-in: 8922be1a user: mistachkin tags: toTypeFuncs
17:45
Enhance the plan solver to take into account the number of output rows when computing the set of paths to retain for the next cycle. check-in: 1a46a724 user: drh tags: unlikely-func
15:23
Initial implementation of the unlikely() SQL function used as a hint to the query planner. check-in: 036fc37a user: drh tags: unlikely-func
13:10
Combine the FuncDef.iPrefEnc and FuncDef.flags fields into a single new FuncDef.funcFlags field. check-in: 97b10e66 user: drh tags: trunk
00:40
Make sure the destination WhereLoop is left in a sane state when an OOM fault occurs inside of whereLoopXfer(). check-in: a99a53b8 user: drh tags: trunk
2013-09-05
18:40
When preparing an UPDATE statement, avoid generating VDBE code for those foreign key related actions and constraint checks that may be seen to be unnecessary by considering the subset of table columns potentially modified by the UPDATE. check-in: e940b5de user: dan tags: trunk
2013-09-04
18:14
Rearrange the order of conditions in an "if" statement to facilitate testing. check-in: 8462fb43 user: drh tags: trunk
16:38
Add tests to improve coverage when SQLITE_ENABLE_STAT3 is defined. check-in: f929e9b4 user: dan tags: trunk
16:08
Fix a bug in the command-line shell for ".mode insert" on UTF16 databases with BLOB values. check-in: d8fdc782 user: drh tags: trunk