[IGNITE-11357] MVCC: SQL tx operations and DDL inside tx block

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 2.7
• Component/s: mvcc
• Ignite Flags: Docs Required
• Assignee: Unassigned
• Reporter: Ivan Pavlukhin
• Created: 19/Feb/19 09:35
• Updated: 25/Aug/23 08:37
• Resolved: 25/Aug/23 08:37

Description

DDL and special tx (BEGIN, COMMIT) operations does not behave well inside explicit tx started using Java API. We should define how such operations behave inside tx or forbid them inside tx. See test SqlTransactionsCommandsWithMvccEnabledSelfTest#testSqlOperationsWithinNonSqlTransaction.
Here is an example of problematic construction:

try (Transaction tx = node.transactions().txStart(PESSIMISTIC, SERIALIZABLE)) {
    cache.put(1, 1);
    cache.query(new SqlFieldsQuery("commit"));
    cache.put(2, 2);

    tx.commit();
}