Partitioning Mariadb small error on https://mariadb.com/kb/en/range-partitioning-type/

Question

Please correct me but I've located a small error on the Mariadb documentation on https://mariadb.com/kb/en/range-partitioning-type/

The second example under Use cases has a superfluous UNIX_TIMESTAMP in the PARTION BY RANGE line. As the column timestamp already is a unix timestamp UNIX_TIMESTAMP(timestamp) will not work, will it? The line should read

 PARTITION BY RANGE( TimeStamp )

Not sure how to get in touch with the ppl. that write the manual.

You could try the "contact" link at the bottom of that page. — Gerald Schneider, Apr 22 '20 at 13:39
I’m voting to close this question because it's not a question that can be answered. — Gerald Schneider, Apr 22 '20 at 13:39

score 2 · Answer 1 · answered Apr 22 '20 at 20:09

2

No, you are wrong. Check the documentation: https://mariadb.com/kb/en/timestamp/

This is a TIMESTAMP:

A timestamp in the format YYYY-MM-DD HH:MM:SS.ffffff.

This is UNIX_TIMESTAMP:

1374490205

answered Apr 22 '20 at 20:09

Swisstone

6,725
7
22
32

Yeah, the column names in those examples are confusing. – Rick James Apr 23 '20 at 01:02
My mistake, Thanks for checking on me, Swisstone. – theking2 Apr 29 '20 at 16:14

Partitioning Mariadb small error on https://mariadb.com/kb/en/range-partitioning-type/

1 Answers1