Debian Codegraph @

mysql-test/suite/ndbcluster/information_schema.test

raw
1 --source include/have_ndb.inc
2
3 --echo #
4 --echo # WL#6599: New Data Dictionary and I_S Integration.
5 --echo #
6 --echo # Test case to check if ndbinfo schema is listed by I_S when ndbcluster
7 --echo # is running.
8 --echo #
9 #'ndbinfo' schema should be listed when ndbcluster is running.
10 SELECT schema_name FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'ndbinfo';
11 # tables of ndbinfo schema should be listed.
12 SELECT
13 IF(count(table_name) > 10, 'Yes', 'No') as 'Have more than 10 ndbinfo tables'
14 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'ndbinfo';
15
16 --echo #
17 --echo # Check that it's not possible to create a NDB table
18 --echo # in the information_schema database
19 --echo #
20 --error ER_DBACCESS_DENIED_ERROR
21 create table information_schema.t1(
22 a int,
23 b varchar(10),
24 c date
25 ) engine=ndb;
26
27 #
28 # Bug #27143813 This testcase is to check if the checksum is supported
29 # in Ndb and Innodb.
30 #
31
32 CREATE TABLE t1(a int primary key,b int) engine = NDB;
33 SELECT CHECKSUM FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME="t1";
34
35 --echo checking the same query in innodb and comparing the result.
36
37 CREATE TABLE t2(a int primary key,b int) engine = INNODB;
38 SELECT CHECKSUM FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME="t2";
39
40 DROP TABLE t1,t2;