Because the first key is a single field unique

пт, 12 янв. 2024 г., 22:38 Sergei Golubchik <serg@mariadb.org>:
Hi, Nikita,

On Jan 12, Nikita Malyavin wrote:
> The new behavior can be found in this commit, the line is highlighted
> https://github.com/MariaDB/server/commit/09bf45a89ee23adc7ce05c46ba859a74b1367f92#diff-1ace7ee02edfe8a4386a6b3c8e6e602c154303e43d13246ecbf9584d6d9994b8R528

Why do you have ER_DUP_ENTRY?
There are three non-overlapping ranges, they all can have id=1 without
conflicting.

Regards,
Sergei
Chief Architect, MariaDB Server
and security@mariadb.org