bahman/sqlite
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

Commit Graph

  • fbe4375cae Update documentation to better explain the typelessness of SQLite and to describe the distinction between text and numeric data. (CVS 711) drh 2002-08-14 00:08:12 +00:00
  • a9e99aee95 Make the distinction between text and numeric data. (CVS 710) drh 2002-08-13 23:02:57 +00:00
  • 76800328b2 Documentation and makefile updates. (CVS 709) drh 2002-08-13 20:45:39 +00:00
  • 72ca3794ab Bug fix to the left outer join logic. (CVS 708) drh 2002-08-13 13:15:51 +00:00
  • 7f09b3e36b Bug fix to the left outer join logic. (CVS 1726) drh 2002-08-13 13:15:49 +00:00
  • f8b593e964 Version 2.6.3 (CVS 707) version-2.6.3 drh 2002-08-13 00:02:10 +00:00
  • 74587e5567 Updates prior to release 2.6.3. (CVS 706) drh 2002-08-13 00:01:16 +00:00
  • 94f3331a0b Fix for ticket #9 (again). The rollback journal files should now also be byte-order independent. (CVS 705) drh 2002-08-12 12:29:56 +00:00
  • 0d316a40cc Fix for ticket #9: Add the ability to read little-endian database files from a big-endian machine and vice versa. (CVS 704) drh 2002-08-11 20:10:47 +00:00
  • 6e397e447e Fix typos the source to webpages html files. (CVS 703) drh 2002-08-06 12:04:59 +00:00
  • 68d2e5918a Fix for ticket #131: When a SELECT contains a GROUP BY clause it cannot use an index for sorting. It has to sort as a separate operation after the GROUP BY is complete. (CVS 702) drh 2002-08-04 00:52:38 +00:00
  • e0e5ef1471 Remove the restriction that a transaction cannot be started by one linuxthread and continued by another. Leave in the documentation the warning about not carrying a database connection across fork() but do not test for it any more. Ticket #130. (CVS 701) drh 2002-08-02 10:36:09 +00:00
  • f1351b6759 Fix for ticket #124: Fix a stack VDBE overflow problem on joins on an INTEGER PRIMARY KEY. (CVS 700) drh 2002-07-31 19:50:26 +00:00
  • 4eb9c6b9fd Version 2.6.2 (CVS 699) version-2.6.2 drh 2002-07-31 00:38:06 +00:00
  • 4dec5b40ec Update version number and change log for the 2.6.2 release. (CVS 698) drh 2002-07-31 00:37:36 +00:00
  • f573c99ba7 Fix for ticket #104: Make triggers on views work properly even after closing and reopening the database. Also fixed an unrelated bug in the version 2.6.0 database format upgrade logic. The upgrade logic bug was found while testing the trigger fixes. (CVS 697) drh 2002-07-31 00:32:50 +00:00
  • 92ed08a9d7 Fix for ticket #114: Correctly handle SQLITE_BUSY if it occurs during database initialization. (CVS 696) drh 2002-07-30 18:43:40 +00:00
  • c51d204464 Fix for ticket #111: Update the documentation to explain that you may not start a transaction in one thread and complete it in another thread under Linux Threads where each thread has its own process ID. (CVS 695) drh 2002-07-30 17:42:10 +00:00
  • 62160e798c Fix for ticket #71: Correctly handle CR and CRLF line terminators in the input files for the COPY command. (CVS 694) drh 2002-07-30 17:20:40 +00:00
  • 368c7f6df1 UPDATE triggers on TEMP tables were broken. (CVS 693) danielk1977 2002-07-21 23:09:55 +00:00
  • 77fc55904e Version 2.6.1 (CVS 691) version-2.6.1 drh 2002-07-19 19:04:04 +00:00
  • 096c497eb3 Rig the ident string so that it is not changed by RCS on checkin. (CVS 692) drh 2002-07-19 19:03:41 +00:00
  • 26b3e1bc06 Fix an assertion failure that occurs when attempting to delete all rows of a table while the "count_changes" pragma is turned on. Up the version number to 2.6.1. (CVS 690) drh 2002-07-19 18:52:40 +00:00
  • 426cc56a6b Add static ident strings (such as picked up by the RCS "ident" command) containing the library version number. (CVS 689) drh 2002-07-19 18:13:35 +00:00
  • c231172f3f Better detection and reporting of errors when initializing from the sqlite_master table. (CVS 688) drh 2002-07-19 17:46:38 +00:00
  • b782325617 Version 2.6.0 Release 2 (CVS 687) version-2.6.0 drh 2002-07-18 11:10:30 +00:00
  • ac729e224e Fix a bug in the publish.sh script that was causing the windows DLL to not be built. (CVS 686) drh 2002-07-18 11:07:19 +00:00
  • 199e3cf1b6 Change the name of variable "near" to "nearby" since MSVC mistakenly belieaves that "near" is a keyword. (CVS 685) drh 2002-07-18 11:01:47 +00:00
  • bd44700073 Version 2.6.0 Release 1 (CVS 684) drh 2002-07-18 02:50:51 +00:00
  • 3c2c354e0e Update documentation prior to the release of 2.6.0. (CVS 683) drh 2002-07-18 02:07:07 +00:00
  • 8e5ba84643 Make the automatic database upgrade work even if there are triggers. Add tests for automatic upgrade and for failing if reading a more advanced version of the database. Ticket #107. (CVS 682) drh 2002-07-18 01:27:17 +00:00
  • 491791a827 Fix for ticket #107: Fix a design defect in indices that was causing queries to fail when using an index on a column containing an empty string. This fix is an incompatible file-format change. (CVS 681) drh 2002-07-18 00:34:09 +00:00
  • 53e3fc70bf Fix for ticket #105: Fix the UPDATE command so that it works properly with indexed tables when there is a subquery in the WHERE clause. Add tests to verify correct operation. (CVS 680) drh 2002-07-16 17:22:50 +00:00
  • 0c36cbe0c2 Fix for ticket #100: Correctly handle ON and USING clauses of JOINs within a VIEW. (CVS 679) drh 2002-07-16 02:05:43 +00:00
  • 704027f16d Fix a syntax error in the tclsqlite.c file. (CVS 678) drh 2002-07-15 20:58:47 +00:00
  • ad16844f35 Fix for ticket #102: Honor the ORDER BY clause in subqueries. (CVS 677) drh 2002-07-15 18:55:24 +00:00
  • 7f953e2052 Fix for ticket #64: Better error reporting in the shell. (CVS 676) drh 2002-07-13 17:33:45 +00:00
  • 70562cd342 Partial fix for ticket #96: Return SQLITE_MISUSE from sqlite_exec() if called from a child process with an active transaction that was started in the parent. (CVS 675) drh 2002-07-13 17:23:21 +00:00
  • 289f6c2336 Fix for ticket #99: Added documentation on the sqlite_mprintf() API. (CVS 674) drh 2002-07-13 17:18:36 +00:00
  • 674d712126 Added a document describing how to do a security audit. (CVS 673) drh 2002-07-13 16:52:35 +00:00
  • 25197f4835 Fix for ticket #54: Export additional APIs to the Win32 DLL. (CVS 672) drh 2002-07-13 14:41:49 +00:00
  • 485b39b401 Fix for ticket #95: Do not allow automatically created indices (associated with UNIQUE or PRIMARY KEY constraints) to be dropped. (CVS 671) drh 2002-07-13 03:11:52 +00:00
  • 5080aaa7ab Turn of the reporting of datatypes in the 4th callback argument unless the SHOW_DATATYPES pragma is ON. Eliminate the NULL pointer that used to separate the beginning of datatypes from the end of column names so that the callback can test to see whether or not datatypes are provided. This is an incompatible changes, but since the prior behavior was never documented, we will let it in. (CVS 670) drh 2002-07-11 12:18:16 +00:00
  • fa173a764a When reporting back the datatype of columns, use the text of the datatype as it appears in the CREATE TABLE statement, if available. Also: removed the ".reindex" command from the shell. (CVS 669) drh 2002-07-10 21:26:00 +00:00
  • 6276c1cbf0 Add support for TEMPORARY views. The code is here but it is mostly untested. (CVS 668) drh 2002-07-08 22:03:32 +00:00
  • bea00b9a2b In the BTree subsystem, when using pages from the freelist, attempt to select pages close to related pages in order to keep data structures near each other in the database file. This improves access speed in some circumstances. (CVS 667) drh 2002-07-08 10:59:50 +00:00
  • 6b30867ff6 Make the BTree balance() routine a little faster by reusing database pages locally rather than freeing and reallocating them. (CVS 666) drh 2002-07-08 02:16:37 +00:00
  • 6f08d709b1 Version 2.5.6 (CVS 664) version-2.5.6 drh 2002-07-07 17:13:00 +00:00
  • 5e5377fb80 Fix for Win32: The %p format on Win32 does not prepend a "0x" as it should. (CVS 665) drh 2002-07-07 17:12:36 +00:00
  • 193a6b4142 More rollback problems: Fix two more errors introduced by checking (410) that can cause database corruption after a ROLLBACK. Also add new tests to make sure everything is working this time. (CVS 663) drh 2002-07-07 16:52:46 +00:00
  • af1c9661a4 Version 2.5.5 (CVS 662) version-2.5.5 drh 2002-07-06 16:34:20 +00:00
  • 0de8c11292 Prepare for the 2.5.5 release. (CVS 661) drh 2002-07-06 16:32:14 +00:00
  • 8e298f92f6 Fix for bug #94: Be sure to journal pages that are added to the freelist then removed from the freelist and reused during the same transaction. (CVS 660) drh 2002-07-06 16:28:47 +00:00
  • 38640e15af All the code is now in place for SQLite to distinguish between NUMERIC and TEXT datatypes. Still need to turn on the new code and test it. (CVS 659) drh 2002-07-05 21:42:36 +00:00
  • 2f2c01e51d Fix for ticket #92: Correct the sqliteExprCompare() function so that is takes into account the iTable and iColumn fields of the Expr structure. Otherwise, "min(a)" and "min(b)" will compare equal to each other in views. (CVS 658) drh 2002-07-02 13:05:04 +00:00
  • 1f66c57a9c Fix for ticket 91: Modify the "publish.sh" script to use the new mingw cross-compiler installed on the development platform. (CVS 657) drh 2002-07-02 11:55:32 +00:00
  • ea1c936a1e Version 2.5.4 (CVS 656) version-2.5.4 drh 2002-07-01 12:35:51 +00:00
  • a4db7ee12d Update the change log and the version number for the next release. (CVS 655) drh 2002-07-01 12:34:36 +00:00
  • 5ad1a6c8c4 Fix for tickets #90 and #89: Make the AS keyword optional again. (CVS 654) drh 2002-07-01 12:27:09 +00:00
  • 6cbe1f1bc4 Added additional tests. No new errors found. (CVS 653) drh 2002-07-01 00:31:36 +00:00
  • a9f9d1c08b Add a few more tests and fix a few bugs that the tests uncovered. (CVS 652) drh 2002-06-29 02:20:08 +00:00
  • 3b167c7583 Additional test cases added. The following bug fixed: A segfault was occurring if a VIEW consisted of a join with a USING clause. (CVS 651) drh 2002-06-28 12:18:47 +00:00
  • 83dcb1ad37 Fix for ticket #84: If the WHERE clause is too complex, issue an error message and refuse to do the SELECT. The cutoff is a WHERE clause with 100 terms. (CVS 650) drh 2002-06-28 01:02:38 +00:00
  • ac83f718fc Fix for ticket #88: A typo in the documention of the "sqlite" shell command. (CVS 649) drh 2002-06-27 13:21:01 +00:00
  • 06b2718a5f In the TCL interface, the "sqlite" command now always returns the address of the "sqlite*" pointer that sqlite_open() returns. It used to do this only when compiled with the SQLITE_TEST macro defined. (CVS 648) drh 2002-06-26 20:06:05 +00:00
  • b13632063d The datatype of the i-th column in the result set is given by the azColName(argc+1+i) parameter to the callback. (CVS 647) drh 2002-06-26 02:45:03 +00:00
  • 411995dc0d Add the sqlite_open_aux_file() API. (CVS 646) drh 2002-06-25 19:31:18 +00:00
  • e3c163e4e0 Version 2.5.3 (CVS 645) version-2.5.3 drh 2002-06-25 15:19:02 +00:00
  • ee6bfdf99c Fix a spelling error in the change log. (CVS 644) drh 2002-06-25 14:46:58 +00:00
  • 8124a30f82 Bug fix: When the database file grows in size during a transaction, make sure the last page of the file gets written to disk even if that page is on the free list and contains no data. Otherwise the disk file will be too small which can lead to database corruption in subsequent transactions. (CVS 643) drh 2002-06-25 14:43:57 +00:00
  • 2150432e7c Enhance the INTEGRITY_CHECK pragma to test the auxiliary database file in addition to the main database file. (CVS 642) drh 2002-06-25 13:16:02 +00:00
  • 90c0bb0b07 Version 2.5.2 (CVS 641) version-2.5.2 drh 2002-06-25 01:09:30 +00:00
  • e0bc4048a0 Added support for the "sqlite_temp_master" table. Increased the version number to 2.5.2. (CVS 640) drh 2002-06-25 01:09:11 +00:00
  • 1cc093c2b5 Partial fix for a problem with LEFT OUTER JOIN. It used to be that the test for the right-hand table not matching the left table occurred after all ON, USING, WHERE clause processing. The test should occur after ON and USING clauses are checked but before the WHERE clause is check. This fix works as long as the total number of "AND" separated terms in the ON, USING, and WHERE clause does not exceed 32. To do: make this work for any number of terms and add test cases. that (CVS 639) drh 2002-06-24 22:01:57 +00:00
  • bf5cd97ed7 Fix a VDBE stack leak in LEFT OUTER JOIN. Fix a bug in the code generator for JOIN ... USING(...). (CVS 638) drh 2002-06-24 12:20:23 +00:00
  • f46f905a1e An optimization: avoid the use of an intermediate table on UNION ALL if there is no ORDER BY clause. (CVS 637) drh 2002-06-22 02:33:38 +00:00
  • d11d382c99 Fix for bugs #77 and #80: Rework the LIMIT mechanism to be reentrant and to clean up the VDBE stack properly. (CVS 636) drh 2002-06-21 23:01:49 +00:00
  • 7aa128dbc5 Fix for ticket #76: Fix a database corruption that might occur when dropping tables or indices. (CVS 635) drh 2002-06-21 13:09:16 +00:00
  • bb3a6dbd2e Fix for ticket #78: Avoid an assertion failure when sqlite_close() to be called in the middle of a transaction. (CVS 634) drh 2002-06-21 11:55:48 +00:00
  • ef1360635c Update the file-format change document to describes the changes between versions 2.4.12 and 2.5.0. (CVS 633) drh 2002-06-20 11:41:58 +00:00
  • c9b84a1fb1 This patch contains the beginnings of the data-typing infrastructure. The new build-in TypeOf() function is added. New opcodes for doing pure text comparisons are added. Most changes are disabled pending the 2.6.0 release. (CVS 632) drh 2002-06-20 11:36:48 +00:00
  • c926afbc2d Fix for ticket #73: The ORDER BY clause is significant for subqueries. This passes all regression tests, but more testing is needed to exercise all paths through the new code. (CVS 631) drh 2002-06-20 03:38:26 +00:00
  • 27a32783ab Fix for ticket #75: Autoincrement INTEGER PRIMARY KEY fields on an INSERT even if the data is coming from a SELECT statement. (CVS 630) drh 2002-06-19 20:32:43 +00:00
  • 9bc542e999 Version 2.5.1 (CVS 629) version-2.5.1 drh 2002-06-19 14:27:22 +00:00
  • e31847449e The query optimizer now attempts to satisfy an ORDER BY clause using an index. Sorting is still used if there are no suitable indices. (CVS 628) drh 2002-06-19 14:27:05 +00:00
  • c2bb7c3dd9 Version 2.5.0 (CVS 627) version-2.5.0 drh 2002-06-17 17:26:38 +00:00
  • af33486ebb Update the change summary for version 2.5.0 (CVS 626) drh 2002-06-17 17:15:46 +00:00
  • 8e2ca029a3 Add preliminary logic for the eventual move to having separate TEXT and NUMTEXT datatypes. Also change the version number to 2.5.0 in preparation for an interim release. (CVS 625) drh 2002-06-17 17:07:19 +00:00
  • e0140fc13a Expose an additional internal API routine (sqliteInitCallback()) for use by private code. (CVS 624) drh 2002-06-16 18:21:44 +00:00
  • 4d60361fe3 Added explanation and examples for %Q format specifier. (CVS 623) chw 2002-06-16 04:57:32 +00:00
  • b22f1b58ac Added printf-4.(2-4) test cases to test new %Q format specifier. (CVS 622) chw 2002-06-16 04:56:36 +00:00
  • 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