delete statement doesn't delete rows

2005-12-12 Thread Alexey Gaidukov
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

delete statement doesn't delete rows

2005-08-28 Thread Alexey Gaidukov
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