Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12151

Support for INSTEAD OF triggers

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • 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/

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          balta Tadas Balaišis created issue -
          serg Sergei Golubchik made changes -
          Field Original Value New Value
          Priority Minor [ 4 ] Major [ 3 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 79781 ] MariaDB v4 [ 130605 ]
          monty Michael Widenius made changes -
          Description Are there any plans to implement INSTEAD OF triggers for views? 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/

          People

            Unassigned Unassigned
            balta Tadas Balaišis
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.