Bug: Cancel button doesn't stop query when clicked immediately after Run

[coderabbitai]

Description

A bug has been identified with the cancel button functionality in the WebUI. When a user clicks "Run" and then immediately clicks "Cancel," the query won't actually stop.

Expected Behavior

The query should be cancelled when the Cancel button is clicked.

Actual Behavior

The query continues running despite the Cancel button being clicked immediately after Run.

Suspected Cause

This might be because Presto's cancel route returns success even if queries aren't submitted yet.

Potential Resolution

This bug will probably be automatically fixed after we handle query status correctly in the client in a future PR. However, we may need to revisit the RESTful API design, especially if users want to use the API directly.

Additional Context

• Issue reported by @hoophalab
• Not related to PR fix(webui): Log Presto cancel route output as object instead of string. #1191 (which addresses logging format in the cancel route)
• Affects WebUI search functionality

References

• Original discussion: fix(webui): Log Presto cancel route output as object instead of string. #1191 (comment)
• Related PR: fix(webui): Log Presto cancel route output as object instead of string. #1191

[hoophalab]

duplicate