Debian Codegraph @

mysql-test/suite/ndbcluster/information_schema.result

raw
1 #
2 # WL#6599: New Data Dictionary and I_S Integration.
3 #
4 # Test case to check if ndbinfo schema is listed by I_S when ndbcluster
5 # is running.
6 #
7 SELECT schema_name FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'ndbinfo';
8 SCHEMA_NAME
9 ndbinfo
10 SELECT
11 IF(count(table_name) > 10, 'Yes', 'No') as 'Have more than 10 ndbinfo tables'
12 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'ndbinfo';
13 Have more than 10 ndbinfo tables
14 Yes
15 #
16 # Check that it's not possible to create a NDB table
17 # in the information_schema database
18 #
19 create table information_schema.t1(
20 a int,
21 b varchar(10),
22 c date
23 ) engine=ndb;
24 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
25 CREATE TABLE t1(a int primary key,b int) engine = NDB;
26 SELECT CHECKSUM FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME="t1";
27 CHECKSUM
28 NULL
29 checking the same query in innodb and comparing the result.
30 CREATE TABLE t2(a int primary key,b int) engine = INNODB;
31 SELECT CHECKSUM FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME="t2";
32 CHECKSUM
33 NULL
34 DROP TABLE t1,t2;