diff options
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; |