Numeric codec doesn't seem to work about skunk HOT 9 CLOSED

val insertOrder: Command[UserId ~ Order] =
  sql"""
      INSERT INTO orders
      VALUES ($varchar, $varchar, $varchar, $varchar, $numeric)
     """.command.contramap {
    case id ~ o =>
      o.id.value.toString ~ id.value.toString ~ o.paymentId.value.toString ~ o.items.asJson.noSpaces ~ o.total.value
  }

  def create(
      userId: UserId,
      paymentId: PaymentId,
      items: List[CartItem],
      total: USD
  ): F[OrderId] =
    sessionPool.use { session =>
      session.prepare(insertOrder).use { cmd =>
        GenUUID[F].make[OrderId].flatMap { id =>
          val itMap = items.map(x => x.item.uuid -> x.quantity).toMap
          val order = Order(id, paymentId, itMap, total)
          cmd.execute(userId ~ order).as(id)
        }
      }
    }

val codec: Codec[UserId ~ Order] =
  (varchar ~ varchar ~ varchar ~ varchar ~ numeric).imap {
    case o ~ u ~ p ~ i ~ t =>
      ju.UUID.fromString(u).coerce[UserId] ~
        Order(
          ju.UUID.fromString(o).coerce[OrderId],
          ju.UUID.fromString(p).coerce[PaymentId],
          decode[Map[ItemId, Quantity]](i).getOrElse(Map.empty),
          t.coerce[USD]
        )
  } {
    case id ~ o =>
      o.id.value.toString ~ id.value.toString ~ o.paymentId.value.toString ~ o.items.asJson.noSpaces ~ o.total.value
  }

val insertOrder: Command[UserId ~ Order] =
  sql"""
      INSERT INTO orders
      VALUES ($codec)
     """.command

val insertItem: Command[ItemId ~ CreateItem] =
  sql"""
      INSERT INTO items
      VALUES ($varchar, $varchar, $varchar, $numeric, $varchar, $varchar)
     """.command.contramap {
    case id ~ i =>
      id.value.toString ~ i.name.value ~ i.description.value ~ i.price.value ~ i.brandId.value.toString ~ i.categoryId.value.toString
  }

val insertCity: Command[City] =
  sql"""
       INSERT INTO city
       VALUES ($int4, $varchar, $bpchar(3), $varchar, $int4)
     """.command.contramap { 
          case c => c.id ~ c.name ~ c.code ~ c.district ~ c.pop 
        }