Guy Gordon wrote:
> I have a MyISAM merge table that works with MySQL 5.0.27, but fails when I try
> to upgrade to 5.0.37. The error is 1168: "Unable to open underlying table which
> is differently defined or non-MyISAM type, or doesn't exist."
> The problem is, they *do* exists. When I switch back to 5.0.27 everything works
> fine. Can anyone tell me what changed that is failing these?
It sounds like you may be hitting http://bugs.mysql.com/bug.php?id=26881. This bug
doesn't affect 5.0.27.
Todd Farmer, Support Engineer
MySQL Inc., www.mysql.com
MySQL Conference & Expo - http://www.mysqlconf.com/
April 23-26 in Santa Clara, California (US)