WL#7705: Create test for mysql_tzinfo_to_sql and mysql_waitpid

Status: Complete

Create automated test for mysql_tzinfo_to_sql and mysql_waitpid utility programs.

mysql_tzinfo_to_sql:
The mysql_tzinfo_to_sql program loads the time zone tables in the mysql
database. It is used on systems that have a zoneinfo database (the set of files
describing time zones). Examples of such systems are Linux, FreeBSD, Solaris,
and Mac OS X. One likely location for these files is the /usr/share/zoneinfo
directory (/usr/share/lib/zoneinfo on Solaris). If your system does not have a
zoneinfo database, you can use the downloadable package
mysql_tzinfo_to_sql can be invoked several ways:

shell> mysql_tzinfo_to_sql tz_dir
shell> mysql_tzinfo_to_sql tz_file tz_name
shell> mysql_tzinfo_to_sql --leap tz_file


mysql_waitpid:
mysql_waitpid signals a process to terminate and waits for the process to exit.
It uses the kill() system call and Unix signals, so it runs on Unix and
Unix-like systems.
shell> mysql_waitpid [options] pid wait_time
mysql_waitpid sends signal 0 to the process identified by pid and waits up to
wait_time seconds for the process to terminate. pid and wait_time must be
positive integers.
If process termination occurs within the wait time or the process does not
exist, mysql_waitpid returns 0. Otherwise, it returns 1. 

Worklog will taget creation of test file with respective options.


FR1: Add Testcase for checking mysql_tzinfo_to_sql 
     shell> mysql_tzinfo_to_sql tz_dir (generates sql for given folder which can
be loaded into mysql zone tables)
     shell> mysql_tzinfo_to_sql tz_file tz_name (generates sql for given file
which can be loaded into mysql zone tables)
     shell> mysql_tzinfo_to_sql --leap tz_file

Note: zonefile must exists on system , else test will be skipped.

FR2: Add Testcase for checking mysql_waitpid
     shell> mysql_waitpid [options] pid wait_time
     Check variuous retune values