# # ndb_mgm_show_table.inc - will execute ndb_mgm -e show command and # mask the details that are unwanted for the test(version details, node id,etc) # and make the result consistent. # # # Build strings for masking ndb_mgm output # #echo MYSQL_SERVER_VERSION: $MYSQL_SERVER_VERSION; # extract X.X.X for MySQL let $mysql_version= `select SUBSTRING_INDEX('$MYSQL_SERVER_VERSION','-', 1)`; # Remove any trailing a in the X.X.X string(ugly but works) let $mysql_version= `select TRIM(TRAILING 'a' FROM '$mysql_version')`; let $mysql_version = mysql-$mysql_version; # echo mysql_version: $mysql_version; # load ndb-X.X.X from the "ndb_version_string" variable, trim off # the version status indicator i.e -dmr etc. let $ndb_version= `select REGEXP_SUBSTR(@@ndb_version_string, "^ndb-[0-9]*[.][0-9]*[.][0-9]*")`; # echo ndb_version: $ndb_version; #masking mgm version and id --disable_query_log let $dump_file = $MYSQLTEST_VARDIR/tmp/ndb_mgm_show.txt; # Dump the output of ndb_mgm to file --exec $NDB_MGM -e show > $dump_file; # Load the file into a temporary table CREATE TEMPORARY TABLE ndb_mgm_show (id int AUTO_INCREMENT, a varchar(512), PRIMARY KEY (id)); eval LOAD DATA INFILE '$dump_file' INTO TABLE ndb_mgm_show FIELDS TERMINATED BY '\n' (a) set id = NULL; --remove_file $dump_file # Remove Windows line feeds UPDATE ndb_mgm_show SET a = TRIM(TRAILING "\r" FROM a); # Ignoring things like: Truncated incorrect DOUBLE value: '---' --disable_warnings SELECT id into @ndbd_id FROM ndb_mgm_show WHERE SUBSTR(a, 2, 4) = 'ndbd'; SELECT id into @mgmd_id FROM ndb_mgm_show WHERE SUBSTR(a, 2, 8) = 'ndb_mgmd'; SELECT id into @mysqld_id FROM ndb_mgm_show WHERE SUBSTR(a, 2, 6) = 'mysqld'; SELECT COUNT(1) into @last_id FROM ndb_mgm_show; # select * from ndb_mgm_show; # select @ndbd_id ; # select @last_id ; # select @mgmd_id ; # select @mysqld_id ; --replace_result $mysql_version MYSQL_VERSION $ndb_version NDB_VERSION @127.0.0.1 LOCALHOST @::1 LOCALHOST SELECT a as 'ndbd(s)' FROM ndb_mgm_show WHERE id > @ndbd_id and id < @mgmd_id-1; --replace_result $mysql_version MYSQL_VERSION $ndb_version NDB_VERSION @127.0.0.1 LOCALHOST @::1 LOCALHOST SELECT a as 'ndb_mgmd(s)' FROM ndb_mgm_show WHERE id > @mgmd_id and id < @mysqld_id-1; --replace_result $mysql_version MYSQL_VERSION $ndb_version NDB_VERSION @127.0.0.1 LOCALHOST @::1 LOCALHOST SELECT a as 'mysqld(s)' FROM ndb_mgm_show WHERE id > @mysqld_id and id < @last_id; --enable_warnings DROP TABLE ndb_mgm_show; --enable_query_log