Partitioned table problem after upgrade to 5.5
Posted by:
Ming Wang
Date: March 06, 2013 04:07AM
hi All
i have a hash partitioned table in MySQL 5.1.
and there is a compound unique index on this table.
i stop mysql 5.1 service and copy all the data to the mysql 5.5 server.
and all other tables are working well except this partitioned table.
i try to use a string to query the record in this partitioned table, it returns to me no record. The string column is one of the unique index column.
but definately there is a record there because i can query from the ID.
anyone met this problem?
and anyone know how to solve this?
thanks.
Jack
Subject
Views
Written By
Posted
Partitioned table problem after upgrade to 5.5
2877
March 06, 2013 04:07AM
1515
March 06, 2013 04:38AM
1403
March 07, 2013 08:23PM
1296
March 07, 2013 11:32PM
1344
March 08, 2013 02:20AM
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.