SQLite

Timeline
Login

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

100 check-ins occurring around b2415a749c.

2005-09-10
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: f4342774 user: drh tags: trunk
15:28
Use of the CROSS keyword in a join prevents table reordering. Ticket #1414. (CVS 2683) check-in: 415b8b24 user: drh tags: trunk
2005-09-09
10:46
Enhanced disk-full tests. (CVS 2682) check-in: 0288fa5d user: drh tags: trunk
10:17
Detect errors returned by SetFilePointer on windows. (CVS 2681) check-in: bc8c33f9 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: 4d62e36f user: drh tags: trunk
01:32
Defend against disk I/O errors that happen during an sqlite3OsSeek(). (CVS 2679) check-in: 461e3a0a user: drh tags: trunk
2005-09-08
20:37
SUM returns NULL when it has no inputs. Ticket #1413. (CVS 2678) check-in: 62818594 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: 2e6230ed user: drh tags: trunk
19:01
Remove a C++ism that snuck in on one of the reason changes. (CVS 2676) check-in: 48f6a331 user: drh tags: trunk
14:17
Remove a few unused variables detected by Borland C. Ticket #1412. (CVS 2675) check-in: cdfe372a user: drh tags: trunk
12:57
Aggregates with GROUP BY can sometimes return no result rows. (CVS 2674) check-in: 0c3e368d 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: 3c555a87 user: drh tags: trunk
12:37
Fix another test to account for SUM() returning integer rather than float. (CVS 2672) check-in: bc723235 user: drh tags: trunk
11:04
Fix typos in documentation. Ticket #1239. (CVS 2671) check-in: 73fbb8d9 user: drh tags: trunk
10:58
Fix a comment in sqlite.h. Ticket #1321. (CVS 2670) check-in: ed4e9e75 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: 21adf4bd user: drh tags: trunk
02:00
Changes to comments only in sqliteInt.h. No changes to code. (CVS 2668) check-in: cc2a6165 user: drh tags: trunk
01:58
Optimizations and refinements. Improvements to test coverage. (CVS 2667) check-in: 7283f7c2 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: bcc7d722 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: a1b6d910 user: drh tags: trunk
22:48
More bug fixes. But there are still tests that fail. (CVS 2664) check-in: 7e85a162 user: drh tags: trunk
22:09
Bug fixes in aggregate processing. Fewer tests fail. (CVS 2663) check-in: c3ac5859 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: 17039ec3 user: drh tags: trunk
2005-09-06
21:40
Changes to reduce the amount of stack space required. (CVS 2661) check-in: b86bd70f user: drh tags: trunk
20:36
Cleanup the processing of MEM_Agg elements. (CVS 2660) check-in: 7ecf3654 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: bfdaef12 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: 449a7895 user: drh tags: trunk
20:06
Fix bugs introduced by checkin (2656) and do some modest code enhancements. (CVS 2657) check-in: 7b56763a user: drh tags: trunk
19:08
Use the unicode API to win32 where available. Tickets #1407, #1396, #1331, #1243, #1206 (CVS 2656) check-in: 3ec58c67 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: efbb4bc8 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: 81259a01 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: 09db0a24 user: drh tags: trunk
2005-08-31
18:20
{quote: KeyInfo} generation moved to a common subroutine. (CVS 2652) check-in: a25801df user: drh tags: trunk
13:48
Updates to the query optimizer overview document. (CVS 2651) check-in: b1dceef0 user: drh tags: trunk
13:13
Explicit typecasts to silence nuisance compiler warnings. Ticket #1398. (CVS 2650) check-in: 90712ea7 user: drh tags: trunk
03:13
Refinements to the optimizer overview and integration into the website. (CVS 2649) check-in: ccd12e9e user: drh tags: trunk
02:46
Update the FAQ to include an entry about binary versus decimal numbers. (CVS 2648) check-in: 0bbe73fc user: drh tags: trunk
01:49
Adding the first cut of the optimizer overview document. (CVS 2647) check-in: 4c8d0a4c user: drh tags: trunk
2005-08-30
22:44
Adjust the makefile for new optimizer documentation. (CVS 2646) check-in: 14668c85 user: drh tags: trunk
22:44
Initial work on documentation describing the optimizer. (CVS 2645) check-in: 5cebd7ba 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: 528df777 user: drh tags: trunk
19:30
Fix printf.c so that it handles 10.0 correctly. (CVS 2643) check-in: 0f7a53f7 user: drh tags: trunk
00:54
Minor code enhancements. (CVS 2642) check-in: 4ab994a8 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: 0e1ac128 user: drh tags: trunk
2005-08-29
23:06
Make the shell aware of SQLITE_OMIT_MEMORYDB. Ticket #1395. (CVS 2640) check-in: 71a71cef user: drh tags: trunk
23:00
Increase resolution of time-of-day on unix. Add an experimental sqlite3_profile() API. (CVS 2639) check-in: ed2ca087 user: drh tags: trunk
16:40
Initialize a local variable to avoid a nuisance compiler warning. Ticket #1394. (CVS 2638) check-in: 9b914901 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: ef84ff79 user: drh tags: trunk
01:38
Improvements to the formatting and layout of the code in the previous checkin. (CVS 2636) check-in: 73b430de 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: 07b48921 user: drh tags: trunk
2005-08-27
17:23
Version 3.2.5 (CVS 2634) check-in: b2415a74 user: drh tags: trunk
17:22
Change the wording of the news line for release 3.2.5. (CVS 2633) check-in: 70db46d3 user: drh tags: trunk
17:19
Get the date right. Today is the 27th, not the 25th or the 28th. (CVS 2632) check-in: 905b9d6c user: drh tags: trunk
17:06
Increase the version number and update web pages for the next release. (CVS 2631) check-in: e6039e90 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: 644b96aa user: drh tags: trunk
13:16
Fix comment in vdbeapi.c. Remove unused structure definition from func.c. (CVS 2629) check-in: 51a38134 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: ecb96044 user: drh tags: trunk
09:07
Remove GNUmake extensions from the makefile. Ticket #1390. (CVS 2627) check-in: d0691fed user: drh tags: trunk
01:51
Do not change fields of stale sqlite3 handles. Ticket #1384. (CVS 2626) check-in: 7e05b7ca user: drh tags: trunk
01:50
Widen the opcode column of explain output in the shell. (CVS 2625) check-in: dd3b00aa 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: fc9e0460 user: drh tags: trunk
2005-08-24
18:04
Fix the --enable-threadsafe option to the configure script. Ticket #1378. (CVS 2623) check-in: 76ec0b3d user: drh tags: trunk
17:07
Additional defense against the rowid-fifo overflow problem. (CVS 2622) check-in: 881dcf5f user: drh tags: trunk
16:54
Remove a stray C++ style comment causing problems for some compilers. (CVS 2621) check-in: aa7dd3f2 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: 7c599bae user: drh tags: trunk
11:14
Version 3.2.4 (CVS 2619) check-in: 8cef2c1a user: drh tags: trunk
11:07
Increase the version number and update the change log prior to release. (CVS 2618) check-in: 139a28d2 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: 9f9a2571 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: a715e700 user: drh tags: trunk
11:17
Handle empty blob constants correctly. Ticket #1373. (CVS 2615) check-in: 5cada745 user: drh tags: trunk
11:03
Fix another documentation typo. (CVS 2614) check-in: 55f4b14e user: drh tags: trunk
11:00
Fix typos in syntax documentation. Ticket #1374 and a report on the mailing list. (CVS 2613) check-in: 990d1f3a 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: 1fab599b 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: 545e702a user: drh tags: trunk
18:54
Version 3.2.3 (CVS 2610) check-in: f620319b user: drh tags: trunk
18:40
Increase the version number and adjust documentation prior to the next release. (CVS 2609) check-in: b15ed7db user: drh tags: trunk
18:21
Disable malloc tests when not compiled with SQLITE_DEBUG. (CVS 2608) check-in: f372682f user: drh tags: trunk
17:48
Do not create an error message if there is no error. (CVS 2607) check-in: 3aa47c55 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: 7f430268 user: drh tags: trunk
2005-08-20
13:47
More test coverage improvements. (CVS 2605) check-in: e559e810 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: f786f37a 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: b550d04d user: drh tags: trunk
03:03
Additional tests for better coverage. (CVS 2602) check-in: 4281a838 user: drh tags: trunk
02:26
Increased test coverage on trigger.c and printf.c. (CVS 2601) check-in: 842a80bd user: drh tags: trunk
01:07
More test coverage enhancements. (CVS 2600) check-in: 0b6cd5ac 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: 2fe0ac4f user: drh tags: trunk
2005-08-18
18:15
Comment fixes. No changes to the underlying code. (CVS 2598) check-in: b865e243 user: drh tags: trunk
2005-08-16
14:44
Fix typo in documentation. (CVS 2597) check-in: 32efcd24 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: 3a7918a6 user: drh tags: trunk
2005-08-14
20:47
General code cleanup resulting in smaller footprint. (CVS 2595) check-in: 98338abf 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: 62b87751 user: drh tags: trunk
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