weird behavior when using views with calculated columns and double type
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.
Thank you.
On 13 Oct 2016, at 19:18, imad hajj chahine imad.hajj.chahine@gmail.com 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
participants (2)
-
imad hajj chahine -
Ying Zhang