[MDEV-12151] Support for INSTEAD OF triggers Created: 2017-02-28  Updated: 2022-05-25

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Major
Reporter: Tadas BalaiĊĦis Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: None


 Description   

Are there any plans to implement INSTEAD OF triggers for views?

An INSTED OF trigger is code that is executed instead of an INSERT, DELETE or UPDATE statement.
This works for both tables and views.

Syntax:

CREATE TRIGGER [schema_name.] trigger_name
ON

{table_name | view_name }

INSTEAD OF

{[INSERT] [,] [UPDATE] [,] [DELETE] }

AS

{sql_statements}

You can find some documentation about this at:
https://www.sqlservertutorial.net/sql-server-triggers/sql-server-instead-of-trigger/
https://www.oracletutorial.com/plsql-tutorial/oracle-instead-of-triggers/


Generated at Thu Feb 08 07:55:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.