Debian Codegraph @

mysql-test/suite/ndbcluster/binlog_index_table.test

raw
1 --source include/have_ndb.inc
2
3 #
4 # Test that the mysql.ndb_binlog_index table has been created properly.
5 # The table is used by MySQL Cluster replication to keep an index of
6 # how epochs in the cluster relates to positions in the binary log.
7 #
8 # The table is created by SQL in the mysqld's bootstrap code and its
9 # schema is kept up to date by SQL compiled into mysql_upgrade.
10 #
11
12 #
13 # Check that the mysql.ndb_binlog_index table exist
14 #
15 select TABLE_SCHEMA, TABLE_NAME from information_schema.tables
16 where TABLE_SCHEMA = 'mysql' and TABLE_NAME = 'ndb_binlog_index';
17
18 #
19 # Check that mysql.ndb_binlog_index table contains the expected columns
20 # and data types
21 #
22 select ORDINAL_POSITION, COLUMN_NAME, COLUMN_TYPE, COLUMN_DEFAULT,
23 IS_NULLABLE from information_schema.columns
24 where TABLE_SCHEMA = 'mysql' and TABLE_NAME = 'ndb_binlog_index'
25 order by ORDINAL_POSITION;
26