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

  • c092998715 Use the unicode API to win32 where available. Tickets #1407, #1396, #1331, #1243, #1206 (CVS 2656) drh 2005-09-05 19:08:29 +00:00
  • a21c8495f9 Fix over-aggressive optimization of ORDER BY as reported on the mailing list. (CVS 2655) drh 2005-09-01 17:47:51 +00:00
  • 4db38a7092 All regression tests now pass with the new bounded-memory sort code. There is still lots of opportunity for optimization, however. (CVS 2654) drh 2005-09-01 12:16:28 +00:00
  • 0342b1f542 Sorting is now done using a sorting index rather than loading the entire result set into memory and doing a merge sort. The old merge sort technique was a carry-over from SQLite version 1. The new method uses a bounded amount of memory and scales to much larger result sets. There are still errors: some 39 regression tests fail. (CVS 2653) drh 2005-09-01 03:07:44 +00:00
  • dece1a8464 {quote: KeyInfo} generation moved to a common subroutine. (CVS 2652) drh 2005-08-31 18:20:00 +00:00
  • 6242b9511d Updates to the query optimizer overview document. (CVS 2651) drh 2005-08-31 13:48:34 +00:00
  • 37108e112a Explicit typecasts to silence nuisance compiler warnings. Ticket #1398. (CVS 2650) drh 2005-08-31 13:13:31 +00:00
  • a91965b38a Refinements to the optimizer overview and integration into the website. (CVS 2649) drh 2005-08-31 03:13:12 +00:00
  • b64d5ee42c Update the FAQ to include an entry about binary versus decimal numbers. (CVS 2648) drh 2005-08-31 02:46:21 +00:00
  • f6ac657f27 Adding the first cut of the optimizer overview document. (CVS 2647) drh 2005-08-31 01:49:59 +00:00
  • 8897f6fa3f Adjust the makefile for new optimizer documentation. (CVS 2646) drh 2005-08-30 22:44:29 +00:00
  • 3e60cdc3c0 Initial work on documentation describing the optimizer. (CVS 2645) drh 2005-08-30 22:44:05 +00:00
  • 0a8640d4f2 The CSV output mode does not sign-extend bytes where the high-order bit is set. Ticket #1397. (CVS 2644) drh 2005-08-30 20:12:02 +00:00
  • 63782855ee Fix printf.c so that it handles 10.0 correctly. (CVS 2643) drh 2005-08-30 19:30:59 +00:00
  • 5d9a4af9af Minor code enhancements. (CVS 2642) drh 2005-08-30 00:54:01 +00:00
  • 220b10285b Update the home page to brag about 150KiB code footprint when optional features are omitted. (CVS 2641) drh 2005-08-30 00:10:45 +00:00
  • 01b4171e57 Make the shell aware of SQLITE_OMIT_MEMORYDB. Ticket #1395. (CVS 2640) drh 2005-08-29 23:06:23 +00:00
  • 19e2d37f1d Increase resolution of time-of-day on unix. Add an experimental sqlite3_profile() API. (CVS 2639) drh 2005-08-29 23:00:03 +00:00
  • b46b57745d Initialize a local variable to avoid a nuisance compiler warning. Ticket #1394. (CVS 2638) drh 2005-08-29 16:40:52 +00:00
  • d64fe2f374 The LIKE optimization does the right thing when collating sequences are present. LIKE expressions where the left-hand side has COLLATE NOCASE are optimized in the default case. (CVS 2637) drh 2005-08-28 17:00:23 +00:00
  • bfd6b03554 Improvements to the formatting and layout of the code in the previous checkin. (CVS 2636) drh 2005-08-28 01:38:44 +00:00
  • de941c605e Add an assert to verify that floating point values and integers use the same byte order. Add a comment to the SELECT code generator. (CVS 2635) drh 2005-08-28 01:34:21 +00:00
  • 9b4b45d5cf Version 3.2.5 (CVS 2634) drh 2005-08-27 17:23:00 +00:00
  • 0b9693556d Change the wording of the news line for release 3.2.5. (CVS 2633) drh 2005-08-27 17:22:11 +00:00
  • c5ee956611 Get the date right. Today is the 27th, not the 25th or the 28th. (CVS 2632) drh 2005-08-27 17:19:33 +00:00
  • f9dc42d870 Increase the version number and update web pages for the next release. (CVS 2631) drh 2005-08-27 17:06:15 +00:00
  • 2c8997b9a5 Disable synchronous writes to the master journal when PRAGMA synchronous=OFF for all database files. Ticket #1375. (CVS 2630) drh 2005-08-27 16:36:48 +00:00
  • 9cc5abd769 Fix comment in vdbeapi.c. Remove unused structure definition from func.c. (CVS 2629) drh 2005-08-27 13:16:32 +00:00
  • ff8a0983d2 Remove the words "statically linked" from the description of the shell on the download page. Ticket #1391. (CVS 2628) drh 2005-08-27 13:11:20 +00:00
  • 77207ab7c6 Remove GNUmake extensions from the makefile. Ticket #1390. (CVS 2627) drh 2005-08-27 09:07:14 +00:00
  • 6e4b7cd4ef Do not change fields of stale sqlite3 handles. Ticket #1384. (CVS 2626) drh 2005-08-27 01:51:44 +00:00
  • e69cc5b742 Widen the opcode column of explain output in the shell. (CVS 2625) drh 2005-08-27 01:50:53 +00:00
  • 87abf5c033 When the left-hand side of an IN operator is constant and the right-hand side is a SELECT, recognize that the IN operator is not constant. Ticket #1380. (CVS 2624) drh 2005-08-25 12:45:04 +00:00
  • 65d415cb72 Fix the --enable-threadsafe option to the configure script. Ticket #1378. (CVS 2623) drh 2005-08-24 18:04:51 +00:00
  • 0f77f5dc0b Additional defense against the rowid-fifo overflow problem. (CVS 2622) drh 2005-08-24 17:07:37 +00:00
  • 978468d488 Remove a stray C++ style comment causing problems for some compilers. (CVS 2621) drh 2005-08-24 16:54:05 +00:00
  • 3ca84ba0a0 Fix a bug in DELETE that might cause a segfault when deleting more than 40940 rows of data all at once. (CVS 2620) drh 2005-08-24 16:13:51 +00:00
  • 3268f2b10c Version 3.2.4 (CVS 2619) drh 2005-08-24 11:14:46 +00:00
  • 96c52a9b48 Increase the version number and update the change log prior to release. (CVS 2618) drh 2005-08-24 11:07:19 +00:00
  • 9eb2028fbc After calling realloc() on an array to resize it, be sure not to use pointers into the old array. Ticket #1376. (CVS 2617) drh 2005-08-24 03:52:18 +00:00
  • 7681618c18 Allow floating point literals to being or end with a decimal point. Ticket #1371. (CVS 2616) drh 2005-08-23 11:31:26 +00:00
  • 6c8c6cec1f Handle empty blob constants correctly. Ticket #1373. (CVS 2615) drh 2005-08-23 11:17:58 +00:00
  • 75757853a0 Fix another documentation typo. (CVS 2614) drh 2005-08-23 11:03:02 +00:00
  • 8c154875b1 Fix typos in syntax documentation. Ticket #1374 and a report on the mailing list. (CVS 2613) drh 2005-08-23 11:00:39 +00:00
  • ff1bc76916 Update the download page of the website to handle TEA builds and starkits. (CVS 2612) drh 2005-08-22 02:10:46 +00:00
  • ad81e87054 Clean up possible locking problem in multithreaded applications that take a malloc failure. (CVS 2611) drh 2005-08-21 21:45:01 +00:00
  • 03e7954732 Version 3.2.3 (CVS 2610) drh 2005-08-21 18:54:48 +00:00
  • 7a22af6a60 Increase the version number and adjust documentation prior to the next release. (CVS 2609) drh 2005-08-21 18:40:20 +00:00
  • 788581d78a Disable malloc tests when not compiled with SQLITE_DEBUG. (CVS 2608) drh 2005-08-21 18:21:50 +00:00
  • 130b9f4040 Do not create an error message if there is no error. (CVS 2607) drh 2005-08-21 17:48:46 +00:00
  • 992f2d781d Do not overwrite small files (less than 1024 bytes) that are not databases. Ticket #1370. (CVS 2606) drh 2005-08-21 16:54:25 +00:00
  • f0bce09cdd More test coverage improvements. (CVS 2605) drh 2005-08-20 13:47:41 +00:00
  • 85c23c61e2 Increased test coverage. Some malloc tests now fail though this is believed to be an instrumentation problem not a real error. (CVS 2604) drh 2005-08-20 03:03:04 +00:00
  • 0bbaa1ba9a Increase test coverage of alter.c to 100%. Fix bugs found in the process. (CVS 2603) drh 2005-08-19 19:14:12 +00:00
  • f14fd03899 Additional tests for better coverage. (CVS 2602) drh 2005-08-19 03:03:51 +00:00
  • 5eba8c09df Increased test coverage on trigger.c and printf.c. (CVS 2601) drh 2005-08-19 02:26:27 +00:00
  • fc23314a0b More test coverage enhancements. (CVS 2600) drh 2005-08-19 01:07:15 +00:00
  • 8b3d990b71 Bring testing coverage of the analyze.c file up to 100%. Bugs found and fixed in the process. (CVS 2599) drh 2005-08-19 00:14:42 +00:00
  • 91124b3545 Comment fixes. No changes to the underlying code. (CVS 2598) drh 2005-08-18 18:15:05 +00:00
  • 731c96b412 Fix typo in documentation. (CVS 2597) drh 2005-08-16 14:44:48 +00:00
  • ce604012ac Null-terminate the strings array passed to Tcl_GetIndexFromObj. Bug reported on the mailing list. (CVS 2596) drh 2005-08-16 11:11:34 +00:00
  • c182d16302 General code cleanup resulting in smaller footprint. (CVS 2595) drh 2005-08-14 20:47:16 +00:00
  • a2b902d66d Split the sqlite3_complete() API out into a separate source file so that in static links where it is not used it will not take up space in the resulting binary. (CVS 2594) drh 2005-08-14 17:53:20 +00:00
  • 9abc9c6aff Declare local-use functions as static. Ticket #1363. (CVS 2593) drh 2005-08-14 01:34:19 +00:00
  • 55ef4d9758 The case_sensitive_like pragma added. Test cases added for the LIKE optimization. (CVS 2592) drh 2005-08-14 01:20:37 +00:00
  • 3d94662a06 Provide grave accent quoting of identifiers for MySQL compatibility. Ticket #1337. (CVS 2591) drh 2005-08-13 18:15:42 +00:00
  • d645967aaa Give the same access permissions to journal files as is given to databases. (CVS 2590) drh 2005-08-13 17:17:01 +00:00
  • 8718f52624 Disable an overzealous optimization the omitted sorting on a join if the first table gave a unique result. The sort can only be omitted if all tables in the join are unique. Ticket #1358. (CVS 2589) drh 2005-08-13 16:13:04 +00:00
  • 531fe87834 Fix a comment in printf. (CVS 2588) drh 2005-08-13 13:40:42 +00:00
  • 3e9aeec03f Additional cleanup and optimization of the printf function. (CVS 2587) drh 2005-08-13 13:39:02 +00:00
  • 557cc60f4d Add the "!" flag to the "%g" mprintf conversion parameter to force a decimal point. This prevents floating point values from appearing as integers. Use this flag when converting floating point to text. Ticket #1362. (CVS 2586) drh 2005-08-13 12:59:14 +00:00
  • 592ac8cb6c Make the round() function work correctly on numbers with very large exponents. Ticket #1340. (CVS 2585) drh 2005-08-13 03:07:47 +00:00
  • 42b9d7c561 Fix a memory leak that occurs when a CREATE TABLE that contains a DEFAULT VALUE fails due to a name conflict. Tickets #1356 and #1357. (CVS 2584) drh 2005-08-13 00:56:27 +00:00
  • 2501eb1df6 3rd argument to sqlite3Error() should always be a format string, never user-supplied error message text. Ticket #1354. (CVS 2583) drh 2005-08-12 23:20:53 +00:00
  • bb7ac00bf0 Improved error message when a #NNN parameter appears on user input. Additional coverage testing. (CVS 2582) drh 2005-08-12 22:58:53 +00:00
  • d2687b7731 Optimize LIKE and GLOB operators in the WHERE clause. Code passes all regression tests but still needs additional tests. (CVS 2581) drh 2005-08-12 22:56:09 +00:00
  • 2db0bbc24b Improve the error message associated with SQLITE_FULL. Ticket #1353. Also remove error messages for obsolete error codes SQLITE_INTERNAL, SQLITE_NOTFOUND, and SQLITE_TOOBIG. (CVS 2580) drh 2005-08-11 02:10:18 +00:00
  • 4dcbdbff40 Add 2005 open source award badge and news announcement. (CVS 2579) drh 2005-08-11 01:25:22 +00:00
  • 1cd7f83ef5 Make sure the .import command strips newlines off the end of the last field in each line imported. Ticket #1348 (CVS 2578) drh 2005-08-05 18:50:51 +00:00
  • 7018030d06 Comment out the use of memory high-water marks when not compiling with SQLITE_MEMDEBUG. (CVS 2577) drh 2005-08-02 21:42:16 +00:00
  • 45b1ee44a4 Minor refactoring of the new optimizer code. (CVS 2576) drh 2005-08-02 17:48:22 +00:00
  • 586e4b2f30 Update the documentation for the new transaction method on the TCL interface. (CVS 2575) drh 2005-08-02 17:38:19 +00:00
  • b5555e7e34 Tests and bug fixes on the new transaction method in the TCL interface. (CVS 2574) drh 2005-08-02 17:15:14 +00:00
  • 09d0debf3b Fix a bug in the btree balancer. ticket #1346. (CVS 2573) drh 2005-08-02 17:13:09 +00:00
  • 3d21423c65 Add the "transaction" coommand to the TCL interface. Untested. (CVS 2572) drh 2005-08-02 12:21:08 +00:00
  • 943af3cda1 Fix problems caused by over-agressive optimization of ORDER BY in joins. Lots more testing needed. (CVS 2571) drh 2005-07-29 19:43:58 +00:00
  • 2ce99ecf8b Fix authentication so that it works with AS aliases. Ticket #1338. (CVS 2570) drh 2005-07-29 15:36:14 +00:00
  • 6c30be8e51 Optimizer now converts OR-connected WHERE-clause terms into an IN operator so that they can be used with indices. There are known problems with the ORDER BY optimization in this and in several prior check-ins. This check-in is not recommended for production use. (CVS 2569) drh 2005-07-29 15:10:17 +00:00
  • ed37800693 The BETWEEN operator in a WHERE clause is now able to use indices. (CVS 2568) drh 2005-07-28 23:12:08 +00:00
  • a611040eea Test cases and tuning of the new optimizer code. (CVS 2567) drh 2005-07-28 20:51:19 +00:00
  • 3adc9cedb0 The new optimizer now passes all regression tests. (CVS 2566) drh 2005-07-28 16:51:51 +00:00
  • 28c4cf42da More work on the new optimizer. Fewer tests fail now. (CVS 2565) drh 2005-07-27 20:41:43 +00:00
  • 51147baa6d A new optimizer that breaks a lot of tests. But none of them critically, I think. Nevertheless, there is a lot of work ahead to stabilize the code. (CVS 2564) drh 2005-07-23 22:59:55 +00:00
  • 17a18f2f36 Store the total number of rows as part of the ANALYZE statistics. (CVS 2563) drh 2005-07-23 14:52:12 +00:00
  • 497e446d76 The results of ANALYZE are now loaded into internal data structures where they can be used. But they are not actually used yet. (CVS 2562) drh 2005-07-23 03:18:40 +00:00
  • e6e049694d Full-coverage testing and documentation for the ANALYZE command. The results of analysis are still not loaded or used, however. (CVS 2561) drh 2005-07-23 02:17:03 +00:00
  • ff2d5ea408 First code for the ANALYZE command. Mostly untested. The analysis is not loaded into the symbol tables and is not used by the optimizer. (CVS 2560) drh 2005-07-23 00:41:48 +00:00
  • d00ada9a00 Clarify the meaning of the TEMP keyword on CREATE TABLE. (CVS 2559) drh 2005-07-22 23:56:49 +00:00
  • ed90e26313 Correct the documentation to show that sqlite3_column_text() returns a NULL pointer (not an empty string) when the column value is NULL. The same goes for sqlite3_column_blob(). Ticket #1334. (CVS 2558) drh 2005-07-22 22:53:15 +00:00
  • e23399fc9c Begin adding code to support multiple IN constraints on the same index. (CVS 2557) drh 2005-07-22 00:31:39 +00:00