title: SQLite Transactions not working
body: <p>I'm trying to perform an SQLite transaction in DB Browser for SQLite, but there's an unexpected behavior. I misspelled the name of a table intentionally in one of my query, but still its inserting data in other tables except for the one I misspelled.
  Here is my query:</p>
  
  <pre><code>BEGIN; 
  INSERT INTO vouchers (person_id, date, amount, description, mop, transaction_id) VALUES('XXXX','XXXX','XXX','XXX','XXXX','XXXX'); 
  INSERT INTO personal_info (id, name, address, city, state, mobile, member) VALUES('XXXX','XXXX','XXXX','XXX','XXX','XX','XX'); 
  INSERT INTO membership_info (person_id, join_date, transaction_id) VALUES('XXX','XXX','XXX'); 
  INSERT INTO cas (id, person_id, date, remarks, type, amount, balance) VALUES('XXXX','XXXX','XXXXX','XXXX','XXX','XXX','XXX') ; 
  COMMIT;
  </code></pre>
  
  <p>I intentionally misspelled the the table name in last query <code>INSERT INTO cas</code> instead of <code>INSERT INTO cash</code> but still rest of the queries are working except the last one. I also tried replacing the <code>COMMIT;</code> with <code>ROLLBACK;</code></p>