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