Bugs item #1691344, was opened at 2007-03-30 14:43 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1691344&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.16 >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Colin Foss (cgfoss) Assigned to: Niels Nes (nielsnes) Summary: SQL UNION with ORDER BY crash Initial Comment: If I run the following SQL, Mserver will die every time: ---------------------------------- create table tmp_one (data numeric(5)); create table tmp_two (data numeric(5)); /* this is ok */ select data from tmp_one union select data from tmp_two ; /* this will crash server */ select data from tmp_one union select data from tmp_two order by data ; ---------------------------------- Here is my work-around: ---------------------------------- /* work-around */ select * from ( select data from tmp_one union select data from tmp_two ) as foo order by data ; ---------------------------------- ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2007-03-31 08:03 Message: Logged In: YES user_id=43556 Originator: NO Fixed the handling of order by with in a union query . ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1691344&group_id=56967 ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
