run-time error: operator does not exist: timestamp without time zone < text

[jerbaroo]

Third run-time error using beam in the last week 👀 Based on the following SQL error messages it seems that the RHS of the <. is being generated into SQL of type Text 😕

  Db.runDelete $ Beam.delete S.userAccountServiceDb.authTokenTable
      let extendedLogin = Beam.subquery_
            $ fmap SUA.extendedLogin
            $ Beam.filter_ (\row' -> SUA.userID row' ==. userID)
            $ Beam.all_ (S.userAccountsTable S.userAccountServiceDb)
      in  timeCreated <. Beam.ifThenElse_ extendedLogin
            (Beam.val_ (currentTime - via @Int64 authTokenExpiry))
            (Beam.val_ (currentTime - via @Int64 authTokenExpiryExtended))

[LaurentRDC]

Would it be possible to create a reproducible example?

[tathougies]

My guess would be that timeCreated is mistakenly a QExpr of type Text. ifThenElse_ and val_ are both 'dumb' an depend on the type checker to say what type it ought to be. There must be a mismatch of the beam and database schema.