/ 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 5ddc09a5e4d81a73.

2006-05-10
14:39
Out-of-memory checks added to tclsqlite.c and shell.c. Tickets #1805 and #1806. (CVS 3182) check-in: 364031d6 user: drh tags: trunk
2006-05-08
15:14
Fix error processing in Lemon. SQLite does not use this feature of lemon so it is uneffected. (CVS 3181) check-in: 864cac96 user: drh tags: trunk
2006-05-07
17:49
Automatically increase the size of the pager hash table as the number of in-memory pages increases. Tickets #1790 and #1799. (CVS 3180) check-in: ef8e9886 user: drh tags: trunk
2006-05-03
23:39
Fix a typo on a webpage. Ticket #1792. (CVS 3179) check-in: 27022052 user: drh tags: trunk
23:34
Faster :memory: database COMMITs. Ticket #1790. (CVS 3178) check-in: 8f820e43 user: drh tags: trunk
2006-04-26
17:39
Get LIMIT 0 working on subqueries. Ticket #1784. (CVS 3177) check-in: 7f3ef7dd user: drh tags: trunk
2006-04-21
09:38
Additional information about index sorting in EXPLAIN QUERY PLAN. (CVS 3176) check-in: 39dd9695 user: drh tags: trunk
2006-04-19
01:24
Remove a superfluous call to access() in the unix driver. Error spotted by Coverity. (CVS 3175) check-in: 4f195aa1 user: drh tags: trunk
2006-04-16
12:05
Allocate enough memory for the worst-case UTF-16 to UTF-8 conversion. Ticket #1773. (CVS 3174) check-in: 2a0120c0 user: drh tags: trunk
2006-04-11
14:16
Allow constant terms in the ORDER BY or GROUP BY clauses. Ticket #1768. (CVS 3173) check-in: d83e0230 user: drh tags: trunk
2006-04-10
13:37
Follow-up to check-in (3164). Make sure SQLITE_NOMEM is returned after a memory allocation failure. It is not sufficent to return an "out of memory" error message. The return code needs to be SQLITE_NOMEM. (CVS 3172) check-in: 9d95750e user: drh tags: trunk
2006-04-08
19:14
Variable declarations should come before code. Ticket #1763. (CVS 3171) check-in: 9682f844 user: drh tags: trunk
2006-04-07
13:54
Reorder code so that it compiles with SQLITE_OMIT_MEMORYDB. Ticket #1754. (CVS 3170) check-in: 1929e37d user: drh tags: trunk
13:50
Return the correct declared column type, origin column name, origin database name, etc. from aggregate queries. Ticket #1726 and #1755. (CVS 3169) check-in: e64809f0 user: drh tags: trunk
13:26
Avoid the use of atof(). Ticket #1756. (CVS 3168) check-in: 76aef93c user: drh tags: trunk
2006-04-05
13:16
Version 3.3.5 (CVS 3167) check-in: a091a61d user: drh tags: trunk
12:50
Fix typos in the previous check-in. (CVS 3166) check-in: 119ec402 user: drh tags: trunk
12:15
Preparing for the release of version 3.3.5. (CVS 3165) check-in: 159fb92b user: drh tags: trunk
11:57
Make sure SQLITE_NOMEM is reported out on a malloc failure in an ATTACH even if the malloc failure reports within a nested calls to sqlite3_prepare(). (CVS 3164) check-in: 3538a4e3 user: drh tags: trunk
01:08
Add documentation on new sqlite_authorizer callback types. Ticket #1744. (CVS 3163) check-in: fdbff3f1 user: drh tags: trunk
01:02
Documentation typos. Tickets #1749 and #1750. (CVS 3162) check-in: 51b35ace user: drh tags: trunk
2006-04-04
01:54
Changes to get SQLite running on machines that use the EBCDIC character set. (CVS 3161) check-in: 4342b499 user: drh tags: trunk
2006-04-02
11:57
Do not strip windows DLLs because this prevents them from being relocatable. Ticket #1474. (CVS 3160) check-in: 94054cd9 user: drh tags: trunk
2006-04-01
14:38
Remove mention of the REVERSE collating sequence from the documentation. (CVS 3159) check-in: bd6876a1 user: drh tags: trunk
2006-03-29
00:24
Properly record the names of triggers even if the name is quoted. Ticket #1737. (CVS 3158) check-in: 4ba280dd user: drh tags: trunk
2006-03-28
23:57
Compile-time option to use only 32-bit integers. (CVS 3157) check-in: aedadfc3 user: drh tags: trunk
23:55
Join optimizer enhancements. (CVS 3156) check-in: 0039888f user: drh tags: trunk
00:24
Extra asserts to prove that certain reported errors in btree.c are not really errors. (CVS 3155) check-in: c64542d0 user: drh tags: trunk
2006-03-26
20:49
Work around a bug in GCC 4.0.2. (CVS 3154) check-in: fe0920c7 user: drh tags: trunk
01:21
SQLite now always chooses the column names for compound selects using the left-most select. This makes SQLite work like other SQL database, but it also is a change from historical behavior and may break some scripts. Ticket #1721. (CVS 3153) check-in: 80cda9f7 user: drh tags: trunk
2006-03-25
15:52
Add code to report an error on a recursive trigger, but leave it commented out - turning it on will likely break a lot of code. (CVS 3152) check-in: c83ec81d user: drh tags: trunk
14:03
Add a note to the API documentation emphasizing that the filename argument to sqlite3_open() must be UTF-8. Tickets #1713, #1533. (CVS 3151) check-in: b0111f43 user: drh tags: trunk
2006-03-24
03:36
Make sure the rootpage values in the symbol table are correctly updated when dropping tables and indices in autocommit mode. Ticket #1728. (CVS 3150) check-in: 1c582dd1 user: drh tags: trunk
2006-03-23
23:33
Improvements to comments in build.c. (CVS 3149) check-in: 986208a3 user: drh tags: trunk
23:29
Get autovacuum and in-memory databases working together. Ticket #1727. (CVS 3148) check-in: 21446df6 user: drh tags: trunk
22:42
Use the pread()/pwrite() interface on Posix if compiled with -DUSE_PREAD=1. Note that on Linux this is slower and does not work for large files. (CVS 3147) check-in: 5a24f619 user: drh tags: trunk
14:03
Improvements to comments. No changes to code. (CVS 3146) check-in: 01e164da user: drh tags: trunk
2006-03-22
22:10
Get the build to run with -DSQLITE_OMIT_SHARED_CACHE. (CVS 3145) check-in: 15e3b183 user: drh tags: trunk
2006-03-19
13:00
Increase test coverage to above 98%. (CVS 3144) check-in: 8ae6ccc7 user: drh tags: trunk
2006-03-17
13:56
Miscellaneous code cleanup. (CVS 3143) check-in: 8f60139f user: drh tags: trunk
00:26
Code and comment cleanup for the sorting optimization of the previous check-in. (CVS 3142) check-in: f3fbe727 user: drh tags: trunk
00:04
Much faster sorting when there are a large number of columns in the result set. (CVS 3141) check-in: 6b3717ae user: drh tags: trunk
2006-03-16
16:19
Fix some compiler warnings. (CVS 3140) check-in: 6c5175bc user: drh tags: trunk
14:05
Make provisions in the code to support Provisions to support caching of serialized statements in the SSE extension. (CVS 3139) check-in: 5048fae0 user: drh tags: trunk
2006-03-15
22:44
Performance improvement in sqlite3VdbeAddOp(). (CVS 3138) check-in: 6bcbe8fc user: drh tags: trunk
16:26
Fix CHECK constraints to use alternative conflict resolution. Ticket #1717. (CVS 3137) check-in: c0d20fa9 user: drh tags: trunk
2006-03-14
13:10
Set and clear the full_column_name flag using direct invocation rather than the execsql tcl command so that the select1 test works with the serialized statement extension. (CVS 3136) check-in: 4d70013a user: drh tags: trunk
12:59
Move the PENDING_PAGE to a very large value if disk I/O is omitted. (CVS 3135) check-in: f0718173 user: drh tags: trunk
11:08
Make sure sqlite3FindCollSeq() returns NULL after a malloc() failure. (CVS 3134) check-in: 0e05355f user: drh tags: trunk
2006-03-13
15:06
Get parserless builds working again. (CVS 3133) check-in: 5ddc09a5 user: drh tags: trunk
14:31
Fix documentation to show the correct return type from sqlite3_db_handle(). Ticket #1716. (CVS 3132) check-in: f4fb047d user: drh tags: trunk
14:28
Changes to get the Serialized Statement Extension working again. (CVS 3131) check-in: 255fdbe6 user: drh tags: trunk
12:54
Additional changes due to Coverity scans. (CVS 3130) check-in: a69f697d user: drh tags: trunk
2006-03-11
12:04
Add an assert() to demonstrate that Klockworks is wrong about an aleged bug. (CVS 3129) check-in: 0910022b user: drh tags: trunk
2006-03-09
17:28
Correct names returned from a query against a view. Ticket #1709, #1688, #1711. (CVS 3128) check-in: 36830faf user: drh tags: trunk
2006-03-06
23:30
Remove all reference to EXTERN from tclsqlite.c. Ticket #1687. (CVS 3127) check-in: b4d3e0d5 user: drh tags: trunk
20:55
Code changes resulting from Coverity analysis. http://scan.coverity.com/ Found 1 potential segfault in sqlite3_mprintf(). Also 2 failures to fclose() following a malloc() failure. And lots of cases where unnecessary conditionals could be removed from the code. (CVS 3126) check-in: e510e6dd user: drh tags: trunk
18:23
Pager performance enhancements. (CVS 3125) check-in: 9c265707 user: drh tags: trunk
2006-03-03
21:39
Fix typo in documentation. Ticket #1578. (CVS 3124) check-in: cb2e009f user: drh tags: trunk
21:38
EXPLAIN sets the length of its text return values correctly. Ticket #1583. (CVS 3123) check-in: 34b560e8 user: drh tags: trunk
21:20
The table_info pragma shows column affinity as "" if there is no column affinity. Ticket #1570. (CVS 3122) check-in: 5cae8d63 user: drh tags: trunk
20:54
Make sure the default busy handler uses usleep() when available. Ticket #1684. (CVS 3121) check-in: 43e54626 user: drh tags: trunk
20:37
The --enable-debug option on configure enables verbose explain and vdbe_trace. Ticket #1680. (CVS 3120) check-in: ee2f7068 user: drh tags: trunk
20:32
Fix tclsqlite.c to better support Mingw. Ticket #1687. (CVS 3119) check-in: da0e843c user: drh tags: trunk
19:12
Ignore leading spaces on text to numeric conversions. Ticket #1662. Fixes to test cases broken by the recent changes to round(). (CVS 3118) check-in: cdca3383 user: drh tags: trunk
2006-03-02
04:44
Allow WHERE clause terms on the left table of a LEFT OUTER JOIN to contain aggregate subqueries. Ticket #1697. (CVS 3117) check-in: a286e54e user: drh tags: trunk
03:02
Change the ROUND() function to return a REAL value instead of TEXT. Ticket #1699. (CVS 3116) check-in: 9dbadfb2 user: drh tags: trunk
2006-02-27
23:44
Reduce the size of a memory allocation in the windows driver to the minimum needed. Ticket #1690. (CVS 3115) check-in: 1fe9ca07 user: drh tags: trunk
23:19
Add a test to make sure parser stack overflow is detected and reported. (CVS 3114) check-in: 201ab3b5 user: drh tags: trunk
22:22
The parser now permits very large triggers - triggers with 10000 or more statements. (CVS 3113) check-in: b4fa96d0 user: drh tags: trunk
21:58
Detect stack overflow in the parser and report an error. (CVS 3112) check-in: bd2c38f4 user: drh tags: trunk
2006-02-24
03:09
Additional compiler warnings suppressed. (CVS 3111) check-in: a359b181 user: drh tags: trunk
02:53
Remove unused parameters on internal APIs. Suppress warnings from CodeWarrior. (CVS 3110) check-in: 4b22e4b8 user: drh tags: trunk
2006-02-23
21:51
Make sure the random() function always returns a value that can be passed to abs(). (CVS 3109) check-in: 5d2e7ea0 user: drh tags: trunk
21:43
Detect integer overflow in the abs() function. The random() function now provides 64 bits of randomness instead of just 32. Fix bugs in testing logic of test4.c. (CVS 3108) check-in: 942c5095 user: drh tags: trunk
2006-02-22
03:08
New compile-time option SQLITE_SECURE_DELETE takes care to overwrite deleted data with zeros. (CVS 3107) check-in: 614fac90 user: drh tags: trunk
2006-02-18
16:36
Always generate code, even if it is a no-op, for CREATE and DROP statements that use the IF EXISTS or IF NOT EXISTS clause. (CVS 3106) check-in: f8173e6a user: drh tags: trunk
2006-02-17
15:01
Fix bug preventing compliation without MEMDEBUG when ENABLE_MEMORY_MANAGE is defined. (CVS 3105) check-in: 76912b33 user: danielk1977 tags: trunk
12:25
Ensure temp db is open before executing a pragma like "temp.cachesize = xxx". Fix for #1682. (CVS 3104) check-in: 1e4644b2 user: danielk1977 tags: trunk
2006-02-16
18:16
Or the SQLITE_UTF16_ALIGNED with the encoding field in sqlite3_create_collation and UTF16 strings will always be aligned on an even byte boundary when passed into the comparison function. (CVS 3103) check-in: 7a1701e8 user: drh tags: trunk
00:32
Fix more typos in the file format document. (CVS 3102) check-in: d7495be8 user: drh tags: trunk
00:31
Fix a typo in the file format document. (CVS 3101) check-in: fac0d202 user: drh tags: trunk
2006-02-15
21:19
Get the build working again. Fix for check-in (3093) (CVS 3100) check-in: 4e6b74b2 user: drh tags: trunk
17:30
Mention the NOT unary operator in the documentation. (CVS 3099) check-in: 3eca2d98 user: drh tags: trunk
02:00
Update the configure script to use AC_HELP_STRING. (CVS 3098) check-in: 92be79de user: drh tags: trunk
2006-02-14
14:46
test_async.c: Writer-thread should not relinquish mutex when writing a file for which only one file handle is open (fixes bug introduced in (3093)). (CVS 3097) check-in: f0c45b7e user: danielk1977 tags: trunk
14:02
Account for a malloc failure in the asynchronous writer thread in test_async.c (CVS 3096) check-in: 2f2a8a69 user: danielk1977 tags: trunk
13:48
Fix bug in test_async.c version of OsFileSize(). (CVS 3095) check-in: 239e53b4 user: danielk1977 tags: trunk
13:25
Add simple io error tests for test_async.c. (CVS 3094) check-in: 528dfb71 user: danielk1977 tags: trunk
10:48
Changes so that test_async.c works with memory management turned on. (CVS 3093) check-in: f4150c29 user: danielk1977 tags: trunk
2006-02-13
18:42
Disable the /./ and /../ collapser logic in sqlite3OsFullPathname under Unix. (CVS 3092) check-in: 111a426b user: drh tags: trunk
18:35
Fix a bug in the handling of sqlite3OsTruncate by the test_async.c demo. Added trans.test to the suite of tests for asychronous I/O. (CVS 3091) check-in: 5b16c435 user: drh tags: trunk
17:03
Add in-process file locking to test_async.c. The unix implementation of sqlite3OsFullPathname() now attempts to remove /./ and /../ elements from the path. (CVS 3090) check-in: 42379c62 user: drh tags: trunk
15:29
Fix a deadlock problem on the sqlite3async_wait test interface. Improvements to tracing in test_async.c. (CVS 3089) check-in: 58c6d501 user: drh tags: trunk
14:49
Improvements to the TRACE macro in test_async.c. (CVS 3088) check-in: 4c6dfec5 user: drh tags: trunk
13:50
I/O errors shut down all processing on the same file in test_async.c. (CVS 3087) check-in: 4366e712 user: drh tags: trunk
13:30
Fix overlapping read logic in the test_async.c demonstration. (CVS 3086) check-in: ad25127b user: drh tags: trunk
13:23
Fix a memory leak in test_async.c. (CVS 3085) check-in: 904ffa4d user: drh tags: trunk
2006-02-11
17:34
I give up. SUM() now throws an error on integer overflow. Those of us who think this is goofy can use TOTAL() instead. Tickets #1664, #1669, #1670, #1674. (CVS 3084) check-in: 1c3e6002 user: drh tags: trunk
02:12
Version 3.3.4 (CVS 3083) check-in: 033aaab6 user: drh tags: trunk