create table `t1`(`a` longtext)engine=innodb charset=utf8; Warnings: Warning 1286 Unknown table engine 'innodb' Warning 1266 Using storage engine MyISAM for table 't1' insert into `t1` values (repeat('a',@@global.max_allowed_packet)); insert into `t1` values (repeat('b',@@global.max_allowed_packet)); explain extended select distinct 1 from `t1`, (select distinctrow `a` as `away` from `t1` group by `a` with rollup) as `d1` where `t1`.`a` = `d1`.`a`; ERROR 42S22: Unknown column 'd1.a' in 'where clause' drop table `t1`;