Here are the results of a few different SQL strings (let's assume the
schemas are valid for the data types used):

SELECT * from myTable where key1 = true  -> no filters are pushed to my
PrunedFilteredScan
SELECT * from myTable where key1 = true and key2 = 5 -> 1 filter (key2) is
pushed to my PrunedFilteredScan
SELECT * from myTable where key1 = false and key3 = 'val3' -> 1 filter
(key3) is pushed to my PrunedFilteredScan
SELECT * from myTable where key1 = 'false' -> (as expected) it passed down
an EqualTo Filter that's matching 'false' as a string.


I was going to file a bug for this but before I did that I wanted to make
sure I wasn't missing something (like a special way to handle booleans).
I'm assuming the filter is being optimized out because it's being assigned
the literal "true" but in this case I really want to match against a
boolean datatype which is true.

Reply via email to