Showing all 75 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version Target OS Summary Assigned
784152015-09-12
6:17
2015-09-12
9:50
MySQL Server: DMLVerified
(802 days)
S35.6.22, 5.6.26, 5.7.9AnyEquivalent SQL like "select cast( varchar as decimal)" returns different results  
438652009-03-25
20:04
2011-02-16
23:43
MySQL Server: GeneralVerified
(3163 days)
S25.1.30, 5.0, 5.1, 6.0 bzrAnyCAST( -1.0 as UNSIGNED) yields 0 instead of MAXINT and returns a warning.  
505672010-01-23
15:46
2011-02-16
23:44
MySQL Server: GeneralVerified
(2860 days)
S35.1+AnyCAST from large double to integer produces inconsistent results  
833642016-10-13
9:03
2016-10-13
9:39
MySQL Server: DMLVerified
(405 days)
S35.7, 5.6.33, 5.7.15Linuxincorrect result with mysql functions  
460372009-07-08
11:11
2011-02-16
23:44
MySQL Server: Data TypesVerified
(3059 days)
S3mysql-azalea/5.1AnyInconsistent behavior when casting floating point numbers to integer Øystein Grøvlen
832562016-10-04
16:17
2016-10-04
16:51
MySQL Server: ParserVerified
(414 days)
S35.5/5.6/5.7Red Hat (rhel6)date in multi-column IN clause with multi-values clause is parsed incorrectly  
799172016-01-11
12:41
2016-01-13
8:10
MySQL Server: DMLVerified
(679 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyFunc COALESCE( date, timestamp) and datetime are not working consistently  
781272015-08-18
12:16
2015-08-18
13:19
MySQL Server: DMLVerified
(827 days)
S35.6.22, 5.5.46, 5.6.26AnyIn consistent behavior between similar UPDATE sqls, error vs warning  
317762007-10-23
8:19
2011-02-16
23:43
MySQL Server: DMLVerified
(3682 days)
S35.0.45, 4.1, 5.0, 5.1, 5.2 BKAny (Linux, Microsoft Windows XP SP2)CAST AS CHAR with SELECT DISTINCT  
799152016-01-11
8:18
2016-01-11
9:34
MySQL Server: DMLVerified
(681 days)
S35.7.8, 5.6.28, 5.7.10AnyFunction NULLIF + CAST is not working as expected  
717772014-02-20
9:39
2014-02-20
10:54
MySQL Server: OptimizerVerified
(1371 days)
S25.5.35-0ubuntu0.13.10.1Linux (ubuntu0.13.10.1)Incorrect results are returned with NULLIF()  
482382009-10-22
17:38
2012-05-18
20:19
Tests: ServerVerifiedS35.1.40Other (AIX + HP-UX, 32 bit)Test "partition_alter4_innodb" fails due to "Out of memory"  
345622008-02-14
18:55
2011-02-16
23:43
MySQL Server: Data TypesVerified
(3561 days)
S35.1.22-rc-logAnyCAST does not accept standard-sql numeric types  
345642008-02-14
19:20
2011-02-16
23:43
MySQL Server: ParserVerified
(3530 days)
S35.1.22-rc-logAnyCAST does not accept varchar type  
816732016-06-01
11:12
2016-06-01
11:28
MySQL Server: DMLVerified
(539 days)
S35.7.8AnyUNION ALL returned incorrect result  
799252016-01-12
8:07
2016-01-12
9:35
MySQL Server: DMLVerified
(680 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnyString const '69E5' is not treated as scientific notation when casting to int  
443632009-04-20
9:56
2011-02-16
23:43
MySQL Server: GeneralVerified
(3137 days)
S25.1.15, 5.1.35-bzrAnyIDIV not rounding off float/decimals correctly ?  
800462016-01-19
9:18
2016-01-19
10:22
MySQL Server: DMLVerified
(673 days)
S35.7.8, 5.6.28, 5.7.10AnyInconsistent result returned for equivalent string input in CAST(str AS DATE)  
791102015-11-04
4:17
2015-11-04
7:23
MySQL Server: DMLVerified
(749 days)
S35.7.8,5.1.77,5.5.47,5.6.27,5.7.9AnyWhen casting a BIG number to unsigned, get inconsistent result for same number  
614722011-06-10
7:26
2011-07-18
6:56
Connector / ODBCAnalyzing
(2319 days)
S15.1.8Microsoft Windows (XP SP3)"Specified cast is not valid" error even when datatypes are perfectly aligned Bogdan Degtyariov
845582017-01-18
17:07
2017-01-18
19:36
MySQL Server: Data TypesVerified
(308 days)
S35.5/5.6/5.7/8.0AnyCast to NUMERIC not working  
815082016-05-19
13:22
2016-05-20
8:52
MySQL Server: DMLVerified
(551 days)
S35.7.8, 5.7.12, 5.6.30AnyType 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
(464 days)
S35.6/5.7Linuxinconsistent and ambiguous results with cast decimal to datetime  
687592013-03-24
12:49
2013-03-25
5:31
MySQL Server: Data TypesVerified
(1703 days)
S35.6.10AnyInconsistent results on comparison a time field with a non-time literal  
795182015-12-04
7:42
2015-12-07
7:01
MySQL Server: DMLVerified
(716 days)
S35.7.8, 5.5.48, 5.6.29, 5.7.11 AnyGet inconsistent string when converting year column to char  
365392008-05-06
15:44
2011-02-16
23:43
MySQL Server: Data TypesVerified
(3487 days)
S25.0.38+, 5.1, 6.0Anydata truncation and implicit cast return different values than explicit cast  
792922015-11-16
9:48
2015-11-19
22:03
MySQL Server: DMLVerified
(734 days)
S35.0/5.1/5.5/5.6/5.7Anycast('-123.9' as signed) returns -123, not expected -124  
799162016-01-11
9:34
2016-01-15
4:25
MySQL Server: DMLVerified
(677 days)
S35.7.8, 5.6.28, 5.7.10AnyComparison gives inconsistent result for time(1) column and explicit cast result  
786402015-09-30
8:42
2015-09-30
9:28
MySQL Server: Data TypesVerified
(784 days)
S35.7.8, 5.5.47, 5.6.28, 5.7.10AnyCAST OF 'DOUBLE' VALUE TO 'UNSIGNED' GIVES INCORRECT VALUE  
735522014-08-12
18:56
2014-08-18
19:47
MySQL Server: DMLVerified
(1192 days)
S25.5.8, 5.5.31, 5.5.34,5.6.20Any('string' = CAST(0 as TIME)) produces bogus error "Illegal mix of collations"  
492532009-12-01
9:38
2011-02-16
23:44
MySQL Server: Data TypesVerified
(2913 days)
S25.1.41, mysql-next-mr(-alik)Linux (SUSE 11.1, Linux 2.6.27.37-0.1-default #1 SMP x86_64 )Inconsistent behavior concering overflow using numeric expressions and literals.  
474832009-09-21
14:05
2011-02-16
23:44
MySQL Server: C API (client library)Verified
(2984 days)
S35.1AnySELECT UNION wrong length after prepare  
209242006-07-09
6:42
2014-06-09
6:33
MySQL Server: Data TypesVerified
(3107 days)
S2AllLinux (Linux 2.6)CAST(expr as UNSIGNED) returns SIGNED value when used in various functions  
721272014-03-25
19:16
2014-03-26
21:07
MySQL Server: DMLVerified
(1337 days)
S35.5.8, 5.5.31,5.6AnyDIV with floats or doubles and unsigned integers sometimes errors out spuriously  
792952015-11-16
15:48
2017-08-28
15:00
MySQL Server: Data TypesVerified
(86 days)
S35.7.8Anyselect cast(-1 as unsigned) returns 18446744073709551615  
880332017-10-09
18:38
2017-10-10
6:58
MySQL Server: JSONVerified
(43 days)
S38.0.3, 5.7.19AnyGenerated INT column with value from JSON document  
788212015-10-13
15:28
2015-10-15
8:13
MySQL Server: DMLVerified
(769 days)
S25.7.8, 5.7.10, 5.6.27, 5.5.47AnyWhen comparing bigint and varchar constant, inconsistent results are returned  
691002013-04-30
9:53
2015-03-15
20:45
MySQL Server: InnoDB storage engineVerified
(1661 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)CAST in IF function fails in some case Assigned Account
647912012-03-28
20:17
2015-07-09
8:35
MySQL Server: OptimizerVerified
(2064 days)
S25.1.61, 5.5AnyMixed String/Int values in IN list cause full table scan  
801542016-01-26
12:33
2016-01-26
13:41
MySQL Server: DMLVerified
(666 days)
S35.0/5.1/5.5/5.6/5.7AnyFunction ROUND( int value, 10) gets padding 0s  
796562015-12-16
4:00
2015-12-16
7:59
MySQL Server: DMLVerified
(707 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10Any"'2' + 0.0, group_concat('2') + 0.0" are returning different result  
796572015-12-16
4:10
2015-12-16
11:46
MySQL Server: DMLVerified
(707 days)
S35.7.8, 5.7.10, 5.6.28AnyBigint unsigned column value in CASE WHEN operator is converted to bigint signed  
799202016-01-11
21:31
2016-05-29
20:45
Connector / JAnalyzing
(651 days)
S35.1.38AnyNPE when executing update to MySQL Fabric Assigned Account
799742016-01-14
3:04
2016-01-14
13:08
MySQL Server: DMLVerified
(678 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10Any"Out of range value for column '(null)'" is not clear enough  
715622014-02-03
10:17
2014-02-03
11:39
MySQL Server: DMLVerified
(1388 days)
S3AnyCAST should give warning for invalid date  
634102011-11-23
21:17
2012-02-17
18:50
MySQL Server: Stored RoutinesVerified
(2105 days)
S35.1.60, 5.1.61FreeBSD (x86_64)string corrupted in stored procedure concat and cast  
621562011-08-12
15:57
2012-05-18
20:19
MySQL Server: TestsVerified
(2294 days)
S35.5Anymain.func_str fails when run with --repeat=2  
741962014-10-02
16:37
2017-04-30
20:45
Connector / NETAnalyzing
(785 days)
S36.9.2Microsoft WindowsExtraneous / unnecessary column output in derived tables (i.e. `Filter1`, etc.) Assigned Account
391252008-08-29
16:31
2012-05-18
20:19
MySQL Cluster: Cluster (NDB) storage engineVerified
(3110 days)
S3mysql-5.1-telco-6.36.3.19AnyResult file for test contains a "temporary error", how can this be stable ? Assigned Account
778052015-07-23
2:01
2015-07-23
5:01
MySQL Server: DMLVerified
(853 days)
S15.6.25 MySQL Community Server (GPL)Ubuntu (Ubuntu 14.04.2 LTS x86_64)NULLIF cause wrong value with cast datetime  
688642013-04-04
8:17
2013-04-04
8:37
MySQL Server: Data TypesVerified
(1693 days)
S25.6.10AnyINTERVAL treats null values of text columns as float/int  
647692012-03-26
22:27
2012-03-27
7:05
MySQL Server: DMLVerified
(2066 days)
S35.1.61Any (Debian unstable)comparing indexed ENUM with 0+string constant does not use index properly  
727112014-05-21
18:33
2014-05-22
8:33
MySQL Server: OptimizerVerified
(1280 days)
S25.5.31, 5.5.38AnyHOUR() of a DATETIME with date zero occasionally (unpredictably) returns NULL  
292022007-06-19
9:11
2014-07-02
8:35
MySQL Server: User-defined functions ( UDF )Verified
(3730 days)
S35.1AnyResult of UDF in subquery is truncated  
860432017-04-22
2:23
2017-04-24
4:59
Connector / NETAnalyzing
(212 days)
S16.8.8AnyCan't use BigInt or Double as userId instead of Int32 (default) Chiranjeevi Battula
706842013-10-22
8:13
2013-10-22
11:35
MySQL Server: OptimizerVerified
(1492 days)
S35.5.33, 5.6.14AnyHAVING referring to subquery results in WARNING 1292  
791632015-11-06
22:32
2017-08-10
2:59
Connector / NETVerified
(744 days)
S26.9.8Microsoft Windows (8.1)VS Entity Framework DataBase First returns Error  
645892012-03-08
5:08
2012-03-16
15:56
MySQL Server: Data TypesVerified
(2077 days)
S35.1; 5.5AnyAlphanumeric strings bring back results on integer columns - SQL mode needed!  
774032015-06-18
12:27
2015-08-04
13:23
MySQL Server: OptimizerOpen
(841 days)
S25.6.25LinuxMySQL server 5.6 consumes all memory on server when running query  
244242006-11-19
4:28
2012-05-18
20:19
MySQL Server: Data TypesVerified
(3610 days)
S15.1.11Any (ALL)CHAR data-type not space-padding Evgeny Potemkin
786972015-10-05
7:17
2016-06-18
21:28
MySQL Server: Data TypesVerified
(779 days)
S25.7.8, 5.7.10, 8.0.0, 5.6.28, 5.5.47Anyfailed cast of string-returning function to DOUBLE emits no warning  
840822016-12-06
19:01
2016-12-08
23:04
MySQL Server: JSONVerified
(349 days)
S35.7.14-google-logAnyJSON_OBJECT("k", dateTime) adds milliseconds to time  
874232017-08-15
15:14
2017-08-16
14:13
MySQL Server: InnoDB storage engineVerified
(98 days)
S25.7.18Linuxos0file.cc assertion failed 'offset > 0' in os_file_io_complete  
823082016-07-21
14:54
2016-07-21
17:54
MySQL Server: MyISAM storage engineVerified
(489 days)
S15.7Anyuse of DISTINCT with BIT and LONGTEXT leads to erroneous results  
823312016-07-25
7:11
2016-07-25
7:36
MySQL Workbench: SQL EditorVerified
(485 days)
S36.3, 6.3.7Microsoft Windows (Microsoft Windows Server 2012 R2 Standard)SQL Editor incorrectly reports an error  
800452016-01-19
9:03
2016-01-19
10:52
MySQL Server: DMLVerified
(673 days)
S35.7.8, 5.5.48, 5.6.28, 5.7.10AnySyntax error returned for invalid D in DECIMAL(M, D), ERROR 1427 expected  
762152015-03-09
1:57
2015-03-11
12:48
MySQL Server: CharsetsVerified
(987 days)
S35.5.44, 5.6.25AnyImplicit casts to string by COLLATE don't use character_set_connection  
611142011-05-10
11:02
2017-07-18
5:57
Connector / ODBCVerified
(2388 days)
S3connector 5.1.8Microsoft Windows (7)ODBC doesn't support Uint32 / Uint64 ? <-> OdbcType.Int / BigInt Bogdan Degtyariov
705982013-10-10
22:19
2013-10-13
11:23
MySQL Server: OptimizerVerified
(1501 days)
S35.5.32,5.5.34, 5.6.14, 5.7.2Linux (.6.18-348.16.1.el5)Premature expression evaluation prevents short-circuited conditionals  
831462016-09-26
7:39
2016-09-26
10:34
MySQL Server: DMLVerified
(422 days)
S35.6, 5.7Linuxtime to bit produces inconsistent results  
560252010-08-16
18:25
2011-02-16
23:44
MySQL Server: GeneralVerified
(2655 days)
S35.0.67, 5.0, 5.1, 5.6.99AnyWeird date between behavior, not consistent between versions  
811162016-04-18
2:14
2016-05-02
9:11
MySQL Server: Data TypesVerified
(583 days)
S25.6.30, 5.5.49CentOS (6.7)Evaluating between DECIMAL and string returns different result depends on index  
847012017-01-28
18:22
2017-01-30
14:36
Connector / NETVerified
(296 days)
S36.9.9Microsoft WindowsOverflow Exception - 64 bit enum value as parameter cast to Int32 Gabriela Martinez Sanchez
824162016-08-02
21:22
2016-08-08
20:12
Connector / NETVerified
(471 days)
S26.9.9Microsoft Windows (Windows 10 Pro 64 bits)Crash after update the Connector/NET  
675802012-11-13
21:57
2012-11-30
16:21
MySQL Server: DMLVerified
(1818 days)
S35.5.28, 5.5.30, 5.1.67, 5.0.97Linux (sles11)group_concat() limited to 64kb on compress()'ed fields when order by is used  
Showing all 75 (Edit, Save, CSV, Feed)