Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/trigger2.test
|
2023-10-20
| ||
| 20:19 | [30fcb3a6aa] part of check-in [b91c19bf26] Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG. (check-in: [b91c19bf26] user: drh branch: string_agg, size: 20871) | |
|
2021-04-21
| ||
| 11:32 | [6e35bd7321] part of check-in [2a28910a17] Fix a problem allowing SQL variables to be used expressions within the second and subsequent ON CONFLICT clauses of an UPSERT within a trigger. (check-in: [2a28910a17] user: dan branch: trunk, size: 20872) | |
|
2019-11-02
| ||
| 17:59 | [d15da46f70] part of check-in [9c795c4d2b] Fix a problem in VIEW creation that was introduced by the generated columns feature. (check-in: [9c795c4d2b] user: drh branch: trunk, size: 20286) | |
|
2013-11-05
| ||
| 13:33 | [5cd7d69a7b] part of check-in [54b2219297] 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. (check-in: [54b2219297] user: drh branch: omit-rowid, size: 19848) | |
| 01:59 | [1996d775f4] part of check-in [294ed33756] Add the conflict2.test script. Fix issues discovered by this script. (check-in: [294ed33756] user: drh branch: omit-rowid, size: 19818) | |
|
2009-09-01
| ||
| 17:11 | [834187beaf] part of check-in [e016cca363] Change "PRAGMA disable_recursive_triggers" to "PRAGMA recursive_triggers". Also a fix for compiling with OMIT_TRIGGER defined. (check-in: [e016cca363] user: dan branch: trunk, size: 19794) | |
|
2009-08-30
| ||
| 11:42 | [10b5fa93a8] part of check-in [9eb91efda5] Fixes for new triggers scheme. (check-in: [9eb91efda5] user: dan branch: trunk, size: 19800) | |
|
2008-11-21
| ||
| 16:22 | [53cf2209f6] part of check-in [88a09dbb4b] 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) (check-in: [88a09dbb4b] user: danielk1977 branch: trunk, size: 19567) | |
|
2006-01-17
| ||
| 09:35 | [33bf8ae9b7] part of check-in [3a54a33dcb] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (check-in: [3a54a33dcb] user: danielk1977 branch: trunk, size: 19277) | |
|
2005-09-08
| ||
| 20:37 | [dea71f4b05] part of check-in [6281859425] SUM returns NULL when it has no inputs. Ticket #1413. (CVS 2678) (check-in: [6281859425] user: drh branch: trunk, size: 19005) | |
| 10:37 | [f85ee0db54] part of check-in [21adf4bd99] 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) (check-in: [21adf4bd99] user: drh branch: trunk, size: 18767) | |
|
2005-03-29
| ||
| 03:10 | [f671b922c8] part of check-in [c41d55443c] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (check-in: [c41d55443c] user: danielk1977 branch: trunk, size: 18775) | |
|
2005-01-29
| ||
| 08:32 | [cbc8fe3775] part of check-in [b1b50f3158] Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286) (check-in: [b1b50f3158] user: danielk1977 branch: trunk, size: 18526) | |
|
2005-01-21
| ||
| 15:52 | [cf497cd1ce] part of check-in [17122c7e8e] Final preparations for the 3.1.0 alpha release. (CVS 2255) (check-in: [17122c7e8e] user: drh branch: trunk, size: 18522) | |
| 04:25 | [52ae910978] part of check-in [d4e19efcef] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) (check-in: [d4e19efcef] user: danielk1977 branch: trunk, size: 18524) | |
|
2004-11-22
| ||
| 08:43 | [534390be50] part of check-in [711e8d7695] Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132) (check-in: [711e8d7695] user: danielk1977 branch: trunk, size: 18095) | |
|
2004-11-04
| ||
| 14:47 | [cbf5da84a2] part of check-in [158a2d16a8] All tests pass when SQLITE_OMIT_INTEGRITY_CHECK is defined. (CVS 2055) (check-in: [158a2d16a8] user: drh branch: trunk, size: 18051) | |
|
2004-10-31
| ||
| 02:22 | [fec8f9091f] part of check-in [be661acfa8] Insert #ifdefs that can optionally remove features at compiletime resulting in a database engine with a smaller footprint. (CVS 2034) (check-in: [be661acfa8] user: drh branch: trunk, size: 18247) | |
|
2004-08-20
| ||
| 18:34 | [a5d06e6e8e] part of check-in [e97c331362] Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) (check-in: [e97c331362] user: drh branch: trunk, size: 18199) | |
|
2003-11-27
| ||
| 00:48 | [0767ab30cb] part of check-in [72bf73b2c1] Disallow temporary indices on persistent tables. (CVS 1122) (check-in: [72bf73b2c1] user: drh branch: trunk, size: 18039) | |
|
2003-08-05
| ||
| 13:13 | [22aa0519ae] part of check-in [086aa1c992] Provide a more informative error message when a uniqueness constraint fails. Ticket #419. (CVS 1068) (check-in: [086aa1c992] user: drh branch: trunk, size: 18105) | |
|
2003-06-15
| ||
| 23:42 | [b17223c35f] part of check-in [c9734c2707] 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) (check-in: [c9734c2707] user: drh branch: trunk, size: 18141) | |
|
2003-05-17
| ||
| 17:35 | [00ceb8aff6] part of check-in [01398fb78b] 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) (check-in: [01398fb78b] user: drh branch: trunk, size: 18153) | |
|
2003-04-24
| ||
| 01:45 | [adf6a9cfd7] part of check-in [206b17397b] Fix some issues with INSTEAD OF triggers. (CVS 930) (check-in: [206b17397b] user: drh branch: trunk, size: 17642) | |
|
2003-02-15
| ||
| 23:09 | [ab4c743bb9] part of check-in [3ef0ad8a4f] Fix the pager so that correct rollbacks occur when synchronous is turned off. This check-in also included unrelated documentation updates. (CVS 866) (check-in: [3ef0ad8a4f] user: drh branch: trunk, size: 15516) | |
|
2003-01-29
| ||
| 18:46 | [592daa956d] part of check-in [ccc82f1ab4] Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) (check-in: [ccc82f1ab4] user: drh branch: trunk, size: 15416) | |
|
2002-09-14
| ||
| 12:04 | [ee346d8c61] part of check-in [6cb80ae10a] 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) (check-in: [6cb80ae10a] user: drh branch: trunk, size: 15350) | |
|
2002-08-13
| ||
| 00:01 | [19070bdb7c] part of check-in [34c4149eea] Updates prior to release 2.6.3. (CVS 706) (check-in: [34c4149eea] user: drh branch: trunk, size: 15194) | |
|
2002-07-21
| ||
| 23:09 | [f739876942] part of check-in [c080ed01ea] UPDATE triggers on TEMP tables were broken. (CVS 693) (check-in: [c080ed01ea] user: danielk1977 branch: trunk, size: 15195) | |
|
2002-05-28
| ||
| 06:55 | [c12759a0d7] part of check-in [5e74d0964b] Update trigger2.test to match checkin 591. Also fix ticket #51 (by documenting problem) (CVS 595) (check-in: [5e74d0964b] user: danielk1977 branch: trunk, size: 15160) | |
|
2002-05-26
| ||
| 20:54 | [7f2b0a9b20] part of check-in [9051173742] 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) (check-in: [9051173742] user: drh branch: trunk, size: 15123) | |
|
2002-05-23
| ||
| 00:30 | [2d23ad8a7e] part of check-in [275ba356f3] Do not allow triggers on the SQLITE_MASTER table. (CVS 579) (check-in: [275ba356f3] user: drh branch: trunk, size: 15039) | |
|
2002-05-15
| ||
| 08:30 | Added: [662818d5cc] part of check-in [794bf67b6b] Added FOR EACH ROW triggers functionality (CVS 562) (check-in: [794bf67b6b] user: danielk1977 branch: trunk, size: 15010) | |