[
https://issues.apache.org/jira/browse/PHOENIX-7651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hari Krishna Dara updated PHOENIX-7651:
---------------------------------------
Description:
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]
was:
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.
This is inspired by [https://www.postgresql.org/docs/17/dml-returning.html]
Summary: Support for RETURNING clause with UPSERT and DELETE (was:
Support for RETURNING clause with UPSERT ... ON DUPLICATE KEY)
> Support for RETURNING clause 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
>
> 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)
