Bug #9463 wrong error msg: merge on non existng tables
Submitted: 29 Mar 2005 18:20 Modified: 14 Aug 2006 16:29
Reporter: Martin Friebe (Gold Quality Contributor) (OCA) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:4, 5.0 OS:FreeBSD (freebsd / *)
Assigned to: Assigned Account CPU Architecture:Any

[29 Mar 2005 18:20] Martin Friebe 
Description:
A merge table can contain references to non existing tables. accessing such a merge table, returns a misleading error.

How to repeat:
# a3,a2 and a1 do not exist

create table mg1 (a int) engine=merge union (a3,a2,a1);
#Query OK, 0 rows affected (0.00 sec)

select * from mg1;
#ERROR 1017 (HY000): Can't find file: 'mg1.MRG' (errno: 2)

# the file mg1.MRG exists, and contains the filenames (with path) to the 3 non existing tables. 

Suggested fix:
The error msg should say

tables a3,a2 and a1 do not exist

or as other errors, only reporting the first error.

table a3 does not exist
[13 Aug 2006 13:26] Sergey Vojtovich 
Stealing this one as it will likely fixed with patch for bug#457.
[14 Aug 2006 16:29] Sergey Vojtovich 
This bug is a duplicate of bug#457.