Bugs item #2420768, was opened at 2008-12-12 13:57
Message generated for change (Comment added) made by romulog
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2420768&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: col from another schema inside function body
Initial Comment:
I used the current branch of SQL this means I am using the algebra version of
it (it is the default one)...
It seems a column from another system is not detected inside a function body...
This example covers the problem:
CREATE FUNCTION fDocColumns(tabname varchar(400))
RETURNS TABLE (enum varchar(64))
BEGIN
RETURN TABLE( select t.name from sys.tables t where name='romulo');
END;
drop function fDocColumns;
MAPI = skyser...@localhost:50000
>> QUERY = CREATE FUNCTION fDocColumns(tabname varchar(400))
>> ERROR = !SELECT: no such column 't.name'
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2008-12-15 10:58
Message:
The bug can be closed... It was fixed with following check in and the test
is green in all platforms:
[Monetdb-sql-checkins] sql/src/server rel_select.mx,,1.101,1.102
Modified Files:
rel_select.mx
Log Message:
fixed bug in table alias handling (for view used in create function).
----------------------------------------------------------------------
Comment By: Romulo Goncalves (romulog)
Date: 2008-12-12 14:01
Message:
Test added at:
sql/src/test/BugTracker-2008/Tests/col_from_another_inside_function_body.SF-2420768.sql
Note:
This bug only occurs in the current and not stable branch ;)
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2420768&group_id=56967
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
