The following query works just fine

select T1.*,
(select IntegerField from T2
where T2.ID = T1.ID AND T2.ItemNo = T1.ItemNo
ORDER BY T2.ItemNo
RANGE 1 TO 1) as F
from T1
where T1.ID = 8

However, if I try getting a blob field in the select from T2, everythings
just stops responding.

select T1.*,
(select BlobField from T2
where T2.ID = T1.ID AND T2.ItemNo = T1.ItemNo
ORDER BY T2.ItemNo
 RANGE 1 TO 1) as F
from T1
where T1.ID = 8

It does work if I LEFT JOIN T2 but I need to use a RANGE as I want just one
of the records in T2.

--
Jan-Erik

Jan-Erik,

<< However, if I try getting a blob field in the select from T2, everythings
just stops responding. >>

Could you send me the source tables and the database catalog ?

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" > wrote
>
> Could you send me the source tables and the database catalog ?

I'll prepare something that you can download, the size makes it unsuitable
for e-mailing.

--
Jan-Erik

Jan-Erik,

<< I'll prepare something that you can download, the size makes it
unsuitable for e-mailing. >>

Thank you very much.  It would be nice if I can get a fix in 2.02 B8 if it
is indeed a bug.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

I've sent you the necessary download info in an e-mail.

--
Jan-Erik

Jan-Erik,

<< I've sent you the necessary download info in an e-mail. >>

Are you executing this in the EDB Manager or in .NET ?  I just tried it here
with the Unicode EDB Manager and it returns 538 rows in 0.516 secs.

Also, are you executing this locally or remotely ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> Are you executing this in the EDB Manager or in .NET ?  I just tried it
> here with the Unicode EDB Manager and it returns 538 rows in 0.516 secs.

I always profile the queries in the EDB Manager unless they are straight
forward, so Yes, it is running from EDB Manager.

> Also, are you executing this locally or remotely ?

Remotely.

It is running on Windows Server 2008, but that shouln't matter.

I'll send you another mail with more info later today.

--
Jan-Erik

Jan-Erik,

<< I always profile the queries in the EDB Manager unless they are straight
forward, so Yes, it is running from EDB Manager.

Remotely. >>

Hmm, works fine here with a remote session also.  Response time is still
good, 0.531 secs in the EDB Manager.

--
Tim Young
Elevate Software
www.elevatesoft.com