R2dbc features are unavailable

[x2d7751347m]

I have a table class with a ByteArray parameter like this:

@Serializable
data class ImageFile(
    var data: ByteArray? = null,
)

If I try

db.runQuery {
        QueryDsl.create(Meta.imageFile)
    }
// or
db.runQuery {
            QueryDsl.insert(imageFileDef).single(imageFile)
        }

Then it throws an exception

org.mariadb.r2dbc.message.server.ErrorPacket [WARN] (Loggers.java:299) - Error: 'Unknown data type: 'bytea'' sqlState='HY000' code=4161 
Exception in thread "main" io.r2dbc.spi.R2dbcTransientResourceException: [4161] [HY000] Unknown data type: 'bytea'
	at org.mariadb.r2dbc.ExceptionFactory.createException(ExceptionFactory.java:75)
	at org.mariadb.r2dbc.ExceptionFactory.createException(ExceptionFactory.java:25)
	at org.mariadb.r2dbc.ExceptionFactory.from(ExceptionFactory.java:83)
	at org.mariadb.r2dbc.client.MariadbSegmentResult$MariadbErrorSegment.exception(MariadbSegmentResult.java:345)
	at org.mariadb.r2dbc.client.MariadbSegmentResult.lambda$getRowsUpdated$1(MariadbSegmentResult.java:153)
	at reactor.core.publisher.FluxHandleFuseable$HandleFuseableSubscriber.onNext(FluxHandleFuseable.java:179)
	at reactor.core.publisher.FluxFilterFuseable$FilterFuseableConditionalSubscriber.onNext(FluxFilterFuseable.java:337)
	at reactor.core.publisher.FluxHandleFuseable$HandleFuseableConditionalSubscriber.onNext(FluxHandleFuseable.java:505)
	at reactor.core.publisher.FluxWindowPredicate$WindowFlux.drainRegular(FluxWindowPredicate.java:670)
	at reactor.core.publisher.FluxWindowPredicate$WindowFlux.drain(FluxWindowPredicate.java:748)
	at reactor.core.publisher.FluxWindowPredicate$WindowFlux.subscribe(FluxWindowPredicate.java:823)
	at reactor.core.publisher.Mono.subscribe(Mono.java:4495)
	at kotlinx.coroutines.reactive.ChannelKt.toChannel(Channel.kt:24)
	at kotlinx.coroutines.reactive.ChannelKt.toChannel$default(Channel.kt:22)
	at org.komapper.r2dbc.R2dbcExecutor$execute$3$1.invokeSuspend(R2dbcExecutor.kt:219)
	at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
	at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:106)
	at kotlinx.coroutines.EventLoopImplBase.processNextEvent(EventLoop.common.kt:280)
	at kotlinx.coroutines.BlockingCoroutine.joinBlocking(Builders.kt:85)
	at kotlinx.coroutines.BuildersKt__BuildersKt.runBlocking(Builders.kt:59)
	at kotlinx.coroutines.BuildersKt.runBlocking(Unknown Source)
	at kotlinx.coroutines.BuildersKt__BuildersKt.runBlocking$default(Builders.kt:38)
	at kotlinx.coroutines.BuildersKt.runBlocking$default(Unknown Source)

build.gradle.kts

dependencies {
    platform("org.komapper:komapper-platform:1.12.0").let {
        implementation(it)
        ksp(it)
    }
    implementation("org.komapper:komapper-starter-r2dbc")
    implementation("org.komapper:komapper-dialect-mariadb-r2dbc")
    ksp("org.komapper:komapper-processor")
    runtimeOnly("org.komapper:komapper-slf4j:$komapperVersion")
    api("io.r2dbc:r2dbc-pool:1.0.1.RELEASE")
}

How do I fix it?

[nakamura-to]

I'm sorry I didn't notice this post.
I think this is a bug in Komapper.
I will fix it in the next release.

Use varbinary instead of bytea in your DDL script.

val query = QueryDsl.executeScript("create table imagefile (id integer not null, data varbinary(500), constraint imagefile primary key(id))")
db.runQuery(query)

[x2d7751347m]

I got it. Thank you!