Bug #11118 | INSERT inside a trigger succeeds regardless of NOT NULL constraint | ||
---|---|---|---|
Submitted: | 6 Jun 2005 17:31 | Modified: | 6 Jun 2005 17:43 |
Reporter: | Guillaume Lebur | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.0.6-beta | OS: | Windows (Windows XP / SP2) |
Assigned to: | CPU Architecture: | Any |
[6 Jun 2005 17:31]
Guillaume Lebur
[6 Jun 2005 17:43]
MySQL Verification Team
Testing against current Bk source, this issue don't exists anymore. Thank you for the bug report: mysql> CREATE TRIGGER TGR_BI_EQUIPE BEFORE INSERT ON equipe FOR EACH ROW -> BEGIN -> SET new.nom=null; -> END // Query OK, 0 rows affected (0.01 sec) mysql> delimiter ; mysql> INSERT INTO equipe (nom, stade, ville) VALUES ('x', 'y', 'z'); ERROR 1048 (23000): Column 'nom' cannot be null