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.

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

Page generated in 0.053 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.