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

Monetdb crashes on query with limit after sort with case #6512

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

Monetdb crashes on query with limit after sort with case #6512

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
bug Something isn't working major SQL

Comments

@monetdb-team
Copy link

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
@monetdb-team monetdb-team added bug Something isn't working major SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working major SQL
Projects
None yet
Development

No branches or pull requests

2 participants