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

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

Issue Links:

 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:

   RETURNS (cnt INT)
   cnt = 0;
   WHILE (cnt < 5000000) DO
     cnt = cnt + 1;

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