Analysis over op on array column failing in RC6

[michae1T]

@jatcwang see test suites using analysis targeting queries with array columns now fail on upgrade to 1.0.0-RC6

Array[A] → ARRAY (_yyy)
Array[A] is not coercible to ARRAY (vendor's name:
_yyy) according to the JDBC specification.
Expected schema type was ARRAY.

possibly due to #2091

meta:

  import doobie.postgres.implicits.unliftedStringArrayType

  given metaNonEmptySetYYY: Meta[NonEmptySet[YYY]] =
    new Meta[NonEmptySet[YYY]](
      get = unliftedStringArrayType.get.temap(
        SortedSet.from(_).toNes.fold(Left("Empty set found")) { strings =>
          Try(strings.map(YYY.valueOf)).toEither.left.map(_.getMessage)
        }
      ),
      put = unliftedStringArrayType.put.tcontramap(_.map(_.toString).toSortedSet.toArray),
    )

postgres

CREATE TYPE yyy AS ENUM ( 'a');

... col yyy[] NOT NULL ...