No errors on UDF returning table with too many columns

[monetdb-team]

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