Can you submit this as bug report to the bug tracker please? You can find the bugtracker at https://sourceforge.net/tracker/?atid=482468&group_id=56967. Thanks. On 2009-10-23 00:40, Allen Zhang wrote:
Hi, There,
We encounter such a strange problem in the union in monetdb, when run attached sql. The where condition did not get applied towards the last union recordset.
So the result from the attached sql is like
2009ABC
2008ABC
2007ABC
ADD
Notice the ADD get into the result!!
But when we remove the last union of ADD, then the ABD gets into the result.
Looks like the where condition gets ignored in the last union.
Regards
Allen
------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Sjoerd Mullender