title: SQLite Left Outer Join not working as expected in Android
body: <p>I have prepared a left outer join query that should be returning non-null data when a record exists in my BLOB table that matches keys with a record in my INCIDENT table.</p>
  
  <p>Essentially, the data and query looks like this:</p>
  
  <pre>
  Table A
     Key
  
  Table B
     Key
     Blob
  </pre>
  
  <p>and the query I'm running, should show all records from A, and the 'hasb' column should be 1 if there's a record in B with a matching key column, or 0 if there isn't. So the query should look like this:</p>
  
  <pre><code>SELECT A.*, ifnull(A.Key = B.Key, 0) as hasb FROM A
  LEFT OUTER JOIN B ON A.Key = B.Key
  </code></pre>
  
  <p>Ok, so my problem is, this query seems to work everywhere I try to use it EXCEPT on the Android device.</p>
  
  <p>Here's a SQLFiddle with the actual tables and query in question. Note that the query works there.</p>
  
  <p><a href="http://sqlfiddle.com/#!7/89e7d/4" rel="nofollow">http://sqlfiddle.com/#!7/89e7d/4</a></p>
  
  <p>Anyone know why this doesn't work on Android? The device I'm testing with is a Samsung Galaxy S 3 running Android 4.1.1.</p>