MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Constant, random or timezone-dependent expressions in (sub)partitioning
8686
Carlo Rossetti
September 18, 2011 02:39AM
Re: Constant, random or timezone-dependent expressions in (sub)partitioning
3302
Mattias Jonsson
September 19, 2011 09:17AM
Re: Constant, random or timezone-dependent expressions in (sub)partitioning
2255
Carlo Rossetti
September 19, 2011 10:40AM


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.