[V4RB] Outer join strange result in sort order

[Ruslan Zasukhin]

On 7/11/05 12:17 PM, "Francois Van Lerberghe" <fvanlerberghe at freegates.be>
wrote:

> le 11/07/05 8:06, Ruslan Zasukhin <sunshine at public.kherson.ua> a écrit :
> 
>> That NULL rows should be on top of result.
>> Please try rebuild indexes.
> 
> That's what I think too.
> I have tried :
> - rebuild of indexes.
> - export the whole table and import again
> - defragment and compact
> But I get the same result.
> 
> Thus I think it's a bug.
> May I sent to you the database ?

> In this case I'm going to narrow the database in order to send you a file as
> small as possible, reproducing the problem.

But this is 1.x engine ?

Try also next: 
    change order of tables and conditions to
    switch to LEFT OUTER instead of RIGHT OUTER


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