Implement INSERT/UPDATE/DELETE ... RETURNING

MySQL & MariaDB Percona Server for MySQL 8.0
1

Hey!

This is a nice feature that MariaDB has:

Example usage:

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? :slight_smile:

Thank you very much!

2

Hello @nunop,

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:
https://jira.percona.com

Thanks,
K

1 Like
3

PostgreSQL has this as well (most likely from where MariaDB grabbed it). I can’t find it as an SQL standard though.

4

Thanks @kedarpercona

Here it is: [CLOUD-798] Implement INSERT/UPDATE/DELETE … RETURNING - Percona JIRA

Apologies - I might have unintentionally put in the wrong area! (“Cloud Dev”)

5

Feature Request was moved to the right place.

New link: [PS-8850] Implement INSERT/UPDATE/DELETE … RETURNING - Percona JIRA