SQL statements in <sql> tag are not using defaultSchema when configured with MultiTenantSpringLiquibase
Description
Environment
Spring Boot 2.0.1
Activity
Show:
Details
Details
Reporter
Gulraiz Malhi
Gulraiz MalhiComponents
Affects versions
Priority
Created May 8, 2018 at 12:47 PM
Updated May 8, 2018 at 12:47 PM
When you configure multiple schemas using MultiTenantSpringLiquibase, it should use the provided schema to execute the raw sql statements given in <sql> tags. It is instead using system default schema.
e.g given a statement update person set name = 'Alpha' where schema name is not explicit, it should have used the provided schema.
I suggest we should pass the schema name as a parameter to changelog file, so it can be used in raw sql statements incase of multiple schemas.