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#39559: dump of stored procedures / functions with C-style comment can't be read back
Target fix: 5.1
Bug#34861: mysqldump with --tab gives weird output for triggers.
Target fix: 5.1
Bug#37748: mysqldump shows misleading error messages when backingup mysql database
Target fix: 5.1
Bug#35934: mysql_upgrade calls mysqlcheck with insufficient parameters
Target fix: 5.1
Bug#34129: mysqldumpslow does not aggregate times
Target fix: 5.1
Bug#39852: bug in mysql_setpermission
Target fix: 5.1
Bug#40395: mysqladmin -i delay extended-status does not iterate with -r
Target fix: 5.1
Server
Bug#41078: With CURSOR_TYPE_READ_ONLY
mysql_stmt_fetch() returns short string value.
Target fix: 5.1
Bug#41004: events_scheduling times out sporadically on pushbuild
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#38883: thd_security_context is not thread safe, crashes?
Target fix: 5.1
Bug#41528: test-create script included in sql-bench doesn't create tables with many keys.
Target fix: 5.1
Bug#38941: fast mutexes in MySQL 5.1 have mutex contention when calling random()
Target fix: 5.1
Bug#40877: multi statement execution fails in 5.1.30
Target fix: 5.1
Bug#40358: HA_KEY_HAS_PART_KEY_SEG does not
properly get passed to storage engine
Target fix: 5.1
Bug#34367: sql/sql_show.cc: create_schema_table should handle
MYSQL_TYPE_NEWDECIMAL
Target fix: 5.1
Bug#40768: InnoDB regression: server crashes if tmpdir is unwritable
Target fix: 5.1
Bug#39494: please support >4GB key_buffer_size on windows
Target fix: 5.1
Bug#31616: div_precision_increment description looks wrong
Target fix: 5.1
Bug#40536: SELECT is blocked by INSERT
DELAYED waiting on upgrading lock, even with low_pri
Target fix: 5.1
Bug#22891: session level max_allowed_packet can be set but is ignored
Target fix: 5.1
Bug#40949: Debug version of MySQL server crashes when run
OPTIMIZE on compressed table.
Target fix: 5.1
Bug#41030: Wrong meta data (incorrect fieldlen)
Target fix: 5.1
Bug#40757: Starting server on Windows with innodb_flush_method=wrong_value causes crash
Target fix: 5.1
Server: Archive
Server: CSV
Bug#41441: repair csv table crashes debug server
Target fix: 5.1.31
Server: Charsets
Bug#33094: Error in upgrading from 5.0 to 5.1 when table contains triggers
Target fix: 5.1.31
Bug#41385: Crash when attempting to repair a #mysql50# upgraded table with triggers.
Target fix: 5.1.31
Bug#40053: 'check table .. for upgrade' doesn't detect collation change made in 5.1.24-rc
Already fixed in: 5.1.30
Bug#32831: libmysql should be built with all charsets
Target fix: 5.1
Bug#41084: full-text index added to custom UCA
collation not working
Target fix: 5.1
Server: Compiling
Bug#26760: SSL support missing from 5.1.15-0
x86_64 Client Programs?
Target fix: 5.1.31
Bug#39709: status variable 'Uptime_since_flush_status' missing
Target fix: 5.1
Bug#39996: 5.1 fails to compile on Windows 32-bit with VS2005
Target fix: 5.1
Bug#25404: mysql_config need several issues corrected
Target fix: 5.1
Bug#38364: gen_lex_hash segmentation fault in debug build
Target fix: 5.1
Bug#39279: mysqld Linux-ia64 binary depends on two versions of libunwind
Target fix: 5.1
Bug#31733: mysqldump linux: _dl_open: Assertion `_dl_debug_initialize ...` failed
Target fix: 5.1
Bug#39571: abi_check: Does not create all prerequisites
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
Server: Config Wizard
Server: DDL
Bug#37016: TRUNCATE TABLE removes some rows but
not all
Target fix: 5.1.31
Bug#23113: Different behavior on altering ENUM
fields between 5.0 and 5.1
Already fixed in: 5.1.30
Bug#39372: "Smart" ALTER TABLE not so smart
after all.
Target fix: 5.1
Bug#41465: confusing error message when comment is too long
Target fix: 5.1
Bug#39200: optimize table does not recognize
ROW_FORMAT=COMPRESSED
Target fix: 5.1
Bug#39793: Foreign keys not constructed when column has a '#' in a comment or default value
Target fix: 5.1
Bug#40886: ALTER TABLE statements appear to
randomly fail on Mac OS 10.4
Target fix: 5.1
Bug#35796: SHOW CREATE TABLE and default value
for BIT field
Target fix: 5.1
Bug#41041: Obsolete debug code can be used to crash server
Target fix: 5.1
Bug#33650: mysql_alter_table() unnecessarily does full table copy
Target fix: 5.1
Server: DML
Bug#39920: MySQL cannot deal with Leap Second expression in string literal.
Target fix: 5.0.74
Bug#41156: List of derived tables acts like a chain of mutually-nested subqueries
Target fix: 5.1
Bug#24678: can't use SQL_BUFFER_RESULT on union
all
Target fix: 5.1
Bug#40384: Gap in auto_increment sequence when inserts fire a trigger
Target fix: 5.1
Bug#41371: Select returns 1 row with condition "col is not null and col is null"
Target fix: 5.1
Bug#33717: INSERT...(default) fails for enum.
Crashes CSV tables, loads spaces for MyISAM
Target fix: 5.1
Bug#38693: leaked memory with blobs!
Target fix: 5.1
Bug#33844: Server crashes when client dies during LOAD
DATA INFILE
Target fix: 5.1
Bug#40745: Error during WHERE clause
calculation in UPDATE leads to an assertion
failure
Target fix: 5.1
Bug#40127: Multiple table DELETE IGNORE hangs
on foreign key constraint violation on 5.0
Target fix: 5.1
Server: Errors
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#41363: crash of mysqld on windows with aggregate in case
Target fix: 5.1.31
Bug#40104: regression with table names?
Target fix: 5.1
Bug#10206: InnoDB: Transaction requiring Max_BinLog_Cache_size > 4GB always rollsback.
Target fix: 5.1
Bug#37284: Crash in Field_string::type()
Target fix: 5.1
Bug#39326: mysqld_safe doesn't use --basedir value in search of my_print_defaults
Target fix: 5.1
Bug#34043: Server loops excessively in _checkchunk() when safemalloc is enabled
Target fix: 5.1
Bug#41580: opt_threads option is not used anywhere at all
Target fix: 5.1
Bug#30261: "mysqld --help" no longer possible for root
Target fix: 5.1
Bug#38477: my_pthread_setprio can change dispatch class on Solaris, not just priority
Target fix: 5.1
Bug#40915: Events takes mutex in wrong order which can easily lead to deadlocks
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#40657: assertion with out of range variables and traditional sql_mode
Target fix: 5.1
Server: I_S
Bug#39541: CHECK TABLE on information_schema
myisam tables produces error
Target fix: 5.0.74
Bug#39955: SELECT on
INFORMATION_SCHEMA.GLOBAL_VARIABLES
takes too long
Target fix: 5.1
Bug#35275:
INFORMATION_SCHEMA.TABLES.CREATE_OPTIONS
omits KEY_BLOCK_SIZE
Target fix: 5.1
Bug#38918: selecting from information_schema.columns is disproportionately slow
Target fix: 5.1
Bug#38909: CREATE_OPTIONS in information_schema
produces wrong results
Target fix: 5.1
Bug#35789: wrong datatypes for collation and charset columns in
EVENTS, ROUTINES,
TRIGGERS
Target fix: 5.1
Server: InnoDB
Bug#40386: Not flushing query cache after truncate
Target fix: 5.1.31
Bug#40360: Binlog related errors with binlog off
Already fixed in: 5.1.30
Bug#39438: Testcase for Bug#39436 crashes on 5.1 in fil_space_get_latch
Target fix: 5.1
Bug#36169: create innodb compressed table with too large row size crashed
Target fix: 5.1
Bug#40369: dtype_get_sql_null_size() returns 0 or 1, not the size
Target fix: 5.1
Bug#39648: Replication failure on RBR + Innodb
+ 2 bit fields + LIMIT + no
PK
Target fix: 5.1
Bug#39830: Table autoinc value not updated on first insert
Target fix: 5.1
Bug#38231: Innodb crash in lock_reset_all_on_table() on
TRUNCATE + LOCK /
UNLOCK
Target fix: 5.1
Bug#38189: innodb_stats_on_metadata missing
Target fix: 5.1
Bug#37885: row_search_for_mysql may gap lock unnecessarily with
SQL comments in query
Target fix: 5.1
Bug#35498: Cannot get table test/table1 auto-inccounter value in ::info
Target fix: 5.1
Bug#38839: auto increment does not work properly with InnoDB after update
Target fix: 5.1
Bug#38741: main.innodb_mysql crashes randomly (2)
Target fix: 5.1
Bug#36411: "Failed to read auto-increment value from storage engine" in 5.1.24 auto-inc
Target fix: 5.1
Server: InnoDB Plugin
Bug#37788: InnoDB Plugin: AUTO_INCREMENT wrong
for compressed tables
Target fix: 5.1
Server: Installing
Server: Locking
Bug#41348: INSERT INTO tbl
SELECT * FROM temp_tbl
overwrites locking type of temp table
Target fix: 5.1.31
Bug#41110: crash with handler command when used concurrently with alter table
Target fix: 5.1
Bug#35077: Innodb deadlock on concurrent DDL
Target fix: 5.1
Bug#39843: DELETE requires write access to
table in subquery in where clause
Target fix: 5.1
Bug#33278: ANALYZE TABLE in InnoDB holds
exclusive locks on subsequent execution
Target fix: 5.1
Server: Logging
Server: Memory
Server: Merge
Server: MyISAM
Bug#41574: REPAIR TABLE: crashes for compressed
tables
Target fix: 5.1.31
Bug#40321: ha_myisam::info could update rec_per_key incorrectly
Target fix: 5.1
Bug#40634: table scan temporary table is 4x slower due to mmap instead instead of caching
Target fix: 5.1
Bug#38834: key_buffer_size irregularities on 64 bit windows
Target fix: 5.1
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#37756: enabling fulltext indexes with myisam_repair_threads > 1 causes crash
Target fix: 5.1
Bug#37631: Incorrect key file for table after upgrading from 5.0 to 5.1
Target fix: 5.1
Bug#40827: Killing insert-select to MyISAM can cause table corruption
Target fix: 5.1
Server: Optimizer
Bug#34773: query with explain extended and derived table / other table crashes server
Target fix: 5.1.31
Bug#38842: Fix for 25951 seems incorrect
Target fix: 5.0.74
Bug#37742: HA_EXTRA_KEYREAD flag is set when
key contains only prefix of requested column
Target fix: 5.1
Bug#28554: Optimizer wrongly prefers index for (col = value) over
(PK <= value)
Target fix: 5.1
Bug#41543: Assertion `m_status == DA_ERROR'
failed in Diagnostics_area::sql_errno
Target fix: 5.1
Bug#37822: Correlated subquery with IN and
IS UNKNOWN provides wrong result
Target fix: 5.1
Bug#38538: 'rows' in EXPLAIN output doesn't
reflect number of rows correctly with LIMIT
Target fix: 5.1
Bug#36259: Optimizing with ORDER BY
Target fix: 5.1
Bug#39298: Prefix key search returns wrong result for multi-level collations
Target fix: 5.1
Bug#31399: Wrong query result when doing join buffering over
BIT fields
Target fix: 5.1
Server: Packaging
Bug#40845: Win inst shows screens with wrong naming "MySQL Monitoring and Advisory Service"
Target fix: 5.1.31
Bug#34025: mysql_config is not returning -ldl lib flag needed when using embedded server
Target fix: 5.1.31
Bug#39074: Binaries do not work on Solaris 10 older than U5
Already fixed in: 5.1.30
Bug#41583: Windows charsets are not compiled into Windows packages
Target fix: 5.1
Bug#41074: Grammatical error in error message from install/request in Solaris package
Target fix: 5.1
Bug#31143: mysqlslap.exe (and other) missing in windows install packages
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#39443: .pdb-files not delivered with 5.1.28
Target fix: 5.1
Bug#41577: improper value in example config file
Target fix: 5.1
Bug#37697: make_binary_distribution places files in wrong path
Target fix: 5.1
Server: Parser
Bug#25250: alter table allows simultaneous drop/add foreign keys
Target fix: 5.1
Server: Partition
Bug#40176: Combination of event, trigger and partitioning breaks auto increment
Target fix: 5.1.31
Bug#37721: ORDER BY when
WHERE contains non-partitioned index column
Target fix: 5.1.31
Bug#40954: Crash in MyISAM index code with concurrency test using partitioned tables
The crash is observed with queries of the form "SELECT * FROM part_table WHERE a < const ORDER BY a" or "SELECT * FROM part_table WHERE a <> ORDER BY a" where a is an indexed column used as the partition key. The crash can be avoided by 'limiting' the where clause with a very low value as in: "SELECT * FROM part_table WHERE a < const AND a > -1000 ORDER BY a" or "SELECT * FROM part_table WHERE a <> AND a > -1000 ORDER BY a"
Target fix: 5.1.31
Bug#39434: ALTER TABLE
CHECK/OPTIMIZE/ANALYZE
PARTITION work on non-partitioned table
Target fix: 5.1.31
Bug#14326: No formatting of SHOW CREATE TABLE
output
Target fix: 5.1.31
Bug#40494: MYSQL server crashes on range access
with partitioning and order by
Already fixed in: 5.1.30
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#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#38784: Mysql server crash if table is altered with partition changes.
Target fix: 5.1
Bug#39084: Getting intermittent errors with statement-based binary logging
Target fix: 5.1
Bug#30102: rename table does corrupt tables with partition files on failure
Target fix: 5.1
Server: Privileges
Bug#30305: Create routine in wrong context in SHOW
PRIVILEGES
Target fix: 5.1
Server: RBR
Bug#40221: Replication failure on RBR +
UPDATE the primary key
Target fix: 5.1.31
Bug#40004: Replication failure with no PK + no
indexes
Already fixed in: 5.1.30
Bug#39934: Slave stops for engine that only support row-based logging
Target fix: 5.1
Bug#40222: Replication failure on RBR +
CREATE TABLE + transactions
Target fix: 5.1
Bug#40278: Replication failure on RBR + MyISAM
+ SAVEPOINTs
Target fix: 5.1
Bug#39701: Mixed binlog format does not switch to row mode on
LOAD_FILE
Target fix: 5.1
Bug#31502: 5.1.20 -> 5.1.22 Slave crashes if it gets an event w/ data for non-exist column
Target fix: 5.1
Bug#38230: Differences between master and slave after
UPDATE or DELETE with
LIMIT with pk
Target fix: 5.1
Bug#40258: Replication failure on Innodb + RBR
+ UPDATE + ORDER BY
Target fix: 5.1
Bug#39753: Replication failure on MIXED + bit +
myisam + no PK
Target fix: 5.1
Bug#40146: log_slave_updates uses MIXED mode
for binlog regardless of binlog_format
Target fix: 5.1
Bug#40186: Replication failure on RBR + Innodb
+ SET AUTOCOMMIT=OFF +
DROP TABLE
Target fix: 5.1
Bug#40188: Replication failure on RBR + Innodb
+ implicit commit + truncate/drop table
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#40116: Uncommited changes are replicated and stay on slave after rollback on master
Target fix: 5.1.31
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#40796: Crash due to heap corruption in rpl.rpl_extraColmaster_myisam
Target fix: 5.1
Bug#22504: load data infile sql statement in replication architechure get error
Target fix: 5.1
Bug#38174: secure-file-priv breaks LOAD DATA
INFILE replication in statement mode
Target fix: 5.1
Bug#40013: mixed replication: row based format could lead to stale tmp tables on the slave
Target fix: 5.1
Bug#41400: slave fails to reconnect on errors
Target fix: 5.1
Bug#41166: stored function requires "deterministic" if binlog_format is "statement"
Target fix: 5.1
Bug#39393: slave-skip-errors does not work when using
ROW based replication
Target fix: 5.1
Bug#39489: Cannot create or drop triggers without
SUPER privilege
Target fix: 5.1
Bug#36763: TRUNCATE TABLE fails to replicate
when stmt-based binlogging is not supported.
Target fix: 5.1
Bug#38934: slave slave until does not work with --replicate-same-server-id
Target fix: 5.1
Bug#41101: set storage_engine and set create_table are not written to the binlog
Target fix: 5.1
Bug#32228: A disk full makes binary log corrupt.
Target fix: 5.1
Bug#34541: mysqlbinlog prints 'set;' in stm mode after changing autocommit mode
Target fix: 5.1
Bug#39526: sql_mode not retained in binary log for CREATE
PROCEDURE
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#38197: Errors in @@init_slave not visible in 'show slave status'
Target fix: 5.1
Bug#38205: Row-based Replication (RBR) causes
inconsistencies: HA_ERR_FOUND_DUPP_KEY
Target fix: 5.1
Bug#36391: mysqlbinlog creates invalid charset statements
Target fix: 5.1
Server: SE API
Bug#38338: REPLACE causes last_insert_id() to
return an incorrect value
Target fix: 5.1
Server: SP
Bug#40770: Server Crash when running with triggers including variable settings (rpl_sys)
The crash is observed when the trigger/SP assigns values to user variables. The crash can be avoided by using local variables instead of user variables in the trigger/SP code.
Target fix: 5.1.31
Bug#38066: Events log 'note' level messages by default in the error log
Target fix: 5.1.31
Bug#38872: Auto-increment for Innodb does not work for mixed and statement based formats
Target fix: 5.1
Bug#35296: CREATE EVENT does not clear warnings
Target fix: 5.1
Bug#36540: CREATE EVENT and ALTER
EVENT statements fail with large server_id
Target fix: 5.1
Bug#33082: Stored Procedure: crash if table replaced with a view in a loop
Target fix: 5.1
Server: Types
Server: UDF
Bug#39053: UNISTALL PLUGIN does not allow the
storage engine to cleanup open connections
Target fix: 5.1
Server: Views
Bug#40825: Error 1356 while selecting from a view with a
"HAVING" clause though query works
Target fix: 5.1
Server: XML
Bug#38227: EXTRACTVALUE doesn't work with
DTD declarations
Target fix: 5.1
libmysqld
Bug#37995: Error message truncation in test "innodb" in embedded mode
Target fix: 5.1
Bug#34517: SHOW GLOBAL STATUS does not work
properly in embedded server.
Target fix: 5.1
Bug#38293: Libmysqld crash in mysql_library_init if language file missing
Target fix: 5.1
Bug#39289: libmysqld.a calls exit() upon error
Target fix: 5.1
Bug#38522: 5 seconds delay when closing application using embedded server
Target fix: 5.1


User Comments
Add your own comment.