| Showing 1-30 of 81 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 75685 | 2015-01-29 20:05 | 2015-02-02 14:57 | MySQL Server: Stored Routines | Verified (3815 days) | S3 | any 5.0+ | Any | Any | SHOW TRIGGERS removes escapes from body of CREATE statement |
| 91585 | 2018-07-10 1:16 | 2018-08-27 11:06 | MySQL Server: Stored Routines | Verified (2561 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 |
| 86830 | 2017-06-26 21:07 | 2017-06-26 22:35 | MySQL Server: Stored Routines | Verified (2940 days) | S3 | 5.5, 5.6, 5.7, 8.0 | Any | Any | Silent UNSIGNED - SIGNED conversion with STRICT mode |
| 84037 | 2016-12-02 6:51 | 2021-09-09 14:05 | MySQL Server: Stored Routines | Verified (3146 days) | S3 | 5.7.17, 5.7.16 | Any | Any | Error on insert JSON data to a table with generated columns from a SP |
| 82679 | 2016-08-22 10:15 | 2016-08-22 12:27 | MySQL Server: Stored Routines | Verified (3248 days) | S3 | 5.5.51, 5.6.33, 5.7.14 | Any | Any | Compound statements may silently eat KILL QUERY |
| 81860 | 2016-06-15 10:18 | 2016-06-15 11:38 | MySQL Server: Stored Routines | Verified (3316 days) | S3 | Any | Any | read_only is not allowed for SUPER because of prelocking | |
| 80923 | 2016-03-31 12:12 | 2016-03-31 12:13 | MySQL Server: Stored Routines | Verified | S3 | 5.6.28, 5.7.11 | Any | Any | Reuse sp_rcontext when processing many rows with stored function / triggers |
| 78144 | 2015-08-19 22:34 | 2015-11-24 9:07 | MySQL Server: Stored Routines | Verified (3615 days) | S3 | 5.6.19-log | Linux (RDS) | Any | Error handler not being triggered for multi-table update |
| 77186 | 2015-05-28 22:13 | 2017-03-16 8:09 | MySQL Server: Stored Routines | Verified (3689 days) | S3 | 5.5 5.6, 5.6.26, 5.7.17 | Any | Any | Implicit GRANT incorrectly issued after CREATE PROCEDURE |
| 75830 | 2015-02-09 20:35 | 2015-02-09 21:04 | MySQL Server: Stored Routines | Verified (3808 days) | S2 | 5.5, 5.6 | Any | Any | Triggers cause statements using LAST_INSERT_ID(X) to return wrong value |
| 93256 | 2018-11-20 10:29 | 2019-05-10 7:43 | MySQL Server: Stored Routines | Verified | S3 | 5.5 | Any | Any | CREATE PROCEDURE/FUNCTION should store the collation for its arguments |
| 75392 | 2015-01-02 14:45 | 2015-01-19 16:03 | MySQL Server: Stored Routines | Verified (3829 days) | S3 | any - case from 5.6.22 | Any | Any | Multiline comments treated inconsistently |
| 73399 | 2014-07-25 18:32 | 2014-07-25 18:56 | MySQL Server: Stored Routines | Verified (4007 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 |
| 73381 | 2014-07-24 22:31 | 2023-04-04 16:30 | MySQL Server: Stored Routines | Verified (832 days) | S1 | 5.6.19, 5.6.21, 5.7.5, 8.0 | Windows | Any | Can't find temp table created in stored proc. using CREATE TEMPORARY TABLE AS |
| 73145 | 2014-06-30 8:10 | 2014-07-01 8:52 | MySQL Server: Stored Routines | Verified (4031 days) | S3 | Any | Any | Suggest SQLSTATE for user warning/not found condition | |
| 72544 | 2014-05-06 7:18 | 2014-05-28 4:53 | MySQL Server: Stored Routines | Verified (4087 days) | S3 | 5.6.17 | Any | Any | Incorrect locking for global_query_id |
| 3052 | 2004-03-03 2:46 | 2025-06-26 7:51 | MySQL Server: Stored Routines | Verified (7021 days) | S3 | 5.1 | Linux (SuSE 8.2) | Any | Rollback in stored procedure doesn't close cursor |
| 71407 | 2014-01-17 12:12 | 2014-06-06 21:35 | MySQL Server: Stored Routines | Verified (4056 days) | S3 | 5.6.15 (at least( | Windows (probably any) | Any | Letter case inconsistency wiht schema/database names |
| 70975 | 2013-11-21 16:44 | 2017-03-23 10:19 | MySQL Server: Stored Routines | Verified (3035 days) | S3 | 5.5.23, 5.5.35, 5.6.16,5.7.17 | Any | Any | ERROR 1577 (HY000): Cannot proceed because system tables used by Event Scheduler |
| 108639 | 2022-09-29 1:15 | 2022-09-29 6:16 | MySQL Server: Stored Routines | Verified (1019 days) | S2 | 8.0.29, 8.0.30 | Any | Any | Value of row_count() does not reset after a DROP TABLE in a procedure |
| 118152 | 2025-05-09 8:45 | 2025-05-09 9:47 | MySQL Server: Stored Routines | Verified (66 days) | S3 | 8.0.42,8.4.5,9.2.0 | Any | Any | BEFORE UPDATE trigger does not use correct NEW.val when val is ON UPDATE CURRENT_TIMESTAMP |
| 118046 | 2025-04-23 21:21 | 2025-05-22 10:34 | MySQL Server: Stored Routines | Verified (53 days) | S2 | 8.0 | Any | Any | KILL (QUERY) should check thread ownership against the security context that initiated the current operation |
| 117719 | 2025-03-17 2:13 | 2025-03-27 20:10 | MySQL Server: Stored Routines | Verified (110 days) | S2 | 8.0.41 | Any | Any | The event scheduler is not working. |
| 117419 | 2025-02-10 4:45 | 2025-02-10 7:08 | MySQL Server: Stored Routines | Verified (154 days) | S2 | 8.0.34, 8.0.41, 8.4.4, 9.2.0 | Any | Any | BEFORE INSERT trigger causes all columns in DEFAULT value expression to be NULL |
| 114419 | 2024-03-20 0:48 | 2024-03-20 8:44 | MySQL Server: Stored Routines | Verified (481 days) | S2 | 8.0.36 | Any | Any | SHOW COLUMNS on a temporary table in a procedure returns table doesn't exist |
| 112158 | 2023-08-23 8:54 | 2023-08-23 11:48 | MySQL Server: Stored Routines | Verified (691 days) | S2 | 8.0.13, 8.0.34 | Any | Any | Calling of stored procedure is not case sensitive |
| 111526 | 2023-06-21 19:02 | 2023-06-22 13:41 | MySQL Server: Stored Routines | Verified (753 days) | S3 | 8.0 | Any | Any | STR_TO_DATE fails in MySQL stored function with error instead of returning NULL |
| 110990 | 2023-05-11 10:13 | 2023-05-11 11:21 | MySQL Server: Stored Routines | Verified (795 days) | S3 | 8.0.33 | Any | Any | Create function misleading error for SUPER privilege and log_bin_trust_function |
| 109128 | 2022-11-17 19:53 | 2022-11-22 15:13 | MySQL Server: Stored Routines | Verified (969 days) | S2 | 8.0.31 | Any | Any | MySQL 8.0.31 Read Replica Procedure Call Bug |
| 72318 | 2014-04-11 17:36 | 2017-12-23 10:47 | MySQL Server: Stored Routines | Verified (4109 days) | S3 | 5.6.14-log | Any | Any | Stored function throws error 1137 if temporary table was not created right then |
| Showing 1-30 of 81 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
