Bug #120124 Remove unused partition states from enum partition_state {
Submitted: 22 Mar 10:29
Reporter: Rahul Sisondia Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:9.6 OS:Any
Assigned to: CPU Architecture:Any
Tags: innodb, partition table

[22 Mar 10:29] Rahul Sisondia
Description:
"WL#2604: Partition Management" introduced some of the partition states are no longer used today except in the comments. We should remove them from the 

`enum partition_state;` and improve doxygen. 

How to repeat:
git show e802a94284e904224a7dc6a40e32a09d2266a546 | grep -E "PART_IS_DROPPED|PART_IS_CHANGED|PART_IS_ADDED" | wc -l 
      36

git grep -irE  "PART_IS_CHANGED|PART_IS_ADDED" storage/innobase sql/ | wc -l                                        
       9

Execute to see how the 9 instances are used today. 

git grep -irEC 3 "PART_IS_CHANGED|PART_IS_ADDED" storage/innobase sql/

Suggested fix:
Remove the stale code and improve the doxygen.