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

Failed to find a table producing function #2817

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

Failed to find a table producing function #2817

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


Copy link

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

Date: 2011-06-04 23:03:01 +0200
From: @mlkersten
To: SQL devs <>
Version: 11.3.7 (Apr2011-SP2) [obsolete]
CC: @njnes, @drstmane

Last updated: 2011-09-16 15:04:40 +0200

Comment 15832

Date: 2011-06-04 23:03:01 +0200
From: @mlkersten

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

Operator resolution issue. User defined function in specific schema not found.

Reproducible: Always

Steps to Reproduce:

create schema datacell;
create table datacell.basket_X(
id integer auto_increment,
tag timestamp default now(),
payload integer

create function datacell.basket_X()
returns table (id integer, tag timestamp, payload integer)
return select * from datacell.basket_X;

select * from datacell.basket_X();

Actual Results:

!SELECT: no such operator 'basket_x'

Comment 15846

Date: 2011-06-13 22:33:46 +0200
From: @mlkersten

Problem is fixed in the default.

Comment 15958

Date: 2011-07-17 15:44:27 +0200
From: @drstmane

Changeset bed1350dc1be made by Stefan Manegold in the MonetDB repo, refers to this bug.

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

Changeset description:

added test for bug #2817

Comment 15959

Date: 2011-07-17 16:06:06 +0200
From: @drstmane

Re-opened as

it still fails as originally reported in Apr2011 branch
(admittedly, it has never been fixed there)

it causes a server crash (segfault) in Aug2011 branch

Comment 15960

Date: 2011-07-17 16:14:39 +0200
From: @drstmane

crash also occurs in default branch

Comment 15987

Date: 2011-07-27 17:29:54 +0200
From: @njnes

Changeset bec5a1fb7ba9 made by Niels Nes in the MonetDB repo, refers to this bug.

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

Changeset description:

fixes for bug #2817, keep 'generated types' in schema sys.
Put function in passed schema (not in the current schema).

Comment 15989

Date: 2011-07-27 20:02:13 +0200
From: @njnes

test is now running also on the april branch

Comment 16049

Date: 2011-07-29 11:03:54 +0200
From: @sjoerdmullender

Apr2011-SP2 has been released.

Comment 16253

Date: 2011-09-16 15:04:40 +0200
From: @sjoerdmullender

The Aug2011 version has been released.

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