Debian Codegraph @

mysql-test/suite/ndb/t/ndb_mgm_show_table.inc

raw
1 #
2 # ndb_mgm_show_table.inc - will execute ndb_mgm -e show command and
3 # mask the details that are unwanted for the test(version details, node id,etc)
4 # and make the result consistent.
5 #
6
7 #
8 # Build strings for masking ndb_mgm output
9 #
10
11 #echo MYSQL_SERVER_VERSION: $MYSQL_SERVER_VERSION;
12
13 # extract X.X.X for MySQL
14 let $mysql_version=
15 `select SUBSTRING_INDEX('$MYSQL_SERVER_VERSION','-', 1)`;
16 # Remove any trailing a in the X.X.X string(ugly but works)
17 let $mysql_version=
18 `select TRIM(TRAILING 'a' FROM '$mysql_version')`;
19 let $mysql_version = mysql-$mysql_version;
20 # echo mysql_version: $mysql_version;
21
22 # load ndb-X.X.X from the "ndb_version_string" variable, trim off
23 # the version status indicator i.e -dmr etc.
24 let $ndb_version=
25 `select REGEXP_SUBSTR(@@ndb_version_string, "^ndb-[0-9]*[.][0-9]*[.][0-9]*")`;
26 # echo ndb_version: $ndb_version;
27
28 #masking mgm version and id
29 --disable_query_log
30 let $dump_file = $MYSQLTEST_VARDIR/tmp/ndb_mgm_show.txt;
31
32 # Dump the output of ndb_mgm to file
33 --exec $NDB_MGM -e show > $dump_file;
34
35 # Load the file into a temporary table
36 CREATE TEMPORARY TABLE ndb_mgm_show (id int AUTO_INCREMENT, a varchar(512), PRIMARY KEY (id));
37
38 eval LOAD DATA INFILE '$dump_file' INTO TABLE ndb_mgm_show
39 FIELDS TERMINATED BY '\n' (a) set id = NULL;
40 --remove_file $dump_file
41
42 # Remove Windows line feeds
43 UPDATE ndb_mgm_show SET a = TRIM(TRAILING "\r" FROM a);
44
45 # Ignoring things like: Truncated incorrect DOUBLE value: '---'
46 --disable_warnings
47
48 SELECT id into @ndbd_id FROM ndb_mgm_show
49 WHERE SUBSTR(a, 2, 4) = 'ndbd';
50
51 SELECT id into @mgmd_id FROM ndb_mgm_show
52 WHERE SUBSTR(a, 2, 8) = 'ndb_mgmd';
53
54 SELECT id into @mysqld_id FROM ndb_mgm_show
55 WHERE SUBSTR(a, 2, 6) = 'mysqld';
56
57 SELECT COUNT(1) into @last_id FROM ndb_mgm_show;
58
59 # select * from ndb_mgm_show;
60 # select @ndbd_id ;
61 # select @last_id ;
62 # select @mgmd_id ;
63 # select @mysqld_id ;
64
65 --replace_result $mysql_version MYSQL_VERSION $ndb_version NDB_VERSION @127.0.0.1 LOCALHOST @::1 LOCALHOST
66 SELECT a as 'ndbd(s)' FROM ndb_mgm_show
67 WHERE id > @ndbd_id and id < @mgmd_id-1;
68
69 --replace_result $mysql_version MYSQL_VERSION $ndb_version NDB_VERSION @127.0.0.1 LOCALHOST @::1 LOCALHOST
70 SELECT a as 'ndb_mgmd(s)' FROM ndb_mgm_show
71 WHERE id > @mgmd_id and id < @mysqld_id-1;
72
73 --replace_result $mysql_version MYSQL_VERSION $ndb_version NDB_VERSION @127.0.0.1 LOCALHOST @::1 LOCALHOST
74 SELECT a as 'mysqld(s)' FROM ndb_mgm_show
75 WHERE id > @mysqld_id and id < @last_id;
76
77 --enable_warnings
78
79 DROP TABLE ndb_mgm_show;
80 --enable_query_log