Set TRANSACTION ISOLATION LEVEL ?

[kmatt]

Queries appear to default to isolation level READ COMMITTED.

If a different level was desired, such as SET TRANSACTION LEVEL READ UNCOMMITTED was desired, can this be set in Connector-X?

Adding them as an initial separate statement to the SQL query results in an error:

RuntimeError: MsSQL failed to get the columns of query: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

[melissa-ellevation]

hi there - I am experiencing the same issue. I imagine if there were any updates someone would have posted them by now...

[jsjasonseba]

Hi @kmatt @melissa-ellevation , you can now submit SET statements on pre_execution_query parameter on connectorx v0.4.2 for mysql and postgres source. (https://sfu-db.github.io/connector-x/api.html)

[kmatt]

Is this feature only supported on Postgres and MySQL?