| Showing 1-1000 of 1711 (Edit, Save, CSV, Feed) | Show Next 1000 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 6229 | 2004-10-23 17:26 | 2015-01-27 15:55 | MySQL Server: DML | Closed (3924 days) | S3 | 5.0.2-debug | Linux (SuSE 9.1) | Any | Inconsistent handling of DEFAULT on a NOT NULL column |
| 6980 | 2004-12-03 10:20 | 2014-02-06 14:22 | MySQL Server: DML | Verified (4279 days) | S2 | 4.1.7 | Windows (Windows 2000) | Any | Error 1093 - You can't specify target table for update in FROM |
| 7742 | 2005-01-08 11:06 | 2017-11-11 20:47 | MySQL Server: DML | Verified (4308 days) | S3 | 4.1 + | Linux (Linux Red Hat 9) | Any | You can't reinvoke the same Temporary Table more than once. |
| 8433 | 2005-02-11 2:05 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5693 days) | S3 | 5.0.3-alpha-debug | Linux (SuSE 9.1) | Any | Overflow must be an error |
| 8457 | 2005-02-11 20:41 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5712 days) | S3 | 5.0.3-alpha-debug | Linux (SuSE 9.1) | Any | Precision math: DIV returns incorrect result with large decimal value |
| 8463 | 2005-02-11 23:30 | 2020-05-03 20:45 | MySQL Server: DML | Verified (6235 days) | S3 | 5.0.3-alpha-debug | Linux (SuSE 9.1) | Any | SQRT: Should return an error when argument is negative |
| 10573 | 2005-05-12 8:08 | 2019-02-13 12:26 | MySQL Server: DML | Verified (4288 days) | S2 | 4.1.11/5.6 | Linux (Linux) | Any | BOM(of UTF-8) is not correctly handled by LOAD DATA |
| 11472 | 2005-06-21 0:08 | 2025-05-20 1:39 | MySQL Server: DML | Verified (6218 days) | S2 | 5.0.8/5.5/5.6/5.7 | Any | Any | Triggers not executed following foreign key updates/deletes |
| 14368 | 2005-10-27 1:35 | 2012-05-18 20:19 | MySQL Server: DML | Duplicate (6169 days) | S2 | 5.0.15 | Windows (Windows XP) | Any | UPPER and LOWER functions don't work with DAYNAME |
| 15409 | 2005-12-02 2:41 | 2008-03-14 20:57 | MySQL Server: DML | Closed (6434 days) | S3 | 4.1.17-BK, 4.1.14 | Linux (Linux) | Any | Columns with SET datatype with 64-element sets may not be updated with integers |
| 15936 | 2005-12-22 12:15 | 2011-02-16 23:43 | MySQL Server: DML | Closed (6065 days) | S3 | 4.1.17 | Windows (Windows (32 bit)) | Any | "round" differs on Windows to Unix |
| 17895 | 2006-03-03 12:41 | 2016-01-28 11:01 | MySQL Server: DML | Can't repeat (3558 days) | S3 | 5.0.26-BK, 5.0.18, 5.1.43-bzr | Linux (Linux, Windows) | Any | IN-subselect from DUAL with impossible WHERE erroneously returns true |
| 18913 | 2006-04-09 2:01 | 2018-09-09 20:45 | MySQL Server: DML | Verified (4299 days) | S2 | 5.0.21-BK, 5.0.19,5.7.4 | Any | Any | Physical order of rows in table alters update behavior of unique index |
| 21326 | 2006-07-28 9:26 | 2022-12-04 20:45 | MySQL Server: DML | Verified (5959 days) | S3 | 5.0.25-BK, 5.0.22/5.1BK | Any (any) | Any | Can SELECT from table being updated in a stored function, but can't in subquery |
| 21431 | 2006-08-03 16:17 | 2022-12-04 20:45 | MySQL Server: DML | Verified (6987 days) | S3 | 4.1.22-BK, 5.0-BK | Any | Any | Incomplete support of temporary tables |
| 21840 | 2006-08-25 18:11 | 2008-10-06 10:48 | MySQL Server: DML | Closed (6228 days) | S3 | 5.0/5.1BK | Linux (Linux) | Any | Spurious ER_WARNING_NOT_COMPLETE_ROLLBACK for transactional tables |
| 22106 | 2006-09-08 6:46 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6534 days) | S3 | 5.0.26-BK | Linux (Linux) | Any | can't output to error log file when INNODB happened ERROR1205 |
| 23938 | 2006-11-03 12:53 | 2008-01-30 10:25 | MySQL Server: DML | Closed (6478 days) | S2 | 4.1, 5.0-BK, 5.1-BK | Linux (Linux, RHEL4 AS) | Any | ISNULL on DATE AND CAST AS DATE returns false for null values |
| 24911 | 2006-12-08 13:52 | 2008-02-07 12:45 | MySQL Server: DML | Won't fix (6470 days) | S3 | 4.1.22 | Any | Any | sum with cast as unsigned, wrong result |
| 25430 | 2007-01-05 11:25 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5703 days) | S3 | 5.1.15-BK, 5.1.11-beta, 5.1.23 | Linux (Linux) | Any | variable not found in SELECT @@global.ft_max_word_len; |
| 25620 | 2007-01-15 6:54 | 2020-05-03 20:45 | MySQL Server: DML | Verified (6534 days) | S3 | 5.0.33 | Windows (Windows Server 2003 Web Edition) | Any | Error in ADDTIME function when update more 35 days |
| 27299 | 2007-03-20 18:20 | 2020-05-03 20:45 | MySQL Server: DML | Verified (6534 days) | S3 | 5.0.40-BK, 5.0.19 | Linux (Linux 2.6.9-34.ELsmp) | Any | Multi-table UPDATE does not work properly (IMHO) |
| 27358 | 2007-03-21 20:18 | 2007-10-23 19:48 | MySQL Server: DML | Closed (6577 days) | S3 | 5.0-bk | Linux (linux) | Any | INSERT DELAYED does not honour SQL_MODE of the client |
| 27525 | 2007-03-29 14:53 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5712 days) | S3 | 5.0.33/5.1 | Linux (OpenSuse 10.2) | Any | table not found when using multi-table-deletes with aliases over several databas |
| 27986 | 2007-04-20 15:20 | 2008-04-07 8:36 | MySQL Server: DML | Can't repeat (6410 days) | S3 | 5.0.27, 5.1 | Linux | Any | Long Decimals from sub-queries used in updates give wrong results |
| 28759 | 2007-05-29 22:24 | 2022-09-04 20:45 | MySQL Server: DML | Duplicate (6190 days) | S3 | 5.1.12-beta-community, 5.1 BK, 5.0 BK | Any | Any | lcase and lower |
| 29045 | 2007-06-12 7:38 | 2011-02-16 23:43 | MySQL Server: DML | Can't repeat (5388 days) | S3 | 5.1 | Any | Any | Some inconsistency in using system variables |
| 29757 | 2007-07-12 13:56 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5107 days) | S3 | 5.5 | Any | Any | STRING FUNCTIONS WITH LIMITS |
| 30159 | 2007-07-31 21:46 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6660 days) | S3 | 5.1.21-beta-debug | Linux (SUSE 10 64-bit) | Any | Different results with SELECT FOR UPDATE versus plain SELECT |
| 30234 | 2007-08-03 19:39 | 2009-11-10 18:50 | MySQL Server: DML | Closed (6399 days) | S3 | 5.0.41/5.1/4.1 | Any | Any | Unexpected behavior using DELETE with AS and USING |
| 30402 | 2007-08-14 8:35 | 2014-03-10 14:31 | MySQL Server: DML | Verified (4707 days) | S2 | 5.0.37 Community | Linux (RedHat 9.0) | Any | SELECT count(distinct) from mytable return 0 |
| 30406 | 2007-08-14 12:15 | 2007-08-14 15:32 | MySQL Server: DML | Not a Bug (6647 days) | S1 | mySQL5.0 | Windows | Any | insert into values() where |
| 30419 | 2007-08-14 19:51 | 2007-08-14 20:00 | MySQL Server: DML | Not a Bug (6647 days) | S2 | Any | Any | security flaw in SELECT INTO OUTFILE | |
| 30454 | 2007-08-16 13:49 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6645 days) | S3 | 5.0.26-log/5.1 | Linux (Gentoo kernel 2.6.18-gentoo-r6-nopatch-xxxx-ipv4-32) | Any | 'default_week_format' has no effect on YEARWEEK() as it has on WEEK() |
| 30643 | 2007-08-27 9:19 | 2007-11-19 15:47 | MySQL Server: DML | Not a Bug (6550 days) | S2 | 5.0.27, 4.1, 5.0, 5.1, 5.2 BK | Any (Linux, Windows) | Any | Sql query returning different result sets when called more then once |
| 30776 | 2007-09-03 23:13 | 2007-12-06 16:36 | MySQL Server: DML | Not a Bug (6533 days) | S2 | 4.1, 5.0, 5.1 | Linux (debian 4.0) | Any | MOD function produces incorrect results with string arguments |
| 30787 | 2007-09-04 10:19 | 2008-03-30 19:41 | MySQL Server: DML | Closed (6418 days) | S2 | 5.0.45 | Linux | Any | Wrong aliasing with subselects |
| 30813 | 2007-09-04 23:04 | 2007-10-05 5:19 | MySQL Server: DML | No Feedback (6595 days) | S2 | 5.0.37 | Windows | Any | Foreign Key constraint fails |
| 30886 | 2007-09-07 8:16 | 2018-02-08 22:08 | MySQL Server: DML | Not a Bug (2816 days) | S3 | 5.0.45, 4.1, 5.0, 5.1, 5.2 BK | Any (Linux, Windows XP SP2) | Any | Union returns wrong column type size |
| 31000 | 2007-09-13 12:52 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5840 days) | S2 | 5.0.45 | Windows | Any | Left join using stored function fails with corrupted result |
| 31023 | 2007-09-14 8:12 | 2012-05-18 20:19 | MySQL Server: DML | Duplicate (6616 days) | S1 | 5.0.45 | Any | Any | Bug when using date function on datetime field in the where clause |
| 31063 | 2007-09-17 15:58 | 2007-09-18 11:34 | MySQL Server: DML | Can't repeat (6612 days) | S3 | 5.1.21 | Any | Any | GROUP BY WITH ROLLUP inconsistence with derived tables |
| 31073 | 2007-09-18 2:56 | 2007-09-18 4:32 | MySQL Server: DML | Not a Bug (6612 days) | S3 | 5.0.45-community-nt | Windows (Windows XP) | Any | UPPER() does not work on MD5() function when Inserting |
| 31112 | 2007-09-20 14:41 | 2007-10-29 16:54 | MySQL Server: DML | No Feedback (6571 days) | S5 | Ver 14.7 Distrib 4.1.13, for pc-linux-gn | Linux (pc-linux-gn) | Any | Aliased version of simple query very slow |
| 31186 | 2007-09-25 14:16 | 2007-10-25 16:09 | MySQL Server: DML | No Feedback (6575 days) | S1 | 5.0.37-community-nt | Windows (Server 2003) | Any | Update on Varchar treated as Double (improper type conversions) |
| 31236 | 2007-09-27 12:49 | 2008-03-15 22:37 | MySQL Server: DML | Closed (6433 days) | S3 | 5.1 | Any | Any | Inconsistent division by zero behavior for floating point numbers |
| 31281 | 2007-09-28 15:09 | 2007-10-28 15:24 | MySQL Server: DML | No Feedback (6572 days) | S1 | 5.0.41-community-nt-log | Windows | Any | Group by and subquery issue in 5.0.41-community-nt-log |
| 31368 | 2007-10-03 12:18 | 2007-10-03 16:30 | MySQL Server: DML | Not a Bug (6597 days) | S3 | mysql.exe Ver 14.12 Distrib 5.0.37 | Windows (XPSP2) | Any | before-JOIN word can be virtually any word |
| 31401 | 2007-10-04 16:05 | 2007-11-04 19:06 | MySQL Server: DML | No Feedback (6565 days) | S2 | 5.1.22 | Windows (w2k sp4) | Any | bigint unsigned non-deterministic near wrap values |
| 31451 | 2007-10-08 14:52 | 2007-11-30 23:38 | MySQL Server: DML | Can't repeat (6539 days) | S3 | 5.0.26/5.0BK | Linux (Gentoo) | Any | ERROR 1105 (HY000): Unknown error on a simple SELECT statement |
| 31472 | 2007-10-09 8:59 | 2012-05-18 20:19 | MySQL Server: DML | Duplicate (6474 days) | S3 | 5.0.50 | Any | Any | multi_update crashes at assert about trans_safe |
| 31634 | 2007-10-16 11:55 | 2018-02-08 21:54 | MySQL Server: DML | Won't fix (2816 days) | S3 | 5.1.21 | Any | Any | procedure analyse won't work |
| 31732 | 2007-10-21 1:14 | 2020-05-03 20:45 | MySQL Server: DML | Verified (6528 days) | S2 | 5.0.45 | Linux (SuSE 10.3 x86_64) | Any | row count(*) overflows after 32-bit integer precision in spite of being bigint |
| 31734 | 2007-10-21 10:45 | 2007-10-21 13:37 | MySQL Server: DML | Not a Bug (6579 days) | S3 | 5.0.45 and 5.1.22 | Linux | Any | Server hangs during large LOAD DATA |
| 31776 | 2007-10-23 8:19 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6576 days) | S3 | 5.0.45, 4.1, 5.0, 5.1, 5.2 BK | Any (Linux, Microsoft Windows XP SP2) | Any | CAST AS CHAR with SELECT DISTINCT |
| 31781 | 2007-10-23 10:57 | 2008-04-10 14:08 | MySQL Server: DML | Closed (6407 days) | S3 | 4.1,5.0 | Windows | Any | multi-table UPDATE with temp-pool enabled fails with errno 17 |
| 31811 | 2007-10-24 10:14 | 2007-10-24 18:09 | MySQL Server: DML | Not a Bug (6576 days) | S3 | 5.0.45 | Any | Any | outer aliases are not supported in subqueries |
| 31835 | 2007-10-25 7:55 | 2007-10-25 9:42 | MySQL Server: DML | Duplicate (6575 days) | S2 | MySQL Server 4.0 | Any | Any | Incorrect handling of dates when used in an IN condition in the WHERE clause |
| 31906 | 2007-10-29 10:22 | 2007-10-29 11:10 | MySQL Server: DML | Not a Bug (6571 days) | S3 | Any | Any | No stmt rollback and wrong binlog if an error in {INSERT|CREATE} ... SELECT UNIO | |
| 31971 | 2007-10-30 23:08 | 2019-10-29 22:33 | MySQL Server: DML | Can't repeat (2188 days) | S3 | 5.0.51 and 5.0.45 | Any (Debian, FreeBSD) | Any | last_insert_id with on duplicate key still broken |
| 32030 | 2007-11-01 12:55 | 2007-12-14 19:47 | MySQL Server: DML | Closed (6525 days) | S3 | Any | Any | DELETE does not return an error and deletes rows if error evaluating WHERE | |
| 32045 | 2007-11-02 5:53 | 2007-11-02 8:11 | MySQL Server: DML | Duplicate (6567 days) | S2 | 5.0.45-Debian_1ubuntu3-log | Linux (ubuntu 7.10) | Any | sec_to_time returns wrong values |
| 32145 | 2007-11-06 13:49 | 2007-11-06 15:39 | MySQL Server: DML | Not a Bug (6563 days) | S1 | 5.0.37-community-nt | Windows (XP professional) | Any | Error while executing Select query |
| 32345 | 2007-11-13 20:23 | 2012-05-18 20:19 | MySQL Server: DML | No Feedback (6386 days) | S3 | 6.0 | Any | Any | Server; mysql_update() compares too much for NULL fields |
| 32482 | 2007-11-18 17:45 | 2008-01-14 19:09 | MySQL Server: DML | Closed (6494 days) | S2 | 5.1.22-rc-log | Linux | Any | crash with GROUP BY alias_of_user_variable WITH ROLLUP |
| 32800 | 2007-11-28 7:43 | 2007-11-28 12:20 | MySQL Server: DML | Not a Bug (6541 days) | S2 | 5.0.45 and 5.0.32 | Any | Any | Umlaut in WHERE filters incorrectly |
| 32917 | 2007-12-02 22:41 | 2015-02-12 13:05 | MySQL Server: DML | Closed (3988 days) | S2 | 5.0.50 | Any | Any | detect orphan temp-pool files, and handle gracefully |
| 33032 | 2007-12-06 10:06 | 2007-12-07 15:35 | MySQL Server: DML | Not a Bug (6532 days) | S3 | 5.0.45-community-nt | Any | Any | Incorrect result with UNION and user-defined variables |
| 33066 | 2007-12-07 16:33 | 2007-12-25 14:06 | MySQL Server: DML | Not a Bug (6514 days) | S3 | 5.1.22-rc | Any | Any | last_insert_id(), wrong values, InnoDB, insert on duplicate key update |
| 33087 | 2007-12-08 17:22 | 2017-12-31 0:12 | MySQL Server: DML | Not a Bug (6520 days) | S3 | 5.0.45, 5.0.52, 5.1.22 | Any | Any | DISTINCT with ORDER BY and LIMIT returns incorrect results |
| 33088 | 2007-12-08 18:04 | 2007-12-08 18:43 | MySQL Server: DML | Can't repeat (6531 days) | S2 | Ver 14.12 Distrib 5.0.44, for pc-linux-g | Any | Any | SELECT query with a definite WHERE clause stops returning rows after NULL value |
| 33131 | 2007-12-11 7:14 | 2008-01-11 7:44 | MySQL Server: DML | No Feedback (6497 days) | S3 | 5.0.45-log | Linux (2.6.9-5.EL) | Any | problem with update query |
| 33138 | 2007-12-11 13:20 | 2018-02-08 22:20 | MySQL Server: DML | Won't fix (2816 days) | S3 | 5.1 | Any | Any | procedure analyse is not aware of cluster 4 byte align types |
| 33169 | 2007-12-12 15:40 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6527 days) | S3 | 5.1.22 | Windows | Any | mysqld --help : lowercase_table-name bad advice |
| 33254 | 2007-12-14 22:56 | 2007-12-16 19:01 | MySQL Server: DML | Not a Bug (6523 days) | S1 | mysql 5.0.27 | FreeBSD (6.2) | Any | Invalid query: Unknown column 'column_id' in 'on clause' |
| 33259 | 2007-12-15 9:53 | 2007-12-16 4:16 | MySQL Server: DML | Not a Bug (6523 days) | S2 | MySQL 5.1 | Windows | Any | str_to_date conversion of date format 'dd-mmm-yy' to 'yyyy-mm-dd' |
| 33304 | 2007-12-17 23:50 | 2008-03-27 19:29 | MySQL Server: DML | Closed (6421 days) | S3 | 5.0.54 | MacOS (10.4 PowerPC 64-bit) | Any | Test 'func_group' hangs on Mac OS X 10.4 PowerPC 64-bit |
| 33389 | 2007-12-20 4:52 | 2008-03-14 22:18 | MySQL Server: DML | Closed (6434 days) | S1 | 5.0.54, 5.0.52, 5.1.22 | Any (Windows, Linux, 32 or 64 bit) | Any | Selecting from a view into a table from within SP or trigger crashes server |
| 33396 | 2007-12-20 10:07 | 2018-04-11 12:17 | MySQL Server: DML | Won't fix (2754 days) | S3 | 5.1 | Linux (Suse 10.1) | Any | duplicate value in set leads to warning 1291, which not shown with ps-protocol |
| 33495 | 2007-12-24 3:17 | 2007-12-24 4:29 | MySQL Server: DML | Duplicate (6515 days) | S3 | Any | Any | Error Insert data in version 5.1.20 | |
| 33629 | 2008-01-02 15:46 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5826 days) | S3 | 5.0.52, 5.1.23, 6.0.3 | Any | Any | last_day function can return null, but has 'not null' flag set for result |
| 33647 | 2008-01-03 10:16 | 2013-05-16 6:10 | MySQL Server: DML | Not a Bug (4545 days) | S3 | 5.1.22 | Any | Any | WITH ROLLUP fails when using subqueries |
| 33699 | 2008-01-04 21:30 | 2008-01-28 18:09 | MySQL Server: DML | Closed (6480 days) | S3 | 5.1, 6.0 | Any | Any | UPDATE allows NULL as new value on NOT NULL columns (= default datatype value) |
| 33717 | 2008-01-07 2:52 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5608 days) | S3 | 5.0+ | Any | Any | INSERT...(default) fails for enum. Crashes CSV tables, loads spaces for MyISAM |
| 33764 | 2008-01-09 12:02 | 2008-03-15 8:11 | MySQL Server: DML | Closed (6433 days) | S3 | 5.0+ | Linux | Any | Wrong result with IN(), CONCAT() and implicit type conversion |
| 33811 | 2008-01-10 23:07 | 2011-02-16 23:43 | MySQL Server: DML | Closed (6192 days) | S3 | 5.0/5.1/6.0 | Any | Any | Call to stored procedure with SELECT * / RIGHT JOIN fails after the first time |
| 33844 | 2008-01-13 13:26 | 2012-05-18 20:19 | MySQL Server: DML | No Feedback (5557 days) | S3 | 5.1.23, 5.1.48 | Any | Any | Server crashes when client dies during LOAD DATA INFILE |
| 33847 | 2008-01-13 16:40 | 2008-01-14 5:20 | MySQL Server: DML | Not a Bug (6494 days) | S3 | 5.0.45 | Any | Any | The character '-' in a table name causes problems |
| 33969 | 2008-01-21 23:28 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5712 days) | S3 | 5.1.22-rc-community | Other (UBUNTU (64Bit), FreeBSD (64bit), RedHat) | Any | Updating a text field via a left join |
| 33992 | 2008-01-22 20:19 | 2008-01-22 21:19 | MySQL Server: DML | Not a Bug (6486 days) | S3 | 5.0.45 | Any | Any | Date column not named in update statement is set to current date |
| 34214 | 2008-02-01 4:47 | 2008-02-01 5:54 | MySQL Server: DML | Not a Bug (6476 days) | S1 | 5.0.27-log | Linux | Any | Unexpected ERROR 1292 (22007) error in strict mode for 2007-03-11 |
| 34314 | 2008-02-05 17:22 | 2022-09-04 20:45 | MySQL Server: DML | Duplicate (6435 days) | S3 | all | Any | Any | System variables in SHOW VARIABLES not selectable with SELECT |
| 34374 | 2008-02-07 9:31 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5826 days) | S3 | 5.0.54a, 5.0, 5.1, 6.0 BK | Linux | Any | mysql generates incorrect warning |
| 34384 | 2008-02-07 16:45 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5497 days) | S3 | 5.0.45, 5.1.22, 5.0.54 | Any | Any | Big quoted int in WHERE of UPDATE or DELETE causes drop in performance |
| 34512 | 2008-02-13 5:13 | 2008-04-12 2:58 | MySQL Server: DML | Closed (6405 days) | S3 | 5.0.51a-community-nt, 5.0.54 | Any | Any | CAST( AVG( double ) AS DECIMAL ) returns wrong results |
| 34594 | 2008-02-15 13:10 | 2018-02-08 22:37 | MySQL Server: DML | Won't fix (2816 days) | S3 | 5.0.56, 5.0.66a | Any | Any | 'handler open' can refer to outdated table names until flush tables is executed |
| 34608 | 2008-02-15 18:43 | 2019-10-30 21:14 | MySQL Server: DML | Not a Bug (2187 days) | S3 | 4.1, 5.0, 5,1, 6.0 bzr | Any (Linux, MS Windows) | Any | unfair subselect |
| 34620 | 2008-02-16 17:16 | 2008-03-15 8:41 | MySQL Server: DML | Closed (6433 days) | S3 | 5.0+, 5.0.58-BK | Any | Any | item_row.cc:50: Item_row::illegal_method_call(const char*): Assertion `0' failed |
| 34731 | 2008-02-21 15:30 | 2008-04-07 17:30 | MySQL Server: DML | Closed (6410 days) | S2 | 5.0.51a, 5.0.54, 5.1.23 | Windows (probably any) | Any | highest possible value for INT erroneously filtered by WHERE |
| 34751 | 2008-02-21 22:19 | 2018-02-08 22:42 | MySQL Server: DML | Closed (2816 days) | S3 | 5.0+ | Any | Any | Inside HAVING clause subqueries with aggregates and without GROUP BY rise error |
| 34755 | 2008-02-22 8:06 | 2008-02-22 9:41 | MySQL Server: DML | Not a Bug (6455 days) | S2 | 5.0.45 SUSE MySQL RPM and 5.0.51a-commun | Linux (opensuse 10.3) | Any | error in select statement with joins - unknown column |
| 34782 | 2008-02-24 9:46 | 2008-02-27 17:20 | MySQL Server: DML | Not a Bug (6450 days) | S2 | 5.0.32-Debian_7etch1-log | Linux (Debian) | Any | CONCAT() fails when longblobs length's are bigger than max_allowed_packet |
| 34829 | 2008-02-26 12:19 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5703 days) | S3 | 5.1.22, 5.0.56 | Windows | Any | No default value for variable and setting default does not raise error |
| 34834 | 2008-02-26 12:47 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5703 days) | S3 | 5.1.22, 5.1.24-BK, 5.0.56 | Any | Any | ? Is accepted as a valid sql mode |
| 34850 | 2008-02-26 16:58 | 2008-05-31 14:05 | MySQL Server: DML | Can't repeat (6356 days) | S1 | 5.0.32-Debian_7etch3-log | Linux (Debian 4.0 Etch.) | Any | UPDATE query with SET date_updated=NOW() intermittently setting other DATETIMEs |
| 34874 | 2008-02-27 9:47 | 2018-02-08 22:50 | MySQL Server: DML | Closed (2816 days) | S3 | 5.0+ | Any | Any | Wrong result with IN(SELECT aggregate FROM DUAL) |
| 34878 | 2008-02-27 10:53 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5702 days) | S3 | 5.1.22, 5.1.23 | Any | Any | Few variables have default value according to documentation but error occurs |
| 34883 | 2008-02-27 11:14 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5702 days) | S3 | 5.1.23 | Any | Any | ft_boolean_syntax cant be assigned from user variable to global var. |
| 34898 | 2008-02-27 17:44 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5826 days) | S3 | 5.0, 5.1, 4.1 | Any | Any | mysql_info() reports 0 warnings while mysql_warning_count() reports 1 |
| 34945 | 2008-02-28 22:53 | 2008-03-15 8:59 | MySQL Server: DML | Closed (6433 days) | S2 | 5.0, 5.1, 6.0 BK | Any (All) | Any | ref_or_null queries that are null_rejecting and have a null value crash mysql |
| 34949 | 2008-02-29 3:23 | 2008-05-30 19:14 | MySQL Server: DML | Closed (6357 days) | S2 | 4.1.22 | Any | Any | Passing invalid parameter to CHAR() in an ORDER BY causes MySQL to hang |
| 34966 | 2008-02-29 22:45 | 2008-03-05 20:39 | MySQL Server: DML | Not a Bug (6443 days) | S2 | 5.0.45 | Linux (debian) | Any | Problems with LOAD_FILE |
| 35002 | 2008-03-03 14:17 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6444 days) | S2 | 5.1.23-rc/5.1BK/5.0/6.0 | Linux (2.6.22.9-61.fc6) | Any | Wrong results returned when using derived table and group by |
| 35242 | 2008-03-12 10:29 | 2020-01-22 4:38 | MySQL Server: DML | Closed (2103 days) | S2 | 5.0.45 and 5.0.51a, 5.0, 5.1, 6.0 BK | Any (and windows) | Any | ERROR 1054 (42S22): Unknown column 't2.i2' in 'on clause' |
| 35355 | 2008-03-17 23:14 | 2012-10-16 4:40 | MySQL Server: DML | Closed (4757 days) | S2 | 5.0 | Any | Any | Support explain for update and delete statements |
| 35362 | 2008-03-18 6:08 | 2008-03-20 21:10 | MySQL Server: DML | Not a Bug (6428 days) | S2 | 5.1.22, 5.0, 5.1, 6.0 BK | Any (MS Windows, Linux) | Any | Auto_Increment_Increment looses its value on switching connections & values |
| 35374 | 2008-03-18 7:19 | 2008-03-24 16:20 | MySQL Server: DML | Not a Bug (6424 days) | S3 | 5.1.22, 5.1.23 | Windows | Any | div_precision_increment is not working with table’s column |
| 35376 | 2008-03-18 7:31 | 2008-05-08 16:34 | MySQL Server: DML | Not a Bug (6379 days) | S3 | 5.1.22 | Any | Any | Value of insert_id automatically resets to 0 after inserting 1st row |
| 35386 | 2008-03-18 9:39 | 2014-09-17 4:39 | MySQL Server: DML | Won't fix (4056 days) | S3 | 5.1.22 | Any | Any | Insert delayed statements insert 1 + limit records instead of just limit records |
| 35392 | 2008-03-18 12:03 | 2008-04-07 17:26 | MySQL Server: DML | Closed (6410 days) | S2 | 5.1.22/5.1/6.0 | Windows | Any | Delete all statement does not execute properly after few delete statements |
| 35461 | 2008-03-20 15:19 | 2015-05-26 12:49 | MySQL Server: DML | Not a Bug (6428 days) | S3 | mysql-6.0-backup | Linux | Any | Not able to insert '\' character. |
| 35478 | 2008-03-21 11:21 | 2011-02-16 23:43 | MySQL Server: DML | Closed (6298 days) | S3 | 5.0-bk | Any | Any | sort_union() returns bad data when sort_buffer_size is hit |
| 35514 | 2008-03-24 16:26 | 2011-02-16 23:43 | MySQL Server: DML | Closed (6169 days) | S2 | 6.0-falcon-team | Any | Any | Item_func_uuid::val_str(String*): Assertion `tv > uuid_time' failed. |
| 35608 | 2008-03-27 14:12 | 2008-03-28 13:37 | MySQL Server: DML | Not a Bug (6420 days) | S1 | 5.1.23a-maria-alpha-log | Any | Any | changed NOT NULL handling breaks replication in 5.1 |
| 35703 | 2008-03-31 11:03 | 2008-05-02 20:51 | MySQL Server: DML | No Feedback (6385 days) | S3 | Any | Any | Max_delayed_thread does not make delayed insert threads as normal insert | |
| 35706 | 2008-03-31 12:12 | 2008-04-30 12:24 | MySQL Server: DML | No Feedback (6387 days) | S3 | 5.1.22 | Linux | Any | Default value of flush_time is Null in SUSE whereas 1 in all other OS's |
| 35766 | 2008-04-02 10:05 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6415 days) | S3 | 5.1.22, 4.1, 5.0, 5.1, 6.0 BK | Linux (Mandriva 2008 ) | Any | LOAD OPTIONALLY ENCLOSED BY prematurly terminates |
| 35815 | 2008-04-03 20:14 | 2008-04-03 23:41 | MySQL Server: DML | Duplicate (6414 days) | S2 | 5.0.51a | Windows ( 5.0.51a-community-nt) | Any | Error 1292 when inserting particular date into timestamp field |
| 35993 | 2008-04-11 12:26 | 2008-05-13 20:04 | MySQL Server: DML | Closed (6374 days) | S1 | 4.1.22, 5.1.24, 5.0.58 | Any | Any | severe memory corruption and crash with multibyte conversion |
| 36023 | 2008-04-13 10:27 | 2008-05-13 20:15 | MySQL Server: DML | Closed (6374 days) | S1 | 5.0.58, 5.1.24 | Any | Any | crash/huge memory alloc with max and case when if statement |
| 36061 | 2008-04-14 14:52 | 2008-04-15 3:40 | MySQL Server: DML | Not a Bug (6402 days) | S3 | 5.0.22 | Linux (CentOS 5) | Any | DATETIME math inaccuracies |
| 36084 | 2008-04-15 8:34 | 2012-05-18 20:19 | MySQL Server: DML | Duplicate (6402 days) | S3 | 5.0.58 | Any | Any | name_const with negative, subquery, group by causes crash |
| 36091 | 2008-04-15 12:41 | 2008-04-18 8:59 | MySQL Server: DML | Not a Bug (6399 days) | S3 | 5.1+ | Windows | Any | Fix for bug #31781 is broken in 5.1/6.0 |
| 36111 | 2008-04-16 5:48 | 2008-05-01 3:46 | MySQL Server: DML | Not a Bug (6386 days) | S2 | 5.0.41 | Windows (XP) | Any | SQL Query returns wrong reults |
| 36128 | 2008-04-16 10:33 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5453 days) | S2 | 6.0.4-nt, 6.0.5-bk | Any | Any | not in subquery causes crash in cleanup.. |
| 36135 | 2008-04-16 11:56 | 2008-09-16 4:23 | MySQL Server: DML | Closed (6248 days) | S3 | 5.1-bk6.0.5-bk | Any | Any | void Diagnostics_area::set_eof_status(THD*): Assertion `! is_set()' failed. |
| 36138 | 2008-04-16 13:21 | 2008-04-25 12:06 | MySQL Server: DML | Not a Bug (6392 days) | S1 | 5.0.45 | Any | Any | SELECT with LEFT JOIN and aggregate function returns incorrect results |
| 36142 | 2008-04-16 15:31 | 2008-05-30 7:51 | MySQL Server: DML | Can't repeat (6357 days) | S2 | 6.0.5-debug-bk | Linux | Any | double free/memory corruption errors on cleanup of join |
| 36508 | 2008-05-05 15:15 | 2008-05-06 16:45 | MySQL Server: DML | Not a Bug (6381 days) | S2 | 5.1.24 | Any | Any | inserting null value to not null column with default value explicitly defined |
| 36676 | 2008-05-12 22:05 | 2016-02-25 12:24 | MySQL Server: DML | Closed (6365 days) | S2 | 5.0.58 | Any | Any | UPDATE on TEXT column using LEFT JOIN doesn't update all rows |
| 36693 | 2008-05-13 15:43 | 2011-02-16 23:43 | MySQL Server: DML | Can't repeat (5651 days) | S1 | 5.0.66a,5.1.24 | Any | Any | stored procedure, derived table crash |
| 36698 | 2008-05-13 19:57 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6367 days) | S3 | 5.0.60/5.1BK | Any | Any | ROW_COUNT() is reset inconsistently |
| 36704 | 2008-05-14 0:24 | 2011-02-16 23:43 | MySQL Server: DML | Can't repeat (5597 days) | S1 | 5.1.24, 5.1.26, 5.1.30 | Any | Any | multi-table update with derived tables cause crash |
| 36738 | 2008-05-15 16:37 | 2012-05-18 20:19 | MySQL Server: DML | Duplicate (6372 days) | S1 | 4.1, 5.0, 5.1, 6.0 BK | Any (Linux) | Any | having + fulltext crashes MySQL server |
| 36760 | 2008-05-16 15:31 | 2008-05-17 19:07 | MySQL Server: DML | Not a Bug (6370 days) | S2 | 5.0.45 MySQL Community Server | Any | Any | from_unixtime rounds fractional seconds |
| 36791 | 2008-05-19 1:10 | 2008-06-19 16:45 | MySQL Server: DML | No Feedback (6337 days) | S2 | 5.1.23 | Windows | Any | Error trying to get Column Names |
| 36898 | 2008-05-22 22:24 | 2008-05-25 10:04 | MySQL Server: DML | Not a Bug (6362 days) | S3 | 5.0.51 | Any | Any | INSERT ... ON DUPLICATE KEY UPDATE seem to compute wrong, if a new row is insert |
| 36939 | 2008-05-24 20:40 | 2008-05-25 0:00 | MySQL Server: DML | Closed (6362 days) | S3 | 5.0.51b | Windows | Any | Multiple-table DELETE syntax worked in 5.0.45 but doesn't work in 5.0.51b |
| 36958 | 2008-05-26 12:19 | 2008-07-02 20:04 | MySQL Server: DML | No Feedback (6324 days) | S2 | 5.0.22 | Windows | Any | left join on small size index |
| 36983 | 2008-05-26 15:34 | 2008-09-22 16:38 | MySQL Server: DML | Can't repeat (6242 days) | S1 | 5.1.26bk | Any | Any | stack corruption and crash with des_encrypt crashes on invalid inputs |
| 37013 | 2008-05-27 18:06 | 2018-02-08 23:00 | MySQL Server: DML | Closed (2816 days) | S3 | 5.0.22,5.0.54, 5.0, 5.1, 6.0 BK | Linux (CentOS5, Gentoo2008) | Any | CONDITION NOT MET IN VALID SQL STATEMENT |
| 37055 | 2008-05-29 6:09 | 2008-06-30 15:29 | MySQL Server: DML | No Feedback (6326 days) | S2 | 5.0.18 | Linux | Any | sub query with in condition takes long time and it hangs |
| 37106 | 2008-05-30 16:43 | 2008-05-31 17:05 | MySQL Server: DML | Not a Bug (6356 days) | S3 | 5.0.22 | Linux (Debian_0ubuntu6.06.9) | Any | SELECT (datetimeB - datetimeA) |
| 37183 | 2008-06-04 8:15 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5706 days) | S3 | 4.1.22, 5.0.64, 5.1.26, 6.0.6 | Any | Any | insert ignore into .. select ... hangs after deadlock was encountered |
| 37240 | 2008-06-06 9:33 | 2008-06-10 2:37 | MySQL Server: DML | Not a Bug (6346 days) | S5 | 5.0.38 | Linux (ubuntu 7.0.4) | Any | Is this a bug here? |
| 37289 | 2008-06-09 16:58 | 2011-02-16 23:43 | MySQL Server: DML | Won't fix (6198 days) | S3 | 5.0.22,5.1.22 | Any | Any | TIMESTAMP field DEFAULT value fails to apply depending on situation. |
| 37401 | 2008-06-13 18:43 | 2019-10-30 22:07 | MySQL Server: DML | Can't repeat (2187 days) | S3 | 5.0.54,5.1.24, 5.0, 5.1, 6.0 bzr | Any | Any | One Item_sum constructor does not initialize quick_group. All others do. |
| 37484 | 2008-06-18 16:43 | 2008-06-18 20:49 | MySQL Server: DML | Not a Bug (6338 days) | S2 | 5.0 | Any | Any | C-style comments not ignored within character literals |
| 37548 | 2008-06-20 15:40 | 2008-09-16 4:24 | MySQL Server: DML | Closed (6248 days) | S1 | 5.1.23 and up, 5.1, 6.0 bzr | Any | Any | result value erronously reported being NULL in certain subqueries |
| 37730 | 2008-06-29 22:13 | 2008-07-14 21:05 | MySQL Server: DML | Won't fix (6312 days) | S3 | 5.0.62 | Any | Any | select from where in returns incorrect results |
| 37735 | 2008-06-30 8:40 | 2008-06-30 15:24 | MySQL Server: DML | Not a Bug (6326 days) | S2 | 5.1, 5.0, 4.1, 6.0 BZR | Any | Any | WHERE clause fails immediately following INSERT on AUTO INCREMENT column |
| 38072 | 2008-07-12 17:28 | 2008-11-10 18:20 | MySQL Server: DML | Closed (6193 days) | S3 | 6.0, 5.1, 5.0 bzr | Any | Any | Wrong result: HAVING not observed in a query with aggregate |
| 38091 | 2008-07-14 5:14 | 2008-08-07 4:19 | MySQL Server: DML | Not a Bug (6288 days) | S3 | 5.1.23 | Windows (Vista Enterprise) | Any | LOAD DATA LOCAL INFILE using source column references loads sequential columns |
| 38215 | 2008-07-17 20:55 | 2011-02-16 23:43 | MySQL Server: DML | Can't repeat (5910 days) | S3 | 5.0.67 | FreeBSD | Any | Query fails to return correct info from table |
| 38489 | 2008-07-31 12:27 | 2018-02-08 23:10 | MySQL Server: DML | Closed (2816 days) | S3 | 5.0, 5.1 | Any | Any | EXPLAIN EXTENDED SELECT generates invalid query |
| 38637 | 2008-08-07 18:35 | 2011-02-16 23:43 | MySQL Server: DML | Closed (6100 days) | S2 | 5.0.51, 5.1.28, 5.0.66a | Any | Any | COUNT DISTINCT prevents NULL testing in HAVING clause |
| 38693 | 2008-08-09 17:31 | 2008-11-10 18:22 | MySQL Server: DML | Closed (6193 days) | S2 | 5.0.66a, 5.1.26, 5.1.28, 6.0.7 | Any | Any | leaked memory with blobs! |
| 38749 | 2008-08-12 11:39 | 2008-08-13 18:29 | MySQL Server: DML | Not a Bug (6282 days) | S1 | 5.0.51a-6 | Linux (debian lenny) | Any | Duplicate error on INSERT - primary key auto increment column |
| 38767 | 2008-08-13 11:50 | 2008-09-13 15:16 | MySQL Server: DML | No Feedback (6251 days) | S1 | 5.0.67 | MacOS (10.5.1 leopard) | Any | combination of 'ORDER BY' and 'LIMIT' yields incorrect output |
| 38809 | 2008-08-14 19:36 | 2008-08-16 5:39 | MySQL Server: DML | Not a Bug (6279 days) | S3 | MySQL 5.1.26-rc-community | Any | Any | A multitable update query is run more than once for each matching row |
| 38928 | 2008-08-20 21:58 | 2008-08-20 22:52 | MySQL Server: DML | Not a Bug (6275 days) | S2 | 5.0.67-community-nt | Windows (XP SP2) | Any | select ... count(*) not enforcing group by clause when obtaining other fields |
| 38999 | 2008-08-25 9:17 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5490 days) | S3 | 5.0.44, 5.0.66a, 5.0.70, 5.0.74,5.0.76 | Linux | Any | valgrind warnings for update statement in function compare_record() |
| 39002 | 2008-08-25 11:32 | 2008-10-17 18:14 | MySQL Server: DML | Closed (6217 days) | S1 | 5.0.42, 5.0.66a, 5.0.70, 5.1.28, 6.0.5 | Any | Any | crash with insert .. select * from ... on duplicate key update col=default |
| 39046 | 2008-08-26 15:30 | 2008-08-26 19:19 | MySQL Server: DML | Closed (6269 days) | S3 | 5.1.26 | Windows | Any | "not in" returns empty set when subquery result is large |
| 39079 | 2008-08-27 19:13 | 2011-02-16 23:43 | MySQL Server: DML | Verified (6268 days) | S3 | 5.x, 6.x | Any (Mac OSX, Linux) | Any | Truncating incorrect DECIMAL value at the wrong place |
| 39169 | 2008-09-01 22:17 | 2008-10-10 8:06 | MySQL Server: DML | No Feedback (6224 days) | S1 | 6.0.4alpha, 6.0.6alpha | Windows (Windows XP Home) | Any | Unexpected behaviour when using GROUP BY and/or WHERE clauses |
| 39201 | 2008-09-02 21:22 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6261 days) | S3 | 5.1.26-rc, 4.1, 5.0, 5.1, 6.0 bzr | Linux (2.6.24.5-smp) | Any | INTO OUTFILE Statement |
| 39247 | 2008-09-04 15:05 | 2015-06-02 13:36 | MySQL Server: DML | Verified (6249 days) | S3 | 5.0.67, 5.0, 5.1, 6.0 bzr | Any (MS Windows 5.0.2195, Linux) | Any | LOAD DATA INFILE skips too many rows |
| 39274 | 2008-09-05 13:15 | 2020-03-10 11:05 | MySQL Server: DML | Won't fix (2184 days) | S2 | 5.0.66a, 5.1.26, 5.1.27-ndb-6.3.17 | Any | Any | SELECT on PK with ROUND(RAND()) give wrong errors |
| 39423 | 2008-09-12 16:35 | 2012-05-18 20:19 | MySQL Server: DML | Duplicate (6204 days) | S3 | 5.0.67-community, 5.0, 5.1, 6.0 bzr | Linux (x86_64 GNU/Linux CentOS) | Any | comparison of NULL datetime column side-effected in trigger body are incorrect |
| 39505 | 2008-09-17 21:55 | 2017-03-17 17:18 | MySQL Server: DML | No Feedback (6217 days) | S2 | 5.1.28 | Windows | Any | ERROR 1292 (22007): Incorrect datetime value |
| 39543 | 2008-09-19 16:56 | 2018-02-10 16:42 | MySQL Server: DML | Closed (2814 days) | S3 | 5.0.67/5.1/6.0 | Linux (debian 4.0) | Any | Group by with case and lpad inside concat truncates values |
| 39615 | 2008-09-23 18:54 | 2008-10-13 18:51 | MySQL Server: DML | Not a Bug (6221 days) | S2 | 5.0.67, 4.1, 5.0, 5.1, 6.0 bzr | Any (MS Windows, Linux) | Any | WITH Rollup fails |
| 39656 | 2008-09-26 2:15 | 2011-02-16 23:43 | MySQL Server: DML | Closed (6165 days) | S1 | 5.0.67, 5.1.28 | Any (Windows XP, Fedora 9) | Any | Behaviour different for agg functions with & without where - ONLY_FULL_GROUP_BY |
| 39828 | 2008-10-03 4:54 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5402 days) | S2 | 5.1.28, 5.1.48, 6.0.6 | Any | Any | autoinc wraps around when offset and increment > 1 |
| 39832 | 2008-10-03 8:05 | 2008-10-03 8:43 | MySQL Server: DML | Not a Bug (6231 days) | S3 | 5.0.24a | Linux (Redhat ES$) | Any | Inconsistents when doing SELECTS using session variables in IN() clause |
| 39860 | 2008-10-04 14:09 | 2008-10-05 17:53 | MySQL Server: DML | Not a Bug (6229 days) | S3 | mysql5.1.25 | Windows | Any | How to update |
| 39883 | 2008-10-06 14:22 | 2008-10-07 12:07 | MySQL Server: DML | Not a Bug (6227 days) | S2 | 5.0.51a / 5.0.67 | Linux (opensuse 11.0) | Any | Performance problem with stored function in where clause |
| 39920 | 2008-10-08 7:07 | 2011-02-16 23:43 | MySQL Server: DML | Closed (6162 days) | S3 | 5.0.x | Linux | Any | MySQL cannot deal with Leap Second expression in string literal. |
| 39970 | 2008-10-10 9:37 | 2008-10-16 11:00 | MySQL Server: DML | Not a Bug (6218 days) | S2 | 5.0.51a, 4.1, 5.0, 5.1, 6.0 bzr | Any (Linux, MS WindowsW2K3 community edition) | Any | count distinct reports zero |
| 40052 | 2008-10-15 14:46 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6219 days) | S3 | Any | Any | SQL_NO_STRICT: per-query way to disable strict mode | |
| 40067 | 2008-10-15 20:02 | 2008-10-16 6:33 | MySQL Server: DML | Duplicate (6218 days) | S2 | 5.0.51a | Any | Any | Query on decimal column returns no value |
| 40125 | 2008-10-18 11:51 | 2008-10-20 10:38 | MySQL Server: DML | Not a Bug (6214 days) | S1 | 5.0.51, 4.1, 5.0, 5.1, 6.0 bzr | Any | Any | Serious error while updating a record from a table! You will over write all! |
| 40127 | 2008-10-18 15:27 | 2011-02-16 23:43 | MySQL Server: DML | Closed (6009 days) | S2 | 5.0.67, 5.0, 5.1, 6.0 bzr | Linux | Any | Multiple table DELETE IGNORE hangs on foreign key constraint violation on 5.0 |
| 40217 | 2008-10-21 18:03 | 2018-02-10 16:58 | MySQL Server: DML | Closed (2814 days) | S3 | 5.0, 5.1.28, 5.1, 6.0 bzr | Any | Any | UNION [ALL] query results present faulty internal datetime |
| 40247 | 2008-10-22 13:02 | 2008-10-26 10:33 | MySQL Server: DML | Can't repeat (6208 days) | S3 | 5.0.51a | Linux (RHEL4 x86_64) | Any | NULL-Safe Comparison of DATE |
| 40299 | 2008-10-24 11:16 | 2008-10-24 13:54 | MySQL Server: DML | Can't repeat (6210 days) | S3 | MySQL Browser 1.2.11 | Windows (XP home) | Any | not updated select after update in MySQL browser |
| 40334 | 2008-10-26 14:09 | 2008-10-29 6:39 | MySQL Server: DML | Not a Bug (6205 days) | S5 | 5.0.67 community nt | Windows (XP SP 2) | Any | LOAD DATA INFILE - Skipping rows in large data files |
| 40374 | 2008-10-28 17:32 | 2008-11-29 15:56 | MySQL Server: DML | Closed (6174 days) | S3 | 5.0.51a | Linux (Debian Lenny amd64) | Any | LOAD DATA with CONVERT_TZ causes memory leak |
| 40384 | 2008-10-29 7:42 | 2019-11-04 15:09 | MySQL Server: DML | Closed (2182 days) | S3 | 5.1, main-6.0, revision 2866 and greater | Any | Any | Gap in auto_increment sequence when inserts fire a trigger |
| 40560 | 2008-11-06 18:47 | 2008-11-16 21:57 | MySQL Server: DML | Closed (6187 days) | S2 | Ver 14.12 Distrib 5.0.18 | Linux | Any | Join condition with OR fails incorrectly in three-table join |
| 40629 | 2008-11-11 7:32 | 2018-02-10 17:03 | MySQL Server: DML | Can't repeat (2814 days) | S2 | 5.0.45 | Linux | Any | Wrong result reutn in select statement math function |
| 40745 | 2008-11-14 14:41 | 2011-02-16 23:43 | MySQL Server: DML | Closed (6164 days) | S3 | 5.1/6.0.8-debug | Linux | Any | Error during WHERE clause calculation in UPDATE leads to an assertion failure |
| 40761 | 2008-11-15 19:17 | 2011-02-16 23:43 | MySQL Server: DML | Closed (6114 days) | S2 | 5.1.29/5.0/5.1/6.0 | Windows (WinXP (Intel-32)/Linux) | Any | LEFT JOIN on inline view crashes server |
| 40879 | 2008-11-20 11:08 | 2011-02-16 23:43 | MySQL Server: DML | Duplicate (6143 days) | S1 | 5.0.68 | Any | Any | insert..select crashed in field_conv |
| 41007 | 2008-11-25 11:21 | 2008-11-26 10:13 | MySQL Server: DML | Not a Bug (6177 days) | S2 | 5.0.67 | Any (Tested on OSX and Linux Debian) | Any | Update Problem when ORing w/ Long.MIN_VALUE |
| 41051 | 2008-11-26 12:47 | 2008-11-26 12:51 | MySQL Server: DML | Not a Bug (6177 days) | S2 | 5.0 | Windows | Any | Retrieving free time slots from a table |
| 41115 | 2008-11-28 21:25 | 2008-12-01 10:29 | MySQL Server: DML | Not a Bug (6172 days) | S3 | 5.0.45-community-nt-log | Windows (xp) | Any | Bad error report on a bad sql syntax |
| 41156 | 2008-12-01 18:44 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5926 days) | S3 | 5.0.72, 5.1.30, 6.0.7 | Any | Any | List of derived tables acts like a chain of mutually-nested subqueries |
| 41345 | 2008-12-09 23:55 | 2009-04-04 19:12 | MySQL Server: DML | Not a Bug (6048 days) | S3 | 5.0.51a, 5.0.72, 5.1.30 | Linux (Fedora core6) | Any | Order by clause is dropping rows |
| 41371 | 2008-12-10 18:36 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5711 days) | S2 | 4.1.22, 5.0.51, 5.0.72, 5.1.30, 6.0.8 | Linux | Any | Select returns 1 row with condition "col is not null and col is null" |
| 41477 | 2008-12-15 15:33 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6158 days) | S3 | 4.1, 5.0, 5,1, 6.0 bzr | Any | Any | InnoDB foreign keys: wrong result if ON DELETE CASCADE, and correlated subquery |
| 41479 | 2008-12-15 16:31 | 2011-02-16 23:43 | MySQL Server: DML | Duplicate (6158 days) | S3 | 5.1.29-rc | Any | Any | Variable in LIMIT clause |
| 41487 | 2008-12-16 5:27 | 2011-02-16 23:43 | MySQL Server: DML | Verified (6157 days) | S3 | 6.0.9, 5.0, 5.1, 6.0 bzr | Any | Any | select into outfile not enclosing integer columns where this would disambiguate |
| 41489 | 2008-12-16 6:32 | 2012-05-18 20:19 | MySQL Server: DML | Verified | S3 | 6.0.9 | Any | Any | LOAD DATA INFILE doesn't work with multibyte ENCLOSED BY (although SELECT INTO O |
| 41666 | 2008-12-22 1:01 | 2011-02-16 23:43 | MySQL Server: DML | Duplicate (6151 days) | S1 | Ver 14.12 Distrib 5.0.67, for apple-darw | MacOS | Any | rand() used in scalar functions returns multiple rows |
| 41814 | 2009-01-01 1:18 | 2011-02-16 23:43 | MySQL Server: DML | Closed (6141 days) | S1 | 5.1.30 | Any | Any | SELECT DISTINCT returns wrong results with fixed width division |
| 41868 | 2009-01-05 14:09 | 2011-02-16 23:43 | MySQL Server: DML | Closed (6074 days) | S1 | 5.1.30, 6.0.10, 6.0.8, 5.0.76, 5.0.74,, 5.0.40 | Any | Any | crash or memory overrun with concat + upper, date_format functions |
| 41878 | 2009-01-05 18:03 | 2011-02-16 23:43 | MySQL Server: DML | Closed (6132 days) | S3 | 5.1.24 | Linux (RHEL) | Any | Deleting a row, trigger (before delete) executed, read_error in binlog |
| 41947 | 2009-01-08 8:00 | 2011-01-03 10:46 | MySQL Server: DML | Not a Bug (5409 days) | S1 | 5 | Linux | Any | select * from [table] where table.id='1' |
| 42009 | 2009-01-10 1:44 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5966 days) | S2 | 5.1.30-log, 4.1, 5.0, 5.1, 6.0 bzr | Linux (Ubuntu 8.10 with 2.6.27-9-generic kernel) | Any | SELECT into variable gives different results to direct SELECT |
| 42059 | 2009-01-12 19:06 | 2011-02-16 23:43 | MySQL Server: DML | No Feedback (6099 days) | S3 | 5.1.24-rc-community-log | Any | Any | Enclosure characters cause data to large for field error |
| 42064 | 2009-01-12 21:08 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5490 days) | S1 | 5.0.76, 5.1.30, 5.1.31, 5.1.46, 6.1.10 | Any | Any | low memory crash when importing hex strings, in Item_hex_string::Item_hex_string |
| 42102 | 2009-01-14 9:34 | 2012-05-18 20:19 | MySQL Server: DML | Duplicate (6128 days) | S1 | 4.1, 5.0, 5.1, 6.0 bzr | Any | Any | INSERT fail 'Duplicated entry' after UPDATE set auto_inc field with InnoDB |
| 42106 | 2009-01-14 11:38 | 2013-08-21 7:25 | MySQL Server: DML | Can't repeat (4448 days) | S3 | 5.0.68 | IBM AIX (AIX sup-aix53 3 5 0003F7BAD300) | Any | INSERT INTO ... SELECT gives error "Incorrect key file" |
| 42250 | 2009-01-21 18:38 | 2018-02-10 17:11 | MySQL Server: DML | Can't repeat (2814 days) | S3 | Any | Any | Just a little mistake | |
| 42259 | 2009-01-22 6:36 | 2012-07-31 12:15 | MySQL Server: DML | Closed (4834 days) | S2 | 5.5.25 | Linux (Ubuntu 12.04 x86_64) | Any | Utilizing a SELECT within a WHERE IN performs poorly (slow) |
| 42374 | 2009-01-27 13:53 | 2009-01-27 17:18 | MySQL Server: DML | Not a Bug (6115 days) | S3 | 5.1.30 | Any | Any | using a value from DUAL in a subquery returns Unknown column |
| 42404 | 2009-01-28 9:08 | 2012-03-27 17:31 | MySQL Server: DML | Closed (4960 days) | S3 | 5.1.25, 4.1, 5.0, 5.1, 6.0 bzr | Linux | Any | substring_index results inconsistent |
| 42492 | 2009-01-30 20:21 | 2018-02-10 17:16 | MySQL Server: DML | Can't repeat (2814 days) | S3 | 5.0.45 | Linux (Centos 5.2) | Any | Truncate causing inconsistent behavior |
| 42583 | 2009-02-04 8:32 | 2009-02-04 8:50 | MySQL Server: DML | Not a Bug (6107 days) | S2 | 5.0 | Windows (XP Version 2 Service Pack 3) | Any | From with SELECT statement when non integer type is used |
| 42666 | 2009-02-06 21:10 | 2019-11-04 14:46 | MySQL Server: DML | Closed (2182 days) | S3 | Ver 14.12 Distrib 5.0.67, 4.1, 5.0, 5.1 6.0 bzr | Linux (amd64 on Ubuntu) | Any | coalesce changes value of float fields |
| 42680 | 2009-02-09 4:20 | 2018-09-09 20:45 | MySQL Server: DML | Duplicate (5107 days) | S3 | 5.0.77, 5.1.30, 5.1.31, 5.0, 5.1, 6.0 bzr | Any | Any | Incorrect NULL output & max_allowed_packet warning for nested string functions |
| 42778 | 2009-02-12 5:42 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5966 days) | S2 | >=5.1.31-debug, 5.1, 6.0 bzr | Any | Any | delete order by null global variable causes assertion .\filesort.cc, line 797 |
| 42866 | 2009-02-15 16:49 | 2009-02-15 19:46 | MySQL Server: DML | Not a Bug (6096 days) | S2 | 5.0.45 | Linux (Fedora Core 7) | Any | CURDATE cannot report proper date if a subtraction breaches beginning of year. |
| 42934 | 2009-02-17 15:05 | 2009-02-17 22:19 | MySQL Server: DML | Not a Bug (6094 days) | S3 | 5.0.41 | Windows (2003) | Any | Function current_date returns an invalid date. |
| 42976 | 2009-02-18 16:15 | 2011-02-16 23:43 | MySQL Server: DML | Duplicate (6093 days) | S3 | 5 | Any | Any | LOAD DATA INFILE command does not accept file names as variables |
| 43165 | 2009-02-25 4:36 | 2009-02-25 6:04 | MySQL Server: DML | Not a Bug (6086 days) | S3 | 5.0 | Any | Any | Mutliple row updates |
| 43208 | 2009-02-25 21:37 | 2018-02-10 17:19 | MySQL Server: DML | Can't repeat (2814 days) | S5 | 5.0.67 | Linux (redhat) | Any | some rows will retrieve just fine and some won't |
| 43385 | 2009-03-04 17:21 | 2011-02-16 23:43 | MySQL Server: DML | Closed (6007 days) | S3 | 5.1.32 | Any | Any | Cannot ALTER DATABASE ... UPGRADE DATA DIRECTORY NAME when Views exist |
| 43432 | 2009-03-05 20:24 | 2011-02-16 23:43 | MySQL Server: DML | Closed (6007 days) | S2 | 5.0.51, 5.1.31 | Any | Any | Union on floats does unnecessary rounding |
| 43622 | 2009-03-13 7:52 | 2014-04-12 18:49 | MySQL Server: DML | Closed (4214 days) | S1 | 4.1.22, 5.0, 5.1 | Any (Linux 64-bit, 32-bit Mac) | Any | text datatype column does not match the long value |
| 43658 | 2009-03-15 16:07 | 2009-03-15 18:42 | MySQL Server: DML | Not a Bug (6068 days) | S1 | 5.1 | Any | Any | The code below returns an error, while other databases allow it |
| 43774 | 2009-03-20 23:26 | 2013-09-10 13:26 | MySQL Server: DML | Closed (4428 days) | S1 | 5.1.30, 4.1, 5.0, 5.1 | Any | Any | CAST(CAST(value) as TIME as DATETIME ) returns the wrong value. |
| 43781 | 2009-03-21 17:13 | 2013-12-20 7:04 | MySQL Server: DML | Won't fix (4327 days) | S3 | 6.1-fk | Any | Any | Foreign keys: ./mysqld crashes if sees a table created in --foreign-key-all-engi |
| 43796 | 2009-03-23 7:44 | 2011-02-16 23:43 | MySQL Server: DML | Closed (6025 days) | S3 | 5.0 | Windows (Intel(R) Pentium(R) 4 CPU 2.40 GHz 2.41GHz ) | Any | Update query doesnt get executed to set the date field to null value |
| 43895 | 2009-03-26 18:45 | 2014-07-14 15:31 | MySQL Server: DML | Closed (4121 days) | S3 | 5.1 bzr | Any | Any | Multi-DELETE IGNORE does not report warnings |
| 43912 | 2009-03-27 13:56 | 2012-10-16 5:00 | MySQL Server: DML | Won't fix (4757 days) | S3 | 5.0.91 | Any | Any | 'Column * cannot be null' when derived table has count() with no results |
| 44060 | 2009-04-03 3:07 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6046 days) | S3 | 4.1, 5.0, 5.1, 6.0 bzr | Any | Any | First option of PROCEDURE ANALYSE() does not work, second needs some work |
| 44090 | 2009-04-04 18:44 | 2012-05-24 13:44 | MySQL Server: DML | Can't repeat (4902 days) | S3 | 5.0, 5.1, 6.0 bzr | Any | Any | ONLY_FULL_GROUP_BY sql_mode allows mixing of group columns with wild cards |
| 44229 | 2009-04-13 2:02 | 2009-04-13 21:09 | MySQL Server: DML | Not a Bug (6039 days) | S3 | 5.0.67, 5.1-bzr | Linux | Any | COUNT() tries to coerce its expression into DOUBLE |
| 44306 | 2009-04-16 6:58 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5965 days) | S1 | 5.1.33, 5.1, 6.0 bzr | Any | Any | Assertion fail on duplicate key error in 'INSERT ... SELECT' statements |
| 44339 | 2009-04-17 7:47 | 2018-02-10 17:25 | MySQL Server: DML | Closed (2814 days) | S3 | 5.1.33, 5.0.80-bzr, 5.0.51 | Any | Any | Wrong result with WHERE 1 IN (SELECT 1 FROM DUAL WHERE FALSE) |
| 44399 | 2009-04-22 3:40 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5965 days) | S2 | 5.1.34-community, 5.1.35-bzr | Windows (Windows XP SP3) | Any | crash with statement using TEXT columns, aggregates, GROUP BY, and HAVING |
| 44478 | 2009-04-25 20:21 | 2009-04-25 21:59 | MySQL Server: DML | Not a Bug (6027 days) | S3 | 5.0.75 | Linux (Ubuntu 9.04) | Any | bigint mod bigint munges least significant byte |
| 44494 | 2009-04-27 13:42 | 2009-05-05 20:37 | MySQL Server: DML | Not a Bug (6017 days) | S3 | 5.1.28, 4.1, 5.0, 5.1, 6.0 bzr | Any (MS Windows, Linux) | Any | Multiples tables UPDATE updates each eligible row at most once |
| 44562 | 2009-04-29 21:41 | 2009-04-30 9:44 | MySQL Server: DML | Not a Bug (6022 days) | S2 | 5.1.30 | Windows (Vista) | Any | Multiple join, duplicate result |
| 44614 | 2009-05-01 18:48 | 2009-05-01 19:00 | MySQL Server: DML | Not a Bug (6021 days) | S1 | 5.0.45,5.1.32 | Any | Any | BIT_COUNT returns '1' for all powers-of-two values |
| 44673 | 2009-05-05 15:52 | 2011-02-16 23:43 | MySQL Server: DML | No Feedback (5986 days) | S2 | 5.1.32-community | Windows (Vista Business) | Any | Clause 'escaped by' on select into outfile |
| 44706 | 2009-05-06 22:38 | 2009-05-06 22:43 | MySQL Server: DML | Not a Bug (6016 days) | S3 | 5.0.45 | Any | Any | Temporary Table error being reported incorrectly |
| 44716 | 2009-05-07 12:29 | 2011-02-16 23:43 | MySQL Server: DML | Can't repeat (6015 days) | S3 | 5.0.67-community-nt-log | Windows (XP) | Any | select (1 in (select key0 from one_bigint)) returns 0 where key0=1 exists |
| 44743 | 2009-05-08 8:55 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5965 days) | S1 | 5.1.34-community, 5.1.35-bzr, 4.1, 5.0, 6.0 | Any (Vista Business SP1, Linux) | Any | Join in combination with concat does not always work |
| 44768 | 2009-05-10 20:45 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5965 days) | S1 | 5.1.30, 5.1.34, 5.1.35 | Linux (32-bit fc8) | Any | SIGFPE crash when selecting rand from a view containing null |
| 44774 | 2009-05-11 6:31 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5965 days) | S3 | 5.0.82, 5.1.30, 5.1.34, 5.1.35 | Linux (32-bit fc8) | Any | load_file function produces valgrind warnings |
| 44792 | 2009-05-11 14:03 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5965 days) | S3 | 5.0.82, 5.1.30, 5.1.34, .5.1.35, 6.0.10 | Linux (32-bit fc8) | Any | valgrind warning when casting from time to time |
| 44796 | 2009-05-11 17:28 | 2011-02-16 23:43 | MySQL Server: DML | Closed (5965 days) | S3 | 5.0.82, 5.1.30, 5.1.34, 5.1.35 | Linux (32-bit fc8) | Any | valgrind: too many my_longlong10_to_str_8bit warnings after uncompressed_length |
| 44904 | 2009-05-15 14:19 | 2018-02-10 17:27 | MySQL Server: DML | Can't repeat (2814 days) | S3 | 5.0, 5.1 | Windows (XP SP3) | Any | LIMIT IN INSERT ... DUPLICATE KEY UPDATE DIFFER IN THE SMPLE LIMIT |
| 44987 | 2009-05-20 14:29 | 2010-05-02 19:09 | MySQL Server: DML | Not a Bug (5655 days) | S3 | 5.0.78 , 5.1.31 | Any | Any | DELETE IGNORE and FK constraint : inconsistency in 5.0 , 5.1 and docs |
| 45081 | 2009-05-25 22:10 | 2014-11-28 6:21 | MySQL Server: DML | Not a Bug (5996 days) | S3 | 5.1.34-community | Any | Any | Insertion anomaly for ON DUPLICATE KEY UPDATE |
| 45152 | 2009-05-28 11:34 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5963 days) | S1 | 5.0.54, 5.0.83, 5.1.35, 6.0.12 | Any | Any | crash with round() function on longtext column in a derived table |
| 45168 | 2009-05-28 19:47 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5944 days) | S1 | 5.1.36-debug | Linux (32-bit fc8) | Any | assertion with convert() and empty set value |
| 45315 | 2009-06-03 22:55 | 2009-06-04 5:35 | MySQL Server: DML | Not a Bug (5987 days) | S3 | 5.1.34 | Windows | Any | rownumber not increase, use select (@s = @+1) as rownumber, others from tbl1 , |
| 45386 | 2009-06-09 3:52 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5870 days) | S3 | 5.0.81, 5.0, 5.1, 6.0 bzr | Solaris | Any | Wrong query result with MIN function in field list, WHERE and GROUP BY clause |
| 45666 | 2009-06-23 0:03 | 2018-09-09 20:45 | MySQL Server: DML | Duplicate (2812 days) | S3 | 5.1.36-bzr | Any | Any | DELETE FROM a.* USING a; syntax invalid in 5.1 |
| 45962 | 2009-07-06 8:39 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5883 days) | S2 | 5.0.84, 5.1.37, 6.0.12 | Any | Any | memory leak after 'sort aborted' errors |
| 46259 | 2009-07-17 10:05 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5789 days) | S3 | 5.1.36, 5.4.4 | Any (openSUSE 11.1) | Any | 5.0.83 -> 5.1.36, query doesn't work |
| 46290 | 2009-07-18 22:24 | 2018-02-10 17:44 | MySQL Server: DML | Can't repeat (2814 days) | S2 | MySQL 5.1.34 comunitiy edition | Windows | Any | SELECT COUNT(*) FROM ... does'nt work with libmysql client library |
| 46465 | 2009-07-30 3:34 | 2018-02-10 17:54 | MySQL Server: DML | Not a Bug (2814 days) | S3 | 5.0.32, 5.1.38 | Linux (debian-etch) | Any | When IF is used with ROLLUP incorrect data is returned |
| 46534 | 2009-08-03 20:31 | 2012-05-18 20:19 | MySQL Server: DML | Duplicate (5926 days) | S3 | Any | Any | Allow reference to same table in UPDATE subquery | |
| 46902 | 2009-08-24 21:35 | 2018-09-09 20:45 | MySQL Server: DML | Duplicate (5408 days) | S3 | 5.1.30-debug, 5.1.39-debug, 5.4.4-debug, 6.0.12-debug | Any | Any | Assertion failed: next_insert_id >= auto_inc_interval_for_cur_row.minimum() |
| 46978 | 2009-08-28 15:21 | 2009-08-28 19:42 | MySQL Server: DML | Not a Bug (5902 days) | S2 | 5.0.67 | MacOS (10.5.8) | Any | Invalid IN statement in Delete causes all rows to be deleted. |
| 46997 | 2009-08-29 22:19 | 2009-09-04 9:14 | MySQL Server: DML | Not a Bug (5895 days) | S2 | 5.1.31-community, 4.1, 5.0, 5.1, next bzr | Any (MS Windows, Linux) | Any | ON DUPLICATE UPDATE does not react on change in one field |
| 47049 | 2009-09-01 17:10 | 2009-09-01 22:03 | MySQL Server: DML | Not a Bug (5898 days) | S3 | 5.1.35, 4.1, 5.0, 5.1, 5.4 bzr | Any (SunOS 5.10 Generic_138889-02 i86pc i386 i86pc) | Any | Boundaries are included in result when using a float in a range (< or >) |
| 47434 | 2009-09-18 10:18 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5876 days) | S3 | 5.0.51a-24+lenny1-log, 5.1.38 | Linux | Any | Ambigous field name in group by clause does not cause an error |
| 47453 | 2009-09-19 13:46 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5608 days) | S2 | 5.1.30, 5.1.45, 5.5.2-m2 | Any | Any | InnoDB incorrectly changes TIMESTAMP columns when JOINed during an UPDATE |
| 47650 | 2009-09-25 16:53 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5706 days) | S3 | 5.0.X, 5.1.39, next-mr | Any (Mac OS X Snow leopard, Linux) | Any | using group by with rollup without indexes returns incorrect results with where |
| 47713 | 2009-09-29 12:51 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5870 days) | S1 | 5.0.83, 5.1.39 | Any | Any | SELECT WITH ROLLUP returned wrong data when using CONCAT |
| 47888 | 2009-10-07 9:28 | 2011-02-16 23:44 | MySQL Server: DML | Can't repeat (5862 days) | S2 | 5.0.24 | Windows (Server 2003) | Any | LAST_INSERT_ID() not working properly within a stored procedure |
| 48150 | 2009-10-19 14:06 | 2013-02-19 13:49 | MySQL Server: DML | Closed (4631 days) | S3 | 5.1.39, 5.1.41, 5.1.47 | Linux | Any | Quoted aliases are not recognized in HAVING clause |
| 48291 | 2009-10-25 16:53 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5453 days) | S1 | >=5.0.32, 5.0.86, 5.1.40 | Any | Any | crash with row() operator,select into @var, and subquery returning multiple rows |
| 48421 | 2009-10-29 19:38 | 2018-02-11 11:03 | MySQL Server: DML | Can't repeat (2813 days) | S2 | 5.1 | Windows | Any | Failure of executing insert into table select ... from .... group by .. |
| 48490 | 2009-11-02 23:55 | 2018-02-11 11:06 | MySQL Server: DML | Can't repeat (2813 days) | S2 | 5.1.39 | Linux (Debian 5.0 lenny 64-bit) | Any | ORDER BY clause not honored when using UNION on two VIEWs. Wrong data returned. |
| 48661 | 2009-11-10 10:37 | 2018-02-11 11:08 | MySQL Server: DML | Can't repeat (2813 days) | S2 | 14.12 Distrib 5.0.26 | Solaris (Sol 10 5/08) | Any | One table only becomes permanently locked after 2-3 successful write operations |
| 48724 | 2009-11-12 12:33 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5711 days) | S2 | 6.0.14-bzr, 6.0-codebase-bugfixing | Any | Any | Deadlock between INSERT DELAYED and FLUSH TABLES |
| 48725 | 2009-11-12 12:38 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5711 days) | S3 | 6.0.14-bzr, 6.0-codebase-bugfixing | Any | Any | Assert !thd->is_error() in delayed_get_table() |
| 48985 | 2009-11-23 11:23 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5706 days) | S1 | 5.1.40, 5.1.41 | Any | Any | show create table crashes if previous access to the table was killed |
| 49475 | 2009-12-05 16:20 | 2009-12-06 17:53 | MySQL Server: DML | Not a Bug (5802 days) | S3 | 5.0.32 | Linux | Any | unknown column error despite parenthesizing FROM clause |
| 49494 | 2009-12-07 9:52 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5525 days) | S3 | 5.1.37, 5.0, next-mr | Linux (Ubuntu 9.10) | Any | CREATE TABLE IF NOT EXISTS does wrong insert when view exists with the name |
| 49534 | 2009-12-08 15:07 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5608 days) | S1 | 5.0.88-debug, 5.0.89-debug, 5.1.41-debug, 5.1.43-debug,5.5.99-m3-debug | Any | Any | multitable IGNORE update with sql_safe_updates error causes debug assertion |
| 49550 | 2009-12-09 7:37 | 2011-02-16 23:44 | MySQL Server: DML | Can't repeat (5491 days) | S1 | 5.1.41 | Any | Any | memory leak after filesort |
| 49552 | 2009-12-09 9:52 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5589 days) | S1 | 5.0.88,5.1.41 | Any | Any | sql_buffer_result cause crash + not found records in multitable delete/subquery |
| 49636 | 2009-12-11 23:15 | 2012-10-05 15:42 | MySQL Server: DML | Closed (4768 days) | S3 | 5.1.36 | Windows (Vista) | Any | ALTER TABLE can create table with no name |
| 49958 | 2009-12-28 13:48 | 2018-02-11 11:09 | MySQL Server: DML | Can't repeat (2813 days) | S1 | Any | Any | How Solve this Error - Errcode: 13 | |
| 50005 | 2009-12-30 19:00 | 2010-01-07 12:13 | MySQL Server: DML | Not a Bug (5770 days) | S2 | 5.1.41 | Windows | Any | select count(*) with LIMIT key word doesn't return expected # of results |
| 50153 | 2010-01-07 19:35 | 2010-01-08 6:29 | MySQL Server: DML | Not a Bug (5769 days) | S3 | Windows (xp sp3) | Any | Error in summing time | |
| 50484 | 2010-01-20 19:20 | 2010-01-21 13:02 | MySQL Server: DML | Not a Bug (5756 days) | S2 | 5.1.42 | Any | Any | Mysql does not manage dates correctly when using DATE_ADD and STR_TO_DATE |
| 50545 | 2010-01-22 13:46 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5608 days) | S3 | Any | Any | Single table UPDATE IGNORE crashes on join view in sql_safe_updates mode. | |
| 50619 | 2010-01-26 11:02 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5402 days) | S3 | 5.1.44,5.5.99-m3,6.0.14-alpha | Any | Any | assert in handler::update_auto_increment |
| 50627 | 2010-01-26 15:21 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5748 days) | S3 | 5.5.1-m2 | Any | Any | how to insert a TIMESTAMP of the last hour of daylight savings |
| 50693 | 2010-01-28 16:15 | 2010-02-01 5:09 | MySQL Server: DML | Not a Bug (5745 days) | S3 | Linux | Any | Incorrect behaviour for aggregate/min/max functions in subquery with no clause | |
| 50774 | 2010-02-01 2:23 | 2011-05-13 14:21 | MySQL Server: DML | Closed (5279 days) | S1 | 5.1.44, 5.1.49, 5.5.99, 5.5.6rc | Any | Any | Wrong resultset when timestamp values are appended with .0 |
| 50790 | 2010-02-01 12:44 | 2010-02-01 17:02 | MySQL Server: DML | Not a Bug (5745 days) | S3 | 5.0.83 and 5.1.42 | Any | Any | Bug in RegExp |
| 51099 | 2010-02-11 14:16 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5457 days) | S2 | 5.1, 5.5 | Any | Any | Assertion in mysql_multi_delete_prepare() |
| 51523 | 2010-02-25 18:31 | 2013-08-09 8:19 | MySQL Server: DML | Not a Bug (4460 days) | S3 | 5.1.45, 5.5.99-m3 | Any | Any | inconsistent reporting of warnings on re-execution of a query against csv tables |
| 51530 | 2010-02-25 22:47 | 2010-02-25 23:00 | MySQL Server: DML | Not a Bug (5721 days) | S2 | 5,1,37 | Linux | Any | Selecting a single column returns incorrect data |
| 51598 | 2010-03-01 9:09 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5608 days) | S3 | 5.0.91, 5.1.37, 5.1.45 | Any | Any | Inconsistent behaviour with a COALESCE statement inside an IN comparison |
| 51840 | 2010-03-08 19:13 | 2014-05-31 13:49 | MySQL Server: DML | Closed (4236 days) | S1 | 4.0.24,4.1.25,5.0.90,5.1.44,5.5.2-m2 | Any | Any | infinite hang with 100% cpu usage with load data local and import errors |
| 51850 | 2010-03-09 4:57 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5469 days) | S1 | 5.0.89, 5.1.44, 5.1.45-bzr, 5.6.99 | Linux (fc6 x86) | Any | crash/memory overlap when using load data infile and set col equal to itself! |
| 51893 | 2010-03-09 21:31 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5608 days) | S1 | 5.0.90, 5.1.44, 5.5.2-m2 | Windows (XP) | Any | crash with certain characters given to load_file function on windows |
| 52122 | 2010-03-17 3:29 | 2018-11-04 20:45 | MySQL Server: DML | Duplicate (5675 days) | S1 | 5.6.99-m4-debug, mysql-6.0-codebase | Any | Any | crash when converting derived table column to decimal |
| 52160 | 2010-03-17 21:24 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5429 days) | S1 | 5.1+ | Any | Any | crash and inconsistent results when grouping by a function and column |
| 52164 | 2010-03-18 6:05 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5589 days) | S1 | 5.1.45-debug,5.6.99-m4-debug | Any | Any | Assertion failed: param.sort_length, file .\filesort.cc, line 149 |
| 52507 | 2010-03-31 14:53 | 2011-02-16 23:44 | MySQL Server: DML | No Feedback (5656 days) | S3 | MySQL 5.1.45 | Windows | Any | HAVING cannot reference a field with variable |
| 52582 | 2010-04-04 3:51 | 2014-08-06 17:47 | MySQL Server: DML | Closed (4511 days) | S2 | 4.1.25, 5.0.91, 5.1.54, 5.5.10 | Any (IBM System i 32 bit, Linux) | Any | Incorrect results with COUNT DISTINCT and BIG_TABLES |
| 52650 | 2010-04-07 10:25 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5680 days) | S2 | 5.1.45, 5.1.47-bzr | Any | Any | select !!0 = 1 returns 1 |
| 52651 | 2010-04-07 10:33 | 2010-04-07 22:09 | MySQL Server: DML | Not a Bug (5680 days) | S2 | 5.1.22-rc-community | Windows | Any | 'WHERE' clause not working for 'INT DEFAULT 0' values cointaining 'NULL' |
| 53034 | 2010-04-21 18:15 | 2018-02-12 9:20 | MySQL Server: DML | Closed (5490 days) | S3 | 5.1.x | Any | Any | Multiple-table DELETE statements not accepting "Access compatibility" syntax |
| 53432 | 2010-05-05 11:41 | 2020-09-13 20:45 | MySQL Server: DML | Duplicate (5632 days) | S1 | 5.5.5 , 5.5.4 | Any | Any | SELECT MAX QUERY WITH DATE FIELD GIVES WRONG RESULTS |
| 53830 | 2010-05-20 4:14 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5490 days) | S1 | 5.1.43sp1-debug,5.1.46-debug, 5.5.3-debug | Any | Any | !table || (!table->read_set || bitmap_is_set(table->read_set, field_index)) |
| 54147 | 2010-06-01 14:18 | 2018-02-11 11:25 | MySQL Server: DML | Closed (2813 days) | S2 | 5.0.51a-3ubuntu5.5 (Ubuntu), 5.0.91, 5.1.48, 5.6.99 bzr | Linux (Ubuntu 8.04.4 LTS) | Any | Valid date string in query results in wrong result on Linux sever. |
| 54459 | 2010-06-12 18:25 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5489 days) | S1 | 5.0.91-debug, 5.1.47-debug, 5.5.3-debug, 5.5.5-m3-debug | Any | Any | Assertion failed: param.sort_length, file .\filesort.cc, line 149 (part II) |
| 54465 | 2010-06-13 10:06 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5489 days) | S1 | 5.0.91, 5.1.47, 5.5.3, 5.5.5-m3 | Any | Any | assert: field_types == 0 || field_types[field_pos] == MYSQL_TYPE_LONGLONG |
| 54543 | 2010-06-16 6:37 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5497 days) | S1 | 5.0.91-debug, 5.1.47-debug, 5.1.49-debug | Any | Any | update ignore with incorrect subquery leads to assertion failure: inited==INDEX |
| 54588 | 2010-06-17 15:51 | 2018-04-11 12:17 | MySQL Server: DML | Not a Bug (2754 days) | S3 | 5.1.47, 5.1.48 | Any | Any | Index on datetime column does not support iso8601. |
| 54609 | 2010-06-18 9:38 | 2011-02-16 23:44 | MySQL Server: DML | Duplicate (5608 days) | S1 | 5.1.47-1~bpo50+1-log, 6.0.14 | Linux (debian lenny) | Any | Select returning incorrect result |
| 54699 | 2010-06-22 16:14 | 2010-06-22 17:23 | MySQL Server: DML | Not a Bug (5604 days) | S2 | 5.1.47 | Linux | Any | Signed Unsigned Subtraction Out of Range Error |
| 54720 | 2010-06-23 6:44 | 2011-07-27 6:38 | MySQL Server: DML | Closed (5204 days) | S1 | 5.1.50 | Linux ( RED HAT Enterprise Linux 2.6.9-55.ELsmp) | Any | Mysql Server crashes and automatically restart where updating temporary table |
| 54860 | 2010-06-28 10:33 | 2018-09-09 20:45 | MySQL Server: DML | Verified | S3 | all | Any | Any | detect when HANDLER was implicitly reset and looses position |
| 54893 | 2010-06-29 9:57 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5597 days) | S3 | 5.1.48 | Any | Any | select .. into dumpfile can write 2 rows into the file instead of 1 |
| 54916 | 2010-06-30 14:24 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5511 days) | S3 | 5.5.4-m3-log, 5.5.6-m3 | Any (FreeBSD 7.2, Mac OS X, Ubuntu) | Any | GROUP_CONCAT + IFNULL truncates output |
| 54920 | 2010-06-30 16:37 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5453 days) | S3 | 5.1.49-bzr | Any | Any | Stored functions are allowed in HANDLER statements, but broken. |
| 54931 | 2010-07-01 10:23 | 2010-07-01 10:37 | MySQL Server: DML | Not a Bug (5595 days) | S2 | 5.1 | Any | Any | mysql subquery |
| 54941 | 2010-07-01 17:57 | 2018-02-11 12:50 | MySQL Server: DML | Can't repeat (2813 days) | S3 | 5.1.47 ?? | Windows (XP SP3) | Any | just executing a loop with a counter with initial value = 256 |
| 55115 | 2010-07-09 8:22 | 2011-02-16 23:44 | MySQL Server: DML | Can't repeat (5587 days) | S2 | 5.1.39 | Windows (XP) | Any | LIMIT with Order By Gives Wrong Result |
| 55188 | 2010-07-12 21:01 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5489 days) | S2 | 5.1.46sp1 | Any | Any | GROUP BY, GROUP_CONCAT and TEXT - inconsistent results |
| 55201 | 2010-07-13 3:30 | 2011-02-16 23:44 | MySQL Server: DML | Can't repeat (5583 days) | S2 | 5.5.3 m3 | Windows | Any | Date-time bug on select |
| 55385 | 2010-07-20 4:51 | 2011-03-02 15:24 | MySQL Server: DML | Closed (5351 days) | S3 | mysql-next-mr-wl5136-stage, 5.1 | Any | Any | UPDATE statement throws an error, but still updates the table entries |
| 55463 | 2010-07-22 0:25 | 2016-09-07 20:04 | MySQL Server: DML | Not a Bug (5574 days) | S5 | Any | Any | incorrect value returned by last_insert_id() function | |
| 55615 | 2010-07-28 18:15 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5453 days) | S1 | 5.0.91-debug, 5.1.49-debug | Any | Any | debug assertion after using variable in assignment and referred to |
| 55810 | 2010-08-06 21:07 | 2011-02-16 23:44 | MySQL Server: DML | Can't repeat (5558 days) | S1 | 5.5.5-m3 | Windows (Vista x64 and Server 2008 x64) | Any | incorrect max aggregate calculated |
| 55912 | 2010-08-11 14:37 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5511 days) | S3 | 5.5.4 | FreeBSD (8.0 release ) | Any | FORMAT with locale set fails for numbers < 1000 |
| 55930 | 2010-08-12 0:33 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5453 days) | S2 | 5.5.6-m3-debug, 5.6.0-m4-debug | Any | Any | Assertion `thd->transaction.stmt.is_empty() || thd->in_sub_stmt || (thd->state.. |
| 56131 | 2010-08-20 1:42 | 2011-02-16 23:44 | MySQL Server: DML | Duplicate (5545 days) | S2 | Any | Any | UPDATE query allows AND (before WHERE) between fields and consequently | |
| 56271 | 2010-08-25 20:32 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5461 days) | S3 | 5.5.5-m3-log | Windows (XP Pro) | Any | STR_TO_DATE in date compare incorrect results |
| 56288 | 2010-08-26 11:56 | 2011-02-16 23:44 | MySQL Server: DML | Duplicate (5538 days) | S1 | 5.0.45-community-nt | Windows (XP SP2) | Any | Can't create/write to file Errcode 17 |
| 56514 | 2010-09-02 18:00 | 2018-02-11 12:57 | MySQL Server: DML | Can't repeat (2813 days) | S3 | 5.5.5 m3 | FreeBSD (7.2) | Any | Mixing utf8, group by, IF and Datefield cause a truncate problem (Only in views) |
| 56565 | 2010-09-05 10:08 | 2010-09-06 20:50 | MySQL Server: DML | Not a Bug (5528 days) | S3 | 5.1.36 | Any | Any | Multiple update syntax doesn't update rows multiple times |
| 56653 | 2010-09-08 13:56 | 2018-09-09 20:45 | MySQL Server: DML | Duplicate (5492 days) | S2 | trunk, 5.6 | Any | Any | Valgrind warnings for memory leak in LOAD DATA INFILE |
| 56678 | 2010-09-09 8:57 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5429 days) | S3 | 5.5 | Any | Any | Valgrind warnings from binlog.binlog_unsafe |
| 56899 | 2010-09-21 15:43 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5513 days) | S3 | 5.5.5-m3-log | Any (XP Pro) | Any | IFNULL Evaluation inside CONCAT_WS Incorrect |
| 57015 | 2010-09-25 8:10 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5506 days) | S3 | 5.0.51 | Any | Any | LPad in view displays junk |
| 57039 | 2010-09-27 15:32 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5457 days) | S2 | 5.5.5-m3-log, 5.5.7-bzr | Any (10.04) | Any | queries using subtime in the where condition returns incorrect data |
| 57153 | 2010-09-30 20:32 | 2018-02-11 13:02 | MySQL Server: DML | Can't repeat (2813 days) | S5 | 5.1.51 | Other (Centos 5.5) | Any | Performance of call to POWER(LOG(EXP(0.25)),0.5) slower than expected on 5.1.51 |
| 57309 | 2010-10-07 11:35 | 2010-10-07 13:35 | MySQL Server: DML | Not a Bug (5497 days) | S2 | Any | Any | TIMEDIFF function giving same value for different date | |
| 57373 | 2010-10-11 14:14 | 2011-03-02 15:25 | MySQL Server: DML | Closed (5351 days) | S3 | 5.1, 5.5 | Any | Any | Multi update+InnoDB reports ER_KEY_NOT_FOUND if a table is updated twice |
| 57643 | 2010-10-22 2:47 | 2022-12-04 20:45 | MySQL Server: DML | Verified (5061 days) | S3 | 5.1.41, 5.1.50, 5.5.20 | Linux | Any | InnoDB skips auto_increment values with LOAD DATA INFILE |
| 57723 | 2010-10-26 1:47 | 2018-09-09 20:45 | MySQL Server: DML | Duplicate (5478 days) | S3 | 5.1.49,5.5.6rc | Any | Any | Wrong results when milisecond precision is passed to WHERE >= clause |
| 57759 | 2010-10-27 3:37 | 2010-10-28 0:26 | MySQL Server: DML | Not a Bug (5476 days) | S2 | 5.0.77, 5.0.90, 5.1, 5.5.6rc | Any | Any | Strange parsing error bug |
| 57777 | 2010-10-27 16:05 | 2011-02-16 23:44 | MySQL Server: DML | Won't fix (5408 days) | S2 | 5.0.92 | Windows (Windows 7) | Any | Connector problems between mysql and crystal reports 8.5 |
| 57869 | 2010-10-31 10:21 | 2018-02-11 13:06 | MySQL Server: DML | Can't repeat (2813 days) | S3 | 5.1.51-community | Windows (7) | Any | INSERT ... SELECT with data manipulation |
| 58002 | 2010-11-04 23:20 | 2010-11-17 9:00 | MySQL Server: DML | Not a Bug (5456 days) | S3 | 5.1.51-community | Windows (7) | Any | same command, different behavior |
| 58165 | 2010-11-12 14:25 | 2011-03-02 3:27 | MySQL Server: DML | Closed (5351 days) | S1 | 5.1.54, 5.5.7 | Any | Any | "my_empty_string" gets modified and causes LOAD DATA to fail and other crashes |
| 58601 | 2010-11-30 17:34 | 2020-01-08 21:08 | MySQL Server: DML | Can't repeat (2117 days) | S3 | 5.1.50-community | Windows (xp Prof) | Any | select into outfile bug with workbench adding LIMIT, and not working w/o FROM |
| 58743 | 2010-12-05 17:36 | 2010-12-05 19:50 | MySQL Server: DML | Not a Bug (5438 days) | S3 | 5.1.45 | Any | Any | UPDATE statement is accepted but produces wrong results when AND is used in SET |
| 59093 | 2010-12-21 16:24 | 2012-07-22 1:00 | MySQL Server: DML | No Feedback (4844 days) | S3 | 5.1.48, 5.5.8 | Linux (Centos 5.5 Final) | Any | LOAD DATA hangs after millions of rows inserted |
| 59154 | 2010-12-24 12:58 | 2018-09-09 20:45 | MySQL Server: DML | Duplicate (5365 days) | S1 | 5.6.1, 5.6.2, 5.5.10, 5.1 | Any | Any | reading of freed memory during multiple user variable assignments |
| 59164 | 2010-12-24 22:43 | 2011-04-19 16:59 | MySQL Server: DML | Closed (5303 days) | S3 | 5.0.92,5.1.55,5.5.9,5.6.1, 5.6.2 | Any | Any | valgrind: uninitialized value in number_to_datetime |
| 59166 | 2010-12-25 6:52 | 2011-04-19 17:15 | MySQL Server: DML | Closed (5303 days) | S3 | 5.1.55,5.5.9,5.6.1,5.6.2 | Any | Any | another datetime valgrind uninitialized warning |
| 59211 | 2010-12-29 11:57 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5372 days) | S3 | mysql-5.1,5.5, 5.6.1, 5.6.2 | Any | Any | Select Returns Different Value for min(year) Function |
| 59241 | 2010-12-31 9:36 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5383 days) | S2 | 5.6.2, 5.5 | Any | Any | invalid memory read in do_div_mod with doubly assigned variables |
| 59248 | 2010-12-31 23:31 | 2013-01-22 19:06 | MySQL Server: DML | Closed (4659 days) | S2 | 5.5.8, 5.5.20 | Any | Any | code review: write_row() crashes on INSERT...DUPLICATE KEY UPDATE |
| 59386 | 2011-01-10 6:01 | 2011-08-20 23:00 | MySQL Server: DML | No Feedback (5180 days) | S3 | mysql-5.5 | Windows | Any | "Load Data" Does Not Populate data in table on window - for 5.5 trunk security |
| 59504 | 2011-01-14 14:07 | 2011-02-22 14:36 | MySQL Server: DML | Can't repeat (5359 days) | S3 | trunk | Any | Any | Assert in Protocol::end_statement() for LOAD DATA |
| 59526 | 2011-01-15 14:08 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5381 days) | S3 | 5.0, 5.1, 5.6.2 | Any | Any | ZERO-date can be inserted in 'no_zero_date' sql_mode |
| 59698 | 2011-01-24 15:36 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5388 days) | S2 | 5.5.8 | Any | Any | Insert with NULL value for recursive constraint fails |
| 59712 | 2011-01-25 11:18 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5387 days) | S3 | 5.1.48 | Any | Any | Cannot insert a table record with a null value for an optional foreign key |
| 59883 | 2011-02-02 8:16 | 2011-04-11 23:00 | MySQL Server: DML | No Feedback (5311 days) | S2 | 5.1.44 | Any | Any | NOT IN clause with LIMIT |
| 59937 | 2011-02-04 9:20 | 2011-02-16 23:44 | MySQL Server: DML | Closed (5377 days) | S2 | 5.1.41 | Linux (ubuntu maverick) | Any | select query with order by clause repeats data and repair table says status ok |
| 60035 | 2011-02-09 6:17 | 2011-05-21 18:49 | MySQL Server: DML | Verified (5271 days) | S3 | mysql-trunk | Solaris (10 x86_64) | Any | main.insert_select fails due to error in log files |
| 60166 | 2011-02-18 10:54 | 2012-03-22 18:25 | MySQL Server: DML | Closed (4965 days) | S2 | 5.0.91, 5.1.36, 5.1.54, 5.5.8, 5.5.9 | Any (Windows 7, Linux Ubuntu 9.10) | Any | SUBSTRING_INDEX() results "omit" character when used inside LOWER() |
| 60178 | 2011-02-19 9:58 | 2013-07-17 19:57 | MySQL Server: DML | Closed (4483 days) | S3 | 5.5.9 | Windows (Windows 7) | Any | Corruption of text variable inside trigger |
| 60251 | 2011-02-25 13:39 | 2011-02-25 14:04 | MySQL Server: DML | Closed (5356 days) | S3 | 5.5.8 | Linux | Any | Does not work DISCARD TABLESPACE on partitioned table |
| 60299 | 2011-03-02 0:21 | 2011-04-02 23:00 | MySQL Server: DML | No Feedback (5320 days) | S3 | 5.1.43sp1-enterprise-gpl-advanced-log | Any | Any | Create Table as SELECT with expression doesn't work right |
| 60435 | 2011-03-11 21:38 | 2018-02-11 13:20 | MySQL Server: DML | Not a Bug (2813 days) | S1 | 5.5.9, 5.5.8, 5.1.54 | Any | Any | return values truncated |
| 60516 | 2011-03-17 15:26 | 2011-11-24 11:33 | MySQL Server: DML | Closed (5084 days) | S1 | 5.5.10 | Linux (Fedora 14) | Any | UPDATE within a function fails and causes infinite loop |
| 60607 | 2011-03-23 20:04 | 2011-03-23 20:37 | MySQL Server: DML | Duplicate (5330 days) | S3 | 5.5.10 | Any | Any | UPDATE Incorrect syntax indicates success but fails |
| 60719 | 2011-04-01 8:40 | 2018-02-11 13:27 | MySQL Server: DML | Can't repeat (2813 days) | S3 | 5.5.10, 5.5.9 | Any | Any | Field info in EXPLAIN EXT./GROUP BY WITH ROLLUP says NOT NULL and contains NULL |
| 60724 | 2011-04-01 16:19 | 2011-04-05 14:50 | MySQL Server: DML | Verified (5321 days) | S2 | 5.5.11, 5.5.10-log, 5.1.57, 5.0.93 | Any | Any | Unquoted date literal in comparison yields incorrect implicit conversion |
| 60786 | 2011-04-07 0:18 | 2019-11-28 21:59 | MySQL Server: DML | Closed (2158 days) | S2 | 5.1.49/5.5 | Linux (Debian Squeeze) | Any | For update:Trailing white space not ignored with index, is ignored without index |
| 60838 | 2011-04-12 2:01 | 2011-05-12 23:00 | MySQL Server: DML | No Feedback (5280 days) | S2 | Ver 14.12 Distrib 5.0.91 | MacOS | Any | on duplicate key update -- lost data |
| 60885 | 2011-04-15 20:49 | 2011-04-16 2:33 | MySQL Server: DML | Not a Bug (5306 days) | S2 | 5.0.32-Debian_7etch11 | Linux | Any | (not so) wrong NOT IN result (when NULL values are involved) |
| 60931 | 2011-04-20 8:13 | 2011-04-20 11:17 | MySQL Server: DML | Not a Bug (5302 days) | S2 | Linux | Any | Comparaison on column with some NULL values | |
| 60987 | 2011-04-27 15:54 | 2011-06-16 19:39 | MySQL Server: DML | Closed (5245 days) | S2 | 5.5 | Any (Windows Vista, CentOS 5 Linux) | Any | LOAD DATA LOCAL INFILE can path parse relative paths "higher" than 3 levels |
| 61032 | 2011-05-02 22:46 | 2011-06-03 23:00 | MySQL Server: DML | No Feedback (5258 days) | S3 | 5.0.51b | Windows (Vista) | Any | Convert to Integers Returns Errorneous Results |
| 61036 | 2011-05-03 8:22 | 2011-05-05 13:11 | MySQL Server: DML | Not a Bug (5287 days) | S3 | 5.6.2 m5 | Windows (xp sp3) | Any | may an error in partitioning order |
| 61067 | 2011-05-05 9:55 | 2011-09-23 23:00 | MySQL Server: DML | No Feedback (5147 days) | S2 | 5.5.11 | Windows (Vista) | Any | Foreign key creation order is essential |
| 61095 | 2011-05-09 8:34 | 2025-10-12 20:45 | MySQL Server: DML | No Feedback (5252 days) | S2 | 5.0.45 | Linux | Any | com.mysql.jdbc.CommunicationsException: Communications link failure due to under |
| 61100 | 2011-05-09 12:48 | 2018-04-12 14:20 | MySQL Server: DML | Closed (2753 days) | S3 | 5.5.8, 5.5.13 | Any (XP, Mac OS X) | Any | Incorrecte value from Select Max(date) with year smaller 100. |
| 61184 | 2011-05-16 9:33 | 2018-02-11 13:39 | MySQL Server: DML | Closed (2813 days) | S1 | 5.1.54-1ubuntu4, 5.1.56 | Any (Ubuntu 11.04, Widnows XP) | Any | RIGHT JOIN with WHERE gives wrong result |
| 61223 | 2011-05-19 1:57 | 2012-10-23 1:00 | MySQL Server: DML | No Feedback (4751 days) | S5 | 5.0 | Any | Any | SQL_CALC_FOUND_ROWS kills performance with left join ,join,right join and LIMIT |
| 61224 | 2011-05-19 10:13 | 2018-02-11 13:48 | MySQL Server: DML | Closed (5269 days) | S3 | 5.5.12 | Windows (XP) | Any | function pow is wrong |
| 61227 | 2011-05-19 11:55 | 2018-09-09 20:45 | MySQL Server: DML | Verified (5273 days) | S2 | 5.0.51, 5.0.91, 5.1.57 | Any | Any | where->order |
| 61366 | 2011-05-31 18:31 | 2011-06-01 13:24 | MySQL Server: DML | Not a Bug (5260 days) | S2 | 5.5.11 | Linux (CentOS 5.6) | Any | table not found when using multi-table delete with alias no default table select |
| 61371 | 2011-06-01 10:26 | 2011-06-02 12:16 | MySQL Server: DML | Not a Bug (5259 days) | S1 | 5.0.32-7etch12, 5.1.54-1ubuntu4 | Linux (Ubuntu 11.04) | Any | Duplicate Key when inserting new auto increment value |
| 61375 | 2011-06-01 13:49 | 2017-04-26 17:17 | MySQL Server: DML | Not a Bug (5260 days) | S3 | 5.5 | Any | Any | Auto Increment Syntax |
| 61376 | 2011-06-01 14:04 | 2018-07-12 10:53 | MySQL Server: DML | Verified (4917 days) | S3 | 5.1.58, 5.5 | Any | Any | Delete statements referencing aliases fail when no database is selected |
| 61378 | 2011-06-01 14:57 | 2018-04-12 14:23 | MySQL Server: DML | Closed (2753 days) | S3 | 5.5.12, 5.5.14 | Any (CentOS Linux 5.6, Mac OS X) | Any | NULLIF sometimes causes timestamp field text output to be truncated |
| 61410 | 2011-06-05 6:47 | 2017-08-06 12:36 | MySQL Server: DML | Not a Bug (5256 days) | S1 | 5.5.11 | Linux (suse) | Any | an unsigned column can't subtract a bigger value than before |
| 61602 | 2011-06-23 3:44 | 2011-06-23 3:52 | MySQL Server: DML | Closed (5238 days) | S2 | 5.0.91 | Any | Any | tolower() in where clause returns wrong value for column |
| 61645 | 2011-06-26 8:16 | 2011-06-28 7:31 | MySQL Server: DML | Verified (5233 days) | S2 | 5.5.13, 5.5.15 | Linux | Any | external locking corrupted temporary table after alter |
| 61832 | 2011-07-12 10:58 | 2011-07-12 11:19 | MySQL Server: DML | Not a Bug (5219 days) | S3 | Linux | Any | No error message shown, though there is no column entry as 5 in table | |
| 61942 | 2011-07-21 12:53 | 2011-07-21 14:51 | MySQL Server: DML | Not a Bug (5210 days) | S5 | mysql 5.5 | Linux | Any | Mysql command to modify the unique index of a table |
| 62053 | 2011-08-02 4:14 | 2011-08-02 4:22 | MySQL Server: DML | Not a Bug (5198 days) | S1 | 5.5 | Any | Any | columns in SELECT clause not affected by group fn must be declared in GROUP BY |
| 62097 | 2011-08-05 18:18 | 2011-08-05 19:32 | MySQL Server: DML | Duplicate (5195 days) | S1 | 5.5 | Windows (xp) | Any | unable to run a select statement |
| 62147 | 2011-08-11 12:05 | 2011-08-23 19:19 | MySQL Server: DML | Not a Bug (5177 days) | S2 | 5.5.8 | Any | Any | LEFT JOIN generating HUGE temp_table (very slow of course) |
| 62282 | 2011-08-28 21:52 | 2012-05-31 17:31 | MySQL Server: DML | Closed (4895 days) | S5 | 5.5, 5.1, ... | Any | Any | LOCK_thread_count is used for random functions |
| 62320 | 2011-09-01 11:23 | 2011-09-01 21:35 | MySQL Server: DML | Verified (5168 days) | S2 | 5.5.15 | Any | Any | InnoDB and MyISAM show different LAST_INSERT_ID()/AUTO_INCREMENT behaviour |
| 62325 | 2011-09-01 17:45 | 2011-11-14 10:37 | MySQL Server: DML | Not a Bug (5094 days) | S3 | 5.5.8 MySQL Community Server (GPL) | Windows (Windows 7) | Any | LOAD DATA not loading NULL values properly |
| 62331 | 2011-09-02 15:56 | 2011-09-02 21:08 | MySQL Server: DML | Not a Bug (5167 days) | S1 | 5.0.77-log | Windows | Any | Error "duplicate entry" in command REPLACE INTO |
| 62350 | 2011-09-05 12:13 | 2013-07-17 13:44 | MySQL Server: DML | Verified (5162 days) | S2 | 5.5/5.1 | Any | Any | mysql_stmt_result_metadata() returns invalid metadata on EXPLAIN, can crash PHP |
| 62359 | 2011-09-06 7:35 | 2012-02-17 1:00 | MySQL Server: DML | No Feedback (5000 days) | S1 | 5.1.36 | Solaris | Any | ERROR 2005 (HY000): Unknown MySQL server host |
| 62372 | 2011-09-07 11:48 | 2018-02-11 14:17 | MySQL Server: DML | Closed (2813 days) | S3 | 5.5.15, 5.5.17 | Any | Any | Wrong query results with SQL_CALC_FOUND_ROWS, GROUP BY, LIMIT and Using index |
| 62447 | 2011-09-16 2:27 | 2011-09-16 6:00 | MySQL Server: DML | Not a Bug (5153 days) | S3 | mysql-5.5.15-win32 | Windows (windows xp) | Any | regexp Return error results |
| 62495 | 2011-09-22 0:38 | 2011-09-22 11:18 | MySQL Server: DML | Not a Bug (5147 days) | S2 | 5.1.44 | MacOS (10.6.8) | Any | Discrepant results when using UNION and COUNT |
| 62526 | 2011-09-24 0:53 | 2011-10-24 23:00 | MySQL Server: DML | No Feedback (5115 days) | S1 | 5.1.49-1ubuntu8.1 (Ubuntu) | Any | Any | MySQL failed to parse Subquery with wrong column name |
| 62552 | 2011-09-27 16:33 | 2011-09-27 16:36 | MySQL Server: DML | Can't repeat (5142 days) | S2 | Any | Any | Erro ao executar script | |
| 62554 | 2011-09-27 17:23 | 2011-09-28 13:14 | MySQL Server: DML | Not a Bug (5141 days) | S3 | 5.1.56-log | Any | Any | Update bug |
| 62580 | 2011-09-30 6:43 | 2011-09-30 17:47 | MySQL Server: DML | Not a Bug (5139 days) | S3 | 5.5.8 | Any | Any | Allow insert null |
| 62584 | 2011-09-30 9:31 | 2012-01-24 10:23 | MySQL Server: DML | Won't fix (5023 days) | S3 | 5.5.17 | Any | Any | PI()+0.000000000000000000 returns differenct value between 5.1 and 5.5. |
| 62615 | 2011-10-04 9:01 | 2012-01-27 1:00 | MySQL Server: DML | No Feedback (5021 days) | S2 | 5.1.52 | Other (CenTOs 2.6.32-71.29.1.e.l6.i686) | Any | limit and order by do not work properly when used together |
| 62656 | 2011-10-07 18:07 | 2012-01-27 1:00 | MySQL Server: DML | No Feedback (5021 days) | S2 | 5.5.16 | Windows (sever 2003 32 bit) | Any | mysqldump losing connection on Big tables: Lost connection to MySQL server |
| 62755 | 2011-10-16 2:59 | 2011-11-23 12:51 | MySQL Server: DML | Duplicate (5085 days) | S3 | 5.5.16; 5.1.59 | Windows (XP SP3) | Any | Unexpect "ERROR 1062 (23000): Duplicate entry '...' for key 'group_key'" error |
| 62838 | 2011-10-20 4:32 | 2011-10-20 11:24 | MySQL Server: DML | Not a Bug (5119 days) | S3 | 5.5 | Windows (Vista) | Any | Bit wise operations return incorrect result |
| 62843 | 2011-10-20 11:25 | 2019-11-06 20:52 | MySQL Server: DML | Verified (5114 days) | S3 | any | Any | Any | bin() function and "Bit functions" |
| 62940 | 2011-10-26 6:51 | 2012-12-24 9:32 | MySQL Server: DML | Duplicate (4688 days) | S2 | 5.1.39, 5.5.10, 5.5.20 | Any (Linux, Mac OS X) | Any | SELECT results vary with version and with/without index range scan |
| 62949 | 2011-10-26 18:36 | 2011-11-03 12:17 | MySQL Server: DML | Verified (5112 days) | S2 | 5.5.17 | Linux (CentOS 5.7) | Any | Multiple DELETE permission bug |
| 63037 | 2011-10-31 13:59 | 2019-11-06 21:42 | MySQL Server: DML | Not a Bug (2180 days) | S3 | 5.5.17 | Linux (Ubuntu 11.04) | Any | Greater-than operator returns unexpected result with text-field |
| 63046 | 2011-10-31 20:12 | 2011-10-31 20:27 | MySQL Server: DML | Not a Bug (5108 days) | S2 | MS sql server 9.00 | Windows | Any | update in mysql - please help |
| 63055 | 2011-11-01 11:45 | 2014-01-28 12:32 | MySQL Server: DML | Closed (4364 days) | S3 | 5.5.17, 5.5.20 | Linux | Any | mysql assumes all ethernet devices are named ethX |
| 63371 | 2011-11-21 22:29 | 2011-12-22 17:54 | MySQL Server: DML | Won't fix (5056 days) | S3 | 5.1.59, 5.1.61 | Any | Any | Invalid sort ordering in 5.1, innodb composite pkeys joined to subqueries |
| 63376 | 2011-11-22 8:16 | 2017-06-08 14:33 | MySQL Server: DML | Verified (5085 days) | S3 | 5.1.52, 5.5.17 | Any (-enterprise-commercial-pro) | Any | CONVERT_TZ should fail on empty mysql.time_zone table, currently it returns NULL |
| 63437 | 2011-11-26 14:10 | 2012-01-27 19:30 | MySQL Server: DML | Closed (5020 days) | S2 | 5.1, 5.5 | Any | Any | CHAR & BETWEEN with index returns wrong result after MySQL 5.1. |
| 63439 | 2011-11-26 17:19 | 2016-11-09 14:00 | MySQL Server: DML | Verified (5080 days) | S3 | 5.5.8, 5.1.60 | Any (Windows 7, Mac OS X) | Any | REGEXP does not work properly with umlauts |
| 63514 | 2011-12-01 5:52 | 2011-12-01 5:57 | MySQL Server: DML | Not a Bug (5077 days) | S2 | 5.5.31 | Windows | Any | select count(*), column_name from table gives inconsistant result |
| 63536 | 2011-12-02 8:16 | 2011-12-02 20:05 | MySQL Server: DML | Not a Bug (5076 days) | S3 | Any | Any | Possible bug in function current_date( ) | |
| 63607 | 2011-12-05 16:56 | 2011-12-05 16:57 | MySQL Server: DML | Can't repeat (5073 days) | S3 | Any | Any | Bug tnmjdfmhdf | |
| 63668 | 2011-12-08 13:21 | 2018-02-11 22:48 | MySQL Server: DML | Not a Bug (2813 days) | S3 | 5.5.13, 5.5.17 | Linux | Any | ROUND(x,d) doesn't round a value to "d" digits when "d" is passed as column |
| 63686 | 2011-12-08 21:58 | 2012-01-09 7:00 | MySQL Server: DML | No Feedback (5038 days) | S2 | 5.0.45-community | Linux (Red Hat) | Any | Nested LEFT JOIN returns invalid results |
| 63747 | 2011-12-14 14:43 | 2011-12-14 14:50 | MySQL Server: DML | Not a Bug (5064 days) | S3 | 5.1.41 | Linux (mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1) | Any | UPDATE test SET a = a+b, b = a+b |
| 63785 | 2011-12-18 4:53 | 2012-01-19 1:00 | MySQL Server: DML | No Feedback (5029 days) | S3 | 5.5 | Windows (7) | Any | select from database that I granted permissions immediately before |
| 63829 | 2011-12-21 19:34 | 2024-04-19 21:56 | MySQL Server: DML | Verified (5056 days) | S3 | 5.1.58, 5.5.20 | Any | Any | Search containig backslash doesn't work if field collation is utf8_unicode_ci |
| 63897 | 2012-01-02 16:17 | 2012-01-14 10:01 | MySQL Server: DML | Not a Bug (5033 days) | S2 | 5.1.56 | Any | Any | round function problem in update query |
| 64025 | 2012-01-13 14:21 | 2012-01-15 19:15 | MySQL Server: DML | Verified (5034 days) | S3 | 5.1.61, 5.5.15 | Any | Any | ON DUPLICATE KEY UPDATE sets auto_increment column value to 0 |
| 64054 | 2012-01-17 20:46 | 2012-01-18 5:15 | MySQL Server: DML | Duplicate (5029 days) | S1 | 5.5.19 | Linux (i686 2.6.18) | Any | Double negation (!!) not working in 5.5.19 |
| 64088 | 2012-01-20 19:18 | 2012-01-20 19:33 | MySQL Server: DML | Not a Bug (5027 days) | S1 | all | Linux | Any | no select works against a view created with limit (x) |
| 64150 | 2012-01-27 17:46 | 2012-03-26 18:09 | MySQL Server: DML | Can't repeat (4961 days) | S5 | 5.1.52 | Any | Any | performance drops with glibc 2.13 when threads are created |
| 64176 | 2012-01-31 9:43 | 2012-02-14 16:22 | MySQL Server: DML | Not a Bug (5002 days) | S3 | 5.1.54 | Any | Any | Sorting issue in a formatted datetime |
| 64247 | 2012-02-07 10:08 | 2019-11-06 21:28 | MySQL Server: DML | Closed (2180 days) | S2 | 5.5.18, 5.5.21 | Any | Any | Abnormal behaviour of str_to_date() function |
| 64274 | 2012-02-09 9:42 | 2012-04-09 16:29 | MySQL Server: DML | Closed (4947 days) | S1 | 5.6.4m7 | Any | Any | MySQL thread was suspended when execute UPDATE query |
| 64290 | 2012-02-10 6:24 | 2012-02-10 15:41 | MySQL Server: DML | Not a Bug (5006 days) | S3 | 5.5.15 | Windows | Any | INSERT ON DUPLICATE KEY UPDATE can't work with primary key value equals zero |
| 64298 | 2012-02-10 20:24 | 2015-08-30 17:06 | MySQL Server: DML | Verified (5005 days) | S3 | 5.1.59, 5.5.20 | Any | Any | ascii does not work on multibyte characters |
| 64301 | 2012-02-11 13:54 | 2012-02-17 17:51 | MySQL Server: DML | Duplicate (4999 days) | S3 | Any | Any | Wrong row count returned with 'NO_AUTO_VALUE_ON_ZERO' sql_mode | |
| 64516 | 2012-03-01 19:23 | 2012-03-01 20:36 | MySQL Server: DML | Not a Bug (4986 days) | S2 | 5.1.47 | Any | Any | CURDATE() -1 on 1 March of leap year |
| 64524 | 2012-03-02 13:48 | 2012-03-02 14:21 | MySQL Server: DML | Not a Bug (4985 days) | S3 | 5.5.19 x64 | Linux (Ubuntu 11.10 x86_64) | Any | Incorrect order when quoting an ORDER BY aliased column. |
| 64526 | 2012-03-02 17:27 | 2012-03-06 8:40 | MySQL Server: DML | Verified (4985 days) | S3 | 5.5.10, 5.5.20 | Windows | Any | bug when truncate() and format() used together |
| 64592 | 2012-03-08 12:42 | 2012-03-09 8:56 | MySQL Server: DML | Can't repeat (4978 days) | S1 | 5.1.52 | Linux (Scientific Linux 6.1) | Any | Select integer query with limit returns 0 results w/ 2 conds but not w/ 3 |
| 64595 | 2012-03-08 23:17 | 2012-04-10 1:00 | MySQL Server: DML | No Feedback (4947 days) | S2 | 5.5 | Linux | Any | som columns in inner joined table not accessible for outer join |
| 64599 | 2012-03-09 7:32 | 2012-03-09 17:40 | MySQL Server: DML | Verified (4978 days) | S3 | 5.0.87, 5.6.5 | Linux | Any | CONVERT_TZ fails to convert from GMT to system_time_zone |
| 64632 | 2012-03-13 10:10 | 2015-01-28 16:17 | MySQL Server: DML | Closed (4968 days) | S1 | 5.1.52 | Windows (Seven 32 bits and XP 64bits) | Any | Cannot insert date '2011-03-27 02:00:00' |
| 64726 | 2012-03-21 19:43 | 2012-03-26 22:32 | MySQL Server: DML | Not a Bug (4961 days) | S3 | 5.1.61 and 5.5.21 | Linux | Any | sub-query not failing when it should be |
| 64747 | 2012-03-23 16:43 | 2012-05-18 1:00 | MySQL Server: DML | No Feedback (4908 days) | S3 | 5.1.56 | Linux (RHEL 5.6) | Any | LOAD DATA INFILE causes server crash on large rows |
| 64751 | 2012-03-24 0:11 | 2014-05-06 16:28 | MySQL Server: DML | Verified (4959 days) | S2 | 5.5.20, 5.6.4, 5.6.5 | Linux (64 bit) | Any | MySQL 5.5+ cannot replicate some statements that are valid in 5.1 |
| 64752 | 2012-03-24 2:58 | 2012-04-02 17:56 | MySQL Server: DML | Not a Bug (4954 days) | S2 | 5.5.21 | Linux (CentOS 5.4) | Any | When trying to restore tables or mysql dump: ERROR 1114 table is full |
| 64765 | 2012-03-26 13:38 | 2019-11-06 21:44 | MySQL Server: DML | Not a Bug (2180 days) | S3 | 5.1.62, 5.5.20 | Any | Any | Strange behavior of GREATEST, when use it in subquery with variables |
| 64769 | 2012-03-26 22:27 | 2012-03-27 7:05 | MySQL Server: DML | Verified (4960 days) | S3 | 5.1.61 | Any (Debian unstable) | Any | comparing indexed ENUM with 0+string constant does not use index properly |
| 64817 | 2012-03-30 16:04 | 2012-03-31 7:32 | MySQL Server: DML | Not a Bug (4956 days) | S3 | 5.1 | Any | Any | INSERT INTO ... VALUES(0,... uses auto_increment value instead |
| 64883 | 2012-04-05 22:35 | 2012-04-09 11:08 | MySQL Server: DML | Verified (4950 days) | S3 | 5.1.61, 5.5.22 | Any (Windows 7 (64 bit), Mac OS X) | Any | ROW_COUNT() returns -1 for LOAD DATA INFILE |
| 65013 | 2012-04-17 18:32 | 2012-04-18 18:45 | MySQL Server: DML | Closed (4938 days) | S3 | 5.1.36, 5.5.22 | Any | Any | Illegal (?) syntax returns different results depending on index in WHERE clause |
| 65017 | 2012-04-17 23:41 | 2012-04-25 8:51 | MySQL Server: DML | Verified (4938 days) | S3 | 5.0, 5.1, 5.5 | Any | Any | Date and time functions are not consistently named |
| 65031 | 2012-04-19 8:24 | 2014-11-08 8:52 | MySQL Server: DML | Not a Bug (4004 days) | S3 | 5.5.21-log, 5.5.23 | Windows (win7 x64) | Any | Expression type BIGINT UNSIGNED |
| 65053 | 2012-04-20 10:52 | 2012-04-26 8:53 | MySQL Server: DML | Can't repeat (4930 days) | S2 | 5.5.21 | Any | Any | Incorrect select results when using index and complicated select count(distinct( |
| 65068 | 2012-04-23 3:31 | 2012-04-24 8:50 | MySQL Server: DML | Not a Bug (4932 days) | S3 | 5.1,5.5 | Any | Any | mysql will return error result while using "case...when" |
| 65185 | 2012-05-03 8:42 | 2012-05-07 7:18 | MySQL Server: DML | Duplicate (4919 days) | S1 | 5.5 | Linux (Ubuntu) | Any | ErrorCode 1379: View's SELECT still can't contain a subquery |
| 65238 | 2012-05-08 10:13 | 2012-06-11 1:00 | MySQL Server: DML | No Feedback (4885 days) | S3 | 5.6.2-m5-log | Any | Any | Incorrect return values in IF and CASE statements |
| 65243 | 2012-05-08 17:50 | 2020-01-08 22:51 | MySQL Server: DML | Can't repeat (2117 days) | S5 | 5.6.4 | Windows | Any | Substring function very slow for longer strings |
| 65305 | 2012-05-13 21:06 | 2012-05-24 3:10 | MySQL Server: DML | Can't repeat (4902 days) | S5 | 5.1.63 | Any | Any | INSERT INTO NULL BUG |
| 65307 | 2012-05-14 4:02 | 2012-05-14 13:20 | MySQL Server: DML | Not a Bug (4912 days) | S3 | 5.5 | Any | Any | Problem with order by and limit offset |
| 65375 | 2012-05-20 22:46 | 2012-06-22 1:00 | MySQL Server: DML | No Feedback (4874 days) | S2 | 5.5.16 | Windows | Any | INSERT-SELECT inserts only last row from SELECT statement |
| 65529 | 2012-06-06 5:56 | 2012-06-08 3:57 | MySQL Server: DML | Can't repeat (4887 days) | S2 | 5.5.15 | Any | Any | Any table trigger breaks multiple insert statement into single statements. |
| 65706 | 2012-06-22 7:42 | 2013-01-10 12:16 | MySQL Server: DML | Can't repeat (4671 days) | S1 | 5.5.24, 5.5.27, 5.1.65, 5.0.97 | Linux (Ubuntu 12.04) | Any | SELECT statement used to create a view works, selecting from the view -> ER 1356 |
| 65763 | 2012-06-28 15:16 | 2018-02-12 22:20 | MySQL Server: DML | Not a Bug (2812 days) | S3 | 5.1.64, 5.5 | Any | Any | COALESCE(), UNION truncates padding on zero-filled values |
| 65766 | 2012-06-29 7:08 | 2012-07-30 1:00 | MySQL Server: DML | No Feedback (4836 days) | S5 | Windows | Any | insert/update | |
| 65798 | 2012-07-03 15:16 | 2012-11-14 20:54 | MySQL Server: DML | Closed (4728 days) | S3 | 5.5.26 | Any | Any | ONLY_FULL_GROUP_BY documentation doesn't mention implicit group by |
| 65808 | 2012-07-04 11:27 | 2012-07-04 14:06 | MySQL Server: DML | Not a Bug (4861 days) | S1 | 5.1.62 | Linux | Any | Minimum value is incorrect. |
| 65846 | 2012-07-08 18:17 | 2016-09-09 11:23 | MySQL Server: DML | Won't fix (3333 days) | S3 | 5.1.63, 5.5.25, 5.5.26 | Any | Any | INSERT DELAYED on a BLACKHOLE table hangs forever |
| 65849 | 2012-07-09 10:09 | 2012-07-09 14:47 | MySQL Server: DML | Not a Bug (4856 days) | S3 | 5.5.24 | Linux (Ubuntu 12.04) | Any | LAST_INSERT_ID() returns multiple rows under certain circumstances |
| 65860 | 2012-07-10 5:48 | 2013-12-11 6:44 | MySQL Server: DML | Closed (4336 days) | S1 | 5.1,5.5,5.6 | Linux | Any | mysqld was crashed wihile using filesort |
| 65902 | 2012-07-15 16:27 | 2012-09-30 11:03 | MySQL Server: DML | Closed (4773 days) | S3 | 5.1.48, 5.5.26 | Any | Any | Incorrect Semantics for "> ALL" when NULL in sub query |
| 65936 | 2012-07-18 12:49 | 2015-07-13 16:51 | MySQL Server: DML | Closed (3757 days) | S2 | 5.5.24, 5.5.26 | Any | Any | wrong results on table left join view |
| 65970 | 2012-07-20 21:50 | 2012-07-23 10:02 | MySQL Server: DML | Verified (4844 days) | S3 | 5.5.19, 5.5.26 | Any | Any | AVG group function when dealing with maximum number give wrong results |
| 65976 | 2012-07-21 18:11 | 2013-10-15 18:31 | MySQL Server: DML | Closed (4393 days) | S3 | 5.5.25a, 5.5.26 | Any | Any | SELECT IFNULL(NULL, ~1) returns incorrect value |
| 65983 | 2012-07-23 10:41 | 2012-08-24 1:00 | MySQL Server: DML | No Feedback (4811 days) | S2 | 5.1.40 | Linux | Any | a executing subquery , never stop |
| 66148 | 2012-08-01 22:53 | 2018-02-13 22:14 | MySQL Server: DML | Closed (2811 days) | S3 | 5.1.32, 5.1.61, 5.1.63, 5.1.66 | MacOS (10.5) | Any | incorrect 'data truncated' warning when inserting into decimal field |
| 66154 | 2012-08-02 9:21 | 2012-08-10 16:04 | MySQL Server: DML | Verified (4832 days) | S3 | 5.0, 5.5, 5.5.28 | Any | Any | CONVERT_TZ using Etc/GMT zones gives wrong result |
| 66178 | 2012-08-03 7:27 | 2014-12-23 12:45 | MySQL Server: DML | Not a Bug (3959 days) | S2 | 5.5.16, 5.5.25, 5.1.36, 5.5.28 | Any | Any | STR_TO_DATE and YEARWEEK inconsistencies |
| 66198 | 2012-08-04 8:04 | 2012-08-04 8:58 | MySQL Server: DML | Not a Bug (4830 days) | S2 | 5.1.61 | Linux (Cent OS) | Any | Date Manipulation |
| 66240 | 2012-08-07 9:57 | 2012-08-09 9:04 | MySQL Server: DML | Closed (4825 days) | S3 | 5.5.25a | Windows (Win2k3) | Any | incorrect datetime value trying to insert valid date |
| 66513 | 2012-08-23 10:14 | 2012-08-31 15:37 | MySQL Server: DML | Closed (4803 days) | S3 | 5.1.65, 5.1.66 | Any | Any | Debug build fails assertion in records_in_range() |
| 66537 | 2012-08-25 14:33 | 2012-08-28 6:34 | MySQL Server: DML | Verified (4809 days) | S2 | 5.0.96. 5.1.63, 5.5.23, 5.6.5 | Any | Any | BOM problem |
| 66659 | 2012-09-03 3:37 | 2012-09-05 16:49 | MySQL Server: DML | Not a Bug (4798 days) | S2 | 5.6.6 | Any (XP and Linux) | Any | mysql 5.6.6m9 fails on OPTION SQL_SELECT_LIMIT=DEFAULT |
| 66663 | 2012-09-03 10:03 | 2016-04-19 22:19 | MySQL Server: DML | Not a Bug (4800 days) | S2 | 5.5.27 | Linux | Any | DELETE has wrong scope in SUBSELECT |
| 66720 | 2012-09-06 8:03 | 2012-09-09 16:24 | MySQL Server: DML | Verified (4797 days) | S3 | 5.5.24-0ubuntu0.12.04.1, 5.5.29, 5.0.95, 5.1.66, 5.7.0 | Linux (Ubuntu 12.04) | Any | Regexp problem |
| 66794 | 2012-09-13 2:39 | 2012-09-13 14:53 | MySQL Server: DML | Verified (4790 days) | S3 | 5.1.63/5.5.29 | Linux (Ubuntu 32bit) | Any | Column metadata inconsistent when used against a View |
| 66915 | 2012-09-21 17:57 | 2012-10-12 3:12 | MySQL Server: DML | Duplicate (4761 days) | S3 | 5.5.27 | Linux | Any | Replication thread crashes server on specific query |
| 67014 | 2012-09-28 22:10 | 2015-07-13 16:51 | MySQL Server: DML | Closed (3757 days) | S2 | 5.5.27, 5.5.67, 5.0.97, 5.1.67, 5.7.1 | Windows (7, 64-bit) | Any | View evaluation is incorrect when joining to view that selects a literal |
| 67022 | 2012-09-30 11:38 | 2012-10-04 21:29 | MySQL Server: DML | Not a Bug (4769 days) | S2 | 5.6.7 | Any | Any | EXPLAIN EXTENDED FORMAT= .. not allowed |
| 67064 | 2012-10-03 3:36 | 2018-02-13 22:39 | MySQL Server: DML | Can't repeat (2811 days) | S5 | since 5.5.24 and new versions | Any | Any | SQL Query Execution from Batch files is now really slow, since 5.5.24 and new. |
| 67259 | 2012-10-16 10:21 | 2013-07-08 12:08 | MySQL Server: DML | Can't repeat (4492 days) | S2 | 5.5.27, 5.5.28 | Linux ( 2.6.35.14-106.fc14.x86_64) | Any | MySQL 5.5.x uses more memory than 5.1.x when temporary tables are used |
| 67300 | 2012-10-19 14:29 | 2015-07-13 16:57 | MySQL Server: DML | Closed (3757 days) | S3 | 5.5.14-log, 5.0.97, 5.1.67, 5.5.30, 5.7.1 | Any (MS Windows Pro 7, Linux) | Any | table left join view, unmatched rows problem where view contains an if |
| 67394 | 2012-10-27 9:08 | 2012-12-22 12:46 | MySQL Server: DML | Duplicate (4690 days) | S1 | 5.5.17, 5.5.24 | Linux | Any | infinite 100% cpu hang on load data local infile |
| 67529 | 2012-11-09 0:20 | 2017-01-09 18:55 | MySQL Server: DML | Verified (4733 days) | S3 | 5.1.41, 5.1.67, 5.5.29, 5.7.0 | Any | Any | GROUP BY treats +0 and -0 as different values |
| 67535 | 2012-11-09 13:41 | 2014-02-03 0:33 | MySQL Server: DML | Verified (4722 days) | S3 | 5.0.97, 5.1.67, 5.5.29, 5.7.0 | Any (MS Windows, Linux) | Any | LAST_INSERT_ID() and INSERT IGNORE behavior |
| 67541 | 2012-11-09 17:30 | 2012-11-09 18:06 | MySQL Server: DML | Verified (4733 days) | S3 | 5.5.28 | Any | Any | LOAD XML cannot load data from mysqldump --xml |
| 67542 | 2012-11-09 17:39 | 2015-08-18 16:43 | MySQL Server: DML | Closed (3721 days) | S3 | 5.5.28, 5.7.0 | Any | Any | LOAD XML does not handle empty elements |
| 67578 | 2012-11-13 17:19 | 2013-03-26 5:58 | MySQL Server: DML | Closed (4596 days) | S2 | 5.5.8, 5.0.96, 5.1.67, 5.5.29, 5.7.0 | Any (MS Windows Vista, Linux) | Any | in ELT of LEAST of FLOOR of NULL NULL is not passed on but ignored, as if MIN |
| 67580 | 2012-11-13 21:57 | 2018-02-13 22:53 | MySQL Server: DML | Closed (2811 days) | S3 | 5.5.28, 5.5.30, 5.1.67, 5.0.97 | Linux (sles11) | Any | group_concat() limited to 64kb on compress()'ed fields when order by is used |
| 67631 | 2012-11-19 11:52 | 2015-03-09 19:03 | MySQL Server: DML | Closed (3883 days) | S3 | 5.0.97, 5.1.67, 5.5.29, 5.7.0 | Any | Any | Subquery in view works slower than if run without view |
| 67632 | 2012-11-19 12:05 | 2020-11-12 14:54 | MySQL Server: DML | Not a Bug (2811 days) | S3 | 5.6.8, 5.7.0 | Any | Any | explain select 1 from (select sleep(10) from dual) as t1; runs 10 seconds in 5.6 |
| 67687 | 2012-11-23 19:40 | 2012-11-25 19:19 | MySQL Server: DML | Closed (4717 days) | S3 | 5.5.15 | Windows (x64) | Any | SQL string literal incorrect handling |
| 67732 | 2012-11-27 19:49 | 2019-11-11 9:44 | MySQL Server: DML | Closed (2175 days) | S2 | 5.5.8, 5.5.30, 5.7.1, 5.0.97, 5.1.67 | Windows (Vista) | Any | WHERE var IS NOT TRUE yields too little |
| 67791 | 2012-12-03 2:54 | 2016-08-05 3:18 | MySQL Server: DML | Closed (3840 days) | S2 | 5.5.25a, 5.1.67, 5.5.30, 5.6.8 | Linux (64-bit, w/InnoDB 1.1.8) | Any | Create View succeeds, but adds invalid parentheses |
| 67800 | 2012-12-04 7:23 | 2018-02-13 23:02 | MySQL Server: DML | Can't repeat (2811 days) | S3 | 5.5.27-log | Windows | Any | INSERT...SELECT WHERE clause "Incorrect integer value" with multi-col unique key |
| 67821 | 2012-12-05 22:37 | 2013-01-07 1:00 | MySQL Server: DML | No Feedback (4675 days) | S3 | 5.5.28 | Windows (7 Ultimate 64bit) | Any | GROUP BY not working in stored procedure |
| 67863 | 2012-12-10 16:24 | 2020-10-07 13:48 | MySQL Server: DML | Closed (1844 days) | S3 | 5.1, 5.5, 5.6 | Any | Any | INSERT INTO view_name () VALUES () fails with ER_WRONG_VALUE_COUNT_ON_ROW |
| 68041 | 2013-01-06 3:29 | 2013-07-19 15:02 | MySQL Server: DML | Closed (4481 days) | S3 | 5.6.9 | Any | Any | Zero date can be inserted in strict no-zero mode through a default value |
| 68145 | 2013-01-22 17:15 | 2017-01-03 15:07 | MySQL Server: DML | Verified (4659 days) | S2 | 5.5.29, 5.0.97, 5.1.69, 5.5.31, 5.7.1 | Any | Any | GROUP_CONCAT with DISTINCT could return wrong result when rb-trees are on disk |
| 68153 | 2013-01-23 11:40 | 2017-07-06 14:30 | MySQL Server: DML | Won't fix (3033 days) | S3 | 5.5.29, 5.0.97, 5.1.69, 5.5.31, 5.7.1 | Linux | Any | REGEXP does not seem to match the NUL character |
| 68265 | 2013-02-05 1:55 | 2013-02-05 3:01 | MySQL Server: DML | Not a Bug (4645 days) | S3 | 5.6 | Linux (Ubuntu Linux 3.2.0-30-generic x86_64) | Any | Inconsistent behavior "INT NOT NULL" column inserting "NULL" |
| 68310 | 2013-02-07 21:56 | 2013-02-08 10:12 | MySQL Server: DML | Not a Bug (4642 days) | S2 | 5.5.28 | Linux (ubuntu/debian 64bit) | Any | Unexpected behaviour with variables in where clause |
| 68339 | 2013-02-11 17:09 | 2013-02-11 20:06 | MySQL Server: DML | Verified (4639 days) | S3 | 5.1, 5.5, 5.6 | Linux | Any | ENCRYPT() with empty string for password doesn't work as system crypt() |
| 68360 | 2013-02-13 10:36 | 2013-02-15 18:02 | MySQL Server: DML | Verified (4635 days) | S3 | 5.5.28, 5.0.97, 5.1.69, 5.5.31, 5.7.0 | Any | Any | Duplicate entry for key while updating |
| 68439 | 2013-02-20 2:35 | 2018-03-08 23:39 | MySQL Server: DML | Can't repeat (2788 days) | S2 | 5.1 | Any | Any | Unsigned INTs underflow in case of math |
| 68446 | 2013-02-20 23:36 | 2013-02-22 14:56 | MySQL Server: DML | Closed (4628 days) | S3 | 5.5.29 | Any | Any | insert on duplicate key update with null autoincremented PK uses wrong pk value |
| 68454 | 2013-02-21 9:52 | 2013-03-04 15:30 | MySQL Server: DML | Closed (4618 days) | S1 | 5.6.11 | Any | Any | Using inet6_ntoa and int6_aton to convert IP causes errors |
| 68529 | 2013-02-28 20:43 | 2018-03-08 23:44 | MySQL Server: DML | Closed (2788 days) | S1 | 5.0/5.1/5.5 | Linux (gentoo/i686) | Any | GROUP_CONCAT(.... ORDER BY ...) prevents ORDER BY if using a VIEW |
| 68705 | 2013-03-18 15:36 | 2019-11-11 10:59 | MySQL Server: DML | Can't repeat (2175 days) | S3 | 5.5.30, 5.6.10, 5.6.12, 5.7.2, 5.1.70, 5.0.97, 5.5.32 | Any | Any | Valgrind warnings (uninitialised value(s)) in Item_field::val on SELECT INTERVAL |
| 68706 | 2013-03-18 18:51 | 2018-04-11 12:11 | MySQL Server: DML | Can't repeat (2754 days) | S3 | 5.6.10, 5.6.12, 5.7.2, 5.5.32, 5.1.70 | Any | Any | Valgrind warnings (uninitialised value(s)) in hp_search with UNCOMPRESSED_LENGTH |
| 68726 | 2013-03-20 11:22 | 2014-07-14 15:28 | MySQL Server: DML | Closed (4121 days) | S3 | 5.5.30 and 5.6.10, 5.1.70, 5.5.32, 5.6.12 | Windows | Any | Update trigger invoked when update ignore means that no update is performed |
| 68762 | 2013-03-25 10:25 | 2013-03-25 11:20 | MySQL Server: DML | Duplicate (4597 days) | S2 | 5.6.10 | Windows | Any | Got error -1 from storage engine |
| 68819 | 2013-03-30 15:44 | 2013-04-02 6:56 | MySQL Server: DML | Can't repeat (4589 days) | S3 | 5.0.77 | Linux | Any | DATE_FORMAT returns empty result |
| 68846 | 2013-04-03 6:56 | 2013-04-03 7:35 | MySQL Server: DML | Duplicate (4588 days) | S3 | Mysql server 5.1 | Any | Any | how to create Bad file in LOAD DATA INFILE in mysql |
| 68934 | 2013-04-11 14:21 | 2013-04-11 20:21 | MySQL Server: DML | Verified (4580 days) | S3 | 5.6.10 | Any | Any | extractValue does not work correctly with xpath last() |
| 68993 | 2013-04-18 6:51 | 2013-04-19 8:03 | MySQL Server: DML | Not a Bug (4572 days) | S3 | 5.5.15 | Linux | Any | SET IN UPDATE TABLE |
| 69138 | 2013-05-03 16:10 | 2013-07-01 16:39 | MySQL Server: DML | Closed (4499 days) | S5 | 5.7, 5.6 | Any | Any | Wasted work in method Item_in_subselect::single_value_transformer |
| 69144 | 2013-05-04 5:53 | 2013-05-04 10:55 | MySQL Server: DML | Duplicate (4557 days) | S2 | 5.6.11 | Any | Any | sql_calc_found_rows, found_rows() in 5.6.11 differs from 5.6.10 |
| 69186 | 2013-05-09 15:47 | 2013-06-21 6:45 | MySQL Server: DML | Not a Bug (4509 days) | S5 | 5.6, 5.7 | Any | Any | Wasted work in method test_rewind |
| 69202 | 2013-05-11 16:40 | 2014-11-09 22:58 | MySQL Server: DML | Closed (4003 days) | S3 | 5.5, 5.6, 5.7 | Any | Any | Valgrind warnings in inflate on UNCOMPRESS |
| 69271 | 2013-05-17 16:14 | 2013-06-05 17:13 | MySQL Server: DML | Closed (4525 days) | S1 | 5.6.x | Any | Any | Wrong count from FOUND_ROWS() with ORDER BY |
| 69273 | 2013-05-17 21:31 | 2013-06-21 1:00 | MySQL Server: DML | No Feedback (4510 days) | S1 | 5.5.28-29.3-log | Linux (by sitegrounds.com) | Any | SQL Server 2008 R2 DTS sends data to MySQL 5.5 "MySQL Server Gone Away" |
| 69287 | 2013-05-20 13:54 | 2013-05-21 8:05 | MySQL Server: DML | Not a Bug (4540 days) | S3 | 5.0.96,5.5.x, 5.6.11 | Any (Tested on Mac OSX 10.8 and CentOS 5.x) | Any | Subtracting "NOW() - SOME_TIME" from "NOW()" returns wrong results |
| 69310 | 2013-05-23 11:47 | 2018-03-14 20:45 | MySQL Server: DML | Verified (4538 days) | S3 | 5.6, 5.0.97, 5.1.70, 5.5.32, 5.6.12, 5.7.2 | Any | Any | Valid SQL statement rejected in ONLY_FULL_GROUP_BY |
| 69319 | 2013-05-25 18:08 | 2013-05-27 9:04 | MySQL Server: DML | Can't repeat (4534 days) | S2 | 5.6.11-embedded | Windows | Any | SELECT with LEFT JOIN return 0 - records |
| 69368 | 2013-05-31 20:36 | 2013-10-11 16:23 | MySQL Server: DML | Closed (4397 days) | S5 | 5.6.6 | Any | Any | performance regression in 5.6.6+ for insert into .... select ... from |
| 69431 | 2013-06-08 12:19 | 2014-08-15 16:09 | MySQL Server: DML | Verified | S3 | 5.6.12 | Windows | Any | wrong ER_INSERT_INFO "Records: %ld Duplicates: %ld Warnings: %ld" |
| 69470 | 2013-06-14 9:33 | 2013-06-14 13:08 | MySQL Server: DML | Duplicate (4516 days) | S3 | 5.6.10 | Linux | Any | Use "group by", but no aggregate function, get weird result |
| 69521 | 2013-06-20 8:57 | 2013-06-26 21:32 | MySQL Server: DML | Duplicate (4504 days) | S2 | 5.6 | Any | Any | incorrect result of left join with additional condition |
| 69590 | 2013-06-26 15:59 | 2018-03-14 20:53 | MySQL Server: DML | Closed (2782 days) | S3 | 5.5.32 | Any | Any | Problem using between with group by functions |
| 69602 | 2013-06-27 13:05 | 2018-05-03 12:58 | MySQL Server: DML | Not a Bug (2732 days) | S3 | 5.6.12-community | Any (Ubuntu 12.04 x86_64) | Any | Poor index optimization/selection using LEFT JOIN ( SELECT ) subquery |
| 69647 | 2013-07-02 12:04 | 2018-04-12 14:27 | MySQL Server: DML | Closed (2753 days) | S3 | 5.6.10 | Any | Any | DO syntax turns error signal into a warning |
| 69648 | 2013-07-02 16:04 | 2013-07-15 7:37 | MySQL Server: DML | Verified (4485 days) | S3 | 5.6.12 | Any | Any | Subselect of literals in FROM throws "Duplicate column name" error |
| 69670 | 2013-07-04 11:37 | 2013-07-05 1:04 | MySQL Server: DML | Verified (4495 days) | S1 | 5.5.31/5.5.32 | Linux (Debian ) | Any | Dependent subquery with ORDER BY returns empty string |
| 69684 | 2013-07-07 10:44 | 2014-06-02 14:33 | MySQL Server: DML | Closed (4176 days) | S2 | 5.5, 5.6 | Any | Any | The update and select behave differently under the same conditions. |
| 69685 | 2013-07-07 20:40 | 2018-03-14 21:07 | MySQL Server: DML | Closed (2782 days) | S3 | 5.5.31 | Linux | Any | STDDEV_SAMP() changes to STD() when used in a view |
| 69705 | 2013-07-10 0:04 | 2013-07-10 13:08 | MySQL Server: DML | Verified (4490 days) | S3 | 5.6 | Any | Any | Strange fractional seconds |
| 69774 | 2013-07-18 4:00 | 2018-05-05 14:44 | MySQL Server: DML | Closed (2730 days) | S3 | 5.1.71, 5.5.32 | Any | Any | Defining a view with case statement and having statement cause error1356 |
| 69916 | 2013-08-03 10:10 | 2015-01-13 14:39 | MySQL Server: DML | Verified (3938 days) | S3 | 5.5+ | Any | Any | COT() does not behave as expected |
| 70165 | 2013-08-27 14:58 | 2013-12-10 19:28 | MySQL Server: DML | Not a Bug (4337 days) | S2 | Ver 14.14 Distrib 5.6.12 | MacOS | Any | Cannot Perform Partial INSERT INTO View When SELECT Priv is Removed |
| 70202 | 2013-08-30 15:36 | 2013-09-02 11:53 | MySQL Server: DML | Verified (4436 days) | S3 | 5.5, 5.6 | Any | Any | REPLACE working differently for a table having PK or UK only versus both PK+UK |
| 70413 | 2013-09-25 7:07 | 2020-03-12 6:27 | MySQL Server: DML | Verified (4405 days) | S3 | 5.5.31, 5.5.34, 5.6.14 | Linux (Debian Wheezy v7.1) | Any | \d is not working in REGEXP for a MySQL query |
| 70416 | 2013-09-25 10:49 | 2013-12-28 9:04 | MySQL Server: DML | Not a Bug (4319 days) | S3 | 5.6.14-log | Windows (8) | Any | consistent bracket syntax with INSERT and DELETE |
| 70444 | 2013-09-26 21:57 | 2013-12-02 13:57 | MySQL Server: DML | Verified (4345 days) | S3 | 5.5.31 | Any | Any | MyISAM engine doesnt use index for count(distinct field) query |
| 70470 | 2013-09-30 15:24 | 2018-04-13 15:22 | MySQL Server: DML | Closed (2752 days) | S3 | 5.1.72,5.6.14,5.5.34,5.7.2 | Any | Any | REGEXP fails to find matches after NUL character |
| 70472 | 2013-09-30 19:50 | 2013-10-01 11:33 | MySQL Server: DML | Verified (4407 days) | S3 | 5.5.32-0ubuntu0.12.04.1, 5.5.34, 5.6.14 | Linux | Any | SQL_SAFE_UPDATES does not work properly with WHERE primary_key IN clauses |
| 70528 | 2013-10-04 21:59 | 2019-11-12 21:40 | MySQL Server: DML | Closed (2174 days) | S3 | 5.5.31, 5.1.72,5.5.34,5.6.14,5.7.2-m12 | Any | Any | Incorrect truncation of SUBSTRING_INDEX's third argument |
| 70622 | 2013-10-15 10:33 | 2014-03-04 16:07 | MySQL Server: DML | Closed (4253 days) | S3 | all | Any | Any | error result when use between...and againest bigint unsigned |
| 70692 | 2013-10-23 3:46 | 2023-05-01 15:48 | MySQL Server: DML | Verified (4385 days) | S2 | 5.6.12,5.6.14,5.5.34,5.1.72 | Linux | Any | auto_increment wrong value when using insert into... select from |
| 70740 | 2013-10-27 10:00 | 2013-10-30 6:40 | MySQL Server: DML | Verified (4380 days) | S3 | 5.6.14 | Any | Any | Don't lose microseconds without warning |
| 70930 | 2013-11-16 15:51 | 2013-11-20 14:01 | MySQL Server: DML | Closed (4357 days) | S2 | 5.1+, 5.5+, 5.6.14, 5.7.2-m12 | Any | Any | count distinct get error result |
| 71002 | 2013-11-25 13:44 | 2013-11-28 17:01 | MySQL Server: DML | Verified (4349 days) | S3 | 5.5.8-log, 5.6.16, 5.5.35, 5.1.71 | Windows (XP, Vista) | Any | IFNULL of plain function parameter always latter argument |
| 71028 | 2013-11-27 21:26 | 2014-02-02 17:38 | MySQL Server: DML | Closed (4302 days) | S3 | 5.5+ | Any | Any | error result when "count + distinct + case when" need merge_walk |
| 71108 | 2013-12-08 13:32 | 2019-12-12 19:04 | MySQL Server: DML | Verified (4338 days) | S3 | 5.6.15, 5.7.3-m13 | Any | Any | 'help procedures' command output not complete |
| 71160 | 2013-12-17 11:11 | 2014-03-01 1:00 | MySQL Server: DML | No Feedback (4257 days) | S3 | 5.1.69 | Any | Any | concat_ws causes case sensitivity issue |
| 71244 | 2013-12-30 9:48 | 2014-03-29 8:31 | MySQL Server: DML | Closed (4253 days) | S2 | 5.6.15, 5.5.35, 5.1.72, 5.7.3 | Any | Any | Wrong result computation using ALL() and GROUP BY |
| 71257 | 2013-12-30 23:47 | 2014-02-02 1:00 | MySQL Server: DML | No Feedback (4284 days) | S3 | Any | Any | Key Exception upon millionth insert | |
| 71322 | 2014-01-09 5:21 | 2019-11-12 22:40 | MySQL Server: DML | Not a Bug (2174 days) | S3 | 5.1.44-community, 5.1.73,5.5.35, 5.6.15, 5.7.3 | Any | Any | DATEDIFF Returns Erroneously In SELECT IF Query |
| 71368 | 2014-01-14 2:09 | 2019-11-12 22:43 | MySQL Server: DML | Closed (2174 days) | S2 | 5.5.31, 5.5.34, 5.5.35, 5.6.15 | Any | Any | -1 % 0.5 yields -0.0 |
| 71378 | 2014-01-14 18:03 | 2014-01-15 5:49 | MySQL Server: DML | Verified (4301 days) | S2 | 5.5.31,5.5.34, 5.5.35, 5.6.15 | Any | Any | FROM_DAYS(3652499) yields invalid unprintable date |
| 71403 | 2014-01-17 0:46 | 2014-01-20 7:01 | MySQL Server: DML | Not a Bug (4296 days) | S3 | 5.6 | Any | Any | ERROR 1167 (42000): The used storage engine can't index column on [VAR]CHAR(0) |
| 71410 | 2014-01-17 16:44 | 2014-01-18 6:13 | MySQL Server: DML | Verified (4298 days) | S3 | 5.6, 5.6.15,5.5.35 | Any | Any | COERCIBILITY(NULL) returns 6 |
| 71414 | 2014-01-17 20:41 | 2014-01-18 5:35 | MySQL Server: DML | Verified (4298 days) | S3 | 5.5.31, 5.5.35, 5.6.15, 5.1.73 | Any | Any | DATE_FORMAT('0000-00-00', '%U') overflows, gives '613566757' |
| 71434 | 2014-01-20 21:24 | 2019-11-12 23:00 | MySQL Server: DML | Closed (2174 days) | S2 | 5.5.31, 5.5.35, 5.6.15, 5.1.73 | Any | Any | DECIMAL `0.1` evaluates to TRUE in project list, FALSE in where/having clauses |
| 71492 | 2014-01-27 11:11 | 2014-01-28 15:12 | MySQL Server: DML | Not a Bug (4288 days) | S3 | 5.5.33 | Linux (Linux ab 3.2.0-58-virtual #88-Ubuntu SMP Tue Dec 3 17:58:13 UTC 2013 x86_64 x86_64 x86_64 GNU/Linuxd) | Any | Expected ERROR 1104, none given with INSERT IGNORE |
| 71531 | 2014-01-30 17:00 | 2014-03-01 1:00 | MySQL Server: DML | No Feedback (4257 days) | S2 | 5.5.8 | Linux (Cent OS 6.4) | Any | Select count(distinct(col)) from table returns zero |
| 71562 | 2014-02-03 10:17 | 2014-02-03 11:39 | MySQL Server: DML | Verified (4282 days) | S3 | Any | Any | CAST should give warning for invalid date | |
| 71649 | 2014-02-10 9:50 | 2014-06-08 22:09 | MySQL Server: DML | Closed (4157 days) | S2 | 5.6.16 | Windows (Windows 7 64 bit) | Any | Executing multiple REPLACE statements causes connection to be lost |
| 71726 | 2014-02-14 20:55 | 2019-11-18 22:17 | MySQL Server: DML | Can't repeat (2168 days) | S3 | 5.6.16 | Any | Any | _my_hash_init_extra() doesn't set HASH::hash_function |
| 71758 | 2014-02-18 13:09 | 2014-02-19 14:58 | MySQL Server: DML | Verified (4266 days) | S2 | 5.1.69 | Any | Any | convert_tz does not work for datetime values > 2038-01-19 03:14:07 |
| 71827 | 2014-02-25 11:26 | 2015-12-09 18:39 | MySQL Server: DML | Closed (3608 days) | S3 | 5.5.35,5.0.96, 5.1.73, 5.5.38, 5.6.18, 5.7.5 | Any | Any | The yearweek() function returns a wrong value |
| 71981 | 2014-03-08 20:24 | 2014-03-13 11:15 | MySQL Server: DML | Verified (4244 days) | S3 | 5.6.16 | Any | Any | Strange result on explain |
| 72027 | 2014-03-12 23:05 | 2018-12-17 19:18 | MySQL Server: DML | Closed (2504 days) | S3 | 5.6, * | Linux | Any | LOAD_FILE() does not work on dynamic files |
| 72032 | 2014-03-13 9:38 | 2019-11-19 7:55 | MySQL Server: DML | Closed (2167 days) | S5 | Server version: 5.0.67-community-nt MySQ, 5.5.38, 5.6.18 | Windows (Windows 7 日语版 SP1) | Any | union和order错误 |
| 72056 | 2014-03-17 10:19 | 2015-05-21 0:51 | MySQL Server: DML | Closed (3810 days) | S1 | 5.5/5.6 | Linux | Any | Wrong comparsion on big DECIMAL values |
| 72089 | 2014-03-20 20:30 | 2014-03-22 6:19 | MySQL Server: DML | Verified (4235 days) | S3 | 5.5.8, 5.5.31, 5.5.38 | Any | Any | FOUND_ROWS returns 0 or garbage when used in non-trivial queries |
| 72098 | 2014-03-21 20:47 | 2019-11-18 22:37 | MySQL Server: DML | Closed (2168 days) | S3 | 5.5, 5.5.38 | Any | Any | select * from (subquery) get different result with subquery. |
| 72100 | 2014-03-21 22:09 | 2014-08-19 14:52 | MySQL Server: DML | Closed (4085 days) | S2 | 5.5.8, 5.5.31, 5.6.17, 5.5.37 | Any | Any | 0.00000000042 MOD 10 = 0.42000000000 |
| 72127 | 2014-03-25 19:16 | 2019-11-18 22:42 | MySQL Server: DML | Closed (2168 days) | S3 | 5.5.8, 5.5.31,5.6 | Any | Any | DIV with floats or doubles and unsigned integers sometimes errors out spuriously |
| 72297 | 2014-04-09 20:25 | 2014-04-09 20:48 | MySQL Server: DML | Not a Bug (4217 days) | S2 | 5.1.73 | Windows (7/64) | Any | Column name ìd` causes problems in SELECT when quoted |
| 72315 | 2014-04-11 6:06 | 2016-09-06 6:00 | MySQL Server: DML | Verified (4215 days) | S3 | 5.5/5.6 | Any | Any | ALTER TABLE doesn't throw error while setting auto_increment value to the column |
| 72364 | 2014-04-17 9:46 | 2019-11-18 22:53 | MySQL Server: DML | Closed (2168 days) | S3 | 5.5.37 | Any | Any | insert ignore was not rollbacked after KILL QUERY |
| 72367 | 2014-04-17 11:48 | 2014-04-17 13:03 | MySQL Server: DML | Not a Bug (4209 days) | S2 | 5.7.4 | Any | Any | DELAYED is documented as deprecated, but it is acutally non-functional |
| 72446 | 2014-04-24 23:09 | 2014-05-20 11:48 | MySQL Server: DML | Closed (4176 days) | S2 | 5.6.17 | Linux (RHEL 6.5) | Any | Unexpected trigger behavior in 5.6 : 1054 Unknown column '...' in 'NEW' |
| 72595 | 2014-05-09 18:54 | 2014-05-10 9:24 | MySQL Server: DML | Closed (4186 days) | S2 | 5.6.17 | Any | Any | Unknown column |
| 72673 | 2014-05-16 22:38 | 2014-06-02 11:29 | MySQL Server: DML | Duplicate (4163 days) | S2 | 5.5.31, 5.5.34 | Any | Any | SUBSTRING_INDEX with negative index sometimes returns uninitialized memory |
| 72702 | 2014-05-21 4:11 | 2014-05-21 7:53 | MySQL Server: DML | Verified (4175 days) | S2 | 5.5,5.6, 5.5.38, 5.6.17 | Any | Any | IS NULL optimization leads to wrong results when using HANDLER |
| 72761 | 2014-05-27 10:00 | 2014-05-27 17:03 | MySQL Server: DML | Verified (4169 days) | S3 | 5.6.17 | Any | Any | MySQL 5.6 FROM_UNIXTIME function returns different result than 5.5 |
| 72981 | 2014-06-12 7:51 | 2014-06-13 11:58 | MySQL Server: DML | Verified | S3 | 5.1.73 | Any | Any | com_status wraps at 2^32 |
| 73028 | 2014-06-17 18:27 | 2019-11-19 22:07 | MySQL Server: DML | Closed (2167 days) | S2 | 5.6.19 | Linux (x86_64) | Any | Unexpected result with nested CONCAT, SUBSTR, and REPLACE |
| 73248 | 2014-07-09 19:51 | 2020-09-30 18:23 | MySQL Server: DML | Closed (1851 days) | S2 | 5.5.8, 5.5.31, 5.5.34, 5.6.20, 5.7.5 | Any | Any | Many, many classes of string-to-integer conversion bug |
| 73283 | 2014-07-13 18:22 | 2019-11-19 22:22 | MySQL Server: DML | Closed (2167 days) | S3 | 5.6.17, 5.6.20, 5.7.4 | Any | Any | FOUND_ROWS() returns 0 on SELECT COUNT(*) of impossible where |
| 73347 | 2014-07-21 17:00 | 2014-07-28 21:39 | MySQL Server: DML | Closed (4107 days) | S3 | 5.6.19-log MySQL Community Server (GPL) | Linux (Red Hat Enterprise Linux Server release 6.4 (Santiago)) | Any | TIMESTAMP Initialization and the NULL Attribute |
| 73410 | 2014-07-28 11:21 | 2014-07-29 15:35 | MySQL Server: DML | Verified (4107 days) | S3 | 5.5, 5.6, 5.7, 5.6.21 | Any | Any | UPDATE IGNORE fails on overflow |
| 73414 | 2014-07-28 19:53 | 2014-07-30 4:23 | MySQL Server: DML | Not a Bug (4106 days) | S1 | 5.6.19 x64 | Any (Windows,Linux) | Any | SELECT UNION malforms result set - returns fewer rows |
| 73436 | 2014-07-30 13:55 | 2015-09-06 12:02 | MySQL Server: DML | Verified (4104 days) | S3 | 5.5.38, 5.6.19, 5.6.21 | Linux (debian-linux-gnu (x86_64)) | Any | format() with locale it_IT return wrong format |
| 73439 | 2014-07-30 18:03 | 2014-08-11 4:13 | MySQL Server: DML | Not a Bug (4093 days) | S3 | 5.6.19, 5.6.21 | Any | Any | FORMAT dk_DK bug |
| 73440 | 2014-07-30 18:17 | 2014-08-11 10:40 | MySQL Server: DML | Not a Bug (4093 days) | S3 | 5.6.19, 5.6.21 | Any | Any | South Asian FORMATting is wrong |
| 73543 | 2014-08-12 0:28 | 2014-09-30 16:26 | MySQL Server: DML | Closed (4043 days) | S2 | 5.5.8, 5.5.31, 5.5.34, 5.5.40 | Any | Any | SUM(DISTINCT ...) incorrectly converts DATE, DATETIME, and TIMESTAMP to YEAR |
| 73552 | 2014-08-12 18:56 | 2014-08-18 19:47 | MySQL Server: DML | Verified (4086 days) | S2 | 5.5.8, 5.5.31, 5.5.34,5.6.20 | Any | Any | ('string' = CAST(0 as TIME)) produces bogus error "Illegal mix of collations" |
| 73612 | 2014-08-16 17:40 | 2019-04-08 13:56 | MySQL Server: DML | Not a Bug (2721 days) | S3 | all | Any | Any | STR_TO_DATE format should allow wildcards |
| 73654 | 2014-08-20 9:57 | 2022-12-30 5:09 | MySQL Server: DML | Verified (3515 days) | S3 | 5.6.20 | Linux (CentOS 6.3) | Any | LOAD DATA LOCAL INFILE's behavior depends on whether with REPLACE or not |
| 73743 | 2014-08-27 16:05 | 2014-08-28 8:40 | MySQL Server: DML | Duplicate (4076 days) | S3 | 5.6.19 5.5.36 | Any | Any | "Explain tablename" increases Created_tmp_disk_tables |
| 73819 | 2014-09-05 17:15 | 2019-11-19 23:59 | MySQL Server: DML | Can't repeat (2167 days) | S3 | 5.5, 5.5.40 | Any | Any | Valgrind warnings " Syscall param write(buf) points to uninitialised byte(s)" |
| 73840 | 2014-09-08 17:02 | 2015-04-30 4:55 | MySQL Server: DML | Verified (4065 days) | S3 | 5.5/5.6/5.7 | Windows | Any | SYSTEM_TIME_ZONE is truncated at 29 characters |
| 73869 | 2014-09-10 6:58 | 2014-11-13 20:17 | MySQL Server: DML | Verified (3999 days) | S2 | 5.6.20, 5.6.23 | Any | Any | !table || (!table->read_set || bitmap_is_set(table->read_set, field_index)) |
| 73896 | 2014-09-11 15:40 | 2015-02-02 22:06 | MySQL Server: DML | Verified (3918 days) | S3 | 5.5.40/5.6.23 | Any | Any | MySQL issues an "Unsafe statement" warning for what should be a safe statement |
| 73946 | 2014-09-17 9:17 | 2014-09-25 8:46 | MySQL Server: DML | Verified (4056 days) | S1 | 5.5.39/5.6/5.7 | Windows (x64) | Any | Wrong result with agregate with join with no resultset |
| 73960 | 2014-09-18 3:31 | 2019-02-05 14:00 | MySQL Server: DML | No Feedback (4024 days) | S3 | 5.6 | Windows | Any | SQL performance problem |
| 73988 | 2014-09-20 20:26 | 2014-10-30 18:11 | MySQL Server: DML | Closed (4013 days) | S3 | 5.7.6 | Any | Any | find_all_keys spams server error log with deadlock/lock wait errors |
| 74260 | 2014-10-08 6:13 | 2017-08-14 7:07 | MySQL Server: DML | Verified (2994 days) | S3 | 5.6.20, 5.6.22, 5.7.19, 5.6.37 | Linux (CentOS 7) | Any | Assertion `sort_field->length >= length' failed in sql/filesort.cc:1029 |
| 74354 | 2014-10-13 10:44 | 2021-03-12 6:06 | MySQL Server: DML | Verified (4030 days) | S2 | 5.7.5, 8.0.23, 5.7.33 | Any | Any | REPLACE INTO affected_rows wrong |
| 74372 | 2014-10-14 11:38 | 2014-10-15 6:52 | MySQL Server: DML | Verified (4028 days) | S3 | Ver 14.14 Distrib 5.5.38, for debian-lin | Linux (3.13.0-37-generic #64-Ubuntu SMP Mon Sep 22 21:28:38 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux) | Any | SHOW CREATE TABLE shows not actual information |
| 74448 | 2014-10-20 9:18 | 2014-10-24 8:10 | MySQL Server: DML | Verified (4023 days) | S3 | 5.6.20-debug, 5.6.22, 5.7.6 | Linux (CentOS 7) | Any | Assertion `table_share->tmp_table != NO_TMP_TABLE || m_lock_type != 2' failed |
| 74500 | 2014-10-22 9:56 | 2017-08-16 13:23 | MySQL Server: DML | Closed (3995 days) | S3 | 5.6.20-debug | Linux (CentOS 7) | Any | Assertion `src' failed in my_strnxfrm_unicode (sig 6 -strings/ctype-utf8.c:5151) |
| 74504 | 2014-10-22 12:09 | 2014-10-22 12:34 | MySQL Server: DML | Verified (4021 days) | S3 | 5.6.20-debug | Linux (CentOS 7) | Any | Assertion `map->bitmap && map2->bitmap && map->n_bits==map2->n_bits' failed |
| 74505 | 2014-10-22 12:22 | 2019-11-20 21:46 | MySQL Server: DML | Can't repeat (2166 days) | S3 | 5.6.20-debug | Linux (CentOS 7) | Any | Assertion tab->select->quick->index==(uint)best_key' in test_if_skip_sort_order |
| 74537 | 2014-10-24 6:53 | 2014-10-24 11:19 | MySQL Server: DML | Verified (4019 days) | S3 | 5.6.20-debug, 5.6.22 | Linux (CentOS 7) | Any | Assertion `lex.sphead == __null' failed in Table_triggers_list::check_n_load |
| 74641 | 2014-10-31 1:31 | 2014-10-31 14:42 | MySQL Server: DML | Verified (4012 days) | S1 | 5.6.20, 5.6.21 | Any | Any | my_seek.c:57: my_seek: Assertion `fd != -1' failed. Table corruption on opt |
| 74646 | 2014-10-31 9:51 | 2014-10-31 10:27 | MySQL Server: DML | Verified (4012 days) | S3 | 5.6.20-debug, 5.6.22, 5.7.6 | Linux (CentOS 7) | Any | Assertion `((Item_result_field*)item)->result_field' failed in create_tmp_field |
| 74650 | 2014-10-31 14:17 | 2019-11-20 21:49 | MySQL Server: DML | Can't repeat (2166 days) | S3 | 5.6.20-debug | Linux (CentOS 7) | Any | Assertion `inited == NONE' failed in handler::ha_close |
| 74664 | 2014-11-03 7:03 | 2016-09-09 2:34 | MySQL Server: DML | Verified (4009 days) | S3 | 5.6.20-debug, 5.5.41, 5.6.22, 5.7.6 | Linux (CentOS 7) | Any | Assertion: len <= col->len || col->mtype==5 || (col->len == 0 && col->mtype ==1) |
| 74665 | 2014-11-03 8:41 | 2015-10-24 17:56 | MySQL Server: DML | Closed (3654 days) | S3 | 5.6.20-debug, 5.6.22 | Linux (CentOS 7) | Any | Assertion `! thd->in_sub_stmt' failed in mysql_execute_command |
| 74678 | 2014-11-04 8:28 | 2014-11-04 9:07 | MySQL Server: DML | Verified (4008 days) | S3 | 5.6.20-debug, 5.6.22, 5.7.6 | Linux (CentOS 7) | Any | Assertion `host_length <= 60' failed in set_setup_actor_key |
| 74695 | 2014-11-05 5:25 | 2017-08-14 1:50 | MySQL Server: DML | Closed (3800 days) | S3 | 5.6.20-debug, 5.6.22, 5.7.6 | Linux (CentOS 7) | Any | Asser tion `args[0]->fixed' failed | sig 6 abort in sql/item_strfunc.h:882 |
| 74705 | 2014-11-06 2:53 | 2014-11-06 3:16 | MySQL Server: DML | Not a Bug (4006 days) | S3 | 5.6.17-log | Any | Any | The having results are not accurate |
| 74716 | 2014-11-06 17:53 | 2015-07-01 10:34 | MySQL Server: DML | Closed (3769 days) | S3 | Any | Any | Time Zone Description Tables are severely outdated | |
| 74740 | 2014-11-07 18:10 | 2015-07-10 15:44 | MySQL Server: DML | Closed (3760 days) | S3 | 5.6.20-debug, 5.6.22, 5.7.6 | Linux (CentOS 7) | Any | Assertion `(*tables)->reginfo.lock_type >= TL_READ' failed in lock_external |
| 74747 | 2014-11-08 7:20 | 2015-02-05 7:55 | MySQL Server: DML | Verified (3915 days) | S1 | 5.6.20, 5.6.22, 5.7.5 | Any | Any | Failing assertion: index->id == btr_page_get_index_id(page) btr0cur.cc line 899 |
| 74759 | 2014-11-10 7:29 | 2014-11-10 8:55 | MySQL Server: DML | Verified (4002 days) | S3 | 5.6.20-debug | Linux (CentOS 7) | Any | Failing assertion: lock_rec_get_first(receiver, receiver_heap_no) == __null |
| 74777 | 2014-11-11 6:14 | 2019-11-20 21:58 | MySQL Server: DML | Can't repeat (2166 days) | S3 | 5.6.21-debug, 5.6.23, 5.7.6 | Any | Any | Assertion :bitmap_is_subset(&m_part_info->lock_partitions, &m_locked_partitions) |
| 74779 | 2014-11-11 7:42 | 2016-07-29 10:37 | MySQL Server: DML | Verified (4001 days) | S3 | 5.6.20-debug, 5.6.23, 5.7.6 | Linux (CentOS 7) | Any | Assertion :bitmap_is_s et(&m_part_info->read_partitions, m_part_spec.start_part) |
| 74780 | 2014-11-11 9:15 | 2016-11-18 6:33 | MySQL Server: DML | Verified (4001 days) | S3 | 5.6.20-debug, 5.6.23, 5.7.6 | Linux (CentOS 7) | Any | Assertion `tab->ref.use_count' failed in join_read_key_unlock_row |
| 74797 | 2014-11-11 15:19 | 2021-09-14 11:06 | MySQL Server: DML | Verified (4001 days) | S3 | 5.6.21/5.7 | Any | Any | create temporary table . select ..union.. select fails on read-only MySQL Server |
| 74848 | 2014-11-14 2:43 | 2019-11-20 22:12 | MySQL Server: DML | Can't repeat (2166 days) | S3 | 5.6.21-debug, 5.6.23 | Linux (CentOS 7) | Any | !table || (!table->write_set || bitmap_is_set(table->write_set, field_index)) |
| 74856 | 2014-11-14 9:03 | 2019-11-25 21:23 | MySQL Server: DML | Can't repeat (2161 days) | S3 | 5.6.21-debug, 5.6.23, 5.7.6 | Linux (CentOS 7) | Any | handle_fatal_signal (sig=6) in get_parts_for_update | sql/sql_partition.cc:328 |
| 74889 | 2014-11-17 5:20 | 2019-11-25 21:39 | MySQL Server: DML | Can't repeat (2161 days) | S3 | 5.6.21 | Linux (CentOS 7) | Any | Sig-6 abort in Item_in_subselect::exec | sql/item_subselect.cc:730 |
| 74946 | 2014-11-21 4:47 | 2014-11-23 9:19 | MySQL Server: DML | Verified (3991 days) | S3 | 5.6.20, 5.6.23, 5.7.6 | Linux (CentOS 7) | Any | Assertion `nr >= 0.0' failed in virtual double Item_sum_std::val_real() |
| 75068 | 2014-12-02 8:40 | 2015-04-06 19:03 | MySQL Server: DML | Closed (3900 days) | S3 | 5.1+ | Any | Any | LOAD DATA INFILE doesn't reset LEX::many_values |
| 75210 | 2014-12-15 6:10 | 2016-01-13 9:24 | MySQL Server: DML | Not a Bug (3573 days) | S1 | 5.5, 5.6, 5.6.22, 5.7.9, 5.5.48, 5.6.29 | Any | Any | Using rand() in UPSERT may result in wrong result |
| 75227 | 2014-12-16 5:41 | 2019-11-25 21:48 | MySQL Server: DML | Won't fix (2161 days) | S3 | 5.6.21, 5.6.23 | Linux (CentOS 7) | Any | Assertion `thd->killed != THD::KILL_BAD_DATA || error > 0' failed |
| 75232 | 2014-12-16 9:11 | 2014-12-16 9:49 | MySQL Server: DML | Verified (3966 days) | S3 | 5.6.21, 5.6.23, 5.7.6 | Linux (CentOS 7) | Any | Sig 6 abort in get_partition_id_range_for_endpoint | sql/sql_partition.cc:3600 |
| 75294 | 2014-12-23 3:32 | 2019-11-25 21:56 | MySQL Server: DML | Closed (2161 days) | S3 | 5.6.22, 5.6.23, 5.7.6 | Any | Any | LEAST() works incorrectly on MySQL 5.6 with expression using other functions |
| 75436 | 2015-01-07 15:02 | 2020-01-31 13:33 | MySQL Server: DML | Closed (2094 days) | S2 | 5.5.41-log | Linux | Any | wrong results |
| 75438 | 2015-01-07 18:21 | 2019-11-25 22:15 | MySQL Server: DML | Closed (2161 days) | S3 | 5.1.68, 5.6.20, 5.6.24 | Any | Any | REGEXP is case sensitive for most russian letters |
| 75471 | 2015-01-09 17:29 | 2019-11-25 22:22 | MySQL Server: DML | Closed (2161 days) | S1 | 5.1/5.5/5.6/5.7 | Any | Any | Views that use hex literals fails |
| 75539 | 2015-01-17 20:55 | 2015-05-12 16:57 | MySQL Server: DML | Closed (3819 days) | S2 | 5.6.21 | Any | Any | max_allowed_packet error destroys original data |
| 75640 | 2015-01-27 4:50 | 2015-01-27 7:58 | MySQL Server: DML | Verified (3924 days) | S3 | 5.6.21-debug, 5.6.24 | Linux (CentOS 7) | Any | Failing assertion: array->n_elems < array->max_elems in sync_thread_add_level |
| 75648 | 2015-01-27 10:04 | 2015-01-27 11:12 | MySQL Server: DML | Verified (3924 days) | S3 | 5.6.21-debug, 5.6.24, 5.7.6 | Linux (CentOS 7) | Any | Assertion `length <= max_data_length()' failed in Field_blob::store_to_mem |
| 75690 | 2015-01-30 5:51 | 2017-08-14 0:32 | MySQL Server: DML | Can't repeat (2994 days) | S1 | 5.7.5-m15 | Any | Any | int handler::ha_index_read_map(...) Assertion`inited == INDEX' failed handler.cc |
| 75736 | 2015-02-03 2:07 | 2015-04-24 12:40 | MySQL Server: DML | Closed (3837 days) | S1 | 5.7.5-m15, 5.7.6 | Any | Any | DEADLOCK of threads detected! 5.7.5, 1 thread SQL testcase, sporadic, in ib_logf |
| 75807 | 2015-02-06 10:00 | 2015-02-20 9:54 | MySQL Server: DML | Verified (3902 days) | S5 | 5.6.22 | Linux | Any | Slow Query in MySQL 5.6 |
| 75833 | 2015-02-10 6:45 | 2015-02-16 13:06 | MySQL Server: DML | Closed (3904 days) | S3 | 5.7.5-m15, 5.7.6 | Any | Any | InnoDB: Failing assertion: found in buf0buf.cc line 3856 |
| 75909 | 2015-02-15 20:16 | 2015-02-16 6:04 | MySQL Server: DML | Duplicate (3904 days) | S2 | 5.7.5-m15 | Any | Any | [ERROR] Invalid (old?) table or database name |
| 75911 | 2015-02-15 21:20 | 2019-11-25 22:32 | MySQL Server: DML | Closed (2161 days) | S1 | 5.7.5-m15 | Any | Any | [ERROR] Got error 155 when reading table './test/t' |
| 75929 | 2015-02-17 9:47 | 2015-02-17 13:59 | MySQL Server: DML | Duplicate (3903 days) | S1 | 5.6.23 | Windows (2k8, win7) | Any | Critical bug with orders in select statements |
| 75958 | 2015-02-18 18:21 | 2015-02-18 22:32 | MySQL Server: DML | Can't repeat (3902 days) | S1 | 5.7.5-m15 | Any | Any | handle_fatal_signal (sig=11) in String::replace | INSERT into TEMPORARY table |
| 75995 | 2015-02-22 11:01 | 2015-07-02 16:20 | MySQL Server: DML | Closed (3768 days) | S2 | 5.7.6-m16 | Any | Any | mysqld --help --verbose tries to lock files |
| 76040 | 2015-02-25 7:31 | 2018-04-20 23:33 | MySQL Server: DML | Verified (3893 days) | S3 | 5.6.23, 5.6.25 | Linux (CentOS 7) | Any | Assertion `!flags.finalized' failed in sql/binlog.cc:1172 |
| 76229 | 2015-03-09 14:31 | 2018-11-30 3:25 | MySQL Server: DML | Closed (2521 days) | S2 | 5.6 and 5.7 | Any | Any | SELECT DISTINCT WITH ROLLUP causes syntax error since 5.6 |
| 76244 | 2015-03-10 16:31 | 2018-07-26 1:00 | MySQL Server: DML | No Feedback (2649 days) | S2 | 5.6.18, 5.1.73+ | Any | Any | MySQL does order of operations incorrectly on distinct numeric string |
| 76307 | 2015-03-13 3:46 | 2015-03-13 6:23 | MySQL Server: DML | Verified (3879 days) | S3 | 5.6.23, 5.6.25, 5.7.7, 5.5.44 | Linux (CentOS 7) | Any | Assertion `share->rows_recorded' failed in ha_tina::delete_row(const uchar*) |
| 76355 | 2015-03-17 15:34 | 2015-03-17 16:33 | MySQL Server: DML | Verified (3875 days) | S3 | 5.6/5.7 | Linux | Any | Function "addtime" returns wrong column type (regression). |
| 76393 | 2015-03-19 17:41 | 2015-03-24 15:57 | MySQL Server: DML | Verified (3873 days) | S3 | 5.6.23 | Any | Any | Update query stores one value before evaluation equation for second |
| 76436 | 2015-03-23 0:23 | 2016-06-18 21:25 | MySQL Server: DML | Closed (3867 days) | S1 | 5.7.6, 5.7.8, 8.0.0 | Any | Any | handle_fatal_signal (sig=11) in st_select_lex::merge_derived |
| 76452 | 2015-03-23 11:04 | 2016-06-18 21:25 | MySQL Server: DML | Can't repeat (3728 days) | S3 | 8.0.0 | Any | Any | memory leak with generated column containing LPAD function |
| 76468 | 2015-03-24 0:06 | 2015-03-25 5:09 | MySQL Server: DML | Duplicate (3867 days) | S1 | 5.6.22, 5.5.44, 5.6.23, 5.6.25 | Any | Any | void Item_row::illegal_method_call(const char*): Assertion `0' failed. |
| 76477 | 2015-03-24 23:54 | 2015-04-01 4:28 | MySQL Server: DML | Closed (3860 days) | S1 | 5.6.22, 5.6.23, 5.6.25 | Any | Any | Assertion `from->len == to->len' failed. |
| 76478 | 2015-03-25 7:46 | 2015-03-26 2:59 | MySQL Server: DML | Verified (3866 days) | S3 | 5.6.22, 5.6.25, 5.5.44, 5.1.73 | Linux | Any | mod functions works incorrectly with arithmetic express |
| 76516 | 2015-03-28 10:07 | 2018-07-26 1:00 | MySQL Server: DML | No Feedback (2649 days) | S1 | 5.5.41-0ubuntu0.14.04.1-log | Linux (Ubuntu 14.04) | Any | time interval arithmetic leads to exception on summer time change |
| 76583 | 2015-04-03 3:26 | 2015-04-05 11:45 | MySQL Server: DML | Not a Bug (3856 days) | S2 | 5.6.23 | Any | Any | Wrong columns in subquery , but doesn't throw exception |
| 76605 | 2015-04-07 4:32 | 2018-06-09 1:00 | MySQL Server: DML | No Feedback (2696 days) | S2 | 5.6.23 & 5.6.24 | Linux (Linux iZ28ihpu0pyZ 3.10.0-123.9.3.el7.x86_64 #1 SMP Thu Nov 6 15:06:03 UTC 2014 x86_64 x86_64 x86_64) | Any | slow query with grant all on *.* to xxx |
| 76614 | 2015-04-08 4:01 | 2019-11-25 22:54 | MySQL Server: DML | Won't fix (2161 days) | S3 | 5.6.23, 5.6.24, 5.6.25 | Linux (CentOS 7) | Any | Assertion `!(mysql_bin_log.is_open()&&!thd.is_current_stmt_bi nlog_format_row()) |
| 76715 | 2015-04-15 17:08 | 2018-03-19 22:38 | MySQL Server: DML | Verified (2787 days) | S3 | 5.0, 5.1+ | Any | Any | Different behavior of LAST_INSERT_ID() function within a trigger AFTER INSERT |
| 76827 | 2015-04-24 13:26 | 2015-06-26 10:02 | MySQL Server: DML | Verified (3774 days) | S1 | 5.6.24, 5.6.26 | Linux (CentOS 6.5) | Any | Assertion failed while creating view after full disk error |
| 76837 | 2015-04-26 3:56 | 2017-12-06 19:46 | MySQL Server: DML | Not a Bug (2880 days) | S3 | Any | Any | Inconsistent JOIN evaluation order | |
| 76840 | 2015-04-26 19:46 | 2015-04-29 11:28 | MySQL Server: DML | Not a Bug (3832 days) | S1 | 5.6.21-log | Any | Any | MySQL reports wrong information |
| 76844 | 2015-04-27 5:50 | 2015-04-27 6:53 | MySQL Server: DML | Verified (3834 days) | S3 | 5.6.23, 5.6.25 | Linux (CentOS 7) | Any | handle_fatal_signal (sig=6) in trx_commit_low | trx/trx0trx.cc:1365 |
| 76925 | 2015-05-04 10:37 | 2015-05-04 11:20 | MySQL Server: DML | Verified (3827 days) | S3 | 5.6.23, 5.6.25 | Linux (CentOS 7) | Any | handle_fatal_signal (sig=11) in ha_innobase::store_key_val_for_row |
| 76962 | 2015-05-07 5:52 | 2016-06-18 21:26 | MySQL Server: DML | Closed (3811 days) | S3 | 8.0.0 | Any | Any | Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field |
| 77108 | 2015-05-21 4:52 | 2015-05-21 6:38 | MySQL Server: DML | Verified (3810 days) | S3 | 5.6.23, 5.6.26 | Linux (CentOS 7) | Any | InnoDB: Failing assertion: index == cursor->index in btr0sea.cc line 1782 |
| 77164 | 2015-05-27 5:10 | 2015-05-27 13:29 | MySQL Server: DML | Verified (3804 days) | S3 | 5.6.21, 5.6.26, 5.6.24 | Linux (CentOS 7) | Any | Assertion : mtr_memo_contains(mtr, block, 2) == rw_lock_own(&block->lock, 351) |
| 77194 | 2015-05-29 17:10 | 2015-06-19 12:58 | MySQL Server: DML | Duplicate (3781 days) | S3 | 5.6.23 | Linux (CentOS 7) | Any | Assertion `param.sort_length != 0' failed in sql/filesort.cc:361 |
| 77222 | 2015-06-02 8:09 | 2015-06-03 10:49 | MySQL Server: DML | Not a Bug (3797 days) | S3 | 5.5.43 | Linux | Any | GROUP_CONCAT shows 1 result having all null values when no result can be found |
| 77232 | 2015-06-02 20:38 | 2015-06-03 7:08 | MySQL Server: DML | Verified (3797 days) | S3 | 5.6.23, 5.6.24, 5.6.25 | Any | Any | Microtime not supported for <1 second past epoch |
| 77289 | 2015-06-10 2:49 | 2015-06-10 7:11 | MySQL Server: DML | Verified (3790 days) | S3 | 5.6.23, 5.6.25, 5.7.8 | Linux (CentOS 7) | Any | InnoDB: Failing assertion: lock->index == index | lock0lock.cc line 5573 |
| 77299 | 2015-06-10 14:08 | 2019-11-26 21:12 | MySQL Server: DML | Can't repeat (2160 days) | S3 | 5.1, 5.5, 5.6, 5.7 | Any | Any | Inconsistent behavior of PROCEDURE ANALYSE for 0 in Min_value |
| 77300 | 2015-06-10 16:24 | 2017-06-08 9:52 | MySQL Server: DML | Not a Bug (3061 days) | S3 | 5.6.25 | Any | Any | Regexp match is too wide |
| 77341 | 2015-06-13 2:14 | 2016-06-13 12:03 | MySQL Server: DML | Verified (3787 days) | S3 | 5.6.22, 5.6.26, 5.7.8, 5.5.45 | Linux | Any | "between and" expr with datetime field and NULL value returns 0/1(not NULL) |
| 77376 | 2015-06-17 2:38 | 2015-06-17 7:47 | MySQL Server: DML | Verified (3783 days) | S3 | 5.6.22, 5.6.25 | Any | Any | " ('xxx' <=> null) is not known " returns 0 |
| 77382 | 2015-06-17 8:35 | 2019-11-26 21:28 | MySQL Server: DML | Closed (2160 days) | S3 | 5.5/5.6/5.7 | Any | Any | Get unexpected "ERROR 1267" for a normal select query |
| 77428 | 2015-06-22 10:46 | 2015-06-22 12:00 | MySQL Server: DML | Not a Bug (3778 days) | S3 | 5.6.24 | Linux | Any | CONVERT_TZ fails between 'Europe/London' and UTC during BST |
| 77480 | 2015-06-25 9:14 | 2015-11-02 16:32 | MySQL Server: DML | Closed (3645 days) | S3 | 5.7.7, 5.6.25 | Any | Any | Wrong results for truncated column and aggregation |
| 77521 | 2015-06-28 23:13 | 2016-06-18 21:26 | MySQL Server: DML | Closed (3700 days) | S1 | 5.7.7 RC, 5.7.8, 8.0.0 | Any | Any | InnoDB: Failing assertion: !trx_is_autocommit_non_locking(trx) in trx0trx.cc |
| 77561 | 2015-06-30 9:28 | 2015-07-10 11:50 | MySQL Server: DML | Closed (3760 days) | S3 | 5.6.25 | Any | Any | A "CASE WHEN" expression with NULL and an unsigned type gives a signed result |
| 77576 | 2015-07-01 10:33 | 2015-08-12 16:49 | MySQL Server: DML | Closed (3727 days) | S3 | Any | Any | Time Zone Description Tables are outdated | |
| 77580 | 2015-07-01 11:45 | 2015-07-02 16:14 | MySQL Server: DML | Closed (3768 days) | S3 | 5.6.23, 5.6.27 | CentOS (CentOS 7) | Any | Assertion `t1->result_range' failed in sql/gcalc_tools.cc:731 |
| 77631 | 2015-07-06 19:00 | 2015-07-20 14:49 | MySQL Server: DML | Closed (3750 days) | S2 | 5.7 | Linux | Any | filter using trim results in correct |
| 77632 | 2015-07-06 19:07 | 2015-08-26 13:29 | MySQL Server: DML | Closed (3713 days) | S2 | 5.7.7 | Linux | Any | count distinct returns in-correct result |
| 77634 | 2015-07-06 23:46 | 2015-10-15 14:07 | MySQL Server: DML | Closed (3663 days) | S2 | 5.5.45, 5.6.25, 5.7.7 | Any | Any | returned value overflows decimal data type |
| 77715 | 2015-07-14 9:03 | 2018-05-21 6:40 | MySQL Server: DML | Verified (2714 days) | S3 | 5.6.24 | Any | Any | table_open_cache_instances Does not Really Split table_open_cache |
| 77805 | 2015-07-23 2:01 | 2015-07-23 5:01 | MySQL Server: DML | Verified (3747 days) | S1 | 5.6.25 MySQL Community Server (GPL) | Ubuntu (Ubuntu 14.04.2 LTS x86_64) | Any | NULLIF cause wrong value with cast datetime |
| 77809 | 2015-07-23 6:14 | 2018-06-25 21:18 | MySQL Server: DML | Can't repeat (2679 days) | S1 | 5.7.7-rc | CentOS (7) | Any | #08S01 Bad handshake with MySQL 5.7.7-rc-debug-valgrind |
| 77874 | 2015-07-29 15:41 | 2018-03-06 17:13 | MySQL Server: DML | Not a Bug (2790 days) | S3 | 5.5.28-0 | Ubuntu (Ubuntu 0.12.04.2) | Any | ORDER BY MAX() Returns a row with empty value when no rows exist |
| 77937 | 2015-08-04 21:07 | 2018-01-01 1:00 | MySQL Server: DML | No Feedback (2856 days) | S5 | 5.6.25 | Any | Any | Table lock problem while adding new foreign key constraints |
| 77938 | 2015-08-04 22:13 | 2015-08-10 11:19 | MySQL Server: DML | Verified (3729 days) | S3 | 5.6.24, 5.6.26, 5.7.9, 5.5.46 | CentOS | Any | Incorrect results returned with like operator and escape characters strings |
| 77994 | 2015-08-08 10:09 | 2019-11-26 21:35 | MySQL Server: DML | Closed (2160 days) | S3 | 5.6.22, 5.5.46, 5.6.26, 5.7.9 | Any | Any | function relace('xxx','yyy', c1) returns 'xxx' when column c1 is null |
| 78005 | 2015-08-10 7:16 | 2019-11-26 21:40 | MySQL Server: DML | Duplicate (2160 days) | S3 | 5.6.22, 5.6.26, 5.7.9 | Any | Any | replace('xxx','',b) when column b is NULL returns 'xxx' |
| 78009 | 2015-08-10 11:25 | 2015-08-10 14:47 | MySQL Server: DML | Not a Bug (3729 days) | S3 | 5.6.22 | Any | Any | Inconsistent behaviors when column alias name(s) and column name are the same |
| 78040 | 2015-08-12 11:16 | 2018-11-23 9:25 | MySQL Server: DML | Not a Bug (2528 days) | S3 | mysqld Ver 5.6.23-ndb-7.4.4-cluster-com | Oracle Linux (Oracle Linux Server release 6.3) | Any | UPDATE is changing incorrect field |
| 78127 | 2015-08-18 12:16 | 2019-11-26 21:50 | MySQL Server: DML | Closed (2160 days) | S3 | 5.6.22, 5.5.46, 5.6.26 | Any | Any | In consistent behavior between similar UPDATE sqls, error vs warning |
| 78149 | 2015-08-20 11:02 | 2015-08-21 6:25 | MySQL Server: DML | Verified (3719 days) | S3 | 5.0/5.1/5.5/5.6/5.7 | Ubuntu | Any | TIMESTAMPDIFF vs TIMESTAMPADD and DATE_ADD : count months in different way |
| 78176 | 2015-08-23 13:36 | 2018-05-18 1:00 | MySQL Server: DML | No Feedback (2718 days) | S2 | 5.6.20 | Debian | Any | 5.6.20 is almost twice as slow as 5.0.96 |
| 78181 | 2015-08-24 6:59 | 2015-08-24 9:23 | MySQL Server: DML | Verified (3715 days) | S2 | 5.6.21, 5.6.26, 5.7.9 | Any | Any | Group by different behavior in mysql 5.6.21 |
| 78183 | 2015-08-24 9:01 | 2015-09-01 8:37 | MySQL Server: DML | Not a Bug (3707 days) | S3 | 5.6.22 | Any | Any | Similar query with aggregate functions returns inconsistent result |
| 78203 | 2015-08-25 9:16 | 2015-08-26 15:33 | MySQL Server: DML | Not a Bug (3713 days) | S3 | 5.6.22 | Any | Any | Inconsistent behaviors when auto_increment_offset is ignored(>auto..._increment) |
| 78253 | 2015-08-28 8:35 | 2015-09-01 6:35 | MySQL Server: DML | Not a Bug (3707 days) | S5 | 4.2.11 | Any | Any | A major problem is found in insert query of my sql which need attention |
| 78292 | 2015-08-31 16:48 | 2015-11-13 13:48 | MySQL Server: DML | Closed (3634 days) | S3 | 5.6.22 | CentOS (CentOS 7) | Any | Assertion `pfs->m_processlist_id != 0' failed in table_session_connect.cc:254 |
| 78330 | 2015-09-05 0:12 | 2015-09-05 6:34 | MySQL Server: DML | Duplicate (3703 days) | S1 | 5.6.23 | Any | Any | handle_fatal_signal (sig=6) in Item_row::illegal_method_call on SELECT |
| 78349 | 2015-09-06 12:12 | 2015-12-03 14:22 | MySQL Server: DML | Closed (3614 days) | S3 | 5.6.22, 5.6.26 | Any | Any | w/ ONLY_FULL_GROUP_BY, having/order by + column alias have different results |
| 78360 | 2015-09-08 6:14 | 2015-09-08 12:29 | MySQL Server: DML | Verified (3700 days) | S3 | 5.6.22, 5.6.26 | Any | Any | More than 1 row is returned when using "having count(alias)" |
| 78361 | 2015-09-08 7:08 | 2015-10-24 18:08 | MySQL Server: DML | Closed (3654 days) | S3 | 5.6.22, 5.6.26 | Any | Any | Column alias can be used in subquery in select list in the same query |
| 78415 | 2015-09-12 6:17 | 2015-09-12 9:50 | MySQL Server: DML | Verified (3696 days) | S3 | 5.6.22, 5.6.26, 5.7.9 | Any | Any | Equivalent SQL like "select cast( varchar as decimal)" returns different results |
| 78418 | 2015-09-12 12:34 | 2015-09-13 19:59 | MySQL Server: DML | Not a Bug (3695 days) | S3 | 5.6.22 | Any | Any | Inserted data in "col float" is truncated to 6 digits in "select * from t1" |
| 78424 | 2015-09-14 2:29 | 2015-09-14 10:50 | MySQL Server: DML | Can't repeat (3694 days) | S3 | 5.7.7 | Any | Any | w/ c1&&c2 appears in select list, group by clause and order by clause, SQL fails |
| 78450 | 2015-09-16 9:59 | 2015-09-18 10:31 | MySQL Server: DML | Not a Bug (3690 days) | S3 | 5.6.22 | Any | Any | Invalid column name is not detected in select list, but detected as unknown |
| 78470 | 2015-09-17 12:20 | 2015-09-18 10:52 | MySQL Server: DML | Not a Bug (3690 days) | S3 | 5.6.22 | Any | Any | When dates are provided as inputs for period_diff, result is not understandable |
| 78486 | 2015-09-19 18:52 | 2015-10-30 12:34 | MySQL Server: DML | Not a Bug (3648 days) | S2 | 5.6.26-1debian7, amd64, 5.7.9 | Debian (wheezy, uptodate) | Any | to_base64() insert an extra '\n' char |
| 78497 | 2015-09-21 8:44 | 2015-09-21 9:11 | MySQL Server: DML | Verified (3687 days) | S3 | 5.6, 5.6.26, 5.6.28, 5.7.10 | Ubuntu | Any | Large select with nested subqueries return 0 rows |
| 78508 | 2015-09-22 3:20 | 2015-09-22 12:19 | MySQL Server: DML | Not a Bug (3686 days) | S3 | 5.6.22 | Any | Any | Subquery result with aggregate function() in outer table is not understandable |
| 78534 | 2015-09-23 17:29 | 2015-09-23 20:44 | MySQL Server: DML | Can't repeat (3685 days) | S3 | Any | Any | Different results are coming when ran a same Query in two different applications | |
| 78536 | 2015-09-24 6:50 | 2018-05-08 13:11 | MySQL Server: DML | Not a Bug (2727 days) | S2 | 5.6.22, 5.7.8 | Any | Any | group_concat returns incorrect result |
| 78598 | 2015-09-28 8:28 | 2015-11-16 1:00 | MySQL Server: DML | No Feedback (3632 days) | S3 | 5.6 | Any | Any | Update results in wrong nr of columns updated (null = null) |
| 78659 | 2015-10-01 8:34 | 2019-11-26 22:51 | MySQL Server: DML | Closed (2160 days) | S3 | 5.6 for Windows,5.1.77, 5.5.47, 5.6.28,5.7.10 | Windows | Any | Stddev_Samp function calculates wrongly when used within Views |
| 78671 | 2015-10-01 13:41 | 2015-10-06 11:57 | MySQL Server: DML | Verified (3677 days) | S3 | 5.7.8 | Any | Any | too big value into BIGINT SIGNED column gives no warning if value is from column |
| 78704 | 2015-10-05 13:29 | 2016-02-04 18:54 | MySQL Server: DML | Closed (3624 days) | S3 | 5.5 | Any | Any | The Item::rsize variable is unused |
| 78821 | 2015-10-13 15:28 | 2015-10-15 8:13 | MySQL Server: DML | Verified (3663 days) | S2 | 5.7.8, 5.7.10, 5.6.27, 5.5.47 | Any | Any | When comparing bigint and varchar constant, inconsistent results are returned |
| 78832 | 2015-10-14 12:20 | 2019-11-26 23:02 | MySQL Server: DML | Closed (2160 days) | S3 | 5.5.44-0+deb7u1-log (Debian) | Debian (3.2.0-4-amd64 #1 SMP Debian 3.2.68-1+deb7u2 x86_64 GNU/Linux) | Any | wrong result using BETWEEN with dates and NULL |
| 78853 | 2015-10-16 1:17 | 2016-02-11 16:21 | MySQL Server: DML | Closed (3544 days) | S3 | 5.6.27, 5.5.47, 5.1.77 | Red Hat (Red Hat Enterprise Linux Server release 6.2 (Santiago)) | Any | INSERT IGNORE fails to ignore foreign key constraint |
| 78934 | 2015-10-23 4:14 | 2015-10-26 13:37 | MySQL Server: DML | Not a Bug (3652 days) | S3 | 5.7.8 | Any | Any | Failed INSERT(Dup entry) still change LAST_INSERT_ID() for auto_increment col |
| 78958 | 2015-10-26 2:37 | 2019-11-27 22:13 | MySQL Server: DML | Closed (2159 days) | S3 | 5.7.8, 5.6.27, 5.7.10 | Any | Any | NULL=ANY( subquery ) returns 0 |
| 79001 | 2015-10-28 12:36 | 2020-01-31 13:33 | MySQL Server: DML | Closed (2094 days) | S3 | 5.0/5.1/5.5/5.6 | Ubuntu | Any | Wrong sort order with CONCAT and CASE-based sort column |
| 79015 | 2015-10-29 9:03 | 2015-11-02 9:18 | MySQL Server: DML | Verified (3649 days) | S3 | 5.7.8, 5.6.27, 5.6.28, 5.7.9 | Any | Any | When function DATEDIFF and NULLIF work together, incorrect result is returned |
| 79110 | 2015-11-04 4:17 | 2015-11-04 7:23 | MySQL Server: DML | Verified (3643 days) | S3 | 5.7.8,5.1.77,5.5.47,5.6.27,5.7.9 | Any | Any | When casting a BIG number to unsigned, get inconsistent result for same number |
| 79111 | 2015-11-04 5:57 | 2015-11-04 6:41 | MySQL Server: DML | Verified (3643 days) | S3 | 5.7.8, 5.6.27, 5.7.9 | Any | Any | w/ DATE_FORMAT, NULLIF works together, incorrect result is returned |
| 79112 | 2015-11-04 6:43 | 2015-11-04 6:55 | MySQL Server: DML | Verified (3643 days) | S3 | 5.7.8, 5.6.27, 5.7.9 | Any | Any | w/ EXTRACT and NULLIF working together, get unexpected warnings |
| 79114 | 2015-11-04 7:53 | 2015-11-18 18:24 | MySQL Server: DML | Closed (3629 days) | S3 | 5.7.8, 5.7.9 | Any | Any | IF(bool, date str, date str) throws ERROR in UPDATE |
| 79116 | 2015-11-04 8:56 | 2015-11-04 13:34 | MySQL Server: DML | Not a Bug (3643 days) | S3 | 5.7.8,5.6.24,5.5.43,5.1.73 | Any | Any | IFNULL returns expr1 with appending decimals when expr2 is w/ decimal |
| 79131 | 2015-11-05 5:34 | 2015-11-17 16:03 | MySQL Server: DML | Closed (3630 days) | S3 | 5.7.8, 5.7.9 | Any | Any | Get negative FOUND_ROWS() for UNION stmt |
| 79226 | 2015-11-11 10:08 | 2015-11-11 15:12 | MySQL Server: DML | Not a Bug (3636 days) | S3 | 5.6.21 | Ubuntu | Any | Order by in where clause doesn't cause error |
| 79243 | 2015-11-12 0:56 | 2019-03-26 19:29 | MySQL Server: DML | Duplicate (2942 days) | S2 | 5.7.9 | Windows (10 x64) | Any | 0xc0000005 |
| 79246 | 2015-11-12 9:15 | 2019-11-27 22:43 | MySQL Server: DML | Closed (2159 days) | S3 | 5.0/5.1/5.5/5.6/5.7 | Any | Any | "select null=ANY(non-empty subquery)" returns 0 |
| 79259 | 2015-11-13 3:47 | 2019-11-04 18:33 | MySQL Server: DML | Not a Bug (2182 days) | S3 | 5.7.8 | Any | Any | Get inconsistent result for invalid date in column and const,compared w/ date |
| 79260 | 2015-11-13 7:33 | 2019-11-28 21:41 | MySQL Server: DML | Closed (2158 days) | S3 | 5.7.8/5.6 | Any | Any | Get "ERROR 1271: Illegal mix of collations" when comparing time and string |
| 79261 | 2015-11-13 7:37 | 2015-11-25 9:34 | MySQL Server: DML | Not a Bug (3622 days) | S3 | 5.7.8 | Any | Any | time compared with varchar, got different result for value in col or const |
| 79266 | 2015-11-13 10:54 | 2016-02-01 17:30 | MySQL Server: DML | Closed (3599 days) | S3 | 5.7.9 | Ubuntu (14.04 LTS) | Any | Adding a trigger to a table changes the behaviour of null detection |
| 79286 | 2015-11-16 3:34 | 2015-11-16 15:27 | MySQL Server: DML | Verified (3631 days) | S3 | 5.0/5.1/5.5/5.6/5.7 | Any | Any | Unexpected ERROR 1093 of delete w/ subquery in from stmt |
| 79292 | 2015-11-16 9:48 | 2015-11-19 22:03 | MySQL Server: DML | Verified (3628 days) | S3 | 5.0/5.1/5.5/5.6/5.7 | Any | Any | cast('-123.9' as signed) returns -123, not expected -124 |
| 79309 | 2015-11-17 10:12 | 2015-11-18 2:02 | MySQL Server: DML | Closed (3629 days) | S1 | 5.7.8.rc | Windows | Any | insert statement puts the value "testing" in place of text string |
| 79333 | 2015-11-19 5:16 | 2015-12-07 18:30 | MySQL Server: DML | Closed (3610 days) | S3 | 5.7.9 | Any | Any | Unexpected error 1093 on nested subquery for update |
| 79353 | 2015-11-20 10:02 | 2015-11-20 10:46 | MySQL Server: DML | Verified (3627 days) | S2 | 5.7.8, 5.6.29, 5.7.9 | Any | Any | IN operator works incorrectly with collate |
| 79398 | 2015-11-24 16:37 | 2015-12-09 15:03 | MySQL Server: DML | Closed (3608 days) | S3 | 5.7.11,5.6.28,5.5.44 | Any | Any | view using hexadecimal or bit literal gives wrong results |
| 79400 | 2015-11-24 20:15 | 2018-12-17 13:29 | MySQL Server: DML | Not a Bug (2504 days) | S3 | 14.14 Distrib 5.6.27 | Any | Any | Uncompress function could be much better |
| 79409 | 2015-11-25 10:45 | 2015-11-30 8:11 | MySQL Server: DML | Verified (3617 days) | S3 | 5.7.8, 5.7.9, 5.5.48, 5.6.29 | Any | Any | compare type for datetime column and varchar column is inconsistent with doc |
| 79410 | 2015-11-25 13:13 | 2015-11-25 14:50 | MySQL Server: DML | Closed (3622 days) | S3 | 5.7.8 | Any | Any | "coalesce(0, 1.2345)" is not returning 0.0000 with aggregate func in select list |
| 79470 | 2015-12-01 8:26 | 2019-11-28 22:24 | MySQL Server: DML | Closed (2158 days) | S3 | 5.7.8, 5.7.9, 5.6.29, 5.5.48 | Any | Any | w/ Collate = utf8_bin, replace('xxx','yyy',c1(NULL)) gives 'xxx' |
| 79505 | 2015-12-03 10:57 | 2015-12-03 12:09 | MySQL Server: DML | Verified (3614 days) | S3 | 5.7.8, 5.5.48, 5.6.29, 5.7.9 | Any | Any | "if(1,1,1.234)" return 1 while the "Decimals" is 3 |
| 79507 | 2015-12-03 12:55 | 2019-11-28 22:34 | MySQL Server: DML | Closed (2158 days) | S3 | 5.6.22, 5.5.48 | Any | Any | String function insert is not working as doc says |
| 79518 | 2015-12-04 7:42 | 2015-12-07 7:01 | MySQL Server: DML | Verified (3610 days) | S3 | 5.7.8, 5.5.48, 5.6.29, 5.7.11 | Any | Any | Get inconsistent string when converting year column to char |
| 79519 | 2015-12-04 9:22 | 2015-12-07 4:25 | MySQL Server: DML | Verified (3610 days) | S3 | 5.7.8, 5.6.29, 5.7.11 | Any | Any | Maximum display width for select list is different for 'utf8' and 'utf8mb4' |
| 79527 | 2015-12-04 12:58 | 2017-08-08 19:08 | MySQL Server: DML | Verified (3000 days) | S3 | 5.6.27 | Any | Any | Errorcode 175: abort in group by on big tables |
| 79530 | 2015-12-04 17:59 | 2015-12-09 3:04 | MySQL Server: DML | Verified (3613 days) | S3 | 5.5 5.6 5.7 | Windows | Any | Power() Function unexpected results when multiplied by decimal |
| 79540 | 2015-12-07 6:53 | 2016-01-11 1:57 | MySQL Server: DML | Closed (3575 days) | S1 | 5.7.9 | CentOS (5.6) | Any | Generated Column Issue |
| 79549 | 2015-12-07 21:14 | 2016-01-16 15:15 | MySQL Server: DML | Closed (3570 days) | S3 | 5.7.9 | Any | Any | Regression: “unknown column” for outer computed values used inside a subquery |
| 79551 | 2015-12-08 3:55 | 2015-12-17 15:38 | MySQL Server: DML | Not a Bug (3600 days) | S3 | 5.7.8 | Any | Any | "select * from (select * from u1 ) u2 for update" is not locking rows in u1 |
| 79565 | 2015-12-09 7:11 | 2015-12-09 8:34 | MySQL Server: DML | Verified (3608 days) | S3 | 5.7.8,5.5.48, 5.6.29, 5.7.9 | Any | Any | Function insert work incorrectly with multiple-type utf8 character |
| 79567 | 2015-12-09 7:41 | 2019-11-28 22:55 | MySQL Server: DML | Closed (2158 days) | S3 | 5.7.8, 5.5.48, 5.6.29, 5.7.9 | Any | Any | Output scale for IFNULL() with join is not correct |
| 79571 | 2015-12-09 10:02 | 2019-12-02 22:09 | MySQL Server: DML | Closed (2154 days) | S2 | 5.0/5.1/5.5/5.6/5.7 | Any | Any | "select distinct" are returning incorrect values |
| 79576 | 2015-12-09 14:30 | 2015-12-14 8:55 | MySQL Server: DML | Not a Bug (3603 days) | S3 | 5.6 | Any | Any | Equivalent subqueries returns different results |
| 79587 | 2015-12-10 7:40 | 2019-12-02 22:14 | MySQL Server: DML | Closed (2154 days) | S3 | 5.7.8, 5.7.9, 5.6.27, 5.5.48 | Any | Any | "UNIX_TIMESTAMP(count(a))" is expected to return 0, not NULL |
| 79588 | 2015-12-10 8:19 | 2015-12-10 9:36 | MySQL Server: DML | Verified (3607 days) | S3 | 5.0/5.1/5.5/5.6/5.7 | Any | Any | "select database()" can return database name which was deleted in other session |
| 79589 | 2015-12-10 8:51 | 2019-12-02 22:21 | MySQL Server: DML | Closed (2154 days) | S3 | 5.7.8, 5.7.10, 5.6.29 | Any | Any | FLOOR(bigint column expr) return different result type (NEWDECIMAL/LONGLONG) |
| 79590 | 2015-12-10 9:33 | 2016-01-06 16:56 | MySQL Server: DML | Closed (3580 days) | S2 | 5.7.9 | MacOS | Any | ERROR 1093 (HY000): You can't specify target table '.' for update in FROM clause |
| 79594 | 2015-12-10 14:19 | 2015-12-11 10:15 | MySQL Server: DML | Verified (3607 days) | S3 | 5.6/5.7 | Ubuntu | Any | Small bug in INET6_NTOA() function |
| 79624 | 2015-12-14 2:52 | 2018-06-25 11:17 | MySQL Server: DML | Verified (2679 days) | S3 | 5.5/5.6/5.7/8.0 | Any | Any | "alter column c1 set default current_stamp" is not working |
| 79656 | 2015-12-16 4:00 | 2015-12-16 7:59 | MySQL Server: DML | Verified (3601 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | "'2' + 0.0, group_concat('2') + 0.0" are returning different result |
| 79657 | 2015-12-16 4:10 | 2019-12-02 22:37 | MySQL Server: DML | Closed (2154 days) | S3 | 5.7.8, 5.7.10, 5.6.28 | Any | Any | Bigint unsigned column value in CASE WHEN operator is converted to bigint signed |
| 79683 | 2015-12-16 23:10 | 2016-10-13 7:14 | MySQL Server: DML | Verified (3601 days) | S3 | Any | Any | Few improvements related to CPU cache line size and padding (contribution) | |
| 79690 | 2015-12-17 12:54 | 2015-12-17 19:33 | MySQL Server: DML | Not a Bug (3600 days) | S3 | 5.7.8 | Any | Any | Insert -0.1 and string '-0.1' into unsigned int returns different result |
| 79695 | 2015-12-18 4:25 | 2016-01-16 15:55 | MySQL Server: DML | Closed (3570 days) | S2 | 5.7.8, 5.6.28, 5.7.10 | Any | Any | True where clause doesn't return expected row, but empty set |
| 79753 | 2015-12-23 8:47 | 2015-12-24 15:20 | MySQL Server: DML | Not a Bug (3593 days) | S3 | 5.7.8 | Any | Any | In SET stmt, different set operations are not executed sequentially |
| 79792 | 2015-12-29 3:12 | 2019-12-02 22:41 | MySQL Server: DML | Closed (2154 days) | S3 | 5.0/5.1/5.5/5.6/5.7 | Any | Any | NULL value is inserted explicitly into NOT NULL column unexpected |
| 79804 | 2015-12-29 12:36 | 2015-12-30 16:54 | MySQL Server: DML | Not a Bug (3587 days) | S3 | 5.7.8 | Any | Any | Inconsistent results when inserting 0.1 into datetime(6) and timestamp(6) |
| 79810 | 2015-12-30 10:03 | 2015-12-30 13:42 | MySQL Server: DML | Verified (3587 days) | S3 | 5..1/5.5/5.6/57 | Any | Any | Extreme big number with IN operator gives in consistent result |
| 79830 | 2016-01-04 9:42 | 2016-01-04 12:08 | MySQL Server: DML | Verified (3582 days) | S1 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | IN operator works incorrectly with NULL |
| 79848 | 2016-01-05 12:20 | 2019-12-09 20:31 | MySQL Server: DML | Closed (2147 days) | S3 | 5.7.8, 5.6.28, 5.7.10 | Any | Any | Comparison of datetime string to time fails with ERROR 1267 |
| 79849 | 2016-01-05 13:08 | 2016-02-08 10:09 | MySQL Server: DML | Verified (3547 days) | S2 | 5.6.23, 5.6.28, 5.7.10 | CentOS | Any | STR_TO_DATE function not working for numeric month (0...12) |
| 79857 | 2016-01-06 2:41 | 2016-01-19 17:31 | MySQL Server: DML | Closed (3567 days) | S2 | 5.7.8, 5.7.10 | Any | Any | select cast(100 as unsigned) between 1 and -1 returns true |
| 79873 | 2016-01-07 14:11 | 2016-10-03 18:11 | MySQL Server: DML | Closed (3309 days) | S3 | 5.7.10 | MacOS (10.11.2) | Any | DROP TRIGGER after RENAME TABLE results in Error Code 1146: table doesn't exist. |
| 79878 | 2016-01-08 6:58 | 2020-10-07 16:24 | MySQL Server: DML | Closed (1844 days) | S2 | 5.7.8, 5.6.28, 5.7.10 | Any | Any | "-1 BETWEEN 9223372036854775808 AND 1" gives True |
| 79884 | 2016-01-08 9:33 | 2019-12-09 21:02 | MySQL Server: DML | Closed (2147 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | "SUBSTRING_INDEX( 'a', 'b', 6192449487634432 )" returns '',not expected 'a' |
| 79890 | 2016-01-08 12:10 | 2016-01-08 14:42 | MySQL Server: DML | Not a Bug (3578 days) | S3 | 5.7.8 | Any | Any | Function GREATEST(bigint, date) is not working as expected |
| 79891 | 2016-01-08 12:44 | 2016-01-08 14:40 | MySQL Server: DML | Verified (3578 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | "case when" and IF() are not returning result with general precision |
| 79902 | 2016-01-09 15:46 | 2016-01-19 17:23 | MySQL Server: DML | Closed (3567 days) | S2 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Function GREATEST and LEAST works incorrectly with bigint unsigned value |
| 79906 | 2016-01-11 3:55 | 2016-01-13 9:21 | MySQL Server: DML | Verified (3573 days) | S3 | 5.7.8, 5.6.28, 5.7.10, 5.5.48 | Any | Any | Implicit and Explicit convert from bigint unsigned to signed give different val |
| 79908 | 2016-01-11 4:47 | 2019-12-09 21:21 | MySQL Server: DML | Closed (2147 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | date comparison has inconsistent behavior between = and CASE WHEN |
| 79909 | 2016-01-11 6:23 | 2020-10-05 12:18 | MySQL Server: DML | Closed (1846 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Get mess code for func INSERT() with str as int const and newstr as multi-byte |
| 79910 | 2016-01-11 6:41 | 2021-02-17 12:00 | MySQL Server: DML | Closed (1711 days) | S3 | 5.7.8, 5.6.28, 5.7.10 | Any | Any | NULLIF fails with ERROR 1271 with date and multi-type character |
| 79911 | 2016-01-11 6:52 | 2019-12-09 21:44 | MySQL Server: DML | Closed (2147 days) | S3 | 5.7.8, 5.6.28, 5.7.10 | Any | Any | Get ERROR 1267 with string LIKE date |
| 79912 | 2016-01-11 7:10 | 2016-01-20 16:51 | MySQL Server: DML | Closed (3566 days) | S3 | 5.7.8,5.5.48, 5.6.28, 5.7.10 | Any | Any | Function REPLACE with binary op doesn't return expected NULL, with param as NULL |
| 79913 | 2016-01-11 7:45 | 2019-12-09 21:49 | MySQL Server: DML | Closed (2147 days) | S3 | 5.7.8, 5.7.10 | Any | Any | Function FOUND_ROW() works incorrectly with previous select w/ aggr ret NULL |
| 79915 | 2016-01-11 8:18 | 2016-01-11 9:34 | MySQL Server: DML | Verified (3575 days) | S3 | 5.7.8, 5.6.28, 5.7.10 | Any | Any | Function NULLIF + CAST is not working as expected |
| 79916 | 2016-01-11 9:34 | 2016-01-15 4:25 | MySQL Server: DML | Verified (3571 days) | S3 | 5.7.8, 5.6.28, 5.7.10 | Any | Any | Comparison gives inconsistent result for time(1) column and explicit cast result |
| 79917 | 2016-01-11 12:41 | 2016-01-13 8:10 | MySQL Server: DML | Verified (3573 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Func COALESCE( date, timestamp) and datetime are not working consistently |
| 79919 | 2016-01-11 19:02 | 2016-01-12 9:13 | MySQL Server: DML | Can't repeat (3574 days) | S2 | 5.6 | Windows | Any | LOAD XML inheritance can fail when loading multiple tables |
| 79923 | 2016-01-12 3:22 | 2016-01-12 7:20 | MySQL Server: DML | Duplicate (3574 days) | S2 | 5.7.8, 5.6.28, 5.7.10 | Any | Any | Aggr function, UPPER() and REPEAT() give incorrect output |
| 79924 | 2016-01-12 6:38 | 2016-01-21 23:04 | MySQL Server: DML | Closed (3565 days) | S2 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Func CONVERT and CONVERT(,BINARY) works incorrect w/ multi-byte+multi-rows |
| 79925 | 2016-01-12 8:07 | 2023-04-10 2:40 | MySQL Server: DML | Verified (3574 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | String const '69E5' is not treated as scientific notation when casting to int |
| 79926 | 2016-01-12 8:26 | 2016-01-19 3:41 | MySQL Server: DML | Not a Bug (3567 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Func IFNULL truncate unsigned param to signed range |
| 79928 | 2016-01-12 9:03 | 2016-01-19 3:41 | MySQL Server: DML | Not a Bug (3567 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Func COALEASE truncates unsigned param to signed |
| 79929 | 2016-01-12 9:08 | 2019-12-09 21:55 | MySQL Server: DML | Closed (2147 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Func CASE WHEN truncates unsigned value to signed |
| 79930 | 2016-01-12 9:11 | 2019-12-09 21:57 | MySQL Server: DML | Closed (2147 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Func IF() truncates unsigned value to signed |
| 79936 | 2016-01-12 15:34 | 2016-01-13 7:20 | MySQL Server: DML | Verified (3573 days) | S3 | 5.7.8, 5.6.28, 5.7.10 | Any | Any | "c1(NULL) > 1 && c2('00:00:00.0') = '00:00:00.000001'" returns NULL, not 0 |
| 79937 | 2016-01-12 15:42 | 2016-01-13 12:15 | MySQL Server: DML | Not a Bug (3573 days) | S3 | 5.6.27 | Any | Any | Incorrect record updated using ON DUPLICATE KEY UPDATE processing |
| 79947 | 2016-01-13 7:43 | 2016-01-13 9:44 | MySQL Server: DML | Duplicate (3573 days) | S3 | 5.7.8, 5.5.48, 5.6.28 | Any | Any | Func ROUND(num, c1(NULL)) doesn't return NULL |
| 79949 | 2016-01-13 9:17 | 2016-01-13 9:27 | MySQL Server: DML | Verified (3573 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | "CONCAT( '2005' , '-01-01') - 100" doesn't throw any warning |
| 79974 | 2016-01-14 3:04 | 2016-01-14 13:08 | MySQL Server: DML | Verified (3572 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | "Out of range value for column '(null)'" is not clear enough |
| 79978 | 2016-01-14 7:39 | 2016-02-08 16:42 | MySQL Server: DML | Closed (3547 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Func SUBSTRING_INDEX works incorrectly when the count param is a bigint unsigned |
| 79988 | 2016-01-14 15:38 | 2016-01-29 18:46 | MySQL Server: DML | Closed (3557 days) | S1 | 5.6, 5.6.28 | Ubuntu (12.04 LTS) | Any | ExtractValue return NULL instead empty string when do not find a XML path |
| 80022 | 2016-01-18 3:14 | 2016-01-18 4:45 | MySQL Server: DML | Can't repeat (3568 days) | S5 | 5.6.21 | Windows (Microsoft Windows 7 Home Premium) | Any | LEFT JOIN with Null test NOW Fails |
| 80045 | 2016-01-19 9:03 | 2016-01-19 10:52 | MySQL Server: DML | Verified (3567 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Syntax error returned for invalid D in DECIMAL(M, D), ERROR 1427 expected |
| 80046 | 2016-01-19 9:18 | 2016-01-19 10:22 | MySQL Server: DML | Verified (3567 days) | S3 | 5.7.8, 5.6.28, 5.7.10 | Any | Any | Inconsistent result returned for equivalent string input in CAST(str AS DATE) |
| 80047 | 2016-01-19 9:59 | 2016-01-27 15:13 | MySQL Server: DML | Closed (3560 days) | S2 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Data rows lost after adding DISTINCT with substr() in select list |
| 80064 | 2016-01-20 8:50 | 2016-05-26 15:01 | MySQL Server: DML | Closed (3439 days) | S1 | 5.7.9,5.7.10 | Any | Any | SELECT STR_TO_DATE('09:30:17','%h:%i:%s') return NULL value |
| 80068 | 2016-01-20 10:57 | 2019-12-24 15:46 | MySQL Server: DML | Closed (2132 days) | S1 | 5.7.10, 5.7.15 | Windows | Any | Invalid result of Query |
| 80080 | 2016-01-20 17:22 | 2017-01-27 16:37 | MySQL Server: DML | Closed (3236 days) | S2 | 5.7.12-debug | Any | Any | Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_i |
| 80088 | 2016-01-21 0:46 | 2016-01-27 8:29 | MySQL Server: DML | Verified (3560 days) | S3 | 5.6/5.7 | Other (Amazon RDS and OSX) | Any | Where in subquery referencing md5 computed column in view causes duplicate rows |
| 80094 | 2016-01-21 9:48 | 2019-12-11 21:36 | MySQL Server: DML | Closed (2145 days) | S3 | 5.7.10 | Any | Any | Assertion `type() != MYSQL_TYPE_TIMESTAMP' failed in sql/field.cc:1615 |
| 80099 | 2016-01-21 13:18 | 2018-06-04 1:00 | MySQL Server: DML | No Feedback (2701 days) | S2 | 5.5.47 | CentOS | Any | Wrong Collation cp1256_general_ci for CP1256 Charset |
| 80107 | 2016-01-22 1:56 | 2016-02-04 20:18 | MySQL Server: DML | Can't repeat (3551 days) | S2 | 5.6.12 | CentOS | Any | mysqld got signal 11 ; |
| 80118 | 2016-01-22 14:45 | 2016-01-25 9:59 | MySQL Server: DML | Verified (3561 days) | S1 | 5.6.26, 5.6.28, 5.7.10 | Any | Any | STR_TO_DATE doesn't work properly |
| 80149 | 2016-01-26 8:10 | 2018-08-15 8:58 | MySQL Server: DML | Verified (3560 days) | S3 | 5.7.10 | Windows | Any | 32-bit win, internal_tmp_disk_storage_engine=innodb, The table is full, >=4GB |
| 80154 | 2016-01-26 12:33 | 2016-01-26 13:41 | MySQL Server: DML | Verified (3560 days) | S3 | 5.0/5.1/5.5/5.6/5.7 | Any | Any | Function ROUND( int value, 10) gets padding 0s |
| 80186 | 2016-01-28 13:15 | 2016-01-28 13:54 | MySQL Server: DML | Not a Bug (3558 days) | S3 | 5.5.38-log | Windows | Any | the group by colunm is trimed when do group by |
| 80221 | 2016-02-01 14:19 | 2016-02-01 15:13 | MySQL Server: DML | Not a Bug (3554 days) | S2 | Any | Any | Any | Error in search record by field type double, returns nothing |
| 80227 | 2016-02-02 4:24 | 2016-02-02 7:49 | MySQL Server: DML | Verified (3553 days) | S3 | 5.7.8, 5.7.10, 5.6.28, 5.5.48 | Any | Any | Func SUBSTRING_INDEX works incorrectly with negative count |
| 80271 | 2016-02-04 20:18 | 2016-07-11 12:15 | MySQL Server: DML | Duplicate (3393 days) | S1 | 5.7.11 | Windows (10, 2012 R2) | Any | Generated columns are required in INSERT INTO ... SELECT * FROM ... commands |
| 80293 | 2016-02-05 19:48 | 2016-07-11 12:15 | MySQL Server: DML | Not a Bug (3548 days) | S1 | 5.7.11 | Any | Any | INSERT ... SELECT * FROM does not work for tables with generated columns |
| 80364 | 2016-02-15 10:03 | 2019-12-11 21:59 | MySQL Server: DML | Closed (2145 days) | S3 | 5.7.8, 5.6.29, 5.7.11 | Any | Any | CASE WHEN timestamp with microseconds are not working as expected |
| 80384 | 2016-02-16 7:31 | 2016-02-16 11:12 | MySQL Server: DML | Duplicate (3539 days) | S1 | 5.7.11 | CentOS (7) | Any | Can not use insert into select * for table with generated column |
| 80404 | 2016-02-17 11:06 | 2016-02-17 13:28 | MySQL Server: DML | Verified (3538 days) | S3 | 5.0/5.1/5.5/5.6/5.7 | Any | Any | After sql_warnings to 0, the INSERT still get warnings message |
| 80440 | 2016-02-19 6:13 | 2016-02-19 9:12 | MySQL Server: DML | Duplicate (3536 days) | S3 | 5.6.29, 5.6.30 | CentOS | Any | Assertion `item_in->left_expr->cols() == 1' failed in sql/item_subselect.cc:382 |
| 80492 | 2016-02-24 11:37 | 2016-02-25 4:57 | MySQL Server: DML | Verified (3531 days) | S3 | 5.0/5.1/5.5/5.6/5.7 | Any | Any | Weird results when quoted number is added to a bigint value |
| 80533 | 2016-02-26 14:46 | 2016-02-26 16:16 | MySQL Server: DML | Verified (3529 days) | S3 | 5.6, 5.7 | Any | Any | PASSWORD(NULL) returns empty string, should be NULL according to documentation |
| 80630 | 2016-03-07 7:47 | 2016-09-19 8:20 | MySQL Server: DML | Closed (3475 days) | S3 | 5.5+ | Any | Any | CAST( .. AS BINARY(N)) gets unexpected NULL |
| 80681 | 2016-03-10 7:24 | 2016-03-11 8:07 | MySQL Server: DML | Verified (3515 days) | S3 | 5.7.11 | CentOS | Any | Failing assertion: len <= fixed_len in in file rem0rec.cc line 886 |
| 80682 | 2016-03-10 8:44 | 2016-03-10 11:50 | MySQL Server: DML | Verified (3516 days) | S3 | 5.7.8, 5.7.11 | Any | Any | Inconsistent behavior with GROUP BY alias, w/ different sequence in select list |
| 80703 | 2016-03-11 9:21 | 2019-12-11 22:32 | MySQL Server: DML | Not a Bug (2145 days) | S3 | 5.7.11, 5.6.29 | Windows (10) | Any | DATE('space') can not be inserted to DATE type with IFNULL in INSERT-SELECT |
| 80775 | 2016-03-17 9:37 | 2016-03-23 8:51 | MySQL Server: DML | Verified (3503 days) | S3 | 5.6.24-72.2-log, 5.6.29, 5.7.11 | Ubuntu (14.04.4) | Any | "Out of range value for column XXX" in DML is missleading |
| 80873 | 2016-03-29 2:40 | 2016-04-09 16:10 | MySQL Server: DML | Closed (3486 days) | S3 | 5.7.8, 5.7.9, 5.6.29, 5.7.11 | Any | Any | Function FLOOR(CEIL()) truncates bigint unsigned |
| 80885 | 2016-03-29 12:59 | 2025-01-03 21:23 | MySQL Server: DML | Verified (3494 days) | S2 | 5.7.11 | Debian (Debian GNU/Linux 8 (jessie)) | Any | Not null update fails with an "Column cannot be null" error. |
| 80990 | 2016-04-07 8:22 | 2019-12-11 22:48 | MySQL Server: DML | Closed (2145 days) | S3 | 5.7.11, 5.6.29, 5.5 | Windows (Microsoft Windows 7 Enterprise Service Pack 1) | Any | "... not in (select null from ...)" should return no rows |
| 81024 | 2016-04-09 19:53 | 2016-04-09 21:45 | MySQL Server: DML | Verified (3486 days) | S5 | 5.0/5.1/5.5/5.6/5.7 | Windows (Microsoft Windows 7 Enterprise Service Pack 1) | Any | HAVING without GROUP BY should imply an aggregation of a single group |
| 81035 | 2016-04-12 1:57 | 2016-04-12 7:43 | MySQL Server: DML | Verified (3483 days) | S3 | 5.7.8, 5.5.49, 5.6.30, 5.7.12 | Any | Any | `NEWDECIMAL` result for ROUND() function is out of range of 65 digits |
| 81191 | 2016-04-25 11:10 | 2016-09-02 16:26 | MySQL Server: DML | Verified (3469 days) | S3 | 5.7.11 | Windows | Any | CREATE TABLE ... SELECT caused ERROR 1114 while destination reached over 4 Gb |
| 81200 | 2016-04-26 12:52 | 2016-04-30 10:16 | MySQL Server: DML | Verified (3465 days) | S3 | 5.0, 5.6 | Any | Any | User-defined variable changes value in SELECT assignment when it shouldn't |
| 81225 | 2016-04-28 16:48 | 2016-06-27 1:00 | MySQL Server: DML | No Feedback (3408 days) | S3 | 5.6.30 | CentOS (3.10.0-327.13.1.el7.x86_64) | Any | str_to_date with before insert trigger results in null |
| 81254 | 2016-05-01 7:53 | 2016-05-02 10:10 | MySQL Server: DML | Verified (3463 days) | S2 | 5.6, 5.6.30, 5.7.12 | Any | Any | Using INSERT_ID local variable, makes REPLACE fail when there is a duplicate key |
| 81259 | 2016-05-01 16:29 | 2016-05-02 5:53 | MySQL Server: DML | Verified (3463 days) | S3 | 5.7.8, 5.5.49, 5.6.30, 5.7.12 | Any | Any | Get unexpected `Empty Set` for correlated subquery with aggregate functions |
| 81299 | 2016-05-03 21:08 | 2016-05-06 14:17 | MySQL Server: DML | Duplicate (3459 days) | S2 | 5.6.30, 5.7.12 | Ubuntu | Any | Unique index does not handle German umlauts properly |
| 81302 | 2016-05-04 6:41 | 2023-04-09 11:55 | MySQL Server: DML | Verified (3461 days) | S3 | 5.7.8, 5.6.30, 5.7.12 | Any | Any | w/o group by, query with column in having clause not in select list, succeeds |
| 81410 | 2016-05-13 4:12 | 2019-01-23 11:50 | MySQL Server: DML | Unsupported (2467 days) | S1 | 5.5.49 | Any | Any | Assertion `multi_range_length > 0' failed. in QUICK_RANGE_SELECT::reset |
| 81486 | 2016-05-18 11:43 | 2016-05-24 18:51 | MySQL Server: DML | Closed (3446 days) | S3 | 5.6.30, 5.5.49 | Debian | Any | ERROR 1452 throws as ERROR 1062 if query has ON DUPLICATE stament |
| 81508 | 2016-05-19 13:22 | 2016-05-20 8:52 | MySQL Server: DML | Verified (3445 days) | S3 | 5.7.8, 5.7.12, 5.6.30 | Any | Any | Type in meta data for "cast('a' as char(100))" is VAR_STRING |
| 81513 | 2016-05-19 19:39 | 2016-05-23 7:15 | MySQL Server: DML | Not a Bug (3442 days) | S3 | 5.7.11, 5.7.12, 5.6.30 | Windows | Any | Incorrect result of ROUND with subquery |
| 81533 | 2016-05-23 4:25 | 2016-05-23 7:24 | MySQL Server: DML | Verified (3442 days) | S3 | 5.7.8, 5.5.49, 5.6.30, 5.7.12 | Any | Any | Get different results when comparing YEAR(4) with 2-digit const and 2-digit col |
| 81578 | 2016-05-24 18:38 | 2016-05-24 18:51 | MySQL Server: DML | Duplicate (3441 days) | S3 | 5.5.49 | Any | Any | INSERT ON DUPLICATE KEY UPDATE statement returning 1062 instead of 1452 |
| 81606 | 2016-05-26 9:12 | 2019-03-01 14:24 | MySQL Server: DML | Closed (2430 days) | S3 | 5.1.73, 5.5.49, 5.6.30, 5.7.12 | Any | Any | Variable-name's typo in sql/item_func.cc |
| 81638 | 2016-05-30 7:40 | 2019-12-16 22:46 | MySQL Server: DML | Closed (2140 days) | S2 | 5.7.8, 5.5.49, 5.6.30, 5.7.12 | Any | Any | Function substr with order by gives incorrect result |
| 81673 | 2016-06-01 11:12 | 2016-06-01 11:28 | MySQL Server: DML | Verified (3433 days) | S3 | 5.7.8 | Any | Any | UNION ALL returned incorrect result |
| 81684 | 2016-06-02 6:05 | 2016-06-02 13:22 | MySQL Server: DML | Verified (3432 days) | S1 | 5.7.8, 5.6.30, 5.7.12 | Any | Any | select + where exists( select + group by + limit) works incorrectly |
| 81685 | 2016-06-02 9:43 | 2016-06-02 18:37 | MySQL Server: DML | Verified (3432 days) | S3 | 5.7.8, 5.6.12 | Any | Any | "select current_time(256)" succeeds while error is expected |
| 81686 | 2016-06-02 10:01 | 2016-07-03 1:00 | MySQL Server: DML | No Feedback (3402 days) | S1 | 5.6.30 | CentOS | Any | COUNT(PRIMARY_KEY) returns 0 with more than one WHERE clause |
| 81767 | 2016-06-08 4:44 | 2016-06-08 7:38 | MySQL Server: DML | Verified (3426 days) | S3 | 5.7.8, 5.6.30,5.6.31, 5.7.12, 5.7.13 | Any | Any | Comparison result for column w/ YEAR(4) and const w/ 2 digits is incorrect |
| 81816 | 2016-06-11 19:53 | 2019-12-19 22:47 | MySQL Server: DML | Closed (2137 days) | S2 | 5.6.31 | Any | Any | Invalid select query result on FIRST time |
| 81835 | 2016-06-13 16:55 | 2016-06-13 22:56 | MySQL Server: DML | Duplicate (3421 days) | S3 | 5.7.13 | Windows (windows 10 and mac el capitan) | Any | Ordering by aggregation column does not work when longtext column is present |
| 81855 | 2016-06-15 8:07 | 2016-06-15 12:17 | MySQL Server: DML | Verified (3419 days) | S2 | 5.7.8, 5.5.50, 5.6.31, 5.7.13 | Any | Any | Subquery with Empty Set in result returns incorrect result |
| 81876 | 2016-06-16 7:30 | 2016-06-20 11:09 | MySQL Server: DML | Verified (3414 days) | S3 | 5.5.50, 5.6.31, 5.7.13 | Linux | Any | neg op returns diff results |
| 81933 | 2016-06-20 12:21 | 2019-12-24 13:32 | MySQL Server: DML | Not a Bug (2132 days) | S3 | 5.6, 5.6.31, 5.7.13 | Linux | Any | select timestamp reports an error |
| 81940 | 2016-06-21 3:31 | 2019-12-24 13:28 | MySQL Server: DML | Closed (2132 days) | S3 | 5.7.8, 5.5.50, 5.6.31,5.7.13 | Any | Any | Order by substr() returns incorrect result |
| 81950 | 2016-06-21 11:06 | 2016-07-27 9:41 | MySQL Server: DML | Not a Bug (3377 days) | S3 | 5.6 | Linux | Any | when cast failed mysql return different results |
| 81951 | 2016-06-21 11:15 | 2016-06-21 12:23 | MySQL Server: DML | Verified (3413 days) | S3 | 5.6, 5.6.31, 5.5.50 | Linux | Any | strcmp returns unexpected value |
| 81963 | 2016-06-22 2:37 | 2019-10-24 10:46 | MySQL Server: DML | Not a Bug (3403 days) | S3 | 5.7.8, 5.6.31, 5.7.13 | Any | Any | Get incorrect result for -2 into unsigned column and cast -2 to unsigned |
| 81969 | 2016-06-22 9:03 | 2019-12-24 13:45 | MySQL Server: DML | Closed (2132 days) | S3 | 5.6, 5.6.31 | Linux | Any | case when returns weird results when meets unsigned |
| 81990 | 2016-06-23 18:51 | 2019-12-24 13:49 | MySQL Server: DML | Closed (2132 days) | S3 | Any | Any | LIKE condition with multiple backslashes, must add extra \ at the end | |
| 81995 | 2016-06-24 6:51 | 2019-12-24 13:39 | MySQL Server: DML | Closed (2132 days) | S2 | 5.7.8, 5.6.31, 5.7.13 | Any | Any | col(const) IN (-1.49) returns true in WHERE condition with index on col |
| 82011 | 2016-06-27 7:56 | 2019-12-24 13:53 | MySQL Server: DML | Closed (2132 days) | S3 | 5.6, 5.5.50, 5.6.31,5.7.13 | Linux | Any | and operation returns weird results |
| 82070 | 2016-06-30 17:14 | 2018-10-11 7:51 | MySQL Server: DML | Not a Bug (2571 days) | S3 | 5.6.30, 5.6.31, 5.7.13 | SUSE (Leap 42) | Any | UNIX_TIMESTAMP() returns decimal (NO fractional seconds part) |
| 82085 | 2016-07-02 0:28 | 2016-07-02 20:33 | MySQL Server: DML | Verified (3402 days) | S3 | 5.6.12, 5.5.50, 5.6.31,5.7.13 | Windows | Any | FORMAT(..., bg_BG) generates zero bytes |
| 82086 | 2016-07-02 5:12 | 2019-12-24 14:22 | MySQL Server: DML | Can't repeat (2132 days) | S3 | 5.6.13, 5.6.31, 5.7.13 | Any | Any | PROCEDURE ANALYSE() is antiquated |
| 82090 | 2016-07-03 18:21 | 2016-07-04 7:54 | MySQL Server: DML | Verified (3400 days) | S3 | 5.6.31, 5.7.13 | Any | Any | South Asian / Indian / Vedic number system with FORMAT() |
| 82166 | 2016-07-08 10:27 | 2016-07-08 11:10 | MySQL Server: DML | Not a Bug (3396 days) | S2 | 5.6.30 | CentOS (Linux 2.6.32-431.11.5.el6.ucloud.x86_64 #1 SMP) | Any | update the other field which isn't the specified field. |
| 82189 | 2016-07-11 21:19 | 2016-07-12 9:18 | MySQL Server: DML | Verified (3392 days) | S3 | 5.7.12 MySQL Community Server (GPL), 5.6.31, 5.7.13 | Any | Any | DELETE via the alias of fully qualified table reference fails with ERROR 1046 |
| 82194 | 2016-07-12 5:47 | 2016-07-13 4:14 | MySQL Server: DML | Not a Bug (3392 days) | S3 | 5.6.12, 5.7.13 | Any | Any | innodb_large_prefix does not honor UNIQUEness past 255 |
| 82201 | 2016-07-12 16:11 | 2016-07-13 13:57 | MySQL Server: DML | Can't repeat (3391 days) | S3 | 5.7.12 | CentOS (Linux mysqlcl2 2.6.32-642.1.1.el6.x86_64 #1 SMP Tue May 31 21:57:07 UTC 2016 x86_64 x86_64 x86_64 GN) | Any | '2015-03-08 02:00:00' and '2015-03-08 02:59:59' data could not be inserted |
| 82238 | 2016-07-15 3:22 | 2019-12-24 14:46 | MySQL Server: DML | Not a Bug (2132 days) | S1 | 5.7.13, 5.5.50, 5.6.31 | Any | Any | Various incorrect looking errors for multi-table DELETE statements |
| 82264 | 2016-07-18 9:24 | 2016-07-20 8:45 | MySQL Server: DML | Duplicate (3384 days) | S1 | 5.7.13 | Any | Any | cannot insert into table when 1. have date column, 2. select using like with '%' |
| 82495 | 2016-08-08 18:51 | 2016-11-18 7:51 | MySQL Server: DML | Closed (3263 days) | S3 | 5.6/5.7 | Linux | Any | UPPER not working properly with AES Encryption |
| 82559 | 2016-08-12 3:08 | 2016-08-16 20:12 | MySQL Server: DML | Verified (3361 days) | S2 | 5.6, 5.7.14, 5.6.32 | Linux | Any | a bug about union with subquery |
| 82560 | 2016-08-12 3:32 | 2016-08-16 10:10 | MySQL Server: DML | Verified (3361 days) | S3 | 5.5.51, 5.6.32, 5.7.14 | Linux | Any | nested limit produces counter intuitive result |
| 82562 | 2016-08-12 5:12 | 2016-08-12 7:56 | MySQL Server: DML | Not a Bug (3361 days) | S3 | 5.6.31,5.7.14 | Any | Any | exists (select max(id) from t3 where id=2) produced the undesired result |
| 82582 | 2016-08-15 11:05 | 2016-08-15 13:34 | MySQL Server: DML | Verified (3358 days) | S3 | 5.6/5.7 | Linux | Any | inconsistent and ambiguous results with cast decimal to datetime |
| 82638 | 2016-08-18 17:48 | 2016-11-19 16:25 | MySQL Server: DML | Closed (3265 days) | S3 | 5.7.2 | Any | Any | Incorrect evaluation of MIN/MAX referring to an outer query block |
| 82640 | 2016-08-19 3:30 | 2016-08-19 7:54 | MySQL Server: DML | Duplicate (3354 days) | S3 | 5.6 | Linux | Any | cast string to datetime produces invalid value |
| 82642 | 2016-08-19 3:58 | 2016-08-19 7:59 | MySQL Server: DML | Verified (3354 days) | S3 | 5.6, 5.5.51, 5.6.32 | Any | Any | insert string-format value to datetime and timestamp return different status |
| 82686 | 2016-08-22 23:56 | 2016-08-23 16:24 | MySQL Server: DML | Can't repeat (3350 days) | S3 | 5.6.30 | FreeBSD | Any | convert_tz returns null - timezones are loaded |
| 82752 | 2016-08-27 15:02 | 2016-08-28 12:02 | MySQL Server: DML | Not a Bug (3345 days) | S5 | 6.3.7 | Windows (Microsoft Windows 7 Ultimate Service Pack 1) | Any | SHOW TABLE STATUS WHERE `Name` = returns different value after db stop-start |
| 82912 | 2016-09-08 18:56 | 2019-12-24 15:26 | MySQL Server: DML | Closed (2132 days) | S1 | 5.6.33 | Any | Any | COUNT DISTINCT returns wrong result when tmp files are used by MySQL |
| 82915 | 2016-09-09 2:27 | 2016-09-09 5:38 | MySQL Server: DML | Verified (3333 days) | S3 | 5.7.13, 5.7.15 | Any | Any | SIGKILL myself when using innodb_limit_optimistic_insert_debug=2 and drop table |
| 82921 | 2016-09-09 8:29 | 2019-12-24 15:30 | MySQL Server: DML | Closed (2132 days) | S3 | 5.6 | Linux | Any | regex return inconsistent results with invalid pattern |
| 82960 | 2016-09-12 19:29 | 2016-10-04 15:48 | MySQL Server: DML | Closed (3308 days) | S3 | 8.0.0 | Any | Any | Removing an invisible index breaks explain |
| 83021 | 2016-09-16 10:02 | 2016-09-16 10:16 | MySQL Server: DML | Verified (3326 days) | S3 | 5.6.33, 5.5.52 | Any | Any | Assertion "buf != end" failed |
| 83031 | 2016-09-18 8:09 | 2016-11-16 1:20 | MySQL Server: DML | Closed (3265 days) | S3 | 5.7, 5.6.33, 5.7.15, 5.5.52 | Linux | Any | bin return inconsistent results with params of datetype bit |
| 83051 | 2016-09-20 9:49 | 2016-09-20 10:01 | MySQL Server: DML | Duplicate (3322 days) | S1 | 5.7.11 | Windows | Any | Invalid Query on MySQL 5.7.11 |
| 83068 | 2016-09-21 7:15 | 2016-11-25 1:00 | MySQL Server: DML | No Feedback (3257 days) | S2 | 5.7.14 | MacOS | Any | MySQL crash with invalid query pointer |
| 83100 | 2016-09-22 14:57 | 2017-01-24 12:29 | MySQL Server: DML | Not a Bug (3196 days) | S3 | 5.5 | Ubuntu | Any | Concurrent procedure calls returning different results with an unrelated SELECT |
| 83110 | 2016-09-23 1:08 | 2017-11-30 3:57 | MySQL Server: DML | Closed (3235 days) | S3 | 5.7.15 | Any | Any | found_rows() returns 1 when no rows found |
| 83113 | 2016-09-23 4:13 | 2017-07-14 2:25 | MySQL Server: DML | Verified (3025 days) | S1 | 5.1.67,8.0-dmr | Any | Any | SIGKILL myself on DROP TABLE |
| 83114 | 2016-09-23 4:20 | 2017-01-13 17:56 | MySQL Server: DML | Closed (3207 days) | S1 | 8.0-dmr | Any | Any | Assertion `strlen(db_name) <= (64*3) && strlen(table_name) <= (64*3)' failed. |
| 83117 | 2016-09-23 4:39 | 2016-11-16 1:05 | MySQL Server: DML | Closed (3265 days) | S1 | 8.0-dmr | Any | Any | Assertion `MDL_checker::is_read_locked(m_thd, *object)' failed. |
| 83146 | 2016-09-26 7:39 | 2016-09-26 10:34 | MySQL Server: DML | Verified (3316 days) | S3 | 5.6, 5.7 | Linux | Any | time to bit produces inconsistent results |
| 83160 | 2016-09-27 7:22 | 2020-01-02 22:42 | MySQL Server: DML | Closed (2123 days) | S3 | 5.6 | Linux | Any | binary in (char) return inconsistent results |
| 83162 | 2016-09-27 8:01 | 2016-09-27 11:11 | MySQL Server: DML | Duplicate (3315 days) | S3 | 5.7, 5.7.15 | Linux | Any | ordered result should have been returned |
| 83178 | 2016-09-28 2:28 | 2016-09-28 6:47 | MySQL Server: DML | Verified (3314 days) | S3 | 5.6, 5.6.33, 5.7.15 | Linux | Any | substring(binary, 3) return inconsistent results |
| 83251 | 2016-10-04 10:01 | 2020-01-02 22:50 | MySQL Server: DML | Can't repeat (2123 days) | S3 | 5.7.15, 5.5.52, 5.6.33 | Any | Any | Cond. jump depends on uninitialised values at check_ulonglong by get_ev_num_info |
| 83286 | 2016-10-06 12:54 | 2020-01-02 22:57 | MySQL Server: DML | Closed (2123 days) | S3 | 5.7 | Any | Any | Invalid error for Subquery returns more than 1 row |
| 83311 | 2016-10-09 7:08 | 2017-07-11 11:48 | MySQL Server: DML | Closed (3263 days) | S3 | 5.7, 5.7.15 | Linux | Any | unexpected and inconsistent results with virtual column when meets index |
| 83312 | 2016-10-09 7:26 | 2020-01-02 23:05 | MySQL Server: DML | Not a Bug (2123 days) | S3 | 5.5/5.6/5.7/8.0 | Linux | Any | insert an empty string to bit field should have failed with strict sql mode |
| 83320 | 2016-10-10 13:02 | 2021-02-17 11:18 | MySQL Server: DML | Closed (1711 days) | S3 | 5.6, 5.6.33, 5.7.15 | Linux | Any | round(bin) returns unexpected negative results |
| 83362 | 2016-10-13 8:46 | 2020-01-02 23:15 | MySQL Server: DML | Closed (2123 days) | S3 | 5.6, 5.6.33, 5.7.15 | Linux | Any | inconsistent results with and operation |
| 83364 | 2016-10-13 9:03 | 2020-01-02 23:10 | MySQL Server: DML | Closed (2123 days) | S3 | 5.7, 5.6.33, 5.7.15 | Linux | Any | incorrect result with mysql functions |
| 83374 | 2016-10-13 15:58 | 2016-10-13 22:00 | MySQL Server: DML | Unsupported (3299 days) | S2 | 5.7.14 | Red Hat (64 Bit) | Any | MySQL Year 2038 |
| 83383 | 2016-10-14 3:30 | 2020-01-02 23:18 | MySQL Server: DML | Closed (2123 days) | S3 | 5.7.15 | Linux | Any | incorrect validation for logical expression in mysql5.7 |
| 83417 | 2016-10-17 22:56 | 2016-10-19 20:53 | MySQL Server: DML | Can't repeat (3293 days) | S3 | 5.5.52 | Ubuntu (14.04) | Any | After updating from 5.5.50 to 5.5.52 We now get Error 1300 with LOCAL INFILE |
| 83452 | 2016-10-20 5:54 | 2016-10-20 6:56 | MySQL Server: DML | Verified (3292 days) | S3 | 5.7, 5.5.53, 5.6.34, 5.7.16 | Linux | Any | inconsistent results returned when compare enum with integer |
| 83454 | 2016-10-20 8:09 | 2016-10-20 8:38 | MySQL Server: DML | Verified (3292 days) | S3 | 5.7 | Linux | Any | inconsistent results returned when compare enum with integer |
| 83463 | 2016-10-20 15:05 | 2016-10-21 7:36 | MySQL Server: DML | Verified (3291 days) | S2 | 5.6.31, 5.5.53, 5.6.34, 5.7.16 | CentOS (CentOS release 6.6 (Final)) | Any | str_to_date() accepts and returns invalid dates |
| 83481 | 2016-10-22 3:09 | 2023-03-14 6:33 | MySQL Server: DML | No Feedback (3259 days) | S3 | 5.7.15 | Linux | Any | Crash on Field_temporal_with_date::store_time(st_mysql_time*, unsigned char) |
| 83489 | 2016-10-23 16:50 | 2016-10-24 12:24 | MySQL Server: DML | Can't repeat (3288 days) | S3 | 5.7 | Windows | Any | Unable to "Load data Infile" |
| 83558 | 2016-10-27 3:16 | 2016-10-27 12:38 | MySQL Server: DML | Not a Bug (3285 days) | S3 | 5.7.16 | Any | Any | Is this a wrong stage? |
| 83699 | 2016-11-04 21:18 | 2017-10-20 18:24 | MySQL Server: DML | Closed (2934 days) | S3 | 5.8 | Any | Any | Wrong calculation of decimals after point for IFNULL w/ GROUP BY using tmp tbl |
| 83707 | 2016-11-06 16:08 | 2020-01-02 23:32 | MySQL Server: DML | Closed (2123 days) | S3 | 5.5/5.6 | Any | Any | Mysql left join with view of type merge returns view `ifnull` results instead of |
| 83763 | 2016-11-10 2:36 | 2016-11-10 3:47 | MySQL Server: DML | Duplicate (3271 days) | S3 | Linux | Any | unreasonable behavior for extracting year from time |
| Showing 1-1000 of 1711 (Edit, Save, CSV, Feed) | Show Next 1000 Entries » |
