MySQL Forums
Forum List  »  Partitioning

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


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?



Options: ReplyQuote

Written By
Drop partition while running a query
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.