-- source include/have_innodb.inc drop table if exists `t1`; create table `t1` (`a` int primary key) engine=innodb ; select 1 from `t1` join `t1` `a` using(`a`) group by `t1`.`a`,`t1`.`a`; drop table `t1`;