i just came across this behavior, which seems weird to me.
i have a node type with a required term reference field "field_state", which references the "state" vocabulary. when i have created a published node of that type, the following rows exist in the database:
- a row in the table field_data_field_state
- a row in the table taxonomy_index
if i unpublish that node, the row in taxonomy_index disappears. if i publish the node, the row in taxonomy_index reappears.
is this the expected behavior? if so, i have to ask why? is the taxonomy_index table being phased out?
thanks for any insights.