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

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

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: