MySQL Forums
Forum List  »  Merge Storage Engine

Merge table not usable
Posted by: Shourav De
Date: May 03, 2007 01:45PM

I have been trying to create this merge table since yesterday. It gets created but if I try to run some select statements on it, I always get this error:

Error Code : 1168
Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist

I am trying to merge 25 tables which follow this schema:

CREATE TABLE `fa_atlga` (
`DeedRecordID` int(11) NOT NULL,
`TaxRecordID` int(11) default NULL,
`CurrentDeedRecordID` int(11) default NULL,
`DateLoaded` datetime NOT NULL,
`RLVendorJobDate` date NOT NULL,

(tons more rows here)

`FIPS` int(9) default NULL,
PRIMARY KEY (`DeedRecordID`),
KEY `FIPS` (`FIPS`),
KEY `UNFORMATTEDAPN` (`UNFORMATTEDAPN`),
KEY `PROPERTYADDRESSZIPCODE` (`PROPERTYADDRESSZIPCODE`),
KEY `TransactionDate` (`TransactionDate`),
KEY `RECORDINGDATE` (`RECORDINGDATE`),
KEY `BATCH` (`BATCHID`,`BATCHSEQ`),
KEY `EXCLUDE` (`Exclude`),
KEY `LockedForPublication` (`LockedForPublication`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

The schema for the merge table is same as above except that Primary Key (DeedRecordID) became just Key(DeedRecordID) and ENGINE=MyISAM DEFAULT CHARSET=latin1 became ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1 UNION=(table_name, tablename).

I have triple checked and all the definitions are same across all tables as well as for the merge table.

Pleasd HELP!

Options: ReplyQuote


Subject
Views
Written By
Posted
Merge table not usable
11877
May 03, 2007 01:45PM
6659
May 04, 2007 01:46PM


Sorry, you can't reply to this topic. It has been closed.

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.