MySQL Forums
Forum List  »  Partitioning

Re: Constant, random or timezone-dependent expressions in (sub)partitioning
Posted by: Mattias Jonsson
Date: September 19, 2011 09:17AM

Hi Carlo,

CAST() is not an allowed partitioning function since it is not guaranteed to be deterministic due to changes in the SQL_MODE variable.

If you really want to use numbers as strings, I would suggest you to either use KEY partitioning which will hash any column type, or look further into COLUMNS partitioning.

Regards
Mattias Jonsson

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Constant, random or timezone-dependent expressions in (sub)partitioning
2550
September 19, 2011 09:17AM


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.