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