Showing 1-1000 of 2778 (Edit, Save, CSV, Feed) | Show Next 1000 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
114058 | 2024-02-20 7:28 | 2024-02-20 11:06 | MySQL Server: Optimizer | Not a Bug (65 days) | S3 | 8.0.35 | Any | Any | The return value of the CAST(... AS UNSIGNED) expression is out of range. |
114740 | 2024-04-23 8:29 | 2024-04-23 8:47 | MySQL Server: JSON | Verified (2 days) | S4 | 8.0.36 | Any | Any | mysql lost decimal's precision for json data type. |
114718 | 2024-04-21 12:09 | 2024-04-22 7:45 | MySQL Server: DML | Verified (3 days) | S1 | 8.0.36 | Any | Any | Incorrect query results |
114534 | 2024-04-03 4:22 | 2024-04-03 8:22 | MySQL Server: DML | Verified (22 days) | S3 | 8.0.36 | Any | Any | Inconsistent result with index and symbol '̏ |
114378 | 2024-03-17 12:44 | 2024-04-23 16:37 | MySQL Server: DML | Verified (38 days) | S3 | 8.0, 8.0.35 | Any | Any | Incorrect query result caused by CONVERT_TZ |
114312 | 2024-03-12 6:30 | 2024-03-19 2:26 | MySQL Server: DML | Verified (37 days) | S3 | 8.0 | Any | Any | Item_ref::used_tables wrong when ref to a rollup constant |
114290 | 2024-03-09 23:51 | 2024-03-10 8:24 | MySQL Server: General | Not a Bug (46 days) | S2 | 8.0.36 | Any | Any | ENUM and operator IN bug |
114217 | 2024-03-05 4:48 | 2024-03-05 7:01 | MySQL Server: DML | Verified (51 days) | S2 | 8.2.0, 8.3.0, 8.0.36 | Any | Any | Unexpected Results by Minus Sign |
114204 | 2024-03-04 8:43 | 2024-03-04 8:58 | MySQL Server: DML | Verified (52 days) | S2 | 8.2.0, 8.3.0 | Any | Any | Unexpected Results by COALESCE |
113369 | 2023-12-08 3:51 | 2024-01-05 13:06 | MySQL Server: Partitions | Verified (139 days) | S3 | 8.0.34, 8.0.35 | Any | Any | In the hash partition table, the query result is error. |
113962 | 2024-02-12 14:05 | 2024-02-12 15:11 | MySQL Server: DML | Verified (73 days) | S3 | 8.0 | Any | Any | Contribution: Fix offset check for insert position overflow |
113614 | 2024-01-11 8:20 | 2024-01-11 9:24 | MySQL Server: Partitions | Won't fix (105 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. |
113595 | 2024-01-09 14:38 | 2024-01-09 15:15 | MySQL Server | Duplicate (107 days) | S3 | 8.0.35 | Any | Any | Incorrect query result of function TIMESTAMPADD |
113557 | 2024-01-04 15:29 | 2024-01-04 15:40 | MySQL Server: JSON | Verified (112 days) | S2 | 8.0.35 | Any | Any | Wrong query result on composite multi-valued index + empty array value |
113535 | 2024-01-02 9:58 | 2024-01-08 13:31 | MySQL Server: DDL | Can't repeat (108 days) | S3 | 8.0.35 | Any | Any | Drop table in background list will remain file exists in directory |
113447 | 2023-12-18 7:54 | 2023-12-18 13:52 | MySQL Server: DML | Not a Bug (129 days) | S3 | MySQL 8.0 | Any | Any | INET6_ATON giving Incorrect integer value for MySQL 8.0 |
113384 | 2023-12-09 8:05 | 2023-12-11 11:42 | MySQL Server: Data Types | Verified (136 days) | S3 | 8.0 | Any | Any | Queried with partitions,returned result is error |
113378 | 2023-12-08 12:31 | 2024-03-29 17:12 | Connector / J | Not a Bug (27 days) | S2 | connector-j>=8.0.29 | Any | Any | Java enums in prepared statement for a VARCHAR throws exception |
113355 | 2023-12-06 17:45 | 2024-04-18 15:27 | MySQL Server: DDL | Verified (7 days) | S3 | 8.0 | Any | Any | DROP/RENAME index, increase VARCHAR should really be ALGORITHM=INSTANT |
4 | 2002-10-29 19:45 | 2002-12-02 12:01 | MySQL Server | Closed (7815 days) | S3 | 4.0.5 | Any (all) | Any | BETWEEN not working properly with timestamp / datetime |
491 | 2003-05-24 7:40 | 2003-07-01 5:38 | MySQL Server: Replication | Closed (7604 days) | S3 | 4.0.13 | Any (all) | Any | If INSERT SELECT fails in a MyISAM table but has changed row, nothing in binlog |
3309 | 2004-03-26 17:59 | 2005-03-07 19:10 | MySQL Server | Closed (6989 days) | S2 | 3.23, 4.0 and up | Any (any) | Any | Netmask matching for 'Host' doesn't work. |
4124 | 2004-06-14 7:16 | 2004-06-21 10:28 | MySQL Server: Replication | Closed (7248 days) | S4 | All | Any (All) | Any | Replication Optimization |
6946 | 2004-12-02 14:31 | 2006-02-14 14:28 | MySQL Server | Won't fix (6645 days) | S4 | * | Any (*) | Any | INSERT ... ON DUPLICATE KEY UPDATE without INSERT |
7806 | 2005-01-11 15:45 | 2005-04-27 1:43 | MySQL Server | Closed (6938 days) | S3 | 4.1.11 | Any (*) | Any | insert on duplicate key and auto-update of timestamp |
9676 | 2005-04-06 11:57 | 2006-07-06 19:02 | MySQL Server: Optimizer | Closed (6503 days) | S3 | 4.1 | Any (any) | Any | INSERT INTO x SELECT .. FROM x LIMIT 1; slows down with big tables |
14400 | 2005-10-27 16:15 | 2006-09-22 15:27 | MySQL Server: MyISAM storage engine | Closed (6425 days) | S2 | 3.23, 4.0, 4.1, 5.0 | Any (any) | Any | Query joins wrong rows from table which is subject of "concurrent insert" |
15193 | 2005-11-23 16:49 | 2005-12-12 21:25 | MySQL Server | Won't fix (6709 days) | S3 | Any | Any | 'select' priv required when deleting from table with where clause | |
15520 | 2005-12-06 14:26 | 2006-05-03 17:56 | MySQL Server: Documentation | Closed (6567 days) | S3 | all | Any (all) | Any | "Optimize table" wants INSERT privs? |
17144 | 2006-02-05 21:31 | 2008-10-04 18:34 | MySQL Server: Security: Privileges | Unsupported (5682 days) | S4 | 4.0 and above | Any (*) | Any | Missing default values in user table complicate insert into user table |
20195 | 2006-06-01 11:55 | 2006-06-22 14:31 | MySQL Server | Closed (6517 days) | S2 | 5.0.22 | Any (All) | Any | INSERT DELAYED with auto_increment is assigned wrong values |
20291 | 2006-06-06 12:37 | 2013-11-12 8:36 | MySQL Server: Errors | Closed (3817 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 (6349 days) | S1 | 5.2 | Any | Any | strange errors around INSERT getting duplicate key, but one row is inserted |
26238 | 2007-02-09 21:21 | 2007-03-15 3:20 | MySQL Server: General | Closed (6251 days) | S1 | 5.0.36 | Any (*) | Any | inserted delayed always inserts 0 for BIT columns |
26418 | 2007-02-15 18:00 | 2007-07-18 16:46 | MySQL Server: Replication | Closed (6126 days) | S2 | 5.1 | Any | Any | Slave out of sync after CREATE/DROP TEMPORARY TABLE + ROLLBACK on master |
26803 | 2007-03-02 19:15 | 2007-04-13 9:04 | MySQL Server: Falcon storage engine | Closed (6222 days) | S3 | 5.1 | Any | Any | unique constraints on VARCHAR columns behave different in MyISAM and Falcon |
27607 | 2007-04-03 7:18 | 2007-04-03 7:33 | MySQL Server: Documentation | Not a Bug (6232 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 | |
28478 | 2007-05-16 17:05 | 2007-06-20 0:51 | MySQL Server: MyISAM storage engine | Closed (6154 days) | S2 | 5.0.42, * | Any | Any | Improper key_cache_block_size corrupts MyISAM tables |
29013 | 2007-06-11 7:03 | 2007-06-11 10:29 | MySQL Server | Can't repeat (6163 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 (6154 days) | S1 | 5.041 | Any | Any | INSERT DELAYED is suspended when table is full, no error reporting. |
29297 | 2007-06-22 9:06 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6148 days) | S3 | 5.0.37, 5.0 BK, 5.1 BK | Any | Any | Wrong result with aggregation and a subquery |
29335 | 2007-06-25 12:29 | 2007-06-27 10:14 | MySQL Server: MyISAM storage engine | Not a Bug (6147 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 (6112 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 (6002 days) | S3 | 6.0.4-alpha-debug | Any | Any | falcon crash recovery not perfect yet |
31881 | 2007-10-26 14:49 | 2011-02-16 23:43 | MySQL Server: Errors | Closed (5164 days) | S3 | 5.0/5.1 | Any | Any | A statement is not aborted immediately if an error inside a stored routine |
32566 | 2007-11-21 11:32 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (5992 days) | S3 | 5.1 | Any | Any | Range partitioning: Insert of maximum value should fail LESS THAN (numeric max) |
36851 | 2008-05-21 12:17 | 2008-05-30 14:12 | MySQL Cluster: NDB API | Closed (5809 days) | S3 | All | Any | Any | NDBAPI : IgnoreError with Insert operation and Blobs |
36984 | 2008-05-26 16:31 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5803 days) | S3 | 5.0.56sp1 | Any | Any | INSERT DELAYED is converted to standard INSERT in Stored Procedure. |
38370 | 2008-07-25 10:27 | 2008-10-17 18:20 | Tests: Cluster | Closed (5669 days) | S3 | 5.1 BK | Any | Any | The test ndb.ndb_index_ordered fails with the community features on |
38515 | 2008-08-01 7:05 | 2008-08-01 7:06 | MySQL Workbench | Duplicate (5746 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 (5676 days) | S3 | 5.0.x, 5.1.x | Any | Any | INSERT ON DUPLICATE returns 1 instead of 0 when nothing is changed |
39420 | 2008-09-12 11:58 | 2008-11-06 18:05 | MySQL Server: Maria storage engine | Can't repeat (5649 days) | S3 | 6.0.7 | Any | Any | maria deadlock when doing a large insert |
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. |
39538 | 2008-09-19 14:48 | 2008-10-08 7:33 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5678 days) | S2 | 5.1-telco-6.3 | Any | Any | Constraint violation in multi-row insert does not abort transaction |
40119 | 2008-10-17 18:29 | 2008-10-17 18:36 | MySQL Server: Replication | Not a Bug (5669 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 (5642 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 (5370 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 (5624 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" |
41820 | 2009-01-01 20:57 | 2014-02-21 18:04 | MySQL Server: Falcon storage engine | Unsupported (3716 days) | S3 | 6.0-falcon-team | Any | Any | Falcon crash in MemFreeBlock::insert |
42102 | 2009-01-14 9:34 | 2012-05-18 20:19 | MySQL Server: DML | Duplicate (5580 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 (5565 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 (5242 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 (5528 days) | S1 | 6.0-falcon-team | Any | Any | Falcon ASSERT(ret) in Table::insert |
44520 | 2009-04-28 14:29 | 2023-02-12 20:45 | MySQL Server: Row Based Replication ( RBR ) | Verified (5475 days) | S4 | 5.1.33, 5.1, 6.0 bzr | Any | Any | INSERT ignored silently if CREATE and INSERT are bundled in one BINLOG stmt |
44976 | 2009-05-20 9:09 | 2011-02-16 23:43 | MySQL Server: Replication | Duplicate (4983 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 (5442 days) | S4 | 5.0.60 | Any | Any | Cannot change LAST_INSERT_ID value within before update trigger |
45784 | 2009-06-26 10:19 | 2016-10-16 20:45 | MySQL Server: Replication | Duplicate (5400 days) | S2 | 5.1+ | Any | Any | INSERT DELAYED in SP does not cause RBL if binlog_format=MIXED |
46650 | 2009-08-11 12:51 | 2011-02-16 23:44 | MySQL Server: InnoDB Plugin storage engine | Closed (5058 days) | S1 | 5.1,5.4 | Any | Any | Innodb assertion autoinc_lock == lock in lock_table_remove_low on INSERT SELECT |
47253 | 2009-09-10 14:30 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (5337 days) | S3 | Any | Any | Assert in ha_partition::end_bulk_insert | |
47742 | 2009-09-30 12:52 | 2012-02-16 4:28 | MySQL Cluster: Cluster (NDB) storage engine | Closed (4452 days) | S3 | mysql-5.1 | Any | Any | Extra-columns on the slave do not work with ndb as expected |
48113 | 2009-10-16 13:21 | 2011-02-16 23:44 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5301 days) | S3 | mysql-5.1-telco-6.2+ | Any | Any | Ndb : Insert hitting DD space exhaustion does not lock following tuple ops |
48724 | 2009-11-12 12:33 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5163 days) | S2 | 6.0.14-bzr, 6.0-codebase-bugfixing | Any | Any | Deadlock between INSERT DELAYED and FLUSH TABLES |
48814 | 2009-11-16 19:14 | 2011-02-16 23:44 | MySQL Server: DDL | Closed (4977 days) | S2 | 5.0+, 5.5.0 | Any | Any | CREATE TABLE IF NOT EXISTS <non-insertable view> SELECT does not fail |
49456 | 2009-12-04 12:04 | 2018-04-08 20:45 | MySQL Server | Analyzing (5256 days) | S3 | mysql-5.1-rep+3 | Any | Any | replication out of sync |
49533 | 2009-12-08 13:08 | 2017-05-21 20:45 | MySQL Server: Replication | Verified (5252 days) | S3 | 5.1,mysql-5.1-rep+3,mysql-6.0-codebase-b | Any | Any | Overflow in DECIMAL, SBR out of sync |
49562 | 2009-12-09 14:30 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5013 days) | S3 | 5.1,mysql-5.1-rep+3,mysql-6.0-codebase-b | Any | Any | SBR out of sync when using numeric data types + user variable |
49567 | 2009-12-09 16:37 | 2015-01-12 15:27 | MySQL Server: Replication | Won't fix (3391 days) | S2 | 5.1+ | Any | Any | INSERT DELAYED uses global binlog_format, should use session |
49971 | 2009-12-29 9:38 | 2010-01-07 9:09 | MySQL Server: DML | Not a Bug (5222 days) | S4 | Any | Any | Allow INSERT .... WHERE .... | |
50065 | 2010-01-04 22:59 | 2012-07-29 23:08 | MySQL Server: Query Cache | Closed (4288 days) | S4 | 5.0.89, 5.1.37, 5.5-mr2 | Any | Any | query cache invalidated in insert...select if no rows inserted |
50385 | 2010-01-15 22:39 | 2014-03-11 21:18 | MySQL Server: Locking | Closed (3698 days) | S3 | 5.1 | Any | Any | test suite fails without query cache |
53075 | 2010-04-22 18:12 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5101 days) | S3 | 5.6.99-m4 | Any | Any | SBR: Strange warning around CONNECTION_ID() |
53298 | 2010-04-29 21:15 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (4902 days) | S3 | 6.0-codebase-bugfixing | Any | Any | wrong result with semijoin (no semijoin strategy chosen) |
57250 | 2010-10-05 14:07 | 2017-05-21 20:45 | MySQL Server: Replication | Verified (4951 days) | S2 | 5.1+ | Any | Any | mark INSERT...SELECT with autoinc column unsafe when innodb_autoinc_lock_mode=2 |
57335 | 2010-10-08 6:35 | 2011-02-16 23:44 | MySQL Enterprise Backup | Closed (4836 days) | S3 | 3.5.2 | Any | Any | abnormal termination of the backup process could leave the global lock active |
57698 | 2010-10-24 21:25 | 2012-09-13 9:30 | Connector / J | Closed (4906 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 (3898 days) | S3 | mysql-5.1-telco-7.1 | Any | Any | wrong interface member function type gives funny exception |
57918 | 2010-11-02 8:54 | 2011-02-16 23:44 | Tests: Replication | Closed (4858 days) | S3 | 5.6 (Dahlia, Erica) | Any | Any | rpl_get_master_version_and_clock times out sporadically |
58083 | 2010-11-09 13:27 | 2011-02-16 23:44 | Tests: Replication | Duplicate (4915 days) | S3 | 5.6 | Any | Any | Test rpl.rpl_server_uuid fails after 5 minutes in trunk-bugfixing |
58086 | 2010-11-09 15:09 | 2011-11-30 18:40 | MySQL Server: Documentation | Closed (4530 days) | S3 | 5.1 | Any | Any | auto_inc in InnoDB have INSERT ... ON DUPLICATE KEY UPDATE != UPDATE |
58678 | 2010-12-02 22:36 | 2023-02-12 20:45 | MySQL Server: Replication | Verified | S3 | 5.5.6, 5.5.8 | Any | Any | Wrong statement quoted in unsafety warning upon event execution |
58686 | 2010-12-03 0:16 | 2010-12-15 23:39 | MySQL Server | Not a Bug (4880 days) | S3 | 5.1.43sp1-enterprise-gpl | Any | Any | CREATE TABLE .. CHARSET=<...> without a COLLATE using case-insensitive collation |
59214 | 2010-12-29 15:45 | 2011-05-05 23:48 | MySQL Server: InnoDB Plugin storage engine | Closed (4739 days) | S5 | 5.1,5.5 | Any | Any | increase rate limit for insert buffer prefetch reads |
59735 | 2011-01-26 9:19 | 2011-04-02 1:35 | MySQL Server: Charsets | Closed (4772 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 (4480 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 (2785 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 (1296 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 (3497 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 (4048 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 (3529 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 (3753 days) | S3 | 1.0.10 | Any | Any | executemany() INSERT INTO fails w/o VALUES (e.g. INSERT .. SELECT) |
71769 | 2014-02-19 14:03 | 2014-11-21 22:55 | MySQL Server: Documentation | Closed (3443 days) | S3 | 5.7.2 | Any | Any | GET STACKED DIAGNOSTICS not behaving as described |
72098 | 2014-03-21 20:47 | 2019-11-18 22:37 | MySQL Server: DML | Closed (1620 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 (3613 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 (3587 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 (3535 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 (3542 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 (3489 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 (3471 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 (3471 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 (3352 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 (3425 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 (3327 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 (3099 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 (1588 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 (3111 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 (3122 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 (3080 days) | S4 | Any | Any | mysqldump diff-friendly extended-insert | |
79658 | 2015-12-16 8:49 | 2015-12-24 7:18 | MySQL Server: Performance Schema | Not a Bug (3045 days) | S3 | 5.7.10 | Any | Any | performance_schema statements by thread limited instrumentation |
79690 | 2015-12-17 12:54 | 2015-12-17 19:33 | MySQL Server: DML | Not a Bug (3052 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 (2199 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 (2990 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 (2086 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 (2885 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 (2747 days) | S3 | 5.7.15, 5.7.16 | Any | Any | INSERT INTO ... SELECT FROM ... fails if source has > 65535 rows on FTS |
84792 | 2017-02-02 12:49 | 2017-05-03 13:18 | MySQL Server: Group Replication | Can't repeat (2549 days) | S3 | 5.7.17 | Any | Any | Idle GR Cluster: Member CPU hog |
87353 | 2017-08-09 8:30 | 2017-08-09 9:39 | MySQL Cluster: Cluster (NDB) storage engine | Verified (2451 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 (2430 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 (2292 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 (1297 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 (2214 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 (2183 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 (2143 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 (511 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 (1532 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 (916 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 (1417 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 (1364 days) | S3 | 8.0.19, 5.7.31, 8.0.21 | Any | Any | The results of aggregation operations are inconsistent in different partitions |
100764 | 2020-09-08 8:50 | 2020-10-16 1:00 | MySQL Server: Optimizer | No Feedback (1288 days) | S1 | 8.0 | Any | Any | Rename Table causes other SQL execution plans to change. |
101907 | 2020-12-08 11:39 | 2021-02-12 1:00 | MySQL Server: Replication | No Feedback (1169 days) | S2 | 5.7 | Any | Any | Replication sql_thread hung while executing DML in init state |
102481 | 2021-02-04 15:37 | 2021-02-05 14:40 | MySQL Server: Optimizer | Verified (1175 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 (875 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 (1141 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 (1016 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 (973 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 (979 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 (897 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 (863 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 (583 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 (447 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 (440 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 (420 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 (373 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 (366 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 (185 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 (147 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 (127 days) | S2 | 8.0.27 | Any | Any | >= 8.0.27 Error 1048 when updating row with empty_sql mode |
114524 | 2024-04-01 12:36 | 2024-04-02 9:17 | Connector / J | Verified (23 days) | S3 | 8.3.0 | Any | Any | INSERT with JSON column error |
169 | 2003-03-19 14:22 | 2003-03-24 13:38 | MySQL Server | Closed (7703 days) | S2 | 3.23.56 and below (not in 4.0) | Any (all) | Any | DELETE FROM t; does not lock 't' enough, causes bad order in binlog |
291 | 2003-04-15 9:37 | 2019-05-14 14:18 | MySQL Server | Closed (7650 days) | S2 | 4.0, 4.1 | Any (All) | Any | bug in NATURAL LEFT JOIN, MySQL 4.0 and 4.1. |
615 | 2003-06-06 13:51 | 2003-07-01 3:18 | MySQL Server | Closed (7604 days) | S2 | 4.0.13, 4.1.0 | Any (Any) | Any | Multiple inserting NULL into a column that has been declared NOT NULL |
675 | 2003-06-18 13:47 | 2003-06-19 13:32 | Connector / J | Closed (7616 days) | S2 | 3.0+ | Any (Any) | Any | A call to ResultSet.getXXX while on insert row fails |
2614 | 2004-02-02 10:02 | 2020-04-29 12:28 | MySQL Server | Closed (7384 days) | S2 | 5.0 | Any (any) | Any | Sotred procedure with INSERT .. SELECT crash 5t.0 |
3081 | 2004-03-06 6:48 | 2004-03-08 5:51 | MySQL Server: Replication | Closed (7353 days) | S3 | 4.0 | Any (all) | Any | if an INSERT DELAYED is killed, it is binlogged as killed but it's not needed |
3985 | 2004-06-03 16:26 | 2005-12-13 16:23 | MySQL Server | Duplicate (6708 days) | S4 | 4.0 | Any (any) | Any | privilege for INSERT, UPDATE, DELETE, DROP, CREATE TEMPORARY TABLES |
4380 | 2004-07-02 14:26 | 2004-08-01 17:00 | MySQL Server: Replication | Not a Bug (7207 days) | S2 | 4.0 | Any (all) | Any | One-row INSERT/UPDATE/DELETE needn't be binlogged as 'killed' |
5369 | 2004-09-02 15:48 | 2004-09-10 17:17 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7167 days) | S3 | 4.13, 4.1.4 | Any (any) | Any | wrong initial value of auto increment in mysql cluster |
5510 | 2004-09-10 4:10 | 2004-09-17 21:24 | MySQL Server | Closed (7160 days) | S2 | 4.1.4 | Any (All) | Any | inserting Null in AutoIncrement primary key Column Fails |
7963 | 2005-01-17 17:12 | 2005-03-07 22:20 | MySQL Server: MyISAM storage engine | Can't repeat (6989 days) | S2 | 4.1.8 | Any (*) | Any | Zero records not possible |
8144 | 2005-01-26 13:49 | 2005-01-28 11:39 | MySQL Server: InnoDB storage engine | Closed (7027 days) | S2 | 5.0.3-bk | Any (all) | Any | Locking problem in TRUNCATE TABLE |
8732 | 2005-02-23 14:49 | 2012-05-18 20:19 | MySQL Server | Duplicate (6838 days) | S3 | 4.1.10 | Any (*) | Any | INSERT ... SELECT ...ON DUPLICATE KEY UPDATE problem |
9229 | 2005-03-16 19:07 | 2019-10-07 12:17 | MySQL Server | Closed (6979 days) | S1 | 5.0.3-pre | Any (Any) | Any | Test 'sp' requires InnoDB and thus fails in 'classic' |
10381 | 2005-05-05 11:50 | 2005-05-19 5:03 | MySQL Server: Documentation | Closed (6916 days) | S3 | 5.0.4-beta-standard | Any (*) | Any | 'INSERT DELAYED' option supports for Memory engine. |
11478 | 2005-06-21 11:02 | 2022-09-04 20:45 | MySQL Server | Duplicate (6880 days) | S3 | 4.0 | Any (any) | Any | option new doesn't work as expected in 4.0 |
11745 | 2005-07-05 20:16 | 2005-08-03 20:56 | MySQL Server: Optimizer | Closed (6840 days) | S2 | 4.1.12a | Any (All) | Any | insert where not exists failing |
12092 | 2005-07-21 20:40 | 2007-11-29 11:23 | MySQL Server: Replication | Closed (5992 days) | S3 | 4.0, 4.1, 5.0 | Any (all) | Any | FOUND_ROWS() not replicated |
15189 | 2005-11-23 15:59 | 2011-02-16 23:43 | MySQL Server: DML | Verified (6728 days) | S4 | 5.0.17-BK | Any | Any | Optimise INSERT ... ON DUPLICATE KEY ... for identical column values |
17974 | 2006-03-06 16:16 | 2006-03-21 10:08 | MySQL Server | Won't fix (6610 days) | S3 | 4.1.18 | Any (Any) | Any | INSERT ... SELECT with GROUP BY causes truncation of DECIMAL |
18484 | 2006-03-24 14:07 | 2011-02-16 23:43 | MySQL Server | Closed (5360 days) | S2 | 5.1, 5.4 | Any | Any | Bogus "Server shutdown in progress" error on INSERT DELAYED + ALTER |
18489 | 2006-03-24 15:33 | 2006-07-29 17:38 | MySQL Server | Won't fix (6480 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 (5581 days) | S4 | Any | Any (Any) | Any | Auto Insert Delimiters on Script Tabs |
19354 | 2006-04-25 21:05 | 2006-05-12 17:38 | MySQL Server | Duplicate (6558 days) | S4 | 5.1 | Any (all) | Any | CREATE INDEX lacks of IF NOT EXISTS |
19565 | 2006-05-05 17:07 | 2022-08-21 20:45 | MySQL Server: Stored Routines | Duplicate (6113 days) | S1 | 5.0, 5.1 | Any | Any | crash in system test, trigger, InnoDB transaction deadlock |
19887 | 2006-05-17 15:17 | 2011-02-16 23:43 | MySQL Server: Locking | Verified (6549 days) | S4 | 4.1 / 5.0 | Any (*) | Any | concurrent updates restricted by queries not using the binlog |
23368 | 2006-10-17 12:37 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5060 days) | S1 | 5.1 | Any | Any | crash during insert, table has foreign key pointing into other schema,permission |
23464 | 2006-10-19 14:02 | 2020-05-03 20:45 | MySQL Server: Views | Duplicate (6285 days) | S3 | 5.0.27-BK, 5.0.26 and 5.1.12 | Any (all) | Any | A view with an ORDER BY clause becomes non-updatable |
24024 | 2006-11-06 19:14 | 2021-05-23 20:45 | MySQL Server: Errors | Duplicate (6020 days) | S3 | Any | Any | wrong error message when drop table (used by pending transaction) fails | |
26733 | 2007-02-28 20:15 | 2007-03-01 9:46 | MySQL Server: Command-line Clients | Not a Bug (6265 days) | S2 | 5.0.38 | Any (any) | Any | '\r' in the text data in INSERT statement causes client to reconnect |
27044 | 2007-03-12 11:47 | 2007-06-02 14:35 | MySQL Cluster: Replication | Closed (6172 days) | S3 | 5.1.17 | Any | Any | replicated with unique field ndb table allows duplicate key inserts |
27177 | 2007-03-15 15:14 | 2007-07-03 15:05 | MySQL Server: Documentation | Closed (6141 days) | S3 | All Versions | Any | Any | SHOW PROCESSLIST Syntax - add descriptions for state |
27713 | 2007-04-09 11:17 | 2020-05-03 20:45 | MySQL Server: Views | Verified (6225 days) | S3 | 5.0.38, 5.1, 5.2 | Any | Any | INSERTs fail for empty table using WITH_CHECK_OPTION |
27981 | 2007-04-20 13:43 | 2007-04-20 13:49 | MySQL Server: Documentation | Closed (6215 days) | S4 | 5.0 | Any | Any | Typo in the INSERT() function documentation |
28806 | 2007-05-31 13:26 | 2007-06-16 13:00 | MySQL Server | Closed (6158 days) | S1 | 5.1.18 | Any | Any | Running SHOW TABLE STATUS during high INSERT load crashes server |
28837 | 2007-06-01 13:57 | 2008-01-15 16:26 | MySQL Server: MyISAM storage engine | Closed (5945 days) | S3 | 4.1BK/5.0BK/5.1BK | Any | Any | MyISAM storage engine error (134) doing delete with self-join |
29095 | 2007-06-14 3:21 | 2010-05-09 3:28 | MySQL Server: General | Closed (6140 days) | S2 | 5.0.44-BK, 5.0.27 community, 5.0.41 Linux | Any (Windows/Linux same...) | Any | Insert into a select from a join b using(c) order by b.auto_id desc limit 1 fail |
29146 | 2007-06-15 19:08 | 2016-02-25 12:24 | MySQL Server: Command-line Clients | Not a Bug (5895 days) | S3 | 5.0.41 | Any | Any | Output truncated when resultset contains \r |
29652 | 2007-07-09 17:39 | 2007-07-11 5:17 | MySQL Server: CSV | Closed (6133 days) | S2 | 5.1-maint | Any | Any | csv.test failure: two changes conflict after merge |
29692 | 2007-07-10 15:37 | 2009-12-07 9:07 | MySQL Server | Closed (6064 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 (6127 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 (6121 days) | S1 | 5.0.6, 5.0.7 | Any | Any | PreparedStatement.executeUpdate returns wrong rowcount for an insert statement. |
30020 | 2007-07-24 23:02 | 2007-08-03 15:52 | MySQL Server: Information schema | Closed (6110 days) | S3 | 5.0.46 | Any | Any | Wrong IS_UPDATABLE value in I_S.VIEWS for a non updatable view (regression) |
30833 | 2007-09-05 14:41 | 2007-09-05 15:07 | MySQL Server: Backup | Can't repeat (6077 days) | S3 | Ver 10.10 Distrib 5.0.27 | Any | Any | mysqldump does not create views when "information_schema" passed to --databases |
30843 | 2007-09-05 21:10 | 2007-10-24 2:58 | MySQL Server: Archive storage engine | Closed (6028 days) | S3 | 5.0 test cases (maybe before) | Any | Any | Bad Test addition to t/archive.test |
31320 | 2007-10-01 16:00 | 2007-10-12 15:50 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6040 days) | S3 | MySQL Cluster CGE 6.3 | Any | Any | transaction with statement error not aborting transaction |
31321 | 2007-10-01 17:00 | 2007-12-06 17:31 | MySQL Server: Documentation | Closed (5985 days) | S3 | 5.1, 6.0 | Any | Any | Partial transaction results with INSERT ... SELECT and cluster replication |
31906 | 2007-10-29 10:22 | 2007-10-29 11:10 | MySQL Server: DML | Not a Bug (6023 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 (5350 days) | S4 | mysql-connector-java-3.1.8-bin.jar | Any | Any | LOAD DATA LOCAL INFILE - Duplicate entry error should come |
32244 | 2007-11-09 19:10 | 2008-02-28 17:24 | Tests: Server | Closed (5901 days) | S3 | 6.0.4-alpha | Any | Any | Result files not updated with ".inc" file used - tests fail (2) |
33515 | 2007-12-26 13:29 | 2008-06-13 16:09 | MySQL Server: Stored Routines | Closed (5795 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 (5943 days) | S3 | 6.0.4 | Any | Any | Falcon crash on thread creation |
33790 | 2008-01-10 11:12 | 2008-02-15 13:03 | MySQL Server: Tests | Can't repeat (5914 days) | S3 | 5.1 | Any | Any | Fix innodb_mysql test |
35634 | 2008-03-28 8:54 | 2008-10-01 15:08 | MySQL Server: Command-line Clients | Won't fix (5685 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 (5820 days) | S2 | 5.1-maria | Any | Any | Maria: INSERT SELECT sends ok to client before committing |
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 |
37873 | 2008-07-04 14:00 | 2008-07-11 8:58 | MySQL Server: Maria storage engine | Closed (5767 days) | S3 | 5.1-maria | Any | Any | Client gets ok from INSERT VALUES before commit record is on disk |
38088 | 2008-07-13 16:03 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | No Feedback (5523 days) | S3 | 6.0 | Any | Any | rpl_row_basic_7ndb failed At line 55 INSERT INTO t2 ... |
38105 | 2008-07-14 14:58 | 2008-07-17 16:54 | MySQL Server: Documentation | Closed (5761 days) | S4 | all | Any | Any | Clarify VALUE as a synonym for VALUES in INSERT |
38725 | 2008-08-11 16:48 | 2011-02-16 23:43 | MySQL Enterprise Monitor: Documentation | Closed (5642 days) | S3 | 2.0.0.7017 | Any | Any | possible addition to the MEM2 docs |
38839 | 2008-08-18 3:08 | 2012-05-09 23:37 | MySQL Server: InnoDB storage engine | Not a Bug (5095 days) | S4 | 5.1.25-rc, 5.1.26-rc | Any | Any | auto increment does not work properly with InnoDB after update |
69075 | 2013-04-26 3:07 | 2014-02-19 10:39 | MySQL Server: Memory storage engine | Duplicate (3718 days) | S3 | 5.6.11, 5.6.15 | Any | Any | Memory leak slave_parallel_workers |
69258 | 2013-05-16 14:57 | 2013-09-05 18:21 | MySQL Server: InnoDB storage engine | Not a Bug (3885 days) | S5 | 5.6.11 | Any | Any | does buf_LRU_buf_pool_running_out need to lock buffer pool mutexes |
69318 | 2013-05-25 16:27 | 2013-07-03 14:09 | MySQL Server: Documentation | Closed (3949 days) | S3 | 5.6 | Any | Any | performance_schema_max_thread_instances documentation tweak |
69515 | 2013-06-19 14:55 | 2013-06-19 15:11 | MySQL Server: Options | Verified (3963 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 (3565 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 |
69675 | 2013-07-04 22:56 | 2013-07-11 17:13 | Connector / Python | Closed (3941 days) | S3 | 1.0.11 | Any | Any | executemany fails when combined with built in functions such as now() |
69737 | 2013-07-13 11:33 | 2013-07-15 5:39 | MySQL Server: Information schema | Can't repeat (3937 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 (3121 days) | S3 | 5.6.12 | Any | Any | Fix for bug 14606334 in 5.6.11 breaks backward compatibility for InnoDB recovery |
69927 | 2013-08-05 18:05 | 2019-04-27 22:52 | MySQL Server: Documentation | Verified | S3 | 5.6.13 | Any | Any | Document all protocol commands |
69928 | 2013-08-05 18:10 | 2016-02-25 12:24 | MySQL Server: Performance Schema | Closed (3849 days) | S3 | Any | Any | "statement/com" event meaning is unclear | |
69944 | 2013-08-07 6:16 | 2014-03-06 13:20 | MySQL Server: Replication | Verified (3703 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 (3888 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 (3863 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 (3789 days) | S1 | 5.6.16 | Any | Any | Illegal mix of collations (gbk_chinese_ci,COERCIBLE) |
70629 | 2013-10-16 8:27 | 2017-05-14 20:45 | MySQL Server: InnoDB storage engine | Verified (3800 days) | S2 | 5.6.14 | Any | Any | InnoDB updated rec_per_key[] statis not published to the optimizer enough often |
70684 | 2013-10-22 8:13 | 2013-10-22 11:35 | MySQL Server: Optimizer | Verified (3838 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 (3291 days) | S3 | 5.6.14 | Any | Any | mysqlbinlog prints invalid SQL from relay logs when GTID is enabled |
70758 | 2013-10-28 23:29 | 2013-11-07 20:32 | Connector / NET | Not a Bug (3822 days) | S3 | 6.7.4 | Any | Any | MySql Connector Targetting wrong namespace for EF6 |
70784 | 2013-10-31 12:33 | 2014-02-21 9:36 | MySQL Server: Documentation | Closed (3732 days) | S3 | 5.6.14 | Any | Any | Adjust documentation and possibly defaults for sync_{master,relay_log}_info |
70894 | 2013-11-13 9:02 | 2013-11-13 11:41 | MySQL Server | Not a Bug (3816 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 (3752 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 (3789 days) | S4 | Any | Any | Implement Statement::getGeneratedKeys() | |
71095 | 2013-12-05 16:00 | 2014-08-01 15:52 | MySQL Server: Partitions | Closed (3632 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 (3780 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 (3773 days) | S3 | 5.6.15 | Any | Any | an autocommit SELECT was not treated as autocommit non-lock trx |
71242 | 2013-12-28 18:45 | 2017-12-23 10:54 | Connector / NET | Closed (3703 days) | S3 | 6.8.3 | Any | Any | Entity Framework Inserts broken on tables with unsigned bigint as auto increment |
71332 | 2014-01-09 15:55 | 2015-04-06 17:49 | MySQL Server: Documentation | Closed (3307 days) | S3 | any | Any | Any | Manual does NOT explain how row constructors work in non-equal comparisons |
71469 | 2014-01-24 10:49 | 2014-02-11 16:02 | MySQL Server: Documentation | Closed (3726 days) | S3 | 5.6 | Any | Any | INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS.MODIFIED_COUNTER resets not documented |
71528 | 2014-01-30 15:20 | 2022-09-04 20:45 | Connector / J | Duplicate (3737 days) | S2 | 5.1.28 | Any | Any | batch inserts with rewriteBatchedStatements=true returns incorrect row counts |
71637 | 2014-02-09 14:23 | 2016-02-23 15:18 | MySQL Server: Documentation | Closed (2984 days) | S1 | 5.6 | Any | Any | Manual mentions IS_GAP and IX_GAP locks, but never explains them |
71672 | 2014-02-11 15:02 | 2014-07-16 22:08 | Connector / J | Closed (3571 days) | S5 | 5.1.29 | Any | Any | Every SQL statement is checked if it contains "ON DUPLICATE KEY UPDATE" or not |
71864 | 2014-02-27 16:18 | 2014-05-07 16:07 | MySQL Enterprise Backup Documentation | Closed (3641 days) | S3 | 3.9.0 | Any | Any | Binlog info seems outdated |
71886 | 2014-02-28 15:37 | 2015-01-09 10:12 | MySQL Enterprise Backup | Closed (3394 days) | S3 | 3.9.0 | Any | Any | Command missing from help: copy-back-and-apply-log |
71923 | 2014-03-04 12:23 | 2014-07-17 17:29 | Connector / J | Closed (3570 days) | S3 | 5.1.29 | Any | Any | Incorrect generated keys if ON DUPLICATE KEY UPDATE not exact |
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 |
71956 | 2014-03-06 11:22 | 2014-03-07 17:02 | MySQL Server: Documentation | Closed (3702 days) | S3 | 5.6 | Any | Any | Manual does not explain how to work with P_S.setup_actors table |
72072 | 2014-03-19 7:31 | 2014-04-14 13:18 | MySQL Server: Locking | Not a Bug (3664 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 (3688 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 (3687 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 (3670 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 (3664 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 (2928 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 (3615 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 (3613 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 (3557 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 (3614 days) | S2 | 5.6.17 | Any | Any | A 5.6's optimizer bug which is releated to 'or' operator's number |
72717 | 2014-05-22 6:37 | 2014-06-12 17:14 | MySQL Server: Documentation | Closed (3605 days) | S4 | 5.7.5 | Any | Any | 'explain for connection' doesn't work on prepared statements |
72732 | 2014-05-23 22:06 | 2014-07-11 14:25 | Connector / Python | Closed (3591 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 (3284 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 (2981 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 (3609 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 (2543 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 (3592 days) | S3 | 6.1.6 | Any | Any | Result Grid's Data Import to include more types, like Data Export |
73170 | 2014-07-02 7:26 | 2016-09-20 8:55 | MySQL Server: InnoDB storage engine | Closed (3583 days) | S2 | 5.5 | Any | Any | Duplicates in Unique Secondary Index Because of Fix of Bug#68021 |
73207 | 2014-07-05 12:21 | 2017-04-27 14:36 | MySQL Server: Stored Routines | Closed (3440 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 (3548 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 (3574 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 (3570 days) | S2 | 1.2.2 | Any | Any | Floating point inaccuracy only on Python 2.x with mysql/connector python |
73370 | 2014-07-24 7:34 | 2014-08-27 18:12 | Connector / Python | Closed (3529 days) | S3 | 1.2.2 | Any | Any | NULL values not working with prepared statements in CPY |
73372 | 2014-07-24 10:11 | 2014-09-15 15:00 | Connector / J Documentation | Closed (3510 days) | S3 | Any | Any | Retrieving AUTO_INCREMENT Column documentation | |
73458 | 2014-08-03 10:23 | 2014-09-09 15:50 | MySQL Server: Documentation | Closed (3516 days) | S3 | 5.6.19, 5.6.21, 5.0.97 | Any | Any | No error or warning on truncation of TIMESTAMP/DATETIME |
73546 | 2014-08-12 8:36 | 2014-09-05 5:08 | MySQL Fabric | Closed (3520 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 (3528 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 (3527 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 (3370 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 (3363 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 (3363 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 (3226 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 (3481 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 (3482 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 (3356 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 (3317 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 (3425 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 (3412 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 (3208 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 (3453 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 (3452 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 (3451 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 (3443 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 (3425 days) | S3 | 5.5.42, 5.6.23, 5.7.6 | Any | Any | CONCAT() of columns with same encoding but different collations behaves wrongly |
75096 | 2014-12-03 15:59 | 2018-10-21 20:45 | MySQL Visual Studio Integration | No Feedback (3386 days) | S2 | 1.2.3 | Any | Any | Unable to debug a store procedure with mysql for visualstudio |
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 (3233 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 (3080 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 (3347 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 (3306 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 (3395 days) | S2 | 5.6, 5.6.24, 5.7.6 | Any | Any | INSERT into a view sometimes ignores default values |
75506 | 2015-01-14 17:35 | 2015-01-19 15:28 | MySQL Cluster: Documentation | Closed (3384 days) | S3 | all | Any | Any | ndb_restore command utility - description of --node-id is misleading |
75614 | 2015-01-24 1:48 | 2015-06-28 10:57 | MySQL Server: InnoDB storage engine | Verified (3376 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 (3272 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 (3367 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 (3312 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 (3271 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 (3286 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 (3319 days) | S3 | 5.7.6 | Any | Any | server crash while connecting with cleartext-plugin user with blank pwd |
75956 | 2015-02-18 14:28 | 2016-03-30 20:04 | Connector / J | Closed (2948 days) | S1 | 5.1.34 | Any | Any | Inserting timestamps using a PreparedStatement and useLegacyDatetimeCode=false |
75958 | 2015-02-18 18:21 | 2015-02-18 22:32 | MySQL Server: DML | Can't repeat (3354 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 (3347 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 (3317 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 (3261 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 (2101 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 (3160 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 (3318 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 (3323 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 (3319 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 (3317 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 (2799 days) | S2 | 5.6.24, 5.6.26 | Any | Any | InnoDB AUTO_INCREMENT produces same value twice |
76874 | 2015-04-28 15:23 | 2016-05-29 20:45 | Connector / J | Duplicate (3272 days) | S2 | 5.1.35 | Any | Any | Mysql fabric JDBC driver doens't update master server on fail |
77013 | 2015-05-12 10:28 | 2015-05-18 6:52 | Connector / ODBC | Verified (3265 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 (3257 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 (3261 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 (3234 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 (3153 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 (3209 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 (2352 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) |
77681 | 2015-07-10 13:50 | 2015-08-20 23:25 | Connector / J | Closed (3171 days) | S3 | 5.1.x | Any | Any | rewrite replace sql like insert when rewriteBatchedStatements=true (contributio |
77782 | 2015-07-20 6:32 | 2015-08-27 4:19 | MySQL Server: Optimizer | Closed (3195 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 (2681 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 (3194 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 (3194 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 (2988 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 (3181 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 (3180 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 (3174 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 (3159 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 (2751 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 (3124 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 (3152 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 (3152 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 (3146 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 (3149 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 (3147 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 (3143 days) | S1 | 6.3.4 CE | Any | Any | Tried Opening Remote MYSQL connection |
78527 | 2015-09-23 7:54 | 2016-06-18 21:28 | MySQL Server: Documentation | Closed (3117 days) | S3 | 5.7.10, 8.0.0 | Any | Any | incomplete support and/or documentation of the JSON datatype |
78536 | 2015-09-24 6:50 | 2018-05-08 13:11 | MySQL Server: DML | Not a Bug (2179 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 (3076 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 (3117 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 (3101 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 |
78778 | 2015-10-09 9:45 | 2017-04-11 7:15 | MySQL Server: C API (client library) | Closed (2610 days) | S3 | 5.7.8 | Any | Any | mysqlclient does not return correct mysql_insert_id via database handle |
78821 | 2015-10-13 15:28 | 2015-10-15 8:13 | MySQL Server: DML | Verified (3115 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 |
78846 | 2015-10-15 12:00 | 2017-11-12 20:45 | MySQL Server: Security: Privileges | Verified (2989 days) | S4 | 5.6 | Any | Any | TRIGGER privilege documentation is incorrect, and dangerous |
78856 | 2015-10-16 8:42 | 2015-11-02 14:24 | MySQL Server: Errors | Closed (3107 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 (3094 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 (3062 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 (3096 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 (3081 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 (3082 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 (3074 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 (1736 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 (3054 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 (3083 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 (3069 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 (3074 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 (3062 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 |
79548 | 2015-12-07 15:12 | 2015-12-09 19:42 | MySQL Server: Documentation | Closed (3060 days) | S3 | 5.7.8 | Any | Any | In "Update t1 set b(date) = c(datetime)", micro seconds are rounded |
79551 | 2015-12-08 3:55 | 2015-12-17 15:38 | MySQL Server: DML | Not a Bug (3052 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 (3055 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 (1606 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 (1990 days) | S3 | 5.7.8 | Any | Any | Result type for max(float column) is FLOAT, while expecting DOUBLE |
79688 | 2015-12-17 10:34 | 2016-02-17 19:14 | MySQL Server: Documentation | Closed (2990 days) | S3 | any | Any | Any | Manual does NOT explain Data_length vs Index_length properly for InnoDB tables |
79695 | 2015-12-18 4:25 | 2016-01-16 15:55 | MySQL Server: DML | Closed (3022 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 (3046 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 (3025 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 (1599 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 (1599 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 (3023 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 (3017 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 (3025 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 (3025 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 (3025 days) | S3 | 5.7.8, 5.5.48, 5.6.28 | Any | Any | Func ROUND(num, c1(NULL)) doesn't return NULL |
79991 | 2016-01-14 20:24 | 2018-10-21 20:45 | Connector / Python | No Feedback (2446 days) | S3 | Any | Any | start_transaction() not implemented in Python Conenctor | |
80026 | 2016-01-18 9:29 | 2016-05-31 14:41 | MySQL Server: Query Cache | Closed (2886 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 (3012 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 (2886 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 (2971 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 (2624 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 (2940 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 (2947 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 (2905 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 (2711 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 (2940 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 (2873 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 (2086 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 (2912 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 (2915 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 (2801 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 (2913 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 |
81468 | 2016-05-17 16:31 | 2022-11-05 2:03 | Connector / J | Closed (537 days) | S3 | 5.1.36 and 6.0.2 tested | Any | Any | MySQL server fails to rewrite batch insert when column name contains word select |
81533 | 2016-05-23 4:25 | 2016-05-23 7:24 | MySQL Server: DML | Verified (2894 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 (1592 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 (2884 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 (2878 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 (2871 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 (2866 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 (1584 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 (2855 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 (2477 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 (2821 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 (2813 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 (2802 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 (2393 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 (2759 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 (2690 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 (1575 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 (2746 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 (2737 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 (2708 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 (2691 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 (2701 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 (2676 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 (2533 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 (2512 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 (2675 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 (2586 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 (2424 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 (2653 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 (2495 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 (2635 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 (2631 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 (2597 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 (749 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 (2009 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 (2586 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 (2172 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 (2411 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 (2565 days) | S3 | 5.7.13, 5.7.18 | Any | Any | SQL optimizer fail to check IS NULL condition |
86159 | 2017-05-02 13:08 | 2018-10-21 20:45 | Connector / J | No Feedback (2518 days) | S2 | 5.1.42 | Any | Any | JConnector driver does not free closed objects |
86215 | 2017-05-08 13:35 | 2017-07-11 22:44 | MySQL Server: Optimizer | Analyzing (2480 days) | S5 | 8.0.1 | Any | Any | MySQL is much slower in 5.7 vs 5.6 |
86422 | 2017-05-23 9:00 | 2017-10-13 17:00 | MySQL Server: InnoDB storage engine | Closed (2386 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 (1284 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 (2487 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 (2487 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 (2439 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 (2117 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 (2359 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 (2010 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 (2436 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 (2229 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 (2302 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 (2394 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 (2396 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 (2241 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 (2388 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 (1934 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 (1366 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 (2332 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 (2215 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 |
12449 | 2005-08-09 4:37 | 2005-09-16 13:21 | MySQL Server: InnoDB storage engine | Closed (6796 days) | S2 | all | Any (all) | Any | DELETE from table references itself |
12765 | 2005-08-23 22:54 | 2005-08-24 11:05 | MySQL Server | Not a Bug (6819 days) | S4 | last | Any (any) | Any | CURRENT_DATE function can not be used as a DEFAULT value for a column |
12766 | 2005-08-23 22:54 | 2005-08-23 22:58 | MySQL Server | Duplicate (6820 days) | S2 | last | Any (any) | Any | what are you doing? |
12767 | 2005-08-23 22:54 | 2005-08-23 22:58 | MySQL Server | Duplicate (6820 days) | S2 | last | Any (any) | Any | what are you doing? |
12768 | 2005-08-23 22:54 | 2005-08-23 22:59 | MySQL Server | Duplicate (6820 days) | S2 | last | Any (any) | Any | what are you doing? |
12769 | 2005-08-23 22:54 | 2005-08-23 22:59 | MySQL Server | Duplicate (6820 days) | S2 | last | Any (any) | Any | what are you doing? |
12956 | 2005-09-02 18:42 | 2005-12-09 19:41 | MySQL Server | Closed (6712 days) | S3 | 4.0 | Any (all) | Any | cast make differ rounding |
13265 | 2005-09-16 13:16 | 2012-05-18 20:19 | MySQL Server: Row Based Replication ( RBR ) | Duplicate (5069 days) | S4 | Any | Any | Adding --hex-blob to mysqlbinlog | |
13311 | 2005-09-19 0:13 | 2006-09-20 15:28 | MySQL Server: Optimizer | Closed (6427 days) | S3 | 5.0 | Any (All) | Any | IN + binary lead to incorrect SELECT results |
13460 | 2005-09-24 14:22 | 2019-10-10 21:42 | MySQL Server: DML | Won't fix (1659 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 (6784 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 (6768 days) | S4 | Any | Any | enhancement to fillfactor | |
14050 | 2005-10-15 17:52 | 2018-09-09 20:45 | MySQL Server: DML | Verified (4878 days) | S4 | Any | Any (Any) | Any | Blocking some replication statements. |
15014 | 2005-11-17 12:51 | 2006-02-02 13:58 | MySQL Server: Stored Routines | Closed (6657 days) | S2 | 5.0 | Any (Any) | Any | Performance problems with functions |
15062 | 2005-11-18 23:03 | 2005-11-19 18:20 | Connector / J | Can't repeat (6732 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 (5504 days) | S4 | 4.1,5.0 | Any | Any | On-disk temporary tables created for GROUP BY should use indexes |
15429 | 2005-12-02 10:09 | 2006-01-26 2:45 | MySQL Server | Closed (6664 days) | S3 | 4.1.16 | Any (all) | Any | Test "func_math" not prepared for "classic" build |
15454 | 2005-12-03 4:38 | 2011-03-29 18:35 | MySQL Server | Closed (4776 days) | S5 | all | Any (all) | Any | watch |
15584 | 2005-12-08 12:25 | 2018-02-11 20:45 | MySQL Server | Analyzing (3964 days) | S4 | Any | Any | Server can not tell clients about generated keys | |
15874 | 2005-12-19 23:23 | 2014-02-21 17:56 | MySQL Server | Unsupported (3716 days) | S5 | 5.0.17, the latest bk | Any (All) | Any | Problem with intensive locking (deadlocks?) during execution of system_1 test |
16463 | 2006-01-12 18:41 | 2006-01-13 18:19 | MySQL Server: Documentation | Closed (6677 days) | S2 | All | Any (All) | Any | '14.4 Choosing a Storage Engine' lists InnoDB costs too high, NDB features wrong |
16689 | 2006-01-20 22:31 | 2012-05-18 20:19 | MySQL Server | Duplicate (6659 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 (6665 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 (4776 days) | S4 | NEWS | Any (ALL) | Any | SQL MODE FEATURE |
17530 | 2006-02-17 14:50 | 2006-02-27 20:53 | MySQL Server | Closed (6632 days) | S1 | 5.0.18 | Any (Any) | Any | Bug in non-UNIQUE index column truncation |
18350 | 2006-03-20 10:43 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5059 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 (6596 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 (6594 days) | S2 | 5.0 | Any (all) | Any | It is very slowly when the where statment include function |
19088 | 2006-04-13 20:05 | 2006-04-25 9:21 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6575 days) | S3 | 5.0 | Any (*) | Any | NDBAPI: Segfault in NdbIndexScanOperation::setBound(...) |
19111 | 2006-04-14 23:44 | 2006-11-13 4:31 | MySQL Server | Closed (6373 days) | S2 | 5.0.20/5.0BK/5.1BK | Any (any) | Any | TRIGGERs selecting from a VIEW on the firing base table fail |
19205 | 2006-04-19 20:44 | 2011-02-16 23:43 | MySQL Server: Prepared statements | Can't repeat (5248 days) | S3 | 4.1, 5.0-BK | Any (any) | Any | server provides different metadata in ps-protocol and non-ps-protocol mode |
19403 | 2006-04-27 16:46 | 2006-08-31 18:53 | MySQL Server | Closed (6447 days) | S2 | 5.1.9 | Any (All) | Any | Crash that happens during removing of database name from cache (#2) |
20536 | 2006-06-19 13:36 | 2006-09-25 15:00 | MySQL Server: Charsets | Closed (6422 days) | S3 | 5.0.23BK, 4.1 | Any (*) | Any | md5() with GROUP BY and UCS2 return different results on myisam/innodb |
20694 | 2006-06-26 13:01 | 2006-07-01 19:14 | Connector / J | Can't repeat (6508 days) | S2 | 3.1.13 | Any (Any) | Any | Java |
20732 | 2006-06-27 20:48 | 2006-11-13 18:55 | MySQL Server | Closed (6373 days) | S3 | 4.1 | Any (all) | Any | Partial index and long sjis search with '>' fails sometimes |
20989 | 2006-07-12 9:13 | 2006-08-04 19:35 | MySQL Server: Security: Privileges | Closed (6474 days) | S2 | 5.0.23,5.1 | Any (any) | Any | View '(null).(null)' references invalid table(s)... on SQL SECURITY INVOKER |
21091 | 2006-07-17 9:40 | 2014-03-31 11:48 | Connector / J | Can't repeat (3678 days) | S3 | 3.1.13 | Any | Any | getGeneratedKeys() problem |
21131 | 2006-07-19 2:27 | 2011-02-16 23:43 | MySQL Server: Locking | Closed (5515 days) | S4 | 4.1.20 | Any | Any | SHOW TABLE STATUS blocked by write lock |
21335 | 2006-07-28 23:08 | 2007-07-05 20:30 | MySQL Server: Documentation | Not a Bug (6139 days) | S2 | 4.1.22 4.0.28 | Any | Any | UNIQUE index on TEXT columns allows trailing whitespace |
21479 | 2006-08-07 12:29 | 2007-06-02 17:22 | MySQL Server: Row Based Replication ( RBR ) | Not a Bug (6172 days) | S2 | 5.1 | Any (ALL) | Any | Binary log rotation cause "orphan" table map event |
21852 | 2006-08-27 14:36 | 2008-06-23 11:54 | MySQL Server | Can't repeat (5785 days) | S3 | 5.0.22 | Any (*) | Any | INSERT statement causing table corruption on v5 but not on v4 |
22150 | 2006-09-09 5:35 | 2007-04-19 17:09 | MySQL Server: Falcon storage engine | Closed (6216 days) | S3 | 5.2 | Any | Any | Falcon: both client and server hang in case of update conflict |
22154 | 2006-09-09 5:46 | 2007-05-20 5:41 | MySQL Server: Falcon storage engine | Closed (6185 days) | S3 | 5.2 | Any | Any | Crash after 500 alters, 500 inserts, and a few updates |
22183 | 2006-09-09 10:40 | 2006-12-05 15:56 | MySQL Server: Falcon storage engine | Closed (6351 days) | S2 | 5.2 | Any (all) | Any | Loss of data after INSERT and ALTER with two interleaving transactions |
22240 | 2006-09-11 15:39 | 2007-09-15 12:11 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6067 days) | S2 | 5.0,5.1 | Any | Any | Upgrading from cluster 5.0 to 5.1 does not resize VARCHARS as expected |
22406 | 2006-09-15 20:08 | 2010-05-26 17:59 | MySQL Server: Falcon storage engine | Unsupported (5083 days) | S1 | mysql-6.0-falcon-team | Any | Any | Falcon: Clients hang when a no disk space error occurs in background threads |
22552 | 2006-09-21 16:14 | 2018-09-25 21:44 | MySQL Server: Tests | No Feedback (4224 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 (6379 days) | S4 | 5.0 | Any | Any | allow missing data = NULL in LOAD DATA INFILE |
23264 | 2006-10-13 15:35 | 2011-02-16 23:43 | Connector / ODBC | Closed (5243 days) | S2 | 3.51 | Any | Any | MyODBC driver returns 'x' instead of empty string when IF applies on TEXT field |
23266 | 2006-10-13 16:35 | 2013-05-30 7:07 | Connector / ODBC | Closed (3983 days) | S2 | 3.x | Any (all) | Any | Inability to execute statements with numeric parameters in a german locale |
23311 | 2006-10-15 22:28 | 2012-05-18 20:19 | MySQL Server: Stored Routines | Duplicate (6377 days) | S2 | 5.0.24a | Any (Any) | Any | Queries within triggers give unexpected results |
23403 | 2006-10-18 2:01 | 2006-12-08 11:23 | MySQL Server: Documentation | Closed (6348 days) | S3 | 5.0.24a | Any (Any) | Any | ROW_FORMAT=FIXED at table creation time does not force fixed column types |
23454 | 2006-10-19 8:12 | 2006-10-20 7:22 | MySQL Enterprise Monitor: Installing | Closed (6397 days) | S1 | 0.7.5 | Any (all) | Any | Server Inst completes normally but authentication always fails (br 1739) |
23553 | 2006-10-23 14:32 | 2012-05-18 20:19 | MySQL Server: Replication | Verified (6386 days) | S4 | 5.0.26 | Any (Any) | Any | SBR needs to recognize appropriate cross-database DML |
23802 | 2006-10-31 13:00 | 2012-05-18 20:19 | MySQL Server | Duplicate (6371 days) | S2 | 5.0 | Any (all) | Any | INSERT (innodb) SF + concurrent SELECTs may result in wrong data in query cache |
23929 | 2006-11-03 10:15 | 2007-08-06 14:27 | MySQL Server: Prepared statements | Won't fix (6107 days) | S3 | 4.1.23 | Any | Any | prepared statement INSERT into char field, bound to MYSQL_TYPE_LONG = bad data |
24117 | 2006-11-08 23:51 | 2007-02-01 1:03 | MySQL Server: Stored Routines | Closed (6293 days) | S2 | 5.0.26,5.0.28 | Any (*) | Any | server crash on a FETCH with a cursor on a table which is not in the table cache |
24950 | 2006-12-11 9:24 | 2011-02-16 23:43 | MySQL Server: Errors | Verified (6317 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 |
25034 | 2006-12-13 10:54 | 2008-06-18 11:20 | MySQL Server: General | Won't fix (5790 days) | S2 | 5.0 & 5.1 | Any (Any) | Any | MySQL does not correctly handle errors on statement commit |
25379 | 2007-01-03 6:16 | 2007-02-22 11:19 | Connector / J | Closed (6272 days) | S3 | 3.1.10 | Any (ANY) | Any | INOUT parameters add extra delimiters for the char ' (single quote) |
25435 | 2007-01-05 15:11 | 2012-05-18 20:19 | MySQL Server: Stored Routines | Duplicate (6315 days) | S3 | 5.0.32, 5.1.14 | Any (Any) | Any | All triggers evaluated for statement even if out of scope of the statement |
25597 | 2007-01-12 21:55 | 2017-05-21 20:45 | MySQL Server: Replication | In progress (6285 days) | S3 | 5.0, 5.1 | Any (All) | Any | Extraneous error message displayed for slave SQL thread errors. |
25665 | 2007-01-17 4:33 | 2009-04-27 2:58 | MySQL Server: Falcon storage engine | Can't repeat (5477 days) | S3 | 5.2 Falcon | Any | Any | Creating primary key index on Falcon table uses too much disk space |
25820 | 2007-01-24 11:15 | 2012-05-18 20:19 | MySQL Server: Locking | Duplicate (6282 days) | S3 | 5.0.36BK | Any (*) | Any | CPU pegged at 100% after optimizing table belonging to merge set |
25847 | 2007-01-25 14:06 | 2024-04-02 11:53 | MySQL Server: InnoDB storage engine | Verified (6300 days) | S4 | 5.0.32 | Any (Any) | Any | Add predicate locking to avoid deadlocks due to locking non-existent rows |
25953 | 2007-01-30 16:50 | 2012-09-13 10:39 | Connector / NET | No Feedback (6223 days) | S2 | 5.0.3 | Any (Server 2003) | Any | ASP.NET page returns "object reference not set" when update is attempted |
26193 | 2007-02-08 19:26 | 2007-06-25 14:17 | MySQL Server: Replication | Can't repeat (6149 days) | S3 | 5.1-bk | Any | Any | Assertion fails in my_tz_select() |
26316 | 2007-02-13 12:01 | 2022-04-28 15:04 | MySQL Server: InnoDB storage engine | Closed (5013 days) | S2 | 5.0.36-BK, 5.0.32, 5.0.38BK, 5.1.17BK | Any (*) | Any | Triggers create duplicate entries on auto-increment columns |
26424 | 2007-02-15 20:52 | 2007-03-13 20:25 | MySQL Server: General | Can't repeat (6253 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 (4081 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 (5676 days) | S4 | * | Any (*) | Any | Char and binary types without padding/stripping |
26824 | 2007-03-03 14:21 | 2018-09-09 20:45 | MySQL Server: Prepared statements | Verified (3751 days) | S2 | 5.1.17-bk, probably 4.1 and 5.0 too | Any (All) | Any | Libmysql, possibly C/XYZ, does not handle error of COM_STMT_SEND_LONG_DATA |
26827 | 2007-03-03 20:37 | 2007-07-07 18:50 | MySQL Server: Partitions | Closed (6137 days) | S2 | 5.1, 5.2 | Any (SUSE 10.0 / 64-bit, suse9.3 x86) | Any | table->read_set is set incorrectly, causing update of a different column |
27025 | 2007-03-10 15:48 | 2007-05-01 18:32 | MySQL Enterprise Monitor: Agent | Closed (6204 days) | S3 | 1.1.0.4876 | Any (all) | Any | SQL errors when monitored mysqld is being backed up |
27234 | 2007-03-17 4:48 | 2022-12-04 20:45 | MySQL Server: Merge storage engine | Verified (6245 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 (6050 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 |
27515 | 2007-03-29 10:15 | 2007-04-27 4:25 | MySQL Server: Security: Privileges | Closed (6208 days) | S2 | 4.1, 5.0, 5.1 | Any (any) | Any | DROP previlege is not required anymore for RENAME TABLE |
27563 | 2007-03-31 14:09 | 2007-06-18 17:57 | MySQL Server: Stored Routines | Closed (6156 days) | S3 | 5.0.38 | Any | Any | killing noticed in SF() stack but the error gets missed in action and wrong rslt |
27586 | 2007-04-02 11:28 | 2007-04-11 2:17 | MySQL Server | Closed (6224 days) | S3 | 5.0-bk | Any | Any | Wrong autoinc value assigned by LOAD DATA in the NO_AUTO_VALUE_ON_ZERO mode |
27722 | 2007-04-09 21:01 | 2007-04-20 15:01 | MySQL Server: Falcon storage engine | Closed (6215 days) | S2 | 5.2.4-pb475 | Any | Any | Problem with update conflict resolution |
27756 | 2007-04-11 14:25 | 2007-04-17 10:01 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6218 days) | S3 | 5.1 | Any | Any | Memleak with insert+delete |
27824 | 2007-04-14 17:11 | 2007-12-22 18:05 | Eventum | No Feedback (5969 days) | S3 | 2.0 beta 1 | Any | Any | 'DB Error: unknown error' |
27826 | 2007-04-14 17:17 | 2013-07-09 8:30 | Eventum | Closed (3943 days) | S3 | 2.0 beta 1 | Any | Any | 'DB Error: unknown error' on class.issue.php [2] |
28133 | 2007-04-27 12:05 | 2007-05-10 18:02 | MySQL Server | Closed (6195 days) | S3 | 5.0-bk | Any | Any | Wrong DATE/DATETIME comparison in IN() function |
28158 | 2007-04-30 6:11 | 2007-07-18 19:27 | MySQL Server | Closed (6126 days) | S3 | 5.1 | Any | Any | table->read_set is set incorrectly, wrong error message in Falcon and NDB |
28203 | 2007-05-02 14:50 | 2011-02-16 23:43 | MySQL Server: Command-line Clients | Closed (5376 days) | S3 | Any | Any | mysql client + null byte | |
28332 | 2007-05-09 13:07 | 2007-06-23 11:57 | MySQL Server: Compiling | No Feedback (6151 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 (6195 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 (6191 days) | S3 | Any | Any | date format | |
28422 | 2007-05-14 18:35 | 2011-02-16 23:43 | MySQL Server: Command-line Clients | Verified (5986 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 (6189 days) | S1 | 5.0.41 | Any | Any | wrong affected rows when using insert into ... on duplicate key ... |
28449 | 2007-05-15 15:50 | 2007-06-14 19:26 | MySQL Server: General | Closed (6160 days) | S2 | 5.0, 5.1.19 | Any | Any | Server crashes on closing a temporary table after SELECT ... GROUP BY |
28587 | 2007-05-22 9:26 | 2007-10-23 15:56 | MySQL Server: Locking | Closed (6029 days) | S2 | 5.0.46-BK, 5.1.19-BK, 5.0.40, 4.1.19 | Any | Any | SELECT is blocked by INSERT waiting on read lock, even with low_priority_updates |
28697 | 2007-05-26 3:39 | 2007-05-26 5:34 | MySQL Server: Data Types | Not a Bug (6179 days) | S2 | 5.0.41 | Any | Any | UNIQUE inded on VARCHAR(X) column disallowes proper values on insert. |
28713 | 2007-05-28 4:53 | 2007-08-30 17:12 | MySQL Server: Documentation | Closed (6083 days) | S3 | 5.0, 5.1 | Any | Any | Binary log and concurrent inserts |
28724 | 2007-05-28 13:24 | 2007-06-19 13:33 | MySQL Cluster: NDB API | Closed (6155 days) | S2 | Any | Any | blob code sets error code on transaction object | |
28787 | 2007-05-30 19:46 | 2016-02-25 12:24 | MySQL Server: Information schema | Can't repeat (6068 days) | S2 | 5.0.41 | Any | Any | Warnings from information_schema cause "ERROR 1105 (HY000): Unknown error" |
28861 | 2007-06-04 5:51 | 2013-03-03 20:45 | MySQL Server: FULLTEXT search | Duplicate (6161 days) | S3 | 4.1, 5.0, 5.1 | Any (Linux, Windows XPProfessional) | Any | Problem With full text search and some characters in boolean mode i want to igno |
28922 | 2007-06-06 11:06 | 2012-05-18 20:19 | MySQL Server | Duplicate (6159 days) | S2 | Any | Any | strange result in func_in | |
28932 | 2007-06-06 19:02 | 2008-01-30 15:36 | MySQL Server: Documentation | Closed (5930 days) | S3 | 5.0.27/5.0BK/5.1BK | Any (example below) | Any | the quote function does not seem to return a string compatible with INSERT |
28934 | 2007-06-06 20:38 | 2007-06-18 15:35 | MySQL Server: Prepared statements | Closed (6156 days) | S1 | 5.0 | Any | Any | server crash when receiving malformed com_execute packets |
28960 | 2007-06-07 21:05 | 2017-05-21 20:45 | MySQL Server: Replication | Duplicate (6162 days) | S3 | <= 5.0.42, 5.1.x | Any | Any | non-trans temp table changes with insert .. select not binlogged after rollback |
28983 | 2007-06-08 18:08 | 2007-07-09 1:01 | MySQL Server: General | Closed (6135 days) | S1 | 5.0.44-BK, 5.0.42 | Any | Any | 'reset master' in multiple threads and innodb tables asserts debug binary |
29046 | 2007-06-12 8:06 | 2018-09-25 21:45 | MySQL Server: Tests | Closed (5994 days) | S7 | 5.1.20 | Any | Any | rpl_stm_mystery22 unstable |
29103 | 2007-06-14 10:48 | 2007-06-19 12:25 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6155 days) | S3 | 5.1.19 | Any | Any | ndb_restore segfaults on NULL var[char|binary] |
29206 | 2007-06-19 11:42 | 2007-07-02 4:50 | MySQL Server: Falcon storage engine | Closed (6142 days) | S3 | 6.0.1-alpha-debug | Any (SUSE 10 64-bit) | Any | Falcon: Two-way deadlock with unique index |
29250 | 2007-06-20 21:16 | 2007-08-10 18:16 | MySQL Server: Archive storage engine | Can't repeat (6103 days) | S1 | 5.1.20, 5.0.44 | Any | Any | Assertion `row_len <= record_buffer->length' failed. |
29252 | 2007-06-20 21:44 | 2007-07-03 18:51 | MySQL Server: CSV | Closed (6141 days) | S1 | 5.1.20 | Any | Any | Assertion `!table->file || table->file->inited == handler::NONE' failed. |
29351 | 2007-06-26 4:57 | 2007-07-26 9:58 | MySQL Server | No Feedback (6118 days) | S1 | 5.0.16 | Any | Any | Archive tables corrupt when run "show table status" |
29353 | 2007-06-26 7:11 | 2007-07-10 22:41 | MySQL Server: CSV | Closed (6134 days) | S1 | 5.1 source | Any | Any | inserting a negative value to a csv table leads to the table corruption |
29361 | 2007-06-26 14:04 | 2015-08-10 14:33 | MySQL Server: mysqldump Command-line Client | Closed (6134 days) | S3 | 5.0.44 | Any | Any | mysqldump creates stray file when too long path name is passed |
29411 | 2007-06-28 6:39 | 2007-07-10 22:39 | MySQL Server: CSV | Closed (6134 days) | S1 | 5.1 source | Any | Any | deleting from a csv table leads to the table corruption |
29480 | 2007-07-02 9:54 | 2022-09-04 20:45 | MySQL Server: Errors | Duplicate (6113 days) | S2 | 5.0.41 | Any (Linux, Windows) | Any | #1105 - Unknown error |
29492 | 2007-07-02 16:50 | 2015-01-09 9:58 | MySQL Enterprise Monitor: Web | Closed (3394 days) | S4 | 1.1.1 | Any | Any | Same color for servers across graphs |
29632 | 2007-07-08 22:23 | 2007-07-23 18:05 | MySQL Server: BDB | Won't fix (6121 days) | S2 | 5.0.46BK | Any | Any | insert into + analyze bdb table in >1 threads crashes mysqld |
29869 | 2007-07-18 13:41 | 2007-07-18 16:44 | MySQL Server: Security: Privileges | Not a Bug (6126 days) | S2 | 5.0.41 | Any | Any | Users with no privileges can do operations |
29891 | 2007-07-19 8:04 | 2007-07-19 16:03 | MySQL Server: InnoDB storage engine | Not a Bug (6125 days) | S3 | 5.0.45, 4.1, 5.0, 5.1 BK | Any (Linux, Windows, Mac) | Any | innodb and lock on delete |
29956 | 2007-07-22 11:48 | 2007-07-22 15:40 | MySQL Server: Optimizer | Won't fix (6122 days) | S4 | All | Any | Any | Explain should optionally execute the query and return the execution path |
29985 | 2007-07-23 19:56 | 2007-11-05 2:34 | MySQL Server: Command-line Clients | Closed (6016 days) | S2 | 5.1.* | Any | Any | mysqlslap -- improper handling of resultsets in SPROCs |
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 (6106 days) | S2 | Any | Any | CREATE ROUTINE privilege not needed to create/alter stored procedures | |
30282 | 2007-08-07 18:42 | 2021-05-23 20:45 | MySQL Server: Falcon storage engine | Duplicate (5607 days) | S2 | 6.0-falcon | Any | Any | Falcon: duplicate-key error for value that ends with 0x00 |
30379 | 2007-08-13 1:55 | 2007-11-06 8:45 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6015 days) | S3 | Any | Any | TC timeout check isn't very random | |
30521 | 2007-08-20 20:49 | 2007-12-14 20:18 | MySQL Server: Documentation | Closed (5977 days) | S3 | 5.1 | Any | Any | strange: CREATE TEMPORARY TABLE .. AS SELECT is only partially atomic |
30560 | 2007-08-22 11:33 | 2007-12-08 15:39 | MySQL Server: Tests | Closed (5983 days) | S3 | Any | Any | Valgrind option to mysql-test-run with spaces in cause strange error | |
30784 | 2007-09-04 9:33 | 2022-12-04 20:45 | MySQL Server: DDL | Verified (5559 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 (5559 days) | S4 | 5.X | Any | Any | COLUMN_FORMAT=FIXED columns in ROW_FORMAT=DYNAMIC MyISAM tables? |
30827 | 2007-09-05 11:50 | 2007-09-05 12:34 | MySQL Server: InnoDB storage engine | Not a Bug (6077 days) | S3 | 5.0.41 | Any | Any | Autoincrement counter does not update on record update |
30863 | 2007-09-06 13:47 | 2022-11-05 1:45 | Connector / J | Won't fix (537 days) | S4 | Mysql 5.1.21 | Any | Any | setDefault |
30868 | 2007-09-06 15:57 | 2007-09-06 15:57 | MySQL Server | Open | S4 | 5.0 | Any | Any | feature request: subdatabases |
30907 | 2007-09-07 17:18 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5060 days) | S2 | 5.1.22 | Any | Any | Regression: "--innodb_autoinc_lock_mode=0" (off) not same as older releases |
30922 | 2007-09-10 6:02 | 2008-09-04 18:49 | MySQL Enterprise Monitor: Server | Closed (5712 days) | S3 | 1.2.0.7481 | Any | Any | Constraint Violation Exception when starting several replication agents at once |
31104 | 2007-09-20 6:31 | 2012-05-18 20:19 | MySQL Server: General | Duplicate (6037 days) | S3 | 5.0-bk, 5.1-bk | Any | Any | string to longlong conversion error |
31121 | 2007-09-20 22:02 | 2014-12-09 19:16 | MySQL Proxy: Scripts | Verified (3425 days) | S4 | 0.6.0, 0.8.5 | Any | Any | rw-splitting script does not handle temporary tables |
31152 | 2007-09-23 7:05 | 2012-05-18 20:19 | MySQL Server: Data Types | Duplicate (6050 days) | S2 | 5.1.23-debug, 5.0.48-debug | Any | Any | virtual int Field_str::store(double): Assertion `local_char_length < 5 || length |
31349 | 2007-10-02 18:13 | 2007-12-20 0:43 | MySQL Server: Data Types | Closed (5971 days) | S3 | 5.1.23-debug, 5.0.48-debug | Any | Any | ERROR 1062 (23000): Duplicate entry '' for key 'group_key' |
31456 | 2007-10-08 15:43 | 2016-01-03 20:45 | MySQL Server: InnoDB storage engine | Duplicate (6042 days) | S4 | 5.0.45/4.1 | Any | Any | Foreign keys (with InnoDB) aren't working (multiple problems) |
31457 | 2007-10-08 15:46 | 2011-02-16 23:43 | Connector / J | Duplicate (5533 days) | S3 | Jdbc-5.0.7 | Any (atleast Windows and Linux) | Any | JDBC SQL Escape processing {fn ... confused by escaped quotes |
31535 | 2007-10-11 14:23 | 2007-11-29 18:38 | MySQL Server: Documentation | Closed (5992 days) | S3 | 5.1.22 | Any | Any | ALTER EVENT fails if 'RENAME...' and 'ON COMPLETION...' clauses are included |
31643 | 2007-10-16 15:26 | 2022-12-12 5:54 | MySQL Server: Stored Routines | Verified (5622 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 (6003 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 (6030 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 (6026 days) | S2 | 5.0.50, 5.1.23,6.0.3 | Any | Any | Federated tables break replication |
31761 | 2007-10-22 17:55 | 2007-11-05 22:26 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6016 days) | S3 | 5.0.52, 5.1-telco | Any (gcc 4.2.1) | Any | Code for cluster is not safe for strict-alias optimization in new gcc |
31840 | 2007-10-25 10:00 | 2007-12-14 17:42 | MySQL Server: Replication | Not a Bug (5977 days) | S3 | 4.1,5.0 | Any | Any | Slave displays queries that should be filtered out in SHOW PROCESSLIST |
31874 | 2007-10-26 11:02 | 2007-11-06 8:32 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6015 days) | S2 | mysql-6.0, mysql-telco-6.2 | Any | Any | Failure for NDB update/delete with combined range and equality constraints |
31971 | 2007-10-30 23:08 | 2019-10-29 22:33 | MySQL Server: DML | Can't repeat (1640 days) | S3 | 5.0.51 and 5.0.45 | Any (Debian, FreeBSD) | Any | last_insert_id with on duplicate key still broken |
31988 | 2007-10-31 14:51 | 2008-04-20 9:36 | MySQL Server: Command-line Clients | No Feedback (5849 days) | S3 | 5.0.27 | Any | Any | mysqlhotcopy should FLUSH TABLES on _copy/_copy_old, else disk space not freed |
32046 | 2007-11-02 6:11 | 2012-05-18 20:19 | MySQL Server: Replication | Duplicate (5932 days) | S2 | 5.1.23 | Any | Any | slave fails with 'Relay log read failure: Could not parse relay log event entry' |
32095 | 2007-11-05 7:26 | 2008-01-23 16:28 | MySQL Server | Closed (5937 days) | S3 | 5.1.22 | Any | Any | data has different result for double type with/without ps-protocol |
32200 | 2007-11-08 21:28 | 2016-10-16 20:45 | MySQL Server: Replication | Verified (6008 days) | S3 | 5.0.50,5.1.22 | Any | Any | National characters in table/view names and replication |
32260 | 2007-11-11 3:26 | 2007-11-30 1:23 | MySQL Server | Closed (5991 days) | S1 | 5.1.23-BK | Any | Any | User variables in query cause server crash |
32471 | 2007-11-17 16:01 | 2007-11-29 15:37 | MySQL Server: General | Not a Bug (5992 days) | S3 | 5.0.45, 4.1, 5.0, 5.1 BK | Any (Linux, Windows) | Any | Conditional update statement not working as expected |
32559 | 2007-11-21 7:04 | 2007-12-14 19:27 | MySQL Server: General | Closed (5977 days) | S1 | 5.0.50, 5.1.23 | Any | Any | connection hangs on query with name_const |
32587 | 2007-11-21 17:56 | 2007-11-22 15:07 | Connector / J | Duplicate (5999 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 (5467 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 (5991 days) | S3 | 6.0.4-alpha-debug | Any | Any | Privileges: I can CREATE ... LIKE without SELECT privilege |
33019 | 2007-12-05 21:27 | 2010-02-20 19:29 | MySQL Server: Backup | Closed (5178 days) | S3 | 6.0 | Any | Any | Online backup process can consume too much processor time |
33083 | 2007-12-08 1:22 | 2012-06-20 16:48 | MySQL Server: Stored Routines | Closed (4327 days) | S1 | 5.0, 5.1, 5.2 | Any | Any | Stored Function: error and crash if a temporary table is dropped in a loop |
33177 | 2007-12-12 17:10 | 2009-05-15 17:04 | MySQL Server: Falcon storage engine | Closed (5459 days) | S2 | 6.0.4 | Any (Linux and Mac OS X) | Any | Table creation fails after error 305 and tablespace change |
33190 | 2007-12-12 23:50 | 2009-05-15 14:15 | MySQL Server: Falcon storage engine | Closed (5459 days) | S3 | 6.0.4 team | Any | Any | Falcon: DeferredIndex and IndexKey may sort slightly differently |
33191 | 2007-12-13 1:21 | 2008-05-02 23:30 | MySQL Server: Falcon storage engine | Closed (5837 days) | S2 | 6.0.4 | Any | Any | Threads 'serialize' when multy-query delete trans. w/trig are run againt Falcon |
33258 | 2007-12-15 9:06 | 2010-05-26 17:59 | MySQL Server: Falcon storage engine | Unsupported (5083 days) | S3 | 6.0.5 | Any | Any | Misleading Error when DROP TABLE operation while a transaction is open |
33266 | 2007-12-16 7:33 | 2018-09-25 21:47 | MySQL Server: Tests | Closed (5867 days) | S7 | 5.0.54,5.1.23, 5.1.24-BK, 6.0-BK | Any | Any | regression test subselect fails |
33370 | 2007-12-19 16:28 | 2007-12-25 18:17 | MySQL Server | Not a Bug (5966 days) | S3 | * | Any | Any | wrong update row count |
33372 | 2007-12-19 16:45 | 2008-01-08 20:24 | MySQL Server: Documentation | Closed (5952 days) | S3 | 5.0.52 | Any | Any | InnoDB free: 0 on a newly created ( and non 0 size) table |
33376 | 2007-12-19 17:35 | 2016-10-16 20:45 | MySQL Server: Row Based Replication ( RBR ) | Verified (4486 days) | S2 | 5.1, 6.0 bzr | Any | Any | Write set for table not set correctly when inserting an empty set |
33504 | 2007-12-24 20:27 | 2012-09-13 11:02 | Connector / NET | No Feedback (5927 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 (5962 days) | S3 | Any | Any | Bugs system does not accept file attachments | |
33670 | 2008-01-03 18:54 | 2016-10-16 20:45 | MySQL Server: Row Based Replication ( RBR ) | Duplicate (5344 days) | S3 | 6.0.4 | Any | Any | binlog_stm_ctype_cp932 test fails under Falcon |
33691 | 2008-01-04 13:41 | 2008-03-05 14:49 | MySQL Server: Partitions | Closed (5895 days) | S3 | 6.0.4-p2 | Any | Any | Falcon crash on partition manipulations |
33702 | 2008-01-05 8:55 | 2011-02-16 23:43 | MySQL Server: Federated storage engine | Closed (5698 days) | S3 | 5.1.23 | Any (Linux and Mac OS X) | Any | accessing a federated table with a non existing server returns random error code |
33849 | 2008-01-13 17:40 | 2008-06-27 10:31 | MySQL Cluster: Replication | Closed (5781 days) | S3 | Any | Any | COMMIT event missing in cluster circular replication. | |
33928 | 2008-01-18 18:34 | 2013-02-20 22:18 | Connectors: DBD::mysql ( Perl ) | Unsupported (4082 days) | S2 | 4.006 | Any | Any | more_results incorrectly interprets value returned by mysql_next_result() |
34018 | 2008-01-23 20:01 | 2011-02-16 23:43 | Connector / J Documentation | Closed (5558 days) | S4 | Any | Any | describe implications of connection escaping on "max_allowed_packet size" | |
34166 | 2008-01-30 15:15 | 2008-02-11 20:45 | MySQL Server: Information schema | Closed (5918 days) | S3 | Any | Any | Server crash in SHOW OPEN TABLES and pre-locking. | |
34207 | 2008-01-31 20:45 | 2011-02-16 23:43 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5522 days) | S2 | 5.1.22 | Any | Any | Cluster will not restart, phase 3 takes 20 minutes then crash |
34228 | 2008-02-01 13:55 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5926 days) | S4 | * | Any | Any | Bulk Update statement |
34258 | 2008-02-03 0:51 | 2008-03-04 12:01 | MySQL Query Browser | No Feedback (5896 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 (4398 days) | S3 | 5.0, 5.1, 6.0 BK | Any | Any | CREATE TABLE fails if in NO_ZERO_DATE SQL mode |
34366 | 2008-02-07 0:02 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (5918 days) | S3 | 5.1.22 | Any | Any | Insert into a partitioned MyISAM table gives ER_AUTOINC_READ_FAILED error |
34393 | 2008-02-07 19:50 | 2008-02-08 7:36 | MySQL Server: Maria storage engine | Not a Bug (5921 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 (5096 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 (2268 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 (5909 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 (3157 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 (5905 days) | S4 | 5.0.46, 5.0.54 | Any | Any | create table ... engine=merge should warn user when non-MyISAM tables are used |
34889 | 2008-02-27 14:27 | 2018-09-25 21:47 | MySQL Server: Tests | Closed (5859 days) | S7 | 5.0 | Any | Any | mysql_client_test::test_mysql_insert_id test fails sporadically |
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 |
35005 | 2008-03-03 16:20 | 2011-02-16 23:43 | MySQL Server: Security: Privileges | Can't repeat (5039 days) | S3 | 5.1 | Any | Any | Possible security flaw around trigger privileges |
35089 | 2008-03-05 19:55 | 2008-03-05 21:48 | MySQL Server | Not a Bug (5895 days) | S3 | 5.1.22-rc-community-log | Any | Any | LAST_INSERT_ID returns 0 on using INSERT... ON DUPLICATE KEY UPDATE ... |
35135 | 2008-03-07 6:48 | 2008-03-10 17:13 | MySQL Server: Documentation | Closed (5890 days) | S3 | 5.1+ | Any | Any | 5.1 document incorrect about binlog in trigger generated AUTO_INCREMENT |
35273 | 2008-03-13 16:02 | 2008-03-17 22:11 | MySQL Server: Maria storage engine | Closed (5883 days) | S3 | 5.1-maria | Any | Any | Corrupted table if using GIS index |
35334 | 2008-03-17 12:48 | 2022-09-04 20:45 | MySQL Server: Optimizer | Verified (5847 days) | S4 | 5.0 all | Any | Any | For MyISAM select * from table order by key_field does not use index |
35376 | 2008-03-18 7:31 | 2008-05-08 16:34 | MySQL Server: DML | Not a Bug (5831 days) | S3 | 5.1.22 | Any | Any | Value of insert_id automatically resets to 0 after inserting 1st row |
35653 | 2008-03-28 15:46 | 2013-01-22 22:56 | Connector / J | Closed (4111 days) | S2 | Current | Any | Any | executeQuery() in Statement.java let "TRUNCATE" queries being executed |
35714 | 2008-03-31 18:57 | 2022-09-04 20:45 | MySQL Server | Duplicate (5812 days) | S3 | 6.0 | Any (64bit) | Any | several rpl tests fail with --thread-handling=pool-of-threads |
35803 | 2008-04-03 14:36 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (5830 days) | S1 | 6.0 | Any | Any | subselect_notembedded crashes the server |
35821 | 2008-04-04 3:54 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5526 days) | S4 | 5.0.56 | Any | Any | Unexpected deadlock between concurrent INSERTs when unique key violation may occ |
35942 | 2008-04-09 15:59 | 2024-02-04 20:45 | MySQL Proxy | Verified (5617 days) | S2 | 0.6.1 , rev 511 | Any (SunOS 5.11 NexentaOS_20080131 i86pc i386 i86pc Solaris - Linux) | Any | MySQL-Proxy with rw-splitting.lua writes to slave because of SQL_CALC_FOUND_ROWS |
36002 | 2008-04-11 18:21 | 2012-01-27 4:14 | MySQL Server: Prepared statements | Closed (4472 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 (5839 days) | S2 | 5.1.23, 6.0.4 | Any | Any | Row-based replication drops events when using multiple tables |
36118 | 2008-04-16 8:39 | 2008-05-09 15:31 | MySQL Server: Replication | Closed (5830 days) | S2 | 5.1, 6.0 | Any | Any | RBR used for mysql database tables |
36172 | 2008-04-17 8:12 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5060 days) | S1 | 5.1.25+innodb_plugin-1.0.0-5.1 | Any | Any | insert into compressed innodb table crashes |
1495 | 2003-10-07 4:35 | 2003-10-14 6:15 | MySQL Server | Closed (7499 days) | S1 | 5.0 | Any (All) | Any | SIGSEGV in Item_bool_func2::fix_length_and_dec() |
43685 | 2009-03-17 2:41 | 2011-02-16 23:43 | MySQL Server: Locking | Closed (5163 days) | S3 | 5.0.78,5.1.32 | Any | Any | Lock table affects other non-related tables |
73136 | 2014-06-27 16:34 | 2015-05-20 15:16 | MySQL Server: Optimizer | Verified (3587 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(*) |
51017 | 2010-02-09 9:07 | 2010-02-13 19:12 | MySQL Server: Optimizer | Not a Bug (5185 days) | S3 | 6.0-codebase-bugfixing | Any | Any | Batched key access gives wrong results for SELECT with LEFT JOIN, GROUP BY |
57024 | 2010-09-26 4:44 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (4957 days) | S2 | 5.1 | Any | Any | Serious performance issue with an outer join |
333 | 2003-04-26 13:49 | 2003-08-22 7:08 | MySQL Server: Replication | Won't fix (7552 days) | S2 | 4.0 | Any (all) | Any | 3 binlogging bugs when doing INSERT with mixed InnoDB / MyISAM |
55453 | 2010-07-21 18:01 | 2011-02-16 23:44 | MySQL Enterprise Monitor: Agent | Closed (5000 days) | S1 | 2.2.2.1729 | Any | Any | Agent resends the same example query over and over every 2 minutes |
29249 | 2007-06-20 21:01 | 2013-03-03 20:45 | MySQL Server: Archive storage engine | Duplicate (6147 days) | S1 | 5.0.44 | Any | Any | thread hang with concurrent insert/optimize of archive tables |
53587 | 2010-05-11 22:57 | 2016-08-17 14:51 | MySQL Server: Documentation | Closed (2808 days) | S3 | 5.0,5.1 | Any | Any | what are the semantics of the rand function |
56184 | 2010-08-23 5:27 | 2011-05-13 10:26 | MySQL Server: Replication | Closed (4731 days) | S3 | 5.1, 5.5 | Any | Any | Rolled back transaction without non-trasactional table updated was binlogged |
85821 | 2017-04-06 7:11 | 2020-12-01 11:51 | MySQL Server: Optimizer | Closed (1241 days) | S3 | 8.0.2-DEBUG | Any | Any | partial update on views does not work |
9922 | 2005-04-15 5:10 | 2005-04-16 16:56 | MySQL Server | Closed (6949 days) | S2 | 4.0.24 | Any (Any) | Any | INSERT SELECT with UNIONs allows illegal concurrent INSERTs |
40505 | 2008-11-04 16:09 | 2011-02-16 23:43 | MySQL Server: General | Verified (5634 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 (2521 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 (227 days) | S3 | all | Any | Any | Typo spotted |
5 | 2002-10-29 19:48 | 2002-12-02 12:48 | MySQL Server | Closed (7815 days) | S3 | 3.23.53 | Any (all) | Any | left join bug |
29571 | 2007-07-05 12:06 | 2007-08-03 15:39 | MySQL Server: Replication | Closed (6110 days) | S3 | 4.1,5.0 | Any | Any | INSERT DELAYED IGNORE written to binary log on the master but on the slave |
32039 | 2007-11-02 1:12 | 2007-11-02 6:21 | Tests: Cluster | Not a Bug (6019 days) | S3 | mysql-5.1 | Any | Any | rpl_ndb_auto_inc should list error 1062 instead or 1022 |
37741 | 2008-06-30 14:12 | 2008-06-30 14:41 | MySQL Server: Tests | Duplicate (5778 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 (5728 days) | S4 | Any | Any | SQL addition - ORLIMIT | |
38858 | 2008-08-18 13:56 | 2022-12-04 20:45 | MySQL Server: Parser | Verified (5728 days) | S4 | Any | Any | ORDERGROUP BY construct | |
38859 | 2008-08-18 14:17 | 2022-12-04 20:45 | MySQL Server: Parser | Verified (5728 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 (3948 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 (4878 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 (3811 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 (930 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 (941 days) | S5 | 8.0 | Any | Any | Added page szie judgment logic like btr_cur_optimistic_insert in btr_insert_into |
35140 | 2008-03-07 10:11 | 2008-05-21 14:24 | MySQL Server: Falcon storage engine | Closed (5818 days) | S3 | 6.0.4 | Any | Any | Suspected Falcon deadlock in Table::insert |
36982 | 2008-05-26 15:20 | 2008-06-23 11:04 | Tests: Replication | Can't repeat (5785 days) | S3 | 6.0-engines-merge | Any | Any | rpl_found_rows.test fails in pushbuild |
42209 | 2009-01-20 8:30 | 2012-08-31 15:44 | MySQL Server: Optimizer | Closed (4255 days) | S3 | 5.1.30 | Any | Any | Rollback affects the index usage for DELETE statement with FORCE INDEX. |
43457 | 2009-03-06 14:24 | 2018-04-11 13:22 | MySQL Server: Replication | Not a Bug (2206 days) | S3 | 5.1, 6.0 | Any | Any | replicate-ignore-db behaves differently with different binlog formats |
57892 | 2010-11-01 12:02 | 2017-05-21 20:45 | MySQL Server: Replication | Duplicate (4915 days) | S1 | 5.6.99 (bzr_mysql-next-mr-wl2540) | Any | Any | Crash in my_b_write_quoted (log_event.cc) from mysqlbinlog with checksum |
64888 | 2012-04-06 14:43 | 2012-04-09 11:03 | MySQL Server: MyISAM storage engine | Verified (4402 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 (3727 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 (3899 days) | S3 | 5.6.12 | Any | Any | deadlock detected on concurrent insert |
71638 | 2014-02-09 14:41 | 2016-05-13 19:29 | MySQL Server: Documentation | Closed (2904 days) | S3 | 5.6 | Any | Any | Manual does NOT explain "insert intention" lock mode properly |
82774 | 2016-08-29 3:13 | 2017-04-13 22:01 | MySQL Server: Locking | Not a Bug (2569 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 (1097 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 (1022 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 (447 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 |
110412 | 2023-03-17 12:42 | 2023-03-20 5:45 | MySQL Server: InnoDB storage engine | Verified (402 days) | S3 | 8.0.28 | Any | Any | SMO(split) can result in unexpected sparse B-tree pages. |
112451 | 2023-09-25 6:35 | 2023-09-25 7:37 | MySQL Server: Optimizer | Verified (213 days) | S3 | 8.0,8.1 | Any | Any | Incorrect result if there are non-deterministic expressions in in-subquery |
189 | 2003-03-25 4:48 | 2003-03-26 12:35 | MySQL Server | Closed (7701 days) | S3 | 4.0.12 / 4.0.13 bk tree | Any (ALL) | Any | Wrong host name/port displayed for DELAYED thread |
11472 | 2005-06-21 0:08 | 2024-04-09 10:03 | MySQL Server: DML | Verified (5670 days) | S2 | 5.0.8/5.5/5.6/5.7 | Any | Any | Triggers not executed following foreign key updates/deletes |
13392 | 2005-09-21 22:47 | 2005-10-31 20:13 | MySQL Server: Optimizer | Closed (6751 days) | S2 | 5.0.12-beta-nt-log | Any (All) | Any | values() fails with 'ambiguous' or returns NULL with ON DUPLICATE and SELECT |
29253 | 2007-06-20 22:01 | 2007-07-23 1:06 | MySQL Server: CSV | Closed (6121 days) | S1 | 5.1.20 | Any | Any | csv table reportedly marked as crashed |
29680 | 2007-07-10 6:38 | 2007-08-07 20:00 | MySQL Server: Documentation | Closed (6106 days) | S3 | 5.0.46-BK, 5.0.41 | Any | Any | index_merge is used instead of (faster!) range |
30788 | 2007-09-04 10:33 | 2008-01-23 18:25 | MySQL Server | Closed (5937 days) | S1 | 5.0.45, 4.1, 5.1 BK | Any | Any | Inconsistent retrieval of char/varchar |
32097 | 2007-11-05 8:40 | 2007-11-05 18:37 | MySQL Server: Documentation | Closed (6016 days) | S3 | 5.1 | Any | Any | Term "statement" used wrongly |
41984 | 2009-01-08 22:28 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Can't repeat (5505 days) | S3 | 5.1.22rc 5.1.30 GA | Any (Linux, Windows) | Any | inserts with auto-increment fails |
47753 | 2009-09-30 20:24 | 2022-12-04 20:45 | MySQL Server: Partitions | Duplicate (5300 days) | S3 | 5.5 WL#3352 | Any | Any | Partition by LIST COLUMN_LIST appears to require an order for value list items |
63280 | 2011-11-16 7:26 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Verified (4544 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 (4433 days) | S4 | Any | Any | Add support of ANSI SQL syntax : INSERT INTO <table name> DEFAULT VALUES | |
68083 | 2013-01-14 14:41 | 2013-01-14 18:18 | MySQL Server | Not a Bug (4119 days) | S2 | 5.1.61 | Any | Any | Inserts that cannot progress that wait for a LOCK, innodb implicity kill them |
73190 | 2014-07-03 21:23 | 2017-04-17 13:36 | MySQL Server: mysqldump Command-line Client | Verified (3205 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 (2663 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 (2352 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 (2451 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 (1442 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 (44 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 (6566 days) | S2 | 4.1.19 | Any (any) | Any | mysqldump with --delayed-insert and InnoDB |
40819 | 2008-11-18 12:22 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5495 days) | S3 | 5.0.67 - likely any | Any | Any | INSERT DELAYED documentation request |
41332 | 2008-12-09 16:01 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Duplicate (5582 days) | S1 | Cluster 6.3.20 | Any | Any | Insert into partitioned "ndbcluster" table causes server crash |
41424 | 2008-12-12 10:52 | 2018-09-25 21:50 | Tests: Replication | Can't repeat (5025 days) | S7 | 6.0-bugteam | Any | Any | rpl_ignore_table fails, "could not execute write_rows event" |
46324 | 2009-07-21 15:42 | 2010-05-26 18:01 | MySQL Server: Falcon storage engine | Unsupported (5083 days) | S1 | 6.0.12-bzr | Any | Any | Crash during repeated INSERT ... SELECT if falcon debug mask includes 4 |
47052 | 2009-09-01 19:22 | 2020-05-03 20:45 | MySQL Server: Optimizer | Duplicate (5253 days) | S3 | 6.0 | Any | Any | wrong result, Subquery with VIEW containing BETWEEN |
51838 | 2010-03-08 17:29 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Won't fix (5151 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 (5103 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 (4273 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 (3713 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 (3692 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 (3297 days) | S3 | 5.7.7 | Any | Any | myisam_views-big fails |
77183 | 2015-05-28 14:39 | 2020-04-18 0:32 | Connector / J | Closed (1468 days) | S2 | 5.1.35 | Any | Any | INSERT..VALUE..lead to invalidation of batch insert |
91026 | 2018-05-25 12:04 | 2018-06-18 12:06 | MySQL Server: DML | Not a Bug (2138 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 (1820 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 (1598 days) | S3 | 5.6.28, 5.6.45, 5.7.27 | Any | Any | Event does't record slow insert in slow log |
106009 | 2021-12-30 11:42 | 2021-12-31 14:57 | MySQL Server: DDL | Not a Bug (846 days) | S3 | 8.0.27 | Any | Any | After INSERT ... SELECT, value of AUTO_INCREMENT becomes multiple of 8 |
114759 | 2024-04-24 8:52 | 2024-04-25 1:43 | MySQL Cluster: Cluster (NDB) storage engine | Duplicate | S2 | 8.0.35-cluster MySQL Cluster Community S | Any (20.04) | Any | hang bug in mysql NDB cluster |
2188 | 2003-12-22 8:22 | 2004-01-20 11:04 | MySQL Server | Closed (7401 days) | S2 | 4.1, 5.0 | Any (all) | Any | Query with select in field list doesn't work with prepared statements |
6460 | 2004-11-05 12:09 | 2004-11-09 3:04 | MySQL Server | Closed (7107 days) | S2 | 4.1.7 | Any (all) | Any | LEFT JOIN with multiple LIKE in WHERE produces wrong result |
13710 | 2005-10-03 11:41 | 2005-10-04 15:05 | MySQL Server: InnoDB storage engine | Closed (6778 days) | S1 | 5.0.14-pre | Any (All) | Any | Test case 'innodb' fails on checksum tests |
14056 | 2005-10-16 9:08 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5060 days) | S2 | 4.1, 5.0 | Any (All) | Any | Column prefix index on UTF-8 primary key column causes 'Can't find record..' |
20543 | 2006-06-19 17:27 | 2006-08-18 12:34 | MySQL Server: Views | Closed (6460 days) | S1 | 5.0 | Any | Any | select on information_schema strange warnings, view, different schemas/users |
22436 | 2006-09-18 9:55 | 2006-11-06 14:46 | MySQL Server: Tests | Closed (6380 days) | S3 | 5.0.25 | Any (All) | Any | Four tests require "innodb" to be configured, fail in "classic" build |
22820 | 2006-09-29 11:49 | 2022-03-06 20:45 | MySQL Server: MyISAM storage engine | No Feedback (5832 days) | S3 | 5.1.12 | Any (*) | Any | INSERT DELAYED does not behave like normal insert |
25025 | 2006-12-13 3:58 | 2007-05-16 19:53 | Connector / J | Closed (6189 days) | S2 | 5.0.x, 3.1.x | Any (any) | Any | Connector/J getRewriteBatchedStatements() should be more forgiving of comments |
27006 | 2007-03-09 16:19 | 2007-03-20 16:34 | MySQL Server: Stored Routines | Closed (6246 days) | S1 | 5.0.36 | Any (All) | Any | AFTER UPDATE triggers not fired with INSERT ... ON DUPLICATE KEY UPDATE |
27954 | 2007-04-19 14:23 | 2007-05-10 18:07 | MySQL Server: General | Closed (6195 days) | S1 | 5.0.38 | Any | Any | INSERT ... ON DUPLICATE KEY UPDATE fails with large multi-insert |
28650 | 2007-05-24 11:09 | 2007-06-24 12:29 | MySQL Server: Stored Routines | No Feedback (6150 days) | S3 | 5.0 | Any | Any | problem facing with triggers |
30861 | 2007-09-06 12:51 | 2007-09-06 12:53 | MySQL Server | Open (6076 days) | S4 | any | Any | Any | an interesting and useful clause |
31305 | 2007-09-30 16:08 | 2007-11-26 19:00 | MySQL Server: MyISAM storage engine | Closed (5995 days) | S1 | 4.0.26, 4.1.21, 5.1.23, 5.0.48, 6.0.4 | Any | Any | myisam tables crash when they are near capacity |
33534 | 2007-12-27 13:12 | 2008-02-20 20:57 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5909 days) | S2 | MySQL Cluster CGE 6.3 | Any | Any | Bad performance of INSERT's in auto_incremented tables |
36545 | 2008-05-06 18:52 | 2008-06-11 18:54 | MySQL Server: Falcon storage engine | Closed (5797 days) | S1 | 6.0.5 | Any | Any | Falcon assertion in Table::insert, ASSERT(ret) fails. |
39358 | 2008-09-10 5:38 | 2008-10-04 6:53 | MySQL Server: Locking | Not a Bug (5682 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 (5334 days) | S3 | 5.1,5.4 | Any | Any | Wrong warning about crashed table, CREATE TABLE IF NOT EXISTS AS SELECT |
47752 | 2009-09-30 17:56 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5278 days) | S3 | 5.5 WL#3352 | Any | Any | Partition by LIST COLUMN_LIST only recognizing last defined partition |
52473 | 2010-03-30 12:51 | 2021-05-02 20:45 | MySQL Cluster: Replication | Verified (5115 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 (5089 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 (4779 days) | S4 | any | Any | Any | insert and query cache |
61213 | 2011-05-18 9:49 | 2014-06-10 7:08 | Connector / J | Closed (3626 days) | S2 | 5.1.16 | Any | Any | ON DUPLICATE KEY UPDATE breaks generated key list when extended INSERT is used |
65581 | 2012-06-11 10:07 | 2012-06-18 6:37 | MySQL Server: InnoDB storage engine | Verified (4336 days) | S3 | 5.5 | Any | Any | INSERT statement can be delayed by SELECT ... LOCK. |
68332 | 2013-02-10 16:34 | 2013-02-11 21:32 | MySQL Server: General | Can't repeat (4091 days) | S2 | 5.5.30,5.6.10 | Any | Any | Value for mysql_affected_rows() became 1 for ON DUPLICATE KEY after 5.5.15 |
69679 | 2013-07-05 17:23 | 2014-06-19 5:57 | MySQL Server: Charsets | Not a Bug (3598 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 (3396 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 (1620 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 (3314 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 |
76563 | 2015-04-01 15:26 | 2017-06-01 14:20 | MySQL Server: Documentation | Closed (2520 days) | S3 | 5.5, 5.6, 5.7 | Any | Any | Manual does NOT explain when exactly AUTO-INC lock is set for "bulk inserts" |
78508 | 2015-09-22 3:20 | 2015-09-22 12:19 | MySQL Server: DML | Not a Bug (3138 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 (3060 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 (2794 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 (2593 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 (2316 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 (2264 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 (1380 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 (1248 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 (1235 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 (126 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 (1115 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 (527 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 (500 days) | S2 | 5.7.40 | Any | Any | The datas of master and standby are inconsistent for Spatial Data Formats |
111703 | 2023-07-10 6:40 | 2023-07-15 1:58 | MySQL Server: Documentation | Not a Bug (285 days) | S3 | 8.0.33, 5.7.42 | Any | Any | INSERT ON DUPLICATE KEY locks INSERT if table have many PRIMARY and UNIQUE key |
113098 | 2023-11-16 2:55 | 2023-11-24 7:00 | Connector / J | Duplicate (160 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 (127 days) | S3 | 8.0 | Any | Any | Incorrect result |
114237 | 2024-03-06 6:57 | 2024-03-06 8:30 | MySQL Server: Optimizer | Verified (50 days) | S5 | 8.2.0, 8.3.0 | Any | Any | Unexpected Cardinality by Index |
114446 | 2024-03-21 14:30 | 2024-04-22 10:14 | MySQL Server: InnoDB storage engine | Not a Bug (35 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 (7635 days) | S4 | 4.X | Any (ALL) | Any | INSERT as SELECT from the same table must be unlocked |
1331 | 2003-09-18 5:39 | 2003-10-04 6:44 | MySQL Server: Replication | Closed (7509 days) | S2 | 4.1 | Any (all) | Any | Unexistent user variable is not replicated |
2491 | 2004-01-23 5:54 | 2004-03-11 10:27 | MySQL Server: Replication | Closed (7350 days) | S2 | 4.0 | Any (all) | Any | INSERT DELAYED causes binary log unusable by mysqlbinlog (replication is ok) |
3275 | 2004-03-23 14:14 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5559 days) | S4 | Any | Any | INSERT INTO table1 AS alias1 - to easier use of LOCK TABLES table1 AS alias1 | |
8475 | 2005-02-12 14:19 | 2005-03-08 0:35 | MySQL Server | Closed (6988 days) | S3 | 4.1 | Any (all) | Any | If multi-query: query does not get into slow query log if it's not last |
10396 | 2005-05-05 19:03 | 2011-02-16 23:43 | MySQL Server: Command-line Clients | Verified (6891 days) | S4 | 4.1 | Any (any) | Any | UPDATE... [ON NONE FOUND INSERT] |
25194 | 2006-12-20 3:55 | 2013-03-03 20:45 | MySQL Server: Federated storage engine | Verified (5012 days) | S4 | 5.1, 5.5 | Any (*) | Any | please implement bulk inserts for federated table |
27650 | 2007-04-04 13:24 | 2007-05-01 17:45 | MySQL Server | Closed (6204 days) | S1 | 5.0.38, 5.x | Any | Any | ON DUPLICATE KEY UPDATE fails when setting UNIQUE values with multi row inserts |
28249 | 2007-05-04 16:01 | 2007-07-23 20:23 | MySQL Server | Closed (6121 days) | S2 | 5.0.42/5,1 | Any | Any | Query Cache returns wrong result with concurrent insert / certain lock |
28412 | 2007-05-14 11:35 | 2011-02-16 23:43 | MySQL Server: General | Verified (6191 days) | S4 | 5.0.41 | Any | Any | insert_id in OK Packet not working with multiple rows INSERT |
28505 | 2007-05-18 0:19 | 2007-06-19 0:56 | MySQL Server | Closed (6155 days) | S2 | 3.1.10, and 5.0.6 | Any | Any | Update count for an INSERT DUPLICATE KEY not correct when CLIENT_FOUND_ROWS set |
28829 | 2007-06-01 10:01 | 2012-05-18 20:19 | MySQL Server: Replication | Duplicate (6161 days) | S2 | 4.1.21,5.0.44 | Any | Any | replication breaks due to binlogs events written in wrong order |
34447 | 2008-02-10 14:46 | 2012-05-18 20:19 | MySQL Server: Replication | Duplicate (5881 days) | S1 | 5.1-BK | Any | Any | replication failure on DELETE after INSERT on an unrelated table |
34472 | 2008-02-11 20:51 | 2008-02-13 16:44 | MySQL Server: General | Can't repeat (5916 days) | S3 | 6.0.5 | Any | Any | Buffer overrun condition in strmake() |
34627 | 2008-02-17 16:21 | 2008-05-21 14:10 | MySQL Server: Falcon storage engine | Closed (5818 days) | S3 | 6.0.4 | Any | Any | Falcon potential deadlock in Bdb::addRef |
35224 | 2008-03-11 16:07 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Closed (5164 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 (3508 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 (5837 days) | S3 | Any | Any | Max_delayed_thread does not make delayed insert threads as normal insert | |
36534 | 2008-05-06 13:54 | 2018-09-09 20:45 | MySQL Server: DML | Verified | S4 | all | Any | Any | sql_mode traditional restrictions affect data manipulation queries only |
36898 | 2008-05-22 22:24 | 2008-05-25 10:04 | MySQL Server: DML | Not a Bug (5814 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 (5685 days) | S2 | 5.1+ | Any | Any | funcs_1: Several tests crash when used with embedded server |
39017 | 2008-08-25 17:34 | 2015-06-28 20:45 | MySQL Server: Backup | Duplicate (5721 days) | S3 | 6.0.7 | Any | Any | backup_default test fails in pushbuild |
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 |
40025 | 2008-10-14 16:06 | 2008-11-05 21:11 | MySQL Server: Maria storage engine | Can't repeat (5650 days) | S1 | 6.0-bzr | Any | Any | Maria deadlock in translog_buffer_lock, _ma_unlock_key_del, wait_for_update_bin |
42491 | 2009-01-30 19:44 | 2011-02-16 23:43 | MySQL Server: Storage Engines | Duplicate (5564 days) | S2 | 5.1.30 | Any | Any | INSERT on temporary table may pass incorrect lock type to storage engine |
43344 | 2009-03-03 22:14 | 2010-05-26 17:59 | MySQL Server: Falcon storage engine | Unsupported (5083 days) | S2 | 6.0.10-alpa | Any | Any | falcon_recovery assert "dup->state == recDeleted" in Table::checkUniqueRecordVer |
45642 | 2009-06-21 20:35 | 2011-02-16 23:44 | MySQL Workbench | Closed (5418 days) | S2 | 5.1.14RC | Any | Any | Generated INSERT statements don't have database name |
46179 | 2009-07-14 18:07 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (1942 days) | S2 | 5.6, 5.7, 8.0 | Any | Any | set new.colname = default(colname) in trigger elicits a crazy error message |
49186 | 2009-11-29 13:52 | 2011-02-16 23:44 | MySQL Server: Replication | Can't repeat (5246 days) | S3 | 5.1.41, 5.5.0 | Any | Any | Concurrent insert/select causes slave abort if select is under read committed |
49625 | 2009-12-11 15:28 | 2009-12-14 18:03 | MySQL Server: Stored Routines | Not a Bug (5246 days) | S1 | 5.0.51 | Any (Unknown host OS) | Any | Stored procedure that calls UUID() calls resuting Insert Statement multipe times |
51193 | 2010-02-15 16:45 | 2015-02-04 22:35 | MySQL Server: Documentation | Closed (3368 days) | S3 | 5.1 | Any | Any | Update 1.8.5.2 Transactions and Atomic Operations in the reference manual |
51509 | 2010-02-25 15:09 | 2011-12-16 7:55 | Connector / J | Closed (4514 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 (5056 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 (4977 days) | S2 | 5.1.13 | Any | Any | JDBC - insert error - field doesn't have a default value - NOT NULL field |
57623 | 2010-10-21 10:43 | 2011-03-02 3:16 | MySQL Server: Optimizer | Closed (4803 days) | S1 | mysql-next-mr-opt-backporting | Any | Any | subquery within before insert trigger causes crash (semijoin=on) |
61468 | 2011-06-09 21:54 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Verified (4703 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 (4648 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 (4579 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 (4523 days) | S3 | 5.5.16 | Any | Any | cannot perform a precise calculation with decimal data |
63128 | 2011-11-07 9:40 | 2014-06-26 22:27 | MySQL Server: Documentation | Closed (3591 days) | S3 | 5.1 5.5 | Any | Any | explanation of the behavior of innodb_autoinc_lock_mode = 1 with INSERT IGNORE |
66301 | 2012-08-10 8:46 | 2013-04-22 20:28 | MySQL Server: InnoDB storage engine | Closed (4021 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 (4080 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 (3999 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 (3851 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 (3583 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 (3703 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 (3661 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 (3165 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 (3104 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 (3068 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 (2899 days) | S3 | 5.5.49-c11 | Any | Any | delete then insert multiple values produces data in wrong order. |
85266 | 2017-03-02 6:15 | 2018-10-21 20:45 | Connector / ODBC | No Feedback (2565 days) | S3 | 5.03.07.00 | Any | Any | Array Insert is not working as expected. |
86019 | 2017-04-20 11:44 | 2017-06-14 13:35 | MySQL Server: Documentation | Closed (2507 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 (2205 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 (2206 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 (1891 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 (1844 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 (1736 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 (1329 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 (745 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 (1149 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 (1114 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 (1063 days) | S4 | All, 8.0 | Any | Any | Suggest to add materialized view log for innodb tables |
20887 | 2006-07-06 11:44 | 2015-03-15 20:45 | MySQL Server: Replication | No Feedback (6395 days) | S3 | 4.1 and up | Any (ALL) | Any | INSERT DELAYED is not logged write-behind to binary log |
20901 | 2006-07-07 12:26 | 2007-12-21 17:04 | MySQL Server: General | Closed (5970 days) | S2 | 4.1.21-BK, 5.0.23-BK, 5.1.12-BK | Any (any) | Any | CREATE privilege is enough to insert into a table |
21113 | 2006-07-18 12:48 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5058 days) | S3 | 5.0.19 | Any (All) | Any | Duplicate printout in SHOW INNODB STATUS |
21293 | 2006-07-26 10:19 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5058 days) | S4 | 4.1,5.0-bk,5.1-bk | Any | Any | Deadlock detection prefers to kill long running FOR UPDATE queries |
21774 | 2006-08-22 8:46 | 2006-09-13 17:31 | MySQL Server | Closed (6434 days) | S2 | 5.0.24 | Any (*) | Any | Column count doesn't match value count at row x |
22168 | 2006-09-09 10:11 | 2007-12-03 14:27 | MySQL Server: Falcon storage engine | Closed (5988 days) | S3 | 5.2 | Any (all) | Any | Inserting bad early dates |
22175 | 2006-09-09 10:27 | 2010-05-26 17:59 | MySQL Server: Falcon storage engine | Unsupported (5083 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 (6420 days) | S4 | 1.2.1 beta | Any (All) | Any | MySQL Query Browser Should Have An Export To Sql Option |
25330 | 2006-12-29 12:17 | 2007-01-02 9:48 | MySQL Cluster: Cluster (NDB) storage engine | Won't fix (6323 days) | S3 | 5.1, 5.0?, 4.1? | Any | Any | ndb: table create and insert during node restart causes restart node crash |
25507 | 2007-01-09 22:46 | 2011-02-16 23:43 | MySQL Server: Replication | Closed (5057 days) | S2 | 4.1-bk,5.0.34 | Any (*) | Any | multi-row insert delayed + auto increment causes duplicate key entries on slave |
25815 | 2007-01-24 10:24 | 2007-03-15 4:29 | MySQL Server | Closed (6251 days) | S3 | 5.0.32 | Any (any) | Any | Data truncated for column TEXT |
26464 | 2007-02-17 18:25 | 2007-03-15 2:54 | MySQL Server: Merge storage engine | Closed (6251 days) | S2 | 4.1.21, 5.0.36BK, 5.1.16BK, 5.2.4BK | Any (*) | Any | insert delayed + update + merge = corruption |
26590 | 2007-02-23 11:30 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5063 days) | S2 | 5.0, 5.1, etc. | Any | Any | MySQL does not allow more than 1023 open transactions |
27159 | 2007-03-15 1:02 | 2011-02-16 23:43 | MySQL Server: Security: Privileges | Verified (6211 days) | S4 | any | Any (any) | Any | restrict permissions for table maintenance statements |
27205 | 2007-03-16 10:47 | 2007-04-30 8:45 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6205 days) | S3 | 5.1 | Any | Any | Occasional 899 if delete+insert during LCP |
27350 | 2007-03-21 17:57 | 2012-05-18 20:19 | MySQL Server: Falcon storage engine | No Feedback (6191 days) | S2 | 5.2 | Any | Any | test-insert, Unexpected error; "Record has changed since last read in table" |
27387 | 2007-03-23 4:08 | 2007-03-30 17:06 | MySQL Server: General | Not a Bug (6236 days) | S2 | All 5.0 and 5.1, 4.1, 5.2 | Any (All) | Any | Error checking is incorrect in INSERT ... ON DUPLICATE KEY UPDATE |
27502 | 2007-03-28 15:44 | 2012-09-13 8:20 | Connector / NET | Can't repeat (6222 days) | S2 | 5.0.23 | Any (unix) | Any | UTF characters inserts into tables as "???" (c# + connector/net) |
27809 | 2007-04-13 13:03 | 2008-02-22 18:42 | MySQL Server: Merge storage engine | Closed (5907 days) | S3 | 5.0.40BK | Any | Any | documentation says REPLACE not working with MERGE, but it does |
27838 | 2007-04-15 23:01 | 2007-04-16 4:33 | MySQL Server: Data Types | Duplicate (6219 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 (6218 days) | S4 | 5.0 | Any | Any | MySQL doesn't accept ISO8601 date |
28000 | 2007-04-21 14:59 | 2007-05-17 14:24 | MySQL Server | Closed (6188 days) | S3 | 5.0.37,5.1, 6.0-falcon-bk | Any | Any | MySQL hangs when using INSERT IGNORE ... ON DUPLICATE KEY |
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 |
28150 | 2007-04-28 21:14 | 2007-04-30 16:42 | MySQL Server | Closed (6205 days) | S3 | 5.1.15-beta | Any | Any | INSERT SELECT accepts invalid SELECT statement |
28280 | 2007-05-07 13:47 | 2007-05-29 13:29 | MySQL Server: Stored Routines | Duplicate (6176 days) | S1 | 5.0.42BK, 5.1.18BK | Any | Any | insert delayed on a table containing trigger leads to server crash |
28526 | 2007-05-18 17:15 | 2012-05-18 20:19 | MySQL Server | Duplicate (6174 days) | S2 | 5.0.40, 5.0.41, 5.0.42-20070517 | Any | Any | Correlated subquery with GROUP BY on outer query returns no results in 5.0.40+ |
28719 | 2007-05-28 9:18 | 2007-06-11 20:20 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6163 days) | S3 | 5.1 | Any | Any | multi pk update ignore corrupts data |
28770 | 2007-05-30 10:02 | 2007-06-11 20:15 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6163 days) | S3 | 5.0 | Any | Any | file already opened error when corrupt schema file |
28842 | 2007-06-01 17:33 | 2007-06-18 15:08 | MySQL Server: Errors | Closed (6156 days) | S2 | 5.1-bk | Any | Any | Different 'duplicate key' error code between 5.0 and 5.1 |
28843 | 2007-06-01 18:07 | 2016-02-25 12:24 | MySQL Server: Documentation | Not a Bug (6145 days) | S3 | 5.0.41 | Any | Any | Incorrect listing of supported operations in Prepared Statements |
28878 | 2007-06-04 15:35 | 2007-10-22 22:03 | MySQL Server | Closed (6030 days) | S1 | 5.0.42, 4.1.23 | Any | Any | InnoDB tables with UTF8 character set and indexes cause wrong result for DML |
28895 | 2007-06-05 12:52 | 2018-09-25 21:45 | MySQL Server: Tests | Closed (6156 days) | S7 | 5.0, 5.1 | Any | Any | Test 'information_schema_db' fails on i5/OS 32 bit |
29019 | 2007-06-11 14:53 | 2007-07-07 19:01 | MySQL Server: Federated storage engine | Closed (6137 days) | S3 | 5.0/5.1 | Any | Any | REPLACE/INSERT IGNORE/UPDATE IGNORE doesn't work |
29042 | 2007-06-12 4:53 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5474 days) | S4 | any | Any | Any | Need documentation page on how InnoDB handles blobs |
29128 | 2007-06-15 5:28 | 2012-05-18 20:19 | MySQL Server: Charsets | Duplicate (5536 days) | S3 | 5.0, 5.1, 4.1 | Any | Any | LC_TIME_NAMES=fr_FR, assignment to non-UTF8 target fails with MONTHNAME() |
29178 | 2007-06-18 14:30 | 2011-02-16 23:43 | MySQL Server: Documentation | Won't fix (5005 days) | S3 | 5.0.44 | Any | Any | new memory chunks for heap tables depend on read_buffer_size |
29207 | 2007-06-19 12:16 | 2010-05-01 9:33 | MySQL Server: Archive storage engine | Closed (6137 days) | S1 | 5.0.44BK | Any | Any | archive table reported as corrupt by check table |
29413 | 2007-06-28 8:38 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5370 days) | S4 | 5.0.41 | Any | Any | Maximum performance of OLTP benchmark is not so scalable on multi-cpu |
29422 | 2007-06-28 14:49 | 2013-10-10 16:48 | MySQL Server: Command-line Clients | Closed (3850 days) | S3 | 5.1.20 | Any | Any | mysqlbinlog incorectly quotes user variable named <backtick> |
29431 | 2007-06-28 22:01 | 2007-07-27 5:09 | MySQL Server: Locking | Closed (6117 days) | S3 | 4.1,5.0.46,5.1 | Any | Any | killing an insert delayed thread causes crash |
29475 | 2007-07-02 4:28 | 2007-08-17 14:06 | MySQL Server: InnoDB storage engine | Won't fix (6096 days) | S5 | 5.0 | Any | Any | InnoDB COMPACT format addition reduces INSERT performance by 10 % |
29601 | 2007-07-06 17:33 | 2007-08-06 22:45 | MySQL Server: Falcon storage engine | Can't repeat (6107 days) | S1 | 6.0-bk | Any | Any | Falcon crashes during DBT2 initial load of tables |
29638 | 2007-07-09 6:41 | 2007-07-31 6:55 | MySQL Server | Not a Bug (6113 days) | S3 | 5.0, 5.1 | Any | Any | syntax error when inserting large hex strings with sufficient max_allowed_packet |
29717 | 2007-07-11 9:58 | 2007-08-03 16:59 | MySQL Server | Closed (6110 days) | S2 | 4.1, 5.0, 5.1 BK | Any (Linux) | Any | INSERT INTO SELECT inserts values even if SELECT statement itself returns empty |
29788 | 2007-07-13 14:35 | 2007-07-27 5:25 | MySQL Server: Backup | Closed (6117 days) | S2 | 5.0.45, 5.0 BK, 6.0.1-Falcon | Any | Any | MySQL 5.0.45 restore of dump fails |
29928 | 2007-07-20 11:01 | 2007-08-03 2:27 | MySQL Server: Backup | Closed (6110 days) | S3 | 4.1 bk, 5.0 bk, 5.1 bk | Any | Any | INSERT ... VALUES(connection_id(), ...) incorrect restores from mysqlbinlog out |
29929 | 2007-07-20 11:20 | 2007-08-02 3:50 | MySQL Server: Locking | Closed (6111 days) | S1 | 5.0, 5.1, 5.2 | Any | Any | LOCK TABLES does not pre-lock tables used in triggers of the locked tables |
30146 | 2007-07-31 12:59 | 2007-07-31 13:10 | MySQL Server: General | Closed (6113 days) | S3 | 5.0.42-enterprise-gpl | Any | Any | on duplicate key update does insert and update at the same time |
30200 | 2007-08-02 8:33 | 2007-08-03 2:18 | MySQL Server: Replication | Closed (6110 days) | S2 | Any | Any | mysqlbinlog.test: connection_id() not restored under ps-protocol | |
30244 | 2007-08-05 17:52 | 2007-09-14 15:10 | MySQL Server | Closed (6068 days) | S3 | 5.0.48 5.1.21, 4.1 | Any | Any | row_count/found_rows does not replicate well |
30256 | 2007-08-06 14:27 | 2007-08-06 15:15 | MySQL Server | Can't repeat (6107 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 (6023 days) | S3 | 1.1.10 Alpha | Any | Any | Columns not insert |
30286 | 2007-08-07 21:32 | 2007-11-05 2:52 | MySQL Server: MyISAM storage engine | Closed (6016 days) | S1 | 5.0.45, 5.0.48BK, 5.1.21 | Any | Any | spatial index cause corruption and server crash! |
30400 | 2007-08-14 8:03 | 2007-09-30 11:08 | MySQL Server: Stored Routines | No Feedback (6052 days) | S3 | Any | Any | cursor can not support recursion. | |
30661 | 2007-08-28 2:05 | 2007-08-28 16:06 | MySQL Enterprise Monitor: Server | Not a Bug (6085 days) | S2 | 1.2.0.7296 | Any | Any | Purging data can cause deadlocks |
30936 | 2007-09-10 15:19 | 2007-09-10 15:33 | MySQL Server: Errors | Not a Bug (6072 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 (6021 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 (5704 days) | S1 | 5.0, 5.1 | Any | Any | alter table x alter column y set default m does not pass default value to engine |
31257 | 2007-09-27 19:49 | 2007-11-06 8:47 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6015 days) | S3 | 4.1,5.0,5.1 | Any | Any | Node failure during LCP can lead to subsequent SR failure |
31352 | 2007-10-02 18:55 | 2007-10-20 16:17 | MySQL Server: Locking | Closed (6032 days) | S3 | 5.0.45 | Any (Linux, Windows) | Any | Write locking in stored functions with INSERT and SELECT statemenst |
31540 | 2007-10-11 16:01 | 2008-01-09 14:12 | MySQL Server: InnoDB storage engine | Closed (5951 days) | S1 | 5.1.22 | Any | Any | incorrect auto_increment values used for multi-row insert trigger |
31668 | 2007-10-17 15:48 | 2014-03-13 13:36 | MySQL Cluster: Disk Data | Won't fix (5846 days) | S3 | 5.1 | Any | Any | Dropping data file with empty table returns different result. |
31776 | 2007-10-23 8:19 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6028 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 |
31848 | 2007-10-25 13:20 | 2007-11-05 23:08 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6016 days) | S3 | 5.0.44 (NDB) + x | Any (gcc 4.2.1, x86 (32)) | Any | Test failure: Cluster has problems on insert with auto-increment |
32239 | 2007-11-09 16:23 | 2008-02-24 21:07 | MySQL Cluster: Replication | Closed (5905 days) | S3 | 5.1.22-ndb-6.3.2-telco-log | Any | Any | failed ndbrequire on slave server after intensive db activity |
32605 | 2007-11-21 22:56 | 2016-02-25 12:24 | MySQL Server: Documentation | Closed (5950 days) | S2 | 5.1.22 | Any | Any | Binary log and replication filtering options differ between RBR and SBR |
32606 | 2007-11-21 23:27 | 2007-11-29 12:58 | MySQL Server: Replication | Can't repeat (5992 days) | S2 | 5.0.45 | Any | Any | auto_increment on slave doesn`t work expected after null insert |
32676 | 2007-11-23 18:20 | 2008-01-11 16:09 | MySQL Server: Locking | Closed (5949 days) | S1 | 5.0.50, 5.1.23, 6.0.3 | Any | Any | insert delayed crash with wrong column and function specified .. |
32790 | 2007-11-27 20:17 | 2008-04-15 1:24 | MySQL Server: Stored Routines | Closed (5854 days) | S1 | 5.0, 5.1, 6.0 | Any | Any | crash in trigger.test with InnoDB for a table |
32839 | 2007-11-29 8:07 | 2007-12-04 14:47 | MySQL Server | Can't repeat (5987 days) | S3 | 5.1 BK | Any (Linux) | Any | Inconsistent behavior of LOW_PRIORITY in 5.0 and 5.1 |
32951 | 2007-12-04 8:04 | 2008-05-13 8:45 | MySQL Cluster: Cluster (NDB) storage engine | Can't repeat (5826 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 (5984 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 (3780 days) | S3 | 5.0.10 OSS Beta 2272 | Any | Any | Table/Inserts can not handle many INSERT statements |
33371 | 2007-12-19 16:39 | 2020-06-12 8:11 | MySQL Server | Not a Bug (5964 days) | S3 | 5.0.45 | Any | Any | default required for column in strict mode when value is specified |
33479 | 2007-12-22 12:51 | 2008-05-24 17:05 | MySQL Server: Partitions | Closed (5815 days) | S3 | 5.1+ | Any | Any | Insert on a partitioned auto_increment table gives ER_AUTOINC_READ_FAILED |
33495 | 2007-12-24 3:17 | 2007-12-24 4:29 | MySQL Server: DML | Duplicate (5967 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 (5083 days) | S3 | 6.0.4-p2 | Any | Any | Falcon selects on blobs above certain size are starved with default settings |
33661 | 2008-01-03 17:00 | 2008-03-16 11:21 | MySQL Server: Falcon storage engine | Closed (5884 days) | S3 | 6.0.4-p2 | Any | Any | Falcon insert into partition fails if starting auto_increment is set |
33736 | 2008-01-08 9:53 | 2008-01-14 6:51 | MySQL Server: General | Closed (5946 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 (5950 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 (5945 days) | S2 | 5.0.45 | Any (windows and linux) | Any | mysql hangs on certain querys in strict mode |
34033 | 2008-01-24 13:10 | 2008-02-20 21:56 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5909 days) | S4 | 5.1* | Any | Any | Error 899 can occur during high insert/delete-load |
34260 | 2008-02-03 12:59 | 2008-02-20 21:50 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5909 days) | S3 | 5.1 | Any | Any | Rare race condition between aborted insert + scan delete can cause node crash |
34267 | 2008-02-04 3:26 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (5922 days) | S2 | 5.1.23 | Any | Any | Server crash when droping a partition on a table with a trigger |
34319 | 2008-02-05 18:21 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5680 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 (5893 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 (4583 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 (5909 days) | S3 | 5.1 | Any | Any | auto increment gaps when using multi row insert with explicit values in InnoDB |
35205 | 2008-03-11 10:34 | 2008-03-15 12:52 | MySQL Workbench | Closed (5885 days) | S3 | 5.0.14b | Any | Any | Impossible to insert booleans |
35856 | 2008-04-05 23:31 | 2008-10-16 4:30 | MySQL Server: InnoDB storage engine | Duplicate (5670 days) | S3 | 5.0.45 | Any | Any | false unique constraint violation on multiple updates |
35869 | 2008-04-07 9:12 | 2020-05-03 20:45 | MySQL Server: Views | Verified (5862 days) | S2 | 5.0/5.1/6.0 | Any | Any | Defining a view over an aggregate view renders the view definition invalid |
35877 | 2008-04-07 12:11 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Closed (5278 days) | S3 | 5.1 | Any | Any | Update .. WHERE with function, constraint violation, crash |
35939 | 2008-04-09 14:49 | 2009-01-08 10:31 | MySQL Server: Falcon storage engine | Closed (5586 days) | S3 | 6.0-BK | Any | Any | Drift in Falcon row count reported by SHOW TABLE STATUS |
35990 | 2008-04-11 10:28 | 2011-02-16 23:43 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5305 days) | S3 | ndbcluster 6.2, 6.3, 7.0 | Any (any) | Any | Error code 1062 to 1296 (unknown) after setting sql_mode to STRICT_TRANS_TABLES |
36065 | 2008-04-14 17:08 | 2012-05-18 20:19 | MySQL Server: MyISAM storage engine | Duplicate (5838 days) | S3 | 6.0-falcon-team | Any | Any | MyISAM: duplicate key error on unique values |
36249 | 2008-04-22 10:50 | 2008-10-09 11:51 | MySQL Server: Falcon storage engine | Closed (5677 days) | S3 | 6.0 | Any | Any | Timing dependency bug in falcon_bug_22183 |
36413 | 2008-04-29 20:36 | 2011-02-16 23:43 | MySQL Workbench | Closed (5292 days) | S4 | 5.0.21 | Any | Any | Add row number to the INSERT Editor |
36430 | 2008-04-30 15:26 | 2008-08-29 1:34 | MySQL Server: Falcon storage engine | Can't repeat (5718 days) | S1 | 6.0.5-release | Any | Any | Falcon: server crashes during plain insert operation |
36508 | 2008-05-05 15:15 | 2008-05-06 16:45 | MySQL Server: DML | Not a Bug (5833 days) | S2 | 5.1.24 | Any | Any | inserting null value to not null column with default value explicitly defined |
36852 | 2008-05-21 13:28 | 2017-05-21 20:45 | MySQL Server: Replication | Verified (5818 days) | S4 | any | Any | Any | Option to strip LOW_PRIORITY for replication |
36964 | 2008-05-26 13:29 | 2011-02-16 23:43 | MySQL Server | No Feedback (5171 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 |
36988 | 2008-05-26 18:34 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5624 days) | S3 | 5.1.24-rc-community-log | Any | Any | Documentation on Next-Key Locking is confusing and misleading |
37112 | 2008-05-31 0:29 | 2008-06-12 16:26 | MySQL Server: Documentation | Closed (5796 days) | S3 | 5.0.45, 4.1, 5.1, 6.0-BK | Any | Any | Server accepts VALUE() syntax as well as VALUES() |
37142 | 2008-06-02 17:04 | 2008-07-04 20:06 | MySQL Server: General | No Feedback (5774 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 (5804 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 (4082 days) | S3 | 4.005, 4.007 | Any | Any | bind_param incorrectly interprets scientific notation |
37735 | 2008-06-30 8:40 | 2008-06-30 15:24 | MySQL Server: DML | Not a Bug (5778 days) | S2 | 5.1, 5.0, 4.1, 6.0 BZR | Any | Any | WHERE clause fails immediately following INSERT on AUTO INCREMENT column |
38034 | 2008-07-11 3:27 | 2011-02-16 23:43 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5337 days) | S2 | mysql-5.1-telco-6.2 | Any (Solaris, Linux) | Any | last_insert_id() value not shown in table with trigger |
38046 | 2008-07-11 14:22 | 2012-08-03 15:34 | MySQL Server: Locking | Closed (4283 days) | S3 | 5.0, 5.1, 6.0 bzr | Any | Any | INSERT SELECT ON DUPLICATE KEY UPDATE, LOAD DATA REPLACE wrong lock |
38071 | 2008-07-12 14:37 | 2017-05-21 20:45 | MySQL Server: Row Based Replication ( RBR ) | Duplicate (5761 days) | S3 | 6.0 | Any | Any | rpl_row_basic_2myisam: results mismatch in row mode |
38122 | 2008-07-15 7:41 | 2011-02-16 23:43 | Tools: Pushbuild | Closed (5292 days) | S3 | 1 | Any | Any | main.mysqlslap fails sporadically |
38148 | 2008-07-15 18:42 | 2008-07-15 20:52 | MySQL Server: Replication | Can't repeat (5763 days) | S3 | 5.0.37 | Any | Any | insert user() references uninitialized fields on a slave |
38289 | 2008-07-22 17:28 | 2018-09-25 21:48 | Tests: Replication | Can't repeat (5554 days) | S7 | 6.0-bugteam | Any | Any | rpl_temporary fails sporadically on windows: server has gone away |
38531 | 2008-08-02 14:16 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5370 days) | S4 | 5.0,5.1,4.0,4.1 | Any | Any | make innodb faster for concurrent insert/update workloads |
38655 | 2008-08-08 4:47 | 2008-09-08 5:05 | MySQL Workbench | No Feedback (5708 days) | S3 | 5.0.23 | Any | Any | insert statements malformed under certain circumstances |
38854 | 2008-08-18 13:15 | 2016-10-16 20:45 | MySQL Server: Replication | Verified (5729 days) | S3 | 5.1.26, 5.1, 6.0 bzr | Any | Any | wrong data if SIGNED/UNSIGNED bit doesn't match |
39088 | 2008-08-28 11:16 | 2008-10-13 15:31 | MySQL Workbench | Closed (5673 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 (5713 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 (4685 days) | S7 | 6.0 | Any | Any | main.analyze fails randomly on Pushbuild |
39432 | 2008-09-13 12:50 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5444 days) | S3 | ndb-6.2+ | Any (debian) | Any | slave stops if master does insert ... on duplicate key update |
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 (5673 days) | S3 | 5.0.25 | Any | Any | "Copy insert to Clipboard" uses lower case for keywords |
39654 | 2008-09-25 19:00 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5330 days) | S3 | 5.1, 6.0 | Any | Any | Insufficient error message for "The total number of locks exceeds ..." |
39660 | 2008-09-26 8:13 | 2012-05-18 20:19 | MySQL Server: Stored Routines | Duplicate (5690 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 (5372 days) | S2 | mysql-5.1-telco-7.0 | Any | Any | ndb_log_update_as_write does not work as expected |
39993 | 2008-10-13 6:16 | 2012-05-18 20:19 | MySQL Server: Replication | Duplicate (5291 days) | S4 | 4.1, 5.0, 5,1, 6.0 bzr | Any | Any | set binlog-do-db parameter by command line |
40255 | 2008-10-22 15:10 | 2011-02-16 23:43 | MySQL Server: Information schema | Verified (5663 days) | S3 | Any | Any | INFORMATION_SCHEMA.WARNINGS - a CREATE/INSERT .. SELECT friendly table | |
40698 | 2008-11-13 13:43 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5638 days) | S3 | Any | Any | after binary to varchar convertion varchar isn't variable | |
40709 | 2008-11-13 17:31 | 2011-02-16 23:43 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5455 days) | S3 | * | Any | Any | weird schema created with partition by key + mysqld core on insert |
40747 | 2008-11-14 15:03 | 2020-05-03 20:45 | MySQL Server: Data Types | Verified (5641 days) | S3 | 5.0.70, 5.1.29, 6.0.7 | Any | Any | Duplicate datetime truncation warning if a range optimizer is used. |
40879 | 2008-11-20 11:08 | 2011-02-16 23:43 | MySQL Server: DML | Duplicate (5595 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 (5629 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 (5616 days) | S3 | 5.0.67, 5.0.72, 5.1.30 | Any | Any | set timestamp allows unprivileged users to change per-session clock |
41466 | 2008-12-15 11:14 | 2011-02-16 23:43 | MySQL Cluster: Replication | Closed (5605 days) | S3 | cluster 6.4 | Any | Any | online add partition with replication looses data |
Showing 1-1000 of 2778 (Edit, Save, CSV, Feed) | Show Next 1000 Entries » |