SQLite

Timeline
Login

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

200 check-ins occurring around 4ab994a87ee844f4.

2005-10-05
10:40
Changes to support TEA on cygwin. (CVS 2742) (check-in: e80fecc986 user: drh tags: trunk)
10:29
Another attempt to get fdatasync to be ignored on non-conforming posix systems. Now a system has to opt-in for fdatasync instead of opt-out. Ticket #1467. (CVS 2741) (check-in: 115340d4e8 user: drh tags: trunk)
02:13
Add the SQLITE_OMIT_GET_TABLE compile-time flag. (CVS 2740) (check-in: 6d4bc8f83b user: drh tags: trunk)
2005-10-04
18:38
Automatically check for the fdatasync() function and replace it with fsync() if not found. (CVS 2739) (check-in: 385a08afef user: drh tags: trunk)
2005-10-03
15:11
The hash tables deallocate when empty in order to avoid nuisanse complaints from valgrind. Added tests to verify no hash table memory leaks in os_unix.c. (CVS 2738) (check-in: 080eadca58 user: drh tags: trunk)
2005-09-25
01:13
Make sure the default storage for virtual tables is the disk not memory while running conflict.test. Ticket #1453. (CVS 2737) (check-in: 6d780ca6cf user: drh tags: trunk)
2005-09-24
15:25
Version 3.2.7 (CVS 2736) (check-in: bd141a7c12 user: drh tags: trunk)
15:10
Perparations for version 3.2.7. (CVS 2735) (check-in: 70937d5cfa user: drh tags: trunk)
11:01
Add the SQLite console source code in the contrib section of the source tree. (CVS 2734) (check-in: 079c6348f9 user: drh tags: trunk)
2005-09-23
21:11
Fix an uninitialized structure member that was causing a malfunction when you used deeply nested and very complex views. Ticket #1449. (CVS 2733) (check-in: 352cc9f53b user: drh tags: trunk)
2005-09-22
15:45
Optionally call fdatasync() instead of fsync() only if _POSIX_SYNCHRONIZED_IO is positive, which should only be the case on operating systems that actually support fdatasync(). (CVS 2732) (check-in: a9b341dccf user: drh tags: trunk)
2005-09-20
18:13
Add VM code comments on the group-by processing. Extra group-by test case. (CVS 2731) (check-in: 655e75ac7d user: drh tags: trunk)
17:42
Code cleanup and simplification. Three new Mem opcodes added. The sqlite3VdbeJumpHere function added. (CVS 2730) (check-in: 2471957fee user: drh tags: trunk)
13:55
Cleanup the implementation and the documentation of the new 0x200 P1 flag on the VDBE comparison operands. (CVS 2729) (check-in: f22d0f64a0 user: drh tags: trunk)
13:12
NULLs compare equal to each other when computing GROUP BY categories. (CVS 2728) (check-in: d9b0c97053 user: drh tags: trunk)
08:47
Update comments in where.c. No code changes. (CVS 2727) (check-in: bb84d27eda user: drh tags: trunk)
01:36
Documentation updates. (CVS 2726) (check-in: 6ec8883c36 user: drh tags: trunk)
2005-09-19
21:05
ON-clause terms in a LEFT JOIN that restrict only the left table, should not really restrict the left table but instead rows that fail to meet the condition to be joined with NULL rows from the right table. (CVS 2725) (check-in: ea10f9785e user: drh tags: trunk)
19:05
Set the default maximum page size to 32768, not 8192. (CVS 2724) (check-in: b32e9ec248 user: drh tags: trunk)
17:35
Do not optimize views with an ORDER BY clause if they are used in a UNION ALL that also has an ORDER BY clause. Ticket #1444. (CVS 2723) (check-in: 6cc57fcf15 user: drh tags: trunk)
15:37
Fix uninitialized value on a UNION ALL select with an ORDER BY clause. (CVS 2722) (check-in: 92126a2161 user: drh tags: trunk)
13:15
The sqlite3_query_plan debugging variable now only appears with SQLITE_TEST=1. (CVS 2721) (check-in: 41e226d2ff user: drh tags: trunk)
12:53
Work around limitations of MSVC++ 6. Tickets #1429, #1437, and #1440. (CVS 2720) (check-in: b2d1803c25 user: drh tags: trunk)
12:37
Change some debugging #defines in order to get SSE working again after recent upgrades. (CVS 2719) (check-in: 86eb7d8363 user: drh tags: trunk)
2005-09-17
19:28
Download page reports sizes in MiB and KiB instead of just bytes. (CVS 2718) (check-in: e985f02d20 user: drh tags: trunk)
19:14
Update to the download page on the website. (CVS 2717) (check-in: 91bc0d0032 user: drh tags: trunk)
18:49
Version 3.2.6 (CVS 2716) (check-in: 1cdfe66714 user: drh tags: trunk)
18:34
The sqlite3ReallocOrFree routine should set its pointer to NULL when it fails. (CVS 2715) (check-in: 0e85af44fa user: drh tags: trunk)
18:02
Fix up the busy test so that it can be run multiple times in a row without giving false errors on 2nd and subsequent runs. (CVS 2714) (check-in: 7a7ba73fb5 user: drh tags: trunk)
17:58
Fix a memory leak that occurs after malloc fails. (CVS 2713) (check-in: 85b931bf72 user: drh tags: trunk)
17:05
Fix the crash.test script to accomodate recent changes. (CVS 2712) (check-in: d594608ff3 user: drh tags: trunk)
16:48
Fix a bug in the lock2 test script introduced by check-in (2709) (CVS 2711) (check-in: c3bf17436b user: drh tags: trunk)
16:36
Fix a problem with the lock_status pragma and the UTF-16 encoding. (CVS 2710) (check-in: 1a737b457c user: drh tags: trunk)
15:20
Changes to make corruption errors easier to track down. (CVS 2709) (check-in: c07330000b user: drh tags: trunk)
15:17
Update the webpage description of 3.2.6 changes to talk about ticket #1432. (CVS 2708) (check-in: 0e23c28b25 user: drh tags: trunk)
13:29
Bug fix in the ORDER BY optimizer. Ticket #1435. (CVS 2707) (check-in: 553b7ba8f8 user: drh tags: trunk)
13:07
Make sure dependencies on the right-hand side of IN operators are checked correctly. Ticket #1433. (CVS 2706) (check-in: 21740794ab user: drh tags: trunk)
02:34
Updates to the FAQ. (CVS 2705) (check-in: 0eaf430d95 user: drh tags: trunk)
2005-09-16
17:16
Do not journal the locking page which doing an autovacuum. Similar to the problem of #1432 except that this one occurs on autovacuum instead of vacuum. An assert() has been added to catch any future incidents of this type. (CVS 2704) (check-in: 5b6dc12b7d user: drh tags: trunk)
11:32
Do not journal the file locking page when doing a database copy as part of a VACUUM. Ticket #1432. (CVS 2703) (check-in: 248f77972b user: drh tags: trunk)
10:18
Prevent the sqlite3_pagecount() function from ever returning the pending-byte page. (CVS 2702) (check-in: 35a8893537 user: danielk1977 tags: trunk)
10:13
Move the definition of sqlite3_pending_byte from test2.c to os_common.h. (CVS 2701) (check-in: bedf702f53 user: danielk1977 tags: trunk)
09:52
Fix an auto-vacuum problem with the PENDING_BYTE page. Also link the Tcl variable sqlite_pending_byte to the internal pending-byte location when in test mode. (CVS 2700) (check-in: 9115e0621d user: danielk1977 tags: trunk)
02:55
Documentation changes in preparation for the release of 3.2.6. (CVS 2698) (check-in: 243f455c7c user: drh tags: trunk)
02:48
Undo check-in (2694). (CVS 2697) (check-in: 6017b19625 user: drh tags: trunk)
02:38
Fix a whole host of newly discovered memory leaks the occur after a failure of realloc(). (CVS 2696) (check-in: 4686d64975 user: drh tags: trunk)
00:27
Fix a memory leak: a failure to deallocate the P3 parameter on a call to sqlite3VdbeChangeP3. (CVS 2695) (check-in: 714254cbc1 user: drh tags: trunk)
2005-09-15
21:24
The table_info pragma now gives the order of columns in the primary key. (CVS 2694) (check-in: 9b60f48de7 user: drh tags: trunk)
2005-09-13
16:12
Correct the sense of a test for SQLITE_DEBUG on the resent NDEBUG change. Ticket #1425 (CVS 2693) (check-in: 81fdffdff6 user: drh tags: trunk)
07:00
Updates to the documentation on the TCL bindings. (CVS 2692) (check-in: 94aa2d3245 user: drh tags: trunk)
00:02
Fix a comment typo in the previous check-in. (CVS 2691) (check-in: 49c952807d user: drh tags: trunk)
00:00
Automatically set the NDEBUG preprocessor macro unless SQLITE_DEBUG is set. In this way, assert() statements become opt-in rather than opt-out. (CVS 2690) (check-in: 2ec2bd8574 user: drh tags: trunk)
2005-09-12
23:03
Bug fix in the new COUNT(DISTINCT) logic. Ticket #1420. (CVS 2689) (check-in: 37116550d3 user: drh tags: trunk)
2005-09-11
11:56
COUNT(DISTINCT x) is now fully functional, though it could benefit from additional testing. (CVS 2688) (check-in: 2f397bd814 user: drh tags: trunk)
02:03
The ".dump" command from the shell correctly saves the state of the sqlite_sequence and sqlite_stat1 tables, if they exist. Ticket #1419. (CVS 2687) (check-in: 3f191cf497 user: drh tags: trunk)
2005-09-10
22:40
The shell does not output the sqlite_stat1 table on .dump or .schema. The ANALYZE command now gathers statistics on tables that have only a single index because this sometimes helps when reordering tables in a join. (CVS 2686) (check-in: 26565b8931 user: drh tags: trunk)
16:46
Add the experimental EXPLAIN QUERY PLAN diagnostic capability. (CVS 2685) (check-in: 986efb7b12 user: drh tags: trunk)
15:35
Avoid a memory leak and/or assertion failure when parsing a table declaration that contains a duplicate column name. Ticket #1418. (CVS 2684) (check-in: f43427742b user: drh tags: trunk)
15:28
Use of the CROSS keyword in a join prevents table reordering. Ticket #1414. (CVS 2683) (check-in: 415b8b2462 user: drh tags: trunk)
2005-09-09
10:46
Enhanced disk-full tests. (CVS 2682) (check-in: 0288fa5d25 user: drh tags: trunk)
10:17
Detect errors returned by SetFilePointer on windows. (CVS 2681) (check-in: bc8c33f94c user: drh tags: trunk)
01:33
Infrastructure for the DISTINCT keyword in aggregate functions. But it does not work yet. If you try to use it you get an error message. (CVS 2680) (check-in: 4d62e36fe3 user: drh tags: trunk)
01:32
Defend against disk I/O errors that happen during an sqlite3OsSeek(). (CVS 2679) (check-in: 461e3a0a27 user: drh tags: trunk)
2005-09-08
20:37
SUM returns NULL when it has no inputs. Ticket #1413. (CVS 2678) (check-in: 6281859425 user: drh tags: trunk)
19:45
A SUM() of all NULLs returns NULL. A SUM() of nothing return 0. A SUM() of a mixture of NULLs and numbers returns the sum of the numbers. Ticket #1413. (CVS 2677) (check-in: 2e6230edfd user: drh tags: trunk)
19:01
Remove a C++ism that snuck in on one of the reason changes. (CVS 2676) (check-in: 48f6a331ef user: drh tags: trunk)
14:17
Remove a few unused variables detected by Borland C. Ticket #1412. (CVS 2675) (check-in: cdfe372a95 user: drh tags: trunk)
12:57
Aggregates with GROUP BY can sometimes return no result rows. (CVS 2674) (check-in: 0c3e368d47 user: drh tags: trunk)
12:38
While doing a transaction comment, use fdatasync() instead of fsync() in cases there the file size is unchanged. (CVS 2673) (check-in: 3c555a8749 user: drh tags: trunk)
12:37
Fix another test to account for SUM() returning integer rather than float. (CVS 2672) (check-in: bc723235e6 user: drh tags: trunk)
11:04
Fix typos in documentation. Ticket #1239. (CVS 2671) (check-in: 73fbb8d968 user: drh tags: trunk)
10:58
Fix a comment in sqlite.h. Ticket #1321. (CVS 2670) (check-in: ed4e9e751b user: drh tags: trunk)
10:37
The SUM() aggregate function returns an integer result if all inputs are integers. Any single non-integer input causes the result to be a floating point value. (CVS 2669) (check-in: 21adf4bd99 user: drh tags: trunk)
02:00
Changes to comments only in sqliteInt.h. No changes to code. (CVS 2668) (check-in: cc2a61650e user: drh tags: trunk)
01:58
Optimizations and refinements. Improvements to test coverage. (CVS 2667) (check-in: 7283f7c29d user: drh tags: trunk)
00:13
All regression tests now pass. But I am sure there must still be problems. New tests need to be added. (CVS 2666) (check-in: bcc7d722ce user: drh tags: trunk)
2005-09-07
23:05
More bug fixes. All of the "quick" tests pass. The full test suite still shows problems. (CVS 2665) (check-in: a1b6d910cd user: drh tags: trunk)
22:48
More bug fixes. But there are still tests that fail. (CVS 2664) (check-in: 7e85a162d0 user: drh tags: trunk)
22:09
Bug fixes in aggregate processing. Fewer tests fail. (CVS 2663) (check-in: c3ac58592f user: drh tags: trunk)
21:22
Rewrite the aggregate handling logic so that it runs in O(1) space. This is the first cut at the code. Many regression tests fail. (CVS 2662) (check-in: 17039ec3ff user: drh tags: trunk)
2005-09-06
21:40
Changes to reduce the amount of stack space required. (CVS 2661) (check-in: b86bd70f30 user: drh tags: trunk)
20:36
Cleanup the processing of MEM_Agg elements. (CVS 2660) (check-in: 7ecf3654aa user: drh tags: trunk)
10:26
Fix ANALYZE so that it works even if the empty_result_callbacks pragma is enabled. Ticket #1409. (CVS 2659) (check-in: bfdaef1224 user: drh tags: trunk)
2005-09-05
20:35
Make due with "sub()" instead of "gsub()" in awk scripts so that builds will work on Solaris which will runs an archiac version of AWK. (CVS 2658) (check-in: 449a789599 user: drh tags: trunk)
20:06
Fix bugs introduced by checkin (2656) and do some modest code enhancements. (CVS 2657) (check-in: 7b56763a8b user: drh tags: trunk)
19:08
Use the unicode API to win32 where available. Tickets #1407, #1396, #1331, #1243, #1206 (CVS 2656) (check-in: 3ec58c673a user: drh tags: trunk)
2005-09-01
17:47
Fix over-aggressive optimization of ORDER BY as reported on the mailing list. (CVS 2655) (check-in: efbb4bc83c user: drh tags: trunk)
12:16
All regression tests now pass with the new bounded-memory sort code. There is still lots of opportunity for optimization, however. (CVS 2654) (check-in: 81259a01f1 user: drh tags: trunk)
03:07
Sorting is now done using a sorting index rather than loading the entire result set into memory and doing a merge sort. The old merge sort technique was a carry-over from SQLite version 1. The new method uses a bounded amount of memory and scales to much larger result sets. There are still errors: some 39 regression tests fail. (CVS 2653) (check-in: 09db0a2424 user: drh tags: trunk)
2005-08-31
18:20
{quote: KeyInfo} generation moved to a common subroutine. (CVS 2652) (check-in: a25801df06 user: drh tags: trunk)
13:48
Updates to the query optimizer overview document. (CVS 2651) (check-in: b1dceef050 user: drh tags: trunk)
13:13
Explicit typecasts to silence nuisance compiler warnings. Ticket #1398. (CVS 2650) (check-in: 90712ea727 user: drh tags: trunk)
03:13
Refinements to the optimizer overview and integration into the website. (CVS 2649) (check-in: ccd12e9e79 user: drh tags: trunk)
02:46
Update the FAQ to include an entry about binary versus decimal numbers. (CVS 2648) (check-in: 0bbe73fccf user: drh tags: trunk)
01:49
Adding the first cut of the optimizer overview document. (CVS 2647) (check-in: 4c8d0a4c26 user: drh tags: trunk)
2005-08-30
22:44
Adjust the makefile for new optimizer documentation. (CVS 2646) (check-in: 14668c85b8 user: drh tags: trunk)
22:44
Initial work on documentation describing the optimizer. (CVS 2645) (check-in: 5cebd7ba3c user: drh tags: trunk)
20:12
The CSV output mode does not sign-extend bytes where the high-order bit is set. Ticket #1397. (CVS 2644) (check-in: 528df777e5 user: drh tags: trunk)
19:30
Fix printf.c so that it handles 10.0 correctly. (CVS 2643) (check-in: 0f7a53f78d user: drh tags: trunk)
00:54
Minor code enhancements. (CVS 2642) (check-in: 4ab994a87e user: drh tags: trunk)
00:10
Update the home page to brag about 150KiB code footprint when optional features are omitted. (CVS 2641) (check-in: 0e1ac1284c user: drh tags: trunk)
2005-08-29
23:06
Make the shell aware of SQLITE_OMIT_MEMORYDB. Ticket #1395. (CVS 2640) (check-in: 71a71cef5b user: drh tags: trunk)
23:00
Increase resolution of time-of-day on unix. Add an experimental sqlite3_profile() API. (CVS 2639) (check-in: ed2ca0873f user: drh tags: trunk)
16:40
Initialize a local variable to avoid a nuisance compiler warning. Ticket #1394. (CVS 2638) (check-in: 9b914901a1 user: drh tags: trunk)
2005-08-28
17:00
The LIKE optimization does the right thing when collating sequences are present. LIKE expressions where the left-hand side has COLLATE NOCASE are optimized in the default case. (CVS 2637) (check-in: ef84ff795c user: drh tags: trunk)
01:38
Improvements to the formatting and layout of the code in the previous checkin. (CVS 2636) (check-in: 73b430de0c user: drh tags: trunk)
01:34
Add an assert to verify that floating point values and integers use the same byte order. Add a comment to the SELECT code generator. (CVS 2635) (check-in: 07b4892149 user: drh tags: trunk)
2005-08-27
17:23
Version 3.2.5 (CVS 2634) (check-in: b2415a749c user: drh tags: trunk)
17:22
Change the wording of the news line for release 3.2.5. (CVS 2633) (check-in: 70db46d3ef user: drh tags: trunk)
17:19
Get the date right. Today is the 27th, not the 25th or the 28th. (CVS 2632) (check-in: 905b9d6c5e user: drh tags: trunk)
17:06
Increase the version number and update web pages for the next release. (CVS 2631) (check-in: e6039e909a user: drh tags: trunk)
16:36
Disable synchronous writes to the master journal when PRAGMA synchronous=OFF for all database files. Ticket #1375. (CVS 2630) (check-in: 644b96aa23 user: drh tags: trunk)
13:16
Fix comment in vdbeapi.c. Remove unused structure definition from func.c. (CVS 2629) (check-in: 51a381345d user: drh tags: trunk)
13:11
Remove the words "statically linked" from the description of the shell on the download page. Ticket #1391. (CVS 2628) (check-in: ecb9604457 user: drh tags: trunk)
09:07
Remove GNUmake extensions from the makefile. Ticket #1390. (CVS 2627) (check-in: d0691fed43 user: drh tags: trunk)
01:51
Do not change fields of stale sqlite3 handles. Ticket #1384. (CVS 2626) (check-in: 7e05b7ca0c user: drh tags: trunk)
01:50
Widen the opcode column of explain output in the shell. (CVS 2625) (check-in: dd3b00aa0b user: drh tags: trunk)
2005-08-25
12:45
When the left-hand side of an IN operator is constant and the right-hand side is a SELECT, recognize that the IN operator is not constant. Ticket #1380. (CVS 2624) (check-in: fc9e04609b user: drh tags: trunk)
2005-08-24
18:04
Fix the --enable-threadsafe option to the configure script. Ticket #1378. (CVS 2623) (check-in: 76ec0b3d3a user: drh tags: trunk)
17:07
Additional defense against the rowid-fifo overflow problem. (CVS 2622) (check-in: 881dcf5fb1 user: drh tags: trunk)
16:54
Remove a stray C++ style comment causing problems for some compilers. (CVS 2621) (check-in: aa7dd3f2c7 user: drh tags: trunk)
16:13
Fix a bug in DELETE that might cause a segfault when deleting more than 40940 rows of data all at once. (CVS 2620) (check-in: 7c599bae33 user: drh tags: trunk)
11:14
Version 3.2.4 (CVS 2619) (check-in: 8cef2c1ae7 user: drh tags: trunk)
11:07
Increase the version number and update the change log prior to release. (CVS 2618) (check-in: 139a28d231 user: drh tags: trunk)
03:52
After calling realloc() on an array to resize it, be sure not to use pointers into the old array. Ticket #1376. (CVS 2617) (check-in: 9f9a257123 user: drh tags: trunk)
2005-08-23
11:31
Allow floating point literals to being or end with a decimal point. Ticket #1371. (CVS 2616) (check-in: a715e70012 user: drh tags: trunk)
11:17
Handle empty blob constants correctly. Ticket #1373. (CVS 2615) (check-in: 5cada745ac user: drh tags: trunk)
11:03
Fix another documentation typo. (CVS 2614) (check-in: 55f4b14e19 user: drh tags: trunk)
11:00
Fix typos in syntax documentation. Ticket #1374 and a report on the mailing list. (CVS 2613) (check-in: 990d1f3a5b user: drh tags: trunk)
2005-08-22
02:10
Update the download page of the website to handle TEA builds and starkits. (CVS 2612) (check-in: 1fab599b6f user: drh tags: trunk)
2005-08-21
21:45
Clean up possible locking problem in multithreaded applications that take a malloc failure. (CVS 2611) (check-in: 545e702a23 user: drh tags: trunk)
18:54
Version 3.2.3 (CVS 2610) (check-in: f620319b44 user: drh tags: trunk)
18:40
Increase the version number and adjust documentation prior to the next release. (CVS 2609) (check-in: b15ed7db4d user: drh tags: trunk)
18:21
Disable malloc tests when not compiled with SQLITE_DEBUG. (CVS 2608) (check-in: f372682fa3 user: drh tags: trunk)
17:48
Do not create an error message if there is no error. (CVS 2607) (check-in: 3aa47c5587 user: drh tags: trunk)
16:54
Do not overwrite small files (less than 1024 bytes) that are not databases. Ticket #1370. (CVS 2606) (check-in: 7f4302686e user: drh tags: trunk)
2005-08-20
13:47
More test coverage improvements. (CVS 2605) (check-in: e559e810a5 user: drh tags: trunk)
03:03
Increased test coverage. Some malloc tests now fail though this is believed to be an instrumentation problem not a real error. (CVS 2604) (check-in: f786f37a5e user: drh tags: trunk)
2005-08-19
19:14
Increase test coverage of alter.c to 100%. Fix bugs found in the process. (CVS 2603) (check-in: b550d04d43 user: drh tags: trunk)
03:03
Additional tests for better coverage. (CVS 2602) (check-in: 4281a838f2 user: drh tags: trunk)
02:26
Increased test coverage on trigger.c and printf.c. (CVS 2601) (check-in: 842a80bd8f user: drh tags: trunk)
01:07
More test coverage enhancements. (CVS 2600) (check-in: 0b6cd5acc0 user: drh tags: trunk)
00:14
Bring testing coverage of the analyze.c file up to 100%. Bugs found and fixed in the process. (CVS 2599) (check-in: 2fe0ac4fa4 user: drh tags: trunk)
2005-08-18
18:15
Comment fixes. No changes to the underlying code. (CVS 2598) (check-in: b865e243ee user: drh tags: trunk)
2005-08-16
14:44
Fix typo in documentation. (CVS 2597) (check-in: 32efcd2461 user: drh tags: trunk)
11:11
Null-terminate the strings array passed to Tcl_GetIndexFromObj. Bug reported on the mailing list. (CVS 2596) (check-in: 3a7918a66b user: drh tags: trunk)
2005-08-14
20:47
General code cleanup resulting in smaller footprint. (CVS 2595) (check-in: 98338abf9e user: drh tags: trunk)
17:53
Split the sqlite3_complete() API out into a separate source file so that in static links where it is not used it will not take up space in the resulting binary. (CVS 2594) (check-in: 62b87751de user: drh tags: trunk)
01:34
Declare local-use functions as static. Ticket #1363. (CVS 2593) (check-in: 94efd79088 user: drh tags: trunk)
01:20
The case_sensitive_like pragma added. Test cases added for the LIKE optimization. (CVS 2592) (check-in: 72ee21c05e user: drh tags: trunk)
2005-08-13
18:15
Provide grave accent quoting of identifiers for MySQL compatibility. Ticket #1337. (CVS 2591) (check-in: 6b7a4e9752 user: drh tags: trunk)
17:17
Give the same access permissions to journal files as is given to databases. (CVS 2590) (check-in: 7961ec0ccb 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: 4f07661279 user: drh tags: trunk)
13:40
Fix a comment in printf. (CVS 2588) (check-in: 1054685f15 user: drh tags: trunk)
13:39
Additional cleanup and optimization of the printf function. (CVS 2587) (check-in: 240bb04900 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: 4b98dace6b user: drh tags: trunk)
03:07
Make the round() function work correctly on numbers with very large exponents. Ticket #1340. (CVS 2585) (check-in: 4f47c3c884 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: 25cfe9390d 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: d6146a542a user: drh tags: trunk)
22:58
Improved error message when a #NNN parameter appears on user input. Additional coverage testing. (CVS 2582) (check-in: 3c00f5982a 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: 3edbe8d621 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: fa7403c7d9 user: drh tags: trunk)
01:25
Add 2005 open source award badge and news announcement. (CVS 2579) (check-in: 8e007f8c06 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: 73fafd2148 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: fb7a258fd3 user: drh tags: trunk)
17:48
Minor refactoring of the new optimizer code. (CVS 2576) (check-in: 868322f7b7 user: drh tags: trunk)
17:38
Update the documentation for the new transaction method on the TCL interface. (CVS 2575) (check-in: 3dc823a0ac user: drh tags: trunk)
17:15
Tests and bug fixes on the new transaction method in the TCL interface. (CVS 2574) (check-in: 68dd0ed5e3 user: drh tags: trunk)
17:13
Fix a bug in the btree balancer. ticket #1346. (CVS 2573) (check-in: 3af69a4928 user: drh tags: trunk)
12:21
Add the "transaction" coommand to the TCL interface. Untested. (CVS 2572) (check-in: a5ce6c58c3 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: 1a4e526d46 user: drh tags: trunk)
15:36
Fix authentication so that it works with AS aliases. Ticket #1338. (CVS 2570) (check-in: cc7ae73ed0 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: d23c8bf81e 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: cdf8c9584b user: drh tags: trunk)
20:51
Test cases and tuning of the new optimizer code. (CVS 2567) (check-in: 4b02703dec user: drh tags: trunk)
16:51
The new optimizer now passes all regression tests. (CVS 2566) (check-in: a212128433 user: drh tags: trunk)
2005-07-27
20:41
More work on the new optimizer. Fewer tests fail now. (CVS 2565) (check-in: ee3a08e353 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: 86ce56ccea user: drh tags: trunk)
14:52
Store the total number of rows as part of the ANALYZE statistics. (CVS 2563) (check-in: 868279c78e 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: 1996bacfb9 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: bd7583a5d6 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: a4886b114d user: drh tags: trunk)
2005-07-22
23:56
Clarify the meaning of the TEMP keyword on CREATE TABLE. (CVS 2559) (check-in: 1a573619f5 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: fd1e013a14 user: drh tags: trunk)
00:31
Begin adding code to support multiple IN constraints on the same index. (CVS 2557) (check-in: 103f8ccb90 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: e2f822ac82 user: drh tags: trunk)
03:48
Add comments to test cases. Improvements to the query plan test variable. (CVS 2555) (check-in: ef3a157f46 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: c30cbba9ea user: drh tags: trunk)
2005-07-20
14:31
Extra memory usage instrumentation added. (CVS 2553) (check-in: ac669f56c0 user: drh tags: trunk)
2005-07-19
22:22
More refactoring in where.c. (CVS 2552) (check-in: a35bd50af8 user: drh tags: trunk)
17:38
Refactoring of the query optimizer in advance of adding better optimization. (CVS 2551) (check-in: 57c6bd3760 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: ca69f36832 user: drh tags: trunk)
2005-07-15
23:24
Fix bugs in the new query plan instrumention logic. (CVS 2549) (check-in: 578490c913 user: drh tags: trunk)
13:05
Add test instrumentation that will be needed during the development of forthcoming optimizer enhancements. (CVS 2548) (check-in: dfd5fd77b0 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: ead583cfad user: drh tags: trunk)
02:39
Fix a comment error. No changes to code. Ticket #1320. (CVS 2546) (check-in: e050af70ad 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: 431999da7b user: drh tags: trunk)
02:23
Patch to Makefile.in so that it works with OS X. Ticket #1292. (CVS 2544) (check-in: 0dfabca641 user: drh tags: trunk)
02:16
Make sure there is only one busy counter. Ticket #1315. (CVS 2543) (check-in: af2a0ba4a3 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: ba56478dd8 user: drh tags: trunk)