| Showing all 14 (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 (6926 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 (5993 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 (5632 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 (5377 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 (4371 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 (4422 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 (4137 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 (3793 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 (3697 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 (3336 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 (2814 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 (2691 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 (2419 days) | S3 | 8.0.15, 5.7.25 | Any | Any | Generated column vs before insert trigger calculation order |
| 117256 | 2025-01-21 13:19 | 2025-01-28 18:24 | MySQL Server: InnoDB storage engine | Verified (297 days) | S2 | 8.4.4 | Any | Any | Repeating uncaused error "Column cannot be null" after single error on table with trigger |
| Showing all 14 (Edit, Save, CSV, Feed) |
