Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 check-ins occurring around 1cdfe66714.
|
2005-11-14
| ||
| 11:51 | Fix documentation typo. (CVS 2765) (check-in: c9b413ea22 user: drh tags: trunk) | |
|
2005-11-06
| ||
| 04:06 | About 0.5KiB of additional compression in the parser tables. (CVS 2764) (check-in: f39974ebd8 user: drh tags: trunk) | |
|
2005-11-05
| ||
| 15:11 | Work around a bug in MSVC++. Ticket #1513. (CVS 2763) (check-in: 6331860e77 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: e66289b52f user: drh tags: trunk) | |
| 15:04 | Improved table compression in lemon reduces the overall library size by about 1.5KiB. (CVS 2761) (check-in: 86ac114769 user: drh tags: trunk) | |
|
2005-11-04
| ||
| 22:03 | VACUUM works even on an empty database. Ticket #1512. (CVS 2760) (check-in: 1b6bf4188e 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: 7780f5e9d5 user: drh tags: trunk) | |
| 12:33 | Prohibit parameters in CHECK constraint expressions. (CVS 2758) (check-in: bb94ef64b2 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: be83bfee02 user: drh tags: trunk) | |
| 02:03 | Disallow subqueries in CHECK constraints. (CVS 2756) (check-in: db27afc4cd user: drh tags: trunk) | |
| 01:22 | CHECK constraints that evaluate to NULL pass. (CVS 2755) (check-in: 55b314a22c 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: 2313d912ba 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: e0d6f61c7d 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: 0d3357b5f6 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: c9c476dd83 user: drh tags: trunk) | |
|
2005-10-20
| ||
| 07:28 | Changes to prevent various compiler warnings. (CVS 2750) (check-in: e261b8b09a 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: a0bdb58468 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: 9753af5349 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: edca8913ca 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: 4862eaafd8 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: 9709f0f6bc 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: efec04dedf 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: 533a85eee2 user: drh tags: trunk) | |
| 10:40 | Changes to support TEA on cygwin. (CVS 2742) (check-in: e80fecc986 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: 115340d4e8 user: drh tags: trunk) | |
| 02:13 | Add the SQLITE_OMIT_GET_TABLE compile-time flag. (CVS 2740) (check-in: 6d4bc8f83b 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: 385a08afef 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: 080eadca58 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: 6d780ca6cf user: drh tags: trunk) | |
|
2005-09-24
| ||
| 15:25 | Version 3.2.7 (CVS 2736) (check-in: bd141a7c12 user: drh tags: trunk) | |
| 15:10 | Perparations for version 3.2.7. (CVS 2735) (check-in: 70937d5cfa user: drh tags: trunk) | |
| 11:01 | Add the SQLite console source code in the contrib section of the source tree. (CVS 2734) (check-in: 079c6348f9 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: 352cc9f53b 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: a9b341dccf 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: 655e75ac7d user: drh tags: trunk) | |
| 17:42 | Code cleanup and simplification. Three new Mem opcodes added. The sqlite3VdbeJumpHere function added. (CVS 2730) (check-in: 2471957fee 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: f22d0f64a0 user: drh tags: trunk) | |
| 13:12 | NULLs compare equal to each other when computing GROUP BY categories. (CVS 2728) (check-in: d9b0c97053 user: drh tags: trunk) | |
| 08:47 | Update comments in where.c. No code changes. (CVS 2727) (check-in: bb84d27eda user: drh tags: trunk) | |
| 01:36 | Documentation updates. (CVS 2726) (check-in: 6ec8883c36 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: ea10f9785e user: drh tags: trunk) | |
| 19:05 | Set the default maximum page size to 32768, not 8192. (CVS 2724) (check-in: b32e9ec248 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: 6cc57fcf15 user: drh tags: trunk) | |
| 15:37 | Fix uninitialized value on a UNION ALL select with an ORDER BY clause. (CVS 2722) (check-in: 92126a2161 user: drh tags: trunk) | |
| 13:15 | The sqlite3_query_plan debugging variable now only appears with SQLITE_TEST=1. (CVS 2721) (check-in: 41e226d2ff user: drh tags: trunk) | |
| 12:53 | Work around limitations of MSVC++ 6. Tickets #1429, #1437, and #1440. (CVS 2720) (check-in: b2d1803c25 user: drh tags: trunk) | |
| 12:37 | Change some debugging #defines in order to get SSE working again after recent upgrades. (CVS 2719) (check-in: 86eb7d8363 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: e985f02d20 user: drh tags: trunk) | |
| 19:14 | Update to the download page on the website. (CVS 2717) (check-in: 91bc0d0032 user: drh tags: trunk) | |
| 18:49 | Version 3.2.6 (CVS 2716) (check-in: 1cdfe66714 user: drh tags: trunk) | |
| 18:34 | The sqlite3ReallocOrFree routine should set its pointer to NULL when it fails. (CVS 2715) (check-in: 0e85af44fa 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: 7a7ba73fb5 user: drh tags: trunk) | |
| 17:58 | Fix a memory leak that occurs after malloc fails. (CVS 2713) (check-in: 85b931bf72 user: drh tags: trunk) | |
| 17:05 | Fix the crash.test script to accomodate recent changes. (CVS 2712) (check-in: d594608ff3 user: drh tags: trunk) | |
| 16:48 | Fix a bug in the lock2 test script introduced by check-in (2709) (CVS 2711) (check-in: c3bf17436b user: drh tags: trunk) | |
| 16:36 | Fix a problem with the lock_status pragma and the UTF-16 encoding. (CVS 2710) (check-in: 1a737b457c user: drh tags: trunk) | |
| 15:20 | Changes to make corruption errors easier to track down. (CVS 2709) (check-in: c07330000b user: drh tags: trunk) | |
| 15:17 | Update the webpage description of 3.2.6 changes to talk about ticket #1432. (CVS 2708) (check-in: 0e23c28b25 user: drh tags: trunk) | |
| 13:29 | Bug fix in the ORDER BY optimizer. Ticket #1435. (CVS 2707) (check-in: 553b7ba8f8 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: 21740794ab user: drh tags: trunk) | |
| 02:34 | Updates to the FAQ. (CVS 2705) (check-in: 0eaf430d95 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: 5b6dc12b7d 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: 248f77972b user: drh tags: trunk) | |
| 10:18 | Prevent the sqlite3_pagecount() function from ever returning the pending-byte page. (CVS 2702) (check-in: 35a8893537 user: danielk1977 tags: trunk) | |
| 10:13 | Move the definition of sqlite3_pending_byte from test2.c to os_common.h. (CVS 2701) (check-in: bedf702f53 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: 9115e0621d user: danielk1977 tags: trunk) | |
| 02:55 | Documentation changes in preparation for the release of 3.2.6. (CVS 2698) (check-in: 243f455c7c user: drh tags: trunk) | |
| 02:48 | Undo check-in (2694). (CVS 2697) (check-in: 6017b19625 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: 4686d64975 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: 714254cbc1 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: 9b60f48de7 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: 81fdffdff6 user: drh tags: trunk) | |
| 07:00 | Updates to the documentation on the TCL bindings. (CVS 2692) (check-in: 94aa2d3245 user: drh tags: trunk) | |
| 00:02 | Fix a comment typo in the previous check-in. (CVS 2691) (check-in: 49c952807d 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: 2ec2bd8574 user: drh tags: trunk) | |
|
2005-09-12
| ||
| 23:03 | Bug fix in the new COUNT(DISTINCT) logic. Ticket #1420. (CVS 2689) (check-in: 37116550d3 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: 2f397bd814 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: 3f191cf497 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: 26565b8931 user: drh tags: trunk) | |
| 16:46 | Add the experimental EXPLAIN QUERY PLAN diagnostic capability. (CVS 2685) (check-in: 986efb7b12 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: f43427742b user: drh tags: trunk) | |
| 15:28 | Use of the CROSS keyword in a join prevents table reordering. Ticket #1414. (CVS 2683) (check-in: 415b8b2462 user: drh tags: trunk) | |
|
2005-09-09
| ||
| 10:46 | Enhanced disk-full tests. (CVS 2682) (check-in: 0288fa5d25 user: drh tags: trunk) | |
| 10:17 | Detect errors returned by SetFilePointer on windows. (CVS 2681) (check-in: bc8c33f94c 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: 4d62e36fe3 user: drh tags: trunk) | |
| 01:32 | Defend against disk I/O errors that happen during an sqlite3OsSeek(). (CVS 2679) (check-in: 461e3a0a27 user: drh tags: trunk) | |
|
2005-09-08
| ||
| 20:37 | SUM returns NULL when it has no inputs. Ticket #1413. (CVS 2678) (check-in: 6281859425 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: 2e6230edfd user: drh tags: trunk) | |
| 19:01 | Remove a C++ism that snuck in on one of the reason changes. (CVS 2676) (check-in: 48f6a331ef user: drh tags: trunk) | |
| 14:17 | Remove a few unused variables detected by Borland C. Ticket #1412. (CVS 2675) (check-in: cdfe372a95 user: drh tags: trunk) | |
| 12:57 | Aggregates with GROUP BY can sometimes return no result rows. (CVS 2674) (check-in: 0c3e368d47 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: 3c555a8749 user: drh tags: trunk) | |
| 12:37 | Fix another test to account for SUM() returning integer rather than float. (CVS 2672) (check-in: bc723235e6 user: drh tags: trunk) | |
| 11:04 | Fix typos in documentation. Ticket #1239. (CVS 2671) (check-in: 73fbb8d968 user: drh tags: trunk) | |
| 10:58 | Fix a comment in sqlite.h. Ticket #1321. (CVS 2670) (check-in: ed4e9e751b 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: 21adf4bd99 user: drh tags: trunk) | |
| 02:00 | Changes to comments only in sqliteInt.h. No changes to code. (CVS 2668) (check-in: cc2a61650e user: drh tags: trunk) | |
| 01:58 | Optimizations and refinements. Improvements to test coverage. (CVS 2667) (check-in: 7283f7c29d 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: bcc7d722ce 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: a1b6d910cd user: drh tags: trunk) | |