Showing all 769 (Edit, Save, CSV, Feed) |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
14350 | 2005-10-26 20:08 | 2006-03-24 6:23 | MySQL Server: Partitions | Closed (6606 days) | S1 | 5.1.2-alpha-debug | Linux (SUSE 10.0) | Any | Partitions: crash if prepared statement |
14356 | 2005-10-26 20:18 | 2007-11-02 15:36 | MySQL Server: Partitions | Closed (6018 days) | S1 | 5.1.2-alpha-debug | Linux (SUSE 10.0) | Any | BUG:Partitions: crash if range((select)) |
14526 | 2005-10-31 21:19 | 2006-03-15 9:00 | MySQL Server: Partitions | Closed (6615 days) | S1 | 5.1.2-alpha-debug | Linux (SUSE 10.0) | Any | Partitions: indexed searches fail |
15134 | 2005-11-22 13:52 | 2005-11-22 17:13 | MySQL Server: Partitions | Duplicate (6728 days) | S1 | 5.1 | Any | Partitions: crash when creating InnoDB/BDB/NDB table with named partitions | |
15820 | 2005-12-17 5:13 | 2006-02-02 5:12 | MySQL Server: Partitions | Closed (6656 days) | S1 | 5.1-bk | Linux (Linux) | Any | Can create table with 1 partition, then doing ALTER .. ADD PARTITION crashes |
15966 | 2005-12-23 14:22 | 2006-01-24 10:45 | MySQL Server: Partitions | Closed (6665 days) | S1 | 5.1 | Any | Partitions: crash if session default engine <> engine used in create table | |
15968 | 2005-12-23 17:43 | 2006-01-20 10:55 | MySQL Server: Partitions | Closed (6669 days) | S1 | 5.1 | Any | Partitions: crash when INSERT with f1 = -1 into PARTITION BY HASH(f1) | |
16596 | 2006-01-18 9:21 | 2006-01-19 8:58 | MySQL Server: Partitions | Closed (6670 days) | S1 | 5.1-new | Linux (RH 9.0) | Any | Crash in mysql_unpack_partition in ndb_condition_pushdown test (--ps-protocol) |
16684 | 2006-01-20 19:48 | 2006-03-02 6:29 | MySQL Server: Partitions | Closed (6628 days) | S1 | 5.1.5 | Linux (RHEL) | Any | Error in calculation of partition id for RANGE partitioned tables |
17136 | 2006-02-05 16:47 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (6532 days) | S1 | 5.1.7-beta-debug | Linux (SUSE 10.0) | Any | Partitions: crash if values in (variable) |
17179 | 2006-02-07 8:38 | 2006-02-14 9:36 | MySQL Server: Partitions | Closed (6644 days) | S1 | 5.1.6-alpha | Linux (redhat9) | Any | Partitioned table creation fails with number of attributes > 32 |
17216 | 2006-02-08 0:22 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (6642 days) | S1 | 5.1.7 | Linux (Linux 32 Bit OS) | Any | SP with CREATE TABLE ... PARTITIONED ... crashes on multiple executions |
17290 | 2006-02-09 21:54 | 2006-03-24 13:51 | MySQL Server: Partitions | Closed (6606 days) | S1 | 5.1.7 | Linux (Linux 32 Bit OS) | Any | SP with delete, create and rollback to save point causes MySQLD core |
17390 | 2006-02-14 17:34 | 2006-02-28 19:34 | MySQL Server: Partitions | Closed (6630 days) | S1 | 5.1 | Any | Partitions: sporadic crash, SELECT on partitioned NDB table | |
17430 | 2006-02-15 16:38 | 2006-02-27 20:45 | MySQL Server: Partitions | Closed (6631 days) | S1 | 5.1 | Any | Partitions: crash on SELECT * FROM t1 WHERE f_int1 IS NULL | |
17432 | 2006-02-15 19:15 | 2006-02-27 20:46 | MySQL Server: Partitions | Closed (6631 days) | S1 | 5.1 | Any | Partitions: wrong result, SELECT ... where <column> is null | |
17499 | 2006-02-17 1:51 | 2006-02-28 19:37 | MySQL Server: Partitions | Closed (6630 days) | S1 | Any | Alter table of ndb partitioned tables causes mysqld to core | ||
17538 | 2006-02-18 0:37 | 2006-02-18 0:43 | MySQL Server: Partitions | Can't repeat (6640 days) | S1 | 5.0.6-alpha | Linux (linux 2.4, 2.6) | Any | Dropping a partition on a RANGE partition results in OOM error |
17631 | 2006-02-21 23:07 | 2006-04-02 6:42 | MySQL Server: Partitions | Closed (6597 days) | S1 | 5.1.5-alpha-nt-max/5.1.8 BK | Windows (Windows XP/Suse Linux) | Any | SHOW TABLE STATUS reports wrong engine |
17744 | 2006-02-27 16:52 | 2006-03-24 13:56 | MySQL Server: Partitions | Closed (6606 days) | S1 | 5.1 | Any | Partitions: InnoDB, Trigger, rotten table leads to wrong result sets | |
17772 | 2006-02-28 12:59 | 2006-03-16 19:34 | MySQL Server: Partitions | Closed (6614 days) | S1 | 5.1.8 | Linux (Linux 32 Bit OS) | Any | ALTER table rename + add column of partitioned cause mysqld to core |
17894 | 2006-03-03 12:00 | 2006-03-15 12:52 | MySQL Server: Partitions | Closed (6615 days) | S1 | 5.1.7 | Linux (Linux, Windows) | Any | Comparison with "less than" operator fails with Range partition |
17992 | 2006-03-06 20:53 | 2006-04-24 16:43 | MySQL Server: Partitions | Closed (6575 days) | S1 | 5.1 | Any | Partitions: InnoDB, somehow rotten table after UPDATE | |
18025 | 2006-03-07 12:35 | 2006-04-02 6:51 | MySQL Server: Partitions | Closed (6597 days) | S1 | 5.1 | Any | Partitions: Alter col. used for part. function, SELECT with wrong result set | |
18070 | 2006-03-08 13:43 | 2006-03-29 7:52 | MySQL Server: Partitions | Closed (6601 days) | S1 | 5.1 | Any | Partitions: wrong result on WHERE ... IS NULL | |
18139 | 2006-03-10 17:11 | 2007-11-02 15:51 | MySQL Server: Partitions | Closed (6018 days) | S1 | 5.1.8-debug | Linux (SuSE 9.3) | Any | SELECT * FROM information_schema.tables crashes server |
18198 | 2006-03-13 18:17 | 2007-07-12 12:18 | MySQL Server: Partitions | Closed (6131 days) | S1 | 5.1 | Any (all) | Any | Expressions are allowed as partition functions |
18329 | 2006-03-18 14:17 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (6606 days) | S1 | 5.1.7,5.1.8 | Linux (Linux) | Any | subpartitioning by HASH cuts the results |
18423 | 2006-03-22 14:47 | 2006-04-12 1:02 | MySQL Server: Partitions | Closed (6587 days) | S1 | 5.1.7, 5.1.8 | Linux (Linux) | Any | partition by hash cuts the results |
18572 | 2006-03-28 9:18 | 2006-04-16 14:45 | MySQL Server: Partitions | Closed (6583 days) | S1 | 5.1 | Any | Partitions: crash on ALTER TABLE during stress testing | |
18659 | 2006-03-30 17:09 | 2006-04-04 16:50 | MySQL Server: Partitions | Closed (6595 days) | S1 | 5.19-BK, 5.1 | Linux (Linux) | Any | Partitions: wrong result on WHERE <col. used in part. function> IS NULL |
18730 | 2006-04-03 8:54 | 2006-05-25 23:57 | MySQL Server: Partitions | Closed (6544 days) | S1 | 5.1 | Any | Partitions: NDB, crash on SELECT MIN(<unique column>) | |
19310 | 2006-04-24 20:29 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (6542 days) | S1 | 5.1 | Any | Partitions: crash when adding a partition to InnoDB table | |
19903 | 2006-05-18 8:58 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (6542 days) | S1 | 5.1-BK, 5.1.10 | Linux (Linux 9.3) | Any | Partition test program caused a crash |
20268 | 2006-06-05 13:45 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (6532 days) | S1 | 5.1.11-pre | Solaris (Solaris 8 & 9 Sparc) | Any | Test 'partition' fails with "Multiple definition of same constanant..." |
20389 | 2006-06-12 8:22 | 2006-07-19 4:08 | MySQL Server: Partitions | Closed (6489 days) | S1 | 5.1.12-BK debug, 5.1.11 | Linux (linux 2.4.20-8) | Any | use partition, server crash |
20484 | 2006-06-15 19:25 | 2006-08-03 2:21 | MySQL Server: Partitions | Closed (6474 days) | S1 | 5.1.12-beta-debug-log | Linux (Linux, SUSE 10.0 / 64-bit) | Any | Partitions: crash with explain and union |
20583 | 2006-06-20 19:05 | 2006-07-04 6:13 | MySQL Server: Partitions | Closed (6504 days) | S1 | 5.1.12 | Linux (Suse Linux 10.1) | Any | After "coalesce partition" and "add partition" client "lost connection" |
20750 | 2006-06-28 9:49 | 2006-07-04 15:03 | MySQL Server: Partitions | Can't repeat (6504 days) | S1 | 5.1.12 | Linux (Suse 10.1) | Any | ALTER ... ADD PARTITION caused a crash. |
20756 | 2006-06-28 16:33 | 2006-08-03 13:15 | MySQL Server: Partitions | Closed (6474 days) | S1 | 5.1.12 | Linux (Suse 10.1) | Any | Move of a partition with subpartitions by REORGANIZE cause a crash. |
20766 | 2006-06-29 8:09 | 2006-07-19 4:11 | MySQL Server: Partitions | Closed (6489 days) | S1 | 5.1.12 | Linux (Suse 10.1) | Any | Crash when merging 2 partitions (with subpartitions) into one. |
20767 | 2006-06-29 8:32 | 2006-07-19 4:14 | MySQL Server: Partitions | Closed (6489 days) | S1 | 5.1.12 | Linux (Suse 10.1) | Any | Crash due to split of one partition with subpartitions ino 2. |
20934 | 2006-07-10 7:23 | 2006-09-12 11:46 | MySQL Server: Partitions | Duplicate (6434 days) | S1 | 5.1.12 | Linux (Suse 10.1) | Any | Using partitions with innodb caused a crash. |
21102 | 2006-07-17 20:17 | 2006-07-18 14:34 | MySQL Server: Partitions | Can't repeat (6490 days) | S1 | 5.1.12-Beta | Linux (Suse 10.1) | Any | Merge of 2 partitions into one cause a crash. |
21143 | 2006-07-19 10:09 | 2006-09-02 4:35 | MySQL Server: Partitions | Closed (6444 days) | S1 | 5.1.12-Beta (06.07.19) | Linux (Linux, Suse 10.1) | Any | Reorganizing of subpartitions let mysqld hang. |
21173 | 2006-07-20 4:48 | 2006-09-02 4:41 | MySQL Server: Partitions | Closed (6444 days) | S1 | 5.1.12-BK, 5.1.11 | Linux (GNU/Linux) | Any | MySQL crashed after "show table status" on some range-partitioned table |
21177 | 2006-07-20 11:35 | 2006-09-11 12:03 | MySQL Server: Partitions | Duplicate (6435 days) | S1 | 5.1.12-Beta (06.07.19) | Linux (Suse 10.1) | Any | Alter partitioning methode to list caused a crash |
21210 | 2006-07-21 9:25 | 2006-10-18 10:08 | MySQL Server: Partitions | Closed (6398 days) | S1 | 5.1.12-BK | Linux (Linux, Suse 10.1) | Any | Altering the number of subpartitions to one caused the server to crash |
21211 | 2006-07-21 10:36 | 2006-12-08 15:37 | MySQL Server: Partitions | No Feedback (6347 days) | S1 | 5.1.12-Beta (06.07.19) | Linux (Suse 10.1) | Any | Alter of nb of subpartitions (table partition by list) cause a crash with innodb |
21388 | 2006-08-01 14:06 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (6472 days) | S1 | 5.1.12-Beta (06.07.19) | Linux (Suse 10.1) | Any | Delete of a bigint failed. |
24186 | 2006-11-10 13:08 | 2007-02-01 0:04 | MySQL Server: Partitions | Closed (6292 days) | S1 | 5.1.11,5.1.13 | Linux (Linux) | Any | nested query across partitions returns fewer records |
24502 | 2006-11-22 12:49 | 2007-01-15 15:22 | MySQL Server: Partitions | Closed (6309 days) | S1 | 5.1.14-BK, 5.1.12 Beta | Linux (Linux (CentOS)) | Any | reorganize partition closes connection. |
26117 | 2007-02-06 15:19 | 2007-03-01 4:51 | MySQL Server: Partitions | Closed (6264 days) | S1 | 5.1.14-Beta/5.1bk | Windows (Windows/Linux) | Any | index_merge sort-union over partitioned table crashes |
27408 | 2007-03-23 19:28 | 2007-10-16 16:42 | MySQL Server: Partitions | Closed (6035 days) | S1 | 5.1.16/5.1BK | Windows (MS Windows Server 2003) | Any | Alter table ADD partition .... with Data Directory causes MySql Server to crash |
27816 | 2007-04-13 19:11 | 2007-06-16 13:13 | MySQL Server: Partitions | Closed (6157 days) | S1 | 5.1.16, 5.1.17, 5.1.18BK | MacOS (Windows) | Any | Log tables ran with partitions crashes the server when logging is enabled. |
28477 | 2007-05-16 17:05 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5402 days) | S1 | 5.1.19, 5.1.17, 5.1.36 | Any | Any | innodb assertion and crash during alter table to add/drop partitions |
28488 | 2007-05-17 5:19 | 2007-06-15 9:27 | MySQL Server: Partitions | Closed (6158 days) | S1 | 5.1.19 | Any | Any | Incorrect information in file: './test/t1_test#.frm' |
28490 | 2007-05-17 6:35 | 2022-09-04 20:45 | MySQL Server: Partitions | Duplicate (6148 days) | S1 | 5.1.19 | Any | Any | crash in handler.cc, handler::print_error(int error, myf errflag) |
30583 | 2007-08-23 1:33 | 2007-10-22 18:20 | MySQL Server: Partitions | Closed (6029 days) | S1 | 5.1.22 | Any | Any | Partition on DOUBLE key + INNODB + count(*) == crash |
30695 | 2007-08-29 15:13 | 2007-11-15 13:08 | MySQL Server: Partitions | Closed (6005 days) | S1 | 5.1+ | Any | Any | Apostrophe in PARTITION clause comment crashes the server |
30878 | 2007-09-06 20:51 | 2007-11-16 12:49 | MySQL Server: Partitions | Closed (6004 days) | S1 | 5.1, 6.0 | Any | Any | Partitioning: Crash when alter an auto_increment table to partitioned |
32091 | 2007-11-04 21:03 | 2007-11-15 14:52 | MySQL Server: Partitions | Closed (6005 days) | S1 | 5.1.23-rc-debug | Linux (SUSE 10 64-bit) | Any | Partitions: Security Breach via directory changes |
32178 | 2007-11-08 6:47 | 2007-12-14 15:46 | MySQL Server: Partitions | Closed (5976 days) | S1 | 5.1.23 | Any | Any | server crash when select from i_s and concurrent partition management |
32585 | 2007-11-21 17:27 | 2007-11-24 0:13 | MySQL Server: Partitions | Can't repeat (5996 days) | S1 | 5.1.23 | MacOS | Any | concurrent DDL on partitioned tables causes threads to hang |
32772 | 2007-11-27 14:36 | 2007-12-14 16:45 | MySQL Server: Partitions | Closed (5976 days) | S1 | 5.1.23-debug | Any | Any | partition crash 1: enum column and double |
32854 | 2007-11-29 17:59 | 2008-07-03 11:43 | MySQL Server: Partitions | Can't repeat (5774 days) | S1 | 5.1.22-rc | Linux (centos 5) | Any | crash when using alter table partition then selecting |
33429 | 2007-12-21 2:23 | 2008-03-27 22:02 | MySQL Server: Partitions | Closed (5872 days) | S1 | 5.1.22 | FreeBSD (6.1) | Any | Inndob innodb_file_per_table drop and add partition -> lost of other partition |
33483 | 2007-12-22 18:41 | 2008-01-03 18:02 | MySQL Server: Partitions | Can't repeat (5956 days) | S1 | 5.1.22 | Any | Any | After partition a INNODB table, order desc by primary key is broken |
34426 | 2008-02-08 17:09 | 2008-02-08 17:13 | MySQL Server: Partitions | Closed (5920 days) | S1 | Any | Any | parts.partition_bit_myisam.test produces valgrind warnings | |
37235 | 2008-06-05 18:16 | 2018-09-09 20:45 | MySQL Server: Partitions | Duplicate (5784 days) | S1 | 5.1.24-rc | Linux (Ubuntu LTS 8.04 server, Mysql binaries) | Any | Incorrect count in MyISAM partitioned table when using index |
38797 | 2008-08-14 13:30 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (5725 days) | S1 | 5.1-bzr | Any (Linux) | Any | Assertion (inited==RND) failed in handler::ha_rnd_end |
39084 | 2008-08-28 4:07 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5644 days) | S1 | 5.1.25-rc, 5.1.28, 5.1, 6.0 bzr | Linux (CentOS 4.4 2.6.9-42.0.3) | Any | Getting intermittent errors with statement-based binary logging |
39422 | 2008-09-12 16:10 | 2008-10-13 20:09 | MySQL Server: Partitions | No Feedback (5672 days) | S1 | 5.1.26 | Windows (2003 sp2) | Any | after kill processs > mysql - replication tables crash > automatic repair fails |
39486 | 2008-09-16 17:11 | 2008-09-17 7:41 | MySQL Server: Partitions | Closed (5698 days) | S1 | 5.1.26 | Windows (2003 sp2) | Any | different select results in partitioned and unpartioned tables |
40389 | 2008-10-29 10:15 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5573 days) | S1 | 5.1, 6.0 bzr | Any | Any | REORGANIZE PARTITION crashes when only using one partition |
40494 | 2008-11-04 11:51 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5644 days) | S1 | 5.1.29/6.0 | Any | Any | MYSQL server crashes on range access with partitioning and order by |
40972 | 2008-11-24 10:54 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5573 days) | S1 | 5.1+ | Any | Any | Partition pruning can lead to crash for bad dates |
41839 | 2009-01-03 13:03 | 2011-02-16 23:43 | MySQL Server: Partitions | Duplicate (5590 days) | S1 | 5.1.29 | Windows (2008) | Any | Crash in mysqld.exe!ha_partition::handle_ordered_next()[ha_partition.cc:4520] |
42849 | 2009-02-13 21:17 | 2012-08-06 11:13 | MySQL Server: Partitions | Closed (5154 days) | S1 | 5.1.30, 5.1.32, 5.1.41, 6.0.9 | Any | Any | innodb crash with varying time_zone on partitioned timestamp primary key |
43809 | 2009-03-23 19:12 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5510 days) | S1 | Community 5.1.30 | Any | Any | Select Distinct with Where clause generated error 1178 (42000) |
44108 | 2009-04-06 9:47 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5292 days) | S1 | 6.0-bzr,5.4 | Any | Any | Assertion bitmap_is_set in ha_partition::end_bulk_insert on slave |
44657 | 2009-05-05 7:14 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (5360 days) | S1 | 5.1.30, 5.1.34, 5.1.36 | Any (linux, windows) | Any | Got error 124 from storage engine when load concurrent data infile working |
44820 | 2009-05-12 12:08 | 2011-02-16 23:43 | MySQL Server: Partitions | Duplicate (5252 days) | S1 | 5.1.35-debug, 5.1.37-enterprise-commercial-advanced-debug, 5.4.4-alpha-debug | Linux | Any | Server crash in ha_external_lock with Assertion `next_insert_id == 0' failed |
44821 | 2009-05-12 13:10 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5418 days) | S1 | 5.1.33, 5.1, 6.0 bzr | Any (Linux, Sun Solaris 10) | Any | select distinct on partitioned table returns wrong results |
45807 | 2009-06-28 13:12 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5383 days) | S1 | 5.1.30, 5.1.37, 6.0.12 | Any | Any | crash accessing partitioned table and sql_mode contains ONLY_FULL_GROUP_BY |
45808 | 2009-06-28 14:11 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (5210 days) | S1 | 5.1.34, 5.1.37, 6.0.12 | Any | Any | crash during concurrent inserts and partition management statements |
45816 | 2009-06-29 5:42 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5161 days) | S1 | 5.1.30-debug, 5.1.37-debug, 6.0.12-debug | Any | Any | assertion failure with index containing DOUBLE column on partitioned table |
45823 | 2009-06-29 13:38 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5240 days) | S1 | 5.1.31, 5.1.31sp1, 5.1.34, 5.1.34sp1, 5.1.37 | Any | Any | Assertion failure in file row/row0mysql.c line 1386 |
45904 | 2009-07-02 10:43 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5154 days) | S1 | 5.1.34-community-log | Any | Any | Cannot create a key subpartition if character set of UTF8 is used |
45916 | 2009-07-02 15:08 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (5376 days) | S1 | 5.1.21, 5.1.30, 5.1.34, 5.1.37 | Any | Any | crash with subpartitioning |
46086 | 2009-07-09 13:56 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4941 days) | S1 | 5.1.37, 5.1.40,5.4.4,6.0 | Any | Any | crash when dropping a partitioned table and the original engine is disabled |
46354 | 2009-07-23 12:38 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5376 days) | S1 | 5.1,5.4 | Any | Any | Crash in partition_info::check_partition_info on inconsistent subpartitions |
46639 | 2009-08-10 22:51 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5334 days) | S1 | 5.1.36 | Any | Any | 1030 (HY000): Got error 124 from storage engine on INSERT ... SELECT ... |
46922 | 2009-08-25 17:07 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5240 days) | S1 | 5.1.30, 5.1.37, 5.1.39 | Any | Any | crash when adding partitions and open_files_limit is reached |
47029 | 2009-08-31 19:42 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (5257 days) | S1 | 5.1.37-1/5.4.4 | Linux (32-bit Ubuntu 9.04 (kernel: 2.6.28-11-generic)) | Any | Server crash when reorganizing two partitions into one with same name as the 2nd |
47343 | 2009-09-16 1:23 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5057 days) | S1 | 5.1.38 | Any | Any | InnoDB fails to clean-up after lock wait timeout on REORGANIZE PARTITION |
49122 | 2009-11-26 6:08 | 2011-02-16 23:44 | MySQL Server: Partitions | No Feedback (5204 days) | S1 | 5.1.33 | Any (Linux and windows) | Any | large numbers of tables(198*18 + 301) to cause table crash and so on |
49754 | 2009-12-17 0:17 | 2013-01-16 11:33 | MySQL Server: Partitions | Closed (4116 days) | S1 | 5.1.41 | Any | Any | Partitioning by RANGE with TO_DAYS always includes first partition when pruning |
50418 | 2010-01-18 15:19 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (4963 days) | S1 | 5.1+, 5.5.99 | Any | Any | DROP PARTITION does not interact with transactions |
51183 | 2010-02-15 11:37 | 2010-02-15 16:51 | MySQL Server: Partitions | Not a Bug (5182 days) | S1 | 5.1.43 | Linux (debian etch) | Any | bug when creating a partitionned table by key with more than 497 partitions |
51279 | 2010-02-18 10:33 | 2010-02-18 10:58 | MySQL Server: Partitions | Not a Bug (5179 days) | S1 | 5.1.43 | Linux | Any | Constant, random or timezone-dependent expressions in (sub)p |
51347 | 2010-02-20 13:56 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5140 days) | S1 | 5.5.1-m2-debug,5.5.99-m3-debug | Any | Any | assertion with show create table + partition by columns on decimal column |
53685 | 2010-05-16 20:56 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (4993 days) | S1 | 5.5.3, 5.5.4 | Linux | Any | Partition pruning for dates does not work in 5.5.3 and 5.5.4 |
54483 | 2010-06-14 11:40 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4837 days) | S1 | 5.1.47, 5.1.49-bzr | Any | Any | valgrind errors when making warnings for multiline inserts into partition |
56287 | 2010-08-26 11:50 | 2011-05-27 12:59 | MySQL Server: Partitions | Closed (4877 days) | S1 | 5.1.50, 5.1.51-bzr ,5.5.6 | Linux (suse 10 x64 and centos 5.5 x64) | Any | mysql5.1.50 crash when using Partition datetime in sub in query |
56484 | 2010-09-02 8:02 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4881 days) | S1 | 5.6.0-m4-debug | Any | Any | !table || (!table->read_set || bitmap_is_set(table->read_set, field_index)) |
57071 | 2010-09-28 14:46 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (4853 days) | S1 | 5.1+, 5.5.7-bzr | Any | Any | EXTRACT(WEEK from date_col) cannot be allowed as partitioning function |
57890 | 2010-11-01 11:17 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4881 days) | S1 | 5.1.53-debug, 5.5.8-debug | Any | Any | Assertion failed: next_insert_id == 0 with on duplicate key update |
59503 | 2011-01-14 13:55 | 2011-03-17 17:09 | MySQL Server: Partitions | Closed (4787 days) | S1 | 5.6.2 | Any | Any | explain extended crash in get_mm_leaf |
60039 | 2011-02-09 9:17 | 2011-03-10 11:42 | MySQL Server: Partitions | Closed (4794 days) | S1 | 5.6.2 | Any | Any | crash when exchanging a partition on nonpartitioned table with a view |
60120 | 2011-02-14 9:56 | 2011-03-27 23:00 | MySQL Server: Partitions | No Feedback (4777 days) | S1 | 5.1.48-community-log | Windows | Any | MY sql partition rebuild causes mysqld service crash |
61765 | 2011-07-06 1:46 | 2011-12-18 23:16 | MySQL Server: Partitions | Closed (4511 days) | S1 | 5.5.8, 5.5.11, 5.5.13 | Any | Any | Wrong query results on subpartitions based on USIGNED BIGINT |
66011 | 2012-07-25 16:21 | 2012-07-29 15:55 | MySQL Server: Partitions | Duplicate (4287 days) | S1 | 5.5.25a | Linux | Any | server crash |
66161 | 2012-08-02 14:55 | 2012-08-02 15:03 | MySQL Server: Partitions | Duplicate (4283 days) | S1 | 5.5.24 | Any | Any | partition by range on multiple col. primary key w/ no maxvalue restarts server |
68056 | 2013-01-09 11:00 | 2013-01-09 11:13 | MySQL Server: Partitions | Unsupported (4123 days) | S1 | 6.0.11 | Windows | Any | PARTITION BY RANGE COLUMNS |
69522 | 2013-06-20 11:34 | 2013-06-20 18:48 | MySQL Server: Partitions | Not a Bug (3961 days) | S1 | 5.5.20 | Linux (Creata range partition using user defind function) | Any | Creata range partition using user defind function |
70001 | 2013-08-12 18:46 | 2017-06-23 9:11 | MySQL Server: Partitions | Closed (3822 days) | S1 | 5.6.13 | Any | Any | Partitioned tables do not use ICP - severe performance loss after partitioning |
72287 | 2014-04-09 9:02 | 2018-05-17 1:00 | MySQL Server: Partitions | No Feedback (2170 days) | S1 | 5.6.16-log | Solaris (s10x_u10wos_17b) | Any | mysqld crash during REORGANIZE PARTITION |
72803 | 2014-05-29 22:48 | 2014-07-01 1:00 | MySQL Server: Partitions | No Feedback (3586 days) | S1 | 5.6 | Any | Any | Wrong "Impossible where" with LIST partitioning |
78260 | 2015-08-28 11:17 | 2016-06-18 21:27 | MySQL Server: Partitions | Closed (3144 days) | S1 | 5.7.8 (RC2), 5.7.9, 8.0.0 | Any | Any | handle_fatal_signal (sig=11) in Partition_helper::ph_read_range_first on SELECT |
78337 | 2015-09-05 6:06 | 2015-09-14 15:31 | MySQL Server: Partitions | Closed (3145 days) | S1 | 5.7.8 RC2 | Any | Any | Assertion `mp->count > 0 && my_thread_equal(my_thread_self(), mp->thread)' faile |
83435 | 2016-10-19 0:40 | 2020-09-08 22:05 | MySQL Server: Partitions | Verified (2744 days) | S1 | 5.7.15/5.6 | Any | Any | ALTER TABLE is very slow when using PARTITIONED table |
85537 | 2017-03-20 10:33 | 2019-01-23 11:53 | MySQL Server: Partitions | Unsupported (1918 days) | S1 | 5.5.54 | Any | Any | Assertion `m_index_scan_type != partition_index_last' failed. |
88639 | 2017-11-24 7:05 | 2017-11-27 9:48 | MySQL Server: Partitions | Verified (2340 days) | S1 | 5.6.38/5.7/8.0 | Any | Any | ERROR 1030 (HY000): Got error -1 from storage engine on PARTITION CREATE TABLE |
97041 | 2019-09-26 16:20 | 2019-09-28 14:33 | MySQL Server: Partitions | Verified (1670 days) | S1 | 8.0+, 8.0.17, 5.7.27 | Any | Any | main&sub partition field order different from combined pk, query result lose row |
100810 | 2020-09-11 8:11 | 2020-09-14 18:46 | MySQL Server: Partitions | Verified (1318 days) | S1 | MySQL8.0.20 | Any (rhel-7.4) | Any (intel x86) | miss to check table definition for partitioned table while importing tablespace |
105014 | 2021-09-23 3:32 | 2021-09-23 15:33 | MySQL Server: Partitions | Verified (944 days) | S1 | 8.0.25, 8.0.26, 8.0.11, 5.7.35 | Any (rhel-7.4) | Any (x86-64) | query gets incorrect resultset from table with subpartitions |
112738 | 2023-10-16 9:26 | 2023-10-16 9:35 | MySQL Server: Partitions | Verified (191 days) | S1 | 8.0.30, 8.0.34 | Any | Any | can't truncate partition when partition_id exceed INT_MAX |
13520 | 2005-09-27 11:34 | 2006-04-02 6:19 | MySQL Server: Partitions | Closed (6597 days) | S2 | 5.1.2-a_drop5p4-log | Linux (Linux) | Any | Quoted partition options fail with syntax error |
13644 | 2005-09-30 9:47 | 2006-01-20 10:45 | MySQL Server: Partitions | Closed (6669 days) | S2 | 5.1.2-a_drop5p4-log | Linux (SuSE Linux 10.0) | Any | DROP PARTITION truncates DATE columns |
14327 | 2005-10-26 11:22 | 2006-01-19 9:21 | MySQL Server: Partitions | Closed (6670 days) | S2 | 5.1.2 (pulled 2005-10-20) | Linux (SuSE 9.3, SuSE 10) | Any | PARTITIONS clause not shown in SHOW CREATE TABLE output |
15393 | 2005-12-01 16:25 | 2006-02-02 14:09 | MySQL Server: Partitions | Closed (6656 days) | S2 | mysql-5.1.4-alpha | Linux (linux) | Any | range partitioning puts records in the wrong partition |
15819 | 2005-12-17 4:56 | 2005-12-28 14:30 | MySQL Server: Partitions | Closed (6692 days) | S2 | 5.1-bk | Linux (Linux) | Any | LIST partitioning: crash on attempt to insert a value < lowest_list_const |
15961 | 2005-12-23 12:13 | 2006-03-15 9:06 | MySQL Server: Partitions | Closed (6615 days) | S2 | 5.1 | Any | Partitions: Creation of subpart. table without subpart. rule not rejected | |
16530 | 2006-01-16 10:19 | 2006-02-08 19:08 | MySQL Server: Partitions | Can't repeat (6650 days) | S2 | 5.1.4-max | Windows (Windows 2000 Server) | Any | DROP PARTITION fails with OS permissions error |
16534 | 2006-01-16 13:02 | 2006-01-24 11:14 | MySQL Server: Partitions | Closed (6665 days) | S2 | 5.1.6-20060116-bk | Linux (SuSE 9.3) | Any | Trying to add multiple partitions crashes server |
16695 | 2006-01-21 6:42 | 2006-02-14 10:56 | MySQL Server: Partitions | Closed (6644 days) | S2 | 5.1.6-20060118-bk | Linux (SuSE 9.3) | Any | Reading I_S.PARTITIONS with pre-5.1.6 partitioned tables crashes server |
16775 | 2006-01-25 12:04 | 2006-02-16 14:17 | MySQL Server: Partitions | Closed (6642 days) | S2 | 5.1 | Any | DROP TABLE of subpartitioned table can fail if default engine used | |
16782 | 2006-01-25 15:19 | 2006-02-16 14:20 | MySQL Server: Partitions | Closed (6642 days) | S2 | 5.1 | Any | Partitions: crash, REPLACE .. on table with PK, DUPLICATE KEY event | |
16806 | 2006-01-26 14:43 | 2006-03-27 14:09 | MySQL Server: Partitions | Closed (6603 days) | S2 | 5.1.6-alpha | Linux (Linux) | Any | ALTER TABLE fails Can't create table 'test.#sql-549f_2' (errno: 140) |
16810 | 2006-01-26 15:50 | 2006-03-16 8:12 | MySQL Server: Partitions | Closed (6614 days) | S2 | 5.1.6-alpha | Linux (Linux) | Any | ALTER TABLE test.t1 COALESCE PARTITION 4' failed: Out of memory; |
16821 | 2006-01-26 21:03 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (6609 days) | S2 | 5.1.6-alpha | Linux (Linux) | Any | ALTER TABLE test.t1 REPAIR PARTITION p0 hangs mysql-test |
16822 | 2006-01-26 21:25 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (6609 days) | S2 | 5.1.6-alpha | Linux (Linux) | Any | ALTER TABLE test.t1 OPTIMIZE PARTITION p4 hangs mysql-test |
16901 | 2006-01-30 13:14 | 2006-02-16 14:37 | MySQL Server: Partitions | Closed (6642 days) | S2 | 5.1 | Any | Partitions: crash, SELECT, column of part. function=first column of primary key | |
16907 | 2006-01-30 17:24 | 2006-02-16 14:42 | MySQL Server: Partitions | Closed (6642 days) | S2 | 5.1.6-alpha-debug-log | Any | Partitions: crash, SELECT goes into last partition, UNIQUE INDEX | |
17082 | 2006-02-02 20:28 | 2006-02-14 11:37 | MySQL Server: Partitions | Closed (6644 days) | S2 | 5.1.7 BK source | Windows (Windows) | Any | Client hangs when creating tables with partition |
17097 | 2006-02-03 12:39 | 2006-03-15 9:21 | MySQL Server: Partitions | Closed (6615 days) | S2 | 5.1 | Any | Partitions: failing ADD PRIMARY KEY leads to temporary rotten metadata,crash | |
17214 | 2006-02-08 0:05 | 2006-03-23 17:08 | MySQL Server: Partitions | Closed (6607 days) | S2 | 5.1.7 | Linux (Linux 32 Bit OS) | Any | Simple Stored Procedure produces failed: 1478: |
17304 | 2006-02-10 15:58 | 2022-09-04 20:45 | MySQL Server: Partitions | Duplicate (6622 days) | S2 | 5.1.6/5.1.7 BK | Linux (Fedora core 4) | Any | Partitioning definition dropped when switching engines |
17540 | 2006-02-18 3:52 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (6596 days) | S2 | 5.1.6/5.1.7 BK | Linux (Fedora Core 4) | Any | Partitioning by range doesn't work with dates |
17720 | 2006-02-26 1:33 | 2006-03-09 2:38 | MySQL Server: Partitions | Closed (6621 days) | S2 | 5.1.7-beta | Windows (Windows) | Any | Partition ALTER TABLE fails on rename of .MYI file |
17722 | 2006-02-26 2:06 | 2006-03-18 16:09 | MySQL Server: Partitions | Closed (6612 days) | S2 | 5.1.7-beta | Windows (Windows) | Any | Test 'partition_02myisam' hangs on Windows |
17763 | 2006-02-28 10:13 | 2006-02-28 20:00 | MySQL Server: Partitions | Closed (6630 days) | S2 | 5.1.7 | Any | mysqld cores with list partitioning if update to missing partition | |
17773 | 2006-02-28 13:00 | 2006-03-27 22:01 | MySQL Server: Partitions | Won't fix (6603 days) | S2 | 5.1 | Any | Partitioning: strange effects with Merge tables + partitioning | |
17834 | 2006-03-01 19:05 | 2006-03-02 16:18 | MySQL Server: Partitions | Can't repeat (6628 days) | S2 | 5.1.8 | Linux (Linux) | Any | ndb_partition_range.test fails |
18552 | 2006-03-27 18:55 | 2022-09-04 20:45 | MySQL Server: Partitions | Duplicate (6589 days) | S2 | 5.1 | Any | Partitions: SP with cursor, autoincrement PK, duplicate key on insert | |
18735 | 2006-04-03 10:26 | 2007-08-01 22:10 | MySQL Server: Partitions | Unsupported (6111 days) | S2 | 5.1 | Any | Any | Partitions: NDB, UNIQUE INDEX, UPDATE, strange server response |
18962 | 2006-04-10 15:19 | 2006-04-23 3:04 | MySQL Server: Partitions | Closed (6576 days) | S2 | 5.1 | Any | Partitions: Error on third ALTER TABLE t1 DROP PARTITION ..., crash | |
19107 | 2006-04-14 20:35 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (5838 days) | S2 | 5.1.10-pre | Windows (Windows 2003) | Any | Server doesn't support symlinked files on Windows |
19305 | 2006-04-24 18:56 | 2006-06-14 1:01 | MySQL Server: Partitions | Closed (6524 days) | S2 | 5.1 | Any | Partitions: COALESCE PARTITION .. does no more remove unused files | |
19421 | 2006-04-28 10:13 | 2006-05-30 1:38 | MySQL Server: Partitions | Can't repeat (6539 days) | S2 | 5.1.9/5.1BK | GNU/Linux 2.6.8-3-686-smp | Any | MySQL server crashed when deleting from a table |
19495 | 2006-05-02 21:39 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (6559 days) | S2 | 5.1.10 | Linux (Linux 32 Bit OS) | Any | default-storeage-engine=ndb causes tables by other engines to be partitioned |
19715 | 2006-05-11 9:14 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (6542 days) | S2 | 5.1.10 | Linux (Linux 9.3) | Any | Using DATA/INDEX DIRECTORY with subpartitions put files in default directory |
19721 | 2006-05-11 11:25 | 2006-06-09 7:35 | MySQL Server: Partitions | Duplicate (6529 days) | S2 | Solaris (Solaris 8+9 Sparc (32+64)) | Any | Partitioning fails on NULL | |
19801 | 2006-05-14 12:34 | 2006-06-15 11:25 | MySQL Server: Partitions | Closed (6523 days) | S2 | 5.1.10-pre | Linux (Red Hat RHAS4 x86) | Any | Test 'partition' shows read outside array in valgrind |
19813 | 2006-05-15 11:02 | 2012-09-13 7:48 | MySQL Server: Partitions | Duplicate (6539 days) | S2 | 5.1.9-beta | Linux (Linux) | Any | When MySQL fails to create a partition, the .par is not deleted |
19830 | 2006-05-15 19:33 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (6542 days) | S2 | 5.1.9/5.1BK | Linux (Fedora core 4) | Any | REORGANIZE PARTITION causes crash on 5.1.9 |
19853 | 2006-05-16 13:31 | 2006-05-16 14:33 | MySQL Server: Partitions | Duplicate (6553 days) | S2 | 5.1.9 | Linux (Fedora core 4) | Any | DATA DIRECTORY ignored in ALTER statement |
20086 | 2006-05-26 6:57 | 2006-07-04 9:18 | MySQL Server: Partitions | Closed (6504 days) | S2 | 5.1.9 | Linux (Debian Linux 2.6.8-3-686-smp) | Any | Can't get data from key partitioned tables with VARCHAR key |
20129 | 2006-05-29 18:54 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5057 days) | S2 | 5.1.19 | Any | Any | ALTER TABLE ... REPAIR PARTITION ... complains that partition is corrupt |
20355 | 2006-06-09 11:51 | 2006-07-18 14:51 | MySQL Server: Partitions | Can't repeat (6490 days) | S2 | 5.1.12 | Linux (Linux 10.1) | Any | Unexpected behaviour of ALTER...ADD PARTITION (data directory) |
20717 | 2006-06-27 9:31 | 2006-06-27 15:56 | MySQL Server: Partitions | Duplicate (6511 days) | S2 | 5.1.12 | Linux (Suse 10.1) | Any | Reorganize partition ignores directory part. |
21339 | 2006-07-29 8:35 | 2006-09-02 5:01 | MySQL Server: Partitions | Closed (6444 days) | S2 | 5.1.11/5.1BK | Linux (linux) | Any | explain partitions leads to server crash |
21349 | 2006-07-30 12:28 | 2006-08-07 7:15 | MySQL Server: Partitions | Duplicate (6470 days) | S2 | 5.1.11/5.1BK | Windows (Windows 2000) | Any | Can't Find File error when using DATA/INDEX DIRECTORY partition options |
21350 | 2006-07-30 12:48 | 2006-09-02 5:13 | MySQL Server: Partitions | Closed (6444 days) | S2 | 5.1.11 (Windows)/5.1.12-bk (Linux) | Linux (Linux/Windows) | Any | Relative path for DATA/INDEX DIRECTORY causes spurious warning & file creation |
22622 | 2006-09-23 1:43 | 2006-09-23 2:38 | MySQL Server: Partitions | Can't repeat (6423 days) | S2 | 5.1.7 | Windows (Window XP Media Center) | Any | mysqld crashes when reorganizing partitions |
22633 | 2006-09-23 22:52 | 2007-10-16 13:14 | MySQL Server: Partitions | Not a Bug (6035 days) | S2 | 5.1.12 | Linux (Linux) | Any | partitioned tables with DATA DIRECTORY option fail to change engine |
22634 | 2006-09-23 23:03 | 2006-12-14 1:56 | MySQL Server: Partitions | Closed (6341 days) | S2 | 5.1.12 | Linux (Linux) | Any | converting where DATA DIRECTORY = table directory to ARCHIVE corrupts table |
24245 | 2006-11-13 9:59 | 2006-11-25 1:24 | MySQL Server: Partitions | Not a Bug (6360 days) | S2 | 5.1.14-BK, 5.1.12 beta | Linux (Linux, Win2003Server) | Any | Partitioning on TIMESTAMP column |
24633 | 2006-11-27 21:54 | 2007-04-11 3:21 | MySQL Server: Partitions | Closed (6223 days) | S2 | 5.1.14 | Linux (Linux) | Any | SQL MODE "NO_DIR_IN_CREATE" does not work with partitioned tables |
25141 | 2006-12-18 13:35 | 2007-05-01 5:24 | MySQL Server: Partitions | Closed (6203 days) | S2 | 5.1.14-beta-community-nt | Windows (Windows 2000 Pro) | Any | Crash Server on Partitioning command |
26074 | 2007-02-05 8:24 | 2007-04-11 3:56 | MySQL Server: Partitions | Closed (6223 days) | S2 | 5.1.14-beta-community-nt/5.1BK | Windows (windows) | Any | Mysql crash when creating partitions |
26075 | 2007-02-05 8:33 | 2008-09-27 18:50 | MySQL Server: Partitions | Closed (5688 days) | S2 | 5.1.14-beta-community-nt | Windows (windows) | Any | Cant open table when too many partition is created |
26827 | 2007-03-03 20:37 | 2007-07-07 18:50 | MySQL Server: Partitions | Closed (6136 days) | S2 | 5.1, 5.2 | Any (SUSE 10.0 / 64-bit, suse9.3 x86) | Any | table->read_set is set incorrectly, causing update of a different column |
27084 | 2007-03-13 14:04 | 2007-06-27 22:40 | MySQL Server: Partitions | Closed (6146 days) | S2 | 5.1.16-beta | Any (i686 GNU/Linux kernel 2.6.17) | Any | partitioning by list seems failing when using case |
27123 | 2007-03-14 9:49 | 2007-05-09 6:05 | MySQL Server: Partitions | Closed (6195 days) | S2 | 5.1.17BK | Linux (suse 9.3 x86) | Any | partition + on duplicate key update + varchar = Can't find record in table |
27233 | 2007-03-16 23:10 | 2007-06-23 11:41 | MySQL Server: Partitions | No Feedback (6150 days) | S2 | 5.1.16 | Linux (Fedora 5 x86_64) | Any | Table crashes all over the place on Partitioned tables |
27405 | 2007-03-23 18:01 | 2007-09-04 9:03 | MySQL Server: Partitions | Closed (6077 days) | S2 | 5.1.16 | Linux (OpenSuse 10.2) | Any | Partitioning InnoDB auto_increment bug |
29444 | 2007-06-29 13:29 | 2007-10-19 8:35 | MySQL Server: Partitions | Closed (6032 days) | S2 | 5.1.20 | Any (Linux, FreeBSD) | Any | crash with partition refering to table in create-select |
29544 | 2007-07-04 10:12 | 2007-08-04 10:55 | MySQL Server: Partitions | No Feedback (6108 days) | S2 | 5.1.19-beta-log | Linux | Any | Partition table crashed |
30480 | 2007-08-17 17:49 | 2007-12-13 10:45 | MySQL Server: Partitions | Closed (5977 days) | S2 | 6.0.2-alpha | Linux (SUSE 10 64-bit) | Any | Falcon: searches fail if LIKE and key partition |
30536 | 2007-08-21 18:13 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (5998 days) | S2 | 6.0.2-alpha-debug | Linux (SUSE 10 64-bit) | Any | Falcon: searches fail if partition, index |
30573 | 2007-08-22 17:49 | 2008-03-14 9:43 | MySQL Server: Partitions | Closed (5885 days) | S2 | 5.1.22-beta-log Source distribution | Linux (maybe other os) | Any | Ordered range scan over partitioned tables returns some rows twice |
30826 | 2007-09-05 11:32 | 2008-09-20 11:53 | MySQL Server: Partitions | Duplicate (5695 days) | S2 | 6.0.2-alpha | Any | Any | Falcon - OPTIMIZE PARTITION not supported. |
31210 | 2007-09-26 17:34 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5057 days) | S2 | 5.1.20 | MacOS | Any | INSERT DELAYED crashes server when used on partitioned table |
32115 | 2007-11-05 14:59 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5162 days) | S2 | 5.5.0 | Any | Any | Bad use of Name_resolution_context from current LEX in partitioning |
32247 | 2007-11-09 20:30 | 2007-12-14 16:52 | MySQL Server: Partitions | Closed (5976 days) | S2 | 5.1.23 (pre) + 6.0.4-alpha (pre) | Linux (PPC) | Any | Test reports wrong value of "AUTO_INCREMENT" (on a partitioned InnoDB table) |
32943 | 2007-12-03 19:45 | 2008-03-28 9:33 | MySQL Server: Partitions | Closed (5871 days) | S2 | 5.1 | Any | Any | ALTER TABLE DROP PARTITION fails if trigger is present |
32948 | 2007-12-04 1:09 | 2007-12-13 10:07 | MySQL Server: Partitions | Closed (5977 days) | S2 | 5.1 | Any | Any | FKs allowed to reference partitioned table |
33555 | 2007-12-28 15:00 | 2008-10-10 13:09 | MySQL Server: Partitions | Closed (5675 days) | S2 | 5.1.26RC | Linux (CENTOS5.2) | Any | Group By Query does not correctly aggregate partitions |
33766 | 2008-01-09 13:23 | 2008-03-14 5:45 | MySQL Server: Partitions | No Feedback (5885 days) | S2 | 5.1.22 | FreeBSD (6.1) | Any | Updating the "PARTITION BY" field don't work from first time |
34039 | 2008-01-24 17:58 | 2008-01-24 18:18 | MySQL Server: Partitions | Not a Bug (5935 days) | S2 | 5.1.22-rc-community | Linux (x86_64) | Any | Can't open FRM file after creating table with > 576 partitions |
34267 | 2008-02-04 3:26 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (5921 days) | S2 | 5.1.23 | Any | Any | Server crash when droping a partition on a table with a trigger |
34358 | 2008-02-06 18:40 | 2008-03-28 9:30 | MySQL Server: Partitions | Closed (5871 days) | S2 | 5.1 | Any | Any | Can not find specified bit type primary key value in partitioned myisam table |
34710 | 2008-02-20 22:46 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (5907 days) | S2 | 5.1.23 | Any | Any | partitioning broken with auto_increment values being specified |
35385 | 2008-03-18 9:35 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (5877 days) | S2 | Mysql-5.1.23 | Windows (Xp,service Pack 2) | Any | Mysql-5.1.23-rc-community MySQL Community Server,PARTITION |
35745 | 2008-04-01 16:21 | 2008-07-23 12:41 | MySQL Server: Partitions | Closed (5754 days) | S2 | 5.1.23 | Any | Any | SELECT COUNT(*) is not correct for some partitioned tables. |
35931 | 2008-04-09 10:44 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5754 days) | S2 | 5.1.23, 5.1.25 | Linux | Any | List partition MyISAM table returns erroneous results |
36008 | 2008-04-11 22:57 | 2008-04-25 14:31 | MySQL Server: Partitions | Not a Bug (5843 days) | S2 | 5.1.23-rc-community | Any | Any | Adding a partition after the maxvalue partition breaks table |
36150 | 2008-04-16 19:02 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (5851 days) | S2 | 5.1.23-rc-win32, 5.1.24-rc | Windows (windows xp) | Any | Partitioned table in range is inaccessible |
36591 | 2008-05-08 11:04 | 2009-02-23 7:40 | MySQL Server: Partitions | Not a Bug (5539 days) | S2 | 5.1 | Any | Any | handler::get_no_parts called on a closed handler |
36604 | 2008-05-08 22:11 | 2008-05-09 17:49 | MySQL Server: Partitions | Not a Bug (5829 days) | S2 | 5.1.22 | Linux | Any | Partition pruning not pruning correctly |
36845 | 2008-05-21 8:05 | 2008-06-27 16:37 | MySQL Server: Partitions | No Feedback (5780 days) | S2 | 5.1.23-rc-community | Linux (2.6.9-67.0.4.ELsmp #1 SMP Sun Feb 3 07:06:14 EST 2008 x86_64 x86_64 x86_64 GNU/Linux) | Any | Partition with composite keys and joins |
37219 | 2008-06-05 8:10 | 2018-09-09 20:45 | MySQL Server: Partitions | Duplicate (5784 days) | S2 | 5.1.24rc, 5.1.26bk | Any | Any | MyISAM engine give wrong result when use PARTITION and IN |
37327 | 2008-06-11 4:43 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (5791 days) | S2 | 5.1.25-rc | Any | Any | range scan on partitioned table returns duplicate rows |
37329 | 2008-06-11 5:35 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (5791 days) | S2 | 5.1.25-rc | Any | Any | range scan on partitioned table shows higher Handler_read_next |
37375 | 2008-06-12 16:29 | 2008-08-11 18:43 | MySQL Server: Partitions | No Feedback (5735 days) | S2 | Ver 5.1.24-rc redhat(x86_64) | Linux (RHEL 4) | Any | partition table - index corruption |
37580 | 2008-06-23 10:47 | 2008-06-23 10:52 | MySQL Server: Partitions | Duplicate (5784 days) | S2 | 5.1.25-rc | Any | Any | Can't analyze partition table. |
38751 | 2008-08-12 15:29 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (5679 days) | S2 | 5.1.29,6.0 | Any | Any | Add partition on a archive table wipes the whole table |
38784 | 2008-08-13 21:49 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5573 days) | S2 | 5.1+ | Windows | Any | Mysql server crash if table is altered with partition changes. |
40912 | 2008-11-21 3:15 | 2011-02-16 23:43 | MySQL Server: Partitions | No Feedback (5603 days) | S2 | 5.1 | Linux | Any | partition rebuild causes differeces in rowcount |
41272 | 2008-12-05 22:17 | 2011-02-16 23:43 | MySQL Server: Partitions | No Feedback (5547 days) | S2 | 5.1.21-beta-log | Any | Any | ALTER TABLE REBUILD PARTITION doesn't cleanup on failure |
42438 | 2009-01-28 20:27 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5057 days) | S2 | 5.1,5.4 | Windows | Any | Crash ha_partition::change_table_ptr |
43134 | 2009-02-24 10:10 | 2011-02-16 23:43 | MySQL Server: Partitions | No Feedback (5278 days) | S2 | 5.1.24 and 5.1.31 | Linux (Centos 4) | Any | select with distinct or group by yields incorrect records |
43477 | 2009-03-07 20:09 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (4950 days) | S2 | 5.1.29, 5.1.32, 5.1.33 | Any | Any | Server hangs with table general log, statement binlog format and partitions |
43867 | 2009-03-25 22:10 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5162 days) | S2 | 6.0-runtime, azalea | Any | Any | ALTER TABLE on a partitioned table causes unnecessary deadlocks |
44653 | 2009-05-04 20:41 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5399 days) | S2 | 5.1, 6.0, mysql-6.0-backup | Linux | Any | Server crash noticed when executing random queries with partitions. |
45203 | 2009-05-29 23:12 | 2022-12-04 20:45 | MySQL Server: Partitions | Duplicate (5376 days) | S2 | mysql-6.0-backup, mysql-6.0 | Linux | Any | Falcon crash noticed when executing random queries with replication enabled |
45531 | 2009-06-16 13:59 | 2009-06-20 14:22 | MySQL Server: Partitions | Not a Bug (5422 days) | S2 | 5.1.32,5.1.34 | Linux (Linux/Solaris) | Any | don't correct optimizer partition's data query |
46483 | 2009-07-30 18:53 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5240 days) | S2 | 5.1.36 | Any | Any | drop table of partitioned table may leave extraneous file |
46592 | 2009-08-06 22:59 | 2011-02-16 23:44 | MySQL Server: Partitions | Can't repeat (5374 days) | S2 | 5.1.30 | Linux (Debian Linux 2.6.24-etchnhalf.1-amd64) | Any | Partition corruption leads to entire table corruption |
46909 | 2009-08-25 5:31 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (5346 days) | S2 | 5.1.37, 5.1.39-debug | Any | Any | partitioned innodb tables end up with duplicate primary key values! |
46911 | 2009-08-25 6:56 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (5342 days) | S2 | 5.1.37 | Any | Any | Inconsistent SHOW CREATE TABLE result before/after FLUSH STATUS w/ partitioning |
46923 | 2009-08-25 18:07 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5154 days) | S2 | 5.1.37, 5.1.39, 5.4.x | Any | Any | select count(*) from partitioned table fails with ONLY_FULL_GROUP_BY |
47176 | 2009-09-07 14:57 | 2012-10-24 11:12 | MySQL Server: Partitions | Duplicate (4200 days) | S2 | 5.1.37 | Any | Any | PARTITION BY RANGE with TIMESTAMP is not pruning |
47522 | 2009-09-22 14:58 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5286 days) | S2 | 5.1.39 | Linux (2.6.26) | Any | Failed make test on main.not_partition |
47764 | 2009-10-01 14:52 | 2015-08-18 17:28 | MySQL Server: Partitions | Closed (4522 days) | S2 | 5.1.39 | Any | Any | partitioned innodb tables can't be moved directly from windows to linux |
48148 | 2009-10-19 10:31 | 2011-02-16 23:44 | MySQL Server: Partitions | No Feedback (5238 days) | S2 | 5.1.34-log | Linux | Any | Can select but 1032 error when update and delete |
49477 | 2009-12-05 21:30 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4941 days) | S2 | 5.1.41-debug, 5.5.0-debug | Any | Any | Assertion `0' failed in ha_partition.cc:5530 with temporary table and partitions |
49591 | 2009-12-10 16:03 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5225 days) | S2 | 5.5 | Any | Any | Conditional definition of Column list partitions has the wrong version |
49742 | 2009-12-16 18:37 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5154 days) | S2 | 5.1.41, 5.1.37, 5.1.43,5.5.0 | Any | Any | Partition Pruning not working correctly for RANGE |
49808 | 2009-12-18 17:12 | 2009-12-18 17:31 | MySQL Server: Partitions | Not a Bug (5241 days) | S2 | 5.1.37-log | Linux | Any | partitioning data directory and index directory clause do not work |
49861 | 2009-12-21 22:01 | 2009-12-29 13:35 | MySQL Server: Partitions | Not a Bug (5230 days) | S2 | 5.5 | Linux (debian etch) | Any | RANGE COLUMNS does not work as it should |
49881 | 2009-12-22 16:20 | 2011-02-16 23:44 | MySQL Server: Partitions | Won't fix (4859 days) | S2 | 5.1.41, 5.1.42, 5.5 | Any | Any | alter table on partition table will lock the table, no queries can read |
49907 | 2009-12-24 2:02 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4908 days) | S2 | 5.5.0-m2, next-4284 | Any | Any | ALTER TABLE ... TRUNCATE PARTITION does not wait for locks on the table |
50025 | 2010-01-02 12:25 | 2010-01-08 23:26 | MySQL Server: Partitions | Not a Bug (5220 days) | S2 | 5.1.42, 5.1.43-bzr | Any (windows, Mac OS X) | Any | pruning error when partition by month using to_days() |
50456 | 2010-01-19 20:17 | 2010-01-19 21:08 | MySQL Server: Partitions | Not a Bug (5209 days) | S2 | 5.1.42-community-log | Any | Any | MySQl partitioning does not use the correct partitions |
50561 | 2010-01-23 1:12 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4941 days) | S2 | 5.1+ | Any | Any | ALTER PARTITIONS does not have adequate lock, breaks with concurrent I_S query |
51042 | 2010-02-09 21:33 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (4940 days) | S2 | 5.1+ | Any | Any | REORGANIZE PARTITION can leave table in an inconsitent state in case of crash |
51470 | 2010-02-24 17:36 | 2011-02-16 23:44 | MySQL Server: Partitions | Verified (5139 days) | S2 | 5.1, 5.5.1, 5.6.99 | Any | Any | subpartition by key need an expression |
51851 | 2010-03-09 5:32 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4908 days) | S2 | 5.1, 5.6.99-m4, 5.5.3-m3 | Any | Any | Server with SBR locks mutex twice on LOAD DATA into partitioned MyISAM table |
53676 | 2010-05-15 20:42 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4983 days) | S2 | 5.5.3-m3, 5.5.5-m3, 5.6.99 | Any | Any | Unexpected errors and possible table corruption on ADD PARTITION and LOCK TABLE |
53770 | 2010-05-19 0:26 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (5003 days) | S2 | 5.5.3-m3, 5.5.5-m3, 5.6.99 | Any | Any | Server crash at handler.cc:2076 on LOAD DATA after timed out COALESCE PARTITION |
53775 | 2010-05-19 4:54 | 2014-11-04 21:31 | MySQL Server: Partitions | Closed (4305 days) | S2 | 5.1.x, 5.6.99 | Any (MAC OS X, Linux) | Any | Query on partitioned table returns cached result from previous transaction |
55458 | 2010-07-21 21:30 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4908 days) | S2 | 5.1, 5.5 | Any | Any | Partitioned MyISAM table gets crashed by multi-table update |
55467 | 2010-07-22 3:20 | 2010-11-24 15:13 | MySQL Server: Partitions | Not a Bug (5007 days) | S2 | Any | Any | First partition is not pruned | |
56172 | 2010-08-22 20:59 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4877 days) | S2 | 5.5.6-m3, 5.6.1-m4, 5.6.99 | Any | Any | Server crashes in ha_partition::reset on REBUILD PARTITION under LOCK TABLE |
56380 | 2010-08-30 18:07 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4837 days) | S2 | 5.1.50 | Any | Any | valgrind memory leak warning from partition tests |
56438 | 2010-09-01 8:56 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4836 days) | S2 | 5.5.7-m3 | Any | Any | Make it possible for handler to affect the hash value for partition |
56590 | 2010-09-06 12:05 | 2011-10-25 16:51 | MySQL Server: Partitions | Closed (4565 days) | S2 | Any | Any | Any | Partitions: fulltext searches fail |
56909 | 2010-09-21 22:16 | 2011-12-18 22:33 | MySQL Server: Partitions | Closed (4511 days) | S2 | 5.1+ | Any | Any | REORGANIZE PARTITION is allowed on HASH/KEY partitioned tables |
57113 | 2010-09-29 19:25 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (4954 days) | S2 | 5.1-bugteam-debug, 5.5.7-rc-debug | Any | Any | ha_partition::extra(ha_extra_function): Assertion `m_extra_cache' failed |
57708 | 2010-10-25 10:56 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4881 days) | S2 | 5.6 | Any | Any | EXCHANGE PARTITION misuses IGNORE |
57778 | 2010-10-27 17:26 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4881 days) | S2 | 5.5.6-rc | Linux (centos 5.5) | Any | failed primary key add to partitioned innodb table inconsistent and crashes |
58910 | 2010-12-14 4:45 | 2010-12-21 8:42 | MySQL Server: Partitions | Not a Bug (4873 days) | S2 | mysql 5.5.6 | Linux (centos 5.5) | Any | #1503 - A UNIQUE INDEX must include all columns in the table's partitioning func |
59013 | 2010-12-17 20:41 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4856 days) | S2 | 5.5.8 | Any | Any | Partition handler loses information about HA_STATUS_NO_LOCK |
59316 | 2011-01-05 20:37 | 2011-04-26 14:08 | MySQL Server: Partitions | Closed (4747 days) | S2 | 5.1.50, 5.5.8 | Linux | Any | Partitioning and index_merge memory leak |
60440 | 2011-03-12 8:24 | 2011-04-29 9:56 | MySQL Server: Partitions | Duplicate (4744 days) | S2 | 5.5.9 | Any (Windows XP - 32 bit) | Any | RANGE partitioning on TIMESTAMP column does not prune partitions |
62505 | 2011-09-22 21:19 | 2011-12-20 15:45 | MySQL Server: Partitions | Closed (4509 days) | S2 | 5.5.15, 5.5.17 | Any (Windows 7 64-bit) | Any | ALTER TABLE ADD PARTITION fails for LIST partitions with more than 16 items |
63083 | 2011-11-03 0:47 | 2011-11-29 16:19 | MySQL Server: Partitions | Verified (4530 days) | S2 | 5.x | Any | Any | ERROR 1469 (HY000): The mix of handlers in the partitions is not permitted in th |
64126 | 2012-01-25 8:37 | 2012-02-26 1:00 | MySQL Server: Partitions | No Feedback (4442 days) | S2 | 5.5.17 | Any | Any | SELECT results vary with range v IN() |
65663 | 2012-06-19 0:36 | 2012-07-31 8:21 | MySQL Server: Partitions | Can't repeat (4285 days) | S2 | 5.5.23, 5.5.24, 5.5.25 | Linux | Any | Signal 8 When Selecting with Range Greater than Last Partition |
65905 | 2012-07-16 5:32 | 2012-07-18 16:44 | MySQL Server: Partitions | Duplicate (4298 days) | S2 | 5.5.24, 5.5.25a | Linux (CentOS 5/Fedora 16) | Any | MySQL crashes when selecting from a table for a partition that does not exist |
65935 | 2012-07-18 9:54 | 2012-08-30 13:54 | MySQL Server: Partitions | Closed (4255 days) | S2 | 5.5.24 | Linux (Debian Squeeze) | Any | SELECT query returns not all rows that are expected |
66187 | 2012-08-03 18:07 | 2012-08-10 16:25 | MySQL Server: Partitions | Verified (4281 days) | S2 | 5.1.63, 5.5.25a, 5.5.28 | Any | Any | Wrong query plan for min/max over an entire partition |
66958 | 2012-09-25 15:24 | 2014-07-03 14:11 | MySQL Server: Partitions | Not a Bug (4229 days) | S2 | Mysql server 5.6.6 | Linux (Xubuntu 12.04) | Any | impossible to create range partition on a Timestamp with miliseconds |
67351 | 2012-10-24 8:02 | 2017-05-03 16:04 | MySQL Server: Partitions | Verified (4162 days) | S2 | 5.5.27-29.0 | Linux | Any | Cardinality samples of partitioned tables sometimes widely off |
69363 | 2013-05-31 10:55 | 2013-05-31 11:36 | MySQL Server: Partitions | Not a Bug (3981 days) | S2 | 5.1.55 | Linux | Any | I want to ADD partition in table but got "ERROR 1499 (HY000): Too many partitio" |
69411 | 2013-06-05 21:30 | 2013-06-06 19:40 | MySQL Server: Partitions | Not a Bug (3975 days) | S2 | 5.6.12 | Linux (CentOS release 6.4 (Final)) | Any | Paritition lock pruning and ALTER TABLE ... EXCHANGE PARTITION not working |
70303 | 2013-09-11 19:24 | 2015-11-19 15:57 | MySQL Server: Partitions | Analyzing (3878 days) | S2 | 5.5.32 | MacOS | Any | main.partition sporadically fails when using the embedded server |
70588 | 2013-10-10 12:09 | 2014-02-02 17:20 | MySQL Server: Partitions | Closed (3823 days) | S2 | 5.6.14,5.5 | Any | Any | Index merge used on partitionned table can return wrong result set |
72061 | 2014-03-17 15:15 | 2017-02-02 3:57 | MySQL Server: Partitions | Closed (2638 days) | S2 | 5.6.14, 5.6.18 | Any (windows, linux) | Any | cannot import mysqldump of table partitions if the table name is relatively long |
72115 | 2014-03-24 19:29 | 2015-07-22 7:17 | MySQL Server: Partitions | Closed (3199 days) | S2 | 5.6.16 | Any | Any | Very slow create/alter table with partitions and STATS_PERSISTENT=1 |
72428 | 2014-04-23 0:12 | 2021-06-29 18:25 | MySQL Server: Partitions | Duplicate (3607 days) | S2 | 5.6.16,5.5.37 | Any | Any | Partition by KEY() results in uneven data distribution |
75112 | 2014-12-05 8:11 | 2016-01-26 15:54 | MySQL Server: Partitions | Closed (3011 days) | S2 | 5.6.21, 5.6.23, 5.7.6 | Any | Any | Optimize table removes the data directory in partitions |
75325 | 2014-12-29 0:47 | 2018-05-08 20:12 | MySQL Server: Partitions | Can't repeat (2178 days) | S2 | 5.6 | Windows (7.0 SP1) | Any | table appears in show tables but can't drop it - INNODB |
75834 | 2015-02-10 7:46 | 2016-02-02 19:35 | MySQL Server: Partitions | Closed (3270 days) | S2 | 5.7.6-m16 | Any | Any | rqg_alter_online_part run into assertion: node->entry == null (row0ins.cc) |
76007 | 2015-02-23 14:49 | 2016-02-02 19:53 | MySQL Server: Partitions | Closed (3332 days) | S2 | 5.7.6 | Any | Any | get_default_num_partitions() called when number of partitions are known |
76810 | 2015-04-23 15:00 | 2016-06-18 21:26 | MySQL Server: Partitions | Closed (3269 days) | S2 | 8.0.0 | Any | Any | Partition_helper::ph_rnd_init(bool): Assertion `0' failed |
77333 | 2015-06-12 11:13 | 2015-12-03 18:14 | MySQL Server: Partitions | Closed (3065 days) | S2 | 5.5, 5.5.45, 5.6.26, 5.7.8 | Any | Any | ALTER TABLE ... PARTITION is not reexecution safe |
78164 | 2015-08-21 10:11 | 2015-11-25 18:23 | MySQL Server: Partitions | Verified (3169 days) | S2 | 5.6.26 , 5.6.27, 5.7.9 | Ubuntu (14.04.2 64bit) | Any | alter table command affect partitioned table data directory |
79372 | 2015-11-21 11:40 | 2015-11-21 13:33 | MySQL Server: Partitions | Verified (3077 days) | S2 | 5.5, 5.5.48 | Any | Any | INSERT ... SELECT does not preserve rows order in InnoDB partitioned tables |
81712 | 2016-06-03 13:32 | 2016-06-06 8:09 | MySQL Server: Partitions | Verified (2879 days) | S2 | 5.7.12, 5.6.31, 5.7.13 | Windows (Microsoft Windows 7 Professional 64bit Service Pack 1) | Any | lower_case_table_names=2 ignored on ADD PARTITION on Windows |
84360 | 2016-12-28 13:36 | 2016-12-28 15:22 | MySQL Server: Partitions | Verified (2674 days) | S2 | 5.7.17 | Ubuntu (16.04) | Any | İt is possible partitoned table to alter to non-existing general tablespace |
84370 | 2016-12-29 13:42 | 2016-12-30 4:14 | MySQL Server: Partitions | Verified (2672 days) | S2 | 5.7.17 | Any | Any | It is possible to enable compression for partitioned table in general tablespace |
85830 | 2017-04-06 12:07 | 2017-11-29 9:24 | MySQL Server: Partitions | Closed (2338 days) | S2 | 5.7.17 | Any | Any | MySQL startup blocked for 20 minutes on partition-engine-check. |
86926 | 2017-07-04 11:24 | 2018-06-29 11:49 | MySQL Server: Partitions | Closed (2126 days) | S2 | 5.7.17-log | Any | Any | The field table_name (varchar(64)) from mysql.innodb_table_stats can overflow. |
87253 | 2017-07-31 2:36 | 2018-05-22 14:53 | MySQL Server: Partitions | Closed (2164 days) | S2 | 5.7.18 | CentOS (6.4) | Any | innodb partition table has unexpected row lock |
96574 | 2019-08-16 17:21 | 2019-08-19 6:48 | MySQL Server: Partitions | Verified (1710 days) | S2 | 5.7.24, 5.7.27 | MacOS | Any | reorganize partition downcases table name on Mac OS X |
98501 | 2020-02-06 14:01 | 2021-02-02 12:49 | MySQL Server: Partitions | Closed (1178 days) | S2 | 8.0.19 | Any | Any | Exchanging partition with tables does not update SDI correctly |
101530 | 2020-11-09 22:49 | 2021-04-27 23:22 | MySQL Server: Partitions | Closed (1093 days) | S2 | 8.0.22 | Linux | Any | Partition pruning fails with explicit time_zone offset in datetime literal |
105186 | 2021-10-11 9:40 | 2021-10-11 10:41 | MySQL Server: Partitions | Verified (926 days) | S2 | 8.0.26, 5.7.35 | Any | Any | a null value is not treated as zero in hash partition table |
106884 | 2022-04-01 8:53 | 2022-05-24 20:59 | MySQL Server: Partitions | Verified (751 days) | S2 | 8.0, 8.0.28 | Any | Any | Data are not repartitioned when the partition key's charset is modified |
107556 | 2022-06-14 1:52 | 2022-06-14 8:20 | MySQL Server: Partitions | Verified (680 days) | S2 | 8.0.29 | Any | Any | restore_object_from_record on partition table consumes too much memory |
113700 | 2024-01-22 4:13 | 2024-01-22 8:45 | MySQL Server: Partitions | Verified (93 days) | S2 | 8.0.22, 8.0.36 | Any | Any | REORGANIZE PARTITION causes losing data |
113750 | 2024-01-25 6:50 | 2024-01-26 10:12 | MySQL Server: Partitions | Verified (89 days) | S2 | 8.0.36 | Any (rhel-7.4) | Any (x86-64) | stats of partitions could be empty after some kind of alter table DDL statements |
114396 | 2024-03-19 2:54 | 2024-03-19 5:53 | MySQL Server: Partitions | Verified (36 days) | S2 | 8.0.22, 8.0.35, 8.0.36 | Any | Any | NULL is not treated as 0 for tables partitioned by key |
13040 | 2005-09-07 14:20 | 2005-09-07 16:25 | MySQL Server: Partitions | Closed (6804 days) | S3 | mysql-5.1.2 | Linux (linux) | Any | Creation of partition table fails with ps-protocol |
13433 | 2005-09-23 17:29 | 2006-04-02 6:16 | MySQL Server: Partitions | Closed (6597 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 9.2) | Any | Partitions: delimited identifiers cause syntax errors |
13435 | 2005-09-23 17:33 | 2006-01-20 7:09 | MySQL Server: Partitions | Closed (6669 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 9.2) | Any | Partitions: CREATE TABLE ... LIKE fails |
13437 | 2005-09-23 17:35 | 2006-01-20 8:23 | MySQL Server: Partitions | Closed (6669 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 9.2) | Any | Partitions: table files can be same as partition files |
13438 | 2005-09-23 17:36 | 2006-01-20 9:27 | MySQL Server: Partitions | Closed (6669 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 9.2) | Any | Partitions: crash if engine clause |
13439 | 2005-09-23 17:37 | 2006-01-20 9:44 | MySQL Server: Partitions | Closed (6669 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 9.2) | Any | Partitions: crash plus database corruption if LESS THAN non-literal |
13440 | 2005-09-23 17:39 | 2006-01-20 9:49 | MySQL Server: Partitions | Closed (6669 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 9.2) | Any | Partitions: crash if replace statement |
13441 | 2005-09-23 17:40 | 2006-01-20 9:54 | MySQL Server: Partitions | Closed (6669 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 9.2) | Any | Partitions: failure with analyze statement |
13442 | 2005-09-23 17:41 | 2006-01-20 9:56 | MySQL Server: Partitions | Closed (6669 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 9.2) | Any | Partitions: crash after truncate |
13443 | 2005-09-23 17:42 | 2005-11-04 11:51 | MySQL Server: Partitions | Closed (6746 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 9.2) | Any | Partitions: no error for unlisted values |
13445 | 2005-09-23 17:43 | 2006-01-20 10:09 | MySQL Server: Partitions | Closed (6669 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 9.2) | Any | Partitions: crash if key method |
13446 | 2005-09-23 17:44 | 2006-01-20 10:29 | MySQL Server: Partitions | Closed (6669 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 9.2) | Any | Partitions: out-of-range values allowed with foreign keys |
13447 | 2005-09-23 17:45 | 2006-01-20 10:40 | MySQL Server: Partitions | Closed (6669 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 9.2) | Any | Partitions: crash with alter table |
13448 | 2005-09-23 17:46 | 2005-10-31 22:00 | MySQL Server: Partitions | Not a Bug (6750 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 9.2) | Any | Partitions: fulltext searches fail |
14352 | 2005-10-26 20:11 | 2005-11-29 21:47 | MySQL Server: Partitions | Not a Bug (6721 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 10.0) | Any | Partitions: range partition list can be out of order |
14353 | 2005-10-26 20:13 | 2007-12-06 14:47 | MySQL Server: Partitions | Closed (5984 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 10.0) | Any | Partitions: foreign key can't reference a partitioned table |
14354 | 2005-10-26 20:14 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (6470 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 10.0) | Any | Partitions: data directory clause fails |
14355 | 2005-10-26 20:16 | 2006-01-20 1:45 | MySQL Server: Partitions | Closed (6669 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 10.0) | Any | Partitions: SHOW ENGINES shows partition=no |
14362 | 2005-10-26 23:46 | 2007-11-02 15:41 | MySQL Server: Partitions | Closed (6018 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 10.0) | Any | Partitions: crash if alter bdb table |
14363 | 2005-10-26 23:58 | 2006-03-02 6:19 | MySQL Server: Partitions | Closed (6628 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 10.0) | Any | Partitions: failure if create in stored procedure |
14365 | 2005-10-27 0:36 | 2006-01-20 10:52 | MySQL Server: Partitions | Closed (6669 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 10.0) | Any | Partitions: crash if value too small |
14367 | 2005-10-27 1:02 | 2006-03-24 6:28 | MySQL Server: Partitions | Closed (6606 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 10.0) | Any | Partitions: crash if utf8 column |
14524 | 2005-10-31 21:10 | 2006-02-02 14:31 | MySQL Server: Partitions | Closed (6656 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 10.0) | Any | Partitions: crash if blackhole |
14527 | 2005-10-31 21:42 | 2006-03-02 10:15 | MySQL Server: Partitions | Closed (6628 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 10.0) | Any | Partitions: table unreadable if partition name = c-cedilla |
14673 | 2005-11-05 21:33 | 2006-03-14 18:48 | MySQL Server: Partitions | Closed (6616 days) | S3 | 5.1 | Linux (linux) | Any | Partitions: Wrong InnoDB default row format |
15142 | 2005-11-22 16:54 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (6596 days) | S3 | 5.1.2-alpha-debug-log | Linux (SUSE 10.0) | Any | Partitions: crash if list(convert_tz) |
15236 | 2005-11-24 20:47 | 2006-03-09 15:42 | MySQL Server: Partitions | Can't repeat (6621 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 10.0) | Any | Partitions: crash, if Insert .. on duplicate key causes update of existing row |
15253 | 2005-11-25 21:30 | 2006-03-13 10:33 | MySQL Server: Partitions | Closed (6617 days) | S3 | 5.1.2-alpha-debug | Linux (SUSE 10.0) | Any | Partitions: no error for unlisted zeros |
15336 | 2005-11-30 0:10 | 2006-03-24 6:34 | MySQL Server: Partitions | Closed (6606 days) | S3 | 5.1.4-alpha-debug | Linux (SUSE 10.0) | Any | Partitions: crash if create table as select |
15407 | 2005-12-02 2:09 | 2006-03-16 8:03 | MySQL Server: Partitions | Closed (6614 days) | S3 | 5.1.4-alpha-debug | Linux (linux) | Any | Partitions: crash if subpartition |
15408 | 2005-12-02 2:16 | 2006-03-08 15:22 | MySQL Server: Partitions | Closed (6622 days) | S3 | 5.1.4-alpha-debug | Linux (linux) | Any | Partitions: subpartition names are not unique |
15447 | 2005-12-02 20:58 | 2006-03-10 2:10 | MySQL Server: Partitions | Closed (6620 days) | S3 | 5.1.4-alpha-debug | Linux (linux) | Any | Partitions: NULL is treated as zero |
15494 | 2005-12-05 15:58 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (6610 days) | S3 | 5.1.3 | Linux (Linux) | Any | CREATE TABLE ... PARTITON crashes server on nonsensical "less than" clause |
15521 | 2005-12-06 15:43 | 2005-12-20 13:54 | MySQL Server: Partitions | Closed (6700 days) | S3 | 5.1.3 | Linux (Linux) | Any | Cannot reorganize a partition with a new name equal to the old name |
15523 | 2005-12-06 15:51 | 2006-01-24 10:41 | MySQL Server: Partitions | Closed (6665 days) | S3 | 5.1.4-alpha-max | Linux (Linux) | Any | ALTER TABLE ... PARTITION BY does not work in 5.1.3 |
15524 | 2005-12-06 15:56 | 2005-12-20 14:04 | MySQL Server: Partitions | Closed (6700 days) | S3 | 5.1.3 | Linux (Linux) | Any | partitioning range/list violation error message is insufficient |
15561 | 2005-12-07 21:17 | 2006-04-12 0:42 | MySQL Server: Partitions | Closed (6587 days) | S3 | 5.1.4-alpha-debug | Linux (linux) | Any | Partitions: no warning if no support |
15890 | 2005-12-20 14:41 | 2006-09-02 4:28 | MySQL Server: Partitions | Closed (6444 days) | S3 | 5.1 | Any | Partitions: Strange interpretation of partition number | |
16000 | 2005-12-27 5:43 | 2006-06-23 6:19 | MySQL Server: Partitions | Closed (6515 days) | S3 | 5.1-bk | Any | CREATE TABLE produces "Incorrect information in file" msg, leaves a junk file | |
16001 | 2005-12-27 5:45 | 2007-11-02 15:37 | MySQL Server: Partitions | Closed (6018 days) | S3 | 5.1-bk | Any | Any | Supplying an invalid partitioning function can crash the server |
16002 | 2005-12-27 5:46 | 2006-06-15 11:09 | MySQL Server: Partitions | Closed (6523 days) | S3 | 5.1-bk | Any | PARTITION BY RANGE(bigint unsigned) is broken: values >2G treated as negative | |
16370 | 2006-01-11 12:18 | 2006-03-16 8:07 | MySQL Server: Partitions | Closed (6614 days) | S3 | 5.1 | Any | Partitions: subpartitions names not mentioned in SHOW CREATE TABLE output | |
16591 | 2006-01-18 2:02 | 2006-02-21 22:08 | MySQL Server: Partitions | Closed (6637 days) | S3 | 5.1.6-alpha-debug | Linux (SUSE 10.0) | Any | Partitions: crash using information_schema.partitions |
16633 | 2006-01-19 14:45 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (6588 days) | S3 | 5.1 | Any | partition with non-ascii names | |
16634 | 2006-01-19 14:49 | 2006-02-11 16:05 | MySQL Server: Partitions | Can't repeat (6647 days) | S3 | 5.1 | Any | safemalloc errors in frm handling | |
16718 | 2006-01-23 4:31 | 2006-01-24 11:24 | MySQL Server: Partitions | Closed (6665 days) | S3 | 5.1.6 | Any (all) | Any | partitioning support system variable has incorrect name |
16819 | 2006-01-26 19:14 | 2006-04-25 9:25 | MySQL Server: Partitions | Closed (6574 days) | S3 | 5.1.6-alpha | Linux (Linux) | Any | ALTER TABLE test.t1 REBUILD PARTITION p0 1037: Out of memory; |
17127 | 2006-02-05 1:39 | 2006-03-16 8:19 | MySQL Server: Partitions | Closed (6614 days) | S3 | 5.1.7-beta-debug | Linux (SUSE 10.0) | Any | Partitions: crash if add range to list partition |
17128 | 2006-02-05 1:41 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (6522 days) | S3 | 5.1.7-beta-debug | Linux (SUSE 10.0) | Any | Partitions: crash if event adds and drops |
17129 | 2006-02-05 1:43 | 2006-03-06 11:48 | MySQL Server: Partitions | Not a Bug (6624 days) | S3 | 5.1.7-beta-debug | Linux (SUSE 10.0) | Any | Partitions: coalesce fails |
17134 | 2006-02-05 16:34 | 2022-09-04 20:45 | MySQL Server: Partitions | Duplicate (6609 days) | S3 | 5.1.7-beta-debug | Linux (SUSE 10.0) | Any | Partitions: uncommitted changes are visible |
17138 | 2006-02-05 17:56 | 2006-07-04 5:40 | MySQL Server: Partitions | Closed (6504 days) | S3 | 5.1.7-beta-debug | Linux (SUSE 10.0) | Any | Partitions: prepared statements become unknown |
17139 | 2006-02-05 18:15 | 2006-04-16 14:06 | MySQL Server: Partitions | Closed (6583 days) | S3 | 5.1.7-beta-debug | Linux (SUSE 10.0) | Any | Partitions: unprivileged user can effectively drop table |
17140 | 2006-02-05 18:42 | 2006-03-16 8:24 | MySQL Server: Partitions | Closed (6614 days) | S3 | 5.1.7-beta-debug | Linux (SUSE 10.0) | Any | Partitions: crash if add partition if subpartitions |
17141 | 2006-02-05 19:15 | 2006-02-28 21:55 | MySQL Server: Partitions | Closed (6630 days) | S3 | 5.1.7-beta-debug | Linux (SUSE 10.0) | Any | Partitions: crash if 500 hash partitions |
17143 | 2006-02-05 20:42 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (6586 days) | S3 | 5.1.7-beta-debug | Linux (SUSE 10.0) | Any | Partitions: no error message when failing to add foreign key |
17169 | 2006-02-06 23:37 | 2006-02-23 11:22 | MySQL Server: Partitions | Closed (6635 days) | S3 | 5.1.7-beta-debug | | Linux (SUSE 10.0) | Any | Partitions: out of memory if add partition and unique |
17173 | 2006-02-07 1:04 | 2006-03-24 13:45 | MySQL Server: Partitions | Closed (6606 days) | S3 | 5.1.7-beta-debug | Linux (SUSE 10.0) | Any | Partitions: less-than search fails |
17221 | 2006-02-08 2:43 | 2006-03-31 5:58 | MySQL Server: Partitions | Not a Bug (6599 days) | S3 | 5.1 | Any (All) | Any | CREATE table with partitons allows for multiple 'engine=' clauses |
17242 | 2006-02-08 20:17 | 2006-03-20 23:42 | MySQL Server: Partitions | Can't repeat (6610 days) | S3 | 5.1.7-beta-debug | Linux (SUSE 10.0) | Any | Partitions: crash if add partition in procedure twice |
17393 | 2006-02-14 18:49 | 2006-02-23 11:26 | MySQL Server: Partitions | Closed (6635 days) | S3 | 5.1 | Any | Partitions: Wrong error message when assigning too many subpartitions | |
17455 | 2006-02-16 13:56 | 2006-05-31 4:57 | MySQL Server: Partitions | Closed (6538 days) | S3 | 5.1 | Any | Partitions: OPTIMIZE/REPAIR TABLE,wrong message + warnings depending on engine | |
17497 | 2006-02-16 23:30 | 2006-03-15 14:51 | MySQL Server: Partitions | Closed (6615 days) | S3 | 5.1.7-beta-debug | Linux (SUSE 10.0) | Any | Partitions: crash if add partition on temporary table |
17541 | 2006-02-18 4:07 | 2006-02-18 17:36 | MySQL Server: Partitions | Closed (6640 days) | S3 | 5.1.6 | Linux (Fedora Core 4) | Any | Partitioning: Out of memory on DROP PARTITION |
17686 | 2006-02-24 2:41 | 2006-03-13 16:12 | MySQL Server: Partitions | Closed (6617 days) | S3 | 5.1.8 | Any | Two Parition Error Messages that make no sense | |
17754 | 2006-02-27 20:20 | 2006-03-24 14:59 | MySQL Server: Partitions | Closed (6606 days) | S3 | 5.1.8 | Linux (Linux) | Any | Partitions: ALTER TABLE ... ENGINE= ... removes partitioning scheme |
17946 | 2006-03-06 1:35 | 2006-04-16 14:28 | MySQL Server: Partitions | Closed (6583 days) | S3 | 5.1.8-beta-debug | Linux (SUSE 10.0) | Any | Partitions: key() can be for a character column |
17947 | 2006-03-06 2:08 | 2006-03-16 8:27 | MySQL Server: Partitions | Closed (6614 days) | S3 | 5.1.8-beta-debug | Linux (SUSE 10.0) | Any | Partitions: crash if rebuild with no name |
17973 | 2006-03-06 15:56 | 2006-04-16 14:38 | MySQL Server: Partitions | Closed (6583 days) | S3 | Any | Partitions: names can have trailing space | ||
17977 | 2006-03-06 18:06 | 2007-11-02 15:38 | MySQL Server: Partitions | Closed (6018 days) | S3 | 5.1.8-beta-debug | Linux (SUSE 10.0) | Any | Partitions: crash if extractquery |
18053 | 2006-03-08 0:00 | 2006-03-29 7:49 | MySQL Server: Partitions | Closed (6601 days) | S3 | 5.1.8-beta-debug | Linux (SUSE 10.0) | Any | Partitions: crash if null |
18140 | 2006-03-10 17:45 | 2006-04-13 1:57 | MySQL Server: Partitions | No Feedback (6586 days) | S3 | 5.1. | Linux (Linux) | Any | Server crash with function, procedure and partitions |
18330 | 2006-03-18 14:26 | 2006-03-20 23:32 | MySQL Server: Partitions | Can't repeat (6610 days) | S3 | 5.1.8-beta-debug | Linux (SUSE 10.0) | Any | Partitions: crash if stored procedure and loop |
18558 | 2006-03-27 22:01 | 2006-04-07 11:14 | MySQL Server: Partitions | Closed (6592 days) | S3 | 5.2-bk, 5.1.9 | Any | Partition pruning results are incorrect for certain class of WHERE clauses | |
18566 | 2006-03-28 5:01 | 2006-05-26 9:10 | MySQL Server: Partitions | No Feedback (6543 days) | S3 | mysql 5.1.7 beta | Linux (Linux) | Any | Partitioning - Table definition changed, partitions not modified |
18750 | 2006-04-03 17:01 | 2006-04-12 1:24 | MySQL Server: Partitions | Closed (6587 days) | S3 | 5.1.9-beta-debug | Linux (SUSE 10.0) | Any | Partitions: name restrictions |
18751 | 2006-04-03 17:04 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (6595 days) | S3 | 5.1.9-beta-debug | Linux (SUSE 10.0) | Any | Partitions: IS NULL searches fail |
18752 | 2006-04-03 17:07 | 2006-04-16 14:50 | MySQL Server: Partitions | Closed (6583 days) | S3 | 5.1.9-beta-debug | Linux (SUSE 10.0) | Any | Partitions: null becomes zero |
18753 | 2006-04-03 17:11 | 2006-04-12 1:29 | MySQL Server: Partitions | Closed (6587 days) | S3 | 5.1.9-beta-debug | Linux (SUSE 10.0) | Any | Partitions: auto_increment fails |
19010 | 2006-04-11 13:59 | 2006-05-22 14:13 | MySQL Server: Partitions | Closed (6547 days) | S3 | 5.1 | Linux (Linux) | Any | ALTER from Cluster table wo/ PK to other engine fails |
19055 | 2006-04-12 16:41 | 2006-06-10 3:49 | MySQL Server: Partitions | Closed (6528 days) | S3 | 5.1.10-beta-debug | Linux (SUSE 10.0) | Any | Partitions: crash when key(varchar_column) and search |
19062 | 2006-04-12 20:54 | 2006-05-22 14:18 | MySQL Server: Partitions | Closed (6547 days) | S3 | 5.1.10-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Partitions: clause ignored if create from select |
19067 | 2006-04-12 23:59 | 2006-06-07 12:08 | MySQL Server: Partitions | Closed (6531 days) | S3 | 5.1.10-beta-debug | Linux (SUSE 10.0) | Any | Partitions: crash if subpartition and alter |
19122 | 2006-04-16 0:34 | 2006-06-14 0:56 | MySQL Server: Partitions | Closed (6524 days) | S3 | 5.1.10-beta-debug | Linux (SUSE 10.0) | Any | Partitions: crash if alter rebuild |
19140 | 2006-04-17 14:36 | 2006-05-22 14:24 | MySQL Server: Partitions | Closed (6547 days) | S3 | 5.1.10-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Partitions: crash if memory and index |
19281 | 2006-04-22 19:44 | 2006-06-23 6:23 | MySQL Server: Partitions | Closed (6515 days) | S3 | 5.1.10-beta-debug | Linux (Linux, SUSE 10.0 / 64-bit) | Any | Partitions: auto_increment=value lost |
19300 | 2006-04-24 14:51 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (6561 days) | S3 | 5.1.10-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Partitions: crash if create index |
19304 | 2006-04-24 18:55 | 2006-05-31 5:04 | MySQL Server: Partitions | Closed (6538 days) | S3 | 5.1.10-beta | Linux (linux) | Any | creating a merged table from partitioned tables does not work |
19307 | 2006-04-24 19:49 | 2006-06-14 1:15 | MySQL Server: Partitions | Closed (6524 days) | S3 | 5.1.10-beta-debug | Linux (SUSE 10.0) | Any | Partitions: csv delete failure |
19309 | 2006-04-24 20:17 | 2006-06-23 6:27 | MySQL Server: Partitions | Closed (6515 days) | S3 | 5.1.10-beta-debug | Linux (SUSE 10.0) | Any | Partitions: crash if double procedural alter |
19313 | 2006-04-24 21:07 | 2006-05-05 13:17 | MySQL Server: Partitions | Closed (6564 days) | S3 | 5.1 | Any | mysqld: -1 files and 0 streams is left open | |
19316 | 2006-04-24 21:38 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (6524 days) | S3 | 5.1.12-beta-debug, 5.1.10-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Partitions: hang if update with order by in procedure |
19501 | 2006-05-03 6:27 | 2006-05-22 14:30 | MySQL Server: Partitions | Closed (6547 days) | S3 | Any | Data_free not properly set, always set to 0 for partitioned tables | ||
19502 | 2006-05-03 6:32 | 2006-05-22 14:40 | MySQL Server: Partitions | Closed (6547 days) | S3 | Any | Disable/Enable keys for partitioned tables not supported | ||
19625 | 2006-05-08 23:22 | 2006-05-12 23:33 | MySQL Server: Partitions | Closed (6557 days) | S3 | 5.1.9/5.1BK | Linux (Linux) | Any | CREATE TABLE .... PARTITION BY order not per docs |
19684 | 2006-05-10 14:05 | 2006-06-10 4:02 | MySQL Server: Partitions | Closed (6528 days) | S3 | 5.1.9/5.1BK | Linux (CentOS 4.3) | Any | partitions column of EXPLAIN PARTITIONS can't handle long text |
19685 | 2006-05-10 14:13 | 2006-05-12 21:13 | MySQL Server: Partitions | Not a Bug (6557 days) | S3 | 5.1.9 | Linux (CentOS 4.3) | Any | Creating a large number of partitions and subpartitions give storage error. |
19695 | 2006-05-10 17:42 | 2006-06-14 1:23 | MySQL Server: Partitions | Closed (6524 days) | S3 | 5.1.10-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Partitions: ignoring no_table_options |
20161 | 2006-05-31 7:00 | 2006-06-02 5:31 | MySQL Server: Partitions | Closed (6536 days) | S3 | 5.1.9-beta | Linux (Red Hat RHAS4 x86) | Any | Information Schema for Partitions don't display LINEAR keyword for subpartition |
20257 | 2006-06-04 10:32 | 2006-08-03 2:17 | MySQL Server: Partitions | Closed (6474 days) | S3 | 5.1-bk with BUG#16002 fix | Any | Partition pruning may be broken for BIGINT UNSIGNED fields. | |
20340 | 2006-06-08 12:58 | 2006-07-26 0:44 | MySQL Server: Partitions | Closed (6482 days) | S3 | 5.1.12-BK, 5.1.11 | Any (all) | Any | Paritioning does not obey to column type |
20397 | 2006-06-12 14:35 | 2006-06-20 7:16 | MySQL Server: Partitions | Closed (6518 days) | S3 | 5.1.12-beta-debug | Linux (SUSE 10.0) | Any | Partitions: crash if alter engine |
20437 | 2006-06-13 20:23 | 2006-06-13 22:47 | MySQL Server: Partitions | Can't repeat (6525 days) | S3 | 5.1.12-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Events: crash with procedure altering partitions |
20444 | 2006-06-13 23:24 | 2006-06-15 19:02 | MySQL Server: Partitions | Not a Bug (6523 days) | S3 | 5.1.12-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Partitions: extra null with archive engine |
20548 | 2006-06-19 21:21 | 2006-09-02 4:32 | MySQL Server: Partitions | Closed (6444 days) | S3 | 5.1.12-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Events: crash if InnoDB, multiple events, busy procedures, partitions |
20577 | 2006-06-20 15:34 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5335 days) | S3 | 5.1.12-beta-debug-log | Linux (SUSE 10.0 / 64-bit) | Any | Partitions: use of to_days() function leads to selection failures |
20733 | 2006-06-27 21:20 | 2006-07-26 0:49 | MySQL Server: Partitions | Closed (6482 days) | S3 | 5.1.12-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Partitions: search fails on zerofill column |
20770 | 2006-06-29 10:34 | 2006-07-19 4:26 | MySQL Server: Partitions | Closed (6489 days) | S3 | 5.1.12 | Linux (Suse 10.1) | Any | Partitions not removed after reorganize. |
20852 | 2006-07-04 18:36 | 2006-07-19 4:29 | MySQL Server: Partitions | Closed (6489 days) | S3 | 5.1.12-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Partitions: crash if hash, innodb, composite primary key |
20871 | 2006-07-05 17:43 | 2006-08-22 15:02 | MySQL Server: Partitions | Closed (6455 days) | S3 | 5.1.12-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Partitions: crash if --skip-innodb |
20893 | 2006-07-06 22:15 | 2006-07-19 4:32 | MySQL Server: Partitions | Closed (6489 days) | S3 | 5.1.12 | Linux (Linux) | Any | Valgrind 'invalid read' warning in test case partition_range |
21357 | 2006-07-31 7:42 | 2006-09-02 4:58 | MySQL Server: Partitions | Closed (6444 days) | S3 | 5.1.12 | Linux (Linux x86_64) | Any | Valgrind 'invalid read' warning in test case partition |
21658 | 2006-08-15 19:15 | 2006-09-02 5:22 | MySQL Server: Partitions | Closed (6444 days) | S3 | 5.1.12-beta-debug | Linux (Suse 10.0, Linux AMD64-bit) | Any | Partition test fails, --ps-protocol |
21862 | 2006-08-28 8:30 | 2006-09-02 5:28 | MySQL Server: Partitions | Closed (6444 days) | S3 | 5.1.12-BK, 5.1 | Any (All) | Any | Misleading error message 1490: "A PRIMARY KEY need to include all fields..." |
22370 | 2006-09-14 23:40 | 2006-09-15 0:30 | MySQL Server: Partitions | Can't repeat (6431 days) | S3 | 5.1.12-beta-debug-log | Linux (SUSE 10.0 / 64-bit) | Any | Partitions: if I ask for too many, I get none |
22451 | 2006-09-18 20:08 | 2007-01-16 1:08 | MySQL Server: Partitions | Closed (6308 days) | S3 | 5.1.12-beta-debug | Linux (SUSE 10.0) | Any | Partitions: duplicate results with engine=federated |
22707 | 2006-09-26 18:55 | 2008-04-09 15:03 | MySQL Server: Partitions | Not a Bug (5859 days) | S3 | 5.1.12-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Partitions: error message with MyISAM foreign key clause |
23603 | 2006-10-24 23:44 | 2008-02-14 16:42 | MySQL Server: Partitions | Won't fix (5914 days) | S3 | 5.1.13-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Partitions: reorganize means delete |
23675 | 2006-10-26 17:10 | 2007-04-11 2:28 | MySQL Server: Partitions | Closed (6223 days) | S3 | 5.1.13-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Partitions: possible security breach via alter |
25270 | 2006-12-25 13:29 | 2007-01-25 13:55 | MySQL Server: Partitions | No Feedback (6299 days) | S3 | 5.1.14 | Any | Partition Pruning no working | |
26063 | 2007-02-04 14:17 | 2022-09-04 20:45 | MySQL Server: Partitions | Duplicate (5609 days) | S3 | 5.1.15-beta | Linux (GNU/Linux) | Any | LIST partition not found for values which do not exist |
26065 | 2007-02-04 20:02 | 2015-03-15 20:45 | MySQL Server: Partitions | No Feedback (6260 days) | S3 | 5.1 (latest bk) | Linux (Linux PPC) | Any | Partitioning uses too many resources |
26082 | 2007-02-05 13:00 | 2007-07-11 9:10 | MySQL Server: Partitions | Closed (6132 days) | S3 | 5.1-bk, telco-bk | Linux (Linux) | Any | UCASE() function, nested function call allowed in partitioning expression |
27359 | 2007-03-21 21:03 | 2007-04-11 4:05 | MySQL Server: Partitions | Closed (6223 days) | S3 | 5.1.17-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Partitions: memory allocation error message |
27429 | 2007-03-25 20:16 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (5924 days) | S3 | 5.2.4-falcon-alpha-debug | Linux (SUSE 10.0 / 64-bit) | Any | Falcon: inconsistent errors for optimize |
27927 | 2007-04-18 12:53 | 2007-09-24 12:42 | MySQL Server: Partitions | Closed (6057 days) | S3 | 5.1.17 | Linux | Any | Partition pruning not optimal with TO_DAYS function |
28005 | 2007-04-21 22:02 | 2007-05-15 6:02 | MySQL Server: Partitions | Closed (6189 days) | S3 | 5.1.18-beta-debug | Linux (SUSE 10 64-bit) | Any | Partitions: can't use -9223372036854775808 |
28026 | 2007-04-23 14:43 | 2007-07-09 12:29 | MySQL Server: Partitions | Closed (6134 days) | S3 | 5.1,6.0.0-alpha-debug | Linux (SUSE 10 64-bit) | Any | Falcon: crash if partitions and select for update |
28487 | 2007-05-17 5:14 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (6168 days) | S3 | 5.1.19 | Any | Any | during alter table .. add partition temporary tables are visible to users |
28489 | 2007-05-17 5:25 | 2022-09-04 20:45 | MySQL Server: Partitions | Duplicate (6175 days) | S3 | 5.1.19 | Any | Any | spurious out of memory message in comment of show table status |
28527 | 2007-05-18 17:35 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (6000 days) | S3 | 6.0.1-alpha-debug | Linux (SUSE 10 64-bit) | Any | Falcon: searches fail if LIKE and partition and estonian collation |
28682 | 2007-05-25 18:13 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (6034 days) | S3 | 6.0.1-alpha-debug/5.1BK | Linux (SUSE 10 64-bit) | Any | Partitions: failure with extract function and sql_mode change |
28928 | 2007-06-06 14:03 | 2011-06-13 13:21 | MySQL Server: Partitions | Closed (4699 days) | S3 | Any | Any | UNIX_TIMESTAMP() should be considered unary monotonic by partition pruning | |
29258 | 2007-06-21 0:48 | 2007-12-13 12:28 | MySQL Server: Partitions | Closed (5977 days) | S3 | 5.1.20-beta-debug | Linux (SUSE 10 64-bit) | Any | Partitions: search fails for maximum unsigned bigint |
29320 | 2007-06-23 23:14 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (5998 days) | S3 | 6.0.1-alpha-debug | Linux (SUSE 10 64-bit) | Any | Falcon: searches fail if subpartition and select for update |
29368 | 2007-06-26 18:50 | 2007-11-15 15:26 | MySQL Server: Partitions | Closed (6005 days) | S3 | 5.1.19 | Any | Any | Incorrect error, 1467, for syntax error when creating partition |
29418 | 2007-06-28 12:42 | 2007-06-28 13:03 | MySQL Server: Partitions | Closed (6145 days) | S3 | 5.1.19-beta-log MySQL | Linux | Any | ERROR 1491 (HY000): A UNIQUE INDEX must include all columns in the table's parti |
29493 | 2007-07-02 16:52 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (5998 days) | S3 | 6.0.1-alpha-debug | Linux (SUSE 10.0 / 64-bit) | Any | Falcon: searches fail after partition alteration |
30102 | 2007-07-27 15:17 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5376 days) | S3 | 5.1.21 | FreeBSD | Any | Failed RENAME of partitioned table corrupts table files |
30484 | 2007-08-17 20:06 | 2007-10-22 18:09 | MySQL Server: Partitions | Closed (6029 days) | S3 | 5.1.22-beta-debug | Linux (SUSE 10 64-bit) | Any | Partitions: crash with self-referencing trigger |
30648 | 2007-08-27 17:47 | 2007-08-31 13:48 | MySQL Server: Partitions | Closed (6081 days) | S3 | 5.1 | Any | Any | Partition handler may not initialize variable used w/ autoincrement |
30822 | 2007-09-05 9:15 | 2007-12-13 12:36 | MySQL Server: Partitions | Closed (5977 days) | S3 | 5.1-bk, 5.2-BK | Linux | Any | ALTER TABLE COALESCE PARTITION causes segmentation fault |
31270 | 2007-09-28 5:11 | 2007-10-06 5:18 | MySQL Server: Partitions | Closed (6045 days) | S3 | 6.0 | Any | Any | falcon_bug_28026.test fails due to bug in ha_partition.cc |
31705 | 2007-10-18 22:29 | 2007-11-15 15:05 | MySQL Server: Partitions | Closed (6005 days) | S3 | 5.2.6-alpha-debug, 5.1.23 | Linux (SUSE 10 64-bit) | Any | Partitions: crash if varchar length > 65530 |
31870 | 2007-10-26 8:54 | 2007-11-23 17:10 | MySQL Server: Partitions | Not a Bug (5997 days) | S3 | 5.1.22-rc | Any | Any | index range search in partition |
31890 | 2007-10-26 19:46 | 2007-12-14 16:59 | MySQL Server: Partitions | Closed (5976 days) | S3 | 5.1.23-beta-debug | Linux (SUSE 10 64-bit) | Any | Partitions: ORDER BY DESC not working |
31893 | 2007-10-26 21:55 | 2007-11-16 10:03 | MySQL Server: Partitions | Closed (6004 days) | S3 | 5.1.23-beta-debug | Linux (SUSE 10 64-bit) | Any | Partitions: crash if subpartitions and engine change |
31931 | 2007-10-29 23:47 | 2008-03-28 15:56 | MySQL Server: Partitions | Closed (5871 days) | S3 | 6.0.4-alpha-debug/5.1 | Linux (SUSE 10 64-bit) | Any | Partitions: unjustified 'mix of handlers' error message |
32067 | 2007-11-02 23:13 | 2007-11-16 12:57 | MySQL Server: Partitions | Closed (6004 days) | S3 | 5.1.23-rc-debug | Linux (SUSE 10 64-bit) | Any | Partitions: crash with timestamp column |
32566 | 2007-11-21 11:32 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (5991 days) | S3 | 5.1 | Any | Any | Range partitioning: Insert of maximum value should fail LESS THAN (numeric max) |
32569 | 2007-11-21 12:32 | 2007-11-27 10:12 | MySQL Server: Partitions | Duplicate (5993 days) | S3 | mysql-5.1.22-rc | Any | Any | COALESCE PARTITION crashes server when reducing LINEAR HASH table to 1 partition |
32769 | 2007-11-27 13:43 | 2007-11-28 4:34 | MySQL Server: Partitions | Not a Bug (5992 days) | S3 | 5.1.22 | Windows (Windows Xp development machine) | Any | Table partition clause not working in create table statement |
32780 | 2007-11-27 17:46 | 2007-11-28 13:37 | MySQL Server: Partitions | Not a Bug (5992 days) | S3 | 5.1.23-BK | Any | Any | Wrong error when doing ALTER TABLE OPTIMIZE PARTITION on a nonexisting partition |
32781 | 2007-11-27 17:51 | 2007-12-03 17:53 | MySQL Server: Partitions | Duplicate (5987 days) | S3 | 5.1.23-BK | Any | Any | ALTER TABLE OPTIMIZE|REPAIR PARTITION fails on innodb tables |
32812 | 2007-11-28 12:13 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (5984 days) | S3 | 5.1.23-rc-debug | Any | Any | ALTER TABLE ANALYZE PARTITION fails on Memory tables |
32932 | 2007-12-03 14:44 | 2012-05-18 20:19 | MySQL Server: Partitions | Duplicate (5984 days) | S3 | 5.1.23 | Any | Any | alter table .. optimize partitions error -7 from storage engine |
33182 | 2007-12-12 19:43 | 2008-03-28 9:39 | MySQL Server: Partitions | Closed (5871 days) | S3 | 5.1.23-rc-debug | Linux (SUSE 10 64-bit) | Any | Partitions: crash wih DIV in a function |
33257 | 2007-12-15 7:38 | 2008-03-14 9:43 | MySQL Server: Partitions | Closed (5885 days) | S3 | Any | Any | range access on partitioned falcon table actually scans entire indexes | |
33379 | 2007-12-19 19:10 | 2008-03-28 15:07 | MySQL Server: Partitions | Closed (5871 days) | S3 | Any | Any | valgrind error in parts/partition_bit_myisam | |
33479 | 2007-12-22 12:51 | 2008-05-24 17:05 | MySQL Server: Partitions | Closed (5814 days) | S3 | 5.1+ | Any | Any | Insert on a partitioned auto_increment table gives ER_AUTOINC_READ_FAILED |
33679 | 2008-01-03 22:26 | 2008-01-04 0:26 | MySQL Server: Partitions | Not a Bug (5955 days) | S3 | 5.1.22-rc | Linux | Any | ASCII partition function returning "This partition function is not allowed" |
33691 | 2008-01-04 13:41 | 2008-03-05 14:49 | MySQL Server: Partitions | Closed (5894 days) | S3 | 6.0.4-p2 | Any | Any | Falcon crash on partition manipulations |
33722 | 2008-01-07 14:40 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (5892 days) | S3 | Any | Any | Possible to mix specifications for subpartitions when not specified for table | |
33955 | 2008-01-21 10:27 | 2008-01-23 7:15 | MySQL Server: Partitions | Can't repeat (5936 days) | S3 | 5.1.22-rc | Linux | Any | unexpectedly enabled indexes on MyISAM patitioned tables after LOAD DATA |
34225 | 2008-02-01 13:28 | 2008-03-27 19:32 | MySQL Server: Partitions | Closed (5872 days) | S3 | Any | Any | test suite parts uses /tmp-dir instead of mysql-test dir, which causes failures | |
34366 | 2008-02-07 0:02 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (5917 days) | S3 | 5.1.22 | Any | Any | Insert into a partitioned MyISAM table gives ER_AUTOINC_READ_FAILED error |
34604 | 2008-02-15 17:07 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5161 days) | S3 | 5.1+ | Any | Any | handler::ha_rnd_end(): Assertion `inited==RND' failed. |
34669 | 2008-02-19 16:07 | 2008-03-12 21:47 | MySQL Server: Partitions | Not a Bug (5887 days) | S3 | 6.0.5-alpha-debug | Any | Any | Blackhole engine responds for partitioning queries |
35161 | 2008-03-08 7:12 | 2008-09-15 13:56 | MySQL Server: Partitions | Closed (5700 days) | S3 | 5.1.23 | Any | Any | --myisam-recover does not work for partitioned MyISAM tables |
35765 | 2008-04-02 8:02 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5162 days) | S3 | 5.1.24-bk (2008-03-30) | Linux (OpenSUSE 10.2 32-bit) | Any | ALTER TABLE produces wrong error when non-existent storage engine used |
35913 | 2008-04-08 20:43 | 2011-02-16 23:43 | MySQL Server: Partitions | Duplicate (5093 days) | S3 | 6.0 | Any | Any | Failed ALTER table leaves orphaned temporary files |
35953 | 2008-04-10 1:41 | 2020-11-22 20:45 | MySQL Server: Partitions | No Feedback (5693 days) | S3 | 5.1.25-rc-debug | Linux (SUSE 10 | 32-bit) | Any | Partitions: index directory preserved |
36001 | 2008-04-11 17:13 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5519 days) | S3 | 5.1.25-rc-debug | Linux (SUSE 10 | 32-bit) | Any | Partitions: spelling and using some error messages |
36145 | 2008-04-16 16:29 | 2011-02-16 23:43 | MySQL Server: Partitions | Can't repeat (5093 days) | S3 | 6.0 | Any | Any | "marked as crashed and should be repaired" on partitioned MyISAM table |
36312 | 2008-04-24 7:42 | 2020-11-22 20:45 | MySQL Server: Partitions | Verified (4872 days) | S3 | 5.1.24,5.1.51 | Linux | Any | InnoDB DATA_FREE BUG? |
37252 | 2008-06-06 19:56 | 2015-02-06 19:01 | MySQL Server: Partitions | Closed (4333 days) | S3 | 5.1, 6.0 | Any | Any | Partitioning performance drops drastically with hundreds of partitions |
37402 | 2008-06-13 18:55 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5057 days) | S3 | 5.1.24-rc | MacOS | Any | Mysql cant read partitioned table with capital letter in the name |
37453 | 2008-06-17 17:10 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5614 days) | S3 | 5.1.25-rc | Any | Any | Dropping/creating index on partitioned table with InnoDB Plugin locks table |
37721 | 2008-06-28 16:57 | 2008-11-10 15:18 | MySQL Server: Partitions | Closed (5644 days) | S3 | 5.1,6.0.4-alpha,6.0 BZR | Any (Linux, MS Windows xp pro 2002 sp3 AMD athlon 2600+ 2.13ghz 480 MB ram) | Any | ORDER BY when WHERE contains non-partitioned index column |
37728 | 2008-06-29 18:27 | 2012-03-15 14:49 | MySQL Server: Partitions | Closed (4423 days) | S3 | 6.0.6-alpha-debug,5.1 | Linux (SUSE 10 | 32-bit) | Any | Partitions: too-long comment causes no warning |
38005 | 2008-07-10 0:22 | 2008-10-17 17:51 | MySQL Server: Partitions | Closed (5668 days) | S3 | 5.1, 6.0 | Linux (SUSE 10 | 32-bit Ubuntu 64bit) | Any | Partitions: error with insert select |
38083 | 2008-07-13 12:47 | 2008-10-17 17:51 | MySQL Server: Partitions | Closed (5668 days) | S3 | 5.1.28-bzr, 6.0.6-bzr | Linux (64-bit SuSE 10.2) | Any | Error-causing row inserted into partitioned table despite error |
38120 | 2008-07-15 7:28 | 2008-10-09 18:57 | MySQL Server: Partitions | Closed (5676 days) | S3 | 6.0-BK, 5.1 | Any | Any | main.partition fails sporadically |
38272 | 2008-07-21 21:50 | 2008-09-15 13:59 | MySQL Server: Partitions | Closed (5700 days) | S3 | 5.1.24, 5.1.26 | Any | Any | timestamps fields incorrectly defaulted on update accross partitions. |
38719 | 2008-08-11 13:36 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5519 days) | S3 | 5.1/6.0 | Any | Any | Partitioning returns a different error code for a duplicate key error |
38964 | 2008-08-22 15:31 | 2008-08-27 8:15 | MySQL Server: Partitions | Duplicate (5719 days) | S3 | 5.1.28, 6.0.7 | Any | Any | Data_free shown as true free amount * partition count |
39434 | 2008-09-13 23:58 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5612 days) | S3 | 5.1.28 | Any | Any | ALTER TABLE CHECK/OPTIMIZE/ANALYZE PARTITION work on non-partitioned table |
39548 | 2008-09-19 20:41 | 2014-12-04 18:25 | MySQL Server: Partitions | Won't fix (5609 days) | S3 | 5.1.28, 5.1, 6.0 bzr | Any (Linux, windows XP sp2) | Any | cannot partition on an ENUM numeric expression |
39554 | 2008-09-20 9:08 | 2011-02-16 23:43 | MySQL Server: Partitions | Can't repeat (5270 days) | S3 | 5.1.28-rc-community-log | Windows (2003 Server) | Any | select statement with joins and group by seems to be an endless loop |
39893 | 2008-10-06 22:22 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5335 days) | S3 | 5.1+ | Any | Any | Crash if select on a partitioned table, when partitioning is disabled |
40176 | 2008-10-20 13:43 | 2008-11-10 15:40 | MySQL Server: Partitions | Closed (5644 days) | S3 | 5.1.29/5.1.30 | Any | Any | Combination of event, trigger and partitioning breaks auto increment |
40181 | 2008-10-20 15:53 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5161 days) | S3 | 6.0.8-alpha-debug,5.4 | Linux (SUSE 10 32-bit) | Any | Partitions: hang if create index |
40515 | 2008-11-05 0:18 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5573 days) | S3 | 5.1.26,5.1.29 | Any | Any | Query on a partitioned table does not return 'lock wait timeout exceeded' |
40595 | 2008-11-09 0:25 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5614 days) | S3 | 5.1.29 | Any | Any | Non-matching rows not released with READ-COMMITTED on tables with partitions |
40954 | 2008-11-23 10:33 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5614 days) | S3 | 5.1.29, 5.1.30 | Linux | Any | Crash in MyISAM index code with concurrency test using partitioned tables |
41499 | 2008-12-16 12:53 | 2015-03-15 20:45 | MySQL Server: Partitions | No Feedback (5540 days) | S3 | Any (Mac OS X 10.5.5.) | Any | DBUG_ASSERT when full disk on partitioned MyISAM tables. | |
41739 | 2008-12-25 7:54 | 2011-02-16 23:43 | MySQL Server: Partitions | Won't fix (5579 days) | S3 | 5.1.30, 6.0 | Any | Any | Partition Pruning doesn't work if partitioning function has some calculation. |
42822 | 2009-02-13 10:24 | 2017-06-01 9:25 | MySQL Server: Partitions | Closed (4186 days) | S3 | 5.1.30 | Any | Any | optimize partition recreates full table instead just partition |
42938 | 2009-02-17 16:40 | 2011-02-16 23:43 | MySQL Server: Partitions | Won't fix (5376 days) | S3 | 5.1.31 | Any | Any | Comments not available to custom storage engine when partitioned |
42944 | 2009-02-17 19:50 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5467 days) | S3 | 5.1..31, 5.1, 6.0 bzr | Linux (2.6.18-92.el5) | Any | partition not pruned correctly |
42954 | 2009-02-18 3:53 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5042 days) | S3 | 5.1.22, 5.1.32 | Any | Any | SQL MODE 'NO_DIR_IN_CREATE' does not work with subpartitions |
43030 | 2009-02-19 18:40 | 2009-03-12 19:09 | MySQL Server: Partitions | Not a Bug (5522 days) | S3 | 6.0.10, 5.1, 6.0 bzr | Any | Any | Archive engine fails to create a table with partitions |
43729 | 2009-03-18 14:46 | 2017-12-23 10:52 | MySQL Server: Partitions | Can't repeat (3799 days) | S3 | 5.1.30, 5.1 bzr | Any | Any | Dropping and recreating a partition causes duplicate partition error |
43903 | 2009-03-27 9:54 | 2009-03-27 10:08 | MySQL Server: Partitions | Not a Bug (5507 days) | S3 | 5.1 | Windows | Any | Partition pruning doesnt work for table partitioned by timestamp. |
43988 | 2009-03-31 16:30 | 2011-02-16 23:43 | MySQL Server: Partitions | Duplicate (5346 days) | S3 | 5.1/6.0 | Any | Any | AUTO_INCREMENT errors with partitioned InnoDB tables in 5.1.31 |
44622 | 2009-05-02 19:29 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5162 days) | S3 | 5.1.34 | Any | Any | Using PARTITIONs with ARCHIVE engine reports 0 bytes in i_s.TABLES |
45840 | 2009-06-30 6:18 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5240 days) | S3 | 5.1.30, 5.1.37 | Any | Any | read_buffer_size allocated for each partition when "insert into.. select * from" |
46300 | 2009-07-20 9:07 | 2011-02-16 23:44 | MySQL Server: Partitions | Verified (4995 days) | S3 | 5.1.36-log, 5.1.46, 5.5.3 | HP/UX (11.23 PA 2.0, LINUX F12) | Any | Partitioned table: LOAD DATA INFILE "stalls" - HPUX 11.23 PA RISC |
46353 | 2009-07-23 12:16 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5383 days) | S3 | 5.4 | Any | Any | Incorrect error message on ALTER TABLE TRUNCATE PARTITION |
46357 | 2009-07-23 14:09 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5389 days) | S3 | 5.4 | Any | Any | Crash in partition_info::print_no_partition_found on TRUNCATE PARTITION |
46362 | 2009-07-24 9:30 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5332 days) | S3 | 5.1.36 | Any | Any | Endpoint should be set to false for TO_DAYS(DATE) |
46478 | 2009-07-30 14:46 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5334 days) | S3 | 5.1.36 | Any | Any | timestamp field incorrectly defaulted when partition is reorganized |
46754 | 2009-08-17 7:17 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (4977 days) | S3 | Any | Any | 'rows' field doesn't reflect partition pruning | |
46866 | 2009-08-22 20:31 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4954 days) | S3 | 5.1, next bzr | Any | Any | AUTO_INCREMENT errors with partitioned Archive tables |
46936 | 2009-08-26 10:08 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (5346 days) | S3 | 5.1, next bzr | Any | Any | Duplicate entry for key 'PRIMARY' if used partition and innodb |
47135 | 2009-09-04 12:56 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5161 days) | S3 | 5.4.2-beta | Other (Solaris + OS X, see text) | Any | Server crashes on "partition_alter2_1_innodb" + "partition_alter2_2_innodb" |
47253 | 2009-09-10 14:30 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (5336 days) | S3 | Any | Any | Assert in ha_partition::end_bulk_insert | |
47261 | 2009-09-10 21:04 | 2011-02-16 23:44 | MySQL Server: Partitions | Won't fix (5189 days) | S3 | Any | Any | 5.1 fix for Partitioning performance drop...with hundreds of partitions (37252) | |
47594 | 2009-09-24 10:00 | 2011-02-16 23:44 | MySQL Server: Partitions | Can't repeat (5318 days) | S3 | 5.1.33 | Any | Any | a query scans some unnessassary partion |
47664 | 2009-09-28 0:01 | 2011-02-16 23:44 | MySQL Server: Partitions | Can't repeat (5257 days) | S3 | 5.4.4-alpha | Linux (SUSE 11.1 64-bit) | Any | Partitions: hang if two alters |
47752 | 2009-09-30 17:56 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5277 days) | S3 | 5.5 WL#3352 | Any | Any | Partition by LIST COLUMN_LIST only recognizing last defined partition |
47753 | 2009-09-30 20:24 | 2022-12-04 20:45 | MySQL Server: Partitions | Duplicate (5299 days) | S3 | 5.5 WL#3352 | Any | Any | Partition by LIST COLUMN_LIST appears to require an order for value list items |
47754 | 2009-09-30 22:06 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5277 days) | S3 | 5.5 WL#3352 | Any | Any | Assertion fail - mark_full_partition_used_with_parts() at at opt_range.cc:2914 |
47772 | 2009-10-01 18:54 | 2009-10-01 21:24 | MySQL Server: Partitions | Not a Bug (5319 days) | S3 | 5.1/5.4 | Any | Any | Partition by RANGE COLUMN_LIST not accepting YEAR(), etc for definition |
47774 | 2009-10-01 21:55 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5277 days) | S3 | 5.5 WL#3352 | Any | Any | InnoDB: Assertion failure in thread 1769970576 in file row/row0mysql.c line 1355 |
47776 | 2009-10-02 1:51 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5277 days) | S3 | 5.5 WL#3352 | Any | Any | Segfault in handler::ha_update_row() at handler.cc:4690 with Innodb |
47787 | 2009-10-02 10:28 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5131 days) | S3 | 6.0.14 | Any | Any | Test main.not_partition fails due to changes in error message |
47837 | 2009-10-05 16:14 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5277 days) | S3 | 5.5 WL#3352 | Any | Any | Crash CREATE'ing a RANGE COLUMN_LIST table using the same column more than once |
47838 | 2009-10-05 17:42 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5277 days) | S3 | 5.5 WL#3352 | Any | Any | TABLE partitioned by LIST COLUMN_LIST not processing <=, >= properly |
48095 | 2009-10-15 19:21 | 2022-12-04 20:45 | MySQL Server: Partitions | Duplicate (4817 days) | S3 | 5.5 WL#3352 | Any | Any | Valgrind - uninitialized value rw_lock_set_writer_id_and_recursion_flag() |
48096 | 2009-10-15 19:26 | 2011-02-16 23:44 | MySQL Server: Partitions | Can't repeat (5293 days) | S3 | 5.5 WL#3352 | Any | Any | Valgrind - get_next_partition_id_list(st_partition_iter*) sql_partition.cc:7319 |
48097 | 2009-10-15 19:31 | 2011-02-16 23:44 | MySQL Server: Partitions | Can't repeat (5293 days) | S3 | 5.5 WL#3352 | Any | Any | Valgrind-Syscall param write(buf) points to uninitialised byte(s) /lib/ld-2.9.so |
48098 | 2009-10-15 19:35 | 2011-02-16 23:44 | MySQL Server: Partitions | Can't repeat (5293 days) | S3 | 5.5 WL#3352 | Any | Any | Valgrind - uninitialized value - os_thread_eq (os0thread.c:56) |
48161 | 2009-10-19 18:14 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5276 days) | S3 | 5.4.3-beta | Linux (SUSE 11.1 64-bit) | Any | Partitions: search fails with non-default collation |
48162 | 2009-10-19 18:16 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5238 days) | S3 | 5.4.3-beta | Linux (SUSE 11.1 64-bit) | Any | Partitions: maxvalue in a list partition |
48163 | 2009-10-19 18:19 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5274 days) | S3 | 5.4.3-beta | Linux (SUSE 11.1 64-bit) | Any | Partitions: dagger duplication |
48164 | 2009-10-19 18:22 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5274 days) | S3 | 5.4.3-beta | Linux (SUSE 11.1 64-bit) | Any | Partitions: crash with long varchar |
48165 | 2009-10-19 18:24 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5277 days) | S3 | 5.4.3-beta | Linux (SUSE 11.1 64-bit) | Any | Partitions: search fails with information_schema |
48166 | 2009-10-19 18:28 | 2011-02-16 23:44 | MySQL Server: Partitions | Won't fix (5214 days) | S3 | 5.1+ | Any | Any | Partitions: error message refers to value after function completion |
48276 | 2009-10-23 22:37 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5154 days) | S3 | 5.1.41 | Any (SUSE 11.1 64-bit) | Any | Partitions: can't add column if subpartition exists |
48397 | 2009-10-29 1:29 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5277 days) | S3 | 5.5 WL#3352 | Any | Any | Valgrind / Innodb crash - get_mm_parts () at opt_range.cc:5795 |
48737 | 2009-11-12 16:48 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5154 days) | S3 | 5.5.0-beta | Linux (SUSE 11.1 64-bit) | Any | Partitions: search fails with ucs2 |
48846 | 2009-11-17 18:51 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5150 days) | S3 | 5.1+ | Any | Any | Too much time spent in ha_partition::records_in_range if not able to prune |
48937 | 2009-11-20 9:44 | 2011-02-16 23:44 | MySQL Server: Partitions | Can't repeat (5170 days) | S3 | 5.6.0-beta | Linux (32-bit) | Any | Memory leak from mysql_insert during partition pruning test |
48956 | 2009-11-20 21:46 | 2011-02-16 23:44 | MySQL Server: Partitions | No Feedback (5234 days) | S3 | 5.5.0-beta | IBM i | Any | Partition tests are intolerably slow on i5os (factor more than 10) |
49161 | 2009-11-27 11:20 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4941 days) | S3 | 5.1.41 | Any | Any | Out of memory; restart server and try again (needed 2 bytes) |
49180 | 2009-11-28 20:41 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5248 days) | S3 | 5.5.0 | Linux (opensuse 11.1/x86_64) | Any | Possible to define unusable partitions using RANGE COLUMNS() |
49187 | 2009-11-29 19:47 | 2011-02-16 23:44 | MySQL Server: Partitions | Won't fix (5214 days) | S3 | 5.5.0 | Linux (openSUSE11.1/64bit) | Any | Nondescriptive error message for function in expression with columns() |
49369 | 2009-12-02 20:59 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5225 days) | S3 | 5.5.0-bzr | Linux (opensuse11.1/64) | Any | No testcase for key caches on partitions |
50036 | 2010-01-03 13:49 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4908 days) | S3 | 5.5.1-m2-bzr | Linux (OpenSUSE11.1/64) | Any | Inconsistent errors when using TIMESTAMP columns/expressions |
50104 | 2010-01-06 13:31 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5057 days) | S3 | 5.1+ | Any | Any | Partitioned table with just 1 partion works with fk |
50300 | 2010-01-13 8:31 | 2020-11-22 20:45 | MySQL Server: Partitions | Duplicate (4984 days) | S3 | 5.1.41-enterprise-gpl-advanced-log, 5.5.1-m2 | Linux | Any | ALTER TABLE REORGANIZE PARTITION .... changes row_format of table |
50392 | 2010-01-17 0:28 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5056 days) | S3 | 5.1+ | Any | Any | insert_id is not reset for partitioned tables auto_increment on duplicate entry |
50393 | 2010-01-17 0:46 | 2011-02-16 23:44 | MySQL Server: Partitions | Verified (5211 days) | S3 | 5.1+ | Any | Any | insert DELAYED disabled for partitioned myisam |
50899 | 2010-02-04 6:04 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (5193 days) | S3 | mysql 5.1.43 | Any | Any | mysql 5.1.43 partitioning UNIX_TIMESTAMP error |
51830 | 2010-03-08 13:57 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5057 days) | S3 | 5.1.44, 5.1.45-bzr | Linux (amd64) | Any | Incorrect partition pruning on range partition (regression) |
52422 | 2010-03-29 3:41 | 2014-03-14 9:41 | MySQL Server: Partitions | Closed (3694 days) | S3 | 5.1.41, 5.1, 5.6.99 bzr | Linux (RHEL4/5) | Any | Cannot do ALTER TABLE DISCARD TABLESPACE if table has partitions |
52455 | 2010-03-30 1:54 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4941 days) | S3 | 5.1 | Any | Any | Subpar INSERT ON DUPLICATE KEY UPDATE performance with many partitions |
52517 | 2010-04-01 3:10 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4941 days) | S3 | 5.1.45 | Any | Any | Regression in ROW level replication performance with partitions |
52815 | 2010-04-14 10:29 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4888 days) | S3 | 5.5+ | Any | Any | LIST COLUMNS doesn't insert rows in correct partition if muliple columns used |
53806 | 2010-05-19 14:00 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4949 days) | S3 | 5.1.46, mysql-next-mr | Any | Any | Wrong estimates for range query in partitioned MyISAM table |
53819 | 2010-05-19 17:42 | 2022-12-27 1:25 | MySQL Server: Partitions | Analyzing (5089 days) | S3 | mysql-next-mr-wl3561 | Any | Any | assert in my_seek, concurrent workload |
54558 | 2010-06-16 16:32 | 2010-06-16 16:35 | MySQL Server: Partitions | Not a Bug (5061 days) | S3 | gfd | IBM AIX (vxv) | Any | hgfbcvbc gdfdgf gfdg |
55228 | 2010-07-13 19:30 | 2012-10-15 14:39 | MySQL Server: Partitions | Can't repeat (4209 days) | S3 | 5.1.48 | Any | Any | Unknown table engine error message contains some garbage |
55506 | 2010-07-23 11:45 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (5022 days) | S3 | 5.1 | Any | Any | Memory leak on partition_error.test |
55734 | 2010-08-04 9:24 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (5000 days) | S3 | 5.5.5-m3 | FreeBSD (8.0 amd64) | Any | Attribute 'columns' doesn't work with 'datetime' field |
55784 | 2010-08-05 16:07 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4908 days) | S3 | 5.6.0-m4 | Linux (SUSE 64-bit) | Any | Foreign key integrity broken by alter table |
55944 | 2010-08-12 12:34 | 2015-08-23 20:45 | MySQL Server: Partitions | Duplicate (4908 days) | S3 | 5.6.0-m4, 5.6.1-m4 | Any | Any | Assertion: node->pcur->rel_pos == BTR_PCUR_ON on DELETE after EXCHANGE PARTITION |
56659 | 2010-09-08 16:04 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4908 days) | S3 | 5.5.6-rc | Windows | Any | Mismatch of CAPITAL vs small letters in "unified filelist" partitioning output |
56684 | 2010-09-09 10:50 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (4976 days) | S3 | 5.6.99 | Any | Any | MySQL fails to compile if configured to not include Partition storage engine |
56996 | 2010-09-24 9:00 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (4893 days) | S3 | 5.1 | Any | Any | Error in ALTER TABLE ... PARTITION causes memory leaks |
57924 | 2010-11-02 12:22 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4835 days) | S3 | 5.1 | Any | Any | crash when creating partitioned table with multiple columns in the partition key |
58062 | 2010-11-08 20:30 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (4913 days) | S3 | 5.1.41-3, 5.1.54, 5.1, 5.6.99 bzr | Linux (ubuntu12.1) | Any | Results incorrect after rollback on Partitioned table |
58147 | 2010-11-11 20:00 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (4876 days) | S3 | 5.5.7-rc | Any | Any | ALTER TABLE w/ TRUNCATE PARTITION fails - but the statement is written to binlog |
59004 | 2010-12-17 18:15 | 2015-08-23 20:45 | MySQL Server: Partitions | Verified (4877 days) | S3 | 5.5.9 | Linux (SUSE 64-bit) | Any | partition with floor(big_decimal_column) fails |
59297 | 2011-01-05 8:23 | 2011-03-10 9:37 | MySQL Server: Partitions | Closed (4794 days) | S3 | 5.1.54 | Any (Linux(2.6.18-8.1.15.el5, i386), FreeBSD(7.0,i386), Windows XP) | Any | Can't find record in 'tablename' on update inner join (5.1.54) |
59976 | 2011-02-07 1:51 | 2012-01-02 21:01 | MySQL Server: Partitions | Won't fix (4496 days) | S3 | 5.1 | Any | Any | Temporary files remain after check and adding partition |
60071 | 2011-02-10 0:50 | 2013-09-18 12:25 | MySQL Server: Partitions | Closed (3871 days) | S3 | 5.5.8 | Any | Any | QUERYING I_S.PARTITIONS CHANGES THE CARDINALITY OF THE PARTITIONS. |
60288 | 2011-03-01 9:54 | 2014-12-04 18:56 | MySQL Server: Partitions | Not a Bug (4803 days) | S3 | 5.5.8 | Any | Any | ENUM should be allowed to partition on |
60298 | 2011-03-01 22:33 | 2021-06-02 2:23 | MySQL Server: Partitions | Verified (4801 days) | S3 | 5.1+ | Any | Any | Geometry columns/spatial indexes unsupported in partitioned tables |
60325 | 2011-03-03 21:29 | 2011-03-12 10:39 | MySQL Server: Partitions | Verified (4792 days) | S3 | 5.5, 5.1.57, 5.6.3 | Any | Any | partition optimization |
60681 | 2011-03-28 19:32 | 2011-10-25 18:11 | MySQL Server: Partitions | Closed (4565 days) | S3 | 5.1.56 | Any | Any | CHECKSUM TABLE returns 0 for partitioned table |
62568 | 2011-09-28 21:54 | 2011-11-09 16:34 | MySQL Server: Partitions | Verified (4591 days) | S3 | 5.5.12, 5.5.17 | Any | Any | Partition options not supported by storage engine are silently ignored |
63856 | 2011-12-26 22:59 | 2011-12-26 23:07 | MySQL Server: Partitions | Not a Bug (4503 days) | S3 | 5.5.14 | Linux (Ubuntu) | Any | unix_timestamp works in "create table" but not "alter table" |
63884 | 2011-12-30 20:05 | 2013-06-17 13:03 | MySQL Server: Partitions | Closed (3964 days) | S3 | 5.1.62, 5.5.20 | Any | Any | Algorithm used for dropping partitioned table can lead to inconsistency |
65008 | 2012-04-17 15:31 | 2012-04-18 18:37 | MySQL Server: Partitions | Can't repeat (4389 days) | S3 | 5.5.23 | Linux (2.6.32-220.7.1.el6.centos.plus.x86_64 #1 SMP Wed Mar 7 11:06:23 GMT 2012 x86_64) | Any | PARTITION RANGE COLUMNS() on DATE columns not pruning |
65112 | 2012-04-26 10:30 | 2012-05-02 20:27 | MySQL Server: Partitions | Verified (4375 days) | S3 | 5.5.20, 5.6.6 | Linux (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) | Any | About half of partitions are empty on Key partition |
65184 | 2012-05-02 15:09 | 2014-07-07 13:32 | MySQL Server: Partitions | Closed (3871 days) | S3 | 5.5.9, 5.5.25 | Windows | Any | Impossible to optimize subpartitions |
65585 | 2012-06-11 15:40 | 2012-09-27 18:20 | MySQL Server: Partitions | Closed (4227 days) | S3 | 5.5, 5.6, 5.1 | Any | Any | Valgrind warning: Syscall param pwrite64(buf) points to uninitialised byte(s) |
66645 | 2012-09-01 16:39 | 2012-12-11 13:04 | MySQL Server: Partitions | Closed (4152 days) | S3 | 5.5-debug | Any | Any | Assertion `file_entry_buf[2] == 0' failed in deactivate_ddl_log_entry |
67241 | 2012-10-15 20:03 | 2012-10-17 13:41 | MySQL Server: Partitions | Verified (4207 days) | S3 | 5.5 | Linux | Any | Partition pruning not working utf8 / skip-character-set-client-handshake options |
67982 | 2012-12-27 23:45 | 2013-11-01 9:47 | MySQL Server: Partitions | Closed (3827 days) | S3 | 5.5.28, 5.6.9 | Any | Any | Got error 124 from storage engine on DELETE from a partitioned table |
68176 | 2013-01-25 3:28 | 2013-01-25 6:17 | MySQL Server: Partitions | Closed (4107 days) | S3 | 5.5.24 | Windows (7) | Any | partitioning table crashes mysqld |
70182 | 2013-08-29 11:31 | 2013-09-30 15:51 | MySQL Server: Partitions | Duplicate (3859 days) | S3 | 5.6.12-enterprise-commercial-advanced-lo | Linux (RHEL 6.4) | Any | some data are missing in a SELECT with a partitioned table |
70343 | 2013-09-14 8:58 | 2013-09-14 9:51 | MySQL Server: Partitions | Not a Bug (3875 days) | S3 | 5.6.12 | MacOS | Any | Table Comment and Partition Statements Cannot Co-exist in Create Table Stmt |
70641 | 2013-10-16 23:56 | 2014-09-25 11:46 | MySQL Server: Partitions | Closed (3557 days) | S3 | 5.6.14 | Any | Any | 5.6 partitions use much more memory than 5.1 |
70823 | 2013-11-05 17:50 | 2013-11-05 20:00 | MySQL Server: Partitions | Verified (3823 days) | S3 | 5.6.14, 5.7.2 | Any | Any | Extended keys doesn't work for partitioned tables |
71095 | 2013-12-05 16:00 | 2014-08-01 15:52 | MySQL Server: Partitions | Closed (3631 days) | S3 | 5.5.33, 5.6.14, 5.6.15 | Any | Any | Wrong results with PARTITION BY LIST COLUMNS() |
71630 | 2014-02-07 19:36 | 2014-02-08 20:57 | MySQL Server: Partitions | Verified (3729 days) | S3 | 5.1, 5.5, 5.6, 5.7 | Any | Any | Assertion `! is_set()' fails on UPDATE on a partitioned table with subquery |
71906 | 2014-03-03 9:47 | 2014-03-10 8:06 | MySQL Server: Partitions | Verified (3698 days) | S3 | 5.6.15 | Any | Any | SHOW CREATE TABLE FOR PARTITIONED TABLES: output slightly wrong |
71932 | 2014-03-05 9:42 | 2014-03-05 9:42 | MySQL Server: Partitions | Verified | S3 | 5.6.18, 5.7.5 | Any | Any | reorganize + multirow insert into partition table leads to wrong auto_increment |
71947 | 2014-03-05 18:55 | 2014-03-06 5:18 | MySQL Server: Partitions | Verified (3702 days) | S3 | 5.6, 5.7 | Any | Any | Unexpected change in error code on INSERT .. PARTITION causes replication abort |
72009 | 2014-03-11 11:53 | 2014-04-27 1:00 | MySQL Server: Partitions | No Feedback (3651 days) | S3 | 5.6.14 | Any | Any | Poor performance using subpartions in MySQL 5.6. Good in 5.5 |
72222 | 2014-04-03 14:21 | 2014-04-03 16:43 | MySQL Server: Partitions | Verified (3674 days) | S3 | mysql-5.5.35; mysql-5.6.16 | Linux | Any | Strange interaction of SQL_MODE=ANSI and partition by TIMESTAMP |
72238 | 2014-04-04 15:20 | 2014-05-14 23:46 | MySQL Server: Partitions | Not a Bug (3633 days) | S3 | 5.5.36 | Linux | Any | Range Partition using Date functions not pruning for range query |
72383 | 2014-04-18 15:36 | 2014-06-09 13:04 | MySQL Server: Partitions | Not a Bug (3607 days) | S3 | 5.5.37 | Any | Any | Pruning includes first partition when query range crosses month boundary |
72600 | 2014-05-09 22:17 | 2019-04-08 13:55 | MySQL Server: Partitions | Not a Bug (3634 days) | S3 | 5.5-5.7 | Any | Any | similar query ranges involve different partitions |
72614 | 2014-05-12 0:42 | 2014-05-12 6:41 | MySQL Server: Partitions | Verified (3635 days) | S3 | 5.6.17, 5.6.19 | Any | Any | DATA DIRECTORY for partitioned tables |
72625 | 2014-05-13 1:57 | 2014-05-13 23:06 | MySQL Server: Partitions | Duplicate (3634 days) | S3 | MySQL Community Server (GPL) - 5.6.15-log, 5.7.5, 5.6.19 | Linux | Any | Select on a Column with partition by List Columns doesn't return any value |
72689 | 2014-05-20 7:21 | 2014-06-22 1:00 | MySQL Server: Partitions | No Feedback (3595 days) | S3 | 5.5.12 | Linux (Linux 2.6.18-128.el5) | Any | Partitioning with YEARWEEK |
72945 | 2014-06-10 21:24 | 2018-11-02 9:41 | MySQL Server: Partitions | Verified (3605 days) | S3 | 5.* | Any | Any | Partitions are opened for information_schema.partitions queries |
73130 | 2014-06-27 6:03 | 2014-07-21 15:50 | MySQL Server: Partitions | Closed (3579 days) | S3 | 5.7.5-m15 | Any | Any | ALTER... REBUILD on subpartitions doesn\'t work with misplaced rows. |
74772 | 2014-11-10 21:53 | 2018-04-16 12:47 | MySQL Server: Partitions | Not a Bug (2200 days) | S3 | 5.5.18-log | Solaris | Any | Running REPAIR TABLE [table] EXTENDED Causes MySQL to Restart Constantly |
74841 | 2014-11-13 17:36 | 2015-03-16 12:36 | MySQL Server: Partitions | Closed (3333 days) | S3 | 5.6.21-debug/5.7-debug | Linux (CentOS 7) | Any | handle_fatal_signal (sig=11) in cmp_rec_and_tuple | sql/sql_partition.cc:7610 |
74869 | 2014-11-14 16:23 | 2015-03-16 12:37 | MySQL Server: Partitions | Closed (3333 days) | S3 | 5.6.20 | Linux (CentOS 7) | Any | handle_fatal_signal (sig=11) in ha_partition::handle_opt_partitions |
75474 | 2015-01-10 1:56 | 2015-01-14 10:06 | MySQL Server: Partitions | Not a Bug (3388 days) | S3 | 5.5/5.6 | Any | Any | Problem with subpartitions |
75856 | 2015-02-11 6:39 | 2015-04-07 21:03 | MySQL Server: Partitions | Closed (3305 days) | S3 | 5.7.6 | Any | Any | valgrind failure in rpl.rpl_row_basic_8partition |
75858 | 2015-02-11 6:43 | 2015-04-07 21:04 | MySQL Server: Partitions | Closed (3332 days) | S3 | Any | Any | valgrind failure in main.partition | |
76154 | 2015-03-04 21:29 | 2016-02-02 20:07 | MySQL Server: Partitions | Closed (3323 days) | S3 | 5.7.7-rc-debug-log | Any | Any | crash of server during repair table1 , table2 quick |
76374 | 2015-03-18 10:30 | 2016-02-08 12:44 | MySQL Server: Partitions | Closed (3155 days) | S3 | 5.7.6 | Any | Any | Partitioned tables not upgraded to use native partitioning |
76575 | 2015-04-02 9:05 | 2016-02-08 12:45 | MySQL Server: Partitions | Closed (3261 days) | S3 | 5.7 | Any | Any | assert if .frm exists but no partitioned innodb table. |
76846 | 2015-04-27 7:12 | 2015-05-14 11:04 | MySQL Server: Partitions | Can't repeat (3268 days) | S3 | 5.6.12-log | Windows | Any | No of rows for table showing differntly |
77499 | 2015-06-26 8:30 | 2015-11-23 4:57 | MySQL Server: Partitions | Duplicate (3075 days) | S3 | 5.6.25, 5.6.26, 5.7.8 | Any | Any | Incorrect Partition Pruning with Subpartitions |
77772 | 2015-07-17 23:32 | 2015-07-21 21:41 | MySQL Server: Partitions | Duplicate (3200 days) | S3 | 5.6.23 | CentOS | Any | If DATA DIRECTORY is defined for a partition or table, exchange is not possible |
77773 | 2015-07-17 23:50 | 2015-07-20 12:44 | MySQL Server: Partitions | Verified (3201 days) | S3 | 5.6.23, 5.6.25 | CentOS | Any | DATA DIRECTORY and INDEX DIRECTORY ignored for MyISAM partitions on Linux |
78638 | 2015-09-30 8:03 | 2016-06-18 21:28 | MySQL Server: Partitions | Closed (3075 days) | S3 | 8.0.0-m17 | Any | Any | parts.partition_alter2_1_1_innodb run into assertion |
79145 | 2015-11-06 2:42 | 2016-02-08 12:57 | MySQL Server: Partitions | Closed (3086 days) | S3 | 5.7.10 | Any | Any | Memory Leak in Ha_innopart_share::set_v_templ partitioned on virtual column |
83434 | 2016-10-19 0:35 | 2016-10-19 7:20 | MySQL Server: Partitions | Duplicate (2744 days) | S3 | 5.6.30 | Any | Any | Select statement with partition selection against MyISAM table opens all partiti |
83470 | 2016-10-20 18:24 | 2017-05-16 2:53 | MySQL Server: Partitions | Closed (2535 days) | S3 | 5.7.16-debug-log | Any | Any | Reverse scan on a partitioned table does ICP check incorrectly, causing slowdown |
84107 | 2016-12-08 11:15 | 2016-12-21 10:50 | MySQL Server: Partitions | Closed (2683 days) | S3 | 5.7.16 | Any | Any | Severe slowdown on partitioned table with simple ORDER BY ASC change to DESC |
84362 | 2016-12-28 17:11 | 2016-12-28 17:52 | MySQL Server: Partitions | Verified (2674 days) | S3 | 5.6, 5.7,8.0 | Any | Any | PARTITION BY LIST COLUMNS allows unsupported data types |
85238 | 2017-03-01 2:58 | 2017-03-01 10:36 | MySQL Server: Partitions | Verified (2611 days) | S3 | 5.6, 5.7, 8.0 | Any | Any | Dropping non-existent partition throws unexpected error under certain conditions |
87914 | 2017-09-29 11:33 | 2017-10-04 14:21 | MySQL Server: Partitions | Verified (2394 days) | S3 | 5.7 | Any | Any | Possible unintended usage of a field in file "sql/sql_partition.cc" |
88377 | 2017-11-06 21:54 | 2019-03-11 13:33 | MySQL Server: Partitions | Verified (1871 days) | S3 | 5.5, 5.6, 5.7, 8.0, 5.7.20 | Any | Any | Wrong CREATE_TIME and UPDATE_TIME for partitioned table |
88916 | 2017-12-14 10:59 | 2021-01-11 3:59 | MySQL Server: Partitions | Verified (2323 days) | S3 | 5.6, 5.7, 5.6.38, 5.7.20 | Any | Any | Assertion `table->s->db_create_options == part_table->s->db_create_options' |
91190 | 2018-06-08 16:51 | 2023-03-28 12:24 | MySQL Server: Partitions | No Feedback (2105 days) | S3 | 8.0.11 | CentOS | Any | DROP PARTITION and REORGANIZE PARTITION are slow |
91203 | 2018-06-10 16:02 | 2018-06-11 8:17 | MySQL Server: Partitions | Verified (2144 days) | S3 | 5.6.38, 5.6.40, 5.7.22, 8.0.11 | CentOS (6,5) | x86 | For partitions table, deal with NULL with is mismatch with reference guide. |
91855 | 2018-08-01 13:38 | 2019-07-22 9:15 | MySQL Server: Partitions | Verified (1738 days) | S3 | 8.0.12 | Any | Any | Last reference to WITH_PARTITION_STORAGE_ENGINE and --skip-partition |
92661 | 2018-10-03 21:42 | 2018-12-02 22:24 | MySQL Server: Partitions | Verified (2029 days) | S3 | 5.7.23 | Any | Any | SELECT on key partitioned enum reading all partitions instead of 1 |
92728 | 2018-10-10 8:39 | 2019-01-30 13:41 | MySQL Server: Partitions | Can't repeat (1933 days) | S3 | 5.7.20 | Windows (WIndows Server 2016) | x86 (On a VM) | MySQL 5.7 issue with 16TB disk |
94875 | 2019-04-02 19:21 | 2019-04-03 5:57 | MySQL Server: Partitions | Verified (1848 days) | S3 | 8.0.15 | Any | Any | MySQL is performing Engine substitution with partitions |
96437 | 2019-08-06 11:58 | 2020-03-06 13:07 | MySQL Server: Partitions | Not a Bug (1510 days) | S3 | 5.7.22 | Red Hat (6.5) | x86 | multi_range select for update with a partition table may lock other rec |
96895 | 2019-09-17 5:45 | 2019-09-19 5:10 | MySQL Server: Partitions | Verified (1681 days) | S3 | 5.7.26 | Windows | Any | Test main.partition_rename_longfilename fails on Samba storage |
97986 | 2019-12-13 14:16 | 2020-01-14 1:00 | MySQL Server: Partitions | No Feedback (1563 days) | S3 | 8.0.17 | Windows | Any | Mysql return different number of rows when select different fields |
98231 | 2020-01-15 8:27 | 2020-03-11 13:52 | MySQL Server: Partitions | Verified (1559 days) | S3 | 8.0 | Any | Any | show index from a partition table gets a wrong cardinality value |
101310 | 2020-10-26 4:39 | 2020-10-27 22:55 | MySQL Server: Partitions | Verified (1276 days) | S3 | 8.0.21, 8.0.22 | Any | Any | partition by key distribute unbalance for utf8 |
101728 | 2020-11-24 6:02 | 2020-12-02 7:57 | MySQL Server: Partitions | Can't repeat (1239 days) | S3 | 8.0.21,8.0.22 | CentOS | x86 | partition by key distribute unbalance when PARTITIONS is even number |
101984 | 2020-12-13 14:28 | 2020-12-14 7:04 | MySQL Server: Partitions | Verified (1227 days) | S3 | 8.0.22, 5.7.32 | CentOS | x86 | partition by key distribute unbalance when PARTITIONS is even and some COLLATE |
102090 | 2020-12-30 7:13 | 2020-12-30 9:35 | MySQL Server: Partitions | Verified (1211 days) | S3 | MySQL8.0.22/5.7 | Red Hat (rhel-7.4) | x86 (intel x86-64) | partitioned-table creation incorrectly checks timezone-dependent expressions |
103029 | 2021-03-18 6:34 | 2021-03-19 13:02 | MySQL Server: Partitions | Verified (1133 days) | S3 | 8.0 | Any | Any | Suboptimal plan due to null partition catch |
104054 | 2021-06-18 7:47 | 2022-11-30 13:32 | MySQL Server: Partitions | Not a Bug (1035 days) | S3 | 8.0 | CentOS (centos 7.0) | x86 | Unnecessary next-key lock for partition table |
104293 | 2021-07-13 8:37 | 2021-07-13 11:50 | MySQL Server: Partitions | Not a Bug (1016 days) | S3 | 8.0.25 | Any | Any | index dir ERROR: 1031 Table storage engine for 'th' doesn't have this option |
104819 | 2021-09-03 6:55 | 2021-09-03 12:17 | MySQL Server: Partitions | Verified (964 days) | S3 | 8.0 | Any | Any | partition table maxvalue define error |
104881 | 2021-09-09 8:25 | 2021-09-15 8:46 | MySQL Server: Partitions | Verified (958 days) | S3 | 8.0.26, 5.7.35 | Any | Any | partition_info::set_used_partition not raise error when finding no partition |
104956 | 2021-09-16 8:54 | 2021-09-16 10:27 | MySQL Server: Partitions | Verified (951 days) | S3 | 8.0.26, 5.7.35 | Any | Any | SHOW CREATE TABLE outputs are inconsistent after CREATE TABLE and ALTER TABLE |
104981 | 2021-09-18 7:14 | 2021-09-20 6:44 | MySQL Server: Partitions | Verified (947 days) | S3 | 8.0.26 | Any | Any | Raise error that partition' name to be dropped doesn't exist at an earlier stage |
105057 | 2021-09-28 3:19 | 2021-10-29 1:00 | MySQL Server: Partitions | No Feedback (909 days) | S3 | Any | Any | data type does not match at range columns partitioning | |
105075 | 2021-09-29 13:00 | 2021-09-29 13:35 | MySQL Server: Partitions | Verified (938 days) | S3 | 5.7 | Any | Any | part field of unsigned bigint type |
105202 | 2021-10-13 10:02 | 2021-10-13 10:52 | MySQL Server: Partitions | Verified (924 days) | S3 | 8.0.26, 5.7.35 | Any | Any | ha_innopart::store_lock() traverse all partitions starting from index 1 not 0 |
105204 | 2021-10-13 11:22 | 2021-11-01 8:41 | MySQL Server: Partitions | Verified (924 days) | S3 | 8.0.26 | Any | Any | ha_innopart traverse all partitions instead of only used partitions causing loss |
105317 | 2021-10-26 6:12 | 2021-10-26 7:20 | MySQL Server: Partitions | Verified (911 days) | S3 | 8.0.26, 8.0.27 | Any | Any | Behavior of auto-increment value after EXCHANGE PARTITION is inconsistent |
105490 | 2021-11-08 11:28 | 2022-01-26 8:45 | MySQL Server: Partitions | Verified (898 days) | S3 | 8.0.27 | Any | Any | Empty loop brings loss to performance when pruning partitions for INSERT command |
105726 | 2021-11-27 10:21 | 2021-11-29 13:44 | MySQL Server: Partitions | Unsupported (877 days) | S3 | 8.0.19 | Red Hat (7.5) | x86 | Creating partitioned tables will lead to a rapid increase in memory usage of my |
106609 | 2022-03-01 8:11 | 2022-03-02 1:55 | MySQL Server: Partitions | Verified (785 days) | S3 | 8.0.27, 5.7 | Any | Any | For EXCHANGE PARTITION, make partition table writable while validation |
107791 | 2022-07-07 7:01 | 2022-07-18 9:11 | MySQL Server: Partitions | Verified (657 days) | S3 | 8.0.29, 5.7.38 | Any | Any | Left join with derived partitioned table returns wrong result |
107890 | 2022-07-15 5:49 | 2022-07-15 12:45 | MySQL Server: Partitions | Not a Bug (649 days) | S3 | Any | Any | Create Partition Table Error Caused By Non-partition Field | |
109939 | 2023-02-05 9:23 | 2023-02-07 9:19 | MySQL Server: Partitions | Verified (442 days) | S3 | 8.0.32, 5.7.41 | Any | Any | Lists partitions can not be reorganized (must be in consecutive order) |
109994 | 2023-02-08 19:44 | 2023-02-09 5:35 | MySQL Server: Partitions | Verified (440 days) | S3 | 5.7, 8.0 | Any | Any | Unexpected 1748 error returns when update stored generated column partition key |
110341 | 2023-03-10 17:18 | 2023-03-16 14:12 | MySQL Server: Partitions | Verified (408 days) | S3 | 8.0.32 | Any | Any | FOUND_ROWS() gives wrong result on prepared query against partitioned table |
111582 | 2023-06-27 12:03 | 2023-06-30 10:33 | MySQL Server: Partitions | Verified (299 days) | S3 | 8.0.33 | Any | Any | Query is incorrect after importing partition table with a different definition |
111685 | 2023-07-07 1:13 | 2023-07-07 8:13 | MySQL Server: Partitions | Verified (292 days) | S3 | 8.0.32, 8.0.33 | Linux | x86 | ADD PARTITION with DATA DIRECTORY forces relocation of other partitions |
112181 | 2023-08-25 9:04 | 2023-09-18 8:39 | MySQL Server: Partitions | Verified (240 days) | S3 | 8.0 | Any | Any | TIMESTAMP(N) partitions doesn't prune for inequity |
112761 | 2023-10-18 10:55 | 2023-10-18 11:59 | MySQL Server: Partitions | Can't repeat (189 days) | S3 | 8.0.2 | Any | Any | Partition prune always with the first partition when range(to_days(xxx)) |
113338 | 2023-12-05 11:16 | 2023-12-07 8:11 | MySQL Server: Partitions | Verified (139 days) | S3 | 8.0.34, 8.0.35 | Linux | Any | return error result with a qubquery |
113369 | 2023-12-08 3:51 | 2024-01-05 13:06 | MySQL Server: Partitions | Verified (138 days) | S3 | 8.0.34, 8.0.35 | Any | Any | In the hash partition table, the query result is error. |
113419 | 2023-12-14 12:50 | 2023-12-18 10:47 | MySQL Server: Partitions | Verified (131 days) | S3 | 8.0 | Any | Any | Contribution by Tencent: partition prune ignore subpartition where condition |
113614 | 2024-01-11 8:20 | 2024-01-11 9:24 | MySQL Server: Partitions | Won't fix (104 days) | S3 | mysql-5.6.51,mysql-5.7.44 | Any | Any | The partiton table's AUTOINC back to older after change partitions ddl executed. |
114400 | 2024-03-19 9:34 | 2024-03-19 12:16 | MySQL Server: Partitions | Verified (36 days) | S3 | 8.0.32, 8.0.36 | Any | Any | Create partition table with DATA DIRECTORY execution result is incorrect |
114466 | 2024-03-24 15:15 | 2024-03-26 11:25 | MySQL Server: Partitions | Can't repeat (29 days) | S3 | mysql 8.0 | CentOS | x86 | online ddl and virtual column related crash problems |
13436 | 2005-09-23 17:34 | 2011-02-16 23:43 | MySQL Server: Partitions | Won't fix (5257 days) | S4 | 5.1.2-alpha-debug | Linux (SUSE 9.2) | Any | Partitions: most data types don't work |
14326 | 2005-10-26 11:14 | 2008-11-10 15:55 | MySQL Server: Partitions | Closed (5644 days) | S4 | 5.1.2 (pulled 2005-10-20) | Linux (SuSE 9.3, SuSE 10) | Any | No formatting of SHOW CREATE TABLE output |
15526 | 2005-12-06 16:21 | 2008-02-02 12:36 | MySQL Server: Partitions | Not a Bug (5926 days) | S4 | 5.1.3 | Linux (Linux) | Any | cannot determine value of "MAXVALUE" used in partitioning |
17010 | 2006-02-01 15:58 | 2006-07-03 14:16 | MySQL Server: Partitions | No Feedback (6505 days) | S4 | 5.1.5-max | Windows (Windows NT) | Any | Table Maintenance (analyze, optimize, ...) |
19405 | 2006-04-27 17:33 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5274 days) | S4 | 5.1.X | Any | Any | No way to truncate a partition |
20130 | 2006-05-29 19:06 | 2007-11-02 16:06 | MySQL Server: Partitions | Closed (6018 days) | S4 | 5.1.9 | Any | Any | ALTER TABLE ... ADD PARTITION needs a force option |
20131 | 2006-05-29 19:24 | 2009-12-07 8:56 | MySQL Server: Partitions | Won't fix (6519 days) | S4 | 5.1.9 | Any | Any | Partitioning by DATE/DATETIME doesn't work |
20279 | 2006-06-06 5:23 | 2012-05-24 11:35 | MySQL Server: Partitions | Closed (4353 days) | S4 | 5.1.9-beta | Linux (CentOS release 4.2 (Final)) | Any | Can't select data from a specific partition |
23652 | 2006-10-25 22:31 | 2015-08-23 20:45 | MySQL Server: Partitions | Verified (6034 days) | S4 | 5.1.13-beta-debug | Linux (SUSE 10.0 / 64-bit) | Any | Partitions: intermittent use of ansi_quotes causes errors |
29120 | 2007-06-14 18:31 | 2011-04-05 6:03 | MySQL Server: Partitions | Open (4768 days) | S4 | any | Any | Any | new partition type |
29840 | 2007-07-17 8:59 | 2014-08-21 13:32 | MySQL Server: Partitions | Verified (3547 days) | S4 | 5.6.21 | Linux | Any | A PRIMARY KEY must include all columns in the table's partitioning function |
30346 | 2007-08-09 23:03 | 2010-06-04 13:43 | MySQL Server: Partitions | Won't fix (5073 days) | S4 | Any | Any | Support INTERVAL Partition Type | |
30459 | 2007-08-16 15:29 | 2008-03-28 15:02 | MySQL Server: Partitions | Closed (5871 days) | S4 | 5.1.19-beta-community-nt-debug-log | Windows | Any | Partitioning across disks failing on Windows Server (64-bit) |
31585 | 2007-10-14 4:54 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5007 days) | S4 | Any | Any | ALTER TABLE ... DROP PARTITION loses data. No ability to archive data. | |
36303 | 2008-04-23 18:13 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5237 days) | S4 | 5.1 | Any | Any | It is not possible to use PARTITION BY RANGE over FLOAT column |
36794 | 2008-05-19 7:53 | 2011-02-16 23:43 | MySQL Server: Partitions | Duplicate (5357 days) | S4 | 5.1.24 | Any | Any | Partition by function of time, optimise queries to use only correct tables. |
39637 | 2008-09-24 21:27 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5274 days) | S4 | 5.1 | Any | Any | Support key caches for partitioned tables. |
40108 | 2008-10-17 14:18 | 2011-02-16 23:43 | MySQL Server: Partitions | Duplicate (5621 days) | S4 | 5.1.28 | Any | Any | Partitioning by function UNIX_TIMESTAMP() is not supported |
41210 | 2008-12-03 18:43 | 2011-02-16 23:43 | MySQL Server: Partitions | Duplicate (5610 days) | S4 | 5.1 | Any | Any | cannot truncate a partition individually |
45350 | 2009-06-05 13:04 | 2011-02-16 23:44 | MySQL Server: Partitions | Won't fix (5257 days) | S4 | 6.0 | Any | Any | Support partition pruning for DAY() and MONTH() functions |
45353 | 2009-06-05 14:23 | 2011-02-16 23:44 | MySQL Server: Partitions | Verified (5378 days) | S4 | Any | Any | Support for compression in partitions | |
46012 | 2009-07-07 14:16 | 2011-02-16 23:44 | MySQL Server: Partitions | Verified (5361 days) | S4 | 5.1.35 | Any | Any | Partitioning of tables requires dropping of FK constraints |
46050 | 2009-07-08 17:44 | 2015-08-23 20:45 | MySQL Server: Partitions | Verified (5364 days) | S4 | 5.1.36 | Any | Any | Condition Pushdown for ha_partition |
46093 | 2009-07-09 16:18 | 2015-08-23 20:45 | MySQL Server: Partitions | Verified (5364 days) | S4 | 5.1.35 | Any | Any | Add MERGE cases for ha_partition |
46611 | 2009-08-07 19:04 | 2011-02-16 23:44 | MySQL Server: Partitions | Won't fix (5257 days) | S4 | 5.1 | Linux (Debian Linux 2.6.24-etchnhalf.1-amd64) | Any | Innodb needs partitioning support |
46661 | 2009-08-11 20:56 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (5237 days) | S4 | 5.1 | Any | Any | Support For Foreign Keys In Partitioned Tables |
47310 | 2009-09-14 12:53 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (5336 days) | S4 | 5.1.37 | Any | Any | Feature request: allow partitioning for any function which returns an integer. |
47492 | 2009-09-21 18:40 | 2012-09-06 11:51 | MySQL Server: Partitions | Closed (4248 days) | S4 | 5.1+ | Any | Any | extend limit beyond 1024 partitions |
48477 | 2009-11-02 16:28 | 2011-02-16 23:44 | MySQL Server: Partitions | Won't fix (4977 days) | S4 | 5.1.40 | Any | Any | should convert some delete statements to truncate in partitioned tables |
50566 | 2010-01-23 14:17 | 2011-02-16 23:44 | MySQL Server: Partitions | Verified (5205 days) | S4 | Any | Any | Add "catch-all" (default) partition in partition by list | |
54275 | 2010-06-07 8:01 | 2011-02-16 23:44 | MySQL Server: Partitions | Verified (5070 days) | S4 | 5.1.47, 5.5.3 | Any | Any | useless partitioning error messages written to error log |
55900 | 2010-08-11 4:16 | 2011-02-16 23:44 | MySQL Server: Partitions | Verified (4992 days) | S4 | 5.5.5-m3 | Windows (Windows 7) | Any | Pruning for PARTITION BY LIST COLUMNS should take advantage of 2nd+ column |
56810 | 2010-09-15 23:24 | 2017-09-01 10:08 | MySQL Server: Partitions | Won't fix (4956 days) | S4 | 5.1 | Linux | Any | Add from_unixtime function to partitioning allowed list |
57668 | 2010-10-22 18:37 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (4932 days) | S4 | all | Any | Any | partition pruning and open files |
60615 | 2011-03-24 5:52 | 2011-03-29 20:07 | MySQL Server: Partitions | Verified (4775 days) | S4 | any | Any | Any | partition otimization 2 - partial index |
61293 | 2011-05-26 1:16 | 2011-05-26 1:25 | MySQL Server: Partitions | Closed (4717 days) | S4 | Any | Any | partition feature (remove partitions) | |
62351 | 2011-09-05 13:21 | 2011-09-05 13:25 | MySQL Server: Partitions | Closed (4615 days) | S4 | 5.5 | Any | Any | How to check that partition pruning occurs |
67145 | 2012-10-09 12:55 | 2019-01-29 0:35 | MySQL Server: Partitions | No Feedback (4099 days) | S4 | 5.5.27 | Any | Any | Is is not possible to partition on TIMESTAMP fields. It really should be, |
68535 | 2013-03-01 10:26 | 2013-03-25 11:31 | MySQL Server: Partitions | Open (4048 days) | S4 | 5.6 | Any | Any | data move from a partition of a partitioned table to a non partitioned table |
69357 | 2013-05-30 23:36 | 2013-06-24 18:41 | MySQL Server: Partitions | Duplicate (3957 days) | S4 | 5.7 | Any | Any | Can not use Foreign Keys with Partitioning |
70790 | 2013-10-31 14:50 | 2013-10-31 14:54 | MySQL Server: Partitions | Verified | S4 | 5.6.14 | Any | Any | ALTER TABLE REBUILD PARTITION SHOULD NOT PREVENT DML IN UNAFFECTED PARTITIONS |
72348 | 2014-04-15 6:13 | 2014-04-19 7:46 | MySQL Server: Partitions | Verified (3658 days) | S4 | 5.6.15 | Any | Any | Please allow rebuild partition to work on multiple partitions at once |
73084 | 2014-06-23 18:10 | 2015-07-21 21:42 | MySQL Server: Partitions | Open | S4 | 5.6 | Linux (3.5.0-17-generic #28-Ubuntu SMP Tue Oct 9 19:31:23 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux) | Any | Exchanging partitions defined with DATA DIRECTORY and INDEX DIRECTORY options |
75085 | 2014-12-03 9:19 | 2022-08-08 8:24 | MySQL Server: Partitions | Verified (625 days) | S4 | 5.6.16 | Any | Any | Partition pruning on key partioning with ENUM |
75302 | 2014-12-24 0:12 | 2014-12-24 0:12 | MySQL Server: Partitions | Open | S4 | Any | Any | Add functionality to use partition order for sorts | |
75400 | 2015-01-03 15:06 | 2015-01-03 15:06 | MySQL Server: Partitions | Open | S4 | Any | Any | Add support in partitions of mix InnoDB and Memory engines | |
87517 | 2017-08-23 17:27 | 2021-12-08 14:09 | MySQL Server: Partitions | Verified (868 days) | S4 | 8.0 | Any | Any | Support of foreign keys on partitioned tables, innodb engine |
89870 | 2018-03-01 14:21 | 2020-10-02 14:27 | MySQL Server: Partitions | Not a Bug (1300 days) | S4 | 5.7.18 | Any | Any | Group by optimization not used with partitioned tables |
94016 | 2019-01-23 10:04 | 2019-01-23 12:11 | MySQL Server: Partitions | Verified (1918 days) | S4 | 8.0 | Any | Any | Support per-partition optimization for paritioned InnoDB tables |
95486 | 2019-05-23 9:54 | 2019-05-23 13:38 | MySQL Server: Partitions | Verified (1798 days) | S4 | 5.7.26 | Any | Any | Allow to ALTER the ROW_FORMAT of a partition. |
95793 | 2019-06-13 15:24 | 2021-03-05 9:36 | MySQL Server: Partitions | Verified (1763 days) | S4 | Any | Any | Allow more functions in partitions using hash | |
96233 | 2019-07-17 13:28 | 2019-07-23 13:16 | MySQL Server: Partitions | Verified (1741 days) | S4 | 5.7.26 | Any | Any | MySQL Questions per second is decreasing with higher number of table partitions |
102606 | 2021-02-16 12:34 | 2021-02-16 12:49 | MySQL Server: Partitions | Verified (1163 days) | S4 | 8.0.23 | Any | Any | Asymmetric partitioning |
104253 | 2021-07-08 14:16 | 2021-07-09 5:48 | MySQL Server: Partitions | Verified (1020 days) | S4 | 8.0.25, 5.7.34 | Ubuntu | x86 | Allow using spatial index and geometry types with partitioned tables |
106011 | 2021-12-30 16:09 | 2022-01-20 16:58 | MySQL Server: Partitions | Verified (832 days) | S4 | 8.0 | Any | Any | REORGANIZE LIST partitions must be in consecutive order |
108152 | 2022-08-16 14:08 | 2022-08-23 13:31 | MySQL Server: Partitions | Verified (611 days) | S4 | 8.0 | Any | Any | PARTITION BY LIST COLUMNS does not normalize/format the list values |
22765 | 2006-09-27 23:01 | 2014-08-27 15:05 | MySQL Server: Partitions | Closed (5937 days) | S5 | 5.1.11-beta-log | Linux (Linux, Fedora core 5) | Any | subselect uses all partitions instead of the actual needed ones. |
26527 | 2007-02-21 14:49 | 2007-10-29 18:41 | MySQL Server: Partitions | Closed (6022 days) | S5 | 5.1.14-log | Linux (Ubuntu 6.10 x86_64/Windows) | Any | LOAD DATA INFILE extremely slow with partitioned table |
35845 | 2008-04-04 20:08 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5240 days) | S5 | 5.1.23 | Any | Any | unneccesary call to ha_start_bulk_insert for not used partitions |
38209 | 2008-07-17 17:13 | 2008-08-06 9:00 | MySQL Server: Partitions | Duplicate (5740 days) | S5 | 5.1.25 | Linux (x86_64) | Any | Partitioning becomes CPU-bound as number of partitions grows beyond 20 |
39586 | 2008-09-22 12:39 | 2008-09-23 18:42 | MySQL Server: Partitions | Not a Bug (5692 days) | S5 | 5.1.28-rc-community-log | Windows (2003 Server) | Any | Partition not used when it should be |
43923 | 2009-03-27 20:51 | 2009-03-27 21:21 | MySQL Server: Partitions | Not a Bug (5507 days) | S5 | MySQL 5.1.30-community | Windows (2003 Server) | Any | Create Table - Partition |
44059 | 2009-04-03 2:26 | 2011-02-16 23:43 | MySQL Server: Partitions | Closed (5240 days) | S5 | 5.1.32, 5.1.35-bzr | Linux (CentOS 5 kernel 2.6.18-53.el5 SMP x86_64) | Any | Incorrect cardinality of indexes on a partitioned table |
48229 | 2009-10-22 13:22 | 2011-02-16 23:44 | MySQL Server: Partitions | Closed (5059 days) | S5 | 5.1.37,5.1.38 | Linux (CentOS 4.4) | Any | group by performance issue of partitioned table |
52287 | 2010-03-23 0:46 | 2010-03-23 8:49 | MySQL Server: Partitions | Not a Bug (5146 days) | S5 | GA 5.1.36 | Other (64bit centos4.6) | Any | mysql should search only in partition p3,but it search all part |
59769 | 2011-01-27 4:00 | 2011-02-16 23:44 | MySQL Server: Partitions | Duplicate (4836 days) | S5 | 5.1 | Any | Any | partition feature/otimization |
65286 | 2012-05-11 16:28 | 2015-01-15 14:43 | MySQL Server: Partitions | Verified (4365 days) | S5 | mysql 5.1, 5.5 | Any | Any | Avoid copying on REORGANIZE PARTITION where possible |
69057 | 2013-04-24 17:41 | 2013-06-14 1:00 | MySQL Server: Partitions | No Feedback (3968 days) | S5 | 5.1 | Any | Any | Wasted work in partition_info::set_up_charset_field_preps() |
70265 | 2013-09-06 18:10 | 2015-08-23 20:45 | MySQL Server: Partitions | Verified (3880 days) | S5 | 5.6.13 | Any | Any | Optimizer under-estimates rows when there are many unmatched partitions |
72274 | 2014-04-08 11:45 | 2014-04-08 14:14 | MySQL Server: Partitions | Verified (3669 days) | S5 | 5.6.17 | Linux | Any | Allow DECIMAL as partitioning key and/or improve pruning for FLOOR(DECIMAL) |
87170 | 2017-07-23 11:40 | 2019-02-08 14:12 | MySQL Server: Partitions | Verified | S5 | 5.6.37, 5.7.19 | Any | Any | altering tables with many partitions is slower than expected |
104576 | 2021-08-10 4:18 | 2023-12-20 6:36 | MySQL Server: Partitions | Closed (929 days) | S5 | 8.0.26, 5.7.35 | Any | Any | partition table access second index lead to cpu high load |
105801 | 2021-12-05 3:35 | 2021-12-08 14:16 | MySQL Server: Partitions | Verified (868 days) | S5 | 5.7 | Any | Any | ha_innopart::records_in_range spend too much cpu cost |
106039 | 2022-01-05 7:08 | 2022-01-11 6:10 | MySQL Server: Partitions | Verified (834 days) | S5 | 8.0.27 | Any | Any | Skip using priority queue and visiting unused partitions when single partition |
79829 | 2016-01-04 3:59 | 2018-09-25 22:04 | MySQL Server: Partitions | Verified (3033 days) | S6 | 5.6, 5.5.48, 5.6.28, 5.6.29, 5.7.10, 5.7.11 | Any | Any | Assertion `i == (uint16) (*((uint16 *) (part_rec_buf_ptr)))' failed. |
86701 | 2017-06-14 19:39 | 2018-10-01 16:17 | MySQL Server: Partitions | Verified (2506 days) | S6 | 5.7/8.0 | Any | Any | Assertion failed: (type() != MYSQL_TYPE_TIMESTAMP), function check_constraints |
87512 | 2017-08-22 20:24 | 2018-10-01 16:17 | MySQL Server: Partitions | Verified (2436 days) | S6 | 5.6 | Any | Any | Server crashes when querying data from non-existing partition |
92057 | 2018-08-17 11:57 | 2018-10-26 7:18 | MySQL Server: Partitions | Closed (2007 days) | S6 | 8.0.12 | Any | Any | index->type & 32 || root != FIL_NULL || dict_table_is_discarded(m_table) |
92074 | 2018-08-20 2:38 | 2018-09-25 22:07 | MySQL Server: Partitions | Verified (2074 days) | S6 | 8.0.12, 5.7.23 | Any | Any | InnoDB: Assertion failure: ha_innodb.cc:5757:j < ncol |
92097 | 2018-08-21 2:53 | 2018-09-25 22:02 | MySQL Server: Partitions | Closed (2070 days) | S6 | 8.0.12 | Any | Any | InnoDB: Assertion failure: ha_innopart.cc:3715:can_switch |
106038 | 2022-01-05 2:24 | 2022-01-05 10:08 | MySQL Server: Partitions | Verified (840 days) | S6 | 5.7.36 | Any | Any | contribution by Tencent : alter innodb partition table crash in debug mode |
110407 | 2023-03-17 5:30 | 2023-07-21 8:48 | MySQL Server: Partitions | Verified (404 days) | S6 | 8.0.32 | Linux | x86 | mysqld crashed when execute a prepared query against partitioned table |
100971 | 2020-09-28 6:14 | 2020-10-12 20:48 | MySQL Server: Partitions | Closed (1290 days) | S7 | 8.0.21 | CentOS | Any | EXCHANGE PARTITION assert |
Showing all 769 (Edit, Save, CSV, Feed) |