# To run this scripts from your current directory, the subfolders t/ and r/ are required.
# The t-directory holds all testfiles (*.test), while the r-directory will hold all resultfiles (*.result)
#
# ***

# Record the results of a test:
mysqltest -D database -u user -ppassword --record --result-file r/$1.result < t/$1.test

# Run all testfiles and compare them with the resultfiles:
for testfile in t/*.test
do
	resultfile="r/"`basename $testfile test`"result"
	mysqltest -D database -ppassword -u user --test-file $testfile --result-file $resultfile
done