SQLite

Timeline
Login

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

200 most recent check-ins using file configure.ac version 2c06a767

2009-03-31
23:29
update configure script so it has proper VERSION in it (CVS 6419) check-in: ce683cbd user: vapier tags: trunk
13:16
Version 3.6.12 (CVS 6418) check-in: 0db862a2 user: drh tags: trunk, release
03:41
Fix compiler warnings from gcc and MSVC; Correct typo in select.c; (CVS 6417) check-in: 76851417 user: shane tags: trunk
02:54
Make sure a ROLLBACK that follows an incremental vacuum works. Ticket #3761. (CVS 6416) check-in: 8c1d0c6a user: drh tags: trunk
01:32
Remove two unused lines from pcache.c. (CVS 6415) check-in: d5cab05c user: drh tags: trunk
00:50
Added a test case for ticket #3672. (CVS 6414) check-in: 7f40576d user: drh tags: trunk
2009-03-30
18:50
Fix a case where a pointer map page was not being journalled before a file truncation that occurs as part of an incremental vacuum. (CVS 6413) check-in: c5890935 user: danielk1977 tags: trunk
17:19
Add a comment to the pageReinit() routine explaining why the return code from sqlite3BtreeInitPage() is ignored. Comment change only - no changes to code. (CVS 6412) check-in: 10f605be user: drh tags: trunk
13:53
Modify integrity-check to prevent a buffer overread when dealing with a corrupted database. (CVS 6411) check-in: 3c9097f1 user: danielk1977 tags: trunk
13:04
Make sure recursive calls to winOpen() preserve the pVfs pointer. Fault found while testing a mingw build in VMWare. (CVS 6410) check-in: 18b44f0d user: drh tags: trunk
12:56
Avoid calls to newer TCL interfaces in the test logic. This helps the TCL test harness compile without warnings and link when using older versions of the TCL library. (CVS 6409) check-in: 1ad17637 user: drh tags: trunk
12:42
Avoid all use of the "LL" suffix for long-long integer literals. Ticket #3759. (CVS 6408) check-in: 7ef36935 user: drh tags: trunk
11:59
Display a warning that the notify2-3 test sometimes fails on single-core machines. (CVS 6407) check-in: ab7c718d user: drh tags: trunk
07:39
Another change related to (6401) and (6402): When an attempt to unlock a file fails in os_unix.c, close all files held open waiting for the unlock event anyway. This prevents a file-descriptor leak when testing IO errors. (CVS 6406) check-in: 50fbcdea user: danielk1977 tags: trunk
2009-03-29
15:12
Add a comment to the doubleToInt64() routine that explains why returning minInt is in fact correct when it seems like maxInt should be returned. (CVS 6405) check-in: 7f3be360 user: drh tags: trunk
00:15
Turn off the debugging macros in where.c - left on by mistake in the previous check-in. (CVS 6404) check-in: b601a575 user: drh tags: trunk
00:13
Improvements to cost estimation for evaluating the IN operator. Ticket #3757. (CVS 6403) check-in: 0c438e81 user: drh tags: trunk
2009-03-28
23:47
Previous commit ((6401)) did not quite fix the problem. This should work better. (CVS 6402) check-in: 2e7d3cc9 user: drh tags: trunk
23:23
In the unix-backend, when simulating an I/O error on an unlock operation, still mark the connection as unlocked to avoid a future assert(). (CVS 6401) check-in: fb35cff8 user: drh tags: trunk
18:56
The test_async.c module must pass an unchanging filename to the underlying VFS. (CVS 6400) check-in: d1eeee21 user: drh tags: trunk
17:21
Fix thread related problems in test modules test_async.c and test_journal.c. (CVS 6399) check-in: 45df27a2 user: danielk1977 tags: trunk
15:04
Back out check-in (6380). Replace it with a proper fix to the xFullPathname method in the async VFS. (CVS 6398) check-in: 767a7f7b user: drh tags: trunk
10:54
The fix in (6395) was not correct. Fix #3756 a different way. (CVS 6397) check-in: 9278f7b1 user: danielk1977 tags: trunk
07:03
Fix a couple of test script bugs. No changes to SQLite code. (CVS 6396) check-in: c9fa329f user: danielk1977 tags: trunk
06:59
Fix readDbPage() so that if an SQLITE_IOERR_SHORT_READ is encountered, the page content is zeroed. Ticket #3756. (CVS 6395) check-in: 647e3b15 user: danielk1977 tags: trunk
2009-03-27
15:26
When "PRAGMA case_sensitive_like" is invoked, override all existing "LIKE" functions, including UTF-16 versions. (CVS 6394) check-in: 1c6521e5 user: danielk1977 tags: trunk
12:44
Fix another compiler warning in the test logic of tclsqlite.c. (CVS 6393) check-in: 47ffc4dc user: drh tags: trunk
12:32
Fix some compiler warnings in test code. (CVS 6392) check-in: a43ecc9c user: drh tags: trunk
09:10
Fix an incompatibility between the test_async.c backend and change (6390). (CVS 6391) check-in: 6762625d user: danielk1977 tags: trunk
2009-03-26
17:13
Check that the first byte of a potentially hot journal file is non-zero before beginning hot-journal rollback. Fix for #3751 and #3745. (CVS 6390) check-in: 80241a05 user: danielk1977 tags: trunk
14:48
Prevent the tcl test suite from throwing an exception when a threadsafe SQLite is linked against a non-threadsafe Tcl for testing. Print a warning instead. Ticket #3753. (CVS 6389) check-in: a22e7c81 user: danielk1977 tags: trunk
12:20
Added new tests of the scratch memory allocator for increased test coverage. (CVS 6388) check-in: e99e28ef user: drh tags: trunk
11:49
Ensure that the test vfs in test_journal.c zeroes sqlite3_file.pMethods if an xOpen() call fails. Similar problem to that fixed by #6384. This was a problem with test code, not SQLite itself. (CVS 6387) check-in: 45ae830d user: danielk1977 tags: trunk
2009-03-25
16:51
Remove an unused parameter from sqlite3DequoteExpr. Fix another unrelated and harmless compiler warning. (CVS 6386) check-in: 8589b0fc user: drh tags: trunk
15:43
Fix a problem preventing sqlite3_extended_errcode() from working correctly. (CVS 6385) check-in: de469c46 user: danielk1977 tags: trunk
14:24
When a VFS.xOpen fails, make sure the pMethods pointer is zeroed on the sqlite3_file object so that subsequent xClose() operations against that same file handler are no-ops. Bug in the test_async.c module only - not in the core library. Ticket #3744. (CVS 6384) check-in: c32b4541 user: drh tags: trunk
01:06
Use fdatasync() only on linux, unless -Dfdatasync=fdatasync is set at compilation time. (CVS 6383) check-in: cbf2ca4c user: drh tags: trunk
2009-03-24
18:42
Change OS_UNIX to SQLITE_OS_UNIX in test_thread.c. Modify notify2.test to print out its timings in addition to reporting success or failure. (CVS 6382) check-in: 940d72d2 user: drh tags: trunk
17:43
Get the OOM tester in async2.test working again. (CVS 6381) check-in: f398a2d1 user: drh tags: trunk
16:55
Adjust the lock.test and lock3.test scripts so that they work with the asynchronous VFS. (CVS 6380) check-in: 40df926b user: drh tags: trunk
16:27
Include sqliteInt.h in test_async.c so that the asynchronous VFS tests will run even if SQLITE_OS_UNIX is not explicitly defined. (CVS 6379) check-in: 29b0d6a3 user: drh tags: trunk
15:31
New assert()s added to verify that the Expr.token value is used correctly. Ticket #3743. (CVS 6378) check-in: cf3d84ab user: drh tags: trunk
15:08
Changes to insure that lookaside memory allocations are never used to hold schema content. Ticket #3743. (CVS 6377) check-in: ea74d8dc user: drh tags: trunk
04:46
Add a comment to prepare.c explaining why the lookaside buffer is disabled before sqlite3_exec() is called to parse a schema statement. No code changes. (CVS 6376) check-in: 8ca6a665 user: danielk1977 tags: trunk
2009-03-23
21:37
Clarify the meaning of a comment. No changes to code. (CVS 6375) check-in: 7c2df04b user: drh tags: trunk
17:49
Add asserts to make sure that database connection locks are held when accessing the lookaside memory allocation buffers. No defects were found. (CVS 6374) check-in: 8a9f3e66 user: drh tags: trunk
17:11
Fix an obscure race condition that can occur when multiple threads, shared cache and DDL statements are combined. Enhance notify2.test to test this scenario. (CVS 6373) check-in: 92ec5975 user: danielk1977 tags: trunk
04:33
Use the ROUND8() macro to round an integer up to the nearest multiple of 8 and ROUNDDOWN8() macro to round down to the nearest multiple of 8. This is a cosmetic change. (CVS 6372) check-in: db1d4d2f user: danielk1977 tags: trunk
02:34
Fix compiler warning in MSVC. (CVS 6371) check-in: 83a4d5b3 user: shane tags: trunk
2009-03-22
20:36
Allow the keyword INDEXED to be used as the name of a table or index or column - for backwards compatibility. (CVS 6370) check-in: 53149c9f user: drh tags: trunk
2009-03-21
16:19
Update comments in build.c to conform to the latest implementation. (CVS 6369) check-in: a915e8e0 user: drh tags: trunk
14:56
Rig the unix backend to use fdatasync() by default, without having to set the HAVE_FDATASYNC macro. Systems that do not support fdatasync() can be compiled using -Dfdatasync=fsync. (CVS 6368) check-in: a3315627 user: drh tags: trunk
14:41
On unix, always use fdatasync() instead of fsync() when available, even if the file size changes, since (we are told) fdatasync() will automatically flush the inode when the file size changes. (CVS 6367) check-in: 0d6b11bc user: drh tags: trunk
2009-03-20
15:16
Add a test to try to hit the race-condition fixed by (6363). (CVS 6366) check-in: 4310411f user: danielk1977 tags: trunk
14:42
Fix an assert failure introduced by (6355). (CVS 6365) check-in: a08324d1 user: danielk1977 tags: trunk
14:18
Make sure struct WhereClause is aligned on an 8-byte boundary. Fix for #3613, #3736. (CVS 6364) check-in: 093a0cf4 user: danielk1977 tags: trunk
13:15
Rename the unused MEM2 static mutex to OPEN and reuse it to serialize access to the sqlite3BtreeOpen() routine to prevent a race condition on detection of sharable caches. Ticket #3735. (CVS 6363) check-in: 19fa5a29 user: drh tags: trunk
10:24
Fix a problem in thread005.test cause errors on osx. (CVS 6362) check-in: 56e6fca1 user: danielk1977 tags: trunk
09:09
Fix a problem in loadext.test causing an error on OSX. This is not a real problem, just a case of the test script expecting a slightly different error message than the one returned. (CVS 6361) check-in: 18680989 user: danielk1977 tags: trunk
2009-03-19
18:51
Fix a couple of fairly obscure cases where an assert() could fail following a malloc failure. (CVS 6360) check-in: cc0d9256 user: danielk1977 tags: trunk
07:58
Change sqlite3_step() to return SQLITE_LOCKED if a statement cannot be re-compiled due to locks on the shared-cache schema. Also add a blocking wrapper of sqlite3_prepare_v2() to the test code. (CVS 6359) check-in: e8be1af9 user: danielk1977 tags: trunk
2009-03-18
18:43
Fix a crash that could occur when creating an index in shared-cache mode with lookaside enabled. (CVS 6358) check-in: 097737e3 user: danielk1977 tags: trunk
13:55
Modify test script backup2.test so that it works on OSX. (CVS 6357) check-in: d82e8cd4 user: danielk1977 tags: trunk
10:36
Add comments and testcase() macros to the fix for shared-cache schema default value problem of check-in (6353). (CVS 6356) check-in: 05d8607d user: drh tags: trunk
10:33
Fix some cases where executing SQL from within a user-function callback could cause problems related to statement-transactions. (CVS 6355) check-in: a60f4191 user: danielk1977 tags: trunk
2009-03-17
22:33
Move the rowid cache out of VdbeCursor and into BtCursor. When multiple BtCursors are open on the same table, set their rowid cache all at the same time. Ticket #3731. (CVS 6354) check-in: 18978583 user: drh tags: trunk
17:49
Fix a problem that could cause a crash when a shared-cache schema contains column default values. (CVS 6353) check-in: afadddc3 user: danielk1977 tags: trunk
15:39
Fix test script bugs in the thread002.test and thread_common.tcl. (CVS 6352) check-in: d137e841 user: drh tags: trunk
2009-03-16
17:07
Make sure the finished() array in thread005.test is cleared before the script starts. (CVS 6351) check-in: ddadc25d user: drh tags: trunk
14:48
Modify quick.test to support the QUICKTEST_INCLUDE environment variable, which can be used to override the built-in EXCLUDE list. (CVS 6350) check-in: fdfe22f0 user: danielk1977 tags: trunk
13:37
Additional hyperlinks in the sqlite3_unlock_notify() documentation. (CVS 6349) check-in: 4dae5f6e user: drh tags: trunk
13:19
Add the sqlite3_unlock_notify() API. (CVS 6348) check-in: b649a6cc user: danielk1977 tags: trunk
12:30
Bump the version number to 3.6.12. (CVS 6347) check-in: 2fcccca3 user: drh tags: trunk
10:59
Remove surplus white space from shell.c. Use strlen30() instead of strlen(). (CVS 6346) check-in: 324a1aff user: drh tags: trunk
2009-03-14
08:37
Fix for #3719. When synthesizing a CREATE TABLE statement as as result of a "CREATE TABLE AS", quote the column type names unless they are simple identifiers or simple identifiers followed by one or two dimensions (e.g. "VARCHAR(10)"). (CVS 6345) check-in: 7c6437ef user: danielk1977 tags: trunk
2009-03-13
15:32
Do not overrun a buffer in the genfkey code (now part of shell.c). Fix for #3722. (CVS 6344) check-in: 943b11fb user: danielk1977 tags: trunk
2009-03-12
15:43
Avoid fts3 crash on (MATCH '""') expressions. Ticket #3717. (CVS 6343) check-in: 03679857 user: danielk1977 tags: trunk
14:43
Make calls to sqlite3BtreeRollbackStmt() no-ops when passed a Btree* handle that does not have an open statement transaction. Ticket #3718. (CVS 6342) check-in: a1bb1aef user: danielk1977 tags: trunk
2009-03-05
14:59
Begin purging dirty pages from the cache once 90% of the cache is dirty (insteadof waiting until it is 100% dirty). This improves performance in some circumstances by effectively reserving 10% of the configured page-cache for frequently reused read-only pages. (CVS 6341) check-in: 823fe7f5 user: danielk1977 tags: trunk
14:53
Comment out a recently added assert statement that is failing. (CVS 6340) check-in: d0b2015f user: danielk1977 tags: trunk
05:54
Implemented winSectorSize(); Other changes for consistency. os_win.c. Ticket #2931. (CVS 6339) check-in: 68abcb27 user: shane tags: trunk
04:27
Changes to cleanup and improve the consistency of tests for large file support in bigfile.test. (CVS 6338) check-in: 3dbdf680 user: shane tags: trunk
04:23
Added some asserts and a check for a null pointer dereference. (CVS 6337) check-in: 6b0cabd0 user: shane tags: trunk
04:20
Corrected typos and misspellings. Ticket #3702. (CVS 6336) check-in: 6404afa0 user: shane tags: trunk
03:48
Removed compiler warnings from MSVC builds. Ticket #3701. (CVS 6335) check-in: 5477833e user: shane tags: trunk
2009-03-02
17:18
Converted EXPR_*SIZE macros to use offsetof() to avoid MSVC compiler warnings. (CVS 6334) check-in: 5e8e16f7 user: shane tags: trunk
14:24
Fix the SQLITE_ENABLE_UPDATE_DELETE_LIMIT option for the new Expr compression logic of check-in (6305). Bug discovered during regression testing. (CVS 6333) check-in: 91969eda user: drh tags: trunk
01:22
Fix a bug in the GROUP BY alias name resolution. The bug was by check-in (6305). Discovered by regression test on 64-bit linux. Test cases added so that the problems is detected on 32-bit systems. (CVS 6332) check-in: fa000850 user: drh tags: trunk
2009-03-01
22:29
Suppress some compiler warnings (where possible). Ticket #3696. (CVS 6331) check-in: a2373e54 user: drh tags: trunk
19:42
Fix a critical bug in the VDBE opcode array resizer introduced by check-in (6307). Bug detected by regression testing. (CVS 6330) check-in: ec3b18ac user: drh tags: trunk
2009-02-28
10:47
Instead of linking temporary triggers on non-temporary tables into the Table.pTrigger list, search the temp schema for them on demand. Fix for #3688. (CVS 6329) check-in: 3befe1ef user: danielk1977 tags: trunk
2009-02-26
07:15
In sqlite3_table_column_metadata(), hold the mutex on all attached BtShared objects while accessing schema objects. Fix for #3679. (CVS 6328) check-in: d197afd6 user: danielk1977 tags: trunk
2009-02-25
19:07
Move the new genfkey shell command out from within #ifdef _WIN32_ (CVS 6327) check-in: 48ee0e47 user: drh tags: trunk
15:43
Remove genfkey.c. Change genfkey.README to talk about the new shell dot-command, not the old standalone genfkey program. (CVS 6326) check-in: 36d69966 user: danielk1977 tags: trunk
15:22
Add the 'genfkey' functionality to the sqlite3 shell. Accessed using a new dot-command - ".genfkey". (CVS 6325) check-in: 0a59fb28 user: danielk1977 tags: trunk
08:56
Minor changes and coverge tests for "SELECT count(*)" optimization. (CVS 6324) check-in: a3695b98 user: danielk1977 tags: trunk
2009-02-24
19:21
Additional commands and another procedure name changes for clarity of presentation. No logic changes. (CVS 6323) check-in: 91d9d51e user: drh tags: trunk
18:57
Changes to comments and functions/procedure names for clarification. No changes to logic. (CVS 6322) check-in: b99c1815 user: drh tags: trunk
18:40
Remove old declaration of sqlite3_pending_byte (which was used by test code). It has been replaced by sqlite3PendingByte. Ticket #3677. (CVS 6321) check-in: 44f0162e user: danielk1977 tags: trunk
18:33
Fixes and some extra test cases for count(*) optimization. (CVS 6320) check-in: 3f0baa1b user: danielk1977 tags: trunk
16:18
Enhanced comments on table locking logic as it relates to preparing new statements. Added assert() and testcase() but no other changes to code. (CVS 6319) check-in: 4a12f5b8 user: drh tags: trunk
10:48
Add test file test/count.test for testing "SELECT count(*)" statements. It is not properly populated yet. (CVS 6318) check-in: a195d74f user: danielk1977 tags: trunk
10:14
Reverse commit (6315) for now. (CVS 6317) check-in: 0e7c369c user: danielk1977 tags: trunk
10:01
Optimize queries of the form "SELECT count(*) FROM <tbl>" by adding a sqlite3BtreeCount() interface to the btree layer. (CVS 6316) check-in: d4aa6593 user: danielk1977 tags: trunk
2009-02-23
17:33
Scan an index instead of a table for "SELECT count(*) FROM <tbl>" queries. Because an index is usually smaller than a table on disk, this saves some IO. (CVS 6315) check-in: 294ba6f7 user: danielk1977 tags: trunk
16:52
Add the reverse_unordered_selects pragma. (CVS 6314) check-in: bc078e00 user: drh tags: trunk
14:42
Ensure the return value of sqlite3_errmsg16() is aligned on a 2-byte boundary. Ticket #3665. (CVS 6313) check-in: 9b8acf83 user: danielk1977 tags: trunk
2009-02-21
22:38
The sqlite3.def file is automatically generated and is not suppose to be part of the source code repository. So it is hereby removed. Ticket #3671. (CVS 6312) check-in: 5dcda154 user: drh tags: trunk
2009-02-20
22:27
unbreak Autoconf-based build procedure by added missing backup.lo to the list of library objects (CVS 6311) check-in: 94945801 user: rse tags: trunk
10:58
Instead of using SetNumColumns, specify the number of columns in a table or index using the P4 argument. (CVS 6310) check-in: e43ed649 user: danielk1977 tags: trunk
03:55
Add a count parameter to the OP_Variable opcode and use it to simplify prepared statements that copy consecutive unnamed parameters into consecutive registers (a common case). (CVS 6309) check-in: 48b77b04 user: drh tags: trunk
03:02
Add the OP_HaltIfNull opcode and use it to simplify prepared statements for INSERTs and UPDATEs of tables with NOT NULL columns. (CVS 6308) check-in: feccad8d user: drh tags: trunk
01:28
Reuse space left-over opcode space at the end of the VDBE opcode array to store memory cells, VDBE cursors, and other content needed by the VDBE. This reduces the memory required by a prepared statement. (CVS 6307) check-in: 58a18092 user: drh tags: trunk
2009-02-19
20:50
Remove code in malloc.c that was already commented out using #if 0. (CVS 6306) check-in: e1ad757e user: drh tags: trunk
14:39
Changes to reduce the heap space consumed by triggers, views and tables in the in-memory representation of the schema. Also to reduce the space used by prepared statements slightly. (CVS 6305) check-in: d9f6ffbc user: danielk1977 tags: trunk
2009-02-18
20:31
Make sure the auto_vacuum=INCREMENTAL setting is preserved across a VACUUM. Ticket #3663. (CVS 6304) check-in: ded04f12 user: drh tags: trunk
18:37
Move the text of C-API requirements out of the sqlite.h.in source file and into separate files in the "docsrc" CM system. Comment changes only - no changes to code. (CVS 6303) check-in: 419eb48b user: drh tags: trunk
12:25
Fix the amalgamation builder to mark sqlite3PagerBackupPtr as private. Ticket #3662. (CVS 6302) check-in: fb281950 user: drh tags: trunk
04:35
run autoconf so the updated version is in the configure script (CVS 6301) check-in: edbb3586 user: vapier tags: trunk
04:34
break libsqlite3.la install step out so the tcl install step can depend on it as well (CVS 6300) check-in: 0998c554 user: vapier tags: trunk
00:00
Version 3.6.11 (CVS 6299) check-in: 6abd630c user: drh tags: trunk, release
2009-02-17
18:37
Add tests to double-check that nothing within SQLite ever tries to allocate amounts of memory that are close to the maximum signed integer, leading to an integer overflow within malloc(). This is not currently a problem. The extra tests just insure it never becomes a problem. (CVS 6298) check-in: f6ba7bb9 user: drh tags: trunk
17:56
Initialize an uninitialized buffer to silence a valgrind warning during a VACUUM operation. (CVS 6297) check-in: 8c61968b user: danielk1977 tags: trunk
16:29
Allow sqlite3_shutdown() to be called by a process before sqlite3_initialize() is. Prior to this commit such a call could segfault. (CVS 6296) check-in: 79431c58 user: danielk1977 tags: trunk
16:17
Make sure result variables are initialized or unused following a failure of the xFullPathname VFS interface. Problem detected by valgrind. (CVS 6295) check-in: 59a47551 user: drh tags: trunk
2009-02-16
17:55
Changes to remove some compiler warnings from MSVC. (CVS 6294) check-in: 68f15442 user: shane tags: trunk
16:23
Fix a compiler warning in backup.c. (CVS 6293) check-in: 82222fbf user: drh tags: trunk
2009-02-13
16:59
Make sure OOM errors in the ANALYSIS loader get reported back out to high-level layers. Strange behavior can result otherwise. (CVS 6292) check-in: 88a6355c user: drh tags: trunk
03:43
Correctly handle attempts to add a UNIQUE or PRIMARY KEY column using the ALTER TABLE statement. Ticket #3651. (CVS 6291) check-in: dd179ff2 user: drh tags: trunk
2009-02-12
17:07
Add additional cross-references from API documentation to other documents. Comment changes only; no changes to code. (CVS 6290) check-in: 97203a0a user: drh tags: trunk
17:06
Update thread tests to clear the sqlite_open_file_count counter at the end. This counter is not threadsafe and can end up with an invalid value at the end of the thread tests. (CVS 6289) check-in: 8c4d71a1 user: drh tags: trunk
17:01
Fix some edge cases with backing up databases that are exactly PENDING_BYTE bytes in size, or just slightly larger. (CVS 6288) check-in: 2fc450e8 user: danielk1977 tags: trunk
09:36
Modify lock.test to account for "PRAGMA lock_status" returning "unknown" for in-memory databases. (CVS 6287) check-in: 9a6e558b user: danielk1977 tags: trunk
09:11
Fix a case where during a rollback triggered by an IO or malloc error an unjournalled region of the database could be written to (with it's original data). This was causing an assert in test_journal.c to fail. Add a test case in ioerr2.test to trigger this case. (CVS 6286) check-in: 315a6692 user: danielk1977 tags: trunk
2009-02-11
16:06
Updated for Windows compatibility. Test scripts only. (CVS 6285) check-in: 2522ad1d user: shane tags: trunk
15:23
Continuing documentation refinements. Comment changes only. (CVS 6284) check-in: 83e83084 user: drh tags: trunk
15:11
Fix the backup.test script so that it works regardless of the value of SQLITE_TEMP_STORE and the initial contents of the file-system. (CVS 6283) check-in: da660ea7 user: danielk1977 tags: trunk
15:04
Add hyperlinks from sqlite3_limit() documention to the limits.html page. Comment changes only - no changes to code. (CVS 6282) check-in: f0189ec8 user: drh tags: trunk
14:27
Fix the crashtest infrastructure so that it doesn't trigger the "don't write to the locking region" assert in os_unix.c. (CVS 6281) check-in: b7fd4615 user: danielk1977 tags: trunk
07:38
Modify the test_journal.c code to (1) account for the backup code writing to parts of the pending-byte page when changing a databases page-size, and (2) to avoid reading from the pending-byte page and triggering the assert in os_unix.c. Changes to test code only. (CVS 6280) check-in: 48796216 user: danielk1977 tags: trunk
05:18
In test_mutex.c, zero the global structure staticly instead of in Sqlitetest_mutex_Init(). This is because Sqlitetest_mutex_Init() is now called by each thread during thread tests ((6193)). Test code changes only. (CVS 6279) check-in: 8b318b93 user: danielk1977 tags: trunk
2009-02-10
18:54
For the "onefile" demo, pass SQLITE_OPEN_TEMP_DB instead of MAIN_DB to the OS layer when opening the single file. This is to work around the assert() in os_unix.c that tests that the locking region is not written to. (CVS 6278) check-in: 2da076a2 user: danielk1977 tags: trunk
14:45
Reduce the number of iterations in one of the savepoint4.test crash tests. (CVS 6277) check-in: fafb07b8 user: danielk1977 tags: trunk
14:28
Prevent code in test6.c from reading the 512 byte locking region (the PENDING_BYTE page) of a database file. Doing so triggers an assert failure in os_unix.c. (CVS 6276) check-in: 2a6a4316 user: danielk1977 tags: trunk
13:41
Create links from backup API documentation to the backup application note. Comment changes only - no changes to code. (CVS 6275) check-in: 85de23fb user: drh tags: trunk
11:17
Reenable triggering vdbe tracing by creating file-system entries. Add a (redundant) test that modifying the temp schema expires all prepared statements. (CVS 6274) check-in: f6590dac user: danielk1977 tags: trunk
10:44
Do not always open a transaction on the temp database when writing to the main or another attached database. (CVS 6273) check-in: f76b0b81 user: danielk1977 tags: trunk
05:45
Fix a bug in test file misc7.test. No code changes. (CVS 6272) check-in: d919d2a1 user: danielk1977 tags: trunk
2009-02-09
18:55
Fix a problem in backup.c causing OsTruncate() to be called with an argument larger than the current file-size. (CVS 6271) check-in: b34bde80 user: danielk1977 tags: trunk
17:34
Add assert() statements to os_unix.c which fire if there is a read or write for the locking region of a database file. (CVS 6270) check-in: 93e792ff user: drh tags: trunk
13:19
Better error message when DISTINCT is used on an aggregate function that takes two or more arguments. Ticket #3641. (CVS 6269) check-in: e20bf384 user: drh tags: trunk
05:32
Ignore the return structure of and F_GETLK fcntl() call on djgpp. Fix for #3642. (CVS 6268) check-in: 8227af34 user: danielk1977 tags: trunk
05:18
Attempt to reproduce ticket #3643. No luck yet. (CVS 6267) check-in: 8f2f98d2 user: danielk1977 tags: trunk
2009-02-06
05:59
Changes to the backup API: (1) if a negative number is passed as the second argument to backup_step(), this is interpreted as "copy all remaining pages" and (2) if backup_finish() is called after backup_step() fails with a BUSY or LOCKED error, then this error is also returned by backup_finish() (same handling as for other errors encountered by backup_step()). (CVS 6266) check-in: 9b8c8b18 user: danielk1977 tags: trunk
2009-02-05
17:00
Fix a test case that was still using the old pending_byte mechanism. (CVS 6265) check-in: 08ec4f2c user: drh tags: trunk
16:53
Fix the declaration of sqlite3PendingByte so that it works with the amalgamation. (CVS 6264) check-in: 193c871f user: drh tags: trunk
16:31
Make the pending byte adjustable via sqlite3_test_control() on all builds, not just on test builds. (CVS 6263) check-in: e8f192e2 user: drh tags: trunk
03:16
Fixed error detection in winTrucate() in os_win.c. Windows version only. Ticket #3640. (CVS 6262) check-in: 82e03f1b user: shane tags: trunk
03:00
Improved overrun detection in mem2.c (SQLITE_MEMDEBUG). Previously was only checking up to 3 extra bytes allocated due to rounding. (CVS 6261) check-in: a6fe3d6b user: shane tags: trunk
2009-02-04
22:46
Add "backup" and "restore" methods to the TCL interfaces and test cases to exercise those methods. (CVS 6260) check-in: e420a3ce user: drh tags: trunk
20:55
Add ".backup" and ".restore" commands to the CLI - implemented using the new backup API. (CVS 6259) check-in: 003e1d62 user: drh tags: trunk
20:08
Increase the version number to 3.6.11. (CVS 6258) check-in: 0882a028 user: drh tags: trunk
19:16
If the truncate operation fails in journalmode=TRUNCATE, do not fall back to overwriting the journal header with zeros. Simply fail the operation. (CVS 6257) check-in: d4af60e5 user: drh tags: trunk
17:40
Simplify wording of backup API error message. Decapitalize some other error messages. (CVS 6256) check-in: f92405af user: drh tags: trunk
16:56
The sqlite3_backup_init() interface must lock the destination in case it needs to change the error message. (CVS 6255) check-in: 572378d3 user: drh tags: trunk
15:27
Fix a bug in test_malloc.c whereby running multi-threaded test cases could cause subsequent OOM tests to fail. (CVS 6254) check-in: 03ea9e59 user: danielk1977 tags: trunk
11:57
Ensure that thread001.test and thread002.test reset the global shared-cache-enabled setting before they finish. (CVS 6253) check-in: 416288a9 user: danielk1977 tags: trunk
10:09
Do not attempt to use the sub-journal file descriptor if it is not opened (as in journal_mode=off mode). Ticket #3636. (CVS 6252) check-in: 20bd7605 user: danielk1977 tags: trunk
08:17
Fix a bug in malloc.test causing the exclusive permutation to fail. Changes to test code only. (CVS 6251) check-in: 72745bde user: danielk1977 tags: trunk
03:59
Changes to completely remove all floating point ops if SQLITE_OMIT_FLOATING_POINT defined. Note that w/o fp, date/time, round, nan, etc. are all gone or limited in functionality. Updated some of the test scripts to support missing fp and 64-bit functionality. Ticket #3029. (CVS 6250) check-in: 5cef4000 user: shane tags: trunk
01:49
Remove compiler warnings under MSVC. (CVS 6249) check-in: 6301f08a user: shane tags: trunk
2009-02-03
22:51
Correction to check-ins (6246) and (6247): The backup object might not hold a valid destination connection pointer. Also, do not reset the page cache when establishing a read-lock while there is a persistent or truncated journal, only if there is a journal that really needs to rollback. Otherwise backups always reset whenever the source database file is read. (CVS 6248) check-in: 7f827ba9 user: drh tags: trunk
22:17
A backup must clear the internal schema of the destination database so that the schema will be reloaded for the next sqlite3_prepare() (CVS 6247) check-in: 76f23a43 user: drh tags: trunk
21:13
Must hold mutex on the destination during backups. Add documentation to warn programmers that attempting to use the destination connection during a backup can lead to deadlock. (CVS 6246) check-in: 5f6c06b9 user: drh tags: trunk
19:55
Fixed postToParent() return type (Tcl_ThreadCreateType) in test_thread.c to compile with MSVC. Removed a few compiler warnings. Test harness change only. (CVS 6245) check-in: e9475aba user: shane tags: trunk
19:52
Fix buffer size in md5_cmd() in test_md5.c. Test harness change only. (CVS 6244) check-in: c1e15717 user: shane tags: trunk
18:47
More adjustments to the backup API documentation. No changes to code. (CVS 6243) check-in: ca650879 user: drh tags: trunk
18:25
Tweaks to the backup API documentation contained in comments. No changes to code. (CVS 6242) check-in: 6298bcca user: drh tags: trunk
16:51
Commit first version of the 'backup' feature. (CVS 6241) check-in: 663479b4 user: danielk1977 tags: trunk
16:25
Fix the sqlite3_mprintf_long test command (added by check-in (6224) in order to address ticket #3621) so that it works on systems with sizeof(int)==4 and sizeof(long)==8. (CVS 6240) check-in: 2e45c2a8 user: drh tags: trunk
15:50
Remove several compiler warnings. (CVS 6239) check-in: 85e9196d user: drh tags: trunk
15:39
Remove the text of the sqlite3VdbeMemSanity() routine, which was already commented out. (CVS 6238) check-in: a3c26077 user: drh tags: trunk
15:27
Check at the write() call to work around the msdos bug in OSX actually succeeds and throw an error if it does not. #ifdef out the work-around for all platforms other than OSX. Ticket #3633. (CVS 6237) check-in: b054b569 user: drh tags: trunk
13:51
Add a special rule to the amalgamation generator to deal with the sqlite3OsDlSym function. Ticket #3631. (CVS 6236) check-in: 876f874c user: drh tags: trunk
13:19
Fix a problem in check-in (6226) which could cause an assertion fault following a malloc failure. The prior check-in was for ticket #3624. (CVS 6235) check-in: 1ffe44e9 user: drh tags: trunk
13:10
Check-in (6230) introduced a bugs in SUBSTR() which was caught by the fuzz tester. Fixed by this check-in. Related to ticket #3628. (CVS 6234) check-in: cd2e7f6c user: drh tags: trunk
2009-02-02
21:57
Make group_concat() a 1- or 2-value function, as the documentation says it should be. Use the md5sum() function to verify ticket #3179, not group_concat(). This undoes the ill-advised group_concat() change of check-in (5233). (CVS 6233) check-in: f2ae82c4 user: drh tags: trunk
18:03
Omit the TEMP keyword from the schema of TEMP tables created using CREATE TEMP TABLE AS SELECT ..... Ticket #3630. (CVS 6232) check-in: 3b0a2554 user: drh tags: trunk
17:30
Minor simplifications to SQL function implementations. (CVS 6231) check-in: 92e5c27f user: drh tags: trunk
16:32
Update the SUBSTR function so that works consistently when the 2nd parameter is 0. Ticket #3628. (CVS 6230) check-in: 5fc125d3 user: drh tags: trunk
01:50
Restrict the RANDOM() function to have zero arguments. Ticket #3627. (CVS 6229) check-in: b8b546b6 user: drh tags: trunk
2009-02-01
19:42
Fix SUBSTR() so that it returns NULL if any argument is NULL. Ticket #3626. (CVS 6228) check-in: 779fce82 user: drh tags: trunk
19:23
Fix the SUBSTR() function so that when the 3rd argument is negative, it counts backwards from the selected start point. Ticket #3625. (CVS 6227) check-in: 2217339b user: drh tags: trunk
18:08
Change the replace() function to return a copy of its first argument when the 2nd argument is an empty string. Ticket #3624. (CVS 6226) check-in: ffebf10f user: drh tags: trunk
00:29
Adjust comments in vdbe.c to use OP_MakeRecord instead of the obsolete OP_MakeIdxRec. Ticket #3619. (CVS 6225) check-in: 0d2abbbf user: drh tags: trunk
00:21
Add a new test command, sqlite3_mprintf_long, for testing the behavior of "long integer" printf formatting. Ticket #3621. (CVS 6224) check-in: 3ba1a17b user: drh tags: trunk
00:00
Make the TO keyword available even if SQLITE_OMIT_ALTERTABLE is defined. Ticket #3622. (CVS 6223) check-in: 3890985c user: drh tags: trunk
2009-01-31
22:28
Better error message when coalesce() has too few arguments. Ticket #3623. (CVS 6222) check-in: 9cd43c82 user: drh tags: trunk
14:54
Avoid a segfault when running vacuum on an in-memory database. Ticket #3620. (CVS 6221) check-in: 407830c6 user: danielk1977 tags: trunk
2009-01-30
17:27
Fix a round-off error when moving dates by negative modifier amounts. Ticket #3618. Enhance the "NNN years" modifier to accept fractional years. (CVS 6220) check-in: 86be908c user: drh tags: trunk