Building Search index fails with Data too long for column 'route' at row 1

[MacJoom]

I updated a site with over 88000 articles. Some of them have very long aliases, close to 400

Steps to reproduce the issue

Go to Components, Smart Search, Index - click Index to run the indexing process

Expected result

Index is built completly

Actual result

Process fails with "Data too long for column 'route' at row 1" at some point

System information (as much as possible)

Joomla 5.2.0
PHP 8.2
MariaDB i guess it fail with postgresql too

Additional comments

A PR from me is on the way.

[Quy]

See #43545 for the suggested fix.

[Quy]

Closing as duplicate of #43545