[IGNITE-9547] Document DML operations prohibited inside transaction

• Type: Task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 2.17
• Component/s: documentation, sql
• Assignee: Artem Budnikov
• Reporter: Iurii Gerzhedovich
• Created: 11/Sep/18 14:55
• Updated: 25/Dec/23 13:00

Description

Docs says:

""Presently, DML supports the atomic mode only meaning that if there is a DML query that is executed as a part of an Ignite transaction then it will not be enlisted in the transaction's writing queue and will be executed right away""

However it's wrong.

We need to document that now any DML operations is prohibited and throw Exception in case it will be executed inside a transaction.

 

Also appeared new boolean property IGNITE_ALLOW_DML_INSIDE_TRANSACTION. it is necessary to emulate the old behavior. In case value is true then DML operation is allowed, but it be applied only after transaction will be commited.

By default value is false.

Issue Links

• relates to: IGNITE-6044 SQL insert waits for transaction commit, but it must be executed right away