Tinyint field set to true in condition

[TomD]

@swf

Looks like an older bug is back.

I think this is the way it works - and the bug is fixed, eg as discussed in this thread:

@TomD

This seems to work for me. If I enter 1 for the value, it’s still converted to ‘true’ as displayed in query builder but the query works now. The query which is actually executed is:
WHERE (tinyint_col = 1)