Hi,
It's not allowed to use select statement in the partition function.
The partition function one should strive to keep fairly short since it
is used in every single record insert, update, delete and it is also
heavily used in partition pruning.
Rgrds Mikael
Eduardo Garcia Wrote:
-------------------------------------------------------
> Sorry
>
> i'm use Linear Hast don't Hash
>
> DROP TABLE IF EXISTS `Sid`;
> CREATE TABLE `Sid` (
> `sid_id` int(11) NOT NULL auto_increment,
> `sid` varchar(255) NOT NULL default '',
> `keyword_id` int(11) NOT NULL default '0',
> `creative_id` int(11) NOT NULL default '0',
> `sid2` varchar(255) NOT NULL default '',
> `max_bid_cpc` double(5,2) unsigned NOT NULL
> default '0.00',
> `min_cpc` double(5,2) unsigned NOT NULL default
> '0.00',
> `parent_id` int(11) NOT NULL default '0',
> `bid_percentage` double(5,2) NOT NULL default
> '1.00',
> `status` varchar(50) NOT NULL default 'active',
> PRIMARY KEY (`sid_id`),
> KEY `keyword_id` (`keyword_id`),
> KEY `creative_id` (`creative_id`),
> KEY `sid2` (`sid2`),
> KEY `sid` (`sid`),
> KEY `parent_id` (`parent_id`)
> )
> PARTITION BY LINEAR HASH(
> Get_Client_Creative(`creative_id`) )
> PARTITIONS 50;
>
> ----
>
> enzo
Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:
http://mikaelronstrom.blogspot.com