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 ?