search

pawelsalawa / sqlitestudio

A free, open source, multi-platform SQLite database manager.
https://sqlitestudio.pl
Other
4.67k stars 571 forks source link

bug in filter #5065

Closed Eyderoe closed 4 days ago

Eyderoe commented 2 months ago

after filter, true become real true image image

pawelsalawa commented 2 months ago

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

Eyderoe commented 2 months ago

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 image image

pawelsalawa commented 2 months ago

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 commented 2 months ago

yep thanks for your effort