Showing 1-1000 of 12997 (Edit, Save, CSV, Feed) Show Next 1000 Entries »
The following words were ignored: ON
ID# Date Updated Type Status Sev Version OS CPU Summary
118392005-07-09
22:32		2005-07-10
1:56		MySQL Server: InstallingNot a Bug
(6858 days)		S4nonenoneAnykemal
118402005-07-09
22:47		2005-07-10
1:53		MySQL Server: InstallingNot a Bug
(6858 days)		S4 Anyinstall
1061532022-01-13
1:23		2022-01-13
18:21		MySQL Server: mysqlpump Command-line ClientVerified
(827 days)		S35.7, 8.0AnyAnymysqlpump should use CREATE TABLE IF NOT EXISTS
206862006-06-25
15:20		2012-05-18
20:19		MySQL ServerDuplicate
(6346 days)		S24.1.20 and 5.0.22Linux (Linux)Anywrong date vs values(date) compare in on duplicate key
251292006-12-18
4:12		2009-03-24
12:25		MySQL Server: InstallingCan't repeat
(5505 days)		S25.1.14AnyAny5.1.14 mysql_fix_privilege_tables does not update privilege tables from 5.0.22
113722005-06-16
9:19		2006-07-25
0:17		MySQL Server: InstallingClosed
(6478 days)		S35.0.7 betaLinux (Linux)AnyInvalid default value for 'sql_mode' when running mysql_fix_privilege_tables
796652015-12-16
10:50		2017-05-31
20:02		MySQL Server: DocumentationClosed
(2515 days)		S3anyAnyAnyManual does NOT explain locks set by INSERT ... ON DUPLICATE KEY UPDATE properly
23942004-01-14
21:21		2004-01-14
22:16		MySQL ServerCan't repeat
(7401 days)		S35.0.0Windows (winxp)AnyCrash MySQL
264272007-02-15
21:20		2007-09-18
14:01		MySQL Server: Falcon storage engineCan't repeat
(6058 days)		S35.2.4-falcon-alpha-debugLinux (suse 9.3 x86)AnySerial Log possible gap: 142463 - 115862 - Duplicate INDEXES.SYSTEM
330662007-12-07
16:33		2007-12-25
14:06		MySQL Server: DMLNot a Bug
(5960 days)		S35.1.22-rcAnyAnylast_insert_id(), wrong values, InnoDB, insert on duplicate key update
284782007-05-16
17:05		2007-06-20
0:51		MySQL Server: MyISAM storage engineClosed
(6148 days)		S25.0.42, *AnyAnyImproper key_cache_block_size corrupts MyISAM tables
661042012-07-30
20:48		2012-09-07
6:31		MySQL Cluster: Cluster (NDB) storage engineClosed
(4242 days)		S27.2.7Linux (Debian 6)AnyMySQL-Cluster Online backup error
839212016-11-22
20:33		2017-01-04
7:22		MySQL Server: ParserVerified
(2662 days)		S35.7.16CentOS (7)Anyfalsely Ambigous Column in On Duplicate Key Update using a subselect
524192010-03-28
18:54		2011-02-16
23:44		MySQL Server: GeneralClosed
(4947 days)		S25.5.3-m3Linux (x86 icc)Anyx86 assembly based atomic CAS causes test failures
90922005-03-10
13:00		2005-07-26
4:40		MySQL Server: InstallingCan't repeat
(6842 days)		S34-1-10-standard-logLinux (RedHat 9)Anyafter running mysql_fix_privilege_tables server still uses old password format
663012012-08-10
8:46		2013-04-22
20:28		MySQL Server: InnoDB storage engineClosed
(4015 days)		S25.1, 5.5AnyAnyINSERT ... ON DUPLICATE KEY UPDATE + innodb_autoinc_lock_mode=1 is broken
458022009-06-27
17:19		2009-07-24
9:11		MySQL Query BrowserClosed
(5383 days)		S11.2.17Windows (Vista)AnyDuplicate & Garbage indexes added to tables
298512007-07-17
18:05		2016-02-25
12:24		MySQL Cluster: Cluster (NDB) storage engineClosed
(5903 days)		S25.0.44LinuxAnyTRUNCATE causes error 4350 from cluster in INSERT... ON DUPLICATE KEY UPDATE
276502007-04-04
13:24		2007-05-01
17:45		MySQL ServerClosed
(6198 days)		S15.0.38, 5.xAnyAnyON DUPLICATE KEY UPDATE fails when setting UNIQUE values with multi row inserts
141312005-10-19
6:06		2012-05-18
20:19		MySQL Server: CharsetsVerified
(5671 days)		S45.0, 5.1, 6.0Linux (any)AnyReport PAD attribute in SHOW COLLATION and INFORMATION_SCHEMA.COLLATIONS
769312015-05-04
13:37		2015-05-21
22:38		MySQL Cluster: Cluster (NDB) storage engineClosed
(3264 days)		S37.5.0AnyAnyRandom warning order ndb_one_fragment
287812007-05-30
17:24		2016-02-25
12:24		MySQL Server: DocumentationClosed
(5054 days)		S25.0.42AnyAnyInnoDB increments auto-increment value incorrectly with ON DUPLICATE KEY UPDATE
380182008-07-10
14:43		2008-07-11
15:52		MySQL Server: Maria storage engineClosed
(5761 days)		S35.1-mariaLinuxAnyMaria: INSERT SELECT ON DUPLICATE KEY UPDATE, LOAD DATA REPLACE wrong lock
704602013-09-28
15:17		2016-12-30
9:20		MySQL Cluster: Cluster (NDB) storage engineVerified
(3856 days)		S25.6.11-ndb-7.3.2-cluster-gpl-logLinux (CentOS release 6.4 (Final))AnyMysql Cluster and constraints
984202020-01-28
19:50		2020-02-28
17:48		MySQL WorkbenchDuplicate
(1542 days)		S28.0.19Windows (Microsoft Windows 10 Pro)x86Will not start due to System.IO.FileNotFoundException
987932020-03-02
2:01		2020-04-03
1:00		MySQL Server: WindowsNo Feedback
(1478 days)		S28.0.18 - MySQL Community Server - GPLWindows (Windows Server 2019 17763.973)AnyMysql Service Stop when database has large number of data and try to truncate
691532013-05-06
10:40		2013-06-28
9:25		MySQL Workbench: ModelingClosed
(3948 days)		S25.2.47MacOS (10.8.3)AnySynchronize database for column name change drops all foreign key constraints
1098912023-02-02
9:10		2023-02-03
7:55		MySQL Server: DMLVerified
(441 days)		S38.0.30,8.0.31, 8.0.32, 5.7AnyAnyContribution by Tencent: insert on duplicate key update would be abnormal
135872005-09-28
21:40		2005-10-20
6:59		MySQL Server: Stored RoutinesClosed
(6756 days)		S35.0.13-rc-standard-log, 5.0.13-rc-ntLinux (Linux, Solaris 9 64 bit, Windows)AnyServer crash when SP is created without database selected
938062019-01-03
17:41		2020-09-21
14:21		MySQL Server: DocumentationClosed
(1885 days)		S3allAnyAnyDocument error about "ON DUPLICATE KEY UPDATE "
731902014-07-03
21:23		2017-04-17
13:36		MySQL Server: mysqldump Command-line ClientVerified
(3199 days)		S4AnyAny[mysqldump] Support INSERT ... ON DUPLICATE KEY UPDATE for data dumps
377132008-06-28
10:27		2018-09-25
21:47		Tests: ReplicationCan't repeat
(5548 days)		S76.0-rplAnyAnyrpl.rpl_known_bugs_detection failed in pushbuild
782702015-08-29
22:50		2016-01-13
20:44		MySQL Server: InnoDB storage engineClosed
(3019 days)		S3MySQL 5.6.26.Any (CentOS release 6.6)AnyUnexpected Memory Consumption for Bulk Index Creation in InnoDB.
178012006-02-28
18:26		2006-03-13
12:51		MySQL Cluster: Cluster (NDB) storage engineClosed
(6612 days)		S15.1.8Linux (Linux 32 Bit OS)AnyINSERT ON DUPLICATE KEY UPDATE using NDB table cause core
963282019-07-25
10:37		2019-07-25
13:04		MySQL ServerNot a Bug
(1730 days)		S3allAnyAny INSERT ... ON DUPLICATE KEY UPDATE
734832014-08-06
10:18		2014-08-14
18:44		MySQL ServerNot a Bug
(3536 days)		S35.6.19Linux (debian6.0)Anyinnodb_autoinc_lock_mode, row based replication, duplicate primary key assigned
293292007-06-25
3:37		2015-03-15
20:45		MySQL Server: Stored RoutinesNo Feedback
(5972 days)		S35.0.38Linux (Gentoo)AnyExplicit commit complaints
1116692023-07-06
0:47		2023-07-12
13:04		MySQL Server: OptimizerVerified
(282 days)		S58.0.33AnyAnySimple Query Times Out
279552007-04-19
14:33		2015-03-15
20:45		MySQL Server: MyISAM storage engineNo Feedback
(6180 days)		S25.0.37Linux (FC5)Anyerror of unknown column 'xxx' in field list but column 'xxx' isnt in the query
236472006-10-25
20:53		2006-11-02
21:44		MySQL Server: Falcon storage engineClosed
(6378 days)		S3Linux (Linux 64-bit)AnyFalcon crashes on update no-key test, 64 threads
524302010-03-29
11:01		2011-02-16
23:44		MySQL Server: Data TypesClosed
(5035 days)		S35.5.3-m3AnyAnyIncorrect key in the error message for duplicate key error involving BINARY type
289042007-06-05
19:04		2011-03-16
16:36		MySQL Server: OptimizerClosed
(6145 days)		S25.0.41Linux (SuSE 10.1)AnyON UPDATE CURRENT_TIMESTAMP does not work properly with ON DUPLICATE KEY
695132013-06-19
14:22		2013-08-19
1:00		MySQL Server: InnoDB storage engineNo Feedback
(3897 days)		S35.6Windows (Windows 7 Ultimate 64-bit)AnyInnoDB: Assertion failure in thread 5616 in file ut0lst.h line 271
277442007-04-11
1:41		2007-04-12
11:58		MySQL ServerCan't repeat
(6217 days)		S25.0.37-logLinuxAnycommand "insert .. on duplicate key update" does not update and/or AFR is wrong
832392016-10-02
4:16		2016-10-06
21:28		MySQL Server: OptimizerNot a Bug
(2752 days)		S35.7.15-0ubuntu0.16.04.1Ubuntu (16.04)AnyInconsistent nonaggregated field in SELECT not in GROUP BY
270062007-03-09
16:19		2007-03-20
16:34		MySQL Server: Stored RoutinesClosed
(6240 days)		S15.0.36Any (All)AnyAFTER UPDATE triggers not fired with INSERT ... ON DUPLICATE KEY UPDATE
273072007-03-20
21:24		2007-03-20
21:31		MySQL Server: GeneralDuplicate
(6240 days)		S25.0.37-communityLinux (Linux (x86))Any'INSERT ... ON DUPLICATE KEY UPDATE' not performing update
429752009-02-18
16:07		2011-02-16
23:43		MySQL Server: GeneralDuplicate
(5538 days)		S25.1.30LinuxAnyMySQL Crash: glibc detected double free or corruption
931412018-11-09
13:17		2018-11-20
14:42		MySQL Server: DMLCan't repeat
(1977 days)		S35.7.22-22-logLinuxAnyDuplicate Records despite index
115192005-06-23
5:17		2005-07-01
12:59		MySQL ServerClosed
(6867 days)		S25.0.8manyAnytype_timestamp fails on many platforms
354572008-03-20
12:06		2008-04-26
20:58		MySQL WorkbenchNo Feedback
(5837 days)		S35.0.15WindowsAnyDROP TABLE comes after CREATE TABLE IF NOT EXISTS
285052007-05-18
0:19		2007-06-19
0:56		MySQL ServerClosed
(6149 days)		S23.1.10, and 5.0.6AnyAnyUpdate count for an INSERT DUPLICATE KEY not correct when CLIENT_FOUND_ROWS set
518382010-03-08
17:29		2011-02-16
23:44		MySQL Server: InnoDB storage engineWon't fix
(5145 days)		S25.0.84AnyAnyInnodb gets X lock for INSERT ON DUPLICATE KEY UPDATE but not INSERT SELECT
891472018-01-08
22:18		2018-01-11
9:52		MySQL Server: Group ReplicationVerified
(2290 days)		S45.7.20,8.0.3AnyAnyThe field end_log_pos in Group Replication error messages is ambiguous.
1005182020-08-13
15:08		2020-08-30
21:18		MySQL Server: ReplicationCan't repeat
(1328 days)		S25.7.29CentOSAnyAuto-increment value in UPDATE conflicts with internally generated values
133852005-09-21
17:17		2005-09-21
17:55		MySQL ServerClosed
(6785 days)		S24.1.13Windows (Windows 2000)Anyvalues() fails with 'Column specified twice' when ON DUPLICATE KEY UPDATE used
506192010-01-26
11:02		2011-02-16
23:44		MySQL Server: DMLClosed
(4848 days)		S35.1.44,5.5.99-m3,6.0.14-alphaAnyAnyassert in handler::update_auto_increment
796342015-12-14
13:04		2016-01-18
10:02		MySQL ServerNot a Bug
(3014 days)		S25.6.25-logDebian (7.8)Anytransaction written to the binary log were not actually applied to the DB
133922005-09-21
22:47		2005-10-31
20:13		MySQL Server: OptimizerClosed
(6745 days)		S25.0.12-beta-nt-logAny (All)Anyvalues() fails with 'ambiguous' or returns NULL with ON DUPLICATE and SELECT
732522014-07-10
7:18		2014-08-22
1:00		MySQL Server: InnoDB storage engineNo Feedback
(3529 days)		S35.6.13AnyAnyDuplicate foreign keys break insertions to a table
610672011-05-05
9:55		2011-09-23
23:00		MySQL Server: DMLNo Feedback
(4593 days)		S25.5.11Windows (Vista)AnyForeign key creation order is essential
898022018-02-26
11:21		2018-02-27
12:04		MySQL Server: DDLNot a Bug
(2243 days)		S35.6.35-81.0AnyAnyMySQL Table key/index position order - No possibility to change
858212017-04-06
7:11		2020-12-01
11:51		MySQL Server: OptimizerClosed
(1235 days)		S38.0.2-DEBUGAnyAnypartial update on views does not work
542492010-06-05
2:32		2017-05-21
20:45		MySQL Server: Row Based Replication ( RBR )Verified
(5066 days)		S35.1AnyAnyMore verbose RBR error logging
53202004-08-31
16:38		2004-08-31
21:40		MySQL Cluster: Cluster (NDB) storage engineDuplicate
(7171 days)		S34.1.4-gamma (ndb)Linux (SuSE 9.1)AnyCluster: different error message returned than under MyISAM/InnoDB
415322008-12-17
9:06		2011-02-16
23:43		Connector / JClosed
(5496 days)		S55.1.7AnyAnySlower performance since 5.1.7 with rewriteBatchedStatements option
1046082021-08-12
22:31		2021-11-10
13:24		MySQL Server: InnoDB storage engineVerified
(891 days)		S45.7.35, 8.0.26AnyAnyImprove error message for ALTER failing because concurrent Duplicate entry.
830852016-09-21
18:15		2016-10-22
1:00		MySQL Server: InnoDB storage engineNo Feedback
(2737 days)		S1MYSQL 5.5.49Debian (x86_64)AnyInsert after Left join generates duplicated rows in result
620882011-08-04
22:53		2011-08-05
14:50		MySQL Workbench: ModelingNot a Bug
(4641 days)		S35.2.31aWindowsAnyForward engineer ALTER script generates different SQL than CREATE
115992005-06-28
0:07		2005-06-28
11:09		MySQL Server: MyISAM storage engineNot a Bug
(6870 days)		S24.1.11aLinux (Linux)AnyI get a Duplicate entry error message even when the key doesn't exist yet
231332006-10-10
11:27		2006-10-26
18:06		MySQL Server: DocumentationClosed
(6385 days)		S35.0.26-standard-logLinux (Linux radium.net45.com 2.6.9-34.)AnyLOAD INDEX INTO CACHE fails
271232007-03-14
9:49		2007-05-09
6:05		MySQL Server: PartitionsClosed
(6190 days)		S25.1.17BKLinux (suse 9.3 x86)Anypartition + on duplicate key update + varchar = Can't find record in table
374112008-06-14
19:21		2017-05-14
20:45		MySQL Server: InnoDB storage engineNo Feedback
(5630 days)		S25.0.51aSolarisAnyThreads staying in the "Sending Data" for long periods of time
390332008-08-26
6:10		2021-05-02
20:45		MySQL Cluster: Cluster (NDB) storage engineDuplicate
(5713 days)		S25.1.24-ndb-6.3.16LinuxAnyTable disappear
687722013-03-26
2:58		2013-05-02
1:00		MySQL Server: MyISAM storage engineNo Feedback
(4006 days)		S2Ver 5.5.29-0ubuntu0.12.04.2-logLinux (Ubuntu 12.04)AnyNew tables corrupted: Table ... is marked as crashed and should be repaired
861482017-05-01
13:19		2018-02-09
18:16		MySQL WorkbenchClosed
(2261 days)		S36.3, 6.3.9Windows (7, 64 bit)AnyMySQL Workbench 6.3 problems importing JSON files into MySQL 5.7.12
980772019-12-26
10:06		2020-01-15
13:53		MySQL ServerNot a Bug
(1556 days)		S35.7.23CentOS (CentOS Linux release 7.4.1708 (Core) )Anyalloc too much memory by a small table
747332014-11-07
13:02		2014-11-07
16:14		MySQL Server: Security: PrivilegesVerified
(3451 days)		S35.5, 5.6, 5.7AnyAnySELECT privilege is not checked for views on UPDATE which references to columns
40082004-06-04
15:12		2004-06-25
15:14		MySQL ServerClosed
(7238 days)		S34.1, 5.0Linux (Linux)Anyinsert on duplicate fails depending on MERGE table INSERT_METHOD
194782006-05-02
13:04		2008-01-29
10:02		MySQL ServerCan't repeat
(5925 days)		S35.0.20Windows (Windows 2003)AnySQL 'UPDATE' stops working
380412008-07-11
9:46		2008-09-30
20:31		MySQL Server: Falcon storage engineClosed
(5680 days)		S16.0-falconAnyAnyBizarre errors when ALTER ADD/DROP KEY on Falcon tables
775722015-07-01
2:33		2018-10-29
21:17		MySQL Server: DDLClosed
(3137 days)		S35.6.16 5.7.7AnyAnyThe bogus duplicate key error in online ddl with incorrect key name
453742009-06-08
13:24		2011-02-16
23:44		MySQL Server: DocumentationClosed
(5411 days)		S4AnyAnyDocumentation: need to document that certain WHERE clauses require Select_priv
611332011-05-11
13:29		2012-12-20
20:55		MySQL Server: ReplicationCan't repeat
(4138 days)		S25.5.10Linux (SuSE Linux Enterprise 11.1)AnyMaster -> Slave : duplicate key error after running fine for days
9842003-08-03
12:15		2003-08-12
13:46		MySQL Server: InnoDB storage engineClosed
(7556 days)		S13.23.48Linux (Linux)Anymysqld crashes when creating an innodb table with foreign key
673672012-10-24
19:26		2013-03-26
1:00		MySQL Workbench: ModelingNo Feedback
(4043 days)		S25.2.44MacOS (Darwin 12.2.0)AnySynchronization requests to remove existing tables.
324372007-11-16
14:41		2007-11-22
8:36		MySQL Server: ReplicationNot a Bug
(5993 days)		S25.0.45Linux (CentOS)AnyINSERT ... ON DUPLICATE KEY UPDATE replication 5.0.27 master & 5.0.45 slave
333952007-12-20
9:24		2008-04-17
9:31		MySQL Server: MyISAM storage engineNo Feedback
(5846 days)		S1Ver 14.12 Distrib 5.0.51Linux (pc-linux-gnu (x86_64) )Any [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_77d3_0.MYI';
384842008-07-31
10:55		2008-11-07
15:59		MySQL Server: Maria storage engineClosed
(5642 days)		S16.0.6-alpha, 6.0.7pre,6.0.7,6.0.8preAnyAnymaria: DELETE causes crash or index corruption
539132010-05-22
15:12		2011-02-16
23:44		MySQL Server: GeneralClosed
(5081 days)		S25.1.45-1Linux (Debian/squeeze)AnyUnknown column error for existing column
577682010-10-27
11:58		2010-10-29
5:00		MySQL Server: InnoDB storage engineNot a Bug
(4921 days)		S25.1.41Windows (Win 7)AnyFOREIGN KEY ON UPDATE CASCADE does not work with self-reference
105382005-05-11
10:52		2022-08-21
20:45		MySQL ServerDuplicate
(6869 days)		S15.0.6bkLinux (Linux)AnyTriggers not locking tables
686092013-03-08
0:28		2014-10-09
16:07		MySQL Server: ReplicationWon't fix
(3480 days)		S35.5.30, 5.6.10AnyAnyMBR: Unique key updates are not marked unsafe, replication fails
276042007-04-03
1:29		2015-03-15
20:45		MySQL Server: GeneralNo Feedback
(6157 days)		S114.12 Distrib 5.0.37, for pc-linux-gnu (Linux (Redhat 9 (Shrike))AnyUpdate query with Join crashes mysqld
192432006-04-21
4:45		2006-09-13
17:45		MySQL Server: OptimizerClosed
(6428 days)		S35.0.21-BK, 4.1.7Linux (Linux, Windows)Anywrong LAST_INSERT_ID() after ON DUPLICATE KEY UPDATE
799372016-01-12
15:42		2016-01-13
12:15		MySQL Server: DMLNot a Bug
(3019 days)		S35.6.27AnyAnyIncorrect record updated using ON DUPLICATE KEY UPDATE processing
246972006-11-29
15:13		2018-09-09
20:45		MySQL Server: OptimizerVerified
(4857 days)		S35.0.24a-community-nt-log/4.1BK/5.0BK/5.1BKWindows (Windows 2000 and Linux)Anyinsert .. select ....ON DUPLICATE KEY UPDATE fails with ambiguous column name
712322013-12-26
11:34		2014-07-04
9:51		MySQL Server: InnoDB storage engineVerified
(3577 days)		S35.6.15AnyAnyWrong behaviour for auto_increment unsigned bigint column approaching max value
368022008-05-19
15:42		2022-01-05
15:50		MySQL Server: OptimizerClosed
(835 days)		S35.0, 5.1, 6.0 BKAnyAnyMySQL only use covered index when selecting from a view (or subquery) with union
109362005-05-28
1:25		2005-08-27
7:44		MySQL Cluster: Cluster (NDB) storage engineClosed
(6810 days)		S35.1.0Linux (Linux)AnyCluster engine shows wrong key value for duplicate key error.
769272015-05-04
12:09		2016-06-18
21:26		MySQL Server: InnoDB storage engineClosed
(3168 days)		S25.1, 5.5, 5.6, 5.7, 8.0AnyAnyDuplicate UK values in READ-COMMITTED (again)
132862005-09-16
22:01		2005-10-26
22:12		MySQL Migration ToolkitCan't repeat
(6750 days)		S1Release 5.0.XWindows (Windows, Linux)AnyTables in SQL Server having composite foreign keys not migrated
491732009-11-28
3:26		2011-02-16
23:44		MySQL Server: ErrorsClosed
(5256 days)		S25.1.30-communityWindows (xp media center sp3)Anycreate view fails: MySQL error 1060 "duplicate column name"
989762020-03-17
15:35		2020-03-18
7:08		MySQL Server: Information schemaVerified
(1493 days)		S38.0.19, 5.7.29Debian (mysql:8.0.19 from Docker)x86Case of referenced column of foreign key not corrected on import
246012006-11-26
17:04		2016-01-03
20:45		MySQL Server: InnoDB storage engineNo Feedback
(6323 days)		S25.0.26MacOS (Mac OS X 10.4.8)AnyMySQLd crashes upon creation of an index
479552009-10-09
18:59		2016-02-25
12:24		MySQL Cluster: Cluster (NDB) storage engineClosed
(5273 days)		S2mysql-5.1-telco-6.3AnyAnyUPDATEs using indexes that modify no rows return incorrect found rows
216532006-08-15
12:06		2006-08-26
10:00		MySQL ServerDuplicate
(6446 days)		S25.0.19Linux (SuSE 10.0)AnyMysql appears to hang at bin log file rotation (not every rotation)
312392007-09-27
13:29		2008-02-25
17:17		MySQL Cluster: Cluster (NDB) storage engineClosed
(5898 days)		S25.1.22-rc, 5.0.50Other (ICC / IA64)AnyTest "ndb_views" returns NDB error 4259 "Invalid set of range scan bounds"
719232014-03-04
12:23		2014-07-17
17:29		Connector / JClosed
(3564 days)		S35.1.29AnyAnyIncorrect generated keys if ON DUPLICATE KEY UPDATE not exact
995752020-05-14
15:26		2023-02-09
20:02		Connector / PythonClosed
(435 days)		S38.0.20, 8.0.25Ubuntu (20.04)ARMinsert into t (c1,...) values(%s,...) as v on duplicate key update c1=v.c1 slow
782622015-08-28
15:19		2015-12-07
18:51		MySQL Server: InnoDB storage engineClosed
(3056 days)		S55.6.26Any (CentOS release 6.6)AnyAdding indexes on empty table is slow with large innodb_sort_buffer_size.
383912008-07-26
13:57		2008-07-27
16:19		MySQL WorkbenchDuplicate
(5745 days)		S35.0.23 SEWindowsAnySynchronize after Forward enginieer creates ALTER statements every time
262762007-02-12
6:07		2015-03-15
20:45		MySQL Server: ErrorsNo Feedback
(6248 days)		S25.0.26Linux (linux)AnyDuplicate entry
79752005-01-17
22:56		2005-04-18
10:22		MySQL Server: InnoDB storage engineClosed
(6941 days)		S34.1.9, official 686 binaryLinux (debian amd64 pure64)Anydeadlock without any locking, simple select and update
675262012-11-08
18:51		2019-05-07
21:37		MySQL Server: InnoDB storage engineClosed
(1809 days)		S35.5.28, 5.5.29, 5.7.0Linux (Debian/AMD64 6.0.5)AnyDuplicate key error on auto-inc PK with mixed auto_increment_increment clients
679142012-12-16
10:36		2013-01-19
1:00		MySQL ServerNo Feedback
(4109 days)		S25.5.20Linux (ubuntu)AnyTimestamp auto update column not updated on each update statement
177442006-02-27
16:52		2006-03-24
13:56		MySQL Server: PartitionsClosed
(6601 days)		S15.1 AnyPartitions: InnoDB, Trigger, rotten table leads to wrong result sets
684462013-02-20
23:36		2013-02-22
14:56		MySQL Server: DMLClosed
(4074 days)		S35.5.29AnyAnyinsert on duplicate key update with null autoincremented PK uses wrong pk value
375602008-06-20
22:56		2008-07-31
18:01		MySQL Server: GeneralClosed
(5741 days)		S35.0.45-community-logLinuxAnyAutoincrement should not increment on duplicate key condition
805052016-02-25
9:43		2016-02-25
14:53		MySQL Server: OptimizerDuplicate
(2976 days)		S55.7.11WindowsAnymysql server 5.7.11 view performance issue
449042009-05-15
14:19		2018-02-10
17:27		MySQL Server: DMLCan't repeat
(2260 days)		S35.0, 5.1Windows (XP SP3)AnyLIMIT IN INSERT ... DUPLICATE KEY UPDATE DIFFER IN THE SMPLE LIMIT
658892012-07-13
0:21		2012-07-16
10:18		MySQL Server: InnoDB storage engineVerified
(4298 days)		S3<=5.5AnyAnyAppended primary key stored inefficiently in unique surrogate keys
1107172023-04-18
15:17		2023-09-13
13:01		Connector / NETClosed
(227 days)		S28.0.33Windows (10)AnyOpening two MySqlConnections simultaneously can crash
321392007-11-06
9:11		2007-12-12
9:39		MySQL ServerNo Feedback
(5973 days)		S25.0.45Linux (ubuntu 7.10)AnyComputing crc32(group_concat(...)) on a very loaded table doesn't give result ok
1125872023-10-02
13:29		2023-10-17
9:58		MySQL Server: DocumentationClosed
(186 days)		S38.0Linuxx86Change in MySQL error message format for 1062 Duplicate Entry from v5.7 to v8.0
188082006-04-05
14:25		2013-10-06
20:45		MySQL Cluster: Cluster (NDB) storage engineDuplicate
(6573 days)		S35.1.9Linux (Linux 32 Bit OS)Any"Rowid already allocated" Error duing update and not during node recovery
394322008-09-13
12:50		2011-02-16
23:43		MySQL Server: DocumentationClosed
(5438 days)		S3ndb-6.2+Any (debian)Anyslave stops if master does insert ... on duplicate key update
656782012-06-19
21:56		2012-06-30
10:09		Connector / PythonClosed
(4311 days)		S30.3.2-devAnyAnyOn duplicate key UPDATE VALUE fails regex
25562004-01-29
8:21		2004-03-06
12:31		MySQL Server: ReplicationNo Feedback
(7349 days)		S24.0.17Linux (Mandrake linux 9.2)AnyError in Log_event::read_log_event(): 'Event too big', data_len: 808333356, eve
173852006-02-14
15:39		2006-02-22
18:46		MySQL ServerClosed
(6631 days)		S15.1.7 src Anyduplicate key error interchangeble refers to attribute name name and number
578682010-10-31
7:07		2011-02-16
23:44		MySQL Server: ErrorsUnsupported
(4918 days)		S24.0.27Linux (suse with kernel 2.6.16.60-0.21)Anyreplication,record error in log but the slave not stop.
873002017-08-03
10:18		2017-11-09
11:24		Shell General / Core ClientClosed
(2353 days)		S2mysqlsh Ver 1.0.10 for Linux on x86_64AnyAnymysql-shell dba.checkInstanceConfiguration()
873522017-08-09
8:17		2017-08-09
9:37		MySQL Cluster: Cluster (NDB) storage engineVerified
(2445 days)		S37.5.7AnyAny"ndb_restore --print-sql-log" includes unnecessary SQL
541822010-06-02
13:33		2016-09-08
5:54		MySQL Cluster: ReplicationCan't repeat
(2780 days)		S2mysql-5.1-telco-6.3Linux (debian etch)AnyUnique constraint make the replication crash
545602010-06-16
18:58		2011-02-16
23:44		MySQL ServerClosed
(5050 days)		S35.1, 4.1, 5.0, 5.6.99AnyAnyDocs for REPLACE are not accurate
586372010-12-01
19:44		2014-06-25
14:34		MySQL Server: ReplicationClosed
(4382 days)		S25.1+, 5.0, 5.6.1AnyAnyMark INSERT...ON DUPLICATE KEY UPDATE unsafe when there is more than one key
166302006-01-19
12:47		2007-03-06
19:42		MySQL Server: OptimizerClosed
(6254 days)		S24.1 Anyerror, when INSERT t1 SELECT ... FROM t1 ON DUPLICATE
220062006-09-05
0:09		2006-09-05
0:20		MySQL ServerNot a Bug
(6436 days)		S25.0.24Windows (MS Server 2003)AnySimple math using floats yielding bad precision results.
612132011-05-18
9:49		2014-06-10
7:08		Connector / JClosed
(3620 days)		S25.1.16AnyAnyON DUPLICATE KEY UPDATE breaks generated key list when extended INSERT is used
17962003-11-10
11:40		2003-12-19
6:46		MySQL ServerClosed
(7427 days)		S14.0.16 Any"IN" Problem
439322009-03-28
18:04		2011-02-16
23:43		MySQL Server: MyISAM storage engineClosed
(5453 days)		S15.1.32Windows (64-bit)Anymyisam index corruption with large index and large key_buffer_size
956782019-06-06
21:22		2019-07-08
12:38		MySQL Server: OptimizerCan't repeat
(1747 days)		S25.6.33Ubuntux86query gives empty result when using index_merge
384342008-07-29
19:15		2012-05-18
20:19		MySQL Server: DDLVerified
(5735 days)		S1 5.0.51b-community-nt MySQL Community Ed, 5.0, 5.1 BZRAny (Linux, MS Windows xp)Anyunique key index length
590422010-12-19
18:44		2010-12-19
18:44		MySQL Server: Security: PrivilegesOpenS45.1.52AnyAnyINSERT ... ON DUPLICATE KEY UPDATE shouldn;t need UPDATE access to key columns
970272019-09-26
10:02		2021-01-15
16:47		MySQL Server: Row Based Replication ( RBR )Verified
(1190 days)		S25.7.*Anyx86Bulk insert with ON DUPLICATE KEY UPDATE breaks replicaiton
429942009-02-18
21:47		2022-04-10
20:45		MySQL Server: InnoDB storage engineDuplicate
(5538 days)		S25.1.30, 5.1.31AnyAnyREPLACE INTO results in a DUPLICATE KEY error on the AUTO_INCREMENT primary key
580862010-11-09
15:09		2011-11-30
18:40		MySQL Server: DocumentationClosed
(4524 days)		S35.1AnyAnyauto_inc in InnoDB have INSERT ... ON DUPLICATE KEY UPDATE != UPDATE
423092009-01-23
18:17		2011-02-16
23:43		Connector / JClosed
(5560 days)		S35.1AnyAnyStatement.getGeneratedKeys() returns 2 keys when using ON DUPLICATE KEY UPDATE
32762004-03-23
16:58		2004-03-26
2:33		MySQL Server: MyISAM storage engineCan't repeat
(7329 days)		S14.0.16Linux (Redhat ES 3)AnyDeadlock with MyISAM
438422009-03-24
20:19		2013-01-14
9:25		MySQL Server: Federated storage engineWon't fix
(4113 days)		S45.0AnyAnySupport for ON DUPLICATE KEY UPDATE with FEDERATED
538712010-05-21
2:57		2011-02-16
23:44		MySQL Server: DocumentationClosed
(5082 days)		S35.1AnyAnyX lock is taken by innodb on duplicate key error, insert on duplicate key update
210002006-07-12
12:49		2006-07-17
11:07		MySQL Query BrowserClosed
(6486 days)		S11.1.20Windows (Windows XP)AnyStored proc crashes Query Browser & Admin
342532008-02-02
20:20		2008-02-03
17:28		MySQL WorkbenchNot a Bug
(5920 days)		S35.012.OSS BetaWindows (XP )Anyimport sql workbech script generates errno 121
382392008-07-19
9:46		2008-07-31
1:40		MySQL WorkbenchNot a Bug
(5741 days)		S25.0.23 OSS Rev. 3198Windows (Vista)AnyError importing 'Forward Engineer SQL CREATE Script' - With constraints
330252007-12-05
21:54		2007-12-07
18:08		MySQL Server: ReplicationDuplicate
(5978 days)		S25.0.45LinuxAnyReplication breaks on "on duplicate key update": ids on master & slave differ
276722007-04-05
16:35		2007-07-29
6:36		MySQL Server: GeneralNo Feedback
(6109 days)		S35.0.37 Community EditionLinux (Fedora 5 64-bit)Anyinsert on duplicate key update sometimes delayed
288002007-05-31
9:16		2007-05-31
10:36		MySQL Server: Stored RoutinesCan't repeat
(6168 days)		S25.0.37-community-ntWindows (XP SP2)AnyON DUPLICATE KEY UPDATE doesn't run triggers
449762009-05-20
9:09		2011-02-16
23:43		MySQL Server: ReplicationDuplicate
(4977 days)		S25.0.77AnyAnyIncorrect INSERT_ID in binary log
665402012-08-25
20:04		2013-01-23
1:00		MySQL Server: DMLNo Feedback
(4105 days)		S4AnyAnyRedundant coding in ON DUPLICATE KEY UPDATE
510552010-02-10
10:43		2011-02-16
23:44		MySQL Server: ReplicationClosed
(5051 days)		S3mysql-5.1AnyAnyReplication failure on duplicate key + traditional SQL mode
3902003-05-07
9:14		2003-05-13
11:10		MySQL ServerClosed
(7647 days)		S34.0.13Any (All)AnyDiscrepancy with ISO about primary key and NOT NULL (error 1171)
96362005-04-05
6:45		2005-05-15
23:05		MySQL ServerCan't repeat
(6914 days)		S25.0.3 rpmLinux (Linux Fedore Core 2)AnyINSERT INTO table from a complex View
867252017-06-16
6:59		2017-10-31
13:08		MySQL Server: DDLClosed
(2362 days)		S35.7 5.7.17, 5.7.18AnyAnyBehavior is different. "ADD KEY" and "ADD UNIQUE KEY" for the TEXT columns
260692007-02-05
5:24		2012-05-18
20:19		MySQL Server: Falcon storage engineNo Feedback
(6186 days)		S25.2.2 (20070204 tree)Linux (ubuntu 6.06 x86_64)Anyduplicate entries for unique keys (incl primary)
309152007-09-08
14:33		2008-01-08
20:32		MySQL Server: DocumentationClosed
(5946 days)		S35.0.41FreeBSD (6.2)Anyon duplicate key update: needs update privileges for primary key
43122004-06-28
17:59		2004-11-18
17:25		MySQL Cluster: Cluster (NDB) storage engineClosed
(7092 days)		S24.1Linux (Linux)Anyndb table, wrong behaviour on insert .. on duplicate key ..
108842005-05-26
14:10		2005-05-26
14:47		MySQL ServerDuplicate
(6903 days)		S25.0.4-ntWindows (Windows XP sp2)AnyInsert ... on duplicate key update does not recognize table alias
240792006-11-08
9:39		2006-12-07
22:31		MySQL Server: Falcon storage engineClosed
(6343 days)		S15.2AnyAnystrange errors around INSERT getting duplicate key, but one row is inserted
393522008-09-09
22:07		2011-05-12
6:42		Connector / JClosed
(5670 days)		S35.0.x, 5.1.xAnyAnyINSERT ON DUPLICATE returns 1 instead of 0 when nothing is changed
619622011-07-23
21:43		2011-08-06
12:44		MySQL ServerNot a Bug
(4640 days)		S15.5.14Any (Tested on 5.5.8 and 5.5.14)Any'ON DUPLICATE KEY UPDATE' bug incrementing ID (auto increment field) on Updates
651302012-04-27
12:12		2013-05-23
19:20		MySQL Cluster: Cluster (NDB) storage engineClosed
(3984 days)		S37.1.x, 7.2.5LinuxAny"Transaction already aborted" hides real error msg on INSERT ... ON DUP UPDATE
893852018-01-24
15:14		2020-10-06
13:05		MySQL ServerNot a Bug
(1291 days)		S4AnyAnyINSERT IGNORE DUPLICATE KEY
135712005-09-28
14:22		2006-04-14
14:45		MySQL Server: CompilingClosed
(6580 days)		S35.0.13-rc, 5.0.14-rcIBM AIX (AIX 5.2)AnyCompiling problems on AIX
719162014-03-03
16:52		2016-10-26
13:43		MySQL Server: DocumentationClosed
(2732 days)		S35.6AnyAnyManual does NOT explain locks set for UPDATE ... WHERE PK='const' properly
1070262022-04-14
16:17		2022-04-15
12:13		MySQL Server: DMLClosed
(735 days)		S35.7.36Debianx86Update performs full table scan due to too many indexes
302562007-08-06
14:27		2007-08-06
15:15		MySQL ServerCan't repeat
(6101 days)		S25.0.45AnyAnyQuery cache not emptied after a INSERT ... ON DUPLICATE KEY UPDATE
182452006-03-15
2:23		2006-04-23
16:05		MySQL ServerNo Feedback
(6571 days)		S34.1.16Linux (Linux)AnySlave executes query from old binlog following master binlog rotation
412632008-12-05
15:18		2011-02-16
23:43		MySQL Server: ReplicationDuplicate
(5506 days)		S25.1.30LinuxAnyReplication breaks after 'INSERT ... ON DUPLICATE UPDATE ...'
549142010-06-30
13:08		2011-02-16
23:44		MySQL Server: InnoDB storage engineClosed
(4924 days)		S55.5.5AnyAnyInnoDB: performance drop with innodb_change_buffering=all
264642007-02-17
18:25		2007-03-15
2:54		MySQL Server: Merge storage engineClosed
(6245 days)		S24.1.21, 5.0.36BK, 5.1.16BK, 5.2.4BKAny (*)Anyinsert delayed + update + merge = corruption
214032006-08-01
19:21		2011-02-16
23:43		MySQL Server: ErrorsVerifiedS4allAny (all)Anymore specific SQL states for 23nnn
1128522023-10-27
7:42		2023-11-06
11:25		MySQL Server: DMLVerified
(165 days)		S38.0Linuxx86insert and insert onduplicate are executed concurrently, data update error
877962017-09-19
5:11		2021-09-01
13:10		MySQL Server: ReplicationClosed
(1236 days)		S15.7.19Linux (Linux localhost 3.10.0-327.28.2.el7.x86_64 #1 SMP Wed Aug 3 11:11:39 UTC 2016 x)AnyCommit_order_manager can't terminate MTS worker properly when deadlock happens
392482008-09-04
15:06		2009-01-09
15:28		MySQL Server: Maria storage engineClosed
(5579 days)		S35.1-maria, 6.0-bkLinuxAnyMaria: INSERT ON DUPLICATE KEY UPDATE gives error if using a view
565932010-09-06
12:20		2010-09-06
16:24		MySQL Server: ParserNot a Bug
(4974 days)		S35.1.41LinuxAnyscope issue in "ON DUPLICATE KEY UPDATE" when using aggregation functions
716722014-02-11
15:02		2014-07-16
22:08		Connector / JClosed
(3565 days)		S55.1.29AnyAnyEvery SQL statement is checked if it contains "ON DUPLICATE KEY UPDATE" or not
110392005-06-02
15:07		2005-06-16
17:11		MySQL Server: InnoDB storage engineClosed
(6882 days)		S35.0Any (any)AnyInnoDB: Warning: using a partial-field key prefix in search.
166352006-01-19
14:52		2007-08-03
1:44		MySQL Server: Embedded Library ( libmysqld )Closed
(6104 days)		S34.1.17Any (all Unix)AnyError messages wrong: absolute path names, "%s" format code
324722007-11-17
17:17		2007-11-20
13:02		MySQL Server: ErrorsClosed
(5995 days)		S35.0.45Linux (Fedora 6 2.6.22.9-61)AnyEnabling keys after inserts: Warning: Enabling keys got errno 22
397862008-10-01
17:56		2012-10-12
10:59		MySQL Server: OptimizerClosed
(4207 days)		S35.1.26AnyAnyExplain doesn't show key with order by in derived table.
805062016-02-25
10:41		2016-03-26
1:00		MySQL WorkbenchNo Feedback
(2947 days)		S16.3.6AnyAnyCould not alter table
1061882022-01-17
20:54		2022-09-05
13:56		MySQL Server: PackagingClosed
(592 days)		S18.0, 5.7AnyAnyThe MySQL GPG key seems to be incorrect
122992005-08-01
15:39		2005-09-02
7:54		MySQL ServerNo Feedback
(6804 days)		S34.0.20Windows (win2000)Anyshow create tables lost referense information accidentally
27252004-02-11
23:55		2004-03-05
0:31		MySQL ServerCan't repeat
(7350 days)		S24.0.17Tru62AnyKEY desc_idx (description(100)) being treated as UNIQUE KEY on Tru64
444642009-04-24
18:05		2011-02-16
23:43		MySQL WorkbenchNo Feedback
(5422 days)		S15.0.30WindowsAnyWorkbench SE Synch with collation difference fails
134292005-09-23
15:19		2005-10-06
12:06		MySQL Server: InnoDB storage engineNot a Bug
(6770 days)		S35.0, 5.0.12-ntLinux (Linux, Windows)AnyDuplicate FOREIGN KEYs are allowed
1087292022-10-10
16:06		2022-10-14
13:28		MySQL Server: FULLTEXT searchCan't repeat
(554 days)		S38.0.30Linuxx86Adding fulltext index results in duplicate entry error for unrelated key
69782004-12-03
9:07		2004-12-03
11:36		MySQL ServerNot a Bug
(7077 days)		S34.1.8 & 5.0.3Linux (Linux 2.4.21-99 smp)AnyErrors on multi table update and delete
108862005-05-26
14:59		2005-06-22
2:36		MySQL Server: OptimizerClosed
(6876 days)		S24.1.12Linux (Linux)AnyINSERT ... SELECT ... ON DUPLICATE KEY UPDATE produces bad results
343822008-02-07
14:55		2008-03-07
15:05		MySQL Server: GeneralNo Feedback
(5887 days)		S35.0.32Any (Sorry none)AnyError when using ON DUPLICATE KEY UPDATE table1.field1 = table2.field1,....
368982008-05-22
22:24		2008-05-25
10:04		MySQL Server: DMLNot a Bug
(5808 days)		S35.0.51AnyAnyINSERT ... ON DUPLICATE KEY UPDATE seem to compute wrong, if a new row is insert
406732008-11-12
19:10		2011-02-16
23:43		Connectors: DBD::mysql ( Perl )No Feedback
(5606 days)		S35.0.22LinuxAnyPerl affected row count incorrect for certain cases of ON DUPLICATE KEY UPDATE
1034172021-04-22
4:22		2022-11-25
23:34		Connector / JNot a Bug
(511 days)		S38.0.24MacOS (big sur)Anyjdbc . have an error in your SQL syntax
129462005-09-02
8:55		2005-10-05
11:27		MySQL ServerNo Feedback
(6771 days)		S24.0.18Linux (Red Hat Linux release 7.3 (Valha)AnyDuplicate key for record
146952005-11-07
9:53		2005-11-09
0:19		MySQL ServerCan't repeat
(6736 days)		S34.1.4Linux (Linux ibm171.iq2003.com 2.6.9-11)Anyreplication fail when reconnection
330292007-12-06
0:59		2008-04-05
7:34		MySQL Server: ReplicationClosed
(5858 days)		S25.0.52 / 5.1.22AnyAny5.0 to 5.1 replication fails on dup key when inserting using a trig in SP
899382018-03-07
3:13		2018-07-11
9:47		MySQL Server: Group ReplicationClosed
(2109 days)		S25.7.20,8.0.4AnyAnyRejoin old primary node may duplicate key when recovery
926422018-10-02
19:08		2018-10-02
20:34		MySQL WorkbenchDuplicate
(2026 days)		S28.0.12MacOS (macOS 10.13.x High Sierra x86_64)AnyResults Grid does now show
433112009-03-02
20:23		2011-02-16
23:43		MySQL Server: GeneralDuplicate
(5495 days)		S25.0.77AnyAnyWrong number of affected rows returned for insert on duplicate key
721622014-03-29
20:02		2014-04-29
20:07		MySQL Server: Stored RoutinesClosed
(3643 days)		S25.5.35-0ubuntu0.12.04.2 (Ubuntu)Linux (Linux 3.2.0-60-generic-pae i686)AnyInsert fail caused by trigger
451632009-05-28
15:10		2014-02-18
15:53		MySQL Server: DocumentationClosed
(3713 days)		S35.1.30, 5.0.70AnyAnyBehavior different then expected from manual - ALTER w/ FK
551572010-07-10
19:23		2011-02-16
23:44		MySQL Workbench: ModelingDuplicate
(5030 days)		S15.2.25WindowsAnyAttempt to add existing foreing key
85632005-02-17
6:30		2005-02-17
19:50		MySQL Server: ReplicationNot a Bug
(7001 days)		S24.1.9Linux (Linux (RHEL 3, x86))AnyReplication of InnoDB table fails with Error_code: 1062 intermittently
401472008-10-19
17:29		2008-11-21
7:12		MySQL Server: InnoDB storage engineNo Feedback
(5628 days)		S15.0.18Linux (SuSe 10.1)AnyInnoDB: All tables / databases Lock / Global Lock ??? - Please help
796172015-12-12
15:16		2019-12-12
20:36		MySQL Server: LockingClosed
(1590 days)		S38.0.18Windows (10)AnyForeign key causing deadlock for UPDATE together with simple transaction
862052017-05-06
23:13		2017-06-10
1:00		MySQL Server: OptimizerNo Feedback
(2506 days)		S35.6/5.7WindowsAnyoptimizer index using select where column in select
437952009-03-23
5:28		2009-03-23
6:15		MySQL Server: InnoDB storage engineNot a Bug
(5506 days)		S25.1.32-communityWindowsAnyAutoincrement increased by 2 on duplicate key condition
35872004-04-28
12:30		2004-05-02
18:14		MySQL ServerClosed
(7292 days)		S25.0.0alphaWindows (WinXP)AnyServer crushes after executing query with connecting two subquery on two fields
89242005-03-03
15:38		2005-04-12
15:16		MySQL ServerClosed
(6947 days)		S35.0.3Other (QNX)Any'Explain' shows different strategy
185962006-03-28
23:38		2012-05-18
20:19		MySQL Cluster: Cluster (NDB) storage engineDuplicate
(6590 days)		S25.1.9Linux (Linux 32 Bit OS)Any binlog schema event auto push causes mysqld errors
186442006-03-30
10:00		2006-05-26
20:41		MySQL Server: DocumentationClosed
(6538 days)		S25.0.18Linux (SuSE linux 9.2 pro)AnyDocumentation Errors for Create Table syntax
255962007-01-12
21:13		2007-02-20
20:30		MySQL Server: InnoDB storage engineClosed
(6268 days)		S25.0.32, 5.0.36-bkLinux (Linux, Windows, Mac OS X 10.4.8)AnyInnoDB Alter Table Failures
324162007-11-15
17:15		2008-07-24
11:57		MySQL Server: InnoDB storage engineNot a Bug
(5748 days)		S15.0.27, 5.0.37, 5.1.22LinuxAnyForeign key constraint violation under concurrent load
368452008-05-21
8:05		2008-06-27
16:37		MySQL Server: PartitionsNo Feedback
(5775 days)		S25.1.23-rc-communityLinux (2.6.9-67.0.4.ELsmp #1 SMP Sun Feb 3 07:06:14 EST 2008 x86_64 x86_64 x86_64 GNU/Linux)AnyPartition with composite keys and joins
608502011-04-13
10:13		2011-04-28
17:22		MySQL Server: MyISAM storage engineCan't repeat
(4740 days)		S25.5.10FreeBSD (amd64)Anymyisamchk: Error reading file '/storage/5/tmp/STVhtaM4' (Errcode: 22)
701152013-08-22
3:19		2013-10-01
1:00		MySQL Server: Pluggable AuthenticationNo Feedback
(3854 days)		S15.6.12Linux (OpenSUSE 12.3)AnyMySQL corrupts sha256 password RSA keys on crash
752872014-12-22
13:44		2015-03-30
15:58		Connector / PythonClosed
(3342 days)		S12.0AnyAnyPython does not work with HASH sahrding in MySQL Fabric
994942020-05-08
21:53		2020-07-06
14:16		Connector / NETCan't repeat
(1383 days)		S28.0Windows (10)x86Unable to remove connector 8.0 .NET
392392008-09-04
11:56		2008-09-05
10:30		MySQL Server: GeneralClosed
(5705 days)		S25.1.26Linux (CentOS 5.2)AnyTemporary server hang
204942006-06-16
6:02		2006-06-22
12:51		MySQL Server: DocumentationClosed
(6511 days)		S25.1Any (All)AnyPartitioning chapter contains dated info
1068182022-03-24
11:23		2022-06-07
2:29		MySQL Server: ReplicationVerified
(682 days)		S25.7,8.0, 5.7.37AnyAnyReplication may fail when XA transactions use replace into statements
752532014-12-18
9:06		2014-12-22
9:36		MySQL ServerNot a Bug
(3406 days)		S35.5.32-logLinux (CentOS)AnyON DUPLICATE KEY UPDATE not working when auto_increment reaches MAX_INT
131082005-09-10
21:43		2005-12-18
5:20		MySQL ServerClosed
(6697 days)		S25.0.12/BK source 5.0MacOS (Mac OSX 10.4.2, Darwin 8.2.0)AnyALTER TABLE does not work on FEDERATED tables
724762014-04-28
23:42		2014-09-16
1:00		MySQL WorkbenchNo Feedback
(3504 days)		S16.1Windows (8.1 64-bit)AnyModifying in Workbench causes update trigger to modify all records instead of 1
1132762023-11-29
5:55		2023-11-29
13:00		MySQL ServerCan't repeat
(142 days)		S38.0.24CentOS (7.9)x86MYSQL does not respond after applications are inserted in batches
122832005-07-30
7:45		2011-02-16
23:43		MySQL Server: DMLWon't fix
(4872 days)		S44.0.21-MaxLinux (SuSE Linux 9.2 pro)AnyMultiple INSERT syntax?
126312005-08-17
21:20		2005-08-18
22:45		MySQL ServerClosed
(6819 days)		S25.0.10Windows (Win XP)AnyINSERT..ON DUPLICATE KEY UPDATE gives errror 1110 (42000) although it shouldn't
279542007-04-19
14:23		2007-05-10
18:07		MySQL Server: GeneralClosed
(6189 days)		S15.0.38AnyAnyINSERT ... ON DUPLICATE KEY UPDATE fails with large multi-insert
467882009-08-18
14:58		2011-02-16
23:44		Connector / JClosed
(5329 days)		S25.1.8Linux (Fedora 10)AnyWhile using ON DUPLICATE KEY UPDATE on a batchRewriteStatements I get exception
504132010-01-18
13:54		2018-11-30
13:16		MySQL Server: InnoDB storage engineClosed
(3811 days)		S15.0.91,5.1.50,5.6.0AnyAnyinsert on duplicate key update sometimes writes binlog position incorrectly
611342011-05-11
14:32		2011-05-17
14:17		Connector / JDuplicate
(4721 days)		S25.1.16AnyAnybad row affected values with INSERT ON DUPLICATE KEY UPDATE
1002522020-07-18
0:51		2020-07-19
5:53		Connector / JDuplicate
(1370 days)		S38.0.21Ubuntux86PreparedStatements with rewriteBatchedStatements does not translate aliases well
288422007-06-01
17:33		2007-06-18
15:08		MySQL Server: ErrorsClosed
(6150 days)		S25.1-bkAnyAnyDifferent 'duplicate key' error code between 5.0 and 5.1
364112008-04-29
19:46		2011-02-16
23:43		MySQL Server: InnoDB storage engineClosed
(5054 days)		S35.1.24, 5.1.25AnyAny"Failed to read auto-increment value from storage engine" in 5.1.24 auto-inc
608082011-04-08
15:06		2011-04-08
16:35		MySQL Server: GeneralDuplicate
(4760 days)		S25.5.11, 5.1.54, 5.1.41Any (win7 64bit, ubuntu 10.04 64 bit)AnyDuplicate entry for key 'group_key'; Can't write, duplicate key in table
891962018-01-11
19:16		2018-01-19
9:50		MySQL Server: ReplicationVerified
(2282 days)		S45.7.20, 8.0.3AnyAnyPlease add GTID in applier error messages.
319752007-10-31
7:36		2009-09-01
13:19		MySQL Server: Command-line ClientsNot a Bug
(5344 days)		S4mysql-connector-java-3.1.8-bin.jarAnyAnyLOAD DATA LOCAL INFILE - Duplicate entry error should come
584932010-11-25
13:32		2010-11-26
8:17		MySQL Server: CharsetsNot a Bug
(4893 days)		S35.1.53AnyAnyRows get skipped as primary duplicates, when they are in fact not.
62872004-10-27
14:41		2004-12-21
17:55		MySQL Server: ReplicationClosed
(7059 days)		S24.0.21-logLinux (Linux)AnySlave skips auto_increment values in Replication with InnoDB
336582008-01-03
16:46		2018-06-24
20:45		MySQL WorkbenchDuplicate
(5946 days)		S25.0.11 SE Beta Rev 2342Windows (XP 32 bit)AnyWorkbench Generates Primary Keys That Are Unnecessary and Can't Be Edited
62052004-10-21
19:56		2004-10-21
21:29		MySQL Server: InnoDB storage engineNot a Bug
(7120 days)		S34.0.14Linux (linux RedHat 7.3)AnyUpdate killed MySQL server
739252014-09-16
9:34		2014-09-16
11:22		MySQL Server: InnoDB storage engineNot a Bug
(3503 days)		S25.5.27Windows (7 64 bit)AnyINSERT INTO ... ON DUPLICATE KEY UPDATE not taking into account multiple column
80582005-01-20
23:03		2005-02-21
16:50		MySQL ServerCan't repeat
(6997 days)		S15.0.3 built todayLinux (Linux/x86)AnyCrashes and out of memory in SQL parsing of stored procs
468642009-08-22
7:05		2011-02-16
23:44		MySQL Server: ReplicationClosed
(5329 days)		S35.1.38, 5.0, 5.1, next bzrAnyAnyIncorrect update of InnoDB table on slave when using trigger with myisam table
1042382021-07-07
15:16		2021-07-08
6:23		MySQL Server: Security: PrivilegesDuplicate
(1016 days)		S38.0.24AnyAnyGrants in prepare with 2 triggers on the same table
281902007-05-02
1:43		2020-05-03
20:45		MySQL ServerDuplicate
(6113 days)		S35.0.37,5.1BKLinux (Fedora Core release 4 (Stentz))AnyON DUPLICATE KEY UPDATE updates the record even if values are identical
903982018-04-12
4:16		2020-02-06
13:34		MySQL Server: OptimizerClosed
(1807 days)		S25.7.17 EE, 5.7.22AnyAnyDuplicate entry for key '<group_key>' error
258532007-01-25
16:20		2007-06-20
1:01		MySQL Server: MyISAM storage engineClosed
(6148 days)		S15.0.27,5.0.40BK, 5.1.18BKLinux (Linux Fedora Core 5)Anykey_cache_block_size=4MB causes table corruptions + duplicate key errors
480292009-10-13
19:30		2011-02-16
23:44		MySQL Server: InnoDB storage engineNo Feedback
(5271 days)		S35.1.34LinuxAnyDeadlock between INSERT...ON DUPLICATE KEY... and DELETE on InnoDB
683322013-02-10
16:34		2013-02-11
21:32		MySQL Server: GeneralCan't repeat
(4085 days)		S25.5.30,5.6.10AnyAnyValue for mysql_affected_rows() became 1 for ON DUPLICATE KEY after 5.5.15
815782016-05-24
18:38		2016-05-24
18:51		MySQL Server: DMLDuplicate
(2887 days)		S35.5.49AnyAnyINSERT ON DUPLICATE KEY UPDATE statement returning 1062 instead of 1452
945412019-03-04
9:32		2019-09-04
15:47		MySQL Server: InnoDB storage engineClosed
(1689 days)		S25.7.25AnyAnyAssertion on import via Transportable Tablespace
302782007-08-07
16:47		2012-05-18
20:19		MySQL Server: InnoDB storage engineNo Feedback
(5321 days)		S55.1.20AnyAnyInnoDB: performance regression for update_with_key_prefix operation(mysql-bench)
918232018-07-29
18:25		2018-10-28
22:02		MySQL Server: InnoDB storage engineClosed
(2000 days)		S38.0.12Ubuntu (14.04)x86innodb.innodb test leads to crash on MySQL 8.0.12
127072005-08-21
23:33		2022-12-04
20:45		MySQL Server: DDLVerified
(5553 days)		S44.0, 5.1Windows (Windows and Linux)AnyThe ON UPDATE and DEFAULT constructs need an Enahncement
459012009-07-02
9:24		2009-07-02
14:03		MySQL Server: InnoDB storage engineNot a Bug
(5405 days)		S35,1.30, 5.1.33, 5.1.35, 5.1.36Windows (XP)AnyCannot do SELECT FOR UPDATE with small amount of records.
1117032023-07-10
6:40		2023-07-15
1:58		MySQL Server: DocumentationNot a Bug
(279 days)		S38.0.33, 5.7.42AnyAnyINSERT ON DUPLICATE KEY locks INSERT if table have many PRIMARY and UNIQUE key
24382004-01-18
16:42		2004-02-02
9:34		MySQL ServerClosed
(7382 days)		S24.1.1Linux (Mandrake Linux 9.2/WindowsXP)AnyRunaway memory consumption
742182014-10-03
23:02		2019-10-29
15:02		MySQL Cluster: Cluster (NDB) storage engineClosed
(1634 days)		S35.6.19-ndb-7.3.6AnyAnyMissing table name in error message 1022
54342004-09-06
16:32		2004-09-06
20:24		MySQL ServerNot a Bug
(7165 days)		S24.0.15-max-debugWindows (win2k)Anyconstraint name not honored for foreign keys
109232005-05-27
17:12		2006-04-04
8:10		MySQL Cluster: Cluster (NDB) storage engineClosed
(6590 days)		S45.1-wl2325Linux (Linux)AnySlave cluster not always updated properly from master cluster with two mysqld
225202006-09-20
14:26		2012-05-18
20:19		MySQL ServerDuplicate
(6399 days)		S35.0.26-BK, 5.0.22-max, 1.2.3rc, 1.2.4rcLinux (Linux, Mac OS X)Anytables without a primary key but with a unique index report it is a primary key
261262007-02-06
21:20		2011-02-16
23:43		MySQL Server: ErrorsNo Feedback
(5746 days)		S24.1.22Linux (Linux, 2.6.9 kernel)Any"Unknown error" during a long running query.
329482007-12-04
1:09		2007-12-13
10:07		MySQL Server: PartitionsClosed
(5972 days)		S25.1AnyAnyFKs allowed to reference partitioned table
408012008-11-17
19:52		2009-05-15
12:56		MySQL Server: Falcon storage engineClosed
(5453 days)		S36.0.8AnyAnyFalcon garbage collection can erase valid key values
436372009-03-13
16:53		2009-03-18
12:51		Connector / JNot a Bug
(5511 days)		S25.1.31-community-logLinux (inux version 2.6.18-92.1.22.el5)AnyUnknown type '246 in column 10 of 24 in binary-encoded result set
727452014-05-26
4:28		2014-05-26
5:48		MySQL Server: OptimizerVerified
(3616 days)		S25.5.37, 5.5.38AnyAnyWrong Results When Using Intersect
696992013-07-09
15:31		2013-07-10
5:21		MySQL Server: InnoDB storage engineDuplicate
(3936 days)		S25.6.11LinuxAnyadd foreign key error
524732010-03-30
12:51		2021-05-02
20:45		MySQL Cluster: ReplicationVerified
(5109 days)		S3mysql-5.1-telco-6.3AnyAnyNDB inserts row when updating slave's empty table (with PK)
717352014-02-16
12:59		2016-10-27
13:34		MySQL Server: DocumentationClosed
(2731 days)		S35.6AnyAnyManual does not explain locks set by SELECT ... FOR UPDATE properly
210852006-07-16
21:33		2006-07-27
6:14		MySQL Server: CharsetsNot a Bug
(6476 days)		S35.0.25_BK, 5.0.21Linux (Red Hat Enterprise Linux ES rele)Anydatabase collate set overriden by specifying only character set on column
387492008-08-12
11:39		2008-08-13
18:29		MySQL Server: DMLNot a Bug
(5728 days)		S15.0.51a-6Linux (debian lenny)AnyDuplicate error on INSERT - primary key auto increment column
26692004-02-06
17:21		2004-02-09
15:34		MySQL Server: InnoDB storage engineNot a Bug
(7375 days)		S14.0.16Linux (Linux - Mandrake 9.0)AnyUpdate fails for no reason - Incorrect "1062 = Duplicate entry"
588642010-12-10
12:13		2011-07-19
15:09		MySQL Server: DocumentationClosed
(4658 days)		S45.1AnyAnyClarify LAST_INSERT_ID() behavior on update by INSERT ON DUPLICATE KEY UPDATE
1076562022-06-25
13:55		2022-07-01
12:09		MySQL ServerNot a Bug
(658 days)		S35.7.29Linuxx86insert into on duplicate key update with PRIMARY cause a deadlock
436742009-03-16
12:42		2009-03-16
12:54		MySQL Server: CharsetsNot a Bug
(5513 days)		S26.0.10-alpha-debug Linux (suse-linux-gnu on i686 (Source distribution))AnyDuplicate entry 'а' with utf8mb3, while the same with utf8 in 5.1 is working.
469762009-08-28
15:00		2013-01-29
23:30		MySQL Server: DocumentationClosed
(4098 days)		S35.1.33AnyAnyDuplicate erro output different for 5.1.33 from dev article
704092013-09-24
15:35		2014-05-28
5:45		Connector / NETClosed
(3614 days)		S16.7.4Windows (server 2008)AnyMySqlSessionStateStore : exception "Duplicate entry"
825442016-08-11
14:36		2016-08-17
14:57		MySQL Server: DocumentationClosed
(2802 days)		S35.7.14AnyAnyDuplicate entry '' for key '<group_key>' while doing group by
860532017-04-24
9:20		2018-10-21
20:45		MySQL ServerNo Feedback
(2522 days)		S35.7.11AnyAnyMySQL 1062 –Duplicate entry for key without duplicate value
986002020-02-14
11:48		2021-12-21
7:40		MySQL Server: DMLVerified
(1526 days)		S35.7,8.0, 5.7.29, 8.0.19AnyAnyOptimize table fails with duplicate entry on UNIQUE KEY
1017062020-11-21
16:51		2020-12-03
14:25		MySQL Server: InnoDB storage engineClosed
(1233 days)		S38.0AnyAnycheck table can't find duplicate error in table
1041442021-06-29
12:14		2021-06-30
13:18		MySQL Server: DMLVerified
(1025 days)		S28.0.25, 5.7.34, 5.6.51AnyAnyREPLACE INTO removes the row
182762006-03-16
11:04		2006-03-23
16:16		MySQL ServerWon't fix
(6602 days)		S35.0.19IBM AIX (AIX 4.2.1)Anydoes not build (failure to link) on AIX
552222010-07-13
16:52		2019-05-15
10:40		MySQL Server: InnoDB storage engineClosed
(4848 days)		S25.1.x, 5.1.49-bzrAny (Windows 7, Mac OS X)AnyMysqldump table names case bug in REFERENCES clause
828092016-08-31
7:20		2016-09-10
9:38		MySQL UtilitiesVerified
(2778 days)		S31.6.4Red HatAnymysqldbcompare output error SQL when 2 tables having different primary keys
881112017-10-16
17:19		2019-05-17
19:22		MySQL Server: DDLClosed
(1799 days)		S35.7, 8.0AnyAnygenerated column not accept foreign key for column included
471752009-09-07
13:25		2011-02-16
23:44		MySQL Server: Row Based Replication ( RBR )Closed
(5157 days)		S35.1,5.4AnyAnyfailing INSERT, transaction, replication out of sync
724072014-04-20
20:47		2014-04-24
17:30		MySQL Server: LockingNot a Bug
(3648 days)		S15.6.10, 5.6.17Linux (Centos 6.5/6.3)AnyUnclear Deadlock conditions with delete / update statement.
804242016-02-18
9:14		2017-01-03
11:46		MySQL Server: OptimizerDuplicate
(2663 days)		S35.6, 5.7.11AnyAnyEXPLAIN output depends on binlog_format setting
29962004-02-27
11:57		2020-03-09
14:06		MySQL ServerClosed
(7344 days)		S24.0.18Linux (Linux 2.4.25 (Slackware 9.1+))Anyupdate on left join can change non matching record in second table.
93132005-03-21
13:19		2005-03-21
13:34		MySQL Server: ReplicationClosed
(6969 days)		S24.1.10FreeBSD (FreeBSD 4.11)AnyMulti-line statements not replicated properly?
597632011-01-27
0:16		2011-05-04
19:12		MySQL Server: InnoDB Plugin storage engineNot a Bug
(4734 days)		S35.1,5.5AnyAnywhen does innodb compact blocks on delete
768082015-04-23
12:33		2016-05-25
17:28		MySQL Server: Stored RoutinesClosed
(2886 days)		S35.1.73 LinuxAnyfunction updating a view fails to find table that actually exists
145602005-11-02
2:30		2006-08-22
14:01		MySQL Server: Row Based Replication ( RBR )Can't repeat
(6450 days)		S25.1.2Linux (Linux)AnyCluster RBR: Slave stops after processing "Create Procedure" with Error in Writ
520612010-03-15
10:36		2011-02-16
23:44		MySQL Server: DocumentationClosed
(5147 days)		S3mysql-5.1AnyAnyMySQL Cluster docs : Wrong parameter effect description
781442015-08-19
22:34		2015-11-24
9:07		MySQL Server: Stored RoutinesVerified
(3164 days)		S35.6.19-log Linux (RDS)AnyError handler not being triggered for multi-table update
243022006-11-14
15:33		2006-11-15
10:48		MySQL ServerNot a Bug
(6365 days)		S24.1.21Windows (Windows)AnyINSERT ...SELECT...ON DUPLICATE KEY not recognizing source field(s)
270332007-03-11
14:09		2007-03-20
17:43		MySQL ServerClosed
(6240 days)		S25.0.37Windows (Windows 2003/Linux)AnyLAST_INSERT_ID returns 0 on using INSERT... ON DUPLICATE KEY UPDATE ...
273872007-03-23
4:08		2007-03-30
17:06		MySQL Server: GeneralNot a Bug
(6230 days)		S2All 5.0 and 5.1, 4.1, 5.2Any (All)AnyError checking is incorrect in INSERT ... ON DUPLICATE KEY UPDATE
369202008-05-23
15:27		2008-10-31
13:03		MySQL ServerCan't repeat
(5649 days)		S15.1.xWindows (XP32, VISTA64)AnyServer (5.1.x) stops error Can't write; duplicate key in table 'C\Windows\temp'
1062402022-01-21
22:00		2022-03-29
22:25		Connector / JClosed
(752 days)		S38.0.25, 8.0.28AnyAnyStringIndexOutOfBoundsException when VALUE is at the end of the query
17282003-10-31
17:01		2003-12-13
4:44		MySQL ServerWon't fix
(7433 days)		S24.0.16Linux (Red Hat linux 8.0)Anylock timeout not consistently returned by mysql_query()
114082005-06-17
8:30		2005-06-17
8:37		MySQL Server: InnoDB storage engineNot a Bug
(6881 days)		S35.0.7Windows (win2000)Anyshow table status return wrong
1017182020-11-23
12:35		2020-11-24
5:16		MySQL Server: DMLVerified
(1243 days)		S58.0, 8.0.22LinuxAnyall new.x in before trigger marked in write_set may cause update use temp table
830452016-09-20
7:11		2016-09-20
8:55		MySQL Server: InnoDB storage engineDuplicate
(2768 days)		S25.6.17CentOS (6.5)AnyUnique index allows duplicates without null values
541152010-05-31
18:49		2011-02-16
23:44		MySQL Server: DocumentationClosed
(4959 days)		S35.1AnyAnyCluster replication conflict resolution docs confuse me
356342008-03-28
8:54		2008-10-01
15:08		MySQL Server: Command-line ClientsWon't fix
(5679 days)		S45.1-bkAnyAny'mysql' client: 'source' should stop after first failed command
466752009-08-12
13:35		2011-08-19
15:15		MySQL Server: GeneralClosed
(4627 days)		S3server 5.1.37Any (MS Windows, Mac, Linux)AnyON DUPLICATE KEY UPDATE and updateCount() possibly wrong
232332006-10-12
22:28		2007-04-04
4:03		MySQL ServerClosed
(6225 days)		S35.1.11-beta and 5.0.26/5.0BK/5.1BKWindows (WINDOWS)AnyNO_AUTO_VALUE_ON_ZERO and INSERT...ON DUPLICATE cause insertion failure
198612006-05-16
19:47		2016-01-03
20:45		MySQL Server: InnoDB storage engineDuplicate
(6540 days)		S35.0.22-BK, 5.0.18Linux (Linux)Any[reference_definition] in [column_definition] section of create table statement
470312009-08-31
23:43		2011-02-16
23:44		MySQL Server: TestsCan't repeat
(5344 days)		S35.0.85Linux (Red Hat Enterprise Linux)Anyview test case fails
482702009-10-23
16:18		2011-02-16
23:44		TestsCan't repeat
(5292 days)		S35.0.85LinuxAnymysql-test view.test fails
521762010-03-18
11:11		2011-02-16
23:44		MySQL Server: InnoDB storage engineNo Feedback
(5109 days)		S25.0.90WindowsAnyMYSQL-NT goes in crash under windowxp
310872007-09-18
17:47		2007-10-18
18:09		MySQL Server: Stored RoutinesNo Feedback
(6028 days)		S1mysql-5.0.44-r1Linux (recent up2date Gentoo box)AnySecond call to stored procedure crashed server
593842011-01-10
5:05		2012-03-25
21:27		MySQL Server: InnoDB storage engineClosed
(4408 days)		S45.5.8, 5.5.11LinuxAnyslow INSERTs, sometimes
127992005-08-25
9:46		2020-05-03
20:45		MySQL Server: OptimizerVerified
(5315 days)		S35.0.10-log, 4.1.13a-log on win, 4.1 on RHES3.0Windows (windows xp)Anyone result returned when change from summer time causes dup unique key recs
27922004-02-14
6:03		2004-09-14
13:03		MySQL Server: InnoDB storage engineNot a Bug
(7157 days)		S34.0.16Linux (Debian 3.0)Any2nd foreign key behaviour "On * do-sth" is missing in comment of Table-Status
110802005-06-03
17:32		2005-06-07
10:52		MySQL Server: OptimizerClosed
(6891 days)		S35.0.7Linux (Linux/x86)AnyMulti-row REPLACE fails on a duplicate key error on an AUTO-INC column
35122004-04-20
2:11		2004-04-27
16:26		MySQL ServerNot a Bug
(7297 days)		S34.0.18Windows (Win2K)Anymysterious failure of insert due to duplicate key
107152005-05-18
15:32		2005-07-11
15:12		MySQL Server: MyISAM storage engineNo Feedback
(6857 days)		S14.1Linux (Linux)AnyPrimary key being violated by duplicate key entries
532902010-04-29
15:31		2011-02-16
23:44		MySQL Server: InnoDB Plugin storage engineClosed
(4847 days)		S35.1.46, plugin 1.0.7AnyAnywrong duplicate key error when adding a unique index via fast alter table
960492019-07-01
14:09		2019-07-02
8:21		MySQL Server: DMLVerified
(1753 days)		S48.0AnyAnyIGNORE clause which doesn't override strict mode
83332005-02-05
7:52		2005-02-05
8:00		MySQL ServerCan't repeat
(7013 days)		S33.23.49Linux (Linux or Apache web server)Anyaccepting duplicate entries in a feild which is set primary
102922005-05-01
16:10		2005-06-03
12:19		MySQL Server: OptimizerClosed
(6895 days)		S25.0.4 max ntWindows (windows 2000 sp4)AnyDuplicate entry error in SELECT
292402007-06-20
15:08		2007-08-07
7:03		MySQL Server: Falcon storage engineClosed
(6100 days)		S36.0.1-alpha-debugLinux (SUSE 10 64-bit)AnyFalcon: duplicate-key error when there's no duplicate key
1028332021-03-05
18:04		2021-03-05
20:25		MySQL Server: FULLTEXT searchVerified
(1141 days)		S15.7.33Ubuntux86Fulltext index error [ERROR] InnoDB: Duplicate FTS_DOC_ID value on table
136902005-10-02
16:28		2005-11-17
9:50		MySQL ServerNo Feedback
(6728 days)		S34.1.12a-ntWindows (WinXP Pro)AnyERROR 1216 (23000): Cannot add or update a child row: a foreign key constraint
336642008-01-03
17:41		2008-01-28
18:44		MySQL WorkbenchClosed
(5926 days)		S25.0.11 SE Beta Rev 2342Windows (XP 32 bit)AnyWorkbench Allows Foreign Relationships With Unmatching Data Definitions
746092014-10-28
18:52		2019-04-18
10:15		MySQL Server: InnoDB storage engineDuplicate
(1828 days)		S35.6.21/5.7LinuxAnyUnable to update Foreign Key created as NOT NULL to table named with a Dollar $
673752012-10-25
5:46		2014-01-13
17:58		Connector / JNot a Bug
(3749 days)		S25.5WindowsAnyON DUPLICATE KEY UPDATE produces wrong affectedRows
788542015-10-16
1:21		2015-10-27
3:28		MySQL Server: DocumentationNot a Bug
(3097 days)		S35.6, 5.7AnyAny"more than one unique or primary key"
434542009-03-06
13:38		2009-03-06
15:09		MySQL Server: ParserNot a Bug
(5523 days)		S25.1.30LinuxAnyGROUP BY makes columns unrecognized when doing INSERT SELECT ... ON DUPLICATE K
1031372021-03-29
10:03		2021-05-17
14:35		MySQL Server: DocumentationClosed
(1079 days)		S38.0.20AnyAnyDeprecated VALUES vs INSERT SELECT ON DUPLICATE KEY UPDATE
185072006-03-25
11:33		2016-01-03
20:45		MySQL Server: InnoDB storage engineDuplicate
(6600 days)		S35.0.19 and 5.1.7-betaWindows (windows xp pro)Anyforeign key
504562010-01-19
20:17		2010-01-19
21:08		MySQL Server: PartitionsNot a Bug
(5204 days)		S25.1.42-community-logAnyAnyMySQl partitioning does not use the correct partitions
777982015-07-22
10:56		2016-03-24
16:45		MySQL Cluster: NDB APICan't repeat
(3112 days)		S27.4.6-1.el7.x86_64Oracle Linux (7.1)AnyERROR 1553 (HY000): Cannot drop index needed by foreign constraint
812502016-04-29
19:57		2016-11-16
15:59		MySQL Server: OptimizerClosed
(2711 days)		S2mysql 5.7.9, 5.7.12Linux (centos6.5)Anysql plan is not right according to optimizer_trace
265072007-02-20
17:59		2012-10-16
5:21		MySQL Server: InnoDB storage engineNot a Bug
(4203 days)		S25.0.27-max-log, 5.1.36, 5.0, 5.1 bzrLinux (Linux, Fedora Core 6)AnyError 121 upon creating InnoDB table (in replicated setup)
622102011-08-19
11:47		2012-02-02
19:59		MySQL Server: InnoDB Plugin storage engineCan't repeat
(4460 days)		S25.1.48 (1.0.9)Linux (2.6.18-164.el5)Anymemory corruption for THD after deadlock in foreign key reference constrain
258262007-01-24
13:26		2022-12-04
20:45		MySQL Server: ErrorsVerified
(6272 days)		S45.0.36-BK, mysql-5.2.0-falcon-alpha-win32Windows (Windows 2000/XP)AnyUnique keys: show constraint name in error message
417002008-12-23
0:40		2013-12-20
6:53		MySQL Server: GeneralWon't fix
(3773 days)		S36.1.0-alpha-debugLinux (SUSE 10.0 / 32-bit)AnyForeign keys: failure with update cascade and duplicate key
36752004-05-06
9:33		2004-05-06
19:32		MySQL ServerNot a Bug
(7288 days)		S24.0+4.1Windows (Windows 2000)AnyUPDATE on multiple tables doesn't work correctly when inner joining by a comma
46662004-07-21
3:30		2004-08-06
16:14		Connector / NETClosed
(7196 days)		S20.7.6.15073Windows (Win XP Pro)AnyMySqlDataAdapter.Update does not update Database
571532010-09-30
20:32		2018-02-11
13:02		MySQL Server: DMLCan't repeat
(2259 days)		S55.1.51Other (Centos 5.5)AnyPerformance of call to POWER(LOG(EXP(0.25)),0.5) slower than expected on 5.1.51
696592013-07-03
10:30		2015-04-22
17:53		MySQL Server: InstallingUnsupported
(3943 days)		S15.6.12Windows (XP SP3)AnyMySQL server 5.6.12 configuration failed
891012018-01-04
1:52		2020-03-30
12:12		MySQL Server: DMLVerified
(2283 days)		S25.7.20AnyAnyMySQL server hang when gtid_mode=on and innodb_thread_concurrency>0
604892011-03-16
13:44		2011-07-05
16:36		MySQL Server: DocumentationNot a Bug
(4672 days)		S35.5.10Windows (XP)AnyUpdate returnd god result but CURRENT_TIMESTAMP field not updated
97252005-04-07
16:36		2005-07-12
5:06		MySQL ServerClosed
(6856 days)		S34.1.11Any (*)Any"disapearing query/hang" and "unknown error" with "on duplicate key update"
114422005-06-20
2:25		2011-02-16
23:43		MySQL Server: DMLVerified
(6323 days)		S45.0Any (All)AnyINSERT... ON DUPLICATE KEY UPDATE; w/ values taken from the INSERT part
209162006-07-08
17:35		2006-10-30
19:08		MySQL Server: DocumentationClosed
(6381 days)		S34.1.13, 5.0.21Linux (Linux)Anyambigous field with INSERT ... SELECT ... ON DUPLICATE KEY UPDATE
358562008-04-05
23:31		2008-10-16
4:30		MySQL Server: InnoDB storage engineDuplicate
(5664 days)		S35.0.45AnyAnyfalse unique constraint violation on multiple updates
408722008-11-19
23:09		2016-10-16
20:45		MySQL Server: ReplicationNo Feedback
(5599 days)		S25.0.45, 5.0.51a (ICC)LinuxAnySlave doesn't get replicated properly with ON DUPLICATE KEY UPDATE statements
445662009-04-30
3:53		2023-03-10
7:52		MySQL Cluster: ReplicationNo Feedback
(5431 days)		S3mysql-5.1-telco-6.3LinuxAnyError on Innodb to NDB replication with UPDATE statements
705832013-10-10
8:14		2014-08-06
17:08		MySQL Server: ReplicationClosed
(3579 days)		S25.6.14AnyAnyINSERT ON DUPLICATE KEY UPDATE failing after MySQL 5.6 upgrade.
873712017-08-10
11:42		2017-10-05
18:16		MySQL Server: Stored RoutinesClosed
(2388 days)		S25.7.17CentOSAnyBug in "INSERT... ON DUPLICATE KEY UPDATE" query
280002007-04-21
14:59		2007-05-17
14:24		MySQL ServerClosed
(6182 days)		S35.0.37,5.1, 6.0-falcon-bkAnyAnyMySQL hangs when using INSERT IGNORE ... ON DUPLICATE KEY
504392010-01-19
11:16		2011-09-30
18:19		MySQL Server: ReplicationClosed
(4585 days)		S25.1+AnyAnymark INSERT...SEL...ON DUP KEY UPD,REPLACE...SEL,CREATE...[IGN|REPL] SEL unsafe
542012010-06-03
12:18		2015-08-26
20:25		MySQL Server: ReplicationClosed
(4375 days)		S25.1.47AnyAny"SET INSERT_ID" event must be ignored if corresponding event is ignored
618502011-07-13
8:19		2011-07-13
8:55		Connector / JClosed
(4664 days)		S35.1Linux (Squeeze)AnyJDBC: return value of INSERT ON DUPLICATE KEY does not match command line client
100952005-04-22
12:38		2005-05-19
2:06		MySQL Server: OptimizerClosed
(6910 days)		S14.0.24Linux (linux)AnyAND/OR - get diff result
106492005-05-15
23:19		2006-09-30
12:18		MySQL ServerDuplicate
(6411 days)		S34.1.11Linux (Red Hat Linux 9)Any"where not in" with subquery produces incorrect results
204982006-06-16
10:25		2006-06-26
13:24		MySQL Cluster: Cluster (NDB) storage engineClosed
(6507 days)		S25.1.12Linux (Linux/all)AnyWrong usage of mysys/hash.c
385502008-08-04
21:47		2018-09-09
20:45		MySQL Server: OptimizerVerified
(5664 days)		S55.0.60, 5.1AnyAnymultiple optimizer bugs for queries with references from preceding table
647752012-03-27
9:53		2012-04-29
1:00		MySQL Server: Federated storage engineNo Feedback
(4374 days)		S25.1.61Linux (open suse 11.4)AnyLeft join on federated.varchar(15) = innodb.char(25) gives bad query plan, crash
750522014-12-01
6:59		2019-05-15
12:56		Tests: ServerWon't fix
(1801 days)		S35.5, 5.5.42AnyAnyforeign-keys testcase mismerged in 5.5
994362020-05-04
11:51		2020-09-28
14:46		MySQL Cluster: Cluster (NDB) storage engineNot a Bug
(1299 days)		S38.0.20Red Hat (8)AnyNDB fully replicated tables only in node group 0, not in node group 1
450522009-05-24
7:46		2011-02-16
23:44		MySQL ServerClosed
(5055 days)		S26.0.10-alpha,5.4Linux (OpenSuse 10.3)AnyALTER TABLE ADD COLUMN crashes server with multiple foreign key columns
465252009-08-03
10:16		2011-02-16
23:44		MySQL Server: InnoDB storage engineCan't repeat
(5030 days)		S5LinuxAny5.1.36: innodb: updates / alter table exremley slow
79362005-01-16
1:15		2005-06-07
15:50		MySQL Server: Memory storage engineOpen
(6891 days)		S44.0.17FreeBSD (FreeBSD)AnyHEAP table HASH not optimized for searches that usually do not match KEY
1023432021-01-22
11:08		2021-01-22
14:05		MySQL Server: DMLNot a Bug
(1183 days)		S4AnyAnyUse FOREIGN KEY description for JOIN tables
676152012-11-16
16:21		2018-01-26
16:20		MySQL Server: InnoDB storage engineNot a Bug
(2275 days)		S25.5.28Linux (6.2)AnyMassive conccurent inserts and lock wait timeout
700862013-08-19
16:06		2013-11-03
1:00		MySQL Server: OptimizerNo Feedback
(3821 days)		S25.6.13-logLinux (2.6.16.33-xenU x86_64)AnyDegraded performance for index_merge updates
853532017-03-08
1:26		2017-03-09
8:34		MySQL Server: ErrorsVerified
(2598 days)		S45.6,5.7.17AnyAnyAmbiguous Error Message in safe_updates mode
170862006-02-03
0:39		2006-07-03
14:42		MySQL Cluster: Cluster (NDB) storage engineClosed
(6500 days)		S34.1 ->Linux (Linux 32 Bit OS)Anyrpl_auto_increment.test fix for ndb
567312010-09-11
14:43		2018-10-21
20:45		Connector / ODBCNo Feedback
(3217 days)		S25.1.6MacOS (likely other OSes)AnySecond SQLSetPos(Update) not posting update to database
69462004-12-02
14:31		2006-02-14
14:28		MySQL ServerWon't fix
(6639 days)		S4*Any (*)AnyINSERT ... ON DUPLICATE KEY UPDATE without INSERT
640252012-01-13
14:21		2012-01-15
19:15		MySQL Server: DMLVerified
(4480 days)		S35.1.61, 5.5.15AnyAnyON DUPLICATE KEY UPDATE sets auto_increment column value to 0
391552008-09-01
11:29		2008-10-01
14:50		MySQL Server: ReplicationNo Feedback
(5679 days)		S15.1.23Windows (2000 sp4)AnyReplication error duplicate entry
751892014-12-12
7:09		2014-12-19
22:15		MySQL Server: TestsVerified
(3409 days)		S35.6AnyAnyengines suite tests depending on InnoDB implementation details
641392012-01-26
22:20		2021-09-05
20:45		MySQL Cluster: ReplicationVerified
(4467 days)		S3mysql-cluster-gpl-7.2.2AnyAnyDuplicate INSERTs in binary log for NDB tables when binlog_format=STATEMENT
768952015-04-30
6:06		2021-08-15
17:57		MySQL Server: InnoDB storage engineNot a Bug
(3277 days)		S25.6.24AnyAnyAdding new column OR Drop column causes duplicate PK error
140552005-10-16
4:18		2005-10-18
22:02		MySQL ServerWon't fix
(6758 days)		S24.1.16Any (any)AnyAES_DECRYPT returns NULL on valid input
36592004-05-05
10:34		2004-07-19
13:39		MySQL Cluster: Cluster (NDB) storage engineClosed
(7214 days)		S1mysql-4.1.2-alpha bkFermiLinux LTS 3.01Any>1 concurrent update causes deadlock
267432007-03-01
9:02		2007-04-30
9:06		MySQL Migration ToolkitClosed
(6199 days)		S31.1.11, 1.1.10, 1.1.9Windows (Win XP)AnyCreated SQL Syntax failed for "DEFAULT USER"
336562008-01-03
16:28		2008-02-04
20:49		MySQL WorkbenchClosed
(5919 days)		S25.0.11 SE Beta Rev 2342Windows (XP 32 bit)AnyWorkbench Generates Invalid Foreign Index Statements
1064922022-02-17
14:37		2022-11-22
21:08		MySQL Server: InstallingWon't fix
(765 days)		S35.7Debian (stretch)Anyhe following signatures were invalid: EXPKEYSIG 8C718D3B5072E1F5
288672007-06-04
7:45		2007-06-04
8:29		MySQL ServerNot a Bug
(6164 days)		S25.0.41FreeBSD (6.2 amd64)AnyINSERT ...ON DUPLICATE KEY UPDATE,affected_rows diff between 5.0.18 and 5.0.41
511402010-02-12
12:06		2010-02-13
7:42		MySQL Server: InnoDB storage engineNot a Bug
(5179 days)		S35.1.31LinuxAnyDeadlock instead of timeout when inserting the same row from two transactions
542502010-06-05
3:18		2018-12-09
9:12		MySQL Server: ReplicationVerified
(5066 days)		S4AnyAnyFeature request for RBR auto-fix slave functionality
642902012-02-10
6:24		2012-02-10
15:41		MySQL Server: DMLNot a Bug
(4452 days)		S35.5.15WindowsAnyINSERT ON DUPLICATE KEY UPDATE can't work with primary key value equals zero
729212014-06-09
17:10		2014-06-25
15:27		MySQL Server: ErrorsVerified
(3601 days)		S45.5+AnyAnynote 1592: unsafe statement...on duplicate key update issued for safe statements
945822019-03-06
21:06		2019-03-06
22:10		MySQL Server: DMLClosed
(1871 days)		S38.0.12AnyAnyPrimary key 1 causes ON DUPLICATE KEY UPDATE to use erroneous value
1144462024-03-21
14:30		2024-03-22
11:07		MySQL Server: InnoDB storage engineNot a Bug
(29 days)		S38.0.*AnyAnyA deadlock example cause by lock inherit
814862016-05-18
11:43		2016-05-24
18:51		MySQL Server: DMLClosed
(2892 days)		S35.6.30, 5.5.49DebianAnyERROR 1452 throws as ERROR 1062 if query has ON DUPLICATE stament
370162008-05-27
19:25		2011-02-16
23:43		MySQL Server: DDLClosed
(5559 days)		S35.1, 6.0-bkAnyAnyTRUNCATE TABLE removes some rows but not all
537122010-05-17
16:13		2011-02-16
23:44		MySQL Server: GeneralNo Feedback
(5054 days)		S25.1.46SolarisAnyORDER BY causes incorrect query result
673042012-10-19
20:54		2012-11-24
1:00		MySQL Workbench: ModelingNo Feedback
(4165 days)		S35.2.44 win32.msiWindowsAnymySQL workbench is dropping foreign keys durring sycronize with DB when updating
702452013-09-04
21:45		2013-09-05
16:57		MySQL Server: OptimizerNot a Bug
(3879 days)		S25.6.13Linux (2.6.16.33-xenU x86_64)Anyincorrect costing for range scan causes optimizer to choose incorrect index
256732007-01-17
9:27		2007-03-15
2:46		MySQL Server: MyISAM storage engineClosed
(6245 days)		S15.0.34,5.0.36-BK,5.1.15-BK *Anyspatial index corruption, error 126 incorrect key file for table
417542008-12-26
12:03		2017-05-21
20:45		MySQL Server: ReplicationDuplicate
(5505 days)		S25.0.70, 5.1.30, 6.0.9AnyAny'Cannot add or update a child row: a foreign key constraint fails' on SBR+Innodb
1058082021-12-06
12:18		2021-12-06
14:15		MySQL Server: OptimizerNot a Bug
(865 days)		S5MySQL 8.0.27AnyAnyConfusing partition pruning policy for `NULL condition` on DATATIME field.
150452005-11-18
9:35		2018-06-14
16:56		MySQL Server: InnoDB storage engineVerified
(5090 days)		S44.1Windows (windows xp)Anycan't drop and recreate foreign key in a single ALTER TABLE statement
733002014-07-16
18:03		2015-04-01
4:41		MySQL Server: InnoDB storage engineClosed
(3536 days)		S35.7.5AnyAnyinnodb.log_file_name fails sproadically on pb2
940682019-01-25
19:19		2019-03-06
14:33		MySQL ServerNot a Bug
(1871 days)		S28.0.13LinuxAnyIndex performance degradation, ~50 times slower after 30 hours. reproduceable
651112012-04-26
9:31		2012-05-15
18:33		MySQL Server: InnoDB Plugin storage engineClosed
(4357 days)		S25.6,5.5LinuxAnyInnodb sometimes fails to update rows inserted by a concurrent transaction
768032015-04-23
8:42		2019-01-25
1:21		MySQL Server: InnoDB storage engineClosed
(1911 days)		S35.1, 5.5, 5.6, 5.7, 8.0AnyAnyInnoDB: Unlock row could not find a 2 mode lock on the record
238422006-11-01
15:33		2006-11-02
3:52		MySQL ServerNot a Bug
(6378 days)		S35.0.27-community-ntWindows (Windows XP)AnyUnsigned check on "ON DUPLICATE KEY" query
291802007-06-18
16:48		2007-06-26
12:57		MySQL ServerClosed
(6142 days)		S25.0.41-logLinuxAnyINSERT ... ON DUPLICATE KEY don't work correctly
420872009-01-13
15:52		2011-02-16
23:43		MySQL Server: GeneralVerified
(5511 days)		S25.1.30AnyAnyStatement.executeUpdate() gives strange update count with INSERT ...ON DUPLICATE
159322005-12-22
9:31		2006-01-22
13:41		MySQL ServerNo Feedback
(6662 days)		S35.0.17Linux (linux)Anywhy can't indexes updated?
184682006-03-23
19:05		2012-05-18
20:19		MySQL Cluster: Cluster (NDB) storage engineDuplicate
(6602 days)		S35.1.8Linux (Linux 32 Bit OS)AnyCluster is not optimizing on indexes provided. "Impossible WHERE noticed"
444472009-04-23
21:25		2009-04-24
6:05		MySQL Server: Information schemaNot a Bug
(5474 days)		S35.0.51aAnyAnyIncorrect clustered index in InnoDB table?
608762011-04-15
6:20		2011-04-23
16:47		MySQL ServerNot a Bug
(4745 days)		S2mysql Ver 14.12 Distrib 5.0.45Linux (Red Hat Enterprise Linux Server release 5.3 )AnyA Floating Point Issue
657012012-06-21
16:26		2014-10-10
18:52		MySQL Server: InnoDB storage engineClosed
(3964 days)		S25.5.24, 5.5.26, 5.6.6Linux (CentOS 6.2)Anycharacter set mismatch when altering foreign keys can lead to missing tables
720332014-03-13
14:50		2014-03-14
8:24		MySQL Server: MyISAM storage engineVerified
(3689 days)		S35.6.18AnyAnyNo warning when setting KEY_BLOCK_SIZE on a MyISAM index, value silently ignored
726902014-05-20
9:13		2014-07-15
8:59		MySQL Server: OptimizerNot a Bug
(3608 days)		S25.6.17AnyAnyA 5.6's optimizer bug which is releated to 'or' operator's number
770262015-05-13
12:20		2016-10-11
1:00		MySQL UtilitiesNo Feedback
(2748 days)		S25.6.24WindowsAnymysqldbcompare and mysqldiff error updating
1004412020-08-06
10:38		2020-09-02
8:33		MySQL Server: DDLNot a Bug
(1325 days)		S38.0.21AnyAnyThe Foreign Key constraint is not updated after renaming
1116162023-06-29
6:19		2023-06-30
7:40		MySQL Server: Data DictionaryVerified
(294 days)		S28.0.32AnyAnyFailed to upgrade from 5.7 to 8.0 because of spatial column with BTREE index
209772006-07-11
22:07		2006-08-10
16:01		MySQL Server: ViewsClosed
(6462 days)		S35.1.12Linux (Fedora core 5)Anyconfusing results after setting 'updatable_views_with_limit' to 'NO'
805282016-02-26
13:09		2016-09-18
1:00		MySQL Workbench: ModelingNo Feedback
(2771 days)		S26.3.6Windows (Microsoft Windows 10 Pro)AnyCopying a PK-column as reference into another table impossible to remove AI
805292016-02-26
13:10		2016-02-26
14:05		MySQL Workbench: ModelingDuplicate
(2975 days)		S26.3.6Windows (Microsoft Windows 10 Pro)AnyCopying a PK-column as reference into another table impossible to remove AI
997802020-06-04
13:25		2020-06-05
2:49		MySQL Workbench: ModelingNot a Bug
(1414 days)		S78.0.20MacOS (macOS 10.15.x Catalina x86_64)Anyfinally forget this bug....it is something else
119072005-07-13
10:04		2013-05-30
5:22		Connector / ODBCCan't repeat
(3977 days)		S34.0.20-logLinux (Mandrake 10.1)AnyDuplicate entry NULL for key
366212008-05-09
10:49		2008-06-20
21:43		MySQL Server: Falcon storage engineNot a Bug
(5782 days)		S36.0.5AnyAnyFalcon allows a key to be named PRIMARY_KEY
170162006-02-01
16:51		2008-01-09
23:08		Connector / ODBCCan't repeat
(5945 days)		S23.51Windows (Windows)AnyI find some problem in MySQL (bugs) - 'update' command in C++
263202007-02-13
13:13		2007-02-21
18:41		MySQL Enterprise Monitor: InstallingClosed
(6267 days)		S21.1.0.4732Linux (RHEL4)AnyService Manager update installer fails on Linux
426152009-02-05
10:59		2011-02-16
23:43		MySQL Server: GeneralVerified
(5535 days)		S45.0.27FreeBSDAnyUPDATE statement workflow
486632009-11-10
10:51		2011-02-16
23:44		MySQL Server: ErrorsClosed
(4845 days)		S25.1.34AnyAnySTRICT_TRANS_TABLE causing an error when 0 rows found in an UPDATE trigger
490702009-11-24
20:53		2016-02-25
12:24		MySQL Workbench: AdministrationNot a Bug
(5189 days)		S25.2 r4753Windows (XP)AnyWB creating strange GRANTs
523502010-03-25
0:19		2022-11-15
23:59		MySQL WorkbenchClosed
(5076 days)		S15.2.16AnyAnycannot set ON UPDATE CURRENT_TIMESTAMP as default value
530752010-04-22
18:12		2011-02-16
23:44		MySQL Server: ReplicationClosed
(5095 days)		S35.6.99-m4AnyAnySBR: Strange warning around CONNECTION_ID()
1079562022-07-25
7:11		2022-08-12
8:09		MySQL Server: Row Based Replication ( RBR )Not a Bug
(616 days)		S35.7.35UbuntuAnylog_slave_updates not respecting binlog_row_image
103962005-05-05
19:03		2011-02-16
23:43		MySQL Server: Command-line ClientsVerified
(6885 days)		S44.1Any (any)AnyUPDATE... [ON NONE FOUND INSERT]
342082008-01-31
21:55		2008-04-02
19:35		MySQL Cluster: Cluster (NDB) storage engineClosed
(5861 days)		S25.1.23-rcLinux (IA64, icc)AnyWrong select results returned by cluster
62702004-10-26
20:28		2004-12-01
19:44		MySQL Server: MyISAM storage engineNot a Bug
(7079 days)		S24.1.7Linux (Linux)AnyUPDATE report a duplicate key error whereas it shouldn't
87322005-02-23
14:49		2012-05-18
20:19		MySQL ServerDuplicate
(6832 days)		S34.1.10Any (*)AnyINSERT ... SELECT ...ON DUPLICATE KEY UPDATE problem
87362005-02-23
17:31		2005-02-23
21:51		MySQL ServerClosed
(6995 days)		S34.1.10Any (*)Anyon duplicate key update allows/ignores updates to read table
272102007-03-16
12:31		2007-08-29
2:10		MySQL ServerClosed
(6078 days)		S25.0.36, 5.0.37Linux (Linux, Windows)AnyINNODB ON DUPLICATE KEY UPDATE
297282007-07-11
17:54		2007-08-13
20:21		MySQL Server: ReplicationCan't repeat
(6094 days)		S25.0.36sp1-enterprise-gpl-logSolaris (i386)AnyINSERT ... ON DUPLICATE KEY UPDATE syntax fails on replication slaves
301462007-07-31
12:59		2007-07-31
13:10		MySQL Server: GeneralClosed
(6107 days)		S35.0.42-enterprise-gplAnyAnyon duplicate key update does insert and update at the same time
380462008-07-11
14:22		2012-08-03
15:34		MySQL Server: LockingClosed
(4277 days)		S35.0, 5.1, 6.0 bzrAnyAnyINSERT SELECT ON DUPLICATE KEY UPDATE, LOAD DATA REPLACE wrong lock
439582009-03-30
13:07		2009-05-15
16:10		MySQL Server: Falcon storage engineClosed
(5453 days)		S16.0.11-bzrSolaris (Solaris 10 x64)AnyAssertion (transState != NULL) failed in Transaction::waitForTransaction
524552010-03-30
1:54		2011-02-16
23:44		MySQL Server: PartitionsClosed
(4936 days)		S35.1AnyAnySubpar INSERT ON DUPLICATE KEY UPDATE performance with many partitions
569352010-09-22
14:50		2010-09-23
5:24		MySQL Server: ParserNot a Bug
(4957 days)		S35.021AnyAnyinsert ... on duplicate key update .. update content may not contain ";"
578802010-11-01
8:30		2011-02-16
23:44		MySQL Server: MyISAM storage engineClosed
(4894 days)		S25.1.49, 5.1.52, 5.5.6rcAnyAnyDifference between MyISAM and InnoDB when using pk + UPDATE
668072012-09-13
12:34		2012-09-13
17:09		MySQL Server: GeneralNot a Bug
(4236 days)		S35.1.41Windows (Windows 7 32bit)AnyWrong AUTO_INCREMENT value when using ON DUPLICATE KEY UPDATE clause
697182013-07-10
18:36		2016-01-10
20:45		Connector / ODBCPatch pending
(3888 days)		S25.2.5Windows (window7 64bit)AnyINSERT ON DUPLICATE KEY UPDATE does regularly report "-1"
950962019-04-24
1:27		2019-04-24
6:03		MySQL Server: DMLNot a Bug
(1822 days)		S3AnyAnyINSERT INTO ... ON DUPLICATE KEY UPDATE returns wrong number of rows updated
1073252022-05-18
10:03		2022-05-18
14:36		MySQL Server: DMLVerified
(702 days)		S38.0AnyAnySubquery gives wrong results in ON DUPLICATE KEY UPDATE ... part of INSERT
1115302023-06-22
8:42		2023-06-23
4:01		Connector / JNot a Bug
(302 days)		S38.0.29AnyAnyuseGeneratedKeys bug When using on duplicate key update clause
1123682023-09-17
14:39		2023-09-21
2:29		MySQL Server: Group ReplicationCan't repeat
(211 days)		S15.7.36Debian (Debian GNU/Linux 10 (buster))AnyMismatched SQL for the same GTID transaction across primary and secondary
1132292023-11-27
7:57		2023-11-27
11:11		MySQL Server: ReplicationCan't repeat
(144 days)		S38.0.33Any (CentOS Linux 7)Anymysqld: Duplicate entry 'mysql/slave_worker_info' for key 'tablespaces.name'
65922004-11-12
13:37		2004-12-16
3:42		MySQL Cluster: Cluster (NDB) storage engineNo Feedback
(7064 days)		S24.1.7Linux (Redhat Enterprise Linux AS 3)Anyndb table, insert, Duplicate entry '-1' for key 1
108522005-05-25
4:06		2011-07-12
20:52		MySQL Migration ToolkitClosed
(6883 days)		S21.0.6betaWindows (WindowsXP)AnyMissing Tables / "Error 1061 Duplicate key name" migrating from Access97
116062005-06-28
9:53		2005-07-28
17:10		MySQL Server: OptimizerNo Feedback
(6840 days)		S24.1.11-standard-logLinux (Fedora Core 2)AnyDuplicate key error in SELECT query
166772006-01-20
16:22		2006-02-17
12:53		MySQL Server: DocumentationClosed
(6636 days)		S34.1->Linux (Linux)AnyCluster returns different duplicate key error then other engines
191332006-04-16
19:51		2006-04-17
13:07		MySQL ServerNot a Bug
(6577 days)		S24.1.14-Debian_6-logLinux (Debian)AnyERROR 1062 (23000): Duplicate entry '127' for key 1
208202006-07-03
13:01		2006-07-07
3:45		MySQL Cluster: Cluster (NDB) storage engineClosed
(6496 days)		S25.0Linux (Linux 32 bit OS)Anyauto inc table not handled correctly when restored from cluster backup
213352006-07-28
23:08		2007-07-05
20:30		MySQL Server: DocumentationNot a Bug
(6133 days)		S24.1.22 4.0.28AnyAnyUNIQUE index on TEXT columns allows trailing whitespace
268032007-03-02
19:15		2007-04-13
9:04		MySQL Server: Falcon storage engineClosed
(6216 days)		S35.1AnyAnyunique constraints on VARCHAR columns behave different in MyISAM and Falcon
270222007-03-10
10:52		2007-04-06
18:06		MySQL Server: InstallingClosed
(6223 days)		S15.0.38, 5.1.17Linux (Linux)AnyInstall fails with Duplicate entry '%-test-' for key 'PRIMARY'
276162007-04-03
13:45		2007-04-17
13:41		MySQL Enterprise Monitor: ServerClosed
(6212 days)		S21.1.0.4973Windows (Windows XP)AnyMySQLIntegrityConstraintViolationException: Duplicate entry '...' for key 2
313492007-10-02
18:13		2007-12-20
0:43		MySQL Server: Data TypesClosed
(5965 days)		S35.1.23-debug, 5.0.48-debugAnyAnyERROR 1062 (23000): Duplicate entry '' for key 'group_key'
336882008-01-04
11:33		2008-03-13
5:52		MySQL Server: ReplicationClosed
(5881 days)		S16.0.4AnyAnyFalcon: replication fails on duplicate key error
358072008-04-03
15:53		2008-09-15
16:09		MySQL Server: Row Based Replication ( RBR )Closed
(5695 days)		S35.1.24AnyAnyINSTALL PLUGIN replicates row-based, but not stmt-based
368012008-05-19
15:02		2016-01-03
20:45		MySQL Server: InnoDB storage engineVerified
(5090 days)		S4AnyAnyInnoDB should release the lock on a duplicate key under REPEATABLE READ
410262008-11-25
19:08		2011-02-16
23:43		MySQL ServerClosed
(5615 days)		S36.0.8-releaseAnyAnymaria: Duplicate entry '...' for key 'PRIMARY' in sysbench OLTP_RW test
423962009-01-27
21:35		2017-01-18
13:23		MySQL Cluster: ReplicationCan't repeat
(2648 days)		S3mysql-6.0AnyAnyautoincrement insert into ndb fails with duplicate key
472072009-09-09
7:21		2022-12-04
20:45		MySQL Server: ErrorsVerified
(5336 days)		S35.1AnyAnyNot enough information in error Duplicate entry xxx for key 1
501982010-01-08
22:55		2011-02-16
23:44		MySQL Server: OptimizerCan't repeat
(5175 days)		S35.1AnyAnyServer adding duplicate row with duplicate WHERE clause condition and Innodb
501992010-01-08
22:56		2018-09-09
20:45		MySQL Server: OptimizerDuplicate
(5215 days)		S35.1AnyAnyServer adding duplicate row with duplicate WHERE clause condition and Innodb
502002010-01-08
22:56		2018-09-09
20:45		MySQL Server: OptimizerDuplicate
(5215 days)		S35.1AnyAnyServer adding duplicate row with duplicate WHERE clause condition and Innodb
608862011-04-15
20:56		2011-04-16
19:35		MySQL ServerDuplicate
(4752 days)		S25.5.11MacOS (10.7.0)AnyALTER IGNORE TABLE ADD PRIMARY KEY fails on duplicate key values
659792012-07-22
12:12		2014-09-05
9:55		MySQL Cluster: Cluster (NDB) storage engineCan't repeat
(3514 days)		S15.5.25a-ndb-7.2.7-gpl-logLinux (CentOS release 6.3 (Final) 2.6.32-279.1.1.el6.x86_64)AnyAll SQL Nodes SIGSEGV when writing dupe data to tables where PK spans all cols
691852013-05-09
15:23		2014-02-24
12:33		MySQL Server: ReplicationVerified
(3707 days)		S25.1.69AnyAnyReplication breaks during concurrent INSERTs and LOAD DATA in a auto_inc table
811012016-04-15
18:13		2017-10-13
23:49		MySQL Server: InnoDB storage engineDuplicate
(2593 days)		S25.6.25CentOSAnyDuplicate PRIMARY KEY errors after changing auto_increment settings
812542016-05-01
7:53		2016-05-02
10:10		MySQL Server: DMLVerified
(2909 days)		S25.6, 5.6.30, 5.7.12AnyAnyUsing INSERT_ID local variable, makes REPLACE fail when there is a duplicate key
891432018-01-08
22:10		2018-07-02
14:06		MySQL Server: ReplicationClosed
(2185 days)		S25.7.20AnyAnyCommit order deadlock + retry logic is not considering trx error cases
950792019-04-23
2:32		2019-04-25
9:21		MySQL Server: InnoDB storage engineVerified
(1823 days)		S35.7, 5.7.25AnyAnyFalse duplicate key check
1026832021-02-22
8:38		2021-04-24
14:56		MySQL Server: Japanese DocumentationClosed
(1091 days)		S38.0AnyAnyProposal for the Japanese 8.0 document correction(Chap 10:Charset).
1036322021-05-08
12:23		2022-08-13
16:23		MySQL Server: OptimizerVerified
(615 days)		S28.0.23, 8.0.24, 5.7.34Any (Windows, Ubuntu)AnyCan't write; duplicate key in table
22932004-01-06
3:17		2005-08-04
23:35		MySQL Websites: bugs.mysql.comClosed
(6833 days)		S4 AnyEnhance the marking of duplicate bug reports
744962014-10-22
8:08		2014-10-24
8:44		MySQL Server: DDLNot a Bug
(3467 days)		S35.6.21WindowsAnyView creation: error in checking duplicate column names
763142015-03-13
13:17		2016-02-04
19:33		MySQL Server: OptimizerClosed
(3124 days)		S35.7AnyAnySemi-join duplicate elimination gives lower cost than no duplicate elimination
1019852020-12-13
15:03		2020-12-14
14:16		MySQL Server: OptimizerNot a Bug
(1222 days)		S3Mysql 5.7AnyAnycost planner doesn't know when DuplicateWeedout Strategy creates disk table
1034632021-04-24
19:30		2021-04-29
1:30		MySQL Server: DDLUnsupported
(1086 days)		S25.7.32-logWindows (Azure cloud instance)Any (Unknown)ALTER TABLE produces a duplicate table
17012003-10-29
6:48		2003-12-07
14:07		MySQL Server: ReplicationClosed
(7439 days)		S34.0.15-std-logLinux (Linux RH9)AnyUpdate from multiple tables
62542004-10-25
20:34		2016-01-03
20:45		MySQL Server: InnoDB storage engineVerified
(6449 days)		S44.1.7-debugLinux (SuSE 9.1)AnyIGNORE: should allow transactional tables to do partial transactions
605162011-03-17
15:26		2011-11-24
11:33		MySQL Server: DMLClosed
(4530 days)		S15.5.10Linux (Fedora 14)AnyUPDATE within a function fails and causes infinite loop
983452020-01-24
9:32		2020-02-17
13:26		MySQL WorkbenchVerified
(1523 days)		S38.0.19Windowsx86MySQL Workbench crashes during update model
1089902022-11-03
14:59		2022-11-22
13:04		MySQL Server: CharsetsCan't repeat
(514 days)		S38.0.29Debian (11)x86Update integer value via integer key raises collation error
325212007-11-20
13:51		2008-09-25
9:52		MySQL Server: DDLNo Feedback
(5685 days)		S35.0.46WindowsAnyMySQL fails to create table where keynames matches to the constraint names.
2412003-04-07
17:24		2003-04-23
2:27		MySQL Server: InnoDB storage engineClosed
(7667 days)		S24.0.12sparc-sun-solaris2.8AnyUPDATE ... ORDER BY does not work with InnoDB
164942006-01-13
20:09		2006-08-18
17:07		MySQL Server: Federated storage engineClosed
(6454 days)		S15.0.18/5.0.19 BK/5.0.24Linux (Linux)AnyUpdates that set a column to NULL fail sometimes
324712007-11-17
16:01		2007-11-29
15:37		MySQL Server: GeneralNot a Bug
(5986 days)		S35.0.45, 4.1, 5.0, 5.1 BKAny (Linux, Windows)AnyConditional update statement not working as expected
530792010-04-22
19:04		2023-02-12
20:45		MySQL Server: ReplicationDuplicate
(4916 days)		S25.1.45, 5.1, 5.6.99AnyAnydue to a trigger, replication fails with DUPLICATE KEY error for an UPDATE
622252011-08-22
9:28		2011-08-22
10:36		MySQL Server: ErrorsNot a Bug
(4624 days)		S25.1.53Windows (7)AnyUpdate with unique column of type TIMESTAMP
151892005-11-23
15:59		2011-02-16
23:43		MySQL Server: DMLVerified
(6722 days)		S45.0.17-BKAnyAnyOptimise INSERT ... ON DUPLICATE KEY ... for identical column values
255112007-01-10
0:03		2007-07-18
17:53		MySQL Server: Federated storage engineClosed
(6120 days)		S35.2.0, 5.0.38-bkLinux (SUSE 10.0 / 64-bit)AnyFederated: INSERT failures
299412007-07-20
19:19		2013-02-20
22:37		Connectors: DBD::mysql ( Perl )Unsupported
(4076 days)		S34.005Any (Sun Solaris 8, Mac OS X)AnyPerl affected row count incorrect for certain cases of ON DUPLICATE KEY UPDATE
377922008-07-02
3:55		2008-07-25
19:20		MySQL Server: InnoDB storage engineNot a Bug
(5747 days)		S5mysql community 5.0.41 Windows (XP sp2)Anydead lock and slow insert
592482010-12-31
23:31		2013-01-22
19:06		MySQL Server: DMLClosed
(4105 days)		S25.5.8, 5.5.20AnyAnycode review: write_row() crashes on INSERT...DUPLICATE KEY UPDATE
765512015-03-31
22:31		2016-01-16
20:31		MySQL Server: InnoDB storage engineVerified
(3306 days)		S15.6Linux (centos)AnyQuery hangs on INSERT INTO...SELECT... ON DUPLICATE KEY UPDATE
928132018-10-17
4:54		2018-10-17
9:47		MySQL Server: InnoDB storage engineVerified
(2011 days)		S35.7.15-log MySQL Community Server (GPL)CentOSAnyinsert ..on duplicate key update return 0 rows affected
137782005-10-05
18:41		2011-02-16
23:43		MySQL Server: InnoDB storage engineClosed
(5054 days)		S15.0/4.1.15Windows (Windows XP Professional SP2 Engl)AnyIf FOREIGN_KEY_CHECKS=0, one can create inconsistent FOREIGN KEYs
327642007-11-27
11:43		2014-05-15
22:33		MySQL WorkbenchNot a Bug
(3627 days)		S25.0.9Windows (Vista)AnyForward Engineer fails to create foreign key constraints
487532009-11-13
8:27		2021-05-02
20:45		MySQL Cluster: Cluster (NDB) storage engineNo Feedback
(5219 days)		S3mysql-5.1-telco-7.0LinuxAnySearch an ordered index after update sometimes fails
890942018-01-02
14:06		2018-01-03
8:07		MySQL Server: DMLCan't repeat
(2298 days)		S25.7.19DebianAnyData inconsistency on master after upgrading to 5.7.19
1000232020-06-28
16:31		2023-06-12
12:27		MySQL Server: DocumentationVerified
(1388 days)		S38.0.20AnyAnyForeign Key Update Cascade FAILS on 2+ Tables Where BOTH are Parent and Child
1080152022-07-28
17:02		2022-07-29
12:04		MySQL ServerDuplicate
(630 days)		S28.0.29,8.0.30Linux (Ubuntu/CentOS)x86select under repeatable read isolation level returns stale version of data
148872005-11-11
21:33		2011-02-16
23:43		MySQL ServerDuplicate
(4874 days)		S45.0.15-standard-logLinux (Linux)AnyAllow Insert Trigger to call simple UPDATE on same table trigger is based
201042006-05-27
10:03		2006-12-29
18:30		Connectors: DBD::mysql ( Perl )Closed
(6321 days)		S33.0004, older versionsLinux (SuSE 9.3, Debian, Ubuntu)AnyDBD::MySQL loses data (with dbh->do in subroutine)
317242007-10-20
7:54		2015-03-15
20:45		MySQL Server: MyISAM storage engineNo Feedback
(5012 days)		S3mysql-5.1.22-rc-linux-x86_64-icc-glibc23Linux (Debian 2.6.18-5-amd64)AnyUPDATE not properly using indexes
401132008-10-17
15:51		2011-02-16
23:43		MySQL Server: LockingClosed
(5369 days)		S25.0, 5.1, 6.0 bzrAny (Linux, Win XP SP2 32bit)AnyEmbedded SELECT inside UPDATE or DELETE can timeout without error
647792012-03-27
16:52		2012-08-24
23:52		Connector / NETClosed
(4256 days)		S36.5.4AnyAnyCascading delete using CreateDatabase in Entity Framework
1032872021-04-12
13:57		2021-06-04
6:32		Connector / ODBCClosed
(1050 days)		S38.0.23AnyAnySQLSetPos(SQL_DELETE) does not produce diagnostic for duplicate key
934102018-11-29
16:57		2019-02-21
2:39		MySQL Server: DMLClosed
(1884 days)		S18.0.13CentOSAnyInsert is fine but "On Duplicate Update" updating wrong data
96892005-04-06
17:37		2005-04-22
21:10		MySQL Server: OptimizerNot a Bug
(6937 days)		S34.1.11Any (*)Anywrong result for subselect in on duplicate key update (query cache)
18122003-11-11
22:54		2003-12-13
16:43		MySQL Server: MyISAM storage engineClosed
(7433 days)		S24.0.16Windows (Windows XP)AnyTable Corruption possibly due to "DELETE FROM TABLE"
109312005-05-27
20:54		2005-06-21
11:00		MySQL ServerClosed
(6877 days)		S24.1.xAny (All)AnyHostname cache completely broken in 4.1
130242005-09-06
23:04		2011-02-16
23:43		MySQL Server: OptimizerVerified
(6799 days)		S44.1.14, 5.0.11AnyAnyoptimizer does not use index when where has (field1,field2,..)=(value1,value2,.
228382006-09-29
18:21		2016-02-25
12:24		MySQL Cluster: Cluster (NDB) storage engineClosed
(6378 days)		S35.1.11-betaLinux (Linux)AnyNDB INSERT fails on table with unique key for ERROR 1296
331342007-12-11
10:57		2022-12-04
20:45		MySQL Server: DDLVerified
(5974 days)		S35.0.51AnyAnydescribe table output wrong for unique key when primary key is dropped
340782008-01-26
14:19		2020-05-03
20:45		MySQL Server: OptimizerVerified
(5901 days)		S34.1,5.0,5.1,6.0-BKAny (Linux)Anyref access is not used for varchar column
460412009-07-08
14:32		2011-02-16
23:44		MySQL WorkbenchNo Feedback
(5368 days)		S35.1.16 OSSWindows (XP SP3)AnyProblem on the export alter SQL script : error 1025
477702009-10-01
17:46		2012-05-18
20:19		MySQL Server: LockingDuplicate
(5291 days)		S36.0AnyAny100% CPU loop in the MDL_context::wait_for_locks hash
608842011-04-15
20:31		2011-04-27
12:05		MySQL Server: LoggingVerified
(4748 days)		S4Ver 14.12 Distrib 5.0.91Linux (CentOS 5.5)AnyEnable logging of all errors to the error log
678312012-12-06
20:48		2017-03-01
1:00		MySQL Workbench: MigrationNo Feedback
(2607 days)		S35.2.44 CEWindows (TypeError: cannot concatenate 'str' and 'NoneType' objects)AnyTypeError: cannot concatenate 'str' and 'NoneType' objects
775382015-06-29
11:06		2015-06-29
11:35		MySQL Server: MyISAM storage engineVerified
(3217 days)		S25.1/5.5/5.6/5.7LinuxAnyMyISAM accepts table definition that is no longer considered as correct
783692015-09-08
14:48		2015-09-14
9:16		Connector / NETCan't repeat
(3140 days)		S26.9.3WindowsAnyConnector/NET 6.9.7 (Upgrading Connector/NET 6.9.3) Failed
905732018-04-23
13:14		2018-10-09
16:07		MySQL ServerCan't repeat
(2019 days)		S15.6.40FreeBSD (11.1)Other (amd64)MySQL crash
1047122021-08-24
16:55		2021-10-08
16:16		MySQL Server: ReplicationVerified
(924 days)		S35.7.35AnyAnyIMPLICITLY added NOT NULL constraint missing in the binary log
310892007-09-18
21:20		2007-09-19
1:04		MySQL Server: CompilingNot a Bug
(6057 days)		S35.0.45Linux (Debian Sarge)AnyInnoDB unsafe binlog test fails with wrong error
699392013-08-06
12:49		2013-08-12
3:02		MySQL Server: InnoDB storage engineDuplicate
(3903 days)		S2MySQL-server-5.6.10Any (RHEL6 64-bit , kernel 2.6.32-71.el6.x86_64)AnyALTER TABLE for Adding Foreign Key crashes MySql Server after disabling FK Check
860782017-04-25
19:14		2018-04-12
7:51		MySQL Server: ReplicationClosed
(2199 days)		S28.0.1AnyAny Bad Write Set tracking with UNIQUE KEY on a DELETE followed by an INSERT.
43862004-07-02
20:41		2004-07-07
18:02		Connector / NETClosed
(7226 days)		S2 AnyInserted data doesn't update properly
448492009-05-13
16:04		2013-05-29
6:08		Connector / ODBCClosed
(3978 days)		S15.1WindowsAnyCannot update records in a table with a column of type CHAR(3) UNICODE PRIMARY
661272012-07-31
18:00		2012-09-08
1:00		MySQL Server: Information schemaNo Feedback
(4243 days)		S25.5.25aSolaris (S11 - MySQL built from source)AnySHOW FULL COLUMNS: Behaviour change:-(
25182004-01-26
11:10		2005-03-21
22:18		MySQL Server: ReplicationNot a Bug
(6969 days)		S24.0.17Linux (Linux)AnyReplication
258282007-01-24
14:01		2007-01-24
16:13		MySQL Server: Falcon storage engineClosed
(6295 days)		S2mysql-5.2.0-falcon-alpha-win32Windows (Win XP)AnyFalcon compound primary key problem
441702009-04-08
22:55		2011-02-16
23:43		MySQL ServerNo Feedback
(5440 days)		S25.1.30Solaris (OpenSolaris December 2008 build)AnyUnexpected errors with certain selects
599522011-02-04
17:20		2014-03-16
11:44		MySQL Server: OptimizerVerified
(4788 days)		S35.1.55-community, 5.6.3AnyAnydistinct ,distinct_key,group_key
925302018-09-21
15:48		2023-01-18
1:58		MySQL Server: ErrorsClosed
(1747 days)		S35.6.35AnyAnyContribution by Facebook: Add more information to duplicate key error
1100922023-02-16
6:43		2023-02-23
13:17		MySQL ServerNot a Bug
(421 days)		S35.7.34-logCentOS (CentOS Linux release 7.6.1810 (Core))Anyunique key has duplicate data.
233832006-10-17
17:42		2006-11-30
20:21		MySQL Server: C API (client library)Closed
(6350 days)		S35.0.26/4.1/5.1BKLinux (SuSE 10.1, 2.6.16.21-0.25-def)Anymysql_affected_rows() returns different values than mysql_stmt_affected_rows()
5732003-06-03
6:45		2003-07-03
5:36		MySQL Server: ReplicationClosed
(7596 days)		S34.0Any (all)Anyslave prints an incomplete error message when LOAD DATA INFILE gives dup entry
52632004-08-27
20:12		2004-09-06
13:41		MySQL ServerClosed
(7165 days)		S35.0.2-alpha-debugLinux (SuSE 8.2)AnyViews: crash if INSERT ... ON DUPLICATE KEY
61262004-10-16
9:19		2004-11-22
18:10		MySQL Server: InnoDB storage engineClosed
(7088 days)		S34.1.5 Anyinnodb index with duplicate column gives missleading error message
108552005-05-25
8:56		2005-06-26
6:35		MySQL ServerCan't repeat
(6872 days)		S15.0.4Windows (Windows XP sp2)AnyDuplicate key error in select AFTER RESET QUERY CACHE
120832005-07-21
14:31		2005-07-22
10:23		MySQL ServerClosed
(6846 days)		S24.0.20Windows (XP, Debian, SuSE)AnyError 'Duplicate entry' on REPLACE INTO on replication slave
144462005-10-28
22:52		2005-11-29
16:00		MySQL ServerNo Feedback
(6716 days)		S35.0.15Windows (WIN XP SP1)Any230000 DUPLICATE ENTRY 'xxxxxxx' FOR KEY 1
223372006-09-14
10:28		2012-05-18
20:19		MySQL Server: CharsetsDuplicate
(6394 days)		S45.0.x, 4.1.21, 4.1.10Linux (Linux, Windows)AnyCollation change results in duplicate key ("e" and "é" mixup)
247622006-12-01
21:41		2011-02-16
23:43		MySQL ServerVerified
(5291 days)		S14.1.20,5.0.60,5.1.38,5.1.40Linux (CentOS,Mac OSX)AnyFailure to import data (timestamp)
302822007-08-07
18:42		2021-05-23
20:45		MySQL Server: Falcon storage engineDuplicate
(5601 days)		S26.0-falconAnyAnyFalcon: duplicate-key error for value that ends with 0x00
387012008-08-10
17:50		2011-02-16
23:43		MySQL ServerClosed
(5663 days)		S15.1.28,6.0.7AnyAnyCrash in String::append when inserting duplicate empty strings an uft8 SET col
391862008-09-02
13:49		2008-10-18
15:56		MySQL ServerClosed
(5662 days)		S36.0AnyAnyCrash in String::append when inserting duplicate empty strings an uft8 SET col
461442009-07-13
10:32		2010-05-26
18:01		MySQL Server: Falcon storage engineUnsupported
(5077 days)		S2falcon-teamAnyAnyFalcon indexes may become corrupt
577822010-10-27
19:32		2021-05-02
20:45		MySQL Cluster: Cluster (NDB) storage engineVerified
(3013 days)		S3mysql-5.1-telco-7.1AnyAnyndb_restore does not warn of possible duplicate keys when using UNIQUE indexes
1029282021-03-11
14:14		2021-04-24
15:43		MySQL Server: Japanese DocumentationClosed
(1091 days)		S38.0.23AnyAny1.3 MySQL 8.0 の新機能（InnoDB の拡張機能（途中）～）
56862004-09-21
19:37		2005-11-30
17:43		MySQL Server: MyISAM storage engineClosed
(6715 days)		S14.1.8Linux (linux 2.4.26)Any#1034 - Incorrect key file for table - only utf8
353342008-03-17
12:48		2022-09-04
20:45		MySQL Server: OptimizerVerified
(5841 days)		S45.0 allAnyAnyFor MyISAM select * from table order by key_field does not use index
438952009-03-26
18:45		2014-07-14
15:31		MySQL Server: DMLClosed
(3567 days)		S35.1 bzrAnyAnyMulti-DELETE IGNORE does not report warnings
250092006-12-12
14:33		2007-02-22
14:10		Connector / JClosed
(6266 days)		S3 AnyResultSet is from UPDATE. No Data
433602009-03-04
10:10		2011-02-16
23:43		MySQL Server: OptimizerClosed
(4897 days)		S36.0-bzrLinux (Ubuntu 8.04)AnyServer crash with a simple multi-table update (InnoDB table)
962052019-07-15
9:05		2019-07-15
15:11		MySQL Server: InnoDB storage engineNot a Bug
(1740 days)		S3AnyAnynot in expect, two versions row datas in a some transaction
980882019-12-28
5:54		2020-02-25
14:47		MySQL Server: DMLCan't repeat
(1515 days)		S38.0.18Anyx86Unique index is functioned unexpectedly when entire records are updated target
2362003-04-06
13:56		2003-05-15
7:59		MySQL ServerCan't repeat
(7645 days)		S24.0.11-gamma-maxFreeBSD (FreeBSD 4.7-RELEASE)AnyMulti-table update denied to user who has all privleges
62112004-10-22
11:04		2004-11-01
14:33		MySQL Server: InnoDB storage engineNot a Bug
(7109 days)		S24.0.18Linux (linux)AnyProblem with InnoDB and Locking on Update
144122005-10-27
21:46		2007-11-06
15:27		Connector / NETDuplicate
(6009 days)		S41.0Windows (Windows 2000)AnyMySqlCommandBuilder does not automatically open connections for update
151662005-11-23
0:39		2006-02-14
3:15		MySQL ServerClosed
(6639 days)		S2 AnyWrong update [was: select/update] permissions required to execute triggers
173992006-02-14
20:47		2006-05-05
16:39		MySQL ServerNo Feedback
(6559 days)		S15.0.16Windows (Windows Server 2003)AnyMulti-table DELETE statement fails, identical SELECT statement works
182692006-03-16
7:01		2006-04-26
4:33		MySQL ServerNot a Bug
(6568 days)		S34.1.12-logLinux (Red Hat Enterprise Linux ES)Anyupdate query's problem (about atomical property)
298832007-07-18
23:48		2023-02-19
20:45		Connector / ODBCDuplicate
(5917 days)		S23.51.17Windows (xp sp 2)AnyMyODBC 3/ADO recordset update if SQL includes a Limit clause
415092008-12-16
14:25		2018-09-25
21:50		Tests: EngineCan't repeat
(5601 days)		S76.0AnyAnyfalcon_bug_22212 fails sporadically: query 'reap' succeeded - should have failed
460442009-07-08
15:38		2011-02-16
23:44		MySQL Server: LockingClosed
(5157 days)		S35.4AnyAnyMDL deadlock on LOCK TABLE + CREATE TABLE HIGH_PRIORITY FOR UPDATE
470102009-08-31
9:36		2013-05-29
6:07		Connector / ODBCClosed
(3978 days)		S35.1Windows (windows 2008 web server)AnyMysql mediumtext update problem on ADDNEW method
537792010-05-19
7:17		2011-02-16
23:44		MySQL Server: LoggingDuplicate
(5084 days)		S35.1-bugteam, peAnyAnymtr --debug was broken by bugfix 52629
554402010-07-21
12:54		2010-07-21
18:44		Connector / NETNot a Bug
(5021 days)		S1Connector .NET Beta 6.3.2Windows (Seven - VS 2010 )Any.NET FormView Update with DataSet generated --
576292010-10-21
13:56		2012-05-18
20:19		Connector / NETNo Feedback
(4676 days)		S16.3.5.0Windows (7 prof)AnyUpdate statement bug (last_insert_id) when using mySQL <-> EF4 Code-Only
631222011-11-06
22:51		2020-06-18
9:14		MySQL Server: InnoDB storage engineVerified
(4546 days)		S35.0+AnyAny"Searched SQL update" seems to release lock got by "select for update"
681982013-01-28
6:59		2013-01-29
15:32		MySQL Server: Stored RoutinesNot a Bug
(4098 days)		S25.5.29Windows (8)AnyIncorrect usage of UPDATE and ORDER BY
874202017-08-15
11:42		2017-08-25
11:57		MySQL Server: Security: PrivilegesVerified
(2438 days)		S35.6.36, 5.6.37, 5.5.56, 5.7.19CentOS (7.3.1611)AnyGRANTS using general and specific permissions
1014782020-11-05
13:46		2020-12-03
23:40		MySQL Package ReposDuplicate
(1261 days)		S25.7Red Hat (Release 7.8)x86yum update of mysql-connector-python fails
1101262023-02-19
10:40		2023-04-15
1:00		Connector / NETNo Feedback
(371 days)		S18.0.32AnyAnyIncorrect datetime value - MySQL 8.0.32 - Entity framework
1119922023-08-08
3:30		2023-08-08
12:45		MySQL Server: JSONDuplicate
(255 days)		S38.0Any (azure mysql single server)Anycannot update null value into nullable field when using UPDATE JOIN JSON_TABLE
55732004-09-14
16:58		2018-09-09
20:45		MySQL Server: InnoDB storage engineVerified
(5855 days)		S4AnyAnyWrong/undocumented behaviour on UNIQUE column mass update
342282008-02-01
13:55		2018-09-09
20:45		MySQL Server: DMLVerified
(5920 days)		S4*AnyAnyBulk Update statement
104002005-05-06
2:39		2005-05-23
2:10		MySQL Server: MyISAM storage engineClosed
(6906 days)		S14.1.12 forward AnyImproperly-defined MERGE table crashes with INSERT ... ON DUPLICATE KEY UPDATE
120542005-07-20
13:44		2014-03-13
13:34		MySQL Cluster: Cluster (NDB) storage engineWon't fix
(6836 days)		S34.1.12 (max)Linux (Linux)AnyON DUPLICATE KEY UPDATE fails in ndb table
134602005-09-24
14:22		2019-10-10
21:42		MySQL Server: DMLWon't fix
(1653 days)		S4*Any (*)AnyAllow delayed insert with on duplicate key update
182602006-03-15
17:08		2015-08-10
14:33		MySQL Server: mysqldump Command-line ClientVerified
(6609 days)		S45.0.18Linux (Debian)Anymysqldumpslow doesn't properly handle multi-row inserts/updates
232002006-10-12
8:18		2006-11-02
10:00		MySQL Cluster: Cluster (NDB) storage engineClosed
(6378 days)		S24.1, 5.0, 5.1Linux (FC 5 / Suse 10.1)AnyCluster INSERT INTO .. ON DUPLICATE KEY UPDATE locks and memory leaks
258312007-01-24
15:32		2007-03-06
19:54		MySQL ServerClosed
(6254 days)		S35.0.36-bk, 5.1.15-bkLinux (Linux Suse 10.1)AnyDeficiencies in INSERT ... SELECT ... field name resolving.
262612007-02-10
20:17		2007-03-19
17:41		MySQL ServerClosed
(6241 days)		S35.0bk, 5.1.15Windows (Windows XP)AnyMissing default value isn't noticed in insert ... on duplicate key update
279682007-04-20
0:47		2007-04-20
7:47		MySQL Server: GeneralDuplicate
(6209 days)		S35.0.36AnyAnyOn Duplicate Key Update Fails
286382007-05-23
23:11		2007-07-26
22:03		MySQL ServerNo Feedback
(6112 days)		S35.0.37-community-ntWindows (Windows Vista, 32bit)AnyINSERT ... ON DUPLICATE KEY UPDATE broken
292122007-06-19
13:42		2007-06-20
5:00		MySQL Server: InnoDB storage engineDuplicate
(6148 days)		S25.0.37LinuxAnyLAST_INSERT_ID doesn't work for innodb on "on duplicate key update"
318922007-10-26
21:48		2007-10-26
22:47		MySQL Server: Query CacheClosed
(6020 days)		S35.0.37-community-nt-logWindows (Windows 2000 5.00.2195 SP4)AnyON DUPLICATE KEY UPDATE does not refresh query cache.
349732008-03-01
18:05		2008-03-04
8:36		MySQL Server: Federated storage engineNot a Bug
(5890 days)		S25.1.23-rc-communityWindowsAnyInsert ... on duplicate key update problem with federated tables
395842008-09-22
11:10		2008-09-22
19:52		MySQL Server: Data TypesNot a Bug
(5688 days)		S35.0.45WindowsAnyTreating unsigned BIGINT as signed BIGINT in INSERT ON DUPLICATE KEY UPDATE
450812009-05-25
22:10		2014-11-28
6:21		MySQL Server: DMLNot a Bug
(5442 days)		S35.1.34-communityAnyAnyInsertion anomaly for ON DUPLICATE KEY UPDATE
608382011-04-12
2:01		2011-05-12
23:00		MySQL Server: DMLNo Feedback
(4726 days)		S2Ver 14.12 Distrib 5.0.91MacOSAnyon duplicate key update -- lost data
655442012-06-06
20:56		2012-08-26
16:13		Connector / JClosed
(4254 days)		S3AnyAnylaunchpad is out of date for the connector/j branhc
711882013-12-20
13:05		2013-12-20
23:06		MySQL Server: Data TypesNot a Bug
(3773 days)		S35.5 - 5.6.15LinuxAnyStrange beheavior ON DUPLICATE KEY UPDATE when auto_increment reaches MAXINT
770872015-05-19
8:32		2015-06-02
12:47		MySQL Server: InnoDB storage engineClosed
(3252 days)		S35.7.8AnyAnyINNODB FTS: error duplicate entry in FTS_DOC_ID_INDEX ON UPDATE CASCADE
830902016-09-22
2:13		2016-09-22
7:26		MySQL Server: Row Based Replication ( RBR )Verified
(2766 days)		S15.7.13, 5.7.15AnyAnyAUTO_INCREMENT not updated when using INSERT ON DUPLICATE KEY UPDATE
843652016-12-29
2:44		2021-12-18
22:54		Connector / JClosed
(853 days)		S38.0.26AnyAnyINSERT..VALUE with VALUES function lead to a StringIndexOutOfBoundsException
965212019-08-13
12:10		2019-08-22
12:47		MySQL Server: OptimizerNot a Bug
(1710 days)		S38.0.17AnyAnyon duplicate key update [1048] [23000]: Column 'NAME' cannot be null
965402019-08-14
20:19		2019-08-29
20:14		MySQL Server: ErrorsCan't repeat
(1695 days)		S25.6.22, 5.6.34AnyAnyError 1022 on INSERT/UPDATE to InnoDB table with a fulltext index defined
996042020-05-16
19:04		2022-12-21
18:05		Connector / JClosed
(519 days)		S38.0.20AnyAnyAdd support to row alias on INSERT... ON DUPLICATE KEY UPDATE on batch mode
1013042020-10-24
4:58		2020-10-24
14:19		MySQL Server: DMLVerified
(1273 days)		S25.7 thru 8.0.21Debian (Buster)x86 (KVM VM)mysql 5.7, 8 insert on duplicate key update on view inserts nothing without err
1042112021-07-05
20:54		2021-07-08
11:35		MySQL Server: ParserNot a Bug
(1017 days)		S38.0.xAnyAnyON DUPLICATE KEY UPDATE and table alias for new VALUES function replacement
1083792022-09-05
7:58		2022-09-20
22:29		Connector / JDuplicate
(577 days)		S38.0.29, 8.0.30AnyAnyRecognize "ON DUPLICATE KEY UPDATE" in "INSERT SET" Statement
1111832023-05-29
9:46		2023-05-29
13:21		MySQL Server: DMLVerified
(326 days)		S35.7AnyAnyWhen use ON DUPLICATE UPDATE syntax, TIMESTAMP in primary key, get wrong answer
1114412023-06-15
18:53		2023-06-22
17:57		MySQL Server: DMLClosed
(302 days)		S68.0.33Ubuntu (20.04 LTS)x86 (Intel(R) Core(TM) i7-10700 CPU)bool Sql_cmd_dml::prepare(THD*): Assertion `thd->is_error()' failed.
1028312021-03-05
16:32		2021-04-19
6:39		MySQL Server: InnoDB storage engineVerified
(1140 days)		S25.7.31, 5.7.33Any (CentOS, Ubuntu)Anytransaction-isolation level is not honored when changed at session level
51032004-08-19
0:49		2016-12-04
20:45		MySQL ServerDuplicate
(6190 days)		S44.0.20-standardLinux (Linux)AnyCannot add or update a child row: a foreign key constraint fails
560462010-08-17
9:12		2011-02-16
23:44		MySQL Server: LockingNo Feedback
(4962 days)		S15.1.46sp1-enterprise-gpl-pro-logLinux (Red Hat Enterprise Linux Server release 5.3 (Tikanga) x86_64)Any'SELECT ... FOR UPDATE' locked another table's index
804712016-02-23
9:05		2017-02-17
12:20		MySQL Cluster: Cluster (NDB) storage engineNot a Bug
(2618 days)		S37.xAnyAnyVia a secondary unique index is automatically upgraded to a Shared read lock
110212005-06-01
18:09		2008-11-14
16:18		MySQL ServerClosed
(5635 days)		S43.23 to currentWindows (Windows XP)Any"Dublicate Entry '#####' for key 1" when it should not occur
250342006-12-13
10:54		2008-06-18
11:20		MySQL Server: GeneralWon't fix
(5784 days)		S25.0 & 5.1Any (Any)AnyMySQL does not correctly handle errors on statement commit
396702008-09-26
14:22		2010-05-26
17:59		MySQL Server: Falcon storage engineUnsupported
(5077 days)		S36.0-falcon-team (6.0.8a)AnyAnyError on rename (errno: 121) from ALTER TABLE ADD KEY in concurrent test
892102018-01-12
15:43		2018-01-13
6:34		MySQL UtilitiesDuplicate
(2288 days)		S21.6.5MacOSAnymysqldcompare erroneously includes database name differences in SQL output
910492018-05-28
17:38		2018-06-08
14:02		MySQL ServerNot a Bug
(2144 days)		S35.5.38AnyAnydeleting duplicate complains about foreign key
131302005-09-13
6:35		2005-09-13
6:56		MySQL ServerNot a Bug
(6793 days)		S24.1Windows (windows advanced server)Anyquery based update failed the row to update do not found
255632007-01-11
23:39		2012-05-18
20:19		MySQL Cluster: Cluster (NDB) storage engineNo Feedback
(6164 days)		S25.0.27Linux (RHEL4)AnyNested Triggers Produce Non-Existant Table
425192009-02-01
15:36		2010-01-04
15:47		MySQL Server: Maria storage engineClosed
(5461 days)		S26.0-mariaAnyAnyMaria: RESTORE leads to corrupted table and assertion
548612010-06-28
11:50		2011-02-16
23:44		MySQL Server: Embedded Library ( libmysqld )Closed
(4947 days)		S35.5.6-m3AnyAnyAdditional connections not handled properly in mtr --embedded
745382014-10-24
7:38		2014-11-03
15:15		MySQL Server: ReplicationOpenS4AllAnyAnyNeed to change the style of SQL apply on slave mode for Update statement
781272015-08-18
12:16		2019-11-26
21:50		MySQL Server: DMLClosed
(1606 days)		S35.6.22, 5.5.46, 5.6.26AnyAnyIn consistent behavior between similar UPDATE sqls, error vs warning
1015232020-11-09
11:01		2020-11-16
14:04		MySQL Server: DMLDuplicate
(1250 days)		S58.0.18, 8.0.22LinuxAny"JSON partial update" does not work when updating a view
1069182022-04-05
17:46		2022-05-25
10:19		MySQL Server: Row Based Replication ( RBR )Verified
(695 days)		S38.0.25AnyAnymaster and slave may get serious in-consistence after add auto-increment as pk
96802005-04-06
14:49		2011-02-16
23:43		MySQL Server: InnoDB storage engineClosed
(5052 days)		S34.*Linux (redhat)Anywrong error from cascading update
770342015-05-14
3:52		2018-04-10
16:06		MySQL ServerUnsupported
(2201 days)		S2Percona 5.6.23-72.1 R 0503478Linux (Ubuntu 14.04LTS)AnyServer crashes mid constraint-definition, then gets false 'duplicate key' error.
109462005-05-29
21:15		2006-07-24
18:26		MySQL Server: Stored RoutinesClosed
(6479 days)		S3506-beta-logLinux (Linux Suse 9.3)AnyConfusing error messeges in the case of duplicate trigger definition
27542004-02-12
10:24		2004-03-26
11:05		MySQL Server: Command-line ClientsNo Feedback
(7329 days)		S14.0.17MacOS (Mac OS X and RedHat 9)AnyIndex error when using order by and limit on indexes
84292005-02-11
0:34		2005-02-25
18:09		MySQL Server: DocumentationClosed
(6993 days)		S24.1.9Linux (Debian unstable ('sid'))AnyCan't create foreign keys on TINYTEXT fields
112282005-06-10
8:40		2011-02-16
23:43		MySQL Server: DocumentationClosed
(4958 days)		S15.0.4-beta-standard-logLinux (Linux)AnyDESC shows arbitrary column as "PRI"
167002006-01-21
13:13		2006-01-21
13:51		MySQL ServerDuplicate
(6663 days)		S35.0.18FreeBSD (FreeBSD 6.0-RELEASE-p3)Anyoptimizer marks subquery DEPENDENT though it's not
185682006-03-28
7:41		2006-04-28
11:29		MySQL ServerNo Feedback
(6566 days)		S1mysql-mysql-5.1.7-beta-linux-i686Linux (linux)Anysome index can't create
187442006-04-03
15:15		2006-09-06
23:20		MySQL Server: OptimizerClosed
(6435 days)		S35.0.21-pre AnyTest 'join_outer' fails if "classic" configuration in 5.0
187452006-04-03
15:20		2006-05-22
18:27		MySQL Server: OptimizerClosed
(6542 days)		S35.0.21-pre AnyTest case 'func_group' fails if "classic" 5.0 configuration
191712006-04-18
18:12		2006-04-20
11:08		MySQL ServerCan't repeat
(6574 days)		S25.1.9-betaSolaris (Solaris 8 Sparc (32))AnyTest "information_schema": Incorrect key file for table './mysql/event'
196572006-05-09
22:03		2006-05-14
7:22		MySQL Server: DocumentationClosed
(6550 days)		S35.0.21/5.1Windows (Windows binary distribution)AnyProposition for YaSSL manual part correction
203252006-06-07
22:11		2007-03-19
19:18		Connectors: DBD::mysql ( Perl )Closed
(6241 days)		S33.0004Linux (SLES 8)Anyt/41bindparam.t: All parts of a PRIMARY KEY must be NOT NULL
287662007-05-30
8:25		2007-06-05
15:05		MySQL ServerCan't repeat
(6163 days)		S15.1.20AnyAnyMySQL crashes when tables with many partitions opened
288882007-06-05
1:25		2007-06-05
10:21		MySQL Server: Data TypesCan't repeat
(6163 days)		S34.0.25AnyAnyCAST on TEXT field returns BLOB when ORDERED BY
296802007-07-10
6:38		2007-08-07
20:00		MySQL Server: DocumentationClosed
(6100 days)		S35.0.46-BK, 5.0.41AnyAnyindex_merge is used instead of (faster!) range
313732007-10-03
14:42		2007-11-10
23:51		MySQL ServerNo Feedback
(6005 days)		S25.0.27-logLinuxAnyUnusing index in select query
316722007-10-17
18:21		2016-02-25
12:24		MySQL Server: OptimizerNot a Bug
(5973 days)		S35.0.46AnyAnyEXPLAIN indicates multiple column index used when it is not
379952008-07-09
15:42		2011-02-16
23:43		MySQL Server: Embedded Library ( libmysqld )Closed
(5369 days)		S35.1.26-rcAnyAnyError message truncation in test "innodb" in embedded mode
459692009-07-06
12:23		2012-10-08
15:31		MySQL Server: OptimizerClosed
(4211 days)		S35.1.35, 5.1.38-bzrWindows (XP, Vista)Anythe query otimizer choose the wrong index
549512010-07-02
7:51		2011-07-27
21:32		MySQL Server: DDLClosed
(4650 days)		S25.1.41-3ubuntu12.3, 5.1.49-bzrLinux (Ubuntu)AnyCreating a unique key across fields that have foreign keys, deletes first FK
676832012-11-23
9:27		2013-01-02
22:13		MySQL Workbench: ModelingDuplicate
(4125 days)		S35.2.44Windows (XP)AnyWB claims it corrected problems in mwb file but same message re-appears
681482013-01-22
21:10		2017-08-30
16:43		MySQL Server: InnoDB storage engineClosed
(4015 days)		S15.5.27, 5.6.7LinuxAnydrop index on a foreign key column leads to missing table
700022013-08-12
19:23		2013-08-19
7:38		MySQL Server: OptimizerDuplicate
(3896 days)		S25.6.13, 5.5, 5.1AnyAnyvery low performance join - eq_ref and ref access broken for compound indexes
899582018-03-08
10:02		2018-03-13
8:04		MySQL WorkbenchCan't repeat
(2229 days)		S35.7.21-0ubuntu0.16.04.1Windows (Server 2012 R2 Datacenter)x86 (x64)Bad export generated by Workbench: ALTER TABLE for UNIQUE KEY
933322018-11-25
18:22		2018-11-26
9:08		MySQL WorkbenchVerified
(1971 days)		S38.0.13Windows (Microsoft Windows 10 Pro)Anyforeign key referencing 2 columns does not show up in schemas
997462020-05-29
17:04		2020-05-30
4:04		Connector / Python DocumentationClosed
(1420 days)		S2AnyAnywrong table definition in connector Python docs
1021992021-01-08
14:04		2023-03-17
7:36		MySQL Server: InnoDB storage engineCan't repeat
(399 days)		S38.0.22CentOS (7.9)x86Data dictionary upgrading fails with encrypted tablespace
1050902021-09-30
17:23		2021-09-30
18:26		MySQL Server: DDLVerified
(932 days)		S35.7.35Anyx86FK cannot be created when the table has a UNIQUE KEY in a virtual generated col
1093572022-12-13
7:11		2022-12-13
12:55		MySQL ServerCan't repeat
(493 days)		S3Mysql Operator 8.0.31Ubuntux86TLS/SSL Certificates with MySQL Operator now working
1100712023-02-15
6:41		2023-02-15
8:11		MySQL Server: Row Based Replication ( RBR )Verified
(429 days)		S2Any, 5.7, 8.0AnyAnyForeign Key should not be added to Writeset-based Dependency Tracking.
271402007-03-14
16:27		2007-03-15
17:44		MySQL Server: InnoDB storage engineNot a Bug
(6245 days)		S25.0.38-BK, 5.0.37-community-ntLinux (Linux, Windows XP SP2)AnySHOW CREATE TABLE and mysqldump does not show ON UPDATE/DELETE constraints
407612008-11-15
19:17		2011-02-16
23:43		MySQL Server: DMLClosed
(5560 days)		S25.1.29/5.0/5.1/6.0Windows (WinXP (Intel-32)/Linux)AnyLEFT JOIN on inline view crashes server
705152013-10-03
19:01		2014-03-12
1:37		MySQL Workbench: ModelingClosed
(3691 days)		S36.0.7AnyAnyWorkbench cannot handle fractional timestamp
725262014-05-03
17:47		2018-10-21
20:45		Connector / NETNo Feedback
(3364 days)		S26.8.3AnyAnyFails to generate correct SQL for one-to-one relationships in Entity Framework 6
974622019-11-03
15:05		2019-11-12
16:37		MySQL Server: OptimizerCan't repeat
(1620 days)		S58.0.17FreeBSD (12.0)x86Slow JOIN with ORDER BY due wrong index selection
1027912021-03-03
5:03		2021-03-05
13:13		MySQL ServerNot a Bug
(1142 days)		S35.7.30 GAAnyAnyA deadlock occurs one innodb tables between unrelated rows
298452007-07-17
13:10		2011-02-16
23:43		MySQL Server: OptimizerVerified
(6002 days)		S46.0.0-alphaAnyAnyGROUP BY does not make best use of indicies when evaluating SUM aggregates
419842009-01-08
22:28		2011-02-16
23:43		MySQL Server: InnoDB storage engineCan't repeat
(5499 days)		S35.1.22rc 5.1.30 GAAny (Linux, Windows)Anyinserts with auto-increment fails
309432007-09-11
6:43		2007-09-11
6:47		MySQL Server: User-defined functions ( UDF )Not a Bug
(6065 days)		S25.1.21, 5.0.45Linux (SuSE-10)AnyUPDATE where key depends on function VERY slow.
553852010-07-20
4:51		2011-03-02
15:24		MySQL Server: DMLClosed
(4797 days)		S3mysql-next-mr-wl5136-stage, 5.1AnyAnyUPDATE statement throws an error, but still updates the table entries
676372012-11-19
16:44		2013-01-22
13:50		MySQL Server: OptimizerClosed
(4105 days)		S35.6.7, 5.6.8AnyAnyEXPLAIN UPDATE output doesn't match query execution
808852016-03-29
12:59		2016-04-01
7:29		MySQL Server: DMLVerified
(2940 days)		S25.7.11Debian (Debian GNU/Linux 8 (jessie))AnyNot null update fails with an "Column cannot be null" error.
829902016-09-14
12:29		2016-09-14
13:44		MySQL Server: ParserDuplicate
(2774 days)		S3AnyAnyMultiple UPDATE query separated by 'AND' not detected Syntax Error
974182019-10-29
15:25		2020-01-28
4:10		MySQL Server: OptimizerClosed
(1543 days)		S55.7, 5.7.28AnyAnyMySQL chooses different execution plan in 5.7
105632005-05-11
17:23		2007-07-03
19:05		Connector / ODBCClosed
(6135 days)		S23.51.11Windows (Windows XP SP1)AnyUpdate using multicolumn primary key with duplicate indexes fails
134732005-09-25
22:49		2006-09-07
0:16		MySQL Server: DocumentationClosed
(6434 days)		S35.0.12* / windowsAnyBefore insert trigger executed, without insert happening
35912004-04-28
16:49		2004-04-28
18:50		MySQL Server: ReplicationNot a Bug
(7296 days)		S24.0.18Linux (redhat 9)AnyReplication sending Errored SQLs to Slave
55202004-09-10
18:33		2004-09-10
20:58		MySQL Server: MyISAM storage engineNot a Bug
(7161 days)		S24.0.20-standardpc-linuxAnyInsert statement failing on duplicate key
210722006-07-14
22:51		2007-12-14
20:32		MySQL Cluster: Cluster (NDB) storage engineClosed
(5971 days)		S25.2AnyAnyDuplicate key error in NDB references wrong key
239452006-11-03
15:59		2006-11-07
23:44		MySQL Server: Falcon storage engineClosed
(6373 days)		S1AnyAnycrash during drop table, AUTOCOMMIT=0, CREATE TABLE .. AS SELECT
354872008-03-21
18:14		2008-03-28
14:37		MySQL ServerCan't repeat
(5866 days)		S15.0.37-communityLinuxAnyDuplicate Entry For Key error reports truncated key value
369122008-05-23
11:36		2008-07-28
21:16		MySQL Server: ErrorsCan't repeat
(5744 days)		S36.0-bkAnyAnywrong error messages
433072009-03-02
13:25		2011-02-16
23:43		MySQL Server: DocumentationClosed
(5524 days)		S15.1, 6.0AnyAnydefault collation will be ignored
458852009-07-01
18:26		2010-05-26
17:59		MySQL Server: Falcon storage engineUnsupported
(5077 days)		S36.0.12-bzrAnyAnyPrimary key added to Falcon table allows non-unique values.
1141332024-02-27
2:39		2024-02-27
12:38		MySQL Server: InnoDB storage engineCan't repeat
(52 days)		S38.3.0-debugOracle Linux (v9, WSL v2 over Windows11)x86dd corrupt assert lob0impl.cc:1237:total_read == len || total_read == avail_lob
85652005-02-17
11:50		2022-12-04
20:45		MySQL Server: DDLDuplicate
(4298 days)		S25.0.30Any (*)AnyALTER TABLE MODIFY adds duplicate keys which slow down SELECTs
238732006-11-02
4:46		2006-11-02
6:51		MySQL ServerNot a Bug
(6378 days)		S35.0.27Windows (Win2003)AnySELECT statement works, but not done as CREATE VIEW AS
263162007-02-13
12:01		2022-04-28
15:04		MySQL Server: InnoDB storage engineClosed
(5007 days)		S25.0.36-BK, 5.0.32, 5.0.38BK, 5.1.17BKAny (*)AnyTriggers create duplicate entries on auto-increment columns
326562007-11-23
12:33		2011-02-16
23:43		MySQL Cluster: Cluster (NDB) storage engineClosed
(5322 days)		S15.1AnyAnyNDB: Duplicate key error aborts transaction in handler. Doesn't talk back to SQL
443812009-04-21
12:28		2014-01-24
14:29		MySQL Server: Falcon storage engineWon't fix
(3738 days)		S36.0-falcon-teamLinuxAnysysbench v0.5 oltp_complex_rw.lua test fails with duplicate entry error
461882009-07-15
3:31		2011-02-16
23:44		MySQL Server: DDLNo Feedback
(5361 days)		S2AnyAnyServer raises fatal exception if engine returns error during ONLINE ALTER
700602013-08-16
15:09		2018-04-24
1:00		MySQL Server: ErrorsNo Feedback
(2188 days)		S25.6AnyAny"Access denied using password no" for slave w/ password, can't connect 2 slaves
718962014-03-01
15:28		2014-04-04
1:00		MySQL WorkbenchNo Feedback
(3669 days)		S26.0MacOS (10.8.5)AnyMySQLWorkbench crashes frequently on OSX
824752016-08-05
13:40		2018-02-03
10:26		MySQL Workbench: SQL EditorVerified
(2267 days)		S46.3.10AnyAnyduplicate values in column
210592006-07-14
13:10		2006-08-17
8:51		MySQL Cluster: Cluster (NDB) storage engineClosed
(6455 days)		S15.1.11, 5.0.19Linux (Linux)AnyServer crashes on join query with large dataset with NDB tables
264802007-02-19
17:31		2007-04-12
14:20		MySQL Server: InnoDB storage engineNot a Bug
(6217 days)		S25.0Windows (Windows XP)Anyon update cascade crashes when a foreign key belongs to the primary key
1038372021-05-28
9:32		2021-05-28
9:54		MySQL Server: LoggingVerified
(1057 days)		S4All, 8.0AnyAnySuggest to add materialized view log for innodb tables
1131382023-11-20
7:43		2023-11-20
13:15		MySQL ServerNot a Bug
(151 days)		S38.2.0AnyAnyOptimization of MySQL query with LIMIT
112872005-06-13
12:58		2005-07-21
14:30		MySQL ServerNo Feedback
(6847 days)		S35.0.6Linux (CentOS4)AnyErrors in stored procedure (ERROR 1418, ERROR 2013)
113052005-06-14
7:05		2020-04-11
13:22		MySQL Server: InnoDB storage engineClosed
(6882 days)		S34.0.16Windows (Windows 2000)AnyOn Update Cascade not working with two references to the same field
450552009-05-24
17:25		2011-02-16
23:44		MySQL Server: ErrorsClosed
(5444 days)		S15.0.41Linux (4)Anyupdate error: Column count doesn't match value count at row 1
717362014-02-16
13:23		2016-10-19
17:28		MySQL Server: DocumentationClosed
(2739 days)		S35.6AnyAnyManual does not explain locks set by UPDATE properly
937872019-01-02
18:07		2021-03-17
10:45		Connector / ODBCNo Feedback
(1344 days)		S35.3.9, 5.3.11, 8.0.13Windows (Server 2012 R2)Other (x64)Auto-inc primary key field changes to 0 on update with ODBC > 5.3.4
163242006-01-10
6:02		2019-10-28
22:42		MySQL Server: DMLClosed
(1635 days)		S45.0.12Windows (windows & linux)Anyauto_increment primary key can be updated,and then insert record fail
72902004-12-14
17:27		2016-01-03
20:45		MySQL Server: InnoDB storage engineOpen
(5090 days)		S44.1.7Solaris (Solaris)Anyupdate should check primary keys after all records altered
580272010-11-06
9:26		2011-02-16
23:44		MySQL WorkbenchNo Feedback
(4881 days)		S3Windows (windows 7)AnyMysql Duplicate entry Error to Update A Table
1144982024-03-27
16:03		2024-03-28
12:43		MySQL WorkbenchDuplicate
(22 days)		S38.0.36Windows (Microsoft Windows 11 Enterprise)x86 (Ryzen 4600H)MySQL Workbench failed to check for update
683022013-02-07
13:47		2013-12-31
11:14		MySQL Server: InnoDB storage engineCan't repeat
(3762 days)		S15.5.32LinuxAnyMySQL crashed when trying to free page that is already marked as free
2602003-04-09
10:57		2003-06-19
6:54		Connector / ODBCClosed
(7610 days)		S33.51 AnyParsing the key columns while generating cursor based updates/deletes query
25352004-01-27
11:56		2004-01-27
12:48		MySQL Server: InnoDB storage engineWon't fix
(7388 days)		S34.0.17Linux (Linux Intel)AnyForeign Keys on InnoDB tables not honoured.
281032007-04-25
19:34		2007-04-27
14:25		MySQL Query BrowserClosed
(6202 days)		S31.2.11AnyAnyMySQL Query Browser ON UPDATE/DELETE NO ACTION not set on foreign keys
610882011-05-07
7:59		2012-01-17
20:17		MySQL Server: InnoDB storage engineCan't repeat
(4476 days)		S15.5.9Linux (Ubuntu 64 bit)AnyCannot alter table or update all row in table at all
756312015-01-26
4:42		2015-01-26
4:42		MySQL Cluster: Cluster (NDB) storage engineOpenS47.3.8 GPLWindows (2008)AnyRquest for foreign key constrain on update cascade and native primary key update
806182016-03-04
15:08		2016-05-16
23:15		MySQL Workbench: ModelingClosed
(2895 days)		S36.3.6Windows (Microsoft Windows 10 Pro)AnyForard Engineered DB Script for table with virtual field has syntax error
1047342021-08-26
8:51		2021-08-27
15:18		MySQL ServerUnsupported
(966 days)		S25.7.33Other (LINUX AWS RDS x86_64)x86 (AWS RDS Master-Slave set up)Parallel one record update by unique key cause deadlock
213012006-07-26
16:22		2006-08-26
23:34		MySQL ServerNo Feedback
(6446 days)		S24.1.15Linux (RedHat/Fedora Core)AnySQL Error updating table when primary key contains multiple columns
21592003-12-18
11:10		2004-01-15
12:33		MySQL ServerClosed
(7400 days)		S1v4.0.15-standardLinux (Linux/Windows)AnyUPDATE of LONGBLOB >= 16Megs corrupts table
23772004-01-13
11:49		2004-02-03
7:51		MySQL Server: MyISAM storage engineClosed
(7381 days)		S14.0.16Linux (Linux)AnyUPDATE privilege BUG
51652004-08-23
11:19		2004-08-23
16:38		MySQL Server: InnoDB storage engineWon't fix
(7179 days)		S24Any (All)AnySELECT ... FOR UPDATE uses 'select' privelege instead 'update'
150282005-11-17
17:21		2005-12-08
23:53		MySQL ServerClosed
(6707 days)		S35.0.17-BK, 5.0.15, 4.1.14/5.0.13Linux (Linux, Windows, Solaris)AnyUpdate multiple tables updates more rows than expected
196082006-05-08
13:50		2006-05-08
14:09		MySQL ServerNot a Bug
(6556 days)		S34.0.18, 5.0.16Solaris (Solaris, Linux(Mandrake 10.2))AnySeparating multiple 'ColName = ExpName' statements within Update x Set ...
313912007-10-04
9:46		2008-01-31
8:21		MySQL Cluster: ReplicationCan't repeat
(5923 days)		S25.1.20Linux (x86_64)AnyReplication broken after few UPDATE on RAM disk only with mod_ndb
366762008-05-12
22:05		2016-02-25
12:24		MySQL Server: DMLClosed
(5811 days)		S25.0.58AnyAnyUPDATE on TEXT column using LEFT JOIN doesn't update all rows
396952008-09-27
15:14		2008-12-13
9:03		MySQL Server: Falcon storage engineClosed
(5606 days)		S16.0-falcon-team (6.0.8a)LinuxAnyCrash in SRLUpdateRecords::thaw during falcon_chill_thaw test
565652010-09-05
10:08		2010-09-06
20:50		MySQL Server: DMLNot a Bug
(4974 days)		S35.1.36AnyAnyMultiple update syntax doesn't update rows multiple times
687262013-03-20
11:22		2014-07-14
15:28		MySQL Server: DMLClosed
(3567 days)		S35.5.30 and 5.6.10, 5.1.70, 5.5.32, 5.6.12WindowsAnyUpdate trigger invoked when update ignore means that no update is performed
836592016-11-02
20:47		2016-11-08
16:34		MySQL Server: ReplicationUnsupported
(2719 days)		S3Percona-XtraDB-Cluster-5.5.39-25.11LinuxAnyReplication Statements Missing From Binary Logs
1026762021-02-21
18:29		2021-02-22
21:03		MySQL Server: LockingNot a Bug
(1152 days)		S25.7.12, 8.0.11Linux (RDS of AWS)AnyIn REPEATABLE READ, the behavior after executing select for update is strange.
1030592021-03-22
12:35		2021-03-23
5:35		MySQL Server: InnoDB storage engineVerified
(1124 days)		S38.0.23AnyAnysystem_variable_source does not report DYNAMIC when queried from sys_var update
1041172021-06-26
2:36		2021-06-26
2:39		MySQL Server: Group ReplicationClosed
(1028 days)		S2mysql8.0.23 mysql8.0.24AnyAnyMGR all second node abnormal stop
1041182021-06-26
2:42		2022-08-23
8:45		MySQL Server: Security: PrivilegesVerified
(1025 days)		S28.0.24AnyAnyMGR all second node abnormal stop
1081552022-08-16
16:22		2024-03-12
11:04		MySQL Server: DMLDuplicate
(38 days)		S38.0.30AnyAnyBEFORE INSERT trigger causes Error 1048 during UPDATE
1091962022-11-24
15:39		2022-11-25
14:45		MySQL Server: InnoDB storage engineVerified
(511 days)		S38.0AnyAnyFOR UPDATE doesn't block FOR SHARE if secondary index is used
1113772023-06-13
2:40		2023-06-13
7:55		MySQL Server: DMLVerified
(311 days)		S68.0.33Ubuntu (20.04 LTS)x86 (Intel(R) Core(TM) i7-10700 CPU) int mysql_execute_command(THD*, bool): Assertion `!thd->in_sub_stmt' failed
692432013-05-15
11:56		2019-08-14
19:58		MySQL Server: FULLTEXT searchNo Feedback
(3956 days)		S25.6.11WindowsAnyCan't update InnoDB table with fulltext index defined
698722013-07-30
15:53		2013-07-30
16:54		MySQL Server: Stored RoutinesDuplicate
(3916 days)		S35.6AnyAnyUPDATE in stored function is not rolled back
42242004-06-20
13:40		2004-06-21
16:07		MySQL Server: DocumentationClosed
(7242 days)		S3 AnyGerman documentation misses INSERT ON DUPLICATE KEY-syntax
121582005-07-25
17:32		2005-07-25
17:52		MySQL ServerCan't repeat
(6843 days)		S25.0.3Solaris (Solaris)AnyON Duplicate Key when field Truncated causes Server Hang
152362005-11-24
20:47		2006-03-09
15:42		MySQL Server: PartitionsCan't repeat
(6616 days)		S35.1.2-alpha-debugLinux (SUSE 10.0)AnyPartitions: crash, if Insert .. on duplicate key causes update of existing row
196562006-05-09
21:55		2006-05-23
14:43		MySQL Server: DocumentationClosed
(6541 days)		S35.1.11 AnyMySQL Error log flooded with [ERROR] NDB Binlog: Duplicate key on write or upda
244402006-11-20
15:06		2006-11-21
9:57		Connector / NETClosed
(6359 days)		S3Connctr./NET 1.0.7Windows (Win XP SP2)AnyPrepared statement with more than 4 parameters and ON DUPLICATE KEY clause fails
244912006-11-21
23:20		2007-02-03
2:34		MySQL Server: Stored RoutinesClosed
(6285 days)		S35.0.27, 5.1 BKLinux (Linux, Windows)Anyusing alias from source table in insert..on duplicate key
251232006-12-17
19:28		2007-02-08
18:40		MySQL Server: ViewsClosed
(6280 days)		S35.0.30/5.1BKFreeBSD (freebsd)Anyinsert into view on dup key, allows cross table reference
263422007-02-13
20:23		2007-06-19
12:37		MySQL Cluster: Cluster (NDB) storage engineClosed
(6149 days)		S25.0.38 | mysql-5.1-telcoLinux (CentOS 4.4 | Fedora)Anyauto_increment_increment AND auto_increment_offset REALLY REALLY anger NDB clust
319712007-10-30
23:08		2019-10-29
22:33		MySQL Server: DMLCan't repeat
(1634 days)		S35.0.51 and 5.0.45Any (Debian, FreeBSD)Anylast_insert_id with on duplicate key still broken
337362008-01-08
9:53		2008-01-14
6:51		MySQL Server: GeneralClosed
(5940 days)		S25.1.22(5.1.19, 6.0.3)AnyAnymysql crash on error sql with INSERT DELAYED and ON DUPLICATE KEY UPDATE
395972008-09-23
4:38		2018-04-08
20:45		Tests: ServerDuplicate
(5687 days)		S35.1+AnyAnyVarious partition errors have changed output - need to update test results
456772009-06-23
13:08		2011-02-16
23:44		MySQL Server: ReplicationClosed
(4915 days)		S25.1.35 and 5.4.0AnyAnySlave stops with Duplicate entry for key PRIMARY when using trigger
520202010-03-12
21:49		2017-12-22
8:24		MySQL Server: InnoDB storage engineClosed
(4489 days)		S35.0, 5.1.46AnyAnyInnoDB can still deadlock on just INSERT...ON DUPLICATE KEY
629612011-10-27
8:02		2011-10-27
17:20		MySQL Server: DMLOpenS45AnyAnyupdate..........on duplicate Key delete
665652012-08-28
6:46		2012-08-28
9:01		MySQL Server: Federated storage engineNot a Bug
(4252 days)		S25.5.28AnyAnyInsert into federated table
906882018-04-30
10:37		2019-05-22
18:37		Connector / JVerified
(2178 days)		S38.0.11AnyAnyStatement.getGeneratedKeys() returns too many rows on INSERT .. ON DUPLICATE KEY
1061132022-01-08
6:52		2022-01-08
9:45		MySQL Server: ReplicationVerified
(832 days)		S28.0.27, 5.7.36Anyx86Contribution by Tencent: insert on duplicate key cause 1032 replication error in
1095102023-01-02
15:14		2023-01-03
14:21		MySQL Server: GeneralNot a Bug
(472 days)		S28.0.31-0ubuntu2Ubuntu (22.04)AnyON DUPLICATE KEY UPDATE change wrong row
1120072023-08-09
9:32		2023-08-09
9:39		MySQL Server: DDLVerified
(254 days)		S3Any, 5.7, 8.0AnyAnyFOREIGN KEY (reference the hidden part of key) should not have the UK's name.
35512004-04-23
10:54		2004-04-28
12:10		MySQL ServerCan't repeat
(7296 days)		S25.0.0-alphaLinux (Linux)AnyIncorect row count on query
85582005-02-16
21:51		2005-02-16
23:32		MySQL Server: MyISAM storage engineNot a Bug
(7002 days)		S34.0.18-standardLinux (Linux 2.4.22 (Mandrake 9))AnyPoor query plan with merge tables
126622005-08-19
2:20		2005-08-19
2:41		MySQL ServerDuplicate
(6818 days)		S25.0.9FreeBSD (FreeBSD 5.4)AnyPoor View Performance
132182005-09-15
10:25		2005-09-24
3:51		MySQL Server: OptimizerClosed
(6782 days)		S34.1.14-nt, 4.1.15-BKWindows (Windows XP, Linux)Anyselect MIN(..) / InnoDB: using a partial-field key prefix in search
167362006-01-23
22:44		2006-03-16
9:38		MySQL Server: DocumentationClosed
(6609 days)		S25.1.6-alphaLinux (Linux)AnyImplicit partitioning key not displayed.
175902006-02-20
17:44		2006-02-23
9:32		MySQL Server: OptimizerCan't repeat
(6630 days)		S25.1.7-betaAny (All)AnyDifferent key-len and # rows reported on all platforms
188002006-04-05
13:13		2006-08-07
7:52		MySQL Server: InnoDB storage engineClosed
(6465 days)		S25.1Linux (Linux)AnyUnicode quoted foreign key references are broken
192132006-04-20
9:16		2006-05-20
16:30		MySQL ServerNo Feedback
(6544 days)		S24.1.16Linux (linux x86_64)AnyTable Locked after wrong Query
194632006-05-01
18:48		2006-05-01
19:58		MySQL ServerNot a Bug
(6563 days)		S25.xWindows (windows)AnyBug in executing SQL scripts that has a key named Group
196532006-05-09
21:49		2007-10-26
2:50		MySQL Server: DocumentationClosed
(6020 days)		S25.0.21AnyAnyYaSSL: is passphrase removing optional for keys?
202982006-06-06
16:27		2006-06-11
4:40		MySQL ServerNot a Bug
(6522 days)		S15.0.22MacOS (Mac OS X)AnySpecified key was too long; max key length is 1000 bytes
217132006-08-18
9:23		2007-02-14
16:41		MySQL Server: Information schemaClosed
(6274 days)		S35.1.12-BK, 5.1.11 betaLinux (Ubuntu 6 (Linux 2.6.15))Anyincorrect value for the REFERENTIAL_CONSTRAINTS.UNIQUE_CONSTRAINT_NAME column
327352007-11-26
19:40		2011-02-16
23:43		MySQL Cluster: Cluster (NDB) storage engineWon't fix
(4987 days)		S3mysql-5.0MacOS (10.5 (x86: 32 bit))AnyNdb is unreliable, fails with varying symptoms (platform-specific): debug server
351372008-03-07
9:45		2008-07-09
7:26		MySQL Cluster: Cluster (NDB) storage engineClosed
(5763 days)		S25.1.23AnyAnyQuery crashed mysqld
413322008-12-09
16:01		2021-05-02
20:45		MySQL Cluster: Cluster (NDB) storage engineDuplicate
(5576 days)		S1Cluster 6.3.20AnyAnyInsert into partitioned "ndbcluster" table causes server crash
440572009-04-02
22:28		2011-02-16
23:43		MySQL Server: InnoDB storage engineNo Feedback
(5462 days)		S25.0.51aLinux (14.12 Distrib 5.0.51a, for debian-linux-gnu (x86_64))AnyUnable to create new tables with foreign key references in big databases
457872009-06-26
11:35		2011-02-16
23:44		MySQL Server: DDLClosed
(5411 days)		S35.0.67LinuxAnyALTER TABLE doesn't differentiate between unique and foreign key
479632009-10-09
23:07		2016-02-25
12:24		MySQL Server: OptimizerClosed
(5152 days)		S15.1.39, 5.1.41AnyAnyWrong results when index is used
513782010-02-22
9:57		2011-02-16
23:44		MySQL Server: InnoDB Plugin storage engineClosed
(5022 days)		S35.1+AnyAnyInit "ref_length" to correct value, in case an out of bound MySQL primary_key
585242010-11-26
17:19		2013-03-03
20:45		MySQL Server: MyISAM storage engineVerified
(4889 days)		S45.xAnyAnyMore detailed information on custom key caches
685342013-03-01
7:00		2013-04-17
17:09		MySQL Workbench: SQL EditorNot a Bug
(4020 days)		S3MySQL 5.5WindowsAnyPrimary Key - NULL Paradox
700132013-08-13
11:29		2013-08-13
12:54		MySQL ServerDuplicate
(3902 days)		S25.5.23Linux (Red Hat Enterprise Linux Server release 5.8 (Tikanga) 64 bit)Anyselect count from innodb partitioned table with compound key can crash db
732992014-07-16
14:59		2014-07-18
9:26		MySQL Server: DDLVerified
(3563 days)		S25.6.19, 5.6.20AnyAnyDEFAULT value for PRIMARY KEY column depends on the way to declare it PRIMARY
826102016-08-17
10:38		2016-09-18
1:00		MySQL WorkbenchNo Feedback
(2771 days)		S16.3.7MacOSAnyMySQL WorkBench alter table window miss primary key
832982016-10-07
9:52		2016-10-20
12:50		MySQL Server: OptimizerDuplicate
(2738 days)		S25.6.10Debian (debian-linux-gnu (x86_64) using readline 6.2)AnyMYSQL 5.6.10 Optimiser selecting wrong index
883342017-11-02
16:29		2019-08-23
14:29		MySQL for Windows: InstallerVerified
(1701 days)		S35.7.20Windows (Windows 10)AnyWeb community Installer fails to install MySQL Server 5.7.20
923922018-09-12
20:53		2023-08-17
7:46		MySQL Server: InstallingNo Feedback
(1926 days)		S18.0.12Windows (Windows 10 Pro 64 bit)AnyThe action 'Install' for product 'MySQL Server 8.0.12' failed
938452019-01-07
21:55		2021-08-23
12:23		MySQL Server: OptimizerVerified
(1927 days)		S25.7,8.0.11,8.0.13AnyAnyOptimizer choose wrong index, sorting index instead of filtering index
969582019-09-20
21:42		2019-09-22
14:28		MySQL Server: OptimizerVerified
(1671 days)		S38.0AnyAnyMySQL optimizer wrongly chooses to use a bigger and inefficient index for query
1000172020-06-27
14:02		2023-05-05
8:00		MySQL Server: MyISAM storage engineDuplicate
(1390 days)		S58.0.20AnyAnyExtremely slow queries after database repair
1021932021-01-08
12:21		2021-01-15
14:06		MySQL Server: OptimizerNot a Bug
(1193 days)		S38.0.22CentOS (CentOS Linux release 8.0.1905 (Core))x86 (4.18.0-80.el8.x86_64 )Inaccurate execution plan selection
157622005-12-14
23:34		2006-06-18
21:25		MySQL ServerNo Feedback
(6515 days)		S25.0.16-1Linux (debian, unstable)Anylosing connection on queries after creating view
206702006-06-23
21:26		2006-10-05
16:15		MySQL Server: Stored RoutinesClosed
(6406 days)		S35.0.23-bkAny (Any)AnyUPDATE using key and invoking trigger that modifies this key does not stop
246682006-11-28
19:02		2016-01-03
20:45		MySQL Server: InnoDB storage engineVerified
(5090 days)		S45.0.32-BK, 5.0.27Linux (Linux, Windows XPsp2)AnyCASCADING FOREIGN KEYS do not work on same TABLE
509172010-02-04
15:23		2012-05-18
20:19		MySQL Server: ReplicationVerified
(4886 days)		S35.1.43,5.5.2-m2AnyAnyslave stops with HA_ERR_KEY_NOT_FOUND
509272010-02-04
19:29		2011-02-16
23:44		MySQL Enterprise Monitor: ServerClosed
(5163 days)		S32.1.0.1096AnyAnyDelete server fails on foreign key error to rule_schedules table
577332010-10-26
9:43		2011-02-16
23:44		MySQL Workbench: ModelingVerified
(4922 days)		S4ALLAnyAnyDuring data insert/update show foreign key values
132262005-09-15
15:18		2005-10-18
10:14		MySQL ServerNo Feedback
(6758 days)		S24.1.11Windows (WinXP SP2)AnyAUTO_INCREMENT attempting to insert zero value
134312005-09-23
15:21		2014-01-16
2:56		MySQL Server: InnoDB storage engineClosed
(3746 days)		S35.0Linux (Linux)AnyDuplicate FOREIGN KEY error does not make sense
162222006-01-05
13:21		2006-01-09
0:31		MySQL ServerNot a Bug
(6675 days)		S34.0.22Linux (Linux)AnySelect on truncated keys
1093132022-12-08
7:33		2023-03-14
19:09		Shell Dump & LoadClosed
(435 days)		S28.0.31CentOS (7.9)x86Can't restore loadDump with deferTableIndexes=all by MySQL Error 1061
95122005-03-31
2:29		2005-04-04
5:30		MySQL Server: InnoDB storage engineNot a Bug
(6955 days)		S34.1.10aAny (All)AnySELECT FOR UPDATE returns phantom rows
256202007-01-15
6:54		2020-05-03
20:45		MySQL Server: DMLVerified
(5980 days)		S35.0.33Windows (Windows Server 2003 Web Edition)AnyError in ADDTIME function when update more 35 days
364702008-05-02
12:12		2012-05-18
20:19		Connector / ODBCDuplicate
(5659 days)		S35.1AnyAnyODBC update boolean wrong in MySQL ODBC 5.1, correct in MySQL ODBC 3.51
548632010-06-28
16:38		2011-02-16
23:44		Connector / NETClosed
(5029 days)		S26.2.3WindowsAnyBug in MySqlDataAdapter update method
672612012-10-16
10:36		2015-08-10
14:34		MySQL Server: mysqldump Command-line ClientDuplicate
(4186 days)		S35.6.7-rcWindows (Windows 8)Anymysqldump 5.6.7-rc does not export all tables in `mysql` database
708882013-11-12
11:21		2013-12-14
0:43		Connector / NETClosed
(3779 days)		S16.7.4Windows (7 x64)AnyNullReferenceException when try to save entity with TINYINT or BIGINT as PK
763522015-03-17
14:51		2015-04-08
16:29		MySQL ServerNot a Bug
(3299 days)		S2Ver 14.12 Distrib 5.0.67, for suse-linuxLinux (Suse Linux )Any“BEFORE UPDATE” trigger strange behaviour for table with two timestamp colums
763962015-03-19
19:42		2015-03-24
7:48		MySQL Server: DDLNot a Bug
(3314 days)		S25.6.22LinuxAnyTrigger behaving wrongly mysql
825922016-08-16
3:55		2016-09-02
13:11		MySQL Server: InnoDB storage engineNot a Bug
(2796 days)		S35.7.14AnyAnyMySQL InnoDB update locking
18902003-11-19
11:09		2003-12-10
5:37		MySQL Server: Embedded Library ( libmysqld )Closed
(7436 days)		S14.0.17Windows (Windows 2000/XP)Anytable handler and corruption bugs on multithread application
292512007-06-20
21:32		2007-07-11
22:27		MySQL ServerClosed
(6127 days)		S25.0.42, 5.1, 4.1Linux (Gentoo)AnyMySQL coerces special 0 enum values to '' when ALTERing the column
477742009-10-01
21:55		2011-02-16
23:44		MySQL Server: PartitionsClosed
(5272 days)		S35.5 WL#3352AnyAnyInnoDB: Assertion failure in thread 1769970576 in file row/row0mysql.c line 1355
685682013-03-05
3:17		2021-09-15
20:49		MySQL Server: ReplicationVerified
(3809 days)		S35.6.10Linux (CentOS 5.8 X64)AnyStop Slave statement will timeout not waiting the event group complete
965782019-08-16
22:08		2020-02-04
19:16		MySQL Server: DMLClosed
(1536 days)		S28.0.16, 5.7.27, 8.0.17AnyAny`Insert on duplicate key update` updates the wrong row
17212003-10-31
0:17		2012-05-18
20:19		MySQL Server: MyISAM storage engineNo Feedback
(7361 days)		S24.0.16Linux (Linux SuSE 8.2)AnyFalse duplicate key warnings on FULLTEXT columns
18242003-11-12
20:59		2003-12-10
9:11		MySQL Server: ReplicationClosed
(7436 days)		S24.0.13 (-log)Linux (Debian)Anyreplication fails for duplicate in primary key, which isn't true on master
20272003-12-05
13:27		2005-05-22
16:22		MySQL Server: MyISAM storage engineCan't repeat
(6907 days)		S14.1.1 (01 Dec 2003)Linux (GNU/Linux)AnyError "Duplicate entry ... for key ..." where not expected
60752004-10-13
22:19		2004-11-19
17:34		MySQL ServerNo Feedback
(7091 days)		S24.0.20a-ntWindows (Windows)AnyBogus Duplicate Key Error
78362005-01-12
14:24		2005-02-13
20:15		MySQL Server: ReplicationNot a Bug
(7005 days)		S34.0.22Linux (Redhat 9.0)AnyREPLACE INTO dies with Duplicate Key Error
126952005-08-20
15:35		2005-09-28
2:08		MySQL Server: OptimizerClosed
(6778 days)		S24.1.13Linux (Linux(Redhat9.0))AnyDuplicate entry 'xxxxx for key 1
145202005-10-31
20:31		2005-12-16
17:51		MySQL ServerNo Feedback
(6699 days)		S24.1.11Windows (Windows XP Pro 2002 SP2)AnyReplication fails with error "Error 'Duplicate entry '-1' for key 2'"
156002005-12-08
19:06		2005-12-09
11:27		MySQL Server: Stored RoutinesDuplicate
(6706 days)		S25.0 AnySELECT on ill FUNCTION gets warning instead of error
168402006-01-27
13:22		2006-02-10
20:38		MySQL ServerNot a Bug
(6643 days)		S1MySQL 5.0.18-standardMacOS (OSX 10.4, RedHat 4)AnyDuplicate Key error without keys being identical
185522006-03-27
18:55		2022-09-04
20:45		MySQL Server: PartitionsDuplicate
(6584 days)		S25.1 AnyPartitions: SP with cursor, autoincrement PK, duplicate key on insert
231902006-10-11
21:36		2006-11-12
5:18		MySQL Workbench PreviewNo Feedback
(6368 days)		S21.1.3 alphaWindows (WinXP)Anyduplicate foreign keys
253262006-12-29
9:19		2007-03-12
15:18		MySQL Server: ReplicationNo Feedback
(6248 days)		S15.1.14-betaLinux (Linux 2.6)AnySince table has been partitioned, replication fails due to duplicate key
280392007-04-23
19:50		2007-04-23
19:50		MySQL Server: Falcon storage engineClosedS3AnyAnyFalcon Crash if INSERT ON DUPLICATE KEY with two interleaving transactions
294602007-06-30
20:00		2007-10-19
20:56		MySQL Server: Falcon storage engineCan't repeat
(6027 days)		S36.0.1-BKAnyAnyfalcon - Can't find record in 't1'
298842007-07-19
0:00		2007-07-20
8:39		MySQL Server: MyISAM storage engineCan't repeat
(6118 days)		S35.0.27-community-ntWindows (XP SP2 fully updated)AnyDuplicate key problem
309072007-09-07
17:18		2011-02-16
23:43		MySQL Server: InnoDB storage engineClosed
(5054 days)		S25.1.22AnyAnyRegression: "--innodb_autoinc_lock_mode=0" (off) not same as older releases
338242008-01-11
17:56		2008-02-11
21:00		MySQL Server: Falcon storage engineCan't repeat
(5912 days)		S16.0.4-p3AnyAnyManipulations on a view and on the underlying table cause duplicate primary key
374482008-06-17
14:43		2008-06-19
18:21		MySQL ServerNot a Bug
(5783 days)		S25.0.51AnyAnyC with cedilla and tilde duplicate key unique entry event up
377182008-06-28
11:48		2018-09-25
21:47		Tests: ReplicationClosed
(5499 days)		S75.1AnyAnyrpl.rpl_stm_mystery22 fails sporadically on pushbuild
411862008-12-02
19:54		2018-09-25
21:50		Tests: ReplicationDuplicate
(5586 days)		S76.0-rpl, 5.1AnyAnyrpl_stm_mystery22 fails sporadically on pushbuild while waiting for slave start
433062009-03-02
13:16		2012-05-18
20:19		MySQL Server: CharsetsDuplicate
(5517 days)		S15.1, 6.0AnyAnyWrong utf8 collation default behaviour
493492009-12-02
13:29		2018-11-04
20:45		MySQL Server: OptimizerDuplicate
(4134 days)		S36.0AnyAnyWrong cost calculation for duplicate weed-out
559192010-08-11
17:12		2010-08-11
18:16		MySQL ServerNot a Bug
(5000 days)		S2 5.1.37sp1-enterprise-gpl-advanced-logLinux (RedHat 5.2)AnyDuplicate rows on Unique key
560192010-08-16
15:47		2013-01-31
11:49		MySQL Server: DocumentationCan't repeat
(4096 days)		S25.6.99-m5AnyAnyBlackhole slave replication: 2nd slave stops for two REPLACE statements
613712011-06-01
10:26		2011-06-02
12:16		MySQL Server: DMLNot a Bug
(4705 days)		S15.0.32-7etch12, 5.1.54-1ubuntu4Linux (Ubuntu 11.04)AnyDuplicate Key when inserting new auto increment value
653962012-05-23
7:24		2012-05-25
14:34		MySQL Server: ReplicationNot a Bug
(4347 days)		S15.5.17-55Linux (2.6.32-34-generic #77-Ubuntu SMP Tue Sep 13 19:39:17 UTC 2011 x86_64 GNU/Linux)AnyDuplicate Entry for Key 'primary' on query insert into select
674472012-11-01
12:33		2012-11-01
12:35		MySQL Server: DDLOpenS45.2AnyAnyTools/Options needs Define Primary Key
789342015-10-23
4:14		2015-10-26
13:37		MySQL Server: DMLNot a Bug
(3098 days)		S35.7.8AnyAnyFailed INSERT(Dup entry) still change LAST_INSERT_ID() for auto_increment col
1071572022-04-29
3:49		2022-04-29
5:41		MySQL Server: InnoDB storage engineVerified
(721 days)		S38.0.22, 8.0.29AnyAnyContribution by Tencent: Collation compare handling is confused in Innobase
1084882022-09-15
7:50		2022-09-19
13:59		MySQL ServerNot a Bug
(578 days)		S35.7.18, 5.7.35, 8.0AnyAnyGap locking issue in READ COMMITTED
1105652023-03-30
10:52		2023-04-17
18:28		MySQL Server: FULLTEXT searchVerified
(368 days)		S38.0.32AnyAnyAdding a fulltext index causes a "Duplicate entry '0'" for the primary key
1123722023-09-18
7:19		2023-09-21
9:36		MySQL Server: ParserCan't repeat
(211 days)		S38.0.33MacOSx86Select query returns duplicate rows
67092004-11-18
22:28		2005-10-04
10:06		MySQL ServerCan't repeat
(6772 days)		S35.0.2-alpha-debugLinux (SuSE 8.2)AnySubquery: table subquery allows duplicate column names
155752005-12-08
8:54		2005-12-09
5:10		EventumClosed
(6706 days)		S2 AnySearching for issues when creating a duplicate entry
206362006-06-22
20:58		2006-06-22
22:55		MySQL Workbench PreviewDuplicate
(6511 days)		S21.0.6 BetaWindows (Windows XP)Anyduplicate phantom relationships created by applying changes
223132006-09-13
14:32		2007-01-12
7:06		MySQL Cluster: Cluster (NDB) storage engineClosed
(6307 days)		S35.0,5.1 Anycan get duplicate log messages in cluster log
275752007-04-01
20:23		2009-05-26
11:53		MySQL AdministratorUnsupported
(5442 days)		S35.0r11MacOS (Mac OS X 10.4)AnyOdd error mesage for duplicate column names in Table Editor
344212008-02-08
16:04		2008-02-08
16:16		MySQL Server: InnoDB storage engineClosed
(5915 days)		S15.1.22 rcAnyAnyDUPLICATE of WHAT!!! RE bug 34420
350872008-03-05
17:54		2011-02-16
23:43		MySQL Server: GeneralClosed
(5456 days)		S25.0.50+AnyAnyInserting duplicate values at one time with DES_ENCRYPT leads to wrong results
368272008-05-20
18:57		2008-11-22
9:34		Connectors: DBD::mysql ( Perl )No Feedback
(5627 days)		S24.007MacOS (10.3.9 server)Anyrunning make on OS X server 10.3.9 yields duplicate function definitions, errors
392992008-09-08
6:50		2011-02-16
23:43		MySQL Server: PackagingWon't fix
(4887 days)		S35.0.67HP/UX (B.11.11 on PA-RISC)AnyHP-UX packages contain duplicate files instead of symlinks
474162009-09-17
14:19		2011-02-16
23:44		MySQL Server: Embedded Library ( libmysqld )Closed
(5043 days)		S26.0.14-alpha, mysql-peMacOS (10.6)AnyBuild failure on OS X 10.6: duplicate symbol _timed_mutexes
514512010-02-24
9:57		2012-05-18
20:19		MySQL Server: DDLDuplicate
(5106 days)		S35.1AnyAnyALTER TABLE DROP INDEX, ADD INDEX executed in opposite order
608282011-04-11
11:39		2011-04-11
17:01		MySQL Enterprise Monitor: Advisors/RulesVerified
(4757 days)		S4AnyAnyAdd rule to detect duplicate foreign keys
697322013-07-12
14:29		2017-10-09
8:42		MySQL Server: OptimizerNot a Bug
(3934 days)		S35.6.11 MySQL Community Server (GPL)AnyAnyLIMIT clause results in duplicate data across pages
760952015-03-02
13:29		2015-03-02
18:12		MySQL Server: ViewsNot a Bug
(3336 days)		S35.5.40MacOS (10.10.2)AnyCREATE VIEW with UNION does not allow duplicate column names in version 5.5.40
795912015-12-10
11:14		2017-08-04
13:00		MySQL Server: OptimizerClosed
(2902 days)		S35.7.9AnyAnyselect distinct not returning distinct rows in 5.7...
840302016-12-01
18:40		2017-01-02
1:00		MySQL Server: DMLNo Feedback
(2665 days)		S35.6.34LinuxAnyDuplicate entry error when doing GROUP BY with UTF collation
868902017-06-30
14:58		2017-07-10
11:57		MySQL Server: ReplicationNot a Bug
(2475 days)		S35.7CentOSAnyDupllicate Entry in Slave
873532017-08-09
8:30		2017-08-09
9:39		MySQL Cluster: Cluster (NDB) storage engineVerified
(2445 days)		S37.5.7AnyAny"ndb_restore --print-data" and "ndb_restore --print-sql-log" have duplicate row
1043362021-07-16
12:38		2021-07-17
18:27		MySQL Server: DMLVerified
(1007 days)		S18.0AnyAnyLEFT Join giving duplicate records for matching records from right table
264712007-02-18
13:55		2007-02-19
9:25		MySQL Workbench PreviewWon't fix
(6269 days)		S11.1.8alphaLinux (linux)Anygenerated request for two tables (many to many relation) bad request generated
391502008-09-01
7:45		2008-10-13
15:47		MySQL WorkbenchClosed
(5667 days)		S35.0.24AnyAnyRemove a table referenced in foreing key constraint
418442009-01-03
20:16		2022-08-21
20:45		MySQL Server: GeneralDuplicate
(5540 days)		S36.1.0-alphaLinux (SUSE 10.0 / 32-bit)AnyForeign keys: failure with varbinary update cascade
452792009-06-02
21:59		2011-02-16
23:44		MySQL Server: InnoDB storage engineNo Feedback
(5404 days)		S2MySQL-server-enterprise-5.0.54a-0.sles10Linux (SUSE Linux Enterprise Server 10 (x86_64) VERSION = 10)Anydeadlock when inserting into auto increment table, not lock on auto-inc
183092006-03-17
14:14		2012-05-18
20:19		MySQL Server: Stored RoutinesDuplicate
(6273 days)		S35.0.19, 5.1.7. 5.1.8Linux (Linux)AnyBEFORE UPDATE TRIGGERS on BLACKHOLE tables raise an error but work as expected
274432007-03-26
14:03		2007-03-26
14:33		MySQL Server: Stored RoutinesNot a Bug
(6234 days)		S25Windows (windows)Anynot able to create update trigger
724122014-04-21
15:42		2014-04-21
16:52		MySQL ServerNot a Bug
(3651 days)		S16.1.4Windows (Microsoft Windows 7 Enterprise Edition Service Pack 1 (build 7601), 64-bit)AnyUpdate Bug
760022015-02-23
8:14		2015-02-25
1:35		MySQL Server: OptimizerNot a Bug
(3341 days)		S35.6AnyAnydifferent plan when executing query using procedure
784122015-09-11
16:17		2017-01-13
9:03		MySQL Server: DocumentationClosed
(3052 days)		S25.6.24AnyAnyUPDATE with subquery is NOT optimized the same way as equivalent SELECT
978372019-12-01
5:01		2019-12-03
14:11		MySQL Server: InnoDB storage engineCan't repeat
(1599 days)		S65.7.27CentOS (CentOS 7.4)x86 (8Uxeon 16G memoy)An assertion failure occurs when multiple threads update a record concurrently
1118112023-07-19
9:38		2023-07-20
14:06		MySQL ServerCan't repeat
(274 days)		S28.0.33Linuxx86UPDATE statement with JOIN doesn't update any records
55532004-09-13
22:31		2004-09-23
9:59		MySQL ServerClosed
(7148 days)		S24.1.4Linux (Linux 2.4.20 debian)AnyUPDATE IGNORE with multiple tables can lock up mysqld connection,reproducable
96792005-04-06
14:38		2016-01-03
20:45		MySQL Server: InnoDB storage engineOpen
(5090 days)		S44.*Any (any)Anyerrors in cascaded updates
309222007-09-10
6:02		2008-09-04
18:49		MySQL Enterprise Monitor: ServerClosed
(5706 days)		S31.2.0.7481AnyAnyConstraint Violation Exception when starting several replication agents at once
388392008-08-18
3:08		2012-05-09
23:37		MySQL Server: InnoDB storage engineNot a Bug
(5089 days)		S45.1.25-rc, 5.1.26-rcAnyAnyauto increment does not work properly with InnoDB after update
501022010-01-06
12:52		2010-01-06
15:15		MySQL Server: InnoDB storage engineNot a Bug
(5217 days)		S35.1.37AnyAnyAUTO_INCREMENT increases when using UPDATE ON DUPLICATE
688892013-04-08
20:27		2013-09-11
17:18		Connector / NETClosed
(3873 days)		S1Net Connector 6.6.5AnyAnyEF 4.3.1 Code First Migration Tries to Migrate Already Migrated Database
27992004-02-14
16:18		2020-04-27
13:04		MySQL Server: InnoDB storage engineClosed
(7365 days)		S24.0.18Windows (Win NT)AnyMulti-table DELETE and Foreign Key (bad affected rows)
194952006-05-02
21:39		2020-11-22
20:45		MySQL Server: PartitionsDuplicate
(6554 days)		S25.1.10Linux (Linux 32 Bit OS)Anydefault-storeage-engine=ndb causes tables by other engines to be partitioned
416952008-12-23
0:29		2011-02-16
23:43		MySQL Server: GeneralClosed
(5561 days)		S36.1.0-alpha-debugLinux (SUSE 10.0 / 32-bit)AnyForeign keys: non-distinct value change
464892009-07-31
11:39		2013-12-20
7:04		MySQL Server: DDLWon't fix
(3773 days)		S36.1-fk-stageAnyAnyForeign keys: MERGE engine should be disallowed.
560082010-08-16
10:59		2011-02-16
23:44		MySQL ServerNo Feedback
(4964 days)		S2mysql-server-5.5.4FreeBSD (FreeBSD 7.2-RC1)AnyInquiry lag
685262013-02-28
15:59		2013-04-16
1:00		MySQL Server: FULLTEXT searchNo Feedback
(4022 days)		S25.6.10Windows (Server 2003 (SP2))AnyServer crash on UPDATEing an InnoDB table when adding a column to the FT index
749622014-11-21
13:24		2014-11-21
14:20		MySQL Server: OptimizerVerified
(3437 days)		S35.5/5.6AnyAnyMatching in char field type is not correct
755152015-01-15
13:18		2015-01-19
16:00		MySQL Cluster: Cluster (NDB) storage engineClosed
(3378 days)		S37.4AnyAnyModify SHOW CREATE TABLE output for better OpenStack integration
1098572023-01-31
8:55		2023-02-03
4:54		MySQL Server: ReplicationDuplicate
(441 days)		S25.7.38AnyAnyTruncate table with foreign key crash replication.
1125892023-10-02
15:16		2024-02-27
14:58		MySQL Server: Security: PrivilegesClosed
(52 days)		S38.0.33, 8.0.34AnyAnyER_ROW_IS_REFERENCED vs ER_ROW_IS_REFERENCED_2 breaks backwards compatibility
380432008-07-11
10:50		2008-09-30
20:36		MySQL Server: Falcon storage engineClosed
(5680 days)		S16.0-falconAnyAnyDeadlock between server and falcon when executing concurrent ALTER + DML
407882008-11-17
15:21		2011-02-16
23:43		MySQL ServerDuplicate
(5593 days)		S26.0.2WindowsAnyTransaction didn't work
435192009-03-09
23:32		2013-12-20
6:52		MySQL Server: GeneralWon't fix
(3773 days)		S36.1.0-alpha-debugLinux (SUSE 10 | 32-bit)AnyForeign keys: no error with RESTRICT and multi-table update
465212009-08-03
6:50		2011-02-16
23:44		MySQL Server: Data TypesNo Feedback
(5342 days)		S25.0.45LinuxAnycan't find rows when date column with primary key
481482009-10-19
10:31		2011-02-16
23:44		MySQL Server: PartitionsNo Feedback
(5233 days)		S25.1.34-logLinuxAnyCan select but 1032 error when update and delete
656482012-06-18
8:07		2013-07-04
13:14		MySQL Server: InnoDB storage engineNot a Bug
(3942 days)		S25.1.63, 5.5.24Any (Linux, Windows)AnyForeign key and uppercase / lowercase values
671232012-10-07
13:02		2012-10-12
12:56		MySQL Server: MyISAM storage engineVerified
(4207 days)		S15.5.27, 5.5.29, 5.1.67, 5.7.0Any (MS Windows 2008 64bit, Linux)Anyerror in mi_update.c:226
906752018-04-28
7:30		2018-05-02
13:34		MySQL Server: InnoDB storage engineNot a Bug
(2179 days)		S3mysql-5.7AnyAnyImproper Record lock With Primary Key. where key >= or <= N
191382006-04-17
12:52		2007-05-03
6:02		MySQL Server: Memory storage engineDuplicate
(6196 days)		S35.0.20, 5.0.19, 4.1.20Linux (Linux)AnyThe table 'foo' is full displayed on HEAP tables which shouldn't be full
379682008-07-08
12:56		2008-07-11
21:43		Connector / NETClosed
(5761 days)		S25.1.6Windows (Server 2003)AnyPrepared statements byte/tinyint causes data corruption.
1089402022-10-31
16:03		2022-11-04
10:09		MySQL Server: DMLVerified
(532 days)		S68.0.31Ubuntu (22.04)x86 (x86_x64)Duplicate update column assertion error
1097482023-01-23
23:06		2023-03-17
1:00		MySQL WorkbenchNo Feedback
(400 days)		S38.0.32MacOSAnyError downloading MySQl Workbench 8.0.32 version (Community)
1121452023-08-23
2:49		2023-09-15
14:48		MySQL Server: DMLClosed
(217 days)		S68.1.0Ubuntu (22.04)x86 (x86_64)Insert on duplicate assertion error
1136362024-01-14
10:24		2024-01-16
13:00		MySQL WorkbenchDuplicate
(94 days)		S18.0.34MacOS (unknown)AnyCrash when create a new model or open any saved model
275042007-03-28
19:34		2007-03-29
22:15		MySQL Server: GeneralDuplicate
(6231 days)		S25.0.36, 5.0.38Linux (Linux 2.6)AnyBugfix 23170 for INSERT...SELECT introduces regression to INSERT.. ON DUPLICATE.
281532007-04-29
14:10		2007-04-29
15:49		MySQL ServerClosed
(6200 days)		S25.0.37LinuxAnyOn duplicate update in conjuction with char field doesn't replicate properly
317372007-10-21
15:58		2007-10-21
17:30		MySQL ServerCan't repeat
(6025 days)		S35.0.38LinuxAnyINSERT SELECT - ON DUPLICATE KEY UPDATE
372062008-06-04
21:08		2008-06-04
21:45		MySQL ServerNot a Bug
(5798 days)		S35.0.51aAnyAnybulk increment contiguous unique values fails, constraint evaluated row-by-row
413912008-12-11
10:57		2009-05-15
13:39		MySQL Server: Falcon storage engineClosed
(5453 days)		S26.0.9-alpha,6.0.10-alphaAnyAnyfalcon.falcon_bug_22211 fails due to seeing duplicate entry
20592003-12-09
10:00		2012-05-18
20:19		MySQL ServerNo Feedback
(7406 days)		S24.1.0Windows (Windows 2000 SP6)AnyNATURAL JOIN changed behaviour
23612004-01-12
12:22		2004-01-14
4:05		MySQL ServerClosed
(7401 days)		S34.1.2Linux (SuSE 8.2)AnyALTER TABLE ... DROP PRIMARY KEY drops a non-primary key
25032004-01-24
15:20		2004-01-24
20:30		MySQL ServerNot a Bug
(7391 days)		S2 5.0.0a-alphaWindows (Window XP Professional)Anystored procedure creation errors
25142004-01-26
8:40		2008-09-29
21:32		MySQL ServerCan't repeat
(5681 days)		S24.0.18Windows (w2k)AnyTRUNCATE table with merge corupts table
42852004-06-25
13:11		2005-01-25
16:16		MySQL ServerClosed
(7024 days)		S34.1.3-beta bk treeLinux (Linux)Anymultiple key cache doesn't work properly
64352004-11-04
16:06		2004-11-08
11:50		MySQL Cluster: Cluster (NDB) storage engineClosed
(7102 days)		S14.1.8 bkLinux (gentoo 2.6)Anystrange behaviour of left join
89572005-03-04
21:23		2014-03-28
11:26		Connector / JClosed
(3675 days)		S13.1.6-7Windows (Win2Kserver)AnyMySQL service crash without errors
109122005-05-27
10:34		2012-05-18
20:19		MySQL Server: Embedded Library ( libmysqld )Duplicate
(6765 days)		S35.0.6 + 4.1.15various Unix (case-insignif. FS)AnyEmbedded tests show wrong path names
118692005-07-11
19:18		2005-08-08
15:49		MySQL Server: OptimizerClosed
(6829 days)		S14.1.12-nt, 5.0.7-nt-beta/5.0.10Windows (Windows XP1/Linux)AnyServer crashes making a union join query with fulltext search
126232005-08-17
13:50		2005-08-19
1:09		MySQL ServerCan't repeat
(6818 days)		S1>4.1.10Linux (LINUX 9.0)AnyMYSQL CRASH AND HANG THE MACHINE WHILE RUNNING THIS QUERY
136882005-10-02
11:43		2005-11-13
8:27		MySQL Server: Stored RoutinesCan't repeat
(6732 days)		S35.0.13-rc, 5.0.14-BKLinux (Linux, Windows)AnyLost connection with SELECT queries and DELETE in SP (WITH QUERY CACHE)
151332005-11-22
13:32		2006-08-17
11:23		MySQL Server: Federated storage engineClosed
(6455 days)		S25.0.16/5.0.17 BKLinux (Linux)Anyunique index with nullable value not accepted in federated table
157002005-12-13
4:52		2005-12-13
9:46		MySQL ServerDuplicate
(6702 days)		S15.0.16Linux (linux,windows)Anyleft join return null
157012005-12-13
5:03		2006-06-29
15:35		MySQL ServerNo Feedback
(6504 days)		S2?Linux (linux, windows)Anyleft join return null (additional for BUg#15700 )
157022005-12-13
6:02		2005-12-13
9:50		MySQL ServerDuplicate
(6702 days)		S1mysql5.0Windows (windows2000,redhat AS3,redhat8)Anyleft join bug
171062006-02-03
20:22		2006-06-04
4:11		Connector / NETClosed
(6529 days)		S31.0.7.30072Windows (Windows 2003 Server)AnyMySql.Data.MySqlClient.CharSetMap.GetEncoding thread synchronization issue
203892006-06-12
8:22		2006-07-19
4:08		MySQL Server: PartitionsClosed
(6484 days)		S15.1.12-BK debug, 5.1.11Linux (linux 2.4.20-8)Anyuse partition, server crash
218512006-08-26
19:04		2006-12-28
12:50		MySQL ServerNo Feedback
(6322 days)		S15.0.22FreeBSD (FreeBSD 6.1)AnyMysql keep crashing with page corruption on disk or a failed file read
224362006-09-18
9:55		2006-11-06
14:46		MySQL Server: TestsClosed
(6374 days)		S35.0.25Any (All)AnyFour tests require "innodb" to be configured, fail in "classic" build
230812006-10-07
23:23		2006-10-17
15:58		MySQL AdministratorClosed
(6394 days)		S31.2.4rcAny (any)Anyfalse primary key (only a unique key) makes changes on the column difficult
248792006-12-07
11:11		2007-06-04
18:13		MySQL Server: Prepared statementsClosed
(6164 days)		S34.1/5.0/5.1BKLinux (Linux)AnyPrepared Statements: CREATE TABLE (UTF8 KEY) produces a growing key length
269392007-03-07
23:20		2008-01-10
4:56		MySQL Server: MyISAM storage engineNo Feedback
(5944 days)		S34.1.22, 5.0.45Linux (RHEL 3)AnyWe randomly get "MySQL Error 1030: Got error 127 from storage engine" on MyISAM
276342007-04-04
5:36		2007-06-15
13:45		MySQL Server: TestsClosed
(6153 days)		S35.1-bkLinuxAnygroup_by test fails
279352007-04-18
20:22		2015-03-22
20:45		MySQL Server: DDLDuplicate
(5888 days)		S35.1-bk/5.0bkLinuxAnyTRUNCATE fires DELETE trigger if InnoDB table is referenced by a foreign key
307472007-08-31
10:23		2007-10-24
20:09		MySQL ServerClosed
(6022 days)		S25.0 & 5.1AnyAnyCreate table with identical constraint names behaves incorrectly
310742007-09-18
5:04		2007-11-25
14:41		MySQL Server: GeneralCan't repeat
(5990 days)		S35.0.50, 5.1.23BKAnyAnykeys on innodb spatial columns cause prefix warnings in logs
350912008-03-05
21:50		2008-03-07
9:28		MySQL Server: Data TypesNot a Bug
(5887 days)		S35.0.54a or newerAnyAnyIF (@...) Returns Incorrect Type - Regression from 5.0.44
359522008-04-10
1:20		2008-04-25
20:24		MySQL Server: OptimizerClosed
(5838 days)		S25.1.24AnyAnyRegression: 5.1.24 Results not returned for users with select privs as expected
364492008-05-01
10:09		2011-02-16
23:43		MySQL Server: OptimizerClosed
(5590 days)		S26.0.6-preAnyAnySignificant slowdown for (ANY|SOME) subqueries processed with semijoin
370672008-05-29
12:02		2011-02-16
23:43		MySQL Server: FULLTEXT searchWon't fix
(4964 days)		S15.0.51a, 5.0.75, 5.0 bzrLinux (Centos 5.1 x86_64)AnySELECT query hang in state FULLTEXT initialization
373282008-06-11
4:50		2014-08-12
2:08		MySQL Server: OptimizerWon't fix
(4197 days)		S35.0.60, 5.0.64AnyAnyOptimizer prefers ref access on multiple-column index over simple range access
373332008-06-11
8:58		2013-08-07
18:39		MySQL Server: OptimizerClosed
(3908 days)		S35.0.60, 5.0.64, 5.1.26AnyAnyOptimizer uses wrong index for the right table in LEFT JOIN
451852009-05-29
10:19		2014-08-18
6:44		MySQL Server: InnoDB storage engineCan't repeat
(3532 days)		S25.0.81-log, 5.6.6Linux (CentOS)AnyInnoDB: Warning: using a partial-field key prefix in search
473302009-09-15
15:39		2018-09-09
20:45		MySQL Server: OptimizerVerified
(5322 days)		S55.0.77, 5.1.34, 5.1.37Linux (Debian x64)AnySlow query with left join and having.
479062009-10-08
4:56		2011-02-16
23:44		MySQL Server: OptimizerNo Feedback
(5276 days)		S15.0.85, 5.1.37, 5.1.39, 6.0.9AnyAnyHaving an extra field in a table changes optimizer index choice for other column
522042010-03-19
8:45		2011-02-16
23:44		MySQL Server: InnoDB Plugin storage engineCan't repeat
(5022 days)		S1M3 (Celosia)MacOS (i386 max)AnySeveral tests using innodb fail with "Incorrect key file for table" on Mac OSX
536312010-05-13
20:54		2010-05-26
20:59		MySQL Server: MyISAM storage engineNot a Bug
(5077 days)		S35.0.41-community-logLinux (CentOS 5.4)AnyPrimary key index size optimisation disagrees with docs
542252010-06-04
8:12		2020-04-11
2:09		MySQL Server: OptimizerClosed
(1469 days)		S55.1.37, 5.1.49, 5.5.5-m3Linux (5.1.37-1ubuntu5.1)AnyOptimizer prefers table scan and filesort instead of index scan
578882010-11-01
10:21		2013-12-05
10:40		MySQL Server: DocumentationCan't repeat
(3788 days)		S35.1.51AnyAnyOpenSSL vs yaSSL: different behavior of --ssl-ca parameter
584062010-11-22
22:02		2012-02-06
23:12		MySQL Server: InnoDB storage engineClosed
(4456 days)		S25.1,5.6 (from trunk)AnyAnyIssues with copying partitioned InnoDB tables from Linux to Windows
597772011-01-27
12:33		2011-04-29
23:00		MySQL Server: ReplicationNo Feedback
(4740 days)		S15.1.48, 5.1.55SolarisAnyReplication over SSL; error 2026 most, but not all, of the time
604572011-03-14
9:00		2011-03-15
9:10		MySQL Server: OptimizerNot a Bug
(4784 days)		S15.5.9AnyAnySelect is not using index
622392011-08-23
13:27		2011-11-03
9:33		MySQL Workbench: ModelingVerified
(4552 days)		S45.2.23, 5.2.35AnyAnyAutomatically detect when a relationship is one-to-many or one-to-one
626792011-10-11
10:36		2011-10-11
12:09		MySQL ServerDuplicate
(4574 days)		S4AnyAnyFlow control in SQL scripts
653592012-05-18
12:41		2012-05-30
17:01		MySQL Server: InnoDB storage engineDuplicate
(4342 days)		S25.1.62LinuxAnybad select performance
663372012-08-12
16:31		2014-04-18
16:25		MySQL Cluster: Cluster (NDB) storage engineClosed
(3654 days)		S1gpl-7.2.7Solaris (5.10 Generic_147441-15 i86pc i386 i86pc)AnyCluster crashes Error 2341 (still exists in 7.2.7)
729072014-06-07
8:12		2014-06-18
7:47		MySQL Server: OptimizerCan't repeat
(3593 days)		S15.6.17LinuxAnyquery on same table in different slave using different plan
735422014-08-11
23:28		2014-09-13
1:00		MySQL Workbench: SQL EditorNo Feedback
(3507 days)		S26.1.7Windows (Microsoft build 9200, 64-bit)AnyDont add Foreign Key
790062015-10-28
21:02		2018-02-15
8:35		MySQL WorkbenchWon't fix
(2255 days)		S36.3.7MacOS (10.11.1)AnyCannot use ssh key authentication with new version of OpenSSH private key
857652017-04-03
7:43		2017-10-16
12:47		MySQL Server: InnoDB storage engineClosed
(2380 days)		S38.0.2 (trunk)AnyAnyAssert !rw_lock_own(lock, RW_LOCK_S) rw_lock_s_lock_func in include/sync0rw.ic
887042017-11-29
23:24		2017-12-05
13:32		MySQL Server: OptimizerNot a Bug
(2327 days)		S55.7.18-ndb-7.6.3-cluster-gplRed HatAnyCompound index (pkey) not used when it should be
950422019-04-17
8:22		2019-04-23
7:22		MySQL Server: OptimizerClosed
(1823 days)		S75.6.43CentOSx86mysql5.6 index problem
1003982020-07-31
8:33		2020-07-31
9:50		MySQL Server: OptimizerVerified
(1358 days)		S38.0.19, 5.7.31, 8.0.21AnyAnyThe results of aggregation operations are inconsistent in different partitions
1039092021-06-04
6:57		2021-11-01
1:00		Connector / NETNo Feedback
(902 days)		S38.0.21.0AnyAnyUnable to determine the provider name for provider factory of type 'MySql.Data.M
1042492021-07-08
6:31		2021-07-09
18:02		MySQL Server: ReplicationCan't repeat
(1015 days)		S28.0.16CentOS (8)x86A field with type integer(12) unsigned is replicated as a bigint
1088492022-10-21
17:09		2022-11-04
2:19		MySQL RouterVerified
(533 days)		S38.0.31AnyAnymysqlrouter bootstrap without password not working / incorrectly prompting
1090792022-11-14
15:03		2022-12-13
14:14		MySQL Server: InnoDB storage engineVerified
(493 days)		S45.7.39-log, 8.0.28Debian (Not tested on other OSes)x86 (Not tested on other architectures)InnoDB: The B-tree of index GEN_CLUST_INDEX is corrupted
1124462023-09-24
23:24		2023-10-03
10:07		MySQL ServerCan't repeat
(200 days)		S28.0.34Debian (Debian 11)x86 (x86-64)Fractured read at SERIALIZABLE
1135072023-12-25
4:04		2023-12-25
10:34		MySQL Server: DDLVerified
(116 days)		S38.0.35AnyAnygipk add column failed
17552003-11-05
2:43		2003-11-05
5:43		MySQL Server: MyISAM storage engineDuplicate
(7471 days)		S24.1.0-alpha and 4.0.12i386-linux and HP Alpha OSF1AnyUPDATE on MyISAM table with many rows fails with "Table is full" error
107952005-05-23
6:58		2008-10-03
19:11		MySQL ServerDuplicate
(5677 days)		S44.1.10Linux (Linux)AnyREPLACE reallocates new AUTO_INCREMENT
131842005-09-14
15:12		2005-09-14
17:25		MySQL ServerCan't repeat
(6792 days)		S23.1Linux (LInux)AnyUpdate messes up the Primary Key
455052009-06-15
15:47		2011-02-16
23:44		MySQL Server: ReplicationNo Feedback
(5340 days)		S15.1.35Linux (RHEL 5.3 (CentOS))AnyDeadlock condition with MyISAM table in version 5.1.35
471032009-09-03
15:57		2011-02-16
23:44		MySQL Server: Row Based Replication ( RBR )Closed
(5284 days)		S35.4AnyAnyRBR slave crash in table_def::type when modifying a merge table
477082009-09-29
11:06		2011-02-16
23:44		MySQL ServerNo Feedback
(5285 days)		S25.1.30-ndb-6.3.20-cluster-gplLinux (Fedora 8)AnyCannot add or update a child row: a foreign key constraint fails
531452010-04-25
20:51		2011-02-16
23:44		MySQL Workbench: ModelingNo Feedback
(5077 days)		S35.2.19 OSSbetaWindowsAnyError1005, err150
824542016-08-04
10:51		2017-01-13
7:44		MySQL Server: InstallingDuplicate
(2653 days)		S25.6Ubuntu (Xenial)AnyBug in Mysql 5.6 Installation in Xenial
882422017-10-27
1:16		2017-11-22
23:39		Connector / JClosed
(2340 days)		S15.1.41, 5.1.44AnyAnyautoReconnect and socketTimeout JDBC option makes wrong order of client packet
8562003-07-16
12:05		2004-03-13
9:52		MySQL ServerClosed
(7342 days)		S34.1.1a/5.0Linux (Linux Mandrake/Win XP/Suse 9.0)AnyNaming a key "Primary" causes trouble
81602005-01-27
12:38		2005-03-08
16:52		MySQL ServerNo Feedback
(6982 days)		S24.0.22Linux (Linux)AnyServer
126332005-08-18
2:44		2006-06-13
17:10		MySQL Server: MyISAM storage engineClosed
(6520 days)		S24.1.13, 4.1.14-ntLinux (linux, windows)Anymyisampack and then unpack destroys auto_increment key
201602006-05-31
0:32		2006-05-31
20:06		MySQL Workbench PreviewWon't fix
(6533 days)		S31.06Windows (win32)Anyduplicate foreign key names
247182006-11-30
10:08		2006-12-18
21:02		MySQL ServerCan't repeat
(6332 days)		S25-0-27Windows (Windows XP)Anydrop database really dropping database
252622006-12-24
2:08		2007-05-04
18:02		MySQL Server: GeneralClosed
(6195 days)		S35.0.34-BK, 4.1.14Linux (Linux Red Hat)AnyAuto Increment lost when changing Engine type
371822008-06-04
5:50		2018-07-01
18:08		MySQL Server: Archive storage engineVerified
(5798 days)		S35.1.24, 5.1.30Any (RH Linux 64, WinXP)AnyDumped Archive table with AUTO_INCRMENET PRIMARY KEY won't restore from dump
453072009-06-03
14:56		2018-09-23
20:45		MySQL Server: InnoDB storage engineDuplicate
(5308 days)		S35.0.82LinuxAnychanging foreign key's field case results in Duplicate key name error on restore
948162019-03-28
14:25		2019-04-23
13:33		MySQL Server: DDLVerified
(1831 days)		S25.7.25Any (Windows and GCP CloudSQL)AnyAlter table results in foreign key error that appears to drop referenced table
41282004-06-14
16:53		2005-04-25
19:15		MySQL ServerClosed
(6934 days)		S44.1.2 alphaMacOS (Mac OS X 10.3.4)AnyPlease allow more than one DEFAULT or ON UPDATE of CURRENT_TIMESTAMP in a table
  Showing 1-1000 of 12997 (Edit, Save, CSV, Feed) Show Next 1000 Entries »