title: "Unknown column in 'field list'", but column does exist
body: <pre><code>DROP TABLE IF EXISTS `transactions`;
  CREATE TABLE `transactions` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `purchase_date` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  INSERT INTO `transactions` (`purchase_date`) VALUES (NULL)
  </code></pre>
  
  <p>I've isolated my problem in this code. When I run it, I get the error:</p>
  
  <blockquote>
    <p>[ERROR in query 3] Unknown column 'purchase_date' in 'field list'</p>
  </blockquote>
  
  <p>Anyone an idea?</p>