MySQL Bugs MySQL AB Bugs Database http://bugs.mysql.com/ MySQL Bugs http://bugs.mysql.com/images/mysql_100x52-64.gif http://bugs.mysql.com/ http://bugs.mysql.com/24489 #24489: @@sql_select_limit applies to stored functions, triggers, events http://bugs.mysql.com/bug.php?id=24489 Submitted by: Konstantin Osipov
Category: Server: SP
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0 BK, 5.1 BK
]]> Tue, 21 Nov 2006 22:16:39 +0000 Server: SP http://bugs.mysql.com/44681 #44681: 2 command trigger causes error 1340 .Configuration file ...is too big http://bugs.mysql.com/bug.php?id=44681 Submitted by: N Bernhardt
Category: Server: SP
Status: Verified
Severity: 2
OS: Linux (Any)
Version: 5.0.82, 5.0, 5.1 bzr
]]> Wed, 06 May 2009 01:27:29 +0000 Server: SP http://bugs.mysql.com/54646 #54646: SHOW PROFILES doesn't work for UPDATEs with triggers http://bugs.mysql.com/bug.php?id=54646 Submitted by: Vojtech Kurka
Category: Server: Logging
Status: Verified
Severity: 3
OS: Any
Version: 5.1.47, 5.1.48
]]> Sun, 20 Jun 2010 21:41:36 +0000 Server: Logging http://bugs.mysql.com/60300 #60300: Corrupted values using variable of type TEXT in trigger or stored procedure http://bugs.mysql.com/bug.php?id=60300 Submitted by: Roland Volkmann
Category: Server: SP
Status: Verified
Severity: 2
OS: Windows (XP Prof.)
Version: 5.5.9
]]> Wed, 02 Mar 2011 01:30:55 +0000 Server: SP http://bugs.mysql.com/71060 #71060: INSERT-SELECT statement takes shared locks in trigger and causes deadlock http://bugs.mysql.com/bug.php?id=71060 Submitted by: Sadao Hiratsuka
Category: Server: Locking
Status: Verified
Severity: 2
OS: Any
Version: 5.6.15, 5.6.16, 5.5.35, 5.1.74
]]> Tue, 03 Dec 2013 14:08:29 +0000 Server: Locking http://bugs.mysql.com/70598 #70598: Premature expression evaluation prevents short-circuited conditionals http://bugs.mysql.com/bug.php?id=70598 Submitted by: Christopher Shumake
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (.6.18-348.16.1.el5)
Version: 5.5.32,5.5.34, 5.6.14, 5.7.2
]]> Thu, 10 Oct 2013 22:19:06 +0000 Server: Optimizer http://bugs.mysql.com/73399 #73399: BEFORE INSERT TRIGGER not fired http://bugs.mysql.com/bug.php?id=73399 Submitted by: Shamshinur Taktayeva
Category: Server: SP
Status: Verified
Severity: 1
OS: Any
Version: 5.6.14, 5.0.97, 5.1.74, 5.5.39, 5.6.21, 5.7.5
]]> Fri, 25 Jul 2014 18:32:49 +0000 Server: SP http://bugs.mysql.com/69828 #69828: Missleading error message if trigger fails http://bugs.mysql.com/bug.php?id=69828 Submitted by: Normann Koldrack
Category: Server: Errors
Status: Verified
Severity: 3
OS: Any
Version: 5.5.32, 5.6.24
]]> Tue, 23 Jul 2013 13:29:24 +0000 Server: Errors http://bugs.mysql.com/78763 #78763: mysqldump with --add-drop-trigger option when trigger name contains dots http://bugs.mysql.com/bug.php?id=78763 Submitted by: Valeriy Kravchuk
Category: Client: mysqldump
Status: Verified
Severity: 3
OS: Any
Version: 5.6/5.7
]]> Thu, 08 Oct 2015 16:22:09 +0000 Client: mysqldump http://bugs.mysql.com/83242 #83242: Improve diagnostics for non-SUPER DEFINER trigger blocking --read_only=ON update http://bugs.mysql.com/bug.php?id=83242 Submitted by: Robert Wunderer
Category: Server: Errors
Status: Verified
Severity: 3
OS: Any
]]> Mon, 03 Oct 2016 07:19:01 +0000 Server: Errors http://bugs.mysql.com/76715 #76715: Different behavior of LAST_INSERT_ID() function within a trigger AFTER INSERT http://bugs.mysql.com/bug.php?id=76715 Submitted by: William Chiquito
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.0, 5.1+
]]> Wed, 15 Apr 2015 17:08:49 +0000 Server: DML http://bugs.mysql.com/91585 #91585: “dead” code inside the stored proc or function can significantly slow it down http://bugs.mysql.com/bug.php?id=91585 Submitted by: Alexander Rubin
Category: Server: SP
Status: Verified
Severity: 5
OS: Any
Version: 5.7, 8.0, 8.0.11, 5.7.23
]]> Tue, 10 Jul 2018 01:16:28 +0000 Server: SP http://bugs.mysql.com/94929 #94929: Generated column vs before insert trigger calculation order http://bugs.mysql.com/bug.php?id=94929 Submitted by: Power Gamer
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 8.0.15, 5.7.25
]]> Sun, 07 Apr 2019 08:38:24 +0000 Server: DML http://bugs.mysql.com/117256 #117256: Repeating uncaused error "Column cannot be null" after single error on table with trigger http://bugs.mysql.com/bug.php?id=117256 Submitted by: Mike Amromin
Category: Server: InnoDB
Status: Verified
Severity: 2
OS: Any
Version: 8.4.4
]]> Tue, 21 Jan 2025 13:19:44 +0000 Server: InnoDB