SQLite

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 check-ins occurring around 7f5e8894ae.

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: 522c2efe 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: 3403d28a 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: 966b1a16 user: drh tags: trunk)
2003-08-26
11:41
Fix compiler warnings under OpenVMS. Ticket #357. (CVS 1088) (check-in: c95f347c 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: cbe32216 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: eebc82b7 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: da53369f user: drh tags: trunk)
11:18
Close files before deleting them on test scripts under Win2k. Ticket #434. (CVS 1084) (check-in: 2a40b461 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: 1aa3658e 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: ad7b017a 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: 5232b066 user: drh tags: trunk)
2003-08-22
03:00
Version 2.8.6 (CVS 1080) (check-in: 0bde7ae2 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: a4e3e075 user: drh tags: trunk)
2003-08-21
14:36
Update the -version-info number on libtool in Makefile.in. (CVS 1078) (check-in: dc36365e 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: 9699c685 user: drh tags: trunk)
2003-08-19
14:31
Add the "onecolumn" method to the TCL language bindings. (CVS 1076) (check-in: c7b4c28f 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: 7d8d3252 user: drh tags: trunk)
12:37
Do not delete tables with the same name when dropping triggers. Ticket #430. (CVS 1074) (check-in: ef58f163 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: 3563e9cf user: drh tags: trunk)
2003-08-13
11:29
Update the NULL-handling chart with new information about Firebird. (CVS 1072) (check-in: 17bdfeb2 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: 02fac304 user: drh tags: trunk)
01:50
tighter coding of the date and time functions. Better comments. A bug fix. (CVS 1070) (check-in: 94243eda user: drh tags: trunk)
2003-08-09
21:32
Add experimental date and time functions based on julian day number. (CVS 1069) (check-in: a6197e20 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: 086aa1c9 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: da627325 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: 09c10fe3 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: 8c163fc0 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: 7514c3db user: drh tags: trunk)
2003-07-22
13:20
Version 2.8.5 (CVS 1063) (check-in: 95fba440 user: drh tags: trunk)
12:44
Fix a typo in the index.html homepage. (CVS 1062) (check-in: 510761cf 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: c2115335 user: drh tags: trunk)
09:24
Add experimental sqlite_reset() API (allows pre-compiled queries) (CVS 1060) (check-in: 1d2fcb01 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: 6ccb92b1 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: 543479e3 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: c35e5071 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: 558969ee 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: 93a2c961 user: drh tags: trunk)
2003-07-16
17:10
Fix typo on the homepage. (CVS 1054) (check-in: c74107d6 user: drh tags: trunk)
11:51
Make LIMIT 0 return no rows. LIMIT -1 still returns all rows. Ticket #346. (CVS 1053) (check-in: a31d0bd9 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: e6a752bf user: drh tags: trunk)
00:54
Initialize a variable to prevent an MSVC compiler warning. Ticket #394. (CVS 1051) (check-in: 96e3c539 user: drh tags: trunk)
2003-07-09
16:34
An an extra test associated with ticket #387. (CVS 1050) (check-in: 6a07ac37 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: dd84f88f 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: 303b2da1 user: drh tags: trunk)
2003-07-07
10:47
A proported fix for ticket #374. (CVS 1047) (check-in: a49ee69e user: drh tags: trunk)
00:10
Update the NULL-handling document to show current behavior of OCELOT. (CVS 1046) (check-in: 1d4c92c7 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: 982aa335 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: eb458283 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: 9a87f2f3 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: a3920b08 user: drh tags: trunk)
2003-06-29
20:45
Version 2.8.4 (CVS 1041) (check-in: 7f5e8894 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: fc490f67 user: drh tags: trunk)
18:29
Fix a bad memory leak in the in-memory database module. (CVS 1039) (check-in: 9cca9593 user: drh tags: trunk)
16:16
Bump the version number in preparation for the next release. (CVS 1038) (check-in: 0532e1a8 user: drh tags: trunk)
16:11
Documentation updates. (CVS 1037) (check-in: ab21de5f user: drh tags: trunk)
2003-06-28
16:25
Minor change to a comment in encode.c. (CVS 1036) (check-in: 3f252b72 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: e2ca936f 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: bad8b558 user: drh tags: trunk)
2003-06-23
15:15
Remove a surplus "return" statement accidentaly left in check-in (1032). (CVS 1033) (check-in: c697410a user: drh tags: trunk)
11:06
Remove all references to SQLITE_OMIT_TRACE. Tracing is always enabled. Ticket #361. (CVS 1032) (check-in: ec31a529 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: cb70ee67 user: drh tags: trunk)
2003-06-17
02:57
Remove unused variable. Ticket #355. (CVS 1030) (check-in: 5228cecd 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: 6920b633 user: drh tags: trunk)
03:08
Add the %z format to the sqlite_mprintf() and related functions. (CVS 1028) (check-in: eca1398e 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: dd8943e8 user: drh tags: trunk)
00:16
Preserve blank lines in the middle of SQL statements in the shell. Ticket #352 (CVS 1026) (check-in: bcf5eeec 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: 38461a7a 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: c9734c27 user: drh tags: trunk)
10:35
Updated sqlite_encode_binary() comments with tighter bounds on output length. (CVS 1023) (check-in: 826aab43 user: jplyon tags: trunk)
10:29
Documented integer values used by PRAGMAs. Fixed missing end tags in generated anchors. (CVS 1022) (check-in: 6c24dfba 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: e13e8b05 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: 9ec40935 user: drh tags: trunk)
11:42
Open the journal file for read-only when doing a playback. Ticket #351. (CVS 1019) (check-in: 66ac7aea user: drh tags: trunk)
2003-06-12
08:59
Added missing error string to sqlite_error_string(). (CVS 1018) (check-in: 3afb7b35 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: b52f07e1 user: drh tags: trunk)
2003-06-09
11:53
Remove redundant "return" statement from btree_rb.c. (CVS 1016) (check-in: 373d0771 user: drh tags: trunk)
2003-06-08
08:36
Documented SQL fns IFNULL() and NULLIF(). (CVS 1015) (check-in: 190252fe 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: 7d3405b9 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: 5dad7c05 user: drh tags: trunk)
08:57
Major update of vdbe tutorial to 2.8.0 engine. (CVS 1012) (check-in: 787d986d user: jplyon tags: trunk)
08:56
Hyperlinks and minor additions/corrections for lang.tcl (CVS 1011) (check-in: 685a179a 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: a97dca73 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: 09546972 user: drh tags: trunk)
15:44
Add a prototype for the sqlite_vmprintf() function to sqlite.h. (CVS 1008) (check-in: 048cf55c user: drh tags: trunk)
2003-06-05
15:05
Fix a typo in speed.html. (CVS 1007) (check-in: d01e6fbd user: drh tags: trunk)
14:27
Remove unused code from util.c. (CVS 1006) (check-in: 1bcaa841 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: af6f2bdf 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: fa10c6df 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: f39100f5 user: drh tags: trunk)
12:44
Version 2.8.3 (CVS 1002) (check-in: 433570e3 user: drh tags: trunk)
12:40
Update the version number to 2.8.3. (CVS 1001) (check-in: c96f5bf0 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: 4bfb30d2 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: e813faae 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: 3e8889d7 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: daf7b940 user: drh tags: trunk)
22:50
Fix a bug in the COPY command introduced by check-in (991). (CVS 996) (check-in: 77ec13da user: drh tags: trunk)
18:17
Fix an initialized variable in sqliteInitOne. (CVS 995) (check-in: 89957b09 user: drh tags: trunk)
06:29
Generate anchors in opcode table html for use by new vdbe tutorial. (CVS 994) (check-in: 3ae36cf1 user: jplyon tags: trunk)
06:17
Added comments. (CVS 993) (check-in: 1276ddb3 user: jplyon tags: trunk)
06:15
Additions and corrections to vdbe documentation comments. (CVS 992) (check-in: b648987d user: jplyon tags: trunk)