Incorrect Redshift search_path parsing

[joshyaustin]

What version of Flyway are you using?

4.2.0

Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin, SBT plugin, ANT tasks)

Java API- flyway-core-4.2.0

What database are you using (type & version)?

amazon redshift

What operating system are you using?

OSX, linux

What did you do?

(Please include the content causing the issue, any relevant configuration settings, and the command you ran)
When flyway DB migration is initiated in a java-spring-boot application connecting to Amazon Redshift DB using redshift DB driver, it parses out the schema name wrongly.

flyway-core-4.2.0] Flyway.java 811 : originalSchema variable value is "$user",public
org.flywaydb.core.internal.dbsupport.redshift.RedshiftDbSupport.getOriginalSchema() // line 37
extracts "ublic" instead of "public" (the leading 'p' is stripped).

What did you expect to see?

schema name should be parsed correctly ("public" in this case)

What did you see instead?

org.flywaydb.core.internal.dbsupport.redshift.RedshiftDbSupport.getOriginalSchema() // line 37
extracts "ublic" instead of "public" (the leading 'p' is stripped)