/ Timeline
Login

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

100 descendants and 100 ancestors of 36229018817eebfbfca7a66d2285e4faf7b39845

2006-01-12
17:20
Cache the encoding value inside VdbeExec. (CVS 2927) (check-in: 6d2a816e user: drh tags: trunk)
15:01
Additional performance improvements in sqlite3BtreeMoveto. (CVS 2926) (check-in: 52b3be96 user: drh tags: trunk)
14:30
BtreeMoveto optimization goes about 1.5% faster. (CVS 2925) (check-in: 4e4a6504 user: drh tags: trunk)
12:43
About a 2.5% speed improvement by reducing the number of sqlite3ThreadData calls in the parser. (CVS 2924) (check-in: 0caa1994 user: drh tags: trunk)
02:50
Mark the end of the return codes in the sqlite3.h.in template file. (CVS 2923) (check-in: 19b848d9 user: drh tags: trunk)
01:56
Add the legacy_file_format pragma. (CVS 2922) (check-in: b2dbd1a5 user: drh tags: trunk)
01:25
Improve performance by about 10% by avoiding excess calls to get the thread-specific data. (CVS 2921) (check-in: a8c74feb user: drh tags: trunk)
2006-01-11
23:40
Testing of the automatic TSD deallocation logic. The sqlite3_thread_cleanup() API is documented. This should close ticket #1601. (CVS 2920) (check-in: fb518b0c user: drh tags: trunk)
21:41
Automatically deallocate thread-specific data when it is no longer being used. Ticket #1601. Also implemented the suggestion of ticket #1603. Memory management is now off by default at compile-time. The sqlite3_enable_memory_management() API has been removed. (CVS 2919) (check-in: 5d9c6aa9 user: drh tags: trunk)
16:10
Ensure the database attached as part of VACUUM can be detached successfully after a malloc() failure. (CVS 2918) (check-in: 8c26893c user: danielk1977 tags: trunk)
14:09
Fix bugs caused by assuming that shared-schemas are initialized. (CVS 2917) (check-in: 3970eb87 user: danielk1977 tags: trunk)
05:49
Fix typo noted by #1599. (CVS 2916) (check-in: 1b368c7c user: danielk1977 tags: trunk)
01:28
Version 3.3.0 (alpha) (CVS 2915) (check-in: 59a7a56c user: drh tags: trunk)
01:28
Add new APIs to the sqlite3.def file. (CVS 2914) (check-in: 9258931a user: drh tags: trunk)
01:08
Prepare for the release of version 3.3.0. (CVS 2913) (check-in: 302993ae user: drh tags: trunk)
2006-01-10
23:00
Fix a typo in the FAQ. (CVS 2912) (check-in: 5be03a36 user: drh tags: trunk)
20:36
Fix bug in the server1 test script. (CVS 2911) (check-in: 25db22b6 user: drh tags: trunk)
20:32
Combine multiple small calls to sqlite3OsWrite into one larger call. (CVS 2910) (check-in: e6e6750c user: drh tags: trunk)
20:01
Improved comments on the server and asynchronous I/O demo programs. (CVS 2909) (check-in: c0f47ccb user: drh tags: trunk)
19:45
More pedantic changes to comments in VDBE. No changes to code. Ticket #1596. (CVS 2908) (check-in: 1cf68554 user: drh tags: trunk)
18:44
Fix opcode name in comments. No changes to code. (CVS 2907) (check-in: 511ac9db user: drh tags: trunk)
18:27
Initialize variables in malloc3.test (was causing error in all.test). (CVS 2906) (check-in: 16a8172a user: danielk1977 tags: trunk)
18:08
Typos in new documentation. (CVS 2905) (check-in: b5bedb2a user: danielk1977 tags: trunk)
17:58
Store collation sequence names instead of pointers in sharable schema data structures. (CVS 2904) (check-in: 0f0213be user: danielk1977 tags: trunk)
15:18
Updates to the C-API documentation. Change the parameter type of sqlite3_soft_heap_limit to integer. (CVS 2903) (check-in: bdd35e9f user: drh tags: trunk)
13:58
Move the implementation of sqlite3_enable_shared_cache from btree.c to main.c. (CVS 2902) (check-in: 4f2ec952 user: drh tags: trunk)
12:31
Fix a problem with shared-schemas and temp triggers. (CVS 2901) (check-in: 9c18a1ce user: danielk1977 tags: trunk)
07:14
If compiled with memory-debugging, write garbage to memory when it is freed. Fix for #1594. (CVS 2900) (check-in: bd02a6fa user: danielk1977 tags: trunk)
02:30
Enable shared cache on the server demonstration. (CVS 2899) (check-in: 8719f880 user: drh tags: trunk)
2006-01-09
23:50
Add the first simple tests of server mode. Get the Makefile generated from the configure script working again. (CVS 2898) (check-in: 66f84068 user: drh tags: trunk)
23:40
Added database server example code (untested). Fixed serveral bugs including the autovacuum compile problem described by ticket #1593. (CVS 2897) (check-in: ec332d88 user: drh tags: trunk)
17:29
Reinstate the asynchronous I/O demonstration code and tests with minor changes. (CVS 2896) (check-in: eeebc640 user: drh tags: trunk)
16:12
Fix some errors to do with attached databases and text encodings in shared-cache mode. (CVS 2895) (check-in: 3e75d3d5 user: danielk1977 tags: trunk)
09:59
Add a runtime interface to enable memory-management features. (CVS 2894) (check-in: 44f8e313 user: danielk1977 tags: trunk)
06:29
Rename DbSchema to "Schema" and SqliteTsd to "ThreadData". (CVS 2893) (check-in: 82b81f69 user: danielk1977 tags: trunk)
05:36
Minor changes so that OMIT_SHARED_CACHE works. (CVS 2892) (check-in: cc963f8c user: danielk1977 tags: trunk)
00:18
Fix timezone parsing in the date/time functions. Ticket #1587. (CVS 2891) (check-in: 94c87b70 user: drh tags: trunk)
00:09
Remove benign reference to an uninitialized variable. Ticket #1590. (CVS 2890) (check-in: 32998fe8 user: drh tags: trunk)
2006-01-08
18:10
Get LIMIT and OFFSET working again for negative limits and offsets. Ticket #1586. (CVS 2889) (check-in: b2ac0be0 user: drh tags: trunk)
05:26
Remove some cruft from the VDBE. Bring comments up to date. (CVS 2888) (check-in: 41aef649 user: drh tags: trunk)
05:02
Reduce memory requirements for ORDER BY combined with LIMIT. Ticket #1586. (CVS 2887) (check-in: 55e703ec user: drh tags: trunk)
2006-01-07
18:48
Invalidate all VDBE cursor row caches in between calls to sqlite3_step() since the emphemeral content that those caches point to might change if the statement is READ UNCOMMITTED. (CVS 2886) (check-in: 0ae46131 user: drh tags: trunk)
18:14
Continued progress toward a working wince backend. (CVS 2885) (check-in: 15fda14e user: drh tags: trunk)
18:10
Make sure there is no ephemeral data on the stack before returning from an sqlite3_step() call. Otherwise, if the statement is in READ UNCOMMITTED mode then the data might be deleted or changed out from under us. (CVS 2884) (check-in: 19f71a6d user: drh tags: trunk)
16:06
Enable redefinable I/O if the SQLITE_ENABLE_REDEF_IO macro exists. (CVS 2883) (check-in: e170e157 user: drh tags: trunk)
14:02
Fix some memory leaks caused by obscure syntax errors in SQL. (CVS 2882) (check-in: 6593199a user: danielk1977 tags: trunk)
13:21
In shared-cache mode, lock all required tables before beginning to execute the body of the statement program. (CVS 2881) (check-in: 23b587b0 user: danielk1977 tags: trunk)
04:06
Drop the mutex if the TSD key allocation fails. Ticket #1585. (CVS 2880) (check-in: 77ac231c user: drh tags: trunk)
2006-01-06
22:11
Fix bugs in test scripts that came of of sse testing. (CVS 2879) (check-in: 22bf1a2f user: drh tags: trunk)
21:52
Changes so that SQLITE_OMIT_PARSER and SQLITE_OMIT_DISKIO work. (CVS 2878) (check-in: 9d71b7de user: drh tags: trunk)
21:09
Additional changes for wince. (CVS 2877) (check-in: b10343d9 user: drh tags: trunk)
20:40
More changes to support wince. (CVS 2876) (check-in: f3cbd995 user: drh tags: trunk)
20:22
Additional efforts to get it to build on WinCE. (CVS 2875) (check-in: b45c076f user: drh tags: trunk)
16:17
A first attempt at adding native support for WinCE. (CVS 2874) (check-in: 43440567 user: drh tags: trunk)
15:03
Fix a crash caused by adding a trigger to a shared-schema and then deleting it using a different connection. (CVS 2873) (check-in: 19f93e13 user: danielk1977 tags: trunk)
14:46
Fix an alignment problem in the sqlite3OsRandomSeed(). Ticket #1584. (CVS 2872) (check-in: 373b56f0 user: drh tags: trunk)
14:41
Remove vestigial file: crashtest1.c (CVS 2871) (check-in: 6676c703 user: drh tags: trunk)
14:32
Change the OS interface layer to use traditional direct function call implementations instead of the more complicated virtual function table. Omit the asynchronous I/O demo. (CVS 2870) (check-in: 2529c2e1 user: drh tags: trunk)
13:00
Add some simple tests and fixes for shared-schema locking. (CVS 2869) (check-in: d054bed1 user: danielk1977 tags: trunk)
12:03
Back out the addition of the new header file - bad idea. (CVS 2868) (check-in: 0c4c45c3 user: drh tags: trunk)
06:33
Fix a bug that was emptying shared-schema tables during an ATTACH. (CVS 2867) (check-in: 752a2754 user: danielk1977 tags: trunk)
03:29
Enable async testing. Modify the OS layer interface. Add the sqlite3_aux.h include file. Add tests for boolean value representation in file format 4. (CVS 2866) (check-in: b8332aa8 user: drh tags: trunk)
01:42
Formatting changes in btree.c. (CVS 2865) (check-in: f1922da2 user: drh tags: trunk)
00:36
Windows implementation of the thread-specific data interface. (CVS 2864) (check-in: 3aa8befe user: drh tags: trunk)
2006-01-05
23:42
Disable the update hook for the truncation optimization used by DELETE. (CVS 2863) (check-in: 448b3b9d user: drh tags: trunk)
15:50
Move TCL interface for sqlite3_release_memory() and sqlite3_soft_heap_limit() out of tclsqlite.c and into test1.c. Update the TCL interface documention to describe the "exists" method. (CVS 2862) (check-in: 98194a45 user: drh tags: trunk)
14:22
Fix for ticket #1582 (Double delete of invalid LIMIT clause Expr* applied to a UNION ALL query). (CVS 2861) (check-in: 5dec3a39 user: danielk1977 tags: trunk)
13:48
Disable automatic invocation of sqlite3_release_memory() when a malloc() fails in those cases where the global mutex is held. (CVS 2860) (check-in: 6fdbb8b7 user: danielk1977 tags: trunk)
11:34
Add the shared schema/pager modifications. Very few tests so far. (CVS 2859) (check-in: deeda0dc user: danielk1977 tags: trunk)
2006-01-04
21:40
Bug fix in the IF NOT EXISTS logic. (CVS 2858) (check-in: cb9095ac user: drh tags: trunk)
18:13
Bug fix in the new "exists" method of the TCL interface. (CVS 2857) (check-in: d0e3d466 user: drh tags: trunk)
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)