Treat timestamp with spring-data-r2dbc in non-UTC timezone

a.kt

val connectionFactory = ConnectionFactories.get("r2dbc:mysql://[email protected]:3306/test")

// Wrapper to initialize each connections
val connectionFactory2 = object : ConnectionFactory {
    override fun getMetadata(): ConnectionFactoryMetadata = connectionFactory.metadata
    override fun create(): Publisher<out Connection> =
        connectionFactory
            .create()
            .toMono()
            .flatMap { connection ->
                connection
                    .createStatement("SET time_zone = 'Asia/Tokyo'")
                    .execute()
                    .toMono()
                    .map { connection }
            }
}

val client = DatabaseClient.create(connectionFactory2)

client.insert()
    .into("person")
    .value("name", "John Doe")
    .value("birthday", LocalDateTime.of(2019, 10, 20, 10, 22))
    .await()

val person = client.select()
    .from("person")
    .`as`(Person::class.java)
    .fetch()
    .awaitFirst()
println(person)
// => Person(id=1, name=John Doe, birthday=2019-10-20T10:22)