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. tests.sql
          0.3 kB
          Robert Humphries
        2. test4.txt
          6 kB
          Robert Humphries
        3. test3.txt
          6 kB
          Robert Humphries
        4. test2.txt
          6 kB
          Robert Humphries
        5. test1.txt
          6 kB
          Robert Humphries
        6. setup.txt
          3 kB
          Robert Humphries
        7. setup.sql
          2 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.