Does Ignite Txs Protect against Phantom Reads?

[John Wilson]

Hi,

Do Ignite transactions with serializable isolation level protect against phantom reads? For example, in the below example, does Ignite, in pessimistic mode, lock all entries in the range 10 to 30?

Thanks.

[Valentin Kulichenko]

Hi John,

Looks like pictures can't be attached directly. Try uploading it somewhere
and providing a link.

However, since you're talking about ranges, my guess would be that you're
using SQL which is currently NOT transactional. This support currently in
development though, probably other members of the community can provide
more details on the progress.

-Val

On Tue, Jul 24, 2018 at 4:52 PM John Wilson <[hidden email]> wrote:

> Hi,
>
> Do Ignite transactions with serializable isolation level protect against
> phantom reads? For example, in the below example, does Ignite, in
> pessimistic mode, lock all entries in the range 10 to 30?
>
> Thanks.
>
>
>
>

[John Wilson]

Hi Val,

Thanks, that answers my question.

John.

On Tue, Jul 24, 2018 at 5:13 PM, Valentin Kulichenko <
[hidden email]> wrote:

> Hi John,
>
> Looks like pictures can't be attached directly. Try uploading it somewhere
> and providing a link.
>
> However, since you're talking about ranges, my guess would be that you're
> using SQL which is currently NOT transactional. This support currently in
> development though, probably other members of the community can provide
> more details on the progress.
>
> -Val
>
> On Tue, Jul 24, 2018 at 4:52 PM John Wilson <[hidden email]>
> wrote:
>
> > Hi,
> >
> > Do Ignite transactions with serializable isolation level protect against
> > phantom reads? For example, in the below example, does Ignite, in
> > pessimistic mode, lock all entries in the range 10 to 30?
> >
> > Thanks.
> >
> >
> >
> >
>