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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.