Showing 1-1000 of 2772 (Edit, Save, CSV, Feed) | Show Next 1000 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
113447 | 2023-12-18 7:54 | 2023-12-18 13:52 | MySQL Server: DML | Not a Bug (102 days) | S3 | MySQL 8.0 | Any | Any | INET6_ATON giving Incorrect integer value for MySQL 8.0 |
113535 | 2024-01-02 9:58 | 2024-01-08 13:31 | MySQL Server: DDL | Can't repeat (81 days) | S3 | 8.0.35 | Any | Any | Drop table in background list will remain file exists in directory |
113557 | 2024-01-04 15:29 | 2024-01-04 15:40 | MySQL Server: JSON | Verified (85 days) | S2 | 8.0.35 | Any | Any | Wrong query result on composite multi-valued index + empty array value |
113595 | 2024-01-09 14:38 | 2024-01-09 15:15 | MySQL Server | Duplicate (80 days) | S3 | 8.0.35 | Any | Any | Incorrect query result of function TIMESTAMPADD |
113614 | 2024-01-11 8:20 | 2024-01-11 9:24 | MySQL Server: Partitions | Won't fix (78 days) | S3 | mysql-5.6.51,mysql-5.7.44 | Any | Any | The partiton table's AUTOINC back to older after change partitions ddl executed. |
113962 | 2024-02-12 14:05 | 2024-02-12 15:11 | MySQL Server: DML | Verified (46 days) | S3 | 8.0 | Any | Any | Contribution: Fix offset check for insert position overflow |
114058 | 2024-02-20 7:28 | 2024-02-20 11:06 | MySQL Server: Optimizer | Not a Bug (38 days) | S3 | 8.0.35 | Any | Any | The return value of the CAST(... AS UNSIGNED) expression is out of range. |
114204 | 2024-03-04 8:43 | 2024-03-04 8:58 | MySQL Server: DML | Verified (25 days) | S2 | 8.2.0, 8.3.0 | Any | Any | Unexpected Results by COALESCE |
114217 | 2024-03-05 4:48 | 2024-03-05 7:01 | MySQL Server: DML | Verified (24 days) | S2 | 8.2.0, 8.3.0, 8.0.36 | Any | Any | Unexpected Results by Minus Sign |
114290 | 2024-03-09 23:51 | 2024-03-10 8:24 | MySQL Server: General | Not a Bug (19 days) | S2 | 8.0.36 | Any | Any | ENUM and operator IN bug |
114312 | 2024-03-12 6:30 | 2024-03-19 2:26 | MySQL Server: DML | Verified (10 days) | S3 | 8.0 | Any | Any | Item_ref::used_tables wrong when ref to a rollup constant |
114378 | 2024-03-17 12:44 | 2024-03-18 7:50 | MySQL Server: DML | Verified (11 days) | S3 | 8.0, 8.0.35 | Any | Any | Incorrect query result caused by CONVERT_TZ |
4 | 2002-10-29 19:45 | 2002-12-02 12:01 | MySQL Server | Closed (7788 days) | S3 | 4.0.5 | Any (all) | Any | BETWEEN not working properly with timestamp / datetime |
4124 | 2004-06-14 7:16 | 2004-06-21 10:28 | MySQL Server: Replication | Closed (7221 days) | S4 | All | Any (All) | Any | Replication Optimization |
6946 | 2004-12-02 14:31 | 2006-02-14 14:28 | MySQL Server | Won't fix (6618 days) | S4 | * | Any (*) | Any | INSERT ... ON DUPLICATE KEY UPDATE without INSERT |
17144 | 2006-02-05 21:31 | 2008-10-04 18:34 | MySQL Server: Security: Privileges | Unsupported (5655 days) | S4 | 4.0 and above | Any (*) | Any | Missing default values in user table complicate insert into user table |
20291 | 2006-06-06 12:37 | 2013-11-12 8:36 | MySQL Server: Errors | Closed (3790 days) | S3 | 5.0.44, 5.0.23-BK, 4.1.20 and 5.0.22 | Any (*) | Any | SELECT with no tables but a derived table resets warning list, contrary to docs |
24079 | 2006-11-08 9:39 | 2006-12-07 22:31 | MySQL Server: Falcon storage engine | Closed (6322 days) | S1 | 5.2 | Any | Any | strange errors around INSERT getting duplicate key, but one row is inserted |
27607 | 2007-04-03 7:18 | 2007-04-03 7:33 | MySQL Server: Documentation | Not a Bug (6205 days) | S3 | 5.0 | Any | Any | Delimiter statement in example wrong. |
28039 | 2007-04-23 19:50 | 2007-04-23 19:50 | MySQL Server: Falcon storage engine | Closed | S3 | Any | Any | Falcon Crash if INSERT ON DUPLICATE KEY with two interleaving transactions | |
29013 | 2007-06-11 7:03 | 2007-06-11 10:29 | MySQL Server | Can't repeat (6136 days) | S1 | 5.0.41 | Any | Any | Signal 11, MySQL server 5.0.41 crashed: has to do with the (NULL) |
29238 | 2007-06-20 13:52 | 2007-06-20 16:31 | MySQL Server: General | Not a Bug (6127 days) | S1 | 5.041 | Any | Any | INSERT DELAYED is suspended when table is full, no error reporting. |
29335 | 2007-06-25 12:29 | 2007-06-27 10:14 | MySQL Server: MyISAM storage engine | Not a Bug (6120 days) | S3 | 5.0.38 | Any | Any | INSERT DELAYED checks table space incorrectly on MyISAM |
29949 | 2007-07-21 18:45 | 2007-08-01 20:26 | MySQL Server: General | Not a Bug (6085 days) | S2 | 5.0.46 | Any | Any | killing a statement can give back wrong error to client |
31317 | 2007-10-01 15:13 | 2021-05-23 20:45 | MySQL Server: Falcon storage engine | No Feedback (5975 days) | S3 | 6.0.4-alpha-debug | Any | Any | falcon crash recovery not perfect yet |
32566 | 2007-11-21 11:32 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (5965 days) | S3 | 5.1 | Any | Any | Range partitioning: Insert of maximum value should fail LESS THAN (numeric max) |
38515 | 2008-08-01 7:05 | 2008-08-01 7:06 | MySQL Workbench | Duplicate (5719 days) | S3 | 5.0.23 | Any | Any | Insert VALUES repeated when importing model from DBDesigner4 |
39352 | 2008-09-09 22:07 | 2011-05-12 6:42 | Connector / J | Closed (5649 days) | S3 | 5.0.x, 5.1.x | Any | Any | INSERT ON DUPLICATE returns 1 instead of 0 when nothing is changed |
39498 | 2008-09-17 13:49 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Verified | S2 | mysql-5.1-telco-6.3 | Any | Any | Doing INSERT INTO .. SELECT brings down all data nodes. |
40119 | 2008-10-17 18:29 | 2008-10-17 18:36 | MySQL Server: Replication | Not a Bug (5642 days) | S2 | 5.0.67 | Any | Any | auto-increment-increment and auto-increment-offset it does not function |
40693 | 2008-11-13 10:15 | 2008-11-13 15:39 | MySQL Server: Options | Not a Bug (5615 days) | S5 | 5 | Any | Any | some status variables being reset |
40737 | 2008-11-14 12:14 | 2009-08-12 21:43 | MySQL Server: Locking | Not a Bug (5343 days) | S2 | 5.0.67 | Any | Any | Lock wait timeout exceeded during inserting row |
40776 | 2008-11-17 9:38 | 2008-12-01 7:40 | MySQL Server: Security: Privileges | Duplicate (5597 days) | S2 | 5.0.67-community-nt | Any | Any | NO Privileges (insert,update,delete) for TEMPORARY table |
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" |
41719 | 2008-12-23 19:08 | 2011-02-16 23:43 | MySQL Server: Replication | Closed (5462 days) | S3 | 5.0, 5.1 bzr | Any | Any | delayed INSERT into timestamp col needs set time_zone for concurrent binlogging |
42102 | 2009-01-14 9:34 | 2012-05-18 20:19 | MySQL Server: DML | Duplicate (5553 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 |
42372 | 2009-01-27 13:02 | 2009-01-29 12:21 | MySQL Server: Charsets | Not a Bug (5538 days) | S1 | 5.0.27 | Any | Any | Data truncate while inserting from PHP |
43196 | 2009-02-25 16:12 | 2011-02-16 23:43 | Connector / J | Closed (5215 days) | S2 | 5.1.31 | Any | Any | Statement.getGeneratedKeys() use long but unsigned bigint(20) use BigInteger |
43297 | 2009-03-02 8:15 | 2021-05-23 20:45 | MySQL Server: Falcon storage engine | Duplicate (5501 days) | S1 | 6.0-falcon-team | Any | Any | Falcon ASSERT(ret) in Table::insert |
43343 | 2009-03-03 22:13 | 2010-12-07 8:53 | MySQL Server: DB2SE for IBM i | Won't fix (4861 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 |
44976 | 2009-05-20 9:09 | 2011-02-16 23:43 | MySQL Server: Replication | Duplicate (4956 days) | S2 | 5.0.77 | Any | Any | Incorrect INSERT_ID in binary log |
45231 | 2009-06-01 3:07 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (5415 days) | S4 | 5.0.60 | Any | Any | Cannot change LAST_INSERT_ID value within before update trigger |
47253 | 2009-09-10 14:30 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (5310 days) | S3 | Any | Any | Assert in ha_partition::end_bulk_insert | |
49971 | 2009-12-29 9:38 | 2010-01-07 9:09 | MySQL Server: DML | Not a Bug (5195 days) | S4 | Any | Any | Allow INSERT .... WHERE .... | |
50065 | 2010-01-04 22:59 | 2012-07-29 23:08 | MySQL Server: Query Cache | Closed (4261 days) | S4 | 5.0.89, 5.1.37, 5.5-mr2 | Any | Any | query cache invalidated in insert...select if no rows inserted |
57698 | 2010-10-24 21:25 | 2012-09-13 9:30 | Connector / J | Closed (4879 days) | S3 | 5.1.13 | Any | Any | StatementRegressionTest.testGetGeneratedKeysAllCases causes false negative |
57806 | 2010-10-28 13:20 | 2021-05-02 20:45 | MySQL Cluster: Cluster/J | No Feedback (3871 days) | S3 | mysql-5.1-telco-7.1 | Any | Any | wrong interface member function type gives funny exception |
58083 | 2010-11-09 13:27 | 2011-02-16 23:44 | Tests: Replication | Duplicate (4888 days) | S3 | 5.6 | Any | Any | Test rpl.rpl_server_uuid fails after 5 minutes in trunk-bugfixing |
58686 | 2010-12-03 0:16 | 2010-12-15 23:39 | MySQL Server | Not a Bug (4853 days) | S3 | 5.1.43sp1-enterprise-gpl | Any | Any | CREATE TABLE .. CHARSET=<...> without a COLLATE using case-insensitive collation |
59735 | 2011-01-26 9:19 | 2011-04-02 1:35 | MySQL Server: Charsets | Closed (4745 days) | S3 | 5.5.8 | Any | Any | can't insert into value |
60425 | 2011-03-11 2:58 | 2012-01-19 18:46 | MySQL Server: Replication | Not a Bug (4453 days) | S3 | mysql5.5 | Any | Any | The rpl_semi_sync_master_wait_no_slave variable is invalid |
65846 | 2012-07-08 18:17 | 2016-09-09 11:23 | MySQL Server: DML | Won't fix (2758 days) | S3 | 5.1.63, 5.5.25, 5.5.26 | Any | Any | INSERT DELAYED on a BLACKHOLE table hangs forever |
67863 | 2012-12-10 16:24 | 2020-10-07 13:48 | MySQL Server: DML | Closed (1269 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | INSERT INTO view_name () VALUES () fails with ER_WRONG_VALUE_COUNT_ON_ROW |
68021 | 2013-01-03 16:49 | 2023-08-08 2:09 | MySQL Server: InnoDB storage engine | Closed (3470 days) | S2 | 5.5.29, 5.5.30, 5.6, 5.7.1 | Any | Any | Unexplainable InnoDB unique index locks on DELETE + INSERT with same values |
68769 | 2013-03-25 22:42 | 2013-03-26 3:37 | MySQL Server: General | Not a Bug (4021 days) | S1 | 5.5 or greater | Any (Linux and Windows) | Any | REPLACE/INSERT INTO fails for MyISAM if truncated is in the first row |
69253 | 2013-05-16 7:31 | 2014-08-27 4:50 | MySQL Server: Row Based Replication ( RBR ) | Closed (3502 days) | S3 | 5.6.11 | Any | Any | mysqlbinlog prints incorrect value while using decimal |
70529 | 2013-10-04 22:17 | 2014-01-15 18:32 | Connector / Python | Closed (3726 days) | S3 | 1.0.10 | Any | Any | executemany() INSERT INTO fails w/o VALUES (e.g. INSERT .. SELECT) |
72098 | 2014-03-21 20:47 | 2019-11-18 22:37 | MySQL Server: DML | Closed (1593 days) | S3 | 5.5, 5.5.38 | Any | Any | select * from (subquery) get different result with subquery. |
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 |
72756 | 2014-05-27 2:46 | 2014-05-27 2:46 | MySQL Server: Locking | Open | S4 | 5.5.37 | Any | Any | Downgrade AUTO-INC lock from simple INSERT when possible |
72851 | 2014-06-03 14:01 | 2015-08-30 12:07 | MySQL Server: InnoDB storage engine | Verified (3586 days) | S3 | 5.6 | Any | Any | Fix for bug 16345265 in 5.6.11 breaks backward compatibility for InnoDB recovery |
73083 | 2014-06-23 17:49 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Duplicate (3560 days) | S4 | Any | Any | mysqldump extended inserts should have new line character between each insert | |
73252 | 2014-07-10 7:18 | 2014-08-22 1:00 | MySQL Server: InnoDB storage engine | No Feedback (3508 days) | S3 | 5.6.13 | Any | Any | Duplicate foreign keys break insertions to a table |
73300 | 2014-07-16 18:03 | 2015-04-01 4:41 | MySQL Server: InnoDB storage engine | Closed (3515 days) | S3 | 5.7.5 | Any | Any | innodb.log_file_name fails sproadically on pb2 |
74228 | 2014-10-05 13:22 | 2014-10-07 11:13 | MySQL Server: Options | Verified (3462 days) | S3 | 5.5, 5.6 | Any | Any | Description of autoincrement behavior if offset > increment needs clarification |
74542 | 2014-10-24 10:05 | 2014-10-24 10:51 | MySQL Server: Optimizer | Verified (3444 days) | S3 | 5.6/5.7 | Any | Any | FLUSH TABLES WITH READ LOCK blocks EXPLAIN UPDATE/DELETE/INSERT |
74543 | 2014-10-24 10:11 | 2017-06-29 5:47 | MySQL Server: Optimizer | Verified (3444 days) | S3 | 5.6/5.7, 5.7.18 | Any | Any | read_only=1 prevents EXPLAIN UPDATE/DELETE/INSERT |
75068 | 2014-12-02 8:40 | 2015-04-06 19:03 | MySQL Server: DML | Closed (3325 days) | S3 | 5.1+ | Any | Any | LOAD DATA INFILE doesn't reset LEX::many_values |
75126 | 2014-12-06 10:42 | 2014-12-09 20:55 | MySQL Server: DDL | Verified (3398 days) | S4 | 5.6, 5.7 | Any | Any | Add option to disallow cross schema ddl |
76353 | 2015-03-17 14:55 | 2015-03-17 18:16 | MySQL Server | Duplicate (3300 days) | S3 | 5.6.22 | Any | Any | "Truncated incorrect INTEGER value" in INSERT...SELECT with CASE tested for NULL |
78004 | 2015-08-10 6:19 | 2023-05-02 13:28 | MySQL Server: InnoDB storage engine | Verified (3072 days) | S3 | 5.6.22, 5.6.26, 5.7.8 | Any | Any | auto_increment tinyint column value jumps from 125 to 127 |
78406 | 2015-09-11 10:21 | 2019-12-20 14:13 | MySQL Server | Not a Bug (1561 days) | S3 | 5.6.25 | Any | Any | Simple insert deadlock when selected from partitioned table being updated |
78623 | 2015-09-29 10:58 | 2015-10-19 12:56 | MySQL Server: InnoDB storage engine | Closed (3084 days) | S2 | 5.7.8 | Any | Any | Small tablespaces with BLOBs take up to 80 times more space in 5.7 than in 5.6 |
78763 | 2015-10-08 16:22 | 2015-10-08 17:02 | MySQL Server: mysqldump Command-line Client | Verified (3095 days) | S3 | 5.6/5.7 | Any | Any | mysqldump with --add-drop-trigger option when trigger name contains dots |
79171 | 2015-11-08 0:13 | 2015-11-19 15:30 | MySQL Server: mysqldump Command-line Client | Verified (3053 days) | S4 | Any | Any | mysqldump diff-friendly extended-insert | |
79690 | 2015-12-17 12:54 | 2015-12-17 19:33 | MySQL Server: DML | Not a Bug (3025 days) | S3 | 5.7.8 | Any | Any | Insert -0.1 and string '-0.1' into unsigned int returns different result |
80219 | 2016-02-01 8:26 | 2018-04-18 8:38 | MySQL Server: Tests | Can't repeat (2172 days) | S3 | 5.6.28 | Any | Any | rpl_stm_mixed_crash_safe mtr test fails |
80404 | 2016-02-17 11:06 | 2016-02-17 13:28 | MySQL Server: DML | Verified (2963 days) | S3 | 5.0/5.1/5.5/5.6/5.7 | Any | Any | After sql_warnings to 0, the INSERT still get warnings message |
81063 | 2016-04-13 9:10 | 2018-08-09 14:45 | Connector / J | Closed (2059 days) | S2 | 5.1.16, 5.1.38 | Any | Any | w/ rewriteBatchedStatements, when 2 tables involved, the rewriting not correct |
81680 | 2016-06-01 13:33 | 2016-06-01 18:01 | MySQL Server: InnoDB storage engine | Verified (2858 days) | S4 | 5.7 | Any (CentOS Linux release 7.2.1511 (Core) ) | Any | A proposal to make disk IO much faster under SSD |
83397 | 2016-10-16 10:58 | 2016-10-17 6:58 | MySQL Server: FULLTEXT search | Verified (2720 days) | S3 | 5.7.15, 5.7.16 | Any | Any | INSERT INTO ... SELECT FROM ... fails if source has > 65535 rows on FTS |
87353 | 2017-08-09 8:30 | 2017-08-09 9:39 | MySQL Cluster: Cluster (NDB) storage engine | Verified (2424 days) | S3 | 7.5.7 | Any | Any | "ndb_restore --print-data" and "ndb_restore --print-sql-log" have duplicate row |
87598 | 2017-08-30 7:44 | 2017-08-30 12:22 | MySQL Server: Optimizer | Duplicate (2403 days) | S3 | 5.7.19 | Any | Any | SELECT DISTINCT doesn't return result with "Using index for group-by" |
89225 | 2018-01-14 21:09 | 2018-01-15 7:30 | MySQL Server: DML | Not a Bug (2265 days) | S3 | 5.7 | Any | Any | INSERT INTO ... VALUES (DEFAULT) on auto_increment becomes unexpected value 0 |
89385 | 2018-01-24 15:14 | 2020-10-06 13:05 | MySQL Server | Not a Bug (1270 days) | S4 | Any | Any | INSERT IGNORE DUPLICATE KEY | |
90210 | 2018-03-26 2:22 | 2018-04-03 14:03 | MySQL Server: InnoDB storage engine | Not a Bug (2187 days) | S2 | 5.6.32+ | Any (CentOS,Ubuntu,MAC) | Any (intel64,MAC) | deadlock when concurrency update the same index |
90745 | 2018-05-04 8:38 | 2023-12-12 12:43 | MySQL Workbench | Verified (2156 days) | S3 | 8.0.11, 8.0.23 | Any | Any | sqlide-history parser fails to parse entries with some html encodings |
91208 | 2018-06-11 10:19 | 2018-06-13 1:03 | MySQL Server: Documentation | Closed (2116 days) | S3 | 8.0 | Any (8.x) | Any | INSERT DELAYED removed, but still referred in docs. |
94814 | 2019-03-28 11:12 | 2022-12-01 12:01 | MySQL Server: XA transactions | Closed (484 days) | S2 | 5.7, 8.0, 5.7.25 | Any | Any | slave replication lock wait timeout because of wrong trx order in binlog file |
98595 | 2020-02-14 9:30 | 2020-02-14 13:46 | MySQL Server | Not a Bug (1505 days) | S3 | 8.0.18 | Any | Any | Auto-inc number is different between different connections |
99504 | 2020-05-11 2:47 | 2021-10-22 17:39 | MySQL Server: DML | Duplicate (889 days) | S2 | 8.0.20 | Any | Any | Generated column incorrect on INSERT when based on column w/ expression DEFAULT |
99513 | 2020-05-11 13:21 | 2020-06-09 12:10 | MySQL Server: Data Types | Closed (1390 days) | S3 | Any | Any | "ALTER TABLE ... ADD ... DEFAULT now()" generates wrong time at first INSERT | |
100398 | 2020-07-31 8:33 | 2020-07-31 9:50 | MySQL Server: Optimizer | Verified (1337 days) | S3 | 8.0.19, 5.7.31, 8.0.21 | Any | Any | The results of aggregation operations are inconsistent in different partitions |
102481 | 2021-02-04 15:37 | 2021-02-05 14:40 | MySQL Server: Optimizer | Verified (1148 days) | S3 | 8.0.23 | Any | Any | EXPLAIN FOR CONNECTION not good |
102655 | 2021-02-19 3:07 | 2021-12-02 11:19 | MySQL Server: Optimizer | Duplicate (848 days) | S3 | 8.0, 8.0.23 | Any | Any | results from SELECT are different when use WHERE or not |
102912 | 2021-03-11 2:07 | 2021-03-11 13:02 | MySQL Server: Optimizer | Verified (1114 days) | S3 | 8.0, 8.0.23, 5.7.33 | Any | Any | filter result different on a index bit column with no-index bit column |
104287 | 2021-07-12 13:39 | 2021-07-14 11:24 | MySQL Server: Clone Plugin | Not a Bug (989 days) | S3 | 8.0.17 | Any | Any | trx_sys binlog coordinates broken after clone plugin |
104499 | 2021-07-31 20:35 | 2021-08-27 12:02 | MySQL Server: InnoDB storage engine | Verified (946 days) | S3 | Any | Any | MySQL auto_inc value changed after a failed insert | |
104674 | 2021-08-20 9:05 | 2021-08-20 9:30 | MySQL Workbench | Verified (952 days) | S3 | 8.0, 8.0.26 | Any | Any | MySQLLexer.g4 `BACK_TICK_QUOTED_ID `lexical rule definition bug |
105517 | 2021-11-10 13:36 | 2021-11-10 14:36 | MySQL Server: Data Types | Verified (870 days) | S2 | 8.0 | Any (20.0.4.1) | Any | INSERT of CURRENT_TIMESTAMP() vs. DEFAULT differs for TIMESTAMP field |
105885 | 2021-12-14 0:42 | 2021-12-14 13:39 | MySQL Cluster: Cluster (NDB) storage engine | Verified (836 days) | S3 | 8.0.27 | Any | Any | Multi row operation mixes can cause crash during node recovery |
108379 | 2022-09-05 7:58 | 2022-09-20 22:29 | Connector / J | Duplicate (556 days) | S3 | 8.0.29, 8.0.30 | Any | Any | Recognize "ON DUPLICATE KEY UPDATE" in "INSERT SET" Statement |
109857 | 2023-01-31 8:55 | 2023-02-03 4:54 | MySQL Server: Replication | Duplicate (420 days) | S2 | 5.7.38 | Any | Any | Truncate table with foreign key crash replication. |
109938 | 2023-02-04 21:51 | 2023-02-13 13:27 | MySQL Server: Locking | Not a Bug (413 days) | S3 | 8.0.31 | Any | Any | next key lock with ROLLBACK TO SAVEPOINT |
110245 | 2023-03-01 3:56 | 2023-03-02 9:59 | MySQL Server: Optimizer | Not a Bug (393 days) | S3 | 8.0.32 | Any | Any | Issue with NOT IN |
110672 | 2023-04-12 21:23 | 2023-04-18 16:02 | MySQL Server: DML | Closed (346 days) | S2 | 8.0.32 | Any | Any | QUOTE function doesn't work as expected on tables that are utf16 |
110795 | 2023-04-25 5:45 | 2023-04-25 8:41 | MySQL Server: Locking | Verified (339 days) | S3 | 8.0.27, 8.0.33, 5.7.42 | Any | Any | mysql insert is deadlocked |
112802 | 2023-10-23 8:23 | 2023-10-27 9:46 | MySQL Server: Optimizer | Verified (158 days) | S3 | 8.1.0, 8.0.34 | Any | Any | Inconsistent results when using INDEX |
113257 | 2023-11-28 14:29 | 2023-12-08 9:43 | Tests: Replication | Verified (120 days) | S6 | 8.2.0 | Any | Any | Assertion on rpl.rpl_replication_observers_example_plugin_ongoing_transaction |
113464 | 2023-12-19 17:40 | 2024-03-12 11:05 | MySQL Server: Optimizer | Verified (100 days) | S2 | 8.0.27 | Any | Any | >= 8.0.27 Error 1048 when updating row with empty_sql mode |
291 | 2003-04-15 9:37 | 2019-05-14 14:18 | MySQL Server | Closed (7623 days) | S2 | 4.0, 4.1 | Any (All) | Any | bug in NATURAL LEFT JOIN, MySQL 4.0 and 4.1. |
2614 | 2004-02-02 10:02 | 2020-04-29 12:28 | MySQL Server | Closed (7357 days) | S2 | 5.0 | Any (any) | Any | Sotred procedure with INSERT .. SELECT crash 5t.0 |
3985 | 2004-06-03 16:26 | 2005-12-13 16:23 | MySQL Server | Duplicate (6681 days) | S4 | 4.0 | Any (any) | Any | privilege for INSERT, UPDATE, DELETE, DROP, CREATE TEMPORARY TABLES |
9229 | 2005-03-16 19:07 | 2019-10-07 12:17 | MySQL Server | Closed (6952 days) | S1 | 5.0.3-pre | Any (Any) | Any | Test 'sp' requires InnoDB and thus fails in 'classic' |
15189 | 2005-11-23 15:59 | 2011-02-16 23:43 | MySQL Server: DML | Verified (6701 days) | S4 | 5.0.17-BK | Any | Any | Optimise INSERT ... ON DUPLICATE KEY ... for identical column values |
18489 | 2006-03-24 15:33 | 2006-07-29 17:38 | MySQL Server | Won't fix (6453 days) | S4 | 5.1 | Any (All) | Any | Field Selection Negation |
18652 | 2006-03-30 13:58 | 2009-01-13 18:08 | MySQL Query Browser | Won't fix (5554 days) | S4 | Any | Any (Any) | Any | Auto Insert Delimiters on Script Tabs |
19887 | 2006-05-17 15:17 | 2011-02-16 23:43 | MySQL Server: Locking | Verified (6522 days) | S4 | 4.1 / 5.0 | Any (*) | Any | concurrent updates restricted by queries not using the binlog |
26733 | 2007-02-28 20:15 | 2007-03-01 9:46 | MySQL Server: Command-line Clients | Not a Bug (6238 days) | S2 | 5.0.38 | Any (any) | Any | '\r' in the text data in INSERT statement causes client to reconnect |
29146 | 2007-06-15 19:08 | 2016-02-25 12:24 | MySQL Server: Command-line Clients | Not a Bug (5868 days) | S3 | 5.0.41 | Any | Any | Output truncated when resultset contains \r |
29692 | 2007-07-10 15:37 | 2009-12-07 9:07 | MySQL Server | Closed (6037 days) | S1 | mysql-essential-5.1.21-beta | Any (Linux, WindowsXP) | Any | Single row inserts can incorrectly report a huge number of row insertions |
29771 | 2007-07-12 19:50 | 2007-07-17 11:25 | MySQL Server: Stored Routines | Not a Bug (6100 days) | S2 | 5.045 | Any | Any | The cursor is automatically closed. |
29979 | 2007-07-23 15:56 | 2007-07-23 16:43 | MySQL Server | Duplicate (6094 days) | S1 | 5.0.6, 5.0.7 | Any | Any | PreparedStatement.executeUpdate returns wrong rowcount for an insert statement. |
30833 | 2007-09-05 14:41 | 2007-09-05 15:07 | MySQL Server: Backup | Can't repeat (6050 days) | S3 | Ver 10.10 Distrib 5.0.27 | Any | Any | mysqldump does not create views when "information_schema" passed to --databases |
31906 | 2007-10-29 10:22 | 2007-10-29 11:10 | MySQL Server: DML | Not a Bug (5996 days) | S3 | Any | Any | No stmt rollback and wrong binlog if an error in {INSERT|CREATE} ... SELECT UNIO | |
31975 | 2007-10-31 7:36 | 2009-09-01 13:19 | MySQL Server: Command-line Clients | Not a Bug (5323 days) | S4 | mysql-connector-java-3.1.8-bin.jar | Any | Any | LOAD DATA LOCAL INFILE - Duplicate entry error should come |
33515 | 2007-12-26 13:29 | 2008-06-13 16:09 | MySQL Server: Stored Routines | Closed (5768 days) | S1 | 6.0.4 | Any | Any | Create trigger, partition, insert = crash |
33767 | 2008-01-09 13:31 | 2008-01-17 22:14 | MySQL Server: Falcon storage engine | Can't repeat (5916 days) | S3 | 6.0.4 | Any | Any | Falcon crash on thread creation |
35634 | 2008-03-28 8:54 | 2008-10-01 15:08 | MySQL Server: Command-line Clients | Won't fix (5658 days) | S4 | 5.1-bk | Any | Any | 'mysql' client: 'source' should stop after first failed command |
36258 | 2008-04-22 13:58 | 2008-05-19 12:16 | MySQL Server: Maria storage engine | Closed (5793 days) | S2 | 5.1-maria | Any | Any | Maria: INSERT SELECT sends ok to client before committing |
36559 | 2008-05-07 11:15 | 2010-05-10 18:37 | MySQL Server: Optimizer | Not a Bug (5072 days) | S1 | 5.0.46-5.0.60 | Any | Any | INSERT .. SELECT takes more time to complete on versions 5.0.46 and newer |
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 |
38088 | 2008-07-13 16:03 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | No Feedback (5496 days) | S3 | 6.0 | Any | Any | rpl_row_basic_7ndb failed At line 55 INSERT INTO t2 ... |
69515 | 2013-06-19 14:55 | 2013-06-19 15:11 | MySQL Server: Options | Verified (3936 days) | S3 | 5.1, 5.5, 5.6, 5.7 | Any | Any | group_concat_max_len >= 4Gb does not work |
69585 | 2013-06-26 11:23 | 2014-07-22 18:41 | MySQL Server: MyISAM storage engine | Verified (3538 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 |
69673 | 2013-07-04 18:42 | 2013-07-04 18:43 | MySQL Server: InnoDB storage engine | Verified | S4 | 5.6.13 | Any | Any | Add P_S instrumentation which allows to observe LSN per page per tablespace |
69737 | 2013-07-13 11:33 | 2013-07-15 5:39 | MySQL Server: Information schema | Can't repeat (3910 days) | S3 | 5.6 | Any | Any | "INSERT INTO ... SELECT ... I_S ... ORDER BY" fails on "ERROR 1028" |
69780 | 2013-07-18 14:03 | 2016-07-15 9:53 | MySQL Server: InnoDB storage engine | Closed (3094 days) | S3 | 5.6.12 | Any | Any | Fix for bug 14606334 in 5.6.11 breaks backward compatibility for InnoDB recovery |
69944 | 2013-08-07 6:16 | 2014-03-06 13:20 | MySQL Server: Replication | Verified (3676 days) | S4 | All Versions | Any | Any | Processlist shows Second Behind Master instead of Query time for Replication |
70202 | 2013-08-30 15:36 | 2013-09-02 11:53 | MySQL Server: DML | Verified (3861 days) | S3 | 5.5, 5.6 | Any | Any | REPLACE working differently for a table having PK or UK only versus both PK+UK |
70298 | 2013-09-11 12:12 | 2014-05-27 6:59 | MySQL Server: InnoDB storage engine | Closed (3836 days) | S3 | 5.6.12 | Any | Any | [ERROR] InnoDB: Failed to set O_DIRECT on file |
70346 | 2013-09-15 4:04 | 2013-12-10 6:47 | MySQL Server: Replication | Verified (3762 days) | S1 | 5.6.16 | Any | Any | Illegal mix of collations (gbk_chinese_ci,COERCIBLE) |
70684 | 2013-10-22 8:13 | 2013-10-22 11:35 | MySQL Server: Optimizer | Verified (3811 days) | S3 | 5.5.33, 5.6.14 | Any | Any | HAVING referring to subquery results in WARNING 1292 |
70711 | 2013-10-23 18:21 | 2015-06-24 4:30 | MySQL Server: Replication | Closed (3264 days) | S3 | 5.6.14 | Any | Any | mysqlbinlog prints invalid SQL from relay logs when GTID is enabled |
70894 | 2013-11-13 9:02 | 2013-11-13 11:41 | MySQL Server | Not a Bug (3789 days) | S2 | 5.5, 5.6 | Any | Any | GROUP BY HAVING with MAX returns not all results |
70983 | 2013-11-22 16:58 | 2014-01-16 5:43 | MySQL Server: Stored Routines | Closed (3725 days) | S3 | 5.6 | Any | Any | Assertion `0' fails on creating a temporary table via trigger |
71087 | 2013-12-05 8:16 | 2013-12-10 18:27 | Connector / C++ | Verified (3762 days) | S4 | Any | Any | Implement Statement::getGeneratedKeys() | |
71095 | 2013-12-05 16:00 | 2014-08-01 15:52 | MySQL Server: Partitions | Closed (3605 days) | S3 | 5.5.33, 5.6.14, 5.6.15 | Any | Any | Wrong results with PARTITION BY LIST COLUMNS() |
71127 | 2013-12-11 11:51 | 2013-12-19 11:32 | MySQL Fabric | Closed (3753 days) | S3 | 1.4.0 | Any | Any | Checkpoint routine can lead to deadlock |
71164 | 2013-12-17 16:38 | 2014-09-05 2:44 | MySQL Server: InnoDB storage engine | Verified (3746 days) | S3 | 5.6.15 | Any | Any | an autocommit SELECT was not treated as autocommit non-lock trx |
71886 | 2014-02-28 15:37 | 2015-01-09 10:12 | MySQL Enterprise Backup | Closed (3367 days) | S3 | 3.9.0 | Any | Any | Command missing from help: copy-back-and-apply-log |
71932 | 2014-03-05 9:42 | 2014-03-05 9:42 | MySQL Server: Partitions | Verified | S3 | 5.6.18, 5.7.5 | Any | Any | reorganize + multirow insert into partition table leads to wrong auto_increment |
72072 | 2014-03-19 7:31 | 2014-04-14 13:18 | MySQL Server: Locking | Not a Bug (3637 days) | S3 | 5.5 | Any | Any | 5.5 Lock |
72074 | 2014-03-19 10:35 | 2016-09-01 15:53 | MySQL Server: Row Based Replication ( RBR ) | Duplicate (3661 days) | S2 | 5.5+ | Any | Any | the third cascade slave crash when MRG_MyISAM used |
72089 | 2014-03-20 20:30 | 2014-03-22 6:19 | MySQL Server: DML | Verified (3660 days) | S3 | 5.5.8, 5.5.31, 5.5.38 | Any | Any | FOUND_ROWS returns 0 or garbage when used in non-trivial queries |
72265 | 2014-04-07 16:59 | 2014-04-08 4:56 | MySQL Enterprise Monitor: Agent | Verified (3643 days) | S3 | 3.0.8 | Any | Any | MEM tries to explain INSERT/UPDATE/DELETE type statements on a read-only slave |
72318 | 2014-04-11 17:36 | 2017-12-23 10:47 | MySQL Server: Stored Routines | Verified (3637 days) | S3 | 5.6.14-log | Any | Any | Stored function throws error 1137 if temporary table was not created right then |
72468 | 2014-04-28 3:30 | 2020-06-25 9:59 | Connector / NET | Can't repeat (2901 days) | S3 | 6.8.3 | Any | Any | Unknown column 'p1' in 'field list' |
72487 | 2014-04-30 8:12 | 2014-06-03 1:00 | Connector / J | No Feedback (3588 days) | S2 | 5.1.18 | Any | Any | UUID via JDBC generates not unique IDs |
72512 | 2014-05-02 8:57 | 2014-06-04 16:45 | MySQL Server: Optimizer | Closed (3586 days) | S3 | 5.5, 5.6 | Any | Any | Non-aggregated query with set function in ORDER BY should be rejected |
72628 | 2014-05-13 7:56 | 2014-07-30 10:02 | MySQL Server: Data Types | Not a Bug (3530 days) | S3 | 5.6 | Any | Any | MySQL is not inserting Default value for datetime column when null value passed |
72690 | 2014-05-20 9:13 | 2014-07-15 8:59 | MySQL Server: Optimizer | Not a Bug (3587 days) | S2 | 5.6.17 | Any | Any | A 5.6's optimizer bug which is releated to 'or' operator's number |
72732 | 2014-05-23 22:06 | 2014-07-11 14:25 | Connector / Python | Closed (3564 days) | S2 | mysql-connector-python==1.1.6 | Any | Any | time variable (TimeField) with 00:00:00 value converts to NULL in the SQL |
72806 | 2014-05-30 6:43 | 2015-04-29 0:11 | MySQL Server: Compiling | Closed (3257 days) | S5 | 5.7.7 | Any | Any | mutex_delay() missing x86 pause instruction optimization |
72858 | 2014-06-03 22:18 | 2016-02-26 13:49 | MySQL Server: Optimizer | Closed (2954 days) | S2 | 5.6.17, 5.6.20, 5.7.5 | Any | Any | EXPLAIN .. SELECT .. FOR UPDATE takes locks |
72912 | 2014-06-08 13:31 | 2014-06-08 19:38 | MySQL Server: Information schema | Verified (3582 days) | S3 | 5.6.19 | Any | Any | Inconsistent naming of tables in different I_S.innodb% tables |
72987 | 2014-06-12 15:28 | 2017-05-09 14:45 | MySQL Server: InnoDB storage engine | Verified (2516 days) | S3 | 5.6, 5.7 | Any | Any | it unnecessary to set page max trx_id in update_index_page when index is cluster |
73085 | 2014-06-23 23:30 | 2015-07-26 7:48 | MySQL Workbench: SQL Editor | Verified (3565 days) | S3 | 6.1.6 | Any | Any | Result Grid's Data Import to include more types, like Data Export |
73207 | 2014-07-05 12:21 | 2017-04-27 14:36 | MySQL Server: Stored Routines | Closed (3413 days) | S3 | 5.7.4 | Any | Any | 5.7 triggers handle not null differently to older versions; breaks compatibility |
73212 | 2014-07-06 1:27 | 2017-07-06 19:19 | MySQL Fabric | Won't fix (3521 days) | S3 | 1.4.3-1 | Any | Any | dump restore fails on shard_split with error 1840 when there is insert activity |
73242 | 2014-07-09 10:57 | 2014-07-13 9:19 | MySQL Server: Charsets | Closed (3547 days) | S3 | 5.6.19 | Any | Any | Error Code: 1366. Incorrect string value: '\xF0\x9F\x94\x8D' |
73266 | 2014-07-10 20:03 | 2014-07-21 14:48 | Connector / Python | Closed (3543 days) | S2 | 1.2.2 | Any | Any | Floating point inaccuracy only on Python 2.x with mysql/connector python |
73546 | 2014-08-12 8:36 | 2014-09-05 5:08 | MySQL Fabric | Closed (3493 days) | S2 | 1.4 | Any | Any | Resharding can cause inconsistency during high loads |
73723 | 2014-08-26 7:58 | 2014-09-19 15:15 | MySQL Server: InnoDB storage engine | Closed (3501 days) | S3 | 5.7 | Any | Any | innodb.log_file_size fails with wrong errno 2006 ob pb2(sporadic) |
73747 | 2014-08-28 3:26 | 2014-08-29 15:00 | Connector / J | Not a Bug (3500 days) | S3 | Any | Any | Add a config option to ignore non-BMP characters | |
73896 | 2014-09-11 15:40 | 2015-02-02 22:06 | MySQL Server: DML | Verified (3343 days) | S3 | 5.5.40/5.6.23 | Any | Any | MySQL issues an "Unsafe statement" warning for what should be a safe statement |
73927 | 2014-09-16 10:12 | 2015-03-24 21:34 | MySQL Server: Optimizer | Closed (3336 days) | S3 | 5.7 | Any | Any | SELECT DISTINCT SUM() RETURNS DUPLICATE ROWS |
73932 | 2014-09-16 12:49 | 2015-03-24 21:55 | MySQL Server: Optimizer | Closed (3336 days) | S3 | 5.7 | Any | Any | multi-update crash with long primary key |
74177 | 2014-10-01 13:51 | 2015-06-26 16:01 | MySQL Server: Replication | Closed (3199 days) | S2 | 5.7.5, 5.7.6 | Any | Any | --slave-preserve-commit-order causes slave to deadlock and break for some querie |
74209 | 2014-10-03 8:38 | 2014-10-22 21:46 | MySQL Server: InnoDB storage engine | Closed (3454 days) | S2 | 5.7.5 | Any | Any | btr_cur_search_to_nth_level() should check modify intention also for leaf pages |
74354 | 2014-10-13 10:44 | 2021-03-12 6:06 | MySQL Server: DML | Verified (3455 days) | S2 | 5.7.5, 8.0.23, 5.7.33 | Any | Any | REPLACE INTO affected_rows wrong |
74486 | 2014-10-21 18:55 | 2015-02-16 20:37 | MySQL Server: Installing | Closed (3329 days) | S3 | 5.7.5-labs-preview | Any | Any | Dangerous grant in rewrite plugin install script |
74514 | 2014-10-22 20:42 | 2015-03-27 1:33 | MySQL Workbench | Closed (3290 days) | S3 | 6.2, 6.1 | Any (verified on Windows, Mac) | Any | Cant import into table with no Primary Key |
74521 | 2014-10-23 8:35 | 2015-04-06 18:38 | MySQL Cluster: Disk Data | Closed (3398 days) | S3 | 7.1.33 | Any | Any | Incorrect schemaTrans outcome reported during DICT master takeover. |
74596 | 2014-10-28 2:27 | 2014-12-22 13:20 | MySQL Server: InnoDB storage engine | Closed (3385 days) | S3 | 5.7.5, 5.7.6 | Any | Any | crash in btr_cur_latch_leaves |
74614 | 2014-10-29 9:15 | 2015-07-14 14:07 | MySQL Server: Performance Schema | Closed (3181 days) | S3 | 5.6.16, 5.6.22, 5.7.7 | Any | Any | events_statements_history has errors=0 when there are errors |
74797 | 2014-11-11 15:19 | 2021-09-14 11:06 | MySQL Server: DML | Verified (3426 days) | S3 | 5.6.21/5.7 | Any | Any | create temporary table . select ..union.. select fails on read-only MySQL Server |
74806 | 2014-11-12 4:23 | 2014-11-12 15:34 | MySQL Server: Optimizer | Closed (3425 days) | S2 | 5.6.12 | Any | Any | COUNT(DISTINCT ... ) wrong with "Using index" |
74816 | 2014-11-12 12:28 | 2015-08-17 16:45 | MySQL Server: DDL | Verified (3424 days) | S3 | 5.6.21, 5.6.23, 5.7.6 | Any | Any | Work around for charset conversion with FKs can result in wrong data |
74962 | 2014-11-21 13:24 | 2014-11-21 14:20 | MySQL Server: Optimizer | Verified (3416 days) | S3 | 5.5/5.6 | Any | Any | Matching in char field type is not correct |
75001 | 2014-11-25 23:55 | 2014-12-09 20:59 | MySQL Server: Charsets | Verified (3398 days) | S3 | 5.5.42, 5.6.23, 5.7.6 | Any | Any | CONCAT() of columns with same encoding but different collations behaves wrongly |
75120 | 2014-12-05 17:45 | 2017-07-06 19:19 | MySQL Fabric | Won't fix | S3 | 1.4.1 | Any | Any | Undo jobs execute in the same transaction context of the failed job |
75175 | 2014-12-11 10:25 | 2015-06-19 17:03 | Connector / Python | Closed (3206 days) | S2 | 2.0.2 | Any | Any | Using a BinaryField in Django will raise an exception on UPDATE/INSERT |
75303 | 2014-12-24 3:04 | 2015-11-19 17:52 | MySQL Server: Security: Encryption | Verified (3053 days) | S4 | Any | Any | Option in hash functions for binary output | |
75342 | 2014-12-30 18:09 | 2015-04-06 21:31 | MySQL for Windows: MySQL for Excel | Closed (3320 days) | S3 | 1.3.3 | Any | Any | Export Data - wrong number of exporting rows in SQL script dialog |
75424 | 2015-01-06 14:23 | 2015-04-07 13:44 | MySQL Server: Optimizer | Closed (3279 days) | S3 | 5.7 | Any | Any | EXPLAIN for insert into a view shows wrong table for insertion |
75447 | 2015-01-08 12:59 | 2015-01-08 13:27 | MySQL Server: Optimizer | Verified (3368 days) | S2 | 5.6, 5.6.24, 5.7.6 | Any | Any | INSERT into a view sometimes ignores default values |
75614 | 2015-01-24 1:48 | 2015-06-28 10:57 | MySQL Server: InnoDB storage engine | Verified (3349 days) | S3 | 5.6, 5.7 | Any | Any | table become unusable if crashed during ddl |
75697 | 2015-01-30 12:28 | 2015-05-11 13:25 | MySQL Server: InnoDB storage engine | Closed (3245 days) | S3 | 3.23.53 | Any | Any | Add a consistency check against DB_TRX_ID being in the future |
75763 | 2015-02-04 13:29 | 2015-02-05 8:19 | MySQL Server: FULLTEXT search | Verified (3340 days) | S2 | 5.6.21, 5.6.24 | Any | Any | InnoDB FULLTEXT index reduces insert performance by up to 6x on JSON docs |
75772 | 2015-02-04 19:07 | 2015-04-07 21:01 | MySQL Server: Replication | Closed (3285 days) | S1 | 5.7.6 | Any | Any | 5.7.6->5.6 replication fails |
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 | |
75834 | 2015-02-10 7:46 | 2016-02-02 19:35 | MySQL Server: Partitions | Closed (3244 days) | S2 | 5.7.6-m16 | Any | Any | rqg_alter_online_part run into assertion: node->entry == null (row0ins.cc) |
75879 | 2015-02-12 17:04 | 2015-06-24 4:00 | MySQL Utilities: Binlog Events | Closed (3259 days) | S2 | 5.6,5.7 | Any | Any | memory consumed quickly while executing loop in procedure |
75893 | 2015-02-13 12:04 | 2015-04-07 21:14 | MySQL Server: Pluggable Authentication | Closed (3292 days) | S3 | 5.7.6 | Any | Any | server crash while connecting with cleartext-plugin user with blank pwd |
75958 | 2015-02-18 18:21 | 2015-02-18 22:32 | MySQL Server: DML | Can't repeat (3327 days) | S1 | 5.7.5-m15 | Any | Any | handle_fatal_signal (sig=11) in String::replace | INSERT into TEMPORARY table |
76002 | 2015-02-23 8:14 | 2015-02-25 1:35 | MySQL Server: Optimizer | Not a Bug (3320 days) | S3 | 5.6 | Any | Any | different plan when executing query using procedure |
76058 | 2015-02-26 9:45 | 2015-04-07 22:08 | MySQL Server: Parser | Closed (3290 days) | S2 | 5.7.6 | Any | Any | refactored parser code may ignore OOM errors and dereference NULL pointers |
76205 | 2015-03-07 7:01 | 2016-02-02 20:10 | MySQL Server: Information schema | Closed (3234 days) | S2 | 5.7+ | Any | Any | sql_show.cc:7764: Assertion `qep_tab->condition() == qep_tab->condition_optim()\ |
76244 | 2015-03-10 16:31 | 2018-07-26 1:00 | MySQL Server: DML | No Feedback (2074 days) | S2 | 5.6.18, 5.1.73+ | Any | Any | MySQL does order of operations incorrectly on distinct numeric string |
76320 | 2015-03-14 5:16 | 2015-08-31 15:45 | MySQL Server: DDL | Closed (3133 days) | S3 | 5.7.6, 5.7.8 | Any | Any | Kill `CREATE TABLE ..SELECT` may lead to replication broken |
76367 | 2015-03-18 4:29 | 2015-04-07 22:54 | Tests | Closed (3291 days) | S3 | Any | Any | main.ctype_ucs test fails in WL8403 | |
76402 | 2015-03-20 4:43 | 2015-03-21 6:48 | MySQL Server | Closed (3296 days) | S1 | 5.7.6-m16 | Any | Any | High CPU usage issue/stuck queries with 5.7.6-m16 |
76436 | 2015-03-23 0:23 | 2016-06-18 21:25 | MySQL Server: DML | Closed (3292 days) | S1 | 5.7.6, 5.7.8, 8.0.0 | Any | Any | handle_fatal_signal (sig=11) in st_select_lex::merge_derived |
76501 | 2015-03-27 6:50 | 2015-03-27 15:11 | MySQL Server: Optimizer | Verified (3290 days) | S3 | 5.6.22 | Any | Any | "select + distinct + group by " works incorrectly |
76872 | 2015-04-28 14:51 | 2017-11-07 14:52 | MySQL Server: InnoDB storage engine | Closed (2772 days) | S2 | 5.6.24, 5.6.26 | Any | Any | InnoDB AUTO_INCREMENT produces same value twice |
77013 | 2015-05-12 10:28 | 2015-05-18 6:52 | Connector / ODBC | Verified (3238 days) | S3 | 5.3.4 | Any | Any | find_closing_quote makes .execute fail with HY000 when a SQL comment has a quote |
77037 | 2015-05-14 9:19 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Closed (3230 days) | S3 | 5.7.7, 5.7.8 | Any | Any | mysqldump: Option '-T' used, but is disabled |
77116 | 2015-05-21 11:43 | 2015-05-22 5:40 | MySQL Server: Optimizer | Closed (3234 days) | S3 | 5.6.*, 5.6.24 | Any | Any | Invalid query result |
77246 | 2015-06-04 7:21 | 2016-02-04 19:38 | MySQL Server: InnoDB storage engine | Closed (3207 days) | S3 | 5.7.2 | Any | Any | Reintroduce adaptive hash index field prefixes to speed up sequential inserts |
77392 | 2015-06-17 16:22 | 2016-04-27 15:05 | MySQL Server: Replication | Closed (3126 days) | S3 | 5.7.7 | Any | Any | Slave group event parser does not recognize XA ROLLBACK as a boundary |
77474 | 2015-06-24 16:06 | 2015-07-13 16:07 | MySQL Server: Documentation | Closed (3182 days) | S3 | 5.6 | Any | Any | Clarification in documentation for Timestamp initilization |
77673 | 2015-07-09 18:30 | 2017-11-16 7:49 | MySQL Server: Replication | Closed (2325 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) |
77782 | 2015-07-20 6:32 | 2015-08-27 4:19 | MySQL Server: Optimizer | Closed (3168 days) | S2 | 5.7.8 | Any | Any | valgrind error (conditional jump) when insert rows into a partitioned table |
77827 | 2015-07-24 9:29 | 2016-12-22 8:58 | MySQL Server: InnoDB storage engine | Verified (2654 days) | S3 | 5.7, 5.6 | Any | Any | reduce cpu time costs of creating dummy index while change buffer is enabled |
77841 | 2015-07-27 9:36 | 2015-07-28 10:07 | MySQL Server: Replication | Can't repeat (3167 days) | S3 | MySQL5.6.11 | Any | Any | There is an bug on slave about 'Last_Error' and ‘Last_SQL_Error’ , |
77856 | 2015-07-28 6:33 | 2019-04-11 19:25 | MySQL Server: Command-line Clients | Verified (3167 days) | S3 | 5.6.26, 5.7.9, 5.5.46 | Any | Any | CREATE TRIGGER incorrect delimiter parsing inside of comments |
77947 | 2015-08-05 12:30 | 2016-02-19 16:37 | MySQL Server: Optimizer | Closed (2961 days) | S2 | 5.7.6 | Any | Any | internal_tmp_disk_storage_engine=innodb breaks SQL optimizer compatibility |
78009 | 2015-08-10 11:25 | 2015-08-10 14:47 | MySQL Server: DML | Not a Bug (3154 days) | S3 | 5.6.22 | Any | Any | Inconsistent behaviors when column alias name(s) and column name are the same |
78025 | 2015-08-11 17:43 | 2015-08-11 21:31 | MySQL Server: Optimizer | Verified (3153 days) | S3 | 5.5, 5.6, 5.7 | Any | Any | Special IS NULL logic for 0000-00-00 does not work with merge views and SQ |
78099 | 2015-08-17 6:42 | 2015-08-17 7:53 | Connector / J | Closed (3147 days) | S3 | 5.1.36 | Any | Any | preparedStatement.executeBatch() return -2. |
78183 | 2015-08-24 9:01 | 2015-09-01 8:37 | MySQL Server: DML | Not a Bug (3132 days) | S3 | 5.6.22 | Any | Any | Similar query with aggregate functions returns inconsistent result |
78215 | 2015-08-26 2:17 | 2016-10-13 10:10 | MySQL Utilities | Can't repeat (2724 days) | S3 | Release-1.5.4 | Any | Any | why mysql-utilities sepeate filed to normal and blob,and mysqldbcopy very slow |
78276 | 2015-08-30 14:47 | 2015-10-06 18:15 | MySQL Server: Charsets | Closed (3097 days) | S3 | 5.7.8, 5.7.9, 5.6.26, 5.5.46 | Any | Any | MySQL accepts non-ascii in ascii columns |
78356 | 2015-09-07 16:02 | 2015-09-08 5:33 | MySQL Server: InnoDB storage engine | Duplicate (3125 days) | S2 | 5.6.26 | Any | Any | AUTO_INCREMENT generates duplicate values after server restart |
78360 | 2015-09-08 6:14 | 2015-09-08 12:29 | MySQL Server: DML | Verified (3125 days) | S3 | 5.6.22, 5.6.26 | Any | Any | More than 1 row is returned when using "having count(alias)" |
78389 | 2015-09-10 8:38 | 2017-11-21 14:52 | MySQL Server: Replication | Closed (3119 days) | S2 | 5.6.24,5.6.25,5.6.26 | Any | Any | 5.6.24: Lost data during master restart if partial transact has been downloaded |
78404 | 2015-09-11 9:11 | 2015-09-11 9:41 | MySQL Server: Parser | Verified (3122 days) | S3 | 5.6.22, 5.6.26 | Any | Any | subquery + "select * from...order by 2" (2 cols) fails with unknown column '2' |
78418 | 2015-09-12 12:34 | 2015-09-13 19:59 | MySQL Server: DML | Not a Bug (3120 days) | S3 | 5.6.22 | Any | Any | Inserted data in "col float" is truncated to 6 digits in "select * from t1" |
78460 | 2015-09-16 21:50 | 2015-09-17 7:25 | MySQL Workbench | Duplicate (3116 days) | S1 | 6.3.4 CE | Any | Any | Tried Opening Remote MYSQL connection |
78536 | 2015-09-24 6:50 | 2018-05-08 13:11 | MySQL Server: DML | Not a Bug (2152 days) | S2 | 5.6.22, 5.7.8 | Any | Any | group_concat returns incorrect result |
78638 | 2015-09-30 8:03 | 2016-06-18 21:28 | MySQL Server: Partitions | Closed (3049 days) | S3 | 8.0.0-m17 | Any | Any | parts.partition_alter2_1_1_innodb run into assertion |
78665 | 2015-10-01 12:08 | 2015-10-13 13:58 | MySQL Server: Optimizer | Closed (3090 days) | S2 | 5.7.8 | Any | Any | GCOLS: GCOL VALUE CHANGES WHEN SESSION CHANGES SQL_MODE |
78728 | 2015-10-07 1:10 | 2018-09-25 22:04 | MySQL Server: InnoDB storage engine | Closed (3074 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 |
78821 | 2015-10-13 15:28 | 2015-10-15 8:13 | MySQL Server: DML | Verified (3088 days) | S2 | 5.7.8, 5.7.10, 5.6.27, 5.5.47 | Any | Any | When comparing bigint and varchar constant, inconsistent results are returned |
78856 | 2015-10-16 8:42 | 2015-11-02 14:24 | MySQL Server: Errors | Closed (3080 days) | S3 | 5.6.28,5.7.10 | Any | Any | UNHEX INET6_ATON INET6_NTOA should emit warning when input is malformed |
78914 | 2015-10-22 6:08 | 2015-11-05 15:28 | MySQL Server: Data Types | Closed (3067 days) | S3 | 5.7.8, 5.7.9, 5.6.28, 5.5.47 | Any | Any | Flags info in result meta data is incorrect ( negative num w/ "UNSIGNED") |
78985 | 2015-10-27 18:40 | 2016-02-25 12:24 | MySQL Workbench: SQL Editor | Closed (3035 days) | S3 | 6.3.3 | Any | Any | Error formatting SQL query |
79063 | 2015-11-02 4:21 | 2015-11-03 14:41 | MySQL Server | Not a Bug (3069 days) | S3 | mysql 5.6.23 | Any | Any | Does row operation for ALL/ANY is supported or not? |
79114 | 2015-11-04 7:53 | 2015-11-18 18:24 | MySQL Server: DML | Closed (3054 days) | S3 | 5.7.8, 5.7.9 | Any | Any | IF(bool, date str, date str) throws ERROR in UPDATE |
79131 | 2015-11-05 5:34 | 2015-11-17 16:03 | MySQL Server: DML | Closed (3055 days) | S3 | 5.7.8, 5.7.9 | Any | Any | Get negative FOUND_ROWS() for UNION stmt |
79261 | 2015-11-13 7:37 | 2015-11-25 9:34 | MySQL Server: DML | Not a Bug (3047 days) | S3 | 5.7.8 | Any | Any | time compared with varchar, got different result for value in col or const |
79274 | 2015-11-13 15:03 | 2019-07-25 12:42 | MySQL Server: Locking | Can't repeat (1709 days) | S2 | 5.6, 5.7, 8.0 | Any | Any | CREATE TRIGGER etc is not able to get a SHARED_NO_WRITE metadata lock |
79284 | 2015-11-15 17:51 | 2015-12-16 1:00 | MySQL Workbench | No Feedback (3027 days) | S3 | 6.3.5 build 201 CE (64 bits) | Any | Any | Workbench throws unexpected exception on trigger editor |
79286 | 2015-11-16 3:34 | 2015-11-16 15:27 | MySQL Server: DML | Verified (3056 days) | S3 | 5.0/5.1/5.5/5.6/5.7 | Any | Any | Unexpected ERROR 1093 of delete w/ subquery in from stmt |
79409 | 2015-11-25 10:45 | 2015-11-30 8:11 | MySQL Server: DML | Verified (3042 days) | S3 | 5.7.8, 5.7.9, 5.5.48, 5.6.29 | Any | Any | compare type for datetime column and varchar column is inconsistent with doc |
79410 | 2015-11-25 13:13 | 2015-11-25 14:50 | MySQL Server: DML | Closed (3047 days) | S3 | 5.7.8 | Any | Any | "coalesce(0, 1.2345)" is not returning 0.0000 with aggregate func in select list |
79518 | 2015-12-04 7:42 | 2015-12-07 7:01 | MySQL Server: DML | Verified (3035 days) | S3 | 5.7.8, 5.5.48, 5.6.29, 5.7.11 | Any | Any | Get inconsistent string when converting year column to char |
79551 | 2015-12-08 3:55 | 2015-12-17 15:38 | MySQL Server: DML | Not a Bug (3025 days) | S3 | 5.7.8 | Any | Any | "select * from (select * from u1 ) u2 for update" is not locking rows in u1 |
79563 | 2015-12-09 6:47 | 2015-12-14 8:03 | MySQL Server: DML | Verified (3028 days) | S4 | 5.7.8 | Any | Any | After "update t1 set b(bigint) = a(date)", '0000000' are appended at tail |
79587 | 2015-12-10 7:40 | 2019-12-02 22:14 | MySQL Server: DML | Closed (1579 days) | S3 | 5.7.8, 5.7.9, 5.6.27, 5.5.48 | Any | Any | "UNIX_TIMESTAMP(count(a))" is expected to return 0, not NULL |
79628 | 2015-12-14 9:28 | 2018-11-13 13:00 | MySQL Server: Data Types | Not a Bug (1963 days) | S3 | 5.7.8 | Any | Any | Result type for max(float column) is FLOAT, while expecting DOUBLE |
79695 | 2015-12-18 4:25 | 2016-01-16 15:55 | MySQL Server: DML | Closed (2995 days) | S2 | 5.7.8, 5.6.28, 5.7.10 | Any | Any | True where clause doesn't return expected row, but empty set |
79757 | 2015-12-23 9:59 | 2015-12-23 10:59 | MySQL Server: InnoDB storage engine | Verified (3019 days) | S3 | 5.7.9, 5.6.28, 5.7.10 | Any | Any | Wrong result when search by utf8_bin partial-field key with order by desc |
79906 | 2016-01-11 3:55 | 2016-01-13 9:21 | MySQL Server: DML | Verified (2998 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 |
79908 | 2016-01-11 4:47 | 2019-12-09 21:21 | MySQL Server: DML | Closed (1572 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | date comparison has inconsistent behavior between = and CASE WHEN |
79913 | 2016-01-11 7:45 | 2019-12-09 21:49 | MySQL Server: DML | Closed (1572 days) | S3 | 5.7.8, 5.7.10 | Any | Any | Function FOUND_ROW() works incorrectly with previous select w/ aggr ret NULL |
79916 | 2016-01-11 9:34 | 2016-01-15 4:25 | MySQL Server: DML | Verified (2996 days) | S3 | 5.7.8, 5.6.28, 5.7.10 | Any | Any | Comparison gives inconsistent result for time(1) column and explicit cast result |
79924 | 2016-01-12 6:38 | 2016-01-21 23:04 | MySQL Server: DML | Closed (2990 days) | S2 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Func CONVERT and CONVERT(,BINARY) works incorrect w/ multi-byte+multi-rows |
79936 | 2016-01-12 15:34 | 2016-01-13 7:20 | MySQL Server: DML | Verified (2998 days) | S3 | 5.7.8, 5.6.28, 5.7.10 | Any | Any | "c1(NULL) > 1 && c2('00:00:00.0') = '00:00:00.000001'" returns NULL, not 0 |
79937 | 2016-01-12 15:42 | 2016-01-13 12:15 | MySQL Server: DML | Not a Bug (2998 days) | S3 | 5.6.27 | Any | Any | Incorrect record updated using ON DUPLICATE KEY UPDATE processing |
79947 | 2016-01-13 7:43 | 2016-01-13 9:44 | MySQL Server: DML | Duplicate (2998 days) | S3 | 5.7.8, 5.5.48, 5.6.28 | Any | Any | Func ROUND(num, c1(NULL)) doesn't return NULL |
80026 | 2016-01-18 9:29 | 2016-05-31 14:41 | MySQL Server: Query Cache | Closed (2859 days) | S2 | 5.6.27 | Any | Any | "The statement (1) has no open cursor" pops sometimes with prepared+query_cache |
80047 | 2016-01-19 9:59 | 2016-01-27 15:13 | MySQL Server: DML | Closed (2985 days) | S2 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Data rows lost after adding DISTINCT with substr() in select list |
80148 | 2016-01-26 7:41 | 2016-05-31 15:59 | MySQL Server: Optimizer | Closed (2859 days) | S3 | 5.7.8 | Any | Any | found_rows() is not working as expected without sql_calc_found_rows |
80394 | 2016-02-16 12:37 | 2016-03-07 9:33 | MySQL Server: Replication | Not a Bug (2944 days) | S2 | 5.7.11 | Any | Any | incorrect semi-sync replication status handling |
80471 | 2016-02-23 9:05 | 2017-02-17 12:20 | MySQL Cluster: Cluster (NDB) storage engine | Not a Bug (2597 days) | S3 | 7.x | Any | Any | Via a secondary unique index is automatically upgraded to a Shared read lock |
80651 | 2016-03-08 3:45 | 2016-04-07 5:46 | MySQL Server: Replication | Duplicate (2913 days) | S3 | 5.5 5.6 | Any | Any | larget rpl_semi_sync_master_timeout will affect performance |
80716 | 2016-03-13 9:53 | 2017-09-21 20:40 | MySQL Server: Memcached | Not a Bug (2920 days) | S3 | 5.7.10, 5.7.11 | Any | Any | JSON data not validated if inserted via InnoDB memcache plugin |
80733 | 2016-03-14 18:21 | 2016-05-23 23:36 | MySQL Cluster: Cluster (NDB) storage engine | Closed (2878 days) | S3 | 7.4.10 | Any | Any | Acc table scan may scan same row twice |
80939 | 2016-04-03 11:58 | 2017-11-13 12:34 | MySQL Server: InnoDB storage engine | Closed (2684 days) | S2 | 5.7.13 | Any | Any | Insert of GIS data into rtree hits assert in rtr_cur_restore_position_func() |
80987 | 2016-04-07 7:03 | 2016-04-07 7:56 | MySQL Server: Command-line Clients | Duplicate (2913 days) | S3 | 5.7 | Any | Any | mysqlslap auto-generate-sql-guid-primary |
81100 | 2016-04-15 17:05 | 2016-06-13 13:50 | MySQL Workbench: Migration | Closed (2846 days) | S3 | 6.3.6 | Any | Any | Workbench Migration Wizard fails for generated columns |
81196 | 2016-04-26 1:40 | 2018-09-27 23:41 | Connector / J | Closed (2059 days) | S2 | 5.1.38+ | Any | Any | Connector/J Not Following Database character set |
81235 | 2016-04-29 11:43 | 2016-05-05 14:05 | MySQL Server: Optimizer | Duplicate (2885 days) | S3 | 5.6 | Any | Any | Incorrect sorting temporary results after Where |
81254 | 2016-05-01 7:53 | 2016-05-02 10:10 | MySQL Server: DML | Verified (2888 days) | S2 | 5.6, 5.6.30, 5.7.12 | Any | Any | Using INSERT_ID local variable, makes REPLACE fail when there is a duplicate key |
81260 | 2016-05-01 18:05 | 2016-08-24 16:15 | MySQL Server: Document Store: MySQL Shell | Closed (2774 days) | S2 | 5.7.12 | Any | Any | mysqlsh shows TIME columns as boolean values |
81302 | 2016-05-04 6:41 | 2023-04-09 11:55 | MySQL Server: DML | Verified (2886 days) | S3 | 5.7.8, 5.6.30, 5.7.12 | Any | Any | w/o group by, query with column in having clause not in select list, succeeds |
81533 | 2016-05-23 4:25 | 2016-05-23 7:24 | MySQL Server: DML | Verified (2867 days) | S3 | 5.7.8, 5.5.49, 5.6.30, 5.7.12 | Any | Any | Get different results when comparing YEAR(4) with 2-digit const and 2-digit col |
81638 | 2016-05-30 7:40 | 2019-12-16 22:46 | MySQL Server: DML | Closed (1565 days) | S2 | 5.7.8, 5.5.49, 5.6.30, 5.7.12 | Any | Any | Function substr with order by gives incorrect result |
81684 | 2016-06-02 6:05 | 2016-06-02 13:22 | MySQL Server: DML | Verified (2857 days) | S1 | 5.7.8, 5.6.30, 5.7.12 | Any | Any | select + where exists( select + group by + limit) works incorrectly |
81767 | 2016-06-08 4:44 | 2016-06-08 7:38 | MySQL Server: DML | Verified (2851 days) | S3 | 5.7.8, 5.6.30,5.6.31, 5.7.12, 5.7.13 | Any | Any | Comparison result for column w/ YEAR(4) and const w/ 2 digits is incorrect |
81852 | 2016-06-15 5:56 | 2016-06-15 8:25 | MySQL Server | Open (2844 days) | S4 | 5.6.27 | Any | Any | Provide option to not allow client access during InnoDB recovery |
81896 | 2016-06-17 4:26 | 2016-06-20 14:32 | MySQL Server: JSON | Not a Bug (2839 days) | S3 | 5.7.13 | Any | Any | Can't use JSON when json name has dash inside |
81940 | 2016-06-21 3:31 | 2019-12-24 13:28 | MySQL Server: DML | Closed (1557 days) | S3 | 5.7.8, 5.5.50, 5.6.31,5.7.13 | Any | Any | Order by substr() returns incorrect result |
81963 | 2016-06-22 2:37 | 2019-10-24 10:46 | MySQL Server: DML | Not a Bug (2828 days) | S3 | 5.7.8, 5.6.31, 5.7.13 | Any | Any | Get incorrect result for -2 into unsigned column and cast -2 to unsigned |
82283 | 2016-07-19 15:13 | 2017-07-14 14:27 | MySQL Server: Replication | Closed (2450 days) | S3 | 5.6,5.7, 5.7.13 | Any | Any | main.mysqlbinlog_debug fails with a LeakSanitizer error |
82347 | 2016-07-26 13:50 | 2016-11-26 18:48 | MySQL Server: Command-line Clients | Closed (2794 days) | S3 | 5.7.5 | Any | Any | Client libraries not buildable on Solaris 11 with Sun Studio using libCstd |
82562 | 2016-08-12 5:12 | 2016-08-12 7:56 | MySQL Server: DML | Not a Bug (2786 days) | S3 | 5.6.31,5.7.14 | Any | Any | exists (select max(id) from t3 where id=2) produced the undesired result |
82592 | 2016-08-16 3:55 | 2016-09-02 13:11 | MySQL Server: InnoDB storage engine | Not a Bug (2775 days) | S3 | 5.7.14 | Any | Any | MySQL InnoDB update locking |
82704 | 2016-08-24 8:35 | 2017-10-06 18:19 | MySQL Server: DDL | Closed (2366 days) | S3 | 8.0.0 | Any | Any | alter table+insert+drop db hang |
83139 | 2016-09-25 11:32 | 2020-09-15 7:54 | MySQL Server: DML | Verified (2732 days) | S4 | 8.0 | Any | Any | Resultset for insert, update and delete |
83148 | 2016-09-26 8:57 | 2023-04-16 19:29 | MySQL Server: Optimizer | Closed (2663 days) | S3 | 5.5 | Any | Any | IF and friends gives wrong type for signed and unsigned integer |
83286 | 2016-10-06 12:54 | 2020-01-02 22:57 | MySQL Server: DML | Closed (1548 days) | S3 | 5.7 | Any | Any | Invalid error for Subquery returns more than 1 row |
83418 | 2016-10-18 0:46 | 2016-10-18 8:51 | MySQL Server: Row Based Replication ( RBR ) | Verified (2719 days) | S5 | 5.6, 5.6.34 | Any | Any | When binlog_row_image is MINIMAL, some updates queries logs redundant columns |
83558 | 2016-10-27 3:16 | 2016-10-27 12:38 | MySQL Server: DML | Not a Bug (2710 days) | S3 | 5.7.16 | Any | Any | Is this a wrong stage? |
83958 | 2016-11-24 21:34 | 2016-11-25 15:08 | MySQL Server: Connection Handling | Not a Bug (2681 days) | S3 | 5.7.16 | Any | Any | BLOB size should not be restricted by the server-side max_allowed_packet param. |
83999 | 2016-11-29 8:08 | 2017-01-27 16:35 | MySQL Server: Charsets | Closed (2664 days) | S3 | 8.0.1 | Any | Any | LIKE function gives wrong result for accented characters |
84037 | 2016-12-02 6:51 | 2021-09-09 14:05 | MySQL Server: Stored Routines | Verified (2674 days) | S3 | 5.7.17, 5.7.16 | Any | Any | Error on insert JSON data to a table with generated columns from a SP |
84059 | 2016-12-05 11:26 | 2016-12-27 8:56 | Connector / J | Not a Bug (2649 days) | S2 | 6.0.5 | Any | Any | Driver is stripping off fractional part of TIME when calling ResultSet.getObject |
84077 | 2016-12-06 13:19 | 2018-01-02 9:52 | MySQL Server: Stored Routines | Closed (2506 days) | S2 | 5.7.11 | Any | Any | CURRENT_TIMESTAMP produces zeros in TRIGGER |
84153 | 2016-12-09 19:05 | 2017-07-17 12:30 | MySQL Server: Replication | Closed (2485 days) | S2 | 5.7.18 | Any | Any | ASSERT "!contains_gtid(gtid)" rpl_gtid_owned.cc:94 Owned_gtids::add_gtid_owner |
84362 | 2016-12-28 17:11 | 2016-12-28 17:52 | MySQL Server: Partitions | Verified (2648 days) | S3 | 5.6, 5.7,8.0 | Any | Any | PARTITION BY LIST COLUMNS allows unsupported data types |
84408 | 2017-01-04 18:36 | 2017-04-04 19:08 | Connector / Python | Closed (2559 days) | S3 | Any | Any | Django 1.9+ bulk insert compatibility fix. (contribution) | |
84537 | 2017-01-17 14:11 | 2017-10-24 14:31 | MySQL Server: Optimizer | Closed (2397 days) | S3 | 8.0.1 | Any | Any | GROUP BY DESC gives wrong result when groups on DECIMAL and sees a NULL |
84557 | 2017-01-18 16:50 | 2017-01-19 19:07 | MySQL Server: Errors | Verified (2626 days) | S4 | 5.6 and 5.7 | Any | Any | Hide specific warnings from SHOW WARNINGS. |
84727 | 2017-01-31 8:16 | 2017-06-26 15:59 | MySQL Server: Group Replication | Closed (2468 days) | S2 | 5.7.17 | Any | Any | GR: Partitioned Node Should Get Updated Status and not accept writes |
84748 | 2017-01-31 16:57 | 2017-02-06 7:29 | MySQL Server: Replication | Verified (2608 days) | S4 | 5.7 | Any | Any | Request transaction GTID in OK packet on COMMIT(without needing a round-trip). |
84934 | 2017-02-10 4:23 | 2017-02-10 8:35 | MySQL Server: Replication | Verified (2604 days) | S3 | 5.7.17 | Any | Any | Column order is not important for replication to function |
85179 | 2017-02-24 19:28 | 2017-06-01 16:53 | MySQL Server: InnoDB storage engine | Closed (2570 days) | S3 | 8.0.1-dmr | Any | Any | Assert in sql/field.cc:... virtual String* Field_varstring::val_str |
85317 | 2017-03-06 8:07 | 2022-04-07 22:21 | Connector / J | Closed (722 days) | S3 | MySQL 5.6.35 Connector/J 5.1.40 | Any | Any | execute Batch will throw null pointer exception where the column is Blob! |
85447 | 2017-03-14 13:09 | 2018-10-25 9:37 | MySQL Server: Replication | Closed (1982 days) | S3 | 5.7, 5.7.17 | Any | Any | Slave SQL thread locking issue on a certain XA workload on master |
85641 | 2017-03-27 9:17 | 2017-03-27 15:49 | MySQL Server: Data Types | Verified (2559 days) | S3 | 5.7.17 | Any | Any | MySQL is not consequent in handling non existing time between 2 and 3 o'clock |
85749 | 2017-03-31 16:45 | 2018-05-15 18:45 | MySQL Server: Documentation | Closed (2145 days) | S3 | 5.7 | Any | Any | Manual does NOT explain gap locks set by SELECT ... FOR UPDATE |
85781 | 2017-04-04 12:32 | 2017-11-08 10:23 | MySQL Server: Group Replication | Closed (2384 days) | S3 | 5.7.19 | Any | Any | GR ALLOWS OPERATIONS ON NON-COMPLAINT TABLES THROUGH MYSQLBINLOG |
85945 | 2017-04-14 8:01 | 2017-04-17 8:08 | MySQL Server: Optimizer | Verified (2538 days) | S3 | 5.7.13, 5.7.18 | Any | Any | SQL optimizer fail to check IS NULL condition |
86046 | 2017-04-23 7:18 | 2017-08-03 3:05 | MySQL Server: Query Cache | Won't fix (2457 days) | S2 | 5.6, 5.6.36 | Any | Any | FROM sub query is cached by mistake |
86047 | 2017-04-23 7:58 | 2017-05-02 17:23 | MySQL Server: Query Cache | Closed (2523 days) | S2 | 5.6,5.7,8.0, 5.6.36 | Any | Any | FROM sub query with 'group by' is cached by mistake |
86422 | 2017-05-23 9:00 | 2017-10-13 17:00 | MySQL Server: InnoDB storage engine | Closed (2359 days) | S2 | 8.0.2 | Any | Any | lock0lock.cc: ((m_mode - (0xFUL & m_mode)) - (0xF0UL & m_mode) - (256 & m_mode)) |
86865 | 2017-06-29 8:09 | 2020-10-20 12:18 | MySQL Server: InnoDB storage engine | Closed (1257 days) | S3 | 5.7, 8.0 | Any | Any | InnoDB does unnecessary work when extending a tablespace |
86900 | 2017-07-03 6:51 | 2017-07-04 7:33 | MySQL Server: DML | Not a Bug (2460 days) | S3 | 5.7.13 | Any | Any | load data result mismatch when escaped by character is 't' |
86930 | 2017-07-04 13:31 | 2017-07-11 19:14 | MySQL Server: Information schema | Verified (2460 days) | S3 | 5.6.29, 5.7.18 | Any | Any | Wrong results for queries with row constructors and information_schema |
87000 | 2017-07-10 15:30 | 2017-08-21 6:22 | Connector / J | Can't repeat (2412 days) | S3 | mysql-connector-java-5.1.42 | Any | Any | com.mysql.jdbc.Driver showing Null pointer Exception for mysqlconnectorjava-5.1 |
87100 | 2017-07-17 20:13 | 2018-07-09 19:21 | MySQL Server: Errors | Closed (2090 days) | S3 | 5.7.17, 8.0, 5.7.18 | Any | Any | "Incorrect string value" is diplayed instead of "Data too long" sometimes. |
87300 | 2017-08-03 10:18 | 2017-11-09 11:24 | Shell General / Core Client | Closed (2332 days) | S2 | mysqlsh Ver 1.0.10 for Linux on x86_64 | Any | Any | mysql-shell dba.checkInstanceConfiguration() |
87412 | 2017-08-14 13:25 | 2018-10-25 12:07 | MySQL Server: Documentation | Closed (1983 days) | S3 | 5.6, 5.7 | Any | Any | The behaviour of the triggers after "INSERT ... ON DUPLICATE KEY UPDATE" |
87526 | 2017-08-24 11:55 | 2017-08-24 12:10 | MySQL Server: XA transactions | Verified (2409 days) | S3 | 5.7.19, 8.0.2 | Any | Any | The output of 'XA recover convert xid' is not useful |
87711 | 2017-09-08 15:08 | 2018-03-19 17:40 | MySQL Server: DML | Closed (2202 days) | S3 | 5.7.17 | Any | Any | CREATE TABLE AS ... UNION fails with DATE column |
87836 | 2017-09-22 8:41 | 2018-02-12 20:26 | MySQL Server: XA transactions | Closed (2275 days) | S2 | mysql-5.7.17, 5.7.19 | Any | Any | XA COMMIT/ROLLBACK rejected by non-autocommit session with no active transaction |
87939 | 2017-10-02 9:00 | 2018-10-10 12:57 | MySQL Server: DML | Closed (2367 days) | S2 | 8.0.3 | Any | Any | Combining CTE and Window Function gives wrong result |
87940 | 2017-10-02 11:18 | 2017-10-03 18:06 | MySQL Server: InnoDB storage engine | Not a Bug (2369 days) | S3 | 5.5, 5.6, 5.7 | Any | Any | InnoDB fails to discard record lock when discarding an index page |
88003 | 2017-10-05 22:08 | 2019-01-22 17:29 | MySQL Server: MyISAM storage engine | Closed (2214 days) | S2 | 5.7.19 | Any | Any | REPAIR TABLE for MyISAM table repeatedly causes index corruption |
88057 | 2017-10-11 12:42 | 2018-06-13 12:32 | MySQL Server: Row Based Replication ( RBR ) | Verified (2361 days) | S3 | 5.7.19, 8.0.3 | Any | Any | Intermediary slave does not log master changes with binlog_rows_query_log_events |
88223 | 2017-10-25 11:48 | 2019-01-08 16:10 | MySQL Server: Row Based Replication ( RBR ) | Verified (1907 days) | S3 | 5.7.19, 8.0.3, 5.7.24, 8.0.13 | Any | Any | Replication with no tmpdir space and InnoDB as tmp_storage_engine can break |
88321 | 2017-11-01 19:19 | 2020-07-29 15:58 | MySQL Server: InnoDB storage engine | Closed (1339 days) | S2 | 5.6.35, 5.6.38, 5.7.20, 8.0.12 | Any | Any | Regression: InnoDB AUTO_INCREMENT produces same value twice |
88780 | 2017-12-06 10:20 | 2018-09-25 22:07 | MySQL Server: DML | Verified (2305 days) | S6 | 5.5.58 | Any | Any | Assertion `is_started()' failed. |
88827 | 2017-12-08 1:30 | 2018-05-31 13:08 | MySQL Server: InnoDB storage engine | Verified (2188 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 |
89068 | 2017-12-27 17:09 | 2018-04-25 18:19 | MySQL Workbench | Closed (2165 days) | S3 | 6.3.10 | Any | Any | BIT column incorrectly used by the script generator |
89139 | 2018-01-08 20:06 | 2018-04-16 11:11 | MySQL Server: C API (client library) | Closed (2174 days) | S3 | 5.7.20, 8.0.3 | Any | Any | mysqlclient does not return correct mysql_insert_id after ping() |
89141 | 2018-01-08 22:07 | 2018-04-11 16:23 | MySQL Server: Group Replication | Duplicate (2179 days) | S2 | 5.7.20,8.0.3 | Any | Any | Error in Group Replication caused by bad Write Set tracking. |
12767 | 2005-08-23 22:54 | 2005-08-23 22:58 | MySQL Server | Duplicate (6793 days) | S2 | last | Any (any) | Any | what are you doing? |
12768 | 2005-08-23 22:54 | 2005-08-23 22:59 | MySQL Server | Duplicate (6793 days) | S2 | last | Any (any) | Any | what are you doing? |
12769 | 2005-08-23 22:54 | 2005-08-23 22:59 | MySQL Server | Duplicate (6793 days) | S2 | last | Any (any) | Any | what are you doing? |
13460 | 2005-09-24 14:22 | 2019-10-10 21:42 | MySQL Server: DML | Won't fix (1632 days) | S4 | * | Any (*) | Any | Allow delayed insert with on duplicate key update |
13569 | 2005-09-28 14:09 | 2005-09-28 15:00 | MySQL Server: Optimizer | Not a Bug (6757 days) | S3 | all | Any (all) | Any | User friendly |
13617 | 2005-09-29 17:52 | 2010-12-15 10:58 | MySQL Server: InnoDB storage engine | Open (6741 days) | S4 | Any | Any | enhancement to fillfactor | |
14050 | 2005-10-15 17:52 | 2018-09-09 20:45 | MySQL Server: DML | Verified (4851 days) | S4 | Any | Any (Any) | Any | Blocking some replication statements. |
14547 | 2005-11-01 19:08 | 2022-12-04 20:45 | MySQL Server: C API (client library) | Verified (6706 days) | S4 | all | Any (all) | Any | mysql_affected_rows() and mysql_info() client calls not made upon error |
15062 | 2005-11-18 23:03 | 2005-11-19 18:20 | Connector / J | Can't repeat (6705 days) | S2 | 3.1.11 | Any (Any) | Any | Memory/Object leak on inserts |
15131 | 2005-11-22 11:44 | 2011-02-16 23:43 | MySQL Server: Optimizer | Verified (5477 days) | S4 | 4.1,5.0 | Any | Any | On-disk temporary tables created for GROUP BY should use indexes |
15454 | 2005-12-03 4:38 | 2011-03-29 18:35 | MySQL Server | Closed (4749 days) | S5 | all | Any (all) | Any | watch |
16689 | 2006-01-20 22:31 | 2012-05-18 20:19 | MySQL Server | Duplicate (6632 days) | S3 | 4.1.2 and up | Any (all) | Any | LAST_INSERT_ID() not stable within statement |
16766 | 2006-01-25 2:40 | 2012-05-18 20:19 | MySQL Server: Replication | Duplicate (6638 days) | S2 | 4.1.16, 5.0.18 | Any (all) | Any | binlog stores updates to already-dropped table |
17147 | 2006-02-06 6:11 | 2011-03-29 18:38 | MySQL Server | Closed (4749 days) | S4 | NEWS | Any (ALL) | Any | SQL MODE FEATURE |
18350 | 2006-03-20 10:43 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5032 days) | S3 | 5.0, 5.1 | Any (All) | Any | Use consistent read in CREATE ... SELECT... if innodb_locks_unsafe_for_binlog |
18768 | 2006-04-04 8:27 | 2006-04-04 8:48 | MySQL Server | Duplicate (6569 days) | S3 | 5.1.7 | Any (*) | Any | Cannot create foreign keys |
18827 | 2006-04-06 5:46 | 2006-04-06 10:48 | MySQL Server | Not a Bug (6567 days) | S2 | 5.0 | Any (all) | Any | It is very slowly when the where statment include function |
19205 | 2006-04-19 20:44 | 2011-02-16 23:43 | MySQL Server: Prepared statements | Can't repeat (5221 days) | S3 | 4.1, 5.0-BK | Any (any) | Any | server provides different metadata in ps-protocol and non-ps-protocol mode |
21131 | 2006-07-19 2:27 | 2011-02-16 23:43 | MySQL Server: Locking | Closed (5488 days) | S4 | 4.1.20 | Any | Any | SHOW TABLE STATUS blocked by write lock |
21852 | 2006-08-27 14:36 | 2008-06-23 11:54 | MySQL Server | Can't repeat (5758 days) | S3 | 5.0.22 | Any (*) | Any | INSERT statement causing table corruption on v5 but not on v4 |
22552 | 2006-09-21 16:14 | 2018-09-25 21:44 | MySQL Server: Tests | No Feedback (4197 days) | S7 | 5.1.14, 5.1.65 | Any (Sun Solaris 10 Sparc) | Any | 5.1.12-beta build on Solaris 10 - client_xml test fail with core dump |
23212 | 2006-10-12 12:15 | 2019-07-30 7:52 | MySQL Server: DML | Verified (6352 days) | S4 | 5.0 | Any | Any | allow missing data = NULL in LOAD DATA INFILE |
23266 | 2006-10-13 16:35 | 2013-05-30 7:07 | Connector / ODBC | Closed (3956 days) | S2 | 3.x | Any (all) | Any | Inability to execute statements with numeric parameters in a german locale |
24769 | 2006-12-02 0:30 | 2013-06-14 19:23 | MySQL Server | Verified (4757 days) | S4 | 5.1 | Any (all) | Any | Delayed queries |
24950 | 2006-12-11 9:24 | 2011-02-16 23:43 | MySQL Server: Errors | Verified (6290 days) | S4 | 5.0 | Any (Any) | Any | Using a incorrect message file not prevented |
25010 | 2006-12-12 14:34 | 2011-02-16 23:43 | MySQL Server: Data Types | Verified | S4 | 5.0 | Any (any) | Any | There is no way to display TIMESTAMP values in UTC without setting variables |
25379 | 2007-01-03 6:16 | 2007-02-22 11:19 | Connector / J | Closed (6245 days) | S3 | 3.1.10 | Any (ANY) | Any | INOUT parameters add extra delimiters for the char ' (single quote) |
25820 | 2007-01-24 11:15 | 2012-05-18 20:19 | MySQL Server: Locking | Duplicate (6255 days) | S3 | 5.0.36BK | Any (*) | Any | CPU pegged at 100% after optimizing table belonging to merge set |
25953 | 2007-01-30 16:50 | 2012-09-13 10:39 | Connector / NET | No Feedback (6196 days) | S2 | 5.0.3 | Any (Server 2003) | Any | ASP.NET page returns "object reference not set" when update is attempted |
26424 | 2007-02-15 20:52 | 2007-03-13 20:25 | MySQL Server: General | Can't repeat (6226 days) | S4 | All | Any (All) | Any | Add ability to look at a database based on a point in time |
26544 | 2007-02-21 20:45 | 2013-02-21 21:55 | Connectors: DBD::mysql ( Perl ) | Unsupported (4054 days) | S2 | 4.001 | Any (any) | Any | Wrong COLUMN_DEF value for NOT NULL field |
26799 | 2007-03-02 16:02 | 2011-02-16 23:43 | MySQL Server: Data Types | Verified (5649 days) | S4 | * | Any (*) | Any | Char and binary types without padding/stripping |
27234 | 2007-03-17 4:48 | 2022-12-04 20:45 | MySQL Server: Merge storage engine | Verified (6218 days) | S4 | Any | Any | INSERT into Merge Table implicitly locks all underlying tables | |
27403 | 2007-03-23 16:28 | 2007-10-02 6:40 | Connector / ODBC | Closed (6023 days) | S2 | 3.51 and 5.0 | Any | Any | UTF8 support in db using the ODBC connector 5.0 to connect MsAccess to MySQL 4.1 |
27824 | 2007-04-14 17:11 | 2007-12-22 18:05 | Eventum | No Feedback (5942 days) | S3 | 2.0 beta 1 | Any | Any | 'DB Error: unknown error' |
28241 | 2007-05-04 13:51 | 2022-12-04 20:45 | MySQL Server | Verified (6162 days) | S4 | 5.0.42,5.1BK | Any | Any | QCache stores dublicates |
28332 | 2007-05-09 13:07 | 2007-06-23 11:57 | MySQL Server: Compiling | No Feedback (6124 days) | S3 | 5.0 | Any | Any | Server compiled with -DNEW_HASH_FUNCTION fails ctype_utf8 |
28353 | 2007-05-10 14:27 | 2007-05-10 16:39 | MySQL Server: Documentation | Not a Bug (6168 days) | S3 | any | Any | Any | begin does not cause implicit commit |
28402 | 2007-05-13 17:21 | 2007-05-14 9:03 | MySQL Server | Not a Bug (6164 days) | S3 | Any | Any | date format | |
28422 | 2007-05-14 18:35 | 2011-02-16 23:43 | MySQL Server: Command-line Clients | Verified (5959 days) | S3 | 5.0.40, 5.5.6 | Any | Any | mysql client does not recognize bit values |
28446 | 2007-05-15 14:51 | 2007-05-16 12:44 | MySQL Server | Closed (6162 days) | S1 | 5.0.41 | Any | Any | wrong affected rows when using insert into ... on duplicate key ... |
28697 | 2007-05-26 3:39 | 2007-05-26 5:34 | MySQL Server: Data Types | Not a Bug (6152 days) | S2 | 5.0.41 | Any | Any | UNIQUE inded on VARCHAR(X) column disallowes proper values on insert. |
29351 | 2007-06-26 4:57 | 2007-07-26 9:58 | MySQL Server | No Feedback (6091 days) | S1 | 5.0.16 | Any | Any | Archive tables corrupt when run "show table status" |
29492 | 2007-07-02 16:50 | 2015-01-09 9:58 | MySQL Enterprise Monitor: Web | Closed (3367 days) | S4 | 1.1.1 | Any | Any | Same color for servers across graphs |
29781 | 2007-07-13 2:24 | 2015-10-08 8:32 | MySQL Server | Verified (6104 days) | S4 | 5.0.41 | Any | Any | Adding in Pattern Replace (RegExp) for MySQL Engine |
29869 | 2007-07-18 13:41 | 2007-07-18 16:44 | MySQL Server: Security: Privileges | Not a Bug (6099 days) | S2 | 5.0.41 | Any | Any | Users with no privileges can do operations |
29956 | 2007-07-22 11:48 | 2007-07-22 15:40 | MySQL Server: Optimizer | Won't fix (6095 days) | S4 | All | Any | Any | Explain should optionally execute the query and return the execution path |
30115 | 2007-07-28 13:42 | 2022-12-04 20:45 | MySQL Server: DDL | Verified | S3 | 5.0-bk,5.1-bk | Any | Any | crash during RENAME TABLE breaks replication |
30132 | 2007-07-31 0:29 | 2016-02-25 12:24 | MySQL Server: Stored Routines | Not a Bug (6079 days) | S2 | Any | Any | CREATE ROUTINE privilege not needed to create/alter stored procedures | |
30784 | 2007-09-04 9:33 | 2022-12-04 20:45 | MySQL Server: DDL | Verified (5532 days) | S4 | 5.X | Any | Any | CREATE/ALTER TABLE table option - OPTIMIZE_TABLE_ORDER BY. An optimization hint. |
30824 | 2007-09-05 10:20 | 2022-12-04 20:45 | MySQL Server: DDL | Verified (5532 days) | S4 | 5.X | Any | Any | COLUMN_FORMAT=FIXED columns in ROW_FORMAT=DYNAMIC MyISAM tables? |
30868 | 2007-09-06 15:57 | 2007-09-06 15:57 | MySQL Server | Open | S4 | 5.0 | Any | Any | feature request: subdatabases |
31121 | 2007-09-20 22:02 | 2014-12-09 19:16 | MySQL Proxy: Scripts | Verified (3398 days) | S4 | 0.6.0, 0.8.5 | Any | Any | rw-splitting script does not handle temporary tables |
31376 | 2007-10-03 15:52 | 2021-05-02 20:45 | MySQL Cluster: Replication | Duplicate (4901 days) | S2 | mysql-5.1-telco-6.2 | Any | Any | DDL during setup of cluster replication give wrong position |
31457 | 2007-10-08 15:46 | 2011-02-16 23:43 | Connector / J | Duplicate (5506 days) | S3 | Jdbc-5.0.7 | Any (atleast Windows and Linux) | Any | JDBC SQL Escape processing {fn ... confused by escaped quotes |
31603 | 2007-10-15 11:20 | 2012-05-18 20:19 | MySQL Server: Row Based Replication ( RBR ) | No Feedback (5977 days) | S1 | mysql-5.1-wl2325-5.0-drop6 | Any | Any | Master crashes during execution of rpl_user_variables test case |
31643 | 2007-10-16 15:26 | 2022-12-12 5:54 | MySQL Server: Stored Routines | Verified (5595 days) | S3 | 5.1.22 | Any | Any | Setting an event to 'disable on slave' disables it on the master |
31686 | 2007-10-18 7:07 | 2007-11-18 8:23 | MySQL Server: Replication | No Feedback (5976 days) | S1 | 5.0.45 | Any | Any | sql syntax error on replication slave |
31756 | 2007-10-22 15:36 | 2007-10-22 16:08 | MySQL Server: Replication | Not a Bug (6003 days) | S2 | 4.1.11 | Any | Any | binlog-ignore-db is ignored in certain cases |
31757 | 2007-10-22 15:42 | 2013-03-03 20:45 | MySQL Server: Federated storage engine | Verified (5999 days) | S2 | 5.0.50, 5.1.23,6.0.3 | Any | Any | Federated tables break replication |
31840 | 2007-10-25 10:00 | 2007-12-14 17:42 | MySQL Server: Replication | Not a Bug (5950 days) | S3 | 4.1,5.0 | Any | Any | Slave displays queries that should be filtered out in SHOW PROCESSLIST |
31988 | 2007-10-31 14:51 | 2008-04-20 9:36 | MySQL Server: Command-line Clients | No Feedback (5822 days) | S3 | 5.0.27 | Any | Any | mysqlhotcopy should FLUSH TABLES on _copy/_copy_old, else disk space not freed |
32095 | 2007-11-05 7:26 | 2008-01-23 16:28 | MySQL Server | Closed (5910 days) | S3 | 5.1.22 | Any | Any | data has different result for double type with/without ps-protocol |
32587 | 2007-11-21 17:56 | 2007-11-22 15:07 | Connector / J | Duplicate (5972 days) | S1 | 5.1.5 | Any | Any | ConnectionWrapper#prepareStatement(String arg0, int arg1) always returns null |
32782 | 2007-11-27 17:57 | 2009-05-07 14:27 | MySQL Server: Backup | Won't fix (5440 days) | S3 | 6.0 | Any | Any | User lock hash fails to find lock |
32826 | 2007-11-28 19:58 | 2007-11-30 15:58 | MySQL Server: Security: Privileges | Duplicate (5964 days) | S3 | 6.0.4-alpha-debug | Any | Any | Privileges: I can CREATE ... LIKE without SELECT privilege |
33083 | 2007-12-08 1:22 | 2012-06-20 16:48 | MySQL Server: Stored Routines | Closed (4300 days) | S1 | 5.0, 5.1, 5.2 | Any | Any | Stored Function: error and crash if a temporary table is dropped in a loop |
33370 | 2007-12-19 16:28 | 2007-12-25 18:17 | MySQL Server | Not a Bug (5939 days) | S3 | * | Any | Any | wrong update row count |
33393 | 2007-12-20 8:10 | 2021-05-02 20:45 | MySQL Cluster: Replication | Verified (5839 days) | S2 | mysql-5.1-telco-6.3 | Any | Any | Didn't write conflict resolution exception table when missing reqired columns |
33411 | 2007-12-20 16:24 | 2021-05-02 20:45 | MySQL Cluster: Replication | Verified (5839 days) | S2 | mysql-5.1-telco-6.3 | Any | Any | Didn't write exception table if reqired columns in different order |
33504 | 2007-12-24 20:27 | 2012-09-13 11:02 | Connector / NET | No Feedback (5900 days) | S1 | 5.1.4 | Any | Any | Problem accesing Datareader with MySQL .NET Connector 5.1.4 |
33580 | 2007-12-29 10:48 | 2007-12-29 16:49 | MySQL Websites: bugs.mysql.com | Closed (5935 days) | S3 | Any | Any | Bugs system does not accept file attachments | |
33928 | 2008-01-18 18:34 | 2013-02-20 22:18 | Connectors: DBD::mysql ( Perl ) | Unsupported (4055 days) | S2 | 4.006 | Any | Any | more_results incorrectly interprets value returned by mysql_next_result() |
34228 | 2008-02-01 13:55 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5899 days) | S4 | * | Any | Any | Bulk Update statement |
34258 | 2008-02-03 0:51 | 2008-03-04 12:01 | MySQL Query Browser | No Feedback (5869 days) | S3 | 1.2.12 | Any | Any | Regex Importer Can only handle 10 expression segments |
34280 | 2008-02-04 14:20 | 2012-04-10 18:30 | MySQL Server: DDL | Closed (4371 days) | S3 | 5.0, 5.1, 6.0 BK | Any | Any | CREATE TABLE fails if in NO_ZERO_DATE SQL mode |
34327 | 2008-02-05 19:14 | 2011-02-16 23:43 | MySQL Server: Compiling | Can't repeat (5408 days) | S3 | 5.0.51, 5.0 BK | Any | Any | DBUG_PRINT() missing semicolon causes Community compile failure |
34393 | 2008-02-07 19:50 | 2008-02-08 7:36 | MySQL Server: Maria storage engine | Not a Bug (5894 days) | S2 | 5.1.23 maria preview | Any | Any | all table engines treated like transactional |
34414 | 2008-02-08 13:07 | 2013-04-14 20:45 | MySQL Server: InnoDB storage engine | Verified (5069 days) | S4 | 5.1.23 | Any | Any | SELECT hangs in InnoDB while running massive UPDATEs |
34594 | 2008-02-15 13:10 | 2018-02-08 22:37 | MySQL Server: DML | Won't fix (2241 days) | S3 | 5.0.56, 5.0.66a | Any | Any | 'handler open' can refer to outdated table names until flush tables is executed |
34693 | 2008-02-20 14:50 | 2008-02-20 15:23 | MySQL Server: Data Types | Closed (5882 days) | S2 | 5.1.23 | Any | Any | DECIMAL(65) colum can accept out of range value in TRADITIONAL mode |
34698 | 2008-02-20 17:28 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | No Feedback (3130 days) | S3 | mysql-5.1 | Any | Any | Node restart in cluster with thousands of tables is very slow |
34781 | 2008-02-24 6:36 | 2013-03-03 20:45 | MySQL Server: Merge storage engine | Verified (5878 days) | S4 | 5.0.46, 5.0.54 | Any | Any | create table ... engine=merge should warn user when non-MyISAM tables are used |
34817 | 2008-02-25 19:31 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Duplicate (4252 days) | S3 | mysql-5.1-telco-6.2 | Any | Any | nested DECLARE CONTINUE HANDLER FOR SQLSTATE '23000' is not triggered |
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 |
35089 | 2008-03-05 19:55 | 2008-03-05 21:48 | MySQL Server | Not a Bug (5868 days) | S3 | 5.1.22-rc-community-log | Any | Any | LAST_INSERT_ID returns 0 on using INSERT... ON DUPLICATE KEY UPDATE ... |
35352 | 2008-03-17 21:40 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (4915 days) | S1 | 5.0 5.1 6.0 | Any | Any | If InnoDB crashes with UNDO slots full error the error persists on restart |
35376 | 2008-03-18 7:31 | 2008-05-08 16:34 | MySQL Server: DML | Not a Bug (5804 days) | S3 | 5.1.22 | Any | Any | Value of insert_id automatically resets to 0 after inserting 1st row |
36002 | 2008-04-11 18:21 | 2012-01-27 4:14 | MySQL Server: Prepared statements | Closed (4445 days) | S3 | 5.0,5.1,6.0 BK | Any | Any | Prepared statements: if a view used in a statement is replaced, bad data |
36101 | 2008-04-15 20:21 | 2008-04-30 7:25 | MySQL Server: Row Based Replication ( RBR ) | Closed (5812 days) | S2 | 5.1.23, 6.0.4 | Any | Any | Row-based replication drops events when using multiple tables |
36205 | 2008-04-18 10:29 | 2008-07-25 11:07 | Connector / NET | Closed (5726 days) | S4 | 5.2.1.0 | Any | Any | .net connector should provide means to manually escape strings |
36214 | 2008-04-19 9:04 | 2008-04-25 9:52 | MySQL Server: Data Types | Not a Bug (5817 days) | S3 | ALL | Any | Any | Timestamp column type limitation |
32838 | 2007-11-29 5:42 | 2016-11-17 7:44 | MySQL Server: Falcon storage engine | Won't fix (2689 days) | S2 | 6.0.4, mysql-6.0-falcon-team | Any | Any | Falcon; error 1296 : Got error 305 'record memory is exhausted' |
73136 | 2014-06-27 16:34 | 2015-05-20 15:16 | MySQL Server: Optimizer | Verified (3560 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 |
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(*) |
57024 | 2010-09-26 4:44 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4930 days) | S2 | 5.1 | Any | Any | Serious performance issue with an outer join |
85821 | 2017-04-06 7:11 | 2020-12-01 11:51 | MySQL Server: Optimizer | Closed (1214 days) | S3 | 8.0.2-DEBUG | Any | Any | partial update on views does not work |
40505 | 2008-11-04 16:09 | 2011-02-16 23:43 | MySQL Server: General | Verified (5607 days) | S4 | Any | Any | INSERT DELAYED and transactions, duplicate keys | |
79665 | 2015-12-16 10:50 | 2017-05-31 20:02 | MySQL Server: Documentation | Closed (2494 days) | S3 | any | Any | Any | Manual does NOT explain locks set by INSERT ... ON DUPLICATE KEY UPDATE properly |
112292 | 2023-09-07 12:37 | 2023-09-11 22:06 | MySQL Server: Documentation | Closed (200 days) | S3 | all | Any | Any | Typo spotted |
37741 | 2008-06-30 14:12 | 2008-06-30 14:41 | MySQL Server: Tests | Duplicate (5751 days) | S3 | 5.1.25 | Any | Any | Test concurrent_innodb fails with invalid login |
38857 | 2008-08-18 13:45 | 2011-02-16 23:43 | MySQL Server: Parser | Duplicate (5701 days) | S4 | Any | Any | SQL addition - ORLIMIT | |
38858 | 2008-08-18 13:56 | 2022-12-04 20:45 | MySQL Server: Parser | Verified (5701 days) | S4 | Any | Any | ORDERGROUP BY construct | |
38859 | 2008-08-18 14:17 | 2022-12-04 20:45 | MySQL Server: Parser | Verified (5701 days) | S4 | 6.0 | Any | Any | limiting a group - LIMITGROUP |
43002 | 2009-02-19 7:39 | 2013-07-04 13:10 | MySQL Server: Maria storage engine | Won't fix (3921 days) | S3 | 6.0-TRUNK | Any | Any | maria.maria_notembedded fails sporadically |
47835 | 2009-10-05 13:19 | 2011-02-16 23:44 | MySQL Server: Replication | Can't repeat (4851 days) | S3 | 5.1.37sp1 | Any | Any | MBR replication failure under concurrent load with OFFSET in subselect |
70923 | 2013-11-15 16:59 | 2013-11-18 19:03 | MySQL Server: Replication | Verified (3784 days) | S2 | 5.5.34, 5.6.16 | Any | Any | Replication failure on multi-statement INSERT DELAYED queries |
104576 | 2021-08-10 4:18 | 2023-12-20 6:36 | MySQL Server: Partitions | Closed (903 days) | S5 | 8.0.26, 5.7.35 | Any | Any | partition table access second index lead to cpu high load |
105044 | 2021-09-26 15:32 | 2021-09-27 12:59 | MySQL Server: InnoDB storage engine | Verified (914 days) | S5 | 8.0 | Any | Any | Added page szie judgment logic like btr_cur_optimistic_insert in btr_insert_into |
42209 | 2009-01-20 8:30 | 2012-08-31 15:44 | MySQL Server: Optimizer | Closed (4228 days) | S3 | 5.1.30 | Any | Any | Rollback affects the index usage for DELETE statement with FORCE INDEX. |
64888 | 2012-04-06 14:43 | 2012-04-09 11:03 | MySQL Server: MyISAM storage engine | Verified (4375 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | Inconsistent behavior of dynamic concurrent_insert values |
65225 | 2012-05-07 16:39 | 2014-03-27 14:23 | MySQL Server: InnoDB storage engine | Closed (3700 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | InnoDB miscalculates auto-increment after changing auto_increment_increment |
69835 | 2013-07-25 2:41 | 2013-08-22 2:52 | MySQL Server: InnoDB storage engine | Not a Bug (3872 days) | S3 | 5.6.12 | Any | Any | deadlock detected on concurrent insert |
82774 | 2016-08-29 3:13 | 2017-04-13 22:01 | MySQL Server: Locking | Not a Bug (2542 days) | S3 | 5.7.13 | Any | Any | Reasonably easy to generate mysqld semi-hang. Input file is 1K lines. |
102982 | 2021-03-15 15:02 | 2021-04-24 15:50 | MySQL Server: Japanese Documentation | Closed (1070 days) | S3 | 8.0.23 | Any | Any | 1.3 MySQL 8.0 の新機能(TIMESTAMP および DATETIME のタイムゾーンサポート~) |
104238 | 2021-07-07 15:16 | 2021-07-08 6:23 | MySQL Server: Security: Privileges | Duplicate (995 days) | S3 | 8.0.24 | Any | Any | Grants in prepare with 2 triggers on the same table |
109891 | 2023-02-02 9:10 | 2023-02-03 7:55 | MySQL Server: DML | Verified (420 days) | S3 | 8.0.30,8.0.31, 8.0.32, 5.7 | Any | Any | Contribution by Tencent: insert on duplicate key update would be abnormal |
112451 | 2023-09-25 6:35 | 2023-09-25 7:37 | MySQL Server: Optimizer | Verified (186 days) | S3 | 8.0,8.1 | Any | Any | Incorrect result if there are non-deterministic expressions in in-subquery |
11472 | 2005-06-21 0:08 | 2024-03-25 4:00 | MySQL Server: DML | Verified (5643 days) | S2 | 5.0.8/5.5/5.6/5.7 | Any | Any | Triggers not executed following foreign key updates/deletes |
63280 | 2011-11-16 7:26 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Verified (4517 days) | S4 | 5.1,5.5 | Any | Any | add full_query param to mysqldump |
64559 | 2012-03-06 7:32 | 2012-03-13 14:42 | MySQL Server: DML | Verified (4406 days) | S4 | Any | Any | Add support of ANSI SQL syntax : INSERT INTO <table name> DEFAULT VALUES | |
73190 | 2014-07-03 21:23 | 2017-04-17 13:36 | MySQL Server: mysqldump Command-line Client | Verified (3178 days) | S4 | Any | Any | [mysqldump] Support INSERT ... ON DUPLICATE KEY UPDATE for data dumps | |
84449 | 2017-01-09 19:08 | 2017-01-09 20:51 | MySQL Server: mysqldump Command-line Client | Verified (2636 days) | S3 | 5.5/5.6/5.7/8.0 | Any | Any | Signed zero not preserved by mysqldump/restore |
86486 | 2017-05-28 1:01 | 2017-11-16 10:02 | MySQL Server: Replication | Duplicate (2325 days) | S3 | 5.7.x | Any | Any | XA Transactions in binlog cause replication broken |
87352 | 2017-08-09 8:17 | 2017-08-09 9:37 | MySQL Cluster: Cluster (NDB) storage engine | Verified (2424 days) | S3 | 7.5.7 | Any | Any | "ndb_restore --print-sql-log" includes unnecessary SQL |
99573 | 2020-05-14 13:42 | 2020-05-14 14:12 | MySQL Server | Not a Bug (1415 days) | S3 | 8.0 | Any | Any | Converting UUID (String) to binary with before insert trigger fails |
108155 | 2022-08-16 16:22 | 2024-03-12 11:04 | MySQL Server: DML | Duplicate (17 days) | S3 | 8.0.30 | Any | Any | BEFORE INSERT trigger causes Error 1048 during UPDATE |
19551 | 2006-05-04 22:48 | 2006-05-04 22:51 | MySQL Server | Duplicate (6539 days) | S2 | 4.1.19 | Any (any) | Any | mysqldump with --delayed-insert and InnoDB |
37775 | 2008-07-01 15:46 | 2012-10-15 14:50 | Tests: Server | Unsupported (4183 days) | S3 | 6.0-BK,5.4 | Any | Any | main.locktrans_innodb and rpl.rpl_locktrans_innodb fail randomly |
51838 | 2010-03-08 17:29 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Won't fix (5124 days) | S2 | 5.0.84 | Any | Any | Innodb gets X lock for INSERT ON DUPLICATE KEY UPDATE but not INSERT SELECT |
53441 | 2010-05-05 15:45 | 2011-02-16 23:44 | MySQL Server: Stored Routines | Duplicate (5076 days) | S3 | 5.1.42 | Any | Any | Cursor does not fetch ts value from int column |
64892 | 2012-04-06 17:53 | 2012-08-13 16:22 | MySQL Server: Locking | Closed (4246 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | Session-level low_priority_updates does not work for INSERT |
69185 | 2013-05-09 15:23 | 2014-02-24 12:33 | MySQL Server: Replication | Verified (3686 days) | S2 | 5.1.69 | Any | Any | Replication breaks during concurrent INSERTs and LOAD DATA in a auto_inc table |
72011 | 2014-03-11 16:06 | 2014-03-17 21:33 | MySQL Server: Documentation | Not a Bug (3665 days) | S3 | 5.6 | Any | Any | Deadlock with 3 transactions (inserts) |
76710 | 2015-04-15 14:48 | 2015-04-16 7:36 | MySQL Server: Tests | Verified (3270 days) | S3 | 5.7.7 | Any | Any | myisam_views-big fails |
91026 | 2018-05-25 12:04 | 2018-06-18 12:06 | MySQL Server: DML | Not a Bug (2111 days) | S3 | 5.7 | Any | Any | Inconsistent behavior insert overflow decimal error-code and warn-code |
95070 | 2019-04-20 14:07 | 2019-05-02 13:09 | MySQL Server | Not a Bug (1793 days) | S3 | 8.0.15 | Any | x86 | INSERT .. VALUES ( .., (SELECT ..), ..) takes shared lock with READ-COMMITTED |
96722 | 2019-09-03 3:19 | 2019-12-10 6:37 | MySQL Server: Logging | Verified (1571 days) | S3 | 5.6.28, 5.6.45, 5.7.27 | Any | Any | Event does't record slow insert in slow log |
14056 | 2005-10-16 9:08 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5033 days) | S2 | 4.1, 5.0 | Any (All) | Any | Column prefix index on UTF-8 primary key column causes 'Can't find record..' |
25025 | 2006-12-13 3:58 | 2007-05-16 19:53 | Connector / J | Closed (6162 days) | S2 | 5.0.x, 3.1.x | Any (any) | Any | Connector/J getRewriteBatchedStatements() should be more forgiving of comments |
28650 | 2007-05-24 11:09 | 2007-06-24 12:29 | MySQL Server: Stored Routines | No Feedback (6123 days) | S3 | 5.0 | Any | Any | problem facing with triggers |
29628 | 2007-07-08 18:01 | 2015-08-10 14:33 | MySQL Server: mysqldump Command-line Client | Verified (6108 days) | S4 | 5.0.38 | Any | Any | mysqldump should put newlines between VALUES when using extended inserts |
30861 | 2007-09-06 12:51 | 2007-09-06 12:53 | MySQL Server | Open (6049 days) | S4 | any | Any | Any | an interesting and useful clause |
36545 | 2008-05-06 18:52 | 2008-06-11 18:54 | MySQL Server: Falcon storage engine | Closed (5770 days) | S1 | 6.0.5 | Any | Any | Falcon assertion in Table::insert, ASSERT(ret) fails. |
38900 | 2008-08-19 20:14 | 2011-02-16 23:43 | MySQL Server | Duplicate (5699 days) | S2 | 5.0.66a | Any | Any | mysql_insert_id() and possibly last_insert_id() incorrect |
39358 | 2008-09-10 5:38 | 2008-10-04 6:53 | MySQL Server: Locking | Not a Bug (5655 days) | S3 | 5.0.51-log | Any | Any | Concurrency locks causes deadlocks |
47381 | 2009-09-16 16:00 | 2012-05-18 20:19 | MySQL Server: DDL | Duplicate (5307 days) | S3 | 5.1,5.4 | Any | Any | Wrong warning about crashed table, CREATE TABLE IF NOT EXISTS AS SELECT |
52473 | 2010-03-30 12:51 | 2021-05-02 20:45 | MySQL Cluster: Replication | Verified (5088 days) | S3 | mysql-5.1-telco-6.3 | Any | Any | NDB inserts row when updating slave's empty table (with PK) |
52522 | 2010-04-01 11:43 | 2011-02-16 23:44 | MySQL Server: Security: Privileges | Duplicate (5062 days) | S3 | 5.5.3-m3 | Any | Any | Running mysql_upgrade loses trigger privileges |
60560 | 2011-03-21 3:49 | 2011-03-26 10:13 | MySQL Server: Query Cache | Unsupported (4752 days) | S4 | any | Any | Any | insert and query cache |
65581 | 2012-06-11 10:07 | 2012-06-18 6:37 | MySQL Server: InnoDB storage engine | Verified (4309 days) | S3 | 5.5 | Any | Any | INSERT statement can be delayed by SELECT ... LOCK. |
69679 | 2013-07-05 17:23 | 2014-06-19 5:57 | MySQL Server: Charsets | Not a Bug (3571 days) | S3 | 5.5.32 | Any | Any | utf8mb4_general_ci considers from u+20000 characters as identical |
71832 | 2014-02-25 21:40 | 2015-01-07 13:17 | Connector / NET | Verified (3369 days) | S3 | 6.8.3, 6.9.5 | Any | Any | Connector/NET batch insert not working (UpdateBatchSize) |
72364 | 2014-04-17 9:46 | 2019-11-18 22:53 | MySQL Server: DML | Closed (1593 days) | S3 | 5.5.37 | Any | Any | insert ignore was not rollbacked after KILL QUERY |
76533 | 2015-03-30 14:34 | 2015-03-31 16:20 | MySQL Server: InnoDB storage engine | Verified (3287 days) | S3 | 5.5.41, 5.6.22 | Any | Any | AUTO_INC lock seems to be NOT set for INSERT INTO t(val) SELECT val FROM t |
77639 | 2015-07-07 12:40 | 2019-12-11 1:09 | MySQL Server: Optimizer | Closed (1631 days) | S4 | 5.7 | Any | Any | Implement VALUES equivalent to a query specification |
78508 | 2015-09-22 3:20 | 2015-09-22 12:19 | MySQL Server: DML | Not a Bug (3111 days) | S3 | 5.6.22 | Any | Any | Subquery result with aggregate function() in outer table is not understandable |
79565 | 2015-12-09 7:11 | 2015-12-09 8:34 | MySQL Server: DML | Verified (3033 days) | S3 | 5.7.8,5.5.48, 5.6.29, 5.7.9 | Any | Any | Function insert work incorrectly with multiple-type utf8 character |
82805 | 2016-08-31 2:20 | 2016-08-31 9:47 | MySQL Server: Optimizer | Verified (2767 days) | S2 | 5.7.10, 5.7.14 | Any | Any | Having clause condition fails on join table with TEXT field |
85224 | 2017-02-28 10:59 | 2020-05-19 8:07 | MySQL Server: Charsets | Closed (2566 days) | S3 | 8.0.1 | Any | Any | Illegal mix of collations for time/varchar |
85562 | 2017-03-21 9:48 | 2017-12-22 8:42 | MySQL Server: Security: Roles | Can't repeat (2289 days) | S2 | 8.0 | Any | Any | dropping a role does not remove privileges from active users |
89148 | 2018-01-08 22:23 | 2019-06-04 1:24 | MySQL Server: Group Replication | Verified (2237 days) | S4 | 5.7.20 and 8.0.3 | Any | Any | The timestamp of the GITD events in the GR relay log look wrong. |
99199 | 2020-04-07 10:51 | 2021-01-02 20:00 | MySQL Visual Studio Integration | Duplicate (1353 days) | S3 | 1.2.9 | Any | Any | TableAdapter config Advanced Option "Refresh the datatable" is ignored |
101727 | 2020-11-24 4:07 | 2020-11-24 6:44 | MySQL Server: DML | Duplicate (1221 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 |
101889 | 2020-12-07 9:45 | 2020-12-07 11:43 | MySQL Server: DML | Can't repeat (1208 days) | S3 | 8.0 | Any | Any | Potentially wrong results |
102238 | 2021-01-12 20:35 | 2023-12-21 8:49 | MySQL Server: InnoDB storage engine | Closed (99 days) | S5 | 8.0.22 | Any | Any | log_writer uses too much CPU on small servers |
102755 | 2021-02-27 17:19 | 2021-04-06 12:34 | MySQL Server: InnoDB storage engine | Duplicate (1088 days) | S5 | 5.7 | Any | Any | Error 1062 locks unique index and do not release until commit or rollback |
109087 | 2022-11-15 2:15 | 2022-11-15 7:13 | MySQL Server: DML | Verified (500 days) | S4 | 8.0 | Any | Any | Automatically optimize the insertion order when INSERT |
109217 | 2022-11-28 9:51 | 2022-12-12 3:19 | MySQL Server: Replication | Verified (473 days) | S2 | 5.7.40 | Any | Any | The datas of master and standby are inconsistent for Spatial Data Formats |
113098 | 2023-11-16 2:55 | 2023-11-24 7:00 | Connector / J | Duplicate (133 days) | S3 | 8.1.0 | Any | Any | Inconsistent Execution of Batch Queries with rewriteBatchedStatements=true |
113462 | 2023-12-19 16:05 | 2023-12-20 15:06 | MySQL Server: Optimizer | Verified (100 days) | S3 | 8.0 | Any | Any | Incorrect result |
114237 | 2024-03-06 6:57 | 2024-03-06 8:30 | MySQL Server: Optimizer | Verified (23 days) | S5 | 8.2.0, 8.3.0 | Any | Any | Unexpected Cardinality by Index |
114446 | 2024-03-21 14:30 | 2024-03-22 11:07 | MySQL Server: InnoDB storage engine | Not a Bug (8 days) | S3 | 8.0.* | Any | Any | A deadlock example cause by lock inherit |
511 | 2003-05-26 13:48 | 2003-05-31 16:53 | MySQL Server | Duplicate (7608 days) | S4 | 4.X | Any (ALL) | Any | INSERT as SELECT from the same table must be unlocked |
3275 | 2004-03-23 14:14 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5532 days) | S4 | Any | Any | INSERT INTO table1 AS alias1 - to easier use of LOCK TABLES table1 AS alias1 | |
10396 | 2005-05-05 19:03 | 2011-02-16 23:43 | MySQL Server: Command-line Clients | Verified (6864 days) | S4 | 4.1 | Any (any) | Any | UPDATE... [ON NONE FOUND INSERT] |
11442 | 2005-06-20 2:25 | 2011-02-16 23:43 | MySQL Server: DML | Verified (6302 days) | S4 | 5.0 | Any (All) | Any | INSERT... ON DUPLICATE KEY UPDATE; w/ values taken from the INSERT part |
25194 | 2006-12-20 3:55 | 2013-03-03 20:45 | MySQL Server: Federated storage engine | Verified (4985 days) | S4 | 5.1, 5.5 | Any (*) | Any | please implement bulk inserts for federated table |
28412 | 2007-05-14 11:35 | 2011-02-16 23:43 | MySQL Server: General | Verified (6164 days) | S4 | 5.0.41 | Any | Any | insert_id in OK Packet not working with multiple rows INSERT |
35224 | 2008-03-11 16:07 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Closed (5137 days) | S3 | 5.1-bk | Any | Any | mysqldump --help is very confusing |
35386 | 2008-03-18 9:39 | 2014-09-17 4:39 | MySQL Server: DML | Won't fix (3481 days) | S3 | 5.1.22 | Any | Any | Insert delayed statements insert 1 + limit records instead of just limit records |
35703 | 2008-03-31 11:03 | 2008-05-02 20:51 | MySQL Server: DML | No Feedback (5810 days) | S3 | Any | Any | Max_delayed_thread does not make delayed insert threads as normal insert | |
36898 | 2008-05-22 22:24 | 2008-05-25 10:04 | MySQL Server: DML | Not a Bug (5787 days) | S3 | 5.0.51 | Any | Any | INSERT ... ON DUPLICATE KEY UPDATE seem to compute wrong, if a new row is insert |
37456 | 2008-06-17 19:03 | 2018-04-08 20:45 | MySQL Server: Embedded Library ( libmysqld ) | Verified (5658 days) | S2 | 5.1+ | Any | Any | funcs_1: Several tests crash when used with embedded server |
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 |
42491 | 2009-01-30 19:44 | 2011-02-16 23:43 | MySQL Server: Storage Engines | Duplicate (5537 days) | S2 | 5.1.30 | Any | Any | INSERT on temporary table may pass incorrect lock type to storage engine |
42640 | 2009-02-06 7:17 | 2011-02-16 23:43 | MySQL Server | Closed (5432 days) | S2 | 5.1-bugteam, 5.1 | Any | Any | mysqld crashes when unsafe statements are executed (STRICT_TRANS_TABLES mode) |
46179 | 2009-07-14 18:07 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (1915 days) | S2 | 5.6, 5.7, 8.0 | Any | Any | set new.colname = default(colname) in trigger elicits a crazy error message |
49625 | 2009-12-11 15:28 | 2009-12-14 18:03 | MySQL Server: Stored Routines | Not a Bug (5219 days) | S1 | 5.0.51 | Any (Unknown host OS) | Any | Stored procedure that calls UUID() calls resuting Insert Statement multipe times |
51509 | 2010-02-25 15:09 | 2011-12-16 7:55 | Connector / J | Closed (4487 days) | S3 | 5.1.12 | Any | Any | allowMultiQueries option is ignored if used with PreparedStatement |
54560 | 2010-06-16 18:58 | 2011-02-16 23:44 | MySQL Server | Closed (5029 days) | S3 | 5.1, 4.1, 5.0, 5.6.99 | Any | Any | Docs for REPLACE are not accurate |
56688 | 2010-09-09 12:04 | 2010-09-09 14:22 | Connector / J | Not a Bug (4950 days) | S2 | 5.1.13 | Any | Any | JDBC - insert error - field doesn't have a default value - NOT NULL field |
61468 | 2011-06-09 21:54 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Verified (4676 days) | S4 | Any | Any | mysqldump values() group size | |
61502 | 2011-06-13 14:02 | 2011-08-04 21:32 | MySQL Server: Locking | Not a Bug (4621 days) | S2 | 5.5.10 | Any | Any | deadlock on insertion - insert holds and waits on same lock |
62696 | 2011-10-12 9:36 | 2011-11-09 15:38 | MySQL Server: Parser | Verified (4552 days) | S3 | 5.5.17, 5.6.4-m5 | Any | Any | Using a numeric operator on a TIME column should return an error or warning |
63126 | 2011-11-07 2:16 | 2011-12-07 7:00 | MySQL Server: Data Types | No Feedback (4496 days) | S3 | 5.5.16 | Any | Any | cannot perform a precise calculation with decimal data |
66301 | 2012-08-10 8:46 | 2013-04-22 20:28 | MySQL Server: InnoDB storage engine | Closed (3994 days) | S2 | 5.1, 5.5 | Any | Any | INSERT ... ON DUPLICATE KEY UPDATE + innodb_autoinc_lock_mode=1 is broken |
68446 | 2013-02-20 23:36 | 2013-02-22 14:56 | MySQL Server: DML | Closed (4053 days) | S3 | 5.5.29 | Any | Any | insert on duplicate key update with null autoincremented PK uses wrong pk value |
69228 | 2013-05-14 14:56 | 2022-05-23 9:39 | MySQL Server: Data Types | Verified (3972 days) | S2 | 5.6, probably since 4.1 | Any | Any | Last insert ID incorrectly delivered to the client |
70555 | 2013-10-08 17:29 | 2013-10-09 8:03 | MySQL Server: Optimizer | Verified (3824 days) | S3 | 5.6.14 | Any | Any | EXPLAIN for INSERT ... SELECT waits for table lock |
71232 | 2013-12-26 11:34 | 2014-07-04 9:51 | MySQL Server: InnoDB storage engine | Verified (3556 days) | S3 | 5.6.15 | Any | Any | Wrong behaviour for auto_increment unsigned bigint column approaching max value |
71947 | 2014-03-05 18:55 | 2014-03-06 5:18 | MySQL Server: Partitions | Verified (3676 days) | S3 | 5.6, 5.7 | Any | Any | Unexpected change in error code on INSERT .. PARTITION causes replication abort |
72367 | 2014-04-17 11:48 | 2014-04-17 13:03 | MySQL Server: DML | Not a Bug (3634 days) | S2 | 5.7.4 | Any | Any | DELAYED is documented as deprecated, but it is acutally non-functional |
78203 | 2015-08-25 9:16 | 2015-08-26 15:33 | MySQL Server: DML | Not a Bug (3138 days) | S3 | 5.6.22 | Any | Any | Inconsistent behaviors when auto_increment_offset is ignored(>auto..._increment) |
78934 | 2015-10-23 4:14 | 2015-10-26 13:37 | MySQL Server: DML | Not a Bug (3077 days) | S3 | 5.7.8 | Any | Any | Failed INSERT(Dup entry) still change LAST_INSERT_ID() for auto_increment col |
79204 | 2015-11-10 12:38 | 2016-02-04 19:57 | MySQL Server: Optimizer | Closed (3041 days) | S3 | 5.7.10 | Any | Any | INSERT INTO table from SELECT accepts to insert into generated columns |
81491 | 2016-05-18 15:05 | 2016-05-18 18:13 | MySQL Server: Optimizer | Not a Bug (2872 days) | S3 | 5.5.49-c11 | Any | Any | delete then insert multiple values produces data in wrong order. |
86019 | 2017-04-20 11:44 | 2017-06-14 13:35 | MySQL Server: Documentation | Closed (2480 days) | S3 | 5.6.35 | Any | Any | explicit_defaults_for_timestamp and timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP |
86078 | 2017-04-25 19:14 | 2018-04-12 7:51 | MySQL Server: Replication | Closed (2178 days) | S2 | 8.0.1 | Any | Any | Bad Write Set tracking with UNIQUE KEY on a DELETE followed by an INSERT. |
89194 | 2018-01-11 19:14 | 2018-04-11 16:23 | MySQL Server: Group Replication | Duplicate (2179 days) | S2 | 5.7.20, 8.0.3 | Any | Any | Wrong certification lead to data inconsistency and GR breakage. |
93806 | 2019-01-03 17:41 | 2020-09-21 14:21 | MySQL Server: Documentation | Closed (1864 days) | S3 | all | Any | Any | Document error about "ON DUPLICATE KEY UPDATE " |
94929 | 2019-04-07 8:38 | 2019-04-08 12:25 | MySQL Server: DML | Verified (1817 days) | S3 | 8.0.15, 5.7.25 | Any | Any | Generated column vs before insert trigger calculation order |
96328 | 2019-07-25 10:37 | 2019-07-25 13:04 | MySQL Server | Not a Bug (1709 days) | S3 | all | Any | Any | INSERT ... ON DUPLICATE KEY UPDATE |
100746 | 2020-09-04 19:40 | 2020-09-04 21:09 | MySQL Server: DML | Verified (1302 days) | S3 | 5.7.31, 8.0 | Any | x86 | user variable in select causes view to be non-insertable |
101269 | 2020-10-22 3:26 | 2022-04-11 9:06 | MySQL Server: Optimizer | Duplicate (718 days) | S1 | 5.7, 8.0, 8.0.22, 5.7.32 | Any | Any | using different index may produce different results |
102776 | 2021-03-02 7:10 | 2021-03-04 9:19 | MySQL Server: C API (client library) | Not a Bug (1122 days) | S3 | 8.0.22 | Any | Any | insert into select on tinyint type, no warning, but with wrong result |
103216 | 2021-04-06 8:30 | 2021-04-07 4:44 | MySQL Server: InnoDB storage engine | Not a Bug (1087 days) | S3 | 8.0.22,8.0.23 | Any | Any | create table failed with ENCRYPTION set to Y after ALTER MASTER KEY crash |
103837 | 2021-05-28 9:32 | 2021-05-28 9:54 | MySQL Server: Logging | Verified (1036 days) | S4 | All, 8.0 | Any | Any | Suggest to add materialized view log for innodb tables |
113355 | 2023-12-06 17:45 | 2023-12-27 17:42 | MySQL Server: DDL | Verified (93 days) | S3 | 8.0 | Any | Any | DROP/RENAME index, increase VARCHAR should really be ALGORITHM=INSTANT |
22175 | 2006-09-09 10:27 | 2010-05-26 17:59 | MySQL Server: Falcon storage engine | Unsupported (5056 days) | S3 | 6.0 | Any (all) | Any | Mixing with InnoDB table leads to an anomaly |
22561 | 2006-09-21 17:44 | 2006-09-27 18:28 | MySQL Query Browser | Duplicate (6393 days) | S4 | 1.2.1 beta | Any (All) | Any | MySQL Query Browser Should Have An Export To Sql Option |
24178 | 2006-11-10 10:40 | 2022-12-01 10:35 | MySQL Server: Prepared statements | Won't fix (484 days) | S3 | Any | Any | ctype_ucs.test fails wit --cursor-protocol | |
25330 | 2006-12-29 12:17 | 2007-01-02 9:48 | MySQL Cluster: Cluster (NDB) storage engine | Won't fix (6296 days) | S3 | 5.1, 5.0?, 4.1? | Any | Any | ndb: table create and insert during node restart causes restart node crash |
27159 | 2007-03-15 1:02 | 2011-02-16 23:43 | MySQL Server: Security: Privileges | Verified (6184 days) | S4 | any | Any (any) | Any | restrict permissions for table maintenance statements |
27350 | 2007-03-21 17:57 | 2012-05-18 20:19 | MySQL Server: Falcon storage engine | No Feedback (6164 days) | S2 | 5.2 | Any | Any | test-insert, Unexpected error; "Record has changed since last read in table" |
27502 | 2007-03-28 15:44 | 2012-09-13 8:20 | Connector / NET | Can't repeat (6195 days) | S2 | 5.0.23 | Any (unix) | Any | UTF characters inserts into tables as "???" (c# + connector/net) |
27838 | 2007-04-15 23:01 | 2007-04-16 4:33 | MySQL Server: Data Types | Duplicate (6192 days) | S2 | 5.0.24a | Any | Any | DateTime and Timestamp do not work with Milliseconds |
27906 | 2007-04-17 23:27 | 2017-10-20 15:16 | MySQL Server: Data Types | Verified (6191 days) | S4 | 5.0 | Any | Any | MySQL doesn't accept ISO8601 date |
28052 | 2007-04-23 22:51 | 2007-04-23 22:51 | MySQL Server: Falcon storage engine | Closed | S3 | 6.0.0-alpha | Any | Any | Falcon Crash with insert while unique key for date and tinyint |
28053 | 2007-04-23 22:59 | 2007-04-23 22:59 | MySQL Server: Falcon storage engine | Closed | S3 | 6.0.0-alpha | Any | Any | Falcon crash on multi table update |
28280 | 2007-05-07 13:47 | 2007-05-29 13:29 | MySQL Server: Stored Routines | Duplicate (6149 days) | S1 | 5.0.42BK, 5.1.18BK | Any | Any | insert delayed on a table containing trigger leads to server crash |
30256 | 2007-08-06 14:27 | 2007-08-06 15:15 | MySQL Server | Can't repeat (6080 days) | S2 | 5.0.45 | Any | Any | Query cache not emptied after a INSERT ... ON DUPLICATE KEY UPDATE |
30267 | 2007-08-07 5:11 | 2007-10-29 12:09 | MySQL GUI Common | Closed (5996 days) | S3 | 1.1.10 Alpha | Any | Any | Columns not insert |
30400 | 2007-08-14 8:03 | 2007-09-30 11:08 | MySQL Server: Stored Routines | No Feedback (6025 days) | S3 | Any | Any | cursor can not support recursion. | |
30871 | 2007-09-06 16:40 | 2011-02-16 23:43 | MySQL Server | Duplicate (4966 days) | S4 | 5.0 | Any | Any | Feature request: login triggers |
30936 | 2007-09-10 15:19 | 2007-09-10 15:33 | MySQL Server: Errors | Not a Bug (6045 days) | S3 | MySQL 5.0 | Any | Any | Syntax error |
30987 | 2007-09-12 17:46 | 2007-10-31 19:31 | MySQL Server: Data Types | Can't repeat (5994 days) | S3 | 5.0.44 | Any | Any | mysql Error: Warning | 1366 | Incorrect string value: '\xB4 FFFF...' for column |
31135 | 2007-09-21 15:59 | 2008-09-12 8:09 | MySQL Server | No Feedback (5677 days) | S1 | 5.0, 5.1 | Any | Any | alter table x alter column y set default m does not pass default value to engine |
31352 | 2007-10-02 18:55 | 2007-10-20 16:17 | MySQL Server: Locking | Closed (6005 days) | S3 | 5.0.45 | Any (Linux, Windows) | Any | Write locking in stored functions with INSERT and SELECT statemenst |
31776 | 2007-10-23 8:19 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6001 days) | S3 | 5.0.45, 4.1, 5.0, 5.1, 5.2 BK | Any (Linux, Microsoft Windows XP SP2) | Any | CAST AS CHAR with SELECT DISTINCT |
31976 | 2007-10-31 8:36 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Verified (5988 days) | S3 | mysql-5.1 | Any | Any | Can't drop a ndb table after all ndbds restarted |
32239 | 2007-11-09 16:23 | 2008-02-24 21:07 | MySQL Cluster: Replication | Closed (5878 days) | S3 | 5.1.22-ndb-6.3.2-telco-log | Any | Any | failed ndbrequire on slave server after intensive db activity |
32245 | 2007-11-09 19:25 | 2015-01-09 14:32 | Tests: Cluster | Won't fix (3367 days) | S3 | 6.0.4-alpha,5.4 | Any | Any | Change in NDB is not reflected in the test results: on-line ADD COLUMN |
32606 | 2007-11-21 23:27 | 2007-11-29 12:58 | MySQL Server: Replication | Can't repeat (5965 days) | S2 | 5.0.45 | Any | Any | auto_increment on slave doesn`t work expected after null insert |
32951 | 2007-12-04 8:04 | 2008-05-13 8:45 | MySQL Cluster: Cluster (NDB) storage engine | Can't repeat (5799 days) | S3 | 6.0 | Any | Any | stack badness in ndb |
33037 | 2007-12-06 12:49 | 2007-12-07 8:43 | MySQL Server: Optimizer | Can't repeat (5957 days) | S5 | 5.0.22-pro-nt-log | Any | Any | Different and much slower access plan used for select when used with insert into |
33095 | 2007-12-09 11:50 | 2013-12-19 18:47 | MySQL Workbench | Closed (3753 days) | S3 | 5.0.10 OSS Beta 2272 | Any | Any | Table/Inserts can not handle many INSERT statements |
33299 | 2007-12-17 20:27 | 2014-03-14 4:54 | Connector / ODBC | Verified (3668 days) | S1 | 5.1.1 | Any | Any | Trying to insert east-asian (or non latin) data into a recordset fails |
33360 | 2007-12-19 8:25 | 2011-02-16 23:43 | MySQL Cluster: Replication | Closed (5292 days) | S2 | mysql-6.0 | Any | Any | rpl_ndb_idempotent fails due to null field for table on slave side |
33371 | 2007-12-19 16:39 | 2020-06-12 8:11 | MySQL Server | Not a Bug (5937 days) | S3 | 5.0.45 | Any | Any | default required for column in strict mode when value is specified |
33495 | 2007-12-24 3:17 | 2007-12-24 4:29 | MySQL Server: DML | Duplicate (5940 days) | S3 | Any | Any | Error Insert data in version 5.1.20 | |
33648 | 2008-01-03 12:18 | 2010-05-26 17:59 | MySQL Server: Falcon storage engine | Unsupported (5056 days) | S3 | 6.0.4-p2 | Any | Any | Falcon selects on blobs above certain size are starved with default settings |
33736 | 2008-01-08 9:53 | 2008-01-14 6:51 | MySQL Server: General | Closed (5919 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 |
33774 | 2008-01-09 16:06 | 2008-01-10 13:18 | MySQL Server: Stored Routines | Not a Bug (5923 days) | S1 | Any | Any | oracle details i am using | |
33857 | 2008-01-14 4:15 | 2008-01-15 13:18 | MySQL Server | Can't repeat (5918 days) | S2 | 5.0.45 | Any (windows and linux) | Any | mysql hangs on certain querys in strict mode |
34319 | 2008-02-05 18:21 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5653 days) | S4 | 5.1.22-rc, 5.0.45, 4.1.22 | Any | Any | last_insert_id() inaccurate when inserting multiple rows |
34382 | 2008-02-07 14:55 | 2008-03-07 15:05 | MySQL Server: General | No Feedback (5866 days) | S3 | 5.0.32 | Any (Sorry none) | Any | Error when using ON DUPLICATE KEY UPDATE table1.field1 = table2.field1,.... |
34660 | 2008-02-19 11:49 | 2011-10-08 16:07 | MySQL Server: Optimizer | Closed (4556 days) | S1 | 5.1.56, 5.0.56, 5.5.10 | Any | Any | crash when federated table loses connection during insert ... select |
34696 | 2008-02-20 16:27 | 2008-02-20 18:14 | MySQL Server: InnoDB storage engine | Not a Bug (5882 days) | S3 | 5.1 | Any | Any | auto increment gaps when using multi row insert with explicit values in InnoDB |
35856 | 2008-04-05 23:31 | 2008-10-16 4:30 | MySQL Server: InnoDB storage engine | Duplicate (5643 days) | S3 | 5.0.45 | Any | Any | false unique constraint violation on multiple updates |
36413 | 2008-04-29 20:36 | 2011-02-16 23:43 | MySQL Workbench | Closed (5265 days) | S4 | 5.0.21 | Any | Any | Add row number to the INSERT Editor |
36508 | 2008-05-05 15:15 | 2008-05-06 16:45 | MySQL Server: DML | Not a Bug (5806 days) | S2 | 5.1.24 | Any | Any | inserting null value to not null column with default value explicitly defined |
36964 | 2008-05-26 13:29 | 2011-02-16 23:43 | MySQL Server | No Feedback (5144 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 |
37142 | 2008-06-02 17:04 | 2008-07-04 20:06 | MySQL Server: General | No Feedback (5747 days) | S2 | 4.0.14 | Any | Any | auto_increment problem with type bigint |
37189 | 2008-06-04 10:44 | 2021-05-23 20:45 | MySQL Server: Falcon storage engine | Duplicate (5777 days) | S3 | 6.0.6 | Any | Any | can't drop table during an uncommited transaction |
37315 | 2008-06-10 18:17 | 2013-02-20 22:14 | Connectors: DBD::mysql ( Perl ) | Unsupported (4055 days) | S3 | 4.005, 4.007 | Any | Any | bind_param incorrectly interprets scientific notation |
37531 | 2008-06-19 19:38 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5031 days) | S3 | 5.1.25/6.0 | Any | Any | After truncate, auto_increment behaves incorrectly for InnoDB |
37735 | 2008-06-30 8:40 | 2008-06-30 15:24 | MySQL Server: DML | Not a Bug (5751 days) | S2 | 5.1, 5.0, 4.1, 6.0 BZR | Any | Any | WHERE clause fails immediately following INSERT on AUTO INCREMENT column |
38046 | 2008-07-11 14:22 | 2012-08-03 15:34 | MySQL Server: Locking | Closed (4256 days) | S3 | 5.0, 5.1, 6.0 bzr | Any | Any | INSERT SELECT ON DUPLICATE KEY UPDATE, LOAD DATA REPLACE wrong lock |
38148 | 2008-07-15 18:42 | 2008-07-15 20:52 | MySQL Server: Replication | Can't repeat (5736 days) | S3 | 5.0.37 | Any | Any | insert user() references uninitialized fields on a slave |
38655 | 2008-08-08 4:47 | 2008-09-08 5:05 | MySQL Workbench | No Feedback (5681 days) | S3 | 5.0.23 | Any | Any | insert statements malformed under certain circumstances |
39088 | 2008-08-28 11:16 | 2008-10-13 15:31 | MySQL Workbench | Closed (5646 days) | S3 | 5.0.24/5.0.25 | Any | Any | triggers calling procedures fails on insert |
39222 | 2008-09-03 19:00 | 2008-09-03 19:32 | MySQL Server | Not a Bug (5686 days) | S3 | 5.0.51-log | Any | Any | no difference between LOCK IN SHARE MODE and LOCK FOR UPDATE |
39359 | 2008-09-10 7:14 | 2018-09-25 21:49 | Tests: Server | Can't repeat (4658 days) | S7 | 6.0 | Any | Any | main.analyze fails randomly on Pushbuild |
39474 | 2008-09-16 11:50 | 2022-12-04 20:45 | MySQL Server: DDL | Verified | S2 | 5.x, 6.0.8 | Any | Any | checksum table reports equal checksums when data is different |
39477 | 2008-09-16 13:12 | 2008-10-13 14:03 | MySQL Workbench | Closed (5646 days) | S3 | 5.0.25 | Any | Any | "Copy insert to Clipboard" uses lower case for keywords |
39660 | 2008-09-26 8:13 | 2012-05-18 20:19 | MySQL Server: Stored Routines | Duplicate (5663 days) | S2 | 5.1 | Any | Any | Before Trigger in combination with NOT NULL behaves wrong |
39927 | 2008-10-08 11:17 | 2011-02-16 23:43 | MySQL Cluster: Replication | Closed (5345 days) | S2 | mysql-5.1-telco-7.0 | Any | Any | ndb_log_update_as_write does not work as expected |
40255 | 2008-10-22 15:10 | 2011-02-16 23:43 | MySQL Server: Information schema | Verified (5636 days) | S3 | Any | Any | INFORMATION_SCHEMA.WARNINGS - a CREATE/INSERT .. SELECT friendly table | |
40384 | 2008-10-29 7:42 | 2019-11-04 15:09 | MySQL Server: DML | Closed (1607 days) | S3 | 5.1, main-6.0, revision 2866 and greater | Any | Any | Gap in auto_increment sequence when inserts fire a trigger |
40879 | 2008-11-20 11:08 | 2011-02-16 23:43 | MySQL Server: DML | Duplicate (5568 days) | S1 | 5.0.68 | Any | Any | insert..select crashed in field_conv |
41007 | 2008-11-25 11:21 | 2008-11-26 10:13 | MySQL Server: DML | Not a Bug (5602 days) | S2 | 5.0.67 | Any (Tested on OSX and Linux Debian) | Any | Update Problem when ORing w/ Long.MIN_VALUE |
41311 | 2008-12-08 21:39 | 2022-12-04 20:45 | MySQL Server: Security: Privileges | Verified (5589 days) | S3 | 5.0.67, 5.0.72, 5.1.30 | Any | Any | set timestamp allows unprivileged users to change per-session clock |
41477 | 2008-12-15 15:33 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5583 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 |
42396 | 2009-01-27 21:35 | 2017-01-18 13:23 | MySQL Cluster: Replication | Can't repeat (2627 days) | S3 | mysql-6.0 | Any | Any | autoincrement insert into ndb fails with duplicate key |
42497 | 2009-01-31 10:51 | 2009-02-02 19:34 | MySQL Server: InnoDB storage engine | Not a Bug (5534 days) | S3 | 5.1.30-log | Any | Any | V5.1 AUTO_INCREMENT gaps with InnoDB when using INSERT IGNORE |
42509 | 2009-02-01 9:20 | 2010-05-26 18:00 | MySQL Server: Maria storage engine | Unsupported (5056 days) | S2 | 6.0-maria | Any | Any | Maria write_block_record: Assertion `data_length < ((block_size) * 3 / 4)' |
42540 | 2009-02-02 11:34 | 2011-02-16 23:43 | MySQL Server: Security: Privileges | Duplicate (5534 days) | S3 | 6.0.9 | Any | Any | SELECT,INSERT ... command denied to usual user for TEMPORARY table |
43167 | 2009-02-25 6:16 | 2009-02-25 6:54 | MySQL Server | Not a Bug (5511 days) | S2 | 6.0 | Any | Any | table locks are not working properly |
43402 | 2009-03-05 8:31 | 2009-03-05 13:18 | MySQL Server: Replication | Not a Bug (5503 days) | S2 | 5.0.45 | Any | Any | mysqlbinlog ignores data added using "insert into database.table values(...) |
43604 | 2009-03-12 16:22 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Verified (5439 days) | S4 | mysql-6.0 | Any (NDB supported OS only) | Any | Backup: No native driver for NDB Backup |
43700 | 2009-03-17 13:27 | 2009-03-18 8:56 | MySQL Server: Locking | Not a Bug (5490 days) | S3 | Ver 14.12 Distrib 5.0.54 | Any (ubuntu) | Any | dead lock after insert inside transaction |
43842 | 2009-03-24 20:19 | 2013-01-14 9:25 | MySQL Server: Federated storage engine | Won't fix (4092 days) | S4 | 5.0 | Any | Any | Support for ON DUPLICATE KEY UPDATE with FEDERATED |
43930 | 2009-03-28 10:18 | 2011-02-16 23:43 | MySQL Server: Options | Verified | S4 | 5.0.x | Any | Any | Add sql_mode that throws warnings when rounding non-integer numbers to integers |
44199 | 2009-04-10 0:11 | 2011-02-16 23:43 | Connector / ODBC | Can't repeat (5467 days) | S2 | 5.1.6 | Any | Any | Unable to INSERT columns into view using ODBC 5.1.6/ADO |
44363 | 2009-04-20 9:56 | 2011-02-16 23:43 | MySQL Server: General | Verified (5456 days) | S2 | 5.1.15, 5.1.35-bzr | Any | Any | IDIV not rounding off float/decimals correctly ? |
44392 | 2009-04-21 21:46 | 2009-04-22 10:30 | Connector / NET | Not a Bug (5455 days) | S1 | 5.2.5 or any 6.0.x beta | Any | Any | Using Variable with insert/select |
45077 | 2009-05-25 19:08 | 2011-02-16 23:44 | Connector / NET | Closed (5345 days) | S1 | 6.0.3 | Any | Any | Insert problem with Connector/NET 6.0.3 and entity framework |
45361 | 2009-06-07 21:58 | 2009-06-11 19:19 | MySQL Server: Parser | Not a Bug (5405 days) | S3 | any | Any | Any | parser behaves too primitive here! |
45729 | 2009-06-24 19:09 | 2012-10-15 13:44 | Tests: Server | Closed (4183 days) | S3 | 5.4 | Any | Any | Test case for Bug#28211 is disabled in query_cache.test |
45890 | 2009-07-01 22:27 | 2009-07-04 12:49 | MySQL Server: Tests | Not a Bug (5382 days) | S3 | 5.1.36 | Any | Any | main.grant failes |
46952 | 2009-08-27 12:14 | 2012-05-18 20:19 | Tools | Duplicate (5320 days) | S3 | Any | Any | backup_logs fails on Valgrind platform in PB2 | |
48935 | 2009-11-20 9:28 | 2011-02-16 23:44 | MySQL Server: InnoDB Plugin storage engine | Closed (5240 days) | S1 | 5.1.40 | Any | Any | alter table to add an index leads to data loss on large table |
49009 | 2009-11-23 23:43 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | No Feedback (5209 days) | S3 | 5.0.77 | Any | Any | Subselect seems to implicitly do LOCK IN SHARE MODE? |
49328 | 2009-12-02 6:57 | 2011-02-16 23:44 | MySQL Workbench | Duplicate (5231 days) | S3 | 5.2.8 | Any | Any | Can't edit TEXT fields |
49437 | 2009-12-03 23:26 | 2011-07-27 16:41 | MySQL Server: DDL | Closed (4629 days) | S2 | 5.0++ | Any | Any | Cannot do SHOW FIELDS for big view |
50293 | 2010-01-12 22:23 | 2010-01-14 23:41 | MySQL Server: Data Types | Not a Bug (5188 days) | S3 | 5.1-bugteam, 5.5.99 | Any | Any | Difference in SELECT output when search is based on an invalid DATE/DATETIME |
50319 | 2010-01-14 0:45 | 2011-02-16 23:44 | MySQL Server | Duplicate (5188 days) | S3 | 5.6.0 | Any | Any | Drop database fails if temporary table has same name as other table in the db |
50454 | 2010-01-19 19:44 | 2012-05-18 20:19 | MySQL Server: Backup | Duplicate (5181 days) | S3 | 5.6.0, 6.0.14 | Any | Any | Creation time changes for database objects after restore. |
50502 | 2010-01-21 10:44 | 2010-01-26 12:36 | Connector / J | Not a Bug (5176 days) | S2 | 5.1.10 | Any | Any | J/Connector doesn't allow to insert NULL as a field value with setNull(int, int) |
50551 | 2010-01-22 17:04 | 2010-01-22 17:20 | MySQL Migration Toolkit | Unsupported (5180 days) | S3 | Any | Any | MySQL Migration Toolkit problem with multiple schemas | |
50876 | 2010-02-03 10:55 | 2017-07-24 8:58 | MySQL Server: Documentation | Closed (2440 days) | S3 | 5.0+ | Any | Any | Upgrading in a replicated environment problems and known issues |
50968 | 2010-02-06 23:09 | 2011-02-16 23:44 | Connector / J | Duplicate (5162 days) | S1 | 5.1.10 | Any | Any | Insertion id is Long instead of BigInteger for BIGINT unsigned ID column |
51329 | 2010-02-19 15:44 | 2012-05-18 20:19 | MySQL Server | Duplicate (5146 days) | S2 | 5.1.36-enterprise-commercial-classic | Any | Any | Inserts from one connection not immediately visible in second connection |
51560 | 2010-02-26 16:59 | 2011-02-16 23:44 | MySQL Workbench: Modeling | No Feedback (5108 days) | S3 | 5.2.16 @5249 | Any | Any | foreign key insert on ERR model throws exception |
51567 | 2010-02-26 22:09 | 2011-02-16 23:44 | MySQL Server: General | Closed (5144 days) | S4 | Any | Any | Create on Join | |
51821 | 2010-03-08 9:22 | 2012-08-13 13:32 | MySQL Server: General | Not a Bug (4246 days) | S3 | 5.1, 5.5 | Any | Any | Setting user var in trigger may lead to strange results |
51907 | 2010-03-10 12:26 | 2021-05-02 20:45 | MySQL Server: Tests | Verified (5106 days) | S3 | 5.5.3 | Any | Any | main.ctype_utf8mb4_ndb fails persistently |
51946 | 2010-03-11 9:23 | 2011-02-16 23:44 | MySQL Server: Optimizer | Duplicate (5132 days) | S1 | 5.1.41 | Any | Any | 'Range' optimized access returns incorrect result (duplicates of rows) |
52283 | 2010-03-22 19:10 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5120 days) | S3 | 5.1.46 | Any | Any | Innodb reports extra warnings when SELECT/WHERE is performed using invalid value |
52303 | 2010-03-23 13:52 | 2010-04-13 5:29 | MySQL Server: Optimizer | Not a Bug (5099 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 |
52330 | 2010-03-24 14:16 | 2010-03-26 14:00 | MySQL Server: Command-line Clients | Not a Bug (5117 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 |
52568 | 2010-04-03 6:36 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Verified (5107 days) | S4 | 5.1.45 | Any | Any | Begin and End option for mysqldumpslow |
52927 | 2010-04-18 18:59 | 2010-05-27 9:29 | MySQL Server: GIS | Not a Bug (5055 days) | S2 | 5.1.45-community | Any (GeomFromText failure) | Any | GeomFromText('POINT(31.5,42.2)') failure.. |
53396 | 2010-05-04 5:24 | 2010-05-04 13:31 | MySQL Server: Charsets | Not a Bug (5078 days) | S3 | Any | Any | latin1_german2_ci not finding 'ü' by looking for 'ue' | |
53724 | 2010-05-18 6:37 | 2013-07-13 23:42 | MySQL Workbench: Modeling | Closed (3912 days) | S4 | Any | Any | Column copy | |
53836 | 2010-05-20 7:40 | 2011-02-16 23:44 | MySQL Server: Command-line Clients | No Feedback (5031 days) | S3 | 5.1.46 | Any | Any | insert AA select * From BB ,can't run |
54065 | 2010-05-28 12:55 | 2015-10-01 15:52 | MySQL Server: GIS | Closed (3102 days) | S4 | 4.1, 5.0, 5.1, 5.6.99 | Any | Any | Support OGC standard WKT for MULTIPOINT |
54125 | 2010-06-01 6:15 | 2010-06-01 12:08 | MySQL Server: Data Types | Not a Bug (5050 days) | S5 | 5.5 | Any | Any | year(4) datatype not taking values before 19th century. |
54642 | 2010-06-20 10:35 | 2010-08-23 7:59 | MySQL Server: InnoDB storage engine | Not a Bug (5000 days) | S1 | mysql-5.1.46 | Any (Windows XP) | Any | One query killing another query. |
54644 | 2010-06-20 16:15 | 2010-08-23 7:59 | Connector / NET | Not a Bug (4991 days) | S1 | .net connector 6.2.3 | Any (Windows XP) | Any | Auto QUERY KILL |
55032 | 2010-07-06 16:52 | 2017-07-07 9:45 | MySQL Server: Query Cache | Won't fix (2457 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. |
55131 | 2010-07-09 16:34 | 2012-08-09 16:54 | MySQL Server: DDL | Closed (4250 days) | S2 | 5.0,5.1,5.5 | Any | Any | cannot define timestamp column without an implicit DEFAULT |
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 |
55595 | 2010-07-28 3:30 | 2014-03-14 19:04 | MySQL Server: Storage Engines | Verified (3668 days) | S1 | Any | Any | Lots of data differences between MyISAM and InnoDB where there shouldn't be | |
55605 | 2010-07-28 14:12 | 2012-05-18 20:19 | MySQL Server: Replication | Duplicate (4991 days) | S3 | 5.1, 5.5, 5.1-wl5370 | Any | Any | Erroneous CREATE TABLE IF NOT EXISTS not written to binlog makes servers diverge |
55731 | 2010-08-04 8:36 | 2013-04-14 20:45 | MySQL Server: InnoDB Plugin storage engine | Verified (4986 days) | S4 | any | Any | Any | Implementation of innodb_min_dirty_pages_pct |
55797 | 2010-08-06 8:43 | 2010-08-06 12:27 | MySQL Server: Charsets | Not a Bug (4984 days) | S2 | 5.1.41 | Any | Any | Collation utf8_polish_ci seems to not work when sorting |
55831 | 2010-08-09 5:16 | 2010-08-09 11:18 | MySQL Server | Not a Bug (4981 days) | S3 | 5.1.45 | Any | Any | Mysql DUMP is not working properly |
55859 | 2010-08-09 20:21 | 2013-04-14 20:45 | MySQL Server: InnoDB storage engine | Verified (4841 days) | S4 | 5.1 | Any | Any | MySQL and InnoDB locks are taken in different orders in different statements |
56345 | 2010-08-28 17:59 | 2018-06-24 20:45 | MySQL Workbench: Modeling | Verified (4960 days) | S4 | 5.2.26 | Any | Any | Column too long when using Longtext in inserts |
56361 | 2010-08-30 11:04 | 2012-05-30 7:04 | MySQL Server: Stored Routines | Verified (4322 days) | S4 | Any | Any | Table Methods | |
56488 | 2010-09-02 9:46 | 2016-12-18 20:32 | MySQL Cluster: NDB API | Verified (2658 days) | S3 | mysql-5.1-telco-6.2 | Any | Any | NdbApi : Improve Blob/internal operation management |
56587 | 2010-09-06 10:13 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | No Feedback (4922 days) | S1 | 5.1.45 | Any | Any | mysqldump fails to dump database |
56801 | 2010-09-15 17:29 | 2010-09-15 18:49 | MySQL Server | Not a Bug (4944 days) | S2 | 5.1.38-community and probably ohters | Any | Any | Rounding error when insert decimal value |
56972 | 2010-09-23 15:22 | 2011-02-16 23:44 | MySQL Workbench: Administration | No Feedback (4878 days) | S3 | 5.2.28 | Any | Any | Large slow_log entries freeze Workbench |
57188 | 2010-10-01 21:58 | 2013-03-03 20:45 | MySQL Server: Archive storage engine | Verified (4928 days) | S3 | 5.1.51, 5.5.6 | Any | Any | checksum table gives 0 until 'show table status' is run against the table |
57215 | 2010-10-04 12:34 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Verified | S3 | 5.1.50 | Any | Any | View definitions are lost in mysqldump's output on error: 1049 with --force |
57355 | 2010-10-10 20:15 | 2018-06-24 20:45 | MySQL Workbench: Administration | Verified (4918 days) | S4 | 5.2.28, 5.2.29 | Any | Any | INSERT FIELD length |
57358 | 2010-10-10 22:26 | 2011-02-16 23:44 | MySQL Server: InnoDB Plugin storage engine | Won't fix (4916 days) | S4 | Any | Any | Any | Add option to not cluster the table around NOT NULL UNIQUE indexes automatically |
57544 | 2010-10-19 0:06 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified | S4 | 5.0, 5.1 | Any | Any | "Sending data" state split |
57594 | 2010-10-20 8:32 | 2012-05-18 20:19 | MySQL Workbench: Modeling | Duplicate (4903 days) | S4 | 5.2.28 | Any | Any | Comment fields for DB schema documentaion too short |
57733 | 2010-10-26 9:43 | 2011-02-16 23:44 | MySQL Workbench: Modeling | Verified (4901 days) | S4 | ALL | Any | Any | During data insert/update show foreign key values |
57821 | 2010-10-28 18:12 | 2018-09-09 20:45 | MySQL Server: Parser | Duplicate (3875 days) | S3 | 5.1+ | Any | Any | select columnname,* from tablename failes |
58131 | 2010-11-11 3:06 | 2010-11-17 0:46 | MySQL Server: Parser | Not a Bug (4881 days) | S3 | 5.1.51 | Any | Any | Inconsistent handling of out of range values |
58143 | 2010-11-11 16:10 | 2014-12-30 14:29 | MySQL Server: Locking | No Feedback (4852 days) | S1 | 5.1.54 | Any | Any | insert delayed corrupts the table cache... |
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 |
58489 | 2010-11-25 12:42 | 2013-03-05 14:18 | MySQL Server: Locking | Won't fix (4042 days) | S3 | 5.5 | Any | Any | FLUSH TABLES WITH READ LOCK - issue with concurrent load |
58719 | 2010-12-03 19:05 | 2010-12-15 12:13 | MySQL Server: Optimizer | Not a Bug (4853 days) | S3 | mysql-5.5.8 | Any | Any | Server does not report ER_SP_FETCH_NO_DATA warning any more |
58935 | 2010-12-15 4:36 | 2011-02-16 23:44 | MySQL Server: Documentation | Closed (4852 days) | S3 | Any | Any | ALTER DATABASE can be used in prepared statements | |
59035 | 2010-12-19 1:57 | 2011-03-26 16:40 | Connector / NET | Duplicate (4752 days) | S4 | 6.3.4 | Any | Any | Distributed transaction |
59172 | 2010-12-26 9:01 | 2010-12-26 11:16 | Connector / J Documentation | Not a Bug (4842 days) | S5 | 5.5 | Any | Any | values of a row diff values of another row in a table |
59203 | 2010-12-29 4:38 | 2015-02-24 16:10 | MySQL Server: Optimizer | Closed (3321 days) | S1 | 5.0.91,5.1.39,5.1.55,5.5.8 | Any | Any | Serious optimizer failure when query is encapsulated in additional SELECT/INSERT |
59226 | 2010-12-30 2:59 | 2010-12-30 14:02 | MySQL Server: InnoDB Plugin storage engine | Not a Bug (4838 days) | S3 | 5.1.52 | Any | Any | 5.1 plugin crashes during crash recovery of 5.5.8 database |
59286 | 2011-01-04 18:05 | 2011-02-27 0:00 | MySQL Workbench: Modeling | No Feedback (4780 days) | S2 | 5.2.31 | Any | Any | INSERTS |
59287 | 2011-01-04 18:05 | 2011-02-16 23:44 | MySQL Workbench | Duplicate (4813 days) | S2 | 5.2.31 | Any | Any | INSERTS |
59485 | 2011-01-13 20:41 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Can't repeat (4795 days) | S1 | 5.6.2 | Any | Any | Failing assertion: buf_size <= sizeof(ulint) |
59526 | 2011-01-15 14:08 | 2018-09-09 20:45 | MySQL Server: DML | Verified (4806 days) | S3 | 5.0, 5.1, 5.6.2 | Any | Any | ZERO-date can be inserted in 'no_zero_date' sql_mode |
59715 | 2011-01-25 14:15 | 2011-12-20 4:41 | MySQL Server: Errors | Closed (4483 days) | S3 | 5.1.54 | Any | Any | UPDATE IGNORE, 1 row affected |
59767 | 2011-01-27 2:01 | 2022-12-04 20:45 | MySQL Server: Security: Privileges | Verified (4810 days) | S4 | 5.0.67 and up | Any | Any | CREATE INDEX requires INDEX_ACL but ignore ALTER_ACL |
59885 | 2011-02-02 10:19 | 2011-03-24 0:00 | MySQL Server: InnoDB storage engine | No Feedback (4755 days) | S3 | 5.1.54 | Any | Any | Specific INSERT syntax fails after UPDATING. |
60460 | 2011-03-14 12:37 | 2011-03-15 8:57 | MySQL Server: Locking | Closed (4763 days) | S3 | 5.1.53 | Any | Any | Locked threads are not killed with 'KILL <process_id>' |
60940 | 2011-04-21 3:56 | 2011-04-21 7:28 | MySQL Server: General | Duplicate (4726 days) | S4 | Any | Any | Implement Common Table Expressions as defined by the ANSI SQL 99 standard | |
60980 | 2011-04-26 14:54 | 2011-04-26 15:38 | MySQL Server: Stored Routines | Not a Bug (4721 days) | S3 | 5.1.47 | Any | Any | SHOW PROCEDURE CODE example returns an error |
61009 | 2011-04-29 16:21 | 2011-05-29 23:00 | MySQL Utilities | No Feedback (4688 days) | S2 | 5.5.11 | Any (did not work) | Any | Ran a create database and nothing happened just this error |
61112 | 2011-05-10 7:31 | 2011-05-12 9:16 | MySQL Server: Views | Verified (4707 days) | S3 | 5.1.55 | Any | Any | Unqualified table names are changed silently |
61317 | 2011-05-27 6:58 | 2011-09-20 23:00 | MySQL Server | No Feedback (4575 days) | S5 | 4.1 | Any | Any | Many locked connections while one connection is "Sending data" |
61361 | 2011-05-31 10:59 | 2023-06-16 3:06 | MySQL Server | Not a Bug (4549 days) | S3 | 5.5.9 | Any | Any | Possible of duplicated primary key by enum type |
61375 | 2011-06-01 13:49 | 2017-04-26 17:17 | MySQL Server: DML | Not a Bug (4685 days) | S3 | 5.5 | Any | Any | Auto Increment Syntax |
61401 | 2011-06-03 17:47 | 2011-06-16 19:49 | MySQL Server: Locking | Closed (4670 days) | S5 | MySQL 5.5.3+ | Any | Any | UPDATE performance degrades gradually if a trigger exists |
61408 | 2011-06-04 18:37 | 2011-06-05 17:06 | MySQL Server: Data Types | Not a Bug (4681 days) | S3 | 5.0.90 | Any | Any | incorrect behaviour of user-defined variables |
61711 | 2011-06-30 16:45 | 2012-12-24 9:36 | MySQL Server: Stored Routines | Duplicate (4113 days) | S3 | 5.5.13, 5.5.15 | Any | Any | CURSOR does not accept variables in LIMIT clause |
61735 | 2011-07-04 11:30 | 2011-07-08 6:02 | MySQL Server: InnoDB storage engine | Verified (4648 days) | S3 | 5.1, etc | Any | Any | index->lock held while preads are done |
61890 | 2011-07-17 4:25 | 2020-11-20 7:06 | MySQL Server: DDL | Verified (4639 days) | S4 | 8.0 | Any | Any | truncate if exists |
61956 | 2011-07-22 16:05 | 2013-05-16 4:48 | MySQL Server: InnoDB storage engine | Closed (3970 days) | S2 | 5.0, 5.1, 5.1.57 | Any | Any | Undo Slots not available after being maxed out from UPDATE statements |
62268 | 2011-08-26 14:20 | 2011-09-12 10:03 | MySQL Enterprise Backup | Closed (4582 days) | S1 | 3.6.0 | Any | Any | mysqlbackup 3.6 will not work with ROW based binlogs and READ-COMMITTED |
62277 | 2011-08-28 13:26 | 2011-08-31 4:42 | MySQL Server: Documentation | Not a Bug (4594 days) | S3 | 5.5 | Any | Any | data types defaults |
62317 | 2011-09-01 8:59 | 2015-02-03 4:01 | MySQL Workbench: Modeling | Closed (3342 days) | S2 | 5.2.34 | Any (XP SP3, Mac OS X) | Any | dbDesigner 4 Import |
62337 | 2011-09-02 21:44 | 2011-09-02 22:25 | MySQL Server: Compiling | Can't repeat (4592 days) | S3 | Any | Any | there is n't this database | |
62455 | 2011-09-16 22:13 | 2011-09-29 16:57 | MySQL Server: Documentation | Closed (4565 days) | S3 | 5.5.15.0 | Any (Win XP SP3) | Any | ALTER SCHEMA or TABLE needs to recompile associated routines |
62541 | 2011-09-26 9:53 | 2011-10-27 4:44 | MySQL Server | Closed (4537 days) | S4 | 5.1.23 | Any | Any | NAME_CONST('in_keyRef',_utf8'gT8nm3rWD+eILdXphATJ/w==') ERROR |
62557 | 2011-09-27 20:52 | 2012-09-07 13:59 | MySQL Server: Replication | Closed (4221 days) | S2 | 5.1, 5.5 | Any | Any | SHOW SLAVE STATUS gives wrong output with master-master and using SET uservars |
62580 | 2011-09-30 6:43 | 2011-09-30 17:47 | MySQL Server: DML | Not a Bug (4564 days) | S3 | 5.5.8 | Any | Any | Allow insert null |
62617 | 2011-10-04 15:34 | 2013-01-28 18:48 | MySQL Server: Optimizer | Closed (4078 days) | S3 | 5.6.3, 5.6.4 | Any | Any | EXPLAIN EXTENDED wiht DELETE, UPDATE etc. |
62662 | 2011-10-09 21:27 | 2012-12-26 8:15 | MySQL Server | Not a Bug (4111 days) | S4 | Any | Any | how to retrieve multiple insert IDs | |
63408 | 2011-11-23 20:48 | 2012-05-31 15:03 | MySQL Workbench: Modeling | Not a Bug (4321 days) | S2 | 5.2.35 | Any | Any | Generated SQL inserts in wrong order (failing PK requirements) |
63807 | 2011-12-20 12:05 | 2012-07-06 5:05 | MySQL Workbench: Modeling | Closed (4284 days) | S3 | 5.2.36, 5.2.37 | Any | Any | WB creates incorrect create query when a if using view |
64004 | 2012-01-12 4:12 | 2012-01-12 15:54 | MySQL Server: Charsets | Not a Bug (4460 days) | S3 | Any | Any | Mysql see two different unicode characters as the same | |
64025 | 2012-01-13 14:21 | 2012-01-15 19:15 | MySQL Server: DML | Verified (4459 days) | S3 | 5.1.61, 5.5.15 | Any | Any | ON DUPLICATE KEY UPDATE sets auto_increment column value to 0 |
64135 | 2012-01-26 15:09 | 2012-12-13 16:06 | MySQL Server: Command-line Clients | Closed (4124 days) | S3 | 5.5.15, 5.6.5 | Any | Any | Delimiter strips the next new line in a SQL statement |
64224 | 2012-02-03 22:15 | 2016-02-04 10:22 | MySQL Server: Data Types | Verified (4437 days) | S2 | 5.1.52, 5.1.56, 5.5.20, 5.6.28 | Any | Any | bug in fractional part of unsigned decimals |
64247 | 2012-02-07 10:08 | 2019-11-06 21:28 | MySQL Server: DML | Closed (1605 days) | S2 | 5.5.18, 5.5.21 | Any | Any | Abnormal behaviour of str_to_date() function |
64248 | 2012-02-07 10:18 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Verified (4434 days) | S4 | 5.1, 5.5 | Any | Any | create secondary indexes after inserting rows statements in mysqldump |
64301 | 2012-02-11 13:54 | 2012-02-17 17:51 | MySQL Server: DML | Duplicate (4424 days) | S3 | Any | Any | Wrong row count returned with 'NO_AUTO_VALUE_ON_ZERO' sql_mode | |
64511 | 2012-03-01 10:47 | 2012-03-06 13:06 | MySQL Server: Replication | Closed (4406 days) | S3 | any | Any | Any | binlog_ignore_db and binlog_do_db at the same time |
64664 | 2012-03-15 21:16 | 2012-03-16 16:14 | Connector / J | Not a Bug (4396 days) | S5 | mysql connector java 5.1.18 | Any | Any | Batched inserts are as slow as individual inserts |
64879 | 2012-04-05 14:38 | 2012-04-10 19:03 | MySQL Server: Documentation | Closed (4371 days) | S3 | 5.1+ | Any | Any | Mysqlslap documentation assumes a Linux console syntax for multiline statements |
64883 | 2012-04-05 22:35 | 2012-04-09 11:08 | MySQL Server: DML | Verified (4375 days) | S3 | 5.1.61, 5.5.22 | Any (Windows 7 (64 bit), Mac OS X) | Any | ROW_COUNT() returns -1 for LOAD DATA INFILE |
65025 | 2012-04-18 19:10 | 2012-04-27 18:52 | MySQL Server: Replication | Won't fix (4354 days) | S2 | 5.1.48, 5.1.62 | Any (CentOS 5, RHEL 6, MacOSx 10.7) | Any | The maximum floating point value breaks replication. |
65094 | 2012-04-24 16:53 | 2012-07-30 15:17 | MySQL Server: GIS | Closed (4260 days) | S3 | 5.1.57, 5.1.58, 5.5.25 | Any | Any | srid information not included when inserting GIS data with GeomFromWKB functions |
65146 | 2012-04-29 12:12 | 2013-07-10 17:36 | MySQL Server: InnoDB storage engine | Closed (3915 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | WITH CONSISTENT SNAPSHOT does not work with isolation level SERIALIZABLE |
65164 | 2012-05-01 17:08 | 2013-08-28 19:58 | MySQL Server: InnoDB Plugin storage engine | Closed (3866 days) | S3 | 5.1,5.6 | Any | Any | confused about docs and behavior for InnoDB gap locks |
65251 | 2012-05-09 9:27 | 2014-04-04 16:50 | MySQL Workbench: Modeling | Duplicate (3647 days) | S4 | 5.2.33 | Any | Any | Allow automatic execution of procudures after forward engineering |
65273 | 2012-05-10 1:53 | 2013-09-27 5:22 | MySQL Utilities | Closed (3836 days) | S2 | 5.2.39 | Any (Windows Server 2003 DataCenter, Linux) | Any | export database which contains Chinese Simplied characters |
65443 | 2012-05-28 21:18 | 2012-09-18 10:07 | MySQL Server: InnoDB storage engine | Duplicate (4210 days) | S1 | 5.6 | Any | Any | Failure when applying insert buffer changes during crash recovery |
65497 | 2012-06-02 21:51 | 2012-06-03 7:45 | MySQL Server: Parser | Not a Bug (4317 days) | S3 | 5.5 | Any | Any | sql_no_cache processed as field name in dependent subquery on mysql 5.5 |
65648 | 2012-06-18 8:07 | 2013-07-04 13:14 | MySQL Server: InnoDB storage engine | Not a Bug (3921 days) | S2 | 5.1.63, 5.5.24 | Any (Linux, Windows) | Any | Foreign key and uppercase / lowercase values |
65731 | 2012-06-25 22:32 | 2012-06-26 16:16 | MySQL Server | Duplicate (4294 days) | S2 | 5.5.25 | Any | Any | ALTER IGNORE behaves differently than documented |
65889 | 2012-07-13 0:21 | 2012-07-16 10:18 | MySQL Server: InnoDB storage engine | Verified (4277 days) | S3 | <=5.5 | Any | Any | Appended primary key stored inefficiently in unique surrogate keys |
66034 | 2012-07-26 19:01 | 2012-08-01 7:08 | MySQL Server: Data Types | Verified (4263 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | Inconsistent results while comparing time fields with string and number literals |
66563 | 2012-08-28 5:37 | 2012-08-28 6:55 | MySQL Server: InnoDB Plugin storage engine | Verified (4231 days) | S5 | 5.1,5.6 | Any | Any | reduce the number of redundant calls to btr_cur_optimistic_insert() |
66587 | 2012-08-28 23:04 | 2013-05-23 16:55 | MySQL Server: InnoDB storage engine | Closed (3963 days) | S3 | 5.6.7 | Any | Any | Behavior of read-only transactions differs from documentation |
66683 | 2012-09-04 13:57 | 2012-09-04 18:47 | MySQL Server: InnoDB storage engine | Verified (4224 days) | S3 | 5.5.27 | Any | Any | InnoDB doesn't report DB_OUT_OF_FILE_SPACE during recovery |
66836 | 2012-09-16 18:49 | 2012-09-17 0:24 | MySQL Server: InnoDB storage engine | Can't repeat (4211 days) | S3 | 5.5.27 | Any | Any | Failing assertion: current <= max_value in ha_innodb.cc on out-of-range autoinc |
67196 | 2012-10-11 21:00 | 2012-10-12 12:22 | MySQL Server: InnoDB storage engine | Verified (4186 days) | S3 | 5.5, 5.6 | Any | Any | ENUM type not treated correctly in HAVING w/ MAX() |
67447 | 2012-11-01 12:33 | 2012-11-01 12:35 | MySQL Server: DDL | Open | S4 | 5.2 | Any | Any | Tools/Options needs Define Primary Key |
67500 | 2012-11-07 9:25 | 2012-11-07 9:34 | MySQL Server: InnoDB storage engine | Duplicate (4160 days) | S1 | 5.6 | Any | Any | Online DDL create unique index is incorrect |
67676 | 2012-11-22 6:37 | 2014-07-14 12:23 | MySQL Server: Prepared statements | Closed (4022 days) | S2 | 5.6.7 | Any | Any | prepared statement is very slow while binlog was enabled |
67810 | 2012-12-05 6:31 | 2013-03-24 4:29 | MySQL Workbench: SQL Editor | Closed (4023 days) | S4 | Any | Any | Implement QueryBrowser feature to right-click column headers to copy columns | |
67886 | 2012-12-12 18:49 | 2012-12-12 19:16 | MySQL Server | Can't repeat (4125 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 |
67894 | 2012-12-13 13:09 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Not a Bug (4124 days) | S3 | 5.1+ | Any | Any | unsuitable default behavior in mysqldump |
67930 | 2012-12-17 18:58 | 2012-12-27 17:21 | MySQL Server: Backup | Not a Bug (4110 days) | S3 | 5.5 | Any | Any | mysqldump POINT field format incompatible with UTF-8, hex-blob doesn't apply |
67942 | 2012-12-18 21:34 | 2012-12-20 16:56 | MySQL Server: Row Based Replication ( RBR ) | Verified (4117 days) | S3 | 5.5, 5.6, 5.5.30 | Any | Any | CREATE TABLE is not written in binary log if connection is killed in the process |
67984 | 2012-12-28 17:51 | 2012-12-28 17:54 | MySQL Server: Data Types | Verified | S4 | 5.5.30, all | Any | Any | Don't allow insertion of not supported dates |
68057 | 2013-01-09 11:54 | 2013-01-10 9:31 | MySQL Cluster: Replication | Not a Bug (4096 days) | S1 | 7.2.10 | Any | Any | Cluster Replication to other storage engines (could be also to other clusters) |
68077 | 2013-01-14 3:37 | 2013-04-03 11:33 | MySQL Server: InnoDB storage engine | Closed (4013 days) | S5 | 5.6 | Any | Any | Mixing 4K/16K blocks increases 8K free blocks and holds buf pool mutex longer |
68299 | 2013-02-07 5:40 | 2013-05-30 2:07 | MySQL Server: Optimizer | Closed (3956 days) | S3 | 5.6 | Any | Any | unexcepted "Using where" in "explain update/delete" |
68577 | 2013-03-05 19:29 | 2019-12-12 16:14 | MySQL Server: Data Types | Verified (4042 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | Incorrect enum values returned when using UNION after CREATE AS SELECT |
68609 | 2013-03-08 0:28 | 2014-10-09 16:07 | MySQL Server: Replication | Won't fix (3459 days) | S3 | 5.5.30, 5.6.10 | Any | Any | MBR: Unique key updates are not marked unsafe, replication fails |
68662 | 2013-03-13 19:16 | 2013-03-13 19:16 | MySQL Server: Stored Routines | Open | S4 | Any | Any | Request for the ability to run self-locking/self-altering triggers (known risks) | |
68818 | 2013-03-30 5:29 | 2013-04-01 14:37 | MySQL Server: Optimizer | Duplicate (4015 days) | S3 | 5.6.10 | Any | Any | Large Value List in WHERE Clause Spends Too Much Time in 'statistics' State |
68931 | 2013-04-11 10:49 | 2013-04-12 12:12 | MySQL Server: Data Types | Not a Bug (4004 days) | S3 | 5.5.29 | Any | Any | saving some timestamp values are incorrect in mysql 5.5.29 |
68932 | 2013-04-11 11:19 | 2013-06-06 15:52 | MySQL Server: Logging | Closed (3949 days) | S1 | 5.6.10, 5.6.12 | Any | Any | A regression in 5.6 crash recovery atomicity |
69054 | 2013-04-24 14:11 | 2013-06-27 0:45 | MySQL Workbench | Closed (3928 days) | S3 | 5.2.47 | Any | Any | Forward Engineer should process inserts, then create foreign keys |
69075 | 2013-04-26 3:07 | 2014-02-19 10:39 | MySQL Server: Memory storage engine | Duplicate (3691 days) | S3 | 5.6.11, 5.6.15 | Any | Any | Memory leak slave_parallel_workers |
39466 | 2008-09-16 3:03 | 2012-05-18 20:19 | MySQL Server: DML | Duplicate (5635 days) | S4 | 5.0+ | Any | Any | Implement INSTEAD OF Triggers |
40674 | 2008-11-12 19:24 | 2015-04-14 12:38 | MySQL Server | Not a Bug (3272 days) | S3 | 5.0+ | Any | Any | SELECT ROW = (SELECT sum(outer col) FROM DUAL) ...: incorrect number of rows |
41114 | 2008-11-28 20:36 | 2011-02-16 23:43 | MySQL Server: Locking | Can't repeat (4817 days) | S2 | 5.0.70, 5.1.30, 5.5.0 | Any | Any | DDL + insert delayed + kill causes infinite hang and 100% cpu waiting for tables |
41559 | 2008-12-17 16:01 | 2009-01-15 14:09 | MySQL Workbench | Not a Bug (5552 days) | S3 | 5.0.29 | Any | Any | Wrong insert order in last versions |
41721 | 2008-12-23 21:37 | 2009-08-17 19:35 | MySQL Server: Backup | Duplicate (5338 days) | S3 | 6.0-backup | Any | Any | Restore generates lots of warnings |
42087 | 2009-01-13 15:52 | 2011-02-16 23:43 | MySQL Server: General | Verified (5490 days) | S2 | 5.1.30 | Any | Any | Statement.executeUpdate() gives strange update count with INSERT ...ON DUPLICATE |
42361 | 2009-01-27 3:03 | 2009-01-27 9:03 | MySQL Enterprise Monitor: Documentation | Not a Bug (5540 days) | S3 | 2.0 | Any | Any | Inappropriate example for creating a user for an agent. |
42376 | 2009-01-27 14:51 | 2009-01-30 9:36 | Connectors: DBD::mysql ( Perl ) | Not a Bug (5537 days) | S3 | 4.010 | Any | Any | Query with SQL variables behaves different on DBI than on CLI |
43306 | 2009-03-02 13:16 | 2012-05-18 20:19 | MySQL Server: Charsets | Duplicate (5496 days) | S1 | 5.1, 6.0 | Any | Any | Wrong utf8 collation default behaviour |
43311 | 2009-03-02 20:23 | 2011-02-16 23:43 | MySQL Server: General | Duplicate (5474 days) | S2 | 5.0.77 | Any | Any | Wrong number of affected rows returned for insert on duplicate key |
43602 | 2009-03-12 15:43 | 2011-02-16 23:43 | Connector / J | Can't repeat (5496 days) | S2 | 5.1.7 | Any | Any | specific year,month,day,hour combination throws MysqlDataTruncationException |
43658 | 2009-03-15 16:07 | 2009-03-15 18:42 | MySQL Server: DML | Not a Bug (5493 days) | S1 | 5.1 | Any | Any | The code below returns an error, while other databases allow it |
43895 | 2009-03-26 18:45 | 2014-07-14 15:31 | MySQL Server: DML | Closed (3546 days) | S3 | 5.1 bzr | Any | Any | Multi-DELETE IGNORE does not report warnings |
44228 | 2009-04-13 0:35 | 2009-04-18 20:51 | Connector / NET | Not a Bug (5459 days) | S2 | 5.2.5 | Any | Any | Unable to insert UTF string into varchar column |
44275 | 2009-04-14 21:58 | 2012-05-18 20:19 | MySQL Workbench | Duplicate (5460 days) | S1 | 5.1.10 Beta Build 5309 | Any | Any | No INSERT Statements are being generated |
44973 | 2009-05-20 8:30 | 2011-02-16 23:43 | Connector / NET | Duplicate (5427 days) | S1 | 6.0.3 | Any | Any | Can't insert backslash |
45864 | 2009-06-30 20:20 | 2011-02-16 23:44 | MySQL Server | Duplicate (5385 days) | S2 | 5.1.35, 5.1 bzr | Any | Any | insert on one connection, immediate query on another produces no result |
45903 | 2009-07-02 10:42 | 2009-07-03 8:59 | MySQL Server: Data Types | Not a Bug (5383 days) | S3 | 5.1 | Any (SQL) | Any | insert date fields should give an error if inserted Data is not formated correct |
45986 | 2009-07-07 3:16 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Can't repeat (5378 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 |
46675 | 2009-08-12 13:35 | 2011-08-19 15:15 | MySQL Server: General | Closed (4606 days) | S3 | server 5.1.37 | Any (MS Windows, Mac, Linux) | Any | ON DUPLICATE KEY UPDATE and updateCount() possibly wrong |
46911 | 2009-08-25 6:56 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (5316 days) | S2 | 5.1.37 | Any | Any | Inconsistent SHOW CREATE TABLE result before/after FLUSH STATUS w/ partitioning |
47118 | 2009-09-04 1:35 | 2020-11-25 3:42 | MySQL Server: General | Verified (1220 days) | S1 | 5.1.39, 5.1.37, 5.0.83,8.0.22, 5.6.10 | Any | Any | Wrong auto_increment value when auto_increment_offset > auto_increment_increment |
49733 | 2009-12-16 11:05 | 2012-05-18 20:19 | MySQL Server: General | Duplicate (5216 days) | S3 | 5.0, mysqld-5.1.41-community, 5.1, next-mr bzr | Any (MS Windows, Linux) | Any | using backslash in NO_BACKSLASH_ESCAPES mode can cause corruption |
50238 | 2010-01-11 15:08 | 2022-12-04 20:45 | MySQL Server: Security: Privileges | Verified | S3 | 5.5.1-m2 | Any | Any | 'GRANT SUPER' doesn't give 'TABLESPACE' priv in fresh 5.5, upgrade from 5.1 does |
50507 | 2010-01-21 14:12 | 2015-07-15 15:38 | MySQL Server | Closed (3683 days) | S3 | 5.0+ | Any | Any | Behavior of logarithmic functions depends on ERROR_FOR_DIVISION_BY_ZERO |
51016 | 2010-02-09 8:57 | 2020-05-03 20:45 | MySQL Server: Optimizer | Duplicate (5160 days) | S3 | 6.0-codebase-bugfixing | Any | Any | Batched key access gives wrong results for T0 semijoin (T1 join T2) |
51966 | 2010-03-11 19:08 | 2011-02-16 23:44 | MySQL Server: Locking | No Feedback (5098 days) | S3 | 5.1.40-community | Any | Any | INSERT ... SELECT should allow concurrent inserts when binary log is disabled. |
54677 | 2010-06-21 18:25 | 2013-06-14 19:46 | MySQL Server | Verified | S4 | 5.6 | Any | Any | INSERT INTO ... ON FAILURE UPDATE ... |
55978 | 2010-08-13 18:54 | 2011-02-16 23:44 | MySQL Server: DML | No Feedback (4913 days) | S4 | Any | Any | Improvement Mysql Date Manipulation Language | |
58379 | 2010-11-22 12:37 | 2014-07-23 20:46 | MySQL Workbench: Modeling | Closed (3537 days) | S4 | 5.2.31 | Any | Any | Insert with Recursave dependency in Foreign Keys throws error |
58799 | 2010-12-07 19:55 | 2010-12-18 0:13 | MySQL Server: Command-line Clients | Not a Bug (4850 days) | S2 | Any | Any | You cannot revoke using db.* syntax grants given with db.tablename | |
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 |
60173 | 2011-02-18 20:54 | 2013-05-30 19:33 | MySQL Server: Replication | Closed (3956 days) | S2 | 5.1.47, 5.1.64, 5.5.27 | Any | Any | Partially written insert statement in binlog -- no errors reported |
61134 | 2011-05-11 14:32 | 2011-05-17 14:17 | Connector / J | Duplicate (4700 days) | S2 | 5.1.16 | Any | Any | bad row affected values with INSERT ON DUPLICATE KEY UPDATE |
61548 | 2011-06-17 8:55 | 2012-11-16 13:07 | MySQL Server: Replication | Closed (4151 days) | S3 | 5.1 and others | Any | Any | autoinc value persistency breaks certain replication scenarios |
61962 | 2011-07-23 21:43 | 2011-08-06 12:44 | MySQL Server | Not a Bug (4619 days) | S1 | 5.5.14 | Any (Tested on 5.5.8 and 5.5.14) | Any | 'ON DUPLICATE KEY UPDATE' bug incrementing ID (auto increment field) on Updates |
63692 | 2011-12-09 7:38 | 2011-12-09 8:08 | MySQL Server: General | Unsupported (4494 days) | S3 | Any | Any | Unable to insert certain big ascii characters under utf8 encoding | |
64428 | 2012-02-23 2:15 | 2012-02-23 4:14 | MySQL Enterprise Monitor: Server | Not a Bug (4418 days) | S5 | 5 | Any | Any | How To insert data to table from other Host in Public IP |
64817 | 2012-03-30 16:04 | 2012-03-31 7:32 | MySQL Server: DML | Not a Bug (4381 days) | S3 | 5.1 | Any | Any | INSERT INTO ... VALUES(0,... uses auto_increment value instead |
66079 | 2012-07-30 2:59 | 2012-08-01 14:19 | MySQL Server: InnoDB storage engine | Verified (4260 days) | S5 | 5.5+ | Any | Any | unnecessary calling trx_sys_update_mysql_binlog_offset when sql_log_bin=0 |
66188 | 2012-08-03 20:02 | 2012-10-06 1:00 | MySQL Server: Options | No Feedback (4193 days) | S3 | 5.5.23, 5.5.27 | Any | Any | Cannot use CREATE TEMPORARY...INSERT with InnoDB when read_only is set |
66540 | 2012-08-25 20:04 | 2013-01-23 1:00 | MySQL Server: DML | No Feedback (4084 days) | S4 | Any | Any | Redundant coding in ON DUPLICATE KEY UPDATE | |
66586 | 2012-08-28 21:51 | 2013-01-10 12:20 | MySQL Server: InnoDB storage engine | Closed (4096 days) | S3 | 5.6.6, 5.6.7 | Any | Any | SHOW INNODB STATUS and I_S show wrong transaction start time and duration |
66871 | 2012-09-19 13:13 | 2015-01-09 9:50 | Connector / C++ | Not a Bug (3367 days) | S1 | 1.1.1 | Any | Any | #error 1040, Too many connections, How to disconnect mysql connection manual use |
67535 | 2012-11-09 13:41 | 2014-02-03 0:33 | MySQL Server: DML | Verified (4147 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 |
67978 | 2012-12-27 6:13 | 2012-12-29 16:21 | MySQL Server: Memory storage engine | Verified (4108 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | Signed zero is handled incorrectly by HASH indexes and GROUP BY |
68041 | 2013-01-06 3:29 | 2013-07-19 15:02 | MySQL Server: DML | Closed (3906 days) | S3 | 5.6.9 | Any | Any | Zero date can be inserted in strict no-zero mode through a default value |
68192 | 2013-01-27 20:52 | 2013-01-28 15:40 | MySQL Server: Data Types | Verified (4078 days) | S3 | 5.1, 5.5, 5.6.9 | Any | Any | Limitation on DOUBLE or REAL length is ignored with INSERT .. SELECT |
68472 | 2013-02-23 15:45 | 2013-03-07 16:25 | MySQL Server: Data Types | Closed (4040 days) | S3 | 5.6.10 | Any | Any | TIMESTAMP logic remains partly non-standard with explicit_defaults_for_timestamp |
68885 | 2013-04-08 7:46 | 2013-04-21 12:09 | MySQL Server: DML | Verified (3995 days) | S4 | 5.5+ | Any | Any | a new parameter to control whether rollback a whole transaction on statment fail |
69122 | 2013-05-02 6:06 | 2014-02-02 17:47 | MySQL Server: InnoDB storage engine | Closed (3851 days) | S3 | 5.1,5.6 | Any | Any | InnoDB doesn't redo-log insert buffer merge operation if it is done in-place |
70583 | 2013-10-10 8:14 | 2014-08-06 17:08 | MySQL Server: Replication | Closed (3558 days) | S2 | 5.6.14 | Any | Any | INSERT ON DUPLICATE KEY UPDATE failing after MySQL 5.6 upgrade. |
72314 | 2014-04-11 5:04 | 2015-02-25 5:01 | MySQL Server: Replication | Closed (3320 days) | S1 | Any | Any | stop io_thread, start io_thread with GTID may cause data inconsistencies | |
72748 | 2014-05-26 8:56 | 2018-10-11 17:07 | MySQL Server: Locking | Can't repeat (1996 days) | S2 | 5.6.17, 5.6.19, 5.6.21 | Any | Any | INSERT...SELECT fails to block concurrent inserts, results in additional records |
73056 | 2014-06-19 21:34 | 2018-03-15 14:17 | MySQL Server: Prepared statements | Closed (2940 days) | S5 | 5.7, 5.7.8 | Any | Any | Prepared Statements ABSURDLY SLOW due to inefficient query creation for logging |
73399 | 2014-07-25 18:32 | 2014-07-25 18:56 | MySQL Server: Stored Routines | Verified (3535 days) | S1 | 5.6.14, 5.0.97, 5.1.74, 5.5.39, 5.6.21, 5.7.5 | Any | Any | BEFORE INSERT TRIGGER not fired |
73601 | 2014-08-15 12:33 | 2016-04-27 15:03 | MySQL Server: Replication | Closed (3291 days) | S2 | 5.7 | Any | Any | Crash on direct insert into mysql.gtid_executed table |
75189 | 2014-12-12 7:09 | 2014-12-19 22:15 | MySQL Server: Tests | Verified (3388 days) | S3 | 5.6 | Any | Any | engines suite tests depending on InnoDB implementation details |
77783 | 2015-07-20 7:01 | 2019-10-25 12:00 | MySQL Server: InnoDB storage engine | Can't repeat (1617 days) | S5 | 5.7, 5.6 | Any | Any | performance dropped when changing innodb_change_buffering from inserts to all |
77959 | 2015-08-06 10:45 | 2021-02-18 9:57 | MySQL Server: Tests | Duplicate (1135 days) | S3 | 5.7.8, 5.7.9 | Any | Any | max_statement_time test is unstable |
78127 | 2015-08-18 12:16 | 2019-11-26 21:50 | MySQL Server: DML | Closed (1585 days) | S3 | 5.6.22, 5.5.46, 5.6.26 | Any | Any | In consistent behavior between similar UPDATE sqls, error vs warning |
78239 | 2015-08-27 8:08 | 2018-02-06 18:18 | MySQL Workbench | Verified (2243 days) | S4 | 6.3 | Any | Any | Insert new column at cursor |
78253 | 2015-08-28 8:35 | 2015-09-01 6:35 | MySQL Server: DML | Not a Bug (3132 days) | S5 | 4.2.11 | Any | Any | A major problem is found in insert query of my sql which need attention |
78348 | 2015-09-06 9:09 | 2015-09-07 7:38 | MySQL Server: Command-line Clients | Closed (3126 days) | S3 | 5.7.8 | Any | Any | mysqlpump support for 4-byte UTF-8 |
79122 | 2015-11-04 15:41 | 2016-02-04 20:18 | MySQL Server: Prepared statements | Closed (3062 days) | S3 | 5.7.10 | Any | Any | memory leaks when doing INSERT... UPDATE ... prepared statements |
79507 | 2015-12-03 12:55 | 2019-11-28 22:34 | MySQL Server: DML | Closed (1583 days) | S3 | 5.6.22, 5.5.48 | Any | Any | String function insert is not working as doc says |
79567 | 2015-12-09 7:41 | 2019-11-28 22:55 | MySQL Server: DML | Closed (1583 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 |
79909 | 2016-01-11 6:23 | 2020-10-05 12:18 | MySQL Server: DML | Closed (1271 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Get mess code for func INSERT() with str as int const and newstr as multi-byte |
80559 | 2016-02-29 14:32 | 2016-02-29 15:17 | MySQL Server: Parser | Verified (2951 days) | S3 | 5.7.11 | Any | Any | EXPLAIN CREATE TABLE .. AS SELECT .. does not work |
81563 | 2016-05-24 8:18 | 2016-05-26 13:13 | MySQL Server | Not a Bug (2864 days) | S3 | 5.6.21,5.6.16 | Any | Any | Insert operation will add S-lock on one record after deleted one. |
81628 | 2016-05-27 17:25 | 2016-12-12 16:42 | MySQL Server: Replication | Closed (2790 days) | S3 | 5.7.14 | Any | Any | Assertion failure in 'MYSQL_BIN_LOG::prepare()' if DML is passed in --init-file |
81642 | 2016-05-30 11:26 | 2016-05-30 16:02 | MySQL Server: Data Types | Not a Bug (2860 days) | S3 | 5.7.8 | Any | Any | union of decimal(10,1) and decimal(10,9) is not expected decimal(18,9) |
82325 | 2016-07-22 18:08 | 2016-07-25 18:50 | MySQL Server: Data Types | Duplicate (2804 days) | S3 | 5.7.9 | Any | Any | DateTime values rounded in set/insert clause but not in where clause |
82642 | 2016-08-19 3:58 | 2016-08-19 7:59 | MySQL Server: DML | Verified (2779 days) | S3 | 5.6, 5.5.51, 5.6.32 | Any | Any | insert string-format value to datetime and timestamp return different status |
84365 | 2016-12-29 2:44 | 2021-12-18 22:54 | Connector / J | Closed (832 days) | S3 | 8.0.26 | Any | Any | INSERT..VALUE with VALUES function lead to a StringIndexOutOfBoundsException |
84587 | 2017-01-20 13:43 | 2017-06-01 16:21 | MySQL Server: Optimizer | Closed (2502 days) | S2 | 8.0 | Any | Any | WL#9236: including or excluding columns from SELECT list makes results wrong |
85047 | 2017-02-17 11:03 | 2017-07-17 12:30 | MySQL Server: Group Replication | Closed (2482 days) | S2 | 5.7.18 | Any | Any | Secondaries allows transactions through ASYNC setup into the group |
85605 | 2017-03-24 9:56 | 2019-06-25 15:28 | MySQL Server: InnoDB storage engine | Verified (2562 days) | S2 | 5.7, 8.0 | Any | Any | Corrupted index for ON DELETE CASCADE with self-referential ON DELETE SET NULL |
86821 | 2017-06-26 4:06 | 2023-02-10 10:55 | MySQL Server: Stored Routines | Not a Bug (1901 days) | S2 | 5.6, 5.7 | Any | Any | Trigger allocates memory during SELECT |
87734 | 2017-09-12 9:02 | 2017-10-24 14:17 | MySQL Server: Replication | Closed (2366 days) | S3 | 8.0 | Any | Any | Replication does not handle NULL inserted in JSON NOT NULL column correctly |
87794 | 2017-09-18 15:10 | 2017-09-19 15:33 | MySQL Server: DML | Not a Bug (2383 days) | S3 | 5.7.17 | Any | Any | MySQL gives invalid value for float column type. |
88091 | 2017-10-13 22:02 | 2017-10-16 16:32 | Connector / J | Duplicate (2356 days) | S1 | 6.0.6 and 8.0.8 | Any | Any | getTables in mysql connector 6.x+ differs from mysql connector 5.1.41 |
89122 | 2018-01-05 16:47 | 2018-03-19 17:49 | MySQL Server: GIS | Closed (2264 days) | S3 | 8.0.5 | Any | Any | Severe performance regression in server bootstrap |
89965 | 2018-03-08 14:07 | 2020-10-02 12:48 | MySQL Server | Not a Bug (1274 days) | S4 | 8.0 | Any | Any | Need Validation when we insert data to the column with SRID |
90448 | 2018-04-16 12:09 | 2018-04-20 5:46 | MySQL Server: Replication | Verified (2170 days) | S3 | 5.7.21 | Any | Any | INSERT IGNORE not ignored on SQL thread |
90890 | 2018-05-16 15:49 | 2018-09-04 13:25 | MySQL Server: InnoDB storage engine | Closed (2033 days) | S5 | 8.0.11 | Any | Any | CPU overhead for insert benchmark load increased by 2X in 8.0.11 |
91394 | 2018-06-24 21:41 | 2018-12-19 14:15 | Shell AdminAPI InnoDB Cluster / ReplicaSet | Closed (1927 days) | S1 | 8.0.11 | Any | Any | mysqlsh will not recognize root privileges if they are assigned with a role |
92501 | 2018-09-19 12:47 | 2019-05-22 5:53 | MySQL Server: Data Types | Closed (1907 days) | S3 | 5.7, 5.7.23, 8.0.12, 5.6.41 | Any | Any | FROM_UNIXTIME accepts an out of range parameter through rounding |
95079 | 2019-04-23 2:32 | 2019-04-25 9:21 | MySQL Server: InnoDB storage engine | Verified (1802 days) | S3 | 5.7, 5.7.25 | Any | Any | False duplicate key check |
95096 | 2019-04-24 1:27 | 2019-04-24 6:03 | MySQL Server: DML | Not a Bug (1801 days) | S3 | Any | Any | INSERT INTO ... ON DUPLICATE KEY UPDATE returns wrong number of rows updated | |
96053 | 2019-07-02 7:17 | 2020-04-13 16:44 | MySQL Server: mysqldump Command-line Client | Closed (1446 days) | S2 | 8.0.13, 8.0.16, 5.7.26 | Any | Any | mysqldump generates invalid insert statements with varbinary columns |
96628 | 2019-08-23 3:21 | 2019-08-24 2:23 | Connector / J | Not a Bug (1679 days) | S1 | 8.0.17 | Any | Any | mysql batch insert generatedKeys not accord expected |
96748 | 2019-09-04 11:59 | 2023-03-22 13:45 | MySQL Server: Locking | Not a Bug (1668 days) | S3 | 8.0.17 | Any | Any | deadlock when doing SELECT FOR UPDATE and INSERT |
97027 | 2019-09-26 10:02 | 2021-01-15 16:47 | MySQL Server: Row Based Replication ( RBR ) | Verified (1169 days) | S2 | 5.7.* | Any | x86 | Bulk insert with ON DUPLICATE KEY UPDATE breaks replicaiton |
98496 | 2020-02-05 20:21 | 2023-09-11 7:38 | MySQL Server: JSON | Duplicate (200 days) | S3 | 5.7, 8.0 | Any | Any | JSON columns allow empty string, allowing invalid JSON in binlog row images |
98651 | 2020-02-18 23:49 | 2020-02-19 12:05 | MySQL Server: Replication | Verified (1500 days) | S2 | 8.0, 8.0.19 | Any | Any | Inserting into temporary table from function breaks replication in MIXED mode |
99524 | 2020-05-12 9:09 | 2020-05-12 11:05 | MySQL Server: DML | Verified (1417 days) | S3 | 5.6/5.7/8.0 | Any | Any | different subquery results with primary key or not |
101862 | 2020-12-04 1:31 | 2020-12-10 13:32 | MySQL Server: DML | Verified (1211 days) | S3 | 8.0 | Any | Any | insert into t1 values (),(); failed when binlog_row_image=minimal |
102031 | 2020-12-19 5:23 | 2021-06-03 18:39 | MySQL Server: Prepared statements | Closed (1030 days) | S3 | 5.6, 5.7, 8.0 | Any | Any | reprepare at the beginning of an implicit trans will cause 1837 error |
102291 | 2021-01-19 9:17 | 2021-01-19 9:58 | MySQL Server: Optimizer | Verified (1165 days) | S1 | 8.0, 8.0.22, 8.0.23 | Any | Any | Subquery produces wrong result when set big_tables = 1 |
102886 | 2021-03-09 13:21 | 2021-04-24 15:40 | MySQL Server: Japanese Documentation | Closed (1070 days) | S3 | 8.0.23 | Any | Any | 1.3 MySQL 8.0 の新機能(リソース管理~) |
105724 | 2021-11-26 19:15 | 2021-11-28 8:23 | MySQL Cluster: Cluster (NDB) storage engine | Verified (852 days) | S3 | 8.0.27 | Any | Any | LQHKEYREQ races COMMIT signal in COPY_FRAGREQ situations |
105819 | 2021-12-07 9:48 | 2021-12-07 14:38 | MySQL Server: Data Types | Verified (843 days) | S3 | 8.0 | Any | Any | Conversion from Blob/Text column value to double does not return a truncation er |
106312 | 2022-01-27 18:14 | 2022-02-09 13:20 | MySQL Server: Optimizer | Verified (791 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 |
106671 | 2022-03-08 12:12 | 2022-03-11 8:00 | MySQL Server: Replication | Verified (749 days) | S3 | 5.7.35, 5.7.37 | Any | Any | Contribution by Tencent: mark insert select with autoinc column unsafe |
107029 | 2022-04-14 22:42 | 2022-04-15 13:19 | MySQL Server: Locking | Not a Bug (714 days) | S3 | 8.0.28 | Any | Any | deadlock when using trigger logic implementation |
107157 | 2022-04-29 3:49 | 2022-04-29 5:41 | MySQL Server: InnoDB storage engine | Verified (700 days) | S3 | 8.0.22, 8.0.29 | Any | Any | Contribution by Tencent: Collation compare handling is confused in Innobase |
107385 | 2022-05-24 9:41 | 2022-05-27 11:56 | MySQL Server | Not a Bug (675 days) | S3 | 8.0.28 | Any | Any | Different result of GT expression for binary type |
107577 | 2022-06-16 8:38 | 2023-11-30 12:30 | Connector / J | Closed (120 days) | S2 | 8.0.29 | Any | Any | rewriteBatchedStatements not work when table column name contains 'value' string |
108145 | 2022-08-16 8:13 | 2022-10-21 20:45 | Connector / Python | Closed (525 days) | S2 | 8.0.30 | Any | Any | MySQLCursor.executemany() fails to correctly identify BULK data loading ops |
109141 | 2022-11-18 18:41 | 2023-04-17 8:29 | Connector / NET | Can't repeat (347 days) | S2 | Any | Any | Insert of data into a table results in System.ArgumentException | |
109339 | 2022-12-12 12:44 | 2023-04-10 22:02 | Connector / J | Verified (470 days) | S3 | 8.0.22, 8.0.31 | Any | Any | Failed to insert bignums due to overflow |
109418 | 2022-12-17 4:00 | 2023-11-24 9:51 | Connector / J | Verified (126 days) | S2 | 8.0.31 | Any | Any | batch insert threw an unexpected exception |
110275 | 2023-03-06 4:42 | 2023-03-07 13:19 | MySQL Server: DDL | Not a Bug (388 days) | S5 | 8.0.25 | Any | Any | The number of tables increases, the table creation speed slows down. |
110432 | 2023-03-20 10:19 | 2023-03-20 12:46 | Connector / J | Verified (375 days) | S3 | 8.0.32 | Any | Any | batch insert failed |
110882 | 2023-05-02 7:26 | 2023-05-03 12:51 | MySQL Server: Optimizer | Not a Bug (331 days) | S3 | 8.0 | Any | Any (x86_64) | BETWEEN query with index wrong result |
111068 | 2023-05-18 8:38 | 2023-05-18 9:46 | MySQL Server: Locking | Verified (316 days) | S2 | 8.0.25, 8.0.33 | Any | Any | Lock failure |
111530 | 2023-06-22 8:42 | 2023-06-23 4:01 | Connector / J | Not a Bug (281 days) | S3 | 8.0.29 | Any | Any | useGeneratedKeys bug When using on duplicate key update clause |
111656 | 2023-07-04 12:32 | 2023-07-05 12:22 | MySQL Server | Unsupported (269 days) | S2 | 8.0.25 | Any | Any | Lock failure |
111675 | 2023-07-06 8:36 | 2023-07-07 12:17 | MySQL Server: Data Types | Verified (267 days) | S3 | 8.0 | Any | Any | wrong result when compare timestamp with undependent subselect that return time |
112251 | 2023-09-04 13:19 | 2023-09-05 12:11 | MySQL Server: Optimizer | Can't repeat (206 days) | S3 | 8.1.0 | Any | Any | Uncertain Result |
112463 | 2023-09-26 9:01 | 2023-10-04 11:24 | MySQL Server | Not a Bug (177 days) | S3 | 8.0.34 | Any | Any | MySQL Delete, Insert Lock Occur |
113211 | 2023-11-24 12:14 | 2023-11-24 12:34 | MySQL Server: Optimizer | Verified (126 days) | S2 | 8.0.35, 8.1.0, 8.2.0 | Any | Any | The latest version 8.0 returns abnormal results for complex queries |
113313 | 2023-12-03 0:44 | 2023-12-04 12:48 | MySQL Server | Not a Bug (116 days) | S1 | 8.2.0 | Any | Any | Unexpected Result for ENGINE HEAP |
113783 | 2024-01-28 12:50 | 2024-01-30 10:58 | MySQL Server: Optimizer | Not a Bug (59 days) | S4 | 8.0 | Any | Any | only_full_group_by option does not take effect |
31 | 2003-01-15 0:03 | 2003-01-28 10:41 | MySQL Server | Closed (7731 days) | S3 | 4.1 | Any (any) | Any | Bug with nested subselect IN (... IN ()) |
104 | 2003-02-26 13:33 | 2003-03-06 14:03 | MySQL Server | Closed (7694 days) | S3 | 4.0 | Any (all) | Any | INSERT DELAYED does not care about SQL_LOG_BIN=0 |
791 | 2003-07-04 9:39 | 2011-03-15 10:21 | MySQL Server | Closed (7564 days) | S1 | 4.0 | Any (all) | Any | At binlog rotation, INSERTs may not find their way into the binlog |
2955 | 2004-02-25 4:27 | 2011-02-16 23:42 | MySQL Server: DML | Closed (5532 days) | S4 | 4.x | Any (All) | Any | LAST INSERTED ID FOR UNIQUE KEY |
6164 | 2004-10-19 20:10 | 2011-02-16 23:43 | MySQL Server: Optimizer | Verified (7100 days) | S4 | 4.0.22 4.1.7 | Any | Any | INSERT ... SELECT ... LIMIT creating too-large temporary tables |
6196 | 2004-10-21 12:44 | 2014-07-23 1:52 | MySQL Server: MyISAM storage engine | Closed (3537 days) | S4 | 5.1 | Any | Any | INSERT IGNORE should return warnings |
7727 | 2005-01-07 7:47 | 2011-02-16 23:43 | MySQL Server: MyISAM storage engine | Verified (6026 days) | S4 | Any | Any | BASE_TABLE function for use w/ MERGE tables | |
8299 | 2005-02-03 22:04 | 2006-05-27 12:04 | MySQL Server | Duplicate (6516 days) | S4 | 5.0 | Any (all) | Any | Allow FOR SELECT syntax extension |
8675 | 2005-02-22 10:59 | 2005-02-22 20:02 | MySQL Server | Duplicate (6975 days) | S3 | 4.1.10 | Any (*) | Any | INSERT INTO tbl (col,...) SELECT (...) ON DUPLICATE KEY doesn't work properly |
9018 | 2005-03-07 12:34 | 2019-12-16 4:52 | MySQL Server: DML | Verified (6020 days) | S4 | Any | Any | Implement SQL 2003 MERGE command | |
9512 | 2005-03-31 2:29 | 2005-04-04 5:30 | MySQL Server: InnoDB storage engine | Not a Bug (6934 days) | S3 | 4.1.10a | Any (All) | Any | SELECT FOR UPDATE returns phantom rows |
9576 | 2005-04-02 4:40 | 2005-04-05 13:08 | MySQL Server | Duplicate (6933 days) | S3 | 4.1.10 | Any (*) | Any | AES_DECRYPT results inconsistent |
10049 | 2005-04-20 23:02 | 2014-12-17 13:46 | MySQL Server: General | Verified (6748 days) | S4 | Any | Any | rownum functionality (alá Oracle) | |
13570 | 2005-09-28 14:16 | 2005-10-07 9:53 | MySQL Server | Won't fix (6748 days) | S4 | all | Any (all) | Any | frederate table |
13728 | 2005-10-04 0:38 | 2011-02-16 23:43 | MySQL Server | No Feedback (5265 days) | S4 | Any | Any | add XML parsing like MSSQLServer does | |
14053 | 2005-10-15 23:44 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (5259 days) | S4 | 5.0.13-rc-standard-log | Any (any) | Any | Impossible to access auto_increment values in triggers on insert |
17092 | 2006-02-03 7:34 | 2022-12-04 20:45 | MySQL Server: DDL | Verified (4851 days) | S4 | Any | Any | allowing TRUNCATE TABLE while LOCKing done. | |
18394 | 2006-03-21 14:50 | 2006-03-21 16:59 | Connector / J | Not a Bug (6583 days) | S2 | 3.1.12 | Any (All) | Any | Don't get any exception with "2005/02/30" with connector/J |
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 |
19652 | 2006-05-09 20:55 | 2006-05-10 13:32 | MySQL Server | Not a Bug (6533 days) | S2 | 3.x,4.x | Any (All) | Any | Wrong description on how to create new user accounts |
20236 | 2006-06-02 20:34 | 2006-06-02 20:40 | MySQL Server | Not a Bug (6510 days) | S3 | 4.1.20, 5.0.22 | Any (All) | Any | incorrect INSERT syntax is allowed and produces confusing results |
21113 | 2006-07-18 12:48 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5031 days) | S3 | 5.0.19 | Any (All) | Any | Duplicate printout in SHOW INNODB STATUS |
36314 | 2008-04-24 11:16 | 2008-04-24 11:47 | MySQL Server: Documentation | Not a Bug (5818 days) | S3 | all | Any | Any | GRANT is missing in SQL documentation |
36348 | 2008-04-25 15:37 | 2008-04-27 7:15 | MySQL Server: Stored Routines | Duplicate (5815 days) | S3 | 5.0 and 5.1 | Any | Any | SQLWARNING and SQLEXCEPTIONs treated differently |
36698 | 2008-05-13 19:57 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5792 days) | S3 | 5.0.60/5.1BK | Any | Any | ROW_COUNT() is reset inconsistently |
37002 | 2008-05-27 11:27 | 2008-05-31 19:15 | MySQL Server | Can't repeat (5781 days) | S2 | 5.0.51b-community-nt | Any | Any | DESCRIBE returns error 1064 |
37280 | 2008-06-09 12:36 | 2012-03-05 20:13 | MySQL Server: Archive storage engine | Closed (4407 days) | S1 | 5.0.64/5.1.46/6.0 | Any | Any | check and repair table report table corrupted when run concurrently with inserts |
37326 | 2008-06-11 3:05 | 2008-06-11 4:28 | Connector / J | Closed (5770 days) | S3 | MYSQL 4.11 | Any | Any | How to find the MYSQL error codes in Java when db exception occurs |
37356 | 2008-06-11 23:00 | 2008-06-11 23:28 | MySQL Server | Not a Bug (5770 days) | S3 | 5.1.25 | Any | Any | setting auto_increment column 0 fails! |
37390 | 2008-06-13 9:53 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Verified (5294 days) | S5 | 5.0++ | Any | Any | "mysqldump -d" can not implement "show table status" |
37480 | 2008-06-18 13:45 | 2018-09-25 21:47 | MySQL Server: Tests | Closed (5762 days) | S7 | 6.0 | Any | Any | commit_1innodb.test fails randomly |
37545 | 2008-06-20 13:02 | 2022-12-04 20:45 | MySQL Server: Logging | Verified | S4 | 5.0, 5.1, 6.0 | Any | Any | Reduce size of the blob field logged in slow query log |
37681 | 2008-06-26 23:24 | 2008-07-01 4:57 | MySQL Server: CSV | Won't fix (5750 days) | S4 | 5.1+ | Any | Any | CSV Engine needs nullable columns |
37791 | 2008-07-02 3:23 | 2008-07-06 12:14 | MySQL Server: InnoDB storage engine | Duplicate (5745 days) | S2 | 5.0.27 | Any | Any | Problem in innodb transaction |
37820 | 2008-07-02 19:22 | 2008-07-03 11:54 | MySQL Server: Charsets | Duplicate (5748 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 |
37994 | 2008-07-09 14:46 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | No Feedback (5543 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 |
37998 | 2008-07-09 17:38 | 2008-07-09 17:44 | MySQL Server: Locking | Duplicate (5742 days) | S3 | 5.1.25 | Any | Any | Lock doesn't allow to copy data from general_log to another table |
38080 | 2008-07-12 21:56 | 2008-07-12 22:37 | MySQL Server: Charsets | Not a Bug (5739 days) | S3 | 5.0.62 | Any | Any | Inserting hexadecimal in unicode data is not validated |
38106 | 2008-07-14 15:21 | 2012-05-18 20:19 | MySQL Server: Tests | Duplicate (5642 days) | S3 | 6.0-BK | Any | Any | main.crash_commit_before crashes the server sporadically |
38142 | 2008-07-15 16:03 | 2008-08-22 16:06 | MySQL Server: Embedded Library ( libmysqld ) | Duplicate (5698 days) | S3 | 5.1 | Any | Any | test case "innodb" fails in embedded mode with long path names |
38517 | 2008-08-01 8:56 | 2008-08-01 13:35 | MySQL Server: General | Closed (5719 days) | S3 | 5.0.45 | Any (Linux 64bit) | Any | min() returns values from unmatched rows when used on unique index |
38518 | 2008-08-01 10:33 | 2008-08-14 5:56 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5706 days) | S2 | 6.2.15 | Any | Any | REPLACE on NDB tables does not consider DEFAULT values |
38595 | 2008-08-06 9:43 | 2009-05-28 12:34 | MySQL Query Browser | Unsupported (5419 days) | S3 | 1.2.12 | Any (Ubuntu 8.04, Mac OSX) | Any | String highlighning errors if using backslash |
39146 | 2008-09-01 5:08 | 2008-09-11 10:10 | MySQL Server: Data Types | Not a Bug (5678 days) | S3 | 4.1.22-standard-log, 4.1, 5.0, 5.1, 6.0 bzr | Any | Any | Convertion to unsigned bigint where it must be signed int |
39179 | 2008-09-02 9:46 | 2008-09-02 14:53 | MySQL Server: Charsets | Not a Bug (5687 days) | S2 | 5.0.51a | Any | Any | Unable to save the Spanish checters with accent |
39197 | 2008-09-02 18:20 | 2008-11-27 22:30 | MySQL Server: Replication | Not a Bug (5601 days) | S1 | 5.1.26,5.1.28, 5.0.67 | Any (Mac OSX and Linux) | Any | replication breaks with large load with InnoDB, flush logs, and slave stop/start |
39221 | 2008-09-03 18:12 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5685 days) | S4 | 5.0.51a, all | Any | Any | System variables can't be set in a SELECT |
39247 | 2008-09-04 15:05 | 2015-06-02 13:36 | MySQL Server: DML | Verified (5674 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 |
39446 | 2008-09-15 8:49 | 2020-09-13 20:45 | MySQL Server: Maria storage engine | Duplicate (5631 days) | S1 | 6.0-bzr | Any | Any | Maria deadlock in pagecache_read |
39452 | 2008-09-15 11:38 | 2021-05-23 20:45 | MySQL Server: Falcon storage engine | Duplicate (5658 days) | S1 | 6.0-falcon-team | Any | Any | Test falcon_bug_22165 fails intermittently (crash) |
39705 | 2008-09-28 4:24 | 2011-05-12 10:52 | Tests | Duplicate (4705 days) | S3 | 6.0, 6.0-falcon, 5.1 | Any | Any | read_many_rows_innodb fails |
39943 | 2008-10-09 1:31 | 2008-10-09 6:59 | MySQL Server: Optimizer | Can't repeat (5650 days) | S2 | 5.1.24 | Any | Any | Wrong index chosen by innoDB |
40012 | 2008-10-14 9:13 | 2012-05-18 20:19 | MySQL Server: DDL | Duplicate (5634 days) | S4 | 5.0 | Any | Any | Add an insteadof time to trigger definition |
40052 | 2008-10-15 14:46 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5644 days) | S3 | Any | Any | SQL_NO_STRICT: per-query way to disable strict mode | |
40440 | 2008-10-30 17:34 | 2011-02-16 23:43 | Connector / J | Closed (5425 days) | S5 | 5.1.7 | Any | Any | Performance bottleneck using batched statements |
41137 | 2008-11-30 16:17 | 2014-01-16 18:01 | MySQL Server: Data Types | Closed (3725 days) | S4 | Any | Any | TIMESTAMP column with no default value | |
41157 | 2008-12-01 19:38 | 2011-02-16 23:43 | MySQL Server: General | Verified (5596 days) | S3 | 5.1 | Any | Any | Modify PreparedStatement to include timestamp column in RETURN_GENERATED_KEYS |
41622 | 2008-12-19 7:10 | 2018-09-25 21:50 | Tests: Server | Duplicate (5562 days) | S7 | 6.0 | Any | Any | func_str fails sporadically on pushbuild with timeout |
41958 | 2009-01-08 12:29 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Duplicate (5553 days) | S2 | Any | Any | mysqldump shouldn't dump triggers before data | |
42047 | 2009-01-12 11:29 | 2021-05-02 20:45 | MySQL Cluster: NDB API | Verified (5549 days) | S3 | mysql-5.1-telco-6.2 | Any | Any | NDBAPI : Too large BIT column causes node failure on insert |
42250 | 2009-01-21 18:38 | 2018-02-10 17:11 | MySQL Server: DML | Can't repeat (2239 days) | S3 | Any | Any | Just a little mistake | |
42374 | 2009-01-27 13:53 | 2009-01-27 17:18 | MySQL Server: DML | Not a Bug (5540 days) | S3 | 5.1.30 | Any | Any | using a value from DUAL in a subquery returns Unknown column |
42501 | 2009-01-31 15:40 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Duplicate (5240 days) | S2 | 5.1.30 | Any | Any | select returns empty set if autocommit=0 after add index in another thread |
42699 | 2009-02-09 15:58 | 2012-05-18 20:19 | Tests: Cluster | Verified | S3 | cluster 6.4.2 | Any | Any | Test "partition_mgm" does not match with current software |
42762 | 2009-02-11 13:54 | 2018-06-19 7:11 | MySQL Workbench | Won't fix (2110 days) | S1 | Any | Any | Migrate INTEGER to wrong data types | |
42763 | 2009-02-11 13:58 | 2013-02-06 23:07 | MySQL Workbench | Can't repeat (4069 days) | S2 | 1.1.17 | Any | Any | Indexe won't be migrated |
42877 | 2009-02-16 12:08 | 2011-02-16 23:43 | MySQL Server: Parser | No Feedback (5492 days) | S1 | 5 | Any | Any | Back slash inserting in Last in data |
43151 | 2009-02-24 15:05 | 2022-12-04 20:45 | MySQL Server: DDL | Duplicate (4029 days) | S3 | 5.0, 5.1.31 | Any | Any | default values doesn't mention implicit default for columns in pkey |
43387 | 2009-03-04 18:21 | 2011-02-16 23:43 | MySQL Server: Embedded Library ( libmysqld ) | No Feedback (5231 days) | S3 | 5.0.88 | Any | Any | main.lowercase_mixed_tmpdir fails with embedded server |
43484 | 2009-03-08 14:40 | 2009-03-23 12:28 | Connector / NET | Not a Bug (5485 days) | S2 | Any | Any | C#: I can't add hebrew strings into my DB using the MySQL.Data.MySqlClient | |
43589 | 2009-03-12 11:53 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Duplicate (5496 days) | S3 | 6.0.11-bzr | Any | Any | Innodb returns zero values for calendar types with IS NULL |
43622 | 2009-03-13 7:52 | 2014-04-12 18:49 | MySQL Server: DML | Closed (3639 days) | S1 | 4.1.22, 5.0, 5.1 | Any (Linux 64-bit, 32-bit Mac) | Any | text datatype column does not match the long value |
43694 | 2009-03-17 9:36 | 2010-05-26 18:00 | MySQL Server: Maria storage engine | Unsupported (5056 days) | S3 | 6.0-maria | Any | Any | Maria: assertion on "table->file->stats.records > 0 || error" in INSERT SELECT |
43798 | 2009-03-23 8:59 | 2011-02-16 23:43 | MySQL Server | Verified (5485 days) | S4 | 4/5 | Any | Any | Respect timezone for Interval etc |
43865 | 2009-03-25 20:04 | 2020-08-04 23:47 | MySQL Server: General | Closed (1333 days) | S2 | 5.1.30, 5.0, 5.1, 6.0 bzr | Any | Any | CAST( -1.0 as UNSIGNED) yields 0 instead of MAXINT and returns a warning. |
44032 | 2009-04-02 6:41 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5031 days) | S3 | 5.0.3+ | Any | Any | In ROW_FORMAT=REDUNDANT, update UTF-8 CHAR to/from NULL is not in-place |
44359 | 2009-04-20 6:44 | 2011-02-16 23:43 | MySQL Server: Query Cache | No Feedback (5310 days) | S2 | 5.1.33 | Any | Any | Query cache gets fragmented when the query cache gets full |
44364 | 2009-04-20 13:22 | 2009-04-20 14:19 | MySQL Server: General | Not a Bug (5457 days) | S3 | 5.0.41-community-nt | Any | Any | The error 1017 while renaming the table |
44425 | 2009-04-23 10:34 | 2011-02-16 23:43 | MySQL Server: General | Verified (5454 days) | S3 | 5.1.22-rc-log | Any | Any | mysqldump --no-data still sets AUTO_INCREMENT base values to CREATE TABLE statem |
44801 | 2009-05-11 18:41 | 2011-02-16 23:43 | Connector / NET | Closed (5429 days) | S3 | 6.0.3.0 | Any | Any | Entity Framework - Table per type inheritance problem |
Showing 1-1000 of 2772 (Edit, Save, CSV, Feed) | Show Next 1000 Entries » |