It would be very nice if I could exec SQL in the server without hacking that using a subclass which would be a big patch. Any updates on when that MDEV (don't know #) will be implemented? For many things the event system can be hijacked to run an event that runs a sp that executes arbitrary SQL and puts results in a table, but that is /really/hacky. It could work though, there is a stored proc from oracle CTE for recursive CTE :)
Sent from my iPhone > On Jun 11, 2015, at 5:20 PM, Geoff Montee <geoff.mon...@gmail.com> wrote: > > Hi Justin, > >> On Thu, Jun 11, 2015 at 12:28 PM, Justin Swanhart <greenl...@gmail.com> >> wrote: >> Hi, >> >> Really, the SQL-2003 standard syntax would be nice (implementing >> non-recursive CTE is mostly trivial, btw): >> >> WITH moved_rows AS ( >> DELETE FROM products >> WHERE >> "date" >= '2010-10-01' AND >> "date" < '2010-11-01' >> RETURNING * >> ) >> INSERT INTO products_log >> SELECT * FROM moved_rows; > > I agree. It would be great if MariaDB supported CTEs. I've submitted a > feature request for that as well: > > https://mariadb.atlassian.net/browse/MDEV-8308 > > If you have a patch, feel free to contribute it. > > Thanks, > > Geoff _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
