SQLite

Timeline
Login

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

50 check-ins using file Makefile.in version 22ea9c0f

2005-08-14
01:34
Declare local-use functions as static. Ticket #1363. (CVS 2593) (check-in: 94efd790 user: drh tags: trunk)
01:20
The case_sensitive_like pragma added. Test cases added for the LIKE optimization. (CVS 2592) (check-in: 72ee21c0 user: drh tags: trunk)
2005-08-13
18:15
Provide grave accent quoting of identifiers for MySQL compatibility. Ticket #1337. (CVS 2591) (check-in: 6b7a4e97 user: drh tags: trunk)
17:17
Give the same access permissions to journal files as is given to databases. (CVS 2590) (check-in: 7961ec0c user: drh tags: trunk)
16:13
Disable an overzealous optimization the omitted sorting on a join if the first table gave a unique result. The sort can only be omitted if all tables in the join are unique. Ticket #1358. (CVS 2589) (check-in: 4f076612 user: drh tags: trunk)
13:40
Fix a comment in printf. (CVS 2588) (check-in: 1054685f user: drh tags: trunk)
13:39
Additional cleanup and optimization of the printf function. (CVS 2587) (check-in: 240bb049 user: drh tags: trunk)
12:59
Add the "!" flag to the "%g" mprintf conversion parameter to force a decimal point. This prevents floating point values from appearing as integers. Use this flag when converting floating point to text. Ticket #1362. (CVS 2586) (check-in: 4b98dace user: drh tags: trunk)
03:07
Make the round() function work correctly on numbers with very large exponents. Ticket #1340. (CVS 2585) (check-in: 4f47c3c8 user: drh tags: trunk)
00:56
Fix a memory leak that occurs when a CREATE TABLE that contains a DEFAULT VALUE fails due to a name conflict. Tickets #1356 and #1357. (CVS 2584) (check-in: 25cfe939 user: drh tags: trunk)
2005-08-12
23:20
3rd argument to sqlite3Error() should always be a format string, never user-supplied error message text. Ticket #1354. (CVS 2583) (check-in: d6146a54 user: drh tags: trunk)
22:58
Improved error message when a #NNN parameter appears on user input. Additional coverage testing. (CVS 2582) (check-in: 3c00f598 user: drh tags: trunk)
22:56
Optimize LIKE and GLOB operators in the WHERE clause. Code passes all regression tests but still needs additional tests. (CVS 2581) (check-in: 3edbe8d6 user: drh tags: trunk)
2005-08-11
02:10
Improve the error message associated with SQLITE_FULL. Ticket #1353. Also remove error messages for obsolete error codes SQLITE_INTERNAL, SQLITE_NOTFOUND, and SQLITE_TOOBIG. (CVS 2580) (check-in: fa7403c7 user: drh tags: trunk)
01:25
Add 2005 open source award badge and news announcement. (CVS 2579) (check-in: 8e007f8c user: drh tags: trunk)
2005-08-05
18:50
Make sure the .import command strips newlines off the end of the last field in each line imported. Ticket #1348 (CVS 2578) (check-in: 73fafd21 user: drh tags: trunk)
2005-08-02
21:42
Comment out the use of memory high-water marks when not compiling with SQLITE_MEMDEBUG. (CVS 2577) (check-in: fb7a258f user: drh tags: trunk)
17:48
Minor refactoring of the new optimizer code. (CVS 2576) (check-in: 868322f7 user: drh tags: trunk)
17:38
Update the documentation for the new transaction method on the TCL interface. (CVS 2575) (check-in: 3dc823a0 user: drh tags: trunk)
17:15
Tests and bug fixes on the new transaction method in the TCL interface. (CVS 2574) (check-in: 68dd0ed5 user: drh tags: trunk)
17:13
Fix a bug in the btree balancer. ticket #1346. (CVS 2573) (check-in: 3af69a49 user: drh tags: trunk)
12:21
Add the "transaction" coommand to the TCL interface. Untested. (CVS 2572) (check-in: a5ce6c58 user: drh tags: trunk)
2005-07-29
19:43
Fix problems caused by over-agressive optimization of ORDER BY in joins. Lots more testing needed. (CVS 2571) (check-in: 1a4e526d user: drh tags: trunk)
15:36
Fix authentication so that it works with AS aliases. Ticket #1338. (CVS 2570) (check-in: cc7ae73e user: drh tags: trunk)
15:10
Optimizer now converts OR-connected WHERE-clause terms into an IN operator so that they can be used with indices. There are known problems with the ORDER BY optimization in this and in several prior check-ins. This check-in is not recommended for production use. (CVS 2569) (check-in: d23c8bf8 user: drh tags: trunk)
2005-07-28
23:12
The BETWEEN operator in a WHERE clause is now able to use indices. (CVS 2568) (check-in: cdf8c958 user: drh tags: trunk)
20:51
Test cases and tuning of the new optimizer code. (CVS 2567) (check-in: 4b02703d user: drh tags: trunk)
16:51
The new optimizer now passes all regression tests. (CVS 2566) (check-in: a2121284 user: drh tags: trunk)
2005-07-27
20:41
More work on the new optimizer. Fewer tests fail now. (CVS 2565) (check-in: ee3a08e3 user: drh tags: trunk)
2005-07-23
22:59
A new optimizer that breaks a lot of tests. But none of them critically, I think. Nevertheless, there is a lot of work ahead to stabilize the code. (CVS 2564) (check-in: 86ce56cc user: drh tags: trunk)
14:52
Store the total number of rows as part of the ANALYZE statistics. (CVS 2563) (check-in: 868279c7 user: drh tags: trunk)
03:18
The results of ANALYZE are now loaded into internal data structures where they can be used. But they are not actually used yet. (CVS 2562) (check-in: 1996bacf user: drh tags: trunk)
02:17
Full-coverage testing and documentation for the ANALYZE command. The results of analysis are still not loaded or used, however. (CVS 2561) (check-in: bd7583a5 user: drh tags: trunk)
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)