[V4RB] Outer join strange result in sort order

[Ruslan Zasukhin]

On 7/9/05 10:49 PM, "Francois Van Lerberghe" <fvanlerberghe at freegates.be>
wrote:

Hi Francois, 

> I'm using V4RB 1.11 (last version) and Realbasic 3.5
> 
> I have a problem with an outer join that don't give me the expected result.
> Here is my SQL query :
> 
> SELECT table1.field1, table2.Field2
> FROM table1, table2
> WHERE table1.field1 =* table2. Field2
> ORDER BY 1
> 
> The results, in viSQL, are :
> 
> field1      field2
> --------------------
> string1     string1
> string1     string1
>             stringA
>             stringB
>             stringC
> string2     string2
> string2     string2
> string2     string2
> string3     string3
> ...         ...
> (next 14000 rows)
> 
> The results don't seem, to me, to be correctly sorted.
> Although I have asked "ORDER BY 1", the 3rd and the 3 following lignes (that
> have not related record in table 1) are *after* the 2 first ??
> 
> Is it a normal behavior with outer join ?
> Is it a problem of indexes ?

That NULL rows should be on top of result.
Please try rebuild indexes.

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