SQLite

Timeline
Login

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

50 check-ins occurring around bdba796f3b.

2003-02-20
01:48
When the right table in a LEFT OUTER JOIN contains an INTEGER PRIMARY KEY make sure that key is NULL if there is no row in the right table that matches the current row in the left table. Tickets #246 and #247. (CVS 873) (check-in: 6a45fe3bd7 user: drh tags: trunk)
00:44
Fix the parsing of the LIMIT clause when the limit and offset are separated by a comma. The offset comes before the limit in that case. Ticket #245. (CVS 872) (check-in: 6ef91a364b user: drh tags: trunk)
2003-02-16
22:49
Version 2.8.0 (CVS 870) (check-in: 5db98b3f40 user: drh tags: trunk)
22:48
Couple of last-minute changes before 2.8.0. (CVS 871) (check-in: 8192c937d5 user: drh tags: trunk)
22:36
Update the speed comparison documentation to show the improved performance of PostgreSQL after performance tuning. (CVS 869) (check-in: 73c904e57a user: drh tags: trunk)
22:21
Added test code to check for file descriptor leaks. All regression tests pass now on both win2k and linux. (CVS 868) (check-in: 75ba78280f user: drh tags: trunk)
19:13
Fix more bugs. The new rollback journal implementation now passes all regression tests under Linux. (CVS 867) (check-in: d10adc1c57 user: drh tags: trunk)
2003-02-15
23:09
Fix the pager so that correct rollbacks occur when synchronous is turned off. This check-in also included unrelated documentation updates. (CVS 866) (check-in: 3ef0ad8a4f user: drh tags: trunk)
2003-02-13
02:54
Update the documentation for the new journal format to be introduced in version 2.8.0. (CVS 1729) (check-in: dc53d92141 user: drh tags: trunk)
02:54
Update the documentation for the new journal format to be introduced in version 2.8.0. (CVS 865) (check-in: e05a7a552f user: drh tags: trunk)
01:58
Fix a bug in the rollback logic for the new journal format. (CVS 864) (check-in: 7c22aa3f81 user: drh tags: trunk)
2003-02-12
14:09
Added the new FULL option to the SYNCHRONOUS pragma. Still need to test it. (CVS 1728) (check-in: 8968bc0636 user: drh tags: trunk)
14:09
Added the new FULL option to the SYNCHRONOUS pragma. Still need to test it. (CVS 863) (check-in: 792a9e157d user: drh tags: trunk)
02:10
Fix a bug in the legacy journal format writing logic. (CVS 862) (check-in: 6c927dd36c user: drh tags: trunk)
2003-02-11
14:55
Modify the journal format to be more robust against garbage that might appear in the file after a power failure. The changes are mostly working but more testing is still required. This check-in is to checkpoint the changes so far. (CVS 861) (check-in: 8ec5632536 user: drh tags: trunk)
2003-02-05
14:06
Make the shell run much faster for inputs where a single SQL statement spans thousands of lines by avoiding the call to sqlite_complete() unless the input ends in a semicolon. (CVS 860) (check-in: e21afb82b5 user: drh tags: trunk)
2003-02-02
12:41
Make the GROUP BY clause work even if there are no aggregate functions. (CVS 859) (check-in: b687923158 user: drh tags: trunk)
2003-02-01
13:53
When a CREATE TABLE ... AS SELECT statement fails, make sure the table name is removed from the internal hash tables. Ticket #238. (CVS 858) (check-in: 65264780c5 user: drh tags: trunk)
2003-01-31
17:21
The sqlite_exec() function now returns SQLITE_AUTH when authorization fails. Ticket #231. (CVS 857) (check-in: d93c1aeb54 user: drh tags: trunk)
17:16
Allow double-quoted strings as string constants in the IN operator. As a side-efffect, allow the GROUP BY clause to refer to columns by their integer column number. Ticket #237. (CVS 856) (check-in: 187d9c4058 user: drh tags: trunk)
2003-01-29
22:58
Additional testing and bug fixing with the non-callback API. Updated the C/C++ interface document to describe the non-callback API. (CVS 855) (check-in: af1e929946 user: drh tags: trunk)
18:46
Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) (check-in: ccc82f1ab4 user: drh tags: trunk)
14:06
The callback-free API is now working, though much more testing is need. (CVS 853) (check-in: 162b259188 user: drh tags: trunk)
2003-01-28
23:13
First code for the new callback-free API. All regression tests pass but the new API is mostly untested and is unlikely to work. (CVS 852) (check-in: 065fa818ff user: drh tags: trunk)
2003-01-26
15:28
Added section on comments. Corrected broken end tags. (CVS 851) (check-in: c957f4f0c6 user: jplyon tags: trunk)
2003-01-25
16:32
Version 2.7.6 (CVS 850) (check-in: bdba796f3b user: drh tags: trunk)
15:43
Fix a bug in the rollback validation logic (code that only runs during debugging). The problem was introduced by check-in (835). (CVS 849) (check-in: b6ea0da76a user: drh tags: trunk)
14:34
Remove an unused variable. (CVS 848) (check-in: 18f4ffaa2e user: drh tags: trunk)
14:32
Preparations for the release of version 2.7.6. (CVS 847) (check-in: 5143d4814d user: drh tags: trunk)
14:25
Update the speed.html documentation. Recent optimizations have made the library much faster. (CVS 846) (check-in: ed47d162a0 user: drh tags: trunk)
2003-01-24
12:14
Add asserts to btree.c that check for the correct size of various typedefs and structures. Ticket #233. (CVS 845) (check-in: c7e647d011 user: drh tags: trunk)
2003-01-22
01:26
Minor refinements to the pager. (CVS 844) (check-in: 19221dee5f user: drh tags: trunk)
2003-01-21
23:06
fix a typo on the quickstart.html page. (CVS 843) (check-in: 61869bb51b user: drh tags: trunk)
02:39
In the pager, cache a pointer to the first page on the freelist that does not need to be synced. This makes a fetch of a page that is not in cache go a lot faster when the cache is full. This check-in also adds some performance instrumentation to the OS layer. (CVS 842) (check-in: 00f08fc0b5 user: drh tags: trunk)
2003-01-19
03:59
Update comments. No changes to code. (CVS 841) (check-in: f6a8706872 user: drh tags: trunk)
2003-01-18
22:01
Update the speed comparison page. (CVS 840) (check-in: 424cb2edb0 user: drh tags: trunk)
20:11
Fix datatype reporting and collating sequence selection so that it works correctly on views and with the UNION, EXCEPT, and INTERCEPT operators. (CVS 839) (check-in: 71cc292dce user: drh tags: trunk)
17:05
Do not report an error if the input to the sqlite shell ends in a comment. Ticket #211. (CVS 838) (check-in: 32a8e6e977 user: drh tags: trunk)
17:04
Check the validity of the database connection before the trace callback, not afterwards. (CVS 837) (check-in: 960a2e4af3 user: drh tags: trunk)
2003-01-16
16:28
Add the sqlite_trace() hook for tracing the SQL that an application executes. The plan is to leave this API undocumented for the time being, in case we want to make changes to it later. (CVS 836) (check-in: f67bff8ff3 user: drh tags: trunk)
13:42
Improvements to the pager to help large updates against a large database run faster. Also improved the testing of the pager rollback algorithms. (CVS 835) (check-in: 717523d375 user: drh tags: trunk)
2003-01-14
13:48
Finish out the test suite for the new sqlite_set_authorizer API. (CVS 834) (check-in: 701a73918d user: drh tags: trunk)
02:54
Fix a memory leak in the PRAGMA authorization code. (CVS 833) (check-in: ba58979f2f user: drh tags: trunk)
02:49
More tests of the sqlite_set_authorizer() API together with fixes for bugs that the new tests uncovered. (CVS 832) (check-in: cc2ae781ac user: drh tags: trunk)
00:44
Make the GLOB work write with upper-case characters. Ticket #226. (CVS 831) (check-in: 7ea46e7064 user: drh tags: trunk)
2003-01-13
23:27
Revise the sqlite_set_authorizer API to provide more detailed information about the SQL statement being authorized. Only partially tested so far. (CVS 830) (check-in: 45de93f913 user: drh tags: trunk)
2003-01-12
19:33
The initial round of tests for the sqlite_set_authorizer() API. More are needed before release. Ticket #215. (CVS 829) (check-in: 5707b3d56e user: drh tags: trunk)
18:07
Forgot to include the new "auth.c" source file in the previous checkin. (CVS 828) (check-in: 7601916419 user: drh tags: trunk)
18:02
Initial check-in of the code for the new sqlite_set_authorizer() API function. The code is mostly untested at this point. (CVS 827) (check-in: 52d5007f64 user: drh tags: trunk)
17:35
Remove an unused variable from the VDBE. Ticket #223. (CVS 826) (check-in: 0deaf563fd user: drh tags: trunk)