Showing all 74 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version Target OS CPU Summary Assigned
784152015-09-12
6:17
2015-09-12
9:50
MySQL Server: DMLVerified
(1260 days)
S35.6.22, 5.6.26, 5.7.9AnyAnyEquivalent SQL like "select cast( varchar as decimal)" returns different results  
438652009-03-25
20:04
2011-02-16
23:43
MySQL Server: GeneralVerified
(3621 days)
S25.1.30, 5.0, 5.1, 6.0 bzrAnyAnyCAST( -1.0 as UNSIGNED) yields 0 instead of MAXINT and returns a warning.  
460372009-07-08
11:11
2018-11-04
20:45
MySQL Server: Data TypesVerified
(3517 days)
S3mysql-azalea/5.1AnyAnyInconsistent behavior when casting floating point numbers to integer Assigned Account
505672010-01-23
15:46
2011-02-16
23:44
MySQL Server: GeneralVerified
(3318 days)
S35.1+AnyAnyCAST from large double to integer produces inconsistent results  
833642016-10-13
9:03
2016-10-13
9:39
MySQL Server: DMLVerified
(863 days)
S35.7, 5.6.33, 5.7.15LinuxAnyincorrect result with mysql functions  
832562016-10-04
16:17
2016-10-04
16:51
MySQL Server: ParserVerified
(872 days)
S35.5/5.6/5.7Red Hat (rhel6)Anydate in multi-column IN clause with multi-values clause is parsed incorrectly  
781272015-08-18
12:16
2015-08-18
13:19
MySQL Server: DMLVerified
(1285 days)
S35.6.22, 5.5.46, 5.6.26AnyAnyIn consistent behavior between similar UPDATE sqls, error vs warning  
799172016-01-11
12:41
2016-01-13
8:10
MySQL Server: DMLVerified
(1137 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyAnyFunc COALESCE( date, timestamp) and datetime are not working consistently  
317762007-10-23
8:19
2018-09-09
20:45
MySQL Server: DMLVerified
(4140 days)
S35.0.45, 4.1, 5.0, 5.1, 5.2 BKAny (Linux, Microsoft Windows XP SP2)AnyCAST AS CHAR with SELECT DISTINCT  
482382009-10-22
17:38
2012-05-18
20:19
Tests: ServerVerifiedS35.1.40Other (AIX + HP-UX, 32 bit)AnyTest "partition_alter4_innodb" fails due to "Out of memory"  
717772014-02-20
9:39
2014-02-20
10:54
MySQL Server: OptimizerVerified
(1829 days)
S25.5.35-0ubuntu0.13.10.1Linux (ubuntu0.13.10.1)AnyIncorrect results are returned with NULLIF()  
799152016-01-11
8:18
2016-01-11
9:34
MySQL Server: DMLVerified
(1139 days)
S35.7.8, 5.6.28, 5.7.10AnyAnyFunction NULLIF + CAST is not working as expected  
345642008-02-14
19:20
2011-02-16
23:43
MySQL Server: ParserVerified
(3988 days)
S35.1.22-rc-logAnyAnyCAST does not accept varchar type  
443632009-04-20
9:56
2011-02-16
23:43
MySQL Server: GeneralVerified
(3595 days)
S25.1.15, 5.1.35-bzrAnyAnyIDIV not rounding off float/decimals correctly ?  
799252016-01-12
8:07
2016-01-12
9:35
MySQL Server: DMLVerified
(1138 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  
800462016-01-19
9:18
2016-01-19
10:22
MySQL Server: DMLVerified
(1131 days)
S35.7.8, 5.6.28, 5.7.10AnyAnyInconsistent result returned for equivalent string input in CAST(str AS DATE)  
816732016-06-01
11:12
2016-06-01
11:28
MySQL Server: DMLVerified
(997 days)
S35.7.8AnyAnyUNION ALL returned incorrect result  
345622008-02-14
18:55
2018-09-09
20:45
MySQL Server: Data TypesVerified
(4019 days)
S35.1.22-rc-logAnyAnyCAST does not accept standard-sql numeric types  
791102015-11-04
4:17
2015-11-04
7:23
MySQL Server: DMLVerified
(1207 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  
792922015-11-16
9:48
2015-11-19
22:03
MySQL Server: DMLVerified
(1192 days)
S35.0/5.1/5.5/5.6/5.7AnyAnycast('-123.9' as signed) returns -123, not expected -124  
795182015-12-04
7:42
2015-12-07
7:01
MySQL Server: DMLVerified
(1174 days)
S35.7.8, 5.5.48, 5.6.29, 5.7.11 AnyAnyGet inconsistent string when converting year column to char  
815082016-05-19
13:22
2016-05-20
8:52
MySQL Server: DMLVerified
(1009 days)
S35.7.8, 5.7.12, 5.6.30AnyAnyType in meta data for "cast('a' as char(100))" is VAR_STRING  
825822016-08-15
11:05
2016-08-15
13:34
MySQL Server: DMLVerified
(922 days)
S35.6/5.7LinuxAnyinconsistent and ambiguous results with cast decimal to datetime  
365392008-05-06
15:44
2011-02-16
23:43
MySQL Server: Data TypesVerified
(3945 days)
S25.0.38+, 5.1, 6.0AnyAnydata truncation and implicit cast return different values than explicit cast  
845582017-01-18
17:07
2017-01-18
19:36
MySQL Server: Data TypesVerified
(766 days)
S35.5/5.6/5.7/8.0AnyAnyCast to NUMERIC not working  
614722011-06-10
7:26
2011-07-18
6:56
Connector / ODBCAnalyzing
(2777 days)
S15.1.8Microsoft Windows (XP SP3)Any"Specified cast is not valid" error even when datatypes are perfectly aligned Bogdan Degtyariov
687592013-03-24
12:49
2013-03-25
5:31
MySQL Server: Data TypesVerified
(2161 days)
S35.6.10AnyAnyInconsistent results on comparison a time field with a non-time literal  
492532009-12-01
9:38
2018-09-09
20:45
MySQL Server: Data TypesVerified
(3371 days)
S25.1.41, mysql-next-mr(-alik)Linux (SUSE 11.1, Linux 2.6.27.37-0.1-default #1 SMP x86_64 )AnyInconsistent behavior concering overflow using numeric expressions and literals.  
880332017-10-09
18:38
2019-01-07
3:15
MySQL Server: JSONVerified
(501 days)
S38.0.3, 5.7.19AnyAnyGenerated INT column with value from JSON document  
691002013-04-30
9:53
2015-03-15
20:45
MySQL Server: InnoDB storage engineVerified
(2119 days)
S15.5.31-0, 5.5.30-1, 5.5.29-0, 5.5.25-1, 5.5.16, 5.5.30-1.1, 5.6.10, 5.0.97, 5.1.70, 5.5.29, 5.7.2Linux (Debian 6 / Debian 7 / Ubuntu 12.10 / Windows 8)AnyCAST in IF function fails in some case Assigned Account
721272014-03-25
19:16
2014-03-26
21:07
MySQL Server: DMLVerified
(1795 days)
S35.5.8, 5.5.31,5.6AnyAnyDIV with floats or doubles and unsigned integers sometimes errors out spuriously  
735522014-08-12
18:56
2014-08-18
19:47
MySQL Server: DMLVerified
(1650 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"  
786402015-09-30
8:42
2015-09-30
9:28
MySQL Server: Data TypesVerified
(1242 days)
S35.7.8, 5.5.47, 5.6.28, 5.7.10AnyAnyCAST OF 'DOUBLE' VALUE TO 'UNSIGNED' GIVES INCORRECT VALUE  
788212015-10-13
15:28
2015-10-15
8:13
MySQL Server: DMLVerified
(1227 days)
S25.7.8, 5.7.10, 5.6.27, 5.5.47AnyAnyWhen comparing bigint and varchar constant, inconsistent results are returned  
209242006-07-09
6:42
2018-09-09
20:45
MySQL Server: Data TypesVerified
(3565 days)
S2AllLinux (Linux 2.6)AnyCAST(expr as UNSIGNED) returns SIGNED value when used in various functions  
792952015-11-16
15:48
2017-08-28
15:00
MySQL Server: Data TypesVerified
(544 days)
S35.7.8AnyAnyselect cast(-1 as unsigned) returns 18446744073709551615  
474832009-09-21
14:05
2011-02-16
23:44
MySQL Server: C API (client library)Verified
(3442 days)
S35.1AnyAnySELECT UNION wrong length after prepare  
799162016-01-11
9:34
2016-01-15
4:25
MySQL Server: DMLVerified
(1135 days)
S35.7.8, 5.6.28, 5.7.10AnyAnyComparison gives inconsistent result for time(1) column and explicit cast result  
796562015-12-16
4:00
2015-12-16
7:59
MySQL Server: DMLVerified
(1165 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  
391252008-08-29
16:31
2012-05-18
20:19
MySQL Cluster: Cluster (NDB) storage engineVerified
(3568 days)
S3mysql-5.1-telco-6.36.3.19AnyAnyResult file for test contains a "temporary error", how can this be stable ? Assigned Account
796572015-12-16
4:10
2015-12-16
11:46
MySQL Server: DMLVerified
(1165 days)
S35.7.8, 5.7.10, 5.6.28AnyAnyBigint unsigned column value in CASE WHEN operator is converted to bigint signed  
621562011-08-12
15:57
2012-05-18
20:19
MySQL Server: TestsVerified
(2752 days)
S35.5AnyAnymain.func_str fails when run with --repeat=2  
799742016-01-14
3:04
2016-01-14
13:08
MySQL Server: DMLVerified
(1136 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyAny"Out of range value for column '(null)'" is not clear enough  
634102011-11-23
21:17
2012-02-17
18:50
MySQL Server: Stored RoutinesVerified
(2563 days)
S35.1.60, 5.1.61FreeBSD (x86_64)Anystring corrupted in stored procedure concat and cast  
801542016-01-26
12:33
2016-01-26
13:41
MySQL Server: DMLVerified
(1124 days)
S35.0/5.1/5.5/5.6/5.7AnyAnyFunction ROUND( int value, 10) gets padding 0s  
647912012-03-28
20:17
2015-07-09
8:35
MySQL Server: OptimizerVerified
(2522 days)
S25.1.61, 5.5AnyAnyMixed String/Int values in IN list cause full table scan  
930102018-10-30
14:40
2018-10-30
20:23
MySQL Server: JSONVerified
(116 days)
S38.0.13AnyAnyJSON_SET() does not create intermediate objects  
715622014-02-03
10:17
2014-02-03
11:39
MySQL Server: DMLVerified
(1846 days)
S3AnyAnyCAST should give warning for invalid date  
741962014-10-02
16:37
2017-04-30
20:45
Connector / NETAnalyzing
(1243 days)
S36.9.2Microsoft WindowsAnyExtraneous / unnecessary column output in derived tables (i.e. `Filter1`, etc.) Assigned Account
778052015-07-23
2:01
2015-07-23
5:01
MySQL Server: DMLVerified
(1311 days)
S15.6.25 MySQL Community Server (GPL)Ubuntu (Ubuntu 14.04.2 LTS x86_64)AnyNULLIF cause wrong value with cast datetime  
611142011-05-10
11:02
2017-07-18
5:57
Connector / ODBCVerified
(2846 days)
S3connector 5.1.8Microsoft Windows (7)AnyODBC doesn't support Uint32 / Uint64 ? <-> OdbcType.Int / BigInt Bogdan Degtyariov
774032015-06-18
12:27
2015-08-04
13:23
MySQL Server: OptimizerOpen
(1299 days)
S25.6.25LinuxAnyMySQL server 5.6 consumes all memory on server when running query  
847012017-01-28
18:22
2018-07-15
20:45
Connector / NETVerified
(754 days)
S36.9.9Microsoft WindowsAnyOverflow Exception - 64 bit enum value as parameter cast to Int32 Assigned Account
645892012-03-08
5:08
2012-03-16
15:56
MySQL Server: Data TypesVerified
(2535 days)
S35.1; 5.5AnyAnyAlphanumeric strings bring back results on integer columns - SQL mode needed!  
786972015-10-05
7:17
2016-06-18
21:28
MySQL Server: Data TypesVerified
(1237 days)
S25.7.8, 5.7.10, 8.0.0, 5.6.28, 5.5.47AnyAnyfailed cast of string-returning function to DOUBLE emits no warning  
860432017-04-22
2:23
2018-10-21
20:45
Connector / NETAnalyzing
(670 days)
S16.8.8AnyAnyCan't use BigInt or Double as userId instead of Int32 (default) Assigned Account
647692012-03-26
22:27
2012-03-27
7:05
MySQL Server: DMLVerified
(2524 days)
S35.1.61Any (Debian unstable)Anycomparing indexed ENUM with 0+string constant does not use index properly  
800452016-01-19
9:03
2016-01-19
10:52
MySQL Server: DMLVerified
(1131 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  
905192018-04-20
2:09
2018-04-20
5:02
Connector / PythonVerified
(309 days)
S28.0.11AnyAnyTypo in conversion.py:648 causes LONG_BLOB to converted to JSON  
688642013-04-04
8:17
2013-04-04
8:37
MySQL Server: Data TypesVerified
(2151 days)
S25.6.10AnyAnyINTERVAL treats null values of text columns as float/int  
811162016-04-18
2:14
2016-05-02
9:11
MySQL Server: Data TypesVerified
(1041 days)
S25.6.30, 5.5.49CentOS (6.7)AnyEvaluating between DECIMAL and string returns different result depends on index  
924402018-09-15
21:02
2018-09-17
12:39
MySQL Visual Studio IntegrationVerified
(159 days)
S38.0Microsoft WindowsAnymysql 8.0 and VS 2017 - editing trigger fails with 'unable to load object'  
705982013-10-10
22:19
2013-10-13
11:23
MySQL Server: OptimizerVerified
(1959 days)
S35.5.32,5.5.34, 5.6.14, 5.7.2Linux (.6.18-348.16.1.el5)AnyPremature expression evaluation prevents short-circuited conditionals  
823082016-07-21
14:54
2016-07-21
17:54
MySQL Server: MyISAM storage engineVerified
(947 days)
S15.7AnyAnyuse of DISTINCT with BIT and LONGTEXT leads to erroneous results  
927652018-10-12
13:16
2018-11-30
14:42
Connector / NETOpen
(85 days)
S16.10.8AnyAnyMySQL Connector 6.10.8/EntityFrameWork 6/oData  
244242006-11-19
4:28
2018-09-09
20:45
MySQL Server: Data TypesVerified
(4068 days)
S15.1.11Any (ALL)AnyCHAR data-type not space-padding Evgeny Potemkin
706842013-10-22
8:13
2013-10-22
11:35
MySQL Server: OptimizerVerified
(1950 days)
S35.5.33, 5.6.14AnyAnyHAVING referring to subquery results in WARNING 1292  
824162016-08-02
21:22
2016-08-08
20:12
Connector / NETVerified
(929 days)
S26.9.9Microsoft Windows (Windows 10 Pro 64 bits)AnyCrash after update the Connector/NET  
292022007-06-19
9:11
2019-01-02
14:14
MySQL Server: User-defined functions ( UDF )Verified
(4188 days)
S35.1AnyAnyResult of UDF in subquery is truncated  
727112014-05-21
18:33
2014-05-22
8:33
MySQL Server: OptimizerVerified
(1738 days)
S25.5.31, 5.5.38AnyAnyHOUR() of a DATETIME with date zero occasionally (unpredictably) returns NULL  
831462016-09-26
7:39
2016-09-26
10:34
MySQL Server: DMLVerified
(880 days)
S35.6, 5.7LinuxAnytime to bit produces inconsistent results  
560252010-08-16
18:25
2018-09-09
20:45
MySQL Server: GeneralVerified
(3113 days)
S35.0.67, 5.0, 5.1, 5.6.99AnyAnyWeird date between behavior, not consistent between versions  
762152015-03-09
1:57
2015-03-11
12:48
MySQL Server: CharsetsVerified
(1445 days)
S35.5.44, 5.6.25AnyAnyImplicit casts to string by COLLATE don't use character_set_connection  
840822016-12-06
19:01
2016-12-08
23:04
MySQL Server: JSONVerified
(807 days)
S35.7.14-google-logAnyAnyJSON_OBJECT("k", dateTime) adds milliseconds to time  
Showing all 74 (Edit, Save, CSV, Feed)