Bugs item #1691344, was opened at 2007-03-30 07:43
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=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: Open
Resolution: None
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
;
----------------------------------


----------------------------------------------------------------------

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

Reply via email to