Bugs item #1913572, was opened at 2008-03-13 15:51
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=1913572&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: None
Priority: 5
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: column from a table function
Initial Comment:
The follwing code crash mserver5:
CREATE FUNCTION fGetNearbyObjEq (ra float, decim float, r float)
RETURNS TABLE (
objID bigint,
run int ,
camcol int ,
field int ,
rerun int ,
type int ,
cx float ,
cy float ,
cz float ,
htmID bigint,
distance float -- distance in arc minutes
)
BEGIN
DECLARE TABLE proxtab (
objID bigint,
run int ,
camcol int ,
field int ,
rerun int ,
type int ,
cx float ,
cy float ,
cz float ,
htmID bigint,
distance float -- distance in arc minutes
);
RETURN proxtab;
END;
create table t2 (objID bigint NULL);
SELECT * FROM t2 s, fGetNearbyObjEq(20.925,1.67,29.4) WHERE s.objID=n.objID;
drop function fGetNearbyObjEq;
drop table t2;
This debug information shows where and what is the problem...
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 1107310928 (LWP 18423)]
0x0000003c4bc79010 in strcmp () from /lib64/libc.so.6
(gdb) up
#1 0x00002aaabe721157 in find_table_column (columns=0x424a518,
tname=0x41ff238 "n", cname=0x41ff248 "objid")
at /ufs/goncalve/MonetDB/sql/src/server/sql_scope.mx:371
371 if (strcmp(c->tname, tname) == 0 && strcmp(c->cname,
cname) == 0) {
(gdb) p tname
$1 = 0x41ff238 "n"
(gdb) p c->tname
$2 = 0x0
(gdb)
Romulo
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1913572&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
