SQLite
Timeline
Not logged in

100 check-ins occurring around c0d89d4a97.

2012-09-24
19:50
Remove an unused subfunction parameter and an obsolete comment from the query planner logic in where.c. check-in: 349a55cd user: drh tags: trunk
15:30
Change the internal sqlite3WhereBegin() to report that the ORDER BY clause is satisfied by indices using the WhereInfo.nOBSat field of the returned structure. check-in: 22989f35 user: drh tags: trunk
11:43
Update documentation to describe the threadsafety of sqlite3_enable_shared_cache(). check-in: e081890c user: drh tags: trunk
2012-09-21
22:50
Enable query planner tracing using the new (and undocumented) ".wheretrace 1" command in the command-line shell if both the shell and the core are compiled with SQLITE_DEBUG and SQLITE_ENABLE_WHERETRACE. This is not a supported API. Use for testing and debugging only. check-in: 1be4b16b user: drh tags: trunk
13:40
Command-line shell enhancements: Added the ".print" command. Enhanced the ".width" command so that negative widths will right-justify. check-in: a1d8269d user: drh tags: trunk
00:04
Consolidate more of the DISTINCT processing logic into a single spot in the code. Reduce the number of OP_Column operations needed to perform a WHERE_DISTINCT_ORDERED. check-in: 79e922f7 user: drh tags: trunk
2012-09-20
15:41
Continuing incremental enhancements of SELECT code generation: Remove the Select.affinity field. Use SelectDest.affSdst instead. check-in: cf40b7b5 user: drh tags: trunk
14:26
Refactoring of DISTINCT code. Change the name of the local variable "distinct" to "distinctTab". Generate cleaner code w/o unnecessary P4 and P5 values on the OP_Null for WHERE_DISTINCT_ORDERED. check-in: 0cda241a user: drh tags: trunk
2012-09-19
21:15
Tighter VDBE code for the WHERE_DISTINCT_ORDERED case of DISTINCT keyword handling. check-in: 94b48064 user: drh tags: trunk
17:31
Add comments to the WHERE_DISTINCT_* macros. No changes to code. check-in: 82320501 user: drh tags: trunk
00:35
Merge the covering-index-scan optimization into trunk. check-in: ddd5d789 user: drh tags: trunk
2012-09-18
23:21
Silence harmless compiler warning seen with SQLITE_OMIT_DEPRECATED. check-in: c5cee969 user: mistachkin tags: trunk
19:29
Enhance IN processing to allow efficient use of indices with numeric affinities. Add test cases for IN processing that would have spotted the error in the [2be661a48023f4] check-in. check-in: 5ded9b68 user: drh tags: trunk
17:32
This change generates incorrect code when there are two or more IN operators in the WHERE clause that are both used by the same index. Was: Omit an unnecessary OP_IfNull that immediately follows an OP_Rowid. Closed-Leaf check-in: 2be661a4 user: drh tags: mistake
17:08
Enhancements to the comments on sqlite3FindInIndex(). No code changes. check-in: b1a4c394 user: drh tags: trunk
14:00
Add the stack_usage.tcl script for analyzing the output of objdump on the amalgamation and estimating the sizes of stack frames on each function. check-in: 030013ff user: drh tags: trunk
13:20
Update the vdbe-compress.tcl script so that it accepts variable declarations inside of #ifdef...#endif. This enhancement is needed due to the change of check-in [39866c0ede5d6ef4]. check-in: e7db056a user: drh tags: trunk
2012-09-17
21:24
Make sure the WHERE_IDX_ONLY flag is not set on query plans that will not be using an index. Closed-Leaf check-in: 698b2a28 user: drh tags: fullscan-covering-index
20:44
Add the ability to disable the covering-index-scan optimization at compile-time, start-time, or at run-time. Add test cases to check this configurability. check-in: ccb8ecc3 user: drh tags: fullscan-covering-index
19:26
Merge recent trunk changes into the fullscan-covering-index branch. check-in: 1c0bf030 user: drh tags: fullscan-covering-index
19:12
Remove obsolete bits from the bitvector that defines disabled optimizations in the SQLITE_TESTCTRL_OPTIMIZATIONS verb of sqlite3_test_control(). check-in: 4c21ee2d user: drh tags: trunk
18:56
Remove an unnecessary parameter from sqlite3Utf8Read() resulting in a slight performance increase. check-in: 8b962c94 user: drh tags: trunk
17:16
Make sure the KeyInfo.aSortOrder array is always allocated so that we never have to test for KeyInfo.aSortOrder==0 in performance-critical loops. check-in: 45793f0b user: drh tags: trunk
15:36
Performance enhancement in the sqlite3VdbeSerialType() routine. check-in: ad298f52 user: drh tags: trunk
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
00:49
Backport check-in [62678be3df35cd]: When the same index is used for all OR-terms in a WHERE clause, then try to use that index as a covering index. Leaf check-in: 865dfcba user: drh tags: branch-3.7.2
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