haskell-beam / haskell-beam/beam

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

Open
#704 2 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
Haskell
Stars
635
Forks
193
PR merge metrics
No merged PRs in 30d

Description

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 😕

```hs
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))
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.