Bug #38791 NDBAPI : Multi-range (MRR) Index scans no longer supported in old Api
Submitted: 14 Aug 2008 12:16 Modified: 5 Oct 2008 18:53
Reporter: Frazer Clement
Status: Closed
Category:Server: NDBAPI Severity:S4 (Feature request)
Version:mysql-5.1-telco-6.3 OS:Any
Assigned to: Frazer Clement Target Version:
Triage: Needs Triage: D5 (Feature request)

[14 Aug 2008 12: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 14: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 14: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 17: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 17: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 11: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 18:53] Jon Stephens 
Already documented as noted above; closing this bug.