[V4RB2] ORDER BY ?

[Ruslan Zasukhin]

On 4/11/05 8:14 PM, "Eric Ferrer" <wonderfef at noos.fr> wrote:

>> v2 do not allow to have ORDER BY on field which is not in SELECT
>> Actually this is SQL92 standard.
> 
>>> Actually, you should have done the same in v4rb1
>>> as well. In my experience with V1, some querries
>>> work fine without order by items in select, but
>>> others do not. It's hit and miss scenerio, so is
>>> safer to include them.
> 
> Safer or standard, maybe...
> But the returned cursor will be bigger, generating more network trafic,
> since you'll get fields that you won't use.
> For some queries, this will not be an issue, for others, that may slow down
> performances, don't you think?

If think about network then agree

NOTE, we plan relax this requirement to allow for simple cases
    do sorting of not-SELECTed fields.
    I think we can do this for single table query...



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