diff options
| author | unknown <pekka@mysql.com> | 2006-02-22 22:04:46 +0100 |
|---|---|---|
| committer | unknown <pekka@mysql.com> | 2006-02-22 22:04:46 +0100 |
| commit | 871335f587d7eefb052e9b08b851098f9ca5e9ed (patch) | |
| tree | 3dfdc1edaababad412fd24c524f37255f21f1c25 /mysql-test/r/ndb_restore.result | |
| parent | b2cf86f1bd9b8ed516f827957b82835fbc7e981a (diff) | |
| download | mariadb-git-871335f587d7eefb052e9b08b851098f9ca5e9ed.tar.gz | |
ndb - ndb_restore.test: fix backup id in result
mysql-test/r/ndb_restore.result:
fix backup id using jeb's ndb_backup.inc
mysql-test/t/ndb_restore.test:
fix backup id using jeb's ndb_backup.inc
Diffstat (limited to 'mysql-test/r/ndb_restore.result')
| -rw-r--r-- | mysql-test/r/ndb_restore.result | 16 |
1 files changed, 15 insertions, 1 deletions
diff --git a/mysql-test/r/ndb_restore.result b/mysql-test/r/ndb_restore.result index 85c4e34cc5a..bdd721d9a16 100644 --- a/mysql-test/r/ndb_restore.result +++ b/mysql-test/r/ndb_restore.result @@ -125,6 +125,13 @@ create table t6 engine=myisam as select * from t6_c; create table t7 engine=myisam as select * from t7_c; create table t8 engine=myisam as select * from t8_c; create table t9 engine=myisam as select * from t9_c; +CREATE TEMPORARY TABLE IF NOT EXISTS test.backup_info (id INT, backup_id INT) ENGINE = HEAP; +DELETE FROM test.backup_info; +LOAD DATA INFILE '../../var/tmp.dat' INTO TABLE test.backup_info FIELDS TERMINATED BY ','; +SELECT @the_backup_id:=backup_id FROM test.backup_info; +@the_backup_id:=backup_id +<the_backup_id> +DROP TABLE test.backup_info; drop table t1_c,t2_c,t3_c,t4_c,t5_c,t6_c,t7_c,t8_c,t9_c; select count(*) from t1; count(*) @@ -241,6 +248,13 @@ PARTITION BY LINEAR HASH (`relatta`) PARTITIONS 4; ALTER TABLE t7_c PARTITION BY LINEAR KEY (`dardtestard`); +CREATE TEMPORARY TABLE IF NOT EXISTS test.backup_info (id INT, backup_id INT) ENGINE = HEAP; +DELETE FROM test.backup_info; +LOAD DATA INFILE '../../var/tmp.dat' INTO TABLE test.backup_info FIELDS TERMINATED BY ','; +SELECT @the_backup_id:=backup_id FROM test.backup_info; +@the_backup_id:=backup_id +<the_backup_id> +DROP TABLE test.backup_info; drop table t1_c,t2_c,t3_c,t4_c,t5_c,t6_c,t7_c,t8_c,t9_c; select count(*) from t1; count(*) @@ -445,4 +459,4 @@ drop table t1_c,t2_c,t3_c,t4_c,t5_c,t6_c,t7_c,t8_c,t9_c; Create table test/def/t2_c failed: Translate frm error drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; drop table if exists t1_c,t2_c,t3_c,t4_c,t5_c,t6_c,t7_c,t8_c,t9_c; -520093696,2 +520093696,<the_backup_id> |