/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 check-ins occurring around 949127d53e0a907e.

2013-08-24
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
12:04
Candidate fix for [d666d600a6]. check-in: 781592f3 user: dan tags: trunk
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: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: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
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: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: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
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
2013-08-07
23:15
If the SQLITE_ALLOW_URI_AUTHORITY compile-time option is set, then allow non-localhost authorities on URI filenames and pass them through as a UNC to the underlying VFS. check-in: 3adb6c1b user: drh tags: trunk
19:46
Replace variable Index.avgEq (average number of rows in keys for which there is no sample in sqlite_stat4) with vector Index.aAvgEq. check-in: 7b70b419 user: dan tags: sqlite_stat4
18:42
Merge latest trunk changes with this branch. check-in: 08f74c45 user: dan tags: sqlite_stat4
18:07
Merge in the latest changes from trunk. Closed-Leaf check-in: c78b0d30 user: drh tags: uri-enhancement
16:38
Fix typos in a comment in analyze.c. No code changes. check-in: 812ed0c5 user: dan tags: sqlite_stat4
16:15
Change the way samples for the sqlite_stat4 table are collected. check-in: 13ed5ac1 user: dan tags: sqlite_stat4
16:04
Fix the ".dump" command on the command-line shell so that it works for "sqlite_stat4" in addition to "sqlite_stat1". check-in: 1e80c4b1 user: drh tags: sqlite_stat4
15:57
Remove the unused sqlite3Utf8to16() utility function. check-in: 9159b43e user: drh tags: sqlite_stat4
15:52
When estimating the number of rows scanned using data from the sqlite_stat4 table, avoid allocating UnpackedRecord and KeyInfo structures until they are definitely required. check-in: 353950a5 user: dan tags: sqlite_stat4
14:18
Add a guard #ifndef to test_intarray.h to prevent harm if it is #included more than once. Add a comment on the closing #endif of the guards on sqlite3.h and test_multiplex.h. check-in: 0ad83ceb user: drh tags: trunk
01:18
Fix typos and add clarification to comments in where.c. No code changes. check-in: f8d8790e user: drh tags: trunk
2013-08-06
20:15
Fixes for builds without SQLITE_ENABLE_STAT4. check-in: 84999e27 user: dan tags: sqlite_stat4
20:01
When possible, use the multi-column samples in sqlite_stat4 to estimate the number of index rows scanned by a query plan. check-in: 2973f5ca user: dan tags: sqlite_stat4
19:18
Fix a test case related to partial indices so that it works even if STAT3 is disabled. check-in: 153c6450 user: drh tags: trunk
18:35
Adjust #ifdefs in test_autoext.c so that it compiles with SQLITE_OMIT_LOAD_EXTENSION. Fix compiler warnings in two other test modules. No changes to the core. check-in: 89930ea3 user: drh tags: trunk
18:21
Update the configure script to use the latest version number (3.8.0). check-in: 52e8ec5e user: drh tags: trunk
17:24
Add a testcase() macro to verify OOM coverage. check-in: d43dcbc4 user: drh tags: trunk
16:56
Remove unreachable branches in expr.c, replacing them with assert() and testcase() statements. check-in: 9103c27c user: drh tags: trunk
14:52
Merge in the latest changes from trunk. check-in: 69d5bed0 user: drh tags: sessions