On Thu, Jun 18, 2015 at 06:00:05PM -0700, Raffael Marty wrote:
I might be doing something wrong, but should this really throw a division by zero?
SELECT count(*) / ((max("end")-min(start)) / 60) FROM table GROUP BY s HAVING max("end")-min(start)<>0 ;
Strangely enough, this works:
SELECT count(*) / ((max("end")-min(start))) FROM table GROUP BY s HAVING max("end")-min(start)<>0;
Am I doing something wrong?
Raffael Seems a bug, ie could you report it on the bugtracker. Including an example of the problem (with ddl statements)? Niels
Thanks
Raffael
—
Visual Analytics Workshop at #BlackHat US in August: http://bit.ly/1FN1W5e Raffael Marty ceo @ pixlcloud http://pixlcloud.com @raffaelmarty http://raffy.ch _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: https://www.cwi.nl/people/niels e-mail: Niels.Nes@cwi.nl