| Bug #14355 | Partitions: SHOW ENGINES shows partition=no | ||
|---|---|---|---|
| Submitted: | 26 Oct 2005 22:16 | Modified: | 20 Jan 2006 2:45 |
| Reporter: | Peter Gulutzan | ||
| Status: | Closed | ||
| Category: | Server: Partition | Severity: | S3 (Non-critical) |
| Version: | 5.1.2-alpha-debug | OS: | Linux (SUSE 10.0) |
| Assigned to: | Mikael Ronstrom | Target Version: | |
[31 Oct 2005 23:05]
Mikael Ronstrom
Completely agree with the comment but still not a bug
[31 Oct 2005 23:13]
Mikael Ronstrom
By closer thought one should ensure that the partition engine is not listed in show engines.
[2 Nov 2005 19:53]
Mikael Ronstrom
Partition engine and Binlog is now not shown in SHOW ENGINES command. Also changed name on have_partition_engine to have_partition_support
[19 Jan 2006 10:18]
Mikael Ronstrom
Fixed, will at least appear in 5.1.6
[20 Jan 2006 2:45]
Paul DuBois
Noted in 5.1.6 changelog.
Partition support is not an <quote>engine</quote>, but it was
included in the output of <literal>SHOW ENGINES</literal>. Now
it does not. (Bug #14355)
Description: The partition feature is called an "engine". So when I say "show variables like '%partition%'" I see have_partition_engine=YES. But when I say "show engines" I see "partition=NO. I would consider it a good "fix" if everyone stopped calling partitions an engine. How to repeat: mysql> show variables like '%partition%'; +-----------------------+-------+ | Variable_name | Value | +-----------------------+-------+ | have_partition_engine | YES | +-----------------------+-------+ 1 row in set (0.00 sec) mysql> show engines; +------------+----------+------------------------------------------------------------------------+ | Engine | Support | Comment | +------------+----------+------------------------------------------------------------------------+ | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | | InnoDB | YES | Supports transactions, row-level locking, and foreign keys | | BerkeleyDB | YES | Supports transactions and page-level locking | | ARCHIVE | YES | Archive storage engine | | CSV | YES | CSV storage engine | | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | | FEDERATED | YES | Federated MySQL storage engine | | ndbcluster | DISABLED | Clustered, fault-tolerant, memory-based tables | | partition | NO | | | MRG_MYISAM | YES | Collection of identical MyISAM tables | | binlog | DISABLED | This is a meta storage engine to represent the binlog in a transaction | +------------+----------+------------------------------------------------------------------------+ 12 rows in set (0.00 sec)