This Day In History For 2020-06-07
1 Year Ago (more context)
|
2019-06-07
| ||
| 22:51 | Remove code in the round() SQL function that became unreachable due to the optimization of check-in [e95138f5f4febde5] (check-in: b141bae3 user: drh tags: trunk) | |
| 22:26 | • Fixed ticket [4c2d7639]: CAST('-' AS NUMERIC) computes 0.0 plus 6 other changes (artifact: 2c9d148c user: drh) | |
| 22:26 | • Fixed ticket [e8bedb2a]: Incorrect result when subtracting a large integer number from a TEXT value plus 6 other changes (artifact: 8ea84fcb user: drh) | |
| 22:26 | When casting string values into numeric and the string has a prefix that looks like a number but total string is not a well-formed number, then take extra care that the result is either integer or real depending on what the prefix looks like. Fix for tickets [e8bedb2a184001] and [4c2d7639f076aa]. (check-in: 67a68af5 user: drh tags: trunk) | |
| 18:56 | Also upgrade script config.sub to the latest version. This should have been part of the previous commit. (check-in: efbf31b8 user: dan tags: trunk) | |
| 18:53 | Upgrade the config.guess script to the latest version. (check-in: be843813 user: dan tags: trunk) | |
2 Years Ago (more context)
|
2018-06-07
| ||
| 20:35 | Merge latest trunk changes with this branch. (check-in: 25102203 user: dan tags: exp-window-functions) | |
| 20:08 | Add window functions lag() and lead(). (check-in: ef342070 user: dan tags: exp-window-functions) | |
| 18:13 | The IN-early-out optimization: When doing a look-up on a multi-column index and an IN operator is used on a column other than the left-most column, then if no rows match against the first IN value, check to make sure there exist rows that match the columns to the right before continuing with the next IN value. (check-in: 09fffbdf user: drh tags: trunk) | |
| 18:01 | Fix the assert()s in the byte-code engine that prove that cursors are unidirectional. (Closed-Leaf check-in: 4b0b4e14 user: drh tags: multikey-opt-idea) | |
| 17:45 | Add support for window function first_value(). (check-in: 060b2640 user: dan tags: exp-window-functions) | |
| 17:32 | Remove the NextIfOpen and PrevIfOpen opcodes which are no longer needed when the IN-early-out optimization is working. (check-in: 439c8162 user: drh tags: multikey-opt-idea) | |
| 16:07 | Test cases. (check-in: 085e8637 user: drh tags: multikey-opt-idea) | |
| 15:54 | Fix problems with the nth_value() function. (check-in: 63002b9a user: dan tags: exp-window-functions) | |
| 15:28 | Merge the ".stat/.eqp" CLI fix from trunk. (check-in: a91cad33 user: drh tags: multikey-opt-idea) | |
| 15:23 | • Fixed ticket [7be932df]: Adverse interaction between .stats and .eqp in the CLI plus 5 other changes (artifact: 07775835 user: drh) | |
| 15:23 | Avoid using a prepared statement for ".stats on" after it has been closed by the ".eqp full" logic. Fix for ticket [7be932dfa60a8a6b3b26bcf76]. (check-in: bb87c054 user: drh tags: trunk) | |
| 15:11 | • New ticket [7be932df] Adverse interaction between .stats and .eqp in the CLI. (artifact: facdb8d3 user: drh) | |
| 14:59 | Add the WHERE_IN_EARLYOUT flag and use it to clarify the logic of this optimization. (check-in: 522f1eac user: drh tags: multikey-opt-idea) | |
| 14:32 | Merge recent trunk enhancements. (check-in: e9d7bf4f user: drh tags: multikey-opt-idea) | |
3 Years Ago (more context)
|
2017-06-07
| ||
| 22:32 | In SQLITE_DEBUG mode, attempt to log the page number of the database that contained the problem when SQLITE_CORRUPT errors are seen. (check-in: e39795d7 user: drh tags: trunk) | |
| 19:46 | Fix another lsmtest build problem. Add the "-trans BOOLEAN" option to "lsmtest speed2". (check-in: 61853bc1 user: dan tags: lsm-vtab) | |
| 16:25 | Merge in trunk enhancements. (check-in: f8bbb608 user: drh tags: prepare_v3) | |
| 15:55 | Add too/tserver.c - the implementation of a simple multi-threaded server designed for interactive testing of concurrency between connections used by different threads of the same process. (check-in: 05b4fc43 user: dan tags: server-edition) | |
| 10:55 | Cause the ANALYZE command to build sqlite_stat1 table entries for empty tables with the assumption that such tables really contain 10 elements. This gives better query plans for tables that are truely empty, but is likely to cause problems in legacy systems, so the change is kept off trunk. Some TCL tests fail on this check-in due to the new stat1 entries. (Leaf check-in: c81f260c user: drh tags: analyze-empty-tables) | |
4 Years Ago (more context)
|
2016-06-07
| ||
| 20:25 | Fix the walcrash4.test test module so that it works on windows. (check-in: 2091a4c9 user: drh tags: trunk) | |
10 Years Ago (more context)
|
2010-06-07
| ||
| 19:26 | In os_unix.c, call munmap() to unmap a shared-memory region prior to closing the associated file descriptor. (check-in: 95cc976f user: dan tags: trunk) | |
| 17:47 | Change all.test, quick.test and permutations.test so that they use a separate interpreter for each test file. (check-in: 7c33eb5a user: dan tags: trunk) | |
| 14:28 | Refactor some of the global variables and commands used by tester.tcl. (check-in: c2edf8e1 user: dan tags: trunk) | |
| 06:11 | Add a couple of extra coverage tests for wal.c. (check-in: cfe60254 user: dan tags: trunk) | |
15 Years Ago (more context)
|
2005-06-07
| ||
| 22:22 | Changes to support linking without a parser and without a disk I/O interface. (CVS 2504) (check-in: 62a7353d user: drh tags: trunk) | |
| 20:07 | In the documentation, amplify the fact that encodings cannot be changed on a database that already exists. Ticket #1277. (CVS 2503) (check-in: 4704f3a1 user: drh tags: trunk) | |
| 09:21 | Remove SSE vacuum hook. (CVS 2502) (check-in: 59960a59 user: danielk1977 tags: trunk) | |
| 07:58 | Add "#ifndef OMIT_DISKIO" condition around sqlite3_opentemp_count variable in test interface code. (CVS 2501) (check-in: f2ce662e user: danielk1977 tags: trunk) | |
| 02:12 | Add tests to make sure statement journals are only opened when necessary. (CVS 2500) (check-in: 914d6e65 user: drh tags: trunk) | |
| 01:43 | Do not open a statement journal unless absolutely necessary. (CVS 2499) (check-in: 989573a5 user: drh tags: trunk) | |
20 Years Ago (more context)
|
2000-06-07
| ||
| 23:51 | :-) (CVS 74) (check-in: 2ffeb850 user: drh tags: trunk) | |
| 15:39 | :-) (CVS 73) (check-in: a00b81b0 user: drh tags: trunk) | |
| 15:24 | :-) (CVS 72) (check-in: 6f8de336 user: drh tags: trunk) | |
| 15:23 | :-) (CVS 71) (check-in: a92eb771 user: drh tags: trunk) | |
| 15:11 | :-) (CVS 70) (check-in: d3baa046 user: drh tags: trunk) | |
| 14:42 | :-) (CVS 69) (check-in: e4f6b17f user: drh tags: trunk) | |
| 14:42 | :-) (CVS 1697) (check-in: 5d773b5d user: drh tags: trunk) | |
| 02:04 | :-) (CVS 68) (check-in: fc8d25ea user: drh tags: trunk) | |
| 01:33 | :-) (CVS 67) (check-in: 8bff1bee user: drh tags: trunk) | |
| 01:27 | :-) (CVS 66) (check-in: 5d2e72e4 user: drh tags: trunk) | |
| 00:12 | :-) (CVS 65) (check-in: 80ee166e user: drh tags: trunk) | |