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? 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.