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 w
a testcase
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
workaround
create table temp.t
(
c integer
)
//
insert into temp.t se