
13 Oct
2016
13 Oct
'16
5:18 p.m.
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.