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 ?


-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-users

Reply via email to