Showing 1-1000 of 11841 (Edit, Save, CSV, Feed) Show Next 1000 Entries »
The following words were ignored: ON
ID# Date Updated Type Status Sev Version Target OS CPU Summary Assigned
118392005-07-09
22:32
2005-07-10
1:56
MySQL Server: InstallingNot a Bug
(5316 days)
S4nonenoneAnykemal  
118402005-07-09
22:47
2005-07-10
1:53
MySQL Server: InstallingNot a Bug
(5316 days)
S4 Anyinstall  
206862006-06-25
15:20
2012-05-18
20:19
MySQL ServerDuplicate
(4804 days)
S24.1.20 and 5.0.22Linux (Linux)Anywrong date vs values(date) compare in on duplicate key Assigned Account
251292006-12-18
4:12
2009-03-24
12:25
MySQL Server: InstallingCan't repeat
(3963 days)
S25.1.14AnyAny5.1.14 mysql_fix_privilege_tables does not update privilege tables from 5.0.22 Daniel Fischer
113722005-06-16
9:19
2006-07-25
0:17
MySQL Server: InstallingClosed
(4936 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
(973 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
(5859 days)
S35.0.0Microsoft Windows (winxp)AnyCrash MySQL  
264272007-02-15
21:20
2007-09-18
14:01
MySQL Server: Falcon storage engineCan't repeat
(4516 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
(4418 days)
S35.1.22-rc5.1+AnyAnylast_insert_id(), wrong values, InnoDB, insert on duplicate key update Evgeny Potemkin
839212016-11-22
20:33
2017-01-04
7:22
MySQL Server: ParserVerified
(1120 days)
S35.7.16CentOS (7)Anyfalsely Ambigous Column in On Duplicate Key Update using a subselect  
284782007-05-16
17:05
2007-06-20
0:51
MySQL Server: MyISAM storage engineClosed
(4606 days)
S25.0.42, *AnyAnyImproper key_cache_block_size corrupts MyISAM tables Ingo Strüwing
524192010-03-28
18:54
2011-02-16
23:44
MySQL Server: GeneralClosed
(3405 days)
S25.5.3-m3Linux (x86 icc)Anyx86 assembly based atomic CAS causes test failures Davi Arnaut
661042012-07-30
20:48
2012-09-07
6:31
MySQL Cluster: Cluster (NDB) storage engineClosed
(2700 days)
S27.2.77.2.8Linux (Debian 6)AnyMySQL-Cluster Online backup error Ole John Aske
90922005-03-10
13:00
2005-07-26
4:40
MySQL Server: InstallingCan't repeat
(5300 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
(2473 days)
S25.1, 5.5AnyAnyINSERT ... ON DUPLICATE KEY UPDATE + innodb_autoinc_lock_mode=1 is broken  
298512007-07-17
18:05
2016-02-25
12:24
MySQL Cluster: Cluster (NDB) storage engineClosed
(4361 days)
S25.0.44LinuxAnyTRUNCATE causes error 4350 from cluster in INSERT... ON DUPLICATE KEY UPDATE Guangbao Ni
458022009-06-27
17:19
2009-07-24
9:11
MySQL Query BrowserClosed
(3841 days)
S11.2.17Microsoft Windows (Vista)AnyDuplicate & Garbage indexes added to tables Sveta Smirnova
276502007-04-04
13:24
2007-05-01
17:45
MySQL ServerClosed
(4656 days)
S15.0.38, 5.xAnyAnyON DUPLICATE KEY UPDATE fails when setting UNIQUE values with multi row inserts Gleb Shchepa
769312015-05-04
13:37
2015-05-21
22:38
MySQL Cluster: Cluster (NDB) storage engineClosed
(1722 days)
S37.5.0AnyAnyRandom warning order ndb_one_fragment  
141312005-10-19
6:06
2012-05-18
20:19
MySQL Server: CharsetsVerified
(4129 days)
S45.0, 5.1, 6.0Linux (any)AnyReport PAD attribute in SHOW COLLATION and INFORMATION_SCHEMA.COLLATIONS Assigned Account
380182008-07-10
14:43
2008-07-11
15:52
MySQL Server: Maria storage engineClosed
(4219 days)
S35.1-mariaLinuxAnyMaria: INSERT SELECT ON DUPLICATE KEY UPDATE, LOAD DATA REPLACE wrong lock Guilhem Bichot
287812007-05-30
17:24
2016-02-25
12:24
MySQL Server: DocumentationClosed
(3512 days)
S25.0.425.0+AnyAnyInnoDB increments auto-increment value incorrectly with ON DUPLICATE KEY UPDATE Paul Dubois
704602013-09-28
15:17
2016-12-30
9:20
MySQL Cluster: Cluster (NDB) storage engineVerified
(2314 days)
S25.6.11-ndb-7.3.2-cluster-gpl-logLinux (CentOS release 6.4 (Final))AnyMysql Cluster and constraints  
135872005-09-28
21:40
2005-10-20
6:59
MySQL Server: Stored RoutinesClosed
(5214 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 Konstantin Osipov
984202020-01-28
19:50
2020-01-29
5:01
MySQL WorkbenchAnalyzingS28.0.19Microsoft Windows (Microsoft Windows 10 Pro)x86Will not start due to System.IO.FileNotFoundException Ashwini Patil
691532013-05-06
10:40
2013-06-28
9:25
MySQL Workbench: ModelingClosed
(2406 days)
S25.2.47Mac OS X (10.8.3)AnySynchronize database for column name change drops all foreign key constraints  
938062019-01-03
17:41
2019-02-20
15:19
MySQL Server: DocumentationClosed
(343 days)
S3allAnyAnyDocument error about "ON DUPLICATE KEY UPDATE "  
731902014-07-03
21:23
2017-04-17
13:36
MySQL Server: mysqldump Command-line ClientVerified
(1657 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
(4006 days)
S76.0-rpl6.0AnyAnyrpl.rpl_known_bugs_detection failed in pushbuild Serge Kozlov
178012006-02-28
18:26
2006-03-13
12:51
MySQL Cluster: Cluster (NDB) storage engineClosed
(5070 days)
S15.1.8Linux (Linux 32 Bit OS)AnyINSERT ON DUPLICATE KEY UPDATE using NDB table cause core Martin Skold
963282019-07-25
10:37
2019-07-25
13:04
MySQL ServerNot a Bug
(188 days)
S3allAnyAny INSERT ... ON DUPLICATE KEY UPDATE  
734832014-08-06
10:18
2014-08-14
18:44
MySQL ServerNot a Bug
(1994 days)
S35.6.19Linux (debian6.0)Anyinnodb_autoinc_lock_mode, row based replication, duplicate primary key assigned  
782702015-08-29
22:50
2016-01-13
20:44
MySQL Server: InnoDB storage engineClosed
(1477 days)
S3MySQL 5.6.26.Any (CentOS release 6.6)AnyUnexpected Memory Consumption for Bulk Index Creation in InnoDB.  
293292007-06-25
3:37
2015-03-15
20:45
MySQL Server: Stored RoutinesNo Feedback
(4430 days)
S35.0.38Linux (Gentoo)AnyExplicit commit complaints Assigned Account
524302010-03-29
11:01
2011-02-16
23:44
MySQL Server: Data TypesClosed
(3493 days)
S35.5.3-m35.5+AnyAnyIncorrect key in the error message for duplicate key error involving BINARY type Sergei Glukhov
289042007-06-05
19:04
2011-03-16
16:36
MySQL Server: OptimizerClosed
(4603 days)
S25.0.41Linux (SuSE 10.1)AnyON UPDATE CURRENT_TIMESTAMP does not work properly with ON DUPLICATE KEY Evgeny Potemkin
236472006-10-25
20:53
2006-11-02
21:44
MySQL Server: Falcon storage engineClosed
(4836 days)
S3Linux (Linux 64-bit)AnyFalcon crashes on update no-key test, 64 threads  
277442007-04-11
1:41
2007-04-12
11:58
MySQL ServerCan't repeat
(4675 days)
S25.0.37-logLinuxAnycommand "insert .. on duplicate key update" does not update and/or AFR is wrong  
279552007-04-19
14:33
2015-03-15
20:45
MySQL Server: MyISAM storage engineNo Feedback
(4638 days)
S25.0.37Linux (FC5)Anyerror of unknown column 'xxx' in field list but column 'xxx' isnt in the query Assigned Account
695132013-06-19
14:22
2013-08-19
1:00
MySQL Server: InnoDB storage engineNo Feedback
(2355 days)
S35.6Microsoft Windows (Windows 7 Ultimate 64-bit)AnyInnoDB: Assertion failure in thread 5616 in file ut0lst.h line 271  
270062007-03-09
16:19
2007-03-20
16:34
MySQL Server: Stored RoutinesClosed
(4698 days)
S15.0.36Any (All)AnyAFTER UPDATE triggers not fired with INSERT ... ON DUPLICATE KEY UPDATE Evgeny Potemkin
273072007-03-20
21:24
2007-03-20
21:31
MySQL Server: GeneralDuplicate
(4698 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
(3996 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
(435 days)
S35.7.22-22-logLinuxAnyDuplicate Records despite index  
285052007-05-18
0:19
2007-06-19
0:56
MySQL ServerClosed
(4607 days)
S23.1.10, and 5.0.6AnyAnyUpdate count for an INSERT DUPLICATE KEY not correct when CLIENT_FOUND_ROWS set Evgeny Potemkin
115192005-06-23
5:17
2005-07-01
12:59
MySQL ServerClosed
(5325 days)
S25.0.8manyAnytype_timestamp fails on many platforms Kent Boortz
891472018-01-08
22:18
2018-01-11
9:52
MySQL Server: Group ReplicationVerified
(748 days)
S45.7.20,8.0.3AnyAnyThe field end_log_pos in Group Replication error messages is ambiguous.  
832392016-10-02
4:16
2016-10-06
21:28
MySQL Server: OptimizerNot a Bug
(1210 days)
S35.7.15-0ubuntu0.16.04.1Ubuntu (16.04)AnyInconsistent nonaggregated field in SELECT not in GROUP BY  
518382010-03-08
17:29
2011-02-16
23:44
MySQL Server: InnoDB storage engineWon't fix
(3603 days)
S25.0.84AnyAnyInnodb gets X lock for INSERT ON DUPLICATE KEY UPDATE but not INSERT SELECT  
133852005-09-21
17:17
2005-09-21
17:55
MySQL ServerClosed
(5243 days)
S24.1.13Microsoft Windows (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
(3306 days)
S35.1.44,5.5.99-m3,6.0.14-alpha5.1+AnyAnyassert in handler::update_auto_increment Jon Olav Hauglid
796342015-12-14
13:04
2016-01-18
10:02
MySQL ServerNot a Bug
(1472 days)
S25.6.25-logDebian (7.8)Anytransaction written to the binary log were not actually applied to the DB Bogdan Kecman
354572008-03-20
12:06
2008-04-26
20:58
MySQL WorkbenchNo Feedback
(4295 days)
S35.0.15Microsoft WindowsAnyDROP TABLE comes after CREATE TABLE IF NOT EXISTS  
133922005-09-21
22:47
2005-10-31
20:13
MySQL Server: OptimizerClosed
(5203 days)
S25.0.12-beta-nt-logAny (All)Anyvalues() fails with 'ambiguous' or returns NULL with ON DUPLICATE and SELECT Evgeny Potemkin
732522014-07-10
7:18
2014-08-22
1:00
MySQL Server: InnoDB storage engineNo Feedback
(1987 days)
S35.6.13AnyAnyDuplicate foreign keys break insertions to a table  
415322008-12-17
9:06
2011-02-16
23:43
Connector / JClosed
(3954 days)
S55.1.7AnyAnySlower performance since 5.1.7 with rewriteBatchedStatements option Mark Matthews
53202004-08-31
16:38
2004-08-31
21:40
MySQL Cluster: Cluster (NDB) storage engineDuplicate
(5629 days)
S34.1.4-gamma (ndb)Linux (SuSE 9.1)AnyCluster: different error message returned than under MyISAM/InnoDB  
542492010-06-05
2:32
2017-05-21
20:45
MySQL Server: Row Based Replication ( RBR )Verified
(3524 days)
S35.1AnyAnyMore verbose RBR error logging Assigned Account
610672011-05-05
9:55
2011-09-23
23:00
MySQL Server: DMLNo Feedback
(3051 days)
S25.5.11Microsoft Windows (Vista)AnyForeign key creation order is essential  
898022018-02-26
11:21
2018-02-27
12:04
MySQL Server: DDLNot a Bug
(701 days)
S35.6.35-81.0AnyAnyMySQL Table key/index position order - No possibility to change Bogdan Kecman
115992005-06-28
0:07
2005-06-28
11:09
MySQL Server: MyISAM storage engineNot a Bug
(5328 days)
S24.1.11aLinux (Linux)AnyI get a Duplicate entry error message even when the key doesn't exist yet  
40082004-06-04
15:12
2004-06-25
15:14
MySQL ServerClosed
(5696 days)
S34.1, 5.0Linux (Linux)Anyinsert on duplicate fails depending on MERGE table INSERT_METHOD Sergei Golubchik
271232007-03-14
9:49
2007-05-09
6:05
MySQL Server: PartitionsClosed
(4648 days)
S25.1.17BKLinux (suse 9.3 x86)Anypartition + on duplicate key update + varchar = Can't find record in table Alexey Botchkov
611332011-05-11
13:29
2012-12-20
20:55
MySQL Server: ReplicationCan't repeat
(2596 days)
S25.5.10Linux (SuSE Linux Enterprise 11.1)AnyMaster -> Slave : duplicate key error after running fine for days  
620882011-08-04
22:53
2011-08-05
14:50
MySQL Workbench: ModelingNot a Bug
(3099 days)
S35.2.31aMicrosoft WindowsAnyForward engineer ALTER script generates different SQL than CREATE  
747332014-11-07
13:02
2014-11-07
16:14
MySQL Server: Security: PrivilegesVerified
(1909 days)
S35.5, 5.6, 5.7AnyAnySELECT privilege is not checked for views on UPDATE which references to columns  
775722015-07-01
2:33
2018-10-29
21:17
MySQL Server: DDLClosed
(1595 days)
S35.6.16 5.7.7AnyAnyThe bogus duplicate key error in online ddl with incorrect key name  
830852016-09-21
18:15
2016-10-22
1:00
MySQL Server: InnoDB storage engineNo Feedback
(1195 days)
S1MYSQL 5.5.49Debian (x86_64)AnyInsert after Left join generates duplicated rows in result  
453742009-06-08
13:24
2011-02-16
23:44
MySQL Server: DocumentationClosed
(3869 days)
S4AnyAnyDocumentation: need to document that certain WHERE clauses require Select_priv Paul Dubois
380412008-07-11
9:46
2008-09-30
20:31
MySQL Server: Falcon storage engineClosed
(4138 days)
S16.0-falcon6.0.7AnyAnyBizarre errors when ALTER ADD/DROP KEY on Falcon tables Christopher Powers
231332006-10-10
11:27
2006-10-26
18:06
MySQL Server: DocumentationClosed
(4843 days)
S35.0.26-standard-logLinux (Linux radium.net45.com 2.6.9-34.)AnyLOAD INDEX INTO CACHE fails Paul Dubois
194782006-05-02
13:04
2008-01-29
10:02
MySQL ServerCan't repeat
(4383 days)
S35.0.20Microsoft Windows (Windows 2003)AnySQL 'UPDATE' stops working Miguel Solorzano
324372007-11-16
14:41
2007-11-22
8:36
MySQL Server: ReplicationNot a Bug
(4451 days)
S25.0.45Linux (CentOS)AnyINSERT ... ON DUPLICATE KEY UPDATE replication 5.0.27 master & 5.0.45 slave  
374112008-06-14
19:21
2017-05-14
20:45
MySQL Server: InnoDB storage engineNo Feedback
(4088 days)
S25.0.51aSolarisAnyThreads staying in the "Sending Data" for long periods of time Assigned Account
390332008-08-26
6:10
2012-05-18
20:19
MySQL Cluster: Cluster (NDB) storage engineDuplicate
(4171 days)
S25.1.24-ndb-6.3.16LinuxAnyTable disappear Assigned Account
687722013-03-26
2:58
2013-05-02
1:00
MySQL Server: MyISAM storage engineNo Feedback
(2464 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
(719 days)
S36.3, 6.3.9Microsoft Windows (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
(14 days)
S35.7.23CentOS (CentOS Linux release 7.4.1708 (Core) )Anyalloc too much memory by a small table  
673672012-10-24
19:26
2013-03-26
1:00
MySQL Workbench: ModelingNo Feedback
(2501 days)
S25.2.44Mac OS X (Darwin 12.2.0)AnySynchronization requests to remove existing tables.  
9842003-08-03
12:15
2003-08-12
13:46
MySQL Server: InnoDB storage engineClosed
(6014 days)
S13.23.48Linux (Linux)Anymysqld crashes when creating an innodb table with foreign key  
686092013-03-08
0:28
2014-10-09
16:07
MySQL Server: ReplicationWon't fix
(1938 days)
S35.5.30, 5.6.10AnyAnyMBR: Unique key updates are not marked unsafe, replication fails  
192432006-04-21
4:45
2006-09-13
17:45
MySQL Server: OptimizerClosed
(4886 days)
S35.0.21-BK, 4.1.7Linux (Linux, Windows)Anywrong LAST_INSERT_ID() after ON DUPLICATE KEY UPDATE Guilhem Bichot
105382005-05-11
10:52
2005-06-29
7:45
MySQL ServerDuplicate
(5327 days)
S15.0.6bkLinux (Linux)AnyTriggers not locking tables Dmitry Lenev
577682010-10-27
11:58
2010-10-29
5:00
MySQL Server: InnoDB storage engineNot a Bug
(3379 days)
S25.1.41Microsoft Windows (Win 7)AnyFOREIGN KEY ON UPDATE CASCADE does not work with self-reference  
539132010-05-22
15:12
2011-02-16
23:44
MySQL Server: GeneralClosed
(3539 days)
S25.1.45-1Linux (Debian/squeeze)AnyUnknown column error for existing column  
246972006-11-29
15:13
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3315 days)
S35.0.24a-community-nt-log/4.1BK/5.0BK/5.1BKMicrosoft Windows (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
(2035 days)
S35.6.15AnyAnyWrong behaviour for auto_increment unsigned bigint column approaching max value  
333952007-12-20
9:24
2008-04-17
9:31
MySQL Server: MyISAM storage engineNo Feedback
(4304 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
(4100 days)
S16.0.6-alpha, 6.0.7pre,6.0.7,6.0.8preAnyAnymaria: DELETE causes crash or index corruption Michael Widenius
769272015-05-04
12:09
2016-06-18
21:26
MySQL Server: InnoDB storage engineClosed
(1626 days)
S25.1, 5.5, 5.6, 5.7, 8.0AnyAnyDuplicate UK values in READ-COMMITTED (again) Kevin Lewis
799372016-01-12
15:42
2016-01-13
12:15
MySQL Server: DMLNot a Bug
(1477 days)
S35.6.27AnyAnyIncorrect record updated using ON DUPLICATE KEY UPDATE processing  
109362005-05-28
1:25
2005-08-27
7:44
MySQL Cluster: Cluster (NDB) storage engineClosed
(5268 days)
S35.1.0Linux (Linux)AnyCluster engine shows wrong key value for duplicate key error. Martin Skold
276042007-04-03
1:29
2015-03-15
20:45
MySQL Server: GeneralNo Feedback
(4615 days)
S114.12 Distrib 5.0.37, for pc-linux-gnu (Linux (Redhat 9 (Shrike))AnyUpdate query with Join crashes mysqld Assigned Account
491732009-11-28
3:26
2011-02-16
23:44
MySQL Server: ErrorsClosed
(3714 days)
S25.1.30-communityMicrosoft Windows (xp media center sp3)Anycreate view fails: MySQL error 1060 "duplicate column name"  
312392007-09-27
13:29
2008-02-25
17:17
MySQL Cluster: Cluster (NDB) storage engineClosed
(4356 days)
S25.1.22-rc, 5.0.505.1Other (ICC / IA64)AnyTest "ndb_views" returns NDB error 4259 "Invalid set of range scan bounds" Magnus Blåudd
719232014-03-04
12:23
2014-07-17
17:29
Connector / JClosed
(2022 days)
S35.1.29AnyAnyIncorrect generated keys if ON DUPLICATE KEY UPDATE not exact Filipe Silva
368022008-05-19
15:42
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4139 days)
S35.0, 5.1, 6.0 BK5.6+AnyAnyMySQL only use covered index when selecting from a view (or subquery) with union Evgeny Potemkin
675262012-11-08
18:51
2019-05-07
21:37
MySQL Server: InnoDB storage engineClosed
(267 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  
132862005-09-16
22:01
2005-10-26
22:12
MySQL Migration ToolkitCan't repeat
(5208 days)
S1Release 5.0.XMicrosoft Windows (Windows, Linux)AnyTables in SQL Server having composite foreign keys not migrated  
216532006-08-15
12:06
2006-08-26
10:00
MySQL ServerDuplicate
(4904 days)
S25.0.19Linux (SuSE 10.0)AnyMysql appears to hang at bin log file rotation (not every rotation)  
262762007-02-12
6:07
2015-03-15
20:45
MySQL Server: ErrorsNo Feedback
(4706 days)
S25.0.26Linux (linux)AnyDuplicate entry Assigned Account
79752005-01-17
22:56
2005-04-18
10:22
MySQL Server: InnoDB storage engineClosed
(5399 days)
S34.1.9, official 686 binaryLinux (debian amd64 pure64)Anydeadlock without any locking, simple select and update Jan Lindström
246012006-11-26
17:04
2016-01-03
20:45
MySQL Server: InnoDB storage engineNo Feedback
(4781 days)
S25.0.26Mac OS X (Mac OS X 10.4.8)AnyMySQLd crashes upon creation of an index Assigned Account
479552009-10-09
18:59
2016-02-25
12:24
MySQL Cluster: Cluster (NDB) storage engineClosed
(3731 days)
S2mysql-5.1-telco-6.3AnyAnyUPDATEs using indexes that modify no rows return incorrect found rows Martin Skold
375602008-06-20
22:56
2008-07-31
18:01
MySQL Server: GeneralClosed
(4199 days)
S35.0.45-community-logLinuxAnyAutoincrement should not increment on duplicate key condition  
383912008-07-26
13:57
2008-07-27
16:19
MySQL WorkbenchDuplicate
(4203 days)
S35.0.23 SEMicrosoft WindowsAnySynchronize after Forward enginieer creates ALTER statements every time  
684462013-02-20
23:36
2013-02-22
14:56
MySQL Server: DMLClosed
(2532 days)
S35.5.29AnyAnyinsert on duplicate key update with null autoincremented PK uses wrong pk value  
782622015-08-28
15:19
2015-12-07
18:51
MySQL Server: InnoDB storage engineClosed
(1514 days)
S55.6.26Any (CentOS release 6.6)AnyAdding indexes on empty table is slow with large innodb_sort_buffer_size.  
177442006-02-27
16:52
2006-03-24
13:56
MySQL Server: PartitionsClosed
(5059 days)
S15.1 AnyPartitions: InnoDB, Trigger, rotten table leads to wrong result sets Mikael Ronström
679142012-12-16
10:36
2013-01-19
1:00
MySQL ServerNo Feedback
(2567 days)
S25.5.20Linux (ubuntu)AnyTimestamp auto update column not updated on each update statement  
25562004-01-29
8:21
2004-03-06
12:31
MySQL Server: ReplicationNo Feedback
(5807 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
(5089 days)
S15.1.7 src Anyduplicate key error interchangeble refers to attribute name name and number Elliot Murphy
578682010-10-31
7:07
2011-02-16
23:44
MySQL Server: ErrorsUnsupported
(3376 days)
S24.0.27Linux (suse with kernel 2.6.16.60-0.21)Anyreplication,record error in log but the slave not stop.  
449042009-05-15
14:19
2018-02-10
17:27
MySQL Server: DMLCan't repeat
(718 days)
S35.0, 5.1Microsoft Windows (XP SP3)AnyLIMIT IN INSERT ... DUPLICATE KEY UPDATE DIFFER IN THE SMPLE LIMIT  
394322008-09-13
12:50
2011-02-16
23:43
MySQL Server: DocumentationClosed
(3896 days)
S3ndb-6.2+Any (debian)Anyslave stops if master does insert ... on duplicate key update Jon Stephens
656782012-06-19
21:56
2012-06-30
10:09
Connector / PythonClosed
(2769 days)
S30.3.2-devAnyAnyOn duplicate key UPDATE VALUE fails regex Geert Vanderkelen
166302006-01-19
12:47
2007-03-06
19:42
MySQL Server: OptimizerClosed
(4712 days)
S24.1 Anyerror, when INSERT t1 SELECT ... FROM t1 ON DUPLICATE Evgeny Potemkin
805052016-02-25
9:43
2016-02-25
14:53
MySQL Server: OptimizerDuplicate
(1434 days)
S55.7.11Microsoft WindowsAnymysql server 5.7.11 view performance issue  
321392007-11-06
9:11
2007-12-12
9:39
MySQL ServerNo Feedback
(4431 days)
S25.0.45Linux (ubuntu 7.10)AnyComputing crc32(group_concat(...)) on a very loaded table doesn't give result ok  
586372010-12-01
19:44
2014-06-25
14:34
MySQL Server: ReplicationClosed
(2840 days)
S25.1+, 5.0, 5.6.1AnyAnyMark INSERT...ON DUPLICATE KEY UPDATE unsafe when there is more than one key Sven Sandberg
188082006-04-05
14:25
2013-10-06
20:45
MySQL Cluster: Cluster (NDB) storage engineDuplicate
(5031 days)
S35.1.9Linux (Linux 32 Bit OS)Any"Rowid already allocated" Error duing update and not during node recovery Assigned Account
541822010-06-02
13:33
2016-09-08
5:54
MySQL Cluster: ReplicationCan't repeat
(1238 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
(3508 days)
S35.1, 4.1, 5.0, 5.6.99AnyAnyDocs for REPLACE are not accurate  
658892012-07-13
0:21
2012-07-16
10:18
MySQL Server: InnoDB storage engineVerified
(2756 days)
S3<=5.5AnyAnyAppended primary key stored inefficiently in unique surrogate keys  
873522017-08-09
8:17
2017-08-09
9:37
MySQL Cluster: Cluster (NDB) storage engineVerified
(903 days)
S37.5.7AnyAny"ndb_restore --print-sql-log" includes unnecessary SQL  
612132011-05-18
9:49
2014-06-10
7:08
Connector / JClosed
(2078 days)
S25.1.16AnyAnyON DUPLICATE KEY UPDATE breaks generated key list when extended INSERT is used Alexander Soklakov
423092009-01-23
18:17
2011-02-16
23:43
Connector / JClosed
(4018 days)
S35.15.1AnyAnyStatement.getGeneratedKeys() returns 2 keys when using ON DUPLICATE KEY UPDATE Jess Balint
873002017-08-03
10:18
2017-11-09
11:24
Shell General / Core ClientClosed
(811 days)
S2mysqlsh Ver 1.0.10 for Linux on x86_64AnyAnymysql-shell dba.checkInstanceConfiguration()  
429942009-02-18
21:47
2011-02-16
23:43
MySQL Server: InnoDB storage engineDuplicate
(3996 days)
S25.1.30, 5.1.315.1+AnyAnyREPLACE INTO results in a DUPLICATE KEY error on the AUTO_INCREMENT primary key Sunny Bains
580862010-11-09
15:09
2011-11-30
18:40
MySQL Server: DocumentationClosed
(2982 days)
S35.1AnyAnyauto_inc in InnoDB have INSERT ... ON DUPLICATE KEY UPDATE != UPDATE John Russell
970272019-09-26
10:02
2019-10-08
17:55
MySQL Server: Row Based Replication ( RBR )Can't repeat
(113 days)
S25.7.*Anyx86Bulk insert with ON DUPLICATE KEY UPDATE breaks replicaiton Bogdan Kecman
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  
220062006-09-05
0:09
2006-09-05
0:20
MySQL ServerNot a Bug
(4894 days)
S25.0.24Microsoft Windows (MS Server 2003)AnySimple math using floats yielding bad precision results.  
438422009-03-24
20:19
2013-01-14
9:25
MySQL Server: Federated storage engineWon't fix
(2571 days)
S45.0AnyAnySupport for ON DUPLICATE KEY UPDATE with FEDERATED  
538712010-05-21
2:57
2011-02-16
23:44
MySQL Server: DocumentationClosed
(3540 days)
S35.1AnyAnyX lock is taken by innodb on duplicate key error, insert on duplicate key update Paul Dubois
384342008-07-29
19:15
2012-05-18
20:19
MySQL Server: DDLVerified
(4193 days)
S1 5.0.51b-community-nt MySQL Community Ed, 5.0, 5.1 BZRAny (Linux, MS Windows xp)Anyunique key index length Assigned Account
510552010-02-10
10:43
2011-02-16
23:44
MySQL Server: ReplicationClosed
(3509 days)
S3mysql-5.15.1+AnyAnyReplication failure on duplicate key + traditional SQL mode Luis Soares
17962003-11-10
11:40
2003-12-19
6:46
MySQL ServerClosed
(5885 days)
S14.0.16 Any"IN" Problem Konstantin Osipov
439322009-03-28
18:04
2011-02-16
23:43
MySQL Server: MyISAM storage engineClosed
(3911 days)
S15.1.325.1.35Microsoft Windows (64-bit)Anymyisam index corruption with large index and large key_buffer_size Vladislav Vaintroub
956782019-06-06
21:22
2019-07-08
12:38
MySQL Server: OptimizerCan't repeat
(205 days)
S25.6.33Ubuntux86query gives empty result when using index_merge  
135712005-09-28
14:22
2006-04-14
14:45
MySQL Server: CompilingClosed
(5038 days)
S35.0.13-rc, 5.0.14-rcIBM AIX (AIX 5.2)AnyCompiling problems on AIX Kent Boortz
32762004-03-23
16:58
2004-03-26
2:33
MySQL Server: MyISAM storage engineCan't repeat
(5787 days)
S14.0.16Linux (Redhat ES 3)AnyDeadlock with MyISAM  
276722007-04-05
16:35
2007-07-29
6:36
MySQL Server: GeneralNo Feedback
(4567 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
(4626 days)
S25.0.37-community-ntMicrosoft Windows (XP SP2)AnyON DUPLICATE KEY UPDATE doesn't run triggers  
449762009-05-20
9:09
2011-02-16
23:43
MySQL Server: ReplicationDuplicate
(3435 days)
S25.0.77AnyAnyIncorrect INSERT_ID in binary log  
665402012-08-25
20:04
2013-01-23
1:00
MySQL Server: DMLNo Feedback
(2563 days)
S4AnyAnyRedundant coding in ON DUPLICATE KEY UPDATE  
893852018-01-24
15:14
2018-01-24
15:14
MySQL ServerOpenS4AnyAnyINSERT IGNORE DUPLICATE KEY  
330252007-12-05
21:54
2007-12-07
18:08
MySQL Server: ReplicationDuplicate
(4436 days)
S25.0.45LinuxAnyReplication breaks on "on duplicate key update": ids on master & slave differ  
393522008-09-09
22:07
2011-05-12
6:42
Connector / JClosed
(4128 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
(3098 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
(2442 days)
S37.1.x, 7.2.5LinuxAny"Transaction already aborted" hides real error msg on INSERT ... ON DUP UPDATE  
240792006-11-08
9:39
2006-12-07
22:31
MySQL Server: Falcon storage engineClosed
(4801 days)
S15.2AnyAnystrange errors around INSERT getting duplicate key, but one row is inserted  
43122004-06-28
17:59
2004-11-18
17:25
MySQL Cluster: Cluster (NDB) storage engineClosed
(5550 days)
S24.1Linux (Linux)Anyndb table, wrong behaviour on insert .. on duplicate key .. Martin Skold
108842005-05-26
14:10
2005-05-26
14:47
MySQL ServerDuplicate
(5361 days)
S25.0.4-ntMicrosoft Windows (Windows XP sp2)AnyInsert ... on duplicate key update does not recognize table alias  
260692007-02-05
5:24
2012-05-18
20:19
MySQL Server: Falcon storage engineNo Feedback
(4644 days)
S25.2.2 (20070204 tree)Linux (ubuntu 6.06 x86_64)Anyduplicate entries for unique keys (incl primary)  
382392008-07-19
9:46
2008-07-31
1:40
MySQL WorkbenchNot a Bug
(4199 days)
S25.0.23 OSS Rev. 3198Microsoft Windows (Vista)AnyError importing 'Forward Engineer SQL CREATE Script' - With constraints  
309152007-09-08
14:33
2008-01-08
20:32
MySQL Server: DocumentationClosed
(4404 days)
S35.0.41FreeBSD (6.2)Anyon duplicate key update: needs update privileges for primary key Paul Dubois
210002006-07-12
12:49
2006-07-17
11:07
MySQL Query BrowserClosed
(4944 days)
S11.1.20Microsoft Windows (Windows XP)AnyStored proc crashes Query Browser & Admin  
342532008-02-02
20:20
2008-02-03
17:28
MySQL WorkbenchNot a Bug
(4378 days)
S35.012.OSS BetaMicrosoft Windows (XP )Anyimport sql workbech script generates errno 121  
182452006-03-15
2:23
2006-04-23
16:05
MySQL ServerNo Feedback
(5029 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
(3964 days)
S25.1.30LinuxAnyReplication breaks after 'INSERT ... ON DUPLICATE UPDATE ...'  
302562007-08-06
14:27
2007-08-06
15:15
MySQL ServerCan't repeat
(4559 days)
S25.0.45AnyAnyQuery cache not emptied after a INSERT ... ON DUPLICATE KEY UPDATE  
3902003-05-07
9:14
2003-05-13
11:10
MySQL ServerClosed
(6105 days)
S34.0.13Any (All)AnyDiscrepancy with ISO about primary key and NOT NULL (error 1171) Per-Erik Martin
96362005-04-05
6:45
2005-05-15
23:05
MySQL ServerCan't repeat
(5372 days)
S25.0.3 rpmLinux (Linux Fedore Core 2)AnyINSERT INTO table from a complex View Oleksandr Byelkin
867252017-06-16
6:59
2017-10-31
13:08
MySQL Server: DDLClosed
(820 days)
S35.7 5.7.17, 5.7.18AnyAnyBehavior is different. "ADD KEY" and "ADD UNIQUE KEY" for the TEXT columns  
392482008-09-04
15:06
2009-01-09
15:28
MySQL Server: Maria storage engineClosed
(4037 days)
S35.1-maria, 6.0-bk6.0-betaLinuxAnyMaria: INSERT ON DUPLICATE KEY UPDATE gives error if using a view Michael Widenius
565932010-09-06
12:20
2010-09-06
16:24
MySQL Server: ParserNot a Bug
(3432 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
(2023 days)
S55.1.29AnyAnyEvery SQL statement is checked if it contains "ON DUPLICATE KEY UPDATE" or not Filipe Silva
719162014-03-03
16:52
2016-10-26
13:43
MySQL Server: DocumentationClosed
(1190 days)
S35.6AnyAnyManual does NOT explain locks set for UPDATE ... WHERE PK='const' properly Daniel Price
214032006-08-01
19:21
2011-02-16
23:43
MySQL Server: ErrorsVerifiedS4allAny (all)Anymore specific SQL states for 23nnn  
129462005-09-02
8:55
2005-10-05
11:27
MySQL ServerNo Feedback
(5229 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
(5194 days)
S34.1.4Linux (Linux ibm171.iq2003.com 2.6.9-11)Anyreplication fail when reconnection Miguel Solorzano
330292007-12-06
0:59
2008-04-05
7:34
MySQL Server: ReplicationClosed
(4316 days)
S25.0.52 / 5.1.225.0+,5.1.24AnyAny5.0 to 5.1 replication fails on dup key when inserting using a trig in SP Zhenxing He
899382018-03-07
3:13
2018-07-11
9:47
MySQL Server: Group ReplicationClosed
(567 days)
S25.7.20,8.0.4AnyAnyRejoin old primary node may duplicate key when recovery  
877962017-09-19
5:11
2018-03-29
12:20
MySQL Server: ReplicationVerified
(853 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  
69782004-12-03
9:07
2004-12-03
11:36
MySQL ServerNot a Bug
(5535 days)
S34.1.8 & 5.0.3Linux (Linux 2.4.21-99 smp)AnyErrors on multi table update and delete Jan Lindström
108862005-05-26
14:59
2005-06-22
2:36
MySQL Server: OptimizerClosed
(5334 days)
S24.1.12Linux (Linux)AnyINSERT ... SELECT ... ON DUPLICATE KEY UPDATE produces bad results Evgeny Potemkin
343822008-02-07
14:55
2008-03-07
15:05
MySQL Server: GeneralNo Feedback
(4345 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
(4266 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
(4064 days)
S35.0.22LinuxAnyPerl affected row count incorrect for certain cases of ON DUPLICATE KEY UPDATE  
264642007-02-17
18:25
2007-03-15
2:54
MySQL Server: Merge storage engineClosed
(4703 days)
S24.1.21, 5.0.36BK, 5.1.16BK, 5.2.4BKAny (*)Anyinsert delayed + update + merge = corruption Ingo Strüwing
433112009-03-02
20:23
2011-02-16
23:43
MySQL Server: GeneralDuplicate
(3953 days)
S25.0.77AnyAnyWrong number of affected rows returned for insert on duplicate key  
549142010-06-30
13:08
2011-02-16
23:44
MySQL Server: InnoDB storage engineClosed
(3382 days)
S55.5.55.5+AnyAnyInnoDB: performance drop with innodb_change_buffering=all Marko Mäkelä
134292005-09-23
15:19
2005-10-06
12:06
MySQL Server: InnoDB storage engineNot a Bug
(5228 days)
S35.0, 5.0.12-ntLinux (Linux, Windows)AnyDuplicate FOREIGN KEYs are allowed Osku Salerma
27252004-02-11
23:55
2004-03-05
0:31
MySQL ServerCan't repeat
(5808 days)
S24.0.17Tru62AnyKEY desc_idx (description(100)) being treated as UNIQUE KEY on Tru64 Michael Widenius
444642009-04-24
18:05
2011-02-16
23:43
MySQL WorkbenchNo Feedback
(3880 days)
S15.0.30Microsoft WindowsAnyWorkbench SE Synch with collation difference fails  
122992005-08-01
15:39
2005-09-02
7:54
MySQL ServerNo Feedback
(5262 days)
S34.0.20Microsoft Windows (win2000)Anyshow create tables lost referense information accidentally  
110392005-06-02
15:07
2005-06-16
17:11
MySQL Server: InnoDB storage engineClosed
(5340 days)
S35.0Any (any)AnyInnoDB: Warning: using a partial-field key prefix in search. Michael Widenius
166352006-01-19
14:52
2007-08-03
1:44
MySQL Server: Embedded Library ( libmysqld )Closed
(4562 days)
S34.1.17Any (all Unix)AnyError messages wrong: absolute path names, "%s" format code Joerg Bruehe
324722007-11-17
17:17
2007-11-20
13:02
MySQL Server: ErrorsClosed
(4453 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
(2665 days)
S35.1.265.5.26AnyAnyExplain doesn't show key with order by in derived table. Evgeny Potemkin
805062016-02-25
10:41
2016-03-26
1:00
MySQL WorkbenchNo Feedback
(1405 days)
S16.3.6AnyAnyCould not alter table  
437952009-03-23
5:28
2009-03-23
6:15
MySQL Server: InnoDB storage engineNot a Bug
(3964 days)
S25.1.32-communityMicrosoft WindowsAnyAutoincrement increased by 2 on duplicate key condition  
926422018-10-02
19:08
2018-10-02
20:34
MySQL WorkbenchDuplicate
(484 days)
S28.0.12Mac OS X (macOS 10.13.x High Sierra x86_64)AnyResults Grid does now show  
319752007-10-31
7:36
2009-09-01
13:19
MySQL Server: Command-line ClientsNot a Bug
(3802 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
(3351 days)
S35.1.53AnyAnyRows get skipped as primary duplicates, when they are in fact not.  
288422007-06-01
17:33
2007-06-18
15:08
MySQL Server: ErrorsClosed
(4608 days)
S25.1-bkAnyAnyDifferent 'duplicate key' error code between 5.0 and 5.1 Jim Winstead
364112008-04-29
19:46
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(3512 days)
S35.1.24, 5.1.255.1+AnyAny"Failed to read auto-increment value from storage engine" in 5.1.24 auto-inc Sunny Bains
608082011-04-08
15:06
2011-04-08
16:35
MySQL Server: GeneralDuplicate
(3218 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
(740 days)
S45.7.20, 8.0.3AnyAnyPlease add GTID in applier error messages.  
122832005-07-30
7:45
2011-02-16
23:43
MySQL Server: DMLWon't fix
(3330 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
(5277 days)
S25.0.10Microsoft Windows (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
(4647 days)
S15.0.38AnyAnyINSERT ... ON DUPLICATE KEY UPDATE fails with large multi-insert Gleb Shchepa
467882009-08-18
14:58
2011-02-16
23:44
Connector / JClosed
(3787 days)
S25.1.8Linux (Fedora 10)AnyWhile using ON DUPLICATE KEY UPDATE on a batchRewriteStatements I get exception Mark Matthews
504132010-01-18
13:54
2018-11-30
13:16
MySQL Server: InnoDB storage engineClosed
(2269 days)
S15.0.91,5.1.50,5.6.0AnyAnyinsert on duplicate key update sometimes writes binlog position incorrectly Sunny Bains
611342011-05-11
14:32
2011-05-17
14:17
Connector / JDuplicate
(3179 days)
S25.1.16AnyAnybad row affected values with INSERT ON DUPLICATE KEY UPDATE  
85632005-02-17
6:30
2005-02-17
19:50
MySQL Server: ReplicationNot a Bug
(5459 days)
S24.1.9Linux (Linux (RHEL 3, x86))AnyReplication of InnoDB table fails with Error_code: 1062 intermittently  
131082005-09-10
21:43
2005-12-18
5:20
MySQL ServerClosed
(5155 days)
S25.0.12/BK source 5.0Mac OS X (Mac OSX 10.4.2, Darwin 8.2.0)AnyALTER TABLE does not work on FEDERATED tables Eric Herman
401472008-10-19
17:29
2008-11-21
7:12
MySQL Server: InnoDB storage engineNo Feedback
(4086 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
(48 days)
S38.0.18Microsoft Windows (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
(964 days)
S35.6/5.7Microsoft WindowsAnyoptimizer index using select where column in select  
451632009-05-28
15:10
2014-02-18
15:53
MySQL Server: DocumentationClosed
(2171 days)
S35.1.30, 5.0.70AnyAnyBehavior different then expected from manual - ALTER w/ FK Daniel Price
551572010-07-10
19:23
2011-02-16
23:44
MySQL Workbench: ModelingDuplicate
(3488 days)
S15.2.25Microsoft WindowsAnyAttempt to add existing foreing key  
752532014-12-18
9:06
2014-12-22
9:36
MySQL ServerNot a Bug
(1864 days)
S35.5.32-logLinux (CentOS)AnyON DUPLICATE KEY UPDATE not working when auto_increment reaches MAX_INT  
721622014-03-29
20:02
2014-04-29
20:07
MySQL Server: Stored RoutinesClosed
(2101 days)
S25.5.35-0ubuntu0.12.04.2 (Ubuntu)Linux (Linux 3.2.0-60-generic-pae i686)AnyInsert fail caused by trigger  
724762014-04-28
23:42
2014-09-16
1:00
MySQL WorkbenchNo Feedback
(1962 days)
S16.1Microsoft Windows (8.1 64-bit)AnyModifying in Workbench causes update trigger to modify all records instead of 1  
258532007-01-25
16:20
2007-06-20
1:01
MySQL Server: MyISAM storage engineClosed
(4606 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 Ingo Strüwing
480292009-10-13
19:30
2011-02-16
23:44
MySQL Server: InnoDB storage engineNo Feedback
(3729 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
(2543 days)
S25.5.30,5.6.10AnyAnyValue for mysql_affected_rows() became 1 for ON DUPLICATE KEY after 5.5.15 Matthew Lord
815782016-05-24
18:38
2016-05-24
18:51
MySQL Server: DMLDuplicate
(1345 days)
S35.5.49AnyAnyINSERT ON DUPLICATE KEY UPDATE statement returning 1062 instead of 1452  
204942006-06-16
6:02
2006-06-22
12:51
MySQL Server: DocumentationClosed
(4969 days)
S25.1Any (All)AnyPartitioning chapter contains dated info Jon Stephens
281902007-05-02
1:43
2012-05-18
20:19
MySQL ServerDuplicate
(4571 days)
S35.0.37,5.1BKLinux (Fedora Core release 4 (Stentz))AnyON DUPLICATE KEY UPDATE updates the record even if values are identical Evgeny Potemkin
903982018-04-12
4:16
2019-05-09
0:29
MySQL Server: OptimizerClosed
(265 days)
S25.7.17 EE, 5.7.22AnyAnyDuplicate entry for key '<group_key>' error  
392392008-09-04
11:56
2008-09-05
10:30
MySQL Server: GeneralClosed
(4163 days)
S25.1.26Linux (CentOS 5.2)AnyTemporary server hang  
739252014-09-16
9:34
2014-09-16
11:22
MySQL Server: InnoDB storage engineNot a Bug
(1961 days)
S25.5.27Microsoft Windows (7 64 bit)AnyINSERT INTO ... ON DUPLICATE KEY UPDATE not taking into account multiple column  
742182014-10-03
23:02
2019-10-29
15:02
MySQL Cluster: Cluster (NDB) storage engineClosed
(92 days)
S35.6.19-ndb-7.3.6AnyAnyMissing table name in error message 1022  
35872004-04-28
12:30
2004-05-02
18:14
MySQL ServerClosed
(5750 days)
S25.0.0alphaMicrosoft Windows (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
(5405 days)
S35.0.3Other (QNX)Any'Explain' shows different strategy Magnus Blåudd
185962006-03-28
23:38
2012-05-18
20:19
MySQL Cluster: Cluster (NDB) storage engineDuplicate
(5048 days)
S25.1.9Linux (Linux 32 Bit OS)Any binlog schema event auto push causes mysqld errors Assigned Account
186442006-03-30
10:00
2006-05-26
20:41
MySQL Server: DocumentationClosed
(4996 days)
S25.0.18Linux (SuSE linux 9.2 pro)AnyDocumentation Errors for Create Table syntax Paul Dubois
255962007-01-12
21:13
2007-02-20
20:30
MySQL Server: InnoDB storage engineClosed
(4726 days)
S25.0.32, 5.0.36-bkLinux (Linux, Windows, Mac OS X 10.4.8)AnyInnoDB Alter Table Failures Marko Mäkelä
324162007-11-15
17:15
2008-07-24
11:57
MySQL Server: InnoDB storage engineNot a Bug
(4206 days)
S15.0.27, 5.0.37, 5.1.22LinuxAnyForeign key constraint violation under concurrent load Vasil Dimov
368452008-05-21
8:05
2008-06-27
16:37
MySQL Server: PartitionsNo Feedback
(4233 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
(3198 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
(2312 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
(1800 days)
S12.0AnyAnyPython does not work with HASH sahrding in MySQL Fabric Peeyush Gupta
468642009-08-22
7:05
2011-02-16
23:44
MySQL Server: ReplicationClosed
(3787 days)
S35.1.38, 5.0, 5.1, next bzr5.0+AnyAnyIncorrect update of InnoDB table on slave when using trigger with myisam table Alfranio Correia
24382004-01-18
16:42
2004-02-02
9:34
MySQL ServerClosed
(5840 days)
S24.1.1Linux (Mandrake Linux 9.2/WindowsXP)AnyRunaway memory consumption Victor Vagin
80582005-01-20
23:03
2005-02-21
16:50
MySQL ServerCan't repeat
(5455 days)
S15.0.3 built todayLinux (Linux/x86)AnyCrashes and out of memory in SQL parsing of stored procs Per-Erik Martin
62052004-10-21
19:56
2004-10-21
21:29
MySQL Server: InnoDB storage engineNot a Bug
(5578 days)
S34.0.14Linux (linux RedHat 7.3)AnyUpdate killed MySQL server  
182762006-03-16
11:04
2006-03-23
16:16
MySQL ServerWon't fix
(5060 days)
S35.0.19IBM AIX (AIX 4.2.1)Anydoes not build (failure to link) on AIX  
336582008-01-03
16:46
2018-06-24
20:45
MySQL WorkbenchDuplicate
(4404 days)
S25.0.11 SE Beta Rev 2342Microsoft Windows (XP 32 bit)AnyWorkbench Generates Primary Keys That Are Unnecessary and Can't Be Edited  
62872004-10-27
14:41
2004-12-21
17:55
MySQL Server: ReplicationClosed
(5517 days)
S24.0.21-logLinux (Linux)AnySlave skips auto_increment values in Replication with InnoDB Heikki Tuuri
436742009-03-16
12:42
2009-03-16
12:54
MySQL Server: CharsetsNot a Bug
(3971 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
(2556 days)
S35.1.335.1+AnyAnyDuplicate erro output different for 5.1.33 from dev article Paul Dubois
704092013-09-24
15:35
2014-05-28
5:45
Connector / NETClosed
(2072 days)
S16.7.4Microsoft Windows (server 2008)AnyMySqlSessionStateStore : exception "Duplicate entry" Fernando Gonzalez.Sanchez
825442016-08-11
14:36
2016-08-17
14:57
MySQL Server: DocumentationClosed
(1260 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
(980 days)
S35.7.11AnyAnyMySQL 1062 –Duplicate entry for key without duplicate value Assigned Account
918232018-07-29
18:25
2018-10-28
22:02
MySQL Server: InnoDB storage engineClosed
(458 days)
S38.0.12Ubuntu (14.04)x86innodb.innodb test leads to crash on MySQL 8.0.12  
588642010-12-10
12:13
2011-07-19
15:09
MySQL Server: DocumentationClosed
(3116 days)
S45.1AnyAnyClarify LAST_INSERT_ID() behavior on update by INSERT ON DUPLICATE KEY UPDATE Paul Dubois
127072005-08-21
23:33
2011-02-16
23:43
MySQL Server: DDLVerified
(4011 days)
S44.0, 5.1Microsoft Windows (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
(3863 days)
S35,1.30, 5.1.33, 5.1.35, 5.1.36Microsoft Windows (XP)AnyCannot do SELECT FOR UPDATE with small amount of records.  
210852006-07-16
21:33
2006-07-27
6:14
MySQL Server: CharsetsNot a Bug
(4934 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 Alexander Barkov
387492008-08-12
11:39
2008-08-13
18:29
MySQL Server: DMLNot a Bug
(4186 days)
S15.0.51a-6Linux (debian lenny)AnyDuplicate error on INSERT - primary key auto increment column  
302782007-08-07
16:47
2012-05-18
20:19
MySQL Server: InnoDB storage engineNo Feedback
(3779 days)
S55.1.20AnyAnyInnoDB: performance regression for update_with_key_prefix operation(mysql-bench)  
26692004-02-06
17:21
2004-02-09
15:34
MySQL Server: InnoDB storage engineNot a Bug
(5833 days)
S14.0.16Linux (Linux - Mandrake 9.0)AnyUpdate fails for no reason - Incorrect "1062 = Duplicate entry" Dean Ellis
945412019-03-04
9:32
2019-09-04
15:47
MySQL Server: InnoDB storage engineClosed
(147 days)
S25.7.25AnyAnyAssertion on import via Transportable Tablespace  
243022006-11-14
15:33
2006-11-15
10:48
MySQL ServerNot a Bug
(4823 days)
S24.1.21Microsoft Windows (Windows)AnyINSERT ...SELECT...ON DUPLICATE KEY not recognizing source field(s)  
270332007-03-11
14:09
2007-03-20
17:43
MySQL ServerClosed
(4698 days)
S25.0.37Microsoft Windows (Windows 2003/Linux)AnyLAST_INSERT_ID returns 0 on using INSERT... ON DUPLICATE KEY UPDATE ... Evgeny Potemkin
273872007-03-23
4:08
2007-03-30
17:06
MySQL Server: GeneralNot a Bug
(4688 days)
S2All 5.0 and 5.1, 4.1, 5.2Any (All)AnyError checking is incorrect in INSERT ... ON DUPLICATE KEY UPDATE Evgeny Potemkin
369202008-05-23
15:27
2008-10-31
13:03
MySQL ServerCan't repeat
(4107 days)
S15.1.xMicrosoft Windows (XP32, VISTA64)AnyServer (5.1.x) stops error Can't write; duplicate key in table 'C\Windows\temp'  
524732010-03-30
12:51
2011-02-16
23:44
MySQL Cluster: ReplicationVerified
(3567 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
(1189 days)
S35.6AnyAnyManual does not explain locks set by SELECT ... FOR UPDATE properly Daniel Price
145602005-11-02
2:30
2006-08-22
14:01
MySQL Server: Row Based Replication ( RBR )Can't repeat
(4908 days)
S25.1.2Linux (Linux)AnyCluster RBR: Slave stops after processing "Create Procedure" with Error in Writ Mats Kindahl
520612010-03-15
10:36
2011-02-16
23:44
MySQL Server: DocumentationClosed
(3605 days)
S3mysql-5.1AnyAnyMySQL Cluster docs : Wrong parameter effect description Jon Stephens
781442015-08-19
22:34
2015-11-24
9:07
MySQL Server: Stored RoutinesVerified
(1622 days)
S35.6.19-log Linux (RDS)AnyError handler not being triggered for multi-table update  
696992013-07-09
15:31
2013-07-10
5:21
MySQL Server: InnoDB storage engineDuplicate
(2394 days)
S25.6.11LinuxAnyadd foreign key error  
232332006-10-12
22:28
2007-04-04
4:03
MySQL ServerClosed
(4683 days)
S35.1.11-beta and 5.0.26/5.0BK/5.1BKMicrosoft Windows (WINDOWS)AnyNO_AUTO_VALUE_ON_ZERO and INSERT...ON DUPLICATE cause insertion failure Evgeny Potemkin
54342004-09-06
16:32
2004-09-06
20:24
MySQL ServerNot a Bug
(5623 days)
S24.0.15-max-debugMicrosoft Windows (win2k)Anyconstraint name not honored for foreign keys  
109232005-05-27
17:12
2006-04-04
8:10
MySQL Cluster: Cluster (NDB) storage engineClosed
(5048 days)
S45.1-wl2325Linux (Linux)AnySlave cluster not always updated properly from master cluster with two mysqld Tomas Ulin
225202006-09-20
14:26
2012-05-18
20:19
MySQL ServerDuplicate
(4857 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
(4204 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
(4430 days)
S25.1AnyAnyFKs allowed to reference partitioned table Mattias Jonsson
408012008-11-17
19:52
2009-05-15
12:56
MySQL Server: Falcon storage engineClosed
(3911 days)
S36.0.86.0.10AnyAnyFalcon garbage collection can erase valid key values Kevin Lewis
436372009-03-13
16:53
2009-03-18
12:51
Connector / JNot a Bug
(3969 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
(2074 days)
S25.5.37, 5.5.38AnyAnyWrong Results When Using Intersect  
29962004-02-27
11:57
2004-03-11
12:23
MySQL ServerClosed
(5802 days)
S24.0.18Linux (Linux 2.4.25 (Slackware 9.1+))Anyupdate on left join can change non matching record in second table. Sinisa Milivojevic
93132005-03-21
13:19
2005-03-21
13:34
MySQL Server: ReplicationClosed
(5427 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
(3192 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
(1344 days)
S35.1.73 LinuxAnyfunction updating a view fails to find table that actually exists Bogdan Kecman
471752009-09-07
13:25
2011-02-16
23:44
MySQL Server: Row Based Replication ( RBR )Closed
(3615 days)
S35.1,5.45.5+AnyAnyfailing INSERT, transaction, replication out of sync Alfranio Correia
724072014-04-20
20:47
2014-04-24
17:30
MySQL Server: LockingNot a Bug
(2106 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
(1121 days)
S35.6, 5.7.11AnyAnyEXPLAIN output depends on binlog_format setting  
356342008-03-28
8:54
2008-10-01
15:08
MySQL Server: Command-line ClientsWon't fix
(4137 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
(3085 days)
S3server 5.1.37Any (MS Windows, Mac, Linux)AnyON DUPLICATE KEY UPDATE and updateCount() possibly wrong  
552222010-07-13
16:52
2019-05-15
10:40
MySQL Server: InnoDB storage engineClosed
(3306 days)
S25.1.x, 5.1.49-bzrAny (Windows 7, Mac OS X)AnyMysqldump table names case bug in REFERENCES clause Kevin Lewis
828092016-08-31
7:20
2016-09-10
9:38
MySQL UtilitiesVerified
(1236 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
(257 days)
S35.7, 8.0AnyAnygenerated column not accept foreign key for column included  
83332005-02-05
7:52
2005-02-05
8:00
MySQL ServerCan't repeat
(5471 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
(5353 days)
S25.0.4 max ntMicrosoft Windows (windows 2000 sp4)AnyDuplicate entry error in SELECT Evgeny Potemkin
292402007-06-20
15:08
2007-08-07
7:03
MySQL Server: Falcon storage engineClosed
(4558 days)
S36.0.1-alpha-debugLinux (SUSE 10 64-bit)AnyFalcon: duplicate-key error when there's no duplicate key Christopher Powers
830452016-09-20
7:11
2016-09-20
8:55
MySQL Server: InnoDB storage engineDuplicate
(1226 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
(3417 days)
S35.1AnyAnyCluster replication conflict resolution docs confuse me Jon Stephens
35122004-04-20
2:11
2004-04-27
16:26
MySQL ServerNot a Bug
(5755 days)
S34.0.18Microsoft Windows (Win2K)Anymysterious failure of insert due to duplicate key Dean Ellis
107152005-05-18
15:32
2005-07-11
15:12
MySQL Server: MyISAM storage engineNo Feedback
(5315 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
(3305 days)
S35.1.46, plugin 1.0.7AnyAnywrong duplicate key error when adding a unique index via fast alter table John Russell
960492019-07-01
14:09
2019-07-02
8:21
MySQL Server: DMLVerified
(211 days)
S48.0AnyAnyIGNORE clause which doesn't override strict mode  
114082005-06-17
8:30
2005-06-17
8:37
MySQL Server: InnoDB storage engineNot a Bug
(5339 days)
S35.0.7Microsoft Windows (win2000)Anyshow table status return wrong  
17282003-10-31
17:01
2003-12-13
4:44
MySQL ServerWon't fix
(5891 days)
S24.0.16Linux (Red Hat linux 8.0)Anylock timeout not consistently returned by mysql_query() Sergei Glukhov
110802005-06-03
17:32
2005-06-07
10:52
MySQL Server: OptimizerClosed
(5349 days)
S35.0.7Linux (Linux/x86)AnyMulti-row REPLACE fails on a duplicate key error on an AUTO-INC column Michael Widenius
434542009-03-06
13:38
2009-03-06
15:09
MySQL Server: ParserNot a Bug
(3981 days)
S25.1.30LinuxAnyGROUP BY makes columns unrecognized when doing INSERT SELECT ... ON DUPLICATE K  
127992005-08-25
9:46
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3773 days)
S35.0.10-log, 4.1.13a-log on win, 4.1 on RHES3.05.5+Microsoft Windows (windows xp)Anyone result returned when change from summer time causes dup unique key recs Evgeny Potemkin
27922004-02-14
6:03
2004-09-14
13:03
MySQL Server: InnoDB storage engineNot a Bug
(5615 days)
S34.0.16Linux (Debian 3.0)Any2nd foreign key behaviour "On * do-sth" is missing in comment of Table-Status Heikki Tuuri
310872007-09-18
17:47
2007-10-18
18:09
MySQL Server: Stored RoutinesNo Feedback
(4486 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
(2866 days)
S45.5.8, 5.5.11LinuxAnyslow INSERTs, sometimes  
673752012-10-25
5:46
2014-01-13
17:58
Connector / JNot a Bug
(2207 days)
S25.5Microsoft WindowsAnyON DUPLICATE KEY UPDATE produces wrong affectedRows  
788542015-10-16
1:21
2015-10-27
3:28
MySQL Server: DocumentationNot a Bug
(1555 days)
S35.6, 5.7AnyAny"more than one unique or primary key"  
198612006-05-16
19:47
2016-01-03
20:45
MySQL Server: InnoDB storage engineDuplicate
(4998 days)
S35.0.22-BK, 5.0.18Linux (Linux)Any[reference_definition] in [column_definition] section of create table statement Assigned Account
470312009-08-31
23:43
2011-02-16
23:44
MySQL Server: TestsCan't repeat
(3802 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
(3750 days)
S35.0.85LinuxAnymysql-test view.test fails  
521762010-03-18
11:11
2011-02-16
23:44
MySQL Server: InnoDB storage engineNo Feedback
(3567 days)
S25.0.90Microsoft WindowsAnyMYSQL-NT goes in crash under windowxp  
280002007-04-21
14:59
2007-05-17
14:24
MySQL ServerClosed
(4640 days)
S35.0.37,5.1, 6.0-falcon-bkAnyAnyMySQL hangs when using INSERT IGNORE ... ON DUPLICATE KEY Gleb Shchepa
504392010-01-19
11:16
2011-09-30
18:19
MySQL Server: ReplicationClosed
(3043 days)
S25.1+5.1+AnyAnymark INSERT...SEL...ON DUP KEY UPD,REPLACE...SEL,CREATE...[IGN|REPL] SEL unsafe Sven Sandberg
542012010-06-03
12:18
2015-08-26
20:25
MySQL Server: ReplicationClosed
(2833 days)
S25.1.47AnyAny"SET INSERT_ID" event must be ignored if corresponding event is ignored Sven Sandberg
618502011-07-13
8:19
2011-07-13
8:55
Connector / JClosed
(3122 days)
S35.1Linux (Squeeze)AnyJDBC: return value of INSERT ON DUPLICATE KEY does not match command line client  
336642008-01-03
17:41
2008-01-28
18:44
MySQL WorkbenchClosed
(4384 days)
S25.0.11 SE Beta Rev 2342Microsoft Windows (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
(286 days)
S35.6.21/5.7LinuxAnyUnable to update Foreign Key created as NOT NULL to table named with a Dollar $  
97252005-04-07
16:36
2005-07-12
5:06
MySQL ServerClosed
(5314 days)
S34.1.11Any (*)Any"disapearing query/hang" and "unknown error" with "on duplicate key update" Antony Curtis
114422005-06-20
2:25
2011-02-16
23:43
MySQL Server: DMLVerified
(4781 days)
S45.0TBDAny (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
(4839 days)
S34.1.13, 5.0.21Linux (Linux)Anyambigous field with INSERT ... SELECT ... ON DUPLICATE KEY UPDATE Paul Dubois
358562008-04-05
23:31
2008-10-16
4:30
MySQL Server: InnoDB storage engineDuplicate
(4122 days)
S35.0.45AnyAnyfalse unique constraint violation on multiple updates  
408722008-11-19
23:09
2016-10-16
20:45
MySQL Server: ReplicationNo Feedback
(4057 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
2011-02-16
23:43
MySQL Cluster: ReplicationNo Feedback
(3889 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
(2037 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
(846 days)
S25.7.17CentOSAnyBug in "INSERT... ON DUPLICATE KEY UPDATE" query  
136902005-10-02
16:28
2005-11-17
9:50
MySQL ServerNo Feedback
(5186 days)
S34.1.12a-ntMicrosoft Windows (WinXP Pro)AnyERROR 1216 (23000): Cannot add or update a child row: a foreign key constraint  
258262007-01-24
13:26
2011-02-16
23:43
MySQL Server: ErrorsVerified
(4730 days)
S45.0.36-BK, mysql-5.2.0-falcon-alpha-win32Microsoft Windows (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
(2231 days)
S36.1.0-alpha-debugLinux (SUSE 10.0 / 32-bit)AnyForeign keys: failure with update cascade and duplicate key  
641392012-01-26
22:20
2015-04-29
7:58
MySQL Cluster: ReplicationVerified
(2925 days)
S3mysql-cluster-gpl-7.2.2AnyAnyDuplicate INSERTs in binary log for NDB tables when binlog_format=STATEMENT Matthew Montgomery
768952015-04-30
6:06
2016-04-04
20:39
MySQL Server: InnoDB storage engineNot a Bug
(1735 days)
S25.6.24AnyAnyAdding new column OR Drop column causes duplicate PK error  
604892011-03-16
13:44
2011-07-05
16:36
MySQL Server: DocumentationNot a Bug
(3130 days)
S35.5.10Microsoft Windows (XP)AnyUpdate returnd god result but CURRENT_TIMESTAMP field not updated Paul Dubois
36752004-05-06
9:33
2004-05-06
19:32
MySQL ServerNot a Bug
(5746 days)
S24.0+4.1Microsoft Windows (Windows 2000)AnyUPDATE on multiple tables doesn't work correctly when inner joining by a comma Dean Ellis
46662004-07-21
3:30
2004-08-06
16:14
Connector / NETClosed
(5654 days)
S20.7.6.15073Microsoft Windows (Win XP Pro)AnyMySqlDataAdapter.Update does not update Database Matthew Lord
571532010-09-30
20:32
2018-02-11
13:02
MySQL Server: DMLCan't repeat
(717 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
(2401 days)
S15.6.12Microsoft Windows (XP SP3)AnyMySQL server 5.6.12 configuration failed  
891012018-01-04
1:52
2018-01-18
13:05
MySQL Server: DMLVerified
(741 days)
S25.7.20AnyAnyMySQL server hang when gtid_mode=on and innodb_thread_concurrency>0  
391552008-09-01
11:29
2008-10-01
14:50
MySQL Server: ReplicationNo Feedback
(4137 days)
S15.1.23Microsoft Windows (2000 sp4)AnyReplication error duplicate entry  
751892014-12-12
7:09
2014-12-19
22:15
MySQL Server: TestsVerified
(1867 days)
S35.6AnyAnyengines suite tests depending on InnoDB implementation details  
265072007-02-20
17:59
2012-10-16
5:21
MySQL Server: InnoDB storage engineNot a Bug
(2661 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) Jimmy Yang
622102011-08-19
11:47
2012-02-02
19:59
MySQL Server: InnoDB Plugin storage engineCan't repeat
(2918 days)
S25.1.48 (1.0.9)Linux (2.6.18-164.el5)Anymemory corruption for THD after deadlock in foreign key reference constrain  
69462004-12-02
14:31
2006-02-14
14:28
MySQL ServerWon't fix
(5097 days)
S4*Any (*)AnyINSERT ... ON DUPLICATE KEY UPDATE without INSERT  
640252012-01-13
14:21
2012-01-15
19:15
MySQL Server: DMLVerified
(2938 days)
S35.1.61, 5.5.15AnyAnyON DUPLICATE KEY UPDATE sets auto_increment column value to 0  
185072006-03-25
11:33
2016-01-03
20:45
MySQL Server: InnoDB storage engineDuplicate
(5058 days)
S35.0.19 and 5.1.7-betaMicrosoft Windows (windows xp pro)Anyforeign key Assigned Account
504562010-01-19
20:17
2010-01-19
21:08
MySQL Server: PartitionsNot a Bug
(3662 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
(1570 days)
S27.4.6-1.el7.x86_64Oracle Linux (7.1)AnyERROR 1553 (HY000): Cannot drop index needed by foreign constraint Bogdan Kecman
812502016-04-29
19:57
2016-11-16
15:59
MySQL Server: OptimizerClosed
(1169 days)
S2mysql 5.7.9, 5.7.12Linux (centos6.5)Anysql plan is not right according to optimizer_trace  
170862006-02-03
0:39
2006-07-03
14:42
MySQL Cluster: Cluster (NDB) storage engineClosed
(4958 days)
S34.1 ->Linux (Linux 32 Bit OS)Anyrpl_auto_increment.test fix for ndb Tomas Ulin
814862016-05-18
11:43
2016-05-24
18:51
MySQL Server: DMLClosed
(1350 days)
S35.6.30, 5.5.49DebianAnyERROR 1452 throws as ERROR 1062 if query has ON DUPLICATE stament  
567312010-09-11
14:43
2018-10-21
20:45
Connector / ODBCNo Feedback
(1675 days)
S25.1.6Mac OS X (likely other OSes)AnySecond SQLSetPos(Update) not posting update to database Assigned Account
79362005-01-16
1:15
2005-06-07
15:50
MySQL Server: Memory storage engineOpen
(5349 days)
S44.0.17FreeBSD (FreeBSD)AnyHEAP table HASH not optimized for searches that usually do not match KEY  
676152012-11-16
16:21
2018-01-26
16:20
MySQL Server: InnoDB storage engineNot a Bug
(733 days)
S25.5.28Linux (6.2)AnyMassive conccurent inserts and lock wait timeout Matthew Lord
700862013-08-19
16:06
2013-11-03
1:00
MySQL Server: OptimizerNo Feedback
(2279 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
(1056 days)
S45.6,5.7.17AnyAnyAmbiguous Error Message in safe_updates mode  
450522009-05-24
7:46
2011-02-16
23:44
MySQL ServerClosed
(3513 days)
S26.0.10-alpha,5.45.4+Linux (OpenSuse 10.3)AnyALTER TABLE ADD COLUMN crashes server with multiple foreign key columns Alexey Botchkov
465252009-08-03
10:16
2011-02-16
23:44
MySQL Server: InnoDB storage engineCan't repeat
(3488 days)
S5LinuxAny5.1.36: innodb: updates / alter table exremley slow  
288672007-06-04
7:45
2007-06-04
8:29
MySQL ServerNot a Bug
(4622 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
(3637 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
(3524 days)
S4AnyAnyFeature request for RBR auto-fix slave functionality Assigned Account
642902012-02-10
6:24
2012-02-10
15:41
MySQL Server: DMLNot a Bug
(2910 days)
S35.5.15Microsoft WindowsAnyINSERT 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
(2059 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
(329 days)
S38.0.12AnyAnyPrimary key 1 causes ON DUPLICATE KEY UPDATE to use erroneous value  
100952005-04-22
12:38
2005-05-19
2:06
MySQL Server: OptimizerClosed
(5368 days)
S14.0.24Linux (linux)AnyAND/OR - get diff result Sergey Petrunya
106492005-05-15
23:19
2006-09-30
12:18
MySQL ServerDuplicate
(4869 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
(4965 days)
S25.1.12Linux (Linux/all)AnyWrong usage of mysys/hash.c Kristian Nielsen
385502008-08-04
21:47
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4122 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
(2832 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
(259 days)
S35.5, 5.5.42AnyAnyforeign-keys testcase mismerged in 5.5  
291802007-06-18
16:48
2007-06-26
12:57
MySQL ServerClosed
(4600 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
(3969 days)
S25.1.30AnyAnyStatement.executeUpdate() gives strange update count with INSERT ...ON DUPLICATE  
36592004-05-05
10:34
2004-07-19
13:39
MySQL Cluster: Cluster (NDB) storage engineClosed
(5672 days)
S1mysql-4.1.2-alpha bkFermiLinux LTS 3.01Any>1 concurrent update causes deadlock Magnus Blåudd
267432007-03-01
9:02
2007-04-30
9:06
MySQL Migration ToolkitClosed
(4657 days)
S31.1.11, 1.1.10, 1.1.9Microsoft Windows (Win XP)AnyCreated SQL Syntax failed for "DEFAULT USER"  
336562008-01-03
16:28
2008-02-04
20:49
MySQL WorkbenchClosed
(4377 days)
S25.0.11 SE Beta Rev 2342Microsoft Windows (XP 32 bit)AnyWorkbench Generates Invalid Foreign Index Statements Johannes Taxacher
140552005-10-16
4:18
2005-10-18
22:02
MySQL ServerWon't fix
(5216 days)
S24.1.16Any (any)AnyAES_DECRYPT returns NULL on valid input Jim Winstead
238422006-11-01
15:33
2006-11-02
3:52
MySQL ServerNot a Bug
(4836 days)
S35.0.27-community-ntMicrosoft Windows (Windows XP)AnyUnsigned check on "ON DUPLICATE KEY" query  
22932004-01-06
3:17
2005-08-04
23:35
MySQL Websites: bugs.mysql.comClosed
(5291 days)
S4 AnyEnhance the marking of duplicate bug reports Indrek Siitan
744962014-10-22
8:08
2014-10-24
8:44
MySQL Server: DDLNot a Bug
(1925 days)
S35.6.21Microsoft WindowsAnyView creation: error in checking duplicate column names  
763142015-03-13
13:17
2016-02-04
19:33
MySQL Server: OptimizerClosed
(1582 days)
S35.7AnyAnySemi-join duplicate elimination gives lower cost than no duplicate elimination  
150452005-11-18
9:35
2018-06-14
16:56
MySQL Server: InnoDB storage engineVerified
(3548 days)
S44.1Microsoft Windows (windows xp)Anycan't drop and recreate foreign key in a single ALTER TABLE statement Assigned Account
733002014-07-16
18:03
2015-04-01
4:41
MySQL Server: InnoDB storage engineClosed
(1994 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
(329 days)
S28.0.13LinuxAnyIndex performance degradation, ~50 times slower after 30 hours. reproduceable  
65922004-11-12
13:37
2004-12-16
3:42
MySQL Cluster: Cluster (NDB) storage engineNo Feedback
(5522 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
(5341 days)
S21.0.6betaMicrosoft Windows (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
(5298 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
(5094 days)
S34.1->Linux (Linux)AnyCluster returns different duplicate key error then other engines Jon Stephens
191332006-04-16
19:51
2006-04-17
13:07
MySQL ServerNot a Bug
(5035 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
(4954 days)
S25.0Linux (Linux 32 bit OS)Anyauto inc table not handled correctly when restored from cluster backup Tomas Ulin
213352006-07-28
23:08
2007-07-05
20:30
MySQL Server: DocumentationNot a Bug
(4591 days)
S24.1.22 4.0.28AnyAnyUNIQUE index on TEXT columns allows trailing whitespace Paul Dubois
268032007-03-02
19:15
2007-04-13
9:04
MySQL Server: Falcon storage engineClosed
(4674 days)
S35.1AnyAnyunique constraints on VARCHAR columns behave different in MyISAM and Falcon Kevin Lewis
270222007-03-10
10:52
2007-04-06
18:06
MySQL Server: InstallingClosed
(4681 days)
S15.0.38, 5.1.17Linux (Linux)AnyInstall fails with Duplicate entry '%-test-' for key 'PRIMARY' Magnus Blåudd
276162007-04-03
13:45
2007-04-17
13:41
MySQL Enterprise Monitor: ServerClosed
(4670 days)
S21.1.0.4973Microsoft Windows (Windows XP)AnyMySQLIntegrityConstraintViolationException: Duplicate entry '...' for key 2 Darren Oldag
313492007-10-02
18:13
2007-12-20
0:43
MySQL Server: Data TypesClosed
(4423 days)
S35.1.23-debug, 5.0.48-debugAnyAnyERROR 1062 (23000): Duplicate entry '' for key 'group_key' Ramil Kalimullin
336882008-01-04
11:33
2008-03-13
5:52
MySQL Server: ReplicationClosed
(4339 days)
S16.0.46.0.4AnyAnyFalcon: replication fails on duplicate key error Antony Curtis
358072008-04-03
15:53
2008-09-15
16:09
MySQL Server: Row Based Replication ( RBR )Closed
(4153 days)
S35.1.245.1.28+AnyAnyINSTALL PLUGIN replicates row-based, but not stmt-based Ingo Strüwing
368012008-05-19
15:02
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(3548 days)
S4AnyAnyInnoDB should release the lock on a duplicate key under REPEATABLE READ Assigned Account
410262008-11-25
19:08
2011-02-16
23:43
MySQL ServerClosed
(4073 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
(1106 days)
S3mysql-6.0AnyAnyautoincrement insert into ndb fails with duplicate key  
472072009-09-09
7:21
2018-07-19
7:52
MySQL Server: ErrorsVerified
(3794 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
(3633 days)
S35.15.1+AnyAnyServer adding duplicate row with duplicate WHERE clause condition and Innodb Sergei Glukhov
501992010-01-08
22:56
2018-09-09
20:45
MySQL Server: OptimizerDuplicate
(3673 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
(3673 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
(3210 days)
S25.5.11Mac OS X (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
(1972 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
(2165 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
(1051 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
(1367 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
(643 days)
S25.7.20AnyAnyCommit order deadlock + retry logic is not considering trx error cases Venkatesh Duggirala
950792019-04-23
2:32
2019-04-25
9:21
MySQL Server: InnoDB storage engineVerified
(281 days)
S35.7, 5.7.25AnyAnyFalse duplicate key check  
651112012-04-26
9:31
2012-05-15
18:33
MySQL Server: InnoDB Plugin storage engineClosed
(2815 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
(369 days)
S35.1, 5.5, 5.6, 5.7, 8.0AnyAnyInnoDB: Unlock row could not find a 2 mode lock on the record  
256732007-01-17
9:27
2007-03-15
2:46
MySQL Server: MyISAM storage engineClosed
(4703 days)
S15.0.34,5.0.36-BK,5.1.15-BK *Anyspatial index corruption, error 126 incorrect key file for table Ingo Strüwing
417542008-12-26
12:03
2017-05-21
20:45
MySQL Server: ReplicationDuplicate
(3963 days)
S25.0.70, 5.1.30, 6.0.95.1+AnyAny'Cannot add or update a child row: a foreign key constraint fails' on SBR+Innodb Assigned Account
62702004-10-26
20:28
2004-12-01
19:44
MySQL Server: MyISAM storage engineNot a Bug
(5537 days)
S24.1.7Linux (Linux)AnyUPDATE report a duplicate key error whereas it shouldn't Sergei Golubchik
87322005-02-23
14:49
2012-05-18
20:19
MySQL ServerDuplicate
(5290 days)
S34.1.10Any (*)AnyINSERT ... SELECT ...ON DUPLICATE KEY UPDATE problem Assigned Account
87362005-02-23
17:31
2005-02-23
21:51
MySQL ServerClosed
(5453 days)
S34.1.10Any (*)Anyon duplicate key update allows/ignores updates to read table Jorge del Conde
272102007-03-16
12:31
2007-08-29
2:10
MySQL ServerClosed
(4536 days)
S25.0.36, 5.0.37Linux (Linux, Windows)AnyINNODB ON DUPLICATE KEY UPDATE Timothy Smith
297282007-07-11
17:54
2007-08-13
20:21
MySQL Server: ReplicationCan't repeat
(4552 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
(4565 days)
S35.0.42-enterprise-gplAnyAnyon duplicate key update does insert and update at the same time Dean Ellis
380462008-07-11
14:22
2012-08-03
15:34
MySQL Server: LockingClosed
(2735 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
(3911 days)
S16.0.11-bzr6.0.11Solaris (Solaris 10 x64)AnyAssertion (transState != NULL) failed in Transaction::waitForTransaction Olav Sandstå
524552010-03-30
1:54
2011-02-16
23:44
MySQL Server: PartitionsClosed
(3394 days)
S35.15.1+AnyAnySubpar INSERT ON DUPLICATE KEY UPDATE performance with many partitions Mattias Jonsson
569352010-09-22
14:50
2010-09-23
5:24
MySQL Server: ParserNot a Bug
(3415 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
(3352 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
(2694 days)
S35.1.41Microsoft Windows (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
(2346 days)
S25.2.5Microsoft Windows (window7 64bit)AnyINSERT ON DUPLICATE KEY UPDATE does regularly report "-1" Bogdan Degtyariov
950962019-04-24
1:27
2019-04-24
6:03
MySQL Server: DMLNot a Bug
(280 days)
S3AnyAnyINSERT INTO ... ON DUPLICATE KEY UPDATE returns wrong number of rows updated  
370162008-05-27
19:25
2011-02-16
23:43
MySQL Server: DDLClosed
(4017 days)
S35.1, 6.0-bk5.1.31AnyAnyTRUNCATE TABLE removes some rows but not all Davi Arnaut
537122010-05-17
16:13
2011-02-16
23:44
MySQL Server: GeneralNo Feedback
(3512 days)
S25.1.46SolarisAnyORDER BY causes incorrect query result  
673042012-10-19
20:54
2012-11-24
1:00
MySQL Workbench: ModelingNo Feedback
(2623 days)
S35.2.44 win32.msiMicrosoft WindowsAnymySQL 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
(2337 days)
S25.6.13Linux (2.6.16.33-xenU x86_64)Anyincorrect costing for range scan causes optimizer to choose incorrect index Jørgen Løland
119072005-07-13
10:04
2013-05-30
5:22
Connector / ODBCCan't repeat
(2435 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
(4240 days)
S36.0.56.0AnyAnyFalcon allows a key to be named PRIMARY_KEY Ann Harrison
103962005-05-05
19:03
2011-02-16
23:43
MySQL Server: Command-line ClientsVerified
(5343 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
(4319 days)
S25.1.23-rcLinux (IA64, icc)AnyWrong select results returned by cluster Kristian Nielsen
170162006-02-01
16:51
2008-01-09
23:08
Connector / ODBCCan't repeat
(4403 days)
S23.51Microsoft Windows (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
(4725 days)
S21.1.0.4732Linux (RHEL4)AnyService Manager update installer fails on Linux BitRock Merlin
426152009-02-05
10:59
2011-02-16
23:43
MySQL Server: GeneralVerified
(3993 days)
S45.0.27FreeBSDAnyUPDATE statement workflow  
486632009-11-10
10:51
2011-02-16
23:44
MySQL Server: ErrorsClosed
(3303 days)
S25.1.345.1+AnyAnySTRICT_TRANS_TABLE causing an error when 0 rows found in an UPDATE trigger Tatiana Azundris Nuernberg
490702009-11-24
20:53
2016-02-25
12:24
MySQL Workbench: AdministrationNot a Bug
(3647 days)
S25.2 r4753WB52Microsoft Windows (XP)AnyWB creating strange GRANTs  
523502010-03-25
0:19
2011-02-16
23:44
MySQL WorkbenchClosed
(3534 days)
S15.2.16wb52AnyAnycannot set ON UPDATE CURRENT_TIMESTAMP as default value Alexander Musienko
530752010-04-22
18:12
2011-02-16
23:44
MySQL Server: ReplicationClosed
(3553 days)
S35.6.99-m4AnyAnySBR: Strange warning around CONNECTION_ID() Alfranio Correia
209772006-07-11
22:07
2006-08-10
16:01
MySQL Server: ViewsClosed
(4920 days)
S35.1.12Linux (Fedora core 5)Anyconfusing results after setting 'updatable_views_with_limit' to 'NO' Georgi Kodinov
805282016-02-26
13:09
2016-09-18
1:00
MySQL Workbench: ModelingNo Feedback
(1229 days)
S26.3.6Microsoft Windows (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
(1433 days)
S26.3.6Microsoft Windows (Microsoft Windows 10 Pro)AnyCopying a PK-column as reference into another table impossible to remove AI  
151892005-11-23
15:59
2011-02-16
23:43
MySQL Server: DMLVerified
(5180 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
(4578 days)
S35.2.0, 5.0.38-bkLinux (SUSE 10.0 / 64-bit)AnyFederated: INSERT failures Antony Curtis
299412007-07-20
19:19
2013-02-20
22:37
Connectors: DBD::mysql ( Perl )Unsupported
(2534 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
(4205 days)
S5mysql community 5.0.41 Microsoft Windows (XP sp2)Anydead lock and slow insert Mikhail Izioumtchenko
592482010-12-31
23:31
2013-01-22
19:06
MySQL Server: DMLClosed
(2563 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
(1764 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
(469 days)
S35.7.15-log MySQL Community Server (GPL)CentOSAnyinsert ..on duplicate key update return 0 rows affected  
159322005-12-22
9:31
2006-01-22
13:41
MySQL ServerNo Feedback
(5120 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
(5060 days)
S35.1.8Linux (Linux 32 Bit OS)AnyCluster is not optimizing on indexes provided. "Impossible WHERE noticed" Assigned Account
444472009-04-23
21:25
2009-04-24
6:05
MySQL Server: Information schemaNot a Bug
(3932 days)
S35.0.51aAnyAnyIncorrect clustered index in InnoDB table?  
608762011-04-15
6:20
2011-04-23
16:47
MySQL ServerNot a Bug
(3203 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
(2422 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
(2147 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
(2066 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
(1206 days)
S25.6.24Microsoft WindowsAnymysqldbcompare and mysqldiff error updating  
530792010-04-22
19:04
2017-05-21
20:45
MySQL Server: ReplicationDuplicate
(3374 days)
S25.1.45, 5.1, 5.6.99AnyAnydue to a trigger, replication fails with DUPLICATE KEY error for an UPDATE Assigned Account
622252011-08-22
9:28
2011-08-22
10:36
MySQL Server: ErrorsNot a Bug
(3082 days)
S25.1.53Microsoft Windows (7)AnyUpdate with unique column of type TIMESTAMP  
325212007-11-20
13:51
2008-09-25
9:52
MySQL Server: DDLNo Feedback
(4143 days)
S35.0.46Microsoft WindowsAnyMySQL fails to create table where keynames matches to the constraint names.  
96892005-04-06
17:37
2005-04-22
21:10
MySQL Server: OptimizerNot a Bug
(5395 days)
S34.1.11Any (*)Anywrong result for subselect in on duplicate key update (query cache) Igor Babaev
2412003-04-07
17:24
2003-04-23
2:27
MySQL Server: InnoDB storage engineClosed
(6125 days)
S24.0.12sparc-sun-solaris2.8AnyUPDATE ... ORDER BY does not work with InnoDB Michael Widenius
164942006-01-13
20:09
2006-08-18
17:07
MySQL Server: Federated storage engineClosed
(4912 days)
S15.0.18/5.0.19 BK/5.0.24Linux (Linux)AnyUpdates that set a column to NULL fail sometimes Jim Winstead
324712007-11-17
16:01
2007-11-29
15:37
MySQL Server: GeneralNot a Bug
(4444 days)
S35.0.45, 4.1, 5.0, 5.1 BKAny (Linux, Windows)AnyConditional update statement not working as expected Georgi Kodinov
605162011-03-17
15:26
2011-11-24
11:33
MySQL Server: DMLClosed
(2988 days)
S15.5.10Linux (Fedora 14)AnyUPDATE within a function fails and causes infinite loop  
983452020-01-24
9:32
2020-01-27
5:23
MySQL WorkbenchAnalyzing
(2 days)
S38.0.19Microsoft Windowsx86MySQL Workbench crashes during update model Ashwini Patil
934102018-11-29
16:57
2019-02-21
2:39
MySQL Server: DMLClosed
(342 days)
S18.0.13CentOSAnyInsert is fine but "On Duplicate Update" updating wrong data  
17012003-10-29
6:48
2003-12-07
14:07
MySQL Server: ReplicationClosed
(5897 days)
S34.0.15-std-logLinux (Linux RH9)AnyUpdate from multiple tables Guilhem Bichot
62542004-10-25
20:34
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(4907 days)
S44.1.7-debugLinux (SuSE 9.1)AnyIGNORE: should allow transactional tables to do partial transactions Assigned Account
5732003-06-03
6:45
2003-07-03
5:36
MySQL Server: ReplicationClosed
(6054 days)
S34.0Any (all)Anyslave prints an incomplete error message when LOAD DATA INFILE gives dup entry Guilhem Bichot
52632004-08-27
20:12
2004-09-06
13:41
MySQL ServerClosed
(5623 days)
S35.0.2-alpha-debugLinux (SuSE 8.2)AnyViews: crash if INSERT ... ON DUPLICATE KEY Oleksandr Byelkin
61262004-10-16
9:19
2004-11-22
18:10
MySQL Server: InnoDB storage engineClosed
(5546 days)
S34.1.5 Anyinnodb index with duplicate column gives missleading error message Antony Curtis
108552005-05-25
8:56
2005-06-26
6:35
MySQL ServerCan't repeat
(5330 days)
S15.0.4Microsoft Windows (Windows XP sp2)AnyDuplicate key error in select AFTER RESET QUERY CACHE  
120832005-07-21
14:31
2005-07-22
10:23
MySQL ServerClosed
(5304 days)
S24.0.20Microsoft Windows (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
(5174 days)
S35.0.15Microsoft Windows (WIN XP SP1)Any230000 DUPLICATE ENTRY 'xxxxxxx' FOR KEY 1  
223372006-09-14
10:28
2012-05-18
20:19
MySQL Server: CharsetsDuplicate
(4852 days)
S45.0.x, 4.1.21, 4.1.10Linux (Linux, Windows)AnyCollation change results in duplicate key ("e" and "é" mixup) Assigned Account
247622006-12-01
21:41
2011-02-16
23:43
MySQL ServerVerified
(3749 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
2012-05-18
20:19
MySQL Server: Falcon storage engineDuplicate
(4059 days)
S26.0-falconAnyAnyFalcon: duplicate-key error for value that ends with 0x00 Assigned Account
387012008-08-10
17:50
2011-02-16
23:43
MySQL ServerClosed
(4121 days)
S15.1.28,6.0.75.1.29+AnyAnyCrash in String::append when inserting duplicate empty strings an uft8 SET col Georgi Kodinov
391862008-09-02
13:49
2008-10-18
15:56
MySQL ServerClosed
(4120 days)
S36.06.0-betaAnyAnyCrash in String::append when inserting duplicate empty strings an uft8 SET col Georgi Kodinov
461442009-07-13
10:32
2010-05-26
18:01
MySQL Server: Falcon storage engineUnsupported
(3535 days)
S2falcon-teamAnyAnyFalcon indexes may become corrupt Lars-Erik Bjørk
577822010-10-27
19:32
2016-01-19
11:31
MySQL Cluster: Cluster (NDB) storage engineVerified
(1471 days)
S3mysql-5.1-telco-7.1AnyAnyndb_restore does not warn of possible duplicate keys when using UNIQUE indexes  
148872005-11-11
21:33
2011-02-16
23:43
MySQL ServerDuplicate
(3332 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
(4779 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
(3470 days)
S3mysql-5.1.22-rc-linux-x86_64-icc-glibc23Linux (Debian 2.6.18-5-amd64)AnyUPDATE not properly using indexes Assigned Account
401132008-10-17
15:51
2011-02-16
23:43
MySQL Server: LockingClosed
(3827 days)
S25.0, 5.1, 6.0 bzr5.0+Any (Linux, Win XP SP2 32bit)AnyEmbedded SELECT inside UPDATE or DELETE can timeout without error Georgi Kodinov
647792012-03-27
16:52
2012-08-24
23:52
Connector / NETClosed
(2714 days)
S36.5.4AnyAnyCascading delete using CreateDatabase in Entity Framework Fernando Gonzalez.Sanchez
487532009-11-13
8:27
2011-02-16
23:44
MySQL Cluster: Cluster (NDB) storage engineNo Feedback
(3677 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
(756 days)
S25.7.19DebianAnyData inconsistency on master after upgrading to 5.7.19  
233832006-10-17
17:42
2006-11-30
20:21
MySQL Server: C API (client library)Closed
(4808 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() Tomash Brechko
137782005-10-05
18:41
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(3512 days)
S15.0/4.1.15Microsoft Windows (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
(2085 days)
S25.0.9Microsoft Windows (Vista)AnyForward Engineer fails to create foreign key constraints  
25182004-01-26
11:10
2005-03-21
22:18
MySQL Server: ReplicationNot a Bug
(5427 days)
S24.0.17Linux (Linux)AnyReplication Guilhem Bichot
258282007-01-24
14:01
2007-01-24
16:13
MySQL Server: Falcon storage engineClosed
(4753 days)
S2mysql-5.2.0-falcon-alpha-win32Microsoft Windows (Win XP)AnyFalcon compound primary key problem Hakan Küçükyılmaz
441702009-04-08
22:55
2011-02-16
23:43
MySQL ServerNo Feedback
(3898 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
(3246 days)
S35.1.55-community, 5.6.3AnyAnydistinct ,distinct_key,group_key  
925302018-09-21
15:48
2019-09-30
18:59
MySQL Server: ErrorsClosed
(205 days)
S35.6.35AnyAnyContribution by Facebook: Add more information to duplicate key error  
860782017-04-25
19:14
2018-04-12
7:51
MySQL Server: ReplicationClosed
(657 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
(5684 days)
S2 AnyInserted data doesn't update properly Reggie Burnett
448492009-05-13
16:04
2013-05-29
6:08
Connector / ODBCClosed
(2436 days)
S15.1Microsoft WindowsAnyCannot update records in a table with a column of type CHAR(3) UNICODE PRIMARY Lawrenty Novitsky
661272012-07-31
18:00
2012-09-08
1:00
MySQL Server: Information schemaNo Feedback
(2701 days)
S25.5.25aSolaris (S11 - MySQL built from source)AnySHOW FULL COLUMNS: Behaviour change:-(  
310892007-09-18
21:20
2007-09-19
1:04
MySQL Server: CompilingNot a Bug
(4515 days)
S35.0.45Linux (Debian Sarge)AnyInnoDB unsafe binlog test fails with wrong error Heikki Tuuri
699392013-08-06
12:49
2013-08-12
3:02
MySQL Server: InnoDB storage engineDuplicate
(2361 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  
104002005-05-06
2:39
2005-05-23
2:10
MySQL Server: MyISAM storage engineClosed
(5364 days)
S14.1.12 forward AnyImproperly-defined MERGE table crashes with INSERT ... ON DUPLICATE KEY UPDATE Ingo Strüwing
120542005-07-20
13:44
2014-03-13
13:34
MySQL Cluster: Cluster (NDB) storage engineWon't fix
(5294 days)
S34.1.12 (max)Linux (Linux)AnyON DUPLICATE KEY UPDATE fails in ndb table Assigned Account
134602005-09-24
14:22
2019-10-10
21:42
MySQL Server: DMLWon't fix
(111 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
(5067 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
(4836 days)
S24.1, 5.0, 5.1Linux (FC 5 / Suse 10.1)AnyCluster INSERT INTO .. ON DUPLICATE KEY UPDATE locks and memory leaks Jonas Oreland
258312007-01-24
15:32
2007-03-06
19:54
MySQL ServerClosed
(4712 days)
S35.0.36-bk, 5.1.15-bkLinux (Linux Suse 10.1)AnyDeficiencies in INSERT ... SELECT ... field name resolving. Georgi Kodinov
262612007-02-10
20:17
2007-03-19
17:41
MySQL ServerClosed
(4699 days)
S35.0bk, 5.1.15Microsoft Windows (Windows XP)AnyMissing default value isn't noticed in insert ... on duplicate key update Georgi Kodinov
279682007-04-20
0:47
2007-04-20
7:47
MySQL Server: GeneralDuplicate
(4667 days)
S35.0.36AnyAnyOn Duplicate Key Update Fails  
286382007-05-23
23:11
2007-07-26
22:03
MySQL ServerNo Feedback
(4570 days)
S35.0.37-community-ntMicrosoft Windows (Windows Vista, 32bit)AnyINSERT ... ON DUPLICATE KEY UPDATE broken  
292122007-06-19
13:42
2007-06-20
5:00
MySQL Server: InnoDB storage engineDuplicate
(4606 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
(4478 days)
S35.0.37-community-nt-logMicrosoft Windows (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
(4348 days)
S25.1.23-rc-communityMicrosoft WindowsAnyInsert ... on duplicate key update problem with federated tables  
395842008-09-22
11:10
2008-09-22
19:52
MySQL Server: Data TypesNot a Bug
(4146 days)
S35.0.45Microsoft WindowsAnyTreating 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
(3900 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
(3184 days)
S2Ver 14.12 Distrib 5.0.91Mac OS XAnyon duplicate key update -- lost data  
655442012-06-06
20:56
2012-08-26
16:13
Connector / JClosed
(2712 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
(2231 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
(1710 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
(1224 days)
S15.7.13, 5.7.15AnyAnyAUTO_INCREMENT not updated when using INSERT ON DUPLICATE KEY UPDATE  
843652016-12-29
2:44
2017-04-06
6:50
Connector / JNo Feedback
(1095 days)
S35.1.40AnyAnyINSERT..VALUE with VALUES function lead to a StringIndexOutOfBoundsException  
965212019-08-13
12:10
2019-08-22
12:47
MySQL Server: OptimizerNot a Bug
(168 days)
S38.0.17AnyAnyon duplicate key update [1048] [23000]: Column 'NAME' cannot be null Bogdan Kecman
965402019-08-14
20:19
2019-08-29
20:14
MySQL Server: ErrorsCan't repeat
(153 days)
S25.6.22, 5.6.34AnyAnyError 1022 on INSERT/UPDATE to InnoDB table with a fulltext index defined Bogdan Kecman
18122003-11-11
22:54
2003-12-13
16:43
MySQL Server: MyISAM storage engineClosed
(5891 days)
S24.0.16Microsoft Windows (Windows XP)AnyTable Corruption possibly due to "DELETE FROM TABLE" Michael Widenius
109312005-05-27
20:54
2005-06-21
11:00
MySQL ServerClosed
(5335 days)
S24.1.xAny (All)AnyHostname cache completely broken in 4.1 Jim Winstead
130242005-09-06
23:04
2011-02-16
23:43
MySQL Server: OptimizerVerified
(5257 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
(4836 days)
S35.1.11-betaLinux (Linux)AnyNDB INSERT fails on table with unique key for ERROR 1296 Jonas Oreland
331342007-12-11
10:57
2011-02-16
23:43
MySQL Server: DDLVerified
(4432 days)
S35.0.51AnyAnydescribe table output wrong for unique key when primary key is dropped  
340782008-01-26
14:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4359 days)
S34.1,5.0,5.1,6.0-BKAny (Linux)Anyref access is not used for varchar column Evgeny Potemkin
460412009-07-08
14:32
2011-02-16
23:44
MySQL WorkbenchNo Feedback
(3826 days)
S35.1.16 OSSMicrosoft Windows (XP SP3)AnyProblem on the export alter SQL script : error 1025  
477702009-10-01
17:46
2012-05-18
20:19
MySQL Server: LockingDuplicate
(3749 days)
S36.0AnyAny100% CPU loop in the MDL_context::wait_for_locks hash Assigned Account
608842011-04-15
20:31
2011-04-27
12:05
MySQL Server: LoggingVerified
(3206 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
(1065 days)
S35.2.44 CEMicrosoft Windows (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
(1675 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
(1598 days)
S26.9.3Microsoft WindowsAnyConnector/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
(477 days)
S15.6.40FreeBSD (11.1)Other (amd64)MySQL crash  
55732004-09-14
16:58
2018-09-09
20:45
MySQL Server: InnoDB storage engineVerified
(4313 days)
S4AnyAnyWrong/undocumented behaviour on UNIQUE column mass update Assigned Account
342282008-02-01
13:55
2018-09-09
20:45
MySQL Server: DMLVerified
(4378 days)
S4*AnyAnyBulk Update statement  
109462005-05-29
21:15
2006-07-24
18:26
MySQL Server: Stored RoutinesClosed
(4937 days)
S3506-beta-logLinux (Linux Suse 9.3)AnyConfusing error messeges in the case of duplicate trigger definition Tomash Brechko
2362003-04-06
13:56
2003-05-15
7:59
MySQL ServerCan't repeat
(6103 days)
S24.0.11-gamma-maxFreeBSD (FreeBSD 4.7-RELEASE)AnyMulti-table update denied to user who has all privleges Michael Widenius
62112004-10-22
11:04
2004-11-01
14:33
MySQL Server: InnoDB storage engineNot a Bug
(5567 days)
S24.0.18Linux (linux)AnyProblem with InnoDB and Locking on Update  
144122005-10-27
21:46
2007-11-06
15:27
Connector / NETDuplicate
(4467 days)
S41.0Microsoft Windows (Windows 2000)AnyMySqlCommandBuilder does not automatically open connections for update  
151662005-11-23
0:39
2006-02-14
3:15
MySQL ServerClosed
(5097 days)
S2 AnyWrong update [was: select/update] permissions required to execute triggers Alexander Nozdrin
173992006-02-14
20:47
2006-05-05
16:39
MySQL ServerNo Feedback
(5017 days)
S15.0.16Microsoft Windows (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
(5026 days)
S34.1.12-logLinux (Red Hat Enterprise Linux ES)Anyupdate query's problem (about atomical property)  
298832007-07-18
23:48
2012-05-18
20:19
Connector / ODBCDuplicate
(4375 days)
S23.51.173.51Microsoft Windows (xp sp 2)AnyMyODBC 3/ADO recordset update if SQL includes a Limit clause Assigned Account
415092008-12-16
14:25
2018-09-25
21:50
Tests: EngineCan't repeat
(4059 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
(3615 days)
S35.45.4+AnyAnyMDL deadlock on LOCK TABLE + CREATE TABLE HIGH_PRIORITY FOR UPDATE Dmitry Lenev
470102009-08-31
9:36
2013-05-29
6:07
Connector / ODBCClosed
(2436 days)
S35.1Microsoft Windows (windows 2008 web server)AnyMysql mediumtext update problem on ADDNEW method Lawrenty Novitsky
537792010-05-19
7:17
2011-02-16
23:44
MySQL Server: LoggingDuplicate
(3542 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
(3479 days)
S1Connector .NET Beta 6.3.2Microsoft Windows (Seven - VS 2010 )Any.NET FormView Update with DataSet generated -- Vladislav Vaintroub
576292010-10-21
13:56
2012-05-18
20:19
Connector / NETNo Feedback
(3134 days)
S16.3.5.0Microsoft Windows (7 prof)AnyUpdate statement bug (last_insert_id) when using mySQL <-> EF4 Code-Only Assigned Account
631222011-11-06
22:51
2011-11-22
12:07
MySQL Server: InnoDB storage engineVerified
(3004 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
(2556 days)
S25.5.29Microsoft Windows (8)AnyIncorrect usage of UPDATE and ORDER BY  
874202017-08-15
11:42
2017-08-25
11:57
MySQL Server: Security: PrivilegesVerified
(896 days)
S35.6.36, 5.6.37, 5.5.56, 5.7.19CentOS (7.3.1611)AnyGRANTS using general and specific permissions  
250092006-12-12
14:33
2007-02-22
14:10
Connector / JClosed
(4724 days)
S3 AnyResultSet is from UPDATE. No Data Mark Matthews
433602009-03-04
10:10
2011-02-16
23:43
MySQL Server: OptimizerClosed
(3355 days)
S36.0-bzrLinux (Ubuntu 8.04)AnyServer crash with a simple multi-table update (InnoDB table) Olav Sandstå
962052019-07-15
9:05
2019-07-15
15:11
MySQL Server: InnoDB storage engineNot a Bug
(198 days)
S3AnyAnynot in expect, two versions row datas in a some transaction  
980882019-12-28
5:54
2020-01-24
15:09
MySQL Server: DMLNeed Feedback
(5 days)
S38.0.18Anyx86Unique index is functioned unexpectedly when entire records are updated target  
56862004-09-21
19:37
2005-11-30
17:43
MySQL Server: MyISAM storage engineClosed
(5173 days)
S14.1.8Linux (linux 2.4.26)Any#1034 - Incorrect key file for table - only utf8 Sergey Vojtovich
353342008-03-17
12:48
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4299 days)
S45.0 allAnyAnyFor MyISAM select * from table order by key_field does not use index Gleb Shchepa
438952009-03-26
18:45
2014-07-14
15:31
MySQL Server: DMLClosed
(2025 days)
S35.1 bzrAnyAnyMulti-DELETE IGNORE does not report warnings  
96802005-04-06
14:49
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(3510 days)
S34.*Linux (redhat)Anywrong error from cascading update  
770342015-05-14
3:52
2018-04-10
16:06
MySQL ServerUnsupported
(659 days)
S2Percona 5.6.23-72.1 R 0503478Linux (Ubuntu 14.04LTS)AnyServer crashes mid constraint-definition, then gets false 'duplicate key' error.  
110212005-06-01
18:09
2008-11-14
16:18
MySQL ServerClosed
(4093 days)
S43.23 to currentMicrosoft Windows (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
(4242 days)
S25.0 & 5.1Any (Any)AnyMySQL does not correctly handle errors on statement commit Konstantin Osipov
396702008-09-26
14:22
2010-05-26
17:59
MySQL Server: Falcon storage engineUnsupported
(3535 days)
S36.0-falcon-team (6.0.8a)AnyAnyError on rename (errno: 121) from ALTER TABLE ADD KEY in concurrent test Christopher Powers
892102018-01-12
15:43
2018-01-13
6:34
MySQL UtilitiesDuplicate
(746 days)
S21.6.5Mac OS XAnymysqldcompare erroneously includes database name differences in SQL output  
910492018-05-28
17:38
2018-06-08
14:02
MySQL ServerNot a Bug
(602 days)
S35.5.38AnyAnydeleting duplicate complains about foreign key Bogdan Kecman
85652005-02-17
11:50
2017-05-07
20:45
MySQL Server: DDLDuplicate
(2756 days)
S25.0.30Any (*)AnyALTER TABLE MODIFY adds duplicate keys which slow down SELECTs Assigned Account
238732006-11-02
4:46
2006-11-02
6:51
MySQL ServerNot a Bug
(4836 days)
S35.0.27Microsoft Windows (Win2003)AnySELECT statement works, but not done as CREATE VIEW AS  
263162007-02-13
12:01
2016-02-11
11:15
MySQL Server: InnoDB storage engineClosed
(3465 days)
S25.0.36-BK, 5.0.32, 5.0.38BK, 5.1.17BKAny (*)AnyTriggers create duplicate entries on auto-increment columns Sunny Bains
326562007-11-23
12:33
2011-02-16
23:43
MySQL Cluster: Cluster (NDB) storage engineClosed
(3780 days)
S15.1AnyAnyNDB: Duplicate key error aborts transaction in handler. Doesn't talk back to SQL Tomas Ulin
443812009-04-21
12:28
2014-01-24
14:29
MySQL Server: Falcon storage engineWon't fix
(2196 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
(3819 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
(646 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
(2127 days)
S26.0Mac OS X (10.8.5)AnyMySQLWorkbench crashes frequently on OSX  
824752016-08-05
13:40
2018-02-03
10:26
MySQL Workbench: SQL EditorVerified
(725 days)
S46.3.10AnyAnyduplicate values in column  
131302005-09-13
6:35
2005-09-13
6:56
MySQL ServerNot a Bug
(5251 days)
S24.1Microsoft Windows (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
(4622 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
(3919 days)
S26.0-maria6.0-betaAnyAnyMaria: RESTORE leads to corrupted table and assertion Guilhem Bichot
548612010-06-28
11:50
2011-02-16
23:44
MySQL Server: Embedded Library ( libmysqld )Closed
(3405 days)
S35.5.6-m35.5+AnyAnyAdditional connections not handled properly in mtr --embedded Alexey Botchkov
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
(64 days)
S35.6.22, 5.5.46, 5.6.26AnyAnyIn consistent behavior between similar UPDATE sqls, error vs warning  
51032004-08-19
0:49
2016-12-04
20:45
MySQL ServerDuplicate
(4648 days)
S44.0.20-standardLinux (Linux)AnyCannot add or update a child row: a foreign key constraint fails Assigned Account
560462010-08-17
9:12
2011-02-16
23:44
MySQL Server: LockingNo Feedback
(3420 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
(1076 days)
S37.xAnyAnyVia a secondary unique index is automatically upgraded to a Shared read lock  
35912004-04-28
16:49
2004-04-28
18:50
MySQL Server: ReplicationNot a Bug
(5754 days)
S24.0.18Linux (redhat 9)AnyReplication sending Errored SQLs to Slave Guilhem Bichot
55202004-09-10
18:33
2004-09-10
20:58
MySQL Server: MyISAM storage engineNot a Bug
(5619 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
(4429 days)
S25.26.0AnyAnyDuplicate key error in NDB references wrong key Martin Skold
239452006-11-03
15:59
2006-11-07
23:44
MySQL Server: Falcon storage engineClosed
(4831 days)
S1AnyAnycrash during drop table, AUTOCOMMIT=0, CREATE TABLE .. AS SELECT Jim Starkey
354872008-03-21
18:14
2008-03-28
14:37
MySQL ServerCan't repeat
(4324 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
(4202 days)
S36.0-bkAnyAnywrong error messages Marc Alff
433072009-03-02
13:25
2011-02-16
23:43
MySQL Server: DocumentationClosed
(3982 days)
S15.1, 6.0AnyAnydefault collation will be ignored Paul Dubois
458852009-07-01
18:26
2010-05-26
17:59
MySQL Server: Falcon storage engineUnsupported
(3535 days)
S36.0.12-bzrAnyAnyPrimary key added to Falcon table allows non-unique values. Christopher Powers
105632005-05-11
17:23
2007-07-03
19:05
Connector / ODBCClosed
(4593 days)
S23.51.11Microsoft Windows (Windows XP SP1)AnyUpdate using multicolumn primary key with duplicate indexes fails Jim Winstead
134732005-09-25
22:49
2006-09-07
0:16
MySQL Server: DocumentationClosed
(4892 days)
S35.0.12* / windowsAnyBefore insert trigger executed, without insert happening Paul Dubois
298452007-07-17
13:10
2011-02-16
23:43
MySQL Server: OptimizerVerified
(4460 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
(3957 days)
S35.1.22rc 5.1.30 GAAny (Linux, Windows)Anyinserts with auto-increment fails Sunny Bains
309432007-09-11
6:43
2007-09-11
6:47
MySQL Server: User-defined functions ( UDF )Not a Bug
(4523 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
(3255 days)
S3mysql-next-mr-wl5136-stage, 5.1AnyAnyUPDATE statement throws an error, but still updates the table entries Jørgen Løland
676372012-11-19
16:44
2013-01-22
13:50
MySQL Server: OptimizerClosed
(2563 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
(1398 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
(1232 days)
S3AnyAnyMultiple UPDATE query separated by 'AND' not detected Syntax Error  
974182019-10-29
15:25
2020-01-28
4:10
MySQL Server: OptimizerClosed
(1 day)
S55.7, 5.7.28AnyAnyMySQL chooses different execution plan in 5.7  
271402007-03-14
16:27
2007-03-15
17:44
MySQL Server: InnoDB storage engineNot a Bug
(4703 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 Heikki Tuuri
407612008-11-15
19:17
2011-02-16
23:43
MySQL Server: DMLClosed
(4018 days)
S25.1.29/5.0/5.1/6.05.0+Microsoft Windows (WinXP (Intel-32)/Linux)AnyLEFT JOIN on inline view crashes server Gleb Shchepa
705152013-10-03
19:01
2014-03-12
1:37
MySQL Workbench: ModelingClosed
(2149 days)
S36.0.7AnyAnyWorkbench cannot handle fractional timestamp  
725262014-05-03
17:47
2018-10-21
20:45
Connector / NETNo Feedback
(1822 days)
S26.8.3AnyAnyFails to generate correct SQL for one-to-one relationships in Entity Framework 6 Assigned Account
974622019-11-03
15:05
2019-11-12
16:37
MySQL Server: OptimizerCan't repeat
(78 days)
S58.0.17FreeBSD (12.0)x86Slow JOIN with ORDER BY due wrong index selection  
72902004-12-14
17:27
2016-01-03
20:45
MySQL Server: InnoDB storage engineOpen
(3548 days)
S44.1.7Solaris (Solaris)Anyupdate should check primary keys after all records altered Assigned Account
580272010-11-06
9:26
2011-02-16
23:44
MySQL WorkbenchNo Feedback
(3339 days)
S3Microsoft Windows (windows 7)AnyMysql Duplicate entry Error to Update A Table  
27542004-02-12
10:24
2004-03-26
11:05
MySQL Server: Command-line ClientsNo Feedback
(5787 days)
S14.0.17Mac OS X (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
(5451 days)
S24.1.9Linux (Debian unstable ('sid'))AnyCan't create foreign keys on TINYTEXT fields Paul Dubois
112282005-06-10
8:40
2011-02-16
23:43
MySQL Server: DocumentationClosed
(3416 days)
S15.0.4-beta-standard-logLinux (Linux)AnyDESC shows arbitrary column as "PRI" Paul Dubois
167002006-01-21
13:13
2006-01-21
13:51
MySQL ServerDuplicate
(5121 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
(5024 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
(4893 days)
S35.0.21-pre AnyTest 'join_outer' fails if "classic" configuration in 5.0 Georgi Kodinov
187452006-04-03
15:20
2006-05-22
18:27
MySQL Server: OptimizerClosed
(5000 days)
S35.0.21-pre AnyTest case 'func_group' fails if "classic" 5.0 configuration Georgi Kodinov
191712006-04-18
18:12
2006-04-20
11:08
MySQL ServerCan't repeat
(5032 days)
S25.1.9-betaSolaris (Solaris 8 Sparc (32))AnyTest "information_schema": Incorrect key file for table './mysql/event' Sergei Glukhov
196572006-05-09
22:03
2006-05-14
7:22
MySQL Server: DocumentationClosed
(5008 days)
S35.0.21/5.1Microsoft Windows (Windows binary distribution)AnyProposition for YaSSL manual part correction Stefan Hinz
203252006-06-07
22:11
2007-03-19
19:18
Connectors: DBD::mysql ( Perl )Closed
(4699 days)
S33.0004Linux (SLES 8)Anyt/41bindparam.t: All parts of a PRIMARY KEY must be NOT NULL Jim Winstead
287662007-05-30
8:25
2007-06-05
15:05
MySQL ServerCan't repeat
(4621 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
(4621 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
(4558 days)
S35.0.46-BK, 5.0.41AnyAnyindex_merge is used instead of (faster!) range Paul Dubois
313732007-10-03
14:42
2007-11-10
23:51
MySQL ServerNo Feedback
(4463 days)
S25.0.27-logLinuxAnyUnusing index in select query  
316722007-10-17
18:21
2016-02-25
12:24
MySQL Server: OptimizerNot a Bug
(4431 days)
S35.0.46AnyAnyEXPLAIN indicates multiple column index used when it is not Martin Hansson
379952008-07-09
15:42
2011-02-16
23:43
MySQL Server: Embedded Library ( libmysqld )Closed
(3827 days)
S35.1.26-rc5.1+AnyAnyError message truncation in test "innodb" in embedded mode Alexey Botchkov
459692009-07-06
12:23
2012-10-08
15:31
MySQL Server: OptimizerClosed
(2669 days)
S35.1.35, 5.1.38-bzr5.5+Microsoft Windows (XP, Vista)Anythe query otimizer choose the wrong index  
549512010-07-02
7:51
2011-07-27
21:32
MySQL Server: DDLClosed
(3108 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
(2583 days)
S35.2.44Microsoft Windows (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
(2473 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
(2354 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
(687 days)
S35.7.21-0ubuntu0.16.04.1Microsoft Windows (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
(429 days)
S38.0.13Microsoft Windows (Microsoft Windows 10 Pro)Anyforeign key referencing 2 columns does not show up in schemas  
163242006-01-10
6:02
2019-10-28
22:42
MySQL Server: DMLClosed
(93 days)
S45.0.12Microsoft Windows (windows & linux)Anyauto_increment primary key can be updated,and then insert record fail  
112872005-06-13
12:58
2005-07-21
14:30
MySQL ServerNo Feedback
(5305 days)
S35.0.6Linux (CentOS4)AnyErrors in stored procedure (ERROR 1418, ERROR 2013)  
113052005-06-14
7:05
2005-06-16
17:00
MySQL Server: InnoDB storage engineClosed
(5340 days)
S34.0.16Microsoft Windows (Windows 2000)AnyOn Update Cascade not working with two references to the same field Heikki Tuuri
450552009-05-24
17:25
2011-02-16
23:44
MySQL Server: ErrorsClosed
(3902 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
(1197 days)
S35.6AnyAnyManual does not explain locks set by UPDATE properly Daniel Price
937872019-01-02
18:07
2019-01-02
18:12
Connector / ODBCOpen
(392 days)
S35.3.9, 5.3.11, 8.0.13Microsoft Windows (Server 2012 R2)Other (x64)Auto-inc primary key field changes to 0 on update with ODBC > 5.3.4  
210592006-07-14
13:10
2006-08-17
8:51
MySQL Cluster: Cluster (NDB) storage engineClosed
(4913 days)
S15.1.11, 5.0.19Linux (Linux)AnyServer crashes on join query with large dataset with NDB tables Martin Skold
264802007-02-19
17:31
2007-04-12
14:20
MySQL Server: InnoDB storage engineNot a Bug
(4675 days)
S25.0Microsoft Windows (Windows XP)Anyon update cascade crashes when a foreign key belongs to the primary key  
42242004-06-20
13:40
2004-06-21
16:07
MySQL Server: DocumentationClosed
(5700 days)
S3 AnyGerman documentation misses INSERT ON DUPLICATE KEY-syntax Stefan Hinz
121582005-07-25
17:32
2005-07-25
17:52
MySQL ServerCan't repeat
(5301 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
(5074 days)
S35.1.2-alpha-debugLinux (SUSE 10.0)AnyPartitions: crash, if Insert .. on duplicate key causes update of existing row Sergey Vlasenko
196562006-05-09
21:55
2006-05-23
14:43
MySQL Server: DocumentationClosed
(4999 days)
S35.1.11 AnyMySQL Error log flooded with [ERROR] NDB Binlog: Duplicate key on write or upda Jon Stephens
244402006-11-20
15:06
2006-11-21
9:57
Connector / NETClosed
(4817 days)
S3Connctr./NET 1.0.7Microsoft Windows (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
(4743 days)
S35.0.27, 5.1 BKLinux (Linux, Windows)Anyusing alias from source table in insert..on duplicate key Dmitry Lenev
251232006-12-17
19:28
2007-02-08
18:40
MySQL Server: ViewsClosed
(4738 days)
S35.0.30/5.1BKFreeBSD (freebsd)Anyinsert into view on dup key, allows cross table reference Evgeny Potemkin
263422007-02-13
20:23
2007-06-19
12:37
MySQL Cluster: Cluster (NDB) storage engineClosed
(4607 days)
S25.0.38 | mysql-5.1-telcoLinux (CentOS 4.4 | Fedora)Anyauto_increment_increment AND auto_increment_offset REALLY REALLY anger NDB clust Martin Skold
319712007-10-30
23:08
2019-10-29
22:33
MySQL Server: DMLCan't repeat
(92 days)
S35.0.51 and 5.0.45Any (Debian, FreeBSD)Anylast_insert_id with on duplicate key still broken Evgeny Potemkin
337362008-01-08
9:53
2008-01-14
6:51
MySQL Server: GeneralClosed
(4398 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
(4145 days)
S35.1+AnyAnyVarious partition errors have changed output - need to update test results Assigned Account
456772009-06-23
13:08
2011-02-16
23:44
MySQL Server: ReplicationClosed
(3373 days)
S25.1.35 and 5.4.05.1+AnyAnySlave stops with Duplicate entry for key PRIMARY when using trigger Daogang Qu
520202010-03-12
21:49
2017-12-22
8:24
MySQL Server: InnoDB storage engineClosed
(2947 days)
S35.0, 5.1.465.1+AnyAnyInnoDB can still deadlock on just INSERT...ON DUPLICATE KEY Marko Mäkelä
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
(2710 days)
S25.5.28AnyAnyInsert into federated table  
906882018-04-30
10:37
2019-05-22
18:37
Connector / JVerified
(636 days)
S38.0.11AnyAnyStatement.getGeneratedKeys() returns too many rows on INSERT .. ON DUPLICATE KEY  
692432013-05-15
11:56
2019-08-14
19:58
MySQL Server: FULLTEXT searchNo Feedback
(2414 days)
S25.6.11Microsoft WindowsAnyCan't update InnoDB table with fulltext index defined  
698722013-07-30
15:53
2013-07-30
16:54
MySQL Server: Stored RoutinesDuplicate
(2374 days)
S35.6AnyAnyUPDATE in stored function is not rolled back  
213012006-07-26
16:22
2006-08-26
23:34
MySQL ServerNo Feedback
(4904 days)
S24.1.15Linux (RedHat/Fedora Core)AnySQL Error updating table when primary key contains multiple columns  
67092004-11-18
22:28
2005-10-04
10:06
MySQL ServerCan't repeat
(5230 days)
S35.0.2-alpha-debugLinux (SuSE 8.2)AnySubquery: table subquery allows duplicate column names Oleksandr Byelkin
155752005-12-08
8:54
2005-12-09
5:10
EventumClosed
(5164 days)
S2 AnySearching for issues when creating a duplicate entry Bryan Alsdorf
206362006-06-22
20:58
2006-06-22
22:55
MySQL Workbench PreviewDuplicate
(4969 days)
S21.0.6 BetaMicrosoft Windows (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
(4765 days)
S35.0,5.1 Anycan get duplicate log messages in cluster log Stewart Smith
275752007-04-01
20:23
2009-05-26
11:53
MySQL AdministratorUnsupported
(3900 days)
S35.0r11Mac OS X (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
(4373 days)
S15.1.22 rcAnyAnyDUPLICATE of WHAT!!! RE bug 34420  
350872008-03-05
17:54
2011-02-16
23:43
MySQL Server: GeneralClosed
(3914 days)
S25.0.50+5.0+AnyAnyInserting duplicate values at one time with DES_ENCRYPT leads to wrong results Georgi Kodinov
368272008-05-20
18:57
2008-11-22
9:34
Connectors: DBD::mysql ( Perl )No Feedback
(4085 days)
S24.007Mac OS X (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
(3345 days)
S35.0.67HP/UX (B.11.11 on PA-RISC)AnyHP-UX packages contain duplicate files instead of symlinks Karen Langford
474162009-09-17
14:19
2011-02-16
23:44
MySQL Server: Embedded Library ( libmysqld )Closed
(3501 days)
S26.0.14-alpha, mysql-pe5.1+Mac OS X (10.6)AnyBuild failure on OS X 10.6: duplicate symbol _timed_mutexes Georgi Kodinov
514512010-02-24
9:57
2012-05-18
20:19
MySQL Server: DDLDuplicate
(3564 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
(3215 days)
S4AnyAnyAdd rule to detect duplicate foreign keys  
697322013-07-12
14:29
2017-10-09
8:42
MySQL Server: OptimizerNot a Bug
(2392 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
(1794 days)
S35.5.40Mac OS X (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
(1360 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
(1123 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
(933 days)
S35.7CentOSAnyDupllicate Entry in Slave Bogdan Kecman
873532017-08-09
8:30
2017-08-09
9:39
MySQL Cluster: Cluster (NDB) storage engineVerified
(903 days)
S37.5.7AnyAny"ndb_restore --print-data" and "ndb_restore --print-sql-log" have duplicate row  
21592003-12-18
11:10
2004-01-15
12:33
MySQL ServerClosed
(5858 days)
S1v4.0.15-standardLinux (Linux/Windows)AnyUPDATE of LONGBLOB >= 16Megs corrupts table Sinisa Milivojevic
23772004-01-13
11:49
2004-02-03
7:51
MySQL Server: MyISAM storage engineClosed
(5839 days)
S14.0.16Linux (Linux)AnyUPDATE privilege BUG Sinisa Milivojevic
51652004-08-23
11:19
2004-08-23
16:38
MySQL Server: InnoDB storage engineWon't fix
(5637 days)
S24Any (All)AnySELECT ... FOR UPDATE uses 'select' privelege instead 'update'  
150282005-11-17
17:21
2005-12-08
23:53
MySQL ServerClosed
(5165 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 Evgeny Potemkin
196082006-05-08
13:50
2006-05-08
14:09
MySQL ServerNot a Bug
(5014 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
(4381 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
(4269 days)
S25.0.585.0+AnyAnyUPDATE on TEXT column using LEFT JOIN doesn't update all rows Gleb Shchepa
396952008-09-27
15:14
2008-12-13
9:03
MySQL Server: Falcon storage engineClosed
(4064 days)
S16.0-falcon-team (6.0.8a)6.0.8LinuxAnyCrash in SRLUpdateRecords::thaw during falcon_chill_thaw test Christopher Powers
565652010-09-05
10:08
2010-09-06
20:50
MySQL Server: DMLNot a Bug
(3432 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
(2025 days)
S35.5.30 and 5.6.10, 5.1.70, 5.5.32, 5.6.12Microsoft WindowsAnyUpdate trigger invoked when update ignore means that no update is performed  
836592016-11-02
20:47
2016-11-08
16:34
MySQL Server: ReplicationUnsupported
(1177 days)
S3Percona-XtraDB-Cluster-5.5.39-25.11LinuxAnyReplication Statements Missing From Binary Logs Bogdan Kecman
2602003-04-09
10:57
2003-06-19
6:54
Connector / ODBCClosed
(6068 days)
S33.51 AnyParsing the key columns while generating cursor based updates/deletes query Venu Anuganti
25352004-01-27
11:56
2004-01-27
12:48
MySQL Server: InnoDB storage engineWon't fix
(5846 days)
S34.0.17Linux (Linux Intel)AnyForeign Keys on InnoDB tables not honoured. Heikki Tuuri
281032007-04-25
19:34
2007-04-27
14:25
MySQL Query BrowserClosed
(4660 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
(2934 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 GPLMicrosoft Windows (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
(1353 days)
S36.3.6Microsoft Windows (Microsoft Windows 10 Pro)AnyForard Engineered DB Script for table with virtual field has syntax error  
683022013-02-07
13:47
2013-12-31
11:14
MySQL Server: InnoDB storage engineCan't repeat
(2220 days)
S15.5.32LinuxAnyMySQL crashed when trying to free page that is already marked as free  
17212003-10-31
0:17
2012-05-18
20:19
MySQL Server: MyISAM storage engineNo Feedback
(5819 days)
S24.0.16Linux (Linux SuSE 8.2)AnyFalse duplicate key warnings on FULLTEXT columns Assigned Account
18242003-11-12
20:59
2003-12-10
9:11
MySQL Server: ReplicationClosed
(5894 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
(5365 days)
S14.1.1 (01 Dec 2003)Linux (GNU/Linux)AnyError "Duplicate entry ... for key ..." where not expected Sergei Golubchik
60752004-10-13
22:19
2004-11-19
17:34
MySQL ServerNo Feedback
(5549 days)
S24.0.20a-ntMicrosoft Windows (Windows)AnyBogus Duplicate Key Error  
78362005-01-12
14:24
2005-02-13
20:15
MySQL Server: ReplicationNot a Bug
(5463 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
(5236 days)
S24.1.13Linux (Linux(Redhat9.0))AnyDuplicate entry 'xxxxx for key 1 Sergei Golubchik
145202005-10-31
20:31
2005-12-16
17:51
MySQL ServerNo Feedback
(5157 days)
S24.1.11Microsoft Windows (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
(5164 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
(5101 days)
S1MySQL 5.0.18-standardMac OS X (OSX 10.4, RedHat 4)AnyDuplicate Key error without keys being identical Evgeny Potemkin
185522006-03-27
18:55
2012-05-18
20:19
MySQL Server: PartitionsDuplicate
(5042 days)
S25.1 AnyPartitions: SP with cursor, autoincrement PK, duplicate key on insert Sergei Glukhov
231902006-10-11
21:36
2006-11-12
5:18
MySQL Workbench PreviewNo Feedback
(4826 days)
S21.1.3 alphaMicrosoft Windows (WinXP)Anyduplicate foreign keys  
253262006-12-29
9:19
2007-03-12
15:18
MySQL Server: ReplicationNo Feedback
(4706 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
(4485 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
(4576 days)
S35.0.27-community-ntMicrosoft Windows (XP SP2 fully updated)AnyDuplicate key problem  
309072007-09-07
17:18
2011-02-16
23:43
MySQL Server: InnoDB storage engineClosed
(3512 days)
S25.1.22AnyAnyRegression: "--innodb_autoinc_lock_mode=0" (off) not same as older releases Sunny Bains
338242008-01-11
17:56
2008-02-11
21:00
MySQL Server: Falcon storage engineCan't repeat
(4370 days)
S16.0.4-p3AnyAnyManipulations on a view and on the underlying table cause duplicate primary key Hakan Küçükyılmaz
374482008-06-17
14:43
2008-06-19
18:21
MySQL ServerNot a Bug
(4241 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
(3957 days)
S75.15.1+AnyAnyrpl.rpl_stm_mystery22 fails sporadically on pushbuild Serge Kozlov
411862008-12-02
19:54
2018-09-25
21:50
Tests: ReplicationDuplicate
(4044 days)
S76.0-rpl, 5.15.1+AnyAnyrpl_stm_mystery22 fails sporadically on pushbuild while waiting for slave start Assigned Account
433062009-03-02
13:16
2012-05-18
20:19
MySQL Server: CharsetsDuplicate
(3975 days)
S15.1, 6.0AnyAnyWrong utf8 collation default behaviour  
493492009-12-02
13:29
2018-11-04
20:45
MySQL Server: OptimizerDuplicate
(2592 days)
S36.0AnyAnyWrong cost calculation for duplicate weed-out Assigned Account
559192010-08-11
17:12
2010-08-11
18:16
MySQL ServerNot a Bug
(3458 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
(2554 days)
S25.6.99-m5AnyAnyBlackhole slave replication: 2nd slave stops for two REPLACE statements Jon Stephens
613712011-06-01
10:26
2011-06-02
12:16
MySQL Server: DMLNot a Bug
(3163 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
(2805 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
(1556 days)
S35.7.8AnyAnyFailed INSERT(Dup entry) still change LAST_INSERT_ID() for auto_increment col  
18902003-11-19
11:09
2003-12-10
5:37
MySQL Server: Embedded Library ( libmysqld )Closed
(5894 days)
S14.0.17Microsoft Windows (Windows 2000/XP)Anytable handler and corruption bugs on multithread application Alexey Botchkov
292512007-06-20
21:32
2007-07-11
22:27
MySQL ServerClosed
(4585 days)
S25.0.42, 5.1, 4.1Linux (Gentoo)AnyMySQL coerces special 0 enum values to '' when ALTERing the column Gleb Shchepa
477742009-10-01
21:55
2011-02-16
23:44
MySQL Server: PartitionsClosed
(3730 days)
S35.5 WL#33525.5+AnyAnyInnoDB: Assertion failure in thread 1769970576 in file row/row0mysql.c line 1355 Mikael Ronström
685682013-03-05
3:17
2017-12-22
15:28
MySQL Server: ReplicationVerified
(2267 days)
S35.6.10Linux (CentOS 5.8 X64)AnyStop Slave statement will timeout not waiting the event group complete  
965782019-08-16
22:08
2019-11-26
19:31
MySQL Server: DMLClosed
(64 days)
S28.0.16, 5.7.27, 8.0.17AnyAny`Insert on duplicate key update` updates the wrong row  
132262005-09-15
15:18
2005-10-18
10:14
MySQL ServerNo Feedback
(5216 days)
S24.1.11Microsoft Windows (WinXP SP2)AnyAUTO_INCREMENT attempting to insert zero value  
134312005-09-23
15:21
2014-01-16
2:56
MySQL Server: InnoDB storage engineClosed
(2204 days)
S35.0Linux (Linux)AnyDuplicate FOREIGN KEY error does not make sense Heikki Tuuri
162222006-01-05
13:21
2006-01-09
0:31
MySQL ServerNot a Bug
(5133 days)
S34.0.22Linux (Linux)AnySelect on truncated keys  
95122005-03-31
2:29
2005-04-04
5:30
MySQL Server: InnoDB storage engineNot a Bug
(5413 days)
S34.1.10aAny (All)AnySELECT FOR UPDATE returns phantom rows  
256202007-01-15
6:54
2018-09-09
20:45
MySQL Server: DMLVerified
(4438 days)
S35.0.33Microsoft Windows (Windows Server 2003 Web Edition)AnyError in ADDTIME function when update more 35 days Evgeny Potemkin
364702008-05-02
12:12
2012-05-18
20:19
Connector / ODBCDuplicate
(4117 days)
S35.1AnyAnyODBC update boolean wrong in MySQL ODBC 5.1, correct in MySQL ODBC 3.51 Assigned Account
548632010-06-28
16:38
2011-02-16
23:44
Connector / NETClosed
(3487 days)
S26.2.3Microsoft WindowsAnyBug in MySqlDataAdapter update method Tony Bedford
672612012-10-16
10:36
2015-08-10
14:34
MySQL Server: mysqldump Command-line ClientDuplicate
(2644 days)
S35.6.7-rcMicrosoft Windows (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
(2237 days)
S16.7.4Microsoft Windows (7 x64)AnyNullReferenceException when try to save entity with TINYINT or BIGINT as PK Fernando Gonzalez.Sanchez
763522015-03-17
14:51
2015-04-08
16:29
MySQL ServerNot a Bug
(1757 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
(1772 days)
S25.6.22LinuxAnyTrigger behaving wrongly mysql  
825922016-08-16
3:55
2016-09-02
13:11
MySQL Server: InnoDB storage engineNot a Bug
(1254 days)
S35.7.14AnyAnyMySQL InnoDB update locking  
157622005-12-14
23:34
2006-06-18
21:25
MySQL ServerNo Feedback
(4973 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
(4864 days)
S35.0.23-bkAny (Any)AnyUPDATE using key and invoking trigger that modifies this key does not stop Dmitry Lenev
246682006-11-28
19:02
2016-01-03
20:45
MySQL Server: InnoDB storage engineVerified
(3548 days)
S45.0.32-BK, 5.0.27TBDLinux (Linux, Windows XPsp2)AnyCASCADING FOREIGN KEYS do not work on same TABLE Assigned Account
509172010-02-04
15:23
2012-05-18
20:19
MySQL Server: ReplicationVerified
(3344 days)
S35.1.43,5.5.2-m25.1+AnyAnyslave stops with HA_ERR_KEY_NOT_FOUND Assigned Account
509272010-02-04
19:29
2011-02-16
23:44
MySQL Enterprise Monitor: ServerClosed
(3621 days)
S32.1.0.1096AnyAnyDelete server fails on foreign key error to rule_schedules table Mark Matthews
577332010-10-26
9:43
2011-02-16
23:44
MySQL Workbench: ModelingVerified
(3380 days)
S4ALLAnyAnyDuring data insert/update show foreign key values  
501022010-01-06
12:52
2010-01-06
15:15
MySQL Server: InnoDB storage engineNot a Bug
(3675 days)
S35.1.37AnyAnyAUTO_INCREMENT increases when using UPDATE ON DUPLICATE  
688892013-04-08
20:27
2013-09-11
17:18
Connector / NETClosed
(2331 days)
S1Net Connector 6.6.5AnyAnyEF 4.3.1 Code First Migration Tries to Migrate Already Migrated Database Roberto Ezequiel Garcia Ballesteros
35512004-04-23
10:54
2004-04-28
12:10
MySQL ServerCan't repeat
(5754 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
(5460 days)
S34.0.18-standardLinux (Linux 2.4.22 (Mandrake 9))AnyPoor query plan with merge tables Sergei Golubchik
126622005-08-19
2:20
2005-08-19
2:41
MySQL ServerDuplicate
(5276 days)
S25.0.9FreeBSD (FreeBSD 5.4)AnyPoor View Performance  
132182005-09-15
10:25
2005-09-24
3:51
MySQL Server: OptimizerClosed
(5240 days)
S34.1.14-nt, 4.1.15-BKMicrosoft Windows (Windows XP, Linux)Anyselect MIN(..) / InnoDB: using a partial-field key prefix in search Evgeny Potemkin
167362006-01-23
22:44
2006-03-16
9:38
MySQL Server: DocumentationClosed
(5067 days)
S25.1.6-alphaLinux (Linux)AnyImplicit partitioning key not displayed. Jon Stephens
175902006-02-20
17:44
2006-02-23
9:32
MySQL Server: OptimizerCan't repeat
(5088 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
(4923 days)
S25.1Linux (Linux)AnyUnicode quoted foreign key references are broken Marko Mäkelä
192132006-04-20
9:16
2006-05-20
16:30
MySQL ServerNo Feedback
(5002 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
(5021 days)
S25.xMicrosoft Windows (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
(4478 days)
S25.0.21AnyAnyYaSSL: is passphrase removing optional for keys? Paul Dubois
202982006-06-06
16:27
2006-06-11
4:40
MySQL ServerNot a Bug
(4980 days)
S15.0.22Mac OS X (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
(4732 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 Sergei Glukhov
327352007-11-26
19:40
2011-02-16
23:43
MySQL Cluster: Cluster (NDB) storage engineWon't fix
(3445 days)
S3mysql-5.0CGEMac OS X (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
(4221 days)
S25.1.23AnyAnyQuery crashed mysqld Frazer Clement
413322008-12-09
16:01
2015-08-23
20:45
MySQL Cluster: Cluster (NDB) storage engineDuplicate
(4034 days)
S1Cluster 6.3.20AnyAnyInsert into partitioned "ndbcluster" table causes server crash Assigned Account
440572009-04-02
22:28
2011-02-16
23:43
MySQL Server: InnoDB storage engineNo Feedback
(3920 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
(3869 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
(3610 days)
S15.1.39, 5.1.415.1.41+AnyAnyWrong results when index is used Ramil Kalimullin
513782010-02-22
9:57
2011-02-16
23:44
MySQL Server: InnoDB Plugin storage engineClosed
(3480 days)
S35.1+AnyAnyInit "ref_length" to correct value, in case an out of bound MySQL primary_key Jimmy Yang
585242010-11-26
17:19
2013-03-03
20:45
MySQL Server: MyISAM storage engineVerified
(3347 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
(2478 days)
S3MySQL 5.5Microsoft WindowsAnyPrimary Key - NULL Paradox  
700132013-08-13
11:29
2013-08-13
12:54
MySQL ServerDuplicate
(2360 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
(2021 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
(1229 days)
S16.3.7Mac OS XAnyMySQL WorkBench alter table window miss primary key  
832982016-10-07
9:52
2016-10-20
12:50
MySQL Server: OptimizerDuplicate
(1196 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
(159 days)
S35.7.20Microsoft Windows (Windows 10)AnyWeb community Installer fails to install MySQL Server 5.7.20  
923922018-09-12
20:53
2019-12-04
17:40
MySQL Server: InstallingNo Feedback
(384 days)
S18.0.12Microsoft Windows (Windows 10 Pro 64 bit)AnyThe action 'Install' for product 'MySQL Server 8.0.12' failed  
938452019-01-07
21:55
2019-09-03
12:52
MySQL Server: OptimizerVerified
(385 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
(129 days)
S38.0AnyAnyMySQL optimizer wrongly chooses to use a bigger and inefficient index for query  
55532004-09-13
22:31
2004-09-23
9:59
MySQL ServerClosed
(5606 days)
S24.1.4Linux (Linux 2.4.20 debian)AnyUPDATE IGNORE with multiple tables can lock up mysqld connection,reproducable Antony Curtis
96792005-04-06
14:38
2016-01-03
20:45
MySQL Server: InnoDB storage engineOpen
(3548 days)
S44.*Any (any)Anyerrors in cascaded updates Assigned Account
309222007-09-10
6:02
2008-09-04
18:49
MySQL Enterprise Monitor: ServerClosed
(4164 days)
S31.2.0.7481AnyAnyConstraint Violation Exception when starting several replication agents at once Darren Oldag
388392008-08-18
3:08
2012-05-09
23:37
MySQL Server: InnoDB storage engineNot a Bug
(3547 days)
S45.1.25-rc, 5.1.26-rcAnyAnyauto increment does not work properly with InnoDB after update Sunny Bains
183092006-03-17
14:14
2012-05-18
20:19
MySQL Server: Stored RoutinesDuplicate
(4731 days)
S35.0.19, 5.1.7. 5.1.8Linux (Linux)AnyBEFORE UPDATE TRIGGERS on BLACKHOLE tables raise an error but work as expected Assigned Account
274432007-03-26
14:03
2007-03-26
14:33
MySQL Server: Stored RoutinesNot a Bug
(4692 days)
S25Microsoft Windows (windows)Anynot able to create update trigger  
724122014-04-21
15:42
2014-04-21
16:52
MySQL ServerNot a Bug
(2109 days)
S16.1.4Microsoft Windows (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
(1799 days)
S35.6AnyAnydifferent plan when executing query using procedure  
784122015-09-11
16:17
2017-01-13
9:03
MySQL Server: DocumentationClosed
(1510 days)
S25.6.24AnyAnyUPDATE with subquery is NOT optimized the same way as equivalent SELECT Paul Dubois
978372019-12-01
5:01
2019-12-03
14:11
MySQL Server: InnoDB storage engineCan't repeat
(57 days)
S65.7.27CentOS (CentOS 7.4)x86 (8Uxeon 16G memoy)An assertion failure occurs when multiple threads update a record concurrently  
264712007-02-18
13:55
2007-02-19
9:25
MySQL Workbench PreviewWon't fix
(4727 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
(4125 days)
S35.0.24AnyAnyRemove a table referenced in foreing key constraint Sergei Tkachenko
418442009-01-03
20:16
2012-05-18
20:19
MySQL Server: GeneralDuplicate
(3998 days)
S36.1.0-alphaLinux (SUSE 10.0 / 32-bit)AnyForeign keys: failure with varbinary update cascade Dmitry Lenev
452792009-06-02
21:59
2011-02-16
23:44
MySQL Server: InnoDB storage engineNo Feedback
(3862 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  
275042007-03-28
19:34
2007-03-29
22:15
MySQL Server: GeneralDuplicate
(4689 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
(4658 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
(4483 days)
S35.0.38LinuxAnyINSERT SELECT - ON DUPLICATE KEY UPDATE  
372062008-06-04
21:08
2008-06-04
21:45
MySQL ServerNot a Bug
(4256 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
(3911 days)
S26.0.9-alpha,6.0.10-alpha6.0.11AnyAnyfalcon.falcon_bug_22211 fails due to seeing duplicate entry Olav Sandstå
191382006-04-17
12:52
2007-05-03
6:02
MySQL Server: Memory storage engineDuplicate
(4654 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
(4219 days)
S25.1.6Microsoft Windows (Server 2003)AnyPrepared statements byte/tinyint causes data corruption.  
380432008-07-11
10:50
2008-09-30
20:36
MySQL Server: Falcon storage engineClosed
(4138 days)
S16.0-falcon6.0.7AnyAnyDeadlock between server and falcon when executing concurrent ALTER + DML Christopher Powers
407882008-11-17
15:21
2011-02-16
23:43
MySQL ServerDuplicate
(4051 days)
S26.0.2Microsoft WindowsAnyTransaction didn't work  
435192009-03-09
23:32
2013-12-20
6:52
MySQL Server: GeneralWon't fix
(2231 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
(3800 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
(3691 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
(2400 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
(2665 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
(637 days)
S3mysql-5.7AnyAnyImproper Record lock With Primary Key. where key >= or <= N  
27992004-02-14
16:18
2004-02-19
11:35
MySQL Server: InnoDB storage engineClosed
(5823 days)
S24.0.18Microsoft Windows (Win NT)AnyMulti-table DELETE and Foreign Key (bad affected rows) Sinisa Milivojevic
194952006-05-02
21:39
2012-05-18
20:19
MySQL Server: PartitionsDuplicate
(5012 days)
S25.1.10Linux (Linux 32 Bit OS)Anydefault-storeage-engine=ndb causes tables by other engines to be partitioned Mikael Ronström
416952008-12-23
0:29
2011-02-16
23:43
MySQL Server: GeneralClosed
(4019 days)
S36.1.0-alpha-debugLinux (SUSE 10.0 / 32-bit)AnyForeign keys: non-distinct value change Dmitry Lenev
464892009-07-31
11:39
2013-12-20
7:04
MySQL Server: DDLWon't fix
(2231 days)
S36.1-fk-stageAnyAnyForeign keys: MERGE engine should be disallowed. Dmitry Lenev
560082010-08-16
10:59
2011-02-16
23:44
MySQL ServerNo Feedback
(3422 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
(2480 days)
S25.6.10Microsoft Windows (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
(1895 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
(1836 days)
S37.47.4AnyAnyModify SHOW CREATE TABLE output for better OpenStack integration Thomas Nielsen
4812003-05-22
21:57
2003-06-23
8:11
MySQL Server: ReplicationNo Feedback
(6064 days)
S1Linux (Linux)Anyerror 'Duplicate entry '  
9052003-07-24
1:40
2003-08-24
4:45
MySQL Server: ReplicationNo Feedback
(6002 days)
S24.0.14Linux (Linux/SuSE)AnyREPLICATION SETUP PROBLEM  
26182004-02-02
16:30
2004-02-03
8:15
MySQL Server: MyISAM storage engineCan't repeat
(5839 days)
S24.0.17Linux (Linux)AnyDuplicate entry error for mediumtext index  
30992004-03-07
13:32
2005-04-11
18:37
Connector / ODBCNot a Bug
(5406 days)
S23.51.06Microsoft Windows (Win2000)AnyInsert occuring on PHP->odbc_prepare prior to PHP->odbc_execute Peter Harvey
33622004-04-01
12:40
2004-04-05
2:24
MySQL ServerNot a Bug
(5777 days)
S24.1 AnyCrash on attempt to insert a record with duplicate primary key value  
35492004-04-23
7:07
2004-05-25
23:40
MySQL Server: MyISAM storage engineNo Feedback
(5727 days)
S2Ver 14.3 Distrib 4.1.1-alphaLinux (Slackware 9.1)AnyFast INSERT causes errors  
35592004-04-25
21:53
2004-05-15
12:44
MySQL Server: ReplicationClosed
(5737 days)
S24.0.18-logLinux (Redhat linux 9)AnyReplication crash when slave under high load Heikki Tuuri
47752004-07-27
20:09
2004-09-23
9:13
MySQL Cluster: Cluster (NDB) storage engineClosed
(5606 days)
S24.1 bkLinux (RH73)AnyDuplicate key requires rollback of transaction Magnus Blåudd
53122004-08-31
9:08
2014-03-13
13:33
MySQL Cluster: Cluster (NDB) storage engineWon't fix
(5551 days)
S3AnyAnyNdb Cluster returns wrong error code for duplicate key at insert Assigned Account
86522005-02-21
16:28
2010-05-12
5:07
MySQL Server: OptimizerNot a Bug
(5348 days)
S34.1.10AnyAnygroup by part of rand() returns duplicate key error  
86752005-02-22
10:59
2005-02-22
20:02
MySQL ServerDuplicate
(5454 days)
S34.1.10Any (*)AnyINSERT INTO tbl (col,...) SELECT (...) ON DUPLICATE KEY doesn't work properly  
98132005-04-11
12:15
2005-05-09
11:50
MySQL ServerClosed
(5378 days)
S15.0.4-betavarious Unix, only 64 bitAnyTest 'ndb_basic': Autoincrement fails in 64 bit ? Martin Skold
99292005-04-15
13:50
2005-05-20
22:26
MySQL Server: ReplicationNo Feedback
(5367 days)
S1MySQL 4.0.24Linux (debian kernel 2.4.27)AnyError 'Duplicate entry '53' for key 1'  
104702005-05-09
11:31
2005-05-09
11:37
MySQL Server: InnoDB storage engineDuplicate
(5378 days)
S35.0.5 BetaMicrosoft Windows (Windows 2003)AnyDuplicate/conflicting foreign key constraint can be added using alter table.  
106802005-05-17
0:24
2005-12-05
18:21
MySQL Server: DocumentationClosed
(5168 days)
S24.1.10 and 4.1.11FreeBSD (Freebsd4.10)AnyIncorrect docs about space-padding in TEXT field sorting order Paul Dubois
123392005-08-03
8:17
2005-08-04
9:08
MySQL ServerClosed
(5291 days)
S35.0.10a (Innodb)Microsoft Windows (Win XP)Anyinsert ... select ... produces duplicate key.  
136932005-10-02
17:36
2005-11-03
7:06
MySQL ServerNo Feedback
(5200 days)
S25.0.12-beta-ntMicrosoft Windows (Windows XP - SP1)AnyDuplicate entry 'wél' for key 1  
148082005-11-09
23:20
2005-11-09
23:56
MySQL ServerCan't repeat
(5194 days)
S15.0.15Linux (Red Hat ES 3)AnyINSERT DELAYED server crash Miguel Solorzano
163802006-01-11
17:54
2015-03-15
20:45
MySQL Server: ReplicationNo Feedback
(4521 days)
S25.0.17Linux (Linux 2.6.14)AnyDuplicate key problem with master <-> master replication and auto_increment Assigned Account
176842006-02-24
1:05
2006-05-06
16:19
MySQL ServerNo Feedback
(5016 days)
S15.0.18Linux (Linux RHE 4)AnyReplication Breaks due to Duplicate Key of ID 0  
179852006-03-06
19:44
2007-05-08
17:39
MySQL ServerNot a Bug
(4649 days)
S15.0.18Linux (linux debian)Anydifferent characters treated as same cause duplicate key error  
219192006-08-30
8:23
2015-03-22
20:45
MySQL Server: ErrorsDuplicate
(4482 days)
S45.1-bkAny (all)AnySegmentation fault when reporting ER_DUP_ENTRY Assigned Account
221612006-09-09
9:16
2006-11-04
17:24
MySQL Server: Falcon storage engineClosed
(4834 days)
S35.2Linux (Linux 32-bit)AnyDuplicate key error with non-unique index after alter Kevin Lewis
235202006-10-20
23:28
2016-02-25
12:24
MySQL Cluster: Cluster (NDB) storage engineWon't fix
(4839 days)
S25.1.11Linux (Linux)AnyDuplicate key error on INSERT with SBR with null for AUTO_INCREMENT column  
249852006-12-12
0:21
2007-04-05
19:42
MySQL Server: Memory storage engineClosed
(4682 days)
S35.0.27/4.1BK/5.0BK/5.1BKMicrosoft Windows (Windows 2K/Linux)AnyUTF8 ENUM primary key on MEMORY using BTREE causes incorrect duplicate entries Ingo Strüwing
255072007-01-09
22:46
2011-02-16
23:43
MySQL Server: ReplicationClosed
(3509 days)
S24.1-bk,5.0.34Any (*)Anymulti-row insert delayed + auto increment causes duplicate key entries on slave Guilhem Bichot
257932007-01-23
17:55
2012-05-18
20:19
MySQL Cluster: Cluster (NDB) storage engineDuplicate
(4534 days)
S35.1.14betaFreeBSD (FreeBSD 6.1)AnyNdb Cluster returns wrong error code for duplicate key at insert Assigned Account
261162007-02-06
14:23
2011-02-16
23:43
MySQL Server: ReplicationClosed
(3509 days)
S34.0,4.1,5.0,5.1Linux (linux)AnyIf multi-row INSERT DELAYED has errors, statement-based binlogging breaks Guilhem Bichot
283092007-05-08
16:49
2007-06-15
9:20
MySQL Server: Embedded Library ( libmysqld )Closed
(4611 days)
S15.1.17Mac OS XAnyFirst insert violates unique constraint - was "memory" table empty ? Alexey Botchkov
291512007-06-15
22:10
2009-05-15
14:14
MySQL Server: Falcon storage engineClosed
(3911 days)
S16.0.4AnyAnyFalcon: running sysbench 0.4.8 leads to duplicate key errors Hakan Küçükyılmaz
336042007-12-31
22:26
2008-01-02
20:54
MySQL Server: InnoDB storage engineNot a Bug
(4410 days)
S25.0.45Microsoft Windows (vista)Anyduplicate key entry error for value that ends with 0x20 Heikki Tuuri
360652008-04-14
17:08
2012-05-18
20:19
MySQL Server: MyISAM storage engineDuplicate
(4290 days)
S36.0-falcon-teamAnyAnyMyISAM: duplicate key error on unique values Assigned Account
405052008-11-04
16:09
2011-02-16
23:43
MySQL Server: GeneralVerified
(4086 days)
S4AnyAnyINSERT DELAYED and transactions, duplicate keys  
424462009-01-29
12:57
2011-02-16
23:43
MySQL WorkbenchNo Feedback
(3985 days)
S35.0.29Microsoft WindowsAnyDuplicate column  
430022009-02-19
7:39
2013-07-04
13:10
MySQL Server: Maria storage engineWon't fix
(2400 days)
S36.0-TRUNKAnyAnymaria.maria_notembedded fails sporadically  
469092009-08-25
5:31
2015-08-23
20:45
MySQL Server: PartitionsDuplicate
(3799 days)
S25.1.37, 5.1.39-debugAnyAnypartitioned innodb tables end up with duplicate primary key values! Assigned Account
469362009-08-26
10:08
2015-08-23
20:45
MySQL Server: PartitionsDuplicate
(3799 days)
S35.1, next bzr5.1+AnyAnyDuplicate entry for key 'PRIMARY' if used partition and innodb Assigned Account
479522009-10-09
17:09
2011-04-29
8:25
MySQL Cluster: ReplicationClosed
(3197 days)
S3mysql-5.1-telco-6.2AnyAnyNdb replication : Unique index modifications give slave duplicate key errors Jonas Oreland
500582010-01-04
17:28
2011-02-16
23:44
MySQL Server: DDLVerified
(3673 days)
S35.1.40AnyAnyalter enum column gives duplicate key error  
505912010-01-25
14:15
2011-02-16
23:44
MySQL Server: Data TypesClosed
(3513 days)
S35.0.89,5.1.42, 5.5.1-m2, 5.5.99-m35.1+AnyAnybit(31) causes Duplicate entry '1-NULL' for key 'group_key' Sergei Glukhov
535612010-05-11
12:20
2016-10-16
20:45
MySQL ServerVerified
(3547 days)
S35.1.46, 5.5AnyAnyHA_EXTRA_WRITE_CAN_REPLACE does not work with row based replication Assigned Account
557802010-08-05
12:23
2015-01-09
14:45
Tools: Random Query GeneratorWon't fix
(1846 days)
S1bzr_revno_509Microsoft WindowsAnyRQG: kill of periodic reporting process on Windows fails with runall-new.pl Bernt Marius Johnsen
571892010-10-01
22:07
2011-02-16
23:44
MySQL Server: Row Based Replication ( RBR )Closed
(3406 days)
S25.1.50Linux (CentOS 5)AnyIsn't possible restore replication with master-master via mysqldump  
576872010-10-23
15:34
2013-03-19
9:45
MySQL Server: GeneralClosed
(3317 days)
S15.5.8AnyAnycrash when reporting duplicate group_key error and utf8 Alexander Barkov
608472011-04-13
6:01
2011-07-28
12:03
MySQL Server: ReplicationDuplicate
(3107 days)
S25.5.10AnyAnyslave replication encounters error 1062 after restoring from master snapshot  
612412011-05-20
5:55
2011-07-22
23:00
MySQL Server: ReplicationNo Feedback
(3114 days)
S15.1.39Linux (Fedora 9 ver 2.6.25-14.fc9-x86_64 )AnyIn Master - Master replication slave I/O showing NO after some days  
627552011-10-16
2:59
2011-11-23
12:51
MySQL Server: DMLDuplicate
(2989 days)
S35.5.16; 5.1.59Microsoft Windows (XP SP3)AnyUnexpect "ERROR 1062 (23000): Duplicate entry '...' for key 'group_key'" error  
648292012-04-01
10:29
2012-04-17
20:06
MySQL Server: CharsetsNot a Bug
(2843 days)
S35.5.21-log MySQL Community Server (GPL)Microsoft Windows (Seven)Anycharacter latin1 have a duplicate entry key (latin1 编码不同文字插入提示主键重复)  
659042012-07-16
2:01
2012-12-21
10:52
Connector / JVerified
(2753 days)
S45.1.21AnyAnyConnector/J (JDBC): Special exception subclass for duplicate key constraint Alexander Soklakov
688852013-04-08
7:46
2013-04-21
12:09
MySQL Server: DMLVerified
(2474 days)
S45.5+AnyAnya new parameter to control whether rollback a whole transaction on statment fail  
707842013-10-31
12:33
2014-02-21
9:36
MySQL Server: DocumentationClosed
(2184 days)
S35.6.14AnyAnyAdjust documentation and possibly defaults for sync_{master,relay_log}_info Jon Stephens
720662014-03-18
1:54
2014-09-24
7:56
MySQL Server: InstallingClosed
(1981 days)
S35.1.73 5.5.35 5.6.15 5.7.3AnyAnymysql_upgrade duplicate key error for mysql.user for 5.5.35+, 5.6.15+, 5.7.3+  
727262014-05-23
4:58
2014-05-23
6:49
MySQL Server: ErrorsDuplicate
(2077 days)
S25.5.28AnyAnyTable name for duplicate entry error  
733672014-07-23
15:59
2014-07-24
18:58
MySQL Utilities: Binlog EventsDuplicate
(2015 days)
S25.6.19AnyAnyminimal row image breaks binlog if alter table with trigger and last_insert_id  
751332014-12-06
16:30
2015-01-07
1:00
MySQL ServerNo Feedback
(1849 days)
S35.5.38Linux (Debian Wheezy)AnyMySQL ignores unique index on multiple columns when one column si null.  
760372015-02-25
4:52
2016-02-02
19:59
MySQL Server: InnoDB storage engineClosed
(1752 days)
S35.7AnyAnyInnodb: Incorrect duplicate key error for autoinc column for partitioned table  
803732016-02-15
13:47
2016-02-17
11:00
MySQL Server: ErrorsDuplicate
(1442 days)
S2AnyAnyauto-increment max triggering incorrect error  
823202016-07-22
8:33
2016-07-22
9:06
MySQL Server: InnoDB storage engineVerified
(1286 days)
S25.6, 5.6.31AnyAnyALTER Table failure with DUPLICATE key causes a crash  
823212016-07-22
9:45
2016-07-22
11:29
MySQL Server: InnoDB storage engineVerified
(1286 days)
S25.6.31AnyAnyALTER table failure with DUPLICATE key crash post index build crashes  
864022017-05-22
10:52
2017-05-24
13:27
Connector / NETCan't repeat
(980 days)
S17.0.7-m61Microsoft Windows (Build 1703)AnyInsert returns incorrect result, unknown corruption  
868662017-06-29
9:09
2017-10-24
23:20
MySQL Server: JSONClosed
(910 days)
S38.0.2AnyAnyUse last-wins strategy for duplicate keys in JSON objects  
886702017-11-27
22:56
2018-08-17
23:38
MySQL Server: OptimizerClosed
(530 days)
S35.7.20, 5.6.38AnyAnySubquery incorrectly shows duplicate values on subqueries.  
899872018-03-09
13:00
2019-07-23
14:29
MySQL Server: ReplicationClosed
(307 days)
S35.7.21Ubuntu (16.04)x86 (amd64)super_read_only with master_info_repository=TABLE breaks replication on restart  
907112018-05-02
5:20
2018-11-01
7:21
MySQL Server: InnoDB storage engineNo Feedback
(454 days)
S18.0.11Microsoft WindowsAnymysqld: Duplicate entry 'innodb_system' for key 'name'  
922532018-08-31
4:06
2018-08-31
10:05
MySQL Server: InnoDB storage engineDuplicate
(516 days)
S15.7.16 Source distributionLinux (embed system)ARM (armv7l)auto_increment column produce duplicate value  
955282019-05-24
15:52
2019-06-30
1:00
Connector / NETNo Feedback
(214 days)
S18.0.16Microsoft WindowsAnyAddRange throws "Duplicate entry 'x' for key 'PRIMARY'"  
959292019-06-22
23:08
2019-06-24
11:54
MySQL Server: Information schemaVerified
(219 days)
S38.0.16Ubuntux86Duplicate entry for key 'PRIMARY' when querying information_schema.TABLES  
189132006-04-09
2:01
2018-09-09
20:45
MySQL Server: DMLVerified
(2203 days)
S25.0.21-BK, 5.0.19,5.7.4AnyAnyPhysical order of rows in table alters update behavior of unique index  
235612006-10-23
22:32
2012-05-18
20:19
MySQL ServerDuplicate
(4466 days)
S35.0.28-BK, 5.0.18-max-logLinux (Linux, RedHat/RHEL3)Anytimestamp is automatically updated when nothing changed through INSERT...ON DUP Assigned Account
397662008-10-01
2:31
2008-10-23
23:04
MySQL Server: Memory storage engineNot a Bug
(4115 days)
S25.0.60-log, 5.0.66a, 5.1.28AnyAnyPhysical order of rows in table alters update behavior of unique index  
399272008-10-08
11:17
2011-02-16
23:43
MySQL Cluster: ReplicationClosed
(3824 days)
S2mysql-5.1-telco-7.0AnyAnyndb_log_update_as_write does not work as expected  
657662012-06-29
7:08
2012-07-30
1:00
MySQL Server: DMLNo Feedback
(2740 days)
S5Microsoft WindowsAnyinsert/update  
791222015-11-04
15:41
2016-02-04
20:18
MySQL Server: Prepared statementsClosed
(1541 days)
S35.7.10AnyAny memory leaks when doing INSERT... UPDATE ... prepared statements  
807332016-03-14
18:21
2016-05-23
23:36
MySQL Cluster: Cluster (NDB) storage engineClosed
(1357 days)
S37.4.10AnyAnyAcc table scan may scan same row twice  
8562003-07-16
12:05
2004-03-13
9:52
MySQL ServerClosed
(5800 days)
S34.1.1a/5.0Linux (Linux Mandrake/Win XP/Suse 9.0)AnyNaming a key "Primary" causes trouble Victor Vagin
81602005-01-27
12:38
2005-03-08
16:52
MySQL ServerNo Feedback
(5440 days)
S24.0.22Linux (Linux)AnyServer  
126332005-08-18
2:44
2006-06-13
17:10
MySQL Server: MyISAM storage engineClosed
(4978 days)
S24.1.13, 4.1.14-ntLinux (linux, windows)Anymyisampack and then unpack destroys auto_increment key Ingo Strüwing
201602006-05-31
0:32
2006-05-31
20:06
MySQL Workbench PreviewWon't fix
(4991 days)
S31.06Microsoft Windows (win32)Anyduplicate foreign key names  
247182006-11-30
10:08
2006-12-18
21:02
MySQL ServerCan't repeat
(4790 days)
S25-0-27Microsoft Windows (Windows XP)Anydrop database really dropping database Miguel Solorzano
252622006-12-24
2:08
2007-05-04
18:02
MySQL Server: GeneralClosed
(4653 days)
S35.0.34-BK, 4.1.14Linux (Linux Red Hat)AnyAuto Increment lost when changing Engine type Magnus Blåudd
371822008-06-04
5:50
2018-07-01
18:08
MySQL Server: Archive storage engineVerified
(4256 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
(3766 days)
S35.0.82LinuxAnychanging foreign key's field case results in Duplicate key name error on restore Assigned Account
948162019-03-28
14:25
2019-04-23
13:33
MySQL Server: DDLVerified
(289 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
(5392 days)
S44.1.2 alphaMac OS X (Mac OS X 10.3.4)AnyPlease allow more than one DEFAULT or ON UPDATE of CURRENT_TIMESTAMP in a table  
55332004-09-13
0:58
2004-10-04
21:10
MySQL ServerClosed
(5595 days)
S14.1.3Linux (RH Enterprise ES3 TaroonUpdate2)Anykeys (#) return no matches Matthew Lord
77852005-01-10
22:35
2005-01-31
21:20
Connector / NETNot a Bug
(5476 days)
S31.0.3.31712.Net 1.1AnySolved Reggie Burnett
78472005-01-12
22:25
2005-02-12
23:05
MySQL Server: ReplicationNo Feedback
(5464 days)
S34.1.7Linux (Linux 2.4.21)AnyMulti-table updates don't seem to replicate properly.  
99792005-04-18
17:58
2005-07-21
4:43
MySQL ServerClosed
(5305 days)
S34.1.10/4.1.12.BKLinux (SuSe 9.2 on AMD64)AnyUse of CONVERT_TZ in multiple-table UPDATE causes bogus privilege error Jim Winstead
106992005-05-18
6:56
2005-06-04
14:21
MySQL Server: ReplicationCan't repeat
(5352 days)
S34.0.22FreeBSD (freebsd)AnyAUTO_INCREMENT locking during replication execution of unrelated db+tables Matthew Lord
132072005-09-15
1:40
2013-05-30
7:24
Connector / ODBCClosed
(2435 days)
S1most recentMicrosoft Windows (XP)Any.edit and .update fail completely with VB6/DAO 3.51 or DAO 3.60  
132082005-09-15
1:42
2005-09-15
3:44
Connector / ODBCDuplicate
(5249 days)
S1most recentMicrosoft Windows (XP)Any.edit and .update fail completely with VB6/DAO 3.51 or DAO 3.60  
146182005-11-03
21:18
2007-08-03
16:19
MySQL ServerClosed
(4562 days)
S34.1.15, 5.1 BK, 5.0 BKLinux (Debian GNU/Linux)Anymysql_setpermission doest not work anymore Jonathan Perkin
163452006-01-10
17:30
2012-05-18
20:19
MySQL Server: OptimizerDuplicate
(5025 days)
S25.0.19-BK, 5.0.18-ntLinux (Linux, Windows 2000 Server SP4)AnyMulti-table update sometimes updates only one row (in tables from 4.x.y) Evgeny Potemkin
165102006-01-15
0:07
2006-01-24
22:09
MySQL ServerClosed
(5118 days)
S24.0.26Linux (Slackware Linux)AnyRepeated crash with 4.0.24 and 4.0.26 Evgeny Potemkin
175692006-02-20
10:06
2009-09-02
8:07
Connector / ODBCNot a Bug
(3801 days)
S33.51Microsoft Windows (Windows 2003 Server)AnyASPUpload / ASPJpge Update BLOB  
186812006-03-31
10:38
2006-05-26
16:39
MySQL Server: ViewsClosed
(4996 days)
S25.0.21-BK, 5.0.18Linux (Linux, Mac OS X 10.4.5)AnyView privileges are broken Georgi Kodinov
191972006-04-19
13:20
2006-06-19
18:18
MySQL ServerNo Feedback
(4972 days)
S1mysql-pro-5.0.20-linux-i686-glibc23Linux (linux debian)AnyUpdate crashing the server.  
224502006-09-18
20:06
2006-09-23
12:53
Connector / NETNot a Bug
(4876 days)
S31.0.7Microsoft Windows (Windows 2000 Professional SP4)AnyMySqlDataAdapter Update causes SqlException with parametrized INSERT command  
280902007-04-25
9:55
2007-04-30
14:07
MySQL Server: Falcon storage engineClosed
(4657 days)
S26.0.0-alphaAnyAnyFalcon Concurrent UPDATEs leading to assertion Kevin Lewis
286302007-05-23
20:33
2009-05-26
12:57
MySQL Query BrowserWon't fix
(3900 days)
S31.2.17QB1218Microsoft WindowsAnyEdit Mode in MySQL Query Browser doesn't support entry of b'1' to a BIT(1) field  
300182007-07-24
21:49
2007-08-30
13:12
MySQL Server: Security: PrivilegesCan't repeat
(4535 days)
S35.0.45Microsoft WindowsAnyUPDATE Fails Sveta Smirnova
301362007-07-31
5:54
2007-08-31
16:54
MySQL Server: Stored RoutinesNo Feedback
(4534 days)
S2mysql-5.1.19-beta-win32Microsoft Windows (Windows XP)AnyCause Table Crash, when replicate a update statement over to slave server  
308522007-09-06
9:27
2007-11-22
19:39
MySQL Enterprise Monitor: InstallingClosed
(4451 days)
S21.2.0.7481Microsoft WindowsAnyagent update installer does not update yassl.dll on Windows BitRock Merlin
311472007-09-22
14:42
2012-09-13
10:58
Connector / NETNo Feedback
(4402 days)
S21.0.9Microsoft WindowsAnyIsolation level not working  
331162007-12-10
14:55
2015-01-09
15:54
MySQL Enterprise Monitor: InstallingNo Feedback
(1846 days)
S11.3.0.8507IBM AIX (5.2)Anyagent update installer on AIX hangs (and ignores parameter "--backupdir") Assigned Account
343842008-02-07
16:45
2011-02-16
23:43
MySQL Server: DMLClosed
(3401 days)
S35.0.45, 5.1.22, 5.0.54AnyAnyBig quoted int in WHERE of UPDATE or DELETE causes drop in performance Evgeny Potemkin
349072008-02-27
21:23
2011-02-16
23:43
MySQL ServerVerified
(3753 days)
S35.1.22AnyAnyHandlers cannot replace the plugin variable update func for thread vars  
373462008-06-11
14:35
2011-02-16
23:43
MySQL Server: LockingClosed
(3615 days)
S35.0,5.15.5+AnyAnyinnodb does not detect deadlock between update and alter table Dmitry Lenev
378032008-07-02
11:09
2008-10-17
17:40
MySQL Server: TestsClosed
(4121 days)
S35.1.26,6.0.65.1+AnyAnyTest "partition_alter2_innodb" exhausts resources (time and/or memory) Mattias Jonsson
385482008-08-04
19:28
2011-02-16
23:43
MySQL Server: DocumentationClosed
(4032 days)
S45.0, 5.1AnyAnyUpdate syntax description doesn't mention table alias Paul Dubois
406252008-11-10
23:07
2011-02-16
23:43
MySQL Server: Data TypesClosed
(3509 days)
S25.0.67-community-nt, 5.0.70, 5.1.295.1+AnyAnyConcat fails on DOUBLE values in a Stored Procedure, while DECIMAL works Gleb Shchepa
410072008-11-25
11:21
2008-11-26
10:13
MySQL Server: DMLNot a Bug
(4081 days)
S25.0.67Any (Tested on OSX and Linux Debian)AnyUpdate Problem when ORing w/ Long.MIN_VALUE  
416332008-12-19
12:01
2009-02-12
13:52
Connector / ODBCNot a Bug
(4003 days)
S25.0.22Linux (Ubuntu 6.06.1 LTS)AnyExecution of Procedure delayed using ODBC-Connector  
471352009-09-04
12:56
2011-02-16
23:44
MySQL Server: PartitionsClosed
(3614 days)
S35.4.2-beta5.4+Other (Solaris + OS X, see text)AnyServer crashes on "partition_alter2_1_innodb" + "partition_alter2_2_innodb" Mattias Jonsson
474532009-09-19
13:46
2011-02-16
23:44
MySQL Server: DMLClosed
(3512 days)
S25.1.30, 5.1.45, 5.5.2-m2AnyAnyInnoDB incorrectly changes TIMESTAMP columns when JOINed during an UPDATE Georgi Kodinov
475572009-09-23
15:50
2011-02-16
23:44
MySQL Server: Row Based Replication ( RBR )Closed
(3289 days)
S25.1+AnyAnymysqlbinlog -v should output 'limit 1' for update and delete row events Luis Soares
499642009-12-28
19:44
2009-12-29
9:10
MySQL ServerNot a Bug
(3683 days)
S35.1.31-communityAnyAnyorder of set commans is important  
523772010-03-25
20:15
2011-02-16
23:44
MySQL Server: LockingVerified
(3506 days)
S45.5.4-m3,5.6.99-m4AnyAnyMDL locks taken by failing statements not automatically removed  
525222010-04-01
11:43
2011-02-16
23:44
MySQL Server: Security: PrivilegesDuplicate
(3541 days)
S35.5.3-m3AnyAnyRunning mysql_upgrade loses trigger privileges  
528602010-04-15
14:54
2011-02-16
23:44
Connector / J DocumentationClosed
(3547 days)
S4n/aAnyAnyambiguous wording "affected rows" in c/J docs Tony Bedford
570592010-09-28
10:00
2011-02-16
23:44
MySQL Enterprise Monitor: InstallingClosed
(3292 days)
S32.3.0.20252.3.x main releaseAnyAnyagent update installer doesn't use all values from command line for the dialogs BitRock Merlin
570642010-09-28
11:02
2011-02-16
23:44
MySQL Enterprise Monitor: InstallingClosed
(3348 days)
S32.3.0.20252.3.x main releaseAnyAnyagent update installer --help should show "Update" in version string BitRock Merlin
599572011-02-04
23:32
2011-09-30
18:30
MySQL Server: Security: PrivilegesClosed
(3043 days)
S35.0, 5.1, 5.5AnyAnyView using merge permissions in multi-table update  
648922012-04-06
17:53
2012-08-13
16:22
MySQL Server: LockingClosed
(2725 days)
S35.1, 5.5, 5.6AnyAnySession-level low_priority_updates does not work for INSERT  
664632012-08-20
12:58
2012-08-21
18:04
MySQL Server: MyISAM storage engineVerified
(2717 days)
S45.5.25aLinuxAnyUPDATE LOW_PRIORITY blocks concurrent_inserts  
688032013-03-28
14:59
2016-04-05
19:14
MySQL ServerNot a Bug
(2497 days)
S35.5.29-0ubuntu0.12.10.1-logLinux (Ubuntu 12.10)AnySELECT ... FOR UPDATE takes out unreported lock causing deadlock  
703142013-09-12
12:28
2013-09-12
14:07
MySQL Server: OptimizerVerified
(2330 days)
S35.6AnyAnyAmbiguous column updated with UPDATE ... JOIN ... USING  
902282018-03-27
11:19
2018-03-28
8:15
MySQL Server: SYS SchemaClosed
(672 days)
S35.7.21AnyAnysys.innodb_lock_waits showing the wrong blocking query  
931152018-11-08
8:19
2019-05-21
12:45
MySQL ServerNot a Bug
(446 days)
S38.0.13AnyAnySKIP LOCKED mode is preventing to UPDATE the very next row.  
933432018-11-26
10:56
2018-11-28
9:54
Connector for Node.jsDuplicate
(427 days)
S28.0.13Microsoft WindowsAnyError while updating TINYINT value using either true/false or 1/0 Rui Quelhas
17552003-11-05
2:43
2003-11-05
5:43
MySQL Server: MyISAM storage engineDuplicate
(5929 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
(4135 days)
S44.1.10Linux (Linux)AnyREPLACE reallocates new AUTO_INCREMENT  
131842005-09-14
15:12
2005-09-14
17:25
MySQL ServerCan't repeat
(5250 days)
S23.1Linux (LInux)AnyUpdate messes up the Primary Key  
455052009-06-15
15:47
2011-02-16
23:44
MySQL Server: ReplicationNo Feedback
(3798 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
(3742 days)
S35.45.4+AnyAnyRBR slave crash in table_def::type when modifying a merge table Luis Soares
477082009-09-29
11:06
2011-02-16
23:44
MySQL ServerNo Feedback
(3743 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
(3535 days)
S35.2.19 OSSbetaMicrosoft WindowsAnyError1005, err150  
824542016-08-04
10:51
2017-01-13
7:44
MySQL Server: InstallingDuplicate
(1111 days)
S25.6Ubuntu (Xenial)AnyBug in Mysql 5.6 Installation in Xenial  
882422017-10-27
1:16
2017-11-22
23:39
Connector / JClosed
(798 days)
S15.1.41, 5.1.44AnyAnyautoReconnect and socketTimeout JDBC option makes wrong order of client packet Filipe Silva
20592003-12-09
10:00
2012-05-18
20:19
MySQL ServerNo Feedback
(5864 days)
S24.1.0Microsoft Windows (Windows 2000 SP6)AnyNATURAL JOIN changed behaviour Assigned Account
23612004-01-12
12:22
2004-01-14
4:05
MySQL ServerClosed
(5859 days)
S34.1.2Linux (SuSE 8.2)AnyALTER TABLE ... DROP PRIMARY KEY drops a non-primary key Ramil Kalimullin
25032004-01-24
15:20
2004-01-24
20:30
MySQL ServerNot a Bug
(5849 days)
S2 5.0.0a-alphaMicrosoft Windows (Window XP Professional)Anystored procedure creation errors  
25142004-01-26
8:40
2008-09-29
21:32
MySQL ServerCan't repeat
(4139 days)
S24.0.18Microsoft Windows (w2k)AnyTRUNCATE table with merge corupts table Ingo Strüwing
42852004-06-25
13:11
2005-01-25
16:16
MySQL ServerClosed
(5482 days)
S34.1.3-beta bk treeLinux (Linux)Anymultiple key cache doesn't work properly Timour Katchaounov
64352004-11-04
16:06
2004-11-08
11:50
MySQL Cluster: Cluster (NDB) storage engineClosed
(5560 days)
S14.1.8 bkLinux (gentoo 2.6)Anystrange behaviour of left join Jonas Oreland
89572005-03-04
21:23
2014-03-28
11:26
Connector / JClosed
(2133 days)
S13.1.6-7Microsoft Windows (Win2Kserver)AnyMySQL service crash without errors Alexander Soklakov
109122005-05-27
10:34
2012-05-18
20:19
MySQL Server: Embedded Library ( libmysqld )Duplicate
(5223 days)
S35.0.6 + 4.1.15various Unix (case-insignif. FS)AnyEmbedded tests show wrong path names Assigned Account
118692005-07-11
19:18
2005-08-08
15:49
MySQL Server: OptimizerClosed
(5287 days)
S14.1.12-nt, 5.0.7-nt-beta/5.0.10Microsoft Windows (Windows XP1/Linux)AnyServer crashes making a union join query with fulltext search Sergey Petrunya
126232005-08-17
13:50
2005-08-19
1:09
MySQL ServerCan't repeat
(5276 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
(5190 days)
S35.0.13-rc, 5.0.14-BKLinux (Linux, Windows)AnyLost connection with SELECT queries and DELETE in SP (WITH QUERY CACHE) Oleksandr Byelkin
151332005-11-22
13:32
2006-08-17
11:23
MySQL Server: Federated storage engineClosed
(4913 days)
S25.0.16/5.0.17 BKLinux (Linux)Anyunique index with nullable value not accepted in federated table Patrick Galbraith
157002005-12-13
4:52
2005-12-13
9:46
MySQL ServerDuplicate
(5160 days)
S15.0.16Linux (linux,windows)Anyleft join return null  
157012005-12-13
5:03
2006-06-29
15:35
MySQL ServerNo Feedback
(4962 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
(5160 days)
S1mysql5.0Microsoft Windows (windows2000,redhat AS3,redhat8)Anyleft join bug  
171062006-02-03
20:22
2006-06-04
4:11
Connector / NETClosed
(4987 days)
S31.0.7.30072Microsoft Windows (Windows 2003 Server)AnyMySql.Data.MySqlClient.CharSetMap.GetEncoding thread synchronization issue Reggie Burnett
203892006-06-12
8:22
2006-07-19
4:08
MySQL Server: PartitionsClosed
(4942 days)
S15.1.12-BK debug, 5.1.11Linux (linux 2.4.20-8)Anyuse partition, server crash Mikael Ronström
218512006-08-26
19:04
2006-12-28
12:50
MySQL ServerNo Feedback
(4780 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
(4832 days)
S35.0.25Any (All)AnyFour tests require "innodb" to be configured, fail in "classic" build Magnus Blåudd
230812006-10-07
23:23
2006-10-17
15:58
MySQL AdministratorClosed
(4852 days)
S31.2.4rcAny (any)Anyfalse primary key (only a unique key) makes changes on the column difficult Vladimir Kolesnikov
248792006-12-07
11:11
2007-06-04
18:13
MySQL Server: Prepared statementsClosed
(4622 days)
S34.1/5.0/5.1BKLinux (Linux)AnyPrepared Statements: CREATE TABLE (UTF8 KEY) produces a growing key length Konstantin Osipov
269392007-03-07
23:20
2008-01-10
4:56
MySQL Server: MyISAM storage engineNo Feedback
(4402 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
(4611 days)
S35.1-bkLinuxAnygroup_by test fails Martin Hansson
279352007-04-18
20:22
2015-03-22
20:45
MySQL Server: DDLDuplicate
(4346 days)
S35.1-bk/5.0bk6.0LinuxAnyTRUNCATE fires DELETE trigger if InnoDB table is referenced by a foreign key Assigned Account
307472007-08-31
10:23
2007-10-24
20:09
MySQL ServerClosed
(4480 days)
S25.0 & 5.1AnyAnyCreate table with identical constraint names behaves incorrectly Davi Arnaut
310742007-09-18
5:04
2007-11-25
14:41
MySQL Server: GeneralCan't repeat
(4448 days)
S35.0.50, 5.1.23BKAnyAnykeys on innodb spatial columns cause prefix warnings in logs Alexey Botchkov
350912008-03-05
21:50
2008-03-07
9:28
MySQL Server: Data TypesNot a Bug
(4345 days)
S35.0.54a or newer5.0.60,5.1.24AnyAnyIF (@...) Returns Incorrect Type - Regression from 5.0.44 Georgi Kodinov
359522008-04-10
1:20
2008-04-25
20:24
MySQL Server: OptimizerClosed
(4296 days)
S25.1.245.1.25AnyAnyRegression: 5.1.24 Results not returned for users with select privs as expected Evgeny Potemkin
364492008-05-01
10:09
2011-02-16
23:43
MySQL Server: OptimizerClosed
(4048 days)
S26.0.6-pre6.0-betaAnyAnySignificant slowdown for (ANY|SOME) subqueries processed with semijoin Sergey Petrunya
370672008-05-29
12:02
2011-02-16
23:43
MySQL Server: FULLTEXT searchWon't fix
(3422 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
(2655 days)
S35.0.60, 5.0.64AnyAnyOptimizer prefers ref access on multiple-column index over simple range access Jørgen Løland
373332008-06-11
8:58
2013-08-07
18:39
MySQL Server: OptimizerClosed
(2366 days)
S35.0.60, 5.0.64, 5.1.26AnyAnyOptimizer uses wrong index for the right table in LEFT JOIN Assigned Account
451852009-05-29
10:19
2014-08-18
6:44
MySQL Server: InnoDB storage engineCan't repeat
(1990 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
(3780 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
(3734 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
(3480 days)
S1M3 (Celosia)5.5+Mac OS X (i386 max)AnySeveral tests using innodb fail with "Incorrect key file for table" on Mac OSX Calvin Sun
536312010-05-13
20:54
2010-05-26
20:59
MySQL Server: MyISAM storage engineNot a Bug
(3535 days)
S35.0.41-community-logLinux (CentOS 5.4)AnyPrimary key index size optimisation disagrees with docs  
542252010-06-04
8:12
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3517 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
(2246 days)
S35.1.51AnyAnyOpenSSL vs yaSSL: different behavior of --ssl-ca parameter Georgi Kodinov
584062010-11-22
22:02
2012-02-06
23:12
MySQL Server: InnoDB storage engineClosed
(2914 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
(3198 days)
S15.1.48, 5.1.55SolarisAnyReplication over SSL; error 2026 most, but not all, of the time  
  Showing 1-1000 of 11841 (Edit, Save, CSV, Feed) Show Next 1000 Entries »