SQLite

Timeline
Login

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

100 check-ins occurring around a359b1817e85a9c5.

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)
02:03
Fix typo in os_unix.c. (CVS 3082) (check-in: c0e987bc user: drh tags: trunk)
01:56
Prepare for the release of 3.3.4. (CVS 3081) (check-in: 951f3322 user: drh tags: trunk)
01:25
Add support and documentation for the fullfsync pragma. Also include some other unrelated documentation updates. (CVS 3080) (check-in: f2069d0b user: drh tags: trunk)
2006-02-10
18:08
Make sure pointers are always aligned to 8-bytes when creating internal Index structures. (CVS 3079) (check-in: d20a33ac user: drh tags: trunk)
14:02
Clean up pointer misuse in vdbe.c. (CVS 3078) (check-in: 9e82b927 user: drh tags: trunk)
13:33
Minor test file modifications for builds compiled with OMIT options. (CVS 3077) (check-in: c468aa34 user: danielk1977 tags: trunk)
13:14
Add documentation for new APIs. (CVS 3076) (check-in: 84c2a5c4 user: danielk1977 tags: trunk)
13:11
More comments on the unix locking code. Ticket #1672. (CVS 3075) (check-in: 4b6f5688 user: drh tags: trunk)
12:48
Add trivial tests to increase coverage of sqlite3_table_column_metadata(). (CVS 3074) (check-in: 424ce5ec user: danielk1977 tags: trunk)
08:24
Work around the case where the pending-byte page is also a a pointer-map page. Ticket #1667. (CVS 3073) (check-in: 5ea87fbb user: danielk1977 tags: trunk)
07:07
Fix the origin APIs so that they correctly handle views and subqueries that cannot be flattened. (CVS 3072) (check-in: 5e8611e1 user: danielk1977 tags: trunk)
04:33
Fix deadlock problem in the unix mutex. Ticket #1672. (CVS 3071) (check-in: a6c30be2 user: drh tags: trunk)
03:06
Add a symbol P3_TRANSIENT to pass to VdbeSetColName() to make it copy the string parameter up to the first 0 byte. (CVS 3070) (check-in: 6ebb8f9b user: danielk1977 tags: trunk)
02:27
Add the column_origin_name() etc. APIs. (CVS 3069) (check-in: 82f502cd user: danielk1977 tags: trunk)
2006-02-09
23:05
Ignore errors when when calling fsync() on a directory. Ticket #1657. (CVS 3068) (check-in: d54d3b82 user: drh tags: trunk)
22:24
Allow '@' to introduce host parameter names for compatibility with MS SQL Server. Ticket #1671. (CVS 3067) (check-in: 0738ef81 user: drh tags: trunk)
22:13
SUM never gives an error. An integer result is returned for exact results and a floating point result is returned for approximate results. Tickets #1664, #1669, and #1670. (CVS 3066) (check-in: 9e04f8fd user: drh tags: trunk)
18:35
Deprecate the sqlite3_aggregate_count() API. Make sure all aggregate counters are 64 bits. Remove unused StdDev structure from func.c. Ticket #1669. (CVS 3065) (check-in: 44bd7ba4 user: drh tags: trunk)
17:47
Integer overflow in SUM causes an exception. Ticket #1669. (CVS 3064) (check-in: c72b9461 user: drh tags: trunk)
16:52
Back out check-in (3058) - it breaks too much application code. (CVS 3063) (check-in: 731f1e32 user: drh tags: trunk)
13:43
Add the sqlite3_table_column_meta() API. (CVS 3062) (check-in: 1ac72f68 user: danielk1977 tags: trunk)
13:38
Avoid overflowing the 48-bit mantissa of a floating point number when summing large integers in the SUM() function. Ticket #1664. (CVS 3061) (check-in: a9169e87 user: drh tags: trunk)