maria-discuss team mailing list archive

[Justin Swanhart <greenlion@xxxxxxxxx>]

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