The following problems are known and fixing them is a high priority:
C API
Bug#43560: client crashes in mysql_stmt_execute/mysql_stmt_close after connection loss
Target fix: 5.1
Bug#40552: Race condition around default_directories in load_defaults()
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
Bug#48284: C99 aliasing violation, results in failures in the client library
Target fix: 5.1
Bug#47485: mysql_store result returns a result set for a prepared statement
Target fix: 5.1
Bug#47320: OpenSSL client does not check YaSSL server certificate
Target fix: 4.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#33048: Not able to recover binary/blob data correctly using mysqlbinlog
Target fix: 5.1
Bug#46310: mysql not handling <BACKSPACE
>
properly with multi-byte chars
Already fixed in: 5.1
Bug#34861: mysqldump with --tab gives weird output for triggers.
Target fix: 5.1
Bug#47655: Memory free error when connecting to 4.1 server from 5.1+ client
Target fix: 5.1
Bug#43594: mysqlhotcopy does not ignore log tables and others in mysql database
Target fix: 5.1
Bug#36391: mysqlbinlog creates invalid charset statements
Target fix: 5.1
Bug#46776: MySQL client confused by quotes, treats data as commands
Target fix: 5.1
Bug#52515: mysql sessions are not terminated properly
Target fix: 5.1
Bug#45740: mysqldump doesn't dump general_log and slow_query causes restore problem
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#40395: mysqladmin -i delay extended-status does not iterate with -r
Already fixed in: 5.1
Bug#46842: mysql_secure_installation ignores --socket, etc.
Target fix: 5.1
Bug#34129: mysqldumpslow does not aggregate times
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#50227: Pre-auth buffer-overflow in mySQL through yaSSL
Target fix: 5.1.43
Bug#48665: sql-bench's insert test fails due to wrong result
Target fix: 5.1.42
Bug#44166: Possible Security Vulnerability in MySQL Server 5.1.30
Target fix: 5.1.35
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#42563: Message tells me to repair table though Storage Engine doesn't allow me to.
Target fix: 5.1
Bug#46425: crash in Diagnostics_area::set_ok_status , empty
statement, DELETE IGNORE
Target fix: 5.1
Bug#50619: assert in handler::update_auto_increment
Target fix: 5.1
Bug#46614: Assertion in show_create_trigger() on SHOW
CREATE TRIGGER
+ MERGE
table
Target fix: 5.1
Bug#46760: Fast ALTER TABLE
no longer works for
InnoDB
Target fix: 5.1
Bug#44495: Prepared Statement: CALL
p(<x>) - `thd->protocol == &thd->protocol_text'
failed
Already fixed in: 5.1
Bug#46941: crash with lower_case_table_names=2 and foreign key data dictionary confusion
Target fix: 5.1
Bug#43435: LOCK_open does not use
MY_MUTEX_INIT_FAST
Already fixed in: 5.1
Bug#45638: Create temporary table with engine innodb fails
Target fix: 5.1
Bug#39494: please support >4GB key_buffer_size on windows
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#51648: DBUG_SYNC_POINT
is not defined on
all platforms and mtr can't pre-check that
Target fix: 5.1
Bug#47788: Crash in TABLE_LIST
::hide_view_error
on UPDATE IGNORE
+ VIEW
+
SP
+ ALTER
Target fix: 5.1
Bug#51591: deadlock in the plugins+status+variables
Target fix: 5.1
Bug#22891: session level max_allowed_packet can be set but is ignored
Target fix: 5.1
Bug#41057: mysql_update fails FATAL ERROR
:
Failed to create temporary file for defaults
Target fix: 5.1
Bug#43827: Server closes connections and restarts
Target fix: 5.1
Bug#40757: server crash after failed plugin/engine initialization
Target fix: 5.1
Bug#45613: handle failures from my_hash_insert
Target fix: 5.1
Bug#47919: assert in open_table during ALTER
temporary table
Target fix: 5.1
Bug#41030: Wrong meta data (incorrect fieldlen)
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#46944: Internal prepared XA
transction XIDs
are not removed if server_id changes
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#42503: "Lost connection" errors when using compression protocol
Target fix: 5.1
Bug#47412: Valgrind warnings / user can read uninitalized memory
using SP
variables
Target fix: 5.1
Bug#40230: 23 seconds difference while the time_zone is
SYSTEM
Target fix: 5.1
Bug#45058: init_available_charsets uses double checked locking
Target fix: 5.1
Bug#43354: Use key hint can crash server in explain extended query
Target fix: 5.1
Bug#46815: CONCAT_WS
returning wrong data
Target fix: 5.1
Bug#40949: Debug version of MySQL server crashes when run
OPTIMIZE
on compressed table.
Target fix: 5.1
Bug#20837: Apparent change of isolation level during transaction
Target fix: 5.1
Bug#11604: Performance degradation caused by do_div_mod() call
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#48327: Some crashes specific to FreeBSD ("embedded")
Target fix: 5.1
Bug#50373: --secure-file-priv=""
Target fix: 5.1
Bug#51468: mysqld_multi is broken in 5.1.44
Target fix: 5.1
Bug#31616: div_precision_increment description looks wrong
Target fix: 5.1
Bug#49334: add_to_status() race conditions
Target fix: 5.1
Bug#42144: plugin_load fails
Target fix: 5.1
Bug#38941: fast mutexes in MySQL 5.1 have mutex contention when calling random()
Target fix: 5.1
Bug#45336: --enable-foobar doesn't work for any plugin foobar.
Target fix: 5.1
Bug#46539: Various crashes on INSERT IGNORE
SELECT
+ SELECT FOR UPDATE
Target fix: 5.1
Bug#41078: With CURSOR_TYPE_READ_ONLY
mysql_stmt_fetch() returns short string value.
Target fix: 5.1
Bug#49628: corrupt table after legal SQL
,
LONGTEXT
column
Target fix: 5.1
Bug#40877: multi statement execution fails in 5.1.30
Target fix: 5.1
Server: Archive
Bug#48757: missing .ARZ
file causes server
crash
Target fix: 5.1
Bug#46961: archive engine loses rows during self joining select!
Target fix: 5.1
Bug#29203: archive tables have weird values in show table status
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#47012: archive tables are not upgradeable, and server crashes on any 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#42784: archive tables cause 100% cpu usage and hang in show table status
Target fix: 5.1
Bug#32880: Repairing Archive table fails with internal error 144
Target fix: 5.1
Bug#46565: repair of partition fail for archive engine
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#51976: LDML
collations issue (cyrillic
example)
Target fix: 5.1
Bug#43207: wrong LC_TIME
names for romanian
locale
Target fix: 5.1
Bug#45012: my_like_range_cp932 generates invalid string
Target fix: 5.1
Bug#41084: full-text index added to custom UCA
collation not working
Target fix: 5.1
Bug#44834: strxnmov is expected to behave as you'd expect
Target fix: 5.1
Bug#43593: dump/backup/restore/upgrade tools fails
Target fix: 5.1
Bug#51876: crash/memory underrun when loading data with ucs2 and reverse() function
Target fix: 5.1
Bug#46448: trailing spaces are not ignored when user collation maps space != 0x20
Target fix: 5.1
Bug#45485: replication different between master/slaver using procedure with gbk
Target fix: 5.1
Bug#49501: Inefficient information_schema check (system collation)
Target fix: 5.1
Bug#32831: libmysql should be built with all charsets
Target fix: 5.1
Bug#45645: Mysql server close all connection and restart using lower function
Target fix: 5.1
Server: Cluster
Bug#47564: funcs_1.ndb_trig_1011ext.test is disabled
Target fix: 5.1
Server: Compiling
Bug#51009: src build failure on SuSe (LT_INIT
:
command not found)
Target fix: 5.1.45
Bug#50059: IBMDB2I storage engine not included in 64-bit MySQL 5.1.42
Target fix: 5.1.43
Bug#46935: No 64-bit version of the MySQL Preference Pane is available
Target fix: 5.1.42
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#42721: configure.in invokes 'nm' directly
Target fix: 5.1
Bug#45616: Fixing build when building in other directory
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#38697: utf8_general_cs cannot be used with Windows?
Target fix: 5.1
Bug#43449: Undefined symbol __1cG__CrunMex_rethrow_q6F_v_ when compiling using Sun Studio
Target fix: 5.1
Bug#38364: gen_lex_hash segmentation fault in debug build
Target fix: 5.1
Bug#39288: MySQL Embedded server (libmysqld.a) is built without -fPIC flag
Target fix: 5.1
Bug#40862: main.subselect_notembedded test case fails
Target fix: 5.1
Bug#42599: error: `pthread_setschedprio' was not declared in this scope
Target fix: 5.1
Bug#47857: strip_sp function in mysys/mf_strip.c never used and cause name clash
Target fix: 5.1
Bug#47957: A build "--without-server" fails if using "--with-ssl" (YaSSL)
Target fix: 5.1
Bug#50850: 32-bit builds for IBM
i should have
maxdata increased
Target fix: 5.1
Bug#49968: Properly define HAVE_ERRNO_AS_DEFINE
for the appropriate OpenBSD releases.
Target fix: 5.1
Bug#45288: pb2 returns a lot of compilation warnings on linux
Target fix: 5.1
Bug#47360: Can't build universal x86_64/i386: Undefined symbols for architecture x86_64
Target fix: 5.1
Bug#39630: AIX
5.3 64-bit binaries are too slow
Target fix: 5.1
Bug#39102: valgrind build does not compile in realpath, which make
DATA
/INDEX DIR
fail
Target fix: 5.1
Bug#49502: CMake error compiling 5.1 on Windows
Target fix: 5.1
Bug#47337: innochecksum not built for --with-plugin-innodb_plugin --without-plugin-innobase
Target fix: 5.1
Bug#35250: readline check breaks when doing vpath build
Target fix: 5.1
Bug#31506: detection of function's availability is wrong in configure.in
Target fix: 5.1
Bug#46995: Missing build dependency between include/mysql.h and libmysql*/client.o
Target fix: 5.1
Bug#39571: abi_check: Does not create all prerequisites
Target fix: 5.1
Bug#25404: mysql_config need several issues corrected
Target fix: 5.1
Bug#49093: 5.1 configure script should warn about MySQL Cluster not being maintained
Target fix: 5.1
Bug#46980: Option "--without-server" still not working in 5.1
Target fix: 5.1
Bug#45706: rpm install fails due to incorrect libc linking
Target fix: 5.1
Bug#47850: too many files built in regex/
Target fix: 5.1
Bug#47795: CMake, storage engine name different from directory name
Target fix: 5.1
Bug#42872: In MySQL 5.1.31, unrecognized --with-innodb, --with-partition, --with-federated
Target fix: 5.1
Bug#45113: mysql_config returns incorrect path if built with prefix != execprefix
Target fix: 5.1
Bug#42141: Compiler crash in "mf_format.c" when optimizing for 64 bit
Target fix: 5.1
Bug#46309: MySQL 5.1.36 fails to compile using
ICC
11.1
Target fix: 5.1
Bug#47797: CMake, engine can't specify additional libraries to link with
Bug#33991: MySQL (6.0-bk) does not compile on Solaris Express Developer Edition
Target fix: 6.0-rc
Server: Config Wizard
Bug#42386: MySQL .msi installer does not start configuration wizard on Vista when prompted
Target fix: 5.1.33
Bug#50122: Configuration wizard cannot reconfigure instance,
freezes and takes 100% CPU
Target fix: 5.1
Bug#37294: Windows .msi - 'Repair' option doesn't back out as expected
Target fix: 5.1
Bug#44428: Cannot recreate instance after clean install (apply security settings fails)
Already fixed in: 5.1
Bug#48835: Instance config window too small
Target fix: 5.1
Bug#38723: MySQL Configuration Wizard on Vista unreadable
Already fixed in: 5.1
Bug#47971: Cannot finish Windows Config Wizard on Czech operating system due "my.ini"
Target fix: 5.1
Bug#46146: Configuration wizard fails if the service already exists
Target fix: 5.1
Server: DB2SE for IBM i
Bug#49203: Latin1 German collation using CCSID
1148 in DB2
Target fix: 5.1
Bug#44856: IBMDB2I gives misleading 2504 error
Target fix: 5.1
Bug#43343: ibmdb2i Storage Engine does not honor timezone settings
with INSERT
Target fix: 5.1
Bug#49205: Cardinality NULL
of index over
UTF
-8 collation field
Target fix: 5.1
Bug#44020: Unicode Swedish collations not working with IBMDB2I
Target fix: 5.1
Bug#45983: ibmdb2i_create_index_option=1 not working for primary key
Target fix: 5.1
Bug#45196: Some collations do not sort correctly 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#44811: Tests with utf8 charset fail with ibmdb2i on 64bit MySQL
Target fix: 5.1
Bug#46730: Tables created witn SE
IBMDB2I show
incorr update and create timestamps
Target fix: 5.1
Bug#45803: Inaccurate estimates for partial key values with IBMDB2I
Target fix: 5.1
Bug#49521: SHOW CREATE TABLE
on IBMDB2I tables
has incorrect fk constraint format
Target fix: 5.1
Bug#44025: Some schema names longer than 8 characters not supported by IBMDB2I
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#45829: CREATE TABLE TRANSACTIONAL PAGE_CHECKSUM
ROW_FORMAT
=PAGE
accepted, does
nothing
Already fixed in: 5.1
Bug#35796: SHOW CREATE TABLE
and default value
for BIT
field
Target fix: 5.1
Bug#52484: Incorrect handling of column types causes fast
ALTER TABLE
failure on enum types
Target fix: 5.1
Bug#48645: Dropping an unique key and adding one leads to a table corruption
Target fix: 5.1
Bug#41041: Obsolete debug code can be used to crash server
Target fix: 5.1
Bug#40277: SHOW CREATE VIEW
returns invalid
SQL
Target fix: 5.1
Bug#41465: confusing error message when comment is too long
Target fix: 5.1
Bug#40886: ALTER TABLE
statements appear to
randomly fail on Mac OS
10.4
Target fix: 5.1
Bug#39372: "Smart" ALTER TABLE
not so smart
after all.
Target fix: 5.1
Bug#48449: hang on show create view after upgrading when view contains function of view
Target fix: 5.1
Bug#47576: TRUNCATE TABLE
for temporary tables
maps to DROP TABLE
Target fix: 5.1
Bug#43508: Renaming timestamp or date column triggers table copy
Target fix: 5.1
Bug#45567: Fast ALTER TABLE
broken for enum and
set
Target fix: 5.1
Bug#31145: ALTER TABLE DROP COLUMN
,
ADD COLUMN
crashes (linux) or freezes (win)
the server
Target fix: 5.1
Bug#50946: fast index creation still seems to copy the table
Target fix: 5.1
Bug#49838: DROP INDEX
and ADD UNIQUE
INDEX
for same index may corrupt definition at engine
Target fix: 5.1
Server: DML
Bug#48985: show create table crashes if previous access to the table was killed
Target fix: 5.1.42
Bug#39920: MySQL cannot deal with Leap Second expression in string literal.
Target fix: 5.0.74
Bug#46259: 5.0.83 -> 5.1.36, query doesn't work
Target fix: 5.1
Bug#33844: Server crashes when client dies during LOAD
DATA INFILE
Target fix: 5.1
Bug#51598: Inconsistent behaviour with a
COALESCE
statement inside an
IN
comparison
Target fix: 5.1
Bug#43385: Cannot ALTER DATABASE
...
UPGRADE DATA DIRECTORY NAME
when Views exist
Target fix: 5.1
Bug#45962: memory leak after 'sort aborted' errors
Target fix: 5.1
Bug#44306: Assertion fail on duplicate key error in
'INSERT
... SELECT
'
statements
Target fix: 5.1
Bug#41156: List of derived tables acts like a chain of mutually-nested subqueries
Target fix: 5.1
Bug#52160: crash and inconsistent results when grouping by a function and column
Target fix: 5.1
Bug#33717: INSERT
...(default) fails for enum.
Crashes CSV
tables, loads spaces for MyISAM
Target fix: 5.1
Bug#44768: SIGFPE
crash when selecting rand
from a view containing null
Target fix: 5.1
Bug#49534: multitable IGNORE
update with
sql_safe_updates error causes debug assertion
Target fix: 5.1
Bug#38693: leaked memory with blobs!
Target fix: 5.1
Bug#44399: crash with statement using TEXT
columns, aggregates, GROUP BY
, and
HAVING
Target fix: 5.1
Bug#44743: Join in combination with concat does not always work
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#47650: using group by with rollup without indexes returns incorrect results with where
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
Bug#47453: InnoDB incorrectly changes TIMESTAMP
columns when JOINed during an UPDATE
Server: Errors
Bug#49025: mysqld-debug: missing DBUG_RETURN
or
DBUG_VOID_RETURN
macro in function "?func"
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#48042: The description for Event ID
( 100 )
in Source ( MySQL ) cannot be found. The lo
Target fix: 5.1
Bug#48451: my_seek and my_tell ignore MY_WME
flag
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
Bug#51638: SBR
logging warning messages for
primary key updates with a LIMIT
of 1
Target fix: 5.1
Bug#42364: SHOW ERRORS
returns empty resultset
after dropping non existent table
Target fix: 5.1
Server: FTS
Bug#47930: MATCH IN BOOLEAN MODE
returns too
many results inside subquery
Target fix: 5.1
Bug#39640: ftb_query_add_word does not recognice
MYSQL_FTFLAGS_NEED_COPY
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#39746: Debug flag breaks struct definition (server crash)
Target fix: 5.1
Bug#50351: ft_min_word_len=2 Causes query to hang
Target fix: 5.1
Bug#28234: global/session scope - documentation vs implementation
Target fix: 5.1
Server: GIS
Server: General
Bug#50096: CONCAT_WS
inside procedure returning
wrong data
Target fix: 5.1.44
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#40915: Events takes mutex in wrong order which can easily lead to deadlocks
Target fix: 5.1
Bug#45548: XA
transaction without access to
InnoDB tables crashes the server
Target fix: 5.1
Bug#44365: valgrind warnings with encrypt() function
Target fix: 5.1
Bug#39265: SQL_MODE
OLD_NOT_NULL_CHECK_BEHAVIOUR
for backward
compatibility
Target fix: 5.1
Bug#45998: database crashes when running "create as select" (innodb table)
Already fixed in: 5.1
Bug#44164: TL_WRITE
has no description in
lock_descriptions[]
Target fix: 5.1
Bug#37168: Missing variable - skip_name_resolve
Target fix: 5.1
Bug#44367: valgrind warnings with find_in_set() functions
Target fix: 5.1
Bug#37284: Crash in Field_string::type()
Target fix: 5.1
Bug#38249: innodb_log_arch_dir still in support files
Target fix: 5.1
Bug#40104: regression with table names?
Target fix: 5.1
Bug#49141: Encode function is significantly slower in 5.1 compared to 5.0
Target fix: 5.1
Bug#43606: 4GB Limit on huge_pages shared memory set-up
Target fix: 5.1
Bug#47382: 'mysqladmin debug' crash on 64-bit windows
Target fix: 5.1
Bug#52107: Comment in sql/net_serv.cc still makes
"GPL
protocol" claim
Target fix: 5.1
Bug#44358: valgrind errors with decode() function
Target fix: 5.1
Bug#41612: resolve_stack_dump does not decode 5.1 stack trace
Target fix: 5.1
Bug#41710: MySQL 5.1.30 crashes on the latest OpenSolaris 10
Target fix: 5.1
Bug#48086: mysql_secure_installation does NOT
work on Solaris
Target fix: 5.1
Bug#38477: my_pthread_setprio can change dispatch class on Solaris, not just priority
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#42146: DATETIME
fractional seconds parse
error
Target fix: 5.1
Bug#51304: checksum table gives different results for same data when using bit fields
Target fix: 5.1
Bug#46261: Plugins can be installed with --skip-grant-tables
Target fix: 5.1
Bug#45309: InnoDB does not rollback for delete and update queries if query was killed
Target fix: 5.1
Bug#30261: "mysqld --help" no longer possible for root
Target fix: 5.1
Bug#49491: Much overhead for MD5() and SHA1() on short strings
Target fix: 5.1
Bug#44664: valgrind warning for
COMMIT_AND_CHAIN
and
ROLLBACK_AND_CHAIN
Target fix: 5.1
Bug#50780: 'show binary logs' debug assertion when binary logging is disabled
Target fix: 5.1
Bug#52629: memory leak from sys_var_thd_dbug in binlog.binlog_write_error
Target fix: 5.1
Bug#10206: InnoDB: Transaction requiring Max_BinLog_Cache_size > 4GB always rollsback.
Target fix: 5.1
Bug#44638: mysql_upgrade, mysqlcheck output instance unclear
Target fix: 5.1
Bug#42158: leak: SSL_get_peer_certificate() doesn't have matching X509_free()
Target fix: 5.1
Bug#46895: Test "outfile_loaddata" fails (reproducible)
Target fix: 5.1
Bug#42957: no results from select where .. (col=col and col=col) or ... (false expression)
Target fix: 5.1
Bug#40657: assertion with out of range variables and traditional sql_mode
Target fix: 5.1
Bug#44736: mysqld_safe's my_which() is broken and doesn't find 'logger'
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#48525: trigger changes "Column 'id' cannot be null" behaviour
Target fix: 5.1
Bug#43962: "Packets out of order" calling a SHOW TABLE
STATUS
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#38918: selecting from information_schema.columns is disproportionately slow
Target fix: 5.1
Bug#48729: SELECT
... FROM
INFORMATION_SCHEMA
.ROUTINES
causes
memory to grow
Target fix: 5.1
Bug#35789: wrong datatypes for collation and charset columns in
EVENTS
, ROUTINES
,
TRIGGERS
Target fix: 5.1
Bug#51377: Crash in information_schema / processlist on concurrent
DDL
workload
Target fix: 5.1
Bug#50276: Security flaw in
INFORMATION_SCHEMA
.TABLES
Target fix: 5.1
Bug#38909: CREATE_OPTIONS
in information_schema
produces wrong results
Target fix: 5.1
Bug#51208: Extra string allocation from thd->mem_root in sql_show.cc, find_files()
Target fix: 5.1
Bug#35275:
INFORMATION_SCHEMA
.TABLES
.CREATE_OPTIONS
omits KEY_BLOCK_SIZE
Target fix: 5.1
Bug#42758:
INFORMATION_SCHEMA
.COLUMNS
is inconsistent
Target fix: 5.1
Bug#39955: SELECT
on
INFORMATION_SCHEMA
.GLOBAL_VARIABLES
takes too long
Target fix: 5.1
Bug#29900: MySQL does not return an error to the client if
INFORMAT SCHEMA
fill table fails
Server: InnoDB
Bug#46193: crash when accessing tables after enabling innodb_force_recovery option
Target fix: 5.1.44
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#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#49032: auto_increment field does not initialize to last value in InnoDB Storage Engine
Target fix: 5.1
Bug#49497: Error 1467 (ER_AUTOINC_READ_FAILED
)
on inserting a negative value
Target fix: 5.1
Bug#47233: Innodb calls
push_warning(MYSQL_ERROR
::WARN_LEVEL_ERROR
)
Target fix: 5.1
Bug#39648: Replication failure on RBR
+ Innodb
+ 2 bit fields + LIMIT
+ no
PK
Target fix: 5.1
Bug#49238: Creating/Dropping a temporary table while at 1023 transactions will cause assert
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#45749: Race condition in SET GLOBAL
innodb_commit_concurrency=DEFAULT
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#47991: InnoDB Dictionary Cache memory usage increases indefinitely when renaming tables
Target fix: 5.1
Bug#45097: Hang during recovery, redo logs for doublewrite buffer pages
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#35498: Cannot get table test/table1 auto-inccounter value in ::info
Target fix: 5.1
Bug#46965: crash in ha_innobase::get_auto_increment
Target fix: 5.1
Bug#41609: Crash recovery does not work for InnoDB temporary tables
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#40369: dtype_get_sql_null_size() returns 0 or 1, not the size
Target fix: 5.1
Bug#49001: SHOW INNODB STATUS
deadlock info
incorrect when deadlock detection aborts
Target fix: 5.1
Bug#38189: innodb_stats_on_metadata missing
Target fix: 5.1
Bug#39830: Table autoinc value not updated on first insert
Target fix: 5.1
Bug#37885: row_search_for_mysql may gap lock unnecessarily with
SQL
comments in query
Target fix: 5.1
Bug#42101: Race condition in innodb_commit_concurrency
Target fix: 5.1
Bug#42714: AUTO_INCREMENT
errors in 5.1.31
Target fix: 5.1
Bug#41671: Semi-consistent read does not unlock rows in
READ COMMITTED
mode
Target fix: 5.1
Bug#38231: Innodb crash in lock_reset_all_on_table() on
TRUNCATE
+ LOCK
/
UNLOCK
Target fix: 5.1
Bug#52062: Compiler warning in os0file.c on windows 64-bit
Target fix: 5.1
Bug#42279: Race condition in btr_search_drop_page_hash_when_freed()
Target fix: 5.1
Bug#51920: Innodb connections in row lock wait ignore
KILL
until lock wait timeout
Target fix: 5.1
Bug#42400: InnoDB autoinc code can't handle floating-point columns
Target fix: 5.1
Bug#43660: SHOW
INDEXES
/ANALYZE
does
NOT
update cardinality for indexes of InnoDB
table
Target fix: 5.1
Bug#44320: InnoDB: missing DB_ROLL_PTR
in Table
Monitor COLUMNS
output
Target fix: 5.1
Bug#48024: Innodb doesn't work with multi-statements
Target fix: 5.1
Bug#43203: Overflow from auto incrementing causes server segv
Target fix: 5.1
Bug#46256: drop table with unknown collation crashes innodb
Target fix: 5.1
Bug#42152: Race condition in lock_is_table_exclusive()
Target fix: 5.1
Bug#49164: READ
-COMMITTED
reports "matched: 0" on compound PK
Target fix: 5.1
Bug#42075: dict_load_indexes failure in dict_load_table will corrupt the dictionary cache
Target fix: 5.1
Bug#42383: main.innodb_bug39438: Can't create table 'test.bug39438'
Target fix: 5.1
Bug#47621: MySQL and InnoDB data dictionaries will become out of sync when renaming columns
Target fix: 5.1
Bug#50691: AIX
implementation of readdir_r
causes InnoDB errors
Bug#3139: Mysql crashes: "windows error 995" after several
selects on a large DB
Server: InnoDB Plugin
Bug#48782: On lock wait timeout, CREATE INDEX
(creating primary key) attempts DROP TABLE
Target fix: 5.1.42
Bug#52360: Innodb assertion wait_lock in lock/lock0lock.c on
UPDATE
Target fix: 5.1
Bug#35077: Very slow DROP TABLE
(ALTER
TABLE
, OPTIMIZE TABLE
) on
compressed tables
Target fix: 5.1
Bug#44571: InnoDB Plugin crashes on ADD INDEX
Target fix: 5.1
Bug#46657: InnoDB plugin: invalid read in index_merge_innodb test (Valgrind)
Target fix: 5.1
Bug#46718: InnoDB plugin incompatible with gcc 4.1 (at least: on
PPC
): "Undefined symbol"
Target fix: 5.1
Bug#46656: InnoDB plugin: memory leaks (Valgrind)
Target fix: 5.1
Bug#48237: Error handling in os_mem_alloc_large appears to be incorrect
Target fix: 5.1
Bug#50495: 'Row size too large' for plugin, but works for built-in innodb
Target fix: 5.1
Bug#39200: optimize table does not recognize
ROW_FORMAT
=COMPRESSED
Target fix: 5.1
Bug#47809: innodb-autoinc.test fails with valgrind errors with the innodb plugin
Target fix: 5.1
Bug#47058: failure to compile innodb_plugin on solaris 10u7 + spro
cc/CC
5.10
Target fix: 5.1
Bug#47167: "set global innodb_file_format_check" cannot set value by User-Defined Variable
Target fix: 5.1
Bug#37788: InnoDB Plugin: AUTO_INCREMENT
wrong
for compressed tables
Target fix: 5.1
Bug#49535: Available memory check slows down crash recovery tens of times
Target fix: 5.1
Bug#46672: InnoDB plugin: consider porting to the plugin some bugfixes made to the builtin
Target fix: 5.1
Bug#52102: InnoDB Plugin shows performance drop compared to InnoDB (Windows)
Target fix: 5.1
Server: Installing
Bug#45418: 'MySQL Server 5.1 Setup Wizard ended prematurely' message during .msi install
Already fixed in: 5.1.38
Bug#49823: mysql_upgrade fatal error due to general_log / slow_low
CSV NULL
Target fix: 5.1
Bug#41828: mysql_install_db misses mysqld options when using --basedir
Target fix: 5.1
Bug#29716: mysql_install_db refers to the (obsolete) mysqlbug script during installation
mysql_install_db output needs to refer to the online bugs database rather than to the obsolete mysqlbug script.
Target fix: 5.1
Bug#48694: mysql-install-db.pl does not correctly handle --srcdir on Windows
Target fix: 5.1
Bug#52047: The syntax '--default-character-set' is deprecated
Target fix: 5.1
Bug#29595: error in service mysql restart
Target fix: 5.1
Bug#41313: network administrator does not have
TRIGGER
and EVENT
privileges
Target fix: 5.1
Bug#48695: mysql-install-db.pl does not account for --lc-messages-dir
Target fix: 5.1
Bug#48031: mysql_secure_installation -- bash bug regarding passwords with special chars
Target fix: 5.1
Bug#44073: 'could not start service' message but service starts anyway!
Target fix: 5.1
Bug#17270: mysql client tool could not find ../share/charsets folder and fails.
Target fix: 5.1
Bug#52274: Missing path to mysql in mysql_secure_installation
Target fix: 5.1
Bug#46258: Windows Install zaps prev. instance, even though basedir is different
Target fix: 5.1
Bug#38073: new default <datadir> does not globally apply
Target fix: 5.1
Bug#42820: MySQL not starting due to InnoDB failure
Target fix: 5.1
Server: Locking
Bug#41756: Strange error messages about locks from InnoDB
Target fix: 5.1.41
Bug#41348: INSERT INTO
tbl
SELECT
* FROM
temp_tbl
overwrites locking type of temp table
Target fix: 5.1.31
Bug#43171: 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#47924: main.log_tables times out sporadically
Target fix: 5.1
Bug#39843: DELETE
requires write access to
table in subquery in where clause
Target fix: 5.1
Bug#47682: strange behaviour of INSERT DELAYED
Target fix: 5.1
Bug#33278: ANALYZE TABLE
in InnoDB holds
exclusive locks on subsequent execution
Target fix: 5.1
Bug#44672: Assertion failed: thd->transaction.xid_state.xid.is_null()
Target fix: 5.1
Bug#46947: Embedded SELECT
without FOR
UPDATE
is causing a lock
Target fix: 5.1
Bug#51855: Race condition in XA START
Target fix: 5.1
Bug#46456: HANDLER OPEN
+
TRUNCATE
+ DROP
(temporary) TABLE
, crash
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#49756: Rows_examined is always 0 in the slow query log for update statements
Target fix: 5.1
Bug#48318: The "debug_sync" mechanism doesn't work correctly (on one platform)
Target fix: 5.1
Bug#47905: stored procedures with multiple statements not being logged to slow query log
Target fix: 5.1
Bug#40281: partitioning the general log table crashes the server
Already fixed in: 5.1
Bug#29751: renaming server logs at FLUSH LOGS
Target fix: 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#41305: server crashes when inserting duplicate row into a merge table
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
Bug#45800: crash when replacing into a merge table and there is a duplicate
Already fixed in: 5.1
Bug#45796: invalid memory reads and writes when altering merge and base tables
Target fix: 5.1
Bug#45781: infinite hang/crash in "opening tables" after handler tries to open merge table
Already fixed in: 5.1
Bug#48265: MRG_MYISAM
problem (works in 5.0.85,
does't work in 5.1.40)
Target fix: 5.1
Server: MyISAM
Bug#43932: myisam index corruption with large index and large key_buffer_size
Target fix: 5.1.35
Bug#41574: REPAIR TABLE
: crashes for compressed
tables
Target fix: 5.1.31
Bug#40827: Killing insert-select to MyISAM can cause table corruption
Target fix: 5.1
Bug#47073: valgrind errs, corruption,failed repair of partition,low myisam_sort_buffer_size
Target fix: 5.1
Bug#37756: enabling fulltext indexes with myisam_repair_threads > 1 causes crash
Target fix: 5.1
Bug#51868: crash with myisam_use_mmap and partitioned myisam tables
Target fix: 5.1
Bug#35111: Truncate a MyISAM partitioned table does not reset the auto_increment value.
Target fix: 5.1
Bug#47598: MyISAM may write uninitialized data to disk
Target fix: 5.1
Bug#43940: 64-bit windows myisamchk doesn't support key_buffer_size > 4G
Target fix: 5.1
Bug#51307: widespread corruption with partitions and insert...select
Target fix: 5.1
Bug#38848: myisam_use_mmap causes widespread myisam corruption on windows
Target fix: 5.1
Bug#49902: SELECT
returns incorrect results
Target fix: 5.1
Bug#50390: mysqld crashes when trying to access specific myisam table
Target fix: 5.1
Bug#37631: Incorrect key file for table after upgrading from 5.0 to 5.1
Target fix: 5.1
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#51877: HANDLER
interface causes invalid
memory read
Target fix: 5.1
Bug#47444: --myisam_repair_threads>1can result in all index cardinalities=1
Target fix: 5.1
Server: Optimizer
Bug#52336: Segfault / crash in 5.1 copy_fields (param=0x9872980) at sql_select.cc:15355
Target fix: 5.1.46
Bug#50995: Having clause on subquery result produces incorrect results.
Target fix: 5.1.45
Bug#48370: Absolutely wrong calculations with GROUP
BY
and decimal fields when using IF
Target fix: 5.1.42
Bug#47963: Wrong results when index is used
Target fix: 5.1.41
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#44290: crash in
SQL_SELECT
::test_quick_select for query with
distinct or order/group by
Target fix: 5.1.35
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#45195: valgrind warnings about uninitialized values in store_record_in_cache()
Target fix: 5.1
Bug#52120: create view cause Assertion failed: 0, file .\item_subselect.cc, line 817
Target fix: 5.1
Bug#48537: difference of index selection between rpm binary and .tar.gz, windows vs linux..
Target fix: 5.1
Bug#52051: Aggregate functions incorrectly returns
NULL
from outer join query
Target fix: 5.1
Bug#51242: HAVING
clause on table join produce
incorrect results
Target fix: 5.1
Bug#41660: Sort-index_merge for non-first join table may require O(#scans) memory
Target fix: 5.1
Bug#48177: SELECTs with NOT IN
subqueries
containing NULL
values return too many
records
Target fix: 5.1
Bug#46051: Selects with a subquery sporadically return wrong data
Already fixed in: 5.1
Bug#45640: optimizer bug produces wrong results
Target fix: 5.1
Bug#47649: crash during CALL
procedure
Target fix: 5.1
Bug#51983: OUTER
JOINs with
WHERE
condition may produce incorrect results
Target fix: 5.1
Bug#46629: Item_in_subselect::val_int(): Assertion `0' on subquery
inside a SP
Target fix: 5.1
Bug#46175: NULL
read_view and consistent read
assertion
Target fix: 5.1
Bug#50939: Loose Index Scan unduly relies on engine to remember range endpoints
Target fix: 5.1
Bug#47669: Query showed by EXPLAIN EXTENDED
gives different result from original query
Target fix: 5.1
Bug#48459: valgrind errors with query using 'Range checked for each record'
Target fix: 5.1
Bug#46159: simple query that never returns
Target fix: 5.1
Bug#45828: Optimizer won't use partial primary key if another index can prevent filesort
Target fix: 5.1
Bug#44139: Table scan when NULL
appears in
IN
clause
Target fix: 5.1
Bug#47904: Incorrect results w/ table subquery, derived SQs, and
LEFT JOIN
on index
Target fix: 5.1
Bug#47280: strange results from count(*) with order by multiple columns without where/group
Target fix: 5.1
Bug#49445: Assertion failed: 0, file .\item_row.cc, line 55 with fulltext search and row op
Target fix: 5.1
Bug#44886: SIGSEGV
in test_if_skip_sort_order()
- uninitialized variable used as subscript
Target fix: 5.1
Bug#48258: Assertion failed when using a spatial index
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#51070: Query with a NOT IN
subquery
predicate returns a wrong result set
Target fix: 5.1
Bug#50394: Regression in EXPLAIN
with index
scan, LIMIT
, GROUP BY
and
ORDER BY
computated c
Target fix: 5.1
Bug#39653: find_shortest_key in sql_select.cc does not consider clustered primary keys
Target fix: 5.1
Bug#46791: Assertion failed:(table->key_read==0),function unknown function,file sql_base.cc
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#46003: Valgrind warning in JOIN
::init()
Already fixed in: 5.1
Bug#49506: Valgrind error in make_cond_for_table_from_pred
Target fix: 5.1
Bug#47123: Endless 100% CPU
loop with
STRAIGHT_JOIN
Target fix: 5.1
Bug#43029: FORCE INDEX FOR ORDER BY
is ignored
when join buffering is used
Target fix: 5.1
Bug#45989: memory leak after explain encounters an error in the query
Target fix: 5.1
Bug#41543: Assertion `m_status == DA_ERROR
'
failed in Diagnostics_area::sql_errno
Target fix: 5.1
Bug#49324: more valgrind errors in test_if_skip_sort_order
Target fix: 5.1
Bug#48916: Server incorrectly processing HAVING
clauses with an ORDER BY
clause
Target fix: 5.1
Bug#42785: mysql gives the wrong result with some special usage
Target fix: 5.1
Bug#50843: Optimizer ignores clustered index for GROUP
BY
even when it improves performance
Target fix: 5.1
Bug#47150: Assertion in Field_long::val_int() on
MERGE
+ TRIGGER
+
multi-table UPDATE
Target fix: 5.1
Bug#50389: Using intersect does not return all rows
Target fix: 5.1
Bug#48703: nontrivial ORDER
/GROUP
BY
expressions: ambiguous statements not detected
Target fix: 5.1
Bug#37936: ASSERT_COLUMN_MARKED_FOR_WRITE
in
Field_datetime::store , Field_varstring::store
Target fix: 5.1
Bug#45360: wrong results
Target fix: 5.1
Bug#31399: Wrong query result when doing join buffering over
BIT
fields
Target fix: 5.1
Bug#51431: Wrong sort order after import of dump file
Target fix: 5.1
Bug#47762: Incorrect result from MIN
() when
WHERE
tests NOT NULL
column for NULL
Target fix: 5.1
Bug#47761: crash when killing a query during subquery execution...
Target fix: 5.1
Bug#39022: Mysql randomly crashing in lock_sec_rec_cons_read_sees
Server: Options
Server: PS
Bug#42496: server debug assertion after mysql_stmt_fetch is killed
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#34025: mysql_config is not returning -ldl lib flag needed when using embedded server
Target fix: 5.1.31
Bug#41838: shared-compat packages missing for Enterprise 5.1 builds
Target fix: 5.1.31
Bug#39074: Binaries do not work on Solaris 10 older than U5
Target fix: 5.1.30
Bug#41577: improper value in example config file
Target fix: 5.1
Bug#48186: MySQL Instance Config Wizard/MySQL Instance Manager
Target fix: 5.1
Bug#52319: MySQL RHEL5 RPMs do not Require net-tools
Target fix: 5.1
Bug#44496: No "MySQL Manual" in Install-Package
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#36409: Windows installer changes needed for Vista Certification.
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#51293: emacs backup file present in MySQL 5.1.44 release.
Target fix: 5.1
Bug#43918: Generated version string is too long for the binlog
Target fix: 5.1
Bug#49707: Files with long names not included in distribution.
Target fix: 5.1
Bug#44353: build-v9.bat is missing in source archive
Target fix: 5.1
Bug#46216: License header size differences again
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#50021: Windows standard configuration files are showing Linux options/settings
Target fix: 5.1
Bug#41728: Dropped symbol but no soname change
Target fix: 5.1
Bug#49800: libstdc++ dependency (was: Provide 64bit icc binaries linked against libstdc++6)
Target fix: 5.1
Bug#48420: Windows binaries
Docs/INSTALL
-BINARY
contains Unix-only instructions
Target fix: 5.1
Bug#49723: support-files/mysql.spec.sh has unwanted Perl dependencies
Target fix: 5.1
Bug#37697: make_binary_distribution places files in wrong path
Target fix: 5.1
Bug#39175: mysql_config --libs polluted by
$LDFLAGS
Target fix: 5.1
Server: Parser
Bug#39559: dump of stored procedures / functions with C-style comment can't be read back
Target fix: 5.1
Bug#50755: Crash if stored routine def contains version comments
Target fix: 5.1
Bug#51232: Create multiple tables with foreign key in
ONE
query doesn't work
Target fix: 5.1
Bug#43746: YACC
return wrong query string when
parse 'load data infile' sql statement
Target fix: 5.1
Server: Partition
Bug#51830: Incorrect partition pruning on range partition (regression)
Target fix: 5.1.46
Bug#47343: InnoDB fails to clean-up after lock wait timeout on
REORGANIZE PARTITION
Target fix: 5.1.44
Bug#14326: No formatting of SHOW CREATE TABLE
output
Target fix: 5.1.31
Bug#39434: ALTER TABLE
CHECK
/OPTIMIZE
/ANALYZE
PARTITION
work on non-partitioned table
Target fix: 5.1.31
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#40494: MYSQL
server crashes on range access
with partitioning and order by
Target fix: 5.1.30
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#38719: Partitioning returns a different error code for a duplicate key error
Target fix: 5.1
Bug#42438: Crash ha_partition::change_table_ptr
Target fix: 5.1
Bug#20577: Partitions: use of to_days() function leads to selection failures
Target fix: 5.1
Bug#44821: select distinct on partitioned table returns wrong results
Target fix: 5.1
Bug#42944: partition not pruned correctly
Target fix: 5.1
Bug#30102: Failed RENAME
of partitioned table
corrupts table files
Already fixed in: 5.1
Bug#48846: Too much time spent in ha_partition::records_in_range if not able to prune
Target fix: 5.1
Bug#50561: ALTER PARTITIONS
does not have
adequate lock, breaks with concurrent I_S
query
Target fix: 5.1
Bug#44059: Incorrect cardinality of indexes on a partitioned table
Target fix: 5.1
Bug#40515: Query on a partitioned table does not return 'lock wait timeout exceeded'
Target fix: 5.1
Bug#50418: DROP PARTITION
does not interact
with transactions
Target fix: 5.1
Bug#45816: assertion failure with index containing
DOUBLE
column on partitioned table
Already fixed in: 5.1
Bug#50104: Partitioned table with just 1 partion works with fk
Target fix: 5.1
Bug#46362: Endpoint should be set to false for
TO_DAYS
(DATE
)
Target fix: 5.1
Bug#49161: Out of memory; restart server and try again (needed 2 bytes)
Target fix: 5.1
Bug#46922: crash when adding partitions and open_files_limit is reached
Target fix: 5.1
Bug#36312: InnoDB DATA_FREE BUG
?
Target fix: 5.1
Bug#45904: Cannot create a key subpartition if character set of UTF8 is used
Target fix: 5.1
Bug#45840: read_buffer_size allocated for each partition when "insert into.. select * from"
Target fix: 5.1
Bug#37453: Dropping/creating index on partitioned table with InnoDB Plugin locks table
Target fix: 5.1
Bug#49477: Assertion `0' failed in ha_partition.cc:5530 with temporary table and partitions
Target fix: 5.1
Bug#40389: REORGANIZE PARTITION
crashes when
only using one partition
Target fix: 5.1
Bug#46354: Crash in partition_info::check_partition_info on inconsistent subpartitions
Already fixed in: 5.1
Bug#39084: Getting intermittent errors with statement-based binary logging
Target fix: 5.1
Bug#48229: group by performance issue of partitioned table
Target fix: 5.1
Bug#45807: crash accessing partitioned table and sql_mode contains
ONLY_FULL_GROUP_BY
Target fix: 5.1
Bug#40972: Partition pruning can lead to crash for bad dates
Target fix: 5.1
Bug#51042: REORGANIZE PARTITION
can leave table
in an inconsitent state in case of crash
Target fix: 5.1
Bug#46483: drop table of partitioned table may leave extraneous file
Target fix: 5.1
Bug#48276: Partitions: can't add column if subpartition exists
Target fix: 5.1
Bug#50392: insert_id is not reset for partitioned tables auto_increment on duplicate entry
Target fix: 5.1
Bug#39893: Crash if select on a partitioned table, when partitioning is disabled
Target fix: 5.1
Bug#42849: innodb crash with varying time_zone on partitioned timestamp primary key
Target fix: 5.1
Bug#50300: ALTER TABLE REORGANIZE PARTITION
.... changes row_format of table
Target fix: 5.1
Bug#46639: 1030 (HY000): Got error 124 from storage engine on
INSERT
... SELECT
...
Target fix: 5.1
Bug#46923: select count(*) from partitioned table fails with
ONLY_FULL_GROUP_BY
Target fix: 5.1
Bug#35845: unneccesary call to ha_start_bulk_insert for not used partitions
Target fix: 5.1
Bug#45823: Assertion failure in file row/row0mysql.c line 1386
Target fix: 5.1
Bug#46478: timestamp field incorrectly defaulted when partition is reorganized
Target fix: 5.1
Server: Privileges
Bug#48872: Privileges for stored functions ignored if function name is mixed case
Target fix: 5.1.42
Bug#44658: Create procedure makes server crash when user does not
have ALL
privilege
Target fix: 5.1
Bug#35591: FLUSH PRIVILEGES
caused a crash
Target fix: 5.1
Bug#30305: Create routine in wrong context in SHOW
PRIVILEGES
Target fix: 5.1
Bug#37191: Failed assertion in CREATE VIEW
Target fix: 5.1
Bug#49752: 2469.126.2 unintentionally breaks authentication against MySQL 5.1 server
Target fix: 5.1
Bug#36742: GRANT
hostname case handling
inconsistent
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#40221: Replication failure on RBR
+
UPDATE
the primary key
Target fix: 5.1.31
Bug#41986: Replication slave does not pick up proper
AUTO_INCREMENT
value for Innodb tables
Target fix: 5.1.31
Bug#40004: Replication failure with no PK
+ no
indexes
Target fix: 5.1.30
Bug#48350: truncate temporary table crashes replication
Target fix: 5.1
Bug#48776: row based replication breaks with spatial / geometry types, cause crashes!
Target fix: 5.1
Bug#49481: RBR
: MyISAM and bit fields may cause
slave to stop on delete: cant find record
Target fix: 5.1
Bug#47678: Changes to n-tables that happen early in a trans. are only flushed upon commit
Target fix: 5.1
Bug#42914: No LAST_IO_ERROR
for
max_allowed_packet errors
Target fix: 5.1
Bug#51406: Changing order of columns breaks Row-Based Replication
Target fix: 5.1
Bug#46640: output from mysqlbinlog command in 5.1 breaks replication
Target fix: 5.1
Bug#47418: RBR
fails, failure with mixup of
base/temporary/view TABLE DDL
Target fix: 5.1
Bug#38230: Differences between master and slave after
UPDATE
or DELETE
with
LIMIT
with pk
Target fix: 5.1
Bug#50018: binlog corruption when table has many columns
Target fix: 5.1
Bug#49618: Field length stored incorrectly in binary log for InnoDB
Target fix: 5.1
Bug#49132: Replication failure on temporary table +
DDL
Target fix: 5.1
Bug#47899: CREATE
TABLE
...SELECT
binlogged wrongly if
binlog_format=row
Target fix: 5.1
Bug#39701: Mixed binlog format does not switch to row mode on
LOAD_FILE
Target fix: 5.1
Bug#42749: infinite loop writing to row based binlog - processlist shows "freeing items"
Target fix: 5.1
Bug#39753: Replication failure on MIXED
+ bit +
myisam + no PK
Target fix: 5.1
Bug#42941: --database paramater to mysqlbinlog fails with
RBR
Target fix: 5.1
Bug#45999: row based replication fails when auto_increment field = 0
Target fix: 5.1
Bug#45243: crash on win in sql thread clear_tables_to_lock() -> free()
Target fix: 5.1
Bug#47312: RBR
: Disabling key on slave breaks
replication: HA_ERR_WRONG_INDEX
Target fix: 5.1
Bug#49482: RBR
: Replication may break on
deletes when MyISAM tables + char field are used
Target fix: 5.1
Server: Replication
Bug#49479: Slave stops with syntax error: LOAD
DATA
event without escaped field names
Target fix: 5.1.43
Bug#48506: crash in CREATE TABLE
<existing_view> IF NOT EXISTS LIKE
<tmp_tbl> with RBL
Target fix: 5.1.42
Bug#48297: Schema name is ignored when LOAD
DATA
is written into binlog, replication aborts
Target fix: 5.1.41
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#34541: mysqlbinlog prints 'set;' in stm mode after changing autocommit mode
Target fix: 5.1
Bug#43579: mysql_upgrade tries to alter log tables on replicated database
Target fix: 5.1
Bug#34739: unexpected binlog file name when --log-bin is set to a directory name
Target fix: 5.1
Bug#49119: Master crashes when executing
'REVOKE
... ON
{PROCEDURE
|FUNCTION
}
FROM
...'
Target fix: 5.1
Bug#34283: mysqlbinlog leaves tmpfile after termination if binlog contains load data infile
Target fix: 5.1
Bug#41948: Query_log_event constructor needlessly contorted
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#41980: SBL
, INSERT
..
SELECT
.. LIMIT
=
ERROR
, even when
@@SQL_LOG_BIN
is 0 !
Target fix: 5.1
Bug#35583: mysqlbinlog replay fails with ERROR
1146 when temp tables are used
Target fix: 5.1
Bug#22504: load data infile sql statement in replication architechure get error
Target fix: 5.1
Bug#45214: get_master_version_and_clock does not report error when queries fail
Already fixed in: 5.1
Bug#38197: Errors in @@init_slave not visible in 'show slave status'
Target fix: 5.1
Bug#47287: RBR
: replication diff on basic case
with txn- and non-txn tables in a statement
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#28421: Infinite loop on slave relay logs
Target fix: 5.1
Bug#46130: Slave does not correctly handle "expected errors"
Target fix: 5.1
Bug#49222: Mark RAND
() as unsafe
Target fix: 5.1
Bug#38240: crash in rotate_relay_log during 'flush logs' and 'kill' or shutdown of server
Target fix: 5.1
Bug#44179: reset slave crashes in my_error when reset_logs returns non-zero
Target fix: 5.1
Bug#42415: UPDATE
with LIMIT
clause unsafe for statement format even when ORDER BY
PK
Target fix: 5.1
Bug#47995: Mark system functions as unsafe
Target fix: 5.1
Bug#44331: Restore of database with events produces warning in replication
Target fix: 5.1
Bug#51089: SHOW STATUS LIKE
'Slave_running' is
not compatible with `SHOW SLAVE STATUS
'
Target fix: 5.1
Bug#46364: MyISAM transbuffer problems (NTM
problem)
Target fix: 5.1
Bug#44270: RESET SLAVE
does not reset
Last_IO_Error or Last_IO_Errno
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#45242: crash on win in mysql_close() -> free()
Target fix: 5.1
Bug#46030: rpl_truncate_3innodb causes server crash on windows
Target fix: 5.1
Bug#41166: stored function requires "deterministic" if binlog_format is "statement"
Already fixed in: 5.1
Bug#50095: Multi statement including CREATE
EVENT
causes rotten binlog entry
Target fix: 5.1
Bug#46014: rpl_stm_reset_slave crashes the server sporadically in pb2
Target fix: 5.1
Bug#48340: rpl_cross_version: Found warnings/errors in server log file!
Target fix: 5.1
Bug#51251: Wrong binlogging in case of TRUNCATE
<temporary InnoDB table>
Target fix: 5.1
Bug#45694: Deadlock in replicated statement is not retried
Target fix: 5.1
Bug#48321: CURRENT_USER
() incorrectly
replicated for DROP
/RENAME
USER
;REVOKE
;GRANT
;ALTER
EV
Target fix: 5.1
Bug#39393: slave-skip-errors does not work when using
ROW
based replication
Target fix: 5.1
Bug#50407: mysqlbinlog --database=X produces bad output for SAVEPOINTs
Target fix: 5.1
Bug#47323: mysqlbinlog --verbose displays bad output when events contain subset of columns
Target fix: 5.1
Bug#47142: "slave start until" stops 1 event too late in 4.1 to 5.0 replication
Target fix: 5.1
Bug#48357: SHOW BINLOG EVENTS
: Wrong offset or
I/O error
Target fix: 5.1
Bug#28976: Mixing trans and non-trans tables in one transaction results in incorrect binlog
Target fix: 5.1
Bug#39526: sql_mode not retained in binary log for CREATE
PROCEDURE
Target fix: 5.1
Bug#50620: Adding an index to a table prevents slave from logging into slow log
Target fix: 5.1
Bug#38174: secure-file-priv breaks LOAD DATA
INFILE
replication in statement mode
Target fix: 5.1
Bug#46166: MYSQL_BIN_LOG
::new_file_impl is not
propagating error when generating new name.
Target fix: 5.1
Bug#50078: Executing REPAIR
on master with
broken table does not correctly update slave
Target fix: 5.1
Bug#51226: mysqlbinlog replay: ERROR
1146 when
using temp tables + failing statements
Target fix: 5.1
Bug#40482: server/mysqlbinlog crashes when reading invalid Incident_log_event
Target fix: 5.1
Bug#42829: binlogging enabled for all schemas regardless of binlog-db-db / binlog-ignore-db
Target fix: 5.1
Bug#44442: Incident events are silent in mysqlbinlog output
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#38934: slave slave until does not work with --replicate-same-server-id
Target fix: 5.1
Bug#38205: Row-based Replication (RBR
) causes
inconsistencies: HA_ERR_FOUND_DUPP_KEY
Target fix: 5.1
Bug#51055: Replication failure on duplicate key + traditional
SQL
mode
Target fix: 5.1
Bug#41961: Some log_event types do not skip post-header when reading
Target fix: 5.1
Bug#36763: TRUNCATE TABLE
fails to replicate
when stmt-based binlogging is not supported.
Target fix: 5.1
Bug#45677: Slave stops with Duplicate entry for key
PRIMARY
when using trigger
Target fix: 5.1
Bug#51987: revoke privileges logs wrong error code
Target fix: 5.1
Bug#34628: LOAD DATA CONCURRENT INFILE
drops
CONCURRENT
in binary log
Target fix: 5.1
Bug#42861: Assigning invalid directories to --slave-load-tmpdir crashes the slave
Target fix: 5.1
Server: SE API
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#45235: 5.1 does not support 5.0-only syntax triggers in any way
Target fix: 5.1
Bug#45261: Crash, stored procedure + decimal
Target fix: 5.1
Bug#47627: SET
@@{global.session}.local_variable in stored routine causes crash
Target fix: 5.1
Bug#43884: SP
+ filename param as
TEXT
+ LOAD_FILE
inside,
causes valgrind warnings in PB
Target fix: 5.1
Bug#47870: Bogus "The table mysql.proc is missing,..."
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#44798: MySQL engine crashes when creating stored procedures with execute_priv=N
Target fix: 5.1
Bug#36540: CREATE EVENT
and ALTER
EVENT
statements fail with large server_id
Target fix: 5.1
Bug#34895: 'show procedure status' or 'show function status' + 'flush tables' crashes
Target fix: 5.1
Server: Tests
Server: Types
Bug#49517: Inconsistent behavior while using NULLable
BIGINT
and INT
columns in
comparison
Target fix: 5.1.43
Bug#49480: WHERE
using YEAR
columns returns unexpected results
Target fix: 5.1.42
Bug#49489: Comparison using a DOUBLE
column
started producing different results
Target fix: 5.1.42
Bug#47925: regression of range optimizer and date comparison in 5.1.39!
Target fix: 5.1.41
Bug#42014: Crash, name_const with collate
Target fix: 5.1.32
Bug#43668: Server returns wrong MAX
() value
with year(2) type and no index
Target fix: 5.1
Bug#49478: year(2) datatype index anomalies
Target fix: 5.1
Bug#35558: Wrong server metadata blows up the client
Target fix: 5.1
Bug#49910: Behavioural change in
SELECT
/WHERE
on
YEAR
(4) data type
Target fix: 5.1
Bug#45262: Bad effects with CREATE TABLE
and
DECIMAL
Target fix: 5.1
Bug#40625: Concat fails on DOUBLE
values in a
Stored Procedure, while DECIMAL
works
Target fix: 5.1
Bug#48294: assertion when creating a view based on some row() construct in select query
Target fix: 5.1
Bug#50591: bit(31) causes Duplicate entry
'1-NULL
' for key 'group_key'
Target fix: 5.1
Bug#52124: memory leaks like a sieve in datetime, timestamp, time, date fields + warnings
Target fix: 5.1
Server: Views
Bug#46384: mysqld segfault when trying to create table with same name as existing view
Target fix: 5.1
Bug#40825: Error 1356 while selecting from a view with a
"HAVING
" clause though query works
Target fix: 5.1
Bug#50918: Date columns treated differently in Views than in Base Tables
Target fix: 5.1
Bug#47736: killing a select from a view when the view is processing a function, asserts
Target fix: 5.1
Bug#41788: mysql_fetch_field returns org_table == table by a view
Target fix: 5.1
Bug#47734: Assertion failed: ! is_set() when locking a view with non-existing definer
Target fix: 5.1
Bug#44860: ALTER TABLE
on view crashes server
Target fix: 5.1
Bug#45806: crash when replacing into a view with a join!
Target fix: 5.1
Bug#46616: Assertion `!table->auto_increment_field_not_null' on view manipulations
Target fix: 5.1
Server: XML
Tests: Replication
Bug#45511: rpl.rpl_binlog_corruption fails with warning messages in Valgrind
Target fix: 5.1
libmysqld
Bug#44091: libmysqld gets stuck waiting on mutex on initialization
Target fix: 5.1.35
Bug#43733: Select on processlist let the embedded server crash (concurrent_innodb_safelog)
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
Bug#37995: Error message truncation in test "innodb" in embedded mode
Target fix: 5.1
Bug#47416: Build failure on OS
X 10.6:
duplicate symbol _timed_mutexes
Target fix: 5.1
Bug#43706: libmysqld segfaults when re-intialised
Target fix: 5.1
Bug#50667: The InnoDB plugin prevents initialization of the "embedded" server
Target fix: 5.1
Bug#38293: Libmysqld crash in mysql_library_init if language file missing
Target fix: 5.1
Bug#34517: SHOW GLOBAL STATUS
does not work
properly in embedded server.
Target fix: 5.1
User Comments
Add your own comment.