Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
51 events for the month beginning 2015-03-01 by user dan
Following month ↑|
2015-03-30
| ||
| 15:45 | Merge sorter optimizations with this branch. (check-in: 9bf1cfb4 user: dan tags: insert-select-opt) | |
| 12:06 | Improve performance of multi-field sorts where the first field has a low cardinality. (check-in: 601e7b6b user: dan tags: sorter-opt) | |
| 09:58 | Remove some unnecessary code from vdbesort.c. (check-in: b58191e9 user: dan tags: sorter-opt) | |
|
2015-03-28
| ||
| 19:56 | Further optimizations for sorting records that begin with integer or text values. (check-in: 24fe9f25 user: dan tags: sorter-opt) | |
|
2015-03-26
| ||
| 12:38 | Merge sorter optimization into this branch. (check-in: aeb8e9a9 user: dan tags: insert-select-opt) | |
| 11:55 | Optimize cases where all the sorter is sorting a set of records that all begin with integer values, or that all begin with text values to be compared using BINARY. (check-in: ce5ad17c user: dan tags: sorter-opt) | |
|
2015-03-25
| ||
| 15:23 | Extend [52e73eec] so that the IS optimization may be used on primary keys with more than 3 columns. (check-in: 4e8796af user: dan tags: ota-update) | |
|
2015-03-24
| ||
| 19:43 | Update this branch with latest trunk changes. (check-in: 3ccd64ef user: dan tags: insert-select-opt) | |
| 18:21 | Merge the latest trunk changes into this branch. (check-in: 9d9b6c88 user: dan tags: ota-update) | |
| 18:03 | When the OTA module updates or deletes a row, save only those fields that are part of an index or primary key to the ota update database. (check-in: 6326fd32 user: dan tags: ota-update) | |
| 14:57 | Add tests to check that attempting to DROP a virtual table while it is use does not cause problems. (Closed-Leaf check-in: 5ee625b1 user: dan tags: nVDestroy) | |
|
2015-03-23
| ||
| 17:10 | Fix a broken assert() in the ota module. (check-in: 858de8a5 user: dan tags: ota-update) | |
| 14:39 | Set the OPFLAG_SEEKRESULT correctly in "INSERT INTO ... SELECT" statements. (check-in: 6f7d9995 user: dan tags: insert-select-opt) | |
|
2015-03-21
| ||
| 19:35 | Avoid a segfault if NULL is passed as the first argument to SQL scalar function fts3_tokenizer(). (check-in: 6d098969 user: dan tags: trunk) | |
| 16:40 | Change walblock.test to block an external process for 10 seconds, not 5. 5 seconds is not long enough to tell the difference between a blocking lock and a series of retries. (check-in: 717335fc user: dan tags: trunk) | |
| 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) | |
| 15:26 | Do not use sorters for INSERT statements that insert multiple rows using the VALUES clause. (check-in: 93e28ea1 user: dan tags: insert-select-opt) | |
| 15:04 | Merge latest trunk changes with this branch. (check-in: 9affe7f3 user: dan tags: insert-select-opt) | |
| 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) | |
| 10:53 | Add a missing "ifcapable fts3" to a test case in vtab2.test. (check-in: d845b0f6 user: dan tags: trunk) | |
| 07:16 | Merge recent trunk changes with this branch. (check-in: 35eef4dd user: dan tags: insert-select-opt) | |
| 07:03 | Disable the sorter optimization used by INSERT INTO SELECT statements if the statement explicitly specifies REPLACE, IGNORE or FAIL conflict handling. (check-in: d4215942 user: dan tags: insert-select-opt) | |
|
2015-03-20
| ||
| 20:30 | Where possible insert the set of new keys for each index in sorted order within "INSERT INTO ... SELECT" statements. (check-in: 0a7f2051 user: dan tags: insert-select-opt) | |
| 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
| ||
| 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) | |
|
2015-03-18
| ||
| 20:03 | Allow whereShortCut() to use the PRIMARY KEY index of a WITHOUT ROWID table to optimize a vector of "IS" operators in a WHERE clause. (check-in: 52e73eec user: dan tags: ota-update) | |
| 19:04 | Clarify that OTA is unable to update or delete rows with NULL values in primary key fields. (check-in: 2e7c1e0a user: dan tags: ota-update) | |
|
2015-03-17
| ||
| 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) | |
| 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) | |
| 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) | |
|
2015-03-12
| ||
| 19:12 | Disable multiplexing of master-journal files in the test_multiplex.c module. (check-in: b8684df3 user: dan 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) | |
|
2015-03-10
| ||
| 19:24 | Avoid redundant string comparisons while merging fts5 segment b-trees. (check-in: 5c46820d user: dan tags: fts5) | |
|
2015-03-07
| ||
| 15:46 | Fix some compiler warnings caused by signed/unsigned pointer conversions. (check-in: cccee7b5 user: dan tags: fts5) | |
| 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) | |
|
2015-03-05
| ||
| 16:21 | Fix some problems with OTA and empty target databases, or target databases with the wrong set of tables. Also add SQLITE_FCNTL_VFSNAME support to the OTA VFS. (check-in: 46119e8d user: dan tags: ota-update) | |
| 14:07 | Add comments to sqlite3ota.h to make it clear that passing NULL in place of a parent VFS name to sqlite3ota_create_vfs() causes the new VFS to use the system default as its parent. (check-in: 158c1a48 user: dan tags: ota-update) | |
| 13:43 | Fix a typo in sqlite3ota.h. (check-in: 04087dec user: dan tags: ota-update) | |
|
2015-03-04
| ||
| 08:29 | Fix a couple of build problems. (check-in: a5d5468c user: dan tags: fts5) | |