SQLite

Timeline
Login

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

100 check-ins occurring around f6c4908e9b5b6ac9.

2003-12-23
16:22
Add localtime<-->UTC conversions to the date functions. (CVS 1146) (check-in: 8482b8c4 user: drh tags: trunk)
03:06
Test functions tolerate an "0x" before a pointer value. Ticket #452. (CVS 1145) (check-in: c6c5e07b user: drh tags: trunk)
02:17
Use a built-in atof() function instead of the one from the library to avoid problems with locale. Ticket #305. (CVS 1144) (check-in: 4d9edbc5 user: drh tags: trunk)
2003-12-22
14:53
Optimizations to the LEMON parser template. (CVS 1143) (check-in: 06db29df user: drh tags: trunk)
2003-12-20
04:00
Fix some minor problems with the new test4.c module used for doing thread testing. (CVS 1142) (check-in: 95292408 user: drh tags: trunk)
2003-12-19
20:09
Update configuration and make files for mingw/msys on Windows (CVS 1141) (check-in: 1e968967 user: dougcurrie tags: trunk)
12:32
Remove a comma at the end of an enum definition. Some compilers could not deal with it. (CVS 1140) (check-in: b1890a5b user: drh tags: trunk)
12:31
Makefile updates for the new "test4.c" module. Also disable large file tests for archic TCL versions. (CVS 1139) (check-in: 55e24889 user: drh tags: trunk)
08:40
A better fix for ticket #530 - one that is likely to work on unix implementations in addition to linux. Also more tests for multi-thread locking added. (CVS 1138) (check-in: 7dddbeb5 user: drh tags: trunk)
02:52
Add new thread-testing code and fix locking under Linux threads. Ticket #530. (CVS 1137) (check-in: b36a4bb6 user: drh tags: trunk)
2003-12-18
14:19
Typo on the "datatypes.html" document. (CVS 1136) (check-in: 80b1e277 user: drh tags: trunk)
01:22
Version 2.8.8 (CVS 1135) (check-in: a0451ccf user: drh tags: trunk)
00:02
Bump the version number and update the change log in preparation for the next release. (CVS 1134) (check-in: 9ad0bdf6 user: drh tags: trunk)
2003-12-17
23:57
Make sure the pagers in-memory cache states in sync with the disk file. Ticket #529. (CVS 1133) (check-in: da00efb1 user: drh tags: trunk)
2003-12-16
03:44
Improvements to the way PRAGMA integrity_check works. More likely to output userful information when given a corrupt database. (CVS 1132) (check-in: b92c31d6 user: drh tags: trunk)
2003-12-15
17:51
Updates to the homepage - fix the CVS access instructions. (CVS 1131) (check-in: 653a7dd9 user: drh tags: trunk)
2003-12-10
03:13
Fix a bulk-memory initialization problem in the expression list logic. (CVS 1130) (check-in: d6549954 user: drh tags: trunk)
01:31
Fix the code generator to a void a VDBE stack overflow on 3-way joins. Ticket #519. (CVS 1129) (check-in: 230a4ff2 user: drh tags: trunk)
2003-12-07
00:24
Make the VACUUM command run out of the VDBE like all other commands. (Ticket #464). Make the VACUUM command work even if there are VIEWs in the SQLITE_MASTER table that come before tables they reference. (Ticket #515) (CVS 1128) (check-in: 614cbbaf user: drh tags: trunk)
2003-12-06
22:22
Fail an ATTACH if the auxiliary database is locked. Ticket #514. (CVS 1127) (check-in: ac428c8d user: drh tags: trunk)
21:43
Always use "(char*)0" to terminate the argument list of sqliteSetString(). This is needed for 64-bit systems that use a 32-bit integer by default. (CVS 1126) (check-in: 656c9038 user: drh tags: trunk)
2003-12-04
20:51
Use sqlite_freemem() instead of free() in the shell. Windows needs this. (Unix does not care.) Ticket #444. (CVS 1125) (check-in: e5e6a848 user: drh tags: trunk)
13:47
Version 2.8.7 (CVS 1124) (check-in: d48b0b01 user: drh tags: trunk)
13:44
Update change log and version in preparation for the 2.8.7 release. (CVS 1123) (check-in: 9e79ab6c user: drh tags: trunk)
2003-11-27
00:48
Disallow temporary indices on persistent tables. (CVS 1122) (check-in: 72bf73b2 user: drh tags: trunk)
2003-11-25
23:48
Fix typos in file format documentation. Ticket #505. (CVS 1121) (check-in: 4eef9381 user: drh tags: trunk)
2003-11-24
23:11
Fix typo in file format documentation. Ticket #502. (CVS 1120) (check-in: 72f3e7c2 user: drh tags: trunk)
2003-11-11
23:30
Fix a typo in a #define that was commented out. No impact to working code. Ticket #476. (CVS 1119) (check-in: 21c2f96e user: drh tags: trunk)
2003-11-08
12:07
Added information on MySQL 4.0.16 to the NULL-handling survey. (CVS 1117) (check-in: e22e3ab5 user: drh tags: trunk)
2003-11-01
01:53
Revised date/time functions - now broken out into a separate source file. See the DateAndTimeFunctions wiki page for additional information. (CVS 1116) (check-in: 68ef9b45 user: drh tags: trunk)
2003-10-30
07:00
Fork the tree for project "shrike" (CVS 1118) (check-in: 181260c0 user: drh tags: trunk)
2003-10-23
15:27
Fix progress test error 1-2 (CVS 1115) (check-in: c3a49502 user: peter tags: trunk)
2003-10-22
22:15
Comment changes to the lemon parser template. Change some sqliteMalloc() calls to sqliteMallocRaw() for speed. Update the website template. (CVS 1114) (check-in: c637caf1 user: drh tags: trunk)
2003-10-21
16:34
Fix bugs in lemon associated with the change to a perfect hash table. (CVS 1113) (check-in: c0d1b269 user: drh tags: trunk)
13:16
Convert lemon to use a single perfect hash table for storing the actions. This should make the resulting parser both smaller and faster. (CVS 1112) (check-in: 4f955c00 user: drh tags: trunk)
2003-10-18
09:37
Add sqlite_progress_handler() API for specifying an progress callback (CVS 1111) (check-in: ddb36463 user: danielk1977 tags: trunk)
2003-10-10
02:09
Update to the date functions. (CVS 1110) (check-in: 06d4e883 user: drh tags: trunk)
2003-10-03
00:13
Allow quoted trigger names. Ticket #468. (CVS 1109) (check-in: 54aa0fb2 user: drh tags: trunk)
2003-09-30
01:54
All LIKE and GLOB operators to use function notation. "A LIKE B" can be expressed as "LIKE(B,A)". (CVS 1108) (check-in: 95b27ebd user: drh tags: trunk)
2003-09-29
12:20
Patch the spec.template file (for generating RPMs) as suggested by Jeremy Hinegardner. Untested. (CVS 1107) (check-in: 703741ca user: drh tags: trunk)
2003-09-27
13:39
Remove support for the Oracle8 outer join syntax. (CVS 1106) (check-in: 824430b3 user: drh tags: trunk)
01:08
Add a test case for ticket #464 but leave it commented out for now. We will fix this problem when VACUUM is rewritten. (CVS 1105) (check-in: 7ba8dc9b user: drh tags: trunk)
00:56
Add additional backslash escapes to the COPY command for compatibility with PostgreSQL. Ticket #460. (CVS 1104) (check-in: 70a50bdd user: drh tags: trunk)
00:41
Do all WHERE clauses tests, even if an index is used for lookup so that we know the test cannot be FALSE. The test might end up being NULL in which case it would need to be treated as false. Ticket #461. (CVS 1103) (check-in: 5aea8148 user: drh tags: trunk)
2003-09-23
10:25
A failed malloc() could have resulted in a segfault. Fixed by this check-in. (CVS 1102) (check-in: 4bb256ee 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: 4fdd44a5 user: xdong tags: trunk)
00:35
regenerate configure to take -enalbe-releasemode as an option (CVS 1100) (check-in: b85847b8 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: 760f2fa2 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: 4fbca3ab 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: f9feedec 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: f6c4908e 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: 990bb118 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: bfd69391 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: 912f47c7 user: drh tags: trunk)
2003-09-02
15:26
Add a logo from Rasmus Schultz. (CVS 1092) (check-in: aaa84c62 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: 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)