Bug #36950 smart scan (ndbapi partition pruning) broken
Submitted: 26 May 2008 9:17 Modified: 28 May 2008 8:34
Reporter: Jonas Oreland Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: NDB API Severity:S3 (Non-critical)
Version:>= telco-6.2 OS:Any
Assigned to: Jonas Oreland CPU Architecture:Any

[26 May 2008 9:17] Jonas Oreland
Description:
ndbapi does internally prune an ordered index scan where partition key
is specified with EQ-bound (currently only if 1 bound)

somewhere in NdbRecord work, this got broken

How to repeat:
.

Suggested fix:
.
[26 May 2008 9:22] 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/47041

ChangeSet@1.2603, 2008-05-26 11:22:39+02:00, jonas@perch.ndb.mysql.com +1 -0
  ndb - bug#36950
    make sure to propaget pruning values to signal
    (as bounds are processed after signal is otherwise prepared)
[26 May 2008 16:41] 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/47060

ChangeSet@1.2604, 2008-05-26 18:41:15+02:00, jonas@perch.ndb.mysql.com +1 -0
  ndb - bug#36950
    handle mysql-style index varsize-keys (2 bytes len regardless of datatype)
    reuse tmp buffer and silently fail (dont prune) when running out of buffer
[27 May 2008 11: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/47078

ChangeSet@1.2605, 2008-05-27 13:48:47+02:00, jonas@perch.ndb.mysql.com +1 -0
  ndb - bug#36950 - patch 3
    arg...bug in fix of long varsize keys (when datatype is short-varchar)
[27 May 2008 19:42] 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/47107

ChangeSet@1.2607, 2008-05-27 21:43:02+02:00, jonas@perch.ndb.mysql.com +1 -0
  ndb - bug#36950
    fix testcase, (autotest doesnt use debug-compile)
[27 May 2008 19:58] Bugs System
Pushed into 5.1.23-ndb-6.4.0
[27 May 2008 20:00] Bugs System
Pushed into 5.1.24-ndb-6.3.15
[27 May 2008 20:01] Bugs System
Pushed into 5.1.24-ndb-6.2.16
[28 May 2008 8:34] Jon Stephens
Documetned fix in the NDB 6.2.16 and NDB 6.3.15 changelogs.

Changed bug category to Cluster APIs.

Closed.
[12 Dec 2008 23:29] Bugs System
Pushed into 6.0.6-alpha  (revid:sp1r-jonas@perch.ndb.mysql.com-20080527194302-22144) (version source revid:jonas@mysql.com-20080808094047-4e1yiarqa2t3opg3) (pib:5)