/ 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 descendants of [6484fb5a]

2014-07-22
14:58
Enhance the sqlite_stat1.stat parsing to allow additional text parameters at the end. Unrecognized parameters are silently ignored. check-in: ca2a5a2c user: drh tags: trunk
14:42
Expire prepared statements after running ANALYZE. check-in: b083a961 user: drh tags: trunk
12:05
Enhance the comment on whereLoopAddBtree(). No changes to code. check-in: b22dd165 user: drh tags: trunk
00:40
For the OR-optimization, avoid generating OP_OpenRead opcodes that reopen exactly the same index. check-in: b67a6e33 user: drh tags: trunk
2014-07-21
20:07
Limit the maximum SQLITE_MAX_ATTACHED to 127, since a signed character is sometimes used to store the database index. check-in: f1c76c7c user: drh tags: trunk
15:45
Fix DELETE and UPDATE operations on fts5 tables. check-in: d44d3a85 user: dan tags: fts5
15:44
Allow the SQLITE_MAX_ATTACHED compile-time option to be larger than 62. The default limit on the number of attached databases remains 10. check-in: 1a817ae2 user: drh tags: trunk
14:22
Add the xTokenize extension API. check-in: 8c6b0aff user: dan tags: fts5
11:44
Fix the xColumnSize() extension API. check-in: 19504c41 user: dan tags: fts5
2014-07-19
20:27
Add simple tests for the xColumnText() extension api. check-in: 1e9053ab user: dan tags: fts5
20:15
Add new ASCII mode to the shell capable of importing and exporting using the official unit and record separators (i.e. 0x1F and 0x1E, respectively). check-in: 7fe601ea user: mistachkin tags: asciiMode
17:57
Update the sqlite3_stmt_busy() function so that it correctly returns true for "ROLLBACK" statements that have been stepped but not yet reset. check-in: 61cee3c0 user: dan tags: trunk
17:49
Fix harmless compiler warnings in the showdb and showwal tools and in the unicode tokenizer of FTS3. check-in: 574cc8eb user: drh tags: trunk
15:44
Fix some harmess compiler warnings in the FTS3 Unicode module. Closed-Leaf check-in: c01caea5 user: mistachkin tags: toolWarnings
15:40
Fix warnings related to having a 64-bit size_t. check-in: 29ac9336 user: mistachkin tags: toolWarnings
15:35
Fixes for the xColumnSize() fts5 extension API. check-in: 43fcb844 user: dan tags: fts5
15:30
Fix warnings caused by the previous commit. check-in: 89634a41 user: mistachkin tags: toolWarnings
2014-07-18
21:16
Fix harmless compiler warnings for MSVC in the showdb/showwal command line tools. check-in: 6dc7b2f1 user: mistachkin tags: toolWarnings
21:02
Update clean targets with the recently added command-line tools. check-in: 2beefa68 user: mistachkin tags: trunk
19:59
Fix issues with position lists and NEAR constraints. check-in: 16352d36 user: dan tags: fts5
19:06
Improved documentation for checkpoints and the busy handler. No changes to code. check-in: ca92c024 user: drh tags: trunk
17:39
SQLite has long accepted some unadvertised and non-standard join syntax. Add a test to ensure that future versions continue to accept this non-standard syntax, to avoid breaking legacy applications that use the undefined syntax. check-in: 824dde7f user: drh tags: trunk
14:43
Improvements to the ".fullschema" command in the command-line shell. check-in: fa80c64c user: drh tags: trunk
2014-07-17
15:14
Fix a problem with position list processing for OR queries. check-in: 5808f30f user: dan tags: fts5
2014-07-16
20:07
Fixes for tcl list generation in fts5_test(). check-in: c1f9a4b7 user: dan tags: fts5
19:15
Begin adding interface for auxiliary functions. check-in: 1e2a7ba0 user: dan tags: fts5
2014-07-10
20:21
Support "ORDER BY rowid ASC". check-in: b96b5e16 user: dan tags: fts5
2014-07-08
16:27
Add support for prefix queries to fts5. check-in: 75ebd3cd user: dan tags: fts5
2014-07-07
18:03
Fix harmless compiler warnings in the fts3view utility program that can occur with MSVC. check-in: 1cec1e03 user: mistachkin tags: trunk
17:57
Add the fts3view utility program to the MSVC makefile. check-in: b04751bd user: mistachkin tags: trunk
16:07
Fix a division-by-zero error in the fts3view utility program. Add the fts3view utility program to the "main.mk" makefile. check-in: 64f02699 user: drh tags: trunk
2014-07-05
15:15
Add support for AND, OR and NOT to fts5. check-in: 8682b87e user: dan tags: fts5
07:54
Add support for the "colname : <nearset>" syntax to fts5. check-in: 00466710 user: dan tags: fts5
2014-07-03
20:39
Add support for NEAR expressions to fts5. check-in: 250ae8d4 user: dan tags: fts5
12:18
Change fts3/4 so that the "unicode61" is included in builds by default. It may now be excluded by defining SQLITE_DISABLE_FTS3_UNICODE. check-in: 0cc0230a user: dan tags: trunk
2014-07-02
20:18
Add support for phrase queries to fts5. check-in: 2e5652e6 user: dan tags: fts5
2014-07-01
20:45
Change the position list format so that its size in bytes is stored at the start of the list itself. check-in: 62f2ff20 user: dan tags: fts5
15:22
Add another test to verify that SQLite is using stat4 data for composite primary keys on WITHOUT ROWID tables. check-in: 0df1fe72 user: dan tags: trunk
11:54
Ensure that all fields are loaded from the stat4 table for records that correspond to indexes on WITHOUT ROWID tables with composite primary keys. check-in: 21981e35 user: dan tags: trunk
2014-06-30
20:25
Merge the latest trunk changes into the threads branch. check-in: ae23a65e user: drh tags: threads
20:02
Merge the latest trunk enhancements into the sessions branch. check-in: a5d94eab user: drh tags: sessions
19:57
Merge the latest trunk changes into the apple-osx branch. check-in: f426876f user: drh tags: apple-osx
19:28
Bump the version number to 3.8.6. check-in: f925e9ba user: drh tags: trunk
19:07
Attempt to use STAT4 information to estimate the selectivity of WHERE clause terms when using the skip-scan optimization. check-in: d09ca6d5 user: drh tags: trunk
18:57
Fix for ticket [b2fa5424e6fcb15]: Better define the format of the sqlite_stat4 file for WITHOUT ROWID tables and make sure the ANALYZE command generates a file in the appropriate format. Use the sqlite_stat4 data to enable the use of WHERE terms that cover all indexed columns plus some prefix of columns in the primary key. check-in: bc2de809 user: drh tags: trunk
18:02
Fix a problem in where.c with using the stat4 sample data of an index on a WITHOUT ROWID table. Closed-Leaf check-in: 053a210e user: dan tags: stat4-without-rowid
17:07
Fix the STAT4 information for WITHOUT ROWID tables. check-in: 5d8628fd user: drh tags: stat4-without-rowid
15:23
Fix where.c so that the primary key values appended to every index entry on a WITHOUT ROWID table may be used when useful. check-in: 6624a61d user: dan tags: stat4-without-rowid
13:56
Omit non-primary-key columns from the STAT4 samples for WITHOUT ROWID tables. Indexes, both rowid and without-rowid, still hold an exact copy of the index entry. check-in: de826c31 user: drh tags: stat4-without-rowid
13:32
Generate complete samples for sqlite_stat4 on WITHOUT ROWID tables. Ticket [b2fa5424e6fcb15b5] check-in: 8cb43edd user: drh tags: stat4-without-rowid
11:14
Add makefile targets for various diagnostic tools, such as showstat4. Fix harmless compiler warnings in diagnostic tools. check-in: 6f86d89b user: drh tags: trunk
2014-06-28
19:06
Add an OOM fault injection test for the new code on this branch. Closed-Leaf check-in: c96de490 user: dan tags: stat4-skipscan
17:35
Add further tests to skipscan5.test. check-in: 4b8230e8 user: dan tags: stat4-skipscan
16:06
Add header comments on new routines. Rework the sqlite3Stat4Column() routine so that is (in theory) able to deal with corrupt samples. check-in: ef5cdf94 user: drh tags: stat4-skipscan
15:26
Fix a problem with using stat4 samples of type text when estimating the rows visited by a range-query/skip-scan loop. check-in: dfb09db6 user: dan tags: stat4-skipscan
14:28
Change the VDBE to export the sqlite3MemCompare() routine and thus free where.c from the dependency on vdbeInt.h. check-in: d186d1ac user: drh tags: stat4-skipscan
14:25
Merge fixes from trunk with this branch. check-in: 6af219d1 user: dan tags: stat4-skipscan
2014-06-27
20:14
Fix a couple of problems in estimating the number of rows visited by a range query that uses a skip-scan. check-in: 219736f5 user: dan tags: stat4-skipscan
2014-06-26
22:17
Add some more IN operator tests. check-in: fb32e374 user: mistachkin tags: trunk
21:32
Fix compilation issue when STAT4 is not enabled. check-in: 74a5454a user: mistachkin tags: stat4-skipscan
21:28
Revise the affinity returned for expressions flagged as 'generic'. Fix for [9a8b09f8e6]. check-in: 92f7ad43 user: mistachkin tags: trunk
20:21
Attempt to use sqlite_stat4 data to estimate the number of rows visited by a range query that uses a skip-scan. This code is largely untested. check-in: 01dc8102 user: dan tags: stat4-skipscan
12:31
Fix minor problems in term matching. check-in: 94eeb077 user: dan tags: fts5
2014-06-25
20:28
Begin adding query support to fts5. check-in: 47a9f3cc user: dan tags: fts5
2014-06-24
20:19
Fix showstat4.c so that it decodes typecodes 8 and 9 correctly. check-in: 9ca737c0 user: drh tags: trunk
16:59
Add simple full-table-scan and rowid lookup support to fts5. check-in: 3515da85 user: dan tags: fts5
00:59
Add the showstat4.exe utility program for decoding and displaying the content of the sqlite_stat4 table in a database. check-in: b4d9f605 user: drh tags: trunk
2014-06-23
23:28
Add the .fullschema command to the sqlite3.exe utility. This command shows the schema and the content of the sqlite_stat tables, all in one go. Useful when reporting problems with the query planner. check-in: ebec4892 user: drh tags: trunk
11:33
Add some code for an experimental fts5 module. Does not work yet. check-in: 1e0648dc user: dan tags: fts5
10:18
Fix a problem with SQLITE_OMIT_WSD builds. check-in: 07dda49c user: dan tags: trunk
10:04
Fix a problem with SQLITE_OMIT_WAL builds. check-in: 612b6d1b user: dan tags: trunk
2014-06-20
13:55
Improved display of record data in the "NNNbd" output of the showdb.exe utility program. check-in: f735c249 user: drh tags: trunk
01:32
In the showdb.exe utility, for the "NNNbd" command, also show data fields in addition to header fields on each record decoded. Improvements to formatting. check-in: b451fe0c user: drh tags: trunk
2014-06-19
23:38
Add the ability to decode the headers of individual cells, byte-by-byte, in the "showdb.exe" utility. check-in: 306b461d user: drh tags: trunk
2014-06-18
18:10
Add the "LogEst" and "LogEst.exe" target to the makefiles. check-in: 7b91b058 user: drh tags: trunk
15:24
Fix a comment on the sqlite3Utf8Read() routine. No changes to code. check-in: 5e514f6a user: drh tags: trunk
15:18
Merge in all recent changes from trunk, and especially the automatic index enhancements. check-in: 0e1b7349 user: drh tags: threads
15:11
Prevent an automatic index from taking the place of a declared index. check-in: 0a52bddd user: drh tags: trunk
2014-06-17
20:16
Prevent an automatic index from taking the place of a declared index. Closed-Leaf check-in: 4ece839d user: drh tags: autoindex-improvements
17:00
Fix a missing space in a "wheretrace" comment. No changes to production code. check-in: b500f2a0 user: drh tags: trunk
16:11
Add the likely() function for symmetry with unlikely(). The likely(X) function means the same thing as likelihood(X,0.9375). check-in: 38965484 user: drh tags: trunk
15:53
Improvements to query planning, especially in regards to estimating the cost and benefit of automatic indexes. check-in: 1272fb89 user: drh tags: trunk
13:23
Add the autoindex2.test testing module. check-in: ffe3fea4 user: drh tags: autoindex-improvements
12:33
A different approach to the autoindex problem that deletes query-planner code rather than adding it. check-in: f270fb6e user: drh tags: autoindex-improvements
09:52
Simplification to the logic that prevents automatic indexes from being formed on constant expressions. check-in: 36d67e1d user: drh tags: autoindex-improvements
09:00
Allow an automatic index on a WHERE constraint where the RHS is does not reference another table as long as the RHS is not a constant. check-in: 58acc2a8 user: drh tags: autoindex-improvements
02:46
Do not attempt to create an automatic index on a constant constraint, as doing so is pointless. check-in: d6883e96 user: drh tags: autoindex-improvements
2014-06-16
22:45
Fix CSV import issue, reported via the mailing list, in the shell when the file to be imported ends with an empty line. check-in: fc918f7d user: mistachkin tags: trunk
21:30
In the "wheretrace" logic (disabled for normal builds) expand the print width of the flags field to be wide enough for all 17 bits. check-in: 3181d206 user: drh tags: trunk
18:35
Add the SQLITE_UNLINK_AFTER_CLOSE compile-time option. If enabled, the unlink of temporary files on unix is deferred until after the file is closed. check-in: e43a2f92 user: drh tags: trunk
18:17
Add an application ID for MBTiles tilesets. check-in: 837f6404 user: drh tags: trunk
16:41
Back out the unix VFS changes that seeks to avoid fstat() calls after an unlink(). That change did not clear the problem on FuseFS. check-in: 0617e20a user: drh tags: trunk
15:01
Add the ".eqp" dot-command to the ".help" output in the command-line shell. This was accidently omitted when the ".eqp" command was originally implemented for SQLite 3.8.4 (check-in [e6ecf7337658624]). check-in: b0b4c776 user: drh tags: trunk
12:51
Fix the extension01.test script so that it works on windows. Fix a harmless compiler warning in the fileio extension. check-in: baf95a19 user: drh tags: trunk
12:44
Add test cases for the fileio extension. check-in: 86343331 user: drh tags: trunk
2014-06-13
13:43
Add the fileio.c loadable extension, that implements readfile() and writefile() SQL functions. check-in: 0ca104d8 user: drh tags: trunk
13:08
Add an extension that implements compress() and uncompress() SQL functions. check-in: d5c17d1a user: drh tags: trunk
2014-06-12
17:10
Increase the WAL-mode SQLITE_PROTOCOL timeout to 10 seconds. check-in: 2aeacf81 user: drh tags: trunk
15:46
Simplify the estLog() routine. check-in: 6c68d758 user: drh tags: trunk
2014-06-10
20:18
Proposed change to the fix for ticket [1c69be2dafc28b] such that legacy applications that were exploiting the older buggy behavior in SQLite continue to work. Leaf check-in: 401a0ca3 user: drh tags: group-by-name-resolution
2014-06-09
20:39
Avoid an unnecessary initialization of the szFile field of unixFile in the unix VFS. check-in: 6484fb5a user: drh tags: trunk