This Day In History For 2019-10-03
1 Year Ago (more context)
|
2018-10-03
| ||
| 23:10 | • New ticket [31c6e64ff9] ALTER TABLE fails if a trigger references a non-existant table.. (artifact: d457452a79 user: drh) | |
| 18:05 | Add an ALWAYS on an unreachable branch in the ALTER TABLE logic. (check-in: ebcd452317 user: drh tags: trunk) | |
| 15:34 | • New ticket [e8b6742419] Query planner chooses an inefficient algorithm.. (artifact: 8b272a1b71 user: drh) | |
| 11:13 | Change a type in shell.c.in from "int" to "sqlite3_int64" in order to avoid a compiler warning and possible integer overflow. (check-in: bf0a6634cd user: dan tags: trunk) | |
2 Years Ago (more context)
|
2017-10-03
| ||
| 19:53 | Simplify the computation of types on columns of a view. (check-in: 772b0db146 user: drh tags: trunk) | |
| 18:35 | Do not enable SELECT tracing with -DSQLITE_DEBUG. Require the -DSQLITE_ENABLE_SELECTTRACE compile-time option to enable SELECT tracing. (check-in: f5c395834c user: drh tags: trunk) | |
| 17:29 | Add some OK_IF_ALWAYS_TRUE() marks on optimization branches in select.c. (check-in: 1dd828088d user: drh tags: trunk) | |
| 17:17 | Remove an unused variable from sqlite3Insert() and fix harmless compiler warnings associated with -DSQLITE_MUTATION_TEST. (check-in: 7be760e907 user: drh tags: trunk) | |
| 16:57 | Fix the sqlite3_column_decltype() interface to return the correct datatype when the value comes through a CTE. (check-in: 966438bd25 user: drh tags: trunk) | |
| 14:24 | The simplification to sqlite3SelectExpand() in last night's [3a4ffb21] check-in was not completely correct. This adjustment is needed for correct OOM handling in some configurations. (check-in: c5ad5e1675 user: drh tags: trunk) | |
| 14:11 | • Edit [f10ece964f1f484f|f10ece964f]: Mark "Closed". (artifact: a9b58274cd user: drh) | |
| 04:53 | • Edit [f10ece964f1f484f|f10ece964f]: Move to branch does-not-work. Edit check-in comment. (artifact: c6ce5b7f91 user: drh) | |
| 03:24 | Simplification to the logic that computes column type names. Update: Does not work in all configurations. (Closed-Leaf check-in: f10ece964f user: drh tags: does-not-work) | |
| 03:01 | Do not compute column and row size estimates for the transient Table objects associated with the result set of a SELECT statement, since those estimates are never used for anything constructive. (check-in: e4342fd401 user: drh tags: trunk) | |
3 Years Ago (more context)
|
2016-10-03
| ||
| 18:13 | Allow deterministic functions in the WHERE clause of a partial index. (check-in: c6e9b94218 user: drh tags: trunk) | |
| 16:33 | Size and performance optimizations on the sqlite3ExprAssignVarNumber() routine. (check-in: 109852e51e user: drh tags: trunk) | |
| 15:28 | Avoid unnecessary strlen() calls in sqlite3ExprAssignVarNumber() by passing in the token length from the parser. (check-in: d15ae2e530 user: drh tags: trunk) | |
| 14:44 | Avoid unnecessary memset() calls in the query optimizer. (check-in: 5bb7cde073 user: drh tags: trunk) | |
| 12:56 | Fix an obsolete comment on a variable definition in expr.c. No code changes. (check-in: 012ff6dd30 user: drh tags: trunk) | |
| 02:59 | • Fixed ticket [7b3328086a]: AUTOINCREMENT problem with the INSERT xfer optimization plus 5 other changes (artifact: 509f81f358 user: drh) | |
| 02:59 | Make sure the sqlite_sequence table is updated when an optional xfer optimization is used. Fix for ticket [7b3328086a5c1]. (check-in: 81e4d4f897 user: drh tags: trunk) | |
| 02:01 | • New ticket [7b3328086a] AUTOINCREMENT problem with the INSERT xfer optimization. (artifact: 5a826871e2 user: drh) | |
| 01:21 | Allocate Parse objects off of the stack where appropriate for a substantial performance increase and a size reduction. (check-in: ea8affa9e4 user: drh tags: trunk) | |
4 Years Ago (more context)
|
2015-10-03
| ||
| 15:38 | Update fts5 to support the table function syntax. "... FROM fts5_tbl WHERE fts5_tbl MATCH ?1 AND rank MATCH ?1" can now be written "FROM fts5_tbl(?1, ?2)". (check-in: 41d17d9e24 user: dan tags: trunk) | |
| 12:23 | Add tests for the rtree module to verify that attempts to insert non-integer primary key values or non-numeric dimensions into an rtree table are handled correctly. (check-in: f653fce908 user: dan tags: trunk) | |
5 Years Ago (more context)
|
2014-10-03
| ||
| 19:29 | Fix a division-by-zero error that might occur if the sqlite_stat1 table is corrupt. (check-in: f9c053b23e user: dan tags: stat4-avgeq) | |
| 19:16 | Improve the accuracy of the estimates used when searching an index for values not present in any stat4 samples under some circumstances. (check-in: e6f7f97dbc user: dan tags: stat4-avgeq) | |
| 16:00 | Add requirements marks on the sqlite3_db_status() interface implementation. Fix a typo in the documentation. Fix the new sqlite3_result_text64() routine so that it works correctly with an encoding parameter of SQLITE_UTF16. (check-in: d2fc322728 user: drh tags: trunk) | |
| 14:54 | Update to requirements marks related to changes in the memory allocation interface and enhancement of the documentation regarding DEFAULT clauses in CREATE TABLE. (check-in: 440705b98a user: drh tags: trunk) | |
10 Years Ago (more context)
|
2009-10-03
| ||
| 23:25 | • New ticket [1a1790ca1a] No way to signal an error in collation callback. (artifact: 0210d47e96 user: rogerb) | |
| 07:56 | • New ticket [6da68f691b] tables says you provide a like pattern but it adds % in code. (artifact: 8d9b39b237 user: rogerb) | |
| 07:04 | Handle an SQLITE_IGNORE returned when requesting authorization to read parent key columns by pretending the parent key columns contain NULL values. (check-in: 3c24df38e6 user: dan tags: trunk) | |
| 04:05 | • New ticket [8f81455baf] fts3GetVarint32 sets random number on error. (artifact: d84ee80c30 user: rogerb) | |
| 02:08 | • New ticket [bd770b2c52] shell doesn't return error exit code on import errors. (artifact: 47ac7eadf3 user: rogerb) | |
| 02:02 | • New ticket [2e047cbefa] select DISTINCT performance could be better. (artifact: f967d12b3e user: rogerb) | |