Bugs item #1907858, was opened at 2008-03-05 11:41
Message generated for change (Comment added) made by romulog
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1907858&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL CVS Head
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: declaration of the second table in the function body
Initial Comment:
The following sql function crashes mserver 5
CREATE FUNCTION fR(x float, types float)
RETURNS float
BEGIN
DECLARE TABLE typesTable(
type varchar(16)
);
INSERT into typesTable (type) values ('asdasd');
DECLARE TABLE region(
regionid bigint,
type varchar(16)
);
Return x;
END;
Romulo
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2008-03-07 17:10
Message:
Logged In: YES
user_id=1498628
Originator: YES
Bug fixed with check in:
[Monetdb-sql-checkins] sql/src/server sql_mvc.mx, SQL_2-22, 1.195.2.1,
1.195.2.2
Modified Files:
Tag: SQL_2-22
sql_mvc.mx
Log Message:
fixed bug [ 1907858 ] declaration of the second table in the function
body
cased columns sometimes have no schema defined (declared tables). So we
cannot reuse the schema from it.
and test added in:
sql/src/test/BugTracker/Tests/decl_sec_tab_in_func_body.SF-1907858
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1907858&group_id=56967
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
