SQLite

Timeline
Login

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

42 check-ins using file test/pragma.test version ab309fb9

2004-11-23
09:06
Fix a bug involving balance_shallow() and the sqlite_master table. (CVS 2143) (check-in: 557be3ff user: danielk1977 tags: trunk)
01:47
More work on the implementation of cursors, but they are still not functioning. (CVS 2142) (check-in: 8b61d1ae user: drh tags: trunk)
2004-11-22
19:12
Add initial infrastructure for cursors. In where.c, optimize out clauses of the form "ORDER BY rowid" if a table scan is being performed. Do a reverse table scan if "ORDER BY rowid DESC" is present. (CVS 2141) (check-in: fc8c1393 user: drh tags: trunk)
19:07
Fix a long-standing bug in btree.c in the sqlite3BtreePrevious() routine. The problem has gone unnoticed before now because it only occurs when you use the OP_Prev opcode on a B+Tree. (CVS 2140) (check-in: 3d2536c4 user: drh tags: trunk)
15:05
Fix a couple of extra test-suite problems with SQLITE_OMIT_VIEW. (CVS 2139) (check-in: 894c142d user: danielk1977 tags: trunk)
13:35
Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) (check-in: 007be591 user: danielk1977 tags: trunk)
11:51
Ensure tests pass when SQLITE_OMIT_TRIGGER is defined. (CVS 2137) (check-in: 53894988 user: danielk1977 tags: trunk)
10:20
Fix a test-suite error made in check-in (2132) (CVS 2136) (check-in: 48c7eb7f user: danielk1977 tags: trunk)
10:02
Back out changes allowing writes to tables that have open cursors. (CVS 2135) (check-in: ec6b48f4 user: danielk1977 tags: trunk)
10:02
Back out changes allowing writes to tables that have open cursors. (CVS 2134) (check-in: af635cab user: danielk1977 tags: trunk)
10:02
Back out changes allowing writes to tables that have open cursors. (CVS 2133) (check-in: 91acd87e user: danielk1977 tags: trunk)
08:43
Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132) (check-in: 711e8d76 user: danielk1977 tags: trunk)
05:26
Have tests pass when SQLITE_OMIT_MEMORYDB is defined. (CVS 2131) (check-in: 9df837c0 user: danielk1977 tags: trunk)
03:34
Fix auth.test to work when SQLITE_OMIT_ALTERTABLE is defined. (CVS 2130) (check-in: 27a8379b user: danielk1977 tags: trunk)
2004-11-21
01:02
AUTOINCREMENT documentation added. Improvements to lang.html. (CVS 2129) (check-in: ac72a1d5 user: drh tags: trunk)
2004-11-20
21:02
Fix to the documentation on sqlite3_create_function. Ticket #899. (CVS 2128) (check-in: 4ab1d012 user: drh tags: trunk)
20:44
Avoid excess heap usage when copying expressions. Ticket #979. (CVS 2127) (check-in: d10560c7 user: drh tags: trunk)
20:31
Correct use of usableSize versus pageSize in btree.c. Ticket #1010. (CVS 2125) (check-in: 5a4013ec user: drh tags: trunk)
20:18
Better error message on an SQLITE_RANGE error. Ticket #991. (CVS 2124) (check-in: accd432e user: drh tags: trunk)
19:55
Rename source file sqlite.1 as sqlite3.1. Ticket #995. (CVS 2123) (check-in: 297559c6 user: drh tags: trunk)
19:18
Omit the maximum loop count on the random name chooser in the VACUUM command. Add a comment to explain why this is safe and does not result in an infinite loop. Ticket #1009. (CVS 2122) (check-in: 1241086f user: drh tags: trunk)
19:18
Rig the sqliteMalloc() routine so that we can make it fail multiple times in a row. Modify the malloc.test procedure to make malloc fail in this way and verify that the failures are still handled correctly. (CVS 2121) (check-in: 519bc9d9 user: drh tags: trunk)
18:13
Fix segfaults that might occur after a malloc failure. (CVS 2119) (check-in: 36877448 user: drh tags: trunk)
08:17
Documentation for REINDEX and ALTER TABLE commands. (CVS 2118) (check-in: aceaa5f6 user: danielk1977 tags: trunk)
06:05
Add a documentation page for compilation options. Still some work to go. (CVS 2117) (check-in: 5efa2d2a user: danielk1977 tags: trunk)
2004-11-19
11:59
Split up the lang.html page into a seperate page for each command. (CVS 2116) (check-in: ea315668 user: danielk1977 tags: trunk)
08:41
Ensure ALTER TABLE respects the system table convention - "sqlite_*". (CVS 2115) (check-in: f635b6aa user: danielk1977 tags: trunk)
08:02
Update the sqlite_sequence table when a table is renamed with ALTER_TABLE. (CVS 2114) (check-in: 6e971868 user: danielk1977 tags: trunk)
07:07
When dropping a table, update the sqlite_sequence table first, as auto-vacuum mode may need to move sqlite_sequence when the btree table is dropped. (CVS 2113) (check-in: 0514107b user: danielk1977 tags: trunk)
05:14
Fix bugs in ALTER TABLE related to (a) whitespace in table defn, (b) temp triggers. (CVS 2112) (check-in: 1fd8e835 user: danielk1977 tags: trunk)
2004-11-18
15:44
Handle triggers correctly in ALTER TABLE. (CVS 2111) (check-in: c61b7de1 user: danielk1977 tags: trunk)
13:49
Speed improvement on the LIKE command. (CVS 2110) (check-in: 85d56beb user: drh tags: trunk)
02:10
Fix an obsolete comment that resulted in incorrect documentation. Ticket #1003. (CVS 2109) (check-in: c93a9e18 user: drh tags: trunk)
02:04
Clarify the documentation of the sqlite3_create_function API. Ticket #1004. (CVS 2108) (check-in: ae45ad86 user: drh tags: trunk)
2004-11-17
16:41
Add the ESCAPE clause to the LIKE operator. Not fully tested yet. (CVS 2107) (check-in: 49268c2b user: danielk1977 tags: trunk)
10:22
Extra tests and resulting bugfixes for btree cursors. (CVS 2106) (check-in: e1530854 user: danielk1977 tags: trunk)
2004-11-16
23:21
Clarify the LIMIT clause in the documentation. Ticket #1002. (CVS 2105) (check-in: e05f52d9 user: drh tags: trunk)
15:50
Perform deletes in a single pass. (CVS 2104) (check-in: a2e1c35b user: danielk1977 tags: trunk)
04:57
Allow btree cursors to persist through BtreeDelete() calls. (CVS 2103) (check-in: 6ad5fc8e user: danielk1977 tags: trunk)
2004-11-15
23:42
Fix a typo in the header comment to the MakeRecord opcode so that the documentation generator will actually see the opcode description. Ticket #1001. (CVS 2102) (check-in: 33c9b647 user: drh tags: trunk)
01:40
Add test cases for escape characters in the GLOB operator. (CVS 2101) (check-in: bb2d9ff8 user: drh tags: trunk)
2004-11-14
21:56
The SQLITE_OMIT_UTF16 macro now removes lots of code and all tests still pass. (CVS 2100) (check-in: 98c7a554 user: drh tags: trunk)