create table if not exists bug_test (col int primary key not null);

insert into bug_test values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);

select crc32(col), count(*) c  from bug_test group by 1;
select count(col) from bug_test where crc32(col)=2147483647;