Debian Codegraph @

mysql-test/suite/ndbcluster/ndbcluster-plugins.test

raw
1 source include/have_ndb.inc;
2
3 echo # All three ndb-plugins should be ENABLED;
4 SELECT RPAD(PLUGIN_NAME, 33, ' ') 'PLUGIN_NAME ',
5 LOAD_OPTION, PLUGIN_STATUS, PLUGIN_TYPE
6 FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'ndb%'
7 ORDER BY PLUGIN_NAME;
8 echo;
9
10 echo # Both ndb-engines should be enabled (SUPPORT YES);
11 SELECT RPAD(ENGINE, 10, ' ') 'ENGINE ', SUPPORT
12 FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE LIKE 'ndb%' ORDER BY ENGINE;
13 echo;
14
15 echo # ndb schemas;
16 SELECT DISTINCT TABLE_SCHEMA FROM INFORMATION_SCHEMA.TABLES
17 WHERE TABLE_SCHEMA LIKE 'ndb%' ORDER BY TABLE_SCHEMA;
18 echo;
19
20 echo # ndb tables;
21 SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, ENGINE
22 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE 'ndb%'
23 ORDER BY TABLE_SCHEMA, TABLE_NAME;
24 echo;
25
26 echo # There should be many ndb variables;
27 SELECT COUNT(*) >= 69 FROM performance_schema.session_variables
28 WHERE variable_name LIKE 'ndb%';
29
30 echo MYSQLD --help --verbose # ALL OFF;
31 let $ndb_exec_command= $MYSQLD --no-defaults --help --verbose;
32 let $ndb_exec_select= REGEXP_LIKE(output_line,
33 '^(ndbcluster|ndbinfo|ndb-transid-mysql-connection-map) .*');
34 let $ndb_exec_project= output_line;
35 source suite/ndb/include/ndb_exec.inc;
36
37 echo MYSQLD --ndbcluster=0 --ndbinfo --help --verbose # ALL OFF;
38 let $ndb_exec_command= $MYSQLD --no-defaults --ndbcluster=0 --ndbinfo --help
39 --verbose;
40 let $ndb_exec_select= REGEXP_LIKE(output_line,
41 '^(ndbcluster|ndbinfo|ndb-transid-mysql-connection-map) .*');
42 let $ndb_exec_project= output_line;
43 source suite/ndb/include/ndb_exec.inc;
44
45 echo MYSQLD --ndbcluster --help --verbose # ALL ON;
46 let $ndb_exec_command= $MYSQLD --no-defaults --ndbcluster --help --verbose;
47 let $ndb_exec_select= REGEXP_LIKE(output_line,
48 '^(ndbcluster|ndbinfo|ndb-transid-mysql-connection-map) .*');
49 let $ndb_exec_project= output_line;
50 source suite/ndb/include/ndb_exec.inc;
51
52 echo MYSQLD --ndbcluster=1 --ndbinfo=0 --help --verbose # ndbinfo OFF;
53 let $ndb_exec_command= $MYSQLD --no-defaults --ndbcluster=1 --ndbinfo=0 --help
54 --verbose;
55 let $ndb_exec_select= REGEXP_LIKE(output_line,
56 '^(ndbcluster|ndbinfo|ndb-transid-mysql-connection-map) .*');
57 let $ndb_exec_project= output_line;
58 source suite/ndb/include/ndb_exec.inc;
59
60 echo MYSQLD --ndbcluster=1 --ndb-transid-mysql-connection-map=0 --help
61 --verbose # ndb-transid-mysql-connection-map OFF;
62 let $ndb_exec_command= $MYSQLD --no-defaults --ndbcluster=1
63 --ndb-transid-mysql-connection-map=0 --help --verbose;
64 let $ndb_exec_select= REGEXP_LIKE(output_line,
65 '^(ndbcluster|ndbinfo|ndb-transid-mysql-connection-map) .*');
66 let $ndb_exec_project= output_line;
67 source suite/ndb/include/ndb_exec.inc;