Partitioning by Timestamp with to_days function but PKEY is ID

[Frank Schuster]

Hello together,

I think my problem is known but I don't know any solution for this problem.

I want a primary key ID with auto_increment but the partitioning is only using the timestamp with the to_days function.

PARTITION BY RANGE (TO_DAYS(timestamp))(...);

But then I get ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function

I know that I didn't use the PKEY ID but can I avoid the problem with a trick?
Something like this (TO_DAYS(timestamp)+id-id <-- this get the same error 1503) or something else?