Wikiservice: Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference

2026-08-28T09:59:40Z

Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference

← Older revision		Revision as of 11:59, 28 August 2026
Line 1:		Line 1:
	MemCP supports persistent BEFORE and AFTER triggers for INSERT, UPDATE, and DELETE. Trigger bodies can read <code>OLD</code> and <code>NEW<</code>, assign permitted <code>NEW</code> values, run conditional BEGIN/END bodies, and execute supported DML including <code>INSERT … SELECT</code>.		<!-- Copyright (C) 2026 Carl-Philip Haensch -->
			<!-- SPDX-License-Identifier: GPL-3.0-or-later -->
			= Triggers =

			MemCP supports persistent BEFORE and AFTER triggers for INSERT, UPDATE, and DELETE. Trigger bodies can read <code>OLD</code> and <code>NEW</code>, assign permitted <code>NEW</code> values, run conditional BEGIN/END bodies, and execute supported DML including <code>INSERT … SELECT</code>.

	Multiple triggers execute by registered priority. AFTER work may be configured as asynchronous, in which case its completion and failure are not identical to the originating statement's synchronous path. Trigger changes participate in transaction/savepoint recovery.		Multiple triggers execute by registered priority. AFTER work may be configured as asynchronous, in which case its completion and failure are not identical to the originating statement's synchronous path. Trigger changes participate in transaction/savepoint recovery.

	MemCP also uses hidden system triggers to enforce constraints and maintain computed columns, group caches, prejoins, and invalidation dependencies. User DROP/CASCADE behavior must not delete unrelated data; lifecycle callbacks are not general garbage collectors.		MemCP also uses hidden system triggers to enforce constraints and maintain computed columns, group caches, prejoins, and invalidation dependencies. [[Temporary Computed Columns]] explains how the storage engine analyzes generated Scheme computors and derives incremental, selective, or complete invalidation triggers automatically. User DROP/CASCADE behavior must not delete unrelated data; lifecycle callbacks are not general garbage collectors.

	Test trigger persistence across restart, multi-row statements, NULL/default handling, errors, ordering, cross-table writes, and rollback. Recursive trigger graphs should be treated with particular care.		Test trigger persistence across restart, multi-row statements, NULL/default handling, errors, ordering, cross-table writes, and rollback. Recursive trigger graphs should be treated with particular care.

Carli: Created page with "MemCP supports persistent BEFORE and AFTER triggers for INSERT, UPDATE, and DELETE. Trigger bodies can read `OLD` and `NEW<`, assign permitted `NEW` values, run conditional BEGIN/END bodies, and execute supported DML including `INSERT … SELECT`. Multiple triggers execute by registered priority. AFTER work may be configured as asynchronous, in which case its completion and failure are not identical to the originating statemen..."

2026-08-21T11:03:47Z

Created page with "MemCP supports persistent BEFORE and AFTER triggers for INSERT, UPDATE, and DELETE. Trigger bodies can read <code>OLD</code> and <code>NEW<</code>, assign permitted <code>NEW</code> values, run conditional BEGIN/END bodies, and execute supported DML including <code>INSERT … SELECT</code>. Multiple triggers execute by registered priority. AFTER work may be configured as asynchronous, in which case its completion and failure are not identical to the originating statemen..."

New page

MemCP supports persistent BEFORE and AFTER triggers for INSERT, UPDATE, and DELETE. Trigger bodies can read <code>OLD</code> and <code>NEW<</code>, assign permitted <code>NEW</code> values, run conditional BEGIN/END bodies, and execute supported DML including <code>INSERT … SELECT</code>.

Multiple triggers execute by registered priority. AFTER work may be configured as asynchronous, in which case its completion and failure are not identical to the originating statement's synchronous path. Trigger changes participate in transaction/savepoint recovery.

MemCP also uses hidden system triggers to enforce constraints and maintain computed columns, group caches, prejoins, and invalidation dependencies. User DROP/CASCADE behavior must not delete unrelated data; lifecycle callbacks are not general garbage collectors.

Test trigger persistence across restart, multi-row statements, NULL/default handling, errors, ordering, cross-table writes, and rollback. Recursive trigger graphs should be treated with particular care.

Triggers - Revision history

Wikiservice: Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference