Bugs item #1848553, was opened at 2007-12-11 12: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=1848553&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 2.20
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: select crashes in the optimization
Initial Comment:
The following queries crash the Mserver5-SQL:
create table s ( snr int, sname varchar(30) );
create table sp ( snr int, pnr varchar(30) );
select 24;
SELECT DISTINCT S.SNAME
FROM S, SP
GROUP BY S.SNR, S.SNAME, SP.SNR, SP.PNR
HAVING SP.SNR = S.SNR
AND SP.PNR = 'P2';
drop table s;
drop table sp;
Regards,
Romulo
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1848553&group_id=56967
-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
