SQLite

Timeline
Login

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

23 check-ins using file main.mk version b2d38013

2005-07-23
00:41
First code for the ANALYZE command. Mostly untested. The analysis is not loaded into the symbol tables and is not used by the optimizer. (CVS 2560) (check-in: a4886b11 user: drh tags: trunk)
2005-07-22
23:56
Clarify the meaning of the TEMP keyword on CREATE TABLE. (CVS 2559) (check-in: 1a573619 user: drh tags: trunk)
22:53
Correct the documentation to show that sqlite3_column_text() returns a NULL pointer (not an empty string) when the column value is NULL. The same goes for sqlite3_column_blob(). Ticket #1334. (CVS 2558) (check-in: fd1e013a user: drh tags: trunk)
00:31
Begin adding code to support multiple IN constraints on the same index. (CVS 2557) (check-in: 103f8ccb user: drh tags: trunk)
2005-07-21
18:23
Split the OP_Integer opcode into OP_Integer and OP_Int64. This allows comments to be added to OP_Integer. Cleanup in the optimizer. Allow terms of the FROM clause to be reordered automatically. (CVS 2556) (check-in: e2f822ac user: drh tags: trunk)
03:48
Add comments to test cases. Improvements to the query plan test variable. (CVS 2555) (check-in: ef3a157f user: drh tags: trunk)
03:15
In where.c, split out the code that selects an index into a separate subroutine. (CVS 2554) (check-in: c30cbba9 user: drh tags: trunk)
2005-07-20
14:31
Extra memory usage instrumentation added. (CVS 2553) (check-in: ac669f56 user: drh tags: trunk)
2005-07-19
22:22
More refactoring in where.c. (CVS 2552) (check-in: a35bd50a user: drh tags: trunk)
17:38
Refactoring of the query optimizer in advance of adding better optimization. (CVS 2551) (check-in: 57c6bd37 user: drh tags: trunk)
2005-07-16
13:33
Allow an unlimited number of terms in the WHERE clause. The old limit was 100. (CVS 2550) (check-in: ca69f368 user: drh tags: trunk)
2005-07-15
23:24
Fix bugs in the new query plan instrumention logic. (CVS 2549) (check-in: 578490c9 user: drh tags: trunk)
13:05
Add test instrumentation that will be needed during the development of forthcoming optimizer enhancements. (CVS 2548) (check-in: dfd5fd77 user: drh tags: trunk)
2005-07-09
23:11
Add remark in the changelog that mentions 64-bit alignment fixes in 3.2.2. (CVS 2547) (check-in: ead583cf user: drh tags: trunk)
02:39
Fix a comment error. No changes to code. Ticket #1320. (CVS 2546) (check-in: e050af70 user: drh tags: trunk)
02:38
Use the internal sqlite3_snprintf function instead of sprintf to avoid cross-platform incompatibilities. Ticket #1316. (CVS 2545) (check-in: 431999da user: drh tags: trunk)
02:23
Patch to Makefile.in so that it works with OS X. Ticket #1292. (CVS 2544) (check-in: 0dfabca6 user: drh tags: trunk)
02:16
Make sure there is only one busy counter. Ticket #1315. (CVS 2543) (check-in: af2a0ba4 user: drh tags: trunk)
2005-07-08
18:25
Allow the IN operator to take a list of arbitrary expressions on its right-hand side. The expressions no longer need to be constant. The current implementation seems to work but needs more testing and optimization. (CVS 2542) (check-in: ba56478d user: drh tags: trunk)
17:13
Change the name of the OpenTemp opcode to OpenVirtual which is more descriptive of what it does. (CVS 2541) (check-in: 3bb9ce5f user: drh tags: trunk)
14:14
Add the EP_OptOnly flag on expressions for WHERE clause terms that are added by the optimizer but should not be coded. (CVS 2540) (check-in: f4a66ed0 user: drh tags: trunk)
13:53
Add the SQLITE_CASE_SENSITIVE_LIKE compile-time option. (CVS 2539) (check-in: b72bff81 user: drh tags: trunk)
13:08
Replace OP_List with OP_Fifo. This is the first step toward allowing recursive delete triggers and later foreign keys with cascading deletes. (CVS 2538) (check-in: 94c120bb user: drh tags: trunk)