[MonetDB-users] Different query results after each execution
20 Feb
2010
20 Feb
'10
2:40 p.m.
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.
5194
Age (days ago)
5194
Last active (days ago)
0 comments
1 participants
participants (1)
-
Alex Bo.