| Showing 1-30 of 63 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 75830 | 2015-02-09 20:35 | 2015-02-09 21:04 | MySQL Server: Stored Routines | Verified (2010 days) | S2 | 5.5, 5.6 | Any | Any | Triggers cause statements using LAST_INSERT_ID(X) to return wrong value |
| 46333 | 2009-07-22 5:30 | 2011-02-16 23:44 | MySQL Server: Stored Routines | Verified (4033 days) | S3 | 5.0.83, 5.0 bzr | Any | Any | Can't update table 'tstamp' in stored function/trigger because it is already use |
| 52899 | 2010-04-16 19:31 | 2011-02-16 23:44 | MySQL Server: Stored Routines | Verified (3763 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 |
| 61568 | 2011-06-20 14:22 | 2011-06-25 11:30 | MySQL Server: Stored Routines | Verified (3339 days) | S2 | 5.5.15, 5.5.13 | Any | Any | Result is not grouped on sequential store procedure runs |
| 64776 | 2012-03-27 11:12 | 2012-03-31 10:57 | MySQL Server: Stored Routines | Verified (3055 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 (3009 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 |
| 70975 | 2013-11-21 16:44 | 2017-03-23 10:19 | MySQL Server: Stored Routines | Verified (1237 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 |
| 72318 | 2014-04-11 17:36 | 2017-12-23 10:47 | MySQL Server: Stored Routines | Verified (2311 days) | S3 | 5.6.14-log | Any | Any | Stored function throws error 1137 if temporary table was not created right then |
| 72544 | 2014-05-06 7:18 | 2014-05-28 4:53 | MySQL Server: Stored Routines | Verified (2289 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 (2233 days) | S3 | Any | Any | Suggest SQLSTATE for user warning/not found condition | |
| 73399 | 2014-07-25 18:32 | 2014-07-25 18:56 | MySQL Server: Stored Routines | Verified (2209 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 |
| 75392 | 2015-01-02 14:45 | 2015-01-19 16:03 | MySQL Server: Stored Routines | Verified (2031 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 (2017 days) | S3 | any 5.0+ | Any | Any | SHOW TRIGGERS removes escapes from body of CREATE statement |
| 61328 | 2011-05-27 14:33 | 2013-04-10 6:35 | MySQL Server: Stored Routines | Verified (3364 days) | S3 | 5.5.11, 5.5.14 | Any | Any | SET profiling = 1 does not profile queries with stored functions |
| 77186 | 2015-05-28 22:13 | 2017-03-16 8:09 | MySQL Server: Stored Routines | Verified (1891 days) | S3 | 5.5 5.6, 5.6.26, 5.7.17 | Any | Any | Implicit GRANT incorrectly issued after CREATE PROCEDURE |
| 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 (1518 days) | S3 | Any | Any | read_only is not allowed for SUPER because of prelocking | |
| 82679 | 2016-08-22 10:15 | 2016-08-22 12:27 | MySQL Server: Stored Routines | Verified (1450 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 | 2016-12-02 11:07 | MySQL Server: Stored Routines | Verified (1348 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 (1142 days) | S3 | 5.5, 5.6, 5.7, 8.0 | Any | Any | Silent UNSIGNED - SIGNED conversion with STRICT mode |
| 91585 | 2018-07-10 1:16 | 2018-08-27 11:06 | MySQL Server: Stored Routines | Verified (763 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 |
| 95734 | 2019-06-11 11:54 | 2019-06-11 12:26 | MySQL Server: Stored Routines | Verified (427 days) | S3 | 8.0.16, 5.7.26 | Any | Any | Failing SET statement in a stored procedure changes variables |
| 100249 | 2020-07-17 14:44 | 2020-07-17 18:52 | MySQL Server: Stored Routines | Verified (25 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 (21 days) | S2 | MySQL8.0.20 | Any (rhel-7.4) | x86 (intel x86) | cursor in procedure works abnormally for with_clause |
| 44398 | 2009-04-22 3:16 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (3590 days) | S3 | 5.1 | Any | Any | MySQL does not support external stored routines |
| 37515 | 2008-06-19 6:24 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (4436 days) | S3 | 5.1.25, 5.0, 6.0 | Any | Any | CHECK TABLE not allowed in stored procedures |
| 46179 | 2009-07-14 18:07 | 2018-12-31 3:08 | MySQL Server: Stored Routines | Verified (589 days) | S2 | 5.6, 5.7, 8.0 | Any | Any | set new.colname = default(colname) in trigger elicits a crazy error message |
| 39173 | 2008-09-02 8:39 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (4361 days) | S3 | 5.1.26, 5.1 bzr | Any (Linux, Windows) | Any | Unable to remove event's ENDS |
| Showing 1-30 of 63 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
