order by - issue?

[Ruslan Zasukhin]

On 31/3/07 7:04 PM, "Thorsten Hohage" <thohage at objectmanufactur.com> wrote:

> 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

A guess:

    do you mean that idserial  do not have flag INDEXED?

It must be. 
Flag UNIQUE is informative also. It not force creation of index yet.
 
> Is this maybe related to the name "order_id"? But then it should work
> when using quotes. Any other idea?
   
Name should not play here.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]