Bug #25508 Federated: Failure to Remove Partitioning

• Submitted: 9 Jan 2007 23:54
• Modified: 11 Jan 2007 9:10
• Reporter: Peter Gulutzan
• Status: Verified
• Category: MySQL Server: Federated storage engine
• Severity: S3 (Non-critical)
• Version: 5.2.0
• OS: Linux (SUSE 10.0 / 64-bit)
• CPU Architecture: Any

[9 Jan 2007 23:54] Peter Gulutzan

Description:
On a remote computer, I create a table with partitioning.
On a local computer, I create a matching federated table, with partitioning.
On the local computer, I try to remove the partitioning.
I get an error message: "Table storage engine doesn't have this option".
But it should have this option. It allowed me to create with partitioning.

How to repeat:
On the remote computer, say:
create table t100 (s1 char(5) character set utf8, primary key (s1,s2), s2 int)
  partition by list (s2) (partition p1 values in (1,2,3),partition p2 values in (4,5,6));

On the local computer, say:

create table t100 (s1 char(5) character set utf8, primary key (s1,s2), s2 int)
  ENGINE=FEDERATED
  CONNECTION='mysql://Remote@192.168.1.106/test/t100'
  partition by list (s2) (partition p1 values in (1,2,3),partition p2 values in (4,5,6));
  /* Change User and Host to what's appropriate for you. */

On the local computer, say:
  ALTER TABLE t100 REMOVE PARTITIONING;

The error message will be:
  ERROR 1031 Table storage engine for 't100` doesn't have this option.

[10 Jan 2007 2:13] MySQL Verification Team

Thank you for the bug report.

[miguel@light 5.2]$ bin/mysql -uroot --prompt='local>'
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.2.0-alpha-debug Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

local>use test
Database changed
local>create table t100 (s1 char(5) character set utf8, primary key (s1,s2), s2 int)
    ->   ENGINE=FEDERATED
    ->   CONNECTION='mysql://miguel@192.168.0.121/test/t100'
    ->   partition by list (s2) (partition p1 values in (1,2,3),partition p2 values in
    -> (4,5,6));
Query OK, 0 rows affected (1.02 sec)

local>ALTER TABLE t100 REMOVE PARTITIONING;
ERROR 1031 (HY000): Table storage engine for 't100' doesn't have this option
local>

[20 Feb 2008 19:42] Omer Barnir

triage: assumed to fail in 5.1 as well