| Showing all 56 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 1382 | 2003-09-23 9:40 | 2022-12-04 20:45 | MySQL Server: Prepared statements | Verified (6748 days) | S2 | 4.0, 4.1, 5.0, 5.1 | Any (all) | Any | SQLDescribeParam returns the same type information |
| 2812 | 2004-02-15 12:18 | 2024-08-28 9:08 | MySQL Server: Prepared statements | Verified (6503 days) | S3 | 5.x | Linux (Linux/Windows) | Any | wrong value for stmt->field_count |
| 6698 | 2004-11-18 16:52 | 2011-02-16 23:43 | MySQL Server: Prepared statements | Verified (7096 days) | S4 | 4.1.8 | Any (all) | Any | Native SQL prepared statements without using variables |
| 7113 | 2004-12-08 18:31 | 2011-02-16 23:43 | MySQL Server: Prepared statements | Verified (7093 days) | S4 | 4.1.7 Pro | Any (All) | Any | Include GRANT, USE and CREATE INDEX in Prepared Statement api. |
| 8323 | 2005-02-04 18:05 | 2022-12-04 20:45 | MySQL Server: Prepared statements | Verified (7307 days) | S4 | 3.1.6, 3.2.0-alpha | Any (WK2K/XP) | Any | LOAD DATA INFILE not supported anymore? in preparedStatement |
| 13572 | 2005-09-28 15:33 | 2022-12-04 20:45 | MySQL Server: Prepared statements | Verified (7099 days) | S4 | 5.0.13 | Any (all) | Any | PREPARE statement breaks on locally declared variables |
| 16564 | 2006-01-17 15:36 | 2011-02-16 23:43 | MySQL Server: Prepared statements | Verified (7110 days) | S4 | Any | Any | Efficient way to use IN() in prepared statements | |
| 22001 | 2006-09-04 16:07 | 2011-02-16 23:43 | MySQL Server: Prepared statements | Verified | S4 | 5.0, 5.1, etc | Any | Prepared Statements unusable with unbuffered queries, mysql_stmt_refetch needed | |
| 22774 | 2006-09-28 10:24 | 2022-12-04 20:45 | MySQL Server: Prepared statements | Verified (4192 days) | S2 | 5.0.24a | Linux (Fedora Core 5 and Windows XP) | Any | Incorrectly reported data truncation with server prepared statements |
| 24176 | 2006-11-10 10:32 | 2020-05-03 20:45 | MySQL Server: Prepared statements | Verified (6174 days) | S3 | 5.0.30 | Any | Any | bigint.test fails with --cursor-protocol |
| 26570 | 2007-02-22 15:02 | 2022-12-04 20:45 | MySQL Server: Prepared statements | Verified (6714 days) | S4 | 5,1.14/5.1BK | Linux (Linux) | Any | CHECK TABLE not allowed in PSs |
| 26824 | 2007-03-03 14:21 | 2018-09-09 20:45 | MySQL Server: Prepared statements | Verified (4197 days) | S2 | 5.1.17-bk, probably 4.1 and 5.0 too | Any (All) | Any | Libmysql, possibly C/XYZ, does not handle error of COM_STMT_SEND_LONG_DATA |
| 27910 | 2007-04-18 1:53 | 2011-02-16 23:43 | MySQL Server: Prepared statements | Verified (6663 days) | S4 | 5.0.37-community-nt | Any | Any | Suggested feature for triggers and functions |
| 31625 | 2007-10-16 2:06 | 2024-05-31 6:03 | MySQL Server: Prepared statements | Verified (6482 days) | S4 | 5.0.44 | Linux (Gentoo Linux) | Any | PREPARED STATEMENT syntax does not allow to create TRIGGERS |
| 38732 | 2008-08-11 22:12 | 2022-12-04 20:45 | MySQL Server: Prepared statements | Verified (6174 days) | S4 | 6.0 | Any | Any | Global Prepared Statement |
| 40038 | 2008-10-15 9:56 | 2022-12-04 20:45 | MySQL Server: Prepared statements | Verified (6117 days) | S3 | any | Any | Any | variables declared inside store procedures should build prepared statements |
| 42337 | 2009-01-26 8:05 | 2022-12-04 20:45 | MySQL Server: Prepared statements | Verified (6013 days) | S1 | 5.1.25rc | Windows | Any | DROP EVENT:this command is not supported in the prepared statement protocol yet. |
| 42490 | 2009-01-30 18:55 | 2023-09-15 8:12 | MySQL Server: Prepared statements | Verified (6007 days) | S2 | 5.1.30, 4.1, 5.0, 5.1, 6.0 bzr | Any | Any | mysql_stmt_result_metadata incorrectly returns null for some statements |
| 44711 | 2009-05-07 9:12 | 2011-02-16 23:43 | MySQL Server: Prepared statements | Verified | S4 | 5.1, ... | Any | Any | Prepared statements should be lazy to send metadata at execute stage |
| 53216 | 2010-04-27 17:39 | 2022-12-04 20:45 | MySQL Server: Prepared statements | Verified | S3 | 5.5.3-m3, 5.5.4-m3 | Any | Any | Unrelated DDL causes repreparation of a prepared statement |
| 62257 | 2011-08-25 5:27 | 2013-07-17 13:56 | MySQL Server: Prepared statements | Verified (4759 days) | S2 | 5.5.8-enterprise-commercial, 5.1.64 | Any | Any | Application hangs while sending 1GB data using mysql_stmt_send_long_data() |
| 65800 | 2012-07-03 22:27 | 2016-02-25 12:24 | MySQL Server: Prepared statements | Verified | S4 | 5.6.6 | Any | Any | Add GQL flag for internal prepare/execute of prepared statements |
| 67225 | 2012-10-14 15:02 | 2014-04-29 8:39 | MySQL Server: Prepared statements | Verified (4095 days) | S2 | 5.6.10 | Windows (XP SP3 32bit) | Any | binary data truncated when using UNION in prepared statement |
| 69083 | 2013-04-26 18:10 | 2016-02-25 12:24 | MySQL Server: Prepared statements | Verified | S3 | 5.6.11 | Any | Any | Syntax error in preparing statement for SET PASSWORD |
| 69218 | 2013-05-13 17:57 | 2024-03-26 7:38 | MySQL Server: Prepared statements | Verified | S2 | 5.6.11 | Any | Any | P_S doesn't record SQL or digest for prepared statements |
| 69383 | 2013-06-02 20:57 | 2017-03-28 0:30 | MySQL Server: Prepared statements | Verified (4425 days) | S3 | 5.1, 5.5, 5.6, 5.7 | Any | Any | PREPARE from a 800 KB string causes ER_PARSE_ERROR "memory exhausted" |
| 70905 | 2013-11-14 0:42 | 2013-11-14 0:42 | MySQL Server: Prepared statements | Open | S4 | 5.x | Any | Any | Automatic global cache for prepared statements |
| 78523 | 2015-09-22 22:54 | 2015-09-23 9:31 | MySQL Server: Prepared statements | Verified (3583 days) | S3 | 5.7.8-rc-log community version, 5.6.26, 5.6.28, 5.7.10 | Debian (8.1) | Any | can't see temporary table in statement with a subquery and a function |
| 81981 | 2016-06-23 2:22 | 2016-06-23 7:48 | MySQL Server: Prepared statements | Verified (3309 days) | S3 | 5.6, 5.7 | Any | Any | Basic automation functionality missing from prepared statements |
| 82139 | 2016-07-07 8:41 | 2016-07-07 10:33 | MySQL Server: Prepared statements | Verified (3295 days) | S2 | 5.7.13 | Any | Any | MySQL server sends internal column type over the wire |
| 91221 | 2018-06-12 7:45 | 2018-06-12 10:33 | MySQL Server: Prepared statements | Verified (2590 days) | S2 | innodb_version = 5.7.21, 5.7.22 | Any | Any | REVOKE ALL PRIVILEGES, GRANT OPTION does not work in stored procedure |
| 96580 | 2019-08-19 2:54 | 2019-08-19 5:09 | MySQL Server: Prepared statements | Verified (2157 days) | S3 | MySQL-5.7.23, 5.7.27 | Any | Any | Using a prepare-stmts with timestampadd function will get an incorrect result |
| 99359 | 2020-04-26 10:57 | 2020-04-27 12:43 | MySQL Server: Prepared statements | Verified (1905 days) | S3 | 5.6.47, 5.7.29, 8.0.19 | Any | Any | Order by in group_concat with prepare statement returns unexpected results |
| 101630 | 2020-11-16 15:58 | 2022-04-02 4:50 | MySQL Server: Prepared statements | Verified (1701 days) | S4 | 8.0.22 | Any | Any | Consider increasing placeholder limit to be > 64k |
| 103765 | 2021-05-21 9:28 | 2024-08-19 14:09 | MySQL Server: Prepared statements | Verified (1516 days) | S3 | Java MySQL Driver 8.0.24, 8.0.25 | Any | Any | Statement prepare hangs |
| 105257 | 2021-10-19 3:58 | 2021-10-19 7:03 | MySQL Server: Prepared statements | Verified (1365 days) | S3 | 8.0, 5.7.35, 8.0.26 | Any | Any | prepare statement return result is different from execute it directly |
| 108293 | 2022-08-26 9:30 | 2022-09-05 7:43 | MySQL Server: Prepared statements | Verified (1044 days) | S2 | 8.0.29 | Any | Any | Prepared statement does not use generated column index |
| 108432 | 2022-09-08 15:06 | 2022-09-08 17:56 | MySQL Server: Prepared statements | Verified (1041 days) | S3 | 5.7.38/5.7.39 | Any | Any | Using the prepare statement causes an "unknown column in 'order clause'" error |
| 109917 | 2023-02-03 11:38 | 2023-02-06 5:08 | MySQL Server: Prepared statements | Verified (892 days) | S6 | 8.0, 8.0.32 | Any | Any | server crash when execute create table with check constraint in ps mode |
| 110523 | 2023-03-28 3:32 | 2023-03-28 6:37 | MySQL Server: Prepared statements | Verified (840 days) | S4 | all, 5.7, 8.0 | Any | Any | expose the prepare statement map size to public for trouble shooting |
| 110720 | 2023-04-19 1:21 | 2023-04-19 6:13 | MySQL Server: Prepared statements | Verified (818 days) | S6 | 8.0.32 | Any | Any | Contribute by tencent: prepared statement can't execute match+rollup twice. |
| 111310 | 2023-06-07 6:51 | 2023-06-08 8:30 | MySQL Server: Prepared statements | Verified (768 days) | S3 | 8.0.33 | Ubuntu (22.04) | x86 (x86_64) | Prepared statement with CTE memory leak |
| 111560 | 2023-06-26 9:33 | 2023-06-26 13:53 | MySQL Server: Prepared statements | Verified (750 days) | S3 | 8.0 | Any | Any | A Prepare statement with cursor on will hang when executed after cursor closed |
| 111722 | 2023-07-11 14:31 | 2023-07-12 5:24 | MySQL Server: Prepared statements | Verified (734 days) | S6 | 8.0.33 | Ubuntu (22.04) | x86 (x86_64) | Create view assertion error |
| 111921 | 2023-07-31 7:57 | 2023-08-11 12:14 | MySQL Server: Prepared statements | Verified (714 days) | S3 | 8.0 | Any | Any | Reusing prepared statement for different data types, different outcomes are obse |
| 112011 | 2023-08-09 12:06 | 2023-08-17 12:21 | MySQL Server: Prepared statements | Verified (705 days) | S3 | 8.0 | Any | Any | RESOURCE GROUP hint fails when used within a prepared statement |
| 112105 | 2023-08-18 2:51 | 2023-08-18 9:21 | MySQL Server: Prepared statements | Verified (697 days) | S3 | 8.1.0, 8.0.34 | Ubuntu (22.04) | x86 (x86_64) | Create table from prepared statement issues |
| 112703 | 2023-10-12 12:13 | 2023-10-12 12:56 | MySQL Server: Prepared statements | Verified (642 days) | S3 | Any | Any | prepare statment has no warning comping to not prepare statment. | |
| 113248 | 2023-11-28 10:57 | 2023-11-29 8:52 | MySQL Server: Prepared statements | Verified (594 days) | S6 | 8.2.0, 8.0.35 | Ubuntu (22.04) | x86 (x86_64) | Execute alter table heap-use-after-free |
| 113301 | 2023-12-01 7:22 | 2023-12-01 8:53 | MySQL Server: Prepared statements | Verified (592 days) | S2 | 8.0.35, 8.0.31 | Any | Any | using preparation statement to query the time type data, some data is not found |
| 113843 | 2024-02-01 2:49 | 2024-02-01 8:09 | MySQL Server: Prepared statements | Verified (530 days) | S3 | 8.0.32, 8.0.36 | Any | Any | prepared json query can not use index |
| 114056 | 2024-02-19 23:03 | 2024-02-22 10:56 | MySQL Server: Prepared statements | Verified (509 days) | S5 | 8.0.32, 8.0.22+ | Any | Any | Performance degredation using REGEXP in statement with parameters vs query |
| 114338 | 2024-03-13 16:41 | 2024-03-19 11:10 | MySQL Server: Prepared statements | Verified (488 days) | S3 | 8.0 | Any | Any | Client might receive incorrect data in ps-protocol |
| 117808 | 2025-03-27 7:21 | 2025-03-27 10:01 | MySQL Server: Prepared statements | Verified (110 days) | S3 | 8.0.41, 8.4.2 | Any | Any | Unexpected JSON column DML error with prepare statement |
| 117903 | 2025-04-07 18:28 | 2025-04-08 14:29 | MySQL Server: Prepared statements | Verified (98 days) | S4 | 8.x, 9.x | Any | Any | Please consider allowing preparing and executing - and maybe closing - a statement in a single round-trip. |
| 118607 | 2025-07-08 18:58 | 2025-07-09 10:02 | MySQL Server: Prepared statements | Verified (6 days) | S4 | 9.3.0 | Any | Any | Providing multiple values for a single parameter, e.g. id IN (?) |
| Showing all 56 (Edit, Save, CSV, Feed) |
