SQLite

Timeline
Login

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

133 check-ins using file src/trigger.c version ce83e017

2004-02-14
17:35
Fix problems with malloc-failure handling. (CVS 1241) (check-in: 398bc294 user: drh tags: trunk)
16:31
The sqlite_exec() function is now implemented using sqlite_compile() and sqlite_step(). This opens up lots of opportunity to remove old code. (CVS 1240) (check-in: 9771ad1e user: drh tags: trunk)
01:39
Disable the malloc.test tests if not compiled with -DMEMORY_DEBUG (CVS 1239) (check-in: 41b6ad78 user: drh tags: trunk)
2004-02-13
20:09
Fix an uninitialized variable in shell.c that would cause a crash if you specified SQL on the command-line. (CVS 1238) (check-in: 5a56090d user: drh tags: trunk)
16:30
Begin the process over converting sqlite_exec() over to use sqlite_compile() and sqlite_step(). The new sqlite_exec() is still commented out. (CVS 1237) (check-in: b8f2ba78 user: drh tags: trunk)
16:22
Fix a bug in the query flattener when trying to find the datatype of the rowid of a view. Also fix a problem with sqlite_compile() and authorization failures. (CVS 1236) (check-in: aa0490cc user: drh tags: trunk)
14:07
Fix an uninitialized variable introduced by check-in (1202). (CVS 1235) (check-in: 9f149fdc user: drh tags: trunk)
2004-02-12
20:49
Add a new parameter to the (unimplemented) encryption API. (CVS 1234) (check-in: 5fe8f023 user: drh tags: trunk)
19:01
Add the SQLITE_NOTADB return code for cases when you try to open a file that does not even remotely resemble an SQLite database file. (CVS 1233) (check-in: 0c77cee7 user: drh tags: trunk)
18:46
Add hooks on each attached database connection for storing auxiliary information. Add the USING clause to ATTACH. (CVS 1232) (check-in: 800c11f4 user: drh tags: trunk)
17:28
All REPLACE INTO syntax inside of triggers. Ticket #610. (CVS 1231) (check-in: a6b862a9 user: drh tags: trunk)
15:32
Remove unused variable. (CVS 1230) (check-in: 74b23426 user: drh tags: trunk)
15:31
Always reload the schema after a rollback. Ticket #594. (CVS 1229) (check-in: 12c7a83f user: drh tags: trunk)
13:02
VACUUM returns SQLITE_INTERRUPT when interrupted. Ticket #593. (CVS 1228) (check-in: 2fe9f510 user: drh tags: trunk)
2004-02-11
16:38
Only define _FILE_OFFSET_BITS if it is not already defined. Ticket #605. (CVS 1227) (check-in: 300c5543 user: drh tags: trunk)
10:37
Fix the shells so that they always enable the codec if it is available, even if no key is supplied. (CVS 1226) (check-in: 95989717 user: drh tags: trunk)
10:35
Fix an uninitialized variable in expr.c. Ticket #604. (CVS 1225) (check-in: 1673bf7c user: drh tags: trunk)
09:46
Refactor the interface to the randomness generator. (CVS 1224) (check-in: f2bdccf4 user: drh tags: trunk)
02:18
Pass all (relevant) regression tests when using the codec. (CVS 1223) (check-in: 5200e9ed user: drh tags: trunk)
2004-02-10
23:51
Adjustments to the codec in the pager. (CVS 1222) (check-in: be5122e9 user: drh tags: trunk)
13:41
Perform updates in search order. Ticket #602. (CVS 1221) (check-in: cf1cec74 user: drh tags: trunk)
13:19
Fix for ticket #603. (CVS 1220) (check-in: d0624d25 user: drh tags: trunk)
02:57
Make the pager accessible from the btree structure always, not just during debugging. (CVS 1219) (check-in: 9c6b4758 user: drh tags: trunk)
02:27
Move the file-format-2 to file-format-3 conversion into sqliteInit(). (CVS 1218) (check-in: dcbe2800 user: drh tags: trunk)
01:54
Allow SQLITE_PAGE_SIZE to be redefined on the compiler command-line. (CVS 1217) (check-in: 4c7bf714 user: drh tags: trunk)
2004-02-09
14:37
After code is generated for a subquery, delete the Select structure in order to force the temporary table to be used and to prevent the subquery from being evaluated a second time. Ticket #601. (CVS 1216) (check-in: 1cff1886 user: drh tags: trunk)
14:35
Add test case for ticket #601. (CVS 1215) (check-in: 096312da user: drh tags: trunk)
01:20
Add an optional codec to the pager layer. (CVS 1214) (check-in: 2f0c122c user: drh tags: trunk)
2004-02-08
18:10
Version 2.8.12 (CVS 1213) (check-in: 1736d415 user: drh tags: trunk)
18:07
Perpare for the 2.8.12 release. (CVS 1212) (check-in: 93ccd1b1 user: drh tags: trunk)
06:17
Fix a bug in the VDBE that occurs when a CreateTable or CreateIndex fails. (CVS 1211) (check-in: 42cfd541 user: drh tags: trunk)
06:06
Add the crashtest1.c program used to test the ability of the database to survive a program crash or power failure. Ticket #599. (CVS 1210) (check-in: 597a59a7 user: drh tags: trunk)
06:05
Fix inaccuracies and add details to comments in the pager. Change the name of one function to make its purpose clearer. Ticket #599. (CVS 1209) (check-in: 48832d35 user: drh tags: trunk)
00:40
Preliminary fix for ticket #599. More testing and analysis needed. (CVS 1208) (check-in: dc5be2c8 user: drh tags: trunk)
2004-02-02
12:29
Remove undocumented extensions from sqlite_mprintf() and friends in order to make it about 10% smaller. (CVS 1207) (check-in: 0b3f552b user: drh tags: trunk)
2004-02-01
01:22
Fix the handling of -init option to the sqlite shell. Ticket #568. Also add hooks for encrypting the database. (CVS 1206) (check-in: 3c796de8 user: drh tags: trunk)
2004-01-31
20:40
Fix a bug introduced by the previous check-in. (CVS 1205) (check-in: 04cf2278 user: drh tags: trunk)
20:20
A few more optimizations to the VDBE. (CVS 1204) (check-in: 06e7ff4c user: drh tags: trunk)
19:22
Rework internal data structures to make the VDBE about 15% smaller. (CVS 1203) (check-in: 8273c74b user: drh tags: trunk)
2004-01-30
14:49
Rework the VDBE data structures to combine string representations into the same structure with integer and floating point. This opens the door to significant optimizations. (CVS 1202) (check-in: c0faa1c6 user: drh tags: trunk)
02:01
Make sure min() and max() optimizations work for subqueries. Ticket #587. (CVS 1201) (check-in: af73fbca user: drh tags: trunk)
2004-01-27
17:46
Change permissions on the install-sh file to be executable. Ticket #582. (CVS 1200) (check-in: eafa714d user: drh tags: trunk)
15:58
Add a web page describing when it is appropriate to use SQLite and when it is not. (CVS 1199) (check-in: d77e4776 user: drh tags: trunk)
2004-01-25
22:44
Modularize the column name resolution code so that it is smaller, faster, and ready for some enhancements that will fix long-standing name resolutions problems. (CVS 1198) (check-in: d3648034 user: drh tags: trunk)
2004-01-24
20:18
Add the ability to group FROM terms using parentheses. Names of columns in a join no longer include the table name. (CVS 1197) (check-in: 3626f6d4 user: drh tags: trunk)
2004-01-22
23:38
Fix typo. Ticket #577. (CVS 1196) (check-in: 3dc95195 user: drh tags: trunk)
2004-01-21
13:35
In test programs, an SQLITE_SCHEMA return is retried repeatedly, not just once. (CVS 1195) (check-in: df3509e1 user: drh tags: trunk)
2004-01-20
11:54
Make ATTACH and DETACH work with the non-callback API. Ticket #574. (CVS 1194) (check-in: c32a80fe user: drh tags: trunk)
2004-01-19
05:09
documented pragma foreign_key_list(). updated docs for removed behavior: Oracle join syntax and temp indexes. (CVS 1193) (check-in: 06bd5070 user: jplyon tags: trunk)
04:57
comment typos (CVS 1192) (check-in: 7972ee32 user: jplyon tags: trunk)
04:55
comment typos (CVS 1191) (check-in: de35c36e user: jplyon tags: trunk)
04:54
coment typo (CVS 1190) (check-in: 0d2683dc user: jplyon tags: trunk)
04:53
coment typo (CVS 1189) (check-in: 8210b2d8 user: jplyon tags: trunk)
04:52
comment (CVS 1188) (check-in: fa55c986 user: jplyon tags: trunk)
2004-01-17
01:16
Do not use strcpy() on overlapping buffers. (CVS 1187) (check-in: ed6bd2eb user: drh tags: trunk)
2004-01-16
20:01
Access to free()ed memory problem fixed. Found by electric fence. Only an issue when doing an EXPLAIN of a CREATE INDEX. (CVS 1186) (check-in: 6604e5f7 user: drh tags: trunk)
19:11
See ticket #569; eliminates warnings for Cygwin v1.5 and above. (CVS 1185) (check-in: a0f8b1f3 user: dougcurrie tags: trunk)
16:42
More compaction of expr.c. (CVS 1184) (check-in: 92e7f780 user: drh tags: trunk)
15:55
Incremental code compaction in expr.c. Now about 4% smaller. Lots more work to do. (CVS 1183) (check-in: d292ba51 user: drh tags: trunk)
13:58
Fix a buffer-overflow problem in the randStr function (used only for testing). (CVS 1182) (check-in: 42c79edc user: drh tags: trunk)
2004-01-15
13:29
More aggressive retry schedule in sqlite_busy_timeout(). (CVS 1181) (check-in: 5e85025b user: drh tags: trunk)
03:30
Allow "expr IN table" as a shorthand for "expr IN (SELECT * FROM table)" (CVS 1180) (check-in: 01874d25 user: drh tags: trunk)
02:44
Reinsert the experimental sqlite_commit_hook() API. (CVS 1179) (check-in: 72bc84f2 user: drh tags: trunk)
2004-01-14
21:59
Fix comparisons of ROWID against floating point numbers so that they work correctly. Ticket #377 and #567. (CVS 1178) (check-in: c9ac3db8 user: drh tags: trunk)
13:50
Version 2.8.11 (CVS 1177) (check-in: a9f25347 user: drh tags: trunk)
13:43
Bump the version number for the next release. (CVS 1176) (check-in: 2812dd5f user: drh tags: trunk)
13:38
Ignore NULLs in a subquery as the right operand of IN. Ticket #565. (CVS 1175) (check-in: c9e7996f user: drh tags: trunk)
03:49
Version 2.8.10 (CVS 1174) (check-in: 8bef75ab user: drh tags: trunk)
03:32
Move some files around and bump the version number in preparation for the release of 2.8.10. (CVS 1173) (check-in: 74c66185 user: drh tags: trunk)
03:12
Remove an incomplete comment that somehow snuck into the sources. (CVS 1172) (check-in: ea1ad465 user: drh tags: trunk)
2004-01-12
00:39
On unix, embargo close() operations until all locks have cleared from the file. Ticket #561. (CVS 1171) (check-in: 1ebe5fc7 user: drh tags: trunk)
00:38
Previous commit of changes to the in-memory backend was not quite right. This check-in should square things away. (CVS 1170) (check-in: 75d91e3b user: drh tags: trunk)
00:21
Make sure the in-memory database can handle malloc failures. (CVS 1169) (check-in: ba92af18 user: drh tags: trunk)
2004-01-08
02:17
Remove unused code and tighten existing code to make the library a little smaller. (CVS 1168) (check-in: 34a6b741 user: drh tags: trunk)
2004-01-07
20:37
Rework the fix to ticket #461 so that we do not have to do redundant tests of WHERE clause terms looking for NULLs. See also check-in (1103). (CVS 1167) (check-in: 5fd58178 user: drh tags: trunk)
19:24
Permit sqlite_exec() to be called from within user-defined functions. (CVS 1166) (check-in: 03636c94 user: drh tags: trunk)
18:52
Defer the {quote: MoveTo} opcode in VDBE until the data is actually needed. Sometimes the data is never needed, resulting in a performance increase. On an indexed order search with a large OFFSET, queries times can be an order of magnitude faster. (CVS 1165) (check-in: d3e96da2 user: drh tags: trunk)
03:41
Make it safe to call sqliteMalloc() with a request for 0 bytes. Ticket #534. (CVS 1164) (check-in: 6c858db2 user: drh tags: trunk)
03:29
Preserve the HH:MM:SS for most date/time modifiers. Ticket #551. (CVS 1163) (check-in: 70df32b7 user: drh tags: trunk)
03:04
Use "long double" to hold intermediate values when doing ascii to binary and binary to ascii conversions of floating point numbers. (CVS 1162) (check-in: 8371f662 user: drh tags: trunk)
02:52
Add a typecast to work around a bug in the Metrowerks Code Warrior compiler. Ticket #553. (CVS 1161) (check-in: 4146f8cc user: drh tags: trunk)
2004-01-06
02:23
Version 2.8.9 (CVS 1160) (check-in: d8ae6bdd user: drh tags: trunk)
01:52
Additional integer overflow boundary case tests. (CVS 1159) (check-in: 532170d4 user: drh tags: trunk)
01:27
Increase the version number and update the change log prior to the next release. (CVS 1158) (check-in: b99b68d0 user: drh tags: trunk)
01:13
Fix problem in the code generator were incorrect code was being created if the SQL source contained a negative integer that was too large to fit in a 32-bit signed integer variable. Ticket #552. (CVS 1157) (check-in: b8381d9f user: drh tags: trunk)
00:44
Add the sqlite_current_time variable for testing purposes. (CVS 1156) (check-in: 23fa407d user: drh tags: trunk)
2004-01-02
15:08
The "EST" timezone designation is ambiguous. Do not use it in the test scripts. (CVS 1155) (check-in: 720b565e user: drh tags: trunk)
13:17
Avoid an assertion fault that can occur with invalid UTF8 on the LENGTH() function. Ticket #548. (CVS 1154) (check-in: 7080fc39 user: drh tags: trunk)
2004-01-01
12:33
Remove unused code from the integrity_check logic. Ticket #545. (CVS 1153) (check-in: ee51e205 user: drh tags: trunk)
2003-12-31
17:57
Fix a bug in the SQLITE_PROFILE conditional compilation. (CVS 1152) (check-in: 597b33f6 user: drh tags: trunk)
17:25
Fix for ticket #542. (CVS 1151) (check-in: 458cfa5b user: drh tags: trunk)
16:00
Fix a bug (ticket #541) introduced by the previous check-in ((1149)). (CVS 1150) (check-in: 64624400 user: drh tags: trunk)
13:21
Reduce the randomness in the sqliteRandomSeed() routine in order to silence bogus errors from valgrind. Tickets #535 and #536. (CVS 1149) (check-in: cfe0acf9 user: drh tags: trunk)
2003-12-24
01:41
minor edits for new date.c with mingw/msys on Windows (CVS 1148) (check-in: 9392c514 user: dougcurrie tags: trunk)
2003-12-23
16:34
Update date/time functions so that they correctly handle NULL arguments. (CVS 1147) (check-in: a5a5fbd6 user: drh tags: trunk)
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)