Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
509 check-ins using file test/null.test version 5c2b57307e
2003-09-23
| ||
10:25 | A failed malloc() could have resulted in a segfault. Fixed by this check-in. (CVS 1102) (check-in: 4bb256ee3e user: drh tags: trunk) | |
00:36 | allow -enable-releasemode as an option and allow Makefile to produce version independent binary like libsqlite-2.8.6.so instead of libsqlite.so.0.0.0 (CVS 1101) (check-in: 4fdd44a5ee user: xdong tags: trunk) | |
00:35 | regenerate configure to take -enalbe-releasemode as an option (CVS 1100) (check-in: b85847b8f2 user: xdong tags: trunk) | |
2003-09-18
| ||
21:59 | modify the configure file to allow cross-compile to work at arm and xscale (CVS 1099) (check-in: 760f2fa2e5 user: xdong tags: trunk) | |
2003-09-12
| ||
02:08 | The tokenizer should never return a negative size of the next token. Ticket #453. (CVS 1098) (check-in: 4fbca3ab09 user: drh tags: trunk) | |
2003-09-09
| ||
00:47 | Add test cases that check out sqlite_get_table() on queries with results sets containing 100 columns. (CVS 1097) (check-in: f9feedec32 user: drh tags: trunk) | |
2003-09-06
| ||
22:45 | Add initial test cases for the new sqlite_bind() API. Fix bugs that the new test cases found. (CVS 1096) (check-in: f6c4908e9b user: drh tags: trunk) | |
22:18 | Update Makefile.in for the new vdbeaux.c file. Remove the experimental "sqlite_instantiate()" routine and replace it with "sqlite_bind()" which is more like ODBC and JDBC. (CVS 1095) (check-in: 990bb11898 user: drh tags: trunk) | |
20:12 | Split almost 1300 lines of code out of vdbe.c into separate files vdbeInt.h and vdbeaux.c. (CVS 1094) (check-in: bfd69391d3 user: drh tags: trunk) | |
01:10 | The beginnings of changes to support pre-compiled SQL. Mostly untested, though all regression tests to pass. (CVS 1093) (check-in: 912f47c72d user: drh tags: trunk) | |
2003-09-02
| ||
15:26 | Add a logo from Rasmus Schultz. (CVS 1092) (check-in: aaa84c6202 user: drh tags: trunk) | |
2003-08-27
| ||
22:57 | CVS missed a commit (because I pressed Ctrl-C in the middle). This extra commit will hopefully help clear things up. (CVS 1091) (check-in: 522c2efeb5 user: drh tags: trunk) | |
22:54 | Add locks to the in-memory backend so that recursive writes will be detected and rejected. Ticket #436. (CVS 1089) (check-in: 3403d28a49 user: drh tags: trunk) | |
22:52 | Add locks to the in-memory database so that recursive writes will be detected and rejected. Ticket #436. (CVS 1090) (check-in: 966b1a16f6 user: drh tags: trunk) | |
2003-08-26
| ||
11:41 | Fix compiler warnings under OpenVMS. Ticket #357. (CVS 1088) (check-in: c95f347cac user: drh tags: trunk) | |
11:35 | Try to work around a bug in VC++ by only passing unsigned characters to the isspace() routine. Bug reported on the mailing list. (CVS 1087) (check-in: cbe3221696 user: drh tags: trunk) | |
11:29 | Fix a bug in sqliteRealloc() that only occurs if there is memory corruption and debugging is enabled. Ticket #421. (CVS 1086) (check-in: eebc82b77d user: drh tags: trunk) | |
11:25 | If the database filename is an empty string, open a temporary file to hold the database. Ticket #432. (CVS 1085) (check-in: da53369f0b user: drh tags: trunk) | |
11:18 | Close files before deleting them on test scripts under Win2k. Ticket #434. (CVS 1084) (check-in: 2a40b46140 user: drh tags: trunk) | |
10:38 | Remove extra backslashes from end of lines in the install target of the Makefile. Ticket #435. (CVS 1083) (check-in: 1aa3658ef5 user: drh tags: trunk) | |
2003-08-24
| ||
16:38 | Fix a bug in the new "pk" column of the table_info pragma that was added by check-in (1081). (CVS 1082) (check-in: ad7b017a12 user: drh tags: trunk) | |
2003-08-23
| ||
22:40 | Add a "pk" column to the table_info pragma which is true for each column that is part of the primary key. Add a "foreign_key_list" pragma that gives information about all foreign keys for a table. Both changes are experimental. (CVS 1081) (check-in: 5232b0665b user: drh tags: trunk) | |
2003-08-22
| ||
03:00 | Version 2.8.6 (CVS 1080) (check-in: 0bde7ae2ba user: drh tags: trunk) | |
02:34 | Change the CVSTrac website to www.sqlite.org. Update change summary for the 2.8.6 release. (CVS 1079) (check-in: a4e3e075e3 user: drh tags: trunk) | |
2003-08-21
| ||
14:36 | Update the -version-info number on libtool in Makefile.in. (CVS 1078) (check-in: dc36365eea user: drh tags: trunk) | |
2003-08-20
| ||
01:03 | Add the experimental "quote()" function to the set of build-in functions. (CVS 1077) (check-in: 9699c68508 user: drh tags: trunk) | |
2003-08-19
| ||
14:31 | Add the "onecolumn" method to the TCL language bindings. (CVS 1076) (check-in: c7b4c28fbc user: drh tags: trunk) | |
2003-08-16
| ||
13:10 | Make the compile work under cygwin. Tickets #327, #213, #316, #322, #349, #373, and #429. (CVS 1075) (check-in: 7d8d3252df user: drh tags: trunk) | |
12:37 | Do not delete tables with the same name when dropping triggers. Ticket #430. (CVS 1074) (check-in: ef58f163b0 user: drh tags: trunk) | |
2003-08-15
| ||
13:24 | Fix a segfault that occurs in the VACUUM command if run on an empty database with the EMPTY_RESULT_CALLBACKS pragma enabled. Ticket #427. (CVS 1073) (check-in: 3563e9cf9d user: drh tags: trunk) | |
2003-08-13
| ||
11:29 | Update the NULL-handling chart with new information about Firebird. (CVS 1072) (check-in: 17bdfeb284 user: drh tags: trunk) | |
2003-08-10
| ||
16:16 | Make the sqliteOsCurrentTime() function work for Windows. Code contributed by "e4liberty" on the mailing list. (CVS 1071) (check-in: 02fac304c9 user: drh tags: trunk) | |
01:50 | tighter coding of the date and time functions. Better comments. A bug fix. (CVS 1070) (check-in: 94243edac1 user: drh tags: trunk) | |
2003-08-09
| ||
21:32 | Add experimental date and time functions based on julian day number. (CVS 1069) (check-in: a6197e2075 user: drh tags: trunk) | |
2003-08-05
| ||
13:13 | Provide a more informative error message when a uniqueness constraint fails. Ticket #419. (CVS 1068) (check-in: 086aa1c992 user: drh tags: trunk) | |
2003-07-30
| ||
12:34 | The {quote: SrcList} object was not being expanded correctly by a call to sqliteSrcListAppend() if the {quote: SrcList} had previously been duplicated by a call to sqliteSrcListDup(). Ticket #416. This check-in fixes that problem by keeping a separate nAlloc field on {quote: SrcList}. A similar change is made to {quote: IdList} and {quote: ExprList} to avoid future problems. (CVS 1067) (check-in: da62732554 user: drh tags: trunk) | |
2003-07-27
| ||
18:59 | When creating a new journal file, open a (read-only) file descriptor on the directory containing the journal and sync that directory once to make sure that the journal filename entry gets into the directory. Ticket #410. (CVS 1066) (check-in: 09c10fe3c9 user: drh tags: trunk) | |
17:26 | Make sure the schema loader callback can handle EMPTY_RESULT_CALLBACKS being on. Ticket #406. (CVS 1065) (check-in: 8c163fc0c7 user: drh tags: trunk) | |
17:16 | In the VDBE, when an integer value will not fit into a 32-bit int, store it in a double instead. Ticket #408. (CVS 1064) (check-in: 7514c3db16 user: drh tags: trunk) | |
2003-07-22
| ||
13:20 | Version 2.8.5 (CVS 1063) (check-in: 95fba440e7 user: drh tags: trunk) | |
12:44 | Fix a typo in the index.html homepage. (CVS 1062) (check-in: 510761cf50 user: drh tags: trunk) | |
12:41 | Increment the version number and update the documentation in preparation for the 2.8.5 release. (CVS 1061) (check-in: c2115335de user: drh tags: trunk) | |
09:24 | Add experimental sqlite_reset() API (allows pre-compiled queries) (CVS 1060) (check-in: 1d2fcb0178 user: danielk1977 tags: trunk) | |
00:39 | Make sure temporary file names in windows have a full 15 characters of random text at the end. (CVS 1059) (check-in: 6ccb92b14f user: drh tags: trunk) | |
2003-07-20
| ||
01:16 | Fix the LIMIT clause so that it applies to the entire query in a compound query. Prior to this change LIMITs on compound queries did not work at all. Ticket #393. (CVS 1058) (check-in: 543479e3ae user: drh tags: trunk) | |
2003-07-19
| ||
00:44 | Make sure the min() and max() optimizer works correctly when there is a LIMIT clause. Ticket #396. (CVS 1057) (check-in: c35e507176 user: drh tags: trunk) | |
2003-07-18
| ||
01:30 | In the sqlite shell, change the name of function getline() to local_getline() to avoid a clash with a library function. Ticket #400. (CVS 1056) (check-in: 558969ee86 user: drh tags: trunk) | |
01:25 | In the test scripts, do not try to delete files that are still open. Windows does not like it when you do. Ticket #397. (CVS 1055) (check-in: 93a2c961b1 user: drh tags: trunk) | |
2003-07-16
| ||
17:10 | Fix typo on the homepage. (CVS 1054) (check-in: c74107d63a user: drh tags: trunk) | |
11:51 | Make LIMIT 0 return no rows. LIMIT -1 still returns all rows. Ticket #346. (CVS 1053) (check-in: a31d0bd90a user: drh tags: trunk) | |
02:19 | Allow negative values for LIMIT and OFFSET. Add tests for negative LIMITs and OFFSETs. Make the OFFSET work even if LIMIT is 0 or negative. (CVS 1052) (check-in: e6a752bfef user: drh tags: trunk) | |
00:54 | Initialize a variable to prevent an MSVC compiler warning. Ticket #394. (CVS 1051) (check-in: 96e3c53958 user: drh tags: trunk) | |
2003-07-09
| ||
16:34 | An an extra test associated with ticket #387. (CVS 1050) (check-in: 6a07ac3782 user: drh tags: trunk) | |
00:28 | Allow the output arguments in sqlite_compile and sqlite_step to be NULL pointers. Tickets #384 and #385. (CVS 1049) (check-in: dd84f88f6c user: drh tags: trunk) | |
2003-07-08
| ||
23:42 | Enhance the C/C++ documentation to clarify the meaning of the return value from sqlite_changes(). Ticket #383. (CVS 1048) (check-in: 303b2da1ac user: drh tags: trunk) | |
2003-07-07
| ||
10:47 | A proported fix for ticket #374. (CVS 1047) (check-in: a49ee69e98 user: drh tags: trunk) | |
00:10 | Update the NULL-handling document to show current behavior of OCELOT. (CVS 1046) (check-in: 1d4c92c732 user: drh tags: trunk) | |
2003-07-06
| ||
17:22 | Correctly handle comparing an INTEGER PRIMARY KEY against a floating point number. Ticket #377. (CVS 1045) (check-in: 982aa3356b user: drh tags: trunk) | |
2003-07-01
| ||
18:13 | Make sure indices in ATTACH-ed databases are put into the right hash table. Ticket #354. (CVS 1044) (check-in: eb4582831d user: drh tags: trunk) | |
01:16 | Update the null-handling document to show how SQL Anywhere and Borland Interbase deal with NULLs. (CVS 1043) (check-in: 9a87f2f326 user: drh tags: trunk) | |
2003-06-30
| ||
10:36 | Documentation change: refer users to the wiki for additional unsupported features rather than have them send me e-mail. (CVS 1042) (check-in: a3920b0804 user: drh tags: trunk) | |
2003-06-29
| ||
20:45 | Version 2.8.4 (CVS 1041) (check-in: 7f5e8894ae user: drh tags: trunk) | |
20:25 | The prior fix of ticket #360 was incorrect and caused a memory leak. This check-in plugs the memory leak and correctly fixes ticket #360. (CVS 1040) (check-in: fc490f677b user: drh tags: trunk) | |
18:29 | Fix a bad memory leak in the in-memory database module. (CVS 1039) (check-in: 9cca959378 user: drh tags: trunk) | |
16:16 | Bump the version number in preparation for the next release. (CVS 1038) (check-in: 0532e1a8f5 user: drh tags: trunk) | |
16:11 | Documentation updates. (CVS 1037) (check-in: ab21de5fdd user: drh tags: trunk) | |
2003-06-28
| ||
16:25 | Minor change to a comment in encode.c. (CVS 1036) (check-in: 3f252b72c9 user: drh tags: trunk) | |
16:20 | Fix a bug in the soundex() code. Ticket #367. Add tests for ticket #261 even thought the problem could not be reproduced. (CVS 1035) (check-in: e2ca936fee user: drh tags: trunk) | |
2003-06-24
| ||
10:39 | In a SELECT, the rowid of a view or subquery which is really a join is set to NULL if the join is flattened. Ticket #364. (CVS 1034) (check-in: bad8b55833 user: drh tags: trunk) | |
2003-06-23
| ||
15:15 | Remove a surplus "return" statement accidentaly left in check-in (1032). (CVS 1033) (check-in: c697410af4 user: drh tags: trunk) | |
11:06 | Remove all references to SQLITE_OMIT_TRACE. Tracing is always enabled. Ticket #361. (CVS 1032) (check-in: ec31a5292c user: drh tags: trunk) | |
2003-06-22
| ||
01:41 | Make sure the source of a PULL opcode is not an ephemeral string. Ticket #360. (CVS 1031) (check-in: cb70ee67ea user: drh tags: trunk) | |
2003-06-17
| ||
02:57 | Remove unused variable. Ticket #355. (CVS 1030) (check-in: 5228cecdb8 user: drh tags: trunk) | |
2003-06-16
| ||
19:18 | Fix compiler errors and warnings win SQLITE_OMIT_AUTHORIZATION is defined. Ticket #353. (CVS 1029) (check-in: 6920b633c2 user: drh tags: trunk) | |
03:08 | Add the %z format to the sqlite_mprintf() and related functions. (CVS 1028) (check-in: eca1398eaa user: drh tags: trunk) | |
00:40 | Do not flatten a subquery which is the right term of a LEFT OUTER JOIN if the subquery contains a WHERE clause. Ticket #350. (CVS 1027) (check-in: dd8943e858 user: drh tags: trunk) | |
00:16 | Preserve blank lines in the middle of SQL statements in the shell. Ticket #352 (CVS 1026) (check-in: bcf5eeecdf user: drh tags: trunk) | |
2003-06-15
| ||
23:49 | Update the documentation to reflect the new capabilities of PRAGMA integrity_check. Rewording in the VACUUM documentation. (CVS 1025) (check-in: 38461a7acb user: drh tags: trunk) | |
23:42 | Enhance the "PRAGMA integrity_check" command to verify that all indices are correctly constructed. New calls to integrity_check are made in the test suite. These changes are intended to prevent any future problems such as seen in ticket #334. (CVS 1024) (check-in: c9734c2707 user: drh tags: trunk) | |
10:35 | Updated sqlite_encode_binary() comments with tighter bounds on output length. (CVS 1023) (check-in: 826aab43d5 user: jplyon tags: trunk) | |
10:29 | Documented integer values used by PRAGMAs. Fixed missing end tags in generated anchors. (CVS 1022) (check-in: 6c24dfbae5 user: jplyon tags: trunk) | |
2003-06-14
| ||
19:29 | * Added -version-info to shared libraries * Remove config.h and libtool in the distclean target (CVS 1021) (check-in: e13e8b05b4 user: a.rottmann tags: trunk) | |
12:04 | Bug fix: sqliteFree() called twice on the same allocation during error handling in attach.c. (CVS 1020) (check-in: 9ec40935b9 user: drh tags: trunk) | |
11:42 | Open the journal file for read-only when doing a playback. Ticket #351. (CVS 1019) (check-in: 66ac7aea3d user: drh tags: trunk) | |
2003-06-12
| ||
08:59 | Added missing error string to sqlite_error_string(). (CVS 1018) (check-in: 3afb7b3586 user: jplyon tags: trunk) | |
2003-06-10
| ||
02:46 | Suppress the warning message about print_node() being unused in btree_rb.c. Ticket #347. (CVS 1017) (check-in: b52f07e1c8 user: drh tags: trunk) | |
2003-06-09
| ||
11:53 | Remove redundant "return" statement from btree_rb.c. (CVS 1016) (check-in: 373d077173 user: drh tags: trunk) | |
2003-06-08
| ||
08:36 | Documented SQL fns IFNULL() and NULLIF(). (CVS 1015) (check-in: 190252fee0 user: jplyon tags: trunk) | |
2003-06-07
| ||
11:33 | Use sqliteOsFileExists() in the debugging hook in vdbe.c, instead of access(). Ticket #341. (CVS 1014) (check-in: 7d3405b95b user: drh tags: trunk) | |
11:29 | Do not assume that a pointer can fit in a long inside the printf() code. Ticket #342. (CVS 1013) (check-in: 5dad7c05e9 user: drh tags: trunk) | |
08:57 | Major update of vdbe tutorial to 2.8.0 engine. (CVS 1012) (check-in: 787d986d0f user: jplyon tags: trunk) | |
08:56 | Hyperlinks and minor additions/corrections for lang.tcl (CVS 1011) (check-in: 685a179aae user: jplyon tags: trunk) | |
2003-06-06
| ||
19:00 | Extend the authorization mechanism to disallow the ATTACH and DETACH commands. Ticket #340. (CVS 1010) (check-in: a97dca73ae user: drh tags: trunk) | |
16:13 | Add btree_rb.c and opcodes.c to the source built by the "target_source" target of the main makefile. (CVS 1009) (check-in: 0954697299 user: drh tags: trunk) | |
15:44 | Add a prototype for the sqlite_vmprintf() function to sqlite.h. (CVS 1008) (check-in: 048cf55c7d user: drh tags: trunk) | |
2003-06-05
| ||
15:05 | Fix a typo in speed.html. (CVS 1007) (check-in: d01e6fbdde user: drh tags: trunk) | |
14:27 | Remove unused code from util.c. (CVS 1006) (check-in: 1bcaa841a3 user: drh tags: trunk) | |
2003-06-04
| ||
16:24 | Fix a bug in UPDATE OR REPLACE that was introduced by check-in (999). Also clean up some compiler warnings for VC++. (CVS 1005) (check-in: af6f2bdf59 user: drh tags: trunk) | |
15:53 | Adjust test cases to cope with the extra column returned by the database_list pragma. (CVS 1004) (check-in: fa10c6df5a user: drh tags: trunk) | |
15:48 | Change the "database_list" pragma to return a third column containing the filename of the underlying database file. Always use an in-memory TEMP database with an in-memory main database. (CVS 1003) (check-in: f39100f575 user: drh tags: trunk) | |
12:44 | Version 2.8.3 (CVS 1002) (check-in: 433570e3e6 user: drh tags: trunk) | |
12:40 | Update the version number to 2.8.3. (CVS 1001) (check-in: c96f5bf0d7 user: drh tags: trunk) | |
12:31 | Disable the unreadable file test (attach-6.2) under windows because of problems in the OS. (CVS 1000) (check-in: 4bfb30d20b user: drh tags: trunk) | |
12:23 | Avoid corrupting indices when doing a REPLACE on a table with an INTEGER PRIMARY KEY that also has another index. Ticket #334. (CVS 999) (check-in: e813faae0e user: drh tags: trunk) | |
2003-06-03
| ||
01:47 | Additional testing of the ATTACH command with bug fixes for the new problems that the tests found. (CVS 998) (check-in: 3e8889d7ce user: drh tags: trunk) | |
2003-06-02
| ||
23:14 | The OP_Checkpoint opcode is now a no-op if invoked on a database that already has an active checkpoint journal. Ticket #333. (CVS 997) (check-in: daf7b94017 user: drh tags: trunk) | |
22:50 | Fix a bug in the COPY command introduced by check-in (991). (CVS 996) (check-in: 77ec13dab8 user: drh tags: trunk) | |
18:17 | Fix an initialized variable in sqliteInitOne. (CVS 995) (check-in: 89957b09ce user: drh tags: trunk) | |
06:29 | Generate anchors in opcode table html for use by new vdbe tutorial. (CVS 994) (check-in: 3ae36cf158 user: jplyon tags: trunk) | |
06:17 | Added comments. (CVS 993) (check-in: 1276ddb307 user: jplyon tags: trunk) | |
06:15 | Additions and corrections to vdbe documentation comments. (CVS 992) (check-in: b648987de3 user: jplyon tags: trunk) | |
2003-06-01
| ||
01:10 | Add the ability to INSERT or UPDATE using the "rowid" column even on tables that lack an integer primary key. (CVS 991) (check-in: 903adbe802 user: drh tags: trunk) | |
2003-05-31
| ||
16:21 | Tighter binding of views, triggers, and indices to their respective databases. Ticket #323. Much more testing needs to be done to the sqliteFix...() routines in attach.c. (CVS 990) (check-in: 7202d4f1a8 user: drh tags: trunk) | |
2003-05-29
| ||
17:50 | Change the row-size limit back to 1MB. It was temporarily raised to 16MB. We'll probably move it to 16MB eventually, but not just yet. (CVS 989) (check-in: b84c4035c6 user: drh tags: trunk) | |
17:43 | Modify the windows locking code so that it works correctly for a database being shared between Win95/98/ME and WinNT/2K/XP systems. Ticket #310. (CVS 988) (check-in: 8c402db7e0 user: drh tags: trunk) | |
04:21 | Added typeof() operator. Minor additions for ATTACH/DETACH. (CVS 987) (check-in: 8b8fa0fff2 user: jplyon tags: trunk) | |
2003-05-19
| ||
23:55 | Fix segfault that occurs when opening a non-existing database in the shell then immediately doing ".q". (CVS 986) (check-in: e8566cf5a3 user: drh tags: trunk) | |
2003-05-17
| ||
19:23 | Additional attach testing. I now believe that ticket #317 was fixed by check-in (981). (CVS 985) (check-in: 2419137379 user: drh tags: trunk) | |
19:04 | Prevent an infinite loop when deleting a table that has a TEMP trigger. (CVS 984) (check-in: c8c823b068 user: drh tags: trunk) | |
17:52 | Version 2.8.2 (CVS 983) (check-in: f542e5fc88 user: drh tags: trunk) | |
17:38 | Bump the version number and update the change log. We are rushing out release 2.8.2 because of the database corruption problem fixed by the previous check-in. (CVS 982) (check-in: e134459d65 user: drh tags: trunk) | |
17:35 | Fix problems with TEMP indices that lead to corrupt databases. These problems were discovered while working on ticket #317. No sure yet if that ticket is fixed. (CVS 981) (check-in: 01398fb78b user: drh tags: trunk) | |
02:44 | Version 2.8.1 (CVS 980) (check-in: 590f963b65 user: drh tags: trunk) | |
02:27 | Fix the fix for newlines in echo commands. Tickets #311, #282, #256. (CVS 979) (check-in: baea7aca10 user: drh tags: trunk) | |
01:39 | Bump the version number to 2.8.1. Update documentation prior to release. (CVS 978) (check-in: 0874814ab0 user: drh tags: trunk) | |
00:24 | Escape backslashes in echo commands in the makefiles. Tickets #311, #282, #256. (CVS 977) (check-in: d614861b8a user: drh tags: trunk) | |
00:05 | Fix memory allocation problem in the sqlite_get_table() API. Ticket #315. (CVS 976) (check-in: f1d955efd9 user: drh tags: trunk) | |
2003-05-16
| ||
02:30 | Make sure the ON CONFLICT clause on a BEGIN overrides the conflict resolution specified by an index. This fixes a bug reported on the newsgroup. (CVS 975) (check-in: 0f92736d1f user: drh tags: trunk) | |
2003-05-13
| ||
08:01 | Removed 3rd (file) column from PRAGMA database_list until tests are fixed. (CVS 974) (check-in: 4183cf9767 user: jplyon tags: trunk) | |
01:52 | Fix another twos-complement negation error. Ticket #313. (CVS 973) (check-in: f267a8a4ff user: drh tags: trunk) | |
00:34 | A change to lemon related to ticket #313. (CVS 972) (check-in: b59d9033d5 user: drh tags: trunk) | |
00:24 | Remove unnecessary "#include <sqliteInt.h>" from the shell code. (CVS 971) (check-in: 6e5c497a42 user: drh tags: trunk) | |
00:21 | Fix a #ifdefs that are used to comment-out the VACUUM command. (CVS 970) (check-in: 22d5324073 user: drh tags: trunk) | |
2003-05-12
| ||
23:06 | Make sure hash functions always return non-negative. (CVS 969) (check-in: 39a3e403f0 user: drh tags: trunk) | |
2003-05-11
| ||
20:09 | Changed PRAGMA database_list to show the filename. (CVS 968) (check-in: 3da10d2d02 user: jplyon tags: trunk) | |
20:07 | Changed ".databases" command to use PRAGMA database_list. (CVS 967) (check-in: bad2065337 user: jplyon tags: trunk) | |
2003-05-10
| ||
03:36 | Changes to comments. In particular, a lengthy comment was added to encode.c that explains how the encoder algorithm works. (CVS 966) (check-in: 8b388b2f69 user: drh tags: trunk) | |
03:04 | Removed never-used symbol SQLITE_ResultDetails. (CVS 965) (check-in: 26bd7bb177 user: jplyon tags: trunk) | |
03:03 | Removed never-used pragma "result_set_details". (CVS 964) (check-in: bf558e7952 user: jplyon tags: trunk) | |
02:54 | Documented the "GO" and "\" command terminators. (CVS 963) (check-in: 6a76bd9590 user: jplyon tags: trunk) | |
02:54 | Fixed metacharacter coloring with LP, RP, PLUS. Added more links. (CVS 962) (check-in: 2bbb080495 user: jplyon tags: trunk) | |
2003-05-07
| ||
13:37 | Format keyword lists in lang.html using a TCL proc. (CVS 961) (check-in: ca75f1ca12 user: drh tags: trunk) | |
04:04 | - Added entries for PRAGMAs database_list, temp_store and default_temp_store. - Fixed missing end tags. (CVS 960) (check-in: 55ae7b35ee user: jplyon tags: trunk) | |
03:59 | Cleaned up keywords section. (CVS 959) (check-in: bb609f96e0 user: jplyon tags: trunk) | |
2003-05-06
| ||
20:35 | Restrain the flattener in the presence of outer joins. Ticket #306. (CVS 958) (check-in: 6d4b6597e5 user: drh tags: trunk) | |
2003-05-04
| ||
20:42 | Added tests trying (unsuccessfully) to reproduce ticket #304. (CVS 957) (check-in: fda637f453 user: drh tags: trunk) | |
18:30 | Shell command-line parsing enhancements suggested by Mike Hall. (CVS 956) (check-in: 5656fe48b1 user: drh tags: trunk) | |
17:58 | Fix deficiencies in sqlite_complete() pointed out by R. Dennis Cote. (CVS 955) (check-in: 54b33a5ed9 user: drh tags: trunk) | |
07:31 | Added shell command ".databases" to list name and file of open ones. Added several missing shell commands. (CVS 954) (check-in: dd57d6ae6a user: jplyon tags: trunk) | |
07:25 | added shell command ".databases" to list name and file of open ones. (CVS 953) (check-in: 741a5a8d39 user: jplyon tags: trunk) | |
07:02 | new section for keywords, more docs for attached databases , links, cleanup (CVS 952) (check-in: 87e1b6a936 user: jplyon tags: trunk) | |
2003-05-03
| ||
19:04 | More documentation updates. (CVS 951) (check-in: 24b9b56924 user: drh tags: trunk) | |
04:55 | - added entry for ATTACH DATABASE. - added entry for DETACH DATABASE. - added soundex() function. - added some new TEMP modifiers. - added new VACUUM behavior. - added the Oracle8 outer join "(+)" syntax. - documented the modulus/remainder operator %. - added ALL as alternative to DISTINCT in SELECT. - fixed assignment list in UPDATE to use * metacharacter. - fixed value in PRAGMA to be optional. - added link from INSERT topic to REPLACE. - added optional CONSTRAINT <name> before column constraints. - skip 2 lines before each Section in the TCL source. (CVS 950) (check-in: fd28c5229e user: jplyon tags: trunk) | |
2003-05-02
| ||
16:44 | Additional tests of the new flattener added. Ticket #272. (CVS 949) (check-in: 8d9ee45ab4 user: drh tags: trunk) | |
16:04 | Enhance the query flattener to handle subqueries that are joins. All regressions pass but new tests need to be added before release. Ticket #272. (CVS 948) (check-in: ad57693e9f user: drh tags: trunk) | |
14:32 | VDBE cursors numbers for tables in a join do not have to be consecutive. This is one step on the road to fixing ticket #272. (CVS 947) (check-in: be7aed2011 user: drh tags: trunk) | |
2003-05-01
| ||
16:56 | Correctly create an index that uses an INTEGER PRIMARY KEY as one of columns to be indexed. (CVS 946) (check-in: 6d019e0baa user: drh tags: trunk) | |
2003-04-30
| ||
11:38 | In the shell tool, delay opening the database until it is needed but also make sure it is opened before trying to use the "db" pointer. Ticket #302. (CVS 945) (check-in: 20fcead42b user: drh tags: trunk) | |
2003-04-29
| ||
18:01 | Accept a "/" or "go" on a line by itself as an SQL statement terminator in the command-line shell. This allows SQL Server and Oracle scripts to be played into SQLite without change. (CVS 944) (check-in: 8211f57b38 user: drh tags: trunk) | |
17:19 | Allow the ASC or DESC keyword to appear after a column name in a CREATE INDEX statement. SQLite indices are aways ASC (ascending) regardless of which keyword is used. (CVS 943) (check-in: 1a0c542088 user: drh tags: trunk) | |
16:20 | The sqlite_complete() function should ignore carriage-return characters. (Oops - some unrelated edits also made it into this check-in.) (CVS 942) (check-in: c6bf62e41c user: drh tags: trunk) | |
2003-04-26
| ||
13:19 | In the test code, make several attempts to convert a pointer to a string and test each attempt to make sure it works before returnning, in order to work around incompatibilities between various systems. Ticket #284. (CVS 941) (check-in: 333011ffdd user: drh tags: trunk) | |
03:03 | Fix the shell tool to do a better job of ignoring whitespace. Ticket #234. (CVS 940) (check-in: 639957e9f7 user: drh tags: trunk) | |
02:50 | Only print the "Loading resources from..." line when the output is a TTY. Ticket #168. (CVS 939) (check-in: 92ded93376 user: drh tags: trunk) | |
02:40 | Do not use the return value of fcntl() to find the reason that it failed. Use errno instead. Tickets #240 and #270. (CVS 938) (check-in: acf9e9802f user: drh tags: trunk) | |
02:31 | Fix the sqlite_complete() routine so that it recognizes /*...*/ comments. Ticket #277. (CVS 937) (check-in: ef8eb580fc user: drh tags: trunk) | |
2003-04-25
| ||
17:52 | Report the correct authorization context in the authorization callback when coding an INSTEAD OF trigger on an update or delete. (CVS 936) (check-in: 67746833fc user: drh tags: trunk) | |
15:37 | Add tests to insure VACUUM works in the presence of I/O errors. Fix some problems that came to light by these tests. (CVS 935) (check-in: 8d3e879349 user: drh tags: trunk) | |
13:28 | Work around a name collision problem on windows. (CVS 934) (check-in: c3b1f84dfc user: drh tags: trunk) | |
13:22 | Make VACUUM work even if multiple processes have the database open at once. (CVS 933) (check-in: caa960289f user: drh tags: trunk) | |
03:13 | Explicit casts to squelch bogus warnings for vc++. Ticket #194. (CVS 932) (check-in: cb808c14bc user: drh tags: trunk) | |
02:43 | Get VACUUM working again - with test cases. Some other minor cleanups. (CVS 931) (check-in: 5afb88008f user: drh tags: trunk) | |
2003-04-24
| ||
01:45 | Fix some issues with INSTEAD OF triggers. (CVS 930) (check-in: 206b17397b user: drh tags: trunk) | |
2003-04-23
| ||
12:25 | Remove the begin_hook and commit_hook APIs. They were a bad idea. Add a "trace" method to the TCL interface. (CVS 929) (check-in: 6289b86359 user: drh tags: trunk) | |
2003-04-22
| ||
20:30 | Update the authorizer API so that it reports the database that table and indices belong to and so that it reports when actions are taken in response to a trigger. (CVS 928) (check-in: c675a55041 user: drh tags: trunk) | |
08:04 | Check for readline libs now adds appropriate curses or termcap lib when needed (CVS 927) (check-in: 393dd91c25 user: paul tags: trunk) | |
2003-04-21
| ||
18:48 | Add support for TEMPORARY triggers. Such triggers can write temporary or permanent tables. (CVS 926) (check-in: 58ddd587b0 user: drh tags: trunk) | |
2003-04-20
| ||
23:45 | Add more tests for the in-memory database. (CVS 925) (check-in: 11cab41c4f user: drh tags: trunk) | |
17:29 | Added tests for the in-memory database backend. Also updated some comments in other modules. (CVS 924) (check-in: fb89adf4d1 user: drh tags: trunk) | |
11:46 | Align config vars controlling in-memory DB with code (CVS 923) (check-in: 921656db9e user: paul tags: trunk) | |
11:41 | Reset pCur->eSkip on a MoveTo (CVS 922) (check-in: d983accf4a user: paul tags: trunk) | |
00:00 | Update comments. Remove unused field from the Index structure. (CVS 921) (check-in: 7084e05093 user: drh tags: trunk) | |
2003-04-19
| ||
17:27 | Modify the optimizer so that it does not assume that functions are constant. (CVS 920) (check-in: 767f1af236 user: drh tags: trunk) | |
16:34 | Bug in WHERE clause processing fixed. Ticket #298. (CVS 919) (check-in: 9b619c98b5 user: drh tags: trunk) | |
2003-04-18
| ||
22:52 | fix a memory leak in btree_rb.c. (CVS 918) (check-in: 1e3d0d0947 user: drh tags: trunk) | |
17:45 | Fix for ticket #297 - bug in sqliteSortCompare(). (CVS 917) (check-in: 4ded1965eb user: drh tags: trunk) | |
02:31 | The VACUUM command is now functioning (again). Need to do more testing. (CVS 916) (check-in: 6e948d9aae user: drh tags: trunk) | |
2003-04-17
| ||
22:57 | Fix triggers to work in an ATTACHed database. Ticket #295. (CVS 915) (check-in: 1e5e00fb73 user: drh tags: trunk) | |
12:44 | Make sure the min() and max() optimizations work on empty indexed tables. Ticket #296. (CVS 914) (check-in: 98ef611006 user: drh tags: trunk) | |
02:54 | Change the shell to use the sqliteIsNumber() routine for determining if values are numeric. Modified os.c so that it should now work with DJGPP - though I have no way of testing this. (CVS 913) (check-in: 35caefe317 user: drh tags: trunk) | |
2003-04-16
| ||
21:03 | Rollback if a commit hook fails. (CVS 912) (check-in: 5cea7554ae user: drh tags: trunk) | |
20:24 | Fix the authorizer so that it correctly interprets attempts to read the OLD and NEW pseudo-tables of a trigger. (CVS 911) (check-in: f04bd43254 user: drh tags: trunk) | |
02:17 | Simplify the number processing code. Fix for ticket #281. (CVS 910) (check-in: 4326b52a39 user: drh tags: trunk) | |
01:28 | Remove some unnecessary code and complication from the btree interface. (CVS 909) (check-in: 35cc7c7d37 user: drh tags: trunk) | |
2003-04-15
| ||
19:22 | Get triggers working on tables with INTEGER PRIMARY KEYs. Ticket #291. This may also fix #159. Still need to add tests so both bugs remain open for the time being. (CVS 908) (check-in: 0b996959b8 user: drh tags: trunk) | |
17:22 | Added btree_rb.c (CVS 907) (check-in: 93eb6c52ac user: paul tags: trunk) | |
14:01 | Do not record the inserted rowid on when doing an INSERT within a trigger. Ticket #290. (CVS 906) (check-in: 96a717661a user: drh tags: trunk) | |
01:49 | Change lemon to use <stdarg.h> instead of <varargs.h> because GCC no longer supports varargs.h. Tickets #288 and #280. Ironically, lemon originally used varargs.h because stdarg.h was not supported by the compiler I was using in 1989 (which was gcc if I recall correctly.) (CVS 905) (check-in: 7902e4778e user: drh tags: trunk) | |
01:19 | Change some variable names and comments in the new in-memory database file implementation. Partial (non-working) implementation of the VACUUM command. (CVS 904) (check-in: e76787f877 user: drh tags: trunk) | |
2003-04-13
| ||
18:26 | Support in-memory databases for temp tables (CVS 903) (check-in: 96336bffde user: paul tags: trunk) | |
2003-04-06
| ||
21:08 | Split the implementation of COPY, PRAGMA, and ATTACH into separate source code files. (CVS 902) (check-in: 73359037ea user: drh tags: trunk) | |
20:52 | Move the implementation of VACUUM into a separate source file. (CVS 901) (check-in: b123c165fd user: drh tags: trunk) | |
20:44 | Simplify the BTree interface by shortening names. Added two new methods for accessing the current filename and for changing the name of the database file. (CVS 900) (check-in: 185d8dc8d0 user: drh tags: trunk) | |
2003-04-05
| ||
16:56 | More testing of ATTACH and DETACH. (CVS 899) (check-in: 51f515f28c user: drh tags: trunk) | |
03:42 | Begin testing the new ATTACH and DETACH commands. (CVS 898) (check-in: 7a0f8024a1 user: drh tags: trunk) | |
2003-04-03
| ||
19:35 | Fix for ticket #276. (CVS 897) (check-in: 452128c6fd user: drh tags: trunk) | |
15:46 | Added experimental APIs: sqlite_begin_hook() and sqlite_commit_hook(). (CVS 896) (check-in: 5efbf62313 user: drh tags: trunk) | |
01:50 | Use a intermediate table when inserting a TEMP table from a SELECT that reads from that same TEMP table. Ticket #275. (CVS 895) (check-in: 087d1e83af user: drh tags: trunk) | |
2003-04-01
| ||
21:16 | Add infrastructure to suport multiple btree implementations (CVS 894) (check-in: 79b3aed2a7 user: paul tags: trunk) | |
2003-03-31
| ||
13:36 | Minor follow-on changes to the recent ATTACH patch. (CVS 893) (check-in: 11378c5bf9 user: drh tags: trunk) | |
13:36 | Minor follow-on changes to the recent ATTACH patch. (CVS 892) (check-in: e80afe75b3 user: drh tags: trunk) | |
02:12 | Add the sqliteErrorMsg() function and use it to generate error message text during parsing and code generation. This simplifies the code somewhat and makes it easier to handle names with a database prefix. (CVS 891) (check-in: 1d3fc97721 user: drh tags: trunk) | |
00:30 | The ATTACH and DETACH statements are now coded but are still mostly untested. (CVS 890) (check-in: c7c5e927a5 user: drh tags: trunk) | |
2003-03-30
| ||
19:17 | Remove the experimental sqlite_open_aux_file() API. It will soon be replaced by ATTACH and DETACH SQL commands. (CVS 1732) (check-in: 0a358844e4 user: drh tags: trunk) | |
19:17 | Remove the experimental sqlite_open_aux_file() API. It will soon be replaced by ATTACH and DETACH SQL commands. (CVS 889) (check-in: b6d6e07f3a user: drh tags: trunk) | |
18:58 | Remove the obsolete documentation on how to crosscompile version 1.0 of SQLite. (CVS 888) (check-in: ac0622bf5f user: drh tags: trunk) | |
18:41 | Detect when a child node of a btree page has zero entries and report that as a case of database corruption. (CVS 887) (check-in: 66c80ae232 user: drh tags: trunk) | |
00:19 | Fix a memory leak in triggers and update tests to show the latest error message text. (CVS 886) (check-in: b90d9de32d user: drh tags: trunk) | |
2003-03-27
| ||
13:50 | Regression tests now work - except for some changes in error message text. The library is now safe to use for experimental work. (CVS 885) (check-in: 8a593e9c2d user: drh tags: trunk) | |
13:01 | Fix a segfault in the trigger code. (CVS 884) (check-in: 7672914b19 user: drh tags: trunk) | |
12:51 | Changes to the "sqlite" structure that allow simultaneous operations on multiple database files. Many regession tests pass - but not all of them. Do not use this version except for debugging SQLite itself. (CVS 1731) (check-in: 9ac71c329e user: drh tags: trunk) | |
12:51 | Changes to the "sqlite" structure that allow simultaneous operations on multiple database files. Many regession tests pass - but not all of them. Do not use this version except for debugging SQLite itself. (CVS 883) (check-in: d2fb2bb50c user: drh tags: trunk) | |
2003-03-24
| ||
09:42 | Re-generated. (CVS 882) (check-in: f0c5bcf72c user: a.rottmann tags: trunk) | |
09:40 | Updated libtool. (CVS 881) (check-in: b1ca4e13dc user: a.rottmann tags: trunk) | |
09:39 | Added pkg-config support. (CVS 880) (check-in: ec1c5a6113 user: a.rottmann tags: trunk) | |
2003-03-20
| ||
01:16 | Record the database name in addition to the table name for DELETE, INSERT, and UPDATE statements. (CVS 879) (check-in: a5d8fc95ee user: drh tags: trunk) | |
2003-03-19
| ||
03:14 | Modifications to the VDBE to support more than one database file. (CVS 878) (check-in: 875da9eed9 user: drh tags: trunk) | |
2003-03-07
| ||
19:50 | Do not allow an empty string to be inserted into an INTEGER PRIMARY KEY. (CVS 877) (check-in: 2aba40bea5 user: drh tags: trunk) | |
2003-03-01
| ||
19:53 | Add more tests to make sure that sqlite_changes() works when using the non-callback API. Ticket #250. (CVS 876) (check-in: 13e501d190 user: drh tags: trunk) | |
19:45 | Get the non-callback API working with the EXPLAIN keyword and for PRAGMAs. Tickets #258 and #257. Update the API documentation on the sqlite_changes() routine to explain how it works with the non-callback API. Ticket #250. (CVS 875) (check-in: 620e1065e9 user: drh tags: trunk) | |
2003-02-26
| ||
13:52 | Fix a memory leak associated with PRIMARY KEY in a CREATE TABLE statement that fails. Ticket #249. (CVS 874) (check-in: 8e9dc56799 user: drh tags: trunk) | |
13:52 | Fix a memory leak associated with PRIMARY KEY in a CREATE TABLE statement that fails. Ticket #249. (CVS 1730) (check-in: 66158843df user: drh tags: trunk) | |
2003-02-20
| ||
01:48 | When the right table in a LEFT OUTER JOIN contains an INTEGER PRIMARY KEY make sure that key is NULL if there is no row in the right table that matches the current row in the left table. Tickets #246 and #247. (CVS 873) (check-in: 6a45fe3bd7 user: drh tags: trunk) | |
00:44 | Fix the parsing of the LIMIT clause when the limit and offset are separated by a comma. The offset comes before the limit in that case. Ticket #245. (CVS 872) (check-in: 6ef91a364b user: drh tags: trunk) | |
2003-02-16
| ||
22:49 | Version 2.8.0 (CVS 870) (check-in: 5db98b3f40 user: drh tags: trunk) | |
22:48 | Couple of last-minute changes before 2.8.0. (CVS 871) (check-in: 8192c937d5 user: drh tags: trunk) | |
22:36 | Update the speed comparison documentation to show the improved performance of PostgreSQL after performance tuning. (CVS 869) (check-in: 73c904e57a user: drh tags: trunk) | |
22:21 | Added test code to check for file descriptor leaks. All regression tests pass now on both win2k and linux. (CVS 868) (check-in: 75ba78280f user: drh tags: trunk) | |
19:13 | Fix more bugs. The new rollback journal implementation now passes all regression tests under Linux. (CVS 867) (check-in: d10adc1c57 user: drh tags: trunk) | |
2003-02-15
| ||
23:09 | Fix the pager so that correct rollbacks occur when synchronous is turned off. This check-in also included unrelated documentation updates. (CVS 866) (check-in: 3ef0ad8a4f user: drh tags: trunk) | |
2003-02-13
| ||
02:54 | Update the documentation for the new journal format to be introduced in version 2.8.0. (CVS 1729) (check-in: dc53d92141 user: drh tags: trunk) | |
02:54 | Update the documentation for the new journal format to be introduced in version 2.8.0. (CVS 865) (check-in: e05a7a552f user: drh tags: trunk) | |
01:58 | Fix a bug in the rollback logic for the new journal format. (CVS 864) (check-in: 7c22aa3f81 user: drh tags: trunk) | |
2003-02-12
| ||
14:09 | Added the new FULL option to the SYNCHRONOUS pragma. Still need to test it. (CVS 1728) (check-in: 8968bc0636 user: drh tags: trunk) | |
14:09 | Added the new FULL option to the SYNCHRONOUS pragma. Still need to test it. (CVS 863) (check-in: 792a9e157d user: drh tags: trunk) | |
02:10 | Fix a bug in the legacy journal format writing logic. (CVS 862) (check-in: 6c927dd36c user: drh tags: trunk) | |
2003-02-11
| ||
14:55 | Modify the journal format to be more robust against garbage that might appear in the file after a power failure. The changes are mostly working but more testing is still required. This check-in is to checkpoint the changes so far. (CVS 861) (check-in: 8ec5632536 user: drh tags: trunk) | |
2003-02-05
| ||
14:06 | Make the shell run much faster for inputs where a single SQL statement spans thousands of lines by avoiding the call to sqlite_complete() unless the input ends in a semicolon. (CVS 860) (check-in: e21afb82b5 user: drh tags: trunk) | |
2003-02-02
| ||
12:41 | Make the GROUP BY clause work even if there are no aggregate functions. (CVS 859) (check-in: b687923158 user: drh tags: trunk) | |
2003-02-01
| ||
13:53 | When a CREATE TABLE ... AS SELECT statement fails, make sure the table name is removed from the internal hash tables. Ticket #238. (CVS 858) (check-in: 65264780c5 user: drh tags: trunk) | |
2003-01-31
| ||
17:21 | The sqlite_exec() function now returns SQLITE_AUTH when authorization fails. Ticket #231. (CVS 857) (check-in: d93c1aeb54 user: drh tags: trunk) | |
17:16 | Allow double-quoted strings as string constants in the IN operator. As a side-efffect, allow the GROUP BY clause to refer to columns by their integer column number. Ticket #237. (CVS 856) (check-in: 187d9c4058 user: drh tags: trunk) | |
2003-01-29
| ||
22:58 | Additional testing and bug fixing with the non-callback API. Updated the C/C++ interface document to describe the non-callback API. (CVS 855) (check-in: af1e929946 user: drh tags: trunk) | |
18:46 | Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) (check-in: ccc82f1ab4 user: drh tags: trunk) | |
14:06 | The callback-free API is now working, though much more testing is need. (CVS 853) (check-in: 162b259188 user: drh tags: trunk) | |
2003-01-28
| ||
23:13 | First code for the new callback-free API. All regression tests pass but the new API is mostly untested and is unlikely to work. (CVS 852) (check-in: 065fa818ff user: drh tags: trunk) | |
2003-01-26
| ||
15:28 | Added section on comments. Corrected broken end tags. (CVS 851) (check-in: c957f4f0c6 user: jplyon tags: trunk) | |
2003-01-25
| ||
16:32 | Version 2.7.6 (CVS 850) (check-in: bdba796f3b user: drh tags: trunk) | |
15:43 | Fix a bug in the rollback validation logic (code that only runs during debugging). The problem was introduced by check-in (835). (CVS 849) (check-in: b6ea0da76a user: drh tags: trunk) | |
14:34 | Remove an unused variable. (CVS 848) (check-in: 18f4ffaa2e user: drh tags: trunk) | |
14:32 | Preparations for the release of version 2.7.6. (CVS 847) (check-in: 5143d4814d user: drh tags: trunk) | |
14:25 | Update the speed.html documentation. Recent optimizations have made the library much faster. (CVS 846) (check-in: ed47d162a0 user: drh tags: trunk) | |
2003-01-24
| ||
12:14 | Add asserts to btree.c that check for the correct size of various typedefs and structures. Ticket #233. (CVS 845) (check-in: c7e647d011 user: drh tags: trunk) | |
2003-01-22
| ||
01:26 | Minor refinements to the pager. (CVS 844) (check-in: 19221dee5f user: drh tags: trunk) | |
2003-01-21
| ||
23:06 | fix a typo on the quickstart.html page. (CVS 843) (check-in: 61869bb51b user: drh tags: trunk) | |
02:39 | In the pager, cache a pointer to the first page on the freelist that does not need to be synced. This makes a fetch of a page that is not in cache go a lot faster when the cache is full. This check-in also adds some performance instrumentation to the OS layer. (CVS 842) (check-in: 00f08fc0b5 user: drh tags: trunk) | |
2003-01-19
| ||
03:59 | Update comments. No changes to code. (CVS 841) (check-in: f6a8706872 user: drh tags: trunk) | |
2003-01-18
| ||
22:01 | Update the speed comparison page. (CVS 840) (check-in: 424cb2edb0 user: drh tags: trunk) | |
20:11 | Fix datatype reporting and collating sequence selection so that it works correctly on views and with the UNION, EXCEPT, and INTERCEPT operators. (CVS 839) (check-in: 71cc292dce user: drh tags: trunk) | |
17:05 | Do not report an error if the input to the sqlite shell ends in a comment. Ticket #211. (CVS 838) (check-in: 32a8e6e977 user: drh tags: trunk) | |
17:04 | Check the validity of the database connection before the trace callback, not afterwards. (CVS 837) (check-in: 960a2e4af3 user: drh tags: trunk) | |
2003-01-16
| ||
16:28 | Add the sqlite_trace() hook for tracing the SQL that an application executes. The plan is to leave this API undocumented for the time being, in case we want to make changes to it later. (CVS 836) (check-in: f67bff8ff3 user: drh tags: trunk) | |
13:42 | Improvements to the pager to help large updates against a large database run faster. Also improved the testing of the pager rollback algorithms. (CVS 835) (check-in: 717523d375 user: drh tags: trunk) | |
2003-01-14
| ||
13:48 | Finish out the test suite for the new sqlite_set_authorizer API. (CVS 834) (check-in: 701a73918d user: drh tags: trunk) | |
02:54 | Fix a memory leak in the PRAGMA authorization code. (CVS 833) (check-in: ba58979f2f user: drh tags: trunk) | |
02:49 | More tests of the sqlite_set_authorizer() API together with fixes for bugs that the new tests uncovered. (CVS 832) (check-in: cc2ae781ac user: drh tags: trunk) | |
00:44 | Make the GLOB work write with upper-case characters. Ticket #226. (CVS 831) (check-in: 7ea46e7064 user: drh tags: trunk) | |
2003-01-13
| ||
23:27 | Revise the sqlite_set_authorizer API to provide more detailed information about the SQL statement being authorized. Only partially tested so far. (CVS 830) (check-in: 45de93f913 user: drh tags: trunk) | |
2003-01-12
| ||
19:33 | The initial round of tests for the sqlite_set_authorizer() API. More are needed before release. Ticket #215. (CVS 829) (check-in: 5707b3d56e user: drh tags: trunk) | |
18:07 | Forgot to include the new "auth.c" source file in the previous checkin. (CVS 828) (check-in: 7601916419 user: drh tags: trunk) | |
18:02 | Initial check-in of the code for the new sqlite_set_authorizer() API function. The code is mostly untested at this point. (CVS 827) (check-in: 52d5007f64 user: drh tags: trunk) | |
17:35 | Remove an unused variable from the VDBE. Ticket #223. (CVS 826) (check-in: 0deaf563fd user: drh tags: trunk) | |
17:28 | Change the PopStack() routine so that it doesn't confuse bounds checkers. Ticket #222. (CVS 825) (check-in: fc11fa50b8 user: drh tags: trunk) | |
2003-01-11
| ||
15:02 | Remove the aOrder() array from where.c. (CVS 824) (check-in: b2c1edb47f user: drh tags: trunk) | |
14:25 | Fix two compiler warnings from OS-X. (CVS 823) (check-in: 4c22da76ca user: drh tags: trunk) | |
14:19 | Document the SHOW_DATATYPES pragma and add tests for it to the test suite. Make sure datatypes are show even for aliased columns. Tickets #220 and #221. (CVS 822) (check-in: e84d3afe7b user: drh tags: trunk) | |
13:30 | Remove the ColumnCount opcode, which had become a no-op. (CVS 821) (check-in: 86deb12d68 user: drh tags: trunk) | |
2003-01-08
| ||
13:02 | Port ot MacOS Classic. Ticket #218. (CVS 820) (check-in: 13f82d67f6 user: drh tags: trunk) | |
2003-01-07
| ||
14:46 | Avoid calling truncate() and stat() on the checkpoint journal to improve the speed of a large number of UPDATEs within a transaction. (CVS 819) (check-in: 2f89e9e696 user: drh tags: trunk) | |
13:55 | In the VDBE, allocate space to hold column names when the VDBE first starts. The ColumnCount opcode now just writes the null terminator into this space. (CVS 818) (check-in: 46d8f5e377 user: drh tags: trunk) | |
13:43 | When constructing records and index keys, use static string space rather than mallocing (when possible) for a small speed improvement. (CVS 817) (check-in: 657c9fb513 user: drh tags: trunk) | |
02:47 | More optimizations. (CVS 816) (check-in: a362981b20 user: drh tags: trunk) | |
01:44 | Optimizations to the tokenizer. (CVS 815) (check-in: 032b3daa1d user: drh tags: trunk) | |
2003-01-06
| ||
23:54 | Remove unnecessary code from the VDBE. (CVS 814) (check-in: b96ec281ff user: drh tags: trunk) | |
2003-01-05
| ||
21:41 | More optimizations. (CVS 813) (check-in: 5809132f5b user: drh tags: trunk) | |
2003-01-04
| ||
19:44 | Parameterize the number of adjacent pages that participate in the balancing algorithm in the BTree. But leave the setting at the current value of 3. (CVS 812) (check-in: 6c304024bb user: drh tags: trunk) | |
18:53 | Another optimization to the btree logic. (CVS 811) (check-in: 03d2067361 user: drh tags: trunk) | |
16:48 | Optimizations to the BTree module for a modest speed improvement. (CVS 810) (check-in: 39902a7041 user: drh tags: trunk) | |
2003-01-03
| ||
02:04 | Allow the rollback journal to be empty except for its header. Ticket #212. (CVS 809) (check-in: 1ba41bc2af user: drh tags: trunk) | |
2003-01-02
| ||
14:43 | Code optimizations to help the library run faster. (CVS 808) (check-in: db745e87dc user: drh tags: trunk) | |
2003-01-01
| ||
23:06 | 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) (check-in: a1c071ea18 user: drh tags: trunk) | |
2002-12-28
| ||
01:26 | Version 2.7.5 (CVS 806) (check-in: ee95eefe12 user: drh tags: trunk) | |
01:10 | Update the version number to 2.7.5. (CVS 805) (check-in: b0864cc9c8 user: drh tags: trunk) | |
01:06 | Fix an uninitialized variable in the pager. Tickets #208 and #206. Bug introduced by check-in (795). (CVS 804) (check-in: f3dc686e02 user: drh tags: trunk) | |
2002-12-17
| ||
22:50 | Version 2.7.4 (CVS 803) (check-in: 0224db6f8c user: drh tags: trunk) | |
14:30 | Preparing for the 2.7.4 release. (CVS 802) (check-in: f685ae15b1 user: drh tags: trunk) | |
14:19 | If the "fake_big_file" command fails, be sure to close the file before returning. (CVS 801) (check-in: fa1b5e2119 user: drh tags: trunk) | |
14:13 | Make sure the host machine has enough disk space before running the large file tests. (CVS 800) (check-in: b1ec547865 user: drh tags: trunk) | |
13:05 | 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) (check-in: f04547edfa user: drh tags: trunk) | |
2002-12-07
| ||
21:45 | 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) (check-in: 1c58b4fc03 user: drh tags: trunk) | |
2002-12-04
| ||
22:29 | 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) (check-in: 0051c87d5e user: drh tags: trunk) | |
21:50 | Fixes to the logic that decides if the ORDER BY can be ignored due to the use of an index. Tests updated. (CVS 796) (check-in: bfb9a2aa93 user: drh tags: trunk) | |
20:01 | Scan the table backwards if there is an ORDER BY ... DESC clause that can be satisfied by an index. (CVS 795) (check-in: c7a3487981 user: drh tags: trunk) | |
13:40 | Add the sqliteBtreePrevious() routine to the BTree module API. This is in anticipation of implementing reverse order searching of a table. (CVS 794) (check-in: 0ad1d93879 user: drh tags: trunk) | |
2002-12-03
| ||
02:34 | Allow an aggregate function in the HAVING clause even if no aggregates appear in the result set. Ticket #187. (CVS 793) (check-in: 33c6fd6b3d user: drh tags: trunk) | |
02:22 | Honor ORDER BY clauses in VIEWs. Ticket #193. (CVS 792) (check-in: dbf7893234 user: drh tags: trunk) | |
2002-12-02
| ||
04:25 | Change to the pager to avoid opening journal files unnecessarily. This can sometimes results in a significant speed improvement. (CVS 791) (check-in: fa5c042585 user: drh tags: trunk) | |
2002-12-01
| ||
02:00 | Fixed large file support under Linux. I'm unable to test under Windows. Ticket #191. (CVS 790) (check-in: 9864a1265b user: drh tags: trunk) | |
2002-11-24
| ||
14:52 | 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) (check-in: 83b2c27a56 user: drh tags: trunk) | |
2002-11-20
| ||
11:55 | Automatically determine if pointers are 4 or 8 bytes in size during the compilation process. Ticket #190. (CVS 788) (check-in: dd5396a73a user: drh tags: trunk) | |
11:08 | Get the new large file code working with the Borland compiler. Ticket #195. (CVS 787) (check-in: da4a79e289 user: drh tags: trunk) | |
2002-11-11
| ||
13:56 | Remove extra from HTML output. Ticket #189. (CVS 786) (check-in: dc5d9c129c user: drh tags: trunk) | |
01:04 | 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) (check-in: 745d66395d user: drh tags: trunk) | |
00:05 | 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) (check-in: 263a8ca40f user: drh tags: trunk) | |
2002-11-10
| ||
23:32 | 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) (check-in: a6ef6657a4 user: drh tags: trunk) | |
2002-11-09
| ||
00:33 | 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) (check-in: a29d60ecc5 user: drh tags: trunk) | |
2002-11-06
| ||
14:08 | 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) (check-in: 2008b56fe1 user: drh tags: trunk) | |
00:59 | Changes to include files so that the >2GB file patch will compile under BSD. (CVS 780) (check-in: 81bb1aed5e user: drh tags: trunk) | |
2002-11-05
| ||
23:24 | Update the FAQ to explain how to enable large file support. (CVS 779) (check-in: 4caf624e90 user: drh tags: trunk) | |
23:03 | 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) (check-in: a3f67fe912 user: drh tags: trunk) | |
2002-11-04
| ||
19:32 | Add the sqlite_version() SQL function as a built-in. (CVS 777) (check-in: 7c8c0e7633 user: drh tags: trunk) | |
2002-11-01
| ||
01:55 | Improvements in threadtest.c (for Unix) and some minor bug fixes that result from the better testing. (CVS 776) (check-in: 326e0983c3 user: drh tags: trunk) | |
2002-10-31
| ||
00:15 | Version 2.7.3 (CVS 775) (check-in: 4051dbdb05 user: drh tags: trunk) | |
00:09 | Fix an assert that might fail if malloc() fails. (CVS 774) (check-in: 8ad018944c user: drh tags: trunk) | |
2002-10-30
| ||
23:04 | Bump the version number prior to the release of version 2.7.3. (CVS 773) (check-in: bc7c7d87e5 user: drh tags: trunk) | |
22:42 | In the VDBE, check to make sure a set has been initialized before using it. Ticket #185. (CVS 772) (check-in: 8c4cbdd055 user: drh tags: trunk) | |
2002-10-27
| ||
19:35 | Minimal support for oracle8 outer join syntax. (CVS 771) (check-in: 31df3690d0 user: drh tags: trunk) | |
2002-10-22
| ||
23:38 | Correctly handle column names and string constants in parentheses. Fix for ticket #179. (CVS 770) (check-in: 3b68aa25c4 user: drh tags: trunk) | |
15:04 | Take care to track ephemeral strings in the VDBE and make copies of ephemeral strings that need to be preserved. Ticket #177. (CVS 769) (check-in: 562da534bb user: drh tags: trunk) | |
2002-10-20
| ||
18:19 | Rework the changes for ticket #176 (check-ins (760) and (761)) to be more consistent with the rest of the source code. (CVS 768) (check-in: f50a177b42 user: drh tags: trunk) | |
16:00 | The "table_info" pragma reports unspecified column types as "numeric" instead of "text". Fix for ticket #174. (CVS 767) (check-in: 395ab5fac2 user: drh tags: trunk) | |
15:55 | Export the sqlite_function_type function from windows DLLs. Ticket #173. (CVS 766) (check-in: d5470dfe10 user: drh tags: trunk) | |
15:53 | Work around a bug in the Borland C compiler. Ticket #172. (CVS 765) (check-in: 3ef2925650 user: drh tags: trunk) | |
15:46 | Make sure malloc(0) always returns NULL. Fix for ticket #171. (CVS 764) (check-in: 4622b7ce8f user: drh tags: trunk) | |
2002-10-19
| ||
20:16 | Speed improvement by avoiding a call to sqliteBtreeLast() when inserting a new row into a table. (CVS 763) (check-in: d0af59fe6b user: drh tags: trunk) | |
20:13 | Fix the URL for pointing to MinGW on the homepage. (CVS 762) (check-in: 16aad98aad user: drh tags: trunk) | |
2002-10-17
| ||
09:01 | Minor coding fix in getting the windows platform version, when multithreading (CVS 761) (check-in: b53ab71d07 user: mike tags: trunk) | |
00:38 | fix for locking in Windows (CVS 760) (check-in: 83add34f64 user: mike tags: trunk) | |
2002-10-12
| ||
13:44 | Remove the call to srand() and add better comments to the sqliteOsRandomSeed() routine. Ticket #163. (CVS 759) (check-in: d87a886d8f user: drh tags: trunk) | |
2002-09-30
| ||
12:36 | Fix a bug in the left outer join logic. (CVS 758) (check-in: 6c0f44bd63 user: drh tags: trunk) | |
01:31 | Fix an uninitialized variable that could cause problems when comparing two NULLs. (CVS 757) (check-in: 0154250018 user: drh tags: trunk) | |
2002-09-25
| ||
19:50 | Version 2.7.2 (CVS 756) (check-in: 59ba43449a user: drh tags: trunk) | |
19:26 | Bump the version number to 2.7.2. (CVS 755) (check-in: a164528e8c user: drh tags: trunk) | |
19:04 | 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) (check-in: b0d27a377a user: drh tags: trunk) | |
2002-09-21
| ||
15:57 | Make sure memory malloced() for structures is aligned on an even byte boundry. Solaris segfaults otherwise. (CVS 753) (check-in: 14ebe30bf5 user: drh tags: trunk) | |
2002-09-17
| ||
03:20 | 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) (check-in: 29145746f3 user: drh tags: trunk) | |
2002-09-16
| ||
11:44 | 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) (check-in: f12c3a25ba user: drh tags: trunk) | |
2002-09-14
| ||
13:47 | Do not put a write lock on the main database file when writing to a temporary table. (CVS 750) (check-in: 3f253afe15 user: drh tags: trunk) | |
12:04 | 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) (check-in: 6cb80ae10a user: drh tags: trunk) | |
2002-09-12
| ||
14:08 | Update the SQL language documentation to talk about SELECT DISTINCT. (CVS 748) (check-in: ef7116751d user: drh tags: trunk) | |
2002-09-08
| ||
17:23 | 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) (check-in: 23fe36c7e8 user: drh tags: trunk) | |
00:04 | 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) (check-in: c4f0bb0238 user: drh tags: trunk) | |
00:04 | 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) (check-in: eb54d455b0 user: drh tags: trunk) | |
2002-09-05
| ||
23:21 | Fix a memory leak that occurred when sqlite_open() failed. (CVS 745) (check-in: a876021304 user: drh tags: trunk) | |
19:10 | Rewind the checkpoint journal after each statement to avoid allowing the file to become too large. (CVS 744) (check-in: f4288520df user: drh tags: trunk) | |
16:08 | Fix for ticket #146: Correctly handle reads of unused disk blocks at the end of the file. (CVS 743) (check-in: f5c2654768 user: drh tags: trunk) | |
2002-09-03
| ||
19:43 | Always fill in the 5th parameter to sqlite_exec if there is an error. (CVS 742) (check-in: 7f8fd5c75d user: drh tags: trunk) | |
2002-09-02
| ||
14:11 | Add documentation on NULL handling in SQLite versus other SQL database engines. (CVS 741) (check-in: dd8867fc47 user: drh tags: trunk) | |
12:14 | Detect when the test scripts are being run as root and issue an appropriate error message. (CVS 740) (check-in: 9ca2c50770 user: drh tags: trunk) | |
2002-09-01
| ||
23:20 |
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.
Before this change, one or more read cursors could be open on a table, or a single write cursor, but not both. Both policies have the same desirable effect: they prevent writes to a table while a sequential scan of that table is underway. But the new policy is a little less restrictive. Both policies prevent an UPDATE from occurring inside a SELECT (which is what we want) but the new policy allows a SELECT to occur inside an UPDATE. (CVS 739) (check-in: 8c2a083698 user: drh tags: trunk) | |
2002-08-31
| ||
18:53 | Parse foreign key constraints and populate internal data structures appropriately. Constraints are still not enforced. (CVS 738) (check-in: 170711ca65 user: drh tags: trunk) | |
17:02 | Version 2.7.1 (CVS 737) (check-in: 5f51e13d56 user: drh tags: trunk) | |
17:02 | Change the version number for release 2.7.1. (CVS 736) (check-in: b7f788fcc4 user: drh tags: trunk) | |
16:52 | Initial checking of two new test files: format3.test and memleak.test. (CVS 735) (check-in: 6ffedb90a6 user: drh tags: trunk) | |
16:33 | 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) (check-in: c5e0c6a782 user: drh tags: trunk) | |
2002-08-29
| ||
23:59 | 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) (check-in: 78a0229a7e user: drh tags: trunk) | |
2002-08-28
| ||
03:00 | 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) (check-in: 723362e74f user: drh tags: trunk) | |
2002-08-27
| ||
14:28 | Change the tokenizer to ignore C-style comments /*...*/ in accordance with SQL99. (CVS 731) (check-in: f153448948 user: drh tags: trunk) | |
2002-08-26
| ||
19:55 | Fix for ticket #142: Make sure we get the correct sort order even when the columns being sorted contain NULLs. (CVS 730) (check-in: 45847390d0 user: drh tags: trunk) | |
2002-08-25
| ||
20:58 | Version 2.7.0 (CVS 729) (check-in: 9e341d9c93 user: drh tags: trunk) | |
20:11 | Documentation updates prior to the releae of 2.7.0. (CVS 728) (check-in: e2d95f85a3 user: drh tags: trunk) | |
19:20 | 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) (check-in: c602603e7c user: drh tags: trunk) | |
18:29 | Fix the memory leak introduced by check-in (725). (CVS 726) (check-in: b957dafc26 user: drh tags: trunk) | |
2002-08-24
| ||
18:24 | 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) (check-in: 22d8726e61 user: drh tags: trunk) | |
2002-08-22
| ||
18:18 | Fix for ticket #138: Makefile doesn't use exec_prefix, has some install problems (CVS 724) (check-in: 97fc4a71a1 user: jadams tags: trunk) | |
2002-08-21
| ||
11:26 | Fix for ticket #137: Use getpwuid() instead of getpwent(). (CVS 723) (check-in: ea011990c5 user: drh tags: trunk) | |
2002-08-18
| ||
22:41 | 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) (check-in: 39bd52d330 user: drh tags: trunk) | |
20:28 | 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) (check-in: df51cb166b user: drh tags: trunk) | |
19:09 | Documentation updates. (CVS 720) (check-in: e372a60be8 user: drh tags: trunk) | |
2002-08-15
| ||
13:50 | Fix for ticket #135: Remove unused variables from three files. (CVS 719) (check-in: 8cf17f2a24 user: drh tags: trunk) | |
13:45 | More documentation updates. (CVS 718) (check-in: 9c0400aa7a user: drh tags: trunk) | |
11:48 | Additional test cases and documentation updates. (CVS 717) (check-in: 048b16c111 user: drh tags: trunk) | |
01:26 | Fixes and test improvements resulting from code coverage testing. (CVS 716) (check-in: 66a0f6a8e2 user: drh tags: trunk) | |
2002-08-14
| ||
23:18 | Fix for ticket #134: Change the lemon.c sources to work around a problem with the AIX C compiler. (CVS 715) (check-in: 07f6020bb5 user: drh tags: trunk) | |
12:56 | Implement probabilistic reader/writer locks under windows so that windows can have multiple simultaneous readers. (CVS 714) (check-in: 2127de3f03 user: drh tags: trunk) | |
03:03 | Disable sorting by indices if there is a COLLATE subclause in the ORDER BY clause. (CVS 713) (check-in: 2438da791a user: drh tags: trunk) | |
00:10 | Fix for ticket #132: make the working directory the last choice for where to write temporary files, not the first choice. (CVS 712) (check-in: 26a4e7e7a3 user: drh tags: trunk) | |
00:08 | Update documentation to better explain the typelessness of SQLite and to describe the distinction between text and numeric data. (CVS 711) (check-in: 4ff0f578ec user: drh tags: trunk) | |
2002-08-13
| ||
23:02 | Make the distinction between text and numeric data. (CVS 710) (check-in: 310ac4fbaf user: drh tags: trunk) | |
20:45 | Documentation and makefile updates. (CVS 709) (check-in: 92c403f485 user: drh tags: trunk) | |
13:15 | Bug fix to the left outer join logic. (CVS 708) (check-in: f9d3d4c123 user: drh tags: trunk) | |
13:15 | Bug fix to the left outer join logic. (CVS 1726) (check-in: 957d908e6b user: drh tags: trunk) | |
00:02 | Version 2.6.3 (CVS 707) (check-in: ba706aca0a user: drh tags: trunk) | |
00:01 | Updates prior to release 2.6.3. (CVS 706) (check-in: 34c4149eea user: drh tags: trunk) | |
2002-08-12
| ||
12:29 | Fix for ticket #9 (again). The rollback journal files should now also be byte-order independent. (CVS 705) (check-in: 2fb3fdcdf0 user: drh tags: trunk) | |
2002-08-11
| ||
20:10 | Fix for ticket #9: Add the ability to read little-endian database files from a big-endian machine and vice versa. (CVS 704) (check-in: ce4b943bf6 user: drh tags: trunk) | |
2002-08-06
| ||
12:05 | Fix typos the source to webpages html files. (CVS 703) (check-in: 61bb3af740 user: drh tags: trunk) | |
2002-08-04
| ||
00:52 | 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) (check-in: 18745c67ac user: drh tags: trunk) | |
2002-08-02
| ||
10:36 | 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) (check-in: bdbdb866f2 user: drh tags: trunk) | |
2002-07-31
| ||
19:50 | Fix for ticket #124: Fix a stack VDBE overflow problem on joins on an INTEGER PRIMARY KEY. (CVS 700) (check-in: fe329e078f user: drh tags: trunk) | |
00:38 | Version 2.6.2 (CVS 699) (check-in: 223a2150ac user: drh tags: trunk) | |
00:37 | Update version number and change log for the 2.6.2 release. (CVS 698) (check-in: 4f196de07d user: drh tags: trunk) | |
00:32 | 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) (check-in: 04973fc2a6 user: drh tags: trunk) | |
2002-07-30
| ||
18:43 | Fix for ticket #114: Correctly handle SQLITE_BUSY if it occurs during database initialization. (CVS 696) (check-in: 5b814b5df6 user: drh tags: trunk) | |
17:42 | 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) (check-in: 0b0c0492cc user: drh tags: trunk) | |
17:20 | Fix for ticket #71: Correctly handle CR and CRLF line terminators in the input files for the COPY command. (CVS 694) (check-in: be1315755e user: drh tags: trunk) | |
2002-07-21
| ||
23:09 | UPDATE triggers on TEMP tables were broken. (CVS 693) (check-in: c080ed01ea user: danielk1977 tags: trunk) | |
2002-07-19
| ||
19:04 | Version 2.6.1 (CVS 691) (check-in: 610b7bc70a user: drh tags: trunk) | |
19:03 | Rig the ident string so that it is not changed by RCS on checkin. (CVS 692) (check-in: 773d36c8d9 user: drh tags: trunk) | |
18:52 | 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) (check-in: 612df00401 user: drh tags: trunk) | |
18:13 | Add static ident strings (such as picked up by the RCS "ident" command) containing the library version number. (CVS 689) (check-in: 712ee3914e user: drh tags: trunk) | |
17:46 | Better detection and reporting of errors when initializing from the sqlite_master table. (CVS 688) (check-in: c8a7b725b7 user: drh tags: trunk) | |
2002-07-18
| ||
11:10 | Version 2.6.0 Release 2 (CVS 687) (check-in: cc4f824b15 user: drh tags: trunk) | |
11:07 | Fix a bug in the publish.sh script that was causing the windows DLL to not be built. (CVS 686) (check-in: ee8c2758a2 user: drh tags: trunk) | |
11:01 | Change the name of variable "near" to "nearby" since MSVC mistakenly belieaves that "near" is a keyword. (CVS 685) (check-in: 9761a2a0fb user: drh tags: trunk) | |
02:50 | Version 2.6.0 Release 1 (CVS 684) (check-in: dde65e9e06 user: drh tags: trunk) | |
02:07 | Update documentation prior to the release of 2.6.0. (CVS 683) (check-in: f2d9191381 user: drh tags: trunk) | |
01:27 | 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) (check-in: 0493e39c1c user: drh tags: trunk) | |
00:34 | 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) (check-in: 20d152fcdd user: drh tags: trunk) | |
2002-07-16
| ||
17:22 | 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) (check-in: bbca16f88d user: drh tags: trunk) | |
02:05 | Fix for ticket #100: Correctly handle ON and USING clauses of JOINs within a VIEW. (CVS 679) (check-in: 93710f7ed7 user: drh tags: trunk) | |
2002-07-15
| ||
20:58 | Fix a syntax error in the tclsqlite.c file. (CVS 678) (check-in: 47997d7f3a user: drh tags: trunk) | |
18:55 | Fix for ticket #102: Honor the ORDER BY clause in subqueries. (CVS 677) (check-in: 7e918c8b0d user: drh tags: trunk) | |
2002-07-13
| ||
17:33 | Fix for ticket #64: Better error reporting in the shell. (CVS 676) (check-in: e1842e04c4 user: drh tags: trunk) | |
17:23 | 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) (check-in: 72a609ec64 user: drh tags: trunk) | |
17:18 | Fix for ticket #99: Added documentation on the sqlite_mprintf() API. (CVS 674) (check-in: d918de5f06 user: drh tags: trunk) | |
16:52 | Added a document describing how to do a security audit. (CVS 673) (check-in: cff2718377 user: drh tags: trunk) | |
14:41 | Fix for ticket #54: Export additional APIs to the Win32 DLL. (CVS 672) (check-in: 072fd2ad58 user: drh tags: trunk) | |
03:11 | Fix for ticket #95: Do not allow automatically created indices (associated with UNIQUE or PRIMARY KEY constraints) to be dropped. (CVS 671) (check-in: 0603eb74e6 user: drh tags: trunk) | |
2002-07-11
| ||
12:18 | 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) (check-in: b98727246d user: drh tags: trunk) | |
2002-07-10
| ||
21:26 | 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) (check-in: ff8b6f4ee8 user: drh tags: trunk) | |
2002-07-08
| ||
22:03 | Add support for TEMPORARY views. The code is here but it is mostly untested. (CVS 668) (check-in: 87cd10c1f6 user: drh tags: trunk) | |
10:59 | 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) (check-in: fd7e41f0ee user: drh tags: trunk) | |
02:16 | Make the BTree balance() routine a little faster by reusing database pages locally rather than freeing and reallocating them. (CVS 666) (check-in: 3c2dea4310 user: drh tags: trunk) | |
2002-07-07
| ||
17:13 | Version 2.5.6 (CVS 664) (check-in: 111c78e683 user: drh tags: trunk) | |
17:12 | Fix for Win32: The %p format on Win32 does not prepend a "0x" as it should. (CVS 665) (check-in: ee86704daf user: drh tags: trunk) | |
16:52 | 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) (check-in: f6e24d5ccb user: drh tags: trunk) | |
2002-07-06
| ||
16:34 | Version 2.5.5 (CVS 662) (check-in: 6284c65c17 user: drh tags: trunk) | |
16:32 | Prepare for the 2.5.5 release. (CVS 661) (check-in: 00f83c2576 user: drh tags: trunk) | |
16:28 | 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) (check-in: db178646a0 user: drh tags: trunk) | |
2002-07-05
| ||
21:42 | 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) (check-in: b4737a16c9 user: drh tags: trunk) | |
2002-07-02
| ||
13:05 | 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) (check-in: 85793a4f03 user: drh tags: trunk) | |
11:55 | Fix for ticket 91: Modify the "publish.sh" script to use the new mingw cross-compiler installed on the development platform. (CVS 657) (check-in: 3cac283de4 user: drh tags: trunk) | |
2002-07-01
| ||
12:35 | Version 2.5.4 (CVS 656) (check-in: f7159fde6b user: drh tags: trunk) | |
12:34 | Update the change log and the version number for the next release. (CVS 655) (check-in: f9d77140ae user: drh tags: trunk) | |
12:27 | Fix for tickets #90 and #89: Make the AS keyword optional again. (CVS 654) (check-in: 1f8a73b1c3 user: drh tags: trunk) | |
00:31 | Added additional tests. No new errors found. (CVS 653) (check-in: 8924a7f5ba user: drh tags: trunk) | |
2002-06-29
| ||
02:20 | Add a few more tests and fix a few bugs that the tests uncovered. (CVS 652) (check-in: 91c0db66c8 user: drh tags: trunk) | |
2002-06-28
| ||
12:18 | 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) (check-in: 96515b813e user: drh tags: trunk) | |
01:02 | 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) (check-in: c07e493b62 user: drh tags: trunk) | |
2002-06-27
| ||
13:21 | Fix for ticket #88: A typo in the documention of the "sqlite" shell command. (CVS 649) (check-in: 16552a7a29 user: drh tags: trunk) | |
2002-06-26
| ||
20:06 | 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) (check-in: 9ca6368525 user: drh tags: trunk) | |
02:45 | 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) (check-in: bdb006b809 user: drh tags: trunk) | |
2002-06-25
| ||
19:31 | Add the sqlite_open_aux_file() API. (CVS 646) (check-in: 332164d645 user: drh tags: trunk) | |
15:19 | Version 2.5.3 (CVS 645) (check-in: d5cb675432 user: drh tags: trunk) | |
14:46 | Fix a spelling error in the change log. (CVS 644) (check-in: 37cc40442b user: drh tags: trunk) | |
14:43 | 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) (check-in: 36fc0add66 user: drh tags: trunk) | |
13:16 | Enhance the INTEGRITY_CHECK pragma to test the auxiliary database file in addition to the main database file. (CVS 642) (check-in: 52eba4de30 user: drh tags: trunk) | |
01:09 | Version 2.5.2 (CVS 641) (check-in: 756310cad2 user: drh tags: trunk) | |
01:09 | Added support for the "sqlite_temp_master" table. Increased the version number to 2.5.2. (CVS 640) (check-in: 9c1432bf74 user: drh tags: trunk) | |
2002-06-24
| ||
22:01 | 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) (check-in: 8b6574cfa8 user: drh tags: trunk) | |
12:20 | Fix a VDBE stack leak in LEFT OUTER JOIN. Fix a bug in the code generator for JOIN ... USING(...). (CVS 638) (check-in: d861489e1f user: drh tags: trunk) | |
2002-06-22
| ||
02:33 | An optimization: avoid the use of an intermediate table on UNION ALL if there is no ORDER BY clause. (CVS 637) (check-in: 8aa73ce612 user: drh tags: trunk) | |
2002-06-21
| ||
23:01 | Fix for bugs #77 and #80: Rework the LIMIT mechanism to be reentrant and to clean up the VDBE stack properly. (CVS 636) (check-in: 9d55231079 user: drh tags: trunk) | |
13:09 | Fix for ticket #76: Fix a database corruption that might occur when dropping tables or indices. (CVS 635) (check-in: 7936b03250 user: drh tags: trunk) | |
11:55 | Fix for ticket #78: Avoid an assertion failure when sqlite_close() to be called in the middle of a transaction. (CVS 634) (check-in: 2532792a58 user: drh tags: trunk) | |
2002-06-20
| ||
11:41 | Update the file-format change document to describes the changes between versions 2.4.12 and 2.5.0. (CVS 633) (check-in: d28a2ecc91 user: drh tags: trunk) | |
11:36 | 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) (check-in: cbbc858d97 user: drh tags: trunk) | |
03:38 | 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) (check-in: 43c5aff5d0 user: drh tags: trunk) | |
2002-06-19
| ||
20:32 | Fix for ticket #75: Autoincrement INTEGER PRIMARY KEY fields on an INSERT even if the data is coming from a SELECT statement. (CVS 630) (check-in: d599f75b65 user: drh tags: trunk) | |
14:27 | Version 2.5.1 (CVS 629) (check-in: 5e8a3131ab user: drh tags: trunk) | |
14:27 | 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) (check-in: f09e19b43e user: drh tags: trunk) | |
2002-06-17
| ||
17:26 | Version 2.5.0 (CVS 627) (check-in: 9baef3e240 user: drh tags: trunk) | |
17:15 | Update the change summary for version 2.5.0 (CVS 626) (check-in: 7a216adea5 user: drh tags: trunk) | |
17:07 | 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) (check-in: 05783a9db5 user: drh tags: trunk) | |
2002-06-16
| ||
18:21 | Expose an additional internal API routine (sqliteInitCallback()) for use by private code. (CVS 624) (check-in: cd74495f99 user: drh tags: trunk) | |
04:57 | Added explanation and examples for %Q format specifier. (CVS 623) (check-in: 633ce4dd25 user: chw tags: trunk) | |
04:56 | Added printf-4.(2-4) test cases to test new %Q format specifier. (CVS 622) (check-in: 7d5fc35b5d user: chw tags: trunk) | |
04:55 | Added %Q format specifier: like %q but automatic enclosing in single quotes, NULL pointers replaced by NULL w/o single-quotes. (CVS 621) (check-in: b9c7ecc2f9 user: chw tags: trunk) | |
04:54 | 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) (check-in: 8bc711571d user: chw tags: trunk) | |
2002-06-14
| ||
22:38 | Make the LIMIT clause work even if the destination of the SELECT is something other than a callback. (Ticket #66) (CVS 619) (check-in: 699cf36208 user: drh tags: trunk) | |
20:58 | Improvements to comments. No code changes. (CVS 618) (check-in: 7e10e60bb7 user: drh tags: trunk) | |
20:54 | Fix for bug #72: Make sure the file descriptors are properly closed if sqliteInit() fails for any reason. (CVS 617) (check-in: e67ac0fec5 user: drh tags: trunk) | |
2002-06-12
| ||
22:33 | Fix for bug #70: Correct a typo in the documentation. (CVS 616) (check-in: 3387d5b6d6 user: drh tags: trunk) | |
2002-06-11
| ||
22:33 | Documentation that should have been checked in along with checkin (614) (CVS 615) (check-in: 10da136125 user: danielk1977 tags: trunk) | |
02:25 | Add RAISE() function, which allows more advanced flow-control in trigger programs (ticket #55) (CVS 614) (check-in: d4a2fb1006 user: danielk1977 tags: trunk) | |
2002-06-09
| ||
10:14 | Fix the spelling of sqliteRegisterBuiltinFunctions(). (CVS 613) (check-in: 74d297d97e user: drh tags: trunk) | |
01:55 | 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) (check-in: 2a710e1817 user: drh tags: trunk) | |
01:16 | 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) (check-in: ad9624798e user: drh tags: trunk) | |
2002-06-08
| ||
23:25 | 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) (check-in: 8481e841eb user: drh tags: trunk) | |
2002-06-06
| ||
23:42 | Bug fix: do not segfault if a SELECT without a FROM clause includes the * wildcard in the result column list. (CVS 609) (check-in: d939294994 user: drh tags: trunk) | |
23:30 | Fix for ticket #59: Add documentation for the || operator. Also added documentation for the new SQL92 join syntax. (CVS 608) (check-in: a0abef62bf user: drh tags: trunk) | |
23:16 | 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) (check-in: 9ef795d1d7 user: drh tags: trunk) | |
19:04 | Additional grammar cleanup resulting from the %fallback directive. (CVS 606) (check-in: c0cb3a012e user: drh tags: trunk) | |
18:54 | 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) (check-in: 7ac5bd293c user: drh tags: trunk) | |
2002-06-02
| ||
18:22 | Fix a compiler warning. (CVS 604) (check-in: 637ee587b5 user: drh tags: trunk) | |
18:19 | 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) (check-in: 6fdcee3c99 user: drh tags: trunk) | |
16:09 | Enhance the ORDER BY clause so that an integer term means to sort by the corresponding column. (CVS 602) (check-in: 7acbf84b49 user: drh tags: trunk) | |
2002-06-01
| ||
21:41 | 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) (check-in: df9cc852ad user: drh tags: trunk) | |