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

Commit Graph

  • 428ae8cb41 Optimizations to the BTree module for a modest speed improvement. (CVS 810) drh 2003-01-04 16:48:09 +00:00
  • 2c79995565 Allow the rollback journal to be empty except for its header. Ticket #212. (CVS 809) drh 2003-01-03 02:04:27 +00:00
  • 8c1238aebd Code optimizations to help the library run faster. (CVS 808) drh 2003-01-02 14:43:55 +00:00
  • 7b39686749 If compiled with the -DVDBE_PROFILE=1 option, special code is inserted that uses the pentium RDTSC instruction to compute very precise runtimes on all VDBE opcodes. (This only works on i586 processors, of course.) The results are written into the vdbe_profile.out file for analysis. Hopefully, this new feature will reveal hot spots that can be optimized to make the VDBE run faster. (CVS 807) drh 2003-01-01 23:06:20 +00:00
  • c64e0ba45c Version 2.7.5 (CVS 806) version-2.7.5 drh 2002-12-28 01:26:07 +00:00
  • 919792ecb9 Update the version number to 2.7.5. (CVS 805) drh 2002-12-28 01:10:14 +00:00
  • 80eb79055e Fix an uninitialized variable in the pager. Tickets #208 and #206. Bug introduced by check-in (795). (CVS 804) drh 2002-12-28 01:06:30 +00:00
  • 5d1f0d4c89 Version 2.7.4 (CVS 803) version-2.7.4 drh 2002-12-17 22:50:45 +00:00
  • 3450e1d3c2 Preparing for the 2.7.4 release. (CVS 802) drh 2002-12-17 14:30:42 +00:00
  • f1337bb5ff If the "fake_big_file" command fails, be sure to close the file before returning. (CVS 801) drh 2002-12-17 14:19:49 +00:00
  • f33cb428e5 Make sure the host machine has enough disk space before running the large file tests. (CVS 800) drh 2002-12-17 14:13:48 +00:00
  • e7e8bc7739 Take care not to modify the sqlite* pointer to sqlite_exec() if we suspect that the pointer is stale - that it has previously been passed to sqlite_close(). Possible fix for ticket #202. Prior to this fix, test misuse-5.3 was causing a change to a buffer that had been previously free()-ed. (CVS 799) drh 2002-12-17 13:05:25 +00:00
  • 3e7a609667 Save the full pathname of the database file so that journalling still works even if the user changes working directories after opening the databae. Ticket #200. (CVS 798) drh 2002-12-07 21:45:14 +00:00
  • 1a844c380b Fix a bug in the reverse scan logic that comes up when the table being scanned is empty. Add additional tests for the reverse scan. (CVS 797) drh 2002-12-04 22:29:28 +00:00
  • dd4852c3d1 Fixes to the logic that decides if the ORDER BY can be ignored due to the use of an index. Tests updated. (CVS 796) drh 2002-12-04 21:50:16 +00:00
  • c045ec51be Scan the table backwards if there is an ORDER BY ... DESC clause that can be satisfied by an index. (CVS 795) drh 2002-12-04 20:01:06 +00:00
  • 2dcc9aa2a8 Add the sqliteBtreePrevious() routine to the BTree module API. This is in anticipation of implementing reverse order searching of a table. (CVS 794) drh 2002-12-04 13:40:25 +00:00
  • c66c5a266b Allow an aggregate function in the HAVING clause even if no aggregates appear in the result set. Ticket #187. (CVS 793) drh 2002-12-03 02:34:49 +00:00
  • 174b619591 Honor ORDER BY clauses in VIEWs. Ticket #193. (CVS 792) drh 2002-12-03 02:22:52 +00:00
  • da47d7748f Change to the pager to avoid opening journal files unnecessarily. This can sometimes results in a significant speed improvement. (CVS 791) drh 2002-12-02 04:25:19 +00:00
  • d0d006e29c Fixed large file support under Linux. I'm unable to test under Windows. Ticket #191. (CVS 790) drh 2002-12-01 02:00:57 +00:00
  • 86bc1c8273 Add the "space_used.tcl" script to the tools directory. This script is used to measure how much disk space is used by each table and index of a database. (CVS 789) drh 2002-11-24 14:52:27 +00:00
  • 58f391b36f Automatically determine if pointers are 4 or 8 bytes in size during the compilation process. Ticket #190. (CVS 788) drh 2002-11-20 11:55:18 +00:00
  • 7cdbd32c8e Get the new large file code working with the Borland compiler. Ticket #195. (CVS 787) drh 2002-11-20 11:07:59 +00:00
  • 7d686b2d57 Remove extra </TD> from HTML output. Ticket #189. (CVS 786) drh 2002-11-11 13:56:47 +00:00
  • 4d9ef4c4ef Back out the changes in the pager that sorted pages prior to writing them to the database. Additional measurements showed no performance gains. (CVS 785) drh 2002-11-11 01:04:47 +00:00
  • 32c05e993f Replace the atoi() library routine with a faster home-grown version in the VDBE. This gives a dramatic speed improvement for some kinds of queries. (CVS 784) drh 2002-11-11 00:05:42 +00:00
  • 03eb96a7b2 Two optimizations to the pager: (1) Write dirty pages back to the database file in order and (2) Keep a separate list of in-memory pages that are in the checkpoint journal in order to speed a checkpoint commit. (CVS 783) drh 2002-11-10 23:32:56 +00:00
  • 8766c34348 Try to better detect when the library is compiled for large file support (LFS) but the support is not available in the host OS kernel. (CVS 782) drh 2002-11-09 00:33:15 +00:00
  • 829e802992 Add large file support to Windows. Change large file support for Unix so that it compiles automatically - without requiring special options on the compiler command line. (CVS 781) drh 2002-11-06 14:08:11 +00:00
  • 20e9ab16d8 Changes to include files so that the >2GB file patch will compile under BSD. (CVS 780) drh 2002-11-06 00:59:44 +00:00
  • f87e9de4c4 Update the FAQ to explain how to enable large file support. (CVS 779) drh 2002-11-05 23:24:38 +00:00
  • 28be87c7c4 Add support for databases larger than 2GB under Unix. Must be compiled with -D_FILE_OFFSET_BITS=64 and -D_LARGEFILE_SOURCE in order to work with larger databases. (CVS 778) drh 2002-11-05 23:03:02 +00:00
  • 647cb0e159 Add the sqlite_version() SQL function as a built-in. (CVS 777) drh 2002-11-04 19:32:25 +00:00
  • 7bc09d3111 Improvements in threadtest.c (for Unix) and some minor bug fixes that result from the better testing. (CVS 776) drh 2002-11-01 01:55:36 +00:00
  • 194a7b6469 Version 2.7.3 (CVS 775) version-2.7.3 drh 2002-10-31 00:15:10 +00:00
  • 1f3e905cd0 Fix an assert that might fail if malloc() fails. (CVS 774) drh 2002-10-31 00:09:39 +00:00
  • bd1edfa321 Bump the version number prior to the release of version 2.7.3. (CVS 773) drh 2002-10-30 23:04:27 +00:00
  • 38dd0b4ff0 In the VDBE, check to make sure a set has been initialized before using it. Ticket #185. (CVS 772) drh 2002-10-30 22:42:58 +00:00
  • 1f16230b5c Minimal support for oracle8 outer join syntax. (CVS 771) drh 2002-10-27 19:35:33 +00:00
  • 6977fea801 Correctly handle column names and string constants in parentheses. Fix for ticket #179. (CVS 770) drh 2002-10-22 23:38:04 +00:00
  • e958bb4aef Take care to track ephemeral strings in the VDBE and make copies of ephemeral strings that need to be preserved. Ticket #177. (CVS 769) drh 2002-10-22 15:04:34 +00:00
  • edbbbdf8f7 Rework the changes for ticket #176 (check-ins (760) and (761)) to be more consistent with the rest of the source code. (CVS 768) drh 2002-10-20 18:19:45 +00:00
  • 3c2007a546 The "table_info" pragma reports unspecified column types as "numeric" instead of "text". Fix for ticket #174. (CVS 767) drh 2002-10-20 16:00:27 +00:00
  • 275ed72c9b Export the sqlite_function_type function from windows DLLs. Ticket #173. (CVS 766) drh 2002-10-20 15:55:01 +00:00
  • 315555ca50 Work around a bug in the Borland C compiler. Ticket #172. (CVS 765) drh 2002-10-20 15:53:03 +00:00
  • 2678058853 Make sure malloc(0) always returns NULL. Fix for ticket #171. (CVS 764) drh 2002-10-20 15:46:22 +00:00
  • 32fbe342db Speed improvement by avoiding a call to sqliteBtreeLast() when inserting a new row into a table. (CVS 763) drh 2002-10-19 20:16:37 +00:00
  • 906bf2a316 Fix the URL for pointing to MinGW on the homepage. (CVS 762) drh 2002-10-19 20:13:51 +00:00
  • 16aaf451b7 Minor coding fix in getting the windows platform version, when multithreading (CVS 761) mike 2002-10-17 09:01:31 +00:00
  • 710dcfbde5 fix for locking in Windows (CVS 760) mike 2002-10-17 00:38:54 +00:00
  • f1f0fa0769 Remove the call to srand() and add better comments to the sqliteOsRandomSeed() routine. Ticket #163. (CVS 759) drh 2002-10-12 13:43:59 +00:00
  • c8f8b632c3 Fix a bug in the left outer join logic. (CVS 758) drh 2002-09-30 12:36:26 +00:00
  • 294fb92b50 Fix an uninitialized variable that could cause problems when comparing two NULLs. (CVS 757) drh 2002-09-30 01:31:21 +00:00
  • c4ca897b9a Version 2.7.2 (CVS 756) version-2.7.2 drh 2002-09-25 19:50:17 +00:00
  • d042ddb31b Bump the version number to 2.7.2. (CVS 755) drh 2002-09-25 19:26:59 +00:00
  • a226d05408 Bug fix: When multiple SQL statements were passed into a single sqlite_exec() call, execution speed would decrease for each statement executed because VDBE cursors were not being reused. Now the cursors are reused and execution time is linear. (CVS 754) drh 2002-09-25 19:04:07 +00:00
  • df68f6b768 Make sure memory malloced() for structures is aligned on an even byte boundry. Solaris segfaults otherwise. (CVS 753) drh 2002-09-21 15:57:57 +00:00
  • 3e56c04c4e Fix a bug in the OP_MemStore operator of the VDBE. A realloc() might occur but pointer to the old buffer were not being moved over to the new buffer. (CVS 752) drh 2002-09-17 03:20:46 +00:00
  • 995d71b715 Modify the sqlite_encode_binary() routine to return the strlen() of the encoded string. Also fix a bug that occurs when attempting to encode a zero-length buffer. (CVS 751) drh 2002-09-16 11:44:05 +00:00
  • cabb081971 Do not put a write lock on the main database file when writing to a temporary table. (CVS 750) drh 2002-09-14 13:47:32 +00:00
  • 41a3bd0a01 Rename all tests so that the first part of the test name corresponds to the file that contains that test. This makes it much easier to find a particular test after it fail. (CVS 749) drh 2002-09-14 12:04:56 +00:00
  • 6eba16f3d7 Update the SQL language documentation to talk about SELECT DISTINCT. (CVS 748) drh 2002-09-12 14:08:32 +00:00
  • ac82fcf5f0 Fix for ticket #147: Honor the ORDER BY and LIMIT clauses in a SELECT even if the destination of that SELECT is a subroutine call. (CVS 747) drh 2002-09-08 17:23:41 +00:00
  • 85a1c4a609 Modify the build process so that the VDBE opcode numbers and the table that contains the opcode names are both automatically generated. This makes it much easier to create new VDBE opcodes. (CVS 1727) drh 2002-09-08 00:04:54 +00:00
  • 8f619ccd3c Modify the build process so that the VDBE opcode numbers and the table that contains the opcode names are both automatically generated. This makes it much easier to create new VDBE opcodes. (CVS 746) drh 2002-09-08 00:04:50 +00:00
  • 8c90ebb0e2 Fix a memory leak that occurred when sqlite_open() failed. (CVS 745) drh 2002-09-05 23:21:37 +00:00
  • 96ddd6db58 Rewind the checkpoint journal after each statement to avoid allowing the file to become too large. (CVS 744) drh 2002-09-05 19:10:33 +00:00
  • 4e371ee41c Fix for ticket #146: Correctly handle reads of unused disk blocks at the end of the file. (CVS 743) drh 2002-09-05 16:08:27 +00:00
  • b798fa6481 Always fill in the 5th parameter to sqlite_exec if there is an error. (CVS 742) drh 2002-09-03 19:43:23 +00:00
  • 96f4531077 Add documentation on NULL handling in SQLite versus other SQL database engines. (CVS 741) drh 2002-09-02 14:11:02 +00:00
  • 0e1cfb8574 Detect when the test scripts are being run as root and issue an appropriate error message. (CVS 740) drh 2002-09-02 12:14:50 +00:00
  • f74b8d9b89 Relax the locking requirements on BTree cursors. Any number of read and write cursors can be open at the same time now, but a write cannot occur as long as one or more read cursors are open. drh 2002-09-01 23:20:45 +00:00
  • c2eef3b32b Parse foreign key constraints and populate internal data structures appropriately. Constraints are still not enforced. (CVS 738) drh 2002-08-31 18:53:06 +00:00
  • b680a344e5 Version 2.7.1 (CVS 737) version-2.7.1 drh 2002-08-31 17:02:43 +00:00
  • 56cdb3b237 Change the version number for release 2.7.1. (CVS 736) drh 2002-08-31 17:02:25 +00:00
  • df01cdf9b0 Initial checking of two new test files: format3.test and memleak.test. (CVS 735) drh 2002-08-31 16:52:44 +00:00
  • b7dadd4d85 Fix for ticket #145: Include the func.c source file in the build of testfixture so that the "randstr()" function will be available. (CVS 734) drh 2002-08-31 16:33:25 +00:00
  • 1e0ccab9f0 If the database is locked when sqlite_open() is called, sqlite_exec() should still honor the busy callback and should return an error message together with the SQLITE_BUSY result code. (CVS 733) drh 2002-08-29 23:59:47 +00:00
  • 142e30df99 Slightly faster INSERTs from a SELECT by avoiding an intermediate table. But it didn't make nearly as much difference as I had hoped. (CVS 732) drh 2002-08-28 03:00:58 +00:00
  • 66105a8ea0 Change the tokenizer to ignore C-style comments /*...*/ in accordance with SQL99. (CVS 731) drh 2002-08-27 14:28:29 +00:00
  • da30d3696b Fix for ticket #142: Make sure we get the correct sort order even when the columns being sorted contain NULLs. (CVS 730) drh 2002-08-26 19:55:07 +00:00
  • d2df27e41d Version 2.7.0 (CVS 729) version-2.7.0 drh 2002-08-25 20:58:11 +00:00
  • 305f99a0fb Documentation updates prior to the releae of 2.7.0. (CVS 728) drh 2002-08-25 20:11:18 +00:00
  • 8c74a8ca5b Fix for ticket #136: Added the OP_RenameCursor VDBE instruction and used it to make cursor numbers right on nested subqueries. Also added OP_Gosub and OP_Return but have not actually used them for anything yet. (CVS 727) drh 2002-08-25 19:20:40 +00:00
  • d94a669894 Fix the memory leak introduced by check-in (725). (CVS 726) drh 2002-08-25 18:29:11 +00:00
  • 4b59ab5e64 Change the way token memory is allocated in an effort to fix ticket #136. There is now a memory leak when using views of views. (CVS 725) drh 2002-08-24 18:24:51 +00:00
  • 79983d03e8 Fix for ticket #138: Makefile doesn't use exec_prefix, has some install problems (CVS 724) jadams 2002-08-22 18:18:35 +00:00
  • bd842babb5 Fix for ticket #137: Use getpwuid() instead of getpwent(). (CVS 723) drh 2002-08-21 11:26:41 +00:00
  • f04d5081a7 This COLLATE keyword was not being parsed correctly inside CREATE TABLE statements - it was being included as part of the datatype. This fixes the problem. (CVS 722) drh 2002-08-18 22:41:22 +00:00
  • 6b8b8749d4 Fix for ticket #110: return an error if trying to start a transaction within a transaction or when attempting to commit or rollback outside of a transaction. (CVS 721) drh 2002-08-18 20:28:06 +00:00
  • d8acdb3c36 Documentation updates. (CVS 720) drh 2002-08-18 19:09:22 +00:00
  • cb48588297 Fix for ticket #135: Remove unused variables from three files. (CVS 719) drh 2002-08-15 13:50:48 +00:00
  • c277413089 More documentation updates. (CVS 718) drh 2002-08-15 13:45:17 +00:00
  • 310ae7be1e Additional test cases and documentation updates. (CVS 717) drh 2002-08-15 11:48:13 +00:00
  • 3d037a91a5 Fixes and test improvements resulting from code coverage testing. (CVS 716) drh 2002-08-15 01:26:09 +00:00
  • b27b83a941 Fix for ticket #134: Change the lemon.c sources to work around a problem with the AIX C compiler. (CVS 715) drh 2002-08-14 23:18:57 +00:00
  • d1efac52d5 Implement probabilistic reader/writer locks under windows so that windows can have multiple simultaneous readers. (CVS 714) drh 2002-08-14 12:56:54 +00:00
  • c330af1dca Disable sorting by indices if there is a COLLATE subclause in the ORDER BY clause. (CVS 713) drh 2002-08-14 03:03:57 +00:00
  • 0c44e2edf3 Fix for ticket #132: make the working directory the last choice for where to write temporary files, not the first choice. (CVS 712) drh 2002-08-14 00:10:44 +00:00