SQLite
Timeline
Not logged in

2 descendants and 200 ancestors of [0a1207c895]

2013-01-08
17:24
[f29680c468] Closed-Leaf: Merge updates from trunk. (user: mistachkin, tags: configReadOnly)
2013-01-07
17:31
[bf90f1fbf8] Merge updates from trunk. (user: mistachkin, tags: configReadOnly)
13:26
[0a1207c895] Closed-Leaf: Do not raise an error if an unknown SQL function is found in a CHECK constraint while parsing the schema of an existing database. This version causes a run-time error when processing STAT3 tables. (user: dan, tags: mistake)
2013-01-05
17:17
[7695b88fe0] More bug fixes to the test_regexp.c module. Bring test_regexp.c into alignment with the regexp.c file in the Fossil sources. (user: drh, tags: trunk)
2013-01-04
22:26
[e9ac533960] Remove superfluous text from a comment. (user: mistachkin, tags: trunk)
20:45
[6c4c2b7dba] Do not use umask() since it change the umask for the entire process, not just the thread using SQLite. Make whatever permission changes are needed using fchmod() after the file is created, instead. (user: drh, tags: trunk)
19:22
[8285b15a05] Fix an out-of-order local variable declaration in test_regexp.c. (user: drh, tags: trunk)
14:06
[357231ec97] Fix the zInit[] optimization of test_regexp.c when the initial string contains 3-byte UTF8 characters. (user: drh, tags: trunk)
2013-01-03
19:34
[45c158b1a0] Bring back test_regexp changes that were made when porting to Fossil. Also fix some bugs that were introduced by the Fossil port. (user: drh, tags: trunk)
18:07
[99127a669c] Improvements to column name resolution in queries with parenthesized FROM clauses. Also includes a fix for ticket [beba9cae6345a3]. (user: drh, tags: trunk)
17:34
[20730bad70] Closed-Leaf: Further corner-case fixes to the name resolution logic. (user: drh, tags: name-resolution-fix)
16:54
[afe96a118c] Remove an incorrect assert() statement (ticket [beba9cae6345a]). Fix other minor problems in the name resolution logic. (user: drh, tags: name-resolution-fix)
00:45
[4cf5ed7ea1] Now supports result sets of the form "TABLE.*" with nested FROM clauses. (user: drh, tags: name-resolution-fix)
2013-01-02
14:57
[ef01e30456] When resolving result-set name collisions, make them x:1, x:2, x:3, etc. instead of x:1, x:1:1, x:1;1;1. (user: drh, tags: name-resolution-fix)
12:29
[a5f4d2b641] Merge all the latest trunk changes into the name-resolution enhancement branch. (user: drh, tags: name-resolution-fix)
2013-01-01
14:01
[5a2ac94483] Reduce the size of the Index object (by 8 bytes on x64). (user: drh, tags: trunk)
13:55
[3076a89015] Enhance the table_info pragma so that the pk column shows the order of the columns in a multi-column primary key. (user: drh, tags: trunk)
2012-12-31
20:16
[a611c75061] More test cases for the REGEXP operator. Fix minor bugs uncovered by these test cases. (user: drh, tags: trunk)
19:18
[46c8c01b75] Add the test_regexp.c module containing a cross-platform implementation of the REGEXP operator. (user: drh, tags: trunk)
2012-12-21
16:15
[ff6857b6ed] Ensure the database size field in the db header of a backup database is set correctly. Fix for [0cfd98ee201]. (user: dan, tags: trunk)
2012-12-20
01:15
[e408dc9080] Add PRAGMA foreign_key_check. Name the child and parent tables as part of a "foreign key mismatch" error. (user: drh, tags: trunk)
00:32
[b5a8f3160b] Closed-Leaf: Remove an unreachable branch operation from the foreign_key_check pragma. (user: drh, tags: foreign-key-check)
2012-12-19
16:58
[b3c9e8f812] Fix the segfault problem of ticket [a7b7803e8d1e869] which involved the use of "AS" named result columns as logical terms of the WHERE clause. (user: drh, tags: trunk)
16:32
[0ae142178d] Closed-Leaf: A couple more test cases. (user: drh, tags: tkt-a7b7803e)
16:25
[d7cc364e87] Additional test cases involving the use of a result column specified by its "AS" name as a logical term of the WHERE clause. Ticket [a7b7803e8d1e8699cd]. (user: drh, tags: tkt-a7b7803e)
15:53
[3d0e00c731] Proposed fix for ticket [a7b7803e8d1e8699cd8a]. (user: drh, tags: tkt-a7b7803e)
13:41
[3e7d84db78] Add commentary to the ExprList object to explain how zSpan is overloaded. Add test cases for the new name resolution functionality. (user: drh, tags: name-resolution-fix)
02:36
[7344e791b9] Better resolution of table and column names in joins where some of the terms of the FROM clause are parenthesized. (user: drh, tags: name-resolution-fix)
2012-12-18
19:36
[7fecced466] Optimize the degenerate case of a FROM clause table name enclosed all by itself inside parentheses. Generate code as if the parentheses did not exist, rather than the old behavior of manifesting the parenthesized table into a transient table. Also, tag every FROM-clause SELECT subquery that is generated by a parenthesized FROM-clause expression using the SF_NestedFrom flag. The new SF_NestedFrom flag is not yet used for anything. (user: drh, tags: trunk)
16:07
[9b67c633d9] Resolve names in FROM-clause subqueries prior to resolving names in the result set expressions of a SELECT statement. (user: drh, tags: trunk)
13:12
[7e30c021ab] Remove old commented-out code from parse.y. Fix some over-length source lines in parse.y. No logical changes. (user: drh, tags: trunk)
11:59
[8183d8d7ae] On atomic-write capable systems, if copying the contents of an in-memory journal to disk fails, close the (on disk) journal file before returning the error to the caller. This causes the subsequent rollback operation to use the in-memory journal. Fix for [df678d738adb]. (user: dan, tags: trunk)
2012-12-17
22:32
[25411f83f9] Added test cases for PRAGMA foreign_key_check. Fixed a bug that appears when the column order of the child and parent differ. (user: drh, tags: foreign-key-check)
20:57
[97f7f73772] Add to the foreign_key_check pragma an extra output column "parent" that contains the name of the parent table for the constraint that failed. (user: drh, tags: foreign-key-check)
20:40
[0f9963526c] Enhance the error message for "foreign key mismatch" to include the names of the child and parent tables. Begin adding test cases for PRAGMA foreign_key_check. Make sure PRAGMA foreign_key_check gets all necessary table locks. (user: drh, tags: foreign-key-check)
18:43
[57d47423a6] "PRAGMA foreign_key_check" with no argument checks the foreign keys on all tables. (user: drh, tags: foreign-key-check)
18:05
[603b695bf0] Fix an issue with child keys that are not INTEGER PRIMARY KEY referencing INTEGER PRIMARY KEY in the parent. (user: drh, tags: foreign-key-check)
16:46
[01c980e9bb] Prototype for PRAGMA that checks all foreign key constraints on a table. (user: drh, tags: foreign-key-check)
2012-12-14
17:54
[3d65c70343] Optimize IN operators in the WHERE clause of queries using virtual tables. (user: drh, tags: trunk)
17:48
[d2fb7619b0] Closed-Leaf: Remove an unreachable branch. Improvements to comments. (user: drh, tags: vtab-IN-opt)
15:54
[6d507e4de9] Merge in all the trunk changes that have occurred since this branch was opened. (user: drh, tags: vtab-IN-opt)
15:36
[d6e045f89c] Fix the virtual table IN optimizer so that it work even if the virtual table implementation leaves the sqlite3_index_info.aConstraintUsage[].omit flag clear for an equality constraint that it intends to use. (user: drh, tags: vtab-IN-opt)
2012-12-13
18:57
[52e755943f] Generalize the min/max optimization so that if an appropriate index exists, the index it can be used by any aggregate query that contains only a single max() or min() and does not contain a GROUP BY clause. (user: drh, tags: trunk)
18:51
[8bcf5f51d8] Increase the version number to 3.7.16 in advance of adding new features for the next release. (user: drh, tags: trunk)
16:37
[7280e14cd8] Closed-Leaf: Attempt to further generalize the min/max optimization so that, if an appropriate index exists, it can be used by any aggregate query that contains only a single aggregate of the form max(colname) or min(colname) and does not contain a GROUP BY clause. (user: dan, tags: minmax-opt)
2012-12-12
14:30
[120c82d56e] Allow the error message from "PRAGMA integrity_check" to be longer than 20,000 bytes. (user: drh, tags: trunk)
13:36
[cd0b37c526] Version 3.7.15 (user: dan, tags: trunk, release, version-3.7.15)
2012-12-11
19:40
[81d9ee0f0d] Update requirements marks and test cases for multi-VALUE INSERT and to fix typos in requirements text. (user: drh, tags: trunk)
19:10
[e38adb60a7] Fix a typo in a comment that is used to generate documentation. No changes to code. (user: drh, tags: trunk)
2012-12-10
22:19
[bd7aeeb691] When an arithmetic operation with two integer operands must give a floating-point answer due to overflow, make sure the answer is not rounded back to integer by affinity. (user: drh, tags: trunk)
10:22
[75e545a9e2] Modify releasetest.tcl so that it runs the "checksymbols" test on a build without SQLITE_DEBUG defined. If SQLITE_DEBUG is defined, the sqlite3WhereTrace variable causes the test to fail. (user: dan, tags: trunk)
09:08
[ee662c039d] Remove a reference to JumpOnce from a comment in vdbe.c. No code changes. (user: dan, tags: trunk)
2012-12-08
22:14
[92c9ab56b1] Factor some work out of the index loop of the bestBtreeIndex() routine for a small performance increase. (user: drh, tags: trunk)
21:51
[8542e6180d] Refactor collating-sequence handling as a fix for ticket [71e333e7d2e642]. The Expr.pColl field is removed from the Expr object. The COLLATE operator now becomes a separate instance of Expr in the expression tree. The code generator looks up the correct collating function as needed, rather than referring to Expr.pColl. (user: drh, tags: trunk)
21:36
[cdbfa66483] Closed-Leaf: Adjustments to the collating-sequence refactoring to facilitate full-coverage testing and to fix some minor issues found by TH3. (user: drh, tags: ticket-71e333e7)
14:16
[b3f5366811] Make sure WHERE clause constraints A=B and B=A work the same even with COLLATE clauses. (user: drh, tags: ticket-71e333e7)
13:26
[2722f4074f] Fix the header comment on the OP_Compare operator. (user: drh, tags: ticket-71e333e7)
04:10
[1a9db8dc2f] Duplicating check constraint expressions prior to code generation is no longer required, and so it is removed. (user: drh, tags: ticket-71e333e7)
03:34
[7b96115e81] Veryquick passes all tests now. (user: drh, tags: ticket-71e333e7)
00:52
[f66c1db296] Recognize TK_COLLATE operators that have been transformed into TK_REGISTER. Skip both TK_COLLATE and TK_AS operators when looking for the top of an expression. (user: drh, tags: ticket-71e333e7)
2012-12-07
23:23
[bd960d937f] Improved error messages when column integers in an ORDER BY clause are out of range. (user: drh, tags: ticket-71e333e7)
23:10
[8e724b383d] For an ORDER BY on a compound SELECT, take the collating sequence from the left-most term of the compound. (user: drh, tags: ticket-71e333e7)
22:54
[e313edca04] Do not report missing collating functions while parsing the schema. Also remove a stray comment. (user: drh, tags: ticket-71e333e7)
22:18
[0aaf52a339] Fix a long-standing issue with the distinct-as-aggregate optimization that only expressed when the new collating-sequence logic is turned on. (user: drh, tags: ticket-71e333e7)
21:02
[49654453ad] Fix the processing of ORDER BY clauses with COLLATE terms on compound queries. 52 veryquick test failures remain. (user: drh, tags: ticket-71e333e7)
20:31
[f9fa7581c0] Many more tests are passing. Only about 100 failures remain in veryquick. (user: drh, tags: ticket-71e333e7)
19:28
[2d5f37c99a] Ensure the VerifyCookie sub-routine has been run before the database is accessed in an obscure case. Fix for ticket [d6b36be38]. (user: dan, tags: trunk)
18:38
[972443b4eb] Some errors in veryquick resolved. Many more to go. (user: drh, tags: ticket-71e333e7)
14:02
[7fafab12e4] Veryquick now runs to completion without segfaulting or asserting. But there are still lots of errors. (user: drh, tags: ticket-71e333e7)
10:55
[df1827b19e] Do not run test file malloc3.test as part of the inmemory_journal permutation. Explanation is in a comment at the top of malloc3.test. (user: dan, tags: trunk)
09:08
[930ba85262] Spelling and header fixes for the async extension. (user: mistachkin, tags: trunk)
2012-12-06
23:16
[c507ca4a8e] In the async VFS, treat the new error code SQLITE_IOERR_DELETE_NOENT as success for xDelete. (user: mistachkin, tags: trunk)
21:16
[fd011cb22f] Remove the Expr.pColl field and compute the collating sequence as it is needed. This fixes the test script "shared9.test", though there is still a memory leak. And there are other problems. Consider this a work-in-progress. (user: drh, tags: ticket-71e333e7)
19:41
[79ef8e3c77] Merge the constant-refactoring-in-triggers branch with the trunk. (user: dan, tags: trunk)
19:37
[0c31a46801] Closed-Leaf: Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements. Candidate fix for [ae3c5670b6]. (user: dan, tags: constant-refactoring-in-triggers)
19:01
[1a63b1d5fa] Add the SQLITE_FCNTL_TEMPFILENAME file control that asks the underlying VFS to return a new temporary filename. Per request from NSS team at Mozilla. (user: drh, tags: trunk)
15:15
[cc6e0785df] Add a test case that demonstrates ticket [71e333e7d2e642]. (user: drh, tags: ticket-71e333e7)
04:33
[d507648d82] For the sqlite3-all.c target, use backslashes when calling the splitter script via the MSVC makefile. (user: mistachkin, tags: trunk)
04:19
[9793a21c13] Bring the ancient malloc3.test file closer into relevance with the latest core code. (user: mistachkin, tags: trunk)
02:56
[1551277208048c] Stop using the TCL_LIBS configuration variable when linking with Tcl. Remove superfluous 'rm' command from the "clean" target. (user: drh, tags: trunk)
01:03
[7b6951016f] Remove obsolete comments from the definition of the CollSeq object. (user: drh, tags: trunk)
00:16
[e1feab9834] Closed-Leaf: Stop using the TCL_LIBS configuration variable when linking with Tcl. Remove superfluous 'rm' command. (user: mistachkin, tags: noTclLibs)
2012-12-05
19:04
[5e961e37c5] Disable a couple of tests in where.test when running the "no_optimization" permutation. (user: dan, tags: trunk)
16:44
[51cbddd51d] Modify a query in test/thread001.test to ensure that results are returned in the order expected by the test. (user: dan, tags: trunk)
14:37
[40c143955e] 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. (user: dan, tags: trunk)
14:31
[9f6c68856b] 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. (user: drh, tags: trunk)
11:30
[bdceca2738] Since errors are ignored anyway, use sqlite3OsFileControlHint() instead of OsFileControl() to invoke the SQLITE_FCNTL_BUSY_HANDLER file-control. (user: dan, tags: trunk)
10:01
[11aa47b0a8] 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. (user: dan, tags: trunk)
09:12
[04ab2dc691] Update a couple of test scripts so that they work in auto-vacuum mode. (user: dan, tags: trunk)
2012-12-04
11:03
[12693deba9] Fix a harmless compiler warning. (user: drh, tags: trunk)
05:24
[41806de5c8] Add a test to ensure that the fix in b0c1ba655d has worked. (user: dan, tags: trunk)
00:59
[487ba75313] Improvements to the 'tcl' shell output mode. Escape doublequotes, set separator to space when mode is set, and skip separator after final column. (user: drh, tags: trunk)
00:53
[ffd1e51490] Fix an uninitialized variable detected by valgrind. (user: drh, tags: trunk)
00:37
[6d31557837] Fix an out-of-order function declaration when compiled with MEMDEBUG. (user: mistachkin, tags: trunk)
00:23
[41fd9dd290] Closed-Leaf: Improvements to the 'tcl' shell output mode. Escape double quotes, set separator to space when mode is set, and skip separator after final column. (user: mistachkin, tags: tclMode)
2012-12-03
19:42
[7d5fc1a339] Remove an unreachable condition. Replace it with an assert(). (user: drh, tags: trunk)
17:04
[b0c1ba655d] 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. (user: drh, tags: trunk)
2012-12-01
20:21
[2e5e651527] Do not exit the command-line shell if a ".read" command invokes a script that contains two errors. But reported on the mailing list. (user: drh, tags: trunk)
2012-11-29
14:26
[3d548db7eb] Mark the "async" module as deprecated as its functionality has been superceded by WAL mode. This closes ticket [f46ca03b55ae0e] (user: drh, tags: trunk)
2012-11-27
21:22
[f0843f885a] Add the SQLLOG capability to trunk. (user: drh, tags: trunk)
21:12
[92e9b5bc05] Improved detection of file-does-not-exist in winDelete. (user: drh, tags: trunk)
16:39
[b3809c937b] Closed-Leaf: Get SQLLOG working on windows. Fix a couple of compiler warnings. (user: drh, tags: sqllog)
15:56
[e38fb02d5e] Fix a problem causing the "number-of-documents" field maintained by FTS4 to be set incorrectly by REPLACE queries. (user: dan, tags: trunk)
10:56
[429c5b2056] 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. (user: dan, tags: sqllog)
2012-11-26
19:50
[cd501bbccf] Add an option to register global hooks used for logging all SQL executed by an application. (user: dan, tags: sqllog)
2012-11-21
02:10
[692ad3c02b] Closed-Leaf: 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. (user: mistachkin, tags: winNotFound)
2012-11-20
15:06
[d4c36d4991] 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. (user: drh, tags: trunk)
2012-11-13
11:16
[29980b08ec] Strive to use posix_fallocate() rather than ftruncate() when posix_fallocate() is available. Ticket [5eaa61ea18]. (user: drh, tags: trunk)
11:08
[597333f102] Closed-Leaf: 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] (user: drh, tags: tkt-5eaa61ea18)
10:54
[356259617c] 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] (user: drh, tags: tkt-5eaa61ea18)
2012-11-09
21:40
[5a3b07f0f5] 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(). (user: drh, tags: trunk)
20:17
[bed9c172ce] 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. (user: dan, tags: trunk)
18:32
[3f87f4593b] Take into account the cost of inner loops when selecting which table of a join to use for the next outer loop. (user: drh, tags: trunk)
18:22
[51bfd63b7f] Closed-Leaf: 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. (user: drh, tags: inner-loop-cost)
17:59
[942556342a] Try to take into account the cost of inner loops when selecting which table of a join to use for the outer loop. (user: drh, tags: inner-loop-cost)
2012-11-06
20:39
[82eb7eadb8] Adjust the SQLITE_DBSTATUS_STMT_USED calculation to take the modified usage of sqlite3VdbeClearObject() into account. (user: mistachkin, tags: trunk)
18:41
[6b4979e86c] In test_quota.c, provide a work-around for the missing _chsize_s() function in mingw. (user: drh, tags: trunk)
2012-11-05
13:51
[a4c181cbcf] Add the INSTR() SQL function. (user: drh, tags: trunk)
2012-11-02
23:42
[4f7dfc32aa] Merge the fix for ticket [bfbf38e5e9956ac6] into trunk. (user: drh, tags: trunk)
19:08
[62ebfa7476] Closed-Leaf: Adding test cases for ticket [bfbf38e5e9956a] (user: drh, tags: ticket-bfbf38e5e9)
18:48
[18ae030dad] Proposed fix for ticket [bfbf38e5e9]. (user: drh, tags: ticket-bfbf38e5e9)
18:24
[10cc12b16b] Fix an out-of-date comment. No changes to code. (user: drh, tags: trunk)
2012-10-30
18:09
[9dca18f5fe] Enable the use of coroutines as an alternative to manifesting views used in a FROM clause. (user: drh, tags: trunk)
15:31
[f83aa0de84] Closed-Leaf: Make sure that the optimizer never tries to create an automatic index on a coroutine subquery. (user: drh, tags: subquery-as-coroutine)
14:44
[4f1061230e] Fix a typo in the header comment for the OpenPseudo opcode. (user: drh, tags: subquery-as-coroutine)
14:39
[564631f3e4] Make it possible to disable the subquery-by-coroutine optimization using sqlite3_test_control(). Remove an always-false conditional. (user: drh, tags: subquery-as-coroutine)
00:29
[7af3acbbd4] Add an optimization that attempts to run a subquery as a coroutine rather than manifesting it into a temporary table. (user: drh, tags: subquery-as-coroutine)
2012-10-29
14:27
[cbd8fddf3b] Make the multiplexor and the IntArray extensions callable from C++. (user: drh, tags: trunk)
2012-10-28
19:35
[99f27d642f] Merge VSIX tooling and packaging enhancements to trunk. (user: mistachkin, tags: trunk)
2012-10-26
19:22
[e24ba5bee4] Fix a 32-bit integer overflow problem that could cause an error in a CREATE INDEX statement that writes more than 16GB of data. (user: dan, tags: trunk)
18:40
[ac1d5d8a55] Make sure the automatic index optimization is checked even if the covering index scan optimization was previously selected. (user: drh, tags: trunk)
13:46
[63a7dd75e6] Add QNX-specific performance tweaks to the unix VFS. (Cherry-pick merge of b02849e7bde458.) (user: drh, tags: trunk)
00:55
[6d42d806ad] 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. (user: drh, tags: trunk)
00:11
[f7c5abe873] Closed-Leaf: Make sure all virtual table cursors have been closed on a prepared statement prior to unlinking the perpared statement from its database connection. (user: drh, tags: deferred-close-order)
2012-10-25
19:25
[33f4f9817e] 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. (user: dan, tags: trunk)
15:43
[a6d906cfeb] 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. (user: mistachkin, tags: trunk)
15:23
[317c80cba3] 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). (user: drh, tags: trunk)
03:07
[49ccae964f] Closed-Leaf: Implementation of the INSTR() SQL function, as found in SQL Server, MySQL, and Oracle. (user: drh, tags: instr)
2012-10-24
00:47
[5023a7adca] Closed-Leaf: Translate the Debug/Release project configurations to the Debug/Retail VSIX package configurations. (user: mistachkin, tags: vsixFlavor)
2012-10-20
09:35
[023217ea9e] Modify clean target to handle all VSIX package flavors. (user: mistachkin, tags: vsixFlavor)
08:40
[702ebc646b] Modify VSIX build tools in support of an additional package flavor. (user: mistachkin, tags: vsixFlavor)
2012-10-19
02:10
[aaa2d9b0db] Make sure substructure elements have proper alignment in the ICU tokenizers of FTS2 and FTS3. (user: drh, tags: trunk)
00:23
[0482c73bfd] 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. (user: mistachkin, tags: trunk)
2012-10-18
20:49
[8fc8548f52] Put auxiliary libraries after libsqlite3.a in the testfixture target of the "main.mk" makefile. (user: drh, tags: trunk)
15:01
[5be96788a1] Merge Watcom compiler warning fixes into trunk. (user: drh, tags: trunk)
10:35
[51a6a797e1] Closed-Leaf: More warning fixes. (user: mistachkin, tags: warnings)
09:39
[018e09c703] Fix harmless compiler warnings. (user: mistachkin, tags: warnings)
2012-10-17
20:28
[b5f5ba3103] Add a comment to fts3_snippet.c. (user: dan, tags: trunk)
20:15
[514505a84b] Initialize variables used as outputs of custom tokenizer method calls in fts4. (user: dan, tags: trunk)
16:20
[db9b1fa597] Add a test for the problem fixed by bf44d73d3e. (user: dan, tags: trunk)
15:28
[b8b7b8f9e9] Change the way the tcl crash-test code works to avoid triggering an assert() in os_unix.c. (user: dan, tags: trunk)
13:15
[bf44d73d3e] Remove an incorrect "#ifndef SQLITE_OMIT_AUTOVACUUM" from pager. (user: drh, tags: trunk)
2012-10-16
23:17
[aa650746b1] Enable optimization of IN operators on constraints to virtual tables. (user: drh, tags: vtab-IN-opt)
2012-10-15
20:28
[2c3af657fe] Correct comments and enhance readability of the mkvsix tool. (user: mistachkin, tags: trunk)
18:02
[629a42d47a] Hold the mutex on the shared-cache for the duration of a VACUUM operation. (user: dan, tags: trunk)
16:24
[5526e0aa3c] Dequote column names generated by the query flattener. (user: drh, tags: trunk)
11:28
[8745530b9a] Fix a failing assert() in wal.c. (user: dan, tags: trunk)
2012-10-13
23:16
[ca86138bda] 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. (user: drh, tags: trunk)
20:55
[ae025cae22] Closed-Leaf: Mark an always-true conditional as such. (user: drh, tags: zero-byte-backup-fix)
20:20
[637fb1c1b7] Modify backup4 test name prefix to make the resulting test names unique. (user: mistachkin, tags: zero-byte-backup-fix)
19:58
[af5c9ee4a4] 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. (user: dan, tags: zero-byte-backup-fix)
09:31
[dce391fc63] Allow the showdb tool to be compiled with MSVC. (user: mistachkin, tags: trunk)
2012-10-12
18:06
[de784399ed] Tooling support for including the debug build in the VSIX package. (user: mistachkin, tags: trunk)
2012-10-10
13:59
[1182b54af0] Fix duplicate test name in whereD.test. (user: mistachkin, tags: trunk)
12:14
[96247853ef] Define the sqlite3PagerWalFramesize() function even if SQLITE_OMIT_WAL is used. (user: drh, tags: trunk)
10:52
[6dc987d32b] Add support for URI filenames in sqlite3_analyzer. (user: drh, tags: trunk)
09:46
[f7437153b9] Move a couple of WAL-related function declarations in sqliteInt.h and pager.h into "#ifndef SQLITE_OMIT_WAL" blocks. Otherwise, the amalgamation fails to build using some compilers with SQLITE_OMIT_WAL (static function declared but not defined). (user: dan, tags: trunk)
2012-10-09
21:07
[dd34bec389] Merge the fix for ticket [d02e1406a58ea02] into trunk. (user: drh, tags: trunk)
18:51
[7b1a6e6cb5] Attempt to suppress warnings generated by Coverity. (user: drh, tags: trunk)
14:36
[a02599ad85] Avoid an assertion fault and/or freeing memory while it is still in use when an error occurs during virtual table construction. (user: drh, tags: trunk)
09:26
[bb5c0f1c92] Bring some comments up to date in the query planner, and especially the ORDER BY optimizer. Also add testcase() macros. (user: drh, tags: trunk)
01:39
[01dc032b5b] Remove an unused variable. Fix code that occurs before a variable declaration. (user: drh, tags: trunk)
01:23
[981b9943e4] Replace an always-false conditional with an assert(). (user: drh, tags: trunk)
2012-10-08
23:25
[28d1eb40bf] Changes to facilitate full test coverage. (user: drh, tags: trunk)
21:51
[c027a9af91] Merge ORDER BY optimization refactoring and repair into trunk. (user: drh, tags: trunk)
21:01
[8314fd6078] Closed-Leaf: All test cases (veryquick.tcl and min.rc) pass. A few branch operations in ORDER BY optimization logic are untested by min.rc. (user: drh, tags: qp-enhancements)
20:27
[bcb4f26247] Further tweaks to the ORDER BY optimizer, to fix a bug and to get the optimizer to recognize some additional cases. (user: drh, tags: qp-enhancements)
19:41
[301bbee404] Bug fixes in the ORDER BY optimizer. (user: drh, tags: qp-enhancements)
18:23
[adbdc663f3] Continued refactoring of the ORDER BY optimization logic. This check-in is close to working, but it still has issues. A few test cases fail. (user: drh, tags: qp-enhancements)
14:36
[1c2c0a2880] Manually define the Win32 file-mapping APIs for WAL if SQLITE_WIN32_FILEMAPPING_API is defined. (user: mistachkin, tags: trunk)
2012-10-07
05:34
[50679889c7] Corrections to test names to eliminate duplicates and follow naming conventions. (user: mistachkin, tags: trunk)
00:52
[585e2070ee] Closed-Leaf: Manually define the Win32 file-mapping APIs for WAL if SQLITE_WIN32_FILEMAPPING_API is defined. (user: mistachkin, tags: winFileMapping)
2012-10-06
03:48
[4b0facc13b] Changes for WinRT compatibility. Also, allow version resource compilation and embedding to be disabled at compile-time. (user: mistachkin, tags: trunk)
2012-10-05
19:43
[e0c889d66c] Fix a problem in shared-cache mode where a COMMIT statement might cause a busy-handler belonging to a shared-cache connection other than the current writer to be invoked. (user: dan, tags: trunk)
17:44
[698ec7769d] Merge the shared-cache related fixes from the shared-cache-fix branch to the trunk. (user: dan, tags: trunk)
17:18
[82b6aa77c8] Closed-Leaf: Add a test for the collation-sequence/CHECK constraint problem fixed by the previous commit. (user: dan, tags: shared-cache-fix)
16:30
[c2c776ab73] Fix a problem with shared-cache mode and CHECK constraints causing one db handle to invoke a collation sequence function registered with another. (user: dan, tags: shared-cache-fix)
14:43
[8ea67522fb] Consolidate all occurrences of the "no such collation sequence" error message into a single spot. (user: drh, tags: trunk)
07:36
[43155b1543] Rename a tool batch file subroutine to avoid confusion about its purpose. (user: mistachkin, tags: trunk)
2012-10-04
19:33
[2b370dea70] Shared-cache mode fixes for views and virtual tables. (user: dan, tags: shared-cache-fix)
12:10
[8f4487450b] Yet another refactoring of ORDER BY logic in the query planner. This particular check-in works mostly, but still has a few minor issues. (user: drh, tags: qp-enhancements)
2012-10-03
18:09
[ba2f492f95] Fix an out-of-order memset() that occurs before all variable declarations are finished. Also fix a line that exceeds the 80-character line length limit. (user: drh, tags: trunk)
12:56
[956e4d7f89] Update the query planner to recognize more cases where ORDER BY clauses can be optimized out. Add test cases to verify correct behavior of the ORDER BY optimization when the covering-index-scan optimization is disabled. Fix a harmless compiler warning in the TCL interface. (user: drh, tags: trunk)
12:38
[0f9bb90100] Closed-Leaf: Fix a query planner problem that only occurs when covering-index-scan is disabled. Fix to tests whose output changed due to the new and more aggressive ORDER BY optimization. (user: drh, tags: qp-enhancements)
11:02
[c1f10a2643] Fix the TCL interface so that SQL functions implemented in TCL honor the "nullvalue" setting. Also remove from the TCL interface some unused legacy UTF8 translation code left over from SQLite2. (user: drh, tags: trunk)
00:25
[6744d9a37f] Further attempts to optimize out unnecessary ORDER BY clauses. (user: drh, tags: qp-enhancements)
2012-10-02
22:54
[7d301fdfee] Work around an optimization issue with the MSVC compiler for ARM. (user: mistachkin, tags: trunk)
15:19
[abcf6a5d05] More lenient handling of ORDER BY optimization in joins with mixed ASC/DESC. This is a better and less restrictive fix for the problem addressed by the previous check-in. (user: drh, tags: trunk)
14:11
[b0e7b4df6c] Only continue an ORDER BY optimization into inner loops if the equality constraints on the inner loop match terms of an outer ordered index that are actually used by the ORDER BY clause. (user: drh, tags: trunk)
01:46
[545bb33688] Factor an invariant out the loop termination condition for the ORDER BY satisfied-by-index analyzer routine. (user: drh, tags: trunk)
01:25
[351dc8d9ca] Make sure the outer loop cursor numbers are recorded in time for them to be used by the ORDER BY optimizer. (user: drh, tags: trunk)
01:10
[76b2776556] Improvements to the wheretrace output. (user: drh, tags: trunk)
2012-10-01
20:32
[59c2be75ff] Fix harmless compiler warnings. (user: drh, tags: trunk)