Showing 1-1000 of 2028 (Edit, Save, CSV, Feed) Show Next 1000 Entries »
ID# Date Updated Type Status Sev Version OS CPU Summary
1189802025-09-10
2:52
2025-09-11
13:04
MySQL Server: OptimizerVerified
(4 days)
S2MySQL8.0.41 AnyAnyqueries have different results using and without index
1189602025-09-09
2:57
2025-09-09
7:12
MySQL Server: OptimizerVerified
(6 days)
S59.2, 8.0, 8.4AnyAnySort optimization fails as primary key info in secondary index is not considered after hint-enforced secondary index
1189492025-09-05
13:57
2025-09-10
0:42
MySQL Server: OptimizerVerified
(7 days)
S29.2.0Linux (ubuntu 20.04)AnyMySQL 9.2.0: Complex CASE in JOIN makes INNER vs INTERSECT yield different rows
1189412025-09-05
8:19
2025-09-10
14:45
MySQL Server: OptimizerVerified
(5 days)
S28.0.x, 8.4.xAnyAnyBug Report: DECIMAL(22,2) Column Comparison with -0.001 Excludes 0.00 Row
1189372025-09-04
4:36
2025-09-10
0:43
MySQL Server: OptimizerVerified
(6 days)
S2 9.4.0 AnyAny LEFT JOIN with constant functions returns incorrect results when condition is ON FALSE
1189182025-09-01
7:30
2025-09-04
11:47
MySQL Server: OptimizerVerified
(12 days)
S2 9.4.0 AnyAnyInconsistent NULL handling in CTE LEFT JOIN results
1189132025-08-29
3:40
2025-09-01
10:19
MySQL Server: OptimizerVerified
(14 days)
S28.0.41, 9.4.0AnyAnyqueries have different results for non primary key table and table with primary key
1189122025-08-28
16:24
2025-09-04
11:48
MySQL Server: OptimizerVerified
(14 days)
S18 and above, 8.0.42, 8.4.5, 9.3.0AnyAnyMismatch in Column values with SUM of IFNULL vs IFNULL of SUM
1189092025-08-28
11:04
2025-09-04
11:49
MySQL Server: OptimizerVerified
(12 days)
S38.0.41, 9.4.0 Linuxx86Inconsistent evaluation of WHERE predicate between table-scan and covering-index paths; result set changes with projecti
1189042025-08-28
3:20
2025-09-04
11:46
MySQL Server: OptimizerVerified
(14 days)
S28.0.41+AnyAnyIncorrect results could be returned when using index condition pushdown and Range checked for each record
1188932025-08-26
8:31
2025-09-04
11:53
MySQL Server: OptimizerVerified
(14 days)
S39.4.0-1.el9LinuxAny"SELECT AUTO_INCREMENT FROM information_schema.TABLES" reports a value that is reduced by one
1188872025-08-25
2:49
2025-08-29
11:06
MySQL Server: OptimizerVerified
(21 days)
S39.4.0CentOSAnyZero '0000-00-00 00:00:00' datetime returned when SQL_BUFFER_RESULT is used
1188852025-08-24
12:05
2025-08-29
11:10
MySQL Server: CompilingVerified
(21 days)
S28.4.6MacOSAny mysql8 @8.4.6: ld: unknown option: -no_warn_duplicate_libraries
1188752025-08-21
12:42
2025-08-21
13:16
MySQL Server: DMLVerified
(25 days)
S38.0.41, 8.0.43AnyAnyset optimizer_switch='block_nested_loop=off/on', result is different.
1188712025-08-21
2:37
2025-08-29
11:12
MySQL Server: OptimizerVerified
(21 days)
S38.0.43 MySQL Community Server - GPLLinux (Linux (Rocky Linux release 8.8 (Green Obsidian)))AnyConstant conditions in SQL with derived views are not passed.new
1188632025-08-20
14:23
2025-08-21
6:30
MySQL Server: OptimizerVerified
(25 days)
S28.4.x, 8.4.6AnyAnyComplex collection query incorrectly missing '0'
1188622025-08-20
14:05
2025-08-21
6:28
MySQL Server: OptimizerVerified
(25 days)
S38.0.x, 8.4.x, 8.0.43AnyAnyMySQL Returns Incorrect Results for Complex Query with Set Operations
1188582025-08-20
8:51
2025-08-20
10:19
MySQL Server: OptimizerVerified
(26 days)
S39.2.0LinuxAnyInconsistency between the results returned by MySQL and other vendors' database systems was found during differentiation
1188572025-08-20
8:39
2025-08-20
10:19
MySQL Server: OptimizerVerified
(26 days)
S29.2.0LinuxAnyBug Summary: MySQL Returns Incorrect Results for Complex Query with Set Operations
1188492025-08-18
12:14
2025-08-18
23:50
MySQL Server: OptimizerVerified
(28 days)
S38.0.41AnyAnyafter add HINT:JOIN_ORDER, the result is wrong.
1188462025-08-15
8:50
2025-08-19
7:34
MySQL Server: OptimizerVerified
(27 days)
S39.3.0UbuntuAnycolumn name change cased by where
1188392025-08-14
3:13
2025-08-18
23:50
MySQL Server: DMLVerified
(28 days)
S38.0.41AnyAnya query including the having subclause that returns NULL, return a wrong nonempty result.
1188372025-08-14
3:05
2025-08-18
23:51
MySQL Server: OptimizerVerified
(28 days)
S38.0.41AnyAnyAfter having(col) in the query statement is changed to having min(col), the returned result is incorrect.
1188362025-08-14
3:01
2025-08-18
23:56
MySQL Server: OptimizerVerified
(28 days)
S38.0.41AnyAnyadding a having clause that return 1/TRUE, the query returns a different and wrong empty result.
1188352025-08-14
2:56
2025-08-19
0:17
MySQL Server: OptimizerVerified
(27 days)
S38.0.41AnyAnyA query statement that returns 0/FALSE in the having clause, the returned result is not null.
1188332025-08-14
2:43
2025-08-19
0:36
MySQL Server: OptimizerVerified
(27 days)
S38.0.41AnyAnyTwo queries that use the where clause with opposite semantics return the same result.
1188322025-08-14
2:39
2025-08-19
7:34
MySQL Server: OptimizerVerified
(27 days)
S38.0.41, 9.4.0AnyAnyusing the return value replacing the IFNUILL function , the query returns different value;
1188312025-08-14
2:33
2025-08-19
10:51
MySQL Server: OptimizerVerified
(27 days)
S38.0.41, 9.4.0AnyAny !(expression1 or expression2) return a different result from !(expression1), while expression2 is 0.
1188302025-08-14
2:26
2025-08-19
10:51
MySQL Server: DMLVerified
(27 days)
S38.0.41, 9.4.0AnyAnyAfter a constant value is replaced by a LEAST function returnning the same value, the sql returns different result;
1188112025-08-11
3:31
2025-08-11
12:02
MySQL Server: OptimizerVerified
(35 days)
S38.0.43Linuxx86When hints are added, different execution plans are used for query. The query result are different.
1188102025-08-11
3:19
2025-08-11
10:35
MySQL Server: OptimizerVerified
(35 days)
S38.0.41, 8.0.43, 8.4.6Linuxx86he query result are inconsistent,when select difference indexes
1188082025-08-10
11:26
2025-08-11
7:00
MySQL Server: OptimizerVerified
(35 days)
S29.4.0, 8.4.3, 8.4.6AnyAnyDifferent result with range scan and table scan in sql with subquery
1188062025-08-09
13:00
2025-08-11
5:39
MySQL Server: OptimizerVerified
(35 days)
S38.0,9.0, 8.0.43, 8.4.6, 9.4.0Ubuntux86NULLIF with VARCHAR omits rows unexpectedly
1187962025-08-06
22:31
2025-09-01
15:27
MySQL Server: CompilingVerified
(14 days)
S39.4.0 / 8.4.6Oracle Linux (10)x86RPM spec files are missing some buildrequires
1187882025-08-06
9:33
2025-08-21
8:59
MySQL Server: OptimizerVerified
(40 days)
S38.0.41, 8.0.43Linuxx86When two tables are joined, the execution results are different in different join order.
1187652025-08-01
2:56
2025-08-01
5:26
MySQL Server: DMLVerified
(45 days)
S38.0, 9.0, 8.4.6, 8.0.43AnyAnySubstring_index with negative index returns inconsistent results across different character sets
1187292025-07-28
13:17
2025-07-29
6:37
MySQL Server: OptimizerVerified
(48 days)
S38.4.4 (Any), 8.0.43, 8.4.6, 9.4.0AnyAnySelect Query is showing wrong column name alias from sub-query
1187102025-07-23
12:08
2025-07-23
12:42
MySQL Server: OptimizerVerified
(54 days)
S18.0.36, 8.0.42, 8.0.43, 8.4.6WindowsAnyOptimizer incorrectly simplifies negative float/decimal comparison in JOIN condition, leading to wrong results
1186942025-07-22
7:03
2025-07-22
11:45
MySQL Server: DMLVerified
(55 days)
S38.0.41 5.7, 8.0.42AnyAnyItem_func_between deal with decimel different from other methods
1186842025-07-18
14:54
2025-07-21
6:07
MySQL Server: OptimizerVerified
(56 days)
S29.2.0, 8.0.42, 8.4.5LinuxAnyInconsistent rows are returned
1186692025-07-16
5:22
2025-07-16
6:46
MySQL Server: OptimizerVerified
(61 days)
S18 and above, 8.0.42, 8.4.5, 9.3.0AnyAnyIssue in applying limit on aggregated data
1186582025-07-15
6:11
2025-07-15
6:16
MySQL Server: Data TypesVerified
(62 days)
S39.2.0, 8.0, 8.0.42AnyAnyIssue with NULL Detection for DATE-Type Columns in Derived Tables After Derived Merge
1186212025-07-09
12:39
2025-07-09
14:19
MySQL Server: OptimizerVerified
(68 days)
S39.3.0, 8.0.42AnyAnysubquery_to_derived optimizer makes query produce incorrect result
1185852025-07-03
16:35
2025-07-04
6:42
MySQL Server: OptimizerVerified
(73 days)
S58.0.39, 8.0.42, 8.4.5, 9.3.0Ubuntu (Ubuntu 20.04.2)Anysystem variable "range_alloc_block_size" arouse different execution plan
1185702025-07-02
2:29
2025-07-03
9:32
MySQL Server: DMLVerified
(75 days)
S58.0.42Linux (22.04)x86Performance regression occurs with INSERT statements after c17d86b
1185562025-06-29
19:07
2025-06-30
8:14
MySQL Server: DMLVerified
(77 days)
S39.3.0Ubuntux86Queries on tables with same data return different results
1185552025-06-29
18:55
2025-06-30
8:09
MySQL Server: DMLVerified
(77 days)
S39.3.0Ubuntux86Inconsistant results in tables containing NULL values
1185542025-06-29
18:42
2025-06-30
8:05
MySQL Server: DMLVerified
(77 days)
S39.3.0Ubuntux86Inconsistent results on same tables with different PRIMARY KEY constraint
1185532025-06-29
18:26
2025-06-30
8:03
MySQL Server: DMLVerified
(77 days)
S39.3.0Ubuntux86SELECT returns different results on tables with same data
1185522025-06-29
18:14
2025-06-30
8:00
MySQL Server: DMLVerified
(77 days)
S39.3.0Ubuntux86Inconsistant result on tables with same data but different constraints
1185512025-06-29
17:59
2025-06-30
7:42
MySQL Server: DMLVerified
(77 days)
S39.3.0Ubuntux86Inconsistant result after removing constraints on table
1185482025-06-28
7:56
2025-06-30
6:45
MySQL Server: OptimizerVerified
(77 days)
S39.2.0, 9.3.0Linuxx86A potential bugs in Mysql Server
1185442025-06-27
14:18
2025-06-30
6:43
MySQL Server: OptimizerVerified
(77 days)
S39.2.0 , 9.3.0LinuxAnyA potential join operator bug
1185412025-06-27
8:31
2025-06-27
13:37
MySQL Server: OptimizerVerified
(80 days)
S39.2.0 , 8.0.42LinuxAnyInconsistent Results Between NATURAL JOIN and its Equivalent Form Using EXCEPT ALL with Implicit Type Casting
1185402025-06-27
7:27
2025-06-27
13:36
MySQL Server: OptimizerVerified
(80 days)
S39.2.0 , 8.0.42LinuxAnyInconsistent results between NATURAL JOIN and INNER JOIN simulated via LEFT JOIN, RIGHT JOIN, and EXCEPT ALL with NULL v
1185122025-06-24
7:52
2025-06-25
8:13
MySQL Server: OptimizerVerified
(83 days)
S28.0.42, 8.4.5, 9.3.0AnyAnyThe missing semi join condition causes incorrect result
1184952025-06-20
7:40
2025-06-20
10:32
MySQL Server: DMLVerified
(87 days)
S38.0.41Linuxx86The query returned wrong result with l"imit offset"
1184902025-06-19
13:00
2025-06-20
5:21
MySQL Server: OptimizerVerified
(87 days)
S3master, 8.4AnyAnyhypergraph optimizer const folding caused inequivalent for join_cond_optim in Table_ref
1184752025-06-18
7:58
2025-06-18
8:40
MySQL Server: DMLVerified
(89 days)
S38.0.41, 8.4.5AnyAnyWhen the IF function is invoked to replace the specified column name, the returned results are inconsistent.
1184012025-06-09
13:37
2025-06-10
6:32
MySQL Server: DMLVerified
(98 days)
S38.0.41Linuxx86When innodb_buffer_pool_size is set a small value , the update value is abnormal.
1184002025-06-09
13:34
2025-07-24
12:28
MySQL Server: DMLVerified
(98 days)
S38.0.41Linuxx86ERROR 3854 (HY000): Cannot convert string '\xF0\x9F\x98\xA6\xF0\x9F...' from utf8mb4 to latin1
1183992025-06-09
12:35
2025-06-09
12:46
MySQL Server: DMLVerified
(98 days)
S38.0.41Linuxx86multijoin and related subqueries are used, the query result is incorrect during optimizer_switch="derived_merge=on"
1183982025-06-09
8:00
2025-06-11
12:40
MySQL Server: DMLVerified
(96 days)
S38.0.41AnyAnyUsing temporary with avg cause wrong result
1183912025-06-08
16:43
2025-06-10
12:23
MySQL Server: DMLVerified
(98 days)
S38.4.2, 8.0AnyAnyInconsistent BIGINT overflow behavior with unary minus operator in multiplication
1183522025-06-04
4:38
2025-06-04
8:51
MySQL Server: CharsetsVerified
(103 days)
S38.0, 8.4AnyAnyIllegal mix of collations when modify collation_connection
1183512025-06-04
2:24
2025-06-04
6:34
MySQL Server: DMLVerified
(103 days)
S38.0.41Linuxx86When Backward index scan is used for query SQL statements, the returned result is incorrect.
1183502025-06-04
2:03
2025-06-04
6:32
MySQL Server: OptimizerVerified
(103 days)
S39.xAnyAnyContribution: Adding fuzz directory and modifications to support it.
1183492025-06-04
2:03
2025-06-04
19:16
MySQL Server: OptimizerVerified
(103 days)
S39.xAnyAnyContribution: fuzz: parse_sql target
1183132025-05-30
9:17
2025-05-30
10:19
MySQL Server: OptimizerVerified
(108 days)
S38.0.41, 8.0.42, 8.4.5, 9.3.0AnyAnyThe query result is incorrect.
1183122025-05-30
8:12
2025-05-30
10:32
MySQL Server: DMLVerified
(108 days)
S28.0.42, 8.4.5, 9.3.0AnyAnyInconsistent results when evaluating `EXCEPT` or `INTERSECT` operations involving `NULL`
1182962025-05-29
2:32
2025-05-29
6:03
MySQL Server: DMLVerified
(109 days)
S38.0.41Linuxx86When join_buffer_size is set to a different value, the query returns different results.
1182642025-05-25
15:04
2025-08-13
11:05
MySQL Server: OptimizerVerified
(40 days)
S59.3.0UbuntuAnyPerformance bug in SEMI JOIN with empty tables
1182392025-05-21
13:05
2025-05-29
13:12
MySQL Server: DMLVerified
(109 days)
S39.3.0Ubuntu (22.04)AnyLogical Inconsistency in MySQL String Comparison with LIKE and NOT LIKE Operators
1181982025-05-14
14:16
2025-05-19
22:49
MySQL Server: OptimizerVerified
(119 days)
S29.3.0Ubuntu (22.04)AnyDifferent intersection orders lead to more than 20,000 times performance gap
1181812025-05-13
12:36
2025-07-03
9:33
MySQL Server: DMLVerified
(76 days)
S58.0.42Linuxx86Performance regression on query statements after commit 0fa789a
1181772025-05-13
8:53
2025-05-22
6:28
MySQL Server: OptimizerVerified
(116 days)
S38.0.35AnyAnyUnnecessary filter operator in the execution plan
1181742025-05-13
6:43
2025-05-14
7:18
MySQL Server: OptimizerVerified
(124 days)
S38.0AnyAnySkip Scan doesn't support non-covering key scan
1181732025-05-13
6:42
2025-07-03
9:24
MySQL Server: DMLVerified
(75 days)
S58.0.42Ubuntu (22.04)x86The insert statement suffers a performance penalty after commit cd66c5c.
1181642025-05-12
8:38
2025-05-12
13:01
MySQL Server: DMLVerified
(126 days)
S38.0.41Linuxx86When sort_buffer_size is set to a different value, group_concat returns different results.
1181612025-05-12
6:57
2025-05-12
8:44
MySQL Server: CompilingVerified
(126 days)
S38.0.42MacOS (15.4.1)ARMHaving Homebrew-installed googletest breaks build
1181582025-05-09
20:09
2025-05-12
12:05
MySQL Server: OptimizerVerified
(126 days)
S58.4.5AnyAnyEndless loop while executing some CTE
1181442025-05-08
23:35
2025-05-14
10:18
MySQL Server: OptimizerVerified
(124 days)
S58.0.40, 8.0.42Red Hat (RHEL9)x86Performance regression at 8.0.40 related to record buffer usage
1181372025-05-08
11:49
2025-05-08
12:10
MySQL Server: DMLVerified
(130 days)
S39.3, 8.0, 8.4AnyAnyContradictory query results for decimal data type
1181122025-05-04
21:32
2025-05-05
13:34
MySQL Server: CompilingVerified
(133 days)
S39.3.0Windows (11)x86openssl build bug
1180922025-04-30
3:31
2025-08-06
12:51
MySQL Server: DMLVerified
(138 days)
S28.0.41, 8.0.42, 8.4.5, 9.3.0LinuxAnyThe query result using index is different with not used index
1180892025-04-29
14:56
2025-05-08
13:57
MySQL Server: OptimizerVerified
(138 days)
S38.0.42, 8.4.5, 9.3.0AnyAnyCOALESCE with BIT field may return wrong values
1180852025-04-29
12:14
2025-04-29
13:43
MySQL Server: OptimizerVerified
(139 days)
S19.3,9.0,8.0,8.0.42, 8.4.5AnyAnyWrong right join result involving subquery
1180802025-04-29
6:51
2025-04-29
8:08
MySQL Server: OptimizerVerified
(139 days)
S38.0.42AnyAnyThe execution plan for the view with UNION ALL uses a full table scan instead of an index.
1180732025-04-28
15:10
2025-04-29
6:29
MySQL Server: OptimizerVerified
(139 days)
S19.3,9.0,8.0, 8.0.42AnyAnyWrong Inner Join Result
1180712025-04-28
13:09
2025-04-28
14:07
MySQL Server: OptimizerVerified
(140 days)
S28.0.41, 8.0.42, 8.4.5, 9.3.0AnyAnyIndexed table fails WHERE filtering with different charset value
1180632025-04-27
19:02
2025-04-28
7:39
MySQL Server: OptimizerVerified
(140 days)
S19.0, 8.0, 8.0.42, 8.4.5, 9.3.0AnyAnyWrong Join Result after creating index on expressions
1180612025-04-26
13:02
2025-04-28
7:40
MySQL Server: OptimizerVerified
(140 days)
S19.3, 8.4.5, 8.0.42AnyAnywrong inner join result when adding an additional true expression
1180532025-04-24
15:47
2025-05-19
2:25
MySQL Server: DMLVerified
(143 days)
S28.4.3, 9.3.0, 8.4.5, 8.0.42CentOSAnycast((NULLIF) as datetime) returns incorrect result
1180332025-04-22
14:51
2025-04-23
8:09
MySQL Server: OptimizerVerified
(145 days)
S29.3.0AnyAnyWrong Result of an and expression
1180262025-04-21
15:03
2025-04-22
7:02
MySQL Server: CompilingVerified
(146 days)
S38.0.42MacOSAnyBuild failed with apple clang 17
1180242025-04-21
12:46
2025-04-23
8:07
MySQL Server: OptimizerVerified
(147 days)
S19.3.0AnyAnyWrong Right Join involving a predicate containing IFNULL and IN
1180202025-04-20
23:23
2025-08-12
4:14
MySQL Server: OptimizerVerified
(119 days)
S19.2.0, 9.3.0Any (22.04)AnyA critical logic bug and performance bug
1180192025-04-20
16:30
2025-04-21
7:56
MySQL Server: OptimizerVerified
(147 days)
S29.0, 8.0, 9.3.0, 8.4.5, 8.0.42AnyAnyWrong Right Join with a subquery containing distinct and wrong NULL-value expression optimization
1180182025-04-20
13:49
2025-08-12
4:14
MySQL Server: OptimizerVerified
(119 days)
S19.2.0, 9.3.0Ubuntu (22.04)AnyA query expose a logic bug and performance bug
1180172025-04-20
10:59
2025-08-12
4:13
MySQL Server: OptimizerVerified
(119 days)
S59.2.0, 9.3.0Ubuntu (22.04)AnyA very serious performance bug
1180162025-04-20
10:34
2025-04-21
12:52
MySQL Server: OptimizerVerified
(148 days)
S29.3, 9.0, 8.0, 8.0.42AnyAnyWrong inner join result involving subquery containing distinct
1180152025-04-20
7:18
2025-08-12
4:13
MySQL Server: OptimizerVerified
(119 days)
S59.2.0, 9.3.0Ubuntu (22.04)AnyThe query which always return a empty result should not comsume executing time
1180142025-04-19
16:53
2025-04-20
13:53
MySQL Server: OptimizerVerified
(148 days)
S29.3.0,8.0, 8.0.42, 8.4.5, 9.3.0AnyAnyWrong Left Join Result
1180112025-04-18
13:26
2025-04-24
0:26
MySQL Server: Data TypesVerified
(145 days)
S38.0.41AnyAnyTimestamp literals with fractional seconds and time zone offset do not convert correctly
1180092025-04-18
7:13
2025-05-20
12:12
MySQL Server: OptimizerVerified
(150 days)
S58.4.5, 9.3.0Debian (12)x86 (amd64)SELECT query on primary key column deteriorates to full table scan when filter involves too long string
1180012025-04-17
4:15
2025-04-21
12:26
MySQL Server: DMLVerified
(147 days)
S28.4.3, 8.4.5AnyAnydelete sql returns error: Temporary file write failure.
1179592025-04-13
0:31
2025-04-13
16:37
MySQL Server: OptimizerVerified
(155 days)
S29.2.0Ubuntu (22.04)AnyPRIMARY KEY leads to incorrect INTERSECT result
1179452025-04-11
11:10
2025-04-11
12:23
MySQL Server: OptimizerVerified
(157 days)
S29.2.0Ubuntu (22.04)AnyUNION operation may return wrong result[
1179412025-04-10
13:29
2025-04-10
14:45
MySQL Server: OptimizerVerified
(158 days)
S28.0.41, 8.4.4, 9.2.0AnyAnyInconsistent query results with / without NOT NULL for BLOB type
1179272025-04-10
6:25
2025-04-10
7:35
MySQL Server: JSONVerified
(158 days)
S28.0.41, 8.4AnyAnyduplicate key in table while using tmp table for group by a json data
1179112025-04-08
12:06
2025-04-08
14:45
MySQL Server: OptimizerVerified
(160 days)
S29.2.0Ubuntu (22.04)AnyINTERSECT operation return wrong result
1178672025-04-03
8:32
2025-04-09
10:19
MySQL Server: OptimizerVerified
(159 days)
S58.0.41AnyAnyuse distinct+left join, MySQL 8.0 excute long time than MySQL 5.7
1178602025-04-02
10:44
2025-05-12
12:20
MySQL Server: OptimizerVerified
(126 days)
S29.2.0Any (Ubuntu 22.04)AnyRead another insertion WITH CONSISTENT SNAPSHOT
1178562025-04-02
7:42
2025-04-02
8:01
MySQL Server: OptimizerVerified
(166 days)
S2 9.1.0, 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyREPEAT Function Causes Row Loss in WHERE Clause
1178552025-04-02
7:37
2025-04-02
8:15
MySQL Server: OptimizerVerified
(166 days)
S2 9.1.0 , 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyQUOTE Function Incorrectly Handles NULL Values
1178542025-04-02
7:31
2025-04-02
8:35
MySQL Server: OptimizerVerified
(166 days)
S2 9.1.0, 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyIncorrect Filtering Behavior of MAKE_SET Function
1178532025-04-02
7:23
2025-04-02
9:27
MySQL Server: OptimizerVerified
(166 days)
S2 9.1.0, 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyIncorrect Result When Using LEFT OUTER JOIN with Subquery
1178522025-04-02
7:14
2025-04-08
15:00
MySQL Server: OptimizerVerified
(166 days)
S2 9.1.0, 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyIncorrect Handling of NULL Values with FIELD Function in SQL Query
1178512025-04-02
7:05
2025-04-02
9:45
MySQL Server: OptimizerVerified
(166 days)
S2 9.1.0, 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyIncorrect Behavior of EXISTS Condition with OR in SQL Query
1178492025-04-02
6:52
2025-04-02
9:48
MySQL Server: OptimizerVerified
(166 days)
S2 9.1.0, 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyIncorrect Query Results When Using Nested String Operation Functions with Conditional Expressions as Inner Parameters
1178482025-04-02
6:37
2025-04-02
9:50
MySQL Server: OptimizerVerified
(166 days)
S2 9.1.0, 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyINTERVAL Function Incorrectly Filters Results in WHERE Clause
1178472025-04-02
6:29
2025-04-02
7:47
MySQL Server: OptimizerVerified
(166 days)
S2 9.1.0 , 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyNULLIF Filtering Fails in WHERE Clause
1178342025-03-31
3:43
2025-04-01
7:20
MySQL Server: OptimizerVerified
(167 days)
S39.2, 8.0.41, 8.4.4Ubuntux86Double negation on booleans incorrectly returns negated value
1178112025-03-27
15:19
2025-04-03
14:22
MySQL Server: OptimizerVerified
(171 days)
S18.4.4, 8.0.41, 9.2.0AnyAnyIncorrect query results for BLOB type
1178092025-03-27
13:06
2025-03-27
20:10
MySQL Server: OptimizerVerified
(172 days)
S5AnyAny Statistics update failed.
1178082025-03-27
7:21
2025-03-27
10:01
MySQL Server: Prepared statementsVerified
(172 days)
S38.0.41, 8.4.2AnyAnyUnexpected JSON column DML error with prepare statement
1177912025-03-25
13:30
2025-03-25
13:48
MySQL Server: OptimizerVerified
(174 days)
S38.0, 8.4, 9.2AnyAnyFORCE INDEX does not skip records_in_range() for 'x IS NULL'
1177832025-03-25
8:45
2025-03-26
8:20
MySQL Server: OptimizerVerified
(173 days)
S28.0.32, 8.0.41AnyAnyoptimizer selects the wrong index due to the "low_limit" mechanism
1177762025-03-24
5:01
2025-03-24
7:46
MySQL Server: OptimizerVerified
(175 days)
S38.0, 8.4, 9.2AnyAnyIndex statistics is unexpectedly used to estimate eq ranges with null part
1177702025-03-22
5:32
2025-03-24
7:54
MySQL Server: OptimizerVerified
(175 days)
S58.0.36, 8.0.41, 8.4.4, 9.2.0AnyAnyrechecking_index_usage causes the materialized table to be generated using table scan in Materialize semijoin strategy
1177652025-03-21
3:09
2025-03-21
9:01
MySQL Server: OptimizerVerified
(178 days)
S29.2.0, 8.0.41, 8.4.4AnyAnyQuery result may be wrong if using compound order by inside GROUP_CONCAT
1177502025-03-19
11:46
2025-03-20
5:44
MySQL Server: OptimizerVerified
(179 days)
S38.0, 8.4, 9.2AnyAnyFORCE INDEX does not skip records_in_range() for 'x IS NOT NULL'
1177212025-03-17
3:20
2025-03-17
7:59
MySQL Server: DMLVerified
(182 days)
S38.0, 8.0.41Ubuntux86Inferred type of functional index is ambiguous and restricts column values
1177142025-03-14
15:36
2025-03-21
1:11
MySQL Server: OptimizerVerified
(181 days)
S25.7.42AnyAnyIncorrect row filtering when using CAST(... AS DATE) adding an AND condition.
1177062025-03-14
9:41
2025-03-14
10:18
MySQL Server: OptimizerVerified
(185 days)
S3 9.1.0 , 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyInconsistent Behavior when use a <=> b and a = b in queries
1177052025-03-14
9:39
2025-03-17
8:15
MySQL Server: OptimizerVerified
(182 days)
S58.0AnyAnySubquery performance degregation
1177042025-03-14
9:24
2025-03-14
10:49
MySQL Server: OptimizerVerified
(185 days)
S2 9.1.0, 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyWHERE Clause Fails to Filter NULL Values in Condition (col1 = col2)
1177032025-03-14
9:00
2025-03-14
10:39
MySQL Server: OptimizerVerified
(185 days)
S2 9.1.0, 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyIncorrect Query Results When Using REPEAT (Branch Structure) in Subquery
1177022025-03-14
8:48
2025-03-14
10:29
MySQL Server: OptimizerVerified
(185 days)
S2 9.1.0 , 8.0.41, 8.4.4, 9.2.0Ubuntu (20.04)AnyIncorrect Query Results When Using DISTINCT and Logical AND in Subquery
1176742025-03-12
6:20
2025-03-17
9:46
MySQL Server: JSONVerified
(182 days)
S28.0.37, 8.0.41, 8.4.4AnyAnyJSON value is not recognized by Mysql inside Stored Routines
1176632025-03-11
8:29
2025-03-11
8:57
MySQL Server: JSONVerified
(188 days)
S39.2.0AnyAnyJSON_ARRAY func result error
1176532025-03-10
3:22
2025-03-10
5:36
MySQL Server: OptimizerVerified
(189 days)
S28.0, 8.0.41, 8.4.4, 9.2.0Ubuntux86Invisible index affects output of query result
1176512025-03-09
15:43
2025-03-10
6:50
MySQL Server: OptimizerVerified
(189 days)
S29.2.0, 9.1.0, 8.0.41, 8.4.4Ubuntu (22.04)AnySTRAIGHT_JOIN produces inconsistent results when comparing text values
1176482025-03-09
14:15
2025-03-10
7:19
MySQL Server: OptimizerVerified
(189 days)
S29.2.0, 9.1.0, 8.0.41, 8.4.4,Ubuntu (22.04)AnyEquivalent straight-join queries with different join orders return different results.
1176342025-03-06
14:00
2025-03-07
12:59
MySQL Server: OptimizerVerified
(192 days)
S18.4.4, 8.0.41AnyAnyIncorrect query results
1176192025-03-05
0:14
2025-03-05
5:53
MySQL Server: OptimizerVerified
(194 days)
S28.*, 8.0.41, 8.0.44AnyAnyMySQL indexes in MyISAM tables not behave as expected.
1176062025-02-28
16:01
2025-02-28
16:27
MySQL Server: OptimizerVerified
(199 days)
S18.4.4, 8.0.41AnyAnyIncorrect query result
1175982025-02-28
3:28
2025-04-01
5:09
MySQL Server: OptimizerVerified
(199 days)
S28.0.35, 8.0.41, 8.4.4AnyAnyWrong sort order for queries with ORDER BY DESC when using range comparison with LIMIT
1175732025-02-26
4:47
2025-03-21
7:12
MySQL Server: OptimizerVerified
(178 days)
S29.2.0, 8.0.41, 8.4.4Ubuntu (22.04)x86Equivalent inner-join queries return different results
1175722025-02-26
2:37
2025-02-26
6:36
MySQL Server: OptimizerVerified
(201 days)
S28.0.41Ubuntu (22.04)x86The same query yields different results across different versions
1175622025-02-25
3:09
2025-02-25
5:53
MySQL Server: Data TypesVerified
(202 days)
S38.4.4AnyAnyTypo in sql/field.cc:301
1175492025-02-24
2:24
2025-02-24
4:52
MySQL Server: OptimizerVerified
(203 days)
S18.0, 8.0.41, 8.4.4AnyAnyWrong result when use "in (select * from (set operation) d)"
1175432025-02-22
0:20
2025-02-24
10:25
MySQL Server: OptimizerVerified
(203 days)
S39.0, 8.0, 8.4AnyAnyContribution: Return the correct collation for temporal results
1175342025-02-20
14:39
2025-02-21
11:36
MySQL Server: OptimizerVerified
(206 days)
S38.0AnyAnyCreate index can lead to incorrect results
1175002025-02-18
11:40
2025-03-11
8:56
MySQL Server: OptimizerVerified
(209 days)
S29.2.0, 8.0.41, 8.4.4AnyAnyresult error when row compared with scalar subquery using '<=>'
1174862025-02-17
8:04
2025-02-17
22:40
MySQL Server: OptimizerVerified
(210 days)
S29.1.0, 8.0.41Ubuntu (22.04)x86Incorrect Semi-join Execution
1174852025-02-17
7:04
2025-02-17
7:53
MySQL Server: OptimizerVerified
(210 days)
S29.1.0, 8.0.41, 8.4.4Ubuntu (22.04)x86Incorrect Semi-join Execution
1174762025-02-15
13:10
2025-02-20
13:36
MySQL Server: OptimizerVerified
(209 days)
S3 9.1.0-clusterUbuntu (18.04)x86Inconsistent result after using optimizer_switch
1174572025-02-13
2:37
2025-02-13
7:02
MySQL Server: DMLVerified
(214 days)
S38.4.1 9.1.0 , 8.0.41Windows (windows 11)x86 (x86_64)Unexpected results with complex WHERE conditions
1174562025-02-13
2:24
2025-02-13
6:37
MySQL Server: DMLVerified
(214 days)
S38.4.1 9.1.0, 8.0.41Windows (windows 11)x86 (x86_64)Unexpected results when using JSON_OBJECT function in WHERE clause
1174542025-02-13
2:08
2025-02-13
5:48
MySQL Server: JSONVerified
(214 days)
S28.4.1 9.1.0 , 8.0.41Windows (windows 11)x86 (x86_64)Unexpected results with JSON_VALID function in WHERE clause.
1174532025-02-13
1:51
2025-02-13
5:20
MySQL Server: DMLVerified
(214 days)
S28.4.1 9.1.0, 8.0.41Windows (windows 11)x86 (x86_64)Unexpected results with ACOS function in WHERE clause.
1174522025-02-13
1:38
2025-02-13
4:43
MySQL Server: DMLVerified
(214 days)
S38.4.1 9.1.0 , 8.0.41Windows (windows 11)x86 (x86_64)Unexpected results with IS_IPV4_MAPPED in WHERE clause.
1174512025-02-13
1:33
2025-02-13
4:24
MySQL Server: OptimizerVerified
(214 days)
S28.4.1 9.1.0, 8.0.41Windows (windows 11)x86 (x86_64)Comparing a BIGINT column with the result of an IF function using "=" yields unexpected results.
1174462025-02-12
7:56
2025-02-12
16:11
MySQL Server: OptimizerVerified
(215 days)
S39.2AnyAnyUnexpected lock wait timeout when executing select for update
1174432025-02-11
19:40
2025-08-07
17:53
MySQL Server: CompilingVerified
(215 days)
S39.2.0AnyAnycmake doesn't detect missing quadmath library
1174392025-02-11
14:27
2025-02-20
13:12
MySQL Server: OptimizerVerified
(215 days)
S28.0, 8.0.41, 8.4.4, 9.2.0Ubuntux86Suspicious behaviour around creation of multi-column indexes
1174092025-02-07
5:48
2025-02-07
6:45
MySQL Server: OptimizerVerified
(220 days)
S58.0.35, 8.0.41AnyAnyjoin with crosse table sort is not optimized away by index
1174082025-02-07
4:26
2025-02-07
8:42
MySQL Server: OptimizerVerified
(220 days)
S58.0.41AnyAnyTight index scan not used when group by does not begin with first part of key, but where condition is list of constants
1173872025-02-05
12:39
2025-02-05
15:42
MySQL Server: OptimizerVerified
(222 days)
S28.4.4, 8.0.41AnyAnyQuery returns wrong results when using offset limit subquery in view
1173862025-02-05
10:13
2025-02-05
13:51
MySQL Server: OptimizerVerified
(222 days)
S28.0, 8.0.41, 8.4.4Ubuntux86Ambiguous functional index not based on any column under-fetches rows
1173482025-01-31
10:06
2025-01-31
13:56
MySQL Server: OptimizerVerified
(227 days)
S28.4, 8.0.41, 8.4.4, 9.2.0Debianx86Query with DISTINCT in combination with big_tables returns wrong sortorder
1173462025-01-30
19:17
2025-02-06
13:55
MySQL Server: CompilingVerified
(227 days)
S39.2.0AnyAnyContribution: Added documentation for unused bytes at the end of Protocol:: ...
1172992025-01-27
11:48
2025-05-14
15:19
MySQL Server: CompilingVerified
(124 days)
S38.4.5, 9.2.0MacOS (15.2)ARMddl0bulk.h:236:15: error: parameter 'prebuilt' not found in the function declaration [-Werror,-Wdocumentation]
1172812025-01-23
10:27
2025-01-23
17:01
MySQL Server: CompilingVerified
(235 days)
S28.0AnyAnysql/table_cache.cc init does not cleanup on failure
1172732025-01-23
4:13
2025-01-24
5:18
MySQL Server: OptimizerVerified
(234 days)
S58.0.35AnyAnysome sort is not optimized away by index, if index have part of primary key
1172612025-01-22
8:37
2025-01-24
7:46
MySQL Server: OptimizerVerified
(236 days)
S38.0, 8.0.40, 8.4.3Ubuntux86Creation of multicolumn indexes might lead to rows not being fetched during GROUP BY
1172452025-01-20
9:58
2025-01-20
13:30
MySQL Server: Data TypesVerified
(238 days)
S38.0AnyAnyGet incorrect result when comparing TIME type with IN value list that contains NULL
1172422025-01-20
9:13
2025-01-20
9:50
MySQL Server: OptimizerVerified
(238 days)
S28.0, 8.0.40, 8.4.3Ubuntux86DISTINCT does not fetch all distinct rows when used with GROUP BY
1172352025-01-18
7:00
2025-01-20
6:07
MySQL Server: JSONVerified
(238 days)
S38.4.1,9.1.0, 8.0.40, 8.4.3Windowsx86Unexpected results when using JSON_ARRAY comparison as a predicate.
1172342025-01-18
6:35
2025-01-20
5:58
MySQL Server: JSONVerified
(238 days)
S28.4.1,9.1.0, 8.0.40, 8.4.3Windowsx86Unexpected results when using JSON_ARRAY(NULL) in query predicates.
1172332025-01-18
6:00
2025-01-20
5:54
MySQL Server: DMLVerified
(238 days)
S28.4.1,9.1.0, 8.0.40, 8.4.3Windowsx86The same query involving TIME type returns different results with and without using an index.
1172322025-01-18
5:48
2025-01-20
5:29
MySQL Server: Data TypesVerified
(238 days)
S28.4.1,9.1.0, 8.4.0, 8.4.3Windows (windows 11)x86Unexpected results with YEAR data type comparisons in query predicates.
1172232025-01-17
7:33
2025-01-17
9:16
MySQL Server: Data TypesVerified
(241 days)
S28.4.1 9.1.0, 8.0.40Windowsx86Query results are unexpected with BIT data type and IN operator.
1172222025-01-17
7:26
2025-01-17
9:15
MySQL Server: Data TypesVerified
(241 days)
S38.4.1 9.1.0, 8.0.40Windowsx86Query results are unexpected with BIT data type comparisons.
1172132025-01-16
5:22
2025-01-16
15:51
MySQL Server: DMLVerified
(242 days)
S38.0AnyAnyWrong execution result when remove all parentheses
1171992025-01-13
14:07
2025-01-13
14:42
MySQL Server: OptimizerVerified
(245 days)
S38.0AnyAnyInconsistent Results with JSON_UNQUOTE Between Table and View
1171982025-01-13
13:26
2025-01-13
14:40
MySQL Server: Data TypesVerified
(245 days)
S38.0AnyAnyInconsistent Results with CASE and Spatial Data Between Table and View
1171862025-01-13
3:01
2025-01-15
6:36
MySQL Server: DMLVerified
(245 days)
S28.0.40, 8.4.3AnyAnyresult is incorrect
1171642025-01-09
6:17
2025-01-09
7:08
MySQL Server: OptimizerVerified
(249 days)
S38.0.36, 8.0.40AnyAnyRange estimation (index dives) overestimates the rows count on large ranges. It almost doubles the actual number of rows
1171552025-01-09
2:29
2025-01-09
4:48
MySQL Server: OptimizerVerified
(249 days)
S38.0.32, 8.0.40AnyAnydrived_merge optimization error
1171342025-01-08
10:25
2025-01-08
10:47
MySQL Server: GISVerified
(250 days)
S18.0.40AnyAnyST_Buffer gives unexpected result with LinearRing
1171312025-01-08
7:52
2025-01-09
9:20
MySQL Server: DMLVerified
(249 days)
S38.4.1, 8.0.40Windows (windows 11)x86 (x86_64)Query results don't match expectations with FIELD function in predicate.
1171302025-01-08
7:03
2025-01-08
7:50
MySQL Server: ParserVerified
(250 days)
S39.1.0AnyAnyerror occurs when using cast collate binary
1171292025-01-08
6:33
2025-01-08
7:15
MySQL Server: GISVerified
(250 days)
S38.0.40AnyAnyPotential bug in ST_Crosses
1171282025-01-08
5:42
2025-01-13
9:23
MySQL Server: DMLVerified
(250 days)
S38.4.1, 8.0.40Windows (windows 11)x86Query results do not meet expectations when the predicate involves CAST AS FLOAT and >> operator
1171272025-01-08
5:38
2025-01-08
7:38
MySQL Server: DMLVerified
(250 days)
S38.4.1, 8.0.40Windows (windows 11)x86 (x86_64)Query results do not meet expectations when the predicate involves CASE WHEN and LIKE
1171202025-01-07
12:40
2025-01-07
12:46
MySQL Server: GISVerified
(251 days)
S39.0, 8.0.40AnyAnyInconsistent Results with ST_Collect in WHERE Clause
1171052025-01-04
10:02
2025-01-06
9:43
MySQL Server: OptimizerVerified
(254 days)
S28.0.39, 8.0.40AnyAnyDependent subqueries incorrect results
1170962025-01-02
8:43
2025-01-02
11:59
MySQL Server: DMLVerified
(256 days)
S38.4.1, 8.0.40Windows (windows 11)x86 (x86_64)The result of using CAST AS DOUBLE in the query does not meet expectations.
1170952025-01-02
7:00
2025-01-02
7:24
MySQL Server: DMLVerified
(256 days)
S38.4.1, 8.0.40Windows (windows 11)x86 (x86_64)The GREATEST function in the predicate behaves unexpectedly.
1170942025-01-02
6:31
2025-01-02
7:35
MySQL Server: DMLVerified
(256 days)
S38.4.1, 8.0.40Windows (windows 11)Any (x86_64)Using TRUE and * in SELECT returns different row counts.
1170912025-01-01
15:26
2025-01-02
7:37
MySQL Server: DMLVerified
(256 days)
S38.4.3, 8.0.40Windows (windows 11)x86 (x86_64)Using two mutually exclusive predicates as WHERE conditions returned the same result.
1170892025-01-01
8:37
2025-01-01
9:29
MySQL Server: DMLVerified
(257 days)
S38.4.1, 8.0.40Windows (windows 11)x86 (x86_64)Inconsistent results using equivalent predicates in two queries.
1170762024-12-30
13:38
2024-12-30
13:49
MySQL Server: GISVerified
(259 days)
S28.0.40AnyAnyST_Intersection returns a non-empty result for two geometries that are disjoint.
1170722024-12-30
9:24
2024-12-30
10:06
MySQL Server: OptimizerVerified
(259 days)
S28.4.3, 9.1.0, 8.0.40Any (Ubuntu 22.04)Any (x86)MAX() as a Window Function Returns NULL for the First Row Even With Non-empty Window Frame Under Specific Conditions
1170632024-12-28
13:40
2024-12-30
13:44
MySQL Server: GISVerified
(259 days)
S18.0.40AnyAnySpatial index causes the disjoint predicate gives wrong result with WHERE,INNER JOIN and CROSS JOIN,
1170602024-12-27
13:28
2024-12-27
13:39
MySQL Server: DMLVerified
(262 days)
S38.4.3, 8.0.40AnyAnychanging a constant TRUE to a condition involving TO_DAYS leads to a different result set
1170592024-12-27
13:14
2024-12-27
13:17
MySQL Server: DMLVerified
(262 days)
S38.4.3, 8.0.40AnyAnyInconsistent Query Results Between Materialized Table and View with Division
1170582024-12-27
13:01
2024-12-27
13:16
MySQL Server: DMLVerified
(262 days)
S38.4.3, 8.0.40AnyAnyInconsistent Results When Using COALESCE
1170572024-12-27
12:35
2024-12-27
13:16
MySQL Server: DMLVerified
(262 days)
S38.4.3, 8.0.40AnyAnyInconsistent Results Between Materialized Table and View with GREATEST
1170552024-12-27
10:11
2024-12-27
12:49
MySQL Server: OptimizerVerified
(262 days)
S38.0.40, 8.4.3AnyAnyQuery result may be incorrect if unique index contains NULL
1170482024-12-26
9:06
2024-12-30
13:44
MySQL Server: GISVerified
(259 days)
S28.0.40AnyAnyST_Buffer gives unexpected reuslt using end_flat strategy with closed Linestring
1170472024-12-26
8:27
2024-12-30
13:44
MySQL Server: GISVerified
(259 days)
S18.0.40AnyAnyST_Touches always return null with Point and GeometryCollection with Points
1170462024-12-25
12:44
2024-12-30
13:44
MySQL Server: GISVerified
(259 days)
S28.0.40AnyAnyNegative buffer of a polygon gives an result that not small enough.
1170422024-12-25
6:56
2024-12-30
13:43
MySQL Server: GISVerified
(259 days)
S28.0.40WindowsAnyST_Within gives unexpected result with Linestring and Polygon in WGS84.
1170402024-12-24
13:04
2024-12-24
13:14
MySQL Server: DMLVerified
(265 days)
S38.4.3, 8.0.40Windows (windows 11)x86 (x86_64)Inconsistent behavior for the same query on a DATETIME column with and without a PRIMARY KEY constraint.
1170362024-12-23
7:28
2024-12-31
5:43
MySQL Server: GISVerified
(266 days)
S28.0, 8.0.40AnyAnySpatial Index causes CHECK TABLE to fail
1170172024-12-18
19:11
2025-01-09
17:17
MySQL Server: OptimizerVerified
(270 days)
S38.0AnyAnyIncorrect Operator Precedence of IN and Comparators in MySQL 8.4.3 and 9.1.0
1169642024-12-13
8:06
2024-12-13
9:31
MySQL Server: OptimizerVerified
(276 days)
S28.0.38, 8.0.40LinuxAnyResult mismatch caused by derived condition push down.
1169372024-12-11
8:25
2024-12-11
15:33
MySQL Server: OptimizerVerified
(278 days)
S38.0, 8.0.40AnyAnyestimation of REF is modified by index diving of INDEX MERGE
1169002024-12-07
8:28
2024-12-09
8:10
MySQL Server: OptimizerVerified
(280 days)
S58.0.40AnyAnyReuseRangeEstimateForRef does not work properly when there are non-prefixed multi keypart ref
1168952024-12-06
11:45
2024-12-25
3:09
MySQL Server: OptimizerVerified
(283 days)
S29.0,8.0, 8.0.40, 8.4.3AnyAnyView using IN(SELECT LIMIT) has wrong result
1168932024-12-06
9:22
2024-12-06
9:43
MySQL Server: DMLVerified
(283 days)
S39.0, 8.0.40AnyAnyInconsistent Results Between Materialized Table and View with GREATEST
1168922024-12-06
8:39
2024-12-06
9:43
MySQL Server: DMLVerified
(283 days)
S39.0, 8.0.40AnyAnyInconsistent Query Results Between Materialized Table and View with FROM_UNIXTIME
1168902024-12-06
7:31
2024-12-06
11:41
MySQL Server: Data TypesVerified
(283 days)
S38.0AnyAnyInconsistent Query Results Between Materialized Table and View with CHAR Function
1168732024-12-04
14:29
2024-12-04
15:12
MySQL Server: Data TypesVerified
(285 days)
S38.0AnyAnyWhen comparing SMALLINT and FLOAT, the type conversion logic is incorrect.
1168632024-12-04
6:47
2024-12-04
7:03
MySQL Server: DMLVerified
(285 days)
S28.0.37, 8.0.40, 8.4.3, 9.1.0LinuxAnyQueries data of the time type, the returned result is incorrect
1168622024-12-04
5:11
2024-12-04
6:51
MySQL Server: DMLVerified
(285 days)
S28.4.1, 8.0.40, 8.4.3, 9.1.0Red Hat (Linux 3.10.0-1160.102.1.el7.x86_64)x86 (x86_64)After deleting the index, the same query produces inconsistent results compared to before.
1168522024-12-03
3:33
2024-12-03
6:17
MySQL Server: JSONVerified
(286 days)
S38.0.34, 8.0.40AnyAnyDifference between JSONPath "$" vs "$[*]"
1168462024-12-02
14:42
2024-12-04
15:06
MySQL Server: Data TypesVerified
(285 days)
S38.0AnyAnyThe logical error of the NULLIF function in the WHERE condition.
1168032024-11-27
11:29
2025-03-22
0:37
MySQL Server: OptimizerVerified
(280 days)
S58.0.40AnyAnyMySQL 8.0.33 is slower than MySQL 8.0.28 with queries using JOINS
1167772024-11-25
19:50
2024-11-27
12:52
MySQL Server: OptimizerVerified
(292 days)
S5596f0d23 (9.0.0), 8.0.40AnyAnyPerformance of TPC-DS Query 47
1167762024-11-25
18:45
2024-11-28
7:53
MySQL Server: OptimizerVerified
(291 days)
S5596f0d23 (9.0.0), 8.0.40AnyAnyPerformance of TPC-DS Query 19
1167752024-11-25
18:34
2024-11-28
8:00
MySQL Server: OptimizerVerified
(291 days)
S5596f0d23 (9.0.0), 8.0.40AnyAnyPerformance of TPC-DS Query 16
1167742024-11-25
18:00
2024-11-28
8:02
MySQL Server: OptimizerVerified
(291 days)
S5596f0d23 (9.0.0), 8.0.40AnyAnyPerformance of TPC-DS Query 15
1167732024-11-25
17:40
2024-11-28
8:02
MySQL Server: OptimizerVerified
(291 days)
S5596f0d23 (9.0.0), 8.0.40AnyAnyPerformance of TPC-DS Query 7
1167652024-11-25
2:18
2024-11-25
13:34
MySQL Server: OptimizerVerified
(294 days)
S38.0Any (22.04)AnyIncorrect Operator Precedence of BETWEEN and Comparators in MySQL 8.4
1167412024-11-21
6:58
2024-11-22
1:05
MySQL Server: OptimizerVerified
(297 days)
S28.0, 8.0.40, 8.4.3AnyAnyInnodb tmp table causes incorrect query results
1167282024-11-20
8:32
2024-11-20
8:51
MySQL Server: OptimizerVerified
(299 days)
S18.4.2, 8.0.40AnyAnyIssues with the EXCEPT operator.
1167272024-11-20
8:27
2024-11-20
8:50
MySQL Server: OptimizerVerified
(299 days)
S18.4.2, 8.0.40AnyAnyIssues with independent subqueries.
1167262024-11-20
8:22
2024-11-20
8:50
MySQL Server: OptimizerVerified
(299 days)
S18.4.2, 8.0.40AnyAnyIssues with the combination of CAST and DATE.
1167252024-11-20
7:44
2024-11-20
8:54
MySQL Server: OptimizerVerified
(299 days)
S18.4.2, 8.0.40AnyAny Issues with CASE statements.
1167242024-11-20
7:44
2024-11-20
8:49
MySQL Server: OptimizerVerified
(299 days)
S18.4.2, 8.0.40AnyAny Issues with CASE statements
1167232024-11-20
7:35
2024-11-20
8:45
MySQL Server: OptimizerVerified
(299 days)
S28.4.2, 8.0.40AnyAnyIssues with explicit type casting using CAST.
1167222024-11-20
7:11
2024-11-20
7:37
MySQL Server: OptimizerVerified
(299 days)
S18.4.2, 8.0.40AnyAny Issues with the COALESCE function.
1167212024-11-20
7:01
2024-11-20
7:37
MySQL Server: OptimizerVerified
(299 days)
S18.4.2, 8.0.40AnyAnyIssues with combining COALESCE and DATE functions.
1167202024-11-20
6:48
2024-11-20
7:37
MySQL Server: OptimizerVerified
(299 days)
S18.4.2, 8.0.40AnyAnyIssues with the combination of CASE and DATE.
1167102024-11-19
12:47
2024-11-20
11:02
MySQL Server: OptimizerVerified
(299 days)
S38.0AnyAnyexplain shows wrong cost value
1167032024-11-19
6:06
2024-11-19
6:28
MySQL Server: JSONVerified
(300 days)
S38.0.33, 8.0.40, 8.4.3, 9.1.0AnyAny`JSON_VALID` has inconsistent behavior for `NULL`
1166882024-11-18
3:23
2024-11-18
6:46
MySQL Server: JSONVerified
(301 days)
S28.0.36, 8.0.40, 8.4.3, 9.1.0AnyAnyUnexpected Behavior in `CASE` Statement with JSON Null Values
1166362024-11-13
5:25
2024-11-15
15:26
MySQL Server: OptimizerVerified
(304 days)
S28.4.3, 8.0.40, 9.1.0AnyAnyOptimizer incorrectly ignores all indexes with NO_INDEX() in some cases
1166242024-11-12
6:58
2024-11-27
8:24
MySQL Server: CompilingVerified
(292 days)
S3latest commitWindows (Windows 11)x86[MSVC] Race condition occurs during msbuild with VS2022
1166162024-11-11
15:37
2024-11-12
14:27
MySQL Server: CompilingVerified
(308 days)
S39.0AnyAnyDocumentation around AUTHENTICATION_CLIENT_PLUGINS in MySQL 9.0 is misleading
1166122024-11-11
11:46
2025-05-07
7:17
MySQL Server: OptimizerVerified
(308 days)
S58.0.40, 8.0.41, 8.4.4AnyAnyPerformance degradation of distinct operator from 5.7 to 8.0
1166112024-11-11
11:20
2024-11-11
12:09
MySQL Server: OptimizerVerified
(308 days)
S38.4.3, 8.0.40AnyAnyuser defined histogram import error for bigint data
1166062024-11-10
6:44
2024-11-11
7:16
MySQL Server: JSONVerified
(308 days)
S29.0, 8.0.40, 8.4.3, 9.1.0AnyAnyIncorrect Grouping in JSON_OBJECTAGG Aggregation for Case-Sensitive Column
1165942024-11-08
6:13
2024-11-26
7:51
MySQL Server: CompilingVerified
(293 days)
S28.4, 8.0Windowsx86[MSVC] MySQL failed to build with msvc on Windows when add ASAN option
1165842024-11-07
11:58
2024-11-10
6:46
MySQL Server: CharsetsVerified
(312 days)
S28.0.36, 8.0.40Any (Redhat 7.4)Any (Intel)Query produces different resultset with force index
1165722024-11-06
19:58
2024-11-11
10:05
MySQL Server: DMLVerified
(311 days)
S38.0AnyAnyInconsistent MATCH() Relevance Scores in BOOLEAN MODE When Grouping Results
1165472024-11-05
6:06
2024-11-05
8:08
MySQL Server: DMLVerified
(314 days)
S39AnyAnyInconsistent WHERE Condition Handling for ELT Function
1165342024-11-03
10:40
2024-11-06
12:58
MySQL Server: OptimizerVerified
(313 days)
S5596f0d23 (9.0.0)AnyAnyAnother Performance of TPC-H Query 16
1164922024-10-28
11:47
2024-11-06
13:48
MySQL Server: CharsetsVerified
(313 days)
S58.0, 8.0.40AnyAnyThe utf8mb4 character set has worse performance
1164842024-10-26
20:54
2024-10-31
15:06
MySQL Server: OptimizerVerified
(319 days)
S5596f0d23 (9.0.0), 9.1.0AnyAnyUnexpected Performance Dropdown for Query 11 in TPC-H
1164562024-10-23
6:43
2024-11-06
13:57
MySQL Server: OptimizerVerified
(319 days)
S5596f0d23 (9.0.0), 9.1.0AnyAnyPerformance of TPC-H Query 8
1164532024-10-22
21:49
2024-10-23
17:27
MySQL Server: OptimizerVerified
(327 days)
S19.0.0, 9.1.0AnyAnyquery_rewrite.flush_rewrite_rules() does not honor binlog_row_metadata=FULL
1164382024-10-21
19:06
2024-10-23
10:12
MySQL Server: Data TypesVerified
(327 days)
S38.0AnyAnyTimestamp literals have deceptive behavior in operations
1164142024-10-19
6:27
2024-10-19
15:07
MySQL Server: DMLVerified
(331 days)
S18.4.2, 8.0.40UbuntuAnyBOLB type or operation
1164002024-10-18
4:06
2024-10-18
5:56
MySQL Server: OptimizerVerified
(332 days)
S2trunk (9.1.0), 8.0.30, 8.4.3, 8.4.0AnyAnyContribution by Tencent: crash on explain format=tree for conn with subquery
1163982024-10-17
14:34
2024-10-25
9:40
MySQL Server: OptimizerVerified
(325 days)
S28.0AnyAnyIncorrect result with LEFT JOIN and small join_buffer_size
1163522024-10-14
2:57
2025-01-06
5:30
MySQL Server: GISVerified
(336 days)
S38.0.31, 8.0.39, 8.4.2AnyAnyspatial index cause check table wrong
1163382024-10-10
18:59
2024-10-11
7:55
MySQL Server: DMLVerified
(339 days)
S38.0.39AnyAnyINSERT fails on virtual date column referring to datetime column
1163352024-10-10
16:53
2025-09-10
1:54
MySQL Server: OptimizerVerified
(339 days)
S58.0.39AnyAnyMulti-valued index isn't used with some range scans on composite indexes
1163222024-10-09
10:48
2024-10-09
11:59
MySQL Server: DMLVerified
(341 days)
S3 9.0.1, 8.0.39AnyAnywhen log in mysql and do not select database, delete stmt returns error
1163092024-10-07
10:39
2024-10-22
11:32
MySQL Server: OptimizerVerified
(328 days)
S5596f0d23 (9.0.0), 9.1.0UbuntuAnyPerformance of TPC-H Query
1163002024-10-04
13:44
2024-10-04
14:34
MySQL Server: JSONVerified
(346 days)
S29.0AnyAnyTINYBLOB and BLOB with same value, stored as JSON, become different
1162412024-09-26
10:05
2024-10-25
11:03
MySQL Server: OptimizerVerified
(325 days)
S5596f0d23 (9.0.0), 9.1.0AnyAnyPotential Performance Improvement on TPC-H
1162272024-09-25
13:03
2024-10-09
11:58
MySQL Server: DMLVerified
(354 days)
S3 9.0.1AnyAnySome incorrect time should be detected
1162222024-09-25
10:56
2024-09-25
11:14
MySQL Server: ParserVerified
(355 days)
S39.0.1, 8.4.2, 8.0.39AnyAnymysql_parser_parse() gets different digest for query with trailing semicolon
1162112024-09-24
8:14
2024-09-26
11:19
MySQL Server: DMLVerified
(356 days)
S3 9.0.1, 8.4.2, 8.0.39AnyAnyzero value of year does not display as 4 characters in union clause
1161822024-09-20
13:39
2025-05-13
7:38
MySQL Server: DMLVerified
(360 days)
S39.0.1, 8.4.2, 8.0.39, 8.4.3AnyAnyrecursive CTE handling of decimal is unexpected
1161732024-09-20
7:16
2024-09-23
14:25
MySQL Server: CompilingVerified
(360 days)
S38.0.39Red Hat (9)AnyCan't build Mysql 8.0.39 in Copr for EPEL9
1161632024-09-19
14:08
2024-09-24
12:36
MySQL Server: OptimizerVerified
(356 days)
S29.0AnyAnyCOALESCE(BIT), IF(BIT) return a wrong result
1161602024-09-19
10:28
2024-09-20
8:58
MySQL Server: JSONVerified
(360 days)
S38.0AnyAnyPrecision loss of double value in JSON
1160842024-09-12
10:33
2024-09-12
13:48
MySQL Server: ParserVerified
(368 days)
S38.0,8.4, 9.0AnyAnyInvalid join order hints in expanded query with semijoin
1160502024-09-10
6:14
2024-10-24
11:53
MySQL Server: OptimizerVerified
(370 days)
S28.0.39, 8.4.2Linux (centos7)x86The query results are incorrect when using CTE, CONCAT, and IN.
1160432024-09-09
15:38
2024-09-12
1:22
MySQL Server: CompilingVerified
(369 days)
S38.0.39LinuxAnyCMakeLists.txt Incorrectly Sets LINUX Flag
1160342024-09-08
16:54
2024-09-09
7:05
MySQL Server: OptimizerVerified
(371 days)
S38.4.2, 8.0.39, 9.0.1AnyAny Unexpected behavior when subquery returns an empty set
1160142024-09-05
15:43
2024-11-07
14:51
MySQL Server: OptimizerVerified
(355 days)
S58.0.27+AnyAnyPerformance Degradation in Query Execution Plans
1159692024-08-30
13:59
2024-09-02
10:36
MySQL Server: OptimizerVerified
(378 days)
S58.0.39AnyAnyMySQL need not sort with ORDER BY primary_key on InnoDB on partial index match
1158932024-08-22
10:11
2024-08-22
12:55
MySQL Server: Data TypesVerified
(389 days)
S38.0AnyAnyInconsistent Results When Using COALESCE
1158562024-08-18
12:56
2024-08-19
7:26
MySQL Server: JSONVerified
(392 days)
S38.0, 8.4, 9.0AnyAnyComposite multi-valued index fails to be used for sorting
1158432024-08-15
8:26
2024-08-21
8:04
MySQL Server: OptimizerVerified
(390 days)
S28.0.32, 8.0.39AnyAnyThe incorrect calculation of 'select_limit' led to an incorrect index selection
1158422024-08-15
8:21
2024-08-20
7:37
MySQL Server: DMLVerified
(396 days)
S28.0.39, 8.4.2, 9.0.1AnyAnyThe count distinct aggregation funciton of UUID returned an error value
1158402024-08-15
2:30
2024-08-26
7:58
MySQL Server: OptimizerVerified
(396 days)
S28.0.39, 8.4.2, 9.0.1AnyAnyContribute by Tencent:Incorrect Cost Display for Join with Materialized Subquery
1158302024-08-14
2:24
2024-08-14
6:06
MySQL Server: DMLVerified
(397 days)
S38.0.39, 8.4.2, 9.0.1AnyAny`Replace into` may be invalid when functional key is unique
1158242024-08-13
7:36
2025-07-23
8:06
MySQL Server: CharsetsVerified
(392 days)
S38.0AnyAnyThe same LOAD DATA 5.7 and 8.0 result in different
1158152024-08-12
2:56
2024-08-12
8:03
MySQL Server: OptimizerVerified
(399 days)
S28.4.2AnyAnyContribute by tencent: EXPLAIN FORMAT=TREE Incorrectly Shows Cost of Statement
1158042024-08-09
5:10
2024-08-15
11:02
MySQL Server: OptimizerVerified
(402 days)
S38.0, 8.0.39AnyAnyKey not found error when executing query
1157962024-08-08
10:18
2024-08-08
10:23
MySQL Server: OptimizerVerified
(403 days)
S38.0.30,8.4.0AnyAnyderived_merge affect exists-subselect condition pushdown
1157942024-08-08
1:54
2024-08-08
6:38
MySQL Server: OptimizerVerified
(403 days)
S38.0.30,8.4.0AnyAnywrong plan may occur when EXISTS-subselect displays its correlated cache item
1157822024-08-06
11:24
2024-08-06
11:55
MySQL Server: OptimizerVerified
(405 days)
S38.0.30,8.4.0AnyAnyunfair comparison between materialization and EXISTS
1157782024-08-06
6:24
2024-08-07
7:17
MySQL Server: DMLVerified
(404 days)
S38.4.0, 8.0AnyAnyCast DATE_ADD/SUB result as double get wrong result.
1157232024-07-30
5:02
2025-01-22
2:51
MySQL Server: DMLVerified
(236 days)
S39.0.1, 8.0.39AnyAnyFor into exists strategy of subquery, table condition may be ignored
1156792024-07-24
9:04
2024-07-24
9:46
MySQL Server: OptimizerVerified
(418 days)
S58.0.37AnyAnyBlock Nested-Loops Join can sometimes slow down the query
1156762024-07-24
4:34
2024-07-24
9:46
MySQL Server: OptimizerVerified
(418 days)
S58.0.37, 8.0.39AnyAnyThe optimizer has chosen a poor execution plan.
1156712024-07-23
9:47
2024-07-23
13:49
MySQL Server: OptimizerVerified
(419 days)
S58.0.37, 8.0.39AnyAnyThe optimizer has chosen a poor execution plan.
1156612024-07-22
5:48
2024-08-15
14:22
MySQL Server: OptimizerVerified
(420 days)
S2mysql 8.4.1, 8.0.38, 9.0.0LinuxAnyQuery results are incorrect after semijoin is turned on
1156542024-07-20
14:01
2025-07-30
11:58
MySQL Server: OptimizerVerified
(420 days)
S29.0.0, 8.0.38, 8.4.1, 9.3Ubuntu (Ubuntu 20.04.6 LTS)x86 (5.15.0-113-generic)Changing “internal_tmp_mem_storage_engine” returns incorrect results
1155652024-07-11
9:37
2024-07-11
13:11
MySQL Server: OptimizerVerified
(431 days)
S38.0AnyAnyPartition tables:compare the field with null and return an incorrect result
1155602024-07-10
15:43
2024-07-12
8:14
MySQL Server: OptimizerVerified
(430 days)
S38.0.38LinuxAnyJSON functional index not being considered for NULL check
1155592024-07-10
13:59
2024-07-11
13:10
MySQL Server: OptimizerVerified
(431 days)
S38.0AnyAnyRow constructor comparison with nested join fails to match rows
1155552024-07-10
10:31
2024-09-16
9:49
MySQL Server: OptimizerVerified
(378 days)
S58.4, 8.0.39AnyAnySevere performance regression in filesort
1155512024-07-10
1:09
2024-07-27
0:12
MySQL Server: CompilingVerified
(415 days)
S38.0AnyAnycomp_err hits AddressSanitizer: stack-buffer-overflow
1155192024-07-05
4:24
2024-07-16
13:34
MySQL Server: OptimizerVerified
(426 days)
S28.2, 8.4.1AnyAnyINTERSECT within correlated subquery results in incorrect result
1155182024-07-05
3:26
2024-08-15
7:00
MySQL Server: DMLVerified
(437 days)
S38.0.38,5.7.44,8.4,9.0AnyAnyLost a record while scanning in reverse order on cursor
1155072024-07-04
7:22
2025-07-11
5:10
MySQL Server: OptimizerVerified
(438 days)
S38.4.0, 8.4.1, 8.0.38AnyAnyif set subquery_to_derived=on, unqualified_count could not be genereated
1154712024-07-01
5:04
2024-07-04
8:23
MySQL Server: CompilingVerified
(438 days)
S38.0.37, 8.4.0MacOS (14.5)ARMLinker errors with enabled LTO
1154102024-06-23
16:02
2024-06-26
14:33
MySQL Server: Data TypesVerified
(447 days)
S38.0AnyAnyMySQL bit field index affects query results unexpectedly.
1154002024-06-21
4:14
2024-07-02
14:58
MySQL Server: OptimizerVerified
(451 days)
S38.4.0 LTSAnyAnyThe hint /+ NO_BNL(t0)/ does not always work as expected
1153982024-06-20
23:58
2024-06-21
5:51
MySQL Server: CharsetsVerified
(451 days)
S38.4.0AnyAnyContribution: Add \"Traditional Chinese\" collation for utf8mb4
1153802024-06-19
8:21
2024-06-19
8:53
MySQL Server: OptimizerVerified
(453 days)
S38.0.32, 8.0.37AnyAnyUpdate Multiple table failed when table is partitioned and using MRR path
1153532024-06-17
7:22
2024-10-14
15:29
MySQL Server: OptimizerVerified
(455 days)
S28.0.37, 8.4.0 LTSAnyAnySetting index_merge_union leads to incorrect results.
1153272024-06-13
22:01
2024-06-19
12:26
MySQL Server: OptimizerVerified
(453 days)
S58.0.37, 8.4.0AnyAnyHigher memory requirements for range optimizer in v. 8.0 vs 5.7
1152832024-06-11
12:00
2024-10-31
10:16
MySQL Server: OptimizerVerified
(461 days)
S28.0.37AnyAnyresult not correct when using ‘<=>’ operator compare null value
1152792024-06-11
7:10
2024-06-11
11:52
MySQL Server: CompilingVerified
(461 days)
S38.0.37AnyAnyWarning about YYSTYPE in mysql-8.0.37
1152782024-06-11
6:54
2024-06-11
8:59
MySQL Server: DMLVerified
(461 days)
S28.0.36, 8.0.37Any (Tested on Windows and AWS RDS))Any (Tested on x64 and AWS Graviton (Arm))Missing records in result when nullablle field with a unique index<=>NULL
1152692024-06-10
12:53
2024-06-11
10:29
MySQL Server: DMLVerified
(462 days)
S38.0AnyAny"INSERT SET column=column" inserts zero date
1152272024-06-05
10:45
2024-08-09
9:32
MySQL Server: OptimizerVerified
(467 days)
S58.0AnyAnyprepared statement encounter performance degradation compared with normal select
1152082024-06-04
8:51
2024-06-04
9:08
MySQL Server: OptimizerVerified
(468 days)
S38.0.33AnyAnyLast_query_cost could be negative number due to unmatched cost values in JOIN
1151912024-06-01
4:29
2024-06-01
9:04
MySQL Server: CompilingVerified
(471 days)
S58.0.37AnyAnyoptimize for net_write_buff
1151902024-05-31
22:12
2024-06-01
9:46
MySQL Server: OptimizerVerified
(471 days)
S58.0.36Ubuntu (jammy)AnyFailure to use index with subquery and tuples
1151612024-05-29
11:28
2024-05-29
12:18
MySQL Server: OptimizerVerified
(474 days)
S28.4.0AnyAnyhint for join order doesn't work
1151562024-05-29
6:48
2024-05-29
7:49
MySQL Server: CompilingVerified
(474 days)
S3mysql-trunk, 8.0AnyAnyPotential Nullptr Derefence in file `strings\ctype-ucs2.cc`
1151542024-05-29
5:40
2024-05-31
13:44
MySQL Server: CharsetsVerified
(472 days)
S28.0.37AnyAnyDynamic Changes to the character_set_% are not honored duing the handshake
1151462024-05-28
2:38
2024-05-29
12:55
MySQL Server: OptimizerVerified
(475 days)
S38.0AnyAnyInconsistent Results in SQL Query
1151272024-05-26
5:51
2024-05-27
12:35
MySQL Server: DMLVerified
(476 days)
S38.0AnyAnyinvalid result set with window function and generated rand value
1151232024-05-25
13:41
2024-05-25
15:49
MySQL Server: DMLVerified
(478 days)
S28.0AnyAnyInconsistent Results with DATE_ADD and BETWEEN Clause
1151222024-05-25
11:17
2024-06-16
9:10
MySQL Server: OptimizerVerified
(456 days)
S58.4 (Latest), 8.0.37Ubuntu (22.04 LTS)ARMUnneeded full table scan, although there is an index and condition
1151112024-05-24
7:33
2024-06-07
11:56
MySQL Server: DMLVerified
(479 days)
S38.4.0, 8.0.37AnyAnylast_insert_id evaluated twice if used nested
1150852024-05-22
20:39
2024-06-27
8:11
MySQL Server: DMLVerified
(480 days)
S28.0.34, 8.4.0Any (Docker Image)x86INDEX using CAST (json_column) AS ARRAY drops rows containing empty array
1150752024-05-22
3:49
2024-05-22
7:00
MySQL Server: OptimizerVerified
(481 days)
S38.0AnyAnyUnexpected subquery execution times
1150402024-05-16
12:09
2024-10-29
10:09
MySQL Server: OptimizerVerified
(487 days)
S38.0AnyAnyIncorrect result from lateral join with group by month/monthname function inside
1150172024-05-15
14:44
2024-07-01
11:21
MySQL Server: OptimizerVerified
(488 days)
S28.0AnyAnyWrong row estimate for range scan
1149702024-05-13
3:42
2024-05-13
6:04
MySQL Server: OptimizerVerified
(490 days)
S18.0.33AnyAnyprev_record_reads() use stale cardinality to calculate after plan enumeration
1149472024-05-09
23:54
2024-06-27
10:05
MySQL Server: DMLVerified
(493 days)
S38.0.37AnyAnyRight and Left functions do not work as documented within WHERE clauses
1149222024-05-08
9:25
2024-05-08
9:58
MySQL Server: OptimizerVerified
(495 days)
S18.0.36AnyAnyIncorrect query results caused by different data conversion
1149172024-05-08
2:52
2024-05-23
12:10
MySQL Server: OptimizerVerified
(490 days)
S38.0.35, 8.0.37, 8.4AnyAnyIncorrect query result
1148872024-05-05
9:20
2024-05-06
6:33
MySQL Server: OptimizerVerified
(497 days)
S18.2.0, 8.0.37AnyAnyIncorrect Muti-table join with group by execution
1148862024-05-05
9:16
2024-05-06
6:30
MySQL Server: OptimizerVerified
(497 days)
S18.2.0, 8.0.37AnyAnyIncorrect semi-join with group by execution
1148852024-05-05
9:07
2024-05-06
6:24
MySQL Server: OptimizerVerified
(497 days)
S18.2.0, 8.0.37AnyAnyIncorrect group by execution
1148842024-05-05
9:03
2024-05-06
6:22
MySQL Server: OptimizerVerified
(497 days)
S28.2.0, 8.0.37AnyAnyIncorrect inner join with group by execution
1148302024-05-01
0:51
2024-11-24
15:54
MySQL Server: CharsetsVerified
(501 days)
S38.0AnyAnyMySQL converts collection of date data type in ibd but data dictionary
1148122024-04-29
9:55
2024-04-29
10:19
MySQL Server: OptimizerVerified
(504 days)
S58.0.36,5.7.44AnyAnyin list values exceed eq_range_index_dive_limit cause index not used
1148072024-04-29
6:28
2024-04-30
3:06
MySQL Server: DMLVerified
(504 days)
S38.0.33AnyAnySubquery returns more than 1 row
1147952024-04-26
10:05
2024-04-29
9:56
MySQL Server: OptimizerVerified
(507 days)
S38.0AnyAnyArithmetic overflow when calculating the length of used fields involving blob
1147942024-04-26
9:36
2024-04-26
12:23
MySQL Server: OptimizerVerified
(507 days)
S38.0AnyAnyIncorrect query result
1147832024-04-25
11:32
2024-04-29
5:40
MySQL Server: OptimizerVerified
(504 days)
S2mysql-8.0.35, 8.0.36LinuxAnyBackward scan partition table with multi-valued Indexes may lost some result.
1147752024-04-25
6:35
2024-04-25
12:38
MySQL Server: DMLVerified
(508 days)
S38.0.35, 8.0.36Ubuntu (AWS RDS)x86Outer join condition filtering bug when using scalar subquery
1147622024-04-24
10:05
2024-04-25
14:23
MySQL Server: OptimizerVerified
(509 days)
S38.0AnyAnyinvalid result set with join lateral and group by on a generated field
1147512024-04-24
2:53
2024-04-24
7:24
MySQL Server: OptimizerVerified
(509 days)
S18.0.36AnyAnyIncorrect query result
1147412024-04-23
9:43
2024-04-23
13:36
MySQL Server: OptimizerVerified
(510 days)
S38.0AnyAnyInconsistent query results caused by different execution of subqueries
1147192024-04-21
14:31
2024-04-22
7:46
MySQL Server: OptimizerVerified
(511 days)
S18.0.36AnyAnyIncorrect results caused by different access types for an index
1147182024-04-21
12:09
2024-04-22
7:45
MySQL Server: DMLVerified
(511 days)
S18.0.36AnyAnyIncorrect query results
1147142024-04-20
3:54
2025-05-09
12:41
MySQL Server: OptimizerVerified
(511 days)
S38.0.33AnyAnyDuplicate subquery explain plan output when explain format is tree
1146822024-04-18
11:57
2024-04-18
13:49
MySQL Server: OptimizerVerified
(515 days)
S38.0AnyAnyDuplicate key error when executing query
1145992024-04-09
16:13
2024-12-04
10:41
MySQL Server: CompilingVerified
(285 days)
S38.0AnyAnyContribution: Fix: month\'s name Indonesia
1145812024-04-08
11:24
2024-04-08
12:37
MySQL Server: OptimizerVerified
(525 days)
S28.0.36AnyAny Constant-Folding optimization negative constant truncate gives wrong operator
1145682024-04-07
13:43
2024-04-08
7:28
MySQL Server: OptimizerVerified
(525 days)
S18.0.36AnyAnyDifferent join orders cause inconsistent results
1145592024-04-05
12:12
2024-04-08
9:26
MySQL Server: OptimizerVerified
(528 days)
S38.0AnyAnyUnexpected Results by the hint SUBQUERY(MATERIALIZATION)
1145392024-04-03
7:36
2024-04-03
8:14
MySQL Server: OptimizerVerified
(530 days)
S18.0.36AnyAnyUnexpected Results by the hint NO_INDEX
1145342024-04-03
4:22
2024-04-03
8:22
MySQL Server: DMLVerified
(530 days)
S38.0.36AnyAnyInconsistent result with index and symbol '̏
1145242024-04-01
12:36
2025-06-16
11:58
MySQL Server: OptimizerVerified
(531 days)
S38.3.0AnyAnyINSERT with JSON column error
1145122024-03-29
9:35
2024-06-17
9:54
MySQL Server: OptimizerVerified
(455 days)
S58.3.0, 8.0.36AnyAnyMySQL 8: Order by with hash join incredibly slow
1145102024-03-29
6:42
2024-03-29
7:29
MySQL Server: OptimizerVerified
(535 days)
S28.0.36Linuxx86Inconsistent results after dropping index on join column
1144622024-03-23
10:30
2024-04-04
9:20
MySQL Server: DMLVerified
(539 days)
S38.3.0, 8.0.36Ubuntu (Ubuntu 22.04)x86 (x86_64)Strange SQL_BUFFER_RESULT error
1144562024-03-22
14:54
2025-03-17
14:46
MySQL Server: CompilingVerified
(185 days)
S3AnyAnyContribution: Fix OpenSSL linking when only static libs are available
1144182024-03-19
23:20
2024-03-20
7:25
MySQL Server: DMLVerified
(544 days)
S28.0.36AnyAnyFlaw in SOUNDEX implementation causing incorrect results
1143842024-03-17
14:33
2024-03-18
6:57
MySQL Server: DMLVerified
(546 days)
S38.0.15,8.0.35, 8.0.36AnyAnyIncorrect query result may caused by LOG
1143832024-03-17
14:11
2024-03-20
11:19
MySQL Server: DMLVerified
(546 days)
S28.0.23,8.0.35AnyAnyIncorrect query result may caused by DATE and window function
1143822024-03-17
13:58
2024-03-20
11:20
MySQL Server: DMLVerified
(546 days)
S28.0.11, 8.0.35, 8.0.36AnyAnyIncorrect query result may caused by LOW_PRIORITY
1143812024-03-17
13:47
2024-03-20
11:21
MySQL Server: DMLVerified
(546 days)
S38.0.19,8.0.35AnyAnyIncorrect query result may caused by EXISTS and TIMEDIFF
1143802024-03-17
13:19
2024-03-20
11:21
MySQL Server: DMLVerified
(546 days)
S38.0.13, 8.0.35, 8.0.36AnyAnyIncorrect query result may caused by TIMESTAMP
1143792024-03-17
13:01
2024-03-20
11:22
MySQL Server: DMLVerified
(546 days)
S38.0.27, 8.0.35, 8.0.21AnyAnyIncorrect query result caused by index and optimizer
1143782024-03-17
12:44
2024-04-23
16:37
MySQL Server: DMLVerified
(546 days)
S38.0, 8.0.35AnyAnyIncorrect query result caused by CONVERT_TZ
1143732024-03-15
16:32
2024-03-20
11:03
MySQL Server: Data TypesVerified
(544 days)
S38.0AnyAnyIncorrect result after transformation from "IN (SELECT)" to "materialization"
1143382024-03-13
16:41
2024-03-19
11:10
MySQL Server: Prepared statementsVerified
(550 days)
S38.0AnyAnyClient might receive incorrect data in ps-protocol
1143332024-03-13
10:50
2024-03-13
16:33
MySQL Server: DMLVerified
(551 days)
S38.0AnyAnyLead/lag window functions returning BLOB instead of VARCHAR
1143122024-03-12
6:30
2024-03-19
2:26
MySQL Server: DMLVerified
(545 days)
S38.0AnyAnyItem_ref::used_tables wrong when ref to a rollup constant
1143012024-03-11
16:40
2024-03-12
16:23
MySQL Server: OptimizerVerified
(552 days)
S38.0AnyAnyIncorrect result with IS NULL predicate in join condition
1142912024-03-10
7:20
2024-06-27
10:05
MySQL Server: GISVerified
(554 days)
S38.2.0, 8.0.36AnyAnyST_Overlap gives an incorrect answer.
1142822024-03-08
13:10
2024-03-08
13:13
MySQL Server: DMLVerified
(556 days)
S28.35, 8.0.36AnyAnyInconsistent result may caused by group by NULL
1142702024-03-07
23:23
2024-03-08
4:11
MySQL Server: CompilingVerified
(556 days)
S38.0AnyAnyContribution: Fix operator name keywords causing obscure errors on -fno-ope ...
1142372024-03-06
6:57
2024-03-06
8:30
MySQL Server: OptimizerVerified
(558 days)
S58.2.0, 8.3.0AnyAnyUnexpected Cardinality by Index
1142182024-03-05
4:50
2024-03-05
7:01
MySQL Server: DMLVerified
(559 days)
S28.2.0, 8.3.0, 8.0.36AnyAnyUnexpected Results by MEMORY ENGINE
1142172024-03-05
4:48
2024-03-05
7:01
MySQL Server: DMLVerified
(559 days)
S28.2.0, 8.3.0, 8.0.36AnyAnyUnexpected Results by Minus Sign
1142042024-03-04
8:43
2024-03-04
8:58
MySQL Server: DMLVerified
(560 days)
S28.2.0, 8.3.0AnyAnyUnexpected Results by COALESCE
1141952024-03-02
15:24
2024-03-04
6:56
MySQL Server: CharsetsVerified
(560 days)
S38.0.36AnyAnymysql doesn't show what collation was used sometimes
1141492024-02-28
3:20
2024-02-28
5:54
MySQL Server: DMLVerified
(565 days)
S38.0+LinuxAnyIncorrect query result caused by where optimization
1140922024-02-22
23:40
2024-02-26
14:58
MySQL Server: OptimizerVerified
(569 days)
S5Ver 8.0.36-0Ubuntu (ubuntu 22.04.1)x86 (Linux on x86_64 ((Ubuntu)))WHERE statement on an indexed decimal column hangs
1140862024-02-21
19:41
2025-01-29
11:22
MySQL Server: CharsetsVerified
(567 days)
S38.0AnyAnyItem_singlerow_subselect::store may lead to memory corruption
1140562024-02-19
23:03
2024-02-22
10:56
MySQL Server: Prepared statementsVerified
(571 days)
S58.0.32, 8.0.22+AnyAnyPerformance degredation using REGEXP in statement with parameters vs query
1140272024-02-17
19:34
2024-02-19
6:29
MySQL Server: OptimizerVerified
(574 days)
S38.0.36 & 8.3.0Windows (10 & 11)ARM (x64)Plans for inner hash join show that wrong table is hashed
1139922024-02-14
14:11
2025-02-01
11:59
MySQL Server: CompilingVerified
(579 days)
S38.0AnyAnyContribution: Improved the way my_plugin_log_message() handles plugin_ptr a ...
1139622024-02-12
14:05
2024-02-12
15:11
MySQL Server: DMLVerified
(581 days)
S38.0AnyAnyContribution: Fix offset check for insert position overflow
1139492024-02-09
19:55
2024-02-12
9:16
MySQL Server: ParserVerified
(581 days)
S38.3.0, 8.0.36AnyAnyBackslash escaping inconsistency in LIKE operator
1138922024-02-05
10:39
2024-02-05
14:13
MySQL Server: OptimizerVerified
(588 days)
S38.0AnyAnyFORCE INDEX reports wrong number of rows
1138882024-02-04
3:38
2025-02-01
11:58
MySQL Server: GISVerified
(589 days)
S28.0Linuxx86st_contains function result is obviously wrong
1138432024-02-01
2:49
2024-02-01
8:09
MySQL Server: Prepared statementsVerified
(592 days)
S38.0.32, 8.0.36AnyAnyprepared json query can not use index
1138002024-01-30
5:30
2024-01-31
8:28
MySQL Server: DMLVerified
(593 days)
S58.0.22, 8.0.36, 8.0.11Linuxx86Performance degradation of Blob operations comparing with MySQL 5.7
1137682024-01-26
2:40
2024-01-26
8:53
MySQL Server: DMLVerified
(598 days)
S38.0.35LinuxAnyreturn error with cast
1137622024-01-25
17:05
2024-01-26
7:05
MySQL Server: DMLVerified
(598 days)
S38.0.36AnyAnyUnexpected results when using ASIN function with NULLIF
1137182024-01-23
4:42
2024-01-23
7:22
MySQL Server: OptimizerVerified
(601 days)
S28.0.35, 8.0.36, 8.3.0AnyAnyleft join + semijoin + materialization finds false matches
1136492024-01-16
10:17
2024-01-16
11:03
MySQL Server: DMLVerified
(608 days)
S38.0.31, 8.0.35AnyAnythe result of format function truncated when using cursor
1136412024-01-15
5:42
2024-01-15
5:50
MySQL Server: JSONVerified
(609 days)
S28.0.28AnyAnyMulti-valued index can lead to incorrect result with implicit conversion
1135872024-01-09
3:31
2024-02-27
12:25
MySQL Server: OptimizerVerified
(609 days)
S28.0AnyAnySELECT DISTINCT makes ORDER BY ... DESC sort data to ascending
1135862024-01-09
3:13
2024-01-09
12:27
MySQL Server: OptimizerVerified
(615 days)
S38.0AnyAnyIFNULL Incorrect query result
1135782024-01-08
13:06
2024-05-21
10:11
MySQL Server: DMLVerified
(614 days)
S35.7.44, 8.0.35AnyAnyAVG calculation bug
1135572024-01-04
15:29
2024-01-04
15:40
MySQL Server: JSONVerified
(620 days)
S28.0.35AnyAnyWrong query result on composite multi-valued index + empty array value
1135512024-01-04
10:04
2024-01-10
11:21
MySQL Server: OptimizerVerified
(614 days)
S38.2.0Linux (mysql docker image 8.2.0)AnyDiscrepancy in MySQL 8.2.0 Documentation Regarding Subquery Scoping Rules
1135412024-01-03
9:17
2024-01-03
10:07
MySQL Server: DMLVerified
(621 days)
S38.2.0AnyAnyRegexp validation failure on empty table
1135372024-01-02
16:00
2024-01-04
10:44
MySQL Server: CharsetsVerified
(620 days)
S38.0.32AnyAnyFalse match of multibyte chars when checking existence of a control character
1135342024-01-02
8:27
2024-01-05
2:27
MySQL Server: OptimizerVerified
(619 days)
S18.0.35AnyAnytable join return Unexpected result when drived table using include join index
1135132023-12-26
12:12
2023-12-27
5:20
MySQL Server: OptimizerVerified
(628 days)
S38.0.33AnyAnyJoin reordering regression and inconsistent behavior for SQL involving LEFT JOIN
1134622023-12-19
16:05
2023-12-20
15:06
MySQL Server: OptimizerVerified
(635 days)
S38.0AnyAnyIncorrect result
1134462023-12-18
2:32
2024-10-22
4:28
MySQL Server: DMLVerified
(637 days)
S38.0.33AnyAnyQuery with DISTINCT and ORDER BY on BIT data type returns wrong result
1134442023-12-16
16:23
2023-12-17
13:28
MySQL Server: CompilingVerified
(638 days)
S38.2.0CentOSx86Contribution by Tencent:-DBISON_EXECUTABLE may cause compile error
1134292023-12-14
21:13
2023-12-18
13:33
MySQL Server: DMLVerified
(637 days)
S58.0AnyAnyFunction call duplicated in CTE
1134262023-12-14
17:21
2023-12-15
7:35
MySQL Server: CompilingVerified
(640 days)
S3mysql-trunkOracle Linuxx86using -DWITH_INNODB_EXTRA_DEBUG results in compilation error
1134152023-12-14
6:27
2023-12-14
8:51
MySQL Server: DMLVerified
(641 days)
S38.0, 8.0.35AnyAnyUnknown column, but can get query result in CTE.
1133842023-12-09
8:05
2023-12-11
11:42
MySQL Server: Data TypesVerified
(644 days)
S38.0AnyAnyQueried with partitions,returned result is error
1133682023-12-08
3:10
2023-12-08
8:01
MySQL Server: DMLVerified
(647 days)
S35.7.44-log, 8.0AnyAnyIN() has a problem handling when the expression on the left is of type time
1133662023-12-08
1:39
2023-12-08
8:06
MySQL Server: DMLVerified
(647 days)
S38.0.35AnyAnyIncorrect query results involving the date type.
1133582023-12-07
7:09
2023-12-07
8:42
MySQL Server: OptimizerVerified
(648 days)
S38.0, 8.0.35AnyAnyWrong functional dependency in ONLY_FULL_GROUP_BY mode
1133202023-12-04
9:00
2023-12-04
11:30
MySQL Server: OptimizerVerified
(651 days)
S28.0AnyAny (DarwinMatt.local 22.5.0 Darwin Kernel Version 22.5.0: root:xnu-8796.121.2~5/RELEASE_ARM64_T6020 arm6)SELECT DISTINCT .. ORDER BY query yields wrong sort order
1133172023-12-04
5:29
2024-10-14
15:31
MySQL Server: DMLVerified
(651 days)
S18.0.35, 8.1.0, 8.2.0AnyAnyUnexpected Result by IF
1133162023-12-04
3:32
2023-12-04
7:21
MySQL Server: OptimizerVerified
(651 days)
S38.0.35, 8.1.0, 8.2.0AnyAnyWhen the bit type has an index, the query result is incorrect.
1133042023-12-01
7:52
2023-12-01
8:20
MySQL Server: DMLVerified
(654 days)
S18.2.0, 8.0.35AnyAnyUnexpected Result for LEAST function
1133032023-12-01
7:29
2023-12-05
4:54
MySQL Server: OptimizerVerified
(654 days)
S58.0.35AnyAnyExplain plan takes forever when there are more joins
1133022023-12-01
7:29
2023-12-01
7:41
MySQL Server: DMLVerified
(654 days)
S18.2.0, 8.0.35AnyAnyUnexpected Result for an Index
1133012023-12-01
7:22
2023-12-01
8:53
MySQL Server: Prepared statementsVerified
(654 days)
S28.0.35, 8.0.31AnyAnyusing preparation statement to query the time type data, some data is not found
1132982023-12-01
4:41
2023-12-01
4:55
MySQL Server: OptimizerVerified
(654 days)
S38.0.33, 8.1.0, 8.0.35AnyAnyUnexpected Results when Using IN for Floating-Point
1132882023-11-30
6:58
2023-12-01
11:37
MySQL Server: OptimizerVerified
(655 days)
S58.0.33AnyAnyExplain plan shows dynamic range, but bug causes no chance to use for LEFT JOIN
1132702023-11-29
0:18
2023-11-29
10:34
MySQL Server: CompilingVerified
(656 days)
S38.0.35AnyAnyUnable to compile 8.0.35 with DISABLE_PSI_THREAD
1132112023-11-24
12:14
2023-11-24
12:34
MySQL Server: OptimizerVerified
(661 days)
S28.0.35, 8.1.0, 8.2.0AnyAnyThe latest version 8.0 returns abnormal results for complex queries
1132092023-11-24
9:16
2023-11-27
8:38
MySQL Server: DMLVerified
(658 days)
S38.0, 8.1, 8.2.0, 5.7AnyAnyCasting str to date, unexpectedly allows for 00 month/day
1132052023-11-24
3:06
2023-11-24
6:01
MySQL Server: GISVerified
(661 days)
S38.2.0, 8.0.35AnyAnyAfter swapping the X and Y coordinates, ST_Crosses gives the incorrect answer.
1131802023-11-22
10:12
2023-11-23
8:46
MySQL Server: DMLVerified
(663 days)
S38.0.33, 8.1.0, 8.0.35AnyAnyUnexpected Results when Using Math Function SIN
1131672023-11-21
14:17
2023-11-22
7:24
MySQL Server: GISVerified
(663 days)
S28.2.0, 8.0.35AnyAnyAfter creating the spatial index, ST_Disjoint gives the incorrect answer
1131542023-11-20
21:57
2023-11-21
6:25
MySQL Server: DMLVerified
(664 days)
S28.2.0, 8.1.0, 8.0.35LinuxAnyJoin using ROW_NUMBER() returns incorrect records
1131352023-11-20
3:03
2023-11-20
15:34
MySQL Server: DMLVerified
(665 days)
S38.0AnyAnyDISTINCT JOIN ORDER BY statements ignore ORDER BY when tmp_table_size is small
1131132023-11-16
20:26
2025-01-29
11:51
MySQL Server: CompilingVerified
(229 days)
S38.0.41MacOSAnyBuild failure with Homebrew LLVM 14-19 on macOS
1130602023-11-13
10:23
2025-03-16
20:45
MySQL Server: DMLVerified
(672 days)
S38.0AnyAnyThe result of avg(distinct xx)is different between from primary and secondary
1130592023-11-13
8:29
2023-11-13
9:51
MySQL Server: OptimizerVerified
(672 days)
S28.2.0AnyAnyInconsistent results when using DUPSWEEDOUT
1130492023-11-10
15:28
2024-01-17
16:27
MySQL Server: JSONVerified
(607 days)
S28.0.35, 8.2.0AnyAnyMTR test json.array_index fails with a result difference
1130452023-11-10
14:54
2024-05-24
10:12
MySQL Server: CompilingVerified
(479 days)
S38.0LinuxAny (x86_64,arm64)Build failure with Protobuf 24.2 in Linux
1130152023-11-09
3:25
2023-11-14
7:35
MySQL Server: DMLVerified
(676 days)
S38.0.35AnyAnyREGEXP curly brackets without escape character works on 5.7 but not in 8.0
1129852023-11-07
8:33
2023-11-08
10:54
MySQL Server: OptimizerVerified
(678 days)
S38.0, 8.1, 8.2AnyAnyInconsistent results when switching hash join optimization
1129142023-11-01
9:43
2023-11-01
15:02
MySQL Server: OptimizerVerified
(684 days)
S38.0AnyAnydifferent result related to zerofill and greatest()
1129122023-11-01
8:45
2023-11-01
14:47
MySQL Server: OptimizerVerified
(684 days)
S38.0AnyAnyParsing a string To BIT type got a wrong result
1129112023-11-01
8:21
2023-11-01
8:56
MySQL Server: OptimizerVerified
(684 days)
S28.1.0, 8.0.35AnyAnyInconsistent results when using PRIMARY and DUPSWEEDOUT
1129102023-11-01
7:20
2023-11-01
7:31
MySQL Server: OptimizerVerified
(684 days)
S28.1.0, 8.0.35AnyAnyIncorrect results when add an uncorrelated row
1129022023-10-31
14:39
2024-06-10
11:08
MySQL Server: OptimizerVerified
(567 days)
S58.0.31, 8.0.35Linux (n.a.)x86 (x86_64)Optimizer in MySQL 8 is significantly slower on dependent subqueries than 5.7
1128532023-10-27
8:32
2023-12-18
2:17
MySQL Server: DMLVerified
(637 days)
S38.0AnyAnyWrong functional dependency in ONLY_FULL_GROUP_BY mode
1128522023-10-27
7:42
2023-11-06
11:25
MySQL Server: DMLVerified
(679 days)
S38.0Linuxx86insert and insert onduplicate are executed concurrently, data update error
1128482023-10-27
2:28
2023-10-27
11:37
MySQL Server: Data TypesVerified
(689 days)
S38.0AnyAnyItem_func_set_user_var::get_string_value may have potion risk of memory access
1128262023-10-25
7:47
2023-10-25
8:27
MySQL Server: DMLVerified
(691 days)
S38.1.0, 8.0.34Ubuntu (22.04)x86 (x86_64)Decimal query with wrong result
1128162023-10-24
16:15
2023-12-13
12:00
MySQL Server: OptimizerVerified
(682 days)
S28.0, 8.1AnyAnyInconsistent results when JOINed in different order
1128022023-10-23
8:23
2023-10-27
9:46
MySQL Server: OptimizerVerified
(693 days)
S38.1.0, 8.0.34AnyAnyInconsistent results when using INDEX
1127372023-10-16
9:07
2025-04-23
16:11
MySQL Server: OptimizerVerified
(700 days)
S58.0, 8.0.34AnyAnyConditions refering to const table were not added to RANGE SCAN
1127292023-10-15
11:20
2023-10-16
6:13
MySQL Server: ParserVerified
(700 days)
S38.1.0AnyAnyTwo single quotes escaping inconsistency in index expression
1127282023-10-15
9:51
2023-10-18
15:43
MySQL Server: OptimizerVerified
(698 days)
S38.0AnyAnyMySQL optimizer generated an incorrect execution plan
1127032023-10-12
12:13
2025-08-25
7:23
MySQL Server: Prepared statementsVerified
(704 days)
S3AnyAnyprepare statment has no warning comping to not prepare statment.
1126472023-10-06
9:28
2023-10-09
6:56
MySQL Server: CompilingVerified
(707 days)
S38.0.34,8.1.0AnyAnyclang-format 17 errors out on .clang-format
1126422023-10-05
18:40
2023-10-09
10:17
MySQL Server: OptimizerVerified
(709 days)
S38.0AnyAnyWrong results when MRR is activated
1125972023-10-03
12:14
2023-10-05
14:13
MySQL Server: OptimizerVerified
(711 days)
S58.0AnyAnySlow performance
1125792023-09-30
8:37
2023-10-02
9:16
MySQL Server: DMLVerified
(714 days)
S28.0.14 - 8.0.34AnyAnyInconsistent results of SELECT with <=> and NULLIF
1125722023-09-29
9:44
2023-09-29
12:27
MySQL Server: OptimizerVerified
(717 days)
S38.0AnyAnyInconsistent results of SELECT statement with HEX, REVERSE, and RPAD functions
1125432023-09-27
19:23
2023-10-03
12:05
MySQL Server: OptimizerVerified
(713 days)
S38.0AnyAnyQuery rewrite plugin can't be used to parse and change reserved words
1125272023-09-26
14:46
2023-09-27
7:25
MySQL Server: DMLVerified
(719 days)
S28.0.11, 8.0.34, 8.1.0AnyAnyInconsistent results caused by REPEAT function
1125242023-09-26
13:32
2023-09-27
7:52
MySQL Server: DMLVerified
(719 days)
S25.7, 8.0.0, 8.0.34AnyAnyInconsistent results of UNIX_TIMESTAMP with NULLIF and COALESCE
1124512023-09-25
6:35
2023-09-25
7:37
MySQL Server: OptimizerVerified
(721 days)
S38.0,8.1AnyAnyIncorrect result if there are non-deterministic expressions in in-subquery
1124502023-09-25
6:25
2023-09-25
7:45
MySQL Server: OptimizerVerified
(721 days)
S38.0.28AnyAnyIncorrect result
1124222023-09-22
1:54
2023-09-25
11:49
MySQL Server: OptimizerVerified
(721 days)
S38.0AnyAnyThe outer select group_concat(NULL) return an empty string
1123942023-09-20
13:13
2023-09-21
12:16
MySQL Server: OptimizerVerified
(725 days)
S38.0AnyAnyInconsistent results caused by subqueries in FROM and EXISTS
1123772023-09-18
23:01
2023-09-19
12:24
MySQL Server: OptimizerVerified
(727 days)
S38.0AnyAnyAssert in AccessPath::index_merge()
1123462023-09-14
8:21
2023-10-11
7:24
MySQL Server: JSONVerified
(705 days)
S58.0.34AnyAnyMEMBER_OF with multi-valued index on JSON not used in 99% of situations.
1123452023-09-14
7:53
2025-05-13
3:07
MySQL Server: OptimizerVerified
(125 days)
S28.0.34AnyAnyContribute by tencent: Repeated subquery plans were printed in format=tree.
1122932023-09-07
14:04
2023-09-08
6:54
MySQL Server: DMLVerified
(738 days)
S38.0, 8.0.34, 5.7.43AnyAnyWrong result if non-breaking space is contained in varchar
1122802023-09-06
20:38
2023-09-07
4:27
MySQL Server: OptimizerVerified
(739 days)
S38.0.34AnyAnyIncorrect costing of group by loose index scans
1122692023-09-06
2:51
2023-09-06
4:52
MySQL Server: OptimizerVerified
(740 days)
S28.1.0, 8.0.34AnyAnyUnexpected Results by the hint JOIN_ORDER
1122642023-09-05
11:47
2023-09-05
12:15
MySQL Server: OptimizerVerified
(741 days)
S28.1.0AnyAnyUnexpected Result by block_nested_loop
1122592023-09-05
9:44
2023-09-05
10:21
MySQL Server: CompilingVerified
(741 days)
S38.0.33AnyAnyAssert when debug_sync_timeout is 0
1122432023-09-04
4:54
2023-09-21
7:13
MySQL Server: OptimizerVerified
(742 days)
S38.0.34AnyAnyUnexpected Result by subquery_to_derived
1122422023-09-04
4:40
2023-09-04
8:34
MySQL Server: OptimizerVerified
(742 days)
S28.1.0, 8.0.34AnyAnyUnexpected Results by use_invisible_indexes
1122382023-09-01
16:08
2023-09-11
11:28
MySQL Server: DMLVerified
(742 days)
S25.5, 5.6, 5.7.43, 8.0.34AnyAnyInconsistent results caused by FIELD()
1122122023-08-29
16:01
2023-08-30
7:42
MySQL Server: OptimizerVerified
(747 days)
S38.0.34AnyAnySubquery to derived result mismatch(HASH JOIN/BNL JOIN result mismatch)
1121982023-08-28
8:21
2024-03-05
6:06
MySQL Server: OptimizerVerified
(749 days)
S18.0, 8.0.34AnyAnyIncorrect multiple equality optimization causes performance degradation
1121942023-08-28
5:31
2023-09-06
9:03
MySQL Server: DMLVerified
(740 days)
S38.0.34Red HatAnyIncorrect result when using INNER JOIN with SELECT FROM VIEW together with OR co
1121922023-08-28
2:55
2023-08-30
11:05
MySQL Server: OptimizerVerified
(747 days)
S58.0.28AnyAnyIn MySQL 8.0, one queries need 1000 times more data than MySQL 5.7
1121912023-08-28
2:52
2023-08-29
9:45
MySQL Server: CompilingVerified
(748 days)
S38.0.31AnyAnyWhen we compile MySQL 8.0 with DEBUG, we have some warning of memory leak
1121752023-08-24
13:32
2025-07-24
7:07
MySQL Server: CompilingVerified
(53 days)
S38.0AnyAnyContribution: [performance optimization]
1121692023-08-23
15:41
2023-08-24
13:51
MySQL Server: OptimizerVerified
(753 days)
S35.7AnyAnyUsing LOWER in HAVING clause falsifies result of GROUP_CONCAT
1121492023-08-23
4:09
2023-08-23
8:15
MySQL Server: DMLVerified
(754 days)
S28.0.34, 5.7.43, 5.6, 5.5AnyAnyInconsistent results caused by SPACE() function and ''||'' operations
1121472023-08-23
2:58
2023-08-24
7:31
MySQL Server: JSONVerified
(754 days)
S38.0.34AnyAnyUse/Ignore Mutil-value index for MEMBER OF function has differnet result
1121242023-08-21
15:10
2023-08-22
13:00
MySQL Server: DMLVerified
(755 days)
S38.0AnyAnySometimes , ROW_COUNT() return wrong answer, which cause by index.
1121122023-08-18
10:20
2023-08-18
13:48
MySQL Server: OptimizerVerified
(759 days)
S38.0AnyAnyCannot find column on derived table with given names and ROLLUP
1121052023-08-18
2:51
2023-08-18
9:21
MySQL Server: Prepared statementsVerified
(759 days)
S38.1.0, 8.0.34Ubuntu (22.04)x86 (x86_64)Create table from prepared statement issues
1120552023-08-13
10:18
2023-08-14
4:35
MySQL Server: OptimizerVerified
(763 days)
S2any, 8.0AnyAnyContribution by Tentent: index merge intersect causes wrong query results
1120532023-08-12
19:55
2023-08-21
12:36
MySQL Server: JSONVerified
(761 days)
S38.0AnyAnyCOALESCE a null value with a JSON object returns hex string
1120372023-08-11
3:45
2023-08-25
6:44
MySQL Server: OptimizerVerified
(766 days)
S38.0.32, 8.0.34AnyAnyContribute by tencent: explain analyze show never executed for materialize
1120222023-08-10
1:56
2023-08-10
7:38
MySQL Server: CompilingVerified
(767 days)
S38.0.34CentOS (CentOS Linux 7)x86Compiling with -DWITH_DEBUG=1 and using C++17 resulted in a failure.
1120112023-08-09
12:06
2023-08-17
12:21
MySQL Server: Prepared statementsVerified
(767 days)
S38.0AnyAnyRESOURCE GROUP hint fails when used within a prepared statement
1120082023-08-09
10:41
2023-08-09
11:53
MySQL Server: CompilingVerified
(768 days)
S38.0.34, 8.1.0AnyAnyUnused macro DBUG_EVALUATE
1119912023-08-08
3:25
2023-08-10
5:53
MySQL Server: OptimizerVerified
(767 days)
S28.0.32,8.1.0AnyAnyindex merge sometimes return incorrect result
1119522023-08-02
19:50
2024-10-30
6:12
MySQL Server: OptimizerVerified
(774 days)
S28.0.34, 5.7.43, 8.1.0AnyAnyRow constructor inequality comparison on Primary Key results in full table scan.
1119212023-07-31
7:57
2023-08-11
12:14
MySQL Server: Prepared statementsVerified
(776 days)
S38.0AnyAnyReusing prepared statement for different data types, different outcomes are obse
1119182023-07-30
6:12
2023-07-31
6:33
MySQL Server: OptimizerVerified
(777 days)
S38.1.0, 8.0.34, 5.7.43Ubuntu (22.04)x86 (x86_64)Auto increment column query wrong result
1119172023-07-30
5:35
2023-07-31
6:31
MySQL Server: OptimizerVerified
(777 days)
S38.1.0, 8.0.34Ubuntu (22.04)x86 (x86_64)derived condition pushdown query with wrong result
1118922023-07-26
6:52
2023-11-13
10:14
MySQL Server: ParserVerified
(781 days)
S38.1AnyAnyTwo single quotes escaping inconsistency
1118522023-07-23
12:46
2023-07-27
1:15
MySQL Server: OptimizerVerified
(784 days)
S38.0.30, 8.0.34AnyAnyAn incorrect number of records is returned
1118512023-07-22
22:59
2023-07-26
6:55
MySQL Server: GISVerified
(782 days)
S28.0.32, 8.0.34, 5.7.43Any (Linux & Mac)Any (x86 & ARM)Spatial index not used for join when field is used in MBRIntersects call
1118502023-07-21
23:40
2023-07-24
8:19
MySQL Server: CompilingVerified
(786 days)
S38.0AnyAnyContribution: Architecture-agnostic fix for crashes caused by cache coheren ...
1118382023-07-21
10:51
2023-07-21
11:31
MySQL Server: JSONVerified
(787 days)
S38.10AnyAnyEvaluate JSON column default on table/column creation
1117392023-07-13
4:50
2023-07-13
9:32
MySQL Server: DMLVerified
(795 days)
S38.0.33AnyAnyThe query results are inconsistent.
1117282023-07-12
8:08
2023-07-12
8:42
MySQL Server: OptimizerVerified
(796 days)
S28.0.28, 8.0.33AnyAnyIncorrect result
1117062023-07-10
8:24
2025-03-17
9:33
MySQL Server: OptimizerVerified
(798 days)
S38.0.28, 8.0.33AnyAnyIncorrect result
1117002023-07-09
7:31
2023-07-12
5:55
MySQL Server: OptimizerVerified
(796 days)
S38.0.32, 8.0.33AnyAnyLIMIT values are not adequately handled in EXPLAIN.
1116992023-07-09
3:46
2023-07-10
5:51
MySQL Server: OptimizerVerified
(798 days)
S38.0.28, 8.0.33AnyAnyIncorrect results
1116812023-07-06
13:47
2023-10-23
10:29
MySQL Server: OptimizerVerified
(796 days)
S38.0LinuxAnyEXISTS query results in duplicate rows
1116752023-07-06
8:36
2023-07-07
12:17
MySQL Server: Data TypesVerified
(802 days)
S38.0AnyAnywrong result when compare timestamp with undependent subselect that return time
1116692023-07-06
0:47
2023-07-12
13:04
MySQL Server: OptimizerVerified
(796 days)
S58.0.33AnyAnySimple Query Times Out
1116592023-07-04
15:46
2023-07-05
13:28
MySQL Server: OptimizerVerified
(803 days)
S28.0AnyAnyEmpty result of SELECT only when bigger LIMIT
1116072023-06-28
14:26
2023-07-12
9:03
MySQL Server: CompilingVerified
(798 days)
S38.0AnyAnyContribution: Fix linkage of \'gen_keyword_list\' executable
1115602023-06-26
9:33
2023-06-26
13:53
MySQL Server: Prepared statementsVerified
(812 days)
S38.0AnyAnyA Prepare statement with cursor on will hang when executed after cursor closed
1115592023-06-26
9:10
2025-01-22
7:36
MySQL Server: OptimizerVerified
(812 days)
S38.0.33Ubuntu (22.04)x86 (x86_64)View with CTE syntax error
1115112023-06-21
8:38
2024-04-12
15:00
MySQL Server: OptimizerVerified
(817 days)
S38.0.33Ubuntu (22.04)x86 (x86_64)CTE missing scope in set queries
1115082023-06-21
7:06
2023-06-21
8:24
MySQL Server: OptimizerVerified
(817 days)
S38.0.33AnyAnyThe query results are inconsistent when different optimizer options are used.
1114932023-06-20
8:25
2023-06-20
13:01
MySQL Server: OptimizerVerified
(818 days)
S38.0AnyAnysql return wrong results
1114852023-06-19
11:16
2023-06-19
11:40
MySQL Server: OptimizerVerified
(819 days)
S3mysql-8.0.33Linuxx86When subquery_to_derived is on, IN-subq to derived table transformed wrongly
1114842023-06-19
8:49
2023-06-19
9:10
MySQL Server: OptimizerVerified
(819 days)
S3mysql-8.0.33Linuxx86wrong result when rewriting scalar subquery in json function parameters
1114792023-06-19
4:24
2023-06-19
11:42
MySQL Server: OptimizerVerified
(819 days)
S35.7.42AnyAnyOptimizer estimated rows is always equal to 1 when using spatial index.
1114712023-06-17
14:28
2023-06-18
13:26
MySQL Server: OptimizerVerified
(820 days)
S28.0.33Ubuntux86Unexpected Error: Memory capacity exceeded
1114662023-06-16
19:18
2025-05-09
12:30
MySQL Server: OptimizerVerified
(821 days)
S35.7AnyAnyContribution: Disable index hints on spatial indices
1114542023-06-16
2:24
2023-06-19
8:37
MySQL Server: OptimizerVerified
(819 days)
S38.0.33AnyAnyselect query with json and time column has different results
1114532023-06-16
0:54
2023-06-19
10:09
MySQL Server: OptimizerVerified
(819 days)
S28.0.33AnyAnysql query with "where time_col not between val1 and null' has diffrent results
1114322023-06-15
8:56
2023-06-16
13:42
MySQL Server: CompilingVerified
(822 days)
S3mysql-8.0.33 Ubuntu (22.04.2)x86c++ Undefined Behavior with clang-16
1114312023-06-15
8:47
2023-06-26
14:48
MySQL Server: OptimizerVerified
(823 days)
S38.0.33Ubuntu (22.04)Other (x86_64)condition_fanout_filter optimizer wrong result?
1114292023-06-15
6:44
2023-06-21
14:02
MySQL Server: OptimizerVerified
(823 days)
S38.0.22, 8.0.33AnyAnyIncorrect result when timestamp col apply <=> to the result of subquery
1114182023-06-14
11:43
2023-06-15
14:04
MySQL Server: OptimizerVerified
(823 days)
S38.0AnyAnySubquery with ROLLUP gives wrong result
1114152023-06-14
9:39
2023-06-19
14:12
MySQL Server: OptimizerVerified
(819 days)
S38.0AnyAnyCorrelated group query wrong result
1114092023-06-14
3:40
2023-06-14
13:31
MySQL Server: OptimizerVerified
(824 days)
S38.0AnyAnyIncorrect result when select time col use "WHERE IN (NULL,'xx:xx:xx.xxxxxx')"
1113972023-06-13
13:32
2023-06-14
8:30
MySQL Server: OptimizerVerified
(825 days)
S38.0AnyAny表达式进行<=>比较并将结果进行与操作,执行结果错误
1113672023-06-12
15:36
2023-08-04
15:11
MySQL Server: OptimizerVerified
(773 days)
S58.0AnyAnyOFFSET 99 LIMIT 1 on a compound PK takes ages to execute.
1113582023-06-12
8:41
2023-06-14
11:35
MySQL Server: DMLVerified
(825 days)
S38.0AnyAnydelete handl error
1113182023-06-07
14:36
2023-06-07
14:55
MySQL Server: OptimizerVerified
(831 days)
S38.0AnyAnyblock_nested_loop optimizer wrong result?
1113102023-06-07
6:51
2023-06-08
8:30
MySQL Server: Prepared statementsVerified
(830 days)
S38.0.33Ubuntu (22.04)x86 (x86_64)Prepared statement with CTE memory leak
1113042023-06-06
21:15
2023-06-08
4:00
MySQL Server: OptimizerVerified
(830 days)
S28.0.33, 5.7.42AnyAnyThe Query Rewrite Plugin mixes-up LIMIT and OFFSET.
1112722023-06-05
8:47
2023-06-05
8:51
MySQL Server: OptimizerVerified
(833 days)
S28.0.32, 8.0.33AnyAnyInconsistent behaviors on string comparison with/without index
1112682023-06-04
17:21
2023-06-06
11:00
MySQL Server: CharsetsVerified
(833 days)
S38.0.25, 8.0.33AnyAnyDifferent character_set_connection returns inconsistent results
1112412023-06-01
11:39
2023-06-01
13:57
MySQL Server: DMLVerified
(837 days)
S3Last commit version in github https://giAnyAnyWrong result of `IN` clause
1112152023-05-31
9:58
2023-06-02
11:53
MySQL Server: DMLVerified
(836 days)
S38.0AnyAnyQuery in transaction may return rows with same unique key column value
1112122023-05-31
8:30
2023-06-16
12:52
MySQL Server: CompilingVerified
(822 days)
S28.0.30, 8.0.33Debian (10)Any (x86 and arm)compile failed with gcc-10 when lto is enable
1111952023-05-30
7:34
2024-04-10
6:59
MySQL Server: OptimizerVerified
(839 days)
S38.0AnyAnyThere is a logical error in source code
1111832023-05-29
9:46
2023-05-29
13:21
MySQL Server: DMLVerified
(840 days)
S35.7AnyAnyWhen use ON DUPLICATE UPDATE syntax, TIMESTAMP in primary key, get wrong answer
1111592023-05-26
6:02
2023-11-06
11:17
MySQL Server: CompilingVerified
(681 days)
S38.0CentOSAnyIncomplete documentation on MySQL rpm rebuilds makes rebuilding packages hard
1110972023-05-22
6:40
2024-04-10
9:51
MySQL Server: OptimizerVerified
(847 days)
S18031, 5.7.42, 8.0.33, 8.0.36Linuxx86Query statement results with subqueries are unstable
1110942023-05-21
2:25
2024-04-10
9:55
MySQL Server: OptimizerVerified
(847 days)
S38.0.33, 8.0.36Ubuntu (8.0.33-0ubuntu0.20.04.2)x86Results ordered incorrectly
1110722023-05-18
10:12
2024-04-10
10:04
MySQL Server: JSONVerified
(850 days)
S38.0.33, 5.7.42, 8.0.36AnyAnyThe subquery involves JSON, and the execution result is incorrect.
1110672023-05-18
8:05
2023-05-19
12:55
MySQL Server: OptimizerVerified
(851 days)
S28.0.25, 8.0.33AnyAnyQuery result error
1110372023-05-15
21:34
2023-05-16
12:57
MySQL Server: OptimizerVerified
(853 days)
S58.0AnyAnyMySQL not selecting or not using the index optimally for query
1110252023-05-13
18:22
2023-05-15
10:24
MySQL Server: OptimizerVerified
(854 days)
S38.0.33AnyAnyDifferent cost with index hint for same plan
1110112023-05-12
3:16
2023-05-15
10:27
MySQL Server: CompilingVerified
(854 days)
S38.0.33AnyAny`mysql_config --libs` returns broken zlib reference
1110072023-05-11
20:30
2023-05-12
13:09
MySQL Server: OptimizerVerified
(857 days)
S38.0AnyAnyIncorrect rows estimate
1109982023-05-11
15:33
2023-12-01
6:49
MySQL Server: OptimizerVerified
(852 days)
S58.0.20+, 8.0.33LinuxAnyPerformance regression with SELECT query when sorting on limited fields
1109882023-05-11
8:06
2023-07-10
13:11
MySQL Server: OptimizerVerified
(798 days)
S38.0.33Ubuntu (22.04)x86 (x86_64)VIEW call error
1109712023-05-10
3:21
2023-05-10
8:00
MySQL Server: OptimizerVerified
(859 days)
S58.0.33AnyAnyOptimizer: reverse index scan doesn't affect the cost
1109692023-05-09
23:33
2023-05-10
8:01
MySQL Server: OptimizerVerified
(859 days)
S38.0.33AnyAnyFunctional indexes aren't covering
1109622023-05-09
13:07
2023-05-10
11:15
MySQL Server: OptimizerVerified
(859 days)
S25.7.42, 8.0.33AnyAnyJOIN a table with trigger report unexpected WARNINGS
1109312023-05-05
11:22
2023-05-05
12:16
MySQL Server: OptimizerVerified
(864 days)
S38.0.33MacOSAnyOptimizer Trace contradicts to EXPLAIN contradicts to SHOW STATUS
1109152023-05-04
16:28
2023-05-18
13:10
MySQL Server: OptimizerVerified
(864 days)
S38.0.33AnyAnyHaving clause missing scope
1108482023-04-27
15:04
2023-05-03
9:59
MySQL Server: OptimizerVerified
(866 days)
S58.0.28, 8.0.33AnyAnymissing considering on order by and limit clause in cost calculation
1108252023-04-26
23:58
2023-04-27
8:29
MySQL Server: CharsetsVerified
(872 days)
S38.0.32AnyAnyExplicit COLLATE clause output in SHOW CREATE TABLE incorrectly
1108192023-04-26
15:11
2023-05-08
22:48
MySQL Server: OptimizerVerified
(872 days)
S28.0.16+, 8.0.33AnyAnyEXISTS with dependent subquery can return incorrect results
1107792023-04-24
11:32
2023-05-12
5:49
MySQL Server: OptimizerVerified
(857 days)
S58.0.33, 5.7.42AnyAnyIN clause cause pick bad performan index
1106562023-04-11
16:02
2024-01-26
9:27
MySQL Server: OptimizerVerified
(598 days)
S38.0.32Ubuntu (22.04)x86 (x86_64)Join query with wrong result
1106142023-04-05
8:32
2023-04-05
13:48
MySQL Server: OptimizerVerified
(894 days)
S38.0AnyAnyLeft join query with wrong result
1105972023-04-04
4:20
2023-04-12
14:05
MySQL Server: OptimizerVerified
(895 days)
S28.0.32MacOS (12.4)AnyDifferent results from equivalent queries
1105872023-04-03
7:51
2023-04-03
9:37
MySQL Server: OptimizerVerified
(896 days)
S18.0.27, 8.0.32, 5.7.41AnyAnyBit with index range query may produce different results
1105792023-03-31
15:10
2023-04-05
12:34
MySQL Server: OptimizerVerified
(899 days)
S38.0.32, 5.7.41Ubuntu (22.04)x86 (x86_64)Right join query with BETWEEN wrong result
1105632023-03-30
8:21
2023-03-30
8:48
MySQL Server: OptimizerVerified
(900 days)
S38.0.32Ubuntu (22.04)x86 (x86_64)NULL safe equality operator query with wrong result
1105622023-03-30
8:05
2023-04-18
21:01
MySQL Server: ParserVerified
(885 days)
S28.0.32Windows (11)x86 (64bit)values statement
1105562023-03-30
2:46
2023-03-30
6:19
MySQL Server: JSONVerified
(900 days)
S28.0.28, 8.0.32LinuxAnyWhen we use json to build an index, we will get wrong results
1104882023-03-24
7:52
2023-03-24
9:17
MySQL Server: ParserVerified
(906 days)
S3all, 8.0CentOS (7.x)x86 (64bit)pound sign can not included in qb_name hint
1104872023-03-24
6:09
2023-03-24
9:20
MySQL Server: JSONVerified
(906 days)
S35.7,8.0.32AnyAnyjson array field ignored in multi sort.
1104742023-03-22
23:09
2023-03-27
7:02
MySQL Server: OptimizerVerified
(903 days)
S58.0, 8.0.32AnyAnyFunctional Index is not work like generated column and index
1104592023-03-22
8:09
2023-06-07
8:51
MySQL Server: OptimizerVerified
(831 days)
S38.0.32Ubuntu (22.04)x86 (x86_64)Derive_merge optimizer missing error
1104452023-03-21
3:11
2023-03-21
6:32
MySQL Server: OptimizerVerified
(909 days)
S58.0LinuxARM (aarch64)Optimize my_convert for Arm64
1104062023-03-17
4:58
2023-03-20
14:08
MySQL Server: OptimizerVerified
(910 days)
S38.0AnyAnyStoring rows with null in join key in hash table for outer join is useless
1103562023-03-14
8:39
2023-03-14
9:37
MySQL Server: OptimizerVerified
(916 days)
S35.7, 8.0AnyAnythe presence of case when cause inconsistant columns mapping in order by
1103552023-03-14
7:40
2023-03-14
9:21
MySQL Server: CompilingVerified
(916 days)
S3Ver 8.0AnyAnycompiling source code error when cmake with -DWITH_JEMALLOC=true
1103542023-03-14
7:37
2023-03-14
9:51
MySQL Server: OptimizerVerified
(916 days)
S28.0.32, 5.7.41CentOSAnySELECT Query choose different index return different results
1103322023-03-10
7:16
2023-03-10
8:38
MySQL Server: OptimizerVerified
(920 days)
S28.0.32, 5.7.41AnyAnyDifferent result when using a user variable
1103222023-03-09
11:41
2023-03-09
12:31
MySQL Server: OptimizerVerified
(921 days)
S38.0.32Ubuntu (22.04)x86 (x86_64)Binary column primary key query with wrong result
1103102023-03-09
8:41
2023-04-29
15:24
MySQL Server: OptimizerVerified
(921 days)
S38.0.32Ubuntu (22.04)x86 (x86_64)BETWEEN query with wrong result
1103062023-03-08
22:08
2023-03-09
6:47
MySQL Server: OptimizerVerified
(921 days)
S38.0.32AnyAnyIncorrect costing in test_if_cheaper_ordering
1103012023-03-08
11:13
2023-03-09
12:30
MySQL Server: OptimizerVerified
(921 days)
S38.0.32Ubuntu (22.04)x86 (x86_64)Change column wrong result
1102912023-03-07
10:57
2023-03-07
13:17
MySQL Server: CharsetsVerified
(923 days)
S38.0, 5.7AnyAnySHOW CREATE TABLE breaks DEFAULT for 4 byte Unicode characters
1102502023-03-01
11:59
2023-03-24
11:16
MySQL Server: OptimizerVerified
(923 days)
S38.0.32Ubuntu (22.04)x86 (x86_64)Right join query with wrong result
1102442023-03-01
3:46
2023-03-01
6:30
MySQL Server: OptimizerVerified
(929 days)
S28.0.32AnyAnyNesting queries in a projection results in different output
1102262023-02-27
18:39
2023-02-28
6:46
MySQL Server: CompilingVerified
(930 days)
S38.0.31AnyAnyBuild fails when CMAKE_CXX_FLAGS_RELEASE is set because -DNDEBUG isn't set
1102172023-02-27
6:16
2023-02-28
17:01
MySQL Server: CompilingVerified
(930 days)
S38.0.32DebianAnyfailed to compile in mysql_release mode
1102092023-02-24
16:01
2023-02-28
15:17
MySQL Server: DMLVerified
(930 days)
S38.0AnyAnyPRIMARY KEY should not change the query result.
1101742023-02-23
3:13
2023-06-07
15:17
MySQL Server: CompilingVerified
(935 days)
S35.7,8.0AnyAnyRe-run cmake may occur even though nothing is modified.
1101632023-02-22
7:22
2023-02-22
8:03
MySQL Server: CompilingVerified
(936 days)
S58.0LinuxAnyIPTOS_THROUGHPUT enabling code is bypassed on Linux
1101562023-02-21
14:24
2023-02-22
15:18
MySQL Server: OptimizerVerified
(937 days)
S38.0AnyAnyIncorrect query results caused by subqueries and JOIN
1101252023-02-19
8:48
2023-02-20
5:04
MySQL Server: OptimizerVerified
(938 days)
S18.0.32, 5.7UbuntuAnyUnexpected query result fetched from an indexed column
1101112023-02-17
12:53
2023-02-20
12:35
MySQL Server: OptimizerVerified
(938 days)
S58.0.31AnyAnyOptimizer chooses worst plan when index condition pushdown opportunity
1100172023-02-10
6:27
2023-02-16
4:47
MySQL Server: OptimizerVerified
(948 days)
S35.7.41UbuntuAnySELECT returns incorrect value when ORDER BY a CASE WHEN value in left-joined su
1100152023-02-10
3:06
2023-11-20
11:24
MySQL Server: OptimizerVerified
(945 days)
S58.0.32Windows (11)x86Multi-valued index on JSON array is not used when used in a join
1100032023-02-09
10:37
2023-02-13
12:29
MySQL Server: DMLVerified
(949 days)
S38.0.32, 5.7, 5.6AnyAnyDELETE query does ot work for BIT columns
1099752023-02-08
1:19
2023-02-08
8:32
MySQL Server: DMLVerified
(950 days)
S35.7, 8.0AnyAnyunique key cause wrong result
1099452023-02-06
15:51
2023-02-09
20:26
MySQL Server: CompilingVerified
(949 days)
S38.0AnyAnyContribution: protocol_classic: Document column default in Protocol::Column ...
1098972023-02-02
10:08
2023-02-02
11:32
MySQL Server: OptimizerVerified
(956 days)
S38.0.31AnyAnyField_double::val_str causes string truncation
1098932023-02-02
9:15
2023-02-02
10:11
MySQL Server: JSONVerified
(956 days)
S38.0.31, 8.0.32AnyAnyjson_contains always return 1 if candidate array is empty array
1098912023-02-02
9:10
2023-02-03
7:55
MySQL Server: DMLVerified
(955 days)
S38.0.30,8.0.31, 8.0.32, 5.7AnyAnyContribution by Tencent: insert on duplicate key update would be abnormal
1098422023-01-30
13:51
2023-01-31
6:54
MySQL Server: DMLVerified
(958 days)
S38.0.31, 8.0.32, 5.7.41MacOSx86Problems when mod , division function and extremum function are used together
1098382023-01-30
12:27
2023-01-31
6:53
MySQL Server: DMLVerified
(958 days)
S38.0.19, 5.7.41, 8.0.31AnyAnyDecimal division lose result precision in some specific scenarios
1098372023-01-30
12:24
2023-01-30
13:24
MySQL Server: DMLVerified
(959 days)
S38.0.31, 8.0.32, 5.7.41MacOSx86The representation of 0 in division function in computing string
1098242023-01-27
15:43
2023-01-28
8:04
MySQL Server: OptimizerVerified
(961 days)
S38.0.32Ubuntu (22.04)x86 (x86_64)Bit query with wrong result
1098202023-01-27
8:54
2023-01-28
12:55
MySQL Server: OptimizerVerified
(962 days)
S38.0.29, 8.0.32Any (rhel-7.4)Any (x86-64)optimizer hints in definition of views seem to be ignored
1097962023-01-26
21:17
2024-05-21
12:29
MySQL Server: DMLVerified
(502 days)
S28.0.32, 5.7UbuntuAnySTR_TO_DATE() invalid input doesn't returns NULL but invalid DATE
1097362023-01-23
10:41
2023-01-25
7:41
MySQL Server: OptimizerVerified
(964 days)
S28.0.32Ubuntu (22.04)x86 (x86_64)ANY query with wrong result
1097282023-01-21
19:27
2023-09-05
8:45
MySQL Server: OptimizerVerified
(937 days)
S18.0.30AnyAnySELECT statement: Result is not proper with GROUP BY with LIMIT OFFSET
1097262023-01-20
21:35
2023-05-29
12:01
MySQL Server: OptimizerVerified
(966 days)
S28.0.31Ubuntux86Incorrect results with aggregated functions on correlated lateral joins
1096082023-01-12
15:11
2023-01-24
11:39
MySQL Server: OptimizerVerified
(965 days)
S38.0.31Ubuntu (22.04)x86 (x86_64)Exists query with wrong result
1096012023-01-12
9:00
2023-01-12
9:38
MySQL Server: OptimizerVerified
(977 days)
S38.0AnyAnyApply partition pruning if all insert rows have non-null values on autoinc field
1095852023-01-11
12:06
2023-01-11
12:28
MySQL Server: OptimizerVerified
(978 days)
S28.0.31Any (Docker image)x86Sub query not returning the right result
1095602023-01-09
20:12
2023-01-10
6:51
MySQL Server: CompilingVerified
(979 days)
S38.0.30AnyAny"Reduce size of RelWithDebInfo" makes coredump useless for official binaries
1095072023-01-01
11:48
2025-07-31
13:10
MySQL Server: CharsetsVerified
(987 days)
S38.0.31, 8.0.41MacOSAnyIllegal mix of collations when selecting from a view with a calculated column
1094492022-12-21
9:48
2023-01-03
8:04
MySQL Server: OptimizerVerified
(999 days)
S38.0.26, 8.0.31AnyAnyfunctional index could produce wrong result
1094292022-12-19
15:59
2022-12-20
14:23
MySQL Server: CompilingVerified
(1001 days)
S38.0LinuxARMUpdate the directories malloc-lib supports because ARM
1094072022-12-16
12:31
2022-12-16
12:38
MySQL Server: OptimizerVerified
(1004 days)
S25.7.5, 8.0.31AnyAnyExtra line caused by NOT comparsion + ALL
1094062022-12-16
12:31
2022-12-16
12:38
MySQL Server: OptimizerVerified
(1004 days)
S35.7.11, 8.0.31AnyAnyValue change after relaxing WHERE condition
1093962022-12-15
15:20
2022-12-16
5:48
MySQL Server: CompilingVerified
(1004 days)
S38.0AnyAnyContribution: cmake: fail fatally when sql/sql_yacc.h is missing and bison ...
1093672022-12-13
16:11
2022-12-14
5:58
MySQL Server: OptimizerVerified
(1006 days)
S35.7.22, 8.0.31AnyAnyvalue changed caused by DISTINCT and JOIN
1093632022-12-13
13:08
2022-12-16
14:50
MySQL Server: OptimizerVerified
(1004 days)
S38.0.4, 8.0.31AnyAny0 changed to -0 caused by DISTINCT and UNION ALL
1093622022-12-13
12:55
2022-12-13
13:20
MySQL Server: OptimizerVerified
(1007 days)
S28.0.13, 8.0.31AnyAnyExtra line caused by DISTINCT and key
1093562022-12-13
7:01
2022-12-13
7:56
MySQL Server: OptimizerVerified
(1007 days)
S28.0.16, 8.0.31AnyAnyExtra line caused by DISTINCT and IS TRUE
1093542022-12-13
5:43
2022-12-13
7:15
MySQL Server: OptimizerVerified
(1007 days)
S38.0.21, 8.0.30, 8.0.31AnyAnyNumeric format change caused by DISTINCT, UNION and NULL
1093532022-12-13
5:24
2022-12-13
7:12
MySQL Server: OptimizerVerified
(1007 days)
S28.0.22, 8.0.31AnyAnyExtra line caused by DISTINCT and a certain number of '0'
1093522022-12-13
5:00
2022-12-13
6:43
MySQL Server: OptimizerVerified
(1007 days)
S38.0.23, 8.0.31AnyAnyNumeric format change caused by DISTINCT and UCASE
1093512022-12-13
4:46
2022-12-13
6:35
MySQL Server: OptimizerVerified
(1007 days)
S28.0.28, 8.0.31AnyAnyValue change caused by DISTINCT and date functions
1093332022-12-11
13:13
2022-12-13
12:46
MySQL Server: OptimizerVerified
(1007 days)
S38.0.31AnyAnyquery with/without index get different result
1093112022-12-08
3:40
2022-12-09
3:36
MySQL Server: OptimizerVerified
(1011 days)
S18.0.22 8.0.30, 8.0.31AnyAnyWrong result
1092512022-11-30
16:06
2023-01-18
23:58
MySQL Server: CompilingVerified
(971 days)
S35.7.39, 5.7.40Ubuntux86Cannot compile 5.7.39 on Ubuntu 22.04 because ssl is not found
1092122022-11-27
8:34
2022-11-27
9:20
MySQL Server: OptimizerVerified
(1023 days)
S18.0.30, 8.0.31AnyAnyIncorrect Hash Semijoin Execution
1091792022-11-23
9:47
2022-11-25
6:49
MySQL Server: DMLVerified
(1027 days)
S28.0.31, 5.7.40LinuxAnyunique key with null value acts abnormally in select statements
1091732022-11-23
7:51
2022-11-24
12:16
MySQL Server: OptimizerVerified
(1026 days)
S5.31, 8.0.31AnyAnyContribution: Offset pushdown to InnoDB and removal of redundant conditions
1091552022-11-22
5:43
2023-12-13
11:44
MySQL Server: OptimizerVerified
(1028 days)
S58.0.18, 8.0.31, 8.0.35AnyAnyInvalid scan on left join tables of which columns not in distinct output fields
1091492022-11-20
5:01
2023-12-05
4:04
MySQL Server: DMLVerified
(650 days)
S38.0.31, 5.7Ubuntux86The representation of 0 in MOD function in computing string
1091072022-11-16
8:19
2022-11-22
14:06
MySQL Server: DMLVerified
(1034 days)
S58.0.31AnyAnyNon optimal query plan chosen for DELETE
1090762022-11-14
11:35
2023-04-06
13:15
MySQL Server: CompilingVerified
(1035 days)
S35.7.40Linuxx86COMPILATION FAILURE IN 5.7 SERVER WITH GCC 7.5.0
1090142022-11-07
2:56
2022-11-07
8:18
MySQL Server: OptimizerVerified
(1043 days)
S35.7.40AnyAnyis null acts abnormally in select statements
1090032022-11-04
8:01
2024-04-29
7:46
MySQL Server: OptimizerVerified
(1046 days)
S28.0.21, 8.0.31Windows (10 Pro)x86 (64-bit)Index intersection returns less results than expected
1090022022-11-04
6:23
2022-11-04
14:13
MySQL Server: DMLVerified
(1046 days)
S38.0AnyAnyfilename_to_tablename() handles temp table's name "p0#tmp" incorrectly
1089962022-11-03
17:07
2022-11-07
16:51
MySQL Server: CompilingVerified
(1043 days)
S38.0.31Windows (10.0.18363)x86MySQL Client compilation errors on Windows when OpenSSL path contains spaces
1089812022-11-03
10:35
2022-11-03
14:52
MySQL Server: OptimizerVerified
(1047 days)
S38.0Any (rhel-7.4)Any (x86-64)function NULLIF(ASCII()) acts abnormally in select statements
1089462022-11-01
3:35
2022-12-13
4:12
MySQL Server: OptimizerVerified
(1007 days)
S38.0.30AnyAny0 changed to 0.0 caused by DISTINCT and UNION ALL
1089382022-10-31
13:59
2022-12-13
4:08
MySQL Server: OptimizerVerified
(1007 days)
S38.0.30AnyAnyDate value change caused by ON
1089372022-10-31
13:30
2022-12-13
4:03
MySQL Server: OptimizerVerified
(1007 days)
S38.0.30AnyAnyDate value change caused by HAVING
1089362022-10-31
12:58
2022-12-13
3:56
MySQL Server: OptimizerVerified
(1007 days)
S28.0.30AnyAnyValue change caused by DISTINCT
1089342022-10-31
9:32
2022-10-31
12:00
MySQL Server: OptimizerVerified
(1050 days)
S2mysql-8.0.18/5.7.25AnyAnyMySQL-8.0 select query about rand() in Subquery result is wrong
1088632022-10-24
16:40
2024-03-15
8:49
MySQL Server: OptimizerVerifiedS58.0.31AnyAnydifferent index picked when row is not found, marginally slower
1088522022-10-22
2:45
2022-10-22
5:43
MySQL Server: OptimizerVerified
(1059 days)
S58.0.31Ubuntu (20.04)x86Suspicious Estimated Rows by DISTINCTROW
1088512022-10-22
1:55
2022-10-22
5:42
MySQL Server: OptimizerVerified
(1059 days)
S58.0.31Ubuntu (20.04)x86Suspicious Estimated Rows by JOIN
1088332022-10-20
10:11
2022-10-20
12:35
MySQL Server: OptimizerVerified
(1061 days)
S58.0.31Ubuntu (20.04)x86Suspicious Estimated Rows
1088282022-10-19
13:39
2024-10-31
7:17
MySQL Server: DMLVerified
(319 days)
S28.0.28, 8.0.31AnyAnyerror DB_UNDO_RECORD_TOO_BIG when update json column
1087902022-10-15
16:46
2022-10-17
6:55
MySQL Server: DMLVerified
(1064 days)
S28.0.30AnyAnyInvisible column's default values is invalid if not specify other columns
1087882022-10-15
7:34
2022-10-17
7:00
MySQL Server: OptimizerVerified
(1064 days)
S35.7.40LinuxAnyThe temporary alias is incorrect when the SQL statement is executed.
1087872022-10-14
18:51
2022-10-17
6:51
MySQL Server: DMLVerified
(1064 days)
S38.0AnyAnyUNIX_TIMESTAMP(NOW()) is lossy
1087652022-10-13
13:52
2022-12-19
12:48
MySQL Server: Data TypesVerified
(1064 days)
S28.0.31UbuntuAnycomparison of INT column with DECIMAL value changes if index is used or not
1086592022-09-30
7:18
2022-09-30
9:54
MySQL Server: OptimizerVerified
(1081 days)
S38.0.30AnyAnymulti-valued index get wrong result
1086302022-09-28
10:46
2022-09-28
11:33
MySQL Server: JSONVerified
(1083 days)
S35.7Linux (centos 7.5)x86json query bug
1085482022-09-20
6:37
2022-09-20
7:35
MySQL Server: OptimizerVerified
(1091 days)
S25.7, 5.7.39AnyAnyGROUP_CONCAT NOT SET USED_TABLES WHEN DERIVED_MERGE.
1085282022-09-18
10:28
2022-09-20
5:25
MySQL Server: OptimizerVerified
(1091 days)
S28.0.30Ubuntu (20.04)x86Inconsistent read and write, which use the same predicate (WHRE clause)
1085202022-09-16
7:54
2022-09-16
8:05
MySQL Server: OptimizerVerified
(1095 days)
S28.0, 8.0.30, 5.7.39LinuxAnyReturn different result due to different optimizer switch
1085182022-09-16
1:56
2022-09-16
6:06
MySQL Server: CompilingVerified
(1095 days)
S38.0.21AnyAnyReturn value of flush_io_cache() not get checked
1085162022-09-16
1:50
2022-09-19
13:24
MySQL Server: OptimizerVerified
(1095 days)
S28.0.21AnyAnyReturn value of my_b_flush_io_cache(IO_CACHE*, int) not get checked
1085132022-09-16
0:58
2022-09-16
5:50
MySQL Server: CompilingVerified
(1095 days)
S28.0.21AnyAnyReturn value of get_instance() not get checked
1084662022-09-13
6:03
2022-09-24
12:29
MySQL Server: Data TypesVerified
(1098 days)
S35.7.38, 5.7.39AnyAny"create table ... select" generates columns of type BIGINT with illegal width
1084552022-09-11
3:37
2022-09-15
2:17
MySQL Server: DMLVerified
(1100 days)
S28.0.30AnyAnyProblem with NULL constraints on generated columns if trigger exists
1084322022-09-08
15:06
2022-09-08
17:56
MySQL Server: Prepared statementsVerified
(1103 days)
S35.7.38/5.7.39AnyAnyUsing the prepare statement causes an "unknown column in 'order clause'" error
1084282022-09-08
13:52
2022-09-12
9:22
MySQL Server: DMLVerified
(1099 days)
S35.7, 8.0AnyAnyformat_bytes length bug
1083892022-09-05
16:16
2022-09-06
13:01
MySQL Server: CompilingVerified
(1105 days)
S28.0.30SUSE (OpenSUSE 15.4)ARMCannot compile with Performance schema disabled
1083652022-09-01
19:15
2023-10-02
19:05
MySQL Server: JSONVerified
(1109 days)
S38.0.30AnyAnyJSON_TABLE fails to parse when used in LATERAL join
1083152022-08-29
8:27
2023-06-07
15:17
MySQL Server: OptimizerVerified
(1113 days)
S28.0, 8.0.30LinuxAnyWrong result with union and small memory tmp table
1082932022-08-26
9:30
2022-09-05
7:43
MySQL Server: Prepared statementsVerified
(1106 days)
S28.0.29AnyAnyPrepared statement does not use generated column index
1082392022-08-23
8:46
2022-09-05
8:03
MySQL Server: OptimizerVerified
(1106 days)
S58.0AnyAnyOptimizer don't choose ICP when using filesort.
1082332022-08-23
6:43
2022-08-23
7:53
MySQL Server: OptimizerVerified
(1119 days)
S35.7.39, 8.0.30AnyAnyAlias displayed incorrectly with "Use temporary"
1082312022-08-23
5:15
2022-08-23
7:53
MySQL Server: JSONVerified
(1119 days)
S35.7.37, 5.7.39, 8.0.30AnyAnyJSON_ARRAY_APPEND adds backslashes when a JSON_OBJECT passed as variable
1082072022-08-21
13:35
2022-08-23
13:36
MySQL Server: Data TypesVerified
(1120 days)
S38.0Any (Centos, window)Anyinformation schema view return wrong data type
1081922022-08-18
13:16
2022-08-19
9:06
MySQL Server: OptimizerVerified
(1124 days)
S28.0.23, 8.0.30AnyAnyDifferent results return when executing the same query with different plans
1081502022-08-16
13:19
2023-01-27
16:19
MySQL Server: OptimizerVerified
(962 days)
S3 8.0.30Ubuntu (22.04.1)x86 (x86_x64)ALL query with UNION and ROLLUP wrong result
1081432022-08-16
5:02
2022-08-16
13:36
MySQL Server: DMLVerified
(1126 days)
S25.7AnyAnyTIMESTAMPDIFF function dones not work as expect on where caluse
1081272022-08-12
5:57
2025-06-19
6:23
MySQL Server: OptimizerVerified
(1126 days)
S58.0.29AnyAnyMySQL optimizer chooses to a inefficient index .
1081162022-08-11
8:21
2024-10-30
6:13
MySQL Server: OptimizerVerified
(1131 days)
S38.0.29, 8.0.30, 5.7.39Any (rhel-7.4)Any (x86-64)SQL queries with range of Item_row are not optimized
1081142022-08-11
7:59
2022-08-11
9:24
MySQL Server: OptimizerVerified
(1131 days)
S38.0.30AnyAnyquery return different result with or without index
1080492022-08-02
10:23
2023-03-18
13:34
MySQL Server: CompilingVerified
(912 days)
S28.0.30Red Hat (Alma Linux 8.6)x86 (AMD)MySQL fails to build on Alma Linux 8.6
1079812022-07-26
13:12
2022-07-26
13:24
MySQL Server: CompilingVerified
(1147 days)
S38.0AnyAnyContribution: Add initial support for Windows on ARM platforms
1079692022-07-26
3:48
2022-07-26
5:29
MySQL Server: OptimizerVerified
(1147 days)
S28.0.29AnyAnywrong result when search binary columns
1078962022-07-15
13:50
2022-07-18
15:21
MySQL Server: GISVerified
(1157 days)
S28.0AnyAnyif exchange the order of input geo, st_intersects will get opposite result
1078212022-07-08
18:02
2022-07-20
6:36
MySQL Server: OptimizerVerified
(1162 days)
S38.0, 8.0.29AnyAnyResult error : SQL with group by with rollup and const field
1077892022-07-07
3:05
2022-07-12
11:50
MySQL Server: OptimizerVerified
(1166 days)
S38.0Ubuntux86can not get only one row when select where id=round()
1076452022-06-24
3:00
2022-06-28
13:48
MySQL Server: DMLVerified
(1179 days)
S35.7.38, 8.0.29AnyAnythe cast function gets an incorrect result if with wrong encoding
1076292022-06-22
8:41
2022-06-22
10:06
MySQL Server: OptimizerVerified
(1181 days)
S38.0.29AnyAnyIncorrect result when using index and materialization-lookup
1076122022-06-20
17:03
2022-06-21
7:09
MySQL Server: DMLVerified
(1182 days)
S28.0.28, 5.7.38, 8.0.29MacOSARMSTRICT sql-mode does not always work with ENUM fields
1076082022-06-20
10:54
2022-06-20
11:56
MySQL Server: Data TypesVerified
(1183 days)
S18.0.25, 8.0.29AnyAnyResults not satisfy expectations with zerofill fields
1076072022-06-20
9:34
2022-06-20
9:51
MySQL Server: OptimizerVerified
(1183 days)
S28.0.29Ubuntux86left join + semijoin + materialization finds false matches
1075982022-06-20
4:40
2022-06-20
5:34
MySQL Server: OptimizerVerified
(1183 days)
S25.7.38AnyAnyOptimizer materialization leads to wrong result
1075852022-06-17
10:29
2022-06-17
11:18
MySQL Server: OptimizerVerified
(1186 days)
S38.0.29Ubuntu (ubuntu 20.04)x86Incorrect result in semi-join and left-join
1075762022-06-16
7:34
2022-06-16
9:24
MySQL Server: OptimizerVerified
(1187 days)
S38.0.29Ubuntu (ubuntu 20.04)x86Incorrect result when comparing 0 and -0 when using materialization-lookup
1075692022-06-15
8:56
2022-06-15
9:21
MySQL Server: OptimizerVerified
(1188 days)
S28.0.29Linuxx86WHERE clause didn’t work with INNER JOIN, WITH, and UNION ALL.
1075542022-06-13
20:28
2022-06-14
16:02
MySQL Server: OptimizerVerified
(1189 days)
S58.0.29-0ubuntu0.20.04.3Ubuntu (20.04.4 LTS)x86regexp_replace in trigger VERY slow when using unicode category \\p{C}
1075352022-06-09
22:56
2023-08-03
19:35
MySQL Server: OptimizerVerified
(774 days)
S38.0.29, 5.7.38AnyAnyGroup by does not use loose scan unless full prefix is given
1075002022-06-07
11:20
2022-06-07
11:29
MySQL Server: CharsetsVerified
(1196 days)
S2any, 8.0AnyAnyContribution by Tentent: Setting default-character-set does not take effect
1074352022-05-31
13:06
2022-06-01
14:26
MySQL Server: GISVerified
(1202 days)
S3AnyAnyIt will return success from expr ST_GeomFromWKB with invalid wkb
1074242022-05-30
5:45
2023-03-30
7:54
MySQL Server: GISVerified
(1203 days)
S28.0.26, 8.0.29, 8.0.32LinuxAnyst_intersects() returns different results with or without spatial index
1074022022-05-26
8:53
2022-05-31
14:24
MySQL Server: GISVerified
(1203 days)
S38.0AnyAnyvalue has changed when 1e-16 is input of GIS expr
1073642022-05-22
15:32
2022-05-23
14:02
MySQL Server: DMLVerified
(1211 days)
S28.0.29Any (Docker(mysql:latest))Anyusing "OR EXISTS" and "SELECT...MATCH" shows less records than expected
1073512022-05-20
10:28
2022-05-24
8:37
MySQL Server: DMLVerified
(1214 days)
S35.7.31, 5.7.38AnyAnyifnull function
1073372022-05-19
6:08
2023-04-14
13:19
MySQL Server: OptimizerVerified
(1215 days)
S38.0.27, 5.7, 8.0.29, 8.0.32LinuxARMIN() does not work correctly for TIME column
1073302022-05-18
12:49
2023-01-25
19:29
MySQL Server: CompilingVerified
(1216 days)
S38.0AnyAnyContribution: fix global-buffer-overflow of fix_paths
1073252022-05-18
10:03
2022-05-18
14:36
MySQL Server: DMLVerified
(1216 days)
S38.0AnyAnySubquery gives wrong results in ON DUPLICATE KEY UPDATE ... part of INSERT
1073242022-05-18
9:50
2022-05-18
14:33
MySQL Server: OptimizerVerified
(1216 days)
S28.0AnyAnyQuery with exists provides inconsistent result
1073042022-05-16
16:00
2022-05-17
6:27
MySQL Server: CompilingVerified
(1217 days)
S38.0AnyAnyContribution: Fix path argument supplied to tar in boost.cmake
1072922022-05-14
0:37
2022-05-17
9:46
MySQL Server: OptimizerVerified
(1220 days)
S58.0.21, 5.7, 8.0AnyAnyIndex isn't used for order if some primary key columns specified in index
1072872022-05-13
10:16
2022-05-15
9:08
MySQL Server: DMLVerified
(1221 days)
S38.0.28, 8.0.29, 5.7.38AnyAnyCASE operator does not follow standard equality
1072862022-05-13
9:06
2022-05-13
9:30
MySQL Server: OptimizerVerified
(1221 days)
S38.0.29AnyAnyRecursive correlated derived table does not work correctly
1072612022-05-11
10:31
2022-05-11
11:18
MySQL Server: OptimizerVerified
(1223 days)
S38.0.29AnyAnyWrong us of dbug_dump
1072252022-05-05
17:13
2023-11-29
17:30
MySQL Server: JSONVerified
(1223 days)
S38.0AnyAnyIFNULL Stringifies JSON Object
1072202022-05-05
9:18
2022-05-11
14:09
MySQL Server: OptimizerVerified
(1229 days)
S3MySQL 8.0, 8.0.29AnyAnyJson query results are inconsistent with or without generated column indexes
1071992022-05-03
15:33
2025-08-17
20:45
MySQL Server: JSONVerified
(1222 days)
S38.0.27AnyAnyInconsistent JSON path ** behaviour between versions
1071092022-04-24
9:07
2023-04-14
13:24
MySQL Server: ParserVerified
(1197 days)
S28.0.27, 5.7.37, 8.0.32Any (rhel-7.4)Any (x86-64)Optimizer hints doesn't work if client charset is the same with charset of syste
1070722022-04-20
16:30
2022-04-21
6:47
MySQL Server: DMLVerified
(1243 days)
S38.0.28AnyAnyIncorrect "Can not delete from join view" when create view based on other view
1070352022-04-15
9:12
2022-04-15
13:34
MySQL Server: OptimizerVerified
(1249 days)
S58.0AnyAnyMRR may cause performance downgrade when multi-range on partition key
1069382022-04-07
2:26
2022-04-08
1:35
MySQL Server: OptimizerVerified
(1256 days)
S18.0, 8.0.28AnyAnylateral derived table with LIMIT produces wrong result
1069282022-04-06
11:39
2022-04-07
12:22
MySQL Server: JSONVerified
(1257 days)
S35.7AnyAnyCan not restore mysqldump that was taken using charset binary
1068502022-03-28
8:43
2022-03-28
14:45
MySQL Server: OptimizerVerified
(1267 days)
S38.0AnyAnywrong result when two table join
1068412022-03-25
16:55
2022-04-27
8:42
MySQL Server: JSONVerified
(1266 days)
S38.0.28, 5.7.37AnyAnyError comparing Json objects and text utf32
1068062022-03-23
7:12
2022-03-23
10:13
MySQL Server: CompilingVerified
(1272 days)
S35.7, 8.0AnyAnybase_list::swap is buggy
1067542022-03-17
7:06
2022-03-21
13:52
MySQL Server: OptimizerVerified
(1278 days)
S55.7, 8.0, 5.7.37, 8.0.28AnyAnyIndex-loose scan doesn't work for signle table partition Query
1067172022-03-13
3:54
2022-03-14
10:36
MySQL Server: OptimizerVerified
(1281 days)
S28.0.28, 8.0.27AnyAnyIncorrect nested loop antijoin when using materialization strategy
1067162022-03-12
15:15
2022-03-14
10:33
MySQL Server: OptimizerVerified
(1281 days)
S28.0.28AnyAnyIncorrect Inner hash join when transforming materialization condition.
1067152022-03-12
11:19
2022-03-14
10:29
MySQL Server: OptimizerVerified
(1281 days)
S28.0.27AnyAnyIncorrect left hash join with subquery in condition
1067132022-03-12
6:02
2022-03-12
8:16
MySQL Server: OptimizerVerified
(1283 days)
S28.0.28AnyAnyIncorrect Semi-join Execution
1067012022-03-11
0:01
2022-03-17
23:56
MySQL Server: DMLVerified
(1284 days)
S38.0AnyAnyContribution: Fix bug in REPLACE() in UNION truncates result
1066542022-03-07
12:06
2022-03-10
14:01
MySQL Server: OptimizerVerified
(1285 days)
S58.0AnyAnyjoin on json key can not use index, but join on virtual column can use index
1066512022-03-07
4:34
2022-03-11
14:21
MySQL Server: OptimizerVerified
(1288 days)
S15.7.*, 5.7.37, 8.0.28AnyAnyQuery wrong result when the condition is "where id ('decimal_a', 'decimal_b')"
1066432022-03-04
15:37
2022-05-03
9:24
MySQL Server: CompilingVerified
(1291 days)
S38.0AnyAnyContribution: fido2.cmake: Fix darwin build
1065972022-02-28
13:25
2022-03-01
7:21
MySQL Server: DMLVerified
(1294 days)
S38.0.25, 8.0.28AnyAnyTIME type truncate error in 'in' function
1065802022-02-26
9:41
2022-03-02
14:56
MySQL Server: OptimizerVerified
(1293 days)
S38.0AnyAnyMulti-Valued Indexes only takes into account a portion of a whole data.
1065422022-02-23
3:12
2022-02-28
1:06
MySQL Server: OptimizerVerified
(1300 days)
S58.0.27, 5.7.37, 8.0.28Any (rhel-7.4)Any (x86-64)in clause on range columns partitioned table is not partition-pruned well
1065332022-02-22
2:05
2022-02-25
13:52
MySQL Server: DMLVerified
(1301 days)
S38.0.25, 5.7,8.0Any (rhel 7.4)AnyThe time type cannot be handled in the `in` statement
1065212022-02-20
13:00
2022-02-21
10:32
MySQL Server: OptimizerVerified
(1302 days)
S38.0.28AnyAnyBackward index scan is not shown for UPDATE/DELETE
1065092022-02-18
13:15
2022-02-18
13:43
MySQL Server: OptimizerVerified
(1305 days)
S28.0.28AnyAnyQuery by multi-valued index and order by desc by another index return one row
1065062022-02-18
10:15
2022-02-18
11:05
MySQL Server: DMLVerified
(1305 days)
S38.0.27, 8.0.28AnyAnymysql does report error for invalid binary literal
1064862022-02-17
9:27
2022-02-17
9:48
MySQL Server: OptimizerVerified
(1306 days)
S28.0.26, 8.0.28AnyAnyThe union query returns an incorrect result
1064732022-02-16
8:55
2022-03-10
9:27
MySQL Server: OptimizerVerified
(1285 days)
S38.0.28AnyAnyInner table of OUT-JOIN is nullable, after applying OUTER2INNER transformation
1064282022-02-09
22:31
2022-02-10
7:23
MySQL Server: OptimizerVerified
(1313 days)
S28.0.28AnyAnyUnexpected aggregation result on lateral join
1063892022-02-07
5:44
2022-02-07
6:10
MySQL Server: CharsetsVerified
(1316 days)
S38.0Any (N/A)AnyWhat is the next step in making utf8 and utf8mb4 synonyms?
1063512022-02-02
0:00
2022-02-04
6:58
MySQL Server: DMLVerified
(1321 days)
S28.0.23, 5.7.37, 8.0.28AnyAnyGroup_concat returns cached results from previous query
1063402022-01-31
16:04
2022-02-01
1:42
MySQL Server: CompilingVerified
(1323 days)
S35.7AnyAnycontribution by Tence : Assertion failed Defining a Sys_var_mybool with NO_ARG
1063322022-01-30
12:54
2022-01-30
14:40
MySQL Server: DMLVerified
(1324 days)
S35.7/8.0CentOS (7)Anyunexpected repeated execution of non-idempotent function in a select
1063122022-01-27
18:14
2022-02-09
13:20
MySQL Server: OptimizerVerified
(1326 days)
S35.7Any (Ubuntu 20.04.3 LTS)Any (Intel(R) Core(TM) i7-10700 CPU @ 2.90GHz)Huge value in GROUP BY clause cause unexpected output
1062972022-01-26
22:39
2022-01-27
6:00
MySQL Server: OptimizerVerified
(1327 days)
S28.0.27, 8.0.28Ubuntu (Ubuntu 20.04.3 LTS)x86 (x86 (Intel(R) Core(TM) i7-10700 CPU @ 2.90GHz))Incorrect outputs when combine unique index with NULL
1062642022-01-24
16:33
2025-04-10
8:12
MySQL Server: OptimizerVerified
(1329 days)
S25.7AnyAnyContribution by Tencent: Prevent badly stale rec_per_key for query optimization
1062252022-01-20
9:54
2023-02-15
7:31
MySQL Server: DMLVerified
(1334 days)
S35.7, 8.0, 8.0.32AnyAnyselect bin("") should return 0 instead of null
1062082022-01-19
7:37
2022-01-21
9:27
MySQL Server: OptimizerVerified
(1335 days)
S38.0.27, 8.0.28, 5.7.37AnyAnyIF function with DECIMAL get different precision result
1061892022-01-17
22:50
2022-01-18
8:44
MySQL Server: JSONVerified
(1336 days)
S35.7.31CentOSAnyjson_object(x,F()) returns NULL if F returns JSON and returns null
1061552022-01-13
7:19
2022-01-13
8:34
MySQL Server: OptimizerVerified
(1341 days)
S2mysql Ver 8.0.27 for Linux on x86_64 (MAnyAnysubquery return wrong record when use expression index
1060902022-01-07
4:45
2022-01-07
6:42
MySQL Server: OptimizerVerified
(1347 days)
S28.0, 5.7.36, 8.0.27AnyAnyquery through *prefix index defined on virutal column* may see unexpected result
1060082021-12-30
9:43
2022-01-03
7:30
MySQL Server: CompilingVerified
(1351 days)
S38.0AnyAnythd in condition 'if (!(thd = new THD)) ' is never NULL
1060032021-12-29
20:06
2022-11-29
7:53
MySQL Server: OptimizerVerified
(1355 days)
S38.0.27/5.7AnyAnyMySQL does not use indexes correctly for backwards ORDER BY conditions
1059902021-12-28
8:37
2021-12-28
9:45
MySQL Server: ParserVerified
(1357 days)
S28.0/5.6/5.7AnyAnyContribution by Tencent: parse ending of SP error
1059832021-12-27
9:42
2023-03-14
14:02
MySQL Server: DMLVerified
(1358 days)
S28.0.26, 8.0.27, 5.7.36MacOSAny`SELECT GREATEST(time '20:00:00', 120000) + 0.00` should return 20
1059752021-12-25
3:13
2023-11-28
9:44
MySQL Server: OptimizerVerified
(1360 days)
S28.0.22,8.0.27LinuxAnyWhen I set duplicateweedout=ON,I got an incorrect query result.
1059162021-12-16
8:12
2021-12-16
11:34
MySQL Server: DMLVerified
(1369 days)
S38.0.26, 8.0.27, 5.7AnyAnycreate enum/set column with binary literal
1058992021-12-15
3:23
2022-01-25
15:43
MySQL Server: OptimizerVerified
(1370 days)
S28.0.27, 5.7AnyAnyResult mismatch when derived_merge
1058602021-12-10
10:17
2021-12-10
14:17
MySQL Server: DMLVerified
(1375 days)
S38.0AnyAnyUNION with JOIN USING puts results under wrong column
1058572021-12-10
7:39
2022-11-16
12:55
MySQL Server: OptimizerVerified
(1343 days)
S38.0.23, 8.0.27LinuxAnyResultSetMetaData return different column type in two calls
1058562021-12-10
7:12
2021-12-10
7:57
MySQL Server: DMLVerified
(1375 days)
S28.0.27AnyAnyInserting values to a view with check option raises unexpected error
1058192021-12-07
9:48
2021-12-07
14:38
MySQL Server: Data TypesVerified
(1378 days)
S38.0AnyAnyConversion from Blob/Text column value to double does not return a truncation er
1057842021-12-03
3:53
2021-12-03
8:49
MySQL Server: DMLVerified
(1382 days)
S38.0, 5.7AnyAnyupdate a set not_null_column = null, not_null_column = 2 should not raise an err
1057832021-12-03
3:18
2023-10-21
9:37
MySQL Server: DMLVerified
(1382 days)
S28.0, 5.7MacOSx86`datetime <cmp> int` returns different result in different SQLs
1057542021-11-30
15:54
2021-12-01
13:45
MySQL Server: Data TypesVerified
(1384 days)
S38.0AnyAnySelecting from column with type "date" returns weird results when joining
1057252021-11-27
7:07
2021-11-27
8:34
MySQL Server: OptimizerVerified
(1388 days)
S25.7, 8.0, 5.7.36, 8.0.27AnyAnyQuery result is not expected
1056682021-11-23
3:19
2021-11-24
12:05
MySQL Server: DMLVerified
(1392 days)
S38.0.26, 5.7, 8.0.27AnyAnyrpad function is not multibyte safe
1056442021-11-19
16:22
2021-11-23
14:10
MySQL Server: OptimizerVerified
(1393 days)
S58.0AnyAnyranges cannot use indexes on joined tables
1056372021-11-19
9:52
2021-11-19
10:25
MySQL Server: OptimizerVerified
(1396 days)
S28.0.25, 8.0.27AnyAnyleft join + semijoin produce wrong results when using materialization strategy
1055872021-11-16
8:57
2021-11-16
9:20
MySQL Server: OptimizerVerified
(1399 days)
S28.0.26AnyAnyPossible Uninitialized Value in sql/sql_help.cc
1055862021-11-16
8:51
2021-11-16
9:19
MySQL Server: OptimizerVerified
(1399 days)
S28.0AnyAnyUninitialized value in storage/innobase/btr/btr0bulk.cc
1055852021-11-16
4:04
2021-11-16
7:19
MySQL Server: DMLVerified
(1399 days)
S28.0AnyAnyPossible Uninitialized Value in sql/sql_handler.cc
1055262021-11-11
9:00
2021-11-17
8:03
MySQL Server: OptimizerVerified
(1400 days)
S35.7AnyAnyQuery result is incompatible with the SQL standard
1055172021-11-10
13:36
2021-11-10
14:36
MySQL Server: Data TypesVerified
(1405 days)
S28.0Any (20.0.4.1)AnyINSERT of CURRENT_TIMESTAMP() vs. DEFAULT differs for TIMESTAMP field
1055152021-11-10
13:10
2023-10-23
13:34
MySQL Server: Data TypesVerified
(1405 days)
S38.0Any (20.0.4.1)AnyTimezone offsets in TIMESTAMP literals broken in DST timezone
1055092021-11-10
1:59
2021-11-10
6:02
MySQL Server: DMLVerified
(1405 days)
S28.0.25, 8.0.27, 5.7.35AnyAnyDECIMAL results are truncated without errors when using derived table
1054892021-11-08
3:38
2021-11-08
4:44
MySQL Server: DMLVerified
(1407 days)
S38.0.27, 5.7.35AnyAnysubtime function seems get wrong result
1054882021-11-08
2:37
2021-12-06
13:08
MySQL Server: CompilingVerified
(1407 days)
S38.0.25, 8.0.27CentOS (centos7)ARM (Linux phy-212-120 4.14.0-115.el7a.0.1.aarch64 #1 SMP Tue Sep 24 08:53:46 CST 2019 aarch64 aarch64 aa)the two question about compiling mysql on arm platform
1054812021-11-06
8:10
2021-11-08
7:55
MySQL Server: DMLVerified
(1409 days)
S38.0.27AnyAnyBIGINT UNSIGNED value on: SELECT (2 < 3) * -1;
1054202021-11-02
12:45
2021-11-02
14:07
MySQL Server: CompilingVerified
(1413 days)
S38.0AnyAnyContribution: Remove unused variables
1053942021-10-31
23:46
2021-11-02
8:32
MySQL Server: CharsetsVerified
(1414 days)
S3all, 5.7, 8.0AnyAnyintroducer _ucs2 not working
1053792021-10-29
9:28
2021-10-29
10:21
MySQL Server: DMLVerified
(1417 days)
S38.0, 5.7MacOSx86select greatest("2020-12-12 12:12:12a", cast("2020-12-12 12:12:12" as datetime))
1053552021-10-28
8:33
2021-11-29
13:09
MySQL Server: OptimizerVerified
(1418 days)
S35.7.36, 8.0.27MacOSx86time <cmp> string returns wrong result
1053082021-10-23
0:59
2021-10-26
12:15
MySQL Server: OptimizerVerified
(1421 days)
S28.0.27AnyAnyExtremely bad plans for star schema using hash joins
1052892021-10-21
14:54
2021-10-25
12:20
MySQL Server: OptimizerVerified
(1424 days)
S35.7AnyAnyOptimizer choose index scan but not index range for query with range condition
1052852021-10-21
11:18
2021-10-26
12:08
MySQL Server: OptimizerVerified
(1421 days)
S38.0Any (AWS RDS)Anycomparing a `bigint` value with an identical `bigint unsigned` value fails
1052612021-10-19
8:24
2021-10-19
11:46
MySQL Server: DMLVerified
(1427 days)
S38.0/5.7AnyAnysystem variable max_join_size acts differently when table size is different
1052572021-10-19
3:58
2021-10-19
7:03
MySQL Server: Prepared statementsVerified
(1427 days)
S38.0, 5.7.35, 8.0.26AnyAnyprepare statement return result is different from execute it directly
1052242021-10-14
9:09
2021-10-21
0:17
MySQL Server: OptimizerVerified
(1425 days)
S38.0, 8.0.26AnyAnydict_stats_analyze_index() may always discard optimal index-based access paths
1051702021-10-08
9:03
2021-10-08
14:24
MySQL Server: Data TypesVerified
(1438 days)
S35.7Any (v10)Anywrong data returned grouping on substring and bit
1051432021-10-05
22:01
2021-10-06
6:16
MySQL Server: OptimizerVerified
(1440 days)
S38.0, 5.7AnyAnyContribution: Fixed scientific notation bug
1050682021-09-28
22:06
2021-10-04
12:07
MySQL Server: OptimizerVerified
(1446 days)
S35.7AnyAnyType ref instead of range after reconsidering_access_paths_for_index_ordering.
1050562021-09-28
2:33
2021-09-29
5:16
MySQL Server: OptimizerVerified
(1448 days)
S58.0.25, 8.0.26, 5.7.35Any (rhel-7.4)Any (x86-64)tables in subquery is not pruned-partition well
1050522021-09-27
14:46
2021-09-27
14:59
MySQL Server: DMLVerified
(1449 days)
S25.7.34, 5.7.35AnyAnyGROUP_CONCAT prematurely truncates with UNION
1050042021-09-22
10:20
2024-02-22
19:27
MySQL Server: ParserVerified
(1453 days)
S28.0.26AnyAnymysql 8.0 parser consuming more memory than 5.7 for similar query
1049782021-09-17
19:57
2021-09-20
9:02
MySQL Server: OptimizerVerified
(1456 days)
S58.0.26, 5.7.35WindowsAnyAdding Join Index forces query optimizer to use inefficient execution plan
1049662021-09-17
9:25
2021-09-17
12:25
MySQL Server: OptimizerVerified
(1459 days)
S38.0.23, 5.7.35, 8.0.26AnyAnydifferent result of in expression when table has index
1049282021-09-13
13:25
2021-09-14
13:53
MySQL Server: DMLVerified
(1462 days)
S38.0AnyAnyLEFT JOIN does not use function-part index
1048832021-09-09
9:54
2021-09-09
11:51
MySQL Server: OptimizerVerified
(1467 days)
S35.7.35AnyAnyResultSet is different between first and second query
1048232021-09-03
17:49
2021-09-06
9:12
MySQL Server: GISVerified
(1470 days)
S38.0.13, 8.0.23, 8.0.26AnyAnyST_Overlaps, ST_Touches returning different values in between SRID 0 and 4326
1048162021-09-02
18:57
2021-09-02
22:57
MySQL Server: DMLVerified
(1474 days)
S25.7.35Linux (mysql:5.7.35 Docker)Any"IN (0, ...)" on a JSON column returns non-matching values
1047602021-08-29
19:12
2021-09-20
12:14
MySQL Server: OptimizerVerified
(1476 days)
S28.0.26AnyAnyincorrect placement of hash join predicates in a left outer join nest
1047562021-08-28
7:52
2021-10-09
7:02
MySQL Server: OptimizerVerified
(1437 days)
S35.7.35AnyAnyIncorrect query results after index creation
1047202021-08-25
13:08
2021-08-26
12:13
MySQL Server: DMLVerified
(1481 days)
S38.0AnyAnyRef scan with impossible where condition returns wrong result
1047132021-08-24
22:56
2024-12-22
6:54
MySQL Server: OptimizerVerified
(1482 days)
S38.0.25, 8.0.26AnyAnyFunctional Index not working with LIKE operator
1046532021-08-18
10:11
2021-08-18
10:25
MySQL Server: DMLVerified
(1489 days)
S38.0.26, 5.7.35AnyAnyextract result incorrect
1046292021-08-16
3:08
2021-08-16
7:09
MySQL Server: OptimizerVerified
(1491 days)
S18.0.25,5.7.35, 8.0.26AnyAnywrong result when outer join prune partition tables with is null predicate
1046282021-08-15
23:37
2021-08-20
12:26
MySQL Server: DMLVerified
(1487 days)
S38.0AnyAnyUnused assignment in MySQL-8.0.23
1045842021-08-10
14:27
2021-08-12
3:20
MySQL Server: CompilingVerified
(1496 days)
S15.7.35Ubuntu (20.04)x86Freshly built mysql client crashes in libedit/terminal.c
1045622021-08-06
16:55
2021-08-06
17:55
MySQL Server: DMLVerified
(1501 days)
S38.0.26Debian (10.9)x86UUID function not executed in implicit subquery, but execute in explicit subquer
1045342021-08-04
13:11
2023-10-11
6:49
MySQL Server: OptimizerVerified
(1502 days)
S28.0, 8.0.26AnyAnyPattern matching using LIKE not working with UFT8MB4_BIN collation
1045252021-08-03
18:18
2021-09-01
19:33
MySQL Server: DMLVerified
(1475 days)
S28.0.26AnyAnyEXISTS in Stored Proc returns incorrect result after first SP execution
1044322021-07-28
3:03
2022-01-25
17:08
MySQL Server: DMLVerified
(1482 days)
S38.0.22, 8.0.26AnyAnyStuck on mysql_cond_wait when get_table_share for non-exist tables
1044212021-07-26
19:58
2021-07-29
7:07
MySQL Server: OptimizerVerified
(1509 days)
S28.0.26, 5.7.35AnyAnyBad plan for WHERE customer_id = @cid ORDER BY id LIMIT 10 with compound PK.
1043362021-07-16
12:38
2021-07-17
18:27
MySQL Server: DMLVerified
(1521 days)
S18.0AnyAnyLEFT Join giving duplicate records for matching records from right table
1042822021-07-12
8:14
2021-07-13
8:35
MySQL Server: OptimizerVerified
(1525 days)
S38.0.25AnyAnyorder by index is not used with low selectivity fields and similar idx
1042502021-07-08
6:47
2021-07-16
13:18
MySQL Server: DMLVerified
(1522 days)
S38.0.25AnyAnykill query will case some mysql client block
1042462021-07-08
3:44
2021-07-08
4:45
MySQL Server: OptimizerVerified
(1530 days)
S28.0.25AnyAnyquery result error with unique index
1042062021-07-05
13:41
2021-07-06
12:56
MySQL Server: DMLVerified
(1532 days)
S38.0.25Any (rhel-7.4)Any (x86-64)`load data` with few specified fields doesn't result in error under STRICT_TRANS
1042012021-07-05
2:50
2021-07-05
5:03
MySQL Server: DMLVerified
(1533 days)
S38.0.25, 5.7.34Ubuntu (20.04)x86 (6 core * 2 threads)Wrong result when compare 'null' with subquery result
1041892021-07-02
8:10
2021-07-02
8:52
MySQL Server: OptimizerVerified
(1536 days)
S35.7.32, 8.0.22, 5.7.34, 8.0.25AnyAnyWrong result for row constructor expression and in clause
1041692021-06-30
14:25
2021-06-30
14:48
MySQL Server: CompilingVerified
(1538 days)
S38.0AnyAnyContribution: Refactoring redundancy code.
1041442021-06-29
12:14
2021-06-30
13:18
MySQL Server: DMLVerified
(1539 days)
S28.0.25, 5.7.34, 5.6.51AnyAnyREPLACE INTO removes the row
1041272021-06-28
7:00
2021-06-28
7:19
MySQL Server: OptimizerVerified
(1540 days)
S28.0, 8.0.25AnyAnyoutput count is unexpected when limit clause is used in CTE
1041162021-06-25
19:04
2021-06-25
22:14
MySQL Server: DMLVerified
(1543 days)
S25.7AnyAnySQL_CALC_FOUND_ROWS with LIMIT returns invalid val when query in parentheses
1040922021-06-23
12:45
2021-06-23
13:00
MySQL Server: OptimizerVerified
(1545 days)
S38.0.25LinuxAnyNO_BNL hint not working if query contains a merged view
1040832021-06-22
8:09
2022-09-22
3:56
MySQL Server: OptimizerVerified
(1546 days)
S58.0.25AnyAnyMySQL optimizer chooses the wrong index due to 'range_uses_more_keyparts'
1040352021-06-16
10:50
2021-06-16
20:28
MySQL Server: DMLVerified
(1552 days)
S3 8.0/5.7Ubuntu (20)AnyStrict SQLMode not honored in SP's based on DB charset
1039972021-06-14
3:24
2021-06-15
13:42
MySQL Server: OptimizerVerified
(1553 days)
S58.0AnyAnyMis-calculate SJM_POS's prefix_rowcount/prefix_costs
1039522021-06-09
4:01
2021-06-09
13:39
MySQL Server: OptimizerVerified
(1559 days)
S38.0AnyAnyThe column name letters capitalized while query from view
1039302021-06-07
18:06
2021-06-08
13:55
MySQL Server: DMLVerified
(1560 days)
S2 5.7.34AnyAnyResult mismatch when unicode collation with special data
1039222021-06-07
7:12
2021-06-07
7:37
MySQL Server: OptimizerVerified
(1561 days)
S35.7.32, 8.0.22, 5.7.34, 8.0.25AnyAnyWrong `between` result for datetime/date/timestamp type
1039182021-06-05
13:58
2021-06-08
8:34
MySQL Server: DMLVerified
(1560 days)
S38.0.25, 5.7.34AnyAnyIllegal mix of collations
1038902021-06-02
13:47
2021-06-03
7:13
MySQL Server: OptimizerVerified
(1565 days)
S38.0.23, 8.0.25AnyAnywrong result when use cte with subquery
1038692021-05-31
14:29
2021-06-03
10:21
MySQL Server: OptimizerVerified
(1566 days)
S58.0.24, 8.0.25AnyAnyDuplicate computation of aggregate function when referred in HAVING clause
1037652021-05-21
9:28
2024-08-19
14:09
MySQL Server: Prepared statementsVerified
(1578 days)
S3Java MySQL Driver 8.0.24, 8.0.25AnyAnyStatement prepare hangs
1037402021-05-19
14:20
2021-05-20
13:41
MySQL Server: OptimizerVerified
(1580 days)
S28.0.18,8.0.24, 8.0.25AnyAnyWhen a primary key uses a reverse index, data will be lost
1036782021-05-13
8:45
2021-05-13
16:10
MySQL Server: GISVerified
(1586 days)
S2MySQL 8.0.20, MySQL 8.0.25Linuxx86ST_Contains function returns incorrect result.
1036772021-05-13
8:04
2021-05-13
8:26
MySQL Server: OptimizerVerified
(1586 days)
S35.7.32, 8.0.22, 8.0.25, 5.7.34AnyAnyMax/Min for enum get different result whether using index
1036652021-05-12
5:48
2021-05-14
6:09
MySQL Server: ParserVerified
(1587 days)
S38.0.23, 5.7.34, 8.0.24AnyAnyThe aliases interferes despite the fact that the database is specified
1036332021-05-08
15:06
2021-05-09
23:04
MySQL Server: DMLVerified
(1590 days)
S25.6/5.7/8.0AnyAnyThe not like returned unexpected results
1036322021-05-08
12:23
2022-08-13
16:23
MySQL Server: OptimizerVerified
(1129 days)
S28.0.23, 8.0.24, 5.7.34Any (Windows, Ubuntu)AnyCan't write; duplicate key in table
1035972021-05-06
2:58
2021-05-06
11:37
MySQL Server: OptimizerVerified
(1593 days)
S38.0.24AnyAnyField_varstring::val_real and Field_varstring::val_int exist logical error
1035552021-05-03
7:16
2021-05-04
5:33
MySQL Server: OptimizerVerified
(1596 days)
S35.7AnyAnyWrong result for dot matching newline with REGEXP
1035442021-04-30
12:44
2021-04-30
13:35
MySQL Server: DMLVerified
(1599 days)
S38.0.22, 8.0.24, 5.7.34AnyAnyAliases in multi table deletes without default schema set
1035222021-04-28
18:02
2021-04-29
5:06
MySQL Server: JSONVerified
(1600 days)
S38.0.24AnyAnyJSON_TABLE: Warning is not produced on truncation
1035152021-04-28
9:31
2021-04-28
9:41
MySQL Server: OptimizerVerified
(1601 days)
S3latest version (8.0.24), 8.0.23Ubuntu (18.04)x86 (Intel)Bug report: strange output in mysql server
1034892021-04-27
3:45
2022-04-28
8:04
MySQL Server: OptimizerVerified
(1602 days)
S38.0.22, 5.7.34, 8.0.24, 8.0.29, 5.7.37AnyAnyDifferent result for enum index
1034242021-04-22
8:58
2021-04-22
9:27
MySQL Server: DMLVerified
(1607 days)
S18.0.23, 8.0.24AnyAnyQuery error in hexadecimal
1033612021-04-19
6:00
2021-05-13
23:05
MySQL Server: JSONVerified
(1610 days)
S38.0.23AnyAnyJSON_VALUE() does not accept an expression in path parameter
1033582021-04-19
3:17
2021-04-19
6:13
MySQL Server: OptimizerVerified
(1610 days)
S35.7.32, 5.7.33AnyAnyDiffernet `not in` result for key/non-key
1033182021-04-14
13:46
2025-05-30
9:30
MySQL Server: Data TypesVerified
(1582 days)
S2 8.0AnyAnyOut of sort memory, consider increasing server sort buffer size for JSON Columns
1033152021-04-14
5:21
2021-04-14
7:14
MySQL Server: CharsetsVerified
(1615 days)
S28.0, 8.0.23CentOSAnyQuery result failure caused by character set
1032982021-04-13
9:19
2021-04-14
5:03
MySQL Server: OptimizerVerified
(1616 days)
S38.0.22, 5.7.33, 8.0.23AnyAnyPotentially wrong results
1032962021-04-13
5:35
2021-04-13
6:01
MySQL Server: OptimizerVerified
(1616 days)
S38.0.22, 5.7.33, 8.0.23AnyAnyAggregate function group by primary key/non-primary key has differnet result
1032892021-04-12
15:00
2021-05-11
5:28
MySQL Server: Data TypesVerified
(1588 days)
S38.0AnyAnybit type display confusing
1032792021-04-12
8:06
2021-04-12
9:35
MySQL Server: CharsetsVerified
(1617 days)
S35.7, 5.6, 5.5, 5.7.33AnyAnyInconsistent byte usage in result set of derived table using utf8m4b charset
1032782021-04-12
6:56
2021-04-12
9:36
MySQL Server: DMLVerified
(1617 days)
S18.0, 8.0.23, 5.7.33AnyAnySUM(decimal) produces wrong result
1032362021-04-07
13:47
2021-04-12
12:47
MySQL Server: DMLVerified
(1619 days)
S18.0.20-8.0.23CentOS (centos7)x86Duplicate empty values after left join
1032332021-04-07
6:58
2021-04-07
7:35
MySQL Server: OptimizerVerified
(1622 days)
S25.7.33CentOSAnywrong results when comparing to null
1031712021-04-01
10:10
2021-04-01
11:48
MySQL Server: DMLVerified
(1628 days)
S28.0./5.7AnyAnyIndex of character utf8 is wrong
1031612021-03-31
6:57
2021-04-08
8:13
MySQL Server: DMLVerified
(1629 days)
S28.0.23AnyAnyThe return value is different after adding a normal index
1031062021-03-25
9:50
2021-03-25
11:39
MySQL Server: OptimizerVerified
(1635 days)
S38.0.23AnyAnyOptimizer hints on subquery won't take effect if the subquery gets transformed
1030512021-03-21
9:30
2021-07-23
13:30
MySQL Server: OptimizerVerified
(1639 days)
S28.0.23AnyAnyWindow with buffering follows equijoin on unique index returns wrong NULL result
1030392021-03-18
14:49
2021-03-26
11:34
MySQL Server: OptimizerVerified
(1634 days)
S58.0.23, 5.7.33CentOS (8.2.2004)AnyQuery with group by not showing that it is using the index for the group by
1030102021-03-17
7:33
2021-03-17
11:16
MySQL Server: OptimizerVerified
(1643 days)
S58.0.23AnyAnySubquery dependent on const tables gets evaluated for unnecessary multiple times
1029702021-03-15
6:22
2021-03-16
11:15
MySQL Server: DMLVerified
(1645 days)
S3MySQL8.0.22, 8.0.23Any (rhel-7.4)Any (intel x86-64)trx reserves record-lock for failed insert statement
1029122021-03-11
2:07
2021-03-11
13:02
MySQL Server: OptimizerVerified
(1649 days)
S38.0, 8.0.23, 5.7.33AnyAnyfilter result different on a index bit column with no-index bit column
1029112021-03-10
23:49
2021-03-12
6:09
MySQL Server: OptimizerVerified
(1649 days)
S25.7, 8.0, 5.7.33, 8.0.23AnyAnyBETWEEN SQL-query on auto-incremented primary key field gives the incorrect resu
1028752021-03-09
8:30
2021-03-09
9:34
MySQL Server: OptimizerVerified
(1651 days)
S38.0.23AnyAnyTree EXPLAIN shows different row estimate for filtering when sorting is used
1028732021-03-09
7:23
2021-03-09
9:38
MySQL Server: DMLVerified
(1651 days)
S38.0.23AnyAnyimplicit cast WHERE datetime_column = 0 not producing Incorrect DATETIME value
1028722021-03-09
3:40
2021-03-09
7:58
MySQL Server: CompilingVerified
(1651 days)
S38.0.22. 8.0.23AnyAnyComments typo
1028502021-03-07
18:55
2021-03-19
12:59
MySQL Server: OptimizerVerified
(1648 days)
S58.0.23AnyAnyMySQL does not use functional index on the function LOG10
1028392021-03-06
11:03
2021-03-06
11:38
MySQL Server: DMLVerified
(1654 days)
S28.0.23AnyAnyIndex out of bounds in regular expression search.
1027772021-03-02
8:36
2021-03-14
20:07
MySQL Server: DMLVerified
(1658 days)
S35.7.22LinuxAnyA replace statement with more than 2 unique values cause breaking replication
1027742021-03-02
0:37
2021-03-06
7:15
MySQL Server: DMLVerified
(1654 days)
S35.7.31,8.0.22, 5.7.33AnyAnyA scenario that result in memory leak
1026862021-02-22
12:50
2021-02-24
16:01
MySQL Server: OptimizerVerified
(1664 days)
S58.0AnyAnyThe query plan changed cause query too long
1026812021-02-22
5:29
2021-02-22
6:05
MySQL Server: OptimizerVerified
(1666 days)
S38.0,5.7.33, 8.0.23AnyAnyresult of "datetime_val not between NULL and NULL" is unexpected
1026562021-02-19
3:52
2021-02-19
6:59
MySQL Server: OptimizerVerified
(1669 days)
S38.0.22, 8.0.23AnyAnySELECT results containing the special character " ︠e " is different
1026012021-02-15
13:42
2021-02-16
9:14
MySQL Server: JSONVerified
(1672 days)
S35.7.31, 5.7.33CentOS (CentOS Linux release 7.6.1810 (Core))Anynested nullif of json values fails
1025992021-02-15
12:11
2023-12-19
10:19
MySQL Server: GISVerified
(1672 days)
S58.0.22Windows (Win 10)x86 (NVMe RAM)Slow performance of MySQL 8 compared with 5.7 on geographical SELECT
1025952021-02-14
23:00
2021-02-15
8:40
MySQL Server: JSONVerified
(1673 days)
S35.7.31, 5.7.33CentOS (CentOS Linux release 7.6.1810 (Core))AnyInternal error: JSON wrapper: unexpected type from json_unquote json_extract
1025942021-02-14
22:31
2021-02-15
8:41
MySQL Server: JSONVerified
(1673 days)
S35.7.31, 5.7.33CentOS (CentOS Linux release 7.6.1810 (Core))Anyjson variable set to null is not <=> null
1025402021-02-09
9:28
2021-02-10
12:56
MySQL Server: DMLVerified
(1679 days)
S55.7AnyAnyA updated-stmt can be repeated with no rand() or now()
1024812021-02-04
15:37
2021-02-05
14:40
MySQL Server: OptimizerVerified
(1683 days)
S38.0.23AnyAnyEXPLAIN FOR CONNECTION not good
1024442021-02-02
1:10
2021-02-02
5:20
MySQL Server: OptimizerVerified
(1686 days)
S25.7.22 - 5.7.32; 8.0.12, 5.7.33Anyx86Dependent subquery with ORDER BY return NULL value
1023732021-01-26
7:53
2021-01-28
1:15
MySQL Server: DMLVerified
(1692 days)
S25.7AnyAnyOrder by "desc" does not work after analyze table.
1022922021-01-19
9:54
2021-12-23
10:00
MySQL Server: OptimizerVerified
(1699 days)
S38.0.22, 8.0.23Any (CentOS Linux release 8.0.1905 (Core))Any (4.18.0-80.el8.x86_64 )ANALYZE TABLE capitalized table name, statistics results are not updated.
1022912021-01-19
9:17
2021-01-19
9:58
MySQL Server: OptimizerVerified
(1700 days)
S18.0, 8.0.22, 8.0.23AnyAnySubquery produces wrong result when set big_tables = 1
1022332021-01-12
11:34
2021-01-12
11:45
MySQL Server: JSONVerified
(1707 days)
S38.0, 8.0.22AnyAnyJSON Path evaluation is not standard-compliant
1021812021-01-07
14:23
2021-01-12
11:12
MySQL Server: OptimizerVerified
(1707 days)
S35.7.30, 5.7.32AnyAnymax_execution_time is not applicable in all query stages
1021692021-01-07
9:42
2021-01-07
10:07
MySQL Server: DMLVerified
(1712 days)
S28.0.18, 5.6.50, 5.7.32, 8.0.22AnyAnytinyint DIV a small value expression return wrong
1021602021-01-06
8:31
2021-01-06
9:01
MySQL Server: OptimizerVerified
(1713 days)
S38.0.22, 5.7.32CentOSAnySimple SELECT query returns different results when an index exists or not
1021502021-01-05
11:53
2021-01-06
8:16
MySQL Server: DMLVerified
(1713 days)
S5MySQL 8.0.22AnyAnyPerformance of repeat() function need to be optimized
1020862020-12-29
12:06
2020-12-31
1:15
MySQL Server: DMLVerified
(1719 days)
S38.0.18Red Hat (7.4)Anythe result of order by cast(field1 as char) is unexpect.
1019452020-12-09
22:03
2020-12-10
5:02
MySQL Server: JSONVerified
(1740 days)
S35.7.31, 8.0.22AnyAnyJSON Unsigned Integer out of range for Unsigned Bigint column
1018812020-12-06
14:29
2020-12-06
19:55
MySQL Server: DMLVerified
(1744 days)
S28.0.22Any (Tested on Win 10 and Linux)x86setting global user variable from GROUP_CONCAT in stored procedure wrong result
1018622020-12-04
1:31
2020-12-10
13:32
MySQL Server: DMLVerified
(1746 days)
S38.0AnyAnyinsert into t1 values (),(); failed when binlog_row_image=minimal
1018202020-12-01
15:23
2021-09-10
9:14
MySQL Server: DMLVerified
(1748 days)
S356, 5.7, 5.6.50, 5.7.32AnyAnyUUID() wrong evaluation.
1017972020-11-30
9:17
2020-12-01
9:17
MySQL Server: DMLVerified
(1749 days)
S35.6AnyAnycreate as select skip sql_mode check for datetime default value
1017962020-11-30
8:52
2020-11-30
8:59
MySQL Server: OptimizerVerified
(1750 days)
S25.6.34, 5.6.50, 5.7.32AnyAnyIncorrect query result for index_subquery type IN subquery
1017942020-11-30
3:46
2020-12-02
4:15
MySQL Server: OptimizerVerified
(1749 days)
S35.7, 5.7.32, 8.0.22LinuxAnyQuery failing with "ERROR 1030 (HY000): Got error 1 from storage engine"
1017182020-11-23
12:35
2020-11-24
5:16
MySQL Server: DMLVerified
(1757 days)
S58.0, 8.0.22LinuxAnyall new.x in before trigger marked in write_set may cause update use temp table
1017052020-11-21
8:01
2022-09-22
17:18
MySQL Server: OptimizerVerified
(1757 days)
S25.7.32AnyAnyOptimizer spends several seconds to produce query plan
1016912020-11-20
7:25
2021-11-05
13:48
MySQL Server: OptimizerVerified
(1760 days)
S38.0.22, 8.0.17, 8.0.18AnyAnyUse substring_index and rank() in a sql cause wrong result
1016652020-11-18
17:58
2020-11-19
14:02
MySQL Server: OptimizerVerified
(1761 days)
S38.0.22Linuxx86mysql use incorrect index during executing "select" query
1015172020-11-09
6:32
2020-11-09
7:41
MySQL Server: OptimizerVerified
(1771 days)
S38.0.20, 8.0.22CentOSAnyEXPLAIN in tree format is inconsistent with classical format when LIMIT 1 used
1014592020-11-04
13:05
2022-02-28
15:34
MySQL Server: OptimizerVerified
(1311 days)
S55.6.50,5.7.32AnyAnyWith more than one value in IN() clause, query skip index use.
1013692020-10-29
8:12
2024-10-10
9:08
MySQL Server: CompilingVerified
(1732 days)
S58.0LinuxAnyRemapping .text and .data application segments to huge pages
1013042020-10-24
4:58
2020-10-24
14:19
MySQL Server: DMLVerified
(1787 days)
S25.7 thru 8.0.21Debian (Buster)x86 (KVM VM)mysql 5.7, 8 insert on duplicate key update on view inserts nothing without err
1012782020-10-22
17:51
2020-10-23
10:26
MySQL Server: OptimizerVerified
(1788 days)
S58.0AnyAnyField_string::cmp suboptimal string comparison
1011862020-10-15
12:35
2020-10-16
11:34
MySQL Server: DMLVerified
(1796 days)
S35.6, 5.7AnyAnyRegexp does not handle square brackets and hyphen in proper way
1011082020-10-09
18:11
2021-10-19
12:01
MySQL Server: DMLVerified
(1427 days)
S28.0.27AnyAnyincorrect derived_merge optimization
1010592020-10-06
2:47
2020-10-06
5:26
MySQL Server: OptimizerVerified
(1805 days)
S38.0.19, 8.0.21, 5.7.31, 5.6.49Anyx86Query result inconsistent for the year type in NOT IN expression
1010242020-10-01
12:55
2020-10-09
15:57
MySQL Server: CompilingVerified
(1802 days)
S58.0AnyAnyGCC malloc function attribute
1009852020-09-29
7:42
2020-09-29
9:18
MySQL Server: OptimizerVerified
(1812 days)
S38.0.21, 5.7.31, 5.6.48AnyAnyStored value for 0.001 is inconsistent, and casted to decimal is also different
1008852020-09-18
3:43
2020-11-09
11:38
MySQL Server: JSONVerified
(1823 days)
S55.7.31AnyAnygenerated column index against json column is not used with different encoding
1008682020-09-16
13:22
2020-09-16
21:09
MySQL Server: CompilingVerified
(1825 days)
S38.0.21Windows (Windows 10 2004)x86Can't build mysqlx plugin on Visual Studio 2019
1008522020-09-15
9:40
2022-11-26
0:29
MySQL Server: OptimizerVerified
(1826 days)
S38.0.20, 8.0.21WindowsAnyANY_VALUE gives unexpected type with GROUP BY
1008372020-09-14
10:44
2020-09-14
12:00
MySQL Server: OptimizerVerified
(1827 days)
S38.0/5.7/5.6AnyAnyNULLIF result is evaluated differently when checked with IS NULL
1008222020-09-12
14:39
2023-02-20
1:47
MySQL Server: DMLVerified
(1605 days)
S38.0/5.7/5.6Red Hat (7.4)Anythe result of group_concat(field1 order by field2) is unexpect.
1008212020-09-12
11:21
2020-09-13
16:05
MySQL Server: DMLVerified
(1828 days)
S38.0.20/5.7/5.6AnyAnyProblems with TEMPORARY tables in TRIGGERS
1008072020-09-11
5:39
2020-09-11
7:50
MySQL Server: OptimizerVerified
(1830 days)
S38.0.21, 5.7.31AnyAnyExplicit IS TRUE changes the result for BETWEEN when index is used
1008062020-09-11
5:36
2020-09-11
7:44
MySQL Server: OptimizerVerified
(1830 days)
S38.0.21, 5.7.31AnyAnyIndex changes behavior of BETWEEN
1007772020-09-09
8:21
2020-09-09
9:51
MySQL Server: OptimizerVerified
(1832 days)
S38.0.21, 5.7.31AnyAnySmall negative float equals to 0 when index is used
1007462020-09-04
19:40
2020-09-04
21:09
MySQL Server: DMLVerified
(1837 days)
S35.7.31, 8.0Anyx86user variable in select causes view to be non-insertable
1007362020-09-03
20:34
2020-09-04
0:56
MySQL Server: DMLVerified
(1837 days)
S25.6.49Any (CentOS 7, Windows)x86 (x86_64)LOAD DATA INFILE does not load one row from specific csv
1006702020-08-28
6:51
2020-08-28
7:13
MySQL Server: OptimizerVerified
(1844 days)
S38.0.21, 5.7.31, 5.6.48AnyAnyUndescribed behavior of INTERVAL function with NULL
1006102020-08-22
22:01
2020-08-24
7:22
MySQL Server: OptimizerVerified
(1848 days)
S25.7.31Ubuntu (18.04)x86HAVING clause is not applied to all rows
1005672020-08-19
3:37
2020-08-27
11:24
MySQL Server: JSONVerified
(1853 days)
S38.0, 8.0.21, 8.0.11AnyAnyUnexpected cast to float from attribute of a JSON datum
1005042020-08-12
11:58
2020-08-18
2:50
MySQL Server: OptimizerVerified
(1854 days)
S18.0.21, 5.7.31Linux (Arch Linux)x86 (x86_64)Count distinct is inconsistent when swapping two fields being counted.
1004932020-08-11
9:43
2020-08-14
3:40
MySQL Server: DMLVerified
(1860 days)
S38.0.18Debian (18.04.)AnyCross schema foreign key blocks actions while stored functions are running
1004892020-08-11
4:17
2020-08-11
5:45
MySQL Server: OptimizerVerified
(1861 days)
S35.7.31, 5.6.48, 8.0.21AnyAnynegative operands with % yields -0 to be displayed
1004712020-08-09
11:41
2020-08-10
13:00
MySQL Server: OptimizerVerified
(1862 days)
S58.0.21AnyAnyoptimizer doesn't consider indexes over FTS when ICP will speed up access
1003982020-07-31
8:33
2020-07-31
9:50
MySQL Server: OptimizerVerified
(1872 days)
S38.0.19, 5.7.31, 8.0.21AnyAnyThe results of aggregation operations are inconsistent in different partitions
1003752020-07-30
6:16
2023-03-10
13:25
MySQL Server: ParserVerified
(1872 days)
S35.7.31, 5.6.48AnyAnyColumn name cannot be parsed inside COS function
1003522020-07-28
9:05
2020-07-28
9:17
MySQL Server: DMLVerified
(1875 days)
S38.0.21AnyAnyDELETE IGNORE deletes wrong rows
1003392020-07-27
17:44
2020-08-17
10:51
MySQL Server: DMLVerified
(1876 days)
S38.0.21Windows (Windows 10 professionqal x64)x86 (ryzen 7 3800)LEFT JOIN doesn't work Join and Right join does on INformation_Scheam
1003072020-07-23
14:08
2020-07-28
15:46
MySQL Server: Data TypesVerified
(1880 days)
S35.7.30AnyAnyJSON field datatype changes unexpectedly
1003052020-07-23
12:37
2020-07-24
12:26
MySQL Server: DMLVerified
(1880 days)
S35.7/8.0Debian (mysql docker official image(5.7 latest))AnyORDER BY on subquery column does not return literal value of subquery
1003012020-07-23
5:16
2020-07-23
5:23
MySQL Server: OptimizerVerified
(1880 days)
S35.7.31, 5.6.48AnyAnyLOG result used as predicate causes the conversion to boolean inconsistent
1002842020-07-22
8:07
2023-05-26
12:38
MySQL Server: DMLVerified
(1880 days)
S35.7.16, 5.7.31AnyAnyQuerying a VIEW fails unless there is a default database
1002702020-07-21
4:30
2020-07-21
6:34
MySQL Server: OptimizerVerified
(1882 days)
S35.7.31, 5.6.48AnyAnyUse MOD result (float number) in HAVING/WHERE is not considered as TRUE
1002092020-07-14
6:55
2020-07-14
14:09
MySQL Server: OptimizerVerified
(1889 days)
S35.7AnyAnyUsing LEAST function results as where condition returns wrong result
1001912020-07-12
10:38
2020-07-13
9:31
MySQL Server: OptimizerVerified
(1890 days)
S55.7.30, 8.0.20AnyAnymacros like COND_FILTER_EQUALITY cannot handle diverse workloads
1001512020-07-08
7:12
2020-08-10
13:44
MySQL Server: OptimizerVerified
(1862 days)
S38.0.20AnyAnyexplain loss Histogram
1000282020-06-29
8:06
2020-07-07
11:08
MySQL Server: OptimizerVerified
(1904 days)
S38.0.18, 5.6.48, 5.7.30,8.0.20AnyAnyLIKE behavior is not same
999952020-06-26
7:57
2020-06-26
13:13
MySQL Server: OptimizerVerified
(1907 days)
S38.0AnyAnyHistogram is not used for filtering estimate when index is disabled
999942020-06-26
7:57
2020-06-26
13:08
MySQL Server: OptimizerVerified
(1907 days)
S58.0AnyAnyIndex range scan is chosen where table scan takes 40% less time
999342020-06-19
2:32
2020-09-21
14:39
MySQL Server: OptimizerVerified
(1914 days)
S58.0.20AnyAnyHash join adds columns to the hash table that is not needed.
998652020-06-13
12:32
2021-01-12
8:56
MySQL Server: DMLVerified
(1919 days)
S38.0.20/5.7/5.6Windows (10 2004)x86 (Coore i5)Server don' delete roqs because of safe_mode even using primary key
997752020-06-04
7:33
2020-08-25
20:30
MySQL Server: OptimizerVerified
(1929 days)
S38.0.20AnyAnyFunctional index and equality condition between two columns
996942020-05-26
13:06
2020-06-01
15:23
MySQL Server: CharsetsVerified
(1932 days)
S58.0AnyAnyImproving performance of my_hash_sort_utf8(mb4)/my_strnncollsp*utf8(mb4)
996842020-05-25
12:19
2022-06-08
12:02
MySQL Server: OptimizerVerified
(1936 days)
S35.6, 5.7, 8.0AnyAnyincorrect determination of big test
996392020-05-20
2:47
2020-05-20
13:41
MySQL Server: DMLVerified
(1944 days)
S38.0.19Ubuntu (Ubuntu 18.04.4 LTS)AnyWrong behavior between insert and insert...select
996062020-05-17
14:41
2021-05-22
7:42
MySQL Server: OptimizerVerified
(1946 days)
S38.0.20, 5.6.48, 5.7.30, 8.0.25, 5.7.34AnyAnyIncorrect ROUND(X,D) result
995562020-05-13
18:18
2020-05-15
12:28
MySQL Server: CompilingVerified
(1949 days)
S58.0.20AnyARMAvoid sequentially consistent atomics for atomic counters
995242020-05-12
9:09
2020-05-12
11:05
MySQL Server: DMLVerified
(1952 days)
S35.6/5.7/8.0AnyAnydifferent subquery results with primary key or not
994992020-05-09
22:13
2020-05-25
11:25
MySQL Server: OptimizerVerified
(1952 days)
S35.7.29AnyAnyIncorrect result when constant equailty expression is used in LEF JOIN condition
994592020-05-06
8:17
2020-05-08
13:41
MySQL Server: OptimizerVerified
(1956 days)
S35.6,5.7,8.0AnyAnySQL run with GROUP_MIN_MAX may infinite loop and never return
994142020-04-30
17:48
2020-05-20
12:20
MySQL Server: OptimizerVerified
(1960 days)
S38.0.20AnyAnyWhere exists performance 8.0.16 onwards
994122020-04-30
13:24
2020-05-06
12:44
MySQL Server: CompilingVerified
(1958 days)
S58.0.19AnyAnyThreads_running becomes scalability bottleneck on multi-node NUMA topologies
993822020-04-28
7:34
2020-04-29
8:13
MySQL Server: ParserVerified
(1965 days)
S15.7, 8.0AnyAnyComplex nested views take up a lot of memory
993812020-04-28
7:26
2020-04-29
7:07
MySQL Server: OptimizerVerified
(1965 days)
S28.0.20AnyAnyORDER_BY Index-level optimizer hint implies NO_JOIN_INDEX for second table
993592020-04-26
10:57
2020-04-27
12:43
MySQL Server: Prepared statementsVerified
(1967 days)
S35.6.47, 5.7.29, 8.0.19AnyAnyOrder by in group_concat with prepare statement returns unexpected results
993542020-04-25
13:34
2020-04-25
18:21
MySQL Server: OptimizerVerified
(1969 days)
S35.7.26, 8.0.19AnyAnyNondeterministic stored function returns incorrect results
993432020-04-24
6:03
2021-05-31
8:36
MySQL Server: ParserVerified
(1970 days)
S28.0.19, 5.7.29, 8.0.25AnyAnySelecting with generated column gets the wrong result
993402020-04-23
20:36
2020-04-24
6:48
MySQL Server: OptimizerVerified
(1970 days)
S28.0.19, 5.6.47, 5.7.29AnyAnyRAND not always returning the same value for equal argument N
992732020-04-16
6:02
2020-04-16
7:53
MySQL Server: OptimizerVerified
(1978 days)
S28.0.19, 5.7.29AnyAnyItem_ref in Having Clause points to invalid outer table field
  Showing 1-1000 of 2028 (Edit, Save, CSV, Feed) Show Next 1000 Entries »