uuid values are not properly escaped in subquery

[ousenko]

Usually there's no problem executing queries with UUID params. In debugger, statement might look kinda this:

... FROM some_table WHERE some_table.id = '19508260-d913-11e8-9f8b-f2801f1b9fd1'::uuid ...

However, when doing subquery ...:

SomeTable.join(OtherTable, JoinType.INNER, SomeTable.id, OtherTable.otherId)
      .select {...} 
      .withDistinct(true)
      .count()

...uuid is not properly escaped :

SELECT COUNT(*) FROM (SELECT DISTINCT ... ON ... WHERE some_table.some_id = d821af77-f698-4141-8f2b-79a14fba0b0f and ...)

..which results in exception:

org.postgresql.util.PSQLException: ERROR: syntax error at or near "f2b"
  Position: 727

[Tapac]

Could you provide an exact query, because I can see a subquery part in one provided above?

[ousenko]

Exact query is:

TableA.join(TableB, JoinType.INNER, TableA.id, TableB.refId)
                    .select {
                        (TableB.someUUIDField eq someUUIDVal) and
                                (TableA.otherField less otherVal)
                    }
                    .withDistinct(true)
                    .count()

object TableA ... {

   val id = uuid("id").primaryKey()
   ...

}

object TableB ... {

  val refId = uuid("ref_id").references(TableA.id /*, restrict cascade */)

  val someUUIDField = uuid("ref_to_table_c").references(TableC.id /*, restrict cascade */)
   ...

}