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

Server Crash When Using a Trigger With A Number of Virtual Columns on INSERT/UPDATE

    XMLWordPrintable

Details

    Description

      When you have a table that has 9 (or more) virtual columns, with any type (tested VARCHAR and INT) or expression (initially found the bug where JSON_VALID was used, then tested with referring to another column or just a constant expression) and a BEFORE INSERT or BEFORE UPDATE trigger (with any content or where the trigger is empty); then any INSERT or UPDATE will crash the server; even if the trigger is a BEFORE INSERT trigger and an UPDATE is run, or the other way round, or an INSERT is run with the trigger being a BEFORE INSERT trigger, etc.

      In the event that the INSERT is done via an INSERT INTO ... SELECT statement, no crash occurs.

      Attachments

        1. setup.sql
          2 kB
          Robert Humphries
        2. setup.txt
          3 kB
          Robert Humphries
        3. test1.txt
          6 kB
          Robert Humphries
        4. test2.txt
          6 kB
          Robert Humphries
        5. test3.txt
          6 kB
          Robert Humphries
        6. test4.txt
          6 kB
          Robert Humphries
        7. tests.sql
          0.3 kB
          Robert Humphries

        Activity

          People

            nikitamalyavin Nikita Malyavin
            rmhumphries Robert Humphries
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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