The world's most popular open source database
The following problems are known and fixing them is a high priority:
C API
Bug#40552: Race condition around default_directories in load_defaults()
Target fix: 5.1
Client
Bug#34861: mysqldump with --tab gives weird output for triggers.
Target fix: 5.1
Bug#31434: mysqldump dumps view as table
Already fixed in: 5.1.29
Bug#40395: mysqladmin -i delay extended-status does not iterate with -r
Target fix: 5.1
Bug#35934: mysql_upgrade calls mysqlcheck with insufficient parameters
Target fix: 5.1
Bug#39852: bug in mysql_setpermission
Target fix: 5.1
Bug#39559: dump of stored procedures / functions with C-style comment can't be read back
Bug#34129: mysqldumpslow does not aggregate times
Target fix: 5.1
Bug#37748: mysqldump shows misleading error messages when backingup mysql database
Target fix: 5.1
Server
Bug#40358: HA_KEY_HAS_PART_KEY_SEG does not
properly get passed to storage engine
Target fix: 5.1
Bug#35068: Assertion fails when reading from i_s.tables and there is incorrect merge table
Target fix: 5.1
Bug#34367: sql/sql_show.cc: create_schema_table should handle
MYSQL_TYPE_NEWDECIMAL
Target fix: 5.1
Bug#36829: Decimal to double conversion is inaccurate
Target fix: 5.1
Bug#38701: Crash in String::append when inserting duplicate empty
strings an uft8 SET col
Already fixed in: 5.1.29
Bug#38338: REPLACE causes last_insert_id() to
return an incorrect value
Target fix: 5.1
Bug#22891: session level max_allowed_packet can be set but is ignored
Target fix: 5.1
Bug#38823: Invalid memory access when a SP
statement does wildcard expansion
Already fixed in: 5.1
Bug#40536: SELECT is blocked by INSERT
DELAYED waiting on upgrading lock, even with low_pri
Target fix: 5.1
Bug#38883: thd_security_context is not thread safe, crashes?
Target fix: 5.1
Bug#31616: div_precision_increment description looks wrong
Target fix: 5.1
Bug#38821: Assert table->auto_increment_field_not_null failed in open_table()
Already fixed in: 5.1.29
Bug#38691: segfault/abort in ``UPDATE
...JOIN'' while ``FLUSH TABLES WITH
READ LOCK''
Already fixed in: 5.1.29
Bug#38360: BLACKHOLE replication with
RBR is broken
Already fixed in: 5.1.29
Bug#38941: fast mutexes in MySQL 5.1 have mutex contention when calling random()
Target fix: 5.1
Bug#37958: test main.plugin crash on Mac OS X
when selecting from EXAMPLE engine.
Already fixed in: 5.1.29
Server: Archive
Server: Charsets
Bug#40053: 'check table .. for upgrade' doesn't detect collation change made in 5.1.24-rc
Target fix: 5.1.30
Bug#20447: Problem with prefix keys with contractions and expansions
Target fix: 5.1
Bug#39585: innodb and myisam corruption after binary upgrade from <=5.0.46 to >=5.0.48
Already fixed in: 5.1.29
Bug#35720: ucs2 + pad_char_to_full_length = failure
Already fixed in: 5.1
Bug#37046: Character sets: failure or hang with sharp s
Target fix: 5.1
Server: Cluster
Bug#39899: No x86-64 version (tgz download) available for 6.3.17
Target fix: 5.1
Server: Compiling
Bug#39996: 5.1 fails to compile on Windows 32-bit with VS2005
Target fix: 5.1
Bug#38364: gen_lex_hash segmentation fault in debug build
Target fix: 5.1
Bug#39102: valgrind build does not compile in realpath, which make
DATA/INDEX DIR fail
Target fix: 5.1
Bug#39802: On Windows, 32-bit time_t should be enforced
Target fix: 5.1
Bug#39279: mysqld Linux-ia64 binary depends on two versions of libunwind
Target fix: 5.1
Bug#25404: mysql_config need several issues corrected
Target fix: 5.1
Bug#35743: Dynamic plugins fail to load on
i5/OS
Already fixed in: 5.1.29
Bug#39709: status variable 'Uptime_since_flush_status' missing
Target fix: 5.1
Bug#39451: Debug builds broken with Sun Studio compiler
Already fixed in: 5.1
Bug#39571: abi_check: Does not create all prerequisites
Target fix: 5.1
Server: Config Wizard
Server: DDL
Bug#23113: Different behavior on altering ENUM
fields between 5.0 and 5.1
Target fix: 5.1.30
Bug#37016: TRUNCATE TABLE removes some rows but
not all
Target fix: 5.1.31
Bug#39793: Foreign keys not constructed when column has a '#' in a comment or default value
Target fix: 5.1
Bug#39372: "Smart" ALTER TABLE not so smart
after all.
Target fix: 5.1
Bug#35796: SHOW CREATE TABLE and default value
for BIT field
Target fix: 5.1
Bug#30102: rename table does corrupt tables with partition files on failure
Target fix: 5.1
Bug#39200: optimize table does not recognize
ROW_FORMAT=COMPRESSED
Target fix: 5.1
Bug#33650: mysql_alter_table() unnecessarily does full table copy
Target fix: 5.1
Server: DML
Bug#40127: Multiple table DELETE IGNORE hangs
on foreign key constraint violation on 5.0
Target fix: 5.1
Bug#38693: leaked memory with blobs!
Target fix: 5.1
Bug#39920: MySQL cannot deal with Leap Second expression in string literal.
Target fix: 5.0.74
Bug#39002: crash with insert .. select * from ... on duplicate key update col=default
Already fixed in: 5.1.29
Bug#40384: Gap in auto_increment sequence when inserts fire a trigger
Target fix: 5.1
Bug#33717: INSERT...(default) fails for enum.
Crashes CSV tables, loads spaces for MyISAM
Target fix: 5.1
Bug#33844: Server crashes when client dies during LOAD
DATA INFILE
Target fix: 5.1
Bug#24678: can't use SQL_BUFFER_RESULT on union
all
Target fix: 5.1
Bug#36091: Fix for Bug#31781 is broken in 5.1/6.0
Target fix: 5.1
Bug#33066: last_insert_id(), wrong values, InnoDB, insert on duplicate key update
Target fix: 5.1
Server: FTS
Server: GIS
Bug#31435: ha_innodb.cc:3983: ulint convert_search_mode_to_innobase(ha_rkey_function): Asse
Target fix: 5.1
Server: General
Bug#37284: Crash in Field_string::type()
Target fix: 5.1
Bug#40610: Date and time functions like
DATE_SUB(), DATE_ADD() are
not leap second enabled.
Target fix: 5.0.74
Bug#30261: "mysqld --help" no longer possible for root
Target fix: 5.1
Bug#40329: TIMESTAMPADD does not take in to
account Daylight Savings Time.
Target fix: 5.1
Bug#40657: assertion with out of range variables and traditional sql_mode
Target fix: 5.1
Bug#39178: Server crash in YaSSL with
non-RSA-requesting client if server uses
RSA key
Target fix: 5.1
Bug#38477: my_pthread_setprio can change dispatch class on Solaris, not just priority
Target fix: 5.1
Bug#39021: SELECT REGEXP BINARY NULL never
returns
Already fixed in: 5.1.29
Bug#34043: Server loops excessively in _checkchunk() when safemalloc is enabled
Target fix: 5.1
Server: I_S
Bug#38918: selecting from information_schema.columns is disproportionately slow
Target fix: 5.1
Bug#39955: SELECT on
INFORMATION_SCHEMA.GLOBAL_VARIABLES
takes too long
Target fix: 5.1
Bug#35789: wrong datatypes for collation and charset columns in
EVENTS, ROUTINES,
TRIGGERS
Target fix: 5.1
Bug#38909: CREATE_OPTIONS in information_schema
produces wrong results
Target fix: 5.1
Bug#39541: CHECK TABLE on information_schema
myisam tables produces error
Target fix: 5.0.74
Server: InnoDB
Bug#27294: crash with innodb_locks_unsafe_for_binlog=1
Target fix: 4.1
Bug#38231: Innodb crash in lock_reset_all_on_table() on
TRUNCATE + LOCK /
UNLOCK
Target fix: 5.1
Bug#37885: row_search_for_mysql may gap lock unnecessarily with
SQL comments in query
Target fix: 5.1
Bug#40369: dtype_get_sql_null_size() returns 0 or 1, not the size
Target fix: 5.1
Bug#40360: Binlog related errors with binlog off
Target fix: 5.1.30
Bug#40386: Not flushing query cache after truncate
Target fix: 5.1.31
Bug#38839: auto increment does not work properly with InnoDB after update
Target fix: 5.1
Bug#35498: Cannot get table test/table1 auto-inccounter value in ::info
Target fix: 5.1
Bug#38741: main.innodb_mysql crashes randomly (2)
Target fix: 5.1
Server: Installing
Server: Locking
Bug#35077: Innodb deadlock on concurrent DDL
Target fix: 5.1
Bug#34306: Can't make copy of log tables when server binary log is enabled
Already fixed in: 5.1.29
Bug#39843: DELETE requires write access to
table in subquery in where clause
Target fix: 5.1
Bug#38804: Query deadlock causes all tables to be inaccessible.
Already fixed in: 5.1.29
Server: Logging
Server: Memory
Server: MyISAM
Bug#40321: ha_myisam::info could update rec_per_key incorrectly
Target fix: 5.1
Bug#37631: Incorrect key file for table after upgrading from 5.0 to 5.1
Target fix: 5.1
Bug#40634: table scan temporary table is 4x slower due to mmap instead instead of caching
Bug#35111: Truncate a MyISAM partitioned table does not reset the auto_increment value.
Target fix: 5.1
Bug#38848: myisam_use_mmap causes widespread myisam corruption on windows
Target fix: 5.1
Bug#38834: key_buffer_size irregularities on 64 bit windows
Target fix: 5.1
Bug#37756: enabling fulltext indexes with myisam_repair_threads > 1 causes crash
Target fix: 5.1
Server: Optimizer
Bug#36259: Optimizing with ORDER BY
Target fix: 5.1
Bug#34773: query with explain extended and derived table / other table crashes server
Target fix: 5.1.31
Bug#37908: 'show procedure/function status' referencing a table in a subquery crashes
Already fixed in: 5.1.29
Bug#25068: MyISAM-Optimizer prefers full table scan than index for
IN with >15 elements
Bug#37348: Crash in or immediately after
JOIN::make_sum_func_list
Already fixed in: 5.1.29
Bug#28554: Optimizer wrongly prefers index for (col = value) over
(PK <= value)
Target fix: 5.1
Bug#38842: Fix for 25951 seems incorrect
Target fix: 5.0.74
Bug#39298: Prefix key search returns wrong result for multi-level collations
Target fix: 5.1
Bug#38499: flush tables and multitable table update with derived table cause crash
Already fixed in: 5.1.29
Bug#31399: Wrong query result when doing join buffering over
BIT fields
Target fix: 5.1
Bug#37742: HA_EXTRA_KEYREAD flag is set when
key contains only prefix of requested column
Target fix: 5.1
Server: Packaging
Bug#37697: make_binary_distribution places files in wrong path
Target fix: 5.1
Bug#39641: mysql_config --plugindir links to /usr/local/mysql/lib/plugin in tar.gz packages
Target fix: 5.1
Bug#39074: Binaries do not work on Solaris 10 older than U5
Target fix: 5.1.30
Bug#39443: .pdb-files not delivered with 5.1.28
Target fix: 5.1
Bug#34025: mysql_config is not returning -ldl lib flag needed when using embedded server
Target fix: 5.1.31
Bug#34231: libmysqlclient contains libz in MySQL-devel-community-5.1.22-0.rhel3.i386.rpm
Target fix: 5.0.58
Server: Parser
Bug#25250: alter table allows simultaneous drop/add foreign keys
Target fix: 5.1
Server: Partition
Bug#40515: Query on a partitioned table does not return 'lock wait timeout exceeded'
Target fix: 5.1
Bug#40389: REORGANIZE PARTITION crashes when
only using one partition
Target fix: 5.1
Bug#33555: Group By Query does not correctly aggregate partitions
Already fixed in: 5.1.29
Bug#39084: Getting intermittent errors with statement-based binary logging
Target fix: 5.1
Bug#40494: MYSQL server crashes on range access
with partitioning and order by
Target fix: 5.1.30
Bug#37721: ORDER BY when
WHERE contains non-partitioned index column
Target fix: 5.1.31
Bug#38083: Error-causing row inserted into partitioned table despite error
Already fixed in: 5.1.29
Bug#39434: ALTER TABLE
CHECK/OPTIMIZE/ANALYZE
PARTITION work on non-partitioned table
Target fix: 5.1.31
Bug#38005: Partitions: error with insert select
Already fixed in: 5.1.29
Bug#37453: Dropping/creating index on partitioned table with InnoDB Plugin locks table
Target fix: 5.1
Bug#36312: InnoDB DATA_FREE BUG?
Target fix: 5.1
Bug#36008: Adding a partition after the maxvalue partition breaks table
Target fix: 5.1
Bug#40176: Combination of event, trigger and partitioning breaks auto increment
Target fix: 5.1.31
Server: Privileges
Server: Query Cache
Bug#38692: concurrent inserts cause valgrind errors in Query_cache::invalidate
Already fixed in: 5.1
Server: RBR
Bug#40278: Replication failure on RBR + MyISAM
+ SAVEPOINTs
Target fix: 5.1
Bug#40146: log_slave_updates uses MIXED mode
for binlog regardless of binlog_format
Target fix: 5.1
Bug#39648: Replication failure on RBR + Innodb
+ 2 bit fields + LIMIT + no
PK
Target fix: 5.1
Bug#40276: Assertion trx_data->empty() in binlog_close_connection
Target fix: 5.1
Bug#40222: Replication failure on RBR +
CREATE TABLE + transactions
Target fix: 5.1
Bug#40004: Replication failure with no PK + no
indexes
Target fix: 5.1.30
Bug#40186: Replication failure on RBR + Innodb
+ SET AUTOCOMMIT=OFF +
DROP TABLE
Target fix: 5.1
Bug#39753: Replication failure on MIXED + bit +
myisam + no PK
Target fix: 5.1
Bug#40188: Replication failure on RBR + Innodb
+ implicit commit + truncate/drop table
Target fix: 5.1
Bug#34707: Row based replication: slave creates table within wrong database
Already fixed in: 5.1.29
Bug#40258: Replication failure on Innodb + RBR
+ UPDATE + ORDER BY
Target fix: 5.1
Bug#39701: Mixed binlog format does not switch to row mode on
LOAD_FILE
Bug#36099: replicate-do-db affects replaying
RBR events with mysqlbinlog
Already fixed in: 5.1.29
Bug#38205: Row-based Replication (RBR) causes
inconsistencies: HA_ERR_FOUND_DUPP_KEY
Target fix: 5.1
Bug#40221: Replication failure on RBR +
UPDATE the primary key
Target fix: 5.1.31
Bug#39106: SUPER is not required to change
binlog format for session
Already fixed in: 5.1.29
Bug#35843: Slow replication slave when using partitioned myisam table
Already fixed in: 5.1.29
Bug#38230: Differences between master and slave after
UPDATE or DELETE with
LIMIT with pk
Target fix: 5.1
Bug#40638: Replication failure with Innodb +
RBR + decimal + no PK
Target fix: 5.1
Bug#40184: Replication failure with RBR +
Innodb + TRUNCATE
Target fix: 5.1
Server: Replication
Bug#38174: secure-file-priv breaks LOAD DATA
INFILE replication in statement mode
Target fix: 5.1
Bug#38934: slave slave until does not work with --replicate-same-server-id
Target fix: 5.1
Bug#31240: load data infile replication between (4.0 or 4.1) and 5.1 fails
Target fix: 5.1
Bug#32709: Assertion failed: trx_data->empty(), file log.cc
Already fixed in: 5.1.29
Bug#40116: Uncommited changes are replicated and stay on slave after rollback on master
Target fix: 5.1.31
Bug#40013: mixed replication: row based format could lead to stale tmp tables on the slave
Target fix: 5.1
Bug#38316: Assertion `m_curr_row_end <= m_rows_end' failed in unpack_current_row
Target fix: 5.1
Bug#40482: server/mysqlbinlog crashes when reading invalid Incident_log_event
Target fix: 5.1
Bug#13684: SP: DROP
PROCEDURE|FUNCTION IF EXISTS not
binlogged if routine does not exist
Target fix: 5.1
Bug#36763: TRUNCATE TABLE fails to replicate
when stmt-based binlogging is not supported.
Target fix: 5.1
Bug#34541: mysqlbinlog prints 'set;' in stm mode after changing autocommit mode
Target fix: 5.1
Bug#39197: replication breaks with large load with InnoDB, flush logs, and slave stop/start
Target fix: 5.1
Bug#39812: Make statement replication default for 5.1 (to match 5.0)
Already fixed in: 5.1.29
Bug#10206: InnoDB: Transaction requiring Max_BinLog_Cache_size > 4GB always rollsback.
Target fix: 5.1
Bug#22504: load data infile sql statement in replication architechure get error
Target fix: 5.1
Bug#39489: Cannot create or drop triggers without
SUPER privilege
Target fix: 5.1
Bug#38197: Errors in @@init_slave not visible in 'show slave status'
Target fix: 5.1
Bug#39526: sql_mode not retained in binary log for CREATE
PROCEDURE
Target fix: 5.1
Bug#38798: Assertion mysql_bin_log.is_open() failed in binlog_trans_log_savepos()
Already fixed in: 5.1.29
Bug#39393: slave-skip-errors does not work when using
ROW based replication
Target fix: 5.1
Bug#32228: A disk full makes binary log corrupt.
Target fix: 5.1
Bug#36391: mysqlbinlog creates invalid charset statements
Target fix: 5.1
Server: SP
Bug#38469: invalid memory read and/or crash with utf8 text field, stored procedure, uservar
Already fixed in: 5.1.29
Bug#35296: CREATE EVENT does not clear warnings
Target fix: 5.1
Bug#37949: Crash if argument to SP is a
subquery that returns more than one row
Already fixed in: 5.1.29
Bug#31612: Trigger fired multiple times leads to gaps in auto_increment sequence
Already fixed in: 5.1.29
Bug#38066: Events log 'note' level messages by default in the error log
Target fix: 5.1.31
Bug#35981: ALTER EVENT causes the server to
change the PRESERVE option.
Already fixed in: 5.1.29
Bug#36540: CREATE EVENT and ALTER
EVENT statements fail with large server_id
Target fix: 5.1
Bug#38872: Auto-increment for Innodb does not work for mixed and statement based formats
Target fix: 5.1
Bug#39182: Binary log producing incompatible character set query from stored procedure.
Already fixed in: 5.1.29
Bug#37526: asymertic operator <=> in trigger
Already fixed in: 5.1.29
Server: Types
Server: UDF
Server: Views
Bug#17823: 'arc' directories inside database directories
Server: XML
Bug#38227: EXTRACTVALUE doesn't work with
DTD declarations
Target fix: 5.1
Tests: Replication
Bug#38269: pushbuild gives valgrind error in ha_statistic_increment for rpl_temporary
Already fixed in: 5.1.29
libmysqld


User Comments
Add your own comment.