[MDEV-10002] Before Insert trigger does not work with NOT NULL columns Created: 2016-04-27  Updated: 2019-06-14  Resolved: 2016-04-27

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Update
Affects Version/s: 10.1.6
Fix Version/s: 10.1.10

Type: Bug Priority: Major
Reporter: Marek Assignee: Sergei Golubchik
Resolution: Duplicate Votes: 0
Labels: None
Environment:

OpenSuse 13.1 x64

Issue Links:
Duplicate
is duplicated by MDEV-8605 MariaDB not use DEFAULT value even wh... Closed
Relates
relates to MDEV-11698 Old Bug possibly not fixed; BEFORE IN... Closed
relates to MDEV-19761 Before Trigger not processed for Not ... Open

 Description   

Basically this bug was present for a long time in MySQL: http://bugs.mysql.com/bug.php?id=6295
Even if there is before insert trigger defined that replaces NOT NULL value, new value can not be inserted into the table.

Tested on OpenSuse 13.1, MariaDB 10.1.6.

 Comments   
Comment by Sergei Golubchik [ 2016-04-27 ]

It was fixed in 10.1.10, see MDEV-8605

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