You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Andrew Kyle Purtell (Jira)" <ji...@apache.org> on 2026/06/12 19:42:00 UTC

[jira] [Updated] (PHOENIX-7916) Disclose atomic upsert flavors and RETURNING in EXPLAIN

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

Andrew Kyle Purtell updated PHOENIX-7916:
-----------------------------------------
    Description: 
Replace the single opaque {{PUT SINGLE ROW}} operator line with a switch on {{UpsertStatement.OnDuplicateKeyType}}, surface the server-side update assignments under {{ON DUPLICATE KEY UPDATE}}, and disclose {{RETURNING *}} on every mutation plan whose parsed statement has {{isReturningRow() == true}} — that is, every concrete {{UpsertCompiler}} plan ({{UpsertValuesMutationPlan}}, {{ServerUpsertSelectMutationPlan}}, {{ClientUpsertSelectMutationPlan}}) and every {{DeleteCompiler}} plan ({{SingleRowDeleteMutationPlan}}, {{ServerSelectDeleteMutationPlan}}, {{ClientSelectDeleteMutationPlan}}).

Add three new structured fields to {{ExplainPlanAttributes}} and matching fluent assertions on {{ExplainPlanTestUtil}}.

> Disclose atomic upsert flavors and RETURNING in EXPLAIN
> -------------------------------------------------------
>
>                 Key: PHOENIX-7916
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-7916
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: Andrew Kyle Purtell
>            Assignee: Andrew Kyle Purtell
>            Priority: Major
>             Fix For: PHOENIX-7876-feature
>
>
> Replace the single opaque {{PUT SINGLE ROW}} operator line with a switch on {{UpsertStatement.OnDuplicateKeyType}}, surface the server-side update assignments under {{ON DUPLICATE KEY UPDATE}}, and disclose {{RETURNING *}} on every mutation plan whose parsed statement has {{isReturningRow() == true}} — that is, every concrete {{UpsertCompiler}} plan ({{UpsertValuesMutationPlan}}, {{ServerUpsertSelectMutationPlan}}, {{ClientUpsertSelectMutationPlan}}) and every {{DeleteCompiler}} plan ({{SingleRowDeleteMutationPlan}}, {{ServerSelectDeleteMutationPlan}}, {{ClientSelectDeleteMutationPlan}}).
> Add three new structured fields to {{ExplainPlanAttributes}} and matching fluent assertions on {{ExplainPlanTestUtil}}.



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