Re: partition by range on decimal type

[Greg K]

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 |
...