Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

where clause with cast and floor fails to sigsegv #6071

monetdb-team opened this issue Nov 30, 2020 · 0 comments

where clause with cast and floor fails to sigsegv #6071

monetdb-team opened this issue Nov 30, 2020 · 0 comments


Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

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, 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 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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant