Showing all 165
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 2676 | 2004-02-08 11:47 | 2011-02-16 23:42 | MySQL Server: Stored Routines | Verified (7563 days) | S4 | 5.0.0-alpha-debug | Linux (SuSE 8.2) | Any | DECLARE can't have COLLATE clause in stored procedure |
| 3052 | 2004-03-03 2:46 | 2026-07-22 14:27 | MySQL Server: Stored Routines | Verified (7509 days) | S3 | 5.1 | Linux (SuSE 8.2) | Any | Rollback in stored procedure doesn't close cursor |
| 3286 | 2004-03-24 10:13 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (7652 days) | S4 | 5.0 alpha | Windows (Windows 2000) | Any | Enhancement to Stored Procedure variables |
| 4210 | 2004-06-18 20:33 | 2011-02-16 23:42 | MySQL Server: Stored Routines | Verified (7641 days) | S4 | 5 | Windows (Win2000) | Any | Stored Procedure Encryption |
| 9051 | 2005-03-08 14:20 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (7199 days) | S3 | 5.0.12-beta-nt, 5.0.13-BK | Windows (Windows Server 2003, XP, Linux) | Any | Stored Functions: Database name in fully qualified name is case sensitive |
| 9588 | 2005-04-02 20:15 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (7654 days) | S4 | 5.0.3 | Any (All) | Any | Support for ALTER (or CREATE OR REPLACE) PROCEDURE/FUNCTION <BODY> |
| 10817 | 2005-05-24 8:46 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6316 days) | S4 | 5.0.0 | Any (all) | Any | Using resultsets returned by a SP in another SP |
| 10907 | 2005-05-27 8:55 | 2005-05-27 8:55 | MySQL Server: Stored Routines | Open | S4 | 5.0.0 | Any (all) | Any | need to be able to create tables of local scope in sp |
| 11746 | 2005-07-05 20:23 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (7730 days) | S4 | 5.0.4 beta, 5.0.13-BK | Linux (Red Hat Linux 9.0) | Any | Stored Procedures: Update failure not handled by any of the error handlers |
| 12417 | 2005-08-06 20:01 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (7199 days) | S3 | 5.0 | Windows (Windows XP) | Any | Connection.prepareCall() is database name case sensitive |
| 12719 | 2005-08-22 10:51 | 2025-12-07 20:45 | MySQL Server: Stored Routines | Verified (6387 days) | S3 | 5.0.12, 5.0.14-rc, 5.1.34 | Linux (Linux) | Any | SHOW CREATE PROCEDURE/FUNCTION does obey sql_quote_show_create |
| 13819 | 2005-10-06 20:10 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (5813 days) | S4 | 5.0.13 | Any | Any | Optionally suppress resultsets returned by SP's (DO syntax but now for SP's) |
| 14053 | 2005-10-15 23:44 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6219 days) | S4 | 5.0.13-rc-standard-log | Any (any) | Any | Impossible to access auto_increment values in triggers on insert |
| 14128 | 2005-10-19 2:41 | 2010-12-15 11:17 | MySQL Server: Stored Routines | Open | S4 | Any | Any | Trigger logging | |
| 14642 | 2005-11-04 14:01 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (7585 days) | S4 | 5.0.15-nt | Any (NA) | Any | Please implement a CURRENT_DATABASE()/CURRENT_SCHEMA() function |
| 14661 | 2005-11-04 21:38 | 2018-03-19 15:53 | MySQL Server: Stored Routines | Verified (7680 days) | S4 | 5.0/5.1 | Any (ALL) | Any | ALTER TRIGGER trigger_name DISABLE or ALTER TABLE table_name DISABLE TRIGGERS; |
| 15813 | 2005-12-16 16:32 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6196 days) | S4 | 5.0+ | Any (All) | Any | Feature Request for Named Parameters in the CALL statement |
| 15975 | 2005-12-24 16:49 | 2026-02-10 5:23 | MySQL Server: Stored Routines | Verified (7629 days) | S4 | 5.0, 8.0 | Windows (Windows) | Any | Optional parameters support in stored procedures |
| 16402 | 2006-01-12 3:44 | 2012-05-18 20:19 | MySQL Server: Stored Routines | Verified (7573 days) | S3 | 5.1.6-alpha-debug | Linux (linux) | Any | Events: SHOW EVENT STATUS doesn't work |
| 16525 | 2006-01-15 23:37 | 2015-11-20 7:32 | MySQL Server: Stored Routines | Verified (7607 days) | S4 | 5.X | Any (all) | Any | INSTEAD OF triggers |
| 17009 | 2006-02-01 15:28 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (7589 days) | S4 | 5.0.18 | Any (any) | Any | Stored Procedures: allow cursors on anything that returns a result set. |
| 17034 | 2006-02-02 11:05 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (7038 days) | S4 | 5.1 | Any (any) | Any | Error messages from stored routines should name their source |
| 17153 | 2006-02-06 13:46 | 2017-11-22 1:53 | MySQL Server: Stored Routines | Verified (7586 days) | S4 | 5.0.18 | Any (any) | Any | Cursors impossible on dynamic SQL |
| 17409 | 2006-02-15 2:21 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (7558 days) | S4 | 5.1.5-alpha-max | Linux (Debian Etch) | Any | PREPARE doesn't support queries in local variables |
| 17428 | 2006-02-15 15:24 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (7540 days) | S4 | 5.1.7-beta | Any | TRIGGER EVENT does not work | |
| 17597 | 2006-02-20 20:20 | 2014-01-22 14:26 | MySQL Server: Stored Routines | Verified (4679 days) | S3 | 5.1 | Any | Any | CREATE TRIGGER does not check privileges the standard way |
| 17598 | 2006-02-20 20:26 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6227 days) | S3 | 5.1 | Any | Any | privilege checks when trigger is executed |
| 17632 | 2006-02-21 23:08 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (7559 days) | S4 | 5.1+ | Any (ALL) | Any | Automatically trigger stored precedures based on events (user login, shutdown) |
| 18845 | 2006-04-06 12:29 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (7527 days) | S4 | 5.0 | Any | Any | Cursor traversal issues |
| 19150 | 2006-04-17 20:59 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (7508 days) | S4 | 5.1 | Any (all) | Any | batch statements |
| 19355 | 2006-04-25 21:06 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (7507 days) | S4 | 5.1 | Any (all) | Any | RETURN inside SP |
| 19584 | 2006-05-06 18:42 | 2013-08-11 17:05 | MySQL Server: Stored Routines | Verified (4843 days) | S4 | 5.0.20-nt-max | Windows (W2K SRV) | Any | CREATE USER in STORED PROCEDURE doesn't work with Variables |
| 19794 | 2006-05-13 12:48 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6616 days) | S4 | 5.1.7-beta-log | Linux (Linux 2.4.27-2-386) | Any | Stored Procedures: No way to "print" log messages to clients |
| 20241 | 2006-06-03 5:08 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (6919 days) | S4 | WIN -5.0.21 LIN 5.0.22 | Any (MS win32 - XP SP2, Fedora core 5) | Any | Access to procedures/functions is lost if the definer is dropped |
| 21110 | 2006-07-18 10:46 | 2018-12-06 11:21 | MySQL Server: Stored Routines | Verified (7424 days) | S4 | 5.0 | Any (All) | Any | limit of max_sp_recursion_depth |
| 21534 | 2006-08-09 10:03 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (7383 days) | S4 | 5.1.11 | Linux (Linux) | Any | function returning a table |
| 21866 | 2006-08-28 9:56 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (7382 days) | S4 | 5.0.24 | Linux (linux ubuntu) | Any | Trigger check sql statement at runtime not at compile time |
| 22012 | 2006-09-05 11:32 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (7375 days) | S4 | 5 | Any | Store procedure: support LEAVE without label | |
| 22034 | 2006-09-05 23:10 | 2014-01-22 14:27 | MySQL Server: Stored Routines | Verified (4679 days) | S3 | 5.1.12-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Events: U and ü are the same name |
| 23319 | 2006-10-16 3:29 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (7334 days) | S4 | 5.0 | Windows (Windows XP) | Any | Separately Trigger |
| 24260 | 2006-11-13 13:02 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (7039 days) | S4 | 5.1 | Any | Any | Events: Don't compile scheduler code in embedded |
| 24286 | 2006-11-14 6:59 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (7263 days) | S4 | 5.2+ | Any | Triggers should be able to callback | |
| 24489 | 2006-11-21 22:16 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (7284 days) | S3 | 5.0 BK, 5.1 BK | Linux (Linux) | Any | @@sql_select_limit applies to stored functions, triggers, events |
| 24720 | 2006-11-30 10:25 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (7267 days) | S4 | 5.0.26 | Linux (opensuse 10.0) | Any | Allow recursive stored functions |
| 26150 | 2007-02-07 14:46 | 2012-05-30 7:20 | MySQL Server: Stored Routines | Verified (5282 days) | S4 | 5.1.14 beta | Any | Any | Omitting meaningess lines from err-logfile |
| 26334 | 2007-02-13 16:50 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (7138 days) | S4 | 5.1.15 | Any | Any | Inconsistency: ALTER PROC/FUNC doesn't allow [NOT] DETERMINISTIC |
| 26394 | 2007-02-15 8:20 | 2018-09-09 20:45 | MySQL Server: Stored Routines | Verified (7212 days) | S3 | 5.0.36-NK, all | Linux (Linux) | Any | IF error message "ERROR 1054 (42S22): Unknown column 'X' in 'field list'" |
| 27721 | 2007-04-09 20:12 | 2012-05-30 7:05 | MySQL Server: Stored Routines | Verified (5282 days) | S4 | 5.1 | Any | Any | In current Event Scheduler you cannot relate one temporal event to another one |
| 27793 | 2007-04-12 21:02 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6464 days) | S4 | Any | Any | RENAME PROCEDURE / FUNCTION and ALTER PROCEDURE / FUNCTION ... RENAME | |
| 28406 | 2007-05-13 20:58 | 2025-12-07 20:45 | MySQL Server: Stored Routines | Verified (7122 days) | S4 | 5.0.42-BK, 5.0.38-Ubuntu | Linux (Ubuntu 7.04) | Any | GRANT using a stored procedure variable as PASSWORD fails |
| 29542 | 2007-07-04 8:42 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (7071 days) | S4 | 5.0.37 | Windows (XP SP2) | Any | Allow to use a table referenced by a trigger in the query |
| 29939 | 2007-07-20 16:34 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6920 days) | S4 | 5.1.20 | Any | Any | wrong error message when trying to create an event without the EVENT grant |
| 30010 | 2007-07-24 16:18 | 2021-05-02 20:45 | MySQL Server: Stored Routines | Verified (6723 days) | S2 | 5.0, 5.1.20, 5.1.24-ndb-6.3.14 | Linux (Fedora Core 5) | Any | Auto-increment out of sync when using triggers and NDB Cluster |
| 31068 | 2007-09-17 20:09 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (6997 days) | S4 | 5.0.32, 5.0.44 | Linux | Any | "select into" syntax doesn't allow new.* variables as target |
| 31532 | 2007-10-11 13:40 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (6957 days) | S4 | 5.1.22-rc | Linux | Any | Log table for event scheduler |
| 31537 | 2007-10-11 15:24 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (6957 days) | S4 | 5.1.22-rc | Linux | Any | alter statement to stop/disable all events on a specified database |
| 31643 | 2007-10-16 15:26 | 2022-12-12 5:54 | MySQL Server: Stored Routines | Verified (6555 days) | S3 | 5.1.22 | Any | Any | Setting an event to 'disable on slave' disables it on the master |
| 32053 | 2007-11-02 12:37 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (6946 days) | S4 | 5.0.45 | Any | Any | Stored procedures/functions are slow |
| 32573 | 2007-11-21 13:33 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (6933 days) | S4 | 5.0 | Any (All) | Any | Slow query Log is not much use for analysing Stored Procedures |
| 34389 | 2008-02-07 18:12 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (6854 days) | S4 | 5.1.22-rc-log | Linux | Any | event sched. spawns new event while a previous instance of it is still runing |
| 34787 | 2008-02-24 13:15 | 2020-08-27 20:47 | MySQL Server: Stored Routines | Verified (4686 days) | S4 | 5.1.23 | Any | Any | TRIGGER definition should support SQL SECURITY = definer|invoker |
| 34805 | 2008-02-25 13:07 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6836 days) | S2 | 5.1+ | Any | Any | Disabled events dropped during server start not correctly replicated |
| 35204 | 2008-03-11 9:21 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6822 days) | S4 | 5.1.22 | Linux | Any | Arrays as Variables in Stored Procedures |
| 36105 | 2008-04-16 0:03 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6786 days) | S4 | Any | Any | Request for CURRENT_PROCEDURE() function | |
| 36229 | 2008-04-21 13:35 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6780 days) | S5 | 5.0.51a, 5.1.24 | Any | Any | Execution overhead of stored function/procedure differs with cross-database call |
| 36518 | 2008-05-05 21:32 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6766 days) | S3 | 5.1 and up | Any | Any | Plugin refcount leak with cursors and exceptions |
| 37515 | 2008-06-19 6:24 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6722 days) | S3 | 5.1.25, 5.0, 6.0 | Any | Any | CHECK TABLE not allowed in stored procedures |
| 39137 | 2008-08-30 18:53 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6649 days) | S2 | 5.0.51, 5.0.66a | Linux (Ubuntu hardy) | Any | DELETE makes stored function to fail (if table type is MyISAM) |
| 39173 | 2008-09-02 8:39 | 2025-12-07 20:45 | MySQL Server: Stored Routines | Verified (6647 days) | S3 | 5.1.26, 5.1 bzr | Any (Linux, Windows) | Any | Unable to remove event's ENDS |
| 39324 | 2008-09-08 18:12 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6641 days) | S3 | 5.1,6.0 | Any | Any | Stored procedures: Misleading error message |
| 39386 | 2008-09-11 9:21 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6637 days) | S3 | 5.0.67, 5.1 | Linux (CentOS 5.2, FreeBSD) | Any | INET_ATON() does not work properly inside a trigger |
| 40896 | 2008-11-20 16:55 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6568 days) | S3 | 5.0.45, 5.0.70, 5.1.30, 6.0.7 | Linux (CentOS 5) | Any | CREATE PROCEDURE fails with the use of a variable for separator |
| 41094 | 2008-11-28 13:44 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6209 days) | S4 | Any | Any | system call not available from a stored program / trigger / function | |
| 44398 | 2009-04-22 3:16 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (5876 days) | S3 | 5.1 | Any | Any | MySQL does not support external stored routines |
| 44681 | 2009-05-06 1:27 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6351 days) | S2 | 5.0.82, 5.0, 5.1 bzr | Linux (Any) | Any | 2 command trigger causes error 1340 .Configuration file ...is too big |
| 44854 | 2009-05-13 20:32 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6379 days) | S2 | 5.1.31-community-log, 5.1.34 | Any | Any | SP retruns 0 rows affected, but it had inserted 1 row |
| 44983 | 2009-05-20 12:49 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6384 days) | S3 | 5.1.34 | Windows (probably any) | Any | Server drops comment after "END" + formating issues |
| 45231 | 2009-06-01 3:07 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6375 days) | S4 | 5.0.60 | Any | Any | Cannot change LAST_INSERT_ID value within before update trigger |
| 46179 | 2009-07-14 18:07 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (2875 days) | S2 | 5.6, 5.7, 8.0 | Any | Any | set new.colname = default(colname) in trigger elicits a crazy error message |
| 46333 | 2009-07-22 5:30 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6319 days) | S3 | 5.0.83, 5.0 bzr | Any | Any | Can't update table 'tstamp' in stored function/trigger because it is already use |
| 46430 | 2009-07-28 14:20 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6318 days) | S4 | 5.x | Any | Any | Stored Routine should release resources after each block and after finishing |
| 48777 | 2009-11-14 19:45 | 2023-09-12 21:47 | MySQL Server: Stored Routines | Verified (6209 days) | S4 | any | Any | Any | Interactive Procedure SQL |
| 50684 | 2010-01-28 10:46 | 2015-07-06 5:33 | MySQL Server: Stored Routines | Verified (4149 days) | S4 | 5.0.51 | Linux (ubuntu) | Any | Recursive triggers |
| 51006 | 2010-02-08 19:30 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6122 days) | S3 | 5.1.42, 5.0, 5.1, 5.5.99 | Linux | Any | InnoDB does not correctly rollback statement on error inside stored function |
| 52025 | 2010-03-13 6:56 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6090 days) | S4 | 5.1.44 | Any | Any | support automatic upgrade of .trg files from old format to new format |
| 52899 | 2010-04-16 19:31 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6049 days) | S2 | 5.5.3-m3, 5.0, 5.1 | Any (Linux, FreeBSD 8.0-RELEASE-p2) | Any | Conversion of BLOB to TEXT (implicit or explicit) yields BLOB |
| 56360 | 2010-08-30 10:40 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (5920 days) | S4 | Any | Any | Constant functions | |
| 56361 | 2010-08-30 11:04 | 2012-05-30 7:04 | MySQL Server: Stored Routines | Verified (5282 days) | S4 | Any | Any | Table Methods | |
| 57401 | 2010-10-12 10:43 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (5820 days) | S4 | 5.1.50 | Windows | Any | Dynamic Select in UD Function |
| 59639 | 2011-01-20 17:51 | 2026-05-28 1:12 | MySQL Server: Stored Routines | In progress | S4 | 5.5 | Any | Any | provide option to log stored procedure SQL in general log |
| 60300 | 2011-03-02 1:30 | 2011-03-03 9:03 | MySQL Server: Stored Routines | Verified (5735 days) | S2 | 5.5.9 | Windows (XP Prof.) | Any | Corrupted values using variable of type TEXT in trigger or stored procedure |
| 61328 | 2011-05-27 14:33 | 2013-04-10 6:35 | MySQL Server: Stored Routines | Verified (5650 days) | S3 | 5.5.11, 5.5.14 | Any | Any | SET profiling = 1 does not profile queries with stored functions |
| 61568 | 2011-06-20 14:22 | 2011-06-25 11:30 | MySQL Server: Stored Routines | Verified (5625 days) | S2 | 5.5.15, 5.5.13 | Any | Any | Result is not grouped on sequential store procedure runs |
| 62435 | 2011-09-14 17:39 | 2011-09-21 9:35 | MySQL Server: Stored Routines | Verified (5538 days) | S2 | 5.1.49, 5.1.60 | Linux (Debian) | Any | not declaring variables returns a byte array instead of a varchar in .Net app |
| 63410 | 2011-11-23 21:17 | 2012-02-17 18:50 | MySQL Server: Stored Routines | Verified (5384 days) | S3 | 5.1.60, 5.1.61 | FreeBSD (x86_64) | Any | string corrupted in stored procedure concat and cast |
| 64089 | 2012-01-20 23:49 | 2014-03-12 2:45 | MySQL Server: Stored Routines | Verified (5243 days) | S4 | 5.1.54 | Linux (5.1.54-1ubuntu4) | Any | wrong last_insert_id() after setting id in trigger / recursive triggers |
| 64776 | 2012-03-27 11:12 | 2012-03-31 10:57 | MySQL Server: Stored Routines | Verified (5341 days) | S3 | 5.5.21 | Any | Any | Stored procedures are not ACID compliant |
| 64855 | 2012-04-03 14:53 | 2012-05-16 13:20 | MySQL Server: Stored Routines | Verified (5295 days) | S2 | 5.5.21, 5.6.5-m8, 5.1.64, 5.6.6, 5.5.25, 5.5.20-ndb-7.2.5 | Any | Any | Stored Procedure with GROUP/ORDER BY return unpredicatable results with CASE/IF |
| 65744 | 2012-06-27 4:09 | 2012-07-11 9:45 | MySQL Server: Stored Routines | Verified (5244 days) | S2 | 5.5.25 | Windows | Any | Nested functions not running |
| 65998 | 2012-07-24 14:51 | 2015-02-20 7:44 | MySQL Server: Stored Routines | Verified (5226 days) | S3 | 5.5.21 | Linux | Any | Event runs again as per the schedule even if an instance of it is still running |
| 68662 | 2013-03-13 19:16 | 2013-03-13 19:16 | MySQL Server: Stored Routines | Open | S4 | Any | Any | Request for the ability to run self-locking/self-altering triggers (known risks) | |
| 68753 | 2013-03-22 21:41 | 2016-02-29 6:52 | MySQL Server: Stored Routines | Verified (4973 days) | S4 | 5.6.10 | Any | Any | Show processlist does not show variable values any more |
| 68758 | 2013-03-24 9:09 | 2013-03-24 9:09 | MySQL Server: Stored Routines | Open | S4 | 5.6 | Any | Any | Procedures: Simpler iteration through result of SELECT |
| 69103 | 2013-04-30 16:53 | 2013-04-30 16:53 | MySQL Server: Stored Routines | Open | S4 | 5.1.48 | Linux (rhel) | Any | triggers should attempt recompile when faced with an error |
| 70405 | 2013-09-24 6:40 | 2013-09-24 6:40 | MySQL Server: Stored Routines | Open | S4 | 5.5.17 MySQL Community Server (GPL) | Windows | Any | Getting MySQL Error Trace from Procedure |
| 70948 | 2013-11-18 23:10 | 2014-03-22 18:41 | MySQL Server: Stored Routines | Verified (4620 days) | S4 | 5.1+ | Any | Any | Compound / Anonymous statement blocks for MySQL |
| 70975 | 2013-11-21 16:44 | 2017-03-23 10:19 | MySQL Server: Stored Routines | Verified (3523 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 |
| 71407 | 2014-01-17 12:12 | 2014-06-06 21:35 | MySQL Server: Stored Routines | Verified (4544 days) | S3 | 5.6.15 (at least( | Windows (probably any) | Any | Letter case inconsistency wiht schema/database names |
| 71610 | 2014-02-06 17:14 | 2014-02-06 17:14 | MySQL Server: Stored Routines | Open | S4 | Any | Any | SIGNAL sqlstates should be interpreted as their literal state | |
| 72318 | 2014-04-11 17:36 | 2017-12-23 10:47 | MySQL Server: Stored Routines | Verified (4597 days) | S3 | 5.6.14-log | Any | Any | Stored function throws error 1137 if temporary table was not created right then |
| 72395 | 2014-04-20 8:40 | 2015-11-20 7:28 | MySQL Server: Stored Routines | Verified (4590 days) | S4 | Any | Any | ON SELECT trigger | |
| 72544 | 2014-05-06 7:18 | 2014-05-28 4:53 | MySQL Server: Stored Routines | Verified (4575 days) | S3 | 5.6.17 | Any | Any | Incorrect locking for global_query_id |
| 73145 | 2014-06-30 8:10 | 2014-07-01 8:52 | MySQL Server: Stored Routines | Verified (4519 days) | S3 | Any | Any | Suggest SQLSTATE for user warning/not found condition | |
| 73381 | 2014-07-24 22:31 | 2023-04-04 16:30 | MySQL Server: Stored Routines | Verified (1320 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 |
| 73399 | 2014-07-25 18:32 | 2014-07-25 18:56 | MySQL Server: Stored Routines | Verified (4495 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 |
| 73991 | 2014-09-21 10:39 | 2023-11-12 14:57 | MySQL Server: Stored Routines | Open | S4 | Any | Any | Named parameter CALL syntax | |
| 75392 | 2015-01-02 14:45 | 2015-01-19 16:03 | MySQL Server: Stored Routines | Verified (4317 days) | S3 | any - case from 5.6.22 | Any | Any | Multiline comments treated inconsistently |
| 75685 | 2015-01-29 20:05 | 2015-02-02 14:57 | MySQL Server: Stored Routines | Verified (4303 days) | S3 | any 5.0+ | Any | Any | SHOW TRIGGERS removes escapes from body of CREATE statement |
| 75830 | 2015-02-09 20:35 | 2015-02-09 21:04 | MySQL Server: Stored Routines | Verified (4296 days) | S2 | 5.5, 5.6 | Any | Any | Triggers cause statements using LAST_INSERT_ID(X) to return wrong value |
| 77186 | 2015-05-28 22:13 | 2017-03-16 8:09 | MySQL Server: Stored Routines | Verified (4177 days) | S3 | 5.5 5.6, 5.6.26, 5.7.17 | Any | Any | Implicit GRANT incorrectly issued after CREATE PROCEDURE |
| 78144 | 2015-08-19 22:34 | 2015-11-24 9:07 | MySQL Server: Stored Routines | Verified (4103 days) | S3 | 5.6.19-log | Linux (RDS) | Any | Error handler not being triggered for multi-table update |
| 79782 | 2015-12-28 5:57 | 2016-09-08 9:09 | MySQL Server: Stored Routines | Verified | S4 | 5.6.28 | Any | Any | implement retry logic for event scheduler in case it cannot create a new thread |
| 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 |
| 81860 | 2016-06-15 10:18 | 2016-06-15 11:38 | MySQL Server: Stored Routines | Verified (3804 days) | S3 | Any | Any | read_only is not allowed for SUPER because of prelocking | |
| 81979 | 2016-06-22 21:41 | 2016-07-15 11:57 | MySQL Server: Stored Routines | Verified (3774 days) | S4 | 5.6.29, 5.7, 5.7.13 | Any | Any | Impossible to flush stored_program_cache |
| 82679 | 2016-08-22 10:15 | 2016-08-22 12:27 | MySQL Server: Stored Routines | Verified (3736 days) | S3 | 5.5.51, 5.6.33, 5.7.14 | Any | Any | Compound statements may silently eat KILL QUERY |
| 84037 | 2016-12-02 6:51 | 2021-09-09 14:05 | MySQL Server: Stored Routines | Verified (3634 days) | S3 | 5.7.17, 5.7.16 | Any | Any | Error on insert JSON data to a table with generated columns from a SP |
| 86830 | 2017-06-26 21:07 | 2017-06-26 22:35 | MySQL Server: Stored Routines | Verified (3428 days) | S3 | 5.5, 5.6, 5.7, 8.0 | Any | Any | Silent UNSIGNED - SIGNED conversion with STRICT mode |
| 87529 | 2017-08-24 13:53 | 2017-08-24 15:18 | MySQL Server: Stored Routines | Verified (3369 days) | S4 | ALL | Any | Any | Optional parameters support in stored procedures |
| 88840 | 2017-12-09 13:22 | 2017-12-10 22:09 | MySQL Server: Stored Routines | Verified | S4 | 5.7, 8.0, 9.0 | Any | Any | ERROR 1424 (HY000): Recursive stored functions and triggers are not allowed. |
| 91585 | 2018-07-10 1:16 | 2018-08-27 11:06 | MySQL Server: Stored Routines | Verified (3049 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 |
| 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 |
| 93605 | 2018-12-14 7:46 | 2018-12-14 7:50 | MySQL Server: Stored Routines | Verified | S2 | 5.7.21 | Any | Any | UDF accidentally accepts stored functions in generated column |
| 93982 | 2019-01-18 14:29 | 2019-01-22 13:50 | MySQL Server: Stored Routines | Verified (2853 days) | S4 | 5.3.9 | Any | Any | Ways to retain Read-Locks for 'SELECT .. FOR UPDATE' across commit points |
| 95734 | 2019-06-11 11:54 | 2026-10-02 16:57 | MySQL Server: Stored Routines | Verified (43 days) | S3 | 8.0.16, 5.7.26 | Any | Any | Failing SET statement in a stored procedure changes variables |
| 99493 | 2020-05-08 19:46 | 2020-05-15 11:46 | MySQL Server: Stored Routines | Verified (2375 days) | S3 | 5.7, 8.0 | Linux (AWS Linux deployment) | x86 (x86_64) | While-loop in Function behaves differently than in Procedure - does not exit |
| 100249 | 2020-07-17 14:44 | 2020-07-17 18:52 | MySQL Server: Stored Routines | Verified (2311 days) | S3 | 5.7 | Any | Any | mysql username with special characters @ and routines parsing issue |
| 100271 | 2020-07-21 6:44 | 2020-07-21 13:53 | MySQL Server: Stored Routines | Verified (2307 days) | S2 | MySQL8.0.20 | Any (rhel-7.4) | x86 (intel x86) | cursor in procedure works abnormally for with_clause |
| 102205 | 2021-01-09 13:07 | 2021-01-10 7:47 | MySQL Server: Stored Routines | Verified (2135 days) | S2 | 5.7.26 /8.0.22 | CentOS (CentOS Linux release 7.6.1810 (Core)) | x86 | ERROR 2027 (HY000): Malformed packet, from exception in nested procedures |
| 102638 | 2021-02-18 9:36 | 2021-04-15 13:06 | MySQL Server: Stored Routines | Verified (2039 days) | S4 | 8.0 | Any | Any | improvements for TRIGGER |
| 102825 | 2021-03-05 11:34 | 2021-03-06 11:47 | MySQL Server: Stored Routines | Verified (2079 days) | S3 | 8.0.23, 5.7.23 | Any | Any | mysqld selects an unexpected function |
| 103965 | 2021-06-09 22:20 | 2021-06-10 6:41 | MySQL Server: Stored Routines | Verified (1983 days) | S2 | 8.0.25, 8.0.23 | Any | x86 | Stored procedure execution fails if contains a functional index |
| 104715 | 2021-08-25 6:22 | 2021-09-13 7:09 | MySQL Server: Stored Routines | Verified (1894 days) | S1 | 8.0.26, 8.0.22+ | Windows (Windows 10 Enterprise 20H2) | x86 | Several calls of stored procedure return different values |
| 106728 | 2022-03-15 2:43 | 2022-03-15 7:12 | MySQL Server: Stored Routines | Verified (1705 days) | S3 | 5.7.37 | Any | Any | CREATE EVENT DEFINER=`test@usr`@localhost processed as 'test'@'usr@localhost' |
| 107160 | 2022-04-29 8:19 | 2024-03-04 4:11 | MySQL Server: Stored Routines | Verified (1660 days) | S2 | 8.0.29 | Any | Any | Upgrade from 5.7 to 8.0 fails with syntax error while parsing an event |
| 107741 | 2022-07-04 7:40 | 2022-07-06 9:03 | MySQL Server: Stored Routines | Verified (1592 days) | S5 | 8.0.25, 8.0.29 | Linux | Any | Event_Scheduler memory leak in MySQL 8 version |
| 108639 | 2022-09-29 1:15 | 2022-09-29 6:16 | MySQL Server: Stored Routines | Verified (1507 days) | S2 | 8.0.29, 8.0.30 | Any | Any | Value of row_count() does not reset after a DROP TABLE in a procedure |
| 109128 | 2022-11-17 19:53 | 2022-11-22 15:13 | MySQL Server: Stored Routines | Verified (1457 days) | S2 | 8.0.31 | Any | Any | MySQL 8.0.31 Read Replica Procedure Call Bug |
| 109525 | 2023-01-04 6:18 | 2023-01-04 12:52 | MySQL Server: Stored Routines | Verified (1410 days) | S3 | mysql-8.0.25-linux-glibc2.12-x86_64.tar., 8.0.31 | CentOS (Linux release 7.9.2009 (Core)) | x86 | the Maximum Length of Compound Statement Label (characters) is inaccurate |
| 110990 | 2023-05-11 10:13 | 2023-05-11 11:21 | MySQL Server: Stored Routines | Verified (1283 days) | S3 | 8.0.33 | Any | Any | Create function misleading error for SUPER privilege and log_bin_trust_function |
| 111374 | 2023-06-13 2:30 | 2023-06-13 7:28 | MySQL Server: Stored Routines | Verified (1250 days) | S6 | 8.0.33 | Ubuntu (20.04 LTS) | x86 (Intel(R) Core(TM) i7-10700 CPU) | Assertion `m_return_field_def.auto_flags == Field::NONE' failed |
| 111404 | 2023-06-13 18:26 | 2023-06-14 5:07 | MySQL Server: Stored Routines | Verified (1249 days) | S6 | 8.0.33 | Ubuntu (20.04 LTS) | x86 (Intel(R) Core(TM) i7-10700 CPU) | Assertion `is_prepared()' failed. |
| 111526 | 2023-06-21 19:02 | 2023-06-22 13:41 | MySQL Server: Stored Routines | Verified (1241 days) | S3 | 8.0 | Any | Any | STR_TO_DATE fails in MySQL stored function with error instead of returning NULL |
| 112158 | 2023-08-23 8:54 | 2023-08-23 11:48 | MySQL Server: Stored Routines | Verified (1179 days) | S2 | 8.0.13, 8.0.34 | Any | Any | Calling of stored procedure is not case sensitive |
| 114419 | 2024-03-20 0:48 | 2024-03-20 8:44 | MySQL Server: Stored Routines | Verified (969 days) | S2 | 8.0.36 | Any | Any | SHOW COLUMNS on a temporary table in a procedure returns table doesn't exist |
| 115649 | 2024-07-19 11:38 | 2024-08-19 12:24 | MySQL Server: Stored Routines | In progress (817 days) | S3 | 8.0.38 | Linux (version_compile_machine: x86_64) | Any | Mixed quoting styles in SHOW CREATE TRIGGER |
| 116622 | 2024-11-12 3:04 | 2025-11-11 5:09 | MySQL Server: Stored Routines | Verified (368 days) | S4 | 8.0.40, 8.4.3, 9.1.0 | Any | Any | There's no alternative way to create TRIGGER without SUPER priv |
| 117267 | 2025-01-22 14:11 | 2025-01-24 20:46 | MySQL Server: Stored Routines | Verified (659 days) | S4 | 8.0.40 | Any | Any | Table's trigger metadata/code is loaded always (for SELECTs too) |
| 117419 | 2025-02-10 4:45 | 2025-02-10 7:08 | MySQL Server: Stored Routines | Verified (642 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 |
| 117719 | 2025-03-17 2:13 | 2025-11-11 2:10 | MySQL Server: Stored Routines | Verified (598 days) | S2 | 8.0.41 | Any | Any | The event scheduler is not working. |
| 118046 | 2025-04-23 21:21 | 2025-05-22 10:34 | MySQL Server: Stored Routines | Verified (541 days) | S2 | 8.0 | Any | Any | KILL (QUERY) should check thread ownership against the security context that initiated the current operation |
| 118152 | 2025-05-09 8:45 | 2025-05-09 9:47 | MySQL Server: Stored Routines | Verified (554 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 |
| 119232 | 2025-10-24 15:11 | 2025-10-24 15:11 | MySQL Server: Stored Routines | Open | S4 | Any | Any | concept of concurrent execution for complex stored procedures | |
| 120499 | 2026-05-20 5:02 | 2026-05-20 5:02 | MySQL Server: Stored Routines | Open | S2 | 9.6.0 | Linux | x86 (AMD EPYC 9K65) | Recursive stored procedure with max_sp_recursion_depth >= 250 crashes mysqld |
| 121736 | 2026-11-10 19:24 | 2026-11-10 19:24 | MySQL Server: Stored Routines | Open | S2 | 8.0.46, 8.4.13, 9.7.4 | Linux (official Docker images) | Any | Undefined user variable reads as 0, not NULL, in a trigger first run by another session |
Showing all 165
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.024 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.