Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around f15591f80212dd6d.
2013-08-26
| ||
23:18 | • Edit [f86b75b6c7290ee6|f86b75b6]: Mark "Closed". (artifact: 75fdda56 user: drh) | |
23:18 | Merge the STAT4 capability into trunk. (check-in: a32af0ab user: drh tags: trunk) | |
20:45 | Change MAX_PATH related defines to use character lengths where WCHARs are used. (check-in: 0a497083 user: mistachkin tags: mmapDisabled) | |
19:36 | Merge updates from trunk. (check-in: 9d686009 user: mistachkin tags: mmapDisabled) | |
14:30 | Fix for builds with both SQLITE_OMIT_WAL and SQLITE_MAX_MMAP_SIZE=0 defined. (check-in: edd5dbdc user: dan tags: trunk) | |
04:50 | Version 3.8.0 (check-in: f64cd21e user: drh tags: trunk, release, version-3.8.0) | |
2013-08-24
| ||
23:55 | Several modifications to the use of the MAX_PATH macro on Windows to improve consistency. (check-in: bda4c47d user: mistachkin tags: mmapDisabled) | |
01:12 | Fix a couple compilation issues on Unix. (check-in: 25b029d8 user: mistachkin tags: mmapDisabled) | |
00:59 | Unify the result of PRAGMA mmap_size when mmap support is disabled. (check-in: 032c3159 user: mistachkin tags: mmapDisabled) | |
2013-08-23
| ||
17:54 | Merge recent trunk changes. (check-in: 6cc54de8 user: dan tags: sessions) | |
17:43 | Add the sqlite3session_table_filter API to the sessions extension. (check-in: b7e4dd88 user: dan tags: sessions) | |
17:33 | Adjust #ifdefs to get SQLITE_OMIT_AUTOMATIC_INDEX and SQLITE_OMIT_PAGER_PRAGMAS to build. (check-in: ed310201 user: drh tags: trunk) | |
16:47 | Fix a requirements comment in a test case. No changes to the testcase itself nor to any code. (check-in: 3ad1f998 user: drh tags: trunk) | |
12:04 | Modify script mkautoconfamal.sh to use the download.html naming convention for the tar.gz it creates. (check-in: 375b4e3d user: dan tags: trunk) | |
2013-08-22
| ||
15:07 | Merge in minor bug fixes and performance tweaks from trunk leading up to the version 3.8.0 release. (check-in: 831492dc user: drh tags: sessions) | |
02:56 | Defer the creation of automatic indices until the index is actually used. (check-in: 0775501a user: drh tags: trunk) | |
2013-08-21
| ||
23:42 | Simplify the btreeGetPage() routine so that it uses a single flag parameter in place of two boolean parameters. (check-in: 617e23ec user: drh tags: trunk) | |
22:54 | Minor performance tweaks to the pager. (check-in: 9ae1f9ce user: drh tags: trunk) | |
22:09 | Refactor the sqlite3_randomness() implementation for improved performance. (check-in: 4144dffb user: drh tags: trunk) | |
21:12 | Simplification to the StrAccum object and the sqlite3StrAccumAppend() method that also results in slightly better performance. (check-in: 700dbbea user: drh tags: trunk) | |
20:04 | Minor fixes for test cases. No code changes. (check-in: ef2a6a37 user: dan tags: trunk) | |
19:59 | Fix typo in test. (check-in: f9859fe9 user: mistachkin tags: trunk) | |
19:13 | Update sqlite3MemCompare() to try common cases first, for a modest speed improvement. (check-in: b25bac79 user: drh tags: trunk) | |
17:35 | If a virtual table xSync() returns an error message, copy it into a buffer allocated by sqlite3DbMalloc() before transfering it to Vdbe.zErrMsg. (check-in: 854ba304 user: dan tags: trunk) | |
15:52 | Performance enhancement in btreeParseCellPtr(). (check-in: a17190a2 user: drh tags: trunk) | |
15:45 | Fix an FTS4 problem introduced by [361084e1eb]. (check-in: 5f35c8cb user: dan tags: trunk) | |
13:09 | • Fixed ticket [d666d600]: COLLATE operator on lhs of BETWEEN expression is ignored. plus 3 other changes (artifact: 83f1d156 user: drh) | |
12:04 | Candidate fix for [d666d600a6]. (check-in: 781592f3 user: dan tags: trunk) | |
10:57 | • Ticket [d666d600] COLLATE operator on lhs of BETWEEN expression is ignored. status still Open with 6 other changes (artifact: 67e6e8db user: dan) ... 1 similar event omitted. | |
07:25 | Fix a minor problem in progress.test. No code changes. (check-in: a95ae93b user: dan tags: trunk) | |
2013-08-20
| ||
20:25 | Fix a couple of test scripts to work with DEFAULT_AUTOVACUUM and OMIT_VIRTUALTABLE. (check-in: 356c6c59 user: dan tags: trunk) | |
17:14 | Fix an invalid assert() in where.c. Also a crash that can occur in the EXPLAIN QUERY PLAN code under obscure circumstances. (check-in: ef192abb user: dan tags: trunk) | |
17:00 | Ignore IS NOT NULL and NOT NULL constraints on NOT NULL columns. (check-in: e476408e user: drh tags: trunk) | |
16:08 | Test script changes to support testing sqlite3_interrupt(). (check-in: 0cede9f8 user: dan tags: trunk) | |
13:02 | Merge performance enhancements and compiler warning fixes from trunk. (check-in: 3e403328 user: drh tags: sessions) | |
09:26 | Add test cases for tointeger() and toreal() functions. Fixes for several tests. (check-in: 5e1e9fd5 user: mistachkin tags: toTypeFuncs) | |
03:13 | Performance optimizations in the VDBE and especially to the OP_Next and related opcodes and in the sqlite3BtreeNext() and sqlite3BtreePrevious() routines. This is a cherrypick of [6f99b54aedeb], [d2efea1682a7], and [d78c5d89de4b]. (check-in: 7f72fc4f user: drh tags: trunk) | |
02:59 | • Edit [af49707211ff7c7c|af497072]: Move to branch toTypeFuncs. (artifact: 278e8043 user: drh) | |
02:07 | Fix compiler warnings and boundary cases for the tointeger() and toreal() functions. (check-in: 4438b986 user: drh tags: toTypeFuncs) | |
00:42 | Performance optimizations in the VDBE and especially to the OP_Next and related opcodes. (check-in: d78c5d89 user: drh tags: toTypeFuncs) | |
2013-08-19
| ||
23:18 | Performance improvement to SQL function calls in the VDBE. (check-in: d2efea16 user: drh tags: toTypeFuncs) | |
22:22 | Additional performance improvements in sqlite3BtreeNext() and sqlite3BtreePrevious(). (check-in: 6f99b54a user: drh tags: toTypeFuncs) | |
21:16 | • Edit [dd4b77c82af07bdc|dd4b77c8]: Mark "Closed". (artifact: 8aa8430d user: mistachkin) | |
21:15 | Add tointeger() and toreal() SQL functions. (check-in: af497072 user: mistachkin tags: toTypeFuncs) | |
20:04 | Performance improvement in sqlite3BtreeNext() and sqlite3BtreePrevious() for the common case of a valid cursor. (check-in: dc65ad8c user: drh tags: trunk) | |
19:29 | Initialize a variable in fts3_write.c on the grounds that the argument required to show that it does not require initialization with is complicated. Add an assert() to where.c to silence a clang scan-build warning. (check-in: d6c4d48a user: dan tags: trunk) | |
18:37 | Fix test script pragma2.test so that it works with ENABLE_MEMORY_MANAGEMENT. (check-in: 6acf7281 user: dan tags: trunk) | |
18:17 | Add some extra assert() statements to silence a few clang warnings. (check-in: 1c63e951 user: dan tags: trunk) | |
14:23 | Remove unused variables from the command-line shell sources. (check-in: 753a402e user: drh tags: trunk) | |
14:19 | Fix a potential reference off the end of an array in the query planner. (check-in: f15591f8 user: drh tags: trunk) | |
12:49 | Merge in all the latest updates and enhancements from trunk. (check-in: 67587a33 user: drh tags: sessions) | |
11:15 | Fixes for harmless compiler warnings. (check-in: a0d9ca4f user: drh tags: trunk) | |
2013-08-17
| ||
18:57 | Adjustments to #ifdefs in analyze.c to all a clean compile with no extra code with both ENABLE_STAT3 and ENABLE_STAT4 and with neither. (Closed-Leaf check-in: f86b75b6 user: drh tags: sqlite_stat4) | |
16:37 | • Edit [d07c4331a28d44de|d07c4331]: Mark "Closed". (artifact: 65c41295 user: drh) | |
16:37 | Add the cache_spill pragma. Change the fullfsync and checkpoint_fullfsync pragmas to apply to all attached databases. (check-in: 65a85a15 user: drh tags: trunk) | |
15:42 | The fullfsync, checkpoint_fullfsync, and cache_spill pragmas apply to all files of a database connection, including those opened by future ATTACH statements. (Closed-Leaf check-in: d07c4331 user: drh tags: cache_spill) | |
00:25 | Test cases for the cache_spill pragma. (check-in: b85c9ec5 user: drh tags: cache_spill) | |
2013-08-16
| ||
20:42 | Add the cache_spill pragma. (check-in: cdb181c0 user: drh tags: cache_spill) | |
17:46 | Add a test for the problem fixed by [91733bc485]. (check-in: 5c591104 user: dan tags: sqlite_stat4) | |
17:18 | In sqlite3Stat4ProbeSetValue() change a local variable name iVar to iBindVar to avoid confusion with iVal, and fix a place where the name was actually confused. (check-in: 91733bc4 user: drh tags: sqlite_stat4) | |
14:51 | Merge the fork that resulted from a check-in race. (check-in: b7fe4f36 user: drh tags: sqlite_stat4) | |
14:49 | Fix valueFromExpr() so that it returns SQLITE_NOMEM following an OOM when changing text encodings. Also fix some asserts to accommodate OOM errors. (check-in: dc1ccd09 user: drh tags: sqlite_stat4) | |
14:48 | Fixes for test code that was not working with utf16 databases. Run the analyze*.test scripts as part of the 'utf16' permutation test. (check-in: fe99494d user: dan tags: sqlite_stat4) | |
14:23 | Add extra tests. No code changes. (check-in: 949127d5 user: dan tags: sqlite_stat4) | |
14:09 | Avoid buffer overreads and false OOM error reports that could be caused by corrupted sample records in the sqlite_stat4 table. (check-in: 9f85b6a5 user: dan tags: sqlite_stat4) | |
13:34 | Fix a potential segfault following an OOM while running ANALYZE. (check-in: 01187978 user: drh tags: sqlite_stat4) | |
12:26 | Merge recent trunk changes into the STAT4 branch. (check-in: c69b512a user: drh tags: sqlite_stat4) | |
2013-08-15
| ||
22:42 | • Fixed ticket [1c69be2d]: Incorrect GROUP BY when input and output columns have the same name plus 5 other changes (artifact: 5edfd40f user: drh) | |
22:42 | • Fixed ticket [f617ea31]: Incorrect ORDER BY with colliding input and output column names plus 3 other changes (artifact: f37c56ed user: drh) | |
22:40 | Make sure that GROUP BY terms select input column names in preference to output column names, in compliance with the SQL standard. Ticket [1c69be2dafc28]. (check-in: f2d175f9 user: drh tags: trunk) | |
20:24 | Bare identifiers in ORDER BY clauses bind more tightly to output column name, but identifiers in expressions bind more tightly to input column names. This is a compromise between SQL92 and SQL99 behavior and is what PostgreSQL and MS-SQL do. Ticket [f617ea3125e9c]. (check-in: c78b357c user: drh tags: trunk) | |
20:11 | • Ticket [f617ea31] Incorrect ORDER BY with colliding input and output column names status still Open with 6 other changes (artifact: cac89508 user: drh) | |
20:05 | Make it easy to attach a debugger the test fixture process prior to any tests being run. (check-in: 53cd9ebf user: mistachkin tags: trunk) | |
19:56 | Fix a crash that can occur if the sqlite_stat3 or sqlite_stat4 table is corrupt. (check-in: d51df8a8 user: dan tags: sqlite_stat4) | |
18:43 | Fix a crash that can occur following an OOM fault. (check-in: 9f80b268 user: dan tags: sqlite_stat4) | |
16:18 | Change some assert() statements in vdbe.c to ensure that a memory cell used to store a VdbeCursor object is not also used for some other purpose. (check-in: 71070c9f user: dan tags: sqlite_stat4) | |
16:15 | Make sure the ANALYZE command allocates enough VDBE registers. (check-in: 46fec9b1 user: drh tags: sqlite_stat4) | |
14:39 | Add tests for sqlite_stat4 sample selection. And a fix for the same. (check-in: 1fb4d9d6 user: dan tags: sqlite_stat4) | |
14:27 | Clarification and typo fixes in comments related to name resolution. No changes to code. (check-in: f30abdf9 user: drh tags: trunk) | |
08:06 | Make it easy to attach a debugger the test fixture process prior to any tests being run. (Closed-Leaf check-in: c23acba1 user: mistachkin tags: dbgTestFixture) | |
2013-08-14
| ||
20:24 | • New ticket [f617ea31] Incorrect ORDER BY with colliding input and output column names. (artifact: 818175f4 user: drh) | |
20:12 | • New ticket [1c69be2d] Incorrect GROUP BY when input and output columns have the same name. (artifact: 7bd16b7d user: drh) | |
19:54 | Change the way ANALYZE works to use a single cursor when scanning indices. (check-in: bdce612b user: dan tags: sqlite_stat4) | |
00:20 | Fix a few more minor comment typos. No changes to code. (check-in: 9e999081 user: mistachkin tags: trunk) | |
2013-08-13
| ||
22:33 | Fix an outdated comment and a comment typo. No changes to code. (check-in: ac336959 user: mistachkin tags: trunk) | |
2013-08-12
| ||
20:14 | If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4. (check-in: cca8bf43 user: dan tags: sqlite_stat4) | |
17:31 | If there is data in both the sqlite_stat4 and sqlite_stat3 tables for a single index, ignore the sqlite_stat3 records. (check-in: 2a417367 user: dan tags: sqlite_stat4) | |
17:00 | Handle a NULL input to decodeIntArray() that can result from a prior OOM. (check-in: fa1588ad user: drh tags: sqlite_stat4) | |
16:34 | Re-enable reading from the sqlite_stat3 table (as well as sqlite_stat4). (check-in: 6d45078e user: dan tags: sqlite_stat4) | |
11:21 | Fix a bug in calculating the average number of entries for keys not present in the sqlite_stat4 table. (check-in: ec3ffb17 user: dan tags: sqlite_stat4) | |
09:29 | Fix minor problems caused by adding the rowid to the records in stat4. (check-in: 088d1ff9 user: dan tags: sqlite_stat4) | |
2013-08-10
| ||
19:08 | Add the rowid field to the end of sample records stored in the sqlite_stat4 table. (check-in: 3a5e8ab7 user: dan tags: sqlite_stat4) | |
2013-08-09
| ||
19:04 | Fix a couple of typos in a comment in analyze.c. No code changes. (check-in: 5bcccb93 user: dan tags: sqlite_stat4) | |
14:07 | Update the header comment on analyze.c to describe the sqlite_stat4 table format. (check-in: 4d97809d user: drh tags: sqlite_stat4) | |
2013-08-08
| ||
19:38 | Fix problems in estimating the number of rows visited by a range query using sqlite_stat4 data when the column subject to the range query is not the leftmost of the index. (check-in: 9228aaf5 user: dan tags: sqlite_stat4) | |
16:17 | Use a binary search instead of a linear scan when comparing a sample key against data from the sqlite_stat4 table. (check-in: e50dc305 user: dan tags: sqlite_stat4) | |
14:38 | If the SQLITE_EXTRA_INIT function is defined, make sure it is called only once by the effective sqlite3_initialize() call. (check-in: e2b597ca user: drh tags: trunk) | |
12:21 | Fix a segfault in "ALTER TABLE t1 ADD COLUMN b DEFAULT (-+1)". Also an assert() failure that could occur if SQLITE_ENABLE_STAT4 were not defined. (check-in: 9fec3e38 user: dan tags: sqlite_stat4) | |
11:48 | Fix a bug in using stat4 data to estimate the number of rows selected by a range constraint. (check-in: f783938e user: dan tags: sqlite_stat4) | |