Showing all 105 (Edit, Save, CSV, Feed)
The following words were ignored: as
ID# Date Updated Type Status Sev Version OS CPU Summary
1051702021-10-08
9:03
2021-10-08
14:24
MySQL Server: Data TypesVerified
(924 days)
S35.7Any (v10)Anywrong data returned grouping on substring and bit
460372009-07-08
11:11
2018-11-04
20:45
MySQL Server: Data TypesVerified
(5399 days)
S3mysql-azalea/5.1AnyAnyInconsistent behavior when casting floating point numbers to integer
725032014-05-01
18:54
2014-11-19
15:45
MySQL Server: Data TypesVerified
(3440 days)
S25.5.37,5.5.40Linux (centos 6)Anyassert hit in sec_since_epoch when running RQG temporal
556332010-07-29
18:08
2018-09-09
20:45
MySQL Server: Data TypesVerified
(5012 days)
S35.0.51a-community, 4.1, 5.0, 5.1, 5.6.99 bzrAny (MS Windows, all)AnyStrange results from stored function
1087652022-10-13
13:52
2022-12-19
12:48
MySQL Server: Data TypesVerified
(550 days)
S28.0.31UbuntuAnycomparison of INT column with DECIMAL value changes if index is used or not
786352015-09-30
6:56
2016-06-18
21:28
MySQL Server: Data TypesVerified
(3124 days)
S35.7.8, 5.7.10, 8.0.10, 5.6.27AnyAnyNon-MySQL data types are not translated in procedure/function params
462252009-07-16
14:09
2018-11-04
20:45
MySQL Server: Data TypesVerifiedS3mysql-azaleaAnyAnyConversion from Blob/Text column value to int does not give truncation warning
496392009-12-12
10:57
2018-09-09
20:45
MySQL Server: Data TypesVerified
(5242 days)
S35.0+, 5.1+AnyAnyNULL union all with unsigned column should return unsigned type
634682011-11-29
8:12
2011-11-29
11:20
MySQL Server: Data TypesVerified
(4525 days)
S35.1/5.5AnyAnydifferent behavior for int/bigint of comparing
448742009-05-14
11:56
2018-09-09
20:45
MySQL Server: Data TypesVerified
(5450 days)
S35.0, 5.1, 6.0Linux (debian 7)Anyselect into outfile exports wrong integer width
1116752023-07-06
8:36
2023-07-07
12:17
MySQL Server: Data TypesVerified
(288 days)
S38.0AnyAnywrong result when compare timestamp with undependent subselect that return time
697962013-07-19
18:19
2014-09-18
6:24
MySQL Server: Data TypesVerified
(3728 days)
S25.5.13AnyAnyBit-shift operators produce signed integer overflow on large input
812952016-05-03
13:35
2016-05-03
16:10
MySQL Server: Data TypesVerified
(2908 days)
S35.5.49Ubuntu (15.10 (Wily))Anymain.bigint/rpl.rpl_stm_user_variables fail on Ubuntu 15.10 Wily in release mode
1143732024-03-15
16:32
2024-03-20
11:03
MySQL Server: Data TypesVerified
(30 days)
S38.0AnyAnyIncorrect result after transformation from "IN (SELECT)" to "materialization"
389152008-08-20
13:30
2020-05-03
20:45
MySQL Server: Data TypesVerified
(5721 days)
S35.0.45, 5.0.67, 5.1.26LinuxAnyLIKE query on DATETIME raises warning
545372010-06-16
0:45
2018-09-09
20:45
MySQL Server: Data TypesVerified
(5056 days)
S25.1.46, 5.1.49-bzrLinux (CENTOS5.4)Anybigint bug
687592013-03-24
12:49
2013-03-25
5:31
MySQL Server: Data TypesVerified
(4043 days)
S35.6.10AnyAnyInconsistent results on comparison a time field with a non-time literal
271562007-03-14
23:33
2018-09-09
20:45
MySQL Server: Data TypesVerified
(4913 days)
S35.0, 5.1, 5.6.99Linux (Linux)AnyNot even if strict mode will halt on warnings
434512009-03-06
10:28
2018-09-09
20:45
MySQL Server: Data TypesVerified
(5523 days)
S35.0, 5.1, 6.0 bzrLinuxAnyWrong varchar to decimal conversion
1133842023-12-09
8:05
2023-12-11
11:42
MySQL Server: Data TypesVerified
(130 days)
S38.0AnyAnyQueried with partitions,returned result is error
407472008-11-14
15:03
2020-05-03
20:45
MySQL Server: Data TypesVerified
(5635 days)
S35.0.70, 5.1.29, 6.0.7AnyAnyDuplicate datetime truncation warning if a range optimizer is used.
696662013-07-03
19:09
2014-07-22
19:40
MySQL Server: Data TypesVerified
(3559 days)
S35.5.31, 5.6.21AnyAnyStrange result types for LPAD/RPAD and CONCAT when mixing binary and non-binary
685772013-03-05
19:29
2019-12-12
16:14
MySQL Server: Data TypesVerified
(4063 days)
S35.1, 5.5, 5.6AnyAnyIncorrect enum values returned when using UNION after CREATE AS SELECT
1032892021-04-12
15:00
2021-05-11
5:28
MySQL Server: Data TypesVerified
(1074 days)
S38.0AnyAnybit type display confusing
808632016-03-27
9:38
2016-11-17
15:42
MySQL Server: Data TypesVerified
(2710 days)
S35.7.11, 5.7.16AnyAnyHandling of DST changes
807622016-03-16
11:01
2016-03-17
8:11
MySQL Server: Data TypesVerified
(2955 days)
S25.6.24-72.2-log, 5.5.48, 5.6.29, 5.7.11Ubuntu (14.04.4)Anyunion converts unsigned int to signed
786402015-09-30
8:42
2015-09-30
9:28
MySQL Server: Data TypesVerified
(3124 days)
S35.7.8, 5.5.47, 5.6.28, 5.7.10AnyAnyCAST OF 'DOUBLE' VALUE TO 'UNSIGNED' GIVES INCORRECT VALUE
660342012-07-26
19:01
2012-08-01
7:08
MySQL Server: Data TypesVerified
(4284 days)
S35.1, 5.5, 5.6AnyAnyInconsistent results while comparing time fields with string and number literals
688652013-04-04
12:17
2013-04-20
19:26
MySQL Server: Data TypesVerified
(4017 days)
S35.5AnyAnySTR_TO_DATE with %Y does not appear to work as documented
732492014-07-09
20:06
2014-07-14
17:18
MySQL Server: Data TypesVerified
(3567 days)
S35.5.36-log, 5.6.38, 5.6.20LinuxAnyInconsistent behavior when doing subtraction on columns
645892012-03-08
5:08
2012-03-16
15:56
MySQL Server: Data TypesVerified
(4417 days)
S35.1; 5.5AnyAnyAlphanumeric strings bring back results on integer columns - SQL mode needed!
337722008-01-09
14:58
2020-05-03
20:45
MySQL Server: Data TypesVerified
(5944 days)
S35.0-bk, 5.1-bkAnyAnyMonthname (string) comparison with Month (integer) succeeds where it shouldn't
811162016-04-18
2:14
2016-05-02
9:11
MySQL Server: Data TypesVerified
(2923 days)
S25.6.30, 5.5.49CentOS (6.7)AnyEvaluating between DECIMAL and string returns different result depends on index
338592008-01-14
10:57
2018-09-09
20:45
MySQL Server: Data TypesVerified
(5940 days)
S35.0.54, 5.0.45Linux (debian sid)AnyIFNULL broken for unsigned bigint values
570182010-09-25
15:32
2018-09-09
20:45
MySQL Server: Data TypesVerified
(4955 days)
S35.1.49, 5.1.52-bzrAnyAnyIncorrect result when using BETWEEN comparison on an indexed DATETIME column.
579642010-11-04
8:28
2018-09-09
20:45
MySQL Server: Data TypesVerified
(4915 days)
S35.0.91, 5.1.52, 5.5.8AnyAnymin/max(constant) in subquery gives wrong result
628612011-10-21
11:50
2011-10-25
10:17
MySQL Server: Data TypesVerified
(4564 days)
S35.1.60, 5.5.17LinuxAnyWrong data type for user-variables in MySQL 5.1
700682013-08-17
11:57
2013-08-19
14:50
MySQL Server: Data TypesVerified
(3896 days)
S35.6.11,5.6.13AnyAnyUNION ALL produces text instead of varchar
209242006-07-09
6:42
2018-09-09
20:45
MySQL Server: Data TypesVerified
(5447 days)
S2AllLinux (Linux 2.6)AnyCAST(expr as UNSIGNED) returns SIGNED value when used in various functions
345622008-02-14
18:55
2018-09-09
20:45
MySQL Server: Data TypesVerified
(5901 days)
S35.1.22-rc-logAnyAnyCAST does not accept standard-sql numeric types
397372008-09-29
20:09
2018-09-09
20:45
MySQL Server: Data TypesPatch approved
(5397 days)
S15.1.28WindowsAnyAssignment operator does not allocate memory for spatial variables
1003072020-07-23
14:08
2020-07-28
15:46
MySQL Server: Data TypesVerified
(1366 days)
S35.7.30AnyAnyJSON field datatype changes unexpectedly
665662012-08-28
7:19
2018-12-10
18:50
MySQL Server: Data TypesVerified
(4252 days)
S3AnyAnyOverflowing of auto_increment columns is not clearly indicated
495242009-12-08
5:15
2018-09-09
20:45
MySQL Server: Data TypesVerified
(5246 days)
S3mysql-next-mr(-alik), 5.0, 5.1Linux (SUSE 11.1, 2.6.27.37-0.1-default #1 SMP 2009-10-15 14:56:58 +0200 x86_64 x86_64 x86_64 GNU/Linux)Anyrejecting the maximum value of double when parsing is not enough.
263742007-02-14
17:17
2018-09-09
20:45
MySQL Server: Data TypesVerified
(5980 days)
S35.0 BK. 5.1 BKLinux (Linux)Anyinsert/update of unsigned bigint column fails when using variable larger than
492532009-12-01
9:38
2018-09-09
20:45
MySQL Server: Data TypesVerified
(5253 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.
580652010-11-08
21:31
2018-09-09
20:45
MySQL Server: Data TypesVerified
(4909 days)
S25.1.51, 5.1.52, 5.0, 5.1, 5.6.99 bzrLinux (x64, 2.6.32)Anyjoin condition handles date columns differently if there's a unique key
688642013-04-04
8:17
2013-04-04
8:37
MySQL Server: Data TypesVerified
(4033 days)
S25.6.10AnyAnyINTERVAL treats null values of text columns as float/int
792952015-11-16
15:48
2017-08-28
15:00
MySQL Server: Data TypesVerified
(2426 days)
S35.7.8AnyAnyselect cast(-1 as unsigned) returns 18446744073709551615
902722018-04-01
10:34
2018-04-04
16:03
MySQL Server: Data TypesVerified
(2207 days)
S3AnyAnyinput overflow of ZEROS returns maximum of possible value of cell
634272011-11-25
9:56
2011-12-22
19:49
MySQL Server: Data TypesVerified
(4502 days)
S25.5.11-log, 5.5.20AnyAnyresults for "not in" and "!=" for the same values are different
274752007-03-27
15:25
2013-07-17
16:02
MySQL Server: Data TypesVerified
(6227 days)
S2Mysql 5.0.37/5.BK/4.1BKWindows (Wincows/Linux)Anymysql_fetch_field do NOT report correctly certain field types
346922008-02-20
14:49
2018-09-09
20:45
MySQL Server: Data TypesVerified
(5195 days)
S35.1.23AnyAnyallow DECIMAL overflow to be reported as an error
553622010-07-19
12:19
2018-09-09
20:45
MySQL Server: Data TypesVerified
(5022 days)
S35.5.6-m3-debug, 5.0, 5.1 bzrAnyAnyMySQL does not properly evaluate NOT + NOT + IN() in WHERE
216772006-08-16
18:48
2014-02-06
14:01
MySQL Server: Data TypesVerified
(3725 days)
S34.1.21, 5.0.23Linux (Linux)AnyChange in results with "now() BETWEEN date_field1 AND date_field2"
333812007-12-19
19:27
2018-09-09
20:45
MySQL Server: Data TypesVerified
(5309 days)
S55.0.45, 5.0.52, 5.1.40LinuxAnyTemporary table created on disk when it should be in ram
401872008-10-20
19:43
2018-09-09
20:45
MySQL Server: Data TypesVerified
(5659 days)
S35.0.62, 5.1.28AnyAnybit comparison against string literal is inconsistent
431002009-02-23
7:54
2022-09-04
20:45
MySQL Server: Data TypesVerified
(5532 days)
S36.0.10, 4.1, 5.0, 5.1, 6.0 bzrAnyAnyDiscrepancy between engines MyISAM/Maria wrong? with Year(2) type
664802012-08-21
9:04
2018-11-24
8:37
MySQL Server: Data TypesVerified
(4259 days)
S35.5.27, 5.5.28Any (Squeeze)AnyMyql comparison of curtime() with a constant in utf8
885732017-11-21
3:17
2017-11-30
18:23
MySQL Server: Data TypesVerified
(2332 days)
S35.7DebianAnyNanosecond precision in INTERVAL xxx DAY_MICROSECOND parsed wrong?
1082072022-08-21
13:35
2022-08-23
13:36
MySQL Server: Data TypesVerified
(606 days)
S38.0Any (Centos, window)Anyinformation schema view return wrong data type
665232012-08-24
9:04
2013-01-15
16:39
MySQL Server: Data TypesVerified
(4243 days)
S35.6.6AnyAnyField_blob::pack - length stored incorrectly
726722014-05-16
18:17
2014-05-22
9:21
MySQL Server: Data TypesVerified
(3620 days)
S25.5.31,5.5.34, 5.7.5, 5.6.19AnyAnyZero-valued DATETIME column can be simultaneously NULL and NOT NULL
365392008-05-06
15:44
2011-02-16
23:43
MySQL Server: Data TypesVerified
(5827 days)
S25.0.38+, 5.1, 6.0AnyAnydata truncation and implicit cast return different values than explicit cast
390492008-08-26
16:18
2018-09-09
20:45
MySQL Server: Data TypesPatch pending
(5609 days)
S35.0, 5.1, 6.0AnyAnyWrong warning when comparing some decimal values to NULL
659582012-07-20
9:35
2012-07-23
10:13
MySQL Server: Data TypesVerified
(4288 days)
S35.5.24Linux (Ubuntu Server 12.04)Anyen_ZA number format incorrect
1055172021-11-10
13:36
2021-11-10
14:36
MySQL Server: Data TypesVerified
(891 days)
S28.0Any (20.0.4.1)AnyINSERT of CURRENT_TIMESTAMP() vs. DEFAULT differs for TIMESTAMP field
404542008-10-31
11:03
2022-12-04
20:45
MySQL Server: Data TypesVerified
(5649 days)
S35.1.26/5.0/6.0AnyAnyText types allow setting of default value
450042009-05-21
8:46
2018-09-09
20:45
MySQL Server: Data TypesVerified
(5447 days)
S25.0.81, 5.0.83-bzrAnyAnyDate Value
642242012-02-03
22:15
2016-02-04
10:22
MySQL Server: Data TypesVerified
(4458 days)
S25.1.52, 5.1.56, 5.5.20, 5.6.28AnyAnybug in fractional part of unsigned decimals
972172019-10-14
13:43
2019-10-15
14:04
MySQL Server: Data TypesVerified
(1649 days)
S3AnyAnyUUID() generates duplicate GUID inside COALESCE
244242006-11-19
4:28
2020-05-03
20:45
MySQL Server: Data TypesVerified
(5950 days)
S15.1.11Any (ALL)AnyCHAR data-type not space-padding
925402018-09-24
8:01
2018-09-24
8:57
MySQL Server: Data TypesVerified
(2034 days)
S35.7, 8.0.12, 5.7.23, 5.6.41AnyAnyComparison between DATE and DECIMAL does not round nanoseconds
700912013-08-20
12:30
2013-08-21
17:26
MySQL Server: Data TypesVerified
(3894 days)
S25.6.13Linux (Ubuntu x86_64)Anytinyint(1) column type returned by jdbc connector becomes Integer with ORDER BY
732402014-07-09
10:26
2014-07-09
14:09
MySQL Server: Data TypesVerifiedS35.6.19AnyAnyEXTRACT function with DAY_HOUR does not return the day part.
1058192021-12-07
9:48
2021-12-07
14:38
MySQL Server: Data TypesVerified
(864 days)
S38.0AnyAnyConversion from Blob/Text column value to double does not return a truncation er
310132007-09-14
4:04
2018-09-09
20:45
MySQL Server: Data TypesVerified
(6062 days)
S35.0bk, 5.1bkAnyAnyFractions used with INTERVAL are rounded without error or warning
680622013-01-09
21:35
2016-02-25
12:24
MySQL Server: Data TypesVerifiedS35.6.8-rcAnyAnyTIME_TO_SEC() doesn't support fractional seconds
983052020-01-21
10:57
2020-08-04
12:41
MySQL Server: Data TypesVerified
(1542 days)
S55.7, 8.0LinuxAnyhp_rec_key_cmp suboptimal comparison
895802018-02-08
2:57
2018-02-08
14:28
MySQL Server: Data TypesVerified
(2262 days)
S35.7.19AnyAnyWrong results of XOR expression
707322013-10-26
14:17
2016-10-27
7:42
MySQL Server: Data TypesVerified
(3822 days)
S35.5, 5.6Linux (UBUNTU 12.4)Anyhex-literals in querys
574262010-10-13
9:26
2011-02-16
23:44
MySQL Server: Data TypesVerified
(4937 days)
S35.5AnyAnyMark tables containing old DECIMAL data type as corrupt in 5.5.
686882013-03-16
0:45
2013-03-19
2:46
MySQL Server: Data TypesVerified
(4049 days)
S25.5.8-logWindows (Vista)AnyIFNULL of SET & ENUM less sensitive than IF to numeric context
692282013-05-14
14:56
2022-05-23
9:39
MySQL Server: Data TypesVerified
(3993 days)
S25.6, probably since 4.1AnyAnyLast insert ID incorrectly delivered to the client
707692013-10-30
8:40
2013-10-30
9:19
MySQL Server: Data TypesVerified
(3824 days)
S25.6.10, 5.5.34, 5.6.14AnyAnyPROCEDURE ANALYSE() gives invalid datatype for expressions
487692009-11-13
22:46
2018-09-09
20:45
MySQL Server: Data TypesVerified
(5270 days)
S35.0.88, 5.1.40AnyAnyinconsistent warnings/errors depending on index usage and engine
640582012-01-18
14:14
2012-01-19
14:05
MySQL Server: Data TypesVerified
(4474 days)
S2 5.5.20MacOS (10.7.2)AnyDATETIME data type botched in queries.
44852004-07-09
14:23
2018-09-09
20:45
MySQL Server: Data TypesVerified
(5681 days)
S3AllLinux (Linux)AnyFloating point conversions are inconsistent.
70832004-12-07
20:30
2017-11-11
19:11
MySQL Server: Data TypesVerified
(3754 days)
S35.0.3-alpha-debugLinux (SuSE 9.1)AnyCHAR columns should report correct length
288862007-06-04
22:01
2014-04-10
15:59
MySQL Server: Data TypesVerified
(3662 days)
S35.1, 5.5, 5.6, 5.7AnyAnyUnion, Sort and Enum
384572008-07-30
12:38
2018-09-09
20:45
MySQL Server: Data TypesVerifiedS34.1, 5.0, 5.1, etcAnyAnyNOW() loses time information when writing to TIMESTAMP field
669372012-09-23
21:27
2012-12-14
17:38
MySQL Server: Data TypesVerified
(4144 days)
S35.5AnyAnyreturn type from nullif is described incorrectly as string type
681922013-01-27
20:52
2013-01-28
15:40
MySQL Server: Data TypesVerified
(4099 days)
S35.1, 5.5, 5.6.9AnyAnyLimitation on DOUBLE or REAL length is ignored with INSERT .. SELECT
690422013-04-23
16:31
2017-07-13
18:49
MySQL Server: Data TypesVerified
(4013 days)
S35.1.68, 5.5.31, 5.6.11AnyAnyMEDIUMINT precision/type incorrect in INFORMATION_SCHEMA.COLUMNS
757762015-02-05
0:30
2015-02-05
20:04
MySQL Server: Data TypesVerified
(3361 days)
S25.6.15AnyAnyME ELIMINATES ZEROFILL.
769132015-05-02
11:13
2016-08-05
13:27
MySQL Server: Data TypesVerified
(3238 days)
S35.5, 5.6, 5.7, 8.0AnyAnysuspicious code in str_to_datetime
769352015-05-04
23:41
2015-05-05
11:03
MySQL Server: Data TypesVerified
(3272 days)
S35.6, 5.7.7, 5.1.75, 5.5.45, 5.6.26, 5.7.8AnyAnymysql strict mode is inconsistent with error 1366 - invalid chars
845582017-01-18
17:07
2017-01-18
19:36
MySQL Server: Data TypesVerified
(2648 days)
S35.5/5.6/5.7/8.0AnyAnyCast to NUMERIC not working
856412017-03-27
9:17
2017-03-27
15:49
MySQL Server: Data TypesVerified
(2580 days)
S35.7.17AnyAnyMySQL is not consequent in handling non existing time between 2 and 3 o'clock
896692018-02-14
14:11
2018-02-16
17:53
MySQL Server: Data TypesVerified
(2254 days)
S3AnyAnystr_to_date do not return the correct first day of 2018
916652018-07-16
13:45
2018-07-23
17:33
MySQL Server: Data TypesVerified
(2101 days)
S38.0.11Windows (Windows 7)Other (x64)CTE misbehaves with 38 digit keys
966082019-08-21
18:53
2020-02-06
13:38
MySQL Server: Data TypesVerified
(1535 days)
S35.7.23, 5.7.27DebianAnyMishandled timezone conversions on timestamps
1055152021-11-10
13:10
2023-10-23
13:34
MySQL Server: Data TypesVerified
(891 days)
S38.0Any (20.0.4.1)AnyTimezone offsets in TIMESTAMP literals broken in DST timezone
1076082022-06-20
10:54
2022-06-20
11:56
MySQL Server: Data TypesVerified
(669 days)
S18.0.25, 8.0.29AnyAnyResults not satisfy expectations with zerofill fields
1128482023-10-27
2:28
2023-10-27
11:37
MySQL Server: Data TypesVerified
(175 days)
S38.0AnyAnyItem_func_set_user_var::get_string_value may have potion risk of memory access
Showing all 105 (Edit, Save, CSV, Feed)