MySQL Forums
Forum List  »  Partitioning

Re: partition by range on decimal type
Posted by: Greg K
Date: November 23, 2012 12:45AM

hard to disagree with you.

one more question - how about "partition by key" ? which doesn't require to return integer, e.g.:
alter table test.bts_hour
partition by key(starttime)
partitions 20;

should it work somehow or never on decimal column?

now it gave me NULLs

partition_name part, partition_expression expr, partition_description val, partition_method meth, table_rows
+------+-----------+------+------+------------+
| part | expr | val | meth | table_rows |
+------+-----------+------+------+------------+
| p0 | starttime | NULL | KEY | 338459 |
| p1 | starttime | NULL | KEY | 320777 |
| p2 | starttime | NULL | KEY | 340764 |
...

Options: ReplyQuote


Subject
Views
Written By
Posted
5645
November 20, 2012 07:15AM
2336
November 21, 2012 10:39AM
1822
November 22, 2012 02:26AM
1934
November 22, 2012 11:02PM
Re: partition by range on decimal type
1945
November 23, 2012 12:45AM
2108
November 23, 2012 09:03PM


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.