/ 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 ancestors of [430bb59d]

2012-04-17
16:38
Improved handling of aggregate subqueries within an aggregate query. check-in: 430bb59d user: drh tags: trunk
09:09
Add an undocumented and possibly ephemeral ".breakpoint" command to the command-line shell, to call a no-op routine on which it is convenient to set a symbolic debugger breakpoint. check-in: 8e2363ad user: drh tags: trunk
2012-04-16
17:22
Fix a bug in the command-line shell logic that attempts to continue with a ".dump" even after encountering database corruption. check-in: 020b5e90 user: drh tags: trunk
2012-04-14
13:25
In the unix VFS, always set every open file to close-on-exec using either O_CLOEXEC at open (preferred) or FD_CLOEXEC in an ioctl after opening. Before this changes, many files were done this way, but not all. check-in: 9efbeb11 user: drh tags: trunk
11:48
Fix a typo in a comment that is extracted for documentation. No changes to code. check-in: e87371c5 user: drh tags: trunk
2012-04-11
23:22
Add a testcase() macro to ensure that the sqlite3AuthCheck() call inside the query flattener really is effective. check-in: a134e6e7 user: drh tags: trunk
11:38
Fix harmless static-analysis warnings, mosting having to do with memory leaks in the command-line shell. Add a clang analysis of the command-line shell to the "warnings-clang.sh" script. Other minor cleanups to the command-line shell code. check-in: 93a0f452 user: drh tags: trunk
2012-04-10
17:53
Add new interfaces to the test_quota.c module: sqlite3_quota_ftruncate(), sqlite3_quota_file_size(), sqlite3_quota_file_truesize(), and sqlite3_quota_file_mtime(). check-in: 2fa9f543 user: drh tags: trunk
16:05
Fix a copy/paste error in a comment in the fuzzer. No changes to code. check-in: 7433f2b5 user: drh tags: trunk
2012-04-07
00:09
Fix the application-defined function logic so that functions with a variable number of parameters can be replaced or deleted correctly. Also refactor some of the function-finder code for clarity of presentation. check-in: 09d5581c user: drh tags: trunk
2012-04-06
00:09
Update sqlite3_analyzer to correctly find all database files when the multiplexor is being used. check-in: 1bfc30cb user: drh tags: trunk
2012-04-05
20:04
Ignore the value of SQLITE_FCNTL_CHUNK_SIZE if it is negative. check-in: 1b08fef9 user: drh tags: trunk
01:37
Performance improvements for the RowSet object when it undergoes many cycles between RowSetInsert and RowSetTest. check-in: 49d20ede user: drh tags: trunk
2012-04-04
16:56
Add the ".trace" option to the command-line shell. check-in: b9ac3d7e user: drh tags: trunk
13:58
Fix the multiplexor logging so that it works with SQLITE_ENABLE_8_3_NAMES. check-in: 9e1e2fe2 user: drh tags: trunk
13:43
In the multiplexor extension, improve the error logging when a chunk fails to open. check-in: 781453c6 user: drh tags: trunk
2012-04-03
18:34
Do not run attempt to run test file fts4merge3.test unless the build includes FTS. check-in: 0506bf86 user: dan tags: trunk
18:33
Modify capi3.test and capi3c.test so that they work with SQLITE_OMIT_AUTORESET builds. check-in: 1d5e744c user: dan tags: trunk
17:43
Modify the integrity-check code to reduce the size of the large allocation from 4 bytes to 1 bit for each page in the database file. check-in: fa3a498d user: dan tags: trunk
17:05
Fix a typo in the rtree6.test script that prevented it from running. check-in: 221fe4a8 user: drh tags: trunk
17:01
Rerun autoconf to update the configure script for version 3.7.12 check-in: 6d73eb20 user: drh tags: trunk
15:10
If the SELECT that finds all root pages in the showdb fails, then report an error. check-in: 4b161415 user: drh tags: trunk
14:59
Enhance the "showdb" utility program with the "pgidx" option. Now requires linkage with the amalgamation. check-in: 4b573701 user: drh tags: trunk
2012-04-02
21:35
The SQLITE_RTREE_INT_ONLY compile-time option causes the RTree extension to use only integer math and store only integer coordinates. check-in: 02b7640f user: drh tags: trunk
17:18
Add #ifdefs to allow a test build to succeed even if SQLITE_ENABLE_FTS3 is not defined. check-in: fb121980 user: drh tags: trunk
2012-03-31
19:12
Fix a compiler warning by removing a redundant variable. check-in: af602d87 user: drh tags: trunk
17:50
Test cases for RELEASE and ROLLBACK TO of a nested savepoint while queries are pending. Ticket [27ca74af3c083] check-in: d2bf0efa user: drh tags: trunk
17:17
Do not abort pending queries on a RELEASE of a nested SAVEPOINT. This is a candidate fix for ticket [27ca74af3c083f787]. check-in: 79a4a3a8 user: drh tags: trunk
15:08
Modify selectColumnsFromExprList() to avoid ever incorrectly returning SQLITE_NOMEM. check-in: e7cb6b73 user: dan tags: trunk
11:58
Change the ICU tokenizer so that it does not attempt to call strlen(NULL). check-in: 04298f1a user: dan tags: trunk
09:59
Fix a bug in the EXPLAIN code for listing trigger programs that was causing an out-of-bounds read. check-in: c9342ca5 user: dan tags: trunk
02:34
Do more aggressive optimization of the AND operator where one side or the other is always false. check-in: f9a7e179 user: drh tags: trunk
2012-03-30
16:44
Avoid using the OVERLAPPED struct on WinCE. check-in: 196ca3a8 user: mistachkin tags: trunk
15:57
Simplify the winRead and winWrite VFS functions to reduce the number of system calls. check-in: b3449186 user: drh tags: trunk
15:48
When a named CHECK constraint fails, include the name of the constraint in the error message. check-in: 1b75f301 user: drh tags: trunk
14:59
Fix MSVC compiler warnings in test code. check-in: cb7a8504 user: drh tags: trunk
13:34
Fix an FTS4 test script problem for windows. check-in: 36aa6665 user: drh tags: trunk
12:10
Change the name of a local variable from "not" to "bNot" to lessen the chances of it colliding with some prior #define in the appliation. check-in: cbdd8638 user: drh tags: trunk
00:05
In the ".output" command of the shell, if the first character of the output filename is '|' then use popen() instead of fopen(). check-in: fa82062c user: drh tags: trunk
00:00
Fix compiler warnings on GCC and MSVC and fix a C89-ism that broke the build for MSVC. check-in: b451c0f9 user: drh tags: trunk
2012-03-29
15:11
Merge fts4-incr-merge with trunk. check-in: 4d6de3e9 user: dan tags: trunk
14:29
Disable the LIKE optimization if the column on the left-hand-side of the LIKE operator belongs to a virtual table. check-in: 0bacb879 user: dan tags: trunk
07:51
Fix an out of date comment on sqlite3ArrayAllocate(). check-in: 4afdd5ae user: dan tags: trunk
2012-03-28
16:44
Merge in the latest changes from trunk. Closed-Leaf check-in: 66c4aaad user: drh tags: fts4-incr-merge
16:22
Avoid loading overflow pages just to satisfy typeof() or length() functions if the correct result can be computed without the extra page fetches. check-in: 0733c98c user: drh tags: trunk
16:14
Minor changes to the core of OP_Column for performance and to clarify the critical path. Closed-Leaf check-in: 86839476 user: drh tags: faster-typeof-and-length
13:55
Fix a problem in fts4merge3.test. check-in: 64fc8b30 user: dan tags: fts4-incr-merge
13:41
Improvements to comments. Minor changes to code in the hot path of OP_Column - with the hope of get a few cycles of performance improvement. check-in: ca093103 user: drh tags: faster-typeof-and-length
02:51
Test cases for length() of a large blob in an aggregate query. check-in: d095fa4b user: drh tags: faster-typeof-and-length
02:43
Fix the typeof() and length() optimization so that it works for aggregates as well as scalar queries. check-in: bc18215a user: drh tags: faster-typeof-and-length
01:34
Evaluate typeof(X) and length(Y) where X is any column and Y is a blob column without actually loading X and Y from disk. check-in: b899dbeb user: drh tags: faster-typeof-and-length
2012-03-27
18:00
Add output of PRAGMAs auto_vacuum and encoding to the "schema" command of the fts3view utility program. check-in: e3107631 user: drh tags: fts4-incr-merge
15:10
Really delete the fts3merge.test script (should have been deleted by the previous commit). check-in: 83838149 user: dan tags: fts4-incr-merge
15:00
Remove the fts3merge.test script in favour of changing the fts4merge.test script so that it runs tests using both fts4 and fts3. Fix some problems with incr-merge and FTS3 tables. check-in: 5c447e22 user: dan tags: fts4-incr-merge
14:54
In the fts3view utility, label the blank segments used to mark the end of a segment sequence for a level/idx as "null". Improve the alignment of root segment names. check-in: 04aea024 user: drh tags: fts4-incr-merge
13:51
Enhance the fts3view tool with the big-segment command and fix a bug in the display of doclists. check-in: e9436d80 user: drh tags: fts4-incr-merge
13:44
Merge the fts4-incr-merge-exp branch with fts4-incr-merge. check-in: eb00b958 user: dan tags: fts4-incr-merge
11:48
Allow multiple incremental merges to proceed concurrently. This is required to prevent a large crisis-merge from occuring while an even larger incremental-merge is underway. Closed-Leaf check-in: 7ed9d2f2 user: dan tags: fts4-incr-merge-exp
00:38
Minor correct errors in the file format description for FTS3/4 contained in the fts3.c header comment. check-in: fb8aacdd user: drh tags: fts4-incr-merge
00:34
Enhance fts3view to show decodes of segments and doclists. check-in: 6d09de23 user: drh tags: fts4-incr-merge
2012-03-26
21:57
Add the fts3view utility program. check-in: f936c8ea user: drh tags: fts4-incr-merge
14:36
Fix FTS3 so that it works even without SQLITE_DEBUG. check-in: a18c1031 user: drh tags: fts4-incr-merge
10:57
Modify the FTS integrity-check so that the checksums do not depend on the results of signed integer overflow, which is undefined in C. check-in: f907fc3f user: dan tags: fts4-incr-merge
10:47
Add a comment to explain how the FTS integrity-check works. check-in: 64e8a116 user: dan tags: fts4-incr-merge
10:36
Add an experimental integrity-check function to FTS. check-in: 40fc8804 user: dan tags: fts4-incr-merge
2012-03-25
17:25
Increase the version number to 3.7.12 check-in: d95f9fb7 user: drh tags: trunk
2012-03-24
20:09
Add SQLITE_DBSTATUS_CACHE_WRITE to the command-line shell. check-in: 30b8dd32 user: drh tags: trunk
20:06
Add SQLITE_DBSTATUS_CACHE_WRITE. Used to query a database connection for the cumulative number of database pages written. check-in: 05f98d4e user: drh tags: trunk
19:44
Add SQLITE_DBSTATUS_CACHE_WRITE. Used to query a database connection for the cumulative number of database pages written. check-in: 3cb6a879 user: dan tags: fts4-incr-merge
17:29
Enable fts3 tables to use incremental merge by automatically creating the %_stat table when it is needed. check-in: cc051fc0 user: drh tags: fts4-incr-merge
17:09
Fix a failing assert() in the FTS3_LOG_MERGES related code. check-in: 4220d52c user: dan tags: fts4-incr-merge
16:43
Add a comment to fts3SyncMethod() to justify the nMinMerge=64 constant. check-in: af55ca5f user: dan tags: fts4-incr-merge
16:18
Fix a bug in debugging code enabled when FTS3_LOG_MERGES is defined. check-in: 2e06babf user: drh tags: fts4-incr-merge
16:11
Remove the Fts3Table.mxLevel variable. check-in: 67a0cffc user: dan tags: fts4-incr-merge
14:45
Merge auto-incr-merge with incr-merge branch. check-in: 1c68687a user: dan tags: fts4-incr-merge
14:45
Modify the way the number of leaves written and the maximum relative level are calculated in the auto-incr-merge code. Closed-Leaf check-in: 0d841c95 user: dan tags: fts4-auto-incr-merge
02:20
An attempt at automatic incremental merging for FTS4. check-in: ed69434c user: drh tags: fts4-auto-incr-merge
2012-03-23
18:26
Fix a spurious SQLITE_CONSTRAINT error that may be returned by an incr-merge operation. check-in: ed7c17ea user: dan tags: fts4-incr-merge
15:38
Add a test to verify that sqlite3_total_changes() works with incr-merge operations. check-in: 1c72cecc user: dan tags: fts4-incr-merge
14:38
Remove an incorrect assert() statement. Fix a const-related warning. check-in: 96ed4749 user: dan tags: fts4-incr-merge
14:23
When an incremental blob cursor is invalidated (occurs when an SQL statement modifies or deletes the row the blob cursor points to) release all page references held by the cursor. Otherwise, the presence of these references may cause other code in btree.c to incorrectly infer that the database is corrupt. check-in: 341b703c user: drh tags: trunk
13:40
Fix another test case issue in trace2.test. check-in: 02a8e423 user: dan tags: fts4-incr-merge
11:09
When an incremental blob cursor is invalidated (occurs when an SQL statement modifies or deletes the row the blob cursor points to) release all page references held by the cursor. Otherwise, the presence of these references may cause other code in btree.c to incorrectly infer that the database is corrupt. check-in: 82c3f2ba user: dan tags: fts4-incr-merge
11:07
Update a couple of existing test cases. check-in: dcb8fa0f user: dan tags: fts4-incr-merge
2012-03-22
17:48
Add test cases to fts4merge.test. check-in: ecab2083 user: dan tags: fts4-incr-merge
16:48
Following an incr-merge operation that does not completely consume its input segments, store context in the rowid==1 row of the %_stat table that allows the next incr-merge to pick up where the previous left off. check-in: ab0a4f44 user: dan tags: fts4-incr-merge
12:50
Always quote the names of tables in the output of the shell's ".dump" command, even if the name is pure alphabetic text, in case the name is a keyword. check-in: 638b7115 user: drh tags: trunk
2012-03-21
14:34
Add fts4merge3.test, for testing that older versions of FTS4 may interoperate with incr-merge capable versions. check-in: 903ec512 user: dan tags: fts4-incr-merge
2012-03-20
17:04
Merge trunk changes into the fts4-incr-merge branch. check-in: f61d5fb0 user: drh tags: fts4-incr-merge
15:10
Remove the _SafeInit() entry points from the TCL interface. They have long been no-ops. Removing them completely avoids confusion as to why they don't work. check-in: 0fb26c7b user: drh tags: trunk
11:35
Version 3.7.11 check-in: 00bb9c9c user: drh tags: trunk, release, version-3.7.11
03:10
Fix out-of-bounds array references in the "echo" virtual table module used for testing. No changes to the SQLite core. check-in: 7b449b30 user: drh tags: trunk
2012-03-19
17:42
Add additional test cases to e_insert.test. Update evidence marks. no changes to core code. check-in: 036395c0 user: drh tags: trunk
14:57
Fix one more compiler warning missed by the previous check-in. check-in: bc03d99a user: drh tags: trunk
14:51
Suppress harmless compiler warnings on windows in FTS4 and RTREE. check-in: 4fd68647 user: drh tags: trunk
14:28
Avoid a compiler warning (an incorrect compiler warning, at that) in vs2010. check-in: 7dd97f12 user: drh tags: trunk
10:21
Ensure that compatible malloc and free functions are used with stat3 data if SQLITE_ENABLE_STAT3 is defined. check-in: 32bb1ece user: dan tags: trunk
2012-03-17
16:56
Fix various incorrect and missing comments and other style issues in and around the FTS incremental merge code. check-in: 7aabb62c user: dan tags: fts4-incr-merge
15:12
In pager1.test, use "file attr test.db -readonly 0" before "file attr test.db -perm rw-rw-rw-", not after. check-in: 4f5283f1 user: dan tags: trunk
09:43
Modify a test in ioerr2.test to account for the new SQLITE_ABORT_ROLLBACK extended error code. check-in: affaebde user: dan tags: trunk
2012-03-16
17:00
Update the trace2.test script for languageid. check-in: a11528ac user: drh tags: trunk