high compile cpu when using long in list with varbinary type

[dbsid]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

run a select statement with long in list with varbinary type

select * from t
where
`id` IN (...);

CREATE TABLE `t` (
  `id` varbinary(16) NOT NULL,
...

2. What did you expect to see? (Required)

fast compile

3. What did you see instead (Required)

long compile time

4. What is your TiDB version? (Required)

v5.3.1

[dbsid]

The new pdqsort might help reduce the cpu on sort in this case.
https://news.ycombinator.com/item?id=31106157

[zanmato1984]

This is more like a performance enhancement rather than a bug. Changing some labels.