sink to mariadb 10.6.5 fails with unknown system variable transaction_isolation

[hicqu]

What did you do?

Create a sink to downstream mariadb 10.6.5.

What did you expect to see?

The downstream can be created without any errors.

What did you see instead?

$ ./cdc cli changefeed list
[
  {
    "id": "test",
    "summary": {
      "state": "error",
      "tso": 431019101257728000,
      "checkpoint": "2022-02-07 12:16:27.000",
      "error": {
        "addr": "192.168.101.2:8300",
        "code": "CDC:ErrOwnerUnknown",
        "message": "[CDC:ErrMySQLConnectionError]fail to open MySQL connection: Error 1193: Unknown system variable 'transaction_isolation'"
      }
    }
  }
]

$ mysql -h 127.0.0.1 -P 3306 -u root -p -e "show variables like '%isolation%'";
Enter password:
+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| tx_isolation  | REPEATABLE-READ |
+---------------+-----------------+

Seems in mariadb 10.6.5 the variable name has been changed from "transaction_isolation" to "tx_isolation", and it causes the failure.

Versions of the cluster

Upstream TiDB cluster version (execute SELECT tidb_version(); in a MySQL client):

(paste TiDB cluster version here)

TiCDC version (execute cdc version):

(paste TiCDC version here)

[amyangfei]

PTAL @maxshuang