summaryrefslogtreecommitdiff
path: root/mysql-test/suite/galera/t/galera_schema_dirty_reads.test
blob: 93e24244611c931802e75fba4f1ff9da02c7b71d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
#
# Dirty reads from INFORMATION_SCHEMA tables.
#
--source include/galera_cluster.inc
--source include/have_innodb.inc
--disable_info
USE information_schema;
SELECT * FROM SESSION_VARIABLES WHERE VARIABLE_NAME LIKE "wsrep_dirty_reads";
SET GLOBAL wsrep_reject_queries=ALL;
SELECT * FROM SESSION_VARIABLES WHERE VARIABLE_NAME LIKE "wsrep_dirty_reads";
SET GLOBAL wsrep_reject_queries=NONE;
SET SESSION wsrep_dirty_reads=TRUE;
SELECT * FROM SESSION_VARIABLES WHERE VARIABLE_NAME LIKE "wsrep_dirty_reads";