diff options
Diffstat (limited to 'mysql-test/suite/galera/r/galera_multi_database.result')
-rw-r--r-- | mysql-test/suite/galera/r/galera_multi_database.result | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_multi_database.result b/mysql-test/suite/galera/r/galera_multi_database.result new file mode 100644 index 00000000000..a04eb484caf --- /dev/null +++ b/mysql-test/suite/galera/r/galera_multi_database.result @@ -0,0 +1,28 @@ +CREATE DATABASE d1; +CREATE TABLE d1.t1(f1 INTEGER) ENGINE=InnoDB; +CREATE DATABASE d2; +CREATE TABLE d2.t1(f1 INTEGER PRIMARY KEY) ENGINE=InnoDB; +SET AUTOCOMMIT=OFF; +START TRANSACTION; +INSERT INTO d1.t1 VALUES (1); +SET AUTOCOMMIT=OFF; +START TRANSACTION; +INSERT INTO d2.t1 VALUES (1); +COMMIT; +COMMIT; +SELECT COUNT(*) = 1 FROM d1.t1; +COUNT(*) = 1 +1 +SELECT COUNT(*) = 1 FROM d2.t1; +COUNT(*) = 1 +1 +SELECT COUNT(*) = 1 FROM d1.t1; +COUNT(*) = 1 +1 +SELECT COUNT(*) = 1 FROM d2.t1; +COUNT(*) = 1 +1 +DROP TABLE d1.t1; +DROP TABLE d2.t1; +DROP DATABASE d1; +DROP DATABASE d2; |