/ 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 check-ins occurring around e756bc9b74ef357c.

2007-11-12
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
08:29
Fixes to the test suite (no code changes) so that quick.test runs with OMIT_ATTACH builds. #2706. (CVS 4480) check-in: 07c00fff user: danielk1977 tags: trunk
2007-10-08
15:06
More untested changes for wince contributed by users. Ticket #2702. (CVS 4479) check-in: ccd709e1 user: drh tags: trunk
12:29
Reverting check-in (3836) at the request of winCE users. We no ability to test this change. Presumably this is a fix for tickets #2698, #2533, and #2598. It is unclear if this causes #2294 to be reopened or not. (CVS 4478) check-in: 27346fa5 user: drh tags: trunk
12:22
Fix a bug in code for winCE. Ticket #2700. (CVS 4477) check-in: a36fca4c user: drh tags: trunk
12:21
In windows, always open files using FILE_FLAG_RANDOM_ACCESS. Ticket #2699. (CVS 4476) check-in: 5cdbc097 user: drh tags: trunk
2007-10-06
01:40
Fix a memory leak in the sqlite3_realloc() implementation of the non-debugging memory allocator. (CVS 4475) check-in: 7e9b886d user: drh tags: trunk
2007-10-05
16:23
Remove #include <math.h> from all source files. It is no longer needed but causes compile problems when -DSQLITE_OMIT_FLOATING_POINT is defined. Ticket #2696. (CVS 4474) check-in: 4424357d user: drh tags: trunk
16:16
Changes lemon so that the generated parser does not accept prior to seeing the EOF token. This is a lemon change only and does not effect SQLite. Ticket #2550. (CVS 4473) check-in: 1c68d934 user: drh tags: trunk
15:53
Changes to a couple of test scripts to handle the tcl 8.5 version of (file attributes -readonly) on mac. (CVS 4472) check-in: a51946e6 user: danielk1977 tags: trunk
15:08
Do not attempt to use TryEnterCriticalSection() under win32. It causes too many compiler problems. Ticket #2685. (CVS 4471) check-in: f795431c user: drh tags: trunk
15:04
Fix problem building testfixture on mac. Ticket #2689. (CVS 4470) check-in: fe067d70 user: danielk1977 tags: trunk
14:54
The sqlite3internal.h file obsolete as of version 3.5.0. Remove legacy procedures and makefile targets for building this file. Tickets #2693 and #2694. (CVS 4469) check-in: e65842a9 user: drh tags: trunk
14:49
Use FormatMessageA() instead of FormatMessage() in the w32 VFS. Ticket #2687. (CVS 4468) check-in: 38674fd2 user: drh tags: trunk
2007-10-04
18:52
Correct the name on the new test script for ticket #2686. (CVS 4467) check-in: d261e2c7 user: drh tags: trunk
18:11
Fixes for OMIT_AUTHORIZATION builds. #2691. (CVS 4466) check-in: 755fcaf7 user: danielk1977 tags: trunk
00:30
Version 3.5.1 (CVS 4465) check-in: 81cf5186 user: drh tags: trunk
00:29
Updates to the documentation index page. (CVS 4464) check-in: 837fc861 user: drh tags: trunk
2007-10-03
21:18
Get io.test to work even if auto_vacuum is on by default and we are running with a reduced maximum page size. (CVS 4463) check-in: 0d05f3fb user: drh tags: trunk
21:10
Fix a syntax error that comes up when memory debugging is disabled. (CVS 4462) check-in: 96dd3c33 user: drh tags: trunk
20:32
Update documentation in preparation for the release of 3.5.1. (CVS 4461) check-in: a57b25a2 user: drh tags: trunk
20:15
Update documentation to talk about the response to errors within an explicit transaction. (CVS 4460) check-in: 84616a13 user: drh tags: trunk
18:45
Simplify the vdbeHalt logic slightly. (CVS 4459) check-in: b59f7bcb user: drh tags: trunk
15:30
Rollback the transaction if an SQLITE_FULL error is encountered. This is a preliminary fix for ticket #2686. More testing and analysis is needed before we close the ticket. (CVS 4458) check-in: 0fb6d5a5 user: drh tags: trunk
15:22
Fix a memory leak that could occur during error-state recovery. (CVS 4457) check-in: 3d1d13d1 user: danielk1977 tags: trunk
15:02
Add a test case to malloc.test. (CVS 4456) check-in: 7d3f0b14 user: danielk1977 tags: trunk
09:43
Fix a problem in test script malloc5.test. (CVS 4455) check-in: 028ec36c user: danielk1977 tags: trunk
08:46
Add automatic recovery from the pager "error-state". Also add a new error code - SQLITE_IOERR_NOMEM. (CVS 4454) check-in: 12eca32a user: danielk1977 tags: trunk
2007-10-02
19:56
Use local variables instead of #defines for the mutex name and length in OS/2's sqlite3_mutex_alloc(). (CVS 4453) check-in: 272959cc user: pweilbacher tags: trunk
2007-10-01
17:47
Additional #ifdefing around _XOPEN_SOURCE. Ticket #2681. (CVS 4452) check-in: eb5d7845 user: drh tags: trunk
17:45
Document that END TRANSACTION is an alias for COMMIT. Ticket #2656 (CVS 4451) check-in: ebe3e691 user: drh tags: trunk
14:30
Omit the _XOPEN_SOURCE 500 define on Mac OS-X. Ticket #2673 (CVS 4450) check-in: 0bbf654b user: drh tags: trunk
13:59
Update the build process so that it includes sqlite3ext.h with the amalgamation ZIP archive. Ticket #2678. (CVS 4449) check-in: 6232ee67 user: drh tags: trunk
13:54
Use sqlite3_int64, not sqlite_in64, consistently in the documentation. Ticket #2680. (CVS 4448) check-in: f7a26470 user: drh tags: trunk
13:50
Fix comment typos in sqlite3.h. Ticket #2666. (CVS 4447) check-in: 2ea278a2 user: drh tags: trunk
13:45
Add text to the load_extension SQL function documentation that explains limitations in the use of that function. Ticket #2672. (CVS 4446) check-in: b2befc84 user: drh tags: trunk
2007-09-21
12:43
Remove "const" keywords from the sqlite3_index_info structure definition. The use of this keyword is suspected to be causing problems for some compilers. (CVS 4445) check-in: 005d780d user: drh tags: trunk
04:28
Another comment typo. Also #2660. (CVS 4444) check-in: 0c1e6f69 user: danielk1977 tags: trunk
04:27
Fix a typo in comments. Ticket #2660. (CVS 4443) check-in: 02c8d60b user: danielk1977 tags: trunk
2007-09-20
21:40
Initial attempt of the new OS/2 mutex implementation. (Compiles and an attempt to create a new table does not crash in mutex_os2 any more.) (CVS 4442) check-in: aa61b244 user: pweilbacher tags: trunk
14:39
Replace "i64" with "sqlite3_int64" in the w32 VFS. (CVS 4441) check-in: 138d3fcc user: drh tags: trunk
12:53
Cleanup the hash functions in FTS3. (CVS 4440) check-in: ac645c8f user: drh tags: trunk
11:34
get rid of remaining GCC 4.3 -Wall compiler warnings by initializing two variables and one structure properly (although the code path was already rather safe) (CVS 4439) check-in: d748694f user: rse tags: trunk