--source include/have_ndb.inc --source suite/ndb/include/backup_restore_setup.inc # Test schema restore using pre-7.5 metadata to check # for regressions introduced since then. # A selection of partitioning variants are # checked. # # CREATE TABLE `standard` ( # `a` int(11) NOT NULL, # `b` int(11) DEFAULT NULL, # PRIMARY KEY (`a`) # ) ENGINE=ndbcluster DEFAULT CHARSET=latin1; # # # CREATE TABLE `maxrows_low` ( # `a` int(11) NOT NULL, # `b` int(11) DEFAULT NULL, # PRIMARY KEY (`a`) # ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 MAX_ROWS=10000000; # # # CREATE TABLE `maxrows_high` ( # `a` int(11) NOT NULL, # `b` int(11) DEFAULT NULL, # PRIMARY KEY (`a`) # ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 MAX_ROWS=1000000000; # # # CREATE TABLE `bykeycount` ( # `a` int(11) NOT NULL, # `b` int(11) DEFAULT NULL, # PRIMARY KEY (`a`) # ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 # PARTITION BY KEY (a) # PARTITIONS 8; # # CREATE TABLE `bykeycount_big` ( # `a` int(11) NOT NULL, # `b` int(11) DEFAULT NULL, # PRIMARY KEY (`a`) # ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 # PARTITION BY KEY (a) # PARTITIONS 32; # # CREATE TABLE `another` ( # `a` int(11) NOT NULL, # `b` int(11) DEFAULT NULL, # PRIMARY KEY (`a`) # ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 # PARTITION BY LINEAR KEY (a); # # --exec $NDB_RESTORE $NDB_RESTORE_NO_ENCR -b 1 -n 1 -m $NDB_SAVED_BACKUPS/pre_75_partitioning_variants >> $NDB_TOOLS_OUTPUT use test; show create table standard; show create table maxrows_low; show create table maxrows_high; show create table bykeycount; show create table bykeycount_big; show create table another; --sorted_result show tables; drop table standard; drop table maxrows_low; drop table maxrows_high; drop table bykeycount; drop table bykeycount_big; drop table another; --remove_file $NDB_TOOLS_OUTPUT