Bug #35908 NDBAPI : Old API ordered Index scan on secondary index not ordered
Submitted: 8 Apr 19:21 Modified: 9 Jul 10:55
Reporter: Frazer Clement
Status: Closed
Category:Server: NDBAPI Severity:S1 (Critical)
Version:5.1-telco-6.3+ OS:Any
Assigned to: Frazer Clement Target Version:CGE-6.3
Triage: D2 (Serious)

[8 Apr 19:21] Frazer Clement 
Description:
Ordered index scan using old api should return tuples in-order, but it can return tuples
out of order. 

How to repeat:
Run testOIBasic with fix to bug 35876.

Ordered scan on a secondary index fails verifyOrdering() check.

Suggested fix:
Ensure correct info is requested from kernel to perform merge sort in API.
[9 Apr 0:19] 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/45091

ChangeSet@1.2544, 2008-04-08 23:18:05+01:00, frazer@forth.ndb.mysql.com +1 -0
  Bug #35908 : Ordered index scan should return tuples in order
  
  Retrieve indexed columns by using column mask from index table, not from base table.
[9 Apr 1:38] Frazer Clement 
Pushed to mysql-5.1-telco-6.2-merge, mysql-5.1-telco-6.3.
[12 Apr 18:57] Jon Stephens 
Documented in the 5.1.24-ndb-6.3.13 changelog as follows:

        Some ordered index scans could return tuples out of order.

Left in Patch Pending status, pending additional merges.
[9 Jul 10:55] Jon Stephens 
Since this is marked telco-6.3+, there appears to be no need for additional documentation.
Closed.