« Show Previous 1000 Entries Showing 1001-2000 of 7284 (Edit, Save, CSV, Feed) Show Next 1000 Entries »
ID# Date Updated Type Status Sev Version OS CPU Summary
1061132022-01-08
6:52
2022-01-08
9:45
MySQL Server: ReplicationVerified
(811 days)
S28.0.27, 5.7.36Anyx86Contribution by Tencent: insert on duplicate key cause 1032 replication error in
1063172022-01-27
22:39
2022-03-21
23:40
MySQL Server: ReplicationVerified
(791 days)
S35.7, 8.0AnyAnyCHANGE REPLICATION FILTER does not persist after restart
1063882022-02-07
1:07
2022-02-07
9:13
MySQL Server: ReplicationVerified
(781 days)
S25.7, 5.7.37AnyAnyUsing SPATIAL KEY cause replication error 1032
1064932022-02-17
14:38
2022-04-11
12:28
MySQL Server: ReplicationVerified
(770 days)
S38.0.28, 5.7.37AnyAnyReplication crash when updating a table with a stored generated field in the pri
1120022023-08-09
6:08
2023-08-09
6:24
MySQL Server: ReplicationVerified
(233 days)
S38.0.23+AnyAnyopt_replication_sender_observe_commit_only is not honored for XA ROLLBACK
1121892023-08-26
23:41
2023-08-28
9:58
MySQL Server: ReplicationVerified
(214 days)
S38.0AnyAnyBinlog::EventHeader position overflow
1122562023-09-05
8:00
2023-10-07
13:28
MySQL Server: ReplicationVerified
(204 days)
S38.0.30 and above, 8.0.34AnyAnyThe event thread_id of source changed after write to local
1123642023-09-15
21:40
2023-09-22
23:44
MySQL Server: ReplicationVerified
(191 days)
S38.0.34AnyAnyCreate table like doesn't write the charset on binlog if its created from a temp
1127172023-10-13
15:14
2023-10-25
8:12
MySQL Server: ReplicationVerified
(156 days)
S38.0.34AnyAnyUndo log truncation does not finalize when super_read_only=1
1130382023-11-10
7:26
2023-11-10
8:36
MySQL Server: ReplicationVerified
(140 days)
S28.0AnyAnyContribution by Tencent: mi->data_lock not release if heartbeat event mismatch
1131872023-11-22
16:24
2023-11-28
21:06
MySQL Server: ReplicationVerified
(124 days)
S58.0 and aboveAnyAnyreplica SQL thread purge applied relay logs blocked commit on source node
1132022023-11-23
17:12
2023-11-23
21:29
MySQL Server: ReplicationVerified
(127 days)
S38.0.35AnyAnyp_s.processlist table does not contain async replica threads after restart
1132602023-11-28
14:55
2024-01-23
10:35
MySQL Server: ReplicationVerified
(66 days)
S38.0.36, 8.2.0, 8.3.0MacOSAnyClient error in error log: MY-004031 - The client was disconnected ...
996282020-05-19
9:16
2020-05-28
14:59
MySQL Server: ReplicationVerified
(1408 days)
S28.0.*AnyAnysemi sync master not handle ack packet correctly when recv packet timeout
997602020-06-02
12:33
2020-06-26
8:51
MySQL Server: ReplicationVerified
(1395 days)
S38.0.16AnyAnyStatements involving temporary tables getting logged
998062020-06-08
16:30
2022-01-13
23:40
MySQL Server: ReplicationVerified
(1390 days)
S3AnyAnyreplace master/slave terminology with primary/replica
1000762020-07-02
8:03
2020-07-03
7:02
MySQL Server: ReplicationVerified
(1365 days)
S35.6, 5.7, 5.7.30, 8.0.20AnyAnyMissing db name when alter current db -break slave
1005912020-08-20
17:57
2020-08-20
19:45
MySQL Server: ReplicationVerified
(1317 days)
S3AnyAnyContribution: Bug #100586 Assertion failure `m_status == DA_ERROR` in `Diag ...
1006122020-08-23
11:28
2020-08-24
4:49
MySQL Server: ReplicationVerified
(1313 days)
S35.6,5.7,8.0AnyAnySQL thread prints wrong command in the error log
1006432020-08-26
11:43
2020-08-28
6:11
MySQL Server: ReplicationVerified
(1309 days)
S38.0.21UbuntuAnyCan't connect to MySQL with sync plugin enabled after user creation
1006912020-08-30
20:16
2022-03-25
16:00
MySQL Server: ReplicationVerified
(735 days)
S38.0.20CentOS (8)x86Incorrect replication of excluded table via replicate-wild-ignore-table
1007232020-09-03
7:30
2020-09-08
19:33
MySQL Server: ReplicationVerified
(1299 days)
S58.0AnyAnyslow MTS recovery in startup
1012622020-10-21
8:57
2023-02-03
7:30
MySQL Server: ReplicationVerified
(1255 days)
S38.0.21, 8.0.32AnyAnyperformance_schema.binary_log_transaction_compression_stats timestamps
1012752020-10-22
13:26
2020-10-23
10:23
MySQL Server: ReplicationVerified
(1253 days)
S35.7, 5.7.31, 5.7.32, 8.0.22AnyAny rpl_semi_sync_master_enabled=ON without any connected slaves will cause timeout
1013142020-10-26
7:14
2020-10-29
7:37
MySQL Server: ReplicationVerified
(1247 days)
S38.0AnyAnyvariable assignment unused in sql/rpl_slave.cc: queue_event()
1013392020-10-27
12:59
2020-10-28
8:18
MySQL Server: ReplicationVerified
(1248 days)
S35.7.29,8.018, 8.0.22, 5.7.32Linuxx86 The binlog file was incorrectly purged
1013512020-10-28
7:28
2020-11-10
12:22
MySQL Server: ReplicationVerified
(1235 days)
S25.7, 5.7.32Linuxx86Replication failure(errno 1399) on dml in XA tr after rollback on timeout
1015672020-11-11
19:22
2020-11-14
1:45
MySQL Server: ReplicationVerified
(1232 days)
S25.7.30/5.7.31AnyAnyGenerated column as primary key breaks replication
1017172020-11-23
12:03
2020-12-15
12:53
MySQL Server: ReplicationVerified
(1204 days)
S28.0, 8.0.22AnyAnyPoor performance on a GTID slave when log_slave_updates is disabled
1017222020-11-23
15:26
2020-11-23
16:58
MySQL Server: ReplicationVerified
(1222 days)
S3AnyAnyContribution: Use mmap for binlog
1018282020-12-02
2:37
2020-12-02
4:32
MySQL Server: ReplicationVerified
(1213 days)
S28.0.22CentOSx86Hash scan incorrectly applied the log resulting in HA_ERR_END_OF_FILE
1019482020-12-10
8:00
2020-12-31
12:11
MySQL Server: ReplicationVerified
(1184 days)
S35.7.29, 5.7.32AnyAnyheartbeat is not compatible with local info
1019552020-12-10
13:51
2020-12-31
12:11
MySQL Server: ReplicationVerified
(1205 days)
S35.7.32AnyAny"heartbeat is not compatible with local info" error message has garbled text
1019642020-12-10
19:57
2020-12-11
8:24
MySQL Server: ReplicationVerified
(1204 days)
S35.7.32, 8.0.22AnyAnyrelay_log_space_limit + stopped sql_thread will stop fetching logs silently
1021002020-12-31
10:58
2020-12-31
12:03
MySQL Server: ReplicationVerified
(1184 days)
S35.7.31, 8.0.22, 5.7.32AnyAnyDCL commands are not replicated witch certain replication filters
1021752021-01-07
12:11
2023-09-13
9:33
MySQL Server: ReplicationVerified
(1155 days)
S28.0.22AnyAnylog_status has wrong binary_log_position of gtid_executed
1104302023-03-20
7:11
2023-03-30
2:49
MySQL Server: ReplicationVerified
(367 days)
S38.0AnyAnyXA COMMIT may not persist GTID into undo header
1105332023-03-28
15:49
2023-03-29
12:17
MySQL Server: ReplicationVerified
(366 days)
S38.0.32AnyAnyXA COMMIT may not be recovered after a crash
1105662023-03-30
11:05
2023-03-31
8:20
MySQL Server: ReplicationVerified
(364 days)
S25.7.41AnyAnyContribution by Tencent: checkpoint may regression in mts
1106832023-04-13
13:21
2023-04-14
7:59
MySQL Server: ReplicationVerified
(350 days)
S35.7, 8.0AnyAnyMulti-threaded slave statistics output is incorrect
1108892023-05-03
5:41
2023-05-03
6:07
MySQL Server: ReplicationVerified
(331 days)
S58.0.32AnyAnybinlog rotate optimize
1110752023-05-18
13:24
2023-05-18
14:01
MySQL Server: ReplicationVerified
(316 days)
S38.0AnyAnyI_S.PROCESSLIST shows misleading information for replica threads
1111462023-05-25
8:45
2023-05-26
9:28
MySQL Server: ReplicationVerified
(308 days)
S38.0AnyAnyWrite set conflict two parallel-able transaction on table with foreign key
1112472023-06-01
15:02
2023-06-05
15:39
MySQL Server: ReplicationVerified
(301 days)
S3MySQL8.0.22, 8.0.23AnyAnyExecuting a SELECT statement causes to allocate lots of memory for binlog
1115072023-06-21
5:12
2023-06-21
9:56
MySQL Server: ReplicationVerified
(282 days)
S35.7.42AnyAnyHuge memory usage by write_set with foreign key info
1115402023-06-23
3:41
2023-06-23
5:15
MySQL Server: ReplicationVerified
(280 days)
S58.0.32AnyAnybinlog compress optimize
1116862023-07-07
1:57
2023-07-07
6:34
MySQL Server: ReplicationVerified
(266 days)
S55.7,8.0, 5.7.42AnyAnyContribution by Tencent: shutdown takes at least 8 seconds if have slave
1119142023-07-28
16:38
2023-08-11
10:26
MySQL Server: ReplicationVerified
(242 days)
S28.0.33AnyAnyGlobal replication filters replace channel specific filters
1136342024-01-12
17:33
2024-01-14
9:16
MySQL Server: ReplicationVerified
(75 days)
S38.0AnyAnyContribution: fix plugin semisync find minAck bug
1137072024-01-22
11:52
2024-01-22
12:04
MySQL Server: ReplicationVerified
(67 days)
S38.3.0, 8.0.36AnyAnyreplication stops after updating geometry column
1137272024-01-23
14:34
2024-01-26
6:39
MySQL Server: ReplicationVerified
(63 days)
S18.0.19+AnyAnyGTID Replica stalls completely when log_slave_updates=0 and a local DDL executed
1138132024-01-31
2:26
2024-02-07
8:24
MySQL Server: ReplicationVerified
(58 days)
S3MySQL8.0,8.0.36AnyAnySemisync will abort due to wrong transaction binlog postion comparison
1138142024-01-31
2:42
2024-01-31
13:16
MySQL Server: ReplicationVerified
(58 days)
S3MySQL8.0,5.7AnyAnyThe Rpl_semi_sync_master_yes_tx and Rpl_semi_sync_master_no_tx are inaccurate
1140742024-02-21
8:35
2024-02-27
14:20
MySQL Server: ReplicationVerified
(37 days)
S58.0.32AnyAnyoptimize for Writeset_trx_dependency_tracker::get_dependency
1141252024-02-26
15:51
2024-02-27
13:37
MySQL Server: ReplicationVerified
(32 days)
S38.0.35,8.0.36CentOS (7.9)x86Parameter set by SET PERSIST is not set to replication threads when restart
1141982024-03-04
4:21
2024-03-07
7:23
MySQL Server: ReplicationVerified
(23 days)
S38.0.35, 8.0.36AnyAnyUsing PERSIST on binlog_transaction_compression partially compresses binary log
1142732024-03-08
2:04
2024-03-08
5:29
MySQL Server: ReplicationNeed Feedback
(21 days)
S3MySQL8.0.22 to 8.0.33AnyAnyturn on the binlog compression and load large data to server will cause oom
1143102024-03-12
4:14
2024-03-19
7:24
MySQL Server: ReplicationVerified
(17 days)
S38.0.33AnyAnyMaster_compression_algorithm output is wrong
1143612024-03-15
1:53
2024-03-19
11:11
MySQL Server: ReplicationVerified
(11 days)
S58.0AnyAnyUnaligned Delegate's lock reduces performance
1144722024-03-25
7:17
2024-03-25
7:20
MySQL Server: ReplicationVerified
(4 days)
S3V8.0AnyAnyMySQL replica encounter error when master and replica innodb_strict_mode=OFF
1145112024-03-29
7:05
2024-03-29
7:05
MySQL Server: ReplicationOpenS3MySQL8.0.22AnyAnyTurn on binlog compression and read binlog generate by big transaction cause oom
1066712022-03-08
12:12
2022-03-11
8:00
MySQL Server: ReplicationVerified
(749 days)
S35.7.35, 5.7.37AnyAnyContribution by Tencent: mark insert select with autoinc column unsafe
1067272022-03-15
2:22
2022-03-15
13:47
MySQL Server: ReplicationVerified
(745 days)
S38.0.28, 5.7.37AnyAnyReport ERROR when logging big binlog events
1068182022-03-24
11:23
2022-06-07
2:29
MySQL Server: ReplicationVerified
(661 days)
S25.7,8.0, 5.7.37AnyAnyReplication may fail when XA transactions use replace into statements
1068452022-03-26
13:23
2022-04-06
1:46
MySQL Server: ReplicationVerified
(723 days)
S28.0.25CentOS (7.6)ARMParallel replication not working with slave_preserve_commit_order=1
1068752022-03-30
14:43
2022-04-05
14:13
MySQL Server: ReplicationVerified
(724 days)
S38.0.28AnyAnyContribution by Tencent: writeset can not be used when binlog_format is mixed
1069702022-04-08
16:55
2022-04-21
0:16
MySQL Server: ReplicationVerified
(714 days)
S38.0.21Linuxx86Replicate_Wild_Do_Table don't take effect
1070082022-04-13
11:44
2022-05-05
7:11
MySQL Server: ReplicationVerified
(694 days)
S25.7.37AnyAnyContribution by Tencent:Shutdown hang due to work thread wait for ack
1071132022-04-24
10:53
2022-04-26
4:17
MySQL Server: ReplicationVerified
(705 days)
S35.7,8.0, 8.0.28AnyAnyGot fatal error 1236 from master when reading data from binary log
1072932022-05-15
13:34
2022-05-21
20:52
MySQL Server: ReplicationVerified
(678 days)
S25.7.37, 8.0.28AnyAnyCURRENT_TIMESTAMP not safe after all?
1073712022-05-23
11:12
2022-05-23
12:29
MySQL Server: ReplicationVerified
(676 days)
S3Ver 8.0, 5.7AnyAnyslave error: Slave I/O for channel '': Unexpected master's heartbeat data
1074382022-05-31
19:57
2023-05-02
16:49
MySQL Server: ReplicationVerified
(667 days)
S25.7.38CentOS (8)AnyJSON STORED generated column values are inserted as NULL on replica
1076772022-06-28
7:41
2022-06-28
8:18
MySQL Server: ReplicationVerified
(640 days)
S28.0.29, 5.7.38AnyAnyContribution by Tencent: create table like temporary table missing charset info
1079282022-07-20
23:09
2022-07-26
2:17
MySQL Server: ReplicationVerified
(617 days)
S28.0AnyAnyMySQL 8.0 Replication breaks when tmpdir space is filled
1079912022-07-27
2:02
2023-10-23
8:31
MySQL Server: ReplicationVerified
(158 days)
S28.0.25AnyAnyClone_persist_gtid causes memory leak
1080612022-08-03
11:33
2022-08-04
2:01
MySQL Server: ReplicationVerified
(603 days)
S35.7.39AnyAnyContribution by Tencent: Generated column calculate error without base column
1084052022-09-06
16:22
2022-09-07
4:56
MySQL Server: ReplicationVerified
(569 days)
S38.0AnyAnyContribution: Implement logic to be able to get a consistent GTID
1069182022-04-05
17:46
2022-05-25
10:19
MySQL Server: Row Based Replication ( RBR )Verified
(674 days)
S38.0.25AnyAnymaster and slave may get serious in-consistence after add auto-increment as pk
1132362023-11-27
17:22
2024-02-03
15:05
MySQL Server: Row Based Replication ( RBR )Verified
(122 days)
S38.0.35-0ubuntu0.22.04.1Ubuntu (22.04.3 LTS 5.15.0-88-generic)x86 (.)conflicting replica_parallel_workers spec causes parallel_mode misconfig
1132512023-11-28
11:54
2023-11-29
9:24
MySQL Server: Row Based Replication ( RBR )Verified
(121 days)
S3MySQL8.0AnyAnythe slow log in slave is logged ,when binlog_format is row
1024822021-02-04
17:24
2021-02-15
16:57
MySQL Server: Row Based Replication ( RBR )Verified
(1146 days)
S35.7AnyAnyData loss with ALL_NON_LOSSY and replication between latin1->utf8mb4
1045462021-08-05
9:50
2024-01-30
15:57
MySQL Server: Row Based Replication ( RBR )Verified
(59 days)
S58.0.26Ubuntu (18.04.5 LTS)x86 (Skylake-SP)MySQL 8.0.26 single thread replication performance is slower than MySQL 5.7.35.
1094012022-12-16
2:01
2023-07-07
12:19
MySQL Server: Row Based Replication ( RBR )Verified
(469 days)
S38.0.31, 5.7.40, 8.0.33AnyAnyRows_query_log_event truncates query due to treating query as C string
1099232023-02-03
14:18
2023-04-03
8:07
MySQL Server: Row Based Replication ( RBR )Verified
(416 days)
S25.7.37, 8.0.30AnyAnyWriteset-based Dependency Tracking will cause error HA_ERR_NO_REFERENCED_ROW.
1100712023-02-15
6:41
2023-02-15
8:11
MySQL Server: Row Based Replication ( RBR )Verified
(408 days)
S2Any, 5.7, 8.0AnyAnyForeign Key should not be added to Writeset-based Dependency Tracking.
1064372022-02-10
23:42
2023-03-07
6:03
MySQL Server: Row Based Replication ( RBR )VerifiedS28.0.28AnyAnyneed an option to let applier thread ignore virtual columns on replica..
778172015-07-23
19:18
2015-07-24
6:46
MySQL Server: Row Based Replication ( RBR )Verified
(3171 days)
S35.6.25, 5.7.7, 5.6.27, 5.7.9AnyAnyBug #60926 was not fixed properly
782652015-08-28
20:48
2015-08-31
22:37
MySQL Server: Row Based Replication ( RBR )Verified
(3133 days)
S35.6.26, 5.7.8, 5.7.9AnyAnyutf8 on master and utf8mb4 on slave leads to "cannot be converted from type" err
730912014-06-24
11:12
2014-07-15
16:22
MySQL Server: Row Based Replication ( RBR )Verified
(3545 days)
S35.5.39, 5.6.21, 5.1.74AnyAnyA character set error may interrupt replication
736482014-08-19
22:10
2018-07-06
3:09
MySQL Server: Row Based Replication ( RBR )Verified
(2240 days)
S2Server version: 5.6.16-log MySQL Communi, 5.6.39LinuxAnyinnodb table replication is very slow with some of the partioned table
691012013-04-30
10:14
2013-04-30
10:14
MySQL Server: Row Based Replication ( RBR )VerifiedS35.6.11AnyAnyAdd counter for number of row events skipped due to IDEMPOTENT slave_exec_mode
798312016-01-04
10:12
2016-01-04
11:28
MySQL Server: Row Based Replication ( RBR )Verified
(3007 days)
S35.6.28AnyAnyUnexpected error message on crash-safe slave with max_relay_log_size set
808212016-03-22
11:38
2023-10-12
16:31
MySQL Server: Row Based Replication ( RBR )Verified
(2920 days)
S35.7, 5.7.11AnyAnyReplication breaks if multi-table DELETE is used in conjunction with Foreign Key
679422012-12-18
21:34
2012-12-20
16:56
MySQL Server: Row Based Replication ( RBR )Verified
(4117 days)
S35.5, 5.6, 5.5.30AnyAnyCREATE TABLE is not written in binary log if connection is killed in the process
749272014-11-19
14:10
2014-11-19
16:42
MySQL Server: Row Based Replication ( RBR )Verified
(3418 days)
S35.6.19, 5.6.23AnyAnyColumn number in slave status error doesn't match information_schema
710352013-11-28
15:53
2014-10-30
8:47
MySQL Server: Row Based Replication ( RBR )Verified
(3772 days)
S2mysqlbinlog Ver 3.4, 5.1.74, 5.5.35, 5.6.16Linux (CentOS release 6.4 2.6.32-358.23.2.el6.x86_64)Anymysqlbinlog dumps out improperly-formatted TIMESTAMP values
333762007-12-19
17:35
2016-10-16
20:45
MySQL Server: Row Based Replication ( RBR )Verified
(4459 days)
S25.1, 6.0 bzrAnyAnyWrite set for table not set correctly when inserting an empty set
542492010-06-05
2:32
2017-05-21
20:45
MySQL Server: Row Based Replication ( RBR )Verified
(5045 days)
S35.1AnyAnyMore verbose RBR error logging
560072010-08-16
10:54
2023-02-12
20:45
MySQL Server: Row Based Replication ( RBR )VerifiedS25.6.99-m5AnyAnyBlackhole slave replication: 2nd slave stops with an error for UPDATE statement
607842011-04-06
22:13
2014-09-25
19:58
MySQL Server: Row Based Replication ( RBR )Verified
(4739 days)
S15.5.8-log MySQL CommunitLinuxAnyLast_SQL_Errno: 1677
434682009-03-06
22:39
2017-05-21
20:45
MySQL Server: Row Based Replication ( RBR )In progressS35.1+AnyAnymodified_non_trans_table is not set in replicated stmt/trans
495092009-12-07
13:40
2012-05-18
20:19
MySQL Server: Row Based Replication ( RBR )VerifiedS3next-mr, 6.0-codebaseAnyAnyRBR replication failure on concurrent ALTER TABLE ENGINE
970272019-09-26
10:02
2021-01-15
16:47
MySQL Server: Row Based Replication ( RBR )Verified
(1169 days)
S25.7.*Anyx86Bulk insert with ON DUPLICATE KEY UPDATE breaks replicaiton
830302016-09-17
7:34
2016-09-19
7:19
MySQL Server: Row Based Replication ( RBR )Verified
(2748 days)
S15.7.13, 5.7.15AnyAnyAUTO_INCREMENT not updated when using REPLACE INTO
830902016-09-22
2:13
2016-09-22
7:26
MySQL Server: Row Based Replication ( RBR )Verified
(2745 days)
S15.7.13, 5.7.15AnyAnyAUTO_INCREMENT not updated when using INSERT ON DUPLICATE KEY UPDATE
834182016-10-18
0:46
2016-10-18
8:51
MySQL Server: Row Based Replication ( RBR )Verified
(2719 days)
S55.6, 5.6.34AnyAnyWhen binlog_row_image is MINIMAL, some updates queries logs redundant columns
834312016-10-18
18:53
2016-11-23
10:21
MySQL Server: Row Based Replication ( RBR )Verified
(2683 days)
S15.6.27.75, 5.6.34CentOSAnyRBR slave's "BEGIN" binlog query event doesn't carry a session database name
852922017-03-03
14:48
2017-03-03
14:49
MySQL Server: Row Based Replication ( RBR )VerifiedS25.6+AnyAnyunreachable statement in function process_event with event type QUERY_EVENT
918222018-07-28
3:56
2018-07-30
10:55
MySQL Server: Row Based Replication ( RBR )Verified
(2069 days)
S35.6, 5.6.41, 5.5.60DebianAnyincorrect datatype in RBR event when column is NULL and not explicit in query
926352018-10-02
13:10
2021-11-30
9:31
MySQL Server: Row Based Replication ( RBR )Verified
(850 days)
S35.7.17, 5.7.36AnyAnyHA_ERR_CORRUPT_EVENT on different slave schema
929492018-10-25
15:38
2018-11-05
11:52
MySQL Server: Row Based Replication ( RBR )Verified
(1981 days)
S35.6.42, 5.7.24, 8.0.13AnyAnyadd auto_increment column as PK cause RBR replication inconsistent
939172019-01-14
13:47
2019-04-23
12:30
MySQL Server: Row Based Replication ( RBR )Verified
(1888 days)
S35.7.24,8.0.12AnyAnyWrong binlog entry for BLOB on a blackhole intermediary master
961422019-07-09
13:24
2019-07-10
8:48
MySQL Server: Row Based Replication ( RBR )Verified
(1724 days)
S35.6,5.7, 5.6.44, 5.7.26AnyAnyInconsistent error on slave for Update event on table with non-exists partition
880572017-10-11
12:42
2018-06-13
12:32
MySQL Server: Row Based Replication ( RBR )Verified
(2361 days)
S35.7.19, 8.0.3AnyAnyIntermediary slave does not log master changes with binlog_rows_query_log_events
882232017-10-25
11:48
2019-01-08
16:10
MySQL Server: Row Based Replication ( RBR )Verified
(1907 days)
S35.7.19, 8.0.3, 5.7.24, 8.0.13AnyAnyReplication with no tmpdir space and InnoDB as tmp_storage_engine can break
885952017-11-21
22:12
2022-11-24
12:06
MySQL Server: Row Based Replication ( RBR )Verified
(2249 days)
S25.6.37AnyAnyRow-based master-master replication broken by add column or drop column
887912017-12-06
15:38
2017-12-08
13:05
MySQL Server: Row Based Replication ( RBR )Verified
(2303 days)
S25.7.20UbuntuAnyBinary log for generated columncontains new value as WHERE clause, not old value
906082018-04-24
14:43
2022-12-18
8:15
MySQL Server: Row Based Replication ( RBR )Verified
(2166 days)
S38.0.11Ubuntu (14.04)x86rpl_gtid.rpl_perfschema_applier_status_by_worker_gtid_skipped_transaction fails
997592020-06-02
12:23
2020-06-04
12:24
MySQL Server: Query CacheVerified
(1394 days)
S35.6, 5.7AnyAnyThree cases QueryCache hit query result error cause result mismatch.
997732020-06-04
3:10
2020-06-04
7:41
MySQL Server: Query CacheVerified
(1394 days)
S35.6, 5.7, 5.7.30AnyAnyQueryCache: session track gitds info error when hit query result cache
1002932020-07-22
14:45
2020-07-27
4:51
MySQL Server: Query CacheVerified
(1341 days)
S35.7, 5.7.31, 5.7.30, 5.6.48AnyAnyThe SERIALIZABLE transactions are not blocked for query cache
1119212023-07-31
7:57
2023-08-11
12:14
MySQL Server: Prepared statementsVerified
(241 days)
S38.0AnyAnyReusing prepared statement for different data types, different outcomes are obse
1120112023-08-09
12:06
2023-08-17
12:21
MySQL Server: Prepared statementsVerified
(232 days)
S38.0AnyAnyRESOURCE GROUP hint fails when used within a prepared statement
1121052023-08-18
2:51
2023-08-18
9:21
MySQL Server: Prepared statementsVerified
(224 days)
S38.1.0, 8.0.34Ubuntu (22.04)x86 (x86_64)Create table from prepared statement issues
1127032023-10-12
12:13
2023-10-12
12:56
MySQL Server: Prepared statementsVerified
(169 days)
S3AnyAnyprepare statment has no warning comping to not prepare statment.
1133012023-12-01
7:22
2023-12-01
8:53
MySQL Server: Prepared statementsVerified
(119 days)
S28.0.35, 8.0.31AnyAnyusing preparation statement to query the time type data, some data is not found
1082932022-08-26
9:30
2022-09-05
7:43
MySQL Server: Prepared statementsVerified
(571 days)
S28.0.29AnyAnyPrepared statement does not use generated column index
1084322022-09-08
15:06
2022-09-08
17:56
MySQL Server: Prepared statementsVerified
(568 days)
S35.7.38/5.7.39AnyAnyUsing the prepare statement causes an "unknown column in 'order clause'" error
1037652021-05-21
9:28
2021-08-03
10:40
MySQL Server: Prepared statementsVerified
(1043 days)
S3Java MySQL Driver 8.0.24, 8.0.25AnyAnyStatement prepare hangs
1052572021-10-19
3:58
2021-10-19
7:03
MySQL Server: Prepared statementsVerified
(892 days)
S38.0, 5.7.35, 8.0.26AnyAnyprepare statement return result is different from execute it directly
1138432024-02-01
2:49
2024-02-01
8:09
MySQL Server: Prepared statementsVerified
(57 days)
S38.0.32, 8.0.36AnyAnyprepared json query can not use index
1140562024-02-19
23:03
2024-02-22
10:56
MySQL Server: Prepared statementsVerified
(36 days)
S58.0.32, 8.0.22+AnyAnyPerformance degredation using REGEXP in statement with parameters vs query
1143382024-03-13
16:41
2024-03-19
11:10
MySQL Server: Prepared statementsVerified
(15 days)
S38.0AnyAnyClient might receive incorrect data in ps-protocol
1113102023-06-07
6:51
2023-06-08
8:30
MySQL Server: Prepared statementsVerified
(295 days)
S38.0.33Ubuntu (22.04)x86 (x86_64)Prepared statement with CTE memory leak
1115602023-06-26
9:33
2023-06-26
13:53
MySQL Server: Prepared statementsVerified
(277 days)
S38.0AnyAnyA Prepare statement with cursor on will hang when executed after cursor closed
819812016-06-23
2:22
2016-06-23
7:48
MySQL Server: Prepared statementsVerified
(2836 days)
S35.6, 5.7AnyAnyBasic automation functionality missing from prepared statements
821392016-07-07
8:41
2016-07-07
10:33
MySQL Server: Prepared statementsVerified
(2822 days)
S25.7.13AnyAnyMySQL server sends internal column type over the wire
965802019-08-19
2:54
2019-08-19
5:09
MySQL Server: Prepared statementsVerified
(1684 days)
S3MySQL-5.7.23, 5.7.27AnyAnyUsing a prepare-stmts with timestampadd function will get an incorrect result
993592020-04-26
10:57
2020-04-27
12:43
MySQL Server: Prepared statementsVerified
(1432 days)
S35.6.47, 5.7.29, 8.0.19AnyAnyOrder by in group_concat with prepare statement returns unexpected results
948572019-04-01
20:37
2019-04-04
13:05
MySQL Server: Prepared statementsVerified
(1821 days)
S25.7.23AnyAnyexecute statement doesn't return correct result
912212018-06-12
7:45
2018-06-12
10:33
MySQL Server: Prepared statementsVerified
(2117 days)
S2innodb_version = 5.7.21, 5.7.22AnyAnyREVOKE ALL PRIVILEGES, GRANT OPTION does not work in stored procedure
690832013-04-26
18:10
2016-02-25
12:24
MySQL Server: Prepared statementsVerifiedS35.6.11AnyAnySyntax error in preparing statement for SET PASSWORD
692182013-05-13
17:57
2024-03-26
7:38
MySQL Server: Prepared statementsVerifiedS25.6.11AnyAnyP_S doesn't record SQL or digest for prepared statements
693832013-06-02
20:57
2017-03-28
0:30
MySQL Server: Prepared statementsVerified
(3952 days)
S35.1, 5.5, 5.6, 5.7AnyAnyPREPARE from a 800 KB string causes ER_PARSE_ERROR "memory exhausted"
785232015-09-22
22:54
2015-09-23
9:31
MySQL Server: Prepared statementsVerified
(3110 days)
S35.7.8-rc-log community version, 5.6.26, 5.6.28, 5.7.10Debian (8.1)Anycan't see temporary table in statement with a subquery and a function
672252012-10-14
15:02
2014-04-29
8:39
MySQL Server: Prepared statementsVerified
(3622 days)
S25.6.10Windows (XP SP3 32bit)Anybinary data truncated when using UNION in prepared statement
400382008-10-15
9:56
2022-12-04
20:45
MySQL Server: Prepared statementsVerified
(5644 days)
S3anyAnyAnyvariables declared inside store procedures should build prepared statements
423372009-01-26
8:05
2022-12-04
20:45
MySQL Server: Prepared statementsVerified
(5540 days)
S15.1.25rcWindowsAnyDROP EVENT:this command is not supported in the prepared statement protocol yet.
424902009-01-30
18:55
2023-09-15
8:12
MySQL Server: Prepared statementsVerified
(5534 days)
S25.1.30, 4.1, 5.0, 5.1, 6.0 bzrAnyAnymysql_stmt_result_metadata incorrectly returns null for some statements
13822003-09-23
9:40
2022-12-04
20:45
MySQL Server: Prepared statementsVerified
(6275 days)
S24.0, 4.1, 5.0, 5.1Any (all)AnySQLDescribeParam returns the same type information
28122004-02-15
12:18
2022-12-04
20:45
MySQL Server: Prepared statementsVerified
(6030 days)
S35.xLinux (Linux/Windows)Anywrong value for stmt->field_count
227742006-09-28
10:24
2022-12-04
20:45
MySQL Server: Prepared statementsVerified
(3719 days)
S25.0.24aLinux (Fedora Core 5 and Windows XP)AnyIncorrectly reported data truncation with server prepared statements
241762006-11-10
10:32
2020-05-03
20:45
MySQL Server: Prepared statementsVerified
(5701 days)
S35.0.30AnyAnybigint.test fails with --cursor-protocol
268242007-03-03
14:21
2018-09-09
20:45
MySQL Server: Prepared statementsVerified
(3724 days)
S25.1.17-bk, probably 4.1 and 5.0 tooAny (All)AnyLibmysql, possibly C/XYZ, does not handle error of COM_STMT_SEND_LONG_DATA
532162010-04-27
17:39
2022-12-04
20:45
MySQL Server: Prepared statementsVerifiedS35.5.3-m3, 5.5.4-m3AnyAnyUnrelated DDL causes repreparation of a prepared statement
622572011-08-25
5:27
2013-07-17
13:56
MySQL Server: Prepared statementsVerified
(4286 days)
S25.5.8-enterprise-commercial, 5.1.64AnyAnyApplication hangs while sending 1GB data using mysql_stmt_send_long_data()
622562011-08-24
21:52
2011-08-25
16:03
MySQL Server: Security: PrivilegesVerified
(4600 days)
S3>= 5.1.53LinuxAnymysql_upgrade should convert Host values in mysql.user to lower case
623902011-09-08
19:34
2011-09-20
19:47
MySQL Server: Security: PrivilegesVerified
(4574 days)
S35.5.15-log, 5.1.60, 5.6.4AnyAny"grant select on <schema>.* to ''" requires "flush privileges"
377822008-07-01
17:58
2011-02-16
23:43
MySQL Server: Security: PrivilegesVerified
(5379 days)
S35.0.62, 5.1, 4.1, 6.0 bzrAnyAnyProgram defensively in sql_acl.cc
397622008-09-30
19:38
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(5659 days)
S35.0.67/5.1/6.0AnyAnycreate/drop user returns wrong rowcount
413112008-12-08
21:39
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(5589 days)
S35.0.67, 5.0.72, 5.1.30AnyAnyset timestamp allows unprivileged users to change per-session clock
303952007-08-13
19:10
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(6073 days)
S35.1AnyAnySHOW PROCESSLIST strange results after REVOKE PROCESS ON *.* FROM ...
315012007-10-10
10:13
2015-09-09
13:53
MySQL Server: Security: PrivilegesVerified
(3990 days)
S35.0.45AnyAnyStored Routines: droping stored procedure revokes all assotiated privileges
332412007-12-14
12:48
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(5588 days)
S35.0.45, 5.1 BKAny (Linux (x86_64))AnyWrong privileges used if there are different for same user name IP and host
341042008-01-28
13:09
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(5898 days)
S35.1AnyAnySELECT FROM I_S.STATISTICS have different privilege requirements than SHOW INDEX
345202008-02-13
13:30
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(5884 days)
S35.0+AnyAnyLate decoding of C-style escape sequences and privilege obfuscation
353632008-03-18
6:14
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(5855 days)
S25.1.22AnyAnyErrors during execution of init_script are not reported to client
353842008-03-18
9:10
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(5848 days)
S35.1.22, 5.1.24-rcWindows (also Linux)AnyRevoke grant fails upon automatic privilege assignment to users on procedures
502382010-01-11
15:08
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerifiedS35.5.1-m2AnyAny'GRANT SUPER' doesn't give 'TABLESPACE' priv in fresh 5.5, upgrade from 5.1 does
543712010-06-09
15:32
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(5041 days)
S35.1.44, 5.1.49-bzrLinuxAnyPrivileges required to use --events option for mysqldump
559722010-08-13
15:10
2011-02-16
23:44
MySQL Server: Security: PrivilegesVerified
(4949 days)
S35.1.47, 5.0, 5.6.99AnyAnyPrivilege ordering sorts % before more specific entries like %.foo.com
438302009-03-24
12:06
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(5481 days)
S35.1.32, 5.0, 5.1, 6.0 bzrLinuxAnyCREATE PROCEDURE causes ERROR 1410 unless ALTER ROUTINE is granted
439182009-03-27
17:45
2016-12-05
10:53
MySQL Server: Security: PrivilegesVerified
(5443 days)
S35.1.31sp1AnyAnyGenerated version string is too long for the binlog
439382009-03-29
9:11
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(5479 days)
S35.1.32AnyAnyWeird error when NO_AUTO_CREATE_USER sql mode is active, creating user w/o pass
443112009-04-16
9:41
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(5357 days)
S25.1.33Windows (Vista 32 bit)Anyprivilege escalation
71912004-12-11
9:46
2017-11-11
19:28
MySQL Server: Security: PrivilegesVerified
(3724 days)
S24.1.7, 5.6.17AnyAnyREVOKE doens't remove permissions from a logged in user
78612005-01-13
6:19
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(6540 days)
S3anyAny (any)AnyColumn level security inconsistent with db/table level security
90342005-03-08
0:25
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(6549 days)
S35.0.3-alpha-debugLinux (SuSE 9.1)AnyViews: Can't GRANT CREATE VIEW unless view already exists
95822005-04-02
14:24
2014-01-17
15:03
MySQL Server: Security: PrivilegesVerified
(3724 days)
S25.0AnyAnyincorrect ACL system refresh after its update by GRANT command
157042005-12-13
7:22
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(6448 days)
S35.0AnyAnyNO_AUTO_CREATE_USER and empty password
199132006-05-18
17:01
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(6239 days)
S35.0.21-community-ntWindows (win32 - XP SP2)AnyMisleading error messages when user attempts to GRANT a priv he doesn't have
202352006-06-02
18:03
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(5903 days)
S35.0.21-community-ntWindows (win32 - XP SP2, Fedora core 5)AnyUnable to SHOW CREATE PROCEDURE without SELECT grant
244552006-11-21
8:40
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(6325 days)
S35.1.12-beta-community-nt, 5.0 BKLinux (linux, window 2000)Anyprocs_priv shows error user after granting procedure's privilege to special user
283312007-05-09
11:37
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(5959 days)
S35.0-bk, 5.1-bkAnyAnyUnclear error message when CREATE USER fails due to duplicate key
285652007-05-21
15:39
2020-05-03
20:45
MySQL Server: Security: PrivilegesVerified
(6139 days)
S35.1, 5.0AnyAnyInformation disclosure during SELECT
292372007-06-20
13:51
2022-12-04
20:45
MySQL Server: Security: PrivilegesVerified
(6122 days)
S35.1.19, 5.0-BKAnyAnyPrivilege system inconsistent
908242018-05-10
13:50
2019-06-08
12:49
MySQL Server: Security: PrivilegesVerified
(1756 days)
S25.7.22FreeBSD (11.1-RELEASE-p8)x86mysql_secure_installation.cc expires all passwords including internal ones
919812018-08-11
13:02
2023-05-10
11:56
MySQL Server: Security: PrivilegesVerified
(2046 days)
S35.6, 5.7, 8.0AnyAnyInconsistent user@host definitions for definer/grantor/grantee columns
920002018-08-13
22:40
2018-08-14
6:11
MySQL Server: Security: PrivilegesVerified
(2054 days)
S35.7.22, 5.7.23AnyAnyCREATE user doesn't validade password hash lenght
934262018-11-30
12:03
2018-11-30
12:15
MySQL Server: Security: PrivilegesVerified
(1946 days)
S38.0.13AnyAny8.0.13 introduced new "volatile" variable
814042016-05-12
18:49
2016-05-13
8:53
MySQL Server: Security: PrivilegesVerified
(2877 days)
S35.7.12UbuntuAnymisleading error message of alter user
814252016-05-14
8:50
2016-05-16
4:14
MySQL Server: Security: PrivilegesVerified
(2874 days)
S35.7.12CentOSAnyInvalid timestamps are inserted into proxies_priv table
816212016-05-27
0:50
2016-06-02
12:07
MySQL Server: Security: PrivilegesVerified
(2857 days)
S35.7, 5.7.12DebianAnyGRANT privileges on db vs db table - Wildcard characters in db name - Escaping
827332016-08-25
21:56
2016-08-27
8:10
MySQL Server: Security: PrivilegesVerified
(2771 days)
S35.6, 5.7, 5.6.32AnyAnyLogin errors after GRANT ON *.* in sql_mode PAD_CHAR_TO_FULL_LENGTH
831742016-09-27
13:53
2016-09-28
13:14
MySQL Server: Security: PrivilegesVerified
(2739 days)
S35.7.12, 5.7.15Linux (na)Anyset password with hash_string does not work as described
860612017-04-24
21:42
2017-05-03
9:26
MySQL Server: Security: PrivilegesVerified
(2522 days)
S35.7.18AnyAnyREQUIRE CIPHER doesn't work as documented
864642017-05-25
18:12
2017-05-25
22:08
MySQL Server: Security: PrivilegesVerified
(2500 days)
S35.7/8.0AnyAnyINFORMATION_SCHEMA.TABLES missing performance_schema.session&global_variables
873632017-08-09
17:24
2017-08-10
18:14
MySQL Server: Security: PrivilegesVerified
(2423 days)
S35.6, 5.5.56, 5.6.37AnyAnyDocument limitations regarding anonymous accounts that use wildcards
874202017-08-15
11:42
2017-08-25
11:57
MySQL Server: Security: PrivilegesVerified
(2417 days)
S35.6.36, 5.6.37, 5.5.56, 5.7.19CentOS (7.3.1611)AnyGRANTS using general and specific permissions
876742017-09-06
4:39
2017-09-06
6:02
MySQL Server: Security: PrivilegesVerified
(2396 days)
S15.7.17, 5.6.37, 5.7.19AnyAnyTable 'user' was not locked with LOCK TABLES on FLUSH PRIVILEGES
886942017-11-29
10:51
2017-12-04
7:23
MySQL Server: Security: PrivilegesVerified
(2311 days)
S35.7.20AnyAnyMySQL accepts wildcard for database name for table level grant but won't use it
888352017-12-08
11:47
2017-12-08
12:25
MySQL Server: Security: PrivilegesVerified
(2303 days)
S38.0.3AnyAnySHOW CREATE USER output not backwards compatible
842442016-12-17
11:27
2017-03-27
12:37
MySQL Server: Security: PrivilegesVerified
(2605 days)
S28AnyAnyDistinguish roles and plain users in mysql.user
970912019-10-02
20:56
2019-11-18
12:54
MySQL Server: Security: PrivilegesVerified
(1604 days)
S25.7+AnyAnyCOM_RESET_CONNECTION does not respect CLIENT_INTERACTIVE
976932019-11-19
15:44
2019-11-21
5:00
MySQL Server: Security: PrivilegesVerified
(1590 days)
S38.0.18, 5.7.28AnyAnyALTER USER user IDENTIFIED BY 'password' broken by invalid authentication_string
1104212023-03-18
4:02
2023-03-26
8:13
MySQL Server: Security: PrivilegesVerified
(369 days)
S38.0.32LinuxAnyMySQL server not honoring connection_memory_limit for user created temp tables
1067852022-03-20
22:02
2022-03-21
5:31
MySQL Server: Security: PrivilegesVerified
(739 days)
S38.0.28AnyAnyAdd ALTER USER privilege
1082222022-08-22
12:05
2022-08-23
13:42
MySQL Server: Security: PrivilegesVerified
(585 days)
S38.0AnyAnyACL cache locking not consistent in 'change_password' function
1000032020-06-26
11:18
2020-06-29
8:29
MySQL Server: Security: PrivilegesVerified
(1369 days)
S38.0.20, 5.7.30AnyAnyEXPLAIN FOR CONNECTION seems to still require the SUPER privilege
1007432020-09-04
15:06
2021-01-24
10:40
MySQL Server: Security: PrivilegesVerified
(1160 days)
S35.7.31, 8.0.21AnyAnyAdditional privileges required to access CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPT
1121522023-08-23
7:17
2023-08-23
12:04
MySQL Server: Security: PrivilegesVerified
(219 days)
S38.0.34AnyAnyRename user to ''@'%' cause "Access denied"
1128732023-10-27
22:49
2023-10-30
7:11
MySQL Server: Security: PrivilegesVerified
(151 days)
S38.0.34, 8.0.35AnyAnyLocked account is not shown in mysql.user
1023782021-01-26
14:24
2021-01-27
10:26
MySQL Server: Security: PrivilegesVerified
(1157 days)
S38.0.22 Enterprise, 5.7.33, 8.0.23Anyx86ALTER USER IF EXISTS ... ACCOUNT LOCK throws error with validate_password
1033932021-04-21
8:02
2021-05-31
17:09
MySQL Server: Security: PrivilegesVerifiedS58.0.24AnyAnyneed efficient way to bulk import grants & privileges for many users/schemas
1041182021-06-26
2:42
2022-08-23
8:45
MySQL Server: Security: PrivilegesVerified
(1004 days)
S28.0.24AnyAnyMGR all second node abnormal stop
1047322021-08-26
7:20
2022-02-25
9:53
MySQL Server: Security: PrivilegesVerified
(946 days)
S38.0.25, 8.0.26, 8.0.28AnyAnyIn the case of using the role, there is a problem with the acl check of the view
1064002022-02-08
2:52
2022-02-08
7:17
MySQL Server: Security: PrivilegesVerified
(780 days)
S35.7, 8.0Any (Fails on all 5.7 environments tested)Any (Only tested amd64/i386)Table-level REVOKE fails for a re-created user.
639262012-01-04
23:22
2012-01-11
20:03
MySQL Server: Security: PrivilegesVerified
(4461 days)
S25.1.59, 5.5.21Linux (CentOS 5.x 64bit)AnyBug 61222 still exists in 5.1.59 (bad handshake due to old passwords change)
645322012-03-03
9:42
2012-03-06
8:38
MySQL Server: Security: PrivilegesVerified
(4409 days)
S25.5.20AnyAnycolumns_priv record not clear or modify when table defination changed
700302013-08-14
9:27
2014-07-22
18:43
MySQL Server: Security: PrivilegesVerified
(3539 days)
S35.6.12AnyAnycurrent_user does not reflect expected value
701142013-08-22
1:38
2013-08-22
8:20
MySQL Server: Security: PrivilegesVerified
(3872 days)
S35.1.61, 5.1.71, 5.5.33, 5.6.13, 5.7.2-m12AnyAnyMySQL Permissions - Renaming a TEMPORARY table requires DROP privilege
703042013-09-11
19:33
2018-03-27
7:46
MySQL Server: Security: PrivilegesVerified
(3405 days)
S35.5.33, 5.5.42LinuxAnyDebug assertion in close_thread_table
703842013-09-20
10:53
2013-10-03
11:26
MySQL Server: Security: PrivilegesVerified
(3830 days)
S25.6.12, 5.6.14AnyAnySHOW GRANTS may not return privileges of a user in current session
704312013-09-26
8:05
2015-07-15
7:11
MySQL Server: Security: PrivilegesVerified
(3180 days)
S15.6.13Any (CentOS)Any5.6 CRASHES WHEN READING ANCIENT SYSTEM TABLES
707422013-10-27
19:22
2014-11-18
10:27
MySQL Server: Security: PrivilegesVerified
(3419 days)
S35.6.14AnyAnyUse hex encoding for show grants for sha256 plugin
709282013-11-16
13:42
2013-11-18
10:30
MySQL Server: Security: PrivilegesVerified
(3784 days)
S35.6.14, 5.7.2-m12AnyAnyError message erroneously claims that SELECT from P_S table is denied
712792014-01-02
17:29
2014-01-08
9:33
MySQL Server: Security: PrivilegesVerified
(3739 days)
S35.6AnyAnyMisleading error message for ANALYZE against PERFORMANCE_SCHEMA tables
732582014-07-10
11:19
2014-07-10
12:27
MySQL Server: Security: PrivilegesVerified
(3550 days)
S3>= 5.6.3, 5.6.20LinuxAnyUnable to analyze ALL queries with EXPLAIN on read-only account
736222014-08-18
9:55
2014-08-18
15:24
MySQL Server: Security: PrivilegesVerified
(3511 days)
S35.5 5.6AnyAnyExisting privileges lost due to the unstable quick sort
793142015-11-17
14:08
2020-03-24
2:56
MySQL Server: Security: PrivilegesVerified
(3054 days)
S35.7.9, 5.6.29AnyAnyHELP not allowed in sandbox
797742015-12-25
8:42
2015-12-29
11:31
MySQL Server: Security: PrivilegesVerified
(3013 days)
S35.7.10, 5.7.11AnyAnysuper_read_only as a server option does not also set read_only
808602016-03-25
10:35
2016-03-26
5:14
MySQL Server: Security: PrivilegesVerified
(2925 days)
S35.7, 5.7.11, 5.6.29LinuxAnyStrange behaviour for PASSWORD function in 5.7
747132014-11-06
12:44
2014-11-07
8:21
MySQL Server: Security: PrivilegesVerified
(3430 days)
S35.6, 5.7, 5.6.22AnyAnyInconsistent error codes returned on lack of access for EXPLAIN UPDATE with view
747332014-11-07
13:02
2014-11-07
16:14
MySQL Server: Security: PrivilegesVerified
(3430 days)
S35.5, 5.6, 5.7AnyAnySELECT privilege is not checked for views on UPDATE which references to columns
747382014-11-07
15:10
2014-11-07
16:52
MySQL Server: Security: PrivilegesVerified
(3430 days)
S35.5, 5.6, 5.7AnyAnyMulti-table DELETE rejected due to lack of SELECT privilege for no good reason
750972014-12-03
16:14
2019-04-08
13:58
MySQL Server: Security: PrivilegesVerified
(3403 days)
S35.6.21AnyAnyWITH GRANT OPTION not functioning as expect
751182014-12-05
16:28
2014-12-09
20:08
MySQL Server: Security: PrivilegesVerified
(3398 days)
S35.6, 5.5.42, 5.6.23, 5.7.6Linux (n.a.)AnyMisleading error message when WITH GRANT OPTION privilege is missing
755722015-01-21
9:22
2015-01-21
10:09
MySQL Server: Security: PrivilegesVerified
(3355 days)
S35.6.22 enterpriseLinux (SLES12)AnyMySQL crashes on create user command after forgetting mysql_upgrade
763902015-03-19
12:15
2016-10-11
8:19
MySQL Server: Security: PrivilegesVerified
(3298 days)
S35.5/5.6/5.7AnyAnywrong privileges in SHOW FULL COLUMNS
766412015-04-09
14:34
2016-02-25
12:24
MySQL Server: Security: PrivilegesVerifiedS35.7.7AnyAnyInconsistent quoting of @@session.proxy_user
750042014-11-26
4:27
2014-12-09
20:42
MySQL Server: Pluggable AuthenticationVerified
(3398 days)
S15.6.20AnyAnyvalidatepassword can't prevent upper case password string which included in file
714652014-01-24
2:56
2014-01-24
17:02
MySQL Server: Pluggable AuthenticationVerified
(3717 days)
S35.5.37AnyAnymysql.user row with plugin and password generates bogus warning
714752014-01-24
21:46
2014-01-27
8:01
MySQL Server: Pluggable AuthenticationVerified
(3714 days)
S35.7AnyAnyServer fails to disable accounts with conflicting password/plugin
742422014-10-07
5:04
2014-10-07
9:53
MySQL Server: Pluggable AuthenticationVerified
(3461 days)
S35.6AnyAnyWrong value returned by external_user variable
743772014-10-14
12:58
2015-11-19
17:30
MySQL Server: Pluggable AuthenticationVerified
(3053 days)
S35.6.21AnyAnyempty processlist for proxy user
792692015-11-13
13:18
2022-12-18
8:23
MySQL Server: Pluggable AuthenticationVerified
(2256 days)
S35.6, 5.7, 8.0.0-dmr, 9.0.0-dmr, 5.7.19, 8.0.4-rcLinuxAnyFailure of auth_socket authentication with sha256_password as default
981132020-01-03
0:19
2020-01-16
16:26
MySQL Server: Pluggable AuthenticationVerified
(1534 days)
S35.7, 8.0AnyAnyCrash possible when load & unload a connection handler
815232016-05-20
15:38
2016-05-24
8:55
MySQL Server: Pluggable AuthenticationVerified
(2866 days)
S35.7.10, 5.7.12AnyAnyPassword validation plugin uses wrong logic
840912016-12-07
11:59
2016-12-13
14:05
MySQL Server: Pluggable AuthenticationVerified
(2663 days)
S35.7.15AnyAnyA possible mistake in send_server_handshake_packet(sql_authentication.cc)
894592018-01-29
18:31
2018-01-29
21:42
MySQL Server: Pluggable AuthenticationVerified
(2251 days)
S3AnyAnyContribution: Adding BinaryLogStream folder
596622011-01-21
16:00
2011-02-16
23:44
MySQL Server: Pluggable AuthenticationVerified
(4804 days)
S35.5, 5.6.2AnyAnyMySQL Server 5.5 wants to change the auth plugin to the same plugin
604322011-03-11
14:56
2011-03-19
9:58
MySQL Server: Pluggable AuthenticationVerified
(4766 days)
S35.5.9AnyAnyModifying mysql.user table can deny users from logging in
607452011-04-03
22:22
2015-11-19
17:44
MySQL Server: Pluggable AuthenticationVerified
(4657 days)
S35.5AnyAnydialog client authentication plugin is broken
1006622020-08-27
13:51
2020-08-27
15:20
MySQL Server: Pluggable AuthenticationVerified
(1310 days)
S38.0.21Linux (n.a.)x86 (n.a.)Require SSL with PAM LDAP on UNIX Socket seems not to work
1001652020-07-09
2:41
2020-07-09
6:32
MySQL Server: Performance SchemaVerified
(1359 days)
S35.7.29, 5.7.30, 8.0.20AnyAnyThe table is visible in performance_schema after renaming it
1003362020-07-27
15:58
2020-07-28
13:45
MySQL Server: Performance SchemaVerified
(1340 days)
S35.7AnyAnyperformance_schema.status_by_thread table not populating on Linux
1004322020-08-05
7:55
2020-08-05
14:03
MySQL Server: Performance SchemaVerified
(1332 days)
S58.0.21AnyARMOptimal memory-barrier for performance-schema counter
1009622020-09-26
5:17
2020-10-26
11:42
MySQL Server: Performance SchemaAnalyzing
(1250 days)
S35.7AnyAnymemory_summary_%_by_event_name Have different values
1013912020-10-30
3:04
2020-11-19
16:59
MySQL Server: Performance SchemaVerified
(1226 days)
S58.0, 8.0.22AnyAnyPerformance Schema storage engine doesn't use index optimizations on group by
1017162020-11-23
9:30
2020-12-29
14:10
MySQL Server: Performance SchemaVerified
(1186 days)
S38.0.22,5.7.32AnyAnyP_S memory_summary_by_account_by_event_name table showing incorrect memory stats
1108572023-04-28
5:56
2023-05-02
13:01
MySQL Server: Performance SchemaVerified
(336 days)
S38.0.30, 8.0.33, 5.7.42CentOS (CentOS (CentOS Linux 7 (Core)))Any ((Linux 3.10.0-1160.49.1.el7.x86_64))invalid NO_INDEX_USED=1 metric when using UNION in queries.
1085332022-09-19
12:04
2022-09-20
6:56
MySQL Server: Performance SchemaVerified
(556 days)
S38.0, 8.0.30AnyAnyNULL query text in performance schema after thread killed
1094522022-12-21
10:22
2022-12-21
12:12
MySQL Server: Performance SchemaVerified
(464 days)
S38.0.31AnyAnyMisleading error message on storage engine failing to collect its log info
1100452023-02-13
11:07
2023-02-13
11:35
MySQL Server: Performance SchemaVerified
(410 days)
S38.0.32Linuxx86Negative numbers on digests
1069852022-04-12
1:11
2022-04-12
7:44
MySQL Server: Performance SchemaVerified
(717 days)
S38.0,5.7AnyAnyperformance_schema.global_variables table shows trimmed data.
1041212021-06-26
15:19
2024-03-20
14:37
MySQL Server: Performance SchemaVerified
(955 days)
S3>=5.7.28 , >=8.0.18, 8.0.25, 5.7.34AnyAnyPSI_THREAD_INFO not updated while executing PREPARED STATEMENTS.
1136592024-01-17
7:55
2024-01-18
11:22
MySQL Server: Performance SchemaVerified
(71 days)
S38.0AnyAnyexplain output "Using temporary" but query dosent create temporary table
1139302024-02-08
11:41
2024-02-09
8:37
MySQL Server: Performance SchemaVerified
(49 days)
S38.0AnyAnyperformance_schema_show_processlist = ON generates inconsistent output
1143002024-03-11
13:45
2024-03-11
14:41
MySQL Server: Performance SchemaVerified
(18 days)
S38.0AnyAnyThe "fake index" of performance_schema.data_lock_waits causes slow sql
1144802024-03-26
7:36
2024-03-26
13:30
MySQL Server: Performance SchemaVerified
(3 days)
S38.0AnyAnyP_S doesn't record SQL or digest for prepared statements for Non-mysql client
1120352023-08-10
19:33
2024-02-21
1:00
MySQL Server: Performance SchemaVerified
(65 days)
S28.0.34AnyAnyMaterializing performance_schema.data_locks can lead to excessive mem usage/OOM
1129592023-11-03
17:53
2023-11-07
10:41
MySQL Server: Performance SchemaVerified
(144 days)
S38.0AnyAnyWrong rows examined in P_S and slow log for Index Merge.
893792018-01-24
11:41
2022-03-31
8:21
MySQL Server: Performance SchemaVerified
(2256 days)
S55.7.20, 5.7.21AnyAnysummary_by_user tables get extremely slow with many users.
896072018-02-09
13:47
2018-06-14
5:03
MySQL Server: Performance SchemaVerified
(2237 days)
S25.7AnyAnyMySQL crash in debug, PFS thread not handling singals.
906312018-04-25
12:57
2018-04-25
15:14
MySQL Server: Performance SchemaVerified
(2165 days)
S38.0.11Ubuntu (14.04)x86 perfschema.statement_digest_query_sample test fails sporadically
984982020-02-06
9:41
2020-02-07
13:01
MySQL Server: Performance SchemaVerified
(1513 days)
S35.7, 8.0Any (n.a.)Any (n.a.)P_S view status_by_thread does not reflect correct results
987342020-02-25
11:51
2020-02-25
14:32
MySQL Server: Performance SchemaVerified
(1494 days)
S35.7.29,8.0.19AnyAnySame digest for different queries if we use integer value in ORDER BY caluse
990392020-03-23
14:29
2020-03-27
1:33
MySQL Server: Performance SchemaVerified
(1466 days)
S3>= 5.6.46 , >=5.7.28, >=8.0.18, 5.6.47, 5.7.29, 8.0.19AnyAnyPSI thread info not getting updated after statement execution
991212020-03-31
8:52
2020-06-23
2:23
MySQL Server: Performance SchemaVerified
(1459 days)
S38.0, 8.0.19AnyAnyPerformance schema does a meaningless summary according to digest
992042020-04-07
20:52
2020-04-13
15:53
MySQL Server: Performance SchemaVerified
(1451 days)
S35.7.29, 8.0.19AnyAnyperformance_schema threads table PROCESSLIST_INFO incorrect behaviour
918252018-07-30
6:16
2020-06-16
8:44
MySQL Server: Performance SchemaVerified
(2069 days)
S35.7.23, 8.0.12, 5.7.22AnyAnyThe user table is renamed as "SYSTEM_USER" in DIGEST_TEXT of history tables
834722016-10-20
21:39
2017-06-27
7:41
MySQL Server: Performance SchemaVerified
(2716 days)
S35.6.27, 5.6.34, 5.7.16LinuxAnyConnection Attributes were not correctly read after change user command
839122016-11-21
15:28
2020-03-09
16:52
MySQL Server: Performance SchemaVerified
(2683 days)
S35.6, 5.7, 5.6.34AnyAnyTime spent sleeping before entering InnoDB is not measured/reported separately
846092017-01-23
12:21
2017-06-27
7:43
MySQL Server: Performance SchemaVerified
(2622 days)
S35.7, 8.0, 5.7.17AnyAnyLock information in TABLE_HANDLES misplaced
846552017-01-24
22:59
2017-06-27
7:44
MySQL Server: Performance SchemaVerified
(2620 days)
S35.7.17AnyAnyreplication worker thread status not showing on performance_schema.threads
949252019-04-06
0:15
2019-04-24
13:37
MySQL Server: Performance SchemaVerified
(1801 days)
S38.0.15AnyAnyWrong Query Sample Text in Performance Query
961962019-07-13
7:17
2019-07-16
10:28
MySQL Server: Performance SchemaVerified
(1719 days)
S35.7.26, 8.0.16AnyAnyperformance_schema_accounts_size and p_s_hosts_size limited by 16384
813942016-05-12
13:40
2023-09-18
15:54
MySQL Server: Performance SchemaVerified
(193 days)
S35.7.12,5.7.15AnyAnyUnable to change performance_schema whilst super_read_only is enabled
826632016-08-20
5:12
2017-06-27
7:40
MySQL Server: Performance SchemaVerified
(2772 days)
S15.7.13, 5.7.14AnyAnymysqld hangs when accessing Performance Schema tables
832762016-10-06
1:03
2016-10-06
7:31
MySQL Server: Performance SchemaVerified
(2731 days)
S25.7,8AnyAnyP_S.replication_connection_status contains a zero datetime
769562015-05-06
14:34
2018-10-31
7:36
MySQL Server: Performance SchemaVerified
(3250 days)
S25.6, 8.0.13AnyAnyThreads table PROCESSLIST_INFO truncate query
772932015-06-10
9:42
2024-01-25
17:10
MySQL Server: Performance SchemaVerified
(1641 days)
S35.6.16Linux (CentOS6.5)AnyWrong processlist_user in threads table for replication threads
780682015-08-14
12:21
2015-08-18
13:08
MySQL Server: Performance SchemaVerified
(3149 days)
S35.7.8AnyAnyreplication_* tables miss information about binary log position and other
783032015-09-02
10:02
2016-09-22
7:50
MySQL Server: Performance SchemaVerified
(3131 days)
S35.7AnyAnyAdd some DNS latency timings to performance_schema (host_cache?)
790112015-10-28
21:53
2017-06-27
7:23
MySQL Server: Performance SchemaVerified
(3052 days)
S35.6.24AnyAnytruncated digest_text values don't always end with "..."
684132013-02-18
2:45
2013-09-25
2:58
MySQL Server: Performance SchemaVerified
(3838 days)
S55.6.10, 5.6.13AnyAnyperformance_schema overhead is at least 10%
697552013-07-16
12:58
2015-05-04
8:59
MySQL Server: Performance SchemaAnalyzing
(3908 days)
S35.5.31-0ubuntu0.12.04.2Linux (Linux xxx 3.5.0-34-generic #55~precise1-Ubuntu SMP Fri Jun 7 16:25:50 UTC 2013 x86_64 x86_64 )Anyfile_instances leaks with innodb_file_per_table
728252014-06-01
3:47
2014-08-10
8:15
MySQL Server: Performance SchemaVerifiedS35.7.4Linux (OL6)AnyWORKER_ID in replication_execute_status_by_worker is always 1 SQL Not Running
731122014-06-25
11:47
2016-02-23
15:52
MySQL Server: Performance SchemaVerified
(2957 days)
S35.6.16, 5.6.17, 5.6.20LinuxAnyPerformance Schema - Statement Tables - Stored Procedures Counters are 0
739672014-09-18
12:35
2015-07-20
8:17
MySQL Server: Performance SchemaVerified
(3363 days)
S35.6.20AnyAnyIncorrect string value for sql_text
794872015-12-02
6:21
2016-01-15
13:07
MySQL Server: Performance SchemaVerified
(3039 days)
S35.6, 5.7AnyAnyProvide non-Windows implementations for LF_BACKOFF
803722016-02-15
12:58
2017-06-27
7:25
MySQL Server: Performance SchemaVerified
(2964 days)
S38.0.0-m17-enterprise-commercial-advancedAnyAnyBuilt-in mysql functions are case sensitive when used in query digest hash
805232016-02-26
9:23
2020-12-30
4:05
MySQL Server: Performance SchemaVerified
(2954 days)
S38.0.0, 8.0.11WindowsAnycurrent_memory in sys.session can go negative!
712042013-12-22
15:42
2014-01-06
13:43
MySQL Server: Performance SchemaVerified
(3748 days)
S35.6.14, 5.6.16AnyAnyTiming for stages in P_S is different from what SHOW PROFILE reports
712932014-01-04
18:35
2021-08-08
20:45
MySQL Server: Performance SchemaVerified
(3735 days)
S35.6AnyAnyManual page for P_S.FILE_INSTANCES table does not explain EVENT_NAME values
708232013-11-05
17:50
2013-11-05
20:00
MySQL Server: PartitionsVerified
(3797 days)
S35.6.14, 5.7.2AnyAnyExtended keys doesn't work for partitioned tables
716302014-02-07
19:36
2014-02-08
20:57
MySQL Server: PartitionsVerified
(3703 days)
S35.1, 5.5, 5.6, 5.7AnyAnyAssertion `! is_set()' fails on UPDATE on a partitioned table with subquery
719062014-03-03
9:47
2014-03-10
8:06
MySQL Server: PartitionsVerified
(3672 days)
S35.6.15AnyAnySHOW CREATE TABLE FOR PARTITIONED TABLES: output slightly wrong
719322014-03-05
9:42
2014-03-05
9:42
MySQL Server: PartitionsVerifiedS35.6.18, 5.7.5AnyAnyreorganize + multirow insert into partition table leads to wrong auto_increment
719472014-03-05
18:55
2014-03-06
5:18
MySQL Server: PartitionsVerified
(3676 days)
S35.6, 5.7AnyAnyUnexpected change in error code on INSERT .. PARTITION causes replication abort
722222014-04-03
14:21
2014-04-03
16:43
MySQL Server: PartitionsVerified
(3648 days)
S3mysql-5.5.35; mysql-5.6.16LinuxAnyStrange interaction of SQL_MODE=ANSI and partition by TIMESTAMP
722742014-04-08
11:45
2014-04-08
14:14
MySQL Server: PartitionsVerified
(3643 days)
S55.6.17LinuxAnyAllow DECIMAL as partitioning key and/or improve pruning for FLOOR(DECIMAL)
777732015-07-17
23:50
2015-07-20
12:44
MySQL Server: PartitionsVerified
(3175 days)
S35.6.23, 5.6.25CentOSAnyDATA DIRECTORY and INDEX DIRECTORY ignored for MyISAM partitions on Linux
781642015-08-21
10:11
2015-11-25
18:23
MySQL Server: PartitionsVerified
(3143 days)
S25.6.26 , 5.6.27, 5.7.9Ubuntu (14.04.2 64bit)Anyalter table command affect partitioned table data directory
793722015-11-21
11:40
2015-11-21
13:33
MySQL Server: PartitionsVerified
(3051 days)
S25.5, 5.5.48AnyAnyINSERT ... SELECT does not preserve rows order in InnoDB partitioned tables
630832011-11-03
0:47
2011-11-29
16:19
MySQL Server: PartitionsVerified
(4504 days)
S25.xAnyAnyERROR 1469 (HY000): The mix of handlers in the partitions is not permitted in th
651122012-04-26
10:30
2012-05-02
20:27
MySQL Server: PartitionsVerified
(4349 days)
S35.5.20, 5.6.6Linux (Linux vega203 2.6.18-238.el5 #1 SMP Thu Jan 13 15:51:15 EST 2011 x86_64 x86_64 x86_64 GNU/Linux)AnyAbout half of partitions are empty on Key partition
652862012-05-11
16:28
2015-01-15
14:43
MySQL Server: PartitionsVerified
(4339 days)
S5mysql 5.1, 5.5AnyAnyAvoid copying on REORGANIZE PARTITION where possible
661872012-08-03
18:07
2012-08-10
16:25
MySQL Server: PartitionsVerified
(4255 days)
S25.1.63, 5.5.25a, 5.5.28AnyAnyWrong query plan for min/max over an entire partition
672412012-10-15
20:03
2012-10-17
13:41
MySQL Server: PartitionsVerified
(4181 days)
S35.5LinuxAnyPartition pruning not working utf8 / skip-character-set-client-handshake options
673512012-10-24
8:02
2017-05-03
16:04
MySQL Server: PartitionsVerified
(4136 days)
S25.5.27-29.0LinuxAnyCardinality samples of partitioned tables sometimes widely off
702652013-09-06
18:10
2015-08-23
20:45
MySQL Server: PartitionsVerified
(3854 days)
S55.6.13AnyAnyOptimizer under-estimates rows when there are many unmatched partitions
703032013-09-11
19:24
2015-11-19
15:57
MySQL Server: PartitionsAnalyzing
(3852 days)
S25.5.32MacOSAnymain.partition sporadically fails when using the embedded server
726142014-05-12
0:42
2014-05-12
6:41
MySQL Server: PartitionsVerified
(3609 days)
S35.6.17, 5.6.19AnyAnyDATA DIRECTORY for partitioned tables
729452014-06-10
21:24
2018-11-02
9:41
MySQL Server: PartitionsVerified
(3579 days)
S35.*AnyAnyPartitions are opened for information_schema.partitions queries
817122016-06-03
13:32
2016-06-06
8:09
MySQL Server: PartitionsVerified
(2853 days)
S25.7.12, 5.6.31, 5.7.13Windows (Microsoft Windows 7 Professional 64bit Service Pack 1)Anylower_case_table_names=2 ignored on ADD PARTITION on Windows
968952019-09-17
5:45
2019-09-19
5:10
MySQL Server: PartitionsVerified
(1655 days)
S35.7.26WindowsAnyTest main.partition_rename_longfilename fails on Samba storage
970412019-09-26
16:20
2019-09-28
14:33
MySQL Server: PartitionsVerified
(1644 days)
S18.0+, 8.0.17, 5.7.27AnyAnymain&sub partition field order different from combined pk, query result lose row
982312020-01-15
8:27
2020-03-11
13:52
MySQL Server: PartitionsVerified
(1533 days)
S38.0AnyAnyshow index from a partition table gets a wrong cardinality value
883772017-11-06
21:54
2019-03-11
13:33
MySQL Server: PartitionsVerified
(1845 days)
S35.5, 5.6, 5.7, 8.0, 5.7.20AnyAny Wrong CREATE_TIME and UPDATE_TIME for partitioned table
886392017-11-24
7:05
2017-11-27
9:48
MySQL Server: PartitionsVerified
(2314 days)
S15.6.38/5.7/8.0AnyAnyERROR 1030 (HY000): Got error -1 from storage engine on PARTITION CREATE TABLE
889162017-12-14
10:59
2021-01-11
3:59
MySQL Server: PartitionsVerified
(2297 days)
S35.6, 5.7, 5.6.38, 5.7.20AnyAnyAssertion `table->s->db_create_options == part_table->s->db_create_options'
871702017-07-23
11:40
2019-02-08
14:12
MySQL Server: PartitionsVerifiedS55.6.37, 5.7.19AnyAnyaltering tables with many partitions is slower than expected
879142017-09-29
11:33
2017-10-04
14:21
MySQL Server: PartitionsVerified
(2368 days)
S35.7AnyAnyPossible unintended usage of a field in file "sql/sql_partition.cc"
948752019-04-02
19:21
2019-04-03
5:57
MySQL Server: PartitionsVerified
(1822 days)
S38.0.15AnyAnyMySQL is performing Engine substitution with partitions
965742019-08-16
17:21
2019-08-19
6:48
MySQL Server: PartitionsVerified
(1684 days)
S25.7.24, 5.7.27MacOSAnyreorganize partition downcases table name on Mac OS X
912032018-06-10
16:02
2018-06-11
8:17
MySQL Server: PartitionsVerified
(2118 days)
S35.6.38, 5.6.40, 5.7.22, 8.0.11CentOS (6,5)x86For partitions table, deal with NULL with is mismatch with reference guide.
918552018-08-01
13:38
2019-07-22
9:15
MySQL Server: PartitionsVerified
(1712 days)
S38.0.12AnyAnyLast reference to WITH_PARTITION_STORAGE_ENGINE and --skip-partition
926612018-10-03
21:42
2018-12-02
22:24
MySQL Server: PartitionsVerified
(2003 days)
S35.7.23AnyAnySELECT on key partitioned enum reading all partitions instead of 1
834352016-10-19
0:40
2020-09-08
22:05
MySQL Server: PartitionsVerified
(2718 days)
S15.7.15/5.6AnyAnyALTER TABLE is very slow when using PARTITIONED table
843602016-12-28
13:36
2016-12-28
15:22
MySQL Server: PartitionsVerified
(2648 days)
S25.7.17Ubuntu (16.04)Anyİt is possible partitoned table to alter to non-existing general tablespace
843622016-12-28
17:11
2016-12-28
17:52
MySQL Server: PartitionsVerified
(2648 days)
S35.6, 5.7,8.0AnyAnyPARTITION BY LIST COLUMNS allows unsupported data types
843702016-12-29
13:42
2016-12-30
4:14
MySQL Server: PartitionsVerified
(2646 days)
S25.7.17AnyAnyIt is possible to enable compression for partitioned table in general tablespace
852382017-03-01
2:58
2017-03-01
10:36
MySQL Server: PartitionsVerified
(2585 days)
S35.6, 5.7, 8.0AnyAnyDropping non-existent partition throws unexpected error under certain conditions
1121812023-08-25
9:04
2023-09-18
8:39
MySQL Server: PartitionsVerified
(214 days)
S38.0AnyAnyTIMESTAMP(N) partitions doesn't prune for inequity
1127382023-10-16
9:26
2023-10-16
9:35
MySQL Server: PartitionsVerified
(165 days)
S18.0.30, 8.0.34AnyAnycan't truncate partition when partition_id exceed INT_MAX
1133382023-12-05
11:16
2023-12-07
8:11
MySQL Server: PartitionsVerified
(113 days)
S38.0.34, 8.0.35LinuxAnyreturn error result with a qubquery
1133692023-12-08
3:51
2024-01-05
13:06
MySQL Server: PartitionsVerified
(112 days)
S38.0.34, 8.0.35AnyAnyIn the hash partition table, the query result is error.
1099392023-02-05
9:23
2023-02-07
9:19
MySQL Server: PartitionsVerified
(416 days)
S38.0.32, 5.7.41AnyAnyLists partitions can not be reorganized (must be in consecutive order)
1099942023-02-08
19:44
2023-02-09
5:35
MySQL Server: PartitionsVerified
(414 days)
S35.7, 8.0AnyAnyUnexpected 1748 error returns when update stored generated column partition key
1103412023-03-10
17:18
2023-03-16
14:12
MySQL Server: PartitionsVerified
(382 days)
S38.0.32AnyAnyFOUND_ROWS() gives wrong result on prepared query against partitioned table
1008102020-09-11
8:11
2020-09-14
18:46
MySQL Server: PartitionsVerified
(1292 days)
S1MySQL8.0.20Any (rhel-7.4)Any (intel x86)miss to check table definition for partitioned table while importing tablespace
1013102020-10-26
4:39
2020-10-27
22:55
MySQL Server: PartitionsVerified
(1250 days)
S38.0.21, 8.0.22AnyAnypartition by key distribute unbalance for utf8
1019842020-12-13
14:28
2020-12-14
7:04
MySQL Server: PartitionsVerified
(1201 days)
S38.0.22, 5.7.32CentOSx86partition by key distribute unbalance when PARTITIONS is even and some COLLATE
1020902020-12-30
7:13
2020-12-30
9:35
MySQL Server: PartitionsVerified
(1185 days)
S3MySQL8.0.22/5.7Red Hat (rhel-7.4)x86 (intel x86-64)partitioned-table creation incorrectly checks timezone-dependent expressions
1048192021-09-03
6:55
2021-09-03
12:17
MySQL Server: PartitionsVerified
(938 days)
S38.0AnyAnypartition table maxvalue define error
1048812021-09-09
8:25
2021-09-15
8:46
MySQL Server: PartitionsVerified
(932 days)
S38.0.26, 5.7.35AnyAnypartition_info::set_used_partition not raise error when finding no partition
1049562021-09-16
8:54
2021-09-16
10:27
MySQL Server: PartitionsVerified
(925 days)
S38.0.26, 5.7.35AnyAnySHOW CREATE TABLE outputs are inconsistent after CREATE TABLE and ALTER TABLE
1049812021-09-18
7:14
2021-09-20
6:44
MySQL Server: PartitionsVerified
(921 days)
S38.0.26AnyAnyRaise error that partition' name to be dropped doesn't exist at an earlier stage
1050142021-09-23
3:32
2021-09-23
15:33
MySQL Server: PartitionsVerified
(918 days)
S18.0.25, 8.0.26, 8.0.11, 5.7.35Any (rhel-7.4)Any (x86-64)query gets incorrect resultset from table with subpartitions
1050752021-09-29
13:00
2021-09-29
13:35
MySQL Server: PartitionsVerified
(912 days)
S35.7AnyAnypart field of unsigned bigint type
1051862021-10-11
9:40
2021-10-11
10:41
MySQL Server: PartitionsVerified
(900 days)
S28.0.26, 5.7.35AnyAnya null value is not treated as zero in hash partition table
1052022021-10-13
10:02
2021-10-13
10:52
MySQL Server: PartitionsVerified
(898 days)
S38.0.26, 5.7.35AnyAnyha_innopart::store_lock() traverse all partitions starting from index 1 not 0
1052042021-10-13
11:22
2021-11-01
8:41
MySQL Server: PartitionsVerified
(898 days)
S38.0.26AnyAnyha_innopart traverse all partitions instead of only used partitions causing loss
1053172021-10-26
6:12
2021-10-26
7:20
MySQL Server: PartitionsVerified
(885 days)
S38.0.26, 8.0.27AnyAnyBehavior of auto-increment value after EXCHANGE PARTITION is inconsistent
1054902021-11-08
11:28
2022-01-26
8:45
MySQL Server: PartitionsVerified
(872 days)
S38.0.27AnyAnyEmpty loop brings loss to performance when pruning partitions for INSERT command
1058012021-12-05
3:35
2021-12-08
14:16
MySQL Server: PartitionsVerified
(842 days)
S55.7AnyAnyha_innopart::records_in_range spend too much cpu cost
1060392022-01-05
7:08
2022-01-11
6:10
MySQL Server: PartitionsVerified
(808 days)
S58.0.27AnyAnySkip using priority queue and visiting unused partitions when single partition
1115822023-06-27
12:03
2023-06-30
10:33
MySQL Server: PartitionsVerified
(273 days)
S38.0.33AnyAnyQuery is incorrect after importing partition table with a different definition
1116852023-07-07
1:13
2023-07-07
8:13
MySQL Server: PartitionsVerified
(266 days)
S38.0.32, 8.0.33Linuxx86ADD PARTITION with DATA DIRECTORY forces relocation of other partitions
1134192023-12-14
12:50
2023-12-18
10:47
MySQL Server: PartitionsVerified
(105 days)
S38.0AnyAnyContribution by Tencent: partition prune ignore subpartition where condition
1137002024-01-22
4:13
2024-01-22
8:45
MySQL Server: PartitionsVerified
(67 days)
S28.0.22, 8.0.36AnyAnyREORGANIZE PARTITION causes losing data
1137502024-01-25
6:50
2024-01-26
10:12
MySQL Server: PartitionsVerified
(63 days)
S28.0.36Any (rhel-7.4)Any (x86-64)stats of partitions could be empty after some kind of alter table DDL statements
1143962024-03-19
2:54
2024-03-19
5:53
MySQL Server: PartitionsVerified
(10 days)
S28.0.22, 8.0.35, 8.0.36AnyAnyNULL is not treated as 0 for tables partitioned by key
1144002024-03-19
9:34
2024-03-19
12:16
MySQL Server: PartitionsVerified
(10 days)
S38.0.32, 8.0.36AnyAnyCreate partition table with DATA DIRECTORY execution result is incorrect
1066092022-03-01
8:11
2022-03-02
1:55
MySQL Server: PartitionsVerified
(759 days)
S38.0.27, 5.7AnyAnyFor EXCHANGE PARTITION, make partition table writable while validation
1068842022-04-01
8:53
2022-05-24
20:59
MySQL Server: PartitionsVerified
(725 days)
S28.0, 8.0.28AnyAnyData are not repartitioned when the partition key's charset is modified
1075562022-06-14
1:52
2022-06-14
8:20
MySQL Server: PartitionsVerified
(654 days)
S28.0.29AnyAnyrestore_object_from_record on partition table consumes too much memory
1077912022-07-07
7:01
2022-07-18
9:11
MySQL Server: PartitionsVerified
(631 days)
S38.0.29, 5.7.38AnyAnyLeft join with derived partitioned table returns wrong result
1030292021-03-18
6:34
2021-03-19
13:02
MySQL Server: PartitionsVerified
(1107 days)
S38.0AnyAnySuboptimal plan due to null partition catch
590042010-12-17
18:15
2015-08-23
20:45
MySQL Server: PartitionsVerified
(4851 days)
S35.5.9Linux (SUSE 64-bit)Anypartition with floor(big_decimal_column) fails
602982011-03-01
22:33
2021-06-02
2:23
MySQL Server: PartitionsVerified
(4775 days)
S35.1+AnyAnyGeometry columns/spatial indexes unsupported in partitioned tables
603252011-03-03
21:29
2011-03-12
10:39
MySQL Server: PartitionsVerified
(4766 days)
S35.5, 5.1.57, 5.6.3AnyAnypartition optimization
625682011-09-28
21:54
2011-11-09
16:34
MySQL Server: PartitionsVerified
(4565 days)
S35.5.12, 5.5.17AnyAnyPartition options not supported by storage engine are silently ignored
363122008-04-24
7:42
2020-11-22
20:45
MySQL Server: PartitionsVerified
(4846 days)
S35.1.24,5.1.51LinuxAnyInnoDB DATA_FREE BUG?
463002009-07-20
9:07
2011-02-16
23:44
MySQL Server: PartitionsVerified
(4969 days)
S35.1.36-log, 5.1.46, 5.5.3HP/UX (11.23 PA 2.0, LINUX F12)AnyPartitioned table: LOAD DATA INFILE "stalls" - HPUX 11.23 PA RISC
503932010-01-17
0:46
2011-02-16
23:44
MySQL Server: PartitionsVerified
(5185 days)
S35.1+AnyAnyinsert DELAYED disabled for partitioned myisam
514702010-02-24
17:36
2011-02-16
23:44
MySQL Server: PartitionsVerified
(5113 days)
S25.1, 5.5.1, 5.6.99AnyAnysubpartition by key need an expression
538192010-05-19
17:42
2022-12-27
1:25
MySQL Server: PartitionsAnalyzing
(5063 days)
S3mysql-next-mr-wl3561AnyAnyassert in my_seek, concurrent workload
528442010-04-15
1:00
2022-12-04
20:45
MySQL Server: ParserVerified
(5097 days)
S35.0.60-log, 5.0.91, 5.1.47Any (Linux, Mac OS X)Anysemi-colon following MySQL comment fails to parse inside of CREATE PROCEDURE
534262010-05-05
8:01
2022-12-04
20:45
MySQL Server: ParserVerified
(5077 days)
S35.1.44AnyAnyNot able to parse a ISO9075 compliant 3-table join
544912010-06-14
16:12
2022-12-04
20:45
MySQL Server: ParserVerified
(5037 days)
S35.5.3AnyAnyinconsistent handling of sql_no_cache between 5.1 and 5.5
545802010-06-17
10:54
2022-12-04
20:45
MySQL Server: ParserVerified
(5034 days)
S35.1.49-bzrAnyAnyplugin with a name starting like an existing option causes wrong parsing
554772010-07-22
11:21
2020-02-12
23:32
MySQL Server: ParserVerified
(4952 days)
S15.1.44, 5.1.50-bzr, 5.5.20Windows (XP)AnyBad parsing of SQL operators (!! is different from ! !)
558402010-08-09
14:45
2022-12-04
20:45
MySQL Server: ParserVerified
(4607 days)
S35.1.45, 5.5-bzrAnyAnyPrecedence / Order of Operations = IN strange.
626962011-10-12
9:36
2011-11-09
15:38
MySQL Server: ParserVerified
(4552 days)
S35.5.17, 5.6.4-m5AnyAnyUsing a numeric operator on a TIME column should return an error or warning
19562003-11-25
16:23
2022-12-04
20:45
MySQL Server: ParserVerified
(5662 days)
S34.0.12, 4.1.0, 5.1.52Any (Any)AnyParser allows naming of PRIMARY KEY
59672004-10-07
22:31
2022-12-04
20:45
MySQL Server: ParserVerified
(5990 days)
S15.0.2-alpha-debugLinux (SuSE 8.2)AnyStored procedure declared variable used instead of column
143472005-10-26
18:53
2022-12-04
20:45
MySQL Server: ParserVerified
(5539 days)
S25.0.15, 5.0.74, 5.1.30, 6.0.9Linux (Linux Suse 10, Windows)AnyCan't remove FOREIGN KEY
248332006-12-05
18:34
2018-09-09
20:45
MySQL Server: ParserVerified
(6283 days)
S35.0.26, 5.1 BKLinux (Linux)AnyQUICK option to DELETE lost in a multiple-table delete
289022007-06-05
18:46
2022-12-04
20:45
MySQL Server: ParserVerified
(5840 days)
S35.1AnyAnyStrange: CREATE TEMPORARY TABLE <not existing database>.t1 is successful
385832008-08-05
19:41
2022-12-04
20:45
MySQL Server: ParserVerified
(5643 days)
S35.0.51b-community-nt MySQL Community EdiWindowsAnyParser error messages are meaningless.
412352008-12-04
16:41
2022-12-04
20:45
MySQL Server: ParserVerified
(5594 days)
S35.1.29, 4.1, 5.0, 5.1, 6.0 bzrAny (Mac OS X, Linux)AnyUsing * and a function in a SELECT can cause a SQL syntax error (ERROR 1064)
505102010-01-21
15:23
2022-12-04
20:45
MySQL Server: ParserVerified
(5181 days)
S35.0+, 5.1+, 6.0-codebaseAnyAnyinvalid double LIMIT clause is accepted
520882010-03-16
12:14
2022-12-04
20:45
MySQL Server: ParserVerified
(5015 days)
S35.1.49-bzrAny (Debian Squeeze 32-bit/Ubuntu 9.10 .deb package, Windows XP)AnyComments are sometimes incorrectly parsed as column names in results view
524212010-03-28
22:31
2022-12-04
20:45
MySQL Server: ParserVerified
(5114 days)
S35.1.32, 5.1.43AnyAnyDECIMAL type given with decimals doesn't return an error.
324322007-11-16
10:55
2012-05-18
20:19
MySQL Server: ParserPatch pending
(5965 days)
S25.1.23AnyAnyALTER TABLE does not accept the ENGINE and PARTITION clauses together
345642008-02-14
19:20
2022-12-04
20:45
MySQL Server: ParserVerified
(5849 days)
S35.1.22-rc-logAnyAnyCAST does not accept varchar type
346292008-02-17
20:35
2022-12-04
20:45
MySQL Server: ParserVerified
(5884 days)
S35.0.45AnyAnyCHANGE MASTER TO doesn't permit quoted values
361402008-04-16
14:00
2022-12-04
20:45
MySQL Server: ParserVerified
(5825 days)
S35.0.60 and upAnyAnyInconsistent synonymy of USING and TYPE for index creation
361612008-04-16
22:44
2018-09-09
20:45
MySQL Server: ParserVerified
(5825 days)
S35.0 and 5.1AnyAnySubquery in FROM clause accepts invalid syntax of LIMIT
362192008-04-20
3:16
2022-12-04
20:45
MySQL Server: ParserVerified
(5643 days)
S35.0.51a.community-ntWindows (Vista 64)AnyCREATE TABLE: wrong error message
366332008-05-09
17:52
2011-02-16
23:43
MySQL Server: ParserVerified
(5801 days)
S35.0 and upAnyAnyMICROSECOND accepted, SQL_TSI_MICROSECOND not accepted
466412009-08-11
0:54
2022-12-04
20:45
MySQL Server: ParserVerified
(5338 days)
S35.1.36/5.4AnyAnyUnclear warning message 'Warning: 1292: Truncated incorrect DOUBLE value: ___'
468332009-08-20
13:20
2022-12-04
20:45
MySQL Server: ParserVerified
(5317 days)
S35.4AnyAnySHOW ENGINE ALL exist in code but are not documented
469682009-08-28
5:14
2022-12-04
20:45
MySQL Server: ParserVerified
(5327 days)
S35.1.39, 6.0.12, next bzrAnyAny'Incorrect information in file' with partitioned table created with ANSI_QUOTES
834752016-10-21
8:17
2016-10-26
9:29
MySQL Server: ParserVerified
(2711 days)
S25.6.32 LinuxAnyfilter in select query works incorrectly
836082016-10-29
10:51
2016-10-29
12:15
MySQL Server: ParserVerified
(2708 days)
S35.5, 5.6, 5.7AnyAnyAssertion `m_cpp_buf <= pt r && ptr <= m_cpp_buf + m_buf_length' failed
839212016-11-22
20:33
2017-01-04
7:22
MySQL Server: ParserVerified
(2641 days)
S35.7.16CentOS (7)Anyfalsely Ambigous Column in On Duplicate Key Update using a subselect
883372017-11-02
17:52
2017-11-03
10:09
MySQL Server: ParserVerified
(2338 days)
S35.5.53-0ubuntu0.14.04.1-logUbuntu (14.04.5)Anymod result differs between hex and decimal values
884502017-11-12
11:09
2017-11-12
13:34
MySQL Server: ParserVerified
(2329 days)
S35.5/5.6/5.7/8.0AnyAnyMultiple DISTINCTs are allowed
813092016-05-04
11:58
2022-09-04
20:45
MySQL Server: ParserIn progress
(2884 days)
S35.7.11AnyAnyKeywords UTC_DATE, UTC_TIME, UTC_TIMESTAMP should be non-reserved
823172016-07-22
7:42
2018-07-18
8:55
MySQL Server: ParserVerified
(2807 days)
S35.5.49Any (v14.04.1)AnyUnrelevant error message: Unknown column in 'having' clause
827352016-08-26
0:32
2016-08-26
8:41
MySQL Server: ParserVerified
(2772 days)
S35.6.31, 5.6.32AnyAnyFractional seconds ignored in view definitions
832562016-10-04
16:17
2016-10-04
16:51
MySQL Server: ParserVerified
(2733 days)
S35.5/5.6/5.7Red Hat (rhel6)Anydate in multi-column IN clause with multi-values clause is parsed incorrectly
985212020-02-08
11:21
2020-02-20
6:29
MySQL Server: ParserVerified
(1501 days)
S38.0.18, 5.7.29, 8.0.19AnyAnyCore client cannot send any query with commentary characters in hints
993432020-04-24
6:03
2021-05-31
8:36
MySQL Server: ParserVerified
(1435 days)
S28.0.19, 5.7.29, 8.0.25AnyAnySelecting with generated column gets the wrong result
993822020-04-28
7:34
2020-04-29
8:13
MySQL Server: ParserVerified
(1430 days)
S15.7, 8.0AnyAnyComplex nested views take up a lot of memory
877262017-09-11
13:44
2017-09-11
22:19
MySQL Server: ParserVerified
(2391 days)
S35.7.7/8.0DebianAnyError 1142 when creating view with subquery without having a default schema
943442019-02-15
11:35
2019-02-18
16:35
MySQL Server: ParserVerified
(1866 days)
S35.7.25AnyAny`SHOW TRIGGERS LIKE` doesn't correctly interpret the underscore symbol (`_`)
732772014-07-11
13:23
2014-07-15
13:55
MySQL Server: ParserVerified
(3545 days)
S35.537-35.1-log, 5.0.97, 5.1.74, 5.5.39, 5.6.21, 5.7.5AnyAnyREGEXP escape of - not escaped properly in character group
735902014-08-14
17:56
2016-04-07
13:54
MySQL Server: ParserVerified
(3514 days)
S35.5.26 5.6.19AnyAnyMySQL returns "ERROR 1046 (3D000): No database selected" when executing "Update
779412015-08-05
3:28
2015-08-05
7:21
MySQL Server: ParserVerified
(3159 days)
S35.7.8AnyAnyHA_CREATE_USED_COMPRESS is defined but not used
783952015-09-10
11:46
2015-09-14
11:53
MySQL Server: ParserVerified
(3122 days)
S35.6.22, 5.1.77, 5.5.46, 5.6.26, 5.7.9AnyAnyGet "Unknown column 'c1' in 'having clause' " when c1 is a valid column
784042015-09-11
9:11
2015-09-11
9:41
MySQL Server: ParserVerified
(3122 days)
S35.6.22, 5.6.26AnyAnysubquery + "select * from...order by 2" (2 cols) fails with unknown column '2'
788792015-10-20
6:23
2022-09-04
20:45
MySQL Server: ParserVerified
(3083 days)
S35.6.23, 5.6.27, 5.5.47LinuxAnyLIKE and '<' should have same precedence according the document.
793502015-11-20
7:44
2015-11-20
11:47
MySQL Server: ParserVerified
(3052 days)
S35.7.9AnyAnyAllow SHOW in the Rewriter plugin
710392013-11-29
14:20
2016-08-11
12:25
MySQL Server: ParserVerifiedS35.7, 5.7.14AnyAnynon-standard usage of table alias allowed in SELECT but not in CREATE VIEW
757002015-01-30
12:40
2015-01-30
17:32
MySQL Server: ParserVerified
(3346 days)
S3mysql Ver 14.14 Distrib 5.1.73Linux (Centos 2.6.32-358.el6.x86_64)AnyCannot create MySQL database with name '5e370227_db'
757772015-02-05
0:47
2015-02-06
15:45
MySQL Server: ParserVerified
(3339 days)
S35.6, 5.6.22AnyAnySELECT FROM DUAL PROCEDURE ANALYSE() returns syntax error
682862013-02-06
5:42
2019-04-13
13:10
MySQL Server: ParserVerified
(4069 days)
S35.1, 5.5(.29), 2.6.7Windows (probably any)AnyCannot change FK constraint settings
683702013-02-13
18:23
2013-02-13
20:07
MySQL Server: ParserVerified
(4062 days)
S35.5AnyAnyENUM with NOT NULL, allows NULL / empty string
686762013-03-14
21:25
2021-08-10
16:42
MySQL Server: ParserVerified
(4028 days)
S35.5.30, 5.0.97, 5.1.70, 5.5.32, 5.6.12, 5.7.2LinuxAnyEscaping backslash in identifier name
686992013-03-18
1:07
2013-03-18
5:20
MySQL Server: ParserVerified
(4029 days)
S35.5.29AnyAnyUnit parsing problem
688322013-04-02
11:04
2013-04-26
13:59
MySQL Server: ParserVerified
(3990 days)
S25.1.70Linux (RHEL6)AnyDaylight Saving time and interval
689022013-04-09
12:16
2013-04-09
17:02
MySQL Server: ParserVerified
(4007 days)
S35.1, 5.5, 5.0.97, 5.1.70, 5.5.32, 5.6.12, 5.7.1AnyAnyDuplicate table aliases
689202013-04-10
16:09
2013-06-03
16:40
MySQL Server: ParserVerified
(4005 days)
S35.5.29AnyAnyInconsistent ordering with column alias in expression
692082013-05-13
5:22
2013-05-20
7:56
MySQL Server: ParserVerified
(3966 days)
S3anyAnyAnyA typo in sql_yacc.yy leads to possibility of creation valid nonsense queries
693742013-06-01
6:49
2014-08-31
5:24
MySQL Server: ParserVerified
(3498 days)
S25.6AnyAnyUser Variable not updating properly in some cases
698362013-07-25
9:30
2013-07-25
13:02
MySQL Server: ParserVerified
(3900 days)
S35.5AnyAnyQuery returns a strange column name (with the comments)
699292013-08-05
18:19
2016-02-25
12:24
MySQL Server: ParserVerifiedS35.6.13AnyAnyRemove support for COM_PROCESS_INFO
805592016-02-29
14:32
2016-02-29
15:17
MySQL Server: ParserVerified
(2951 days)
S35.7.11AnyAnyEXPLAIN CREATE TABLE .. AS SELECT .. does not work
653602012-05-18
14:12
2014-08-21
19:20
MySQL Server: ParserVerified
(4333 days)
S35.1.61, 5.5.23AnyAnyUpdate does not work with double-nested queries without default database
1036652021-05-12
5:48
2021-05-14
6:09
MySQL Server: ParserVerified
(1052 days)
S38.0.23, 5.7.34, 8.0.24AnyAnyThe aliases interferes despite the fact that the database is specified
1050042021-09-22
10:20
2024-02-22
19:27
MySQL Server: ParserVerified
(918 days)
S28.0.26AnyAnymysql 8.0 parser consuming more memory than 5.7 for similar query
1059902021-12-28
8:37
2021-12-28
9:45
MySQL Server: ParserVerified
(822 days)
S28.0/5.6/5.7AnyAnyContribution by Tencent: parse ending of SP error
1127292023-10-15
11:20
2023-10-16
6:13
MySQL Server: ParserVerified
(165 days)
S38.1.0AnyAnyTwo single quotes escaping inconsistency in index expression
1003752020-07-30
6:16
2023-03-10
13:25
MySQL Server: ParserVerified
(1337 days)
S35.7.31, 5.6.48AnyAnyColumn name cannot be parsed inside COS function
1071092022-04-24
9:07
2023-04-14
13:24
MySQL Server: ParserVerified
(662 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
1104882023-03-24
7:52
2023-03-24
9:17
MySQL Server: ParserVerified
(371 days)
S3all, 8.0CentOS (7.x)x86 (64bit)pound sign can not included in qb_name hint
1105622023-03-30
8:05
2023-04-18
21:01
MySQL Server: ParserVerified
(350 days)
S28.0.32Windows (11)x86 (64bit)values statement
1118922023-07-26
6:52
2023-11-13
10:14
MySQL Server: ParserVerified
(246 days)
S38.1AnyAnyTwo single quotes escaping inconsistency
1138872024-02-04
2:12
2024-02-05
13:07
MySQL Server: ParserVerified
(53 days)
S38.0AnyAnyMySQL fails to execute query if a subquery refer to a column of parent table
1139492024-02-09
19:55
2024-02-12
9:16
MySQL Server: ParserVerified
(46 days)
S38.3.0, 8.0.36AnyAnyBackslash escaping inconsistency in LIKE operator
1137262024-01-23
14:31
2024-01-23
15:16
MySQL Server: PackagingVerified
(66 days)
S38.4.0AnyAnyContribution: Add support for specifying a .cnf file and a linux user
1129492023-11-03
7:25
2023-12-15
14:46
MySQL Server: PackagingVerified
(105 days)
S38.2.0AnyAny (RHEL rpms)missing mysql-community-libs-compat rpms for 8.2.0
1012332020-10-19
19:06
2020-10-20
6:33
MySQL Server: PackagingVerified
(1256 days)
S38.0DebianARMDebian APT repository missing aarch64/arm64 packages
941542019-01-31
15:14
2019-04-15
11:18
MySQL Server: PackagingVerified
(1884 days)
S3AnyAnyContribution: Updated mysqld_multi script to be able to pass custom paramet ...
961672019-07-11
2:50
2019-07-11
5:39
MySQL Server: PackagingVerified
(1723 days)
S38.0AnyAnyMany header files now missing from devel package
857782017-04-04
11:39
2017-04-07
12:07
MySQL Server: PackagingVerified
(2548 days)
S25.6+Ubuntu (ver 14.04)AnyCustom apparmor profile not correctly replaced if user agrees to replace cnf
977682019-11-25
9:16
2021-12-10
9:21
MySQL Server: PackagingVerified
(1585 days)
S28.0.18Ubuntu (18.04.3)x86Adding 2 apparmor rules for mysql from apt repo for using huge page not failed
591602010-12-24
16:29
2012-06-10
20:45
MySQL Server: PackagingVerified
(4844 days)
S3WindowsAnypackages - src suffix used in an incoherent way
615842011-06-21
11:54
2012-06-10
20:45
MySQL Server: PackagingVerified
(4665 days)
S35.5.13Windows (XP SP2 JP)Anyinstalling server only will still setup shortcut for cmdline client
709852013-11-23
8:24
2013-12-05
13:35
MySQL Server: PackagingVerified
(3769 days)
S35.6.14AnyAnymysql-community-server should not depend on mysql-community-client
776462015-07-08
0:27
2016-10-14
12:02
MySQL Server: PackagingVerified
(3187 days)
S3AnyAnySUSE patches we keep against 5.6 (contribution)
777032015-07-13
15:49
2015-07-14
4:11
MySQL Server: PackagingVerified
(3181 days)
S3AnyAnyUpdate README (contribution)
799962016-01-15
1:16
2016-01-15
6:03
MySQL Server: PackagingVerified
(2996 days)
S3AllAnyAnySuggest to add a "--numanode" option to mysqld_safe scripts
746512014-10-31
15:19
2016-05-20
8:31
MySQL Server: PackagingVerified
(3432 days)
S35.6/5.7Linux (CentOS 6)Anymysql-community rpms uninstall followed by reinstall changes /etc/my.cnf
760422015-02-25
8:45
2015-02-25
15:46
MySQL Server: PackagingVerified
(3320 days)
S35.6.23Linux (OL6.4)Anymysqld_multi.server was not included in Package mysql-community-server.rpm
747292014-11-07
10:19
2014-11-07
10:46
MySQL Server: OptionsVerified
(3430 days)
S35.6.20-debug, 5.6.22, 5.7.6Linux (CentOS 7)Anyassertion:mode == BUF_GET_POSSIBLY_FREED || !fix_block->page.file_page_was_freed
747302014-11-07
10:23
2017-08-13
23:25
MySQL Server: OptionsVerified
(3430 days)
S35.6.20-debug, 5.6.22, 5.7.6Linux (CentOS 7)AnyAssertion failure in fil0fil.cc line 5594 | abort sig 6 in fil/fil0fil.cc:5594
747322014-11-07
12:13
2015-04-08
7:17
MySQL Server: OptionsVerified
(3430 days)
S35.6.21Windows (W7)Anyinit_file use in windows needs ";" terminator
748712014-11-14
18:45
2014-11-15
5:50
MySQL Server: OptionsVerified
(3422 days)
S35.5.40, 5.5.42, 5.6.23LinuxAnymax_seeks_for_key default value is invalid when used in cnf
752862014-12-22
12:23
2014-12-22
14:56
MySQL Server: OptionsVerified
(3385 days)
S35.7.5, 5.6.22AnyAnyserver accepts garbage port
762702015-03-11
22:56
2016-06-18
21:24
MySQL Server: OptionsVerified
(3305 days)
S35.7.6, 8.0.0AnyAnyConsider improving startup mysql startup NO_AUTO_CREATE_USER warning message
710812013-12-04
23:50
2016-02-25
12:24
MySQL Server: OptionsVerifiedS35.7.3AnyAnyNeed status variable for COM_RESET_CONNECTION
711942013-12-20
20:33
2013-12-24
13:53
MySQL Server: OptionsVerified
(3752 days)
S35.5.35, 5.6.16LinuxAnymysqld daemon should check if any process uses the socket file before removing
713092014-01-06
22:44
2015-01-28
23:04
MySQL Server: OptionsVerified
(3734 days)
S35.6.14-enterprise-commercial-advanced-log, 5.6.15Linux (Red Hat Enterprise Linux Server release 5.6 (Tikanga))AnyNot able to customize mysql prompt with new line and tab options
713672014-01-14
2:01
2014-01-14
6:03
MySQL Server: OptionsVerified
(3727 days)
S35.6AnyAnyspeficied is not a word, though it sounds cool
714772014-01-25
12:10
2014-01-27
15:11
MySQL Server: OptionsVerified
(3714 days)
S35.6.15AnyAnytransaction_allow_batching is available in non-Cluster MySQL Server 5.6
714792014-01-25
15:32
2014-01-30
14:23
MySQL Server: OptionsVerified
(3714 days)
S35.6Windows (Win64)Anysort_buffer_size is limited to 4GB-1 on 64-bit Windows
716022014-02-06
9:10
2017-08-23
10:47
MySQL Server: OptionsVerified
(3703 days)
S35.6.15AnyAnyUnexpected option file read from basedir
718522014-02-27
6:34
2015-04-18
22:06
MySQL Server: OptionsVerified
(3677 days)
S35.6.16, 5.6.17LinuxAnyULONG_MAX capable sys vars could not set in my.cnf
718532014-02-27
6:37
2014-03-05
12:01
MySQL Server: OptionsVerified
(3677 days)
S35.6.16, 5.6.17LinuxAnyeval_num_suffix return overflowed/underflowed value
719602014-03-06
23:57
2017-12-23
10:39
MySQL Server: OptionsVerified
(3269 days)
S15.6.16, 5.6.20MacOS (10.8)AnyMysql 5.6.16 on OSX throws connection errors with innodb_file_per_table option
720192014-03-12
12:13
2014-03-31
14:21
MySQL Server: OptionsVerified
(3651 days)
S3anyAnyAnyIs my server 32 bit or 64 bit?
724292014-04-23
8:30
2014-04-28
6:32
MySQL Server: OptionsVerified
(3625 days)
S35.5 , 5.6Any (options ignored, option handling intransparent )Anyhandling of options, expire logs
725832014-05-08
18:32
2014-05-08
19:03
MySQL Server: OptionsVerified
(3613 days)
S35.6.17AnyAnySQL Mode shows deprecated settings even when not used
725872014-05-09
1:40
2014-05-09
11:12
MySQL Server: OptionsVerified
(3612 days)
S3MySQL 5.6.17AnyAnyinnodb-buffer-pool-instances gives a warning when set to -1
726262014-05-13
2:34
2014-05-13
6:47
MySQL Server: OptionsVerified
(3608 days)
S35.6.17, 5.6.19AnyAnyinnodb_open_files gives a warning when set to -1
731192014-06-25
20:38
2014-06-26
7:14
MySQL Server: OptionsVerified
(3564 days)
S35.5.36, 5.5.38AnyAnycreate temporary table ... select fails on read-only slave
734352014-07-30
12:27
2014-07-30
12:33
MySQL Server: OptionsVerifiedS35.6.21AnyAnyinnodb_api_enable_binlog is not recognized when used on the mysqld command line
742112014-10-03
11:29
2024-02-06
9:33
MySQL Server: OptionsVerified
(52 days)
S35.6.14, 5.7, 8.0AnyAnyNo upgrade path for explicit_defaults_for_timestamp = 1
742282014-10-05
13:22
2014-10-07
11:13
MySQL Server: OptionsVerified
(3462 days)
S35.5, 5.6AnyAnyDescription of autoincrement behavior if offset > increment needs clarification
742462014-10-07
8:04
2014-10-07
9:11
MySQL Server: OptionsVerified
(3461 days)
S35.7, 5.6.22, 5.7.6AnyAnySET: Semantic behavior different for regular execution and function
744822014-10-21
12:42
2014-10-25
8:44
MySQL Server: OptionsVerified
(3447 days)
S35.5.38LinuxAnyA # character cannot be represented in MySQL .ini files
745512014-10-24
15:11
2014-10-25
17:21
MySQL Server: OptionsVerified
(3443 days)
S35.6.21LinuxAnyDots in file names of configuration files
634522011-11-28
5:59
2011-12-05
8:19
MySQL Server: OptionsVerified
(4505 days)
S35.5.18AnyAnyShow currently used my.ini/mycnf directory location
636852011-12-08
21:38
2017-01-05
14:54
MySQL Server: OptionsVerified
(4494 days)
S35.5.19Any (Mac OS X, Vista 32-bit Home Premium)AnyMySQL does not recognize timezone offset UTC +14:00
637182011-12-11
18:45
2011-12-14
10:30
MySQL Server: OptionsVerified
(4491 days)
S35.1.41, 5.1.61AnyAnyUnable to increase ft_max_word_len variable
639892012-01-11
8:41
2012-01-19
12:06
MySQL Server: OptionsVerified
(4461 days)
S35.5LinuxAnyinnodb_buffer_pool_size with 128M default is too large
642432012-02-06
19:18
2012-02-09
12:08
MySQL Server: OptionsVerified
(4435 days)
S2anyAnyAnyDatabase where log tables are written should be configurable
643472012-02-16
6:01
2012-02-16
16:35
MySQL Server: OptionsVerified
(4425 days)
S35.1.52, 5.1.62, 5.5.22AnyAnylower_case_table_names and my_database_names_init
646662012-03-15
23:47
2012-03-20
7:44
MySQL Server: OptionsVerified
(4396 days)
S25.1,5.5,5.6AnyAnyMySQL discards fractional part of the default values of system
651222012-04-26
19:08
2012-04-26
19:49
MySQL Server: OptionsVerified
(4355 days)
S15.5.24AnyAnyFix for ipv4/ipv6 hostnames is incorrect
653332012-05-16
13:03
2012-05-21
11:28
MySQL Server: OptionsVerified
(4334 days)
S35.xAnyAnyoption --safe-user-create and sql_mode NO_AUTO_CREATE_USER should be dependent
653432012-05-16
20:13
2012-05-21
11:31
MySQL Server: OptionsVerified
(4334 days)
S3anyAnyAnyPlease expose --skip-grant-tables as a variable
657112012-06-22
13:30
2012-06-25
6:24
MySQL Server: OptionsVerified
(4298 days)
S35.5.25, 5.5.26, 5.6.5AnyAnyServer crashes in intern_plugin_lock on concurrent install plugin / set variable
657322012-06-26
8:43
2012-07-05
14:56
MySQL Server: OptionsVerified
(4285 days)
S3AnyAnySession variable late value acessment
668842012-09-20
3:16
2017-01-09
18:04
MySQL Server: OptionsVerified
(4077 days)
S35.5, 5.0.97, 5.1.69, 5.5.31, 5.7.1Linux (I only test it on ubuntu 11.10)AnySERVER_STATUS is always inited with SERVER_STATUS_AUTOCOMMIT=1
668932012-09-20
14:34
2013-01-31
11:12
MySQL Server: OptionsVerified
(4208 days)
S35.5+WindowsAnyMinimum value for table-open-cache
674222012-10-30
13:50
2015-01-07
19:03
MySQL Server: OptionsVerifiedS35.5.28LinuxAnymysqld fails to switch DNS resolver if thread_cache_size > 0
795092015-12-03
14:33
2018-01-03
19:56
MySQL Server: OptionsVerified
(3039 days)
S35.7.10, 5.7.18, 5.7.20AnyAnyBad tls_version values are not rejected
795582015-12-08
16:29
2018-01-03
13:50
MySQL Server: OptionsVerified
(2814 days)
S25.7.10AnyAnytls_version accepts invalid arguments
796082015-12-11
18:36
2015-12-13
14:28
MySQL Server: OptionsVerified
(3029 days)
S35.1+, 5.7.10AnyAnymysqld_safe mishandles UMASK
803122016-02-09
8:14
2016-02-09
8:23
MySQL Server: OptionsVerified
(2971 days)
S35.7.11CentOS (6.6)Anymaximum_query_cache_size cannot be set
804192016-02-18
0:38
2016-02-18
8:04
MySQL Server: OptionsVerified
(2962 days)
S3AnyAnythr_lock: Only set stack size when stack size is < 64k (contribution)
806682016-03-09
7:27
2016-03-16
2:56
MySQL Server: OptionsVerified
(2936 days)
S35.7.10, 5.7.11CentOSAnyInnoDB: Failing assertion: !m_fatal in in file ut0ut.cc line 938
806902016-03-10
14:50
2016-03-14
8:30
MySQL Server: OptionsVerifiedS35.6.27WindowsAny!include directive is ignored in my.cnf if it is last line in file
809492016-04-04
20:41
2016-04-05
8:20
MySQL Server: OptionsVerified
(2915 days)
S35.7. 5.7.11, 5.6.29AnyAnyWhen setting a boolean variable values less than 0 are allowed
811302016-04-18
15:46
2016-04-18
19:48
MySQL Server: OptionsVerified
(2902 days)
S35.7.12AnyAnymaster_info_file is not listed in 'show global variables';
774362015-06-22
14:55
2015-06-23
10:44
MySQL Server: OptionsVerified
(3202 days)
S25.6.23, 5.6.26LinuxAnyprocs_priv table not restored with sql_mode traditional and only_full_group_by
777812015-07-19
20:35
2015-07-20
18:47
MySQL Server: OptionsVerified
(3175 days)
S35.6AnyAnyNo alternative for max_long_data_size in 5.6
779762015-08-07
9:08
2017-09-22
14:37
MySQL Server: OptionsVerified
(2380 days)
S35.6.23, 5.6.26, 5.6.37CentOS (CentOS 7)AnyInnoDB: Failing assertion: event in file os0sync.cc line 419
782382015-08-27
5:09
2016-11-24
12:11
MySQL Server: OptionsVerified
(3128 days)
S15.6, 5.7.8 (RC2), 5.7.9AnyAny--query-alloc-block-size issues with numerous different crash examples
689632013-04-15
17:23
2018-12-10
9:50
MySQL Server: OptionsVerified
(4000 days)
S35.6.10 and earlierAnyAnySHOW GLOBAL STATUS Threads_running may be misleading
692262013-05-14
10:31
2018-02-06
13:52
MySQL Server: OptionsVerified
(2243 days)
S35.6.11,5.7.21,8.0.4AnyAnyStatus variable for SSL/TLS implementation
692442013-05-15
13:28
2013-05-16
4:50
MySQL Server: OptionsVerified
(3970 days)
S35.6.11AnyAnyDocumentation and code inconsistent wrt. back_log
692952013-05-21
16:22
2013-05-22
9:04
MySQL Server: OptionsVerified
(3964 days)
S35.1.44, 5.6.10AnyAnySlow_queries status variable incremented when it should not
693142013-05-24
21:33
2013-05-25
7:57
MySQL Server: OptionsVerified
(3961 days)
S35.7.1AnyAnyignore-db-dir option doesn't work for databases with an * in the name
695152013-06-19
14:55
2013-06-19
15:11
MySQL Server: OptionsVerified
(3936 days)
S35.1, 5.5, 5.6, 5.7AnyAnygroup_concat_max_len >= 4Gb does not work
696822013-07-05
22:12
2013-07-11
16:59
MySQL Server: OptionsVerified
(3914 days)
S35.6.12AnyAnymysqld crashes after uninstall of plugin with "first" status var
697042013-07-09
23:26
2013-07-10
5:36
MySQL Server: OptionsVerified
(3915 days)
S35.5.32, 5.6.12AnyAnyStrangeness with max_binlog_stmt_cache_size Settings
699762013-08-09
19:44
2015-06-05
7:07
MySQL Server: OptionsVerified
(3363 days)
S35.6.13AnyAnyNo deprecation warning on innodb_stats_sample_pages
699972013-08-12
15:19
2013-08-15
22:49
MySQL Server: OptionsVerified
(3879 days)
S3any.AnyAnyPlease expose skip-character-set-client-handshake as a variable
700082013-08-13
5:35
2018-05-23
6:26
MySQL Server: OptionsVerified
(3769 days)
S3all (up to 5.7.1)Any (n/a)Anyuse tx_isolation for startup/my.cnf parameter settings for consistency
700362013-08-14
17:22
2014-06-06
13:29
MySQL Server: OptionsVerified
(3584 days)
S35.6.13MacOS (10.6)Anycharacter-set-client option ignored in my.cnf
983322020-01-23
7:12
2021-01-16
0:52
MySQL Server: OptionsVerified
(1526 days)
S38.0.19AnyAnypartial_revokes=1 disables wildcard database grants
991872020-04-06
7:14
2020-04-06
7:28
MySQL Server: OptionsVerified
(1453 days)
S38.0.19AnyAnyPLUGIN_VAR_OPCMDARG is more better for innodb_dedicated_server
814422016-05-16
22:12
2018-01-24
16:08
MySQL Server: OptionsVerified
(2256 days)
S35.7.12,5.7.15,8.0.0,8.0.4-rcAnyAnyUnable to analyze table whilst super_read_only is enabled
816492016-05-30
23:33
2016-05-31
11:55
MySQL Server: OptionsVerified
(2859 days)
S25.7.12AnyAny[ERROR] Can't create interrupt-thread (error 11, errno: 12)
816902016-06-02
13:55
2017-06-12
16:27
MySQL Server: OptionsVerified
(2856 days)
S35.7.12AnyAnyexecuting prepared statements increases com_stmt_execute but also com_select
822372016-07-15
3:15
2016-07-15
5:54
MySQL Server: OptionsVerified
(2814 days)
S15.7.13, 5.6.31AnyAnyOPTIMIZER_SWITCH cannot be modified once a different collation is selected
824142016-08-02
16:01
2016-08-02
16:21
MySQL Server: OptionsVerified
(2796 days)
S35.7, 5.7.14AnyAnyIncorrect charset in INFORMATION_SCHEMA
825772016-08-14
11:43
2016-08-15
5:58
MySQL Server: OptionsVerified
(2783 days)
S3AnyAnylet variables in my.cnf specify percent of ram
840022016-11-29
9:33
2016-12-02
13:52
MySQL Server: OptionsVerified
(2674 days)
S35.7, 5.6.34, 5.7.16AnyAnyCannot override skip-name-resolve in my.cnf
840812016-12-06
18:38
2021-11-09
15:27
MySQL Server: OptionsVerified
(2667 days)
S35.7.14, 5.7.16UbuntuAnysuper_read_only and read_only not allowing OPTIMIZE TABLE on 5.7
840852016-12-07
2:30
2016-12-09
6:54
MySQL Server: OptionsVerified
(2667 days)
S35.7, 5.7.16LinuxAnyinconsistent states for system variables after PL routine finished
850172017-02-16
10:22
2017-02-16
12:14
MySQL Server: OptionsVerified
(2598 days)
S35.7AnyAnyShouldn't'delayed_insert_timeout' variable be removed?
852972017-03-03
17:04
2017-03-03
17:05
MySQL Server: OptionsVerifiedS35.7+AnyAnyunreachable code in check_track_session_sys_vars
880702017-10-12
7:17
2017-10-16
12:04
MySQL Server: OptionsVerified
(2356 days)
S38.0.3AnyAnyToo limited compatibility options for transaction isolation
883822017-11-07
9:13
2017-11-07
13:09
MySQL Server: OptionsVerified
(2334 days)
S38.0.3AnyAnyPersisted configuration in mysqld-auto.cnf is not reflected in mysqld output
896732018-02-14
17:57
2018-02-15
6:54
MySQL Server: OptionsVerified
(2234 days)
S35.7, 5.7.9, 5.7.21LinuxAnyDefault values showed by "--verbose --help" doesn't match with the documentation
897412018-02-21
4:55
2018-02-21
8:03
MySQL Server: OptionsVerified
(2228 days)
S35.6.39, 5.5.59AnyAnyEvents log Note level messages even for log_warnings=0
902082018-03-24
14:59
2018-03-27
6:19
MySQL Server: OptionsVerified
(2194 days)
S25.7.20, 5.7.21, 5.6.39AnyAnyoption 'default(_tmp)_storage_engine' does not work as expected
903942018-04-11
19:57
2018-04-12
12:21
MySQL Server: OptionsVerified
(2178 days)
S35.7.21AnyAnySSL session cache: hits/misses wrong and size hardcoded
857992017-04-05
8:32
2017-04-05
12:50
MySQL Server: OptionsVerified
(2550 days)
S35.7.1, 5.6.35, 5.7.17CentOSAnyvariable --master-info-file
859402017-04-13
22:16
2017-05-07
1:17
MySQL Server: OptionsVerified
(2518 days)
S35.6.36DebianAnyMySQL 5.6.36 changes default sql_mode
876572017-09-04
12:56
2017-09-05
14:13
MySQL Server: OptionsVerified
(2397 days)
S35.7AnyAnyTrailing # comment on !includedir / !include directive causes error
909392018-05-19
3:43
2018-05-21
6:07
MySQL Server: OptionsVerified
(2139 days)
S35.6.39, 5.6.40AnyAnyERROR 1238 (HY000): Variable 'explicit_defaults_for_timestamp' is a read only va
909432018-05-20
14:42
2018-05-20
15:53
MySQL Server: OptionsVerified
(2140 days)
S35.7/8.0AnyAnyBuffer pool size adjustment can cause crashes on small instance sizes
918872018-08-03
10:29
2018-08-03
12:37
MySQL Server: OptionsVerified
(2065 days)
S35.7.22, 8.0.13AnyAnyRedundant code around mysql_real_data_home_ptr in rpl_make_log_name()
920322018-08-15
23:07
2018-10-02
12:03
MySQL Server: OptionsVerified
(2051 days)
S3AnyAnyRestrict usage of session foreign_key_checks
923912018-09-12
15:55
2018-09-13
6:56
MySQL Server: OptionsVerified
(2024 days)
S35.6.40 5.7.6, 5.6.41Red HatAnyread_only=1, non super user Create temporary as select from temp fails
929582018-10-26
9:21
2018-11-20
14:30
MySQL Server: OptionsVerified
(1960 days)
S35.7.22Debianx86Event Creation not respecting SQL_MODE settings
938512019-01-08
12:15
2019-01-09
7:57
MySQL Server: OptionsVerified
(1906 days)
S35.7, not 8.0AnyAnyBuffer underflow in fix_paths
944872019-02-27
8:17
2019-02-27
17:19
MySQL Server: OptionsVerified
(1857 days)
S38.0, 5.6, 5.7AnyAnyWrong default value for max_binlog_cache_size
952612019-05-06
14:04
2019-06-14
12:33
MySQL Server: OptionsVerified
(1788 days)
S38.0.15, 8.0.16AnyAnyinnodb_undo_log_encrypt and innodb_redo_log_encrypt do not emit client warnings
959852019-06-25
21:42
2019-06-25
22:31
MySQL Server: OptionsVerified
(1739 days)
S35.7/8.0Ubuntux86SET GLOBAL on rbr_exec_mode fails
959872019-06-25
23:21
2019-06-26
5:59
MySQL Server: OptionsVerified
(1738 days)
S38.0.16, 5.7.26, 5.6.44Ubuntux86SET key_cache_* and key_buffer_* variables fails nondeterministically
1002832020-07-22
7:40
2020-07-22
10:19
MySQL Server: OptionsVerified
(1346 days)
S25.7, 5.7.31LinuxAnySuper_read_only prevents myisam_recover_options from working
1012042020-10-16
10:12
2021-08-04
7:15
MySQL Server: OptionsVerified
(1260 days)
S28.0AnyAnyinnodb_dedicated_server sets incorrect number of log files if RAM < 2GB
1012382020-10-20
10:22
2020-10-20
11:14
MySQL Server: OptionsVerified
(1256 days)
S38.0.21, 5.7.31AnyAnytable_open_cache adjustment doesn't kick in when changed dynamically
1014692020-11-05
4:53
2020-11-05
10:38
MySQL Server: OptionsVerified
(1240 days)
S38.0.21, 8.0.22, 5.7.32AnyAnyskip_name_resolve does not take effect
1020052020-12-16
6:50
2020-12-16
7:51
MySQL Server: OptionsVerified
(1199 days)
S38.0.22, 5.7, 5.7.32AnyAnySession tracker not reset itself when error affect next statement
1139782024-02-13
18:38
2024-02-14
9:25
MySQL Server: OptionsVerified
(44 days)
S38.0.35, 8.0.36AnyAnySet admin_port in port being used does not throw error
1023272021-01-21
7:45
2021-01-21
9:34
MySQL Server: OptionsVerified
(1163 days)
S38.0.23AnyAnyPossible memory leaks in mysqld
1023282021-01-21
8:58
2021-01-21
9:54
MySQL Server: OptionsVerified
(1163 days)
S35.6, 5.7, 8.0, 5.7.33, 8.0.23AnyAnyRange of innodb_ft_sort_pll_degree error
1040662021-06-21
7:00
2023-11-24
13:22
MySQL Server: OptionsVerified
(1012 days)
S38.0.23, 8.0.25LinuxAnyInconsistency of description for default_collation_for_utf8mb4
1050162021-09-23
9:03
2021-09-23
13:24
MySQL Server: OptionsVerified
(918 days)
S38.0.25, 8.0.26, 5.7.35LinuxAnycreate user with max_user_connections ,it save as Unexpected data
1054422021-11-03
13:05
2021-11-03
14:19
MySQL Server: OptionsVerified
(877 days)
S35.7AnyAnyContribution: Fix memory leak when host_cache_size is 0.
1055702021-11-15
8:53
2021-11-15
9:01
MySQL Server: OptionsVerified
(865 days)
S28.0.25, 8.0.27, 5.7.36AnyAnyDynamic setting variable innodb_buffer_pool_load_abort cannot take effect
1059332021-12-19
8:11
2021-12-21
8:04
MySQL Server: OptionsVerified
(829 days)
S35.7.35, 8.0.27LinuxAnyThe table "general_log" not close when config option general_log set into OFF
1059572021-12-22
7:44
2021-12-22
8:01
MySQL Server: OptionsVerified
(828 days)
S35.7.35, 8.0.27LinuxAnyThe table "slow_log" not close when config option slow_query_log set into OFF
1059642021-12-23
1:43
2021-12-23
5:06
MySQL Server: OptionsVerified
(827 days)
S35.7.35, 8.0.27LinuxAnyThe table "general_log/slow_log" not close when config log_output set into NONE
1061222022-01-10
8:25
2022-01-12
9:54
MySQL Server: OptionsVerified
(809 days)
S35.7.36AnyAny[Tencent]session track of collation_connection missing character_set_connectioB
1127982023-10-23
7:02
2023-10-23
7:44
MySQL Server: OptionsVerified
(158 days)
S28.1, 8.0.34LinuxAnyThe configuration value of innodb_buffer_pool_size underflow
1104902023-03-24
11:08
2023-03-27
5:13
MySQL Server: OptionsVerified
(371 days)
S3Ver 8.0AnyAnyadd a option to get the malloc lib infomation of MySQL server use
1110622023-05-17
18:49
2023-05-22
12:39
MySQL Server: OptionsVerified
(315 days)
S38.0.33MacOSARMCannot disable TLS in MySQL 8.0.33
1111432023-05-24
15:11
2023-05-26
7:56
MySQL Server: OptionsVerified
(308 days)
S38.0.33, 5.7.42MacOSARMQuoting of ints
1065912022-02-28
4:10
2022-02-28
7:06
MySQL Server: OptionsVerified
(760 days)
S58.0AnyAnynet_set_read_timeout、net_set_write_timeout value set
1071152022-04-25
3:47
2023-05-24
10:25
MySQL Server: OptionsVerified
(704 days)
S28.0.27, 8.0.28, 8.0.33AnyAny??at the end of the error mecessage after setting Chinese characters to variable
579722010-11-04
11:21
2011-02-16
23:44
MySQL Server: OptionsVerified
(4894 days)
S35.5.8,5.6.1-m4,5.6.99-m5AnyAnymysqld --help --verbose does not always list all optimizer_switch flags
581062010-11-10
10:24
2011-02-16
23:44
MySQL Server: OptionsVerified
(4888 days)
S35.1-bugteamAnyAnyWrong directory info in general_log_file/slow_query_log_file.
581142010-11-10
13:55
2011-02-16
23:44
MySQL Server: OptionsVerified
(4853 days)
S35.5AnyAnyNULL value in a system variable is not displayed as such in SHOW VARIABLES/I_S
593252011-01-06
10:06
2014-10-10
7:30
MySQL Server: OptionsVerified
(4112 days)
S35.5.8 GAWindows (WS 2008 Std SP2 x86 32-bit)AnyOpenSSL generated key/certificate required for SSL/TLS connections
594412011-01-12
10:42
2012-05-18
20:19
MySQL Server: OptionsVerified
(4810 days)
S3anyAnyAnyNo information in GLOBAL 'character_set_database' variable
600182011-02-08
19:13
2011-02-16
23:44
MySQL Server: OptionsVerifiedS34.1 and aboveAnyAnyReport deprecated options in error log (some old options are missing)
601132011-02-11
11:53
2011-03-02
18:27
MySQL Server: OptionsVerified
(4780 days)
S35.6.2AnyAnyplugin names are conflicting with system variable names
605382011-03-18
20:29
2011-03-19
8:50
MySQL Server: OptionsVerified
(4759 days)
S35.1.55, 5.1.57AnyAnyMySQL fails to start when max_connect_errors is set to 18446744073709547520
607032011-03-31
7:26
2015-11-19
16:59
MySQL Server: OptionsVerified
(4658 days)
S2MySQL Community 5.5.9Windows (Windows Server 2003 Standard Edition)Any" --verbose --help" seems don't read the options in service name based group
611302011-05-11
4:32
2012-01-17
20:01
MySQL Server: OptionsVerified
(4455 days)
S35.0.77, 5.0.95, 5.1.62, 5.5.21, 5.6.5Linux (CenOS 5.5)AnyKey_blocks_not_flushed values is not correct!
622242011-08-22
8:00
2015-08-06
19:12
MySQL Server: OptionsVerified
(4602 days)
S35.5.13, 5.6.3, 5.1.60AnyAnySetting open-files-limit above the hard limit won't be logged in errorlog
625452011-09-26
22:44
2011-09-27
11:49
MySQL Server: OptionsVerified
(4567 days)
S35.5AnyAnymy_atof and getopt_double callers pass bogus end of string offsets
627522011-10-15
17:32
2014-07-31
13:29
MySQL Server: OptionsVerified
(4520 days)
S35.5.16, 5.1.60Linux (CentOS 5.7 x86_64)Anymysqld --verbose --help ends with error
433982009-03-05
4:45
2016-10-16
20:45
MySQL Server: OptionsVerified
(5502 days)
S34.1, 5.0, 5,1, 6.0 bzrAnyAnymysqld in --bootstrap mode still initialises its binlog
435232009-03-10
2:01
2011-02-16
23:43
MySQL Server: OptionsVerified
(5498 days)
S35.0.51, 5.1.32Linux (Possibly more)AnyOpen_files status variable does not report all opened file descriptors by the OS
445092009-04-28
9:15
2011-10-28
3:21
MySQL Server: OptionsVerified
(5448 days)
S3>= 5.0AnyAnyInconsistent use of ON/OFF variable values in my.cnf vs SHOW GLOBAL VARIABLES
534942010-05-07
15:32
2011-02-16
23:44
MySQL Server: OptionsVerified
(5056 days)
S35.1AnyAnyUpdate docs for Queries and Questions in SHOW STATUS
552882010-07-15
14:35
2011-02-16
23:44
MySQL Server: OptionsVerified
(5001 days)
S35.1+AnyAnyUse of the underscore or hyphen for variables and options is confusing
558932010-08-10
20:08
2018-09-09
20:45
MySQL Server: OptionsVerified
(4980 days)
S3mysql-next-mr-opt-backportingAnyAnyoptimizer_switch should report which variable it can not process
562642010-08-25
17:41
2011-02-16
23:44
MySQL Server: OptionsVerified
(4964 days)
S35.1.47, 5.1.51-bzrLinuxAnyCommand-line options are case-sensitive but don't throw errors
571122010-09-29
18:16
2011-02-16
23:44
MySQL Server: OptionsVerified
(4929 days)
S35.1.49, 5.6.99AnyAnyIncorrect option parsing code in my_getopt.c
572202010-10-04
15:00
2011-02-16
23:44
MySQL Server: OptionsVerified
(4924 days)
S25.1.48AnyAnySET SESSION @sql_log_off should not require SUPER privilege
200402006-05-24
10:46
2017-01-12
15:32
MySQL Server: OptionsVerified
(6239 days)
S35.1-bk, 5.0.38Any (*)AnySSL connections do not affect SSL statistics in STATUS output
202632006-06-05
2:35
2011-02-16
23:43
MySQL Server: OptionsVerified
(5930 days)
S35.0.22AnyAnymysql.cnf line break incompatibility
219782006-09-01
22:13
2011-02-16
23:43
MySQL Server: OptionsVerified
(5959 days)
S34.0.18, 5.0, 6.0.10, 5.5Windows (Windows 2000)Any'flush_time' value set for 1800 sec. on Non Win9x/Me installs by default
247582006-12-01
18:08
2012-05-18
20:19
MySQL Server: OptionsVerified
(5959 days)
S35.0.27, 4.1 BK, 5.1 BKLinux (Fedora Core6)Anymax_user_connections=0 doesn't work had to set a value to make it work
251532006-12-18
17:35
2013-03-03
20:45
MySQL Server: OptionsVerified
(6310 days)
S35.0,5.1Linux (SUSE 10.0 / 64-bit)Anymysqld --skip-engine option
257482007-01-22
11:14
2018-09-09
20:45
MySQL Server: OptionsVerified
(5959 days)
S35.0.32-33/5.1.14/5.2.0Windows (windows)Anymy.ini (Windows) file demands Unix file syntax for SSL parameters
298542007-07-17
19:05
2018-09-09
20:45
MySQL Server: OptionsVerified
(5959 days)
S35.1.19, 5.1 BKAnyAnymysqld --help --verbose retuns [ERROR] instead of printing help
311062007-09-20
11:17
2022-12-04
20:45
MySQL Server: OptionsVerified
(6035 days)
S35.1.20AnyAnyerrors whenn running "mysqld --help" before "mysql_install_db"
415842008-12-18
10:20
2018-09-09
20:45
MySQL Server: OptionsVerified
(5580 days)
S3Ver 5.1.31-debugLinux (suse-linux on x86_64)AnyInconsistent behaviour when comparing system variable "timestamp".
423052009-01-23
14:53
2011-02-16
23:43
MySQL Server: OptionsVerified
(5544 days)
S35.1/6.0AnyAnyIt is not possible to list existing key caches
475132009-09-22
10:16
2011-02-16
23:44
MySQL Server: OptionsVerified
(5302 days)
S36.0.14AnyAnyTest main.merge_recover fails
491712009-11-27
20:02
2022-12-04
20:45
MySQL Server: OptionsVerified
(5233 days)
S35.1AnyAnyread_buffer_size is only partially dynamic variable
497782009-12-17
19:02
2011-02-16
23:44
MySQL Server: OptionsVerifiedS35.1WindowsAnyMix of forward (/) and backward (\) slashes in show variables paths
501302010-01-07
9:24
2019-05-16
7:48
MySQL Server: OptionsVerified
(5195 days)
S35.0+AnyAny--sysdate-is-now sets no system variable
503302010-01-14
13:47
2022-12-04
20:45
MySQL Server: OptionsVerified
(5187 days)
S35.5.99-m3 (Celosia)Any (32 bit)Anysys_vars.sql_select_limit_basic fails on 32 bit OS without big tables support
503782010-01-15
17:34
2022-12-04
20:45
MySQL Server: OptionsVerified
(5184 days)
S25.0.77, 5.0, 5.1 bzrLinux (RHEL 5.4)AnyUptime_since_flush_status has an abnormally large value
504252010-01-18
17:42
2011-02-16
23:44
MySQL Server: OptionsVerified
(5184 days)
S35.5.1-m2-communityAnyAnyBetter defaults (key buffer, thread_cache_size)
506412010-01-26
21:07
2013-03-03
20:45
MySQL Server: OptionsVerified
(5176 days)
S35.1.41AnyAnysetting innodb_adaptive_hash_index = ON actually disables it
518202010-03-08
9:12
2011-02-16
23:44
MySQL Server: OptionsVerified
(5135 days)
S35.0, 5.1, 5.5-m3, 6.0-codebaseAnyAnyError log is automatically named after the PID file's name
518342010-03-08
15:56
2022-12-04
20:45
MySQL Server: OptionsVerified
(5134 days)
S35.1.44, 5.0, 5.1, 5.5.99Any (MS Windos XP Pro SP3 32bit, Mac OS X)AnyCase Sensitivity table name problem with Windows
478842009-10-07
3:24
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5173 days)
S25.1.39, 5.1.44, 5.5.99Linux (Linux web2 2.6.18-92.1.18.el5.028stab060.8 #1 SMP Mon Feb 9 21:44:50 MSK 2009 x86_64)AnyMySQL 5.1.39 failed to use index
480492009-10-14
16:46
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.1.37, 5.5.7AnyAnySELECT MIN(1) reports differently for MERGE tables in 5.0 and 5.1
481032009-10-16
0:32
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.1, 6.0AnyAnyUsing STRAIGHT_JOIN with Innodb tables can produce duplicate results
481902009-10-20
14:59
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.1,6.0AnyAnyError processing ALL subqueries on empty sets - different than JavaDB/Postgres
482452009-10-22
20:25
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5271 days)
S35.1,mysql-6.0-codebase-bugfixingAnyAnycrash in Bitmap<64u>::merge called by add_key_field
487032009-11-11
21:58
2022-09-04
20:45
MySQL Server: OptimizerIn progress
(5044 days)
S35.0+AnyAnynontrivial ORDER/GROUP BY expressions: ambiguous statements not detected
488862009-11-19
0:38
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5244 days)
S55.1+AnyAnyMySQL doesn't seem to optimize "less than empty string"
492002009-11-30
10:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5233 days)
S36.0AnyAnySelect_type in explain output incorrect for semijoin queries
492762009-12-01
17:03
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5232 days)
S55.0.85-community-log, 5.0.89, 5.1.42LinuxAnyOptimization for IN (on InnoDB tables) depends on number of set elements
495042009-12-07
12:54
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5226 days)
S35.1+AnyAnyInconsistency in handling range predicates with NULL constants
495902009-12-10
16:03
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0+AnyAnyServer reporting different result sets for a query depending on use of indexes
501682010-01-08
2:16
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5189 days)
S35.0,5.1AnyAnyThe value of 'rows' in EXPLAIN output is not accurate for LIMIT
503882010-01-16
4:13
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS55.1.41,5.1.42, 5.1.43-bzrAnyAnypartition pruning not working with some right joins
509532010-02-05
18:40
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5165 days)
S25.1.41, 5.1.44, 5.5.99AnyAnyLocked rows change in number, strangely.
515212010-02-25
18:03
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5145 days)
S25.1.42, 5.1.45-bzrAnyAnyMERGE Algorithm in LEFT JOIN retuns 0000-00-00 instead of NULL
520292010-03-13
12:26
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5121 days)
S55.1.44AnyAnyGROUP BY results in much slower query
520302010-03-13
12:35
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5127 days)
S25.1.44AnyAnyWHERE clause with != primary key check slows a query from 0.06 sec to 4 min
521702010-03-18
9:57
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5121 days)
S55.1.44, mysql-next-mtLinux (fc12)Anyinnodb query optimizer fails (null possible_keys) with multicolumn key
521742010-03-18
10:59
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5106 days)
S34.1, 5.0, 5.1AnyAnySometimes wrong plan when reading a MAX value from non-NULL index
522832010-03-22
19:10
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5120 days)
S35.1.46AnyAnyInnodb reports extra warnings when SELECT/WHERE is performed using invalid value
527622010-04-12
10:49
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5099 days)
S55.3AnyAnylike should be index optimised if starts with _ rather than %
527842010-04-13
14:02
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5099 days)
S35.1.43, 5.6.99-m4AnyAnyNon optimal execution plan when using "NULL-safe not equal" on partitioned table
536482010-05-14
14:00
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5064 days)
S35.1.48-bzrAnyAnyWhere clause with IS TRUE generates different plan
537932010-05-19
9:52
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5063 days)
S36.0-codebase-bugfixingAnyAny"early NULL filtering" not done for outer join converted to inner join
540562010-05-28
6:43
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5054 days)
S35.1.47, 5.1.48, 5.6.99AnyAnyIncorrect number format in output from SELECT
541792010-06-02
11:37
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.1.37 , 5.1.47 , 5.5.4AnyAnyIndex is not used for range scan on SET field
542072010-06-03
15:05
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5042 days)
S25.1.40, 5.1.48, allLinux (5u4)Anywhy mysql cann't using index to filter column after range condition ;
543122010-06-07
22:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5043 days)
S35.1.47, 5.1.48-bzrAnyAnyinsert ... select .. order by rand(): difference depending on indexes.
549212010-06-30
16:41
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5021 days)
S35.0-bzr, 5.1-bzrAnyAnyORDER BY doesn't use index if ref lookup on VARBINARY column used
552482010-07-14
9:22
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5007 days)
S55.1.43, 5.1.48WindowsAnyconstant WHERE inefficient
559792010-08-13
22:05
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4974 days)
S55.1.39LinuxAnyKey not used if IN() list contains mix of strings and integers
561652010-08-21
8:12
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4967 days)
S35.0.not_sure, 5.0, 5.1, 5.6.99 bzrAnyAnyBad Optimization
569252010-09-22
11:27
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4804 days)
S35.5AnyAnyWrong execution of UPDATE … WHERE sec_key=… ORDER BY pk DESC
570242010-09-26
4:44
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4930 days)
S25.1AnyAnySerious performance issue with an outer join
572162010-10-04
12:59
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4921 days)
S35.1, 5.6.99 bzrAnyAnyInnoDB column prefix index not treated as a covering one
580082010-11-05
9:38
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4893 days)
S35.1, 5.0AnyAnywrong datatype (blob) in the resultset if the string is larger than 512 bytes
581012010-11-10
0:21
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4887 days)
S55.1.38-community-log, 5.1.54-bzrLinuxAnyOptimizer picks wrong order of queries
586042010-11-30
21:28
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4866 days)
S15.5.7, 5.5.9, 5.6.1AnyAnycrash in cleanup code of explain partitions after killing connection
587372010-12-05
7:59
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4862 days)
S35.1.53, 5.1.54Windows (7)Anynested query fails to execute
589242010-12-14
18:38
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4853 days)
S35.1.44, 5.0, 5.1, 5.6.1LinuxAnya LIMIT after a UNION doesn't propogate to all queries
589282010-12-14
20:58
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4854 days)
S35.1-bugteamAnyAny"not exists" optimization not applied if relevant table is not single inner one
591192010-12-23
0:01
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4845 days)
S25.1.50AnyAnyIncorrect table order chosen for three table join with an ORDER BY
591872010-12-27
15:31
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4841 days)
S25.1.55, 5.6.2-m5AnyAnyWrong result with NULL NOT IN subquery
595572011-01-17
15:26
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4820 days)
S25.1, 5.5AnyAnyMySQL uses order of fields in GROUP BY when ORDER BY NULL is specified
596502011-01-21
9:32
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4816 days)
S3mysql-trunkAnyAnySELECT Does Not Return Result For "equal / Null safe equal" Operator On BIT
599522011-02-04
17:20
2014-03-16
11:44
MySQL Server: OptimizerVerified
(4767 days)
S35.1.55-community, 5.6.3AnyAnydistinct ,distinct_key,group_key
600232011-02-08
21:45
2014-05-22
12:13
MySQL Server: OptimizerVerifiedS55.5.8 , 5.1.51AnyAnyNo Loose Index Scan for GROUP BY / DISTINCT on InnoDB partitioned table
601852011-02-20
15:58
2011-03-03
8:35
MySQL Server: OptimizerVerified
(4786 days)
S35.0.51, 5.5.11LinuxAnyindex DEPENDENT SUBQUERY
604942011-03-16
17:26
2011-03-19
9:43
MySQL Server: OptimizerVerified
(4761 days)
S35.1.36-community, 5.1.57AnyAnyOrder By produces wrong order
607022011-03-30
23:25
2011-04-05
14:55
MySQL Server: OptimizerVerified
(4747 days)
S55.1.57AnyAnyGROUP BY orders when used inside a UNION query, though it should not
615512011-06-17
12:26
2011-06-18
8:34
MySQL Server: OptimizerVerified
(4669 days)
S35.1.56AnyAnyLoose index scan is not used for select COUNT(distinct a)
619362011-07-21
6:27
2011-07-31
15:28
MySQL Server: OptimizerVerified
(4634 days)
S25.1.48, 5.5.13, 5.5.16Linux (x86_64)AnySTRAIGHT_JOIN has no effect on query with subquery in FROM clause
623072011-08-31
1:54
2011-09-01
21:29
MySQL Server: OptimizerVerified
(4593 days)
S35.5.15AnyAnyCondition "TIME = '19:20'" does not use index in sjis
433412009-03-03
21:39
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5505 days)
S25.1AnyAnyFORCE INDEX FOR ORDER BY does not affect join queries
433422009-03-03
21:54
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5505 days)
S25.1, 6.0AnyAnyFORCE INDEX hint does not differentiate between ORDER BY and GROUP BY
435312009-03-10
11:24
2020-05-03
20:45
MySQL Server: OptimizerVerified
(5316 days)
S35.1, 6.0.11-bzrLinuxAnyCrash if Falcon or MyISAM, subqueries, 4 clients
437202009-03-18
6:00
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5490 days)
S36.0.11, 5.0, 5.1 bzrAnyAnyMyISAM & Maria gives wrong results with range access on bit type
442012009-04-10
3:04
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5036 days)
S35.1.32, 5.1.35-bzr, 6.0.11-bzr, 5.0, 5.6.99AnyAnyPerformance problem with View
444452009-04-23
19:24
2020-05-03
20:45
MySQL Server: OptimizerVerified
(5336 days)
S35.1.31-log, 5.0, 5.1, azalea bzrLinuxAnyProblem using index when selecting all columns
445492009-04-29
17:47
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0.80, 5.1.34AnyAnyoptimizer incorrectly chooses table scan and filesort over index
445932009-05-01
3:31
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5446 days)
S35.0.56, 5.0.72AnyAnyMyISAM tables showing odd "rows" value with EXPLAIN of a JOIN query
450012009-05-21
6:22
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5380 days)
S35.1.33, 4.1, 5.0, 5.1, 6.0 bzrAnyAnyEXPLAIN says "Using index; Using filesort", however table scan is used
453142009-06-03
22:46
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5412 days)
S35.1.28-rc-community, 4.1, 5.0, 5.1, 6.0 bzrAny (MS Windows, Linux)AnyIndex is not used for joining on a nullable columns with no additional condition
453732009-06-08
13:14
2022-09-04
20:45
MySQL Server: OptimizerVerified
(5397 days)
S35.1.35-community, 5.1.36-bzrAnyAnyINDEX FOR GROUP BY is not used if there is a LIMIT clause in the query
454242009-06-10
6:58
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5406 days)
S25.0.51a, 5.0.77 and 5.1.34, 5.1, 6.0 bzrLinuxAnyUPDATE statement cause full table scan ?
456802009-06-23
14:15
2020-04-01
13:16
MySQL Server: OptimizerVerifiedS35.0.54, 5.0.82, 5.1.35, 6.0.12AnyAnywrong results when using index for lookup with implicitly casted values
457412009-06-25
10:46
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5387 days)
S15.0.83, 5.0, 5.1, 5.5.8LinuxAnyMemory of server increases abnormally for sql with mass <> condition
457762009-06-26
7:17
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5390 days)
S5mysql-5.1.35LinuxAny"OR" condition on SPATIAL index not optimized
458802009-07-01
14:21
2022-09-04
20:45
MySQL Server: OptimizerVerifiedS35.0, 5.1AnyAnyOUTER JOINed tables with no condition in WHERE must be at the end of explain
460112009-07-07
14:05
2020-05-03
20:45
MySQL Server: OptimizerVerified
(4917 days)
S35.1-bugteamAnyAnyRegression after applying fix for bug #45828
460562009-07-08
20:24
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0,5.1,5.4AnyAnyDuplicate rows returned on MAX + ORDER BY
461352009-07-12
19:03
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4997 days)
S25.0, 5.1, next, 6.0.0, 6.0.2, 5.1.36AnyAnyLIMIT + JOIN problem
462172009-07-16
11:16
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0,5.1,5.4AnyAnyWrong result on aggregate + JOIN + ORDER BY + LIMIT
462272009-07-16
14:43
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5370 days)
S35.0,5.1,5.4AnyAnyWrong result on DISTINCT + aggregate + JOIN + InnoDB
462772009-07-17
21:33
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0, 5.1, 5.4, 6.0AnyAnydiffering results for equivalent queries using VAR_POP() & AVG() with DISTINCT
462832009-07-18
15:22
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.0, 5.1, 5.4, 6.0AnyAnyCOUNT() returning bad values when LIMIT 1 clause added to query
462882009-07-18
19:12
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5368 days)
S35.1.35-community, 5.1.36WindowsAnyIndex is not used for equality condition on single-row, multiple column subquery
463762009-07-24
17:05
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5357 days)
S55.0.85, 5.1.36, 5.1.38, 5.1.39Windows (XP)AnyOptimizer choose wrong index even when where clause and order-by are covered
464752009-07-30
11:24
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5355 days)
S35.1,5.4AnyAnyDifferent optimizations chosen for exactly equivalent queries
465172009-08-02
21:54
2018-09-09
20:45
MySQL Server: OptimizerVerifiedS35.4,5.6.99AnyAnyQueries with constant / null only WHERE clause interpreted differently in azalea
466482009-08-11
11:41
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5338 days)
S35.1.32, 4.1, 5.0, 5.1, azalea bzrLinux (2.6.28.7)AnySQL_CALC_FOUND_ROWS kills performance with ORDER BY and LIMIT
467172009-08-14
11:14
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5331 days)
S55.1.32AnyAnyUnnecessary joins are not optimized away
468532009-08-21
11:07
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5238 days)
S3AnyAnyvalgrind warnings in mysql-pe branch with the testcase for the BUG#45816
469892009-08-29
5:52
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5326 days)
S35.1,5.4AnyAnyNULL attribute gets lost when "CREATE TABLE AS SELECT ... GROUP BY WITH ROLLUP"
473302009-09-15
15:39
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5301 days)
S55.0.77, 5.1.34, 5.1.37Linux (Debian x64)AnySlow query with left join and having.
474542009-09-19
19:33
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5304 days)
S35.1.35AnyAnyNot exists optimization method is not used for NULL columns in the right table
372642008-06-07
22:35
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5643 days)
S55.1.24-rc 5.1.29-rc 5.1.30AnyAnyMySQL wrongly uses filesort
373052008-06-10
9:53
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5706 days)
S35.0/5.1/6.0, 5.7.18AnyAnyselect count(*); returns value
379022008-07-06
15:14
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5724 days)
S35.0.45, 5.0.68MacOSAnyBug (2) in the query optimizer (explain)
382512008-07-21
0:29
2020-05-03
20:45
MySQL Server: OptimizerVerified
(5730 days)
S55.0.51AnyAnyUseless external queries should be ignored
383972008-07-27
20:13
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5723 days)
S35.1.26, 5.0.62AnyAnyselect distinct + order by desc is executed inefficiently
385502008-08-04
21:47
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5643 days)
S55.0.60, 5.1AnyAnymultiple optimizer bugs for queries with references from preceding table
392982008-09-08
6:42
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5506 days)
S34.0, 4.1, 5.0, 5.1, 6.0AnyAnyPrefix key search returns wrong result for multi-level collations
399442008-10-09
2:10
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5650 days)
S34.1, 5.0, 5,1, 6.0 bzrAnyAnyWith join buffer executor ignores index scan
401512008-10-19
18:12
2020-05-03
20:45
MySQL Server: OptimizerVerified
(3984 days)
S36.0/5.6AnyAnyEXPLAIN doesn't show DISTINCT+join optimization
410642008-11-27
2:25
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5601 days)
S3MySQL 5.0.27-standard, 5.0.70, 6.0.7LinuxAnyenum query never use index and it should
411092008-11-28
17:13
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5476 days)
S25.1.30, 5.0, 5.1, 6.0 bzrAnyAnyQuery takes >5 hrs and locks db, when optimised manually takes <1s
412202008-12-04
9:59
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5337 days)
S55.1.30, 5.0, 5.1, azalea bzrAnyAnyLEFT JOIN with compound clause uses table scan, while INNER JOIN uses indexes
413502008-12-10
8:00
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5588 days)
S35.0.46-logLinuxAnyString expression collation determined only by the first equality operand
418732009-01-05
15:52
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5555 days)
S35.1.30-community, 5.0, 5.1, 6.0 bzrAny (MS Windows, Linux)AnyMySQL doesn't use indexes when joining large table to small one
428082009-02-12
22:17
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5523 days)
S54.1, 5.0, 5.1AnyAnyExecution Plan Cache
429482009-02-17
23:02
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5505 days)
S55.0.67-0ubuntu6, 6.0.11Linux (Ubuntu 8.10)AnyMySQL Optimizer does not properly use Indexes on Views with "Group By"
430112009-02-19
10:01
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5309 days)
S25.0.75, 5.0.*, 5.1.*AnyAnyinconsistent content for 'rows' column in EXPLAIN for index_merge
430522009-02-20
9:49
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5516 days)
S35.1.30-community, 4.1, 5.0, 5.1, 6.0 bzrAny (MS Windows XP, Linux)Anynot optimalised (sub)query, = versus IN
432192009-02-26
9:49
2020-12-23
7:46
MySQL Server: OptimizerVerified
(5510 days)
S35.0.70, 4.1, 5.0, 5.1, 6.0 bzrLinux (Gentoo)Anydelete does not use index when using OR in where clause
70802004-12-07
15:23
2018-09-09
20:45
MySQL Server: OptimizerVerified
(6999 days)
S34.0Linux (Linux)AnyOptimizer choose incorrect index
76042004-12-31
20:13
2020-05-03
20:45
MySQL Server: OptimizerVerified
(5219 days)
S35.0.21-BK, 6.0.14Linux (Linux)AnyRow subqueries don't work with ALL
80362005-01-20
10:12
2018-09-09
20:45
MySQL Server: OptimizerVerified
(6999 days)
S34.0.18, 4.1.10, 5.1.52FreeBSD (Free BSD 4.5, Linux)AnyBad optimization of ORDER BY ... LIMIT 1 if one table is MyISAM, another InnoDB
81132005-01-24
15:43
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5337 days)
S55.0, 5.1, azalea bzrAnyAnySelect with between optimization
86622005-02-21
21:31
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5233 days)
S56.0.14, 5.1.12-BK, 4.1.10AnyAnyoptimizer, query takes 3 to 10 times as long when using index
87492005-02-23
21:08
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5294 days)
S34.1.10, 5.0.67Any (*)AnyEXPLAIN report different "type" w and w/o USE INDEX(...) for the same used key
119482005-07-14
18:00
2018-09-09
20:45
MySQL Server: OptimizerVerified
(6813 days)
S35.0AnyAnyMyISAM only, nested JOIN Views, dramatic performance loss
121132005-07-22
14:23
2014-01-24
12:43
MySQL Server: OptimizerVerified
(3717 days)
S15.0.28-BK, 4.0,5.0AnyAnyComposite index chosen partially for ORDER BY ... LIMIT query.
127992005-08-25
9:46
2020-05-03
20:45
MySQL Server: OptimizerVerified
(5294 days)
S35.0.10-log, 4.1.13a-log on win, 4.1 on RHES3.0Windows (windows xp)Anyone result returned when change from summer time causes dup unique key recs
140842005-10-17
20:09
2014-01-23
9:50
MySQL Server: OptimizerVerified
(3718 days)
S35.0-bkAnyAnyindex_merge access method not used for federated engine
142532005-10-24
9:26
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5202 days)
S35.0, 4.1, 6.0.14-bzrLinux (Linux)AnyOptimizer uses partial indexes for subqueries, where it should not
159072005-12-21
15:23
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5218 days)
S55.0.19-BK, 5.0.13, 6.0.14-bzrLinux (Linux)AnyBinary comparison ignores indexes
172592006-02-09
2:23
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5625 days)
S55.0.15, 6.0.7Linux (Linux)AnyQuery optimizer chooses wrong index
172992006-02-10
12:35
2014-01-23
9:53
MySQL Server: OptimizerVerified
(3718 days)
S35.0.18Any (All)AnyInefficient optimizer for fulltext queries.
184652006-03-23
17:43
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5299 days)
S25.0.20-BK, 5.0.19, 5.0.85Any (any)AnyOptimizer/execution plan bug with dependent subqueries in ON clauses of JOINs
186882006-03-31
14:07
2018-09-09
20:45
MySQL Server: OptimizerVerified
(6048 days)
S34.0, 4.1, 5.0Linux (linux)Anynon-optimal plan for SELECT
191952006-04-19
12:09
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5299 days)
S35.0.27-BK, 5.0.21-BK, 5.0.19Linux (Linux)AnyOptimizer does not use proper index for join
201112006-05-28
10:57
2014-01-24
13:26
MySQL Server: OptimizerVerified
(3717 days)
S54.1.19-logLinux (Linux)Anynamed columns used in subqueries hinder optimisation of LIKE, BETWEEN, range
242512006-11-13
10:58
2018-09-09
20:45
MySQL Server: OptimizerIn progress
(5240 days)
S55.0.30-BK, 5.1.12Linux (Linux, Win XP SP2)AnyNon-optimal choice of indexes for queries
246972006-11-29
15:13
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4836 days)
S35.0.24a-community-nt-log/4.1BK/5.0BK/5.1BKWindows (Windows 2000 and Linux)Anyinsert .. select ....ON DUPLICATE KEY UPDATE fails with ambiguous column name
247542006-12-01
13:34
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5223 days)
S35.1.14, 5.1.43-bzrLinux (Linux)AnyIndex is not used when joining two tables
247702006-12-02
0:37
2018-09-09
20:45
MySQL Server: OptimizerIn progress
(4757 days)
S55.1Any (all)Anyupdate with subquery slow
250682006-12-14
11:56
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5643 days)
S34.0.27, 5.0.19, 5.0.36-BKLinux (Linux)AnyMyISAM-Optimizer prefers full table scan than index for IN with >15 elements
257642007-01-22
20:59
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5542 days)
S35.0.36-BK, 6.0.8-bzrLinux (Linux, Mac OS X)AnyQuery Cost Estimate seems to only cover a part of subqueries, not full query.
262322007-02-09
17:28
2018-09-09
20:45
MySQL Server: OptimizerVerified
(6252 days)
S34.1.22, 5.0.34, 5.0.36-BKLinux (Linux)Anyreview of bug #20944 / proof of concept attached
262842007-02-12
12:32
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5983 days)
S35.0.bkLinux (Linux)Anybug #26273 / optimize, not executed for index, if datafile is gap-free
268322007-03-04
18:17
2011-04-05
14:46
MySQL Server: OptimizerVerified
(4742 days)
S55.5AnyAnyENUM types not optimized
274522007-03-26
17:35
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5611 days)
S35.0.40-BK, 5.0.24a-debian-log, 5.1.31-bzr, 6.0.7-alpha, 6.0.9-bzrLinuxAnyCorrelated subquery produces inefficient optimizer plan for INFORMATION_SCHEMA
284042007-05-13
18:33
2018-11-11
14:44
MySQL Server: OptimizerVerified
(1965 days)
S24.0.31, 4.1.25, 4.1.26, 5.0.42-BK, 5.0.46, 5.1.33LinuxAnyOptimizer does not consider index that can be used for ORDER BY
285542007-05-21
9:32
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5425 days)
S34.1.22, 5.0.42-BKAnyAnyOptimizer wrongly prefers index for (col = value) over (PK <= value)
294212007-06-28
13:43
2018-09-09
20:45
MySQL Server: OptimizerVerified
(6119 days)
S25.1.14-beta/5.0AnyAnyMySQL allows mixing of GROUP columns with no GROUP columns in complex terms
294332007-06-29
0:03
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5233 days)
S35.0.27, 5.0, 5.1, 4.1, 5.2 BK, 6.0.14-bzrAnyAnycomposite index not used
294432007-06-29
13:28
2018-09-09
20:45
MySQL Server: OptimizerVerified
(4915 days)
S35.1.19AnyAnycost calculations are off
303022007-08-08
12:41
2022-09-04
20:45
MySQL Server: OptimizerVerified
(5065 days)
S35.0.40, 5.1, 5.2, 5.0 BKAnyAnyQuery from EXPLAIN EXTENDED .. SHOW WARNINGS returns different result
303422007-08-09
18:52
2015-10-07
14:54
MySQL Server: OptimizerVerified
(3096 days)
S55.0.37, 5.6.17AnyAnyEquality propagation can make optimization much slower
314462007-10-08
12:14
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5643 days)
S55.0.44, 5.0.37, 6.0.2 AlphaAnyAnyInefficient index use with order by and joins
319012007-10-29
2:51
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5889 days)
S55.0.45AnyAnyread_rnd_buffer_size doesn't seem to be used as written in Reference Manual
323412007-11-13
19:29
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5643 days)
S35.0.41, 5.0.52LinuxAnySubquery does not use index with session variable, works with string literal
340782008-01-26
14:19
2020-05-03
20:45
MySQL Server: OptimizerVerified
(5880 days)
S34.1,5.0,5.1,6.0-BKAny (Linux)Anyref access is not used for varchar column
340802008-01-26
17:25
2020-05-03
20:45
MySQL Server: OptimizerVerified
(5907 days)
S35.0.54, 5.0.45Linux (Ubuntu)AnyEXPLAIN EXTENDED converts NULL to empty string
343102008-02-05
14:51
2018-09-09
20:45
MySQL Server: OptimizerVerified
(3754 days)
S55.0.51a-log, 5.0.54, 5.6.14LinuxAnyOptimizer is inefficient by using ORDER BY function() and LIMIT
346662008-02-19
14:11
2020-05-03
20:45
MySQL Server: OptimizerVerified
(5814 days)
S35.0/5.1/6.0.4AnyAnyIncomplete metadata returned to client on view + group by + Innodb/Falcon
356332008-03-28
8:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5845 days)
S15.0.54, 5.0.56Linux (2.6.25-rc4)AnyColumn cant be NULL error on SELECT...FROM (SELECT not_null_column, agg_func...)
357242008-03-31
22:24
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5504 days)
S2MySQL 5.0.51a-community-nt, 5.1, 6.0 BKAnyAnyNon-found left join data passed as a parameter to a function in WHERE
361952008-04-18
2:29
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5814 days)
S35.1-bkAnyAnymysqld calls handler->cond_push twice
363002008-04-23
17:49
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5190 days)
S34.1.26, 5.0.32, 5.0+, 5.1.43-bzr, 6.0.14-bzrLinuxAnymin() and max() functions returns NULL when using NOT + BETWEEN in where
364222008-04-30
2:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5812 days)
S36.0.xAnyAnyEXPLAIN EXTENDED; SHOW WARNINGS doesn't have ON expression for semi-joins
367252008-05-14
20:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5603 days)
S25.1.22/5.0BK/5.1BKLinux (Ubuntu 7.04)AnyUPDATE takes too long to execute
368172008-05-20
13:19
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5381 days)
S55.0.54a,5.1.19, 5.1.25, 5.0.60, 5.5AnyAnyNon optimal index choice, depending on index creation order
370532008-05-29
4:11
2018-09-09
20:45
MySQL Server: OptimizerVerified
(5673 days)
S34.1, 5.0, 5.1,6.0.5Any (Linux, Solaris)AnyOptimizer unnecessarily uses temporary and filesort with ORDER BY
938452019-01-07
21:55
2021-08-23
12:23
MySQL Server: OptimizerVerified
(1906 days)
S25.7,8.0.11,8.0.13AnyAnyOptimizer choose wrong index, sorting index instead of filtering index
942242019-02-06
16:45
2019-11-17
10:39
MySQL Server: OptimizerVerified
(1877 days)
S35.6, 5.6.43Any (any)Any (any)[5.6] Optimizer reconsiders index based on index definition order, not value
945482019-03-04
15:31
2019-03-05
10:03
MySQL Server: OptimizerVerified
(1851 days)
S35.7, 5.7.25, 8.0.15CentOS (7)AnyOptimizer error evaluating JSON_Extract
946112019-03-10
2:14
2019-03-10
5:32
MySQL Server: OptimizerVerified
(1846 days)
S28.0.15-rds-dev, 8.0.15, 5.7.25,5.6.43CentOSAnyWrong results returned with "group by"
946122019-03-10
2:18
2020-12-13
18:00
MySQL Server: OptimizerVerified
(1846 days)
S28.0.15-rds-dev, 8.0.15, 5.7.25,5.6.43CentOSAnyWrong results are returned with "group by"
947312019-03-21
6:08
2019-03-21
12:38
MySQL Server: OptimizerVerified
(1835 days)
S35.7.25AnyAnyOptimizer hints removed from views definition
947952019-03-27
7:07
2019-03-27
9:19
MySQL Server: OptimizerVerified
(1829 days)
S25.7.22, 5.7.25Oracle Linux (6.8)x86wrong results with GROUP_CONCAT
948002019-03-27
14:11
2023-06-27
12:31
MySQL Server: OptimizerVerified
(1829 days)
S25.7.23-4CentOSAnyLost connection (for Debug version) or wrong result (for release version)
949032019-04-04
8:39
2020-08-26
12:32
MySQL Server: OptimizerVerified
(1817 days)
S38.0.15AnyAnyoptimazer chooses inefficient plan for order by + limit in subquery
949732019-04-10
16:12
2019-04-25
23:04
MySQL Server: OptimizerVerified
(1800 days)
S25.7.25Linux (Ubuntu 4.15.0-47-generic)x86 (64 bit)Wrong result with subquery in where clause and order by
950202019-04-15
10:11
2019-04-24
13:02
MySQL Server: OptimizerVerified
(1802 days)
S55.7.25CentOSAnyselect no rows return but check profile process Creating sort index
950412019-04-17
3:12
2019-06-03
13:52
MySQL Server: OptimizerVerified
(1763 days)
S35.6.41AnyAnyselect with union cause ERROR1169(23000)Can't write,because of unique constraint
950582019-04-18
18:12
2019-04-25
2:29
MySQL Server: OptimizerVerified
(1800 days)
S35.7.21AnyAnyIndex not used for column with IS TRUE or IS FALSE operators
953032019-05-08
16:17
2019-05-09
14:53
MySQL Server: OptimizerVerified
(1786 days)
S28.0.15, 5.6.36, 5.6.44, 5.7.26Linuxx86RIGHT ... IN evaluating to 1 within user function, 0 outside of user function
954162019-05-20
0:33
2019-05-22
21:45
MySQL Server: OptimizerVerified
(1775 days)
S25.7.25,8.0.15, 5.6.44, 5.7.26, 8.0.16AnyAnyZERO Date is both NULL and NOT NULL
955432019-05-27
12:37
2019-05-29
12:34
MySQL Server: OptimizerVerifiedS25.7.26AnyAnyoptimizer prefers index for order by rather than filtering - (70x slower)
957762019-06-13
2:34
2019-06-13
5:38
MySQL Server: OptimizerVerified
(1751 days)
S35.7.15-log MySQL Community Server (GPL), 5.6.44, 5.7.26, 8.0.16CentOSAnyAbout FUNCTION STDDEV_SAMP:Data only in different order
958232019-06-15
10:54
2019-06-16
5:57
MySQL Server: OptimizerVerified
(1748 days)
S38.0, 5.7.26, 8.0.16AnyAnyEXPLAIN FORMAT=JSON shows incorrect information in used_key_parts
958242019-06-15
11:07
2019-06-16
5:58
MySQL Server: OptimizerVerified
(1748 days)
S35.7.26,8.0.16AnyAnyOptimizer trace prints ranges incorrectly for multi-part keys
959362019-06-23
20:54
2019-10-18
15:41
MySQL Server: OptimizerVerified
(1737 days)
S35.7.25CentOSx86insert into ... select does not work with repeatable read
959382019-06-24
6:51
2019-07-23
11:46
MySQL Server: OptimizerVerified
(1711 days)
S38.0.16, 5.7.26, 5.6.44Ubuntux86Function return value with newline yields wrong result when used as a boolean
959572019-06-24
16:26
2019-06-25
5:15
MySQL Server: OptimizerVerified
(1739 days)
S38.0.16, 5.7.26, 5.6.44Ubuntux86IN operator issue when comparing signed column and the column cast to unsigned
959602019-06-24
18:55
2019-09-26
12:36
MySQL Server: OptimizerVerified
(1712 days)
S38.0.16, 5.7.26, 5.6.44Ubuntux86The logical operators &, |, and ^ do not ignore newlines in TEXT
960872019-07-04
3:06
2019-07-24
5:26
MySQL Server: OptimizerVerified
(1730 days)
S28.0.16, 5.7.26, 5.6.44AnyAnyDIV + const expression return wrong data
960902019-07-04
8:01
2019-07-10
14:19
MySQL Server: OptimizerVerified
(1725 days)
S35.7.26 MySQL Community ServerLinuxAnyselect exists return wrong result while subquery contains limit offset.
961372019-07-09
9:20
2019-07-09
16:25
MySQL Server: OptimizerVerified
(1725 days)
S2 5.7.17 MySQL Community ServerLinuxAnyNOT(NOT( FIELD > ALL (SUBQUERY) )) 'S RESULT NOT EQUAL FIELD > ALL (SUBQUERY)
963792019-07-31
5:55
2019-08-02
7:03
MySQL Server: OptimizerVerified
(1702 days)
S38.0.16, 8.0.17, 5.7.27Windowsx86First query successfull, second - ERROR 1270 (HY000): Illegal mix of collations
965032019-08-12
3:31
2019-08-12
5:20
MySQL Server: OptimizerVerified
(1691 days)
S38.0.17, 5.6.45, 5.7.27AnyAnylast_day does not return null with invalid argument "2011-01-00"
836272016-11-01
8:16
2016-11-01
9:36
MySQL Server: OptimizerVerified
(2705 days)
S35.7/8.0LinuxAnyinconsistent results with generated column when meets char and padding
837222016-11-07
13:28
2020-06-24
9:10
MySQL Server: OptimizerVerified
(2699 days)
S35.7/8.0Ubuntu (16.04)AnyUNION with outer LIMIT can return wrong number of rows
838562016-11-17
4:19
2019-11-15
17:31
MySQL Server: OptimizerVerified
(2658 days)
S35.7.13,5.7.16CentOSAnyIndex ref not used for multi-column IN - type or collation conversion warning
840242016-12-01
2:40
2016-12-02
9:07
MySQL Server: OptimizerVerified
(2674 days)
S35.7.16, 5.6.34AnyAnyOptimizer thinks clustered primary key is not covering
844162017-01-04
23:11
2017-01-05
11:26
MySQL Server: OptimizerVerified
(2640 days)
S35.6 and 5.7AnyAnyMySQL updates 0000-00-00 00:00:00 for datetime type
846382017-01-24
12:40
2017-01-30
6:47
MySQL Server: OptimizerVerified
(2619 days)
S35.6, 5.7AnyAnyMissing FROM clause returns error when using INTO at the end of the statement
847202017-01-30
12:09
2017-01-30
13:19
MySQL Server: OptimizerVerified
(2615 days)
S35.6.27,5.7, 5.7.17AnyAnyWITH ROLLUP not providing expected NULL values
848582017-02-07
13:09
2017-02-09
6:34
MySQL Server: OptimizerVerified
(2605 days)
S35.6, 5.7, 5.6.35AnyAnyTime is spent at "statistics" stage for primary key lookups
851262017-02-22
10:42
2017-02-28
7:19
MySQL Server: OptimizerVerified
(2586 days)
S15.6.35AnyAnyDelete by range in presence of partitioning and no PK always picks wrong index
851882017-02-27
2:33
2017-02-27
7:30
MySQL Server: OptimizerVerified
(2587 days)
S35.6.34,5.6.35, 5.7.17AnyAnywarnings of explain extended does not convert charset
966472019-08-26
6:21
2019-08-26
7:38
MySQL Server: OptimizerVerified
(1677 days)
S35.7.22, 5.7.27, 8.0.17AnyAnyQuery Rewrite plugin database_pattern column length is too shot
966882019-08-29
4:14
2019-08-29
11:31
MySQL Server: OptimizerVerified
(1674 days)
S38.0.16, 8.0.17AnyAnysql query 'where' condition
969582019-09-20
21:42
2019-09-22
14:28
MySQL Server: OptimizerVerified
(1650 days)
S38.0AnyAnyMySQL optimizer wrongly chooses to use a bigger and inefficient index for query
973392019-10-23
8:06
2021-07-23
13:05
MySQL Server: OptimizerVerified
(1613 days)
S25.7.18, 5.7.28, 5.6.46AnyAnybin() function return Incorrect result set
976482019-11-14
20:25
2019-11-19
14:48
MySQL Server: OptimizerVerified
(1593 days)
S35.7, 8.0AnyAnyBug in order by clause in union clause
980552019-12-23
11:37
2020-01-24
13:03
MySQL Server: OptimizerVerified
(1527 days)
S35.7Red Hat (amezon RDS)AnyMySQL Optimizer Bug not picking right index
985202020-02-08
9:37
2020-05-05
14:51
MySQL Server: OptimizerVerified
(1424 days)
S58.0AnyARMSuboptimal implementations for some load/store functions for little-endian arch
986472020-02-18
13:06
2020-02-18
14:03
MySQL Server: OptimizerVerified
(1501 days)
S35.7.29Windowsx86Bad SUM result with GROUP BY
987702020-02-28
4:02
2020-03-03
15:05
MySQL Server: OptimizerVerified
(1487 days)
S58.0.19AnyAnyNon-covering full index scan is always preferred over table scan for GROUP BY
987712020-02-28
6:29
2020-03-02
18:39
MySQL Server: OptimizerVerified
(1491 days)
S25.7, 5.7.29AnyAnyPerformance impact while selecting data from a JSON type column
988382020-03-05
6:11
2020-03-05
6:22
MySQL Server: OptimizerVerified
(1485 days)
S2mysql5.7.22 mysql5.7.29AnyAnyselect distinct will return wrong result in one case
991302020-03-31
12:18
2020-04-01
13:10
MySQL Server: OptimizerVerified
(1459 days)
S38.0.19,5.6.47, 5.7.29AnyAnyBETWEEN malfunctions when comparing a string containing a newline
991352020-03-31
16:54
2020-04-01
5:11
MySQL Server: OptimizerVerified
(1458 days)
S38.0.19, 5.6.47, 5.7.29AnyAnyBETWEEN malfunctions when comparing large numbers
991422020-04-01
7:39
2020-04-01
8:27
MySQL Server: OptimizerVerified
(1458 days)
S28.0.16, 8.0.19, 5.7.29AnyAnyThe result mismatches when DISTINCT syntax exists
991462020-04-01
9:49
2020-04-01
10:42
MySQL Server: OptimizerVerified
(1458 days)
S38.0.19, 5.7.29AnyAnyComparison on FLOAT column and large value malfunctions
991492020-04-01
11:07
2020-04-01
11:46
MySQL Server: OptimizerVerified
(1458 days)
S38.0.19AnyAnyBETWEEN query malfunctions for special character and TEXT index
992442020-04-14
3:22
2020-04-22
12:45
MySQL Server: OptimizerVerified
(1438 days)
S18.0.19AnyAnybad performance in hash join because join with no join condition between tables
992452020-04-14
3:55
2021-05-31
8:40
MySQL Server: OptimizerVerified
(1445 days)
S38.0.19, 5.6.47, 5.7.29CentOSAnyWrong result is returned with DISTINCT syntax
992732020-04-16
6:02
2020-04-16
7:53
MySQL Server: OptimizerVerified
(1443 days)
S28.0.19, 5.7.29AnyAnyItem_ref in Having Clause points to invalid outer table field
993402020-04-23
20:36
2020-04-24
6:48
MySQL Server: OptimizerVerified
(1435 days)
S28.0.19, 5.6.47, 5.7.29AnyAnyRAND not always returning the same value for equal argument N
993542020-04-25
13:34
2020-04-25
18:21
MySQL Server: OptimizerVerified
(1434 days)
S35.7.26, 8.0.19AnyAnyNondeterministic stored function returns incorrect results
993812020-04-28
7:26
2020-04-29
7:07
MySQL Server: OptimizerVerified
(1430 days)
S28.0.20AnyAnyORDER_BY Index-level optimizer hint implies NO_JOIN_INDEX for second table
994142020-04-30
17:48
2020-05-20
12:20
MySQL Server: OptimizerVerified
(1425 days)
S38.0.20AnyAnyWhere exists performance 8.0.16 onwards
994592020-05-06
8:17
2020-05-08
13:41
MySQL Server: OptimizerVerified
(1421 days)
S35.6,5.7,8.0AnyAnySQL run with GROUP_MIN_MAX may infinite loop and never return
994992020-05-09
22:13
2020-05-25
11:25
MySQL Server: OptimizerVerified
(1417 days)
S35.7.29AnyAnyIncorrect result when constant equailty expression is used in LEF JOIN condition
814692016-05-17
21:51
2016-05-18
6:54
MySQL Server: OptimizerVerified
(2872 days)
S35.6.30, 5.7.12AnyAnySlow performance for IN subquery and UNION
818032016-06-10
12:35
2016-06-15
16:58
MySQL Server: OptimizerVerified
(2844 days)
S5>=5.1AnyAnyMysql 5.1 and later Update performance regression
820212016-06-27
17:46
2016-06-28
6:11
MySQL Server: OptimizerVerified
(2831 days)
S35.6.31, 5.7.13AnyAnyDifference in range behaviour between range analyzer and query execution engine
820742016-06-30
21:50
2016-07-01
5:04
MySQL Server: OptimizerVerified
(2828 days)
S35.5.49, 5.6.30, 5.7.13AnyAnySelect_scan set even if table scan was not used
823342016-07-25
10:58
2016-12-16
14:00
MySQL Server: OptimizerVerified
(2660 days)
S25.7.13CentOSAnyunexpected order for grouped query
823382016-07-25
21:05
2021-12-29
17:53
MySQL Server: OptimizerVerified
(821 days)
S3any, 5.6.31, 5.7.13AnyAnyPlease support ASC/DESC index traversal on ASC/ASC indexing.
823632016-07-27
19:28
2016-07-28
8:11
MySQL Server: OptimizerVerified
(2801 days)
S35.7 and every otherAnyAnyimpossible const condition still followed in a JOIN
825652016-08-12
12:31
2016-08-13
5:09
MySQL Server: OptimizerVerified
(2785 days)
S38.0.0-dmrAnyAnyConditions are only constant propagated within an AND condition
827252016-08-25
15:55
2016-09-14
6:28
MySQL Server: OptimizerVerified
(2753 days)
S55.7.14, 5.7.15CentOS (Linux rda-db-rep.ucar.edu 3.10.0-327.28.2.el7.x86_64 #1 SMP Wed Aug 3 11:11:39 UTC 2016 x86_64 x86_6)AnyExtremely slow query when optimizer_switch='derived_merge=ON'
827512016-08-27
9:31
2017-06-13
4:51
MySQL Server: OptimizerVerified
(2771 days)
S35.6Any (https://aws.amazon.com/amazon-linux-ami/2016.03-release-notes/)AnyCreate View appears to corrupt geospatial function names in version 5.6
828052016-08-31
2:20
2016-08-31
9:47
MySQL Server: OptimizerVerified
(2767 days)
S25.7.10, 5.7.14AnyAnyHaving clause condition fails on join table with TEXT field
830062016-09-15
7:51
2016-09-15
8:36
MySQL Server: OptimizerVerified
(2752 days)
S25.6.24AnyAnyIncorrect processing of WHERE condition with ELT
830622016-09-20
13:18
2018-04-24
20:15
MySQL Server: OptimizerVerified
(2746 days)
S35.6.32, 5.7.14, 5.6.33, 5.7.15AnyAnyit's no longer possible to determine used key parts by looking at key_length
830712016-09-21
8:02
2016-09-21
8:34
MySQL Server: OptimizerVerified
(2746 days)
S35.7.14, 5.6.*, 5.7.15AnyAnyMySQL prefers first declared index over more useful other indexes
832482016-10-03
15:57
2023-02-22
1:40
MySQL Server: OptimizerVerified
(2734 days)
S38.0.0, 5.7.15AnyAnyPartition pruning is not working with LEFT JOIN
833232016-10-10
18:02
2018-04-13
12:41
MySQL Server: OptimizerVerified
(2531 days)
S35.7, 5.6, 8.0.1AnyAnyOptimizer chooses wrong plan when joining 2 tables
908472018-05-12
16:57
2018-08-18
11:52
MySQL Server: OptimizerVerified
(2146 days)
S15.7.22, 8.0.11Windows (W10 64bit)x86Query returns wrong data if order by is present
911392018-06-04
20:37
2021-01-13
11:59
MySQL Server: OptimizerVerified
(1172 days)
S58.0.11AnyAnyuse index dives less often
913622018-06-21
15:18
2019-02-13
14:05
MySQL Server: OptimizerVerified
(2107 days)
S15.6.36 - 5.6.40 and 5.7.18 - 5.7.22, 5.6.40, 5.7.22AnyAnyIncorrect query results under certain conditions.
914182018-06-26
7:08
2018-09-07
13:32
MySQL Server: OptimizerVerified
(2103 days)
S35.7,8.0.11, 5.7.22AnyAnyderived_merge causing inccorect results with distinct subquery and uuid()
917802018-07-24
20:10
2018-07-25
14:45
MySQL Server: OptimizerVerified
(2074 days)
S38.0.11, 5.7.22AnyAnyInconsistent printing of EXPLAIN queries.
918782018-08-02
23:09
2019-09-03
5:29
MySQL Server: OptimizerVerified
(2053 days)
S35.7.23, 8.0.12, 5.7.22, 8.0.11AnyAnyWrong results with optimizer_switch='derived_merge=ON';
918982018-08-03
23:15
2018-09-03
4:42
MySQL Server: OptimizerVerified
(2062 days)
S38.0.11,5.5.60, 5.6.41, 5.7.23,8.0.12AnyAnyLost of precision in Item_func_mod::real_op
920202018-08-15
11:25
2019-02-18
16:46
MySQL Server: OptimizerVerified
(2053 days)
S35.7.23, 8.0.12AnyAnyIntroduce new SQL mode rejecting queries with results depending on query plan
920922018-08-20
19:21
2022-03-23
11:15
MySQL Server: OptimizerVerified
(2047 days)
S38.0.11, 5.7.17AnyAnygetTableName gives inconsistent results
922972018-09-05
16:29
2018-11-12
21:51
MySQL Server: OptimizerVerified
(2031 days)
S38.0.12, 5.7.23, 5.6.41, 5.5.61AnyAnyGROUP_CONCAT doesn't work properly with FLOAT(M,D) fields with value of M digits
924212018-09-14
9:57
2021-06-08
6:49
MySQL Server: OptimizerVerified
(2011 days)
S55.7AnyAnyQueries with views and operations over local variables don't use indexes
924662018-09-17
16:05
2018-09-18
9:14
MySQL Server: OptimizerVerified
(2019 days)
S35.7.22, 5.7.23, 8.0.12AnyAnyCase function error on randomly generated values
925382018-09-24
3:42
2018-10-01
8:51
MySQL Server: OptimizerVerified
(2006 days)
S35.7.23, 5.7.17Windows (windows10)x86when I use CachedRowSet. error:Table doesn't exist
926542018-10-03
11:16
2018-10-03
14:05
MySQL Server: OptimizerVerified
(2004 days)
S38.0.12, 5.7.23Windowsx86GROUP BY fails for queries when a temporary table is involved
928502018-10-19
0:46
2018-10-22
5:31
MySQL Server: OptimizerVerified
(1985 days)
S35.7.23AnyAnyBad select+order by+limit performance in 5.7
930492018-11-01
23:03
2018-11-02
7:06
MySQL Server: OptimizerVerified
(1974 days)
S38.0.13, 5.7.24, 5.6.42AnyAnyORDER BY pk, otherdata should just use PK
931882018-11-14
11:16
2020-07-15
12:53
MySQL Server: OptimizerVerified
(1960 days)
S55.7AnyAnyOptimiser chose incorrect join order inside of derived table
933602018-11-27
9:41
2018-12-12
14:48
MySQL Server: OptimizerVerified
(1934 days)
S55.6.16,5.7.23Linuxx86mysterious optimizer behavior
934182018-11-30
1:07
2018-11-30
5:01
MySQL Server: OptimizerVerified
(1946 days)
S35.7, 5.7.24AnyAnySELECT with IN clause get wrong result set
934552018-12-03
16:46
2018-12-06
14:04
MySQL Server: OptimizerVerified
(1941 days)
S35.7.24AnyAnymax_execution_time optimizer hint has no effect on boolean full-text search
934912018-12-05
17:40
2018-12-06
5:39
MySQL Server: OptimizerVerified
(1940 days)
S38.0.13, 5.7.24, 5.6.42AnyAnyOptimizer does not correctly consider attached conditions in planning
936062018-12-14
7:53
2021-11-23
15:30
MySQL Server: OptimizerVerified
(1905 days)
S25.6.40,5.7.24CentOS (6.9)x86 when use Connector/J preparestatement mysql returns the wrong result
880142017-10-06
17:33
2017-10-23
9:13
MySQL Server: OptimizerVerified
(2349 days)
S35.7.19LinuxAnyRewrite plugin fails to accept pattern with multiple values IN()
881272017-10-17
21:45
2021-11-23
7:22
MySQL Server: OptimizerVerified
(2353 days)
S35.7.19, 5.7.20AnyAnyIndex not used for 'order by' query with utf8mb4 character set
881812017-10-23
5:30
2018-06-11
19:55
MySQL Server: OptimizerVerified
(2349 days)
S35.7.20AnyAnyAnother example of optimizer choosing ref over range when range is faster
882522017-10-27
14:38
2017-10-30
10:41
MySQL Server: OptimizerVerified
(2345 days)
S35.7AnyAnyIncorrect result when using IS NULL expression
886712017-11-28
0:16
2017-12-04
15:41
MySQL Server: OptimizerVerified
(2307 days)
S55.7.19AnyAnyALL + BNL chosen over REF in query plan with a simple SELECT + JOIN
888962017-12-13
12:12
2017-12-14
5:34
MySQL Server: OptimizerVerified
(2297 days)
S35.6, 5.7.20, 8.0.3, 5.6.38AnyAnyDifferent query result, depending from data load pattern
890512017-12-25
19:06
2018-01-02
9:54
MySQL Server: OptimizerVerified
(2285 days)
S35.7.20AnyAnyEXPLAIN output is different for same content depending when index was added
891492018-01-08
23:41
2018-01-16
17:07
MySQL Server: OptimizerVerified
(2264 days)
S55.7.20Red Hat (7.4)AnySELECT DISTINCT on multiple TEXT columns is slow
891822018-01-11
9:51
2018-01-11
13:10
MySQL Server: OptimizerVerified
(2269 days)
S35.6.38, 5.7.20, 8.0.3AnyAnyOptimizer unable to ignore index part entering less optimal query plan
893672018-01-24
2:52
2018-01-24
9:04
MySQL Server: OptimizerVerified
(2256 days)
S35.7.20, 5.7.21AnyAnyStoring result in a variable(UDV) causes query on a view to use derived tables
894732018-01-30
16:56
2018-01-30
18:16
MySQL Server: OptimizerVerified
(2250 days)
S35.7.21AnyAnyInconsistent metadata from derived tables usage.
894812018-01-31
6:57
2018-02-06
11:38
MySQL Server: OptimizerVerified
(2247 days)
S55.6.25.5.7.18Red HatAnymysql does't optimize range query when using where
896212018-02-12
1:10
2018-02-13
17:33
MySQL Server: OptimizerVerified
(2236 days)
S35.6.17MacOS (10.13.3)AnyORDER BY BINARY on alias throws Error:1247
896502018-02-13
13:55
2018-02-14
6:56
MySQL Server: OptimizerVerified
(2235 days)
S35.7, 8.0, 5.6.39, 5.7.21AnyAnyIncorrect ordering with memory tables and long keys
900432018-03-13
8:53
2019-02-18
16:43
MySQL Server: OptimizerVerified
(2207 days)
S35.6, 5.7LinuxAnyconvert_tz doesn't handle offset more than 13 hours
859452017-04-14
8:01
2017-04-17
8:08
MySQL Server: OptimizerVerified
(2538 days)
S35.7.13, 5.7.18AnyAnySQL optimizer fail to check IS NULL condition
862152017-05-08
13:35
2017-07-11
22:44
MySQL Server: OptimizerAnalyzing
(2453 days)
S58.0.1AnyAnyMySQL is much slower in 5.7 vs 5.6
862202017-05-08
16:35
2018-11-06
12:50
MySQL Server: OptimizerVerified
(1971 days)
S35.7.18AnyAnyQuery returns wrong results when using UDF in view
865742017-06-03
16:16
2017-06-03
19:36
MySQL Server: OptimizerVerified
(2491 days)
S35.6AnyAnyConfusing EXPLAIN output for INSERT Queries
866102017-06-07
14:36
2017-06-16
6:47
MySQL Server: OptimizerVerified
(2480 days)
S35.7Linux (centos7)AnyMysql 5.6 and 5.7.17 enterprise "semi join" results are different
869732017-07-06
13:26
2017-07-07
7:19
MySQL Server: OptimizerVerified
(2457 days)
S15.6, 5.5.56, 5.6.36, 5.7.18AnyAnyBIN() function error
872642017-07-31
21:49
2017-08-31
9:04
MySQL Server: OptimizerVerified
(2431 days)
S25.6.36, 5.6.37, 5.7.19CentOS (release 6.9)AnyQuery not returning expected results
873392017-08-07
12:36
2018-10-30
8:39
MySQL Server: OptimizerVerified
(1977 days)
S25.7 and 8.0, 8.0.13AnyAnyDuplicating the condition gives a different result set
876442017-09-01
22:19
2022-09-06
8:01
MySQL Server: OptimizerVerified
(2165 days)
S25.7.18CentOS (6 (x86_64))AnyOrder by on 'datetime' column not working with LIMIT <row_count>
876702017-09-05
9:32
2017-09-06
7:54
MySQL Server: OptimizerVerified
(2396 days)
S35.7.18, 5.6.37, 5.7.19AnyAnyForce index for group by is not always honored
879152017-09-29
13:47
2018-04-27
14:20
MySQL Server: OptimizerVerified
(2163 days)
S35.7.18/trunkAnyAnyConstant in multi-byte character fails to propagate to dependent subquery
879472017-10-03
4:00
2018-06-11
19:57
MySQL Server: OptimizerVerified
(2363 days)
S55.7.19AnyAnyOptimizer chooses ref over range when access when range access is faster
680722013-01-12
18:02
2013-01-13
15:08
MySQL Server: OptimizerVerified
(4093 days)
S25.1, 5.5Any (Win64, CentOS Linux)AnyMySQL 5.1 issue with timediff, group by on multiple columns, join, primary key
681542013-01-23
13:07
2016-10-09
20:45
MySQL Server: OptimizerVerified
(4082 days)
S35.6.*AnyAnyexplain output 'Using index condition' not proper
685542013-03-03
16:16
2022-03-14
16:43
MySQL Server: OptimizerVerified
(4029 days)
S55.6.10AnyAnyOptimizer wrongly choses covering index over ICP
685642013-03-04
21:17
2016-02-10
16:45
MySQL Server: OptimizerVerified
(4041 days)
S25.5.8-logAnyAnyROLLUP-NULL sometimes becomes other than NULL
688252013-04-01
16:28
2018-07-11
15:09
MySQL Server: OptimizerVerified
(3132 days)
S55.6.10AnyAnyperformance regressions for single-threaded workloads
688522013-04-03
9:27
2013-04-03
9:41
MySQL Server: OptimizerVerified
(4013 days)
S35.5.28AnyAnyWrong behavior with aggregate functions, dates and between
688992013-04-09
9:38
2013-04-10
11:00
MySQL Server: OptimizerVerified
(4006 days)
S35.5.30, 5.6.10LinuxAnyHigh join_buffer_size prevents use of spatial index on joined tables
689192013-04-10
14:25
2013-04-10
14:33
MySQL Server: OptimizerVerified
(4006 days)
S55.6.10AnyAnyPerformance regression when DS-MRR is used for query with small limit
689792013-04-17
3:47
2018-07-11
15:11
MySQL Server: OptimizerVerified
(3964 days)
S55.6.10LinuxAnyperformance regression of MySQL 5.6.10?
692032013-05-11
17:35
2020-12-06
20:45
MySQL Server: OptimizerVerified
(3794 days)
S35.7Linux (Ubuntu 12.04 64-bit)AnyValgrind warnings and crash on select from an InnoDB table
692192013-05-13
20:14
2013-05-13
20:32
MySQL Server: OptimizerVerified
(3973 days)
S55.6.12AnyAnyCREATE TEMPORARY TABLE ... SELECT is slower on 5.6 than on 5.1
692852013-05-20
3:48
2013-06-10
10:28
MySQL Server: OptimizerVerified
(3945 days)
S35.5+AnyAnycount upon not null field can not treated as count(*)
693502013-05-30
5:44
2014-02-20
5:48
MySQL Server: OptimizerVerifiedS55.6AnyAnyperformance regression between 5.5 and 5.6 for simple statement in routine loop
695672013-06-25
8:44
2016-06-16
20:30
MySQL Server: OptimizerVerified
(2843 days)
S35.6.12AnyAnyEXPLAIN FORMAT=JSON lists subquery in optimized_away_subqueries, but it is run
697292013-07-12
2:18
2018-07-12
12:54
MySQL Server: OptimizerVerified
(3913 days)
S25.5.31, 5.5.32AnyAnyBad interaction between MIN/MAX and "NOT BETWEEN" leads to wrong results
697952013-07-19
17:54
2016-06-16
20:32
MySQL Server: OptimizerVerified
(2843 days)
S35.6.12AnyAnyEXPLAIN FORMAT=JSON doesn't show Using filesort for UNIONs
698912013-08-01
6:33
2014-09-18
21:25
MySQL Server: OptimizerVerifiedS35.1.31AnyAnysince 5.1.31 REPLACE() function concats it's results under certain conditions
703142013-09-12
12:28
2013-09-12
14:07
MySQL Server: OptimizerVerified
(3851 days)
S35.6AnyAnyAmbiguous column updated with UPDATE ... JOIN ... USING
703572013-09-16
17:35
2013-11-21
14:09
MySQL Server: OptimizerVerified
(3781 days)
S25.6.13AnyAnyUse of group_concat causes having conditions to be ignored
703592013-09-16
23:02
2013-09-17
7:10
MySQL Server: OptimizerVerified
(3846 days)
S35.1, 5.5, 5.6, 5.7AnyAnyWrong result (missing rows) with group by, multi-part key, equality conditions
704662013-09-30
7:24
2013-09-30
8:45
MySQL Server: OptimizerVerified
(3833 days)
S25.5,5.6AnyAnyNo results when filesorting with a correlation in subquery's HAVING clause
704912013-10-02
19:04
2013-10-02
20:35
MySQL Server: OptimizerVerified
(3831 days)
S25.6.13AnyAnySELECT DISTINCT may return a wrong result if a join buffer is involved
705552013-10-08
17:29
2013-10-09
8:03
MySQL Server: OptimizerVerified
(3824 days)
S35.6.14AnyAnyEXPLAIN for INSERT ... SELECT waits for table lock
705982013-10-10
22:19
2013-10-13
11:23
MySQL Server: OptimizerVerified
(3820 days)
S35.5.32,5.5.34, 5.6.14, 5.7.2Linux (.6.18-348.16.1.el5)AnyPremature expression evaluation prevents short-circuited conditionals
706262013-10-15
22:08
2017-07-17
13:18
MySQL Server: OptimizerVerified
(3817 days)
S35.1+Linux (Ubuntu 12.04)Anyselect * from t where exists (select * from t limit 0); returns rows
725012014-05-01
17:31
2014-05-01
18:12
MySQL Server: OptimizerVerifiedS35.6.17AnyAnyjoining NULLs + different collation is not efficient
725322014-05-04
19:26
2014-05-05
8:42
MySQL Server: OptimizerVerified
(3616 days)
S35.6.12, 5.6.19AnyAnyDESCRIBE with FULLTEXT does Key=MUL incorrectly
726462014-05-14
9:40
2014-05-14
12:17
MySQL Server: OptimizerVerified
(3607 days)
S35.5 5.6, 5.6.19AnyAnyA strange result from explain query
727112014-05-21
18:33
2014-05-22
8:33
MySQL Server: OptimizerVerified
(3599 days)
S25.5.31, 5.5.38AnyAnyHOUR() of a DATETIME with date zero occasionally (unpredictably) returns NULL
727452014-05-26
4:28
2014-05-26
5:48
MySQL Server: OptimizerVerified
(3595 days)
S25.5.37, 5.5.38AnyAnyWrong Results When Using Intersect
728142014-05-30
9:31
2014-07-18
18:56
MySQL Server: OptimizerVerified
(3588 days)
S35.6.17AnyAnyAssertion `!(ordered_index_usage == ordered_index_void && ... fails
728152014-05-30
11:06
2014-05-31
14:24
MySQL Server: OptimizerVerified
(3591 days)
S55.1, 5.5, 5.6, 5.7AnyAnyUPDATE ... WHERE ... ORDER BY... always does a filesort even if not required
728922014-06-05
16:27
2014-06-09
9:39
MySQL Server: OptimizerVerified
(3581 days)
S3AnyAnyPlease allow multiple ranges in the LIMIT clause
729962014-06-13
6:08
2015-04-10
7:07
MySQL Server: OptimizerVerified
(3276 days)
S35.6.16, 5.6.19, 5.6.18,5.6.23AnyAnydesc error on convert
730462014-06-19
2:42
2016-02-17
11:23
MySQL Server: OptimizerVerified
(3571 days)
S35.6.19AnyAnyOptimizer chooses wrong plan with (const, range) order by range ASC
730942014-06-24
12:24
2014-06-25
8:26
MySQL Server: OptimizerVerified
(3565 days)
S25.5, 5.6, 5.6.19, 5.7.5LinuxAnyMySQL uses all partitions instead necessary ones when using CASE THEN ELSE END
731362014-06-27
16:34
2015-05-20
15:16
MySQL Server: OptimizerVerified
(3560 days)
S35.6.12,5.6.19,5.5, 5.5.38, 5.5.20AnyAnyIndex scan incorrectly selected over ref+sort leading to x1000 worse performance
732842014-07-13
19:12
2014-07-14
8:47
MySQL Server: OptimizerVerified
(3546 days)
S15.5.35, 5.5.38AnyAnyWrong query result when search from 2 related views
733572014-07-22
14:42
2014-07-22
19:10
MySQL Server: OptimizerVerified
(3538 days)
S35.6, 5.7AnyAnyWrong result on query involving information_schema
736032014-08-15
14:28
2015-05-04
13:17
MySQL Server: OptimizerVerified
(3362 days)
S55.6.20, 5.6.24Windows (Server 2012 R2)AnyMySQL 5.6.20 Not Using Index
738252014-09-06
16:45
2014-11-06
11:39
MySQL Server: OptimizerVerified
(3492 days)
S35.1, 5.5, 5.6, 5.7AnyAnyWrong result (extra row) with group by, multi-part key
739072014-09-12
18:27
2014-09-14
3:51
MySQL Server: OptimizerVerified
(3484 days)
S25.5/5.6/5.7Windows (Server 2008)AnyREGRESSION: Indexes miss on quoted large numeric bigints
740492014-09-24
8:01
2014-09-24
10:01
MySQL Server: OptimizerVerified
(3474 days)
S35.6.19-67.0, 5.6.22AnyAnyUpdate query use filesort instead of index
740782014-09-25
16:15
2014-10-16
19:49
MySQL Server: OptimizerVerified
(3452 days)
S55.6.19/5.5/5.7Linux (Ubuntu 14)Anyjoin of large table to small table is slow if small table has less than 7 rows
740832014-09-25
18:11
2014-10-09
12:58
MySQL Server: OptimizerVerified
(3459 days)
S55.6.20, 5.6.22Linux (CentOS 6.5)AnyENUM index scan is slower than INT index scan
741052014-09-26
12:16
2014-09-26
12:55
MySQL Server: OptimizerVerified
(3472 days)
S35.5.38-0ubuntu0.14.04.1, 5.5.41, 5.1.74LinuxAnyQualified comparisons return true when subquery contains nulls
742512014-10-07
14:54
2014-10-07
15:55
MySQL Server: OptimizerVerified
(3461 days)
S35.1/5.5/5.6AnyAnySyntax error when using DUAL dummy table in UNION subselect with ORDER BY
742562014-10-07
22:43
2015-11-02
6:19
MySQL Server: OptimizerVerified
(3362 days)
S25.6.19, 5.6.22AnyAnyindex_extensions used incorrectly in select cause performance regression
744622014-10-20
19:26
2014-11-01
0:57
MySQL Server: OptimizerVerified
(3436 days)
S35.6.21AnyAnyEXPLAIN FORMAT=JSON produces ordering_operation when no ordering takes place.
744902014-10-22
2:08
2014-10-22
6:57
MySQL Server: OptimizerVerified
(3446 days)
S35.6.20-debug, 5.6.22Linux (CentOS 7)AnyAssertion `table->key_read == 0' failed | sig 6 in close_open_tables
745422014-10-24
10:05
2014-10-24
10:51
MySQL Server: OptimizerVerified
(3444 days)
S35.6/5.7AnyAnyFLUSH TABLES WITH READ LOCK blocks EXPLAIN UPDATE/DELETE/INSERT
745432014-10-24
10:11
2017-06-29
5:47
MySQL Server: OptimizerVerified
(3444 days)
S35.6/5.7, 5.7.18AnyAnyread_only=1 prevents EXPLAIN UPDATE/DELETE/INSERT
746612014-11-02
20:20
2016-06-16
20:44
MySQL Server: OptimizerVerified
(2843 days)
S35.6.21, 5.6.22, 5.7.6AnyAnyEXPLAIN FORMAT=JSON says two temptables are used, execution shows just one
747442014-11-07
22:45
2016-06-16
20:45
MySQL Server: OptimizerVerified
(2843 days)
S35.6.21, 5.6.22, 5.7.6AnyAnyEXPLAIN FORMAT=JSON produces duplicates_removal where there is none
749622014-11-21
13:24
2014-11-21
14:20
MySQL Server: OptimizerVerified
(3416 days)
S35.5/5.6AnyAnyMatching in char field type is not correct
751212014-12-05
18:25
2014-12-08
8:26
MySQL Server: OptimizerVerified
(3402 days)
S25.6.21Linux (CentOS 5.11)AnyIN clause subquery optimization
752662014-12-18
16:36
2014-12-18
18:19
MySQL Server: OptimizerVerified
(3389 days)
S25.6.19AnyAnySetting sum of decimal field on user defined variable is not working as expected
754472015-01-08
12:59
2015-01-08
13:27
MySQL Server: OptimizerVerified
(3368 days)
S25.6, 5.6.24, 5.7.6AnyAnyINSERT into a view sometimes ignores default values
755102015-01-15
0:36
2015-01-16
9:59
MySQL Server: OptimizerVerified
(3360 days)
S35.6.21AnyAnyMySQL chooses index scan over full table scan
756682015-01-28
16:21
2015-01-28
20:10
MySQL Server: OptimizerVerified
(3348 days)
S25.6.22/5.7FreeBSD (FreeBSD 8.4)AnyUse of Distinct, Group_concat, and Group by together produces 1 NULL row result.
759672015-02-19
12:45
2015-02-20
8:06
MySQL Server: OptimizerVerified
(3325 days)
S35.6, 5.7, 5.6.24AnyAnyWrong result (extra rows) with SQ and comparison to NULL, materialization=off
759912015-02-21
18:12
2015-02-23
9:59
MySQL Server: OptimizerVerified
(3322 days)
S35.6.14-log, 5.6.24Windows (Vista)Anywrit of ALLOW_INVALID_DATES
759922015-02-21
18:29
2015-02-23
9:45
MySQL Server: OptimizerVerified
(3322 days)
S35.6.14-log, 5.6.24Windows (Vista)Anyno warning when, under "ALLOW_INVALID_DATES", an invalid date is discarded
760292015-02-24
14:26
2015-02-24
15:52
MySQL Server: OptimizerVerified
(3321 days)
S35.6.23LinuxAnyIN / NOT IN doesn't return correct result when on-disk temporary table is used
765012015-03-27
6:50
2015-03-27
15:11
MySQL Server: OptimizerVerified
(3290 days)
S35.6.22AnyAny"select + distinct + group by " works incorrectly
766042015-04-07
4:29
2015-04-07
6:15
MySQL Server: OptimizerVerified
(3279 days)
S35.6.23, 5.6.24, 5.6.25, 5.7.8Linux (CentOS 7)AnyAssertion `length > 0 && keyparts != 0' failed in create_ref_for_key
766792015-04-13
15:48
2017-02-01
14:28
MySQL Server: OptimizerVerified
(3272 days)
S35.6, 5.6.24, 5.6.25, 5.7.8AnyAnyEXPLAIN incorrectly shows Distinct for tables using join buffer
767552015-04-20
12:35
2015-04-25
13:23
MySQL Server: OptimizerVerified
(3261 days)
S25.6.24AnyAnyQuery execution plan / indexes problem
706842013-10-22
8:13
2013-10-22
11:35
MySQL Server: OptimizerVerified
(3811 days)
S35.5.33, 5.6.14AnyAnyHAVING referring to subquery results in WARNING 1292
708862013-11-12
10:42
2013-11-12
11:02
MySQL Server: OptimizerVerified
(3790 days)
S35.5.32, 5.6AnyAnyMIN/MAX optimizer doesn't take into account type conversions
709012013-11-13
20:18
2013-11-14
18:02
MySQL Server: OptimizerVerified
(3788 days)
S35.5.31, 5.5.35, 5.1.71, 5.0.97, 5.6.15AnyAnyORDER BY of a TEXT column doesn't use the same ordering as the < > = operators
710272013-11-27
19:50
2013-11-28
13:31
MySQL Server: OptimizerVerified
(3774 days)
S35.6.11, 5.6.14AnyAnyFull-scan UPDATE is EXPLAINED confusingly
711402013-12-13
9:16
2015-07-31
8:59
MySQL Server: OptimizerVerified
(3164 days)
S25.1, 5.5, 5.6.15, 5.7.7AnyAnyOptimizer does NOT use range checks in typical self-join for InnoDB tables
« Show Previous 1000 Entries Showing 1001-2000 of 7284 (Edit, Save, CSV, Feed) Show Next 1000 Entries »