On Thu, Sep 17, 2009 at 05:25:10AM -0700, Alex Bo. wrote:

I ran the same query on the Aug09 release. This time the Monet doesn't crash, but throws this error:

!TypeException:user.s5_3[21]:'algebra.semijoin' undefined in: _31:any := algebra.semijoin(_30:wrd, _28:wrd) !SQLException:SQLengine:Program contains errors

Is this a bug?

Yes still a but. Indeed there is no function semijoin on single values. So I probably generate incorrect mal. I'll look at this later today. Could you create an bug report for it?

Niels

Alex Bo. wrote:

...

Hi,

I am running FebSP2 on Windows. The following query crashes Monet:

SELECT COUNT (*) AS c1, COUNT (*) AS c2 FROM t2 limit 100

The following queries do work:

1. Same but with only 1 aggregation field: SELECT COUNT (*) AS c1 FROM t2

limit 100

2. Same but without LIMIT: SELECT COUNT (*) AS c1, COUNT (*) AS c2 FROM t2

This seems like a bug.

Thanks, Alex.

-- View this message in context: http://www.nabble.com/Two-count%28*%29-in-query-with-LIMIT-crashes-Monet-tp2... Sent from the monetdb-users mailing list archive at Nabble.com.

---

Come build with us! The BlackBerry® 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/devconf _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users