Ability to configure Row for returning booleans instead of Byte in MySQL reactive client

Question

Ability to configure Row for returning booleans instead of Byte in MySQL reactive client

olofumark opened this issue a year ago · 2 comments

Describe the feature

io.vertx.sqlclient.Row needs a way to specify preference for the retrieval of all boolean columns as booleans instead of Byte.

Currently all boolean columns are served as Byte unless you explicitly call getBoolean() for individual fields.

Use cases

Reading data and streaming without having to do extra conversions.
Consistency with query expectations e.g after doing SELECT * FROM ... WHERE sent = true; only to be served the Byte equivalent of the boolean fields which(though might be the low level storage format) is not very helpful unless first converted.
Very helpful for migrating from the legacy JDBC client if you already have frontend systems relying on true and false where they will break if suddenly served with 0's and 1's.

Answer 1 · 2023-10-13T07:29:31.000Z

Thanks for reporting @olofumark

Thoughts @BillyYccc ?

Answer 2 · 2023-10-15T15:30:18.000Z

I was aware of mysql jdbc providing a dedicated transformation option, I wonder maybe we could instead pick up and support the custom data type codec to cover such use cases.