I am getting following exception while executing merge query in mysql 3.2. I am using embedded java library called mysql-je. Its an open source project (http://mysql-je.sourceforge.net/).
EXCEPTION IN RESULTSET WRAPPER WHILE EXECUTING QUERY: java.sql.SQLException: All tables in the MERGE table are not identically definedjava.sql.SQLException: All tables in the MERGE table are not identically defined
at com.mysql.embedded.api.api.mysql_real_query(Native Method)
Thanks in advance,
David O'Meara wrote:the error message is pretty informative. have you looked at that?
Yes I did search for that but I found no solution. They all were talking about incompatible engine type and datatype. But I've all tables created with MyISAM.
Alright, thanks for the info. I read that but it was working fine with the original mysql daemon. I've just copied the whole database from another location. Do you have anything in mind that can be solve this problem.
Tim McGuire wrote:It seems pretty clear that the tables are not identical. Could you post the DDL for each table so we can compare them?
Yeah sure.. Here it is..
Both the table has the following schema.. Because the tables are automatically made from a script. There is only difference in name of the table. They both have date as postfix.