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? -- View this message in context: http://old.nabble.com/Different-query-results-after-each-execution-tp2766695... Sent from the monetdb-users mailing list archive at Nabble.com.