Bug #29550 EXPLAIN PARTITIONS report wrong partition on PARTITION BY KEY with MySQL Cluster
Submitted: 4 Jul 2007 14:21 Modified: 23 Nov 2007 9:22
Reporter: Mikael Ronström Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Mikael Ronström CPU Architecture:Any

[4 Jul 2007 14:21] Mikael Ronström
Description:
EXPLAIN PARTITIONS SELECT * from t WHERE pk = 1;

This will report the partition according to the standard MySQL hash function and
not according to the hash function used in the NDB storage engine

How to repeat:
EXPLAIN PARTITIONS SELECT * from t WHERE pk = 1;

Suggested fix:
Make calculate_key_hash_value a handler function
[8 Sep 2007 20:04] Mikael Ronström
Pushed into telco 6.2.6
[11 Sep 2007 11:02] Jon Stephens
Documented bugfix in mysql-5.1.22-ndb-6.2.6 changelog.

No changeset listed - will this also be pushed to 5.1-telco and/or 5.1-main?
[22 Nov 2007 13:32] Mikael Ronström
Fixed in Telco 6.2, 6.3 and MySQL 6.0 but not in 5.1
[23 Nov 2007 9:22] Jon Stephens
Also documented for 5.1.22-ndb-6.3.7 and 6.0.4. Closed.