/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

100 descendants and 100 ancestors of [a0bdb584]

2006-01-04
15:58
Update document for CREATE INDEX IF NOT EXISTS and DROP INDEX IF EXISTS (CVS 2856) check-in: 963ba8b8 user: drh tags: trunk
15:54
Add support for CREATE INDEX IF NOT EXISTS and DROP INDEX IF EXISTS. (CVS 2855) check-in: 551cdd6c user: drh tags: trunk
2006-01-03
15:16
Always case 0 to (char*) on varargs functions. Otherwise there are problems on 64-bit machines. (CVS 2854) check-in: 837dc77f user: drh tags: trunk
13:39
Add test files for the asynchronous IO concept. (CVS 2853) check-in: 7c3492c8 user: danielk1977 tags: trunk
00:33
The sqlite TCL command no longer returns the hex address of the sqlite3* structure. Instead there is a new command in testfixture to find that information. (CVS 2852) check-in: 70b22857 user: drh tags: trunk
2006-01-02
20:00
Add the xInMutex method to the os-layer switch for testing whether or not mutexes are used correctly. (CVS 2851) check-in: a582b159 user: drh tags: trunk
18:24
Additional tests for descending indices. Comment changes. (CVS 2850) check-in: 2622c524 user: drh tags: trunk
2005-12-30
16:31
Repair typo in previous commit. (CVS 2849) check-in: a4aa0911 user: danielk1977 tags: trunk
16:28
Add part of the btree layer of the shared-cache feature. (CVS 2848) check-in: 2afcad99 user: danielk1977 tags: trunk
2005-12-29
23:33
Add support for CREATE TABLE IF NOT EXISTS. (CVS 2847) check-in: 0bd9e35f user: drh tags: trunk
23:04
Bug fix in codec processing. (CVS 2846) check-in: a88580bc user: drh tags: trunk
19:23
Add serial-types 8 and 9 for integer constants of 0 and 1 that use zero bytes of storage. Make the default file format 4. Add the SQLITE_DEFAULT_FILE_FORMAT compile-time option to lower the default file format number so that newly created databases can be read and written by older versions of SQLite. (CVS 2845) check-in: ae301db8 user: drh tags: trunk
12:53
Fix for ticket #1575. (CVS 2844) check-in: 1586921b user: drh tags: trunk
01:11
Add support for DROP TABLE IF EXISTS. (CVS 2843) check-in: a4c547de user: drh tags: trunk
2005-12-22
13:47
Make genericAllocationSize work on NULL pointers. (CVS 2842) check-in: 326fc9cc user: drh tags: trunk
2005-12-21
18:36
Bug fixes and additional testing of descending indices. (CVS 2841) check-in: 5638a11e user: drh tags: trunk
14:43
Basic functionality for descending indices is in place. Lots more testing needed. (CVS 2840) check-in: 7064433e user: drh tags: trunk
03:16
Progress toward decending indices. (CVS 2839) check-in: 112a34b8 user: drh tags: trunk
2005-12-20
14:38
Include sqlite3_release_memory() code when SQLITE_MEMDEBUG is not defined. (CVS 2838) check-in: 77a37cec user: danielk1977 tags: trunk
09:19
Add simple tests and fixes for sqlite3_soft_heap_limit() (CVS 2837) check-in: c2c52854 user: danielk1977 tags: trunk
2005-12-19
17:53
Website changes in preparation for the release of 2.8.17. (CVS 2834) check-in: a927696b user: drh tags: trunk
17:26
Website changes for the release of 3.2.8. (CVS 2831) check-in: 2f7ec117 user: drh tags: trunk
16:15
Tentative fix for ticket #1567: disable the sqlite3pager_dont_write() optimization when a statement transaction is active. We continue to look for a better fix. (CVS 2827) check-in: e6106cc1 user: drh tags: trunk
14:18
Add some very simple test cases (and resulting bug fixes) for release_memory(). (CVS 2826) check-in: 154282fc user: danielk1977 tags: trunk
2005-12-18
08:51
Add the (untested) sqlite3_release_memory() function. (CVS 2825) check-in: 345addaa user: danielk1977 tags: trunk
2005-12-16
15:24
Verify that the rollback-hook is invoked correctly when a malloc() failure occurs. (CVS 2824) check-in: 83c8ae5b user: danielk1977 tags: trunk
06:54
Add the sqlite3_rollback_hook() API. Still requires further testing. (CVS 2823) check-in: 3baa3ff3 user: danielk1977 tags: trunk
01:06
Initial infrastructure for recognizing DESC indices and being able to read and write older databases that specify DESC indices but do not really use them. Nothing is close to working yet. (CVS 2822) check-in: cd110aa2 user: drh tags: trunk
2005-12-15
22:34
Fix the utf8 to utf16 conversion routine for short strings. Bug introduced by check-in (2817). (CVS 2821) check-in: 4fba2db3 user: drh tags: trunk
15:22
Add the sqlite3_update_hook() API. (CVS 2820) check-in: 36229018 user: danielk1977 tags: trunk
10:50
Move malloc(), free(), realloc() and allocationSize() into the Os vtbl. (CVS 2819) check-in: 81a41f66 user: danielk1977 tags: trunk
10:11
Add the sqlite3_os_routine_set()/get() functions. (CVS 2818) check-in: c1ed79f5 user: danielk1977 tags: trunk
03:04
Fix memory allocation problems on the utf-16 versions of collating function control routines. (CVS 2817) check-in: ad292e27 user: drh tags: trunk
2005-12-14
22:51
Avoid using the transient value in the UTF-16 collation needed callback. (CVS 2816) check-in: ab6241af user: drh tags: trunk
20:11
Properly zero-terminate UTF-16 collation names on an sqlite3_collation_needed16 callback. (CVS 2815) check-in: 71a49d05 user: drh tags: trunk
2005-12-12
06:53
Fix minor malloc() related problems and add sqlite3_soft_heap_limit() stubs. (CVS 2814) check-in: 1637f379 user: danielk1977 tags: trunk
2005-12-10
21:19
Add the "exists" method to the TCL interface. (CVS 2813) check-in: 8a355d7a user: drh tags: trunk
2005-12-09
20:54
New bind tests (check-ins (2797) and (2798)) only work right on a UTF8 database. So make sure they are only run when the database is UTF8. (CVS 2812) check-in: 39803790 user: drh tags: trunk
20:21
More annoying and pointless signedness warnings fixed. (CVS 2811) check-in: 590578be user: drh tags: trunk
20:02
Clean up annoying (and pointless) compiler warnings about differing signedness. (CVS 2810) check-in: 83a59151 user: drh tags: trunk
14:39
Define the sqliteMalloc() macro differently to avoid a compiler warning. (CVS 2809) check-in: 3d177bde user: danielk1977 tags: trunk
14:25
Many small changes to ensure memory is not leaked after malloc() fails. (CVS 2808) check-in: 601c3354 user: danielk1977 tags: trunk
02:35
Add more stress testing to autovacuum in an (unsuccessful) attempt to reproduce a reported problem. Even though these tests did not uncover anything amiss, extra tests never hurt... (CVS 2807) check-in: d8a8933f user: drh tags: trunk
2005-12-08
18:12
Provide a pragma to set the codec key. (CVS 2806) check-in: a7c9e898 user: drh tags: trunk
2005-12-07
06:27
Add some tests for malloc() failure within the column_name() and column_decl() APIs. (CVS 2805) check-in: 78f10ca0 user: danielk1977 tags: trunk
2005-12-06
17:48
Allow VACUUM to detach the auxillary database after malloc() fails. (CVS 2804) check-in: 6824a78b user: danielk1977 tags: trunk
17:19
Modify ATTACH and DETACH to execute at runtime instead of compile time. (CVS 2803) check-in: 5e04ec69 user: danielk1977 tags: trunk
13:19
Report errors out of sqlite3_open16(). (CVS 2802) check-in: f5b58163 user: drh tags: trunk
12:57
Add test file for new malloc() failure handling. (CVS 2801) check-in: 0b82f962 user: danielk1977 tags: trunk
12:52
Some elements of the new malloc() failure handling. Not all cases work properly yet. Also, library is not threadsafe if malloc() fails right now. (CVS 2800) check-in: e1606658 user: danielk1977 tags: trunk
2005-12-05
22:22
Update mailing list hyperlink on the support page. (CVS 2799) check-in: 41a7aeee user: drh tags: trunk
13:20
Make sure sqlite3_result_text can handle text strings with embedded '\000' characters. (CVS 2798) check-in: 9d6057cd user: drh tags: trunk
2005-12-02
02:44
Add a test to verify that binding text with embedded '\000' works. Also comment changes in os.h. (CVS 2797) check-in: 31251a90 user: drh tags: trunk
01:57
Documentation updates. (CVS 2796) check-in: 2ffb90c3 user: drh tags: trunk
2005-11-30
03:20
Restructure the OS interface yet again. This time make the OsFile object a virtual base class which is subclassed for unix, windows, and the crash test simulator. Add the new file "os.c" for common os layer code. Move all OS-specific routines into the sqlite3Os structure. (CVS 2795) check-in: bd8740d1 user: drh tags: trunk
2005-11-29
19:56
The crash test works now, at least on unix. Untested on windows. But it never worked on windows before so if it still does not there is no big loss. I am still troubled by the current design of the OS overloading mechanism. Expect to see more changes. (CVS 2794) check-in: fa1d7ecf user: drh tags: trunk
19:50
Make the build work on windows again. Ticket #1544. (CVS 2793) check-in: 59bdca25 user: drh tags: trunk
18:37
The crash tests now compile, at least. But they get wrong results. The problem is fundamental and suggests I need to completely rethink how the new OS backend should work. (CVS 2792) check-in: 966bc68e user: drh tags: trunk
03:13
Make the OsFile structure opaque with its internal structure known only to the appropriate os_*.c implementation. Omit the os_unix.h and os_win.h include files. The crash tests are broken by this patch. (CVS 2791) check-in: 058f3175 user: drh tags: trunk
2005-11-28
12:36
Replace a call to sprintf() with sqlite3MPrintf() since on some embedded platforms, sprintf() is busted. Need to go through and do similar replacements elsewhere in the code. (CVS 2790) check-in: 1b4f2d89 user: drh tags: trunk
2005-11-26
14:24
Disable the OR-clause optimization if it does not result in an index being used that would not have been used otherwise. In other words, do not convert OR clauses into an IN statement if it does not help the optimizer. (CVS 2789) check-in: 7e7cfce0 user: drh tags: trunk
14:08
Make sure left joins still work even when the OR clause optimization fires. Ticket #1537. (CVS 2788) check-in: cbbeb9de user: drh tags: trunk
03:51
Remove some vestiges of the old OS_TEST driver. (CVS 2787) check-in: 008f676f user: drh tags: trunk
03:43
Add an OS method for making copies of file descriptors. This fixes the crash tests. (CVS 2786) check-in: 57a674fc user: drh tags: trunk
00:25
Modify the OS layer so that I/O routines are called through a virtual function table. The os_test.c module has been replaced by test6.c. The crash tests are busted now and need to be fixed. (CVS 2785) check-in: 1f69aec2 user: drh tags: trunk
2005-11-25
10:55
Ensure a low system limit on the number of open files does not cause manydb.test to fail. (CVS 2784) check-in: dba2cc0d user: danielk1977 tags: trunk
10:38
Add the compilation option SQLITE_DISABLE_DIRSYNC (CVS 2783) check-in: f9f5ecbb user: danielk1977 tags: trunk
10:38
Add the compilation option SQLITE_DISABLE_DIRSYNC (CVS 2782) check-in: f1298bb1 user: danielk1977 tags: trunk
09:01
If SQLITE_DISABLE_LFS is defined, omit the bigfile tests. (CVS 2781) check-in: f882a516 user: danielk1977 tags: trunk
08:47
Check the return code of full_fsync() when used to sync a directory fd. (CVS 2780) check-in: 84aae3b0 user: danielk1977 tags: trunk
02:43
Preserve 64-bit last insert rowids across triggers. (CVS 2779) check-in: 4dd7cfaa user: drh tags: trunk
2005-11-24
23:14
The --enable-cross-thread-connect configuration option or the -DSQLITE_ALLOW_XTHREAD_CONNECT compile-time option permits database connections to be moved across threads. This will cause latch-ups and failures on some linux systems such as RedHat-9. Do not use these options if you want a portable build. (CVS 2778) check-in: 84aa4d58 user: drh tags: trunk
22:33
Make sure sqliteInt.h is included before any system includes. This is required for QNX. Ticket #1478. (CVS 2777) check-in: ab764535 user: drh tags: trunk
22:22
Reduce the number of distinct token symbols in the parser so that the parser can store tokens in a single byte and thus be smaller in size. (CVS 2776) check-in: 2dfc9863 user: drh tags: trunk
14:34
Comment changes. No changes to code. (CVS 2775) check-in: 786e23b2 user: drh tags: trunk
14:24
Fix a comment in btree.c. No code changes. (CVS 2774) check-in: 0d8bd133 user: drh tags: trunk
13:15
Fix incorrect type conversions when copying from a table into itself. Ticket #1536. (CVS 2773) check-in: a2e55a38 user: drh tags: trunk
2005-11-21
12:48
Less verbose output when EXPLAIN QUERY PLAN identifies use of the primary key. (CVS 2772) check-in: 5045f099 user: drh tags: trunk
12:46
The EXPLAIN QUERY PLAN now identifies when tables use the integer primary key. (CVS 2771) check-in: 80721e2c user: drh tags: trunk
2005-11-16
13:47
Fix a problem with the sorting of literals in a compound query. Ticket #1501. (CVS 2770) check-in: b3882b43 user: drh tags: trunk
12:53
Do not allow aggregate functions in a WHERE clause. Ticket #1514. (CVS 2769) check-in: bb866ed8 user: drh tags: trunk
04:34
Avoid unnecessary strlen() calls in the OP_String opcode. (CVS 2768) check-in: 2e195e96 user: drh tags: trunk
2005-11-15
02:14
Fix a bug in UTF-16 handling introduced by the previous check-in. (CVS 2767) check-in: 25fa16a2 user: drh tags: trunk
2005-11-14
22:29
Create separate affinities for INTEGER and REAL. (CVS 2766) check-in: ce06c123 user: drh tags: trunk
11:51
Fix documentation typo. (CVS 2765) check-in: c9b413ea user: drh tags: trunk
2005-11-06
04:06
About 0.5KiB of additional compression in the parser tables. (CVS 2764) check-in: f39974eb user: drh tags: trunk
2005-11-05
15:11
Work around a bug in MSVC++. Ticket #1513. (CVS 2763) check-in: 6331860e user: drh tags: trunk
15:07
Remove a C++-ism that slipped into the code during the recent CHECK enhancements. Ticket #1513. (CVS 2762) check-in: e66289b5 user: drh tags: trunk
15:04
Improved table compression in lemon reduces the overall library size by about 1.5KiB. (CVS 2761) check-in: 86ac1147 user: drh tags: trunk
2005-11-04
22:03
VACUUM works even on an empty database. Ticket #1512. (CVS 2760) check-in: 1b6bf418 user: drh tags: trunk
2005-11-03
14:29
sqlite3_column_int() and similar routines return 0 or 0.0 on an out-of-memory condition, not some mysterious error code. (CVS 2759) check-in: 7780f5e9 user: drh tags: trunk
12:33
Prohibit parameters in CHECK constraint expressions. (CVS 2758) check-in: bb94ef64 user: drh tags: trunk
02:15
Add the ignore_check_constraints pragma. VACUUM works even on a database that contains table entries that violate check constraints. (CVS 2757) check-in: be83bfee user: drh tags: trunk
02:03
Disallow subqueries in CHECK constraints. (CVS 2756) check-in: db27afc4 user: drh tags: trunk
01:22
CHECK constraints that evaluate to NULL pass. (CVS 2755) check-in: 55b314a2 user: drh tags: trunk
00:41
First cut at supporting CHECK constraints. Everything appears to work, but much more testing is needed as well as documentation. (CVS 2754) check-in: 2313d912 user: drh tags: trunk
2005-11-01
15:48
Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are now of type real, though an integer representation is still sometimes used internally for efficiency. (CVS 2753) check-in: e0d6f61c user: drh tags: trunk
2005-10-29
15:48
Fix the shift operators so that they work with 64-bit quantities. (CVS 2752) check-in: 0d3357b5 user: drh tags: trunk
2005-10-23
11:29
Report an error if the input SQL contains an unterminated string. Ticket #1497. (CVS 2751) check-in: c9c476dd user: drh tags: trunk
2005-10-20
07:28
Changes to prevent various compiler warnings. (CVS 2750) check-in: e261b8b0 user: drh tags: trunk
2005-10-13
02:09
Attempt to fix the SQLite core so that no floating point operations are used anywhere if SQLITE_OMIT_FLOATING_POINT is defined at compile-time. This is useful to people who use SQLite on embedded processors that lack floating point support. (CVS 2749) check-in: a0bdb584 user: drh tags: trunk
2005-10-10
00:05
Make the default TEMP_STORE=1 (TEMP tables stored on disk) in the configure script. (CVS 2748) check-in: 9753af53 user: drh tags: trunk
2005-10-06
16:53
More efficient handling of the LIMIT clause. Scalar subqueries and EXISTS on compound SELECT statements now working properly. Ticket #1473. (CVS 2747) check-in: edca8913 user: drh tags: trunk
13:59
Check-in (2744) as incomplete and broke pragma integrity_check. This completes the change and fixes the problem. (CVS 2746) check-in: 4862eaaf user: drh tags: trunk
2005-10-05
22:31
Make the SQLite logo on the website a hyperlink to the home page. Ticket #1471. (CVS 2745) check-in: 9709f0f6 user: drh tags: trunk
11:41
Make sure pragma integrity_check does not report "ok" after first finding a bunch of errors. (CVS 2744) check-in: efec04de user: drh tags: trunk
11:35
Fix an assert or memory leak that occurs when trying to EXPLAIN a statement other than a SELECT that outputs results. Examples of such statements include PRAGMA integrity_check or INSERT/DELETE/UPDATE with PRAGMA count_changes=ON. (CVS 2743) check-in: 533a85ee user: drh tags: trunk
10:40
Changes to support TEA on cygwin. (CVS 2742) check-in: e80fecc9 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: 115340d4 user: drh tags: trunk
02:13
Add the SQLITE_OMIT_GET_TABLE compile-time flag. (CVS 2740) check-in: 6d4bc8f8 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: 385a08af 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: 080eadca 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: 6d780ca6 user: drh tags: trunk
2005-09-24
15:25
Version 3.2.7 (CVS 2736) check-in: bd141a7c user: drh tags: trunk
15:10
Perparations for version 3.2.7. (CVS 2735) check-in: 70937d5c user: drh tags: trunk
11:01
Add the SQLite console source code in the contrib section of the source tree. (CVS 2734) check-in: 079c6348 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: 352cc9f5 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: a9b341dc 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: 655e75ac user: drh tags: trunk
17:42
Code cleanup and simplification. Three new Mem opcodes added. The sqlite3VdbeJumpHere function added. (CVS 2730) check-in: 2471957f 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: f22d0f64 user: drh tags: trunk
13:12
NULLs compare equal to each other when computing GROUP BY categories. (CVS 2728) check-in: d9b0c970 user: drh tags: trunk
08:47
Update comments in where.c. No code changes. (CVS 2727) check-in: bb84d27e user: drh tags: trunk
01:36
Documentation updates. (CVS 2726) check-in: 6ec8883c 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: ea10f978 user: drh tags: trunk
19:05
Set the default maximum page size to 32768, not 8192. (CVS 2724) check-in: b32e9ec2 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: 6cc57fcf user: drh tags: trunk
15:37
Fix uninitialized value on a UNION ALL select with an ORDER BY clause. (CVS 2722) check-in: 92126a21 user: drh tags: trunk
13:15
The sqlite3_query_plan debugging variable now only appears with SQLITE_TEST=1. (CVS 2721) check-in: 41e226d2 user: drh tags: trunk
12:53
Work around limitations of MSVC++ 6. Tickets #1429, #1437, and #1440. (CVS 2720) check-in: b2d1803c user: drh tags: trunk
12:37
Change some debugging #defines in order to get SSE working again after recent upgrades. (CVS 2719) check-in: 86eb7d83 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: e985f02d user: drh tags: trunk
19:14
Update to the download page on the website. (CVS 2717) check-in: 91bc0d00 user: drh tags: trunk
18:49
Version 3.2.6 (CVS 2716) check-in: 1cdfe667 user: drh tags: trunk
18:34
The sqlite3ReallocOrFree routine should set its pointer to NULL when it fails. (CVS 2715) check-in: 0e85af44 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: 7a7ba73f user: drh tags: trunk
17:58
Fix a memory leak that occurs after malloc fails. (CVS 2713) check-in: 85b931bf user: drh tags: trunk
17:05
Fix the crash.test script to accomodate recent changes. (CVS 2712) check-in: d594608f user: drh tags: trunk
16:48
Fix a bug in the lock2 test script introduced by check-in (2709) (CVS 2711) check-in: c3bf1743 user: drh tags: trunk
16:36
Fix a problem with the lock_status pragma and the UTF-16 encoding. (CVS 2710) check-in: 1a737b45 user: drh tags: trunk
15:20
Changes to make corruption errors easier to track down. (CVS 2709) check-in: c0733000 user: drh tags: trunk
15:17
Update the webpage description of 3.2.6 changes to talk about ticket #1432. (CVS 2708) check-in: 0e23c28b user: drh tags: trunk
13:29
Bug fix in the ORDER BY optimizer. Ticket #1435. (CVS 2707) check-in: 553b7ba8 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: 21740794 user: drh tags: trunk
02:34
Updates to the FAQ. (CVS 2705) check-in: 0eaf430d 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: 5b6dc12b 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: 248f7797 user: drh tags: trunk
10:18
Prevent the sqlite3_pagecount() function from ever returning the pending-byte page. (CVS 2702) check-in: 35a88935 user: danielk1977 tags: trunk
10:13
Move the definition of sqlite3_pending_byte from test2.c to os_common.h. (CVS 2701) check-in: bedf702f 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: 9115e062 user: danielk1977 tags: trunk
02:55
Documentation changes in preparation for the release of 3.2.6. (CVS 2698) check-in: 243f455c user: drh tags: trunk
02:48
Undo check-in (2694). (CVS 2697) check-in: 6017b196 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: 4686d649 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: 714254cb 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: 9b60f48d 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: 81fdffdf user: drh tags: trunk
07:00
Updates to the documentation on the TCL bindings. (CVS 2692) check-in: 94aa2d32 user: drh tags: trunk
00:02
Fix a comment typo in the previous check-in. (CVS 2691) check-in: 49c95280 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: 2ec2bd85 user: drh tags: trunk
2005-09-12
23:03
Bug fix in the new COUNT(DISTINCT) logic. Ticket #1420. (CVS 2689) check-in: 37116550 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: 2f397bd8 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: 3f191cf4 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: 26565b89 user: drh tags: trunk
16:46
Add the experimental EXPLAIN QUERY PLAN diagnostic capability. (CVS 2685) check-in: 986efb7b 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: 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