The real nested transaction is disabled by default. Enable it using $dataSource->useNestedTransactions = true;.