History log of /sqlite-3.40.0/test/triggerC.test (Results 1 – 22 of 22)
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, 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, version-3.30.1, version-3.30.0
# 175b8f06 08-Aug-2019 drh <[email protected]>

Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
exist. STAT4 continues to work as it always has, and as it is a superset of
STAT3 is the recommended replacement.

FossilOrigi

Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
exist. STAT4 continues to work as it always has, and as it is a superset of
STAT3 is the recommended replacement.

FossilOrigin-Name: 1e17ea2fd1df4ad49138c787c8fe3207dd0c25c93f9001d52a9b69f8c12e841c

show more ...


Revision tags: version-3.29.0, version-3.28.0
# b84b38fd 04-Apr-2019 dan <[email protected]>

Add test cases to improve coverage of VDBE branches. Still some to go.

FossilOrigin-Name: 4cef609d61de272cfdc2b39e1d49c7cd56ec834086bd63095116ff98f4d402bd


Revision tags: version-3.27.2, version-3.27.1, version-3.27.0
# 16dd3985 20-Dec-2018 dan <[email protected]>

Fix a segfault caused by using the RAISE function incorrectly (library now
returns an error instead of crashing).

FossilOrigin-Name: ddf06db702761d663119d508afe21d7dfebe963d576bb42fc2f2024205ab86f8


Revision tags: 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
# 46408354 21-Apr-2015 dan <[email protected]>

Ensure that tables names are dequoted exactly once by the trigger logic.

FossilOrigin-Name: 9d887b92f8086961e045f8acb9ee7a443796d411


Revision tags: 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 ...


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
# f78baafe 06-Dec-2012 dan <[email protected]>

Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements. Candidate fix for [ae3c5670b6].

FossilOrigin-Name: 0c31a46801746191d1a53332d75beda

Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements. Candidate fix for [ae3c5670b6].

FossilOrigin-Name: 0c31a46801746191d1a53332d75beda880fe1fd7

show more ...


Revision tags: version-3.7.14.1
# 3f4d1d1b 15-Sep-2012 drh <[email protected]>

Attempt to use a covering index even on a full table scan, under the theory
that the index will be smaller and require less disk I/O and thus be faster.

FossilOrigin-Name: cfaa7bc12847a7006ccc93815f

Attempt to use a covering index even on a full table scan, under the theory
that the index will be smaller and require less disk I/O and thus be faster.

FossilOrigin-Name: cfaa7bc12847a7006ccc93815f2395ad5259744a

show more ...


Revision tags: 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
# fda06bef 02-Aug-2011 mistachkin <[email protected]>

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

FossilOrigin-Name: 9007586fdabed8dbcc78581ea9821cfd1f

Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried.

FossilOrigin-Name: 9007586fdabed8dbcc78581ea9821cfd1f9a4c8c

show more ...


Revision tags: version-3.7.7.1, version-3.7.7
# f9032cbc 22-Jun-2011 shaneh <[email protected]>

Adjust a test case in triggerC.test to handle non-default SQLITE_MAX_TRIGGER_DEPTH settings.

FossilOrigin-Name: f14339c54bdeabc68c1e05b2c63ee95226f184e0


Revision tags: version-3.7.6.3, version-3.7.6.2
# 35913a49 17-Apr-2011 shaneh <[email protected]>

Adjust some test cases in triggerC.test to handle non-default SQLITE_MAX_TRIGGER_DEPTH settings.

FossilOrigin-Name: 9d6c6129fd8be42c164f14bb90011b252c1f2c46


Revision tags: version-3.7.6.1, version-3.7.6, version-3.7.5, version-3.7.4
# 27106570 01-Dec-2010 dan <[email protected]>

Avoid recursive calls to sqlite3VdbeMemRelease() when deleting VM frames used by trigger programs.

FossilOrigin-Name: 119ffe955eb1e8016cb8131a63bd17557f395f3f


Revision tags: experimental, version-3.7.2
# 98530cac 14-Aug-2010 dan <[email protected]>

Test that it is possible to drop a trigger while there are active statements belonging to the same connection.

FossilOrigin-Name: d4ec61e2547200aa92a26c1f270682ed67edc241


# 7ba45971 30-Mar-2010 dan <[email protected]>

Do not crash when compiling an "INSERT INTO tbl DEFAULT VALUES" when tbl has either BEFORE or INSTEAD OF triggers attached to it. Ticket [f3162063fd].

FossilOrigin-Name: ca359a3e8048bd11605c41c4b481

Do not crash when compiling an "INSERT INTO tbl DEFAULT VALUES" when tbl has either BEFORE or INSTEAD OF triggers attached to it. Ticket [f3162063fd].

FossilOrigin-Name: ca359a3e8048bd11605c41c4b48134c0343e543b

show more ...


# bb5f168f 27-Nov-2009 dan <[email protected]>

Move [7d30880114] to the trunk. Add optimizations to reduce the number of opcodes used for BEFORE UPDATE triggers.

FossilOrigin-Name: 1b7c5250ccb63182324bfc3f1ea28f17b6db357a


Revision tags: fts3-refactor
# 07fcc268 08-Oct-2009 dan <[email protected]>

Update triggerC.test to match the change to the way the trigger-recursion limit is handled.

FossilOrigin-Name: 5806925283b889867567c4ad92518bad000e9d9d


# 3991bb0d 17-Sep-2009 drh <[email protected]>

When coding a trigger, assume that the "oldmask" requires all columns until
we know otherwise. That pessimistic assumption assures that all necessary
parameters are available on a cascading delete t

When coding a trigger, assume that the "oldmask" requires all columns until
we know otherwise. That pessimistic assumption assures that all necessary
parameters are available on a cascading delete trigger.
Ticket [e25d9ea771f]

FossilOrigin-Name: 03e464be51a1c36fc02cf31178ae91f736dfddd6

show more ...


# ae0931ed 09-Sep-2009 dan <[email protected]>

Add some tests that involve BEFORE UPDATE or BEFORE DELETE triggers messing with the row being updated or deleted. SQLite behaviour in this scenario is undefined, so the tests just check that the beh

Add some tests that involve BEFORE UPDATE or BEFORE DELETE triggers messing with the row being updated or deleted. SQLite behaviour in this scenario is undefined, so the tests just check that the behaviour is relatively sane and there are no crashes.

FossilOrigin-Name: 9a4c59a2ddd0df2d9425097004b450a6685f2147

show more ...


# e0af83ac 08-Sep-2009 dan <[email protected]>

Combine the OP_Statement and OP_Transaction opcodes.

FossilOrigin-Name: aec9dbd8d21c55c3945287a3dfa55d3ed168f977


# 2283d46c 08-Sep-2009 dan <[email protected]>

If recursive-triggers are enabled, fire DELETE triggers if database rows are removed as a result of OR REPLACE conflict resolution.

FossilOrigin-Name: 85cb0c94a63eda5f059ebe40887c7af9b4869893


# 417168ad 07-Sep-2009 drh <[email protected]>

Add the SQLITE_LIMIT_TRIGGER_DEPTH option to sqlite3_limit().

FossilOrigin-Name: d7dc8b433691745b3842282569f1573d1e057963


# 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


# 436355a0 01-Sep-2009 dan <[email protected]>

Add new test script triggerC.test.

FossilOrigin-Name: a2a062a4b52f45af85c195582a36d1b76d2675db