· 8 years ago · Apr 24, 2018, 11:04 AM
1flush tables;
2set max_sort_length=1;
3drop table if exists `g1`;
4create table `g1`(`a` decimal(53,23) not null,key (`a`))engine=innodb;
5insert into `g1` values (0),(0),(-1),(1);
6select 1 from `g1`,g1 `g2` group by g1.a desc limit 1;