MySQL Forums
Forum List  »  Partitioning

Re: Cannot create partition with ASCII function.
Posted by: Phil Hildebrand
Date: May 02, 2008 10:39AM

There are only a few functions currently you can use with partitioning:

http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations-functions.html

ASCII isn't on the list.

In your case (depending on the complexity of the project), it might make more sense to break out the Job Code to another table so you end up with a job_id (integer) in the employee table that logically references the new job_code_type table or something, then you could do it.

Depending on your queries as well, it might make sense to partition employee's on store_id instead of job_code (depending on your reason for wanting to partition on job_code)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Cannot create partition with ASCII function.
3083
May 02, 2008 10:39AM


Sorry, you can't reply to this topic. It has been closed.

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.