MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: Problem creating partioned table on Unix but workingon windows
Posted by: Mattias Jonsson
Date: January 22, 2009 01:47PM

I think that unix_timestamp was removed as a partitioning function sometime around 5.1.21 with the fix for bug#18198 (http://bugs.mysql.com/bug.php?id=18198).

Since unix_timestamp only is 32-bit, and partitioning functions must handle 64-bit integers.

So that's why it works on windows (5.1.11-beta), but not on unix (5.1.30)

You could look into the WL#3352 tree at launchpad which adds TO_SECONDS and partition by COLUMN_LIST:
https://code.launchpad.net/~mikael-ronstrom/mysql-server/mysql-5.1-wl3352

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


Subject
Views
Written By
Posted
Problem creating partioned table on Unix but workingon windows
4519
Jonas Nylund
January 20, 2009 09:24AM
Re: Problem creating partioned table on Unix but workingon windows
2361
Mattias Jonsson
January 22, 2009 01:47PM


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.