30 Mar
2007
30 Mar
'07
7:28 a.m.
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 ?