Hi,

I am getting weird behavior with a query that involves a LIKE comparison:

This is the query:

SELECT ("test2"."a1") AS "a1", (Count(DISTINCT CASE WHEN (Lower("test2"."a2") LIKE '%aaa%') THEN "test2"."a3" ELSE NULL END)) AS "m1" FROM "test"."test2" GROUP BY "test2"."a1"

Whenever I run this query I get different results in my m1 field. If I remove the LIKE then it behaves fine.

I can't seem to reproduce it on new tables with little data, but with the data I have (a table with 109402 rows) it does reproduce all the time.

Can I upload the dbfarm and file this as a bug?