Issue Details (XML | Word | Printable)

Key: CORE-1441
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Dmitry Yemanov
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Query cancellation feature cannot interrupt a long fetch

Created: 05/Sep/07 03:05 AM   Updated: 29/Dec/07 05:44 AM
Component/s: Engine
Affects Version/s: 2.1 Beta 1
Fix Version/s: 2.1 Beta 2

Time Tracking:
Not Specified

Issue Links:
Relate
 


 Description  « Hide
If an active transaction performs a long fetch (e.g. "fetch-all" of more than 1M rows) from a trivial data source (table or simple stored procedure) the query cancellation does not affect that activity, thus allowing all records to be successfully fetched.

Sample of the query not affected by the cancellation:

EXECUTE BLOCK
   RETURNS (cnt INT)
AS
BEGIN
   cnt = 0;
   WHILE (cnt < 5000000) DO
   BEGIN
     cnt = cnt + 1;
     SUSPEND;
   END
END

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.