This Day In History For 2020-05-29
1 Year Ago (more context)
|
2019-05-29
| ||
| 21:18 | Much faster implementation of applyNumericAffinity() by avoiding some unnecessary calls to sqlite3Atoi64(). (check-in: c1d8a3f6 user: drh tags: trunk) | |
| 18:33 | Add an assert() as an additional test for fix in check-in [523b42371122d9e1b3]. (check-in: f9e85e6c user: drh tags: trunk) | |
| 17:22 | • Fixed ticket [c41afac3]: LIMIT applied globally rather than locally plus 5 other changes (artifact: d33af184 user: drh) | |
| 17:22 | Fix the query flattener optimization so that it preserve the "SF_Compound" bit when flattening a compound subquery into a non-compound outer query. Failure to preserve that bit could allow subsequent flattenings which are not valid. Fix for ticket [c41afac34f15781fe09cd]. (check-in: 523b4237 user: drh tags: trunk) | |
| 16:04 | • New ticket [c41afac3] LIMIT applied globally rather than locally. (artifact: 67d7ba17 user: drh) | |
2 Years Ago (more context)
|
2018-05-29
| ||
| 19:12 | Increase the number of database handles opened by test script oserror.test to provoke an "out of file-descriptors" error to 20000 (from 2000). (check-in: 3b00f734 user: dan tags: trunk) | |
| 17:17 | Fix a problem in the geopoly json parser associated with spaces before a coordinate number. (check-in: 9d8d3af8 user: drh tags: rtree-geopoly) | |
| 16:37 | Fix autoinc.test and resetdb.test so that they work with all permutations. (check-in: 89f56d6b user: dan tags: trunk) | |
| 15:18 | Add a comment to justify a goto statement. No code changes. (check-in: f141d806 user: drh tags: trunk) | |
| 14:29 | More minor changes to test scripts. (check-in: ce9b756f user: dan tags: trunk) | |
| 14:06 | Fix some test script issues caused by recent EXPLAIN QUERY PLAN enhancements. (check-in: f808e228 user: dan tags: trunk) | |
| 13:25 | Do not run test file "resetdb.test" as part of permutation "inmemory_journal". (check-in: 4921e5ba user: dan tags: trunk) | |
3 Years Ago (more context)
|
2017-05-29
| ||
| 22:44 | More efficient error handling and reset in the binding mechanism. (check-in: 9a3e3b34 user: drh tags: trunk) | |
| 19:23 | Instead of a root page number, log the object (table or index) name if a page level locking conflict is detected. (check-in: 9ad846e5 user: dan tags: begin-concurrent) | |
| 17:59 | Omit unnecessary fstat() calls for determining the database file size, resulting in smaller and faster code. (check-in: dd61c736 user: drh tags: trunk) | |
| 17:43 | Fix an issue with OPT_FEATURE_FLAGS in configure.ac. (check-in: 43ce3bd3 user: drh tags: trunk) | |
| 16:45 | Avoid unnecessary fstat() calls to determine the database size when transitioning into a read transaction on a rollback-mode database. (Closed-Leaf check-in: 6c3476b5 user: drh tags: io-opt) | |
| 14:57 | Avoid unnecessary calls to fstat() to determine the database file size. (check-in: c733a1de user: drh tags: io-opt) | |
| 14:30 | Fix a typo in a comment. No code changes. (check-in: cb29b838 user: drh tags: trunk) | |
| 14:27 | Enhance the log messages emitted when a page conflict is detected. (check-in: 92618492 user: dan tags: begin-concurrent) | |
| 14:26 | Optimizations to the Walker object and its methods to make the code a little smaller and to help it run a little faster. (check-in: 6854a34e user: drh tags: trunk) | |
| 13:09 | Correctly initialize the iSelectId of FROM clause terms that are a self join of a reused materialized subquery. Without this, the EXPLAIN QUERY PLAN output for the query will identify the subquery using the uninitialized (and arbitrary) iSelectId. (check-in: 43c9ae37 user: drh tags: trunk) | |
| 03:48 | Improve shell help text for the '.open' command. (check-in: 7cc940a9 user: mistachkin tags: trunk) | |
5 Years Ago (more context)
|
2015-05-29
| ||
| 19:04 | Import recent enhancements from trunk. (check-in: 54bec164 user: drh tags: sessions) | |
| 19:00 | Add extra tests and fixes for multi-column matches. (check-in: ae6794ff user: dan tags: fts5) | |
| 18:42 | Ensure that allocateBtreePage() always clears the MemPage pointer when it fails due to an I/O or memory allocation error. (check-in: 09a38bf6 user: drh tags: trunk) | |
| 17:51 | Move two unreachable conditionals inside of NEVER() or assert(). (check-in: db4e9728 user: drh tags: trunk) | |
| 17:13 | Remove a corruption test in balance_nonroot that is superceded by a prior better check. (check-in: 00693682 user: drh tags: trunk) | |
| 15:55 | Add syntax to fts5 used to specify that a phrase or NEAR group should match a subset of columns. For example "[col1 col2 ...] : <phrase>". (check-in: 0fc0ea20 user: dan tags: fts5) | |
| 15:15 | Omit the rowallock.test script (Read-Only WAL lock) from the inmemory_journal permutation. (check-in: d21db330 user: drh tags: trunk) | |
| 14:47 | Add support for automatic indexes on FROM-clause subqueries that are implemented via co-routine. (check-in: 020b8b10 user: drh tags: trunk) | |
| 14:36 | Add some extra source-code comments and a test case. (Closed-Leaf check-in: 6d410442 user: drh tags: coroutine-autoindex) | |
| 13:55 | An attempt to allow automatic index creation on subqueries accessed via co-routine. (check-in: 521345ad user: drh tags: coroutine-autoindex) | |
| 01:35 | Using "SELECT ALL" instead of just "SELECT" on a query that uses a single unflattenable subquery or view in its FROM clause will force the subquery to be manifested into a temporary table rather than run incrementally using a co-routine. This is a stop-gap means of controlling the decision to manifest while we try to work out a better to make that decision automatically. (check-in: a29e117d user: drh tags: trunk) | |
10 Years Ago (more context)
|
2010-05-29
| ||
| 08:40 | Add tests to fkey2.test to check that ON CONFLICT clauses do not affect SQLite's behaviour when an FK constraint is violated. (check-in: e9e5b100 user: dan tags: trunk) | |
| 06:19 | • Edit [60c22bde52121993|60c22bde]: Edit check-in comment. Timestamp 2010-05-29 06:18:55. (artifact: 148ddca9 user: dan) | |
| 06:18 | Minor changes to checksum related test cases. (check-in: 60c22bde user: dan tags: trunk) | |
15 Years Ago (more context)
|
2005-05-29
| ||
| 14:23 | Omit a couple of test cases if the library is compiled without subqueries. (CVS 2488) (check-in: 6bc37297 user: danielk1977 tags: trunk) | |
20 Years Ago (more context)
|
2000-05-29
| ||
| 23:58 | :-) (CVS 9) (check-in: 84333008 user: drh tags: trunk) | |
| 23:48 | :-) (CVS 8) (check-in: e34143c2 user: drh tags: trunk) | |
| 23:30 | :-) (CVS 7) (check-in: fdf4b31a user: drh tags: trunk) | |
| 20:41 | :-) (CVS 6) (check-in: 1517f852 user: drh tags: trunk) | |
| 18:50 | :-) (CVS 5) (check-in: 9fd0628a user: drh tags: trunk) | |
| 18:32 | :-) (CVS 4) (check-in: 1d328670 user: drh tags: trunk) | |
| 18:20 | :-) (CVS 3) (check-in: 9e36a601 user: drh tags: trunk) | |
| 17:44 | :-) (CVS 2) (check-in: 53841c66 user: drh tags: trunk) | |
| 14:26 | initial check-in of the new version (CVS 1) (check-in: 6f3655f7 user: drh tags: trunk) | |
| 14:16 | initial empty check-in (check-in: 704b122e user: drh tags: trunk) | |