/ 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 46fdd195483787ee.

2007-06-20
11:56
Additional changes for ticket #2426. (CVS 4098) check-in: 79debf95 user: drh tags: trunk
09:09
Fix for #2432 and partial fix for #2427 (documentation change only). (CVS 4097) check-in: f025a745 user: danielk1977 tags: trunk
08:49
Change main.mk to make it easier to build testfixture and sqlite3 with the icu or fts2 extensions linked in. (CVS 4096) check-in: 91719cc8 user: danielk1977 tags: trunk
06:23
Fix snippet generation when the left-most column of an fts2 table is used in the MATCH clause. Fix for ticket #2429. (CVS 4095) check-in: fec56ad2 user: danielk1977 tags: trunk
2007-06-19
23:01
Change the TCL bindings so that @aaa always treats the variable aaa as a bytearray and binds the value as a BLOB. This change is backwards compatible since the $ behavior is unchanged and @ was not accepted until the current round of changes. (CVS 4094) check-in: 6f7d55ac user: drh tags: trunk
17:48
Cleanup the TCL interface source code and add documentation for recently added methods on the SQLite object of TCL. (CVS 4093) check-in: d88b7981 user: drh tags: trunk
17:15
In the TCL bindings, if a TCL variable has a bytearray representation and the host parameter starts with @ instead of $, then always store the content as a BLOB not as a string even if a string representation is also available. (CVS 4092) check-in: dcb104bd user: drh tags: trunk
15:23
Change the name of the "limits.h" source file to "sqliteLimit.h". Ticket #2428. (CVS 4091) check-in: 64bcc41f user: drh tags: trunk
10:58
Do not segfault even if sqlite is misused by requesting query results after the query has been reset. ticket #2426. (CVS 4090) check-in: 783f19be user: drh tags: trunk
10:50
Cast the 2nd parameter of ftruncate to off_t to work around bugs in some unix implementations. Ticket #2425. (CVS 4089) check-in: 0b20a696 user: drh tags: trunk
2007-06-18
17:44
Another attempt to fix the build process for TCL windows bindings. (CVS 4088) check-in: 1fd2a358 user: drh tags: trunk
17:25
Bring the pager_datahash() macro into sync with its function definition. Ticket #2422. (CVS 4087) check-in: ba967bbb user: drh tags: trunk
16:06
Fix the build scripts so that they generate Tcl bindings for windows correctly. (CVS 4086) check-in: c7be8b41 user: drh tags: trunk
13:33
Version 3.4.0 (CVS 4085) check-in: 2647980f user: drh tags: trunk
12:22
Documentation updates prior to release 3.4.0. Enhanced support for soak testing in the test scripts. (CVS 4084) check-in: eec38710 user: drh tags: trunk
2007-06-16
18:39
Fix a faulty assert() in the pager. (CVS 4083) check-in: 4cff47b0 user: drh tags: trunk
14:43
Modify the tests in exclusive2.test to account for the fact that the pager cache may be very small by default. These tests are only valid if the entire database fitting in the cache. (CVS 4082) check-in: 04a13fe4 user: danielk1977 tags: trunk
14:19
Add another scenario to the soak1.tcl script. (CVS 4081) check-in: 10e6822d user: drh tags: trunk
11:17
A minor logic correction in the previous check-in. Also added a lengthy comment describing the meanings of various flags in the {quote: PgHdr} structure. (CVS 4080) check-in: 57bf8204 user: drh tags: trunk
04:42
Fix a database corruption problem that can occur in auto-vacuum mode when a malloc() failure causes a statement rollback, additional statements are run in the same transaction, then the total transaction rolls back. (CVS 4079) check-in: c9dcf2b9 user: drh tags: trunk
03:06
Additional debugging instrumentation added to the pager. (CVS 4078) check-in: dcdb20f8 user: drh tags: trunk
2007-06-15
20:29
Make arrangements to optionally print a debug message at the point of a simulated malloc() failure when SQLITE_MEMDEBUG is defined. (CVS 4077) check-in: 7d3c1f08 user: drh tags: trunk
18:59
Fix more documentation typos. Ticket #2416. (CVS 4076) check-in: b55318b1 user: drh tags: trunk
18:53
Remove a C++ism from the test harness. Get the TCL interface working with older versions of TCL. (CVS 4075) check-in: c8beb867 user: drh tags: trunk
18:43
Add a script for "soak" testing. (CVS 4074) check-in: d4ea1287 user: drh tags: trunk
17:50
Fix a race condition in test_server.c/test7.c (test changes only). (CVS 4073) check-in: d0de32e4 user: danielk1977 tags: trunk
17:04
Fix typo in change comments for 3.4.0. Ticket #2416 (CVS 4072) check-in: 1f6f0330 user: drh tags: trunk
17:03
Fix a memory leak in the parser that can occur following a malloc failure. (CVS 4071) check-in: d0b6e9a0 user: drh tags: trunk
16:37
Fix an obscure memory leak in the SQL compiler.. (CVS 4070) check-in: d4ab9428 user: danielk1977 tags: trunk
15:31
Fix a memory leak that was discovered by the tests that were added to cover ticket #2339. (CVS 4069) check-in: 1d10a489 user: drh tags: trunk
15:08
Fix a test suite bug. To accommadate the fact that handles returned by (db incrblob) change for the second test suite iteration of full.test. (CVS 4068) check-in: 32218834 user: danielk1977 tags: trunk
14:53
Fix for #2415. The progress handler should abandon only the current query, not all active queries. (CVS 4067) check-in: 115e19fe user: danielk1977 tags: trunk
13:57
Do not try to run the fuzz_malloc tests if SQLITE_MEMDEBUG is not enabled. (CVS 4066) check-in: 45211595 user: drh tags: trunk
12:41
Clean up a variable in tkt2409.test that would cause subsequent tests to fail. (CVS 4065) check-in: 0f944cb9 user: drh tags: trunk
12:16
Documentation updates in preparation for 3.4.0. (CVS 4064) check-in: 5232fd29 user: drh tags: trunk
12:06
Update the btree file format description in btreeInt.h. (CVS 4063) check-in: 1ac160d3 user: drh tags: trunk
2007-06-14
20:57
The C-api reference documentation is now generated directly from comments in the sqlite3.h header file. (CVS 4062) check-in: d93c41e9 user: drh tags: trunk
2007-06-13
16:49
Have queries interrupted by the progress-handler return SQLITE_INTERRUPT. Rollback any active transaction if a DML statement returns SQLITE_INTERRUPT. (CVS 4061) check-in: 33454b56 user: danielk1977 tags: trunk
15:22
Fix for #2409. Return SQLITE_IOERR_BLOCKED instead of SQLITE_BUSY in cases where failure to obtain a database lock leaves the cache in an inconsistent state. See additional information at CorruptionFollowingBusyError. (CVS 4060) check-in: ce2c9925 user: danielk1977 tags: trunk
2007-06-12
18:50
In the "transaction" command of the TCL interface, if a COMMIT fails finish it with a rollback. (CVS 4059) check-in: 6da39fa4 user: drh tags: trunk
18:20
Minor comment edits from my prefix development client. No code changes. (CVS 4058) check-in: 6953cd09 user: shess tags: trunk
2007-06-11
23:23
Fix typo in the limits.html document. Ticket #2410. (CVS 4057) check-in: d3fe186c user: drh tags: trunk
12:56
Fix a bug in the LIKE optimization that was causing the pattern string to be dequoted twice. Ticket #2407. (CVS 4056) check-in: abf64d1d user: drh tags: trunk
08:00
Add a README.txt file for the ICU extension. (CVS 4055) check-in: 7b692782 user: danielk1977 tags: trunk
2007-06-10
22:57
Define isnan() on windows. Ticket #2399. (CVS 4054) check-in: fed9373e user: drh tags: trunk
2007-06-09
09:53
Documentation updates, in particular in the new limits.html file is added. (CVS 4053) check-in: 4ca6cdae user: drh tags: trunk
2007-06-08
18:27
Use C-sylte comments exclusively, never C++ comments. Ticket #2406. (CVS 4052) check-in: 8f5b789f user: drh tags: trunk
08:43
Additional test cases for comparisons against NULL in the WHERE clause and elsewhere in a SELECT. (CVS 4051) check-in: 72612a03 user: drh tags: trunk
08:39
Make sure rowid comparisons against NULL work correctly. Ticket #2404. (CVS 4050) check-in: 11ee8ea4 user: drh tags: trunk
00:20
Fix the query optimizer so that it correctly handles constant expressions in the ON clause of a LEFT JOIN. Ticket #2403. (CVS 4049) check-in: 46fdd195 user: drh tags: trunk
2007-06-07
19:08
Make sure zeroblob does reasonable things with a negative argument or an argument that is larger than the maximum blob size. (CVS 4048) check-in: f4021843 user: drh tags: trunk
15:45
Fix an error in test file sqllimits1.test that was causing a test to fail when SQLITE_MAX_EXPR_DEPTH was defined. (CVS 4047) check-in: e66aa2c3 user: danielk1977 tags: trunk
10:55
Add the SQLITE_MAX_COMPOUND_SELECT compile-time parameter for limiting the number of terms in a compound select statement. Set the default limit to 100. (CVS 4046) check-in: 0d71ad45 user: drh tags: trunk
2007-06-02
07:54
Fix a vdbe stack leak that could occur where one side of a WHERE clause inequality evaluated to SQL null. (CVS 4045) check-in: 17152bf1 user: danielk1977 tags: trunk
2007-05-31
08:20
Extend out-of-memory testing with fuzzily generated sql some. One fix for a problem found by the same. (CVS 4044) check-in: d2282e64 user: danielk1977 tags: trunk
2007-05-30
10:36
Add some extra tests for malloc failure during expression parsing and execution using fuzzily generated SQL. (CVS 4043) check-in: 7522d2fb user: danielk1977 tags: trunk
08:18
Add the start of the soak-test infrastructure. (CVS 4042) check-in: 5d0b247c user: danielk1977 tags: trunk
06:19
Fix a problem with zeroblob() and CAST(...) expressions that could cause an assert() to fail. (CVS 4041) check-in: 03750a2a user: danielk1977 tags: trunk
2007-05-29
12:11
Consider explicit collate clauses when matching WHERE constraints to indices. Fix for #2391. (CVS 4040) check-in: f9a95e92 user: danielk1977 tags: trunk
2007-05-24
10:18
Add some tests to verify that the parameter to the incremental_vacuum pragma is working. It is. (CVS 4039) check-in: 1abf784f user: danielk1977 tags: trunk
09:44
Fix a typo in comments in sqlite.h.in. No code changes. Ticket #2384. (CVS 4038) check-in: e8ae6214 user: danielk1977 tags: trunk
09:41
Remove an assert() statement that may not be true if an IO or malloc error has occured. (CVS 4037) check-in: 16c8e9c2 user: danielk1977 tags: trunk
09:20
Fix a page reference leak that could occur after an IO error. (CVS 4036) check-in: d00c8242 user: danielk1977 tags: trunk
07:47
Remove an incorrect assert() statement that was being triggered by ioerr tests run in utf-16 mode. (CVS 4035) check-in: c6575173 user: danielk1977 tags: trunk
07:22
Fix an assert() failure occuring in corrupt.test. (CVS 4034) check-in: 3c54cddf user: danielk1977 tags: trunk
2007-05-23
16:23
Add some code to MemTranslate() to prevent the READ_UTF8() macro from overreading a buffer. (CVS 4033) check-in: 0595319c user: danielk1977 tags: trunk
13:50
Make sure the database schema has been read before compiling an incrmental_vacuum pragma. (CVS 4032) check-in: efd7bcb3 user: danielk1977 tags: trunk
13:34
Fix a leaked page reference that could occur after an IO error in auto-vacuum databases. Also modify incrvacuum.test to work with DEFAULT_AUTOVACUUM=1 builds. (CVS 4031) check-in: e691f2fa user: danielk1977 tags: trunk
09:52
Fix a database corrupting bug in the optimistic overflow chain. Exposed by running bigrow.test with auto-vacuum enabled. (CVS 4030) check-in: 10ee2d50 user: danielk1977 tags: trunk
07:20
Additional comments ono the SQLITE_MIXED_ENDIAN_64BIT_FLOAT issue. (CVS 4029) check-in: dd48a31e user: drh tags: trunk
06:31
Make sure zeroblob() works with the concatenation operator. Ticket #2379. (CVS 4028) check-in: 6e19ef75 user: drh tags: trunk
06:25
Increase the number of repititions in crash.test. (CVS 4027) check-in: f3c3412a user: danielk1977 tags: trunk
2007-05-21
21:59
Fix overzealous fts2 assertions WRT rowid 0 or lower. Only check that docids are ascending if there was a prior docid set for the doclist, ignore the initial docid of 0. (CVS 4026) check-in: ed3a131f user: shess tags: trunk
2007-05-19
11:50
Add the larger SQLite icon to the repository. (CVS 4025) check-in: d7539c6e user: drh tags: trunk
06:48
Add a few extra words to the sqlite3_finalize() documentation. (CVS 4024) check-in: 315dc71b user: danielk1977 tags: trunk
2007-05-17
18:28
Change the way overflow pages are allocated from the free-list to increase the chance that they are a contiguous block. Much more can still be done. (CVS 4023) check-in: b7391892 user: danielk1977 tags: trunk
16:38
Bring the autoconf based build system up to date with the recent changes. #2366, #2367 and #2368. (CVS 4022) check-in: ae644bc7 user: danielk1977 tags: trunk
16:34
Fix a problem with casting blobs to numeric types. (CVS 4021) check-in: f2ce727c user: danielk1977 tags: trunk
14:45
Add speed3.test file. For testing performance issues related to overflow pages. (CVS 4020) check-in: 684f765d user: danielk1977 tags: trunk
06:44
Modify test scripts to allow for the fact that zeroblob() is not available when compiled with OMIT_INCRBLOB. Ticket #2365. (CVS 4019) check-in: 2ee959be user: danielk1977 tags: trunk
2007-05-16
18:23
Remove the SKIP_UTF16 macros (they are no longer in use). (CVS 4018) check-in: 73e654fb user: danielk1977 tags: trunk
18:11
Fix handling of utf-16 encoding of code point 0xE000. (CVS 4017) check-in: bfc35ce8 user: danielk1977 tags: trunk
17:50
Avoid passing a negative value to isspace() in a couple places. (CVS 4016) check-in: d5db8be3 user: danielk1977 tags: trunk
17:28
Change a few selected functions to macros to speed things up. (CVS 4015) check-in: 93f811ec user: danielk1977 tags: trunk
14:23
Omit some extra code when OMIT_INCRBLOB is defined. (CVS 4014) check-in: 1d89be28 user: danielk1977 tags: trunk
13:55
Add a --nostatic option to mksqlite3c.tcl. With this option turned on, the extra "static" storage class markers are not inserted into the amalgamation. (CVS 4013) check-in: 57e17c7c user: drh tags: trunk
11:55
Keep the full precision of integers if possible when casting to "numeric". Ticket #2364. (CVS 4012) check-in: 2ac985a3 user: drh tags: trunk
2007-05-15
18:35
Additional tests for malformed UTF-8. (CVS 4011) check-in: 448d3ef6 user: drh tags: trunk
16:51
Make sure pParse->rc gets set whenever sqlite3ErrorMsg() is called. This is added insurance that parsing will stop quickly after an error. This change did make the parser stop faster in some cases, which required some revisions to tests. (CVS 4010) check-in: f84d9dab user: drh tags: trunk
14:40
Remove the alternative UTF-16 implementation of SUBSTR(). It does not work anymore and the UTF-8 version can do everything that the UTF-16 version does. (CVS 4009) check-in: 9b91502e user: drh tags: trunk
14:34
Relax the restriction on using bytes 0x80 through 0xbf as the first character of an identifier. Enhancements to ALTER TABLE tests for tables with strange names or stange column names. (CVS 4008) check-in: 262a3e63 user: drh tags: trunk
14:17
Change the documentation to clearly state that the result of sqlite3_column_type() is undefined following a type conversion. (CVS 4007) check-in: 960be575 user: drh tags: trunk
14:10
Fix to check-in (4005). A call to sqlite3_column_blob() should not make subsequent calls to sqlite3_column_type() return SQLITE_BLOB. Sqlite3_column_type() returns the initial type. (CVS 4006) check-in: b5e85deb user: drh tags: trunk
13:27
Clarification on the best practices for using the _bytes() APIs. Change sqlite3_value_blob() to force the representation to be purely a BLOB and not a dual BLOB/String. Ticket #2360. (CVS 4005) check-in: cf2dd45b user: drh tags: trunk
11:55
A new approach for UTF-8 translation. (CVS 4004) check-in: 6c8ad279 user: drh tags: trunk
09:00
Do not allow bytes 0x80 through 0xBF to be the first character of an identifer because no valid UTF-8 character can begin with those bytes. If we allowed an identifier to begin with one of those bytes, then the substr() function in ALTER TABLE will not work correctly. (CVS 4003) check-in: 25281042 user: drh tags: trunk
07:14
Fix some test script errors in fuzz.test. (CVS 4002) check-in: 51eeae7b user: danielk1977 tags: trunk
07:00
A fix for queries that used correlated, compound sub-queries in the HAVING clause. Also update fuzz.test some more. (CVS 4001) check-in: da0c1ab4 user: danielk1977 tags: trunk
03:56
Fix problems in ALTER TABLE that occur when column or table names are invalid UTF encodings. (CVS 4000) check-in: 9ff382f4 user: drh tags: trunk
02:45
Fix a typo in a comment. Ticket #2359. (CVS 3999) check-in: 1fbbc108 user: drh tags: trunk