Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 ancestors of 3e0590dee0e68cc1
|
2015-03-16
| ||
| 16:28 | When estimating the number of rows visited by a range scan for which the keys consist of more than one field, consider prefixes of stat4 samples as well as the full samples. This generates more accurate estimates. (check-in: 3e0590dee0 user: dan tags: trunk) | |
| 13:48 | Use #ifdef to omit code that is only used for STAT3 and STAT4. (check-in: f2c9c5b57b user: drh tags: trunk) | |
| 09:21 | Another test case for the planner change on this branch. (Closed-Leaf check-in: f2207a0691 user: dan tags: stat4-change) | |
|
2015-03-14
| ||
| 18:59 | When estimating the number of rows visited by a range scan for which the keys consist of more than one field, consider prefixes of stat4 samples as well as the full samples. (check-in: e1caf93c9a user: dan tags: stat4-change) | |
|
2015-03-13
| ||
| 15:44 | Add tests to ensure "PRAGMA incremental_vacuum" and "PRAGMA auto_vacuum = incremental" handle corrupt databases correctly. (check-in: 1c2166cb2a user: dan tags: trunk) | |
| 08:31 | Extra tests for commit [0f250957]. (check-in: 5aa522dcb9 user: dan tags: trunk) | |
| 00:11 | Remove debugging logic accidently included in the previous check-in. (check-in: 2887fb38ff user: drh tags: trunk) | |
|
2015-03-12
| ||
| 23:48 | Fix the "now" option for date-time functions for cases when STAT4 is disabled. (check-in: 3ac1f6a3cf user: drh tags: trunk) | |
| 21:22 | When STAT4 is enabled, allow probes of the STAT4 table using the value of constant functions computed at compile-time. (check-in: 0f250957cd user: drh tags: trunk) | |
| 21:02 | Always disallow functions as the DEFAULT of a column. Add assert()s and (Closed-Leaf check-in: a991bb1a9e user: drh tags: stat4-function) | |
| 19:12 | Disable multiplexing of master-journal files in the test_multiplex.c module. (check-in: b8684df395 user: dan tags: trunk) | |
| 18:38 | If an error occurs in the compile-time evaluation of an application-defined function, then propagate back out the exact error code, not just the generic SQLITE_ERROR. (check-in: 93f42586cc user: drh tags: stat4-function) | |
| 06:46 | The valueFromFunction() routine is better able to handle OOM errors. Omit unreachable branches. (check-in: 8fb6bd9be5 user: drh tags: stat4-function) | |
| 05:08 | Improve the text on one of the opcode documentation comments in vdbe.c. (check-in: 08958f5797 user: drh tags: trunk) | |
|
2015-03-11
| ||
| 20:59 | Allow the default value for columns added using ALTER TABLE ADD COLUMN to be a function in existing schemas loaded from disk. But prevent this version of SQLite from being used to create such a column. (check-in: ff868e22ca user: dan tags: stat4-function) | |
| 20:06 | Allow the query planner to evaluate deterministic scalar SQL functions used in WHERE constraints if all arguments are SQL literals in order to compare the results with sqlite_stat4 sample data. (check-in: b7f1fc26d2 user: dan tags: stat4-function) | |
| 14:34 | Expand the multi-process test cases to repeat each case 20 times and to repeat tests using different journal modes. (check-in: a2715b049a user: drh tags: trunk) | |
|
2015-03-10
| ||
| 15:34 | Fix an incrblob2 test case so that it works on 32-bit systems. (check-in: 8d0b11c96e user: drh tags: trunk) | |
| 13:50 | Revise test cases in malloc5.test to accommodate varying allocation sizes returned by some system malloc() implementations. (check-in: fbae6bafd7 user: drh tags: trunk) | |
|
2015-03-09
| ||
| 13:01 | Fix the LIKE optimization so that it works even if there are additional range contraints on the column that is subject to the LIKE or GLOB. (check-in: 984c3fd526 user: drh tags: trunk) | |
| 12:11 | Always use LIKE optimization range constraints in pairs. (Closed-Leaf check-in: 0e02dc94fd user: drh tags: like-opt-fix) | |
| 10:40 | Increase the version number to 3.8.9 (check-in: e5da5e7d5d user: drh tags: trunk) | |
|
2015-03-07
| ||
| 20:32 | Fix another problem with the LIKE optimization. (check-in: 465bfc72d2 user: drh tags: like-opt-fix) | |
| 13:56 | Fix the LIKE optimization so that it finds BLOB entries in addition to text entries. Ticket [05f43be8fdda9f]. (check-in: 74cb0b032f user: drh tags: trunk) | |
| 12:58 | New test cases for LIKE and GLOB with BLOB left-hand side values. (Closed-Leaf check-in: 50fa3c5fae user: drh tags: like-opt-fix) | |
| 03:02 | Remove some code that is commented out. (check-in: 55ff429177 user: drh tags: like-opt-fix) | |
| 02:51 | Fix problems with reverse order sorting and indexes in the LIKE optimization. (check-in: 564b8fe794 user: drh tags: like-opt-fix) | |
| 00:57 | Refactor some jump opcodes in the VDBE. Add JumpZeroIncr and DecrJumpZero. Fix the LIKE optimization to work with DESC sort order. (check-in: 26cb5145bf user: drh tags: like-opt-fix) | |
|
2015-03-06
| ||
| 20:49 | Test cases added. Comments fixed. Proposed solution for ticket [05f43be8fdda9fbd9]. (check-in: 6b993bd540 user: drh tags: like-opt-fix) | |
| 19:47 | Fix the LIKE optimization even when comparing mixed-case BLOBs. (check-in: a58aafdb4e user: drh tags: like-opt-fix) | |
| 16:45 | The LIKE optimization must be applied twice, once for strings and a second time for BLOBs. Ticket [05f43be8fdda9f]. This check-in is a proof-of-concept of how that might be done. (check-in: 5757e803cb user: drh tags: like-opt-fix) | |
| 04:37 | Clearification of some documentation text. Added requirements marks. (check-in: 8c1e85aab9 user: drh tags: trunk) | |
| 03:31 | Clarification of documentation on sqlite3_backup. (check-in: 31d5e9b42e user: drh tags: trunk) | |
|
2015-03-05
| ||
| 15:34 | New test cases and requirements marks for PRAGMA index_info, index_xinfo, and index_list. (check-in: e5b13634d9 user: drh tags: trunk) | |
| 14:29 | Revert "PRAGMA index_info" to output only three columns, for complete compatibility with prior versions. The new "PRAGMA index_xinfo" can be used to get the extra information in 4th, 5th, and 6th columns. (check-in: fc543c2c5c user: drh tags: trunk) | |
| 01:29 | New requirements marks on compound SELECT statements. (check-in: e7991bc510 user: drh tags: trunk) | |
|
2015-03-04
| ||
| 23:14 | New requirements marks on INSERT and INDEXED BY and on some sqlite3_config() options. (check-in: c298ea0bd9 user: drh tags: trunk) | |
| 20:18 | Fix harmless compiler warning. (check-in: 580dae4615 user: mistachkin tags: trunk) | |
| 15:35 | Refinement to the wording of the documentation on depreciated functions. (check-in: 04a59d6f7e user: drh tags: trunk) | |
| 15:25 | Remove a surplus </dl> mark in the documentation. No changes to code. (check-in: 5450e4650b user: drh tags: trunk) | |
|
2015-03-03
| ||
| 20:42 | Clean up #ifdef logic dealing with VxWorks in os_unix.c. On VxWorks, automatically use posix advisory locking if it is available or fall back to named semaphore locking if not. (check-in: ac8c7ca3db user: drh tags: trunk) | |
| 19:56 | Fix compiler warnings when compiling under VxWorks 7. (check-in: 55c21521a6 user: drh tags: trunk) | |
| 16:58 | Enhance SQLITE_ALLOW_URI_AUTHORITITY to elide //localhost/ and to deal with dodgy URIs that contain too many "/" characters. (check-in: 39b566a2d0 user: drh tags: trunk) | |
| 14:00 | Fix over-length source code lines in the main.c source file. (check-in: debba6f161 user: drh tags: trunk) | |
|
2015-03-02
| ||
| 22:06 | Changes so that the amalgamation and the command-line shell build without modifications on VxWorks 7. Still gives a few compiler warnings, and still mostly untested on that platform. (check-in: 7d92f1f11e user: drh tags: trunk) | |
| 17:25 | Ensure that automatic indexes are *not* considered when doing the the subqueries of the OR-optimization. (check-in: 17890292cf user: drh tags: trunk) | |
|
2015-02-28
| ||
| 14:03 | In the command-line shell, the inability to read ~/.sqliterc is no longer a fatal error. A warning is issued, but processing continues. (check-in: 6bf6246306 user: drh tags: trunk) | |
| 01:04 | More test cases and requirements marks for pragmas. (check-in: fc51037cd9 user: drh tags: trunk) | |
|
2015-02-27
| ||
| 21:53 | Remove all references to SQLITE_DEFAULT_TEMP_CACHE_SIZE. Add requirements marks related to cache_size changing. (check-in: 766ad65025 user: drh tags: trunk) | |
| 20:28 | New requirements marks and a few new test cases to go with them. No changes to code. (check-in: 8c2b29d9ac user: drh tags: trunk) | |
| 00:33 | Add a couple of requirements marks. (check-in: d70b0fd4c9 user: drh tags: trunk) | |