Thanks Stefan, will do. George Ramonov UC Berkeley B.S. Electrical Engineering & Computer Science '13 http://www.linkedin.com/in/georgeramonov On Sat, Jun 14, 2014 at 2:01 PM, Stefan Manegold wrote:

Dear George,

this is most probably a bug somewhere in MonetDB.

Please file a bug report at bugs.monetdb.org

Best, Stefan

----- Original Message -----

...

Hi,

I am still learning about monetdb internals, so I hope someone can enlighten me here.

I was playing around with monetdb, and run into the following problem:

Suppose we have a table

CREATE TABLE test.simple_table("id" INTEGER);

INSERT INTO test.simple_table VALUES (1),(2),(3),(4),(5);

Let's say I want to run a simple query:

SELECT COUNT(*) AS val FROM test.simple_table ORDER BY val DESC;

+----+ | v | +==+ | 5 | +----+

Runs fine. However, if add a LIMIT clause:

SELECT COUNT(*) AS val FROM test.simple_table ORDER BY val DESC LIMIT 5;

I get the following

TypeException:user.s37_7[17]:'algebra.markT' undefined in: _30:any := algebra.markT(_27:oid, _29:oid) program contains errors

Now things let's add a primitive HAVING clause

SELECT COUNT(*) AS val FROM test.simple_table

HAVING 1 > 0

ORDER BY val DESC LIMIT 5;

+----+ | v | +==+ | 5 | +----+

And things are magically fine again. Can someone explain what's going on?

Thanks,

George Ramonov UC Berkeley B.S. Electrical Engineering & Computer Science '13

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list