Hi,

with the MAR2010 release (x64 windows through installer) (and also the release Feb2010-SP2) I get an exception running a particular query, whilst

a slightly modified one with the expected result (except for the naming of a result column) does not. I narrowed

the problem down to this:

sql>CREATE TABLE dbg (a INT, b INT);

operation successful

sql>INSERT INTO dbg (a,b) VALUES (10,10);

1 affected row (32.410ms)

sql>SELECT a as d, SUM(b), (2 * (SUM(b) / (SELECT 2))) as f FROM dbg GROUP BY d;

+------+------+------+

| d    | L451 | f    |

+======+======+======+

|   10 |   10 |   10 |

+------+------+------+

1 tuple (8.841ms)

sql>SELECT a as d, SUM(b) as e, (2 * (SUM(b) / (SELECT 2))) as f FROM dbg GROUP

BY d;

sql>

The second select query does not produce a result set (as stated in the SQLException I get when doing this through JDBC). The monetdb client

just shows a new prompt without stating any warning/error. The query works when I remove the “as e” … or the “select 2” but in the real case

I get this problem this select does much more than just selecting the number 2.

I think this is a bug. Or am I doing something that is not (yet) supported in MonetDB?

Thanks

Bas Kaptijn