| Showing all 165 (Edit, Save, CSV, Feed) |
| 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 (7178 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 | 2025-10-16 17:24 | MySQL Server: Stored Routines | Verified (7124 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 (7267 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 (7256 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 (6814 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 (7269 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 (5931 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 (7345 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 (6814 days) | S3 | 5.0 | Windows (Windows XP) | Any | Connection.prepareCall() is database name case sensitive |
| 12719 | 2005-08-22 10:51 | 2017-11-13 20:47 | MySQL Server: Stored Routines | Verified (6002 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 (5428 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 (5834 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 (7200 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 (7295 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 (5811 days) | S4 | 5.0+ | Any (All) | Any | Feature Request for Named Parameters in the CALL statement |
| 15975 | 2005-12-24 16:49 | 2023-01-25 5:56 | MySQL Server: Stored Routines | Verified (7244 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 (7188 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 (7222 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 (7204 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 (6653 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 (7201 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 (7173 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 (7155 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 (4294 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 (5842 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 (7174 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 (7142 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 (7123 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 (7122 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 (4458 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 (6231 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 (6534 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 (7039 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 (6998 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 (6997 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 (6990 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 (4294 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 (6949 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 (6654 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 (6878 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 (6899 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 (6882 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 (4897 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 (6753 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 (6827 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 (4897 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 (6079 days) | S4 | Any | Any | RENAME PROCEDURE / FUNCTION and ALTER PROCEDURE / FUNCTION ... RENAME | |
| 28406 | 2007-05-13 20:58 | 2016-03-07 17:33 | MySQL Server: Stored Routines | Verified (6737 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 (6686 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 (6535 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 (6338 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 (6612 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 (6572 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 (6572 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 (6170 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 (6561 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 (6548 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 (6469 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 (4301 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 (6451 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 (6437 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 (6401 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 (6395 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 (6381 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 (6337 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 (6264 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 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (6262 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 (6256 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 (6252 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 (6183 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 (5824 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 (5491 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 (5966 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 (5994 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 (5999 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 (5990 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 (2490 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 (5934 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 (5933 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 (5824 days) | S4 | any | Any | Any | Interactive Procedure SQL |
| 50684 | 2010-01-28 10:46 | 2015-07-06 5:33 | MySQL Server: Stored Routines | Verified (3764 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 (5737 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 (5705 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 (5664 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 (5535 days) | S4 | Any | Any | Constant functions | |
| 56361 | 2010-08-30 11:04 | 2012-05-30 7:04 | MySQL Server: Stored Routines | Verified (4897 days) | S4 | Any | Any | Table Methods | |
| 57401 | 2010-10-12 10:43 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (5435 days) | S4 | 5.1.50 | Windows | Any | Dynamic Select in UD Function |
| 59639 | 2011-01-20 17:51 | 2011-02-16 23:44 | MySQL Server: Stored Routines | Verified | 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 (5350 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 (5265 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 (5240 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 (5153 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 (4999 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 (4858 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 (4956 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 (4910 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 (4859 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 (4841 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 (4588 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 (4235 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 (3138 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 (4159 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 (4212 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 (4205 days) | S4 | Any | Any | ON SELECT trigger | |
| 72544 | 2014-05-06 7:18 | 2014-05-28 4:53 | MySQL Server: Stored Routines | Verified (4190 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 (4134 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 (935 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 (4110 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 (3932 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 (3918 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 (3911 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 (3792 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 (3718 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 (3419 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 (3389 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 (3351 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 (3249 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 (3043 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 (2984 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 (2664 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 (2468 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 | 2019-06-11 12:26 | MySQL Server: Stored Routines | Verified (2328 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 (1990 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 (1926 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 (1922 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 (1750 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 (1654 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 (1694 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 (1598 days) | S2 | 8.0.25, 8.0.23 | Any | x86 | Stored procedure execution fails if contains a functional index |
| 104115 | 2021-06-25 18:39 | 2021-07-25 10:39 | MySQL Server: Stored Routines | Verified (1553 days) | S2 | 8.0 | Any | Any | Digest user functions pollute current THD |
| 104715 | 2021-08-25 6:22 | 2021-09-13 7:09 | MySQL Server: Stored Routines | Verified (1509 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 (1320 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 (1275 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 (1207 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 (1122 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 (1072 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 (1025 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 (898 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 (865 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 (864 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 (856 days) | S3 | 8.0 | Any | Any | STR_TO_DATE fails in MySQL stored function with error instead of returning NULL |
| 111690 | 2023-07-07 8:32 | 2023-07-07 9:04 | MySQL Server: Stored Routines | Verified (841 days) | S4 | 8.0 | Any | Any | Expose number of table objects with triggers in table cache |
| 112158 | 2023-08-23 8:54 | 2023-08-23 11:48 | MySQL Server: Stored Routines | Verified (794 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 (584 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 (432 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 | 2024-11-12 5:33 | MySQL Server: Stored Routines | Verified (347 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 (274 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 (257 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-03-27 20:10 | MySQL Server: Stored Routines | Verified (213 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 (156 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 (169 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 |
| Showing all 165 (Edit, Save, CSV, Feed) |
