I have two active schemas. I’ve created a set of entities for which I’ve annotated each one of them with
@Table(catalog = "secondary", schema = "secondary"). All entities annotated as being part of secondary schema were created correctly. However one entity has a @ManyToMany relationship to another entity. Although both entities are part of schema “secondary“, the relationship entity was created in “primary“ schema. This is counterintuitive since all entities are in secondary schema and this goes against the idea of isolating entities in their own schemas. Further, there is no way to specify in which schema the relationship entity is supposed to be created automatically.
Ubuntu 18.04, Percona MySQL 8