mysql-test/suite/galera/r/galera_status_local_index.result


1
2
3
4
5
6
7
8
9
10
11
12
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;