Thanks Stefan, will do.

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


On Sat, Jun 14, 2014 at 2:01 PM, Stefan Manegold <Stefan.Manegold@cwi.nl> 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