DROP SCHEMA gts1; CREATE SCHEMA gts1; DROP SCHEMA gts2; CREATE SCHEMA gts2; DROP SCHEMA gts3; CREATE SCHEMA gts3; DROP SCHEMA gts4; CREATE SCHEMA gts4; DROP SCHEMA gts5; CREATE SCHEMA gts5; DROP SCHEMA gts6; CREATE SCHEMA gts6; DROP SCHEMA gts7; CREATE SCHEMA gts7; DROP SCHEMA gts8; CREATE SCHEMA gts8; CREATE TABLE gts1.tt1 (col1 bigint,col2 varchar(158) character set latin1 DEFAULT (col6),col3 float,col4 varchar(203) character set utf8mb4,col5 char(6) character set utf8mb4,col6 varchar(8)) AUTOEXTEND_SIZE=4M STATS_SAMPLE_PAGES=17; CREATE TABLE gts1.tt2 (col1 char(10) character set utf8mb4,col2 smallint,col3 varchar(8) character set utf8mb4,col4 varchar(1) character set latin1,col5 varchar(7) character set latin1,col6 char(3),col7 varchar(1) character set utf8mb4, PRIMARY KEY ind1 ( `col6`)) AUTOEXTEND_SIZE=16M STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=19 CHARACTER SET latin1; CREATE TABLE gts1.tt3 (col1 smallint,col2 blob,col3 char(10) character set latin1,col4 bigint, PRIMARY KEY ind1 ( `col3`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=38; CREATE TABLE gts1.tt4 (col1 timestamp DEFAULT (col3),col2 smallint,col3 varchar(9) character set latin1) STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1 CHARACTER SET latin1; CREATE TABLE gts1.tt5 (col1 varchar(10) character set utf8mb4,col2 varchar(9),col3 varchar(2),col4 varchar(3) character set utf8mb4 DEFAULT 'NOP',col5 bigint,col6 tinyint, PRIMARY KEY ind1 ( `col2`)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=7; CREATE TABLE gts1.tt6 (col1 bigint unique, PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=4M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=36; CREATE TABLE gts1.tt7 (col1 smallint,col2 timestamp(3),col3 float, PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col3`), KEY ind3 ( `col2`), KEY ind4 ( `col3`), KEY ind5 ( `col2`, `col3`)) AUTOEXTEND_SIZE=4M AUTO_INCREMENT=1870 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=33 CHARACTER SET latin1; CREATE TABLE gts1.tt8 (col1 text,col2 varchar(4) character set utf8mb4,col3 datetime(3), PRIMARY KEY ind1 ( `col1`(117)), KEY ind2 ( `col1`(418))) AUTOEXTEND_SIZE=8M STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=1 CHARACTER SET utf8mb4; CREATE TABLE gts1.tt9 (col1 tinyint,col2 char(5) character set utf8mb4 DEFAULT (HEX(RANDOM_BYTES(55))), PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPACT STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=36; CREATE TABLE gts1.tt10 (col1 varchar(235),col2 char(10),col3 varchar(3),col4 bigint, PRIMARY KEY ind1 ( `col2`)) AUTOEXTEND_SIZE=12M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=31 CHARACTER SET utf8mb4; CREATE TABLE gts1.tt11 (col1 varchar(2),col2 varchar(6) character set latin1,col3 longtext,col4 varchar(1) character set utf8mb4,col5 double, PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=28; CREATE TABLE gts1.tt12 (col1 varchar(6),col2 varchar(121),col3 datetime, PRIMARY KEY ind1 ( `col3`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=37; CREATE TABLE gts1.tt13 (col1 varchar(72) character set utf8mb4,col2 varchar(8) character set utf8mb4,col3 varchar(13),col4 char(8) character set utf8mb4,col5 float, PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col4`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 STATS_SAMPLE_PAGES=26 CHARACTER SET latin1; CREATE TABLE gts1.tt14 (col1 varchar(205),col2 bigint,col3 varchar(3),col4 int unsigned,col5 varchar(250),col6 varchar(2) character set utf8mb4,col7 longtext,col8 float DEFAULT (col5), PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col8`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=REDUNDANT STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=2; CREATE TABLE gts1.tt15 (col1 varchar(4),col2 varchar(150),col3 varchar(8), PRIMARY KEY ind1 ( `col3`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=9; CREATE TABLE gts1.tt16 (col1 varchar(7) DEFAULT (col2),col2 mediumint,col3 tinyint,col4 varchar(22) character set utf8mb4,col5 varchar(6), PRIMARY KEY ind1 ( `col3`)) STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=18 CHARACTER SET latin1; CREATE TABLE gts1.tt17 (col1 tinyint,col2 varchar(69) character set utf8mb4,col3 bigint DEFAULT (col1),col4 int,col5 char(2) DEFAULT (HEX(RANDOM_BYTES(55))),col6 tinyint,col7 smallint, PRIMARY KEY ind1 ( `col4`), UNIQUE KEY ind2 ( `col6`)) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 STATS_SAMPLE_PAGES=21 CHARACTER SET utf8mb4; CREATE TABLE gts1.tt18 (col1 double DEFAULT -0.185566731522258,col2 decimal(7,1),col3 tinyblob,col4 smallint,col5 smallint,col6 varchar(9) character set utf8mb4 DEFAULT (HEX(RANDOM_BYTES(55))), PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col4`)) ROW_FORMAT=DYNAMIC COMPRESSION='NONE' STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=5; CREATE TABLE gts1.tt19 (col1 float,col2 longtext,col3 varchar(4) character set latin1,col4 smallint,col5 varchar(9),col6 varchar(2) character set utf8mb4 DEFAULT (HEX(RANDOM_BYTES(55))), PRIMARY KEY ind1 ( `col4` desc), UNIQUE KEY ind2 ( `col5`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=7; CREATE TABLE gts1.tt20 (col1 varchar(7) character set latin1 DEFAULT 'EFGH59A',col2 varchar(72),col3 timestamp(0), PRIMARY KEY ind1 ( `col2`), UNIQUE KEY ind2 ( `col3`, `col1`)) ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1; CREATE TABLE gts1.tt21 (col1 float,col2 varchar(9) character set utf8mb4,col3 varchar(8) character set latin1 DEFAULT 'TOXYZ01Z', PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 CHARACTER SET utf8mb4; CREATE TABLE gts1.tt22 (col1 varchar(2) character set latin1, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`)) AUTOEXTEND_SIZE=4M STATS_SAMPLE_PAGES=4; CREATE TABLE gts1.tt23 (col1 varchar(1) character set latin1,col2 varchar(6) character set latin1, PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col1`), KEY ind3 ( `col1`), KEY ind4 ( `col1`, `col2`), KEY ind5 ( `col1`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=DYNAMIC STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=11; CREATE TABLE gts1.tt24 (col1 timestamp DEFAULT '2026-09-23 05:35:43.000000',col2 varchar(2),col3 varchar(1), PRIMARY KEY ind1 ( `col3`), KEY ind2 ( `col2`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=34; CREATE TABLE gts1.tt25 (col1 varchar(61),col2 char(210) character set utf8mb4,col3 char(225) character set latin1,col4 smallint,col5 float,col6 varchar(8),col7 tinyblob, PRIMARY KEY ind1 ( `col6`), KEY ind2 ( `col7`(649), `col6`), KEY ind3 ( `col7`(67)), KEY ind4 ( `col6`)) AUTOEXTEND_SIZE=4M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=14 CHARACTER SET utf8mb4; CREATE TABLE gts1.tt26 (col1 float,col2 smallint,col3 char(6) character set utf8mb4,col4 varchar(58), PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col4`)) STATS_PERSISTENT=1 CHARACTER SET latin1; CREATE TABLE gts1.tt27 (col1 char(9)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=9; CREATE TABLE gts1.tt28 (col1 varchar(6),col2 int,col3 float,col4 varchar(100) character set latin1,col5 datetime,col6 bigint auto_increment PRIMARY KEY,col7 varchar(240),col8 char(7), KEY ind1 ( `col3`), UNIQUE KEY ind2 ( `col3`)) AUTOEXTEND_SIZE=4M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=29 CHARACTER SET utf8mb4; CREATE TABLE gts1.tt29 (col1 varchar(63) character set latin1 DEFAULT 'ldeabcde3GHIjkYZ012XgXlm67bNOPQWXY3456bcdepqr4567rcdefgmn5abcdZ',col2 varchar(149) character set utf8mb4,col3 decimal(5,4), PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=20M ROW_FORMAT=DYNAMIC STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=17; CREATE TABLE gts1.tt30 (col1 tinyint,col2 varchar(3) character set latin1,col3 varchar(8), PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`)) AUTOEXTEND_SIZE=4M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=5; CREATE TABLE gts1.tt31 (col1 decimal(65,3) DEFAULT (col2),col2 bigint,col3 varchar(99) character set utf8mb4,col4 float, PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col4`)) ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=16; CREATE TABLE gts1.tt32 (col1 char(4),col2 varchar(8),col3 int,col4 char(2) character set latin1, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col2`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=27; CREATE TABLE gts1.tt33 (col1 float,col2 varchar(27) character set utf8mb4 DEFAULT (HEX(RANDOM_BYTES(55))),col3 int,col4 float,col5 smallint,col6 tinyint DEFAULT (col1),col7 decimal(7,0), PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=16M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=37; CREATE TABLE gts2.tt1 (col1 char(1) character set latin1,col2 varchar(2) character set latin1,col3 varchar(1) character set latin1,col4 varchar(25),col5 smallint,col6 tinyint unsigned, PRIMARY KEY ind1 ( `col4`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=DYNAMIC STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=4; CREATE TABLE gts2.tt2 (col1 varchar(239) character set utf8mb4,col2 varchar(61) DEFAULT (col3),col3 bigint,col4 float) ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1; CREATE TABLE gts2.tt3 (col1 varchar(220) character set latin1 DEFAULT (HEX(RANDOM_BYTES(55))), PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`), KEY ind3 ( `col1`), KEY ind4 ( `col1`)) STATS_SAMPLE_PAGES=19; CREATE TABLE gts2.tt4 (col1 char(207) character set latin1 unique DEFAULT (col2),col2 varchar(19),col3 tinyint,col4 varchar(68) character set utf8mb4, PRIMARY KEY ind1 ( `col3`), KEY ind2 ( `col2`)) AUTOEXTEND_SIZE=4M STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=16 CHARACTER SET latin1; CREATE TABLE gts2.tt5 (col1 timestamp,col2 mediumint,col3 varchar(10),col4 varchar(117),col5 double,col6 varchar(1),col7 int, PRIMARY KEY ind1 ( `col3`), KEY ind2 ( `col1`), KEY ind3 ( `col4`), KEY ind4 ( `col7`), KEY ind5 ( `col4`)) AUTOEXTEND_SIZE=16M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=38; CREATE TABLE gts2.tt6 (col1 varchar(3) character set utf8mb4,col2 varchar(10) character set latin1,col3 varchar(7) character set utf8mb4, PRIMARY KEY ind1 ( `col2`)) AUTO_INCREMENT=7 STATS_PERSISTENT=1; CREATE TABLE gts2.tt7 (col1 smallint,col2 smallint unsigned,col3 varchar(10),col4 varchar(28), PRIMARY KEY ind1 ( `col3`), KEY ind2 ( `col2`, `col3`)) AUTOEXTEND_SIZE=4M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1; CREATE TABLE gts2.tt8 (col1 varchar(3) character set utf8mb4,col2 float,col3 timestamp(5),col4 float, PRIMARY KEY ind1 ( `col4`), KEY ind2 ( `col2`)) ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=6; CREATE TABLE gts2.tt9 (col1 char(10) character set latin1,col2 varchar(3) character set utf8mb4, PRIMARY KEY ind1 ( `col2`, `col1`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=17; CREATE TABLE gts2.tt10 (col1 char(10) character set latin1,col2 varchar(2),col3 mediumtext,col4 varchar(207) character set latin1,col5 char(8) character set utf8mb4 DEFAULT (HEX(RANDOM_BYTES(55))),col6 tinyint,col7 char(6),col8 smallint unsigned, PRIMARY KEY ind1 ( `col6`), KEY ind2 ( `col6`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=DYNAMIC STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1 CHARACTER SET latin1; CREATE TABLE gts2.tt11 (col1 bigint,col2 varchar(4),col3 int) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=10; CREATE TABLE gts2.tt12 (col1 varchar(78) character set utf8mb4 DEFAULT (col23),col2 varchar(238) character set utf8mb4,col3 smallint,col4 char(9),col5 varchar(172) character set latin1,col6 smallint,col7 varchar(8) character set utf8mb4,col8 float,col9 char(2) character set utf8mb4,col10 varchar(243),col11 varchar(5),col12 float,col13 char(10),col14 bigint,col15 float,col16 longtext,col17 varchar(6) character set utf8mb4,col18 float,col19 smallint,col20 varchar(10) character set utf8mb4,col21 json not null,col22 varchar(8) character set latin1,col23 varchar(3) character set utf8mb4,col24 char(10) character set utf8mb4 unique,col25 varchar(9),col26 varchar(44) character set utf8mb4,col27 varchar(35) character set latin1,col28 varchar(226),col29 varchar(73),col30 varchar(33) character set latin1,col31 int,col32 tinyint DEFAULT (col11),col33 float,col34 varchar(3),col35 varchar(106), PRIMARY KEY ind1 ( `col25`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=REDUNDANT COMPRESSION='LZ4' STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=17; CREATE TABLE gts2.tt13 (col1 char(8) character set utf8mb4 DEFAULT (HEX(RANDOM_BYTES(55))),col2 int,col3 char(4) character set utf8mb4,col4 char(26) character set latin1,col5 varchar(247),col6 varchar(9) character set utf8mb4 DEFAULT (HEX(RANDOM_BYTES(55))),col7 datetime(3),col8 smallint, PRIMARY KEY ind1 ( `col7`), KEY ind2 ( `col5`)) AUTOEXTEND_SIZE=12M STATS_AUTO_RECALC=1 STATS_PERSISTENT=0 STATS_SAMPLE_PAGES=36; CREATE TABLE gts2.tt14 (col1 char(6) character set latin1,col2 char(4) character set utf8mb4 DEFAULT (col18),col3 smallint,col4 varchar(76) DEFAULT 'FG0Mz01VWXUnopqs',col5 tinyint,col6 varchar(9) DEFAULT 'wx9ABCDKL',col7 smallint,col8 smallint,col9 varchar(250) character set utf8mb4,col10 bigint unsigned,col11 tinyint unsigned DEFAULT 116,col12 bigint,col13 double,col14 smallint,col15 longtext,col16 float,col17 float,col18 float,col19 float,col20 decimal(8),col21 float,col22 smallint,col23 float,col24 varchar(2),col25 varchar(7) DEFAULT (col24),col26 smallint,col27 float,col28 varchar(5) character set utf8mb4,col29 varchar(2) DEFAULT (col16),col30 varchar(50) character set latin1,col31 tinyint,col32 tinyint,col33 decimal(50,26), PRIMARY KEY ind1 ( `col7`), KEY ind2 ( `col11`)) ROW_FORMAT=DYNAMIC STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=26; CREATE TABLE gts2.tt15 (col1 longtext,col2 smallint,col3 bigint, PRIMARY KEY ind1 ( `col2`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=8 CHARACTER SET utf8mb4; CREATE TABLE gts2.tt16 (col1 timestamp,col2 smallint,col3 int,col4 timestamp(6), PRIMARY KEY ind1 ( `col4`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=12; CREATE TABLE gts2.tt17 (col1 blob, PRIMARY KEY ind1 ( `col1`(104)), KEY ind2 ( `col1`(703)), KEY ind3 ( `col1`(955))) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=3 CHARACTER SET utf8mb4; CREATE TABLE gts2.tt18 (col1 varchar(144),col2 char(7),col3 smallint,col4 bigint,col5 varchar(244) character set utf8mb4,col6 decimal(6,2),col7 date,col8 char(5),col9 timestamp(6) DEFAULT (LOCALTIME),col10 varchar(74) character set utf8mb4,col11 float,col12 varchar(4) character set utf8mb4,col13 tinyint,col14 varchar(166) character set latin1,col15 smallint unsigned,col16 float,col17 varchar(198) character set utf8mb4,col18 varchar(1) character set utf8mb4,col19 smallint,col20 int,col21 varchar(172) character set latin1,col22 smallint DEFAULT (col26),col23 varchar(10) character set latin1 DEFAULT '12CLMxyz0F',col24 tinytext,col25 varchar(103),col26 float,col27 varbinary(3),col28 smallint,col29 varchar(9),col30 tinyint,col31 mediumblob,col32 decimal(21,1),col33 bigint unsigned,col34 varchar(2) character set utf8mb4,col35 varchar(87) character set latin1, PRIMARY KEY ind1 ( `col11`)) AUTOEXTEND_SIZE=16M STATS_SAMPLE_PAGES=17; CREATE TABLE gts2.tt19 (col1 bigint,col2 datetime(4),col3 varchar(239),col4 smallint,col5 timestamp(4) unique, PRIMARY KEY ind1 ( `col4`), KEY ind2 ( `col2`) visible, KEY ind3 ( `col1`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=28; CREATE TABLE gts2.tt20 (col1 varchar(1) DEFAULT (col2),col2 int, PRIMARY KEY ind1 ( `col2` desc)) AUTOEXTEND_SIZE=12M ROW_FORMAT=DYNAMIC STATS_SAMPLE_PAGES=1 CHARACTER SET latin1; CREATE TABLE gts2.tt21 (col1 decimal(3)) AUTOEXTEND_SIZE=4M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=37 CHARACTER SET utf8mb4; CREATE TABLE gts2.tt22 (col1 smallint,col2 int DEFAULT (col1),col3 float, PRIMARY KEY ind1 ( `col3`, `col2`), UNIQUE KEY ind2 ( `col1`), KEY ind3 ( `col3`) visible) ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=38 CHARACTER SET latin1; CREATE TABLE gts2.tt23 (col1 mediumint,col2 varchar(3) character set latin1,col3 tinyint DEFAULT (RAND()*107),col4 float,col5 bigint,col6 smallint,col7 varchar(70),col8 float, PRIMARY KEY ind1 ( `col6`), KEY ind2 ( `col8`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=DYNAMIC COMPRESSION='LZ4' STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=27 CHARACTER SET utf8mb4; CREATE TABLE gts2.tt24 (col1 varchar(120) character set latin1 GENERATED ALWAYS AS (REGEXP_INSTR(col4,col4) ) virtual,col2 int GENERATED ALWAYS AS (CHAR(col3) ) stored,col3 mediumint unsigned,col4 varchar(2),col5 varchar(7),col6 mediumint,col7 varchar(23), PRIMARY KEY ind1 ( `col7`), KEY ind2 ( `col7`, `col6`), KEY ind3 ( `col5`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=DYNAMIC STATS_SAMPLE_PAGES=1; CREATE TABLE gts2.tt25 (col1 varchar(5) character set utf8mb4, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`)) ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=25; CREATE TABLE gts2.tt26 (col1 bigint,col2 float,col3 datetime(6),col4 varchar(17) character set utf8mb4, PRIMARY KEY ind1 ( `col3`), KEY ind2 ( `col4`), KEY ind3 ( `col1`), KEY ind4 ( `col4`), KEY ind5 ( `col4`)) AUTOEXTEND_SIZE=20M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1; CREATE TABLE gts2.tt27 (col1 float,col2 varchar(8),col3 varchar(64),col4 tinyblob,col5 varchar(3),col6 mediumblob,col7 json not null, PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col4`(103))) AUTOEXTEND_SIZE=12M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=40 CHARACTER SET utf8mb4; CREATE TABLE gts2.tt28 (col1 tinyblob, PRIMARY KEY ind1 ( `col1`(95)), KEY ind2 ( `col1`(3))) AUTOEXTEND_SIZE=8M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1; CREATE TABLE gts2.tt29 (col1 varchar(35),col2 varchar(3),col3 date,col4 float,col5 varchar(6) character set latin1,col6 tinyint,col7 tinyint DEFAULT (RAND()*107),col8 bigint,col9 varchar(92) DEFAULT '9ABCDYZ012STUV678RSTUg94a6rstnopqIcXYZ0def',col10 varchar(1),col11 smallint DEFAULT (col1),col12 bigint unsigned, PRIMARY KEY ind1 ( `col5`)) STATS_PERSISTENT=1; CREATE TABLE gts2.tt30 (col1 varchar(107),col2 varchar(135),col3 char(2),col4 varchar(201) character set latin1,col5 varchar(4),col6 char(10),col7 varchar(213),col8 timestamp(1),col9 blob,col10 varchar(6) character set latin1,col11 tinyint unsigned,col12 varchar(244) DEFAULT (col20),col13 char(151) character set latin1,col14 varchar(3) character set utf8mb4,col15 smallint,col16 varchar(4),col17 int DEFAULT 11491,col18 char(7),col19 char(6),col20 date,col21 varchar(250),col22 varchar(40) character set latin1,col23 mediumblob,col24 timestamp(3),col25 smallint,col26 tinyint unsigned,col27 char(5),col28 varchar(8),col29 double,col30 varchar(10) character set utf8mb4,col31 varchar(60) character set utf8mb4 unique,col32 tinytext,col33 varchar(100),col34 float,col35 smallint,col36 smallint,col37 varchar(10),col38 smallint,col39 char(9) character set latin1 DEFAULT 'deRSKLp9A',col40 varchar(236) character set latin1,col41 char(70),col42 date,col43 varchar(6),col44 varchar(9) character set latin1,col45 tinyint DEFAULT (col49),col46 char(2) character set latin1,col47 bigint,col48 char(3) character set utf8mb4,col49 datetime(1),col50 timestamp(0),col51 int unsigned,col52 smallint,col53 decimal(32,1),col54 varchar(4) character set latin1,col55 int DEFAULT 16,col56 int,col57 tinyblob,col58 smallint,col59 smallint,col60 smallint,col61 varchar(242) character set latin1,col62 smallint,col63 bigint DEFAULT -11472, PRIMARY KEY ind1 ( `col28`), KEY ind2 ( `col37`)) ROW_FORMAT=DYNAMIC COMPRESSION='LZ4' STATS_SAMPLE_PAGES=39 CHARACTER SET latin1; CREATE TABLE gts2.tt31 (col1 date,col2 timestamp,col3 varchar(209),col4 varchar(6),col5 tinyint,col6 varchar(7) character set utf8mb4 unique, PRIMARY KEY ind1 ( `col3`), UNIQUE KEY ind2 ( `col6`), KEY ind3 ( `col1`), KEY ind4 ( `col5`)) AUTOEXTEND_SIZE=8M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=21 CHARACTER SET utf8mb4; CREATE TABLE gts2.tt32 (col1 tinyint DEFAULT (col2),col2 char(121) DEFAULT (col1),col3 char(2),col4 time,col5 json,col6 tinyint unsigned,col7 double DEFAULT (col6), PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col2`), KEY ind3 ( `col4`), KEY ind4 ( `col4`, `col1`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 STATS_SAMPLE_PAGES=8 CHARACTER SET utf8mb4; CREATE TABLE gts2.tt33 (col1 varchar(10) character set utf8mb4,col2 smallint,col3 bigint,col4 tinyint unsigned,col5 varchar(3) character set utf8mb4,col6 varbinary(5),col7 varchar(217), PRIMARY KEY ind1 ( `col6`), KEY ind2 ( `col2`), KEY ind3 ( `col1`), KEY ind4 ( `col4`), KEY ind5 ( `col5`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=17 CHARACTER SET latin1; CREATE TABLE gts3.tt1 (col1 char(5) character set latin1,col2 timestamp,col3 char(5) character set utf8mb4,col4 tinyint,col5 varchar(0) unique,col6 int, PRIMARY KEY ind1 ( `col2`)) ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=10; CREATE TABLE gts3.tt2 (col1 tinyint,col2 varchar(8),col3 bigint,col4 varchar(2), PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col4`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=DYNAMIC COMPRESSION='ZLIB' STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=22 CHARACTER SET latin1; CREATE TABLE gts3.tt3 (col1 timestamp(3),col2 varbinary(1),col3 timestamp(4),col4 longtext,col5 bigint, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`), KEY ind3 ( `col4`(142))) AUTOEXTEND_SIZE=4M ROW_FORMAT=REDUNDANT STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=12; CREATE TABLE gts3.tt4 (col1 char(6) character set utf8mb4,col2 varchar(2),col3 tinyint,col4 double, PRIMARY KEY ind1 ( `col3`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=3 CHARACTER SET utf8mb4; CREATE TABLE gts3.tt5 (col1 smallint,col2 char(7),col3 char(1) DEFAULT (HEX(RANDOM_BYTES(55))), PRIMARY KEY ind1 ( `col2`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=DYNAMIC STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=20 CHARACTER SET utf8mb4; CREATE TABLE gts3.tt6 (col1 varchar(168) character set utf8mb4,col2 bigint DEFAULT (col1),col3 char(4) character set latin1,col4 smallint unsigned,col5 float,col6 varchar(2) character set latin1,col7 smallint DEFAULT (col2),col8 varchar(3) character set latin1, PRIMARY KEY ind1 ( `col3`), KEY ind2 ( `col3`)) AUTOEXTEND_SIZE=12M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=10 CHARACTER SET latin1; CREATE TABLE gts3.tt7 (col1 float DEFAULT (RAND()*107),col2 timestamp,col3 timestamp(5),col4 char(8) character set latin1,col5 varchar(1),col6 float,col7 varchar(238),col8 smallint, PRIMARY KEY ind1 ( `col7`), KEY ind2 ( `col4`), KEY ind3 ( `col6`), KEY ind4 ( `col4`), UNIQUE KEY ind5 ( `col7`)) AUTOEXTEND_SIZE=20M STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=4 CHARACTER SET latin1; CREATE TABLE gts3.tt8 (col1 float DEFAULT (col2),col2 int DEFAULT (col7),col3 varchar(8) character set utf8mb4,col4 smallint,col5 int,col6 varchar(5),col7 varchar(9), PRIMARY KEY ind1 ( `col6`), KEY ind2 ( `col6`)) ROW_FORMAT=DYNAMIC STATS_SAMPLE_PAGES=36 CHARACTER SET latin1; CREATE TABLE gts3.tt9 (col1 varchar(91),col2 smallint,col3 char(180),col4 varchar(7),col5 smallint,col6 int,col7 double,col8 varchar(175) character set latin1, PRIMARY KEY ind1 ( `col8`), KEY ind2 ( `col7`)) AUTOEXTEND_SIZE=16M STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=40; CREATE TABLE gts3.tt10 (col1 varchar(151) character set latin1 DEFAULT (col2),col2 varchar(9),col3 blob,col4 varchar(111) DEFAULT (col3),col5 varchar(5),col6 char(3), PRIMARY KEY ind1 ( `col6`), KEY ind2 ( `col1`), KEY ind3 ( `col3`(6)), KEY ind4 ( `col1`)) AUTOEXTEND_SIZE=16M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=10 CHARACTER SET latin1; CREATE TABLE gts3.tt11 (col1 char(241),col2 varchar(45) character set latin1,col3 varchar(26),col4 varchar(8), PRIMARY KEY ind1 ( `col3`)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=7; CREATE TABLE gts3.tt12 (col1 varchar(175),col2 varchar(202),col3 smallint,col4 float unique,col5 varchar(2),col6 datetime,col7 int,col8 varchar(140),col9 char(9) character set utf8mb4,col10 decimal(54),col11 varchar(7),col12 tinyint unsigned,col13 smallint,col14 char(8),col15 float,col16 float,col17 smallint,col18 text,col19 varchar(111) character set utf8mb4 DEFAULT (col1),col20 bigint unique,col21 timestamp,col22 tinyint,col23 smallint,col24 varchar(6) character set utf8mb4,col25 varchar(99),col26 smallint,col27 varchar(53) character set utf8mb4,col28 varchar(42),col29 mediumtext,col30 char(2),col31 float,col32 bigint,col33 timestamp,col34 timestamp, PRIMARY KEY ind1 ( `col30`), KEY ind2 ( `col22`)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=28 CHARACTER SET utf8mb4; CREATE TABLE gts3.tt13 (col1 char(5),col2 varchar(18),col3 varchar(8) character set latin1,col4 varchar(225) character set latin1,col5 longtext, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col2`)) STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=38; CREATE TABLE gts3.tt14 (col1 smallint,col2 char(8),col3 varchar(58) character set utf8mb4,col4 varchar(8) character set utf8mb4,col5 varchar(33) character set latin1,col6 tinyint unique,col7 varchar(121),col8 timestamp(6), PRIMARY KEY ind1 ( `col6`), UNIQUE KEY ind2 ( `col2`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 STATS_SAMPLE_PAGES=38 CHARACTER SET utf8mb4; CREATE TABLE gts3.tt15 (col1 char(7) character set latin1) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 STATS_SAMPLE_PAGES=1; CREATE TABLE gts3.tt16 (col1 mediumint,col2 smallint,col3 char(7) character set utf8mb4,col4 char(154) character set utf8mb4) ROW_FORMAT=COMPACT STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=6 CHARACTER SET latin1; CREATE TABLE gts3.tt17 (col1 varchar(7) character set latin1 unique,col2 varchar(128) character set utf8mb4,col3 timestamp(4),col4 varchar(53),col5 longtext) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=7 CHARACTER SET utf8mb4; CREATE TABLE gts3.tt18 (col1 varchar(84),col2 varchar(7) character set latin1,col3 varchar(106),col4 char(2),col5 timestamp(5),col6 smallint, PRIMARY KEY ind1 ( `col2`)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=5 CHARACTER SET utf8mb4; CREATE TABLE gts3.tt19 (col1 varchar(2),col2 mediumint,col3 varchar(117) DEFAULT (col5),col4 varchar(10) character set utf8mb4,col5 timestamp(5),col6 varchar(230),col7 varchar(7),col8 float, PRIMARY KEY ind1 ( `col5`), KEY ind2 ( `col3`), UNIQUE KEY ind3 ( `col2`), KEY ind4 ( `col4`), UNIQUE KEY ind5 ( `col2`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=REDUNDANT STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1; CREATE TABLE gts3.tt20 (col1 int,col2 smallint,col3 varchar(2) character set utf8mb4, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`), KEY ind3 ( `col1` desc, `col2`)) AUTOEXTEND_SIZE=8M STATS_PERSISTENT=1 CHARACTER SET utf8mb4; CREATE TABLE gts3.tt21 (col1 double,col2 smallint,col3 varchar(109),col4 varchar(231) character set utf8mb4,col5 char(3), PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col4`)) ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=5; CREATE TABLE gts3.tt22 (col1 varchar(10),col2 double,col3 float,col4 float,col5 smallint unsigned,col6 varchar(73) character set latin1,col7 varchar(24), PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col7`)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=3; CREATE TABLE gts3.tt23 (col1 varchar(48) character set utf8mb4,col2 varchar(9),col3 float,col4 float,col5 smallint unsigned,col6 smallint, PRIMARY KEY ind1 ( `col3`), KEY ind2 ( `col5`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=DYNAMIC STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=25 CHARACTER SET utf8mb4; CREATE TABLE gts3.tt24 (col1 float, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=20 CHARACTER SET latin1; CREATE TABLE gts3.tt25 (col1 varchar(2),col2 varchar(102) character set latin1,col3 bigint,col4 char(105) character set latin1,col5 tinytext,col6 varchar(10) character set latin1 DEFAULT (col8),col7 decimal(6,6),col8 int, KEY ind1 ( (BIN(`col7`))), KEY ind2 ( `col5`(2627)), KEY ind3 ( `col5`(76))) STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=12 CHARACTER SET utf8mb4; CREATE TABLE gts3.tt26 (col1 bigint DEFAULT (RAND()*107),col2 varchar(90),col3 int,col4 int,col5 smallint,col6 varchar(2) DEFAULT (HEX(RANDOM_BYTES(55))),col7 char(1) character set latin1,col8 smallint unsigned DEFAULT (col3), PRIMARY KEY ind1 ( `col2`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1; CREATE TABLE gts3.tt27 (col1 blob,col2 char(4),col3 float,col4 tinyint,col5 float,col6 float,col7 tinyint,col8 float,col9 varchar(171),col10 tinyint,col11 float,col12 varchar(171) DEFAULT (HEX(RANDOM_BYTES(12))),col13 timestamp,col14 varchar(166) character set utf8mb4,col15 int,col16 tinyint,col17 smallint,col18 varchar(244),col19 polygon srid 4326,col20 smallint,col21 varchar(56) character set utf8mb4,col22 varchar(139) character set utf8mb4,col23 smallint,col24 varchar(6),col25 longtext,col26 char(8) character set latin1 DEFAULT (HEX(RANDOM_BYTES(55))),col27 tinyint,col28 varchar(28),col29 tinyint,col30 float,col31 varchar(150) character set utf8mb4,col32 char(29) character set utf8mb4,col33 bigint,col34 int, PRIMARY KEY ind1 ( `col30`), KEY ind2 ( `col29`)) AUTOEXTEND_SIZE=12M STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=24; CREATE TABLE gts3.tt28 (col1 varchar(158) character set utf8mb4,col2 longtext,col3 tinyint) AUTOEXTEND_SIZE=12M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=36; CREATE TABLE gts3.tt29 (col1 linestring srid 4326,col2 smallint,col3 varchar(9) character set utf8mb4,col4 varchar(2),col5 varchar(7),col6 smallint) ROW_FORMAT=DYNAMIC STATS_SAMPLE_PAGES=5; CREATE TABLE gts3.tt30 (col1 varchar(10) character set utf8mb4,col2 mediumint,col3 varchar(27),col4 varchar(4) character set latin1,col5 bigint,col6 bigint, PRIMARY KEY ind1 ( `col1`)) ROW_FORMAT=DYNAMIC STATS_SAMPLE_PAGES=9 CHARACTER SET utf8mb4; CREATE TABLE gts3.tt31 (col1 varchar(55),col2 smallint,col3 char(83) character set latin1, PRIMARY KEY ind1 ( `col1`)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=22; CREATE TABLE gts3.tt32 (col1 blob,col2 varchar(89) character set latin1 DEFAULT (col8),col3 char(7),col4 smallint unsigned DEFAULT 64,col5 timestamp,col6 char(10) DEFAULT 'BCD12xyz09',col7 char(126),col8 smallint, PRIMARY KEY ind1 ( `col4`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPACT STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=22; CREATE TABLE gts3.tt33 (col1 datetime DEFAULT '2018-10-09 10:37:50',col2 longtext,col3 varchar(160),col4 varbinary(5) DEFAULT (col3), PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=16M ROW_FORMAT=COMPACT STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=3 CHARACTER SET utf8mb4; CREATE TABLE gts4.tt1 (col1 tinyint unsigned, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`)) AUTOEXTEND_SIZE=8M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1; CREATE TABLE gts4.tt2 (col1 varchar(155) character set latin1 DEFAULT (HEX(RANDOM_BYTES(55))),col2 varchar(7) character set latin1, PRIMARY KEY ind1 ( `col1`)) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=28; CREATE TABLE gts4.tt3 (col1 varchar(36),col2 mediumint,col3 char(5),col4 timestamp,col5 timestamp(5),col6 char(6) character set utf8mb4) AUTOEXTEND_SIZE=12M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=32; CREATE TABLE gts4.tt4 (col1 timestamp(1),col2 float,col3 bigint,col4 varchar(9),col5 tinyint,col6 char(5), PRIMARY KEY ind1 ( `col4`), KEY ind2 ( `col3`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=18; CREATE TABLE gts4.tt5 (col1 varchar(63) character set utf8mb4,col2 varchar(175) character set latin1,col3 varchar(7),col4 varchar(184),col5 linestring srid 4326,col6 timestamp,col7 text,col8 varchar(120) character set latin1, PRIMARY KEY ind1 ( `col4`)) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 STATS_SAMPLE_PAGES=27 CHARACTER SET utf8mb4; CREATE TABLE gts4.tt6 (col1 bigint,col2 tinytext,col3 varchar(9) character set utf8mb4,col4 float,col5 smallint, PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=8M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=2 CHARACTER SET utf8mb4; CREATE TABLE gts4.tt7 (col1 varchar(9) DEFAULT (HEX(RANDOM_BYTES(55))),col2 smallint,col3 varchar(97) character set latin1 DEFAULT (col1), PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=4M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1 CHARACTER SET latin1; CREATE TABLE gts4.tt8 (col1 int,col2 float DEFAULT (col1), PRIMARY KEY ind1 ( `col2`)) STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1; CREATE TABLE gts4.tt9 (col1 tinyint,col2 varchar(87),col3 smallint,col4 bigint,col5 varchar(4) character set latin1,col6 smallint,col7 bigint, PRIMARY KEY ind1 ( `col5`), KEY ind2 ( `col2`)) ROW_FORMAT=REDUNDANT STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=13 CHARACTER SET latin1; CREATE TABLE gts4.tt10 (col1 tinyint,col2 timestamp,col3 timestamp(4),col4 varchar(3), PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col1`), KEY ind3 ( `col3`), KEY ind4 ( `col2` desc), KEY ind5 ( `col2`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=40 CHARACTER SET utf8mb4; CREATE TABLE gts4.tt11 (col1 int,col2 varchar(128) character set latin1,col3 float,col4 int,col5 varchar(2) character set utf8mb4,col6 float,col7 tinytext,col8 smallint) AUTOEXTEND_SIZE=8M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=12 CHARACTER SET utf8mb4; CREATE TABLE gts4.tt12 (col1 decimal(30,1),col2 varchar(163) character set latin1,col3 varchar(42) DEFAULT (HEX(RANDOM_BYTES(55))),col4 smallint,col5 varchar(6),col6 varchar(126), PRIMARY KEY ind1 ( `col3`), KEY ind2 ( `col4`)) STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=26; CREATE TABLE gts4.tt13 (col1 bigint,col2 varchar(141) character set utf8mb4,col3 smallint, PRIMARY KEY ind1 ( `col2`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=DYNAMIC STATS_SAMPLE_PAGES=18 CHARACTER SET latin1; CREATE TABLE gts4.tt14 (col1 smallint,col2 varchar(4) character set utf8mb4,col3 timestamp(4),col4 varchar(22) character set utf8mb4,col5 varchar(10),col6 char(20) character set latin1, PRIMARY KEY ind1 ( `col6`)) AUTOEXTEND_SIZE=12M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=35 CHARACTER SET latin1; CREATE TABLE gts4.tt15 (col1 longblob,col2 mediumint, PRIMARY KEY ind1 ( `col1`(30))) AUTOEXTEND_SIZE=4M ROW_FORMAT=REDUNDANT STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1; CREATE TABLE gts4.tt16 (col1 int,col2 varchar(7),col3 time,col4 int, PRIMARY KEY ind1 ( `col3`, `col4`), KEY ind2 ( `col3`)) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=7 CHARACTER SET latin1; CREATE TABLE gts4.tt17 (col1 int,col2 varchar(209) character set utf8mb4,col3 varchar(11) character set latin1, PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=4M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=20 CHARACTER SET latin1; CREATE TABLE gts4.tt18 (col1 float,col2 varchar(7) DEFAULT (HEX(RANDOM_BYTES(55))),col3 float,col4 float DEFAULT 0.0159773638333295,col5 smallint, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col4`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=22; CREATE TABLE gts4.tt19 (col1 int,col2 char(2) DEFAULT 'NO',col3 varchar(10),col4 varchar(8),col5 varchar(8) character set utf8mb4,col6 tinyint, PRIMARY KEY ind1 ( `col3`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=6 CHARACTER SET latin1; CREATE TABLE gts4.tt20 (col1 float,col2 bigint, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`), KEY ind3 ( `col2`), KEY ind4 ( `col2`), KEY ind5 ( `col2` desc)) AUTOEXTEND_SIZE=8M STATS_SAMPLE_PAGES=26 CHARACTER SET utf8mb4; CREATE TABLE gts4.tt21 (col1 bigint,col2 varchar(155),col3 float DEFAULT (col5),col4 float,col5 float,col6 float DEFAULT (RAND()*107),col7 varchar(10), PRIMARY KEY ind1 ( `col5`), KEY ind2 ( `col4`)) AUTOEXTEND_SIZE=20M ROW_FORMAT=DYNAMIC STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1 CHARACTER SET utf8mb4; CREATE TABLE gts4.tt22 (col1 tinyint unsigned,col2 varchar(92) character set utf8mb4,col3 varchar(112), PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1 CHARACTER SET utf8mb4; CREATE TABLE gts4.tt23 (col1 longtext,col2 float, PRIMARY KEY ind1 ( `col1`(253))) AUTOEXTEND_SIZE=12M STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=38 CHARACTER SET latin1; CREATE TABLE gts4.tt24 (col1 varchar(133) DEFAULT 'uXxyKLMUV1UVW5Z1234JKLM89Q45678QR23STz0WGH567OPQRTUfghi6789Z0123ABCDIJKLM67vtuvwghijkuvQRSTU01223456345opqr123abc456fUVWNnop01bkl',col2 varchar(232) character set utf8mb4,col3 varchar(197) character set latin1,col4 smallint, PRIMARY KEY ind1 ( `col3`)) ROW_FORMAT=DYNAMIC COMPRESSION='LZ4' STATS_AUTO_RECALC=1 STATS_PERSISTENT=1; CREATE TABLE gts4.tt25 (col1 smallint unsigned,col2 double, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col2`)) STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=34; CREATE TABLE gts4.tt26 (col1 tinyint,col2 varchar(6) character set utf8mb4, PRIMARY KEY ind1 ( `col2`)) AUTOEXTEND_SIZE=4M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1 CHARACTER SET latin1; CREATE TABLE gts4.tt27 (col1 float DEFAULT (col6),col2 varchar(9) character set latin1 DEFAULT (RAND()),col3 bigint,col4 float,col5 char(10) character set utf8mb4,col6 varchar(5) character set latin1,col7 varchar(123) character set latin1,col8 varchar(8), PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col6`), KEY ind3 ( `col8`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 STATS_SAMPLE_PAGES=39; CREATE TABLE gts4.tt28 (col1 float DEFAULT (col4),col2 varchar(22) character set latin1,col3 varchar(50) DEFAULT 'iyz01DEFGH59ABOPQRnopqrpWklmnoKL3456YZYZ01YZ012MNO',col4 tinyint, PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col2`)) AUTOEXTEND_SIZE=12M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=2 CHARACTER SET latin1; CREATE TABLE gts4.tt29 (col1 varchar(216) character set latin1,col2 int unsigned,col3 varchar(8),col4 float,col5 smallint unique,col6 int,col7 varchar(6) character set latin1,col8 bigint DEFAULT (RAND()*107),col9 smallint unsigned) AUTOEXTEND_SIZE=12M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=32 CHARACTER SET latin1; CREATE TABLE gts4.tt30 (col1 smallint DEFAULT (RAND()*107), PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=40 CHARACTER SET latin1; CREATE TABLE gts4.tt31 (col1 varchar(214) character set latin1,col2 varchar(179) character set utf8mb4,col3 smallint,col4 int,col5 varchar(9) character set utf8mb4,col6 mediumtext, PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col1`)) AUTOEXTEND_SIZE=16M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=20; CREATE TABLE gts4.tt32 (col1 smallint,col2 varchar(42), PRIMARY KEY ind1 ( `col2`, `col1`)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=40 CHARACTER SET utf8mb4; CREATE TABLE gts4.tt33 (col1 smallint,col2 varchar(2) character set utf8mb4,col3 varchar(10),col4 smallint,col5 varchar(106) character set latin1,col6 varchar(4) character set utf8mb4,col7 varchar(3) character set latin1, PRIMARY KEY ind1 ( `col6`), KEY ind2 ( `col6`), KEY ind3 ( `col5`), KEY ind4 ( `col2`), KEY ind5 ( `col5`, `col3`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1 CHARACTER SET latin1; CREATE TABLE gts5.tt1 (col1 smallint unsigned, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`), KEY ind3 ( `col1`), KEY ind4 ( `col1`)) ROW_FORMAT=DYNAMIC COMPRESSION='NONE' STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=2 CHARACTER SET utf8mb4; CREATE TABLE gts5.tt2 (col1 varchar(9) character set latin1 DEFAULT (HEX(RANDOM_BYTES(55))),col2 varchar(7),col3 float,col4 varchar(30),col5 int unsigned,col6 varchar(95) character set latin1,col7 varchar(98) character set latin1,col8 smallint, PRIMARY KEY ind1 ( `col3`), UNIQUE KEY ind2 ( `col8`), KEY ind3 ( `col3`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=21 CHARACTER SET latin1; CREATE TABLE gts5.tt3 (col1 varchar(9) character set latin1,col2 varchar(1),col3 char(4) character set latin1 DEFAULT (HEX(RANDOM_BYTES(55))),col4 tinyint, PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 CHARACTER SET latin1; CREATE TABLE gts5.tt4 (col1 varchar(190),col2 varchar(6) character set utf8mb4,col3 varchar(61) character set utf8mb4,col4 varchar(138) character set utf8mb4,col5 decimal(31,30),col6 tinyint,col7 varchar(209),col8 float,col9 varchar(223) character set utf8mb4,col10 double) ROW_FORMAT=REDUNDANT COMPRESSION='LZ4' STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=31 CHARACTER SET utf8mb4; CREATE TABLE gts5.tt5 (col1 float, PRIMARY KEY ind1 ( `col1`)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=33; CREATE TABLE gts5.tt6 (col1 varchar(20) character set latin1,col2 varchar(6) DEFAULT (HEX(RANDOM_BYTES(12))),col3 varchar(3) DEFAULT (col4),col4 tinyint,col5 double,col6 int, PRIMARY KEY ind1 ( `col6`)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=14; CREATE TABLE gts5.tt7 (col1 decimal(22,5),col2 float,col3 varchar(98) character set utf8mb4,col4 float, PRIMARY KEY ind1 ( `col3`), KEY ind2 ( `col2`), KEY ind3 ( `col2`), KEY ind4 ( `col1`)) ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=30 CHARACTER SET utf8mb4; CREATE TABLE gts5.tt8 (col1 varchar(126) character set latin1,col2 varchar(23),col3 varchar(160),col4 varchar(214),col5 varchar(6) DEFAULT (col3), PRIMARY KEY ind1 ( `col5`)) STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=25; CREATE TABLE gts5.tt9 (col1 varchar(213) character set utf8mb4, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`)) ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=28 CHARACTER SET latin1; CREATE TABLE gts5.tt10 (col1 varchar(110) character set latin1,col2 bigint,col3 varchar(3) character set utf8mb4 unique DEFAULT '4IV',col4 timestamp(6)) AUTOEXTEND_SIZE=4M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=36; CREATE TABLE gts5.tt11 (col1 smallint,col2 smallint,col3 varchar(7) character set latin1,col4 varchar(1),col5 int DEFAULT (RAND()*107),col6 timestamp,col7 varchar(6)) AUTOEXTEND_SIZE=8M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=13 CHARACTER SET latin1; CREATE TABLE gts5.tt12 (col1 float,col2 tinyint,col3 bigint,col4 tinyint DEFAULT (col1),col5 json not null,col6 double, PRIMARY KEY ind1 ( `col4`), UNIQUE KEY ind2 ( `col4`), KEY ind3 ( `col4`), KEY ind4 ( `col1`)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=35 CHARACTER SET utf8mb4; CREATE TABLE gts5.tt13 (col1 smallint DEFAULT (RAND()*107),col2 smallint,col3 varchar(10),col4 json not null,col5 smallint,col6 bigint,col7 varchar(149),col8 float DEFAULT (col5), PRIMARY KEY ind1 ( `col2`)) STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=24; CREATE TABLE gts5.tt14 (col1 bigint,col2 char(67) character set utf8mb4) AUTOEXTEND_SIZE=8M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=39; CREATE TABLE gts5.tt15 (col1 varchar(5) character set utf8mb4,col2 json not null,col3 varchar(4),col4 float,col5 varchar(2),col6 smallint,col7 varchar(90),col8 varchar(145) character set latin1, PRIMARY KEY ind1 ( `col1`, `col8`), KEY ind2 ( (REGEXP_INSTR(`col8`,`col8`)))) AUTOEXTEND_SIZE=8M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1; CREATE TABLE gts5.tt16 (col1 varchar(4),col2 float,col3 smallint,col4 int,col5 varchar(6) character set latin1 DEFAULT (HEX(RANDOM_BYTES(55))),col6 char(10) character set utf8mb4, PRIMARY KEY ind1 ( `col3`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=36; CREATE TABLE gts5.tt17 (col1 float,col2 varchar(78) character set utf8mb4,col3 char(200) character set latin1,col4 datetime(5)) STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=7 CHARACTER SET utf8mb4; CREATE TABLE gts5.tt18 (col1 varchar(7) character set latin1,col2 varchar(179),col3 varchar(167),col4 varchar(79),col5 varchar(5) character set utf8mb4) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=9; CREATE TABLE gts5.tt19 (col1 smallint,col2 varchar(10),col3 smallint,col4 varchar(10) character set utf8mb4,col5 varchar(193) character set utf8mb4 DEFAULT (col3), PRIMARY KEY ind1 ( `col4`), KEY ind2 ( `col2`), KEY ind3 ( `col4`)) ROW_FORMAT=DYNAMIC STATS_SAMPLE_PAGES=1 CHARACTER SET utf8mb4; CREATE TABLE gts5.tt20 (col1 varchar(128) character set latin1,col2 varchar(242) character set utf8mb4,col3 float,col4 tinyint,col5 varchar(2) character set utf8mb4,col6 timestamp(4),col7 varchar(8),col8 mediumint) ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=1; CREATE TABLE gts5.tt21 (col1 timestamp, PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=20M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=34; CREATE TABLE gts5.tt22 (col1 smallint unsigned,col2 varchar(87),col3 float,col4 float, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col3`, `col1`), KEY ind3 ( `col4`)) STATS_PERSISTENT=1 CHARACTER SET latin1; CREATE TABLE gts5.tt23 (col1 varchar(64) character set latin1 DEFAULT (HEX(RANDOM_BYTES(55))),col2 time,col3 tinyblob,col4 timestamp,col5 char(5) character set latin1,col6 decimal(13,1) DEFAULT 0.442161422485167,col7 varchar(5) character set utf8mb4,col8 varchar(7) character set latin1, PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col7`), KEY ind3 ( `col8`), KEY ind4 ( `col2`), UNIQUE KEY ind5 ( `col5`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=REDUNDANT STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=12 CHARACTER SET latin1; CREATE TABLE gts5.tt24 (col1 char(7),col2 char(4) character set utf8mb4,col3 varchar(190),col4 varchar(95) character set latin1,col5 smallint,col6 char(10) DEFAULT 'BCvwx9ABCD',col7 varchar(109) character set latin1, PRIMARY KEY ind1 ( `col2`)) AUTOEXTEND_SIZE=16M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=30; CREATE TABLE gts5.tt25 (col1 tinyint,col2 bigint,col3 float,col4 int unsigned,col5 float, PRIMARY KEY ind1 ( `col2`)) AUTOEXTEND_SIZE=20M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=25 CHARACTER SET latin1; CREATE TABLE gts5.tt26 (col1 varchar(102) character set utf8mb4, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`), UNIQUE KEY ind3 ( `col1`)) AUTOEXTEND_SIZE=12M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=8 CHARACTER SET utf8mb4; CREATE TABLE gts5.tt27 (col1 smallint,col2 varchar(65),col3 char(1),col4 decimal(7,1),col5 float, PRIMARY KEY ind1 ( `col5`), KEY ind2 ( `col5`), KEY ind3 ( `col1`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=4 CHARACTER SET latin1; CREATE TABLE gts5.tt28 (col1 varchar(169),col2 char(73),col3 varchar(2) character set latin1,col4 char(203),col5 timestamp(4),col6 varchar(10) character set latin1, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col4`), KEY ind3 ( `col2`), KEY ind4 ( `col4`), KEY ind5 ( `col1`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=23; CREATE TABLE gts5.tt29 (col1 mediumint,col2 varchar(7),col3 timestamp,col4 varchar(5),col5 smallint) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPACT COMPRESSION='LZ4' STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=5 CHARACTER SET utf8mb4; CREATE TABLE gts5.tt30 (col1 varchar(200) character set utf8mb4 DEFAULT (HEX(RANDOM_BYTES(55))),col2 decimal(37,6) DEFAULT (col1),col3 char(22) character set latin1,col4 varchar(89),col5 tinyint, PRIMARY KEY ind1 ( `col3`)) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=25; CREATE TABLE gts5.tt31 (col1 float,col2 smallint,col3 smallint unsigned) STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=23 CHARACTER SET utf8mb4; CREATE TABLE gts5.tt32 (col1 varchar(180) DEFAULT 'DQRSTABH456xyzvwxyz782345345tud3456opqrsEFGmn789vwxyhibcsmxyzYZ012CLMxyz0FGHIJYZ0789uvt1234rstucdefdxyzUVWc784567yz01ghijkM675679ABC78678rstuvfvwxyzopdeRSKLp9ABCDefghiz012',col2 smallint, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col2`)) AUTOEXTEND_SIZE=16M ROW_FORMAT=DYNAMIC STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=33; CREATE TABLE gts5.tt33 (col1 varchar(231),col2 varchar(40),col3 tinyint,col4 float, PRIMARY KEY ind1 ( `col2`)) AUTOEXTEND_SIZE=20M ROW_FORMAT=DYNAMIC STATS_SAMPLE_PAGES=33 CHARACTER SET latin1; CREATE TABLE gts6.tt1 (col1 varchar(85),col2 varchar(142),col3 float,col4 timestamp, PRIMARY KEY ind1 ( `col3`), KEY ind2 ( `col2`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=8; CREATE TABLE gts6.tt2 (col1 tinyint unsigned, PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=27 CHARACTER SET utf8mb4; CREATE TABLE gts6.tt3 (col1 varchar(10),col2 varchar(103),col3 float,col4 float,col5 mediumint, PRIMARY KEY ind1 ( `col4`)) AUTOEXTEND_SIZE=4M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=17; CREATE TABLE gts6.tt4 (col1 char(163) character set utf8mb4,col2 tinyblob,col3 varchar(6),col4 varchar(241) character set utf8mb4,col5 varchar(246) character set utf8mb4,col6 timestamp, PRIMARY KEY ind1 ( `col4`)) AUTOEXTEND_SIZE=12M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=18; CREATE TABLE gts6.tt5 (col1 int, PRIMARY KEY ind1 ( `col1`)) ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=17; CREATE TABLE gts6.tt6 (col1 varchar(8) DEFAULT (col36),col2 timestamp(6) DEFAULT (LOCALTIME),col3 int unsigned,col4 varchar(8),col5 varchar(9),col6 varchar(5) character set utf8mb4,col7 varchar(59),col8 varchar(129) character set latin1,col9 float,col10 smallint,col11 varchar(62),col12 smallint,col13 timestamp(4),col14 smallint,col15 timestamp,col16 float,col17 varchar(4) character set latin1,col18 varchar(137),col19 tinyint,col20 date,col21 float,col22 varchar(8) character set utf8mb4,col23 smallint,col24 float DEFAULT 0.0154131533065307,col25 varchar(72) character set utf8mb4 DEFAULT (HEX(RANDOM_BYTES(55))),col26 smallint unique,col27 json not null,col28 float DEFAULT (RAND()*107),col29 varchar(22),col30 varchar(169),col31 smallint,col32 char(7) character set utf8mb4,col33 varchar(6) character set utf8mb4,col34 varchar(43),col35 varchar(12) character set utf8mb4,col36 varchar(189),col37 varchar(1) character set utf8mb4,col38 smallint,col39 smallint, PRIMARY KEY ind1 ( `col6`), KEY ind2 ( `col6`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=DYNAMIC STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=15 CHARACTER SET latin1; CREATE TABLE gts6.tt7 (col1 varchar(9),col2 smallint unsigned,col3 varbinary(6),col4 smallint unsigned DEFAULT (RAND()*107),col5 datetime(2),col6 tinyint, PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col3`)) STATS_SAMPLE_PAGES=8; CREATE TABLE gts6.tt8 (col1 timestamp(1),col2 float,col3 smallint,col4 varchar(5),col5 smallint,col6 varchar(69) character set utf8mb4,col7 smallint,col8 smallint, PRIMARY KEY ind1 ( `col4`, `col6`, `col7`)) STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=37; CREATE TABLE gts6.tt9 (col1 varchar(8),col2 varchar(9) character set latin1,col3 varchar(173),col4 varchar(3) character set utf8mb4,col5 varchar(9) character set latin1,col6 json,col7 char(9) character set utf8mb4,col8 varchar(5), PRIMARY KEY ind1 ( `col3`), KEY ind2 ( `col5`), KEY ind3 ( `col5`)) ROW_FORMAT=REDUNDANT STATS_PERSISTENT=1 CHARACTER SET latin1; CREATE TABLE gts6.tt10 (col1 varchar(228) character set latin1,col2 char(10) character set utf8mb4,col3 float DEFAULT 0.0686841856503829,col4 varchar(230),col5 smallint, PRIMARY KEY ind1 ( `col5`), KEY ind2 ( `col2`)) AUTOEXTEND_SIZE=16M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=12 CHARACTER SET latin1; CREATE TABLE gts6.tt11 (col1 varchar(36) character set latin1,col2 timestamp(1),col3 tinyint unsigned, PRIMARY KEY ind1 ( `col3`), KEY ind2 ( `col3`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 CHARACTER SET latin1; CREATE TABLE gts6.tt12 (col1 float,col2 timestamp,col3 bigint,col4 varchar(1) character set utf8mb4, PRIMARY KEY ind1 ( `col4`)) AUTOEXTEND_SIZE=16M ROW_FORMAT=COMPACT STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=26; CREATE TABLE gts6.tt13 (col1 varchar(7),col2 float, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`, `col2`)) STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=10; CREATE TABLE gts6.tt14 (col1 varchar(94) character set utf8mb4 GENERATED ALWAYS AS (RTRIM(col3) ) virtual,col2 varchar(9) character set utf8mb4 GENERATED ALWAYS AS (LENGTH(col3) ) virtual,col3 varchar(8) GENERATED ALWAYS AS (AES_ENCRYPT(col2,"") ) stored,col4 float, PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1; CREATE TABLE gts6.tt15 (col1 float DEFAULT (col3),col2 tinyint,col3 float,col4 smallint,col5 bigint DEFAULT (RAND()*107),col6 bigint,col7 varchar(3),col8 varchar(2)) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16 STATS_PERSISTENT=1 CHARACTER SET utf8mb4; CREATE TABLE gts6.tt16 (col1 timestamp,col2 float,col3 float,col4 double,col5 float,col6 smallint,col7 varchar(158) character set utf8mb4,col8 smallint, PRIMARY KEY ind1 ( `col5`)) ROW_FORMAT=DYNAMIC STATS_SAMPLE_PAGES=3 CHARACTER SET latin1; CREATE TABLE gts6.tt17 (col1 varchar(236)) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=39 CHARACTER SET utf8mb4; CREATE TABLE gts6.tt18 (col1 varchar(1),col2 float unique,col3 float DEFAULT (col2),col4 varchar(10) character set utf8mb4,col5 varchar(9) character set latin1,col6 varchar(116) character set latin1) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=32 CHARACTER SET latin1; CREATE TABLE gts6.tt19 (col1 float,col2 varchar(77) character set utf8mb4,col3 varchar(8) character set latin1,col4 varchar(155) character set latin1, PRIMARY KEY ind1 ( `col2`)) AUTOEXTEND_SIZE=4M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=36 CHARACTER SET latin1; CREATE TABLE gts6.tt20 (col1 varchar(1) character set latin1,col2 decimal(55,12),col3 int,col4 varchar(121) character set utf8mb4,col5 varchar(3),col6 varchar(4) character set utf8mb4, PRIMARY KEY ind1 ( `col3`), KEY ind2 ( `col5`), KEY ind3 ( `col2`), KEY ind4 ( `col3`)) AUTOEXTEND_SIZE=20M STATS_AUTO_RECALC=1; CREATE TABLE gts6.tt21 (col1 char(6) character set utf8mb4 DEFAULT (col7),col2 int,col3 bigint,col4 smallint,col5 varchar(5),col6 varchar(225),col7 varchar(7),col8 varchar(85), PRIMARY KEY ind1 ( `col8`), KEY ind2 ( `col3`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=DYNAMIC STATS_SAMPLE_PAGES=37 CHARACTER SET latin1; CREATE TABLE gts6.tt22 (col1 decimal(6,2),col2 char(13),col3 char(2) character set latin1 DEFAULT (HEX(RANDOM_BYTES(55))), PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=33; CREATE TABLE gts6.tt23 (col1 timestamp(3),col2 tinyint,col3 varchar(5) character set utf8mb4,col4 bigint) STATS_PERSISTENT=1; CREATE TABLE gts6.tt24 (col1 varchar(7),col2 int) AUTOEXTEND_SIZE=12M ROW_FORMAT=DYNAMIC COMPRESSION='ZLIB' STATS_SAMPLE_PAGES=26 CHARACTER SET latin1; CREATE TABLE gts6.tt25 (col1 tinyint, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`), KEY ind3 ( `col1`), UNIQUE KEY ind4 ( `col1`), KEY ind5 ( `col1`)) AUTOEXTEND_SIZE=8M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1; CREATE TABLE gts6.tt26 (col1 char(4),col2 float,col3 smallint,col4 float,col5 bigint DEFAULT (col3),col6 char(132) character set utf8mb4, PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=20M ROW_FORMAT=DYNAMIC COMPRESSION='LZ4' STATS_SAMPLE_PAGES=39 CHARACTER SET utf8mb4; CREATE TABLE gts6.tt27 (col1 varchar(6) character set utf8mb4,col2 varchar(9) character set latin1,col3 smallint,col4 int DEFAULT (col1), PRIMARY KEY ind1 ( `col4`), KEY ind2 ( `col2`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=4; CREATE TABLE gts6.tt28 (col1 smallint,col2 varchar(49) character set utf8mb4 DEFAULT (col4),col3 smallint,col4 varchar(53) character set latin1,col5 smallint,col6 varchar(94), PRIMARY KEY ind1 ( `col6`), KEY ind2 ( `col2`, `col1`, `col5`, `col4`)) AUTOEXTEND_SIZE=4M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=15; CREATE TABLE gts6.tt29 (col1 varchar(220),col2 char(8),col3 varchar(2),col4 timestamp,col5 varchar(143),col6 char(241) character set utf8mb4,col7 varchar(22) character set utf8mb4 DEFAULT (RAND()),col8 bigint,col9 varchar(186) character set utf8mb4,col10 decimal(17,2),col11 smallint,col12 float, PRIMARY KEY ind1 ( `col5`), KEY ind2 ( `col6`, `col5`), KEY ind3 ( `col9`)) ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=28 CHARACTER SET latin1; CREATE TABLE gts6.tt30 (col1 varchar(219) character set utf8mb4,col2 varchar(6) character set latin1,col3 smallint unsigned DEFAULT 192,col4 char(75),col5 float,col6 char(64) character set utf8mb4,col7 bigint unsigned,col8 bigint,col9 tinyint,col10 bigint,col11 varchar(166),col12 float,col13 smallint unsigned,col14 varchar(7), PRIMARY KEY ind1 ( `col11`)) ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 CHARACTER SET latin1; CREATE TABLE gts6.tt31 (col1 smallint,col2 varchar(186),col3 varchar(1) character set latin1,col4 varchar(51) character set latin1,col5 float, PRIMARY KEY ind1 ( `col3`), KEY ind2 ( `col2`)) AUTOEXTEND_SIZE=16M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=40 CHARACTER SET latin1; CREATE TABLE gts6.tt32 (col1 varchar(2),col2 varchar(31) character set latin1,col3 float,col4 char(96) character set utf8mb4 DEFAULT 'STUV234klhi96789AopqJrstuvxyz01ABCDE232345bcdef9456IJKx12345yz2345mnopq45678qrXYZGHIJlmnopEFGNO2', PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col3`), UNIQUE KEY ind3 ( `col3`)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=40 CHARACTER SET latin1; CREATE TABLE gts6.tt33 (col1 text,col2 float, PRIMARY KEY ind1 ( `col1`(72)), KEY ind2 ( `col2`), KEY ind3 ( `col1`(45)), KEY ind4 ( `col1`(169))) AUTOEXTEND_SIZE=12M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=34; CREATE TABLE gts7.tt1 (col1 float,col2 char(189),col3 timestamp,col4 bigint,col5 varchar(3) character set utf8mb4,col6 varchar(2),col7 decimal(14), PRIMARY KEY ind1 ( `col4`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=DYNAMIC STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=21; CREATE TABLE gts7.tt2 (col1 varchar(4),col2 decimal(7),col3 int) ROW_FORMAT=DYNAMIC STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=40; CREATE TABLE gts7.tt3 (col1 decimal(5,0),col2 char(1) character set utf8mb4) ROW_FORMAT=DYNAMIC STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=32 CHARACTER SET utf8mb4; CREATE TABLE gts7.tt4 (col1 varchar(24),col2 tinytext,col3 varchar(136) character set latin1,col4 varchar(5),col5 varchar(94) character set utf8mb4,col6 timestamp(0),col7 float,col8 int DEFAULT (col7), PRIMARY KEY ind1 ( `col5`)) STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=36; CREATE TABLE gts7.tt5 (col1 smallint,col2 float,col3 char(111) character set latin1,col4 varchar(9),col5 tinyint, PRIMARY KEY ind1 ( `col4`)) AUTO_INCREMENT=8 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=20; CREATE TABLE gts7.tt6 (col1 varchar(2) character set latin1,col2 varchar(2) character set utf8mb4,col3 int,col4 double,col5 varchar(7) unique,col6 varchar(173) character set utf8mb4,col7 varchar(5), PRIMARY KEY ind1 ( `col3`), KEY ind2 ( `col4`), KEY ind3 ( `col6`), KEY ind4 ( `col6`), KEY ind5 ( `col6`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=6 CHARACTER SET latin1; CREATE TABLE gts7.tt7 (col1 char(9) DEFAULT 'pGH678XY2',col2 longblob,col3 char(1) character set latin1,col4 char(46), PRIMARY KEY ind1 ( `col4`), KEY ind2 ( `col1`), KEY ind3 ( `col1`, `col3`)) AUTOEXTEND_SIZE=8M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=25 CHARACTER SET latin1; CREATE TABLE gts7.tt8 (col1 varchar(131), PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`)) ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=4; CREATE TABLE gts7.tt9 (col1 varchar(7),col2 varchar(234) character set utf8mb4 DEFAULT (HEX(RANDOM_BYTES(55))),col3 tinyint,col4 tinyint,col5 char(63),col6 tinytext,col7 tinyint,col8 varchar(245),col9 double,col10 varchar(8) character set latin1, PRIMARY KEY ind1 ( `col8`), KEY ind2 ( `col10`), KEY ind3 ( `col7`), KEY ind4 ( `col7`), KEY ind5 ( `col2`)) ROW_FORMAT=REDUNDANT STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 CHARACTER SET latin1; CREATE TABLE gts7.tt10 (col1 varchar(5) character set latin1 DEFAULT (col3),col2 char(2),col3 varchar(9) character set latin1,col4 char(145),col5 varchar(1) DEFAULT 'x',col6 varchar(11) character set utf8mb4, PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col2`)) AUTOEXTEND_SIZE=4M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=17; CREATE TABLE gts7.tt11 (col1 varchar(5) DEFAULT (col6),col2 varchar(4) character set utf8mb4,col3 varchar(5) character set utf8mb4,col4 float,col5 varchar(248) character set utf8mb4,col6 varchar(1),col7 decimal(63,1), PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col7`), KEY ind3 ( `col6`, `col7`)) ROW_FORMAT=REDUNDANT STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=29; CREATE TABLE gts7.tt12 (col1 varchar(115),col2 varchar(10) character set utf8mb4,col3 float, PRIMARY KEY ind1 ( `col2`)) STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1; CREATE TABLE gts7.tt13 (col1 varchar(118),col2 smallint unique,col3 varchar(148) character set latin1,col4 char(3),col5 float DEFAULT (col3), PRIMARY KEY ind1 ( `col2`), UNIQUE KEY ind2 ( `col2`), KEY ind3 ( `col5`)) AUTOEXTEND_SIZE=16M STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=33 CHARACTER SET utf8mb4; CREATE TABLE gts7.tt14 (col1 int, PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=4M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=10; CREATE TABLE gts7.tt15 (col1 varchar(9) character set latin1,col2 varchar(112),col3 varchar(141), PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col1`), KEY ind3 ( `col1`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=35; CREATE TABLE gts7.tt16 (col1 double,col2 smallint,col3 varchar(31) character set utf8mb4,col4 varchar(175) character set utf8mb4,col5 smallint,col6 varchar(3),col7 varchar(8),col8 varchar(1), PRIMARY KEY ind1 ( `col4`), KEY ind2 ( `col8`, `col3`), KEY ind3 ( `col2`), KEY ind4 ( `col2`), KEY ind5 ( `col2`, `col5`) visible) AUTOEXTEND_SIZE=16M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=35; CREATE TABLE gts7.tt17 (col1 varchar(106) character set latin1,col2 float DEFAULT (col5),col3 varchar(40) character set utf8mb4,col4 smallint,col5 smallint unsigned,col6 bigint, PRIMARY KEY ind1 ( `col3`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=COMPACT STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=34 CHARACTER SET utf8mb4; CREATE TABLE gts7.tt18 (col1 smallint unsigned,col2 varchar(9) character set latin1,col3 varchar(4),col4 smallint, PRIMARY KEY ind1 ( `col3`)) ROW_FORMAT=DYNAMIC COMPRESSION='ZLIB' STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=27 CHARACTER SET utf8mb4; CREATE TABLE gts7.tt19 (col1 geometrycollection srid 4326,col2 float,col3 varchar(132) character set latin1,col4 text,col5 varchar(187) character set utf8mb4 DEFAULT 'V678RSTUg94a6rstnopqIcXYZ0defghVWXYEFGHIOPQRLMNOabcbcd2345WXYZ045678TUxyz01Ob512345UVKLDEFGjkuvwxy89ABUVUVW45678QRSTNOPQRF13456efBCDEF1234cdhiLMNyz01KLLMN781201234789AEFGHIDEF789ABABCDEtw', PRIMARY KEY ind1 ( `col5`), UNIQUE KEY ind2 ( `col4`(99))) ROW_FORMAT=DYNAMIC STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=6; CREATE TABLE gts7.tt20 (col1 varchar(9) character set utf8mb4,col2 smallint,col3 varchar(7) character set utf8mb4,col4 varchar(9), PRIMARY KEY ind1 ( `col3`), KEY ind2 ( `col1`)) AUTOEXTEND_SIZE=8M STATS_PERSISTENT=1; CREATE TABLE gts7.tt21 (col1 float,col2 varchar(105) character set latin1, PRIMARY KEY ind1 ( `col1`), UNIQUE KEY ind2 ( `col1`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=20 CHARACTER SET latin1; CREATE TABLE gts7.tt22 (col1 varchar(7) character set latin1, PRIMARY KEY ind1 ( `col1`)) ROW_FORMAT=DYNAMIC STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=23 CHARACTER SET latin1; CREATE TABLE gts7.tt23 (col1 varchar(4), PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`), KEY ind3 ( `col1`)) AUTOEXTEND_SIZE=20M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=40; CREATE TABLE gts7.tt24 (col1 varchar(9) character set latin1,col2 varchar(167),col3 float DEFAULT (col1), PRIMARY KEY ind1 ( `col2`)) STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=39 CHARACTER SET latin1; CREATE TABLE gts7.tt25 (col1 varchar(2) character set utf8mb4,col2 mediumblob,col3 longtext,col4 float,col5 smallint,col6 char(4) character set utf8mb4, PRIMARY KEY ind1 ( `col2`(18)), KEY ind2 ( `col2`(95)), UNIQUE KEY ind3 ( (CHAR(`col2`))), KEY ind4 ( `col2`(70)), KEY ind5 ( `col2`(186))) AUTOEXTEND_SIZE=8M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=30 CHARACTER SET utf8mb4; CREATE TABLE gts7.tt26 (col1 varchar(1),col2 tinyint, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col2`), KEY ind3 ( `col2`), UNIQUE KEY ind4 ( `col1`)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=38; CREATE TABLE gts7.tt27 (col1 varchar(4) character set latin1,col2 varchar(4) character set latin1,col3 smallint,col4 float,col5 float,col6 bigint DEFAULT (col14),col7 tinyint,col8 varchar(84) character set latin1 DEFAULT 'IJKLMghOPyzKLMNz0123344563F9fghij12343456opqZ01QR01x9AIJKCKLMNqrstdeMNOIJKL456786785',col9 int,col10 tinyint DEFAULT (col11),col11 float,col12 smallint,col13 float,col14 varchar(5) DEFAULT (col7),col15 mediumtext,col16 varchar(5),col17 varchar(2),col18 char(28) character set latin1,col19 point srid 4326,col20 timestamp,col21 varchar(114) character set latin1,col22 varchar(76),col23 varchar(5),col24 tinyint, UNIQUE KEY ind2 ( `col13`), KEY ind3 ( `col15`(188)), KEY ind4 ( `col17`), UNIQUE KEY ind5 ( `col13`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=28 CHARACTER SET utf8mb4; CREATE TABLE gts7.tt28 (col1 int,col2 float,col3 float,col4 smallint,col5 varchar(99) character set latin1, PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=REDUNDANT STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=13 CHARACTER SET utf8mb4; CREATE TABLE gts7.tt29 (col1 int,col2 varchar(207) character set utf8mb4,col3 bigint unsigned,col4 varchar(83),col5 float DEFAULT (col6),col6 varchar(6) character set latin1,col7 float,col8 varchar(10) character set utf8mb4) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=6; CREATE TABLE gts7.tt30 (col1 float,col2 smallint,col3 smallint unsigned,col4 char(3),col5 varchar(215) character set latin1,col6 tinyblob, PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col1`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=DYNAMIC STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=12 CHARACTER SET latin1; CREATE TABLE gts7.tt31 (col1 varchar(6),col2 varchar(82),col3 varchar(1),col4 mediumint,col5 float,col6 tinyint DEFAULT (col4)) STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=9 CHARACTER SET latin1; CREATE TABLE gts7.tt32 (col1 mediumint DEFAULT (col2),col2 varchar(6) character set latin1,col3 int,col4 json,col5 varchar(1) character set utf8mb4,col6 varchar(8) character set utf8mb4,col7 varchar(66) character set latin1,col8 varchar(5), PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col7`, `col8`)) AUTOEXTEND_SIZE=16M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=19 CHARACTER SET utf8mb4; CREATE TABLE gts7.tt33 (col1 decimal(55),col2 float,col3 bigint,col4 float, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col2`), KEY ind3 ( `col4`), KEY ind4 ( `col1`), KEY ind5 ( `col3`)) AUTOEXTEND_SIZE=8M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=29; CREATE TABLE gts8.tt1 (col1 tinyint,col2 decimal(3,1),col3 varchar(114) character set utf8mb4,col4 smallint,col5 varchar(10) character set latin1, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1; CREATE TABLE gts8.tt2 (col1 varchar(3) character set utf8mb4, PRIMARY KEY ind1 ( `col1`), UNIQUE KEY ind2 ( `col1`)) STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=24; CREATE TABLE gts8.tt3 (col1 varchar(9) character set latin1, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`), KEY ind3 ( `col1`)) AUTOEXTEND_SIZE=8M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=22 CHARACTER SET utf8mb4; CREATE TABLE gts8.tt4 (col1 char(10) character set utf8mb4,col2 smallint unsigned,col3 longtext,col4 tinyint unsigned,col5 varchar(77) character set utf8mb4 DEFAULT (col8),col6 bigint DEFAULT (RAND()*107),col7 varchar(10) character set latin1,col8 char(8), PRIMARY KEY ind1 ( `col7`)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=8 CHARACTER SET utf8mb4; CREATE TABLE gts8.tt5 (col1 date, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`), KEY ind3 ( `col1`), KEY ind4 ( `col1`)) AUTOEXTEND_SIZE=12M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=18 CHARACTER SET latin1; CREATE TABLE gts8.tt6 (col1 varchar(7) character set utf8mb4,col2 varchar(3) character set latin1,col3 varchar(242) character set utf8mb4,col4 smallint DEFAULT (col3),col5 varchar(44) character set latin1, PRIMARY KEY ind1 ( `col3`)) AUTOEXTEND_SIZE=4M STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=24 CHARACTER SET latin1; CREATE TABLE gts8.tt7 (col1 smallint unsigned,col2 varchar(245) character set utf8mb4, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col2`), UNIQUE KEY ind3 ( `col1`), KEY ind4 ( `col2`)) AUTOEXTEND_SIZE=16M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 STATS_SAMPLE_PAGES=18 CHARACTER SET latin1; CREATE TABLE gts8.tt8 (col1 mediumint unsigned,col2 tinyint,col3 tinyint,col4 tinyint unsigned,col5 varchar(80) character set utf8mb4,col6 tinyint DEFAULT (RAND()*107),col7 float,col8 int DEFAULT (col7),col9 smallint,col10 varchar(16) character set utf8mb4,col11 smallint,col12 decimal(11,2),col13 date,col14 smallint,col15 int,col16 varchar(101) character set latin1 DEFAULT (HEX(RANDOM_BYTES(55))), PRIMARY KEY ind1 ( `col16`), KEY ind2 ( `col4`), KEY ind3 ( `col4`), KEY ind4 ( `col2`), KEY ind5 ( `col5`)) AUTOEXTEND_SIZE=16M ROW_FORMAT=COMPACT STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=31 CHARACTER SET latin1; CREATE TABLE gts8.tt9 (col1 varchar(229) character set latin1 DEFAULT '7efgklmQRSTURSTUeWXYyz0678BCDEFTUVW45678DEFGH0678z01234567EFGHIYZ4567Db67CDE6789defg456opqr9ABCg5678OPQRS8mnKLMNXY34567ABChijklHIghijkldeabcde3GHIjkYZ012XgXlm67bNOPQWXY3456bcdepqr4567rcdefgm',col2 mediumblob, PRIMARY KEY ind1 ( `col2`(88))) AUTOEXTEND_SIZE=12M STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=8 CHARACTER SET latin1; CREATE TABLE gts8.tt10 (col1 char(1), PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`)) AUTOEXTEND_SIZE=4M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=40 CHARACTER SET latin1; CREATE TABLE gts8.tt11 (col1 timestamp DEFAULT (col7),col2 varchar(9) DEFAULT (col8),col3 float,col4 float,col5 varchar(8),col6 varchar(8) character set utf8mb4,col7 varchar(190) character set latin1,col8 longblob, PRIMARY KEY ind1 ( `col3`), KEY ind2 ( (RTRIM(`col2`)))) AUTOEXTEND_SIZE=4M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=40; CREATE TABLE gts8.tt12 (col1 tinyint,col2 char(223) character set utf8mb4,col3 smallint,col4 smallint,col5 varchar(204),col6 varchar(6) character set latin1,col7 varchar(107) character set latin1,col8 bigint) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1; CREATE TABLE gts8.tt13 (col1 varchar(2) character set utf8mb4 DEFAULT (col5),col2 char(6) character set latin1,col3 varchar(7) character set latin1,col4 float,col5 char(3),col6 int DEFAULT (col3),col7 varchar(4) character set latin1,col8 varchar(7), PRIMARY KEY ind1 ( `col8`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1; CREATE TABLE gts8.tt14 (col1 float,col2 json, PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=REDUNDANT STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=32; CREATE TABLE gts8.tt15 (col1 smallint,col2 tinyblob,col3 smallint,col4 timestamp(2),col5 int, PRIMARY KEY ind1 ( `col3`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=38 CHARACTER SET latin1; CREATE TABLE gts8.tt16 (col1 tinyint DEFAULT 3,col2 char(6) character set latin1,col3 varchar(10) character set latin1, PRIMARY KEY ind1 ( `col3`), KEY ind2 ( `col2`, `col1`), KEY ind3 ( `col3`), UNIQUE KEY ind4 ( `col2`), UNIQUE KEY ind5 ( `col2`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_SAMPLE_PAGES=27 CHARACTER SET latin1; CREATE TABLE gts8.tt17 (col1 char(9) character set utf8mb4,col2 varchar(186) character set latin1,col3 timestamp(1), PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`), KEY ind3 ( `col1`), KEY ind4 ( `col2`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 STATS_PERSISTENT=0 STATS_SAMPLE_PAGES=1; CREATE TABLE gts8.tt18 (col1 float,col2 decimal(7,7),col3 bigint unsigned,col4 float,col5 varchar(5), PRIMARY KEY ind1 ( `col3`, `col1`), KEY ind2 ( `col3`)) AUTOEXTEND_SIZE=8M STATS_SAMPLE_PAGES=1; CREATE TABLE gts8.tt19 (col1 float) AUTOEXTEND_SIZE=8M ROW_FORMAT=DYNAMIC COMPRESSION='ZLIB' STATS_SAMPLE_PAGES=33 CHARACTER SET utf8mb4; CREATE TABLE gts8.tt20 (col1 varchar(98) character set latin1,col2 int,col3 char(140) character set utf8mb4,col4 varchar(91) character set utf8mb4 unique DEFAULT 'cdxTUVPQ7756',col5 varchar(8) character set latin1,col6 varchar(188) character set latin1, PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col3`)) ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1 STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=30; CREATE TABLE gts8.tt21 (col1 float, PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=15; CREATE TABLE gts8.tt22 (col1 float DEFAULT (RAND()*107),col2 varchar(2) character set utf8mb4,col3 tinyint,col4 varchar(172) character set utf8mb4,col5 varchar(28),col6 float,col7 varchar(205) DEFAULT '456lmnRSTUVWXdefghlmuXxyKLMUV1UVW5Z1234JKLM89Q45678QR23STz0WGH567OPQRTUfghi6789Z0123ABCDIJKLM67vtuvwghijkuvQRSTU01223456345opqr123abc456fUVWNnop01bklmnoijkbcdefXYZ01gQRDjklbyz67823Y9ABCABCUVW12qrstu4567deb',col8 varchar(8) character set latin1, PRIMARY KEY ind1 ( `col7`), KEY ind2 ( `col3`)) STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=578; CREATE TABLE gts8.tt23 (col1 varchar(118) unique,col2 int, PRIMARY KEY ind1 ( `col1`)) AUTOEXTEND_SIZE=12M ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=5; CREATE TABLE gts8.tt24 (col1 smallint,col2 varchar(147),col3 int,col4 timestamp,col5 mediumint,col6 bigint,col7 char(5), PRIMARY KEY ind1 ( `col2`), KEY ind2 ( `col6`)) AUTOEXTEND_SIZE=16M STATS_PERSISTENT=1; CREATE TABLE gts8.tt25 (col1 tinyint,col2 float,col3 mediumint,col4 tinyint,col5 smallint,col6 decimal(57,2) DEFAULT (RAND()*107), PRIMARY KEY ind1 ( `col5`), KEY ind2 ( `col5`)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=34; CREATE TABLE gts8.tt26 (col1 char(2),col2 varchar(10),col3 varchar(146) DEFAULT 'PQRF13456efBCDEF12', PRIMARY KEY ind1 ( `col3`), KEY ind2 ( `col1`)) AUTOEXTEND_SIZE=20M STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1 CHARACTER SET latin1; CREATE TABLE gts8.tt27 (col1 mediumtext,col2 varchar(169),col3 varchar(2) character set utf8mb4,col4 varchar(7) character set latin1,col5 numeric(63,0),col6 mediumint,col7 smallint,col8 varchar(3) character set utf8mb4 DEFAULT 'OPQ',col9 int,col10 char(7) character set utf8mb4 DEFAULT (HEX(RANDOM_BYTES(55))),col11 char(8) character set utf8mb4,col12 float,col13 smallint,col14 datetime(1),col15 varchar(244),col16 datetime(0),col17 char(112) character set latin1,col18 double,col19 varchar(195),col20 varchar(207),col21 varchar(225),col22 varchar(136) character set latin1,col23 varchar(8) character set utf8mb4,col24 varchar(9) character set utf8mb4,col25 varchar(93),col26 varchar(146),col27 float,col28 tinyint,col29 float,col30 char(10),col31 tinyint,col32 varchar(128) character set utf8mb4,col33 varchar(3),col34 float,col35 char(2),col36 varchar(148) character set latin1,col37 varchar(8) character set latin1,col38 varchar(9) character set latin1,col39 int,col40 varchar(33) character set utf8mb4,col41 varchar(8) character set utf8mb4,col42 timestamp,col43 float,col44 blob,col45 smallint, PRIMARY KEY ind1 ( `col25`), KEY ind2 ( `col16`), KEY ind3 ( `col19`), KEY ind4 ( `col33`)) AUTOEXTEND_SIZE=8M ROW_FORMAT=DYNAMIC STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=25; CREATE TABLE gts8.tt28 (col1 date,col2 double,col3 varchar(2) character set utf8mb4, PRIMARY KEY ind1 ( `col3`)) ROW_FORMAT=DYNAMIC STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=1; CREATE TABLE gts8.tt29 (col1 varchar(121),col2 int,col3 varchar(4),col4 varchar(6)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=20 CHARACTER SET utf8mb4; CREATE TABLE gts8.tt30 (col1 float,col2 varchar(58)) AUTOEXTEND_SIZE=20M STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=24 CHARACTER SET utf8mb4; CREATE TABLE gts8.tt31 (col1 mediumint unsigned, PRIMARY KEY ind1 ( `col1`), KEY ind2 ( `col1`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=DYNAMIC STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=14; CREATE TABLE gts8.tt32 (col1 bigint,col2 varchar(2),col3 varchar(149) character set utf8mb4, PRIMARY KEY ind1 ( `col3`)) AUTOEXTEND_SIZE=4M ROW_FORMAT=REDUNDANT STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 STATS_SAMPLE_PAGES=39 CHARACTER SET latin1; CREATE TABLE gts8.tt33 (col1 varchar(145),col2 smallint,col3 decimal(7,2),col4 decimal,col5 timestamp(0),col6 linestring srid 4326,col7 varchar(1) character set latin1, PRIMARY KEY ind1 ( `col3`), KEY ind3 ( `col3`)) STATS_AUTO_RECALC=1 STATS_PERSISTENT=1 CHARACTER SET utf8mb4;