You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Viraj Jasani (Jira)" <ji...@apache.org> on 2025/08/19 19:27:00 UTC

[jira] [Resolved] (PHOENIX-7651) Support RETURNING * with UPSERT and DELETE

     [ https://issues.apache.org/jira/browse/PHOENIX-7651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Viraj Jasani resolved PHOENIX-7651.
-----------------------------------
    Resolution: Fixed

> Support RETURNING * with UPSERT and DELETE
> ------------------------------------------
>
>                 Key: PHOENIX-7651
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-7651
>             Project: Phoenix
>          Issue Type: New Feature
>            Reporter: Hari Krishna Dara
>            Assignee: Hari Krishna Dara
>            Priority: Major
>             Fix For: 5.3.0
>
>
> PHOENIX-7630 made it possible to use standard JDBC API to fetch the row with UPSERT ... ON DUPLICATE KEY statement, but it is unconditional and not efficient for use cases that do not need the row, especially if the row is large. This feature should support a {{RETURNING *}}  clause to make it possible for the user to conditionally fetch the row for any UPSERT and DELETE statement.
> This is inspired by [https://www.postgresql.org/docs/17/dml-returning.html]



--
This message was sent by Atlassian Jira
(v8.20.10#820010)