Milen Manev wrote:
>
> create table t1 (ch1 char(10))
> create table t2 (ch2 char(10), i2 integer)
> create table t3 (ch3 char(10), i3 integer)
> create table t4 (ch4 char(10))
> insert into t1 values ('error')
> insert into t2 values ('error', 2)
> insert into t3 values ('error3', 2)
>
> select ch1
> from t1
>
> result is string:
> error
> This result is correct.
>
> select ch2
> from t2, t3
> where i2 = i3 and ch3 = 'error3' and ch2 not in (select ch4 from t4)
>
> result is string:
> error
> This result is correct.
>
>
> Now execute
> select *
> from t1
> where ch1 not in (select ch2
> from t2, t3
> where i2 = i3 and ch3 = 'error3' and
> ch2 not in
> (select ch4 from t4))
>
> For my surprise result is again string:
> error
>
> And is is realy an error :(
>
Indeed it is! It's a problem with subqueries in subqueries.
We will fix it in the next release. Thanks for reporting it.
Kind regards,
Holger
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
