[MDEV-11951] Triggers doesn't work Created: 2017-01-31  Updated: 2017-03-02  Resolved: 2017-03-02

Status: Closed
Project: MariaDB Server
Component/s: Triggers
Affects Version/s: 10.1.21
Fix Version/s: 10.1.22, 10.2.5

Type: Bug Priority: Blocker
Reporter: azurit Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None
Environment:

Debian Jessie, 64bit

Attachments: File outbox.sql    
Issue Links:
Duplicate
is duplicated by MDEV-11842 Fail to insert on a table where a fie... Closed
Sprint: 10.1.22

 Description   

After upgrade to 10.1.21, triggers (maybe not all) stopped working, downgrading to 10.1.20 fixed the problem. Attaching table and trigger definition, here is SQL command:
insert into outbox (`UDH`,`SendingDateTime`,`DestinationNumber`,`TextDecoded`,`MultiPart`,`SenderID`) values ('','','0900123123','test','false','');

The result is that NOTHING is inserted into table and no errors or warnings are reported. Maybe it's related to MDEV-11698 (the only thing related to triggers in 10.1.21 changelog)?

 Comments   
Comment by Elena Stepanova [ 2017-02-01 ]

Thanks for the report. We have a couple already, MDEV-11842 and MDEV-11886.
Keeping this one open as well, so that all test cases are checked after the bug is fixed.

Generated at Thu Feb 08 07:53:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.