diff options
Diffstat (limited to 'mysql-test/suite/galera/r/galera_status_local_index.result')
| -rw-r--r-- | mysql-test/suite/galera/r/galera_status_local_index.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_status_local_index.result b/mysql-test/suite/galera/r/galera_status_local_index.result new file mode 100644 index 00000000000..4e886ac8921 --- /dev/null +++ b/mysql-test/suite/galera/r/galera_status_local_index.result @@ -0,0 +1,13 @@ +CREATE TABLE wsrep_local_indexes (wsrep_local_index INTEGER); +INSERT INTO wsrep_local_indexes VALUES ((SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE variable_name = 'wsrep_local_index')); +INSERT INTO wsrep_local_indexes VALUES ((SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE variable_name = 'wsrep_local_index')); +SELECT COUNT(*) = 2 FROM wsrep_local_indexes; +COUNT(*) = 2 +1 +SELECT COUNT(DISTINCT wsrep_local_index) = 2 FROM wsrep_local_indexes; +COUNT(DISTINCT wsrep_local_index) = 2 +1 +SELECT COUNT(*) = 0 FROM wsrep_local_indexes WHERE wsrep_local_index NOT IN (0, 1); +COUNT(*) = 0 +1 +DROP TABLE wsrep_local_indexes; |