title: Drop view which does not exist
body: <p>I am unable to create a view. It throws an error that that table already exists, but if I try to drop it, it says unknown table. I checked out this <a href="https://stackoverflow.com/questions/10538908/schrodingers-mysql-table-exists-yet-it-does-not">question</a> but it didnt help much.</p>
  
  <pre><code>drop view if exists foo;
  create view foo ... ;
  # Table foo already exists
  drop table / DROP TABLE IF EXISTS foo;
  # unknown table foo
  </code></pre>
  
  <p><code>Flush table/repair table</code> didnt solve either. Any ideas ?</p>