Debian Codegraph @

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

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