/ File History
Login

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

History of test/trigger2.test

2013-11-05
13:33
Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. file: [5cd7d69a] check-in: [54b22192] user: drh branch: omit-rowid, size: 19848
01:59
Add the conflict2.test script. Fix issues discovered by this script. file: [1996d775] check-in: [294ed337] user: drh branch: omit-rowid, size: 19818
2009-09-01
17:11
Change "PRAGMA disable_recursive_triggers" to "PRAGMA recursive_triggers". Also a fix for compiling with OMIT_TRIGGER defined. file: [834187be] check-in: [e016cca3] user: dan branch: trunk, size: 19794
2009-08-30
11:42
Fixes for new triggers scheme. file: [10b5fa93] check-in: [9eb91efd] user: dan branch: trunk, size: 19800
2008-11-21
16:22
Fix a segfault that can be caused by an INSTEAD OF trigger on a view that includes an expression of the form "table.column" in the select list. (CVS 5940) file: [53cf2209] check-in: [88a09dbb] user: danielk1977 branch: trunk, size: 19567
2006-01-17
09:35
Test suite fixes for builds that define OMIT symbols. (CVS 2962) file: [33bf8ae9] check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 19277
2005-09-08
20:37
SUM returns NULL when it has no inputs. Ticket #1413. (CVS 2678) file: [dea71f4b] check-in: [62818594] user: drh branch: trunk, size: 19005
10:37
The SUM() aggregate function returns an integer result if all inputs are integers. Any single non-integer input causes the result to be a floating point value. (CVS 2669) file: [f85ee0db] check-in: [21adf4bd] user: drh branch: trunk, size: 18767
2005-03-29
03:10
Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) file: [f671b922] check-in: [c41d5544] user: danielk1977 branch: trunk, size: 18775
2005-01-29
08:32
Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286) file: [cbc8fe37] check-in: [b1b50f31] user: danielk1977 branch: trunk, size: 18526
2005-01-21
15:52
Final preparations for the 3.1.0 alpha release. (CVS 2255) file: [cf497cd1] check-in: [17122c7e] user: drh branch: trunk, size: 18522
04:25
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) file: [52ae9109] check-in: [d4e19efc] user: danielk1977 branch: trunk, size: 18524
2004-11-22
08:43
Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132) file: [534390be] check-in: [711e8d76] user: danielk1977 branch: trunk, size: 18095
2004-11-04
14:47
All tests pass when SQLITE_OMIT_INTEGRITY_CHECK is defined. (CVS 2055) file: [cbf5da84] check-in: [158a2d16] user: drh branch: trunk, size: 18051
2004-10-31
02:22
Insert #ifdefs that can optionally remove features at compiletime resulting in a database engine with a smaller footprint. (CVS 2034) file: [fec8f909] check-in: [be661acf] user: drh branch: trunk, size: 18247
2004-08-20
18:34
Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) file: [a5d06e6e] check-in: [e97c3313] user: drh branch: trunk, size: 18199
2003-11-27
00:48
Disallow temporary indices on persistent tables. (CVS 1122) file: [0767ab30] check-in: [72bf73b2] user: drh branch: trunk, size: 18039
2003-08-05
13:13
Provide a more informative error message when a uniqueness constraint fails. Ticket #419. (CVS 1068) file: [22aa0519] check-in: [086aa1c9] user: drh branch: trunk, size: 18105
2003-06-15
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) file: [b17223c3] check-in: [c9734c27] user: drh branch: trunk, size: 18141
2003-05-17
17:35
Fix problems with TEMP indices that lead to corrupt databases. These problems were discovered while working on ticket #317. No sure yet if that ticket is fixed. (CVS 981) file: [00ceb8af] check-in: [01398fb7] user: drh branch: trunk, size: 18153
2003-04-24
01:45
Fix some issues with INSTEAD OF triggers. (CVS 930) file: [adf6a9cf] check-in: [206b1739] user: drh branch: trunk, size: 17642
2003-02-15
23:09
Fix the pager so that correct rollbacks occur when synchronous is turned off. This check-in also included unrelated documentation updates. (CVS 866) file: [ab4c743b] check-in: [3ef0ad8a] user: drh branch: trunk, size: 15516
2003-01-29
18:46
Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) file: [592daa95] check-in: [ccc82f1a] user: drh branch: trunk, size: 15416
2002-09-14
12:04
Rename all tests so that the first part of the test name corresponds to the file that contains that test. This makes it much easier to find a particular test after it fail. (CVS 749) file: [ee346d8c] check-in: [6cb80ae1] user: drh branch: trunk, size: 15350
2002-08-13
00:01
Updates prior to release 2.6.3. (CVS 706) file: [19070bdb] check-in: [34c4149e] user: drh branch: trunk, size: 15194
2002-07-21
23:09
UPDATE triggers on TEMP tables were broken. (CVS 693) file: [f7398769] check-in: [c080ed01] user: danielk1977 branch: trunk, size: 15195
2002-05-28
06:55
Update trigger2.test to match checkin 591. Also fix ticket #51 (by documenting problem) (CVS 595) file: [c12759a0] check-in: [5e74d096] user: danielk1977 branch: trunk, size: 15160
2002-05-26
20:54
NULL values are distinct. A comparison involving a NULL is always false. Operations on a NULL value yield a NULL result. This change makes SQLite operate more like the SQL spec, but it may break existing applications that assumed the old behavior. All the old tests pass but we still need to add new tests to better verify the new behavior. Fix for ticket #44. (CVS 589) file: [7f2b0a9b] check-in: [90511737] user: drh branch: trunk, size: 15123
2002-05-23
00:30
Do not allow triggers on the SQLITE_MASTER table. (CVS 579) file: [2d23ad8a] check-in: [275ba356] user: drh branch: trunk, size: 15039
2002-05-15
08:30
Added FOR EACH ROW triggers functionality (CVS 562) file: [662818d5] check-in: [794bf67b] user: danielk1977 branch: trunk, size: 15010 Added