title: Sphinx rotation not removing old records?
body: <p>I removed records from a table using a Mysql Editor.</p>
  
  <p>This table was previously indexed by <code>Sphinx</code> (using <code>indexer --rotate</code>).</p>
  
  <p>When I re-rotate again using <code>indexer --rotate</code> the old record can still be queried.</p>
  
  <p>To test whether the index is actually being obeyed I</p>
  
  <ul>
  <li>Added a new record</li>
  <li>Modified an old one</li>
  </ul>
  
  <p>I re-rotated and the new/modified records were as expected yet the deleted record was still being found during a SphinxQL query.</p>
  
  <p>Lastly, I added a <code>Where</code> condition to the indexing so it would only index those records where <code>Add=1</code>.</p>
  
  <p>I then added back the old record with its original ID and and set <code>Add=0</code>.</p>
  
  <p>NOW the record is not found during SphinxQL query.</p>
  
  <p>I've read various solutions in the interim such as having a secondary 'Deleted Records' table the index can query yet this seems like a difficult and error-prone solution.</p>
  
  <p>Isn't there a simpler way to have Sphinx simply re-create the index with only the existing records?</p>
  
  <p>Since I do a daily rotation would deleting the index and then rotating it work? I'd test it but since Sphinx is so finicky would prefer to ask before breaking anything.</p>