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

Ivan Pavlukhin updated IGNITE-11357:
------------------------------------
    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:
{code}
try (Transaction tx = node.transactions().txStart(PESSIMISTIC, SERIALIZABLE)) {
    cache.put(1, 1);
    cache.query(new SqlFieldsQuery("commit"));
    cache.put(2, 2);

    tx.commit();
}
{code}

  was:
DLL and special tx (BEGIN, COMMIT) and DDL 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:
{code}
try (Transaction tx = node.transactions().txStart(PESSIMISTIC, SERIALIZABLE)) {
    cache.put(1, 1);
    cache.query(new SqlFieldsQuery("commit"));
    cache.put(2, 2);

    tx.commit();
}
{code}


> MVCC: SQL tx operations and DDL inside tx block
> -----------------------------------------------
>
>                 Key: IGNITE-11357
>                 URL: https://issues.apache.org/jira/browse/IGNITE-11357
>             Project: Ignite
>          Issue Type: Bug
>          Components: mvcc
>    Affects Versions: 2.7
>            Reporter: Ivan Pavlukhin
>            Priority: Major
>
> 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:
> {code}
> try (Transaction tx = node.transactions().txStart(PESSIMISTIC, SERIALIZABLE)) 
> {
>     cache.put(1, 1);
>     cache.query(new SqlFieldsQuery("commit"));
>     cache.put(2, 2);
>     tx.commit();
> }
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to