[ 
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)

Reply via email to