MariaDB & MySQL - Trigger not firing: “Field '__' doesn't have a default value” (Old Bug not really fixed?)
I opened a ticket with MariaDB. They have confirmed that it's still broken, and it has been put in the backlog to fix it.

Update:

The ticket has been fixed in MariaDB versions: 10.1.21 &amp; 10.2.4