Ciao Marco, grazie millie for for your investigation and effort.

With your explanations I was able to understand the problem. Therefore I adapted my example but I have still a problem.

I have created another example with a minimum setup to isolate my problem. This time I also used better readable names. 😉

This is what I’m trying to achieve:

Here the testcase:

hibernate-orm-6-HHH-15111-Example2.zip

Here the error-output:

I guess that hibernate has to create “on c1_1.sequence=d1_0.sequence” instead.

But maybe this is also not allowed in general or I did something wrong. Would be very nice if you can have once again a look to that.

Grazie

Marco