Delete syntax

[seesharper]

Need to add more delete syntax tests as we are moving towards support for Oracle.

It turns out that Oracle can not handle joins as part of the delete statement unless they are wrapped in a sub query.

This means that something like:

delete from orderdetails od inner join orders o on o.Order  = od.orderid and o.order  = -1;

would need to be (re)written to something like:

delete from (SELECT  od.* FROM orderdetails od inner join orders o on o.Orderid  = od.orderid and o.orderid  = -1)

The question is should we rewrite the expression tree or should we handle this in VisitDeleteExpression ?

http://www.dbforums.com/oracle/1006077-delete-join-query.html