MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: range columns including datetime column
Posted by: Mattias Jonsson
Date: August 16, 2012 02:42AM

I have tested your table and finds no problem.

My guess is that you use period = 4 or period = 5 and expect it to be inserted in p45_1206 or higher.

The partitioning scheme you have will only have period = 6 and START between '2012-06-01 00:00:00' and '2012-06-31 23:59:59' in p45_1206.

There are further examples and explanations here:
http://dev.mysql.com/doc/refman/5.5/en/partitioning-columns-range.html

If you switch the order of period and START, you will first order by date and then by period.

Regards
Mattias Jonsson, MySQL Partitioning developer

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


Subject
Views
Written By
Posted
range columns including datetime column
2801
Rob Voyer
August 15, 2012 10:01PM
Re: range columns including datetime column
1567
Mattias Jonsson
August 16, 2012 02:42AM
Re: range columns including datetime column
1502
Rob Voyer
August 16, 2012 07:15AM
Re: range columns including datetime column
1493
Mattias Jonsson
August 16, 2012 09:35AM
Re: range columns including datetime column
1440
Rob Voyer
August 16, 2012 09:54AM
Re: range columns including datetime column
1538
Rick James
August 19, 2012 10:55PM
Re: range columns including datetime column
1405
Mattias Jonsson
August 20, 2012 03:21AM


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.