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 | e42f28192d582ec84cd62066a6ce0fb83e32ad0b (patch) | |
| tree | 3a605894fb2abe775aef339ab3e0c844429e60b1 /mysql-test/r/mysqldump_restore.result | |
| parent | 2a47699cad56952ff5d22e18b080a2aacf4c91b4 (diff) | |
| download | mariadb-git-e42f28192d582ec84cd62066a6ce0fb83e32ad0b.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/r/mysqldump_restore.result')
| -rw-r--r-- | mysql-test/r/mysqldump_restore.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/mysqldump_restore.result b/mysql-test/r/mysqldump_restore.result index 1e106c3be11..16698251913 100644 --- a/mysql-test/r/mysqldump_restore.result +++ b/mysql-test/r/mysqldump_restore.result @@ -8,7 +8,7 @@ DROP TABLE IF EXISTS t1; # # Bug#2005 Long decimal comparison bug. # -CREATE TABLE t1 (a decimal(64, 20)); +CREATE TABLE t1 (a DECIMAL(64, 20)); INSERT INTO t1 VALUES ("1234567890123456789012345678901234567890"), ("0987654321098765432109876543210987654321"); # Begin testing mysqldump output + restore @@ -69,8 +69,8 @@ DROP TABLE test.t1, test.t1_orig; # # WL#2319 Exclude Tables from dump # -CREATE TABLE t1 (a int); -CREATE TABLE t2 (a int); +CREATE TABLE t1 (a INT); +CREATE TABLE t2 (a INT); INSERT INTO t1 VALUES (1),(2),(3); INSERT INTO t2 VALUES (4),(5),(6); # Begin testing mysqldump output + restore |