Describe the bug

1. create a table.
2. add a temp partition to this table.
3. modify the table to enable the dynamic partition feature.
4. when trying to drop the temp partition, encounter error:
   can not drop partition when dynamic partition is enable
5. when trying to disable the dynamic partition, encounter error:
   can not modify table when there is temp partitions

This logic is a dead lock. We should fix it.