Hello Alexander,

Can you add a task for delete statement with same table as source and target in sql_mode=oracle

Example :

create or replace table t1 (c1 int, c2 int);

delete from t1 where c1 in (select b.c1 from t1 b where b.c2=0);

Failed with :

Error: Table 't1' is specified twice, both as a target for 'DELETE' and as a separate source for data

SQLState:  HY000

ErrorCode: 1093

Regards,

Jérôme.