Skip to content

Regression in master: SET transaction_isolation = 'repeatable_read'; #1262

Open
@morgo

Description

@morgo

This is the place to report a bug, ask a question, or suggest an enhancement.

In this PR da35142

GetDBUri() will execute a statement such as the following:

set transaction_isolation = 'repeatable-read';

This variable was only introduced in MySQL 5.7.20, so if you are using an earlier version such as what Aurora 5.7 is, it will result in an error:

mysql> set transaction_isolation = 'repeatable-read';
ERROR 1193 (HY000): Unknown system variable 'transaction_isolation'

Instead the statement needs to be set tx_isolation = 'repeatable-read', but this statement is not supported by MySQL 8.0. So some version-specific logic is probably required.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions