WARNINGS;

CREATE TABLE test (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data VARCHAR(64)
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = MyISAM;

INSERT INTO test VALUES (NULL, 'short', NULL);
INSERT INTO test SELECT NULL, 'short', NULL FROM test;
INSERT INTO test SELECT NULL, 'short', NULL FROM test;
INSERT INTO test SELECT NULL, 'short', NULL FROM test;
INSERT INTO test SELECT NULL, 'short', NULL FROM test;
INSERT INTO test SELECT NULL, 'short', NULL FROM test;
INSERT INTO test SELECT NULL, 'short', NULL FROM test;
INSERT INTO test SELECT NULL, 'short', NULL FROM test;
INSERT INTO test SELECT NULL, 'short', NULL FROM test;
INSERT INTO test SELECT NULL, 'short', NULL FROM test;
INSERT INTO test SELECT NULL, 'short', NULL FROM test;
INSERT INTO test SELECT NULL, 'short', NULL FROM test;
INSERT INTO test SELECT NULL, 'short', NULL FROM test;
INSERT INTO test SELECT NULL, 'short', NULL FROM test;
INSERT INTO test SELECT NULL, 'short', NULL FROM test;
INSERT INTO test SELECT NULL, 'short', NULL FROM test;
INSERT INTO test SELECT NULL, 'short', NULL FROM test;
INSERT INTO test SELECT NULL, 'short', NULL FROM test;
INSERT INTO test SELECT NULL, 'short', NULL FROM test;
INSERT INTO test SELECT NULL, 'short', NULL FROM test;

SELECT COUNT(*) FROM test;

----

CREATE TABLE t_myisam_varchar (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data VARCHAR(64)
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = MyISAM;

INSERT INTO t_myisam_varchar SELECT * FROM test;

CREATE TABLE t_myisam_varcharlong (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data VARCHAR(64000)
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = MyISAM;

INSERT INTO t_myisam_varcharlong SELECT * FROM test;

CREATE TABLE t_myisam_char (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data CHAR(64)
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = MyISAM;

INSERT INTO t_myisam_char SELECT * FROM test;

CREATE TABLE t_myisam_tinytext (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data TINYTEXT
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = MyISAM;

INSERT INTO t_myisam_tinytext SELECT * FROM test;

CREATE TABLE t_myisam_smalltext (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data TEXT
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = MyISAM;

INSERT INTO t_myisam_smalltext SELECT * FROM test;

CREATE TABLE t_myisam_mediumtext (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data MEDIUMTEXT
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = MyISAM;

INSERT INTO t_myisam_mediumtext SELECT * FROM test;

CREATE TABLE t_myisam_longtext (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data LONGTEXT
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = MyISAM;

INSERT INTO t_myisam_longtext SELECT * FROM test;

--

CREATE TABLE t_innodb_varchar (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data VARCHAR(64)
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = InnoDB;

INSERT INTO t_innodb_varchar SELECT * FROM test;


CREATE TABLE t_innodb_varcharlong (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data VARCHAR(64000)
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = InnoDB;

INSERT INTO t_innodb_varcharlong SELECT * FROM test;


CREATE TABLE t_innodb_char (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data CHAR(64)
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = InnoDB;

INSERT INTO t_innodb_char SELECT * FROM test;

CREATE TABLE t_innodb_tinytext (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data TINYTEXT
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = InnoDB;

INSERT INTO t_innodb_tinytext SELECT * FROM test;

CREATE TABLE t_innodb_smalltext (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data TEXT
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = InnoDB;

INSERT INTO t_innodb_smalltext SELECT * FROM test;

CREATE TABLE t_innodb_mediumtext (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data MEDIUMTEXT
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = InnoDB;

INSERT INTO t_innodb_mediumtext SELECT * FROM test;

CREATE TABLE t_innodb_longtext (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data LONGTEXT
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = InnoDB;

INSERT INTO t_innodb_longtext SELECT * FROM test;

--

SET @OLD_MAX_HEAP_TABLE_SIZE=@@MAX_HEAP_TABLE_SIZE;
SET SESSION max_heap_table_size = 128*1024*1024;

CREATE TABLE t_memory_varchar (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data VARCHAR(64)
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = MEMORY;

INSERT INTO t_memory_varchar SELECT * FROM test;

CREATE TABLE t_memory_char (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data CHAR(64)
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = MEMORY;

INSERT INTO t_memory_char SELECT * FROM test;

SET SESSION max_heap_table_size = @OLD_MAX_HEAP_TABLE_SIZE;

--

CREATE TABLE t_pbxt_varchar (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data VARCHAR(64)
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = PBXT;

INSERT INTO t_pbxt_varchar SELECT * FROM test;


CREATE TABLE t_pbxt_varcharlong (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data VARCHAR(64000)
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = PBXT;

INSERT INTO t_pbxt_varcharlong SELECT * FROM test;


CREATE TABLE t_pbxt_char (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data CHAR(64)
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = PBXT;

INSERT INTO t_pbxt_char SELECT * FROM test;

CREATE TABLE t_pbxt_tinytext (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data TINYTEXT
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = PBXT;

INSERT INTO t_pbxt_tinytext SELECT * FROM test;

CREATE TABLE t_pbxt_smalltext (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data TEXT
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = PBXT;

INSERT INTO t_pbxt_smalltext SELECT * FROM test;

CREATE TABLE t_pbxt_mediumtext (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data MEDIUMTEXT
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = PBXT;

INSERT INTO t_pbxt_mediumtext SELECT * FROM test;

CREATE TABLE t_pbxt_longtext (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data LONGTEXT
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = PBXT;

INSERT INTO t_pbxt_longtext SELECT * FROM test;

--

CREATE TABLE t_pbxt_memory_varchar (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data VARCHAR(64)
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = PBXT STORAGE MEMORY;

INSERT INTO t_pbxt_memory_varchar SELECT * FROM test;


CREATE TABLE t_pbxt_memory_varcharlong (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data VARCHAR(64000)
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = PBXT STORAGE MEMORY;

INSERT INTO t_pbxt_memory_varcharlong SELECT * FROM test;


CREATE TABLE t_pbxt_memory_char (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data CHAR(64)
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = PBXT STORAGE MEMORY;

INSERT INTO t_pbxt_memory_char SELECT * FROM test;

CREATE TABLE t_pbxt_memory_tinytext (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data TINYTEXT
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = PBXT STORAGE MEMORY;

INSERT INTO t_pbxt_memory_tinytext SELECT * FROM test;

CREATE TABLE t_pbxt_memory_smalltext (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data TEXT
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = PBXT STORAGE MEMORY;

INSERT INTO t_pbxt_memory_smalltext SELECT * FROM test;

CREATE TABLE t_pbxt_memory_mediumtext (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data MEDIUMTEXT
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = PBXT STORAGE MEMORY;

INSERT INTO t_pbxt_memory_mediumtext SELECT * FROM test;

CREATE TABLE t_pbxt_memory_longtext (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, data LONGTEXT
, ts TIMESTAMP
, INDEX (ts)
) ENGINE = PBXT STORAGE MEMORY;

INSERT INTO t_pbxt_memory_longtext SELECT * FROM test;

SHOW TABLE STATUS;