Bugs item #1841734, was opened at 2007-11-30 15:23
Message generated for change (Comment added) made by romulog
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: Closed
Resolution: Fixed
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
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2007-11-30 16:51
Message:
Logged In: YES
user_id=1498628
Originator: YES
Yes you are right, I forgot the stable...
I will also change there.
Sorry...
Regards,
Romulo
----------------------------------------------------------------------
Comment By: Sjoerd Mullender (sjoerd)
Date: 2007-11-30 16:48
Message:
Logged In: YES
user_id=43607
Originator: NO
This also affects the stable branch. Why didn't you fix it there?
----------------------------------------------------------------------
Comment By: Romulo Goncalves (romulog)
Date: 2007-11-30 16:32
Message:
Logged In: YES
user_id=1498628
Originator: YES
The bug is ifxed in the checkin:
[Monetdb-sql-checkins] sql/src/server sql_select.mx,,1.208,1.209
at 4:30
The test to cover it was added it in:
sql/src/test/BugTracker/Tests/select_with_coalesce.SF-1841734
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
