Bug #51687 feature request for MySQL support of multiple clustering indexes - part II
Submitted: 3 Mar 2010 10:58 Modified: 3 Mar 2010 12:09
Reporter: Jonas Oreland Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Storage Engine API Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[3 Mar 2010 10:58] Jonas Oreland 
Description:
Hi,

As a child bug to http://bugs.mysql.com/45458 here comes a patch
that introduces a new index-flag which lets a SE inform optimizer
that an index can be considered clustered, and a change to optimizer
so that it will use it for order/group by on "equal" terms with a
clustered primary key index.

How to repeat:
This is a feature request to allow storage engines to support multiple clustering
indexes.

Suggested fix:
I will submit a patch
[3 Mar 2010 10:59] Jonas Oreland 
Patch for 5.1.41

Attachment: HA_CLUSTERED_INDEX (application/octet-stream, text), 1.66 KiB.
[26 Mar 2010 19:48] Zardosht Kasheff 
Other places that need to be modified to take into account clustering keys:
MySQL bug #39653
MySQL bug #50843
function get_best_ror_intersect needs to exclude clustering keys

There may be more. I am in the progress of tracking them down