Bugs item #2604573, was opened at 2009-02-16 14:31
Message generated for change (Tracker Item Submitted) made by Item Submitter
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: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: z lh (zlh)
Assigned to: Nobody/Anonymous (nobody)
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
----------------------------------------------------------------------
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
