Set LocalDateTime as Default Java Type for TIMESTAMP/DATETIME

asyncer-io / r2dbc-mysql

Reactive Relational Database Connectivity for MySQL. The official successor to mirromutth/r2dbc-mysql(dev.miku:r2dbc-mysql).

https://r2dbc.io

Apache License 2.0

195 stars 21 forks source link

Set LocalDateTime as Default Java Type for TIMESTAMP/DATETIME #135

Closed jchrys closed 1 year ago

jchrys commented 1 year ago

Motivation: The current default JavaType(ZonedDateTime) for TIMESTAMP and DATETIME columns does not align with r2dbc-community (especially org.mariadb:r2dbc-mariadb) and previous version (dev.miku:r2dbc-mysql).

Modification: Set LocalDateTime as the default Java type for TIMESTAMP and DATETIME columns.

Result: Ensures compatibility with the r2dbc-driver community. resolves https://github.com/asyncer-io/r2dbc-mysql/issues/130.

jchrys commented 1 year ago

tested against various tcks(spring-data-r2dbc, micronaut-data(r2dbc), r2dbc-spi)

jchrys commented 1 year ago

@JohnNiang, @mobidick1969 PTAL :D