/ Timeline
Login

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

100 check-ins occurring around 4f1061230e0e5a66.

2012-12-06
01:03
Remove obsolete comments from the definition of the CollSeq object. check-in: 7b695101 user: drh tags: trunk
00:16
Stop using the TCL_LIBS configuration variable when linking with Tcl. Remove superfluous 'rm' command. Closed-Leaf check-in: e1feab98 user: mistachkin tags: noTclLibs
2012-12-05
19:04
Disable a couple of tests in where.test when running the "no_optimization" permutation. check-in: 5e961e37 user: dan tags: trunk
16:44
Modify a query in test/thread001.test to ensure that results are returned in the order expected by the test. check-in: 51cbddd5 user: dan tags: trunk
14:37
Fixes to a test case in shared_err.test. The fix is to prevent sqlite3_prepare() from being called when the test intends to test the response of sqlite3_step() to an OOM condition. check-in: 40c14395 user: dan tags: trunk
14:31
Make sure memory is freed using a routine that is compatible with the routine used to allocate the memory. The SQLITE_MEMDEBUG compile-time option enforces this. check-in: 9f6c6885 user: drh tags: trunk
11:30
Since errors are ignored anyway, use sqlite3OsFileControlHint() instead of OsFileControl() to invoke the SQLITE_FCNTL_BUSY_HANDLER file-control. check-in: bdceca27 user: dan tags: trunk
10:01
If the atomic-write property is enabled, a transaction may be committed in journal_mode=DELETE mode without ever actually creating a journal file on disk. In this case, do not attempt to unlink() the journal file when committing the transaction. check-in: 11aa47b0 user: dan tags: trunk
09:12
Update a couple of test scripts so that they work in auto-vacuum mode. check-in: 04ab2dc6 user: dan tags: trunk
2012-12-04
11:03
Fix a harmless compiler warning. check-in: 12693deb user: drh tags: trunk
05:24
Add a test to ensure that the fix in [b0c1ba655d] has worked. check-in: 41806de5 user: dan tags: trunk
05:21
Add a test to ensure that the fix in [b0c1ba655d] has worked. Closed-Leaf check-in: 59c23394 user: dan tags: mistake
00:59
Improvements to the 'tcl' shell output mode. Escape doublequotes, set separator to space when mode is set, and skip separator after final column. check-in: 487ba753 user: drh tags: trunk
00:53
Fix an uninitialized variable detected by valgrind. check-in: ffd1e514 user: drh tags: trunk
00:37
Fix an out-of-order function declaration when compiled with MEMDEBUG. check-in: 6d315578 user: mistachkin tags: trunk
00:23
Improvements to the 'tcl' shell output mode. Escape double quotes, set separator to space when mode is set, and skip separator after final column. Closed-Leaf check-in: 41fd9dd2 user: mistachkin tags: tclMode
2012-12-03
19:42
Remove an unreachable condition. Replace it with an assert(). check-in: 7d5fc1a3 user: drh tags: trunk
17:04
Make sure that the optimization that set the maximum column that will be used on a particular query does not mistakenly change an opcode other than OP_OpenRead or OP_OpenWrite. In particular, make sure it does not overwrite the P4 field of an OP_SorterOpen. check-in: b0c1ba65 user: drh tags: trunk
2012-12-01
20:21
Do not exit the command-line shell if a ".read" command invokes a script that contains two errors. But reported on the mailing list. check-in: 2e5e6515 user: drh tags: trunk
2012-11-29
14:26
Mark the "async" module as deprecated as its functionality has been superceded by WAL mode. This closes ticket [f46ca03b55ae0e] check-in: 3d548db7 user: drh tags: trunk
2012-11-27
21:56
Update the sessions branch to include the SQLLOG enhancement, the SQLITE_IOERR_DELETE_NOENT fix, and a fix for the number-of-documents bug in FTS4. check-in: ba8d08b6 user: drh tags: sessions
21:22
Add the SQLLOG capability to trunk. check-in: f0843f88 user: drh tags: trunk
21:12
Improved detection of file-does-not-exist in winDelete. check-in: 92e9b5bc user: drh tags: trunk
16:39
Get SQLLOG working on windows. Fix a couple of compiler warnings. Closed-Leaf check-in: b3809c93 user: drh tags: sqllog
15:56
Fix a problem causing the "number-of-documents" field maintained by FTS4 to be set incorrectly by REPLACE queries. check-in: e38fb02d user: dan tags: trunk
10:56
Fix problems in test_sqllog.c. Clarify the experimental SQLITE_CONFIG_SQLLOG interface. Handle at least the more likely error conditions in test_sqllog.c. check-in: 429c5b20 user: dan tags: sqllog
2012-11-26
19:50
Add an option to register global hooks used for logging all SQL executed by an application. check-in: cd501bbc user: dan tags: sqllog
2012-11-21
02:10
In winDelete, determine that a file does not exist by checking for a last error of ERROR_FILE_NOT_FOUND or ERROR_PATH_NOT_FOUND. Closed-Leaf check-in: 692ad3c0 user: mistachkin tags: winNotFound
2012-11-20
15:06
Have the windows implementation of xDelete return SQLITE_IOERR_DELETE_NOENT if the file to be deleted does not exist. The unix implementation was previously modified to behave this way. The current changes simply brings the two implementations into alignment. check-in: d4c36d49 user: drh tags: trunk
2012-11-13
11:16
Strive to use posix_fallocate() rather than ftruncate() when posix_fallocate() is available. Ticket [5eaa61ea18]. check-in: 29980b08 user: drh tags: trunk
11:08
Use preprocessor macros to automatically detect whether or not posix_allocate() is available. (It is generally available on Linux but not on Mac.) Ticket [5eaa61ea1881040b17449ca043b6f8fd9ca55dc3] Closed-Leaf check-in: 597333f1 user: drh tags: tkt-5eaa61ea18
10:54
When available, use posix_fallocate() rather than ftruncate() to allocate space for mmap()ed -shm files, since posix_fallocate() gives an error if no disk space is available whereas ftruncate() is silent and leaves the system vulnerable to a SIGBUS upon first write to the mmap()ed region. Ticket [5eaa61ea1881040b17449ca043b6f8fd9ca55dc3] check-in: 35625961 user: drh tags: tkt-5eaa61ea18
2012-11-10
01:27
Merge the latest changes from trunk: chiefly the outer/inner loop query optimizer scoring enhancement and the INSTR() function. check-in: 2993ca20 user: drh tags: sessions
2012-11-09
21:40
Only log unlink() errors if the error is something other than SQLITE_IOERR_DELETE_NOENT. The error is still reported up the stack, it is simply not added to the sqlite3_log(). check-in: 5a3b07f0 user: drh tags: trunk
20:17
Change os_unix.c to propagate ENOENT errors back to sqlite as SQLITE_IOERR_DELETE_NOENT. Have SQLite ignore these where they are benign and propagate them back to the caller where they may indicate a file-system malfunction of some description. check-in: bed9c172 user: dan tags: trunk
18:32
Take into account the cost of inner loops when selecting which table of a join to use for the next outer loop. check-in: 3f87f459 user: drh tags: trunk
18:22
Disable the table selection rule that tried to prevent full table scans from migrating to the outer loop unless they were optimal. The new scaling of outer-loop costs by cost of inner loops obviates the need for that step. And, in fact, that step causes problems with the new inner-loop cost accounting. Closed-Leaf check-in: 51bfd63b user: drh tags: inner-loop-cost
17:59
Try to take into account the cost of inner loops when selecting which table of a join to use for the outer loop. check-in: 94255634 user: drh tags: inner-loop-cost
2012-11-06
20:39
Adjust the SQLITE_DBSTATUS_STMT_USED calculation to take the modified usage of sqlite3VdbeClearObject() into account. check-in: 82eb7ead user: mistachkin tags: trunk
18:41
In test_quota.c, provide a work-around for the missing _chsize_s() function in mingw. check-in: 6b4979e8 user: drh tags: trunk
2012-11-05
16:36
Merge the omit-wal-fix branch into branch-3.7.9 where it belongs, and in so doing get branch-3.7.9 working with SQLITE_OMIT_WAL. check-in: 03919517 user: drh tags: branch-3.7.9
13:51
Add the INSTR() SQL function. check-in: a4c181cb user: drh tags: trunk
2012-11-02
23:42
Merge the fix for ticket [bfbf38e5e9956ac6] into trunk. check-in: 4f7dfc32 user: drh tags: trunk
19:08
Adding test cases for ticket [bfbf38e5e9956a] Closed-Leaf check-in: 62ebfa74 user: drh tags: ticket-bfbf38e5e9
18:48
Proposed fix for ticket [bfbf38e5e9]. check-in: 18ae030d user: drh tags: ticket-bfbf38e5e9
18:24
Fix an out-of-date comment. No changes to code. check-in: 10cc12b1 user: drh tags: trunk
2012-10-30
21:03
Pull all the latest trunk enhancements into the sessions branch. check-in: fce667f2 user: drh tags: sessions
18:09
Enable the use of coroutines as an alternative to manifesting views used in a FROM clause. check-in: 9dca18f5 user: drh tags: trunk
15:31
Make sure that the optimizer never tries to create an automatic index on a coroutine subquery. Closed-Leaf check-in: f83aa0de user: drh tags: subquery-as-coroutine
14:44
Fix a typo in the header comment for the OpenPseudo opcode. check-in: 4f106123 user: drh tags: subquery-as-coroutine
14:39
Make it possible to disable the subquery-by-coroutine optimization using sqlite3_test_control(). Remove an always-false conditional. check-in: 564631f3 user: drh tags: subquery-as-coroutine
00:29
Add an optimization that attempts to run a subquery as a coroutine rather than manifesting it into a temporary table. check-in: 7af3acbb user: drh tags: subquery-as-coroutine
2012-10-29
14:27
Make the multiplexor and the IntArray extensions callable from C++. check-in: cbd8fddf user: drh tags: trunk
2012-10-28
19:35
Merge VSIX tooling and packaging enhancements to trunk. check-in: 99f27d64 user: mistachkin tags: trunk
2012-10-26
19:22
Fix a 32-bit integer overflow problem that could cause an error in a CREATE INDEX statement that writes more than 16GB of data. check-in: e24ba5be user: dan tags: trunk
18:40
Make sure the automatic index optimization is checked even if the covering index scan optimization was previously selected. check-in: ac1d5d8a user: drh tags: trunk
13:46
Add QNX-specific performance tweaks to the unix VFS. (Cherry-pick merge of [b02849e7bde458].) check-in: 63a7dd75 user: drh tags: trunk
13:34
Backport the shared-cache-fix branch. check-in: 325364a9 user: drh tags: branch-3.7.14
13:25
Add QNX-specific performance tweaks to the unix VFS. (Cherry-pick merge of [b02849e7bde458].) Put auxiliary libraries after libsqlite3.a in the testfixture target of the "main.mk" makefile. (Cherry-pick merge of [8fc8548f52ab8fcfb5].) check-in: cbfd1b12 user: drh tags: branch-3.7.14
00:55
Make sure all virtual table cursors have been closed on a prepared statement prior to unlinking the perpared statement from its database connection. The test case for this is in TH3, in the main39.test module. check-in: 6d42d806 user: drh tags: trunk
00:11
Make sure all virtual table cursors have been closed on a prepared statement prior to unlinking the perpared statement from its database connection. Closed-Leaf check-in: f7c5abe8 user: drh tags: deferred-close-order
2012-10-25
23:47
Further work on getting ssdsim to run. This is an incremental checkin to save my place while jumping off to work on other things. Leaf check-in: ae2f1627 user: drh tags: ssdsim
19:25
Fix a bug in fts3 causing it to return SQLITE_NOMEM when NEAR, OR and some auxiliary functions were used together. Also a segfault in vtab.c that could follow an OOM condition. check-in: 33f4f981 user: dan tags: trunk
17:21
Use a constant string "BINARY" for the unspecified collating sequence. This is part of check-in [635e3a762dd] that is being back-ported. check-in: 9078ea75 user: drh tags: branch-3.7.9
15:43
Fix typo in usage text for the command-line shell. Also, in the same usage text, make the file name argument to -init uppercase for consistency. check-in: a6d906cf user: mistachkin tags: trunk
15:32
Merge the command-line shell enhancements from trunk. Other edits toward trying to get ssdsim to run. check-in: 848f87e2 user: drh tags: ssdsim
15:23
Improvements to the command-line argument parsing in the command-line shell. Command-line options can now occur either before or after the database name and first command and are still accepted and processed. Command-line options are processed even if no database name is given (and :memory: is assumed). check-in: 317c80cb user: drh tags: trunk
03:07
Implementation of the INSTR() SQL function, as found in SQL Server, MySQL, and Oracle. Closed-Leaf check-in: 49ccae96 user: drh tags: instr
01:50
Initial check-in of a test VFS designed to simulate a NAND-flash SSD for the purpose of measuring and subsequently minimizing write amplification caused by SQLite. The code in this check-in compiles but does not run. check-in: 9e6efcf0 user: drh tags: ssdsim
2012-10-24
00:47
Translate the Debug/Release project configurations to the Debug/Retail VSIX package configurations. Closed-Leaf check-in: 5023a7ad user: mistachkin tags: vsixFlavor
2012-10-20
09:35
Modify clean target to handle all VSIX package flavors. check-in: 023217ea user: mistachkin tags: vsixFlavor
08:40
Modify VSIX build tools in support of an additional package flavor. check-in: 702ebc64 user: mistachkin tags: vsixFlavor
2012-10-19
19:22
Correct the design-time library file path in the VSIX package now that it is per-configuration. check-in: 521024d4 user: mistachkin tags: branch-3.7.14
02:10
Make sure substructure elements have proper alignment in the ICU tokenizers of FTS2 and FTS3. check-in: aaa2d9b0 user: drh tags: trunk
00:23
Add detailed comments to the build tools used to generate the VSIX package. Also, allow the build configurations and native library directories to be overridden for the multi-platform build tool for MSVC. check-in: 0482c73b user: mistachkin tags: trunk
2012-10-18
20:49
Put auxiliary libraries after libsqlite3.a in the testfixture target of the "main.mk" makefile. check-in: 8fc8548f user: drh tags: trunk
15:01
Merge Watcom compiler warning fixes into trunk. check-in: 5be96788 user: drh tags: trunk
10:35
More warning fixes. Closed-Leaf check-in: 51a6a797 user: mistachkin tags: warnings
09:39
Fix harmless compiler warnings. check-in: 018e09c7 user: mistachkin tags: warnings
2012-10-17
20:28
Add a comment to fts3_snippet.c. check-in: b5f5ba31 user: dan tags: trunk
20:15
Initialize variables used as outputs of custom tokenizer method calls in fts4. check-in: 514505a8 user: dan tags: trunk
16:20
Add a test for the problem fixed by [bf44d73d3e]. check-in: db9b1fa5 user: dan tags: trunk
15:28
Change the way the tcl crash-test code works to avoid triggering an assert() in os_unix.c. check-in: b8b7b8f9 user: dan tags: trunk
13:15
Remove an incorrect "#ifndef SQLITE_OMIT_AUTOVACUUM" from pager. check-in: bf44d73d user: drh tags: trunk
2012-10-16
23:17
Enable optimization of IN operators on constraints to virtual tables. check-in: aa650746 user: drh tags: vtab-IN-opt
23:08
Merge updates from trunk. check-in: f021559d user: mistachkin tags: configReadOnly
21:08
An optimization that converts "a IN (b)" into "a==b". Seems to work, but needs additional test cases. Leaf check-in: 8b4c3c5e user: drh tags: degenerate_IN
2012-10-15
23:15
Change the ICU tokenizer so that it does not attempt to call strlen(NULL). This is a cherry-pick of the fix in [04298f1ac42c40c] on 2012-03-31 first appearing in release 3.7.12. check-in: 49ffbc11 user: drh tags: branch-3.7.9
20:28
Correct comments and enhance readability of the mkvsix tool. check-in: 2c3af657 user: mistachkin tags: trunk
18:02
Hold the mutex on the shared-cache for the duration of a VACUUM operation. check-in: 629a42d4 user: dan tags: trunk
16:24
Dequote column names generated by the query flattener. check-in: 5526e0aa user: drh tags: trunk
14:25
Merge all the latest core changes into the sessions branch. check-in: 76767d65 user: drh tags: sessions
11:28
Fix a failing assert() in wal.c. check-in: 8745530b user: dan tags: trunk
2012-10-13
23:16
Ensure that when the source of a backup is a database that is zero bytes in size, the final destination database consists of at least one page. Truncating it to zero bytes is equivalent to zeroing the schema cookie and change counter, which can cause problems for existing clients. check-in: ca86138b user: drh tags: trunk
20:55
Mark an always-true conditional as such. Closed-Leaf check-in: ae025cae user: drh tags: zero-byte-backup-fix
20:20
Modify backup4 test name prefix to make the resulting test names unique. check-in: 637fb1c1 user: mistachkin tags: zero-byte-backup-fix
19:58
Ensure that when the source of a backup is a database that is zero bytes in size, the final destination database consists of at least one page. Truncating it to zero bytes is equivalent to zeroing the schema cookie and change counter, which can cause problems for existing clients. check-in: af5c9ee4 user: dan tags: zero-byte-backup-fix
09:31
Allow the showdb tool to be compiled with MSVC. check-in: dce391fc user: mistachkin tags: trunk
2012-10-12
18:22
Backport of tooling support for including the debug build in the VSIX package. check-in: c1888967 user: mistachkin tags: branch-3.7.14
18:06
Tooling support for including the debug build in the VSIX package. check-in: de784399 user: mistachkin tags: trunk