/ Timeline
Login

100 check-ins occurring around 60da01630a.

2007-11-29
17:43
When using an index to scan a database table, read column data from the index in preference to the table. This increases the likelihood that the table will not be required at all. (CVS 4580) check-in: 061608c7 user: danielk1977 tags: trunk
17:05
Optimisations for expressions of the form "<value> IN (SELECT <column> FROM )". (CVS 4579) check-in: 56d0e326 user: danielk1977 tags: trunk
2007-11-28
22:36
Add the {quote: StrAccum} object for accumulating strings. Revamp xprintf to use the new object. Rewrite the group_concat() function to use the new object. Productize and test the group_concat() function. (CVS 4578) check-in: 221aee72 user: drh tags: trunk
16:19
Change the BTree so that it uses the Pagers temporary page space when reorganizing the rows on a page, rather than mallocing for space of its own. In this way, we avoid having to deal with a malloc failure deep down inside the page reorganizer. Ticket #2806 (CVS 4577) check-in: 98960132 user: drh tags: trunk
14:04
Reorganize the code for the homegrown recursive mutexes. Fix a place in the previous check-in where the #ifdef label was incorrect. Ticket #2804. (CVS 4576) check-in: 542e11f9 user: drh tags: trunk
13:55
Clarify the conditions under which homegrown recursive mutexes work (they require a coherent cache) and only enable them if there is an explicit #define so as to avoid accidental use on platforms that do not meet the constraints. Ticket #2805. (CVS 4575) check-in: 80299eeb user: drh tags: trunk
13:43
Preset the legacy_file_format pragma to the value of the primary database so that a VACUUM will not unknowingly alter the setting. Ticket #2804. (CVS 4574) check-in: f731fa6b user: drh tags: trunk
00:51
Add an implementation of recursive mutexes for unix systems that lack pthreads recursive mutexes (ex: Solaris 2.6). Modern unix systems continue to use the recursive mutexes provided by pthreads. (CVS 4573) check-in: f366a776 user: drh tags: trunk
2007-11-27
23:36
Add test cases to verify that the file format is preserved across VACUUM. Ticket #2804. (CVS 4572) check-in: 57400f50 user: drh tags: trunk
23:11
Use the hexio test utility rather than TCL's binary I/O to avoid 32/64-bit problems in io.test. Ticket #2803. (This is a change to the test harness only - not to SQLite.) (CVS 4571) check-in: 07f7dde8 user: drh tags: trunk
21:44
Remove superfluous -lpthread from publish_osx.sh. Ticket #2801. Fix a bug in mkdll.sh. (CVS 4570) check-in: 8d6e8fd3 user: drh tags: trunk
18:45
Omit the superfluous -lpthread option in publish.sh. Ticket #2800. (CVS 4569) check-in: 4f09f233 user: drh tags: trunk
18:30
Add the publish_osx.sh script for building binaries for OSX (CVS 4568) check-in: 9bd7c314 user: drh tags: trunk
17:38
Update the "publish.sh" scripts used to build the binaries for the website. (CVS 4567) check-in: 2f748318 user: drh tags: trunk
17:12
Version 3.5.3 (CVS 4566) check-in: a39007d5 user: drh tags: trunk
16:55
Fix a bug that can cause a segfault on win32 systems following an I/O error. (CVS 4565) check-in: eeec8d27 user: drh tags: trunk
14:50
Bug fix in the configure script. Ticket #2799. The configure script is a real mess and needs to be completely rewritten. (CVS 4564) check-in: 9d15f033 user: drh tags: trunk
14:46
Update the version number to 3.5.3. Fix some minor testing problems. (CVS 4563) check-in: f4c8f2d1 user: drh tags: trunk
02:38
Add likely() and unlikely() macros to the header file. They are not yet used for anything. (CVS 4562) check-in: 485add38 user: drh tags: trunk
2007-11-26
22:54
Use macro __DARWIN__ rather than __MACOS__ for conditional compilation of MacOSX specific features. Ticket #2780. (CVS 4561) check-in: d0a4c2a3 user: drh tags: trunk
13:36
Additional out-of-memory testing. Fix bugs caused by malloc failures in where.c. Tickets #2794, #2795, #2796, and #2797. (CVS 4560) check-in: 5e02dbab user: drh tags: trunk
2007-11-24
10:23
Declare the invalidateCursorsOnModifiedBtrees function to be static. Ticket #2792. (CVS 4559) check-in: 94f25fc1 user: drh tags: trunk
00:41
The FTS3 amalgamation can now be appended to the SQLite amalgamation to generate a single source file that contains both components. (CVS 4558) check-in: 0fc61f99 user: drh tags: trunk
2007-11-23
18:19
Fix a typo in a change to all.test from earlier today. (CVS 4557) check-in: 8c0b2157 user: drh tags: trunk
18:06
Do not require SQLITE_ENABLE_BROKEN_FTS2 if FTS2 is not enabled. The same for FTS1. Ticket #2777. (CVS 4556) check-in: f94cdcfd user: drh tags: trunk
18:01
Add a #include of sqlite3.h to fts3_hash.c. Tickets #2762 and #2777. (CVS 4555) check-in: c8485eb8 user: drh tags: trunk
17:31
Changes fts3 to use only sqlite3_malloc() and not system malloc. Ticket #2762. (CVS 4554) check-in: 460af6bb user: drh tags: trunk
15:12
Remove most documentation from the source code repository. Documentation configuration management is now handled by a separate repository at http://www.sqlite.org/docsrc. (CVS 4553) check-in: b20f3a6f user: drh tags: trunk
15:02
Make sure that INSERT INTO ... SELECT ... always uses an ephemeral intermediate table if the SELECT clause refers to the destination table, even if the SELECT clause is compound or uses the destination table in a subquery. This fixes a long-standing bug that can cause an infinite loop for some SQL statements. (CVS 4552) check-in: 492b39b6 user: drh tags: trunk
13:42
Avoid a double-free in an out-of-memory situation with a USING clause or NATURAL JOIN. Ticket #2789. (CVS 4551) check-in: 59669475 user: drh tags: trunk
2007-11-22
00:47
Change to sqlite3.pc.in recommended by ticket #2786. (CVS 4550) check-in: 247fa2ea user: drh tags: trunk
2007-11-21
15:24
Handle out-of-memory situations inside the query flattener. Ticket #2784. (CVS 4549) check-in: 2655a3f2 user: drh tags: trunk
2007-11-17
22:23
Fix a bug in the grammar. We were giving the ones-complement operator ~ the same precedence as the NOT operator, which is incorrect. (CVS 4548) check-in: b48a4bfd user: drh tags: trunk
2007-11-16
14:55
Fix a crash that can occur after a malloc failure. Ticket #2775. (CVS 4547) check-in: c91bc8d3 user: danielk1977 tags: trunk
00:23
Don't do anything when input doclists are both empty. Ticket #2774 (CVS 4546) check-in: 75cb46f8 user: shess tags: trunk
2007-11-15
16:04
Return SQLITE_MISUSE instead of crashing if NULL is (incorrectly) passed to sqlite3_step(). Ticket #2773. (CVS 4545) check-in: 3bfee76f user: danielk1977 tags: trunk
13:10
Fix a segfault that can occur after a malloc failure in an ANALYZE statement. Ticket #2772. (CVS 4544) check-in: d05eb67d user: danielk1977 tags: trunk
2007-11-14
06:48
Add an experimental API for retrieving the SQL source from a compiled statement: sqlite3_sql(). Ticket #2769. (CVS 4543) check-in: d31f1e0d user: danielk1977 tags: trunk
2007-11-13
10:30
Modify the Tcl interface to use sqlite3_prepare_v2(). (CVS 4542) check-in: 7bb00c7d user: danielk1977 tags: trunk
2007-11-12
21:09
Various changes to enable compilation of SQLite library and command line shell with the Windows CE cross compiler from cegcc.sourceforge.net (CVS 4541) check-in: 8ad0ab8c user: chw tags: trunk
17:56
Another attempt at fixing a memory leak in the TCL interface. See check-in (4338) for the first attempt. Ticket #2597. (CVS 4540) check-in: 68a43c99 user: drh tags: trunk
15:40
Fix a code comment in select.c. No code changes. (CVS 4539) check-in: cf41d6a0 user: danielk1977 tags: trunk
15:29
Where possible, transform the DISTINCT qualifier to a GROUP BY clause. GROUP BY clauses may be optimized by indices, DISTINCT qualifiers cannot. (CVS 4538) check-in: e5633123 user: danielk1977 tags: trunk
09:50
Allow collation sequence names to be quoted. Ticket #2744. (CVS 4537) check-in: 06749ac7 user: danielk1977 tags: trunk
08:09
Modify the order of assert() macros in vdbe.c as per the suggestion in #2768. (CVS 4536) check-in: af5af5dc user: danielk1977 tags: trunk
2007-11-11
18:36
Fix the code generation for UPDATE and DELETE so that BEFORE triggers that use RAISE(IGNORE) do not leave extra values on the stack. Ticket #2767 (CVS 4535) check-in: 3391f413 user: drh tags: trunk
2007-11-07
15:13
Add asserts on sqlite3_mutex_held() to the zero-malloc memory allocator, in order to prove that the mutex is held when it is needed. (CVS 4534) check-in: 31eb4abc user: drh tags: trunk
01:23
Changes the asynchronous I/O test module so that it can be appended to the end of the amalgamation. (CVS 4533) check-in: c1fe27de user: drh tags: trunk
01:19
In the windows VFS, make sure we do not return an error if attempting to delete a file that does not exist. (CVS 4532) check-in: 08a685ab user: drh tags: trunk
2007-11-05
20:49
Version 3.5.2 (CVS 4531) check-in: 60da0163 user: drh tags: trunk
18:11
Preparing documentation for the release of version 3.5.2. (CVS 4530) check-in: b985328a user: drh tags: trunk
17:54
Drop support for the SQLITE_OMIT_MEMORY_ALLOCATION compile-time option. (CVS 4529) check-in: b57c89fe user: drh tags: trunk
17:01
Reset the writer-thread halt criteria after halting the thread. (CVS 4528) check-in: ecbff972 user: danielk1977 tags: trunk
15:30
Fix some minor problems with malloc failure and in-memory databases. (CVS 4527) check-in: b752906e user: danielk1977 tags: trunk
14:58
Fix a bug in the misc1 test script. (CVS 4526) check-in: fa16996d user: drh tags: trunk
14:30
Make sure the default page size never exceeds the maximum page size. (CVS 4525) check-in: 9c2731f1 user: drh tags: trunk
12:46
Use malloc to obtain space for sqlite3_aggregate_context(). Ticket #2751. (CVS 4524) check-in: bf75058f user: danielk1977 tags: trunk
05:12
Handle "IS NULL" constraints on virtual table scans. IS NULL constraints are not passed to the virtual table layer. Ticket #2759. (CVS 4523) check-in: 7027368c user: danielk1977 tags: trunk
2007-11-02
12:53
Add the ".timer" command to the CLI. (CVS 4522) check-in: 56680360 user: drh tags: trunk
12:52
Fix building of sqlite3_analyzer on Mac. (CVS 4521) check-in: a616b6cb user: drh tags: trunk
09:07
Add some assert() statements to the asychronous backend demo to enforce the strategy used to avoid deadlock. Also a minor change to avoid a potential deadlock. (CVS 4520) check-in: 6340ca5e user: danielk1977 tags: trunk
2007-11-01
17:38
Add a prototype "group_concat()" aggregate function to func.c. Disabled by default. No documentation nor test cases. No effort to make it efficient. (CVS 4519) check-in: 61987a89 user: drh tags: trunk
2007-10-30
17:28
Avoid leaking a file descriptor after a malloc failure on unix. (CVS 4518) check-in: c249d5da user: danielk1977 tags: trunk
15:38
Remove a debugging assert() that went in by accident with the previous commit. (CVS 4517) check-in: 4ad60bdb user: danielk1977 tags: trunk
15:29
Fix a race condtion in test_async.c. (CVS 4516) check-in: 5e3f7c3d user: danielk1977 tags: trunk
2007-10-27
16:25
Clarify the behavior of sqlite3_last_insert_rowid() when using INSERT OR IGNORE. (CVS 4515) check-in: c0fa0c8b user: drh tags: trunk
2007-10-24
23:24
Be a bit more susicious of invalid results from the tokenizer. (CVS 4514) check-in: deb8f56d user: shess tags: trunk
23:04
Fix os2CurrentTime() to give correct results for negative timezones. (CVS 4513) check-in: a3b82548 user: pweilbacher tags: trunk
23:03
Fix os2GetTempname() to actually work: DosScanEnv() wants an empty PSZ as argument and we obviously don't need to test for file existence any more. (CVS 4512) check-in: 8a233845 user: pweilbacher tags: trunk
21:52
fts3.c buildTerms() passes -1 for nInput. (CVS 4511) check-in: e87c883a user: shess tags: trunk
2007-10-23
18:55
Add comments, assertions, and test cases to demonstrate that the problem described in ticket #2742 is not a real problem. (CVS 4510) check-in: c085d6df user: drh tags: trunk
15:59
Add comments to the code warning that _XOPEN_SOURCE might need to be defined manually if using USE_PREAD or USE_PREAD64. (CVS 4509) check-in: d7ed7cd0 user: drh tags: trunk
15:51
Make sure the _LARGEFILE_SOURCE macro occurs before any system includes. Ticket #2739. (CVS 4508) check-in: 36465aeb user: drh tags: trunk
15:39
Floating point and 64-bit integer constants store in the virtual machine opcodes in binary, not as text. Performance improvement. Ticket #2733. (CVS 4507) check-in: 7e30fd6a user: drh tags: trunk
14:55
Fix limit assertions in vdbe.c. Ticket #2740. (CVS 4506) check-in: 27f846d0 user: drh tags: trunk
14:49
Make sure the sqlite3_vfs_register() and sqlite3_vfs_unregister() APIs work right even if not VFS is currently registered. Ticket #2738. (CVS 4505) check-in: c3650087 user: drh tags: trunk
10:25
Add speed4.test, with some speed tests for triggers, sub-selects, views and joins. (CVS 4504) check-in: 3e3475b9 user: danielk1977 tags: trunk
08:17
Fix an error message in the tcl interface. (CVS 4503) check-in: 2449e080 user: danielk1977 tags: trunk
2007-10-22
18:02
Add the NEAR operator to fts3. (CVS 4502) check-in: aef7720e user: danielk1977 tags: trunk
2007-10-21
22:59
We need an extra define to activate OS/2 semaphores for compiling/linking. (CVS 4501) check-in: 0604dace user: pweilbacher tags: trunk
22:47
Finally bring OS/2 to the 3.5 level. This at least is a first draft version that survives very basic tests. It still contains a lot of debugging stuff... (CVS 4500) check-in: 46b2d103 user: pweilbacher tags: trunk
2007-10-20
20:58
Use the 2-argument version of substr() in the SQL contained in the VACUUM and ALTER TABLE commands. Ticket #2737. (CVS 4499) check-in: 82b08a3d user: drh tags: trunk
16:36
Add the new memory allocator to the amalgamation. Improvements to out-of-memory handling. (CVS 4498) check-in: b58c2b37 user: drh tags: trunk
16:11
Bug fix in the realloc algorithm of the static memory allocator. (CVS 4497) check-in: 50db16be user: drh tags: trunk
15:41
Simplify the mem3.c memory allocator. Have it call sqlite3_release_memory() automatically, without having to specify the soft heap limit. (CVS 4496) check-in: ca51b2f5 user: drh tags: trunk
13:17
Go back to allocating each page and its header with a single memory allocation. This undoes the change of (4409). (CVS 4495) check-in: f56c9884 user: drh tags: trunk
12:34
Fix a mutex leak in the new malloc-free memory allocator. (CVS 4494) check-in: 30f014d3 user: drh tags: trunk
2007-10-19
17:47
Added an experimental malloc-free memory allocation subsystem, intended for use on embedded systems. Runs 7% faster than when using system malloc() on Linux. (CVS 4493) check-in: 8487ca82 user: drh tags: trunk
2007-10-17
01:44
Reorder some tests at the beginning of sqlite3_step() to work around misuse by python. Ticket #2732. (CVS 4492) check-in: e8d591e8 user: drh tags: trunk
2007-10-16
19:45
A cosmetic changes to btree.c which (we are told) works around a bug in MSVC++. (CVS 4491) check-in: 329dd014 user: drh tags: trunk
2007-10-15
19:34
Add a malloc size histogram to the debugging malloc implementation in mem2.c. (CVS 4490) check-in: 3e51696c user: drh tags: trunk
07:08
Fix for OMIT_AUTHORIZATION builds. (CVS 4489) check-in: 260711a1 user: danielk1977 tags: trunk
2007-10-12
20:42
Do not invoke the authorizer when reparsing the schema after a schema change or when trying to figure out the result set of a view. (CVS 4488) check-in: e756bc9b user: drh tags: trunk
19:35
Convert a K&R style function to ANSI style. Ticket #2548. (CVS 4487) check-in: e1b2e7c2 user: drh tags: trunk
19:11
Make the 3rd parameter of the SUBSTR() function optional. Ticket #2579. (CVS 4486) check-in: 4a807d48 user: drh tags: trunk
18:36
Add an explicit type conversion in an AWK script to work around bugs in cygwin. Ticket #2713. (CVS 4485) check-in: 043cee2f user: drh tags: trunk
18:30
Update documentation to talk about the SQLITE_UTF16_ALIGNED option for sqlite3_create_collation(). Ticket #2722 (CVS 4484) check-in: a7292c14 user: drh tags: trunk
00:23
Fix to the main.mk makefile. (CVS 4483) check-in: e4527dd6 user: drh tags: trunk
2007-10-09
15:36
Still more tweaks to the wince interface. Ticket #2711. (CVS 4482) check-in: b2bdb476 user: drh tags: trunk
15:20
Fix a typo in the wince driver. Ticket #2710. See also ticket #2702. (CVS 4481) check-in: beb91af7 user: drh tags: trunk