`sqlErrorMsg = "cursor \"temp1\" does not exist"`

[dnikolovv]

In the process of migrating some selectSource calls to selectCursor, I've run into the following runtime error:

ResourceCleanupException {rceOriginalException = Just (SqlError {sqlState = "34000", sqlExecStatus = FatalError, sqlErrorMsg = "cursor \"temp1\" does not exist", sqlErrorDetail = "", sqlErrorHint = ""}), rceFirstCleanupException = SqlError {sqlState = "", sqlExecStatus = FatalError, sqlErrorMsg = "connection disconnected", sqlErrorDetail = "", sqlErrorHint = ""}, rceOtherCleanupExceptions = []}

If I switch from selectCursor to transPipe (withCompatibleBackend @SqlBackend) $ selectSource it works fine.

For simpler queries it works fine, it's only on this "more complicated" one that it fails (basically 4 joins).

Will try to provide a minimal repro when I get the time. Just leaving this here for now.

[ivb-supercede]

Thanks for the issue!

I'd be interested to see a repro for this when you have the time to write one. My first impression is that this is an issue with how the call-site is managing resources - but it's very possible that the library has a resource bug.

[ivb-supercede]

Any luck with reproducing this?

[dnikolovv]

Ah, sorry, I don't think I can remember what caused this exactly.

We just ended up not using the library because we couldn't figure it out :/