I’m having an issue that I traced to this unexpected (by me) behavior: ‘False’ values for boolean fields show up as NULL in SQL Runner, and of course in query results as well.
Here’s a simple example. I made a very simple table, seen here as queried from Postgres’s command line client:
=> select bar, count(*) from foo group by bar;
bar | count
f | 1
t | 1
You can see there is one NULL, one False, and one True.
Now run that same SQL in SQL Runner:
Query returned 3 rows in 0.003s
So that’s weird. Why is Looker declaring False values to be NULL? And then, why isn’t it grouping those NULL values together?