Re: [MonetDB-users] Strange things...
7 May
2012
7 May
'12
3:43 p.m.
Dear All! My old problem http://sourceforge.net/mailarchive/message.php?msg_id=29168305 strikes back on the new version. The situation is just the same - combination of two conditions gives empty result (that is wrong), while each condition alone gives correct resultset. The problem shows up only in the SECOND run of quite a huge set of queries (the first one runs Ok). Even more, there has to be some delay (~10 sec) before the second run, otherwise everything works. Deleting all records does not help, problem disappears only if I recreate the table.
What on Earth can this be? It seems rather hard to pin down the problem with SQL-methods only. Just in case - I attach traces of correct and incorrect queries.
Regards, Alexey Mints
4395
Age (days ago)
4395
Last active (days ago)
0 comments
1 participants
participants (1)
-
Alexey Mints