/ Timeline
Login

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

100 descendants and 100 ancestors of [7e0f861b]

2012-04-20
16:59
Do not consider a DISTINCT clause redundant unless a subset of the result-set is collectively subject to a UNIQUE constraint and it can be guaranteed that all columns of the subset are NOT NULL (either due to NOT NULL constraints WHERE clause terms). Fix for [385a5b56b9]. check-in: 7b8548b1 user: dan tags: trunk
15:24
Fix for [2a5629202f]. When considering whether or not a UNIQUE index may be used to optimize an ORDER BY clause, do not assume that all index entries are distinct unless there is some reason to believe that the index contains no NULL values. check-in: 9870e4c4 user: dan tags: trunk
12:02
Remove obsolete art. check-in: 372a90e2 user: drh tags: trunk
08:23
Merge the latest trunk changes into the WinRT branch (fixes various MSVC compiler warnings). check-in: 294a5cca user: mistachkin tags: winrt
2012-04-19
20:43
Update the apple-osx branch so that it includes all of the latest trunk changes. check-in: b72f07b4 user: drh tags: apple-osx
20:00
Merge the latest trunk changes into the sessions branch. check-in: 2b7a91e6 user: drh tags: sessions
18:04
Fix harmless compiler warnings on x64 MSVC, mostly in test code, but also in tclsqlite.c and in the FTS4 module. check-in: 3281972e user: drh tags: trunk
17:19
Fix a harmless compiler warning in tclsqlite.c for MSVC x64. Fix a test case associated with the FTS4 merge feature. check-in: de3f7187 user: drh tags: trunk
15:49
Fix harmless compiler warnings (unused parameter warnings) in the aggregate query analyzer. check-in: 2d435620 user: drh tags: trunk
2012-04-18
10:29
Merge build tool updates from trunk. Also, modify MSVC makefile to allow for debugging of build tool issues. check-in: b2a2fdb0 user: mistachkin tags: winrt
10:13
Fix a harmless compiler warning in the mkkeywordhash.c utility program. check-in: 6015200b user: drh tags: trunk
09:59
Fix a typecast problem in lemon that could cause problems on 64-bit machines. check-in: 4a5641cc user: drh tags: trunk
05:57
Import all the latest trunk changes into the WinRT branch. Refactor and/or remove WinCE-specific macros and functions used for file locking to improve clarity of presentation. check-in: ad5cd15f user: mistachkin tags: winrt
01:41
Import all the latest trunk changes into the sessions branch. check-in: 87a0eab5 user: drh tags: sessions
2012-04-17
21:00
When compiling for WinRT, always use the 'appcontainer' linker option. check-in: 300bcfe3 user: mistachkin tags: winrt
16:38
Improved handling of aggregate subqueries within an aggregate query. check-in: 430bb59d user: drh tags: trunk
09:09
Add an undocumented and possibly ephemeral ".breakpoint" command to the command-line shell, to call a no-op routine on which it is convenient to set a symbolic debugger breakpoint. check-in: 8e2363ad user: drh tags: trunk
2012-04-16
17:22
Fix a bug in the command-line shell logic that attempts to continue with a ".dump" even after encountering database corruption. check-in: 020b5e90 user: drh tags: trunk
2012-04-14
13:25
In the unix VFS, always set every open file to close-on-exec using either O_CLOEXEC at open (preferred) or FD_CLOEXEC in an ioctl after opening. Before this changes, many files were done this way, but not all. check-in: 9efbeb11 user: drh tags: trunk
11:48
Fix a typo in a comment that is extracted for documentation. No changes to code. check-in: e87371c5 user: drh tags: trunk
2012-04-11
23:22
Add a testcase() macro to ensure that the sqlite3AuthCheck() call inside the query flattener really is effective. check-in: a134e6e7 user: drh tags: trunk
11:38
Fix harmless static-analysis warnings, mosting having to do with memory leaks in the command-line shell. Add a clang analysis of the command-line shell to the "warnings-clang.sh" script. Other minor cleanups to the command-line shell code. check-in: 93a0f452 user: drh tags: trunk
2012-04-10
17:53
Add new interfaces to the test_quota.c module: sqlite3_quota_ftruncate(), sqlite3_quota_file_size(), sqlite3_quota_file_truesize(), and sqlite3_quota_file_mtime(). check-in: 2fa9f543 user: drh tags: trunk
16:05
Fix a copy/paste error in a comment in the fuzzer. No changes to code. check-in: 7433f2b5 user: drh tags: trunk
2012-04-07
00:09
Fix the application-defined function logic so that functions with a variable number of parameters can be replaced or deleted correctly. Also refactor some of the function-finder code for clarity of presentation. check-in: 09d5581c user: drh tags: trunk
2012-04-06
00:09
Update sqlite3_analyzer to correctly find all database files when the multiplexor is being used. check-in: 1bfc30cb user: drh tags: trunk
2012-04-05
20:04
Ignore the value of SQLITE_FCNTL_CHUNK_SIZE if it is negative. check-in: 1b08fef9 user: drh tags: trunk
01:37
Performance improvements for the RowSet object when it undergoes many cycles between RowSetInsert and RowSetTest. check-in: 49d20ede user: drh tags: trunk
2012-04-04
16:56
Add the ".trace" option to the command-line shell. check-in: b9ac3d7e user: drh tags: trunk
13:58
Fix the multiplexor logging so that it works with SQLITE_ENABLE_8_3_NAMES. check-in: 9e1e2fe2 user: drh tags: trunk
13:43
In the multiplexor extension, improve the error logging when a chunk fails to open. check-in: 781453c6 user: drh tags: trunk
2012-04-03
19:43
Cherrypick commit [1d5e744cc6] from the trunk in order to avoid leaving a file-descriptor open in test scripts capi3.test and capi3c.test. This is the version of SQLite that ships by default on the original Mountain Lion release. check-in: 86b8481b user: dan tags: apple-osx, mountain-lion
18:34
Do not run attempt to run test file fts4merge3.test unless the build includes FTS. check-in: 0506bf86 user: dan tags: trunk
18:33
Modify capi3.test and capi3c.test so that they work with SQLITE_OMIT_AUTORESET builds. check-in: 1d5e744c user: dan tags: trunk
17:43
Modify the integrity-check code to reduce the size of the large allocation from 4 bytes to 1 bit for each page in the database file. check-in: fa3a498d user: dan tags: trunk
17:05
Fix a typo in the rtree6.test script that prevented it from running. check-in: 221fe4a8 user: drh tags: trunk
17:01
Rerun autoconf to update the configure script for version 3.7.12 check-in: 6d73eb20 user: drh tags: trunk
15:10
If the SELECT that finds all root pages in the showdb fails, then report an error. check-in: 4b161415 user: drh tags: trunk
14:59
Enhance the "showdb" utility program with the "pgidx" option. Now requires linkage with the amalgamation. check-in: 4b573701 user: drh tags: trunk
2012-04-02
23:42
bad assert check-in: 0c0150f2 user: adam tags: apple-osx
23:35
Merge in latest changes, autologging options, read only file system wal support, test config conditionalization, WAL frame write prebuffering check-in: d51c086e user: adam tags: apple-osx
21:35
The SQLITE_RTREE_INT_ONLY compile-time option causes the RTree extension to use only integer math and store only integer coordinates. check-in: 02b7640f user: drh tags: trunk
17:18
Add #ifdefs to allow a test build to succeed even if SQLITE_ENABLE_FTS3 is not defined. check-in: fb121980 user: drh tags: trunk
2012-03-31
19:12
Fix a compiler warning by removing a redundant variable. check-in: af602d87 user: drh tags: trunk
17:50
Test cases for RELEASE and ROLLBACK TO of a nested savepoint while queries are pending. Ticket [27ca74af3c083] check-in: d2bf0efa user: drh tags: trunk
17:17
Do not abort pending queries on a RELEASE of a nested SAVEPOINT. This is a candidate fix for ticket [27ca74af3c083f787]. check-in: 79a4a3a8 user: drh tags: trunk
15:08
Modify selectColumnsFromExprList() to avoid ever incorrectly returning SQLITE_NOMEM. check-in: e7cb6b73 user: dan tags: trunk
11:58
Change the ICU tokenizer so that it does not attempt to call strlen(NULL). check-in: 04298f1a user: dan tags: trunk
09:59
Fix a bug in the EXPLAIN code for listing trigger programs that was causing an out-of-bounds read. check-in: c9342ca5 user: dan tags: trunk
02:46
Merge all the latest trunk changes into the apple-osx branch. check-in: 18ec60ca user: drh tags: apple-osx
02:34
Do more aggressive optimization of the AND operator where one side or the other is always false. check-in: f9a7e179 user: drh tags: trunk
2012-03-30
17:30
Merge all recent trunk changes into the sessions branch. check-in: fb9b9987 user: drh tags: sessions
16:44
Avoid using the OVERLAPPED struct on WinCE. check-in: 196ca3a8 user: mistachkin tags: trunk
15:57
Simplify the winRead and winWrite VFS functions to reduce the number of system calls. check-in: b3449186 user: drh tags: trunk
15:48
When a named CHECK constraint fails, include the name of the constraint in the error message. check-in: 1b75f301 user: drh tags: trunk
14:59
Fix MSVC compiler warnings in test code. check-in: cb7a8504 user: drh tags: trunk
14:01
Merge the latest trunk changes into the winrt branch. check-in: a1a85b84 user: drh tags: winrt
13:34
Fix an FTS4 test script problem for windows. check-in: 36aa6665 user: drh tags: trunk
12:10
Change the name of a local variable from "not" to "bNot" to lessen the chances of it colliding with some prior #define in the appliation. check-in: cbdd8638 user: drh tags: trunk
00:05
In the ".output" command of the shell, if the first character of the output filename is '|' then use popen() instead of fopen(). check-in: fa82062c user: drh tags: trunk
00:00
Fix compiler warnings on GCC and MSVC and fix a C89-ism that broke the build for MSVC. check-in: b451c0f9 user: drh tags: trunk
2012-03-29
15:11
Merge fts4-incr-merge with trunk. check-in: 4d6de3e9 user: dan tags: trunk
2012-03-28
18:08
Do the accounting for incr-merge work in pages instead of blocks. Closed-Leaf check-in: 83037d58 user: dan tags: fts4-incr-merge-exp
16:44
Merge in the latest changes from trunk. Closed-Leaf check-in: 66c4aaad user: drh tags: fts4-incr-merge
13:55
Fix a problem in fts4merge3.test. check-in: 64fc8b30 user: dan tags: fts4-incr-merge
2012-03-27
18:00
Add output of PRAGMAs auto_vacuum and encoding to the "schema" command of the fts3view utility program. check-in: e3107631 user: drh tags: fts4-incr-merge
15:10
Really delete the fts3merge.test script (should have been deleted by the previous commit). check-in: 83838149 user: dan tags: fts4-incr-merge
15:00
Remove the fts3merge.test script in favour of changing the fts4merge.test script so that it runs tests using both fts4 and fts3. Fix some problems with incr-merge and FTS3 tables. check-in: 5c447e22 user: dan tags: fts4-incr-merge
14:54
In the fts3view utility, label the blank segments used to mark the end of a segment sequence for a level/idx as "null". Improve the alignment of root segment names. check-in: 04aea024 user: drh tags: fts4-incr-merge
13:51
Enhance the fts3view tool with the big-segment command and fix a bug in the display of doclists. check-in: e9436d80 user: drh tags: fts4-incr-merge
13:44
Merge the fts4-incr-merge-exp branch with fts4-incr-merge. check-in: eb00b958 user: dan tags: fts4-incr-merge
11:48
Allow multiple incremental merges to proceed concurrently. This is required to prevent a large crisis-merge from occuring while an even larger incremental-merge is underway. Closed-Leaf check-in: 7ed9d2f2 user: dan tags: fts4-incr-merge-exp
00:38
Minor correct errors in the file format description for FTS3/4 contained in the fts3.c header comment. check-in: fb8aacdd user: drh tags: fts4-incr-merge
00:34
Enhance fts3view to show decodes of segments and doclists. check-in: 6d09de23 user: drh tags: fts4-incr-merge
2012-03-26
21:57
Add the fts3view utility program. check-in: f936c8ea user: drh tags: fts4-incr-merge
14:36
Fix FTS3 so that it works even without SQLITE_DEBUG. check-in: a18c1031 user: drh tags: fts4-incr-merge
10:57
Modify the FTS integrity-check so that the checksums do not depend on the results of signed integer overflow, which is undefined in C. check-in: f907fc3f user: dan tags: fts4-incr-merge
10:47
Add a comment to explain how the FTS integrity-check works. check-in: 64e8a116 user: dan tags: fts4-incr-merge
10:36
Add an experimental integrity-check function to FTS. check-in: 40fc8804 user: dan tags: fts4-incr-merge
2012-03-24
19:44
Add SQLITE_DBSTATUS_CACHE_WRITE. Used to query a database connection for the cumulative number of database pages written. check-in: 3cb6a879 user: dan tags: fts4-incr-merge
17:29
Enable fts3 tables to use incremental merge by automatically creating the %_stat table when it is needed. check-in: cc051fc0 user: drh tags: fts4-incr-merge
17:09
Fix a failing assert() in the FTS3_LOG_MERGES related code. check-in: 4220d52c user: dan tags: fts4-incr-merge
16:43
Add a comment to fts3SyncMethod() to justify the nMinMerge=64 constant. check-in: af55ca5f user: dan tags: fts4-incr-merge
16:18
Fix a bug in debugging code enabled when FTS3_LOG_MERGES is defined. check-in: 2e06babf user: drh tags: fts4-incr-merge
16:11
Remove the Fts3Table.mxLevel variable. check-in: 67a0cffc user: dan tags: fts4-incr-merge
14:45
Merge auto-incr-merge with incr-merge branch. check-in: 1c68687a user: dan tags: fts4-incr-merge
14:45
Modify the way the number of leaves written and the maximum relative level are calculated in the auto-incr-merge code. Closed-Leaf check-in: 0d841c95 user: dan tags: fts4-auto-incr-merge
02:20
An attempt at automatic incremental merging for FTS4. check-in: ed69434c user: drh tags: fts4-auto-incr-merge
2012-03-23
18:26
Fix a spurious SQLITE_CONSTRAINT error that may be returned by an incr-merge operation. check-in: ed7c17ea user: dan tags: fts4-incr-merge
15:38
Add a test to verify that sqlite3_total_changes() works with incr-merge operations. check-in: 1c72cecc user: dan tags: fts4-incr-merge
14:38
Remove an incorrect assert() statement. Fix a const-related warning. check-in: 96ed4749 user: dan tags: fts4-incr-merge
13:40
Fix another test case issue in trace2.test. check-in: 02a8e423 user: dan tags: fts4-incr-merge
11:09
When an incremental blob cursor is invalidated (occurs when an SQL statement modifies or deletes the row the blob cursor points to) release all page references held by the cursor. Otherwise, the presence of these references may cause other code in btree.c to incorrectly infer that the database is corrupt. check-in: 82c3f2ba user: dan tags: fts4-incr-merge
11:07
Update a couple of existing test cases. check-in: dcb8fa0f user: dan tags: fts4-incr-merge
2012-03-22
17:48
Add test cases to fts4merge.test. check-in: ecab2083 user: dan tags: fts4-incr-merge
16:48
Following an incr-merge operation that does not completely consume its input segments, store context in the rowid==1 row of the %_stat table that allows the next incr-merge to pick up where the previous left off. check-in: ab0a4f44 user: dan tags: fts4-incr-merge
2012-03-21
14:34
Add fts4merge3.test, for testing that older versions of FTS4 may interoperate with incr-merge capable versions. check-in: 903ec512 user: dan tags: fts4-incr-merge
2012-03-20
17:04
Merge trunk changes into the fts4-incr-merge branch. check-in: f61d5fb0 user: drh tags: fts4-incr-merge
2012-03-17
16:56
Fix various incorrect and missing comments and other style issues in and around the FTS incremental merge code. check-in: 7aabb62c user: dan tags: fts4-incr-merge
2012-03-16
15:54
Fix some integer overflow problems that can occur when using large langauge id values. check-in: 3475092c user: dan tags: fts4-incr-merge
14:54
Add a comment to the FTS getAbsoluteLevel() function. No actual code changes. check-in: 7e0f861b user: dan tags: fts4-incr-merge
2012-03-15
17:45
Modify incremental merge code to merge nMin segments at a time. check-in: cd34bc1a user: dan tags: fts4-incr-merge
2012-03-14
20:01
Add tests for incremental merge code. check-in: 57047372 user: dan tags: fts4-incr-merge
12:17
Avoid allocating a large object on the stack in the incremental merge code. Use sqlite3_malloc() instead. check-in: 36ae510d user: dan tags: fts4-incr-merge
11:51
Fix another bug in the incremental merge code. check-in: f97b12e0 user: dan tags: fts4-incr-merge
2012-03-13
19:56
Fix some bugs in the incremental merge code. Some remain. check-in: bff21683 user: dan tags: fts4-incr-merge
2012-03-09
12:52
Minor commenting and stylistic changes only. check-in: a1747086 user: drh tags: fts4-incr-merge
2012-03-08
18:39
Add the 'merge=?,?' command to fts4. This still needs some work. check-in: 741b8f89 user: dan tags: fts4-incr-merge
2012-03-05
16:24
Fix a problem compiling the test code in fts3_test.c when SQLITE_ENABLE_FTS3 is not defined. check-in: b00ccda3 user: dan tags: trunk
15:33
Merge the fts4-languageid branch with the trunk. check-in: 99a9073b user: dan tags: trunk
2012-03-03
18:46
Add the xLanguageid method to sqlite3_fts3_tokenizer versions 1 and greater. Closed-Leaf check-in: f8e9c445 user: dan tags: fts4-languageid
01:44
Add a test case for ticket [3557ad65a076c]. check-in: 4f34d707 user: drh tags: trunk
00:34
Fix a bug [3557ad65a07] that causes incorrect DISTINCT processing on an indexed query involving the IN operator. check-in: dec9a995 user: drh tags: trunk
2012-03-02
22:41
Fix test pragma-19.5 so that it works on file names that may contain spaces and/or backslashes. check-in: 9aaa1ab7 user: mistachkin tags: trunk
20:34
Remove an obsolete comment from FTS3. No code changes. check-in: 74d224b1 user: drh tags: trunk
19:53
Fix problems with combining content= and languageid= in a single fts4 table. check-in: 22491e7b user: dan tags: fts4-languageid
16:18
Add test for FTS 'rebuild' command. check-in: 181bc357 user: dan tags: fts4-languageid
12:26
Fix the FTS 'optimize' command on multi-lingual databases. check-in: 65fa6937 user: dan tags: fts4-languageid
11:48
Fix a bug in merging FTS language tables for languages other than language 0. check-in: d281cb89 user: dan tags: fts4-languageid
2012-03-01
21:30
Fix a typo in the header comment of sqlite3_commit_hook(). check-in: 3784d147 user: drh tags: trunk
19:44
Add the "languageid=" option to fts4. This code is still largely untested and alsmost certainly buggy. check-in: bea257f7 user: dan tags: fts4-languageid
2012-02-28
17:57
Fix spurious errors that may occur if an empty database is opened and then initialized as a WAL database by a second connection. check-in: 16330a2f user: dan tags: trunk
11:52
Fix a case where an error code was being overwritten in multiplexDelete(). check-in: c267893a user: dan tags: trunk
2012-02-27
14:28
Fix the xDelete implementation of the multiplexor VFS so that it correctly deletes overflow WAL files. check-in: e44e2677 user: drh tags: trunk
2012-02-24
16:13
Separate multiplexor overflow pages for -wal and -journal files into separate namespaces when in 8+3 filename mode. check-in: d6850667 user: drh tags: trunk
15:57
Fix the multiplexor so that it works with WAL mode and 8+3 filenames. check-in: a9fcb46b user: drh tags: trunk
14:33
Add #ifdef SQLITE_ENABLE_ZIPVFS around those bits of code that are only used by ZIPVFS. check-in: 3130275c user: drh tags: trunk
00:03
If the SQLITE_FCNTL_PRAGMA file control returns something other than SQLITE_NOTFOUND, then skip the rest of Pragma code generation. check-in: 9e6d340f user: drh tags: trunk
00:02
A simple change that allows the SQLITE_32BIT_ROWID compile-time option to work better. check-in: f9df4063 user: drh tags: trunk
2012-02-23
17:35
Fix an obscure bug that causes a crash when parsing certain invalid SQL statements. check-in: c8c7846f user: drh tags: trunk
16:45
Fix a typo made inside an assert() statement in the previous commit. check-in: f0640615 user: dan tags: trunk
15:35
Add the sqlite3PagerWalFramesize() function to pager.c. This is used by zipvfs. check-in: 786e24dc user: dan tags: trunk
14:28
Expose the sqlite3_stricmp() interface. Add the SQLITE_FCNTL_PRAGMA file control. check-in: c539cf21 user: drh tags: trunk
2012-02-22
20:08
Move test logic for SQLITE_FCNTL_PRAGMA out of os_unix.c and into test_vfs.c. Closed-Leaf check-in: c81fc40b user: drh tags: file-control-pragma
19:56
If the SQLITE_FCNTL_PRAGMA file-control returns anything other than SQLTIE_NOTFOUND and SQLITE_OK, then treat the result as an error. check-in: 56436181 user: drh tags: file-control-pragma
19:03
Disable the "filename" pragma implemented by os_unix.c except when compiled with SQLITE_TEST. check-in: 9a1da918 user: drh tags: file-control-pragma
18:21
Make benign any malloc failures inside the sqlite3_file_control() call within PRAGMA parsing. Add a couple simple tests for SQLITE_FCNTL_PRAGMA. check-in: a1f29fa6 user: drh tags: file-control-pragma
16:58
Change the SQLITE_FCNTL_PRAGMA file-control so that it can return a string value. check-in: fd8d7440 user: drh tags: file-control-pragma
14:45
Begin adding support for SQLITE_FCNTL_PRAGMA. check-in: 5be07904 user: drh tags: file-control-pragma
2012-02-21
18:35
Avoid redefining NDEBUG if the fuzzer is included in an amalagmated source file. check-in: f8ac826f user: drh tags: trunk
18:00
Prevent the fuzzer from ever returning a string longer than 100 bytes. check-in: 969095ca user: dan tags: trunk
14:11
Further fuzzer test cases. Fix a case in the fuzzer where an error code was being dropped. check-in: 8b77d395 user: dan tags: trunk
10:36
Add further test cases and minor fixes for the fuzzer. check-in: 583dde93 user: dan tags: trunk
2012-02-20
22:44
Updates to the instructions in the header comment of the fuzzer implementation. New test cases for the fuzzer. check-in: bf1dc790 user: drh tags: trunk
20:03
Change the way the fuzzer (test_fuzzer.c) works so that it loads its configuration from a database table. check-in: 90b7b957 user: dan tags: trunk
19:36
Fix a case in test_fuzzer.c causing transformations from the wrong ruleset to be applied in some cases. check-in: cb5f5ebc user: dan tags: trunk
2012-02-14
18:56
Increase the maximum ruleset id in the fuzzer from 50 to 2^31-1. check-in: 760e009a user: drh tags: trunk
15:34
Enhance the fuzzer virtual table to support multiple rule sets. check-in: a8293873 user: drh tags: trunk
2012-02-13
21:24
Merge the non-blocking ROLLBACK changes into trunk. check-in: 9c572d42 user: drh tags: trunk
20:28
Fix a harmless compiler warning introduced by the previous check-in. check-in: a8a042a7 user: drh tags: trunk
20:16
On unix, ignore the umask when creating journal files. That way, journal files will have exactly the same permissions as the original database and any process that has permission to write to the database can also recover hot journals. check-in: 84b32460 user: drh tags: trunk
17:01
Add the new SQLITE_ABORT_ROLLBACK extended error code to be returned for statements that are cancelled due to a rollback. Closed-Leaf check-in: 549f4fd0 user: drh tags: nonblocking-rollback
16:43
Change the ROLLBACK command so that pending statements to not block it. The pending statements instead return SQLITE_ABORT upon next access. Note: This causes separate shared-cache connections in read_uncommitted mode to abort as well. check-in: 9b66c79e user: drh tags: nonblocking-rollback
10:00
Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. check-in: 76bb649e user: dan tags: trunk
08:50
Fix a typo in the type of the fchown() function in os_unix.c. check-in: bfbfe05b user: dan tags: trunk
2012-02-11
23:55
Make fchown() an overrideable system call in os_unix.c. check-in: 98efac96 user: drh tags: trunk
22:19
Cleanup some directories and files left by the MinGW build, even when using the MSVC Makefile. check-in: 3ab89e25 user: mistachkin tags: trunk
21:56
Revise the preprocessor directives used to handle malloc.h and _msize, in order to detect and handle the MSVC special-case automatically. check-in: 90e73dc3 user: mistachkin tags: trunk
21:21
Silence GCC compiler warnings about unused return value from fchown(). check-in: b0225473 user: drh tags: trunk
19:53
Another attempt to fix warnings in the randomFunc() function. check-in: 768df4e1 user: drh tags: trunk
19:23
When creating journal files (including -wal and -shm files) try to set the ownership to be the same as the original database. This will prevent root from locking out the original owner of the file. check-in: 1254dffe user: drh tags: trunk
18:51
Remove a redundant test from the shared-memory logic in os_unix.c. check-in: 31142ca7 user: drh tags: trunk
2012-02-10
20:43
Fix a warning coming from the Solaris Studio compiler. check-in: 33294bbd user: drh tags: trunk
17:38
Disable the ability to have multiple values in the VALUES clause of an INSERT statement when SQLITE_OMIT_COMPOUND_SELECT is used. check-in: 92131195 user: drh tags: trunk
03:10
Fix an important bug in the handling of EINTR in unixRead(). Never came up on x86 but crashes on sparc. check-in: 1a16db0b user: drh tags: trunk
01:25
Fix a boundary case for the integer affinity routine for non-x86 processors. check-in: bea05ddd user: drh tags: trunk
2012-02-08
12:13
Add an autoconf test for malloc.h and use the results of that test to conditionally #include the malloc.h header file. check-in: 16a47112 user: drh tags: trunk
2012-02-07
14:13
Command-line shell enhancements: Reorganize the "usage" comment so that options are in alphabetical order. Add the new "--cmd" option. Allow either "--option" or "-option" for options. check-in: 9497893b user: drh tags: trunk
2012-02-02
21:02
More structure packing for smaller objects and less memory usage. check-in: f14e7f29 user: drh tags: trunk
19:37
Reduce the size of the MemPage object by about 32 bytes. Other structure size optimizations. check-in: 21695c34 user: drh tags: trunk
18:46
When non-aggregate columns occur in an aggregate query with a single min() or max(), then the values of the non-aggregate columns are taken from one of the rows that was the min() or max(). check-in: fa13edd3 user: drh tags: trunk
18:42
Fix a problem with NULL handling in aggregate min/max when returning values from the row containing the min or max. Closed-Leaf check-in: f27c7b4f user: drh tags: output-minmax-row
17:35
For queries of the form "SELECT p, max(q) FROM t1", the value of column p returned is the one on the same row that holds the maximum value of q. check-in: adb29232 user: drh tags: output-minmax-row
15:50
Data structure cleanup. Remove unused fields. Rearrange other files for tighter packing and reduced memory usage. check-in: 0bc594e8 user: drh tags: trunk
03:38
Simplified array allocation in the IdList and AggInfo objects. check-in: 25df2a74 user: drh tags: trunk
03:11
Fix a possible segfault after an OOM fault. This has been in the code for ages but only expressed itself following the previous check-in. check-in: a3553b8a user: drh tags: trunk
01:58
Remove the nAlloc field from the ExprList object. check-in: 5963de30 user: drh tags: trunk
2012-02-01
19:03
Very small performance enhancement and reduction in size of the sqlite3_stmt object. check-in: a38d57a4 user: drh tags: trunk
01:13
Fix ALTER TABLE RENAME so that it correctly handles triggers that attach to the table using the name in a different case. Ticket [ae6794effd404]. check-in: 0d78ebb8 user: drh tags: trunk
2012-01-31
23:34
Fix a compiler warning in FTS4. check-in: b4cad1ce user: drh tags: trunk
14:24
Futher pedantic fixes to the sqlite3_uri_boolean() interface. check-in: 77b3430d user: drh tags: trunk
13:35
Improvements to the documentation for sqlite3_uri_boolean(). check-in: b0a16179 user: drh tags: trunk
05:11
Change a comment in test script backup.test. check-in: 313546b4 user: dan tags: trunk
2012-01-30
18:40
Bring the documentation and implementation of sqlite3_uri_boolean() into closer agreement. Ticket [5f41597f7c9c] check-in: 7b053d69 user: drh tags: trunk
18:00
Fix compiler warnings in the TCL test harness. check-in: c4cd38a0 user: drh tags: trunk
16:02
Do not rely on the _WIN32_WINNT macro as vs2005 does not define it by default. Instead, always assume winNT unless the makefile explicitly sets SQLITE_OS_WINNT=0. check-in: 1ce4d21d user: drh tags: trunk
2012-01-28
21:08
Update the .dump command of the command-line shell so that it (1) avoids putting the semicolon of a DDL statement on the same line as a comment, (2) avoids long expression, even when dumping a table with many columns, and (3) avoids unnecessary quoting of the table name. This fixes tickets [c04a8b8a4f] and [232637c465]. Shell change only; no changes to the SQLite core. check-in: e6eea8d5 user: drh tags: trunk
19:44
Remove a couple of unnecessary nonterminals from the grammar. check-in: 2b2a7d8d user: drh tags: trunk
19:41
Add support for IF NOT EXISTS on CREATE VIRTUAL TABLE. check-in: 230983e8 user: drh tags: trunk
15:26
Update the version number to 3.7.11 and rerun autoconf. check-in: 6f9b265d user: drh tags: trunk
15:22
Add support for multiple rows of VALUES in an INSERT statement. check-in: eb3b6a0c user: drh tags: trunk
2012-01-25
20:43
Only invalidate the schema when the OP_ParseSchema opcode fails, not on any general failure of a vdbe program. check-in: 11f68d99 user: drh tags: trunk
16:29
Fix an FTS problem triggered by querying for an N character prefix using an N+1 character prefix index after rows have been deleted from the FTS table. Fix for [edb497982c]. check-in: c05c3fd2 user: dan tags: trunk
2012-01-24
10:08
Changes to the async-io module so that the xFileControl method returns SQLITE_NOTFOUND when a file-control is not recognized and so that it adds the second nul-terminator byte to filenames passed to the xOpen method of the underlying VFS. check-in: 7036886e user: dan tags: trunk
2012-01-19
16:57
Make the use and function of SQLITE_DYNAMIC clearer. Add assert() statement to help ensure that SQLITE_DYNAMIC is not misused. check-in: ab80f2c3 user: drh tags: trunk
2012-01-18
18:22
Avoid overriding the malloc_usable_size symbol using the C preprocessor as this might be confusing the build on some systems. check-in: bbaec351 user: drh tags: trunk
12:46
Add the SQLITE_WITHOUT_MSIZE and SQLITE_WITHOUT_ZONEMALLOC macros in mem1.c to disable the use of _msize() on windows and the zone memory allocator on Apple products, respectively. check-in: 238e35a4 user: drh tags: trunk
01:14
Remove a redundant assignment from the VM. check-in: d0dabe2f user: drh tags: trunk
01:09
Fix typo in comment. check-in: 199edb68 user: mistachkin tags: trunk
2012-01-17
15:29
Remove the undocumented PRAGMA omit_readlock hack. check-in: 96900c47 user: drh tags: trunk
2012-01-16
16:56
Enhance the command-lin shell to interpret CSV files as described by the wikipedia article on CSV. check-in: 93aa17d8 user: drh tags: trunk