/ Timeline
Login

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

26 check-ins using file src/trigger.c version 21342af6

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: 8b6574cf 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: d861489e 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: 8aa73ce6 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: 9d552310 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: 7936b032 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: 2532792a 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: d28a2ecc 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: cbbc858d 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: 43c5aff5 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: d599f75b user: drh tags: trunk
14:27
Version 2.5.1 (CVS 629) check-in: 5e8a3131 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: f09e19b4 user: drh tags: trunk
2002-06-17
17:26
Version 2.5.0 (CVS 627) check-in: 9baef3e2 user: drh tags: trunk
17:15
Update the change summary for version 2.5.0 (CVS 626) check-in: 7a216ade 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: 05783a9d 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: cd74495f user: drh tags: trunk
04:57
Added explanation and examples for %Q format specifier. (CVS 623) check-in: 633ce4dd user: chw tags: trunk
04:56
Added printf-4.(2-4) test cases to test new %Q format specifier. (CVS 622) check-in: 7d5fc35b 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: b9c7ecc2 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: 8bc71157 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: 699cf362 user: drh tags: trunk
20:58
Improvements to comments. No code changes. (CVS 618) check-in: 7e10e60b 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: e67ac0fe user: drh tags: trunk
2002-06-12
22:33
Fix for bug #70: Correct a typo in the documentation. (CVS 616) check-in: 3387d5b6 user: drh tags: trunk
2002-06-11
22:33
Documentation that should have been checked in along with checkin (614) (CVS 615) check-in: 10da1361 user: danielk1977 tags: trunk
02:25
Add RAISE() function, which allows more advanced flow-control in trigger programs (ticket #55) (CVS 614) check-in: d4a2fb10 user: danielk1977 tags: trunk