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

Incorrect use of generate_series #3609

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

Incorrect use of generate_series #3609

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

Comments

@monetdb-team
Copy link

Date: 2014-10-24 22:37:05 +0200
From: @mlkersten
To: SQL devs <>
Version: 11.17.13 (Jan2014-SP1)

Last updated: 2015-03-06 12:38:47 +0100

Comment 20315

Date: 2014-10-24 22:37:05 +0200
From: @mlkersten

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:33.0) Gecko/20100101 Firefox/33.0
Build Identifier:

Generate_series is a table producing function, which causes problems in the query

SELECT generate_series(0,10,1)

where the optimizer would try to dump a scalar value.

Reproducible: Always

Steps to Reproduce:

SELECT generate_series(0,10,1);

Comment 20408

Date: 2014-10-31 15:52:25 +0100
From: @sjoerdmullender

Fixed with changeset 103d748e8ceb

Comment 20467

Date: 2014-11-28 10:03:16 +0100
From: @sjoerdmullender

Oct2014-SP1 has been released.

Comment 20694

Date: 2015-03-06 12:38:47 +0100
From: MonetDB Mercurial Repository <>

Changeset dbe2e264be1f 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=dbe2e264be1f

Changeset description:

Filter out comments about builtin and command line options.
This makes that test sq/backends/monet5/generator/crash.Bug-3609
doesn't fail if it is run without property checking.
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