diff options
| author | Nirbhay Choubey <nirbhay@mariadb.com> | 2015-04-21 13:17:17 -0400 |
|---|---|---|
| committer | Nirbhay Choubey <nirbhay@mariadb.com> | 2015-05-08 17:43:57 -0400 |
| commit | 3331d4e07efca993b3f34fa06b8a03b41b6b690d (patch) | |
| tree | 33ec8ad535c4003ce4e7bda050641cb748b35a04 /mysql-test/suite/galera/r/galera_many_tables_pk.result | |
| parent | 608a1ce5b184f617d45c69095e1fae7b39402853 (diff) | |
| download | mariadb-git-3331d4e07efca993b3f34fa06b8a03b41b6b690d.tar.gz | |
Merge galera tests from github.com/codership/mysql-wsrep
Diffstat (limited to 'mysql-test/suite/galera/r/galera_many_tables_pk.result')
| -rw-r--r-- | mysql-test/suite/galera/r/galera_many_tables_pk.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_many_tables_pk.result b/mysql-test/suite/galera/r/galera_many_tables_pk.result new file mode 100644 index 00000000000..6b6899d979d --- /dev/null +++ b/mysql-test/suite/galera/r/galera_many_tables_pk.result @@ -0,0 +1,20 @@ +SELECT COUNT(*) = 1000 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME LIKE 't%'; +COUNT(*) = 1000 +1 +SET AUTOCOMMIT=OFF; +START TRANSACTION; +COMMIT; +CREATE TABLE sum_table (f1 INTEGER); +SELECT SUM(f1) = 1000 FROM sum_table; +SUM(f1) = 1000 +1 +SET AUTOCOMMIT=OFF; +START TRANSACTION; +SET AUTOCOMMIT=OFF; +START TRANSACTION; +UPDATE t1000 SET f1 = 3; +COMMIT; +COMMIT; +ERROR 40001: Deadlock found when trying to get lock; try restarting transaction +DROP SCHEMA test; +CREATE SCHEMA test; |