• mhansson/martin@linux-st28.site's avatar
    Bug #30234: Unexpected behavior using DELETE with AS and USING · df5c9e69
    mhansson/martin@linux-st28.site authored
      
    DELETE FROM ... USING ... statements with the following type of 
    ambiguous aliasing gave unexpected results:
    DELETE FROM t1 AS alias USING t1, t2 AS alias WHERE t1.a = alias.a;
    This query would leave table t1 intact but delete rows from t2.
    Fixed by changing DELETE FROM ... USING syntax so that only alias 
    references (as opposed to alias declarations) may be used in FROM.
    df5c9e69
delete.result 7.45 KB