SQLite

Timeline
Login

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

54 check-ins using file test/trigger2.test version 22aa0519

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)