connector-x icon indicating copy to clipboard operation
connector-x copied to clipboard

Set TRANSACTION ISOLATION LEVEL ?

Open kmatt opened this issue 1 year ago • 3 comments

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

kmatt avatar Jun 11 '24 20:06 kmatt