I asked this question four monthes ago and didn't get any answers. In
latest MaxDB 7.6.00.16 I get the same problem. Can somebody explain this?
create table t1
(
c integer
)
//
create table t2
(
c integer
)
//
insert into t1 values(1)
//
delete from t1 where c in (select t1.c from t1,t2 where t1.c=t2.c(+) and
t2.c is null)
//
select * from t1
retuns one row
The following workaround
create table temp.t as select t1.c from t1,t2 where t1.c=t2.c(+) and
t2.c is
null
//
delete from t1 where c in (select c from temp.t)
//
select * from t1
returns zero rows
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
