MySQL Forums
Forum List  »  Partitioning

Drop partition while running a query
Posted by: Eric Her
Date: December 21, 2006 10:21AM

Hi

Imagine that you have a table partitioned by range and each partition have millions of rows. What happen to an ongoing query that "uses" a partition and this partition is dropped by another process? In which state this query is going to fall? Is it canceled automatically or immediately returns an empty result set or it falls in a black hole?

Thanks

Eric

Options: ReplyQuote


Subject
Views
Written By
Posted
Drop partition while running a query
3563
December 21, 2006 10:21AM


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.