Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 ancestors of 49c1e74522a26e5d
2015-04-11
| ||
16:23 | Improve fts5 integrity-check so that it checks that DESC queries return the same as ASC. Change the poslist format slightly to make room for a delete-flag. (check-in: 49c1e745 user: dan tags: fts5) | |
2015-03-21
| ||
15:45 | Merge trunk changes with this branch. (check-in: 14274391 user: dan tags: fts5) | |
15:37 | When scanning the full-text index as part of the fts5 integrity-check, also run a point query for every term and verify that these results are consistent with those found by the linear scan. (check-in: ce972f6a user: dan tags: fts5) | |
12:25 | Remove an unreachable branch from the OP_VCreate opcode (merge accidental fork in trunk). (check-in: 2fbfec62 user: dan tags: trunk) | |
12:22 | Avoid an integer overflow in fts3 causing gcc 4.7.1 with -O2 to behave counter-intuitively (perhaps because the behaviour is undefined). Add an "ifcapable trace" to a test in shell4.test. (check-in: e3e23464 user: dan tags: trunk) | |
12:22 | Remove an unreachable branch from the OP_VCreate opcode. (check-in: 5fca41a3 user: drh tags: trunk) | |
10:53 | Add a missing "ifcapable fts3" to a test case in vtab2.test. (check-in: d845b0f6 user: dan tags: trunk) | |
03:18 | Correctly detect the error of having a "*" wildcard on a SELECT without a FROM clause on the left-hand side of a recursive CTE. (check-in: b11d1793 user: drh tags: trunk) | |
02:58 | If a column is both UNIQUE and a PRIMARY KEY, make sure the PRIMARY KEY designation takes precedence. (check-in: d871a792 user: drh tags: trunk) | |
02:25 | Remove superfluous define from the MSVC makefile. (check-in: 880d2513 user: mistachkin tags: trunk) | |
02:22 | Improvements to the MSVC build. Fix harmless compiler warnings. Enable use of 'stdcall'. (check-in: 737630b8 user: mistachkin tags: trunk) | |
2015-03-20
| ||
16:54 | Provide the BTREE_SEEK_EQ hint to the b-tree layer. (check-in: 3c367004 user: drh tags: trunk) | |
16:34 | Fix to get SQLITE_SMALL_STACK working correctly again after the previous change. (Closed-Leaf check-in: 78df0ce1 user: drh tags: seek-eq) | |
14:57 | Provide the BTREE_SEEK_EQ hint to the b-tree layer. (check-in: e750830f user: drh tags: seek-eq) | |
08:43 | Fix a problem causing collation sequence names to be dequoted multiple times under some circumstances. (check-in: eddc05e7 user: dan tags: trunk) | |
2015-03-19
| ||
20:09 | If a virtual table is created with a malformed UTF8 name in a UTF16 database, make sure that does not cause problems. (check-in: b74cb0a9 user: drh tags: trunk) | |
19:59 | Fix a crash that can occur following an OOM condition within a CREATE VIRTUAL TABLE statement on a utf-16 database. (Closed-Leaf check-in: 9453e7da user: dan tags: malformed-vtab-name) | |
18:56 | Fix a problem with creating virtual table with names specified using malformed utf-8 within utf-16 databases. (check-in: 9969cff2 user: dan tags: malformed-vtab-name) | |
16:25 | Fix an FTS3/4 problem with handling empty tokenizer declarations (e.g. "CREATE VIRTUAL TABLE t(tokenize=);"). (check-in: 26d2def8 user: dan tags: trunk) | |
15:52 | Silently ignore any attempt to add a prefix index for prefixes zero bytes in size to an fts3/4 table. Or any prefix index size so large that it overflows a 32-bit signed integer. (check-in: ad4b19d2 user: dan tags: trunk) | |
15:04 | Add an assert() to check that the database mutex is held in sqlite3BtreeLeave(). (check-in: 31f54d7b user: dan tags: trunk) | |
14:48 | Fix typo in shell error message. (check-in: 775a02d5 user: mistachkin tags: trunk) | |
13:30 | Fix a bug in error handling in the ".trace" command of the command-line shell. (check-in: 6a48b5d7 user: drh tags: trunk) | |
2015-03-18
| ||
16:00 | Add another sqlite3FaultSim() to the multi-threaded sorter logic to improve testability. (check-in: 49ea2cde user: drh tags: trunk) | |
2015-03-17
| ||
20:39 | Clarify the documentation on sqlite3_errcode(). No changes to code. (check-in: 2c0e0d87 user: drh tags: trunk) | |
17:08 | Also merge the WAL blocking lock tests that were somehow missed on the previous check-in. (check-in: 7214dab7 user: drh tags: trunk) | |
16:59 | Transient locks in WAL mode can now block in order to resolve priority inversions. (check-in: ec2f46de user: drh tags: trunk) | |
16:01 | Add a test for the change on this branch. (Closed-Leaf check-in: e22dde18 user: dan tags: wal-blocking-lock) | |
2015-03-16
| ||
20:40 | Make SQLite slightly more likely to use an auto-index within a sub-query. (check-in: ab832336 user: dan tags: trunk) | |
18:08 | Fix typo of test prefix in the new WHERE test file. (check-in: 34779c52 user: mistachkin tags: trunk) | |
17:48 | When the WHERE clause contains two OR-connected terms with identical operands but different operators, try to combine them into a single term. Example: (X=A OR X>A) becomes (X>=A). (check-in: 8bdda827 user: drh tags: trunk) | |
17:07 | Modify the fts3query.test script so that it works even when testfixture is built using a version of TCL that is unable to sort the integer -9223372036854775808 (check-in: f61fd24b user: drh tags: trunk) | |
16:44 | When deleting the master journal to commit a multi-database transaction, do not sync the directory if PRAGMA synchronous=OFF for all participating database files. (check-in: 018d7671 user: drh tags: trunk) | |
16:28 | When estimating the number of rows visited by a range scan for which the keys consist of more than one field, consider prefixes of stat4 samples as well as the full samples. This generates more accurate estimates. (check-in: 3e0590de user: dan tags: trunk) | |
13:48 | Use #ifdef to omit code that is only used for STAT3 and STAT4. (check-in: f2c9c5b5 user: drh tags: trunk) | |
13:12 | Improved comments. No code changes. (Closed-Leaf check-in: 23f71a26 user: drh tags: combine-disjuncts) | |
12:13 | When a WHERE clause contains disjuncts with the same operands, try to combine them into a single operator. Example: (x=A OR x>A) becomes (x>=A). (check-in: 7a309768 user: drh tags: combine-disjuncts) | |
09:21 | Another test case for the planner change on this branch. (Closed-Leaf check-in: f2207a06 user: dan tags: stat4-change) | |
2015-03-14
| ||
18:59 | When estimating the number of rows visited by a range scan for which the keys consist of more than one field, consider prefixes of stat4 samples as well as the full samples. (check-in: e1caf93c user: dan tags: stat4-change) | |
2015-03-13
| ||
15:44 | Add tests to ensure "PRAGMA incremental_vacuum" and "PRAGMA auto_vacuum = incremental" handle corrupt databases correctly. (check-in: 1c2166cb user: dan tags: trunk) | |
08:31 | Extra tests for commit [0f250957]. (check-in: 5aa522dc user: dan tags: trunk) | |
00:11 | Remove debugging logic accidently included in the previous check-in. (check-in: 2887fb38 user: drh tags: trunk) | |
2015-03-12
| ||
23:48 | Fix the "now" option for date-time functions for cases when STAT4 is disabled. (check-in: 3ac1f6a3 user: drh tags: trunk) | |
21:22 | When STAT4 is enabled, allow probes of the STAT4 table using the value of constant functions computed at compile-time. (check-in: 0f250957 user: drh tags: trunk) | |
21:02 | Always disallow functions as the DEFAULT of a column. Add assert()s and (Closed-Leaf check-in: a991bb1a user: drh tags: stat4-function) | |
19:12 | Disable multiplexing of master-journal files in the test_multiplex.c module. (check-in: b8684df3 user: dan tags: trunk) | |
18:38 | If an error occurs in the compile-time evaluation of an application-defined function, then propagate back out the exact error code, not just the generic SQLITE_ERROR. (check-in: 93f42586 user: drh tags: stat4-function) | |
06:46 | The valueFromFunction() routine is better able to handle OOM errors. Omit unreachable branches. (check-in: 8fb6bd9b user: drh tags: stat4-function) | |
05:08 | Improve the text on one of the opcode documentation comments in vdbe.c. (check-in: 08958f57 user: drh tags: trunk) | |
2015-03-11
| ||
20:59 | Allow the default value for columns added using ALTER TABLE ADD COLUMN to be a function in existing schemas loaded from disk. But prevent this version of SQLite from being used to create such a column. (check-in: ff868e22 user: dan tags: stat4-function) | |
20:06 | Allow the query planner to evaluate deterministic scalar SQL functions used in WHERE constraints if all arguments are SQL literals in order to compare the results with sqlite_stat4 sample data. (check-in: b7f1fc26 user: dan tags: stat4-function) | |
14:51 | Add an optimization to the fts5 unicode tokenizer code. (check-in: f5db4892 user: dan tags: fts5) | |
14:34 | Expand the multi-process test cases to repeat each case 20 times and to repeat tests using different journal modes. (check-in: a2715b04 user: drh tags: trunk) | |
2015-03-10
| ||
20:22 | Arrange for some of the transient locks in WAL mode to block, as a single to the OS to fix priority inversions. (check-in: c6e6d5f4 user: drh tags: wal-blocking-lock) | |
19:24 | Avoid redundant string comparisons while merging fts5 segment b-trees. (check-in: 5c46820d user: dan tags: fts5) | |
15:34 | Fix an incrblob2 test case so that it works on 32-bit systems. (check-in: 8d0b11c9 user: drh tags: trunk) | |
13:50 | Revise test cases in malloc5.test to accommodate varying allocation sizes returned by some system malloc() implementations. (check-in: fbae6baf user: drh tags: trunk) | |
2015-03-09
| ||
13:01 | Fix the LIKE optimization so that it works even if there are additional range contraints on the column that is subject to the LIKE or GLOB. (check-in: 984c3fd5 user: drh tags: trunk) | |
12:11 | Always use LIKE optimization range constraints in pairs. (Closed-Leaf check-in: 0e02dc94 user: drh tags: like-opt-fix) | |
10:40 | Increase the version number to 3.8.9 (check-in: e5da5e7d user: drh tags: trunk) | |
2015-03-07
| ||
20:32 | Fix another problem with the LIKE optimization. (check-in: 465bfc72 user: drh tags: like-opt-fix) | |
15:46 | Fix some compiler warnings caused by signed/unsigned pointer conversions. (check-in: cccee7b5 user: dan tags: fts5) | |
13:56 | Fix the LIKE optimization so that it finds BLOB entries in addition to text entries. Ticket [05f43be8fdda9f]. (check-in: 74cb0b03 user: drh tags: trunk) | |
12:58 | New test cases for LIKE and GLOB with BLOB left-hand side values. (Closed-Leaf check-in: 50fa3c5f user: drh tags: like-opt-fix) | |
11:50 | Fix the bm25() function so that it multiplies scores by -1 before returning them. This means better matches have a lower numerical score, so "ORDER BY rank" (not "ORDER BY rank DESC") does what you want. (check-in: 3ee7b5a9 user: dan tags: fts5) | |
03:02 | Remove some code that is commented out. (check-in: 55ff4291 user: drh tags: like-opt-fix) | |
02:51 | Fix problems with reverse order sorting and indexes in the LIKE optimization. (check-in: 564b8fe7 user: drh tags: like-opt-fix) | |
00:57 | Refactor some jump opcodes in the VDBE. Add JumpZeroIncr and DecrJumpZero. Fix the LIKE optimization to work with DESC sort order. (check-in: 26cb5145 user: drh tags: like-opt-fix) | |
2015-03-06
| ||
20:49 | Test cases added. Comments fixed. Proposed solution for ticket [05f43be8fdda9fbd9]. (check-in: 6b993bd5 user: drh tags: like-opt-fix) | |
19:47 | Fix the LIKE optimization even when comparing mixed-case BLOBs. (check-in: a58aafdb user: drh tags: like-opt-fix) | |
16:45 | The LIKE optimization must be applied twice, once for strings and a second time for BLOBs. Ticket [05f43be8fdda9f]. This check-in is a proof-of-concept of how that might be done. (check-in: 5757e803 user: drh tags: like-opt-fix) | |
04:37 | Clearification of some documentation text. Added requirements marks. (check-in: 8c1e85aa user: drh tags: trunk) | |
03:31 | Clarification of documentation on sqlite3_backup. (check-in: 31d5e9b4 user: drh tags: trunk) | |
2015-03-05
| ||
15:34 | New test cases and requirements marks for PRAGMA index_info, index_xinfo, and index_list. (check-in: e5b13634 user: drh tags: trunk) | |
14:29 | Revert "PRAGMA index_info" to output only three columns, for complete compatibility with prior versions. The new "PRAGMA index_xinfo" can be used to get the extra information in 4th, 5th, and 6th columns. (check-in: fc543c2c user: drh tags: trunk) | |
01:29 | New requirements marks on compound SELECT statements. (check-in: e7991bc5 user: drh tags: trunk) | |
2015-03-04
| ||
23:14 | New requirements marks on INSERT and INDEXED BY and on some sqlite3_config() options. (check-in: c298ea0b user: drh tags: trunk) | |
20:18 | Fix harmless compiler warning. (check-in: 580dae46 user: mistachkin tags: trunk) | |
15:35 | Refinement to the wording of the documentation on depreciated functions. (check-in: 04a59d6f user: drh tags: trunk) | |
15:25 | Remove a surplus </dl> mark in the documentation. No changes to code. (check-in: 5450e465 user: drh tags: trunk) | |
08:29 | Fix a couple of build problems. (check-in: a5d5468c user: dan tags: fts5) | |
2015-03-03
| ||
20:42 | Clean up #ifdef logic dealing with VxWorks in os_unix.c. On VxWorks, automatically use posix advisory locking if it is available or fall back to named semaphore locking if not. (check-in: ac8c7ca3 user: drh tags: trunk) | |
19:56 | Fix compiler warnings when compiling under VxWorks 7. (check-in: 55c21521 user: drh tags: trunk) | |
16:58 | Enhance SQLITE_ALLOW_URI_AUTHORITITY to elide //localhost/ and to deal with dodgy URIs that contain too many "/" characters. (check-in: 39b566a2 user: drh tags: trunk) | |
14:00 | Fix over-length source code lines in the main.c source file. (check-in: debba6f1 user: drh tags: trunk) | |
2015-03-02
| ||
22:06 | Changes so that the amalgamation and the command-line shell build without modifications on VxWorks 7. Still gives a few compiler warnings, and still mostly untested on that platform. (check-in: 7d92f1f1 user: drh tags: trunk) | |
17:25 | Ensure that automatic indexes are *not* considered when doing the the subqueries of the OR-optimization. (check-in: 17890292 user: drh tags: trunk) | |
2015-02-28
| ||
14:03 | In the command-line shell, the inability to read ~/.sqliterc is no longer a fatal error. A warning is issued, but processing continues. (check-in: 6bf62463 user: drh tags: trunk) | |
01:04 | More test cases and requirements marks for pragmas. (check-in: fc51037c user: drh tags: trunk) | |
2015-02-27
| ||
21:53 | Remove all references to SQLITE_DEFAULT_TEMP_CACHE_SIZE. Add requirements marks related to cache_size changing. (check-in: 766ad650 user: drh tags: trunk) | |
20:28 | New requirements marks and a few new test cases to go with them. No changes to code. (check-in: 8c2b29d9 user: drh tags: trunk) | |
09:41 | Further minor optimizations to flushing fts5 data to disk. (check-in: a07dcca9 user: dan tags: fts5) | |
07:23 | Fix suffix and prefix compression of terms in top-level fts5 segments. And a crash that could follow an OOM condition. (check-in: bb104b36 user: dan tags: fts5) | |
00:33 | Add a couple of requirements marks. (check-in: d70b0fd4 user: drh tags: trunk) | |
2015-02-26
| ||
21:04 | Fix potential memory leaks in the misc 'compress' extension. (check-in: 3bc34fd4 user: mistachkin tags: trunk) | |
20:49 | Optimize copying data from fts5 in-memory hash tables to top level segments. (check-in: 8e3ca632 user: dan tags: fts5) | |
16:40 | Update a requirements mark to reflect a change of wording in the documentation. No changes to code. (check-in: 3038d016 user: drh tags: trunk) | |
16:32 | Fix a real bug (in test code) that was introduced while trying to eliminate harmless compiler warnings from OpenBSD (see check-in [10321910990195878c]). (check-in: a62ba58c user: drh tags: trunk) | |
14:54 | Fix an fts5 bug in large incremental merges. (check-in: 208e3cb6 user: dan tags: fts5) | |
02:33 | Simplifications to the description of the nByte parameter to sqlite3_prepare() and friends. (check-in: 4bee8295 user: drh tags: trunk) | |
2015-02-25
| ||
19:24 | Instead of the 4-byte fields, use regular varints for the poslist-size field in fts5_hash.c. (check-in: 7eb022d7 user: dan tags: fts5) | |