Re: [MonetDB-users] UNION with ORDER BY crash

30 Mar 2007


      I forgot to add my work-around:

------------------
/* work-around */
select *
from (
  select data from tmp_one
  union
  select data from tmp_two
) as foo
order by data
;
------------------


--- Colin Foss <cgfoss@yahoo.com> wrote:
...
I am running latest 4.x line on Windows 64bit.  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
;
----------------------------------
Is "ORDER BY" supported with a UNION ?