[MonetDB-users] UNION with ORDER BY crash
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 ?
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
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 ?
Colin Foss wrote:
I am running latest 4.x line on Windows 64bit. If I run the following SQL Mserver will die every time.
A crash of the program is always a bug, so can you please submit this as a bug report in SourceForge?
---------------------------------- 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 ?
------------------------------------------------------------------------- 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-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Sjoerd Mullender
participants (2)
-
Colin Foss -
Sjoerd Mullender