- 6 Bugs Reported in MySQL
- 6.1 Bugs Reported and Fixed in 5.0
- 6.2 Bugs Reported and Fixed in 5.1
- 6.3 Bugs Reported and Fixed in 5.4
- 6.4 Bugs Reported and Fixed in 5.5
5.0.0
5.0.1
Bug#4603 (SHOW TABLES table_type incorreclty named): Fixed in 5.0.1
Bug#4838 (DDL statements for views are not written to the binary log): Fixed in 5.0.3
Bug#5050 (mysql-test-run fails on rpl_trunc_binlog after 'make install'): Fixed in 5.0.2
Bug#6903 (Procedures, functions and views not quoted correctly when using ANSI_QUOTES): Fixed in 5.0.9
Bug#7024 (FUNCTION does not exist when using CREATE VIEW): Fixed in 5.0.9
Bug#7856 (When installing service, server ignores options after --install <name<): Fixed in 5.0.3
Bug#16539 (MySQL-shared-compat-4.1.15-0.i386.rpm requires glibc 2.3): Fixed in 5.0.21
5.0.2
Bug#5500 (EXPLAIN for a view differs from EXPLAIN for a base table): Fixed in 5.0.26
Bug#5501 (SHOW TABLE STATUS should show "view" in upper case): Fixed in 5.0.12
Bug#5505 (Views: an updatable view is falsely called non-updatable): Fixed in 5.0.26
Bug#5508 (Views:RENAME doesn't work with views): Fixed in 5.0.14
Bug#5859 (DROP TABLE does not drop triggers): Fixed in 5.0.4
Bug#5860 (Multi-table UPDATE does not activate update triggers): Fixed in 5.0.7
Bug#5861 (Triggers are executed under wrong privileges.): Fixed in 5.0.17
Bug#5891 (Triggers stop working if change to sql_mode): Fixed in 5.0.11
Bug#5892 (Triggers have the wrong namespace): Fixed in 5.0.10
Bug#5893 (Triggers with dropped functions cause crashes): Fixed in 5.0.7
Bug#5894 (Triggers with altered tables cause corrupt databases): Fixed in 5.0.7
Bug#5902 (Traditional mode: STR_TO_DATE changes invalid value rather than rejecting): Fixed in 5.0.4
Bug#5903 (Traditional mode: invalid DEFAULT value accepted rather than rejected): Fixed in 5.0.4
Bug#5906 (Traditional mode: invalid date due to conversion accepted): Fixed in 5.0.10
Bug#5907 (Traditional mode: invalid value can be inserted via a stored procedure): Fixed in 5.0.4
Bug#5912 (Traditional mode: CAST allows invalid value): Fixed in 5.0.4
Bug#5933 (Traditional: zero dates should be rejected): Fixed in 5.0.4
Bug#5963 (Stored procedure crash if variable = subquery): Fixed in 5.0.6
Bug#5986 (TRADITIONAL: column with no default not handled correctly): Fixed in 5.0.4
Bug#6106 (Views: SELECT of 2 views with RIGHT JOIN returns wrong result): Fixed in 5.0.5
Bug#6107 (Views: RIGHT JOIN with WHERE clause on views returns wrong result): Fixed in 5.0.5
Bug#6120 (Stored procedure unaffected by ALTER VIEW): Fixed in 5.0.10
Bug#6127 (Stored procedure handlers within handlers don't work): Fixed in 5.0.14
Bug#6145 (Traditional: CONVERT and CAST should reject zero DATE values): Fixed in 5.0.4
Bug#6147 (Traditional: Assigning a string to a numeric column has unexpected results): Fixed in 5.0.26
Bug#6182 (Triggers: duplicate names allowed): Fixed in 5.0.10
Bug#6267 (ENUM ... NOT NULL w/o default treated differently than other data types): Fixed in 5.0.7
Bug#6394 (Views: Crash if select a view created with EXISTS clause): Fixed in 5.0.3
Bug#6443 (Views: failed WHERE clause doesn't prevent updatability): Fixed in 5.0.9
Bug#6513 (Test Suite: Values inserted by using cursor is interpreted latin1 character): Fixed in 5.0.13
Bug#6808 (Views: CREATE VIEW v ... FROM t AS v fails): Fixed in 5.0.13
Bug#6812 (Triggers are not activated for INSERT ... SELECT): Fixed in 5.0.7
Bug#6814 (Views: Crashes if view exists with complex selection): Fixed in 5.0.3
Bug#6866 (stored procedures are errornous in conjunction with views): Fixed in 5.0.7
Bug#6894 (Views: crash if correlated subquery): Fixed in 5.0.3
Bug#7098 (False negative with both like and equals clauses for the same text column): Fixed in 5.0.3
Bug#7413 (VIEW with sub query can cause the MySQL server to crash): Fixed in 5.0.3
Bug#8392 (reference in 'delete from foo where id<0 order by foo.id' crashes server): Fixed in 5.0.3
Bug#8528 (View to a view created from a join crashes): Fixed in 5.0.6
Bug#8702 (Stored Procedures: No Error/Warning shown for inappropriate data type matching.): Fixed in 5.0.18
Bug#8751 (Triggers: Allowed to create triggers on a subject table in a different DB.): Fixed in 5.0.10
Bug#8755 (Triggers: Trigger is NOT activated by implicit insertion into subject table): Fixed in 5.0.7
Bug#8758 (Triggers: CREATE TRIGGER does not accept fully qualified names): Fixed in 5.0.10
Bug#8769 (Functions: For Int datatypes, out of range values can be passed and returned.): Fixed in 5.0.18
Bug#8861 (Functions: If Return is a YEAR data type, value is not shown in year format): Fixed in 5.0.5
Bug#8921 (Views: Creating a temporary table with the same name as an existing view allowed): Fixed in 5.0.6
Bug#9088 (WHERE clause fails with BIGINT if value is between quotes): Fixed in 5.0.19
5.0.3
Bug#4663 (constant function in WHERE clause evaluated in view definition): Fixed in 5.0.10
Bug#6951 (Triggers/Traditional: SET @ result wrong): Fixed in 5.0.23
Bug#6961 (Traditional: assignment of string to numeric column should fail): Fixed in 5.0.6
Bug#6999 (Traditional: Wrong SQLSTATE returned for string truncation): Fixed in 5.0.3
Bug#7015 (Views: selection fails if sum(distinct)): Fixed in 5.0.8
Bug#7049 (Stored procedure CALL errors are ignored): Fixed in 5.0.16
Bug#7061 (No error message for ALTER with AUTO_INCREMENT): Fixed in 5.0.3
Bug#7088 (Stored procedures: labels won't work if character set is utf8): Fixed in 5.0.10
Bug#7115 (Prepared Statements: packet error if execution within stored procedure): Fixed in 5.0.8
Bug#7116 (Views: GROUP_CONCAT crashes the server): Fixed in 5.0.3
Bug#7214 (information_schema: unauthorized user can see metadata): Fixed in 5.0.4
Bug#7215 (information_schema: columns are longtext instead of varchar): Fixed in 5.0.3
Bug#7217 (information_schema: columns are varbinary() instead of timestamp): Fixed in 5.0.3
Bug#7291 (Stored procedures: wrong CURRENT_USER value): Fixed in 5.0.10
Bug#7350 (Error in UCS2 comparisons of InnoDB tables): Fixed in 5.0.3
Bug#7448 (Views: column name generation doesn't always work): Fixed in 5.0.8
Bug#7549 (Missing error message for invalid view selection with subquery): Fixed in 5.0.23
Bug#7648 (Stored procedure crash when invoking a function that returns a bit): Fixed in 5.0.5
Bug#7787 (Stored procedures: improper warning for "grant execute" statement): Fixed in 5.0.19
Bug#7973 (Index corruption on crash recovery of compact table): Fixed in 5.0.3
Bug#8115 (Server Crash with prepared statement): Fixed in 5.0.3
Bug#8125 (reexecution of prepared statement crashes server): Fixed in 5.0.3
Bug#8153 (Stored procedure with subquery and continue handler, wrong result): Fixed in 5.0.25
Bug#8295 (VARCHAR: Silent data type change when size too large): Fixed in 5.0.6
Bug#8296 (VARBINARY: Silent data type change when size too large): Fixed in 5.0.6
Bug#8405 (Stored procedure crash if function causes reference to same table): Fixed in 5.0.3
Bug#8406 (Triggers crash if referencing a table): Fixed in 5.0.10
Bug#8407 (Stored functions/triggers ignore exception handler): Fixed in 5.0.41, 5.0.38
Bug#8408 (Stored procedure crash if function contains SHOW): Fixed in 5.0.6
Bug#8409 (Stored procedure crash if function contains FLUSH): Fixed in 5.0.7
Bug#8461 (TRUNCATE: returns incorrect result if 2nd argument is negative): Fixed in 5.0.19
Bug#8532 (SELECT DISTINCT a, a causes server to crash): Fixed in 5.0.3
Bug#8578 (Test case 'index_merge_ror' fails on SGI irix): Fixed in 5.0.3
Bug#8610 (The ucs2_turkish_ci collation fails with upper('i')): Fixed in 5.0.7
Bug#8650 (InnoDB does not rollback SQL statement at an error): Fixed in 5.0.4
Bug#8682 (Server crashes on 'reap' (test 'flush_block_commit')): Fixed in 5.0.3
Bug#8703 (insert into table select from view crashes): Fixed in 5.0.4
Bug#8731 (MySQL does not respect set timeouts on Mac OS X): Fixed in 5.0.15
Bug#8849 (problem with insert statement with table alias's): Fixed in 5.0.3
Bug#8850 (Truncate table in a stored procedure locks the tables): Fixed in 5.0.3
Bug#8866 (Test 'kill' fails in PS protocol: Server crash on 'select get_lock("a", 10)'): Fixed in 5.0.4
Bug#8880 (Commands out of sync error with cursors): Fixed in 5.0.4
Bug#8902 (mysql.proc.sql_mode column definition is incomplete): Fixed in 5.0.3
Bug#8998 (information_schema: Table SCHEMATA should report default collations): Fixed in 5.0.6
Bug#9029 (Traditional: Wrong SQLSTATE returned for string truncation): Fixed in 5.0.3
Bug#9048 (FUNCTIONS: Creating a function with char binary IN parameter fails): Fixed in 5.0.12
Bug#9100 (Replication: suspicious-looking binlog entries if function present): Fixed in 5.0.6
Bug#9102 (Stored proccedures: function which returns blob causes crash): Fixed in 5.0.5
Bug#9159 (Server crash during mysql_stmt_close): Fixed in 5.0.4
Bug#9260 (Views: CREATE OR REPLACE VIEW/ALTER VIEW require incorrect privilege): Fixed in 5.0.4
Bug#9309 (Wrong order in INFORMATION_SCHEMA): Fixed in 5.0.4
Bug#9314 (Bug in range searches on prefix primary key on varchar column): Fixed in 5.0.4
Bug#9317 (Wrong count for tables in INFORMATION_SCHEMA): Fixed in 5.0.4
Bug#9348 (result for WHERE A AND (B OR C) differs from WHERE a AND (C OR B)): Fixed in 5.0.5
Bug#9398 (CREATE TABLE that uses SELECT from a multi-table view causes a crash of server): Fixed in 5.0.4
Bug#9404 (information_schema: Weird error messages with SELECT SUM() ... GROUP BY queries): Fixed in 5.0.6
Bug#9434 (SHOW CREATE DATABASE `information_schema`;): Fixed in 5.0.8
Bug#9486 (can't perform multi-update in stored procedure): Fixed in 5.0.5
Bug#9489 (Problem with BIT_OR and MySQL 5.0.3): Fixed in 5.0.6
Bug#9496 (Table mysql.proc created by mysql_create_system_tables lacks ENGINE-specificati): Fixed in 5.0.4
Bug#9501 (Arbitrary precision math done incorretly (numeric math in fp maybe?)): Fixed in 5.0.4
Bug#9526 (ENUM storage wrong; Got signal 11 when trying to create an InnoDB table): Fixed in 5.0.4
Bug#9542 (MySQL dies with signal 11 when it is using non-existent location of binary logs): Fixed in 5.0.5
Bug#9558 (mysqldump --no-data db t1 t2 format still dumps data): Fixed in 5.0.9
Bug#9565 (wrong locking in stored procedure if a sub-sequent procedure is called): Fixed in 5.0.10
Bug#9566 (explicit LOCK TABLE and store procedures result in illegal state): Fixed in 5.0.5
Bug#9571 (Primary key creation causes server crash): Fixed in 5.0.4
Bug#9581 (LOCK TABLEs is ignored after UNLOCK TABLES if TRIGGERs are involved): Fixed in 5.0.10
Bug#9586 (information_schema doesn't contain table with trigger information): Fixed in 5.0.10
Bug#9587 (information_schema.table_constraints doesn't contain foreign key relationship): Fixed in 5.0.6
Bug#9593 (The combination of COUNT, DISTINCT and CONCAT seems to lock the server): Fixed in 5.0.7
Bug#9597 (read lock stays when querying view from stored procedure): Fixed in 5.0.10
Bug#9669 (Ordering on IF function with FROM_UNIXTIME function fails): Fixed in 5.0.7
Bug#9673 (valgrind shows not freed memory in InnoDB): Fixed in 5.0.7
Bug#9683 (INFORMATION_SCH: Creation of temporary table allowed in Information_schema DB): Fixed in 5.0.13
Bug#9758 (error in SP that retrives data from a view): Fixed in 5.0.6
Bug#9814 (Cursors: Closing a cursor that is not open hangs MySQL): Fixed in 5.0.9
Bug#9819 (Cursors: Mysql Server Crash while fetching from table with 5 million records.): Fixed in 5.0.13
Bug#9841 (Views: Unexpected READ Lock when trying to update a view in a stored procedure): Fixed in 5.0.6
Bug#9846 (Inappropriate error displayed while dropping table from 'INFORMATION_SCHEMA'): Fixed in 5.0.13
Bug#9896 (SHOW TABLE STATUS shows wrong information): Fixed in 5.0.13
Bug#9897 (Views: 'Check Table' crashes MySQL, with a view and a table in the statement): Fixed in 5.0.6
Bug#9978 (MySQL crash when Natural Right Join is used with no conditions): Fixed in 5.0.12
Bug#14747 (Race condition can cause btr_search_drop_page_hash_index() to crash): Fixed in 5.0.17
Bug#15550 (mysqld crashes in printing a FOREIGN KEY error in InnoDB): Fixed in 5.0.18
Bug#18252 (Disk space leak in updates of InnoDB BLOB rows in 5.0 and 5.1): Fixed in 5.0.20
Bug#18384 (InnoDB memory leak on duplicate key errors in 5.0 if row has many columns): Fixed in 5.0.20
Bug#19217 (dict_load_indexes() may read the delete-mark incorrectly): Fixed in 5.0.21
5.0.4
Bug#9072 ('Max_error_count' system variable cannot be set to zero): Fixed in 5.0.4
Bug#9455 (mysqladmin status crash the server): Fixed in 5.0.5
Bug#9478 (mysql_stmt_attr_set mysql_stmt_execute): Fixed in 5.0.6
Bug#9503 (SP: after some SP function errors server will not send OK (client hangs)): Fixed in 5.0.9
Bug#9504 (Stored procedures: execute privilege doesn't make 'use database' okay): Fixed in 5.0.42, 5.0.45
Bug#9505 (Views: privilege needed on underlying function): Fixed in 5.0.16
Bug#9509 (Optimizer: wrong result after AND with latin1_german2_ci comparisons): Fixed in 5.0.25
Bug#9520 (SELECT DISTINCT crashes server with cursor): Fixed in 5.0.6
Bug#9535 (Warning for "create table t as select uuid();"): Fixed in 5.0.6
Bug#9558 (mysqldump --no-data db t1 t2 format still dumps data): Fixed in 5.0.9
Bug#9593 (The combination of COUNT, DISTINCT and CONCAT seems to lock the server): Fixed in 5.0.7
Bug#9643 (CURSOR_TYPE_SCROLLABLE dos not work): Fixed in 5.0.6
Bug#9756 (mysql client failing on dumps containing certain \ sequences): Fixed in 5.0.5
Bug#9775 (Stored procedures: crash if create function that returns enum or set): Fixed in 5.0.5
Bug#9795 (MySQL forgets about SHOW VIEW / CREATE VIEW privileges granted on table level): Fixed in 5.0.9
Bug#9996 (Crash in VIEW's due to privilege problems): Fixed in 5.0.13
Bug#10015 (Crash in InnoDB if SPs and Triggers are used): Fixed in 5.0.7
Bug#10039 (MEMORY engine is reported as HEAP): Fixed in 5.0.5
Bug#10056 (PACK_KEYS option take values greater than 1 while creating table): Fixed in 5.0.12
Bug#10059 (SHOW TABLE STATUS FROM `information_schema`; reports uppercase table names): Fixed in 5.0.7
Bug#10136 (select returns wrong result when called from stored procedure): Fixed in 5.0.8
Bug#10181 (mysqld.exe crash with an access violation after INSERT INTO mysql.host): Fixed in 5.0.7
Bug#10303 (Misleading Last_query_cost value): Fixed in 5.0.16
Bug#10339 (Incorrect error is displayed if try to set value of internal ' warning_count '.): Fixed in 5.0.7
Bug#10351 (Max_Heap_Table_Size cannot be set to 4 gb): Fixed in 5.0.11
Bug#10359 (InnoDB in MySQL v5.0.4 doesn't lock auto increment reliably): Fixed in 5.0.6
Bug#10362 (SHOW PROCEDURE always qualifies name with database): Fixed in 5.0.13
Bug#10407 (Incorrect error is displayed when creating a teble with incorrect DB name.): Fixed in 5.0.11
Bug#10466 (Datatype "timestamp" displays "YYYYMMDDHHMMSS" irrespective of display sizes.): Fixed in 5.0.9
Bug#10732 (Set SQL_MODE to NULL gives garbled error message): Fixed in 5.0.8
Bug#10927 (mysqldump: Can't reload dump with view that consist of other view): Fixed in 5.0.9
Bug#11227 (DESC says "MUL" where it shoud say "UNI"): Fixed in 5.0.11
5.0.5
Bug#6897 (Stored procedure packet error with sql_cache): Fixed in 5.0.11
Bug#9798 (Rollup crash with InnoDB in setup_sum_funcs()): Fixed in 5.0.6
Bug#9897 (Views: 'Check Table' crashes MySQL, with a view and a table in the statement): Fixed in 5.0.6
Bug#9978 (MySQL crash when Natural Right Join is used with no conditions): Fixed in 5.0.12
Bug#10041 ('view' test fails in --ps-protocol test suite on multiple build hosts): Fixed in 5.0.6
Bug#10419 (Change search location for My.ini on Windows): Fixed in 5.0.10
Bug#10473 (Can't set 'key_buffer_size' system variable to ZERO.): Fixed in 5.0.12
Bug#10499 (MyISAM: Function creation fails which returns GEOMETRY datatype.): Fixed in 5.0.12
Bug#10504 (Character set does not support traditional mode): Fixed in 5.0.14
Bug#10543 (Incorrect error when trying to convert varchar column having index to tinytext.): Fixed in 5.0.8
Bug#10568 (Function 'LAST_DAY(date)' does not return NULL for invalid argument.): Fixed in 5.0.7
Bug#10589 (des_encrypt functionality always return NULL): Fixed in 5.0.9
Bug#10590 (Function 'TIME_FORMAT(time,format)' does not display correct result.): Fixed in 5.0.7
Bug#10599 (Numeric function 'abs' make server crash): Fixed in 5.0.6
Bug#10617 (Insert from same table to same table give incorrect result for bit(4) column.): Fixed in 5.0.9
Bug#10668 (CREATE USER does not enforce username length limit): Fixed in 5.0.25
Bug#10734 (Grant of privileges other than 'select' and 'create view' should fail on schema): Fixed in 5.0.13
Bug#10964 (Information Schema:Authorization check on privilege tables is improper): Fixed in 5.0.7
Bug#10979 (USE does not refresh db privilege changes if the same db is used in command.): Fixed in 5.0.25
5.0.6
Bug#10246 (Parser: bad syntax for GRANT EXECUTE): Fixed in 5.0.6
Bug#10409 (ON UPDATE CASCADE does not enforce maximum length of UTF-8 data): Fixed in 5.0.8
Bug#10605 (Stored procedure with multiple SQL prepared statements disconnects client): Fixed in 5.0.8, 5.0.13
Bug#10624 (Views with multiple UNION and UNION ALL produce incorrect results): Fixed in 5.0.12
Bug#10625 (DECIMAL tables corrupt after upgrade 5.0.4 -< 5.0.6): Fixed in 5.0.6
Bug#10627 (Traditional: invalid date accepted from DATE_ADD/DATE_SUB functions): Fixed in 5.0.12
Bug#10651 (Views: var_samp() looks like var_pop()): Fixed in 5.0.9
Bug#10708 (SP's can use INFORMATION_SCHEMA as ROUTINE_SCHEMA): Fixed in 5.0.13
Bug#10729 (mysql_stmt_attr_set CURSOR_TYPE_READ_ONLY): Fixed in 5.0.8
Bug#10736 (mysql_stmt_attr_set CURSOR_TYPE_READ_ONLY select within select): Fixed in 5.0.9
Bug#10746 (InnoDB: Error: stored_select_lock_type is 0 inside ::start_stmt()!): Fixed in 5.0.30
Bug#10760 (mysql_stmt_attr_set fetch after rollback): Fixed in 5.0.10
Bug#10776 (Failure to compile ndb ReadNodesConf.cpp on AIX 5.2): Fixed in 5.0.48, 5.0.51, 5.0.20
Bug#10794 (mysql_stmt_attr_set no open cursor after mysql_stmt_execute): Fixed in 5.0.9
Bug#10801 (Test using "--embedded-server" has error messages truncated): Fixed in 5.0.19
Bug#10911 (Crash when running tests --embedded-server): Fixed in 5.0.19
Bug#10924 (Test "derived" crashes in embedded test): Fixed in 5.0.19
Bug#10925 (Test "myisam" hangs in embedded test): Fixed in 5.0.19
Bug#10926 (Embedded Server: "mysql_client_test" test failure): Fixed in 5.0.19
Bug#10930 (Test "sp-threads" does not fit embedded server): Fixed in 5.0.19
Bug#10932 (Building server with key limit of 128, makes test cases fail): Fixed in 5.0.18
Bug#11037 (mysql_stmt_fetch() returns error instead of MYSQL_NO_DATA): Fixed in 5.0.11
Bug#11044 (SELECT DISTINCT on indexed column returns inconsistent results): Fixed in 5.0.8
Bug#11060 (Server crashe on calling stored procedure with INSERT SELECT UNION SELECT): Fixed in 5.0.8
Bug#11081 (Using a CONVERT_TZ function in a stored function or trigger fails): Fixed in 5.0.23
Bug#11091 (union involving BIT: assertion failure in Item::tmp_table_field_from_field_type): Fixed in 5.0.9
Bug#11172 (mysql_stmt_attr_set CURSOR_TYPE_READ_ONLY date/datetime filter server crash): Fixed in 5.0.9
Bug#11207 (SET GLOBAL TRANSACTION ISOLATION LEVEL seems to be broken): Fixed in 5.0.12
Bug#11230 (Keeping comments when storing stored procedures): Fixed in 5.0.52
Bug#11298 (insert into select from VIEW produces incorrect result when using ORDER BY): Fixed in 5.0.8
Bug#11337 (Check table for two views crashes server): Fixed in 5.0.9
Bug#11523 (\d behaves different from delimiter): Fixed in 5.0.12
Bug#11572 (MYSQL_TYPE_BIT not taken care of in temp. table creation for VIEWs): Fixed in 5.0.9
Bug#28505 (Update count for an INSERT DUPLICATE KEY not correct when CLIENT_FOUND_ROWS set): Fixed in 5.0.45, 5.0.44
5.0.7
Bug#8441 (ROR code has key len 4, should be 5): Fixed in 5.0.8
Bug#10055 (Stored proccedures: using stored procedure (function) cause empty result set): Fixed in 5.0.12
Bug#10963 (LEFT/RIGHT/SUBSTR/.. string functions returns wrong result on large length): Fixed in 5.0.33, 5.0.30sp1
Bug#10966 (Variance functions return wrong data type): Fixed in 5.0.25
Bug#10970 (Views: dependence on temporary table allowed): Fixed in 5.0.12
Bug#10972 (Views: natural join of view and underlying table gives wrong result): Fixed in 5.0.12
Bug#10974 (No error message if merge table based on union of innodb, memory): Fixed in 5.0.26
Bug#10975 (Prepared statements: crash if function deallocates): Fixed in 5.0.8, 5.0.13
Bug#10977 (Views: no warning if column name is truncated): Fixed in 5.0.25
Bug#11033 (Valgrind warning in compare_record): Fixed in 5.0.21
Bug#11034 (Valgrind warning in DictCache::get, memory loss): Fixed in 5.0.21
Bug#11055 (information_schema: routines.sql_data_access has wrong value): Fixed in 5.0.8
Bug#11057 (information_schema: columns table has some questionable contents): Fixed in 5.0.10
Bug#11080 (Multi-row REPLACE fails on a duplicate key error on an AUTO-INC column): Fixed in 5.0.7
Bug#11111 (fetch from view returns wrong data): Fixed in 5.0.7
Bug#11150 (HP-UX yaSSL/OpenSSL configure/header problem): Fixed in 5.0.8
Bug#11153 (Ambiguous call to overloaded function, acording to Visual Studio 6): Fixed in 5.0.7
Bug#11158 (Can't perform multi-delete in stored procedure): Fixed in 5.0.8
Bug#11183 (mysql_stmt_reset() doesn't reset information about error): Fixed in 5.0.10
Bug#11200 (show instance options returns garbage instead of log options): Fixed in 5.0.8
Bug#11213 (Thread stack usage: Message is misleading): Fixed in 5.0.11
Bug#11235 (Expression with IFNULL yields 18 where 1 is correct): Fixed in 5.0.8
Bug#11284 (left join with empty derived table): Fixed in 5.0.8
Bug#11312 (DELIMITER is not written to the binary log that causes syntax error): Fixed in 5.0.19
Bug#11380 (mysqld will not start-problem with /tmp/mysql.sock): Fixed in 5.0.12
Bug#11398 (Varchar trailing space handling breaks multi-column indexing): Fixed in 5.0.12
Bug#11399 (Use an alias in a select statement on a view): Fixed in 5.0.10
Bug#11402 (Select abs(-1) * -1 result: 18446744073709551615): Fixed in 5.0.11
Bug#11459 (ndb status variables not updated): Fixed in 5.0.23
Bug#11484 (SELECT DISTINCT don't seems to work): Fixed in 5.0.9
Bug#11493 (Alter table rename to default database does not work without db name qualifying): Fixed in 5.0.12
Bug#11553 (gives error if aggregate user-defined function in HAVING clause): Fixed in 5.0.14
Bug#11572 (MYSQL_TYPE_BIT not taken care of in temp. table creation for VIEWs): Fixed in 5.0.9
Bug#11577 ('show procedure/function status' doesn't work for user with limited access): Fixed in 5.0.10
Bug#11587 (trigger causes lost connection error): Fixed in 5.0.12
Bug#11639 (View + "with rollup" returns strange data): Fixed in 5.0.9
Bug#11680 (5.0.7-beta build fails when using --without-server): Fixed in 5.0.14
Bug#11685 (SHOW TABLES; doesn't update Com_show_tables): Fixed in 5.0.10
Bug#11709 (ORDER BY with views can use the wrong column): Fixed in 5.0.10
Bug#11711 (create a view referencing a information schema (temporary) table): Fixed in 5.0.12
Bug#11717 (MySQL cannot convert "Division Sign" to 'eucjpms' from the other character-set.): Fixed in 5.0.10
Bug#11754 (SET NAMES utf8 followed by SELECT "A\\" LIKE "A\\" returns 0): Fixed in 5.0.11
Bug#11815 (LOAD DATA INFILE not replicating to XP): Fixed in 5.0.13
Bug#11832 (Server crash with InnoDB + Cursors): Fixed in 5.0.12
Bug#11853 (DELETE ... NOT LIKE doesn't seem to work properly when index present): Fixed in 5.0.10
Bug#11864 (non unique names are allowed in subquery): Fixed in 5.0.12
Bug#11869 (Server crashes making a union join query with fulltext search): Fixed in 5.0.12
Bug#11885 (error in select with NOT IN of one item if it's a primary key): Fixed in 5.0.10
Bug#11892 (ODBC Connector/libmysql cause corruption of the MySQL charset data.): Fixed in 5.0.19
Bug#11934 (FLUSH TABLES WITH READ LOCK hangs client): Fixed in 5.0.11
Bug#12267 (Can't use POINT for Primary Key): Fixed in 5.0.16
5.0.8
Bug#11183 (mysql_stmt_reset() doesn't reset information about error): Fixed in 5.0.10
Bug#11215 (BIGINT: can't set DEFAULT to minimum end-range): Fixed in 5.0.9
Bug#11286 (yassl incompatible with "load data infile"): Fixed in 5.0.13
Bug#11333 (Stored Procedure: Memory blow up on repeated SELECT ... INTO query): Fixed in 5.0.13
Bug#11365 (Stored Procedure: Crash on Procedure operation): Fixed in 5.0.10
Bug#11484 (SELECT DISTINCT don't seems to work): Fixed in 5.0.9
Bug#11510 (Internal compiler error in innobase/btr/btr0cur.c): Fixed in 5.0.12
Bug#11544 (Use of missing rint() function on QNX): Fixed in 5.0.9
Bug#11554 (Server crashes on statement indirectly using non-cached function): Fixed in 5.0.10
Bug#11567 (Variable 'foreign_key_checks', and other variables, differs binlog tests): Fixed in 5.0.10
Bug#11572 (MYSQL_TYPE_BIT not taken care of in temp. table creation for VIEWs): Fixed in 5.0.9
Bug#11602 (stored procedure < 64K causes bad behavior): Fixed in 5.0.11
Bug#11650 (LIKE pattern matching using prefix index doesn't return correct result): Fixed in 5.0.10
Bug#12947 (InnoDB: consistent read can return inconsistent results, even crash possible): Fixed in 5.0.13
5.0.9
Bug#9881 (ALTER TABLE gives wrong error message with sql-mode TRADITIONAL): Fixed in 5.0.10
Bug#11338 (logging of prepared statement w/ blob type): Fixed in 5.0.12
Bug#11399 (Use an alias in a select statement on a view): Fixed in 5.0.10
Bug#11516 (ndb_mgmd debug core on cluster shutdown with failed data nodes): Fixed in 5.0.10
Bug#11639 (View + "with rollup" returns strange data): Fixed in 5.0.9
Bug#11657 (Creation of secondary index fails): Fixed in 5.0.9
Bug#11704 (Found locks from different threads in write -< crash with OPTIMIZE table?): Fixed in 5.0.16
Bug#11709 (ORDER BY with views can use the wrong column): Fixed in 5.0.10
Bug#11834 (Re-execution of prepared statement with dropped function crashes server): Fixed in 5.0.10
Bug#12154 (SELECT FROM a VIEW fails with NULL column and DISTINCT): Fixed in 5.0.12
Bug#12166 (Unable to index very large tables): Fixed in 5.0.16
Bug#12198 (Temporary Table Aliasing does not work inside stored procedure): Fixed in 5.0.19
Bug#12207 (alter table ... discard table space on MyISAM table causes ERROR 2013 (HY000):): Fixed in 5.0.13
Bug#12226 (Insert delayed SQL stmt causes mysqld to crash if record already exists): Fixed in 5.0.11
Bug#12298 (Cannot execute view but the underlying select statement): Fixed in 5.0.12
Bug#12532 (sql_thread causing memory overrun): Fixed in 5.0.12
5.0.10
Bug#11815 (LOAD DATA INFILE not replicating to XP): Fixed in 5.0.13
Bug#11864 (non unique names are allowed in subquery): Fixed in 5.0.12
Bug#11869 (Server crashes making a union join query with fulltext search): Fixed in 5.0.12
Bug#11889 (Server crash when dropping a trigger using non-cached stored routine): Fixed in 5.0.10
Bug#11896 (Partial locking in case of recursive trigger definittions): Fixed in 5.0.12
Bug#11901 (mysql_stmt_attr_set CURSOR_TYPE_READ_ONLY join in subqry order by server crash): Fixed in 5.0.12
Bug#11904 (mysql_stmt_attr_set CURSOR_TYPE_READ_ONLY grouping wrong result): Fixed in 5.0.13
Bug#11909 (mysql_stmt_attr_set CURSOR_TYPE_READ_ONLY nested queries corrupt result): Fixed in 5.0.12
Bug#11934 (FLUSH TABLES WITH READ LOCK hangs client): Fixed in 5.0.11
Bug#11964 (ALTER TABLE gives wrong error message with sql-mode TRADITIONAL (timestamp)): Fixed in 5.0.11
Bug#11972 (client uses wrong character set after reconnect): Fixed in 5.0.25
Bug#11973 (SELECT .. INTO var_name; in trigger cause crash on update): Fixed in 5.0.12
Bug#12082 (Prepared statement "FOR UPDATE" "LOCK IN SHARE MODE": timeout gives server crash): Fixed in 5.0.12
Bug#12101 (Invalid outer join elimination for a query with NOT BETWEEN condition): Fixed in 5.0.13
Bug#12102 (Missing outer join elimination for some queries): Fixed in 5.0.13
Bug#12243 (MySQL Server crashes with 2 cursors (+ commit)): Fixed in 5.0.12
Bug#12291 (ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql518e_1_2.MYI'; try to): Fixed in 5.0.14
Bug#12307 (SP hangs server when it includes FLUSH PRIVILEGES;): Fixed in 5.0.12
Bug#12315 (SHOW TABLE STATUS FROM `information_schema`; does not sort tablenames): Fixed in 5.0.12
Bug#12318 (ERROR 42000: Unknown db 'information_schema' at call of a SP without privileges): Fixed in 5.0.12
Bug#12340 (multitable delete deletes only one record): Fixed in 5.0.12
Bug#12351 (CONCAT with USER()/DATEBASE() etc, a constant and a column gets strange results): Fixed in 5.0.12
Bug#12379 (PROCEDURE with HANDLER calling FUNCTION with error get strange result): Fixed in 5.0.13
Bug#12397 (wrong values shown in column CREATE_OPTIONS of INFORMATION_SCHEMA.TABLES): Fixed in 5.0.12
Bug#12448 (LOAD DATA / 'SELECT INTO OUTFILE doesn't work with multibyte path name): Fixed in 5.0.19
Bug#12470 (MySQL server crashes when attached view is SELECT'ed upon.): Fixed in 5.0.12
Bug#12547 (Inserting long string into varchar causes table crash in cp932): Fixed in 5.0.16
Bug#12779 (Wrong left join result if InnoDB estimates a table to be empty when it is not): Fixed in 5.0.12
Bug#12791 (LEAST() Ignores NULLs (Undocumented Behaviour)): Fixed in 5.0.13
Bug#13052 (mysqldump timestamp reloads broken when servers have different time zones): Fixed in 5.0.15
5.0.11
Bug#10950 (Occational 'Error in mgm protocol parser' error on mysqld startup): Fixed in 5.0.12
Bug#11309 (mysql_stmt_attr_set CURSOR_TYPE_READ_ONLY select aggregrate server crash): Fixed in 5.0.12
Bug#12122 (Views: ORDER BY doesn't have to mean merge): Fixed in 5.0.36, 5.0.37
Bug#12127 (triggers do not show in info_schema before they are used if set to the database): Fixed in 5.0.11
Bug#12154 (SELECT FROM a VIEW fails with NULL column and DISTINCT): Fixed in 5.0.12
Bug#12186 (NULL VARCHAR UCS2 column in InnoDB table crashes the server): Fixed in 5.0.11
Bug#12212 (Crash that happens during removing of database name from cache): Fixed in 5.0.11
Bug#12228 (Crash happens during calling specific SP in multithread environment): Fixed in 5.0.12
Bug#12278 (Triggers: packet error if select from information_schema): Fixed in 5.0.12
Bug#12280 (Triggers: crash if flush tables): Fixed in 5.0.12
Bug#12334 (If SP is inside transaction, BEGIN ..ROLLBACK are not written to the binary log): Fixed in 5.0.12
Bug#12371 (executing prepared statement fails (illegal mix of collations)): Fixed in 5.0.16
Bug#12392 (Server crashes in complex join query): Fixed in 5.0.12
Bug#12490 (Packets out of order if calling HELP CONTENTS from Stored Procedure): Fixed in 5.0.13
Bug#12595 (Escape character has to be exactly one): Fixed in 5.0.16
Bug#12597 (mysqldump dumps triggers wrongly): Fixed in 5.0.13
Bug#12672 (Select involving 3 times the same InnoDB table causes next subquery work wrong): Fixed in 5.0.12
Bug#12705 (Syntax error in mysql_fix_privilege_tables.sql): Fixed in 5.0.12
Bug#12712 (SET AUTOCOMMIT should fail within SP/functions/triggers): Fixed in 5.0.13
Bug#12723 (Shared memory connections not working): Fixed in 5.0.14
Bug#12751 (Instance Manager: client hangs after start instance; kill mysqlmanager; show ...): Fixed in 5.0.33, 5.0.30
Bug#12791 (LEAST() Ignores NULLs (Undocumented Behaviour)): Fixed in 5.0.13
Bug#12792 (@@system_time_zone is not SELECTable.): Fixed in 5.0.23
Bug#12820 (Unable to use UDFs and Stored Procs in 5.0.11 (after upgrading from 5.0.9)): Fixed in 5.0.13
Bug#12838 (mysqldump cannot dump views when tables are locked): Fixed in 5.0.16
Bug#12841 (Server crash on DO IFNULL(NULL,NULL);): Fixed in 5.0.13
Bug#12885 (rollup / subquery and creat table, causes incorrect cannot be null): Fixed in 5.0.13
Bug#12887 (distinct vs rollup, are applied in inconsistent ways): Fixed in 5.0.14
Bug#12903 (upper function does not work inside a function): Fixed in 5.0.18
Bug#12905 (show fields from view behaving erratically with current database): Fixed in 5.0.13
Bug#12922 (wrong results with GROUP BY on VIEW): Fixed in 5.0.13
Bug#13000 (WEEKDAY function in views changed to WEEKDAY(TO_DATE(field))): Fixed in 5.0.13
5.0.12
Bug#9078 (STORED PROCDURE: Decimal digits are not displayed when we use DECIMAL datatype): Fixed in 5.0.18
Bug#12198 (Temporary Table Aliasing does not work inside stored procedure): Fixed in 5.0.19
Bug#12267 (Can't use POINT for Primary Key): Fixed in 5.0.16
Bug#12423 (Deadlock in multithread environment (stress test)): Fixed in 5.0.13
Bug#12468 (SP crashes the server when executing CREATE VIEW statement): Fixed in 5.0.13
Bug#12518 (COLUMN_DEFAULT has wrong value if NOT NULL is set): Fixed in 5.0.12
Bug#12532 (sql_thread causing memory overrun): Fixed in 5.0.12
Bug#12550 (mysql.server script contains libexec=basedir/bin and other problems): Fixed in 5.0.13
Bug#12611 (ESCAPE + LIKE do not work when the escape char is a multibyte one): Fixed in 5.0.13
Bug#12651 (Crash on a PS including a subquery which is a select from a simple view): Fixed in 5.0.13
Bug#12694 (Inconsistency for float(m,d) specification): Fixed in 5.0.14
Bug#12720 (SELECT from VIEW doesn't return rows): Fixed in 5.0.13
Bug#12734 (prepared statement may return incorrect result set for a select SQL request): Fixed in 5.0.19
Bug#12739 (Deadlock in multithread env during creating/droping trigger on innodb table): Fixed in 5.0.16
Bug#12762 (Aggregate function cannot be used in statement): Fixed in 5.0.18
Bug#12770 (DESC cannot display the info. about temporary table): Fixed in 5.0.18
Bug#12891 (UNION doesn't return DISTINCT result for multi-byte characters): Fixed in 5.0.13
Bug#12938 (Stored procedures: DECIMAL arithmetic in a loop fails): Fixed in 5.0.13
Bug#12943 (bogus "Unknown column 'a.b' in 'on clause'" error): Fixed in 5.0.13
Bug#12947 (InnoDB: consistent read can return inconsistent results, even crash possible): Fixed in 5.0.13
Bug#12973 (SHOW TABLE STATUS shows Autoincrement = 0 for InnoDB): Fixed in 5.0.13
Bug#12976 (stored procedures local variables of type bit): Fixed in 5.0.41, 5.0.38
Bug#12977 (Crash referencing a joined column by table when a USING follows an ON): Fixed in 5.0.13
Bug#12993 (View column raname broken in subselect): Fixed in 5.0.13
Bug#13037 (undefined variable in IF cause erroneous error-message): Fixed in 5.0.15
Bug#13067 (JOIN xxx USING is case sensitive): Fixed in 5.0.13
Bug#13108 (ALTER TABLE does not work on FEDERATED tables): Fixed in 5.0.13
Bug#13126 (join among several tables returns empty set): Fixed in 5.0.16
Bug#13133 (Local variables in stored procedures are not initialized correctly.): Fixed in 5.0.13
Bug#13134 (Length of VARCHAR() utf8 column is increasing when table is recreated with PS/SP): Fixed in 5.0.19
Bug#13228 (open table cache not flushed when table schema changed): Fixed in 5.0.21
Bug#13293 (SELECT query goes in an infinite loop after an ALTER TABLE): Fixed in 5.0.16
Bug#13361 (FORMAT function on NULL DECIMAL field crashes MySQL service): Fixed in 5.0.14
Bug#13367 (InnoDB does not create doublewrite buffer in new installation: assertion failure): Fixed in 5.0.14
Bug#13392 (values() fails with 'ambiguous' or returns NULL with ON DUPLICATE and SELECT): Fixed in 5.0.16
Bug#13479 (REPLACE activates UPDATE trigger, not the DELETE and INSERT triggers): Fixed in 5.0.23
Bug#13512 (ndb_restore dumps core if there are no free mysqld): Fixed in 5.0.14
Bug#13525 (Rename table does not keep info of triggers): Fixed in 5.0.19
Bug#13575 (SELECT id, myFunc(id) FROM aTable ORDER BY id; returns bad data): Fixed in 5.0.20
Bug#13597 (Column in ON condition not resolved if references a table in nested right join): Fixed in 5.0.15
Bug#13616 ("CALL <dbname<.<procedurename<" executes properly, but displays error): Fixed in 5.0.15
Bug#13619 (SIG11: encrypt(): salt beginning with "_" followed by any char out ascii64): Fixed in 5.0.15
5.0.13
Bug#7787 (Stored procedures: improper warning for "grant execute" statement): Fixed in 5.0.19
Bug#8768 (Functions: For any unsigned data type, -ve values can be passed and returned.): Fixed in 5.0.18
Bug#9078 (STORED PROCDURE: Decimal digits are not displayed when we use DECIMAL datatype): Fixed in 5.0.18
Bug#10836 (ctype_tis620 test failure with ICC-compiled binaries on IA64): Fixed in 5.0.15
Bug#12037 (ndb_mgmd IP address do not show in other ndb_mgmd processes): Fixed in 5.0.14
Bug#12704 (Server crashes during trigger execution): Fixed in 5.0.13
Bug#12841 (Server crash on DO IFNULL(NULL,NULL);): Fixed in 5.0.13
Bug#12844 (Multi-update or mul-DELETE that calls func with side-effect goes not to binlog): Fixed in 5.0.14
Bug#12845 (Stress test: Server crashes on CREATE .. SELECT statement): Fixed in 5.0.13
Bug#12849 (Stored Procedure: Crash on procedure call with CHAR type 'INOUT' parameter): Fixed in 5.0.13
Bug#12870 (CREATE PROCEDURE followed by ROLLBACK is not replicated): Fixed in 5.0.13
Bug#12935 (Local and XA transactions not mutually exclusive): Fixed in 5.0.15
Bug#12953 (Stored procedures: crash if OPTIMIZE TABLE in function): Fixed in 5.0.13
Bug#12974 (mysqld --no-defaults --sql-bin-update-same crashes with a segfault): Fixed in 5.0.16
Bug#12976 (stored procedures local variables of type bit): Fixed in 5.0.41, 5.0.38
Bug#12979 (Stored procedures: crash if inout decimal parameter): Fixed in 5.0.13
Bug#13037 (undefined variable in IF cause erroneous error-message): Fixed in 5.0.15
Bug#13046 (LIKE pattern matching using prefix index doesn't return correct result(2)): Fixed in 5.0.15
Bug#13081 (NDB gets incorrect result in test-ATIS): Fixed in 5.0.14
Bug#13095 (Cannot create VIEWs in prepared statements): Fixed in 5.0.15
Bug#13127 (LEFT JOIN against a VIEW returns NULL instead of correct value): Fixed in 5.0.14
Bug#13158 (mysql_config returns erroneous 'libs' under x86_64): Fixed in 5.0.20
Bug#13159 (libmysqlclient.a in x86_64 RPM not compiled with -fPIC): Fixed in 5.0.22
Bug#13202 (SELECT * INTO OUTFILE ... FROM information_schema.schemata now fails): Fixed in 5.0.15
Bug#13326 (SQLPS statement logging is incomplete in 5.0): Fixed in 5.0.48, 5.0.51
Bug#13377 (After RESET MASTER, the delete of "master-bin.000001" fails on Windows): Fixed in 5.0.17
Bug#13501 (build problem: too many arguments to function my_bool acl_init): Fixed in 5.0.14
Bug#13514 (server crash when create a stored procedure before choose a database): Fixed in 5.0.16
Bug#13549 (Server crash with nested stored procedures): Fixed in 5.0.17
Bug#13550 (--without-server compilation fails): Fixed in 5.0.14
Bug#13551 (#1054 - Unknown column 'xxxx' in 'on clause'): Fixed in 5.0.12
Bug#13573 (wrong data inserted for too big values for INSERT into DECIMAL column): Fixed in 5.0.16
Bug#13575 (SELECT id, myFunc(id) FROM aTable ORDER BY id; returns bad data): Fixed in 5.0.20
Bug#13587 (Server crash when SP is created without database selected): Fixed in 5.0.16
Bug#13622 (VIEW depending on information_schema.TRIGGERS claims it does not exist): Fixed in 5.0.17
Bug#13634 (Failed dependencies for 5.0.13 RPMs): Fixed in 5.0.23
Bug#13705 (parameters to stored procedures are not verified): Fixed in 5.0.18
Bug#13707 (Server crash with INSERT DELAYED on MyISAM table): Fixed in 5.0.16
Bug#13724 (federated tables structure not replicable): Fixed in 5.0.16
Bug#13783 (mysqlcheck tries to optimize and analyze information_schema): Fixed in 5.0.15
Bug#13808 (ENUM type stored procedure parameter accepts non-enumerated data): Fixed in 5.0.18
Bug#13809 (mysql-test: --replace_result option works on Windows incorrect): Fixed in 5.0.19
Bug#13811 (example configs have misnamed thread_cache parameter): Fixed in 5.0.16
Bug#13820 (Handling of logarithm math functions with negative values): Fixed in 5.0.16
Bug#13835 (max key length is 1000 bytes when trying to create a fulltext index): Fixed in 5.0.19
Bug#13897 (mysqlbinlog outputs wrong 'SET @@session.sql_mode' statement): Fixed in 5.0.19
Bug#13900 (DATETIME data changes after inserting a new row in a InnoDB table): Fixed in 5.0.16
Bug#13909 (Varchar Stored Procedure Parameter always BINARY string (ignores CHARACTER SET)): Fixed in 5.0.18
Bug#13919 (Escape does not work as expected): Fixed in 5.0.15
Bug#13941 (replace() string fuction behaves badly inside stored procedure): Fixed in 5.0.16
Bug#13961 (Triggers on tables with auto_increment insert bogus values into table): Fixed in 5.0.14
Bug#14027 (updatable views cannot be updated in certain cases): Fixed in 5.0.16
Bug#14061 (mysqldump fails when dumping view): Fixed in 5.0.15
Bug#14089 (FROM list subquery always fails when information_schema is current database): Fixed in 5.0.16
Bug#14093 (Query takes a lot of time when date format is not valid): Fixed in 5.0.16
Bug#14094 (SLEEP() and Windows seems to be a bad combination.): Fixed in 5.0.36, 5.0.37
Bug#14139 (Incorrect CREATE TABLE (...) SELECT ... behaviour): Fixed in 5.0.16
Bug#14155 (MAX_ROWS is wrong on 64bit platform): Fixed in 5.0.17
Bug#14161 (Stored procedure cannot retrieve bigint unsigned): Fixed in 5.0.18
Bug#14169 (ORDER BY changes field type to BLOB for GROUP_CONCAT): Fixed in 5.0.19
Bug#14202 (libmysqlclient.a for Solaris-sparc not compiled with -fPIC): Fixed in 5.0.22
Bug#14233 (Crash after tampering with the mysql.proc table): Fixed in 5.0.17
Bug#14719 (Views DEFINER grammar is incorrect): Fixed in 5.0.17
Bug#14871 (mysqldump: invalid view dump output): Fixed in 5.0.19
Bug#15028 (Update multiple tables updates more rows than expected): Fixed in 5.0.17
Bug#15091 (Sp Returns Unknown error in order clause....and there is no order by clause): Fixed in 5.0.19
Bug#16710 (select distinct doesn't return all it should): Fixed in 5.0.21
5.0.14
Bug#8702 (Stored Procedures: No Error/Warning shown for inappropriate data type matching.): Fixed in 5.0.18
Bug#12198 (Temporary Table Aliasing does not work inside stored procedure): Fixed in 5.0.19
Bug#13410 (HAVING clause filtering on qualified view column fails to resolve): Fixed in 5.0.15
Bug#13411 (HAVING clause filtering on unqualified view column name crashes server): Fixed in 5.0.14
Bug#13455 (JOIN: different execution plans for (col=BETWEEN '0' AND '0') AND (col='0')): Fixed in 5.0.14
Bug#13484 (Wrong result on SELECT of table with multiple keys): Fixed in 5.0.15
Bug#13488 (Left outer join query incorrectly gives MYSQL_DATA_TRUNCATED): Fixed in 5.0.17
Bug#13514 (server crash when create a stored procedure before choose a database): Fixed in 5.0.16
Bug#13524 (lock timeout gives incorrect warning on open cursor): Fixed in 5.0.17
Bug#13545 (Server crash caused by select query): Fixed in 5.0.14
Bug#13573 (wrong data inserted for too big values for INSERT into DECIMAL column): Fixed in 5.0.16
Bug#13627 (MySQL crashes when invoking DROP TRIGGER in a trigger): Fixed in 5.0.17
Bug#13667 (Inconsistency for decimal(m,d) specification): Fixed in 5.0.16
Bug#13675 (DATETIME/DATE type in store proc param seems to be converted as varbinary): Fixed in 5.0.51, 5.0.50
Bug#13683 (INSERT DELAYED into a view create an infinite loop): Fixed in 5.0.21
Bug#13818 (SHOW CREATE VIEW / TABLE and information_schema.views fail for invalid view): Fixed in 5.0.17
Bug#13832 ("Unknown column 't1.a' in 'on clause" once again): Fixed in 5.0.16
5.0.15
Bug#5792 (MYSQL_TCP_PORT is ignored in mysql command-line client): Fixed in 5.0.17
Bug#12166 (Unable to index very large tables): Fixed in 5.0.16
Bug#13683 (INSERT DELAYED into a view create an infinite loop): Fixed in 5.0.21
Bug#13729 (Stored procedures: packet error after exception handled): Fixed in 5.0.17
Bug#13783 (mysqlcheck tries to optimize and analyze information_schema): Fixed in 5.0.15
Bug#13835 (max key length is 1000 bytes when trying to create a fulltext index): Fixed in 5.0.19
Bug#13919 (Escape does not work as expected): Fixed in 5.0.15
Bug#13926 (mysqldump --order-by-primary fails if PK column needs quoting): Fixed in 5.0.36, 5.0.37
Bug#13975 ("same string" + 0 has 2 different results): Fixed in 5.0.23
Bug#13987 (Cluster: Loss of data nodes can cause high CPU usage from ndb_mgmd): Fixed in 5.0.23
Bug#14026 (Using nested LEFT JOIN in a VIEW with Prepared Statements causes crash.): Fixed in 5.0.16
Bug#14027 (updatable views cannot be updated in certain cases): Fixed in 5.0.16
Bug#14064 (information_schema test fails on opnsrv6c): Fixed in 5.0.15
Bug#14065 (tests containing 'show table status...' fail on opnsrv6c): Fixed in 5.0.15
Bug#14137 (SHOW VARIABLES called on Windows shows a 'non-Windows' path): Fixed in 5.0.16
Bug#14139 (Incorrect CREATE TABLE (...) SELECT ... behaviour): Fixed in 5.0.16
Bug#14146 (CHAR(...USING ...) and CONVERT(CHAR(...) USING...) produce different results): Fixed in 5.0.17
Bug#14169 (ORDER BY changes field type to BLOB for GROUP_CONCAT): Fixed in 5.0.19
Bug#14202 (libmysqlclient.a for Solaris-sparc not compiled with -fPIC): Fixed in 5.0.22
Bug#14212 (BDB: Server crash after COMMIT + ALTER TABLE): Fixed in 5.0.19
Bug#14262 (SP: DROP PROCEDURE|VIEW (maybe more) write to binlog too late (race cond)): Fixed in 5.0.33, 5.0.30
Bug#14271 (I_S: columns has no size for (var)binary columns): Fixed in 5.0.18
Bug#14304 (auto_increment field incorrect set from within stored procedure (insert select)): Fixed in 5.0.17
Bug#14308 (server hang, with recursive view (after rename table)): Fixed in 5.0.21
Bug#14310 (Database symbolic link isn't detected by server on windows): Fixed in 5.0.17
Bug#14342 (Complex subquery is causing the server to hang/crash): Fixed in 5.0.17
Bug#14358 (mysql client parser error with "use foo;" command (database names <= 3 chars)): Fixed in 5.0.16
Bug#14376 (MySQL crash on scoped variable (re)initialization): Fixed in 5.0.17
Bug#14387 (SHOW COLUMNS doesn't work on temporary tables.): Fixed in 5.0.18
Bug#14466 (Sort Order Incorrect in GROUP_CONCAT Function in a View): Fixed in 5.0.16
Bug#14469 (mysql_fix_privilege_tables.sql error in script): Fixed in 5.0.17
Bug#14476 (`information_schema`.`TABLES`.`TABLE_TYPE` with empty value): Fixed in 5.0.17
Bug#14496 (Crash or strange results with prepared statement, MATCH and FULLTEXT): Fixed in 5.0.19
Bug#14537 (Instanse manager crashes with 'access violation' when started on Windows): Fixed in 5.0.16
Bug#14540 (REPAIR, OPTIMIZE or ANALYZE a VIEW crashes server when underlying table is gone): Fixed in 5.0.16
Bug#14553 (NULL in WHERE resets LAST_INSERT_ID): Fixed in 5.0.25
Bug#14554 (bad dump of triggers by mysqldump): Fixed in 5.0.17
Bug#14569 (editing a stored procedure kills mysqld-nt): Fixed in 5.0.17
Bug#14583 (Bug on query using a LIKE on indexed field with ucs2_bin collation): Fixed in 5.0.19
Bug#14610 (mysqlhotcopy tries to copy virtual information_scheme table): Fixed in 5.0.17
Bug#14614 (TRIGGER crashing on UPDATE if other database selected): Fixed in 5.0.18
Bug#14616 (Freshly imported table returns error 124 when using LIMIT): Fixed in 5.0.17
Bug#14649 (MySQLInstanceConfig.exe fails when writing configuration file): Fixed in 5.0.51, 5.0.46
Bug#14676 (substring_index yields different results on same arguments): Fixed in 5.0.19
Bug#14693 (Cannot create a new column default after column created): Fixed in 5.0.17
Bug#14708 (Inconsistent treatment of NULLs in LEFT JOINed FULLTEXT matching without index): Fixed in 5.0.23
Bug#14726 (Crash when mysqldump encounters a view while privileges limited.): Fixed in 5.0.17
Bug#14768 (last_insert_id not set using Federated): Fixed in 5.0.19
Bug#14770 (LOAD DATA INFILE doesn't respect default values for columns): Fixed in 5.0.25
Bug#14807 (GeomFromText() should return MYSQL_TYPE_GEOMETRY): Fixed in 5.0.25
Bug#14816 (VIEW performs filesort when using ORDER BY but underlying table does not): Fixed in 5.0.17
Bug#14828 (ALL Nodes Crash. Forced node shutdown completed. Initiated by signal 0. Caused): Fixed in 5.0.17
Bug#14834 (Server denies to execute Stored Procedure): Fixed in 5.0.19
Bug#14850 (ERROR 1062 when a quering a view using a Group By on a column that can be null.): Fixed in 5.0.17
Bug#14861 (aliased column names are not preserved.): Fixed in 5.0.18
Bug#14885 (Out of memory when creating view in stored procedure): Fixed in 5.0.17
Bug#14902 (ANALYZE TABLE fails to recognize up-to-date tables): Fixed in 5.0.17
Bug#14920 (Ordering aggregated result sets with composite primary keys corrupts resultset): Fixed in 5.0.17
Bug#14945 (Truncate table doesn't reset the auto_increment counter): Fixed in 5.0.21
Bug#14946 (BENCHMARK() function returns strange results for stored functions): Fixed in 5.0.19
Bug#14956 (no way to get row_count() info when using prepared statements): Fixed in 5.0.17
Bug#14960 (Symbolic links do not work on Windows): Fixed in 5.0.17
Bug#14980 (COUNT(*) incorrect on MyISAM table with certain INDEX): Fixed in 5.0.20
Bug#15025 (LOAD DATA FROM MASTER attempts to load INFORMATION_SCHEMA): Fixed in 5.0.26
Bug#15028 (Update multiple tables updates more rows than expected): Fixed in 5.0.17
Bug#15094 (VC++ project is not correct (with other minor problems)): Fixed in 5.0.17
Bug#15096 (View -< Function -< View = Crash): Fixed in 5.0.17
Bug#15101 (sysdate() digregards SET TIMESTAMP): Fixed in 5.0.20
Bug#15106 (EXPLAIN output differs for almost same query): Fixed in 5.0.18
Bug#15215 (mysqld fails at start-up because of illegal reply from mgmd): Fixed in 5.0.17
Bug#15240 (NDBD is aborted in MySQL Cluster): Fixed in 5.0.17
Bug#15392 (Server crashes during prepared statement execute): Fixed in 5.0.17
Bug#15441 (Running SP causes Server to Crash): Fixed in 5.0.18
Bug#15658 (Server crashes after creating function as empty string): Fixed in 5.0.19
Bug#15682 (Incorrect handling of varchar primary keys, when doing filesort): Fixed in 5.0.17
Bug#15728 (LAST_INSERT_ID function inside a stored function returns 0): Fixed in 5.0.21
Bug#15772 (Aborted YaSSL connections force threads into busyloops): Fixed in 5.0.18
Bug#15811 (extremely long time for mysql client to execute long INSERT): Fixed in 5.0.23
Bug#16143 (mysql_stmt_sqlstate returns an empty string instead of '00000'): Fixed in 5.0.19
Bug#16172 (DECIMAL data type processed incorrectly): Fixed in 5.0.25
Bug#18544 (LOCK TABLES timeout causes MyISAM table corruption): Fixed in 5.0.21
Bug#19025 (mysqldump doesn't correctly dump "auto_increment = [int]"): Fixed in 5.0.23
Bug#19370 (DateTime datatype in MySQL has two bugs in it): Fixed in 5.0.25
Bug#19745 (mysqldump --xml produces invalid xml): Fixed in 5.0.33, 5.0.30
Bug#19764 (SHOW commands end up in the slow log as table scans): Fixed in 5.0.33, 5.0.30
Bug#21811 (Odd casting with date + INTERVAL arithmetic): Fixed in 5.0.33, 5.0.30
5.0.16
Bug#9815 (--skip-innodb --default-table-type=innodb leads to assertion failure): Fixed in 5.0.16
Bug#12071 (Windows hang: 'Opening tables' or 'Waiting for table' lockup): Fixed in 5.0.18
Bug#12751 (Instance Manager: client hangs after start instance; kill mysqlmanager; show ...): Fixed in 5.0.33, 5.0.30
Bug#13707 (Server crash with INSERT DELAYED on MyISAM table): Fixed in 5.0.16
Bug#14061 (mysqldump fails when dumping view): Fixed in 5.0.15
Bug#14090 (The server stores junk in the TRG/TRN files): Fixed in 5.0.17
Bug#14094 (SLEEP() and Windows seems to be a bad combination.): Fixed in 5.0.36, 5.0.37
Bug#14146 (CHAR(...USING ...) and CONVERT(CHAR(...) USING...) produce different results): Fixed in 5.0.17
Bug#14161 (Stored procedure cannot retrieve bigint unsigned): Fixed in 5.0.18
Bug#14169 (ORDER BY changes field type to BLOB for GROUP_CONCAT): Fixed in 5.0.19
Bug#14189 (VARBINARY and BINARY variables: trailing space ignored with InnoDB): Fixed in 5.0.19
Bug#14207 (strange change of values CHARACTER_OCTET_LENGTH and CHARACTER_MAXIMUM_LENGTH): Fixed in 5.0.16
Bug#14210 (Simple query with < operator on large table gives server crash): Fixed in 5.0.16
Bug#14233 (Crash after tampering with the mysql.proc table): Fixed in 5.0.17
Bug#14256 (definer in view definition is not fully qualified): Fixed in 5.0.16
Bug#14270 (Stored procedures: crash if load index): Fixed in 5.0.19
Bug#14299 (BINARY space truncation should cause warning or error): Fixed in 5.0.17
Bug#14308 (server hang, with recursive view (after rename table)): Fixed in 5.0.21
Bug#14342 (Complex subquery is causing the server to hang/crash): Fixed in 5.0.17
Bug#14376 (MySQL crash on scoped variable (re)initialization): Fixed in 5.0.17
Bug#14381 (Key length is limited to 255 bytes on BDB): Fixed in 5.0.16
Bug#14387 (SHOW COLUMNS doesn't work on temporary tables.): Fixed in 5.0.18
Bug#14476 (`information_schema`.`TABLES`.`TABLE_TYPE` with empty value): Fixed in 5.0.17
Bug#14482 (Server crash when subselecting from the same table): Fixed in 5.0.16
Bug#14496 (Crash or strange results with prepared statement, MATCH and FULLTEXT): Fixed in 5.0.19
Bug#14498 (Stored procedures: hang if undefined variable and exception): Fixed in 5.0.19
Bug#14540 (REPAIR, OPTIMIZE or ANALYZE a VIEW crashes server when underlying table is gone): Fixed in 5.0.16
Bug#14553 (NULL in WHERE resets LAST_INSERT_ID): Fixed in 5.0.25
Bug#14554 (bad dump of triggers by mysqldump): Fixed in 5.0.17
Bug#14610 (mysqlhotcopy tries to copy virtual information_scheme table): Fixed in 5.0.17
Bug#14643 (Stored Procedure: Continuing after failed var. initialization crashes server.): Fixed in 5.0.17
Bug#14654 (Cannot select from the same table twice within a UNION statement): Fixed in 5.0.26
Bug#14662 (ORDER BY on column of a view, with an alias of the same column causes ambiguous): Fixed in 5.0.17
Bug#14676 (substring_index yields different results on same arguments): Fixed in 5.0.19
Bug#14693 (Cannot create a new column default after column created): Fixed in 5.0.17
Bug#14723 (Dumping of stored functions seems to cause corruption in the function body): Fixed in 5.0.16
Bug#14747 (Race condition can cause btr_search_drop_page_hash_index() to crash): Fixed in 5.0.17
Bug#14768 (last_insert_id not set using Federated): Fixed in 5.0.19
Bug#14816 (VIEW performs filesort when using ORDER BY but underlying table does not): Fixed in 5.0.17
Bug#14863 (Triggers: crash if create before use): Fixed in 5.0.18
Bug#14875 (Bad view DEFINER makes SHOW CREATE VIEW fail): Fixed in 5.0.23
Bug#14885 (Out of memory when creating view in stored procedure): Fixed in 5.0.17
Bug#15097 (missing LF at end of version string of mysql.exe): Fixed in 5.0.17
Bug#15108 (mysqld crashes when innodb_log_file_size is set < 4G): Fixed in 5.0.19
Bug#15130 (CREATE TABLE ... SELECT SQL_BIG_RESULT looses filesort optimization): Fixed in 5.0.48, 5.0.51
Bug#15133 (unique index with nullable value not accepted in federated table): Fixed in 5.0.25
Bug#15137 (CREATE TABLE ... SECLECT .. from a view with stored function doesn't work): Fixed in 5.0.23
Bug#15185 (Server crashes if InnoDB table is opened when InnoDB is disabled): Fixed in 5.0.19
Bug#15204 (5.0 Crashes when selecting from imported data): Fixed in 5.0.17
Bug#15209 (MySQL installation problem on Windows ME): Fixed in 5.0.17
Bug#15217 (Using a SP cursor on a table created with PREPARE fails with weird error): Fixed in 5.0.23
Bug#15223 (5.0.16/5.0.17/4.1.16 RPM packages provides wrong zlib dependancy): Fixed in 5.0.17
Bug#15224 (SHOW INDEX from temporary table doesn't work): Fixed in 5.0.18
Bug#15229 (Unknown column when mixing ON and USING): Fixed in 5.0.20
Bug#15231 (Stored procedure bug with not found condition handler): Fixed in 5.0.19
Bug#15298 (SHOW GRANTS FOR CURRENT_USER: Incorrect output in DEFINER context): Fixed in 5.0.25
Bug#15307 (GROUP_CONCAT() with ORDER BY returns empty set on information_schema): Fixed in 5.0.19
Bug#15308 (Problem of Order with Enum Column in Primary Key): Fixed in 5.0.19
Bug#15328 (Segmentation fault occured if my.cnf is invalid for escape sequence): Fixed in 5.0.23
Bug#15439 (UDF name case handling forces DELETE FROM mysql.func to remove the UDF): Fixed in 5.0.37, 5.0.34
Bug#15463 (EXPLAIN SELECT..INTO hangs the client (QB, command line)): Fixed in 5.0.23
Bug#15512 (crash during online add of API/SQL node): Fixed in 5.0.17
Bug#15517 (Nodes shutting down when using NdbAPI equal() method on a VARCHAR field): Fixed in 5.0.17
Bug#15560 (GROUP_CONCAT on subquery with GROUP_CONCAT usually returns NULL): Fixed in 5.0.21
Bug#15562 (Package for Solaris 10 has invalid unix group 'wheel' reference): Fixed in 5.0.19
Bug#15598 (Server crashes in specific case during setting new password): Fixed in 5.0.19
Bug#15619 (Test case 'ndb_autodiscover' failure on Linux/Itanium): Fixed in 5.0.19
Bug#15633 (join order differences can affect optimizer and result in corrupted datasets): Fixed in 5.0.19
Bug#15650 (DELETE with LEFT JOIN crashes server with innodb_locks_unsafe_for_binlog): Fixed in 5.0.21
Bug#15658 (Server crashes after creating function as empty string): Fixed in 5.0.19
Bug#15690 (mysqlimport tries to set options the server doesn't understand): Fixed in 5.0.25
Bug#15695 (startings nodes hang in phase 2 forever on temporary network failure): Fixed in 5.0.21
Bug#15719 (MYSQL_OPT_RECONNECT option is modified by mysql_real_connect): Fixed in 5.0.19
Bug#15745 (COUNT(DISTINCT x,y) and COUNT(DISTINCT CONCAT(x,y)) return different values): Fixed in 5.0.20
Bug#15757 (The substring function does not work as expected): Fixed in 5.0.41, 5.0.38
Bug#15758 (Holding adaptive search latch in innobase_query_caching_of_table_permitted()): Fixed in 5.0.21
Bug#15759 (MySQL 5.0.16 doesn't include the help tables properly on Windows): Fixed in 5.0.19
Bug#15760 (fill_help_tables.sql doesn't work in strict mode): Fixed in 5.0.19
Bug#15772 (Aborted YaSSL connections force threads into busyloops): Fixed in 5.0.18
Bug#15787 (MySQL crashes when archive table exceeds 2GB): Fixed in 5.0.51, 5.0.46
Bug#15846 (libmysql: handle-leak in mysql_close with shared memory (fix supplied)): Fixed in 5.0.20
Bug#15851 (Unlistable directories yield no info from information_schema): Fixed in 5.0.19
Bug#15860 (SPATIAL KEY InnoDB crash: MySQL gives key len too small?): Fixed in 5.0.23
Bug#15872 (large NOT IN (a,b,c,d) lists consume huge amounts of memory in DML queries): Fixed in 5.0.21
Bug#15933 (max_used_connections is wrong after FLUSH STATUS if connections are cached): Fixed in 5.0.21
Bug#16201 (Indexed query on a table with clause using 3+ indexes crashes InnoDB server): Fixed in 5.0.25
Bug#16281 (Multi-table update failing to change matched rows): Fixed in 5.0.21
Bug#16377 ([BETWEEN] Weird issue when selecting records between two hard-coded dates): Fixed in 5.0.42, 5.0.45
Bug#16603 (Row subquery gives different result when index is added): Fixed in 5.0.19
Bug#18819 (DELETE IGNORE hangs on foreign key parent delete): Fixed in 5.0.33, 5.0.30
5.0.17
Bug#13134 (Length of VARCHAR() utf8 column is increasing when table is recreated with PS/SP): Fixed in 5.0.19
Bug#14708 (Inconsistent treatment of NULLs in LEFT JOINed FULLTEXT matching without index): Fixed in 5.0.23
Bug#14845 (mysql_stmt_fetch returns MYSQL_NO_DATA when COUNT(*) is 0): Fixed in 5.0.17
Bug#14850 (ERROR 1062 when a quering a view using a Group By on a column that can be null.): Fixed in 5.0.17
Bug#14857 (Reading dump files with single statement stored routines fails.): Fixed in 5.0.19
Bug#14861 (aliased column names are not preserved.): Fixed in 5.0.18
Bug#14863 (Triggers: crash if create before use): Fixed in 5.0.18
Bug#14875 (Bad view DEFINER makes SHOW CREATE VIEW fail): Fixed in 5.0.23
Bug#14902 (ANALYZE TABLE fails to recognize up-to-date tables): Fixed in 5.0.17
Bug#14920 (Ordering aggregated result sets with composite primary keys corrupts resultset): Fixed in 5.0.17
Bug#14945 (Truncate table doesn't reset the auto_increment counter): Fixed in 5.0.21
Bug#14980 (COUNT(*) incorrect on MyISAM table with certain INDEX): Fixed in 5.0.20
Bug#15011 (error handler for mysql errno in nested block not activated): Fixed in 5.0.19
Bug#15025 (LOAD DATA FROM MASTER attempts to load INFORMATION_SCHEMA): Fixed in 5.0.26
Bug#15028 (Update multiple tables updates more rows than expected): Fixed in 5.0.17
Bug#15047 (server crash when compiling without transaction support): Fixed in 5.0.17
Bug#15096 (View -< Function -< View = Crash): Fixed in 5.0.17
Bug#15101 (sysdate() digregards SET TIMESTAMP): Fixed in 5.0.20
Bug#15103 (SHOW TRIGGERS: small output alignment problem): Fixed in 5.0.18
Bug#15106 (EXPLAIN output differs for almost same query): Fixed in 5.0.18
Bug#15110 (mysqldump --triggers: does not include DEFINER clause): Fixed in 5.0.18
Bug#15133 (unique index with nullable value not accepted in federated table): Fixed in 5.0.25
Bug#15185 (Server crashes if InnoDB table is opened when InnoDB is disabled): Fixed in 5.0.19
Bug#15195 (Security Breach with MERGE table): Fixed in 5.0.24
Bug#15206 (Misleading message "No data to FETCH"): Fixed in 5.0.19
Bug#15223 (5.0.16/5.0.17/4.1.16 RPM packages provides wrong zlib dependancy): Fixed in 5.0.17
Bug#15224 (SHOW INDEX from temporary table doesn't work): Fixed in 5.0.18
Bug#15231 (Stored procedure bug with not found condition handler): Fixed in 5.0.19
Bug#15298 (SHOW GRANTS FOR CURRENT_USER: Incorrect output in DEFINER context): Fixed in 5.0.25
Bug#15307 (GROUP_CONCAT() with ORDER BY returns empty set on information_schema): Fixed in 5.0.19
Bug#15308 (Problem of Order with Enum Column in Primary Key): Fixed in 5.0.19
Bug#15328 (Segmentation fault occured if my.cnf is invalid for escape sequence): Fixed in 5.0.23
Bug#15347 (query with subquery has different results on 4.1 and 5.0): Fixed in 5.0.19
Bug#15355 (Common natural join column not resolved in prepared statement nested query): Fixed in 5.0.23
Bug#15425 (Small window for NF during backup failing without error): Fixed in 5.0.17
Bug#15441 (Running SP causes Server to Crash): Fixed in 5.0.18
Bug#15463 (EXPLAIN SELECT..INTO hangs the client (QB, command line)): Fixed in 5.0.23
Bug#15510 (mysql_warning_count returns 0 after mysql_stmt_fetch which should warn): Fixed in 5.0.17
Bug#15518 (Reusing a stmt that has failed during prepare does not clear error): Fixed in 5.0.36, 5.0.37
Bug#15583 (BIN()/OCT()/CONV() do not work with BIT values): Fixed in 5.0.26
Bug#15605 (5.0.17 test case 'mysqltest' failure): Fixed in 5.0.17
Bug#15623 (Test case rpl000001 and rpl_error_ignored_table failure on MacOSX): Fixed in 5.0.17
Bug#15630 (Test case failure in sp-dynamic, sp-error, and sp): Fixed in 5.0.17
Bug#15634 (Runtime stack overflow Windows's compiler warning): Fixed in 5.0.19
Bug#15668 (Test 'sp-error' crashes server on Mac OS X): Fixed in 5.0.17
Bug#15669 (Test case 'csv' produces incorrect result on OpenBSD): Fixed in 5.0.25
Bug#15675 (Test 'ndb_read_multi_range' fails on FreeBSD and HP-UX 11.23 IA64): Fixed in 5.0.18
Bug#15699 (multi-table update does not work with replicate-wild-do-table): Fixed in 5.0.19
Bug#15775 ("drop user" command does not refresh acl_check_hosts): Fixed in 5.0.19
Bug#15866 (main.sp fails (thread stack limit insufficient for recursive call "fib(20)")): Fixed in 5.0.19
Bug#15917 (wrong result in NIST test on Windows for nested SELECT with GROUP BY): Fixed in 5.0.21
Bug#15943 (mysql_next_result hangs on invalid SHOW CREATE VIEW): Fixed in 5.0.19
Bug#15950 (NOW() optimized away to constant in BETWEEN ... AND ... in VIEWs): Fixed in 5.0.25
Bug#15962 (union truncate column composed by concat()): Fixed in 5.0.23
Bug#16069 (Using BETWEEN with a VIEW doesn't work correctly): Fixed in 5.0.21
Bug#16110 (insert permitted into view col w/o default value): Fixed in 5.0.25
Bug#16168 (execute the same queries, however the results are different): Fixed in 5.0.25
Bug#16260 (VIEW MERGE fails (connection lost) for some select): Fixed in 5.0.19
Bug#16266 (Definer is not fully qualified error during replication): Fixed in 5.0.17, 5.0.20
Bug#16372 (server crashes when test 'conc_sys' is running): Fixed in 5.0.23
Bug#16387 (InnoDB crash when dropping a foreign key <table<_ibfk_0): Fixed in 5.0.19
Bug#16581 (deadlock: server and client both read from connection in 'conc_sys' test): Fixed in 5.0.25
Bug#16593 (Deadlock or crash in stress test for case where triggers starting trigger): Fixed in 5.0.19
Bug#16662 (rpm packages built with icc compiler depended on icc libraries): Fixed in 5.0.21
Bug#16710 (select distinct doesn't return all it should): Fixed in 5.0.21
Bug#16716 (constant subselect - incorrect result on sequential rows): Fixed in 5.0.23
Bug#17194 (Problem with usage of mysql-test suite shipped for RPM based platforms): Fixed in 5.0.33, 5.0.30
Bug#17204 (second CALL to procedure crashes Server): Fixed in 5.0.23
Bug#19147 (mysqlshow INFORMATION_SCHEMA does not work): Fixed in 5.0.25
Bug#23760 (row_count() and store procedure not working together): Fixed in 5.0.33, 5.0.32
5.0.18
Bug#14028 ([Data Loss] NDB node crashes during backup if a BLOB is inserted and deleted): Fixed in 5.0.20
Bug#14346 (Prepared statements corrupting general log/server memory): Fixed in 5.0.25
Bug#14635 (Accept NEW.x as INOUT parameters to stored procedures from within triggers): Fixed in 5.0.23
Bug#15588 (String overrun during sp-vars.test): Fixed in 5.0.19
Bug#15613 (libmysqlclient API function mysql_stmt_prepare returns wrong field length): Fixed in 5.0.18
Bug#15633 (join order differences can affect optimizer and result in corrupted datasets): Fixed in 5.0.19
Bug#15650 (DELETE with LEFT JOIN crashes server with innodb_locks_unsafe_for_binlog): Fixed in 5.0.21
Bug#15658 (Server crashes after creating function as empty string): Fixed in 5.0.19
Bug#15684 (system variables cannot be SELECTed (e.g. @@version_comment)): Fixed in 5.0.23
Bug#15728 (LAST_INSERT_ID function inside a stored function returns 0): Fixed in 5.0.21
Bug#15752 (Lost connection to MySQL server when calling a SP from C API): Fixed in 5.0.25
Bug#15787 (MySQL crashes when archive table exceeds 2GB): Fixed in 5.0.51, 5.0.46
Bug#15846 (libmysql: handle-leak in mysql_close with shared memory (fix supplied)): Fixed in 5.0.20
Bug#15860 (SPATIAL KEY InnoDB crash: MySQL gives key len too small?): Fixed in 5.0.23
Bug#15963 (SBR does not show "Definer" correctly on slave host (rpl_ddl.test)): Fixed in 5.0.20
Bug#16016 (Problem with optimization of SELECT MAX() FROM view): Fixed in 5.0.19
Bug#16195 (SHOW VARIABLES doesn't report correctly sql_warnings and sql_notes values): Fixed in 5.0.23
Bug#16201 (Indexed query on a table with clause using 3+ indexes crashes InnoDB server): Fixed in 5.0.25
Bug#16203 (GROUP BY on column used in where returns false empty result): Fixed in 5.0.19
Bug#16226 (TIMESTAMPDIFF seems to ignore time when interval is bigger than week): Fixed in 5.0.25
Bug#16240 (datadir after basedir in my.cnf causes datadir to be possibly incorrect): Fixed in 5.0.21
Bug#16249 (Different results for query with and without indexes): Fixed in 5.0.25
Bug#16272 (IF with floting point values does not work with GROUP BY): Fixed in 5.0.19
Bug#16298 (InnoDB segfaults in INSERTs in upgrade of 4.0 -< 5.0 tables with VARCHAR BINARY): Fixed in 5.0.19
Bug#16302 (Non-table subquery with ANY gives wrong results): Fixed in 5.0.25
Bug#16303 (erroneus stored procedures and functions should be droppable): Fixed in 5.0.19
Bug#16377 ([BETWEEN] Weird issue when selecting records between two hard-coded dates): Fixed in 5.0.42, 5.0.45
Bug#16382 (SELECT with IF and GROUP BY on VIEW can crash server): Fixed in 5.0.19
Bug#16393 (No index used on outer table of nested left join): Fixed in 5.0.19
Bug#16461 (connection_id() does not work properly inside trigger): Fixed in 5.0.21
Bug#16487 (table ignores fail with multiple tables in updates): Fixed in 5.0.19
Bug#16494 (Updates that set a column to NULL fail sometimes): Fixed in 5.0.25
Bug#16502 (mysqlcheck gets confused with views): Fixed in 5.0.23
Bug#16513 (mysql_set_server_option not present in libmysqld.lib/exp): Fixed in 5.0.25
Bug#16520 (solaris package does not include shared/relocatable libraries): Fixed in 5.0.41
Bug#16557 (mysql cmd-line client does not rename .mysql_history.TMP to .mysql_history): Fixed in 5.0.19
Bug#16559 (Replication Problems with Non transactional tables inside an interrupted trans.): Fixed in 5.0.19
Bug#16582 (InnoDB: Error in an adaptive hash index pointer to page): Fixed in 5.0.19
Bug#16593 (Deadlock or crash in stress test for case where triggers starting trigger): Fixed in 5.0.19
Bug#16676 (Database CHARSET not used for stored procedures): Fixed in 5.0.25
Bug#16681 (information_schema shows forbidden VIEW details): Fixed in 5.0.23
Bug#16712 (group_concat returns odd string instead of intended result): Fixed in 5.0.25
Bug#16716 (constant subselect - incorrect result on sequential rows): Fixed in 5.0.23
Bug#16777 (Can not create trigger nor view w/o definer if --skip-grant-tables specified): Fixed in 5.0.20
Bug#16803 ("ln -s /dev/null .mysql_history" doesn't work!): Fixed in 5.0.23
Bug#16813 (WITH CHECK OPTION doesn't work with UPDATE command): Fixed in 5.0.33, 5.0.30
Bug#16814 (SHOW INNODB STATUS format error in LATEST FOREIGN KEY ERROR section): Fixed in 5.0.20
Bug#16829 (Firing trigger crashes the server): Fixed in 5.0.19
Bug#16861 (User variables and ORDER BY RAND() LIMIT 1 product unexpected result): Fixed in 5.0.25
Bug#16896 (Stored function: unused AGGREGATE-clause in CREATE FUNCTION): Fixed in 5.0.19
Bug#16899 (Possible buffer overflow in handling of DEFINER-clause): Fixed in 5.0.24a
Bug#16986 (Deadlock condition with MyISAM tables): Fixed in 5.0.23
Bug#17001 (Table and server crash on ALTER TABLE): Fixed in 5.0.23
Bug#17044 (FEDERATED storage engine is not UTF8 clean): Fixed in 5.0.37, 5.0.34
Bug#17126 (CHECK TABLE on InnoDB causes a short hang during check of adaptive hash): Fixed in 5.0.20
Bug#17164 (LEFT JOIN with OR clause not optimized correctly): Fixed in 5.0.20
Bug#17199 (Problem when view calls function from another database.): Fixed in 5.0.23
Bug#17201 (mysqldump sometimes creates database twice): Fixed in 5.0.23
Bug#17203 ("sql_no_cache sql_cache" in views created from prepared statement): Fixed in 5.0.23
Bug#17208 (SSL: client does not verify server certificate): Fixed in 5.0.23
Bug#17212 (results not sorted correctly by ORDER BY when using index): Fixed in 5.0.25
Bug#17254 (Error for DEFINER security on VIEW provides too much info): Fixed in 5.0.33, 5.0.32
Bug#17261 (Passing a variable from a stored procedure to UDF crashes mysqld): Fixed in 5.0.20
Bug#17270 (mysql client tool could not find ../share/charsets folder and fails.): Fixed in 5.0.85
Bug#17279 (user with no global privs and with create priv in db can create databases): Fixed in 5.0.20
Bug#17294 (INSERT DELAYED puting an \n before data): Fixed in 5.0.25
Bug#17303 (Create View privileges not available for remote root user): Fixed in 5.0.51a
Bug#17313 (N'xxx' and _utf8'xxx' are not equivalent): Fixed in 5.0.25
Bug#17332 (changing key_buffer_size on a running server can crash under load): Fixed in 5.0.87
Bug#17366 (crash on left join on union with literal, 5.0.18): Fixed in 5.0.20
Bug#17371 (Unable to dump a schema with invalid views): Fixed in 5.0.23
Bug#17374 (select ... like 'A%' operator fails to find value on columuns with key): Fixed in 5.0.20
Bug#17377 (Federated Engine returns wrong Data, always the rows with the highest ID): Fixed in 5.0.20
Bug#17379 (5.0 is slower than 4.0 by 3.5x times in select/join query): Fixed in 5.0.23
Bug#17476 (Stored procedure not returning data when it is called first time per connection): Fixed in 5.0.19
Bug#17485 (Instance Manager: mysql client crashes when connecting to the IM): Fixed in 5.0.25
Bug#17498 (failed to put data file in custom directory use "data directory" option): Fixed in 5.0.36, 5.0.37
Bug#17526 (errors thrown by VIEW using TRIM("x" FROM some_field)): Fixed in 5.0.24
Bug#17530 (Bug in non-UNIQUE index column truncation): Fixed in 5.0.19
Bug#17591 (Updatable view not possible with trigger or stored function): Fixed in 5.0.25
Bug#17602 (Server crash on AVG/SUM over DECIMAL column): Fixed in 5.0.19
Bug#17608 (String literals lost during INSERT query on FEDERATED table): Fixed in 5.0.25
Bug#17615 (invalid handling of function results in UPDATE...SET statement): Fixed in 5.0.20
Bug#17635 (Sleep time long process after time clock adjust in system): Fixed in 5.0.36, 5.0.37
Bug#17661 (information_schema.SCHEMATA returns uppercase with lower_case_table_names = 1): Fixed in 5.0.23
Bug#17667 (An attacker has the opportunity to bypass query logging.): Fixed in 5.0.23
Bug#17726 (mysqld hangs at update of view with check option): Fixed in 5.0.20
Bug#17729 (Result corruption with ORDER BY and NDB tables): Fixed in 5.0.20
Bug#17733 (Flushing logs causes daily server crash): Fixed in 5.0.33, 5.0.32
Bug#17823 ('arc' directories inside database directories): Fixed in 5.0.72
Bug#17826 ( 'type_decimal' fails with ps-protocol): Fixed in 5.0.19
Bug#17843 (Certain stored procedures fail to run at startup): Fixed in 5.0.25
Bug#17951 (myisampack --force --silent : adnormal end in Windows XP): Fixed in 5.0.33, 5.0.32
Bug#18036 (update of table joined to self reports table as crashed): Fixed in 5.0.23
Bug#18037 (Server crash when returning system variable in stored procedures): Fixed in 5.0.23
Bug#18077 (InnoDB uses full explicit table locks in stored FUNCTION): Fixed in 5.0.33, 5.0.30
Bug#18080 (INSERT ... SELECT ... JOIN results in ambiguous field list error): Fixed in 5.0.24
Bug#18091 (libmysqlclient.a relocation error): Fixed in 5.0.22
Bug#18116 (MySQL 5.0 deadlocks while writing binary log): Fixed in 5.0.20
Bug#18160 (Memory-/HEAP Table endless growing indexes): Fixed in 5.0.23
Bug#18165 (SQL optimizer ineficiencies with "BETWEEN" statements): Fixed in 5.0.25
Bug#18175 (union with aggregate function over 128 tables returns fail.): Fixed in 5.0.23
Bug#18177 (any access to INFORMATION_SCHEMA.ROUTINES crashes): Fixed in 5.0.23
Bug#18199 (PURGE BINARY LOGS fails silently with missing logs): Fixed in 5.0.60
Bug#18206 (first key part using prefix of utf8 varchar field yeilds empty set sometimes): Fixed in 5.0.23
Bug#18233 (Memory tables INDEX USING HASH (a,b) returns 1 row on SELECT WHERE a= AND b=): Fixed in 5.0.23
Bug#18238 (When locks exhaust the buffer pool, InnoDB does not roll back the trx): Fixed in 5.0.20
Bug#18503 (Queries with "< ALL (subquery)" on InnoDB tables may return wrong result.): Fixed in 5.0.25
Bug#18539 (uncompress(d) is null: impossible?): Fixed in 5.0.25
Bug#18660 (Can't grant any privileges on single table in database with underscore char): Fixed in 5.0.45, 5.0.44
Bug#18863 (NDB node fails to restart, cluster stuck in state trying to restart it.): Fixed in 5.0.25
Bug#18925 (Dependant, subquery on information_schema.COLUMNS returns wrong result): Fixed in 5.0.25
Bug#19024 (SHOW COUNT(*) WARNINGS not return Errors): Fixed in 5.0.33, 5.0.30
Bug#19288 (Package "shared compat" might not conain newly build 5.0/5.1 shared libs): Fixed in 5.0.21
Bug#19648 (Merge table does not work with bit types): Fixed in 5.0.23
Bug#19700 (subselect returning BIGINT always returned it as SIGNED): Fixed in 5.0.23
Bug#19702 (Using myisampack/myisamchk on a FULLTEXT indexed table results in table corrupt): Fixed in 5.0.26
Bug#20108 (alter table default value errors on enum fields when unicode): Fixed in 5.0.26
Bug#20395 (Cluster Datanodes Always Assigned To NodeGroup 0 During SINGLE USER MODE): Fixed in 5.0.33, 5.0.30
Bug#20697 (slave fails to rollback replicated transaction hang over innodb_lock_wait_timeou): Fixed in 5.0.33, 5.0.32
Bug#21013 (Performance Degrades when importing data that uses Trigger and Stored Procedure): Fixed in 5.0.25
Bug#21174 (Index degrades sort performance and optimizer does not honor IGNORE INDEX ): Fixed in 5.0.40, 5.0.41, 5.0.25
Bug#22989 (START SLAVE causes Error on COM_REGISTER_SLAVE: 1105 'Wrong parameters to functi): Fixed in 5.0.60
Bug#23196 (MySQL server does not exit / shutdown when storage engine returns errno 12): Fixed in 5.0.36, 5.0.37
Bug#28188 ('not exists' optimization for outer joins does not work anymore): Fixed in 5.0.42, 5.0.45
Bug#29166 (MYsql crash when query is run): Fixed in 5.0.51, 5.0.46
Bug#48508 (re-execution of prepared statement crashes!): Fixed in 5.0.90, 5.0.87sp1
5.0.19
Bug#12734 (prepared statement may return incorrect result set for a select SQL request): Fixed in 5.0.19
Bug#13987 (Cluster: Loss of data nodes can cause high CPU usage from ndb_mgmd): Fixed in 5.0.23
Bug#14635 (Accept NEW.x as INOUT parameters to stored procedures from within triggers): Fixed in 5.0.23
Bug#15591 (Occasional test suite abort due to port in use): Fixed in 5.0.19
Bug#15650 (DELETE with LEFT JOIN crashes server with innodb_locks_unsafe_for_binlog): Fixed in 5.0.21
Bug#15811 (extremely long time for mysql client to execute long INSERT): Fixed in 5.0.23
Bug#15933 (max_used_connections is wrong after FLUSH STATUS if connections are cached): Fixed in 5.0.21
Bug#15950 (NOW() optimized away to constant in BETWEEN ... AND ... in VIEWs): Fixed in 5.0.25
Bug#15962 (union truncate column composed by concat()): Fixed in 5.0.23
Bug#16168 (execute the same queries, however the results are different): Fixed in 5.0.25
Bug#16172 (DECIMAL data type processed incorrectly): Fixed in 5.0.25
Bug#16195 (SHOW VARIABLES doesn't report correctly sql_warnings and sql_notes values): Fixed in 5.0.23
Bug#16201 (Indexed query on a table with clause using 3+ indexes crashes InnoDB server): Fixed in 5.0.25
Bug#16203 (GROUP BY on column used in where returns false empty result): Fixed in 5.0.19
Bug#16226 (TIMESTAMPDIFF seems to ignore time when interval is bigger than week): Fixed in 5.0.25
Bug#16249 (Different results for query with and without indexes): Fixed in 5.0.25
Bug#16260 (VIEW MERGE fails (connection lost) for some select): Fixed in 5.0.19
Bug#16297 (In memory grant tables not flushed when users's hostname is ""): Fixed in 5.0.23
Bug#16302 (Non-table subquery with ANY gives wrong results): Fixed in 5.0.25
Bug#16377 ([BETWEEN] Weird issue when selecting records between two hard-coded dates): Fixed in 5.0.42, 5.0.45
Bug#16382 (SELECT with IF and GROUP BY on VIEW can crash server): Fixed in 5.0.19
Bug#16387 (InnoDB crash when dropping a foreign key <table<_ibfk_0): Fixed in 5.0.19
Bug#16461 (connection_id() does not work properly inside trigger): Fixed in 5.0.21
Bug#16494 (Updates that set a column to NULL fail sometimes): Fixed in 5.0.25
Bug#16502 (mysqlcheck gets confused with views): Fixed in 5.0.23
Bug#16568 (Continue handler with simple CASE not working correctly): Fixed in 5.0.19
Bug#16603 (Row subquery gives different result when index is added): Fixed in 5.0.19
Bug#16676 (Database CHARSET not used for stored procedures): Fixed in 5.0.25
Bug#16681 (information_schema shows forbidden VIEW details): Fixed in 5.0.23
Bug#16777 (Can not create trigger nor view w/o definer if --skip-grant-tables specified): Fixed in 5.0.20
Bug#16792 (query with subselect, join, and group not returning proper values): Fixed in 5.0.26
Bug#16803 ("ln -s /dev/null .mysql_history" doesn't work!): Fixed in 5.0.23
Bug#16829 (Firing trigger crashes the server): Fixed in 5.0.19
Bug#16857 (Altering BINARY(x) column uses incorrect padding): Fixed in 5.0.19
Bug#16859 (mysql client improperly handles NULL-terminated strings): Fixed in 5.0.19
Bug#16896 (Stored function: unused AGGREGATE-clause in CREATE FUNCTION): Fixed in 5.0.19
Bug#16899 (Possible buffer overflow in handling of DEFINER-clause): Fixed in 5.0.24a
Bug#17001 (Table and server crash on ALTER TABLE): Fixed in 5.0.23
Bug#17015 (Routine name truncation not an error): Fixed in 5.0.20
Bug#17039 (Cursor with procedure crashes client): Fixed in 5.0.33, 5.0.30
Bug#17043 (Casting trimmed string to decimal loses precision): Fixed in 5.0.21
Bug#17048 (CREATE TABLE ... SELECT truncate values): Fixed in 5.0.23
Bug#17164 (LEFT JOIN with OR clause not optimized correctly): Fixed in 5.0.20
Bug#17201 (mysqldump sometimes creates database twice): Fixed in 5.0.23
Bug#17203 ("sql_no_cache sql_cache" in views created from prepared statement): Fixed in 5.0.23
Bug#17254 (Error for DEFINER security on VIEW provides too much info): Fixed in 5.0.33, 5.0.32
Bug#17294 (INSERT DELAYED puting an \n before data): Fixed in 5.0.25
Bug#17313 (N'xxx' and _utf8'xxx' are not equivalent): Fixed in 5.0.25
Bug#17332 (changing key_buffer_size on a running server can crash under load): Fixed in 5.0.87
Bug#17353 (mysqld_safe sets core file size only when run as root): Fixed in 5.0.23
Bug#17366 (crash on left join on union with literal, 5.0.18): Fixed in 5.0.20
Bug#17374 (select ... like 'A%' operator fails to find value on columuns with key): Fixed in 5.0.20
Bug#17377 (Federated Engine returns wrong Data, always the rows with the highest ID): Fixed in 5.0.20
Bug#17411 (cannot have path longer than 128 characters): Fixed in 5.0.19
Bug#17476 (Stored procedure not returning data when it is called first time per connection): Fixed in 5.0.19
Bug#17526 (errors thrown by VIEW using TRIM("x" FROM some_field)): Fixed in 5.0.24
Bug#17726 (mysqld hangs at update of view with check option): Fixed in 5.0.20
Bug#17733 (Flushing logs causes daily server crash): Fixed in 5.0.33, 5.0.32
Bug#18023 (IM: instance can be started several times; monitor interval must be < 2sec): Fixed in 5.0.23
Bug#18077 (InnoDB uses full explicit table locks in stored FUNCTION): Fixed in 5.0.33, 5.0.30
Bug#18113 (SELECT * FROM information_schema.xxx crashes server): Fixed in 5.0.20
Bug#18153 (REPAIR/OPTIMIZE/ALTER on transactional tables corrupt triggers): Fixed in 5.0.20
Bug#18177 (any access to INFORMATION_SCHEMA.ROUTINES crashes): Fixed in 5.0.23
Bug#18184 (SELECT ... FOR UPDATE does not work..): Fixed in 5.0.25
Bug#18195 (MySQL on Windows not built with YaSSL correctly): Fixed in 5.0.20
Bug#18224 (VIEW on information_schema crashes the server): Fixed in 5.0.20
Bug#18235 (assertion/crash when windows mysqld is ended with ctrl-c): Fixed in 5.0.23
Bug#18237 (COUNT(*) on view returns different results than base table): Fixed in 5.0.21
Bug#18265 (mysql client: No longer right-justifies numeric columns): Fixed in 5.0.21
Bug#18267 (pthreads library in single-threaded libraries causes dlopen() to fail on HP/UX): Fixed in 5.0.26
Bug#18275 (invalid file descriptor causes crash on windows): Fixed in 5.0.23
Bug#18279 (While using complex queries with bracketed joins mysqld-nt service terminate): Fixed in 5.0.20
Bug#18281 (group_concat changes charset to binary): Fixed in 5.0.20
Bug#18282 (INFORMATION_SCHEMA.TABLES provides inconsistent info about invalid views): Fixed in 5.0.23
Bug#18293 (Values in stored procedure written to binlog unescaped): Fixed in 5.0.20
Bug#18306 (MySQL crashes and restarts using subquery): Fixed in 5.0.20
Bug#18321 (Can't store Euro Sign with latin1_german1_ci and latin1_general_ci): Fixed in 5.0.21
Bug#18361 (Triggers on mysql.user table cause server crash): Fixed in 5.0.25
Bug#18444 (Fully qualified stored function names don't work correctly in SELECT statements): Fixed in 5.0.25
Bug#18462 (mysqldump does not dump view structures correctly): Fixed in 5.0.23
Bug#18516 (mysql_upgrade missing in binary packages): Fixed in 5.0.23
Bug#18587 (Function that accepts and returns TEXT garbles data if longer than 766 chars): Fixed in 5.0.23
Bug#18618 (Joining tables with DATE BETWEEN in WHERE clause gives unexpected results): Fixed in 5.0.21
Bug#18691 (Converting number to UNICODE string returns invalid result.): Fixed in 5.0.21
Bug#18739 (select having field=max(field) causes problems): Fixed in 5.0.23
Bug#18761 (constant expression as UDF parameters not passed in as constant): Fixed in 5.0.33, 5.0.32
Bug#18764 (Delete conditions causing inconsistencies in Federated tables): Fixed in 5.0.25
Bug#18767 (Single resultset UNION doesn't sort correctly): Fixed in 5.0.21
Bug#18787 (Server crashed when calling a stored procedure containing a misnamed function): Fixed in 5.0.21
Bug#18810 (MySQL starts before ypbind with SuSE RPMs): Fixed in 5.0.23
Bug#18874 (Setting myisam_repair_threads < 1, index cardinality always 1): Fixed in 5.0.25
Bug#18908 (ERROR 1406 (22001): Data too long for column :: using utf8): Fixed in 5.0.33, 5.0.32
Bug#18940 (STRAIGHT_JOIN generates bad execution plan in 5.0): Fixed in 5.0.23
Bug#19079 (key_cache_block_size set to 4K corrupts indexes): Fixed in 5.0.21
Bug#19136 (Crashing log-bin and uninitialized user variables in a derived table): Fixed in 5.0.23
Bug#19192 (CHECK TABLE EXTENDED / REPAIR TABLE show no errors. ALTER TABLE crashes): Fixed in 5.0.23
Bug#19372 (Optimizer does not use index anymore when WHERE index NOT IN () is added): Fixed in 5.0.40, 5.0.41
Bug#19424 (InnoDB: Possibly a memory overrun of the buffer being freed (64-bit Visual C)): Fixed in 5.0.33, 5.0.28, 5.0.34
Bug#19604 (CHECK TABLE with concurrent INSERT can reset auto_increment): Fixed in 5.0.23
Bug#19960 (Inconsistent results when joining InnoDB tables using partial UTF8 indexes): Fixed in 5.0.26
Bug#20637 ("load data concurrent infile" locks the table): Fixed in 5.0.33, 5.0.30sp1, 5.0.32
Bug#21059 (Server crashes on join query with large dataset with NDB tables): Fixed in 5.0.25
Bug#21113 (Duplicate printout in SHOW INNODB STATUS): Fixed in 5.0.25
5.0.20
Bug#15530 (Cluster start up "show" shows all data nodes as master during start): Fixed in 5.0.21
Bug#15881 (expression = constant -< invalid results when they are of different types): Fixed in 5.0.37, 5.0.34
Bug#15921 (DROP TRIGGER - can't be drop trigger created in older version): Fixed in 5.0.20
Bug#16201 (Indexed query on a table with clause using 3+ indexes crashes InnoDB server): Fixed in 5.0.25
Bug#16211 (Stored function return type for strings is ignored): Fixed in 5.0.25
Bug#16539 (MySQL-shared-compat-4.1.15-0.i386.rpm requires glibc 2.3): Fixed in 5.0.21
Bug#17608 (String literals lost during INSERT query on FEDERATED table): Fixed in 5.0.25
Bug#18113 (SELECT * FROM information_schema.xxx crashes server): Fixed in 5.0.20
Bug#18153 (REPAIR/OPTIMIZE/ALTER on transactional tables corrupt triggers): Fixed in 5.0.20
Bug#18224 (VIEW on information_schema crashes the server): Fixed in 5.0.20
Bug#18243 (View returns two different results for identical expressions in a concat): Fixed in 5.0.25
Bug#18246 (compilation error with tcp_wrapper): Fixed in 5.0.26
Bug#18279 (While using complex queries with bracketed joins mysqld-nt service terminate): Fixed in 5.0.20
Bug#18306 (MySQL crashes and restarts using subquery): Fixed in 5.0.20
Bug#18344 (DROP DATABASE does not drop associated routines): Fixed in 5.0.21
Bug#18516 (mysql_upgrade missing in binary packages): Fixed in 5.0.23
Bug#18618 (Joining tables with DATE BETWEEN in WHERE clause gives unexpected results): Fixed in 5.0.21
Bug#18715 (replicate-wild-ignore-table prevents CREATE VIEW from replicating): Fixed in 5.0.21
Bug#18964 (return 0 instead of DBUG_RETURN(0) in sql_base.cc::open_table()): Fixed in 5.0.21
Bug#19021 (Server crashes while resolving index merge): Fixed in 5.0.21
Bug#19077 (Wrong results from VIEWS with BIGINTs and extrema functions): Fixed in 5.0.23
Bug#19089 (CREATE TABLE ... SELECT * FROM a view with an ENUM column and GROUP BY fails): Fixed in 5.0.23
Bug#19111 (TRIGGERs selecting from a VIEW on the firing base table fail): Fixed in 5.0.33, 5.0.30
Bug#19121 (Windows incompatible udf_example): Fixed in 5.0.26
Bug#19136 (Crashing log-bin and uninitialized user variables in a derived table): Fixed in 5.0.23
Bug#19190 (syntax error in mysql-test/mysql-test-run.sh script): Fixed in 5.0.21
Bug#19191 (Repeated crashes on OpenBSD for ssl test cases): Fixed in 5.0.23
Bug#19207 (Final parenthesis omitted for CREATE INDEX in Stored Procedure): Fixed in 5.0.25
Bug#19208 (Test 'rpl000017' hangs on Windows): Fixed in 5.0.23
Bug#19209 (Test 'rpl_openssl' hangs on Windows): Fixed in 5.0.36, 5.0.37
Bug#19399 (Stored Procedures 'Lost Connection' when dropping/creating tables): Fixed in 5.0.25
Bug#19419 (VIEW: View that the column name is different by master and slave is made): Fixed in 5.0.26
Bug#19834 (Using cursors when running in READ-COMMITTED can cause InnoDB to crash): Fixed in 5.0.25
Bug#19955 (unsigned bigint treated as signed by MOD): Fixed in 5.0.33, 5.0.32
Bug#19960 (Inconsistent results when joining InnoDB tables using partial UTF8 indexes): Fixed in 5.0.26
Bug#19967 (W32 case insensitive tablenames cannot be transferred to Linux): Fixed in 5.0.23
Bug#20152 (mysql_stmt_execute() overwrites parameter buffers): Fixed in 5.0.24
Bug#21468 (InnoDB crash during recovery with corrupted data pages: XA bug?): Fixed in 5.0.33, 5.0.30sp1, 5.0.32
Bug#22026 (Warning when using IF statement and large unsigned bigint): Fixed in 5.0.36, 5.0.37
Bug#25543 (Replication of wrong values if using rand() in stored procedure): Fixed in 5.0.40, 5.0.41
Bug#29136 (erred multi-delete on trans table does not rollback the statement): Fixed in 5.0.54
5.0.21
Bug#8153 (Stored procedure with subquery and continue handler, wrong result): Fixed in 5.0.25
Bug#11081 (Using a CONVERT_TZ function in a stored function or trigger fails): Fixed in 5.0.23
Bug#15522 (create ... select and with merge tables drops underlying table): Fixed in 5.0.42, 5.0.45
Bug#16504 (Some of the simplest SELECTs are 1000 times slower in v5 compared to v4): Fixed in 5.0.21
Bug#16621 (INSERTs in Stored Procedures causes data corruption in the Binary Log for 5.0.18): Fixed in 5.0.19
Bug#17332 (changing key_buffer_size on a running server can crash under load): Fixed in 5.0.87
Bug#17733 (Flushing logs causes daily server crash): Fixed in 5.0.33, 5.0.32
Bug#18091 (libmysqlclient.a relocation error): Fixed in 5.0.22
Bug#18165 (SQL optimizer ineficiencies with "BETWEEN" statements): Fixed in 5.0.25
Bug#18177 (any access to INFORMATION_SCHEMA.ROUTINES crashes): Fixed in 5.0.23
Bug#18492 (mysqld reports ER_ILLEGAL_REFERENCE in --ps-protocol): Fixed in 5.0.23
Bug#18630 (Arguments of suid routine calculated in wrong security context): Fixed in 5.0.25
Bug#18691 (Converting number to UNICODE string returns invalid result.): Fixed in 5.0.21
Bug#18739 (select having field=max(field) causes problems): Fixed in 5.0.23
Bug#18764 (Delete conditions causing inconsistencies in Federated tables): Fixed in 5.0.25
Bug#18908 (ERROR 1406 (22001): Data too long for column :: using utf8): Fixed in 5.0.33, 5.0.32
Bug#18914 (Calling certain SPs from triggers fail): Fixed in 5.0.41, 5.0.38
Bug#18925 (Dependant, subquery on information_schema.COLUMNS returns wrong result): Fixed in 5.0.25
Bug#18966 (Change in stop/shutdown behaviour): Fixed in 5.0.23
Bug#19022 (Memory bug when switching db during trigger execution): Fixed in 5.0.23
Bug#19188 (incorrect temporary table name of DROP query in replication): Fixed in 5.0.22
Bug#19194 (Right recursion in parser for CASE causes excessive stack usage, limitation): Fixed in 5.0.37, 5.0.34
Bug#19198 (mysqld failure during DBT2): Fixed in 5.0.33, 5.0.30
Bug#19204 (ARCHIVE data size increases when table is flushed): Fixed in 5.0.23
Bug#19236 (bad COLUMNS.CHARACTER_MAXIMUM_LENGHT and CHARACTER_OCTET_LENGTH): Fixed in 5.0.23
Bug#19318 (valgrind: memory leak in ndb_mgmd): Fixed in 5.0.23
Bug#19342 (IN works incorrectly for BIGINT UNSIGNED values): Fixed in 5.0.41, 5.0.38
Bug#19356 (Assert on undefined @uservar in prepared statement execute): Fixed in 5.0.33, 5.0.30
Bug#19368 (Failure in "flush_instances" causes assert in Thread_registry): Fixed in 5.0.33, 5.0.30
Bug#19370 (DateTime datatype in MySQL has two bugs in it): Fixed in 5.0.25
Bug#19371 (VARBINARY() have trailing zeros after upgrade from 4.1): Fixed in 5.0.33, 5.0.32
Bug#19391 (IM fails to start after two executions): Fixed in 5.0.23
Bug#19402 (SQL close to the size of the max_allowed_packet fails on the slave): Fixed in 5.0.33, 5.0.32
Bug#19407 (Test 'func_regexp' fails on Windows x64): Fixed in 5.0.23
Bug#19410 (Test 'kill' fails on Windows + SCO): Fixed in 5.0.36, 5.0.37
Bug#19424 (InnoDB: Possibly a memory overrun of the buffer being freed (64-bit Visual C)): Fixed in 5.0.33, 5.0.28, 5.0.34
Bug#19474 (readline bug: mysql: free(): invalid pointer): Fixed in 5.0.36, 5.0.37
Bug#19490 (View on a date column with calculated INTERVAL crashes the server): Fixed in 5.0.23
Bug#19537 (NDB API: NdbOperation::write_attr does not update 32-bit fields correctly): Fixed in 5.0.23
Bug#19573 (Views with complex expressions in first column gives errors when selected): Fixed in 5.0.23
Bug#19606 (ssl variables are not displayed in show variables): Fixed in 5.0.23
Bug#19618 ("select x from x where x not in(1,-1)" may crash the server): Fixed in 5.0.23
Bug#19634 (Re-execution of multi-delete which involve trigger/stored function crashes MySQL): Fixed in 5.0.23
Bug#19667 (group by a decimal expression yields wrong result): Fixed in 5.0.23
Bug#19714 (COALESCE() returns wrong datatype in VIEWs): Fixed in 5.0.25
Bug#19717 (DELETE Query Error on BLACKHOLE when using WHERE on column with UNIQUE INDEX): Fixed in 5.0.41, 5.0.38
Bug#19789 (VIEW with WITH CHECK OPTION allows invalid REPLACE): Fixed in 5.0.23
Bug#19799 (delimiter command not working correctly when sourcing a sql file): Fixed in 5.0.33, 5.0.32
Bug#19810 (Bundled YASSL in libmysqlclient conflicts with OpenSSL): Fixed in 5.0.25
Bug#19815 (CREATE/RENAME/DROP DATABASE can deadlock on a global read lock): Fixed in 5.0.23
Bug#19816 (Optimizer wrongly rewrites LEFT as INNER JOIN and produces wrong results): Fixed in 5.0.23
Bug#19817 (error when try to compile PHP5.1 with mysql 5.0.21 static libs): Fixed in 5.0.33, 5.0.32
Bug#19828 (Case sensitivity in hostname leads to inconsistent behavior): Fixed in 5.0.52
Bug#19834 (Using cursors when running in READ-COMMITTED can cause InnoDB to crash): Fixed in 5.0.25
Bug#19857 (When a user with CREATE ROUTINE priv creates a routine it results in NULL p/w): Fixed in 5.0.25
Bug#19873 (After an ndb_mgmd restart, ndb_mgm needs a command to be executed twice): Fixed in 5.0.33, 5.0.30
Bug#19904 (UDF: not initialized *is_null per row): Fixed in 5.0.25
Bug#19930 (Incorrect thread handling in ndb_mgmd could casue crash/incorrect behavior): Fixed in 5.0.23
Bug#19932 (mgmapi crash if disconnect in ndb_mgm_get_status): Fixed in 5.0.23
Bug#20016 (error in mgm protocal parser error message incorrect): Fixed in 5.0.23
Bug#20028 (Function with select return no data): Fixed in 5.0.33, 5.0.30
Bug#20045 (Qcache invalidate crashes when INSERT ... SELECT query uses a VIEW): Fixed in 5.0.33, 5.0.32
Bug#20078 (MySQL-bench-5.0.21 RPMs contain strange dependencies): Fixed in 5.0.23
Bug#20095 (Changing length of VARCHAR field with UTF8 collation does not truncate values): Fixed in 5.0.42, 5.0.45
Bug#20100 (mysql_upgrade passes socket parameter to mysqlcheck etc. incorrectly): Fixed in 5.0.33, 5.0.30
Bug#20141 (User-defined variables are not replicated properly for SF/Triggers in SBR mode): Fixed in 5.0.41, 5.0.38
Bug#20145 (perror segfault when call it with error nr): Fixed in 5.0.25
Bug#20252 (NDB API: NdbIndexScanOperation::readTuples ignores the batch parameter): Fixed in 5.0.25
Bug#20419 (ndbd --nowait-nodes=<id_of_running_node< fails with bad error message): Fixed in 5.0.25
Bug#20637 ("load data concurrent infile" locks the table): Fixed in 5.0.33, 5.0.30sp1, 5.0.32
Bug#20708 (ndb_cache_check_time doesn't get set from my.cnf file): Fixed in 5.0.25
Bug#20862 (truncated result with show variables like 'innodb_data_file_path'): Fixed in 5.0.33, 5.0.30
Bug#20910 (NOT NULL column reported as NULL in SHOW FIELDS or INFORMATION_SCHEMA): Fixed in 5.0.25
Bug#21007 (NATURAL JOIN (any JOIN (2 x NATURAL JOIN)) crashes the server): Fixed in 5.0.25
Bug#21103 (DATE column not compared as DATE): Fixed in 5.0.45, 5.0.44, 5.0.41
Bug#21132 (Slave fails to reconnect on update_slave_list): Fixed in 5.0.54
Bug#21459 (myisam_ftdump gives bad counts for common words): Fixed in 5.0.26
Bug#21462 (Stored procedures with no arguments require parenthesis): Fixed in 5.0.33, 5.0.30
Bug#21468 (InnoDB crash during recovery with corrupted data pages: XA bug?): Fixed in 5.0.33, 5.0.30sp1, 5.0.32
Bug#21493 (MySQL aborts on calling function with ROW IN subquery for multiple rows): Fixed in 5.0.26
Bug#23666 (strange Innodb_row_lock_time_% values in show status; also millisecs wrong): Fixed in 5.0.40, 5.0.41
Bug#24478 (DROP TRIGGER is not caught by replicate-*-table filters): Fixed in 5.0.41, 5.0.38
Bug#29420 (crash with show and purge binlogs): Fixed in 5.0.51, 5.0.46
5.0.22
Bug#11312 (DELIMITER is not written to the binary log that causes syntax error): Fixed in 5.0.19
Bug#16201 (Indexed query on a table with clause using 3+ indexes crashes InnoDB server): Fixed in 5.0.25
Bug#18462 (mysqldump does not dump view structures correctly): Fixed in 5.0.23
Bug#19372 (Optimizer does not use index anymore when WHERE index NOT IN () is added): Fixed in 5.0.40, 5.0.41
Bug#19399 (Stored Procedures 'Lost Connection' when dropping/creating tables): Fixed in 5.0.25
Bug#19564 (mysql displays NULL instead of space): Fixed in 5.0.23
Bug#19700 (subselect returning BIGINT always returned it as SIGNED): Fixed in 5.0.23
Bug#19705 (connector/j can't connect to 5.0.22 server using certificate): Fixed in 5.0.25
Bug#19714 (COALESCE() returns wrong datatype in VIEWs): Fixed in 5.0.25
Bug#19725 (Calls to SF in other database are not replicated correctly in some cases): Fixed in 5.0.36, 5.0.37
Bug#19736 (VIEW: column names not quoted properly when view is replicated): Fixed in 5.0.33, 5.0.30
Bug#19773 (Crash when using multi-table updates with federated tables): Fixed in 5.0.23
Bug#19834 (Using cursors when running in READ-COMMITTED can cause InnoDB to crash): Fixed in 5.0.25
Bug#19835 (Binary copy of corrupted tables crash the server when issuing a query): Fixed in 5.0.25
Bug#19955 (unsigned bigint treated as signed by MOD): Fixed in 5.0.33, 5.0.32
Bug#20045 (Qcache invalidate crashes when INSERT ... SELECT query uses a VIEW): Fixed in 5.0.33, 5.0.32
Bug#20119 (Undefined functions when linking with libmysqlclient with yaSSL + icc): Fixed in 5.0.23
Bug#20190 (Unixware 7.13 port and make test errors): Fixed in 5.0.25
Bug#20195 (INSERT DELAYED with auto_increment is assigned wrong values): Fixed in 5.0.23
Bug#20221 (Dumping of multiple databases containing view(s) yields maleformed dumps): Fixed in 5.0.24
Bug#20293 (group by cuts off value from time_format): Fixed in 5.0.41, 5.0.38
Bug#20327 (incorrect results with views, server-side prepared stmts, correlated subquery): Fixed in 5.0.33, 5.0.32
Bug#20395 (Cluster Datanodes Always Assigned To NodeGroup 0 During SINGLE USER MODE): Fixed in 5.0.33, 5.0.30
Bug#20396 (Bin Log does not get DELIMETER cmd - Recover StoredProc fails): Fixed in 5.0.36, 5.0.37
Bug#20411 ("GRANT ... REQUIRE ISSUER nnn AND SUBJECT mmm" fails to require both): Fixed in 5.0.25
Bug#20420 (optimizer reports wrong keys on left join with IN): Fixed in 5.0.41, 5.0.38
Bug#20430 (mysqld.exe windows service stuck in "SERVICE_STOP_PENDING" status): Fixed in 5.0.74
Bug#20446 (NDB API: scans with updates by multiple processes/threads can skip some records): Fixed in 5.0.33, 5.0.30
Bug#20466 (SELECT with GROUP BY from view missing data when trigger defined on base table): Fixed in 5.0.25
Bug#20492 (Subsequent calls to stored procedure yield incorrect result if join is used): Fixed in 5.0.40, 5.0.41
Bug#20519 ("Subquery returns more that 1 row" error with "limit x, 1"): Fixed in 5.0.25
Bug#20542 (fill_help_tables.sql Does Not Work With ANSI_QUOTES): Fixed in 5.0.23
Bug#20551 (fill_help_tables.sql Lacks Character Encoding Declaration): Fixed in 5.0.23
Bug#20569 (Garbage in DECIMAL results from some mathematical functions): Fixed in 5.0.25
Bug#20596 (Views don't replicate with LOAD DATA FROM MASTER): Fixed in 5.0.26
Bug#20697 (slave fails to rollback replicated transaction hang over innodb_lock_wait_timeou): Fixed in 5.0.33, 5.0.32
Bug#20789 (Merge Subtable Rename Causes Crash): Fixed in 5.0.26
Bug#20792 (Incorrect results from aggregate subquery): Fixed in 5.0.25
Bug#20825 (rollup puts non-equal values together): Fixed in 5.0.33, 5.0.30
Bug#20860 (error 2341: 'Internal program error (failed ndbrequire)): Fixed in 5.0.25
Bug#20868 (Client connection is broken on SQL query error): Fixed in 5.0.25
Bug#20927 (sec_to_time treats big unsigned as signed): Fixed in 5.0.33, 5.0.30
Bug#20987 (str_to_date doesn't accept user variable for specification): Fixed in 5.0.25
Bug#21042 (mysql client segfaults on importing a mysqldump export): Fixed in 5.0.25
Bug#21051 (RESET QUERY CACHE very slow when query_cache_type=0): Fixed in 5.0.25
Bug#21054 (myisam_stats_method ignored in my.cnf and cmdline): Fixed in 5.0.25
Bug#21056 (ndb pushdown equal/setValue error on datetime): Fixed in 5.0.33, 5.0.30
Bug#21081 (SELECT inside stored procedure returns wrong results): Fixed in 5.0.33, 5.0.30
Bug#21158 (mysql_config doesn't include -lmygcc): Fixed in 5.0.58
Bug#21166 (Prepared statement causes signal 11 on second execution): Fixed in 5.0.25
Bug#21180 (Subselect with index for both WHERE and ORDER BY produces empty result): Fixed in 5.0.26
Bug#21206 (memory corruption when too many cursors are opened at once): Fixed in 5.0.24
Bug#21208 (time_zone_name.`Name` column is not wide enough): Fixed in 5.0.26
Bug#21215 (mysqldump creating incomplete backups without warning): Fixed in 5.0.25
Bug#21263 (mysql client XML output does not distinguish between NULL and string 'NULL'): Fixed in 5.0.26
Bug#21265 (mysqld_error.h file not installed when building only client libraries): Fixed in 5.0.37, 5.0.34
Bug#21282 (NOT IN, more than 1000 returns incorrect reults with INDEX): Fixed in 5.0.25
Bug#21302 (Result not properly sorted when using an ORDER BY on a second table in a join): Fixed in 5.0.25
Bug#21310 (Trees in SQL causing a "crashed" table with MyISAM storage engine): Fixed in 5.0.36, 5.0.37
Bug#21354 ((COUNT(*) = 1) not working in SELECT inside prepared statement): Fixed in 5.0.33, 5.0.30
Bug#21392 (multi-table delete with alias table name fails with 1003: Incorrect table name): Fixed in 5.0.26
Bug#21424 (mysqldump failing to export/import views - note update below, when using definer): Fixed in 5.0.26
Bug#21476 (stack overflow crashes server; error-message stack reservation too small): Fixed in 5.0.45, 5.0.44
Bug#21535 (3r: The failure handling of node 1 ends up in an infinite loop.): Fixed in 5.0.33, 5.0.30
Bug#21556 (federated table - charset=euckr): Fixed in 5.0.37, 5.0.34
Bug#22271 (data casting may affect data stored in the next column(s?)): Fixed in 5.0.26
Bug#22342 (No results returned for query using max and group by): Fixed in 5.0.33, 5.0.30
Bug#23097 (mysql can't insert korean on mysql prompt.): Fixed in 5.0.60
Bug#23313 (AUTO_INCREMENT=# not reported back for InnoDB tables): Fixed in 5.0.42, 5.0.45
Bug#23451 (GROUP_CONCAT truncates a multibyte utf8 character): Fixed in 5.0.33, 5.0.32
Bug#24653 (server crash, with multirow subquery in order by): Fixed in 5.0.36, 5.0.37
Bug#24856 (distinct with constant item and rollup =< missing summary lines): Fixed in 5.0.42, 5.0.45
Bug#26207 (inserts don't work with shortened index): Fixed in 5.0.40, 5.0.41
Bug#26794 (Adding an index with a prefix on a SPATIAL type breaks ALTER TABLE): Fixed in 5.0.40, 5.0.41
Bug#28980 (ROUND(x,y) returns different results for same literal and int column values as y): Fixed in 5.0.45, 5.0.44
Bug#30666 (Incorrect order when using range conditions on 2 tables or more): Fixed in 5.0.52
Bug#35848 (UUID() returns UUIDs with the wrong time): Fixed in 5.0.68
Bug#37226 (Explicit call of my_thread_init() on Windows for every new thread): Fixed in 5.0.70
5.0.23
Bug#11312 (DELIMITER is not written to the binary log that causes syntax error): Fixed in 5.0.19
Bug#17526 (errors thrown by VIEW using TRIM("x" FROM some_field)): Fixed in 5.0.24
Bug#18243 (View returns two different results for identical expressions in a concat): Fixed in 5.0.25
Bug#18539 (uncompress(d) is null: impossible?): Fixed in 5.0.25
Bug#19474 (readline bug: mysql: free(): invalid pointer): Fixed in 5.0.36, 5.0.37
Bug#19702 (Using myisampack/myisamchk on a FULLTEXT indexed table results in table corrupt): Fixed in 5.0.26
Bug#19834 (Using cursors when running in READ-COMMITTED can cause InnoDB to crash): Fixed in 5.0.25
Bug#20076 (Crash if grouping a ucs2 column): Fixed in 5.0.25
Bug#20095 (Changing length of VARCHAR field with UTF8 collation does not truncate values): Fixed in 5.0.42, 5.0.45
Bug#20100 (mysql_upgrade passes socket parameter to mysqlcheck etc. incorrectly): Fixed in 5.0.33, 5.0.30
Bug#20103 (Escaping with backslash does not work): Fixed in 5.0.25
Bug#20191 (getTableName gives wrong or inconsistent result when using VIEWs): Fixed in 5.0.33, 5.0.32
Bug#20221 (Dumping of multiple databases containing view(s) yields maleformed dumps): Fixed in 5.0.24
Bug#20333 (valgrind: mgmd event reporting dep on uninit value): Fixed in 5.0.23
Bug#20396 (Bin Log does not get DELIMETER cmd - Recover StoredProc fails): Fixed in 5.0.36, 5.0.37
Bug#20420 (optimizer reports wrong keys on left join with IN): Fixed in 5.0.41, 5.0.38
Bug#20438 (CREATE statements for views, stored routines and triggers can be not replicable): Fixed in 5.0.25
Bug#20536 (md5() with GROUP BY and UCS2 return different results on myisam/innodb): Fixed in 5.0.25
Bug#20569 (Garbage in DECIMAL results from some mathematical functions): Fixed in 5.0.25
Bug#20570 (CURRENT_USER() in a VIEW with SQL SECURITY DEFINER returns invoker name): Fixed in 5.0.24
Bug#20579 (memory bug (valgrind): Syscall param write(buf) points to uninitialised byte): Fixed in 5.0.23
Bug#20589 (Missing some table level privileges after upgrade): Fixed in 5.0.33, 5.0.32
Bug#20616 (drop_temp_table test fails on Windows platform): Fixed in 5.0.23
Bug#20664 (Unprivileged SHOW CREATE FUNCTION crashes 'mysql' command line client): Fixed in 5.0.24
Bug#20670 (UPDATE using key and invoking trigger that modifies this key does not stop): Fixed in 5.0.33, 5.0.30
Bug#20691 (DATETIME col (NOT NULL, NO DEFAULT) may insert garbage when specifying DEFAULT): Fixed in 5.0.33, 5.0.36, 5.0.37
Bug#20713 (Functions will not not continue for SQLSTATE VALUE '42S02'): Fixed in 5.0.41, 5.0.38
Bug#20728 (REPLACE does not work correctly for NDB table with PK and unique index): Fixed in 5.0.25
Bug#20769 (Dangling pointer error in test case ctype_recoding): Fixed in 5.0.23
Bug#20778 (strange characters in warning message 1366 when called in SP): Fixed in 5.0.26
Bug#20783 (Valgrind uninitialised warning in test case ctype_uca): Fixed in 5.0.23
Bug#20803 (ICC 9.1.039 produces bad code compiling "mysql_client_test.c"): Fixed in 5.0.51, 5.0.50
Bug#20903 (Crash when using CREATE TABLE .. SELECT and triggers): Fixed in 5.0.42, 5.0.45
Bug#20919 (temp tables closing fails when binlog is off): Fixed in 5.0.24a
Bug#20989 (View '(null).(null)' references invalid table(s)... on SQL SECURITY INVOKER): Fixed in 5.0.24
Bug#21002 (Derived table not selecting from a "real" table fails in JOINs ): Fixed in 5.0.24
Bug#21014 (Segmentation fault of mysqldump on view): Fixed in 5.0.24
Bug#25309 (SSL connections without CA certificate broken since MySQL 5.0.23): Fixed in 5.0.40, 5.0.41
5.0.24
Bug#16494 (Updates that set a column to NULL fail sometimes): Fixed in 5.0.25
Bug#17485 (Instance Manager: mysql client crashes when connecting to the IM): Fixed in 5.0.25
Bug#18267 (pthreads library in single-threaded libraries causes dlopen() to fail on HP/UX): Fixed in 5.0.26
Bug#19575 (MySQL-shared-5.0.21-0.glibc23 causes segfault in SSL_library_init): Fixed in 5.0.23
Bug#19834 (Using cursors when running in READ-COMMITTED can cause InnoDB to crash): Fixed in 5.0.25
Bug#20825 (rollup puts non-equal values together): Fixed in 5.0.33, 5.0.30
Bug#20850 (Assert during slave shutdown in many rpl_* tests): Fixed in 5.0.24
Bug#20910 (NOT NULL column reported as NULL in SHOW FIELDS or INFORMATION_SCHEMA): Fixed in 5.0.25
Bug#20968 (incorrect DBUG_ENTER string in mysqld.cc network_init(void) function): Fixed in 5.0.25
Bug#21052 (Fix error message when aborting backup): Fixed in 5.0.48
Bug#21269 (DEFINER-clause is allowed for UDF-functions): Fixed in 5.0.25
Bug#21396 (Wrong error number generated for a missing table: 1017 vs 1146): Fixed in 5.0.25
Bug#21468 (InnoDB crash during recovery with corrupted data pages: XA bug?): Fixed in 5.0.33, 5.0.30sp1, 5.0.32
Bug#21475 (incorrect result and warning with datetime and subquery): Fixed in 5.0.25
Bug#21483 (Server abort or deadlock on INSERT DELAYED with another implicit insert): Fixed in 5.0.42, 5.0.45
Bug#21505 (Create view - illegal mix of collation for operation 'UNION'): Fixed in 5.0.33, 5.0.32
Bug#21507 (I can't create a unique hash index in NDB): Fixed in 5.0.33, 5.0.32
Bug#21543 (5.0.24 breaks ABI compatibility for python bindings: InterfaceError on connect): Fixed in 5.0.24a
Bug#21582 (mysql server crashes in close_temporary_tables): Fixed in 5.0.24a
Bug#21587 (FLUSH TABLES causes server crash when used with HANDLER statements): Fixed in 5.0.32
Bug#21617 (crash when selecting from merge table with inconsistent indexes): Fixed in 5.0.33, 5.0.30
Bug#21618 (NULL shown as empty string in client): Fixed in 5.0.26
Bug#21620 (ALTER TABLE affects other columns): Fixed in 5.0.26
Bug#21635 (MYSQL_FIELD struct's member strings seem to misbehave for expression cols): Fixed in 5.0.33, 5.0.32
Bug#21638 (InnoDB: possible segfault in page_copy_rec_list_end_no_locks ): Fixed in 5.0.26
Bug#21646 (ALGORITHM=MERGE CREATE VIEW FAILS FOR INNER JOINS WITH SUBQUERIES USING AGG FUNC): Fixed in 5.0.26
Bug#21675 (engine=archive 2GB file limit, when reached mysqld restarts on any query ): Fixed in 5.0.26
Bug#21698 (ASCII() function results are not respected in a WHERE clause): Fixed in 5.0.26
Bug#21727 (sort_buffer_size has an extremely negative impact on a query as it increases): Fixed in 5.0.33, 5.0.30sp1, 5.0.32
Bug#21765 (Illegal Instruction crash on pre-pentium when using YASSL): Fixed in 5.0.33, 5.0.42, 5.0.45, 5.0.32
Bug#21772 (can not name a column 'upgrade' when create a table in version 5.0.24): Fixed in 5.0.26
Bug#21774 (Column count doesn't match value count at row x): Fixed in 5.0.25
Bug#21781 (Replication slave io thread hangs): Fixed in 5.0.36, 5.0.37
Bug#21790 (geometry field with spatial index returns ERROR 1105 (HY000): Unknown error): Fixed in 5.0.33, 5.0.32
Bug#21798 (memory leak during query execution with subquery in column list using a function): Fixed in 5.0.33, 5.0.30
Bug#21809 (Error 1356 while selecting from view with grouping though underlying select OK. ): Fixed in 5.0.33, 5.0.32
Bug#21825 (Incorrect message error deleting records in a table with a trigger for inserting): Fixed in 5.0.41, 5.0.38
Bug#21856 (Prepared Statments: crash if bad create): Fixed in 5.0.33, 5.0.30
Bug#21904 (parser problem when using IN with a double "(())"): Fixed in 5.0.41, 5.0.38
Bug#21930 (libmysqlclient defines BN_bin2bn which belongs to OpenSSL! Breaks other apps!): Fixed in 5.0.25
Bug#22015 (nested group_concat in subselect results in server crash): Fixed in 5.0.26
Bug#22029 (str_to_date returning NULL, while date_format works using identical format.): Fixed in 5.0.33, 5.0.32
Bug#22043 (MySQL don't add "USE <DATABASE<" before "DROP PROCEDURE IF EXISTS"): Fixed in 5.0.33, 5.0.36, 5.0.37
Bug#22053 (REPAIR table can crash server for some really damaged MyISAM tables): Fixed in 5.0.37, 5.0.34
Bug#22227 (ulong not defined for client library): Fixed in 5.0.26
Bug#22238 (32bitversion of MySQL Server in 'Linux (AMD64 / Intel EM64T) Intel C/C++' binary): Fixed in 5.0.25
Bug#22251 (Shared compatibilty library RPMs are incomplete (5.0.24a)): Fixed in 5.0.24a
Bug#22326 (Build problems on hurd-i386: conflicting declaration of socklen_t): Fixed in 5.0.26
Bug#22331 (EXPLAIN EXTENDED does not always return full query information): Fixed in 5.0.41, 5.0.38
Bug#22344 (InnoDB keys act strange on datetime vs timestamp comparison): Fixed in 5.0.36, 5.0.37
Bug#22364 (Inconsistent "matched rows" when executing UPDATE): Fixed in 5.0.42, 5.0.45
Bug#22367 (Optimizer uses ref join type instead of eq_ref for simple join on strings): Fixed in 5.0.33, 5.0.30
Bug#22372 (Disable spatial key, load data, enable spatial key, crashes table): Fixed in 5.0.33, 5.0.32
Bug#22413 (EXPLAIN SELECT FROM view with ORDER BY yield server crash): Fixed in 5.0.33, 5.0.32
Bug#22457 (Column alias in ORDER BY works, but not if in an expression): Fixed in 5.0.33, 5.0.32
Bug#22555 (STDDEV yields positive result for groups with only one row): Fixed in 5.0.36, 5.0.37
Bug#22580 (DROP TABLE in nested stored procedure causes strange dependency error): Fixed in 5.0.41, 5.0.38
Bug#22584 (last_insert_id not updated after inserting a record through a updatable view): Fixed in 5.0.33, 5.0.30
Bug#22877 (replication character sets get out of sync using replicate-wild-ignore-table): Fixed in 5.0.33, 5.0.32
Bug#23037 (Bug in field "Default" of query "SHOW COLUMNS FROM table"): Fixed in 5.0.33, 5.0.30
Bug#23240 (--init-file statements with NOW() reports '1970-01-01 11:00:00' as the date time): Fixed in 5.0.41, 5.0.38
Bug#23299 (Some queries against INFORMATION_SCHEMA with subqueries fail): Fixed in 5.0.36, 5.0.37
Bug#23404 (ROW_FORMAT=FIXED option is lost is an index is added to the table): Fixed in 5.0.37, 5.0.34
Bug#23417 ((ONLY_FULL_GROUP_BY) function of aggregate is still an aggregate [S3/S2]): Fixed in 5.0.36, 5.0.37
Bug#23491 (MySQLDump prefix function call in a view by database name): Fixed in 5.0.40, 5.0.41
Bug#23616 (Week() changed behaviour between 5.0.22 and 5.0.24): Fixed in 5.0.41, 5.0.38
Bug#23656 (NOW() and CURDATE() doesn't convert correctly when used by CAST() function): Fixed in 5.0.42, 5.0.45
Bug#23775 (Replicated event larger that max_allowed_packet infinitely re-transmits): Fixed in 5.0.40, 5.0.41
Bug#26503 (Illegal SQL exception handler code causes the server to crash): Fixed in 5.0.40
Bug#26622 (MASTER_POS_WAIT does not work as documented): Fixed in 5.0.60
Bug#26909 ( Specified key was too long; max key length is 255 bytes when create table): Fixed in 5.0.48, 5.0.51
Bug#27300 (create view with geometry functions lost columns types ): Fixed in 5.0.40, 5.0.41
Bug#28492 (subselect returns LONG in <5.0.24a and LONGLONG in <=5.0.24a): Fixed in 5.0.45, 5.0.44
Bug#28808 (log_queries_not_using_indexes variable dynamic change is ignored): Fixed in 5.0.51, 5.0.46
Bug#29152 (INSERT DELAYED does not use concurrent_insert on slave): Fixed in 5.0.48, 5.0.51
Bug#29644 (alter table hangs if records locked in share mode by long running transaction): Fixed in 5.0.48, 5.0.51
Bug#30385 (Server crash when deleting with order by and limit): Fixed in 5.0.51, 5.0.50
5.0.25
Bug#11151 (LOAD DATA INFILE commits transaction in 5.0): Fixed in 5.0.26
Bug#20596 (Views don't replicate with LOAD DATA FROM MASTER): Fixed in 5.0.26
Bug#20637 ("load data concurrent infile" locks the table): Fixed in 5.0.33, 5.0.30sp1, 5.0.32
Bug#20867 (InnoDB Bug - create temporary table+crash =< mysqld needs to clean up): Fixed in 5.0.37, 5.0.34
Bug#21014 (Segmentation fault of mysqldump on view): Fixed in 5.0.24
Bug#21056 (ndb pushdown equal/setValue error on datetime): Fixed in 5.0.33, 5.0.30
Bug#21096 (locking issue ; temporary table conflicts.): Fixed in 5.0.33, 5.0.30
Bug#21216 (Simultaneous DROP TABLE and SHOW OPEN TABLES causes server to crash): Fixed in 5.0.25
Bug#21224 (mysql_upgrade uses possibly insecure temporary files): Fixed in 5.0.25
Bug#21302 (Result not properly sorted when using an ORDER BY on a second table in a join): Fixed in 5.0.25
Bug#21310 (Trees in SQL causing a "crashed" table with MyISAM storage engine): Fixed in 5.0.36, 5.0.37
Bug#21354 ((COUNT(*) = 1) not working in SELECT inside prepared statement): Fixed in 5.0.33, 5.0.30
Bug#21477 (Segfault in valgrind when running "func_in" test): Fixed in 5.0.25
Bug#21540 (Subqueries with no from and aggregate functions return wrong results): Fixed in 5.0.26
Bug#21567 (mysqld doesn't react to Ctrl-C when run under GDB even with the --gdb option): Fixed in 5.0.60
Bug#21646 (ALGORITHM=MERGE CREATE VIEW FAILS FOR INNER JOINS WITH SUBQUERIES USING AGG FUNC): Fixed in 5.0.26
Bug#21671 (memory leak for mgmapi event listeners): Fixed in 5.0.25
Bug#21726 (Incorrect result with multiple invocations of LAST_INSERT_ID): Fixed in 5.0.26
Bug#21790 (geometry field with spatial index returns ERROR 1105 (HY000): Unknown error): Fixed in 5.0.33, 5.0.32
Bug#21809 (Error 1356 while selecting from view with grouping though underlying select OK. ): Fixed in 5.0.33, 5.0.32
Bug#21813 (An attacker has the opportunity to bypass query logging, part2): Fixed in 5.0.25
Bug#21825 (Incorrect message error deleting records in a table with a trigger for inserting): Fixed in 5.0.41, 5.0.38
Bug#22053 (REPAIR table can crash server for some really damaged MyISAM tables): Fixed in 5.0.37, 5.0.34
Bug#22082 (Slave hangs(holds mutex) on "disk full"): Fixed in 5.0.79
Bug#22268 (MySQL/InnoDB crashes in high concurrency test): Fixed in 5.0.26
Bug#22427 (create table if not exists + stored function results in inconsistent behavior): Fixed in 5.0.48, 5.0.51
Bug#22723 (Host field blank when server started with skip-grant): Fixed in 5.0.33, 5.0.30
Bug#23578 (Corruption prevents Optimize table from working properly with a spatial index): Fixed in 5.0.37, 5.0.34
5.0.26
Bug#21468 (InnoDB crash during recovery with corrupted data pages: XA bug?): Fixed in 5.0.33, 5.0.30sp1, 5.0.32
Bug#21635 (MYSQL_FIELD struct's member strings seem to misbehave for expression cols): Fixed in 5.0.33, 5.0.32
Bug#22326 (Build problems on hurd-i386: conflicting declaration of socklen_t): Fixed in 5.0.26
Bug#22331 (EXPLAIN EXTENDED does not always return full query information): Fixed in 5.0.41, 5.0.38
Bug#22344 (InnoDB keys act strange on datetime vs timestamp comparison): Fixed in 5.0.36, 5.0.37
Bug#22457 (Column alias in ORDER BY works, but not if in an expression): Fixed in 5.0.33, 5.0.32
Bug#22555 (STDDEV yields positive result for groups with only one row): Fixed in 5.0.36, 5.0.37
Bug#22580 (DROP TABLE in nested stored procedure causes strange dependency error): Fixed in 5.0.41, 5.0.38
Bug#22584 (last_insert_id not updated after inserting a record through a updatable view): Fixed in 5.0.33, 5.0.30
Bug#22753 (No equality propagation into BETWEEN predicates): Fixed in 5.0.33, 5.0.30
Bug#22763 (Disrepancy between SHOW CREATE VIEW and I_S.VIEWS): Fixed in 5.0.72
Bug#23170 (if Insert ignore ...select fails on violation unique key, @@identity is << 0): Fixed in 5.0.36, 5.0.37
Bug#23184 (SELECT causes server crash): Fixed in 5.0.33, 5.0.30sp1, 5.0.32
Bug#23203 (ndb_mgmd seg fauts on all dump 1000): Fixed in 5.0.33, 5.0.30
Bug#23233 (NO_AUTO_VALUE_ON_ZERO and INSERT...ON DUPLICATE cause insertion failure): Fixed in 5.0.40, 5.0.41
Bug#23260 (String converted to floating-point when comparing to DECIMAL type): Fixed in 5.0.33, 5.0.30sp1, 5.0.32
Bug#23293 (readline detection broken on NetBSD): Fixed in 5.0.36, 5.0.37
Bug#23299 (Some queries against INFORMATION_SCHEMA with subqueries fail): Fixed in 5.0.36, 5.0.37
Bug#23312 (server hangs 'closing tables' with insert delayed,flush tables,alter table): Fixed in 5.0.37, 5.0.34
Bug#23379 (wrong time value in SHOW PROCESSLIST): Fixed in 5.0.33, 5.0.30
Bug#23383 (mysql_affected_rows() returns different values than mysql_stmt_affected_rows()): Fixed in 5.0.33, 5.0.32
Bug#23427 (incompatible ABI change in 5.0.26?): Fixed in 5.0.33, 5.0.27, 5.0.28
Bug#23443 (user-defined variables can consume too much memory in the server): Fixed in 5.0.37, 5.0.34
Bug#23526 (show table status reports incorrect values for MyISAM tables): Fixed in 5.0.36, 5.0.37
Bug#23527 (set global query_cache_size can crash the server under high load): Fixed in 5.0.41, 5.0.38
Bug#23556 (TRUNCATE TABLE still maps to DELETE): Fixed in 5.0.36, 5.0.37
Bug#23588 (SHOW COLUMNS on a temporary table causes locking issues): Fixed in 5.0.60
Bug#23616 (Week() changed behaviour between 5.0.22 and 5.0.24): Fixed in 5.0.41, 5.0.38
Bug#23651 (Server crash calling trigger): Fixed in 5.0.33, 5.0.32
Bug#23669 (mysql.proc not created in default install): Fixed in 5.0.41, 5.0.38
Bug#23800 (Correlated sub query returning incorrect results when operated upon): Fixed in 5.0.41, 5.0.38
Bug#24010 (INSERT INTO ... SELECT fails on unique constraint with data it doesn't select): Fixed in 5.0.41, 5.0.38
Bug#24035 (performance of update query difference between 5.0.22-log AND 5.0.27-log): Fixed in 5.0.36, 5.0.37
Bug#24117 (server crash on a FETCH with a cursor on a table which is not in the table cache): Fixed in 5.0.36, 5.0.37
Bug#24345 (simple query on a view crashes...): Fixed in 5.0.37, 5.0.34
Bug#25126 (Reference to non-existant column in UPDATE ... ORDER BY ... crashes server): Fixed in 5.0.41, 5.0.38
Bug#25407 (MySQL prefers UNIQUE index for IS NULL conditions over more selective conditions): Fixed in 5.0.36, 5.0.37
Bug#25645 (Assertion failure in file srv0srv.c; adaptive hash hang in a complex query): Fixed in 5.0.48, 5.0.51
Bug#25729 (boolean full text search is confused by NULLs produced by LEFT JOIN): Fixed in 5.0.40, 5.0.41
Bug#25946 (Namespace not include for xsi usage within --xml output with null/nil values): Fixed in 5.0.40, 5.0.41
Bug#27216 (coalesce returns varbinary for dates): Fixed in 5.0.52
Bug#27513 (mysql 5.0.x + NULL pointer DoS): Fixed in 5.0.40, 5.0.41
Bug#27884 (mysql --html does not quote HTML special characters in output): Fixed in 5.0.89
5.0.27
Bug#15126 (character_set_database is not replicated (LOAD DATA INFILE need it)): Fixed in 5.0.41, 5.0.38
Bug#19829 (make test Failed in mysql_client_test *with --with-charset=utf8*): Fixed in 5.0.79
Bug#21074 (Large query_cache freezes mysql server sporadically under heavy load): Fixed in 5.0.51, 5.0.50
Bug#23068 (key_cache_block_size is not set or displayes correctly): Fixed in 5.0.51, 5.0.46
Bug#23175 (MYISAM crash/repair failed during repair): Fixed in 5.0.33, 5.0.30
Bug#23293 (readline detection broken on NetBSD): Fixed in 5.0.36, 5.0.37
Bug#23299 (Some queries against INFORMATION_SCHEMA with subqueries fail): Fixed in 5.0.36, 5.0.37
Bug#23312 (server hangs 'closing tables' with insert delayed,flush tables,alter table): Fixed in 5.0.37, 5.0.34
Bug#23313 (AUTO_INCREMENT=# not reported back for InnoDB tables): Fixed in 5.0.42, 5.0.45
Bug#23411 (The "%" (MOD) operator is not documented; MOD-ing zero returns strange result): Fixed in 5.0.33, 5.0.30
Bug#23417 ((ONLY_FULL_GROUP_BY) function of aggregate is still an aggregate [S3/S2]): Fixed in 5.0.36, 5.0.37
Bug#23451 (GROUP_CONCAT truncates a multibyte utf8 character): Fixed in 5.0.33, 5.0.32
Bug#24035 (performance of update query difference between 5.0.22-log AND 5.0.27-log): Fixed in 5.0.36, 5.0.37
Bug#24040 (Create View don't succed with "all privileges" on a database): Fixed in 5.0.42, 5.0.45
Bug#24052 (On Win64, MEMORY tables are limited to 4 GB): Fixed in 5.0.33, 5.0.30sp1, 5.0.32
Bug#24121 (Incorrect test for SSL_VERIFY_SERVER_CERT): Fixed in 5.0.40, 5.0.41
Bug#24148 (regression tests hang with SSL enabled): Fixed in 5.0.36, 5.0.37
Bug#24191 (ndb_size.tmpl missing in distributions): Fixed in 5.0.36, 5.0.37
Bug#24261 (crash when WHERE contains NOT IN ('<negative value<') for unsigned column type): Fixed in 5.0.36, 5.0.37
Bug#24294 (mysql.server: source: not found ): Fixed in 5.0.33, 5.0.32
Bug#24299 (Identifiers in foreign keys cannot contain U+0160, U+0360, ..., U+FF60 ): Fixed in 5.0.33, 5.0.32
Bug#24342 (Incorrect results with query over MERGE table): Fixed in 5.0.42, 5.0.45
Bug#24432 (INSERT... ON DUPLICATE KEY UPDATE skips auto_increment values): Fixed in 5.0.41, 5.0.38
Bug#24491 (using alias from source table in insert..on duplicate key): Fixed in 5.0.36, 5.0.37
Bug#24562 (ALTER TABLE ... ORDER BY ... with complex expression asserts): Fixed in 5.0.36, 5.0.37
Bug#24563 (MBROverlaps does not seem to function propertly.): Fixed in 5.0.40, 5.0.41
Bug#24611 (mysqld crashes when connecting from remote host, and compiled from source): Fixed in 5.0.45, 5.0.44
Bug#24630 (Subselect query crashes mysqld): Fixed in 5.0.36, 5.0.37
Bug#24778 (Innodb: No result when using ORDER BY): Fixed in 5.0.42, 5.0.45
Bug#24780 (Make /etc/mysql directory configurable): Fixed in 5.0.36, 5.0.37
Bug#24854 (Mixing Searched Case with Simple Case inside Stored Procedure crashes Mysqld): Fixed in 5.0.37, 5.0.34
Bug#24912 (problems with bigint in abs() ceiling() ruond() truncate() mod()): Fixed in 5.0.42, 5.0.45
Bug#24918 (drop table and lock / inconsistent between perm and temp tables): Fixed in 5.0.48, 5.0.51
Bug#24985 (UTF8 ENUM primary key on MEMORY using BTREE causes incorrect duplicate entries): Fixed in 5.0.40, 5.0.41
Bug#24989 ('Explicit or implicit commit' error/server crash with concurrent transactions): Fixed in 5.0.48, 5.0.51
Bug#25008 (Mac OS X's StartupItem does not work): Fixed in 5.0.51b, 5.0.60
Bug#25048 (ERROR 126 : Incorrect key file for table '.XXXX.MYI'; try to repair it): Fixed in 5.0.37, 5.0.34
Bug#25106 (A USING clause in combination with a VIEW results in column aliases ignored): Fixed in 5.0.37, 5.0.34
Bug#25189 (mysqld: coding.cpp:243: void TaoCrypt::Base64Decoder::Decode(): Assertion `endLi): Fixed in 5.0.36, 5.0.37
Bug#25376 (wrong order with order by using sum and division): Fixed in 5.0.41, 5.0.38
Bug#25427 (Use of ambiguous column in an expression in ORDER BY clause crashes server): Fixed in 5.0.37, 5.0.34
Bug#25551 (inconsistent behaviour in grouping NULL, depending on index type): Fixed in 5.0.36, 5.0.37
Bug#25575 (ERROR 1052 (Column in from clause is ambiguous) with sub-join): Fixed in 5.0.36, 5.0.37
Bug#25580 (The Parsing difers from a direct select to a create view): Fixed in 5.0.36, 5.0.37
Bug#25679 (Denial-of-Service against entire server if FEDERATED engine is compiled): Fixed in 5.0.48, 5.0.51
Bug#25761 (Table is partially created when disk is full, causing database corruption): Fixed in 5.0.42, 5.0.45
Bug#25830 (SHOW TABLE STATUS behaves differently depending on table name): Fixed in 5.0.79
Bug#25853 (key_cache_block_size=4MB causes table corruptions + duplicate key errors): Fixed in 5.0.51, 5.0.46
Bug#25971 (Optimizer ignores key on left join in version 5.0.27, 4.1.10 but not in 4.0.27): Fixed in 5.0.41, 5.0.38
Bug#25993 (mysqldump crashes with merge table and -c option): Fixed in 5.0.40, 5.0.41
Bug#26124 (BETWEEN in views returns incorrect results): Fixed in 5.0.36, 5.0.37
Bug#26199 (Replication of stored procedures with BIT parameters fails): Fixed in 5.0.54
Bug#26209 (wrong result using COUNT(DISTINCT ?) querying a VIEW with GROUP BY and ORDER BY): Fixed in 5.0.36, 5.0.37
Bug#26294 (library name conflict between MySQL 4.x, 5.0 and Qt 3.3): Fixed in 5.0.62
Bug#26461 (Intrinsic data type bool (1 byte) redefined to BOOL (4 bytes)): Fixed in 5.0.60
Bug#26560 (VIEW with scalar correlated subquery returns wrong results): Fixed in 5.0.41, 5.0.38
Bug#26672 (Incorrect SEC_TO_TIME() casting in ORDER BY): Fixed in 5.0.40, 5.0.41
Bug#26738 (Quoted strings not concatenating when in subquery): Fixed in 5.0.40, 5.0.41
Bug#26767 (Solaris 10 tar package does not include shared libraries): Fixed in 5.0.41
Bug#26842 (master binary log contains invalid queries - replication fails): Fixed in 5.0.45, 5.0.44
Bug#26996 (Update of a Field in a Memory Table ends with wrong result): Fixed in 5.0.40, 5.0.41
Bug#27101 (mysqlhotcopy --record_log_pos retrieves wrong slave parameters): Fixed in 5.0.60
Bug#27427 (resolveip fails on hostnames with a leading digit): Fixed in 5.0.56
Bug#27984 (Long Decimal Maths produces truncated results): Fixed in 5.0.45, 5.0.44
Bug#28121 (INSERT or UPDATE into DOUBLE(200,0) field being truncated to 31 digits): Fixed in 5.0.45, 5.0.44
Bug#28248 (mysqldump results with MERGE ... UNION=() cannot be executed): Fixed in 5.0.60
Bug#28677 (SELECT on missing column gives extra error): Fixed in 5.0.51, 5.0.46
Bug#29095 (Insert into a select from a join b using(c) order by b.auto_id desc limit 1 fail): Fixed in 5.0.51, 5.0.46
5.0.28
Bug#10746 (InnoDB: Error: stored_select_lock_type is 0 inside ::start_stmt()!): Fixed in 5.0.30
Bug#24040 (Create View don't succed with "all privileges" on a database): Fixed in 5.0.42, 5.0.45
Bug#24117 (server crash on a FETCH with a cursor on a table which is not in the table cache): Fixed in 5.0.36, 5.0.37
Bug#24156 (Loose index scan not used with CREATE TABLE ...SELECT and similar statements): Fixed in 5.0.33, 5.0.30sp1, 5.0.32
Bug#24158 (SET PASSWORD in binary log fails under ANSI_QUOTES): Fixed in 5.0.36, 5.0.37
Bug#24478 (DROP TRIGGER is not caught by replicate-*-table filters): Fixed in 5.0.41, 5.0.38
Bug#24484 (Aggregate function used in column list subquery gives erroneous error): Fixed in 5.0.40, 5.0.41
5.0.30
Bug#10218 (Command line recall rolls into Segmentation Fault(coredump)): Fixed in 5.0.44
Bug#14649 (MySQLInstanceConfig.exe fails when writing configuration file): Fixed in 5.0.51, 5.0.46
Bug#17047 (CHAR() and IN() can return NULL without signaling NULL result): Fixed in 5.0.33, 5.0.32
Bug#21033 (Error 0 in readAutoIncrementValue()): Fixed in 5.0.41, 5.0.38
Bug#24040 (Create View don't succed with "all privileges" on a database): Fixed in 5.0.42, 5.0.45
Bug#24156 (Loose index scan not used with CREATE TABLE ...SELECT and similar statements): Fixed in 5.0.33, 5.0.30sp1, 5.0.32
Bug#24289 (Status Variable "Questions" gets wrong values with Stored Routines): Fixed in 5.0.72
Bug#24345 (simple query on a view crashes...): Fixed in 5.0.37, 5.0.34
Bug#24401 (MySQL server crashes if you try to retrieve data from corrupted table): Fixed in 5.0.36, 5.0.37
Bug#24896 (mysql_upgrade core dumps on RHEL3 using 5.0.30 commerical binaries): Fixed in 5.0.33, 5.0.32
Bug#24988 (FLUSH PRIVILEGES causes brief unavailability): Fixed in 5.0.45, 5.0.44
Bug#24992 (Enabling Shared Memory support on Windows x64 causes client to fail): Fixed in 5.0.60
Bug#25058 (ignored return codes in memory allocation functions): Fixed in 5.0.82
Bug#25082 (default database change on trigger execution breaks replication): Fixed in 5.0.42, 5.0.45
Bug#25122 (insertability of views not consistent): Fixed in 5.0.41, 5.0.38
Bug#25123 (insert into view on dup key, allows cross table reference): Fixed in 5.0.36, 5.0.37
Bug#25172 (Server crash with GROUP and LIMIT): Fixed in 5.0.36, 5.0.37
Bug#25275 (SINGLE USER MODE prevents ALTER on non-ndb tables for other mysqld nodes): Fixed in 5.0.40, 5.0.41
Bug#25341 (/etc/init.d/mysql stop may timeout too quickly): Fixed in 5.0.36, 5.0.37
Bug#25373 (rollup grand total not have NULL for group by field basd on stored function): Fixed in 5.0.41, 5.0.38
Bug#25482 (GRANT statements are not replicated if you use "replicate-ignore-table"): Fixed in 5.0.40, 5.0.41
Bug#25522 (Update with IN syntax Cluster table + Trigger leads to mysqld segfault): Fixed in 5.0.36, 5.0.37
Bug#25543 (Replication of wrong values if using rand() in stored procedure): Fixed in 5.0.40, 5.0.41
Bug#25657 (mysql-test-run.pl kill itself under ActiveState perl): Fixed in 5.0.51, 5.0.46
Bug#26242 (UPDATE with subquery and triggers failing with cluster tables): Fixed in 5.0.40, 5.0.41
Bug#26711 (Binary content 0x00 sometimes becomes 0x5C 0x00 after dump/load): Fixed in 5.0.51, 5.0.46
Bug#28138 (indexing column prefixes produces corruption in InnoDB): Fixed in 5.0.48, 5.0.51
Bug#28149 (overflow in some "SHOW STATUS"-variables): Fixed in 5.0.45, 5.0.44
5.0.32
Bug#19829 (make test Failed in mysql_client_test *with --with-charset=utf8*): Fixed in 5.0.79
Bug#21476 (stack overflow crashes server; error-message stack reservation too small): Fixed in 5.0.45, 5.0.44
Bug#21765 (Illegal Instruction crash on pre-pentium when using YASSL): Fixed in 5.0.33, 5.0.42, 5.0.45, 5.0.32
Bug#23345 (Incorrect check when SELECT INTO + UNION, moreover invalid data): Fixed in 5.0.40, 5.0.41
Bug#23491 (MySQLDump prefix function call in a view by database name): Fixed in 5.0.40, 5.0.41
Bug#24358 (Table access crashes server): Fixed in 5.0.36, 5.0.37
Bug#24508 (Inconsistent results of CREATE TABLE ... SELECT when temporary table exists): Fixed in 5.0.42, 5.0.45
Bug#24778 (Innodb: No result when using ORDER BY): Fixed in 5.0.42, 5.0.45
Bug#24854 (Mixing Searched Case with Simple Case inside Stored Procedure crashes Mysqld): Fixed in 5.0.37, 5.0.34
Bug#24907 (unpredictable (display) precision, if input precision increases): Fixed in 5.0.54
Bug#24912 (problems with bigint in abs() ceiling() ruond() truncate() mod()): Fixed in 5.0.42, 5.0.45
Bug#24947 (REPEAT function returns NULL when passed a field as the count parameter): Fixed in 5.0.33, 5.0.32
Bug#24989 ('Explicit or implicit commit' error/server crash with concurrent transactions): Fixed in 5.0.48, 5.0.51
Bug#25027 (Assertion abort on PS for a query with single-row subquery and IS NULL predicate): Fixed in 5.0.37, 5.0.34
Bug#25044 (ALTER TABLE ... ENABLE KEYS acquires global 'opening tables' lock. ): Fixed in 5.0.36, 5.0.37
Bug#25167 (Dupl. usage of user-variables in trigger/function is not replicated correctly): Fixed in 5.0.41, 5.0.38
Bug#25382 (Passing NULL to an UDF called from stored procedures crashes server): Fixed in 5.0.36, 5.0.37
Bug#25452 (mysql_upgrade access denied.): Fixed in 5.0.42, 5.0.45
Bug#25482 (GRANT statements are not replicated if you use "replicate-ignore-table"): Fixed in 5.0.40, 5.0.41
Bug#25596 (InnoDB Alter Table Failures): Fixed in 5.0.36, 5.0.37
Bug#25602 (Error with /*!HIGH_PRIORITY SQL_CACHE SQL_BIG_RESULT*/ combined with DISTINCT): Fixed in 5.0.51, 5.0.46
Bug#25643 (SEC_TO_TIME function problem): Fixed in 5.0.36, 5.0.37
Bug#25807 (LOAD DATA INFILE does not work with Pipes): Fixed in 5.0.36, 5.0.37
Bug#25815 (Data truncated for column TEXT): Fixed in 5.0.41, 5.0.38
Bug#25897 (Some queries are no longer possible after a CREATE VIEW fails): Fixed in 5.0.41, 5.0.38
Bug#26038 (X() value of empty NOT NULL POINT is neither NULL nor NOT NULL): Fixed in 5.0.41, 5.0.38
Bug#26138 (REPAIR TABLE with option USE_FRM erases all records in ARCHIVE table): Fixed in 5.0.40, 5.0.41
Bug#27573 (MIN() on an indexed column which is always NULL sets _other_ results to NULL): Fixed in 5.0.45, 5.0.44
Bug#28652 (MySQL (with-debug=full) asserts when alter table operations): Fixed in 5.0.45, 5.0.44
Bug#29474 (21587 Regression Ever increasing open tables/fd when using HANDLER READ + DELETE): Fixed in 5.0.48, 5.0.51
Bug#29850 (session character encoding vs. group_concat): Fixed in 5.0.48, 5.0.51
Bug#31077 (mysqldump appending date to dump breaks dump semantics): Fixed in 5.0.52
Bug#32436 (KILL QUERY completely deadlocks mysqld): Fixed in 5.0.54
Bug#41571 (MySQL segfaults after innodb recovery): Fixed in 5.0.79
Bug#48291 (crash with row() operator,select into @var, and subquery returning multiple rows): Fixed in 5.0.87sp1, 5.0.88
5.0.33
Bug#22364 (Inconsistent "matched rows" when executing UPDATE): Fixed in 5.0.42, 5.0.45
Bug#25602 (Error with /*!HIGH_PRIORITY SQL_CACHE SQL_BIG_RESULT*/ combined with DISTINCT): Fixed in 5.0.51, 5.0.46
Bug#25798 (Incorrect results with the index merge union access algorithm and InnoDB tables): Fixed in 5.0.51, 5.0.46
Bug#25927 (Foreign key with ON DELETE SET NULL on NOT NULL can crash server): Fixed in 5.0.40, 5.0.41
Bug#25931 (VIEW ignores CHECK OPTION when updated against a JOIN clause): Fixed in 5.0.36, 5.0.37
Bug#25951 (ignore/use index does not work with fulltext): Fixed in 5.0.42, 5.0.45
Bug#26017 (LEFT JOIN does not select's case insensitive): Fixed in 5.0.36, 5.0.37
Bug#26186 (delete order by, sometimes accept unknown column): Fixed in 5.0.40, 5.0.41
Bug#26359 (Strings becoming truncated and converted to numbers under STRICT mode): Fixed in 5.0.40, 5.0.41
Bug#26639 (mysql_upgrade exits successfully even if external command failed): Fixed in 5.0.42, 5.0.45
Bug#26817 (mysqldump fails to backup database containing view with invalid definer): Fixed in 5.0.42, 5.0.45
Bug#27507 (Out of range value accepted for new NOT NULL datetime column in existing table): Fixed in 5.0.45, 5.0.44
Bug#28652 (MySQL (with-debug=full) asserts when alter table operations): Fixed in 5.0.45, 5.0.44
Bug#30444 (5.0 mysqldump silently allows wrong backup to be taken against a 4.0 database): Fixed in 5.0.52
5.0.34
Bug#22043 (MySQL don't add "USE <DATABASE<" before "DROP PROCEDURE IF EXISTS"): Fixed in 5.0.33, 5.0.36, 5.0.37
Bug#24010 (INSERT INTO ... SELECT fails on unique constraint with data it doesn't select): Fixed in 5.0.41, 5.0.38
Bug#24035 (performance of update query difference between 5.0.22-log AND 5.0.27-log): Fixed in 5.0.36, 5.0.37
Bug#25106 (A USING clause in combination with a VIEW results in column aliases ignored): Fixed in 5.0.37, 5.0.34
Bug#25122 (insertability of views not consistent): Fixed in 5.0.41, 5.0.38
Bug#25167 (Dupl. usage of user-variables in trigger/function is not replicated correctly): Fixed in 5.0.41, 5.0.38
Bug#25262 (Auto Increment lost when changing Engine type): Fixed in 5.0.42, 5.0.45
Bug#25289 (repair table causes "my_seek.c:56: my_seek: Assertion `fd != -1' failed"): Fixed in 5.0.40, 5.0.41
Bug#25341 (/etc/init.d/mysql stop may timeout too quickly): Fixed in 5.0.36, 5.0.37
Bug#25376 (wrong order with order by using sum and division): Fixed in 5.0.41, 5.0.38
Bug#25405 (mysql_upgrade fails due to case-sensitivity on dependant file- or path-names): Fixed in 5.0.42, 5.0.45
Bug#25407 (MySQL prefers UNIQUE index for IS NULL conditions over more selective conditions): Fixed in 5.0.36, 5.0.37
Bug#25427 (Use of ambiguous column in an expression in ORDER BY clause crashes server): Fixed in 5.0.37, 5.0.34
Bug#25487 (deleting ndb_cluster_connection object takes long time): Fixed in 5.0.36, 5.0.37
Bug#25507 (multi-row insert delayed + auto increment causes duplicate key entries on slave): Fixed in 5.0.41, 5.0.38
Bug#25521 (optimize table, delete, show table status leads to table losing it's .MYD): Fixed in 5.0.40, 5.0.41
Bug#25543 (Replication of wrong values if using rand() in stored procedure): Fixed in 5.0.40, 5.0.41
Bug#25551 (inconsistent behaviour in grouping NULL, depending on index type): Fixed in 5.0.36, 5.0.37
Bug#25575 (ERROR 1052 (Column in from clause is ambiguous) with sub-join): Fixed in 5.0.36, 5.0.37
Bug#25578 (CREATE TABLE LIKE does not require any privileges on source table. ): Fixed in 5.0.45, 5.0.44
Bug#25580 (The Parsing difers from a direct select to a create view): Fixed in 5.0.36, 5.0.37
Bug#25621 (Error in my_thread_global_end(): 1 threads didn't exit): Fixed in 5.0.45, 5.0.44
Bug#25668 (mysqld may core if cluster disconnected): Fixed in 5.0.36, 5.0.37
Bug#25673 (spatial index corruption, error 126 incorrect key file for table): Fixed in 5.0.41, 5.0.38
Bug#26093 (SELECT BENCHMARK() for SELECT statements does not produce valid results): Fixed in 5.0.41, 5.0.38
Bug#26162 (Trigger DML ignores low_priority_updates setting): Fixed in 5.0.45, 5.0.44
Bug#26186 (delete order by, sometimes accept unknown column): Fixed in 5.0.40, 5.0.41
Bug#27513 (mysql 5.0.x + NULL pointer DoS): Fixed in 5.0.40, 5.0.41
Bug#28808 (log_queries_not_using_indexes variable dynamic change is ignored): Fixed in 5.0.51, 5.0.46
5.0.36
Bug#17233 (LOAD DATA INFILE: failure causes mysqld dbug_assert, binlog not flushed): Fixed in 5.0.45, 5.0.44
Bug#22364 (Inconsistent "matched rows" when executing UPDATE): Fixed in 5.0.42, 5.0.45
Bug#23170 (if Insert ignore ...select fails on violation unique key, @@identity is << 0): Fixed in 5.0.36, 5.0.37
Bug#24989 ('Explicit or implicit commit' error/server crash with concurrent transactions): Fixed in 5.0.48, 5.0.51
Bug#25596 (InnoDB Alter Table Failures): Fixed in 5.0.36, 5.0.37
Bug#25621 (Error in my_thread_global_end(): 1 threads didn't exit): Fixed in 5.0.45, 5.0.44
Bug#25643 (SEC_TO_TIME function problem): Fixed in 5.0.36, 5.0.37
Bug#25673 (spatial index corruption, error 126 incorrect key file for table): Fixed in 5.0.41, 5.0.38
Bug#25679 (Denial-of-Service against entire server if FEDERATED engine is compiled): Fixed in 5.0.48, 5.0.51
Bug#25712 (insert delayed and check table run together report crashed tables): Fixed in 5.0.45, 5.0.44
Bug#25831 (Deficiencies in INSERT ... SELECT ... field name resolving.): Fixed in 5.0.41, 5.0.38
Bug#25897 (Some queries are no longer possible after a CREATE VIEW fails): Fixed in 5.0.41, 5.0.38
Bug#25966 (2MB per second endless memory consumption after LOCK TABLE ... WRITE): Fixed in 5.0.41, 5.0.38
Bug#25971 (Optimizer ignores key on left join in version 5.0.27, 4.1.10 but not in 4.0.27): Fixed in 5.0.41, 5.0.38
Bug#26000 (SHOW SLAVE STATUS can crash mysqld during shutdown process): Fixed in 5.0.54
Bug#26141 (mixing table types in trigger causes full table lock on innodb table): Fixed in 5.0.48, 5.0.51
Bug#26159 (select statement crashes mysql server): Fixed in 5.0.36, 5.0.37
Bug#26209 (wrong result using COUNT(DISTINCT ?) querying a VIEW with GROUP BY and ORDER BY): Fixed in 5.0.36, 5.0.37
Bug#26215 (mysql command line client should not strip comments from SQL statements): Fixed in 5.0.52
Bug#26238 (inserted delayed always inserts 0 for BIT columns): Fixed in 5.0.41, 5.0.38
Bug#26243 (mysql command line crash after control-c): Fixed in 5.0.60
Bug#26288 (savepoint not deleted, commit on empty transaction): Fixed in 5.0.82
Bug#26346 (stack + buffer overrun in mysqldump): Fixed in 5.0.40, 5.0.41
Bug#26359 (Strings becoming truncated and converted to numbers under STRICT mode): Fixed in 5.0.40, 5.0.41
Bug#26464 (insert delayed + update + merge = corruption): Fixed in 5.0.41, 5.0.38
Bug#26571 (Different format specifiers in errmsg.txt): Fixed in 5.0.41, 5.0.38
Bug#26609 (funcs1/2 files missing from install package): Fixed in 5.0.45, 5.0.44
Bug#26664 (test suite times out on OS X 64bit): Fixed in 5.0.45, 5.0.44
Bug#26813 (Super privilege required when altering a view): Fixed in 5.0.40, 5.0.41
Bug#26881 (Large MERGE tables report incorrect specification when no differences in tables): Fixed in 5.0.36sp1, 5.0.41, 5.0.38
Bug#26963 (Incorrect query results with CONST join compared to RANGE or ALL): Fixed in 5.0.40, 5.0.41
Bug#27006 (AFTER UPDATE triggers not fired with INSERT ... ON DUPLICATE KEY UPDATE): Fixed in 5.0.41
Bug#27173 ("Enabling keys got errno ..." does not say which table): Fixed in 5.0.45, 5.0.44
Bug#27381 (InnoDB exits when attempting to rename table to non-existant database): Fixed in 5.0.40, 5.0.41
Bug#27427 (resolveip fails on hostnames with a leading digit): Fixed in 5.0.56
Bug#27573 (MIN() on an indexed column which is always NULL sets _other_ results to NULL): Fixed in 5.0.45, 5.0.44
Bug#27653 (Temp table can't be created if lower_case_table_names=1 and tmpdir has uppercase): Fixed in 5.0.42, 5.0.45
Bug#28574 (repair table causes queries to fail with various corruption errors: 126,134,145): Fixed in 5.0.51, 5.0.46
5.0.37
Bug#21611 (Slave can't connect when master-ssl-cipher specified): Fixed in 5.0.42, 5.0.45
Bug#25602 (Error with /*!HIGH_PRIORITY SQL_CACHE SQL_BIG_RESULT*/ combined with DISTINCT): Fixed in 5.0.51, 5.0.46
Bug#26793 (mysqld crashes when doing specific query on information_schema): Fixed in 5.0.51, 5.0.50
Bug#26815 (Unexpected built-in function behavior: group_concat(distinct substring_index()) ): Fixed in 5.0.40, 5.0.41
Bug#26938 (SHOW PROFILE: hangs if @@profiling not set to 1): Fixed in 5.0.45
Bug#27033 (LAST_INSERT_ID returns 0 on using INSERT... ON DUPLICATE KEY UPDATE ...): Fixed in 5.0.40, 5.0.41
Bug#27060 (SQL Profile utility may not be reporting right duration for each step): Fixed in 5.0.45
Bug#27069 (set with identical elements are created): Fixed in 5.0.40, 5.0.41
Bug#27154 (Server crash on statement using 3-dimensional row constructor): Fixed in 5.0.40, 5.0.41
Bug#27164 (Crash when mixing InnoDB and MyISAM Geospatial tables): Fixed in 5.0.40, 5.0.41
Bug#27293 (mysqldump crashes when dumping procedure defined by different user): Fixed in 5.0.42, 5.0.45
Bug#27300 (create view with geometry functions lost columns types ): Fixed in 5.0.40, 5.0.41
Bug#27322 (failure to allocate transaction_prealloc_size causes crash): Fixed in 5.0.42, 5.0.45
Bug#27433 (Parser error for MySQL 5.0.37 with Bison 1.75 for sql_yacc.yy): Fixed in 5.0.51
Bug#27437 (NDB Data node crashes during mysqldump inserts): Fixed in 5.0.42, 5.0.45
Bug#27440 (read_only allows create and drop database): Fixed in 5.0.56
Bug#27499 (DROP TABLE race with SHOW TABLE STATUS): Fixed in 5.0.42, 5.0.45
Bug#27501 (5.0 significantly more sys ("kernel") time than 4.1 due to getrusage() calls): Fixed in 5.0.41
Bug#27530 (Incorrect calculation CRC32 value in GROUP BY requests): Fixed in 5.0.42, 5.0.45
Bug#27532 (Incorrect results when grouping with similar IN and NOT IN conditions): Fixed in 5.0.40, 5.0.41
Bug#27573 (MIN() on an indexed column which is always NULL sets _other_ results to NULL): Fixed in 5.0.45, 5.0.44
Bug#27580 (SPACE() function collation bug?): Fixed in 5.0.60
Bug#27659 (SELECT DISTINCT returns incorrect result set when field is repeated): Fixed in 5.0.40, 5.0.41
Bug#27692 (anonymous accounts not created): Fixed in 5.0.51, 5.0.52
Bug#27786 (Inconsistent Operation Performing UNION On View With ORDER BY): Fixed in 5.0.42, 5.0.45
Bug#27807 (Server crash when executing subquery with EXPLAIN): Fixed in 5.0.42, 5.0.45
Bug#27874 (sql-mode: only full group by mode not working ): Fixed in 5.0.42, 5.0.45
Bug#27884 (mysql --html does not quote HTML special characters in output): Fixed in 5.0.89
Bug#27921 (View ignores precision for CAST()): Fixed in 5.0.42, 5.0.45
Bug#27932 (Comparing return value of LOCATE() to NULL fails): Fixed in 5.0.51, 5.0.46
Bug#27990 (MYSQL_FIELD struct's member strings Bug 21635 not fixed for all cases): Fixed in 5.0.52
Bug#28000 (MySQL hangs when using INSERT IGNORE ... ON DUPLICATE KEY): Fixed in 5.0.42, 5.0.45
Bug#28261 (Datetime comparison with user var yields incorrect results): Fixed in 5.0.45, 5.0.44
Bug#28266 (IS_UPDATABLE field on VIEWS table in I_S database is wrong): Fixed in 5.0.45, 5.0.44
Bug#28293 (mysqlbinlog: corrupt SQL in hex dump mode [PATCH INCLUDED]): Fixed in 5.0.51, 5.0.46
Bug#28375 (mysql crash with subselect and null values): Fixed in 5.0.42, 5.0.45
Bug#28522 (Buffer overrun in mysqldump when using --hex-blob): Fixed in 5.0.45, 5.0.44
Bug#28571 (LEFT JOIN with a const false condition produces no rows instead of 1 NULL row): Fixed in 5.0.45, 5.0.44
Bug#28921 (Queries contaning UDF functions are cached): Fixed in 5.0.51, 5.0.46
Bug#29053 (SQL_CACHE in UNION causes non-deterministic functions to be cached): Fixed in 5.0.51, 5.0.46
Bug#29247 (Double free in libmysqlclient_r when mysqld restarted): Fixed in 5.0.51, 5.0.46
Bug#29306 (Truncated data in MS Access with decimal (3,1) columns in a VIEW): Fixed in 5.0.48, 5.0.51
Bug#36819 (ut_usectime does not handle errors from gettimeofday): Fixed in 5.0.76
Bug#38694 (Race condition in replication thread shutdown): Fixed in 5.0.82
Bug#40953 (SELECT query throws "ERROR 1062 (23000): Duplicate entry..." error): Fixed in 5.0.76
Bug#42803 (Field_bit does not have unsigned_flag field, can lead to bad memory access): Fixed in 5.0.88
5.0.38
Bug#25511 (Federated: INSERT failures): Fixed in 5.0.51, 5.0.46
Bug#26342 (auto_increment_increment AND auto_increment_offset REALLY REALLY anger NDB clust): Fixed in 5.0.51, 5.0.46
Bug#26624 (high mem usage (crash) in range optimizer (depends on order of fields in where)): Fixed in 5.0.40, 5.0.41
Bug#26625 (crash in range optimizer (out of mem) Bug#26624): Fixed in 5.0.40, 5.0.41
Bug#26642 (create index corrupts table definition in .frm): Fixed in 5.0.51, 5.0.46
Bug#26661 (SELECT with UNION kills the daemon): Fixed in 5.0.41, 5.0.38
Bug#26794 (Adding an index with a prefix on a SPATIAL type breaks ALTER TABLE): Fixed in 5.0.40, 5.0.41
Bug#26815 (Unexpected built-in function behavior: group_concat(distinct substring_index()) ): Fixed in 5.0.40, 5.0.41
Bug#26817 (mysqldump fails to backup database containing view with invalid definer): Fixed in 5.0.42, 5.0.45
Bug#26830 (subquery, group by .. with rollup crashes server): Fixed in 5.0.41, 5.0.38
Bug#26842 (master binary log contains invalid queries - replication fails): Fixed in 5.0.45, 5.0.44
Bug#26996 (Update of a Field in a Memory Table ends with wrong result): Fixed in 5.0.40, 5.0.41
Bug#27018 (Partial blob write inside blob clobbers data after the write): Fixed in 5.0.40, 5.0.41
Bug#27022 (Install fails with Duplicate entry '%-test-' for key 'PRIMARY'): Fixed in 5.0.40, 5.0.41
Bug#27029 (alter table ... enable keys crashes mysqld on large table): Fixed in 5.0.51, 5.0.46
Bug#27119 (server crash with integer division by zero during filesort on huge result): Fixed in 5.0.45, 5.0.44
Bug#27229 (crash/incorrect result in subquery with aggregate(outer_column) (debug server)): Fixed in 5.0.40, 5.0.41
Bug#27354 (stored function in where condition was always treated as const): Fixed in 5.0.42, 5.0.45
Bug#27362 (SELECT id FROM tablename WHERE id IN(4564, (SELECT IF(1=0,1,1/0)) ) crash): Fixed in 5.0.40, 5.0.41
Bug#27417 (thd-<no_trans_update.stmt lost value inside of SF-exec-stack): Fixed in 5.0.48, 5.0.51
Bug#27563 (killing noticed in SF() stack but the error gets missed in action and wrong rslt): Fixed in 5.0.45, 5.0.44
Bug#27571 (asynchronousity in setting mysql_`query`::error and Query_log_event::error_code): Fixed in 5.0.54
Bug#27590 (Problem comparing DATEs with DATETIMEs): Fixed in 5.0.42, 5.0.45
Bug#27640 (backup id not displayed in the output of "ndb_mgm start backup wait completed"): Fixed in 5.0.51, 5.0.46
Bug#27650 (ON DUPLICATE KEY UPDATE fails when setting UNIQUE values with multi row inserts): Fixed in 5.0.42, 5.0.45
Bug#27669 (mysqldump: Got error: 2026: SSL connection error when trying to connect): Fixed in 5.0.42, 5.0.45
Bug#27670 (LOAD DATA INFILE processing does not respect TIMESTAMP default value): Fixed in 5.0.42, 5.0.45
Bug#27692 (anonymous accounts not created): Fixed in 5.0.51, 5.0.52
Bug#27741 (udf test fails on AIX < 5.3): Fixed in 5.0.45, 5.0.44
Bug#27758 (NDB tables with index names containing spaces not restored correctly): Fixed in 5.0.40, 5.0.41
Bug#27827 (Multi-table VIEW treats CHECK OPTION inconsistently on UPDATE): Fixed in 5.0.45, 5.0.44
Bug#27878 (Use of view overrides column update privileges on underlying table): Fixed in 5.0.42, 5.0.45
Bug#27954 (INSERT ... ON DUPLICATE KEY UPDATE fails with large multi-insert): Fixed in 5.0.42, 5.0.45
Bug#28138 (indexing column prefixes produces corruption in InnoDB): Fixed in 5.0.48, 5.0.51
Bug#28244 (CREATE VIEW breaks replication when view exists): Fixed in 5.0.45, 5.0.44
Bug#28323 (Server crashed in xid cache operations): Fixed in 5.0.72
Bug#29661 (EXPLAIN for an ENUM column incorrectly shows 'Impossible WHERE noticed'): Fixed in 5.0.48, 5.0.51
Bug#29734 (thread_id=0 in binary log which leads to temporary table conflicts): Fixed in 5.0.48, 5.0.51
Bug#31167 (Introduction of @@hostname breaks replication in a ring): Fixed in 5.0.52
Bug#31177 (Server variables can't be set to their current values): Fixed in 5.0.54
Bug#31479 (Bad lock interaction if CREATE TABLE LIKE is killed): Fixed in 5.0.54
Bug#32848 (Data type conversion bug in union subselects in MySQL 5.0.38): Fixed in 5.0.56
Bug#36488 (regexp returns false matches, concatenating with previous rows): Fixed in 5.0.64
5.0.40
Bug#12676 (RHEL4: MySQL RPMs unusable when SELinux is enabled): Fixed in 5.0.36, 5.0.37
Bug#18322 (Explicit link to libmtmalloc breaks dlopen() applications like DBD::mysql): Fixed in 5.0.45, 5.0.44
Bug#21281 (Pending write lock is incorrectly removed when its statement being KILLed): Fixed in 5.0.48, 5.0.51
Bug#22855 (Optimizer doesn't rewrite NOT IN subselects to a correlated subquery): Fixed in 5.0.45, 5.0.44
Bug#25853 (key_cache_block_size=4MB causes table corruptions + duplicate key errors): Fixed in 5.0.51, 5.0.46
Bug#26294 (library name conflict between MySQL 4.x, 5.0 and Qt 3.3): Fixed in 5.0.62
Bug#27101 (mysqlhotcopy --record_log_pos retrieves wrong slave parameters): Fixed in 5.0.60
Bug#27333 (subquery grouped for aggregate of outer query / no aggregate of subquery): Fixed in 5.0.51, 5.0.46
Bug#27337 (Privileges are not properly restored): Fixed in 5.0.42, 5.0.45
Bug#27348 (aggregate in subquery executed, even if position in qualifying query is invalid): Fixed in 5.0.40, 5.0.41
Bug#27352 (outer aggregate in nested subquery, looking at some code): Fixed in 5.0.48, 5.0.51
Bug#27363 (nested aggregates in outer, subquery / sum(select count(outer))): Fixed in 5.0.42, 5.0.45
Bug#27484 (server crash with nested rows()): Fixed in 5.0.40, 5.0.41
Bug#27490 (Function to log to NT event log could allocate memory): Fixed in 5.0.40, 5.0.41
Bug#27507 (Out of range value accepted for new NOT NULL datetime column in existing table): Fixed in 5.0.45, 5.0.44
Bug#27513 (mysql 5.0.x + NULL pointer DoS): Fixed in 5.0.40, 5.0.41
Bug#27516 (divide by zero crash during optimize table): Fixed in 5.0.42, 5.0.45
Bug#27592 (stack overrun when storing datetime value using prepared statements): Fixed in 5.0.51, 5.0.46
Bug#27629 (Possible security flaw in INFORMATION_SCHEMA and SHOW statements): Fixed in 5.0.48, 5.0.51
Bug#27653 (Temp table can't be created if lower_case_table_names=1 and tmpdir has uppercase): Fixed in 5.0.42, 5.0.45
Bug#27694 (mysqlhotcopy & p5-DBD-mysql51-4.003): Fixed in 5.0.51, 5.0.50
Bug#27704 (row comparisation returns wrong results): Fixed in 5.0.42, 5.0.45
Bug#27716 (Partial modification by multi-table update not binlogged): Fixed in 5.0.51, 5.0.46
Bug#27775 (mediumint auto_increment with ndb_restore): Fixed in 5.0.40, 5.0.41
Bug#27786 (Inconsistent Operation Performing UNION On View With ORDER BY): Fixed in 5.0.42, 5.0.45
Bug#27792 (query cache returns wrong result, with certain system variables): Fixed in 5.0.42, 5.0.45
Bug#27811 (The variable 'join_tab' is being used without being defined): Fixed in 5.0.42, 5.0.45
Bug#27848 (rollup in union part causes error with order of union): Fixed in 5.0.56
Bug#27870 (join and subselect crash server): Fixed in 5.0.40, 5.0.41
Bug#27874 (sql-mode: only full group by mode not working ): Fixed in 5.0.42, 5.0.45
Bug#27957 (cast as decimal does not check overflow, also inconsistent with group, subselect): Fixed in 5.0.42, 5.0.45
Bug#28189 (optimizer issue on Innodb tables): Fixed in 5.0.42, 5.0.45
Bug#28337 (NOT EXISTS with GROUP BY behaves different in 5.0.40 (regression)): Fixed in 5.0.45, 5.0.44
Bug#28587 (SELECT is blocked by INSERT waiting on read lock, even with low_priority_updates): Fixed in 5.0.51, 5.0.50
Bug#28804 (Unknown error returned on a query using joins.): Fixed in 5.0.51, 5.0.50
Bug#28808 (log_queries_not_using_indexes variable dynamic change is ignored): Fixed in 5.0.51, 5.0.46
Bug#28898 (mysql_fetch_field gives empty table name by a view): Fixed in 5.0.51, 5.0.46
Bug#29154 (LOCK TABLES is not atomic when <1 InnoDB tables are locked): Fixed in 5.0.51, 5.0.46
Bug#30453 (String not cast to int correctly): Fixed in 5.0.54
Bug#41868 (crash or memory overrun with concat + upper, date_format functions): Fixed in 5.0.79
5.0.41
Bug#19829 (make test Failed in mysql_client_test *with --with-charset=utf8*): Fixed in 5.0.79
Bug#21158 (mysql_config doesn't include -lmygcc): Fixed in 5.0.58
Bug#25008 (Mac OS X's StartupItem does not work): Fixed in 5.0.51b, 5.0.60
Bug#27861 (Can't compile a client application: unresolved external symbols): Fixed in 5.0.48, 5.0.51
Bug#28358 (libmysql.dll cannot be dynamically loaded on Windows): Fixed in 5.0.45, 5.0.44
Bug#28359 (Intermitted lost connection at 'reading authorization packet' errors): Fixed in 5.0.52
Bug#28401 (mysql_upgrade Failed with STRICT_ALL_TABLES, ANSI_QUOTES and NO_ZERO_DATE): Fixed in 5.0.45, 5.0.44
Bug#28494 (Assigning to variable in SELECT spoils result of GROUP BY): Fixed in 5.0.45, 5.0.44
Bug#28544 (Incorrect shared library install name ): Fixed in 5.0.48, 5.0.51
Bug#28555 (Upgrading MySQL Fails to shut down old server and kills socket file): Fixed in 5.0.58
Bug#28585 (mysql_install_db fails ): Fixed in 5.0.48, 5.0.51
Bug#28603 (Invalid log-bin default location): Fixed in 5.0.54
Bug#28604 (innodb_force_recovery restricts data dump): Fixed in 5.0.48
Bug#28605 (SHOW CREATE VIEW with views using stored_procedures no longer showing SP names.): Fixed in 5.0.45, 5.0.44
Bug#28701 (SELECTs from VIEWs completely ignore USE/FORCE KEY, allowing invalid statements): Fixed in 5.0.52
Bug#28702 (VIEWs defined with USE/FORCE KEY ignore that request): Fixed in 5.0.52
Bug#28763 (UNION involving GEOMETRY fields crashes server): Fixed in 5.0.45, 5.0.44
Bug#28854 (MySQL.prefPane does not start or stop mysql on osx 10.5): Fixed in 5.0.51b, 5.0.58
Bug#28860 (USE_TLS not defined for mysqlclient.lib): Fixed in 5.0.45, 5.0.44
Bug#28897 (UUID() returns non-unique values when query cache is enabled): Fixed in 5.0.45, 5.0.44
Bug#28904 (ON UPDATE CURRENT_TIMESTAMP does not work properly with ON DUPLICATE KEY): Fixed in 5.0.45, 5.0.44
Bug#29095 (Insert into a select from a join b using(c) order by b.auto_id desc limit 1 fail): Fixed in 5.0.51, 5.0.46
Bug#29247 (Double free in libmysqlclient_r when mysqld restarted): Fixed in 5.0.51, 5.0.46
Bug#29248 (MyISAMchk & MyISAMpack failing with * wildcard on Windows platform): Fixed in 5.0.82
Bug#29392 (MySQL 5.0.41 returning incorrect columns in query): Fixed in 5.0.51, 5.0.46
Bug#29408 (Cannot find view in columns table if the selection contains a function): Fixed in 5.0.51, 5.0.50
Bug#29560 (InnoDB <= 5.0.30 hangs on adaptive hash rw-lock 'waiting for an X-lock'): Fixed in 5.0.50sp1, 5.0.54
Bug#29617 (Community "Linux (x86, glibc-2.2, "standard" is static)" binaries are dynamic): Fixed in 5.0.45
Bug#29801 (Federated engine crashes local server if remote server sends malicious response): Fixed in 5.0.50sp1, 5.0.52, 5.0.51a
Bug#29816 (Syntactically wrong query fails with misleading error message): Fixed in 5.0.52
Bug#29972 (The mysqlhotcopy script fails to copy tables or databases): Fixed in 5.0.52
Bug#30234 (Unexpected behavior using DELETE with AS and USING): Fixed in 5.0.51, 5.0.54, 5.0.50
Bug#32400 (Complex SELECT query returns correct result only on some occasions): Fixed in 5.0.54
5.0.42
Bug#15787 (MySQL crashes when archive table exceeds 2GB): Fixed in 5.0.51, 5.0.46
Bug#20815 (Re: Errno 12 on Windows after 197 connections): Fixed in 5.0.48, 5.0.51
Bug#28138 (indexing column prefixes produces corruption in InnoDB): Fixed in 5.0.48, 5.0.51
Bug#28149 (overflow in some "SHOW STATUS"-variables): Fixed in 5.0.45, 5.0.44
Bug#28181 (Access denied to 'information_schema when select into out file (regression) ): Fixed in 5.0.42, 5.0.45
Bug#28188 ('not exists' optimization for outer joins does not work anymore): Fixed in 5.0.42, 5.0.45
Bug#28208 (Comparison of curdate() or now() with string sometimes fails): Fixed in 5.0.45, 5.0.44
Bug#28248 (mysqldump results with MERGE ... UNION=() cannot be executed): Fixed in 5.0.60
Bug#28249 (Query Cache returns wrong result with concurrent insert / certain lock): Fixed in 5.0.48, 5.0.51
Bug#28272 (server crash during EXPLAIN SELECT ..): Fixed in 5.0.45, 5.0.44
Bug#28375 (mysql crash with subselect and null values): Fixed in 5.0.42, 5.0.45
Bug#28476 (force index on a disabled myisam index gives error 124): Fixed in 5.0.45, 5.0.44
Bug#28478 (Improper key_cache_block_size corrupts MyISAM tables): Fixed in 5.0.51, 5.0.46
Bug#28522 (Buffer overrun in mysqldump when using --hex-blob): Fixed in 5.0.45, 5.0.44
Bug#28553 (mysqld crash in "purge master log before(select time from information_schema)"): Fixed in 5.0.45, 5.0.44
Bug#28625 (decimal column used instead of bigint, for max-negative-bigint): Fixed in 5.0.51, 5.0.46
Bug#28728 (server crash with EXPLAIN EXTENDED .. and subqueries): Fixed in 5.0.45, 5.0.44
Bug#28774 (mysql_upgrade creates tempfiles in root-dir (C:\) and doesn't clean them up ): Fixed in 5.0.52
Bug#28778 (Wrong results from datetime column comparing short, numeric date with BETWEEN): Fixed in 5.0.45, 5.0.44
Bug#28779 (mysql_query() allows execution of statements with unbalanced comments): Fixed in 5.0.51, 5.0.50
Bug#28781 (InnoDB increments auto-increment value incorrectly with ON DUPLICATE KEY UPDATE): Fixed in 5.0.48, 5.0.51
Bug#28811 (server crash with subqueries and order by): Fixed in 5.0.45, 5.0.44
Bug#28846 (Use of undocumented Prepared Statements crashes server): Fixed in 5.0.51, 5.0.46
Bug#28878 (InnoDB tables with UTF8 character set and indexes cause wrong result for DML): Fixed in 5.0.44
Bug#28893 (--relay-log variable is not exposed with SHOW VARIABLES): Fixed in 5.0.52
Bug#28929 (Comparing date field with NOW() broken): Fixed in 5.0.42, 5.0.45
Bug#28983 ('reset master' in multiple threads and innodb tables asserts debug binary): Fixed in 5.0.51, 5.0.46
Bug#29050 (Creation of a legal stored procedure fails if a database is not selected prior): Fixed in 5.0.48, 5.0.51, 5.0.44sp1
Bug#29104 (crash when selecting from a view): Fixed in 5.0.51, 5.0.46
Bug#29205 (truncation when using binary in union): Fixed in 5.0.51, 5.0.46
Bug#29251 (MySQL coerces special 0 enum values to '' when ALTERing the column): Fixed in 5.0.51, 5.0.46
Bug#29364 (SQL queries hang while data node in start phase 5): Fixed in 5.0.51, 5.0.46
Bug#29582 (huge memory consumption with union, subselect, joins): Fixed in 5.0.48, 5.0.51
Bug#29898 (DATE() function returns inconsistent results): Fixed in 5.0.48, 5.0.51, 5.0.44sp1
Bug#30084 (Installation script runs mysql_install_db unconditionally): Fixed in 5.0.42, 5.0.45, 5.0.44, 5.0.46
Bug#30088 (Can't disable myisam-recover by a value of "".): Fixed in 5.0.48, 5.0.51
Bug#39002 (crash with insert .. select * from ... on duplicate key update col=default): Fixed in 5.0.70
Bug#41943 (mysqlbinlog.exe crashes if --hexdump option is used): Fixed in 5.0.83
Bug#42419 (Server crash with "Pure virtual method called" on two concurrent connections ): Fixed in 5.0.74sp1, 5.0.79
5.0.44
Bug#23097 (mysql can't insert korean on mysql prompt.): Fixed in 5.0.60
Bug#25347 (Patch: mysqlcheck -A -r doesn't repair table marked as crashed): Fixed in 5.0.56
Bug#25602 (Error with /*!HIGH_PRIORITY SQL_CACHE SQL_BIG_RESULT*/ combined with DISTINCT): Fixed in 5.0.51, 5.0.46
Bug#26793 (mysqld crashes when doing specific query on information_schema): Fixed in 5.0.51, 5.0.50
Bug#27990 (MYSQL_FIELD struct's member strings Bug 21635 not fixed for all cases): Fixed in 5.0.52
Bug#28293 (mysqlbinlog: corrupt SQL in hex dump mode [PATCH INCLUDED]): Fixed in 5.0.51, 5.0.46
Bug#28571 (LEFT JOIN with a const false condition produces no rows instead of 1 NULL row): Fixed in 5.0.45, 5.0.44
Bug#28574 (repair table causes queries to fail with various corruption errors: 126,134,145): Fixed in 5.0.51, 5.0.46
Bug#28598 (mysqld crash when killing a long-running explain query): Fixed in 5.0.45, 5.0.44
Bug#28652 (MySQL (with-debug=full) asserts when alter table operations): Fixed in 5.0.45, 5.0.44
Bug#28702 (VIEWs defined with USE/FORCE KEY ignore that request): Fixed in 5.0.52
Bug#28728 (server crash with EXPLAIN EXTENDED .. and subqueries): Fixed in 5.0.45, 5.0.44
Bug#28808 (log_queries_not_using_indexes variable dynamic change is ignored): Fixed in 5.0.51, 5.0.46
Bug#28811 (server crash with subqueries and order by): Fixed in 5.0.45, 5.0.44
Bug#28812 (rpl_ssl fails due to assert in extra/yassl/src/socket_wrapper.cpp:117): Fixed in 5.0.51, 5.0.50
Bug#28897 (UUID() returns non-unique values when query cache is enabled): Fixed in 5.0.45, 5.0.44
Bug#28898 (mysql_fetch_field gives empty table name by a view): Fixed in 5.0.51, 5.0.46
Bug#28921 (Queries contaning UDF functions are cached): Fixed in 5.0.51, 5.0.46
Bug#28980 (ROUND(x,y) returns different results for same literal and int column values as y): Fixed in 5.0.45, 5.0.44
Bug#28983 ('reset master' in multiple threads and innodb tables asserts debug binary): Fixed in 5.0.51, 5.0.46
Bug#29095 (Insert into a select from a join b using(c) order by b.auto_id desc limit 1 fail): Fixed in 5.0.51, 5.0.46
Bug#29104 (crash when selecting from a view): Fixed in 5.0.51, 5.0.46
Bug#29154 (LOCK TABLES is not atomic when <1 InnoDB tables are locked): Fixed in 5.0.51, 5.0.46
Bug#29207 (archive table reported as corrupt by check table): Fixed in 5.0.51, 5.0.46
Bug#29261 (repeatable innodb and myisam corruption): Fixed in 5.0.51, 5.0.46
Bug#29299 (repeatable myisam fulltext index corruption): Fixed in 5.0.51, 5.0.46
Bug#29325 (create table overwrites .MYD file of other table (datadir)): Fixed in 5.0.48, 5.0.51
Bug#29333 (myisam corruption with character set cp932 collate cp932_japanese_ci): Fixed in 5.0.48, 5.0.51
Bug#29361 (mysqldump creates stray file when too long path name is passed): Fixed in 5.0.51, 5.0.46
Bug#29415 (cast as decimal does allow out of range specification): Fixed in 5.0.51, 5.0.46
Bug#29420 (crash with show and purge binlogs): Fixed in 5.0.51, 5.0.46
Bug#29469 (Client dies if a query is issued after hitting Ctrl + C): Fixed in 5.0.48, 5.0.51
Bug#29536 (timestamp inconsistent in replication around 1970): Fixed in 5.0.48, 5.0.51
Bug#29604 (Views sometimes return incorrect data with LEFT JOINs): Fixed in 5.0.48, 5.0.51
Bug#29674 (restore of backup from different endian core dump): Fixed in 5.0.51, 5.0.50
Bug#29729 (datetime compared with date failing to add zero time on group by query): Fixed in 5.0.48, 5.0.51, 5.0.44sp1
Bug#29834 (Accessing a view in a stored procedure causes a small memory consumption): Fixed in 5.0.48, 5.0.51
Bug#29851 (TRUNCATE causes error 4350 from cluster in INSERT... ON DUPLICATE KEY UPDATE): Fixed in 5.0.58
Bug#29856 (Very long prepared statement in SP can cause crash with certain options): Fixed in 5.0.48, 5.0.51
Bug#30084 (Installation script runs mysql_install_db unconditionally): Fixed in 5.0.42, 5.0.45, 5.0.44, 5.0.46
Bug#30088 (Can't disable myisam-recover by a value of "".): Fixed in 5.0.48, 5.0.51
Bug#30287 (tmpdir not respected on GROUP BY): Fixed in 5.0.48, 5.0.51
Bug#31291 (ALTER TABLE CONVERT TO CHARACTER SET does not change some data types): Fixed in 5.0.76
Bug#31848 (Test failure: Cluster has problems on insert with auto-increment ): Fixed in 5.0.52
Bug#32125 (Database crash due to ha_innodb.cc:3896: ulint convert_search_mode_to_innobase): Fixed in 5.0.50sp1, 5.0.54
Bug#32436 (KILL QUERY completely deadlocks mysqld): Fixed in 5.0.54
Bug#37150 (Risk for crash in User_var_log_event::exec_event()): Fixed in 5.0.66
Bug#41354 (Access control is bypassed when all columns of a view are selected by * wildcard): Fixed in 5.0.79
5.0.45
Bug#27415 (Text Variables in stored procedures): Fixed in 5.0.45, 5.0.44
Bug#27884 (mysql --html does not quote HTML special characters in output): Fixed in 5.0.89
Bug#29306 (Truncated data in MS Access with decimal (3,1) columns in a VIEW): Fixed in 5.0.48, 5.0.51
Bug#29729 (datetime compared with date failing to add zero time on group by query): Fixed in 5.0.48, 5.0.51, 5.0.44sp1
Bug#29788 (MySQL 5.0.45 restore of dump fails): Fixed in 5.0.48, 5.0.51
Bug#29911 (DISTINCT adds a result to what should be an empty result set): Fixed in 5.0.48, 5.0.51
Bug#30069 (bigint -9223372036854775808 stopped working on x86_64): Fixed in 5.0.54
Bug#30126 (ADD_DROP_DATABASE with mysqldump problem): Fixed in 5.0.51, 5.0.50
Bug#30129 (mysql_install_db appears to run normally, but the databases are not created): Fixed in 5.0.68
Bug#30269 (Query cache eats memory): Fixed in 5.0.48, 5.0.51
Bug#30286 (spatial index cause corruption and server crash!): Fixed in 5.0.52
Bug#30305 (Create routine in wrong context in SHOW PRIVILEGES): Fixed in 5.0.79
Bug#30377 (EXPLAIN loses last_query_cost when used with UNION): Fixed in 5.0.51, 5.0.50
Bug#30394 (Empty HOME environment variable causes several utilities to crash): Fixed in 5.0.70
Bug#30666 (Incorrect order when using range conditions on 2 tables or more): Fixed in 5.0.52
Bug#30715 (Assertion failed: item_field-<field-<real_maybe_null(), file .\opt_sum.cc, line ): Fixed in 5.0.52
Bug#30782 (Truncated UNSIGNED BIGINT columns only in SELECT w/ CASE, JOIN, and ORDER BY): Fixed in 5.0.54
Bug#30788 (Inconsistent retrieval of char/varchar): Fixed in 5.0.54
Bug#30897 (GROUP_CONCAT returns extra comma on empty fields): Fixed in 5.0.52
Bug#30954 ("configure" script in binary distributions considered harmfull): Fixed in 5.0.87
Bug#30998 (Drop View breaks replication if view does not exist): Fixed in 5.0.56
Bug#31019 (MOD() Function and Operator Crashes MySQL when Divisor is Very Long and < 1): Fixed in 5.0.52
Bug#31137 (Assertion failed: primary_key_no == -1 || primary_key_no == 0, file .\ha_innodb.): Fixed in 5.0.54
Bug#31158 (Spatial, Union, LONGBLOB vs BLOB bug (crops data)): Fixed in 5.0.54
Bug#31164 (Solaris 10 postinstall script fails to create system tables): Fixed in 5.0.78
Bug#31221 (Optimizer incorrectly identifies impossible WHERE clause): Fixed in 5.0.51, 5.0.50
Bug#31347 (Increase in memory usage after many DROP USER statements): Fixed in 5.0.52
Bug#31605 (mysql_upgrade relies on Linux /proc filesystem when not running on Windows): Fixed in 5.0.68
Bug#31797 (error while parsing subqueries -- WHERE is parsed as HAVING): Fixed in 5.0.56
Bug#31800 (Date comparison fails with timezone and slashes for greater than comparison): Fixed in 5.0.52
Bug#31887 (DML Select statement not returning same results when executed in version 5): Fixed in 5.0.60
Bug#32051 (UNION within EXISTS returns incorrect result): Fixed in 5.0.54
Bug#32180 (DATE_ADD treats datetime numeric argument as DATE instead of DATETIME): Fixed in 5.0.54
Bug#32223 (SETting max_allowed_packet variable): Fixed in 5.0.84
Bug#32268 (Indexed queries give bogus MIN and MAX results): Fixed in 5.0.54
Bug#32798 (DISTINCT in GROUP_CONCAT clause fails when ordering by a column with null values): Fixed in 5.0.56
Bug#32815 (Problem with ORDER BY if WHERE is used with NOT NULL): Fixed in 5.0.54
Bug#32848 (Data type conversion bug in union subselects in MySQL 5.0.38): Fixed in 5.0.56
Bug#32858 (Error: "Incorrect usage of UNION and INTO" does not take subselects into account): Fixed in 5.0.56
Bug#32898 (Bug#23973 (--without-server builds server) patch not applied in 5.0.45): Fixed in 5.0.67
Bug#32942 (now() - interval '7200' second is NOT pre-calculated, causing "full table scan"): Fixed in 5.0.60
Bug#33201 (Crash occurs when granting update privilege on one column of a view): Fixed in 5.0.60
Bug#33851 (Passing UNSIGNED param to EXECUTE returns ERROR 1210): Fixed in 5.0.58
Bug#34289 (Incorrect NAME_CONST substitution in stored procedures breaks replication): Fixed in 5.0.60
Bug#36737 (having + full text operator crashes mysql): Fixed in 5.0.79
Bug#37740 (Server crashes on execute statement with full text search and match against): Fixed in 5.0.85
Bug#38842 (Fix for 25951 seems incorrect): Fixed in 5.0.72sp1, 5.0.74
5.0.46
Bug#21476 (stack overflow crashes server; error-message stack reservation too small): Fixed in 5.0.45, 5.0.44
Bug#25714 (getGeneratedKeys() does not work with FEDERATED table): Fixed in 5.0.48, 5.0.51
Bug#28587 (SELECT is blocked by INSERT waiting on read lock, even with low_priority_updates): Fixed in 5.0.51, 5.0.50
Bug#29247 (Double free in libmysqlclient_r when mysqld restarted): Fixed in 5.0.51, 5.0.46
Bug#29431 (killing an insert delayed thread causes crash): Fixed in 5.0.48, 5.0.51
Bug#29458 (check/optimize/repair/analyze table reports 'corrupt' unnessesarily): Fixed in 5.0.80
Bug#29461 (corruption with character set macce collate macce_bin): Fixed in 5.0.48, 5.0.51
Bug#29499 (Converting 'del' from ascii to Unicode results in 'question mark'): Fixed in 5.0.48, 5.0.51
Bug#29579 (Clients using SSL can hang the server): Fixed in 5.0.48, 5.0.51
Bug#29582 (huge memory consumption with union, subselect, joins): Fixed in 5.0.48, 5.0.51
Bug#29734 (thread_id=0 in binary log which leads to temporary table conflicts): Fixed in 5.0.48, 5.0.51
Bug#29838 (myisam corruption using concurrent select ... and update): Fixed in 5.0.48, 5.0.51
Bug#29908 (alter view keeps current definer, user can gain additioanl access): Fixed in 5.0.50sp1, 5.0.52, 5.0.51a
Bug#29948 (autoreconnect + prepared statements + kill seems unstable): Fixed in 5.0.48, 5.0.51
Bug#30020 (Wrong IS_UPDATABLE value in I_S.VIEWS for a non updatable view (regression)): Fixed in 5.0.48, 5.0.51
Bug#30084 (Installation script runs mysql_install_db unconditionally): Fixed in 5.0.42, 5.0.45, 5.0.44, 5.0.46
Bug#30118 (Debug version of static client library on Windows lacks symbols): Fixed in 5.0.48, 5.0.51
Bug#30435 (loading large LOAD DATA INFILE breaks slave with read_buffer_size set on master): Fixed in 5.0.56
Bug#30638 (why doesn't < 4294967295 rows work in myisam on windows ?): Fixed in 5.0.52
Bug#30942 (select str_to_date from derived table returns varying results): Fixed in 5.0.52
Bug#31194 (Privilege ordering does not order properly for wildcard values): Fixed in 5.0.60
Bug#31793 (log event corruption causes crash): Fixed in 5.0.54
Bug#34286 (Assertion failure in thread 2816 in file .\row\row0sel.c line 3500): Fixed in 5.0.68
Bug#37527 (mysqlcheck fails to report entire database when InnoDB frm file corruption): Fixed in 5.0.74
5.0.48
Bug#29856 (Very long prepared statement in SP can cause crash with certain options): Fixed in 5.0.48, 5.0.51
Bug#30193 (crash during drop table and kill): Fixed in 5.0.48, 5.0.51
Bug#30201 (crash with query cache when killing a select): Fixed in 5.0.48, 5.0.51
Bug#30286 (spatial index cause corruption and server crash!): Fixed in 5.0.52
Bug#30294 (blackhole engine causes 100% with 2 alter table statements running): Fixed in 5.0.54
Bug#30396 (memory overrun during EXPLAIN EXTENDED): Fixed in 5.0.48, 5.0.51
Bug#30468 (column level privileges not respected when joining tables): Fixed in 5.0.52
Bug#30495 (optimize table t1,t2,t3 extended errors): Fixed in 5.0.54
Bug#30590 (delete from memory table with composite btree primary key): Fixed in 5.0.52
Bug#30593 (No cipher list returned for "SHOW STATUS LIKE 'Ssl_cipher_list'"): Fixed in 5.0.51, 5.0.50
Bug#30638 (why doesn't < 4294967295 rows work in myisam on windows ?): Fixed in 5.0.52
Bug#30942 (select str_to_date from derived table returns varying results): Fixed in 5.0.52
Bug#30960 (processlist state '*** DEAD ***' on recent 5.0.48 windows builds): Fixed in 5.0.60
Bug#31001 (ORDER BY DESC in InnoDB not working): Fixed in 5.0.51, 5.0.50
Bug#31048 (many nested subqueries causes out of memory and crash): Fixed in 5.0.54
Bug#31081 (server crash in regexp function): Fixed in 5.0.54
Bug#31095 (server crashes with group by null with rollup): Fixed in 5.0.52
Bug#31154 (field.h:1649: virtual int Field_bit::cmp(const uchar*, const uchar*): Assertion ): Fixed in 5.0.52
Bug#31155 (gis types in union'd select cause crash): Fixed in 5.0.52
Bug#31156 (mysqld: item_sum.cc:918: virtual bool Item_sum_distinct::setup(THD*): Assertion ): Fixed in 5.0.52
Bug#31159 (fulltext search on ucs2 column crashes server): Fixed in 5.0.52
Bug#31253 (crash comparing datetime to double): Fixed in 5.0.52
Bug#31305 (myisam tables crash when they are near capacity): Fixed in 5.0.52
Bug#31347 (Increase in memory usage after many DROP USER statements): Fixed in 5.0.52
Bug#32020 (loading udfs while --skip-grant-tables is enabled causes out of memory errors): Fixed in 5.0.52
Bug#34286 (Assertion failure in thread 2816 in file .\row\row0sel.c line 3500): Fixed in 5.0.68
Bug#42278 (Missing libndbclient.so from "cluster" packages.): Fixed in 5.0.78, 5.0.72sp1
5.0.50
Bug#30768 (query cache patch for Bug#21074 crashes on windows): Fixed in 5.0.52
Bug#30821 (setting --tc_heuristic_recover tries to set myisam_stats_method): Fixed in 5.0.52
Bug#30832 (Assertion + crash with select name_const('test',now());): Fixed in 5.0.52
Bug#30885 (MEMORY returns incorrect data if BTREE index is used for NULL lookup): Fixed in 5.0.52
Bug#30889 (filesort and order by with float/numeric crashes server): Fixed in 5.0.56
Bug#30942 (select str_to_date from derived table returns varying results): Fixed in 5.0.52
Bug#31035 (select from function, group by result crasher): Fixed in 5.0.51, 5.0.50
Bug#31070 (crash during conversion of charsets): Fixed in 5.0.52
Bug#31159 (fulltext search on ucs2 column crashes server): Fixed in 5.0.52
Bug#31222 (com_% global status counters behave randomly with mysql_change_user): Fixed in 5.0.78
Bug#31227 (memory overrun with decimal (6,6) and zerofill and group_concat..): Fixed in 5.0.52
Bug#31239 (Test "ndb_views" returns NDB error 4259 "Invalid set of range scan bounds"): Fixed in 5.0.58
Bug#31435 (ha_innodb.cc:3983: ulint convert_search_mode_to_innobase(ha_rkey_function): Asse): Fixed in 5.0.79
Bug#31440 ('select 1 regex null' asserts debug server): Fixed in 5.0.52
Bug#31471 (decimal_bin_size: Assertion `scale <= 0 && precision < 0 && scale <= precision' ): Fixed in 5.0.52
Bug#31588 (buffer overrun when setting variables): Fixed in 5.0.52
Bug#31615 (crash after set names ucs2 collate xxx): Fixed in 5.0.54
Bug#31742 (delete from ... order by function call that causes an error, asserts server): Fixed in 5.0.52
Bug#31758 (inet_ntoa, oct, crashes server with null + filesort): Fixed in 5.0.52
Bug#31950 (repair table hangs while processing multicolumn utf8 fulltext index): Fixed in 5.0.52
Bug#31989 (InnoDB is contained in "cluster" RPMs): Fixed in 5.0.51, 5.0.50
Bug#32036 (EXISTS within a WHERE clause with a UNION crashes MySQL 5.122): Fixed in 5.0.54
Bug#32047 ('Spurious' errors while opening MERGE tables): Fixed in 5.0.78
Bug#32083 (server crashes on show status when InnoDB is not initialized): Fixed in 5.0.58
Bug#32103 (optimizer crash when join on int and mediumint with variable in where clause..): Fixed in 5.0.52
Bug#32197 (mysqld.exe is missing from 5.0.50 on windows): Fixed in 5.0.51, 5.0.50
Bug#32198 (Comparison of DATE with DATETIME still not using indexes correctly): Fixed in 5.0.54
Bug#32202 (ORDER BY not working with GROUP BY): Fixed in 5.0.52
Bug#32205 (Replaying statements from mysqlbinlog fails with a syntax error, replicates fine): Fixed in 5.0.56
Bug#32221 (bug25714, mytest, mysql_client_test complaints and crashes): Fixed in 5.0.54
Bug#32241 (memory corruption due to large index map in 'Range checked for each record'): Fixed in 5.0.54
Bug#32265 (Server returns different metadata if prepared statement is used): Fixed in 5.0.58
Bug#32335 (inconsistent int < null +1 behavior): Fixed in 5.0.54
Bug#32374 (crash with filesort when selecting from federated table and view): Fixed in 5.0.54
Bug#32403 (query causes a crash due to stack and memory corruptions): Fixed in 5.0.54
Bug#32510 (LIKE search fails with indexed 'eucjpms' and 'ujis' char column): Fixed in 5.0.60
Bug#32514 (mysqld depends on icc libraries): Fixed in 5.0.50sp1, 5.0.52
Bug#32556 (assert in "using index for group-by" : is_last_prefix <= 0, file .\opt_range.cc): Fixed in 5.0.54
Bug#32559 (connection hangs on query with name_const): Fixed in 5.0.54
Bug#32560 (crash with interval function and count(*)): Fixed in 5.0.54
Bug#32575 (Parse error of stmt with extended comments on slave side): Fixed in 5.0.62
Bug#32676 (insert delayed crash with wrong column and function specified ..): Fixed in 5.0.54
Bug#32705 (myisam corruption: Key in wrong position at page 1024 with ucs2_bin): Fixed in 5.0.60
Bug#32726 (crash with cast in order by clause and cp932 charset): Fixed in 5.0.54
Bug#33031 (app linked to libmysql.lib crash if run as service in vista under localsystem): Fixed in 5.0.70
Bug#33050 (5.0.50 fails many SSL testcases): Fixed in 5.0.58
Bug#33146 (CHECKSUM TABLE is not interruptable by KILL QUERY statement): Fixed in 5.0.82
Bug#33756 (query cache with concurrent_insert=0 appears broken): Fixed in 5.0.60
Bug#35087 (Inserting duplicate values at one time with DES_ENCRYPT leads to wrong results): Fixed in 5.0.82
Bug#35193 (VIEW query is rewritten without "FROM DUAL", causing syntax error): Fixed in 5.0.60
Bug#35396 (Abnormal / impossible / large Query_time and Lock_time values in slow query log): Fixed in 5.0.78
Bug#35577 (CREATE PROCEDURE causes either crash or syntax error depending on build): Fixed in 5.0.68
Bug#37553 (MySql Error Compare TimeDiff & Time): Fixed in 5.0.74
5.0.51
Bug#22082 (Slave hangs(holds mutex) on "disk full"): Fixed in 5.0.79
Bug#31164 (Solaris 10 postinstall script fails to create system tables): Fixed in 5.0.78
Bug#33050 (5.0.50 fails many SSL testcases): Fixed in 5.0.58
Bug#33201 (Crash occurs when granting update privilege on one column of a view): Fixed in 5.0.60
Bug#33758 (Got query result when using ORDER BY ASC, but empty result when using DESC): Fixed in 5.0.60
Bug#34159 (mysql_install_db fails with sql_mode=TRADITIONAL): Fixed in 5.0.67, 5.0.68
Bug#34192 (mysqldump from mysql 5.0.51 silently fails on dumping databases from 4.0 server): Fixed in 5.0.60
Bug#34291 (compile-amd64-debug-max-no-ndb missing): Fixed in 5.0.62
Bug#34339 (mysql_explain_log fails if queries have embedded comments): Fixed in 5.0.58
Bug#34512 (CAST( AVG( double ) AS DECIMAL ) returns wrong results): Fixed in 5.0.60
Bug#34687 (Error in bin-log after shutdown restart binlog was not closed properly): Fixed in 5.0.84
Bug#34731 (highest possible value for INT erroneously filtered by WHERE): Fixed in 5.0.60
Bug#34909 (mysqldump returns a 0 status on error when using --master-data ): Fixed in 5.0.60
Bug#35132 (MySQLadmin --wait ping always crashes on Windows systems): Fixed in 5.0.86
Bug#35178 (INSERT_ID not written to binary log for inserts against BLACKHOLE backed tables ): Fixed in 5.0.60
Bug#35469 (server crash with LOAD DATA INFILE to a VIEW): Fixed in 5.0.60
Bug#35924 (DEFINER should be stored 'quoted' in I_S): Fixed in 5.0.72
Bug#36149 (Read buffer overflow in srv0start.c found during "make test"): Fixed in 5.0.76
Bug#37044 (Read overflow in opt_range.cc found during "make test"): Fixed in 5.0.86
Bug#37228 (Sever crashes when creating stored procedure with more than 10 IF/ELSEIF): Fixed in 5.0.68
Bug#37416 (When SQL_NO_CACHE is used, MySQL still lookup into the query cache): Fixed in 5.0.79
Bug#37526 (asymertic operator <=< in trigger): Fixed in 5.0.70
Bug#37740 (Server crashes on execute statement with full text search and match against): Fixed in 5.0.85
Bug#37943 (Reproducible mysqld crash/sigsegv in sel_trees_can_be_ored): Fixed in 5.0.72
Bug#38195 (Executing query causes memory access violation error in mysql service): Fixed in 5.0.70
Bug#38637 (COUNT DISTINCT prevents NULL testing in HAVING clause): Fixed in 5.0.78
Bug#40565 (Update Query Results in "1 Row Affected" But Should Be "Zero Rows"): Fixed in 5.0.84
Bug#41049 (does syntax "grant" case insensitive?): Fixed in 5.0.87sp1, 5.0.88
Bug#41079 (information_schema.schema_privileges is limited to 7680 records.): Fixed in 5.0.76
Bug#41486 (extra character appears in BLOB for every ~40Mb after mysqldump/import ): Fixed in 5.0.80
Bug#43254 (SQL_SELECT_LIMIT=0 crashes command line client): Fixed in 5.0.80
Bug#43432 (Union on floats does unnecessary rounding): Fixed in 5.0.82
5.0.52
Bug#31761 (Code for cluster is not safe for strict-alias optimization in new gcc): Fixed in 5.0.52
Bug#32136 (mysqld_multi --defaults-file not respected while using --mysqld=mysqld_safe): Fixed in 5.0.78
Bug#32198 (Comparison of DATE with DATETIME still not using indexes correctly): Fixed in 5.0.54
Bug#32496 (In "traditional, ansi" an identifier is not more accepted, that formerly was.): Fixed in 5.0.52
Bug#33029 (5.0 to 5.1 replication fails on dup key when inserting using a trig in SP): Fixed in 5.0.60
Bug#33050 (5.0.50 fails many SSL testcases): Fixed in 5.0.58
Bug#33057 (mysql command line client slows down and uses 100% CPU when restoring dump): Fixed in 5.0.56
Bug#33146 (CHECKSUM TABLE is not interruptable by KILL QUERY statement): Fixed in 5.0.82
Bug#33252 (Add the mysqld.debug to tarball packages): Fixed in 5.0.60
Bug#33389 (Selecting from a view into a table from within SP or trigger crashes server): Fixed in 5.0.60
Bug#33461 (SELECT ... FROM <view< USE INDEX (...) throws an error): Fixed in 5.0.74
Bug#33812 (mysql client incorrectly parsing DELIMITER): Fixed in 5.0.76, 5.0.66
Bug#33813 (Schema names are case-sensitive in DROP FUNCTION): Fixed in 5.0.79
Bug#35577 (CREATE PROCEDURE causes either crash or syntax error depending on build): Fixed in 5.0.68
5.0.54
Bug#21226 (FLUSH PRIVILEGES does not provided feedback when it fails.): Fixed in 5.0.68
Bug#33057 (mysql command line client slows down and uses 100% CPU when restoring dump): Fixed in 5.0.56
Bug#33304 (Test 'func_group' hangs on Mac OS X 10.4 PowerPC 64-bit): Fixed in 5.0.60
Bug#33389 (Selecting from a view into a table from within SP or trigger crashes server): Fixed in 5.0.60
Bug#33675 (crash with subquery and filesort?): Fixed in 5.0.56
Bug#33756 (query cache with concurrent_insert=0 appears broken): Fixed in 5.0.60
Bug#33798 (prepared statements improperly handle large unsigned ints): Fixed in 5.0.58
Bug#33812 (mysql client incorrectly parsing DELIMITER): Fixed in 5.0.76, 5.0.66
Bug#33841 (mysql client crashes when returning results for long running queries): Fixed in 5.0.58
Bug#33851 (Passing UNSIGNED param to EXECUTE returns ERROR 1210): Fixed in 5.0.58
Bug#33946 (Join on Federated tables with Unique index gives error 1430 from storage engine): Fixed in 5.0.60
Bug#34223 (Assertion failed: (optp-<var_type & 127) == 8, file .\my_getopt.c, line 830): Fixed in 5.0.60
Bug#34286 (Assertion failure in thread 2816 in file .\row\row0sel.c line 3500): Fixed in 5.0.68
Bug#34512 (CAST( AVG( double ) AS DECIMAL ) returns wrong results): Fixed in 5.0.60
Bug#34731 (highest possible value for INT erroneously filtered by WHERE): Fixed in 5.0.60
Bug#34749 (Server crash when using NAME_CONST() with an aggregate function): Fixed in 5.0.60
Bug#35480 (BOM detection code crashes mysql CLI with zero-sized input): Fixed in 5.0.66
Bug#37145 (Killing a statement doing DDL may log binlog event with error code 1053): Fixed in 5.0.82
Bug#45152 (crash with round() function on longtext column in a derived table): Fixed in 5.0.82sp1, 5.0.84
Bug#45806 (crash when replacing into a view with a join!): Fixed in 5.0.82sp1, 5.0.84
5.0.56
Bug#27732 (Possible memory leak with index_merge): Fixed in 5.0.60
Bug#31052 (PKG Install on Solaris creates temporary files that are not deleted): Fixed in 5.0.77, 5.0.79
Bug#31164 (Solaris 10 postinstall script fails to create system tables): Fixed in 5.0.78
Bug#31590 (incorrect out of memory error and sort aborted messages in logs): Fixed in 5.0.60
Bug#33049 (Assert while running test-as3ap test(mysql-bench suite)): Fixed in 5.0.60
Bug#33862 (completely failed DROP USER statement gets replicated): Fixed in 5.0.56
Bug#34223 (Assertion failed: (optp-<var_type & 127) == 8, file .\my_getopt.c, line 830): Fixed in 5.0.60
Bug#34747 (crash in debug assertion check after derived table): Fixed in 5.0.60
Bug#34773 (query with explain extended and derived table / other table crashes server): Fixed in 5.0.76, 5.0.74sp1
Bug#34788 (malformed federated connection url is not handled correctly - crashes server !): Fixed in 5.0.60
Bug#34825 (perror on windows doesn't know about win32 error codes): Fixed in 5.0.74
Bug#35298 (GROUP_CONCAT with DISTINCT can crash the server): Fixed in 5.0.62
Bug#35383 (binlog playback and replication breaks due to name_const substitution): Fixed in 5.0.80
Bug#35515 (Aliases of variables in binary log are ignored with NAME_CONST): Fixed in 5.0.82
Bug#35848 (UUID() returns UUIDs with the wrong time): Fixed in 5.0.68
Bug#37051 (Replication rules not evaluated correctly.): Fixed in 5.0.79
Bug#37301 (Length and Max_length differ with no obvious reason): Fixed in 5.0.70
Bug#38145 (.frm file isn't sync'd with sync_frm enabled): Fixed in 5.0.78
5.0.58
Bug#34620 (item_row.cc:50: Item_row::illegal_method_call(const char*): Assertion `0' failed): Fixed in 5.0.60
Bug#35104 (Debug symbols are missing for mysql client on Windows): Fixed in 5.0.60
Bug#35577 (CREATE PROCEDURE causes either crash or syntax error depending on build): Fixed in 5.0.68
Bug#35754 (mysql_install_db does not work if no hostname is set): Fixed in 5.0.72
Bug#35993 (severe memory corruption and crash with multibyte conversion): Fixed in 5.0.62
Bug#36005 (crash in subselect with single row (subselect_single_select_engine::exec)): Fixed in 5.0.62
Bug#36011 (server crash with explain extended on query with dependent subqueries): Fixed in 5.0.64
Bug#36023 (crash/huge memory alloc with max and case when if statement): Fixed in 5.0.62
Bug#36270 (incorrect calculation result - works in 4.1 but not in 5.0 or 5.1): Fixed in 5.0.70
Bug#36279 (mysql.exe built with Visual C++ 2005 cannot display japanese character.): Fixed in 5.0.74
Bug#36676 (UPDATE on TEXT column using LEFT JOIN doesn't update all rows): Fixed in 5.0.64
5.0.60
Bug#11122 (Server won't always start when cold booting after a crash): Fixed in 5.0.8, 5.0.72
Bug#32047 ('Spurious' errors while opening MERGE tables): Fixed in 5.0.78
Bug#35509 (Federated leaks memory when connecting to localhost/default port): Fixed in 5.0.60
Bug#36570 (Parse error of CREATE PROCEDURE stmt with comments on slave): Fixed in 5.0.64
Bug#36654 (mysqld_multi cannot start instances with different versions occasionally.): Fixed in 5.0.84
Bug#36705 (key_buffer_size of <= 2G allocates all available virtual memory on 64-bit windo): Fixed in 5.0.64
Bug#36737 (having + full text operator crashes mysql): Fixed in 5.0.79
Bug#37027 (expire_logs_days and missing binlogs cause a crash !): Fixed in 5.0.68
Bug#37268 ('binary' character set makes CLI-internal commands case sensitive): Fixed in 5.0.84
Bug#37671 (crash on prepared statement + cursor + geometry + too many open files !): Fixed in 5.0.76
Bug#37830 (ORDER BY ASC/DESC - no difference): Fixed in 5.0.68
Bug#41370 (TIMESTAMP field does not accepts NULL from FROM_UNIXTIME()): Fixed in 5.0.78
Bug#43660 (SHOW INDEXES/ANALYZE does NOT update cardinality for indexes of InnoDB table): Fixed in 5.0.82
5.0.62
Bug#35577 (CREATE PROCEDURE causes either crash or syntax error depending on build): Fixed in 5.0.68
Bug#37339 (SHOW VARIABLES not working properly with multi-byte datadir): Fixed in 5.0.74
Bug#37553 (MySql Error Compare TimeDiff & Time): Fixed in 5.0.74
Bug#37943 (Reproducible mysqld crash/sigsegv in sel_trees_can_be_ored): Fixed in 5.0.72
Bug#39040 (valgrind errors/crash when creating views with binlog logging enabled): Fixed in 5.0.74
5.0.64
Bug#25058 (ignored return codes in memory allocation functions): Fixed in 5.0.82
Bug#37027 (expire_logs_days and missing binlogs cause a crash !): Fixed in 5.0.68
Bug#37269 (parser crash when creating stored procedure): Fixed in 5.0.68
Bug#37301 (Length and Max_length differ with no obvious reason): Fixed in 5.0.70
Bug#37662 (nested if() inside sum() is parsed in exponential time): Fixed in 5.0.68
Bug#37671 (crash on prepared statement + cursor + geometry + too many open files !): Fixed in 5.0.76
Bug#38291 (memory corruption and server crash with view/sp/function): Fixed in 5.0.70
5.0.66
Bug#27884 (mysql --html does not quote HTML special characters in output): Fixed in 5.0.89
Bug#34159 (mysql_install_db fails with sql_mode=TRADITIONAL): Fixed in 5.0.67, 5.0.68
Bug#36995 (valgrind error in remove_const during subquery executions): Fixed in 5.0.84
Bug#37671 (crash on prepared statement + cursor + geometry + too many open files !): Fixed in 5.0.76
Bug#37956 (memory leak and / or crash with geometry and prepared statements!): Fixed in 5.0.76
Bug#38180 (options are read from ~/my.cnf instead of ~/.my.cnf): Fixed in 5.0.66a
Bug#38469 (invalid memory read and/or crash with utf8 text field, stored procedure, uservar): Fixed in 5.0.72
Bug#38479 (valgrind warnings in show table status for innodb tables): Fixed in 5.0.84
Bug#38637 (COUNT DISTINCT prevents NULL testing in HAVING clause): Fixed in 5.0.78
Bug#38816 (kill + flush tables with read lock + stored procedures causes crashes!): Fixed in 5.0.85
Bug#39002 (crash with insert .. select * from ... on duplicate key update col=default): Fixed in 5.0.70
Bug#39040 (valgrind errors/crash when creating views with binlog logging enabled): Fixed in 5.0.74
Bug#39069 (<row constructor< IN <table-subquery< seriously messed up): Fixed in 5.0.78
Bug#41486 (extra character appears in BLOB for every ~40Mb after mysqldump/import ): Fixed in 5.0.80
Bug#42635 (mysqldump includes views that were excluded using the --ignore-table option): Fixed in 5.0.80
5.0.67
Bug#22082 (Slave hangs(holds mutex) on "disk full"): Fixed in 5.0.79
Bug#27884 (mysql --html does not quote HTML special characters in output): Fixed in 5.0.89
Bug#34760 (Character set autodetection appears to fail): Fixed in 5.0.72sp1, 5.0.74
Bug#35558 (Wrong server metadata blows up the client): Fixed in 5.0.76
Bug#38691 (segfault/abort in ``UPDATE ...JOIN'' while ``FLUSH TABLES WITH READ LOCK''): Fixed in 5.0.72
Bug#38990 (Arbitrary data input plus GIS functions causes mysql server crash): Fixed in 5.0.82
Bug#39021 (SELECT REGEXP BINARY NULL never returns): Fixed in 5.0.70
Bug#39101 (client -i (--ignore-spaces) option does not seem to work): Fixed in 5.0.83
Bug#39182 (Binary log producing incompatible character set query from stored procedure.): Fixed in 5.0.72
Bug#39283 (Date returned as VARBINARY to client for queries with COALESCE and JOIN): Fixed in 5.0.72
Bug#39541 (CHECK TABLE on information_schema myisam tables produces error): Fixed in 5.0.74
Bug#39656 (Behaviour different for agg functions with & without where - ONLY_FULL_GROUP_BY): Fixed in 5.0.74
Bug#39793 (Foreign keys not constructed when column has a '#' in a comment or default value): Fixed in 5.0.83
Bug#39918 (memory (heap) engine crashing with b-tree index and DELETE with seg fault): Fixed in 5.0.83
Bug#40264 (Aborted cached query causes query to hang indefinitely on next cache hit): Fixed in 5.0.78
Bug#40345 (MySQLDump prefixes view name with database name when view references other db): Fixed in 5.0.79
Bug#40845 (Win inst shows screens with wrong naming "MySQL Monitoring and Advisory Service"): Fixed in 5.0.78
Bug#41078 (With CURSOR_TYPE_READ_ONLY mysql_stmt_fetch() returns short string value.): Fixed in 5.0.79
Bug#41486 (extra character appears in BLOB for every ~40Mb after mysqldump/import ): Fixed in 5.0.80
Bug#41571 (MySQL segfaults after innodb recovery): Fixed in 5.0.79
Bug#41728 (Dropped symbol but no soname change): Fixed in 5.0.88
Bug#42760 (Select doesn't return desired results when we have null values): Fixed in 5.0.90
5.0.68
Bug#21250 (resolve stack traces on x86-64 (AMD64, EM64T): most 64 bit CPUs we see): Fixed in 5.0.25
Bug#28323 (Server crashed in xid cache operations): Fixed in 5.0.72
Bug#38291 (memory corruption and server crash with view/sp/function): Fixed in 5.0.70
Bug#38296 (low memory crash with many conditions in a query): Fixed in 5.0.66sp1, 5.0.68
Bug#38694 (Race condition in replication thread shutdown): Fixed in 5.0.82
Bug#39074 (Binaries do not work on Solaris 10 older than U5): Fixed in 5.0.72
Bug#39616 (Missing quotes from .CSV crashes server): Fixed in 5.0.76
Bug#39953 (Triggers are not working properly with multi table updates): Fixed in 5.0.82
Bug#40925 (Equality propagation takes non indexed attribute): Fixed in 5.0.83
5.0.70
Bug#39002 (crash with insert .. select * from ... on duplicate key update col=default): Fixed in 5.0.70
Bug#39040 (valgrind errors/crash when creating views with binlog logging enabled): Fixed in 5.0.74
Bug#40825 (Error 1356 while selecting from a view with a "HAVING" clause though query works): Fixed in 5.0.83
Bug#41725 (slave crashes when inserting into temporary table after stop/start slave): Fixed in 5.0.83
5.0.72
Bug#37575 (UCASE fails on monthname and dayname): Fixed in 5.0.76
Bug#40565 (Update Query Results in "1 Row Affected" But Should Be "Zero Rows"): Fixed in 5.0.84
Bug#40953 (SELECT query throws "ERROR 1062 (23000): Duplicate entry..." error): Fixed in 5.0.76
Bug#41131 ("Questions" fails to increment - ignores statements instead stored procs): Fixed in 5.0.76
Bug#41725 (slave crashes when inserting into temporary table after stop/start slave): Fixed in 5.0.83
Bug#42014 (Crash, name_const with collate): Fixed in 5.0.78, 5.0.74sp1
Bug#42213 (Check for "stack overrun" doesn't work, server crashes): Fixed in 5.0.87, 5.0.85
Bug#44428 (Cannot recreate instance after clean install (apply security settings fails)): Fixed in 5.0.85
5.0.74
Bug#38479 (valgrind warnings in show table status for innodb tables): Fixed in 5.0.84
Bug#41212 (crash after race condition between merge table and table_cache evictions): Fixed in 5.0.83
Bug#41571 (MySQL segfaults after innodb recovery): Fixed in 5.0.79
Bug#41610 (key_infix_len can be overwritten causing some group by queries to return no rows): Fixed in 5.0.79
Bug#41725 (slave crashes when inserting into temporary table after stop/start slave): Fixed in 5.0.83
Bug#41868 (crash or memory overrun with concat + upper, date_format functions): Fixed in 5.0.79
Bug#41943 (mysqlbinlog.exe crashes if --hexdump option is used): Fixed in 5.0.83
Bug#42419 (Server crash with "Pure virtual method called" on two concurrent connections ): Fixed in 5.0.74sp1, 5.0.79
Bug#42502 (huge memory leak possible with timezone functions): Fixed in 5.0.80
Bug#42760 (Select doesn't return desired results when we have null values): Fixed in 5.0.90
Bug#43254 (SQL_SELECT_LIMIT=0 crashes command line client): Fixed in 5.0.80
5.0.75
5.0.76
Bug#38694 (Race condition in replication thread shutdown): Fixed in 5.0.82
Bug#41868 (crash or memory overrun with concat + upper, date_format functions): Fixed in 5.0.79
Bug#42014 (Crash, name_const with collate): Fixed in 5.0.78, 5.0.74sp1
Bug#42108 (Wrong locking for UPDATE with subqueries leads to broken statement replication): Fixed in 5.0.87
Bug#42419 (Server crash with "Pure virtual method called" on two concurrent connections ): Fixed in 5.0.74sp1, 5.0.79
Bug#46591 (.frm file isn't sync'd with sync_frm enabled for CREATE TABLE...LIKE...): Fixed in 5.0.87
5.0.77
Bug#30525 (Server instance configuration wizard): Fixed in 5.0.85
Bug#37044 (Read overflow in opt_range.cc found during "make test"): Fixed in 5.0.86
Bug#42419 (Server crash with "Pure virtual method called" on two concurrent connections ): Fixed in 5.0.74sp1, 5.0.79
Bug#42635 (mysqldump includes views that were excluded using the --ignore-table option): Fixed in 5.0.80
Bug#44798 (MySQL engine crashes when creating stored procedures with execute_priv=N): Fixed in 5.0.84
5.0.78
5.0.79
Bug#38795 (Automatic search depth and nested join's results in server crash): Fixed in 5.0.78
Bug#41756 (Strange error messages about locks from InnoDB): Fixed in 5.0.87sp1, 5.0.88
Bug#42760 (Select doesn't return desired results when we have null values): Fixed in 5.0.90
Bug#43254 (SQL_SELECT_LIMIT=0 crashes command line client): Fixed in 5.0.80
5.0.80
5.0.81
Bug#44428 (Cannot recreate instance after clean install (apply security settings fails)): Fixed in 5.0.85
Bug#44643 (Non-standard path to Perl in scripts): Fixed in 5.0.84
Bug#44798 (MySQL engine crashes when creating stored procedures with execute_priv=N): Fixed in 5.0.84
Bug#44810 (index merge and order by with low sort_buffer_size crashes server!): Fixed in 5.0.82sp1, 5.0.84
Bug#45236 (large blob inserts from mysqldump fail, possible memory issue ?): Fixed in 5.0.84
Bug#45386 (Wrong query result with MIN function in field list, WHERE and GROUP BY clause): Fixed in 5.0.84
5.0.82
Bug#36995 (valgrind error in remove_const during subquery executions): Fixed in 5.0.84
Bug#38479 (valgrind warnings in show table status for innodb tables): Fixed in 5.0.84
Bug#43612 (crash with explain extended, union, order by): Fixed in 5.0.83
Bug#44767 (invalid memory reads in password() and old_password() functions): Fixed in 5.0.84
Bug#44774 (load_file function produces valgrind warnings): Fixed in 5.0.83
Bug#44792 (valgrind warning when casting from time to time): Fixed in 5.0.83
Bug#44796 (valgrind: too many my_longlong10_to_str_8bit warnings after uncompressed_length): Fixed in 5.0.83
Bug#45010 (invalid memory reads during parsing some strange statements): Fixed in 5.0.85
Bug#45031 (invalid memory reads in my_real_read using protocol compression): Fixed in 5.0.85
Bug#45534 (Vendor name change breaks RPM upgrades): Fixed in 5.0.85
Bug#46791 (Assertion failed:(table-<key_read==0),function unknown function,file sql_base.cc): Fixed in 5.0.87
5.0.83
5.0.84
Bug#41756 (Strange error messages about locks from InnoDB): Fixed in 5.0.87sp1, 5.0.88
Bug#45806 (crash when replacing into a view with a join!): Fixed in 5.0.82sp1, 5.0.84
Bug#46000 (using index called GEN_CLUST_INDEX crashes server): Fixed in 5.0.89
Bug#46075 (Assertion failed: 0, file .\protocol.cc, line 416): Fixed in 5.0.85
Bug#46080 (group_concat(... order by) crashes server when sort_buffer_size cannot allocate): Fixed in 5.0.85
Bug#46216 (License header size differences again): Fixed in 5.0.88
Bug#46385 ([Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted t): Fixed in 5.0.85
Bug#46749 (Segfault in add_key_fields() with outer subquery level field references): Fixed in 5.0.84sp1, 5.0.86
5.0.85
Bug#47780 (crash when comparing GIS items from subquery): Fixed in 5.0.87sp1, 5.0.88
Bug#48131 (crash group by with rollup, distinct, filesort, with temporary tables): Fixed in 5.0.87sp1, 5.0.88
Bug#48458 (simple query tries to allocate enormous amount of memory!): Fixed in 5.0.87sp1, 5.0.89
Bug#48508 (re-execution of prepared statement crashes!): Fixed in 5.0.90, 5.0.87sp1
5.0.86
Bug#34895 ('show procedure status' or 'show function status' + 'flush tables' crashes): Fixed in 5.0.87
Bug#47019 (Assertion failed: 0, file .\rt_mbr.c, line 138 when forcing a spatial index): Fixed in 5.0.87sp1, 5.0.88
Bug#48216 (Replication fails on all slaves after upgrade to 5.0.86 on master): Fixed in 5.0.87sp1, 5.0.88
Bug#48291 (crash with row() operator,select into @var, and subquery returning multiple rows): Fixed in 5.0.87sp1, 5.0.88
Bug#48293 (crash with procedure analyse, view with < 10 columns, having clause...): Fixed in 5.0.87sp1, 5.0.88
Bug#48295 (explain extended crash with subquery and ONLY_FULL_GROUP_BY sql_mode): Fixed in 5.0.91
Bug#48500 (5.0 buffer overflow for ER_UPDATE_INFO, or truncated info message in 5.1): Fixed in 5.0.90
5.0.87
5.0.88
Bug#48472 (Loose index scan inappropriately chosen for some WHERE conditions): Fixed in 5.0.89
Bug#48475 (DISTINCT is ignored with GROUP BY WITH ROLLUP and only const tables): Fixed in 5.0.89
Bug#49465 (valgrind warnings and incorrect live checksum...): Fixed in 5.0.90
Bug#49570 (Assertion failed: !(order-<used & map) on re-execution of prepared statement): Fixed in 5.0.90
5.0.89
5.0.90
Bug#51342 (more xid crashing): Fixed in 5.0.91
5.0.91
