Hi

We use Delphi using the sybase DLL's and upgraded from sybase 10 to 11.

create table table1 (a int);
create table table2 (a int, b int);

insert into table1 (a) values (1);

insert into table2 (a, b) values (1, 1);
insert into table2 (a, b) values (1, 2);

select table1.a, table2.b
from table1
left outer join table2
on table1.a = table2.a

If I run the select statement from I-SQL the results are

a | b
-----
1 | 1
1 | 2

If I run the same statement from our application (Delphi 2007 using NativeDb
components) using direct calls to the dll's on the same database the results
are

a | b
-----
1 | 1
1 | 2
1 | 1

This is on a ASA version 11.0.1.2341 database

Running the same scripts on a ASA version 10.0.1.3976 database I get the
same results from both I-SQL and our application!

Somebody any idea?

Eric