MySQL Bugs: #12659: Federated storage engine needs better handling of other storage engine errors

Bug #12659	Federated storage engine needs better handling of other storage engine errors
Submitted:	18 Aug 2005 21:23	Modified:	30 Nov 2005 15:40
Reporter:	Patrick Galbraith	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:		OS:
Assigned to:	Eric Herman	CPU Architecture:	Any

Description:
Federated needs to have it's error handling and reporting of foreign server errors improved:

(two servers, one on port 5555 (archive server) and the other on port 5554 (federated server))

5554 server:

create table for federated_table:

| federated_table | CREATE TABLE `federated_table` (
  `id` int(4) NOT NULL,
  `name` varchar(54) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COMMENT='mysql://root@localhost:5555/test/archive_table' |

5555 server:

create table for archive_table:

| archive_table | CREATE TABLE `archive_table` (
  `id` int(4) NOT NULL,
  `name` varchar(54) default NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 |

5554 server:

mysql> insert into federated_table (id, name) values (1, "John Smith");
Query OK, 1 row affected (0.62 sec)

mysql> insert into federated_table (id, name) values (2, "Sam Johnson");
Query OK, 1 row affected (0.71 sec)

5555 server:

mysql> select * from archive_table;
+----+-------------+
| id | name        |
+----+-------------+
|  1 | John Smith  |
|  2 | Sam Johnson |
+----+-------------+
2 rows in set (0.00 sec)

mysql> delete from archive_table where id =1 ;
ERROR 1031 (HY000): Table storage engine for 'archive_table' doesn't have this option

5554 server:

mysql> delete from federated_table where id = 1;
ERROR 1430 (HY000): There was a problem processing the query on the foreign data source. Data source error: 'b†   ºπ'

5555 server:

mysql> select * from archive_table;
+----+-------------+
| id | name        |
+----+-------------+
|  1 | John Smith  |
|  2 | Sam Johnson |
+----+-------------+
2 rows in set (0.00 sec)

How to repeat:
follow steps above

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/29542

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/29572

there is still room for a little bit of clean-up with federated errors, but things are better.