/ Timeline
Login

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

100 descendants of [e1e9cb08]

2012-09-15
18:45
Attempt to use a covering index even on a full table scan, under the theory that the index will be smaller and require less disk I/O and thus be faster. check-in: cfaa7bc1 user: drh tags: fullscan-covering-index
13:39
Make sure the name of rollback journal files are double-zero terminated when they are passed into the VFS. check-in: 8711a844 user: drh tags: trunk
13:29
Factor out the code that generates a co-routine for evaluating the SELECT on the RHS of an INSERT statement so that the same code can potentially be reused in other places. check-in: a93ee09c user: drh tags: trunk
2012-09-13
19:59
Improved alignment of fields in the Expr object gives an 8-byte size reduction on 64-bit machines. check-in: 6b252a0d user: drh tags: trunk
16:12
Fix WAL capability checking in one of the test files. check-in: 0ebe7cc5 user: mistachkin tags: trunk
15:26
Fix an unused variable warning with SQLITE_OMIT_WAL. check-in: 39866c0e user: mistachkin tags: trunk
15:24
Improved reporting of filename translation errors in the Windows VFS. check-in: eb0f1c29 user: mistachkin tags: trunk
14:42
Reduce the size of the Table object by 16 bytes on 64-bit machines, mostly by avoiding intermixing pointer fields with integer fields. check-in: 1cb9aedf user: drh tags: trunk
14:22
Change boolean fields in the Column object from unsigned characters into bits in a single bit mask variable. check-in: 4163f5f1 user: drh tags: trunk
12:10
Add the RTREE_INT_ONLY configuration parameter to the compile-time options logic. check-in: 98b971fb user: drh tags: trunk
01:51
Allow SQLite to work on Win32 with SQLITE_OS_WINNT=0 as long as WAL is disabled. check-in: c1a85570 user: mistachkin tags: trunk
2012-09-12
18:45
Add an implementation of the REGEXP operator and function. Only defined if compiled with SQLITE_ENABLE_REGEXP. Closed-Leaf check-in: 8398f77c user: drh tags: regexp
00:11
Update version number to 3.7.15. Delete some obsolete build scripts. check-in: 9402f81f user: drh tags: trunk
2012-09-11
02:00
Added sqlite3_errstr API to translate a result code to the corresponding error message. check-in: bf8a9ca5 user: mistachkin tags: trunk
2012-09-10
23:44
Correct two duplicated test names. check-in: ced49974 user: mistachkin tags: trunk
15:02
Remove the stale implementation of the ifnull and coalesce functions - code that has been commented out for ages. No functional changes. check-in: c2ad6911 user: drh tags: trunk
10:29
Initial prototype of SQLITE_CONFIG_READONLY. check-in: 7c340165 user: mistachkin tags: configReadOnly
09:33
Avoid using the sqlite3ErrStr function in the Tcl package if USE_SYSTEM_SQLITE is defined. check-in: a716b9a3 user: mistachkin tags: trunk
08:48
Make header comments for some Tcl test commands more consistent. No changes to code. check-in: af870ca9 user: mistachkin tags: trunk
07:56
More test cleanup. Closed-Leaf check-in: b8d5359b user: mistachkin tags: testClean
07:29
Refine error messages in the sqlite3 Tcl command when a NULL database connection is returned from sqlite3_open_v2. check-in: f260d7d5 user: mistachkin tags: trunk
06:02
Fix typo in documentation for sqlite3_open_v2. No changes to code. check-in: b532120a user: mistachkin tags: trunk
2012-09-07
20:10
Correct two test names to make them unique. Closed-Leaf check-in: 43e474d3 user: mistachkin tags: busy-timeout-pragma
18:49
Have PRAGMA busy_timeout return 0 if the busy handler has been changed or cancelled. check-in: 7be5bc36 user: drh tags: busy-timeout-pragma
16:46
Add an experimental busy_timeout pragma to facilitate access to the sqlite3_busy_timeout() interfaces for programmers that are working from behind a language wrapper that does not expose that interface. check-in: 22ebc668 user: drh tags: busy-timeout-pragma
2012-09-04
21:34
Avoid repeating calls to the sqlite3_trace() callback when the same statement is evaluted multiple times by sqlite3_step() due to an SQLITE_SCHEMA reprepare. check-in: 39f763bf user: drh tags: trunk
2012-09-03
15:42
Version 3.7.14 check-in: c0d89d4a user: drh tags: trunk, release, version-3.7.14
12:40
Fix compiler warnings in test_spellfix1.c check-in: ebb08d0b user: drh tags: trunk
11:39
Add resources describing the version number and other information to EXEs and DLLs generated using MSVC. check-in: a15a7084 user: drh tags: trunk
11:14
Insert additional tab character. Closed-Leaf check-in: 3af7c1a6 user: mistachkin tags: win32Resources
11:01
Linking and cleaning fixes for the tclsqlite3.exe target in the MSVC makefile. check-in: 96d43c7a user: mistachkin tags: win32Resources
10:32
Add Win32 version resources to the applicable binaries built by the MSVC makefile. check-in: e2f27d28 user: mistachkin tags: win32Resources
2012-08-31
14:55
In the spellfix phonehash() function, add letter W into the same character class as V. check-in: 75361013 user: drh tags: trunk
14:23
Update with latest trunk changes. check-in: 87995dc9 user: dan tags: sessions
14:10
Merge in latest trunk changes. check-in: bc9b9cd0 user: dan tags: apple-osx
12:31
Changes for ERROR_PATH_NOT_FOUND in addition to ERROR_FILE_NOT_FOUND in winAccess(). check-in: 527340ab user: drh tags: trunk
2012-08-30
20:24
Exclude the atof1.test test script from the valgrind permutations test since valgrind sets up the floating point hardware in an unusual way that makes atof1 fail. check-in: d3cf6832 user: drh tags: trunk
11:22
Fix an out-of-bounds read in the demonstration code in test_spellfix.c. check-in: 59194311 user: dan tags: trunk
2012-08-29
10:28
Fix a typo in a comment in vdbe.c. No changes to code. check-in: 9fbe858b user: drh tags: trunk
2012-08-28
14:45
Fix a case where SQLite was failing to detect a syntax error in queries like "SELECT ... FROM (<select-1> UNION ALL <select-2>)" when <select-1> and <select-2> return different numbers of result columns. check-in: 200a8135 user: dan tags: trunk
04:20
Issue a log message if the temporary directory has not been set when running on WinRT. check-in: 9ee39102 user: mistachkin tags: trunk
01:44
Enable the use of a simpler command line when cross-compiling in the MSVC build environment. check-in: 8ade136a user: mistachkin tags: trunk
00:17
Formatting changes to the C code example in the documentation for sqlite3_temp_directory(). No changes to code. check-in: 5b4b3978 user: drh tags: trunk
00:09
Update API docs to include notes about the WinRT temporary directory. No changes to code. check-in: eaeeb069 user: mistachkin tags: trunk
2012-08-27
21:19
Add to #undef statements to the command-line shell, go make sure that the macros definitions that follow do not collide with system definitions. check-in: 24420d6d user: drh tags: trunk
14:39
Fix an incorrect assert in the virtual table logic - it could fire following an I/O error after sqlite3_close_v2() was added. check-in: 4ccc18e9 user: drh tags: trunk
2012-08-25
10:01
Fix all known instances of 'repeated the' style typos in comments. No changes to code. check-in: 9b19b847 user: mistachkin tags: trunk
02:11
Fix a harmless compiler warning. check-in: 929b5184 user: drh tags: trunk
01:38
Merge all the latest trunk changes into the apple-osx branch. check-in: 6723add4 user: drh tags: apple-osx
01:21
Merge the latest trunk changes into the sessions branch. check-in: aa62d688 user: drh tags: sessions
2012-08-24
23:56
When the same index is used for all OR-terms in a WHERE clause, then try to use that index as a covering index. check-in: 62678be3 user: drh tags: trunk
23:24
Move field WhereLevel.pCovidx inside the union to WhereLevel.u.pCovidx. Closed-Leaf check-in: b722143d user: drh tags: multi-or-covering-index
21:54
Remove a NEVER() that is in fact reachable on an OOM. This probably has nothing to do with the multi-or-covering-index change but just happened to be found while testing that change. check-in: 5499af53 user: drh tags: multi-or-covering-index
19:58
Another test for whereD.test. check-in: 29d58617 user: dan tags: multi-or-covering-index
19:52
Add extra tests to whereD.test. check-in: 7e961eef user: dan tags: multi-or-covering-index
18:44
Fix a problem to do with multi-or queries and automatic indexes. check-in: a3e26038 user: dan tags: multi-or-covering-index
17:52
More test cases for OR-optimization covering indices. check-in: e5c3190c user: drh tags: multi-or-covering-index
15:29
Additional test cases for OR-optimization with covering indices, including one test case that currently fails. check-in: d8b7ab37 user: drh tags: multi-or-covering-index
10:52
Experimental change to support the covering index optimization for queries with OR terms in the WHERE clause that search a single index more than once. check-in: 1dc8c7c7 user: dan tags: multi-or-covering-index
01:07
Merge the nested aggregate query enhancements into trunk. check-in: d4cd6017 user: drh tags: trunk
2012-08-23
22:45
Merge changes for the new sqlite3_win32_set_directory API to trunk. check-in: 20f184f2 user: mistachkin tags: trunk
19:46
Add test cases and fix bugs associated with the previous check-in enhancements to nested aggregate subquery processing. Closed-Leaf check-in: 00b1dc71 user: drh tags: nested-agg
16:18
Further improvements to the processing of nested aggregate queries. check-in: 3c3ffa90 user: drh tags: nested-agg
2012-08-22
15:16
Do not let the multi-core sorter use lookaside memory, which is not thread-safe. Leaf check-in: acdc7d12 user: drh tags: threads-sort-ex1
00:39
Modify the MSVC makefile to make it easier to select the heap subsystem to use. check-in: b1dbf490 user: mistachkin tags: trunk
00:18
Add assert to check that the memory block for the previous directory value was allocated via sqlite3_malloc or related function. Closed-Leaf check-in: 1246f15b user: mistachkin tags: win32SetDir
2012-08-21
23:33
Added sqlite3_win32_set_directory API to assist in portability to WinRT. check-in: 600de08d user: mistachkin tags: win32SetDir
17:46
Merge in all the latest trunk changes. check-in: 45cdc32f user: drh tags: threads-sort-ex1
17:44
Update the spellfix virtual table so that all OOM errors are reported out to the application. check-in: 573770f5 user: drh tags: trunk
17:36
Cherry-pick [555fc07]: Changes to the thread routines to disable them when threading is turned off using sqlite3_config(). Also merge all recent trunk changes. check-in: c92b0fe1 user: drh tags: threads
13:08
Update the spellfix virtual table so that all OOM errors are reported out to the application. ERROR: A single edit was missed in spellfix1 which means that this particular check-in won't build "make test". Closed-Leaf check-in: c2cf4985 user: drh tags: mistake
2012-08-20
17:24
Add the SQLITE_DISABLE_FTS4_DEFERRED compile time option. check-in: e799222f user: dan tags: trunk
16:23
Change the checkSpacing utility program to ignore whitespace at end-of-line unless the --wseol option is used. check-in: be1faade user: drh tags: trunk
16:08
Silence harmless compiler warnings in the test code. check-in: 7653973a user: drh tags: trunk
15:53
Remove tab characters from source code files. Replace them with spaces. check-in: 7edd10a9 user: drh tags: trunk
15:46
Add a command-line program to tool/ that will check source code files for the presence of tabs, carriage-returns, whitespace at the ends of lines, and blank lines at the ends of files. check-in: 656a9c8b user: drh tags: trunk
12:36
Changes to the thread routines to disable them when threading is turned off using sqlite3_config(). check-in: 555fc07e user: drh tags: threads-sort-ex1
2012-08-17
13:44
Clarify that the number-of-bytes parameter to sqlite3_bind_blob() must be non-negative. check-in: b1b01c4c user: drh tags: trunk
12:13
Fix MSVC compiler warning in the spellfix module. Also, add an assert. check-in: e66cf040 user: mistachkin tags: trunk
11:47
Skip defining some WAL specific things in the Win32 VFS code when compiling without WAL support. Also, fix an example command line in the MSVC makefile. check-in: 61b1ae12 user: mistachkin tags: trunk
2012-08-16
20:05
Attempt to use two cores to do sorting. Unfortunately, instead of making sorts go faster as was hoped, this changes slows sorting down by about 10%. (Later:) The previous measurement was compiled using -pg. When compiled using -Os, this new code is roughly 10% faster than the original. check-in: 11dd05e5 user: drh tags: threads-sort-ex1
11:24
Update the threads branch to include all the latest trunk changes. check-in: f4125771 user: drh tags: threads
2012-08-15
16:43
Changes to the spellfix test script to make the results deterministic. check-in: 31c07db2 user: drh tags: trunk
16:21
Merge all the latest trunk changes into the sessions branch. check-in: fc07a479 user: drh tags: sessions
16:06
Change autoconf so that the --with-tcl=DIR option will override the TCL configuration that is found using tclsh. check-in: 772d0de3 user: drh tags: trunk
15:57
Experimental change to speed up ORDER BY clauses that sort based on a single expression. Leaf check-in: 2bb8c492 user: dan tags: sorter-exp
2012-08-14
19:04
Silence three harmless compiler warnings in vdbesort.c. check-in: a5431c86 user: drh tags: trunk
18:43
Add an assert() to the btree rebalancer in order to silence a clang/scan-build warning. check-in: 6730579c user: drh tags: trunk
17:29
Update the spellfix virtual table to the latest development code. check-in: 6954fef0 user: drh tags: trunk
01:45
Refer to the file mapping Win32 API functions only when absolutely necessary. check-in: 1de2237d user: mistachkin tags: trunk
2012-08-13
22:05
Refer to the WaitForSingleObjectEx and SetFilePointerEx Win32 functions only for platforms where they are going to be used. check-in: 9888ce92 user: mistachkin tags: trunk
2012-08-08
14:04
When populating an index b-tree as part of a CREATE INDEX or REINDEX statement, distribute cells between up to three siblings in balance_nonroot() instead of four. This produces identical database files, but is slightly faster. check-in: b0d31e77 user: dan tags: trunk
11:55
When building a b-tree as part of a CREATE INDEX or REINDEX statement, attempt to pack keys into pages as tightly as possible. check-in: efea62b9 user: dan tags: trunk
10:14
Change to securedel2.test so that it works even if SQLITE_DEFAULT_AUTOVACUUM=1 is defined. check-in: 1e6f5ea4 user: dan tags: trunk
2012-08-07
22:53
Simplifications to the sorter to support full-coverage testing. check-in: de804f4c user: drh tags: trunk
17:41
Add extra tests for secure-delete mode. check-in: e380cd3c user: dan tags: trunk
15:19
Fix a bug in hash.c introduced by [305b66672653]. check-in: 17cb5e95 user: dan tags: trunk
14:18
Do not run test script spellfix.test if SQLITE_OMIT_VIRTUAL_TABLE is defined. Fix walro.test so that it works if DEFAULT_AUTOVACUUM is defined. check-in: 26428b45 user: dan tags: trunk
13:55
Fix a bug in walthread.test causing intermittent failures. check-in: a192a718 user: dan tags: trunk
2012-08-06
22:29
Modify VSIX package generation tool to put the PDB files in the Debug directory. check-in: 9d072083 user: mistachkin tags: trunk
19:28
Merge the sorter-coalesce-writes branch into the trunk. This improves CREATE INDEX performance on some platforms. check-in: e1e9cb08 user: dan tags: trunk