sqlite/libsql
0
0
Fork 0
mirror of https://github.com/tursodatabase/libsql.git synced 2024-12-15 00:29:48 +00:00
Code

Commit Graph

  • 0cfcf3fbd1 Added %Q format specifier: like %q but automatic enclosing in single quotes, NULL pointers replaced by NULL w/o single-quotes. (CVS 621) chw 2002-06-16 04:55:48 +00:00
  • f220b24fc6 Changed sqlite_mprintf_str to allow a NULL string parameter. Command template now is cmd FORMAT INT INT ?STRING?. When STRING omitted a NULL is passed to sqlite_mprintf. (CVS 620) chw 2002-06-16 04:54:28 +00:00
  • df199a25bd Make the LIMIT clause work even if the destination of the SELECT is something other than a callback. (Ticket #66) (CVS 619) drh 2002-06-14 22:38:41 +00:00
  • c27a1ce4bd Improvements to comments. No code changes. (CVS 618) drh 2002-06-14 20:58:45 +00:00
  • c67980bedc Fix for bug #72: Make sure the file descriptors are properly closed if sqliteInit() fails for any reason. (CVS 617) drh 2002-06-14 20:54:14 +00:00
  • 6ca62f21e3 Fix for bug #70: Correct a typo in the documentation. (CVS 616) drh 2002-06-12 22:33:54 +00:00
  • c3d2ac6561 Documentation that should have been checked in along with checkin (614) (CVS 615) danielk1977 2002-06-11 22:33:47 +00:00
  • 6f34903e85 Add RAISE() function, which allows more advanced flow-control in trigger programs (ticket #55) (CVS 614) danielk1977 2002-06-11 02:25:40 +00:00
  • 28f4b6885b Fix the spelling of sqliteRegisterBuiltinFunctions(). (CVS 613) drh 2002-06-09 10:14:18 +00:00
  • 48185c15c7 Added tests for the new IN operator optimizer and fixed a bug that the new tests found. This completes the implementation of enhancement #63. (CVS 612) drh 2002-06-09 01:55:20 +00:00
  • d9e3093038 Fix for ticket #65: If an integer value is too big to be represented as a 32-bit integer, then treat it as a string. (CVS 611) drh 2002-06-09 01:16:01 +00:00
  • d99f70680f Add optimizations for the IN operator in WHERE clauses. This is a partial implementation of enhancement #63. Still need to add test cases. (CVS 610) drh 2002-06-08 23:25:08 +00:00
  • f5db2d3ea2 Bug fix: do not segfault if a SELECT without a FROM clause includes the * wildcard in the result column list. (CVS 609) drh 2002-06-06 23:42:27 +00:00
  • d5c644c0b1 Fix for ticket #59: Add documentation for the || operator. Also added documentation for the new SQL92 join syntax. (CVS 608) drh 2002-06-06 23:30:58 +00:00
  • 5df72a5ad6 Fix for ticket #62: Do not report an SQLITE_READONLY error until the application actually tries to write data into a readonly file. It is OK to start a transaction on a read-only file, and doing so will get you a read lock. This change allows TEMP tables to be read/write even though the main database is readonly. (CVS 607) drh 2002-06-06 23:16:05 +00:00
  • 34e33bb835 Additional grammar cleanup resulting from the %fallback directive. (CVS 606) drh 2002-06-06 19:04:16 +00:00
  • 0bd1f4ea5a Added the %fallback directive to the lemon parser generator and used this in the parser to make the parse tables much smaller. This reduced the size of the library by 15K. (CVS 605) drh 2002-06-06 18:54:39 +00:00
  • bd790ee395 Fix a compiler warning. (CVS 604) drh 2002-06-02 18:22:06 +00:00
  • 04738cb9ff Add the ability to parse FOREIGN KEYs. Foreign keys are still ignored, but at least they now do not cause a syntax error. (CVS 603) drh 2002-06-02 18:19:00 +00:00
  • e4de1feb3e Enhance the ORDER BY clause so that an integer term means to sort by the corresponding column. (CVS 602) drh 2002-06-02 16:09:01 +00:00
  • 1288c9561d Multiplying NULL by zero gives NULL, not zero. I misread the test data and coded it wrong. This check-in fixes the problem. (CVS 601) drh 2002-06-01 21:41:10 +00:00
  • f570f011eb Refinements to NULL processing: NULLs are indistinct for DISTINCT and UNION. Multiplying a NULL by zero yields zero. In a CASE expression, a NULL comparison is considered false, not NULL. With these changes, NULLs in SQLite now work the same as in PostgreSQL and in Oracle. (CVS 600) drh 2002-05-31 15:51:25 +00:00
  • 0f89253e21 Once it is opened, leave the checkpoint journal file open for the duration of a transaction, rather than closing it and reopening it for each statement. (Ticket #53) (CVS 599) drh 2002-05-30 12:27:03 +00:00
  • 461c281a2e Bug fix: bad code was generated for when the first operand of a CASE was NULL. (CVS 598) drh 2002-05-30 02:35:11 +00:00
  • 739105c72c Built-in aggregate functions (MIN, SUM, AVG, etc) should ignore NULL entires. (CVS 597) drh 2002-05-29 23:22:23 +00:00
  • f1756d2a79 Remove extra \ characters from temporary filenames under windows. (Ticket #52) (CVS 596) drh 2002-05-29 12:44:52 +00:00
  • 993b173e55 Update trigger2.test to match checkin 591. Also fix ticket #51 (by documenting problem) (CVS 595) danielk1977 2002-05-28 06:55:27 +00:00
  • d7489c3987 A SELECT statement inside the body of a TRIGGER uses the SRT_Discard target to discard the query results. Such selects are intended to be used to call user-defined functions for their side-effects. They do not return results. (CVS 594) drh 2002-05-27 12:24:48 +00:00
  • c754fa5486 Fix the "alias.*" bug found by Bernie Cosell and reported on the newsgroup. (CVS 593) drh 2002-05-27 03:25:51 +00:00
  • bb113518f9 Bug fixes and additional test cases for the distinct-NULL patch. (CVS 592) drh 2002-05-27 01:04:51 +00:00
  • d702fccbce Require the INSTEAD OF syntax to create triggers on database views. (CVS 591) danielk1977 2002-05-26 23:24:40 +00:00
  • 8912d106e1 Change functions to handle NULLs correctly. Added the NULLIF() function. (CVS 590) drh 2002-05-26 21:34:58 +00:00
  • f5905aa7be NULL values are distinct. A comparison involving a NULL is always false. Operations on a NULL value yield a NULL result. This change makes SQLite operate more like the SQL spec, but it may break existing applications that assumed the old behavior. All the old tests pass but we still need to add new tests to better verify the new behavior. Fix for ticket #44. (CVS 589) drh 2002-05-26 20:54:33 +00:00
  • 195e6967fb Additional testing of LEFT OUTER JOIN. (CVS 588) drh 2002-05-25 00:18:20 +00:00
  • ad2d8307ac Initial implementation of LEFT OUTER JOIN including the expanded SQL92 join syntax. The basic functionality is there but there is still a lot of testing to do. (CVS 587) drh 2002-05-24 20:31:36 +00:00
  • 01f3f25376 Add support for the full SQL join syntax. This is just a parser enhancement. We now recognize all kinds of joins, but we don't actually do anything with them yet. (CVS 586) drh 2002-05-24 16:14:15 +00:00
  • 2e392e2c53 Added tests for multi-column primary keys. (CVS 585) drh 2002-05-24 02:14:50 +00:00
  • ad3cab52fe Split the IdList structure into IdList and SrcList. SrcList is used to represent a FROM clause and IdList is used for everything else. This change allows SrcList to grow to support outer joins without burdening the other uses of IdList. (CVS 584) drh 2002-05-24 02:04:32 +00:00
  • bd5a451d5d Change the names of the PushList and PopList opcodes to ListPush and ListPop so that they will appear together with the other List opcodes in the documentation. (CVS 583) drh 2002-05-23 22:07:02 +00:00
  • 0b4efed236 Fix for ticket #50. (CVS 582) drh 2002-05-23 13:15:37 +00:00
  • 07d6e3a74c Partial fix for ticket #49. The correct result is computed, but now we have a memory leak. I'm not sure if the memory leak was pre-existing or a result of this change. (CVS 581) drh 2002-05-23 12:50:18 +00:00
  • e4697f5e90 Fix some places where a malloc() failure would lead to a segfault. (CVS 580) drh 2002-05-23 02:09:03 +00:00
  • 1873cd508a Do not allow triggers on the SQLITE_MASTER table. (CVS 579) drh 2002-05-23 00:30:31 +00:00
  • 97fc3d060a Fix for ticket #46: Report an error if a CREATE TABLE contains two or more columns with the same name. (CVS 578) drh 2002-05-22 21:27:03 +00:00
  • 2ce1a6ec60 Fix for ticket #47: Use a cast to avoid a warning about discarding a "const" inside of hash.c. (CVS 577) drh 2002-05-21 23:44:30 +00:00
  • 2398937b7f Double-quoted strings resolve to column names if possible. Single-quoted strings continue to be interpreted as string literals. (CVS 576) drh 2002-05-21 13:43:04 +00:00
  • 1d1f30555d Clean up some compiler warnings. (CVS 575) drh 2002-05-21 13:18:25 +00:00
  • b05789ff2b Modify the shell so that when it is doing a ".dump" it always uses single quotes and not double quotes for quoting literal strings. This is for portability to other databases that only support single quote string literals. (CVS 574) drh 2002-05-21 13:02:24 +00:00
  • 79b0c95687 Fix for ticket #45: Allow an UPDATE statement to change the INTEGER PRIMARY KEY to itself without triggering a constraint error. (CVS 573) drh 2002-05-21 12:56:43 +00:00
  • c977f7f596 Additional code cleanup resulting from a review of the new trigger code. (CVS 572) drh 2002-05-21 11:38:11 +00:00
  • f29ce55958 Style fixes to triggers code in various *.c files (partial fix to ticket #39) (CVS 571) danielk1977 2002-05-19 23:43:12 +00:00
  • 633ed08d95 Stylistic changes to src/trigger.c (partial fix to ticket #39). Also more comments. (CVS 570) danielk1977 2002-05-17 00:05:58 +00:00
  • d99bc930f7 Fix for ticket #42: Added comments to structs Trigger, TriggerStep and TriggerStack. (CVS 569) danielk1977 2002-05-16 00:13:12 +00:00
  • b6b2de0c35 Fix a typo in the c_interface.html documentation file. (CVS 568) drh 2002-05-15 23:26:22 +00:00
  • ce9079c8f2 Fix for ticket #41: Better handling of CREATE TRIGGER in the sqlite_complete() function. (CVS 567) drh 2002-05-15 14:17:44 +00:00
  • dc3794561f Beginning to clean up the trigger code. Still lots of work to do. (CVS 566) drh 2002-05-15 12:45:43 +00:00
  • 9adf9ac4e4 Remove all tabs from the beginning of source code lines. Replace tabs with the appropriate number of spaces. (CVS 565) drh 2002-05-15 11:44:13 +00:00
  • 5b87fa2a57 In the "lang.html" documentation file, put the CREATE TRIGGER and DROP TRIGGER sections in alphabetical order. (CVS 564) drh 2002-05-15 11:43:16 +00:00
  • b38f58b51a Add the Makefile.in that was forgotten with checkin #562 (CVS 563) danielk1977 2002-05-15 08:43:10 +00:00
  • c3f9bad209 Added FOR EACH ROW triggers functionality (CVS 562) danielk1977 2002-05-15 08:30:12 +00:00
  • 9456bcc975 Version 2.4.12 (CVS 561) drh 2002-05-10 14:41:54 +00:00
  • 4d908a3b43 Update the misuse.test script so that it will work under Windows. Changes to the speed testing script to support version 2.4.12. (CVS 560) drh 2002-05-10 14:37:30 +00:00
  • c22bd47d55 Improvements to the SQLITE_MISUSE detection logic. Also added test cases for this logic, including the new test file "misuse.test". (CVS 559) drh 2002-05-10 13:14:07 +00:00
  • 247be43d60 Attempt to detect when two or more threads try to use the same database at the same time and return an SQLITE_MISUSE error. Also return this error if an attempt is made to use a closed database. (CVS 558) drh 2002-05-10 05:44:55 +00:00
  • d5feede1ff Fix for ticket #35: Ignore any ORDER BY clause on a subquery in a FROM clause. (CVS 557) drh 2002-05-08 21:46:14 +00:00
  • 0f18b450ad Fix for ticket #34: VIEWs ignore their ORDER BY clause. (CVS 556) drh 2002-05-08 21:30:15 +00:00
  • 891da435d6 Version 2.4.11 (CVS 555) drh 2002-05-08 12:03:50 +00:00
  • 685b941542 Increase the version number and update the change log in preparation for the 2.4.11 release. (CVS 554) drh 2002-05-08 11:57:09 +00:00
  • 0bb28106be Fix for tickets #32 and #33: Generate the names of the result set early, before doing the flattening optimization or evaluating subqueries. Otherwise, the result set column names are generated incorrectly or after they are needed. (CVS 553) drh 2002-05-08 11:54:14 +00:00
  • cc47c28068 Added documentation about the new CASE expression. (CVS 552) drh 2002-05-06 11:47:32 +00:00
  • 0fface6e33 Fix typos in the man-page (sqlite.1) and remove two unused files. Patches from Andreas Rottmann. (CVS 551) drh 2002-05-06 11:34:26 +00:00
  • 133224676a Version 2.4.10 (CVS 550) drh 2002-05-03 00:18:11 +00:00
  • 2e18abf43c Update the change log prior to releasing version 2.4.10. (CVS 549) drh 2002-05-03 00:17:54 +00:00
  • 08192d5f76 Fix for ticket #31: Do not attempt the flattening optimization if the subselect does not contain a FROM clause. Handle the special case where a WHERE clause is constant. (CVS 548) drh 2002-04-30 19:20:28 +00:00
  • ef9f708e8f Fix for ticket #28: Export the "sqlite_changes" function in Windows DLLs. (CVS 547) drh 2002-04-26 09:47:20 +00:00
  • f7bd5d75db Update the test logic and the comments on the encoder.c module. (CVS 546) drh 2002-04-25 23:06:47 +00:00
  • e8a49c12a6 Added the "encode.c" source file that contains two utility subroutines that can be used to encode binary data for use in INSERT and UPDATE statements. This is just an initial checking. The code has not yet been integrated into the library. (CVS 545) drh 2002-04-25 11:45:41 +00:00
  • 7caf776079 Fix for ticket #26: Document the fact that CREATE TABLE might not be immediately visible to other processes that are holding the database open. (CVS 544) drh 2002-04-25 00:21:50 +00:00
  • 41202ccae2 Fix for ticket #22: In the code generator for compound SELECT statements, take care not to generate column name headers if the output is an intermediate table. Otherwise the column headers are not generated correctly if a compound SELECT statement appears as an expression in part of the WHERE clause. (CVS 543) drh 2002-04-23 17:10:18 +00:00
  • 60ea3720f2 Version 2.4.9 (CVS 542) drh 2002-04-22 00:35:06 +00:00
  • 85b988c803 Update the version number and changes log for 2.4.9 (CVS 541) drh 2002-04-22 00:33:23 +00:00
  • e98d4fafe4 Fix for ticket #21 (I think): Do not return an "out of memory" error if we can not find the users home directory. Instead, just report that we could not find the home directory. (CVS 540) drh 2002-04-21 19:06:22 +00:00
  • 77155c480a Version 2.4.8 (CVS 538) drh 2002-04-20 14:45:31 +00:00
  • 57809db9c5 Update the change log for the 2.4.8 release. (CVS 539) drh 2002-04-20 14:44:01 +00:00
  • 0ac6589202 Fix for ticket #1: Implement the GLOB and LIKE operators as functions that can be overridden. This way, a developer can change the LIKE operator to be case sensitive, for example. (CVS 537) drh 2002-04-20 14:24:41 +00:00
  • 67505e78c6 Add support for saving the sqlite shell command-line history across sessions. (CVS 536) drh 2002-04-19 12:34:06 +00:00
  • c8cacb3704 Added rights release for Matthew O. Persico (CVS 535) persicom 2002-04-19 01:00:12 +00:00
  • dd45df8a5b Change shell.c so that it will compile under windows. Shorten the help command somewhat. Add the state of ".header" to the output of ".show". (CVS 534) drh 2002-04-18 12:39:03 +00:00
  • 45698a3a03 Updated to match new shell.c functionality. (CVS 533) persicom 2002-04-18 02:53:54 +00:00
  • 1d0b872d43 Mistake in help text. Spurious trailing whitespace removed. (CVS 532) persicom 2002-04-18 02:53:04 +00:00
  • 7e2dfdd726 General: o Added global static chars mainPrompt and continuePrompt. o Moved Argv0 declaration to head of file. Needed in do_meta_command, previously found below that. o Added struct previous_mode_data to support new .explain toggle functionality. o Added nullvalue, explainPrev and outfile members to struct callback_data. o Added modeDescr array for number/text translation ofdisplay modes. o Modified zHelp to match new functionality. persicom 2002-04-18 02:46:52 +00:00
  • a168045f7d Fix for ticket #19: Do not call sqliteOsSync() if the only changes were changes to TEMP tables. (CVS 530) drh 2002-04-18 01:56:57 +00:00
  • fc6cdfe9dc When doing a ".dump" command in the command-line shell, make sure VIEWs are created after TABLEs. (CVS 529) drh 2002-04-13 23:42:24 +00:00
  • 6b0e620fda Version 2.4.7 (CVS 528) drh 2002-04-12 13:12:25 +00:00
  • adbe353fc6 Add tests to prevent a recurrance of bug #16. Also: put a hyperlink to the new ticket screen on the main page of the website. (CVS 527) drh 2002-04-12 13:11:52 +00:00
  • c8d30ac109 Fix for bug #15: Add the sqlite_changes() API function for retrieving the number of rows that changed in the previous operation. (CVS 526) drh 2002-04-12 10:08:59 +00:00
  • b04a5d8768 Fix for bug #16: Check for invalid functions in the VALUES clause of an INSERT statement. (CVS 525) drh 2002-04-12 03:55:15 +00:00
  • feeb1394ee Fix for bug #11: Output the correct row count when and INSERT does an IGNORE action. (CVS 524) drh 2002-04-09 03:28:01 +00:00
  • fe1a1773a8 Fix for bug #10: Pop the stack by the right amount on an IGNORE so that the stack does not grow without bound. (CVS 523) drh 2002-04-09 03:15:06 +00:00
  • 8b32e17d26 Add a -column option to the sqlite command-line utility. Patch from Matthew O. Persico. (CVS 522) drh 2002-04-08 02:42:57 +00:00