Manticore 5.0.2 min/max function doesn't work as expecting ...

[pavelnemirovsky]

Describe the bug

It looks like max function doesn't work correctly, see below:

mysql> desc index;
+-------------------+-----------+------------+
| Field             | Type      | Properties |
+-------------------+-----------+------------+
| id                | bigint    | columnar   |
| article_body_hash | text      | stored     |
| content           | text      | indexed    |
| publish_date      | timestamp | columnar   |
| internal_id       | string    | columnar   |
| tags_id           | json      |            |
| tags_name         | json      |            |
| entities_id       | json      |            |
+-------------------+-----------+------------+

mysql> select internal_id, publish_date from index order by publish_date desc;
+----------------------------------+--------------+
| internal_id                      | publish_date |
+----------------------------------+--------------+
| df63545a6e7fa7bb8fc2769e0f04e54b |   1663116129 |
| 6a112fc2820cccda46b8e3a3d0a25a4e |   1663116124 |
| 813458b64acb4253bcfcc90c1bf57785 |   1663116115 |
| 456252179ef306f006f31ab9319246c0 |   1663116092 |
| 33c1333affd0d6b6f8622c172aea8c0b |   1663116088 |
| d95abbd08f5acfb17a1aebaf30700d33 |   1663116088 |
| 650586502c322080300a5e1b1bf9a57d |   1663116087 |
| 35c5dcbb37dd3f1f2fca8c1cb5fc90ae |   1663116071 |
| 09f93dbed887e32c214629b4d78177bd |   1663116068 |
| 726e461e29530e753fc78c327a3cfed8 |   1663116068 |
| 528ab97f7c5fe4f05c7aec408a277427 |   1663116068 |
| 5f0155434f547db70e3dbc24f196e628 |   1663116068 |
| ce1a2f8d6b1605187d24beb9efdd20a2 |   1663116062 |
| afb3df6759826d0978091a5544388c6c |   1663116058 |
| b32cc9d5fe1f60d89b784c847b386afe |   1663116054 |
| 814c7d3cc73abc95ead6db6e28590393 |   1663116054 |
| 330b75af0866e8191fc190d359381713 |   1663116054 |
| b66fe91136c8ebab4b2faa5861da38f4 |   1663116048 |
| c9ed9b8096444f877a5d1ae09959d448 |   1663116048 |
| 01028d951b1bb563d308be8186f2c879 |   1663116048 |
+----------------------------------+--------------+
20 rows in set (0.00 sec)

mysql> select max(publish_date) from index;
+-------------------+
| max(publish_date) |
+-------------------+
|        1662928732 |
+-------------------+
1 row in set (0.01 sec)

mysql> select min(publish_date) from index;
+-------------------+
| min(publish_date) |
+-------------------+
|        1662928732 |
+-------------------+
1 row in set (0.00 sec)

Expected behavior I expect to get a response from my above query that max function is equal to 1663116129 instead, I am getting 1662928732.

Describe the environment:

• Manticore Search version (top line in output of bin/searchd -v or bin/indexer -v): e.g. 3.5.0 1d34c49@200722 release: 5.0.2
• OS version (uname -a if on a Unix-like system): Ubuntu 18.04