Closed mmaryo closed 2 years ago
It looks like a bug
CryptoExchanges(null, null) Should generates this request : INSERT INTO "common"."CryptoExchanges" VALUES (DEFAULT, DEFAULT);
CryptoExchanges(null, null)
INSERT INTO "common"."CryptoExchanges" VALUES (DEFAULT, DEFAULT);
But I see it generates: INSERT INTO "common"."CryptoExchanges" VALUES (DEFAULT)
INSERT INTO "common"."CryptoExchanges" VALUES (DEFAULT)
With an error : Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Column count does not match; SQL statement:
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Column count does not match; SQL statement:
I join a project with last version of Spring boot, Java, Kotlin and H2 R2dbc
You can find a test inside that generate this error And an SQL script for init the DB
@Test fun findByExchangeCodeNotNull() { // given val uni = CryptoExchanges(null, "uni") val null1 = CryptoExchanges(null, null) cryptoExchangesRepository.saveAll(listOf(uni, null1)).collectList().block() // when val res = cryptoExchangesRepository.findByExchangeCodeNotNull() // then res.`as`(StepVerifier::create) .expectNextMatches { it.id == 1L && it.exchangeCode == "uni" } .expectNextMatches { it.id == 2L && it.exchangeCode == null} .verifyComplete() } CREATE SCHEMA "common"; CREATE TABLE "common"."CryptoExchanges" ( "Id" SERIAL NOT NULL, "ExchangeCode" character varying(30) ); INSERT INTO "common"."CryptoExchanges" VALUES (DEFAULT, 'crypto'); INSERT INTO "common"."CryptoExchanges" VALUES (DEFAULT, DEFAULT);
demo.zip
Best
This issue tracker hosts bug reports and feature requests for the R2DBC specification. Looking at your code, it seems related to Spring Data.
@mp911de thx I write to spring data now
Bug Report
It looks like a bug
CryptoExchanges(null, null)
Should generates this request :INSERT INTO "common"."CryptoExchanges" VALUES (DEFAULT, DEFAULT);
But I see it generates:
INSERT INTO "common"."CryptoExchanges" VALUES (DEFAULT)
With an error :
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Column count does not match; SQL statement:
I join a project with last version of Spring boot, Java, Kotlin and H2 R2dbc
You can find a test inside that generate this error And an SQL script for init the DB
demo.zip
Best