Monetdb crashes on query with limit after sort with case

[monetdb-team]

Date: 2018-01-12 14:01:51 +0100
From: Manuel <>
To: SQL devs <>
Version: 11.27.11 (Jul2017-SP3)
CC: @njnes

Last updated: 2018-02-12 16:12:15 +0100

Comment 26073

Date: 2018-01-12 14:01:51 +0100
From: Manuel <>

User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36
Build Identifier:

I have seen this crash that I have been able to reproduce it every time.

When I run the query contained in query.sql, against the dataset contained in BondPricesWithNulls.sql, Montedb crashes with the error:

Error: could not allocate space
SQLState: HY001
ErrorCode: 0
Error: COLnew:tt error
SQLState: 22000
ErrorCode: 0

Using a nested query solves the issue.

Reproducible: Always

Steps to Reproduce:

1. Import the table contained in BondPricesWithNulls.sql
2. Run the query contained in query.sql

Actual Results:

crash

Comment 26074

Date: 2018-01-12 14:02:25 +0100
From: Manuel <>

Created attachment 589
the table used in the query

Attached file: BondPricesWithNulls.sql (text/plain, 210717 bytes)
Description: the table used in the query

Comment 26075

Date: 2018-01-12 14:02:58 +0100
From: Manuel <>

Created attachment 590
query.sql

Attached file: query.sql (text/plain, 37144 bytes)
Description: query.sql

Comment 26088

Date: 2018-01-18 08:05:55 +0100
From: @njnes

make sure we only call bat.single on constants (ie not on bats).

Comment 26091

Date: 2018-01-18 08:08:04 +0100
From: MonetDB Mercurial Repository <>

Changeset 248aa8f21695 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=248aa8f21695

Changeset description:

Fixes for bugs 6510, 6512, 6514 and 6515

6510 start sum's at 0 instead of nil in case of count/sum 2 step aggregation
6512 make sure we only call bat.single on constants (ie not on bats).
6514 handle NULL (type void) on both sides of an compare operator, ie cast to a valid type.
6515 handle null in calc.second_interval

Comment 26095

Date: 2018-01-18 08:17:32 +0100
From: MonetDB Mercurial Repository <>

Changeset d6a18014adce made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=d6a18014adce

Changeset description:

add test and output for bug #6512