Title: How to create a merge table from a partitioned table and a unpartitioned table
Tags: mysql;merge;union
Question: I have a partitioned table and an unpartitioned table in a mysql table. I will like to create a union merge table for the two tables. The problem is, after creating the merge table, I get this error when I try to access the table: Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist
When I run the check table command on it, I get the following errors(ptable is the partitioned table):
Table 'mydb.ptable' is differently defined or of non-MyISAM type or doesn't exist
Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist
Corrupt


Here is another answer: From the MySQL docs u cannot have tables with partitions to be used in the MERGE storage engine
MERGE tables do not support partitioning. That is, you cannot partition a MERGE table, nor can any of a MERGE table's underlying MyISAM tables be partitioned.

Here is another answer: Are you sure both the partitioned table and non-partitioned table are of MyISAM type? they should be. (Please make sure 'ptable' is of MyIsam type).
Continue reading here.
Comment for this answer: Yes, the both are. I already read that blog and run a "show create table " command on the tables to double check.

{'source': 'StackExchangeDataset', 'subset': 'stackoverflow.com', 'metadata': {'AnswerCount': 2, 'CommentCount': 0, 'ContentLicense': 'CC BY-SA 3.0', 'CreationDate': '2013:00:01/29/13', 'FavoriteCount': 1.0, 'PostTypeId': 1, 'Tags': '<mysql><merge><union>', 'Title': 'How to create a merge table from a partitioned table and a unpartitioned table', 'ViewCount': 1177, 'id': 14578933, 'user_AboutMe': '<p>Programmer at DreamOval Ltd., Ghana.\nI love Java and Kotlin.\nVery good at Android development.\nBeginner level IOS development.</p>\n', 'user_AccountId': 948462.0, 'user_DisplayName': 'euniceadu', 'user_Reputation': 858.0, 'user_Views': 132.0, 'user_id': 975178.0}}