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 when executing SQL with window function #3891

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

MonetDB crashes when executing SQL with window function #3891

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

Comments

@monetdb-team
Copy link

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

Date: 2015-12-18 17:40:21 +0100
From: Kaijiang <>
To: SQL devs <>
Version: 11.21.11 (Jul2015-SP1)
CC: @njnes

Last updated: 2016-03-25 09:59:25 +0100

Comment 21676

Date: 2015-12-18 17:40:21 +0100
From: Kaijiang <>

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

create a table and insert some integers; execute sql with window function; then mserver5 process is gone.

Reproducible: Always

Steps to Reproduce:

  1. create table t3 (f1 int, f2 int);
  2. insert into t3 values (1,1), (2,2), (3,3), (4,4), (5,5);
  3. select f1,f2, avg(f1) over (order by f2 rows between 2 PRECEDING AND CURRENT ROW) from t3;

Actual Results:

mserver5 process gone

Expected Results:

gives sql result

Comment 21713

Date: 2016-01-06 08:05:09 +0100
From: Kaijiang <>

also crashes if I use RANGE clause:
select f1,f2, avg(f1) over (order by f2 range between 2 PRECEDING AND CURRENT ROW) from t3;

Comment 21898

Date: 2016-03-14 09:07:58 +0100
From: MonetDB Mercurial Repository <>

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

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

Changeset description:

remove bogus (debug) assert, fixes bug #3891 (well the crash only, as
window functions with aggregation (avg,sum etc) isn't supported).

Comment 21899

Date: 2016-03-14 09:08:28 +0100
From: @njnes

Crash is fixed (window functions with aggregation aren't supported at the moment)

Comment 21965

Date: 2016-03-25 09:59:25 +0100
From: @sjoerdmullender

Jul2015-SP3 has been released.

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

Successfully merging a pull request may close this issue.

None yet
1 participant