Bug #46050 Condition Pushdown for ha_partition
Submitted: 8 Jul 2009 17:44 Modified: 17 Aug 2009 9:42
Reporter: kentoku shiba Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Partitions Severity:S4 (Feature request)
Version:5.1.36 OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: condition pushdown, Contribution, partition
Triage: Needs Triage: D5 (Feature request)

[8 Jul 2009 17:44] kentoku shiba
I created a patch file of Condition Pushdown for ha_partition.

This file is a patch file for MySQL's table partitioning feature.(ndb is excluded)
This patch file works to add methods("cond_push" and "cond_pop") to ha_partition. As a result, every storage engine's table that use table partitioning can get condition-pushdown through ha_partition.

There was no problem because only ndb supported engine-condition-pushdown up to now.
This patch was needed because the Spider storage engine supported engine-condition-pushdown recently.

How to repeat:

Suggested fix:
[8 Jul 2009 21:25] Sergei Golubchik
In order for us to continue the process of reviewing your contribution to MySQL we need you to review and sign the Sun|MySQL contributor agreement (the "SCA")

The process is explained here:

Getting a signed/approved SCA on file will help us facilitate your contribution -- this one, and others in the future.

Thank you !
[10 Jul 2009 12:37] kentoku shiba
Patch file for adding methods("cond_push" and "cond_pop") to ha_partition

Attachment: mysql-5.1.36.partition_cond_push.diff (text/plain), 2.17 KiB.

[13 Jul 2009 11:23] kentoku shiba
DO NOT contribute the code under these url "http://launchpad.net/partitionconditionpushdownformysql", only the patch file "mysql-5.1.36.partition_cond_push.diff" is contributed.
[17 Aug 2009 9:42] Susanne Ebrecht
Many thanks for sending a patch. We will check this.