1connection node_2;
2connection node_1;
3connection node_1;
4CREATE TABLE wsrep_local_indexes (wsrep_local_index INTEGER);
5INSERT INTO wsrep_local_indexes VALUES ((SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE variable_name = 'wsrep_local_index'));
6connection node_2;
7INSERT INTO wsrep_local_indexes VALUES ((SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE variable_name = 'wsrep_local_index'));
8connection node_1;
9SELECT COUNT(*) = 2 FROM wsrep_local_indexes;
10COUNT(*) = 2
111
12SELECT COUNT(DISTINCT wsrep_local_index) = 2 FROM wsrep_local_indexes;
13COUNT(DISTINCT wsrep_local_index) = 2
141
15SELECT COUNT(*) = 0 FROM wsrep_local_indexes WHERE wsrep_local_index NOT IN (0, 1);
16COUNT(*) = 0
171
18DROP TABLE wsrep_local_indexes;
19