Date: 2016-10-10 12:22:51 +0200
From: @bartscheers
To: SQL devs <>
Version: 11.23.7 (Jun2016-SP1)
CC: @njnes

Last updated: 2016-12-21 13:07:41 +0100

Comment 24472

Date: 2016-10-10 12:22:51 +0200
From: @bartscheers

Created attachment 472
csv file with the data

Join two select queries, using a where clause from two different columns, fails when cast and floor is used.

Attached file: cat7and5.csv (text/csv, 45226 bytes)
Description: csv file with the data

Comment 24473

Date: 2016-10-10 12:23:46 +0200
From: @bartscheers

Created attachment 473
table definition

Attached file: create.catsrc.sql (application/sql, 191 bytes)
Description: table definition

Comment 24474

Date: 2016-10-10 12:24:18 +0200
From: @bartscheers

Created attachment 474
copy into to load the data

Attached file: load.catsrc.sql (application/sql, 82 bytes)
Description: copy into to load the data

Comment 24475

Date: 2016-10-10 12:25:23 +0200
From: @bartscheers

Created attachment 475
the buggy query

When uncommenting the clause around c2.zone, the query crashes the server

Attached file: bug_query.sql (application/sql, 1235 bytes)
Description: the buggy query

Comment 24481

Date: 2016-10-12 14:24:14 +0200
From: MonetDB Mercurial Repository <>

Changeset 2ceeb49da970 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=2ceeb49da970

Changeset description:

Avoid division by zero.
This fixes bug #6071.

Comment 24484

Date: 2016-10-12 19:00:57 +0200
From: @njnes

was fixed by sjoerd. Added a test for this