Does Trafodion support to use 'order by' in a subquery

[Liu, Ming (Ming)]

Hi, all,

I don't know if this is same in other database, but in Trafodion, if I want to 
have a subquery which have a 'order by', it seems not allowed. Is this normal 
or a limitation in Trafodion?
For example:

create table t1 ( c1 int, c2 int);

select * from (
   Select * from t1 order by c1);
*** ERROR[15001] A syntax error occurred at or before:
select * from (select * from t1 order by c1);
                                           ^ (44 characters from start of SQL 
statement)

Thanks in advance,
Ming