Hi Alexey, could you share what your "condition1" and "condition2" look like? You can see the logical relational plan and physical MAL plan of the queries by prefixing your SQL query with PLAN and EXPLAIN, respectively, and get a detailed trace of the execution by prefixing your SQL query with TRACE. It would be helpful for us, if you can produce traces where the single condition return the correct (same) result, but the conjunctive condition returns an empty result, and file a bug report with these traces attached. Of course, a "minimal" example to reproduce the problem woudl be perfect ... Stefan On Mon, Apr 23, 2012 at 04:31:43PM +0200, Alexey Mints wrote:

Hello! I have a strange behavior of my MonetDB database. After some actions I run into situation, when queries select * from table1 where {condition1}; and select * from table1 where {condition2}; return the same results (same rows), but select * from table1 where {condition1} and {condition2}; is empty, which is definitely wrong. I cannot see any problems from SQL-side. I am still struggling to get a minimal code producing this bug. Even worse - it is not always occurring under the same conditions... How can I get more information on what's happened? Alexey

------------------------------------------------------------------------------ For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |