Null in array serialized wrongly

[Katrix]

Using code like this

implicit private val listOptionStrType: DriverJdbcType[List[Option[String]]] =
  new SimpleArrayJdbcType[String]("text")
    .mapTo[Option[String]](Option(_), _.orNull)
    .to(_.toList)

Trying to insert a None in the list produces an empty string for that element, and not the NULL identifier. For example, trying to insert List(Some("[2.3,)"), Some("[0.3.0,)"), None, Some("7.1.0"), None)
produces the error org.postgresql.util.PSQLException: ERROR: malformed array literal: "{"[2.3,)","[0.3.0,)",,7.1.0,}".

From the Postgres docs, NULL values should be written as null, and not as an empty string

To set an element of an array constant to NULL, write NULL for the element value. (Any upper- or lower-case variant of NULL will do.)

[Katrix]

Here's a working workaround which I assume works on the fact that String is a primitive

implicit private val listOptionStrType: DriverJdbcType[List[Option[String]]] =
  new SimpleArrayJdbcType[String]("text")
    .to[List](
      _.map(Option(_)).toList.asInstanceOf[List[String]],
      _.asInstanceOf[List[Option[String]]].map(_.orNull)
    )
    .asInstanceOf[DriverJdbcType[List[Option[String]]]]

[tminglei]

@Katrix well, I missed to test List[Option[_]].

[tminglei]

@Katrix fixed, pls help double check. Thanks!