Re: Division By Zero

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