maria-developers team mailing list archive

[Alexander Barkov <bar@xxxxxxxxxxx>]

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!