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

No errors on UDF returning table with too many columns #3077

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

No errors on UDF returning table with too many columns #3077

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

Comments

@monetdb-team
Copy link

Date: 2012-05-01 10:33:03 +0200
From: @yzchang
To: SQL devs <>
Version: 11.9.1 (Apr2012) [obsolete]
CC: @njnes

Last updated: 2012-05-25 12:58:44 +0200

Comment 17200

Date: 2012-05-01 10:33:03 +0200
From: @yzchang

The following query should trigger an error, as the table actually returned has more columns than the table specified in de RETURNS statement:

sql>create function t3 () returns table (x int) begin declare table t (x int, y int); return t; end;
operation successful (19.386ms)
sql>select * from t3();
+---+
| x |
+===+
+---+

PS> Returning a table with too few columns does correctly trigger an error.

Comment 17201

Date: 2012-05-01 10:50:26 +0200
From: @yzchang

Changeset d5e2534ed65f made by Jennie Zhang y.zhang@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

Added test for Bug #3077

Comment 17206

Date: 2012-05-02 11:01:27 +0200
From: @njnes

Added proper error

@monetdb-team monetdb-team added bug Something isn't working normal SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Nov 9, 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 normal SQL
Projects
None yet
Development

No branches or pull requests

2 participants