[ Avaa Bypassed ]

Upload:

Command:

hmhc3928@18.119.110.76: ~ $ 
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` tinyint(4) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 1 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` smallint(6) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 1 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` mediumint(9) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 1 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 1 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 1 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` bigint(20) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 1 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` tinyint(4) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 1 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` smallint(6) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 1 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` mediumint(9) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 1 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 1 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 1 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 1;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` bigint(20) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 1 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` tinyint(4) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 2 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` smallint(6) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 2 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` mediumint(9) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 2 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 2 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 2 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` bigint(20) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 2 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` tinyint(4) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 2 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` smallint(6) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 2 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` mediumint(9) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 2 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 2 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 2 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 2;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` bigint(20) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 2 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` tinyint(4) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 3 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` smallint(6) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 3 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` mediumint(9) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 3 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 3 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 3 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` bigint(20) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 3 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` tinyint(4) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 3 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` smallint(6) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 3 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` mediumint(9) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 3 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 3 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 3 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 3;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` bigint(20) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 3 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` tinyint(4) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 4 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` smallint(6) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 4 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` mediumint(9) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 4 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 4 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 4 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` bigint(20) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 4 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` tinyint(4) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 4 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` smallint(6) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 4 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` mediumint(9) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 4 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 4 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 4 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 4;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` bigint(20) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 4 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` tinyint(4) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 5 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` smallint(6) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 5 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` mediumint(9) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 5 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 5 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 5 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` bigint(20) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 5 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` tinyint(4) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 5 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` smallint(6) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 5 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` mediumint(9) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 5 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 5 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 5 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 5;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` bigint(20) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 5 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` tinyint(4) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 10 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` smallint(6) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 10 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` mediumint(9) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 10 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 10 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 10 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` bigint(20) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 10 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` tinyint(4) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 10 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` smallint(6) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 10 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` mediumint(9) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 10 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 10 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 10 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 10;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` bigint(20) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 10 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 TINYINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` tinyint(4) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 50 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 SMALLINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` smallint(6) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 50 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 MEDIUMINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` mediumint(9) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 50 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 50 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INTEGER NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 50 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 BIGINT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` bigint(20) DEFAULT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 50 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 TINYINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` tinyint(4) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 50 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 SMALLINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` smallint(6) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 50 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 MEDIUMINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` mediumint(9) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 50 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 50 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 INTEGER NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 50 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test
CREATE TABLE t1 (c1 BIGINT NOT NULL, c2 CHAR(5)) PARTITION BY HASH(c1) PARTITIONS 50;
SHOW TABLES;
Tables_in_test
t1
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `c1` bigint(20) NOT NULL,
  `c2` char(5) DEFAULT NULL
) ENGINE=ENGINE DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (c1)
PARTITIONS 50 */
DROP TABLE t1;
SHOW TABLES;
Tables_in_test

Filemanager

DIR : / usr/ share/ mysql-test/ suite/ engines/ funcs/ r/
Name Type Size Permission Actions
ai_init_alter_table.result File 26.39 KB 0644
ai_init_create_table.result File 25.45 KB 0644
ai_init_insert.result File 79.08 KB 0644
ai_init_insert_id.result File 24.51 KB 0644
ai_overflow_error.result File 34.23 KB 0644
ai_reset_by_truncate.result File 52.33 KB 0644
ai_sql_auto_is_null.result File 13.71 KB 0644
an_calendar.result File 1.15 KB 0644
an_number.result File 2.65 KB 0644
an_string.result File 1.36 KB 0644
comment_column.result File 132.93 KB 0644
comment_column2.result File 355.68 KB 0644
comment_index.result File 173.03 KB 0644
comment_table.result File 28.72 KB 0644
crash_manycolumns_number.result File 22.36 KB 0644
crash_manycolumns_string.result File 26.27 KB 0644
crash_manyindexes_number.result File 12.41 KB 0644
crash_manyindexes_string.result File 14.17 KB 0644
crash_manytables_number.result File 76.92 KB 0644
crash_manytables_string.result File 82.78 KB 0644
date_function.result File 16.65 KB 0644
datetime_function.result File 1.36 KB 0644
db_alter_character_set.result File 18.94 KB 0644
db_alter_character_set_collate.result File 5.6 KB 0644
db_alter_collate_ascii.result File 13.92 KB 0644
db_alter_collate_utf8.result File 81.43 KB 0644
db_create_character_set.result File 4.47 KB 0644
db_create_character_set_collate.result File 2.87 KB 0644
db_create_drop.result File 546 B 0644
db_create_error.result File 302 B 0644
db_create_error_reserved.result File 239 B 0644
db_create_if_not_exists.result File 664 B 0644
db_drop_error.result File 311 B 0644
db_use_error.result File 419 B 0644
de_autoinc.result File 2.57 KB 0644
de_calendar_range.result File 2.65 KB 0644
de_ignore.result File 2.96 KB 0644
de_limit.result File 1.79 KB 0644
de_multi_db_table.result File 25.11 KB 0644
de_multi_db_table_using.result File 25.3 KB 0644
de_multi_table.result File 20.67 KB 0644
de_multi_table_using.result File 20.86 KB 0644
de_number_range.result File 55.42 KB 0644
de_quick.result File 2.95 KB 0644
de_string_range.result File 19.37 KB 0644
de_truncate.result File 1.44 KB 0644
de_truncate_autoinc.result File 3.29 KB 0644
fu_aggregate_avg_number.result File 94.1 KB 0644
fu_aggregate_count_number.result File 93.15 KB 0644
fu_aggregate_max_number.result File 92.93 KB 0644
fu_aggregate_max_subquery.result File 3.11 KB 0644
fu_aggregate_min_number.result File 92.93 KB 0644
fu_aggregate_sum_number.result File 93.13 KB 0644
general_no_data.result File 11.09 KB 0644
general_not_null.result File 15.61 KB 0644
general_null.result File 16.8 KB 0644
in_calendar_2_unique_constraints_duplicate_update.result File 6.22 KB 0644
in_calendar_pk_constraint_duplicate_update.result File 2.46 KB 0644
in_calendar_pk_constraint_error.result File 2.47 KB 0644
in_calendar_pk_constraint_ignore.result File 2.47 KB 0644
in_calendar_unique_constraint_duplicate_update.result File 2.39 KB 0644
in_calendar_unique_constraint_error.result File 2.36 KB 0644
in_calendar_unique_constraint_ignore.result File 2.05 KB 0644
in_enum_null.result File 712 B 0644
in_enum_null_boundary_error.result File 655 B 0644
in_enum_null_large_error.result File 32.62 KB 0644
in_insert_select.result File 2.2 KB 0644
in_insert_select_autoinc.result File 2.25 KB 0644
in_insert_select_unique_violation.result File 2.28 KB 0644
in_lob_boundary_error.result File 3.13 KB 0644
in_multicolumn_calendar_pk_constraint_duplicate_update.result File 7.29 KB 0644
in_multicolumn_calendar_pk_constraint_error.result File 6.83 KB 0644
in_multicolumn_calendar_pk_constraint_ignore.result File 6.83 KB 0644
in_multicolumn_calendar_unique_constraint_duplicate_update.result File 7.15 KB 0644
in_multicolumn_calendar_unique_constraint_error.result File 6.62 KB 0644
in_multicolumn_calendar_unique_constraint_ignore.result File 5.88 KB 0644
in_multicolumn_number_pk_constraint_duplicate_update.result File 7.29 KB 0644
in_multicolumn_number_pk_constraint_error.result File 11.25 KB 0644
in_multicolumn_number_pk_constraint_ignore.result File 11.25 KB 0644
in_multicolumn_number_unique_constraint_duplicate_update.result File 10.39 KB 0644
in_multicolumn_number_unique_constraint_error.result File 10.81 KB 0644
in_multicolumn_number_unique_constraint_ignore.result File 8.92 KB 0644
in_multicolumn_string_pk_constraint_duplicate_update.result File 4.14 KB 0644
in_multicolumn_string_pk_constraint_error.result File 4.23 KB 0644
in_multicolumn_string_pk_constraint_ignore.result File 3.67 KB 0644
in_multicolumn_string_unique_constraint_duplicate_update.result File 4.07 KB 0644
in_multicolumn_string_unique_constraint_error.result File 3.54 KB 0644
in_multicolumn_string_unique_constraint_ignore.result File 2.97 KB 0644
in_number_2_unique_constraints_duplicate_update.result File 7.69 KB 0644
in_number_boundary_error.result File 3.51 KB 0644
in_number_decimal_boundary_error.result File 2.61 KB 0644
in_number_length.result File 7.7 KB 0644
in_number_null.result File 2.72 KB 0644
in_number_pk_constraint_duplicate_update.result File 3.03 KB 0644
in_number_pk_constraint_error.result File 3.3 KB 0644
in_number_pk_constraint_ignore.result File 2.69 KB 0644
in_number_unique_constraint_duplicate_update.result File 2.9 KB 0644
in_number_unique_constraint_error.result File 3.11 KB 0644
in_number_unique_constraint_ignore.result File 2.56 KB 0644
in_set_null.result File 784 B 0644
in_set_null_boundary_error.result File 806 B 0644
in_set_null_large.result File 163.22 KB 0644
in_string_2_unique_constraints_duplicate_update.result File 2.75 KB 0644
in_string_boundary_error.result File 2.33 KB 0644
in_string_not_null.result File 3.62 KB 0644
in_string_null.result File 3.93 KB 0644
in_string_pk_constraint_duplicate_update.result File 1009 B 0644
in_string_pk_constraint_error.result File 1.04 KB 0644
in_string_pk_constraint_ignore.result File 877 B 0644
in_string_set_enum_fail.result File 1.07 KB 0644
in_string_unique_constraint_duplicate_update.result File 973 B 0644
in_string_unique_constraint_error.result File 1005 B 0644
in_string_unique_constraint_ignore.result File 841 B 0644
ix_drop.result File 154 B 0644
ix_drop_error.result File 186 B 0644
ix_index_decimals.result File 5.75 KB 0644
ix_index_lob.result File 4.55 KB 0644
ix_index_non_string.result File 8.99 KB 0644
ix_index_string.result File 2.31 KB 0644
ix_index_string_length.result File 2.37 KB 0644
ix_unique_decimals.result File 6.02 KB 0644
ix_unique_lob.result File 4.77 KB 0644
ix_unique_non_string.result File 9.42 KB 0644
ix_unique_string.result File 2.42 KB 0644
ix_unique_string_length.result File 2.48 KB 0644
ix_using_order.result File 2.43 KB 0644
jp_comment_column.result File 243.95 KB 0644
jp_comment_index.result File 327.04 KB 0644
jp_comment_older_compatibility1.result File 9.58 KB 0644
jp_comment_table.result File 52.13 KB 0644
ld_all_number_string_calendar_types.result File 659.48 KB 0644
ld_bit.result File 811 B 0644
ld_enum_set.result File 625 B 0644
ld_less_columns.result File 507 B 0644
ld_more_columns_truncated.result File 565 B 0644
ld_null.result File 872 B 0644
ld_quote.result File 495 B 0644
ld_simple.result File 602 B 0644
ld_starting.result File 624 B 0644
ld_unique_error1.result File 309 B 0644
ld_unique_error1_local.result File 852 B 0644
ld_unique_error2.result File 425 B 0644
ld_unique_error2_local.result File 938 B 0644
ld_unique_error3.result File 478 B 0644
ld_unique_error3_local.result File 894 B 0644
ps_number_length.result File 29.51 KB 0644
ps_number_null.result File 10.43 KB 0644
ps_string_not_null.result File 11.41 KB 0644
ps_string_null.result File 12.23 KB 0644
re_number_range.result File 67.44 KB 0644
re_number_range_set.result File 67.44 KB 0644
re_number_select.result File 427 B 0644
re_string_range.result File 22.98 KB 0644
re_string_range_set.result File 22.88 KB 0644
rpl000010.result File 305 B 0644
rpl000011.result File 291 B 0644
rpl000013.result File 600 B 0644
rpl000017.result File 512 B 0644
rpl_000015.result File 3.82 KB 0644
rpl_LD_INFILE.result File 1.33 KB 0644
rpl_REDIRECT.result File 529 B 0644
rpl_alter.result File 563 B 0644
rpl_alter_db.result File 238 B 0644
rpl_bit.result File 2.56 KB 0644
rpl_bit_npk.result File 3.32 KB 0644
rpl_change_master.result File 1.95 KB 0644
rpl_create_database.result File 1.62 KB 0644
rpl_do_grant.result File 3.65 KB 0644
rpl_drop.result File 260 B 0644
rpl_drop_db.result File 984 B 0644
rpl_dual_pos_advance.result File 450 B 0644
rpl_empty_master_crash.result File 334 B 0644
rpl_err_ignoredtable.result File 893 B 0644
rpl_flushlog_loop.result File 1.35 KB 0644
rpl_free_items.result File 230 B 0644
rpl_get_lock.result File 969 B 0644
rpl_ignore_grant.result File 1.48 KB 0644
rpl_ignore_revoke.result File 1.05 KB 0644
rpl_ignore_table_update.result File 695 B 0644
rpl_init_slave.result File 749 B 0644
rpl_insert.result File 460 B 0644
rpl_insert_select.result File 384 B 0644
rpl_loaddata2.result File 1.47 KB 0644
rpl_loaddata_m.result File 823 B 0644
rpl_loaddata_s.result File 423 B 0644
rpl_loaddatalocal.result File 833 B 0644
rpl_loadfile.result File 2.38 KB 0644
rpl_log_pos.result File 4.2 KB 0644
rpl_many_optimize.result File 276 B 0644
rpl_master_pos_wait.result File 677 B 0644
rpl_misc_functions.result File 981 B 0644
rpl_multi_delete.result File 411 B 0644
rpl_multi_delete2.result File 972 B 0644
rpl_multi_update4.result File 600 B 0644
rpl_ps.result File 710 B 0644
rpl_rbr_to_sbr.result File 1.18 KB 0644
rpl_relayspace.result File 422 B 0644
rpl_replicate_ignore_db.result File 575 B 0644
rpl_row_NOW.result File 865 B 0644
rpl_row_USER.result File 1.1 KB 0644
rpl_row_drop.result File 1.3 KB 0644
rpl_row_func001.result File 510 B 0644
rpl_row_inexist_tbl.result File 1.37 KB 0644
rpl_row_max_relay_size.result File 1.62 KB 0644
rpl_row_reset_slave.result File 961 B 0644
rpl_row_sp001.result File 1.42 KB 0644
rpl_row_sp005.result File 2.13 KB 0644
rpl_row_sp008.result File 742 B 0644
rpl_row_sp009.result File 1.42 KB 0644
rpl_row_sp010.result File 1.17 KB 0644
rpl_row_sp011.result File 1.87 KB 0644
rpl_row_sp012.result File 1.56 KB 0644
rpl_row_stop_middle.result File 881 B 0644
rpl_row_trig001.result File 1.01 KB 0644
rpl_row_trig002.result File 2.31 KB 0644
rpl_row_trig003.result File 3.82 KB 0644
rpl_row_until.result File 2.98 KB 0644
rpl_row_view01.result File 2.71 KB 0644
rpl_server_id1.result File 1.22 KB 0644
rpl_server_id2.result File 1.21 KB 0644
rpl_session_var.result File 1.1 KB 0644
rpl_sf.result File 1016 B 0644
rpl_skip_error.result File 333 B 0644
rpl_slave_status.result File 1.25 KB 0644
rpl_sp.result File 10.08 KB 0644
rpl_sp004.result File 1.54 KB 0644
rpl_sp_effects.result File 3.37 KB 0644
rpl_start_stop_slave.result File 259 B 0644
rpl_stm_max_relay_size.result File 1.62 KB 0644
rpl_stm_mystery22.result File 666 B 0644
rpl_stm_no_op.result File 1.08 KB 0644
rpl_stm_reset_slave.result File 961 B 0644
rpl_switch_stm_row_mixed.result File 10.71 KB 0644
rpl_temp_table.result File 949 B 0644
rpl_temporary.result File 3.27 KB 0644
rpl_trigger.result File 18.94 KB 0644
rpl_trunc_temp.result File 592 B 0644
rpl_user_variables.result File 1.31 KB 0644
rpl_variables.result File 762 B 0644
rpl_view.result File 1.88 KB 0644
se_join_cross.result File 156.52 KB 0644
se_join_default.result File 139.55 KB 0644
se_join_inner.result File 156.52 KB 0644
se_join_left.result File 194.09 KB 0644
se_join_left_outer.result File 167.84 KB 0644
se_join_natural_left.result File 161.89 KB 0644
se_join_natural_left_outer.result File 164.35 KB 0644
se_join_natural_right.result File 140.44 KB 0644
se_join_natural_right_outer.result File 142.9 KB 0644
se_join_right.result File 143.93 KB 0644
se_join_right_outer.result File 146.39 KB 0644
se_join_straight.result File 143.19 KB 0644
se_rowid.result File 1.17 KB 0644
se_string_distinct.result File 289.73 KB 0644
se_string_from.result File 242.65 KB 0644
se_string_groupby.result File 272.91 KB 0644
se_string_having.result File 1.04 MB 0644
se_string_limit.result File 721 KB 0644
se_string_orderby.result File 244.55 KB 0644
se_string_union.result File 347.99 KB 0644
se_string_where.result File 226.87 KB 0644
se_string_where_and.result File 225.35 KB 0644
se_string_where_or.result File 225.35 KB 0644
sf_alter.result File 98.76 KB 0644
sf_cursor.result File 1.64 KB 0644
sf_simple1.result File 119.73 KB 0644
sp_alter.result File 58.51 KB 0644
sp_cursor.result File 986 B 0644
sp_simple1.result File 62.43 KB 0644
sq_all.result File 2.45 KB 0644
sq_any.result File 2.58 KB 0644
sq_corr.result File 1.66 KB 0644
sq_error.result File 3.27 KB 0644
sq_exists.result File 2.4 KB 0644
sq_from.result File 2.58 KB 0644
sq_in.result File 1.79 KB 0644
sq_row.result File 2.17 KB 0644
sq_scalar.result File 3.14 KB 0644
sq_some.result File 2.6 KB 0644
ta_2part_column_to_pk.result File 8.58 KB 0644
ta_2part_diff_string_to_pk.result File 11.12 KB 0644
ta_2part_diff_to_pk.result File 176.13 KB 0644
ta_2part_string_to_pk.result File 2.2 KB 0644
ta_3part_column_to_pk.result File 9.89 KB 0644
ta_3part_string_to_pk.result File 2.51 KB 0644
ta_add_column.result File 521.65 KB 0644
ta_add_column2.result File 89.06 KB 0644
ta_add_column_first.result File 504.81 KB 0644
ta_add_column_first2.result File 90.18 KB 0644
ta_add_column_middle.result File 750.4 KB 0644
ta_add_column_middle2.result File 129.09 KB 0644
ta_add_string.result File 15.13 KB 0644
ta_add_string2.result File 88.02 KB 0644
ta_add_string_first.result File 15.29 KB 0644
ta_add_string_first2.result File 89.15 KB 0644
ta_add_string_middle.result File 21.84 KB 0644
ta_add_string_middle2.result File 86.44 KB 0644
ta_add_string_unique_index.result File 33.92 KB 0644
ta_add_unique_index.result File 134.83 KB 0644
ta_column_from_unsigned.result File 19.89 KB 0644
ta_column_from_zerofill.result File 41.85 KB 0644
ta_column_to_index.result File 88.58 KB 0644
ta_column_to_not_null.result File 20.66 KB 0644
ta_column_to_null.result File 20.66 KB 0644
ta_column_to_pk.result File 7.27 KB 0644
ta_column_to_unsigned.result File 19.89 KB 0644
ta_column_to_zerofill.result File 41.85 KB 0644
ta_drop_column.result File 17.41 KB 0644
ta_drop_index.result File 43.88 KB 0644
ta_drop_pk_autoincrement.result File 6.21 KB 0644
ta_drop_pk_number.result File 7.4 KB 0644
ta_drop_pk_string.result File 1.88 KB 0644
ta_drop_string_index.result File 11.05 KB 0644
ta_orderby.result File 3.81 KB 0644
ta_rename.result File 17.48 KB 0644
ta_set_drop_default.result File 20.8 KB 0644
ta_string_drop_column.result File 4.43 KB 0644
ta_string_to_index.result File 22.29 KB 0644
ta_string_to_not_null.result File 3.61 KB 0644
ta_string_to_null.result File 3.61 KB 0644
ta_string_to_pk.result File 1.85 KB 0644
tc_column_autoincrement.result File 1.81 KB 0644
tc_column_comment.result File 8.38 KB 0644
tc_column_comment_string.result File 1.25 KB 0644
tc_column_default_decimal.result File 4.33 KB 0644
tc_column_default_number.result File 3.13 KB 0644
tc_column_default_string.result File 2.17 KB 0644
tc_column_enum.result File 543 B 0644
tc_column_enum_long.result File 142.83 KB 0644
tc_column_key.result File 5.27 KB 0644
tc_column_key_length.result File 1.09 KB 0644
tc_column_length.result File 5.25 KB 0644
tc_column_length_decimals.result File 3.92 KB 0644
tc_column_length_zero.result File 993 B 0644
tc_column_not_null.result File 6.63 KB 0644
tc_column_null.result File 6.49 KB 0644
tc_column_primary_key_number.result File 5.42 KB 0644
tc_column_primary_key_string.result File 1.12 KB 0644
tc_column_serial.result File 307 B 0644
tc_column_set.result File 539 B 0644
tc_column_set_long.result File 142.82 KB 0644
tc_column_unique_key.result File 5.48 KB 0644
tc_column_unique_key_string.result File 1.13 KB 0644
tc_column_unsigned.result File 7.11 KB 0644
tc_column_zerofill.result File 14.99 KB 0644
tc_drop_table.result File 2.84 KB 0644
tc_multicolumn_different.result File 1.12 MB 0644
tc_multicolumn_same.result File 9.84 KB 0644
tc_multicolumn_same_string.result File 2.08 KB 0644
tc_partition_analyze.result File 1.78 KB 0644
tc_partition_change_from_range_to_hash_key.result File 14.17 KB 0644
tc_partition_check.result File 1.77 KB 0644
tc_partition_hash.result File 30.11 KB 0644
tc_partition_hash_date_function.result File 18.62 KB 0644
tc_partition_key.result File 17.12 KB 0644
tc_partition_linear_key.result File 17.77 KB 0644
tc_partition_list_directory.result File 1.52 KB 0644
tc_partition_list_error.result File 2.68 KB 0644
tc_partition_optimize.result File 1.73 KB 0644
tc_partition_rebuild.result File 1.73 KB 0644
tc_partition_remove.result File 9.7 KB 0644
tc_partition_reorg_divide.result File 13.49 KB 0644
tc_partition_reorg_hash_key.result File 26.7 KB 0644
tc_partition_reorg_merge.result File 11.57 KB 0644
tc_partition_repair.result File 1.72 KB 0644
tc_partition_sub1.result File 9.94 KB 0644
tc_partition_sub2.result File 11.35 KB 0644
tc_partition_value.result File 4.42 KB 0644
tc_partition_value_error.result File 2.97 KB 0644
tc_partition_value_specific.result File 3.73 KB 0644
tc_rename.result File 452 B 0644
tc_rename_across_database.result File 836 B 0644
tc_rename_error.result File 863 B 0644
tc_structure_comment.result File 7.84 KB 0644
tc_structure_create_like.result File 9.9 KB 0644
tc_structure_create_like_string.result File 1.65 KB 0644
tc_structure_create_select.result File 20.67 KB 0644
tc_structure_create_select_string.result File 3.4 KB 0644
tc_structure_string_comment.result File 1.32 KB 0644
tc_temporary_column.result File 14.03 KB 0644
tc_temporary_column_length.result File 5.66 KB 0644
time_function.result File 317 B 0644
tr_all_type_triggers.result File 35.7 KB 0644
tr_delete.result File 26.62 KB 0644
tr_delete_new_error.result File 26.02 KB 0644
tr_insert.result File 20.18 KB 0644
tr_insert_after_error.result File 13.07 KB 0644
tr_insert_old_error.result File 13.04 KB 0644
tr_update.result File 20.2 KB 0644
tr_update_after_error.result File 13.18 KB 0644
up_calendar_range.result File 2.92 KB 0644
up_ignore.result File 3.78 KB 0644
up_limit.result File 1.98 KB 0644
up_multi_db_table.result File 10.18 KB 0644
up_multi_table.result File 8.08 KB 0644
up_nullcheck.result File 1.94 KB 0644
up_number_range.result File 65.49 KB 0644
up_string_range.result File 22.13 KB 0644