Debian Codegraph @

mysql-test/suite/ndbcluster/apply_status_table.test

raw
1 --source include/have_ndb.inc
2
3 #
4 # Test that the mysql.ndb_apply_status table has been created properly.
5 # The table is used by MySQL Cluster replication to keep a record
6 # of the operations that have been replicated from the source to the replica.
7 #
8 # The table is created by the ndbcluster plugin while connecting to NDB.
9
10 #
11 # Check that the mysql.ndb_apply_status table exist
12 #
13 select TABLE_SCHEMA, TABLE_NAME from information_schema.tables
14 where TABLE_SCHEMA = 'mysql' and TABLE_NAME = 'ndb_apply_status';
15
16 #
17 # Check that mysql.ndb_apply_status table contains the expected columns
18 # and data types
19 #
20 select ORDINAL_POSITION, COLUMN_NAME, COLUMN_TYPE, CHARACTER_SET_NAME,
21 COLUMN_DEFAULT, IS_NULLABLE from information_schema.columns
22 where TABLE_SCHEMA = 'mysql' and TABLE_NAME = 'ndb_apply_status'
23 order by ORDINAL_POSITION;