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
• Status: Closed
• 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.