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.
_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to     : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Reply via email to