Bug #38791 NDBAPI : Multi-range (MRR) Index scans no longer supported in old Api
Submitted: 14 Aug 2008 10:16 Modified: 5 Oct 2008 16:53
Reporter: Frazer Clement Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: NDB API Severity:S4 (Feature request)
Version:mysql-5.1-telco-6.3 OS:Any
Assigned to: Frazer Clement CPU Architecture:Any

[14 Aug 2008 10:16] Frazer Clement
Description:
WL 4052 NdbRecord Modifications removed support for multi range index scans from the old Api.  The multi range scans remained supported via the NdbRecord Api.

This is a feature request to re-implement the MRR functionality for the old scan API.

How to repeat:
Attempt to use MRR facilities (NdbIndexScanOperation::setBound(), NdbIndexScanOperation::end_of_bound()) for old Api.

Suggested fix:
Re-implement functionality
[14 Aug 2008 12:11] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/51629
[14 Aug 2008 12:23] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/51631
[14 Aug 2008 15:47] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/51645
[14 Aug 2008 15:48] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/51646
[12 Sep 2008 9:29] Jon Stephens
Documented in the NDB 6.3.17 changelog as follows:

        Support for multi-range index scans using the old API (using, for
        example, NdbIndexScanOperation::setBound() or
        NdbIndexScanOperation::end_of_bound())) were dropped in MySQL Cluster
        NDB 6.2. This functionality is restored in MySQL Cluster NDB 6.3
        beginning with 6.3.17, but remains unavailable in MySQL Cluster NDB  
        6.2. Both MySQL Cluster NDB 6.2 and 6.3 support multi-range scans via 
        the NdbRecord API.

Also noted change in the API docs for NdbScanOperation.
[5 Oct 2008 16:53] Jon Stephens
Already documented as noted above; closing this bug.