This Day In History For 2020-08-03
1 Year Ago (more context)
|
2019-08-03
| ||
| 19:06 | Strengthen an assert() in the WHERE clause code generator for the min/max optimization. (check-in: 1bd4b97d64 user: drh tags: trunk) | |
| 16:51 | • Closed ticket [71e183cab6]: MIN() malfunctions for a query with ISNULL condition plus 4 other changes (artifact: 3dfda9a4da user: dan) | |
| 16:37 | Fix a problem with queries of the form "SELECT min(<expr>) ... WHERE <expr>=?" where there is an index on <expr>. Fix for [71e183ca]. (check-in: d465c3eef4 user: dan tags: trunk) | |
| 16:17 | In the ".wheretrace 0x100" debugging mode, show the structure of the main parameters to sqlite3WhereBegin() calls. (check-in: fd598e475d user: drh tags: trunk) | |
| 14:30 | • Ticket [71e183cab6] MIN() malfunctions for a query with ISNULL condition status still Open with 4 other changes (artifact: afd8a0b21f user: drh) | |
| 13:44 | • Ticket [71e183cab6]: 6 changes (artifact: 6226b17723 user: dan) | |
| 01:40 | Add the SQLITE_TESTCTRL_PRNG_SEED which can control the PRNG seed either directly or through the schema cookie of a supplied database connection. (check-in: 2660e9292a user: drh tags: trunk) | |
| 01:39 | Give the SQLITE_TESTCTRL_PRNG_SEED two arguments. The second argument if not NULL is a pointer to a database connection which seeds the connection from its schema cookie. In this way, fuzzers can control the PRNG seed. (Closed-Leaf check-in: 49aa344806 user: drh tags: prng-seed-test-control) | |
2 Years Ago (more context)
|
2018-08-03
| ||
| 23:04 | Completely remove the column cache logic, which has been a persistent source of bugs for many years. Due to recent enhancements to the performance of the OP_Column opcode, removing the column cache actually makes speed-check.sh run faster. Removing the column cache also saves about 1,800 bytes of code space. (check-in: 3f5f60cd75 user: drh tags: omit-column-cache) | |
| 20:19 | Fix the handling of sub-queries with LIMIT clauses by the optimization activated by compile-time symbol SQLITE_COUNTOFVIEW_OPTIMIZATION. (check-in: 21235d9a41 user: dan tags: trunk) | |
| 15:59 | • Edit [fa94b49e02eb6b8f|fa94b49e02]: Edit check-in comment. (artifact: af8209998f user: drh) | |
| 15:58 | Fix the OP_SeekRowid opcode so that it has no type-change side-effects on the key register in P3. This fixes an obcure problem that arises when doing equi-joins between a table with a TEXT column against another table with an INTEGER PRIMARY KEY. The original problem was discovered when OSSFuzz created such a query and hit an assert() in OP_VerifyTabCol that was specifically designed to catch these kinds of errors at run-time. Test cases for this fix are in TH3. (check-in: fa94b49e02 user: drh tags: trunk) | |
| 13:56 | Improve "PRAGMA vdbe_trace=ON" to always show the key values for the OP_IdxGT and related opcodes. (check-in: 0f881955ed user: drh tags: trunk) | |
3 Years Ago (more context)
|
2017-08-03
| ||
| 21:01 | • Edit [d8637badf63b90b6|d8637badf6]: Move to branch mistake. Mark "Closed". (artifact: 0dfc15afa6 user: dan) | |
| 20:13 | Modify swarmvtab to use a separate database connection for each database file. (check-in: 1f05ad29c3 user: dan tags: union-vtab) | |
| 15:50 | Add SQLITE_API qualifiers to public API functions in header file sqlite3rbu.h. (check-in: d8637badf6 user: dan tags: sqlite3rbu.h-fix) | |
| 15:43 | Fix some problems in RBU test cases. Also update RBU source code to better handle the trivial case where an RBU update is applied to a database zero pages in size. (check-in: 7676b39bc1 user: dan tags: trunk) | |
| 00:29 | Optimization to the comparison opcodes in the byte-code engine. (check-in: 654935c773 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2016-08-03
| ||
| 18:00 | Fix a problem with estimating the number of rows visited by a query that uses a multi-column IN(SELECT...) constraint. (check-in: 3c2f908f5b user: dan tags: rowvalue) | |
| 16:39 | Fix another problem involving vector range constraints and mixed ASC/DESC indexes. (check-in: 1559f4c434 user: dan tags: rowvalue) | |
| 16:14 | Fix stat4-based cost estimates for vector range constraints. (check-in: 18af74abc8 user: dan tags: rowvalue) | |
| 14:51 | Fix a typo in a comment in btree.c. No changes to code. (check-in: 722c128163 user: drh tags: trunk) | |
| 13:40 | Fix the --help output on fuzzcheck so that it fix in an 80-character window. (check-in: b91444b5db user: drh tags: trunk) | |
5 Years Ago (more context)
|
2015-08-03
| ||
| 17:03 | Add the "--uri" option to utility program "showdb". This option causes showdb to use sqlite with the SQLITE_OPEN_URI option to open the database file, instead of opening it directly using the OS open() function. (check-in: 90e34d5119 user: dan tags: showdb-uri-option) | |
| 13:44 | Allow a VIEW to reference undefined tables and functions when initially created. The error report is deferred until the VIEW is used. This allows views to be created before subviews and tables that the view references. (check-in: 70b57dafb3 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2010-08-03
| ||
| 18:29 | Merge trunk changes into experimental branch. (check-in: 15368a9f85 user: dan tags: experimental) | |
| 18:18 | Set the Pager.eState variable to PAGER_ERROR whenever the pager enters the error state. (check-in: 4d384761d2 user: dan tags: experimental) | |
| 18:06 | Fix disabled implementation-mark comments in func.c. (check-in: 57c0960038 user: drh tags: trunk) | |
| 15:57 | Add comments to clarify the purpose of the pager "error state". (check-in: fde4c59782 user: dan tags: experimental) | |
| 13:09 | • Fixed ticket [c38baa3d96]: REPLACE on a CHECK constraint does not work as advertised plus 2 other changes (artifact: 0f5aa05f8b user: drh) | |
| 13:08 | Fix the REPLACE conflict resolution so that it falls back to ABORT when a CHECK constraint fails. Ticket [c38baa3d969eab794]. (check-in: 4e157b7747 user: drh tags: trunk) | |
| 12:59 | • New ticket [c38baa3d96] REPLACE on a CHECK constraint does not work as advertised. (artifact: 564db3d998 user: drh) | |
| 12:48 | Add state diagram to comments in experimental version of pager.c. (check-in: 16dcf5a6d3 user: dan tags: experimental) | |
| 06:42 | Incremental checkin on pager state refactoring. (check-in: 0a636798bd user: dan tags: experimental) | |
20 Years Ago (more context)
|
2000-08-03
| ||
| 15:13 | spelling error (CVS 124) (check-in: 577421e5d3 user: drh tags: trunk) | |
| 15:09 | bug fix (CVS 123) (check-in: 4dabf5e4e6 user: drh tags: trunk) | |