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.
In the process of migrating some
selectSourcecalls toselectCursor, I've run into the following runtime error:If I switch from
selectCursortotransPipe (withCompatibleBackend @SqlBackend) $ selectSourceit 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.