diff options
Diffstat (limited to 'mysql-test/suite/galera/r/galera_nopk_unicode.result')
-rw-r--r-- | mysql-test/suite/galera/r/galera_nopk_unicode.result | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_nopk_unicode.result b/mysql-test/suite/galera/r/galera_nopk_unicode.result new file mode 100644 index 00000000..587ba928 --- /dev/null +++ b/mysql-test/suite/galera/r/galera_nopk_unicode.result @@ -0,0 +1,31 @@ +connection node_2; +connection node_1; +CREATE TABLE t1 ( +f1 VARCHAR(255), +KEY (f1) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +INSERT INTO t1 VALUES ('текст'); +connection node_2; +SELECT f1 = 'текст' FROM t1; +f1 = 'текст' +1 +connection node_1; +SET AUTOCOMMIT=OFF; +START TRANSACTION; +UPDATE t1 SET f1 = 'текст2'; +connection node_2; +SET AUTOCOMMIT=OFF; +START TRANSACTION; +UPDATE t1 SET f1 = 'текст3'; +connection node_1; +COMMIT; +connection node_2; +COMMIT; +ERROR 40001: Deadlock found when trying to get lock; try restarting transaction +SELECT f1 = 'текст2' FROM t1; +f1 = 'текст2' +1 +SELECT f1 = 'текст2' FROM t1 WHERE f1 = 'текст2'; +f1 = 'текст2' +1 +DROP TABLE t1; |