Bugs item #2604573, was opened at 2009-02-16 07:31
Message generated for change (Comment added) made by stmane
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2604573&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: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: z lh (zlh)
>Assigned to: Niels Nes (nielsnes)
Summary: error while drop the function which returns table_type
Initial Comment:
--error while drop the function which returns table_type ,
--test case: create a new database , then run the SQLs
create function test_002() returns table(i int)
begin
create table tbl(i int);
insert into tbl values(110);
insert into tbl values(210);
return tbl;
end;
select * from test_002();
drop function test_002;
create function test_002() returns table( j char(20) )
begin
create table tbl( j char(20) );
insert into tbl values( 'aaa' );
insert into tbl values( 'bbb' );
return tbl;
end;
select * from test_002();
-------------------------------------
the result : after drop the function test_002, can't create/use the funtion
test_002
sql>--create a new database
0 tuples
sql>create function test_002() returns table(i int)
more>begin
more>create table tbl(i int);
more>insert into tbl values(110);
more>insert into tbl values(210);
more>return tbl;
more>end;
0 tuples
sql>select * from test_002();
Rows affected 1
Rows affected 1
+-----+
| i |
+=====+
| 110 |
| 210 |
+-----+
2 tuples
sql>
0 tuples
sql>drop function test_002;
0 tuples
sql>create function test_002() returns table( j char(20) )
more>begin
more>create table tbl( j char(20) );
more>insert into tbl values( 'aaa' );
more>insert into tbl values( 'bbb' );
more>return tbl;
more>end;
0 tuples
sql>select * from test_002();
Rows affected 1
Rows affected 1
!SQLException:int:conversion of string 'aaa' failed
0 tuples
----------------------------------------------------------------------
>Comment By: Stefan Manegold (stmane)
Date: 2009-02-16 08:09
Message:
zlh,
could you please indicate, which version of MonetDB you are using,
e.g., by selecting either 'SQL CVS Head' or 'SQL "stable"' as 'Group" for
this bug report,
and providing the output of `mserver5 --version`.
Thanks!
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2604573&group_id=56967
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
