Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 check-ins occurring around 7dd4968f235d6e1c.
|
2013-09-11
| ||
| 14:57 | Add test cases to cover TPC-H Q8. check-in: eb5cef8351 user: drh tags: trunk | |
| 14:34 | Additional unlikely() test cases. Logic tweaks to support test coverage. check-in: 5d00cce74a user: drh tags: unlikely-func | |
| 11:38 | Change the name of the two-argument unlikely() function to likelihood(). Add test cases. check-in: 29a359b8d7 user: drh tags: unlikely-func | |
| 03:53 | Tweaks to the index selection logic. check-in: 52d5268864 user: drh tags: unlikely-func | |
|
2013-09-10
| ||
| 01:53 | Merge trunk fixes into the unlikely-func branch. check-in: a51d751553 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: 48ed8b565b 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: d6e361d7fb 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: b65dc53415 user: drh tags: unlikely-func | |
|
2013-09-06
| ||
| 22:27 | Merge updates from trunk. check-in: 8922be1a3e user: mistachkin tags: toTypeFuncs | |
| 21:41 | Add the ability to generate assembly listing files using the MSVC makefile. check-in: 6caa2cd104 user: mistachkin tags: toTypeFuncs | |
| 20:30 | When converting from a BLOB value in the tointeger() and toreal() SQL functions, make sure that endianness of the machine does not matter. check-in: 94c4cdc50d 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: 1a46a72423 user: drh tags: unlikely-func | |
| 15:23 | Initial implementation of the unlikely() SQL function used as a hint to the query planner. check-in: 036fc37a03 user: drh tags: unlikely-func | |
| 13:10 | Combine the FuncDef.iPrefEnc and FuncDef.flags fields into a single new FuncDef.funcFlags field. check-in: 97b10e66e9 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: a99a53b81e 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: e940b5de49 user: dan tags: trunk | |
|
2013-09-04
| ||
| 18:14 | Rearrange the order of conditions in an "if" statement to facilitate testing. check-in: 8462fb43c2 user: drh tags: trunk | |
| 16:38 | Add tests to improve coverage when SQLITE_ENABLE_STAT3 is defined. check-in: f929e9b41f 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: d8fdc78218 user: drh tags: trunk | |
| 15:15 | The sqlite3Stat4ProbeSetValue() routine should always return results using the database encoding. check-in: eb21663271 user: drh tags: trunk | |
| 04:04 | Fix out-of-order variable declaration. Fix harmless compiler warning. check-in: 8df95bb0b3 user: mistachkin tags: trunk | |
| 02:07 | Conditionally exclude code from analyze.c that is not used by STAT3. check-in: a48948a170 user: drh tags: trunk | |
| 00:58 | Additional test cases for the tointeger() and toreal() SQL functions when converting from a BLOB. check-in: e1814452fa user: mistachkin tags: toTypeFuncs | |
|
2013-09-03
| ||
| 19:26 | Harden the STAT4 logic in where.c against OOM faults. check-in: 91d2cfbc95 user: drh tags: trunk | |
| 17:11 | Version 3.8.0.2 check-in: 7dd4968f23 user: drh tags: release, version-3.8.0.2, branch-3.8.0 | |
| 14:49 | Merge in all the latest trunk changes, including the win32-longpath VFS and the fix for the segfault in the omit-left-join optimization. check-in: cdd3838b78 user: drh tags: sessions | |
| 14:43 | Fix another problem in stat4 sample selection. check-in: d59f580904 user: dan tags: trunk | |
| 14:33 | Make sure the omit-noop-left-join optimization is not applied if columns of the LEFT JOIN are used in the ORDER BY clause. Ticket [be84e357c035]. Increase version number to 3.8.0.2. check-in: cce541864d user: drh tags: branch-3.8.0 | |
| 14:03 | Make sure the omit-noop-left-join optimization is not applied if columns of the LEFT JOIN are used in the ORDER BY clause. Ticket [be84e357c035] check-in: 0303d6bc71 user: drh tags: trunk | |
|
2013-09-02
| ||
| 23:40 | Add the experimental SQLITE_DEFAULT_INDEX_SHAPE=1 compile-time option that makes a much more pessimistic guess at the effectiveness of unanalyzed indices. Leaf check-in: d8daaba7da user: drh tags: index-shape-1 | |
| 20:22 | Simplify branch coverage testing by interchanging the order of two tests in the whereLoopInsert() function. check-in: f7079b5365 user: drh tags: trunk | |
| 18:58 | Further stat4 related tests. check-in: 0a702c4b4c user: dan tags: trunk | |
| 11:52 | Add tests to check if ANALYZE is choosing common non-periodic samples for the stat4 table. check-in: 175842997a user: dan tags: trunk | |
| 07:16 | Fix a problem with using stat4 data to estimate the number of rows scanned by a range constraint on the second or subsequent column of any index where an affinity transformation must be applied to the constraint argument. check-in: c21f58d848 user: dan tags: trunk | |
|
2013-09-01
| ||
| 23:36 | Merge updates from trunk. check-in: 2982725e12 user: mistachkin tags: toTypeFuncs | |
|
2013-08-31
| ||
| 21:41 | Handle BLOBs specially, treating them as binary, in the tointeger() and toreal() SQL functions. check-in: c4c53acb98 user: mistachkin tags: toTypeFuncs | |
| 18:36 | Cleanup of the windows VFS, including added support for Cygwin, fixes for compiler warnings under unusual configurations, and improved diagnostic error messages. check-in: c94933f132 user: drh tags: trunk | |
| 18:06 | Revise the amalgamation tool to allow 'duplicate' include files to be retained manually while still preserving the existing line numbers. Closed-Leaf check-in: aa48284637 user: mistachkin tags: cygwinTempPath | |
| 17:21 | Fix a problem causing SQLite not to use stat4 or stat3 data to analyze constraints of the form "column = expr COLLATE collation" (those with an explicit COLLATE on the non-column side of the comparison operator). check-in: 1e86d81d46 user: dan tags: trunk | |
| 17:01 | Enhancements to the Win32 API definition macros. check-in: b1811baab6 user: mistachkin tags: cygwinTempPath | |
| 14:56 | Reenable a test accidentally disabled when the stat4 branch was merged. check-in: d9fadc8fa6 user: dan tags: trunk | |
| 05:46 | Avoid commenting out #include statements when building the amalgamation source code file. check-in: 2fca6d784b user: mistachkin tags: cygwinTempPath | |
| 05:13 | Fix harmless MSVC compiler warning with MEMDEBUG defined. check-in: b48cfd2dfc user: mistachkin tags: cygwinTempPath | |
| 02:48 | Improve the consistency of the diagnostic messages on Windows. check-in: c6f174a0cb user: mistachkin tags: cygwinTempPath | |
|
2013-08-30
| ||
| 21:52 | Add support for Cygwin when handling temporary file names. Improve error codes and diagnostic messages for temporary file name handling on Windows. Rename winConvertUtf8Filename to winConvertFromUtf8Filename. Improve placement and comments for forward function declarations. check-in: a411df7251 user: mistachkin tags: cygwinTempPath | |
| 20:19 | Fix compiler warnings in analyze.c. check-in: 5bbd2ccb3d user: dan tags: trunk | |
| 19:59 | Fix comment typo in analyze.c. No changes to code. check-in: dbc3175044 user: mistachkin tags: trunk | |
| 17:50 | Fix comment typos in the where.c module. No code changes. check-in: 1e0b77cf0e user: drh tags: trunk | |
| 17:35 | If the cost of two whereLoop objects is the same in every way except that one has fewer expected output rows than the other, then choose the one with fewer output rows. check-in: 79e458ef7a user: drh tags: trunk | |
| 14:24 | Add the SQLITE_MINIMUM_FILE_DESCRIPTOR compile-time option, for control over exactly which low-numbered file descriptors SQLite will use. check-in: ba51905343 user: drh tags: trunk | |