Tables created in wrong schemas when specifying entity catalog/schema

Description

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.

Environment

Ubuntu 18.04, Percona MySQL 8

Status

Assignee

Unassigned

Reporter

Sergiu Hlihor

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Feedback Requested

2019/09/10

Feedback Requested By

Andrea Boriero

Components

Affects versions

5.4.4

Priority

Major