Showing 1-1000 of 2825 (Edit, Save, CSV, Feed) | Show Next 1000 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
1495 | 2003-10-07 4:35 | 2003-10-14 6:15 | MySQL Server | Closed (7691 days) | S1 | 5.0 | Any (All) | Any | SIGSEGV in Item_bool_func2::fix_length_and_dec() |
53432 | 2010-05-05 11:41 | 2020-09-13 20:45 | MySQL Server: DML | Duplicate (5276 days) | S1 | 5.5.5 , 5.5.4 | Any | Any | SELECT MAX QUERY WITH DATE FIELD GIVES WRONG RESULTS |
43685 | 2009-03-17 2:41 | 2011-02-16 23:43 | MySQL Server: Locking | Closed (5355 days) | S3 | 5.0.78,5.1.32 | Any | Any | Lock table affects other non-related tables |
37395 | 2008-06-13 14:16 | 2008-09-12 14:31 | MySQL Server: Falcon storage engine | Can't repeat (5896 days) | S1 | 6.0.5-rebuild | Any | Any | Falcon deadlock between Table::insert and Table::validateAndInsert |
33175 | 2007-12-12 16:56 | 2008-05-02 1:48 | MySQL Server: Falcon storage engine | Closed (6029 days) | S2 | 6.0.4 | Any | Any | Falcon table hangs when insertng over 8M rows |
32838 | 2007-11-29 5:42 | 2016-11-17 7:44 | MySQL Server: Falcon storage engine | Won't fix (2908 days) | S2 | 6.0.4, mysql-6.0-falcon-team | Any | Any | Falcon; error 1296 : Got error 305 'record memory is exhausted' |
73136 | 2014-06-27 16:34 | 2015-05-20 15:16 | MySQL Server: Optimizer | Verified (3779 days) | S3 | 5.6.12,5.6.19,5.5, 5.5.38, 5.5.20 | Any | Any | Index scan incorrectly selected over ref+sort leading to x1000 worse performance |
55659 | 2010-07-31 11:39 | 2013-03-03 20:45 | MySQL Server: MyISAM storage engine | Verified | S3 | 5.1 bzr | Any | Any | Negative count(*) |
51017 | 2010-02-09 9:07 | 2010-02-13 19:12 | MySQL Server: Optimizer | Not a Bug (5377 days) | S3 | 6.0-codebase-bugfixing | Any | Any | Batched key access gives wrong results for SELECT with LEFT JOIN, GROUP BY |
57024 | 2010-09-26 4:44 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5149 days) | S2 | 5.1 | Any | Any | Serious performance issue with an outer join |
58831 | 2010-12-09 3:30 | 2011-02-16 23:44 | Tests: Server | Closed (5067 days) | S3 | Any | Any | large_tests.alter_table crashes the server | |
37200 | 2008-06-04 17:23 | 2008-07-29 9:52 | MySQL Server: Replication | Closed (5941 days) | S3 | 5.1, 6.0 | Any | Any | rpl_switch_stm_row_mixed fails sporadically in pushbuild |
333 | 2003-04-26 13:49 | 2003-08-22 7:08 | MySQL Server: Replication | Won't fix (7744 days) | S2 | 4.0 | Any (all) | Any | 3 binlogging bugs when doing INSERT with mixed InnoDB / MyISAM |
55453 | 2010-07-21 18:01 | 2011-02-16 23:44 | MySQL Enterprise Monitor: Agent | Closed (5192 days) | S1 | 2.2.2.1729 | Any | Any | Agent resends the same example query over and over every 2 minutes |
30059 | 2007-07-26 3:01 | 2011-02-16 23:43 | MySQL Server: Data Types | Closed (5253 days) | S3 | 5.0 and up | Any | Any | End-space truncation is inconsistent or incorrect |
29249 | 2007-06-20 21:01 | 2013-03-03 20:45 | MySQL Server: Archive storage engine | Duplicate (6339 days) | S1 | 5.0.44 | Any | Any | thread hang with concurrent insert/optimize of archive tables |
53587 | 2010-05-11 22:57 | 2016-08-17 14:51 | MySQL Server: Documentation | Closed (3000 days) | S3 | 5.0,5.1 | Any | Any | what are the semantics of the rand function |
39903 | 2008-10-07 9:18 | 2018-09-25 21:49 | MySQL Server: Tests | Closed (5756 days) | S7 | 6.0-rpl | Any | Any | Tests that restart server fail sporadically on pushbuild |
37713 | 2008-06-28 10:27 | 2018-09-25 21:47 | Tests: Replication | Can't repeat (5746 days) | S7 | 6.0-rpl | Any | Any | rpl.rpl_known_bugs_detection failed in pushbuild |
56184 | 2010-08-23 5:27 | 2011-05-13 10:26 | MySQL Server: Replication | Closed (4923 days) | S3 | 5.1, 5.5 | Any | Any | Rolled back transaction without non-trasactional table updated was binlogged |
85821 | 2017-04-06 7:11 | 2020-12-01 11:51 | MySQL Server: Optimizer | Closed (1433 days) | S3 | 8.0.2-DEBUG | Any | Any | partial update on views does not work |
9922 | 2005-04-15 5:10 | 2005-04-16 16:56 | MySQL Server | Closed (7141 days) | S2 | 4.0.24 | Any (Any) | Any | INSERT SELECT with UNIONs allows illegal concurrent INSERTs |
36411 | 2008-04-29 19:46 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5252 days) | S3 | 5.1.24, 5.1.25 | Any | Any | "Failed to read auto-increment value from storage engine" in 5.1.24 auto-inc |
37712 | 2008-06-28 10:19 | 2018-09-25 21:47 | Tests: Replication | Closed (5756 days) | S7 | 6.0 | Any | Any | rpl.rpl_locktrans_innodb fails sporadically on pushbuild |
40505 | 2008-11-04 16:09 | 2011-02-16 23:43 | MySQL Server: General | Verified (5826 days) | S4 | Any | Any | INSERT DELAYED and transactions, duplicate keys | |
41498 | 2008-12-16 12:36 | 2018-09-25 21:50 | Tests: Server | Closed (5570 days) | S7 | Any | Any | concurrent_innodb_unsafelog fails sporadically: query should have had errno 1205 | |
46129 | 2009-07-11 12:44 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5569 days) | S3 | 5.1+ | Any | Any | Failing mixed stm (with trans and non-trans tables) causes wrong seq in binlog |
47175 | 2009-09-07 13:25 | 2011-02-16 23:44 | MySQL Server: Row Based Replication ( RBR ) | Closed (5355 days) | S3 | 5.1,5.4 | Any | Any | failing INSERT, transaction, replication out of sync |
47682 | 2009-09-28 16:12 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5350 days) | S3 | 5.1,6.0.14 | Any | Any | strange behaviour of INSERT DELAYED |
54122 | 2010-06-01 3:23 | 2018-09-25 21:51 | Tests: Replication | Closed (4930 days) | S7 | 5.6.1 | Any | Any | Race condition in mysqlbinlog_raw_mode |
79665 | 2015-12-16 10:50 | 2017-05-31 20:02 | MySQL Server: Documentation | Closed (2713 days) | S3 | any | Any | Any | Manual does NOT explain locks set by INSERT ... ON DUPLICATE KEY UPDATE properly |
112292 | 2023-09-07 12:37 | 2023-09-11 22:06 | MySQL Server: Documentation | Closed (419 days) | S3 | all | Any | Any | Typo spotted |
5 | 2002-10-29 19:48 | 2002-12-02 12:48 | MySQL Server | Closed (8007 days) | S3 | 3.23.53 | Any (all) | Any | left join bug |
29571 | 2007-07-05 12:06 | 2007-08-03 15:39 | MySQL Server: Replication | Closed (6302 days) | S3 | 4.1,5.0 | Any | Any | INSERT DELAYED IGNORE written to binary log on the master but on the slave |
32039 | 2007-11-02 1:12 | 2007-11-02 6:21 | Tests: Cluster | Not a Bug (6211 days) | S3 | mysql-5.1 | Any | Any | rpl_ndb_auto_inc should list error 1062 instead or 1022 |
33066 | 2007-12-07 16:33 | 2007-12-25 14:06 | MySQL Server: DML | Not a Bug (6158 days) | S3 | 5.1.22-rc | Any | Any | last_insert_id(), wrong values, InnoDB, insert on duplicate key update |
37741 | 2008-06-30 14:12 | 2008-06-30 14:41 | MySQL Server: Tests | Duplicate (5970 days) | S3 | 5.1.25 | Any | Any | Test concurrent_innodb fails with invalid login |
37964 | 2008-07-08 11:17 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (5955 days) | S2 | 5.1/5.0/6.0 | Any | Any | Wrong result using ORDER BY + LIMIT |
38857 | 2008-08-18 13:45 | 2011-02-16 23:43 | MySQL Server: Parser | Duplicate (5920 days) | S4 | Any | Any | SQL addition - ORLIMIT | |
38858 | 2008-08-18 13:56 | 2022-12-04 20:45 | MySQL Server: Parser | Verified (5920 days) | S4 | Any | Any | ORDERGROUP BY construct | |
38859 | 2008-08-18 14:17 | 2022-12-04 20:45 | MySQL Server: Parser | Verified (5920 days) | S4 | 6.0 | Any | Any | limiting a group - LIMITGROUP |
43002 | 2009-02-19 7:39 | 2013-07-04 13:10 | MySQL Server: Maria storage engine | Won't fix (4140 days) | S3 | 6.0-TRUNK | Any | Any | maria.maria_notembedded fails sporadically |
47835 | 2009-10-05 13:19 | 2011-02-16 23:44 | MySQL Server: Replication | Can't repeat (5070 days) | S3 | 5.1.37sp1 | Any | Any | MBR replication failure under concurrent load with OFFSET in subselect |
51564 | 2010-02-26 20:10 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5305 days) | S3 | 5.5.99-m3 | Any | Any | Error ER_BINLOG_UNSAFE_NONTRANS_AFTER_TRANS is too eager after BUG#46364 |
70923 | 2013-11-15 16:59 | 2013-11-18 19:03 | MySQL Server: Replication | Verified (4003 days) | S2 | 5.5.34, 5.6.16 | Any | Any | Replication failure on multi-statement INSERT DELAYED queries |
104576 | 2021-08-10 4:18 | 2024-05-28 3:21 | MySQL Server: Partitions | Closed (1122 days) | S5 | 8.0.26, 5.7.35 | Any | Any | partition table access second index lead to cpu high load |
105044 | 2021-09-26 15:32 | 2021-09-27 12:59 | MySQL Server: InnoDB storage engine | Verified (1133 days) | S5 | 8.0 | Any | Any | Added page szie judgment logic like btr_cur_optimistic_insert in btr_insert_into |
28781 | 2007-05-30 17:24 | 2016-02-25 12:24 | MySQL Server: Documentation | Closed (5252 days) | S2 | 5.0.42 | Any | Any | InnoDB increments auto-increment value incorrectly with ON DUPLICATE KEY UPDATE |
35140 | 2008-03-07 10:11 | 2008-05-21 14:24 | MySQL Server: Falcon storage engine | Closed (6010 days) | S3 | 6.0.4 | Any | Any | Suspected Falcon deadlock in Table::insert |
36982 | 2008-05-26 15:20 | 2008-06-23 11:04 | Tests: Replication | Can't repeat (5977 days) | S3 | 6.0-engines-merge | Any | Any | rpl_found_rows.test fails in pushbuild |
42209 | 2009-01-20 8:30 | 2012-08-31 15:44 | MySQL Server: Optimizer | Closed (4447 days) | S3 | 5.1.30 | Any | Any | Rollback affects the index usage for DELETE statement with FORCE INDEX. |
43457 | 2009-03-06 14:24 | 2018-04-11 13:22 | MySQL Server: Replication | Not a Bug (2398 days) | S3 | 5.1, 6.0 | Any | Any | replicate-ignore-db behaves differently with different binlog formats |
57892 | 2010-11-01 12:02 | 2017-05-21 20:45 | MySQL Server: Replication | Duplicate (5107 days) | S1 | 5.6.99 (bzr_mysql-next-mr-wl2540) | Any | Any | Crash in my_b_write_quoted (log_event.cc) from mysqlbinlog with checksum |
64888 | 2012-04-06 14:43 | 2012-04-09 11:03 | MySQL Server: MyISAM storage engine | Verified (4594 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | Inconsistent behavior of dynamic concurrent_insert values |
65225 | 2012-05-07 16:39 | 2014-03-27 14:23 | MySQL Server: InnoDB storage engine | Closed (3919 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | InnoDB miscalculates auto-increment after changing auto_increment_increment |
69835 | 2013-07-25 2:41 | 2013-08-22 2:52 | MySQL Server: InnoDB storage engine | Not a Bug (4091 days) | S3 | 5.6.12 | Any | Any | deadlock detected on concurrent insert |
71638 | 2014-02-09 14:41 | 2016-05-13 19:29 | MySQL Server: Documentation | Closed (3096 days) | S3 | 5.6 | Any | Any | Manual does NOT explain "insert intention" lock mode properly |
82774 | 2016-08-29 3:13 | 2017-04-13 22:01 | MySQL Server: Locking | Not a Bug (2761 days) | S3 | 5.7.13 | Any | Any | Reasonably easy to generate mysqld semi-hang. Input file is 1K lines. |
102982 | 2021-03-15 15:02 | 2021-04-24 15:50 | MySQL Server: Japanese Documentation | Closed (1289 days) | S3 | 8.0.23 | Any | Any | 1.3 MySQL 8.0 の新機能(TIMESTAMP および DATETIME のタイムゾーンサポート~) |
104238 | 2021-07-07 15:16 | 2021-07-08 6:23 | MySQL Server: Security: Privileges | Duplicate (1214 days) | S3 | 8.0.24 | Any | Any | Grants in prepare with 2 triggers on the same table |
109891 | 2023-02-02 9:10 | 2023-02-03 7:55 | MySQL Server: DML | Verified (639 days) | S3 | 8.0.30,8.0.31, 8.0.32, 5.7 | Any | Any | Contribution by Tencent: insert on duplicate key update would be abnormal |
110412 | 2023-03-17 12:42 | 2023-03-20 5:45 | MySQL Server: InnoDB storage engine | Verified (594 days) | S3 | 8.0.28 | Any | Any | SMO(split) can result in unexpected sparse B-tree pages. |
112451 | 2023-09-25 6:35 | 2023-09-25 7:37 | MySQL Server: Optimizer | Verified (405 days) | S3 | 8.0,8.1 | Any | Any | Incorrect result if there are non-deterministic expressions in in-subquery |
189 | 2003-03-25 4:48 | 2003-03-26 12:35 | MySQL Server | Closed (7893 days) | S3 | 4.0.12 / 4.0.13 bk tree | Any (ALL) | Any | Wrong host name/port displayed for DELAYED thread |
11472 | 2005-06-21 0:08 | 2024-04-09 10:03 | MySQL Server: DML | Verified (5862 days) | S2 | 5.0.8/5.5/5.6/5.7 | Any | Any | Triggers not executed following foreign key updates/deletes |
13392 | 2005-09-21 22:47 | 2005-10-31 20:13 | MySQL Server: Optimizer | Closed (6943 days) | S2 | 5.0.12-beta-nt-log | Any (All) | Any | values() fails with 'ambiguous' or returns NULL with ON DUPLICATE and SELECT |
29253 | 2007-06-20 22:01 | 2007-07-23 1:06 | MySQL Server: CSV | Closed (6313 days) | S1 | 5.1.20 | Any | Any | csv table reportedly marked as crashed |
29680 | 2007-07-10 6:38 | 2007-08-07 20:00 | MySQL Server: Documentation | Closed (6298 days) | S3 | 5.0.46-BK, 5.0.41 | Any | Any | index_merge is used instead of (faster!) range |
30788 | 2007-09-04 10:33 | 2008-01-23 18:25 | MySQL Server | Closed (6129 days) | S1 | 5.0.45, 4.1, 5.1 BK | Any | Any | Inconsistent retrieval of char/varchar |
32097 | 2007-11-05 8:40 | 2007-11-05 18:37 | MySQL Server: Documentation | Closed (6208 days) | S3 | 5.1 | Any | Any | Term "statement" used wrongly |
39003 | 2008-08-25 11:34 | 2018-09-25 21:49 | Tools: MTR / mysql-test-run | Closed (5434 days) | S7 | 5.1, 5.4 | Any | Any | mtr's diff_files command failed in pushbuild without printing a result diff |
41984 | 2009-01-08 22:28 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Can't repeat (5697 days) | S3 | 5.1.22rc 5.1.30 GA | Any (Linux, Windows) | Any | inserts with auto-increment fails |
46374 | 2009-07-24 16:29 | 2018-10-01 16:17 | MySQL Server: Stored Routines | Closed (5355 days) | S6 | 5.4 | Any | Any | crash, INSERT INTO t1 uses function, function modifies t1 |
47753 | 2009-09-30 20:24 | 2022-12-04 20:45 | MySQL Server: Partitions | Duplicate (5492 days) | S3 | 5.5 WL#3352 | Any | Any | Partition by LIST COLUMN_LIST appears to require an order for value list items |
48465 | 2009-11-02 12:04 | 2011-02-16 23:44 | Tests: Replication | Can't repeat (5417 days) | S3 | 5.0 | Any | Any | rpl000012 failed on PB2 |
52580 | 2010-04-04 1:17 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Closed (5255 days) | S1 | 5.5.4-m3 | Any | Any | Crash in ha_innobase::open on executing INSERT with concurrent ALTER TABLE |
63280 | 2011-11-16 7:26 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Verified (4736 days) | S4 | 5.1,5.5 | Any | Any | add full_query param to mysqldump |
64559 | 2012-03-06 7:32 | 2012-03-13 14:42 | MySQL Server: DML | Verified (4625 days) | S4 | Any | Any | Add support of ANSI SQL syntax : INSERT INTO <table name> DEFAULT VALUES | |
68083 | 2013-01-14 14:41 | 2013-01-14 18:18 | MySQL Server | Not a Bug (4311 days) | S2 | 5.1.61 | Any | Any | Inserts that cannot progress that wait for a LOCK, innodb implicity kill them |
73190 | 2014-07-03 21:23 | 2017-04-17 13:36 | MySQL Server: mysqldump Command-line Client | Verified (3397 days) | S4 | Any | Any | [mysqldump] Support INSERT ... ON DUPLICATE KEY UPDATE for data dumps | |
84449 | 2017-01-09 19:08 | 2017-01-09 20:51 | MySQL Server: mysqldump Command-line Client | Verified (2855 days) | S3 | 5.5/5.6/5.7/8.0 | Any | Any | Signed zero not preserved by mysqldump/restore |
86486 | 2017-05-28 1:01 | 2017-11-16 10:02 | MySQL Server: Replication | Duplicate (2544 days) | S3 | 5.7.x | Any | Any | XA Transactions in binlog cause replication broken |
87352 | 2017-08-09 8:17 | 2017-08-09 9:37 | MySQL Cluster: Cluster (NDB) storage engine | Verified (2643 days) | S3 | 7.5.7 | Any | Any | "ndb_restore --print-sql-log" includes unnecessary SQL |
99573 | 2020-05-14 13:42 | 2020-05-14 14:12 | MySQL Server | Not a Bug (1634 days) | S3 | 8.0 | Any | Any | Converting UUID (String) to binary with before insert trigger fails |
108155 | 2022-08-16 16:22 | 2024-03-12 11:04 | MySQL Server: DML | Duplicate (236 days) | S3 | 8.0.30 | Any | Any | BEFORE INSERT trigger causes Error 1048 during UPDATE |
19551 | 2006-05-04 22:48 | 2006-05-04 22:51 | MySQL Server | Duplicate (6758 days) | S2 | 4.1.19 | Any (any) | Any | mysqldump with --delayed-insert and InnoDB |
37775 | 2008-07-01 15:46 | 2012-10-15 14:50 | Tests: Server | Unsupported (4402 days) | S3 | 6.0-BK,5.4 | Any | Any | main.locktrans_innodb and rpl.rpl_locktrans_innodb fail randomly |
38120 | 2008-07-15 7:28 | 2008-10-09 18:57 | MySQL Server: Partitions | Closed (5869 days) | S3 | 6.0-BK, 5.1 | Any | Any | main.partition fails sporadically |
40819 | 2008-11-18 12:22 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5687 days) | S3 | 5.0.67 - likely any | Any | Any | INSERT DELAYED documentation request |
41332 | 2008-12-09 16:01 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Duplicate (5774 days) | S1 | Cluster 6.3.20 | Any | Any | Insert into partitioned "ndbcluster" table causes server crash |
41424 | 2008-12-12 10:52 | 2018-09-25 21:50 | Tests: Replication | Can't repeat (5217 days) | S7 | 6.0-bugteam | Any | Any | rpl_ignore_table fails, "could not execute write_rows event" |
42519 | 2009-02-01 15:36 | 2010-01-04 15:47 | MySQL Server: Maria storage engine | Closed (5659 days) | S2 | 6.0-maria | Any | Any | Maria: RESTORE leads to corrupted table and assertion |
43001 | 2009-02-19 7:34 | 2021-05-23 20:45 | MySQL Server: Falcon storage engine | Duplicate (5709 days) | S3 | 6.0-TRUNK | Any | Any | maria.maria-no-logging fails sporadically on valgrind in PS mode |
46324 | 2009-07-21 15:42 | 2010-05-26 18:01 | MySQL Server: Falcon storage engine | Unsupported (5275 days) | S1 | 6.0.12-bzr | Any | Any | Crash during repeated INSERT ... SELECT if falcon debug mask includes 4 |
47052 | 2009-09-01 19:22 | 2020-05-03 20:45 | MySQL Server: Optimizer | Duplicate (5445 days) | S3 | 6.0 | Any | Any | wrong result, Subquery with VIEW containing BETWEEN |
47477 | 2009-09-21 10:13 | 2011-02-16 23:44 | Tests: Replication | Can't repeat (5389 days) | S3 | Any | Any | PB2: rpl_start_stop_slave failures | |
50192 | 2010-01-08 19:21 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5354 days) | S3 | 5.5.99-m3 | Any | Any | Strange effect in replication test, trigger, auto_increment |
50619 | 2010-01-26 11:02 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5046 days) | S3 | 5.1.44,5.5.99-m3,6.0.14-alpha | Any | Any | assert in handler::update_auto_increment |
51838 | 2010-03-08 17:29 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Won't fix (5343 days) | S2 | 5.0.84 | Any | Any | Innodb gets X lock for INSERT ON DUPLICATE KEY UPDATE but not INSERT SELECT |
53441 | 2010-05-05 15:45 | 2011-02-16 23:44 | MySQL Server: Stored Routines | Duplicate (5295 days) | S3 | 5.1.42 | Any | Any | Cursor does not fetch ts value from int column |
64892 | 2012-04-06 17:53 | 2012-08-13 16:22 | MySQL Server: Locking | Closed (4465 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | Session-level low_priority_updates does not work for INSERT |
69185 | 2013-05-09 15:23 | 2014-02-24 12:33 | MySQL Server: Replication | Verified (3905 days) | S2 | 5.1.69 | Any | Any | Replication breaks during concurrent INSERTs and LOAD DATA in a auto_inc table |
72011 | 2014-03-11 16:06 | 2014-03-17 21:33 | MySQL Server: Documentation | Not a Bug (3884 days) | S3 | 5.6 | Any | Any | Deadlock with 3 transactions (inserts) |
76710 | 2015-04-15 14:48 | 2015-04-16 7:36 | MySQL Server: Tests | Verified (3489 days) | S3 | 5.7.7 | Any | Any | myisam_views-big fails |
77183 | 2015-05-28 14:39 | 2020-04-18 0:32 | Connector / J | Closed (1660 days) | S2 | 5.1.35 | Any | Any | INSERT..VALUE..lead to invalidation of batch insert |
91026 | 2018-05-25 12:04 | 2018-06-18 12:06 | MySQL Server: DML | Not a Bug (2330 days) | S3 | 5.7 | Any | Any | Inconsistent behavior insert overflow decimal error-code and warn-code |
95070 | 2019-04-20 14:07 | 2019-05-02 13:09 | MySQL Server | Not a Bug (2012 days) | S3 | 8.0.15 | Any | x86 | INSERT .. VALUES ( .., (SELECT ..), ..) takes shared lock with READ-COMMITTED |
96722 | 2019-09-03 3:19 | 2019-12-10 6:37 | MySQL Server: Logging | Verified (1790 days) | S3 | 5.6.28, 5.6.45, 5.7.27 | Any | Any | Event does't record slow insert in slow log |
106009 | 2021-12-30 11:42 | 2021-12-31 14:57 | MySQL Server: DDL | Not a Bug (1038 days) | S3 | 8.0.27 | Any | Any | After INSERT ... SELECT, value of AUTO_INCREMENT becomes multiple of 8 |
114759 | 2024-04-24 8:52 | 2024-04-25 1:43 | MySQL Cluster: Cluster (NDB) storage engine | Duplicate (192 days) | S2 | 8.0.35-cluster MySQL Cluster Community S | Any (20.04) | Any | hang bug in mysql NDB cluster |
115064 | 2024-05-20 12:00 | 2024-06-03 10:01 | MySQL Server: DML | Not a Bug (153 days) | S3 | 8.0 | Any (rhel-7.4) | Any (x86-64) | Row size too large is reported for insert operation with a large amount of data |
116338 | 2024-10-10 18:59 | 2024-10-11 7:55 | MySQL Server: DML | Verified (23 days) | S3 | 8.0.39 | Any | Any | INSERT fails on virtual date column referring to datetime column |
2188 | 2003-12-22 8:22 | 2004-01-20 11:04 | MySQL Server | Closed (7593 days) | S2 | 4.1, 5.0 | Any (all) | Any | Query with select in field list doesn't work with prepared statements |
6460 | 2004-11-05 12:09 | 2004-11-09 3:04 | MySQL Server | Closed (7299 days) | S2 | 4.1.7 | Any (all) | Any | LEFT JOIN with multiple LIKE in WHERE produces wrong result |
13710 | 2005-10-03 11:41 | 2005-10-04 15:05 | MySQL Server: InnoDB storage engine | Closed (6970 days) | S1 | 5.0.14-pre | Any (All) | Any | Test case 'innodb' fails on checksum tests |
14056 | 2005-10-16 9:08 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5252 days) | S2 | 4.1, 5.0 | Any (All) | Any | Column prefix index on UTF-8 primary key column causes 'Can't find record..' |
20543 | 2006-06-19 17:27 | 2006-08-18 12:34 | MySQL Server: Views | Closed (6652 days) | S1 | 5.0 | Any | Any | select on information_schema strange warnings, view, different schemas/users |
22436 | 2006-09-18 9:55 | 2006-11-06 14:46 | MySQL Server: Tests | Closed (6572 days) | S3 | 5.0.25 | Any (All) | Any | Four tests require "innodb" to be configured, fail in "classic" build |
22820 | 2006-09-29 11:49 | 2022-03-06 20:45 | MySQL Server: MyISAM storage engine | No Feedback (6024 days) | S3 | 5.1.12 | Any (*) | Any | INSERT DELAYED does not behave like normal insert |
25025 | 2006-12-13 3:58 | 2007-05-16 19:53 | Connector / J | Closed (6381 days) | S2 | 5.0.x, 3.1.x | Any (any) | Any | Connector/J getRewriteBatchedStatements() should be more forgiving of comments |
27006 | 2007-03-09 16:19 | 2007-03-20 16:34 | MySQL Server: Stored Routines | Closed (6438 days) | S1 | 5.0.36 | Any (All) | Any | AFTER UPDATE triggers not fired with INSERT ... ON DUPLICATE KEY UPDATE |
27954 | 2007-04-19 14:23 | 2007-05-10 18:07 | MySQL Server: General | Closed (6387 days) | S1 | 5.0.38 | Any | Any | INSERT ... ON DUPLICATE KEY UPDATE fails with large multi-insert |
28650 | 2007-05-24 11:09 | 2007-06-24 12:29 | MySQL Server: Stored Routines | No Feedback (6342 days) | S3 | 5.0 | Any | Any | problem facing with triggers |
29290 | 2007-06-22 0:06 | 2007-11-21 20:23 | MySQL Server: Tests | Closed (6192 days) | S3 | 5.1 | Any | Any | type_datetime.test failure in 5.1 |
29628 | 2007-07-08 18:01 | 2015-08-10 14:33 | MySQL Server: mysqldump Command-line Client | Verified (6327 days) | S4 | 5.0.38 | Any | Any | mysqldump should put newlines between VALUES when using extended inserts |
30408 | 2007-08-14 15:48 | 2007-08-29 18:47 | MySQL Server: Tests | Closed (6276 days) | S3 | 5.1.21 | Any | Any | Suite "parts" needs bug numbers updated |
30861 | 2007-09-06 12:51 | 2007-09-06 12:53 | MySQL Server | Open (6268 days) | S4 | any | Any | Any | an interesting and useful clause |
31305 | 2007-09-30 16:08 | 2007-11-26 19:00 | MySQL Server: MyISAM storage engine | Closed (6187 days) | S1 | 4.0.26, 4.1.21, 5.1.23, 5.0.48, 6.0.4 | Any | Any | myisam tables crash when they are near capacity |
33534 | 2007-12-27 13:12 | 2008-02-20 20:57 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6101 days) | S2 | MySQL Cluster CGE 6.3 | Any | Any | Bad performance of INSERT's in auto_incremented tables |
36545 | 2008-05-06 18:52 | 2008-06-11 18:54 | MySQL Server: Falcon storage engine | Closed (5989 days) | S1 | 6.0.5 | Any | Any | Falcon assertion in Table::insert, ASSERT(ret) fails. |
37016 | 2008-05-27 19:25 | 2011-02-16 23:43 | MySQL Server: DDL | Closed (5757 days) | S3 | 5.1, 6.0-bk | Any | Any | TRUNCATE TABLE removes some rows but not all |
37883 | 2008-07-04 16:24 | 2018-09-25 21:47 | Tests: Replication | Duplicate (5932 days) | S7 | 5.1.26-rc | Any | Any | Failures in rowbased replication: Test "rpl_row_basic_{2myisam,3innodb}" (3) |
38369 | 2008-07-25 10:24 | 2018-09-25 21:48 | Tests: Replication | Closed (5877 days) | S7 | 5.1 | Any | Any | rpl_ndb.rpl_row_basic_7ndb fails |
38900 | 2008-08-19 20:14 | 2011-02-16 23:43 | MySQL Server | Duplicate (5918 days) | S2 | 5.0.66a | Any | Any | mysql_insert_id() and possibly last_insert_id() incorrect |
39358 | 2008-09-10 5:38 | 2008-10-04 6:53 | MySQL Server: Locking | Not a Bug (5874 days) | S3 | 5.0.51-log | Any | Any | Concurrency locks causes deadlocks |
40892 | 2008-11-20 16:10 | 2009-01-08 10:38 | MySQL Server: Maria storage engine | Closed (5778 days) | S1 | 6.0.8-release | Any | Any | maria: Livelock in sysbench OLTP_RW test |
41186 | 2008-12-02 19:54 | 2018-09-25 21:50 | Tests: Replication | Duplicate (5784 days) | S7 | 6.0-rpl, 5.1 | Any | Any | rpl_stm_mystery22 fails sporadically on pushbuild while waiting for slave start |
45387 | 2009-06-09 8:04 | 2011-02-16 23:44 | MySQL Server | Won't fix (5539 days) | S3 | 5.1, 6.0 bzr | Any | Any | Information about statement id for prepared statements missed from general log |
46654 | 2009-08-11 15:15 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5355 days) | S3 | 5.4.4-alpha | Any | Any | False deadlock on concurrent DML/DDL with partitions, inconsistent behavior |
47381 | 2009-09-16 16:00 | 2012-05-18 20:19 | MySQL Server: DDL | Duplicate (5526 days) | S3 | 5.1,5.4 | Any | Any | Wrong warning about crashed table, CREATE TABLE IF NOT EXISTS AS SELECT |
47752 | 2009-09-30 17:56 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5470 days) | S3 | 5.5 WL#3352 | Any | Any | Partition by LIST COLUMN_LIST only recognizing last defined partition |
50511 | 2010-01-21 15:27 | 2011-02-16 23:44 | MySQL Server | Closed (5294 days) | S3 | 5.1.43,5.5.99-m3,6.0.14-alpha | Any | Any | Sometimes wrong handling of user variables containing NULL |
52473 | 2010-03-30 12:51 | 2021-05-02 20:45 | MySQL Cluster: Replication | Verified (5307 days) | S3 | mysql-5.1-telco-6.3 | Any | Any | NDB inserts row when updating slave's empty table (with PK) |
52522 | 2010-04-01 11:43 | 2011-02-16 23:44 | MySQL Server: Security: Privileges | Duplicate (5281 days) | S3 | 5.5.3-m3 | Any | Any | Running mysql_upgrade loses trigger privileges |
58674 | 2010-12-02 20:42 | 2011-04-21 0:37 | MySQL Server: Stored Routines | Closed (4945 days) | S3 | 5.5.6, 5.5.8 | Any | Any | Unsafe warnings are still produced after unsafety has been eliminated |
59570 | 2011-01-17 21:22 | 2012-10-15 13:41 | Tests: Server | Closed (4402 days) | S3 | 5.5.8 | Any | Any | in_multicolumn_calendar_unique_constraint_ignore fails with wrong TZ |
60560 | 2011-03-21 3:49 | 2011-03-26 10:13 | MySQL Server: Query Cache | Unsupported (4971 days) | S4 | any | Any | Any | insert and query cache |
61213 | 2011-05-18 9:49 | 2014-06-10 7:08 | Connector / J | Closed (3818 days) | S2 | 5.1.16 | Any | Any | ON DUPLICATE KEY UPDATE breaks generated key list when extended INSERT is used |
65581 | 2012-06-11 10:07 | 2012-06-18 6:37 | MySQL Server: InnoDB storage engine | Verified (4528 days) | S3 | 5.5 | Any | Any | INSERT statement can be delayed by SELECT ... LOCK. |
68332 | 2013-02-10 16:34 | 2013-02-11 21:32 | MySQL Server: General | Can't repeat (4283 days) | S2 | 5.5.30,5.6.10 | Any | Any | Value for mysql_affected_rows() became 1 for ON DUPLICATE KEY after 5.5.15 |
69679 | 2013-07-05 17:23 | 2014-06-19 5:57 | MySQL Server: Charsets | Not a Bug (3790 days) | S3 | 5.5.32 | Any | Any | utf8mb4_general_ci considers from u+20000 characters as identical |
71832 | 2014-02-25 21:40 | 2024-10-18 12:38 | Connector / NET | Verified (3588 days) | S3 | 6.8.3, 6.9.5 | Any | Any | Connector/NET batch insert not working (UpdateBatchSize) |
72364 | 2014-04-17 9:46 | 2019-11-18 22:53 | MySQL Server: DML | Closed (1812 days) | S3 | 5.5.37 | Any | Any | insert ignore was not rollbacked after KILL QUERY |
76533 | 2015-03-30 14:34 | 2015-03-31 16:20 | MySQL Server: InnoDB storage engine | Verified (3506 days) | S3 | 5.5.41, 5.6.22 | Any | Any | AUTO_INC lock seems to be NOT set for INSERT INTO t(val) SELECT val FROM t |
76563 | 2015-04-01 15:26 | 2017-06-01 14:20 | MySQL Server: Documentation | Closed (2712 days) | S3 | 5.5, 5.6, 5.7 | Any | Any | Manual does NOT explain when exactly AUTO-INC lock is set for "bulk inserts" |
77639 | 2015-07-07 12:40 | 2019-12-11 1:09 | MySQL Server: Optimizer | Closed (1850 days) | S4 | 5.7 | Any | Any | Implement VALUES equivalent to a query specification |
78508 | 2015-09-22 3:20 | 2015-09-22 12:19 | MySQL Server: DML | Not a Bug (3330 days) | S3 | 5.6.22 | Any | Any | Subquery result with aggregate function() in outer table is not understandable |
79565 | 2015-12-09 7:11 | 2015-12-09 8:34 | MySQL Server: DML | Verified (3252 days) | S3 | 5.7.8,5.5.48, 5.6.29, 5.7.9 | Any | Any | Function insert work incorrectly with multiple-type utf8 character |
82805 | 2016-08-31 2:20 | 2016-08-31 9:47 | MySQL Server: Optimizer | Verified (2986 days) | S2 | 5.7.10, 5.7.14 | Any | Any | Having clause condition fails on join table with TEXT field |
85224 | 2017-02-28 10:59 | 2020-05-19 8:07 | MySQL Server: Charsets | Closed (2785 days) | S3 | 8.0.1 | Any | Any | Illegal mix of collations for time/varchar |
85562 | 2017-03-21 9:48 | 2017-12-22 8:42 | MySQL Server: Security: Roles | Can't repeat (2508 days) | S2 | 8.0 | Any | Any | dropping a role does not remove privileges from active users |
89148 | 2018-01-08 22:23 | 2019-06-04 1:24 | MySQL Server: Group Replication | Verified (2456 days) | S4 | 5.7.20 and 8.0.3 | Any | Any | The timestamp of the GITD events in the GR relay log look wrong. |
99199 | 2020-04-07 10:51 | 2021-01-02 20:00 | MySQL Visual Studio Integration | Duplicate (1572 days) | S3 | 1.2.9 | Any | Any | TableAdapter config Advanced Option "Refresh the datatable" is ignored |
101727 | 2020-11-24 4:07 | 2020-11-24 6:44 | MySQL Server: DML | Duplicate (1440 days) | S3 | 8.0.20, 5.7.32, 8.0.22 | Any | Any | insert null into a not null column in the empty SQL mode is not consistent |
101889 | 2020-12-07 9:45 | 2020-12-07 11:43 | MySQL Server: DML | Can't repeat (1427 days) | S3 | 8.0 | Any | Any | Potentially wrong results |
102238 | 2021-01-12 20:35 | 2023-12-21 8:49 | MySQL Server: InnoDB storage engine | Closed (318 days) | S5 | 8.0.22 | Any | Any | log_writer uses too much CPU on small servers |
102755 | 2021-02-27 17:19 | 2021-04-06 12:34 | MySQL Server: InnoDB storage engine | Duplicate (1307 days) | S5 | 5.7 | Any | Any | Error 1062 locks unique index and do not release until commit or rollback |
109087 | 2022-11-15 2:15 | 2022-11-15 7:13 | MySQL Server: DML | Verified (719 days) | S4 | 8.0 | Any | Any | Automatically optimize the insertion order when INSERT |
109217 | 2022-11-28 9:51 | 2022-12-12 3:19 | MySQL Server: Replication | Verified (692 days) | S2 | 5.7.40 | Any | Any | The datas of master and standby are inconsistent for Spatial Data Formats |
111703 | 2023-07-10 6:40 | 2023-07-15 1:58 | MySQL Server: Documentation | Not a Bug (477 days) | S3 | 8.0.33, 5.7.42 | Any | Any | INSERT ON DUPLICATE KEY locks INSERT if table have many PRIMARY and UNIQUE key |
113098 | 2023-11-16 2:55 | 2023-11-24 7:00 | Connector / J | Duplicate (352 days) | S3 | 8.1.0 | Any | Any | Inconsistent Execution of Batch Queries with rewriteBatchedStatements=true |
113462 | 2023-12-19 16:05 | 2023-12-20 15:06 | MySQL Server: Optimizer | Verified (319 days) | S3 | 8.0 | Any | Any | Incorrect result |
114237 | 2024-03-06 6:57 | 2024-03-06 8:30 | MySQL Server: Optimizer | Verified (242 days) | S5 | 8.2.0, 8.3.0 | Any | Any | Unexpected Cardinality by Index |
114446 | 2024-03-21 14:30 | 2024-04-22 10:14 | MySQL Server: InnoDB storage engine | Not a Bug (227 days) | S3 | 8.0.* | Any | Any | A deadlock example cause by lock inherit |
115194 | 2024-06-03 6:24 | 2024-06-03 13:43 | MySQL Server: Documentation | Verified (153 days) | S3 | 8.0 | Any | Any | Incorrect description of Online DDL Operations in reference manual |
115470 | 2024-07-01 3:25 | 2024-08-02 12:10 | MySQL Server | Not a Bug (93 days) | S3 | 8.0.35 | Any | Any | The precision of avg () is lost when multiple tables are joined. |
115978 | 2024-09-02 7:06 | 2024-09-04 15:01 | MySQL Server | Duplicate (60 days) | S1 | 8.0 | Any | Any | Inconsistent results at the serializable isolation level |
511 | 2003-05-26 13:48 | 2003-05-31 16:53 | MySQL Server | Duplicate (7827 days) | S4 | 4.X | Any (ALL) | Any | INSERT as SELECT from the same table must be unlocked |
1331 | 2003-09-18 5:39 | 2003-10-04 6:44 | MySQL Server: Replication | Closed (7701 days) | S2 | 4.1 | Any (all) | Any | Unexistent user variable is not replicated |
2491 | 2004-01-23 5:54 | 2004-03-11 10:27 | MySQL Server: Replication | Closed (7542 days) | S2 | 4.0 | Any (all) | Any | INSERT DELAYED causes binary log unusable by mysqlbinlog (replication is ok) |
3275 | 2004-03-23 14:14 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5751 days) | S4 | Any | Any | INSERT INTO table1 AS alias1 - to easier use of LOCK TABLES table1 AS alias1 | |
8475 | 2005-02-12 14:19 | 2005-03-08 0:35 | MySQL Server | Closed (7180 days) | S3 | 4.1 | Any (all) | Any | If multi-query: query does not get into slow query log if it's not last |
10396 | 2005-05-05 19:03 | 2011-02-16 23:43 | MySQL Server: Command-line Clients | Verified (7083 days) | S4 | 4.1 | Any (any) | Any | UPDATE... [ON NONE FOUND INSERT] |
11442 | 2005-06-20 2:25 | 2011-02-16 23:43 | MySQL Server: DML | Verified (6521 days) | S4 | 5.0 | Any (All) | Any | INSERT... ON DUPLICATE KEY UPDATE; w/ values taken from the INSERT part |
25194 | 2006-12-20 3:55 | 2013-03-03 20:45 | MySQL Server: Federated storage engine | Verified (5204 days) | S4 | 5.1, 5.5 | Any (*) | Any | please implement bulk inserts for federated table |
27650 | 2007-04-04 13:24 | 2007-05-01 17:45 | MySQL Server | Closed (6396 days) | S1 | 5.0.38, 5.x | Any | Any | ON DUPLICATE KEY UPDATE fails when setting UNIQUE values with multi row inserts |
28249 | 2007-05-04 16:01 | 2007-07-23 20:23 | MySQL Server | Closed (6313 days) | S2 | 5.0.42/5,1 | Any | Any | Query Cache returns wrong result with concurrent insert / certain lock |
28412 | 2007-05-14 11:35 | 2011-02-16 23:43 | MySQL Server: General | Verified (6383 days) | S4 | 5.0.41 | Any | Any | insert_id in OK Packet not working with multiple rows INSERT |
28505 | 2007-05-18 0:19 | 2007-06-19 0:56 | MySQL Server | Closed (6347 days) | S2 | 3.1.10, and 5.0.6 | Any | Any | Update count for an INSERT DUPLICATE KEY not correct when CLIENT_FOUND_ROWS set |
28829 | 2007-06-01 10:01 | 2012-05-18 20:19 | MySQL Server: Replication | Duplicate (6353 days) | S2 | 4.1.21,5.0.44 | Any | Any | replication breaks due to binlogs events written in wrong order |
31243 | 2007-09-27 14:40 | 2007-11-01 12:49 | MySQL Server: Tests | Closed (6212 days) | S3 | 5.1.22 | Any | Any | Test "partition_basic_myisam" truncates path names |
34447 | 2008-02-10 14:46 | 2012-05-18 20:19 | MySQL Server: Replication | Duplicate (6073 days) | S1 | 5.1-BK | Any | Any | replication failure on DELETE after INSERT on an unrelated table |
34472 | 2008-02-11 20:51 | 2008-02-13 16:44 | MySQL Server: General | Can't repeat (6108 days) | S3 | 6.0.5 | Any | Any | Buffer overrun condition in strmake() |
34488 | 2008-02-12 12:50 | 2008-10-31 19:24 | MySQL Server: MyISAM storage engine | Not a Bug (5847 days) | S3 | 5.0.54 | Any | Any | Cardinality stats wrong after first analyze against MyISAM table |
34627 | 2008-02-17 16:21 | 2008-05-21 14:10 | MySQL Server: Falcon storage engine | Closed (6010 days) | S3 | 6.0.4 | Any | Any | Falcon potential deadlock in Bdb::addRef |
35178 | 2008-03-10 9:12 | 2008-04-05 7:01 | MySQL Server: Replication | Closed (6056 days) | S1 | 5.0.51a | Any | Any | INSERT_ID not written to binary log for inserts against BLACKHOLE backed tables |
35224 | 2008-03-11 16:07 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Closed (5356 days) | S3 | 5.1-bk | Any | Any | mysqldump --help is very confusing |
35386 | 2008-03-18 9:39 | 2014-09-17 4:39 | MySQL Server: DML | Won't fix (3700 days) | S3 | 5.1.22 | Any | Any | Insert delayed statements insert 1 + limit records instead of just limit records |
35703 | 2008-03-31 11:03 | 2008-05-02 20:51 | MySQL Server: DML | No Feedback (6029 days) | S3 | Any | Any | Max_delayed_thread does not make delayed insert threads as normal insert | |
35991 | 2008-04-11 11:29 | 2008-10-05 14:59 | MySQL Server: Falcon storage engine | Closed (5873 days) | S3 | 6.0-falcon-team | Any | Any | Falcon assertion on TRUNCATE in Section::getSectionPage Section.cpp line 198 |
36443 | 2008-04-30 22:14 | 2011-02-16 23:43 | MySQL Server: Replication | Closed (5942 days) | S1 | 5.1.24-rc-community-log, 5.1.26 | Any | Any | Server crashes when executing insert when insert trigger on table |
36534 | 2008-05-06 13:54 | 2018-09-09 20:45 | MySQL Server: DML | Verified | S4 | all | Any | Any | sql_mode traditional restrictions affect data manipulation queries only |
36898 | 2008-05-22 22:24 | 2008-05-25 10:04 | MySQL Server: DML | Not a Bug (6006 days) | S3 | 5.0.51 | Any | Any | INSERT ... ON DUPLICATE KEY UPDATE seem to compute wrong, if a new row is insert |
37456 | 2008-06-17 19:03 | 2018-04-08 20:45 | MySQL Server: Embedded Library ( libmysqld ) | Verified (5877 days) | S2 | 5.1+ | Any | Any | funcs_1: Several tests crash when used with embedded server |
37718 | 2008-06-28 11:48 | 2018-09-25 21:47 | Tests: Replication | Closed (5697 days) | S7 | 5.1 | Any | Any | rpl.rpl_stm_mystery22 fails sporadically on pushbuild |
39017 | 2008-08-25 17:34 | 2015-06-28 20:45 | MySQL Server: Backup | Duplicate (5913 days) | S3 | 6.0.7 | Any | Any | backup_default test fails in pushbuild |
39931 | 2008-10-08 13:29 | 2011-02-16 23:43 | Tests: Replication | Closed (5759 days) | S3 | 5.0 | Any | Any | random failures of rpl.rpl_temporary |
39985 | 2008-10-11 19:32 | 2011-02-16 23:43 | MySQL Server: Embedded Library ( libmysqld ) | Verified | S2 | 5.1+ | Any | Any | INSERT ... SELECT on a I_S table leads to a assertion on the embedded server |
40025 | 2008-10-14 16:06 | 2008-11-05 21:11 | MySQL Server: Maria storage engine | Can't repeat (5842 days) | S1 | 6.0-bzr | Any | Any | Maria deadlock in translog_buffer_lock, _ma_unlock_key_del, wait_for_update_bin |
41661 | 2008-12-20 22:04 | 2009-05-15 13:40 | MySQL Server: Falcon storage engine | Closed (5651 days) | S1 | 6.0-falcon-team | Any | Any | Falcon assertion (ret) failed at line 3052 in file Table.cpp |
42491 | 2009-01-30 19:44 | 2011-02-16 23:43 | MySQL Server: Storage Engines | Duplicate (5756 days) | S2 | 5.1.30 | Any | Any | INSERT on temporary table may pass incorrect lock type to storage engine |
42640 | 2009-02-06 7:17 | 2011-02-16 23:43 | MySQL Server | Closed (5651 days) | S2 | 5.1-bugteam, 5.1 | Any | Any | mysqld crashes when unsafe statements are executed (STRICT_TRANS_TABLES mode) |
42828 | 2009-02-13 12:40 | 2009-05-15 15:10 | MySQL Server: Falcon storage engine | Closed (5651 days) | S1 | 6.0-falcon-team | Any | Any | Falcon crash in Table::checkUniqueRecordVersion - transaction = 0x0 |
43344 | 2009-03-03 22:14 | 2010-05-26 17:59 | MySQL Server: Falcon storage engine | Unsupported (5275 days) | S2 | 6.0.10-alpa | Any | Any | falcon_recovery assert "dup->state == recDeleted" in Table::checkUniqueRecordVer |
45642 | 2009-06-21 20:35 | 2011-02-16 23:44 | MySQL Workbench | Closed (5610 days) | S2 | 5.1.14RC | Any | Any | Generated INSERT statements don't have database name |
46130 | 2009-07-11 13:34 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5527 days) | S3 | 5.1+ | Any | Any | Slave does not correctly handle "expected errors" |
46179 | 2009-07-14 18:07 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (2134 days) | S2 | 5.6, 5.7, 8.0 | Any | Any | set new.colname = default(colname) in trigger elicits a crazy error message |
46961 | 2009-08-27 17:28 | 2011-02-16 23:44 | MySQL Server: Archive storage engine | Closed (5434 days) | S1 | 5.1.37, 5.1.39 | Any | Any | archive engine loses rows during join when results approach join_buffer_size |
49186 | 2009-11-29 13:52 | 2011-02-16 23:44 | MySQL Server: Replication | Can't repeat (5438 days) | S3 | 5.1.41, 5.5.0 | Any | Any | Concurrent insert/select causes slave abort if select is under read committed |
49625 | 2009-12-11 15:28 | 2009-12-14 18:03 | MySQL Server: Stored Routines | Not a Bug (5438 days) | S1 | 5.0.51 | Any (Unknown host OS) | Any | Stored procedure that calls UUID() calls resuting Insert Statement multipe times |
51193 | 2010-02-15 16:45 | 2015-02-04 22:35 | MySQL Server: Documentation | Closed (3560 days) | S3 | 5.1 | Any | Any | Update 1.8.5.2 Transactions and Atomic Operations in the reference manual |
51509 | 2010-02-25 15:09 | 2011-12-16 7:55 | Connector / J | Closed (4706 days) | S3 | 5.1.12 | Any | Any | allowMultiQueries option is ignored if used with PreparedStatement |
52020 | 2010-03-12 21:49 | 2017-12-22 8:24 | MySQL Server: InnoDB storage engine | Closed (4687 days) | S3 | 5.0, 5.1.46 | Any | Any | InnoDB can still deadlock on just INSERT...ON DUPLICATE KEY |
52520 | 2010-04-01 10:57 | 2011-02-16 23:44 | MySQL Server: Charsets | Closed (5219 days) | S3 | 5.5.3-m3 | Any | Any | Difference in tinytext utf column metadata |
54560 | 2010-06-16 18:58 | 2011-02-16 23:44 | MySQL Server | Closed (5248 days) | S3 | 5.1, 4.1, 5.0, 5.6.99 | Any | Any | Docs for REPLACE are not accurate |
56688 | 2010-09-09 12:04 | 2010-09-09 14:22 | Connector / J | Not a Bug (5169 days) | S2 | 5.1.13 | Any | Any | JDBC - insert error - field doesn't have a default value - NOT NULL field |
57623 | 2010-10-21 10:43 | 2011-03-02 3:16 | MySQL Server: Optimizer | Closed (4995 days) | S1 | mysql-next-mr-opt-backporting | Any | Any | subquery within before insert trigger causes crash (semijoin=on) |
61468 | 2011-06-09 21:54 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Verified (4895 days) | S4 | Any | Any | mysqldump values() group size | |
61502 | 2011-06-13 14:02 | 2011-08-04 21:32 | MySQL Server: Locking | Not a Bug (4840 days) | S2 | 5.5.10 | Any | Any | deadlock on insertion - insert holds and waits on same lock |
62696 | 2011-10-12 9:36 | 2011-11-09 15:38 | MySQL Server: Parser | Verified (4771 days) | S3 | 5.5.17, 5.6.4-m5 | Any | Any | Using a numeric operator on a TIME column should return an error or warning |
63126 | 2011-11-07 2:16 | 2011-12-07 7:00 | MySQL Server: Data Types | No Feedback (4715 days) | S3 | 5.5.16 | Any | Any | cannot perform a precise calculation with decimal data |
63128 | 2011-11-07 9:40 | 2014-06-26 22:27 | MySQL Server: Documentation | Closed (3783 days) | S3 | 5.1 5.5 | Any | Any | explanation of the behavior of innodb_autoinc_lock_mode = 1 with INSERT IGNORE |
66301 | 2012-08-10 8:46 | 2013-04-22 20:28 | MySQL Server: InnoDB storage engine | Closed (4213 days) | S2 | 5.1, 5.5 | Any | Any | INSERT ... ON DUPLICATE KEY UPDATE + innodb_autoinc_lock_mode=1 is broken |
68446 | 2013-02-20 23:36 | 2013-02-22 14:56 | MySQL Server: DML | Closed (4272 days) | S3 | 5.5.29 | Any | Any | insert on duplicate key update with null autoincremented PK uses wrong pk value |
69228 | 2013-05-14 14:56 | 2022-05-23 9:39 | MySQL Server: Data Types | Verified (4191 days) | S2 | 5.6, probably since 4.1 | Any | Any | Last insert ID incorrectly delivered to the client |
70555 | 2013-10-08 17:29 | 2013-10-09 8:03 | MySQL Server: Optimizer | Verified (4043 days) | S3 | 5.6.14 | Any | Any | EXPLAIN for INSERT ... SELECT waits for table lock |
71232 | 2013-12-26 11:34 | 2014-07-04 9:51 | MySQL Server: InnoDB storage engine | Verified (3775 days) | S3 | 5.6.15 | Any | Any | Wrong behaviour for auto_increment unsigned bigint column approaching max value |
71947 | 2014-03-05 18:55 | 2014-03-06 5:18 | MySQL Server: Partitions | Verified (3895 days) | S3 | 5.6, 5.7 | Any | Any | Unexpected change in error code on INSERT .. PARTITION causes replication abort |
72367 | 2014-04-17 11:48 | 2014-04-17 13:03 | MySQL Server: DML | Not a Bug (3853 days) | S2 | 5.7.4 | Any | Any | DELAYED is documented as deprecated, but it is acutally non-functional |
78203 | 2015-08-25 9:16 | 2015-08-26 15:33 | MySQL Server: DML | Not a Bug (3357 days) | S3 | 5.6.22 | Any | Any | Inconsistent behaviors when auto_increment_offset is ignored(>auto..._increment) |
78934 | 2015-10-23 4:14 | 2015-10-26 13:37 | MySQL Server: DML | Not a Bug (3296 days) | S3 | 5.7.8 | Any | Any | Failed INSERT(Dup entry) still change LAST_INSERT_ID() for auto_increment col |
79204 | 2015-11-10 12:38 | 2016-02-04 19:57 | MySQL Server: Optimizer | Closed (3260 days) | S3 | 5.7.10 | Any | Any | INSERT INTO table from SELECT accepts to insert into generated columns |
81491 | 2016-05-18 15:05 | 2016-05-18 18:13 | MySQL Server: Optimizer | Not a Bug (3091 days) | S3 | 5.5.49-c11 | Any | Any | delete then insert multiple values produces data in wrong order. |
85266 | 2017-03-02 6:15 | 2018-10-21 20:45 | Connector / ODBC | No Feedback (2757 days) | S3 | 5.03.07.00 | Any | Any | Array Insert is not working as expected. |
86019 | 2017-04-20 11:44 | 2017-06-14 13:35 | MySQL Server: Documentation | Closed (2699 days) | S3 | 5.6.35 | Any | Any | explicit_defaults_for_timestamp and timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP |
86078 | 2017-04-25 19:14 | 2018-04-12 7:51 | MySQL Server: Replication | Closed (2397 days) | S2 | 8.0.1 | Any | Any | Bad Write Set tracking with UNIQUE KEY on a DELETE followed by an INSERT. |
89194 | 2018-01-11 19:14 | 2018-04-11 16:23 | MySQL Server: Group Replication | Duplicate (2398 days) | S2 | 5.7.20, 8.0.3 | Any | Any | Wrong certification lead to data inconsistency and GR breakage. |
93806 | 2019-01-03 17:41 | 2020-09-21 14:21 | MySQL Server: Documentation | Closed (2083 days) | S3 | all | Any | Any | Document error about "ON DUPLICATE KEY UPDATE " |
94929 | 2019-04-07 8:38 | 2019-04-08 12:25 | MySQL Server: DML | Verified (2036 days) | S3 | 8.0.15, 5.7.25 | Any | Any | Generated column vs before insert trigger calculation order |
96328 | 2019-07-25 10:37 | 2019-07-25 13:04 | MySQL Server | Not a Bug (1928 days) | S3 | all | Any | Any | INSERT ... ON DUPLICATE KEY UPDATE |
100746 | 2020-09-04 19:40 | 2020-09-04 21:09 | MySQL Server: DML | Verified (1521 days) | S3 | 5.7.31, 8.0 | Any | x86 | user variable in select causes view to be non-insertable |
101269 | 2020-10-22 3:26 | 2022-04-11 9:06 | MySQL Server: Optimizer | Duplicate (937 days) | S1 | 5.7, 8.0, 8.0.22, 5.7.32 | Any | Any | using different index may produce different results |
102776 | 2021-03-02 7:10 | 2021-03-04 9:19 | MySQL Server: C API (client library) | Not a Bug (1341 days) | S3 | 8.0.22 | Any | Any | insert into select on tinyint type, no warning, but with wrong result |
103216 | 2021-04-06 8:30 | 2021-04-07 4:44 | MySQL Server: InnoDB storage engine | Not a Bug (1306 days) | S3 | 8.0.22,8.0.23 | Any | Any | create table failed with ENCRYPTION set to Y after ALTER MASTER KEY crash |
103837 | 2021-05-28 9:32 | 2021-05-28 9:54 | MySQL Server: Logging | Verified (1255 days) | S4 | All, 8.0 | Any | Any | Suggest to add materialized view log for innodb tables |
113355 | 2023-12-06 17:45 | 2024-04-18 15:27 | MySQL Server: DDL | Verified (199 days) | S3 | 8.0 | Any | Any | DROP/RENAME index, increase VARCHAR should really be ALGORITHM=INSTANT |
115496 | 2024-07-03 8:18 | 2024-07-03 9:00 | MySQL Server: Locking | Unsupported (123 days) | S3 | 5.6.16, 5.6.51, 5.7.1 | Any | Any | UPDATE and INSERT...ON DUPLICATE KEY UPDATE... cause dead lock |
115740 | 2024-08-01 9:21 | 2024-08-02 12:29 | MySQL Server: Command-line Clients | Verified (94 days) | S4 | 8.0 | Any | Any | Binary log shows different separator in Date type |
4 | 2002-10-29 19:45 | 2002-12-02 12:01 | MySQL Server | Closed (8007 days) | S3 | 4.0.5 | Any (all) | Any | BETWEEN not working properly with timestamp / datetime |
491 | 2003-05-24 7:40 | 2003-07-01 5:38 | MySQL Server: Replication | Closed (7796 days) | S3 | 4.0.13 | Any (all) | Any | If INSERT SELECT fails in a MyISAM table but has changed row, nothing in binlog |
3309 | 2004-03-26 17:59 | 2005-03-07 19:10 | MySQL Server | Closed (7181 days) | S2 | 3.23, 4.0 and up | Any (any) | Any | Netmask matching for 'Host' doesn't work. |
4124 | 2004-06-14 7:16 | 2004-06-21 10:28 | MySQL Server: Replication | Closed (7440 days) | S4 | All | Any (All) | Any | Replication Optimization |
6946 | 2004-12-02 14:31 | 2006-02-14 14:28 | MySQL Server | Won't fix (6837 days) | S4 | * | Any (*) | Any | INSERT ... ON DUPLICATE KEY UPDATE without INSERT |
7806 | 2005-01-11 15:45 | 2005-04-27 1:43 | MySQL Server | Closed (7130 days) | S3 | 4.1.11 | Any (*) | Any | insert on duplicate key and auto-update of timestamp |
9676 | 2005-04-06 11:57 | 2006-07-06 19:02 | MySQL Server: Optimizer | Closed (6695 days) | S3 | 4.1 | Any (any) | Any | INSERT INTO x SELECT .. FROM x LIMIT 1; slows down with big tables |
14400 | 2005-10-27 16:15 | 2006-09-22 15:27 | MySQL Server: MyISAM storage engine | Closed (6617 days) | S2 | 3.23, 4.0, 4.1, 5.0 | Any (any) | Any | Query joins wrong rows from table which is subject of "concurrent insert" |
15193 | 2005-11-23 16:49 | 2005-12-12 21:25 | MySQL Server | Won't fix (6901 days) | S3 | Any | Any | 'select' priv required when deleting from table with where clause | |
15520 | 2005-12-06 14:26 | 2006-05-03 17:56 | MySQL Server: Documentation | Closed (6759 days) | S3 | all | Any (all) | Any | "Optimize table" wants INSERT privs? |
17144 | 2006-02-05 21:31 | 2008-10-04 18:34 | MySQL Server: Security: Privileges | Unsupported (5874 days) | S4 | 4.0 and above | Any (*) | Any | Missing default values in user table complicate insert into user table |
20195 | 2006-06-01 11:55 | 2006-06-22 14:31 | MySQL Server | Closed (6709 days) | S2 | 5.0.22 | Any (All) | Any | INSERT DELAYED with auto_increment is assigned wrong values |
20291 | 2006-06-06 12:37 | 2013-11-12 8:36 | MySQL Server: Errors | Closed (4009 days) | S3 | 5.0.44, 5.0.23-BK, 4.1.20 and 5.0.22 | Any (*) | Any | SELECT with no tables but a derived table resets warning list, contrary to docs |
24079 | 2006-11-08 9:39 | 2006-12-07 22:31 | MySQL Server: Falcon storage engine | Closed (6541 days) | S1 | 5.2 | Any | Any | strange errors around INSERT getting duplicate key, but one row is inserted |
26238 | 2007-02-09 21:21 | 2007-03-15 3:20 | MySQL Server: General | Closed (6443 days) | S1 | 5.0.36 | Any (*) | Any | inserted delayed always inserts 0 for BIT columns |
26418 | 2007-02-15 18:00 | 2007-07-18 16:46 | MySQL Server: Replication | Closed (6318 days) | S2 | 5.1 | Any | Any | Slave out of sync after CREATE/DROP TEMPORARY TABLE + ROLLBACK on master |
26803 | 2007-03-02 19:15 | 2007-04-13 9:04 | MySQL Server: Falcon storage engine | Closed (6414 days) | S3 | 5.1 | Any | Any | unique constraints on VARCHAR columns behave different in MyISAM and Falcon |
27607 | 2007-04-03 7:18 | 2007-04-03 7:33 | MySQL Server: Documentation | Not a Bug (6424 days) | S3 | 5.0 | Any | Any | Delimiter statement in example wrong. |
28039 | 2007-04-23 19:50 | 2007-04-23 19:50 | MySQL Server: Falcon storage engine | Closed | S3 | Any | Any | Falcon Crash if INSERT ON DUPLICATE KEY with two interleaving transactions | |
28478 | 2007-05-16 17:05 | 2007-06-20 0:51 | MySQL Server: MyISAM storage engine | Closed (6346 days) | S2 | 5.0.42, * | Any | Any | Improper key_cache_block_size corrupts MyISAM tables |
29013 | 2007-06-11 7:03 | 2007-06-11 10:29 | MySQL Server | Can't repeat (6355 days) | S1 | 5.0.41 | Any | Any | Signal 11, MySQL server 5.0.41 crashed: has to do with the (NULL) |
29238 | 2007-06-20 13:52 | 2007-06-20 16:31 | MySQL Server: General | Not a Bug (6346 days) | S1 | 5.041 | Any | Any | INSERT DELAYED is suspended when table is full, no error reporting. |
29297 | 2007-06-22 9:06 | 2012-05-18 20:19 | MySQL Server: Optimizer | Duplicate (6340 days) | S3 | 5.0.37, 5.0 BK, 5.1 BK | Any | Any | Wrong result with aggregation and a subquery |
29335 | 2007-06-25 12:29 | 2007-06-27 10:14 | MySQL Server: MyISAM storage engine | Not a Bug (6339 days) | S3 | 5.0.38 | Any | Any | INSERT DELAYED checks table space incorrectly on MyISAM |
29949 | 2007-07-21 18:45 | 2007-08-01 20:26 | MySQL Server: General | Not a Bug (6304 days) | S2 | 5.0.46 | Any | Any | killing a statement can give back wrong error to client |
31317 | 2007-10-01 15:13 | 2021-05-23 20:45 | MySQL Server: Falcon storage engine | No Feedback (6194 days) | S3 | 6.0.4-alpha-debug | Any | Any | falcon crash recovery not perfect yet |
31881 | 2007-10-26 14:49 | 2011-02-16 23:43 | MySQL Server: Errors | Closed (5356 days) | S3 | 5.0/5.1 | Any | Any | A statement is not aborted immediately if an error inside a stored routine |
32566 | 2007-11-21 11:32 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (6184 days) | S3 | 5.1 | Any | Any | Range partitioning: Insert of maximum value should fail LESS THAN (numeric max) |
32627 | 2007-11-22 15:51 | 2008-02-29 1:19 | Connector / ODBC | Not a Bug (6092 days) | S3 | 5.1 | Any | Any | double recoding when inserting utf8 data in utf8 database |
32991 | 2007-12-05 9:32 | 2011-02-16 23:43 | MySQL Server: Command-line Clients | Closed (5568 days) | S2 | 5.1, 6.0 | Any | Any | mysqlimport --use-threads test fails on solaris |
33055 | 2007-12-07 2:47 | 2011-01-11 20:11 | MySQL Server: Falcon storage engine | Closed (5045 days) | S2 | 6.0.4 | Any | Any | Replication fails for UPDATE when using falcon Storage engine |
35754 | 2008-04-01 22:42 | 2011-02-16 23:43 | MySQL Server: Installing | Closed (5861 days) | S2 | 5.0.58 | Any | Any | mysql_install_db does not work if no hostname is set |
35982 | 2008-04-11 0:31 | 2008-09-30 19:19 | MySQL Server: Falcon storage engine | Closed (5878 days) | S1 | mysql-6.0-falcon-team | Any | Any | Falcon crashes on concurrent load data infile |
36851 | 2008-05-21 12:17 | 2008-05-30 14:12 | MySQL Cluster: NDB API | Closed (6001 days) | S3 | All | Any | Any | NDBAPI : IgnoreError with Insert operation and Blobs |
36984 | 2008-05-26 16:31 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5995 days) | S3 | 5.0.56sp1 | Any | Any | INSERT DELAYED is converted to standard INSERT in Stored Procedure. |
37460 | 2008-06-17 20:25 | 2011-02-16 23:43 | MySQL Server | Closed (5809 days) | S2 | 5.1.24/5.0/6.0 | Any | Any | Assertion failed: !table->file || table->file->inited == handler::NONE |
37774 | 2008-07-01 15:42 | 2011-02-16 23:43 | MySQL Server: General | Closed (5606 days) | S3 | 6.0-BK | Any | Any | main.events_bugs fails sporadically |
37882 | 2008-07-04 16:12 | 2018-09-25 21:47 | Tests: Replication | Duplicate (5932 days) | S7 | 5,1,26-rc | Any | Any | Failures in rowbased replication: Test "rpl_row_basic_{2myisam,3innodb}" (2) |
37884 | 2008-07-04 16:31 | 2008-08-12 17:25 | MySQL Server: Row Based Replication ( RBR ) | Closed (5927 days) | S2 | 5.1.26-rc | Any | Any | rpl_row_basic_2myisam and rpl_row_basic_3innodb fail sporadically in pushbuild |
37940 | 2008-07-07 16:50 | 2018-09-25 21:47 | Tests: Replication | Closed (5959 days) | S7 | 6.0-rpl | Any | Any | rpl_dual_pos_advance fails on pushbuild,fail wait_for_slave_to_stop |
38241 | 2008-07-19 17:24 | 2008-09-25 16:24 | MySQL Server: Row Based Replication ( RBR ) | Can't repeat (5883 days) | S1 | 5.1 | Any | Any | replication failure with a very simple mix of INSERT / UPDATE / DELETE |
38370 | 2008-07-25 10:27 | 2008-10-17 18:20 | Tests: Cluster | Closed (5861 days) | S3 | 5.1 BK | Any | Any | The test ndb.ndb_index_ordered fails with the community features on |
38515 | 2008-08-01 7:05 | 2008-08-01 7:06 | MySQL Workbench | Duplicate (5938 days) | S3 | 5.0.23 | Any | Any | Insert VALUES repeated when importing model from DBDesigner4 |
38822 | 2008-08-15 14:09 | 2011-02-16 23:43 | MySQL Server: Locking | Can't repeat (5735 days) | S3 | 6.0 | Any | Any | Assertion failed in mdl_upgrade_shared_lock_to_exclusive() at mdl.cc:989 |
39014 | 2008-08-25 16:19 | 2018-09-25 21:49 | Tests: Replication | Can't repeat (5707 days) | S7 | 6.0-bugteam | Any | Any | rpl.rpl_sporadic_master failed on pushbuild: "could not parse relay log entry" |
39352 | 2008-09-09 22:07 | 2011-05-12 6:42 | Connector / J | Closed (5868 days) | S3 | 5.0.x, 5.1.x | Any | Any | INSERT ON DUPLICATE returns 1 instead of 0 when nothing is changed |
39420 | 2008-09-12 11:58 | 2008-11-06 18:05 | MySQL Server: Maria storage engine | Can't repeat (5841 days) | S3 | 6.0.7 | Any | Any | maria deadlock when doing a large insert |
39498 | 2008-09-17 13:49 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Verified | S2 | mysql-5.1-telco-6.3 | Any | Any | Doing INSERT INTO .. SELECT brings down all data nodes. |
39538 | 2008-09-19 14:48 | 2008-10-08 7:33 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5870 days) | S2 | 5.1-telco-6.3 | Any | Any | Constraint violation in multi-row insert does not abort transaction |
39701 | 2008-09-27 16:59 | 2011-02-16 23:43 | MySQL Server: Row Based Replication ( RBR ) | Closed (5681 days) | S2 | 5.1.28, 5.1, 6.0 bzr | Any | Any | Mixed binlog format does not switch to row mode on LOAD_FILE |
40119 | 2008-10-17 18:29 | 2008-10-17 18:36 | MySQL Server: Replication | Not a Bug (5861 days) | S2 | 5.0.67 | Any | Any | auto-increment-increment and auto-increment-offset it does not function |
40365 | 2008-10-28 7:55 | 2011-02-16 23:43 | MySQL Server: Data Types | Closed (5809 days) | S3 | any | Any | Any | Prepared statements may insert invalid dates. |
40693 | 2008-11-13 10:15 | 2008-11-13 15:39 | MySQL Server: Options | Not a Bug (5834 days) | S5 | 5 | Any | Any | some status variables being reset |
40704 | 2008-11-13 16:32 | 2018-09-25 21:49 | Tests: Server | Closed (5756 days) | S7 | 5.1-rpl, 6.0-rpl | Any | Any | main.events_restart fails sporadically in pushbuild: "server has gone away" |
40737 | 2008-11-14 12:14 | 2009-08-12 21:43 | MySQL Server: Locking | Not a Bug (5562 days) | S2 | 5.0.67 | Any | Any | Lock wait timeout exceeded during inserting row |
40776 | 2008-11-17 9:38 | 2008-12-01 7:40 | MySQL Server: Security: Privileges | Duplicate (5816 days) | S2 | 5.0.67-community-nt | Any | Any | NO Privileges (insert,update,delete) for TEMPORARY table |
41017 | 2008-11-25 14:27 | 2018-09-25 21:49 | Tests | Closed (5756 days) | S7 | 6.0-rpl | Any | Any | main.events_restart fails in pushbuild: "Server failed to restart" |
41055 | 2008-11-26 14:11 | 2018-09-25 21:50 | Tests: Replication | Can't repeat (5078 days) | S7 | 5.1-rpl | Any | Any | rpl_sporadic_master fails in sync_slave_with_master sporadically in pushbuild |
41181 | 2008-12-02 18:23 | 2018-09-25 21:50 | Tests: Server | Can't repeat (5738 days) | S7 | 6.0-rpl | Any | Any | events_restart failed with "query succeeded - should have failed" |
41500 | 2008-12-16 13:05 | 2021-05-02 20:45 | Tests: Cluster | Verified | S7 | 5.1, 6.0 | Any | Any | ndb_basic fails sporadically with "lock wait timeout exceeded" |
41719 | 2008-12-23 19:08 | 2011-02-16 23:43 | MySQL Server: Replication | Closed (5681 days) | S3 | 5.0, 5.1 bzr | Any | Any | delayed INSERT into timestamp col needs set time_zone for concurrent binlogging |
41820 | 2009-01-01 20:57 | 2014-02-21 18:04 | MySQL Server: Falcon storage engine | Unsupported (3908 days) | S3 | 6.0-falcon-team | Any | Any | Falcon crash in MemFreeBlock::insert |
42102 | 2009-01-14 9:34 | 2012-05-18 20:19 | MySQL Server: DML | Duplicate (5772 days) | S1 | 4.1, 5.0, 5.1, 6.0 bzr | Any | Any | INSERT fail 'Duplicated entry' after UPDATE set auto_inc field with InnoDB |
42372 | 2009-01-27 13:02 | 2009-01-29 12:21 | MySQL Server: Charsets | Not a Bug (5757 days) | S1 | 5.0.27 | Any | Any | Data truncate while inserting from PHP |
43196 | 2009-02-25 16:12 | 2011-02-16 23:43 | Connector / J | Closed (5434 days) | S2 | 5.1.31 | Any | Any | Statement.getGeneratedKeys() use long but unsigned bigint(20) use BigInteger |
43297 | 2009-03-02 8:15 | 2021-05-23 20:45 | MySQL Server: Falcon storage engine | Duplicate (5720 days) | S1 | 6.0-falcon-team | Any | Any | Falcon ASSERT(ret) in Table::insert |
43343 | 2009-03-03 22:13 | 2010-12-07 8:53 | MySQL Server: DB2SE for IBM i | Won't fix (5080 days) | S3 | 5.1.30, 5.0, 5.1, 6.0 bzr | Any (Linux, IBM i5os) | Any | ibmdb2i Storage Engine does not honor timezone settings with INSERT |
44520 | 2009-04-28 14:29 | 2023-02-12 20:45 | MySQL Server: Row Based Replication ( RBR ) | Verified (5667 days) | S4 | 5.1.33, 5.1, 6.0 bzr | Any | Any | INSERT ignored silently if CREATE and INSERT are bundled in one BINLOG stmt |
44976 | 2009-05-20 9:09 | 2011-02-16 23:43 | MySQL Server: Replication | Duplicate (5175 days) | S2 | 5.0.77 | Any | Any | Incorrect INSERT_ID in binary log |
45231 | 2009-06-01 3:07 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (5634 days) | S4 | 5.0.60 | Any | Any | Cannot change LAST_INSERT_ID value within before update trigger |
45677 | 2009-06-23 13:08 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5113 days) | S2 | 5.1.35 and 5.4.0 | Any | Any | Slave stops with Duplicate entry for key PRIMARY when using trigger |
45784 | 2009-06-26 10:19 | 2016-10-16 20:45 | MySQL Server: Replication | Duplicate (5592 days) | S2 | 5.1+ | Any | Any | INSERT DELAYED in SP does not cause RBL if binlog_format=MIXED |
46650 | 2009-08-11 12:51 | 2011-02-16 23:44 | MySQL Server: InnoDB Plugin storage engine | Closed (5250 days) | S1 | 5.1,5.4 | Any | Any | Innodb assertion autoinc_lock == lock in lock_table_remove_low on INSERT SELECT |
46682 | 2009-08-12 21:55 | 2011-02-16 23:44 | MySQL Server: Locking | Can't repeat (5542 days) | S2 | 5.4.4-alpha, azalea | Any | Any | Replication aborts after DROP table with concurrent active transaction and lock |
46748 | 2009-08-16 17:53 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5355 days) | S2 | 5.4 | Any | Any | Assertion in MDL_context::wait_for_locks() on INSERT + CREATE TRIGGER |
46965 | 2009-08-27 20:20 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Closed (5344 days) | S3 | Any | Any | crash in ha_innobase::get_auto_increment | |
47097 | 2009-09-03 10:55 | 2024-09-08 20:45 | MySQL Server: Documentation | No Feedback (5496 days) | S3 | 5.0+ | Any | Any | ALTER <existing table> ENGINE = MERGE/BLACKHOLE ... is allowed + data loss |
47253 | 2009-09-10 14:30 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (5529 days) | S3 | Any | Any | Assert in ha_partition::end_bulk_insert | |
47442 | 2009-09-18 14:06 | 2011-02-16 23:44 | MySQL Server: Row Based Replication ( RBR ) | Closed (5176 days) | S3 | 5.1,5.4 | Any | Any | RBR breaks on CREATE TABLE IF EXISTS <existing VIEW> AS SELECT |
47648 | 2009-09-25 13:23 | 2011-02-16 23:44 | MySQL Server: Merge storage engine | Closed (5354 days) | S3 | 6.0, mysql-next-4284 | Any | Any | main.merge fails sporadically |
47742 | 2009-09-30 12:52 | 2012-02-16 4:28 | MySQL Cluster: Cluster (NDB) storage engine | Closed (4644 days) | S3 | mysql-5.1 | Any | Any | Extra-columns on the slave do not work with ndb as expected |
48113 | 2009-10-16 13:21 | 2011-02-16 23:44 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5493 days) | S3 | mysql-5.1-telco-6.2+ | Any | Any | Ndb : Insert hitting DD space exhaustion does not lock following tuple ops |
48724 | 2009-11-12 12:33 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5355 days) | S2 | 6.0.14-bzr, 6.0-codebase-bugfixing | Any | Any | Deadlock between INSERT DELAYED and FLUSH TABLES |
48814 | 2009-11-16 19:14 | 2011-02-16 23:44 | MySQL Server: DDL | Closed (5169 days) | S2 | 5.0+, 5.5.0 | Any | Any | CREATE TABLE IF NOT EXISTS <non-insertable view> SELECT does not fail |
48874 | 2009-11-18 17:36 | 2011-02-16 23:44 | Tests: Server | Closed (5101 days) | S3 | 5.5.0-beta | Any (all) | Any | Test "is_triggers" fails because of wrong charset info |
49020 | 2009-11-24 3:51 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5377 days) | S1 | 5.5.0 | Any | Any | Semi-sync master crashed with free_pool == NULL, assertion `free_pool_' |
49456 | 2009-12-04 12:04 | 2018-04-08 20:45 | MySQL Server | Analyzing (5448 days) | S3 | mysql-5.1-rep+3 | Any | Any | replication out of sync |
49533 | 2009-12-08 13:08 | 2017-05-21 20:45 | MySQL Server: Replication | Verified (5444 days) | S3 | 5.1,mysql-5.1-rep+3,mysql-6.0-codebase-b | Any | Any | Overflow in DECIMAL, SBR out of sync |
49562 | 2009-12-09 14:30 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5205 days) | S3 | 5.1,mysql-5.1-rep+3,mysql-6.0-codebase-b | Any | Any | SBR out of sync when using numeric data types + user variable |
49567 | 2009-12-09 16:37 | 2015-01-12 15:27 | MySQL Server: Replication | Won't fix (3583 days) | S2 | 5.1+ | Any | Any | INSERT DELAYED uses global binlog_format, should use session |
49971 | 2009-12-29 9:38 | 2010-01-07 9:09 | MySQL Server: DML | Not a Bug (5414 days) | S4 | Any | Any | Allow INSERT .... WHERE .... | |
50065 | 2010-01-04 22:59 | 2012-07-29 23:08 | MySQL Server: Query Cache | Closed (4480 days) | S4 | 5.0.89, 5.1.37, 5.5-mr2 | Any | Any | query cache invalidated in insert...select if no rows inserted |
50385 | 2010-01-15 22:39 | 2014-03-11 21:18 | MySQL Server: Locking | Closed (3890 days) | S3 | 5.1 | Any | Any | test suite fails without query cache |
50728 | 2010-01-29 12:24 | 2011-02-16 23:44 | MySQL Workbench: Administration | Closed (5381 days) | S3 | 5.2.15 | Any | Any | mysqldump error with whitespace in table name |
52868 | 2010-04-15 21:03 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5134 days) | S2 | 5.1.37, 5.1.47,5.5.5-m3,5.6.99-m4 | Any | Any | Wrong handling of NULL value during update, replication out of sync |
53075 | 2010-04-22 18:12 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5293 days) | S3 | 5.6.99-m4 | Any | Any | SBR: Strange warning around CONNECTION_ID() |
53298 | 2010-04-29 21:15 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5094 days) | S3 | 6.0-codebase-bugfixing | Any | Any | wrong result with semijoin (no semijoin strategy chosen) |
54579 | 2010-06-17 9:45 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5102 days) | S3 | 5.5+ | Any | Any | Wrong unsafe warning for INSERT DELAYED in SBR |
56680 | 2010-09-09 9:25 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Closed (5073 days) | S3 | all | Any | Any | InnoDB may return wrong results from a case-insensitive covering index |
57250 | 2010-10-05 14:07 | 2017-05-21 20:45 | MySQL Server: Replication | Verified (5143 days) | S2 | 5.1+ | Any | Any | mark INSERT...SELECT with autoinc column unsafe when innodb_autoinc_lock_mode=2 |
57335 | 2010-10-08 6:35 | 2011-02-16 23:44 | MySQL Enterprise Backup | Closed (5028 days) | S3 | 3.5.2 | Any | Any | abnormal termination of the backup process could leave the global lock active |
57698 | 2010-10-24 21:25 | 2012-09-13 9:30 | Connector / J | Closed (5098 days) | S3 | 5.1.13 | Any | Any | StatementRegressionTest.testGetGeneratedKeysAllCases causes false negative |
57806 | 2010-10-28 13:20 | 2021-05-02 20:45 | MySQL Cluster: Cluster/J | No Feedback (4090 days) | S3 | mysql-5.1-telco-7.1 | Any | Any | wrong interface member function type gives funny exception |
57918 | 2010-11-02 8:54 | 2011-02-16 23:44 | Tests: Replication | Closed (5050 days) | S3 | 5.6 (Dahlia, Erica) | Any | Any | rpl_get_master_version_and_clock times out sporadically |
58083 | 2010-11-09 13:27 | 2011-02-16 23:44 | Tests: Replication | Duplicate (5107 days) | S3 | 5.6 | Any | Any | Test rpl.rpl_server_uuid fails after 5 minutes in trunk-bugfixing |
58086 | 2010-11-09 15:09 | 2011-11-30 18:40 | MySQL Server: Documentation | Closed (4722 days) | S3 | 5.1 | Any | Any | auto_inc in InnoDB have INSERT ... ON DUPLICATE KEY UPDATE != UPDATE |
58212 | 2010-11-15 21:20 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Closed (5030 days) | S3 | 5.5+ | Any | Any | Possible deadlock in change buffer in debug builds |
58377 | 2010-11-22 11:07 | 2011-02-16 23:44 | MySQL Workbench: SQL Editor | Closed (5050 days) | S3 | 5.2.30 | Any (Fedora 14 x86_64, Windows XP) | Any | Export as "SQL Insert Statements" file does not work properly |
58562 | 2010-11-29 15:05 | 2011-03-07 11:32 | MySQL Workbench: Administration | Closed (4990 days) | S1 | 5.2.30 | Any | Any | --lock-tables enabled even when --single-transaction option selected |
58678 | 2010-12-02 22:36 | 2023-02-12 20:45 | MySQL Server: Replication | Verified | S3 | 5.5.6, 5.5.8 | Any | Any | Wrong statement quoted in unsafety warning upon event execution |
58686 | 2010-12-03 0:16 | 2010-12-15 23:39 | MySQL Server | Not a Bug (5072 days) | S3 | 5.1.43sp1-enterprise-gpl | Any | Any | CREATE TABLE .. CHARSET=<...> without a COLLATE using case-insensitive collation |
59214 | 2010-12-29 15:45 | 2011-05-05 23:48 | MySQL Server: InnoDB Plugin storage engine | Closed (4931 days) | S5 | 5.1,5.5 | Any | Any | increase rate limit for insert buffer prefetch reads |
59735 | 2011-01-26 9:19 | 2011-04-02 1:35 | MySQL Server: Charsets | Closed (4964 days) | S3 | 5.5.8 | Any | Any | can't insert into value |
60425 | 2011-03-11 2:58 | 2012-01-19 18:46 | MySQL Server: Replication | Not a Bug (4672 days) | S3 | mysql5.5 | Any | Any | The rpl_semi_sync_master_wait_no_slave variable is invalid |
65846 | 2012-07-08 18:17 | 2016-09-09 11:23 | MySQL Server: DML | Won't fix (2977 days) | S3 | 5.1.63, 5.5.25, 5.5.26 | Any | Any | INSERT DELAYED on a BLACKHOLE table hangs forever |
67863 | 2012-12-10 16:24 | 2020-10-07 13:48 | MySQL Server: DML | Closed (1488 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | INSERT INTO view_name () VALUES () fails with ER_WRONG_VALUE_COUNT_ON_ROW |
68021 | 2013-01-03 16:49 | 2023-08-08 2:09 | MySQL Server: InnoDB storage engine | Closed (3689 days) | S2 | 5.5.29, 5.5.30, 5.6, 5.7.1 | Any | Any | Unexplainable InnoDB unique index locks on DELETE + INSERT with same values |
68769 | 2013-03-25 22:42 | 2013-03-26 3:37 | MySQL Server: General | Not a Bug (4240 days) | S1 | 5.5 or greater | Any (Linux and Windows) | Any | REPLACE/INSERT INTO fails for MyISAM if truncated is in the first row |
69253 | 2013-05-16 7:31 | 2014-08-27 4:50 | MySQL Server: Row Based Replication ( RBR ) | Closed (3721 days) | S3 | 5.6.11 | Any | Any | mysqlbinlog prints incorrect value while using decimal |
70529 | 2013-10-04 22:17 | 2014-01-15 18:32 | Connector / Python | Closed (3945 days) | S3 | 1.0.10 | Any | Any | executemany() INSERT INTO fails w/o VALUES (e.g. INSERT .. SELECT) |
71769 | 2014-02-19 14:03 | 2014-11-21 22:55 | MySQL Server: Documentation | Closed (3635 days) | S3 | 5.7.2 | Any | Any | GET STACKED DIAGNOSTICS not behaving as described |
72098 | 2014-03-21 20:47 | 2019-11-18 22:37 | MySQL Server: DML | Closed (1812 days) | S3 | 5.5, 5.5.38 | Any | Any | select * from (subquery) get different result with subquery. |
72195 | 2014-04-01 18:50 | 2016-02-25 12:24 | MySQL Server: Replication | Verified | S3 | 5.6.17 | Any | Any | GTID restriction with non-transactional storage engines unclear |
72756 | 2014-05-27 2:46 | 2014-05-27 2:46 | MySQL Server: Locking | Open | S4 | 5.5.37 | Any | Any | Downgrade AUTO-INC lock from simple INSERT when possible |
72851 | 2014-06-03 14:01 | 2015-08-30 12:07 | MySQL Server: InnoDB storage engine | Verified (3805 days) | S3 | 5.6 | Any | Any | Fix for bug 16345265 in 5.6.11 breaks backward compatibility for InnoDB recovery |
73083 | 2014-06-23 17:49 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Duplicate (3779 days) | S4 | Any | Any | mysqldump extended inserts should have new line character between each insert | |
73252 | 2014-07-10 7:18 | 2014-08-22 1:00 | MySQL Server: InnoDB storage engine | No Feedback (3727 days) | S3 | 5.6.13 | Any | Any | Duplicate foreign keys break insertions to a table |
73300 | 2014-07-16 18:03 | 2015-04-01 4:41 | MySQL Server: InnoDB storage engine | Closed (3734 days) | S3 | 5.7.5 | Any | Any | innodb.log_file_name fails sproadically on pb2 |
74228 | 2014-10-05 13:22 | 2014-10-07 11:13 | MySQL Server: Options | Verified (3681 days) | S3 | 5.5, 5.6 | Any | Any | Description of autoincrement behavior if offset > increment needs clarification |
74542 | 2014-10-24 10:05 | 2014-10-24 10:51 | MySQL Server: Optimizer | Verified (3663 days) | S3 | 5.6/5.7 | Any | Any | FLUSH TABLES WITH READ LOCK blocks EXPLAIN UPDATE/DELETE/INSERT |
74543 | 2014-10-24 10:11 | 2017-06-29 5:47 | MySQL Server: Optimizer | Verified (3663 days) | S3 | 5.6/5.7, 5.7.18 | Any | Any | read_only=1 prevents EXPLAIN UPDATE/DELETE/INSERT |
75068 | 2014-12-02 8:40 | 2015-04-06 19:03 | MySQL Server: DML | Closed (3544 days) | S3 | 5.1+ | Any | Any | LOAD DATA INFILE doesn't reset LEX::many_values |
75126 | 2014-12-06 10:42 | 2014-12-09 20:55 | MySQL Server: DDL | Verified (3617 days) | S4 | 5.6, 5.7 | Any | Any | Add option to disallow cross schema ddl |
76353 | 2015-03-17 14:55 | 2015-03-17 18:16 | MySQL Server | Duplicate (3519 days) | S3 | 5.6.22 | Any | Any | "Truncated incorrect INTEGER value" in INSERT...SELECT with CASE tested for NULL |
78004 | 2015-08-10 6:19 | 2023-05-02 13:28 | MySQL Server: InnoDB storage engine | Verified (3291 days) | S3 | 5.6.22, 5.6.26, 5.7.8 | Any | Any | auto_increment tinyint column value jumps from 125 to 127 |
78406 | 2015-09-11 10:21 | 2019-12-20 14:13 | MySQL Server | Not a Bug (1780 days) | S3 | 5.6.25 | Any | Any | Simple insert deadlock when selected from partitioned table being updated |
78623 | 2015-09-29 10:58 | 2015-10-19 12:56 | MySQL Server: InnoDB storage engine | Closed (3303 days) | S2 | 5.7.8 | Any | Any | Small tablespaces with BLOBs take up to 80 times more space in 5.7 than in 5.6 |
78763 | 2015-10-08 16:22 | 2015-10-08 17:02 | MySQL Server: mysqldump Command-line Client | Verified (3314 days) | S3 | 5.6/5.7 | Any | Any | mysqldump with --add-drop-trigger option when trigger name contains dots |
79171 | 2015-11-08 0:13 | 2015-11-19 15:30 | MySQL Server: mysqldump Command-line Client | Verified (3272 days) | S4 | Any | Any | mysqldump diff-friendly extended-insert | |
79658 | 2015-12-16 8:49 | 2015-12-24 7:18 | MySQL Server: Performance Schema | Not a Bug (3237 days) | S3 | 5.7.10 | Any | Any | performance_schema statements by thread limited instrumentation |
79690 | 2015-12-17 12:54 | 2015-12-17 19:33 | MySQL Server: DML | Not a Bug (3244 days) | S3 | 5.7.8 | Any | Any | Insert -0.1 and string '-0.1' into unsigned int returns different result |
80219 | 2016-02-01 8:26 | 2018-04-18 8:38 | MySQL Server: Tests | Can't repeat (2391 days) | S3 | 5.6.28 | Any | Any | rpl_stm_mixed_crash_safe mtr test fails |
80404 | 2016-02-17 11:06 | 2016-02-17 13:28 | MySQL Server: DML | Verified (3182 days) | S3 | 5.0/5.1/5.5/5.6/5.7 | Any | Any | After sql_warnings to 0, the INSERT still get warnings message |
81063 | 2016-04-13 9:10 | 2018-08-09 14:45 | Connector / J | Closed (2278 days) | S2 | 5.1.16, 5.1.38 | Any | Any | w/ rewriteBatchedStatements, when 2 tables involved, the rewriting not correct |
81680 | 2016-06-01 13:33 | 2016-06-01 18:01 | MySQL Server: InnoDB storage engine | Verified (3077 days) | S4 | 5.7 | Any (CentOS Linux release 7.2.1511 (Core) ) | Any | A proposal to make disk IO much faster under SSD |
83397 | 2016-10-16 10:58 | 2016-10-17 6:58 | MySQL Server: FULLTEXT search | Verified (2939 days) | S3 | 5.7.15, 5.7.16 | Any | Any | INSERT INTO ... SELECT FROM ... fails if source has > 65535 rows on FTS |
84792 | 2017-02-02 12:49 | 2017-05-03 13:18 | MySQL Server: Group Replication | Can't repeat (2741 days) | S3 | 5.7.17 | Any | Any | Idle GR Cluster: Member CPU hog |
87353 | 2017-08-09 8:30 | 2017-08-09 9:39 | MySQL Cluster: Cluster (NDB) storage engine | Verified (2643 days) | S3 | 7.5.7 | Any | Any | "ndb_restore --print-data" and "ndb_restore --print-sql-log" have duplicate row |
87598 | 2017-08-30 7:44 | 2017-08-30 12:22 | MySQL Server: Optimizer | Duplicate (2622 days) | S3 | 5.7.19 | Any | Any | SELECT DISTINCT doesn't return result with "Using index for group-by" |
89225 | 2018-01-14 21:09 | 2018-01-15 7:30 | MySQL Server: DML | Not a Bug (2484 days) | S3 | 5.7 | Any | Any | INSERT INTO ... VALUES (DEFAULT) on auto_increment becomes unexpected value 0 |
89385 | 2018-01-24 15:14 | 2020-10-06 13:05 | MySQL Server | Not a Bug (1489 days) | S4 | Any | Any | INSERT IGNORE DUPLICATE KEY | |
90210 | 2018-03-26 2:22 | 2018-04-03 14:03 | MySQL Server: InnoDB storage engine | Not a Bug (2406 days) | S2 | 5.6.32+ | Any (CentOS,Ubuntu,MAC) | Any (intel64,MAC) | deadlock when concurrency update the same index |
90745 | 2018-05-04 8:38 | 2023-12-12 12:43 | MySQL Workbench | Verified (2375 days) | S3 | 8.0.11, 8.0.23 | Any | Any | sqlide-history parser fails to parse entries with some html encodings |
91208 | 2018-06-11 10:19 | 2018-06-13 1:03 | MySQL Server: Documentation | Closed (2335 days) | S3 | 8.0 | Any (8.x) | Any | INSERT DELAYED removed, but still referred in docs. |
94814 | 2019-03-28 11:12 | 2022-12-01 12:01 | MySQL Server: XA transactions | Closed (703 days) | S2 | 5.7, 8.0, 5.7.25 | Any | Any | slave replication lock wait timeout because of wrong trx order in binlog file |
98595 | 2020-02-14 9:30 | 2020-02-14 13:46 | MySQL Server | Not a Bug (1724 days) | S3 | 8.0.18 | Any | Any | Auto-inc number is different between different connections |
99504 | 2020-05-11 2:47 | 2021-10-22 17:39 | MySQL Server: DML | Duplicate (1108 days) | S2 | 8.0.20 | Any | Any | Generated column incorrect on INSERT when based on column w/ expression DEFAULT |
99513 | 2020-05-11 13:21 | 2020-06-09 12:10 | MySQL Server: Data Types | Closed (1609 days) | S3 | Any | Any | "ALTER TABLE ... ADD ... DEFAULT now()" generates wrong time at first INSERT | |
100398 | 2020-07-31 8:33 | 2020-07-31 9:50 | MySQL Server: Optimizer | Verified (1556 days) | S3 | 8.0.19, 5.7.31, 8.0.21 | Any | Any | The results of aggregation operations are inconsistent in different partitions |
100764 | 2020-09-08 8:50 | 2020-10-16 1:00 | MySQL Server: Optimizer | No Feedback (1480 days) | S1 | 8.0 | Any | Any | Rename Table causes other SQL execution plans to change. |
101907 | 2020-12-08 11:39 | 2021-02-12 1:00 | MySQL Server: Replication | No Feedback (1361 days) | S2 | 5.7 | Any | Any | Replication sql_thread hung while executing DML in init state |
102481 | 2021-02-04 15:37 | 2021-02-05 14:40 | MySQL Server: Optimizer | Verified (1367 days) | S3 | 8.0.23 | Any | Any | EXPLAIN FOR CONNECTION not good |
102655 | 2021-02-19 3:07 | 2021-12-02 11:19 | MySQL Server: Optimizer | Duplicate (1067 days) | S3 | 8.0, 8.0.23 | Any | Any | results from SELECT are different when use WHERE or not |
102912 | 2021-03-11 2:07 | 2021-03-11 13:02 | MySQL Server: Optimizer | Verified (1333 days) | S3 | 8.0, 8.0.23, 5.7.33 | Any | Any | filter result different on a index bit column with no-index bit column |
104287 | 2021-07-12 13:39 | 2021-07-14 11:24 | MySQL Server: Clone Plugin | Not a Bug (1208 days) | S3 | 8.0.17 | Any | Any | trx_sys binlog coordinates broken after clone plugin |
104499 | 2021-07-31 20:35 | 2021-08-27 12:02 | MySQL Server: InnoDB storage engine | Verified (1165 days) | S3 | Any | Any | MySQL auto_inc value changed after a failed insert | |
104674 | 2021-08-20 9:05 | 2021-08-20 9:30 | MySQL Workbench | Verified (1171 days) | S3 | 8.0, 8.0.26 | Any | Any | MySQLLexer.g4 `BACK_TICK_QUOTED_ID `lexical rule definition bug |
105517 | 2021-11-10 13:36 | 2021-11-10 14:36 | MySQL Server: Data Types | Verified (1089 days) | S2 | 8.0 | Any (20.0.4.1) | Any | INSERT of CURRENT_TIMESTAMP() vs. DEFAULT differs for TIMESTAMP field |
105885 | 2021-12-14 0:42 | 2021-12-14 13:39 | MySQL Cluster: Cluster (NDB) storage engine | Verified (1055 days) | S3 | 8.0.27 | Any | Any | Multi row operation mixes can cause crash during node recovery |
108379 | 2022-09-05 7:58 | 2022-09-20 22:29 | Connector / J | Duplicate (775 days) | S3 | 8.0.29, 8.0.30 | Any | Any | Recognize "ON DUPLICATE KEY UPDATE" in "INSERT SET" Statement |
109857 | 2023-01-31 8:55 | 2023-02-03 4:54 | MySQL Server: Replication | Duplicate (639 days) | S2 | 5.7.38 | Any | Any | Truncate table with foreign key crash replication. |
109938 | 2023-02-04 21:51 | 2023-02-13 13:27 | MySQL Server: Locking | Not a Bug (632 days) | S3 | 8.0.31 | Any | Any | next key lock with ROLLBACK TO SAVEPOINT |
110245 | 2023-03-01 3:56 | 2023-03-02 9:59 | MySQL Server: Optimizer | Not a Bug (612 days) | S3 | 8.0.32 | Any | Any | Issue with NOT IN |
110672 | 2023-04-12 21:23 | 2023-04-18 16:02 | MySQL Server: DML | Closed (565 days) | S2 | 8.0.32 | Any | Any | QUOTE function doesn't work as expected on tables that are utf16 |
110795 | 2023-04-25 5:45 | 2023-04-25 8:41 | MySQL Server: Locking | Verified (558 days) | S3 | 8.0.27, 8.0.33, 5.7.42 | Any | Any | mysql insert is deadlocked |
112802 | 2023-10-23 8:23 | 2023-10-27 9:46 | MySQL Server: Optimizer | Verified (377 days) | S3 | 8.1.0, 8.0.34 | Any | Any | Inconsistent results when using INDEX |
113257 | 2023-11-28 14:29 | 2024-06-25 15:01 | Tests: Replication | Won't fix (131 days) | S6 | 8.2.0 | Any | Any | Assertion on rpl.rpl_replication_observers_example_plugin_ongoing_transaction |
113464 | 2023-12-19 17:40 | 2024-03-12 11:05 | MySQL Server: Optimizer | Verified (319 days) | S2 | 8.0.27 | Any | Any | >= 8.0.27 Error 1048 when updating row with empty_sql mode |
114524 | 2024-04-01 12:36 | 2024-09-25 22:29 | Connector / J | Verified (215 days) | S3 | 8.3.0 | Any | Any | INSERT with JSON column error |
114982 | 2024-05-13 11:47 | 2024-05-13 12:40 | MySQL Server: Partitions | Verified (174 days) | S2 | 8.0 | Any | Any | Query result about list partition table is incorrect |
115181 | 2024-05-31 2:11 | 2024-06-03 13:36 | MySQL Server: Performance Schema | Verified (153 days) | S3 | 8.0 | Any | Any | performance_schema.metadata_locks table doesn't show EXCLUSIVE locks correctly |
115269 | 2024-06-10 12:53 | 2024-06-11 10:29 | MySQL Server: DML | Verified (146 days) | S3 | 8.0 | Any | Any | "INSERT SET column=column" inserts zero date |
116114 | 2024-09-15 18:46 | 2024-10-07 16:37 | Connector / J | Closed (27 days) | S3 | >= 8.0.23 | Any | Any | Connector/J is writing incorrect values when passed negative dates |
116161 | 2024-09-19 11:50 | 2024-09-19 12:33 | MySQL Server | Duplicate (45 days) | S2 | any | Any | Any | Permission Loss in Certain Cases for Database Names Containing Underscores |
116502 | 2024-10-30 4:31 | 2024-10-31 7:13 | MySQL Server: InnoDB storage engine | Verified (3 days) | S2 | 8.0.40 | Any | Any | Duplicate Detection Flaw for NULL Values in UK During DDL Rollback Operations |
169 | 2003-03-19 14:22 | 2003-03-24 13:38 | MySQL Server | Closed (7895 days) | S2 | 3.23.56 and below (not in 4.0) | Any (all) | Any | DELETE FROM t; does not lock 't' enough, causes bad order in binlog |
291 | 2003-04-15 9:37 | 2019-05-14 14:18 | MySQL Server | Closed (7842 days) | S2 | 4.0, 4.1 | Any (All) | Any | bug in NATURAL LEFT JOIN, MySQL 4.0 and 4.1. |
615 | 2003-06-06 13:51 | 2003-07-01 3:18 | MySQL Server | Closed (7796 days) | S2 | 4.0.13, 4.1.0 | Any (Any) | Any | Multiple inserting NULL into a column that has been declared NOT NULL |
675 | 2003-06-18 13:47 | 2003-06-19 13:32 | Connector / J | Closed (7808 days) | S2 | 3.0+ | Any (Any) | Any | A call to ResultSet.getXXX while on insert row fails |
2614 | 2004-02-02 10:02 | 2020-04-29 12:28 | MySQL Server | Closed (7576 days) | S2 | 5.0 | Any (any) | Any | Sotred procedure with INSERT .. SELECT crash 5t.0 |
3081 | 2004-03-06 6:48 | 2004-03-08 5:51 | MySQL Server: Replication | Closed (7545 days) | S3 | 4.0 | Any (all) | Any | if an INSERT DELAYED is killed, it is binlogged as killed but it's not needed |
3985 | 2004-06-03 16:26 | 2005-12-13 16:23 | MySQL Server | Duplicate (6900 days) | S4 | 4.0 | Any (any) | Any | privilege for INSERT, UPDATE, DELETE, DROP, CREATE TEMPORARY TABLES |
4380 | 2004-07-02 14:26 | 2004-08-01 17:00 | MySQL Server: Replication | Not a Bug (7399 days) | S2 | 4.0 | Any (all) | Any | One-row INSERT/UPDATE/DELETE needn't be binlogged as 'killed' |
5369 | 2004-09-02 15:48 | 2004-09-10 17:17 | MySQL Cluster: Cluster (NDB) storage engine | Closed (7359 days) | S3 | 4.13, 4.1.4 | Any (any) | Any | wrong initial value of auto increment in mysql cluster |
5510 | 2004-09-10 4:10 | 2004-09-17 21:24 | MySQL Server | Closed (7352 days) | S2 | 4.1.4 | Any (All) | Any | inserting Null in AutoIncrement primary key Column Fails |
7963 | 2005-01-17 17:12 | 2005-03-07 22:20 | MySQL Server: MyISAM storage engine | Can't repeat (7181 days) | S2 | 4.1.8 | Any (*) | Any | Zero records not possible |
8144 | 2005-01-26 13:49 | 2005-01-28 11:39 | MySQL Server: InnoDB storage engine | Closed (7219 days) | S2 | 5.0.3-bk | Any (all) | Any | Locking problem in TRUNCATE TABLE |
8732 | 2005-02-23 14:49 | 2012-05-18 20:19 | MySQL Server | Duplicate (7030 days) | S3 | 4.1.10 | Any (*) | Any | INSERT ... SELECT ...ON DUPLICATE KEY UPDATE problem |
9229 | 2005-03-16 19:07 | 2019-10-07 12:17 | MySQL Server | Closed (7171 days) | S1 | 5.0.3-pre | Any (Any) | Any | Test 'sp' requires InnoDB and thus fails in 'classic' |
10381 | 2005-05-05 11:50 | 2005-05-19 5:03 | MySQL Server: Documentation | Closed (7108 days) | S3 | 5.0.4-beta-standard | Any (*) | Any | 'INSERT DELAYED' option supports for Memory engine. |
11478 | 2005-06-21 11:02 | 2022-09-04 20:45 | MySQL Server | Duplicate (7072 days) | S3 | 4.0 | Any (any) | Any | option new doesn't work as expected in 4.0 |
11745 | 2005-07-05 20:16 | 2005-08-03 20:56 | MySQL Server: Optimizer | Closed (7032 days) | S2 | 4.1.12a | Any (All) | Any | insert where not exists failing |
12092 | 2005-07-21 20:40 | 2007-11-29 11:23 | MySQL Server: Replication | Closed (6184 days) | S3 | 4.0, 4.1, 5.0 | Any (all) | Any | FOUND_ROWS() not replicated |
15189 | 2005-11-23 15:59 | 2011-02-16 23:43 | MySQL Server: DML | Verified (6920 days) | S4 | 5.0.17-BK | Any | Any | Optimise INSERT ... ON DUPLICATE KEY ... for identical column values |
17974 | 2006-03-06 16:16 | 2006-03-21 10:08 | MySQL Server | Won't fix (6802 days) | S3 | 4.1.18 | Any (Any) | Any | INSERT ... SELECT with GROUP BY causes truncation of DECIMAL |
18484 | 2006-03-24 14:07 | 2011-02-16 23:43 | MySQL Server | Closed (5552 days) | S2 | 5.1, 5.4 | Any | Any | Bogus "Server shutdown in progress" error on INSERT DELAYED + ALTER |
18489 | 2006-03-24 15:33 | 2006-07-29 17:38 | MySQL Server | Won't fix (6672 days) | S4 | 5.1 | Any (All) | Any | Field Selection Negation |
18652 | 2006-03-30 13:58 | 2009-01-13 18:08 | MySQL Query Browser | Won't fix (5773 days) | S4 | Any | Any (Any) | Any | Auto Insert Delimiters on Script Tabs |
19354 | 2006-04-25 21:05 | 2024-09-15 20:45 | MySQL Server | Duplicate (6750 days) | S4 | 5.1 | Any (all) | Any | CREATE INDEX lacks of IF NOT EXISTS |
19565 | 2006-05-05 17:07 | 2022-08-21 20:45 | MySQL Server: Stored Routines | Duplicate (6305 days) | S1 | 5.0, 5.1 | Any | Any | crash in system test, trigger, InnoDB transaction deadlock |
19887 | 2006-05-17 15:17 | 2011-02-16 23:43 | MySQL Server: Locking | Verified (6741 days) | S4 | 4.1 / 5.0 | Any (*) | Any | concurrent updates restricted by queries not using the binlog |
23368 | 2006-10-17 12:37 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5252 days) | S1 | 5.1 | Any | Any | crash during insert, table has foreign key pointing into other schema,permission |
23464 | 2006-10-19 14:02 | 2020-05-03 20:45 | MySQL Server: Views | Duplicate (6477 days) | S3 | 5.0.27-BK, 5.0.26 and 5.1.12 | Any (all) | Any | A view with an ORDER BY clause becomes non-updatable |
24024 | 2006-11-06 19:14 | 2021-05-23 20:45 | MySQL Server: Errors | Duplicate (6212 days) | S3 | Any | Any | wrong error message when drop table (used by pending transaction) fails | |
26733 | 2007-02-28 20:15 | 2007-03-01 9:46 | MySQL Server: Command-line Clients | Not a Bug (6457 days) | S2 | 5.0.38 | Any (any) | Any | '\r' in the text data in INSERT statement causes client to reconnect |
27044 | 2007-03-12 11:47 | 2007-06-02 14:35 | MySQL Cluster: Replication | Closed (6364 days) | S3 | 5.1.17 | Any | Any | replicated with unique field ndb table allows duplicate key inserts |
27177 | 2007-03-15 15:14 | 2007-07-03 15:05 | MySQL Server: Documentation | Closed (6333 days) | S3 | All Versions | Any | Any | SHOW PROCESSLIST Syntax - add descriptions for state |
27713 | 2007-04-09 11:17 | 2020-05-03 20:45 | MySQL Server: Views | Verified (6417 days) | S3 | 5.0.38, 5.1, 5.2 | Any | Any | INSERTs fail for empty table using WITH_CHECK_OPTION |
27981 | 2007-04-20 13:43 | 2007-04-20 13:49 | MySQL Server: Documentation | Closed (6407 days) | S4 | 5.0 | Any | Any | Typo in the INSERT() function documentation |
28806 | 2007-05-31 13:26 | 2007-06-16 13:00 | MySQL Server | Closed (6350 days) | S1 | 5.1.18 | Any | Any | Running SHOW TABLE STATUS during high INSERT load crashes server |
28837 | 2007-06-01 13:57 | 2008-01-15 16:26 | MySQL Server: MyISAM storage engine | Closed (6137 days) | S3 | 4.1BK/5.0BK/5.1BK | Any | Any | MyISAM storage engine error (134) doing delete with self-join |
29095 | 2007-06-14 3:21 | 2010-05-09 3:28 | MySQL Server: General | Closed (6332 days) | S2 | 5.0.44-BK, 5.0.27 community, 5.0.41 Linux | Any (Windows/Linux same...) | Any | Insert into a select from a join b using(c) order by b.auto_id desc limit 1 fail |
29146 | 2007-06-15 19:08 | 2016-02-25 12:24 | MySQL Server: Command-line Clients | Not a Bug (6087 days) | S3 | 5.0.41 | Any | Any | Output truncated when resultset contains \r |
29652 | 2007-07-09 17:39 | 2007-07-11 5:17 | MySQL Server: CSV | Closed (6325 days) | S2 | 5.1-maint | Any | Any | csv.test failure: two changes conflict after merge |
29692 | 2007-07-10 15:37 | 2009-12-07 9:07 | MySQL Server | Closed (6256 days) | S1 | mysql-essential-5.1.21-beta | Any (Linux, WindowsXP) | Any | Single row inserts can incorrectly report a huge number of row insertions |
29771 | 2007-07-12 19:50 | 2007-07-17 11:25 | MySQL Server: Stored Routines | Not a Bug (6319 days) | S2 | 5.045 | Any | Any | The cursor is automatically closed. |
29979 | 2007-07-23 15:56 | 2007-07-23 16:43 | MySQL Server | Duplicate (6313 days) | S1 | 5.0.6, 5.0.7 | Any | Any | PreparedStatement.executeUpdate returns wrong rowcount for an insert statement. |
30020 | 2007-07-24 23:02 | 2007-08-03 15:52 | MySQL Server: Information schema | Closed (6302 days) | S3 | 5.0.46 | Any | Any | Wrong IS_UPDATABLE value in I_S.VIEWS for a non updatable view (regression) |
30212 | 2007-08-02 20:31 | 2018-09-25 21:45 | MySQL Server: Tests | Closed (6295 days) | S7 | Any | Any | events_logs_tests not deterministic; SLEEP(2), others | |
30833 | 2007-09-05 14:41 | 2007-09-05 15:07 | MySQL Server: Backup | Can't repeat (6269 days) | S3 | Ver 10.10 Distrib 5.0.27 | Any | Any | mysqldump does not create views when "information_schema" passed to --databases |
30843 | 2007-09-05 21:10 | 2007-10-24 2:58 | MySQL Server: Archive storage engine | Closed (6220 days) | S3 | 5.0 test cases (maybe before) | Any | Any | Bad Test addition to t/archive.test |
31320 | 2007-10-01 16:00 | 2007-10-12 15:50 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6232 days) | S3 | MySQL Cluster CGE 6.3 | Any | Any | transaction with statement error not aborting transaction |
31321 | 2007-10-01 17:00 | 2007-12-06 17:31 | MySQL Server: Documentation | Closed (6177 days) | S3 | 5.1, 6.0 | Any | Any | Partial transaction results with INSERT ... SELECT and cluster replication |
31906 | 2007-10-29 10:22 | 2007-10-29 11:10 | MySQL Server: DML | Not a Bug (6215 days) | S3 | Any | Any | No stmt rollback and wrong binlog if an error in {INSERT|CREATE} ... SELECT UNIO | |
31975 | 2007-10-31 7:36 | 2009-09-01 13:19 | MySQL Server: Command-line Clients | Not a Bug (5542 days) | S4 | mysql-connector-java-3.1.8-bin.jar | Any | Any | LOAD DATA LOCAL INFILE - Duplicate entry error should come |
32244 | 2007-11-09 19:10 | 2008-02-28 17:24 | Tests: Server | Closed (6093 days) | S3 | 6.0.4-alpha | Any | Any | Result files not updated with ".inc" file used - tests fail (2) |
33515 | 2007-12-26 13:29 | 2008-06-13 16:09 | MySQL Server: Stored Routines | Closed (5987 days) | S1 | 6.0.4 | Any | Any | Create trigger, partition, insert = crash |
33717 | 2008-01-07 2:52 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5252 days) | S3 | 5.0+ | Any | Any | INSERT...(default) fails for enum. Crashes CSV tables, loads spaces for MyISAM |
33767 | 2008-01-09 13:31 | 2008-01-17 22:14 | MySQL Server: Falcon storage engine | Can't repeat (6135 days) | S3 | 6.0.4 | Any | Any | Falcon crash on thread creation |
33790 | 2008-01-10 11:12 | 2008-02-15 13:03 | MySQL Server: Tests | Can't repeat (6106 days) | S3 | 5.1 | Any | Any | Fix innodb_mysql test |
35538 | 2008-03-24 22:11 | 2009-01-08 10:00 | MySQL Server: Falcon storage engine | Closed (5778 days) | S3 | 6.04 | Any | Any | Falcon three-way deadlock between scavenger, gopher and an insert |
35634 | 2008-03-28 8:54 | 2008-10-01 15:08 | MySQL Server: Command-line Clients | Won't fix (5877 days) | S4 | 5.1-bk | Any | Any | 'mysql' client: 'source' should stop after first failed command |
36258 | 2008-04-22 13:58 | 2008-05-19 12:16 | MySQL Server: Maria storage engine | Closed (6012 days) | S2 | 5.1-maria | Any | Any | Maria: INSERT SELECT sends ok to client before committing |
36559 | 2008-05-07 11:15 | 2010-05-10 18:37 | MySQL Server: Optimizer | Not a Bug (5291 days) | S1 | 5.0.46-5.0.60 | Any | Any | INSERT .. SELECT takes more time to complete on versions 5.0.46 and newer |
36802 | 2008-05-19 15:42 | 2022-01-05 15:50 | MySQL Server: Optimizer | Closed (1033 days) | S3 | 5.0, 5.1, 6.0 BK | Any | Any | MySQL only use covered index when selecting from a view (or subquery) with union |
37007 | 2008-05-27 14:36 | 2008-09-05 16:31 | MySQL Server: Maria storage engine | Closed (5903 days) | S3 | 5.1-maria | Any | Any | Maria: different checksum for MyISAM table depending on CHECKSUM=0|1 |
37281 | 2008-06-09 13:30 | 2009-05-15 12:57 | MySQL Server: Falcon storage engine | Closed (5651 days) | S2 | 6.0.6 alpha | Any (big-endian) | Any | Time stamps in Falcon on big-endian machine give wrong results |
37793 | 2008-07-02 8:26 | 2011-02-16 23:43 | MySQL Server: Command-line Clients | Verified | S4 | 5.0,5.1,6.0 | Any | Any | mysql cli verbosity level at stdin error |
37873 | 2008-07-04 14:00 | 2008-07-11 8:58 | MySQL Server: Maria storage engine | Closed (5959 days) | S3 | 5.1-maria | Any | Any | Client gets ok from INSERT VALUES before commit record is on disk |
37938 | 2008-07-07 16:33 | 2008-10-17 17:44 | Tests: Server | Closed (5861 days) | S3 | 5.1.26-rc | Any | Any | Test "mysqldump" lacks various INSERT statements / values |
38043 | 2008-07-11 10:50 | 2008-09-30 20:36 | MySQL Server: Falcon storage engine | Closed (5878 days) | S1 | 6.0-falcon | Any | Any | Deadlock between server and falcon when executing concurrent ALTER + DML |
38088 | 2008-07-13 16:03 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | No Feedback (5715 days) | S3 | 6.0 | Any | Any | rpl_row_basic_7ndb failed At line 55 INSERT INTO t2 ... |
38105 | 2008-07-14 14:58 | 2008-07-17 16:54 | MySQL Server: Documentation | Closed (5953 days) | S4 | all | Any | Any | Clarify VALUE as a synonym for VALUES in INSERT |
38701 | 2008-08-10 17:50 | 2011-02-16 23:43 | MySQL Server | Closed (5861 days) | S1 | 5.1.28,6.0.7 | Any | Any | Crash in String::append when inserting duplicate empty strings an uft8 SET col |
38725 | 2008-08-11 16:48 | 2011-02-16 23:43 | MySQL Enterprise Monitor: Documentation | Closed (5834 days) | S3 | 2.0.0.7017 | Any | Any | possible addition to the MEM2 docs |
38839 | 2008-08-18 3:08 | 2012-05-09 23:37 | MySQL Server: InnoDB storage engine | Not a Bug (5287 days) | S4 | 5.1.25-rc, 5.1.26-rc | Any | Any | auto increment does not work properly with InnoDB after update |
39162 | 2008-09-01 15:59 | 2011-02-16 23:43 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5171 days) | S1 | mysql-5.1-telco-6.3 | Any | Any | "insert ; commit" fails due to 'Transaction already aborted' from NDBCLUSTER |
39186 | 2008-09-02 13:49 | 2008-10-18 15:56 | MySQL Server | Closed (5860 days) | S3 | 6.0 | Any | Any | Crash in String::append when inserting duplicate empty strings an uft8 SET col |
39466 | 2008-09-16 3:03 | 2012-05-18 20:19 | MySQL Server: DML | Duplicate (5854 days) | S4 | 5.0+ | Any | Any | Implement INSTEAD OF Triggers |
40425 | 2008-10-30 11:50 | 2008-12-17 10:30 | MySQL Server: Maria storage engine | Can't repeat (5800 days) | S1 | 6.0 | Any | Any | Maria: ha_maria::enable_indexes(uint): Assertion `0' failed. |
40499 | 2008-11-04 13:26 | 2008-11-19 20:10 | MySQL Server: MyISAM storage engine | Not a Bug (5828 days) | S1 | 5.1 | Any | Any | INSERT INTO t SELECT * FROM t does not work with myisam if binlogging is on |
40536 | 2008-11-06 0:56 | 2011-02-16 23:43 | MySQL Server | Closed (5737 days) | S3 | 5.1.29, 5.1.23, 5.0.70 | Any | Any | SELECT is blocked by INSERT DELAYED waiting on upgrading lock, even with low_pri |
40674 | 2008-11-12 19:24 | 2015-04-14 12:38 | MySQL Server | Not a Bug (3491 days) | S3 | 5.0+ | Any | Any | SELECT ROW = (SELECT sum(outer col) FROM DUAL) ...: incorrect number of rows |
40708 | 2008-11-13 17:10 | 2018-09-25 21:49 | Tests: Replication | Closed (5756 days) | S7 | 5.1-rpl | Any | Any | rpl_row_create_table fails sporadically in pushbuild |
40790 | 2008-11-17 16:11 | 2012-02-02 10:17 | MySQL Server: Falcon storage engine | Unsupported (4658 days) | S3 | 6.0.8 | Any | Any | Falcon assertion (bdb->buffer->pageNumber == pageNumber) in Bdb*Cache::fetchPage |
40852 | 2008-11-19 13:18 | 2021-05-23 20:45 | MySQL Server: Falcon storage engine | Duplicate (5822 days) | S1 | 6.0.8-alpha | Any | Any | Falcon assert due to wrong page type in Section.cpp |
40927 | 2008-11-21 15:40 | 2018-09-25 21:49 | Tests: Replication | Closed (5806 days) | S7 | 6.0.9-bzr | Any | Any | rpl.rpl_relay_space_falcon fails when binlog-format is explicitly set to mixed |
41049 | 2008-11-26 11:24 | 2011-02-16 23:43 | MySQL Server: Security: Privileges | Closed (5253 days) | S3 | 5.0.51b-log, all | Any (FreeBSD 6.0, Linux) | Any | does syntax "grant" case insensitive? |
41114 | 2008-11-28 20:36 | 2011-02-16 23:43 | MySQL Server: Locking | Can't repeat (5036 days) | S2 | 5.0.70, 5.1.30, 5.5.0 | Any | Any | DDL + insert delayed + kill causes infinite hang and 100% cpu waiting for tables |
41378 | 2008-12-10 22:21 | 2011-02-16 23:43 | MySQL Workbench | Closed (5708 days) | S3 | 5.0.28SE | Any | Any | Insert statements don't update when changing table name |
41472 | 2008-12-15 13:54 | 2010-05-26 18:00 | MySQL Server: Falcon storage engine | Unsupported (5275 days) | S1 | 6.0-falcon-team | Any | Any | Falcon crash in MemFreeBlock::findNextLargest |
41559 | 2008-12-17 16:01 | 2009-01-15 14:09 | MySQL Workbench | Not a Bug (5771 days) | S3 | 5.0.29 | Any | Any | Wrong insert order in last versions |
41614 | 2008-12-19 6:14 | 2018-09-25 21:50 | Tests | Closed (5688 days) | S7 | 6.0, 5.1 | Any | Any | rpl_row_func003 fails sporadically: diff_files failed with error 2 |
41721 | 2008-12-23 21:37 | 2009-08-17 19:35 | MySQL Server: Backup | Duplicate (5557 days) | S3 | 6.0-backup | Any | Any | Restore generates lots of warnings |
41885 | 2009-01-05 20:15 | 2010-05-26 18:00 | MySQL Server: Falcon storage engine | Unsupported (5275 days) | S3 | 6.0.9-release | Any | Any | Falcon: slowdown in 6.0.9 in update_of_key_big test from mysql-bench suite |
41980 | 2009-01-08 20:10 | 2011-02-16 23:43 | MySQL Server: Replication | Closed (5709 days) | S2 | 5.1.30, 5.1, 6.0 bzr | Any | Any | SBL, INSERT .. SELECT .. LIMIT = ERROR, even when @@SQL_LOG_BIN is 0 ! |
42087 | 2009-01-13 15:52 | 2011-02-16 23:43 | MySQL Server: General | Verified (5709 days) | S2 | 5.1.30 | Any | Any | Statement.executeUpdate() gives strange update count with INSERT ...ON DUPLICATE |
42189 | 2009-01-18 22:05 | 2009-05-15 15:49 | MySQL Server: Falcon storage engine | Closed (5651 days) | S2 | 6.0.10-alpha | Any | Any | falcon.falcon_bug_22211 fails due to blocked transaction sees rollbacked data |
42309 | 2009-01-23 18:17 | 2011-02-16 23:43 | Connector / J | Closed (5758 days) | S3 | 5.1 | Any | Any | Statement.getGeneratedKeys() returns 2 keys when using ON DUPLICATE KEY UPDATE |
42361 | 2009-01-27 3:03 | 2009-01-27 9:03 | MySQL Enterprise Monitor: Documentation | Not a Bug (5759 days) | S3 | 2.0 | Any | Any | Inappropriate example for creating a user for an agent. |
42370 | 2009-01-27 11:24 | 2018-09-25 21:50 | Tests: Replication | Closed (5756 days) | S7 | Any | Any | rpl_trigger.test: Test case timeout after 900 seconds | |
42376 | 2009-01-27 14:51 | 2009-01-30 9:36 | Connectors: DBD::mysql ( Perl ) | Not a Bug (5756 days) | S3 | 4.010 | Any | Any | Query with SQL variables behaves different on DBI than on CLI |
42429 | 2009-01-28 16:35 | 2009-05-07 16:58 | MySQL Server: Falcon storage engine | Closed (5659 days) | S3 | 6.0.9 | Any | Any | Falcon crash in Table::checkUniqueRecordVersion |
42475 | 2009-01-30 12:51 | 2009-05-15 13:02 | MySQL Server: Falcon storage engine | Closed (5651 days) | S3 | 6.0.9 | Any | Any | Falcon can crash in Sync::findLocks after a timeout. |
43079 | 2009-02-21 13:41 | 2011-02-16 23:43 | Tests | Can't repeat (5596 days) | S3 | 5.1, 6.0-rpl | Any | Any | main.mysqldump fails sporadically on pushbuild |
43306 | 2009-03-02 13:16 | 2012-05-18 20:19 | MySQL Server: Charsets | Duplicate (5715 days) | S1 | 5.1, 6.0 | Any | Any | Wrong utf8 collation default behaviour |
43307 | 2009-03-02 13:25 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5722 days) | S1 | 5.1, 6.0 | Any | Any | default collation will be ignored |
43311 | 2009-03-02 20:23 | 2011-02-16 23:43 | MySQL Server: General | Duplicate (5693 days) | S2 | 5.0.77 | Any | Any | Wrong number of affected rows returned for insert on duplicate key |
43602 | 2009-03-12 15:43 | 2011-02-16 23:43 | Connector / J | Can't repeat (5715 days) | S2 | 5.1.7 | Any | Any | specific year,month,day,hour combination throws MysqlDataTruncationException |
43620 | 2009-03-13 6:34 | 2009-05-07 8:32 | MySQL Server: Maria storage engine | Closed (5659 days) | S3 | 6.0.11-bzr | Any | Any | Maria throws 'Got error 176 from storage engine' on a range query |
43658 | 2009-03-15 16:07 | 2009-03-15 18:42 | MySQL Server: DML | Not a Bug (5712 days) | S1 | 5.1 | Any | Any | The code below returns an error, while other databases allow it |
43895 | 2009-03-26 18:45 | 2014-07-14 15:31 | MySQL Server: DML | Closed (3765 days) | S3 | 5.1 bzr | Any | Any | Multi-DELETE IGNORE does not report warnings |
44228 | 2009-04-13 0:35 | 2009-04-18 20:51 | Connector / NET | Not a Bug (5678 days) | S2 | 5.2.5 | Any | Any | Unable to insert UTF string into varchar column |
44275 | 2009-04-14 21:58 | 2012-05-18 20:19 | MySQL Workbench | Duplicate (5679 days) | S1 | 5.1.10 Beta Build 5309 | Any | Any | No INSERT Statements are being generated |
44973 | 2009-05-20 8:30 | 2011-02-16 23:43 | Connector / NET | Duplicate (5646 days) | S1 | 6.0.3 | Any | Any | Can't insert backslash |
45757 | 2009-06-25 16:08 | 2013-06-26 16:00 | Connector / J | Closed (4148 days) | S3 | 5.0.8, 5.1.6, 5.1.7, 5.1.14 | Any | Any | ResultSet.updateRow should throw SQLException when cursor is on insert row |
45825 | 2009-06-29 14:55 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5175 days) | S2 | 5.1+ | Any | Any | INSERT DELAYED is not unsafe: logged in statement format |
45864 | 2009-06-30 20:20 | 2011-02-16 23:44 | MySQL Server | Duplicate (5604 days) | S2 | 5.1.35, 5.1 bzr | Any | Any | insert on one connection, immediate query on another produces no result |
45903 | 2009-07-02 10:42 | 2009-07-03 8:59 | MySQL Server: Data Types | Not a Bug (5602 days) | S3 | 5.1 | Any (SQL) | Any | insert date fields should give an error if inserted Data is not formated correct |
45986 | 2009-07-07 3:16 | 2011-02-16 23:44 | MySQL Server: InnoDB storage engine | Can't repeat (5597 days) | S1 | 5.1.36-community | Any (Windows Server 2008 x64) | Any | InnoDB: Assertion failure in thread 6472 in file .\buf\buf0flu.c line 279 |
46489 | 2009-07-31 11:39 | 2013-12-20 7:04 | MySQL Server: DDL | Won't fix (3971 days) | S3 | 6.1-fk-stage | Any | Any | Foreign keys: MERGE engine should be disallowed. |
46615 | 2009-08-08 9:03 | 2011-02-16 23:44 | MySQL Server: Query Cache | Closed (5252 days) | S3 | 5.1,5.4 | Any | Any | Assertion in Query_cache::invalidate in INSERT in a VIEW of a MERGE table |
46639 | 2009-08-10 22:51 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5527 days) | S1 | 5.1.36 | Any | Any | 1030 (HY000): Got error 124 from storage engine on INSERT ... SELECT ... |
46675 | 2009-08-12 13:35 | 2011-08-19 15:15 | MySQL Server: General | Closed (4825 days) | S3 | server 5.1.37 | Any (MS Windows, Mac, Linux) | Any | ON DUPLICATE KEY UPDATE and updateCount() possibly wrong |
46911 | 2009-08-25 6:56 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (5535 days) | S2 | 5.1.37 | Any | Any | Inconsistent SHOW CREATE TABLE result before/after FLUSH STATUS w/ partitioning |
47118 | 2009-09-04 1:35 | 2020-11-25 3:42 | MySQL Server: General | Verified (1439 days) | S1 | 5.1.39, 5.1.37, 5.0.83,8.0.22, 5.6.10 | Any | Any | Wrong auto_increment value when auto_increment_offset > auto_increment_increment |
49100 | 2009-11-25 13:17 | 2011-02-16 23:44 | MySQL Server: Row Based Replication ( RBR ) | Closed (5088 days) | S3 | 6.0-codebase, mysql-5.1-rpl-wl5092 | Any | Any | RBR: Unexpected behavior when AI contains no usable data for slave columns |
49128 | 2009-11-26 9:35 | 2011-08-17 14:51 | MySQL Server | Won't fix (4827 days) | S4 | all | Any | Any | Status variable for delayed insert queue waits is missing |
49349 | 2009-12-02 13:29 | 2018-11-04 20:45 | MySQL Server: Optimizer | Duplicate (4332 days) | S3 | 6.0 | Any | Any | Wrong cost calculation for duplicate weed-out |
49733 | 2009-12-16 11:05 | 2012-05-18 20:19 | MySQL Server: General | Duplicate (5435 days) | S3 | 5.0, mysqld-5.1.41-community, 5.1, next-mr bzr | Any (MS Windows, Linux) | Any | using backslash in NO_BACKSLASH_ESCAPES mode can cause corruption |
50238 | 2010-01-11 15:08 | 2022-12-04 20:45 | MySQL Server: Security: Privileges | Verified | S3 | 5.5.1-m2 | Any | Any | 'GRANT SUPER' doesn't give 'TABLESPACE' priv in fresh 5.5, upgrade from 5.1 does |
50413 | 2010-01-18 13:54 | 2018-11-30 13:16 | MySQL Server: InnoDB storage engine | Closed (4009 days) | S1 | 5.0.91,5.1.50,5.6.0 | Any | Any | insert on duplicate key update sometimes writes binlog position incorrectly |
50507 | 2010-01-21 14:12 | 2015-07-15 15:38 | MySQL Server | Closed (3902 days) | S3 | 5.0+ | Any | Any | Behavior of logarithmic functions depends on ERROR_FOR_DIVISION_BY_ZERO |
50517 | 2010-01-21 17:39 | 2010-03-02 1:44 | MySQL Server: Backup | Closed (5360 days) | S2 | 6.0.14-alpha | Any | Any | mysqldump.test sometimes times out |
50620 | 2010-01-26 11:36 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5249 days) | S3 | 5.5.99, next-mr, 5.1 | Any | Any | Adding an index to a table prevents slave from logging into slow log |
50917 | 2010-02-04 15:23 | 2012-05-18 20:19 | MySQL Server: Replication | Verified (5084 days) | S3 | 5.1.43,5.5.2-m2 | Any | Any | slave stops with HA_ERR_KEY_NOT_FOUND |
50996 | 2010-02-08 14:32 | 2011-02-16 23:44 | MySQL Server: Optimizer | Closed (5182 days) | S3 | Any | Any | Wrong result for second call of prepared statement with view in subselect | |
50998 | 2010-02-08 15:00 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5355 days) | S2 | mysql-next-4284 | Any | Any | Deadlock in MDL code during test rqg_mdl_stability |
51016 | 2010-02-09 8:57 | 2020-05-03 20:45 | MySQL Server: Optimizer | Duplicate (5379 days) | S3 | 6.0-codebase-bugfixing | Any | Any | Batched key access gives wrong results for T0 semijoin (T1 join T2) |
51157 | 2010-02-13 0:04 | 2016-11-05 10:15 | MySQL Enterprise Monitor: Server | Won't fix (2920 days) | S3 | 2.2.0.1616 | Any | Any | INSERT statements with blob data cause JDBC Exception (quan via proxy) |
51307 | 2010-02-19 7:06 | 2011-02-16 23:44 | MySQL Server: MyISAM storage engine | Closed (5252 days) | S1 | 5.1.34, 5.1.44, 5.1.45-bzr,5.5.1-m2 | Any | Any | widespread corruption with partitions and insert...select |
51426 | 2010-02-23 15:57 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5205 days) | S3 | 5.1.44,5.5.99-m3 | Any | Any | User var unsigned_flag value not preserved until binlog time |
51593 | 2010-03-01 1:46 | 2011-05-26 19:42 | MySQL Server: Documentation | Closed (4910 days) | S3 | 5.0 and 5.1 | Any | Any | MySQL Documentation Incorrect on 'ALTER' Privilege |
51966 | 2010-03-11 19:08 | 2011-02-16 23:44 | MySQL Server: Locking | No Feedback (5317 days) | S3 | 5.1.40-community | Any | Any | INSERT ... SELECT should allow concurrent inserts when binary log is disabled. |
52140 | 2010-03-17 14:37 | 2011-02-16 23:44 | MySQL Server: Documentation | Closed (5290 days) | S3 | Any | Any | search for function on the documentation page does not work well | |
52393 | 2010-03-26 14:05 | 2012-07-19 23:17 | MySQL Server: Documentation | Closed (4490 days) | S3 | 5.1 and later | Any | Any | innodb_io_capacity documentation error |
53143 | 2010-04-25 16:13 | 2012-05-18 20:19 | Connector / NET | No Feedback (5154 days) | S2 | 6.0.5 | Any | Any | Transactions not working with .Net Entity framework connector |
53421 | 2010-05-04 20:28 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5227 days) | S2 | 5.5.5-m3, 5.6.99-m4 | Any | Any | Part of transaction not written in binlog after deadlock, replication breaks |
54249 | 2010-06-05 2:32 | 2017-05-21 20:45 | MySQL Server: Row Based Replication ( RBR ) | Verified (5264 days) | S3 | 5.1 | Any | Any | More verbose RBR error logging |
54332 | 2010-06-08 11:31 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5097 days) | S3 | 5.5.5-m3 | Any | Any | Deadlock with two connections doing LOCK TABLE+INSERT DELAYED |
54538 | 2010-06-16 1:23 | 2011-02-16 23:44 | MySQL Server: InnoDB Plugin storage engine | Closed (5073 days) | S3 | 5.1.47 | Any | Any | use of exclusive innodb dictionary lock limits performance |
54677 | 2010-06-21 18:25 | 2013-06-14 19:46 | MySQL Server | Verified | S4 | 5.6 | Any | Any | INSERT INTO ... ON FAILURE UPDATE ... |
55211 | 2010-07-13 13:50 | 2017-05-21 20:45 | MySQL Server: Replication | Verified (5227 days) | S2 | 5.1+ | Any | Any | INSERT...SELECT...LIMIT...UNION should be marked unsafe |
55499 | 2010-07-23 8:13 | 2011-02-16 23:44 | MySQL Server | Closed (5133 days) | S3 | 5.1-wl5370 | Any | Any | Wrong binlog(Repl. breaks) with 'CREATE TABLE IF NOT EXISTS' & tbl prefix schema |
55598 | 2010-07-28 10:11 | 2011-02-16 23:44 | MySQL Server | Closed (5133 days) | S2 | 5.1-wl5370 | Any | Any | RBR: CREATE TABLE IF NOT EXISTS and INSERT written to binary log twice |
55617 | 2010-07-28 21:48 | 2011-02-16 23:44 | MySQL Server | Closed (5170 days) | S3 | trunk-wl5370 | Any | Any | Irrelevant error on attempt to override an existing view by CREATE IF NOT EXISTS |
55824 | 2010-08-08 16:40 | 2015-08-10 14:34 | MySQL Server: mysqldump Command-line Client | Duplicate (5071 days) | S3 | 5.1+ | Any | Any | Option or compatibility mode for mysqldump to NOT quote decimal values |
55978 | 2010-08-13 18:54 | 2011-02-16 23:44 | MySQL Server: DML | No Feedback (5132 days) | S4 | Any | Any | Improvement Mysql Date Manipulation Language | |
56251 | 2010-08-25 13:21 | 2011-02-16 23:44 | MySQL Server: Locking | Closed (5097 days) | S3 | 5.5 | Any | Any | Deadlock with INSERT DELAYED and MERGE tables |
56913 | 2010-09-21 23:39 | 2011-02-16 23:44 | Tests: Replication | Closed (5102 days) | S3 | mysql-next-mr-bugfixing | Any | Any | rpl_row_ignorable_event fails sporadically on next-mr-bugfixing codebase. |
57166 | 2010-10-01 12:58 | 2011-02-16 23:44 | MySQL Server: Row Based Replication ( RBR ) | Won't fix (5140 days) | S3 | mysql-5.1 (any) | Any | Any | Row based replication not able to convert from 'old' to 'new' DECIMAL |
57666 | 2010-10-22 17:16 | 2011-02-16 23:44 | MySQL Server: Replication | Closed (5050 days) | S3 | 5.5.7, 5.6.99 | Any | Any | Unclear warning with broken text in error log on INSERT DELAYED |
57813 | 2010-10-28 14:40 | 2018-12-09 20:45 | MySQL Enterprise Monitor: Web | Verified (5120 days) | S3 | 2.3.0.2036 | Any | Any | MEM Dashboard: could not insert: [com.mysql.etools.monitor.pom.hib.HibNamed |
58321 | 2010-11-19 11:56 | 2011-02-16 23:44 | MySQL Server: Charsets | Closed (5065 days) | S3 | 5.6, 5.5 | Any | Any | No warning when characters outside BMP0 is converted to UCS2 |
58379 | 2010-11-22 12:37 | 2014-07-23 20:46 | MySQL Workbench: Modeling | Closed (3756 days) | S4 | 5.2.31 | Any | Any | Insert with Recursave dependency in Foreign Keys throws error |
58637 | 2010-12-01 19:44 | 2014-06-25 14:34 | MySQL Server: Replication | Closed (4580 days) | S2 | 5.1+, 5.0, 5.6.1 | Any | Any | Mark INSERT...ON DUPLICATE KEY UPDATE unsafe when there is more than one key |
58799 | 2010-12-07 19:55 | 2010-12-18 0:13 | MySQL Server: Command-line Clients | Not a Bug (5069 days) | S2 | Any | Any | You cannot revoke using db.* syntax grants given with db.tablename | |
58864 | 2010-12-10 12:13 | 2011-07-19 15:09 | MySQL Server: Documentation | Closed (4856 days) | S4 | 5.1 | Any | Any | Clarify LAST_INSERT_ID() behavior on update by INSERT ON DUPLICATE KEY UPDATE |
59042 | 2010-12-19 18:44 | 2010-12-19 18:44 | MySQL Server: Security: Privileges | Open | S4 | 5.1.52 | Any | Any | INSERT ... ON DUPLICATE KEY UPDATE shouldn;t need UPDATE access to key columns |
59205 | 2010-12-29 6:14 | 2011-03-30 7:58 | MySQL Server: Replication | Closed (4967 days) | S3 | 5.6 | Any | Any | Test rpl.rpl_stm_000001 fail on Valgrind with binlog-checksum enabled |
60173 | 2011-02-18 20:54 | 2013-05-30 19:33 | MySQL Server: Replication | Closed (4175 days) | S2 | 5.1.47, 5.1.64, 5.5.27 | Any | Any | Partially written insert statement in binlog -- no errors reported |
61134 | 2011-05-11 14:32 | 2011-05-17 14:17 | Connector / J | Duplicate (4919 days) | S2 | 5.1.16 | Any | Any | bad row affected values with INSERT ON DUPLICATE KEY UPDATE |
61191 | 2011-05-16 20:53 | 2012-01-10 3:52 | MySQL Server: InnoDB Plugin storage engine | Closed (4681 days) | S3 | 5.1.52 | Any | Any | question about page_zip_available |
61548 | 2011-06-17 8:55 | 2012-11-16 13:07 | MySQL Server: Replication | Closed (4370 days) | S3 | 5.1 and others | Any | Any | autoinc value persistency breaks certain replication scenarios |
61962 | 2011-07-23 21:43 | 2011-08-06 12:44 | MySQL Server | Not a Bug (4838 days) | S1 | 5.5.14 | Any (Tested on 5.5.8 and 5.5.14) | Any | 'ON DUPLICATE KEY UPDATE' bug incrementing ID (auto increment field) on Updates |
62323 | 2011-09-01 14:01 | 2018-07-02 13:59 | MySQL Server: Documentation | Won't fix (2316 days) | S4 | Any | Any | Documentation of 'NaN' | |
63692 | 2011-12-09 7:38 | 2011-12-09 8:08 | MySQL Server: General | Unsupported (4713 days) | S3 | Any | Any | Unable to insert certain big ascii characters under utf8 encoding | |
64428 | 2012-02-23 2:15 | 2012-02-23 4:14 | MySQL Enterprise Monitor: Server | Not a Bug (4637 days) | S5 | 5 | Any | Any | How To insert data to table from other Host in Public IP |
64817 | 2012-03-30 16:04 | 2012-03-31 7:32 | MySQL Server: DML | Not a Bug (4600 days) | S3 | 5.1 | Any | Any | INSERT INTO ... VALUES(0,... uses auto_increment value instead |
66079 | 2012-07-30 2:59 | 2012-08-01 14:19 | MySQL Server: InnoDB storage engine | Verified (4479 days) | S5 | 5.5+ | Any | Any | unnecessary calling trx_sys_update_mysql_binlog_offset when sql_log_bin=0 |
66188 | 2012-08-03 20:02 | 2012-10-06 1:00 | MySQL Server: Options | No Feedback (4412 days) | S3 | 5.5.23, 5.5.27 | Any | Any | Cannot use CREATE TEMPORARY...INSERT with InnoDB when read_only is set |
66540 | 2012-08-25 20:04 | 2013-01-23 1:00 | MySQL Server: DML | No Feedback (4303 days) | S4 | Any | Any | Redundant coding in ON DUPLICATE KEY UPDATE | |
66586 | 2012-08-28 21:51 | 2013-01-10 12:20 | MySQL Server: InnoDB storage engine | Closed (4315 days) | S3 | 5.6.6, 5.6.7 | Any | Any | SHOW INNODB STATUS and I_S show wrong transaction start time and duration |
66871 | 2012-09-19 13:13 | 2015-01-09 9:50 | Connector / C++ | Not a Bug (3586 days) | S1 | 1.1.1 | Any | Any | #error 1040, Too many connections, How to disconnect mysql connection manual use |
67535 | 2012-11-09 13:41 | 2014-02-03 0:33 | MySQL Server: DML | Verified (4366 days) | S3 | 5.0.97, 5.1.67, 5.5.29, 5.7.0 | Any (MS Windows, Linux) | Any | LAST_INSERT_ID() and INSERT IGNORE behavior |
67978 | 2012-12-27 6:13 | 2012-12-29 16:21 | MySQL Server: Memory storage engine | Verified (4327 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | Signed zero is handled incorrectly by HASH indexes and GROUP BY |
68041 | 2013-01-06 3:29 | 2013-07-19 15:02 | MySQL Server: DML | Closed (4125 days) | S3 | 5.6.9 | Any | Any | Zero date can be inserted in strict no-zero mode through a default value |
68192 | 2013-01-27 20:52 | 2013-01-28 15:40 | MySQL Server: Data Types | Verified (4297 days) | S3 | 5.1, 5.5, 5.6.9 | Any | Any | Limitation on DOUBLE or REAL length is ignored with INSERT .. SELECT |
68472 | 2013-02-23 15:45 | 2013-03-07 16:25 | MySQL Server: Data Types | Closed (4259 days) | S3 | 5.6.10 | Any | Any | TIMESTAMP logic remains partly non-standard with explicit_defaults_for_timestamp |
68885 | 2013-04-08 7:46 | 2013-04-21 12:09 | MySQL Server: DML | Verified (4214 days) | S4 | 5.5+ | Any | Any | a new parameter to control whether rollback a whole transaction on statment fail |
69122 | 2013-05-02 6:06 | 2014-02-02 17:47 | MySQL Server: InnoDB storage engine | Closed (4070 days) | S3 | 5.1,5.6 | Any | Any | InnoDB doesn't redo-log insert buffer merge operation if it is done in-place |
70583 | 2013-10-10 8:14 | 2014-08-06 17:08 | MySQL Server: Replication | Closed (3777 days) | S2 | 5.6.14 | Any | Any | INSERT ON DUPLICATE KEY UPDATE failing after MySQL 5.6 upgrade. |
71328 | 2014-01-09 14:27 | 2015-05-26 13:05 | MySQL Server: Documentation | Closed (3449 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | Manual does not describe how to monitor InnoDB change buffer usage |
72314 | 2014-04-11 5:04 | 2015-02-25 5:01 | MySQL Server: Replication | Closed (3539 days) | S1 | Any | Any | stop io_thread, start io_thread with GTID may cause data inconsistencies | |
72748 | 2014-05-26 8:56 | 2018-10-11 17:07 | MySQL Server: Locking | Can't repeat (2215 days) | S2 | 5.6.17, 5.6.19, 5.6.21 | Any | Any | INSERT...SELECT fails to block concurrent inserts, results in additional records |
73056 | 2014-06-19 21:34 | 2018-03-15 14:17 | MySQL Server: Prepared statements | Closed (3159 days) | S5 | 5.7, 5.7.8 | Any | Any | Prepared Statements ABSURDLY SLOW due to inefficient query creation for logging |
73399 | 2014-07-25 18:32 | 2014-07-25 18:56 | MySQL Server: Stored Routines | Verified (3754 days) | S1 | 5.6.14, 5.0.97, 5.1.74, 5.5.39, 5.6.21, 5.7.5 | Any | Any | BEFORE INSERT TRIGGER not fired |
73504 | 2014-08-08 0:51 | 2014-12-10 12:49 | MySQL Server: Performance Schema | Closed (3677 days) | S3 | 5.6 | Any | Any | performance_schema digests do not handle negative numbers well |
73601 | 2014-08-15 12:33 | 2016-04-27 15:03 | MySQL Server: Replication | Closed (3510 days) | S2 | 5.7 | Any | Any | Crash on direct insert into mysql.gtid_executed table |
75189 | 2014-12-12 7:09 | 2014-12-19 22:15 | MySQL Server: Tests | Verified (3607 days) | S3 | 5.6 | Any | Any | engines suite tests depending on InnoDB implementation details |
76206 | 2015-03-07 9:41 | 2018-07-16 11:56 | MySQL Server: Documentation | Closed (3519 days) | S3 | All | Any | Any | AUTO_INCREMENT behaviour not fully documented where values given explicitly |
77783 | 2015-07-20 7:01 | 2019-10-25 12:00 | MySQL Server: InnoDB storage engine | Can't repeat (1836 days) | S5 | 5.7, 5.6 | Any | Any | performance dropped when changing innodb_change_buffering from inserts to all |
77959 | 2015-08-06 10:45 | 2021-02-18 9:57 | MySQL Server: Tests | Duplicate (1354 days) | S3 | 5.7.8, 5.7.9 | Any | Any | max_statement_time test is unstable |
78127 | 2015-08-18 12:16 | 2019-11-26 21:50 | MySQL Server: DML | Closed (1804 days) | S3 | 5.6.22, 5.5.46, 5.6.26 | Any | Any | In consistent behavior between similar UPDATE sqls, error vs warning |
78239 | 2015-08-27 8:08 | 2018-02-06 18:18 | MySQL Workbench | Verified (2462 days) | S4 | 6.3 | Any | Any | Insert new column at cursor |
78253 | 2015-08-28 8:35 | 2015-09-01 6:35 | MySQL Server: DML | Not a Bug (3351 days) | S5 | 4.2.11 | Any | Any | A major problem is found in insert query of my sql which need attention |
78348 | 2015-09-06 9:09 | 2015-09-07 7:38 | MySQL Server: Command-line Clients | Closed (3345 days) | S3 | 5.7.8 | Any | Any | mysqlpump support for 4-byte UTF-8 |
79065 | 2015-11-02 8:27 | 2018-10-21 20:45 | MySQL Server | No Feedback (3259 days) | S3 | 5.5 | Any | Any | insert data into DB met error:"Fatal error encountered during command execution" |
79122 | 2015-11-04 15:41 | 2016-02-04 20:18 | MySQL Server: Prepared statements | Closed (3281 days) | S3 | 5.7.10 | Any | Any | memory leaks when doing INSERT... UPDATE ... prepared statements |
79259 | 2015-11-13 3:47 | 2019-11-04 18:33 | MySQL Server: DML | Not a Bug (1826 days) | S3 | 5.7.8 | Any | Any | Get inconsistent result for invalid date in column and const,compared w/ date |
79507 | 2015-12-03 12:55 | 2019-11-28 22:34 | MySQL Server: DML | Closed (1802 days) | S3 | 5.6.22, 5.5.48 | Any | Any | String function insert is not working as doc says |
79567 | 2015-12-09 7:41 | 2019-11-28 22:55 | MySQL Server: DML | Closed (1802 days) | S3 | 5.7.8, 5.5.48, 5.6.29, 5.7.9 | Any | Any | Output scale for IFNULL() with join is not correct |
79909 | 2016-01-11 6:23 | 2020-10-05 12:18 | MySQL Server: DML | Closed (1490 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Get mess code for func INSERT() with str as int const and newstr as multi-byte |
80559 | 2016-02-29 14:32 | 2016-02-29 15:17 | MySQL Server: Parser | Verified (3170 days) | S3 | 5.7.11 | Any | Any | EXPLAIN CREATE TABLE .. AS SELECT .. does not work |
81563 | 2016-05-24 8:18 | 2016-05-26 13:13 | MySQL Server | Not a Bug (3083 days) | S3 | 5.6.21,5.6.16 | Any | Any | Insert operation will add S-lock on one record after deleted one. |
81628 | 2016-05-27 17:25 | 2016-12-12 16:42 | MySQL Server: Replication | Closed (3009 days) | S3 | 5.7.14 | Any | Any | Assertion failure in 'MYSQL_BIN_LOG::prepare()' if DML is passed in --init-file |
81642 | 2016-05-30 11:26 | 2016-05-30 16:02 | MySQL Server: Data Types | Not a Bug (3079 days) | S3 | 5.7.8 | Any | Any | union of decimal(10,1) and decimal(10,9) is not expected decimal(18,9) |
82325 | 2016-07-22 18:08 | 2016-07-25 18:50 | MySQL Server: Data Types | Duplicate (3023 days) | S3 | 5.7.9 | Any | Any | DateTime values rounded in set/insert clause but not in where clause |
82642 | 2016-08-19 3:58 | 2016-08-19 7:59 | MySQL Server: DML | Verified (2998 days) | S3 | 5.6, 5.5.51, 5.6.32 | Any | Any | insert string-format value to datetime and timestamp return different status |
84365 | 2016-12-29 2:44 | 2021-12-18 22:54 | Connector / J | Closed (1051 days) | S3 | 8.0.26 | Any | Any | INSERT..VALUE with VALUES function lead to a StringIndexOutOfBoundsException |
84587 | 2017-01-20 13:43 | 2017-06-01 16:21 | MySQL Server: Optimizer | Closed (2721 days) | S2 | 8.0 | Any | Any | WL#9236: including or excluding columns from SELECT list makes results wrong |
85047 | 2017-02-17 11:03 | 2017-07-17 12:30 | MySQL Server: Group Replication | Closed (2701 days) | S2 | 5.7.18 | Any | Any | Secondaries allows transactions through ASYNC setup into the group |
85605 | 2017-03-24 9:56 | 2019-06-25 15:28 | MySQL Server: InnoDB storage engine | Verified (2781 days) | S2 | 5.7, 8.0 | Any | Any | Corrupted index for ON DELETE CASCADE with self-referential ON DELETE SET NULL |
86821 | 2017-06-26 4:06 | 2024-08-22 22:30 | MySQL Server: Stored Routines | Closed (73 days) | S2 | 5.6, 5.7 | Any | Any | Trigger allocates memory during SELECT |
87734 | 2017-09-12 9:02 | 2017-10-24 14:17 | MySQL Server: Replication | Closed (2585 days) | S3 | 8.0 | Any | Any | Replication does not handle NULL inserted in JSON NOT NULL column correctly |
87794 | 2017-09-18 15:10 | 2017-09-19 15:33 | MySQL Server: DML | Not a Bug (2602 days) | S3 | 5.7.17 | Any | Any | MySQL gives invalid value for float column type. |
88091 | 2017-10-13 22:02 | 2017-10-16 16:32 | Connector / J | Duplicate (2575 days) | S1 | 6.0.6 and 8.0.8 | Any | Any | getTables in mysql connector 6.x+ differs from mysql connector 5.1.41 |
89122 | 2018-01-05 16:47 | 2018-03-19 17:49 | MySQL Server: GIS | Closed (2483 days) | S3 | 8.0.5 | Any | Any | Severe performance regression in server bootstrap |
89245 | 2018-01-15 14:09 | 2018-01-19 15:55 | MySQL Server: Documentation | Not a Bug (2480 days) | S3 | Any | Any | Documentation bug on triggers | |
89965 | 2018-03-08 14:07 | 2020-10-02 12:48 | MySQL Server | Not a Bug (1493 days) | S4 | 8.0 | Any | Any | Need Validation when we insert data to the column with SRID |
90448 | 2018-04-16 12:09 | 2018-04-20 5:46 | MySQL Server: Replication | Verified (2389 days) | S3 | 5.7.21 | Any | Any | INSERT IGNORE not ignored on SQL thread |
90890 | 2018-05-16 15:49 | 2018-09-04 13:25 | MySQL Server: InnoDB storage engine | Closed (2252 days) | S5 | 8.0.11 | Any | Any | CPU overhead for insert benchmark load increased by 2X in 8.0.11 |
91049 | 2018-05-28 17:38 | 2018-06-08 14:02 | MySQL Server | Not a Bug (2342 days) | S3 | 5.5.38 | Any | Any | deleting duplicate complains about foreign key |
91394 | 2018-06-24 21:41 | 2018-12-19 14:15 | Shell AdminAPI InnoDB Cluster / ReplicaSet | Closed (2146 days) | S1 | 8.0.11 | Any | Any | mysqlsh will not recognize root privileges if they are assigned with a role |
92501 | 2018-09-19 12:47 | 2019-05-22 5:53 | MySQL Server: Data Types | Closed (2126 days) | S3 | 5.7, 5.7.23, 8.0.12, 5.6.41 | Any | Any | FROM_UNIXTIME accepts an out of range parameter through rounding |
95079 | 2019-04-23 2:32 | 2019-04-25 9:21 | MySQL Server: InnoDB storage engine | Verified (2021 days) | S3 | 5.7, 5.7.25 | Any | Any | False duplicate key check |
95096 | 2019-04-24 1:27 | 2019-04-24 6:03 | MySQL Server: DML | Not a Bug (2020 days) | S3 | Any | Any | INSERT INTO ... ON DUPLICATE KEY UPDATE returns wrong number of rows updated | |
96053 | 2019-07-02 7:17 | 2020-04-13 16:44 | MySQL Server: mysqldump Command-line Client | Closed (1665 days) | S2 | 8.0.13, 8.0.16, 5.7.26 | Any | Any | mysqldump generates invalid insert statements with varbinary columns |
96540 | 2019-08-14 20:19 | 2019-08-29 20:14 | MySQL Server: Errors | Can't repeat (1893 days) | S2 | 5.6.22, 5.6.34 | Any | Any | Error 1022 on INSERT/UPDATE to InnoDB table with a fulltext index defined |
96628 | 2019-08-23 3:21 | 2019-08-24 2:23 | Connector / J | Not a Bug (1898 days) | S1 | 8.0.17 | Any | Any | mysql batch insert generatedKeys not accord expected |
96748 | 2019-09-04 11:59 | 2023-03-22 13:45 | MySQL Server: Locking | Not a Bug (1887 days) | S3 | 8.0.17 | Any | Any | deadlock when doing SELECT FOR UPDATE and INSERT |
97027 | 2019-09-26 10:02 | 2021-01-15 16:47 | MySQL Server: Row Based Replication ( RBR ) | Verified (1388 days) | S2 | 5.7.* | Any | x86 | Bulk insert with ON DUPLICATE KEY UPDATE breaks replicaiton |
98496 | 2020-02-05 20:21 | 2023-09-11 7:38 | MySQL Server: JSON | Duplicate (419 days) | S3 | 5.7, 8.0 | Any | Any | JSON columns allow empty string, allowing invalid JSON in binlog row images |
98651 | 2020-02-18 23:49 | 2020-02-19 12:05 | MySQL Server: Replication | Verified (1719 days) | S2 | 8.0, 8.0.19 | Any | Any | Inserting into temporary table from function breaks replication in MIXED mode |
99524 | 2020-05-12 9:09 | 2020-05-12 11:05 | MySQL Server: DML | Verified (1636 days) | S3 | 5.6/5.7/8.0 | Any | Any | different subquery results with primary key or not |
101862 | 2020-12-04 1:31 | 2020-12-10 13:32 | MySQL Server: DML | Verified (1430 days) | S3 | 8.0 | Any | Any | insert into t1 values (),(); failed when binlog_row_image=minimal |
102031 | 2020-12-19 5:23 | 2021-06-03 18:39 | MySQL Server: Prepared statements | Closed (1249 days) | S3 | 5.6, 5.7, 8.0 | Any | Any | reprepare at the beginning of an implicit trans will cause 1837 error |
102291 | 2021-01-19 9:17 | 2021-01-19 9:58 | MySQL Server: Optimizer | Verified (1384 days) | S1 | 8.0, 8.0.22, 8.0.23 | Any | Any | Subquery produces wrong result when set big_tables = 1 |
102886 | 2021-03-09 13:21 | 2021-04-24 15:40 | MySQL Server: Japanese Documentation | Closed (1289 days) | S3 | 8.0.23 | Any | Any | 1.3 MySQL 8.0 の新機能(リソース管理~) |
103137 | 2021-03-29 10:03 | 2021-05-17 14:35 | MySQL Server: Documentation | Closed (1277 days) | S3 | 8.0.20 | Any | Any | Deprecated VALUES vs INSERT SELECT ON DUPLICATE KEY UPDATE |
105074 | 2021-09-29 11:18 | 2021-09-30 11:47 | MySQL Cluster: Cluster (NDB) storage engine | Closed (1130 days) | S3 | 8.0.23++ | Any | Any | Take over error: DELETE immediately followed by INSERT |
105724 | 2021-11-26 19:15 | 2021-11-28 8:23 | MySQL Cluster: Cluster (NDB) storage engine | Verified (1071 days) | S3 | 8.0.27 | Any | Any | LQHKEYREQ races COMMIT signal in COPY_FRAGREQ situations |
105819 | 2021-12-07 9:48 | 2021-12-07 14:38 | MySQL Server: Data Types | Verified (1062 days) | S3 | 8.0 | Any | Any | Conversion from Blob/Text column value to double does not return a truncation er |
106312 | 2022-01-27 18:14 | 2022-02-09 13:20 | MySQL Server: Optimizer | Verified (1010 days) | S3 | 5.7 | Any (Ubuntu 20.04.3 LTS) | Any (Intel(R) Core(TM) i7-10700 CPU @ 2.90GHz) | Huge value in GROUP BY clause cause unexpected output |
106671 | 2022-03-08 12:12 | 2022-03-11 8:00 | MySQL Server: Replication | Verified (968 days) | S3 | 5.7.35, 5.7.37 | Any | Any | Contribution by Tencent: mark insert select with autoinc column unsafe |
107029 | 2022-04-14 22:42 | 2022-04-15 13:19 | MySQL Server: Locking | Not a Bug (933 days) | S3 | 8.0.28 | Any | Any | deadlock when using trigger logic implementation |
107157 | 2022-04-29 3:49 | 2022-04-29 5:41 | MySQL Server: InnoDB storage engine | Verified (919 days) | S3 | 8.0.22, 8.0.29 | Any | Any | Contribution by Tencent: Collation compare handling is confused in Innobase |
107385 | 2022-05-24 9:41 | 2022-05-27 11:56 | MySQL Server | Not a Bug (894 days) | S3 | 8.0.28 | Any | Any | Different result of GT expression for binary type |
107577 | 2022-06-16 8:38 | 2023-11-30 12:30 | Connector / J | Closed (339 days) | S2 | 8.0.29 | Any | Any | rewriteBatchedStatements not work when table column name contains 'value' string |
108145 | 2022-08-16 8:13 | 2022-10-21 20:45 | Connector / Python | Closed (744 days) | S2 | 8.0.30 | Any | Any | MySQLCursor.executemany() fails to correctly identify BULK data loading ops |
109141 | 2022-11-18 18:41 | 2024-10-11 7:57 | Connector / NET | Can't repeat (566 days) | S2 | Any | Any | Insert of data into a table results in System.ArgumentException | |
109339 | 2022-12-12 12:44 | 2023-04-10 22:02 | Connector / J | Verified (689 days) | S3 | 8.0.22, 8.0.31 | Any | Any | Failed to insert bignums due to overflow |
109418 | 2022-12-17 4:00 | 2024-10-07 20:30 | Connector / J | Closed (27 days) | S2 | 8.0.31 | Any | Any | batch insert threw an unexpected exception |
110275 | 2023-03-06 4:42 | 2023-03-07 13:19 | MySQL Server: DDL | Not a Bug (607 days) | S5 | 8.0.25 | Any | Any | The number of tables increases, the table creation speed slows down. |
110432 | 2023-03-20 10:19 | 2023-03-20 12:46 | Connector / J | Verified (594 days) | S3 | 8.0.32 | Any | Any | batch insert failed |
110882 | 2023-05-02 7:26 | 2023-05-03 12:51 | MySQL Server: Optimizer | Not a Bug (550 days) | S3 | 8.0 | Any | Any (x86_64) | BETWEEN query with index wrong result |
111068 | 2023-05-18 8:38 | 2023-05-18 9:46 | MySQL Server: Locking | Verified (535 days) | S2 | 8.0.25, 8.0.33 | Any | Any | Lock failure |
111530 | 2023-06-22 8:42 | 2023-06-23 4:01 | Connector / J | Not a Bug (500 days) | S3 | 8.0.29 | Any | Any | useGeneratedKeys bug When using on duplicate key update clause |
111656 | 2023-07-04 12:32 | 2023-07-05 12:22 | MySQL Server | Unsupported (488 days) | S2 | 8.0.25 | Any | Any | Lock failure |
111675 | 2023-07-06 8:36 | 2023-07-07 12:17 | MySQL Server: Data Types | Verified (486 days) | S3 | 8.0 | Any | Any | wrong result when compare timestamp with undependent subselect that return time |
112251 | 2023-09-04 13:19 | 2023-09-05 12:11 | MySQL Server: Optimizer | Can't repeat (425 days) | S3 | 8.1.0 | Any | Any | Uncertain Result |
112463 | 2023-09-26 9:01 | 2023-10-04 11:24 | MySQL Server | Not a Bug (396 days) | S3 | 8.0.34 | Any | Any | MySQL Delete, Insert Lock Occur |
113211 | 2023-11-24 12:14 | 2023-11-24 12:34 | MySQL Server: Optimizer | Verified (345 days) | S2 | 8.0.35, 8.1.0, 8.2.0 | Any | Any | The latest version 8.0 returns abnormal results for complex queries |
113313 | 2023-12-03 0:44 | 2023-12-04 12:48 | MySQL Server | Not a Bug (335 days) | S1 | 8.2.0 | Any | Any | Unexpected Result for ENGINE HEAP |
113783 | 2024-01-28 12:50 | 2024-01-30 10:58 | MySQL Server: Optimizer | Not a Bug (278 days) | S4 | 8.0 | Any | Any | only_full_group_by option does not take effect |
114016 | 2024-02-16 13:00 | 2024-03-20 1:00 | Connector / J | No Feedback (229 days) | S2 | Any | Any | CompoundCacheKey does not include generatedKey | |
114542 | 2024-04-03 8:36 | 2024-04-03 13:18 | MySQL Server: Prepared statements | Not a Bug (214 days) | S3 | 8.0.36-commercial | Any (8) | Any | Encoding issue when reusing Prepared Statement |
115274 | 2024-06-11 3:19 | 2024-06-11 9:21 | MySQL Server | Not a Bug (145 days) | S3 | 8.0.36 | Any (22.04) | Any | Abnormal behavior of strings in expressions |
115546 | 2024-07-09 8:45 | 2024-07-09 11:55 | MySQL Server: Partitions | Duplicate (117 days) | S3 | 8.0.38, 9.0.0 | Any | Any | InnoDB partition table auto-increment behavior is inconsistent |
115763 | 2024-08-05 7:02 | 2024-08-05 12:00 | MySQL Server | Duplicate (90 days) | S3 | 8.0.31 | Any | Any | Incorrect order of create trigger / user statements in forward engineer SQL |
116459 | 2024-10-23 12:01 | 2024-10-23 13:26 | MySQL Server | Not a Bug (11 days) | S3 | 8.0.28 | Any | Any | Deadlocks in transaction using Insert Ignore Statements post Upgrade to Mysql 8 |
31 | 2003-01-15 0:03 | 2003-01-28 10:41 | MySQL Server | Closed (7950 days) | S3 | 4.1 | Any (any) | Any | Bug with nested subselect IN (... IN ()) |
104 | 2003-02-26 13:33 | 2003-03-06 14:03 | MySQL Server | Closed (7913 days) | S3 | 4.0 | Any (all) | Any | INSERT DELAYED does not care about SQL_LOG_BIN=0 |
490 | 2003-05-24 7:09 | 2003-07-01 6:14 | MySQL Server: Replication | Closed (7796 days) | S2 | 4.0.13 | Any (all) | Any | Accidental introduction of a bug with auto_increment and INSERT SELECT |
791 | 2003-07-04 9:39 | 2011-03-15 10:21 | MySQL Server | Closed (7783 days) | S1 | 4.0 | Any (all) | Any | At binlog rotation, INSERTs may not find their way into the binlog |
1113 | 2003-08-21 8:41 | 2003-08-22 7:02 | MySQL Server | Closed (7744 days) | S3 | 4.0 | Any (all) | Any | If in a trans, a non-trans table is updated by INSERTSELECT, ROLLBACK, no error |
2955 | 2004-02-25 4:27 | 2011-02-16 23:42 | MySQL Server: DML | Closed (5751 days) | S4 | 4.x | Any (All) | Any | LAST INSERTED ID FOR UNIQUE KEY |
3771 | 2004-05-15 13:05 | 2004-05-21 12:59 | MySQL Server: Embedded Library ( libmysqld ) | Closed (7471 days) | S2 | 4.1.2 | Any (All) | Any | wrong returned number of affected rows INSERT command in embedded server |
5312 | 2004-08-31 9:08 | 2014-03-13 13:33 | MySQL Cluster: Cluster (NDB) storage engine | Won't fix (7291 days) | S3 | Any | Any | Ndb Cluster returns wrong error code for duplicate key at insert | |
6164 | 2004-10-19 20:10 | 2011-02-16 23:43 | MySQL Server: Optimizer | Verified (7319 days) | S4 | 4.0.22 4.1.7 | Any | Any | INSERT ... SELECT ... LIMIT creating too-large temporary tables |
6172 | 2004-10-20 8:50 | 2007-02-12 18:43 | MySQL Server | Closed (6474 days) | S3 | All | Any (All) | Any | RAND(a) should only accept constant values as arguments. |
6196 | 2004-10-21 12:44 | 2014-07-23 1:52 | MySQL Server: MyISAM storage engine | Closed (3756 days) | S4 | 5.1 | Any | Any | INSERT IGNORE should return warnings |
6678 | 2004-11-17 10:09 | 2005-06-01 3:45 | MySQL Server | Closed (7095 days) | S1 | 4.0 | Any (all) | Any | CREATE TABLE ... SELECT ... has too weak locking on dest table |
6883 | 2004-11-29 20:57 | 2005-06-21 16:50 | MySQL Server | Closed (7075 days) | S2 | 4.0 | Any (all) | Any | ROLLBACK wipes out some DDLs from the binlog (breaks binlog and replication) |
7351 | 2004-12-16 13:15 | 2012-05-18 20:19 | MySQL Server | Duplicate (6132 days) | S2 | 5.1 | Any | Any | incomplete result, outer query with NULL <> ALL (empty subquery) |
7578 | 2004-12-29 18:48 | 2004-12-29 22:47 | MySQL Server: InnoDB storage engine | Closed (7249 days) | S1 | 5.0.3-bk | Any (all) | Any | Insert buffering of prefix indexes works incorrectly with new InnoDB format |
7714 | 2005-01-06 20:13 | 2005-01-06 20:39 | MySQL Server: MyISAM storage engine | Closed (7241 days) | S3 | 4.0.23 | Any (all) | Any | if disk full, sometimes MyISAM doesn't wait for free space, corrupts table |
7727 | 2005-01-07 7:47 | 2011-02-16 23:43 | MySQL Server: MyISAM storage engine | Verified (6245 days) | S4 | Any | Any | BASE_TABLE function for use w/ MERGE tables | |
7879 | 2005-01-13 16:34 | 2005-02-21 11:09 | MySQL Server | Closed (7195 days) | S3 | 4.0 and up | Any (all) | Any | Changing read locks properly for replication purposes |
7947 | 2005-01-16 20:40 | 2005-12-21 13:53 | MySQL Server: Replication | Closed (6892 days) | S3 | 4.0 | Any (all) | Any | Wrong binlogging of CREATE [LIKE] | DROP TABLE if TEMPORARY and transaction |
8299 | 2005-02-03 22:04 | 2006-05-27 12:04 | MySQL Server | Duplicate (6735 days) | S4 | 5.0 | Any (all) | Any | Allow FOR SELECT syntax extension |
8675 | 2005-02-22 10:59 | 2005-02-22 20:02 | MySQL Server | Duplicate (7194 days) | S3 | 4.1.10 | Any (*) | Any | INSERT INTO tbl (col,...) SELECT (...) ON DUPLICATE KEY doesn't work properly |
8893 | 2005-03-02 14:51 | 2005-03-09 3:41 | MySQL Server: Optimizer | Closed (7179 days) | S2 | 4.1.10 | Any (all) | Any | Using "SELECT MAX(ID)" with Multiple-Column Indexes |
9018 | 2005-03-07 12:34 | 2019-12-16 4:52 | MySQL Server: DML | Verified (6239 days) | S4 | Any | Any | Implement SQL 2003 MERGE command | |
9168 | 2005-03-14 12:53 | 2014-02-10 8:10 | MySQL Server: Errors | Can't repeat (3919 days) | S2 | 5.0 | Any | Any | Traditional: DECIMAL/NUMERIC/BIGINT column: col / 0 returns 0 or NULL |
9357 | 2005-03-23 12:57 | 2005-04-26 0:10 | MySQL Server | Closed (7131 days) | S3 | 4.1.10 | Any (all) | Any | TEXT columns break string with special word in BIG5 charset. |
9512 | 2005-03-31 2:29 | 2005-04-04 5:30 | MySQL Server: InnoDB storage engine | Not a Bug (7153 days) | S3 | 4.1.10a | Any (All) | Any | SELECT FOR UPDATE returns phantom rows |
9576 | 2005-04-02 4:40 | 2005-04-05 13:08 | MySQL Server | Duplicate (7152 days) | S3 | 4.1.10 | Any (*) | Any | AES_DECRYPT results inconsistent |
9689 | 2005-04-06 17:37 | 2005-04-22 21:10 | MySQL Server: Optimizer | Not a Bug (7135 days) | S3 | 4.1.11 | Any (*) | Any | wrong result for subselect in on duplicate key update (query cache) |
9725 | 2005-04-07 16:36 | 2005-07-12 5:06 | MySQL Server | Closed (7054 days) | S3 | 4.1.11 | Any (*) | Any | "disapearing query/hang" and "unknown error" with "on duplicate key update" |
10049 | 2005-04-20 23:02 | 2014-12-17 13:46 | MySQL Server: General | Verified (6967 days) | S4 | Any | Any | rownum functionality (alá Oracle) | |
11987 | 2005-07-17 3:56 | 2005-08-03 20:46 | MySQL Server | Closed (7032 days) | S3 | 4.1 .. 5.0 | Any (*) | Any | mysql will truncate the text when the text contain GBK char:"0xA3A0" and "0xA1" |
12009 | 2005-07-18 14:33 | 2005-07-20 21:07 | MySQL Server | Not a Bug (7046 days) | S3 | 4.1 | Any (*) | Any | Insert into Merge table does not enforce base table defaults |
13570 | 2005-09-28 14:16 | 2005-10-07 9:53 | MySQL Server | Won't fix (6967 days) | S4 | all | Any (all) | Any | frederate table |
13728 | 2005-10-04 0:38 | 2011-02-16 23:43 | MySQL Server | No Feedback (5484 days) | S4 | Any | Any | add XML parsing like MSSQLServer does | |
14053 | 2005-10-15 23:44 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (5478 days) | S4 | 5.0.13-rc-standard-log | Any (any) | Any | Impossible to access auto_increment values in triggers on insert |
15430 | 2005-12-02 11:19 | 2006-05-22 1:18 | MySQL Server: Embedded Library ( libmysqld ) | Closed (6740 days) | S3 | 4.1.16 | Any (all) | Any | Test using parallel connections fails on "embedded" |
16546 | 2006-01-16 18:55 | 2007-04-23 19:46 | MySQL Server | Closed (6404 days) | S3 | 4.1.x, 5.0.x | Any | Any | DATETIME+0 not always coerced the same way |
16593 | 2006-01-18 3:14 | 2006-02-23 3:24 | MySQL Server | Closed (6828 days) | S1 | 5.0.17a-cert,5.0.18 | Any (ALL) | Any | Deadlock or crash in stress test for case where triggers starting trigger |
16730 | 2006-01-23 16:25 | 2006-01-24 17:05 | MySQL Server: InnoDB storage engine | Closed (6858 days) | S3 | 4.1.17 | Any (All) | Any | Test "ctype_ucs" fails without "Innodb" ("classic" build) |
16979 | 2006-01-31 15:43 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5250 days) | S5 | 5.0.18 | Any (All) | Any | AUTO_INC lock in InnoDB works a table level lock |
17092 | 2006-02-03 7:34 | 2022-12-04 20:45 | MySQL Server: DDL | Verified (5070 days) | S4 | Any | Any | allowing TRUNCATE TABLE while LOCKing done. | |
18394 | 2006-03-21 14:50 | 2006-03-21 16:59 | Connector / J | Not a Bug (6802 days) | S2 | 3.1.12 | Any (All) | Any | Don't get any exception with "2005/02/30" with connector/J |
18906 | 2006-04-08 13:09 | 2006-04-10 20:05 | MySQL Server: Replication | Closed (6782 days) | S3 | 5.0.21 | Any (all) | Any | Test case rpl_temporary fails when using --vardir option |
18914 | 2006-04-09 4:33 | 2007-03-09 3:14 | MySQL Server: Stored Routines | Closed (6449 days) | S3 | 5.0.21-BK, 5.0+ | Any (ALL) | Any | Calling certain SPs from triggers fail |
19447 | 2006-04-30 16:53 | 2006-04-30 16:53 | MySQL Server | Open | S4 | 5 | Any (all) | Any | Have default values for fields when using INSERT on a view |
19652 | 2006-05-09 20:55 | 2006-05-10 13:32 | MySQL Server | Not a Bug (6752 days) | S2 | 3.x,4.x | Any (All) | Any | Wrong description on how to create new user accounts |
20151 | 2006-05-30 16:43 | 2012-05-18 20:19 | MySQL Server: Row Based Replication ( RBR ) | No Feedback (5991 days) | S2 | 5.1.12pre | Any (All) | Any | Slave instance crashed during exection of SP |
20203 | 2006-06-01 13:45 | 2006-07-06 1:45 | MySQL Server: Views | Not a Bug (6695 days) | S3 | 5.0.22, 4.1.21-BK | Any (All) | Any | SEC_TO_TIME(SUM(TIME_TO_SEC( doesn't work correctly with a VIEW |
20236 | 2006-06-02 20:34 | 2006-06-02 20:40 | MySQL Server | Not a Bug (6729 days) | S3 | 4.1.20, 5.0.22 | Any (All) | Any | incorrect INSERT syntax is allowed and produces confusing results |
20340 | 2006-06-08 12:58 | 2006-07-26 0:44 | MySQL Server: Partitions | Closed (6675 days) | S3 | 5.1.12-BK, 5.1.11 | Any (all) | Any | Paritioning does not obey to column type |
20887 | 2006-07-06 11:44 | 2015-03-15 20:45 | MySQL Server: Replication | No Feedback (6587 days) | S3 | 4.1 and up | Any (ALL) | Any | INSERT DELAYED is not logged write-behind to binary log |
20901 | 2006-07-07 12:26 | 2007-12-21 17:04 | MySQL Server: General | Closed (6162 days) | S2 | 4.1.21-BK, 5.0.23-BK, 5.1.12-BK | Any (any) | Any | CREATE privilege is enough to insert into a table |
21113 | 2006-07-18 12:48 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5250 days) | S3 | 5.0.19 | Any (All) | Any | Duplicate printout in SHOW INNODB STATUS |
21205 | 2006-07-21 8:12 | 2011-02-16 23:43 | MySQL Server: Prepared statements | Closed (5655 days) | S3 | 5.0 | Any | Any | Different number of digits for float/doble/real in --ps-protocol |
21293 | 2006-07-26 10:19 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5250 days) | S4 | 4.1,5.0-bk,5.1-bk | Any | Any | Deadlock detection prefers to kill long running FOR UPDATE queries |
21774 | 2006-08-22 8:46 | 2006-09-13 17:31 | MySQL Server | Closed (6626 days) | S2 | 5.0.24 | Any (*) | Any | Column count doesn't match value count at row x |
22168 | 2006-09-09 10:11 | 2007-12-03 14:27 | MySQL Server: Falcon storage engine | Closed (6180 days) | S3 | 5.2 | Any (all) | Any | Inserting bad early dates |
22175 | 2006-09-09 10:27 | 2010-05-26 17:59 | MySQL Server: Falcon storage engine | Unsupported (5275 days) | S3 | 6.0 | Any (all) | Any | Mixing with InnoDB table leads to an anomaly |
22561 | 2006-09-21 17:44 | 2006-09-27 18:28 | MySQL Query Browser | Duplicate (6612 days) | S4 | 1.2.1 beta | Any (All) | Any | MySQL Query Browser Should Have An Export To Sql Option |
24178 | 2006-11-10 10:40 | 2022-12-01 10:35 | MySQL Server: Prepared statements | Won't fix (703 days) | S3 | Any | Any | ctype_ucs.test fails wit --cursor-protocol | |
25330 | 2006-12-29 12:17 | 2007-01-02 9:48 | MySQL Cluster: Cluster (NDB) storage engine | Won't fix (6515 days) | S3 | 5.1, 5.0?, 4.1? | Any | Any | ndb: table create and insert during node restart causes restart node crash |
25507 | 2007-01-09 22:46 | 2011-02-16 23:43 | MySQL Server: Replication | Closed (5249 days) | S2 | 4.1-bk,5.0.34 | Any (*) | Any | multi-row insert delayed + auto increment causes duplicate key entries on slave |
25815 | 2007-01-24 10:24 | 2007-03-15 4:29 | MySQL Server | Closed (6443 days) | S3 | 5.0.32 | Any (any) | Any | Data truncated for column TEXT |
26379 | 2007-02-14 19:59 | 2007-12-03 9:33 | MySQL Server: Merge storage engine | Closed (6180 days) | S1 | 4.0 4.1 5.0 5.1 | Any | Any | Combination of FLUSH TABLE and REPAIR TABLE corrupts a MERGE table |
26464 | 2007-02-17 18:25 | 2007-03-15 2:54 | MySQL Server: Merge storage engine | Closed (6443 days) | S2 | 4.1.21, 5.0.36BK, 5.1.16BK, 5.2.4BK | Any (*) | Any | insert delayed + update + merge = corruption |
26590 | 2007-02-23 11:30 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5255 days) | S2 | 5.0, 5.1, etc. | Any | Any | MySQL does not allow more than 1023 open transactions |
27159 | 2007-03-15 1:02 | 2011-02-16 23:43 | MySQL Server: Security: Privileges | Verified (6403 days) | S4 | any | Any (any) | Any | restrict permissions for table maintenance statements |
27205 | 2007-03-16 10:47 | 2007-04-30 8:45 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6397 days) | S3 | 5.1 | Any | Any | Occasional 899 if delete+insert during LCP |
27350 | 2007-03-21 17:57 | 2012-05-18 20:19 | MySQL Server: Falcon storage engine | No Feedback (6383 days) | S2 | 5.2 | Any | Any | test-insert, Unexpected error; "Record has changed since last read in table" |
27387 | 2007-03-23 4:08 | 2007-03-30 17:06 | MySQL Server: General | Not a Bug (6428 days) | S2 | All 5.0 and 5.1, 4.1, 5.2 | Any (All) | Any | Error checking is incorrect in INSERT ... ON DUPLICATE KEY UPDATE |
27480 | 2007-03-27 18:22 | 2011-05-12 17:21 | MySQL Server: Security: Privileges | Closed (4924 days) | S3 | 5.0,5.1 | Any (All) | Any | Extend CREATE TEMPORARY TABLES privilege to allow temp table operations |
27502 | 2007-03-28 15:44 | 2012-09-13 8:20 | Connector / NET | Can't repeat (6414 days) | S2 | 5.0.23 | Any (unix) | Any | UTF characters inserts into tables as "???" (c# + connector/net) |
27809 | 2007-04-13 13:03 | 2008-02-22 18:42 | MySQL Server: Merge storage engine | Closed (6099 days) | S3 | 5.0.40BK | Any | Any | documentation says REPLACE not working with MERGE, but it does |
27838 | 2007-04-15 23:01 | 2007-04-16 4:33 | MySQL Server: Data Types | Duplicate (6411 days) | S2 | 5.0.24a | Any | Any | DateTime and Timestamp do not work with Milliseconds |
27906 | 2007-04-17 23:27 | 2017-10-20 15:16 | MySQL Server: Data Types | Verified (6410 days) | S4 | 5.0 | Any | Any | MySQL doesn't accept ISO8601 date |
28000 | 2007-04-21 14:59 | 2007-05-17 14:24 | MySQL Server | Closed (6380 days) | S3 | 5.0.37,5.1, 6.0-falcon-bk | Any | Any | MySQL hangs when using INSERT IGNORE ... ON DUPLICATE KEY |
28052 | 2007-04-23 22:51 | 2007-04-23 22:51 | MySQL Server: Falcon storage engine | Closed | S3 | 6.0.0-alpha | Any | Any | Falcon Crash with insert while unique key for date and tinyint |
28053 | 2007-04-23 22:59 | 2007-04-23 22:59 | MySQL Server: Falcon storage engine | Closed | S3 | 6.0.0-alpha | Any | Any | Falcon crash on multi table update |
28150 | 2007-04-28 21:14 | 2007-04-30 16:42 | MySQL Server | Closed (6397 days) | S3 | 5.1.15-beta | Any | Any | INSERT SELECT accepts invalid SELECT statement |
28280 | 2007-05-07 13:47 | 2007-05-29 13:29 | MySQL Server: Stored Routines | Duplicate (6368 days) | S1 | 5.0.42BK, 5.1.18BK | Any | Any | insert delayed on a table containing trigger leads to server crash |
28526 | 2007-05-18 17:15 | 2012-05-18 20:19 | MySQL Server | Duplicate (6366 days) | S2 | 5.0.40, 5.0.41, 5.0.42-20070517 | Any | Any | Correlated subquery with GROUP BY on outer query returns no results in 5.0.40+ |
28719 | 2007-05-28 9:18 | 2007-06-11 20:20 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6355 days) | S3 | 5.1 | Any | Any | multi pk update ignore corrupts data |
28770 | 2007-05-30 10:02 | 2007-06-11 20:15 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6355 days) | S3 | 5.0 | Any | Any | file already opened error when corrupt schema file |
28842 | 2007-06-01 17:33 | 2007-06-18 15:08 | MySQL Server: Errors | Closed (6348 days) | S2 | 5.1-bk | Any | Any | Different 'duplicate key' error code between 5.0 and 5.1 |
28843 | 2007-06-01 18:07 | 2016-02-25 12:24 | MySQL Server: Documentation | Not a Bug (6337 days) | S3 | 5.0.41 | Any | Any | Incorrect listing of supported operations in Prepared Statements |
28878 | 2007-06-04 15:35 | 2007-10-22 22:03 | MySQL Server | Closed (6222 days) | S1 | 5.0.42, 4.1.23 | Any | Any | InnoDB tables with UTF8 character set and indexes cause wrong result for DML |
28895 | 2007-06-05 12:52 | 2018-09-25 21:45 | MySQL Server: Tests | Closed (6348 days) | S7 | 5.0, 5.1 | Any | Any | Test 'information_schema_db' fails on i5/OS 32 bit |
29019 | 2007-06-11 14:53 | 2007-07-07 19:01 | MySQL Server: Federated storage engine | Closed (6329 days) | S3 | 5.0/5.1 | Any | Any | REPLACE/INSERT IGNORE/UPDATE IGNORE doesn't work |
29020 | 2007-06-11 16:13 | 2008-03-31 19:09 | MySQL Server: Row Based Replication ( RBR ) | Closed (6061 days) | S2 | 5.1.20 | Any | Any | Event results not correctly replicated to slave in RBR |
29042 | 2007-06-12 4:53 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5666 days) | S4 | any | Any | Any | Need documentation page on how InnoDB handles blobs |
29128 | 2007-06-15 5:28 | 2012-05-18 20:19 | MySQL Server: Charsets | Duplicate (5728 days) | S3 | 5.0, 5.1, 4.1 | Any | Any | LC_TIME_NAMES=fr_FR, assignment to non-UTF8 target fails with MONTHNAME() |
29178 | 2007-06-18 14:30 | 2011-02-16 23:43 | MySQL Server: Documentation | Won't fix (5197 days) | S3 | 5.0.44 | Any | Any | new memory chunks for heap tables depend on read_buffer_size |
29207 | 2007-06-19 12:16 | 2010-05-01 9:33 | MySQL Server: Archive storage engine | Closed (6329 days) | S1 | 5.0.44BK | Any | Any | archive table reported as corrupt by check table |
29413 | 2007-06-28 8:38 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5562 days) | S4 | 5.0.41 | Any | Any | Maximum performance of OLTP benchmark is not so scalable on multi-cpu |
29422 | 2007-06-28 14:49 | 2013-10-10 16:48 | MySQL Server: Command-line Clients | Closed (4042 days) | S3 | 5.1.20 | Any | Any | mysqlbinlog incorectly quotes user variable named <backtick> |
29431 | 2007-06-28 22:01 | 2007-07-27 5:09 | MySQL Server: Locking | Closed (6309 days) | S3 | 4.1,5.0.46,5.1 | Any | Any | killing an insert delayed thread causes crash |
29475 | 2007-07-02 4:28 | 2007-08-17 14:06 | MySQL Server: InnoDB storage engine | Won't fix (6288 days) | S5 | 5.0 | Any | Any | InnoDB COMPACT format addition reduces INSERT performance by 10 % |
29601 | 2007-07-06 17:33 | 2007-08-06 22:45 | MySQL Server: Falcon storage engine | Can't repeat (6299 days) | S1 | 6.0-bk | Any | Any | Falcon crashes during DBT2 initial load of tables |
29638 | 2007-07-09 6:41 | 2007-07-31 6:55 | MySQL Server | Not a Bug (6305 days) | S3 | 5.0, 5.1 | Any | Any | syntax error when inserting large hex strings with sufficient max_allowed_packet |
29717 | 2007-07-11 9:58 | 2007-08-03 16:59 | MySQL Server | Closed (6302 days) | S2 | 4.1, 5.0, 5.1 BK | Any (Linux) | Any | INSERT INTO SELECT inserts values even if SELECT statement itself returns empty |
29788 | 2007-07-13 14:35 | 2007-07-27 5:25 | MySQL Server: Backup | Closed (6309 days) | S2 | 5.0.45, 5.0 BK, 6.0.1-Falcon | Any | Any | MySQL 5.0.45 restore of dump fails |
29928 | 2007-07-20 11:01 | 2007-08-03 2:27 | MySQL Server: Backup | Closed (6302 days) | S3 | 4.1 bk, 5.0 bk, 5.1 bk | Any | Any | INSERT ... VALUES(connection_id(), ...) incorrect restores from mysqlbinlog out |
29929 | 2007-07-20 11:20 | 2007-08-02 3:50 | MySQL Server: Locking | Closed (6303 days) | S1 | 5.0, 5.1, 5.2 | Any | Any | LOCK TABLES does not pre-lock tables used in triggers of the locked tables |
30146 | 2007-07-31 12:59 | 2007-07-31 13:10 | MySQL Server: General | Closed (6305 days) | S3 | 5.0.42-enterprise-gpl | Any | Any | on duplicate key update does insert and update at the same time |
30200 | 2007-08-02 8:33 | 2007-08-03 2:18 | MySQL Server: Replication | Closed (6302 days) | S2 | Any | Any | mysqlbinlog.test: connection_id() not restored under ps-protocol | |
30209 | 2007-08-02 18:13 | 2007-11-28 16:29 | MySQL Server: Replication | Closed (6185 days) | S2 | 5.0, 5.1 | Any | Any | rpl_packet.test: Slave_running mismatch (timing bug?) |
30244 | 2007-08-05 17:52 | 2007-09-14 15:10 | MySQL Server | Closed (6260 days) | S3 | 5.0.48 5.1.21, 4.1 | Any | Any | row_count/found_rows does not replicate well |
30256 | 2007-08-06 14:27 | 2007-08-06 15:15 | MySQL Server | Can't repeat (6299 days) | S2 | 5.0.45 | Any | Any | Query cache not emptied after a INSERT ... ON DUPLICATE KEY UPDATE |
30267 | 2007-08-07 5:11 | 2007-10-29 12:09 | MySQL GUI Common | Closed (6215 days) | S3 | 1.1.10 Alpha | Any | Any | Columns not insert |
30284 | 2007-08-07 19:53 | 2008-01-15 16:30 | MySQL Server: MyISAM storage engine | Closed (6137 days) | S2 | 5.0.45,5.1.22BK | Any | Any | spatial key corruption |
30286 | 2007-08-07 21:32 | 2007-11-05 2:52 | MySQL Server: MyISAM storage engine | Closed (6208 days) | S1 | 5.0.45, 5.0.48BK, 5.1.21 | Any | Any | spatial index cause corruption and server crash! |
30400 | 2007-08-14 8:03 | 2007-09-30 11:08 | MySQL Server: Stored Routines | No Feedback (6244 days) | S3 | Any | Any | cursor can not support recursion. | |
30604 | 2007-08-23 18:02 | 2008-04-15 23:09 | MySQL Server: General | Closed (6046 days) | S3 | 5.0 BK | Any | Any | different flagging of time_zone_used in normal and ps-protocol |
30648 | 2007-08-27 17:47 | 2007-08-31 13:48 | MySQL Server: Partitions | Closed (6274 days) | S3 | 5.1 | Any | Any | Partition handler may not initialize variable used w/ autoincrement |
30661 | 2007-08-28 2:05 | 2007-08-28 16:06 | MySQL Enterprise Monitor: Server | Not a Bug (6277 days) | S2 | 1.2.0.7296 | Any | Any | Purging data can cause deadlocks |
30871 | 2007-09-06 16:40 | 2011-02-16 23:43 | MySQL Server | Duplicate (5185 days) | S4 | 5.0 | Any | Any | Feature request: login triggers |
30936 | 2007-09-10 15:19 | 2007-09-10 15:33 | MySQL Server: Errors | Not a Bug (6264 days) | S3 | MySQL 5.0 | Any | Any | Syntax error |
30987 | 2007-09-12 17:46 | 2007-10-31 19:31 | MySQL Server: Data Types | Can't repeat (6213 days) | S3 | 5.0.44 | Any | Any | mysql Error: Warning | 1366 | Incorrect string value: '\xB4 FFFF...' for column |
30996 | 2007-09-13 10:54 | 2007-11-05 22:22 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6208 days) | S3 | 5.1.22 | Any | Any | NDB commits too early when LOCK TABLE & SET AUTOCOMMIT=OFF are used together |
31135 | 2007-09-21 15:59 | 2008-09-12 8:09 | MySQL Server | No Feedback (5896 days) | S1 | 5.0, 5.1 | Any | Any | alter table x alter column y set default m does not pass default value to engine |
31257 | 2007-09-27 19:49 | 2007-11-06 8:47 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6207 days) | S3 | 4.1,5.0,5.1 | Any | Any | Node failure during LCP can lead to subsequent SR failure |
31314 | 2007-10-01 12:47 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | No Feedback (5376 days) | S3 | mysql-5.1 | Any | Any | Strange impact of ndb_cache_check_time on cluster auto_increment performance |
31352 | 2007-10-02 18:55 | 2007-10-20 16:17 | MySQL Server: Locking | Closed (6224 days) | S3 | 5.0.45 | Any (Linux, Windows) | Any | Write locking in stored functions with INSERT and SELECT statemenst |
31408 | 2007-10-04 20:31 | 2007-11-01 12:51 | MySQL Server: Tests | Closed (6212 days) | S3 | 5.1 | Any | Any | funcs_1: <engine>_trig_03e test fail |
31540 | 2007-10-11 16:01 | 2008-01-09 14:12 | MySQL Server: InnoDB storage engine | Closed (6143 days) | S1 | 5.1.22 | Any | Any | incorrect auto_increment values used for multi-row insert trigger |
31668 | 2007-10-17 15:48 | 2014-03-13 13:36 | MySQL Cluster: Disk Data | Won't fix (6038 days) | S3 | 5.1 | Any | Any | Dropping data file with empty table returns different result. |
31776 | 2007-10-23 8:19 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6220 days) | S3 | 5.0.45, 4.1, 5.0, 5.1, 5.2 BK | Any (Linux, Microsoft Windows XP SP2) | Any | CAST AS CHAR with SELECT DISTINCT |
31848 | 2007-10-25 13:20 | 2007-11-05 23:08 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6208 days) | S3 | 5.0.44 (NDB) + x | Any (gcc 4.2.1, x86 (32)) | Any | Test failure: Cluster has problems on insert with auto-increment |
31976 | 2007-10-31 8:36 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Verified (6207 days) | S3 | mysql-5.1 | Any | Any | Can't drop a ndb table after all ndbds restarted |
32239 | 2007-11-09 16:23 | 2008-02-24 21:07 | MySQL Cluster: Replication | Closed (6097 days) | S3 | 5.1.22-ndb-6.3.2-telco-log | Any | Any | failed ndbrequire on slave server after intensive db activity |
32245 | 2007-11-09 19:25 | 2015-01-09 14:32 | Tests: Cluster | Won't fix (3586 days) | S3 | 6.0.4-alpha,5.4 | Any | Any | Change in NDB is not reflected in the test results: on-line ADD COLUMN |
32605 | 2007-11-21 22:56 | 2016-02-25 12:24 | MySQL Server: Documentation | Closed (6142 days) | S2 | 5.1.22 | Any | Any | Binary log and replication filtering options differ between RBR and SBR |
32606 | 2007-11-21 23:27 | 2007-11-29 12:58 | MySQL Server: Replication | Can't repeat (6184 days) | S2 | 5.0.45 | Any | Any | auto_increment on slave doesn`t work expected after null insert |
32676 | 2007-11-23 18:20 | 2008-01-11 16:09 | MySQL Server: Locking | Closed (6141 days) | S1 | 5.0.50, 5.1.23, 6.0.3 | Any | Any | insert delayed crash with wrong column and function specified .. |
32705 | 2007-11-26 5:57 | 2008-04-15 2:13 | MySQL Server: MyISAM storage engine | Closed (6046 days) | S1 | 5.1.23, 5.0.50, 6.0.3 | Any | Any | myisam corruption: Key in wrong position at page 1024 with ucs2_bin |
32790 | 2007-11-27 20:17 | 2008-04-15 1:24 | MySQL Server: Stored Routines | Closed (6046 days) | S1 | 5.0, 5.1, 6.0 | Any | Any | crash in trigger.test with InnoDB for a table |
32839 | 2007-11-29 8:07 | 2007-12-04 14:47 | MySQL Server | Can't repeat (6179 days) | S3 | 5.1 BK | Any (Linux) | Any | Inconsistent behavior of LOW_PRIORITY in 5.0 and 5.1 |
32951 | 2007-12-04 8:04 | 2008-05-13 8:45 | MySQL Cluster: Cluster (NDB) storage engine | Can't repeat (6018 days) | S3 | 6.0 | Any | Any | stack badness in ndb |
33037 | 2007-12-06 12:49 | 2007-12-07 8:43 | MySQL Server: Optimizer | Can't repeat (6176 days) | S5 | 5.0.22-pro-nt-log | Any | Any | Different and much slower access plan used for select when used with insert into |
33095 | 2007-12-09 11:50 | 2013-12-19 18:47 | MySQL Workbench | Closed (3972 days) | S3 | 5.0.10 OSS Beta 2272 | Any | Any | Table/Inserts can not handle many INSERT statements |
33299 | 2007-12-17 20:27 | 2014-03-14 4:54 | Connector / ODBC | Verified (3887 days) | S1 | 5.1.1 | Any | Any | Trying to insert east-asian (or non latin) data into a recordset fails |
33360 | 2007-12-19 8:25 | 2011-02-16 23:43 | MySQL Cluster: Replication | Closed (5511 days) | S2 | mysql-6.0 | Any | Any | rpl_ndb_idempotent fails due to null field for table on slave side |
33371 | 2007-12-19 16:39 | 2020-06-12 8:11 | MySQL Server | Not a Bug (6156 days) | S3 | 5.0.45 | Any | Any | default required for column in strict mode when value is specified |
33479 | 2007-12-22 12:51 | 2008-05-24 17:05 | MySQL Server: Partitions | Closed (6007 days) | S3 | 5.1+ | Any | Any | Insert on a partitioned auto_increment table gives ER_AUTOINC_READ_FAILED |
33480 | 2007-12-22 13:44 | 2008-05-02 23:06 | MySQL Server: Falcon storage engine | Closed (6029 days) | S3 | 6.0.4 | Any | Any | (Falcon) deadlock on inserts into a partitioned auto_increment table |
33495 | 2007-12-24 3:17 | 2007-12-24 4:29 | MySQL Server: DML | Duplicate (6159 days) | S3 | Any | Any | Error Insert data in version 5.1.20 | |
33648 | 2008-01-03 12:18 | 2010-05-26 17:59 | MySQL Server: Falcon storage engine | Unsupported (5275 days) | S3 | 6.0.4-p2 | Any | Any | Falcon selects on blobs above certain size are starved with default settings |
33661 | 2008-01-03 17:00 | 2008-03-16 11:21 | MySQL Server: Falcon storage engine | Closed (6076 days) | S3 | 6.0.4-p2 | Any | Any | Falcon insert into partition fails if starting auto_increment is set |
33736 | 2008-01-08 9:53 | 2008-01-14 6:51 | MySQL Server: General | Closed (6138 days) | S2 | 5.1.22(5.1.19, 6.0.3) | Any | Any | mysql crash on error sql with INSERT DELAYED and ON DUPLICATE KEY UPDATE |
33774 | 2008-01-09 16:06 | 2008-01-10 13:18 | MySQL Server: Stored Routines | Not a Bug (6142 days) | S1 | Any | Any | oracle details i am using | |
33857 | 2008-01-14 4:15 | 2008-01-15 13:18 | MySQL Server | Can't repeat (6137 days) | S2 | 5.0.45 | Any (windows and linux) | Any | mysql hangs on certain querys in strict mode |
33971 | 2008-01-22 2:06 | 2011-06-25 0:45 | MySQL Server: Tests | Closed (4880 days) | S3 | 5.1, 6.0 | Any | Any | Test of using (default) for INSERT with an enum column not enabled. |
34033 | 2008-01-24 13:10 | 2008-02-20 21:56 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6101 days) | S4 | 5.1* | Any | Any | Error 899 can occur during high insert/delete-load |
34086 | 2008-01-27 3:59 | 2008-03-16 11:21 | MySQL Server: Falcon storage engine | Closed (6076 days) | S3 | 6.0.3-alpha/6,0.5BK | Any | Any | Falcon crashes from large insert select statement |
34260 | 2008-02-03 12:59 | 2008-02-20 21:50 | MySQL Cluster: Cluster (NDB) storage engine | Closed (6101 days) | S3 | 5.1 | Any | Any | Rare race condition between aborted insert + scan delete can cause node crash |
34267 | 2008-02-04 3:26 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (6114 days) | S2 | 5.1.23 | Any | Any | Server crash when droping a partition on a table with a trigger |
34289 | 2008-02-04 16:58 | 2008-03-29 17:10 | MySQL Server: Replication | Closed (6063 days) | S2 | 5.0.45, 5.0, 5.1, 6.0 BK | Any (Linux) | Any | Incorrect NAME_CONST substitution in stored procedures breaks replication |
34311 | 2008-02-05 14:57 | 2008-02-11 16:46 | MySQL Server | Closed (6110 days) | S1 | 5.1, 6.0 | Any | Any | main.lock_multi.test fails |
34319 | 2008-02-05 18:21 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5872 days) | S4 | 5.1.22-rc, 5.0.45, 4.1.22 | Any | Any | last_insert_id() inaccurate when inserting multiple rows |
34382 | 2008-02-07 14:55 | 2008-03-07 15:05 | MySQL Server: General | No Feedback (6085 days) | S3 | 5.0.32 | Any (Sorry none) | Any | Error when using ON DUPLICATE KEY UPDATE table1.field1 = table2.field1,.... |
34620 | 2008-02-16 17:16 | 2008-03-15 8:41 | MySQL Server: DML | Closed (6077 days) | S3 | 5.0+, 5.0.58-BK | Any | Any | item_row.cc:50: Item_row::illegal_method_call(const char*): Assertion `0' failed |
34660 | 2008-02-19 11:49 | 2011-10-08 16:07 | MySQL Server: Optimizer | Closed (4775 days) | S1 | 5.1.56, 5.0.56, 5.5.10 | Any | Any | crash when federated table loses connection during insert ... select |
34696 | 2008-02-20 16:27 | 2008-02-20 18:14 | MySQL Server: InnoDB storage engine | Not a Bug (6101 days) | S3 | 5.1 | Any | Any | auto increment gaps when using multi row insert with explicit values in InnoDB |
34768 | 2008-02-22 21:19 | 2008-03-29 18:24 | MySQL Server: Replication | Closed (6063 days) | S2 | 5.1, 6.0 BK | Any | Any | nondeterministic INSERT using LIMIT logged in stmt mode if binlog_format=mixed |
35087 | 2008-03-05 17:54 | 2011-02-16 23:43 | MySQL Server: General | Closed (5654 days) | S2 | 5.0.50+ | Any | Any | Inserting duplicate values at one time with DES_ENCRYPT leads to wrong results |
35205 | 2008-03-11 10:34 | 2008-03-15 12:52 | MySQL Workbench | Closed (6077 days) | S3 | 5.0.14b | Any | Any | Impossible to insert booleans |
35767 | 2008-04-02 10:55 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5097 days) | S1 | 6.0.5pre | Any | Any | Processing of uncorrelated subquery with semi-join cause wrong result and crash |
35856 | 2008-04-05 23:31 | 2008-10-16 4:30 | MySQL Server: InnoDB storage engine | Duplicate (5862 days) | S3 | 5.0.45 | Any | Any | false unique constraint violation on multiple updates |
35869 | 2008-04-07 9:12 | 2020-05-03 20:45 | MySQL Server: Views | Verified (6054 days) | S2 | 5.0/5.1/6.0 | Any | Any | Defining a view over an aggregate view renders the view definition invalid |
35877 | 2008-04-07 12:11 | 2011-02-16 23:43 | MySQL Server: Stored Routines | Closed (5470 days) | S3 | 5.1 | Any | Any | Update .. WHERE with function, constraint violation, crash |
35939 | 2008-04-09 14:49 | 2009-01-08 10:31 | MySQL Server: Falcon storage engine | Closed (5778 days) | S3 | 6.0-BK | Any | Any | Drift in Falcon row count reported by SHOW TABLE STATUS |
35990 | 2008-04-11 10:28 | 2011-02-16 23:43 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5497 days) | S3 | ndbcluster 6.2, 6.3, 7.0 | Any (any) | Any | Error code 1062 to 1296 (unknown) after setting sql_mode to STRICT_TRANS_TABLES |
36065 | 2008-04-14 17:08 | 2012-05-18 20:19 | MySQL Server: MyISAM storage engine | Duplicate (6030 days) | S3 | 6.0-falcon-team | Any | Any | MyISAM: duplicate key error on unique values |
36249 | 2008-04-22 10:50 | 2008-10-09 11:51 | MySQL Server: Falcon storage engine | Closed (5869 days) | S3 | 6.0 | Any | Any | Timing dependency bug in falcon_bug_22183 |
36413 | 2008-04-29 20:36 | 2011-02-16 23:43 | MySQL Workbench | Closed (5484 days) | S4 | 5.0.21 | Any | Any | Add row number to the INSERT Editor |
36426 | 2008-04-30 13:51 | 2008-11-05 22:56 | MySQL Server: Falcon storage engine | Can't repeat (5842 days) | S1 | 6.0.4 | Any | Any | Assertion in SerialLogControl::nextRecord line 313 on live downgrade |
36430 | 2008-04-30 15:26 | 2008-08-29 1:34 | MySQL Server: Falcon storage engine | Can't repeat (5910 days) | S1 | 6.0.5-release | Any | Any | Falcon: server crashes during plain insert operation |
36508 | 2008-05-05 15:15 | 2008-05-06 16:45 | MySQL Server: DML | Not a Bug (6025 days) | S2 | 5.1.24 | Any | Any | inserting null value to not null column with default value explicitly defined |
36570 | 2008-05-07 16:36 | 2008-05-24 17:39 | MySQL Server: Replication | Closed (6007 days) | S3 | 5.0.60 | Any | Any | Parse error of CREATE PROCEDURE stmt with comments on slave |
36676 | 2008-05-12 22:05 | 2016-02-25 12:24 | MySQL Server: DML | Closed (6009 days) | S2 | 5.0.58 | Any | Any | UPDATE on TEXT column using LEFT JOIN doesn't update all rows |
36852 | 2008-05-21 13:28 | 2017-05-21 20:45 | MySQL Server: Replication | Verified (6010 days) | S4 | any | Any | Any | Option to strip LOW_PRIORITY for replication |
36964 | 2008-05-26 13:29 | 2011-02-16 23:43 | MySQL Server | No Feedback (5363 days) | S2 | 5.1.22rc | Any (insert into into transaction don't insert record but don't return error) | Any | INSERT ... ON DUPLICATE KEY UPDATE does nothing but does not return error |
36988 | 2008-05-26 18:34 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5816 days) | S3 | 5.1.24-rc-community-log | Any | Any | Documentation on Next-Key Locking is confusing and misleading |
37080 | 2008-05-29 21:59 | 2009-01-08 10:32 | MySQL Server: Falcon storage engine | Closed (5778 days) | S3 | mysql-6.0-falcon-team | Any | Any | Falcon deadlock on concurrent insert and truncate |
37112 | 2008-05-31 0:29 | 2008-06-12 16:26 | MySQL Server: Documentation | Closed (5988 days) | S3 | 5.0.45, 4.1, 5.1, 6.0-BK | Any | Any | Server accepts VALUE() syntax as well as VALUES() |
37132 | 2008-06-02 3:48 | 2019-06-19 1:23 | MySQL Server: Logging | Closed (1964 days) | S3 | 5.1.25 | Any | Any | Logging to slow_log table fails with very slow queries |
37142 | 2008-06-02 17:04 | 2008-07-04 20:06 | MySQL Server: General | No Feedback (5966 days) | S2 | 4.0.14 | Any | Any | auto_increment problem with type bigint |
37183 | 2008-06-04 8:15 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5350 days) | S3 | 4.1.22, 5.0.64, 5.1.26, 6.0.6 | Any | Any | insert ignore into .. select ... hangs after deadlock was encountered |
37189 | 2008-06-04 10:44 | 2021-05-23 20:45 | MySQL Server: Falcon storage engine | Duplicate (5996 days) | S3 | 6.0.6 | Any | Any | can't drop table during an uncommited transaction |
37315 | 2008-06-10 18:17 | 2013-02-20 22:14 | Connectors: DBD::mysql ( Perl ) | Unsupported (4274 days) | S3 | 4.005, 4.007 | Any | Any | bind_param incorrectly interprets scientific notation |
37343 | 2008-06-11 13:42 | 2008-09-30 19:49 | MySQL Server: Falcon storage engine | Closed (5878 days) | S1 | 6.0-falcon | Any | Any | Assertion in IndexNode::parseNode, ASSERT(key - (UCHAR*) indexNode < 14); |
37348 | 2008-06-11 15:30 | 2011-02-16 23:43 | MySQL Server: Optimizer | Closed (5861 days) | S1 | 5.1/6.0-falcon | Any | Any | Crash in or immediately after JOIN::make_sum_func_list |
37531 | 2008-06-19 19:38 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5250 days) | S3 | 5.1.25/6.0 | Any | Any | After truncate, auto_increment behaves incorrectly for InnoDB |
37716 | 2008-06-28 11:20 | 2018-09-25 21:47 | Tests: Replication | Closed (5659 days) | S7 | 6.0, 5.1 | Any | Any | rpl.rpl_deadlock_innodb 'row' failed on pushbuild |
37735 | 2008-06-30 8:40 | 2008-06-30 15:24 | MySQL Server: DML | Not a Bug (5970 days) | S2 | 5.1, 5.0, 4.1, 6.0 BZR | Any | Any | WHERE clause fails immediately following INSERT on AUTO INCREMENT column |
37879 | 2008-07-04 15:44 | 2018-09-25 21:47 | Tests: Replication | Duplicate (5932 days) | S7 | 5.1.26-rc | Any | Any | Failures in rowbased replication: Test "rpl_row_basic_{2myisam,3innodb}" (1) |
37995 | 2008-07-09 15:42 | 2011-02-16 23:43 | MySQL Server: Embedded Library ( libmysqld ) | Closed (5567 days) | S3 | 5.1.26-rc | Any | Any | Error message truncation in test "innodb" in embedded mode |
38034 | 2008-07-11 3:27 | 2011-02-16 23:43 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5529 days) | S2 | mysql-5.1-telco-6.2 | Any (Solaris, Linux) | Any | last_insert_id() value not shown in table with trigger |
38046 | 2008-07-11 14:22 | 2012-08-03 15:34 | MySQL Server: Locking | Closed (4475 days) | S3 | 5.0, 5.1, 6.0 bzr | Any | Any | INSERT SELECT ON DUPLICATE KEY UPDATE, LOAD DATA REPLACE wrong lock |
38068 | 2008-07-12 12:37 | 2008-09-15 17:15 | MySQL Server: Replication | Closed (5893 days) | S2 | 6.0, 5.1 | Any | Any | binlog_stm_binlog fails sporadically in pushbuild |
38071 | 2008-07-12 14:37 | 2017-05-21 20:45 | MySQL Server: Row Based Replication ( RBR ) | Duplicate (5953 days) | S3 | 6.0 | Any | Any | rpl_row_basic_2myisam: results mismatch in row mode |
38122 | 2008-07-15 7:41 | 2011-02-16 23:43 | Tools: Pushbuild | Closed (5484 days) | S3 | 1 | Any | Any | main.mysqlslap fails sporadically |
38148 | 2008-07-15 18:42 | 2008-07-15 20:52 | MySQL Server: Replication | Can't repeat (5955 days) | S3 | 5.0.37 | Any | Any | insert user() references uninitialized fields on a slave |
38289 | 2008-07-22 17:28 | 2018-09-25 21:48 | Tests: Replication | Can't repeat (5746 days) | S7 | 6.0-bugteam | Any | Any | rpl_temporary fails sporadically on windows: server has gone away |
38360 | 2008-07-25 3:55 | 2011-02-16 23:43 | MySQL Server | Closed (5861 days) | S2 | 5.1, 6.0 BZR | Any | Any | BLACKHOLE replication with RBR is broken |
38531 | 2008-08-02 14:16 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5562 days) | S4 | 5.0,5.1,4.0,4.1 | Any | Any | make innodb faster for concurrent insert/update workloads |
38540 | 2008-08-04 14:57 | 2018-09-25 21:48 | Tests: Replication | Closed (5756 days) | S7 | 5.1 | Any | Any | rpl_server_id2 uses show slave status unnecessarily |
38558 | 2008-08-05 7:58 | 2018-09-25 21:49 | Tests: Replication | Can't repeat (5544 days) | S7 | 6.0,5.4 | Any | Any | rpl_blob_innodb_row fails sporadically in pushbuild: Lost connection to server |
38654 | 2008-08-08 4:43 | 2011-02-16 23:43 | MySQL Workbench | Closed (5604 days) | S3 | 5.0.23 | Any | Any | renaming table causes insert statements to be lost |
38655 | 2008-08-08 4:47 | 2008-09-08 5:05 | MySQL Workbench | No Feedback (5900 days) | S3 | 5.0.23 | Any | Any | insert statements malformed under certain circumstances |
38744 | 2008-08-12 8:58 | 2016-10-16 20:45 | Tests: Replication | Duplicate (5760 days) | S3 | 6.0-BK | Any | Any | rpl.rpl_stm_000001 (mix) fails sporadically |
38854 | 2008-08-18 13:15 | 2016-10-16 20:45 | MySQL Server: Replication | Verified (5921 days) | S3 | 5.1.26, 5.1, 6.0 bzr | Any | Any | wrong data if SIGNED/UNSIGNED bit doesn't match |
38906 | 2008-08-20 9:02 | 2011-02-16 23:43 | MySQL Workbench | Closed (5568 days) | S3 | 5.0.24 | Any | Any | illegal/no quoting in Insert Editor |
39088 | 2008-08-28 11:16 | 2008-10-13 15:31 | MySQL Workbench | Closed (5865 days) | S3 | 5.0.24/5.0.25 | Any | Any | triggers calling procedures fails on insert |
39193 | 2008-09-02 16:10 | 2011-02-16 23:43 | MySQL Server | Can't repeat (5603 days) | S2 | 6.0-bzr, 5.4 | Any | Any | Deadlock in recover_from_failed_open_table_attempt() |
39207 | 2008-09-03 9:58 | 2008-09-09 10:46 | MySQL Server: InnoDB storage engine | Not a Bug (5899 days) | S3 | 5.1+ | Any | Any | update does not always change auto_increment value |
39222 | 2008-09-03 19:00 | 2008-09-03 19:32 | MySQL Server | Not a Bug (5905 days) | S3 | 5.0.51-log | Any | Any | no difference between LOCK IN SHARE MODE and LOCK FOR UPDATE |
39265 | 2008-09-05 4:13 | 2018-08-22 10:23 | MySQL Server: General | Closed (5738 days) | S3 | 5.1, 6.0 | Any | Any | SQL_MODE OLD_NOT_NULL_CHECK_BEHAVIOUR for backward compatibility |
39359 | 2008-09-10 7:14 | 2018-09-25 21:49 | Tests: Server | Can't repeat (4877 days) | S7 | 6.0 | Any | Any | main.analyze fails randomly on Pushbuild |
39432 | 2008-09-13 12:50 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5636 days) | S3 | ndb-6.2+ | Any (debian) | Any | slave stops if master does insert ... on duplicate key update |
39474 | 2008-09-16 11:50 | 2022-12-04 20:45 | MySQL Server: DDL | Verified | S2 | 5.x, 6.0.8 | Any | Any | checksum table reports equal checksums when data is different |
39477 | 2008-09-16 13:12 | 2008-10-13 14:03 | MySQL Workbench | Closed (5865 days) | S3 | 5.0.25 | Any | Any | "Copy insert to Clipboard" uses lower case for keywords |
39654 | 2008-09-25 19:00 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5522 days) | S3 | 5.1, 6.0 | Any | Any | Insufficient error message for "The total number of locks exceeds ..." |
39660 | 2008-09-26 8:13 | 2012-05-18 20:19 | MySQL Server: Stored Routines | Duplicate (5882 days) | S2 | 5.1 | Any | Any | Before Trigger in combination with NOT NULL behaves wrong |
39661 | 2008-09-26 9:30 | 2021-05-23 20:45 | MySQL Server: Falcon storage engine | Duplicate (5542 days) | S2 | 6.0.7 | Any | Any | Assert in SerialLogWindow.cpp during very long lasting insert transaction |
39927 | 2008-10-08 11:17 | 2011-02-16 23:43 | MySQL Cluster: Replication | Closed (5564 days) | S2 | mysql-5.1-telco-7.0 | Any | Any | ndb_log_update_as_write does not work as expected |
39993 | 2008-10-13 6:16 | 2012-05-18 20:19 | MySQL Server: Replication | Duplicate (5483 days) | S4 | 4.1, 5.0, 5,1, 6.0 bzr | Any | Any | set binlog-do-db parameter by command line |
40116 | 2008-10-17 16:57 | 2011-02-16 23:43 | MySQL Server: Replication | Closed (5470 days) | S2 | 5.0.70, 5.0.74, 5.1.26, 5.1.29 | Any | Any | Uncommited changes are replicated and stay on slave after rollback on master |
40255 | 2008-10-22 15:10 | 2011-02-16 23:43 | MySQL Server: Information schema | Verified (5855 days) | S3 | Any | Any | INFORMATION_SCHEMA.WARNINGS - a CREATE/INSERT .. SELECT friendly table | |
40329 | 2008-10-25 18:43 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5816 days) | S3 | mysqld-nt Ver 5.0.67-community-nt for Win32 on ia32, 5.0, 5.1, 6.0 | Any | Any | TIMESTAMPADD does not take in to account Daylight Savings Time. |
40384 | 2008-10-29 7:42 | 2019-11-04 15:09 | MySQL Server: DML | Closed (1826 days) | S3 | 5.1, main-6.0, revision 2866 and greater | Any | Any | Gap in auto_increment sequence when inserts fire a trigger |
40698 | 2008-11-13 13:43 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5830 days) | S3 | Any | Any | after binary to varchar convertion varchar isn't variable | |
40709 | 2008-11-13 17:31 | 2011-02-16 23:43 | MySQL Cluster: Cluster (NDB) storage engine | Closed (5647 days) | S3 | * | Any | Any | weird schema created with partition by key + mysqld core on insert |
40747 | 2008-11-14 15:03 | 2020-05-03 20:45 | MySQL Server: Data Types | Verified (5833 days) | S3 | 5.0.70, 5.1.29, 6.0.7 | Any | Any | Duplicate datetime truncation warning if a range optimizer is used. |
40827 | 2008-11-18 16:18 | 2011-02-16 23:43 | MySQL Server: MyISAM storage engine | Closed (5653 days) | S2 | 5.0+ | Any | Any | Killing insert-select to MyISAM can cause table corruption |
40878 | 2008-11-20 10:21 | 2008-11-26 16:14 | MySQL Server: Backup | Closed (5821 days) | S3 | mysql-6.0-backup v6.0.8 | Any | Any | Backup: main.implicit_commit fails in pushbuild |
40879 | 2008-11-20 11:08 | 2011-02-16 23:43 | MySQL Server: DML | Duplicate (5787 days) | S1 | 5.0.68 | Any | Any | insert..select crashed in field_conv |
41007 | 2008-11-25 11:21 | 2008-11-26 10:13 | MySQL Server: DML | Not a Bug (5821 days) | S2 | 5.0.67 | Any (Tested on OSX and Linux Debian) | Any | Update Problem when ORing w/ Long.MIN_VALUE |
41098 | 2008-11-28 14:33 | 2011-02-16 23:43 | MySQL Server: Query Cache | Closed (5709 days) | S3 | 5.1,6.0 | Any | Any | Query Cache returns wrong result with concurrent insert |
41140 | 2008-11-30 23:41 | 2011-02-16 23:43 | MySQL Server: Locking | Can't repeat (5546 days) | S2 | 5.1.22-rc, 5.1.30 | Any | Any | Failure of replication on triggered insert if innodb_autoinc_lock_mode > 0 |
41183 | 2008-12-02 19:17 | 2011-02-16 23:43 | Tests: Cluster | Closed (5744 days) | S3 | 5.1 | Any | Any | rpl_ndb_circular, rpl_ndb_circular_simplex need maintenance, crash |
41311 | 2008-12-08 21:39 | 2022-12-04 20:45 | MySQL Server: Security: Privileges | Verified (5808 days) | S3 | 5.0.67, 5.0.72, 5.1.30 | Any | Any | set timestamp allows unprivileged users to change per-session clock |
41348 | 2008-12-10 2:38 | 2011-02-16 23:43 | MySQL Server: Locking | Closed (5757 days) | S2 | 5.1.30 | Any | Any | INSERT INTO tbl SELECT * FROM temp_tbl overwrites locking type of temp table |
41370 | 2008-12-10 18:13 | 2011-02-16 23:43 | MySQL Server: Data Types | Closed (5744 days) | S2 | 5.0.60sp1, 5.1.30 | Any | Any | TIMESTAMP field does not accepts NULL from FROM_UNIXTIME() |
41466 | 2008-12-15 11:14 | 2011-02-16 23:43 | MySQL Cluster: Replication | Closed (5797 days) | S3 | cluster 6.4 | Any | Any | online add partition with replication looses data |
41477 | 2008-12-15 15:33 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5802 days) | S3 | 4.1, 5.0, 5,1, 6.0 bzr | Any | Any | InnoDB foreign keys: wrong result if ON DELETE CASCADE, and correlated subquery |
41503 | 2008-12-16 13:12 | 2018-09-25 21:50 | Tests: Replication | Closed (5773 days) | S7 | 5.1-rpl, 6.0-rpl | Any | Any | rpl_row_log fails sporadically: query failed: "Unknown table 't1'" |
41703 | 2008-12-23 0:56 | 2021-05-23 20:45 | MySQL Server: Falcon storage engine | Duplicate (5794 days) | S2 | 6.0.10-alpha-debug | Any | Any | Falcon: dagger duplicates space |
41709 | 2008-12-23 10:59 | 2011-02-16 23:43 | MySQL Server: Documentation | Closed (5665 days) | S3 | 5.0.70, 5.1.30 | Any (windows+linux+solaris) | Any | myisam external locking doesn't work as advertised |
41754 | 2008-12-26 12:03 | 2017-05-21 20:45 | MySQL Server: Replication | Duplicate (5703 days) | S2 | 5.0.70, 5.1.30, 6.0.9 | Any | Any | 'Cannot add or update a child row: a foreign key constraint fails' on SBR+Innodb |
41760 | 2008-12-27 2:01 | 2020-05-03 20:45 | MySQL Server: Views | Verified (5493 days) | S3 | 5.0 and up | Any | Any | Inserting into multiple-table views is not working |
41776 | 2008-12-29 3:45 | 2011-02-16 23:43 | MySQL Server: Tests | Closed (5570 days) | S3 | 5.0, 5.1, 6.0 bzr | Any | Any | type_date.test may fail if run around midnight. |
42396 | 2009-01-27 21:35 | 2017-01-18 13:23 | MySQL Cluster: Replication | Can't repeat (2846 days) | S3 | mysql-6.0 | Any | Any | autoincrement insert into ndb fails with duplicate key |
42497 | 2009-01-31 10:51 | 2009-02-02 19:34 | MySQL Server: InnoDB storage engine | Not a Bug (5753 days) | S3 | 5.1.30-log | Any | Any | V5.1 AUTO_INCREMENT gaps with InnoDB when using INSERT IGNORE |
42509 | 2009-02-01 9:20 | 2010-05-26 18:00 | MySQL Server: Maria storage engine | Unsupported (5275 days) | S2 | 6.0-maria | Any | Any | Maria write_block_record: Assertion `data_length < ((block_size) * 3 / 4)' |
42539 | 2009-02-02 11:12 | 2017-10-07 13:25 | MySQL Server: Documentation | Closed (2584 days) | S3 | Any | Any | _rowid can be used anywhere as identifier for pkey | |
42540 | 2009-02-02 11:34 | 2011-02-16 23:43 | MySQL Server: Security: Privileges | Duplicate (5753 days) | S3 | 6.0.9 | Any | Any | SELECT,INSERT ... command denied to usual user for TEMPORARY table |
43167 | 2009-02-25 6:16 | 2009-02-25 6:54 | MySQL Server | Not a Bug (5730 days) | S2 | 6.0 | Any | Any | table locks are not working properly |
43263 | 2009-02-27 14:39 | 2011-02-16 23:43 | MySQL Server: Replication | Closed (5610 days) | S3 | 5.0, 5.1 | Any | Any | BEGIN skipped in some replicate-do-db cases |
43402 | 2009-03-05 8:31 | 2009-03-05 13:18 | MySQL Server: Replication | Not a Bug (5722 days) | S2 | 5.0.45 | Any | Any | mysqlbinlog ignores data added using "insert into database.table values(...) |
43452 | 2009-03-06 13:08 | 2009-05-15 17:05 | MySQL Server: Falcon storage engine | Closed (5651 days) | S3 | 6.0.10 | Any | Any | Wrong number of rows returned when using LIMIT |
43477 | 2009-03-07 20:09 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (5143 days) | S2 | 5.1.29, 5.1.32, 5.1.33 | Any | Any | Server hangs with table general log, statement binlog format and partitions |
43504 | 2009-03-09 12:39 | 2009-05-15 16:13 | MySQL Server: Falcon storage engine | Closed (5651 days) | S1 | 6.0 | Any | Any | Falcon DBT2 crash in Table::rollbackRecord() |
43565 | 2009-03-11 15:51 | 2021-05-23 20:45 | MySQL Server: Falcon storage engine | Duplicate (5716 days) | S1 | 6.0.10-release | Any | Any | Falcon: Access to any Falcon data after second restart of server causes crash |
43604 | 2009-03-12 16:22 | 2021-05-02 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Verified (5658 days) | S4 | mysql-6.0 | Any (NDB supported OS only) | Any | Backup: No native driver for NDB Backup |
43630 | 2009-03-13 11:31 | 2009-10-22 10:35 | MySQL Server: Falcon storage engine | Closed (5491 days) | S2 | falcon-team | Any | Any | A SELECT using ORDER BY and LIMIT sometimes returns no rows |
43700 | 2009-03-17 13:27 | 2009-03-18 8:56 | MySQL Server: Locking | Not a Bug (5709 days) | S3 | Ver 14.12 Distrib 5.0.54 | Any (ubuntu) | Any | dead lock after insert inside transaction |
43716 | 2009-03-18 2:22 | 2011-02-16 23:43 | Tests: Server | Closed (5660 days) | S3 | 5.1+ | Any | Any | Test mysqlbinlog_row_big is failing, needs to be updated |
43842 | 2009-03-24 20:19 | 2013-01-14 9:25 | MySQL Server: Federated storage engine | Won't fix (4311 days) | S4 | 5.0 | Any | Any | Support for ON DUPLICATE KEY UPDATE with FEDERATED |
43930 | 2009-03-28 10:18 | 2011-02-16 23:43 | MySQL Server: Options | Verified | S4 | 5.0.x | Any | Any | Add sql_mode that throws warnings when rounding non-integer numbers to integers |
43954 | 2009-03-30 8:49 | 2021-05-23 20:45 | MySQL Server: Falcon storage engine | Duplicate (5695 days) | S3 | 6.0.11-alpha | Any | Any | falcon_bug_22150 sometimes crashes the server |
44199 | 2009-04-10 0:11 | 2011-02-16 23:43 | Connector / ODBC | Can't repeat (5686 days) | S2 | 5.1.6 | Any | Any | Unable to INSERT columns into view using ODBC 5.1.6/ADO |
44306 | 2009-04-16 6:58 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5609 days) | S1 | 5.1.33, 5.1, 6.0 bzr | Any | Any | Assertion fail on duplicate key error in 'INSERT ... SELECT' statements |
44363 | 2009-04-20 9:56 | 2011-02-16 23:43 | MySQL Server: General | Verified (5675 days) | S2 | 5.1.15, 5.1.35-bzr | Any | Any | IDIV not rounding off float/decimals correctly ? |
44392 | 2009-04-21 21:46 | 2009-04-22 10:30 | Connector / NET | Not a Bug (5674 days) | S1 | 5.2.5 or any 6.0.x beta | Any | Any | Using Variable with insert/select |
44752 | 2009-05-08 14:46 | 2016-10-16 20:45 | MySQL Server: Row Based Replication ( RBR ) | Duplicate (5654 days) | S1 | 5.1.34 | Any | Any | binary log corruption with RBR and trigger |
44783 | 2009-05-11 12:00 | 2012-05-18 20:19 | MySQL Server: Falcon storage engine | Duplicate (5589 days) | S3 | falcon-team | Any | Any | A SELECT using ORDER BY and LIMIT sometimes returns too many rows |
44960 | 2009-05-19 18:46 | 2011-02-16 23:43 | Connector / NET | Closed (5640 days) | S3 | 6.0.3 | Any | Any | backslash in string - connector return exeption |
44978 | 2009-05-20 9:38 | 2023-02-12 20:45 | MySQL Server: Replication | Duplicate (5645 days) | S3 | Any | Any | Valgrind failure: Source and destination overlap in strcpy | |
45077 | 2009-05-25 19:08 | 2011-02-16 23:44 | Connector / NET | Closed (5564 days) | S1 | 6.0.3 | Any | Any | Insert problem with Connector/NET 6.0.3 and entity framework |
45086 | 2009-05-26 7:10 | 2021-05-23 20:45 | MySQL Server: Falcon storage engine | Duplicate (5589 days) | S3 | 6.0.11 | Any | Any | A SELECT using ORDER BY and LIMIT sometimes misses one row |
Showing 1-1000 of 2825 (Edit, Save, CSV, Feed) | Show Next 1000 Entries » |