Bug #25508 Federated: Failure to Remove Partitioning

Submitted: 9 Jan 2007 23:54 Modified: 11 Jan 2007 9:10
Reporter: Peter Gulutzan Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Federated storage engine Severity:S3 (Non-critical)
Version:5.2.0 OS:Linux (SUSE 10.0 / 64-bit)
Assigned to: 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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.