Showing 1-1000 of 1638 (Edit, Save, CSV, Feed) Show Next 1000 Entries »
ID# Date Updated Type Status Sev Version OS CPU Summary
62292004-10-23
17:26
2015-01-27
15:55
MySQL Server: DMLClosed
(3753 days)
S35.0.2-debugLinux (SuSE 9.1)AnyInconsistent handling of DEFAULT on a NOT NULL column
69802004-12-03
10:20
2014-02-06
14:22
MySQL Server: DMLVerified
(4108 days)
S24.1.7Windows (Windows 2000)AnyError 1093 - You can't specify target table for update in FROM
77422005-01-08
11:06
2017-11-11
20:47
MySQL Server: DMLVerified
(4137 days)
S34.1 +Linux (Linux Red Hat 9)AnyYou can't reinvoke the same Temporary Table more than once.
84332005-02-11
2:05
2011-02-16
23:43
MySQL Server: DMLClosed
(5522 days)
S35.0.3-alpha-debugLinux (SuSE 9.1)AnyOverflow must be an error
84572005-02-11
20:41
2011-02-16
23:43
MySQL Server: DMLClosed
(5541 days)
S35.0.3-alpha-debugLinux (SuSE 9.1)AnyPrecision math: DIV returns incorrect result with large decimal value
84632005-02-11
23:30
2020-05-03
20:45
MySQL Server: DMLVerified
(6064 days)
S35.0.3-alpha-debugLinux (SuSE 9.1)AnySQRT: Should return an error when argument is negative
105732005-05-12
8:08
2019-02-13
12:26
MySQL Server: DMLVerified
(4117 days)
S24.1.11/5.6Linux (Linux)Any BOM(of UTF-8) is not correctly handled by LOAD DATA
114722005-06-21
0:08
2025-03-23
10:50
MySQL Server: DMLVerified
(6047 days)
S25.0.8/5.5/5.6/5.7AnyAnyTriggers not executed following foreign key updates/deletes
143682005-10-27
1:35
2012-05-18
20:19
MySQL Server: DMLDuplicate
(5998 days)
S25.0.15Windows (Windows XP)AnyUPPER and LOWER functions don't work with DAYNAME
154092005-12-02
2:41
2008-03-14
20:57
MySQL Server: DMLClosed
(6263 days)
S34.1.17-BK, 4.1.14Linux (Linux)AnyColumns with SET datatype with 64-element sets may not be updated with integers
159362005-12-22
12:15
2011-02-16
23:43
MySQL Server: DMLClosed
(5894 days)
S34.1.17Windows (Windows (32 bit))Any"round" differs on Windows to Unix
178952006-03-03
12:41
2016-01-28
11:01
MySQL Server: DMLCan't repeat
(3387 days)
S35.0.26-BK, 5.0.18, 5.1.43-bzrLinux (Linux, Windows)AnyIN-subselect from DUAL with impossible WHERE erroneously returns true
189132006-04-09
2:01
2018-09-09
20:45
MySQL Server: DMLVerified
(4128 days)
S25.0.21-BK, 5.0.19,5.7.4AnyAnyPhysical order of rows in table alters update behavior of unique index
213262006-07-28
9:26
2022-12-04
20:45
MySQL Server: DMLVerified
(5788 days)
S35.0.25-BK, 5.0.22/5.1BKAny (any)AnyCan SELECT from table being updated in a stored function, but can't in subquery
214312006-08-03
16:17
2022-12-04
20:45
MySQL Server: DMLVerified
(6816 days)
S34.1.22-BK, 5.0-BKAnyAnyIncomplete support of temporary tables
218402006-08-25
18:11
2008-10-06
10:48
MySQL Server: DMLClosed
(6057 days)
S35.0/5.1BKLinux (Linux)AnySpurious ER_WARNING_NOT_COMPLETE_ROLLBACK for transactional tables
221062006-09-08
6:46
2018-09-09
20:45
MySQL Server: DMLVerified
(6363 days)
S35.0.26-BKLinux (Linux)Anycan't output to error log file when INNODB happened ERROR1205
239382006-11-03
12:53
2008-01-30
10:25
MySQL Server: DMLClosed
(6307 days)
S24.1, 5.0-BK, 5.1-BKLinux (Linux, RHEL4 AS)AnyISNULL on DATE AND CAST AS DATE returns false for null values
249112006-12-08
13:52
2008-02-07
12:45
MySQL Server: DMLWon't fix
(6299 days)
S34.1.22AnyAnysum with cast as unsigned, wrong result
254302007-01-05
11:25
2011-02-16
23:43
MySQL Server: DMLClosed
(5532 days)
S35.1.15-BK, 5.1.11-beta, 5.1.23Linux (Linux)Anyvariable not found in SELECT @@global.ft_max_word_len;
256202007-01-15
6:54
2020-05-03
20:45
MySQL Server: DMLVerified
(6363 days)
S35.0.33Windows (Windows Server 2003 Web Edition)AnyError in ADDTIME function when update more 35 days
272992007-03-20
18:20
2020-05-03
20:45
MySQL Server: DMLVerified
(6363 days)
S35.0.40-BK, 5.0.19Linux (Linux 2.6.9-34.ELsmp)AnyMulti-table UPDATE does not work properly (IMHO)
273582007-03-21
20:18
2007-10-23
19:48
MySQL Server: DMLClosed
(6406 days)
S35.0-bkLinux (linux)AnyINSERT DELAYED does not honour SQL_MODE of the client
275252007-03-29
14:53
2011-02-16
23:43
MySQL Server: DMLClosed
(5541 days)
S35.0.33/5.1Linux (OpenSuse 10.2)Anytable not found when using multi-table-deletes with aliases over several databas
279862007-04-20
15:20
2008-04-07
8:36
MySQL Server: DMLCan't repeat
(6239 days)
S35.0.27, 5.1LinuxAnyLong Decimals from sub-queries used in updates give wrong results
287592007-05-29
22:24
2022-09-04
20:45
MySQL Server: DMLDuplicate
(6019 days)
S35.1.12-beta-community, 5.1 BK, 5.0 BKAnyAnylcase and lower
290452007-06-12
7:38
2011-02-16
23:43
MySQL Server: DMLCan't repeat
(5217 days)
S35.1AnyAnySome inconsistency in using system variables
297572007-07-12
13:56
2018-09-09
20:45
MySQL Server: DMLVerified
(4936 days)
S35.5AnyAnySTRING FUNCTIONS WITH LIMITS
301592007-07-31
21:46
2018-09-09
20:45
MySQL Server: DMLVerified
(6489 days)
S35.1.21-beta-debugLinux (SUSE 10 64-bit)AnyDifferent results with SELECT FOR UPDATE versus plain SELECT
302342007-08-03
19:39
2009-11-10
18:50
MySQL Server: DMLClosed
(6228 days)
S35.0.41/5.1/4.1AnyAnyUnexpected behavior using DELETE with AS and USING
304022007-08-14
8:35
2014-03-10
14:31
MySQL Server: DMLVerified
(4536 days)
S25.0.37 CommunityLinux (RedHat 9.0)AnySELECT count(distinct) from mytable return 0
304062007-08-14
12:15
2007-08-14
15:32
MySQL Server: DMLNot a Bug
(6476 days)
S1mySQL5.0WindowsAnyinsert into values() where
304192007-08-14
19:51
2007-08-14
20:00
MySQL Server: DMLNot a Bug
(6476 days)
S2AnyAnysecurity flaw in SELECT INTO OUTFILE
304542007-08-16
13:49
2018-09-09
20:45
MySQL Server: DMLVerified
(6474 days)
S35.0.26-log/5.1Linux (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()
306432007-08-27
9:19
2007-11-19
15:47
MySQL Server: DMLNot a Bug
(6379 days)
S25.0.27, 4.1, 5.0, 5.1, 5.2 BKAny (Linux, Windows)AnySql query returning different result sets when called more then once
307762007-09-03
23:13
2007-12-06
16:36
MySQL Server: DMLNot a Bug
(6362 days)
S24.1, 5.0, 5.1Linux (debian 4.0)AnyMOD function produces incorrect results with string arguments
307872007-09-04
10:19
2008-03-30
19:41
MySQL Server: DMLClosed
(6247 days)
S25.0.45LinuxAnyWrong aliasing with subselects
308132007-09-04
23:04
2007-10-05
5:19
MySQL Server: DMLNo Feedback
(6424 days)
S25.0.37WindowsAnyForeign Key constraint fails
308862007-09-07
8:16
2018-02-08
22:08
MySQL Server: DMLNot a Bug
(2645 days)
S35.0.45, 4.1, 5.0, 5.1, 5.2 BKAny (Linux, Windows XP SP2)AnyUnion returns wrong column type size
310002007-09-13
12:52
2011-02-16
23:43
MySQL Server: DMLClosed
(5669 days)
S25.0.45WindowsAnyLeft join using stored function fails with corrupted result
310232007-09-14
8:12
2012-05-18
20:19
MySQL Server: DMLDuplicate
(6445 days)
S15.0.45AnyAnyBug when using date function on datetime field in the where clause
310632007-09-17
15:58
2007-09-18
11:34
MySQL Server: DMLCan't repeat
(6441 days)
S35.1.21AnyAnyGROUP BY WITH ROLLUP inconsistence with derived tables
310732007-09-18
2:56
2007-09-18
4:32
MySQL Server: DMLNot a Bug
(6441 days)
S35.0.45-community-ntWindows (Windows XP)AnyUPPER() does not work on MD5() function when Inserting
311122007-09-20
14:41
2007-10-29
16:54
MySQL Server: DMLNo Feedback
(6400 days)
S5Ver 14.7 Distrib 4.1.13, for pc-linux-gnLinux (pc-linux-gn)AnyAliased version of simple query very slow
311862007-09-25
14:16
2007-10-25
16:09
MySQL Server: DMLNo Feedback
(6404 days)
S15.0.37-community-ntWindows (Server 2003)AnyUpdate on Varchar treated as Double (improper type conversions)
312362007-09-27
12:49
2008-03-15
22:37
MySQL Server: DMLClosed
(6262 days)
S35.1AnyAnyInconsistent division by zero behavior for floating point numbers
312812007-09-28
15:09
2007-10-28
15:24
MySQL Server: DMLNo Feedback
(6401 days)
S15.0.41-community-nt-logWindowsAnyGroup by and subquery issue in 5.0.41-community-nt-log
313682007-10-03
12:18
2007-10-03
16:30
MySQL Server: DMLNot a Bug
(6426 days)
S3mysql.exe Ver 14.12 Distrib 5.0.37Windows (XPSP2)Anybefore-JOIN word can be virtually any word
314012007-10-04
16:05
2007-11-04
19:06
MySQL Server: DMLNo Feedback
(6394 days)
S25.1.22Windows (w2k sp4)Anybigint unsigned non-deterministic near wrap values
314512007-10-08
14:52
2007-11-30
23:38
MySQL Server: DMLCan't repeat
(6368 days)
S35.0.26/5.0BKLinux (Gentoo)AnyERROR 1105 (HY000): Unknown error on a simple SELECT statement
314722007-10-09
8:59
2012-05-18
20:19
MySQL Server: DMLDuplicate
(6303 days)
S35.0.50AnyAnymulti_update crashes at assert about trans_safe
316342007-10-16
11:55
2018-02-08
21:54
MySQL Server: DMLWon't fix
(2645 days)
S35.1.21AnyAnyprocedure analyse won't work
317322007-10-21
1:14
2020-05-03
20:45
MySQL Server: DMLVerified
(6357 days)
S25.0.45Linux (SuSE 10.3 x86_64)Anyrow count(*) overflows after 32-bit integer precision in spite of being bigint
317342007-10-21
10:45
2007-10-21
13:37
MySQL Server: DMLNot a Bug
(6408 days)
S35.0.45 and 5.1.22LinuxAnyServer hangs during large LOAD DATA
317762007-10-23
8:19
2018-09-09
20:45
MySQL Server: DMLVerified
(6405 days)
S35.0.45, 4.1, 5.0, 5.1, 5.2 BKAny (Linux, Microsoft Windows XP SP2)AnyCAST AS CHAR with SELECT DISTINCT
317812007-10-23
10:57
2008-04-10
14:08
MySQL Server: DMLClosed
(6236 days)
S34.1,5.0WindowsAnymulti-table UPDATE with temp-pool enabled fails with errno 17
318112007-10-24
10:14
2007-10-24
18:09
MySQL Server: DMLNot a Bug
(6405 days)
S35.0.45AnyAnyouter aliases are not supported in subqueries
318352007-10-25
7:55
2007-10-25
9:42
MySQL Server: DMLDuplicate
(6404 days)
S2MySQL Server 4.0AnyAnyIncorrect handling of dates when used in an IN condition in the WHERE clause
319062007-10-29
10:22
2007-10-29
11:10
MySQL Server: DMLNot a Bug
(6400 days)
S3AnyAnyNo stmt rollback and wrong binlog if an error in {INSERT|CREATE} ... SELECT UNIO
319712007-10-30
23:08
2019-10-29
22:33
MySQL Server: DMLCan't repeat
(2017 days)
S35.0.51 and 5.0.45Any (Debian, FreeBSD)Anylast_insert_id with on duplicate key still broken
320302007-11-01
12:55
2007-12-14
19:47
MySQL Server: DMLClosed
(6354 days)
S3AnyAnyDELETE does not return an error and deletes rows if error evaluating WHERE
320452007-11-02
5:53
2007-11-02
8:11
MySQL Server: DMLDuplicate
(6396 days)
S25.0.45-Debian_1ubuntu3-logLinux (ubuntu 7.10)Anysec_to_time returns wrong values
321452007-11-06
13:49
2007-11-06
15:39
MySQL Server: DMLNot a Bug
(6392 days)
S15.0.37-community-ntWindows (XP professional)AnyError while executing Select query
323452007-11-13
20:23
2012-05-18
20:19
MySQL Server: DMLNo Feedback
(6215 days)
S36.0AnyAnyServer; mysql_update() compares too much for NULL fields
324822007-11-18
17:45
2008-01-14
19:09
MySQL Server: DMLClosed
(6323 days)
S25.1.22-rc-logLinuxAnycrash with GROUP BY alias_of_user_variable WITH ROLLUP
328002007-11-28
7:43
2007-11-28
12:20
MySQL Server: DMLNot a Bug
(6370 days)
S25.0.45 and 5.0.32AnyAnyUmlaut in WHERE filters incorrectly
329172007-12-02
22:41
2015-02-12
13:05
MySQL Server: DMLClosed
(3817 days)
S25.0.50AnyAnydetect orphan temp-pool files, and handle gracefully
330322007-12-06
10:06
2007-12-07
15:35
MySQL Server: DMLNot a Bug
(6361 days)
S35.0.45-community-ntAnyAnyIncorrect result with UNION and user-defined variables
330662007-12-07
16:33
2007-12-25
14:06
MySQL Server: DMLNot a Bug
(6343 days)
S35.1.22-rcAnyAnylast_insert_id(), wrong values, InnoDB, insert on duplicate key update
330872007-12-08
17:22
2017-12-31
0:12
MySQL Server: DMLNot a Bug
(6349 days)
S35.0.45, 5.0.52, 5.1.22AnyAnyDISTINCT with ORDER BY and LIMIT returns incorrect results
330882007-12-08
18:04
2007-12-08
18:43
MySQL Server: DMLCan't repeat
(6360 days)
S2Ver 14.12 Distrib 5.0.44, for pc-linux-gAnyAnySELECT query with a definite WHERE clause stops returning rows after NULL value
331312007-12-11
7:14
2008-01-11
7:44
MySQL Server: DMLNo Feedback
(6326 days)
S3 5.0.45-logLinux (2.6.9-5.EL)Anyproblem with update query
331382007-12-11
13:20
2018-02-08
22:20
MySQL Server: DMLWon't fix
(2645 days)
S35.1AnyAnyprocedure analyse is not aware of cluster 4 byte align types
331692007-12-12
15:40
2018-09-09
20:45
MySQL Server: DMLVerified
(6356 days)
S35.1.22WindowsAnymysqld --help : lowercase_table-name bad advice
332542007-12-14
22:56
2007-12-16
19:01
MySQL Server: DMLNot a Bug
(6352 days)
S1mysql 5.0.27FreeBSD (6.2)AnyInvalid query: Unknown column 'column_id' in 'on clause'
332592007-12-15
9:53
2007-12-16
4:16
MySQL Server: DMLNot a Bug
(6352 days)
S2MySQL 5.1WindowsAnystr_to_date conversion of date format 'dd-mmm-yy' to 'yyyy-mm-dd'
333042007-12-17
23:50
2008-03-27
19:29
MySQL Server: DMLClosed
(6250 days)
S35.0.54MacOS (10.4 PowerPC 64-bit)AnyTest 'func_group' hangs on Mac OS X 10.4 PowerPC 64-bit
333892007-12-20
4:52
2008-03-14
22:18
MySQL Server: DMLClosed
(6263 days)
S15.0.54, 5.0.52, 5.1.22Any (Windows, Linux, 32 or 64 bit)AnySelecting from a view into a table from within SP or trigger crashes server
333962007-12-20
10:07
2018-04-11
12:17
MySQL Server: DMLWon't fix
(2583 days)
S35.1Linux (Suse 10.1)Anyduplicate value in set leads to warning 1291, which not shown with ps-protocol
334952007-12-24
3:17
2007-12-24
4:29
MySQL Server: DMLDuplicate
(6344 days)
S3AnyAnyError Insert data in version 5.1.20
336292008-01-02
15:46
2011-02-16
23:43
MySQL Server: DMLClosed
(5655 days)
S35.0.52, 5.1.23, 6.0.3AnyAnylast_day function can return null, but has 'not null' flag set for result
336472008-01-03
10:16
2013-05-16
6:10
MySQL Server: DMLNot a Bug
(4374 days)
S35.1.22AnyAnyWITH ROLLUP fails when using subqueries
336992008-01-04
21:30
2008-01-28
18:09
MySQL Server: DMLClosed
(6309 days)
S35.1, 6.0AnyAnyUPDATE allows NULL as new value on NOT NULL columns (= default datatype value)
337172008-01-07
2:52
2011-02-16
23:43
MySQL Server: DMLClosed
(5437 days)
S35.0+AnyAnyINSERT...(default) fails for enum. Crashes CSV tables, loads spaces for MyISAM
337642008-01-09
12:02
2008-03-15
8:11
MySQL Server: DMLClosed
(6262 days)
S35.0+LinuxAnyWrong result with IN(), CONCAT() and implicit type conversion
338112008-01-10
23:07
2011-02-16
23:43
MySQL Server: DMLClosed
(6021 days)
S35.0/5.1/6.0AnyAnyCall to stored procedure with SELECT * / RIGHT JOIN fails after the first time
338442008-01-13
13:26
2012-05-18
20:19
MySQL Server: DMLNo Feedback
(5386 days)
S35.1.23, 5.1.48AnyAnyServer crashes when client dies during LOAD DATA INFILE
338472008-01-13
16:40
2008-01-14
5:20
MySQL Server: DMLNot a Bug
(6323 days)
S35.0.45AnyAnyThe character '-' in a table name causes problems
339692008-01-21
23:28
2011-02-16
23:43
MySQL Server: DMLClosed
(5541 days)
S35.1.22-rc-communityOther (UBUNTU (64Bit), FreeBSD (64bit), RedHat)AnyUpdating a text field via a left join
339922008-01-22
20:19
2008-01-22
21:19
MySQL Server: DMLNot a Bug
(6315 days)
S35.0.45AnyAnyDate column not named in update statement is set to current date
342142008-02-01
4:47
2008-02-01
5:54
MySQL Server: DMLNot a Bug
(6305 days)
S15.0.27-logLinuxAnyUnexpected ERROR 1292 (22007) error in strict mode for 2007-03-11
343142008-02-05
17:22
2022-09-04
20:45
MySQL Server: DMLDuplicate
(6264 days)
S3allAnyAnySystem variables in SHOW VARIABLES not selectable with SELECT
343742008-02-07
9:31
2011-02-16
23:43
MySQL Server: DMLClosed
(5655 days)
S35.0.54a, 5.0, 5.1, 6.0 BKLinuxAnymysql generates incorrect warning
343842008-02-07
16:45
2011-02-16
23:43
MySQL Server: DMLClosed
(5326 days)
S35.0.45, 5.1.22, 5.0.54AnyAnyBig quoted int in WHERE of UPDATE or DELETE causes drop in performance
345122008-02-13
5:13
2008-04-12
2:58
MySQL Server: DMLClosed
(6234 days)
S35.0.51a-community-nt, 5.0.54AnyAnyCAST( AVG( double ) AS DECIMAL ) returns wrong results
345942008-02-15
13:10
2018-02-08
22:37
MySQL Server: DMLWon't fix
(2645 days)
S35.0.56, 5.0.66aAnyAny'handler open' can refer to outdated table names until flush tables is executed
346082008-02-15
18:43
2019-10-30
21:14
MySQL Server: DMLNot a Bug
(2016 days)
S34.1, 5.0, 5,1, 6.0 bzr Any (Linux, MS Windows)Anyunfair subselect
346202008-02-16
17:16
2008-03-15
8:41
MySQL Server: DMLClosed
(6262 days)
S35.0+, 5.0.58-BKAnyAnyitem_row.cc:50: Item_row::illegal_method_call(const char*): Assertion `0' failed
347312008-02-21
15:30
2008-04-07
17:30
MySQL Server: DMLClosed
(6239 days)
S25.0.51a, 5.0.54, 5.1.23Windows (probably any)Anyhighest possible value for INT erroneously filtered by WHERE
347512008-02-21
22:19
2018-02-08
22:42
MySQL Server: DMLClosed
(2645 days)
S35.0+AnyAnyInside HAVING clause subqueries with aggregates and without GROUP BY rise error
347552008-02-22
8:06
2008-02-22
9:41
MySQL Server: DMLNot a Bug
(6284 days)
S25.0.45 SUSE MySQL RPM and 5.0.51a-communLinux (opensuse 10.3)Anyerror in select statement with joins - unknown column
347822008-02-24
9:46
2008-02-27
17:20
MySQL Server: DMLNot a Bug
(6279 days)
S25.0.32-Debian_7etch1-logLinux (Debian)AnyCONCAT() fails when longblobs length's are bigger than max_allowed_packet
348292008-02-26
12:19
2011-02-16
23:43
MySQL Server: DMLClosed
(5532 days)
S35.1.22, 5.0.56WindowsAnyNo default value for variable and setting default does not raise error
348342008-02-26
12:47
2011-02-16
23:43
MySQL Server: DMLClosed
(5532 days)
S35.1.22, 5.1.24-BK, 5.0.56AnyAny? Is accepted as a valid sql mode
348502008-02-26
16:58
2008-05-31
14:05
MySQL Server: DMLCan't repeat
(6185 days)
S15.0.32-Debian_7etch3-logLinux (Debian 4.0 Etch.)AnyUPDATE query with SET date_updated=NOW() intermittently setting other DATETIMEs
348742008-02-27
9:47
2018-02-08
22:50
MySQL Server: DMLClosed
(2645 days)
S35.0+AnyAnyWrong result with IN(SELECT aggregate FROM DUAL)
348782008-02-27
10:53
2011-02-16
23:43
MySQL Server: DMLClosed
(5531 days)
S35.1.22, 5.1.23AnyAnyFew variables have default value according to documentation but error occurs
348832008-02-27
11:14
2011-02-16
23:43
MySQL Server: DMLClosed
(5531 days)
S35.1.23AnyAnyft_boolean_syntax cant be assigned from user variable to global var.
348982008-02-27
17:44
2011-02-16
23:43
MySQL Server: DMLClosed
(5655 days)
S35.0, 5.1, 4.1AnyAnymysql_info() reports 0 warnings while mysql_warning_count() reports 1
349452008-02-28
22:53
2008-03-15
8:59
MySQL Server: DMLClosed
(6262 days)
S25.0, 5.1, 6.0 BKAny (All)Anyref_or_null queries that are null_rejecting and have a null value crash mysql
349492008-02-29
3:23
2008-05-30
19:14
MySQL Server: DMLClosed
(6186 days)
S24.1.22AnyAnyPassing invalid parameter to CHAR() in an ORDER BY causes MySQL to hang
349662008-02-29
22:45
2008-03-05
20:39
MySQL Server: DMLNot a Bug
(6272 days)
S25.0.45Linux (debian)AnyProblems with LOAD_FILE
350022008-03-03
14:17
2018-09-09
20:45
MySQL Server: DMLVerified
(6273 days)
S25.1.23-rc/5.1BK/5.0/6.0Linux (2.6.22.9-61.fc6)AnyWrong results returned when using derived table and group by
352422008-03-12
10:29
2020-01-22
4:38
MySQL Server: DMLClosed
(1932 days)
S25.0.45 and 5.0.51a, 5.0, 5.1, 6.0 BKAny (and windows)AnyERROR 1054 (42S22): Unknown column 't2.i2' in 'on clause'
353552008-03-17
23:14
2012-10-16
4:40
MySQL Server: DMLClosed
(4586 days)
S25.0AnyAnySupport explain for update and delete statements
353622008-03-18
6:08
2008-03-20
21:10
MySQL Server: DMLNot a Bug
(6257 days)
S25.1.22, 5.0, 5.1, 6.0 BKAny (MS Windows, Linux)AnyAuto_Increment_Increment looses its value on switching connections & values
353742008-03-18
7:19
2008-03-24
16:20
MySQL Server: DMLNot a Bug
(6253 days)
S35.1.22, 5.1.23WindowsAnydiv_precision_increment is not working with table’s column
353762008-03-18
7:31
2008-05-08
16:34
MySQL Server: DMLNot a Bug
(6208 days)
S35.1.22AnyAnyValue of insert_id automatically resets to 0 after inserting 1st row
353862008-03-18
9:39
2014-09-17
4:39
MySQL Server: DMLWon't fix
(3885 days)
S35.1.22AnyAnyInsert delayed statements insert 1 + limit records instead of just limit records
353922008-03-18
12:03
2008-04-07
17:26
MySQL Server: DMLClosed
(6239 days)
S25.1.22/5.1/6.0WindowsAnyDelete all statement does not execute properly after few delete statements
354612008-03-20
15:19
2015-05-26
12:49
MySQL Server: DMLNot a Bug
(6257 days)
S3mysql-6.0-backupLinuxAnyNot able to insert '\' character.
354782008-03-21
11:21
2011-02-16
23:43
MySQL Server: DMLClosed
(6127 days)
S35.0-bkAnyAnysort_union() returns bad data when sort_buffer_size is hit
355142008-03-24
16:26
2011-02-16
23:43
MySQL Server: DMLClosed
(5998 days)
S26.0-falcon-teamAnyAnyItem_func_uuid::val_str(String*): Assertion `tv > uuid_time' failed.
356082008-03-27
14:12
2008-03-28
13:37
MySQL Server: DMLNot a Bug
(6249 days)
S15.1.23a-maria-alpha-logAnyAnychanged NOT NULL handling breaks replication in 5.1
357032008-03-31
11:03
2008-05-02
20:51
MySQL Server: DMLNo Feedback
(6214 days)
S3AnyAnyMax_delayed_thread does not make delayed insert threads as normal insert
357062008-03-31
12:12
2008-04-30
12:24
MySQL Server: DMLNo Feedback
(6216 days)
S35.1.22LinuxAnyDefault value of flush_time is Null in SUSE whereas 1 in all other OS's
357662008-04-02
10:05
2018-09-09
20:45
MySQL Server: DMLVerified
(6244 days)
S35.1.22, 4.1, 5.0, 5.1, 6.0 BKLinux (Mandriva 2008 )AnyLOAD OPTIONALLY ENCLOSED BY prematurly terminates
358152008-04-03
20:14
2008-04-03
23:41
MySQL Server: DMLDuplicate
(6243 days)
S25.0.51aWindows ( 5.0.51a-community-nt)AnyError 1292 when inserting particular date into timestamp field
359932008-04-11
12:26
2008-05-13
20:04
MySQL Server: DMLClosed
(6203 days)
S14.1.22, 5.1.24, 5.0.58AnyAnysevere memory corruption and crash with multibyte conversion
360232008-04-13
10:27
2008-05-13
20:15
MySQL Server: DMLClosed
(6203 days)
S15.0.58, 5.1.24AnyAnycrash/huge memory alloc with max and case when if statement
360612008-04-14
14:52
2008-04-15
3:40
MySQL Server: DMLNot a Bug
(6231 days)
S35.0.22Linux (CentOS 5)AnyDATETIME math inaccuracies
360842008-04-15
8:34
2012-05-18
20:19
MySQL Server: DMLDuplicate
(6231 days)
S35.0.58AnyAnyname_const with negative, subquery, group by causes crash
360912008-04-15
12:41
2008-04-18
8:59
MySQL Server: DMLNot a Bug
(6228 days)
S35.1+WindowsAnyFix for bug #31781 is broken in 5.1/6.0
361112008-04-16
5:48
2008-05-01
3:46
MySQL Server: DMLNot a Bug
(6215 days)
S25.0.41Windows (XP)AnySQL Query returns wrong reults
361282008-04-16
10:33
2011-02-16
23:43
MySQL Server: DMLClosed
(5282 days)
S26.0.4-nt, 6.0.5-bkAnyAnynot in subquery causes crash in cleanup..
361352008-04-16
11:56
2008-09-16
4:23
MySQL Server: DMLClosed
(6077 days)
S35.1-bk6.0.5-bkAnyAny void Diagnostics_area::set_eof_status(THD*): Assertion `! is_set()' failed.
361382008-04-16
13:21
2008-04-25
12:06
MySQL Server: DMLNot a Bug
(6221 days)
S15.0.45AnyAnySELECT with LEFT JOIN and aggregate function returns incorrect results
361422008-04-16
15:31
2008-05-30
7:51
MySQL Server: DMLCan't repeat
(6186 days)
S26.0.5-debug-bkLinuxAnydouble free/memory corruption errors on cleanup of join
365082008-05-05
15:15
2008-05-06
16:45
MySQL Server: DMLNot a Bug
(6210 days)
S25.1.24AnyAnyinserting null value to not null column with default value explicitly defined
366762008-05-12
22:05
2016-02-25
12:24
MySQL Server: DMLClosed
(6194 days)
S25.0.58AnyAnyUPDATE on TEXT column using LEFT JOIN doesn't update all rows
366932008-05-13
15:43
2011-02-16
23:43
MySQL Server: DMLCan't repeat
(5480 days)
S15.0.66a,5.1.24AnyAnystored procedure, derived table crash
366982008-05-13
19:57
2018-09-09
20:45
MySQL Server: DMLVerified
(6196 days)
S35.0.60/5.1BKAnyAnyROW_COUNT() is reset inconsistently
367042008-05-14
0:24
2011-02-16
23:43
MySQL Server: DMLCan't repeat
(5426 days)
S15.1.24, 5.1.26, 5.1.30AnyAnymulti-table update with derived tables cause crash
367382008-05-15
16:37
2012-05-18
20:19
MySQL Server: DMLDuplicate
(6201 days)
S14.1, 5.0, 5.1, 6.0 BKAny (Linux)Anyhaving + fulltext crashes MySQL server
367602008-05-16
15:31
2008-05-17
19:07
MySQL Server: DMLNot a Bug
(6199 days)
S25.0.45 MySQL Community ServerAnyAnyfrom_unixtime rounds fractional seconds
367912008-05-19
1:10
2008-06-19
16:45
MySQL Server: DMLNo Feedback
(6166 days)
S25.1.23WindowsAnyError trying to get Column Names
368982008-05-22
22:24
2008-05-25
10:04
MySQL Server: DMLNot a Bug
(6191 days)
S35.0.51AnyAnyINSERT ... ON DUPLICATE KEY UPDATE seem to compute wrong, if a new row is insert
369392008-05-24
20:40
2008-05-25
0:00
MySQL Server: DMLClosed
(6191 days)
S3 5.0.51bWindowsAnyMultiple-table DELETE syntax worked in 5.0.45 but doesn't work in 5.0.51b
369582008-05-26
12:19
2008-07-02
20:04
MySQL Server: DMLNo Feedback
(6153 days)
S25.0.22WindowsAnyleft join on small size index
369832008-05-26
15:34
2008-09-22
16:38
MySQL Server: DMLCan't repeat
(6071 days)
S15.1.26bkAnyAnystack corruption and crash with des_encrypt crashes on invalid inputs
370132008-05-27
18:06
2018-02-08
23:00
MySQL Server: DMLClosed
(2645 days)
S35.0.22,5.0.54, 5.0, 5.1, 6.0 BKLinux (CentOS5, Gentoo2008)AnyCONDITION NOT MET IN VALID SQL STATEMENT
370552008-05-29
6:09
2008-06-30
15:29
MySQL Server: DMLNo Feedback
(6155 days)
S25.0.18LinuxAnysub query with in condition takes long time and it hangs
371062008-05-30
16:43
2008-05-31
17:05
MySQL Server: DMLNot a Bug
(6185 days)
S35.0.22Linux (Debian_0ubuntu6.06.9)AnySELECT (datetimeB - datetimeA)
371832008-06-04
8:15
2011-02-16
23:43
MySQL Server: DMLClosed
(5535 days)
S34.1.22, 5.0.64, 5.1.26, 6.0.6AnyAnyinsert ignore into .. select ... hangs after deadlock was encountered
372402008-06-06
9:33
2008-06-10
2:37
MySQL Server: DMLNot a Bug
(6175 days)
S55.0.38Linux (ubuntu 7.0.4)AnyIs this a bug here?
372892008-06-09
16:58
2011-02-16
23:43
MySQL Server: DMLWon't fix
(6027 days)
S35.0.22,5.1.22AnyAnyTIMESTAMP field DEFAULT value fails to apply depending on situation.
374012008-06-13
18:43
2019-10-30
22:07
MySQL Server: DMLCan't repeat
(2016 days)
S35.0.54,5.1.24, 5.0, 5.1, 6.0 bzrAnyAnyOne Item_sum constructor does not initialize quick_group. All others do.
374842008-06-18
16:43
2008-06-18
20:49
MySQL Server: DMLNot a Bug
(6167 days)
S25.0AnyAnyC-style comments not ignored within character literals
375482008-06-20
15:40
2008-09-16
4:24
MySQL Server: DMLClosed
(6077 days)
S15.1.23 and up, 5.1, 6.0 bzrAnyAnyresult value erronously reported being NULL in certain subqueries
377302008-06-29
22:13
2008-07-14
21:05
MySQL Server: DMLWon't fix
(6141 days)
S35.0.62AnyAnyselect from where in returns incorrect results
377352008-06-30
8:40
2008-06-30
15:24
MySQL Server: DMLNot a Bug
(6155 days)
S25.1, 5.0, 4.1, 6.0 BZRAnyAnyWHERE clause fails immediately following INSERT on AUTO INCREMENT column
380722008-07-12
17:28
2008-11-10
18:20
MySQL Server: DMLClosed
(6022 days)
S36.0, 5.1, 5.0 bzrAnyAnyWrong result: HAVING not observed in a query with aggregate
380912008-07-14
5:14
2008-08-07
4:19
MySQL Server: DMLNot a Bug
(6117 days)
S35.1.23Windows (Vista Enterprise)AnyLOAD DATA LOCAL INFILE using source column references loads sequential columns
382152008-07-17
20:55
2011-02-16
23:43
MySQL Server: DMLCan't repeat
(5739 days)
S35.0.67FreeBSDAnyQuery fails to return correct info from table
384892008-07-31
12:27
2018-02-08
23:10
MySQL Server: DMLClosed
(2645 days)
S35.0, 5.1AnyAnyEXPLAIN EXTENDED SELECT generates invalid query
386372008-08-07
18:35
2011-02-16
23:43
MySQL Server: DMLClosed
(5929 days)
S25.0.51, 5.1.28, 5.0.66aAnyAnyCOUNT DISTINCT prevents NULL testing in HAVING clause
386932008-08-09
17:31
2008-11-10
18:22
MySQL Server: DMLClosed
(6022 days)
S25.0.66a, 5.1.26, 5.1.28, 6.0.7AnyAnyleaked memory with blobs!
387492008-08-12
11:39
2008-08-13
18:29
MySQL Server: DMLNot a Bug
(6111 days)
S15.0.51a-6Linux (debian lenny)AnyDuplicate error on INSERT - primary key auto increment column
387672008-08-13
11:50
2008-09-13
15:16
MySQL Server: DMLNo Feedback
(6080 days)
S15.0.67MacOS (10.5.1 leopard)Anycombination of 'ORDER BY' and 'LIMIT' yields incorrect output
388092008-08-14
19:36
2008-08-16
5:39
MySQL Server: DMLNot a Bug
(6108 days)
S3MySQL 5.1.26-rc-communityAnyAnyA multitable update query is run more than once for each matching row
389282008-08-20
21:58
2008-08-20
22:52
MySQL Server: DMLNot a Bug
(6104 days)
S25.0.67-community-ntWindows (XP SP2)Anyselect ... count(*) not enforcing group by clause when obtaining other fields
389992008-08-25
9:17
2011-02-16
23:43
MySQL Server: DMLClosed
(5319 days)
S35.0.44, 5.0.66a, 5.0.70, 5.0.74,5.0.76LinuxAnyvalgrind warnings for update statement in function compare_record()
390022008-08-25
11:32
2008-10-17
18:14
MySQL Server: DMLClosed
(6046 days)
S15.0.42, 5.0.66a, 5.0.70, 5.1.28, 6.0.5AnyAnycrash with insert .. select * from ... on duplicate key update col=default
390462008-08-26
15:30
2008-08-26
19:19
MySQL Server: DMLClosed
(6098 days)
S35.1.26WindowsAny"not in" returns empty set when subquery result is large
390792008-08-27
19:13
2011-02-16
23:43
MySQL Server: DMLVerified
(6097 days)
S35.x, 6.xAny (Mac OSX, Linux)AnyTruncating incorrect DECIMAL value at the wrong place
391692008-09-01
22:17
2008-10-10
8:06
MySQL Server: DMLNo Feedback
(6053 days)
S16.0.4alpha, 6.0.6alphaWindows (Windows XP Home)AnyUnexpected behaviour when using GROUP BY and/or WHERE clauses
392012008-09-02
21:22
2018-09-09
20:45
MySQL Server: DMLVerified
(6090 days)
S35.1.26-rc, 4.1, 5.0, 5.1, 6.0 bzrLinux (2.6.24.5-smp)AnyINTO OUTFILE Statement
392472008-09-04
15:05
2015-06-02
13:36
MySQL Server: DMLVerified
(6078 days)
S35.0.67, 5.0, 5.1, 6.0 bzrAny (MS Windows 5.0.2195, Linux)AnyLOAD DATA INFILE skips too many rows
392742008-09-05
13:15
2020-03-10
11:05
MySQL Server: DMLWon't fix
(2013 days)
S25.0.66a, 5.1.26, 5.1.27-ndb-6.3.17AnyAnySELECT on PK with ROUND(RAND()) give wrong errors
394232008-09-12
16:35
2012-05-18
20:19
MySQL Server: DMLDuplicate
(6033 days)
S35.0.67-community, 5.0, 5.1, 6.0 bzrLinux (x86_64 GNU/Linux CentOS)Anycomparison of NULL datetime column side-effected in trigger body are incorrect
395052008-09-17
21:55
2017-03-17
17:18
MySQL Server: DMLNo Feedback
(6046 days)
S25.1.28WindowsAnyERROR 1292 (22007): Incorrect datetime value
395432008-09-19
16:56
2018-02-10
16:42
MySQL Server: DMLClosed
(2643 days)
S35.0.67/5.1/6.0Linux (debian 4.0)AnyGroup by with case and lpad inside concat truncates values
396152008-09-23
18:54
2008-10-13
18:51
MySQL Server: DMLNot a Bug
(6050 days)
S25.0.67, 4.1, 5.0, 5.1, 6.0 bzrAny (MS Windows, Linux)AnyWITH Rollup fails
396562008-09-26
2:15
2011-02-16
23:43
MySQL Server: DMLClosed
(5994 days)
S15.0.67, 5.1.28Any (Windows XP, Fedora 9)AnyBehaviour different for agg functions with & without where - ONLY_FULL_GROUP_BY
398282008-10-03
4:54
2011-02-16
23:43
MySQL Server: DMLClosed
(5231 days)
S25.1.28, 5.1.48, 6.0.6AnyAnyautoinc wraps around when offset and increment > 1
398322008-10-03
8:05
2008-10-03
8:43
MySQL Server: DMLNot a Bug
(6060 days)
S35.0.24aLinux (Redhat ES$)AnyInconsistents when doing SELECTS using session variables in IN() clause
398602008-10-04
14:09
2008-10-05
17:53
MySQL Server: DMLNot a Bug
(6058 days)
S3mysql5.1.25WindowsAnyHow to update
398832008-10-06
14:22
2008-10-07
12:07
MySQL Server: DMLNot a Bug
(6056 days)
S25.0.51a / 5.0.67Linux (opensuse 11.0)AnyPerformance problem with stored function in where clause
399202008-10-08
7:07
2011-02-16
23:43
MySQL Server: DMLClosed
(5991 days)
S35.0.xLinuxAnyMySQL cannot deal with Leap Second expression in string literal.
399702008-10-10
9:37
2008-10-16
11:00
MySQL Server: DMLNot a Bug
(6047 days)
S25.0.51a, 4.1, 5.0, 5.1, 6.0 bzrAny (Linux, MS WindowsW2K3 community edition)Anycount distinct reports zero
400522008-10-15
14:46
2018-09-09
20:45
MySQL Server: DMLVerified
(6048 days)
S3AnyAnySQL_NO_STRICT: per-query way to disable strict mode
400672008-10-15
20:02
2008-10-16
6:33
MySQL Server: DMLDuplicate
(6047 days)
S25.0.51aAnyAnyQuery on decimal column returns no value
401252008-10-18
11:51
2008-10-20
10:38
MySQL Server: DMLNot a Bug
(6043 days)
S15.0.51, 4.1, 5.0, 5.1, 6.0 bzrAnyAnySerious error while updating a record from a table! You will over write all!
401272008-10-18
15:27
2011-02-16
23:43
MySQL Server: DMLClosed
(5838 days)
S25.0.67, 5.0, 5.1, 6.0 bzrLinuxAnyMultiple table DELETE IGNORE hangs on foreign key constraint violation on 5.0
402172008-10-21
18:03
2018-02-10
16:58
MySQL Server: DMLClosed
(2643 days)
S35.0, 5.1.28, 5.1, 6.0 bzrAnyAnyUNION [ALL] query results present faulty internal datetime
402472008-10-22
13:02
2008-10-26
10:33
MySQL Server: DMLCan't repeat
(6037 days)
S35.0.51aLinux (RHEL4 x86_64)AnyNULL-Safe Comparison of DATE
402992008-10-24
11:16
2008-10-24
13:54
MySQL Server: DMLCan't repeat
(6039 days)
S3MySQL Browser 1.2.11Windows (XP home)Anynot updated select after update in MySQL browser
403342008-10-26
14:09
2008-10-29
6:39
MySQL Server: DMLNot a Bug
(6034 days)
S55.0.67 community ntWindows (XP SP 2)AnyLOAD DATA INFILE - Skipping rows in large data files
403742008-10-28
17:32
2008-11-29
15:56
MySQL Server: DMLClosed
(6003 days)
S35.0.51aLinux (Debian Lenny amd64)AnyLOAD DATA with CONVERT_TZ causes memory leak
403842008-10-29
7:42
2019-11-04
15:09
MySQL Server: DMLClosed
(2011 days)
S35.1, main-6.0, revision 2866 and greaterAnyAnyGap in auto_increment sequence when inserts fire a trigger
405602008-11-06
18:47
2008-11-16
21:57
MySQL Server: DMLClosed
(6016 days)
S2Ver 14.12 Distrib 5.0.18LinuxAnyJoin condition with OR fails incorrectly in three-table join
406292008-11-11
7:32
2018-02-10
17:03
MySQL Server: DMLCan't repeat
(2643 days)
S2 5.0.45LinuxAnyWrong result reutn in select statement math function
407452008-11-14
14:41
2011-02-16
23:43
MySQL Server: DMLClosed
(5993 days)
S35.1/6.0.8-debugLinuxAnyError during WHERE clause calculation in UPDATE leads to an assertion failure
407612008-11-15
19:17
2011-02-16
23:43
MySQL Server: DMLClosed
(5943 days)
S25.1.29/5.0/5.1/6.0Windows (WinXP (Intel-32)/Linux)AnyLEFT JOIN on inline view crashes server
408792008-11-20
11:08
2011-02-16
23:43
MySQL Server: DMLDuplicate
(5972 days)
S15.0.68AnyAnyinsert..select crashed in field_conv
410072008-11-25
11:21
2008-11-26
10:13
MySQL Server: DMLNot a Bug
(6006 days)
S25.0.67Any (Tested on OSX and Linux Debian)AnyUpdate Problem when ORing w/ Long.MIN_VALUE
410512008-11-26
12:47
2008-11-26
12:51
MySQL Server: DMLNot a Bug
(6006 days)
S25.0WindowsAnyRetrieving free time slots from a table
411152008-11-28
21:25
2008-12-01
10:29
MySQL Server: DMLNot a Bug
(6001 days)
S35.0.45-community-nt-logWindows (xp)AnyBad error report on a bad sql syntax
411562008-12-01
18:44
2011-02-16
23:43
MySQL Server: DMLClosed
(5755 days)
S35.0.72, 5.1.30, 6.0.7AnyAnyList of derived tables acts like a chain of mutually-nested subqueries
413452008-12-09
23:55
2009-04-04
19:12
MySQL Server: DMLNot a Bug
(5877 days)
S35.0.51a, 5.0.72, 5.1.30Linux (Fedora core6)AnyOrder by clause is dropping rows
413712008-12-10
18:36
2011-02-16
23:43
MySQL Server: DMLClosed
(5540 days)
S24.1.22, 5.0.51, 5.0.72, 5.1.30, 6.0.8LinuxAnySelect returns 1 row with condition "col is not null and col is null"
414772008-12-15
15:33
2018-09-09
20:45
MySQL Server: DMLVerified
(5987 days)
S34.1, 5.0, 5,1, 6.0 bzrAnyAnyInnoDB foreign keys: wrong result if ON DELETE CASCADE, and correlated subquery
414792008-12-15
16:31
2011-02-16
23:43
MySQL Server: DMLDuplicate
(5987 days)
S35.1.29-rcAnyAnyVariable in LIMIT clause
414872008-12-16
5:27
2011-02-16
23:43
MySQL Server: DMLVerified
(5986 days)
S36.0.9, 5.0, 5.1, 6.0 bzrAnyAnyselect into outfile not enclosing integer columns where this would disambiguate
414892008-12-16
6:32
2012-05-18
20:19
MySQL Server: DMLVerifiedS36.0.9AnyAnyLOAD DATA INFILE doesn't work with multibyte ENCLOSED BY (although SELECT INTO O
416662008-12-22
1:01
2011-02-16
23:43
MySQL Server: DMLDuplicate
(5980 days)
S1Ver 14.12 Distrib 5.0.67, for apple-darwMacOSAnyrand() used in scalar functions returns multiple rows
418142009-01-01
1:18
2011-02-16
23:43
MySQL Server: DMLClosed
(5970 days)
S15.1.30AnyAnySELECT DISTINCT returns wrong results with fixed width division
418682009-01-05
14:09
2011-02-16
23:43
MySQL Server: DMLClosed
(5903 days)
S15.1.30, 6.0.10, 6.0.8, 5.0.76, 5.0.74,, 5.0.40AnyAnycrash or memory overrun with concat + upper, date_format functions
418782009-01-05
18:03
2011-02-16
23:43
MySQL Server: DMLClosed
(5961 days)
S35.1.24Linux (RHEL)AnyDeleting a row, trigger (before delete) executed, read_error in binlog
419472009-01-08
8:00
2011-01-03
10:46
MySQL Server: DMLNot a Bug
(5238 days)
S15LinuxAnyselect * from [table] where table.id='1'
420092009-01-10
1:44
2011-02-16
23:43
MySQL Server: DMLClosed
(5795 days)
S25.1.30-log, 4.1, 5.0, 5.1, 6.0 bzrLinux (Ubuntu 8.10 with 2.6.27-9-generic kernel)AnySELECT into variable gives different results to direct SELECT
420592009-01-12
19:06
2011-02-16
23:43
MySQL Server: DMLNo Feedback
(5928 days)
S35.1.24-rc-community-logAnyAnyEnclosure characters cause data to large for field error
420642009-01-12
21:08
2011-02-16
23:43
MySQL Server: DMLClosed
(5319 days)
S15.0.76, 5.1.30, 5.1.31, 5.1.46, 6.1.10AnyAnylow memory crash when importing hex strings, in Item_hex_string::Item_hex_string
421022009-01-14
9:34
2012-05-18
20:19
MySQL Server: DMLDuplicate
(5957 days)
S14.1, 5.0, 5.1, 6.0 bzrAnyAnyINSERT fail 'Duplicated entry' after UPDATE set auto_inc field with InnoDB
421062009-01-14
11:38
2013-08-21
7:25
MySQL Server: DMLCan't repeat
(4277 days)
S35.0.68IBM AIX (AIX sup-aix53 3 5 0003F7BAD300)AnyINSERT INTO ... SELECT gives error "Incorrect key file"
422502009-01-21
18:38
2018-02-10
17:11
MySQL Server: DMLCan't repeat
(2643 days)
S3AnyAnyJust a little mistake
422592009-01-22
6:36
2012-07-31
12:15
MySQL Server: DMLClosed
(4663 days)
S25.5.25Linux (Ubuntu 12.04 x86_64)AnyUtilizing a SELECT within a WHERE IN performs poorly (slow)
423742009-01-27
13:53
2009-01-27
17:18
MySQL Server: DMLNot a Bug
(5944 days)
S35.1.30AnyAnyusing a value from DUAL in a subquery returns Unknown column
424042009-01-28
9:08
2012-03-27
17:31
MySQL Server: DMLClosed
(4789 days)
S35.1.25, 4.1, 5.0, 5.1, 6.0 bzrLinuxAnysubstring_index results inconsistent
424922009-01-30
20:21
2018-02-10
17:16
MySQL Server: DMLCan't repeat
(2643 days)
S35.0.45Linux (Centos 5.2)AnyTruncate causing inconsistent behavior
425832009-02-04
8:32
2009-02-04
8:50
MySQL Server: DMLNot a Bug
(5936 days)
S25.0Windows (XP Version 2 Service Pack 3)AnyFrom with SELECT statement when non integer type is used
426662009-02-06
21:10
2019-11-04
14:46
MySQL Server: DMLClosed
(2011 days)
S3Ver 14.12 Distrib 5.0.67, 4.1, 5.0, 5.1 6.0 bzrLinux (amd64 on Ubuntu)Anycoalesce changes value of float fields
426802009-02-09
4:20
2018-09-09
20:45
MySQL Server: DMLDuplicate
(4936 days)
S35.0.77, 5.1.30, 5.1.31, 5.0, 5.1, 6.0 bzrAnyAnyIncorrect NULL output & max_allowed_packet warning for nested string functions
427782009-02-12
5:42
2011-02-16
23:43
MySQL Server: DMLClosed
(5795 days)
S2>=5.1.31-debug, 5.1, 6.0 bzrAnyAnydelete order by null global variable causes assertion .\filesort.cc, line 797
428662009-02-15
16:49
2009-02-15
19:46
MySQL Server: DMLNot a Bug
(5925 days)
S25.0.45Linux (Fedora Core 7)AnyCURDATE cannot report proper date if a subtraction breaches beginning of year.
429342009-02-17
15:05
2009-02-17
22:19
MySQL Server: DMLNot a Bug
(5923 days)
S35.0.41Windows (2003)AnyFunction current_date returns an invalid date.
429762009-02-18
16:15
2011-02-16
23:43
MySQL Server: DMLDuplicate
(5922 days)
S35AnyAnyLOAD DATA INFILE command does not accept file names as variables
431652009-02-25
4:36
2009-02-25
6:04
MySQL Server: DMLNot a Bug
(5915 days)
S35.0AnyAnyMutliple row updates
432082009-02-25
21:37
2018-02-10
17:19
MySQL Server: DMLCan't repeat
(2643 days)
S55.0.67Linux (redhat)Anysome rows will retrieve just fine and some won't
433852009-03-04
17:21
2011-02-16
23:43
MySQL Server: DMLClosed
(5836 days)
S35.1.32AnyAnyCannot ALTER DATABASE ... UPGRADE DATA DIRECTORY NAME when Views exist
434322009-03-05
20:24
2011-02-16
23:43
MySQL Server: DMLClosed
(5836 days)
S25.0.51, 5.1.31AnyAnyUnion on floats does unnecessary rounding
436222009-03-13
7:52
2014-04-12
18:49
MySQL Server: DMLClosed
(4043 days)
S14.1.22, 5.0, 5.1Any (Linux 64-bit, 32-bit Mac)Anytext datatype column does not match the long value
436582009-03-15
16:07
2009-03-15
18:42
MySQL Server: DMLNot a Bug
(5897 days)
S15.1AnyAnyThe code below returns an error, while other databases allow it
437742009-03-20
23:26
2013-09-10
13:26
MySQL Server: DMLClosed
(4257 days)
S15.1.30, 4.1, 5.0, 5.1AnyAnyCAST(CAST(value) as TIME as DATETIME ) returns the wrong value.
437812009-03-21
17:13
2013-12-20
7:04
MySQL Server: DMLWon't fix
(4156 days)
S36.1-fkAnyAnyForeign keys: ./mysqld crashes if sees a table created in --foreign-key-all-engi
437962009-03-23
7:44
2011-02-16
23:43
MySQL Server: DMLClosed
(5854 days)
S35.0Windows (Intel(R) Pentium(R) 4 CPU 2.40 GHz 2.41GHz )AnyUpdate query doesnt get executed to set the date field to null value
438952009-03-26
18:45
2014-07-14
15:31
MySQL Server: DMLClosed
(3950 days)
S35.1 bzrAnyAnyMulti-DELETE IGNORE does not report warnings
439122009-03-27
13:56
2012-10-16
5:00
MySQL Server: DMLWon't fix
(4586 days)
S35.0.91AnyAny'Column * cannot be null' when derived table has count() with no results
440602009-04-03
3:07
2018-09-09
20:45
MySQL Server: DMLVerified
(5875 days)
S34.1, 5.0, 5.1, 6.0 bzrAnyAnyFirst option of PROCEDURE ANALYSE() does not work, second needs some work
440902009-04-04
18:44
2012-05-24
13:44
MySQL Server: DMLCan't repeat
(4731 days)
S35.0, 5.1, 6.0 bzrAnyAnyONLY_FULL_GROUP_BY sql_mode allows mixing of group columns with wild cards
442292009-04-13
2:02
2009-04-13
21:09
MySQL Server: DMLNot a Bug
(5868 days)
S35.0.67, 5.1-bzrLinuxAnyCOUNT() tries to coerce its expression into DOUBLE
443062009-04-16
6:58
2011-02-16
23:43
MySQL Server: DMLClosed
(5794 days)
S15.1.33, 5.1, 6.0 bzrAnyAnyAssertion fail on duplicate key error in 'INSERT ... SELECT' statements
443392009-04-17
7:47
2018-02-10
17:25
MySQL Server: DMLClosed
(2643 days)
S35.1.33, 5.0.80-bzr, 5.0.51AnyAnyWrong result with WHERE 1 IN (SELECT 1 FROM DUAL WHERE FALSE)
443992009-04-22
3:40
2011-02-16
23:43
MySQL Server: DMLClosed
(5794 days)
S25.1.34-community, 5.1.35-bzrWindows (Windows XP SP3)Anycrash with statement using TEXT columns, aggregates, GROUP BY, and HAVING
444782009-04-25
20:21
2009-04-25
21:59
MySQL Server: DMLNot a Bug
(5856 days)
S35.0.75Linux (Ubuntu 9.04)Anybigint mod bigint munges least significant byte
444942009-04-27
13:42
2009-05-05
20:37
MySQL Server: DMLNot a Bug
(5846 days)
S35.1.28, 4.1, 5.0, 5.1, 6.0 bzrAny (MS Windows, Linux)AnyMultiples tables UPDATE updates each eligible row at most once
445622009-04-29
21:41
2009-04-30
9:44
MySQL Server: DMLNot a Bug
(5851 days)
S25.1.30Windows (Vista)AnyMultiple join, duplicate result
446142009-05-01
18:48
2009-05-01
19:00
MySQL Server: DMLNot a Bug
(5850 days)
S15.0.45,5.1.32AnyAnyBIT_COUNT returns '1' for all powers-of-two values
446732009-05-05
15:52
2011-02-16
23:43
MySQL Server: DMLNo Feedback
(5815 days)
S25.1.32-communityWindows (Vista Business)AnyClause 'escaped by' on select into outfile
447062009-05-06
22:38
2009-05-06
22:43
MySQL Server: DMLNot a Bug
(5845 days)
S35.0.45AnyAnyTemporary Table error being reported incorrectly
447162009-05-07
12:29
2011-02-16
23:43
MySQL Server: DMLCan't repeat
(5844 days)
S35.0.67-community-nt-logWindows (XP)Anyselect (1 in (select key0 from one_bigint)) returns 0 where key0=1 exists
447432009-05-08
8:55
2011-02-16
23:43
MySQL Server: DMLClosed
(5794 days)
S15.1.34-community, 5.1.35-bzr, 4.1, 5.0, 6.0Any (Vista Business SP1, Linux)AnyJoin in combination with concat does not always work
447682009-05-10
20:45
2011-02-16
23:43
MySQL Server: DMLClosed
(5794 days)
S15.1.30, 5.1.34, 5.1.35Linux (32-bit fc8)AnySIGFPE crash when selecting rand from a view containing null
447742009-05-11
6:31
2011-02-16
23:43
MySQL Server: DMLClosed
(5794 days)
S35.0.82, 5.1.30, 5.1.34, 5.1.35Linux (32-bit fc8)Anyload_file function produces valgrind warnings
447922009-05-11
14:03
2011-02-16
23:43
MySQL Server: DMLClosed
(5794 days)
S35.0.82, 5.1.30, 5.1.34, .5.1.35, 6.0.10Linux (32-bit fc8)Anyvalgrind warning when casting from time to time
447962009-05-11
17:28
2011-02-16
23:43
MySQL Server: DMLClosed
(5794 days)
S35.0.82, 5.1.30, 5.1.34, 5.1.35Linux (32-bit fc8)Anyvalgrind: too many my_longlong10_to_str_8bit warnings after uncompressed_length
449042009-05-15
14:19
2018-02-10
17:27
MySQL Server: DMLCan't repeat
(2643 days)
S35.0, 5.1Windows (XP SP3)AnyLIMIT IN INSERT ... DUPLICATE KEY UPDATE DIFFER IN THE SMPLE LIMIT
449872009-05-20
14:29
2010-05-02
19:09
MySQL Server: DMLNot a Bug
(5484 days)
S35.0.78 , 5.1.31AnyAnyDELETE IGNORE and FK constraint : inconsistency in 5.0 , 5.1 and docs
450812009-05-25
22:10
2014-11-28
6:21
MySQL Server: DMLNot a Bug
(5825 days)
S35.1.34-communityAnyAnyInsertion anomaly for ON DUPLICATE KEY UPDATE
451522009-05-28
11:34
2011-02-16
23:44
MySQL Server: DMLClosed
(5792 days)
S15.0.54, 5.0.83, 5.1.35, 6.0.12AnyAnycrash with round() function on longtext column in a derived table
451682009-05-28
19:47
2011-02-16
23:44
MySQL Server: DMLClosed
(5773 days)
S15.1.36-debugLinux (32-bit fc8)Anyassertion with convert() and empty set value
453152009-06-03
22:55
2009-06-04
5:35
MySQL Server: DMLNot a Bug
(5816 days)
S35.1.34WindowsAnyrownumber not increase, use select (@s = @+1) as rownumber, others from tbl1 ,
453862009-06-09
3:52
2011-02-16
23:44
MySQL Server: DMLClosed
(5699 days)
S35.0.81, 5.0, 5.1, 6.0 bzrSolarisAnyWrong query result with MIN function in field list, WHERE and GROUP BY clause
456662009-06-23
0:03
2018-09-09
20:45
MySQL Server: DMLDuplicate
(2641 days)
S35.1.36-bzrAnyAnyDELETE FROM a.* USING a; syntax invalid in 5.1
459622009-07-06
8:39
2011-02-16
23:44
MySQL Server: DMLClosed
(5712 days)
S25.0.84, 5.1.37, 6.0.12AnyAnymemory leak after 'sort aborted' errors
462592009-07-17
10:05
2011-02-16
23:44
MySQL Server: DMLClosed
(5618 days)
S35.1.36, 5.4.4Any (openSUSE 11.1)Any5.0.83 -> 5.1.36, query doesn't work
462902009-07-18
22:24
2018-02-10
17:44
MySQL Server: DMLCan't repeat
(2643 days)
S2MySQL 5.1.34 comunitiy editionWindowsAnySELECT COUNT(*) FROM ... does'nt work with libmysql client library
464652009-07-30
3:34
2018-02-10
17:54
MySQL Server: DMLNot a Bug
(2643 days)
S35.0.32, 5.1.38Linux (debian-etch)AnyWhen IF is used with ROLLUP incorrect data is returned
465342009-08-03
20:31
2012-05-18
20:19
MySQL Server: DMLDuplicate
(5755 days)
S3AnyAnyAllow reference to same table in UPDATE subquery
469022009-08-24
21:35
2018-09-09
20:45
MySQL Server: DMLDuplicate
(5237 days)
S35.1.30-debug, 5.1.39-debug, 5.4.4-debug, 6.0.12-debugAnyAnyAssertion failed: next_insert_id >= auto_inc_interval_for_cur_row.minimum()
469782009-08-28
15:21
2009-08-28
19:42
MySQL Server: DMLNot a Bug
(5731 days)
S25.0.67MacOS (10.5.8)AnyInvalid IN statement in Delete causes all rows to be deleted.
469972009-08-29
22:19
2009-09-04
9:14
MySQL Server: DMLNot a Bug
(5724 days)
S25.1.31-community, 4.1, 5.0, 5.1, next bzrAny (MS Windows, Linux)AnyON DUPLICATE UPDATE does not react on change in one field
470492009-09-01
17:10
2009-09-01
22:03
MySQL Server: DMLNot a Bug
(5727 days)
S35.1.35, 4.1, 5.0, 5.1, 5.4 bzrAny (SunOS 5.10 Generic_138889-02 i86pc i386 i86pc)AnyBoundaries are included in result when using a float in a range (< or >)
474342009-09-18
10:18
2018-09-09
20:45
MySQL Server: DMLVerified
(5705 days)
S35.0.51a-24+lenny1-log, 5.1.38LinuxAnyAmbigous field name in group by clause does not cause an error
474532009-09-19
13:46
2011-02-16
23:44
MySQL Server: DMLClosed
(5437 days)
S25.1.30, 5.1.45, 5.5.2-m2AnyAnyInnoDB incorrectly changes TIMESTAMP columns when JOINed during an UPDATE
476502009-09-25
16:53
2011-02-16
23:44
MySQL Server: DMLClosed
(5535 days)
S35.0.X, 5.1.39, next-mrAny (Mac OS X Snow leopard, Linux)Anyusing group by with rollup without indexes returns incorrect results with where
477132009-09-29
12:51
2018-09-09
20:45
MySQL Server: DMLVerified
(5699 days)
S15.0.83, 5.1.39AnyAnySELECT WITH ROLLUP returned wrong data when using CONCAT
478882009-10-07
9:28
2011-02-16
23:44
MySQL Server: DMLCan't repeat
(5691 days)
S25.0.24Windows (Server 2003)AnyLAST_INSERT_ID() not working properly within a stored procedure
481502009-10-19
14:06
2013-02-19
13:49
MySQL Server: DMLClosed
(4460 days)
S35.1.39, 5.1.41, 5.1.47LinuxAnyQuoted aliases are not recognized in HAVING clause
482912009-10-25
16:53
2011-02-16
23:44
MySQL Server: DMLClosed
(5282 days)
S1>=5.0.32, 5.0.86, 5.1.40AnyAnycrash with row() operator,select into @var, and subquery returning multiple rows
484212009-10-29
19:38
2018-02-11
11:03
MySQL Server: DMLCan't repeat
(2642 days)
S25.1WindowsAnyFailure of executing insert into table select ... from .... group by ..
484902009-11-02
23:55
2018-02-11
11:06
MySQL Server: DMLCan't repeat
(2642 days)
S25.1.39Linux (Debian 5.0 lenny 64-bit)AnyORDER BY clause not honored when using UNION on two VIEWs. Wrong data returned.
486612009-11-10
10:37
2018-02-11
11:08
MySQL Server: DMLCan't repeat
(2642 days)
S214.12 Distrib 5.0.26Solaris (Sol 10 5/08)AnyOne table only becomes permanently locked after 2-3 successful write operations
487242009-11-12
12:33
2011-02-16
23:44
MySQL Server: DMLClosed
(5540 days)
S26.0.14-bzr, 6.0-codebase-bugfixingAnyAnyDeadlock between INSERT DELAYED and FLUSH TABLES
487252009-11-12
12:38
2011-02-16
23:44
MySQL Server: DMLClosed
(5540 days)
S36.0.14-bzr, 6.0-codebase-bugfixingAnyAnyAssert !thd->is_error() in delayed_get_table()
489852009-11-23
11:23
2011-02-16
23:44
MySQL Server: DMLClosed
(5535 days)
S15.1.40, 5.1.41AnyAnyshow create table crashes if previous access to the table was killed
494752009-12-05
16:20
2009-12-06
17:53
MySQL Server: DMLNot a Bug
(5631 days)
S35.0.32LinuxAnyunknown column error despite parenthesizing FROM clause
494942009-12-07
9:52
2011-02-16
23:44
MySQL Server: DMLClosed
(5354 days)
S35.1.37, 5.0, next-mrLinux (Ubuntu 9.10)AnyCREATE TABLE IF NOT EXISTS does wrong insert when view exists with the name
495342009-12-08
15:07
2011-02-16
23:44
MySQL Server: DMLClosed
(5437 days)
S15.0.88-debug, 5.0.89-debug, 5.1.41-debug, 5.1.43-debug,5.5.99-m3-debugAnyAnymultitable IGNORE update with sql_safe_updates error causes debug assertion
495502009-12-09
7:37
2011-02-16
23:44
MySQL Server: DMLCan't repeat
(5320 days)
S15.1.41AnyAnymemory leak after filesort
495522009-12-09
9:52
2011-02-16
23:44
MySQL Server: DMLClosed
(5418 days)
S15.0.88,5.1.41AnyAnysql_buffer_result cause crash + not found records in multitable delete/subquery
496362009-12-11
23:15
2012-10-05
15:42
MySQL Server: DMLClosed
(4597 days)
S35.1.36Windows (Vista)AnyALTER TABLE can create table with no name
499582009-12-28
13:48
2018-02-11
11:09
MySQL Server: DMLCan't repeat
(2642 days)
S1AnyAnyHow Solve this Error - Errcode: 13
500052009-12-30
19:00
2010-01-07
12:13
MySQL Server: DMLNot a Bug
(5599 days)
S25.1.41WindowsAnyselect count(*) with LIMIT key word doesn't return expected # of results
501532010-01-07
19:35
2010-01-08
6:29
MySQL Server: DMLNot a Bug
(5598 days)
S3Windows (xp sp3)AnyError in summing time
504842010-01-20
19:20
2010-01-21
13:02
MySQL Server: DMLNot a Bug
(5585 days)
S25.1.42AnyAnyMysql does not manage dates correctly when using DATE_ADD and STR_TO_DATE
505452010-01-22
13:46
2011-02-16
23:44
MySQL Server: DMLClosed
(5437 days)
S3AnyAnySingle table UPDATE IGNORE crashes on join view in sql_safe_updates mode.
506192010-01-26
11:02
2011-02-16
23:44
MySQL Server: DMLClosed
(5231 days)
S35.1.44,5.5.99-m3,6.0.14-alphaAnyAnyassert in handler::update_auto_increment
506272010-01-26
15:21
2018-09-09
20:45
MySQL Server: DMLVerified
(5577 days)
S35.5.1-m2AnyAnyhow to insert a TIMESTAMP of the last hour of daylight savings
506932010-01-28
16:15
2010-02-01
5:09
MySQL Server: DMLNot a Bug
(5574 days)
S3LinuxAnyIncorrect behaviour for aggregate/min/max functions in subquery with no clause
507742010-02-01
2:23
2011-05-13
14:21
MySQL Server: DMLClosed
(5108 days)
S15.1.44, 5.1.49, 5.5.99, 5.5.6rcAnyAnyWrong resultset when timestamp values are appended with .0
507902010-02-01
12:44
2010-02-01
17:02
MySQL Server: DMLNot a Bug
(5574 days)
S35.0.83 and 5.1.42AnyAnyBug in RegExp
510992010-02-11
14:16
2011-02-16
23:44
MySQL Server: DMLClosed
(5286 days)
S25.1, 5.5AnyAnyAssertion in mysql_multi_delete_prepare()
515232010-02-25
18:31
2013-08-09
8:19
MySQL Server: DMLNot a Bug
(4289 days)
S35.1.45, 5.5.99-m3AnyAnyinconsistent reporting of warnings on re-execution of a query against csv tables
515302010-02-25
22:47
2010-02-25
23:00
MySQL Server: DMLNot a Bug
(5550 days)
S25,1,37LinuxAnySelecting a single column returns incorrect data
515982010-03-01
9:09
2011-02-16
23:44
MySQL Server: DMLClosed
(5437 days)
S35.0.91, 5.1.37, 5.1.45AnyAnyInconsistent behaviour with a COALESCE statement inside an IN comparison
518402010-03-08
19:13
2014-05-31
13:49
MySQL Server: DMLClosed
(4065 days)
S14.0.24,4.1.25,5.0.90,5.1.44,5.5.2-m2AnyAnyinfinite hang with 100% cpu usage with load data local and import errors
518502010-03-09
4:57
2011-02-16
23:44
MySQL Server: DMLClosed
(5298 days)
S15.0.89, 5.1.44, 5.1.45-bzr, 5.6.99Linux (fc6 x86)Anycrash/memory overlap when using load data infile and set col equal to itself!
518932010-03-09
21:31
2011-02-16
23:44
MySQL Server: DMLClosed
(5437 days)
S15.0.90, 5.1.44, 5.5.2-m2Windows (XP)Anycrash with certain characters given to load_file function on windows
521222010-03-17
3:29
2018-11-04
20:45
MySQL Server: DMLDuplicate
(5504 days)
S15.6.99-m4-debug, mysql-6.0-codebaseAnyAnycrash when converting derived table column to decimal
521602010-03-17
21:24
2011-02-16
23:44
MySQL Server: DMLClosed
(5258 days)
S15.1+AnyAnycrash and inconsistent results when grouping by a function and column
521642010-03-18
6:05
2011-02-16
23:44
MySQL Server: DMLClosed
(5418 days)
S15.1.45-debug,5.6.99-m4-debugAnyAnyAssertion failed: param.sort_length, file .\filesort.cc, line 149
525072010-03-31
14:53
2011-02-16
23:44
MySQL Server: DMLNo Feedback
(5485 days)
S3MySQL 5.1.45WindowsAnyHAVING cannot reference a field with variable
525822010-04-04
3:51
2014-08-06
17:47
MySQL Server: DMLClosed
(4340 days)
S24.1.25, 5.0.91, 5.1.54, 5.5.10Any (IBM System i 32 bit, Linux)AnyIncorrect results with COUNT DISTINCT and BIG_TABLES
526502010-04-07
10:25
2018-09-09
20:45
MySQL Server: DMLVerified
(5509 days)
S25.1.45, 5.1.47-bzrAnyAnyselect !!0 = 1 returns 1
526512010-04-07
10:33
2010-04-07
22:09
MySQL Server: DMLNot a Bug
(5509 days)
S25.1.22-rc-communityWindowsAny'WHERE' clause not working for 'INT DEFAULT 0' values cointaining 'NULL'
530342010-04-21
18:15
2018-02-12
9:20
MySQL Server: DMLClosed
(5319 days)
S35.1.xAnyAnyMultiple-table DELETE statements not accepting "Access compatibility" syntax
534322010-05-05
11:41
2020-09-13
20:45
MySQL Server: DMLDuplicate
(5461 days)
S15.5.5 , 5.5.4AnyAnySELECT MAX QUERY WITH DATE FIELD GIVES WRONG RESULTS
538302010-05-20
4:14
2011-02-16
23:44
MySQL Server: DMLClosed
(5319 days)
S15.1.43sp1-debug,5.1.46-debug, 5.5.3-debugAnyAny!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))
541472010-06-01
14:18
2018-02-11
11:25
MySQL Server: DMLClosed
(2642 days)
S25.0.51a-3ubuntu5.5 (Ubuntu), 5.0.91, 5.1.48, 5.6.99 bzrLinux (Ubuntu 8.04.4 LTS)AnyValid date string in query results in wrong result on Linux sever.
544592010-06-12
18:25
2011-02-16
23:44
MySQL Server: DMLClosed
(5318 days)
S15.0.91-debug, 5.1.47-debug, 5.5.3-debug, 5.5.5-m3-debugAnyAnyAssertion failed: param.sort_length, file .\filesort.cc, line 149 (part II)
544652010-06-13
10:06
2011-02-16
23:44
MySQL Server: DMLClosed
(5318 days)
S15.0.91, 5.1.47, 5.5.3, 5.5.5-m3AnyAnyassert: field_types == 0 || field_types[field_pos] == MYSQL_TYPE_LONGLONG
545432010-06-16
6:37
2011-02-16
23:44
MySQL Server: DMLClosed
(5326 days)
S15.0.91-debug, 5.1.47-debug, 5.1.49-debugAnyAnyupdate ignore with incorrect subquery leads to assertion failure: inited==INDEX
545882010-06-17
15:51
2018-04-11
12:17
MySQL Server: DMLNot a Bug
(2583 days)
S35.1.47, 5.1.48AnyAnyIndex on datetime column does not support iso8601.
546092010-06-18
9:38
2011-02-16
23:44
MySQL Server: DMLDuplicate
(5437 days)
S15.1.47-1~bpo50+1-log, 6.0.14Linux (debian lenny)AnySelect returning incorrect result
546992010-06-22
16:14
2010-06-22
17:23
MySQL Server: DMLNot a Bug
(5433 days)
S25.1.47LinuxAnySigned Unsigned Subtraction Out of Range Error
547202010-06-23
6:44
2011-07-27
6:38
MySQL Server: DMLClosed
(5033 days)
S15.1.50Linux ( RED HAT Enterprise Linux 2.6.9-55.ELsmp)AnyMysql Server crashes and automatically restart where updating temporary table
548602010-06-28
10:33
2018-09-09
20:45
MySQL Server: DMLVerifiedS3allAnyAnydetect when HANDLER was implicitly reset and looses position
548932010-06-29
9:57
2018-09-09
20:45
MySQL Server: DMLVerified
(5426 days)
S35.1.48AnyAnyselect .. into dumpfile can write 2 rows into the file instead of 1
549162010-06-30
14:24
2011-02-16
23:44
MySQL Server: DMLClosed
(5340 days)
S35.5.4-m3-log, 5.5.6-m3Any (FreeBSD 7.2, Mac OS X, Ubuntu)AnyGROUP_CONCAT + IFNULL truncates output
549202010-06-30
16:37
2011-02-16
23:44
MySQL Server: DMLClosed
(5282 days)
S35.1.49-bzrAnyAnyStored functions are allowed in HANDLER statements, but broken.
549312010-07-01
10:23
2010-07-01
10:37
MySQL Server: DMLNot a Bug
(5424 days)
S25.1AnyAnymysql subquery
549412010-07-01
17:57
2018-02-11
12:50
MySQL Server: DMLCan't repeat
(2642 days)
S35.1.47 ??Windows (XP SP3)Anyjust executing a loop with a counter with initial value = 256
551152010-07-09
8:22
2011-02-16
23:44
MySQL Server: DMLCan't repeat
(5416 days)
S25.1.39Windows (XP)AnyLIMIT with Order By Gives Wrong Result
551882010-07-12
21:01
2011-02-16
23:44
MySQL Server: DMLClosed
(5318 days)
S25.1.46sp1AnyAnyGROUP BY, GROUP_CONCAT and TEXT - inconsistent results
552012010-07-13
3:30
2011-02-16
23:44
MySQL Server: DMLCan't repeat
(5412 days)
S25.5.3 m3WindowsAnyDate-time bug on select
553852010-07-20
4:51
2011-03-02
15:24
MySQL Server: DMLClosed
(5180 days)
S3mysql-next-mr-wl5136-stage, 5.1AnyAnyUPDATE statement throws an error, but still updates the table entries
554632010-07-22
0:25
2016-09-07
20:04
MySQL Server: DMLNot a Bug
(5403 days)
S5AnyAnyincorrect value returned by last_insert_id() function
556152010-07-28
18:15
2011-02-16
23:44
MySQL Server: DMLClosed
(5282 days)
S15.0.91-debug, 5.1.49-debugAnyAnydebug assertion after using variable in assignment and referred to
558102010-08-06
21:07
2011-02-16
23:44
MySQL Server: DMLCan't repeat
(5387 days)
S15.5.5-m3Windows (Vista x64 and Server 2008 x64)Anyincorrect max aggregate calculated
559122010-08-11
14:37
2011-02-16
23:44
MySQL Server: DMLClosed
(5340 days)
S35.5.4FreeBSD (8.0 release )AnyFORMAT with locale set fails for numbers < 1000
559302010-08-12
0:33
2011-02-16
23:44
MySQL Server: DMLClosed
(5282 days)
S25.5.6-m3-debug, 5.6.0-m4-debugAnyAnyAssertion `thd->transaction.stmt.is_empty() || thd->in_sub_stmt || (thd->state..
561312010-08-20
1:42
2011-02-16
23:44
MySQL Server: DMLDuplicate
(5374 days)
S2AnyAnyUPDATE query allows AND (before WHERE) between fields and consequently
562712010-08-25
20:32
2011-02-16
23:44
MySQL Server: DMLClosed
(5290 days)
S35.5.5-m3-logWindows (XP Pro)AnySTR_TO_DATE in date compare incorrect results
562882010-08-26
11:56
2011-02-16
23:44
MySQL Server: DMLDuplicate
(5367 days)
S15.0.45-community-ntWindows (XP SP2)AnyCan't create/write to file Errcode 17
565142010-09-02
18:00
2018-02-11
12:57
MySQL Server: DMLCan't repeat
(2642 days)
S35.5.5 m3FreeBSD (7.2)AnyMixing utf8, group by, IF and Datefield cause a truncate problem (Only in views)
565652010-09-05
10:08
2010-09-06
20:50
MySQL Server: DMLNot a Bug
(5357 days)
S35.1.36AnyAnyMultiple update syntax doesn't update rows multiple times
566532010-09-08
13:56
2018-09-09
20:45
MySQL Server: DMLDuplicate
(5321 days)
S2trunk, 5.6AnyAnyValgrind warnings for memory leak in LOAD DATA INFILE
566782010-09-09
8:57
2011-02-16
23:44
MySQL Server: DMLClosed
(5258 days)
S35.5AnyAnyValgrind warnings from binlog.binlog_unsafe
568992010-09-21
15:43
2011-02-16
23:44
MySQL Server: DMLClosed
(5342 days)
S35.5.5-m3-logAny (XP Pro)AnyIFNULL Evaluation inside CONCAT_WS Incorrect
570152010-09-25
8:10
2011-02-16
23:44
MySQL Server: DMLClosed
(5335 days)
S35.0.51AnyAnyLPad in view displays junk
570392010-09-27
15:32
2011-02-16
23:44
MySQL Server: DMLClosed
(5286 days)
S25.5.5-m3-log, 5.5.7-bzrAny (10.04)Anyqueries using subtime in the where condition returns incorrect data
571532010-09-30
20:32
2018-02-11
13:02
MySQL Server: DMLCan't repeat
(2642 days)
S55.1.51Other (Centos 5.5)AnyPerformance of call to POWER(LOG(EXP(0.25)),0.5) slower than expected on 5.1.51
573092010-10-07
11:35
2010-10-07
13:35
MySQL Server: DMLNot a Bug
(5326 days)
S2AnyAnyTIMEDIFF function giving same value for different date
573732010-10-11
14:14
2011-03-02
15:25
MySQL Server: DMLClosed
(5180 days)
S35.1, 5.5AnyAnyMulti update+InnoDB reports ER_KEY_NOT_FOUND if a table is updated twice
576432010-10-22
2:47
2022-12-04
20:45
MySQL Server: DMLVerified
(4890 days)
S35.1.41, 5.1.50, 5.5.20LinuxAnyInnoDB skips auto_increment values with LOAD DATA INFILE
577232010-10-26
1:47
2018-09-09
20:45
MySQL Server: DMLDuplicate
(5307 days)
S35.1.49,5.5.6rcAnyAnyWrong results when milisecond precision is passed to WHERE >= clause
577592010-10-27
3:37
2010-10-28
0:26
MySQL Server: DMLNot a Bug
(5305 days)
S25.0.77, 5.0.90, 5.1, 5.5.6rcAnyAnyStrange parsing error bug
577772010-10-27
16:05
2011-02-16
23:44
MySQL Server: DMLWon't fix
(5237 days)
S25.0.92Windows (Windows 7)AnyConnector problems between mysql and crystal reports 8.5
578692010-10-31
10:21
2018-02-11
13:06
MySQL Server: DMLCan't repeat
(2642 days)
S35.1.51-communityWindows (7)AnyINSERT ... SELECT with data manipulation
580022010-11-04
23:20
2010-11-17
9:00
MySQL Server: DMLNot a Bug
(5285 days)
S35.1.51-communityWindows (7)Anysame command, different behavior
581652010-11-12
14:25
2011-03-02
3:27
MySQL Server: DMLClosed
(5180 days)
S15.1.54, 5.5.7AnyAny"my_empty_string" gets modified and causes LOAD DATA to fail and other crashes
586012010-11-30
17:34
2020-01-08
21:08
MySQL Server: DMLCan't repeat
(1946 days)
S35.1.50-communityWindows (xp Prof)Anyselect into outfile bug with workbench adding LIMIT, and not working w/o FROM
587432010-12-05
17:36
2010-12-05
19:50
MySQL Server: DMLNot a Bug
(5267 days)
S35.1.45AnyAnyUPDATE statement is accepted but produces wrong results when AND is used in SET
590932010-12-21
16:24
2012-07-22
1:00
MySQL Server: DMLNo Feedback
(4673 days)
S35.1.48, 5.5.8Linux (Centos 5.5 Final)AnyLOAD DATA hangs after millions of rows inserted
591542010-12-24
12:58
2018-09-09
20:45
MySQL Server: DMLDuplicate
(5194 days)
S15.6.1, 5.6.2, 5.5.10, 5.1AnyAnyreading of freed memory during multiple user variable assignments
591642010-12-24
22:43
2011-04-19
16:59
MySQL Server: DMLClosed
(5132 days)
S35.0.92,5.1.55,5.5.9,5.6.1, 5.6.2AnyAnyvalgrind: uninitialized value in number_to_datetime
591662010-12-25
6:52
2011-04-19
17:15
MySQL Server: DMLClosed
(5132 days)
S35.1.55,5.5.9,5.6.1,5.6.2AnyAnyanother datetime valgrind uninitialized warning
592112010-12-29
11:57
2011-02-16
23:44
MySQL Server: DMLClosed
(5201 days)
S3mysql-5.1,5.5, 5.6.1, 5.6.2AnyAnySelect Returns Different Value for min(year) Function
592412010-12-31
9:36
2011-02-16
23:44
MySQL Server: DMLClosed
(5212 days)
S25.6.2, 5.5AnyAnyinvalid memory read in do_div_mod with doubly assigned variables
592482010-12-31
23:31
2013-01-22
19:06
MySQL Server: DMLClosed
(4488 days)
S25.5.8, 5.5.20AnyAnycode review: write_row() crashes on INSERT...DUPLICATE KEY UPDATE
593862011-01-10
6:01
2011-08-20
23:00
MySQL Server: DMLNo Feedback
(5009 days)
S3mysql-5.5WindowsAny"Load Data" Does Not Populate data in table on window - for 5.5 trunk security
595042011-01-14
14:07
2011-02-22
14:36
MySQL Server: DMLCan't repeat
(5188 days)
S3trunkAnyAnyAssert in Protocol::end_statement() for LOAD DATA
595262011-01-15
14:08
2018-09-09
20:45
MySQL Server: DMLVerified
(5210 days)
S35.0, 5.1, 5.6.2AnyAnyZERO-date can be inserted in 'no_zero_date' sql_mode
596982011-01-24
15:36
2011-02-16
23:44
MySQL Server: DMLClosed
(5217 days)
S25.5.8AnyAnyInsert with NULL value for recursive constraint fails
597122011-01-25
11:18
2011-02-16
23:44
MySQL Server: DMLClosed
(5216 days)
S35.1.48AnyAnyCannot insert a table record with a null value for an optional foreign key
598832011-02-02
8:16
2011-04-11
23:00
MySQL Server: DMLNo Feedback
(5140 days)
S25.1.44AnyAnyNOT IN clause with LIMIT
599372011-02-04
9:20
2011-02-16
23:44
MySQL Server: DMLClosed
(5206 days)
S25.1.41Linux (ubuntu maverick)Anyselect query with order by clause repeats data and repair table says status ok
600352011-02-09
6:17
2011-05-21
18:49
MySQL Server: DMLVerified
(5100 days)
S3mysql-trunkSolaris (10 x86_64)Anymain.insert_select fails due to error in log files
601662011-02-18
10:54
2012-03-22
18:25
MySQL Server: DMLClosed
(4794 days)
S25.0.91, 5.1.36, 5.1.54, 5.5.8, 5.5.9Any (Windows 7, Linux Ubuntu 9.10)AnySUBSTRING_INDEX() results "omit" character when used inside LOWER()
601782011-02-19
9:58
2013-07-17
19:57
MySQL Server: DMLClosed
(4312 days)
S35.5.9Windows (Windows 7)AnyCorruption of text variable inside trigger
602512011-02-25
13:39
2011-02-25
14:04
MySQL Server: DMLClosed
(5185 days)
S35.5.8LinuxAnyDoes not work DISCARD TABLESPACE on partitioned table
602992011-03-02
0:21
2011-04-02
23:00
MySQL Server: DMLNo Feedback
(5149 days)
S35.1.43sp1-enterprise-gpl-advanced-logAnyAnyCreate Table as SELECT with expression doesn't work right
604352011-03-11
21:38
2018-02-11
13:20
MySQL Server: DMLNot a Bug
(2642 days)
S15.5.9, 5.5.8, 5.1.54AnyAnyreturn values truncated
605162011-03-17
15:26
2011-11-24
11:33
MySQL Server: DMLClosed
(4913 days)
S15.5.10Linux (Fedora 14)AnyUPDATE within a function fails and causes infinite loop
606072011-03-23
20:04
2011-03-23
20:37
MySQL Server: DMLDuplicate
(5159 days)
S35.5.10AnyAnyUPDATE Incorrect syntax indicates success but fails
607192011-04-01
8:40
2018-02-11
13:27
MySQL Server: DMLCan't repeat
(2642 days)
S35.5.10, 5.5.9AnyAnyField info in EXPLAIN EXT./GROUP BY WITH ROLLUP says NOT NULL and contains NULL
607242011-04-01
16:19
2011-04-05
14:50
MySQL Server: DMLVerified
(5150 days)
S25.5.11, 5.5.10-log, 5.1.57, 5.0.93AnyAnyUnquoted date literal in comparison yields incorrect implicit conversion
607862011-04-07
0:18
2019-11-28
21:59
MySQL Server: DMLClosed
(1987 days)
S25.1.49/5.5Linux (Debian Squeeze)AnyFor update:Trailing white space not ignored with index, is ignored without index
608382011-04-12
2:01
2011-05-12
23:00
MySQL Server: DMLNo Feedback
(5109 days)
S2Ver 14.12 Distrib 5.0.91MacOSAnyon duplicate key update -- lost data
608852011-04-15
20:49
2011-04-16
2:33
MySQL Server: DMLNot a Bug
(5135 days)
S25.0.32-Debian_7etch11LinuxAny(not so) wrong NOT IN result (when NULL values are involved)
609312011-04-20
8:13
2011-04-20
11:17
MySQL Server: DMLNot a Bug
(5131 days)
S2LinuxAnyComparaison on column with some NULL values
609872011-04-27
15:54
2011-06-16
19:39
MySQL Server: DMLClosed
(5074 days)
S25.5Any (Windows Vista, CentOS 5 Linux)AnyLOAD DATA LOCAL INFILE can path parse relative paths "higher" than 3 levels
610322011-05-02
22:46
2011-06-03
23:00
MySQL Server: DMLNo Feedback
(5087 days)
S35.0.51bWindows (Vista)AnyConvert to Integers Returns Errorneous Results
610362011-05-03
8:22
2011-05-05
13:11
MySQL Server: DMLNot a Bug
(5116 days)
S35.6.2 m5Windows (xp sp3)Anymay an error in partitioning order
610672011-05-05
9:55
2011-09-23
23:00
MySQL Server: DMLNo Feedback
(4976 days)
S25.5.11Windows (Vista)AnyForeign key creation order is essential
610952011-05-09
8:34
2011-06-09
23:00
MySQL Server: DMLNo Feedback
(5081 days)
S25.0.45LinuxAnycom.mysql.jdbc.CommunicationsException: Communications link failure due to under
611002011-05-09
12:48
2018-04-12
14:20
MySQL Server: DMLClosed
(2582 days)
S35.5.8, 5.5.13Any (XP, Mac OS X)AnyIncorrecte value from Select Max(date) with year smaller 100.
611842011-05-16
9:33
2018-02-11
13:39
MySQL Server: DMLClosed
(2642 days)
S15.1.54-1ubuntu4, 5.1.56Any (Ubuntu 11.04, Widnows XP)AnyRIGHT JOIN with WHERE gives wrong result
612232011-05-19
1:57
2012-10-23
1:00
MySQL Server: DMLNo Feedback
(4580 days)
S55.0AnyAnySQL_CALC_FOUND_ROWS kills performance with left join ,join,right join and LIMIT
612242011-05-19
10:13
2018-02-11
13:48
MySQL Server: DMLClosed
(5098 days)
S35.5.12Windows (XP)Anyfunction pow is wrong
612272011-05-19
11:55
2018-09-09
20:45
MySQL Server: DMLVerified
(5102 days)
S25.0.51, 5.0.91, 5.1.57AnyAnywhere->order
613662011-05-31
18:31
2011-06-01
13:24
MySQL Server: DMLNot a Bug
(5089 days)
S25.5.11Linux (CentOS 5.6)Anytable not found when using multi-table delete with alias no default table select
613712011-06-01
10:26
2011-06-02
12:16
MySQL Server: DMLNot a Bug
(5088 days)
S15.0.32-7etch12, 5.1.54-1ubuntu4Linux (Ubuntu 11.04)AnyDuplicate Key when inserting new auto increment value
613752011-06-01
13:49
2017-04-26
17:17
MySQL Server: DMLNot a Bug
(5089 days)
S35.5AnyAnyAuto Increment Syntax
613762011-06-01
14:04
2018-07-12
10:53
MySQL Server: DMLVerified
(4746 days)
S35.1.58, 5.5AnyAnyDelete statements referencing aliases fail when no database is selected
613782011-06-01
14:57
2018-04-12
14:23
MySQL Server: DMLClosed
(2582 days)
S35.5.12, 5.5.14Any (CentOS Linux 5.6, Mac OS X)AnyNULLIF sometimes causes timestamp field text output to be truncated
614102011-06-05
6:47
2017-08-06
12:36
MySQL Server: DMLNot a Bug
(5085 days)
S15.5.11Linux (suse)Anyan unsigned column can't subtract a bigger value than before
616022011-06-23
3:44
2011-06-23
3:52
MySQL Server: DMLClosed
(5067 days)
S25.0.91AnyAnytolower() in where clause returns wrong value for column
616452011-06-26
8:16
2011-06-28
7:31
MySQL Server: DMLVerified
(5062 days)
S25.5.13, 5.5.15LinuxAnyexternal locking corrupted temporary table after alter
618322011-07-12
10:58
2011-07-12
11:19
MySQL Server: DMLNot a Bug
(5048 days)
S3LinuxAnyNo error message shown, though there is no column entry as 5 in table
619422011-07-21
12:53
2011-07-21
14:51
MySQL Server: DMLNot a Bug
(5039 days)
S5mysql 5.5LinuxAnyMysql command to modify the unique index of a table
620532011-08-02
4:14
2011-08-02
4:22
MySQL Server: DMLNot a Bug
(5027 days)
S15.5AnyAnycolumns in SELECT clause not affected by group fn must be declared in GROUP BY
620972011-08-05
18:18
2011-08-05
19:32
MySQL Server: DMLDuplicate
(5024 days)
S15.5Windows (xp)Anyunable to run a select statement
621472011-08-11
12:05
2011-08-23
19:19
MySQL Server: DMLNot a Bug
(5006 days)
S25.5.8AnyAnyLEFT JOIN generating HUGE temp_table (very slow of course)
622822011-08-28
21:52
2012-05-31
17:31
MySQL Server: DMLClosed
(4724 days)
S55.5, 5.1, ...AnyAnyLOCK_thread_count is used for random functions
623202011-09-01
11:23
2011-09-01
21:35
MySQL Server: DMLVerified
(4997 days)
S25.5.15AnyAnyInnoDB and MyISAM show different LAST_INSERT_ID()/AUTO_INCREMENT behaviour
623252011-09-01
17:45
2011-11-14
10:37
MySQL Server: DMLNot a Bug
(4923 days)
S35.5.8 MySQL Community Server (GPL)Windows (Windows 7)AnyLOAD DATA not loading NULL values properly
623312011-09-02
15:56
2011-09-02
21:08
MySQL Server: DMLNot a Bug
(4996 days)
S15.0.77-logWindowsAnyError "duplicate entry" in command REPLACE INTO
623502011-09-05
12:13
2013-07-17
13:44
MySQL Server: DMLVerified
(4991 days)
S25.5/5.1AnyAnymysql_stmt_result_metadata() returns invalid metadata on EXPLAIN, can crash PHP
623592011-09-06
7:35
2012-02-17
1:00
MySQL Server: DMLNo Feedback
(4829 days)
S15.1.36SolarisAnyERROR 2005 (HY000): Unknown MySQL server host
623722011-09-07
11:48
2018-02-11
14:17
MySQL Server: DMLClosed
(2642 days)
S35.5.15, 5.5.17AnyAnyWrong query results with SQL_CALC_FOUND_ROWS, GROUP BY, LIMIT and Using index
624472011-09-16
2:27
2011-09-16
6:00
MySQL Server: DMLNot a Bug
(4982 days)
S3mysql-5.5.15-win32Windows (windows xp)Anyregexp Return error results
624952011-09-22
0:38
2011-09-22
11:18
MySQL Server: DMLNot a Bug
(4976 days)
S25.1.44MacOS (10.6.8)AnyDiscrepant results when using UNION and COUNT
625262011-09-24
0:53
2011-10-24
23:00
MySQL Server: DMLNo Feedback
(4944 days)
S15.1.49-1ubuntu8.1 (Ubuntu)AnyAnyMySQL failed to parse Subquery with wrong column name
625522011-09-27
16:33
2011-09-27
16:36
MySQL Server: DMLCan't repeat
(4971 days)
S2AnyAnyErro ao executar script
625542011-09-27
17:23
2011-09-28
13:14
MySQL Server: DMLNot a Bug
(4970 days)
S35.1.56-logAnyAnyUpdate bug
625802011-09-30
6:43
2011-09-30
17:47
MySQL Server: DMLNot a Bug
(4968 days)
S35.5.8AnyAnyAllow insert null
625842011-09-30
9:31
2012-01-24
10:23
MySQL Server: DMLWon't fix
(4852 days)
S35.5.17AnyAnyPI()+0.000000000000000000 returns differenct value between 5.1 and 5.5.
626152011-10-04
9:01
2012-01-27
1:00
MySQL Server: DMLNo Feedback
(4850 days)
S25.1.52Other (CenTOs 2.6.32-71.29.1.e.l6.i686)Anylimit and order by do not work properly when used together
626562011-10-07
18:07
2012-01-27
1:00
MySQL Server: DMLNo Feedback
(4850 days)
S25.5.16Windows (sever 2003 32 bit)Anymysqldump losing connection on Big tables: Lost connection to MySQL server
627552011-10-16
2:59
2011-11-23
12:51
MySQL Server: DMLDuplicate
(4914 days)
S35.5.16; 5.1.59Windows (XP SP3)AnyUnexpect "ERROR 1062 (23000): Duplicate entry '...' for key 'group_key'" error
628382011-10-20
4:32
2011-10-20
11:24
MySQL Server: DMLNot a Bug
(4948 days)
S35.5Windows (Vista)AnyBit wise operations return incorrect result
628432011-10-20
11:25
2019-11-06
20:52
MySQL Server: DMLVerified
(4943 days)
S3anyAnyAnybin() function and "Bit functions"
629402011-10-26
6:51
2012-12-24
9:32
MySQL Server: DMLDuplicate
(4517 days)
S25.1.39, 5.5.10, 5.5.20Any (Linux, Mac OS X)AnySELECT results vary with version and with/without index range scan
629492011-10-26
18:36
2011-11-03
12:17
MySQL Server: DMLVerified
(4941 days)
S25.5.17Linux (CentOS 5.7)AnyMultiple DELETE permission bug
630372011-10-31
13:59
2019-11-06
21:42
MySQL Server: DMLNot a Bug
(2009 days)
S35.5.17Linux (Ubuntu 11.04)AnyGreater-than operator returns unexpected result with text-field
630462011-10-31
20:12
2011-10-31
20:27
MySQL Server: DMLNot a Bug
(4937 days)
S2MS sql server 9.00WindowsAnyupdate in mysql - please help
630552011-11-01
11:45
2014-01-28
12:32
MySQL Server: DMLClosed
(4193 days)
S35.5.17, 5.5.20LinuxAnymysql assumes all ethernet devices are named ethX
633712011-11-21
22:29
2011-12-22
17:54
MySQL Server: DMLWon't fix
(4885 days)
S35.1.59, 5.1.61AnyAnyInvalid sort ordering in 5.1, innodb composite pkeys joined to subqueries
633762011-11-22
8:16
2017-06-08
14:33
MySQL Server: DMLVerified
(4914 days)
S35.1.52, 5.5.17Any (-enterprise-commercial-pro)AnyCONVERT_TZ should fail on empty mysql.time_zone table, currently it returns NULL
634372011-11-26
14:10
2012-01-27
19:30
MySQL Server: DMLClosed
(4849 days)
S25.1, 5.5AnyAnyCHAR & BETWEEN with index returns wrong result after MySQL 5.1.
634392011-11-26
17:19
2016-11-09
14:00
MySQL Server: DMLVerified
(4909 days)
S35.5.8, 5.1.60Any (Windows 7, Mac OS X)AnyREGEXP does not work properly with umlauts
635142011-12-01
5:52
2011-12-01
5:57
MySQL Server: DMLNot a Bug
(4906 days)
S25.5.31WindowsAnyselect count(*), column_name from table gives inconsistant result
635362011-12-02
8:16
2011-12-02
20:05
MySQL Server: DMLNot a Bug
(4905 days)
S3AnyAnyPossible bug in function current_date( )
636072011-12-05
16:56
2011-12-05
16:57
MySQL Server: DMLCan't repeat
(4902 days)
S3AnyAnyBug tnmjdfmhdf
636682011-12-08
13:21
2018-02-11
22:48
MySQL Server: DMLNot a Bug
(2642 days)
S35.5.13, 5.5.17LinuxAnyROUND(x,d) doesn't round a value to "d" digits when "d" is passed as column
636862011-12-08
21:58
2012-01-09
7:00
MySQL Server: DMLNo Feedback
(4867 days)
S25.0.45-communityLinux (Red Hat)AnyNested LEFT JOIN returns invalid results
637472011-12-14
14:43
2011-12-14
14:50
MySQL Server: DMLNot a Bug
(4893 days)
S35.1.41Linux (mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1)AnyUPDATE test SET a = a+b, b = a+b
637852011-12-18
4:53
2012-01-19
1:00
MySQL Server: DMLNo Feedback
(4858 days)
S35.5Windows (7)Anyselect from database that I granted permissions immediately before
638292011-12-21
19:34
2024-04-19
21:56
MySQL Server: DMLVerified
(4885 days)
S35.1.58, 5.5.20AnyAnySearch containig backslash doesn't work if field collation is utf8_unicode_ci
638972012-01-02
16:17
2012-01-14
10:01
MySQL Server: DMLNot a Bug
(4862 days)
S25.1.56AnyAnyround function problem in update query
640252012-01-13
14:21
2012-01-15
19:15
MySQL Server: DMLVerified
(4863 days)
S35.1.61, 5.5.15AnyAnyON DUPLICATE KEY UPDATE sets auto_increment column value to 0
640542012-01-17
20:46
2012-01-18
5:15
MySQL Server: DMLDuplicate
(4858 days)
S15.5.19Linux (i686 2.6.18)AnyDouble negation (!!) not working in 5.5.19
640882012-01-20
19:18
2012-01-20
19:33
MySQL Server: DMLNot a Bug
(4856 days)
S1allLinuxAnyno select works against a view created with limit (x)
641502012-01-27
17:46
2012-03-26
18:09
MySQL Server: DMLCan't repeat
(4790 days)
S55.1.52AnyAnyperformance drops with glibc 2.13 when threads are created
641762012-01-31
9:43
2012-02-14
16:22
MySQL Server: DMLNot a Bug
(4831 days)
S35.1.54AnyAnySorting issue in a formatted datetime
642472012-02-07
10:08
2019-11-06
21:28
MySQL Server: DMLClosed
(2009 days)
S25.5.18, 5.5.21AnyAnyAbnormal behaviour of str_to_date() function
642742012-02-09
9:42
2012-04-09
16:29
MySQL Server: DMLClosed
(4776 days)
S15.6.4m7AnyAnyMySQL thread was suspended when execute UPDATE query
642902012-02-10
6:24
2012-02-10
15:41
MySQL Server: DMLNot a Bug
(4835 days)
S35.5.15WindowsAnyINSERT ON DUPLICATE KEY UPDATE can't work with primary key value equals zero
642982012-02-10
20:24
2015-08-30
17:06
MySQL Server: DMLVerified
(4834 days)
S35.1.59, 5.5.20AnyAnyascii does not work on multibyte characters
643012012-02-11
13:54
2012-02-17
17:51
MySQL Server: DMLDuplicate
(4828 days)
S3AnyAnyWrong row count returned with 'NO_AUTO_VALUE_ON_ZERO' sql_mode
645162012-03-01
19:23
2012-03-01
20:36
MySQL Server: DMLNot a Bug
(4815 days)
S25.1.47AnyAnyCURDATE() -1 on 1 March of leap year
645242012-03-02
13:48
2012-03-02
14:21
MySQL Server: DMLNot a Bug
(4814 days)
S35.5.19 x64Linux (Ubuntu 11.10 x86_64)AnyIncorrect order when quoting an ORDER BY aliased column.
645262012-03-02
17:27
2012-03-06
8:40
MySQL Server: DMLVerified
(4814 days)
S35.5.10, 5.5.20WindowsAnybug when truncate() and format() used together
645922012-03-08
12:42
2012-03-09
8:56
MySQL Server: DMLCan't repeat
(4807 days)
S15.1.52Linux (Scientific Linux 6.1)AnySelect integer query with limit returns 0 results w/ 2 conds but not w/ 3
645952012-03-08
23:17
2012-04-10
1:00
MySQL Server: DMLNo Feedback
(4776 days)
S25.5LinuxAnysom columns in inner joined table not accessible for outer join
645992012-03-09
7:32
2012-03-09
17:40
MySQL Server: DMLVerified
(4807 days)
S35.0.87, 5.6.5LinuxAnyCONVERT_TZ fails to convert from GMT to system_time_zone
646322012-03-13
10:10
2015-01-28
16:17
MySQL Server: DMLClosed
(4797 days)
S15.1.52Windows (Seven 32 bits and XP 64bits)AnyCannot insert date '2011-03-27 02:00:00'
647262012-03-21
19:43
2012-03-26
22:32
MySQL Server: DMLNot a Bug
(4790 days)
S35.1.61 and 5.5.21LinuxAnysub-query not failing when it should be
647472012-03-23
16:43
2012-05-18
1:00
MySQL Server: DMLNo Feedback
(4737 days)
S35.1.56Linux (RHEL 5.6)AnyLOAD DATA INFILE causes server crash on large rows
647512012-03-24
0:11
2014-05-06
16:28
MySQL Server: DMLVerified
(4788 days)
S25.5.20, 5.6.4, 5.6.5Linux (64 bit)AnyMySQL 5.5+ cannot replicate some statements that are valid in 5.1
647522012-03-24
2:58
2012-04-02
17:56
MySQL Server: DMLNot a Bug
(4783 days)
S25.5.21Linux (CentOS 5.4)AnyWhen trying to restore tables or mysql dump: ERROR 1114 table is full
647652012-03-26
13:38
2019-11-06
21:44
MySQL Server: DMLNot a Bug
(2009 days)
S35.1.62, 5.5.20 AnyAnyStrange behavior of GREATEST, when use it in subquery with variables
647692012-03-26
22:27
2012-03-27
7:05
MySQL Server: DMLVerified
(4789 days)
S35.1.61Any (Debian unstable)Anycomparing indexed ENUM with 0+string constant does not use index properly
648172012-03-30
16:04
2012-03-31
7:32
MySQL Server: DMLNot a Bug
(4785 days)
S35.1AnyAnyINSERT INTO ... VALUES(0,... uses auto_increment value instead
648832012-04-05
22:35
2012-04-09
11:08
MySQL Server: DMLVerified
(4779 days)
S35.1.61, 5.5.22Any (Windows 7 (64 bit), Mac OS X)AnyROW_COUNT() returns -1 for LOAD DATA INFILE
650132012-04-17
18:32
2012-04-18
18:45
MySQL Server: DMLClosed
(4767 days)
S35.1.36, 5.5.22AnyAnyIllegal (?) syntax returns different results depending on index in WHERE clause
650172012-04-17
23:41
2012-04-25
8:51
MySQL Server: DMLVerified
(4767 days)
S35.0, 5.1, 5.5AnyAnyDate and time functions are not consistently named
650312012-04-19
8:24
2014-11-08
8:52
MySQL Server: DMLNot a Bug
(3833 days)
S35.5.21-log, 5.5.23Windows (win7 x64)AnyExpression type BIGINT UNSIGNED
650532012-04-20
10:52
2012-04-26
8:53
MySQL Server: DMLCan't repeat
(4759 days)
S25.5.21AnyAnyIncorrect select results when using index and complicated select count(distinct(
650682012-04-23
3:31
2012-04-24
8:50
MySQL Server: DMLNot a Bug
(4761 days)
S35.1,5.5AnyAnymysql will return error result while using "case...when"
651852012-05-03
8:42
2012-05-07
7:18
MySQL Server: DMLDuplicate
(4748 days)
S15.5Linux (Ubuntu)AnyErrorCode 1379: View's SELECT still can't contain a subquery
652382012-05-08
10:13
2012-06-11
1:00
MySQL Server: DMLNo Feedback
(4714 days)
S3 5.6.2-m5-log AnyAnyIncorrect return values in IF and CASE statements
652432012-05-08
17:50
2020-01-08
22:51
MySQL Server: DMLCan't repeat
(1946 days)
S55.6.4WindowsAnySubstring function very slow for longer strings
653052012-05-13
21:06
2012-05-24
3:10
MySQL Server: DMLCan't repeat
(4731 days)
S55.1.63AnyAnyINSERT INTO NULL BUG
653072012-05-14
4:02
2012-05-14
13:20
MySQL Server: DMLNot a Bug
(4741 days)
S35.5AnyAnyProblem with order by and limit offset
653752012-05-20
22:46
2012-06-22
1:00
MySQL Server: DMLNo Feedback
(4703 days)
S25.5.16WindowsAnyINSERT-SELECT inserts only last row from SELECT statement
655292012-06-06
5:56
2012-06-08
3:57
MySQL Server: DMLCan't repeat
(4716 days)
S25.5.15AnyAnyAny table trigger breaks multiple insert statement into single statements.
657062012-06-22
7:42
2013-01-10
12:16
MySQL Server: DMLCan't repeat
(4500 days)
S15.5.24, 5.5.27, 5.1.65, 5.0.97Linux (Ubuntu 12.04)AnySELECT statement used to create a view works, selecting from the view -> ER 1356
657632012-06-28
15:16
2018-02-12
22:20
MySQL Server: DMLNot a Bug
(2641 days)
S35.1.64, 5.5AnyAnyCOALESCE(), UNION truncates padding on zero-filled values
657662012-06-29
7:08
2012-07-30
1:00
MySQL Server: DMLNo Feedback
(4665 days)
S5WindowsAnyinsert/update
657982012-07-03
15:16
2012-11-14
20:54
MySQL Server: DMLClosed
(4557 days)
S35.5.26AnyAnyONLY_FULL_GROUP_BY documentation doesn't mention implicit group by
658082012-07-04
11:27
2012-07-04
14:06
MySQL Server: DMLNot a Bug
(4690 days)
S15.1.62LinuxAnyMinimum value is incorrect.
658462012-07-08
18:17
2016-09-09
11:23
MySQL Server: DMLWon't fix
(3162 days)
S35.1.63, 5.5.25, 5.5.26AnyAnyINSERT DELAYED on a BLACKHOLE table hangs forever
658492012-07-09
10:09
2012-07-09
14:47
MySQL Server: DMLNot a Bug
(4685 days)
S35.5.24Linux (Ubuntu 12.04)AnyLAST_INSERT_ID() returns multiple rows under certain circumstances
658602012-07-10
5:48
2013-12-11
6:44
MySQL Server: DMLClosed
(4165 days)
S15.1,5.5,5.6LinuxAnymysqld was crashed wihile using filesort
659022012-07-15
16:27
2012-09-30
11:03
MySQL Server: DMLClosed
(4602 days)
S35.1.48, 5.5.26AnyAnyIncorrect Semantics for "> ALL" when NULL in sub query
659362012-07-18
12:49
2015-07-13
16:51
MySQL Server: DMLClosed
(3586 days)
S25.5.24, 5.5.26AnyAnywrong results on table left join view
659702012-07-20
21:50
2012-07-23
10:02
MySQL Server: DMLVerified
(4673 days)
S35.5.19, 5.5.26AnyAnyAVG group function when dealing with maximum number give wrong results
659762012-07-21
18:11
2013-10-15
18:31
MySQL Server: DMLClosed
(4222 days)
S35.5.25a, 5.5.26AnyAnySELECT IFNULL(NULL, ~1) returns incorrect value
659832012-07-23
10:41
2012-08-24
1:00
MySQL Server: DMLNo Feedback
(4640 days)
S25.1.40LinuxAnya executing subquery , never stop
661482012-08-01
22:53
2018-02-13
22:14
MySQL Server: DMLClosed
(2640 days)
S35.1.32, 5.1.61, 5.1.63, 5.1.66MacOS (10.5)Anyincorrect 'data truncated' warning when inserting into decimal field
661542012-08-02
9:21
2012-08-10
16:04
MySQL Server: DMLVerified
(4661 days)
S35.0, 5.5, 5.5.28AnyAnyCONVERT_TZ using Etc/GMT zones gives wrong result
661782012-08-03
7:27
2014-12-23
12:45
MySQL Server: DMLNot a Bug
(3788 days)
S25.5.16, 5.5.25, 5.1.36, 5.5.28AnyAnySTR_TO_DATE and YEARWEEK inconsistencies
661982012-08-04
8:04
2012-08-04
8:58
MySQL Server: DMLNot a Bug
(4659 days)
S25.1.61Linux (Cent OS)AnyDate Manipulation
662402012-08-07
9:57
2012-08-09
9:04
MySQL Server: DMLClosed
(4654 days)
S35.5.25aWindows (Win2k3)Anyincorrect datetime value trying to insert valid date
665132012-08-23
10:14
2012-08-31
15:37
MySQL Server: DMLClosed
(4632 days)
S35.1.65, 5.1.66AnyAnyDebug build fails assertion in records_in_range()
665372012-08-25
14:33
2012-08-28
6:34
MySQL Server: DMLVerified
(4638 days)
S25.0.96. 5.1.63, 5.5.23, 5.6.5AnyAnyBOM problem
666592012-09-03
3:37
2012-09-05
16:49
MySQL Server: DMLNot a Bug
(4627 days)
S25.6.6Any (XP and Linux)Anymysql 5.6.6m9 fails on OPTION SQL_SELECT_LIMIT=DEFAULT
666632012-09-03
10:03
2016-04-19
22:19
MySQL Server: DMLNot a Bug
(4629 days)
S25.5.27LinuxAnyDELETE has wrong scope in SUBSELECT
667202012-09-06
8:03
2012-09-09
16:24
MySQL Server: DMLVerified
(4626 days)
S35.5.24-0ubuntu0.12.04.1, 5.5.29, 5.0.95, 5.1.66, 5.7.0Linux (Ubuntu 12.04)AnyRegexp problem
667942012-09-13
2:39
2012-09-13
14:53
MySQL Server: DMLVerified
(4619 days)
S35.1.63/5.5.29Linux (Ubuntu 32bit)AnyColumn metadata inconsistent when used against a View
669152012-09-21
17:57
2012-10-12
3:12
MySQL Server: DMLDuplicate
(4590 days)
S35.5.27LinuxAnyReplication thread crashes server on specific query
670142012-09-28
22:10
2015-07-13
16:51
MySQL Server: DMLClosed
(3586 days)
S25.5.27, 5.5.67, 5.0.97, 5.1.67, 5.7.1Windows (7, 64-bit)AnyView evaluation is incorrect when joining to view that selects a literal
670222012-09-30
11:38
2012-10-04
21:29
MySQL Server: DMLNot a Bug
(4598 days)
S25.6.7AnyAnyEXPLAIN EXTENDED FORMAT= .. not allowed
670642012-10-03
3:36
2018-02-13
22:39
MySQL Server: DMLCan't repeat
(2640 days)
S5since 5.5.24 and new versionsAnyAnySQL Query Execution from Batch files is now really slow, since 5.5.24 and new.
672592012-10-16
10:21
2013-07-08
12:08
MySQL Server: DMLCan't repeat
(4321 days)
S25.5.27, 5.5.28Linux ( 2.6.35.14-106.fc14.x86_64)AnyMySQL 5.5.x uses more memory than 5.1.x when temporary tables are used
673002012-10-19
14:29
2015-07-13
16:57
MySQL Server: DMLClosed
(3586 days)
S35.5.14-log, 5.0.97, 5.1.67, 5.5.30, 5.7.1Any (MS Windows Pro 7, Linux)Anytable left join view, unmatched rows problem where view contains an if
673942012-10-27
9:08
2012-12-22
12:46
MySQL Server: DMLDuplicate
(4519 days)
S15.5.17, 5.5.24LinuxAnyinfinite 100% cpu hang on load data local infile
675292012-11-09
0:20
2017-01-09
18:55
MySQL Server: DMLVerified
(4562 days)
S35.1.41, 5.1.67, 5.5.29, 5.7.0AnyAnyGROUP BY treats +0 and -0 as different values
675352012-11-09
13:41
2014-02-03
0:33
MySQL Server: DMLVerified
(4551 days)
S35.0.97, 5.1.67, 5.5.29, 5.7.0Any (MS Windows, Linux)AnyLAST_INSERT_ID() and INSERT IGNORE behavior
675412012-11-09
17:30
2012-11-09
18:06
MySQL Server: DMLVerified
(4562 days)
S35.5.28AnyAnyLOAD XML cannot load data from mysqldump --xml
675422012-11-09
17:39
2015-08-18
16:43
MySQL Server: DMLClosed
(3550 days)
S35.5.28, 5.7.0AnyAnyLOAD XML does not handle empty elements
675782012-11-13
17:19
2013-03-26
5:58
MySQL Server: DMLClosed
(4425 days)
S25.5.8, 5.0.96, 5.1.67, 5.5.29, 5.7.0Any (MS Windows Vista, Linux)Anyin ELT of LEAST of FLOOR of NULL NULL is not passed on but ignored, as if MIN
675802012-11-13
21:57
2018-02-13
22:53
MySQL Server: DMLClosed
(2640 days)
S35.5.28, 5.5.30, 5.1.67, 5.0.97Linux (sles11)Anygroup_concat() limited to 64kb on compress()'ed fields when order by is used
676312012-11-19
11:52
2015-03-09
19:03
MySQL Server: DMLClosed
(3712 days)
S35.0.97, 5.1.67, 5.5.29, 5.7.0AnyAnySubquery in view works slower than if run without view
676322012-11-19
12:05
2020-11-12
14:54
MySQL Server: DMLNot a Bug
(2640 days)
S35.6.8, 5.7.0AnyAnyexplain select 1 from (select sleep(10) from dual) as t1; runs 10 seconds in 5.6
676872012-11-23
19:40
2012-11-25
19:19
MySQL Server: DMLClosed
(4546 days)
S35.5.15Windows (x64)AnySQL string literal incorrect handling
677322012-11-27
19:49
2019-11-11
9:44
MySQL Server: DMLClosed
(2004 days)
S25.5.8, 5.5.30, 5.7.1, 5.0.97, 5.1.67Windows (Vista)AnyWHERE var IS NOT TRUE yields too little
677912012-12-03
2:54
2016-08-05
3:18
MySQL Server: DMLClosed
(3669 days)
S25.5.25a, 5.1.67, 5.5.30, 5.6.8Linux (64-bit, w/InnoDB 1.1.8)AnyCreate View succeeds, but adds invalid parentheses
678002012-12-04
7:23
2018-02-13
23:02
MySQL Server: DMLCan't repeat
(2640 days)
S35.5.27-logWindowsAnyINSERT...SELECT WHERE clause "Incorrect integer value" with multi-col unique key
678212012-12-05
22:37
2013-01-07
1:00
MySQL Server: DMLNo Feedback
(4504 days)
S35.5.28Windows (7 Ultimate 64bit)AnyGROUP BY not working in stored procedure
678632012-12-10
16:24
2020-10-07
13:48
MySQL Server: DMLClosed
(1673 days)
S35.1, 5.5, 5.6AnyAnyINSERT INTO view_name () VALUES () fails with ER_WRONG_VALUE_COUNT_ON_ROW
680412013-01-06
3:29
2013-07-19
15:02
MySQL Server: DMLClosed
(4310 days)
S35.6.9AnyAnyZero date can be inserted in strict no-zero mode through a default value
681452013-01-22
17:15
2017-01-03
15:07
MySQL Server: DMLVerified
(4488 days)
S25.5.29, 5.0.97, 5.1.69, 5.5.31, 5.7.1AnyAnyGROUP_CONCAT with DISTINCT could return wrong result when rb-trees are on disk
681532013-01-23
11:40
2017-07-06
14:30
MySQL Server: DMLWon't fix
(2862 days)
S35.5.29, 5.0.97, 5.1.69, 5.5.31, 5.7.1LinuxAnyREGEXP does not seem to match the NUL character
682652013-02-05
1:55
2013-02-05
3:01
MySQL Server: DMLNot a Bug
(4474 days)
S35.6Linux (Ubuntu Linux 3.2.0-30-generic x86_64)AnyInconsistent behavior "INT NOT NULL" column inserting "NULL"
683102013-02-07
21:56
2013-02-08
10:12
MySQL Server: DMLNot a Bug
(4471 days)
S25.5.28Linux (ubuntu/debian 64bit)AnyUnexpected behaviour with variables in where clause
683392013-02-11
17:09
2013-02-11
20:06
MySQL Server: DMLVerified
(4468 days)
S35.1, 5.5, 5.6LinuxAnyENCRYPT() with empty string for password doesn't work as system crypt()
683602013-02-13
10:36
2013-02-15
18:02
MySQL Server: DMLVerified
(4464 days)
S35.5.28, 5.0.97, 5.1.69, 5.5.31, 5.7.0AnyAnyDuplicate entry for key while updating
684392013-02-20
2:35
2018-03-08
23:39
MySQL Server: DMLCan't repeat
(2617 days)
S25.1AnyAnyUnsigned INTs underflow in case of math
684462013-02-20
23:36
2013-02-22
14:56
MySQL Server: DMLClosed
(4457 days)
S35.5.29AnyAnyinsert on duplicate key update with null autoincremented PK uses wrong pk value
684542013-02-21
9:52
2013-03-04
15:30
MySQL Server: DMLClosed
(4447 days)
S15.6.11AnyAnyUsing inet6_ntoa and int6_aton to convert IP causes errors
685292013-02-28
20:43
2018-03-08
23:44
MySQL Server: DMLClosed
(2617 days)
S15.0/5.1/5.5Linux (gentoo/i686)AnyGROUP_CONCAT(.... ORDER BY ...) prevents ORDER BY if using a VIEW
687052013-03-18
15:36
2019-11-11
10:59
MySQL Server: DMLCan't repeat
(2004 days)
S35.5.30, 5.6.10, 5.6.12, 5.7.2, 5.1.70, 5.0.97, 5.5.32AnyAnyValgrind warnings (uninitialised value(s)) in Item_field::val on SELECT INTERVAL
687062013-03-18
18:51
2018-04-11
12:11
MySQL Server: DMLCan't repeat
(2583 days)
S35.6.10, 5.6.12, 5.7.2, 5.5.32, 5.1.70AnyAnyValgrind warnings (uninitialised value(s)) in hp_search with UNCOMPRESSED_LENGTH
687262013-03-20
11:22
2014-07-14
15:28
MySQL Server: DMLClosed
(3950 days)
S35.5.30 and 5.6.10, 5.1.70, 5.5.32, 5.6.12WindowsAnyUpdate trigger invoked when update ignore means that no update is performed
687622013-03-25
10:25
2013-03-25
11:20
MySQL Server: DMLDuplicate
(4426 days)
S25.6.10WindowsAnyGot error -1 from storage engine
688192013-03-30
15:44
2013-04-02
6:56
MySQL Server: DMLCan't repeat
(4418 days)
S35.0.77LinuxAnyDATE_FORMAT returns empty result
688462013-04-03
6:56
2013-04-03
7:35
MySQL Server: DMLDuplicate
(4417 days)
S3Mysql server 5.1AnyAnyhow to create Bad file in LOAD DATA INFILE in mysql
689342013-04-11
14:21
2013-04-11
20:21
MySQL Server: DMLVerified
(4409 days)
S35.6.10AnyAnyextractValue does not work correctly with xpath last()
689932013-04-18
6:51
2013-04-19
8:03
MySQL Server: DMLNot a Bug
(4401 days)
S35.5.15LinuxAnySET IN UPDATE TABLE
691382013-05-03
16:10
2013-07-01
16:39
MySQL Server: DMLClosed
(4328 days)
S55.7, 5.6AnyAnyWasted work in method Item_in_subselect::single_value_transformer
691442013-05-04
5:53
2013-05-04
10:55
MySQL Server: DMLDuplicate
(4386 days)
S25.6.11AnyAnysql_calc_found_rows, found_rows() in 5.6.11 differs from 5.6.10
691862013-05-09
15:47
2013-06-21
6:45
MySQL Server: DMLNot a Bug
(4338 days)
S55.6, 5.7AnyAnyWasted work in method test_rewind
692022013-05-11
16:40
2014-11-09
22:58
MySQL Server: DMLClosed
(3832 days)
S35.5, 5.6, 5.7AnyAnyValgrind warnings in inflate on UNCOMPRESS
692712013-05-17
16:14
2013-06-05
17:13
MySQL Server: DMLClosed
(4354 days)
S15.6.xAnyAnyWrong count from FOUND_ROWS() with ORDER BY
692732013-05-17
21:31
2013-06-21
1:00
MySQL Server: DMLNo Feedback
(4339 days)
S15.5.28-29.3-logLinux (by sitegrounds.com)AnySQL Server 2008 R2 DTS sends data to MySQL 5.5 "MySQL Server Gone Away"
692872013-05-20
13:54
2013-05-21
8:05
MySQL Server: DMLNot a Bug
(4369 days)
S35.0.96,5.5.x, 5.6.11Any (Tested on Mac OSX 10.8 and CentOS 5.x)AnySubtracting "NOW() - SOME_TIME" from "NOW()" returns wrong results
693102013-05-23
11:47
2018-03-14
20:45
MySQL Server: DMLVerified
(4367 days)
S35.6, 5.0.97, 5.1.70, 5.5.32, 5.6.12, 5.7.2AnyAnyValid SQL statement rejected in ONLY_FULL_GROUP_BY
693192013-05-25
18:08
2013-05-27
9:04
MySQL Server: DMLCan't repeat
(4363 days)
S25.6.11-embeddedWindowsAnySELECT with LEFT JOIN return 0 - records
693682013-05-31
20:36
2013-10-11
16:23
MySQL Server: DMLClosed
(4226 days)
S55.6.6AnyAnyperformance regression in 5.6.6+ for insert into .... select ... from
694312013-06-08
12:19
2014-08-15
16:09
MySQL Server: DMLVerifiedS35.6.12WindowsAnywrong ER_INSERT_INFO "Records: %ld Duplicates: %ld Warnings: %ld"
694702013-06-14
9:33
2013-06-14
13:08
MySQL Server: DMLDuplicate
(4345 days)
S35.6.10LinuxAnyUse "group by", but no aggregate function, get weird result
695212013-06-20
8:57
2013-06-26
21:32
MySQL Server: DMLDuplicate
(4333 days)
S25.6AnyAnyincorrect result of left join with additional condition
695902013-06-26
15:59
2018-03-14
20:53
MySQL Server: DMLClosed
(2611 days)
S35.5.32AnyAnyProblem using between with group by functions
696022013-06-27
13:05
2018-05-03
12:58
MySQL Server: DMLNot a Bug
(2561 days)
S35.6.12-communityAny (Ubuntu 12.04 x86_64)AnyPoor index optimization/selection using LEFT JOIN ( SELECT ) subquery
696472013-07-02
12:04
2018-04-12
14:27
MySQL Server: DMLClosed
(2582 days)
S35.6.10AnyAnyDO syntax turns error signal into a warning
696482013-07-02
16:04
2013-07-15
7:37
MySQL Server: DMLVerified
(4314 days)
S35.6.12AnyAnySubselect of literals in FROM throws "Duplicate column name" error
696702013-07-04
11:37
2013-07-05
1:04
MySQL Server: DMLVerified
(4324 days)
S15.5.31/5.5.32Linux (Debian )AnyDependent subquery with ORDER BY returns empty string
696842013-07-07
10:44
2014-06-02
14:33
MySQL Server: DMLClosed
(4005 days)
S25.5, 5.6AnyAnyThe update and select behave differently under the same conditions.
696852013-07-07
20:40
2018-03-14
21:07
MySQL Server: DMLClosed
(2611 days)
S35.5.31LinuxAnySTDDEV_SAMP() changes to STD() when used in a view
697052013-07-10
0:04
2013-07-10
13:08
MySQL Server: DMLVerified
(4319 days)
S35.6AnyAnyStrange fractional seconds
697742013-07-18
4:00
2018-05-05
14:44
MySQL Server: DMLClosed
(2559 days)
S35.1.71, 5.5.32AnyAnyDefining a view with case statement and having statement cause error1356
699162013-08-03
10:10
2015-01-13
14:39
MySQL Server: DMLVerified
(3767 days)
S35.5+AnyAnyCOT() does not behave as expected
701652013-08-27
14:58
2013-12-10
19:28
MySQL Server: DMLNot a Bug
(4166 days)
S2Ver 14.14 Distrib 5.6.12MacOSAnyCannot Perform Partial INSERT INTO View When SELECT Priv is Removed
702022013-08-30
15:36
2013-09-02
11:53
MySQL Server: DMLVerified
(4265 days)
S35.5, 5.6AnyAnyREPLACE working differently for a table having PK or UK only versus both PK+UK
704132013-09-25
7:07
2020-03-12
6:27
MySQL Server: DMLVerified
(4234 days)
S35.5.31, 5.5.34, 5.6.14Linux (Debian Wheezy v7.1)Any\d is not working in REGEXP for a MySQL query
704162013-09-25
10:49
2013-12-28
9:04
MySQL Server: DMLNot a Bug
(4148 days)
S35.6.14-logWindows (8)Anyconsistent bracket syntax with INSERT and DELETE
704442013-09-26
21:57
2013-12-02
13:57
MySQL Server: DMLVerified
(4174 days)
S35.5.31AnyAnyMyISAM engine doesnt use index for count(distinct field) query
704702013-09-30
15:24
2018-04-13
15:22
MySQL Server: DMLClosed
(2581 days)
S35.1.72,5.6.14,5.5.34,5.7.2AnyAnyREGEXP fails to find matches after NUL character
704722013-09-30
19:50
2013-10-01
11:33
MySQL Server: DMLVerified
(4236 days)
S35.5.32-0ubuntu0.12.04.1, 5.5.34, 5.6.14LinuxAnySQL_SAFE_UPDATES does not work properly with WHERE primary_key IN clauses
705282013-10-04
21:59
2019-11-12
21:40
MySQL Server: DMLClosed
(2003 days)
S35.5.31, 5.1.72,5.5.34,5.6.14,5.7.2-m12AnyAnyIncorrect truncation of SUBSTRING_INDEX's third argument
706222013-10-15
10:33
2014-03-04
16:07
MySQL Server: DMLClosed
(4082 days)
S3allAnyAnyerror result when use between...and againest bigint unsigned
706922013-10-23
3:46
2023-05-01
15:48
MySQL Server: DMLVerified
(4214 days)
S25.6.12,5.6.14,5.5.34,5.1.72LinuxAnyauto_increment wrong value when using insert into... select from
707402013-10-27
10:00
2013-10-30
6:40
MySQL Server: DMLVerified
(4209 days)
S35.6.14AnyAnyDon't lose microseconds without warning
709302013-11-16
15:51
2013-11-20
14:01
MySQL Server: DMLClosed
(4186 days)
S25.1+, 5.5+, 5.6.14, 5.7.2-m12AnyAnycount distinct get error result
710022013-11-25
13:44
2013-11-28
17:01
MySQL Server: DMLVerified
(4178 days)
S35.5.8-log, 5.6.16, 5.5.35, 5.1.71Windows (XP, Vista)AnyIFNULL of plain function parameter always latter argument
710282013-11-27
21:26
2014-02-02
17:38
MySQL Server: DMLClosed
(4131 days)
S35.5+AnyAnyerror result when "count + distinct + case when" need merge_walk
711082013-12-08
13:32
2019-12-12
19:04
MySQL Server: DMLVerified
(4167 days)
S35.6.15, 5.7.3-m13AnyAny'help procedures' command output not complete
711602013-12-17
11:11
2014-03-01
1:00
MySQL Server: DMLNo Feedback
(4086 days)
S35.1.69 AnyAnyconcat_ws causes case sensitivity issue
712442013-12-30
9:48
2014-03-29
8:31
MySQL Server: DMLClosed
(4082 days)
S25.6.15, 5.5.35, 5.1.72, 5.7.3AnyAnyWrong result computation using ALL() and GROUP BY
712572013-12-30
23:47
2014-02-02
1:00
MySQL Server: DMLNo Feedback
(4113 days)
S3AnyAnyKey Exception upon millionth insert
713222014-01-09
5:21
2019-11-12
22:40
MySQL Server: DMLNot a Bug
(2003 days)
S35.1.44-community, 5.1.73,5.5.35, 5.6.15, 5.7.3AnyAnyDATEDIFF Returns Erroneously In SELECT IF Query
713682014-01-14
2:09
2019-11-12
22:43
MySQL Server: DMLClosed
(2003 days)
S25.5.31, 5.5.34, 5.5.35, 5.6.15AnyAny-1 % 0.5 yields -0.0
713782014-01-14
18:03
2014-01-15
5:49
MySQL Server: DMLVerified
(4130 days)
S25.5.31,5.5.34, 5.5.35, 5.6.15AnyAnyFROM_DAYS(3652499) yields invalid unprintable date
714032014-01-17
0:46
2014-01-20
7:01
MySQL Server: DMLNot a Bug
(4125 days)
S35.6AnyAnyERROR 1167 (42000): The used storage engine can't index column on [VAR]CHAR(0)
714102014-01-17
16:44
2014-01-18
6:13
MySQL Server: DMLVerified
(4127 days)
S35.6, 5.6.15,5.5.35AnyAnyCOERCIBILITY(NULL) returns 6
714142014-01-17
20:41
2014-01-18
5:35
MySQL Server: DMLVerified
(4127 days)
S35.5.31, 5.5.35, 5.6.15, 5.1.73AnyAnyDATE_FORMAT('0000-00-00', '%U') overflows, gives '613566757'
714342014-01-20
21:24
2019-11-12
23:00
MySQL Server: DMLClosed
(2003 days)
S25.5.31, 5.5.35, 5.6.15, 5.1.73AnyAnyDECIMAL `0.1` evaluates to TRUE in project list, FALSE in where/having clauses
714922014-01-27
11:11
2014-01-28
15:12
MySQL Server: DMLNot a Bug
(4117 days)
S35.5.33Linux (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)AnyExpected ERROR 1104, none given with INSERT IGNORE
715312014-01-30
17:00
2014-03-01
1:00
MySQL Server: DMLNo Feedback
(4086 days)
S25.5.8Linux (Cent OS 6.4)AnySelect count(distinct(col)) from table returns zero
715622014-02-03
10:17
2014-02-03
11:39
MySQL Server: DMLVerified
(4111 days)
S3AnyAnyCAST should give warning for invalid date
716492014-02-10
9:50
2014-06-08
22:09
MySQL Server: DMLClosed
(3986 days)
S25.6.16Windows (Windows 7 64 bit)AnyExecuting multiple REPLACE statements causes connection to be lost
717262014-02-14
20:55
2019-11-18
22:17
MySQL Server: DMLCan't repeat
(1997 days)
S35.6.16AnyAny_my_hash_init_extra() doesn't set HASH::hash_function
717582014-02-18
13:09
2014-02-19
14:58
MySQL Server: DMLVerified
(4095 days)
S25.1.69AnyAnyconvert_tz does not work for datetime values > 2038-01-19 03:14:07
718272014-02-25
11:26
2015-12-09
18:39
MySQL Server: DMLClosed
(3437 days)
S35.5.35,5.0.96, 5.1.73, 5.5.38, 5.6.18, 5.7.5AnyAnyThe yearweek() function returns a wrong value
719812014-03-08
20:24
2014-03-13
11:15
MySQL Server: DMLVerified
(4073 days)
S35.6.16AnyAnyStrange result on explain
720272014-03-12
23:05
2018-12-17
19:18
MySQL Server: DMLClosed
(2333 days)
S35.6, *LinuxAnyLOAD_FILE() does not work on dynamic files
720322014-03-13
9:38
2019-11-19
7:55
MySQL Server: DMLClosed
(1996 days)
S5Server version: 5.0.67-community-nt MySQ, 5.5.38, 5.6.18Windows (Windows 7 日语版 SP1)Anyunion和order错误
720562014-03-17
10:19
2015-05-21
0:51
MySQL Server: DMLClosed
(3639 days)
S15.5/5.6LinuxAnyWrong comparsion on big DECIMAL values
720892014-03-20
20:30
2014-03-22
6:19
MySQL Server: DMLVerified
(4064 days)
S35.5.8, 5.5.31, 5.5.38AnyAnyFOUND_ROWS returns 0 or garbage when used in non-trivial queries
720982014-03-21
20:47
2019-11-18
22:37
MySQL Server: DMLClosed
(1997 days)
S35.5, 5.5.38AnyAnyselect * from (subquery) get different result with subquery.
721002014-03-21
22:09
2014-08-19
14:52
MySQL Server: DMLClosed
(3914 days)
S25.5.8, 5.5.31, 5.6.17, 5.5.37AnyAny0.00000000042 MOD 10 = 0.42000000000
721272014-03-25
19:16
2019-11-18
22:42
MySQL Server: DMLClosed
(1997 days)
S35.5.8, 5.5.31,5.6AnyAnyDIV with floats or doubles and unsigned integers sometimes errors out spuriously
722972014-04-09
20:25
2014-04-09
20:48
MySQL Server: DMLNot a Bug
(4046 days)
S25.1.73Windows (7/64)AnyColumn name ìd` causes problems in SELECT when quoted
723152014-04-11
6:06
2016-09-06
6:00
MySQL Server: DMLVerified
(4044 days)
S35.5/5.6AnyAnyALTER TABLE doesn't throw error while setting auto_increment value to the column
723642014-04-17
9:46
2019-11-18
22:53
MySQL Server: DMLClosed
(1997 days)
S35.5.37AnyAnyinsert ignore was not rollbacked after KILL QUERY
723672014-04-17
11:48
2014-04-17
13:03
MySQL Server: DMLNot a Bug
(4038 days)
S25.7.4AnyAnyDELAYED is documented as deprecated, but it is acutally non-functional
724462014-04-24
23:09
2014-05-20
11:48
MySQL Server: DMLClosed
(4005 days)
S25.6.17Linux (RHEL 6.5)AnyUnexpected trigger behavior in 5.6 : 1054 Unknown column '...' in 'NEW'
725952014-05-09
18:54
2014-05-10
9:24
MySQL Server: DMLClosed
(4015 days)
S25.6.17AnyAnyUnknown column
726732014-05-16
22:38
2014-06-02
11:29
MySQL Server: DMLDuplicate
(3992 days)
S25.5.31, 5.5.34AnyAnySUBSTRING_INDEX with negative index sometimes returns uninitialized memory
727022014-05-21
4:11
2014-05-21
7:53
MySQL Server: DMLVerified
(4004 days)
S25.5,5.6, 5.5.38, 5.6.17AnyAnyIS NULL optimization leads to wrong results when using HANDLER
727612014-05-27
10:00
2014-05-27
17:03
MySQL Server: DMLVerified
(3998 days)
S35.6.17AnyAnyMySQL 5.6 FROM_UNIXTIME function returns different result than 5.5
729812014-06-12
7:51
2014-06-13
11:58
MySQL Server: DMLVerifiedS35.1.73AnyAnycom_status wraps at 2^32
730282014-06-17
18:27
2019-11-19
22:07
MySQL Server: DMLClosed
(1996 days)
S25.6.19Linux (x86_64)AnyUnexpected result with nested CONCAT, SUBSTR, and REPLACE
732482014-07-09
19:51
2020-09-30
18:23
MySQL Server: DMLClosed
(1680 days)
S25.5.8, 5.5.31, 5.5.34, 5.6.20, 5.7.5AnyAnyMany, many classes of string-to-integer conversion bug
732832014-07-13
18:22
2019-11-19
22:22
MySQL Server: DMLClosed
(1996 days)
S35.6.17, 5.6.20, 5.7.4AnyAnyFOUND_ROWS() returns 0 on SELECT COUNT(*) of impossible where
733472014-07-21
17:00
2014-07-28
21:39
MySQL Server: DMLClosed
(3936 days)
S35.6.19-log MySQL Community Server (GPL)Linux (Red Hat Enterprise Linux Server release 6.4 (Santiago))AnyTIMESTAMP Initialization and the NULL Attribute
734102014-07-28
11:21
2014-07-29
15:35
MySQL Server: DMLVerified
(3936 days)
S35.5, 5.6, 5.7, 5.6.21AnyAnyUPDATE IGNORE fails on overflow
734142014-07-28
19:53
2014-07-30
4:23
MySQL Server: DMLNot a Bug
(3935 days)
S15.6.19 x64Any (Windows,Linux)AnySELECT UNION malforms result set - returns fewer rows
734362014-07-30
13:55
2015-09-06
12:02
MySQL Server: DMLVerified
(3933 days)
S35.5.38, 5.6.19, 5.6.21Linux (debian-linux-gnu (x86_64))Anyformat() with locale it_IT return wrong format
734392014-07-30
18:03
2014-08-11
4:13
MySQL Server: DMLNot a Bug
(3922 days)
S35.6.19, 5.6.21AnyAnyFORMAT dk_DK bug
734402014-07-30
18:17
2014-08-11
10:40
MySQL Server: DMLNot a Bug
(3922 days)
S35.6.19, 5.6.21AnyAnySouth Asian FORMATting is wrong
735432014-08-12
0:28
2014-09-30
16:26
MySQL Server: DMLClosed
(3872 days)
S25.5.8, 5.5.31, 5.5.34, 5.5.40AnyAnySUM(DISTINCT ...) incorrectly converts DATE, DATETIME, and TIMESTAMP to YEAR
735522014-08-12
18:56
2014-08-18
19:47
MySQL Server: DMLVerified
(3915 days)
S25.5.8, 5.5.31, 5.5.34,5.6.20AnyAny('string' = CAST(0 as TIME)) produces bogus error "Illegal mix of collations"
736122014-08-16
17:40
2019-04-08
13:56
MySQL Server: DMLNot a Bug
(2550 days)
S3allAnyAnySTR_TO_DATE format should allow wildcards
736542014-08-20
9:57
2022-12-30
5:09
MySQL Server: DMLVerified
(3344 days)
S35.6.20Linux (CentOS 6.3)AnyLOAD DATA LOCAL INFILE's behavior depends on whether with REPLACE or not
737432014-08-27
16:05
2014-08-28
8:40
MySQL Server: DMLDuplicate
(3905 days)
S35.6.19 5.5.36AnyAny"Explain tablename" increases Created_tmp_disk_tables
738192014-09-05
17:15
2019-11-19
23:59
MySQL Server: DMLCan't repeat
(1996 days)
S35.5, 5.5.40AnyAnyValgrind warnings " Syscall param write(buf) points to uninitialised byte(s)"
738402014-09-08
17:02
2015-04-30
4:55
MySQL Server: DMLVerified
(3894 days)
S35.5/5.6/5.7WindowsAnySYSTEM_TIME_ZONE is truncated at 29 characters
738692014-09-10
6:58
2014-11-13
20:17
MySQL Server: DMLVerified
(3828 days)
S25.6.20, 5.6.23AnyAny!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))
738962014-09-11
15:40
2015-02-02
22:06
MySQL Server: DMLVerified
(3747 days)
S35.5.40/5.6.23AnyAnyMySQL issues an "Unsafe statement" warning for what should be a safe statement
739462014-09-17
9:17
2014-09-25
8:46
MySQL Server: DMLVerified
(3885 days)
S15.5.39/5.6/5.7Windows (x64)AnyWrong result with agregate with join with no resultset
739602014-09-18
3:31
2019-02-05
14:00
MySQL Server: DMLNo Feedback
(3853 days)
S35.6WindowsAnySQL performance problem
739882014-09-20
20:26
2014-10-30
18:11
MySQL Server: DMLClosed
(3842 days)
S35.7.6AnyAnyfind_all_keys spams server error log with deadlock/lock wait errors
742602014-10-08
6:13
2017-08-14
7:07
MySQL Server: DMLVerified
(2823 days)
S35.6.20, 5.6.22, 5.7.19, 5.6.37Linux (CentOS 7)AnyAssertion `sort_field->length >= length' failed in sql/filesort.cc:1029
743542014-10-13
10:44
2021-03-12
6:06
MySQL Server: DMLVerified
(3859 days)
S25.7.5, 8.0.23, 5.7.33AnyAnyREPLACE INTO affected_rows wrong
743722014-10-14
11:38
2014-10-15
6:52
MySQL Server: DMLVerified
(3857 days)
S3Ver 14.14 Distrib 5.5.38, for debian-linLinux (3.13.0-37-generic #64-Ubuntu SMP Mon Sep 22 21:28:38 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux)AnySHOW CREATE TABLE shows not actual information
744482014-10-20
9:18
2014-10-24
8:10
MySQL Server: DMLVerified
(3852 days)
S35.6.20-debug, 5.6.22, 5.7.6Linux (CentOS 7)AnyAssertion `table_share->tmp_table != NO_TMP_TABLE || m_lock_type != 2' failed
745002014-10-22
9:56
2017-08-16
13:23
MySQL Server: DMLClosed
(3824 days)
S35.6.20-debugLinux (CentOS 7)AnyAssertion `src' failed in my_strnxfrm_unicode (sig 6 -strings/ctype-utf8.c:5151)
745042014-10-22
12:09
2014-10-22
12:34
MySQL Server: DMLVerified
(3850 days)
S35.6.20-debugLinux (CentOS 7)AnyAssertion `map->bitmap && map2->bitmap && map->n_bits==map2->n_bits' failed
745052014-10-22
12:22
2019-11-20
21:46
MySQL Server: DMLCan't repeat
(1995 days)
S35.6.20-debugLinux (CentOS 7)AnyAssertion tab->select->quick->index==(uint)best_key' in test_if_skip_sort_order
745372014-10-24
6:53
2014-10-24
11:19
MySQL Server: DMLVerified
(3848 days)
S35.6.20-debug, 5.6.22Linux (CentOS 7)AnyAssertion `lex.sphead == __null' failed in Table_triggers_list::check_n_load
746412014-10-31
1:31
2014-10-31
14:42
MySQL Server: DMLVerified
(3841 days)
S15.6.20, 5.6.21AnyAnymy_seek.c:57: my_seek: Assertion `fd != -1' failed. Table corruption on opt
746462014-10-31
9:51
2014-10-31
10:27
MySQL Server: DMLVerified
(3841 days)
S35.6.20-debug, 5.6.22, 5.7.6Linux (CentOS 7)AnyAssertion `((Item_result_field*)item)->result_field' failed in create_tmp_field
746502014-10-31
14:17
2019-11-20
21:49
MySQL Server: DMLCan't repeat
(1995 days)
S35.6.20-debugLinux (CentOS 7)AnyAssertion `inited == NONE' failed in handler::ha_close
746642014-11-03
7:03
2016-09-09
2:34
MySQL Server: DMLVerified
(3838 days)
S35.6.20-debug, 5.5.41, 5.6.22, 5.7.6Linux (CentOS 7)AnyAssertion: len <= col->len || col->mtype==5 || (col->len == 0 && col->mtype ==1)
746652014-11-03
8:41
2015-10-24
17:56
MySQL Server: DMLClosed
(3483 days)
S35.6.20-debug, 5.6.22Linux (CentOS 7)AnyAssertion `! thd->in_sub_stmt' failed in mysql_execute_command
746782014-11-04
8:28
2014-11-04
9:07
MySQL Server: DMLVerified
(3837 days)
S35.6.20-debug, 5.6.22, 5.7.6Linux (CentOS 7)AnyAssertion `host_length <= 60' failed in set_setup_actor_key
746952014-11-05
5:25
2017-08-14
1:50
MySQL Server: DMLClosed
(3629 days)
S35.6.20-debug, 5.6.22, 5.7.6Linux (CentOS 7)AnyAsser tion `args[0]->fixed' failed | sig 6 abort in sql/item_strfunc.h:882
747052014-11-06
2:53
2014-11-06
3:16
MySQL Server: DMLNot a Bug
(3835 days)
S35.6.17-logAnyAnyThe having results are not accurate
747162014-11-06
17:53
2015-07-01
10:34
MySQL Server: DMLClosed
(3598 days)
S3AnyAnyTime Zone Description Tables are severely outdated
747402014-11-07
18:10
2015-07-10
15:44
MySQL Server: DMLClosed
(3589 days)
S35.6.20-debug, 5.6.22, 5.7.6Linux (CentOS 7)Any Assertion `(*tables)->reginfo.lock_type >= TL_READ' failed in lock_external
747472014-11-08
7:20
2015-02-05
7:55
MySQL Server: DMLVerified
(3744 days)
S15.6.20, 5.6.22, 5.7.5AnyAnyFailing assertion: index->id == btr_page_get_index_id(page) btr0cur.cc line 899
747592014-11-10
7:29
2014-11-10
8:55
MySQL Server: DMLVerified
(3831 days)
S35.6.20-debugLinux (CentOS 7)AnyFailing assertion: lock_rec_get_first(receiver, receiver_heap_no) == __null
747772014-11-11
6:14
2019-11-20
21:58
MySQL Server: DMLCan't repeat
(1995 days)
S35.6.21-debug, 5.6.23, 5.7.6AnyAnyAssertion :bitmap_is_subset(&m_part_info->lock_partitions, &m_locked_partitions)
747792014-11-11
7:42
2016-07-29
10:37
MySQL Server: DMLVerified
(3830 days)
S35.6.20-debug, 5.6.23, 5.7.6Linux (CentOS 7)AnyAssertion :bitmap_is_s et(&m_part_info->read_partitions, m_part_spec.start_part)
747802014-11-11
9:15
2016-11-18
6:33
MySQL Server: DMLVerified
(3830 days)
S35.6.20-debug, 5.6.23, 5.7.6Linux (CentOS 7)AnyAssertion `tab->ref.use_count' failed in join_read_key_unlock_row
747972014-11-11
15:19
2021-09-14
11:06
MySQL Server: DMLVerified
(3830 days)
S35.6.21/5.7AnyAnycreate temporary table . select ..union.. select fails on read-only MySQL Server
748482014-11-14
2:43
2019-11-20
22:12
MySQL Server: DMLCan't repeat
(1995 days)
S35.6.21-debug, 5.6.23Linux (CentOS 7)Any!table || (!table->write_set || bitmap_is_set(table->write_set, field_index))
748562014-11-14
9:03
2019-11-25
21:23
MySQL Server: DMLCan't repeat
(1990 days)
S35.6.21-debug, 5.6.23, 5.7.6Linux (CentOS 7)Anyhandle_fatal_signal (sig=6) in get_parts_for_update | sql/sql_partition.cc:328
748892014-11-17
5:20
2019-11-25
21:39
MySQL Server: DMLCan't repeat
(1990 days)
S35.6.21Linux (CentOS 7)AnySig-6 abort in Item_in_subselect::exec | sql/item_subselect.cc:730
749462014-11-21
4:47
2014-11-23
9:19
MySQL Server: DMLVerified
(3820 days)
S35.6.20, 5.6.23, 5.7.6Linux (CentOS 7)AnyAssertion `nr >= 0.0' failed in virtual double Item_sum_std::val_real()
750682014-12-02
8:40
2015-04-06
19:03
MySQL Server: DMLClosed
(3729 days)
S35.1+AnyAnyLOAD DATA INFILE doesn't reset LEX::many_values
752102014-12-15
6:10
2016-01-13
9:24
MySQL Server: DMLNot a Bug
(3402 days)
S15.5, 5.6, 5.6.22, 5.7.9, 5.5.48, 5.6.29AnyAnyUsing rand() in UPSERT may result in wrong result
752272014-12-16
5:41
2019-11-25
21:48
MySQL Server: DMLWon't fix
(1990 days)
S35.6.21, 5.6.23Linux (CentOS 7)AnyAssertion `thd->killed != THD::KILL_BAD_DATA || error > 0' failed
752322014-12-16
9:11
2014-12-16
9:49
MySQL Server: DMLVerified
(3795 days)
S35.6.21, 5.6.23, 5.7.6Linux (CentOS 7)AnySig 6 abort in get_partition_id_range_for_endpoint | sql/sql_partition.cc:3600
752942014-12-23
3:32
2019-11-25
21:56
MySQL Server: DMLClosed
(1990 days)
S35.6.22, 5.6.23, 5.7.6AnyAnyLEAST() works incorrectly on MySQL 5.6 with expression using other functions
754362015-01-07
15:02
2020-01-31
13:33
MySQL Server: DMLClosed
(1923 days)
S25.5.41-logLinuxAnywrong results
754382015-01-07
18:21
2019-11-25
22:15
MySQL Server: DMLClosed
(1990 days)
S35.1.68, 5.6.20, 5.6.24AnyAnyREGEXP is case sensitive for most russian letters
754712015-01-09
17:29
2019-11-25
22:22
MySQL Server: DMLClosed
(1990 days)
S15.1/5.5/5.6/5.7AnyAnyViews that use hex literals fails
755392015-01-17
20:55
2015-05-12
16:57
MySQL Server: DMLClosed
(3648 days)
S25.6.21AnyAnymax_allowed_packet error destroys original data
756402015-01-27
4:50
2015-01-27
7:58
MySQL Server: DMLVerified
(3753 days)
S35.6.21-debug, 5.6.24Linux (CentOS 7)AnyFailing assertion: array->n_elems < array->max_elems in sync_thread_add_level
756482015-01-27
10:04
2015-01-27
11:12
MySQL Server: DMLVerified
(3753 days)
S35.6.21-debug, 5.6.24, 5.7.6Linux (CentOS 7)AnyAssertion `length <= max_data_length()' failed in Field_blob::store_to_mem
756902015-01-30
5:51
2017-08-14
0:32
MySQL Server: DMLCan't repeat
(2823 days)
S15.7.5-m15AnyAnyint handler::ha_index_read_map(...) Assertion`inited == INDEX' failed handler.cc
757362015-02-03
2:07
2015-04-24
12:40
MySQL Server: DMLClosed
(3666 days)
S15.7.5-m15, 5.7.6AnyAnyDEADLOCK of threads detected! 5.7.5, 1 thread SQL testcase, sporadic, in ib_logf
758072015-02-06
10:00
2015-02-20
9:54
MySQL Server: DMLVerified
(3731 days)
S55.6.22LinuxAnySlow Query in MySQL 5.6
758332015-02-10
6:45
2015-02-16
13:06
MySQL Server: DMLClosed
(3733 days)
S35.7.5-m15, 5.7.6AnyAnyInnoDB: Failing assertion: found in buf0buf.cc line 3856
759092015-02-15
20:16
2015-02-16
6:04
MySQL Server: DMLDuplicate
(3733 days)
S25.7.5-m15AnyAny[ERROR] Invalid (old?) table or database name
759112015-02-15
21:20
2019-11-25
22:32
MySQL Server: DMLClosed
(1990 days)
S15.7.5-m15AnyAny[ERROR] Got error 155 when reading table './test/t'
759292015-02-17
9:47
2015-02-17
13:59
MySQL Server: DMLDuplicate
(3732 days)
S15.6.23Windows (2k8, win7)AnyCritical bug with orders in select statements
759582015-02-18
18:21
2015-02-18
22:32
MySQL Server: DMLCan't repeat
(3731 days)
S15.7.5-m15AnyAnyhandle_fatal_signal (sig=11) in String::replace | INSERT into TEMPORARY table
759952015-02-22
11:01
2015-07-02
16:20
MySQL Server: DMLClosed
(3597 days)
S25.7.6-m16AnyAnymysqld --help --verbose tries to lock files
760402015-02-25
7:31
2018-04-20
23:33
MySQL Server: DMLVerified
(3722 days)
S35.6.23, 5.6.25Linux (CentOS 7)AnyAssertion `!flags.finalized' failed in sql/binlog.cc:1172
762292015-03-09
14:31
2018-11-30
3:25
MySQL Server: DMLClosed
(2350 days)
S25.6 and 5.7AnyAnySELECT DISTINCT WITH ROLLUP causes syntax error since 5.6
762442015-03-10
16:31
2018-07-26
1:00
MySQL Server: DMLNo Feedback
(2478 days)
S25.6.18, 5.1.73+AnyAnyMySQL does order of operations incorrectly on distinct numeric string
763072015-03-13
3:46
2015-03-13
6:23
MySQL Server: DMLVerified
(3708 days)
S35.6.23, 5.6.25, 5.7.7, 5.5.44Linux (CentOS 7)AnyAssertion `share->rows_recorded' failed in ha_tina::delete_row(const uchar*)
763552015-03-17
15:34
2015-03-17
16:33
MySQL Server: DMLVerified
(3704 days)
S35.6/5.7LinuxAnyFunction "addtime" returns wrong column type (regression).
763932015-03-19
17:41
2015-03-24
15:57
MySQL Server: DMLVerified
(3702 days)
S35.6.23AnyAnyUpdate query stores one value before evaluation equation for second
764362015-03-23
0:23
2016-06-18
21:25
MySQL Server: DMLClosed
(3696 days)
S15.7.6, 5.7.8, 8.0.0AnyAnyhandle_fatal_signal (sig=11) in st_select_lex::merge_derived
764522015-03-23
11:04
2016-06-18
21:25
MySQL Server: DMLCan't repeat
(3557 days)
S38.0.0AnyAnymemory leak with generated column containing LPAD function
764682015-03-24
0:06
2015-03-25
5:09
MySQL Server: DMLDuplicate
(3696 days)
S15.6.22, 5.5.44, 5.6.23, 5.6.25AnyAnyvoid Item_row::illegal_method_call(const char*): Assertion `0' failed.
764772015-03-24
23:54
2015-04-01
4:28
MySQL Server: DMLClosed
(3689 days)
S15.6.22, 5.6.23, 5.6.25AnyAnyAssertion `from->len == to->len' failed.
764782015-03-25
7:46
2015-03-26
2:59
MySQL Server: DMLVerified
(3695 days)
S35.6.22, 5.6.25, 5.5.44, 5.1.73LinuxAnymod functions works incorrectly with arithmetic express
765162015-03-28
10:07
2018-07-26
1:00
MySQL Server: DMLNo Feedback
(2478 days)
S15.5.41-0ubuntu0.14.04.1-logLinux (Ubuntu 14.04)Anytime interval arithmetic leads to exception on summer time change
765832015-04-03
3:26
2015-04-05
11:45
MySQL Server: DMLNot a Bug
(3685 days)
S25.6.23AnyAnyWrong columns in subquery , but doesn't throw exception
766052015-04-07
4:32
2018-06-09
1:00
MySQL Server: DMLNo Feedback
(2525 days)
S25.6.23 & 5.6.24Linux (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)Anyslow query with grant all on *.* to xxx
766142015-04-08
4:01
2019-11-25
22:54
MySQL Server: DMLWon't fix
(1990 days)
S35.6.23, 5.6.24, 5.6.25Linux (CentOS 7)AnyAssertion `!(mysql_bin_log.is_open()&&!thd.is_current_stmt_bi nlog_format_row())
767152015-04-15
17:08
2018-03-19
22:38
MySQL Server: DMLVerified
(2616 days)
S35.0, 5.1+AnyAnyDifferent behavior of LAST_INSERT_ID() function within a trigger AFTER INSERT
768272015-04-24
13:26
2015-06-26
10:02
MySQL Server: DMLVerified
(3603 days)
S15.6.24, 5.6.26Linux (CentOS 6.5)AnyAssertion failed while creating view after full disk error
768372015-04-26
3:56
2017-12-06
19:46
MySQL Server: DMLNot a Bug
(2709 days)
S3AnyAnyInconsistent JOIN evaluation order
768402015-04-26
19:46
2015-04-29
11:28
MySQL Server: DMLNot a Bug
(3661 days)
S15.6.21-logAnyAnyMySQL reports wrong information
768442015-04-27
5:50
2015-04-27
6:53
MySQL Server: DMLVerified
(3663 days)
S35.6.23, 5.6.25Linux (CentOS 7)Anyhandle_fatal_signal (sig=6) in trx_commit_low | trx/trx0trx.cc:1365
769252015-05-04
10:37
2015-05-04
11:20
MySQL Server: DMLVerified
(3656 days)
S35.6.23, 5.6.25Linux (CentOS 7)Anyhandle_fatal_signal (sig=11) in ha_innobase::store_key_val_for_row
769622015-05-07
5:52
2016-06-18
21:26
MySQL Server: DMLClosed
(3640 days)
S38.0.0AnyAny Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field
771082015-05-21
4:52
2015-05-21
6:38
MySQL Server: DMLVerified
(3639 days)
S35.6.23, 5.6.26Linux (CentOS 7)AnyInnoDB: Failing assertion: index == cursor->index in btr0sea.cc line 1782
771642015-05-27
5:10
2015-05-27
13:29
MySQL Server: DMLVerified
(3633 days)
S35.6.21, 5.6.26, 5.6.24Linux (CentOS 7)AnyAssertion : mtr_memo_contains(mtr, block, 2) == rw_lock_own(&block->lock, 351)
771942015-05-29
17:10
2015-06-19
12:58
MySQL Server: DMLDuplicate
(3610 days)
S35.6.23Linux (CentOS 7)AnyAssertion `param.sort_length != 0' failed in sql/filesort.cc:361
772222015-06-02
8:09
2015-06-03
10:49
MySQL Server: DMLNot a Bug
(3626 days)
S35.5.43LinuxAnyGROUP_CONCAT shows 1 result having all null values when no result can be found
772322015-06-02
20:38
2015-06-03
7:08
MySQL Server: DMLVerified
(3626 days)
S35.6.23, 5.6.24, 5.6.25AnyAnyMicrotime not supported for <1 second past epoch
772892015-06-10
2:49
2015-06-10
7:11
MySQL Server: DMLVerified
(3619 days)
S35.6.23, 5.6.25, 5.7.8Linux (CentOS 7)AnyInnoDB: Failing assertion: lock->index == index | lock0lock.cc line 5573
772992015-06-10
14:08
2019-11-26
21:12
MySQL Server: DMLCan't repeat
(1989 days)
S35.1, 5.5, 5.6, 5.7AnyAnyInconsistent behavior of PROCEDURE ANALYSE for 0 in Min_value
773002015-06-10
16:24
2017-06-08
9:52
MySQL Server: DMLNot a Bug
(2890 days)
S35.6.25AnyAnyRegexp match is too wide
773412015-06-13
2:14
2016-06-13
12:03
MySQL Server: DMLVerified
(3616 days)
S35.6.22, 5.6.26, 5.7.8, 5.5.45LinuxAny"between and" expr with datetime field and NULL value returns 0/1(not NULL)
773762015-06-17
2:38
2015-06-17
7:47
MySQL Server: DMLVerified
(3612 days)
S35.6.22, 5.6.25AnyAny" ('xxx' <=> null) is not known " returns 0
773822015-06-17
8:35
2019-11-26
21:28
MySQL Server: DMLClosed
(1989 days)
S35.5/5.6/5.7AnyAnyGet unexpected "ERROR 1267" for a normal select query
774282015-06-22
10:46
2015-06-22
12:00
MySQL Server: DMLNot a Bug
(3607 days)
S35.6.24LinuxAnyCONVERT_TZ fails between 'Europe/London' and UTC during BST
774802015-06-25
9:14
2015-11-02
16:32
MySQL Server: DMLClosed
(3474 days)
S35.7.7, 5.6.25AnyAnyWrong results for truncated column and aggregation
775212015-06-28
23:13
2016-06-18
21:26
MySQL Server: DMLClosed
(3529 days)
S15.7.7 RC, 5.7.8, 8.0.0AnyAnyInnoDB: Failing assertion: !trx_is_autocommit_non_locking(trx) in trx0trx.cc
775612015-06-30
9:28
2015-07-10
11:50
MySQL Server: DMLClosed
(3589 days)
S35.6.25AnyAnyA "CASE WHEN" expression with NULL and an unsigned type gives a signed result
775762015-07-01
10:33
2015-08-12
16:49
MySQL Server: DMLClosed
(3556 days)
S3AnyAnyTime Zone Description Tables are outdated
775802015-07-01
11:45
2015-07-02
16:14
MySQL Server: DMLClosed
(3597 days)
S35.6.23, 5.6.27CentOS (CentOS 7)Any Assertion `t1->result_range' failed in sql/gcalc_tools.cc:731
776312015-07-06
19:00
2015-07-20
14:49
MySQL Server: DMLClosed
(3579 days)
S25.7LinuxAnyfilter using trim results in correct
776322015-07-06
19:07
2015-08-26
13:29
MySQL Server: DMLClosed
(3542 days)
S25.7.7LinuxAnycount distinct returns in-correct result
776342015-07-06
23:46
2015-10-15
14:07
MySQL Server: DMLClosed
(3492 days)
S25.5.45, 5.6.25, 5.7.7AnyAnyreturned value overflows decimal data type
777152015-07-14
9:03
2018-05-21
6:40
MySQL Server: DMLVerified
(2543 days)
S35.6.24AnyAnytable_open_cache_instances Does not Really Split table_open_cache
778052015-07-23
2:01
2015-07-23
5:01
MySQL Server: DMLVerified
(3576 days)
S15.6.25 MySQL Community Server (GPL)Ubuntu (Ubuntu 14.04.2 LTS x86_64)AnyNULLIF cause wrong value with cast datetime
778092015-07-23
6:14
2018-06-25
21:18
MySQL Server: DMLCan't repeat
(2508 days)
S15.7.7-rcCentOS (7)Any#08S01 Bad handshake with MySQL 5.7.7-rc-debug-valgrind
778742015-07-29
15:41
2018-03-06
17:13
MySQL Server: DMLNot a Bug
(2619 days)
S35.5.28-0Ubuntu (Ubuntu 0.12.04.2)AnyORDER BY MAX() Returns a row with empty value when no rows exist
779372015-08-04
21:07
2018-01-01
1:00
MySQL Server: DMLNo Feedback
(2685 days)
S55.6.25AnyAnyTable lock problem while adding new foreign key constraints
779382015-08-04
22:13
2015-08-10
11:19
MySQL Server: DMLVerified
(3558 days)
S35.6.24, 5.6.26, 5.7.9, 5.5.46CentOSAnyIncorrect results returned with like operator and escape characters strings
779942015-08-08
10:09
2019-11-26
21:35
MySQL Server: DMLClosed
(1989 days)
S35.6.22, 5.5.46, 5.6.26, 5.7.9AnyAnyfunction relace('xxx','yyy', c1) returns 'xxx' when column c1 is null
780052015-08-10
7:16
2019-11-26
21:40
MySQL Server: DMLDuplicate
(1989 days)
S35.6.22, 5.6.26, 5.7.9AnyAnyreplace('xxx','',b) when column b is NULL returns 'xxx'
780092015-08-10
11:25
2015-08-10
14:47
MySQL Server: DMLNot a Bug
(3558 days)
S35.6.22AnyAnyInconsistent behaviors when column alias name(s) and column name are the same
780402015-08-12
11:16
2018-11-23
9:25
MySQL Server: DMLNot a Bug
(2357 days)
S3mysqld Ver 5.6.23-ndb-7.4.4-cluster-comOracle Linux (Oracle Linux Server release 6.3)AnyUPDATE is changing incorrect field
781272015-08-18
12:16
2019-11-26
21:50
MySQL Server: DMLClosed
(1989 days)
S35.6.22, 5.5.46, 5.6.26AnyAnyIn consistent behavior between similar UPDATE sqls, error vs warning
781492015-08-20
11:02
2015-08-21
6:25
MySQL Server: DMLVerified
(3548 days)
S35.0/5.1/5.5/5.6/5.7UbuntuAnyTIMESTAMPDIFF vs TIMESTAMPADD and DATE_ADD : count months in different way
781762015-08-23
13:36
2018-05-18
1:00
MySQL Server: DMLNo Feedback
(2547 days)
S25.6.20DebianAny5.6.20 is almost twice as slow as 5.0.96
781812015-08-24
6:59
2015-08-24
9:23
MySQL Server: DMLVerified
(3544 days)
S25.6.21, 5.6.26, 5.7.9AnyAnyGroup by different behavior in mysql 5.6.21
781832015-08-24
9:01
2015-09-01
8:37
MySQL Server: DMLNot a Bug
(3536 days)
S35.6.22AnyAnySimilar query with aggregate functions returns inconsistent result
782032015-08-25
9:16
2015-08-26
15:33
MySQL Server: DMLNot a Bug
(3542 days)
S35.6.22AnyAnyInconsistent behaviors when auto_increment_offset is ignored(>auto..._increment)
782532015-08-28
8:35
2015-09-01
6:35
MySQL Server: DMLNot a Bug
(3536 days)
S54.2.11AnyAnyA major problem is found in insert query of my sql which need attention
782922015-08-31
16:48
2015-11-13
13:48
MySQL Server: DMLClosed
(3463 days)
S35.6.22CentOS (CentOS 7)AnyAssertion `pfs->m_processlist_id != 0' failed in table_session_connect.cc:254
783302015-09-05
0:12
2015-09-05
6:34
MySQL Server: DMLDuplicate
(3532 days)
S15.6.23AnyAnyhandle_fatal_signal (sig=6) in Item_row::illegal_method_call on SELECT
783492015-09-06
12:12
2015-12-03
14:22
MySQL Server: DMLClosed
(3443 days)
S35.6.22, 5.6.26AnyAnyw/ ONLY_FULL_GROUP_BY, having/order by + column alias have different results
783602015-09-08
6:14
2015-09-08
12:29
MySQL Server: DMLVerified
(3529 days)
S35.6.22, 5.6.26AnyAnyMore than 1 row is returned when using "having count(alias)"
783612015-09-08
7:08
2015-10-24
18:08
MySQL Server: DMLClosed
(3483 days)
S35.6.22, 5.6.26AnyAnyColumn alias can be used in subquery in select list in the same query
784152015-09-12
6:17
2015-09-12
9:50
MySQL Server: DMLVerified
(3525 days)
S35.6.22, 5.6.26, 5.7.9AnyAnyEquivalent SQL like "select cast( varchar as decimal)" returns different results
784182015-09-12
12:34
2015-09-13
19:59
MySQL Server: DMLNot a Bug
(3524 days)
S35.6.22AnyAnyInserted data in "col float" is truncated to 6 digits in "select * from t1"
784242015-09-14
2:29
2015-09-14
10:50
MySQL Server: DMLCan't repeat
(3523 days)
S35.7.7AnyAnyw/ c1&&c2 appears in select list, group by clause and order by clause, SQL fails
784502015-09-16
9:59
2015-09-18
10:31
MySQL Server: DMLNot a Bug
(3519 days)
S35.6.22AnyAnyInvalid column name is not detected in select list, but detected as unknown
784702015-09-17
12:20
2015-09-18
10:52
MySQL Server: DMLNot a Bug
(3519 days)
S35.6.22AnyAnyWhen dates are provided as inputs for period_diff, result is not understandable
784862015-09-19
18:52
2015-10-30
12:34
MySQL Server: DMLNot a Bug
(3477 days)
S25.6.26-1debian7, amd64, 5.7.9Debian (wheezy, uptodate)Anyto_base64() insert an extra '\n' char
784972015-09-21
8:44
2015-09-21
9:11
MySQL Server: DMLVerified
(3516 days)
S35.6, 5.6.26, 5.6.28, 5.7.10UbuntuAnyLarge select with nested subqueries return 0 rows
785082015-09-22
3:20
2015-09-22
12:19
MySQL Server: DMLNot a Bug
(3515 days)
S35.6.22AnyAnySubquery result with aggregate function() in outer table is not understandable
785342015-09-23
17:29
2015-09-23
20:44
MySQL Server: DMLCan't repeat
(3514 days)
S3AnyAnyDifferent results are coming when ran a same Query in two different applications
785362015-09-24
6:50
2018-05-08
13:11
MySQL Server: DMLNot a Bug
(2556 days)
S25.6.22, 5.7.8AnyAnygroup_concat returns incorrect result
785982015-09-28
8:28
2015-11-16
1:00
MySQL Server: DMLNo Feedback
(3461 days)
S35.6AnyAnyUpdate results in wrong nr of columns updated (null = null)
786592015-10-01
8:34
2019-11-26
22:51
MySQL Server: DMLClosed
(1989 days)
S35.6 for Windows,5.1.77, 5.5.47, 5.6.28,5.7.10WindowsAnyStddev_Samp function calculates wrongly when used within Views
786712015-10-01
13:41
2015-10-06
11:57
MySQL Server: DMLVerified
(3506 days)
S35.7.8AnyAnytoo big value into BIGINT SIGNED column gives no warning if value is from column
787042015-10-05
13:29
2016-02-04
18:54
MySQL Server: DMLClosed
(3453 days)
S35.5AnyAnyThe Item::rsize variable is unused
788212015-10-13
15:28
2015-10-15
8:13
MySQL Server: DMLVerified
(3492 days)
S25.7.8, 5.7.10, 5.6.27, 5.5.47AnyAnyWhen comparing bigint and varchar constant, inconsistent results are returned
788322015-10-14
12:20
2019-11-26
23:02
MySQL Server: DMLClosed
(1989 days)
S35.5.44-0+deb7u1-log (Debian)Debian (3.2.0-4-amd64 #1 SMP Debian 3.2.68-1+deb7u2 x86_64 GNU/Linux)Anywrong result using BETWEEN with dates and NULL
788532015-10-16
1:17
2016-02-11
16:21
MySQL Server: DMLClosed
(3373 days)
S35.6.27, 5.5.47, 5.1.77Red Hat (Red Hat Enterprise Linux Server release 6.2 (Santiago))AnyINSERT IGNORE fails to ignore foreign key constraint
789342015-10-23
4:14
2015-10-26
13:37
MySQL Server: DMLNot a Bug
(3481 days)
S35.7.8AnyAnyFailed INSERT(Dup entry) still change LAST_INSERT_ID() for auto_increment col
789582015-10-26
2:37
2019-11-27
22:13
MySQL Server: DMLClosed
(1988 days)
S35.7.8, 5.6.27, 5.7.10AnyAnyNULL=ANY( subquery ) returns 0
790012015-10-28
12:36
2020-01-31
13:33
MySQL Server: DMLClosed
(1923 days)
S35.0/5.1/5.5/5.6UbuntuAnyWrong sort order with CONCAT and CASE-based sort column
790152015-10-29
9:03
2015-11-02
9:18
MySQL Server: DMLVerified
(3478 days)
S35.7.8, 5.6.27, 5.6.28, 5.7.9AnyAnyWhen function DATEDIFF and NULLIF work together, incorrect result is returned
791102015-11-04
4:17
2015-11-04
7:23
MySQL Server: DMLVerified
(3472 days)
S35.7.8,5.1.77,5.5.47,5.6.27,5.7.9AnyAnyWhen casting a BIG number to unsigned, get inconsistent result for same number
791112015-11-04
5:57
2015-11-04
6:41
MySQL Server: DMLVerified
(3472 days)
S35.7.8, 5.6.27, 5.7.9AnyAnyw/ DATE_FORMAT, NULLIF works together, incorrect result is returned
791122015-11-04
6:43
2015-11-04
6:55
MySQL Server: DMLVerified
(3472 days)
S35.7.8, 5.6.27, 5.7.9AnyAnyw/ EXTRACT and NULLIF working together, get unexpected warnings
791142015-11-04
7:53
2015-11-18
18:24
MySQL Server: DMLClosed
(3458 days)
S35.7.8, 5.7.9AnyAnyIF(bool, date str, date str) throws ERROR in UPDATE
791162015-11-04
8:56
2015-11-04
13:34
MySQL Server: DMLNot a Bug
(3472 days)
S35.7.8,5.6.24,5.5.43,5.1.73AnyAnyIFNULL returns expr1 with appending decimals when expr2 is w/ decimal
791312015-11-05
5:34
2015-11-17
16:03
MySQL Server: DMLClosed
(3459 days)
S35.7.8, 5.7.9AnyAnyGet negative FOUND_ROWS() for UNION stmt
792262015-11-11
10:08
2015-11-11
15:12
MySQL Server: DMLNot a Bug
(3465 days)
S35.6.21UbuntuAnyOrder by in where clause doesn't cause error
792432015-11-12
0:56
2019-03-26
19:29
MySQL Server: DMLDuplicate
(2771 days)
S25.7.9Windows (10 x64)Any0xc0000005
792462015-11-12
9:15
2019-11-27
22:43
MySQL Server: DMLClosed
(1988 days)
S35.0/5.1/5.5/5.6/5.7AnyAny"select null=ANY(non-empty subquery)" returns 0
792592015-11-13
3:47
2019-11-04
18:33
MySQL Server: DMLNot a Bug
(2011 days)
S35.7.8AnyAnyGet inconsistent result for invalid date in column and const,compared w/ date
792602015-11-13
7:33
2019-11-28
21:41
MySQL Server: DMLClosed
(1987 days)
S35.7.8/5.6AnyAnyGet "ERROR 1271: Illegal mix of collations" when comparing time and string
792612015-11-13
7:37
2015-11-25
9:34
MySQL Server: DMLNot a Bug
(3451 days)
S35.7.8AnyAnytime compared with varchar, got different result for value in col or const
792662015-11-13
10:54
2016-02-01
17:30
MySQL Server: DMLClosed
(3428 days)
S35.7.9Ubuntu (14.04 LTS)AnyAdding a trigger to a table changes the behaviour of null detection
792862015-11-16
3:34
2015-11-16
15:27
MySQL Server: DMLVerified
(3460 days)
S35.0/5.1/5.5/5.6/5.7AnyAnyUnexpected ERROR 1093 of delete w/ subquery in from stmt
792922015-11-16
9:48
2015-11-19
22:03
MySQL Server: DMLVerified
(3457 days)
S35.0/5.1/5.5/5.6/5.7AnyAnycast('-123.9' as signed) returns -123, not expected -124
793092015-11-17
10:12
2015-11-18
2:02
MySQL Server: DMLClosed
(3458 days)
S15.7.8.rcWindowsAnyinsert statement puts the value "testing" in place of text string
793332015-11-19
5:16
2015-12-07
18:30
MySQL Server: DMLClosed
(3439 days)
S35.7.9AnyAnyUnexpected error 1093 on nested subquery for update
793532015-11-20
10:02
2015-11-20
10:46
MySQL Server: DMLVerified
(3456 days)
S25.7.8, 5.6.29, 5.7.9AnyAnyIN operator works incorrectly with collate
793982015-11-24
16:37
2015-12-09
15:03
MySQL Server: DMLClosed
(3437 days)
S35.7.11,5.6.28,5.5.44AnyAnyview using hexadecimal or bit literal gives wrong results
794002015-11-24
20:15
2018-12-17
13:29
MySQL Server: DMLNot a Bug
(2333 days)
S314.14 Distrib 5.6.27AnyAnyUncompress function could be much better
794092015-11-25
10:45
2015-11-30
8:11
MySQL Server: DMLVerified
(3446 days)
S35.7.8, 5.7.9, 5.5.48, 5.6.29AnyAnycompare type for datetime column and varchar column is inconsistent with doc
794102015-11-25
13:13
2015-11-25
14:50
MySQL Server: DMLClosed
(3451 days)
S35.7.8AnyAny"coalesce(0, 1.2345)" is not returning 0.0000 with aggregate func in select list
794702015-12-01
8:26
2019-11-28
22:24
MySQL Server: DMLClosed
(1987 days)
S35.7.8, 5.7.9, 5.6.29, 5.5.48AnyAnyw/ Collate = utf8_bin, replace('xxx','yyy',c1(NULL)) gives 'xxx'
795052015-12-03
10:57
2015-12-03
12:09
MySQL Server: DMLVerified
(3443 days)
S35.7.8, 5.5.48, 5.6.29, 5.7.9AnyAny"if(1,1,1.234)" return 1 while the "Decimals" is 3
795072015-12-03
12:55
2019-11-28
22:34
MySQL Server: DMLClosed
(1987 days)
S35.6.22, 5.5.48AnyAnyString function insert is not working as doc says
795182015-12-04
7:42
2015-12-07
7:01
MySQL Server: DMLVerified
(3439 days)
S35.7.8, 5.5.48, 5.6.29, 5.7.11 AnyAnyGet inconsistent string when converting year column to char
795192015-12-04
9:22
2015-12-07
4:25
MySQL Server: DMLVerified
(3439 days)
S35.7.8, 5.6.29, 5.7.11AnyAnyMaximum display width for select list is different for 'utf8' and 'utf8mb4'
795272015-12-04
12:58
2017-08-08
19:08
MySQL Server: DMLVerified
(2829 days)
S35.6.27AnyAnyErrorcode 175: abort in group by on big tables
795302015-12-04
17:59
2015-12-09
3:04
MySQL Server: DMLVerified
(3442 days)
S35.5 5.6 5.7WindowsAnyPower() Function unexpected results when multiplied by decimal
795402015-12-07
6:53
2016-01-11
1:57
MySQL Server: DMLClosed
(3404 days)
S15.7.9CentOS (5.6)AnyGenerated Column Issue
795492015-12-07
21:14
2016-01-16
15:15
MySQL Server: DMLClosed
(3399 days)
S35.7.9AnyAnyRegression: “unknown column” for outer computed values used inside a subquery
795512015-12-08
3:55
2015-12-17
15:38
MySQL Server: DMLNot a Bug
(3429 days)
S35.7.8AnyAny"select * from (select * from u1 ) u2 for update" is not locking rows in u1
795652015-12-09
7:11
2015-12-09
8:34
MySQL Server: DMLVerified
(3437 days)
S35.7.8,5.5.48, 5.6.29, 5.7.9AnyAnyFunction insert work incorrectly with multiple-type utf8 character
795672015-12-09
7:41
2019-11-28
22:55
MySQL Server: DMLClosed
(1987 days)
S35.7.8, 5.5.48, 5.6.29, 5.7.9AnyAnyOutput scale for IFNULL() with join is not correct
795712015-12-09
10:02
2019-12-02
22:09
MySQL Server: DMLClosed
(1983 days)
S25.0/5.1/5.5/5.6/5.7AnyAny"select distinct" are returning incorrect values
795762015-12-09
14:30
2015-12-14
8:55
MySQL Server: DMLNot a Bug
(3432 days)
S35.6AnyAnyEquivalent subqueries returns different results
795872015-12-10
7:40
2019-12-02
22:14
MySQL Server: DMLClosed
(1983 days)
S35.7.8, 5.7.9, 5.6.27, 5.5.48AnyAny"UNIX_TIMESTAMP(count(a))" is expected to return 0, not NULL
795882015-12-10
8:19
2015-12-10
9:36
MySQL Server: DMLVerified
(3436 days)
S35.0/5.1/5.5/5.6/5.7AnyAny"select database()" can return database name which was deleted in other session
795892015-12-10
8:51
2019-12-02
22:21
MySQL Server: DMLClosed
(1983 days)
S35.7.8, 5.7.10, 5.6.29AnyAnyFLOOR(bigint column expr) return different result type (NEWDECIMAL/LONGLONG)
795902015-12-10
9:33
2016-01-06
16:56
MySQL Server: DMLClosed
(3409 days)
S25.7.9MacOSAnyERROR 1093 (HY000): You can't specify target table '.' for update in FROM clause
795942015-12-10
14:19
2015-12-11
10:15
MySQL Server: DMLVerified
(3436 days)
S35.6/5.7UbuntuAnySmall bug in INET6_NTOA() function
796242015-12-14
2:52
2018-06-25
11:17
MySQL Server: DMLVerified
(2508 days)
S35.5/5.6/5.7/8.0AnyAny"alter column c1 set default current_stamp" is not working
796562015-12-16
4:00
2015-12-16
7:59
MySQL Server: DMLVerified
(3430 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyAny"'2' + 0.0, group_concat('2') + 0.0" are returning different result
796572015-12-16
4:10
2019-12-02
22:37
MySQL Server: DMLClosed
(1983 days)
S35.7.8, 5.7.10, 5.6.28AnyAnyBigint unsigned column value in CASE WHEN operator is converted to bigint signed
796832015-12-16
23:10
2016-10-13
7:14
MySQL Server: DMLVerified
(3430 days)
S3AnyAnyFew improvements related to CPU cache line size and padding (contribution)
796902015-12-17
12:54
2015-12-17
19:33
MySQL Server: DMLNot a Bug
(3429 days)
S35.7.8AnyAnyInsert -0.1 and string '-0.1' into unsigned int returns different result
796952015-12-18
4:25
2016-01-16
15:55
MySQL Server: DMLClosed
(3399 days)
S25.7.8, 5.6.28, 5.7.10AnyAnyTrue where clause doesn't return expected row, but empty set
797532015-12-23
8:47
2015-12-24
15:20
MySQL Server: DMLNot a Bug
(3422 days)
S35.7.8AnyAnyIn SET stmt, different set operations are not executed sequentially
797922015-12-29
3:12
2019-12-02
22:41
MySQL Server: DMLClosed
(1983 days)
S35.0/5.1/5.5/5.6/5.7AnyAnyNULL value is inserted explicitly into NOT NULL column unexpected
798042015-12-29
12:36
2015-12-30
16:54
MySQL Server: DMLNot a Bug
(3416 days)
S35.7.8AnyAnyInconsistent results when inserting 0.1 into datetime(6) and timestamp(6)
798102015-12-30
10:03
2015-12-30
13:42
MySQL Server: DMLVerified
(3416 days)
S35..1/5.5/5.6/57AnyAnyExtreme big number with IN operator gives in consistent result
798302016-01-04
9:42
2016-01-04
12:08
MySQL Server: DMLVerified
(3411 days)
S15.7.8, 5.5.48, 5.6.28, 5.7.10AnyAnyIN operator works incorrectly with NULL
798482016-01-05
12:20
2019-12-09
20:31
MySQL Server: DMLClosed
(1976 days)
S35.7.8, 5.6.28, 5.7.10AnyAnyComparison of datetime string to time fails with ERROR 1267
798492016-01-05
13:08
2016-02-08
10:09
MySQL Server: DMLVerified
(3376 days)
S25.6.23, 5.6.28, 5.7.10CentOSAnySTR_TO_DATE function not working for numeric month (0...12)
798572016-01-06
2:41
2016-01-19
17:31
MySQL Server: DMLClosed
(3396 days)
S25.7.8, 5.7.10AnyAnyselect cast(100 as unsigned) between 1 and -1 returns true
798732016-01-07
14:11
2016-10-03
18:11
MySQL Server: DMLClosed
(3138 days)
S35.7.10MacOS (10.11.2)AnyDROP TRIGGER after RENAME TABLE results in Error Code 1146: table doesn't exist.
798782016-01-08
6:58
2020-10-07
16:24
MySQL Server: DMLClosed
(1673 days)
S25.7.8, 5.6.28, 5.7.10AnyAny"-1 BETWEEN 9223372036854775808 AND 1" gives True
798842016-01-08
9:33
2019-12-09
21:02
MySQL Server: DMLClosed
(1976 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyAny"SUBSTRING_INDEX( 'a', 'b', 6192449487634432 )" returns '',not expected 'a'
798902016-01-08
12:10
2016-01-08
14:42
MySQL Server: DMLNot a Bug
(3407 days)
S35.7.8AnyAnyFunction GREATEST(bigint, date) is not working as expected
798912016-01-08
12:44
2016-01-08
14:40
MySQL Server: DMLVerified
(3407 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyAny"case when" and IF() are not returning result with general precision
799022016-01-09
15:46
2016-01-19
17:23
MySQL Server: DMLClosed
(3396 days)
S25.7.8, 5.5.48, 5.6.28, 5.7.10AnyAnyFunction GREATEST and LEAST works incorrectly with bigint unsigned value
799062016-01-11
3:55
2016-01-13
9:21
MySQL Server: DMLVerified
(3402 days)
S35.7.8, 5.6.28, 5.7.10, 5.5.48AnyAnyImplicit and Explicit convert from bigint unsigned to signed give different val
799082016-01-11
4:47
2019-12-09
21:21
MySQL Server: DMLClosed
(1976 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyAnydate comparison has inconsistent behavior between = and CASE WHEN
799092016-01-11
6:23
2020-10-05
12:18
MySQL Server: DMLClosed
(1675 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyAnyGet mess code for func INSERT() with str as int const and newstr as multi-byte
799102016-01-11
6:41
2021-02-17
12:00
MySQL Server: DMLClosed
(1540 days)
S35.7.8, 5.6.28, 5.7.10AnyAnyNULLIF fails with ERROR 1271 with date and multi-type character
799112016-01-11
6:52
2019-12-09
21:44
MySQL Server: DMLClosed
(1976 days)
S35.7.8, 5.6.28, 5.7.10AnyAnyGet ERROR 1267 with string LIKE date
799122016-01-11
7:10
2016-01-20
16:51
MySQL Server: DMLClosed
(3395 days)
S35.7.8,5.5.48, 5.6.28, 5.7.10AnyAnyFunction REPLACE with binary op doesn't return expected NULL, with param as NULL
799132016-01-11
7:45
2019-12-09
21:49
MySQL Server: DMLClosed
(1976 days)
S35.7.8, 5.7.10AnyAnyFunction FOUND_ROW() works incorrectly with previous select w/ aggr ret NULL
799152016-01-11
8:18
2016-01-11
9:34
MySQL Server: DMLVerified
(3404 days)
S35.7.8, 5.6.28, 5.7.10AnyAnyFunction NULLIF + CAST is not working as expected
799162016-01-11
9:34
2016-01-15
4:25
MySQL Server: DMLVerified
(3400 days)
S35.7.8, 5.6.28, 5.7.10AnyAnyComparison gives inconsistent result for time(1) column and explicit cast result
799172016-01-11
12:41
2016-01-13
8:10
MySQL Server: DMLVerified
(3402 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyAnyFunc COALESCE( date, timestamp) and datetime are not working consistently
799192016-01-11
19:02
2016-01-12
9:13
MySQL Server: DMLCan't repeat
(3403 days)
S25.6WindowsAnyLOAD XML inheritance can fail when loading multiple tables
799232016-01-12
3:22
2016-01-12
7:20
MySQL Server: DMLDuplicate
(3403 days)
S25.7.8, 5.6.28, 5.7.10AnyAnyAggr function, UPPER() and REPEAT() give incorrect output
799242016-01-12
6:38
2016-01-21
23:04
MySQL Server: DMLClosed
(3394 days)
S25.7.8, 5.5.48, 5.6.28, 5.7.10AnyAnyFunc CONVERT and CONVERT(,BINARY) works incorrect w/ multi-byte+multi-rows
799252016-01-12
8:07
2023-04-10
2:40
MySQL Server: DMLVerified
(3403 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyAnyString const '69E5' is not treated as scientific notation when casting to int
799262016-01-12
8:26
2016-01-19
3:41
MySQL Server: DMLNot a Bug
(3396 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyAnyFunc IFNULL truncate unsigned param to signed range
799282016-01-12
9:03
2016-01-19
3:41
MySQL Server: DMLNot a Bug
(3396 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyAnyFunc COALEASE truncates unsigned param to signed
799292016-01-12
9:08
2019-12-09
21:55
MySQL Server: DMLClosed
(1976 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyAnyFunc CASE WHEN truncates unsigned value to signed
799302016-01-12
9:11
2019-12-09
21:57
MySQL Server: DMLClosed
(1976 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyAnyFunc IF() truncates unsigned value to signed
799362016-01-12
15:34
2016-01-13
7:20
MySQL Server: DMLVerified
(3402 days)
S35.7.8, 5.6.28, 5.7.10AnyAny"c1(NULL) > 1 && c2('00:00:00.0') = '00:00:00.000001'" returns NULL, not 0
799372016-01-12
15:42
2016-01-13
12:15
MySQL Server: DMLNot a Bug
(3402 days)
S35.6.27AnyAnyIncorrect record updated using ON DUPLICATE KEY UPDATE processing
799472016-01-13
7:43
2016-01-13
9:44
MySQL Server: DMLDuplicate
(3402 days)
S35.7.8, 5.5.48, 5.6.28AnyAnyFunc ROUND(num, c1(NULL)) doesn't return NULL
799492016-01-13
9:17
2016-01-13
9:27
MySQL Server: DMLVerified
(3402 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyAny"CONCAT( '2005' , '-01-01') - 100" doesn't throw any warning
799742016-01-14
3:04
2016-01-14
13:08
MySQL Server: DMLVerified
(3401 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyAny"Out of range value for column '(null)'" is not clear enough
799782016-01-14
7:39
2016-02-08
16:42
MySQL Server: DMLClosed
(3376 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyAnyFunc SUBSTRING_INDEX works incorrectly when the count param is a bigint unsigned
799882016-01-14
15:38
2016-01-29
18:46
MySQL Server: DMLClosed
(3386 days)
S15.6, 5.6.28Ubuntu (12.04 LTS)AnyExtractValue return NULL instead empty string when do not find a XML path
800222016-01-18
3:14
2016-01-18
4:45
MySQL Server: DMLCan't repeat
(3397 days)
S55.6.21Windows (Microsoft Windows 7 Home Premium)AnyLEFT JOIN with Null test NOW Fails
800452016-01-19
9:03
2016-01-19
10:52
MySQL Server: DMLVerified
(3396 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyAnySyntax error returned for invalid D in DECIMAL(M, D), ERROR 1427 expected
800462016-01-19
9:18
2016-01-19
10:22
MySQL Server: DMLVerified
(3396 days)
S35.7.8, 5.6.28, 5.7.10AnyAnyInconsistent result returned for equivalent string input in CAST(str AS DATE)
800472016-01-19
9:59
2016-01-27
15:13
MySQL Server: DMLClosed
(3389 days)
S25.7.8, 5.5.48, 5.6.28, 5.7.10AnyAnyData rows lost after adding DISTINCT with substr() in select list
800642016-01-20
8:50
2016-05-26
15:01
MySQL Server: DMLClosed
(3268 days)
S15.7.9,5.7.10AnyAnySELECT STR_TO_DATE('09:30:17','%h:%i:%s') return NULL value
800682016-01-20
10:57
2019-12-24
15:46
MySQL Server: DMLClosed
(1961 days)
S15.7.10, 5.7.15WindowsAnyInvalid result of Query
800802016-01-20
17:22
2017-01-27
16:37
MySQL Server: DMLClosed
(3065 days)
S25.7.12-debugAnyAnyAssertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_i
800882016-01-21
0:46
2016-01-27
8:29
MySQL Server: DMLVerified
(3389 days)
S35.6/5.7Other (Amazon RDS and OSX)AnyWhere in subquery referencing md5 computed column in view causes duplicate rows
800942016-01-21
9:48
2019-12-11
21:36
MySQL Server: DMLClosed
(1974 days)
S35.7.10AnyAnyAssertion `type() != MYSQL_TYPE_TIMESTAMP' failed in sql/field.cc:1615
800992016-01-21
13:18
2018-06-04
1:00
MySQL Server: DMLNo Feedback
(2530 days)
S25.5.47CentOSAnyWrong Collation cp1256_general_ci for CP1256 Charset
801072016-01-22
1:56
2016-02-04
20:18
MySQL Server: DMLCan't repeat
(3380 days)
S25.6.12CentOSAnymysqld got signal 11 ;
801182016-01-22
14:45
2016-01-25
9:59
MySQL Server: DMLVerified
(3390 days)
S15.6.26, 5.6.28, 5.7.10AnyAnySTR_TO_DATE doesn't work properly
801492016-01-26
8:10
2018-08-15
8:58
MySQL Server: DMLVerified
(3389 days)
S35.7.10WindowsAny32-bit win, internal_tmp_disk_storage_engine=innodb, The table is full, >=4GB
801542016-01-26
12:33
2016-01-26
13:41
MySQL Server: DMLVerified
(3389 days)
S35.0/5.1/5.5/5.6/5.7AnyAnyFunction ROUND( int value, 10) gets padding 0s
801862016-01-28
13:15
2016-01-28
13:54
MySQL Server: DMLNot a Bug
(3387 days)
S35.5.38-logWindowsAnythe group by colunm is trimed when do group by
802212016-02-01
14:19
2016-02-01
15:13
MySQL Server: DMLNot a Bug
(3383 days)
S2AnyAnyAnyError in search record by field type double, returns nothing
802272016-02-02
4:24
2016-02-02
7:49
MySQL Server: DMLVerified
(3382 days)
S35.7.8, 5.7.10, 5.6.28, 5.5.48AnyAnyFunc SUBSTRING_INDEX works incorrectly with negative count
802712016-02-04
20:18
2016-07-11
12:15
MySQL Server: DMLDuplicate
(3222 days)
S15.7.11Windows (10, 2012 R2)AnyGenerated columns are required in INSERT INTO ... SELECT * FROM ... commands
802932016-02-05
19:48
2016-07-11
12:15
MySQL Server: DMLNot a Bug
(3377 days)
S15.7.11AnyAnyINSERT ... SELECT * FROM does not work for tables with generated columns
803642016-02-15
10:03
2019-12-11
21:59
MySQL Server: DMLClosed
(1974 days)
S35.7.8, 5.6.29, 5.7.11AnyAnyCASE WHEN timestamp with microseconds are not working as expected
803842016-02-16
7:31
2016-02-16
11:12
MySQL Server: DMLDuplicate
(3368 days)
S15.7.11CentOS (7)AnyCan not use insert into select * for table with generated column
804042016-02-17
11:06
2016-02-17
13:28
MySQL Server: DMLVerified
(3367 days)
S35.0/5.1/5.5/5.6/5.7AnyAnyAfter sql_warnings to 0, the INSERT still get warnings message
804402016-02-19
6:13
2016-02-19
9:12
MySQL Server: DMLDuplicate
(3365 days)
S35.6.29, 5.6.30CentOSAny Assertion `item_in->left_expr->cols() == 1' failed in sql/item_subselect.cc:382
804922016-02-24
11:37
2016-02-25
4:57
MySQL Server: DMLVerified
(3360 days)
S35.0/5.1/5.5/5.6/5.7AnyAnyWeird results when quoted number is added to a bigint value
805332016-02-26
14:46
2016-02-26
16:16
MySQL Server: DMLVerified
(3358 days)
S35.6, 5.7AnyAnyPASSWORD(NULL) returns empty string, should be NULL according to documentation
806302016-03-07
7:47
2016-09-19
8:20
MySQL Server: DMLClosed
(3304 days)
S35.5+AnyAnyCAST( .. AS BINARY(N)) gets unexpected NULL
806812016-03-10
7:24
2016-03-11
8:07
MySQL Server: DMLVerified
(3344 days)
S35.7.11CentOSAnyFailing assertion: len <= fixed_len in in file rem0rec.cc line 886
806822016-03-10
8:44
2016-03-10
11:50
MySQL Server: DMLVerified
(3345 days)
S35.7.8, 5.7.11AnyAnyInconsistent behavior with GROUP BY alias, w/ different sequence in select list
807032016-03-11
9:21
2019-12-11
22:32
MySQL Server: DMLNot a Bug
(1974 days)
S35.7.11, 5.6.29Windows (10)AnyDATE('space') can not be inserted to DATE type with IFNULL in INSERT-SELECT
807752016-03-17
9:37
2016-03-23
8:51
MySQL Server: DMLVerified
(3332 days)
S35.6.24-72.2-log, 5.6.29, 5.7.11Ubuntu (14.04.4)Any"Out of range value for column XXX" in DML is missleading
808732016-03-29
2:40
2016-04-09
16:10
MySQL Server: DMLClosed
(3315 days)
S35.7.8, 5.7.9, 5.6.29, 5.7.11AnyAnyFunction FLOOR(CEIL()) truncates bigint unsigned
808852016-03-29
12:59
2025-01-03
21:23
MySQL Server: DMLVerified
(3323 days)
S25.7.11Debian (Debian GNU/Linux 8 (jessie))AnyNot null update fails with an "Column cannot be null" error.
809902016-04-07
8:22
2019-12-11
22:48
MySQL Server: DMLClosed
(1974 days)
S35.7.11, 5.6.29, 5.5Windows (Microsoft Windows 7 Enterprise Service Pack 1)Any"... not in (select null from ...)" should return no rows
810242016-04-09
19:53
2016-04-09
21:45
MySQL Server: DMLVerified
(3315 days)
S55.0/5.1/5.5/5.6/5.7Windows (Microsoft Windows 7 Enterprise Service Pack 1)AnyHAVING without GROUP BY should imply an aggregation of a single group
810352016-04-12
1:57
2016-04-12
7:43
MySQL Server: DMLVerified
(3312 days)
S35.7.8, 5.5.49, 5.6.30, 5.7.12AnyAny`NEWDECIMAL` result for ROUND() function is out of range of 65 digits
811912016-04-25
11:10
2016-09-02
16:26
MySQL Server: DMLVerified
(3298 days)
S35.7.11WindowsAnyCREATE TABLE ... SELECT caused ERROR 1114 while destination reached over 4 Gb
812002016-04-26
12:52
2016-04-30
10:16
MySQL Server: DMLVerified
(3294 days)
S35.0, 5.6AnyAnyUser-defined variable changes value in SELECT assignment when it shouldn't
812252016-04-28
16:48
2016-06-27
1:00
MySQL Server: DMLNo Feedback
(3237 days)
S35.6.30CentOS (3.10.0-327.13.1.el7.x86_64)Anystr_to_date with before insert trigger results in null
812542016-05-01
7:53
2016-05-02
10:10
MySQL Server: DMLVerified
(3292 days)
S25.6, 5.6.30, 5.7.12AnyAnyUsing INSERT_ID local variable, makes REPLACE fail when there is a duplicate key
812592016-05-01
16:29
2016-05-02
5:53
MySQL Server: DMLVerified
(3292 days)
S35.7.8, 5.5.49, 5.6.30, 5.7.12AnyAnyGet unexpected `Empty Set` for correlated subquery with aggregate functions
812992016-05-03
21:08
2016-05-06
14:17
MySQL Server: DMLDuplicate
(3288 days)
S25.6.30, 5.7.12UbuntuAnyUnique index does not handle German umlauts properly
813022016-05-04
6:41
2023-04-09
11:55
MySQL Server: DMLVerified
(3290 days)
S35.7.8, 5.6.30, 5.7.12AnyAnyw/o group by, query with column in having clause not in select list, succeeds
814102016-05-13
4:12
2019-01-23
11:50
MySQL Server: DMLUnsupported
(2296 days)
S15.5.49AnyAnyAssertion `multi_range_length > 0' failed. in QUICK_RANGE_SELECT::reset
814862016-05-18
11:43
2016-05-24
18:51
MySQL Server: DMLClosed
(3275 days)
S35.6.30, 5.5.49DebianAnyERROR 1452 throws as ERROR 1062 if query has ON DUPLICATE stament
815082016-05-19
13:22
2016-05-20
8:52
MySQL Server: DMLVerified
(3274 days)
S35.7.8, 5.7.12, 5.6.30AnyAnyType in meta data for "cast('a' as char(100))" is VAR_STRING
815132016-05-19
19:39
2016-05-23
7:15
MySQL Server: DMLNot a Bug
(3271 days)
S35.7.11, 5.7.12, 5.6.30WindowsAnyIncorrect result of ROUND with subquery
815332016-05-23
4:25
2016-05-23
7:24
MySQL Server: DMLVerified
(3271 days)
S35.7.8, 5.5.49, 5.6.30, 5.7.12AnyAnyGet different results when comparing YEAR(4) with 2-digit const and 2-digit col
815782016-05-24
18:38
2016-05-24
18:51
MySQL Server: DMLDuplicate
(3270 days)
S35.5.49AnyAnyINSERT ON DUPLICATE KEY UPDATE statement returning 1062 instead of 1452
816062016-05-26
9:12
2019-03-01
14:24
MySQL Server: DMLClosed
(2259 days)
S35.1.73, 5.5.49, 5.6.30, 5.7.12AnyAnyVariable-name's typo in sql/item_func.cc
816382016-05-30
7:40
2019-12-16
22:46
MySQL Server: DMLClosed
(1969 days)
S25.7.8, 5.5.49, 5.6.30, 5.7.12AnyAnyFunction substr with order by gives incorrect result
816732016-06-01
11:12
2016-06-01
11:28
MySQL Server: DMLVerified
(3262 days)
S35.7.8AnyAnyUNION ALL returned incorrect result
816842016-06-02
6:05
2016-06-02
13:22
MySQL Server: DMLVerified
(3261 days)
S15.7.8, 5.6.30, 5.7.12AnyAnyselect + where exists( select + group by + limit) works incorrectly
816852016-06-02
9:43
2016-06-02
18:37
MySQL Server: DMLVerified
(3261 days)
S35.7.8, 5.6.12AnyAny"select current_time(256)" succeeds while error is expected
816862016-06-02
10:01
2016-07-03
1:00
MySQL Server: DMLNo Feedback
(3231 days)
S15.6.30CentOSAnyCOUNT(PRIMARY_KEY) returns 0 with more than one WHERE clause
817672016-06-08
4:44
2016-06-08
7:38
MySQL Server: DMLVerified
(3255 days)
S35.7.8, 5.6.30,5.6.31, 5.7.12, 5.7.13AnyAnyComparison result for column w/ YEAR(4) and const w/ 2 digits is incorrect
818162016-06-11
19:53
2019-12-19
22:47
MySQL Server: DMLClosed
(1966 days)
S25.6.31AnyAnyInvalid select query result on FIRST time
818352016-06-13
16:55
2016-06-13
22:56
MySQL Server: DMLDuplicate
(3250 days)
S35.7.13Windows (windows 10 and mac el capitan)AnyOrdering by aggregation column does not work when longtext column is present
818552016-06-15
8:07
2016-06-15
12:17
MySQL Server: DMLVerified
(3248 days)
S25.7.8, 5.5.50, 5.6.31, 5.7.13AnyAnySubquery with Empty Set in result returns incorrect result
818762016-06-16
7:30
2016-06-20
11:09
MySQL Server: DMLVerified
(3243 days)
S35.5.50, 5.6.31, 5.7.13LinuxAnyneg op returns diff results
819332016-06-20
12:21
2019-12-24
13:32
MySQL Server: DMLNot a Bug
(1961 days)
S35.6, 5.6.31, 5.7.13LinuxAnyselect timestamp reports an error
819402016-06-21
3:31
2019-12-24
13:28
MySQL Server: DMLClosed
(1961 days)
S35.7.8, 5.5.50, 5.6.31,5.7.13AnyAnyOrder by substr() returns incorrect result
819502016-06-21
11:06
2016-07-27
9:41
MySQL Server: DMLNot a Bug
(3206 days)
S35.6LinuxAnywhen cast failed mysql return different results
819512016-06-21
11:15
2016-06-21
12:23
MySQL Server: DMLVerified
(3242 days)
S35.6, 5.6.31, 5.5.50LinuxAnystrcmp returns unexpected value
819632016-06-22
2:37
2019-10-24
10:46
MySQL Server: DMLNot a Bug
(3232 days)
S35.7.8, 5.6.31, 5.7.13AnyAnyGet incorrect result for -2 into unsigned column and cast -2 to unsigned
819692016-06-22
9:03
2019-12-24
13:45
MySQL Server: DMLClosed
(1961 days)
S35.6, 5.6.31LinuxAnycase when returns weird results when meets unsigned
819902016-06-23
18:51
2019-12-24
13:49
MySQL Server: DMLClosed
(1961 days)
S3AnyAnyLIKE condition with multiple backslashes, must add extra \ at the end
819952016-06-24
6:51
2019-12-24
13:39
MySQL Server: DMLClosed
(1961 days)
S25.7.8, 5.6.31, 5.7.13AnyAnycol(const) IN (-1.49) returns true in WHERE condition with index on col
820112016-06-27
7:56
2019-12-24
13:53
MySQL Server: DMLClosed
(1961 days)
S35.6, 5.5.50, 5.6.31,5.7.13LinuxAnyand operation returns weird results
820702016-06-30
17:14
2018-10-11
7:51
MySQL Server: DMLNot a Bug
(2400 days)
S35.6.30, 5.6.31, 5.7.13SUSE (Leap 42)AnyUNIX_TIMESTAMP() returns decimal (NO fractional seconds part)
820852016-07-02
0:28
2016-07-02
20:33
MySQL Server: DMLVerified
(3231 days)
S35.6.12, 5.5.50, 5.6.31,5.7.13WindowsAnyFORMAT(..., bg_BG) generates zero bytes
820862016-07-02
5:12
2019-12-24
14:22
MySQL Server: DMLCan't repeat
(1961 days)
S35.6.13, 5.6.31, 5.7.13AnyAnyPROCEDURE ANALYSE() is antiquated
820902016-07-03
18:21
2016-07-04
7:54
MySQL Server: DMLVerified
(3229 days)
S35.6.31, 5.7.13AnyAnySouth Asian / Indian / Vedic number system with FORMAT()
821662016-07-08
10:27
2016-07-08
11:10
MySQL Server: DMLNot a Bug
(3225 days)
S25.6.30CentOS (Linux 2.6.32-431.11.5.el6.ucloud.x86_64 #1 SMP)Anyupdate the other field which isn't the specified field.
821892016-07-11
21:19
2016-07-12
9:18
MySQL Server: DMLVerified
(3221 days)
S35.7.12 MySQL Community Server (GPL), 5.6.31, 5.7.13AnyAnyDELETE via the alias of fully qualified table reference fails with ERROR 1046
821942016-07-12
5:47
2016-07-13
4:14
MySQL Server: DMLNot a Bug
(3221 days)
S35.6.12, 5.7.13AnyAnyinnodb_large_prefix does not honor UNIQUEness past 255
822012016-07-12
16:11
2016-07-13
13:57
MySQL Server: DMLCan't repeat
(3220 days)
S35.7.12CentOS (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
822382016-07-15
3:22
2019-12-24
14:46
MySQL Server: DMLNot a Bug
(1961 days)
S15.7.13, 5.5.50, 5.6.31AnyAnyVarious incorrect looking errors for multi-table DELETE statements
822642016-07-18
9:24
2016-07-20
8:45
MySQL Server: DMLDuplicate
(3213 days)
S15.7.13AnyAnycannot insert into table when 1. have date column, 2. select using like with '%'
824952016-08-08
18:51
2016-11-18
7:51
MySQL Server: DMLClosed
(3092 days)
S35.6/5.7LinuxAnyUPPER not working properly with AES Encryption
825592016-08-12
3:08
2016-08-16
20:12
MySQL Server: DMLVerified
(3190 days)
S25.6, 5.7.14, 5.6.32LinuxAnya bug about union with subquery
825602016-08-12
3:32
2016-08-16
10:10
MySQL Server: DMLVerified
(3190 days)
S35.5.51, 5.6.32, 5.7.14LinuxAnynested limit produces counter intuitive result
825622016-08-12
5:12
2016-08-12
7:56
MySQL Server: DMLNot a Bug
(3190 days)
S35.6.31,5.7.14AnyAny exists (select max(id) from t3 where id=2) produced the undesired result
825822016-08-15
11:05
2016-08-15
13:34
MySQL Server: DMLVerified
(3187 days)
S35.6/5.7LinuxAnyinconsistent and ambiguous results with cast decimal to datetime
826382016-08-18
17:48
2016-11-19
16:25
MySQL Server: DMLClosed
(3094 days)
S35.7.2AnyAnyIncorrect evaluation of MIN/MAX referring to an outer query block
826402016-08-19
3:30
2016-08-19
7:54
MySQL Server: DMLDuplicate
(3183 days)
S35.6LinuxAnycast string to datetime produces invalid value
826422016-08-19
3:58
2016-08-19
7:59
MySQL Server: DMLVerified
(3183 days)
S35.6, 5.5.51, 5.6.32AnyAnyinsert string-format value to datetime and timestamp return different status
826862016-08-22
23:56
2016-08-23
16:24
MySQL Server: DMLCan't repeat
(3179 days)
S35.6.30FreeBSDAnyconvert_tz returns null - timezones are loaded
827522016-08-27
15:02
2016-08-28
12:02
MySQL Server: DMLNot a Bug
(3174 days)
S56.3.7Windows (Microsoft Windows 7 Ultimate Service Pack 1)AnySHOW TABLE STATUS WHERE `Name` = returns different value after db stop-start
829122016-09-08
18:56
2019-12-24
15:26
MySQL Server: DMLClosed
(1961 days)
S15.6.33AnyAnyCOUNT DISTINCT returns wrong result when tmp files are used by MySQL
829152016-09-09
2:27
2016-09-09
5:38
MySQL Server: DMLVerified
(3162 days)
S35.7.13, 5.7.15AnyAnySIGKILL myself when using innodb_limit_optimistic_insert_debug=2 and drop table
829212016-09-09
8:29
2019-12-24
15:30
MySQL Server: DMLClosed
(1961 days)
S35.6LinuxAnyregex return inconsistent results with invalid pattern
829602016-09-12
19:29
2016-10-04
15:48
MySQL Server: DMLClosed
(3137 days)
S38.0.0AnyAnyRemoving an invisible index breaks explain
830212016-09-16
10:02
2016-09-16
10:16
MySQL Server: DMLVerified
(3155 days)
S35.6.33, 5.5.52AnyAnyAssertion "buf != end" failed
830312016-09-18
8:09
2016-11-16
1:20
MySQL Server: DMLClosed
(3094 days)
S35.7, 5.6.33, 5.7.15, 5.5.52LinuxAnybin return inconsistent results with params of datetype bit
830512016-09-20
9:49
2016-09-20
10:01
MySQL Server: DMLDuplicate
(3151 days)
S15.7.11WindowsAnyInvalid Query on MySQL 5.7.11
830682016-09-21
7:15
2016-11-25
1:00
MySQL Server: DMLNo Feedback
(3086 days)
S25.7.14MacOSAnyMySQL crash with invalid query pointer
831002016-09-22
14:57
2017-01-24
12:29
MySQL Server: DMLNot a Bug
(3025 days)
S35.5UbuntuAnyConcurrent procedure calls returning different results with an unrelated SELECT
831102016-09-23
1:08
2017-11-30
3:57
MySQL Server: DMLClosed
(3064 days)
S35.7.15AnyAnyfound_rows() returns 1 when no rows found
831132016-09-23
4:13
2017-07-14
2:25
MySQL Server: DMLVerified
(2854 days)
S15.1.67,8.0-dmrAnyAnySIGKILL myself on DROP TABLE
831142016-09-23
4:20
2017-01-13
17:56
MySQL Server: DMLClosed
(3036 days)
S18.0-dmrAnyAnyAssertion `strlen(db_name) <= (64*3) && strlen(table_name) <= (64*3)' failed.
831172016-09-23
4:39
2016-11-16
1:05
MySQL Server: DMLClosed
(3094 days)
S18.0-dmrAnyAnyAssertion `MDL_checker::is_read_locked(m_thd, *object)' failed.
831462016-09-26
7:39
2016-09-26
10:34
MySQL Server: DMLVerified
(3145 days)
S35.6, 5.7LinuxAnytime to bit produces inconsistent results
831602016-09-27
7:22
2020-01-02
22:42
MySQL Server: DMLClosed
(1952 days)
S35.6LinuxAnybinary in (char) return inconsistent results
831622016-09-27
8:01
2016-09-27
11:11
MySQL Server: DMLDuplicate
(3144 days)
S35.7, 5.7.15LinuxAnyordered result should have been returned
831782016-09-28
2:28
2016-09-28
6:47
MySQL Server: DMLVerified
(3143 days)
S35.6, 5.6.33, 5.7.15LinuxAnysubstring(binary, 3) return inconsistent results
832512016-10-04
10:01
2020-01-02
22:50
MySQL Server: DMLCan't repeat
(1952 days)
S35.7.15, 5.5.52, 5.6.33AnyAnyCond. jump depends on uninitialised values at check_ulonglong by get_ev_num_info
832862016-10-06
12:54
2020-01-02
22:57
MySQL Server: DMLClosed
(1952 days)
S35.7AnyAnyInvalid error for Subquery returns more than 1 row
833112016-10-09
7:08
2017-07-11
11:48
MySQL Server: DMLClosed
(3092 days)
S35.7, 5.7.15LinuxAnyunexpected and inconsistent results with virtual column when meets index
833122016-10-09
7:26
2020-01-02
23:05
MySQL Server: DMLNot a Bug
(1952 days)
S35.5/5.6/5.7/8.0LinuxAnyinsert an empty string to bit field should have failed with strict sql mode
833202016-10-10
13:02
2021-02-17
11:18
MySQL Server: DMLClosed
(1540 days)
S35.6, 5.6.33, 5.7.15LinuxAnyround(bin) returns unexpected negative results
833622016-10-13
8:46
2020-01-02
23:15
MySQL Server: DMLClosed
(1952 days)
S35.6, 5.6.33, 5.7.15LinuxAnyinconsistent results with and operation
833642016-10-13
9:03
2020-01-02
23:10
MySQL Server: DMLClosed
(1952 days)
S35.7, 5.6.33, 5.7.15LinuxAnyincorrect result with mysql functions
833742016-10-13
15:58
2016-10-13
22:00
MySQL Server: DMLUnsupported
(3128 days)
S25.7.14Red Hat (64 Bit)AnyMySQL Year 2038
833832016-10-14
3:30
2020-01-02
23:18
MySQL Server: DMLClosed
(1952 days)
S35.7.15LinuxAnyincorrect validation for logical expression in mysql5.7
834172016-10-17
22:56
2016-10-19
20:53
MySQL Server: DMLCan't repeat
(3122 days)
S35.5.52Ubuntu (14.04)AnyAfter updating from 5.5.50 to 5.5.52 We now get Error 1300 with LOCAL INFILE
834522016-10-20
5:54
2016-10-20
6:56
MySQL Server: DMLVerified
(3121 days)
S35.7, 5.5.53, 5.6.34, 5.7.16LinuxAnyinconsistent results returned when compare enum with integer
834542016-10-20
8:09
2016-10-20
8:38
MySQL Server: DMLVerified
(3121 days)
S35.7LinuxAnyinconsistent results returned when compare enum with integer
834632016-10-20
15:05
2016-10-21
7:36
MySQL Server: DMLVerified
(3120 days)
S25.6.31, 5.5.53, 5.6.34, 5.7.16CentOS (CentOS release 6.6 (Final))Anystr_to_date() accepts and returns invalid dates
834812016-10-22
3:09
2023-03-14
6:33
MySQL Server: DMLNo Feedback
(3088 days)
S35.7.15LinuxAnyCrash on Field_temporal_with_date::store_time(st_mysql_time*, unsigned char)
834892016-10-23
16:50
2016-10-24
12:24
MySQL Server: DMLCan't repeat
(3117 days)
S35.7WindowsAnyUnable to "Load data Infile"
835582016-10-27
3:16
2016-10-27
12:38
MySQL Server: DMLNot a Bug
(3114 days)
S35.7.16AnyAnyIs this a wrong stage?
836992016-11-04
21:18
2017-10-20
18:24
MySQL Server: DMLClosed
(2763 days)
S35.8AnyAnyWrong calculation of decimals after point for IFNULL w/ GROUP BY using tmp tbl
837072016-11-06
16:08
2020-01-02
23:32
MySQL Server: DMLClosed
(1952 days)
S35.5/5.6AnyAnyMysql left join with view of type merge returns view `ifnull` results instead of
837632016-11-10
2:36
2016-11-10
3:47
MySQL Server: DMLDuplicate
(3100 days)
S3LinuxAnyunreasonable behavior for extracting year from time
  Showing 1-1000 of 1638 (Edit, Save, CSV, Feed) Show Next 1000 Entries »