Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 descendants of 41e226d2ff5c0021
|
2005-11-21
| ||
| 12:46 | The EXPLAIN QUERY PLAN now identifies when tables use the integer primary key. (CVS 2771) (check-in: 80721e2c90 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: b3882b434a user: drh tags: trunk) | |
| 12:53 | Do not allow aggregate functions in a WHERE clause. Ticket #1514. (CVS 2769) (check-in: bb866ed880 user: drh tags: trunk) | |
| 04:34 | Avoid unnecessary strlen() calls in the OP_String opcode. (CVS 2768) (check-in: 2e195e96bc 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: 25fa16a2e1 user: drh tags: trunk) | |
|
2005-11-14
| ||
| 22:29 | Create separate affinities for INTEGER and REAL. (CVS 2766) (check-in: ce06c123d0 user: drh tags: trunk) | |
| 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) | |