This is a nice feature that MariaDB has:
DELETE FROM table_sequence ORDER BY fid LIMIT 1 RETURNING fid
Would be nice to support also something like:
INSERT INTO ... ON DUPLICATE KEY UPDATE ... RETURNING xyz
Would this be something you would consider?
Thank you very much!
Thank you for your suggestion and I’m not the right person to speak about feature implementation for Percona Server but I can surely guide you to an appropriate place to raise this.
Consider using this for raising bugs or in your case, feature request:
PostgreSQL has this as well (most likely from where MariaDB grabbed it). I can’t find it as an SQL standard though.
Here it is: [CLOUD-798] Implement INSERT/UPDATE/DELETE … RETURNING - Percona JIRA
Apologies - I might have unintentionally put in the wrong area! (“Cloud Dev”)