You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
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:
Comment 17206
Date: 2012-05-02 11:01:27 +0200
From: @njnes
Added proper error
The text was updated successfully, but these errors were encountered: