/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

2014-10-11
02:12
Make sure that a GROUP BY that also implements an ORDER BY scans the table in the correct order. Fix for ticket [ba7cbfaedc7e6]. check-in: 7a32fdfd4b user: drh tags: trunk
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
19:15
Restrict the scope of the explainIndexRange() function in where.c. check-in: c301245200 user: drh tags: trunk
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-28
19:38
Improved WHERETRACE messages for the estimated output row reductions from range scans. check-in: fdd478bb11 user: drh tags: trunk
2014-08-22
15:19
Improve the performance and reduce the size of the sqlite3VdbeSerialGet() routine by avoiding the use of stack. check-in: ebc10e46c1 user: drh tags: trunk
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
13:22
Change a while-loop into a do-loop in sqlite3VdbeSerialPut() for a small size reduction and performance improvement. check-in: 750bb0a096 user: drh tags: trunk
2014-03-03
21:59
Refactor the sqlite3VdbeRecordCompare() routine used to compare btree records. Create a couple of fast-track routines to handle the common cases of a string with BINARY collation or integer values as the left-most column. This gives a significant performance boost in common use. Oops: This build does not work on the Beaglebone where "char" defaults to unsigned. check-in: aec5473a75 user: drh tags: broken-on-arm
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
17:36
Change an OP_SCopy into an OP_Copy in a case where the destination might be used after the source has changed. check-in: c0fa0c0e2d user: drh tags: trunk
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
14:20
Fix a segfault that can occur following an OOM error. check-in: 7fdd378d54 user: dan tags: trunk
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
20:47
In the command-line shell add the (undocumented and unsupported) ".eqp" command and -eqp command-line option, to cause EXPLAIN QUERY PLAN to be run on each SQL statement as it is evaluated. Intended use is for analysis of the query planner. check-in: e6ecf73376 user: drh tags: trunk
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
15:11
A better way of handling the USE_SYSTEM_SQLITE #define in shell.c. check-in: 51ce713c6e user: drh tags: trunk
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
18:12
Also adjust the order of files in the amalgamation to ensure that _FILE_OFFSET_BITS is defined before any #include, for QNX. check-in: 23001a85cd user: drh tags: trunk
2013-03-08
18:16
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. check-in: f2fecfb2d3 user: dan tags: trunk
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-07
09:39
Skip tests that require UTF-16 support when compiled with SQLITE_OMIT_UTF16. check-in: e39391422e user: mistachkin tags: trunk
2013-03-05
16:54
Failed merge experimental branch with trunk. check-in: 4e6e07a60e user: dan tags: ex-robust-open
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
11:27
Fix a bug in the recent incremental-vacuum related changes. check-in: 717863fca6 user: dan tags: trunk
2011-12-16
15:38
Merge the fix for [a1fa75cbdd02] from the experimental branch. Also fix the persistent-wal mode feature of truncating the WAL on close so that it always truncates the WAL to zero bytes. check-in: 09ccc4a1be user: drh tags: trunk
13:24
Experimental fix for [a1fa75cbdd]. Closed-Leaf check-in: 6492af76ea user: dan tags: experimental
2011-12-15
17:44
Add stdio support to the quota VFS. check-in: 322bd15f97 user: drh tags: trunk
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-12-12
19:48
Fix os_unix.c so that, unless 8.3 filenames are actually in use, journal and wal file permissions are assigned correctly even if SQLITE_ENABLE_8_3_NAMES is defined. check-in: 169e12295c user: dan tags: trunk
2011-08-29
03:08
Merge performance enhancements into trunk. check-in: 5a00d24b27 user: drh tags: trunk
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-26
20:55
Fix several harmless compiler warnings and a documentation bug. check-in: 5454d0fe22 user: drh tags: trunk
2011-08-12
16:47
Merge the experimental changes to use a merge-sort when creating an index into the trunk. check-in: 346a453d1f user: dan tags: trunk