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

Converting NEW and OLD rows in triggers to JSON

    XMLWordPrintable

Details

    Description

      It would be great for e.g. auditing purposes, if it were possible, to convert NEW and OLD in triggers to a JSON string with something like JSON_OBJECT(OLD) or JSON_OBJECT(NEW) - or a new function.

      Similar bug report (by others) for MySQL: https://bugs.mysql.com/bug.php?id=89366

      In PostgeSQL, row_to_json(NEW) would work.

      Attachments

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34723 NEW and OLD in a trigger as row variables

          • Critical - Crashes, loss of data, severe memory leak.
          • In Review

          Activity

            People

              Unassigned Unassigned
              warp Markus Peter
              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.