Bugs item #1714814, was opened at 2007-05-08 11:29
Message generated for change (Comment added) made by mlkersten
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1714814&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: Open
Resolution: Fixed
Priority: 5
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
>Summary: SQL: View creation using a function....

Initial Comment:
create table t1(id int, name varchar(1024), age int);
create table t2(id int, age int);

create function f1()
returns int
BEGIN
        return 1;
END;

create view v1 as select * from t1 where id = f(1);

This example crash the mserver. I know that it should be f1(), however it 
should not crash the mserver it should give an error message.

Regards,
Romulo



----------------------------------------------------------------------

>Comment By: Martin Kersten (mlkersten)
Date: 2007-05-08 17:35

Message:
Logged In: YES 
user_id=490798
Originator: NO

Added test file to the repository

----------------------------------------------------------------------

Comment By: Niels Nes (nielsnes)
Date: 2007-05-08 14:22

Message:
Logged In: YES 
user_id=43556
Originator: NO

fixed, ie added check of result of subquery.


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1714814&group_id=56967

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs

Reply via email to