test cardinality with a single alter table drop add command