intermediate tables of many to many relations are not qualified with schema in generated queries

[dobe]

trafficstars

Expected Behavior

when i have a ManyToMany relation between entities with a defined schema e.g:

@Table(name = "channel_assets", schema = "myschema")
@Table(name = "assets", schema = "myschema")
@Table(name = "channels", schema = "myschema")

and defining a channels property on assets queries schould qualify the intermediate table with the schema of the llinked tables.

or if i define:

@JoinTable(name="channel_assets", schema="catalog") 

on the reference attribute, then the schema argument to the annotation should be used

Actual Behaviour

the intermediate table is never qualified with a schema, even when defining a JoinTable explicitly.

Note: the name of the JoinTable annotation gets applied as expected, however the schema is always ignored

Steps To Reproduce

No response

Environment Information

osx, postgres, r2dbc, micronaut

Example Application

No response

Version

3.3.0