order by - issue?

[Thorsten Hohage]

Hi,

why is

	select "order_id", "idserial"
	from CB_GROUP_X where ( C_SERIAL = 100056) order by "idserial" asc

working and especially SORTING like expected and

	select "order_id", "idserial"
	from CB_GROUP_X where ( C_SERIAL = 100056) order by "order_id" asc


not????


order_id and idserial are both UnsingendLongLong,  idserial is  
unique, order_id is indexed

Is this maybe related to the name "order_id"? But then it should work  
when using quotes. Any other idea?


regards

Thorsten Hohage
--
objectmanufactur.com - Hamburg,Germany