[MonetDB-users] query dit not produce result set
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
Interesting. Looks like a bug to me. Can you submit an entry on the bugtracker, please. http://bugs.monetdb.org/ When I try this I see that the server prints: could not find (null).e dbg.d dbg.L13 L15.L15 dbg.d and with assertions enabled, in addition it says: mserver5: /home/sjoerd/src/MonetDB/candidate/sql/server/rel_bin.c:1481: rel2bin_project: Assertion `0' failed. Aborted - core dumped On 2011-04-04 13:52, Bas Kaptijn wrote:
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
------------------------------------------------------------------------------ Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Sjoerd Mullender
participants (2)
-
Bas Kaptijn -
Sjoerd Mullender