order by - issue?

[Thorsten Hohage]

Hi Ruslan,

On 2007-03-31, at 20:23, Ruslan Zasukhin wrote:

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

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?


regards

Thorsten Hohage
--
objectmanufactur.com - Hamburg,Germany