Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 check-ins occurring around f426876fe1cc9ebc.
2014-07-23
| ||
01:26 | Add support for parsing C-style hexadecimal literals. (check-in: 34a1f38b user: drh tags: hex-literal) | |
2014-07-22
| ||
22:46 | When running ANALYZE, it is not necessary to check the right-most key column for changes since that column will always change if none of the previous columns have. (check-in: 48f40861 user: drh tags: trunk) | |
20:02 | Add the OP_ReopenIdx opcode that works like OP_OpenRead except that it becomes a no-op if the cursor is already open on the same index. Update the OR-optimization logic to make use of OP_ReopenIdx in order to avoid unnecessary cursor open requests sent to the B-Tree layer. (check-in: 77f412ca user: drh tags: trunk) | |
19:14 | The optimization of check-in [b67a6e33f2] does not work (it generates incorrect VDBE code) if an OR term is AND-ed with a constant expression. So back that optimization out and add a test case to make sure it does not get added back in. (check-in: eed754fe user: drh tags: trunk) | |
16:00 | Fix the index name for the shadow tables in the spellfix1 extension so that multiple instances of the spellfix1 virtual table can each have their own index. (check-in: 438c348a user: drh tags: trunk) | |
15:33 | Correction: The maximum SQLITE_MAX_ATTACHED value to avoid overflowing a signed 8-bit integer is 125, not 127. (check-in: 48e37802 user: drh tags: trunk) | |
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-15
| ||
11:59 | Add simple tests for new sqlite3BtreeCursorHint() functionality. (check-in: 1efa6ed5 user: dan tags: cursor-hints) | |
2014-07-14
| ||
19:04 | In the expression passed to sqlite3BtreeCursorHint() for the inner loops of joins, replace any TK_COLUMN references to columns in the outer loops with TK_REGISTER expressions (Expr.iTable indicates the specific register containing the value). There are no automated tests for this yet. (check-in: f9dddd00 user: dan tags: cursor-hints) | |
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) | |
18:43 | Experimental changes to use GetFileInformationByHandle instead of GetFileSize in the Win32 VFS. (Closed-Leaf check-in: d22c8142 user: mistachkin tags: filesize-debug) | |
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) | |
15:13 | Small tweaks to the query planner to get it to try harder to use an index for sorting and to avoid using automatic indexes on constant terms. (Leaf check-in: 2d9de154 user: drh tags: branch-3.8.3) | |
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) | |