« Show Previous 1000 Entries | Showing 1001-2000 of 2775 (Edit, Save, CSV, Feed) | Show Next 1000 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
98702 | 2020-02-21 6:36 | 2020-02-21 6:54 | MySQL Server: Replication | Duplicate (1519 days) | S3 | 8.0 | Any | Any | grant grant option statements are binlogged wrongly |
36314 | 2008-04-24 11:16 | 2008-04-24 11:47 | MySQL Server: Documentation | Not a Bug (5839 days) | S3 | all | Any | Any | GRANT is missing in SQL documentation |
104238 | 2021-07-07 15:16 | 2021-07-08 6:23 | MySQL Server: Security: Privileges | Duplicate (1016 days) | S3 | 8.0.24 | Any | Any | Grants in prepare with 2 triggers on the same table |
8093 | 2005-01-22 20:08 | 2005-01-24 17:19 | MySQL Server: MyISAM storage engine | Closed (7025 days) | S3 | 4.1.8 | Any (*) | Any | GROUP BY can alter some values of a grouped by column |
84537 | 2017-01-17 14:11 | 2017-10-24 14:31 | MySQL Server: Optimizer | Closed (2418 days) | S3 | 8.0.1 | Any | Any | GROUP BY DESC gives wrong result when groups on DECIMAL and sees a NULL |
70894 | 2013-11-13 9:02 | 2013-11-13 11:41 | MySQL Server | Not a Bug (3810 days) | S2 | 5.5, 5.6 | Any | Any | GROUP BY HAVING with MAX returns not all results |
99133 | 2020-03-31 15:08 | 2024-01-30 17:50 | MySQL Server: Group Replication | Verified (1473 days) | S3 | 8.0.19 | Any | Any | Group Replication Performance Degradation with partial network outage |
98473 | 2020-02-04 4:18 | 2020-03-02 10:18 | MySQL Server: Group Replication | Not a Bug (1509 days) | S3 | 8.0.18 | Any | Any | group replication will be block after lock table |
4463 | 2004-07-08 15:01 | 2007-05-04 12:13 | MySQL Server: Replication | Not a Bug (6195 days) | S4 | <4.1 | Any (doesn't matter) | Any | GROUP takes the first-found values |
78536 | 2015-09-24 6:50 | 2018-05-08 13:11 | MySQL Server: DML | Not a Bug (2173 days) | S2 | 5.6.22, 5.7.8 | Any | Any | group_concat returns incorrect result |
69515 | 2013-06-19 14:55 | 2013-06-19 15:11 | MySQL Server: Options | Verified (3957 days) | S3 | 5.1, 5.5, 5.6, 5.7 | Any | Any | group_concat_max_len >= 4Gb does not work |
30324 | 2007-08-08 23:31 | 2007-10-23 16:34 | MySQL Server: Optimizer | Closed (6023 days) | S2 | 5.0-bk, 5.1-bk | Any | Any | Grouping queries with COUNT(DISTINCT bit column) return wrong results |
72195 | 2014-04-01 18:50 | 2016-02-25 12:24 | MySQL Server: Replication | Verified | S3 | 5.6.17 | Any | Any | GTID restriction with non-transactional storage engines unclear |
37742 | 2008-06-30 14:33 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5559 days) | S3 | 5.1.23-rc | Any | Any | HA_EXTRA_KEYREAD flag is set when key contains only prefix of requested column |
53561 | 2010-05-11 12:20 | 2016-10-16 20:45 | MySQL Server | Verified (5089 days) | S3 | 5.1.46, 5.5 | Any | Any | HA_EXTRA_WRITE_CAN_REPLACE does not work with row based replication |
76436 | 2015-03-23 0:23 | 2016-06-18 21:25 | MySQL Server: DML | Closed (3313 days) | S1 | 5.7.6, 5.7.8, 8.0.0 | Any | Any | handle_fatal_signal (sig=11) in st_select_lex::merge_derived |
75958 | 2015-02-18 18:21 | 2015-02-18 22:32 | MySQL Server: DML | Can't repeat (3348 days) | S1 | 5.7.5-m15 | Any | Any | handle_fatal_signal (sig=11) in String::replace | INSERT into TEMPORARY table |
70949 | 2013-11-19 5:31 | 2013-12-29 1:00 | MySQL Server: Connection Handling | No Feedback (3765 days) | S3 | 5.1+ | Any | Any | handshake charset leads error data (Is it a bug in MySQL or in java-connector?) |
72108 | 2014-03-24 9:45 | 2014-08-17 12:29 | MySQL Server: Command-line Clients | Verified (3679 days) | S3 | 5.6.16, 5.6.18, 5.7.5 | Any | Any | Hard to read history file |
99934 | 2020-06-19 2:32 | 2020-09-21 14:39 | MySQL Server: Optimizer | Verified (1400 days) | S5 | 8.0.20 | Any | Any | Hash join adds columns to the hash table that is not needed. |
111435 | 2023-06-15 11:14 | 2023-06-15 13:16 | MySQL Server: Optimizer | Duplicate (309 days) | S3 | 8.0.32 | Any | Any | Hash join results in incorrect query results |
111414 | 2023-06-14 9:26 | 2023-06-16 9:32 | MySQL Server: Optimizer | Can't repeat (308 days) | S3 | 8.0.33 | Any | Any | HASH JOIN results in wrong query results |
19447 | 2006-04-30 16:53 | 2006-04-30 16:53 | MySQL Server | Open | S4 | 5 | Any (all) | Any | Have default values for fields when using INSERT on a view |
82805 | 2016-08-31 2:20 | 2016-08-31 9:47 | MySQL Server: Optimizer | Verified (2788 days) | S2 | 5.7.10, 5.7.14 | Any | Any | Having clause condition fails on join table with TEXT field |
70684 | 2013-10-22 8:13 | 2013-10-22 11:35 | MySQL Server: Optimizer | Verified (3832 days) | S3 | 5.5.33, 5.6.14 | Any | Any | HAVING referring to subquery results in WARNING 1292 |
632 | 2003-06-11 3:58 | 2003-06-11 3:58 | MySQL Server | Closed (7618 days) | S2 | 4.1 | Any (all) | Any | heap b-tree index scan error |
103603 | 2021-05-06 8:25 | 2021-05-21 12:34 | MySQL Server | Can't repeat (1064 days) | S3 | 5.7.x;8.0.x | Any | Any | heap use after free |
49610 | 2009-12-11 6:29 | 2011-02-16 23:44 | MySQL Server | Closed (5243 days) | S3 | 5.1.41 | Any | Any | help use the mysql 5.1.41 |
61520 | 2011-06-15 7:51 | 2013-03-22 1:23 | MySQL Server: Installing | Closed (4046 days) | S3 | 5.1.57 | Any | Any | help-tableformat doesn't match help-files |
84557 | 2017-01-18 16:50 | 2017-01-19 19:07 | MySQL Server: Errors | Verified (2647 days) | S4 | 5.6 and 5.7 | Any | Any | Hide specific warnings from SHOW WARNINGS. |
76402 | 2015-03-20 4:43 | 2015-03-21 6:48 | MySQL Server | Closed (3317 days) | S1 | 5.7.6-m16 | Any | Any | High CPU usage issue/stuck queries with 5.7.6-m16 |
108605 | 2022-09-25 2:12 | 2022-09-26 12:14 | MySQL Server: JSON | Not a Bug (571 days) | S3 | Any | Any | How to convert json null to sql null using json_table? | |
37326 | 2008-06-11 3:05 | 2008-06-11 4:28 | Connector / J | Closed (5791 days) | S3 | MYSQL 4.11 | Any | Any | How to find the MYSQL error codes in Java when db exception occurs |
50627 | 2010-01-26 15:21 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5194 days) | S3 | 5.5.1-m2 | Any | Any | how to insert a TIMESTAMP of the last hour of daylight savings |
64428 | 2012-02-23 2:15 | 2012-02-23 4:14 | MySQL Enterprise Monitor: Server | Not a Bug (4439 days) | S5 | 5 | Any | Any | How To insert data to table from other Host in Public IP |
62662 | 2011-10-09 21:27 | 2012-12-26 8:15 | MySQL Server | Not a Bug (4132 days) | S4 | Any | Any | how to retrieve multiple insert IDs | |
106312 | 2022-01-27 18:14 | 2022-02-09 13:20 | MySQL Server: Optimizer | Verified (812 days) | S3 | 5.7 | Any (Ubuntu 20.04.3 LTS) | Any (Intel(R) Core(TM) i7-10700 CPU @ 2.90GHz) | Huge value in GROUP BY clause cause unexpected output |
106328 | 2022-01-29 0:40 | 2022-02-09 1:33 | MySQL Server: Optimizer | Duplicate (800 days) | S3 | 8.0.28, 5.7.37 | Any | Any | Huge value in ORDER BY clause cause unexpected output |
106020 | 2022-01-02 13:30 | 2022-01-03 8:42 | MySQL Workbench: SQL Editor | Can't repeat (837 days) | S3 | Any | Any | I am not able to insert values to a particular table and sql is not responding | |
61141 | 2011-05-12 6:13 | 2011-07-07 6:37 | MySQL Server: DML | Not a Bug (4670 days) | S4 | 5.1.56-log | Any | Any | I am unable to insert/update only blank space in any field. |
66029 | 2012-07-26 17:21 | 2012-07-27 4:12 | MySQL Workbench | Duplicate (4284 days) | S3 | Any | Any | I was using the insert option to build a table when I got a warning that there w | |
77301 | 2015-06-10 17:28 | 2016-06-18 21:26 | MySQL Server: InnoDB storage engine | Closed (3095 days) | S3 | 5.6/5.7/8.0 | Any | Any | I_S.innodb_sys_tablestats.modified_counter doesn't change on UPDATE |
34050 | 2008-01-25 4:40 | 2008-07-25 19:31 | MySQL Server: Replication | Can't repeat (5747 days) | S2 | 5.1.23 | Any | Any | I/O thread disconnects/killed when replicating under load with partition tables |
44856 | 2009-05-13 21:29 | 2009-12-22 23:33 | MySQL Server: DB2SE for IBM i | Closed (5393 days) | S2 | 5.1.33 | Any | Any | IBMDB2I gives misleading 2504 error |
43343 | 2009-03-03 22:13 | 2010-12-07 8:53 | MySQL Server: DB2SE for IBM i | Won't fix (4882 days) | S3 | 5.1.30, 5.0, 5.1, 6.0 bzr | Any (Linux, IBM i5os) | Any | ibmdb2i Storage Engine does not honor timezone settings with INSERT |
113647 | 2024-01-16 8:55 | 2024-03-07 20:37 | MySQL Server: Optimizer | Closed (43 days) | S5 | 8.0.35,8.2.0 | Any | Any | identical tables are checked in HashJoin because of no STOP_AT_MATERIALIZATION |
44363 | 2009-04-20 9:56 | 2011-02-16 23:43 | MySQL Server: General | Verified (5477 days) | S2 | 5.1.15, 5.1.35-bzr | Any | Any | IDIV not rounding off float/decimals correctly ? |
84792 | 2017-02-02 12:49 | 2017-05-03 13:18 | MySQL Server: Group Replication | Can't repeat (2543 days) | S3 | 5.7.17 | Any | Any | Idle GR Cluster: Member CPU hog |
3081 | 2004-03-06 6:48 | 2004-03-08 5:51 | MySQL Server: Replication | Closed (7347 days) | S3 | 4.0 | Any (all) | Any | if an INSERT DELAYED is killed, it is binlogged as killed but it's not needed |
83148 | 2016-09-26 8:57 | 2023-04-16 19:29 | MySQL Server: Optimizer | Closed (2684 days) | S3 | 5.5 | Any | Any | IF and friends gives wrong type for signed and unsigned integer |
7714 | 2005-01-06 20:13 | 2005-01-06 20:39 | MySQL Server: MyISAM storage engine | Closed (7043 days) | S3 | 4.0.23 | Any (all) | Any | if disk full, sometimes MyISAM doesn't wait for free space, corrupts table |
989 | 2003-08-04 1:16 | 2011-02-16 23:40 | MySQL Server: Locking | Closed (5007 days) | S1 | 4.0 and higher | Any (all) | Any | If DROP TABLE while there's an active transaction, wrong binlog order |
106208 | 2022-01-19 7:37 | 2022-01-21 9:27 | MySQL Server: Optimizer | Verified (821 days) | S3 | 8.0.27, 8.0.28, 5.7.37 | Any | Any | IF function with DECIMAL get different precision result |
1113 | 2003-08-21 8:41 | 2003-08-22 7:02 | MySQL Server | Closed (7546 days) | S3 | 4.0 | Any (all) | Any | If in a trans, a non-trans table is updated by INSERTSELECT, ROLLBACK, no error |
35352 | 2008-03-17 21:40 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (4936 days) | S1 | 5.0 5.1 6.0 | Any | Any | If InnoDB crashes with UNDO slots full error the error persists on restart |
491 | 2003-05-24 7:40 | 2003-07-01 5:38 | MySQL Server: Replication | Closed (7598 days) | S3 | 4.0.13 | Any (all) | Any | If INSERT SELECT fails in a MyISAM table but has changed row, nothing in binlog |
8475 | 2005-02-12 14:19 | 2005-03-08 0:35 | MySQL Server | Closed (6982 days) | S3 | 4.1 | Any (all) | Any | If multi-query: query does not get into slow query log if it's not last |
73936 | 2014-09-16 16:50 | 2019-01-22 15:35 | MySQL Server: Replication | Closed (1914 days) | S3 | 5.6.20 | Any | Any | If the storage engine supports RBR, unsafe SQL statementes end up in binlog |
319 | 2003-04-23 14:32 | 2011-02-16 23:40 | MySQL Server: Replication | Closed (5462 days) | S3 | 4.0, 4.1, 5.1 | Any (all) | Any | if while a non-transactional slave is replicating a transaction, possiblproblem |
79114 | 2015-11-04 7:53 | 2015-11-18 18:24 | MySQL Server: DML | Closed (3075 days) | S3 | 5.7.8, 5.7.9 | Any | Any | IF(bool, date str, date str) throws ERROR in UPDATE |
56899 | 2010-09-21 15:43 | 2011-02-16 23:44 | MySQL Server: DML | Closed (4959 days) | S3 | 5.5.5-m3-log | Any (XP Pro) | Any | IFNULL Evaluation inside CONCAT_WS Incorrect |
96049 | 2019-07-01 14:09 | 2019-07-02 8:21 | MySQL Server: DML | Verified (1753 days) | S4 | 8.0 | Any | Any | IGNORE clause which doesn't override strict mode |
25058 | 2006-12-14 4:19 | 2011-02-16 23:43 | MySQL Server: General | Closed (5456 days) | S3 | 5.0.64, 5.0.30, 4.0.26 | Any | Any | ignored return codes in memory allocation functions |
70346 | 2013-09-15 4:04 | 2013-12-10 6:47 | MySQL Server: Replication | Verified (3783 days) | S1 | 5.6.16 | Any | Any | Illegal mix of collations (gbk_chinese_ci,COERCIBLE) |
85224 | 2017-02-28 10:59 | 2020-05-19 8:07 | MySQL Server: Charsets | Closed (2587 days) | S3 | 8.0.1 | Any | Any | Illegal mix of collations for time/varchar |
38906 | 2008-08-20 9:02 | 2011-02-16 23:43 | MySQL Workbench | Closed (5370 days) | S3 | 5.0.24 | Any | Any | illegal/no quoting in Insert Editor |
60940 | 2011-04-21 3:56 | 2011-04-21 7:28 | MySQL Server: General | Duplicate (4747 days) | S4 | Any | Any | Implement Common Table Expressions as defined by the ANSI SQL 99 standard | |
39466 | 2008-09-16 3:03 | 2012-05-18 20:19 | MySQL Server: DML | Duplicate (5656 days) | S4 | 5.0+ | Any | Any | Implement INSTEAD OF Triggers |
67810 | 2012-12-05 6:31 | 2013-03-24 4:29 | MySQL Workbench: SQL Editor | Closed (4044 days) | S4 | Any | Any | Implement QueryBrowser feature to right-click column headers to copy columns | |
9018 | 2005-03-07 12:34 | 2019-12-16 4:52 | MySQL Server: DML | Verified (6041 days) | S4 | Any | Any | Implement SQL 2003 MERGE command | |
71087 | 2013-12-05 8:16 | 2013-12-10 18:27 | Connector / C++ | Verified (3783 days) | S4 | Any | Any | Implement Statement::getGeneratedKeys() | |
77639 | 2015-07-07 12:40 | 2019-12-11 1:09 | MySQL Server: Optimizer | Closed (1652 days) | S4 | 5.7 | Any | Any | Implement VALUES equivalent to a query specification |
55731 | 2010-08-04 8:36 | 2013-04-14 20:45 | MySQL Server: InnoDB Plugin storage engine | Verified (5007 days) | S4 | any | Any | Any | Implementation of innodb_min_dirty_pages_pct |
79906 | 2016-01-11 3:55 | 2016-01-13 9:21 | MySQL Server: DML | Verified (3019 days) | S3 | 5.7.8, 5.6.28, 5.7.10, 5.5.48 | Any | Any | Implicit and Explicit convert from bigint unsigned to signed give different val |
100965 | 2020-09-27 1:20 | 2021-04-01 0:40 | MySQL Server: Data Dictionary | Verified (1299 days) | S3 | 8.0.21 | Any | Any | import table has auto increment, after restart,report Duplicate entry error |
73406 | 2014-07-27 4:34 | 2014-08-29 18:33 | Connector / J | Can't repeat (3521 days) | S2 | 5.1.31 | Any | Any | import.sql in V 5.1.29 works, but not in 5.1.31 |
14053 | 2005-10-15 23:44 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (5280 days) | S4 | 5.0.13-rc-standard-log | Any (any) | Any | Impossible to access auto_increment values in triggers on insert |
35205 | 2008-03-11 10:34 | 2008-03-15 12:52 | MySQL Workbench | Closed (5879 days) | S3 | 5.0.14b | Any | Any | Impossible to insert booleans |
28478 | 2007-05-16 17:05 | 2007-06-20 0:51 | MySQL Server: MyISAM storage engine | Closed (6148 days) | S2 | 5.0.42, * | Any | Any | Improper key_cache_block_size corrupts MyISAM tables |
104608 | 2021-08-12 22:31 | 2021-11-10 13:24 | MySQL Server: InnoDB storage engine | Verified (891 days) | S4 | 5.7.35, 8.0.26 | Any | Any | Improve error message for ALTER failing because concurrent Duplicate entry. |
75180 | 2014-12-11 13:22 | 2014-12-11 13:22 | MySQL Server | Open | S4 | 5.6.20/5.7 | Any | Any | Improve privilege granularity of optimize table |
87678 | 2017-09-06 9:16 | 2018-02-13 8:22 | MySQL Server: Data Types | Verified (2257 days) | S4 | 5.7.18 | Any | Any | Improve the strict mode for DECIMAL |
55978 | 2010-08-13 18:54 | 2011-02-16 23:44 | MySQL Server: DML | No Feedback (4934 days) | S4 | Any | Any | Improvement Mysql Date Manipulation Language | |
102638 | 2021-02-18 9:36 | 2021-04-15 13:06 | MySQL Server: Stored Routines | Verified (1100 days) | S4 | 8.0 | Any | Any | improvements for TRIGGER |
112655 | 2023-10-07 8:00 | 2023-10-10 9:41 | MySQL Server: JSON | Duplicate (192 days) | S4 | 8.0 | Any | Any | In `json_{object|array}`, types of values are inconsistent with scalar function |
79548 | 2015-12-07 15:12 | 2015-12-09 19:42 | MySQL Server: Documentation | Closed (3054 days) | S3 | 5.7.8 | Any | Any | In "Update t1 set b(date) = c(datetime)", micro seconds are rounded |
13311 | 2005-09-19 0:13 | 2006-09-20 15:28 | MySQL Server: Optimizer | Closed (6421 days) | S3 | 5.0 | Any (All) | Any | IN + binary lead to incorrect SELECT results |
78127 | 2015-08-18 12:16 | 2019-11-26 21:50 | MySQL Server: DML | Closed (1606 days) | S3 | 5.6.22, 5.5.46, 5.6.26 | Any | Any | In consistent behavior between similar UPDATE sqls, error vs warning |
79830 | 2016-01-04 9:42 | 2016-01-04 12:08 | MySQL Server: DML | Verified (3028 days) | S1 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | IN operator works incorrectly with NULL |
44032 | 2009-04-02 6:41 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5052 days) | S3 | 5.0.3+ | Any | Any | In ROW_FORMAT=REDUNDANT, update UTF-8 CHAR to/from NULL is not in-place |
104732 | 2021-08-26 7:20 | 2022-02-25 9:53 | MySQL Server: Security: Privileges | Verified (967 days) | S3 | 8.0.25, 8.0.26, 8.0.28 | Any | Any | In the case of using the role, there is a problem with the acl check of the view |
113369 | 2023-12-08 3:51 | 2024-01-05 13:06 | MySQL Server: Partitions | Verified (133 days) | S3 | 8.0.34, 8.0.35 | Any | Any | In the hash partition table, the query result is error. |
89333 | 2018-01-20 9:25 | 2018-01-20 23:24 | MySQL Server: DML | Not a Bug (2281 days) | S3 | 5.6.38,5.7.21 | Any | Any | in Unknown column |
59570 | 2011-01-17 21:22 | 2012-10-15 13:41 | Tests: Server | Closed (4204 days) | S3 | 5.5.8 | Any | Any | in_multicolumn_calendar_unique_constraint_ignore fails with wrong TZ |
99933 | 2020-06-19 1:30 | 2020-11-11 8:38 | MySQL Server: Optimizer | Closed (1255 days) | S3 | 8.0 | Any | Any | In-memory hash join will only use two-thirds of join buffer |
23266 | 2006-10-13 16:35 | 2013-05-30 7:07 | Connector / ODBC | Closed (3977 days) | S2 | 3.x | Any (all) | Any | Inability to execute statements with numeric parameters in a german locale |
42361 | 2009-01-27 3:03 | 2009-01-27 9:03 | MySQL Enterprise Monitor: Documentation | Not a Bug (5561 days) | S3 | 2.0 | Any | Any | Inappropriate example for creating a user for an agent. |
7351 | 2004-12-16 13:15 | 2012-05-18 20:19 | MySQL Server | Duplicate (5934 days) | S2 | 5.1 | Any | Any | incomplete result, outer query with NULL <> ALL (empty subquery) |
78527 | 2015-09-23 7:54 | 2016-06-18 21:28 | MySQL Server: Documentation | Closed (3111 days) | S3 | 5.7.10, 8.0.0 | Any | Any | incomplete support and/or documentation of the JSON datatype |
59338 | 2011-01-06 19:05 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (4818 days) | S3 | 5.1.50 | Any | Any | Inconsistency in binlog for statements that don't change any rows STATEMENT SBR |
91026 | 2018-05-25 12:04 | 2018-06-18 12:06 | MySQL Server: DML | Not a Bug (2132 days) | S3 | 5.7 | Any | Any | Inconsistent behavior insert overflow decimal error-code and warn-code |
64888 | 2012-04-06 14:43 | 2012-04-09 11:03 | MySQL Server: MyISAM storage engine | Verified (4396 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | Inconsistent behavior of dynamic concurrent_insert values |
32839 | 2007-11-29 8:07 | 2007-12-04 14:47 | MySQL Server | Can't repeat (5981 days) | S3 | 5.1 BK | Any (Linux) | Any | Inconsistent behavior of LOW_PRIORITY in 5.0 and 5.1 |
46037 | 2009-07-08 11:11 | 2018-11-04 20:45 | MySQL Server: Data Types | Verified (5399 days) | S3 | mysql-azalea/5.1 | Any | Any | Inconsistent behavior when casting floating point numbers to integer |
80682 | 2016-03-10 8:44 | 2016-03-10 11:50 | MySQL Server: DML | Verified (2962 days) | S3 | 5.7.8, 5.7.11 | Any | Any | Inconsistent behavior with GROUP BY alias, w/ different sequence in select list |
78203 | 2015-08-25 9:16 | 2015-08-26 15:33 | MySQL Server: DML | Not a Bug (3159 days) | S3 | 5.6.22 | Any | Any | Inconsistent behaviors when auto_increment_offset is ignored(>auto..._increment) |
78009 | 2015-08-10 11:25 | 2015-08-10 14:47 | MySQL Server: DML | Not a Bug (3175 days) | S3 | 5.6.22 | Any | Any | Inconsistent behaviors when column alias name(s) and column name are the same |
110347 | 2023-03-12 12:18 | 2023-03-16 1:15 | MySQL Server: InnoDB storage engine | Not a Bug (400 days) | S3 | 8.0.32 | Any | Any | Inconsistent blocking of UPDATE and DELETE with the same WHERE clause |
59240 | 2010-12-31 0:50 | 2011-02-16 23:44 | MySQL Server: Replication | Won't fix (4830 days) | S3 | 5.6 | Any | Any | Inconsistent case of identifiers in binlog when lower_case_table_name=1 |
113098 | 2023-11-16 2:55 | 2023-11-24 7:00 | Connector / J | Duplicate (154 days) | S3 | 8.1.0 | Any | Any | Inconsistent Execution of Batch Queries with rewriteBatchedStatements=true |
58131 | 2010-11-11 3:06 | 2010-11-17 0:46 | MySQL Server: Parser | Not a Bug (4902 days) | S3 | 5.1.51 | Any | Any | Inconsistent handling of out of range values |
46337 | 2009-07-22 10:39 | 2019-04-12 18:27 | MySQL Server: General | Closed (1834 days) | S3 | 5.1.35 | Any | Any | Inconsistent MySQL behavior when creating a table with self-ref. FKs |
72912 | 2014-06-08 13:31 | 2014-06-08 19:38 | MySQL Server: Information schema | Verified (3603 days) | S3 | 5.6.19 | Any | Any | Inconsistent naming of tables in different I_S.innodb% tables |
44951 | 2009-05-19 12:18 | 2012-05-18 20:19 | MySQL Server: Charsets | Duplicate (5404 days) | S3 | 6.0 bzr | Any | Any | Inconsistent result for "cast ... as char binary" (failure in main.cast) |
114534 | 2024-04-03 4:22 | 2024-04-03 8:22 | MySQL Server: DML | Verified (16 days) | S3 | 8.0.36 | Any | Any | Inconsistent result with index and symbol '̏ |
68759 | 2013-03-24 12:49 | 2013-03-25 5:31 | MySQL Server: Data Types | Verified (4043 days) | S3 | 5.6.10 | Any | Any | Inconsistent results on comparison a time field with a non-time literal |
79804 | 2015-12-29 12:36 | 2015-12-30 16:54 | MySQL Server: DML | Not a Bug (3033 days) | S3 | 5.7.8 | Any | Any | Inconsistent results when inserting 0.1 into datetime(6) and timestamp(6) |
112816 | 2023-10-24 16:15 | 2023-12-13 12:00 | MySQL Server: Optimizer | Verified (168 days) | S2 | 8.0, 8.1 | Any | Any | Inconsistent results when JOINed in different order |
112985 | 2023-11-07 8:33 | 2023-11-08 10:54 | MySQL Server: Optimizer | Verified (164 days) | S3 | 8.0, 8.1, 8.2 | Any | Any | Inconsistent results when switching hash join optimization |
112768 | 2023-10-19 7:15 | 2023-10-19 10:12 | MySQL Server: Optimizer | Not a Bug (183 days) | S3 | 8.1.0, 8.0.34 | Any | Any | Inconsistent results when tables are JOINed in a different order |
113059 | 2023-11-13 8:29 | 2023-11-13 9:51 | MySQL Server: Optimizer | Verified (158 days) | S2 | 8.2.0 | Any | Any | Inconsistent results when using DUPSWEEDOUT |
112802 | 2023-10-23 8:23 | 2023-10-27 9:46 | MySQL Server: Optimizer | Verified (179 days) | S3 | 8.1.0, 8.0.34 | Any | Any | Inconsistent results when using INDEX |
112911 | 2023-11-01 8:21 | 2023-11-01 8:56 | MySQL Server: Optimizer | Verified (170 days) | S2 | 8.1.0, 8.0.35 | Any | Any | Inconsistent results when using PRIMARY and DUPSWEEDOUT |
66034 | 2012-07-26 19:01 | 2012-08-01 7:08 | MySQL Server: Data Types | Verified (4284 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | Inconsistent results while comparing time fields with string and number literals |
30788 | 2007-09-04 10:33 | 2008-01-23 18:25 | MySQL Server | Closed (5931 days) | S1 | 5.0.45, 4.1, 5.1 BK | Any | Any | Inconsistent retrieval of char/varchar |
46911 | 2009-08-25 6:56 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (5337 days) | S2 | 5.1.37 | Any | Any | Inconsistent SHOW CREATE TABLE result before/after FLUSH STATUS w/ partitioning |
31540 | 2007-10-11 16:01 | 2008-01-09 14:12 | MySQL Server: InnoDB storage engine | Closed (5945 days) | S1 | 5.1.22 | Any | Any | incorrect auto_increment values used for multi-row insert trigger |
110429 | 2023-03-20 5:56 | 2023-03-20 9:55 | MySQL Server: InnoDB storage engine | Verified (396 days) | S3 | 8.0.31, 8.0.32 | Any | Any | Incorrect autoinc in imported tablespace after restart server |
61408 | 2011-06-04 18:37 | 2011-06-05 17:06 | MySQL Server: Data Types | Not a Bug (4702 days) | S3 | 5.0.90 | Any | Any | incorrect behaviour of user-defined variables |
77095 | 2015-05-19 13:59 | 2017-04-04 10:27 | MySQL Server: DDL | Closed (2572 days) | S3 | 5.7/5.6 | Any | Any | Incorrect binlog order for concurrent CREATE TRIGGER and DROP TRIGGER |
72335 | 2014-04-14 6:16 | 2014-04-21 8:47 | MySQL Server: Stored Routines | Not a Bug (3651 days) | S2 | Any | Any | INCORRECT BIT COLUMN VALUE RETURNED IN THE STORED PROCEDURE OUT PARAM | |
104431 | 2021-07-27 22:13 | 2021-07-29 13:49 | MySQL Server: Locking | Not a Bug (995 days) | S3 | 8.0.26 | Any | Any | Incorrect data locks listed for INSERT |
68577 | 2013-03-05 19:29 | 2019-12-12 16:14 | MySQL Server: Data Types | Verified (4063 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | Incorrect enum values returned when using UNION after CREATE AS SELECT |
47315 | 2009-09-15 4:28 | 2011-03-15 16:39 | MySQL Server: Errors | Not a Bug (4784 days) | S2 | 5.1.37, 5.1.40sp1 | Any | Any | Incorrect ERROR 1235 when trying to create a trigger with a name that exists |
45832 | 2009-06-29 16:53 | 2015-08-19 13:56 | MySQL Server: Views | Closed (3166 days) | S3 | 5.1+ | Any | Any | Incorrect error message when creating unsafe view |
71923 | 2014-03-04 12:23 | 2014-07-17 17:29 | Connector / J | Closed (3564 days) | S3 | 5.1.29 | Any | Any | Incorrect generated keys if ON DUPLICATE KEY UPDATE not exact |
45154 | 2009-05-28 12:09 | 2011-02-16 23:44 | MySQL Cluster: Disk Data | Closed (5439 days) | S3 | * | Any | Any | Incorrect handling of create/drop with different #partitions in DD-tables |
49459 | 2009-12-04 14:05 | 2011-02-16 23:44 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5237 days) | S3 | mysql-5.1-telco-6.2 | Any | Any | Incorrect handling of too long string in condition pushdown |
112351 | 2023-09-15 2:17 | 2023-09-15 10:34 | Connector / J | Analyzing (217 days) | S2 | 8.0.30 | Any | Any | Incorrect implementation while locally creating Timestamp fields value in JVM |
20236 | 2006-06-02 20:34 | 2006-06-02 20:40 | MySQL Server | Not a Bug (6531 days) | S3 | 4.1.20, 5.0.22 | Any (All) | Any | incorrect INSERT syntax is allowed and produces confusing results |
44976 | 2009-05-20 9:09 | 2011-02-16 23:43 | MySQL Server: Replication | Duplicate (4977 days) | S2 | 5.0.77 | Any | Any | Incorrect INSERT_ID in binary log |
52430 | 2010-03-29 11:01 | 2011-02-16 23:44 | MySQL Server: Data Types | Closed (5035 days) | S3 | 5.5.3-m3 | Any | Any | Incorrect key in the error message for duplicate key error involving BINARY type |
28843 | 2007-06-01 18:07 | 2016-02-25 12:24 | MySQL Server: Documentation | Not a Bug (6139 days) | S3 | 5.0.41 | Any | Any | Incorrect listing of supported operations in Prepared Statements |
34289 | 2008-02-04 16:58 | 2008-03-29 17:10 | MySQL Server: Replication | Closed (5865 days) | S2 | 5.0.45, 5.0, 5.1, 6.0 BK | Any (Linux) | Any | Incorrect NAME_CONST substitution in stored procedures breaks replication |
31590 | 2007-10-14 20:49 | 2008-03-30 20:29 | MySQL Server: General | Closed (5864 days) | S2 | 5.1.24BK, 5.0.56BK | Any | Any | incorrect out of memory error and sort aborted messages in logs |
114378 | 2024-03-17 12:44 | 2024-03-18 7:50 | MySQL Server: DML | Verified (32 days) | S3 | 8.0, 8.0.35 | Any | Any | Incorrect query result caused by CONVERT_TZ |
113595 | 2024-01-09 14:38 | 2024-01-09 15:15 | MySQL Server | Duplicate (101 days) | S3 | 8.0.35 | Any | Any | Incorrect query result of function TIMESTAMPADD |
79937 | 2016-01-12 15:42 | 2016-01-13 12:15 | MySQL Server: DML | Not a Bug (3019 days) | S3 | 5.6.27 | Any | Any | Incorrect record updated using ON DUPLICATE KEY UPDATE processing |
112354 | 2023-09-15 7:52 | 2023-10-20 1:00 | MySQL Server: Optimizer | No Feedback (183 days) | S3 | 8.0.28 | Any | Any | Incorrect result |
113462 | 2023-12-19 16:05 | 2023-12-20 15:06 | MySQL Server: Optimizer | Verified (121 days) | S3 | 8.0 | Any | Any | Incorrect result |
47762 | 2009-10-01 14:29 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5052 days) | S3 | 5.0.87, 5.1, 6.0,5.4 | Any | Any | Incorrect result from MIN() when WHERE tests NOT NULL column for NULL |
112451 | 2023-09-25 6:35 | 2023-09-25 7:37 | MySQL Server: Optimizer | Verified (207 days) | S3 | 8.0,8.1 | Any | Any | Incorrect result if there are non-deterministic expressions in in-subquery |
107629 | 2022-06-22 8:41 | 2022-06-22 10:06 | MySQL Server: Optimizer | Verified (667 days) | S3 | 8.0.29 | Any | Any | Incorrect result when using index and materialization-lookup |
105692 | 2021-11-24 10:20 | 2022-01-06 14:13 | MySQL Server: Optimizer | Closed (877 days) | S3 | 8.0.29 | Any | Any | Incorrect result with aggregation by temporary table |
111699 | 2023-07-09 3:46 | 2023-07-10 5:51 | MySQL Server: Optimizer | Verified (284 days) | S3 | 8.0.28, 8.0.33 | Any | Any | Incorrect results |
63502 | 2011-11-30 10:23 | 2012-01-27 19:06 | MySQL Server: Data Types | Closed (4466 days) | S3 | 5.1.58 | Any | Any | Incorrect results of BIGINT and DECIMAL comparison |
74521 | 2014-10-23 8:35 | 2015-04-06 18:38 | MySQL Cluster: Disk Data | Closed (3419 days) | S3 | 7.1.33 | Any | Any | Incorrect schemaTrans outcome reported during DICT master takeover. |
80394 | 2016-02-16 12:37 | 2016-03-07 9:33 | MySQL Server: Replication | Not a Bug (2965 days) | S2 | 5.7.11 | Any | Any | incorrect semi-sync replication status handling |
24860 | 2006-12-06 18:17 | 2007-11-28 19:03 | MySQL Server: Replication | Closed (5987 days) | S3 | 5.1.12 | Any | Any | Incorrect SLAVE_TRANSACTION_RETRIES code can result in slave stuck |
81235 | 2016-04-29 11:43 | 2016-05-05 14:05 | MySQL Server: Optimizer | Duplicate (2906 days) | S3 | 5.6 | Any | Any | Incorrect sorting temporary results after Where |
55463 | 2010-07-22 0:25 | 2016-09-07 20:04 | MySQL Server: DML | Not a Bug (5020 days) | S5 | Any | Any | incorrect value returned by last_insert_id() function | |
58134 | 2010-11-11 11:01 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4829 days) | S2 | 5.1.51-ndb-7.1.9 | Any | Any | Incorrectly condition pushdown inside subquery to NDB engine |
59214 | 2010-12-29 15:45 | 2011-05-05 23:48 | MySQL Server: InnoDB Plugin storage engine | Closed (4733 days) | S5 | 5.1,5.5 | Any | Any | increase rate limit for insert buffer prefetch reads |
51122 | 2010-02-11 21:20 | 2018-09-09 20:45 | MySQL Server: Optimizer | Duplicate (5153 days) | S3 | 6.0-codebase-bugfixing | Any | Any | incremental join buffering + dup weedout semijoin + STRAIGHT_JOIN = wrong result |
100806 | 2020-09-11 5:36 | 2020-09-11 7:44 | MySQL Server: Optimizer | Verified (1316 days) | S3 | 8.0.21, 5.7.31 | Any | Any | Index changes behavior of BETWEEN |
9639 | 2005-04-05 10:09 | 2008-10-06 13:15 | MySQL Server: General | Duplicate (5674 days) | S4 | Any (any) | Any | Index on columns with functon aplied. | |
73136 | 2014-06-27 16:34 | 2015-05-20 15:16 | MySQL Server: Optimizer | Verified (3581 days) | S3 | 5.6.12,5.6.19,5.5, 5.5.38, 5.5.20 | Any | Any | Index scan incorrectly selected over ref+sort leading to x1000 worse performance |
29680 | 2007-07-10 6:38 | 2007-08-07 20:00 | MySQL Server: Documentation | Closed (6100 days) | S3 | 5.0.46-BK, 5.0.41 | Any | Any | index_merge is used instead of (faster!) range |
61735 | 2011-07-04 11:30 | 2011-07-08 6:02 | MySQL Server: InnoDB storage engine | Verified (4669 days) | S3 | 5.1, etc | Any | Any | index->lock held while preads are done |
42763 | 2009-02-11 13:58 | 2013-02-06 23:07 | MySQL Workbench | Can't repeat (4090 days) | S2 | 1.1.17 | Any | Any | Indexe won't be migrated |
113447 | 2023-12-18 7:54 | 2023-12-18 13:52 | MySQL Server: DML | Not a Bug (123 days) | S3 | MySQL 8.0 | Any | Any | INET6_ATON giving Incorrect integer value for MySQL 8.0 |
34174 | 2008-01-30 19:43 | 2009-05-15 17:06 | MySQL Server: Falcon storage engine | Closed (5453 days) | S3 | 6.0-falcon-team | Any | Any | Infinite loop checking rolled back record in select for update |
52964 | 2010-04-20 5:58 | 2011-02-16 23:44 | MySQL Server: InnoDB Plugin storage engine | Closed (4848 days) | S1 | 5.1.45 | Any | Any | Infinite loop in btr_page_split_and_insert in ROW_FORMAT=COMPRESSED |
97523 | 2019-11-06 21:02 | 2021-01-27 10:18 | MySQL Server | No Feedback (1595 days) | S3 | 5.7.26 | Any | Any | Infinite loop on query end re TrxInInnoDB::wait() |
42749 | 2009-02-11 6:59 | 2011-02-16 23:43 | MySQL Server: Row Based Replication ( RBR ) | Closed (5412 days) | S1 | 5.1.30, 5.1.32, 6.0.10 | Any (Windows, Linux) | Any | infinite loop writing to row based binlog - processlist shows "freeing items" |
45387 | 2009-06-09 8:04 | 2011-02-16 23:44 | MySQL Server | Won't fix (5341 days) | S3 | 5.1, 6.0 bzr | Any | Any | Information about statement id for prepared statements missed from general log |
71469 | 2014-01-24 10:49 | 2014-02-11 16:02 | MySQL Server: Documentation | Closed (3720 days) | S3 | 5.6 | Any | Any | INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS.MODIFIED_COUNTER resets not documented |
40255 | 2008-10-22 15:10 | 2011-02-16 23:43 | MySQL Server: Information schema | Verified (5657 days) | S3 | Any | Any | INFORMATION_SCHEMA.WARNINGS - a CREATE/INSERT .. SELECT friendly table | |
67345 | 2012-10-24 0:29 | 2013-01-07 5:26 | MySQL Server: Command-line Clients | Not a Bug (4120 days) | S2 | 5.6, 5.7.1 | Any | Any | init-file stops getting executed if a long enough line is encountered |
29891 | 2007-07-19 8:04 | 2007-07-19 16:03 | MySQL Server: InnoDB storage engine | Not a Bug (6119 days) | S3 | 5.0.45, 4.1, 5.0, 5.1 BK | Any (Linux, Windows, Mac) | Any | innodb and lock on delete |
46650 | 2009-08-11 12:51 | 2011-02-16 23:44 | MySQL Server: InnoDB Plugin storage engine | Closed (5052 days) | S1 | 5.1,5.4 | Any | Any | Innodb assertion autoinc_lock == lock in lock_table_remove_low on INSERT SELECT |
76872 | 2015-04-28 14:51 | 2017-11-07 14:52 | MySQL Server: InnoDB storage engine | Closed (2793 days) | S2 | 5.6.24, 5.6.26 | Any | Any | InnoDB AUTO_INCREMENT produces same value twice |
50357 | 2010-01-15 9:15 | 2012-05-18 20:19 | MySQL Server: Backup | Patch queued (5163 days) | S3 | 6.0-backup | Any | Any | Innodb blob+text columns: empty strings become NULL after restore |
52020 | 2010-03-12 21:49 | 2017-12-22 8:24 | MySQL Server: InnoDB storage engine | Closed (4489 days) | S3 | 5.0, 5.1.46 | Any | Any | InnoDB can still deadlock on just INSERT...ON DUPLICATE KEY |
86155 | 2017-05-02 6:56 | 2017-06-30 9:58 | Shell AdminAPI InnoDB Cluster / ReplicaSet | Closed (2485 days) | S2 | 1.0.9 | Any | Any | InnoDB Cluster doen not work with sql_mode="ORACLE,TRADITIONAL" |
29475 | 2007-07-02 4:28 | 2007-08-17 14:06 | MySQL Server: InnoDB storage engine | Won't fix (6090 days) | S5 | 5.0 | Any | Any | InnoDB COMPACT format addition reduces INSERT performance by 10 % |
90993 | 2018-05-23 14:21 | 2018-08-20 12:24 | MySQL Server: InnoDB storage engine | Closed (2069 days) | S2 | 8.0.11 | Any | Any | InnoDB crashes from long lock wait - log writer waiting for checkpointer |
59783 | 2011-01-27 18:39 | 2018-08-15 18:18 | MySQL Server: InnoDB storage engine | Closed (4396 days) | S2 | 5.1.51, 5.1.54, 5.5.8 | Any | Any | InnoDB data grows unexpectedly when inserting, truncating, inserting the same nu |
43725 | 2009-03-18 11:28 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Can't repeat (5475 days) | S3 | 6.0.11/5.0/5.1 | Any | Any | Innodb different on hex() results for bit type |
45309 | 2009-06-03 17:17 | 2017-01-30 19:11 | MySQL Server: General | Closed (5393 days) | S2 | 5.1, 6.0 bzr | Any | Any | InnoDB does not rollback for delete and update queries if query was killed |
86865 | 2017-06-29 8:09 | 2020-10-20 12:18 | MySQL Server: InnoDB storage engine | Closed (1278 days) | S3 | 5.7, 8.0 | Any | Any | InnoDB does unnecessary work when extending a tablespace |
69122 | 2013-05-02 6:06 | 2014-02-02 17:47 | MySQL Server: InnoDB storage engine | Closed (3872 days) | S3 | 5.1,5.6 | Any | Any | InnoDB doesn't redo-log insert buffer merge operation if it is done in-place |
66683 | 2012-09-04 13:57 | 2012-09-04 18:47 | MySQL Server: InnoDB storage engine | Verified (4245 days) | S3 | 5.5.27 | Any | Any | InnoDB doesn't report DB_OUT_OF_FILE_SPACE during recovery |
87940 | 2017-10-02 11:18 | 2017-10-03 18:06 | MySQL Server: InnoDB storage engine | Not a Bug (2390 days) | S3 | 5.5, 5.6, 5.7 | Any | Any | InnoDB fails to discard record lock when discarding an index page |
41477 | 2008-12-15 15:33 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5604 days) | S3 | 4.1, 5.0, 5,1, 6.0 bzr | Any | Any | InnoDB foreign keys: wrong result if ON DELETE CASCADE, and correlated subquery |
33372 | 2007-12-19 16:45 | 2008-01-08 20:24 | MySQL Server: Documentation | Closed (5946 days) | S3 | 5.0.52 | Any | Any | InnoDB free: 0 on a newly created ( and non 0 size) table |
75763 | 2015-02-04 13:29 | 2015-02-05 8:19 | MySQL Server: FULLTEXT search | Verified (3361 days) | S2 | 5.6.21, 5.6.24 | Any | Any | InnoDB FULLTEXT index reduces insert performance by up to 6x on JSON docs |
110592 | 2023-04-03 10:00 | 2023-05-11 12:54 | MySQL Server: FULLTEXT search | Can't repeat (344 days) | S3 | 8.0.30 | Any | Any | InnoDB FULLTEXT search result lost a record when recovery from a crash |
51838 | 2010-03-08 17:29 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Won't fix (5145 days) | S2 | 5.0.84 | Any | Any | Innodb gets X lock for INSERT ON DUPLICATE KEY UPDATE but not INSERT SELECT |
28781 | 2007-05-30 17:24 | 2016-02-25 12:24 | MySQL Server: Documentation | Closed (5054 days) | S2 | 5.0.42 | Any | Any | InnoDB increments auto-increment value incorrectly with ON DUPLICATE KEY UPDATE |
68453 | 2013-02-21 9:51 | 2015-04-30 15:32 | MySQL Server: InnoDB storage engine | Closed (3277 days) | S3 | 5.6.10, 5.6.17 | Any | Any | InnoDB indexes no longer silently truncated to 767 bytes, produce error instead |
112106 | 2023-08-18 5:20 | 2023-08-22 12:50 | MySQL Server: InnoDB storage engine | Not a Bug (242 days) | S4 | 8.0.33 | Any | Any | InnoDB locks supremum when last record of page is updated |
56680 | 2010-09-09 9:25 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Closed (4875 days) | S3 | all | Any | Any | InnoDB may return wrong results from a case-insensitive covering index |
37232 | 2008-06-05 17:38 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5052 days) | S3 | 5.1.24 | Any | Any | Innodb might get too many read locks for DML with repeatable-read |
65225 | 2012-05-07 16:39 | 2014-03-27 14:23 | MySQL Server: InnoDB storage engine | Closed (3721 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | InnoDB miscalculates auto-increment after changing auto_increment_increment |
85119 | 2017-02-22 3:08 | 2022-03-15 15:38 | MySQL Server: InnoDB storage engine | Unsupported (766 days) | S4 | 5.6 5.7 | Any | Any | Innodb needs an instant checksum. |
112252 | 2023-09-04 16:20 | 2023-11-07 11:29 | MySQL Server: InnoDB storage engine | Analyzing (172 days) | S3 | 8.0.33, 8.0.34 | Any | Any | InnoDB page compression impacts checkpointing |
113733 | 2024-01-24 6:36 | 2024-02-01 6:39 | MySQL Server: InnoDB storage engine | Verified (78 days) | S2 | 8.0, 8.0.36 | Any | Any | Innodb page has a large proportion of garbage space in certain conditions |
39435 | 2008-09-14 3:37 | 2022-04-10 20:45 | MySQL Server: InnoDB Plugin storage engine | Duplicate (5695 days) | S2 | 5.1.28 + 1.0.1 plugin | Any | Any | InnoDB plugin auto_inc test fails |
52283 | 2010-03-22 19:10 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5141 days) | S3 | 5.1.46 | Any | Any | Innodb reports extra warnings when SELECT/WHERE is performed using invalid value |
43589 | 2009-03-12 11:53 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Duplicate (5517 days) | S3 | 6.0.11-bzr | Any | Any | Innodb returns zero values for calendar types with IS NULL |
71576 | 2014-02-04 6:14 | 2014-02-04 18:08 | MySQL Server: Optimizer | Duplicate (3727 days) | S3 | 5.5.36 | Any | Any | InnoDB Table Statistics Is Not Updated on Bulk INSERT |
28878 | 2007-06-04 15:35 | 2007-10-22 22:03 | MySQL Server | Closed (6024 days) | S1 | 5.0.42, 4.1.23 | Any | Any | InnoDB tables with UTF8 character set and indexes cause wrong result for DML |
49414 | 2009-12-03 19:34 | 2010-03-02 1:28 | MySQL Server: Backup | Closed (5162 days) | S3 | 6.0-backup, 6.0.14 | Any | Any | Innodb tbl w/blob and text column with NULL no longer NULL after backup/restore |
70629 | 2013-10-16 8:27 | 2017-05-14 20:45 | MySQL Server: InnoDB storage engine | Verified (3794 days) | S2 | 5.6.14 | Any | Any | InnoDB updated rec_per_key[] statis not published to the optimizer enough often |
88827 | 2017-12-08 1:30 | 2018-05-31 13:08 | MySQL Server: InnoDB storage engine | Verified (2209 days) | S3 | 5.6.35, 5.6.38, 5.7.20, 8.0.4 | Any | Any | innodb uses too much space in the PK for concurrent inserts into the same table |
37994 | 2008-07-09 14:46 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | No Feedback (5564 days) | S2 | 5.0.51a-community | Any (seen on windows server 2003 and linux) | Any | InnoDb waits for lock when DELETE from a table previously in a interrupted trans |
67963 | 2012-12-22 6:51 | 2015-11-02 12:52 | MySQL Server: InnoDB storage engine | Closed (3091 days) | S3 | All | Any | Any | InnoDB wastes almost one extent out of every innodb_page_size pages |
7496 | 2004-12-22 21:50 | 2005-01-21 16:34 | MySQL Server: InnoDB storage engine | Closed (7028 days) | S1 | 4.1 | Any (All) | Any | innodb_file_per_table corrupts secondary indexes |
81467 | 2016-05-17 14:33 | 2016-05-18 9:43 | MySQL Server: Tests | Verified (2893 days) | S3 | 5.7, 5.7.12 | Any | Any | innodb_fts.sync_block test unstable due to slow query log nondeterminism |
55818 | 2010-08-07 6:23 | 2013-08-25 20:45 | MySQL Server: InnoDB Plugin storage engine | Verified | S3 | 5.1.49 | Any | Any | innodb_io_capacity can't be set below 100 |
52393 | 2010-03-26 14:05 | 2012-07-19 23:17 | MySQL Server: Documentation | Closed (4292 days) | S3 | 5.1 and later | Any | Any | innodb_io_capacity documentation error |
48482 | 2009-11-02 17:46 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Closed (5152 days) | S1 | Any | Any | innodb-autoinc.test fails with results difference | |
45986 | 2009-07-07 3:16 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Can't repeat (5399 days) | S1 | 5.1.36-community | Any (Windows Server 2008 x64) | Any | InnoDB: Assertion failure in thread 6472 in file .\buf\buf0flu.c line 279 |
40992 | 2008-11-24 19:14 | 2018-09-09 20:45 | MySQL Server: Optimizer | Duplicate (5166 days) | S3 | 6.0 bzr | Any | Any | InnoDB: Crash when index_condition_pushdown is on |
78728 | 2015-10-07 1:10 | 2018-09-25 22:04 | MySQL Server: InnoDB storage engine | Closed (3095 days) | S6 | 5.7.8 (RC2), 5.7.10, 8.0.0 | Any | Any | InnoDB: Failing assertion: 0 in file ha_innopart.cc line 3526 |
80625 | 2016-03-06 9:26 | 2016-03-08 13:10 | MySQL Server: InnoDB storage engine | Verified (2964 days) | S1 | 5.6.29 | Any | Any | InnoDB: Failing assertion: table->data_dir_path while dropping table |
76037 | 2015-02-25 4:52 | 2016-02-02 19:59 | MySQL Server: InnoDB storage engine | Closed (3294 days) | S3 | 5.7 | Any | Any | Innodb: Incorrect duplicate key error for autoinc column for partitioned table |
107919 | 2022-07-20 7:23 | 2022-07-27 12:52 | MySQL Server | Can't repeat (632 days) | S3 | 8.0.29 | Any | Any | InnoDB: insufficient history for index 0 |
76803 | 2015-04-23 8:42 | 2019-01-25 1:21 | MySQL Server: InnoDB storage engine | Closed (1911 days) | S3 | 5.1, 5.5, 5.6, 5.7, 8.0 | Any | Any | InnoDB: Unlock row could not find a 2 mode lock on the record |
73300 | 2014-07-16 18:03 | 2015-04-01 4:41 | MySQL Server: InnoDB storage engine | Closed (3536 days) | S3 | 5.7.5 | Any | Any | innodb.log_file_name fails sproadically on pb2 |
73723 | 2014-08-26 7:58 | 2014-09-19 15:15 | MySQL Server: InnoDB storage engine | Closed (3522 days) | S3 | 5.7 | Any | Any | innodb.log_file_size fails with wrong errno 2006 ob pb2(sporadic) |
25379 | 2007-01-03 6:16 | 2007-02-22 11:19 | Connector / J | Closed (6266 days) | S3 | 3.1.10 | Any (ANY) | Any | INOUT parameters add extra delimiters for the char ' (single quote) |
79690 | 2015-12-17 12:54 | 2015-12-17 19:33 | MySQL Server: DML | Not a Bug (3046 days) | S3 | 5.7.8 | Any | Any | Insert -0.1 and string '-0.1' into unsigned int returns different result |
36559 | 2008-05-07 11:15 | 2010-05-10 18:37 | MySQL Server: Optimizer | Not a Bug (5093 days) | S1 | 5.0.46-5.0.60 | Any | Any | INSERT .. SELECT takes more time to complete on versions 5.0.46 and newer |
95070 | 2019-04-20 14:07 | 2019-05-02 13:09 | MySQL Server | Not a Bug (1814 days) | S3 | 8.0.15 | Any | x86 | INSERT .. VALUES ( .., (SELECT ..), ..) takes shared lock with READ-COMMITTED |
103576 | 2021-05-04 17:56 | 2021-05-05 6:05 | MySQL Server: InnoDB storage engine | Duplicate (1080 days) | S3 | 8.0.20 | Any | Any | insert ... on duplicate key ... disjoint sets of rows deadlock on supremum |
56935 | 2010-09-22 14:50 | 2010-09-23 5:24 | MySQL Server: Parser | Not a Bug (4957 days) | S3 | 5.021 | Any | Any | insert ... on duplicate key update .. update content may not contain ";" |
66301 | 2012-08-10 8:46 | 2013-04-22 20:28 | MySQL Server: InnoDB storage engine | Closed (4015 days) | S2 | 5.1, 5.5 | Any | Any | INSERT ... ON DUPLICATE KEY UPDATE + innodb_autoinc_lock_mode=1 is broken |
36964 | 2008-05-26 13:29 | 2011-02-16 23:43 | MySQL Server | No Feedback (5165 days) | S2 | 5.1.22rc | Any (insert into into transaction don't insert record but don't return error) | Any | INSERT ... ON DUPLICATE KEY UPDATE does nothing but does not return error |
27954 | 2007-04-19 14:23 | 2007-05-10 18:07 | MySQL Server: General | Closed (6189 days) | S1 | 5.0.38 | Any | Any | INSERT ... ON DUPLICATE KEY UPDATE fails with large multi-insert |
36898 | 2008-05-22 22:24 | 2008-05-25 10:04 | MySQL Server: DML | Not a Bug (5808 days) | S3 | 5.0.51 | Any | Any | INSERT ... ON DUPLICATE KEY UPDATE seem to compute wrong, if a new row is insert |
59042 | 2010-12-19 18:44 | 2010-12-19 18:44 | MySQL Server: Security: Privileges | Open | S4 | 5.1.52 | Any | Any | INSERT ... ON DUPLICATE KEY UPDATE shouldn;t need UPDATE access to key columns |
6946 | 2004-12-02 14:31 | 2006-02-14 14:28 | MySQL Server | Won't fix (6639 days) | S4 | * | Any (*) | Any | INSERT ... ON DUPLICATE KEY UPDATE without INSERT |
54312 | 2010-06-07 22:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5064 days) | S3 | 5.1.47, 5.1.48-bzr | Any | Any | insert ... select .. order by rand(): difference depending on indexes. |
6164 | 2004-10-19 20:10 | 2011-02-16 23:43 | MySQL Server: Optimizer | Verified (7121 days) | S4 | 4.0.22 4.1.7 | Any | Any | INSERT ... SELECT ... LIMIT creating too-large temporary tables |
8732 | 2005-02-23 14:49 | 2012-05-18 20:19 | MySQL Server | Duplicate (6832 days) | S3 | 4.1.10 | Any (*) | Any | INSERT ... SELECT ...ON DUPLICATE KEY UPDATE problem |
80293 | 2016-02-05 19:48 | 2016-07-11 12:15 | MySQL Server: DML | Not a Bug (2994 days) | S1 | 5.7.11 | Any | Any | INSERT ... SELECT * FROM does not work for tables with generated columns |
79372 | 2015-11-21 11:40 | 2015-11-21 13:33 | MySQL Server: Partitions | Verified (3072 days) | S2 | 5.5, 5.5.48 | Any | Any | INSERT ... SELECT does not preserve rows order in InnoDB partitioned tables |
39985 | 2008-10-11 19:32 | 2011-02-16 23:43 | MySQL Server: Embedded Library ( libmysqld ) | Verified | S2 | 5.1+ | Any | Any | INSERT ... SELECT on a I_S table leads to a assertion on the embedded server |
51966 | 2010-03-11 19:08 | 2011-02-16 23:44 | MySQL Server: Locking | No Feedback (5119 days) | S3 | 5.1.40-community | Any | Any | INSERT ... SELECT should allow concurrent inserts when binary log is disabled. |
17974 | 2006-03-06 16:16 | 2006-03-21 10:08 | MySQL Server | Won't fix (6604 days) | S3 | 4.1.18 | Any (Any) | Any | INSERT ... SELECT with GROUP BY causes truncation of DECIMAL |
29928 | 2007-07-20 11:01 | 2007-08-03 2:27 | MySQL Server: Backup | Closed (6104 days) | S3 | 4.1 bk, 5.0 bk, 5.1 bk | Any | Any | INSERT ... VALUES(connection_id(), ...) incorrect restores from mysqlbinlog out |
23802 | 2006-10-31 13:00 | 2012-05-18 20:19 | MySQL Server | Duplicate (6365 days) | S2 | 5.0 | Any (all) | Any | INSERT (innodb) SF + concurrent SELECTs may result in wrong data in query cache |
100860 | 2020-09-16 7:00 | 2020-09-16 7:45 | MySQL Server: FULLTEXT search | Verified (1311 days) | S3 | 8.0.21, 5.7.31 | Any | Any | Insert a table with large auto_increment full text index |
79475 | 2015-12-01 9:27 | 2016-02-04 18:23 | MySQL Server: InnoDB storage engine | Closed (3060 days) | S2 | 5.6+ | Any | Any | Insert a token of 84 4-bytes chars into fts index causes server crash |
53836 | 2010-05-20 7:40 | 2011-02-16 23:44 | MySQL Server: Command-line Clients | No Feedback (5052 days) | S3 | 5.1.46 | Any | Any | insert AA select * From BB ,can't run |
96310 | 2019-07-24 9:01 | 2019-07-24 9:45 | MySQL Server: DML | Verified (1731 days) | S3 | 5.7.23, 5.7.27, 8.0.17 | Any | Any | INSERT accepts invalid date from default val while turn on mysql binary log |
60560 | 2011-03-21 3:49 | 2011-03-26 10:13 | MySQL Server: Query Cache | Unsupported (4773 days) | S4 | any | Any | Any | insert and query cache |
511 | 2003-05-26 13:48 | 2003-05-31 16:53 | MySQL Server | Duplicate (7629 days) | S4 | 4.X | Any (ALL) | Any | INSERT as SELECT from the same table must be unlocked |
44140 | 2009-04-08 1:30 | 2014-04-12 18:50 | MySQL Server: InnoDB storage engine | Won't fix (3660 days) | S3 | 5.0 5.1 | Any | Any | Insert buffer operation may destroy the page during its recovery process |
100086 | 2020-07-02 10:34 | 2020-07-06 15:27 | MySQL Server: InnoDB storage engine | Verified (1383 days) | S3 | 5.7 | Any | Any | Insert buffer read ahead causes server stalls |
7578 | 2004-12-29 18:48 | 2004-12-29 22:47 | MySQL Server: InnoDB storage engine | Closed (7051 days) | S1 | 5.0.3-bk | Any (all) | Any | Insert buffering of prefix indexes works incorrectly with new InnoDB format |
55739 | 2010-08-04 10:44 | 2018-06-24 20:45 | MySQL Workbench: SQL Editor | Verified (5007 days) | S4 | Any | Any | Insert column {above|below} for Alter Table | |
79065 | 2015-11-02 8:27 | 2018-10-21 20:45 | MySQL Server | No Feedback (3061 days) | S3 | 5.5 | Any | Any | insert data into DB met error:"Fatal error encountered during command execution" |
45903 | 2009-07-02 10:42 | 2009-07-03 8:59 | MySQL Server: Data Types | Not a Bug (5404 days) | S3 | 5.1 | Any (SQL) | Any | insert date fields should give an error if inserted Data is not formated correct |
26464 | 2007-02-17 18:25 | 2007-03-15 2:54 | MySQL Server: Merge storage engine | Closed (6245 days) | S2 | 4.1.21, 5.0.36BK, 5.1.16BK, 5.2.4BK | Any (*) | Any | insert delayed + update + merge = corruption |
40505 | 2008-11-04 16:09 | 2011-02-16 23:43 | MySQL Server: General | Verified (5628 days) | S4 | Any | Any | INSERT DELAYED and transactions, duplicate keys | |
60114 | 2011-02-11 12:39 | 2012-10-15 14:05 | MySQL Server: Locking | Closed (4204 days) | S3 | mysql-trunk | Any | Any | INSERT DELAYED can call ha_release_auto_increment without having a lock. |
2491 | 2004-01-23 5:54 | 2004-03-11 10:27 | MySQL Server: Replication | Closed (7344 days) | S2 | 4.0 | Any (all) | Any | INSERT DELAYED causes binary log unusable by mysqlbinlog (replication is ok) |
29335 | 2007-06-25 12:29 | 2007-06-27 10:14 | MySQL Server: MyISAM storage engine | Not a Bug (6141 days) | S3 | 5.0.38 | Any | Any | INSERT DELAYED checks table space incorrectly on MyISAM |
58143 | 2010-11-11 16:10 | 2014-12-30 14:29 | MySQL Server: Locking | No Feedback (4873 days) | S1 | 5.1.54 | Any | Any | insert delayed corrupts the table cache... |
32676 | 2007-11-23 18:20 | 2008-01-11 16:09 | MySQL Server: Locking | Closed (5943 days) | S1 | 5.0.50, 5.1.23, 6.0.3 | Any | Any | insert delayed crash with wrong column and function specified .. |
50393 | 2010-01-17 0:46 | 2011-02-16 23:44 | MySQL Server: Partitions | Verified (5206 days) | S3 | 5.1+ | Any | Any | insert DELAYED disabled for partitioned myisam |
40819 | 2008-11-18 12:22 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5489 days) | S3 | 5.0.67 - likely any | Any | Any | INSERT DELAYED documentation request |
22820 | 2006-09-29 11:49 | 2022-03-06 20:45 | MySQL Server: MyISAM storage engine | No Feedback (5826 days) | S3 | 5.1.12 | Any (*) | Any | INSERT DELAYED does not behave like normal insert |
104 | 2003-02-26 13:33 | 2003-03-06 14:03 | MySQL Server | Closed (7715 days) | S3 | 4.0 | Any (all) | Any | INSERT DELAYED does not care about SQL_LOG_BIN=0 |
29571 | 2007-07-05 12:06 | 2007-08-03 15:39 | MySQL Server: Replication | Closed (6104 days) | S3 | 4.1,5.0 | Any | Any | INSERT DELAYED IGNORE written to binary log on the master but on the slave |
45784 | 2009-06-26 10:19 | 2016-10-16 20:45 | MySQL Server: Replication | Duplicate (5394 days) | S2 | 5.1+ | Any | Any | INSERT DELAYED in SP does not cause RBL if binlog_format=MIXED |
36984 | 2008-05-26 16:31 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5797 days) | S3 | 5.0.56sp1 | Any | Any | INSERT DELAYED is converted to standard INSERT in Stored Procedure. |
20887 | 2006-07-06 11:44 | 2015-03-15 20:45 | MySQL Server: Replication | No Feedback (6389 days) | S3 | 4.1 and up | Any (ALL) | Any | INSERT DELAYED is not logged write-behind to binary log |
45825 | 2009-06-29 14:55 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (4977 days) | S2 | 5.1+ | Any | Any | INSERT DELAYED is not unsafe: logged in statement format |
29238 | 2007-06-20 13:52 | 2007-06-20 16:31 | MySQL Server: General | Not a Bug (6148 days) | S1 | 5.041 | Any | Any | INSERT DELAYED is suspended when table is full, no error reporting. |
65846 | 2012-07-08 18:17 | 2016-09-09 11:23 | MySQL Server: DML | Won't fix (2779 days) | S3 | 5.1.63, 5.5.25, 5.5.26 | Any | Any | INSERT DELAYED on a BLACKHOLE table hangs forever |
28280 | 2007-05-07 13:47 | 2007-05-29 13:29 | MySQL Server: Stored Routines | Duplicate (6170 days) | S1 | 5.0.42BK, 5.1.18BK | Any | Any | insert delayed on a table containing trigger leads to server crash |
91208 | 2018-06-11 10:19 | 2018-06-13 1:03 | MySQL Server: Documentation | Closed (2137 days) | S3 | 8.0 | Any (8.x) | Any | INSERT DELAYED removed, but still referred in docs. |
35386 | 2008-03-18 9:39 | 2014-09-17 4:39 | MySQL Server: DML | Won't fix (3502 days) | S3 | 5.1.22 | Any | Any | Insert delayed statements insert 1 + limit records instead of just limit records |
45942 | 2009-07-03 15:53 | 2012-05-18 20:19 | MySQL Server: InnoDB storage engine | Duplicate (5404 days) | S3 | - | Any | Any | Insert delayed support |
51282 | 2010-02-18 14:02 | 2011-02-16 23:44 | MySQL Server: Row Based Replication ( RBR ) | Can't repeat (4838 days) | S1 | 5.1.34-debug, 5.1.44-debug, 5.1.45-debug, 5.5.1-m2-debug | Any | Any | insert delayed thread asserts when binlog is closed due to reset master! |
49567 | 2009-12-09 16:37 | 2015-01-12 15:27 | MySQL Server: Replication | Won't fix (3385 days) | S2 | 5.1+ | Any | Any | INSERT DELAYED uses global binlog_format, should use session |
20195 | 2006-06-01 11:55 | 2006-06-22 14:31 | MySQL Server | Closed (6511 days) | S2 | 5.0.22 | Any (All) | Any | INSERT DELAYED with auto_increment is assigned wrong values |
42102 | 2009-01-14 9:34 | 2012-05-18 20:19 | MySQL Server: DML | Duplicate (5574 days) | S1 | 4.1, 5.0, 5.1, 6.0 bzr | Any | Any | INSERT fail 'Duplicated entry' after UPDATE set auto_inc field with InnoDB |
60015 | 2011-02-08 18:43 | 2011-06-02 2:05 | Connector / NET | Not a Bug (4705 days) | S1 | 6.3.6 | Any | Any | Insert fails using LINQ to Entity Framework and Concurrency Mode = Fixed |
57355 | 2010-10-10 20:15 | 2018-06-24 20:45 | MySQL Workbench: Administration | Verified (4939 days) | S4 | 5.2.28, 5.2.29 | Any | Any | INSERT FIELD length |
89385 | 2018-01-24 15:14 | 2020-10-06 13:05 | MySQL Server | Not a Bug (1291 days) | S4 | Any | Any | INSERT IGNORE DUPLICATE KEY | |
37183 | 2008-06-04 8:15 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5152 days) | S3 | 4.1.22, 5.0.64, 5.1.26, 6.0.6 | Any | Any | insert ignore into .. select ... hangs after deadlock was encountered |
90448 | 2018-04-16 12:09 | 2018-04-20 5:46 | MySQL Server: Replication | Verified (2191 days) | S3 | 5.7.21 | Any | Any | INSERT IGNORE not ignored on SQL thread |
6196 | 2004-10-21 12:44 | 2014-07-23 1:52 | MySQL Server: MyISAM storage engine | Closed (3558 days) | S4 | 5.1 | Any | Any | INSERT IGNORE should return warnings |
72364 | 2014-04-17 9:46 | 2019-11-18 22:53 | MySQL Server: DML | Closed (1614 days) | S3 | 5.5.37 | Any | Any | insert ignore was not rollbacked after KILL QUERY |
44520 | 2009-04-28 14:29 | 2023-02-12 20:45 | MySQL Server: Row Based Replication ( RBR ) | Verified (5469 days) | S4 | 5.1.33, 5.1, 6.0 bzr | Any | Any | INSERT ignored silently if CREATE and INSERT are bundled in one BINLOG stmt |
95096 | 2019-04-24 1:27 | 2019-04-24 6:03 | MySQL Server: DML | Not a Bug (1822 days) | S3 | Any | Any | INSERT INTO ... ON DUPLICATE KEY UPDATE returns wrong number of rows updated | |
83397 | 2016-10-16 10:58 | 2016-10-17 6:58 | MySQL Server: FULLTEXT search | Verified (2741 days) | S3 | 5.7.15, 5.7.16 | Any | Any | INSERT INTO ... SELECT FROM ... fails if source has > 65535 rows on FTS |
89225 | 2018-01-14 21:09 | 2018-01-15 7:30 | MySQL Server: DML | Not a Bug (2286 days) | S3 | 5.7 | Any | Any | INSERT INTO ... VALUES (DEFAULT) on auto_increment becomes unexpected value 0 |
64817 | 2012-03-30 16:04 | 2012-03-31 7:32 | MySQL Server: DML | Not a Bug (4402 days) | S3 | 5.1 | Any | Any | INSERT INTO ... VALUES(0,... uses auto_increment value instead |
94829 | 2019-03-29 9:14 | 2019-04-02 12:40 | MySQL Server: DML | Not a Bug (1848 days) | S3 | 8.0.13 | Any | Any | INSERT INTO (...) SELECT ... FROM view LIMIT X 'forgets' order defined in VIEW |
29632 | 2007-07-08 22:23 | 2007-07-23 18:05 | MySQL Server: BDB | Won't fix (6115 days) | S2 | 5.0.46BK | Any | Any | insert into + analyze bdb table in >1 threads crashes mysqld |
34366 | 2008-02-07 0:02 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (5912 days) | S3 | 5.1.22 | Any | Any | Insert into a partitioned MyISAM table gives ER_AUTOINC_READ_FAILED error |
29095 | 2007-06-14 3:21 | 2010-05-09 3:28 | MySQL Server: General | Closed (6134 days) | S2 | 5.0.44-BK, 5.0.27 community, 5.0.41 Linux | Any (Windows/Linux same...) | Any | Insert into a select from a join b using(c) order by b.auto_id desc limit 1 fail |
75447 | 2015-01-08 12:59 | 2015-01-08 13:27 | MySQL Server: Optimizer | Verified (3389 days) | S2 | 5.6, 5.6.24, 5.7.6 | Any | Any | INSERT into a view sometimes ignores default values |
36172 | 2008-04-17 8:12 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5054 days) | S1 | 5.1.25+innodb_plugin-1.0.0-5.1 | Any | Any | insert into compressed innodb table crashes |
66565 | 2012-08-28 6:46 | 2012-08-28 9:01 | MySQL Server: Federated storage engine | Not a Bug (4252 days) | S2 | 5.5.28 | Any | Any | Insert into federated table |
12009 | 2005-07-18 14:33 | 2005-07-20 21:07 | MySQL Server | Not a Bug (6848 days) | S3 | 4.1 | Any (*) | Any | Insert into Merge table does not enforce base table defaults |
27234 | 2007-03-17 4:48 | 2022-12-04 20:45 | MySQL Server: Merge storage engine | Verified (6239 days) | S4 | Any | Any | INSERT into Merge Table implicitly locks all underlying tables | |
65305 | 2012-05-13 21:06 | 2012-05-24 3:10 | MySQL Server: DML | Can't repeat (4348 days) | S5 | 5.1.63 | Any | Any | INSERT INTO NULL BUG |
41332 | 2008-12-09 16:01 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Duplicate (5576 days) | S1 | Cluster 6.3.20 | Any | Any | Insert into partitioned "ndbcluster" table causes server crash |
29717 | 2007-07-11 9:58 | 2007-08-03 16:59 | MySQL Server | Closed (6104 days) | S2 | 4.1, 5.0, 5.1 BK | Any (Linux) | Any | INSERT INTO SELECT inserts values even if SELECT statement itself returns empty |
102776 | 2021-03-02 7:10 | 2021-03-04 9:19 | MySQL Server: C API (client library) | Not a Bug (1143 days) | S3 | 8.0.22 | Any | Any | insert into select on tinyint type, no warning, but with wrong result |
100215 | 2020-07-14 13:19 | 2020-08-17 12:06 | MySQL Server | Can't repeat (1341 days) | S5 | 5.7.1.6 | Any | Any | insert into sql timeout spent 10s mysql 5.7 |
40499 | 2008-11-04 13:26 | 2008-11-19 20:10 | MySQL Server: MyISAM storage engine | Not a Bug (5630 days) | S1 | 5.1 | Any | Any | INSERT INTO t SELECT * FROM t does not work with myisam if binlogging is on |
101862 | 2020-12-04 1:31 | 2020-12-10 13:32 | MySQL Server: DML | Verified (1232 days) | S3 | 8.0 | Any | Any | insert into t1 values (),(); failed when binlog_row_image=minimal |
79204 | 2015-11-10 12:38 | 2016-02-04 19:57 | MySQL Server: Optimizer | Closed (3062 days) | S3 | 5.7.10 | Any | Any | INSERT INTO table from SELECT accepts to insert into generated columns |
39671 | 2008-09-26 14:24 | 2012-05-18 20:19 | MySQL Cluster: Cluster (NDB) storage engine | No Feedback (5626 days) | S3 | 6.3.17 | Any | Any | INSERT INTO table gives PK violation but should not. |
3275 | 2004-03-23 14:14 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5553 days) | S4 | Any | Any | INSERT INTO table1 AS alias1 - to easier use of LOCK TABLES table1 AS alias1 | |
8675 | 2005-02-22 10:59 | 2005-02-22 20:02 | MySQL Server | Duplicate (6996 days) | S3 | 4.1.10 | Any (*) | Any | INSERT INTO tbl (col,...) SELECT (...) ON DUPLICATE KEY doesn't work properly |
41348 | 2008-12-10 2:38 | 2011-02-16 23:43 | MySQL Server: Locking | Closed (5559 days) | S2 | 5.1.30 | Any | Any | INSERT INTO tbl SELECT * FROM temp_tbl overwrites locking type of temp table |
67863 | 2012-12-10 16:24 | 2020-10-07 13:48 | MySQL Server: DML | Closed (1290 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | INSERT INTO view_name () VALUES () fails with ER_WRONG_VALUE_COUNT_ON_ROW |
9676 | 2005-04-06 11:57 | 2006-07-06 19:02 | MySQL Server: Optimizer | Closed (6497 days) | S3 | 4.1 | Any (any) | Any | INSERT INTO x SELECT .. FROM x LIMIT 1; slows down with big tables |
92570 | 2018-09-26 7:13 | 2018-10-10 8:19 | MySQL Workbench | Verified (2018 days) | S3 | 8.0.12 | Any | Any | INSERT is not highlighted as keyword when connected against mysql server 5.7 |
83781 | 2016-11-11 2:42 | 2018-07-31 14:51 | MySQL Server: Documentation | Closed (2089 days) | S3 | 5.7 | Any | Any | Insert manual page does not adequately show how to handle auto_increment columns |
78239 | 2015-08-27 8:08 | 2018-02-06 18:18 | MySQL Workbench | Verified (2264 days) | S4 | 6.3 | Any | Any | Insert new column at cursor |
101727 | 2020-11-24 4:07 | 2020-11-24 6:44 | MySQL Server: DML | Duplicate (1242 days) | S3 | 8.0.20, 5.7.32, 8.0.22 | Any | Any | insert null into a not null column in the empty SQL mode is not consistent |
105517 | 2021-11-10 13:36 | 2021-11-10 14:36 | MySQL Server: Data Types | Verified (891 days) | S2 | 8.0 | Any (20.0.4.1) | Any | INSERT of CURRENT_TIMESTAMP() vs. DEFAULT differs for TIMESTAMP field |
109141 | 2022-11-18 18:41 | 2023-04-17 8:29 | Connector / NET | Can't repeat (368 days) | S2 | Any | Any | Insert of data into a table results in System.ArgumentException | |
80939 | 2016-04-03 11:58 | 2017-11-13 12:34 | MySQL Server: InnoDB storage engine | Closed (2705 days) | S2 | 5.7.13 | Any | Any | Insert of GIS data into rtree hits assert in rtr_cur_restore_position_func() |
33479 | 2007-12-22 12:51 | 2008-05-24 17:05 | MySQL Server: Partitions | Closed (5809 days) | S3 | 5.1+ | Any | Any | Insert on a partitioned auto_increment table gives ER_AUTOINC_READ_FAILED |
7806 | 2005-01-11 15:45 | 2005-04-27 1:43 | MySQL Server | Closed (6932 days) | S3 | 4.1.11 | Any (*) | Any | insert on duplicate key and auto-update of timestamp |
111703 | 2023-07-10 6:40 | 2023-07-15 1:58 | MySQL Server: Documentation | Not a Bug (279 days) | S3 | 8.0.33, 5.7.42 | Any | Any | INSERT ON DUPLICATE KEY locks INSERT if table have many PRIMARY and UNIQUE key |
70583 | 2013-10-10 8:14 | 2014-08-06 17:08 | MySQL Server: Replication | Closed (3579 days) | S2 | 5.6.14 | Any | Any | INSERT ON DUPLICATE KEY UPDATE failing after MySQL 5.6 upgrade. |
50413 | 2010-01-18 13:54 | 2018-11-30 13:16 | MySQL Server: InnoDB storage engine | Closed (3811 days) | S1 | 5.0.91,5.1.50,5.6.0 | Any | Any | insert on duplicate key update sometimes writes binlog position incorrectly |
81578 | 2016-05-24 18:38 | 2016-05-24 18:51 | MySQL Server: DML | Duplicate (2887 days) | S3 | 5.5.49 | Any | Any | INSERT ON DUPLICATE KEY UPDATE statement returning 1062 instead of 1452 |
1873 | 2003-11-18 7:58 | 2008-02-14 10:46 | MySQL Server | Won't fix (5909 days) | S4 | 6.0 | Any | Any | Insert on duplicate key update strict mode |
68446 | 2013-02-20 23:36 | 2013-02-22 14:56 | MySQL Server: DML | Closed (4074 days) | S3 | 5.5.29 | Any | Any | insert on duplicate key update with null autoincremented PK uses wrong pk value |
112838 | 2023-10-26 2:51 | 2023-10-26 9:46 | MySQL Server | Not a Bug (176 days) | S4 | 8.0 | Any | Any | INSERT ON DUPLICATE locks the first unequal record in unique secondary index |
39352 | 2008-09-09 22:07 | 2011-05-12 6:42 | Connector / J | Closed (5670 days) | S3 | 5.0.x, 5.1.x | Any | Any | INSERT ON DUPLICATE returns 1 instead of 0 when nothing is changed |
45864 | 2009-06-30 20:20 | 2011-02-16 23:44 | MySQL Server | Duplicate (5406 days) | S2 | 5.1.35, 5.1 bzr | Any | Any | insert on one connection, immediate query on another produces no result |
42491 | 2009-01-30 19:44 | 2011-02-16 23:43 | MySQL Server: Storage Engines | Duplicate (5558 days) | S2 | 5.1.30 | Any | Any | INSERT on temporary table may pass incorrect lock type to storage engine |
81563 | 2016-05-24 8:18 | 2016-05-26 13:13 | MySQL Server | Not a Bug (2885 days) | S3 | 5.6.21,5.6.16 | Any | Any | Insert operation will add S-lock on one record after deleted one. |
71159 | 2013-12-17 10:00 | 2013-12-17 17:06 | MySQL Server | Not a Bug (3776 days) | S3 | 5.6.15 | Any | Any | INSERT OR UPDATE updates last row when max autoinc value is reached |
45077 | 2009-05-25 19:08 | 2011-02-16 23:44 | Connector / NET | Closed (5366 days) | S1 | 6.0.3 | Any | Any | Insert problem with Connector/NET 6.0.3 and entity framework |
28150 | 2007-04-28 21:14 | 2007-04-30 16:42 | MySQL Server | Closed (6199 days) | S3 | 5.1.15-beta | Any | Any | INSERT SELECT accepts invalid SELECT statement |
38046 | 2008-07-11 14:22 | 2012-08-03 15:34 | MySQL Server: Locking | Closed (4277 days) | S3 | 5.0, 5.1, 6.0 bzr | Any | Any | INSERT SELECT ON DUPLICATE KEY UPDATE, LOAD DATA REPLACE wrong lock |
9922 | 2005-04-15 5:10 | 2005-04-16 16:56 | MySQL Server | Closed (6943 days) | S2 | 4.0.24 | Any (Any) | Any | INSERT SELECT with UNIONs allows illegal concurrent INSERTs |
65581 | 2012-06-11 10:07 | 2012-06-18 6:37 | MySQL Server: InnoDB storage engine | Verified (4330 days) | S3 | 5.5 | Any | Any | INSERT statement can be delayed by SELECT ... LOCK. |
21852 | 2006-08-27 14:36 | 2008-06-23 11:54 | MySQL Server | Can't repeat (5779 days) | S3 | 5.0.22 | Any (*) | Any | INSERT statement causing table corruption on v5 but not on v4 |
41378 | 2008-12-10 22:21 | 2011-02-16 23:43 | MySQL Workbench | Closed (5510 days) | S3 | 5.0.28SE | Any | Any | Insert statements don't update when changing table name |
38655 | 2008-08-08 4:47 | 2008-09-08 5:05 | MySQL Workbench | No Feedback (5702 days) | S3 | 5.0.23 | Any | Any | insert statements malformed under certain circumstances |
51157 | 2010-02-13 0:04 | 2016-11-05 10:15 | MySQL Enterprise Monitor: Server | Won't fix (2722 days) | S3 | 2.2.0.1616 | Any | Any | INSERT statements with blob data cause JDBC Exception (quan via proxy) |
82642 | 2016-08-19 3:58 | 2016-08-19 7:59 | MySQL Server: DML | Verified (2800 days) | S3 | 5.6, 5.5.51, 5.6.32 | Any | Any | insert string-format value to datetime and timestamp return different status |
38148 | 2008-07-15 18:42 | 2008-07-15 20:52 | MySQL Server: Replication | Can't repeat (5757 days) | S3 | 5.0.37 | Any | Any | insert user() references uninitialized fields on a slave |
38515 | 2008-08-01 7:05 | 2008-08-01 7:06 | MySQL Workbench | Duplicate (5740 days) | S3 | 5.0.23 | Any | Any | Insert VALUES repeated when importing model from DBDesigner4 |
11745 | 2005-07-05 20:16 | 2005-08-03 20:56 | MySQL Server: Optimizer | Closed (6834 days) | S2 | 4.1.12a | Any (All) | Any | insert where not exists failing |
114524 | 2024-04-01 12:36 | 2024-04-02 9:17 | Connector / J | Verified (17 days) | S3 | 8.3.0 | Any | Any | INSERT with JSON column error |
59698 | 2011-01-24 15:36 | 2011-02-16 23:44 | MySQL Server: DML | Closed (4834 days) | S2 | 5.5.8 | Any | Any | Insert with NULL value for recursive constraint fails |
58379 | 2010-11-22 12:37 | 2014-07-23 20:46 | MySQL Workbench: Modeling | Closed (3558 days) | S4 | 5.2.31 | Any | Any | Insert with Recursave dependency in Foreign Keys throws error |
28412 | 2007-05-14 11:35 | 2011-02-16 23:43 | MySQL Server: General | Verified (6185 days) | S4 | 5.0.41 | Any | Any | insert_id in OK Packet not working with multiple rows INSERT |
50392 | 2010-01-17 0:28 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5051 days) | S3 | 5.1+ | Any | Any | insert_id is not reset for partitioned tables auto_increment on duplicate entry |
35178 | 2008-03-10 9:12 | 2008-04-05 7:01 | MySQL Server: Replication | Closed (5858 days) | S1 | 5.0.51a | Any | Any | INSERT_ID not written to binary log for inserts against BLACKHOLE backed tables |
8092 | 2005-01-22 18:38 | 2013-07-03 5:38 | MySQL Server: Merge storage engine | Open | S4 | Any | Any | INSERT_METHOD feature request | |
71060 | 2013-12-03 14:08 | 2013-12-05 13:31 | MySQL Server: Locking | Verified (3790 days) | S2 | 5.6.15, 5.6.16, 5.5.35, 5.1.74 | Any | Any | INSERT-SELECT statement takes shared locks in trigger and causes deadlock |
11442 | 2005-06-20 2:25 | 2011-02-16 23:43 | MySQL Server: DML | Verified (6323 days) | S4 | 5.0 | Any (All) | Any | INSERT... ON DUPLICATE KEY UPDATE; w/ values taken from the INSERT part |
33717 | 2008-01-07 2:52 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5054 days) | S3 | 5.0+ | Any | Any | INSERT...(default) fails for enum. Crashes CSV tables, loads spaces for MyISAM |
72748 | 2014-05-26 8:56 | 2018-10-11 17:07 | MySQL Server: Locking | Can't repeat (2017 days) | S2 | 5.6.17, 5.6.19, 5.6.21 | Any | Any | INSERT...SELECT fails to block concurrent inserts, results in additional records |
55211 | 2010-07-13 13:50 | 2017-05-21 20:45 | MySQL Server: Replication | Verified (5029 days) | S2 | 5.1+ | Any | Any | INSERT...SELECT...LIMIT...UNION should be marked unsafe |
40879 | 2008-11-20 11:08 | 2011-02-16 23:43 | MySQL Server: DML | Duplicate (5589 days) | S1 | 5.0.68 | Any | Any | insert..select crashed in field_conv |
84365 | 2016-12-29 2:44 | 2021-12-18 22:54 | Connector / J | Closed (853 days) | S3 | 8.0.26 | Any | Any | INSERT..VALUE with VALUES function lead to a StringIndexOutOfBoundsException |
77183 | 2015-05-28 14:39 | 2020-04-18 0:32 | Connector / J | Closed (1462 days) | S2 | 5.1.35 | Any | Any | INSERT..VALUE..lead to invalidation of batch insert |
62829 | 2011-10-19 18:58 | 2011-10-20 13:13 | MySQL Server: Replication | Verified (4565 days) | S2 | 5.1.57 | Any | Any | INSERT/SELECT between Blackhole tables loses INSERT_ID |
101424 | 2020-11-02 14:51 | 2020-11-10 12:15 | Connector / NET | Duplicate (1256 days) | S2 | 8.0.22 | Any | Any | Insert/Update enum error "Value *column name* is not of the correct type". |
78418 | 2015-09-12 12:34 | 2015-09-13 19:59 | MySQL Server: DML | Not a Bug (3141 days) | S3 | 5.6.22 | Any | Any | Inserted data in "col float" is truncated to 6 digits in "select * from t1" |
26238 | 2007-02-09 21:21 | 2007-03-15 3:20 | MySQL Server: General | Closed (6245 days) | S1 | 5.0.36 | Any (*) | Any | inserted delayed always inserts 0 for BIT columns |
29353 | 2007-06-26 7:11 | 2007-07-10 22:41 | MySQL Server: CSV | Closed (6128 days) | S1 | 5.1 source | Any | Any | inserting a negative value to a csv table leads to the table corruption |
35087 | 2008-03-05 17:54 | 2011-02-16 23:43 | MySQL Server: General | Closed (5456 days) | S2 | 5.0.50+ | Any | Any | Inserting duplicate values at one time with DES_ENCRYPT leads to wrong results |
38080 | 2008-07-12 21:56 | 2008-07-12 22:37 | MySQL Server: Charsets | Not a Bug (5760 days) | S3 | 5.0.62 | Any | Any | Inserting hexadecimal in unicode data is not validated |
41760 | 2008-12-27 2:01 | 2020-05-03 20:45 | MySQL Server: Views | Verified (5295 days) | S3 | 5.0 and up | Any | Any | Inserting into multiple-table views is not working |
98651 | 2020-02-18 23:49 | 2020-02-19 12:05 | MySQL Server: Replication | Verified (1521 days) | S2 | 8.0, 8.0.19 | Any | Any | Inserting into temporary table from function breaks replication in MIXED mode |
80556 | 2016-02-29 12:05 | 2016-06-13 16:39 | MySQL Server: Optimizer | Closed (2867 days) | S2 | 5.7.12 | Any | Any | inserting large json data takes an inordinate amount of time |
5510 | 2004-09-10 4:10 | 2004-09-17 21:24 | MySQL Server | Closed (7154 days) | S2 | 4.1.4 | Any (All) | Any | inserting Null in AutoIncrement primary key Column Fails |
36508 | 2008-05-05 15:15 | 2008-05-06 16:45 | MySQL Server: DML | Not a Bug (5827 days) | S2 | 5.1.24 | Any | Any | inserting null value to not null column with default value explicitly defined |
53629 | 2010-05-13 20:32 | 2010-05-17 7:00 | MySQL Cluster: NDB API | Not a Bug (5087 days) | S1 | NDB 7.1.3 | Any | Any | Inserting records using NDB API adds empty padding to make value take max space |
101877 | 2020-12-05 9:37 | 2020-12-05 10:55 | MySQL Server: DML | Verified (1231 days) | S4 | 5.7.30 | Any | Any | inserting skip check with default value '0000-00-00 00:00:00' in strict sql_mode |
75956 | 2015-02-18 14:28 | 2016-03-30 20:04 | Connector / J | Closed (2942 days) | S1 | 5.1.34 | Any | Any | Inserting timestamps using a PreparedStatement and useLegacyDatetimeCode=false |
50968 | 2010-02-06 23:09 | 2011-02-16 23:44 | Connector / J | Duplicate (5183 days) | S1 | 5.1.10 | Any | Any | Insertion id is Long instead of BigInteger for BIGINT unsigned ID column |
40261 | 2008-10-22 17:55 | 2008-10-31 9:52 | MySQL Server: Security: Privileges | Not a Bug (5649 days) | S2 | 5.0.67, 4.1, 5.0, 5.1, 6.0 bzr | Any | Any | insertion of column privileges fail |
59286 | 2011-01-04 18:05 | 2011-02-27 0:00 | MySQL Workbench: Modeling | No Feedback (4801 days) | S2 | 5.2.31 | Any | Any | INSERTS |
59287 | 2011-01-04 18:05 | 2011-02-16 23:44 | MySQL Workbench | Duplicate (4834 days) | S2 | 5.2.31 | Any | Any | INSERTS |
46390 | 2009-07-26 18:16 | 2011-02-16 23:44 | MySQL Workbench | Closed (5348 days) | S1 | 5.1.16 | Any (ubuntu 9.04, Windows XP) | Any | Inserts doesn't show input field for TEXT datatypes |
27713 | 2007-04-09 11:17 | 2020-05-03 20:45 | MySQL Server: Views | Verified (6219 days) | S3 | 5.0.38, 5.1, 5.2 | Any | Any | INSERTs fail for empty table using WITH_CHECK_OPTION |
51329 | 2010-02-19 15:44 | 2012-05-18 20:19 | MySQL Server | Duplicate (5167 days) | S2 | 5.1.36-enterprise-commercial-classic | Any | Any | Inserts from one connection not immediately visible in second connection |
68083 | 2013-01-14 14:41 | 2013-01-14 18:18 | MySQL Server | Not a Bug (4113 days) | S2 | 5.1.61 | Any | Any | Inserts that cannot progress that wait for a LOCK, innodb implicity kill them |
41984 | 2009-01-08 22:28 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Can't repeat (5499 days) | S3 | 5.1.22rc 5.1.30 GA | Any (Linux, Windows) | Any | inserts with auto-increment fails |
109501 | 2022-12-30 3:16 | 2022-12-30 14:03 | MySQL Server | Not a Bug (476 days) | S3 | all | Any | Any | Insufficient checks for trigger |
109502 | 2022-12-30 3:17 | 2022-12-30 10:06 | MySQL Server | Duplicate (476 days) | S3 | all | Any | Any | Insufficient checks for trigger |
39654 | 2008-09-25 19:00 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5324 days) | S3 | 5.1, 6.0 | Any | Any | Insufficient error message for "The total number of locks exceeds ..." |
88057 | 2017-10-11 12:42 | 2018-06-13 12:32 | MySQL Server: Row Based Replication ( RBR ) | Verified (2382 days) | S3 | 5.7.19, 8.0.3 | Any | Any | Intermediary slave does not log master changes with binlog_rows_query_log_events |
39152 | 2008-09-01 9:12 | 2008-09-21 17:14 | MySQL Server: Backup | Closed (5689 days) | S3 | 6.0 | Any | Any | Intermittent debug_sync time-outs in backup tests |
77947 | 2015-08-05 12:30 | 2016-02-19 16:37 | MySQL Server: Optimizer | Closed (2982 days) | S2 | 5.7.6 | Any | Any | internal_tmp_disk_storage_engine=innodb breaks SQL optimizer compatibility |
83286 | 2016-10-06 12:54 | 2020-01-02 22:57 | MySQL Server: DML | Closed (1569 days) | S3 | 5.7 | Any | Any | Invalid error for Subquery returns more than 1 row |
77116 | 2015-05-21 11:43 | 2015-05-22 5:40 | MySQL Server: Optimizer | Closed (3255 days) | S3 | 5.6.*, 5.6.24 | Any | Any | Invalid query result |
101687 | 2020-11-20 0:16 | 2020-11-20 5:10 | MySQL Server: Optimizer | Verified (1246 days) | S4 | 8.0.22 | Any | Any | Inverse unix_timestamp(TIMESTAMP_col) function needed |
108790 | 2022-10-15 16:46 | 2022-10-17 6:55 | MySQL Server: DML | Verified (550 days) | S2 | 8.0.30 | Any | Any | Invisible column's default values is invalid if not specify other columns |
55617 | 2010-07-28 21:48 | 2011-02-16 23:44 | MySQL Server | Closed (4972 days) | S3 | trunk-wl5370 | Any | Any | Irrelevant error on attempt to override an existing view by CREATE IF NOT EXISTS |
83558 | 2016-10-27 3:16 | 2016-10-27 12:38 | MySQL Server: DML | Not a Bug (2731 days) | S3 | 5.7.16 | Any | Any | Is this a wrong stage? |
113156 | 2023-11-21 2:42 | 2023-11-22 10:51 | MySQL Server | Not a Bug (150 days) | S3 | Any | Any | Is this dead lock can be treated as a bug in design? | |
89007 | 2017-12-21 10:57 | 2020-06-23 13:53 | MySQL Server: Documentation | Closed (1396 days) | S3 | 5.7.18 | Any | Any | Issue with grants and wildcards |
42196 | 2009-01-19 11:34 | 2009-05-15 13:04 | MySQL Server: Falcon storage engine | Closed (5453 days) | S3 | 6.0.10-bzr | Any | Any | Issue with key look up for bit field in Falcon table after insert + stored func |
110245 | 2023-03-01 3:56 | 2023-03-02 9:59 | MySQL Server: Optimizer | Not a Bug (414 days) | S3 | 8.0.32 | Any | Any | Issue with NOT IN |
95095 | 2019-04-24 1:07 | 2019-04-24 5:54 | MySQL Server: Parser | Not a Bug (1822 days) | S3 | Any | Any | Issue with SQL parser | |
18827 | 2006-04-06 5:46 | 2006-04-06 10:48 | MySQL Server | Not a Bug (6588 days) | S2 | 5.0 | Any (all) | Any | It is very slowly when the where statment include function |
72987 | 2014-06-12 15:28 | 2017-05-09 14:45 | MySQL Server: InnoDB storage engine | Verified (2537 days) | S3 | 5.6, 5.7 | Any | Any | it unnecessary to set page max trx_id in update_index_page when index is cluster |
114312 | 2024-03-12 6:30 | 2024-03-19 2:26 | MySQL Server: DML | Verified (31 days) | S3 | 8.0 | Any | Any | Item_ref::used_tables wrong when ref to a rollup constant |
34620 | 2008-02-16 17:16 | 2008-03-15 8:41 | MySQL Server: DML | Closed (5879 days) | S3 | 5.0+, 5.0.58-BK | Any | Any | item_row.cc:50: Item_row::illegal_method_call(const char*): Assertion `0' failed |
50502 | 2010-01-21 10:44 | 2010-01-26 12:36 | Connector / J | Not a Bug (5197 days) | S2 | 5.1.10 | Any | Any | J/Connector doesn't allow to insert NULL as a field value with setNull(int, int) |
20694 | 2006-06-26 13:01 | 2006-07-01 19:14 | Connector / J | Can't repeat (6502 days) | S2 | 3.1.13 | Any (Any) | Any | Java |
113378 | 2023-12-08 12:31 | 2024-03-29 17:12 | Connector / J | Not a Bug (21 days) | S2 | connector-j>=8.0.29 | Any | Any | Java enums in prepared statement for a VARCHAR throws exception |
62006 | 2011-07-27 15:04 | 2022-04-06 22:47 | Connector / J | Closed (744 days) | S2 | 5.1.17 | Any | Any | java.io.NotSerializableException: java.io.StringReader when profileSQL=true |
93839 | 2019-01-07 15:33 | 2019-02-25 23:38 | Connector for Node.js | Closed (1880 days) | S3 | 8.0.13 | Any | Any | JavaScript Date values are converted to empty objects in new documents |
86159 | 2017-05-02 13:08 | 2018-10-21 20:45 | Connector / J | No Feedback (2512 days) | S2 | 5.1.42 | Any | Any | JConnector driver does not free closed objects |
56688 | 2010-09-09 12:04 | 2010-09-09 14:22 | Connector / J | Not a Bug (4971 days) | S2 | 5.1.13 | Any | Any | JDBC - insert error - field doesn't have a default value - NOT NULL field |
31457 | 2007-10-08 15:46 | 2011-02-16 23:43 | Connector / J | Duplicate (5527 days) | S3 | Jdbc-5.0.7 | Any (atleast Windows and Linux) | Any | JDBC SQL Escape processing {fn ... confused by escaped quotes |
100967 | 2020-09-27 6:35 | 2020-11-25 18:02 | MySQL Server: DML | Closed (1241 days) | S3 | 8.0.21 | Any | Any | Join get wrong result for type bit(64) |
102584 | 2021-02-12 15:19 | 2021-02-16 12:46 | MySQL Server: Optimizer | Not a Bug (1159 days) | S3 | 5.7.31 | Any (CentOS Linux release 7.6.1810 (Core)) | Any | join on result of function |
98496 | 2020-02-05 20:21 | 2023-09-11 7:38 | MySQL Server: JSON | Duplicate (221 days) | S3 | 5.7, 8.0 | Any | Any | JSON columns allow empty string, allowing invalid JSON in binlog row images |
80716 | 2016-03-13 9:53 | 2017-09-21 20:40 | MySQL Server: Memcached | Not a Bug (2941 days) | S3 | 5.7.10, 5.7.11 | Any | Any | JSON data not validated if inserted via InnoDB memcache plugin |
100307 | 2020-07-23 14:08 | 2020-07-28 15:46 | MySQL Server: Data Types | Verified (1366 days) | S3 | 5.7.30 | Any | Any | JSON field datatype changes unexpectedly |
101945 | 2020-12-09 22:03 | 2020-12-10 5:02 | MySQL Server: JSON | Verified (1226 days) | S3 | 5.7.31, 8.0.22 | Any | Any | JSON Unsigned Integer out of range for Unsigned Bigint column |
42250 | 2009-01-21 18:38 | 2018-02-10 17:11 | MySQL Server: DML | Can't repeat (2260 days) | S3 | Any | Any | Just a little mistake | |
71257 | 2013-12-30 23:47 | 2014-02-02 1:00 | MySQL Server: DML | No Feedback (3730 days) | S3 | Any | Any | Key Exception upon millionth insert | |
2509 | 2004-01-26 2:37 | 2004-01-29 6:12 | MySQL Server | Closed (7386 days) | S3 | 4.0.17 | Any (any) | Any | Key on a char field in BDB changes case and accents of the original data. |
71985 | 2014-03-09 8:42 | 2017-07-05 15:12 | MySQL Server: Documentation | Won't fix (2480 days) | S3 | 5.6 | Any | Any | keycache concurrent insert docs need to be updated |
76320 | 2015-03-14 5:16 | 2015-08-31 15:45 | MySQL Server: DDL | Closed (3154 days) | S3 | 5.7.6, 5.7.8 | Any | Any | Kill `CREATE TABLE ..SELECT` may lead to replication broken |
29949 | 2007-07-21 18:45 | 2007-08-01 20:26 | MySQL Server: General | Not a Bug (6106 days) | S2 | 5.0.46 | Any | Any | killing a statement can give back wrong error to client |
29431 | 2007-06-28 22:01 | 2007-07-27 5:09 | MySQL Server: Locking | Closed (6111 days) | S3 | 4.1,5.0.46,5.1 | Any | Any | killing an insert delayed thread causes crash |
40827 | 2008-11-18 16:18 | 2011-02-16 23:43 | MySQL Server: MyISAM storage engine | Closed (5455 days) | S2 | 5.0+ | Any | Any | Killing insert-select to MyISAM can cause table corruption |
27563 | 2007-03-31 14:09 | 2007-06-18 17:57 | MySQL Server: Stored Routines | Closed (6150 days) | S3 | 5.0.38 | Any | Any | killing noticed in SF() stack but the error gets missed in action and wrong rslt |
6824 | 2004-11-25 12:27 | 2006-02-12 12:34 | MySQL Server | Won't fix (6641 days) | S4 | next | Any (all) | Any | Lack of column's default value type info confuses clients |
56972 | 2010-09-23 15:22 | 2011-02-16 23:44 | MySQL Workbench: Administration | No Feedback (4899 days) | S3 | 5.2.28 | Any | Any | Large slow_log entries freeze Workbench |
68818 | 2013-03-30 5:29 | 2013-04-01 14:37 | MySQL Server: Optimizer | Duplicate (4036 days) | S3 | 5.6.10 | Any | Any | Large Value List in WHERE Clause Spends Too Much Time in 'statistics' State |
79822 | 2016-01-02 2:26 | 2016-01-02 5:04 | MySQL Server | Not a Bug (3030 days) | S1 | 5.7.10 | Any | Any | Large values in Time column of SHOW PROCESSLIST |
58831 | 2010-12-09 3:30 | 2011-02-16 23:44 | Tests: Server | Closed (4869 days) | S3 | Any | Any | large_tests.alter_table crashes the server | |
80651 | 2016-03-08 3:45 | 2016-04-07 5:46 | MySQL Server: Replication | Duplicate (2934 days) | S3 | 5.5 5.6 | Any | Any | larget rpl_semi_sync_master_timeout will affect performance |
69228 | 2013-05-14 14:56 | 2022-05-23 9:39 | MySQL Server: Data Types | Verified (3993 days) | S2 | 5.6, probably since 4.1 | Any | Any | Last insert ID incorrectly delivered to the client |
2955 | 2004-02-25 4:27 | 2011-02-16 23:42 | MySQL Server: DML | Closed (5553 days) | S4 | 4.x | Any (All) | Any | LAST INSERTED ID FOR UNIQUE KEY |
45405 | 2009-06-09 15:26 | 2011-02-16 23:44 | MySQL Server: Documentation | Closed (5035 days) | S2 | 5.0.81, 5.0, 5.1 bzr | Any (MS Windows, Linux) | Any | LAST_INSERT_ID and Stored Functions and Triggers |
35089 | 2008-03-05 19:55 | 2008-03-05 21:48 | MySQL Server | Not a Bug (5889 days) | S3 | 5.1.22-rc-community-log | Any | Any | LAST_INSERT_ID returns 0 on using INSERT... ON DUPLICATE KEY UPDATE ... |
31971 | 2007-10-30 23:08 | 2019-10-29 22:33 | MySQL Server: DML | Can't repeat (1634 days) | S3 | 5.0.51 and 5.0.45 | Any (Debian, FreeBSD) | Any | last_insert_id with on duplicate key still broken |
67535 | 2012-11-09 13:41 | 2014-02-03 0:33 | MySQL Server: DML | Verified (4168 days) | S3 | 5.0.97, 5.1.67, 5.5.29, 5.7.0 | Any (MS Windows, Linux) | Any | LAST_INSERT_ID() and INSERT IGNORE behavior |
34319 | 2008-02-05 18:21 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5674 days) | S4 | 5.1.22-rc, 5.0.45, 4.1.22 | Any | Any | last_insert_id() inaccurate when inserting multiple rows |
16689 | 2006-01-20 22:31 | 2012-05-18 20:19 | MySQL Server | Duplicate (6653 days) | S3 | 4.1.2 and up | Any (all) | Any | LAST_INSERT_ID() not stable within statement |
38034 | 2008-07-11 3:27 | 2011-02-16 23:43 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5331 days) | S2 | mysql-5.1-telco-6.2 | Any (Solaris, Linux) | Any | last_insert_id() value not shown in table with trigger |
33066 | 2007-12-07 16:33 | 2007-12-25 14:06 | MySQL Server: DML | Not a Bug (5960 days) | S3 | 5.1.22-rc | Any | Any | last_insert_id(), wrong values, InnoDB, insert on duplicate key update |
53396 | 2010-05-04 5:24 | 2010-05-04 13:31 | MySQL Server: Charsets | Not a Bug (5099 days) | S3 | Any | Any | latin1_german2_ci not finding 'ü' by looking for 'ue' | |
29128 | 2007-06-15 5:28 | 2012-05-18 20:19 | MySQL Server: Charsets | Duplicate (5530 days) | S3 | 5.0, 5.1, 4.1 | Any | Any | LC_TIME_NAMES=fr_FR, assignment to non-UTF8 target fails with MONTHNAME() |
5 | 2002-10-29 19:48 | 2002-12-02 12:48 | MySQL Server | Closed (7809 days) | S3 | 3.23.53 | Any (all) | Any | left join bug |
113188 | 2023-11-22 17:51 | 2023-12-21 10:18 | MySQL Server: Optimizer | Closed (120 days) | S1 | 8.2.0 | Any | Any | LEFT JOIN returns results that do not exist in table |
6460 | 2004-11-05 12:09 | 2004-11-09 3:04 | MySQL Server | Closed (7101 days) | S2 | 4.1.7 | Any (all) | Any | LEFT JOIN with multiple LIKE in WHERE produces wrong result |
96930 | 2019-09-18 13:55 | 2019-09-25 11:51 | MySQL Server | Not a Bug (1668 days) | S3 | Any | Any | lf_hash get performance regression when the bucket size is too large | |
26824 | 2007-03-03 14:21 | 2018-09-09 20:45 | MySQL Server: Prepared statements | Verified (3745 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 |
3774 | 2004-05-15 13:16 | 2004-05-21 13:01 | MySQL Server: Embedded Library ( libmysqld ) | Closed (7273 days) | S1 | 4.1.2 | Any (all) | Any | libmysqld distorts datatime values in PS when inserts into table |
2885 | 2004-02-19 1:46 | 2004-03-16 1:50 | MySQL Server | Closed (7339 days) | S1 | 4.1.1 & 5.0.0 | Any (All) | Any | like datetime |
83999 | 2016-11-29 8:08 | 2017-01-27 16:35 | MySQL Server: Charsets | Closed (2685 days) | S3 | 8.0.1 | Any | Any | LIKE function gives wrong result for accented characters |
93214 | 2018-11-15 19:15 | 2019-04-17 23:18 | MySQL Server: DML | Closed (1829 days) | S1 | 8.0 | Any | Any | LIMIT is applied before HAVING when you have a subquery |
68192 | 2013-01-27 20:52 | 2013-01-28 15:40 | MySQL Server: Data Types | Verified (4099 days) | S3 | 5.1, 5.5, 5.6.9 | Any | Any | Limitation on DOUBLE or REAL length is ignored with INSERT .. SELECT |
38859 | 2008-08-18 14:17 | 2022-12-04 20:45 | MySQL Server: Parser | Verified (5722 days) | S4 | 6.0 | Any | Any | limiting a group - LIMITGROUP |
52815 | 2010-04-14 10:29 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4883 days) | S3 | 5.5+ | Any | Any | LIST COLUMNS doesn't insert rows in correct partition if muliple columns used |
76742 | 2015-04-17 16:00 | 2016-02-08 12:28 | MySQL Cluster: Cluster (NDB) storage engine | Closed (3018 days) | S2 | 7.4.7 | Any | Any | Livelock during heavy insert traffic of LCP scan |
82 | 2003-02-18 14:07 | 2003-03-03 5:52 | MySQL Server: Replication | Closed (7718 days) | S2 | 4.0 | Any (all) | Any | LOAD DATA *LOCAL* INFILE is not properly written to the binary log |
75068 | 2014-12-02 8:40 | 2015-04-06 19:03 | MySQL Server: DML | Closed (3346 days) | S3 | 5.1+ | Any | Any | LOAD DATA INFILE doesn't reset LEX::many_values |
39247 | 2008-09-04 15:05 | 2015-06-02 13:36 | MySQL Server: DML | Verified (5695 days) | S3 | 5.0.67, 5.0, 5.1, 6.0 bzr | Any (MS Windows 5.0.2195, Linux) | Any | LOAD DATA INFILE skips too many rows |
48189 | 2009-10-20 14:41 | 2011-02-16 23:44 | MySQL Server: DML | Verified | S4 | 5.1 | Any | Any | LOAD DATA LOCAL and IGNORE behavior |
31975 | 2007-10-31 7:36 | 2009-09-01 13:19 | MySQL Server: Command-line Clients | Not a Bug (5344 days) | S4 | mysql-connector-java-3.1.8-bin.jar | Any | Any | LOAD DATA LOCAL INFILE - Duplicate entry error should come |
86900 | 2017-07-03 6:51 | 2017-07-04 7:33 | MySQL Server: DML | Not a Bug (2481 days) | S3 | 5.7.13 | Any | Any | load data result mismatch when escaped by character is 't' |
60198 | 2011-02-22 8:28 | 2011-09-10 23:00 | MySQL Server: InnoDB storage engine | No Feedback (4605 days) | S2 | 5.1.55 | Any | Any | load data/Insert blocks delete from another session |
79066 | 2015-11-02 9:09 | 2017-02-07 17:14 | MySQL Server: JSON | Verified (3091 days) | S4 | 5.7.9, 5.7.10 | Any | Any | LOAD_FILE will not load a file into a JSON column unless converted |
90291 | 2018-04-03 15:35 | 2018-05-30 12:45 | MySQL Server: DML | Verified (2207 days) | S4 | 5.7.20, 5.7.21, 5.6.39, 8.0 | Any | Any | load_file() will not raise an error if secure_file_priv option was not set |
84158 | 2016-12-11 12:15 | 2017-09-26 12:28 | MySQL Server: mysqldump Command-line Client | Verified (2685 days) | S3 | 8.0.0, 5.7.16 | Any | Any | Loading table with fulltext from mysqldump fails |
37998 | 2008-07-09 17:38 | 2008-07-09 17:44 | MySQL Server: Locking | Duplicate (5763 days) | S3 | 5.1.25 | Any | Any | Lock doesn't allow to copy data from general_log to another table |
111068 | 2023-05-18 8:38 | 2023-05-18 9:46 | MySQL Server: Locking | Verified (337 days) | S2 | 8.0.25, 8.0.33 | Any | Any | Lock failure |
111656 | 2023-07-04 12:32 | 2023-07-05 12:22 | MySQL Server | Unsupported (290 days) | S2 | 8.0.25 | Any | Any | Lock failure |
84609 | 2017-01-23 12:21 | 2017-06-27 7:43 | MySQL Server: Performance Schema | Verified (2643 days) | S3 | 5.7, 8.0, 5.7.17 | Any | Any | Lock information in TABLE_HANDLES misplaced |
43685 | 2009-03-17 2:41 | 2011-02-16 23:43 | MySQL Server: Locking | Closed (5157 days) | S3 | 5.0.78,5.1.32 | Any | Any | Lock table affects other non-related tables |
108050 | 2022-08-02 12:29 | 2022-08-04 11:39 | MySQL Server: DDL | Analyzing (624 days) | S3 | 5.7.37 | Any | Any | LOCK TABLE and then RENAME TABLE operation would releases all lock |
29929 | 2007-07-20 11:20 | 2007-08-02 3:50 | MySQL Server: Locking | Closed (6105 days) | S1 | 5.0, 5.1, 5.2 | Any | Any | LOCK TABLES does not pre-lock tables used in triggers of the locked tables |
96317 | 2019-07-24 13:52 | 2019-08-02 17:55 | MySQL Server: Locking | Not a Bug (1723 days) | S3 | 5.7.18 | Any | Any | Lock wait time out is not occuring for INSERT query |
40737 | 2008-11-14 12:14 | 2009-08-12 21:43 | MySQL Server: Locking | Not a Bug (5364 days) | S2 | 5.0.67 | Any | Any | Lock wait timeout exceeded during inserting row |
29049 | 2007-06-12 12:30 | 2007-08-11 10:12 | MySQL Server: Tests | Closed (6096 days) | S3 | Any | Any | lock_multi fails in rare case | |
66533 | 2012-08-24 17:17 | 2012-11-09 18:12 | MySQL Server: Documentation | Closed (4179 days) | S3 | 5.5, 5.6 | Any | Any | lock_wait_timeout ignored with system tables and FLUSH TABLES WITH READ LOCK |
86422 | 2017-05-23 9:00 | 2017-10-13 17:00 | MySQL Server: InnoDB storage engine | Closed (2380 days) | S2 | 8.0.2 | Any | Any | lock0lock.cc: ((m_mode - (0xFUL & m_mode)) - (0xF0UL & m_mode) - (256 & m_mode)) |
60460 | 2011-03-14 12:37 | 2011-03-15 8:57 | MySQL Server: Locking | Closed (4784 days) | S3 | 5.1.53 | Any | Any | Locked threads are not killed with 'KILL <process_id>' |
8144 | 2005-01-26 13:49 | 2005-01-28 11:39 | MySQL Server: InnoDB storage engine | Closed (7021 days) | S2 | 5.0.3-bk | Any (all) | Any | Locking problem in TRUNCATE TABLE |
75243 | 2014-12-17 9:12 | 2018-05-02 14:17 | MySQL Server: InnoDB storage engine | Closed (2179 days) | S5 | 5.6.22 | Any | Any | Locking rows from the source table for INSERT.. SELECT seems unnecessary in RBR |
73168 | 2014-07-02 4:14 | 2015-02-25 10:51 | MySQL Server: InnoDB storage engine | Verified (3579 days) | S5 | 5.6/5.7 | Any | Any | locking/unlocking overhead for THD::LOCK_thd_data |
40146 | 2008-10-19 16:51 | 2009-03-24 14:42 | MySQL Server: Row Based Replication ( RBR ) | Not a Bug (5505 days) | S1 | 5.1.29, 5.1, 6.0 bzr | Any | Any | log_slave_updates uses MIXED mode for binlog regardless of binlog_format |
102238 | 2021-01-12 20:35 | 2023-12-21 8:49 | MySQL Server: InnoDB storage engine | Closed (120 days) | S5 | 8.0.22 | Any | Any | log_writer uses too much CPU on small servers |
11338 | 2005-06-15 4:55 | 2005-08-24 17:59 | MySQL Server: Replication | Closed (6813 days) | S2 | 4.1.12, 5.0.9 | Any (any) | Any | logging of prepared statement w/ blob type |
37132 | 2008-06-02 3:48 | 2019-06-19 1:23 | MySQL Server: Logging | Closed (1766 days) | S3 | 5.1.25 | Any | Any | Logging to slow_log table fails with very slow queries |
48472 | 2009-11-02 13:39 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5152 days) | S3 | 5.0.88, 5.1.41 | Any | Any | Loose index scan inappropriately chosen for some WHERE conditions |
22183 | 2006-09-09 10:40 | 2006-12-05 15:56 | MySQL Server: Falcon storage engine | Closed (6345 days) | S2 | 5.2 | Any (all) | Any | Loss of data after INSERT and ALTER with two interleaving transactions |
52312 | 2010-03-23 18:15 | 2011-02-16 23:44 | MySQL Server: Information schema | Closed (4899 days) | S3 | any, 5.1.46-bzr | Any | Any | lost Handler_read_last status variable |
100053 | 2020-07-01 2:47 | 2020-07-09 23:01 | MySQL Server: DML | Closed (1380 days) | S3 | 8.0.19, 5.6.48, 5.7.30, 8.0.20 | Any (Ubuntu 18.04.4 LTS) | Any | Lost ULLONG_MAX value in table with type of bit(64) |
55595 | 2010-07-28 3:30 | 2014-03-14 19:04 | MySQL Server: Storage Engines | Verified (3689 days) | S1 | Any | Any | Lots of data differences between MyISAM and InnoDB where there shouldn't be | |
69585 | 2013-06-26 11:23 | 2014-07-22 18:41 | MySQL Server: MyISAM storage engine | Verified (3559 days) | S1 | 5.5.30 x64, 5.5.39, 5.6.21, 5.7.5 | Any (MS Windows W2K8 64bit, Linux) | Any | low-priority-updates not working on replication slave |
105724 | 2021-11-26 19:15 | 2021-11-28 8:23 | MySQL Cluster: Cluster (NDB) storage engine | Verified (873 days) | S3 | 8.0.27 | Any | Any | LQHKEYREQ races COMMIT signal in COPY_FRAGREQ situations |
39359 | 2008-09-10 7:14 | 2018-09-25 21:49 | Tests: Server | Can't repeat (4679 days) | S7 | 6.0 | Any | Any | main.analyze fails randomly on Pushbuild |
40160 | 2008-10-19 20:29 | 2018-09-25 21:49 | Tests | Closed (5634 days) | S7 | 6.0 | Any | Any | main.backup_progress fails sporadically on pushbuild |
51049 | 2010-02-10 7:23 | 2011-02-16 23:44 | MySQL Server: Tests | Closed (5051 days) | S3 | 5.1-bugteam | Any | Any | main.bug39022 fails in mysql-trunk-merge |
38106 | 2008-07-14 15:21 | 2012-05-18 20:19 | MySQL Server: Tests | Duplicate (5663 days) | S3 | 6.0-BK | Any | Any | main.crash_commit_before crashes the server sporadically |
59204 | 2010-12-29 5:55 | 2023-02-12 20:45 | MySQL Server: Replication | No Feedback (4219 days) | S3 | 5.6 | Any (Windows) | Any | main.create with binlog-checksum enabled fail on Windows (x86_64) |
76367 | 2015-03-18 4:29 | 2015-04-07 22:54 | Tests | Closed (3312 days) | S3 | Any | Any | main.ctype_ucs test fails in WL8403 | |
51907 | 2010-03-10 12:26 | 2021-05-02 20:45 | MySQL Server: Tests | Verified (5127 days) | S3 | 5.5.3 | Any | Any | main.ctype_utf8mb4_ndb fails persistently |
37774 | 2008-07-01 15:42 | 2011-02-16 23:43 | MySQL Server: General | Closed (5408 days) | S3 | 6.0-BK | Any | Any | main.events_bugs fails sporadically |
41017 | 2008-11-25 14:27 | 2018-09-25 21:49 | Tests | Closed (5558 days) | S7 | 6.0-rpl | Any | Any | main.events_restart fails in pushbuild: "Server failed to restart" |
40704 | 2008-11-13 16:32 | 2018-09-25 21:49 | Tests: Server | Closed (5558 days) | S7 | 5.1-rpl, 6.0-rpl | Any | Any | main.events_restart fails sporadically in pushbuild: "server has gone away" |
38762 | 2008-08-13 7:47 | 2008-10-17 18:25 | Tests: Engine | Closed (5663 days) | S3 | 6.0-BK, 5.1, 5.0 | Any | Any | main.federated_bug_25714 fails sporadically |
45890 | 2009-07-01 22:27 | 2009-07-04 12:49 | MySQL Server: Tests | Not a Bug (5403 days) | S3 | 5.1.36 | Any | Any | main.grant failes |
34311 | 2008-02-05 14:57 | 2008-02-11 16:46 | MySQL Server | Closed (5912 days) | S1 | 5.1, 6.0 | Any | Any | main.lock_multi.test fails |
37775 | 2008-07-01 15:46 | 2012-10-15 14:50 | Tests: Server | Unsupported (4204 days) | S3 | 6.0-BK,5.4 | Any | Any | main.locktrans_innodb and rpl.rpl_locktrans_innodb fail randomly |
43387 | 2009-03-04 18:21 | 2011-02-16 23:43 | MySQL Server: Embedded Library ( libmysqld ) | No Feedback (5252 days) | S3 | 5.0.88 | Any | Any | main.lowercase_mixed_tmpdir fails with embedded server |
47648 | 2009-09-25 13:23 | 2011-02-16 23:44 | MySQL Server: Merge storage engine | Closed (5156 days) | S3 | 6.0, mysql-next-4284 | Any | Any | main.merge fails sporadically |
82283 | 2016-07-19 15:13 | 2017-07-14 14:27 | MySQL Server: Replication | Closed (2471 days) | S3 | 5.6,5.7, 5.7.13 | Any | Any | main.mysqlbinlog_debug fails with a LeakSanitizer error |
43079 | 2009-02-21 13:41 | 2011-02-16 23:43 | Tests | Can't repeat (5398 days) | S3 | 5.1, 6.0-rpl | Any | Any | main.mysqldump fails sporadically on pushbuild |
38122 | 2008-07-15 7:41 | 2011-02-16 23:43 | Tools: Pushbuild | Closed (5286 days) | S3 | 1 | Any | Any | main.mysqlslap fails sporadically |
38120 | 2008-07-15 7:28 | 2008-10-09 18:57 | MySQL Server: Partitions | Closed (5671 days) | S3 | 6.0-BK, 5.1 | Any | Any | main.partition fails sporadically |
40862 | 2008-11-19 18:24 | 2013-01-10 11:25 | MySQL Server: Compiling | Can't repeat (4117 days) | S2 | 5.1.29-rc | Any | Any | main.subselect_notembedded test case fails |
38531 | 2008-08-02 14:16 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5364 days) | S4 | 5.0,5.1,4.0,4.1 | Any | Any | make innodb faster for concurrent insert/update workloads |
55180 | 2010-07-12 16:27 | 2011-02-16 23:44 | MySQL Server: Options | Verified | S4 | any | Any | Any | make the Threads_running server status variable more meaningful |
71328 | 2014-01-09 14:27 | 2015-05-26 13:05 | MySQL Server: Documentation | Closed (3251 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | Manual does not describe how to monitor InnoDB change buffer usage |
71638 | 2014-02-09 14:41 | 2016-05-13 19:29 | MySQL Server: Documentation | Closed (2898 days) | S3 | 5.6 | Any | Any | Manual does NOT explain "insert intention" lock mode properly |
79688 | 2015-12-17 10:34 | 2016-02-17 19:14 | MySQL Server: Documentation | Closed (2984 days) | S3 | any | Any | Any | Manual does NOT explain Data_length vs Index_length properly for InnoDB tables |
85749 | 2017-03-31 16:45 | 2018-05-15 18:45 | MySQL Server: Documentation | Closed (2166 days) | S3 | 5.7 | Any | Any | Manual does NOT explain gap locks set by SELECT ... FOR UPDATE |
71332 | 2014-01-09 15:55 | 2015-04-06 17:49 | MySQL Server: Documentation | Closed (3301 days) | S3 | any | Any | Any | Manual does NOT explain how row constructors work in non-equal comparisons |
71956 | 2014-03-06 11:22 | 2014-03-07 17:02 | MySQL Server: Documentation | Closed (3696 days) | S3 | 5.6 | Any | Any | Manual does not explain how to work with P_S.setup_actors table |
79665 | 2015-12-16 10:50 | 2017-05-31 20:02 | MySQL Server: Documentation | Closed (2515 days) | S3 | any | Any | Any | Manual does NOT explain locks set by INSERT ... ON DUPLICATE KEY UPDATE properly |
76563 | 2015-04-01 15:26 | 2017-06-01 14:20 | MySQL Server: Documentation | Closed (2514 days) | S3 | 5.5, 5.6, 5.7 | Any | Any | Manual does NOT explain when exactly AUTO-INC lock is set for "bulk inserts" |
71637 | 2014-02-09 14:23 | 2016-02-23 15:18 | MySQL Server: Documentation | Closed (2978 days) | S1 | 5.6 | Any | Any | Manual mentions IS_GAP and IX_GAP locks, but never explains them |
61317 | 2011-05-27 6:58 | 2011-09-20 23:00 | MySQL Server | No Feedback (4596 days) | S5 | 4.1 | Any | Any | Many locked connections while one connection is "Sending data" |
39210 | 2008-09-03 11:19 | 2009-01-09 14:58 | MySQL Server: Maria storage engine | Closed (5579 days) | S1 | 5.1-maria, 6.0-maria | Any | Any | Maria deadlock in _ma_bitmap_wait_or_flush |
39446 | 2008-09-15 8:49 | 2020-09-13 20:45 | MySQL Server: Maria storage engine | Duplicate (5652 days) | S1 | 6.0-bzr | Any | Any | Maria deadlock in pagecache_read |
40025 | 2008-10-14 16:06 | 2008-11-05 21:11 | MySQL Server: Maria storage engine | Can't repeat (5644 days) | S1 | 6.0-bzr | Any | Any | Maria deadlock in translog_buffer_lock, _ma_unlock_key_del, wait_for_update_bin |
38368 | 2008-07-25 9:34 | 2008-08-16 10:26 | MySQL Server: Maria storage engine | Can't repeat (5725 days) | S1 | 6.0-bzr | Any | Any | Maria deadlock on INSERT/UPDATE/DELETE |
39420 | 2008-09-12 11:58 | 2008-11-06 18:05 | MySQL Server: Maria storage engine | Can't repeat (5643 days) | S3 | 6.0.7 | Any | Any | maria deadlock when doing a large insert |
43620 | 2009-03-13 6:34 | 2009-05-07 8:32 | MySQL Server: Maria storage engine | Closed (5461 days) | S3 | 6.0.11-bzr | Any | Any | Maria throws 'Got error 176 from storage engine' on a range query |
42509 | 2009-02-01 9:20 | 2010-05-26 18:00 | MySQL Server: Maria storage engine | Unsupported (5077 days) | S2 | 6.0-maria | Any | Any | Maria write_block_record: Assertion `data_length < ((block_size) * 3 / 4)' |
39904 | 2008-10-07 9:34 | 2018-09-25 21:49 | Tests: Engine | Closed (5665 days) | S7 | 6.0-rpl | Any | Any | maria-autozerofill fails sporadically on pushbuild |
37005 | 2008-05-27 13:54 | 2008-06-11 20:51 | MySQL Server: Maria storage engine | Closed (5791 days) | S3 | 5.1-maria | Any | Any | Maria: ALTER TABLE TRANSACTIONAL=0 leaves table transactional inside Maria |
40579 | 2008-11-07 15:20 | 2009-03-10 14:39 | MySQL Server: Maria storage engine | Closed (5519 days) | S3 | 5.1-maria | Any | Any | Maria: assertion in page cache in check_and_set_lsn() |
43694 | 2009-03-17 9:36 | 2010-05-26 18:00 | MySQL Server: Maria storage engine | Unsupported (5077 days) | S3 | 6.0-maria | Any | Any | Maria: assertion on "table->file->stats.records > 0 || error" in INSERT SELECT |
41159 | 2008-12-01 21:01 | 2009-01-09 15:00 | MySQL Server: Maria storage engine | Closed (5579 days) | S3 | 5.1-maria | Any | Any | Maria: deadlock between checkpoint and maria_write() when extending data file |
37007 | 2008-05-27 14:36 | 2008-09-05 16:31 | MySQL Server: Maria storage engine | Closed (5705 days) | S3 | 5.1-maria | Any | Any | Maria: different checksum for MyISAM table depending on CHECKSUM=0|1 |
40425 | 2008-10-30 11:50 | 2008-12-17 10:30 | MySQL Server: Maria storage engine | Can't repeat (5602 days) | S1 | 6.0 | Any | Any | Maria: ha_maria::enable_indexes(uint): Assertion `0' failed. |
36258 | 2008-04-22 13:58 | 2008-05-19 12:16 | MySQL Server: Maria storage engine | Closed (5814 days) | S2 | 5.1-maria | Any | Any | Maria: INSERT SELECT sends ok to client before committing |
40892 | 2008-11-20 16:10 | 2009-01-08 10:38 | MySQL Server: Maria storage engine | Closed (5580 days) | S1 | 6.0.8-release | Any | Any | maria: Livelock in sysbench OLTP_RW test |
42519 | 2009-02-01 15:36 | 2010-01-04 15:47 | MySQL Server: Maria storage engine | Closed (5461 days) | S2 | 6.0-maria | Any | Any | Maria: RESTORE leads to corrupted table and assertion |
41962 | 2009-01-08 14:05 | 2009-03-10 20:54 | MySQL Server: Maria storage engine | Closed (5519 days) | S3 | 5.1-maria | Any | Any | Maria: view-related test failures (insert, view, maria, trigger tests) |
43002 | 2009-02-19 7:39 | 2013-07-04 13:10 | MySQL Server: Maria storage engine | Won't fix (3942 days) | S3 | 6.0-TRUNK | Any | Any | maria.maria_notembedded fails sporadically |
43001 | 2009-02-19 7:34 | 2021-05-23 20:45 | MySQL Server: Falcon storage engine | Duplicate (5511 days) | S3 | 6.0-TRUNK | Any | Any | maria.maria-no-logging fails sporadically on valgrind in PS mode |
50440 | 2010-01-19 11:26 | 2012-02-10 14:23 | MySQL Server: Replication | Closed (4452 days) | S2 | 5.1+ | Any | Any | mark [INSERT|REPLACE|CREATE]...SELECT unsafe if updated table has autoinc column |
58637 | 2010-12-01 19:44 | 2014-06-25 14:34 | MySQL Server: Replication | Closed (4382 days) | S2 | 5.1+, 5.0, 5.6.1 | Any | Any | Mark INSERT...ON DUPLICATE KEY UPDATE unsafe when there is more than one key |
50439 | 2010-01-19 11:16 | 2011-09-30 18:19 | MySQL Server: Replication | Closed (4585 days) | S2 | 5.1+ | Any | Any | mark INSERT...SEL...ON DUP KEY UPD,REPLACE...SEL,CREATE...[IGN|REPL] SEL unsafe |
55481 | 2010-07-22 13:53 | 2023-02-12 20:45 | MySQL Server: Replication | Verified (5020 days) | S2 | 5.1+ | Any | Any | Mark INSERT...SELECT into non-transactional table unsafe |
57250 | 2010-10-05 14:07 | 2017-05-21 20:45 | MySQL Server: Replication | Verified (4945 days) | S2 | 5.1+ | Any | Any | mark INSERT...SELECT with autoinc column unsafe when innodb_autoinc_lock_mode=2 |
48382 | 2009-10-28 16:12 | 2016-10-16 20:45 | MySQL Server: Replication | Verified | S2 | 5.1+ | Any | Any | mark reads from mysql.* and information_schema.* as unsafe |
106918 | 2022-04-05 17:46 | 2022-05-25 10:19 | MySQL Server: Row Based Replication ( RBR ) | Verified (695 days) | S3 | 8.0.25 | Any | Any | master and slave may get serious in-consistence after add auto-increment as pk |
31603 | 2007-10-15 11:20 | 2012-05-18 20:19 | MySQL Server: Row Based Replication ( RBR ) | No Feedback (5998 days) | S1 | mysql-5.1-wl2325-5.0-drop6 | Any | Any | Master crashes during execution of rpl_user_variables test case |
71575 | 2014-02-04 3:59 | 2015-02-25 4:54 | MySQL Server: Replication | Closed (3341 days) | S3 | Any | Any | Master logs two consecutive GTIDs causing slaves to miss the first GTID | |
70342 | 2013-09-13 22:18 | 2013-09-21 15:44 | MySQL Server: Replication | Verified (3863 days) | S5 | 5.6.13 | Any | Any | master_info_repository=FILE calls my_b_printf too often |
37417 | 2008-06-16 1:47 | 2012-05-18 20:19 | MySQL Server: Replication | No Feedback (5642 days) | S3 | 5.0.64 | Any | Any | Master/Slave INSERT/SELECT results differ |
74962 | 2014-11-21 13:24 | 2014-11-21 14:20 | MySQL Server: Optimizer | Verified (3437 days) | S3 | 5.5/5.6 | Any | Any | Matching in char field type is not correct |
103387 | 2021-04-20 17:27 | 2021-04-26 14:33 | MySQL Server | Duplicate (1089 days) | S3 | 8.0.19 | Any | Any | max_allowed_packet prevents use of LONGBLOB and large JSON |
35703 | 2008-03-31 11:03 | 2008-05-02 20:51 | MySQL Server: DML | No Feedback (5831 days) | S3 | Any | Any | Max_delayed_thread does not make delayed insert threads as normal insert | |
629 | 2003-06-11 0:15 | 2003-07-03 7:05 | MySQL Server | Won't fix (7596 days) | S3 | 4.0 | Any (all) | Any | max_join_size and sql_select_limit affect CREATE SELECT |
10317 | 2005-05-02 16:28 | 2005-05-11 18:14 | MySQL Server: Documentation | Closed (6918 days) | S2 | 5.0.4.-beta-standard | Any (Any) | Any | Max_Rows option for Innodb, Myisam and Memory engines. |
77959 | 2015-08-06 10:45 | 2021-02-18 9:57 | MySQL Server: Tests | Duplicate (1156 days) | S3 | 5.7.8, 5.7.9 | Any | Any | max_statement_time test is unstable |
50190 | 2010-01-08 16:39 | 2018-09-09 20:45 | MySQL Server: Optimizer | Duplicate (5184 days) | S3 | 6.0-codebase,pe,next-mr | Any | Any | MAX() and MIN() failing for time values with Innodb |
29413 | 2007-06-28 8:38 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5364 days) | S4 | 5.0.41 | Any | Any | Maximum performance of OLTP benchmark is not so scalable on multi-cpu |
47835 | 2009-10-05 13:19 | 2011-02-16 23:44 | MySQL Server: Replication | Can't repeat (4872 days) | S3 | 5.1.37sp1 | Any | Any | MBR replication failure under concurrent load with OFFSET in subselect |
68609 | 2013-03-08 0:28 | 2014-10-09 16:07 | MySQL Server: Replication | Won't fix (3480 days) | S3 | 5.5.30, 5.6.10 | Any | Any | MBR: Unique key updates are not marked unsafe, replication fails |
20536 | 2006-06-19 13:36 | 2006-09-25 15:00 | MySQL Server: Charsets | Closed (6416 days) | S3 | 5.0.23BK, 4.1 | Any (*) | Any | md5() with GROUP BY and UCS2 return different results on myisam/innodb |
52377 | 2010-03-25 20:15 | 2022-12-04 20:45 | MySQL Server: Locking | Verified (5048 days) | S4 | 5.5.4-m3,5.6.99-m4 | Any | Any | MDL locks taken by failing statements not automatically removed |
53238 | 2010-04-28 8:43 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5030 days) | S3 | M3 (Celosia) | Any | Any | mdl_sync fails sporadically |
57813 | 2010-10-28 14:40 | 2018-12-09 20:45 | MySQL Enterprise Monitor: Web | Verified (4922 days) | S3 | 2.3.0.2036 | Any | Any | MEM Dashboard: could not insert: [com.mysql.etools.monitor.pom.hib.HibNamed |
72265 | 2014-04-07 16:59 | 2014-04-08 4:56 | MySQL Enterprise Monitor: Agent | Verified (3664 days) | S3 | 3.0.8 | Any | Any | MEM tries to explain INSERT/UPDATE/DELETE type statements on a read-only slave |
27756 | 2007-04-11 14:25 | 2007-04-17 10:01 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6212 days) | S3 | 5.1 | Any | Any | Memleak with insert+delete |
75879 | 2015-02-12 17:04 | 2015-06-24 4:00 | MySQL Utilities: Binlog Events | Closed (3280 days) | S2 | 5.6,5.7 | Any | Any | memory consumed quickly while executing loop in procedure |
110518 | 2023-03-27 23:53 | 2023-12-23 13:54 | MySQL Server: Group Replication | Closed (118 days) | S3 | all, 8.0 | Any | Any | Memory leak possible |
69075 | 2013-04-26 3:07 | 2014-02-19 10:39 | MySQL Server: Memory storage engine | Duplicate (3712 days) | S3 | 5.6.11, 5.6.15 | Any | Any | Memory leak slave_parallel_workers |
111654 | 2023-07-04 10:33 | 2023-07-05 13:00 | MySQL Server | Not a Bug (289 days) | S5 | 8.0.31 | Any (Mac, Alpine docker image) | Any (Arm 64) | Memory usage increasing with truncate |
15062 | 2005-11-18 23:03 | 2005-11-19 18:20 | Connector / J | Can't repeat (6726 days) | S2 | 3.1.11 | Any (Any) | Any | Memory/Object leak on inserts |
104117 | 2021-06-26 2:36 | 2021-06-26 2:39 | MySQL Server: Group Replication | Closed (1028 days) | S2 | mysql8.0.23 mysql8.0.24 | Any | Any | MGR all second node abnormal stop |
104118 | 2021-06-26 2:42 | 2022-08-23 8:45 | MySQL Server: Security: Privileges | Verified (1025 days) | S2 | 8.0.24 | Any | Any | MGR all second node abnormal stop |
42762 | 2009-02-11 13:54 | 2018-06-19 7:11 | MySQL Workbench | Won't fix (2131 days) | S1 | Any | Any | Migrate INTEGER to wrong data types | |
52303 | 2010-03-23 13:52 | 2010-04-13 5:29 | MySQL Server: Optimizer | Not a Bug (5120 days) | S3 | 5.1.46, 5.5.1-m2, 5.5.3-m3 | Any | Any | MIN() outputs 0 as the minimum year(4) corresponding to 0000 |
38517 | 2008-08-01 8:56 | 2008-08-01 13:35 | MySQL Server: General | Closed (5740 days) | S3 | 5.0.45 | Any (Linux 64bit) | Any | min() returns values from unmatched rows when used on unique index |
45507 | 2009-06-15 19:05 | 2022-12-04 20:45 | MySQL Server: Errors | Verified (5421 days) | S4 | 5.0 | Any | Any | Misleading error message (Error 1054) |
71279 | 2014-01-02 17:29 | 2014-01-08 9:33 | MySQL Server: Security: Privileges | Verified (3760 days) | S3 | 5.6 | Any | Any | Misleading error message for ANALYZE against PERFORMANCE_SCHEMA tables |
33258 | 2007-12-15 9:06 | 2010-05-26 17:59 | MySQL Server: Falcon storage engine | Unsupported (5077 days) | S3 | 6.0.5 | Any | Any | Misleading Error when DROP TABLE operation while a transaction is open |
69986 | 2013-08-11 20:49 | 2013-10-02 12:20 | MySQL Cluster: Cluster (NDB) storage engine | Closed (3852 days) | S4 | Any | Any | Any | misleading ndb_autoincrement_prefetch_sz documentation |
47901 | 2009-10-07 18:03 | 2022-12-04 20:45 | MySQL Server: Errors | Verified (5307 days) | S3 | 5.0.86, 5.1.40 | Any | Any | Missing default value warning issued on TEXT fields on INSERT |
17144 | 2006-02-05 21:31 | 2008-10-04 18:34 | MySQL Server: Security: Privileges | Unsupported (5676 days) | S4 | 4.0 and above | Any (*) | Any | Missing default values in user table complicate insert into user table |
39701 | 2008-09-27 16:59 | 2011-02-16 23:43 | MySQL Server: Row Based Replication ( RBR ) | Closed (5483 days) | S2 | 5.1.28, 5.1, 6.0 bzr | Any | Any | Mixed binlog format does not switch to row mode on LOAD_FILE |
68077 | 2013-01-14 3:37 | 2013-04-03 11:33 | MySQL Server: InnoDB storage engine | Closed (4034 days) | S5 | 5.6 | Any | Any | Mixing 4K/16K blocks increases 8K free blocks and holds buf pool mutex longer |
41157 | 2008-12-01 19:38 | 2011-02-16 23:43 | MySQL Server: General | Verified (5617 days) | S3 | 5.1 | Any | Any | Modify PreparedStatement to include timestamp column in RETURN_GENERATED_KEYS |
78360 | 2015-09-08 6:14 | 2015-09-08 12:29 | MySQL Server: DML | Verified (3146 days) | S3 | 5.6.22, 5.6.26 | Any | Any | More than 1 row is returned when using "having count(alias)" |
54249 | 2010-06-05 2:32 | 2017-05-21 20:45 | MySQL Server: Row Based Replication ( RBR ) | Verified (5066 days) | S3 | 5.1 | Any | Any | More verbose RBR error logging |
33928 | 2008-01-18 18:34 | 2013-02-20 22:18 | Connectors: DBD::mysql ( Perl ) | Unsupported (4076 days) | S2 | 4.006 | Any | Any | more_results incorrectly interprets value returned by mysql_next_result() |
37148 | 2008-06-03 3:21 | 2011-02-16 23:43 | MySQL Server: Replication | Closed (5149 days) | S3 | 5.0.37, 5.0.64, 5.1.26 | Any | Any | Most callers of mysql_bin_log.write ignore the return result |
59968 | 2011-02-05 20:35 | 2014-07-17 1:04 | Connector / ODBC | Closed (3978 days) | S2 | 5.1.8 | Any | Any | MS Access ODBC Driver 5.1.8 #DELETED on Insert after Changing field to NULL |
52203 | 2010-03-19 8:28 | 2018-09-25 21:51 | Tools: MTR / mysql-test-run | Closed (4819 days) | S7 | M3 (Celosia) | Any | Any | MTR sporadic bug (Could not execute 'check-testcase' before testcase) |
39003 | 2008-08-25 11:34 | 2018-09-25 21:49 | Tools: MTR / mysql-test-run | Closed (5236 days) | S7 | 5.1, 5.4 | Any | Any | mtr's diff_files command failed in pushbuild without printing a result diff |
28719 | 2007-05-28 9:18 | 2007-06-11 20:20 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6157 days) | S3 | 5.1 | Any | Any | multi pk update ignore corrupts data |
105885 | 2021-12-14 0:42 | 2021-12-14 13:39 | MySQL Cluster: Cluster (NDB) storage engine | Verified (857 days) | S3 | 8.0.27 | Any | Any | Multi row operation mixes can cause crash during node recovery |
57373 | 2010-10-11 14:14 | 2011-03-02 15:25 | MySQL Server: DML | Closed (4797 days) | S3 | 5.1, 5.5 | Any | Any | Multi update+InnoDB reports ER_KEY_NOT_FOUND if a table is updated twice |
43895 | 2009-03-26 18:45 | 2014-07-14 15:31 | MySQL Server: DML | Closed (3567 days) | S3 | 5.1 bzr | Any | Any | Multi-DELETE IGNORE does not report warnings |
25507 | 2007-01-09 22:46 | 2011-02-16 23:43 | MySQL Server: Replication | Closed (5051 days) | S2 | 4.1-bk,5.0.34 | Any (*) | Any | multi-row insert delayed + auto increment causes duplicate key entries on slave |
73932 | 2014-09-16 12:49 | 2015-03-24 21:55 | MySQL Server: Optimizer | Closed (3357 days) | S3 | 5.7 | Any | Any | multi-update crash with long primary key |
615 | 2003-06-06 13:51 | 2003-07-01 3:18 | MySQL Server | Closed (7598 days) | S2 | 4.0.13, 4.1.0 | Any (Any) | Any | Multiple inserting NULL into a column that has been declared NOT NULL |
56299 | 2010-08-26 16:16 | 2011-11-07 17:24 | MySQL Server: Locking | Closed (4547 days) | S1 | 5.1.50,5.5.5 | Any | Any | mutex deadlock with COM_BINLOG_DUMP, binlog purge, and processlist/kill |
72806 | 2014-05-30 6:43 | 2015-04-29 0:11 | MySQL Server: Compiling | Closed (3278 days) | S5 | 5.7.7 | Any | Any | mutex_delay() missing x86 pause instruction optimization |
37820 | 2008-07-02 19:22 | 2008-07-03 11:54 | MySQL Server: Charsets | Duplicate (5769 days) | S2 | 5.1.25-rc, 4.1, 5.0, 5.1, 6.0 bzr | Any | Any | MyISAM and InnoDB provide different results on test with prefix index |
57323 | 2010-10-07 17:50 | 2011-06-21 18:51 | MySQL Server: MyISAM storage engine | Closed (4686 days) | S1 | 5.1.53, 5.5.7 | Any | Any | myisam corruption with insert ignore and invalid spatial data |
32705 | 2007-11-26 5:57 | 2008-04-15 2:13 | MySQL Server: MyISAM storage engine | Closed (5848 days) | S1 | 5.1.23, 5.0.50, 6.0.3 | Any | Any | myisam corruption: Key in wrong position at page 1024 with ucs2_bin |
41709 | 2008-12-23 10:59 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5467 days) | S3 | 5.0.70, 5.1.30 | Any (windows+linux+solaris) | Any | myisam external locking doesn't work as advertised |
58689 | 2010-12-03 6:02 | 2012-07-31 1:44 | MySQL Server: Locking | Closed (4280 days) | S3 | 5.0, 5.1, 5.6.1 | Any | Any | MyISAM Selects locks inserts inside procedure only |
28837 | 2007-06-01 13:57 | 2008-01-15 16:26 | MySQL Server: MyISAM storage engine | Closed (5939 days) | S3 | 4.1BK/5.0BK/5.1BK | Any | Any | MyISAM storage engine error (134) doing delete with self-join |
31305 | 2007-09-30 16:08 | 2007-11-26 19:00 | MySQL Server: MyISAM storage engine | Closed (5989 days) | S1 | 4.0.26, 4.1.21, 5.1.23, 5.0.48, 6.0.4 | Any | Any | myisam tables crash when they are near capacity |
76710 | 2015-04-15 14:48 | 2015-04-16 7:36 | MySQL Server: Tests | Verified (3291 days) | S3 | 5.7.7 | Any | Any | myisam_views-big fails |
36065 | 2008-04-14 17:08 | 2012-05-18 20:19 | MySQL Server: MyISAM storage engine | Duplicate (5832 days) | S3 | 6.0-falcon-team | Any | Any | MyISAM: duplicate key error on unique values |
23264 | 2006-10-13 15:35 | 2011-02-16 23:43 | Connector / ODBC | Closed (5237 days) | S2 | 3.51 | Any | Any | MyODBC driver returns 'x' instead of empty string when IF applies on TEXT field |
68947 | 2013-04-13 11:39 | 2013-05-14 1:00 | MySQL Server | No Feedback (3994 days) | S3 | 5.5.8 | Any | Any | Mysql |
86053 | 2017-04-24 9:20 | 2018-10-21 20:45 | MySQL Server | No Feedback (2522 days) | S3 | 5.7.11 | Any | Any | MySQL 1062 –Duplicate entry for key without duplicate value |
29788 | 2007-07-13 14:35 | 2007-07-27 5:25 | MySQL Server: Backup | Closed (6111 days) | S2 | 5.0.45, 5.0 BK, 6.0.1-Falcon | Any | Any | MySQL 5.0.45 restore of dump fails |
61830 | 2011-07-12 8:51 | 2011-07-12 9:29 | Connector / ODBC | Closed (4665 days) | S2 | MySQL Enterprise 5.5.9 | Any | Any | MySQL 5.1.8. Connector not identifying VARCHAR type in views. |
95595 | 2019-06-02 4:34 | 2019-06-04 12:20 | MySQL Server: Locking | Not a Bug (1781 days) | S3 | 5.6.26 | Any | Any | MySQL 5.6.26 high concurrency dead lock |
79317 | 2015-11-17 22:15 | 2016-04-25 13:30 | MySQL Server: Data Types | Not a Bug (3047 days) | S3 | 5.5.46, 5.6.27, 5.7.9.1 | Any | Any | MySQL 5.6.27 trying to validate binary data as UTF-8 |
90821 | 2018-05-10 9:43 | 2018-05-31 13:17 | MySQL Server: GIS | Not a Bug (2150 days) | S1 | 8 | Any (centos 7.3) | x86 | Mysql 8 support spatial fail with srid 4326 |
104335 | 2021-07-16 11:24 | 2021-07-16 12:56 | MySQL Server: Errors | Not a Bug (1008 days) | S3 | 8.0 | Any | Any | MySQL 8.0 operation failing silently |
92979 | 2018-10-28 13:51 | 2024-01-25 4:35 | MySQL Server: InnoDB storage engine | Closed (85 days) | S5 | 8.0.13 Communty Server | Any | x86 | MySQL 8.0 performance degradation on INSERT with foreign_key_checks=0 |
78276 | 2015-08-30 14:47 | 2015-10-06 18:15 | MySQL Server: Charsets | Closed (3118 days) | S3 | 5.7.8, 5.7.9, 5.6.26, 5.5.46 | Any | Any | MySQL accepts non-ascii in ascii columns |
55859 | 2010-08-09 20:21 | 2013-04-14 20:45 | MySQL Server: InnoDB storage engine | Verified (4862 days) | S4 | 5.1 | Any | Any | MySQL and InnoDB locks are taken in different orders in different statements |
104499 | 2021-07-31 20:35 | 2021-08-27 12:02 | MySQL Server: InnoDB storage engine | Verified (967 days) | S3 | Any | Any | MySQL auto_inc value changed after a failed insert | |
96628 | 2019-08-23 3:21 | 2019-08-24 2:23 | Connector / J | Not a Bug (1700 days) | S1 | 8.0.17 | Any | Any | mysql batch insert generatedKeys not accord expected |
37793 | 2008-07-02 8:26 | 2011-02-16 23:43 | MySQL Server: Command-line Clients | Verified | S4 | 5.0,5.1,6.0 | Any | Any | mysql cli verbosity level at stdin error |
28203 | 2007-05-02 14:50 | 2011-02-16 23:43 | MySQL Server: Command-line Clients | Closed (5370 days) | S3 | Any | Any | mysql client + null byte | |
28422 | 2007-05-14 18:35 | 2011-02-16 23:43 | MySQL Server: Command-line Clients | Verified (5980 days) | S3 | 5.0.40, 5.5.6 | Any | Any | mysql client does not recognize bit values |
71082 | 2013-12-05 3:18 | 2015-03-12 15:59 | MySQL Server: Command-line Clients | No Feedback (3647 days) | S3 | 5.7.3, 5.5.18 | Any | Any | mysql client was crashed while loading data |
47674 | 2009-09-28 11:37 | 2011-02-16 23:44 | MySQL Cluster: Replication | Closed (5307 days) | S2 | mysql-5.1-telco-6.2 | Any | Any | MySQL Cluster : Manually applying binlog zaps unmodified columns |
99388 | 2020-04-28 12:15 | 2020-04-29 15:06 | MySQL Cluster: Cluster (NDB) storage engine | Not a Bug (1452 days) | S1 | ndb-8.0.19 | Any | Any | Mysql Cluster 8 - “Jumpy” Auto Increment Values |
52061 | 2010-03-15 10:36 | 2011-02-16 23:44 | MySQL Server: Documentation | Closed (5147 days) | S3 | mysql-5.1 | Any | Any | MySQL Cluster docs : Wrong parameter effect description |
70758 | 2013-10-28 23:29 | 2013-11-07 20:32 | Connector / NET | Not a Bug (3816 days) | S3 | 6.7.4 | Any | Any | MySql Connector Targetting wrong namespace for EF6 |
109024 | 2022-11-08 7:49 | 2022-11-09 14:50 | Connector / Python | Closed (527 days) | S2 | 8.0 | Any | Any | MySQL Connector/Python Invalid executemany function |
33736 | 2008-01-08 9:53 | 2008-01-14 6:51 | MySQL Server: General | Closed (5940 days) | S2 | 5.1.22(5.1.19, 6.0.3) | Any | Any | mysql crash on error sql with INSERT DELAYED and ON DUPLICATE KEY UPDATE |
67886 | 2012-12-12 18:49 | 2012-12-12 19:16 | MySQL Server | Can't repeat (4146 days) | S2 | 5.5.28 | Any (MacOS X 10.8, Amazon RDS) | Any | MySQL crashes using REPLACE on a table with a five-fold composite primary key |
112463 | 2023-09-26 9:01 | 2023-10-04 11:24 | MySQL Server | Not a Bug (198 days) | S3 | 8.0.34 | Any | Any | MySQL Delete, Insert Lock Occur |
51593 | 2010-03-01 1:46 | 2011-05-26 19:42 | MySQL Server: Documentation | Closed (4712 days) | S3 | 5.0 and 5.1 | Any | Any | MySQL Documentation Incorrect on 'ALTER' Privilege |
26590 | 2007-02-23 11:30 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5057 days) | S2 | 5.0, 5.1, etc. | Any | Any | MySQL does not allow more than 1023 open transactions |
25034 | 2006-12-13 10:54 | 2008-06-18 11:20 | MySQL Server: General | Won't fix (5784 days) | S2 | 5.0 & 5.1 | Any (Any) | Any | MySQL does not correctly handle errors on statement commit |
76244 | 2015-03-10 16:31 | 2018-07-26 1:00 | MySQL Server: DML | No Feedback (2095 days) | S2 | 5.6.18, 5.1.73+ | Any | Any | MySQL does order of operations incorrectly on distinct numeric string |
27906 | 2007-04-17 23:27 | 2017-10-20 15:16 | MySQL Server: Data Types | Verified (6212 days) | S4 | 5.0 | Any | Any | MySQL doesn't accept ISO8601 date |
55831 | 2010-08-09 5:16 | 2010-08-09 11:18 | MySQL Server | Not a Bug (5002 days) | S3 | 5.1.45 | Any | Any | Mysql DUMP is not working properly |
30987 | 2007-09-12 17:46 | 2007-10-31 19:31 | MySQL Server: Data Types | Can't repeat (6015 days) | S3 | 5.0.44 | Any | Any | mysql Error: Warning | 1366 | Incorrect string value: '\xB4 FFFF...' for column |
76874 | 2015-04-28 15:23 | 2016-05-29 20:45 | Connector / J | Duplicate (3266 days) | S2 | 5.1.35 | Any | Any | Mysql fabric JDBC driver doens't update master server on fail |
87794 | 2017-09-18 15:10 | 2017-09-19 15:33 | MySQL Server: DML | Not a Bug (2404 days) | S3 | 5.7.17 | Any | Any | MySQL gives invalid value for float column type. |
104408 | 2021-07-25 7:19 | 2021-08-26 1:00 | MySQL Server: DDL | No Feedback (968 days) | S3 | 8.0.21 | Any | Any | MySQL got the single 11 and crush |
101114 | 2020-10-10 6:46 | 2020-11-15 1:00 | MySQL Server: Group Replication | No Feedback (1252 days) | S2 | 8.0.18 | Any | Any | MySQL group replication not set read_only before it joins the GR cluster |
33857 | 2008-01-14 4:15 | 2008-01-15 13:18 | MySQL Server | Can't repeat (5939 days) | S2 | 5.0.45 | Any (windows and linux) | Any | mysql hangs on certain querys in strict mode |
33735 | 2008-01-08 9:39 | 2008-10-05 14:52 | MySQL Server: Falcon storage engine | Closed (5675 days) | S3 | 6.0.4-p3 | Any | Any | mysql hangs when running systems test |
28000 | 2007-04-21 14:59 | 2007-05-17 14:24 | MySQL Server | Closed (6182 days) | S3 | 5.0.37,5.1, 6.0-falcon-bk | Any | Any | MySQL hangs when using INSERT IGNORE ... ON DUPLICATE KEY |
82592 | 2016-08-16 3:55 | 2016-09-02 13:11 | MySQL Server: InnoDB storage engine | Not a Bug (2796 days) | S3 | 5.7.14 | Any | Any | MySQL InnoDB update locking |
110795 | 2023-04-25 5:45 | 2023-04-25 8:41 | MySQL Server: Locking | Verified (360 days) | S3 | 8.0.27, 8.0.33, 5.7.42 | Any | Any | mysql insert is deadlocked |
73816 | 2014-09-05 12:56 | 2016-04-18 3:18 | MySQL Server: Locking | Closed (2978 days) | S2 | 5.6.20 | Any | Any | MySQL instance stalling “doing SYNC index” |
86215 | 2017-05-08 13:35 | 2017-07-11 22:44 | MySQL Server: Optimizer | Analyzing (2474 days) | S5 | 8.0.1 | Any | Any | MySQL is much slower in 5.7 vs 5.6 |
85641 | 2017-03-27 9:17 | 2017-03-27 15:49 | MySQL Server: Data Types | Verified (2580 days) | S3 | 5.7.17 | Any | Any | MySQL is not consequent in handling non existing time between 2 and 3 o'clock |
72628 | 2014-05-13 7:56 | 2014-07-30 10:02 | MySQL Server: Data Types | Not a Bug (3551 days) | S3 | 5.6 | Any | Any | MySQL is not inserting Default value for datetime column when null value passed |
73896 | 2014-09-11 15:40 | 2015-02-02 22:06 | MySQL Server: DML | Verified (3364 days) | S3 | 5.5.40/5.6.23 | Any | Any | MySQL issues an "Unsafe statement" warning for what should be a safe statement |
101823 | 2020-12-01 17:47 | 2022-11-25 16:14 | Connector / J | Not a Bug (511 days) | S3 | 8.0.22, 8.0.12 | Any | Any | MySQL JDBC driver incorrectly reports bigint as BigInteger in generated keys |
50551 | 2010-01-22 17:04 | 2010-01-22 17:20 | MySQL Migration Toolkit | Unsupported (5201 days) | S3 | Any | Any | MySQL Migration Toolkit problem with multiple schemas | |
36802 | 2008-05-19 15:42 | 2022-01-05 15:50 | MySQL Server: Optimizer | Closed (835 days) | S3 | 5.0, 5.1, 6.0 BK | Any | Any | MySQL only use covered index when selecting from a view (or subquery) with union |
22561 | 2006-09-21 17:44 | 2006-09-27 18:28 | MySQL Query Browser | Duplicate (6414 days) | S4 | 1.2.1 beta | Any (All) | Any | MySQL Query Browser Should Have An Export To Sql Option |
112879 | 2023-10-30 1:54 | 2023-10-31 12:01 | MySQL Router Documentation | Closed (171 days) | S3 | 8.2 | Any | Any | MySQL Router 8.2 document may have some minor mistakes |
64004 | 2012-01-12 4:12 | 2012-01-12 15:54 | MySQL Server: Charsets | Not a Bug (4481 days) | S3 | Any | Any | Mysql see two different unicode characters as the same | |
94476 | 2019-02-26 18:44 | 2019-03-14 17:05 | MySQL Server: Replication | Can't repeat (1863 days) | S2 | 5.7.21 | Any | Any | mysql semisync replication stuck with master in Waiting to finalize termination |
46178 | 2009-07-14 17:18 | 2011-02-16 23:44 | MySQL Server | Duplicate (5341 days) | S1 | 5.1.36 | Any | Any | MySql server crashes (supposedly when too many changes in transaction) |
81468 | 2016-05-17 16:31 | 2022-11-05 2:03 | Connector / J | Closed (531 days) | S3 | 5.1.36 and 6.0.2 tested | Any | Any | MySQL server fails to rewrite batch insert when column name contains word select |
52288 | 2010-03-23 1:26 | 2011-02-16 23:44 | MySQL Server: Documentation | Closed (5077 days) | S3 | 5.5.2, 5.0, 5.1 | Any | Any | MySQL sometimes does not accept BEGIN [WORK] |
80497 | 2016-02-24 14:57 | 2016-03-03 3:11 | Connector / J | Not a Bug (2969 days) | S4 | 5.0.4 | Any | Any | MySQL Statement executeBatch - batchedGeneratedKeys Field not exposed |
95212 | 2019-05-01 13:12 | 2019-05-06 13:51 | MySQL Server: DML | Verified (1812 days) | S4 | 8.0.15 | Any | Any | MySQL timestamp arithmetics should not produce invalid values |
11987 | 2005-07-17 3:56 | 2005-08-03 20:46 | MySQL Server | Closed (6834 days) | S3 | 4.1 .. 5.0 | Any (*) | Any | mysql will truncate the text when the text contain GBK char:"0xA3A0" and "0xA1" |
14547 | 2005-11-01 19:08 | 2022-12-04 20:45 | MySQL Server: C API (client library) | Verified (6727 days) | S4 | all | Any (all) | Any | mysql_affected_rows() and mysql_info() client calls not made upon error |
5196 | 2004-08-25 2:57 | 2004-08-25 19:58 | MySQL Server: Documentation | Closed (7177 days) | S3 | 4.1.X (including 4.1.4-bk) | Any (all) | Any | MYSQL_BIND.is_unsigned not documented |
34889 | 2008-02-27 14:27 | 2018-09-25 21:47 | MySQL Server: Tests | Closed (5853 days) | S7 | 5.0 | Any | Any | mysql_client_test::test_mysql_insert_id test fails sporadically |
69630 | 2013-07-01 15:15 | 2013-07-22 17:48 | MySQL Server: Documentation | Closed (3924 days) | S1 | 5.6.10 | Any | Any | MYSQL_FIELD structure has incorrect information. |
38900 | 2008-08-19 20:14 | 2011-02-16 23:43 | MySQL Server | Duplicate (5720 days) | S2 | 5.0.66a | Any | Any | mysql_insert_id() and possibly last_insert_id() incorrect |
35754 | 2008-04-01 22:42 | 2011-02-16 23:43 | MySQL Server: Installing | Closed (5663 days) | S2 | 5.0.58 | Any | Any | mysql_install_db does not work if no hostname is set |
36055 | 2008-04-14 11:53 | 2008-05-22 15:56 | MySQL Server: Command-line Clients | Closed (5811 days) | S2 | all | Any | Any | mysql_upgrade doesn't really 'upgrade' tables |
53613 | 2010-05-13 1:43 | 2011-02-16 23:44 | MySQL Server: General | Closed (4936 days) | S1 | 5.1.34>5.1.38/.40 and 5.1.34>5.1.46 | Any | Any | mysql_upgrade incorrectly revokes TRIGGER privilege on given table |
92804 | 2018-10-16 19:48 | 2018-10-19 15:09 | Shell Upgrade Checker | Not a Bug (2009 days) | S3 | 5.7.23 | Any | Any | mysql_upgrade not validate sql_mode |
35942 | 2008-04-09 15:59 | 2024-02-04 20:45 | MySQL Proxy | Verified (5611 days) | S2 | 0.6.1 , rev 511 | Any (SunOS 5.11 NexentaOS_20080131 i86pc i386 i86pc Solaris - Linux) | Any | MySQL-Proxy with rw-splitting.lua writes to slave because of SQL_CALC_FOUND_ROWS |
105223 | 2021-10-14 8:59 | 2021-10-15 23:36 | MySQL Router | Verified (918 days) | S2 | 8.0.26 | Any | Any | mysql-router bootstrap reuses wrong router_id from mysql_innodb_cluster_metadata |
87300 | 2017-08-03 10:18 | 2017-11-09 11:24 | Shell General / Core Client | Closed (2353 days) | S2 | mysqlsh Ver 1.0.10 for Linux on x86_64 | Any | Any | mysql-shell dba.checkInstanceConfiguration() |
49586 | 2009-12-10 13:27 | 2011-02-16 23:44 | MySQL Cluster: Replication | Closed (5170 days) | S3 | mysql-5.1-ndb-7.0 | Any | Any | mysql.ndb_replication should be restored first when restoring from backup |
43801 | 2009-03-23 10:08 | 2011-02-16 23:43 | Tests: Server | Closed (5485 days) | S3 | 5.0, 5.1, 6.0 | Any | Any | mysql.test takes too long, fails due to expired timeout on debx86-b in PB |
59038 | 2010-12-19 16:36 | 2011-04-21 0:43 | MySQL Server: Pluggable Authentication | Closed (4747 days) | S2 | 5.5.8 GA | Any | Any | mysql.user.authentication_string column causes configuration wizard to fail |
93336 | 2018-11-26 6:59 | 2018-11-26 7:26 | MySQL Server: Japanese Documentation | Verified (1971 days) | S3 | MySQL5.6 | Any | Any | MySQL5.6 Japanese Docs say " The REFERENCES privilege is not currently in use" |
109603 | 2023-01-12 12:06 | 2023-01-12 14:10 | MySQL Server | Duplicate (463 days) | S3 | Any | Any | MySQL8 write performance degrades compares to MySQL 5.7 | |
62268 | 2011-08-26 14:20 | 2011-09-12 10:03 | MySQL Enterprise Backup | Closed (4603 days) | S1 | 3.6.0 | Any | Any | mysqlbackup 3.6 will not work with ROW based binlogs and READ-COMMITTED |
47323 | 2009-09-15 12:27 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5235 days) | S3 | mysql-5.1-telco-6.2 | Any | Any | mysqlbinlog --verbose displays bad output when events contain subset of columns |
47557 | 2009-09-23 15:50 | 2011-02-16 23:44 | MySQL Server: Row Based Replication ( RBR ) | Closed (4831 days) | S2 | 5.1+ | Any | Any | mysqlbinlog -v should output 'limit 1' for update and delete row events |
43402 | 2009-03-05 8:31 | 2009-03-05 13:18 | MySQL Server: Replication | Not a Bug (5524 days) | S2 | 5.0.45 | Any | Any | mysqlbinlog ignores data added using "insert into database.table values(...) |
29422 | 2007-06-28 14:49 | 2013-10-10 16:48 | MySQL Server: Command-line Clients | Closed (3844 days) | S3 | 5.1.20 | Any | Any | mysqlbinlog incorectly quotes user variable named <backtick> |
52330 | 2010-03-24 14:16 | 2010-03-26 14:00 | MySQL Server: Command-line Clients | Not a Bug (5138 days) | S2 | mysqlbinlog Ver 3.3 for pc-linux | Any (mysqlbinlog Ver 3.3 for pc-linux-gnu at i686) | Any | mysqlbinlog not filtering log events for a given database |
71324 | 2014-01-09 12:34 | 2014-01-13 8:57 | MySQL Utilities: Binlog Events | Verified (3749 days) | S3 | 5.5.30, 5.5.35 | Any | Any | mysqlbinlog parses binary logs wrong with tinyint unsigned values |
69253 | 2013-05-16 7:31 | 2014-08-27 4:50 | MySQL Server: Row Based Replication ( RBR ) | Closed (3523 days) | S3 | 5.6.11 | Any | Any | mysqlbinlog prints incorrect value while using decimal |
70711 | 2013-10-23 18:21 | 2015-06-24 4:30 | MySQL Server: Replication | Closed (3285 days) | S3 | 5.6.14 | Any | Any | mysqlbinlog prints invalid SQL from relay logs when GTID is enabled |
51226 | 2010-02-16 23:18 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5051 days) | S3 | 5.1.44, 6.0-backup | Any | Any | mysqlbinlog replay: ERROR 1146 when using temp tables + failing statements |
59177 | 2010-12-27 5:10 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (4830 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | mysqlbinlog_row_big fails on Windows with out of memory |
30200 | 2007-08-02 8:33 | 2007-08-03 2:18 | MySQL Server: Replication | Closed (6104 days) | S2 | Any | Any | mysqlbinlog.test: connection_id() not restored under ps-protocol | |
78778 | 2015-10-09 9:45 | 2017-04-11 7:15 | MySQL Server: C API (client library) | Closed (2604 days) | S3 | 5.7.8 | Any | Any | mysqlclient does not return correct mysql_insert_id via database handle |
89139 | 2018-01-08 20:06 | 2018-04-16 11:11 | MySQL Server: C API (client library) | Closed (2195 days) | S3 | 5.7.20, 8.0.3 | Any | Any | mysqlclient does not return correct mysql_insert_id after ping() |
108145 | 2022-08-16 8:13 | 2022-10-21 20:45 | Connector / Python | Closed (546 days) | S2 | 8.0.30 | Any | Any | MySQLCursor.executemany() fails to correctly identify BULK data loading ops |
102269 | 2021-01-18 10:11 | 2021-01-18 10:22 | MySQL Server | Closed (1187 days) | S3 | 8.0.22 | Any | Any | mysqld automatic reboot when do batch insert or do others batch dml |
35599 | 2008-03-27 11:47 | 2008-10-05 16:36 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5675 days) | S1 | telco-6.4 | Any | Any | Mysqld crash after delete records from table (with constraint violation) |
42640 | 2009-02-06 7:17 | 2011-02-16 23:43 | MySQL Server | Closed (5453 days) | S2 | 5.1-bugteam, 5.1 | Any | Any | mysqld crashes when unsafe statements are executed (STRICT_TRANS_TABLES mode) |
48837 | 2009-11-17 12:46 | 2009-11-21 6:51 | MySQL Server: Charsets | Not a Bug (5263 days) | S2 | 5.1.41 | Any | Any | mysqldump --all-databases: german äöü destroyd |
55540 | 2010-07-26 0:41 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | No Feedback (4941 days) | S2 | 5.1.47 | Any | Any | mysqldump --complete-insert : result order differs from column order |
64309 | 2012-02-13 11:34 | 2012-03-07 2:54 | MySQL Server: Documentation | Closed (4426 days) | S3 | any | Any | Any | mysqldump --disable-keys |
35224 | 2008-03-11 16:07 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Closed (5158 days) | S3 | 5.1-bk | Any | Any | mysqldump --help is very confusing |
48972 | 2009-11-22 20:03 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Verified (3671 days) | S3 | 5.0 | Any | Any | mysqldump --insert-ignore leaves set unique_checks=0. |
4953 | 2004-08-09 14:54 | 2015-08-10 14:33 | MySQL Server: mysqldump Command-line Client | Closed (7182 days) | S2 | 4.0 | Any (all) | Any | mysqldump --master-data may report incorrect binlog position if using InnoDB |
44425 | 2009-04-23 10:34 | 2011-02-16 23:43 | MySQL Server: General | Verified (5475 days) | S3 | 5.1.22-rc-log | Any | Any | mysqldump --no-data still sets AUTO_INCREMENT base values to CREATE TABLE statem |
8830 | 2005-02-27 11:26 | 2019-10-07 12:17 | MySQL Server: mysqldump Command-line Client | Closed (6983 days) | S2 | 4.1 | Any | Any | mysqldump --skip-extended-insert causes --hex-blob to dump wrong values |
80790 | 2016-03-18 13:16 | 2021-10-07 20:59 | MySQL Server: mysqldump Command-line Client | Verified (2954 days) | S2 | 5.7.11, 5.7.29, 8.0.19 | Any | Any | mysqldump creates invalid dumpfile when generated columns exist |
29361 | 2007-06-26 14:04 | 2015-08-10 14:33 | MySQL Server: mysqldump Command-line Client | Closed (6128 days) | S3 | 5.0.44 | Any | Any | mysqldump creates stray file when too long path name is passed |
79171 | 2015-11-08 0:13 | 2015-11-19 15:30 | MySQL Server: mysqldump Command-line Client | Verified (3074 days) | S4 | Any | Any | mysqldump diff-friendly extended-insert | |
30833 | 2007-09-05 14:41 | 2007-09-05 15:07 | MySQL Server: Backup | Can't repeat (6071 days) | S3 | Ver 10.10 Distrib 5.0.27 | Any | Any | mysqldump does not create views when "information_schema" passed to --databases |
44995 | 2009-05-20 20:33 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Verified | S3 | 5.0+ | Any | Any | mysqldump does not properly format MAX DOUBLE values in its output. |
50728 | 2010-01-29 12:24 | 2011-02-16 23:44 | MySQL Workbench: Administration | Closed (5183 days) | S3 | 5.2.15 | Any | Any | mysqldump error with whitespace in table name |
73083 | 2014-06-23 17:49 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Duplicate (3581 days) | S4 | Any | Any | mysqldump extended inserts should have new line character between each insert | |
56587 | 2010-09-06 10:13 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | No Feedback (4943 days) | S1 | 5.1.45 | Any | Any | mysqldump fails to dump database |
3716 | 2004-05-11 17:56 | 2005-08-07 2:03 | MySQL Server | Closed (6830 days) | S4 | Any (all) | Any | mysqldump feature request: --add-drop-database | |
96053 | 2019-07-02 7:17 | 2020-04-13 16:44 | MySQL Server: mysqldump Command-line Client | Closed (1467 days) | S2 | 8.0.13, 8.0.16, 5.7.26 | Any | Any | mysqldump generates invalid insert statements with varbinary columns |
3816 | 2004-05-18 18:43 | 2015-08-10 14:33 | MySQL Server: mysqldump Command-line Client | Verified (6074 days) | S4 | any | Any (any) | Any | mysqldump option to wrap chunks of inserts into transactions |
67930 | 2012-12-17 18:58 | 2012-12-27 17:21 | MySQL Server: Backup | Not a Bug (4131 days) | S3 | 5.5 | Any | Any | mysqldump POINT field format incompatible with UTF-8, hex-blob doesn't apply |
1493 | 2003-10-06 22:07 | 2008-04-09 6:17 | MySQL Server | Closed (5854 days) | S3 | ./mysqldump Ver 9.08 Distrib 4.0.15a | Any (unknown-freebsd4.8 (i386)) | Any | mysqldump puts table names in different cases |
29628 | 2007-07-08 18:01 | 2015-08-10 14:33 | MySQL Server: mysqldump Command-line Client | Verified (6129 days) | S4 | 5.0.38 | Any | Any | mysqldump should put newlines between VALUES when using extended inserts |
41958 | 2009-01-08 12:29 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Duplicate (5574 days) | S2 | Any | Any | mysqldump shouldn't dump triggers before data | |
55222 | 2010-07-13 16:52 | 2019-05-15 10:40 | MySQL Server: InnoDB storage engine | Closed (4848 days) | S2 | 5.1.x, 5.1.49-bzr | Any (Windows 7, Mac OS X) | Any | Mysqldump table names case bug in REFERENCES clause |
61468 | 2011-06-09 21:54 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Verified (4697 days) | S4 | Any | Any | mysqldump values() group size | |
78763 | 2015-10-08 16:22 | 2015-10-08 17:02 | MySQL Server: mysqldump Command-line Client | Verified (3116 days) | S3 | 5.6/5.7 | Any | Any | mysqldump with --add-drop-trigger option when trigger name contains dots |
19551 | 2006-05-04 22:48 | 2006-05-04 22:51 | MySQL Server | Duplicate (6560 days) | S2 | 4.1.19 | Any (any) | Any | mysqldump with --delayed-insert and InnoDB |
77037 | 2015-05-14 9:19 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Closed (3251 days) | S3 | 5.7.7, 5.7.8 | Any | Any | mysqldump: Option '-T' used, but is disabled |
50517 | 2010-01-21 17:39 | 2010-03-02 1:44 | MySQL Server: Backup | Closed (5162 days) | S2 | 6.0.14-alpha | Any | Any | mysqldump.test sometimes times out |
12410 | 2005-08-06 6:20 | 2005-09-01 14:46 | MySQL Server: InnoDB storage engine | Closed (6805 days) | S2 | 4.1 | Any (any) | Any | mysqldump/InnoDB too permissive with LOCK TABLE foo READ LOCAL |
31988 | 2007-10-31 14:51 | 2008-04-20 9:36 | MySQL Server: Command-line Clients | No Feedback (5843 days) | S3 | 5.0.27 | Any | Any | mysqlhotcopy should FLUSH TABLES on _copy/_copy_old, else disk space not freed |
32991 | 2007-12-05 9:32 | 2011-02-16 23:43 | MySQL Server: Command-line Clients | Closed (5370 days) | S2 | 5.1, 6.0 | Any | Any | mysqlimport --use-threads test fails on solaris |
104674 | 2021-08-20 9:05 | 2021-08-20 9:30 | MySQL Workbench | Verified (973 days) | S3 | 8.0, 8.0.26 | Any | Any | MySQLLexer.g4 `BACK_TICK_QUOTED_ID `lexical rule definition bug |
78348 | 2015-09-06 9:09 | 2015-09-07 7:38 | MySQL Server: Command-line Clients | Closed (3147 days) | S3 | 5.7.8 | Any | Any | mysqlpump support for 4-byte UTF-8 |
78345 | 2015-09-05 22:33 | 2016-08-22 19:59 | MySQL Utilities | Verified (3012 days) | S2 | 1.5.4, 1.5.6, 1.6.2 | Any | Any | mysqlrpladmin requires excessive GRANTs and permissions |
81271 | 2016-05-02 7:24 | 2017-10-09 16:14 | MySQL Server: Document Store: MySQL Shell | Can't repeat (2384 days) | S3 | 5.7.12 | Any | Any | mysqlsh accepts collections with extra fields |
81260 | 2016-05-01 18:05 | 2016-08-24 16:15 | MySQL Server: Document Store: MySQL Shell | Closed (2795 days) | S2 | 5.7.12 | Any | Any | mysqlsh shows TIME columns as boolean values |
91394 | 2018-06-24 21:41 | 2018-12-19 14:15 | Shell AdminAPI InnoDB Cluster / ReplicaSet | Closed (1948 days) | S1 | 8.0.11 | Any | Any | mysqlsh will not recognize root privileges if they are assigned with a role |
29985 | 2007-07-23 19:56 | 2007-11-05 2:34 | MySQL Server: Command-line Clients | Closed (6010 days) | S2 | 5.1.* | Any | Any | mysqlslap -- improper handling of resultsets in SPROCs |
80987 | 2016-04-07 7:03 | 2016-04-07 7:56 | MySQL Server: Command-line Clients | Duplicate (2934 days) | S3 | 5.7 | Any | Any | mysqlslap auto-generate-sql-guid-primary |
64879 | 2012-04-05 14:38 | 2012-04-10 19:03 | MySQL Server: Documentation | Closed (4392 days) | S3 | 5.1+ | Any | Any | Mysqlslap documentation assumes a Linux console syntax for multiline statements |
49837 | 2009-12-21 6:13 | 2011-02-16 23:44 | Tools: MTR / mysql-test-run | Closed (5055 days) | S3 | 5.0,5.1,6.0 | Any | Any | mysqltest exec cannot handle multi-line command correctly |
62541 | 2011-09-26 9:53 | 2011-10-27 4:44 | MySQL Server | Closed (4558 days) | S4 | 5.1.23 | Any | Any | NAME_CONST('in_keyRef',_utf8'gT8nm3rWD+eILdXphATJ/w==') ERROR |
73991 | 2014-09-21 10:39 | 2023-11-12 14:57 | MySQL Server: Stored Routines | Open | S4 | Any | Any | Named parameter CALL syntax | |
32200 | 2007-11-08 21:28 | 2016-10-16 20:45 | MySQL Server: Replication | Verified (6002 days) | S3 | 5.0.50,5.1.22 | Any | Any | National characters in table/view names and replication |
6698 | 2004-11-18 16:52 | 2011-02-16 23:43 | MySQL Server: Prepared statements | Verified (6644 days) | S4 | 4.1.8 | Any (all) | Any | Native SQL prepared statements without using variables |
99807 | 2020-06-08 17:35 | 2020-06-25 15:32 | MySQL Server: DML | Closed (1394 days) | S3 | 8.0.19 | Any | Any | natural join returns wrong result when expression index is used |
48113 | 2009-10-16 13:21 | 2011-02-16 23:44 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5295 days) | S3 | mysql-5.1-telco-6.2+ | Any | Any | Ndb : Insert hitting DD space exhaustion does not lock following tuple ops |
52201 | 2010-03-19 8:06 | 2011-02-16 23:44 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5135 days) | S3 | mysql-5.1-telco-6.3 | Any | Any | Ndb : Insert hitting DD space exhaustion gives incorrect error message - part II |
5312 | 2004-08-31 9:08 | 2014-03-13 13:33 | MySQL Cluster: Cluster (NDB) storage engine | Won't fix (7093 days) | S3 | Any | Any | Ndb Cluster returns wrong error code for duplicate key at insert | |
30996 | 2007-09-13 10:54 | 2007-11-05 22:22 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6010 days) | S3 | 5.1.22 | Any | Any | NDB commits too early when LOCK TABLE & SET AUTOCOMMIT=OFF are used together |
30529 | 2007-08-21 7:16 | 2011-02-16 23:43 | MySQL Cluster: Replication | Closed (5077 days) | S3 | mysql-5.1 | Any | Any | NDB does not use default values extra columns in new rows |
52473 | 2010-03-30 12:51 | 2021-05-02 20:45 | MySQL Cluster: Replication | Verified (5109 days) | S3 | mysql-5.1-telco-6.3 | Any | Any | NDB inserts row when updating slave's empty table (with PK) |
53945 | 2010-05-24 15:10 | 2012-03-20 18:13 | MySQL Server: Documentation | Closed (4413 days) | S3 | mysql-5.1-telco-7.0 | Any | Any | ndb_autoincrement_prefetch_sz ignored for insert...select |
41500 | 2008-12-16 13:05 | 2021-05-02 20:45 | Tests: Cluster | Verified | S7 | 5.1, 6.0 | Any | Any | ndb_basic fails sporadically with "lock wait timeout exceeded" |
47666 | 2009-09-28 3:02 | 2021-05-02 20:45 | Tests: Cluster | Verified (5316 days) | S3 | mysql-5.0 | Any | Any | ndb_basic test fails due to incorrect result file |
55909 | 2010-08-11 11:01 | 2011-02-16 23:44 | MySQL Cluster: Replication | Closed (4951 days) | S3 | mysql-5.1-telco-7.1 | Any | Any | ndb_binlog_index missing entry on normal mysqld shutdown |
39927 | 2008-10-08 11:17 | 2011-02-16 23:43 | MySQL Cluster: Replication | Closed (5366 days) | S2 | mysql-5.1-telco-7.0 | Any | Any | ndb_log_update_as_write does not work as expected |
75506 | 2015-01-14 17:35 | 2015-01-19 15:28 | MySQL Cluster: Documentation | Closed (3378 days) | S3 | all | Any | Any | ndb_restore command utility - description of --node-id is misleading |
29103 | 2007-06-14 10:48 | 2007-06-19 12:25 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6149 days) | S3 | 5.1.19 | Any | Any | ndb_restore segfaults on NULL var[char|binary] |
25330 | 2006-12-29 12:17 | 2007-01-02 9:48 | MySQL Cluster: Cluster (NDB) storage engine | Won't fix (6317 days) | S3 | 5.1, 5.0?, 4.1? | Any | Any | ndb: table create and insert during node restart causes restart node crash |
54851 | 2010-06-28 6:42 | 2022-12-04 20:45 | MySQL Server: General | Verified (5037 days) | S1 | M3 (Celosia), M4 (Dahlia) | Any | Any | ndb.ndb_binlog_discover crashes the server |
36851 | 2008-05-21 12:17 | 2008-05-30 14:12 | MySQL Cluster: NDB API | Closed (5803 days) | S3 | All | Any | Any | NDBAPI : IgnoreError with Insert operation and Blobs |
56488 | 2010-09-02 9:46 | 2016-12-18 20:32 | MySQL Cluster: NDB API | Verified (2679 days) | S3 | mysql-5.1-telco-6.2 | Any | Any | NdbApi : Improve Blob/internal operation management |
42238 | 2009-01-21 11:54 | 2011-02-16 23:43 | MySQL Cluster: NDB API | Closed (5512 days) | S3 | 6.2+ | Any | Any | NDBAPI : NdbRecord insert permits key column value ambiguity |
42047 | 2009-01-12 11:29 | 2021-05-02 20:45 | MySQL Cluster: NDB API | Verified (5570 days) | S3 | mysql-5.1-telco-6.2 | Any | Any | NDBAPI : Too large BIT column causes node failure on insert |
19088 | 2006-04-13 20:05 | 2006-04-25 9:21 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6569 days) | S3 | 5.0 | Any (*) | Any | NDBAPI: Segfault in NdbIndexScanOperation::setBound(...) |
48037 | 2009-10-14 10:09 | 2011-02-16 23:44 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5295 days) | S3 | mysql-5.1-telco-7.0 | Any | Any | ndbmtd cluster crash during insert of data (dbtup) |
39792 | 2008-10-01 21:37 | 2011-03-08 13:52 | MySQL Server: General | Open | S4 | 4.1 thru 6.0 | Any | Any | Need automatic CURRENT_TIMESTAMP capability in separate TIMESTAMP fields |
38571 | 2008-08-05 13:06 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5734 days) | S4 | Any | Any | need better docs on how temporary tables are replicated | |
29042 | 2007-06-12 4:53 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5468 days) | S4 | any | Any | Any | Need documentation page on how InnoDB handles blobs |
75774 | 2015-02-04 22:51 | 2015-04-18 11:38 | MySQL Server | Open | S4 | Any | Any | Need function to get user context of calling statement to trigger | |
74538 | 2014-10-24 7:38 | 2014-11-03 15:15 | MySQL Server: Replication | Open | S4 | All | Any | Any | Need to change the style of SQL apply on slave mode for Update statement |
89965 | 2018-03-08 14:07 | 2020-10-02 12:48 | MySQL Server | Not a Bug (1295 days) | S4 | 8.0 | Any | Any | Need Validation when we insert data to the column with SRID |
55659 | 2010-07-31 11:39 | 2013-03-03 20:45 | MySQL Server: MyISAM storage engine | Verified | S3 | 5.1 bzr | Any | Any | Negative count(*) |
78933 | 2015-10-23 4:07 | 2015-11-04 18:43 | MySQL Server: Data Types | Not a Bug (3089 days) | S3 | 5.7.8, 5.7.9, 5.6.28, 5.5.47 | Any | Any | Negative zero(-0) is returned for mod(%) operation |
34817 | 2008-02-25 19:31 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Duplicate (4273 days) | S3 | mysql-5.1-telco-6.2 | Any | Any | nested DECLARE CONTINUE HANDLER FOR SQLSTATE '23000' is not triggered |
110244 | 2023-03-01 3:46 | 2023-03-01 6:30 | MySQL Server: Optimizer | Verified (415 days) | S2 | 8.0.32 | Any | Any | Nesting queries in a projection results in different output |
3309 | 2004-03-26 17:59 | 2005-03-07 19:10 | MySQL Server | Closed (6983 days) | S2 | 3.23, 4.0 and up | Any (any) | Any | Netmask matching for 'Host' doesn't work. |
3186 | 2004-03-16 1:52 | 2011-02-16 23:42 | MySQL Server: DML | Verified (6601 days) | S4 | Any | Any | new function: client_ip() | |
46272 | 2009-07-17 17:54 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5157 days) | S3 | 6.0-codebase | Any | Any | New MDL: unnecessary deadlock |
29178 | 2007-06-18 14:30 | 2011-02-16 23:43 | MySQL Server: Documentation | Won't fix (4999 days) | S3 | 5.0.44 | Any | Any | new memory chunks for heap tables depend on read_buffer_size |
34958 | 2008-02-29 10:03 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Open | S4 | mysql-5.1 | Any | Any | New parameter to name a cluster for logging and identification purposes |
109938 | 2023-02-04 21:51 | 2023-02-13 13:27 | MySQL Server: Locking | Not a Bug (434 days) | S3 | 8.0.31 | Any | Any | next key lock with ROLLBACK TO SAVEPOINT |
39267 | 2008-09-05 6:58 | 2008-10-03 10:56 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5677 days) | S3 | 5.1.27-ndb-6.3,16 | Any | Any | No caching of unique identifiers in PK-less tables |
39222 | 2008-09-03 19:00 | 2008-09-03 19:32 | MySQL Server | Not a Bug (5707 days) | S3 | 5.0.51-log | Any | Any | no difference between LOCK IN SHARE MODE and LOCK FOR UPDATE |
98069 | 2019-12-25 10:12 | 2020-01-09 4:53 | MySQL Server: Replication | Not a Bug (1571 days) | S3 | 5.7 | Any | Any | No error on slave while trigger for binlog_format="statement" and read_only is 1 |
73458 | 2014-08-03 10:23 | 2014-09-09 15:50 | MySQL Server: Documentation | Closed (3510 days) | S3 | 5.6.19, 5.6.21, 5.0.97 | Any | Any | No error or warning on truncation of TIMESTAMP/DATETIME |
44275 | 2009-04-14 21:58 | 2012-05-18 20:19 | MySQL Workbench | Duplicate (5481 days) | S1 | 5.1.10 Beta Build 5309 | Any | Any | No INSERT Statements are being generated |
40776 | 2008-11-17 9:38 | 2008-12-01 7:40 | MySQL Server: Security: Privileges | Duplicate (5618 days) | S2 | 5.0.67-community-nt | Any | Any | NO Privileges (insert,update,delete) for TEMPORARY table |
31906 | 2007-10-29 10:22 | 2007-10-29 11:10 | MySQL Server: DML | Not a Bug (6017 days) | S3 | Any | Any | No stmt rollback and wrong binlog if an error in {INSERT|CREATE} ... SELECT UNIO | |
39268 | 2008-09-05 7:05 | 2011-02-16 23:43 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5323 days) | S5 | mysql-5.1-telco-7.0 | Any | Any | No transaction hints used to update SYSTAB_0 for autoincrement and PK-less table |
58321 | 2010-11-19 11:56 | 2011-02-16 23:44 | MySQL Server: Charsets | Closed (4867 days) | S3 | 5.6, 5.5 | Any | Any | No warning when characters outside BMP0 is converted to UCS2 |
31257 | 2007-09-27 19:49 | 2007-11-06 8:47 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6009 days) | S3 | 4.1,5.0,5.1 | Any | Any | Node failure during LCP can lead to subsequent SR failure |
34698 | 2008-02-20 17:28 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | No Feedback (3151 days) | S3 | mysql-5.1 | Any | Any | Node restart in cluster with thousands of tables is very slow |
72512 | 2014-05-02 8:57 | 2014-06-04 16:45 | MySQL Server: Optimizer | Closed (3607 days) | S3 | 5.5, 5.6 | Any | Any | Non-aggregated query with set function in ORDER BY should be rejected |
71039 | 2013-11-29 14:20 | 2016-08-11 12:25 | MySQL Server: Parser | Verified | S3 | 5.7, 5.7.14 | Any | Any | non-standard usage of table alias allowed in SELECT but not in CREATE VIEW |
28960 | 2007-06-07 21:05 | 2017-05-21 20:45 | MySQL Server: Replication | Duplicate (6156 days) | S3 | <= 5.0.42, 5.1.x | Any | Any | non-trans temp table changes with insert .. select not binlogged after rollback |
34768 | 2008-02-22 21:19 | 2008-03-29 18:24 | MySQL Server: Replication | Closed (5865 days) | S2 | 5.1, 6.0 BK | Any | Any | nondeterministic INSERT using LIMIT logged in stmt mode if binlog_format=mixed |
48703 | 2009-11-11 21:58 | 2022-09-04 20:45 | MySQL Server: Optimizer | In progress (5065 days) | S3 | 5.0+ | Any | Any | nontrivial ORDER/GROUP BY expressions: ambiguous statements not detected |
59882 | 2011-02-02 7:28 | 2011-11-16 16:54 | MySQL Workbench: SQL Editor | Closed (4538 days) | S3 | 5.2.31 | Any | Any | Not correct change trigger script |
96205 | 2019-07-15 9:05 | 2019-07-15 15:11 | MySQL Server: InnoDB storage engine | Not a Bug (1740 days) | S3 | Any | Any | not in expect, two versions row datas in a some transaction | |
9098 | 2005-03-10 18:39 | 2012-05-18 20:19 | MySQL Server: C API (client library) | No Feedback (5648 days) | S3 | 4.1.10 | Any | Any | Not possible for clients to distinguish between string default values and other |
72921 | 2014-06-09 17:10 | 2014-06-25 15:27 | MySQL Server: Errors | Verified (3601 days) | S4 | 5.5+ | Any | Any | note 1592: unsafe statement...on duplicate key update issued for safe statements |
114396 | 2024-03-19 2:54 | 2024-03-19 5:53 | MySQL Server: Partitions | Verified (31 days) | S2 | 8.0.22, 8.0.35, 8.0.36 | Any | Any | NULL is not treated as 0 for tables partitioned by key |
79792 | 2015-12-29 3:12 | 2019-12-02 22:41 | MySQL Server: DML | Closed (1600 days) | S3 | 5.0/5.1/5.5/5.6/5.7 | Any | Any | NULL value is inserted explicitly into NOT NULL column unexpected |
73370 | 2014-07-24 7:34 | 2014-08-27 18:12 | Connector / Python | Closed (3523 days) | S3 | 1.2.2 | Any | Any | NULL values not working with prepared statements in CPY |
78958 | 2015-10-26 2:37 | 2019-11-27 22:13 | MySQL Server: DML | Closed (1605 days) | S3 | 5.7.8, 5.6.27, 5.7.10 | Any | Any | NULL=ANY( subquery ) returns 0 |
27205 | 2007-03-16 10:47 | 2007-04-30 8:45 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6199 days) | S3 | 5.1 | Any | Any | Occasional 899 if delete+insert during LCP |
6026 | 2004-10-11 13:03 | 2010-12-02 20:33 | Connector / ODBC | Closed (6752 days) | S3 | Any | Any | ODBC TIME type error when inserting 01:00:00 | |
54271 | 2010-06-07 0:48 | 2011-02-16 23:44 | MySQL Workbench: Modeling | No Feedback (5035 days) | S3 | 5.2.11 OSS Beta | Any | Any | Omit schema qualifiers does not omit schema for INSERT statements |
8736 | 2005-02-23 17:31 | 2005-02-23 21:51 | MySQL Server | Closed (6995 days) | S3 | 4.1.10 | Any (*) | Any | on duplicate key update allows/ignores updates to read table |
104211 | 2021-07-05 20:54 | 2021-07-08 11:35 | MySQL Server: Parser | Not a Bug (1017 days) | S3 | 8.0.x | Any | Any | ON DUPLICATE KEY UPDATE and table alias for new VALUES function replacement |
46675 | 2009-08-12 13:35 | 2011-08-19 15:15 | MySQL Server: General | Closed (4627 days) | S3 | server 5.1.37 | Any (MS Windows, Mac, Linux) | Any | ON DUPLICATE KEY UPDATE and updateCount() possibly wrong |
61213 | 2011-05-18 9:49 | 2014-06-10 7:08 | Connector / J | Closed (3620 days) | S2 | 5.1.16 | Any | Any | ON DUPLICATE KEY UPDATE breaks generated key list when extended INSERT is used |
30146 | 2007-07-31 12:59 | 2007-07-31 13:10 | MySQL Server: General | Closed (6107 days) | S3 | 5.0.42-enterprise-gpl | Any | Any | on duplicate key update does insert and update at the same time |
27650 | 2007-04-04 13:24 | 2007-05-01 17:45 | MySQL Server | Closed (6198 days) | S1 | 5.0.38, 5.x | Any | Any | ON DUPLICATE KEY UPDATE fails when setting UNIQUE values with multi row inserts |
64025 | 2012-01-13 14:21 | 2012-01-15 19:15 | MySQL Server: DML | Verified (4480 days) | S3 | 5.1.61, 5.5.15 | Any | Any | ON DUPLICATE KEY UPDATE sets auto_increment column value to 0 |
65678 | 2012-06-19 21:56 | 2012-06-30 10:09 | Connector / Python | Closed (4311 days) | S3 | 0.3.2-dev | Any | Any | On duplicate key UPDATE VALUE fails regex |
46997 | 2009-08-29 22:19 | 2009-09-04 9:14 | MySQL Server: DML | Not a Bug (5341 days) | S2 | 5.1.31-community, 4.1, 5.0, 5.1, next bzr | Any (MS Windows, Linux) | Any | ON DUPLICATE UPDATE does not react on change in one field |
10409 | 2005-05-06 11:47 | 2005-07-04 10:17 | MySQL Server: InnoDB storage engine | Closed (6864 days) | S3 | 5.0.6-bk | Any (all) | Any | ON UPDATE CASCADE does not enforce maximum length of UTF-8 data |
15131 | 2005-11-22 11:44 | 2011-02-16 23:43 | MySQL Server: Optimizer | Verified (5498 days) | S4 | 4.1,5.0 | Any | Any | On-disk temporary tables created for GROUP BY should use indexes |
54642 | 2010-06-20 10:35 | 2010-08-23 7:59 | MySQL Server: InnoDB storage engine | Not a Bug (5021 days) | S1 | mysql-5.1.46 | Any (Windows XP) | Any | One query killing another query. |
4380 | 2004-07-02 14:26 | 2004-08-01 17:00 | MySQL Server: Replication | Not a Bug (7201 days) | S2 | 4.0 | Any (all) | Any | One-row INSERT/UPDATE/DELETE needn't be binlogged as 'killed' |
41466 | 2008-12-15 11:14 | 2011-02-16 23:43 | MySQL Cluster: Replication | Closed (5599 days) | S3 | cluster 6.4 | Any | Any | online add partition with replication looses data |
79462 | 2015-11-30 19:17 | 2017-12-27 8:14 | MySQL Cluster: Cluster (NDB) storage engine | Verified (3059 days) | S3 | ndb-7.3.7, 7.3.12 | Any | Any | ONLINE ALTER table holds metadata lock preventing local DML |
33019 | 2007-12-05 21:27 | 2010-02-20 19:29 | MySQL Server: Backup | Closed (5172 days) | S3 | 6.0 | Any | Any | Online backup process can consume too much processor time |
47484 | 2009-09-21 15:01 | 2010-03-07 19:40 | MySQL Server: Backup | Closed (5157 days) | S3 | 5.4.4 | Any | Any | Online Backup: Restore does not set the auto_increment value correctly |
67500 | 2012-11-07 9:25 | 2012-11-07 9:34 | MySQL Server: InnoDB storage engine | Duplicate (4181 days) | S1 | 5.6 | Any | Any | Online DDL create unique index is incorrect |
113783 | 2024-01-28 12:50 | 2024-01-30 10:58 | MySQL Server: Optimizer | Not a Bug (80 days) | S4 | 8.0 | Any | Any | only_full_group_by option does not take effect |
15189 | 2005-11-23 15:59 | 2011-02-16 23:43 | MySQL Server: DML | Verified (6722 days) | S4 | 5.0.17-BK | Any | Any | Optimise INSERT ... ON DUPLICATE KEY ... for identical column values |
61456 | 2011-06-09 7:40 | 2012-10-18 22:40 | MySQL Server: InnoDB Plugin storage engine | Closed (4201 days) | S5 | 5.1.52 | Any | Any | Optimistic Insert/Update uses wrong heuristics for compressed page size |
109260 | 2022-12-01 12:20 | 2023-01-03 12:51 | MySQL Server: InnoDB storage engine | Can't repeat (472 days) | S5 | 8.0.31 | Any | Any | optimize for innodb recovery |
110068 | 2023-02-15 5:13 | 2023-02-15 6:05 | MySQL Server: InnoDB storage engine | Verified (429 days) | S5 | 8.0.31 | Any | Any | optimize for innodb recovery |
114074 | 2024-02-21 8:35 | 2024-02-27 14:20 | MySQL Server: Replication | Verified (58 days) | S5 | 8.0.32 | Any | Any | optimize for Writeset_trx_dependency_tracker::get_dependency |
58551 | 2010-11-29 9:33 | 2011-02-16 23:44 | MySQL Server: Documentation | Closed (4881 days) | S5 | 5.0, 5.1, (probably All) | Any | Any | Optimize table after load or insert into ... select gives 25% speed increase |
98600 | 2020-02-14 11:48 | 2021-12-21 7:40 | MySQL Server: DML | Verified (1526 days) | S3 | 5.7,8.0, 5.7.29, 8.0.19 | Any | Any | Optimize table fails with duplicate entry on UNIQUE KEY |
77673 | 2015-07-09 18:30 | 2017-11-16 7:49 | MySQL Server: Replication | Closed (2346 days) | S2 | 5.1.73, 5.5.44, 5.6.24, 5.6.27, 5.5.46, 5.7.7-rc | Any | Any | Option "replicate_do_db" does not cause "create table" to replicate ('row' log) |
75303 | 2014-12-24 3:04 | 2015-11-19 17:52 | MySQL Server: Security: Encryption | Verified (3074 days) | S4 | Any | Any | Option in hash functions for binary output | |
11478 | 2005-06-21 11:02 | 2022-09-04 20:45 | MySQL Server | Duplicate (6874 days) | S3 | 4.0 | Any (any) | Any | option new doesn't work as expected in 4.0 |
55824 | 2010-08-08 16:40 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Duplicate (4873 days) | S3 | 5.1+ | Any | Any | Option or compatibility mode for mysqldump to NOT quote decimal values |
36852 | 2008-05-21 13:28 | 2017-05-21 20:45 | MySQL Server: Replication | Verified (5812 days) | S4 | any | Any | Any | Option to strip LOW_PRIORITY for replication |
33774 | 2008-01-09 16:06 | 2008-01-10 13:18 | MySQL Server: Stored Routines | Not a Bug (5944 days) | S1 | Any | Any | oracle details i am using | |
81940 | 2016-06-21 3:31 | 2019-12-24 13:28 | MySQL Server: DML | Closed (1578 days) | S3 | 5.7.8, 5.5.50, 5.6.31,5.7.13 | Any | Any | Order by substr() returns incorrect result |
38858 | 2008-08-18 13:56 | 2022-12-04 20:45 | MySQL Server: Parser | Verified (5722 days) | S4 | Any | Any | ORDERGROUP BY construct | |
45292 | 2009-06-03 9:58 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5149 days) | S2 | mysql-5.1-telco-7.0 | Any | Any | orphan binary log created when starting server twice |
79567 | 2015-12-09 7:41 | 2019-11-28 22:55 | MySQL Server: DML | Closed (1604 days) | S3 | 5.7.8, 5.5.48, 5.6.29, 5.7.9 | Any | Any | Output scale for IFNULL() with join is not correct |
29146 | 2007-06-15 19:08 | 2016-02-25 12:24 | MySQL Server: Command-line Clients | Not a Bug (5889 days) | S3 | 5.0.41 | Any | Any | Output truncated when resultset contains \r |
49533 | 2009-12-08 13:08 | 2017-05-21 20:45 | MySQL Server: Replication | Verified (5246 days) | S3 | 5.1,mysql-5.1-rep+3,mysql-6.0-codebase-b | Any | Any | Overflow in DECIMAL, SBR out of sync |
93089 | 2018-11-06 3:37 | 2018-11-07 7:45 | MySQL Server: Replication | Can't repeat (1990 days) | S2 | 5.7 | Any | Any | parallel workers+slave_preserve_commit_order+flushtables with read lock deadlock |
93572 | 2018-12-12 11:37 | 2022-11-04 13:54 | MySQL Server: Locking | Won't fix (532 days) | S3 | 5.7.18 | Any | Any | parallel workers+slave_preserve_commit_order+flushtables with read lock deadlock |
105162 | 2021-10-07 7:55 | 2021-10-07 12:51 | MySQL Server | Not a Bug (925 days) | S4 | Any | Any | Parameter columns/fields that can also be calculated fields | |
20340 | 2006-06-08 12:58 | 2006-07-26 0:44 | MySQL Server: Partitions | Closed (6477 days) | S3 | 5.1.12-BK, 5.1.11 | Any (all) | Any | Paritioning does not obey to column type |
36570 | 2008-05-07 16:36 | 2008-05-24 17:39 | MySQL Server: Replication | Closed (5809 days) | S3 | 5.0.60 | Any | Any | Parse error of CREATE PROCEDURE stmt with comments on slave |
45361 | 2009-06-07 21:58 | 2009-06-11 19:19 | MySQL Server: Parser | Not a Bug (5426 days) | S3 | any | Any | Any | parser behaves too primitive here! |
112912 | 2023-11-01 8:45 | 2023-11-01 14:47 | MySQL Server: Optimizer | Verified (170 days) | S3 | 8.0 | Any | Any | Parsing a string To BIT type got a wrong result |
53421 | 2010-05-04 20:28 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5029 days) | S2 | 5.5.5-m3, 5.6.99-m4 | Any | Any | Part of transaction not written in binlog after deadlock, replication breaks |
20732 | 2006-06-27 20:48 | 2006-11-13 18:55 | MySQL Server | Closed (6367 days) | S3 | 4.1 | Any (all) | Any | Partial index and long sjis search with '>' fails sometimes |
31321 | 2007-10-01 17:00 | 2007-12-06 17:31 | MySQL Server: Documentation | Closed (5979 days) | S3 | 5.1, 6.0 | Any | Any | Partial transaction results with INSERT ... SELECT and cluster replication |
85821 | 2017-04-06 7:11 | 2020-12-01 11:51 | MySQL Server: Optimizer | Closed (1235 days) | S3 | 8.0.2-DEBUG | Any | Any | partial update on views does not work |
92114 | 2018-08-22 1:22 | 2021-06-10 4:05 | MySQL Server: JSON | Closed (1044 days) | S3 | 8.0.12 | Any | Any | Partial Updates of JSON Values |
54866 | 2010-06-28 17:53 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (4977 days) | S3 | 5.1, 5.5 | Any | Any | Partially failed REVOKE not binlogged, causes inconsistency or replication abort |
60173 | 2011-02-18 20:54 | 2013-05-30 19:33 | MySQL Server: Replication | Closed (3977 days) | S2 | 5.1.47, 5.1.64, 5.5.27 | Any | Any | Partially written insert statement in binlog -- no errors reported |
47753 | 2009-09-30 20:24 | 2022-12-04 20:45 | MySQL Server: Partitions | Duplicate (5294 days) | S3 | 5.5 WL#3352 | Any | Any | Partition by LIST COLUMN_LIST appears to require an order for value list items |
47752 | 2009-09-30 17:56 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5272 days) | S3 | 5.5 WL#3352 | Any | Any | Partition by LIST COLUMN_LIST only recognizing last defined partition |
84362 | 2016-12-28 17:11 | 2016-12-28 17:52 | MySQL Server: Partitions | Verified (2669 days) | S3 | 5.6, 5.7,8.0 | Any | Any | PARTITION BY LIST COLUMNS allows unsupported data types |
30648 | 2007-08-27 17:47 | 2007-08-31 13:48 | MySQL Server: Partitions | Closed (6076 days) | S3 | 5.1 | Any | Any | Partition handler may not initialize variable used w/ autoincrement |
40972 | 2008-11-24 10:54 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5568 days) | S1 | 5.1+ | Any | Any | Partition pruning can lead to crash for bad dates |
104576 | 2021-08-10 4:18 | 2023-12-20 6:36 | MySQL Server: Partitions | Closed (924 days) | S5 | 8.0.26, 5.7.35 | Any | Any | partition table access second index lead to cpu high load |
104881 | 2021-09-09 8:25 | 2021-09-15 8:46 | MySQL Server: Partitions | Verified (953 days) | S3 | 8.0.26, 5.7.35 | Any | Any | partition_info::set_used_partition not raise error when finding no partition |
37252 | 2008-06-06 19:56 | 2015-02-06 19:01 | MySQL Server: Partitions | Closed (4328 days) | S3 | 5.1, 6.0 | Any | Any | Partitioning performance drops drastically with hundreds of partitions |
48166 | 2009-10-19 18:28 | 2011-02-16 23:44 | MySQL Server: Partitions | Won't fix (5209 days) | S3 | 5.1+ | Any | Any | Partitions: error message refers to value after function completion |
78638 | 2015-09-30 8:03 | 2016-06-18 21:28 | MySQL Server: Partitions | Closed (3070 days) | S3 | 8.0.0-m17 | Any | Any | parts.partition_alter2_1_1_innodb run into assertion |
59830 | 2011-01-31 5:42 | 2011-06-30 14:57 | Tests: Server | Closed (4677 days) | S3 | mysql-trunk | Any | Any | parts.partition_debug_innodb failing due to case difference on windows |
47477 | 2009-09-21 10:13 | 2011-02-16 23:44 | Tests: Replication | Can't repeat (5191 days) | S3 | Any | Any | PB2: rpl_start_stop_slave failures | |
40440 | 2008-10-30 17:34 | 2011-02-16 23:43 | Connector / J | Closed (5446 days) | S5 | 5.1.7 | Any | Any | Performance bottleneck using batched statements |
103055 | 2021-03-22 6:37 | 2021-03-23 13:18 | MySQL Server: InnoDB storage engine | Not a Bug (1123 days) | S5 | 8.0.23 | Any | Any | Performance degradation when too many tables |
77783 | 2015-07-20 7:01 | 2019-10-25 12:00 | MySQL Server: InnoDB storage engine | Can't repeat (1638 days) | S5 | 5.7, 5.6 | Any | Any | performance dropped when changing innodb_change_buffering from inserts to all |
15014 | 2005-11-17 12:51 | 2006-02-02 13:58 | MySQL Server: Stored Routines | Closed (6651 days) | S2 | 5.0 | Any (Any) | Any | Performance problems with functions |
69368 | 2013-05-31 20:36 | 2013-10-11 16:23 | MySQL Server: DML | Closed (3843 days) | S5 | 5.6.6 | Any | Any | performance regression in 5.6.6+ for insert into .... select ... from |
85933 | 2017-04-13 13:25 | 2023-11-02 6:30 | MySQL Server: Optimizer | Closed (2396 days) | S5 | 8.0.1-dmr | Any | Any | Performance regression with Prepared Statements |
58620 | 2010-12-01 6:27 | 2011-02-16 23:44 | MySQL Server: Performance Schema | Closed (4878 days) | S3 | 5.6 | Any | Any | Performance schema failed assert, pfs_instr_class.cc, line 956 |
73504 | 2014-08-08 0:51 | 2014-12-10 12:49 | MySQL Server: Performance Schema | Closed (3479 days) | S3 | 5.6 | Any | Any | performance_schema digests do not handle negative numbers well |
79658 | 2015-12-16 8:49 | 2015-12-24 7:18 | MySQL Server: Performance Schema | Not a Bug (3039 days) | S3 | 5.7.10 | Any | Any | performance_schema statements by thread limited instrumentation |
69318 | 2013-05-25 16:27 | 2013-07-03 14:09 | MySQL Server: Documentation | Closed (3943 days) | S3 | 5.6 | Any | Any | performance_schema_max_thread_instances documentation tweak |
98545 | 2020-02-10 23:45 | 2022-05-02 7:22 | MySQL Server: Performance Schema | Closed (718 days) | S3 | 8.0.19 | Any | Any | Perfschema tables are not collation aware |
39008 | 2008-08-25 13:43 | 2018-09-25 21:49 | Tests | Closed (5558 days) | S7 | 5.1-rpl | Any | Any | perl warning in mtr: 'use of uninitialized value in concatenation' in mtr:3995 |
99027 | 2020-03-23 4:09 | 2020-03-26 13:42 | MySQL Server | Not a Bug (1485 days) | S3 | Any | Any | PITR with unknown error: 1105 | |
25194 | 2006-12-20 3:55 | 2013-03-03 20:45 | MySQL Server: Federated storage engine | Verified (5006 days) | S4 | 5.1, 5.5 | Any (*) | Any | please implement bulk inserts for federated table |
62653 | 2011-10-07 16:13 | 2011-10-31 17:36 | Connector / NET | Closed (4554 days) | S5 | 6.4.4 | Any | Any | Poor performance when adding parameters to MysqlCommand |
38725 | 2008-08-11 16:48 | 2011-02-16 23:43 | MySQL Enterprise Monitor: Documentation | Closed (5636 days) | S3 | 2.0.0.7017 | Any | Any | possible addition to the MEM2 docs |
58212 | 2010-11-15 21:20 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Closed (4832 days) | S3 | 5.5+ | Any | Any | Possible deadlock in change buffer in debug builds |
59733 | 2011-01-26 7:32 | 2011-10-07 20:59 | MySQL Server: InnoDB storage engine | Closed (4578 days) | S2 | 3.23.53,4.0,4.1,5.0,5.1,5.5 | Any | Any | Possible deadlock when buffered changes are to be discarded in buf_page_create() |
61361 | 2011-05-31 10:59 | 2023-06-16 3:06 | MySQL Server | Not a Bug (4570 days) | S3 | 5.5.9 | Any | Any | Possible of duplicated primary key by enum type |
35005 | 2008-03-03 16:20 | 2011-02-16 23:43 | MySQL Server: Security: Privileges | Can't repeat (5033 days) | S3 | 5.1 | Any | Any | Possible security flaw around trigger privileges |
61208 | 2011-05-17 21:41 | 2012-10-18 23:09 | MySQL Server: InnoDB Plugin storage engine | Closed (4201 days) | S3 | 5.1.52 | Any | Any | Possibly invalid assertion in btr_cur_pessimistic_update() inside btr0cur.c |
101889 | 2020-12-07 9:45 | 2020-12-07 11:43 | MySQL Server: DML | Can't repeat (1229 days) | S3 | 8.0 | Any | Any | Potentially wrong results |
112703 | 2023-10-12 12:13 | 2023-10-12 12:56 | MySQL Server: Prepared statements | Verified (190 days) | S3 | Any | Any | prepare statment has no warning comping to not prepare statment. | |
103458 | 2021-04-23 15:22 | 2021-06-28 11:41 | MySQL Server: Prepared statements | Closed (1033 days) | S3 | 8.0 | Any | Any | PREPARE type checking error |
71526 | 2014-01-30 13:10 | 2014-03-01 1:00 | MySQL Server: Prepared statements | No Feedback (3703 days) | S3 | 5.6 | Any | Any | prepared statement fail on table_open_cache even when is autosize |
23929 | 2006-11-03 10:15 | 2007-08-06 14:27 | MySQL Server: Prepared statements | Won't fix (6101 days) | S3 | 4.1.23 | Any | Any | prepared statement INSERT into char field, bound to MYSQL_TYPE_LONG = bad data |
67676 | 2012-11-22 6:37 | 2014-07-14 12:23 | MySQL Server: Prepared statements | Closed (4043 days) | S2 | 5.6.7 | Any | Any | prepared statement is very slow while binlog was enabled |
11589 | 2005-06-27 12:29 | 2007-10-25 0:02 | MySQL Server: Prepared statements | Closed (6021 days) | S3 | 4.1 | Any | Any | prepared statements - strange output, float/double/real with zerofill |
73056 | 2014-06-19 21:34 | 2018-03-15 14:17 | MySQL Server: Prepared statements | Closed (2961 days) | S5 | 5.7, 5.7.8 | Any | Any | Prepared Statements ABSURDLY SLOW due to inefficient query creation for logging |
6415 | 2004-11-03 21:27 | 2004-11-04 18:09 | MySQL Server: Documentation | Closed (7106 days) | S3 | 4.1 | Any (any) | Any | prepared statements documentation doesn't list what queries are preparable |
40365 | 2008-10-28 7:55 | 2011-02-16 23:43 | MySQL Server: Data Types | Closed (5611 days) | S3 | any | Any | Any | Prepared statements may insert invalid dates. |
36002 | 2008-04-11 18:21 | 2012-01-27 4:14 | MySQL Server: Prepared statements | Closed (4466 days) | S3 | 5.0,5.1,6.0 BK | Any | Any | Prepared statements: if a view used in a statement is replaced, bad data |
78099 | 2015-08-17 6:42 | 2015-08-17 7:53 | Connector / J | Closed (3168 days) | S3 | 5.1.36 | Any | Any | preparedStatement.executeBatch() return -2. |
29979 | 2007-07-23 15:56 | 2007-07-23 16:43 | MySQL Server | Duplicate (6115 days) | S1 | 5.0.6, 5.0.7 | Any | Any | PreparedStatement.executeUpdate returns wrong rowcount for an insert statement. |
104753 | 2021-08-27 14:57 | 2022-09-27 22:21 | Connector / J | Closed (570 days) | S3 | 8.0.26 | Any | Any | PreparedStatement.setFetchSize(0) causes ArrayIndexOutOfBoundsException |
58392 | 2010-11-22 16:31 | 2022-12-04 20:45 | MySQL Server: DDL | Verified | S4 | 5.5+ | Any | Any | Prevent TEMPORARY tables from shadowing regular tables |
94582 | 2019-03-06 21:06 | 2019-03-06 22:10 | MySQL Server: DML | Closed (1871 days) | S3 | 8.0.12 | Any | Any | Primary key 1 causes ON DUPLICATE KEY UPDATE to use erroneous value |
3985 | 2004-06-03 16:26 | 2005-12-13 16:23 | MySQL Server | Duplicate (6702 days) | S4 | 4.0 | Any (any) | Any | privilege for INSERT, UPDATE, DELETE, DROP, CREATE TEMPORARY TABLES |
32826 | 2007-11-28 19:58 | 2007-11-30 15:58 | MySQL Server: Security: Privileges | Duplicate (5985 days) | S3 | 6.0.4-alpha-debug | Any | Any | Privileges: I can CREATE ... LIKE without SELECT privilege |
33504 | 2007-12-24 20:27 | 2012-09-13 11:02 | Connector / NET | No Feedback (5921 days) | S1 | 5.1.4 | Any | Any | Problem accesing Datareader with MySQL .NET Connector 5.1.4 |
28650 | 2007-05-24 11:09 | 2007-06-24 12:29 | MySQL Server: Stored Routines | No Feedback (6144 days) | S3 | 5.0 | Any | Any | problem facing with triggers |
37791 | 2008-07-02 3:23 | 2008-07-06 12:14 | MySQL Server: InnoDB storage engine | Duplicate (5766 days) | S2 | 5.0.27 | Any | Any | Problem in innodb transaction |
663 | 2003-06-17 13:25 | 2003-07-22 8:10 | MySQL Server | Closed (7577 days) | S3 | all | Any (all) | Any | Problem resulting from zeros in autoincrement fields |
28861 | 2007-06-04 5:51 | 2013-03-03 20:45 | MySQL Server: FULLTEXT search | Duplicate (6155 days) | S3 | 4.1, 5.0, 5.1 | Any (Linux, Windows XPProfessional) | Any | Problem With full text search and some characters in boolean mode i want to igno |
15874 | 2005-12-19 23:23 | 2014-02-21 17:56 | MySQL Server | Unsupported (3710 days) | S5 | 5.0.17, the latest bk | Any (All) | Any | Problem with intensive locking (deadlocks?) during execution of system_1 test |
27722 | 2007-04-09 21:01 | 2007-04-20 15:01 | MySQL Server: Falcon storage engine | Closed (6209 days) | S2 | 5.2.4-pb475 | Any | Any | Problem with update conflict resolution |
35767 | 2008-04-02 10:55 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (4899 days) | S1 | 6.0.5pre | Any | Any | Processing of uncorrelated subquery with semi-join cause wrong result and crash |
69944 | 2013-08-07 6:16 | 2014-03-06 13:20 | MySQL Server: Replication | Verified (3697 days) | S4 | All Versions | Any | Any | Processlist shows Second Behind Master instead of Query time for Replication |
4513 | 2004-07-12 13:03 | 2011-02-16 23:42 | Connector / J | Closed (5617 days) | S4 | any | Any (any) | Any | Programmatic access to the LOAD DATA LOCAL stream in a Java way |
81852 | 2016-06-15 5:56 | 2016-06-15 8:25 | MySQL Server | Open (2865 days) | S4 | 5.6.27 | Any | Any | Provide option to not allow client access during InnoDB recovery |
30661 | 2007-08-28 2:05 | 2007-08-28 16:06 | MySQL Enterprise Monitor: Server | Not a Bug (6079 days) | S2 | 1.2.0.7296 | Any | Any | Purging data can cause deadlocks |
28241 | 2007-05-04 13:51 | 2022-12-04 20:45 | MySQL Server | Verified (6183 days) | S4 | 5.0.42,5.1BK | Any | Any | QCache stores dublicates |
113384 | 2023-12-09 8:05 | 2023-12-11 11:42 | MySQL Server: Data Types | Verified (130 days) | S3 | 8.0 | Any | Any | Queried with partitions,returned result is error |
23311 | 2006-10-15 22:28 | 2012-05-18 20:19 | MySQL Server: Stored Routines | Duplicate (6371 days) | S2 | 5.0.24a | Any (Any) | Any | Queries within triggers give unexpected results |
110040 | 2023-02-13 8:28 | 2023-02-13 14:00 | MySQL Server: Optimizer | Not a Bug (431 days) | S2 | 8.0.22+ | Any | Any | query bin() function by order by desc return incorrect result set |
12385 | 2005-08-04 14:27 | 2005-08-16 3:53 | MySQL Server: MyISAM storage engine | Closed (6821 days) | S2 | 4.0 | Any (*) | Any | Query Cache and READ LOCAL locks can cause bad results from query |
44359 | 2009-04-20 6:44 | 2011-02-16 23:43 | MySQL Server: Query Cache | No Feedback (5331 days) | S2 | 5.1.33 | Any | Any | Query cache gets fragmented when the query cache gets full |
50065 | 2010-01-04 22:59 | 2012-07-29 23:08 | MySQL Server: Query Cache | Closed (4282 days) | S4 | 5.0.89, 5.1.37, 5.5-mr2 | Any | Any | query cache invalidated in insert...select if no rows inserted |
30256 | 2007-08-06 14:27 | 2007-08-06 15:15 | MySQL Server | Can't repeat (6101 days) | S2 | 5.0.45 | Any | Any | Query cache not emptied after a INSERT ... ON DUPLICATE KEY UPDATE |
41098 | 2008-11-28 14:33 | 2011-02-16 23:43 | MySQL Server: Query Cache | Closed (5511 days) | S3 | 5.1,6.0 | Any | Any | Query Cache returns wrong result with concurrent insert |
28249 | 2007-05-04 16:01 | 2007-07-23 20:23 | MySQL Server | Closed (6115 days) | S2 | 5.0.42/5,1 | Any | Any | Query Cache returns wrong result with concurrent insert / certain lock |
55032 | 2010-07-06 16:52 | 2017-07-07 9:45 | MySQL Server: Query Cache | Won't fix (2478 days) | S3 | All versions (5.1.x, 5.5.x) | Any | Any | Query cache sometime insert queries to cache, but doenn't find this queries. |
14400 | 2005-10-27 16:15 | 2006-09-22 15:27 | MySQL Server: MyISAM storage engine | Closed (6419 days) | S2 | 3.23, 4.0, 4.1, 5.0 | Any (any) | Any | Query joins wrong rows from table which is subject of "concurrent insert" |
106980 | 2022-04-11 12:43 | 2022-04-20 10:23 | MySQL Server: Data Types | Not a Bug (731 days) | S3 | 5.7 | Any | Any | Query parsed as UPDATE calculates a different value from same query as INSERT |
111067 | 2023-05-18 8:05 | 2023-05-19 12:55 | MySQL Server: Optimizer | Verified (337 days) | S2 | 8.0.25, 8.0.33 | Any | Any | Query result error |
101059 | 2020-10-06 2:47 | 2020-10-06 5:26 | MySQL Server: Optimizer | Verified (1291 days) | S3 | 8.0.19, 8.0.21, 5.7.31, 5.6.49 | Any | x86 | Query result inconsistent for the year type in NOT IN expression |
106924 | 2022-04-06 8:12 | 2022-04-06 12:07 | MySQL Server: DML | Not a Bug (744 days) | S3 | 8.0.27 | Any (rhel-7.4) | Any (x86-64) | Query result is incorrect if there is a condition compares char field with 0 |
96647 | 2019-08-26 6:21 | 2019-08-26 7:38 | MySQL Server: Optimizer | Verified (1698 days) | S3 | 5.7.22, 5.7.27, 8.0.17 | Any | Any | Query Rewrite plugin database_pattern column length is too shot |
74813 | 2014-11-12 9:41 | 2015-04-06 18:49 | MySQL Server: Optimizer | Closed (3381 days) | S3 | 5.7.6 | Any | Any | QUERY REWRITE: NULL IS NOT RECOGNIZED BY THE PLUGIN AS A LITERAL |
94077 | 2019-01-27 6:29 | 2019-02-05 17:15 | MySQL Server: Information schema | Can't repeat (1900 days) | S5 | 8.0.13 | Any | Any | Query to get processes from processlist is choking mysql to 30% speed |
78464 | 2015-09-17 7:30 | 2016-02-08 12:55 | MySQL Server: JSON | Closed (3094 days) | S3 | 5.7.10 | Any | Any | Query using JSON_EXTRACT() returns wrong result after adding virtual index |
3833 | 2004-05-20 4:14 | 2004-06-01 0:43 | MySQLCC | Closed (7262 days) | S2 | 0.94beta | Any (all) | Any | Query Window's default_table corrupted |
2188 | 2003-12-22 8:22 | 2004-01-20 11:04 | MySQL Server | Closed (7395 days) | S2 | 4.1, 5.0 | Any (all) | Any | Query with select in field list doesn't work with prepared statements |
42376 | 2009-01-27 14:51 | 2009-01-30 9:36 | Connectors: DBD::mysql ( Perl ) | Not a Bug (5558 days) | S3 | 4.010 | Any | Any | Query with SQL variables behaves different on DBI than on CLI |
110349 | 2023-03-13 9:14 | 2023-03-27 9:42 | Connector / ODBC | Patch queued (389 days) | S3 | 8.0.32 | Any | Any | Querying mysql through otl's odbc means that the results obtained in the Chinese |
61191 | 2011-05-16 20:53 | 2012-01-10 3:52 | MySQL Server: InnoDB Plugin storage engine | Closed (4483 days) | S3 | 5.1.52 | Any | Any | question about page_zip_available |
59019 | 2010-12-18 1:25 | 2011-01-04 11:09 | MySQL Server | Not a Bug (4854 days) | S3 | 5.1.52, 5.1, 5.6.1 bzr | Any | Any | question about rentrant use of LOCK_logger |
94777 | 2019-03-26 8:14 | 2019-04-23 13:12 | MySQL Server: InnoDB storage engine | Not a Bug (1841 days) | S5 | 8.0.14 | Any | Any | Question about the redo log write_ahead_buffer |
110672 | 2023-04-12 21:23 | 2023-04-18 16:02 | MySQL Server: DML | Closed (367 days) | S2 | 8.0.32 | Any | Any | QUOTE function doesn't work as expected on tables that are utf16 |
110594 | 2023-04-03 11:28 | 2023-04-05 7:20 | MySQL Server: XA transactions | Verified (380 days) | S2 | 8.0.32 | Any | Any | Race condition between xa recover and xa start on Transaction_ctx object |
54122 | 2010-06-01 3:23 | 2018-09-25 21:51 | Tests: Replication | Closed (4732 days) | S7 | 5.6.1 | Any | Any | Race condition in mysqlbinlog_raw_mode |
61009 | 2011-04-29 16:21 | 2011-05-29 23:00 | MySQL Utilities | No Feedback (4709 days) | S2 | 5.5.11 | Any (did not work) | Any | Ran a create database and nothing happened just this error |
66530 | 2012-08-24 15:34 | 2012-08-30 16:16 | MySQL Server: Documentation | Closed (4250 days) | S3 | 5.1.66, 5.5.27 | Any | Any | RAND() not mentioned as unsafe for replication in 5.5 |
6172 | 2004-10-20 8:50 | 2007-02-12 18:43 | MySQL Server | Closed (6276 days) | S3 | All | Any (All) | Any | RAND(a) should only accept constant values as arguments. |
105675 | 2021-11-23 10:33 | 2022-05-18 2:45 | MySQL Server | Unsupported (702 days) | S3 | 5.7.35 | Any | Any | Random error "Errcode: 13 - Permission denied" occured when creating an index |
39931 | 2008-10-08 13:29 | 2011-02-16 23:43 | Tests: Replication | Closed (5561 days) | S3 | 5.0 | Any | Any | random failures of rpl.rpl_temporary |
32566 | 2007-11-21 11:32 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (5986 days) | S3 | 5.1 | Any | Any | Range partitioning: Insert of maximum value should fail LESS THAN (numeric max) |
34260 | 2008-02-03 12:59 | 2008-02-20 21:50 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5903 days) | S3 | 5.1 | Any | Any | Rare race condition between aborted insert + scan delete can cause node crash |
47442 | 2009-09-18 14:06 | 2011-02-16 23:44 | MySQL Server: Row Based Replication ( RBR ) | Closed (4978 days) | S3 | 5.1,5.4 | Any | Any | RBR breaks on CREATE TABLE IF EXISTS <existing VIEW> AS SELECT |
55625 | 2010-07-29 12:25 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (4904 days) | S3 | 5.1.49 | Any | Any | RBR breaks on failing 'CREATE TABLE' |
61556 | 2011-06-17 21:58 | 2011-07-20 11:02 | MySQL Server: Documentation | Closed (4657 days) | S3 | 5.1,5.5 | Any | Any | RBR should use TL_WRITE_CONCURRENT_INSERT |
47103 | 2009-09-03 15:57 | 2011-02-16 23:44 | MySQL Server: Row Based Replication ( RBR ) | Closed (5284 days) | S3 | 5.4 | Any | Any | RBR slave crash in table_def::type when modifying a merge table |
36118 | 2008-04-16 8:39 | 2008-05-09 15:31 | MySQL Server: Replication | Closed (5824 days) | S2 | 5.1, 6.0 | Any | Any | RBR used for mysql database tables |
51501 | 2010-02-25 12:44 | 2016-10-16 20:45 | MySQL Server: Row Based Replication ( RBR ) | Duplicate (4995 days) | S3 | 5.1.37, 5.1.44, 5.1.45,5.5.99-m3 | Any | Any | RBR, slave stops with HA_ERR_KEY_NOT_FOUND |
« Show Previous 1000 Entries | Showing 1001-2000 of 2775 (Edit, Save, CSV, Feed) | Show Next 1000 Entries » |