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
Bug#47007: Unresolved reference to 'innodb_system_libs' in "mysql_config"
Target fix: 5.1
Bug#43560: client crashes in mysql_stmt_execute/mysql_stmt_close after connection loss
Target fix: 5.1
Bug#45017: Failure to connect if hostname maps to multiple addresses
Already fixed in: 5.1
Bug#42675: Dangling pointer leads to a client crash (mysys/my_error.c patch enclosed)
Target fix: 5.1
Client
Bug#44278: mysqlhotcopy unable to backup schema with a hyphen in its name
mysqlhotcopy fails for database names that contain non-alphanumeric characters.
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
Already fixed in: 5.1
Bug#34861: mysqldump with --tab gives weird output for triggers.
Target fix: 5.1
Bug#46310: mysql not handling <BACKSPACE
>
properly with multi-byte chars
Target fix: 5.1
Bug#46776: MySQL client confused by quotes, treats data as commands
Target fix: 5.1
Bug#45740: mysqldump doesn't dump general_log and slow_query causes restore problem
Target fix: 5.1
Bug#36391: mysqlbinlog creates invalid charset statements
Target fix: 5.1
Bug#30946: mysqldump silently ignores --default-character-set when used with --tab
Dumps for tables containing columns with different character sets would not be reloadable. To deal with this, a CHARACTER SET clause is being added to SELECT ... INTO OUTFILE (which mysqldump uses) so that all columns will be converted to a single character set on output. The same character set can be specified for LOAD DATA to enable the dump file to be reloaded.
Already fixed in: 5.1
Server
Bug#42640: mysqld crashes when unsafe statements are executed
(STRICT_TRANS_TABLES
mode)
Target fix: 5.1.35
Bug#42610: Dynamic plugin broken in 5.1.31
Target fix: 5.1.33
Bug#41078: With CURSOR_TYPE_READ_ONLY
mysql_stmt_fetch() returns short string value.
Target fix: 5.1
Bug#46486: warnings produced when running mysql_install_db
Target fix: 5.1
Bug#39494: please support >4GB key_buffer_size on windows
Target fix: 5.1
Bug#38883: thd_security_context is not thread safe, crashes?
Target fix: 5.1
Bug#38941: fast mutexes in MySQL 5.1 have mutex contention when calling random()
Target fix: 5.1
Bug#40230: 23 seconds difference while the time_zone is
SYSTEM
Target fix: 5.1
Bug#31616: div_precision_increment description looks wrong
Target fix: 5.1
Bug#43354: Use key hint can crash server in explain extended query
Target fix: 5.1
Bug#46756: Test group_min_max fails in valgrind mode
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#46815: CONCAT_WS
returning wrong data
Target fix: 5.1
Bug#46539: Various crashes on INSERT IGNORE
SELECT
+ SELECT FOR UPDATE
Target fix: 5.1
Bug#43435: LOCK_open does not use
MY_MUTEX_INIT_FAST
Already fixed in: 5.1
Bug#45336: --enable-foobar doesn't work for any plugin foobar.
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#46043: mysqld --skip-innodb does not skip InnoDB
After changes made for Bug#19027, --skip-innodb does not work.
Target fix: 5.1
Bug#40877: multi statement execution fails in 5.1.30
Target fix: 5.1
Bug#45058: init_available_charsets uses double checked locking
Target fix: 5.1
Bug#46804: innodb test fails on PB
-2 with a
crash
Target fix: 5.1
Bug#46941: crash with lower_case_table_names=2 and foreign key data dictionary confusion
Target fix: 5.1
Bug#42144: plugin_load fails on PPC64 and Sparc
Target fix: 5.1
Bug#45638: Create temporary table with engine innodb fails
Target fix: 5.1
Bug#40757: server crash after failed plugin/engine initialization
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#43827: Server closes connections and restarts
Target fix: 5.1
Bug#46760: Fast ALTER TABLE
no longer works for
InnoDB
Target fix: 5.1
Bug#41030: Wrong meta data (incorrect fieldlen)
Target fix: 5.1
Bug#42563: Message tells me to repair table though Storage Engine doesn't allow me to.
Target fix: 5.1
Bug#44521: Prepared Statement: CALL
p() -
crashes: `! thd->main_da.is_sent' failed et.al.
Already fixed in: 5.1
Bug#46893: Performance degradation on
SuSE-10/RHEL
in dbt2 test
Target fix: 5.1
Server: Archive
Bug#47012: archive tables are not upgradeable, server crashes on access
After a binary upgrade from 5.0 to 5.1, accessing ARCHIVE tables causes a server crash. Workaround: Dump ARCHIVE tables with mysqldump in 5.0, reload into 5.1 after upgrading.
Target fix: 5.1
Bug#37719: Crash if rename Archive table to same name with different case and then select
Target fix: 5.1
Bug#29203: archive tables have weird values in show table status
Target fix: 5.1
Bug#46961: archive engine loses rows during self joining select!
Target fix: 5.1
Bug#46565: repair of partition fail for archive engine
Target fix: 5.1
Bug#32880: Repairing Archive table fails with internal error 144
Target fix: 5.1
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
Target fix: 5.1.30
Bug#32831: libmysql should be built with all charsets
Target fix: 5.1
Bug#46448: trailing spaces are not ignored when user collation maps space != 0x20
Target fix: 5.1
Bug#45012: my_like_range_cp932 generates invalid string
Target fix: 5.1
Bug#43593: dump/backup/restore/upgrade tools fails
Target fix: 5.1
Bug#45485: replication different between master/slaver using procedure with gbk
Target fix: 5.1
Bug#45645: Mysql server close all connection and restart using lower function
Target fix: 5.1
Bug#41084: full-text index added to custom UCA
collation not working
Target fix: 5.1
Server: Compiling
Bug#42524: Function pthread_setschedprio() is defined but seems
broken on i5/OS PASE
Target fix: 5.1.32
Bug#26760: SSL
support missing from 5.1.15-0
x86_64 Client Programs?
Target fix: 5.1.31
Bug#43715: Link errors when trying to link mysql_embedded.exe
Target fix: 5.1
Bug#43449: Undefined symbol __1cG__CrunMex_rethrow_q6F_v_ when compiling using Sun Studio
Target fix: 5.1
Bug#42872: In MySQL 5.1.31, unrecognized --with-innodb, --with-partition, --with-federated
Target fix: 5.1
Bug#39996: 5.1 fails to compile on Windows 32-bit with VS2005
Target fix: 5.1
Bug#45706: rpm install fails due to incorrect libc linking
Target fix: 5.1
Bug#46309: MySQL 5.1.36 fails to compile using
ICC
11.1
Target fix: 5.1
Bug#45113: mysql_config returns incorrect path if built with prefix != execprefix
Target fix: 5.1
Bug#42599: error: `pthread_setschedprio' was not declared in this scope
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#42733: type-punning warnings when compiling MySQL with -O2/-O3 -Wall and gcc 4.x
Target fix: 5.1
Bug#39102: valgrind build does not compile in realpath, which make
DATA
/INDEX DIR
fail
Target fix: 5.1
Bug#31506: detection of function's availability is wrong in configure.in
Target fix: 5.1
Bug#38697: utf8_general_cs cannot be used with Windows?
Target fix: 5.1
Bug#40862: main.subselect_notembedded test case fails
Target fix: 5.1
Bug#46980: Option "--without-server" still not working in 5.1
Target fix: 5.1
Bug#42071: Obsoleted configure options were still used in the official compiling.
Target fix: 5.1
Bug#39571: abi_check: Does not create all prerequisites
Target fix: 5.1
Bug#42141: Compiler crash in "mf_format.c" when optimizing for 64 bit
Target fix: 5.1
Bug#42721: configure.in invokes 'nm' directly
Target fix: 5.1
Bug#39288: MySQL Embedded server (libmysqld.a) is built without -fPIC flag
Target fix: 5.1
Server: Config Wizard
Bug#42386: MySQL .msi installer does not start configuration wizard on Vista when prompted
Target fix: 5.1.33
Bug#37294: Windows .msi - 'Repair' option doesn't back out as expected
Target fix: 5.1
Bug#46146: Configuration wizard fails if the service already exists
Target fix: 5.1
Bug#44428: Cannot recreate instance after clean install (apply security settings fails)
Already fixed in: 5.1
Bug#38723: MySQL Configuration Wizard on Vista unreadable
Already fixed in: 5.1
Server: DB2SE for IBM i
Bug#45196: Some collations do not sort correctly with IBMDB2I
Target fix: 5.1
Bug#45983: ibmdb2i_create_index_option=1 not working for primary key
Target fix: 5.1
Bug#45803: Inaccurate estimates for partial key values with IBMDB2I
Target fix: 5.1
Bug#44022: CREATE TABLE
sometimes fails
silently for IBMDB2I engine
Target fix: 5.1
Bug#45197: cp1250 character set with IBMDB2I generates 2027 error
Target fix: 5.1
Bug#43343: ibmdb2i Storage Engine does not honor timezone settings
with INSERT
Target fix: 5.1
Bug#44025: Some schema names longer than 8 characters not supported by IBMDB2I
Target fix: 5.1
Bug#44856: IBMDB2I gives misleading 2504 error
Target fix: 5.1
Bug#44811: Tests with utf8 charset fail with ibmdb2i on 64bit MySQL
Target fix: 5.1
Bug#44020: Unicode Swedish collations not working with IBMDB2I
Target fix: 5.1
Bug#46730: Tables created witn SE
IBMDB2I show
incorr update and create timestamps
Target fix: 5/1
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
Target fix: 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#45567: Fast ALTER TABLE
broken for enum and
set
Target fix: 5.1
Bug#43508: Renaming timestamp or date column triggers table copy
Target fix: 5.1
Bug#40886: ALTER TABLE
statements appear to
randomly fail on Mac OS
10.4
Target fix: 5.1
Bug#40277: SHOW CREATE VIEW
returns invalid
SQL
Target fix: 5.1
Bug#46766: ALTER TABLE
corrupts table on
combined drop and add index
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
Server: DML
Bug#39920: MySQL cannot deal with Leap Second expression in string literal.
Target fix: 5.0.74
Bug#44743: Join in combination with concat does not always work
Target fix: 5.1
Bug#41156: List of derived tables acts like a chain of mutually-nested subqueries
Target fix: 5.1
Bug#40384: Gap in auto_increment sequence when inserts fire a trigger
Target fix: 5.1
Bug#45168: assertion with convert() and empty set value
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#46259: 5.0.83 -> 5.1.36, query doesn't work
Target fix: 5.1
Bug#44306: Assertion fail on duplicate key error in
'INSERT
... SELECT
'
statements
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#45962: memory leak after 'sort aborted' errors
Target fix: 5.1
Bug#43385: Cannot ALTER DATABASE
...
UPGRADE DATA DIRECTORY NAME
when Views exist
Target fix: 5.1
Bug#40127: Multiple table DELETE IGNORE
hangs
on foreign key constraint violation on 5.0
Target fix: 5.1
Bug#44399: crash with statement using TEXT
columns, aggregates, GROUP BY
, and
HAVING
Target fix: 5.1
Server: Docs
Server: Errors
Bug#42364: SHOW ERRORS
returns empty resultset
after dropping non existent table
Target fix: 5.1
Bug#41121: "Statement is not safe to log in statement format" is prints table name only
Target fix: 5.1
Bug#41077: Warning contains wrong future version
Target fix: 5.1
Bug#46265: Can not disable warning about unsafe statements for binary logging
Already fixed in: 5.1
Server: FTS
Bug#39746: Debug flag breaks struct definition (server crash)
Target fix: 5.1
Bug#28234: global/session scope - documentation vs implementation
Target fix: 5.1
Bug#42907: Multi-term boolean fulltext query containing a single quote fails in 5.1.x
Target fix: 5.1
Bug#39640: ftb_query_add_word does not recognice
MYSQL_FTFLAGS_NEED_COPY
Target fix: 5.1
Server: GIS
Server: General
Bug#43748: crash when non-super user tries to kill the replication threads
Target fix: 5.1.34
Bug#41456: SET PASSWORD
hates
CURRENT_USER
()
Target fix: 5.1.31
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#38249: innodb_log_arch_dir still in support files
Target fix: 5.1
Bug#10206: InnoDB: Transaction requiring Max_BinLog_Cache_size > 4GB always rollsback.
Target fix: 5.1
Bug#47130: misplaced or redundant check for null pointer ?
Target fix: 5.1
Bug#36751: Segmentation fault in ctype-bin.c:308; Linux 86_64, with-max-indexes=128
Target fix: 5.1
Bug#42957: no results from select where .. (col=col and col=col) or ... (false expression)
Target fix: 5.1
Bug#44358: valgrind errors with decode() function
Target fix: 5.1
Bug#40915: Events takes mutex in wrong order which can easily lead to deadlocks
Target fix: 5.1
Bug#44736: mysqld_safe's my_which() is broken and doesn't find 'logger'
Target fix: 5.1
Bug#44638: mysql_upgrade, mysqlcheck output instance unclear
Target fix: 5.1
Bug#43606: 4GB Limit on huge_pages shared memory set-up
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#46261: Plugins can be installed with --skip-grant-tables
Target fix: 5.1
Bug#41612: resolve_stack_dump does not decode 5.1 stack trace
Target fix: 5.1
Bug#37284: Crash in Field_string::type()
Target fix: 5.1
Bug#30261: "mysqld --help" no longer possible for root
Target fix: 5.1
Bug#41710: MySQL 5.1.30 crashes on the latest OpenSolaris 10
Target fix: 5.1
Bug#46480: Return values for mysys file API
are
obscure and undocumented
Target fix: 5.1
Bug#38477: my_pthread_setprio can change dispatch class on Solaris, not just priority
Target fix: 5.1
Bug#44367: valgrind warnings with find_in_set() functions
Target fix: 5.1
Bug#45309: InnoDB does not rollback for delete and update queries if query was killed
Target fix: 5.1
Bug#39265: SQL_MODE
OLD_NOT_NULL_CHECK_BEHAVIOUR
for backward
compatibility
Target fix: 5.1
Bug#44664: valgrind warning for
COMMIT_AND_CHAIN
and
ROLLBACK_AND_CHAIN
Target fix: 5.1
Bug#43962: "Packets out of order" calling a SHOW TABLE
STATUS
Target fix: 5.1
Bug#42158: leak: SSL_get_peer_certificate() doesn't have matching X509_free()
Target fix: 5.1
Bug#45548: XA
transaction without access to
InnoDB tables crashes the server
Target fix: 5.1
Bug#42146: DATETIME
fractional seconds parse
error
Target fix: 5.1
Bug#44365: valgrind warnings with encrypt() function
Target fix: 5.1
Bug#40657: assertion with out of range variables and traditional sql_mode
Target fix: 5.1
Bug#44164: TL_WRITE
has no description in
lock_descriptions[]
Target fix: 5.1
Bug#34043: Server loops excessively in _checkchunk() when safemalloc is enabled
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#42758:
INFORMATION_SCHEMA
.COLUMNS
is inconsistent
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#45357: 5.1.35 crashes with Failing assertion: index->type
& DICT_CLUSTERED
Target fix: 5.1.37
Bug#39320: assert btr/btr0pcur.c line 217 -innodb_locks_unsafe_for_binlog or read committed
Target fix: 5.1.35
Bug#40386: Not flushing query cache after truncate
Target fix: 5.1.31
Bug#40360: Binlog related errors with binlog off
Target fix: 5.1.30
Bug#42400: InnoDB autoinc code can't handle floating-point columns
Target fix: 5.1
Bug#42101: Race condition in innodb_commit_concurrency
Target fix: 5.1
Bug#21704: Renaming column does not update FK
definition
Renaming a column that appears in a foreign key definition does not update the foreign key definition with the new column name; this occurs with both referenced and referencing tables. This could interefere with reloading from a dump, due to creating constraints against non-existent columns. Workaround: Drop and re-create manually any foreign key definitions affected by the renaming of a column.
Target fix: 5.1
Bug#45097: Hang during recovery, redo logs for doublewrite buffer pages
Target fix: 5.1
Bug#42152: Race condition in lock_is_table_exclusive()
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#47233: Innodb calls
push_warning(MYSQL_ERROR
::WARN_LEVEL_ERROR
)
Target fix: 5.1
Bug#44030: Error: (1500) Couldn't read the
MAX
(ID
) autoinc value from
the index (PRIMARY
)
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
Bug#43203: Overflow from auto incrementing causes server segv
Target fix: 5.1
Bug#42075: dict_load_indexes failure in dict_load_table will corrupt the dictionary cache
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#43660: SHOW
INDEXES
/ANALYZE
does
NOT
update cardinality for indexes of InnoDB
table
Target fix: 5.1
Bug#39648: Replication failure on RBR
+ Innodb
+ 2 bit fields + LIMIT
+ no
PK
Target fix: 5.1
Bug#37885: row_search_for_mysql may gap lock unnecessarily with
SQL
comments in query
Target fix: 5.1
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#44320: InnoDB: missing DB_ROLL_PTR
in Table
Monitor COLUMNS
output
Target fix: 5.1
Bug#39830: Table autoinc value not updated on first insert
Target fix: 5.1
Bug#45749: Race condition in SET GLOBAL
innodb_commit_concurrency=DEFAULT
Target fix: 5.1
Bug#42383: main.innodb_bug39438: Can't create table 'test.bug39438'
Target fix: 5.1
Bug#40369: dtype_get_sql_null_size() returns 0 or 1, not the size
Target fix: 5.1
Bug#42279: Race condition in btr_search_drop_page_hash_when_freed()
Target fix: 5.1
Bug#46256: drop table with unknown collation crashes innodb
Target fix: 5.1
Bug#35498: Cannot get table test/table1 auto-inccounter value in ::info
Target fix: 5.1
Bug#46193: crash when accessing tables after enabling innodb_force_recovery option
Target fix: 5.1
Bug#41671: Semi-consistent read does not unlock rows in
READ COMMITTED
mode
Target fix: 5.1
Bug#42714: AUTO_INCREMENT
errors in 5.1.31
Target fix: 5.1
Bug#32430: 'show innodb status' causes errors Invalid (old?) table or database name in logs
Target fix: 5.1
Server: InnoDB Plugin
Server: Installing
Bug#45418: 'MySQL Server 5.1 Setup Wizard ended prematurely' message during .msi install
Already fixed in: 5.1.38
Bug#17270: mysql client tool could not find ../share/charsets folder and fails.
Target fix: 5.1
Bug#46258: Windows Install zaps prev. instance, even though basedir is different
Target fix: 5.1
Bug#41828: mysql_install_db misses mysqld options when using --basedir
Target fix: 5.1
Bug#41313: network administrator does not have
TRIGGER
and EVENT
privileges
Target fix: 5.1
Bug#44073: 'could not start service' message but service starts anyway!
Target fix: 5.1
Server: Locking
Bug#41348: INSERT INTO
tbl
SELECT
* FROM
temp_tbl
overwrites locking type of temp table
Target fix: 5.1.31
Bug#46944: Internal prepared XA
transction XIDs
are not removed if server_id changes
Target fix: 5.1
Bug#44672: Assertion failed: thd->transaction.xid_state.xid.is_null()
Target fix: 5.1
Bug#41110: crash with handler command when used concurrently with alter table
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
Bug#43885: main.variables-big fails because of warnings within the server log
Target fix: 5.1
Bug#37132: Logging to slow_log table fails with very slow queries
Target fix: 5.1
Bug#29751: renaming server logs at FLUSH LOGS
Target fix: 5.1
Bug#40281: partitioning the general log table crashes the server
Already fixed in: 5.1
Server: Memory
Bug#39886: Table full for MEMORY
table is not
written into error log
Target fix: 5.1
Server: Merge
Bug#40675: MySQL 5.1 crash with index merge algorithm and Merge tables
Target fix: 5.1.33
Bug#45796: invalid memory reads and writes when altering merge and base tables
Target fix: 5.1
Bug#41305: server crashes when inserting duplicate row into a merge table
Target fix: 5.1
Bug#45800: crash when replacing into a merge table and there is a duplicate
Target fix: 5.1
Bug#44040: MySQL allows creating a MERGE
table
upon VIEWs but crashes when using it
Target fix: 5.1
Bug#41212: crash after race condition between merge table and table_cache evictions
Target fix: 5.1
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#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#47073: valgrind errs, corruption,failed repair of partition,low myisam_sort_buffer_size
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
Bug#43940: 64-bit windows myisamchk doesn't support key_buffer_size > 4G
Target fix: 5.1
Server: Optimizer
Bug#46454: MySQL wrong index optimisation leads to incorrect result & crashes
Already fixed in: 5.1.38
Bug#37362: Crash in do_field_eq
Target fix: 5.1.36
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#45828: Optimizer won't use partial primary key if another index can prevent filesort
Target fix: 5.1
Bug#37742: HA_EXTRA_KEYREAD
flag is set when
key contains only prefix of requested column
Target fix: 5.1
Bug#46003: Valgrind warning in JOIN
::init()
Already fixed in: 5.1
Bug#46159: simple query that never returns
Target fix: 5.1
Bug#47150: Assertion in Field_long::val_int() on
MERGE
+ TRIGGER
+
multi-table UPDATE
Target fix: 5.1
Bug#37948: Assertion in Field_long::val_int
Target fix: 5.1
Bug#37936: ASSERT_COLUMN_MARKED_FOR_WRITE
in
Field_datetime::store , Field_varstring::store
Target fix: 5.1
Bug#41543: Assertion `m_status == DA_ERROR
'
failed in Diagnostics_area::sql_errno
Target fix: 5.1
Bug#44886: SIGSEGV
in test_if_skip_sort_order()
- uninitialized variable used as subscript
Target fix: 5.1
Bug#37822: Correlated subquery with IN
and
IS UNKNOWN
provides wrong result
Target fix: 5.1
Bug#46607: Assertion failed: (cond_type ==
Item::FUNC_ITEM
) results in server crash
Target fix: 5.1
Bug#46051: Selects with a subquery sporadically return wrong data
Already fixed in: 5.1
Bug#46629: Item_in_subselect::val_int(): Assertion `0' on subquery
inside a SP
Target fix: 5.1
Bug#31399: Wrong query result when doing join buffering over
BIT
fields
Target fix: 5.1
Bug#39756: EXPLAIN
for uncorrelated
NOT EXISTS
query is slow
Target fix: 5.1
Bug#39433: poor optimized query
Target fix: 5.1
Server: Options
Bug#43835: SHOW VARIABLES
does not include 0
for slave_skip_errors
Target fix: 5.1
Server: Packaging
Bug#46834: Test suite missing from RPMs
Already fixed in: 5.1.39
Bug#43153: Version comment is too long
Target fix: 5.1.34
Bug#40845: Win inst shows screens with wrong naming "MySQL Monitoring and Advisory Service"
Target fix: 5.1.31
Bug#41838: shared-compat packages missing for Enterprise 5.1 builds
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
Target fix: 5.1.30
Bug#43918: Generated version string is too long for the binlog
Target fix: 5.1
Bug#44496: No "MySQL Manual" in Install-Package
Target fix: 5.1
Bug#45415: rpm upgrade recreates test database
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#41577: improper value in example config file
Target fix: 5.1
Bug#44353: build-v9.bat is missing in source archive
Target fix: 5.1
Bug#31143: mysqlslap.exe (and other) missing in windows install packages
Windows distributions are missing mysqlslap and a few other test-related programs.
Target fix: 5.1
Bug#41189: No debug symbols in 5.1.30 build for Mac
OSX
(mysql-5.1.30-osx10.5-x86.dmg)
Target fix: 5.1
Bug#37697: make_binary_distribution places files in wrong path
Target fix: 5.1
Server: Parser
Server: Partition
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#40176: Combination of event, trigger and partitioning breaks auto increment
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#37721: ORDER BY
when
WHERE
contains non-partitioned index column
Target fix: 5.1.31
Bug#40494: MYSQL
server crashes on range access
with partitioning and order by
Target fix: 5.1.30
Bug#45823: Assertion failure in file row/row0mysql.c line 1386
Target fix: 5.1
Bug#40515: Query on a partitioned table does not return 'lock wait timeout exceeded'
Target fix: 5.1
Bug#44821: select distinct on partitioned table returns wrong results
Target fix: 5.1
Bug#44653: Server crash noticed when executing random queries with partitions.
Target fix: 5.1
Bug#36001: Partitions: spelling and using some error messages
Target fix: 5.1
Bug#46354: Crash in partition_info::check_partition_info on inconsistent subpartitions
Already fixed in: 5.1
Bug#30102: Failed RENAME
of partitioned table
corrupts table files
Already fixed in: 5.1
Bug#45840: read_buffer_size allocated for each partition when "insert into.. select * from"
Target fix: 5.1
Bug#46362: Endpoint should be set to false for
TO_DAYS
(DATE
)
Target fix: 5.1
Bug#20577: Partitions: use of to_days() function leads to selection failures
Target fix: 5.1
Bug#45807: crash accessing partitioned table and sql_mode contains
ONLY_FULL_GROUP_BY
Target fix: 5.1
Bug#42944: partition not pruned correctly
Target fix: 5.1
Bug#38719: Partitioning returns a different error code for a duplicate key error
Target fix: 5.1
Bug#46922: crash when adding partitions and open_files_limit is reached
Target fix: 5.1
Bug#39893: Crash if select on a partitioned table, when partitioning is disabled
Target fix: 5.1
Bug#40972: Partition pruning can lead to crash for bad dates
Target fix: 5.1
Bug#45961: DDL
on partitioned innodb tables
leaves data dictionary in an inconsistent state
Target fix: 5.1
Bug#40389: REORGANIZE PARTITION
crashes when
only using one partition
Target fix: 5.1
Bug#46639: 1030 (HY000): Got error 124 from storage engine on
INSERT
... SELECT
...
Target fix: 5.1
Bug#47029: Server crash when reorganizing two partitions into one with same name as the 2nd
Target fix: 5.1
Bug#46923: select count(*) from partitioned table fails with
ONLY_FULL_GROUP_BY
Target fix: 5.1
Bug#46483: drop table of partitioned table may leave extraneous file
Target fix: 5.1
Bug#35845: unneccesary call to ha_start_bulk_insert for not used partitions
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#39084: Getting intermittent errors with statement-based binary logging
Target fix: 5.1
Bug#45816: assertion failure with index containing
DOUBLE
column on partitioned table
Already fixed in: 5.1
Bug#46478: timestamp field incorrectly defaulted when partition is reorganized
Target fix: 5.1
Server: Privileges
Bug#37191: Failed assertion in CREATE VIEW
Target fix: 5.1
Bug#46960: Users can obtain unauthorized information about objects
through SHOW CREATE VIEW
Target fix: 5.1
Bug#30305: Create routine in wrong context in SHOW
PRIVILEGES
Target fix: 5.1
Bug#45100: Incomplete DROP USER
in case of
SQL_MODE
=
'PAD_CHAR_TO_FULL_LENGTH
'
Target fix: 5.1
Server: Query Cache
Server: RBR
Bug#42977: RBR
logs for rows with more than 250
column results in corrupt binlog.
Target fix: 5.1.34
Bug#41986: Replication slave does not pick up proper
AUTO_INCREMENT
value for Innodb tables
Target fix: 5.1.31
Bug#40221: Replication failure on RBR
+
UPDATE
the primary key
Target fix: 5.1.31
Bug#40004: Replication failure with no PK
+ no
indexes
Target fix: 5.1.30
Bug#46640: output from mysqlbinlog command in 5.1 breaks replication
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#42941: --database paramater to mysqlbinlog fails with
RBR
Target fix: 5.1
Bug#39753: Replication failure on MIXED
+ bit +
myisam + no PK
Target fix: 5.1
Bug#45999: row based replication fails when auto_increment field = 0
Target fix: 5.1
Bug#42914: non-updated blob columns are included in
RBR
binlog record.
Target fix: 5.1
Bug#45243: crash on win in sql thread clear_tables_to_lock() -> free()
Target fix: 5.1
Bug#42749: infinite loop writing to row based binlog - processlist shows "freeing items"
Target fix: 5.1
Server: Replication
Bug#44581: Slave stops when transaction with non-transactional table gets lock wait timeout
Target fix: 5.1.37
Bug#40116: Uncommited changes are replicated and stay on slave after rollback on master
Target fix: 5.1.31
Bug#45827: Stmt using two autoinc values does not produce unsafe warning
Target fix: 5.4
Bug#28976: Mixing trans and non-trans tables in one transaction results in incorrect binlog
Target fix: 5.1
Bug#40482: server/mysqlbinlog crashes when reading invalid Incident_log_event
Target fix: 5.1
Bug#43579: mysql_upgrade tries to alter log tables on replicated database
Target fix: 5.1
Bug#42851: Spurious "Statement is not safe to log in statement format." warnings
Target fix: 5.1
Bug#46030: rpl_truncate_3innodb causes server crash on windows
Target fix: 5.1
Bug#41980: SBL
, INSERT
..
SELECT
.. LIMIT
=
ERROR
, even when
@@SQL_LOG_BIN
is 0 !
Target fix: 5.1
Bug#40796: Crash due to heap corruption in rpl.rpl_extraColmaster_myisam
Target fix: 5.1
Bug#38240: Crash in safe_mutex_lock () thr_mutex.c line 97 on rotate_relay_log ()
Target fix: 5.1
Bug#34739: unexpected binlog file name when --log-bin is set to a directory name
Target fix: 5.1
Bug#38174: secure-file-priv breaks LOAD DATA
INFILE
replication in statement mode
Target fix: 5.1
Bug#46129: Failing mixed stm (with trans and non-trans tables) causes wrong seq in binlog
Already fixed in: 5.1
Bug#35583: mysqlbinlog replay fails with ERROR
1146 when temp tables are used
Target fix: 5.1
Bug#47160: rpl_binlog_max_cache_size fails sporadically on PB2
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#44179: reset slave crashes in my_error when reset_logs returns non-zero
Target fix: 5.1
Bug#45825: INSERT DELAYED
is not unsafe: logged
in statement format
Target fix: 5.1
Bug#36763: TRUNCATE TABLE
fails to replicate
when stmt-based binlogging is not supported.
Target fix: 5.1
Bug#45694: Deadlock in replicated statement is not retried
Target fix: 5.1
Bug#34628: LOAD DATA CONCURRENT INFILE
drops
CONCURRENT
in binary log
Target fix: 5.1
Bug#38934: slave slave until does not work with --replicate-same-server-id
Target fix: 5.1
Bug#41948: Query_log_event constructor needlessly contorted
Target fix: 5.1
Bug#43046: mixed mode switch to row format with temp table lead to wrong result
Already fixed in: 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#38205: Row-based Replication (RBR
) causes
inconsistencies: HA_ERR_FOUND_DUPP_KEY
Target fix: 5.1
Bug#44041: ALTER DATABASE
change default
COLLATION
for following stmts of other
DB
on slave
Target fix: 5.1
Bug#44442: Incident events are silent in mysqlbinlog output
Target fix: 5.1
Bug#22504: load data infile sql statement in replication architechure get error
Target fix: 5.1
Bug#45677: Slave stops with Duplicate entry for key
PRIMARY
when using trigger
Target fix: 5.1
Bug#46130: Slave does not correctly handle "expected errors"
Target fix: 5.1
Bug#45242: crash on win in mysql_close() -> free()
Target fix: 5.1
Bug#42861: Assigning invalid directories to --slave-load-tmpdir crashes the slave
Target fix: 5.1
Bug#42829: binlogging enabled for all schemas regardless of binlog-db-db / binlog-ignore-db
Target fix: 5.1
Bug#41166: stored function requires "deterministic" if binlog_format is "statement"
Already fixed in: 5.1
Bug#39393: slave-skip-errors does not work when using
ROW
based replication
Target fix: 5.1
Bug#44270: RESET SLAVE
does not reset
Last_IO_Error or Last_IO_Errno
Target fix: 5.1
Bug#44331: Restore of database with events produces warning in replication
Target fix: 5.1
Bug#42415: UPDATE
with LIMIT
clause unsafe for statement format even when ORDER BY
PK
Target fix: 5.1
Bug#32228: A disk full makes binary log corrupt.
Target fix: 5.1
Bug#41961: Some log_event types do not skip post-header when reading
Target fix: 5.1
Bug#45214: get_master_version_and_clock does not report error when queries fail
Already fixed in: 5.1
Bug#46014: rpl_stm_reset_slave crashes the server sporadically in pb2
Target fix: 5.1
Bug#38197: Errors in @@init_slave not visible in 'show slave status'
Target fix: 5.1
Server: SE API
Bug#39053: UNISTALL PLUGIN
does not allow the
storage engine to cleanup open connections
Target fix: 5.1
Server: SP
Bug#42188: crash and/or memory corruption with user variables in trigger
Target fix: 5.1.32
Bug#38066: Events log 'note' level messages by default in the error log
Target fix: 5.1.31
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#34895: 'show procedure status' or 'show function status' + 'flush tables' crashes
Target fix: 5.1
Bug#45261: Crash, stored procedure + decimal
Target fix: 5.1
Bug#43884: SP
+ filename param as
TEXT
+ LOAD_FILE
inside,
causes valgrind warnings in PB
Target fix: 5.1
Bug#41726: upgrade from 5.0 to 5.1.30 crashes if you didn't run mysql_upgrade
Target fix: 5.1
Bug#43587: Putting event_scheduler=1 in init
SQL
file crashes mysqld
Already fixed in: 5.1
Bug#36540: CREATE EVENT
and ALTER
EVENT
statements fail with large server_id
Target fix: 5.1
Bug#45235: 5.1 does not support 5.0-only syntax triggers in any way
Target fix: 5.1
Server: Types
Server: Views
Server: XML
Tests: Replication
libmysqld
Bug#44091: libmysqld gets stuck waiting on mutex on initialization
Target fix: 5.1.35
Bug#43706: libmysqld segfaults when re-intialised
Target fix: 5.1
Bug#43733: Select on processlist let the embedded server crash (concurrent_innodb_safelog)
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#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#38522: 5 seconds delay when closing application using embedded server
Target fix: 5.1
User Comments
Add your own comment.