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.montee@gmail.com> wrote:
Hi Justin,
On Thu, Jun 11, 2015 at 12:28 PM, Justin Swanhart <greenlion@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