diff options
| author | Patrick Crews <patrick.crews@sun.com> | 2009-05-22 10:38:17 -0400 |
|---|---|---|
| committer | Patrick Crews <patrick.crews@sun.com> | 2009-05-22 10:38:17 -0400 |
| commit | 6c31d59bf43d2d2d0b363a93f7acf2100a816a6a (patch) | |
| tree | 3a605894fb2abe775aef339ab3e0c844429e60b1 /mysql-test/include | |
| parent | 2bb44aef97cd9108f66b5d7f56d86cdbdf3eda98 (diff) | |
| download | mariadb-git-6c31d59bf43d2d2d0b363a93f7acf2100a816a6a.tar.gz | |
Bug#40465 - mysqldump.test does no checking of dump or restore
Created new .test file - mysqldump_restore that does test restore from mysqldump
output for a limited number of basic cases.
Create new .inc file - mysqldump.inc - renames original table and uses mysqldump
output to recreate the table, then uses diff_tables.inc to compare the two tables.
Backported include/diff_tables.inc to facilitate this testing.
New patch incorporating review feedback prior to push.
mysqldump.test - removed redundant call to include/have_log_bin.inc (was used twice in the test!)
Diffstat (limited to 'mysql-test/include')
| -rw-r--r-- | mysql-test/include/mysqldump.inc | 15 |
1 files changed, 12 insertions, 3 deletions
diff --git a/mysql-test/include/mysqldump.inc b/mysql-test/include/mysqldump.inc index fb22ab0bc74..6227138b012 100644 --- a/mysql-test/include/mysqldump.inc +++ b/mysql-test/include/mysqldump.inc @@ -1,28 +1,37 @@ ################################################################################ # mysqldump.inc +# # SUMMARY: include file to facilitate testing the quality of mysqldump output +# # INPUTS: Two variables: # $table_name - the name of the table that was dumped # $mysqldumpfile - the name of the file that captured mysqldump output +# # OUTPUTS: minor echo data: # We 'echo' some stage information to the .result file: # 'altering original table', 'restoring from dumpfile', 'comparing' +# # OTHER FILES: We use include/diff_tables.inc to compare the original, renamed # table with the 'restored' one. +# # DESCRIPTION: This file works by being fed the name of the original table # and a mysqldump output file. The original table is then renamed # to <table_name>_orig, the mysqldump file is used to recreate the # table, then diff_tables.inc is called to compare them. +# # LIMITATIONS: Does *NOT* work with xml output! -# AUTHOR: pcrews +# +# AUTHOR: pcrews 2009-05-21 +# Bug#40465 mysqldump.test does no checking of dump or restore +# # LAST CHANGE: 2009-05-21 -# PURPOSE: Bug#40465: mysqldump.test does no checking of dump or restore +# ################################################################################ --echo # Begin testing mysqldump output + restore --echo # Create 'original table name - <table>_orig # NOTE: We use SET then let as query_get_value has issues with the extra commas -# used in the CONCAT statement. +# used in the CONCAT statement. eval SET @orig_table_name = CONCAT('$table_name', '_orig'); let $orig_table_name = query_get_value(SELECT @orig_table_name,@orig_table_name,1); --echo # Rename original table |