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