#46 Postgres-XL bug in setting transaction isolation level

[Kaijiang]

Postgres-XL can't set isolation level as serializable.

REPRO:

start XL, enter the console, and type:

postgres=# set default_transaction_isolation=SERIALIZABLE;
SET
Time: 0.560 ms
postgres=# show default_transaction_isolation;
default_transaction_isolation

---

repeatable read
(1 row)

(Expected result is SERIALIZABLE)

[Saad Talaat]

postgres=# SHOW DEFAULT_TRANSACTION_ISOLATION;
default_transaction_isolation

---

repeatable read
(1 row)

postgres=# BEGIN;
BEGIN
postgres=# SHOW DEFAULT_TRANSACTION_ISOLATION;
default_transaction_isolation

---

repeatable read
(1 row)

postgres=# SET DEFAULT_TRANSACTION_ISOLATION='SERIALIZABLE';
SET
postgres=# SHOW DEFAULT_TRANSACTION_ISOLATION;
default_transaction_isolation

---

serializable
(1 row)

postgres=# END;
COMMIT

It does work on a local transaction. However not for a session transaction it doesn't, It default to repeatable read as you stated. The problem stands out however once you commit. that's why you get that in both a session SET statement and once you commit on a local transaction.