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

Problem trigger with OLD. or NEW. values usage

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4.11, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL), 10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 12.2
    • 10.6, 10.11, 11.4, 11.8, 12.3
    • Server, Stored routines
    • None
    • Any

    Description

      Have trigger functionality for data "change log" collecting in separate table.
      Trigger compares OLD. with NEW. and changes are inserted into H table.

      This works correctly with MySQL (5.6, 8.0 atleast).

      In MariaDB this does not work.

      Script provided shoud produce 4+5+4 rows in H table, and should not end up with error
      Unknown column 'I4' in 'field list'

      Now works only middle part of trigger - with removed WHERE clause.

      Attachments

        Activity

          People

            shulga Dmitry Shulga
            eimix Eimantas
            Votes:
            0 Vote for this issue
            Watchers:
            6 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.