bug in filter

[Eyderoe]

after filter, true become real true

[pawelsalawa]

I have no idea what the problem is. Could you explain in a different way?

[Eyderoe]

the raw correct data is 17 197 17 197 17 197
after filter become 1 1 1 1 1 1 (column name is "true")
and wonderfully if the column name is "false"
after filter data will become 0 0 0 0 0 0

[pawelsalawa]

Oh, I see. Yeah, it seems that during filtering the column names true and false aren't correctly quoted in subquery by SQLiteStudio, thus returning interpreted integer value of logical value true/false. Indeed this is a bug.

[Eyderoe]

yep thanks for your effort