/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

100 check-ins occurring around 3a049ca761f36d0f.

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
16:09
Made code to remove unused parameter warning part of the conditional. Ticket #3610. (CVS 6219) check-in: c5dca114 user: shane tags: trunk
06:11
Changes to setupLookaside() in main.c to better handle lookaside buffer configurations of zero-size. Ticket #3616. (CVS 6218) check-in: 0a2c7f74 user: shane tags: trunk
05:59
Implemented the SQLITE_LAST_ERRNO op in the xFileControl() method of os_win.c. Ticket #3615. (CVS 6217) check-in: 9ea871f3 user: shane tags: trunk
05:47
In test case incrvacuum-15.1 close both db handles (db and db2) before attempting to delete test.db. Ticket #3614. (CVS 6216) check-in: e764a7c5 user: shane tags: trunk
05:40
Minor changes to remove a few MSVC compiler warnings at /W3. Ticket #3610. (CVS 6215) check-in: c74c78e4 user: shane tags: trunk
2009-01-29
19:27
Add test cases to make sure that keywords that we say can be used as identifiers really can be used as identifiers. These tests were inspired by ticket #3612, but they do not directly address ticket #3612. (CVS 6214) check-in: 6041ca87 user: drh tags: trunk
02:54
add a cvsignore file (CVS 6213) check-in: 68c8cdd7 user: vapier tags: trunk
2009-01-28
20:21
Fix a segfault that can occur when attempting to insert into a corrupt database file. Need a test case. (CVS 6212) check-in: 68957cf0 user: drh tags: trunk
04:46
regenerate autotools (CVS 6211) check-in: 813a3c96 user: vapier tags: trunk
04:46
unify TCLLIBDIR handling with libtclsqlite3.so and use libtool to install it rather than custom tclinstaller.tcl ... this integrates better with autotools and avoids relinking issues (RPATH pointing to builddir) (CVS 6210) check-in: 3a049ca7 user: vapier tags: trunk
02:55
Add testcase() macros for coverage in date.c. (CVS 6209) check-in: 90b42eba user: drh tags: trunk
2009-01-26
21:43
use AC_MSG_xxx funcs rather than `echo` (CVS 6208) check-in: ed08025a user: vapier tags: trunk
21:39
(#3449) search for tclConfig.sh first by asking tclsh itself where it is (CVS 6207) check-in: ff2912dc user: vapier tags: trunk
21:25
(#1428) installed shared libs with exec perms (CVS 6206) check-in: 3f2a3414 user: vapier tags: trunk
20:59
(#3583) add a rule for sqlite3.pc in case the .in file is updated (CVS 6205) check-in: 4d03b693 user: vapier tags: trunk
2009-01-24
15:23
Remove obsolete files from the tools subfolder. (CVS 6204) check-in: d7456080 user: drh tags: trunk
11:30
Fix some minor compiler warnings. Added sqlite3Isalpha() for use in the soundex() function. (CVS 6203) check-in: bfc71edc user: drh tags: trunk
09:56
Remove incorrect ALWAYS macro associated with empty IN() sets. Ticket #3602. (CVS 6202) check-in: f3c09a0c user: danielk1977 tags: trunk
2009-01-23
16:45
Optimization: When loading a new page into the cache, avoid redundant memset() calls to zero it. (CVS 6201) check-in: 9c0b9f88 user: danielk1977 tags: trunk
2009-01-22
23:04
Fix the VACUUM command so that it does not commit a transaction when it is mistakenly run within a transaction - it should leave the transaction open. (CVS 6200) check-in: 75cc709b user: drh tags: trunk
17:12
Silence a C++ builder warning by writing "if( (rc = function())!=SQLITE_OK )" instead of "if( (rc = function()) )" in two places in pager.c. Ticket #3605. (CVS 6199) check-in: 78ae96de user: danielk1977 tags: trunk
2009-01-21
17:45
Add a comment to fts3_tokenizer.h to make it clear how the xNext() method is supposed to set its output variables. Make sure the output variables of xNext() are only used if SQLITE_OK is returned. Ticket #3604. (CVS 6198) check-in: 5b3c075f user: danielk1977 tags: trunk
2009-01-20
17:06
Big change to make pager.c easier to follow. Unused variables removed, comments improved, etc. (CVS 6197) check-in: 12f7346c user: danielk1977 tags: trunk
16:53
When not compiling for an EBCDIC system, use built-in alternatives to the tolowe r(), toupper() and other ctype.h library functions. Ticket #3597. (CVS 6196) check-in: 1041abd6 user: danielk1977 tags: trunk
2009-01-19
20:49
Make sure the *pzErrMsg return from sqlite3_get_table() is aways zeroed. Ticket #3598. (CVS 6195) check-in: 7035c35d user: drh tags: trunk
18:18
Fix the --enable-tempstore option on the configure script. Ticket #3599 (CVS 6194) check-in: c2eabb99 user: drh tags: trunk
17:40
Make sure mutexes are fully enabled for thread001.test. Take steps to ensure that the thread tests run during regression testing. (CVS 6193) check-in: 6242f113 user: drh tags: trunk
2009-01-17
16:59
Fix a bug that was preventing SQLite from releasing locks properly under obscure circumstances. (CVS 6192) check-in: 502c66df user: danielk1977 tags: trunk
15:53
Back out the Makefile.in changes from check-in (6181) because of reports (ticket #3594) that they do not work on NetBSD. Separately, documentation is updated to make clear that configure and Makefile.in are unsupported. (CVS 6191) check-in: 2d79aaab user: drh tags: trunk
2009-01-16
23:47
Remove a harmless UMR that occurs inside some debugging code. (CVS 6190) check-in: 191c399f user: drh tags: trunk
16:40
Fix a change-counter bug similar to #3584. This one is much more obscure though, requiring a transient IO or malloc error to occur while running in exclusive mode. (CVS 6189) check-in: 9f07d2d9 user: danielk1977 tags: trunk
16:23
Revert (6187). (CVS 6188) check-in: a353c1ab user: danielk1977 tags: trunk
15:21
This commit is an error. Reverted by (6188). (CVS 6187) check-in: aa67fd0c user: danielk1977 tags: trunk
11:04
Allow recently added keywords 'savepoint' and 'release' to be used as database object names. Just as they could be prior to 3.6.8. Ticket #3590. (CVS 6186) check-in: 54ab8326 user: danielk1977 tags: trunk
2009-01-15
17:40
Treat "or" as an ANSI-C keyword, even though it is not. Ticket #3588. (CVS 6185) check-in: ed4e308c user: drh tags: trunk
17:04
Version 3.6.10 (CVS 6184) check-in: 21b720cc user: drh tags: trunk, release, version-3.6.10
15:23
Disable test case select2-2.0.3. This was a timing test that sometimes fails due to CPU contention with other processes on the same host. (CVS 6183) check-in: ffdf91fe user: drh tags: trunk
04:30
Avoid using ENOTSUP on systems that do not define that symbol. Ticket #3512. (CVS 6182) check-in: fcb6c677 user: drh tags: trunk
2009-01-14
23:38
Make some changes requested by Fedora. (CVS 6181) check-in: 7bc08bc7 user: drh tags: trunk
23:17
Fix the shell so that the ".schema" command works regardless of the pragma settings. Ticket #3585. (CVS 6180) check-in: 6f6b638e user: drh tags: trunk
23:03
Add asserts to detect if a transaction commits without first incrementing the transaction counter. These asserts are intended to prevent future problems similar to ticket #3584. (CVS 6179) check-in: b676ccfd user: drh tags: trunk
18:59
Fix typos in comments in FTS3 implementation. (CVS 6178) check-in: b0f06663 user: drh tags: trunk
18:59
Increment the version number in preparation for yet another release. (CVS 6177) check-in: dce60ea7 user: drh tags: trunk
17:45
Fix a problem with committing a transaction while there are other active statements. Sometimes, the database change counter was not being updated. (CVS 6176) check-in: b7d2a477 user: danielk1977 tags: trunk
04:09
Version 3.6.9 (CVS 6175) check-in: b6ce8199 user: drh tags: trunk, release
01:10
Here is the test case to prove that ticket #3581 is fixed. (CVS 6174) check-in: f5f5ef64 user: drh tags: trunk
00:55
Make sure the OR-clause optimizer takes the cost of sorting into account. Reset the rowid cache on the OP_Rewind and OP_Last opcodes. Bump the version number so that we can do an emergency release. Ticket #3581. (CVS 6173) check-in: d28b5820 user: drh tags: trunk
2009-01-13
20:14
Updates to comments as suggested by tickets #3578 and #3579. (CVS 6172) check-in: b5927213 user: drh tags: trunk
16:03
If the journal file is open when unlocking the database, close it just before unlocking the database file instead of just after. This may fix #3572. (CVS 6171) check-in: 36fe9a7a user: danielk1977 tags: trunk
2009-01-12
15:46
Version 3.6.8 (CVS 6170) check-in: 8ca0b7c1 user: drh tags: trunk, release
14:01
Only run tests that depend on SQLITE_PREFER_PROXY_LOCKING builds when said symbol is set. (CVS 6169) check-in: 5d88f8be user: danielk1977 tags: trunk
2009-01-11
18:24
Sometimes a single byte is written to the main database file. Make sure that journaltest knows this. (CVS 6168) check-in: e0af5a43 user: drh tags: trunk
17:00
Fix an assert() so that it works correctly with SQLITE_TEMP_STORE=3. (CVS 6167) check-in: fd2bbcf8 user: drh tags: trunk
05:54
Fix jrnlmode.test so that it does not run tests involving in-memory journals during the "journaltest" permutation. (CVS 6166) check-in: b47ddefc user: danielk1977 tags: trunk
00:44
The crash8.test depends on auto_vacuum being off. Make sure that is the case. (CVS 6165) check-in: 3538d2a9 user: drh tags: trunk
00:42
In io.test, reset the connection after manually deleting the journal file, so that the connection does not continue to use the old deleted journal file. (CVS 6164) check-in: 1e79f4f9 user: drh tags: trunk
00:18
Adjust savepoint.test so that it can deal with SQLITE_TEMP_STORE=3. (CVS 6163) check-in: 3cb910f0 user: drh tags: trunk
2009-01-10
18:51
Do not run crash8.test as part of the "journaltest" permutation. crash8.test uses "PRAGMA synchronous=off", which is incompatible with journaltest. (CVS 6162) check-in: 5f184da6 user: danielk1977 tags: trunk
17:57
Remove the unused Pager.alwaysRollback flag. Fix a couple of comments in pager.c. (CVS 6161) check-in: 8f0672af user: danielk1977 tags: trunk