| Showing all 167 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 118750 | 2025-07-30 3:33 | 2025-09-21 20:45 | MySQL Server: Prepared statements | Analyzing (222 days) | S3 | 9.3.0 | Any | Any | binary comparison has different results in prepared statement and normal SELECT query |
| 86043 | 2017-04-22 2:23 | 2018-10-21 20:45 | Connector / NET | Analyzing (3241 days) | S1 | 6.8.8 | Any | Any | Can't use BigInt or Double as userId instead of Int32 (default) |
| 74196 | 2014-10-02 16:37 | 2017-04-30 20:45 | Connector / NET | Analyzing (3814 days) | S3 | 6.9.2 | Windows | Any | Extraneous / unnecessary column output in derived tables (i.e. `Filter1`, etc.) |
| 61472 | 2011-06-10 7:26 | 2025-10-12 20:45 | Connector / ODBC | Analyzing (5348 days) | S1 | 5.1.8 | Windows (XP SP3) | Any | "Specified cast is not valid" error even when datatypes are perfectly aligned |
| 120011 | 2026-03-09 10:29 | 2026-03-09 10:29 | MySQL Server: Optimizer | Open | S1 | 8.0.44 | Any | Any | The normal query generated a non-optimal query plan with index. |
| 119238 | 2025-10-27 7:31 | 2026-01-23 7:48 | MySQL Server: Compiling | Open (45 days) | S3 | 8.0.45 | MacOS (26.0.1) | ARM | Compilation error with clang 20 |
| 119239 | 2025-10-27 7:53 | 2026-01-23 10:19 | MySQL Server: Compiling | Open (45 days) | S3 | 8.0.45, 8.4.8 | MacOS (26.0.1) | ARM | Compilation error with clang 21 |
| 119246 | 2025-10-27 15:02 | 2026-01-23 12:14 | MySQL Server: Compiling | Open (45 days) | S3 | 8.4.8, 9.6.0 | MacOS (26.0.1) | ARM | 9.5.0 compilation error with LLVM 21 |
| 119369 | 2025-11-12 9:10 | 2026-01-20 7:17 | MySQL Server: SYS Schema | Open (48 days) | S3 | MySQL 8.0 | Any | Any | MySQL 8.0 sys.x$innodb_lock_waits has Unnecessary type conversion |
| 119513 | 2025-12-05 1:27 | 2025-12-08 1:12 | MySQL Router | Open (91 days) | S2 | 8.0.40 | Linux (Rocky Linux 8.10 (Green Obsidian)) | x86 | MySQL Router SSL Error Leading to Crash |
| 119242 | 2025-10-27 12:13 | 2025-10-27 12:35 | MySQL Server: Compiling | Open (133 days) | S3 | 8.4.7 | MacOS (26.0.1) | ARM | 8.4.7 fails to build with clang 21 |
| 48238 | 2009-10-22 17:38 | 2012-05-18 20:19 | Tests: Server | Verified | S3 | 5.1.40 | Other (AIX + HP-UX, 32 bit) | Any | Test "partition_alter4_innodb" fails due to "Out of memory" |
| 106437 | 2022-02-10 23:42 | 2023-03-07 6:03 | MySQL Server: Row Based Replication ( RBR ) | Verified | S2 | 8.0.28 | Any | Any | need an option to let applier thread ignore virtual columns on replica.. |
| 119955 | 2026-02-27 5:03 | 2026-03-02 12:46 | MySQL Server: Optimizer | Verified (7 days) | S3 | 8.0.43 (MySQL Community Server - GPL) | Any (Docker container) | Any (x86_64) | Semantically equivalent scalar expressions yield different result sets in WHERE clause involving RPAD() |
| 119927 | 2026-02-20 10:28 | 2026-02-25 8:56 | MySQL Server: Optimizer | Verified (12 days) | S2 | 8.0.45 | Linux | Any | Inconsistent results between direct query and derived table with BIGINT column and FLOAT predicate (IN clause) |
| 118278 | 2025-05-27 8:29 | 2026-02-06 13:01 | MySQL Server: Optimizer | Verified (31 days) | S3 | 8.0.41 | Any | Any | two query SQL statements filling with opposite semantics in the where clause, result same result |
| 118336 | 2025-06-03 8:24 | 2026-02-06 12:26 | MySQL Server: Optimizer | Verified (31 days) | S3 | 8.0.41 | Any | Any | after adding a having clause equivalent to "having 1", the returned result set is wrong |
| 118393 | 2025-06-09 1:36 | 2026-02-05 22:47 | MySQL Server: Optimizer | Verified (32 days) | S3 | 8.0.41 | Any | Any | while the having subquery return NULL actually, the query using this having query returns a wrong result. |
| 119793 | 2026-01-27 10:32 | 2026-02-04 16:32 | MySQL Server: Prepared statements | Verified (33 days) | S1 | 9.5.0 | Any | Any | Incorrect result of prepared SELECT when running with JDBC |
| 119823 | 2026-02-01 11:42 | 2026-02-02 3:55 | MySQL Server: Optimizer | Verified (35 days) | S3 | 8.0.44 | Any | Any | drop index can lead to different results |
| 119802 | 2026-01-28 13:49 | 2026-01-28 15:52 | MySQL Server: Optimizer | Verified (40 days) | S2 | 8.0.42+ | Any | Any | Assertion 'is_nullable()' failed in Item_typecast_signed::val_int() |
| 119790 | 2026-01-27 10:14 | 2026-01-27 12:07 | MySQL Server: Optimizer | Verified (41 days) | S1 | 8.0.44 | Any | Any | Unexpected result of expression IN NULL |
| 119741 | 2026-01-22 7:00 | 2026-01-22 8:35 | MySQL Server: Optimizer | Verified (46 days) | S1 | 8.0.44 | Any | Any | internal_tmp_mem_storage_engine = MEMORY setting makes the DISTINCTROW returns incorrect result on 0 and -0 |
| 119752 | 2026-01-22 15:08 | 2026-01-22 21:36 | MySQL Server: Optimizer | Verified (46 days) | S3 | 8.0.44 | Any | Any | after changing MINUTE(subq.c1) to MINUTE(subq.c1 + INTERVAL '60' MINUTE),the result become empty. |
| 119716 | 2026-01-19 1:36 | 2026-01-19 9:16 | MySQL Server: Optimizer | Verified (49 days) | S1 | 8.0.44 | Any | Any | Suboptimal query plan generated by normal query compare to prepared statement |
| 119692 | 2026-01-16 5:23 | 2026-01-16 8:09 | MySQL Server: Optimizer | Verified (52 days) | S1 | 8.0.44 | Any | Any | The normal query generated a non-optimal query plan. |
| 119670 | 2026-01-13 13:46 | 2026-01-13 14:51 | MySQL Server: Optimizer | Verified (55 days) | S1 | 8.0.44 | Any | Any | Incorrect result caused by index |
| 119669 | 2026-01-13 13:27 | 2026-01-13 14:53 | MySQL Server: Optimizer | Verified (55 days) | S1 | 8.0.44 | Any | Any | Inconsistent behaviour between normal query and prepared statement |
| 119650 | 2026-01-09 2:04 | 2026-01-09 7:34 | MySQL Server: Optimizer | Verified (59 days) | S1 | 9.5.0 | Any | Any | IN operator returns unexpected result when one of values in the list is NULL |
| 119354 | 2025-11-10 15:51 | 2025-12-06 21:52 | MySQL Server: Optimizer | Verified (93 days) | S3 | 9.4.0 8.4.6 | Any | Any | IN subquery evaluates incorrectly when using IFNULL and CAST AS DATETIME |
| 119346 | 2025-11-10 9:43 | 2025-11-20 12:40 | MySQL Server: Optimizer | Verified (109 days) | S3 | 8.0 | Any | Any | CASE expression evaluates incorrectly |
| 119363 | 2025-11-12 2:52 | 2025-11-12 3:10 | MySQL Server: Optimizer | Verified (117 days) | S3 | 9.4.0 8.4.6 | Any | Any | Complex WHERE Expression on Indexed FLOAT Column Evaluates Incorrectly |
| 113113 | 2023-11-16 20:26 | 2025-10-28 10:13 | MySQL Server: Compiling | Verified (132 days) | S3 | 8.0.41 | MacOS | Any | Build failure with Homebrew LLVM 14-19 on macOS |
| 118161 | 2025-05-12 6:57 | 2025-10-27 6:49 | MySQL Server: Compiling | Verified (133 days) | S3 | 8.0.43 | MacOS (15.4.1) | ARM | Having Homebrew-installed googletest breaks build |
| 118858 | 2025-08-20 8:51 | 2025-09-23 4:03 | MySQL Server: Optimizer | Verified (167 days) | S2 | 9.2.0 | Linux | Any | Inconsistency between the results returned by MySQL and other vendors' database systems was found during differentiation |
| 118544 | 2025-06-27 14:18 | 2025-09-23 4:03 | MySQL Server: Optimizer | Verified (167 days) | S2 | 9.2.0 , 9.3.0 | Linux | Any | A potential join operator bug |
| 119032 | 2025-09-18 7:52 | 2025-09-23 0:51 | MySQL Server: Optimizer | Verified (168 days) | S2 | 9.2.0 | Any | Any | Inconsistency with MySQL 8.0.36 in MySQL 9.2.0: Equivalent INTERSECT query does not match INNER JOIN result and returns |
| 119035 | 2025-09-18 10:11 | 2025-09-23 0:48 | MySQL Server: Optimizer | Verified (168 days) | S3 | 9.4.0 8.4.6 | Any | Any | Incorrect result for BETWEEN with mixed types on a BINARY column with a UNIQUE key |
| 119033 | 2025-09-18 9:16 | 2025-09-23 0:51 | MySQL Server: Optimizer | Verified (168 days) | S3 | 9.4.0 8.4.6 | Any | Any | Incorrect filtering when comparing a BINARY-cast integer to a BIT column with a UNIQUE key |
| 118949 | 2025-09-05 13:57 | 2025-09-10 0:42 | MySQL Server: Optimizer | Verified (182 days) | S2 | 9.2.0 | Linux (ubuntu 20.04) | Any | MySQL 9.2.0: Complex CASE in JOIN makes INNER vs INTERSECT yield different rows |
| 118299 | 2025-05-29 6:57 | 2025-08-21 2:18 | MySQL Server: InnoDB storage engine | Verified (200 days) | S2 | 8.0.42, 8.4.5 | Any | Any | Multi-valued Index on Composite Key Returns Incomplete Results for Rows with Empty JSON Array('[]') |
| 118833 | 2025-08-14 2:43 | 2025-08-19 0:36 | MySQL Server: Optimizer | Verified (202 days) | S3 | 8.0.41 | Any | Any | Two queries that use the where clause with opposite semantics return the same result. |
| 118837 | 2025-08-14 3:05 | 2025-08-18 23:51 | MySQL Server: Optimizer | Verified (203 days) | S3 | 8.0.41 | Any | Any | After having(col) in the query statement is changed to having min(col), the returned result is incorrect. |
| 118836 | 2025-08-14 3:01 | 2025-08-18 23:56 | MySQL Server: Optimizer | Verified (203 days) | S3 | 8.0.41 | Any | Any | adding a having clause that return 1/TRUE, the query returns a different and wrong empty result. |
| 118839 | 2025-08-14 3:13 | 2025-08-18 23:50 | MySQL Server: DML | Verified (203 days) | S3 | 8.0.41 | Any | Any | a query including the having subclause that returns NULL, return a wrong nonempty result. |
| 118621 | 2025-07-09 12:39 | 2025-07-09 14:19 | MySQL Server: Optimizer | Verified (243 days) | S3 | 9.3.0, 8.0.42 | Any | Any | subquery_to_derived optimizer makes query produce incorrect result |
| 118063 | 2025-04-27 19:02 | 2025-04-28 7:39 | MySQL Server: Optimizer | Verified (315 days) | S1 | 9.0, 8.0, 8.0.42, 8.4.5, 9.3.0 | Any | Any | Wrong Join Result after creating index on expressions |
| 118053 | 2025-04-24 15:47 | 2025-05-19 2:25 | MySQL Server: DML | Verified (318 days) | S2 | 8.4.3, 9.3.0, 8.4.5, 8.0.42 | CentOS | Any | cast((NULLIF) as datetime) returns incorrect result |
| 117927 | 2025-04-10 6:25 | 2025-04-10 7:35 | MySQL Server: JSON | Verified (333 days) | S2 | 8.0.41, 8.4 | Any | Any | duplicate key in table while using tmp table for group by a json data |
| 117714 | 2025-03-14 15:36 | 2025-03-21 1:11 | MySQL Server: Optimizer | Verified (356 days) | S2 | 5.7.42 | Any | Any | Incorrect row filtering when using CAST(... AS DATE) adding an AND condition. |
| 117131 | 2025-01-08 7:52 | 2025-01-09 9:20 | MySQL Server: DML | Verified (424 days) | S3 | 8.4.1, 8.0.40 | Windows (windows 11) | x86 (x86_64) | Query results don't match expectations with FIELD function in predicate. |
| 117128 | 2025-01-08 5:42 | 2025-01-13 9:23 | MySQL Server: DML | Verified (425 days) | S3 | 8.4.1, 8.0.40 | Windows (windows 11) | x86 | Query results do not meet expectations when the predicate involves CAST AS FLOAT and >> operator |
| 117130 | 2025-01-08 7:03 | 2025-01-08 7:50 | MySQL Server: Parser | Verified (425 days) | S3 | 9.1.0 | Any | Any | error occurs when using cast collate binary |
| 117096 | 2025-01-02 8:43 | 2025-01-02 11:59 | MySQL Server: DML | Verified (431 days) | S3 | 8.4.1, 8.0.40 | Windows (windows 11) | x86 (x86_64) | The result of using CAST AS DOUBLE in the query does not meet expectations. |
| 117091 | 2025-01-01 15:26 | 2025-01-02 7:37 | MySQL Server: DML | Verified (431 days) | S3 | 8.4.3, 8.0.40 | Windows (windows 11) | x86 (x86_64) | Using two mutually exclusive predicates as WHERE conditions returned the same result. |
| 117089 | 2025-01-01 8:37 | 2025-01-01 9:29 | MySQL Server: DML | Verified (432 days) | S3 | 8.4.1, 8.0.40 | Windows (windows 11) | x86 (x86_64) | Inconsistent results using equivalent predicates in two queries. |
| 116846 | 2024-12-02 14:42 | 2024-12-04 15:06 | MySQL Server: Data Types | Verified (460 days) | S3 | 8.0 | Any | Any | The logical error of the NULLIF function in the WHERE condition. |
| 116775 | 2024-11-25 18:34 | 2024-11-28 8:00 | MySQL Server: Optimizer | Verified (466 days) | S5 | 596f0d23 (9.0.0), 8.0.40 | Any | Any | Performance of TPC-DS Query 16 |
| 116723 | 2024-11-20 7:35 | 2024-11-20 8:45 | MySQL Server: Optimizer | Verified (474 days) | S2 | 8.4.2, 8.0.40 | Any | Any | Issues with explicit type casting using CAST. |
| 116726 | 2024-11-20 8:22 | 2024-11-20 8:50 | MySQL Server: Optimizer | Verified (474 days) | S1 | 8.4.2, 8.0.40 | Any | Any | Issues with the combination of CAST and DATE. |
| 116724 | 2024-11-20 7:44 | 2024-11-20 8:49 | MySQL Server: Optimizer | Verified (474 days) | S1 | 8.4.2, 8.0.40 | Any | Any | Issues with CASE statements |
| 116725 | 2024-11-20 7:44 | 2024-11-20 8:54 | MySQL Server: Optimizer | Verified (474 days) | S1 | 8.4.2, 8.0.40 | Any | Any | Issues with CASE statements. |
| 116335 | 2024-10-10 16:53 | 2025-09-10 1:54 | MySQL Server: Optimizer | Verified (514 days) | S5 | 8.0.39 | Any | Any | Multi-valued index isn't used with some range scans on composite indexes |
| 115778 | 2024-08-06 6:24 | 2024-08-07 7:17 | MySQL Server: DML | Verified (579 days) | S3 | 8.4.0, 8.0 | Any | Any | Cast DATE_ADD/SUB result as double get wrong result. |
| 115471 | 2024-07-01 5:04 | 2024-07-04 8:23 | MySQL Server: Compiling | Verified (613 days) | S3 | 8.0.37, 8.4.0 | MacOS (14.5) | ARM | Linker errors with enabled LTO |
| 115085 | 2024-05-22 20:39 | 2024-06-27 8:11 | MySQL Server: DML | Verified (655 days) | S2 | 8.0.34, 8.4.0 | Any (Docker Image) | x86 | INDEX using CAST (json_column) AS ARRAY drops rows containing empty array |
| 114380 | 2024-03-17 13:19 | 2024-03-20 11:21 | MySQL Server: DML | Verified (721 days) | S3 | 8.0.13, 8.0.35, 8.0.36 | Any | Any | Incorrect query result may caused by TIMESTAMP |
| 114217 | 2024-03-05 4:48 | 2024-03-05 7:01 | MySQL Server: DML | Verified (734 days) | S2 | 8.2.0, 8.3.0, 8.0.36 | Any | Any | Unexpected Results by Minus Sign |
| 113768 | 2024-01-26 2:40 | 2024-01-26 8:53 | MySQL Server: DML | Verified (773 days) | S3 | 8.0.35 | Linux | Any | return error with cast |
| 112816 | 2023-10-24 16:15 | 2023-12-13 12:00 | MySQL Server: Optimizer | Verified (857 days) | S2 | 8.0, 8.1 | Any | Any | Inconsistent results when JOINed in different order |
| 112910 | 2023-11-01 7:20 | 2023-11-01 7:31 | MySQL Server: Optimizer | Verified (859 days) | S2 | 8.1.0, 8.0.35 | Any | Any | Incorrect results when add an uncorrelated row |
| 112053 | 2023-08-12 19:55 | 2023-08-21 12:36 | MySQL Server: JSON | Verified (936 days) | S3 | 8.0 | Any | Any | COALESCE a null value with a JSON object returns hex string |
| 111918 | 2023-07-30 6:12 | 2023-07-31 6:33 | MySQL Server: Optimizer | Verified (952 days) | S3 | 8.1.0, 8.0.34, 5.7.43 | Ubuntu (22.04) | x86 (x86_64) | Auto increment column query wrong result |
| 110988 | 2023-05-11 8:06 | 2023-07-10 13:11 | MySQL Server: Optimizer | Verified (973 days) | S3 | 8.0.33 | Ubuntu (22.04) | x86 (x86_64) | VIEW call error |
| 111415 | 2023-06-14 9:39 | 2023-06-19 14:12 | MySQL Server: Optimizer | Verified (994 days) | S3 | 8.0 | Any | Any | Correlated group query wrong result |
| 111310 | 2023-06-07 6:51 | 2023-06-08 8:30 | MySQL Server: Prepared statements | Verified (1005 days) | S3 | 8.0.33 | Ubuntu (22.04) | x86 (x86_64) | Prepared statement with CTE memory leak |
| 110751 | 2023-04-20 15:50 | 2023-04-25 17:14 | MySQL Router | Verified (1050 days) | S3 | 8.0.33 and 8.0.33 | Red Hat ( 8.4 (Ootpa)) | x86 | rhel8 rpm : mysqlrouter 8.0.33 aborts initial connection |
| 110681 | 2023-04-13 11:53 | 2023-04-13 13:27 | Connector / J | Verified (1061 days) | S3 | 8.0.32 | Any | Any | Setting rewriteBatchedStatements=true with multi-host connections bug |
| 110563 | 2023-03-30 8:21 | 2023-03-30 8:48 | MySQL Server: Optimizer | Verified (1075 days) | S3 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | NULL safe equality operator query with wrong result |
| 110556 | 2023-03-30 2:46 | 2023-03-30 6:19 | MySQL Server: JSON | Verified (1075 days) | S2 | 8.0.28, 8.0.32 | Linux | Any | When we use json to build an index, we will get wrong results |
| 110322 | 2023-03-09 11:41 | 2023-03-09 12:31 | MySQL Server: Optimizer | Verified (1096 days) | S3 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | Binary column primary key query with wrong result |
| 110301 | 2023-03-08 11:13 | 2023-03-09 12:30 | MySQL Server: Optimizer | Verified (1096 days) | S3 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | Change column wrong result |
| 110310 | 2023-03-09 8:41 | 2023-04-29 15:24 | MySQL Server: Optimizer | Verified (1096 days) | S3 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | BETWEEN query with wrong result |
| 110250 | 2023-03-01 11:59 | 2023-03-24 11:16 | MySQL Server: Optimizer | Verified (1098 days) | S3 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | Right join query with wrong result |
| 109824 | 2023-01-27 15:43 | 2023-01-28 8:04 | MySQL Server: Optimizer | Verified (1136 days) | S3 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | Bit query with wrong result |
| 109736 | 2023-01-23 10:41 | 2023-01-25 7:41 | MySQL Server: Optimizer | Verified (1139 days) | S2 | 8.0.32 | Ubuntu (22.04) | x86 (x86_64) | ANY query with wrong result |
| 109608 | 2023-01-12 15:11 | 2023-01-24 11:39 | MySQL Server: Optimizer | Verified (1140 days) | S3 | 8.0.31 | Ubuntu (22.04) | x86 (x86_64) | Exists query with wrong result |
| 108563 | 2022-09-21 9:36 | 2022-09-21 9:40 | MySQL Server: DDL | Verified (1265 days) | S3 | 8.0.28, 8.0.30 | Any | Any | Cannot create json index in procedure |
| 108500 | 2022-09-15 20:03 | 2022-09-16 10:32 | Connector / J | Verified (1270 days) | S2 | 8.0.30 | Any | x86 | updateBlob fails with ClassCastException when replication is in use |
| 108357 | 2022-09-01 4:10 | 2022-09-05 4:22 | MySQL Server: DDL | Verified (1281 days) | S3 | 8.0.26, 5.7.39, 8.0.30 | Any | Any | inconsistent behavior about the cast function and modify column |
| 107645 | 2022-06-24 3:00 | 2022-06-28 13:48 | MySQL Server: DML | Verified (1354 days) | S3 | 5.7.38, 8.0.29 | Any | Any | the cast function gets an incorrect result if with wrong encoding |
| 106654 | 2022-03-07 12:06 | 2022-03-10 14:01 | MySQL Server: Optimizer | Verified (1460 days) | S5 | 8.0 | Any | Any | join on json key can not use index, but join on virtual column can use index |
| 106225 | 2022-01-20 9:54 | 2023-02-15 7:31 | MySQL Server: DML | Verified (1509 days) | S3 | 5.7, 8.0, 8.0.32 | Any | Any | select bin("") should return 0 instead of null |
| 105875 | 2021-12-13 9:40 | 2021-12-13 10:52 | Shell General / Core Client | Verified (1547 days) | S1 | 8.0.27 | Any | Any | Unexpected output for CAST('2000' AS YEAR) when using MySQL Shell |
| 105783 | 2021-12-03 3:18 | 2023-10-21 9:37 | MySQL Server: DML | Verified (1557 days) | S2 | 8.0, 5.7 | MacOS | x86 | `datetime <cmp> int` returns different result in different SQLs |
| 105652 | 2021-11-22 4:41 | 2021-11-23 14:20 | MySQL Server: InnoDB storage engine | Verified (1568 days) | S2 | 5.7, 8.0 | Any | Any | buffer pool flush_rbt could be disorded with innodb tablespace > 32TB |
| 105379 | 2021-10-29 9:28 | 2021-10-29 10:21 | MySQL Server: DML | Verified (1592 days) | S3 | 8.0, 5.7 | MacOS | x86 | select greatest("2020-12-12 12:12:12a", cast("2020-12-12 12:12:12" as datetime)) |
| 105355 | 2021-10-28 8:33 | 2021-11-29 13:09 | MySQL Server: Optimizer | Verified (1593 days) | S3 | 5.7.36, 8.0.27 | MacOS | x86 | time <cmp> string returns wrong result |
| 88033 | 2017-10-09 18:38 | 2021-06-06 8:13 | MySQL Server: JSON | Verified (1737 days) | S3 | 8.0.24, 5.7.19 | Any | Any | Generated INT column with value from JSON document |
| 102827 | 2021-03-05 13:57 | 2021-03-09 13:32 | MySQL Workbench: SQL Editor | Verified (1826 days) | S1 | 8.0.23 | Windows (Microsoft Windows 10 Enterprise) | Any | beautifying SQL script |
| 102873 | 2021-03-09 7:23 | 2021-03-09 9:38 | MySQL Server: DML | Verified (1826 days) | S3 | 8.0.23 | Any | Any | implicit cast WHERE datetime_column = 0 not producing Incorrect DATETIME value |
| 102831 | 2021-03-05 16:32 | 2021-04-19 6:39 | MySQL Server: InnoDB storage engine | Verified (1829 days) | S2 | 5.7.31, 5.7.33 | Any (CentOS, Ubuntu) | Any | transaction-isolation level is not honored when changed at session level |
| 102601 | 2021-02-15 13:42 | 2021-02-16 9:14 | MySQL Server: JSON | Verified (1847 days) | S3 | 5.7.31, 5.7.33 | CentOS (CentOS Linux release 7.6.1810 (Core)) | Any | nested nullif of json values fails |
| 102224 | 2021-01-11 23:14 | 2021-01-18 13:05 | MySQL Server: InnoDB storage engine | Verified (1879 days) | S3 | 8.0 | Any | Any | dtuple_get_nth_field is not const clean |
| 102086 | 2020-12-29 12:06 | 2020-12-31 1:15 | MySQL Server: DML | Verified (1894 days) | S3 | 8.0.18 | Red Hat (7.4) | Any | the result of order by cast(field1 as char) is unexpect. |
| 101945 | 2020-12-09 22:03 | 2020-12-10 5:02 | MySQL Server: JSON | Verified (1915 days) | S3 | 5.7.31, 8.0.22 | Any | Any | JSON Unsigned Integer out of range for Unsigned Bigint column |
| 101704 | 2020-11-21 5:02 | 2020-11-21 7:48 | MySQL Workbench: Modeling | Verified (1934 days) | S3 | 8.0.22 | Windows (Microsoft Windows 10 Pro) | x86 | JSON type in CAST() and CONVERT() is recognized as error in model editors |
| 100985 | 2020-09-29 7:42 | 2020-09-29 9:18 | MySQL Server: Optimizer | Verified (1987 days) | S3 | 8.0.21, 5.7.31, 5.6.48 | Any | Any | Stored value for 0.001 is inconsistent, and casted to decimal is also different |
| 100608 | 2020-08-21 18:25 | 2023-08-23 12:42 | MySQL Workbench: SQL Editor | Verified (2016 days) | S3 | 8.0.21, 8.0.31, 8.0.32, 8.0.33 | MacOS | x86 | Beautify query doesn't work when CAST(<field>) AS DOUBLE is used |
| 100567 | 2020-08-19 3:37 | 2020-08-27 11:24 | MySQL Server: JSON | Verified (2028 days) | S3 | 8.0, 8.0.21, 8.0.11 | Any | Any | Unexpected cast to float from attribute of a JSON datum |
| 95964 | 2019-06-24 22:23 | 2020-03-30 15:38 | MySQL Server: Memory storage engine | Verified (2170 days) | S3 | 8.0.16, 5.7.26, 5.6.44 | Ubuntu | x86 | Compare that uses UNSIGNED cast and function malfunctions in the MEMORY engine |
| 96983 | 2019-09-24 6:43 | 2019-09-25 8:56 | MySQL Workbench: Modeling | Verified (2357 days) | S3 | 8.0.17 | Any | Any | can not CAST( anything AS JSON) in stored routines , triggers |
| 95957 | 2019-06-24 16:26 | 2019-06-25 5:15 | MySQL Server: Optimizer | Verified (2449 days) | S3 | 8.0.16, 5.7.26, 5.6.44 | Ubuntu | x86 | IN operator issue when comparing signed column and the column cast to unsigned |
| 94925 | 2019-04-06 0:15 | 2019-04-24 13:37 | MySQL Server: Performance Schema | Verified (2511 days) | S3 | 8.0.15 | Any | Any | Wrong Query Sample Text in Performance Query |
| 93010 | 2018-10-30 14:40 | 2018-10-30 20:23 | MySQL Server: JSON | Verified (2687 days) | S3 | 8.0.13 | Any | Any | JSON_SET() does not create intermediate objects |
| 92440 | 2018-09-15 21:02 | 2018-09-17 12:39 | MySQL Visual Studio Integration | Verified (2730 days) | S3 | 8.0 | Windows | Any | mysql 8.0 and VS 2017 - editing trigger fails with 'unable to load object' |
| 79295 | 2015-11-16 15:48 | 2017-08-28 15:00 | MySQL Server: Data Types | Verified (3115 days) | S3 | 5.7.8 | Any | Any | select cast(-1 as unsigned) returns 18446744073709551615 |
| 84558 | 2017-01-18 17:07 | 2017-01-18 19:36 | MySQL Server: Data Types | Verified (3337 days) | S3 | 5.5/5.6/5.7/8.0 | Any | Any | Cast to NUMERIC not working |
| 84082 | 2016-12-06 19:01 | 2016-12-08 23:04 | MySQL Server: JSON | Verified (3378 days) | S3 | 5.7.14-google-log | Any | Any | JSON_OBJECT("k", dateTime) adds milliseconds to time |
| 83146 | 2016-09-26 7:39 | 2016-09-26 10:34 | MySQL Server: DML | Verified (3451 days) | S3 | 5.6, 5.7 | Linux | Any | time to bit produces inconsistent results |
| 82582 | 2016-08-15 11:05 | 2016-08-15 13:34 | MySQL Server: DML | Verified (3493 days) | S3 | 5.6/5.7 | Linux | Any | inconsistent and ambiguous results with cast decimal to datetime |
| 82308 | 2016-07-21 14:54 | 2023-07-31 15:25 | MySQL Server: MyISAM storage engine | Verified (3518 days) | S1 | 5.7 | Any | Any | use of DISTINCT with BIT and LONGTEXT leads to erroneous results |
| 81673 | 2016-06-01 11:12 | 2016-06-01 11:28 | MySQL Server: DML | Verified (3568 days) | S3 | 5.7.8 | Any | Any | UNION ALL returned incorrect result |
| 81508 | 2016-05-19 13:22 | 2016-05-20 8:52 | MySQL Server: DML | Verified (3580 days) | S3 | 5.7.8, 5.7.12, 5.6.30 | Any | Any | Type in meta data for "cast('a' as char(100))" is VAR_STRING |
| 81116 | 2016-04-18 2:14 | 2016-05-02 9:11 | MySQL Server: Data Types | Verified (3612 days) | S2 | 5.6.30, 5.5.49 | CentOS (6.7) | Any | Evaluating between DECIMAL and string returns different result depends on index |
| 80154 | 2016-01-26 12:33 | 2016-01-26 13:41 | MySQL Server: DML | Verified (3695 days) | S3 | 5.0/5.1/5.5/5.6/5.7 | Any | Any | Function ROUND( int value, 10) gets padding 0s |
| 80045 | 2016-01-19 9:03 | 2016-01-19 10:52 | MySQL Server: DML | Verified (3702 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Syntax error returned for invalid D in DECIMAL(M, D), ERROR 1427 expected |
| 79916 | 2016-01-11 9:34 | 2016-01-15 4:25 | MySQL Server: DML | Verified (3706 days) | S3 | 5.7.8, 5.6.28, 5.7.10 | Any | Any | Comparison gives inconsistent result for time(1) column and explicit cast result |
| 79974 | 2016-01-14 3:04 | 2016-01-14 13:08 | MySQL Server: DML | Verified (3707 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | "Out of range value for column '(null)'" is not clear enough |
| 79917 | 2016-01-11 12:41 | 2016-01-13 8:10 | MySQL Server: DML | Verified (3708 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | Func COALESCE( date, timestamp) and datetime are not working consistently |
| 79925 | 2016-01-12 8:07 | 2023-04-10 2:40 | MySQL Server: DML | Verified (3709 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | String const '69E5' is not treated as scientific notation when casting to int |
| 79915 | 2016-01-11 8:18 | 2016-01-11 9:34 | MySQL Server: DML | Verified (3710 days) | S3 | 5.7.8, 5.6.28, 5.7.10 | Any | Any | Function NULLIF + CAST is not working as expected |
| 79656 | 2015-12-16 4:00 | 2015-12-16 7:59 | MySQL Server: DML | Verified (3736 days) | S3 | 5.7.8, 5.5.48, 5.6.28, 5.7.10 | Any | Any | "'2' + 0.0, group_concat('2') + 0.0" are returning different result |
| 79518 | 2015-12-04 7:42 | 2015-12-07 7:01 | MySQL Server: DML | Verified (3745 days) | S3 | 5.7.8, 5.5.48, 5.6.29, 5.7.11 | Any | Any | Get inconsistent string when converting year column to char |
| 79292 | 2015-11-16 9:48 | 2015-11-19 22:03 | MySQL Server: DML | Verified (3763 days) | S3 | 5.0/5.1/5.5/5.6/5.7 | Any | Any | cast('-123.9' as signed) returns -123, not expected -124 |
| 79110 | 2015-11-04 4:17 | 2015-11-04 7:23 | MySQL Server: DML | Verified (3778 days) | S3 | 5.7.8,5.1.77,5.5.47,5.6.27,5.7.9 | Any | Any | When casting a BIG number to unsigned, get inconsistent result for same number |
| 78821 | 2015-10-13 15:28 | 2015-10-15 8:13 | MySQL Server: DML | Verified (3798 days) | S2 | 5.7.8, 5.7.10, 5.6.27, 5.5.47 | Any | Any | When comparing bigint and varchar constant, inconsistent results are returned |
| 78640 | 2015-09-30 8:42 | 2015-09-30 9:28 | MySQL Server: Data Types | Verified (3813 days) | S3 | 5.7.8, 5.5.47, 5.6.28, 5.7.10 | Any | Any | CAST OF 'DOUBLE' VALUE TO 'UNSIGNED' GIVES INCORRECT VALUE |
| 78415 | 2015-09-12 6:17 | 2015-09-12 9:50 | MySQL Server: DML | Verified (3831 days) | S3 | 5.6.22, 5.6.26, 5.7.9 | Any | Any | Equivalent SQL like "select cast( varchar as decimal)" returns different results |
| 77805 | 2015-07-23 2:01 | 2015-07-23 5:01 | MySQL Server: DML | Verified (3882 days) | S1 | 5.6.25 MySQL Community Server (GPL) | Ubuntu (Ubuntu 14.04.2 LTS x86_64) | Any | NULLIF cause wrong value with cast datetime |
| 76215 | 2015-03-09 1:57 | 2015-03-11 12:48 | MySQL Server: Charsets | Verified (4016 days) | S3 | 5.5.44, 5.6.25 | Any | Any | Implicit casts to string by COLLATE don't use character_set_connection |
| 71777 | 2014-02-20 9:39 | 2014-02-20 10:54 | MySQL Server: Optimizer | Verified (4400 days) | S2 | 5.5.35-0ubuntu0.13.10.1 | Linux (ubuntu0.13.10.1) | Any | Incorrect results are returned with NULLIF() |
| 70684 | 2013-10-22 8:13 | 2013-10-22 11:35 | MySQL Server: Optimizer | Verified (4521 days) | S3 | 5.5.33, 5.6.14 | Any | Any | HAVING referring to subquery results in WARNING 1292 |
| 70598 | 2013-10-10 22:19 | 2013-10-13 11:23 | MySQL Server: Optimizer | Verified (4530 days) | S3 | 5.5.32,5.5.34, 5.6.14, 5.7.2 | Linux (.6.18-348.16.1.el5) | Any | Premature expression evaluation prevents short-circuited conditionals |
| 69100 | 2013-04-30 9:53 | 2015-03-15 20:45 | MySQL Server: InnoDB storage engine | Verified (4690 days) | S1 | 5.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.2 | Linux (Debian 6 / Debian 7 / Ubuntu 12.10 / Windows 8) | Any | CAST in IF function fails in some case |
| 68864 | 2013-04-04 8:17 | 2013-04-04 8:37 | MySQL Server: Data Types | Verified (4722 days) | S2 | 5.6.10 | Any | Any | INTERVAL treats null values of text columns as float/int |
| 68759 | 2013-03-24 12:49 | 2013-03-25 5:31 | MySQL Server: Data Types | Verified (4732 days) | S3 | 5.6.10 | Any | Any | Inconsistent results on comparison a time field with a non-time literal |
| 64791 | 2012-03-28 20:17 | 2015-07-09 8:35 | MySQL Server: Optimizer | Verified (5093 days) | S2 | 5.1.61, 5.5 | Any | Any | Mixed String/Int values in IN list cause full table scan |
| 64769 | 2012-03-26 22:27 | 2012-03-27 7:05 | MySQL Server: DML | Verified (5095 days) | S3 | 5.1.61 | Any (Debian unstable) | Any | comparing indexed ENUM with 0+string constant does not use index properly |
| 64589 | 2012-03-08 5:08 | 2012-03-16 15:56 | MySQL Server: Data Types | Verified (5106 days) | S3 | 5.1; 5.5 | Any | Any | Alphanumeric strings bring back results on integer columns - SQL mode needed! |
| 63410 | 2011-11-23 21:17 | 2012-02-17 18:50 | MySQL Server: Stored Routines | Verified (5134 days) | S3 | 5.1.60, 5.1.61 | FreeBSD (x86_64) | Any | string corrupted in stored procedure concat and cast |
| 62156 | 2011-08-12 15:57 | 2012-05-18 20:19 | MySQL Server: Tests | Verified (5323 days) | S3 | 5.5 | Any | Any | main.func_str fails when run with --repeat=2 |
| 61114 | 2011-05-10 11:02 | 2025-10-12 20:45 | Connector / ODBC | Verified (5417 days) | S3 | connector 5.1.8 | Windows (7) | Any | ODBC doesn't support Uint32 / Uint64 ? <-> OdbcType.Int / BigInt |
| 56025 | 2010-08-16 18:25 | 2018-09-09 20:45 | MySQL Server: General | Verified (5684 days) | S3 | 5.0.67, 5.0, 5.1, 5.6.99 | Any | Any | Weird date between behavior, not consistent between versions |
| 50567 | 2010-01-23 15:46 | 2025-12-07 20:45 | MySQL Server: General | Verified (5889 days) | S3 | 5.1+ | Any | Any | CAST from large double to integer produces inconsistent results |
| 49253 | 2009-12-01 9:38 | 2018-09-09 20:45 | MySQL Server: Data Types | Verified (5942 days) | S2 | 5.1.41, mysql-next-mr(-alik) | Linux (SUSE 11.1, Linux 2.6.27.37-0.1-default #1 SMP x86_64 ) | Any | Inconsistent behavior concering overflow using numeric expressions and literals. |
| 47483 | 2009-09-21 14:05 | 2025-12-07 20:45 | MySQL Server: C API (client library) | Verified (6013 days) | S3 | 5.1 | Any | Any | SELECT UNION wrong length after prepare |
| 46037 | 2009-07-08 11:11 | 2018-11-04 20:45 | MySQL Server: Data Types | Verified (6088 days) | S3 | mysql-azalea/5.1 | Any | Any | Inconsistent behavior when casting floating point numbers to integer |
| 20924 | 2006-07-09 6:42 | 2018-09-09 20:45 | MySQL Server: Data Types | Verified (6136 days) | S2 | All | Linux (Linux 2.6) | Any | CAST(expr as UNSIGNED) returns SIGNED value when used in various functions |
| 39125 | 2008-08-29 16:31 | 2026-02-08 20:45 | MySQL Cluster: Cluster (NDB) storage engine | Verified (6139 days) | S3 | mysql-5.1-telco-6.3 | Any | Any | Result file for test contains a "temporary error", how can this be stable ? |
| 44363 | 2009-04-20 9:56 | 2025-12-07 20:45 | MySQL Server: General | Verified (6166 days) | S2 | 5.1.15, 5.1.35-bzr | Any | Any | IDIV not rounding off float/decimals correctly ? |
| 36539 | 2008-05-06 15:44 | 2025-12-07 20:45 | MySQL Server: Data Types | Verified (6516 days) | S2 | 5.0.38+, 5.1, 6.0 | Any | Any | data truncation and implicit cast return different values than explicit cast |
| 34564 | 2008-02-14 19:20 | 2022-12-04 20:45 | MySQL Server: Parser | Verified (6559 days) | S3 | 5.1.22-rc-log | Any | Any | CAST does not accept varchar type |
| 34562 | 2008-02-14 18:55 | 2018-09-09 20:45 | MySQL Server: Data Types | Verified (6590 days) | S3 | 5.1.22-rc-log | Any | Any | CAST does not accept standard-sql numeric types |
| 24424 | 2006-11-19 4:28 | 2020-05-03 20:45 | MySQL Server: Data Types | Verified (6639 days) | S1 | 5.1.11 | Any (ALL) | Any | CHAR data-type not space-padding |
| 31776 | 2007-10-23 8:19 | 2018-09-09 20:45 | MySQL Server: DML | Verified (6711 days) | S3 | 5.0.45, 4.1, 5.0, 5.1, 5.2 BK | Any (Linux, Microsoft Windows XP SP2) | Any | CAST AS CHAR with SELECT DISTINCT |
| 29202 | 2007-06-19 9:11 | 2019-01-02 14:14 | MySQL Server: User-defined functions ( UDF ) | Verified (6759 days) | S3 | 5.1 | Any | Any | Result of UDF in subquery is truncated |
| Showing all 167 (Edit, Save, CSV, Feed) |
