Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 most recent check-ins tagged with "experimental"
|
2014-10-10
| ||
| 20:52 | Account for the ASC/DESC properties of ORDER BY expressions when using the same index for GROUP BY and ORDER BY. Candidate fix for [ba7cbfaedc]. (Closed-Leaf check-in: 2a9573962b user: dan tags: experimental) | |
|
2014-08-29
| ||
| 11:24 | Add the sqlite3VdbeChangeDest() routine that can be used to eliminate OP_Move opcodes. (Closed-Leaf check-in: 8c57bcc327 user: drh tags: experimental) | |
|
2014-08-22
| ||
| 14:56 | Handle the 4-byte integer case in the stackless routine. (Closed-Leaf check-in: 3f55484e81 user: drh tags: experimental) | |
| 14:34 | Get the sqlite3VdbeSerialGet() routine to run faster by avoiding the use of local variables. (check-in: 8267d82174 user: drh tags: experimental) | |
|
2014-03-03
| ||
| 21:46 | Fix a couple of harmless compiler warnings. (Closed-Leaf check-in: fcf480cc63 user: drh tags: experimental) | |
| 20:48 | Avoid a buffer overread in vdbeCompareRecordInt() that might occur if the database is corrupt. (check-in: 7c0b4381f0 user: dan tags: experimental) | |
| 19:29 | Fix a typo in a comment. No changes to code. (check-in: 1f4991ab16 user: drh tags: experimental) | |
| 18:25 | Fix compiler warnings. (check-in: ba8993727e user: drh tags: experimental) | |
| 17:48 | Merge latest trunk changes. (check-in: 1d60356462 user: dan tags: experimental) | |
| 15:13 | Fix a harmless compiler warning. (check-in: d7f6837e69 user: drh tags: experimental) | |
| 14:45 | Merge latest trunk changes. (check-in: e00ed717fb user: dan tags: experimental) | |
|
2014-03-01
| ||
| 19:45 | Merge trunk changes. (check-in: 9c1747b5de user: dan tags: experimental) | |
| 19:44 | Remove the vdbeRecordCompareLargeHeader function. Fix some other details. (check-in: 3861e85310 user: dan tags: experimental) | |
|
2014-02-28
| ||
| 18:39 | Update some test cases that deal with corrupt databases. (check-in: 3a09f5605a user: dan tags: experimental) | |
| 09:48 | Minor tweak to vdbeRecordCompareInt(). (check-in: 284bde0ee2 user: dan tags: experimental) | |
|
2014-02-27
| ||
| 20:52 | Merge in latest trunk changes. (check-in: 8f30b09518 user: dan tags: experimental) | |
| 20:44 | Further changes to sqlite3VdbeRecordCompare(). (check-in: 5708937400 user: dan tags: experimental) | |
|
2014-02-25
| ||
| 21:01 | Attempt to speed up sqlite3VdbeRecordCompare() by various means. This code is in an interim state. (check-in: 85206e0bba user: dan tags: experimental) | |
|
2013-03-08
| ||
| 07:10 | If SQLITE_OMIT_UTF16 is defined, avoid setting the 'enc' field of Schema objects to any value except SQLITE_UTF8. Otherwise, assert() statements may fail or spurious SQLITE_NOMEM errors may be returned at the vdbe level later on. (Closed-Leaf check-in: 69746ef787 user: dan tags: experimental) | |
|
2013-03-05
| ||
| 15:27 | Do not attempt to set the permissions on an existing journal or wal file. Do this only immediately after creating a new file (or opening one zero bytes in size). (Closed-Leaf check-in: 1d8086902e user: dan tags: experimental) | |
| 15:09 | Add extended error code SQLITE_READONLY_ROLLBACK. Returned if a read-only connection cannot read the database because doing so would require it to roll back a hot-journal. (check-in: 39247b14a5 user: dan tags: experimental) | |
|
2011-12-16
| ||
| 13:24 | Experimental fix for [a1fa75cbdd]. (Closed-Leaf check-in: 6492af76ea user: dan tags: experimental) | |
|
2011-12-13
| ||
| 12:10 | This branch merged with nx-devkit and from there into trunk. Was: In the multiplexor, instead of generating a unique file-name when SQLite opens a temp file, allow the underlying VFS to generate a different temp file for each chunk. Given the changes to the xFileSize method, it is no longer necessary for the different chunks of a temp file to use the same base name. (Closed-Leaf check-in: 199f52bced user: dan tags: experimental) | |
| 11:15 | Change the way IO errors are handled in the xFileSize method of the multiplexor VFS. Add test file multiplex3.test. (check-in: 255d21499b user: dan tags: experimental) | |
|
2011-08-29
| ||
| 02:49 | About a 1% overall performance improvement by using a macro to avoid no-op calls to sqlite3MemReleaseExternal(). (Closed-Leaf check-in: ff71d20a9e user: drh tags: experimental) | |
| 02:16 | Small performance improvement to OP_Column. (check-in: b6b73a747a user: drh tags: experimental) | |
|
2011-08-28
| ||
| 02:15 | About a 3% improvement in the performance of OP_Column. (check-in: edff9d4a99 user: drh tags: experimental) | |
| 00:19 | Correctly display P4_ADVANCE values on opcode traces. Mark an always-taken branch in OP_Column as such. (check-in: 087dc96086 user: drh tags: experimental) | |
|
2011-08-27
| ||
| 18:48 | Experimental changes to improve the performance of OP_Next. (check-in: 1a24984525 user: dan tags: experimental) | |
|
2011-08-12
| ||
| 16:34 | Update Makefile.in and configure to account for new source file vdbesort.c. (Closed-Leaf check-in: 69e4b41de2 user: dan tags: experimental) | |
| 16:30 | Merge latest trunk changes into experimental branch. (check-in: 7e515055f2 user: dan tags: experimental) | |
| 16:11 | Remove an unused parameter from a function in vdbesort.c. Fix some comments and other details in the same file. (check-in: 1a8498d803 user: dan tags: experimental) | |
| 15:02 | Add the SQLITE_OMIT_MERGE_SORT pre-processor directive. To omit the code in vdbesort.c. (check-in: 4ced2394b1 user: dan tags: experimental) | |
| 11:59 | Add tests to improve coverage of vdbesort.c. (check-in: 87a15917d7 user: dan tags: experimental) | |
|
2011-08-08
| ||
| 19:26 | Remove redundant parameter from vdbeSorterInitMerge() in vdbesort.c. (check-in: eec8c0df07 user: dan tags: experimental) | |
| 16:44 | Add fault-injection and other tests (and fixes) to improve coverage of vdbesort.c. (check-in: 0e6defa6aa user: dan tags: experimental) | |
|
2011-08-06
| ||
| 15:09 | Fix a problem with building large indexes introduced by the previous commit. (check-in: 038ec9ea92 user: dan tags: experimental) | |
| 12:01 | In temp files used for merge sorting, store the size of each packed-memory-array at the start of the array itself. This is to avoid having to store the offsets of all arrays in the (potentially very large) file in main-memory. (check-in: 8051c1767c user: dan tags: experimental) | |
|
2011-08-05
| ||
| 11:49 | Minor internal changes to vdbesort.c. Also, default to merging lists together 16 at a time. (check-in: 9ddc324a34 user: dan tags: experimental) | |
|
2011-08-04
| ||
| 18:43 | Fix a comment in vdbesort.c. (check-in: db8518cab8 user: dan tags: experimental) | |
| 12:14 | Change to using packed-memory-arrays instead of b-trees when performing an offline merge-sort for CREATE INDEX. This makes it easier to control the number of disc seeks required when merging. (check-in: a4770d079c user: dan tags: experimental) | |
|
2011-08-02
| ||
| 10:56 | Minor fixes to vdbesort.c code in preparation for a major rework. (check-in: 7f339c0e26 user: dan tags: experimental) | |
|
2011-07-12
| ||
| 14:28 | Experimental support for speeding up CREATE INDEX commands using an offline merge sort. (check-in: 30dbf0feab user: dan tags: experimental) | |
|
2011-07-02
| ||
| 06:44 | Fix a broken assert() in where.c. (Closed-Leaf check-in: 090b29177f user: dan tags: experimental) | |
|
2011-07-01
| ||
| 18:43 | Merge latest trunk changes with experimental branch. (check-in: e56be74eab user: dan tags: experimental) | |
| 18:26 | Improve use of indexes to optimize DISTINCT queries. (check-in: 6c202ea024 user: dan tags: experimental) | |
| 14:21 | Improvements and tests for detection of redundant DISTINCT qualifiers. (check-in: 7337293c87 user: dan tags: experimental) | |
|
2011-06-30
| ||
| 20:17 | Experimental changes to improve optimization of DISTINCT queries. (check-in: f7ba0219ef user: dan tags: experimental) | |
|
2011-04-15
| ||
| 13:29 | Add retry logic to GetFileAttributesEx() on windows. (Closed-Leaf check-in: 1cca9a49f2 user: drh tags: experimental) | |
|
2010-12-20
| ||
| 15:51 | Add additional DBSTATUS options for measuring the hit and miss rates against the lookaside memory pool - information useful in tuning the lookaside size. Currently experimental pending analysis of performance impact. (Closed-Leaf check-in: 34613f1dc5 user: drh tags: experimental) | |
|
2010-11-13
| ||
| 16:42 | Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans. (Closed-Leaf check-in: 6611b76b02 user: dan tags: experimental) | |
|
2010-11-12
| ||
| 17:41 | Add EXPLAIN QUERY PLAN test cases to check that the examples in the documentation work. (check-in: 85fdad850a user: dan tags: experimental) | |
| 15:36 | Reduce the number of branches that need to be tested in the explainIndexRange() function of where.c. (check-in: 6fdae9a635 user: drh tags: experimental) | |
|
2010-11-11
| ||
| 17:48 | Use "COMPOUND" instead of "COMPOSITE" in the EXPLAIN QUERY PLAN output to describe UNION, UNION ALL, EXCEPT and INTERSECT operations. (check-in: 28643b85d9 user: dan tags: experimental) | |
| 16:46 | Add a row of EXPLAIN QUERY PLAN output for each composite select operation (UNION, EXCEPT etc.) in the query. (check-in: 00fb8468b5 user: dan tags: experimental) | |
| 11:43 | Fix a bug in the EXPLAIN QUERY PLAN code. (check-in: 7ae068952f user: dan tags: experimental) | |
| 10:36 | Modifications to test cases to account for new EXPLAIN QUERY PLAN output. (check-in: 30904ef841 user: dan tags: experimental) | |
|
2010-11-09
| ||
| 17:49 | Merge with latest trunk changes. (check-in: 4b5c93bc7c user: dan tags: experimental) | |
| 17:35 | Add missing comments and fix other issues with routines used by new EQP features. (check-in: 925f35c535 user: dan tags: experimental) | |
| 14:49 | Further enhancements and fixes for explain query plan. (check-in: 73c93f5a2a user: dan tags: experimental) | |
|
2010-11-08
| ||
| 19:01 | Experimental changes to EXPLAIN QUERY PLAN. (check-in: f4747eb83d user: dan tags: experimental) | |
|
2010-11-05
| ||
| 00:00 | Fix the Makefile.in so that it works with the multiplexer VFS. (Closed-Leaf check-in: 54e2efb667 user: drh tags: experimental) | |
|
2010-11-04
| ||
| 21:14 | Back out an unintended change to permutations.test. (check-in: 57fe35357d user: drh tags: experimental) | |
| 21:13 | Another change for testing on Windows. (check-in: 2625886b19 user: shaneh tags: experimental) | |
| 21:03 | Fix the main.mk makefile to include test_multiplex.c for testfixture. (check-in: c27c51180e user: drh tags: experimental) | |
| 20:50 | First attempt at a sharding VFS to split large DBs. (check-in: dd4dc8a426 user: shaneh tags: experimental) | |
| 20:47 | Fix icon size so it's really 32x32. (check-in: 62c494f694 user: shaneh tags: experimental) | |
| 20:46 | Updates for Windows. (check-in: cc9d9a12c3 user: shaneh tags: experimental) | |
|
2010-10-27
| ||
| 16:52 | Fix a buffer overread in fts3 that can occur if the database is corrupt. (Closed-Leaf check-in: 84194c4195 user: dan tags: experimental) | |
| 10:55 | In fts4, store the total number of bytes of for all records in the table in the %_stat table. (check-in: 941647d121 user: dan tags: experimental) | |
|
2010-10-26
| ||
| 18:42 | Structural coverage tests for vdbeblob.c. Including experimental new API sqlite3_blob_reopen(). (check-in: 97c6b2616d user: dan tags: experimental) | |
| 11:56 | Add missing header comments for changes related to the experimental sqlite3_blob_reopen() API. (check-in: d1cc5c93f0 user: dan tags: experimental) | |
| 07:14 | More coverage tests for fts3.c. (check-in: 7a2f286400 user: dan tags: experimental) | |
|
2010-10-25
| ||
| 19:01 | Further improvements to coverage of fts3.c. Fixes for bugs revealed by the same. (check-in: 918b609290 user: dan tags: experimental) | |
| 12:47 | Test coverage improvements for fts3.c. (check-in: a8b1d99899 user: dan tags: experimental) | |
| 09:01 | Add test for matchinfo when a phrase includes some common tokens. (check-in: 80a54ebc41 user: dan tags: experimental) | |
|
2010-10-23
| ||
| 19:07 | Fixes for the matchinfo() function related to FTS4 common token handling. (check-in: deb80eac91 user: dan tags: experimental) | |
|
2010-10-22
| ||
| 19:03 | Add new test file fts3defer2.test. (check-in: 5a4d5bfcae user: dan tags: experimental) | |
| 16:44 | Add missing comments and fix compiler warnings in new FTS3/4 code. Other minor fixes too. (check-in: 1c9c70fec3 user: dan tags: experimental) | |
|
2010-10-21
| ||
| 15:49 | Merge trunk changes into experimental branch. (check-in: fd1e5cade0 user: dan tags: experimental) | |
|
2010-10-20
| ||
| 18:56 | Updates to FTS4 to improve performance and make more accurate cost estimates for prefix terms. (check-in: d0a450ce78 user: dan tags: experimental) | |
|
2010-10-19
| ||
| 14:08 | Experimental changes to fts4 to try to selectively avoid loading very large doclists. (check-in: 5ae0ba447a user: dan tags: experimental) | |
|
2010-09-30
| ||
| 20:11 | Fix some matching issues in enc4.test affected by TCL versions. (Closed-Leaf check-in: dd6d61a967 user: shaneh tags: experimental) | |
| 18:30 | Fix memory leak in enc4.test script. (check-in: bfc294ae43 user: shaneh tags: experimental) | |
| 18:19 | Additional encoding tests. (check-in: c7f9363617 user: shaneh tags: experimental) | |
| 18:12 | Remove unnecessary calls to memAboutToChange() in vdbe.c. An affinity change no longer invalidates shallow copies. (check-in: afb0fd0b04 user: drh tags: experimental) | |
| 17:33 | Do correct affinity transformations on floating point values which have a decimal point at the beginning or end of the mantissa. Ticket [3998683a16a7076e08f5]. (check-in: ca154f97a5 user: drh tags: experimental) | |
| 16:51 | Changes to remove sqlite3FitsIn64Bits(). (check-in: 43fef1cab6 user: shaneh tags: experimental) | |
| 14:48 | Fix the handling of default values for ALTER TABLE ADD COLUMN columns so that is able to deal with negative numbers, including large negative numbers. Ticket [8454a207b9fd2243c4] (check-in: ce6cc16e3a user: drh tags: experimental) | |
| 00:50 | Rework the text to numeric conversion routines so that they work with either UTF8 or UTF16 and do not require a NULL terminator. This allowed text to numeric conversion without reallocating the string. (check-in: 14eed3a0e0 user: drh tags: experimental) | |
|
2010-09-24
| ||
| 09:32 | Add experimental branch disallowing VACUUM when there are one or more active SQL statements. (check-in: c1ebcacd9b user: dan tags: experimental) | |
|
2010-09-01
| ||
| 15:11 | Fix the TCL interface to test_quota.c so that it works with empty callback scripts. (Closed-Leaf check-in: 19e95f6335 user: drh tags: experimental) | |
| 14:58 | Variable name and comment changes to test_quota.c for clearer presentation. (check-in: 38ed1992c8 user: drh tags: experimental) | |
| 14:45 | Make all private routines in test_quota.c begin with "quota". Fix a test_quota.c segfault when setting a zero-quota. (check-in: c0d0fc3a1c user: drh tags: experimental) | |
| 14:35 | Add the sqlite3_quota_dump test command. Add a destructor argument on the sqlite3_quota_set() interface. (check-in: 7a624b5ae2 user: drh tags: experimental) | |
| 13:09 | Clean up comments in the test_quota.c source file. (check-in: c1eec7dba6 user: drh tags: experimental) | |
| 12:50 | Update the quota shim so that when the same file is opened multiple times, its size only counts against the quota once. (check-in: f5d2638030 user: drh tags: experimental) | |
| 11:40 | Add file test_quota.c, demonstrating how file-system quotas may be implemented as a VFS wrapper. (check-in: 383eb87bbf user: dan tags: experimental) | |
|
2010-08-10
| ||
| 15:46 | Fix a bug in pager.c causing it to omit the xSync() call required following a hot-journal rollback. (Closed-Leaf check-in: 42ba43ac69 user: dan tags: experimental) | |
| 09:58 | Add variable pager.dbHintSize, used to limit the number of calls made to the xFileControl(FCNTL_SIZE_HINT) method. (check-in: eb3ac895bd user: dan tags: experimental) | |