Showing all 15 (Edit, Save, CSV, Feed) |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
24489 | 2006-11-21 22:16 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6324 days) | S3 | 5.0 BK, 5.1 BK | Linux (Linux) | Any | @@sql_select_limit applies to stored functions, triggers, events |
44681 | 2009-05-06 1:27 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (5391 days) | S2 | 5.0.82, 5.0, 5.1 bzr | Linux (Any) | Any | 2 command trigger causes error 1340 .Configuration file ...is too big |
54646 | 2010-06-20 21:41 | 2011-02-16 23:44 | MySQL Server: Logging | Verified (5030 days) | S3 | 5.1.47, 5.1.48 | Any | Any | SHOW PROFILES doesn't work for UPDATEs with triggers |
60300 | 2011-03-02 1:30 | 2011-03-03 9:03 | MySQL Server: Stored Routines | Verified (4775 days) | S2 | 5.5.9 | Windows (XP Prof.) | Any | Corrupted values using variable of type TEXT in trigger or stored procedure |
71060 | 2013-12-03 14:08 | 2013-12-05 13:31 | MySQL Server: Locking | Verified (3769 days) | S2 | 5.6.15, 5.6.16, 5.5.35, 5.1.74 | Any | Any | INSERT-SELECT statement takes shared locks in trigger and causes deadlock |
70598 | 2013-10-10 22:19 | 2013-10-13 11:23 | MySQL Server: Optimizer | Verified (3820 days) | S3 | 5.5.32,5.5.34, 5.6.14, 5.7.2 | Linux (.6.18-348.16.1.el5) | Any | Premature expression evaluation prevents short-circuited conditionals |
73399 | 2014-07-25 18:32 | 2014-07-25 18:56 | MySQL Server: Stored Routines | Verified (3535 days) | S1 | 5.6.14, 5.0.97, 5.1.74, 5.5.39, 5.6.21, 5.7.5 | Any | Any | BEFORE INSERT TRIGGER not fired |
69828 | 2013-07-23 13:29 | 2015-07-04 22:38 | MySQL Server: Errors | Verified (3191 days) | S3 | 5.5.32, 5.6.24 | Any | Any | Missleading error message if trigger fails |
78763 | 2015-10-08 16:22 | 2015-10-08 17:02 | MySQL Server: mysqldump Command-line Client | Verified (3095 days) | S3 | 5.6/5.7 | Any | Any | mysqldump with --add-drop-trigger option when trigger name contains dots |
83242 | 2016-10-03 7:19 | 2016-10-03 8:07 | MySQL Server: Errors | Verified (2734 days) | S3 | Any | Any | Improve diagnostics for non-SUPER DEFINER trigger blocking --read_only=ON update | |
76715 | 2015-04-15 17:08 | 2018-03-19 22:38 | MySQL Server: DML | Verified (2212 days) | S3 | 5.0, 5.1+ | Any | Any | Different behavior of LAST_INSERT_ID() function within a trigger AFTER INSERT |
91585 | 2018-07-10 1:16 | 2018-08-27 11:06 | MySQL Server: Stored Routines | Verified (2089 days) | S5 | 5.7, 8.0, 8.0.11, 5.7.23 | Any | Any | “dead” code inside the stored proc or function can significantly slow it down |
94929 | 2019-04-07 8:38 | 2019-04-08 12:25 | MySQL Server: DML | Verified (1817 days) | S3 | 8.0.15, 5.7.25 | Any | Any | Generated column vs before insert trigger calculation order |
86163 | 2017-05-02 21:29 | 2023-12-01 6:55 | MySQL Server: DML | Verified (2514 days) | S2 | All, 5.7.18 | Any | Any | can't update temporary table when joined with table with triggers on read-only |
41313 | 2008-12-08 23:31 | 2011-02-16 23:43 | MySQL Server: Installing | Verified (5588 days) | S2 | 5.1.30 | Any (Windows) | Any | network administrator does not have TRIGGER and EVENT privileges |
Showing all 15 (Edit, Save, CSV, Feed) |