Comments - MariaDB 10.1.21 silently skipping INSERTs

7 years, 1 month ago Christian Rishøj

It turns out that the following trigger causes the INSERT to silently fail:

CREATE TRIGGER `beforeSupplierItemsInsert`
BEFORE INSERT ON `supplierItems`
FOR EACH ROW
  BEGIN

    IF NEW.status = 'expired' THEN
      SET NEW.dateExpired = UNIX_TIMESTAMP();
    END IF;

    IF NOT NEW.dateUpdated THEN
      SET NEW.dateUpdated = UNIX_TIMESTAMP();
    END IF;

  END
 
7 years, 1 month ago Christian Rishøj

The issue is reproducible with the given trigger.

Bug report filed: https://jira.mariadb.org/browse/MDEV-12100

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.