From 3cb34ba5ef410ed868b46b2cc68cddffaf56776f Mon Sep 17 00:00:00 2001
From: Chris Hofstaedtler <chris.hofstaedtler@deduktiva.com>
Date: Tue, 22 May 2018 14:12:41 +0200
Subject: [PATCH] gmysql: Use future-proof statement for transaction isolation

(cherry picked from commit c11d8368ddc369ff8473dbcb619b17b6a1cf7e38)
---
 modules/gmysqlbackend/smysql.cc | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/modules/gmysqlbackend/smysql.cc b/modules/gmysqlbackend/smysql.cc
index 8a2a5092a..eaccaeeae 100644
--- a/modules/gmysqlbackend/smysql.cc
+++ b/modules/gmysqlbackend/smysql.cc
@@ -427,7 +427,7 @@ void SMySQL::connect()
 #endif
 
     if (d_setIsolation && (retry == 1))
-      mysql_options(&d_db, MYSQL_INIT_COMMAND,"SET SESSION tx_isolation='READ-COMMITTED'");
+      mysql_options(&d_db, MYSQL_INIT_COMMAND,"SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED");
 
     mysql_options(&d_db, MYSQL_READ_DEFAULT_GROUP, d_group.c_str());
 
-- 
2.40.0