Bugs item #1841734, was opened at 2007-11-30 15:23
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=1841734&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: select with coalesce
Initial Comment:
The following sq1 code crashes the Mserver5-SQL:
CREATE TABLE CASE_TBL (
i integer,
f double precision
);
CREATE TABLE CASE2_TBL (
i integer,
j integer
);
SELECT *
FROM CASE_TBL a, CASE2_TBL b
WHERE COALESCE(a.f, b.i, b.j) = 2;
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 46912517404944 (LWP 11063)]
0x00002aaabc3d199d in sql_case (sql=0x13b6c68, scp=0xaf22d8, token=48,
opt_cond=0x0, when_search_list=0x14f4a68, opt_else=0x14f4a48, grp=0x0,
subset=0x0, f=1)
at /ufs/goncalve/MonetDB/sql/src/server/sql_select.mx:630
630 if (cond && subset->nrcols && cond->nrcols == 0)
Regards,
Romulo
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1841734&group_id=56967
-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
