I am having an issue with transactions and isolation level.
I am using orient as a document .db (no graph in the project)
I expect that if I create a record in a transaction, the same transaction is able to query for that record before commit (I expect isolation level to involve other transactions, not the current one).
If I use an in memory orient db (for tests) everything works as I expected, but when I switch to the remote db the query is not returning anything.
I am using orient db version 2.2.37.
Is that the supposed behaviour or should I set something to make it work?