History log of /sqlite-3.40.0/test/trigger2.test (Results 1 – 25 of 32)
Revision (<<< Hide revision tags) (Show revision tags >>>) Date Author Comments
Revision tags: release, version-3.50.2, version-3.50.1, major-release, version-3.50.0, version-3.49.2, patch-release, version-3.44.4, version-3.49.1, version-3.49.0, major-relase, relase, version-3.48.0, version-3.47.2, version-3.47.1, version-3.47.0, version-3.46.1, version-3.46.0, version-3.45.3, version-3.44.3, version-3.45.2, version-3.45.1, vesion-3.45.1, version-3.45.0, version-3.44.2, version-3.44.1, version-3.44.0, version-3.43.2, version-3.43.1, version-3.43.0, version-3.42.0, version-3.41.2, version-3.41.1, version-3.41.0, version-3.40.1, version-3.40.0, version-3.39.4, version-3.39.3, version-3.39.2, version-3.39.1, version-3.39.0, version-3.38.5, version-3.38.4, relese, version-3.38.3, version-3.38.2, version-3.38.1, version-3.38.0, version-3.37.2, version-3.37.1, version-3.37.0, version-3.36.0
# fe599b05 21-Apr-2021 dan <Dan Kennedy>

Fix a problem allowing SQL variables to be used expressions within the second and subsequent ON CONFLICT clauses of an UPSERT within a trigger.

FossilOrigin-Name: 2a28910a17dc5b3ce43062fdf879f9622f6

Fix a problem allowing SQL variables to be used expressions within the second and subsequent ON CONFLICT clauses of an UPSERT within a trigger.

FossilOrigin-Name: 2a28910a17dc5b3ce43062fdf879f9622f6ec2db19ed780fa7fe5cae781be7b7

show more ...


Revision tags: version-3.35.5, version-3.35.4, version-3.35.3, same-as-3.35.3, version-3.35.2, version-3.35.1, version-3.35.0, patch, version-3.34.1, version-3.34.0, version-3.33.0, version-3.32.3, version-3.32.2, version-3.32.1, version-3.32.0, version-3.31.1, version-3.31.0
# 03836614 02-Nov-2019 drh <[email protected]>

Fix a problem in VIEW creation that was introduced by the generated columns
feature.

FossilOrigin-Name: 9c795c4d2b042d2932774bd1274fa0167ca2dc9838e127e0cf31eb9273a32f2c


Revision tags: version-3.30.1, version-3.30.0, version-3.29.0, version-3.28.0, version-3.27.2, version-3.27.1, version-3.27.0, version-3.26.0, version-3.25.3, version-3.25.2, version-3.25.1, version-3.25.0, version-3.24.0, version-3.23.2, version-3.23.1, version-3.23.0, version-3.22.0, version-3.21.0, version-3.20.1, version-3.19.4, version-3.20.0, version-3.18.2, version-3.18.1, version-3.19.3, version-3.19.2, version-3.19.1, version-3.19.0, version-3.18.0, version-3.17.0, version-3.16.2, version-3.16.1, version-3.16.0, version-3.15.2, version-3.15.1, version-3.15.0, version-3.14.2, version-3.14.1, version-3.14.0, version-3.13.0, version-3.12.2, version-3.12.1, version-3.9.3, version-3.12.0, version-3.11.1, version-3.11.0, version-3.10.2, version-3.10.1, version-3.10.0, version-3.9.2, version-3.9.1, version-3.9.0, version-3.8.11.1, version-3.8.11, version-3.8.10.2, version-3.8.10.1, version-3.8.10, version-3.8.9, version-3.8.8.3, version-3.8.8.2, version-3.8.8.1, version-3.8.8, version-3.8.7.4, version-3.8.7.3, version-3.8.7.2, version-3.8.7.1, version-3.8.6.1, version-3.8.7, version-3.8.6, version-3.8.5, version-3.8.4.3, version-3.8.4.2, version-3.8.4.1, version-3.8.4, version-3.8.3.1, version-3.8.3, version-3.8.2
# f9c8ce3c 05-Nov-2013 drh <[email protected]>

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.

FossilOrigin-Name

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.

FossilOrigin-Name: 54b221929744b1bcdbcc2030fef2e510618afd41

show more ...


# 00012df4 05-Nov-2013 drh <[email protected]>

Add the conflict2.test script. Fix issues discovered by this script.

FossilOrigin-Name: 294ed33756b06375e56c41f1088d42ee48adbdc8


Revision tags: version-3.8.1, version-3.8.0.2, version-3.8.0.1, version-3.8.0, version-3.7.17, version-3.7.16.2, version-3.7.16.1, version-3.7.16, version-3.7.15.2, version-3.7.15.1, version-3.7.15, version-3.7.14.1, version-3.7.14, version-3.7.13, version-3.7.12.1, version-3.7.12, mountain-lion, version-3.7.11, version-3.7.10, version-3.7.9, version-3.7.8, version-3.7.7.1, version-3.7.7, version-3.7.6.3, version-3.7.6.2, version-3.7.6.1, version-3.7.6, version-3.7.5, version-3.7.4, experimental, version-3.7.2, fts3-refactor
# 5bde73c4 01-Sep-2009 dan <[email protected]>

Change "PRAGMA disable_recursive_triggers" to "PRAGMA recursive_triggers". Also a fix for compiling with OMIT_TRIGGER defined.

FossilOrigin-Name: e016cca36390451d5d1c6e0d1b3cdbd6d869be1a


# 76d462ee 30-Aug-2009 dan <[email protected]>

Fixes for new triggers scheme.

FossilOrigin-Name: 9eb91efda5241609ff18ff15ef5eaa0e86788eab


Revision tags: cvs-to-fossil-cutover, version-3.6.15, version-3.6.10
# f7300753 21-Nov-2008 danielk1977 <[email protected]>

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)

FossilOrigin-Name: 88a09dbb4b54be4010aae767

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)

FossilOrigin-Name: 88a09dbb4b54be4010aae767157a1e2002237909

show more ...


# 3bdca9c9 17-Jan-2006 danielk1977 <[email protected]>

Test suite fixes for builds that define OMIT symbols. (CVS 2962)

FossilOrigin-Name: 3a54a33dcb7e765ee3773397407e8929a8cfe1a9


# c2bd913a 08-Sep-2005 drh <[email protected]>

SUM returns NULL when it has no inputs. Ticket #1413. (CVS 2678)

FossilOrigin-Name: 6281859425d39c11d82875301fefafad1f08416d


# 3d1d95e6 08-Sep-2005 drh <[email protected]>

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)

FossilOrigin-Name: 21adf4b

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)

FossilOrigin-Name: 21adf4bd99e732650a1e8e9a1cc954126983a654

show more ...


# 53c0f748 29-Mar-2005 danielk1977 <[email protected]>

Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427)

FossilOrigin-Name: c41d55443c2dd532147962b87f542fb7d37075fd


# b3bce662 29-Jan-2005 danielk1977 <[email protected]>

Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286)

FossilOrigin-Name: b1b50f315873a8614920d1e3af4a07fb29a7ff6a


# 7bf56610 21-Jan-2005 drh <[email protected]>

Final preparations for the 3.1.0 alpha release. (CVS 2255)

FossilOrigin-Name: 17122c7e8e9cae36f1ffa7b42bd69d702980ac6a


# e61b9f4f 21-Jan-2005 danielk1977 <[email protected]>

Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252)

FossilOrigin-Name: d4e19efcef68d834c55c7d496cdb3696d63a31a2


# 0fa8ddbd 22-Nov-2004 danielk1977 <[email protected]>

Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132)

FossilOrigin-Name: 711e8d7695dfc74b3f1ee00591dcdda2cd7fc7d5


# 40e016e4 04-Nov-2004 drh <[email protected]>

All tests pass when SQLITE_OMIT_INTEGRITY_CHECK is defined. (CVS 2055)

FossilOrigin-Name: 158a2d16a8630e3b5892120f6ea68f2b0dc47eb3


# b7f9164e 31-Oct-2004 drh <[email protected]>

Insert #ifdefs that can optionally remove features at compiletime resulting
in a database engine with a smaller footprint. (CVS 2034)

FossilOrigin-Name: be661acfa849bb0d5692797dd221f5a8a457f8ad


# 92febd92 20-Aug-2004 drh <[email protected]>

Tcl interface transfers values directly between SQLite and Tcl_Objs, without
at translation to strings. (CVS 1898)

FossilOrigin-Name: e97c331362545ce21117776c7b61d3488668f2bf


# 4925ca00 27-Nov-2003 drh <[email protected]>

Disallow temporary indices on persistent tables. (CVS 1122)

FossilOrigin-Name: 72bf73b2c1e3594aa85920e47fc345bba56c80d0


# 37ed48ed 05-Aug-2003 drh <[email protected]>

Provide a more informative error message when a uniqueness constraint
fails. Ticket #419. (CVS 1068)

FossilOrigin-Name: 086aa1c9922b7bf399b3ee8b73ba7353d126b119


# ed717fe3 15-Jun-2003 drh <[email protected]>

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

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)

FossilOrigin-Name: c9734c27074d2039a1896a8c6965c08d03711b13

show more ...


# 8bf8dc92 17-May-2003 drh <[email protected]>

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)

FossilOrigin-Name: 01398f

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)

FossilOrigin-Name: 01398fb78bab7e5c6f439f2b743f26e82118468a

show more ...


# 5cf590c1 24-Apr-2003 drh <[email protected]>

Fix some issues with INSTEAD OF triggers. (CVS 930)

FossilOrigin-Name: 206b17397b1d2b55179c935927ff1d8215728c32


# 4303feed 15-Feb-2003 drh <[email protected]>

Fix the pager so that correct rollbacks occur when synchronous is turned off.
This check-in also included unrelated documentation updates. (CVS 866)

FossilOrigin-Name: 3ef0ad8a4f2696a58aff9d812f900

Fix the pager so that correct rollbacks occur when synchronous is turned off.
This check-in also included unrelated documentation updates. (CVS 866)

FossilOrigin-Name: 3ef0ad8a4f2696a58aff9d812f90038c2c63f3fc

show more ...


# 483750ba 29-Jan-2003 drh <[email protected]>

Better error messages on constraint violations. Additional tests and bug fixes
for the callback-free API. (CVS 854)

FossilOrigin-Name: ccc82f1ab4539a60ee5cc2625743c5389f9ccd8e


12