You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Ignite TC Bot (Jira)" <ji...@apache.org> on 2026/08/13 06:12:00 UTC

[jira] [Commented] (IGNITE-28981) [doc] Document Calcite SELECT FOR UPDATE support

    [ https://issues.apache.org/jira/browse/IGNITE-28981?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18104291#comment-18104291 ] 

Ignite TC Bot commented on IGNITE-28981:
----------------------------------------

A documentation branch is available for this issue:

* Branch: https://github.com/ignitetcbot/ignite/tree/IGNITE-28981-docs
* Commit: https://github.com/ignitetcbot/ignite/commit/21a34128be
* Manual PR URL: https://github.com/apache/ignite/compare/master...ignitetcbot:IGNITE-28981-docs?quick_pull=1

Automatic PR creation from this environment failed because the current GitHub token cannot call createPullRequest. A maintainer can use the compare URL above to open the PR manually.

> [doc] Document Calcite SELECT FOR UPDATE support
> ------------------------------------------------
>
>                 Key: IGNITE-28981
>                 URL: https://issues.apache.org/jira/browse/IGNITE-28981
>             Project: Ignite
>          Issue Type: Task
>          Components: documentation
>            Reporter: Ignite TC Bot
>            Priority: Major
>              Labels: ignite-2, sql
>
> IGNITE-28724 added support for SELECT ... FOR UPDATE in the Calcite-based SQL engine.
> The documentation should update docs/_docs/SQL/sql-calcite.adoc under Transaction-aware Queries / SELECT ... FOR UPDATE. The current page still says the statement is not supported.
> Minimal scope:
> * Document that SELECT ... FOR UPDATE is supported inside a PESSIMISTIC transaction.
> * Document the basic syntax, FOR UPDATE OF, NOWAIT, and WAIT n.
> * Mention that without OF all participating cache-based tables are locked; with OF only the tables owning listed columns are locked.
> * Mention the narrow limitations verified by implementation/tests: plain SELECT over cache-based tables and joins; not DISTINCT, GROUP BY, HAVING, aggregate-only result sets, system views, or table functions.
> Source issue: IGNITE-28724
> Implementation PR: https://github.com/apache/ignite/pull/13366
> Merged commit: 009946c769d4b4b7d9a792a85d66b54f4e7afe3d



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