This Day In History For 2023-11-03
1 Year Ago (more context)
|
2022-11-03
| ||
| 22:51 | Add experimental esm target to ext/wasm/GNUmakefile to tell emcc to generate sqlite3.mjs (ES6 module) instead of sqlite3.js. Related to discussion at ed4596cf8496a39b. (check-in: e55d8eba83 user: stephan tags: trunk) | |
| 22:14 | Experimentally use clang's C preprocessor to filter #ifdef's out of the generated sqlite3-api.js, the goal being to see if we can feasibly use cpp to include ES6 module-specific code in the main code base and conditionally filter it out. (check-in: 718a6d371e user: stephan tags: js-cpp) | |
| 21:21 | Globally replace '' with "" for empty JS strings to please C preprocessor. (check-in: e92e1f42be user: stephan tags: trunk) | |
| 21:08 | Experimental changes that try to identify indexes as covering when they contain expressions which do cover all data uses. This check-in does not work, because the AggInfo object might still refer to individual columns. The purpose of this check-in is to preserve the idea. I might come back to it later. (Leaf check-in: 018914a5a1 user: drh tags: indexed-expr-exp) | |
| 18:46 | • New ticket [73ebbb3a3d] View ought not be materialized. (artifact: 60c699c856 user: drh) | |
| 11:59 | • New ticket [9937817793] Use indexed expressions in an aggregate query. (artifact: 9593cae7fd user: drh) | |
| 11:35 | • New ticket [695a1a53de] Better choice of indexes with covering indexes on expressions. (artifact: f6561b0c33 user: drh) | |
2 Years Ago (more context)
|
2021-11-03
| ||
| 16:35 | Remove two incorrect assert() statements added by a check-in from earlier today. (check-in: 3206edff94 user: drh tags: trunk) | |
| 15:59 | Improved the error message that results when a schema parse fails after ALTER TABLE ADD COLUMN. (check-in: b007a39dd3 user: drh tags: trunk) | |
| 14:02 | Fix INSERT into STRICT table with STATIC generated columns. (check-in: 24285d9136 user: drh tags: trunk) | |
| 12:50 | Add the --strict option to speedtest1.c (check-in: a247b5d88c user: drh tags: trunk) | |
| 11:43 | Fix an issue in PRAGMA integrity_check associated reporting NULL values in a NOT NULL column of type ANY in a STRICT table. (check-in: 5dff1f6673 user: drh tags: trunk) | |
3 Years Ago (more context)
|
2020-11-03
| ||
| 12:06 | • Edit [2a71bebfe3139a74|2a71bebfe3]: Mark "Closed". (artifact: 2fb2739b85 user: shearer) | |
| 11:54 | Make platform compilation clearer, including the section that applies to both *ix and Windows Add link to the detailed compilation instructions Add brief Android section, it seems strange to omit it since Android is the majority use case by numbers (Closed-Leaf check-in: 2a71bebfe3 user: shearer tags: docupdate) | |
| 11:27 | Update for new git-style syntax in Fossil (check-in: d46b6778b1 user: shearer tags: docupdate) | |
| 11:20 | Add links, especially for the docsrc repo, which is otherwise hard to find (check-in: e03867e2fb user: shearer tags: docupdate) | |
4 Years Ago (more context)
|
2019-11-03
| ||
| 10:51 | • New ticket [02aa2bd02f] Row value comparison malfunctions on view with left join. (artifact: 0d1dbe8439 user: mrigger) | |
| 10:06 | • New ticket [3c9eadd2a6] PRAGMA integrity_check fails due to CHECK constraint even without records. (artifact: d58c01a983 user: mrigger) | |
| 00:07 | • Fixed ticket [623eff57e7]: LEFT JOIN in view malfunctions with partial index on table plus 6 other changes (artifact: 4895f3bf95 user: drh) | |
| 00:07 | The optimization of check-in [9b2879629c34fc0a] is incorrectly reasoned. The WHERE clause of the partial index might not be true if the table of the partial index is the right table of a left join. So disable the optimization in that case. Ticket [623eff57e76d45f6] (check-in: 3be19e1151 user: drh tags: trunk) | |
5 Years Ago (more context)
|
2018-11-03
| ||
| 17:31 | Correct the internal logic for SQLITE_DBCONFIG_DEFENSIVE. (Closed-Leaf check-in: 7609434582 user: drh tags: dbconfig-defensive) | |
| 16:51 | Add extra defenses against strategically corrupt databases to fts3/4. (check-in: d44318f590 user: dan tags: trunk) | |
| 16:09 | Add the SQLITE_DBCONFIG_DEFENSIVE flag. (check-in: af3f29d493 user: drh tags: dbconfig-defensive) | |
| 13:11 | Fix a assert() in the query planner that can arise when doing row-value operations on a PRIMARY KEY that contains duplicate columns. Ticket [1a84668dcfdebaf12415d]. (check-in: dcb8c73594 user: drh tags: trunk) | |
| 12:36 | • New ticket [1a84668dcf] Assertion fault due to malformed PRIMARY KEY. (artifact: 25fe2f85fe user: drh) | |
10 Years Ago (more context)
|
2013-11-03
| ||
| 02:27 | Improved comments on foreign key logic. (check-in: 1315d9109c user: drh tags: omit-rowid) | |
15 Years Ago (more context)
|
2008-11-03
| ||
| 21:40 | Test cases to verify that COMMIT and ROLLBACK return SQLITE_BUSY when there are active statements. (CVS 5858) (check-in: cedfa214e4 user: drh tags: trunk) | |
| 20:55 | Change the name of the Cursor object to VdbeCursor. (CVS 5857) (check-in: fdb98fd8c1 user: drh tags: trunk) | |
| 09:39 | Modify an assert() statement to fix #3473. No other code changes. (CVS 5856) (check-in: aca6b260c0 user: danielk1977 tags: trunk) | |
| 09:06 |
Fix a bug reported on the mailing list triggered by the pattern "SELECT | |