Cancelling a query from RStudio

[MarkMc1089]

Issue Description and Expected Result

Unable to gracefully stop a sent query (specifically to Oracle SQL server) from RStudio. When wanting to stop a running query, only way at present is to either wait or force quit RStudio. After force quitting the query does seem to stop eventually but the time is variable, on the order of several minutes.

See the issue below, which I followed Hadley's advice on to raise here also.
rstudio/rstudio#6287 (comment)

Database

Oracle Database 19c

Reproducible Example

Not really applicable, any long query that you subsequently want to stop before it finishes naturally.

[hadley]

@detule have you look at this problem at all? It's typically a matter of ensuring that we check for user interrupts in the tight loop that retrieves data from the database.

[detule]

Hi Hadley:

Yes - looked at this I think couple of years ago in a different context. The tight loop is relatively straightforward. We probably need a bit of care ( and testing ) to ensure we clean up well and leave the connection in a good state.

I'll resurrect that patch.

[hadley]

Duplicate of #433