| Showing all 172 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 24251 | 2006-11-13 10:58 | 2018-09-09 20:45 | MySQL Server: Optimizer | In progress (5645 days) | S5 | 5.0.30-BK, 5.1.12 | Linux (Linux, Win XP SP2) | Any | Non-optimal choice of indexes for queries |
| 32571 | 2007-11-21 13:03 | 2022-12-04 20:45 | MySQL Server: DDL | In progress (2951 days) | S3 | 5.0.37, 5.1, 5.6, 5.7 | Linux (Windows, Ubuntu) | Any | CREATE TABLE options are dependant on the order of specification |
| 36541 | 2008-05-06 17:01 | 2016-10-16 20:45 | MySQL Server: Replication | In progress (5270 days) | S2 | 5.0.51a-log, 5.1 | Linux | Any | Query event with BEGIN has different size on master and slave |
| 44278 | 2009-04-15 3:26 | 2014-07-02 11:56 | MySQL Server: Command-line Clients | Patch pending (5756 days) | S2 | 1.23, 5.1, 6.0 bzr | Linux (RHEL4) | Any | mysqlhotcopy unable to backup schema with a hyphen in its name |
| 3052 | 2004-03-03 2:46 | 2025-04-30 18:27 | MySQL Server: Stored Routines | Verified (6954 days) | S3 | 5.1 | Linux (SuSE 8.2) | Any | Rollback in stored procedure doesn't close cursor |
| 10132 | 2005-04-25 3:00 | 2018-09-23 20:45 | MySQL Server: InnoDB storage engine | Verified (4123 days) | S1 | 5.1, 6.0 | Linux (Linux) | Any | Crashing the server on corrupt InnoDB page is unhelpful |
| 12719 | 2005-08-22 10:51 | 2017-11-13 20:47 | MySQL Server: Stored Routines | Verified (5832 days) | S3 | 5.0.12, 5.0.14-rc, 5.1.34 | Linux (Linux) | Any | SHOW CREATE PROCEDURE/FUNCTION does obey sql_quote_show_create |
| 14347 | 2005-10-26 18:53 | 2022-12-04 20:45 | MySQL Server: Parser | Verified (5944 days) | S2 | 5.0.15, 5.0.74, 5.1.30, 6.0.9 | Linux (Linux Suse 10, Windows) | Any | Can't remove FOREIGN KEY |
| 16402 | 2006-01-12 3:44 | 2012-05-18 20:19 | MySQL Server: Stored Routines | Verified (7018 days) | S3 | 5.1.6-alpha-debug | Linux (linux) | Any | Events: SHOW EVENT STATUS doesn't work |
| 17785 | 2006-02-28 14:38 | 2012-05-18 20:19 | MySQL Server: Federated storage engine | Verified (6936 days) | S2 | 5.1.6 | Linux (Linux Fedora Core 4) | Any | Transactions on Federated Engine do not work when initiated on federated server |
| 20026 | 2006-05-23 19:34 | 2013-03-03 20:45 | MySQL Server: Federated storage engine | Verified (6701 days) | S3 | 5.1-bk | Linux (linux) | Any | FEDERATED lacks support for auto_increment_increment and auto_increment_offset |
| 20724 | 2006-06-27 14:00 | 2013-03-03 20:45 | MySQL Server: Federated storage engine | Verified (6701 days) | S3 | 5.1-bk | Linux (linux) | Any | FEDERATED does not honour SET INSERT_ID |
| 20786 | 2006-06-29 22:31 | 2024-04-29 4:58 | MySQL Server: Information schema | Verified (5868 days) | S2 | 5.1.11 beta | Linux (Redhat Linux ES3) | Any | mysqldump always includes AUTO_INCREMENT |
| 21094 | 2006-07-17 14:50 | 2022-12-18 8:21 | MySQL Server: DDL | Verified (6870 days) | S3 | 5.1-BK, 5.0-BK, 5.0.19 | Linux (linux) | Any | ALTER TABLE ... ROW_FORMAT=compressed does not lead into error |
| 21517 | 2006-08-08 18:10 | 2017-05-21 20:45 | MySQL Server: Replication | Verified (6848 days) | S3 | 5.1.12 | Linux (Linux) | Any | Several variables need to be added to show variabels and slave status |
| 22034 | 2006-09-05 23:10 | 2014-01-22 14:27 | MySQL Server: Stored Routines | Verified (4124 days) | S3 | 5.1.12-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Events: U and ΓΌ are the same name |
| 22246 | 2006-09-11 21:37 | 2022-12-04 20:45 | MySQL Server: Locking | Verified (5626 days) | S3 | 4.1.22, 5.0.45, 5.1.43, 6.0.14 | Linux (Linux) | Any | Allow LOCK TABLE WRITE lock a non-existent table. |
| 22632 | 2006-09-23 20:45 | 2022-12-04 20:45 | MySQL Server: DDL | Verified (6784 days) | S3 | 5.1.11-beta | Linux (linux) | Any | SHOW CREATE TABLE is inconsistent in showing unsupported options |
| 24455 | 2006-11-21 8:40 | 2022-12-04 20:45 | MySQL Server: Security: Privileges | Verified (6730 days) | S3 | 5.1.12-beta-community-nt, 5.0 BK | Linux (linux, window 2000) | Any | procs_priv shows error user after granting procedure's privilege to special user |
| 24489 | 2006-11-21 22:16 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6729 days) | S3 | 5.0 BK, 5.1 BK | Linux (Linux) | Any | @@sql_select_limit applies to stored functions, triggers, events |
| 24754 | 2006-12-01 13:34 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5628 days) | S3 | 5.1.14, 5.1.43-bzr | Linux (Linux) | Any | Index is not used when joining two tables |
| 24758 | 2006-12-01 18:08 | 2012-05-18 20:19 | MySQL Server: Options | Verified (6364 days) | S3 | 5.0.27, 4.1 BK, 5.1 BK | Linux (Fedora Core6) | Any | max_user_connections=0 doesn't work had to set a value to make it work |
| 24761 | 2006-12-01 20:50 | 2022-12-04 20:45 | MySQL Server: General | Verified (6065 days) | S3 | 5.0.36-BK, 5.0.27, 5.1, 6.0.7 | Linux (Linux (Fedora)) | Any | dropped TCP connections not logged as errors but result in blocked host |
| 24833 | 2006-12-05 18:34 | 2018-09-09 20:45 | MySQL Server: Parser | Verified (6688 days) | S3 | 5.0.26, 5.1 BK | Linux (Linux) | Any | QUICK option to DELETE lost in a multiple-table delete |
| 25093 | 2006-12-15 12:49 | 2017-05-21 20:45 | MySQL Server: Replication | Verified | S3 | 5.1.14 | Linux (linux5.) | Any | slave replay of transaction with CREATE TMP table fails |
| 25153 | 2006-12-18 17:35 | 2013-03-03 20:45 | MySQL Server: Options | Verified (6715 days) | S3 | 5.0,5.1 | Linux (SUSE 10.0 / 64-bit) | Any | mysqld --skip-engine option |
| 25630 | 2007-01-15 15:59 | 2018-09-09 20:45 | MySQL Server: Information schema | Verified (5768 days) | S3 | 5.0.33-standard-log/5.1BK | Linux (Centos 4.x) | Any | INFORMATION_SCHEMA collation wrong for filesystems with case sensitive filenames |
| 25672 | 2007-01-17 8:33 | 2013-03-03 20:45 | MySQL Server: Federated storage engine | Verified (6686 days) | S3 | 5.1.15 | Linux (linux) | Any | ALTER/DROP SERVER does not immediately affect open tables |
| 26697 | 2007-02-27 21:53 | 2013-03-03 20:45 | MySQL Server: Federated storage engine | Verified (6629 days) | S2 | 5.0.38-BK, 5.0.27, 5.1 | Linux (Linux, Windows 2000) | Any | Every query to a federated table results in a full scan of MyISAM table. |
| 27452 | 2007-03-26 17:35 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6016 days) | S3 | 5.0.40-BK, 5.0.24a-debian-log, 5.1.31-bzr, 6.0.7-alpha, 6.0.9-bzr | Linux | Any | Correlated subquery produces inefficient optimizer plan for INFORMATION_SCHEMA |
| 27552 | 2007-03-30 15:37 | 2016-10-16 20:45 | MySQL Server: Replication | Verified (5054 days) | S1 | 5.0.37-log, 5.0, 5.1 BK | Linux (Linux (x86_64)) | Any | NO_BACKSLASH_ESCAPES with replication fails with apostrophes |
| 28404 | 2007-05-13 18:33 | 2018-11-11 14:44 | MySQL Server: Optimizer | Verified (2370 days) | S2 | 4.0.31, 4.1.25, 4.1.26, 5.0.42-BK, 5.0.46, 5.1.33 | Linux | Any | Optimizer does not consider index that can be used for ORDER BY |
| 28538 | 2007-05-19 14:16 | 2017-05-21 20:45 | MySQL Server: Replication | Verified (6562 days) | S3 | 5.1.18, 5.1.21 | Linux | Any | Assertion failure when replicating "DELETE FROM t" from ndb to myisam. |
| 30010 | 2007-07-24 16:18 | 2021-05-02 20:45 | MySQL Server: Stored Routines | Verified (6168 days) | S2 | 5.0, 5.1.20, 5.1.24-ndb-6.3.14 | Linux (Fedora Core 5) | Any | Auto-increment out of sync when using triggers and NDB Cluster |
| 30159 | 2007-07-31 21:46 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6490 days) | S3 | 5.1.21-beta-debug | Linux (SUSE 10 64-bit) | Any | Different results with SELECT FOR UPDATE versus plain SELECT |
| 30454 | 2007-08-16 13:49 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6475 days) | S3 | 5.0.26-log/5.1 | Linux (Gentoo kernel 2.6.18-gentoo-r6-nopatch-xxxx-ipv4-32) | Any | 'default_week_format' has no effect on YEARWEEK() as it has on WEEK() |
| 31102 | 2007-09-20 4:21 | 2022-12-04 20:45 | MySQL Server: Logging | Verified (6435 days) | S3 | 5.1.22-rc, 5.1.21 | Linux | Any | set global general_log_file does not check that log file exists, can corrupt fil |
| 31551 | 2007-10-11 22:30 | 2013-06-13 19:31 | MySQL Server: MyISAM storage engine | Verified (6176 days) | S2 | 5.0.45, 5.0 BK, 5.1 BK | Linux (CentOS 4.5) | Any | MyISAM poor performance with multiple queries running concurrently |
| 31832 | 2007-10-25 6:52 | 2011-02-16 23:43 | MySQL Server: Command-line Clients | Verified (5833 days) | S3 | 5.0.41, 5.0, 5.1 BK | Linux | Any | mysql executable ignores --protocol when $MYSQL_HOST is set |
| 33006 | 2007-12-05 17:40 | 2011-02-16 23:43 | MySQL Server: Command-line Clients | Verified (6363 days) | S3 | 5.0, 5.1, 6.0 | Linux (SUSE 10 64-bit, FreeBSD 7.0 64-bit) | Any | mysql client: editing non-ascii characters fails |
| 33250 | 2007-12-14 17:17 | 2013-03-03 20:45 | MySQL Server: Federated storage engine | Verified (5617 days) | S2 | mysql-5.1.22-rc | Linux | Any | SELECT * FROM really_big_federated_table eats lots of virtual memory (OOM) |
| 33368 | 2007-12-19 14:33 | 2022-12-04 20:45 | MySQL Server: General | Verified (6349 days) | S3 | 5.1.23 | Linux | Any | rows count wrapped when inserting 2^31 or more records |
| 34023 | 2008-01-23 22:07 | 2020-05-03 20:45 | MySQL Server: Views | Verified (6313 days) | S3 | 5.0, 5.1 BK,6.0.5-alpha-debug | Linux (SUSE 10 / 64-bit) | Any | Views: column name length = 0 if binary non-latin |
| 34119 | 2008-01-29 0:42 | 2022-12-04 20:45 | MySQL Server: DDL | Verified (6251 days) | S3 | 5.1.24-rc-debug | Linux (SUSE 10 / 64-bit) | Any | CREATE INDEX changes data if no_zero_in_date |
| 34720 | 2008-02-21 11:29 | 2018-09-09 20:45 | MySQL Server: General | Verified (6286 days) | S3 | 5.1.22-RC, 5.0, 5.1, 6.0 BK | Linux (Linux database-112-2-1.db.overlay.intra 2.6.18-53.1.6.el5 #1 SMP Wed Jan 23 11:28:47 EST 2008 x86_64) | Any | Looks like the CONCAT function is truncating the output |
| 35002 | 2008-03-03 14:17 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6274 days) | S2 | 5.1.23-rc/5.1BK/5.0/6.0 | Linux (2.6.22.9-61.fc6) | Any | Wrong results returned when using derived table and group by |
| 35499 | 2008-03-22 6:26 | 2018-09-09 20:45 | MySQL Server: Views | Verified (6256 days) | S3 | mysql-6.0-backup,5.1 | Linux | Any | View when created with swe7 character set fails. |
| 35766 | 2008-04-02 10:05 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6245 days) | S3 | 5.1.22, 4.1, 5.0, 5.1, 6.0 BK | Linux (Mandriva 2008 ) | Any | LOAD OPTIONALLY ENCLOSED BY prematurly terminates |
| 36300 | 2008-04-23 17:49 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5595 days) | S3 | 4.1.26, 5.0.32, 5.0+, 5.1.43-bzr, 6.0.14-bzr | Linux | Any | min() and max() functions returns NULL when using NOT + BETWEEN in where |
| 36312 | 2008-04-24 7:42 | 2020-11-22 20:45 | MySQL Server: Partitions | Verified (5251 days) | S3 | 5.1.24,5.1.51 | Linux | Any | InnoDB DATA_FREE BUG? |
| 36725 | 2008-05-14 20:19 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (6008 days) | S2 | 5.1.22/5.0BK/5.1BK | Linux (Ubuntu 7.04) | Any | UPDATE takes too long to execute |
| 37109 | 2008-05-30 22:05 | 2011-02-16 23:43 | MySQL Server: Command-line Clients | Verified (6186 days) | S3 | 5.0.54, 4.1, 5.1, 6.0 BK | Linux | Any | parse error in \! and system |
| 37262 | 2008-06-07 10:18 | 2017-05-21 20:45 | MySQL Server: Replication | Verified (6006 days) | S3 | 5.0, 5.1 | Linux | Any | Access denied for Linux Master and Slave on other machine/OS |
| 37307 | 2008-06-10 13:23 | 2011-02-16 23:43 | MySQL Server: MyISAM storage engine | Verified (5985 days) | S3 | 5.0-bk, 5.1-maria | Linux | Any | MyISAM: R-tree unit test produces corrupted table |
| 38256 | 2008-07-21 12:36 | 2011-02-16 23:43 | MySQL Server: General | Verified (6133 days) | S3 | 5.0.51, 5.1 | Linux (Debian "Sid" package mysql-server-5.0 5.0.51a-10) | Any | Inconsistency between unix_timestamp() differences and timestampdiff(SECOND,) |
| 39201 | 2008-09-02 21:22 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6091 days) | S3 | 5.1.26-rc, 4.1, 5.0, 5.1, 6.0 bzr | Linux (2.6.24.5-smp) | Any | INTO OUTFILE Statement |
| 39386 | 2008-09-11 9:21 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6082 days) | S3 | 5.0.67, 5.1 | Linux (CentOS 5.2, FreeBSD) | Any | INET_ATON() does not work properly inside a trigger |
| 39799 | 2008-10-02 0:39 | 2013-03-03 20:45 | MySQL Server: MyISAM storage engine | Verified (6042 days) | S2 | 5.0.64 Enterprise, 5.0, 5.1 bzr | Linux (CentOS 3.5) | Any | MySQL changes total_data_length before free_data_length when optimizing table |
| 39967 | 2008-10-10 1:47 | 2016-10-16 20:45 | MySQL Server: Replication | Verified (6021 days) | S3 | 5.0.67, 5.1 | Linux (ubuntu 8.04 lts x86_64) | Any | Binlog should save timezone information when calculating dates from timestamp |
| 40896 | 2008-11-20 16:55 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (6013 days) | S3 | 5.0.45, 5.0.70, 5.1.30, 6.0.7 | Linux (CentOS 5) | Any | CREATE PROCEDURE fails with the use of a variable for separator |
| 41584 | 2008-12-18 10:20 | 2018-09-09 20:45 | MySQL Server: Options | Verified (5985 days) | S3 | Ver 5.1.31-debug | Linux (suse-linux on x86_64) | Any | Inconsistent behaviour when comparing system variable "timestamp". |
| 43219 | 2009-02-26 9:49 | 2020-12-23 7:46 | MySQL Server: Optimizer | Verified (5915 days) | S3 | 5.0.70, 4.1, 5.0, 5.1, 6.0 bzr | Linux (Gentoo) | Any | delete does not use index when using OR in where clause |
| 43523 | 2009-03-10 2:01 | 2011-02-16 23:43 | MySQL Server: Options | Verified (5903 days) | S3 | 5.0.51, 5.1.32 | Linux (Possibly more) | Any | Open_files status variable does not report all opened file descriptors by the OS |
| 43531 | 2009-03-10 11:24 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (5721 days) | S3 | 5.1, 6.0.11-bzr | Linux | Any | Crash if Falcon or MyISAM, subqueries, 4 clients |
| 43555 | 2009-03-11 9:42 | 2013-03-03 20:45 | MySQL Server: MyISAM storage engine | Verified (5902 days) | S3 | 4.0.27, 5.0.67, 5.0.80-bzr, 5.1 | Linux | Any | mysqlcheck exits 0 althought corruption found |
| 43766 | 2009-03-20 10:19 | 2022-12-04 20:45 | MySQL Server: Locking | Verified (5893 days) | S3 | 5.1.25, 5.1.31, 4.1, 5.0, 5.1, 6.0 bzr | Linux | Any | unnecessary locking on update even with tx_isolation=READ-COMMITTED or |
| 43830 | 2009-03-24 12:06 | 2022-12-04 20:45 | MySQL Server: Security: Privileges | Verified (5886 days) | S3 | 5.1.32, 5.0, 5.1, 6.0 bzr | Linux | Any | CREATE PROCEDURE causes ERROR 1410 unless ALTER ROUTINE is granted |
| 43889 | 2009-03-26 16:07 | 2011-02-16 23:43 | MySQL Server: General | Verified (5887 days) | S5 | 5.1 | Linux | Any | closing half-read resultset causes is O(n) instead of O(1) |
| 44138 | 2009-04-07 22:48 | 2016-06-09 7:33 | MySQL Server: Memory storage engine | Verified (4178 days) | S2 | 5.1.57, 5.6.14, 5.6.30 | Linux (x86_64 rhel5 version from download page) | Any | Memory engine table full at much less than max_heap_table_size with btree index |
| 44445 | 2009-04-23 19:24 | 2020-05-03 20:45 | MySQL Server: Optimizer | Verified (5741 days) | S3 | 5.1.31-log, 5.0, 5.1, azalea bzr | Linux | Any | Problem using index when selecting all columns |
| 44681 | 2009-05-06 1:27 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (5796 days) | S2 | 5.0.82, 5.0, 5.1 bzr | Linux (Any) | Any | 2 command trigger causes error 1340 .Configuration file ...is too big |
| 45424 | 2009-06-10 6:58 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5811 days) | S2 | 5.0.51a, 5.0.77 and 5.1.34, 5.1, 6.0 bzr | Linux | Any | UPDATE statement cause full table scan ? |
| 45620 | 2009-06-19 15:53 | 2011-02-16 23:44 | MySQL Server: User-defined functions ( UDF ) | Verified (5797 days) | S3 | 5.1, 5.4.0-beta | Linux | Any | Server process restart after calling functions from ha_innodb |
| 45741 | 2009-06-25 10:46 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5792 days) | S1 | 5.0.83, 5.0, 5.1, 5.5.8 | Linux | Any | Memory of server increases abnormally for sql with mass <> condition |
| 45776 | 2009-06-26 7:17 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5795 days) | S5 | mysql-5.1.35 | Linux | Any | "OR" condition on SPATIAL index not optimized |
| 46096 | 2009-07-09 17:26 | 2022-12-04 20:45 | MySQL Server: General | Verified (5782 days) | S3 | 5.1, 5.4 | Linux | Any | SHOW CREATE TRIGGER does not respect lower_case_table_names |
| 46609 | 2009-08-07 17:19 | 2011-02-16 23:44 | MySQL Server: General | Verified (5753 days) | S3 | 5.1.38-debug, 4.1, 5.0, 5.1, azalea | Linux (SUSE 11.1 64-bit) | Any | Short display width when extracting microseconds |
| 46648 | 2009-08-11 11:41 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5743 days) | S3 | 5.1.32, 4.1, 5.0, 5.1, azalea bzr | Linux (2.6.28.7) | Any | SQL_CALC_FOUND_ROWS kills performance with ORDER BY and LIMIT |
| 46653 | 2009-08-11 14:50 | 2011-05-12 10:15 | MySQL Server: Command-line Clients | Verified (5110 days) | S3 | 5.1 | Linux | Any | mysqlhotcopy fails if db/table name contains '.' |
| 46858 | 2009-08-21 14:29 | 2011-02-16 23:44 | MySQL Server: Storage Engine API | Verified (5722 days) | S2 | 5.1, azalea | Linux | Any | Not using "thr_lock_data_init" in the plugin let the serve crash. |
| 47330 | 2009-09-15 15:39 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5706 days) | S5 | 5.0.77, 5.1.34, 5.1.37 | Linux (Debian x64) | Any | Slow query with left join and having. |
| 47434 | 2009-09-18 10:18 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5706 days) | S3 | 5.0.51a-24+lenny1-log, 5.1.38 | Linux | Any | Ambigous field name in group by clause does not cause an error |
| 47436 | 2009-09-18 10:27 | 2011-11-02 9:21 | MySQL Server: InnoDB storage engine | Verified (4936 days) | S2 | 5.1.38 | Linux | Any | Transaction isolation level SERIALIZABLE becomes REPEATABLE-READ in autocommit |
| 47834 | 2009-10-05 13:01 | 2011-02-16 23:44 | MySQL Server: General | Verified | S3 | 5.1.39 | Linux | Any | init.d script should fail when it has no permission to read PID |
| 47884 | 2009-10-07 3:24 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5578 days) | S2 | 5.1.39, 5.1.44, 5.5.99 | Linux (Linux web2 2.6.18-92.1.18.el5.028stab060.8 #1 SMP Mon Feb 9 21:44:50 MSK 2009 x86_64) | Any | MySQL 5.1.39 failed to use index |
| 47961 | 2009-10-09 21:51 | 2011-02-16 23:44 | MySQL Server: Information schema | Verified (5690 days) | S3 | 5.1.39-community,5.5+ | Linux (only tested on CentOS 5.3) | Any | metadata leak from information_schema.routines via privs on mysql.proc table |
| 48062 | 2009-10-14 23:09 | 2017-05-21 20:45 | MySQL Server: Replication | Verified (5684 days) | S2 | 5.0.85, 5.1.41 | Linux | Any | Date artithmetic in stored procedure breaks replication |
| 48281 | 2009-10-24 14:08 | 2023-02-12 20:45 | MySQL Server: Command-line Clients | Verified (5675 days) | S3 | 5.1 | Linux (x86 Ubuntu Jaunty) | Any | mysqlbinlog prints warning about unfreed memory |
| 48326 | 2009-10-26 18:03 | 2014-02-09 20:42 | MySQL Server: General | Verified (5644 days) | S2 | 5.0.75, 5.1 bzr | Linux (5.0.75-0ubuntu10.2-log) | Any | current_timestamp and now() don't produce the same value for a given statement |
| 48392 | 2009-10-28 21:03 | 2011-02-16 23:44 | MySQL Server: Command-line Clients | Verified (5653 days) | S3 | 5.0.86, 5.1.42 | Linux | Any | mysql_upgrade improperly escapes passwords with single quotes |
| 49276 | 2009-12-01 17:03 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5637 days) | S5 | 5.0.85-community-log, 5.0.89, 5.1.42 | Linux | Any | Optimization for IN (on InnoDB tables) depends on number of set elements |
| 50378 | 2010-01-15 17:34 | 2022-12-04 20:45 | MySQL Server: Options | Verified (5589 days) | S2 | 5.0.77, 5.0, 5.1 bzr | Linux (RHEL 5.4) | Any | Uptime_since_flush_status has an abnormally large value |
| 50523 | 2010-01-21 20:35 | 2011-02-16 23:44 | MySQL Server: General | Verified (5585 days) | S3 | 5.1.44-bzr | Linux (64) | Any | BENCHMARK(1000,(SELECT...)) runs SELECT only once |
| 50954 | 2010-02-05 19:46 | 2022-12-04 20:45 | MySQL Server: Logging | Verified (5570 days) | S3 | MySQL 5.1.32, 5.1, 5.5.99 | Linux (Red Hat 4.1.2-44) | Any | start_time in slow query log is recording the query end time, not start time |
| 51006 | 2010-02-08 19:30 | 2022-12-04 20:45 | MySQL Server: Stored Routines | Verified (5567 days) | S3 | 5.1.42, 5.0, 5.1, 5.5.99 | Linux | Any | InnoDB does not correctly rollback statement on error inside stored function |
| 52170 | 2010-03-18 9:57 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5526 days) | S5 | 5.1.44, mysql-next-mt | Linux (fc12) | Any | innodb query optimizer fails (null possible_keys) with multicolumn key |
| 52563 | 2010-04-02 21:43 | 2023-02-12 20:45 | MySQL Server: Replication | Verified (5514 days) | S2 | 5.1.44, 5.1 bzr, 5.6.99 | Linux | Any | Replication failure when using xpath variable inside a stored procedure |
| 52644 | 2010-04-07 4:30 | 2014-12-03 8:02 | MySQL Server: General | Verified (5250 days) | S3 | 5.1.40, 5.0 | Linux (Redhat 4 x64) | Any | mysql_install_db: 'Unknown database mysql' with non-default tmpdir |
| 52901 | 2010-04-16 19:49 | 2011-03-21 19:40 | MySQL Server: General | Verified (5493 days) | S3 | 5.1.45-1 (Debian) | Linux | Any | Key_blocks_unused counter incorrect |
| 53272 | 2010-04-28 22:12 | 2011-02-16 23:44 | MySQL Server: Command-line Clients | Verified | S3 | 5.1.40sp1 | Linux | Any | REPAIR of large table causes mysql client to grow rapidly in memory |
| 53556 | 2010-05-11 9:09 | 2011-02-16 23:44 | MySQL Server: Command-line Clients | Verified (5470 days) | S3 | 5.1 | Linux ( 2.6.27.45-0.1-default #1 SMP 2010-02-22 x86_64 x86_64 x86_64 GNU/Linux) | Any | mysqlhotcopy: noindices doesn't work as described. |
| 53748 | 2010-05-18 12:30 | 2014-12-31 13:27 | MySQL Server: MyISAM storage engine | Verified (5460 days) | S3 | 5.1.46 | Linux (Fedora 12) | Any | INDEX/DATA DIRECTORY realpath(3) race allows access to server data dir |
| 54207 | 2010-06-03 15:05 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5447 days) | S2 | 5.1.40, 5.1.48, all | Linux (5u4) | Any | why mysql cann't using index to filter column after range condition ; |
| 54371 | 2010-06-09 15:32 | 2022-12-04 20:45 | MySQL Server: Security: Privileges | Verified (5446 days) | S3 | 5.1.44, 5.1.49-bzr | Linux | Any | Privileges required to use --events option for mysqldump |
| 54434 | 2010-06-11 15:55 | 2016-08-24 15:30 | MySQL Server: Federated storage engine | Verified (5445 days) | S2 | 5.1.47 | Linux (CentOS 5.5) | Any | LEFT JOIN on federated view always results in NULL |
| 54450 | 2010-06-12 3:42 | 2011-02-16 23:44 | MySQL Server: General | Verified (5435 days) | S3 | 5.1.47, 5.1.48, 5.1, 5.6.99 bzr | Linux ( 2.6.18-6-amd64 ) | Any | mysql_intall_db crash with debug option |
| 55301 | 2010-07-15 19:08 | 2011-02-16 23:44 | MySQL Server: General | Verified (5411 days) | S3 | 5.1.48 | Linux | Any | documentation bug |
| 55557 | 2010-07-26 13:21 | 2011-02-16 23:44 | MySQL Server: Command-line Clients | Verified (5400 days) | S2 | 5.1.49, 5.1.50-bzr | Linux (all) | Any | can not import functions and procedures with comment "/* Procedure" |
| 55733 | 2010-08-04 8:47 | 2012-05-18 20:19 | MySQL Server: Replication | Verified (5188 days) | S5 | 5.1.37 | Linux (CentOS 5.3) | Any | replication I/O slave is replicating statements that should be ignored |
| 55979 | 2010-08-13 22:05 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5379 days) | S5 | 5.1.39 | Linux | Any | Key not used if IN() list contains mix of strings and integers |
| 56010 | 2010-08-16 12:20 | 2011-02-16 23:44 | MySQL Server: General | Verified (5361 days) | S3 | 5.1.49, 4.1, 5.0, 5.1, 5.6.99 | Linux (Debian Lenny) | Any | Spaces cause mysqld_safe not to start,my_print_defaults generated invalid output |
| 56264 | 2010-08-25 17:41 | 2011-02-16 23:44 | MySQL Server: Options | Verified (5369 days) | S3 | 5.1.47, 5.1.51-bzr | Linux | Any | Command-line options are case-sensitive but don't throw errors |
| 56441 | 2010-09-01 9:22 | 2011-02-16 23:44 | MySQL Server: General | Verified (5351 days) | S2 | 5.0-bzr, 5.1-bzr | Linux | Any | mysql_upgrade 5.0->5.1 fails for tables with long names |
| 56764 | 2010-09-14 7:42 | 2022-12-04 20:45 | MySQL Server: Locking | Verified (5348 days) | S2 | 5.0.91, 5.1.39, 5.1.50, 5.5.7 | Linux | Any | if clause causes unnecessary locking |
| 56902 | 2010-09-21 16:43 | 2013-03-03 20:45 | MySQL Server: MyISAM storage engine | Verified (5343 days) | S1 | mysql-5.1.50.tar | Linux (Linux 2.6.18-164.el5xen Red Hat) | Any | Reproducible/systematic core by myisampack (latest 5.1.50 version) |
| 57049 | 2010-09-28 2:59 | 2011-02-16 23:44 | MySQL Server: General | Verified (5336 days) | S3 | 5.1.50, 5.1, 5.6.99 bzr | Linux | Any | mysqldump unhappy with /var/lib/mysql directories with leading dot |
| 57643 | 2010-10-22 2:47 | 2022-12-04 20:45 | MySQL Server: DML | Verified (4891 days) | S3 | 5.1.41, 5.1.50, 5.5.20 | Linux | Any | InnoDB skips auto_increment values with LOAD DATA INFILE |
| 57690 | 2010-10-24 10:47 | 2022-12-04 20:45 | MySQL Server: Logging | Verified (5284 days) | S3 | 5.1.50 | Linux | Any | impossible to redirect log-error to STDOUT in 5.1 |
| 58089 | 2010-11-09 18:40 | 2018-09-09 20:45 | MySQL Server: Views | Verified (5283 days) | S3 | 5.1.49-2-log, 5.0, 5.1, 5.6.99 | Linux (Debian) | Any | CREATE VIEW refuses WITH CHECK OPTION for updatable view |
| 58101 | 2010-11-10 0:21 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5292 days) | S5 | 5.1.38-community-log, 5.1.54-bzr | Linux | Any | Optimizer picks wrong order of queries |
| 58924 | 2010-12-14 18:38 | 2018-09-09 20:45 | MySQL Server: Optimizer | Verified (5258 days) | S3 | 5.1.44, 5.0, 5.1, 5.6.1 | Linux | Any | a LIMIT after a UNION doesn't propogate to all queries |
| 59359 | 2011-01-07 18:07 | 2013-03-03 20:45 | MySQL Server: Information schema | Verified (5235 days) | S3 | 5.1.41, 5.5.9 | Linux | Any | Packed Status Always NULL |
| 59550 | 2011-01-17 12:57 | 2020-06-23 6:10 | MySQL Server: InnoDB storage engine | Verified (4908 days) | S3 | 5.1.48, 5.1.60, 5.5.18 | Linux (Red Hat Enterprise Linux Server release 5.4 (Tikanga)) | Any | "Innodb_buffer_pool_pages_misc" goes wrong |
| 59847 | 2011-01-31 14:32 | 2014-09-22 20:50 | MySQL Server: Logging | Verified (5158 days) | S3 | 5.1.49-enterprise-gpl-pro-log | Linux (2.6.18-238.1.1.el5) | Any | Error closing the general/query logfile, if file is a named pipe/socket/fifo |
| 60185 | 2011-02-20 15:58 | 2011-03-03 8:35 | MySQL Server: Optimizer | Verified (5191 days) | S3 | 5.0.51, 5.5.11 | Linux | Any | index DEPENDENT SUBQUERY |
| 61058 | 2011-05-04 15:53 | 2013-12-09 10:18 | MySQL Server: InnoDB storage engine | Verified (5118 days) | S2 | 5.1.37/5.5/5.6/5.7 | Linux | Any | Autoincrement exceed expected value after INSERT INTO ... SELECT |
| 61130 | 2011-05-11 4:32 | 2012-01-17 20:01 | MySQL Server: Options | Verified (4860 days) | S3 | 5.0.77, 5.0.95, 5.1.62, 5.5.21, 5.6.5 | Linux (CenOS 5.5) | Any | Key_blocks_not_flushed values is not correct! |
| 61645 | 2011-06-26 8:16 | 2011-06-28 7:31 | MySQL Server: DML | Verified (5063 days) | S2 | 5.5.13, 5.5.15 | Linux | Any | external locking corrupted temporary table after alter |
| 61936 | 2011-07-21 6:27 | 2011-07-31 15:28 | MySQL Server: Optimizer | Verified (5039 days) | S2 | 5.1.48, 5.5.13, 5.5.16 | Linux (x86_64) | Any | STRAIGHT_JOIN has no effect on query with subquery in FROM clause |
| 62256 | 2011-08-24 21:52 | 2011-08-25 16:03 | MySQL Server: Security: Privileges | Verified (5005 days) | S3 | >= 5.1.53 | Linux | Any | mysql_upgrade should convert Host values in mysql.user to lower case |
| 62435 | 2011-09-14 17:39 | 2011-09-21 9:35 | MySQL Server: Stored Routines | Verified (4983 days) | S2 | 5.1.49, 5.1.60 | Linux (Debian) | Any | not declaring variables returns a byte array instead of a varchar in .Net app |
| 62535 | 2011-09-25 14:46 | 2017-05-14 20:45 | MySQL Server: InnoDB storage engine | Verified (4908 days) | S3 | 5.5, 5.1, etc | Linux | Any | os_event_create() has inefficient memory allocation |
| 62548 | 2011-09-27 10:22 | 2015-05-16 14:26 | MySQL Server: Memory storage engine | Verified (4972 days) | S2 | 5.1.49, 5.1.58 | Linux (Ubuntu) | Any | Different result from memory and myisam table |
| 62559 | 2011-09-28 8:23 | 2014-02-18 15:04 | MySQL Server: Command-line Clients | Verified (4971 days) | S2 | 5.5.15, 5.5.17 | Linux (SUSE Linux Enterprise Server 11 (x86_64)) | Any | mysqld_multi doesn't check pid-file |
| 62752 | 2011-10-15 17:32 | 2014-07-31 13:29 | MySQL Server: Options | Verified (4925 days) | S3 | 5.5.16, 5.1.60 | Linux (CentOS 5.7 x86_64) | Any | mysqld --verbose --help ends with error |
| 62949 | 2011-10-26 18:36 | 2011-11-03 12:17 | MySQL Server: DML | Verified (4942 days) | S2 | 5.5.17 | Linux (CentOS 5.7) | Any | Multiple DELETE permission bug |
| 63868 | 2011-12-28 19:34 | 2011-12-30 15:41 | MySQL Server: Optimizer | Verified (4879 days) | S3 | 5.1.60, 5.5.20 | Linux (Centos 5 x64) | Any | Left outer join with user defined function on NULL column gives wrong results |
| 63926 | 2012-01-04 23:22 | 2012-01-11 20:03 | MySQL Server: Security: Privileges | Verified (4866 days) | S2 | 5.1.59, 5.5.21 | Linux (CentOS 5.x 64bit) | Any | Bug 61222 still exists in 5.1.59 (bad handshake due to old passwords change) |
| 64316 | 2012-02-14 12:04 | 2012-02-14 15:50 | MySQL Server: Optimizer | Verified (4832 days) | S2 | 5.1.49-3\5.5.21 | Linux (Debian) | Any | search with decimal value on INT field with index gives wrong result with LIMIT |
| 64361 | 2012-02-17 11:12 | 2012-02-20 10:18 | MySQL Server: Information schema | Verified (4829 days) | S3 | 5.5.18-log, 5.5.20 | Linux (x86_64 debian5.0 ) | Any | SHOW TABLES FROM ... increments Select_scan Status |
| 64391 | 2012-02-21 7:42 | 2014-09-26 18:30 | MySQL Server: Federated storage engine | Verified (4818 days) | S2 | 5.1.59, 5.5.23, 5.6.5, 5.0.96 | Linux (open suse 11.2) | Any | Select from federated table with order by clause returns no rows |
| 64522 | 2012-03-02 11:28 | 2016-03-22 14:49 | MySQL Server: Command-line Clients | Verified (4811 days) | S3 | 5.1.61, 5.5.21, 5.6.5 | Linux (RHEL 6.2 64 bit) | Any | Effective UID issue |
| 64703 | 2012-03-20 11:31 | 2012-03-20 14:38 | MySQL Server: Command-line Clients | Verified (4797 days) | S3 | 5.1.61 | Linux | Any | Providing socket as an option does not override host and port in my.cnf |
| 64800 | 2012-03-29 14:44 | 2012-03-31 10:12 | MySQL Server: Replication | Verified (4786 days) | S3 | server: 5.5.15, mysqldump: 10.13, 5.6.6 | Linux | Any | mysqldump with --include-master-host-port putting quotes around port number |
| 66363 | 2012-08-13 21:33 | 2013-03-13 22:32 | MySQL Server: Replication | Verified (4439 days) | S2 | 5.1.58, 5.1.67 | Linux (rhel 6.1) | Any | Large transaction writing rbr with sync_binlog hangs entire server on fsync |
| 66720 | 2012-09-06 8:03 | 2012-09-09 16:24 | MySQL Server: DML | Verified (4627 days) | S3 | 5.5.24-0ubuntu0.12.04.1, 5.5.29, 5.0.95, 5.1.66, 5.7.0 | Linux (Ubuntu 12.04) | Any | Regexp problem |
| 66794 | 2012-09-13 2:39 | 2012-09-13 14:53 | MySQL Server: DML | Verified (4620 days) | S3 | 5.1.63/5.5.29 | Linux (Ubuntu 32bit) | Any | Column metadata inconsistent when used against a View |
| 66849 | 2012-09-17 18:49 | 2013-06-10 19:50 | MySQL Server: Optimizer | Verified (4350 days) | S1 | 5.5.16, 5.1.70, 5.5.32, 5.6.12 | Linux | Any | [REGRESSION] this query hangs the server (100% CPU for several minutes) |
| 66884 | 2012-09-20 3:16 | 2017-01-09 18:04 | MySQL Server: Options | Verified (4482 days) | S3 | 5.5, 5.0.97, 5.1.69, 5.5.31, 5.7.1 | Linux (I only test it on ubuntu 11.10) | Any | SERVER_STATUS is always inited with SERVER_STATUS_AUTOCOMMIT=1 |
| 67924 | 2012-12-17 15:01 | 2012-12-17 18:40 | MySQL Server: Locking | Verified (4525 days) | S2 | 5.1.59, 5.5.24 | Linux | Any | Row lock isn't released after evaluating WHERE condition in READ COMMITTED |
| 68203 | 2013-01-28 9:39 | 2013-01-30 17:26 | MySQL Server: Replication | Verified (4481 days) | S3 | 5.1.54, 5.0.97, 5.1.69, 5.5.31, 5.7.1 | Linux | Any | slave does not retry connect |
| 68339 | 2013-02-11 17:09 | 2013-02-11 20:06 | MySQL Server: DML | Verified (4469 days) | S3 | 5.1, 5.5, 5.6 | Linux | Any | ENCRYPT() with empty string for password doesn't work as system crypt() |
| 68650 | 2013-03-12 13:19 | 2013-04-12 19:15 | MySQL Server: Command-line Clients | Verified (4409 days) | S3 | 5.5.30, 5.1.70, 5.5.32, 5.6.12, 5.7.2 | Linux | Any | Dump restoration does not create events |
| 68676 | 2013-03-14 21:25 | 2021-08-10 16:42 | MySQL Server: Parser | Verified (4433 days) | S3 | 5.5.30, 5.0.97, 5.1.70, 5.5.32, 5.6.12, 5.7.2 | Linux | Any | Escaping backslash in identifier name |
| 68832 | 2013-04-02 11:04 | 2013-04-26 13:59 | MySQL Server: Parser | Verified (4395 days) | S2 | 5.1.70 | Linux (RHEL6) | Any | Daylight Saving time and interval |
| 69090 | 2013-04-29 4:53 | 2013-04-29 8:01 | MySQL Server: Information schema | Verified (4392 days) | S2 | 5.1.69-0ubuntu0.10.04.1 | Linux (Ubuntu 10.04) | Any | Trigger bodies containing the "\" character are returned unescaped |
| 69100 | 2013-04-30 9:53 | 2015-03-15 20:45 | MySQL Server: InnoDB storage engine | Verified (4385 days) | S1 | 5.5.31-0, 5.5.30-1, 5.5.29-0, 5.5.25-1, 5.5.16, 5.5.30-1.1, 5.6.10, 5.0.97, 5.1.70, 5.5.29, 5.7.2 | Linux (Debian 6 / Debian 7 / Ubuntu 12.10 / Windows 8) | Any | CAST in IF function fails in some case |
| 69491 | 2013-06-17 12:16 | 2013-06-18 7:01 | MySQL Server: Replication | Verified (4342 days) | S2 | 5.1 and 5.5 | Linux (debian) | Any | Breaking replication with update on fulltext |
| 69926 | 2013-08-05 10:40 | 2022-06-27 18:23 | MySQL Server: MyISAM storage engine | Verified (1981 days) | S1 | 5.1 , 5.5, 5.6, 5.6.46 | Linux | Any | MySQL crash on disk full with mysqld got signal 11 |
| 70626 | 2013-10-15 22:08 | 2017-07-17 13:18 | MySQL Server: Optimizer | Verified (4222 days) | S3 | 5.1+ | Linux (Ubuntu 12.04) | Any | select * from t where exists (select * from t limit 0); returns rows |
| 70692 | 2013-10-23 3:46 | 2023-05-01 15:48 | MySQL Server: DML | Verified (4215 days) | S2 | 5.6.12,5.6.14,5.5.34,5.1.72 | Linux | Any | auto_increment wrong value when using insert into... select from |
| 71035 | 2013-11-28 15:53 | 2014-10-30 8:47 | MySQL Server: Row Based Replication ( RBR ) | Verified (4177 days) | S2 | mysqlbinlog Ver 3.4, 5.1.74, 5.5.35, 5.6.16 | Linux (CentOS release 6.4 2.6.32-358.23.2.el6.x86_64) | Any | mysqlbinlog dumps out improperly-formatted TIMESTAMP values |
| 71206 | 2013-12-22 17:13 | 2013-12-31 20:00 | MySQL Server: Optimizer | Verified (4154 days) | S1 | 5.5.32-0ubuntu0.12.04.1-log, 5.6.15, 5.1.72, 5.5.35, 5.7.3 | Linux (ubuntu 12.04) | Any | GROUP_CONCAT changes GROUP BY behavior |
| 72170 | 2014-03-31 13:59 | 2014-03-31 14:31 | MySQL Server: DDL | Verified (4056 days) | S3 | 5.6.17 (actually anything >= 5.1?) | Linux | Any | Table name lenght limit is 50 chars, not 64, when using "high" unicode |
| 72509 | 2014-05-01 22:18 | 2014-05-05 14:20 | MySQL Server: Command-line Clients | Verified (4021 days) | S2 | 5.5.37, 5.1.73 | Linux | Any | mysql_ping spins when mysqld is stopped via SIGSTOP |
| 72598 | 2014-05-09 21:54 | 2014-06-18 6:06 | MySQL Server: Logging | Verified (3978 days) | S3 | 5.1, 5.5 | Linux (syslog-capable) | Any | FLUSH LOGS fails with error 1105 if both syslog and log-error are enabled |
| 74105 | 2014-09-26 12:16 | 2014-09-26 12:55 | MySQL Server: Optimizer | Verified (3877 days) | S3 | 5.5.38-0ubuntu0.14.04.1, 5.5.41, 5.1.74 | Linux | Any | Qualified comparisons return true when subquery contains nulls |
| 74433 | 2014-10-17 23:32 | 2014-10-21 9:25 | MySQL Server: Replication | Verified (3852 days) | S2 | MySQL 5.6 and 5.5, 5.1.73, 5.6.22 | Linux | Any | Slave 5.5/5.6 crash while using MRG table,auto_increment,inner join and triggers |
| 75700 | 2015-01-30 12:40 | 2015-01-30 17:32 | MySQL Server: Parser | Verified (3751 days) | S3 | mysql Ver 14.14 Distrib 5.1.73 | Linux (Centos 2.6.32-358.el6.x86_64) | Any | Cannot create MySQL database with name '5e370227_db' |
| 76478 | 2015-03-25 7:46 | 2015-03-26 2:59 | MySQL Server: DML | Verified (3696 days) | S3 | 5.6.22, 5.6.25, 5.5.44, 5.1.73 | Linux | Any | mod functions works incorrectly with arithmetic express |
| 77538 | 2015-06-29 11:06 | 2015-06-29 11:35 | MySQL Server: MyISAM storage engine | Verified (3601 days) | S2 | 5.1/5.5/5.6/5.7 | Linux | Any | MyISAM accepts table definition that is no longer considered as correct |
| 78149 | 2015-08-20 11:02 | 2015-08-21 6:25 | MySQL Server: DML | Verified (3549 days) | S3 | 5.0/5.1/5.5/5.6/5.7 | Ubuntu | Any | TIMESTAMPDIFF vs TIMESTAMPADD and DATE_ADD : count months in different way |
| Showing all 172 (Edit, Save, CSV, Feed) |
