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: b141bae3f6 user: drh tags: trunk) | |
| 22:26 | • Fixed ticket [4c2d7639f0]: CAST('-' AS NUMERIC) computes 0.0 plus 6 other changes (artifact: 2c9d148c85 user: drh) | |
| 22:26 | • Fixed ticket [e8bedb2a18]: Incorrect result when subtracting a large integer number from a TEXT value plus 6 other changes (artifact: 8ea84fcb40 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: 67a68af557 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: efbf31b82e user: dan tags: trunk) | |
| 18:53 | Upgrade the config.guess script to the latest version. (check-in: be8438133f user: dan tags: trunk) | |
2 Years Ago (more context)
|
2018-06-07
| ||
| 20:35 | Merge latest trunk changes with this branch. (check-in: 2510220342 user: dan tags: exp-window-functions) | |
| 20:08 | Add window functions lag() and lead(). (check-in: ef34207073 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: 09fffbdf9f 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: 4b0b4e1403 user: drh tags: multikey-opt-idea) | |
| 17:45 | Add support for window function first_value(). (check-in: 060b264028 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: 439c816227 user: drh tags: multikey-opt-idea) | |
| 16:07 | Test cases. (check-in: 085e863713 user: drh tags: multikey-opt-idea) | |
| 15:54 | Fix problems with the nth_value() function. (check-in: 63002b9a09 user: dan tags: exp-window-functions) | |
| 15:28 | Merge the ".stat/.eqp" CLI fix from trunk. (check-in: a91cad3381 user: drh tags: multikey-opt-idea) | |
| 15:23 | • Fixed ticket [7be932dfa6]: Adverse interaction between .stats and .eqp in the CLI plus 5 other changes (artifact: 07775835d6 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: bb87c054b1 user: drh tags: trunk) | |
| 15:11 | • New ticket [7be932dfa6] Adverse interaction between .stats and .eqp in the CLI. (artifact: facdb8d39f user: drh) | |
| 14:59 | Add the WHERE_IN_EARLYOUT flag and use it to clarify the logic of this optimization. (check-in: 522f1eacc2 user: drh tags: multikey-opt-idea) | |
| 14:32 | Merge recent trunk enhancements. (check-in: e9d7bf4f7b 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: e39795d7d7 user: drh tags: trunk) | |
| 19:46 | Fix another lsmtest build problem. Add the "-trans BOOLEAN" option to "lsmtest speed2". (check-in: 61853bc171 user: dan tags: lsm-vtab) | |
| 16:25 | Merge in trunk enhancements. (check-in: f8bbb608cb 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: 05b4fc4340 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: c81f260c2d 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: 2091a4c923 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: 95cc976f15 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: 7c33eb5a5a user: dan tags: trunk) | |
| 14:28 | Refactor some of the global variables and commands used by tester.tcl. (check-in: c2edf8e17f user: dan tags: trunk) | |
| 06:11 | Add a couple of extra coverage tests for wal.c. (check-in: cfe60254df 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: 62a7353d4a 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: 4704f3a19a user: drh tags: trunk) | |
| 09:21 | Remove SSE vacuum hook. (CVS 2502) (check-in: 59960a5915 user: danielk1977 tags: trunk) | |
| 07:58 | Add "#ifndef OMIT_DISKIO" condition around sqlite3_opentemp_count variable in test interface code. (CVS 2501) (check-in: f2ce662e81 user: danielk1977 tags: trunk) | |
| 02:12 | Add tests to make sure statement journals are only opened when necessary. (CVS 2500) (check-in: 914d6e6549 user: drh tags: trunk) | |
| 01:43 | Do not open a statement journal unless absolutely necessary. (CVS 2499) (check-in: 989573a53b user: drh tags: trunk) | |
20 Years Ago (more context)
|
2000-06-07
| ||
| 23:51 | :-) (CVS 74) (check-in: 2ffeb8509c user: drh tags: trunk) | |
| 15:39 | :-) (CVS 73) (check-in: a00b81b0e1 user: drh tags: trunk) | |
| 15:24 | :-) (CVS 72) (check-in: 6f8de336d0 user: drh tags: trunk) | |
| 15:23 | :-) (CVS 71) (check-in: a92eb77170 user: drh tags: trunk) | |
| 15:11 | :-) (CVS 70) (check-in: d3baa046c9 user: drh tags: trunk) | |
| 14:42 | :-) (CVS 69) (check-in: e4f6b17f66 user: drh tags: trunk) | |
| 14:42 | :-) (CVS 1697) (check-in: 5d773b5d4e user: drh tags: trunk) | |
| 02:04 | :-) (CVS 68) (check-in: fc8d25ea1f user: drh tags: trunk) | |
| 01:33 | :-) (CVS 67) (check-in: 8bff1bee63 user: drh tags: trunk) | |
| 01:27 | :-) (CVS 66) (check-in: 5d2e72e4bd user: drh tags: trunk) | |
| 00:12 | :-) (CVS 65) (check-in: 80ee166ed1 user: drh tags: trunk) | |