[Maria-developers] bb-10.2-compatibility : delete compatibility
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.
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!
participants (2)
-
Alexander Barkov
-
jerome brauge