diff options
| author | unknown <tomas@poseidon.ndb.mysql.com> | 2006-07-06 20:04:48 +0200 |
|---|---|---|
| committer | unknown <tomas@poseidon.ndb.mysql.com> | 2006-07-06 20:04:48 +0200 |
| commit | 925fba7a031d1e6b3a025c98436274375b4ca2f7 (patch) | |
| tree | 5ebe5c48a8dadc7c2c5d8ba67f003b622eb08fc8 /mysql-test/t/ndb_restore.test | |
| parent | b78304d21500437e448b85783bc5d698b0f7896f (diff) | |
| download | mariadb-git-925fba7a031d1e6b3a025c98436274375b4ca2f7.tar.gz | |
Bug #20820 auto inc table not handled correctly when restored from cluster backup
mysql-test/t/ndb_dd_backuprestore.test:
make sure only run in default cluster
mysql-test/t/rpl_ndb_dd_advance.test:
make sure only run in default cluster
mysql-test/t/rpl_ndb_sync.test:
make sure only run in default cluster
Diffstat (limited to 'mysql-test/t/ndb_restore.test')
| -rw-r--r-- | mysql-test/t/ndb_restore.test | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/mysql-test/t/ndb_restore.test b/mysql-test/t/ndb_restore.test index 42efedb898a..c465a3d7b92 100644 --- a/mysql-test/t/ndb_restore.test +++ b/mysql-test/t/ndb_restore.test @@ -152,7 +152,7 @@ create table t10 engine=myisam as select * from t10_c; --source include/ndb_backup.inc -drop table t1_c,t2_c,t3_c,t4_c,t5_c,t6_c,t7_c,t8_c,t9_c, t10_c; +drop table t1_c,t2_c,t3_c,t4_c,t5_c,t6_c,t7_c,t8_c,t9_c,t10_c; --exec $NDB_TOOLS_DIR/ndb_restore --no-defaults -b $the_backup_id -n 1 -m -r --print --print_meta $NDB_BACKUP_DIR/BACKUP/BACKUP-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_TOOLS_DIR/ndb_restore --no-defaults -b $the_backup_id -n 2 -r --print --print_meta $NDB_BACKUP_DIR/BACKUP/BACKUP-$the_backup_id >> $NDB_TOOLS_OUTPUT @@ -219,21 +219,26 @@ select * from t10_c order by a; # # Try Partitioned tables as well # +--error 1005 ALTER TABLE t1_c PARTITION BY RANGE (`capgoaledatta`) (PARTITION p0 VALUES LESS THAN MAXVALUE); +--error 1005 ALTER TABLE t2_c PARTITION BY LIST(`capgotod`) (PARTITION p0 VALUES IN (0,1,2,3,4,5,6)); +--error 1005 ALTER TABLE t3_c PARTITION BY HASH (`CapGoaledatta`); +--error 1005 ALTER TABLE t5_c PARTITION BY HASH (`capfa`) PARTITIONS 4; +--error 1005 ALTER TABLE t6_c PARTITION BY LINEAR HASH (`relatta`) PARTITIONS 4; @@ -242,7 +247,7 @@ ALTER TABLE t7_c PARTITION BY LINEAR KEY (`dardtestard`); --source include/ndb_backup.inc -drop table t1_c,t2_c,t3_c,t4_c,t5_c,t6_c,t7_c,t8_c,t9_c; +drop table t1_c,t2_c,t3_c,t4_c,t5_c,t6_c,t7_c,t8_c,t9_c,t10_c; --exec $NDB_TOOLS_DIR/ndb_restore --no-defaults -b $the_backup_id -n 1 -m -r --print --print_meta $NDB_BACKUP_DIR/BACKUP/BACKUP-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_TOOLS_DIR/ndb_restore --no-defaults -b $the_backup_id -n 2 -r --print --print_meta $NDB_BACKUP_DIR/BACKUP/BACKUP-$the_backup_id >> $NDB_TOOLS_OUTPUT @@ -300,7 +305,7 @@ select count(*) from (select * from t9 union select * from t9_c) a; -drop table t1_c,t2_c,t3_c,t4_c,t5_c,t6_c,t7_c,t8_c,t9_c; +drop table t1_c,t2_c,t3_c,t4_c,t5_c,t6_c,t7_c,t8_c,t9_c,t10_c; --exec $NDB_TOOLS_DIR/ndb_restore --no-defaults -b $the_backup_id -n 1 -m -r --ndb-nodegroup_map '(0,0)' --print --print_meta $NDB_BACKUP_DIR/BACKUP/BACKUP-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_TOOLS_DIR/ndb_restore --no-defaults -b $the_backup_id -n 2 -r --print --print_meta $NDB_BACKUP_DIR/BACKUP/BACKUP-$the_backup_id >> $NDB_TOOLS_OUTPUT |