drop table if exists t; create table t ( c9001 varchar(21759) not null, c9004 varchar(31334) not null, c9008 varchar(5112) not null, c9009 char(187) not null, c9010 char(127) not null, c9011 char(10), c9012 char(82), c9013 char(129), c9020 char(68), c9021 char(226), c9022 char(21) not null, c9023 char(111) not null, c9024 char(202), c9025 char(172) not null, c9027 char(76) not null, c9029 varchar(3713) not null, c9033 char(241) not null, c9034 char(79), c9036 char(145) not null, c9037 char(135), c9038 char(114) not null, c9039 char(12), c9042 char(39) not null, c9045 char(198) not null, c9046 char(248) not null, c9047 char(44) not null, c9048 char(185) not null, c9049 char(44) not null, c9054 char(186), c9057 char(124), c9058 char(195) not null, c9059 char(111), c9063 char(3) not null, c9068 char(18) not null, c9074 char(2), c9082 char(54), c9148 char(17)) engine=innodb default charset=latin1 row_format=dynamic; insert into t values (); insert into t values ('','eo','vu','kpn','','cz','wuhpm','un','nzzfzf','njhu','wscxrm','kbkhcgty',' zlpbfes','urlf',' tczfv','c awfa kp',' odk','xk','h fqi','pqaos','kor pru','','qzq','shr','cvlvmo',' izkobd','','',' im jazml','u z','trqv','','phz','d c','du',' rguzoqy z','bd wlt z'); insert into t values ('psirgqpx','yduvcijk','wfh','fs','jfcaffiy','e agpujk','nnxkj','jktw','m','xpmeysg','kxfm r','slwj x','',' s','uyimn','','','gji rltzr','tjcklxvv','jhk','rgdkt','k wqki','p','jsf','nji','aywlbtlhmd','','gb bmcr','','qhga','dtspufy','uytxhibss','axi',' s','wj','cwsvcbhbqo','pz'); set sql_mode=""; set global internal_tmp_disk_storage_engine=innodb; select 1 from t group by c9027 order by c9068,c9023,c9059,c9034,c9033,c9036,c9021,c9021,c9033, c9074,c9082,c9011,c9039,c9047,c9045,c9082,c9048,c9010, c9038,c9047,c9021,c9049,c9045,c9011,c9042,c9036,c9013, c9048,c9148,c9047,c9082,c9054,c9038,c9068,c9025,c9011, c9148,c9048,c9048,c9074,c9068,c9011,c9039,c9021,c9045, c9021,c9037,c9013,c9027,c9011,c9024,c9029,c9036,c9038, c9011,c9033,c9059,c9054,c9049,c9010,c9004,c9054,c9001, c9047,c9148,c9021,c9008,c9034,c9021,c9010,c9054,c9008, c9054,c9059; show warnings;