Hello Jerome, Sorry, I noticed I've never replied this:
On 02/14/2017 08:24 PM, jerome brauge wrote: > 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 > Done, here it is: MDEV-12137 sql_mode=ORACLE: DELETE statement with the same source and target Thanks! _______________________________________________ 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
