Drop partition operations don't follow the catalog's locking protocol

The CatalogOpExecutor.alterTableDropPartition() function violates the locking protocol used in the catalog that requires catalogLock_ to be acquired before any table-level lock. That may cause deadlocks when this statement is executed concurrently with other DDL operations.