This Day In History For 2025-06-06
1 Year Ago (more context)
|
2024-06-06
| ||
| 23:59 | • Edit [e94dfe9928750dd9|e94dfe9928]: Mark "Closed". (artifact: 0af92934be user: drh) | |
| 23:56 | Allow the query planner access to the argument of LIMIT even if that argument is a bound parameter. (check-in: c4a9dda280 user: drh tags: trunk) | |
| 23:22 | Omit bogus tests accidentally added by the privious commit. (Closed-Leaf check-in: e94dfe9928 user: drh tags: var-in-limit) | |
| 16:06 | Better optimize queries that use parameters in the LIMIT clause. (Closed-Leaf check-in: b44f267671 user: drh tags: branch-3.28-var-in-limit) | |
| 15:03 | Better optimize queries that use parameters in the LIMIT clause. (check-in: e58cb304d1 user: drh tags: var-in-limit) | |
| 12:22 | Re-enable [dcc2bb2c562e97e090174], as [296eeb26c816bc73] corrects the wasi-sdk build problem the former check-in triggered. Reported in forum post 143e40d7f4e79c66. (check-in: f66608bd35 user: stephan tags: trunk) | |
| 01:21 | Adjust the parser so that the value of TK_ISNOT is similar to the value of TK_IS. This helps the compiler generate faster switch() statements on the Expr.op fields when there are cases for TK_ISNOT and other common operators. (check-in: 34f05c3d89 user: drh tags: trunk) | |
| 01:00 | Small performance optimization in the operatorMask routine of the WHERE clause analysis logic. (check-in: 9d69fc1c87 user: drh tags: trunk) | |
| 00:49 | Small performance optimization in the allowedOp() routine of the WHERE clause analysis code. (check-in: 4ba8be5447 user: drh tags: trunk) | |
2 Years Ago (more context)
|
2023-06-06
| ||
| 01:07 | More ExportHandler use. Sync w/trunk. Fix .archive UB. (check-in: 4fd4240f14 user: larrybr tags: cli_extension) | |
3 Years Ago (more context)
|
2022-06-06
| ||
| 23:22 | More precise determination of when a WHERE clause can be used to drive an index on an outer join. (check-in: 318543a911 user: drh tags: trunk) | |
| 22:33 | More precise determination of when a WHERE/ON clause term can be used as an indexed join constraint. Testcase macros added to ensure test coverage. (Closed-Leaf check-in: f419e98c51 user: drh tags: outer-join-tests) | |
| 21:08 | Extra test cases for outer joins. (check-in: c750576528 user: dan tags: outer-join-tests) | |
| 17:18 | • Edit [268072f636b25c24|268072f636]: Mark "Closed". (artifact: fb8cd39a63 user: larrybr) | |
| 15:27 | Do not allow a WHERE clause constraint to be used to drive an index for the right operand of a RIGHT JOIN, since this can cause problem if the constraint implies a not-NULL value for one of the columns for the left operand of the same join. See forum post 206d99a16dd9212f. (check-in: 4a31b7942a user: drh tags: trunk) | |
| 15:22 | In CLI, drop .dbinfo command when build options prevent it from working. (check-in: 4b50a55165 user: larrybr tags: trunk) | |
| 14:00 | Sync w/trunk, pickup fts3corrupt6.test change. (Closed-Leaf check-in: 268072f636 user: larrybr tags: dbinfo-guard) | |
| 06:29 | fiddle: replaced the huge file selection widget with a smaller proxy button. (check-in: f7c17449ea user: stephan tags: trunk) | |
| 06:17 | Fix a test case in fts3corrupt6.test. Was failing due to [f1dfbc4f]. (check-in: 04b2e47784 user: dan tags: trunk) | |
| 04:09 | shell: in WASM mode, permit ATTACH because the filesystem is a virtual sandbox and ATTACH can be used to provide more import/export options. Minor doc updates in sqlite3-api.js. (check-in: f28de5b726 user: stephan tags: trunk) | |
5 Years Ago (more context)
|
2020-06-06
| ||
| 23:21 | • New ticket [e5504e987e] Segfault in sqlite3VdbeCursorMoveto. (artifact: bc502e9362 user: yongheng) | |
| 20:48 | Merge multiple changes from trunk to address concerns with window-function parse-tree rewriting. (check-in: 05418b2a4a user: drh tags: branch-3.32-early-winfunc-rewrite) | |
| 19:54 | Fix a possible ASAN violation inside of debug-only code following an OOM. (check-in: 0e021887a1 user: drh tags: early-winfunc-rewrite-dev) | |
| 19:36 | • Fixed ticket [1f6f353b68]: Segfault in sqlite3VdbeExec plus 5 other changes (artifact: 94be72fccf user: drh) | |
| 19:36 | • Edit [8583c3483c1b1ab2|8583c3483c]: Edit check-in comment. (artifact: 213b8e3b5d user: drh) | |
| 19:35 | When determining if the subquery inserted by the window-function rewriter is an aggregate query, aggregate functions that are in parameters to another window function do not count. Fix for ticket [1f6f353b684fc708] (check-in: 8583c3483c user: drh tags: early-winfunc-rewrite-dev) | |
| 18:45 | Clearly distinguish between window functions and scalar functions in the debugging TreeView output. (check-in: 15babdcb91 user: drh tags: early-winfunc-rewrite-dev) | |
| 18:34 | In the query flattener, defer deleting content until after associated Parse object is destroyed, in case some of the deleted expressions have been collected for use by sAggInfo. (check-in: 03b32be44d user: drh tags: early-winfunc-rewrite-dev) | |
| 17:03 | • New ticket [1f6f353b68] Segfault in sqlite3VdbeExec. (artifact: 955543e288 user: yongheng) | |
| 14:58 | Remove an incorrect assert() added earlier today. (check-in: 3926ff1725 user: drh tags: early-winfunc-rewrite-dev) | |
| 14:44 | • Fixed ticket [0899cf62f5]: Segfault in sqlite3VdbeExec plus 5 other changes (artifact: b4bdfecefd user: drh) | |
| 14:44 | When rewriting the parse-tree for window functions, ensure that the inserted subqueries have an accurate SF_Aggregate bit set. This change also coincidentally fixes ticket [0899cf62f597d7e7], even thought that was not the issue we were working on at the time. (check-in: 2cddb24e91 user: drh tags: early-winfunc-rewrite-dev) | |
| 14:29 | Fix an assert() failure that could occur if an ORDER BY expression attached to a compound query contains a subquery that (a) is itself a compound query, (b) uses window functions and (c) has an ORDER BY clause that includes another sub-query. (check-in: c96914ea02 user: dan tags: early-winfunc-rewrite-dev) | |
| 13:29 | Avoid no-op calls to sqlite3SelectPrep() when processing sqlite3Select() for subqueries. This simplifies the ".selecttrace" debugging output. (check-in: 3de19ee22a user: drh tags: early-winfunc-rewrite-dev) | |
10 Years Ago (more context)
|
2015-06-06
| ||
| 20:12 | Split out the bulk of the actual VDBE code generation logic from where.c into a new file, leaving behind the analysis logic. This makes the original where.c smaller and hopefully easier to edit. (check-in: faa0e420e9 user: drh tags: view-optimization) | |
| 19:23 | Fix a comment in fts5.h. (check-in: e964b58774 user: dan tags: fts5) | |
| 18:30 | Code simplifications in select.c and where.c. (check-in: 4f20ac90bc user: drh tags: view-optimization) | |
| 16:28 | Fix handling of fts5 rowid constraints in the absence of a MATCH clause. Add tests to cover recently added branches. (check-in: 3a9cb64813 user: dan tags: fts5) | |
| 00:18 | Minor cleanup of the sqlite3Select() procedure. (check-in: f4c90d06bb user: drh tags: view-optimization) | |
20 Years Ago (more context)
|
2005-06-06
| ||
| 21:19 | Reference count Table structures so that they are not deallocated too soon. Ticket #1210. (CVS 2498) (check-in: e73d25c741 user: drh tags: trunk) | |
| 17:54 | Return SQLITE_MISUSE when passing a NULL pointer into sqlite3_bind routines. Ticket #1219. (CVS 2497) (check-in: 12c32f139b user: drh tags: trunk) | |
| 17:27 | Any non-zero value is considered TRUE in a WHERE clause. Ticket #1211. (CVS 2496) (check-in: 0f7af62379 user: drh tags: trunk) | |
| 17:11 | Avoid ambiguous column name errors when the column name is in the USING clause of a join. Ticket #743. (CVS 2495) (check-in: 6a51bdeeff user: drh tags: trunk) | |
| 16:59 | Naming the join columns in the result set of a natural join does not result in an "ambiguous column name" error. Ticket #1217. (CVS 2494) (check-in: 265fb6079c user: drh tags: trunk) | |
| 16:34 | Honor the full_column_names pragma on * results. Ticket #1263. (CVS 2493) (check-in: 0d57f851ae user: drh tags: trunk) | |
| 15:32 | Do not allow parameters in VIEW definitions. Ticket #1270. (CVS 2492) (check-in: 0d46289f02 user: drh tags: trunk) | |
| 15:07 | Handle failures of getcwd() without segfaulting. Ticket #1274. (CVS 2491) (check-in: c1bd0a150c user: drh tags: version_2) | |
| 15:06 | Handle failures of getcwd() without segfaulting. Ticket #1274. (CVS 2490) (check-in: c1691004d6 user: drh tags: trunk) | |
| 14:45 | Fix a bug in the malloc2 tests introduced by checkin (2473). (CVS 2489) (check-in: fafaa18eea user: drh tags: trunk) | |
25 Years Ago (more context)
|
2000-06-06
| ||
| 22:19 | :-) (CVS 64) (check-in: 3a2f4dcab2 user: drh tags: trunk) | |
| 22:13 | :-) (CVS 63) (check-in: 65d2100d33 user: drh tags: trunk) | |
| 21:56 | :-) (CVS 62) (check-in: f4d9089c5d user: drh tags: trunk) | |
| 19:18 | :-) (CVS 61) (check-in: 25984b4d3c user: drh tags: trunk) | |
| 18:24 | :-) (CVS 60) (check-in: 4eca3bf64f user: drh tags: trunk) | |
| 18:00 | :-) (CVS 59) (check-in: a8fa6719d5 user: drh tags: trunk) | |
| 17:27 | GROUP BY and HAVING installed (CVS 58) (check-in: db88a0c2d4 user: drh tags: trunk) | |
| 13:54 | added IN and BETWEEN operators (CVS 57) (check-in: 54d198189b user: drh tags: trunk) | |
| 03:31 | :-) (CVS 56) (check-in: b52dd82fe3 user: drh tags: trunk) | |
| 01:50 | :-) (CVS 55) (check-in: bd8b2645cc user: drh tags: trunk) | |