sqlite/libsql
0
0
Fork 0
mirror of https://github.com/tursodatabase/libsql.git synced 2024-12-17 02:31:13 +00:00
Code

Commit Graph

  • 0cd2d4c9a1 Add the ignore_check_constraints pragma. VACUUM works even on a database that contains table entries that violate check constraints. (CVS 2757) drh 2005-11-03 02:15:02 +00:00
  • 06f6541e2f Disallow subqueries in CHECK constraints. (CVS 2756) drh 2005-11-03 02:03:13 +00:00
  • 6275b88b9e CHECK constraints that evaluate to NULL pass. (CVS 2755) drh 2005-11-03 01:22:30 +00:00
  • ffe07b2dc1 First cut at supporting CHECK constraints. Everything appears to work, but much more testing is needed as well as documentation. (CVS 2754) drh 2005-11-03 00:41:17 +00:00
  • 8df447f0e6 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) drh 2005-11-01 15:48:24 +00:00
  • b127612933 Fix the shift operators so that they work with 64-bit quantities. (CVS 2752) drh 2005-10-29 15:48:30 +00:00
  • eef8b55832 Report an error if the input SQL contains an unterminated string. Ticket #1497. (CVS 2751) drh 2005-10-23 11:29:40 +00:00
  • d9cb6ac02f Changes to prevent various compiler warnings. (CVS 2750) drh 2005-10-20 07:28:17 +00:00
  • b37df7b928 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) drh 2005-10-13 02:09:49 +00:00
  • 54414bb449 Make the default TEMP_STORE=1 (TEMP tables stored on disk) in the configure script. (CVS 2748) drh 2005-10-10 00:05:50 +00:00
  • ec7429ae27 More efficient handling of the LIMIT clause. Scalar subqueries and EXISTS on compound SELECT statements now working properly. Ticket #1473. (CVS 2747) drh 2005-10-06 16:53:14 +00:00
  • 23cc57f6a3 Check-in (2744) as incomplete and broke pragma integrity_check. This completes the change and fixes the problem. (CVS 2746) drh 2005-10-06 13:59:26 +00:00
  • eb3d389ca9 Make the SQLite logo on the website a hyperlink to the home page. Ticket #1471. (CVS 2745) drh 2005-10-05 22:31:49 +00:00
  • b59005e5a3 Make sure pragma integrity_check does not report "ok" after first finding a bunch of errors. (CVS 2744) drh 2005-10-05 11:41:48 +00:00
  • cc43cabcb0 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) drh 2005-10-05 11:35:09 +00:00
  • 29bc461550 Changes to support TEA on cygwin. (CVS 2742) drh 2005-10-05 10:40:15 +00:00
  • f2f23916ec 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) drh 2005-10-05 10:29:36 +00:00
  • ff55c3585c Add the SQLITE_OMIT_GET_TABLE compile-time flag. (CVS 2740) drh 2005-10-05 02:13:40 +00:00
  • af6edf5534 Automatically check for the fdatasync() function and replace it with fsync() if not found. (CVS 2739) drh 2005-10-04 18:38:49 +00:00
  • 762e584e2c 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) drh 2005-10-03 15:11:08 +00:00
  • abec0bee03 Make sure the default storage for virtual tables is the disk not memory while running conflict.test. Ticket #1453. (CVS 2737) drh 2005-09-25 01:13:09 +00:00
  • b842b1a61f Version 3.2.7 (CVS 2736) drh 2005-09-24 15:25:01 +00:00
  • 8dc5a288c6 Perparations for version 3.2.7. (CVS 2735) drh 2005-09-24 15:10:59 +00:00
  • 74217cc079 Add the SQLite console source code in the contrib section of the source tree. (CVS 2734) drh 2005-09-24 11:01:11 +00:00
  • 8e647b8191 Fix an uninitialized structure member that was causing a malfunction when you used deeply nested and very complex views. Ticket #1449. (CVS 2733) drh 2005-09-23 21:11:53 +00:00
  • c035e6e4ab 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) drh 2005-09-22 15:45:04 +00:00
  • de29e3e9be Add VM code comments on the group-by processing. Extra group-by test case. (CVS 2731) drh 2005-09-20 18:13:23 +00:00
  • d654be803f Code cleanup and simplification. Three new Mem opcodes added. The sqlite3VdbeJumpHere function added. (CVS 2730) drh 2005-09-20 17:42:23 +00:00
  • 4f68623875 Cleanup the implementation and the documentation of the new 0x200 P1 flag on the VDBE comparison operands. (CVS 2729) drh 2005-09-20 13:55:18 +00:00
  • e313382e3e NULLs compare equal to each other when computing GROUP BY categories. (CVS 2728) drh 2005-09-20 13:11:59 +00:00
  • b6fb62d9b4 Update comments in where.c. No code changes. (CVS 2727) drh 2005-09-20 08:47:20 +00:00
  • e1547a2f1c Documentation updates. (CVS 2726) drh 2005-09-20 01:36:30 +00:00
  • 22d6a53a77 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) drh 2005-09-19 21:05:48 +00:00
  • eb8cbaeb18 Set the default maximum page size to 32768, not 8192. (CVS 2724) drh 2005-09-19 19:05:21 +00:00
  • 4b14b4d720 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) drh 2005-09-19 17:35:53 +00:00
  • a7aa59e097 Fix uninitialized value on a UNION ALL select with an ORDER BY clause. (CVS 2722) drh 2005-09-19 15:37:06 +00:00
  • 549c8b68c7 The sqlite3_query_plan debugging variable now only appears with SQLITE_TEST=1. (CVS 2721) drh 2005-09-19 13:15:23 +00:00
  • bbdc2b94fc Work around limitations of MSVC++ 6. Tickets #1429, #1437, and #1440. (CVS 2720) drh 2005-09-19 12:53:18 +00:00
  • 48083cee4c Change some debugging #defines in order to get SSE working again after recent upgrades. (CVS 2719) drh 2005-09-19 12:37:27 +00:00
  • a15cdcc4f4 Download page reports sizes in MiB and KiB instead of just bytes. (CVS 2718) drh 2005-09-17 19:28:45 +00:00
  • ee2b437f0a Update to the download page on the website. (CVS 2717) drh 2005-09-17 19:14:40 +00:00
  • 8cb1895c74 Version 3.2.6 (CVS 2716) drh 2005-09-17 18:49:49 +00:00
  • 5c959118f1 The sqlite3ReallocOrFree routine should set its pointer to NULL when it fails. (CVS 2715) drh 2005-09-17 18:34:11 +00:00
  • e3000ae84c 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) drh 2005-09-17 18:02:36 +00:00
  • ac1733d409 Fix a memory leak that occurs after malloc fails. (CVS 2713) drh 2005-09-17 17:58:22 +00:00
  • 0aadf33312 Fix the crash.test script to accomodate recent changes. (CVS 2712) drh 2005-09-17 17:05:19 +00:00
  • 432a93ba73 Fix a bug in the lock2 test script introduced by check-in (2709) (CVS 2711) drh 2005-09-17 16:48:18 +00:00
  • a67367e7d1 Fix a problem with the lock_status pragma and the UTF-16 encoding. (CVS 2710) drh 2005-09-17 16:36:55 +00:00
  • 4928570812 Changes to make corruption errors easier to track down. (CVS 2709) drh 2005-09-17 15:20:26 +00:00
  • bfcb8909c6 Update the webpage description of 3.2.6 changes to talk about ticket #1432. (CVS 2708) drh 2005-09-17 15:17:40 +00:00
  • 36da52425b Bug fix in the ORDER BY optimizer. Ticket #1435. (CVS 2707) drh 2005-09-17 13:29:23 +00:00
  • f5b1138bae Make sure dependencies on the right-hand side of IN operators are checked correctly. Ticket #1433. (CVS 2706) drh 2005-09-17 13:07:13 +00:00
  • 4190d4b53e Updates to the FAQ. (CVS 2705) drh 2005-09-17 02:34:04 +00:00
  • 267cb326e9 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) drh 2005-09-16 17:16:52 +00:00
  • 50f2f43cba Do not journal the file locking page when doing a database copy as part of a VACUUM. Ticket #1432. (CVS 2703) drh 2005-09-16 11:32:18 +00:00
  • 15f411dbdd Prevent the sqlite3_pagecount() function from ever returning the pending-byte page. (CVS 2702) danielk1977 2005-09-16 10:18:45 +00:00
  • 2349c3d151 Move the definition of sqlite3_pending_byte from test2.c to os_common.h. (CVS 2701) danielk1977 2005-09-16 10:13:41 +00:00
  • fd5f5b65b4 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) danielk1977 2005-09-16 09:52:29 +00:00
  • a2833a0cf6 Documentation changes in preparation for the release of 3.2.6. (CVS 2698) drh 2005-09-16 02:55:13 +00:00
  • 688c9f0622 Undo check-in (2694). (CVS 2697) drh 2005-09-16 02:48:01 +00:00
  • 53f733c7ae Fix a whole host of newly discovered memory leaks the occur after a failure of realloc(). (CVS 2696) drh 2005-09-16 02:38:09 +00:00
  • b38ad9991c Fix a memory leak: a failure to deallocate the P3 parameter on a call to sqlite3VdbeChangeP3. (CVS 2695) drh 2005-09-16 00:27:01 +00:00
  • 6e4fc2ca2b The table_info pragma now gives the order of columns in the primary key. (CVS 2694) drh 2005-09-15 21:24:51 +00:00
  • 289ab0760b Correct the sense of a test for SQLITE_DEBUG on the resent NDEBUG change. Ticket #1425 (CVS 2693) drh 2005-09-13 16:12:47 +00:00
  • 111cf34f7a Updates to the documentation on the TCL bindings. (CVS 2692) drh 2005-09-13 07:00:05 +00:00
  • b27795c183 Fix a comment typo in the previous check-in. (CVS 2691) drh 2005-09-13 00:02:16 +00:00
  • 4b529d97ff 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) drh 2005-09-13 00:00:00 +00:00
  • 9d4673a9ea Bug fix in the new COUNT(DISTINCT) logic. Ticket #1420. (CVS 2689) drh 2005-09-12 23:03:16 +00:00
  • c99130fd82 COUNT(DISTINCT x) is now fully functional, though it could benefit from additional testing. (CVS 2688) drh 2005-09-11 11:56:27 +00:00
  • 00b950d71e 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) drh 2005-09-11 02:03:03 +00:00
  • 0c35667b02 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) drh 2005-09-10 22:40:53 +00:00
  • ecc9242f6f Add the experimental EXPLAIN QUERY PLAN diagnostic capability. (CVS 2685) drh 2005-09-10 16:46:12 +00:00
  • d891967052 Avoid a memory leak and/or assertion failure when parsing a table declaration that contains a duplicate column name. Ticket #1418. (CVS 2684) drh 2005-09-10 15:35:06 +00:00
  • 3dec223ca0 Use of the CROSS keyword in a join prevents table reordering. Ticket #1414. (CVS 2683) drh 2005-09-10 15:28:09 +00:00
  • f307a4aaf8 Enhanced disk-full tests. (CVS 2682) drh 2005-09-09 10:46:19 +00:00
  • e08b814d72 Detect errors returned by SetFilePointer on windows. (CVS 2681) drh 2005-09-09 10:17:33 +00:00
  • fd35797469 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) drh 2005-09-09 01:33:19 +00:00
  • b4746b9e33 Defend against disk I/O errors that happen during an sqlite3OsSeek(). (CVS 2679) drh 2005-09-09 01:32:06 +00:00
  • c2bd913a40 SUM returns NULL when it has no inputs. Ticket #1413. (CVS 2678) drh 2005-09-08 20:37:43 +00:00
  • 3f219f46fc 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) drh 2005-09-08 19:45:57 +00:00
  • 825c662e66 Remove a C++ism that snuck in on one of the reason changes. (CVS 2676) drh 2005-09-08 19:01:05 +00:00
  • 4f26bb62a8 Remove a few unused variables detected by Borland C. Ticket #1412. (CVS 2675) drh 2005-09-08 14:17:20 +00:00
  • 97571957a1 Aggregates with GROUP BY can sometimes return no result rows. (CVS 2674) drh 2005-09-08 12:57:28 +00:00
  • eb796a7c8f While doing a transaction comment, use fdatasync() instead of fsync() in cases there the file size is unchanged. (CVS 2673) drh 2005-09-08 12:38:41 +00:00
  • f80bcd73af Fix another test to account for SUM() returning integer rather than float. (CVS 2672) drh 2005-09-08 12:37:28 +00:00
  • 2af6742d86 Fix typos in documentation. Ticket #1239. (CVS 2671) drh 2005-09-08 11:04:57 +00:00
  • 3224b32b00 Fix a comment in sqlite.h. Ticket #1321. (CVS 2670) drh 2005-09-08 10:58:51 +00:00
  • 3d1d95e625 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) drh 2005-09-08 10:37:01 +00:00
  • d49c16ee9b Changes to comments only in sqliteInt.h. No changes to code. (CVS 2668) drh 2005-09-08 02:00:25 +00:00
  • 9d2985c7b4 Optimizations and refinements. Improvements to test coverage. (CVS 2667) drh 2005-09-08 01:58:42 +00:00
  • 5360ad34b1 All regression tests now pass. But I am sure there must still be problems. New tests need to be added. (CVS 2666) drh 2005-09-08 00:13:27 +00:00
  • d1c301e804 More bug fixes. All of the "quick" tests pass. The full test suite still shows problems. (CVS 2665) drh 2005-09-07 23:05:21 +00:00
  • 5774b80629 More bug fixes. But there are still tests that fail. (CVS 2664) drh 2005-09-07 22:48:16 +00:00
  • a10a34b88f Bug fixes in aggregate processing. Fewer tests fail. (CVS 2663) drh 2005-09-07 22:09:48 +00:00
  • 13449892ef Rewrite the aggregate handling logic so that it runs in O(1) space. This is the first cut at the code. Many regression tests fail. (CVS 2662) drh 2005-09-07 21:22:45 +00:00
  • 79158e1865 Changes to reduce the amount of stack space required. (CVS 2661) drh 2005-09-06 21:40:45 +00:00
  • abfcea25ea Cleanup the processing of MEM_Agg elements. (CVS 2660) drh 2005-09-06 20:36:48 +00:00
  • 1ec43c9a5a Fix ANALYZE so that it works even if the empty_result_callbacks pragma is enabled. Ticket #1409. (CVS 2659) drh 2005-09-06 10:26:47 +00:00
  • b726ee6d1c Make due with "sub()" instead of "gsub()" in awk scripts so that builds will work on Solaris which will runs an archiac version of AWK. (CVS 2658) drh 2005-09-05 20:35:25 +00:00
  • d81bd4e209 Fix bugs introduced by checkin (2656) and do some modest code enhancements. (CVS 2657) drh 2005-09-05 20:06:49 +00:00