search

com-lihaoyi / scalasql

Scala ORM to query SQL databases from Scala via concise, type-safe, and familiar case classes and collection operations. Connects to Postgres, MySql, H2, and Sqlite out of the box
194 stars 22 forks source link

empty Option[UUID] datatypes fail to write on Postgres and Hikari #41

Closed jlvertol closed 1 month ago

jlvertol commented 1 month ago

on Hikari and Postgres the error is:

ERROR: column "my_uuid" is of type uuid but expression is of type bytea
  Hint: You will need to rewrite or cast the expression

I confirmed this error by going to DataTypeTests and changing the UUID field to Option[UUID] and the value to fill in as None

jlvertol commented 1 month ago

Commit merged fixed this issue