[ Avaa Bypassed ]

Upload:

Command:

hmhc3928@3.135.214.216: ~ $ 
######################################################################
# Test restoring backups with lossy conversions on integral types
######################################################################

-- source include/have_ndb.inc

# mysqld's configuration is not relevant to this test
-- source include/not_embedded.inc

--echo ************************************************************
--echo * Creating table with integral types
--echo ************************************************************

CREATE TABLE t1(
  t1 tinyint,  t2 tinyint,  ut1 tinyint unsigned,
  s1 smallint,  s2 smallint,  us1 smallint unsigned,
  m1 mediumint,  m2 mediumint,  um1 mediumint unsigned,
  i1 int,  i2 int,  ui1 int unsigned,
  b1 bigint,  b2 bigint,  ub1 bigint unsigned
) ENGINE=NDB;

INSERT INTO t1 VALUES(
  -128, 127, 255,
  -32768, 32767, 65535,
  -8388608, 8388607, 16777215,
  -2147483648, 2147483647, 4294967295,
  -9223372036854775808, 9223372036854775807, 18446744073709551615
);

--echo ************************************************************
--echo * Backing up table with integral types
--echo ************************************************************

--source include/ndb_backup.inc

# command shortcuts
--let $restore_cmd=$NDB_RESTORE --no-defaults -b $the_backup_id
--let $restore_cmd=$restore_cmd -r --backup_path=$NDB_BACKUPS-$the_backup_id

--echo ************************************************************
--echo * Restoring table with unchanged integral types:
--echo *     tinyint[unsigned]  -->    tinyint[unsigned]
--echo *    smallint[unsigned]  -->   smallint[unsigned]
--echo *   mediumint[unsigned]  -->  mediumint[unsigned]
--echo *         int[unsigned]  -->        int[unsigned]
--echo *      bigint[unsigned]  -->     bigint[unsigned]
--echo ************************************************************

# create a MyISAM table from NDB table, against which to compare data
CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;

# restore table
DELETE FROM t1;
# for debugging:
#    --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -L -r --print $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
#    --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -L -r --print $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
--exec $restore_cmd -n 1 --print -L > /dev/null
--exec $restore_cmd -n 2 --print -L > /dev/null
SELECT * FROM t1;

# verify data
SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
DROP TABLE t1_myisam;

--echo ************************************************************
--echo * Restoring table with 1st degree demoted integral types:
--echo *     tinyint[unsigned]  -->    tinyint[unsigned]
--echo *    smallint[unsigned]  -->    tinyint[unsigned]
--echo *   mediumint[unsigned]  -->   smallint[unsigned]
--echo *         int[unsigned]  -->  mediumint[unsigned]
--echo *      bigint[unsigned]  -->        int[unsigned]
--echo ************************************************************

# demote integral type attibutes
--disable_warnings
ALTER TABLE t1
  modify t1 tinyint,  modify t2 tinyint,  modify ut1 tinyint unsigned,
  modify s1 tinyint,  modify s2 tinyint,  modify us1 tinyint unsigned,
  modify m1 smallint,  modify m2 smallint,  modify um1 smallint unsigned,
  modify i1 mediumint,  modify i2 mediumint,  modify ui1 mediumint unsigned,
  modify b1 int,  modify b2 int,  modify ub1 int unsigned;
--enable_warnings
SELECT * FROM t1;

# create a MyISAM table from NDB table, against which to compare data
CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;

# restore table
DELETE FROM t1;
--exec $restore_cmd -n 1 --print -L > /dev/null
--exec $restore_cmd -n 2 --print -L > /dev/null
SELECT * FROM t1;

# verify data
SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
DROP TABLE t1_myisam;

--echo ************************************************************
--echo * Restoring table with 2nd degree demoted integral types:
--echo *     tinyint[unsigned]  -->    tinyint[unsigned]
--echo *    smallint[unsigned]  -->    tinyint[unsigned]
--echo *   mediumint[unsigned]  -->    tinyint[unsigned]
--echo *         int[unsigned]  -->   smallint[unsigned]
--echo *      bigint[unsigned]  -->  mediumint[unsigned]
--echo ************************************************************

# demote integral type attibutes
--disable_warnings
ALTER TABLE t1
  modify t1 tinyint,  modify t2 tinyint,  modify ut1 tinyint unsigned,
  modify s1 tinyint,  modify s2 tinyint,  modify us1 tinyint unsigned,
  modify m1 tinyint,  modify m2 tinyint,  modify um1 tinyint unsigned,
  modify i1 smallint,  modify i2 smallint,  modify ui1 smallint unsigned,
  modify b1 mediumint,  modify b2 mediumint,  modify ub1 mediumint unsigned;
--enable_warnings
SELECT * FROM t1;

# create a MyISAM table from NDB table, against which to compare data
CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;

# restore table
DELETE FROM t1;
--exec $restore_cmd -n 1 --print -L > /dev/null
--exec $restore_cmd -n 2 --print -L > /dev/null
SELECT * FROM t1;

# verify data
SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
DROP TABLE t1_myisam;

--echo ************************************************************
--echo * Restoring table with 3rd degree demoted integral types:
--echo *     tinyint[unsigned]  -->    tinyint[unsigned]
--echo *    smallint[unsigned]  -->    tinyint[unsigned]
--echo *   mediumint[unsigned]  -->    tinyint[unsigned]
--echo *         int[unsigned]  -->    tinyint[unsigned]
--echo *      bigint[unsigned]  -->   smallint[unsigned]
--echo ************************************************************

# demote integral type attibutes
--disable_warnings
ALTER TABLE t1
  modify t1 tinyint,  modify t2 tinyint,  modify ut1 tinyint unsigned,
  modify s1 tinyint,  modify s2 tinyint,  modify us1 tinyint unsigned,
  modify m1 tinyint,  modify m2 tinyint,  modify um1 tinyint unsigned,
  modify i1 tinyint,  modify i2 tinyint,  modify ui1 tinyint unsigned,
  modify b1 smallint,  modify b2 smallint,  modify ub1 smallint unsigned;
--enable_warnings
SELECT * FROM t1;

# create a MyISAM table from NDB table, against which to compare data
CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;

# restore table
DELETE FROM t1;
--exec $restore_cmd -n 1 --print -L > /dev/null
--exec $restore_cmd -n 2 --print -L > /dev/null
SELECT * FROM t1;

# verify data
SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
DROP TABLE t1_myisam;

--echo ************************************************************
--echo * Restoring table with 4th degree demoted integral types:
--echo *     tinyint[unsigned]  -->    tinyint[unsigned]
--echo *    smallint[unsigned]  -->    tinyint[unsigned]
--echo *   mediumint[unsigned]  -->    tinyint[unsigned]
--echo *         int[unsigned]  -->    tinyint[unsigned]
--echo *      bigint[unsigned]  -->    tinyint[unsigned]
--echo ************************************************************

# demote integral type attibutes
--disable_warnings
ALTER TABLE t1
  modify t1 tinyint,  modify t2 tinyint,  modify ut1 tinyint unsigned,
  modify s1 tinyint,  modify s2 tinyint,  modify us1 tinyint unsigned,
  modify m1 tinyint,  modify m2 tinyint,  modify um1 tinyint unsigned,
  modify i1 tinyint,  modify i2 tinyint,  modify ui1 tinyint unsigned,
  modify b1 tinyint,  modify b2 tinyint,  modify ub1 tinyint unsigned;
--enable_warnings
SELECT * FROM t1;

# create a MyISAM table from NDB table, against which to compare data
CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;

# restore table
DELETE FROM t1;
--exec $restore_cmd -n 1 --print -L > /dev/null
--exec $restore_cmd -n 2 --print -L > /dev/null
SELECT * FROM t1;

# verify data
SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
DROP TABLE t1_myisam;

--echo ************************************************************
--echo * Restoring table with changed signedness:
--echo *     tinyint unsigned/signed  -->    tinyint signed/unsigned
--echo *    smallint unsigned/signed  -->   smallint signed/unsigned
--echo *   mediumint unsigned/signed  -->  mediumint signed/unsigned
--echo *         int unsigned/signed  -->        int signed/unsigned
--echo *      bigint unsigned/signed  -->     bigint signed/unsigned
--echo ************************************************************

# convert signedness of integral type attibutes
--disable_warnings
DELETE FROM t1;
ALTER TABLE t1
  modify t1 tinyint unsigned,  modify t2 tinyint unsigned,  modify ut1 tinyint signed,
  modify s1 smallint unsigned,  modify s2 smallint unsigned,  modify us1 smallint signed,
  modify m1 mediumint unsigned,  modify m2 mediumint unsigned,  modify um1 mediumint signed,
  modify i1 int unsigned,  modify i2 int unsigned,  modify ui1 int signed,
  modify b1 bigint unsigned,  modify b2 bigint unsigned,  modify ub1 bigint signed;
INSERT INTO t1 VALUES(
  -128, 127, 255,
  -32768, 32767, 65535,
  -8388608, 8388607, 16777215,
  -2147483648, 2147483647, 4294967295,
  -9223372036854775808, 9223372036854775807, 18446744073709551615
);
--enable_warnings
SELECT * FROM t1;

# create a MyISAM table from NDB table, against which to compare data
CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;

# restore table
DELETE FROM t1;
--exec $restore_cmd -n 1 --print -L > /dev/null
--exec $restore_cmd -n 2 --print -L > /dev/null
SELECT * FROM t1;

# verify data
SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
DROP TABLE t1_myisam;

--echo ************************************************************
--echo * Restoring table with changed signedness + 1st degree promoted types:
--echo *     tinyint unsigned/signed  -->   smallint signed/unsigned
--echo *    smallint unsigned/signed  -->  mediumint signed/unsigned
--echo *   mediumint unsigned/signed  -->        int signed/unsigned
--echo *         int unsigned/signed  -->     bigint signed/unsigned
--echo *      bigint unsigned/signed  -->     bigint signed/unsigned
--echo ************************************************************

# convert signedness of integral type attibutes
--disable_warnings
DELETE FROM t1;
ALTER TABLE t1
  modify t1 smallint unsigned,  modify t2 smallint unsigned,  modify ut1 smallint signed,
  modify s1 mediumint unsigned,  modify s2 mediumint unsigned,  modify us1 mediumint signed,
  modify m1 int unsigned,  modify m2 int unsigned,  modify um1 int signed,
  modify i1 bigint unsigned,  modify i2 bigint unsigned,  modify ui1 bigint signed,
  modify b1 bigint unsigned,  modify b2 bigint unsigned,  modify ub1 bigint signed;
INSERT INTO t1 VALUES(
  -128, 127, 255,
  -32768, 32767, 65535,
  -8388608, 8388607, 16777215,
  -2147483648, 2147483647, 4294967295,
  -9223372036854775808, 9223372036854775807, 18446744073709551615
);
--enable_warnings
SELECT * FROM t1;

# create a MyISAM table from NDB table, against which to compare data
CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;

# restore table
DELETE FROM t1;
--exec $restore_cmd -n 1 --print -L > /dev/null
--exec $restore_cmd -n 2 --print -L > /dev/null
SELECT * FROM t1;

# verify data
SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
DROP TABLE t1_myisam;

--echo ************************************************************
--echo * Restoring table with changed signedness + 2nd degree promoted types:
--echo *     tinyint unsigned/signed  -->  mediumint signed/unsigned
--echo *    smallint unsigned/signed  -->        int signed/unsigned
--echo *   mediumint unsigned/signed  -->     bigint signed/unsigned
--echo *         int unsigned/signed  -->     bigint signed/unsigned
--echo *      bigint unsigned/signed  -->     bigint signed/unsigned
--echo ************************************************************

# convert signedness of integral type attibutes
--disable_warnings
DELETE FROM t1;
ALTER TABLE t1
  modify t1 mediumint unsigned,  modify t2 mediumint unsigned,  modify ut1 mediumint signed,
  modify s1 int unsigned,  modify s2 int unsigned,  modify us1 int signed,
  modify m1 bigint unsigned,  modify m2 bigint unsigned,  modify um1 bigint signed,
  modify i1 bigint unsigned,  modify i2 bigint unsigned,  modify ui1 bigint signed,
  modify b1 bigint unsigned,  modify b2 bigint unsigned,  modify ub1 bigint signed;
INSERT INTO t1 VALUES(
  -128, 127, 255,
  -32768, 32767, 65535,
  -8388608, 8388607, 16777215,
  -2147483648, 2147483647, 4294967295,
  -9223372036854775808, 9223372036854775807, 18446744073709551615
);
--enable_warnings
SELECT * FROM t1;

# create a MyISAM table from NDB table, against which to compare data
CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;

# restore table
DELETE FROM t1;
--exec $restore_cmd -n 1 --print -L > /dev/null
--exec $restore_cmd -n 2 --print -L > /dev/null
SELECT * FROM t1;

# verify data
SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
DROP TABLE t1_myisam;

--echo ************************************************************
--echo * Restoring table with changed signedness + 3rd degree promoted types:
--echo *     tinyint unsigned/signed  -->        int signed/unsigned
--echo *    smallint unsigned/signed  -->     bigint signed/unsigned
--echo *   mediumint unsigned/signed  -->     bigint signed/unsigned
--echo *         int unsigned/signed  -->     bigint signed/unsigned
--echo *      bigint unsigned/signed  -->     bigint signed/unsigned
--echo ************************************************************

# convert signedness of integral type attibutes
--disable_warnings
DELETE FROM t1;
ALTER TABLE t1
  modify t1 int unsigned,  modify t2 int unsigned,  modify ut1 int signed,
  modify s1 bigint unsigned,  modify s2 bigint unsigned,  modify us1 bigint signed,
  modify m1 bigint unsigned,  modify m2 bigint unsigned,  modify um1 bigint signed,
  modify i1 bigint unsigned,  modify i2 bigint unsigned,  modify ui1 bigint signed,
  modify b1 bigint unsigned,  modify b2 bigint unsigned,  modify ub1 bigint signed;
INSERT INTO t1 VALUES(
  -128, 127, 255,
  -32768, 32767, 65535,
  -8388608, 8388607, 16777215,
  -2147483648, 2147483647, 4294967295,
  -9223372036854775808, 9223372036854775807, 18446744073709551615
);
--enable_warnings
SELECT * FROM t1;

# create a MyISAM table from NDB table, against which to compare data
CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;

# restore table
DELETE FROM t1;
--exec $restore_cmd -n 1 --print -L > /dev/null
--exec $restore_cmd -n 2 --print -L > /dev/null
SELECT * FROM t1;

# verify data
SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
DROP TABLE t1_myisam;

--echo ************************************************************
--echo * Restoring table with changed signedness + 4th degree promoted types:
--echo *     tinyint unsigned/signed  -->     bigint signed/unsigned
--echo *    smallint unsigned/signed  -->     bigint signed/unsigned
--echo *   mediumint unsigned/signed  -->     bigint signed/unsigned
--echo *         int unsigned/signed  -->     bigint signed/unsigned
--echo *      bigint unsigned/signed  -->     bigint signed/unsigned
--echo ************************************************************

# convert signedness of integral type attibutes
--disable_warnings
DELETE FROM t1;
ALTER TABLE t1
  modify t1 bigint unsigned,  modify t2 bigint unsigned,  modify ut1 bigint signed,
  modify s1 bigint unsigned,  modify s2 bigint unsigned,  modify us1 bigint signed,
  modify m1 bigint unsigned,  modify m2 bigint unsigned,  modify um1 bigint signed,
  modify i1 bigint unsigned,  modify i2 bigint unsigned,  modify ui1 bigint signed,
  modify b1 bigint unsigned,  modify b2 bigint unsigned,  modify ub1 bigint signed;
INSERT INTO t1 VALUES(
  -128, 127, 255,
  -32768, 32767, 65535,
  -8388608, 8388607, 16777215,
  -2147483648, 2147483647, 4294967295,
  -9223372036854775808, 9223372036854775807, 18446744073709551615
);
--enable_warnings
SELECT * FROM t1;

# create a MyISAM table from NDB table, against which to compare data
CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;

# restore table
DELETE FROM t1;
--exec $restore_cmd -n 1 --print -L > /dev/null
--exec $restore_cmd -n 2 --print -L > /dev/null
SELECT * FROM t1;

# verify data
SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
DROP TABLE t1_myisam;

--echo ************************************************************
--echo * Restoring table with changed signedness + 1st degree demoted types:
--echo *     tinyint unsigned/signed  -->    tinyint signed/unsigned
--echo *    smallint unsigned/signed  -->    tinyint signed/unsigned
--echo *   mediumint unsigned/signed  -->   smallint signed/unsigned
--echo *         int unsigned/signed  -->  mediumint signed/unsigned
--echo *      bigint unsigned/signed  -->        int signed/unsigned
--echo ************************************************************

# convert signedness of integral type attibutes
--disable_warnings
DELETE FROM t1;
ALTER TABLE t1
  modify t1 tinyint unsigned,  modify t2 tinyint unsigned,  modify ut1 tinyint signed,
  modify s1 tinyint unsigned,  modify s2 tinyint unsigned,  modify us1 tinyint signed,
  modify m1 smallint unsigned,  modify m2 smallint unsigned,  modify um1 smallint signed,
  modify i1 mediumint unsigned,  modify i2 mediumint unsigned,  modify ui1 mediumint signed,
  modify b1 int unsigned,  modify b2 int unsigned,  modify ub1 int signed;
INSERT INTO t1 VALUES(
  -128, 127, 255,
  -32768, 32767, 65535,
  -8388608, 8388607, 16777215,
  -2147483648, 2147483647, 4294967295,
  -9223372036854775808, 9223372036854775807, 18446744073709551615
);
--enable_warnings
SELECT * FROM t1;

# create a MyISAM table from NDB table, against which to compare data
CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;

# restore table
DELETE FROM t1;
--exec $restore_cmd -n 1 --print -L > /dev/null
--exec $restore_cmd -n 2 --print -L > /dev/null
SELECT * FROM t1;

# verify data
SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
DROP TABLE t1_myisam;

--echo ************************************************************
--echo * Restoring table with changed signedness + 2nd degree demoted types:
--echo *     tinyint unsigned/signed  -->    tinyint signed/unsigned
--echo *    smallint unsigned/signed  -->    tinyint signed/unsigned
--echo *   mediumint unsigned/signed  -->    tinyint signed/unsigned
--echo *         int unsigned/signed  -->   smallint signed/unsigned
--echo *      bigint unsigned/signed  -->  mediumint signed/unsigned
--echo ************************************************************

# convert signedness of integral type attibutes
--disable_warnings
DELETE FROM t1;
ALTER TABLE t1
  modify t1 tinyint unsigned,  modify t2 tinyint unsigned,  modify ut1 tinyint signed,
  modify s1 tinyint unsigned,  modify s2 tinyint unsigned,  modify us1 tinyint signed,
  modify m1 tinyint unsigned,  modify m2 tinyint unsigned,  modify um1 tinyint signed,
  modify i1 smallint unsigned,  modify i2 smallint unsigned,  modify ui1 smallint signed,
  modify b1 mediumint unsigned,  modify b2 mediumint unsigned,  modify ub1 mediumint signed;
INSERT INTO t1 VALUES(
  -128, 127, 255,
  -32768, 32767, 65535,
  -8388608, 8388607, 16777215,
  -2147483648, 2147483647, 4294967295,
  -9223372036854775808, 9223372036854775807, 18446744073709551615
);
--enable_warnings
SELECT * FROM t1;

# create a MyISAM table from NDB table, against which to compare data
CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;

# restore table
DELETE FROM t1;
--exec $restore_cmd -n 1 --print -L > /dev/null
--exec $restore_cmd -n 2 --print -L > /dev/null
SELECT * FROM t1;

# verify data
SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
DROP TABLE t1_myisam;

--echo ************************************************************
--echo * Restoring table with changed signedness + 3rd degree demoted types:
--echo *     tinyint unsigned/signed  -->    tinyint signed/unsigned
--echo *    smallint unsigned/signed  -->    tinyint signed/unsigned
--echo *   mediumint unsigned/signed  -->    tinyint signed/unsigned
--echo *         int unsigned/signed  -->    tinyint signed/unsigned
--echo *      bigint unsigned/signed  -->   smallint signed/unsigned
--echo ************************************************************

# convert signedness of integral type attibutes
--disable_warnings
DELETE FROM t1;
ALTER TABLE t1
  modify t1 tinyint unsigned,  modify t2 tinyint unsigned,  modify ut1 tinyint signed,
  modify s1 tinyint unsigned,  modify s2 tinyint unsigned,  modify us1 tinyint signed,
  modify m1 tinyint unsigned,  modify m2 tinyint unsigned,  modify um1 tinyint signed,
  modify i1 tinyint unsigned,  modify i2 tinyint unsigned,  modify ui1 tinyint signed,
  modify b1 smallint unsigned,  modify b2 smallint unsigned,  modify ub1 smallint signed;
INSERT INTO t1 VALUES(
  -128, 127, 255,
  -32768, 32767, 65535,
  -8388608, 8388607, 16777215,
  -2147483648, 2147483647, 4294967295,
  -9223372036854775808, 9223372036854775807, 18446744073709551615
);
--enable_warnings
SELECT * FROM t1;

# create a MyISAM table from NDB table, against which to compare data
CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;

# restore table
DELETE FROM t1;
--exec $restore_cmd -n 1 --print -L > /dev/null
--exec $restore_cmd -n 2 --print -L > /dev/null
SELECT * FROM t1;

# verify data
SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
DROP TABLE t1_myisam;

--echo ************************************************************
--echo * Restoring table with changed signedness + 4th degree demoted types:
--echo *     tinyint unsigned/signed  -->    tinyint signed/unsigned
--echo *    smallint unsigned/signed  -->    tinyint signed/unsigned
--echo *   mediumint unsigned/signed  -->    tinyint signed/unsigned
--echo *         int unsigned/signed  -->    tinyint signed/unsigned
--echo *      bigint unsigned/signed  -->    tinyint signed/unsigned
--echo ************************************************************

# convert signedness of integral type attibutes
--disable_warnings
DELETE FROM t1;
ALTER TABLE t1
  modify t1 tinyint unsigned,  modify t2 tinyint unsigned,  modify ut1 tinyint signed,
  modify s1 tinyint unsigned,  modify s2 tinyint unsigned,  modify us1 tinyint signed,
  modify m1 tinyint unsigned,  modify m2 tinyint unsigned,  modify um1 tinyint signed,
  modify i1 tinyint unsigned,  modify i2 tinyint unsigned,  modify ui1 tinyint signed,
  modify b1 tinyint unsigned,  modify b2 tinyint unsigned,  modify ub1 tinyint signed;
INSERT INTO t1 VALUES(
  -128, 127, 255,
  -32768, 32767, 65535,
  -8388608, 8388607, 16777215,
  -2147483648, 2147483647, 4294967295,
  -9223372036854775808, 9223372036854775807, 18446744073709551615
);
--enable_warnings
SELECT * FROM t1;

# create a MyISAM table from NDB table, against which to compare data
CREATE TABLE t1_myisam ENGINE=MYISAM AS SELECT * FROM t1;

# restore table
DELETE FROM t1;
--exec $restore_cmd -n 1 --print -L > /dev/null
--exec $restore_cmd -n 2 --print -L > /dev/null
SELECT * FROM t1;

# verify data
SELECT COUNT(*) FROM t1 NATURAL JOIN t1_myisam;
DROP TABLE t1_myisam;

--echo ************************************************************
--echo * Deleting table with integral types
--echo ************************************************************

DROP TABLE t1;

Filemanager

DIR : / usr/ share/ mysql-test/ suite/ ndb/ t/
Name Type Size Permission Actions
bug36547.test File 386 B 0644
clusterj.test File 1.8 KB 0644
clusterj_jpa.test File 2.46 KB 0644
disabled.def File 918 B 0644
have_ndb_dist_priv.inc File 857 B 0644
have_ndb_error_insert.inc File 931 B 0644
have_ndbinfo.inc File 821 B 0644
loaddata_autocom_ndb.test File 98 B 0644
ndb_add_partition.test File 6.78 KB 0644
ndb_addnode.cnf File 664 B 0644
ndb_addnode.test File 2.18 KB 0644
ndb_alter_table.test File 9.6 KB 0644
ndb_alter_table2.test File 1.31 KB 0644
ndb_alter_table3.test File 1.47 KB 0644
ndb_alter_table_backup.test File 1.53 KB 0644
ndb_alter_table_error.test File 953 B 0644
ndb_alter_table_online.test File 21.47 KB 0644
ndb_alter_table_online2.test File 4.82 KB 0644
ndb_alter_table_online_multi.test File 1.92 KB 0644
ndb_auto_increment.test File 11.59 KB 0644
ndb_autoinc.test File 642 B 0644
ndb_basic.test File 20.68 KB 0644
ndb_bitfield.test File 6.33 KB 0644
ndb_blob.test File 17.7 KB 0644
ndb_blob_big.cnf File 353 B 0644
ndb_blob_big.test File 1.62 KB 0644
ndb_blob_partition.test File 4.28 KB 0644
ndb_bug26793.test File 843 B 0644
ndb_bug31477.test File 2.13 KB 0644
ndb_bug31754.test File 206 B 0644
ndb_bulk_delete.test File 3.92 KB 0644
ndb_cache.test File 7.92 KB 0644
ndb_cache2.test File 11.05 KB 0644
ndb_cache_multi.test File 1.89 KB 0644
ndb_cache_multi2.test File 4.3 KB 0644
ndb_cache_trans.test File 4.64 KB 0644
ndb_charset.test File 6.41 KB 0644
ndb_column_properties.test File 4.48 KB 0644
ndb_condition_pushdown.test File 80.54 KB 0644
ndb_config.test File 3.53 KB 0644
ndb_config2.test File 346 B 0644
ndb_create_table.test File 795 B 0644
ndb_cursor.test File 918 B 0644
ndb_database.test File 2.99 KB 0644
ndb_dbug_lock.test File 1.94 KB 0644
ndb_dbug_tc_select.test File 3.81 KB 0644
ndb_dbug_tc_select_1.inc File 1.83 KB 0644
ndb_dbug_tc_select_2.inc File 1.91 KB 0644
ndb_dbug_tc_select_3.inc File 2.06 KB 0644
ndb_dd_alter.test File 7.87 KB 0644
ndb_dd_basic.test File 20.17 KB 0644
ndb_dd_bug12581213.cnf File 111 B 0644
ndb_dd_bug12581213.test File 370 B 0644
ndb_dd_ddl.test File 7.37 KB 0644
ndb_dd_disk2memory.test File 10.02 KB 0644
ndb_dd_dump.test File 10.58 KB 0644
ndb_dd_restore_compat.test File 949 B 0644
ndb_dd_sql_features.test File 16.14 KB 0644
ndb_ddl_open_trans.test File 2.54 KB 0644
ndb_disconnect_ddl.test File 1.31 KB 0644
ndb_discover_db-master.opt File 43 B 0644
ndb_discover_db.test File 1.88 KB 0644
ndb_dist_priv.test File 7.09 KB 0644
ndb_gis.test File 211 B 0644
ndb_global_schema_lock.test File 3.51 KB 0644
ndb_global_schema_lock_error.test File 1.53 KB 0644
ndb_grant.later File 10.98 KB 0644
ndb_hidden_pk.test File 2.55 KB 0644
ndb_index.test File 11.9 KB 0644
ndb_index_ordered.test File 15.46 KB 0644
ndb_index_stat.test File 9.91 KB 0644
ndb_index_stat_enable.inc File 1.18 KB 0644
ndb_index_unique.test File 14.63 KB 0644
ndb_init_schema_locks_count.inc File 226 B 0644
ndb_insert.test File 36.32 KB 0644
ndb_join_pushdown.test File 110.53 KB 0644
ndb_jtie.test File 990 B 0644
ndb_limit.test File 2.25 KB 0644
ndb_load.test File 2.12 KB 0644
ndb_loaddatalocal.test File 2.43 KB 0644
ndb_lock.test File 5.69 KB 0644
ndb_lock_table.test File 284 B 0644
ndb_mgm.inc File 130 B 0644
ndb_mgm.test File 3.38 KB 0644
ndb_minmax.test File 1.28 KB 0644
ndb_multi.test File 5.79 KB 0644
ndb_multi_row.test File 1.78 KB 0644
ndb_native_default_support.test File 25.47 KB 0644
ndb_optimize_table.test File 2.44 KB 0644
ndb_optimized_node_selection.test File 908 B 0644
ndb_partition_error.test File 1.83 KB 0644
ndb_partition_error2.test File 369 B 0644
ndb_partition_hash.test File 1.53 KB 0644
ndb_partition_key.test File 6.85 KB 0644
ndb_partition_list.test File 2.67 KB 0644
ndb_partition_range.test File 7.91 KB 0644
ndb_read_multi_range.test File 14.6 KB 0644
ndb_reconnect.test File 1.76 KB 0644
ndb_rename.test File 858 B 0644
ndb_replace.test File 3.95 KB 0644
ndb_restart_nostart.inc File 147 B 0644
ndb_restart_start.inc File 130 B 0644
ndb_restore_compat_compression-master.opt File 46 B 0644
ndb_restore_compat_compression.test File 589 B 0644
ndb_restore_compat_downward.test File 3.99 KB 0644
ndb_restore_compat_endianness.test File 6.68 KB 0644
ndb_restore_conv_lossy_charbinary.test File 16.86 KB 0644
ndb_restore_conv_lossy_integral.test File 22.53 KB 0644
ndb_restore_conv_padding.test File 9.09 KB 0644
ndb_restore_conv_promotion.test File 12.71 KB 0644
ndb_restore_discover.test File 1.72 KB 0644
ndb_restore_misc.test File 23.18 KB 0644
ndb_restore_print.test File 6.82 KB 0644
ndb_restore_schema_blobs.test File 4.26 KB 0644
ndb_restore_schema_partitions.test File 14.93 KB 0644
ndb_restore_schema_rewrites.test File 16.26 KB 0644
ndb_restore_schema_subsets.test File 10.97 KB 0644
ndb_restore_schema_tolerance.test File 6.55 KB 0644
ndb_restore_undolog.test File 16.53 KB 0644
ndb_row_count.test File 2.95 KB 0644
ndb_row_format.test File 1.89 KB 0644
ndb_schema_locks_count.inc File 209 B 0644
ndb_select_count.test File 364 B 0644
ndb_share.cnf File 652 B 0644
ndb_share.test File 9.38 KB 0644
ndb_short_sigs.cnf File 170 B 0644
ndb_short_sigs.test File 2.5 KB 0644
ndb_show_tables_result.inc File 563 B 0644
ndb_single_user-master.opt File 32 B 0644
ndb_single_user.test File 4.76 KB 0644
ndb_sp.test File 909 B 0644
ndb_sql_allow_batching.test File 1.12 KB 0644
ndb_statistics.inc File 3.33 KB 0644
ndb_statistics0.test File 232 B 0644
ndb_statistics1.test File 231 B 0644
ndb_subquery.test File 2.53 KB 0644
ndb_temporary.test File 1.08 KB 0644
ndb_tmp_table_and_DDL.test File 393 B 0644
ndb_transaction.test File 5.76 KB 0644
ndb_trigger.test File 8.77 KB 0644
ndb_truncate.test File 794 B 0644
ndb_types.test File 2.69 KB 0644
ndb_update.test File 2.74 KB 0644
ndb_update_no_read.test File 16.91 KB 0644
ndb_view.test File 607 B 0644
ndb_wait_nostart.inc File 103 B 0644
ndb_wait_started.inc File 84 B 0644
ndb_waiter.inc File 148 B 0644
ndbapi.test File 1.98 KB 0644
ndbinfo.test File 6.85 KB 0644
ndbinfo_cache.test File 794 B 0644
ndbinfo_create.inc File 387 B 0644
ndbinfo_drop.inc File 127 B 0644
ndbinfo_dump.test File 626 B 0644
ps_7ndb.test File 898 B 0644
show_attributes.inc File 664 B 0644
show_primary_keys.inc File 609 B 0644
show_varpart.inc File 762 B 0644
strict_autoinc_5ndb.test File 146 B 0644
test_mgmd.cnf File 232 B 0644
test_mgmd.test File 195 B 0644
test_ndbinfo.test File 229 B 0644