order by - issue?

[Ruslan Zasukhin]

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

>>> 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.
> 
> NO this was just additional information for the issue and of course
> (sorry missed above) idserial is also indexed.
> 
>>> 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.
> 
> ok, that was the first positive step - but why is the second query
> not sorting?

I think we need your db for test then.

You can yet self try set WarningMode ON, and check warning.log file to see
how each query is executed

-- 
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]