On 13 Oct 2016, at 19:18, imad hajj chahine wrote:

Hi,

When paginating over a view that contains a calculated double columns. i got a TypeException error and sometimes the server crash.

To replicate the error, create a table with 2 double columns col1 and col2, fill it with some test data; after create a view as select col1, col2, col1+col2 as col3 from table.

when running select col1, col2, col3 from view limit 100 offset 100 i got the error.

Also in related context, when i use 2 quantiles function on the calculated view column i get the same error. select quantile(col3, 0.25), quantile(col3, 0.75) from view.

I am using jun2016-sp1 on windows.

Hai, I think you can best fire a bug report for this, with the exact SQL queries to reproduce the problem. Thanks! Jennie

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