Showing 1-30 of 79 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
99493 | 2020-05-08 19:46 | 2020-05-15 11:46 | MySQL Server: Stored Routines | Verified (1414 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 |
108639 | 2022-09-29 1:15 | 2022-09-29 6:16 | MySQL Server: Stored Routines | Verified (546 days) | S2 | 8.0.29, 8.0.30 | Any | Any | Value of row_count() does not reset after a DROP TABLE in a procedure |
107160 | 2022-04-29 8:19 | 2024-03-04 4:11 | MySQL Server: Stored Routines | Verified (699 days) | S2 | 8.0.29 | Any | Any | Upgrade from 5.7 to 8.0 fails with syntax error while parsing an event |
39173 | 2008-09-02 8:39 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Verified (5686 days) | S3 | 5.1.26, 5.1 bzr | Any (Linux, Windows) | Any | Unable to remove event's ENDS |
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 |
44625 | 2009-05-03 9:59 | 2023-02-09 22:49 | MySQL Server: Stored Routines | Verified (5074 days) | S3 | 5.0, 5.1 | Any | Any | Triggers should not be loaded on SELECTs |
75830 | 2015-02-09 20:35 | 2015-02-09 21:04 | MySQL Server: Stored Routines | Verified (3335 days) | S2 | 5.5, 5.6 | Any | Any | Triggers cause statements using LAST_INSERT_ID(X) to return wrong value |
109525 | 2023-01-04 6:18 | 2023-01-04 12:52 | MySQL Server: Stored Routines | Verified (449 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 |
73145 | 2014-06-30 8:10 | 2014-07-01 8:52 | MySQL Server: Stored Routines | Verified (3558 days) | S3 | Any | Any | Suggest SQLSTATE for user warning/not found condition | |
63410 | 2011-11-23 21:17 | 2012-02-17 18:50 | MySQL Server: Stored Routines | Verified (4423 days) | S3 | 5.1.60, 5.1.61 | FreeBSD (x86_64) | Any | string corrupted in stored procedure concat and cast |
111526 | 2023-06-21 19:02 | 2023-06-22 13:41 | MySQL Server: Stored Routines | Verified (280 days) | S3 | 8.0 | Any | Any | STR_TO_DATE fails in MySQL stored function with error instead of returning NULL |
39324 | 2008-09-08 18:12 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (5680 days) | S3 | 5.1,6.0 | Any | Any | Stored procedures: Misleading error message |
64776 | 2012-03-27 11:12 | 2012-03-31 10:57 | MySQL Server: Stored Routines | Verified (4380 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 (4334 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 |
103965 | 2021-06-09 22:20 | 2021-06-10 6:41 | MySQL Server: Stored Routines | Verified (1022 days) | S2 | 8.0.25, 8.0.23 | Any | x86 | Stored procedure execution fails if contains a functional index |
9051 | 2005-03-08 14:20 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6238 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 |
72318 | 2014-04-11 17:36 | 2017-12-23 10:47 | MySQL Server: Stored Routines | Verified (3636 days) | S3 | 5.6.14-log | Any | Any | Stored function throws error 1137 if temporary table was not created right then |
44854 | 2009-05-13 20:32 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (5418 days) | S2 | 5.1.31-community-log, 5.1.34 | Any | Any | SP retruns 0 rows affected, but it had inserted 1 row |
86830 | 2017-06-26 21:07 | 2017-06-26 22:35 | MySQL Server: Stored Routines | Verified (2467 days) | S3 | 5.5, 5.6, 5.7, 8.0 | Any | Any | Silent UNSIGNED - SIGNED conversion with STRICT mode |
75685 | 2015-01-29 20:05 | 2015-02-02 14:57 | MySQL Server: Stored Routines | Verified (3342 days) | S3 | any 5.0+ | Any | Any | SHOW TRIGGERS removes escapes from body of CREATE statement |
12719 | 2005-08-22 10:51 | 2017-11-13 20:47 | MySQL Server: Stored Routines | Verified (5426 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 |
114419 | 2024-03-20 0:48 | 2024-03-20 8:44 | MySQL Server: Stored Routines | Verified (8 days) | S2 | 8.0.36 | Any | Any | SHOW COLUMNS on a temporary table in a procedure returns table doesn't exist |
104715 | 2021-08-25 6:22 | 2021-09-13 7:09 | MySQL Server: Stored Routines | Verified (933 days) | S1 | 8.0.26, 8.0.22+ | Windows (Windows 10 Enterprise 20H2) | x86 | Several calls of stored procedure return different values |
31643 | 2007-10-16 15:26 | 2022-12-12 5:54 | MySQL Server: Stored Routines | Verified (5594 days) | S3 | 5.1.22 | Any | Any | Setting an event to 'disable on slave' disables it on the master |
61328 | 2011-05-27 14:33 | 2013-04-10 6:35 | MySQL Server: Stored Routines | Verified (4689 days) | S3 | 5.5.11, 5.5.14 | Any | Any | SET profiling = 1 does not profile queries with stored functions |
46179 | 2009-07-14 18:07 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (1914 days) | S2 | 5.6, 5.7, 8.0 | Any | Any | set new.colname = default(colname) in trigger elicits a crazy error message |
44983 | 2009-05-20 12:49 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (5423 days) | S3 | 5.1.34 | Windows (probably any) | Any | Server drops comment after "END" + formating issues |
3052 | 2004-03-03 2:46 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6548 days) | S3 | 5.1 | Linux (SuSE 8.2) | Any | Rollback in stored procedure doesn't close cursor |
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 |
61568 | 2011-06-20 14:22 | 2011-06-25 11:30 | MySQL Server: Stored Routines | Verified (4664 days) | S2 | 5.5.15, 5.5.13 | Any | Any | Result is not grouped on sequential store procedure runs |
Showing 1-30 of 79 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |