Old Flyway dependency cannot auto detect SLF4J 2.0

[huyi0912]

Expected Behavior

Logging output should respect on log level setting.
For example add following to logback.xml should print out all sql executed
<logger name="org.flywaydb.core.internal.sqlscript" level="DEBUG">
<appender-ref ref="STDOUT"/>
</logger>

Actual Behaviour

Setting log level to debug but always got info level only

Steps To Reproduce

By following guide "ACCESS A DATABASE WITH MICRONAUT DATA R2DBC". When I try to see the logging for real sql executed by flyway. Found no matter how detail level I setup.Always only info level was logged.After some digging find flyway have a bug detecting SLF4j 2.0(flyway/flyway#3730). And it's been fixed at Flyway 9.22.2 (2023-09-21).But latest micronaut depends on older 9.21.2. Temporary solution is add dependency(Maven)
<dependency>
<groupId>org.flywaydb</groupId>
<artifactId>flyway-core</artifactId>
<version>9.22.3</version>
</dependency>

Environment Information

Mac Sonoma 14
JDK Oracle GraalVM 21+35.1

Example Application

No response

Version

4.1.4,4.1.5